Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please provide detailed explanation with formulas used to calculate the answers First 2 pictures are for data given and third picture is for what is
please provide detailed explanation with formulas used to calculate the answers
C D E B Parameters - budget Quarters 3 1 2 4 Year 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 (S/hr): 9 Selling price per hour (commercial) 10 Selling price per hour (residential) 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 37 S 48 S 37 $ 48 $ 37 $ 48 $ 37 $ 48 $ 37 48 23 23 23 23 2 Direct labour expense (S/hr): 3 14 Cleaning Supply usage ( litre / labour hour): 15 Commercial 16 Residential 0.25 0.15 0.25 0.15 0.25 0.15 0.25 0.15 5.50 $ 5.50 $ 5.50 $ 5.50 18 Cleaning Supply expense (S/litre)): 19 20 Fixed overhead: 21 Receptionist 22 Depreciation 23 Gas 04 Office Supplies 25 26 27 28 6,500 9,125 7,625 1,125 6,500 9,125 7,625 1,125 6,500 9,125 7,625 1,125 6,500 9,125 7,625 1,125 26,000 36,500 30,500 4,500 Parameters - actual Quarters 2 1 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 4,020 2,810 1,210 5,220 3,650 1,570 4,120 2,880 1,240 5,320 3,720 1,600 18,680 13,060 5,620 $ 41 41 S 47 $ 41 S 47 $ 41 S 47 $ 41 $ 475 47 Direct labour expense S/hr): 22 22 22 22 0.22 0.11 0.22 0.11 0.22 0.11 0.22 0.11 5 5 5 5 Actual Cleaning Supply usage ( litre / labour hour): Commercial Residential Actual Cleaning Supply expenses/litre)); Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6,010 9,125 7,300 990 5,770 9,125 7,940 950 5,915 9,125 7,450 975 6,325 9,125 7,275 1,215 24,020 36,500 29,965 4,130 21,482 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,232 1,392 4,623 101,706 4,198 1,806 6,003 132,066 3,312 1.426 4,738 104,236 4,278 1,840 6,118 134,596 15,019 6,463 21,482 472,604 Unproductive unbilled) factor 15N 15% 15% 15% 15% Direct Materials - Commercial Actual Quantity-AQ Actual Rate -AR Actual Quantity -AQ Standard Rate -SR Standard Quantity - SQ Standard Rate - SR Price Variance Quantity Variance Total Variance Explanation for Quantity variance: Explanation for price variance: Direct Materials - Residential Actual Quantity-AQ Actual Rate -AR Actual Quantity-AQ Standard Rate -SR Standard Quantity - SQ Standard Rate - SR Price Variance Quantity Variance Total Variance First 2 pictures are for data given and third picture is for what is required to be calculated
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started