Use the spreadsheet extract to answer the questions1ABMaterials budgets: 50mm x 20mm pineCDEF2345Usage budgetSeptemberOctober NovemberTotalunitsunitsunitsunits67Production of tables25028029082089metres10Raw material usage625metres700metres725metres?111213Purchases budgetmetresmetresmetresmetres14Production usage625700725?15Add: closing stock282930?16Less: opening stock(25)(28)(29)?17Purchases62870172620551819$$2021Raw material purchases5903.206589.406824.4019317.00222324Raw materials data25Usage per unit of production (metres)2.526Purchase price per metre ($)9.40272829Assumptions1 The closing stock in one month is 4% of the following month's production requirement302 From December onwards production of tables will plateau at 290RequiredWhich of the following cells require the input of an actual value rather thanformula relating to another cell on the spreadsheet? B15Suggest a formula for the following:D17; D10 or =D7*B25The total column has yet to be completed. Match up the cells below with theappropriate formulae in order to complete this column.E15: =SUM(B16:D16) →E10: =B16

Budgeting refers to the process of preparing a plan that accounts for all the cash receipts and…

Use the spreadsheet extract to answer the questions 1 A B Materials budgets: 50mm x 20mm pine C D E F 2 3 September October November Total 4 5 Usage budget units units units units 6 7 Production of tables 250 280 290 820 8 9 metres 10 Raw material usage 625 metres 700 metres metres 725 ? 11 12 13 Purchases budget metres metres metres metres 14 Production usage 625 700 725 ? 15 Add: closing stock 28 29 30 ? 16 Less: opening stock (25) (28) (29) ? 17 Purchases 628 701 726 2055 18 19 $ $ $ $ 20 21 Raw material purchases 5903.20 6589.40 6824.40 19317.00 22 23 24 Raw materials data 25 Usage per unit of production (metres) 2.5 222 Purchase price per metre ($) 9.40 29 30 Assumptions 1 The closing stock in one month is 4% of the following month's production requirement 2 From December onwards production of tables will plateau at 290 Required Which of the following cells require the input of an actual value rather than a formula relating to another cell on the spreadsheet? B15 Suggest a formula for the following: D17; D10 or =D7*B25 ÷ The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E15: =SUM(B16:D16) E10: =B16

Use the spreadsheet extract to answer the questions 1 A B Materials budgets: 50mm x 20mm pine C D E F 2 3 September October November Total 4 5 Usage budget units units units units 6 7 Production of tables 250 280 290 820 8 9 metres 10 Raw material usage 625 metres 700 metres metres 725 ? 11 12 13 Purchases budget metres metres metres metres 14 Production usage 625 700 725 ? 15 Add: closing stock 28 29 30 ? 16 Less: opening stock (25) (28) (29) ? 17 Purchases 628 701 726 2055 18 19 $ $ $ $ 20 21 Raw material purchases 5903.20 6589.40 6824.40 19317.00 22 23 24 Raw materials data 25 Usage per unit of production (metres) 2.5 222 Purchase price per metre ($) 9.40 29 30 Assumptions 1 The closing stock in one month is 4% of the following month's production requirement 2 From December onwards production of tables will plateau at 290 Required Which of the following cells require the input of an actual value rather than a formula relating to another cell on the spreadsheet? B15 Suggest a formula for the following: D17; D10 or =D7*B25 ÷ The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E15: =SUM(B16:D16) E10: =B16

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Help Save & Exit AA company provided the following information from its flexible budget performance report: Actual Results 52 Flexible Budget Master Budget Trips (q) 2. Expenses: Maintenance expense ($4,000 + $88.00g) $8,440 $8,400 What is the spending variance for maintenance expense? Multiple Choice $136 F $136 U $176 U Nex 11 of 23 < Prev
Please do not give solution in image format thanku
8
answer in text form please (without image), Note: .Every entry should have narration please
Do not give answer in image formate
Question 6 View Policies Current Attempt in Progress Crane Company determines that 59000 pounds of direct materials are needed for production in July. There are 3700 pounds of direct materials on hand at July 1 and the desired ending inventory is 3300 pounds. If the cost per unit of direct materials is $3, what is the budgeted total cost of direct materials purchases? ort $175800 O $180600. O $178200. O $173400. ea Chp ins prt sc fho 12 home delete % 5 & 7 backspace lock T P hom G H K enter B pause t shift ctri NM N
Mailings Review View Help Tell me what you want to do AB-T A. G II M Paragraph 5 Styles Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: cost formulas Direct labor AaBbCcDd AaBbCcDd AaBbC AaBbCct AaB AaBbCcD AaBbCcDd Ac 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... E $16.20q Indirect labor $4,600+ $1.50q Utilities $5,200 + $0.40q Supplies Equipment depreciation Factory rent $8,400 Property taxes $2,800 Factory administration $13,300 + $0.60q The Production Department planned to work 4,000 labor-hours in March; however, it actually worked 3,800 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor $ 63,120 Indirect labor $9,780…
Required information SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 520 sun shades in May and 340 in June. Each shade sells for $149. Shadee's beginning and ending finished goods inventories for May are 75 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. E8-7 (Algo) Preparing Direct Labor and Manufacturing Overhead Budgets [LO 8-3d] Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $12 per hour. Additionally, Shadee's fixed manufacturing overhead is $11,000 per month, and variable manufacturing overhead is $14 per unit produced. Required: 1. Prepare Shadee's direct labor budget for May and June. 2. Prepare Shadee's manufacturing overhead budget for May and June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare Shadee's manufacturing overhead budget for May and June. May…
The fixed budget for 20,600 units of production shows sales of $473,800; variable costs of $61,800; and fixed costs of $141,000. If the company actually produces and sells 26,700 units, calculate the flexible budget income.
Please do not give solution in image format thanku
ine teacnl akeAssignment/takeAssignmentMain.do?invoker%3&takeAssignmentSessionLocator=&inprogress=false Sales and Production Budgets Ultimate Audio Company manufactures two models of speakers, U500 and S1000. Based on the following production and sales data for June. U500 S1000 Estimated inventory (units), June 1 262 71 Desired inventory (units), June 30 301 62 Expected sales volume (units): Northeast Region 2,950 3,300 Southwest Region 5,650 4,900 Unit sales price $135 $215 a. Prepare a sales budget. Enter all amounts as positive numbers. ULTIMATE AUDIO COMPANY Sales Budget For the Month Ending June 30 Product and Area Unit Sales Volume Unit Sales Price Total Sales Model U500: Northeast Region Southwest Region Total Next Check My Work Sign out マ012:1 女