Please provide the answers with detailed formula. Please do provide the cell reference from where the numbers will be derived for better understanding.Thanks !

Question:-

Part A

Insert Delete Format B 1 Merge & Center - $ - % Clear a copy Paste Format Painter Clipboard Conditional Format Cell Formatting as Table - Styles Styles Sort & Find a Filter - Select Editing Font Alignment Number Cells 02 G H 1 1 M F N O Parameters - actual Quarters 2 1 Year 4 3 Year 18,400 12,880 5,520 Sales ( hours): Actual total sales Actual sales - commercial Actual sales - residential Selling price ( S/hr): Actual selling price-commercial Actual sellling price - residential 3,800 2,660 1,140 5,000 3,500 1,500 3,900 2,730 1,170 5,100 3,570 1.530 17,800 12,460 5,340 $40 $50 $40 $50 $40 $50 $40 $50 540 S50 540 $50 Direct labour expense (S/hr): s 18 S 18 S 18 5 18 B C D E E 1 Parameters - budget 2 Quarters 3 1 2 3 4 4 Sales (hours): 5 Budgeted total sales in hours 4,000 4,900 4,300 5,200 6 Budgeted commercial sales in hours 2,800 3,430 3,010 3,640 7 Budgeted residential sales in hours 1,200 1,470 1,290 1,560 8 Selling price ( S/hr): 9 Selling price per hour (commercial) $40 $40 $40 $40 10 Selling price per hour (residential) $50 $50 $50 $50 11 12 Direct labour expense (S/hr): S 20 S 205 20 S 20 13 14 Cleaning Supply usage (litre / labour hour): 15 Commercial 0.2 0.2 0.2 02 16 Residential 0.1 0.1 0.1 0.1 17 18 Cleaning Supply expense (S/litre)); $ 5.50 $ 5.50 $ 5.50 $ 5.50 19 20 Fixed overhead: 21 Receptionist 6,250 6,250 6,250 6,250 22 Depreciation 9,375 9,375 9,375 9,375 23 Gas 7,500 7,500 7,500 7,500 24 Office Supplies 1,000 1,000 1,000 1,000 25 26 Actual Cleaning Supply usage (litre / labour hour): Commercial Residential 0.19 0.09 0.19 0.09 0.19 0.09 0.19 0.09 Actual Cleaning Supply expense (S/litre)); S 5.6 5 5.6 S 5.6 S 5.6 25,000 37,500 30,000 4,000 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6,000 9,375 7,200 950 5,750 9,375 7.800 1,100 5,900 9,375 7,100 1,050 6,300 9,375 7,000 1,000 23,950 37,500 29,100 4,100 21,360 28 29 30 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,192 1,368 4,560 82,080 4,200 1,800 6,000 3,276 1,404 4,680 84,240 4 284 14,952 1,836 6,408 6,120 21,350 110,160 384,480 108,000 32 38 Unproductive (unbilled ) factor 2096 20% 20% 2095 2095 A B C D E F 1 SUPER CLEAN Flexible budget for the period Jan - Dec '18 Quarters 600 ou +wn 1 2 3 4 Year 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 11 12 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs 17 18 19 Labour budget 20 Commercial 21 Residential 22 Total labour 23 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total 30