Please calculate Flexible Budget , La

K29 C E F G Parameters - budget M N Parameters - actual Quarters 2 3 Quarters Year 4 Sales [ hours) Year 5 Budgeted total sales in hours Sales ( hours): 4,000 4,900 4,300 5,200 18,400 Actual total sales 6 Budgeted commercial sales in hours 3,800 2,800 5,000 3,430 3,900 3,010 5,100 3,640 12,880 17,800 Actual sales -commercial 7 Budgeted residential sales in hours 1.200 2,660 1.470 3,500 1,290 2.730 1,560 5.520 3,570 12,460 Actual sales - residential U Selling price ( 5/hi): 1,140 1,500 1.170 1.530 5,340 9 selling price per hour (commercial) Selling price ( 5/hr): $40 $40 $40 $40 Actual selling price - commercial 10 Selling price per hour (residential) 540 San 550 $50 SAD $50 $50 Actual sellling price - residential $50 $50 IT $50 12 Direct labour expense ( $/hr): S 20 $ 20 S 20 5 20 Direct labour expense ( $/hr): S 18 $ 13 115 5 18 14 Cleaning Supply usage ( litre / labour hour 15 Commercial Actual Cleaning Supply usage ( litre / labour hour): 0.2 0.2 0.2 0.2 Commercial 0.19 0.19 0.19 16 Residential 0.19 0.1 Residential 0.09 0.09 0.09 17 0.03 18 Cleaning Supply expense ( $/litre]): S 5.50 $ 5.50 $ 5.50 5 5.50 5.6 9 9.0 5 19 Actual Cleaning Supply expense ( S/litre)): 5.6 5. 5.6 20 Fixed overhead: Actual Fixed overhead: 21 Receptionist 6,250 6,250 6,250 6.250 25,000 Receptionist 6,000 5,750 5,900 6,300 23,950 22 Depreciation 9,375 9,375 9,375 9,375 37,500 Depreciation 9,375 9.375 9,375 9,375 37,500 23 Gas 7,500 7,500 7,500 7.500 30,000 Gas 7,200 7,HOO 7,100 7,000 29,100 24 Office Supplies 1,000 1,000 1,000 1,000 4,000 Office Supplies 950 1, 100 1,050 1,000 4,100 25 26 Total no. of hours actually paid to employees 21,360 27 Breakdown: 28 Commercial 3,192 4,200 3,276 4,284 14,952 29 Residential 1,368 1,800 1,404 1,836 6,408 30 Actual hours worked 4,560 6,000 4,680 6,120 21,360 31 Direct labour cost 82,080 1,08,000 84,240 1,10,160 3.84,480 32 3a Unproductive ( unbilled ) factor 20% 20% 20% 2016 35 Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric