Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer as much as possible. it is quite tough to understand. D G Parameters - budget 1 Quarters 3 2 4 Year 4 260 3.000

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Answer as much as possible. it is quite tough to understand.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
D G Parameters - budget 1 Quarters 3 2 4 Year 4 260 3.000 1,260 4,860 3,330 1.530 4,500 3,110 1,390 5,460 3,840 1,620 19.080 13,280 5,800 Sales ho Actual to! Actual sa Actual sa Selling pe Actual se Actual se 37 s uso 37 S 48 S 48 $ 37 S 48 $ 37 $ 48 S 37 48 22 22 22 22 Direct lat 13 4 Sales (hours): 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours Budgeted residential sales in hours 8. Selling price ( S/hr): Selling price per hour (commercial) 10 Selling price per hour (residential) 31 12 Direct labour expense (S/hr): 13 14 cleaning Supply usage ( litre / labour hour): 15 Commercial 16. Residential 17 23 Cleaning Supply expense (S/litre)); 19 20 Fixed overhead: Receptionist 22 Depreciation 23 | Gas 24 Office Supplies 125 26 527 0.3 0.3 017 0.25 0.15 0.25 0.15 Actuala Commerc Residenti 0.17 $ 5.50 $ 5.50 $ 5.50 S 5.50 Actual Cla 6500 1275 7800 1200 6500 9600 7800 1200 6800 9600 7900 1350 7000 9600 7900 1350 26800 30075 31400 5100 Actual Reception Deprecia Gas Office Su 28 129 20 Total to Breakdov Commer Residenti Actual he Direct lal M N B 1 Parameters actual Quarters 2 1 4 Year Year 9,000 3,280 5800 4,500 2,810 1,210 5,220 3,650 1,570 4,700 2,880 1,240 Sales (hours: Actual total sales Actual sales - commercial Actual sales - residential Selling price S/hr): Actual selling price-commercial Actual selling price - residential 5,450 3,720 1,600 19,870 13,060 5.520 39 32 48 39 49 89 49 40 50 40 49 49 Direct labour expense { $/hr): 23 23 23 23 Actual Cleaning Supply usare (litre / labour hour): Commercial Residential 0.25 0.11 0.25 0.11 0.22 0.11 0.22 0.11 Actual Cleaning Supply expenses/litre): 5 5 5 5 26800 30075 31400 5100 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6,010 7,519 7,300 990 5,770 7,519 7,940 950 5,900 7,519 7,450 975 6,325 7,519 7,560 1,215 24,005 30,075 30,250 4,130 21,108 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,175 1,367 4,543 104,480 4,125 1,774 5,899 135.668 3,254 1,401 4,656 4,204 1,808 6,012 138,267 14,758 6,351 21,108 485,493 107,079 Unproductive (unbilled ) factor 13% 18% 1396 13% 13% 1 2. 3 SUPER CLEAN Operating Budget for the period Jan - Dec '18 Quarters 3 1 2 4 Year 5 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 71 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 + Cover page Read this first Assumptions Static Budget Actual Budget 1 2 SUPER CLEAN Operating Budget for the period Jan - Dec '18 3 4 Quarters 3 1 2 4 Year 5 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 31 32 33 34 35 Read this first otions Static Budget Actual Budget 2 3 SUPER CLEAN Operating results for the period Jan - Dec '18 4 Quarters 3 1 2 4 Year 5 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 1 2 3 Direct material budget 4 Variable costs commercial 5 Variable costs residential 6 Total variable costs 7 8 9 Labour budget o Commercial 1 Residential 2 Total labour 3 4 Fixed Overhead: 5 Receptionist 6 Depreciation 7 Gas Static Budget Actual Budge 1 SUPER CLEAN Operating results for the period Jan - Dec '18 2 3 Quarters 3 1 2 4 5 17 Year 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 31 32 33 34 35 36 37 Cover page Read this first Assumptions Static Budget Actual Budget PROIRIE VIEW Be carefullies liom the ernet can contain you need it is suter to stay in Protected enabled C12 X GI H D Super Clean Inc Static Budget Variance Actual for the year Static for the yea Variance U/E Flexible Budget Variance Actuall for the year Rexible for the year Variance UF 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 Fabour Fixed Overhead: Receptionist Depreciation Gas Office Supplies Total + H42 E o Direet Materials commercial 3 Atual Quantity20 Actual Rate AR Actual Quantity Standard Rates Standard Quantity Standard Flate. SB 15 16 T Ptice Variance Quantity Variance Total Variance to 11 12 Explanation for Quantity wariance: Direct Materials - Residential 16 Explanation for price variance: 16 17 18 15 20 21 22 Actual Quantity.AQ 23 Actual Rate -AR 24 25 26 Price Variance 27 Actual Quantity-AQ Standard Rate SR Standard Quantity SQ Standard Rate.SR Quantity Variance Total Variance 28 30 31 32 33 Explanation for Quantity variance: 34 35 36 Explanation for price variance 37 38 39 40 To 18 M A Labour Commercial Actual HOUDHAH Actual Rate HAR Actual Hours LAHI Standard Rite-SF Standard Hour LSH Standard Rate SR 6 Rate Variance Efficien Variance Total Variance 10 Explanation for Efficiency wariance: HE 117 Explanation for rate variange: 5 17 18 Labour - Residential 13 20 21 22 Actual Hours=AH 23 Actual Rate-AR 24 45 126 27 Actual Hours-AH Standard Rate-SR Standard Hours.-SH Standard Rate - SR Rate Variance Efficiency Vatsance Total Variance 28 29 Explanation for Efficiency wariance. Explanation forlate variance 37

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Connect For Financial Accounting Fundamentals

Authors: Author

8th Edition

126411169X, 9781264111695

More Books

Students also viewed these Accounting questions

Question

Which of the following best describes risk mitigation?

Answered: 1 week ago

Question

What is the effect of word war second?

Answered: 1 week ago