Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with the answers and kindly update the detailed formulas used for better understanding. Thanks ! B1 U Merge & Center % 8-12 Insert

image text in transcribedimage text in transcribedPlease help with the answers and kindly update the detailed formulas used for better understanding. Thanks !

B1 U Merge & Center % 8-12 Insert Delete Format Format Painter Clipboard conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort Find & Ejter Select Editing Font Alignment Number Cells R25 A D E F G H 0 J M N o B C Parameters-budget Parameters actual Quarters 3 Quarters 2 1 2 4 Year 1 3 4 Year Sales[hours: Budgeted total sales in hours Sudgeted commercial sales in hours Budgeted residential sales in hours Selling prices/hr): Selling price per hour (commercial) Selling price per hour (residential) 4,000 2.800 1,200 4.900 3.430 1,470 4,300 3,010 1,290 5,200 3,640 1,560 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 selling 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,300 12,460 5,340 $40 550 $40 S50 $40 S50 $40 $50 $40 550 540 S50 $40 $50 $40 $50 $40 $50 $40 $50 5 Direct labour expense ( 5/hr): 205 205 20 20$ Direct labour expense S/hr): 18 S 18 $ 18 5 18 5 Cleaning Supply usage (litre/labour hour): Commercial Residential 02 0.2 0.1 0:2 C 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 0.1 0.1 5.505 S 5.50 S S Cleaning Supply expenses/litre]): Actual Cleaning Supply expense (S/litre)) 5.50 5.50 5.6 $ 5.6 5.65 5.6 S 23,950 Fixed overhead: Receptionist Depreciation Gas Office Supplies 5,250 9,875 7,500 1,000 6,250 9,375 3500 1.000 6,250 9,375 7,500 1,000 6,250 9.375 7,500 1,000 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 37,500 29,100 4,100 23,360 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3.192 1,368 4.560 - 200 1,800 6,000 108,000 3,276 1,404 4,680 94,240 4,284 14,952 1,836 6,408 6,120 21,360 110 160 384,480 82.080 2016 2056 2098 2093 2095 Unproductive (unbilled) factor Labour - Commercial Actual Hours - AH Actual Rate -AR Total Actual Hours - AH Standard Rate -SR Total Standard Hours - SH Standard Rate - SR Total Rate Variance Efficiency Variance Total Variance Explanation for Efficiency variance: Explanation for rate variance: Labour - Residential Actual Hours - AH Actual Rate -AR Total Actual Hours - AH Standard Rate -SR Total Standard Hours - SH Standard Rate - SR Tota Rate Variance Efficiency Variance Total Variance B1 U Merge & Center % 8-12 Insert Delete Format Format Painter Clipboard conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort Find & Ejter Select Editing Font Alignment Number Cells R25 A D E F G H 0 J M N o B C Parameters-budget Parameters actual Quarters 3 Quarters 2 1 2 4 Year 1 3 4 Year Sales[hours: Budgeted total sales in hours Sudgeted commercial sales in hours Budgeted residential sales in hours Selling prices/hr): Selling price per hour (commercial) Selling price per hour (residential) 4,000 2.800 1,200 4.900 3.430 1,470 4,300 3,010 1,290 5,200 3,640 1,560 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 selling 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,300 12,460 5,340 $40 550 $40 S50 $40 S50 $40 $50 $40 550 540 S50 $40 $50 $40 $50 $40 $50 $40 $50 5 Direct labour expense ( 5/hr): 205 205 20 20$ Direct labour expense S/hr): 18 S 18 $ 18 5 18 5 Cleaning Supply usage (litre/labour hour): Commercial Residential 02 0.2 0.1 0:2 C 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 0.1 0.1 5.505 S 5.50 S S Cleaning Supply expenses/litre]): Actual Cleaning Supply expense (S/litre)) 5.50 5.50 5.6 $ 5.6 5.65 5.6 S 23,950 Fixed overhead: Receptionist Depreciation Gas Office Supplies 5,250 9,875 7,500 1,000 6,250 9,375 3500 1.000 6,250 9,375 7,500 1,000 6,250 9.375 7,500 1,000 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 37,500 29,100 4,100 23,360 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3.192 1,368 4.560 - 200 1,800 6,000 108,000 3,276 1,404 4,680 94,240 4,284 14,952 1,836 6,408 6,120 21,360 110 160 384,480 82.080 2016 2056 2098 2093 2095 Unproductive (unbilled) factor Labour - Commercial Actual Hours - AH Actual Rate -AR Total Actual Hours - AH Standard Rate -SR Total Standard Hours - SH Standard Rate - SR Total Rate Variance Efficiency Variance Total Variance Explanation for Efficiency variance: Explanation for rate variance: Labour - Residential Actual Hours - AH Actual Rate -AR Total Actual Hours - AH Standard Rate -SR Total Standard Hours - SH Standard Rate - SR Tota Rate Variance Efficiency Variance Total Variance

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

Principles Of Managerial Finance Brief

Authors: Chad J. Zutter, Scott B. Smart

8th Global Edition

1292267143, 978-1292267142

More Books

Students also viewed these Finance questions