How do I make a static budget given the following data?
AutoSave ON svo F20 - Budget Assignment - Student - v3 - Saved Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share o Comments ? AL A Define Name V Dfx V Calculate Now E Trace Precedents , Sa Trace Dependents Remove Arrows v le Date & Lookup & Math & Time Reference Trig Text Insert Function AutoSum Recently Financial Logical Used More Functions Create from Selection Show Error Watch Formulas Checking Window Calculation Calculate Sheet Options B6 fx =2800+100 A B C D E F G H I J L 1 Parameters - budget Parameters - actual 2 Quarters 3 1 2 4 Year 1 4,160 2,900 1,260 5,060 3,530 1,530 4,460 3,110 1,350 5,360 3,740 1,620 19,040 13,280 5,760 Sales ( hours): Actual total sales Actual sales - commercial Actual sales - residential Selling price ( $/hr): Actual selling price - commercial Actual selling price - residential 4,020 2,810 1,210 3 $ $ 37 $ 48 $ 37 $ 48 $ $ 37 $ 48 $ 37 $ 48 $ 37 48 $40 $50 $ 20 $ 20 $ 20 $ 20 Direct labour expense ( $/hr): $ 18 $ 0.2 0.2 0.1 0.2 0.1 0.2 0.1 Actual Cleaning Supply usage ( litre / labour hour): Commercial Residential 0.19 0.09 0.1 3 4 Sales ( hours): 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours 8 Selling price ( $/hr): 9 Selling price per hour (commercial) 10 Selling price per hour (residential) 11 12 Direct labour expense ( $/hr): 13 14 Cleaning Supply usage ( litre / labour hour): 15 Commercial 16 Residential 17 18 Cleaning Supply expense ($/litre)): 19 20 Fixed overhead: 21 Receptionist 22 Depreciation 23 Gas 24 Office Supplies 25 26 27 28 29 30 31 32 $ 5.50 $ 5.50 $ 5.50 $ 5.50 Actual Cleaning Supply expense ( $/litre)): $ 5.40 $ 6,363 9,225 7,650 1,075 5 9 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 25,450 36,900 30,600 4,300 6,010 9,225 7,300 990 20,735 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,119 1,343 4,462 80,320 5 104 Cover page Read this first Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric Ready 13 P + 133% SUPER CLEAN Operating Budget for the period Jan-Dec '18 Quarters 3 1 2 4 Year Marks N Sales budget Sales Commercial Sales residential Total sales $2,900 $1,260 $4,160 $3,530 $1,530 $5,060 $3,110 $1,350 $4,460 $3,740 $1,620 $5,360 $13,280 $5,760 $19,040 2 Direct material budget Variable costs commercial Variable costs residential Total variable costs N Labour budget Commercial Residential Total labour 2 Fixed Overhead: Receptionist Depreciation Gas Office Supplies Total Total 8
