Wiap Text General - Bad Copy Normal Conditional Format as Check Cell Formatting the Good Input Neutral Unked Cell BIV A Merge & Center - $ . % Explanatory. Static Budget E F G H I Instructions 1. Your input is required for the following spreadsheets whose tabs are highlighted in yellow: 5 > Static Budget 6 > Actual Budget 7 > Flexible Budget 8 > Var Analysis - Static and Flex 9 > Material variances 10 > Labour variances 11 > Assumptions 13 2. Within each of the above spreadsheets, your input is required for cells highlighted in grey: 15 3. The input data is available in the spreadsheet,'Input Database. This spreadsheet is locked and you will 16 not be able to make any changes to its values. You are required to link data from this spreadsheet and 17 complete the inputs in the spreadsheets above ( whose tabs are highlighted in yellow). 4.On the input data spreadsheet, cells 33:033 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 19 the direct labour budget, but not in the revenue budget. 21 5. Ensure that there are no plugged values in cells, IF statements are used where appropriate 23 6. Upload your completed spreadsheet to eConestoga Cover page Read this first Static Budget Actual Budget Fleebe tudget Var Analysis - Stic and flex Material variances Labour van ... O Type here to search 2435 Alignment Clipboard BH E SUPER CLEAN Operating Budget for the period Jan-Dec '18 Quarters 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs III 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Total Cover page Read this first Static Budget Actual Budget Flexible Budget Var AnalyskStatic and flex Material variances Ahnur GHI SUPER CLEAN Operating results for the period Jan Dec '18 Quarters Year Marks 15 Variable costs residential 16 Total variable costs 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24. Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Total Cover page Read this first stalk Budget Actual Budget b udget a static and flex Material variances Labour vari... Type here in our G H SUPER CLEAN Flexible budget for the period lan-Dec 18 - Noc Quarters Marks Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead 25 Receptionist 26 Depreciation 27 Gas 23 Office Supplies 29 Total Total Cover page Read this first Sulic Budget Adual Budget Flexible Budget Type here to search Var Analysis Static and her Material variances Labour var. O Tell me what you want to do Add-ins Help Insert Page Layout Formulasi Data Review View Home Xan Bad E xplanatory... Wrap lest Normal *88 Conditional Formats Check Cell Formatting Table Neutral Linked Good Input 11 . Copy Merge & Center. $. %. BIU. .A. . format Paint Opboard Alignment EF Super Clean Inc Static Budget Variance Flexible Budget Variance Actual for the year Static for the year Variance UF Actual for the year Flexible for the year Variance ULE Sales budget S Sales Commercial 6 Sales residential 7 Total sales 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 16 Labour budget 17 Commercial 18 Residential 19 Total labour 21 Feed Overhead: 22 Receptionist 23 Depreciation 4 Gas 25 Office Supplies 26 Total Cover page Read this first Stati Budget Actual Budget Fleche E xplanatory... Input Xu .% Conditional Formats Check Cell Formatting Table Copy Merge & Center Cupboard L M N O P 630 Standard Quantity - 50 Standard Rate.SR Actual Quantity andard Rare- Actual Rate Quantity Variance Total Variance II II Standard Quantity - 50 Mul Quantity Actual Quantity-AD III III Cover page Read this for a Budget A Budget H oe Vera Format Painter B IU. . . Merge & Center. 5. % Formatting Table Arment Labour - Commercial Actual Hours -AH Standard Rate SR Standard Rate - SR Total Variance SSN Actual Hours - AH Standard Rate -SR Standard Hours - SH Standard Rate.SR Este Variance Total Variance talon toisen 34 Caption for variance DES Sic Budget Actual Budget Flexible Budget Var Analys - Static and Flex M aterial variances Labour variances Assumptions A pet Mega Normal - S. Pomag Un Cell 1 List three assumptions beyond numbers: Assumption 1: MN Assumption 2: Assumption : PHILIPS Web-Budget Anger Student Corel General Tomating Table BC001 Parametersbudget Quarters K Parameters - actual L M N O 19,040 4 Sales (hours Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours a Selling price : Selling price per hour commercial) Selling price per hour freudential 4.110 2.900 1.250 500 3,530 1.500 4460 110 150 5.300 1,70 1620 Artuales Actual sales comercial 5,720 4.120 1,210 3.450 1.520 5 5 375 37 5 43 $ 17S 4BS Selling puke Adung price.com Actual selling price: resident 12 Direct labour expense W: 5 225 225 225 22 14 Cleaning supply agere labout how Commercial 16 Residential 38 R99 Actual Cleaning Supply elite/obow 0.25 0.15 0. 0.15 0.25 0.15 0.25 0.15 0.19 18 Cleaning Suppl $ 5.90 $ .30 530 5.50 20 Ted overhead 21 Receptionist 22 Depreciation 351 165 , 150 5,915 750 1,073 24 othee Supplies 710 107 750 FASO 1075 .00 3 2235 7,235 5 .000 35,300 23,965 410 5 21,69 4.35 5.150 5171216 autoSave OOBS Home Insert Page Layout cut Colibri Formulas Data Review View Add-ins Help W20 - Budget Assignment - Student - 4xlsx - Excel Tell me what you want to do H D Normal Explanatory... 2. Wrap Text General Copy . Merge & Center - S. . . Format Painter BTU. Conditional Format as Check Cell Formatting Table Clipboard Font Number Style A B C D E F G H I Instructions for students 4 1. Your input is required for the following spreadsheets whose tabs are highlighted in yellow: 5 > Static Budget 6 > Actual Budget 7 > Flexible Budget 8 > Var Analysis - Static and Flex 9 > Material variances 10 > Labour variances 11 > Assumptions 12 13 2. Within each of the above spreadsheets, your input is required for cells highlighted in grey 15 3. The input data is available in the spreadsheet,'Input Database'. This spreadsheet is locked and you will 16 not be able to make any changes to its values. You are required to link data from this spreadsheet and 17 complete the inputs in the spreadsheets above ( whose tabs are highlighted in yellow). 4.On the input data spreadsheet, cells K33:033 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 19 the direct labour budget, but not in the revenue budget. 21 5. Ensure that there are no plugged values in cells, IF statements are used where appropriate. 23 6. Upload your completed spreadsheet to eConestoga Cover page Read this first Static Budget Actual Budget Flexible Budget Var Analysis Static and Flex Material variances Labour vari... W20 - Budget Assignment - Student - ll- Excel Tell me what you want to do Review View Add-ins Help A | Home Insert Page Layout X out Calibri Format Painter .BIU. Clipboard Formulas Du A A . .A. 20 Wrap Text a copy Bad Explanatory.. Normal Conditional Formats Check Cell Formatting Table- Good Input Paste Merge & Center Styles 014 SUPER CLEAN Operating Budget for the period lan-Dec '18 Quarters 7 Sales budget Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 FedOverhead 25 Receptionist 26 Depreciation 27 2 Office Supplies 29 Total Cover page Read this first statie Budget Adual budget ble budget var store and the Material e s Labour var BS. Insert Pace Layout W20 - Budget Assiga Tell me what you want to do Formulas Data Review View Add-ins Help Calibri 11 - ab Wrap Text X Cut En Copy Format Painter BTU Merge Center - 5 3 9 2 Conditional Format as c Formatting - Table- Alignment C24 C D SUPER CLEAN Operating results for the period Jan - Dec '18 Quarters Marks 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 11 12 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs 18 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 9 Total - Total Cover page Read this first Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Ma eady do Calibri - 11 AA === . Wrap Text General Normal Copy aste BIU- - Merge & Center - $ - % 8. Format Painter Clipboard Conditional Format as Check Cell Formatting" Table Font Alignment Number B GH SUPER CLEAN Flexible budget for the period Jan-Dec '18 Quarters Marks Sales budget 3 Sales Commercial Sales residential 0 Total sales 3 Direct material budget 4 Variable costs commercial 5 Variable costs residential 6 Total variable costs 9 Labour budget 0 Commercial 21 Residential 2 Total labour I LILI 4 Fixed Overhead: 5 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Total Cover page Read this first Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Material variance - Barn-Studera Inaut Page Layout fom. Adin Ordu t you want to do Culom 5.3. Condition Accents Rent Accent Ants Acenta Ca - Menge Car r ry Super Clean Inc Static Budget Variance Actual for the year Static for the year Variance E Flexible Budget Variance flexible for the ye Variance Actual for the year 4 Sales budget 5 Sales Commercial 6 resident 7 Totes 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 16 Labour budget 17 Commercia 1 detal 19 Totator 21 Fixed Overhead: 22 Reception 23 Depreciation 2 Gas 25 Offices 26 Total Coverage lendes fr o m Yol Format Painter = Merge & Center - $. Conditional Formats Check Cell Formatting Table Alignment L M N O Actual Quantity-AQ Actual Rate AR Actual Quantity-AO Standard Rate-SR Standard Quantity - SQ Standard Rate - SR Price Variance Quantity Variance Total Variance 12 Explanation for Quantity o nce 15 Explanation for price variante Direct Materials - Resi 22 Actual Quantity-AO 23 Actual Rate -AR Actual Quantity-AO Standard Rate -SR Standard Quantity - SQ Standard Rate SR Quantity Variance Total Variance 13 Explanation for antity variance 36 Explanation for price variance BOS Cover page Read this first Static Budget Actual Budget Flexble Budget Var Analysis Static and flex Material variances Type here to search 2435 PHILIPS s - Excel Home Incert Page Layout W20 - Budget Assignment - Student Tel me what you want to de Formulas Data Re v iew Add-ins File A Xu Help Calibri - 11-A E Copy A Wrap Text TU. Paste - Format Painter B Cloboard Merge & Center - Conditional Format as Check Cell Formatting Table Expanorary Labour Commercial 3 Actual Hours - AH 4 Actual Rate AR Actual Hours AH Standard Rate -SR Standard Hours SH Standard Rate.SR Rate Variance Efficiency Variance Total Variance III 11 Explanation for Efficiency variances 14 Explanation for rate variance: 22 Actual Hours - AH Actual Hours - AH Standard Rate.SR Standard hours SH Standard late Rate Variance Total Variance nation for Elficiency walance III III 34 Explanation for rate wariance: Read this first Static Budget Actual Budget Flexible Budget Var Analysis Static and Flex Material variances Labour variances Assunt File Formulas Data Review View Add-ins Help Tell me what you want to do General Home Insert Page Layout & Cut Calibri Format Painter BIU- Font Copy Wrap Text Merge & Center - Paste - $ - % 242 Conditional Form Formatting Tal Coboard E18 1 List three assumptions beyond numbers: 2 Assumption 1: 5 Assumption 2: NO 8 Assumption 3 : Budapted Guided to tour Selling price per tout comme 10 Selling price per lo residential Actual Ac .com i deta 161 13 WS 10 ca TAPA PS4 NO 200 234 115 11 A Alte www stand s b eston Input De Rube Tab title Marks allocated Studer 00 00 00 3 Static Budget 4 Actual Budget 5 Flexible budget 6 Variance Analysis - Static and Flex 7. Material variances 8 Labour variances 68 La 9 76 List three the assumptions beyond the numbers. 10 Subtotal Worksheet data quality: no plugged values, use of 11 IF statements and cell references 12 Total 85 Wiap Text General - Bad Copy Normal Conditional Format as Check Cell Formatting the Good Input Neutral Unked Cell BIV A Merge & Center - $ . % Explanatory. Static Budget E F G H I Instructions 1. Your input is required for the following spreadsheets whose tabs are highlighted in yellow: 5 > Static Budget 6 > Actual Budget 7 > Flexible Budget 8 > Var Analysis - Static and Flex 9 > Material variances 10 > Labour variances 11 > Assumptions 13 2. Within each of the above spreadsheets, your input is required for cells highlighted in grey: 15 3. The input data is available in the spreadsheet,'Input Database. This spreadsheet is locked and you will 16 not be able to make any changes to its values. You are required to link data from this spreadsheet and 17 complete the inputs in the spreadsheets above ( whose tabs are highlighted in yellow). 4.On the input data spreadsheet, cells 33:033 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 19 the direct labour budget, but not in the revenue budget. 21 5. Ensure that there are no plugged values in cells, IF statements are used where appropriate 23 6. Upload your completed spreadsheet to eConestoga Cover page Read this first Static Budget Actual Budget Fleebe tudget Var Analysis - Stic and flex Material variances Labour van ... O Type here to search 2435 Alignment Clipboard BH E SUPER CLEAN Operating Budget for the period Jan-Dec '18 Quarters 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs III 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Total Cover page Read this first Static Budget Actual Budget Flexible Budget Var AnalyskStatic and flex Material variances Ahnur GHI SUPER CLEAN Operating results for the period Jan Dec '18 Quarters Year Marks 15 Variable costs residential 16 Total variable costs 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24. Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Total Cover page Read this first stalk Budget Actual Budget b udget a static and flex Material variances Labour vari... Type here in our G H SUPER CLEAN Flexible budget for the period lan-Dec 18 - Noc Quarters Marks Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead 25 Receptionist 26 Depreciation 27 Gas 23 Office Supplies 29 Total Total Cover page Read this first Sulic Budget Adual Budget Flexible Budget Type here to search Var Analysis Static and her Material variances Labour var. O Tell me what you want to do Add-ins Help Insert Page Layout Formulasi Data Review View Home Xan Bad E xplanatory... Wrap lest Normal *88 Conditional Formats Check Cell Formatting Table Neutral Linked Good Input 11 . Copy Merge & Center. $. %. BIU. .A. . format Paint Opboard Alignment EF Super Clean Inc Static Budget Variance Flexible Budget Variance Actual for the year Static for the year Variance UF Actual for the year Flexible for the year Variance ULE Sales budget S Sales Commercial 6 Sales residential 7 Total sales 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 16 Labour budget 17 Commercial 18 Residential 19 Total labour 21 Feed Overhead: 22 Receptionist 23 Depreciation 4 Gas 25 Office Supplies 26 Total Cover page Read this first Stati Budget Actual Budget Fleche E xplanatory... Input Xu .% Conditional Formats Check Cell Formatting Table Copy Merge & Center Cupboard L M N O P 630 Standard Quantity - 50 Standard Rate.SR Actual Quantity andard Rare- Actual Rate Quantity Variance Total Variance II II Standard Quantity - 50 Mul Quantity Actual Quantity-AD III III Cover page Read this for a Budget A Budget H oe Vera Format Painter B IU. . . Merge & Center. 5. % Formatting Table Arment Labour - Commercial Actual Hours -AH Standard Rate SR Standard Rate - SR Total Variance SSN Actual Hours - AH Standard Rate -SR Standard Hours - SH Standard Rate.SR Este Variance Total Variance talon toisen 34 Caption for variance DES Sic Budget Actual Budget Flexible Budget Var Analys - Static and Flex M aterial variances Labour variances Assumptions A pet Mega Normal - S. Pomag Un Cell 1 List three assumptions beyond numbers: Assumption 1: MN Assumption 2: Assumption : PHILIPS Web-Budget Anger Student Corel General Tomating Table BC001 Parametersbudget Quarters K Parameters - actual L M N O 19,040 4 Sales (hours Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours a Selling price : Selling price per hour commercial) Selling price per hour freudential 4.110 2.900 1.250 500 3,530 1.500 4460 110 150 5.300 1,70 1620 Artuales Actual sales comercial 5,720 4.120 1,210 3.450 1.520 5 5 375 37 5 43 $ 17S 4BS Selling puke Adung price.com Actual selling price: resident 12 Direct labour expense W: 5 225 225 225 22 14 Cleaning supply agere labout how Commercial 16 Residential 38 R99 Actual Cleaning Supply elite/obow 0.25 0.15 0. 0.15 0.25 0.15 0.25 0.15 0.19 18 Cleaning Suppl $ 5.90 $ .30 530 5.50 20 Ted overhead 21 Receptionist 22 Depreciation 351 165 , 150 5,915 750 1,073 24 othee Supplies 710 107 750 FASO 1075 .00 3 2235 7,235 5 .000 35,300 23,965 410 5 21,69 4.35 5.150 5171216 autoSave OOBS Home Insert Page Layout cut Colibri Formulas Data Review View Add-ins Help W20 - Budget Assignment - Student - 4xlsx - Excel Tell me what you want to do H D Normal Explanatory... 2. Wrap Text General Copy . Merge & Center - S. . . Format Painter BTU. Conditional Format as Check Cell Formatting Table Clipboard Font Number Style A B C D E F G H I Instructions for students 4 1. Your input is required for the following spreadsheets whose tabs are highlighted in yellow: 5 > Static Budget 6 > Actual Budget 7 > Flexible Budget 8 > Var Analysis - Static and Flex 9 > Material variances 10 > Labour variances 11 > Assumptions 12 13 2. Within each of the above spreadsheets, your input is required for cells highlighted in grey 15 3. The input data is available in the spreadsheet,'Input Database'. This spreadsheet is locked and you will 16 not be able to make any changes to its values. You are required to link data from this spreadsheet and 17 complete the inputs in the spreadsheets above ( whose tabs are highlighted in yellow). 4.On the input data spreadsheet, cells K33:033 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 19 the direct labour budget, but not in the revenue budget. 21 5. Ensure that there are no plugged values in cells, IF statements are used where appropriate. 23 6. Upload your completed spreadsheet to eConestoga Cover page Read this first Static Budget Actual Budget Flexible Budget Var Analysis Static and Flex Material variances Labour vari... W20 - Budget Assignment - Student - ll- Excel Tell me what you want to do Review View Add-ins Help A | Home Insert Page Layout X out Calibri Format Painter .BIU. Clipboard Formulas Du A A . .A. 20 Wrap Text a copy Bad Explanatory.. Normal Conditional Formats Check Cell Formatting Table- Good Input Paste Merge & Center Styles 014 SUPER CLEAN Operating Budget for the period lan-Dec '18 Quarters 7 Sales budget Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 FedOverhead 25 Receptionist 26 Depreciation 27 2 Office Supplies 29 Total Cover page Read this first statie Budget Adual budget ble budget var store and the Material e s Labour var BS. Insert Pace Layout W20 - Budget Assiga Tell me what you want to do Formulas Data Review View Add-ins Help Calibri 11 - ab Wrap Text X Cut En Copy Format Painter BTU Merge Center - 5 3 9 2 Conditional Format as c Formatting - Table- Alignment C24 C D SUPER CLEAN Operating results for the period Jan - Dec '18 Quarters Marks 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 11 12 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs 18 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 9 Total - Total Cover page Read this first Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Ma eady do Calibri - 11 AA === . Wrap Text General Normal Copy aste BIU- - Merge & Center - $ - % 8. Format Painter Clipboard Conditional Format as Check Cell Formatting" Table Font Alignment Number B GH SUPER CLEAN Flexible budget for the period Jan-Dec '18 Quarters Marks Sales budget 3 Sales Commercial Sales residential 0 Total sales 3 Direct material budget 4 Variable costs commercial 5 Variable costs residential 6 Total variable costs 9 Labour budget 0 Commercial 21 Residential 2 Total labour I LILI 4 Fixed Overhead: 5 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Total Cover page Read this first Static Budget Actual Budget Flexible Budget Var Analysis - Static and Flex Material variance - Barn-Studera Inaut Page Layout fom. Adin Ordu t you want to do Culom 5.3. Condition Accents Rent Accent Ants Acenta Ca - Menge Car r ry Super Clean Inc Static Budget Variance Actual for the year Static for the year Variance E Flexible Budget Variance flexible for the ye Variance Actual for the year 4 Sales budget 5 Sales Commercial 6 resident 7 Totes 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs 16 Labour budget 17 Commercia 1 detal 19 Totator 21 Fixed Overhead: 22 Reception 23 Depreciation 2 Gas 25 Offices 26 Total Coverage lendes fr o m Yol Format Painter = Merge & Center - $. Conditional Formats Check Cell Formatting Table Alignment L M N O Actual Quantity-AQ Actual Rate AR Actual Quantity-AO Standard Rate-SR Standard Quantity - SQ Standard Rate - SR Price Variance Quantity Variance Total Variance 12 Explanation for Quantity o nce 15 Explanation for price variante Direct Materials - Resi 22 Actual Quantity-AO 23 Actual Rate -AR Actual Quantity-AO Standard Rate -SR Standard Quantity - SQ Standard Rate SR Quantity Variance Total Variance 13 Explanation for antity variance 36 Explanation for price variance BOS Cover page Read this first Static Budget Actual Budget Flexble Budget Var Analysis Static and flex Material variances Type here to search 2435 PHILIPS s - Excel Home Incert Page Layout W20 - Budget Assignment - Student Tel me what you want to de Formulas Data Re v iew Add-ins File A Xu Help Calibri - 11-A E Copy A Wrap Text TU. Paste - Format Painter B Cloboard Merge & Center - Conditional Format as Check Cell Formatting Table Expanorary Labour Commercial 3 Actual Hours - AH 4 Actual Rate AR Actual Hours AH Standard Rate -SR Standard Hours SH Standard Rate.SR Rate Variance Efficiency Variance Total Variance III 11 Explanation for Efficiency variances 14 Explanation for rate variance: 22 Actual Hours - AH Actual Hours - AH Standard Rate.SR Standard hours SH Standard late Rate Variance Total Variance nation for Elficiency walance III III 34 Explanation for rate wariance: Read this first Static Budget Actual Budget Flexible Budget Var Analysis Static and Flex Material variances Labour variances Assunt File Formulas Data Review View Add-ins Help Tell me what you want to do General Home Insert Page Layout & Cut Calibri Format Painter BIU- Font Copy Wrap Text Merge & Center - Paste - $ - % 242 Conditional Form Formatting Tal Coboard E18 1 List three assumptions beyond numbers: 2 Assumption 1: 5 Assumption 2: NO 8 Assumption 3 : Budapted Guided to tour Selling price per tout comme 10 Selling price per lo residential Actual Ac .com i deta 161 13 WS 10 ca TAPA PS4 NO 200 234 115 11 A Alte www stand s b eston Input De Rube Tab title Marks allocated Studer 00 00 00 3 Static Budget 4 Actual Budget 5 Flexible budget 6 Variance Analysis - Static and Flex 7. Material variances 8 Labour variances 68 La 9 76 List three the assumptions beyond the numbers. 10 Subtotal Worksheet data quality: no plugged values, use of 11 IF statements and cell references 12 Total 85
