Answered step by step
Verified Expert Solution
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
Please 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 SUPER CLEAN Flexible budget for the period Jan - Dec '18 Quarters 3 1 2 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 TotalStep 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