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 Direct Materials - Commercial Actual Quantity -AQ Actual Rate -AR Total Actual Quantity -AQ Standard Rate -SR Total Standard Quantity - SQ Standard Rate - SR Total Price Variance $ 30U Quantity Variance $ 10 U Total Variance Explanation for Quantity variance: Explanation for price variance: Direct Materials - Residential Actual Quantity -AQ Actual Rate -AR Total Actual Quantity -40 Standard Rate -SR Total Standard Quantity - SO Standard Rate - SR Total Price Variance Quantity Variance Total Variance Explanation for Quantitu variance: Explanation for price variance: Total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions