Please help with the answers and kindly update the formulas used for better understanding
Parameters - actual Quarters 2 3 4 Year 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 $40 $50 Direct labour expense ( S/hr): $ 18 $ 18 $ 18 $ 18 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 ( $/litre)): $ 5.6 $ 5.6 S 5.6 S 5.6 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 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 108,000 3,276 1,404 4,680 84,240 4,284 14,952 1,836 6,408 6,120 21,360 110.160 384,480 Unproductive ( unbilled ) factor 20% 20% 20% 2098 20% 2 3 4 Year Sales budget Sales Commercial Sales residential Total sales Direct material budget Variable costs commercial Variable costs residential Total variable costs Labour budget Commercial Residential Total labour Fixed Overhead: Receptionist Depreciation Gas Office Supplies Total Total Parameters - actual Quarters 2 3 4 Year 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 $40 $50 Direct labour expense ( S/hr): $ 18 $ 18 $ 18 $ 18 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 ( $/litre)): $ 5.6 $ 5.6 S 5.6 S 5.6 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 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 108,000 3,276 1,404 4,680 84,240 4,284 14,952 1,836 6,408 6,120 21,360 110.160 384,480 Unproductive ( unbilled ) factor 20% 20% 20% 2098 20% 2 3 4 Year Sales budget Sales Commercial Sales residential Total sales Direct material budget Variable costs commercial Variable costs residential Total variable costs Labour budget Commercial Residential Total labour Fixed Overhead: Receptionist Depreciation Gas Office Supplies Total Total
