1. Your input is required for the following spreadsheets whose tabs are highlighted in yellow:
> Static Budget
> Actual Budget
> Flexible Budget
> Var Analysis - Static and Flex
> Material variances
> Labour variances
> Assumptions
2. Within each of the above spreadsheets, your input is required for cells highlighted in grey:
3. The input data is availalble in the spreadsheet, ' Input Database'. This spreadsheet is locked and you will
not be able to make any changes to its values. You are required to link data from this spreadsheet and
complete the inputs in the spreadsheets above ( whose tabs are highlighted in yellow).
4.On the Input data spreadsheet, cells K33:O33 represent unproductive / unbilled factor. The percentage reflects hours over and above revenue generating hours. These are hours where re-work had to be done, but clients would not be billed for. This factor is to be included in the direct labour budget, but not in the revenue budget.Assume that there is no impact on direct materials on account of these hours.
5. Ensure that there are no plugged values in cells, IF statements are used where appropriate.

Excel File Edit View View Insert Format Tools Data Window Help 34%O Wed 25 Nov 2:06 PM Q AutoSave OFF HES F20 - Budget Assignment - Student - v5 X Calibri (Body Insert 11 ' = = = ab v ENAU Custom Conditional Formatting Format as Table Cell Styles 4YO 5 X Delete v Tv Paste .00 BI U V ar Av V % 9 Ideas Sort & Filter Format Find & Select Sensitivity Create and Share Adobe PDF A37 fx A D E F G H H K L M N 0 Q B --- Parameters - budget 1 Parameters-actual 1 Quarters 3 Quarters 2 1 2 4 Year 1 3 Yeari 4,160 2,900 1,260 5,060 3,530 1,530 4,460 3,110 1,350 5,360 3,740 1,620 19,040 13,280 5,760 Sales (hours): Actual total sales Actual sales -commercial Actual sales - residential Selling price ($/hr): Actual selling price-commercial Actual sellling price - residential 4,020 2,810 1,210 5,220 3,650 1,570 4,120 2,880 1,240 5,320 3,720 1,600 1 18,680 i 13,060 i 5,620 1 $40 1 $ $ 37 $ 48 $ 37 $ 48 $ 37 $ 48 $ 37 $ 48 $ 37 48 $40 $50 $40 $50 $40 $50 $40 $50 $50 $ 22 $ 22 $ 22 $ 22 Direct labour expense ($/hr): 22 22 22 22 1 1 0.25 0.15 0.25 0.15 0.25 0.15 0.25 0.15 Actual Cleaning Supply usage (litre / labour hour): Commercial Residential 0.22 0.11 0.22 0.11 0.22 0.11 0.22 0.11 1 $ 5.50 $ 5.50 $ 5.50 $ 5.50 Actual Cleaning Supply expense ($/litre): 5 5 5 5 5 5 1 2 3 i 4 Sales (hours): 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours 8 Selling price ($/hr): 9 Selling price per hour (commercial) 10 Selling price per hour (residential) 11) 12 Direct labour expense ($/hr): 13 14 Cleaning Supply usage (litre / labour hour): 15 Commercial 16 Residential 17) 18 Cleaning Supply expense ($/litre)); 19 20 Fixed overhead: 21 Receptionist 22 Depreciation 23 Gas 24 Office Supplies 25 26 27 28 29 30 21 31 32 33 ) 34 35 36 37 38 39 40 41 42 43 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 25,450 36,900 30,600 4,300 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6,010 9,225 7,300 990 5,770 9,225 7,940 950 5,915 9,225 7,450 975 6,325 9,225 7,275 1,215 24,020 i 36,900 29,965 ! 4,130 20,361 1 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,063 1,319 4,382 96,400 3,979 1,711 5,690 1,25,176 3,139 1,352 4,491 98,798 4,055 1,744 5,799 1,27,574 14,235 6,126! 20,361 4,47,946 i Unproductive (unbilled) factor 996 996 996 9% 9%1 Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Select destination and press ENTER or choose Paste a + 100% Excel File Edit View Insert Format Tools Data Window Help 8%D Wed 25 Nov 4:11 PM Q AutoSave OFF B Fv 5 F20 - Budget Assignment - Student - v5 Calibri (Body) . AP Insert 11 v Custom Conditional Formatting Format as Table Cell Styles WE 48. Ou 5 DX Delete v Paste B 1 Uv a. Av Lg % ) Ideas E == Sensitivity 00 0 Sort & Filter Format Find & Select Create and Share Adobe PDF D5 4 x fx A B D E F G H 1 J K L M N 1 2 Super Clean Inc Static Budget Variance Static for the year Variance U/F Marks Flexible Budget Variance Flexible for the year Variance Actual for the year Actual for the year U/F 1 1 1 3 4 Sales budget 5 Sales Commercial 6 Sales residential 7 Total sales 8 9 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 1 1 1 14 1 1 1 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 1 1 1 1 1 27 28 29 Total 14 30 31 32 Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Ready E + 130% AutoSave OFF ES5= F20 - Budget Assignment - Student - v5 Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments X Calibri (Body) ab "A 11 Insert v I Conditional Formatting Custom WE s 48" LO Format as Table v DX Delete v V Paste B IU A LE % 8 E .00 > 0 Ideas Sensitivity Cell Styles Sort & Filter Format v Find & Select Create and Share Adobe PDF C26 fx A B D E F G H 1 J K L M N o 0 P P 1 SUPER CLEAN Operating results for the period Jan - Dec '18 2 3 4 Quarters 3 5 1 2 4 Year Marks 2 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 2 31 Total 8 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Ready @ + 130% AutoSave OFF HES F20 - Budget Assignment - Student - v5 Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments X Calibri (Body) ab AI 11 Insert v I Conditional Formatting General WE s 48" LO Format as Table v , DX Delete v V Paste .00 B I U Uv A LE %> 8 Ideas Cell Styles Sort & Filter Sensitivity Format v Find & Select Create and Share Adobe PDF E31 fx A B D E F G H J K L M N o 0 P P 1 SUPER CLEAN Flexible budget for the period Jan-Dec '18 2 3 4 Quarters 3 5 1 2 4 Year Marks 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 2 11 2 2 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 28 Office Supplies 29 Total 30 31 2 Total 8 32 Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + - Ready @ A + 130% AutoSave OFF BES = F20 - Budget Assignment - Student - v5 Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share O Comments X Calibri (Body) . Ai Insert v 11 I Conditional Formatting v ab General WE s Ayu Oy Format as Table DX Delete V Paste B I U Uv A LE % 8 .00 20 Ideas Cell Styles Sort & Filter Sensitivity Format Find & Select Create and Share Adobe PDF F8 4 x fx A B D E F G H H 1 L L M M N O P Q R s T U v Labour - Commercial Marks 1 2 3 Actual Hours -AH 4 Actual Rate -AR Actual Hours -AH - Standard Rate-SR Standard Hours -SH Standard Rate - SR 5 3 6 Rate Variance Efficiency Variance 7 8 2 1 Total Variance 9 10 11 Explanation for Efficiency variance: 12 13 14 Explanation for rate variance: 15 1 1 16 17 18 19 Labour - Residential Actual Hours -AH Standard Rate -SR Standard Hours -SH Standard Rate -SR 3 Efficiency Variance 2 Total Variance 1 1 20 21 22 Actual Hours -AH 23 Actual Rate -AR 24 25 26 Rate Variance 27 28 29 30 31 Explanation for Efficiency variance: 32 33 34 Explanation for rate variance: 35 36 37 38 39 40 41 42 43 A4 Actual Budget Flexible Budget Ready 1 Total 16 Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + + 100% Excel File Edit View View Insert Format Tools Data Window Help 8%D Wed 25 Nov 4:11 PM Q AutoSave OFF HES F20 - Budget Assignment - Student - v5 Calibri (Body) Insert 11 . Ai General El Conditional Formatting Format as Table Cell Styles N O WE 480 5 DX Delete v V Paste Uv A LE % * ) 8 .00 20 Ideas Sort & Filter Sensitivity Format v Find & Select Create and Share Adobe PDF G30 fx A B D E F H 1 L L M N O P Q R S T U V w Direct Materials - Commercial Marks 1 2 3 Actual Quantity-AQ 4 Actual Rate -AR Actual Quantity -AQ Standard Rate-SR Standard Quantity - SQ Standard Rate-SR 5 3 Quantity Variance 2 1 Total Variance 1 1 Direct Materials - Residential Actual Quantity -AQ Standard Rate -SR Standard Quantity - SQ Standard Rate-SR 3 6 7 Price Variance 8 9 10 11 12 Explanation for Quantity variance: 13 14 15 Explanation for price variance: 16 17 18 19 20 21 22 Actual Quantity -AQ 23 Actual Rate -AR 24 25 26 Price Variance 27 28 29 30 31 32 33 Explanation for Quantity variance: 34 35 36 Explanation for price variance: 37 38 39 40 41 42 43 44 Actual Budget Flexible Budget Quantity Variance 2 Total Variance 1 1 1 Total 16 Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Ready A + 100% Excel File Edit View View Insert Format Tools Data Window Help 34%O Wed 25 Nov 2:06 PM Q AutoSave OFF HES F20 - Budget Assignment - Student - v5 X Calibri (Body Insert 11 ' = = = ab v ENAU Custom Conditional Formatting Format as Table Cell Styles 4YO 5 X Delete v Tv Paste .00 BI U V ar Av V % 9 Ideas Sort & Filter Format Find & Select Sensitivity Create and Share Adobe PDF A37 fx A D E F G H H K L M N 0 Q B --- Parameters - budget 1 Parameters-actual 1 Quarters 3 Quarters 2 1 2 4 Year 1 3 Yeari 4,160 2,900 1,260 5,060 3,530 1,530 4,460 3,110 1,350 5,360 3,740 1,620 19,040 13,280 5,760 Sales (hours): Actual total sales Actual sales -commercial Actual sales - residential Selling price ($/hr): Actual selling price-commercial Actual sellling price - residential 4,020 2,810 1,210 5,220 3,650 1,570 4,120 2,880 1,240 5,320 3,720 1,600 1 18,680 i 13,060 i 5,620 1 $40 1 $ $ 37 $ 48 $ 37 $ 48 $ 37 $ 48 $ 37 $ 48 $ 37 48 $40 $50 $40 $50 $40 $50 $40 $50 $50 $ 22 $ 22 $ 22 $ 22 Direct labour expense ($/hr): 22 22 22 22 1 1 0.25 0.15 0.25 0.15 0.25 0.15 0.25 0.15 Actual Cleaning Supply usage (litre / labour hour): Commercial Residential 0.22 0.11 0.22 0.11 0.22 0.11 0.22 0.11 1 $ 5.50 $ 5.50 $ 5.50 $ 5.50 Actual Cleaning Supply expense ($/litre): 5 5 5 5 5 5 1 2 3 i 4 Sales (hours): 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours 8 Selling price ($/hr): 9 Selling price per hour (commercial) 10 Selling price per hour (residential) 11) 12 Direct labour expense ($/hr): 13 14 Cleaning Supply usage (litre / labour hour): 15 Commercial 16 Residential 17) 18 Cleaning Supply expense ($/litre)); 19 20 Fixed overhead: 21 Receptionist 22 Depreciation 23 Gas 24 Office Supplies 25 26 27 28 29 30 21 31 32 33 ) 34 35 36 37 38 39 40 41 42 43 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1,075 25,450 36,900 30,600 4,300 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6,010 9,225 7,300 990 5,770 9,225 7,940 950 5,915 9,225 7,450 975 6,325 9,225 7,275 1,215 24,020 i 36,900 29,965 ! 4,130 20,361 1 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,063 1,319 4,382 96,400 3,979 1,711 5,690 1,25,176 3,139 1,352 4,491 98,798 4,055 1,744 5,799 1,27,574 14,235 6,126! 20,361 4,47,946 i Unproductive (unbilled) factor 996 996 996 9% 9%1 Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Select destination and press ENTER or choose Paste a + 100% Excel File Edit View Insert Format Tools Data Window Help 8%D Wed 25 Nov 4:11 PM Q AutoSave OFF B Fv 5 F20 - Budget Assignment - Student - v5 Calibri (Body) . AP Insert 11 v Custom Conditional Formatting Format as Table Cell Styles WE 48. Ou 5 DX Delete v Paste B 1 Uv a. Av Lg % ) Ideas E == Sensitivity 00 0 Sort & Filter Format Find & Select Create and Share Adobe PDF D5 4 x fx A B D E F G H 1 J K L M N 1 2 Super Clean Inc Static Budget Variance Static for the year Variance U/F Marks Flexible Budget Variance Flexible for the year Variance Actual for the year Actual for the year U/F 1 1 1 3 4 Sales budget 5 Sales Commercial 6 Sales residential 7 Total sales 8 9 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 1 1 1 14 1 1 1 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 1 1 1 1 1 27 28 29 Total 14 30 31 32 Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Ready E + 130% AutoSave OFF ES5= F20 - Budget Assignment - Student - v5 Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments X Calibri (Body) ab "A 11 Insert v I Conditional Formatting Custom WE s 48" LO Format as Table v DX Delete v V Paste B IU A LE % 8 E .00 > 0 Ideas Sensitivity Cell Styles Sort & Filter Format v Find & Select Create and Share Adobe PDF C26 fx A B D E F G H 1 J K L M N o 0 P P 1 SUPER CLEAN Operating results for the period Jan - Dec '18 2 3 4 Quarters 3 5 1 2 4 Year Marks 2 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 2 31 Total 8 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Ready @ + 130% AutoSave OFF HES F20 - Budget Assignment - Student - v5 Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments X Calibri (Body) ab AI 11 Insert v I Conditional Formatting General WE s 48" LO Format as Table v , DX Delete v V Paste .00 B I U Uv A LE %> 8 Ideas Cell Styles Sort & Filter Sensitivity Format v Find & Select Create and Share Adobe PDF E31 fx A B D E F G H J K L M N o 0 P P 1 SUPER CLEAN Flexible budget for the period Jan-Dec '18 2 3 4 Quarters 3 5 1 2 4 Year Marks 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 2 11 2 2 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 28 Office Supplies 29 Total 30 31 2 Total 8 32 Actual Budget Flexible Budget Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + - Ready @ A + 130% AutoSave OFF BES = F20 - Budget Assignment - Student - v5 Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share O Comments X Calibri (Body) . Ai Insert v 11 I Conditional Formatting v ab General WE s Ayu Oy Format as Table DX Delete V Paste B I U Uv A LE % 8 .00 20 Ideas Cell Styles Sort & Filter Sensitivity Format Find & Select Create and Share Adobe PDF F8 4 x fx A B D E F G H H 1 L L M M N O P Q R s T U v Labour - Commercial Marks 1 2 3 Actual Hours -AH 4 Actual Rate -AR Actual Hours -AH - Standard Rate-SR Standard Hours -SH Standard Rate - SR 5 3 6 Rate Variance Efficiency Variance 7 8 2 1 Total Variance 9 10 11 Explanation for Efficiency variance: 12 13 14 Explanation for rate variance: 15 1 1 16 17 18 19 Labour - Residential Actual Hours -AH Standard Rate -SR Standard Hours -SH Standard Rate -SR 3 Efficiency Variance 2 Total Variance 1 1 20 21 22 Actual Hours -AH 23 Actual Rate -AR 24 25 26 Rate Variance 27 28 29 30 31 Explanation for Efficiency variance: 32 33 34 Explanation for rate variance: 35 36 37 38 39 40 41 42 43 A4 Actual Budget Flexible Budget Ready 1 Total 16 Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + + 100% Excel File Edit View View Insert Format Tools Data Window Help 8%D Wed 25 Nov 4:11 PM Q AutoSave OFF HES F20 - Budget Assignment - Student - v5 Calibri (Body) Insert 11 . Ai General El Conditional Formatting Format as Table Cell Styles N O WE 480 5 DX Delete v V Paste Uv A LE % * ) 8 .00 20 Ideas Sort & Filter Sensitivity Format v Find & Select Create and Share Adobe PDF G30 fx A B D E F H 1 L L M N O P Q R S T U V w Direct Materials - Commercial Marks 1 2 3 Actual Quantity-AQ 4 Actual Rate -AR Actual Quantity -AQ Standard Rate-SR Standard Quantity - SQ Standard Rate-SR 5 3 Quantity Variance 2 1 Total Variance 1 1 Direct Materials - Residential Actual Quantity -AQ Standard Rate -SR Standard Quantity - SQ Standard Rate-SR 3 6 7 Price Variance 8 9 10 11 12 Explanation for Quantity variance: 13 14 15 Explanation for price variance: 16 17 18 19 20 21 22 Actual Quantity -AQ 23 Actual Rate -AR 24 25 26 Price Variance 27 28 29 30 31 32 33 Explanation for Quantity variance: 34 35 36 Explanation for price variance: 37 38 39 40 41 42 43 44 Actual Budget Flexible Budget Quantity Variance 2 Total Variance 1 1 1 Total 16 Var Analysis - Static and Flex Material variances Labour variances Input Database Rubric + Ready A + 100%