5 Static Budget 6 > Actual Budget > Flexible Budget 8 > Var Analysis - Static and Flex 9 > Material variances 10> Labour variances 11 > Assumptions 12 13 2. Within each of the above worksheets, your input is required for cells highlighted in grey: 16 17 15 3. The input data is availalble in the worksheet, assumption. This worksheet is locked and you will not be able to make any changes to its values. You are required to link data from this worksheet and complete the inputs in the worksheets above ( whose tabs are highlighted in yellow). 18 revenue 4.On assumptions sheet, cells 35:035 represent unproductive / unbilled factor. The percentage reflects hours over and above generating hours. These are hours whese re-work had to be done, but clients would not be billed for. This factor is to be included in the 19 direct labour budgetbut not in the revenue budget.Assume that there is no impact on direct materials on account of these hours. 20 21 5. Ensure that there are no plugged values in cells, IF statements are used where appropriate. 22 4 Year 5.460 3.840 1.620 19.080 13.280 5.800 ao 37 S 48 $ 37 48 22 A B Parameters - budget 2 Quarters 3 1 2 3 4 Sales hours) 5 Budgeted total sales in hours 4.260 4.860 4.500 6 Budgeted commercial sales in hours 3.000 3.330 3.110 7 Budgeted residential sales in hours 1 260 1.530 1.390 8 Selling price ( S/hr): 9 Selling price per hour (commercial) 37 S 37 S 37 S 10 Selling price per hour (residential) 48 $ 48 $ 48 $ 11 12 Direct labour expense (S/hr): 22 22 22 13 14 Cleaning Supply usage ( litre / labour hour): 15 Commercial 0.3 0.3 0.25 16 Residential 0.17 0.17 0.15 17 18 Cleaning Supply expense (S/litre)); S 5.50 S 5.50 $ 5.50 $ 19 20 Fixed overhead: 21 Receptionist 6800 6800 6800 22 Depreciation 9600 9600 9600 123 Gas 7800 7800 7900 24 Office Supplies 1300 1300 1300 25 26 27 28 0.25 0.15 5.50 6800 9600 7900 1300 27200 38400 31400 5200 SEV re Yes 1 Share 2 54 Bunuh LO DEE OT 4 1110 10 ERGI IEEE IMAIS Arts Alles A les DOS DIRE DIET 5230 160 1.o 3 5400 130 170 10 5:20 160 Seperti 1.2 MS 18 ABS LE 19 MS 48 40 40 Nec More 16 49 on 22 22 23 23 23 23 11 03 011 SEO S10 012 ATM) CO Red 0.25 0.15 SEO ILO 025 011 022 011 tto 110 OSS SOOS 055 5 5 s 3 400 20 21 deception 22 Depreciation cas 24 Oras 00 500 7800 1300 5800 9600 7500 1100 6800 9600 7900 1100 Actor Recent Deprecate des Once 27200 300 33600 $300 8010 9.500 72300 DOBE DOET 5770 3800 7540 550 S 500 9.600 2450 0115 9.600 7.550 2000 33400 30 250 4130 066 1.215 21 108 Temployees Bread Comercial 3195 14256 1354 1401 4.556 4.304 100 4 125 1124 599 115.66B Actors wat Debo 31 21106 4141 104.430 307.09 138 267 Lieproductible NET NET NET De Supply expenses/le) 5 5 5 51 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6.010 9.600 7.300 990 5.770 9.600 7.940 950 5.900 9.600 7.450 975 6.325 9.600 7560 1.215 24.005 38.400 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 4543 104.480 4.125 1.774 5.899 135.668 3.254 1.401 4.656 107.079 4.204 14.758 1.808 6.351 6,012 21 108 138.267485.493 Unproductive (unbilled) factor 13% 13% 13% 1396 13% al Budget Flexible Budget Var Analysis - Static and F ENG 11:22 2020- (hp 1 2 Super Clean Ind Statke Budget Variance Actual for the year Static for the yea Variance WE Flexible Budget Variance Actual for the year Flexible for the yearVariance WE 4 Sales budget 5 Sales Commercial 6 Sales residential 7 Total sales 9 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 14 15 16 Labour budget 17 Commercial 18 Residential 19. Total labour 20 21 Fixed Overhead: -22 Receptionist 23 Depreciation 24 Gas 25 Office Supplies 26 Total 27 28 29 To Read this first Assumptions Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Materis LE M Total Variance F Oireet MATATS Commeren Actuarusnya Actual Bater AR Actual Quantity Standard Bate.SR Standard Quantit se Standards: SR Quantity Variance Total Variance Direct Materials - Residential 7 Price Variance 3 18 0 11 Explanation for Quantity wariance. 13, HE 15. Explanation for price variance: ES 17 18 19 20 21 22. Actual Quantity AD 28 | Actual Rate -AR 124 25 26 Price Variance 27 25 29 30 31 32 33 Explanation for Quantit variance: 34 13 36 Explanation for price variance. 37 38 39 Actual Quantity:AQ Standard Rate.SR Standard Quantity - SQ Standard Rate . SR Quantity Variance Total Variance Was you need to detexto stay in Protected Vi ES X A D Labour Commercial ACUSTHOUSAH Adal Rate -AR Aus Hours HAH Standard Rate SA Standard Hours SH Standard Re SR Rate Variance Elfidency Variance Total Variance Explanation for Efficiency variance: Explanation for rate variance: 1951 Labour Residential Actual Hours - AH Standard Rate -SA Standard Hours-SH Standard Rate SR Efficiency Variance 22 Atual Hours - AH 23 Actual Rate -AR 124 25 26 Rate Variance 27 28 29 30 31 Explanation for Efficiency variance: Total Variance Explanation for rate variance: Total 5 Static Budget 6 > Actual Budget > Flexible Budget 8 > Var Analysis - Static and Flex 9 > Material variances 10> Labour variances 11 > Assumptions 12 13 2. Within each of the above worksheets, your input is required for cells highlighted in grey: 16 17 15 3. The input data is availalble in the worksheet, assumption. This worksheet is locked and you will not be able to make any changes to its values. You are required to link data from this worksheet and complete the inputs in the worksheets above ( whose tabs are highlighted in yellow). 18 revenue 4.On assumptions sheet, cells 35:035 represent unproductive / unbilled factor. The percentage reflects hours over and above generating hours. These are hours whese re-work had to be done, but clients would not be billed for. This factor is to be included in the 19 direct labour budgetbut not in the revenue budget.Assume that there is no impact on direct materials on account of these hours. 20 21 5. Ensure that there are no plugged values in cells, IF statements are used where appropriate. 22 4 Year 5.460 3.840 1.620 19.080 13.280 5.800 ao 37 S 48 $ 37 48 22 A B Parameters - budget 2 Quarters 3 1 2 3 4 Sales hours) 5 Budgeted total sales in hours 4.260 4.860 4.500 6 Budgeted commercial sales in hours 3.000 3.330 3.110 7 Budgeted residential sales in hours 1 260 1.530 1.390 8 Selling price ( S/hr): 9 Selling price per hour (commercial) 37 S 37 S 37 S 10 Selling price per hour (residential) 48 $ 48 $ 48 $ 11 12 Direct labour expense (S/hr): 22 22 22 13 14 Cleaning Supply usage ( litre / labour hour): 15 Commercial 0.3 0.3 0.25 16 Residential 0.17 0.17 0.15 17 18 Cleaning Supply expense (S/litre)); S 5.50 S 5.50 $ 5.50 $ 19 20 Fixed overhead: 21 Receptionist 6800 6800 6800 22 Depreciation 9600 9600 9600 123 Gas 7800 7800 7900 24 Office Supplies 1300 1300 1300 25 26 27 28 0.25 0.15 5.50 6800 9600 7900 1300 27200 38400 31400 5200 SEV re Yes 1 Share 2 54 Bunuh LO DEE OT 4 1110 10 ERGI IEEE IMAIS Arts Alles A les DOS DIRE DIET 5230 160 1.o 3 5400 130 170 10 5:20 160 Seperti 1.2 MS 18 ABS LE 19 MS 48 40 40 Nec More 16 49 on 22 22 23 23 23 23 11 03 011 SEO S10 012 ATM) CO Red 0.25 0.15 SEO ILO 025 011 022 011 tto 110 OSS SOOS 055 5 5 s 3 400 20 21 deception 22 Depreciation cas 24 Oras 00 500 7800 1300 5800 9600 7500 1100 6800 9600 7900 1100 Actor Recent Deprecate des Once 27200 300 33600 $300 8010 9.500 72300 DOBE DOET 5770 3800 7540 550 S 500 9.600 2450 0115 9.600 7.550 2000 33400 30 250 4130 066 1.215 21 108 Temployees Bread Comercial 3195 14256 1354 1401 4.556 4.304 100 4 125 1124 599 115.66B Actors wat Debo 31 21106 4141 104.430 307.09 138 267 Lieproductible NET NET NET De Supply expenses/le) 5 5 5 51 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6.010 9.600 7.300 990 5.770 9.600 7.940 950 5.900 9.600 7.450 975 6.325 9.600 7560 1.215 24.005 38.400 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 4543 104.480 4.125 1.774 5.899 135.668 3.254 1.401 4.656 107.079 4.204 14.758 1.808 6.351 6,012 21 108 138.267485.493 Unproductive (unbilled) factor 13% 13% 13% 1396 13% al Budget Flexible Budget Var Analysis - Static and F ENG 11:22 2020- (hp 1 2 Super Clean Ind Statke Budget Variance Actual for the year Static for the yea Variance WE Flexible Budget Variance Actual for the year Flexible for the yearVariance WE 4 Sales budget 5 Sales Commercial 6 Sales residential 7 Total sales 9 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 14 15 16 Labour budget 17 Commercial 18 Residential 19. Total labour 20 21 Fixed Overhead: -22 Receptionist 23 Depreciation 24 Gas 25 Office Supplies 26 Total 27 28 29 To Read this first Assumptions Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Materis LE M Total Variance F Oireet MATATS Commeren Actuarusnya Actual Bater AR Actual Quantity Standard Bate.SR Standard Quantit se Standards: SR Quantity Variance Total Variance Direct Materials - Residential 7 Price Variance 3 18 0 11 Explanation for Quantity wariance. 13, HE 15. Explanation for price variance: ES 17 18 19 20 21 22. Actual Quantity AD 28 | Actual Rate -AR 124 25 26 Price Variance 27 25 29 30 31 32 33 Explanation for Quantit variance: 34 13 36 Explanation for price variance. 37 38 39 Actual Quantity:AQ Standard Rate.SR Standard Quantity - SQ Standard Rate . SR Quantity Variance Total Variance Was you need to detexto stay in Protected Vi ES X A D Labour Commercial ACUSTHOUSAH Adal Rate -AR Aus Hours HAH Standard Rate SA Standard Hours SH Standard Re SR Rate Variance Elfidency Variance Total Variance Explanation for Efficiency variance: Explanation for rate variance: 1951 Labour Residential Actual Hours - AH Standard Rate -SA Standard Hours-SH Standard Rate SR Efficiency Variance 22 Atual Hours - AH 23 Actual Rate -AR 124 25 26 Rate Variance 27 28 29 30 31 Explanation for Efficiency variance: Total Variance Explanation for rate variance: Total