Calibri - -AN = ) Wap Test Parameters - budget Quarters 1 Year 4 Selebours): 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours 8 Selling price (S/h: 9 Selling price per hour (commercial) 10 Seling price per hour (residential 4,160 2,900 1.260 5,060 3,530 1.500 4,460 3,110 1,350 5,360 3,740 1,620 19,040 13,280 5,760 S37 S37 S37 S37 S 37 $ 48 S48 S48 S48 S48 12 Direct labour expense (S/hr): S 20 S 20 S 20 S 20 14 Cleaning Supply usage litre / labour hourl: 15 Commercial 16 Residential 0.2 0.1 0.2 0.1 0.2 0.1 0.2 0.1 Material varices variance Assumption out bane Rubrik Type here to search Auto F D 19Budget Agent Studentin Formats Data Review View File Home vert Page Layout Help fonet 14 Cleaning Supply use (litre/Inbourhou): 15 Commercial 16 Residential 0.2 0.1 0.2 0.1 0.2 0.1 0.2 0.1 18 Cleaning Supply expenses/litrell: $ 5.50 $ 5.50 S 5.50 $ 5.50 20 Fixed overhead: 21 Receptionist Depreciation 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 925 9,225 7,650 1.075 25,450 36.900 30,600 4,300 24 Office Supplies Type here to search Budget Arrigment Student P ath opinder GC Forms Data Review ViewHelp General L M N O Parameters actual Sules ( hours: Actualtolal sales Actual sales - commercial Actual sales residential Selling prices/h: Actual selling price commercial Actual selling price-residential 4,020 2,810 1,210 5.220 3,650 1,570 4,120 2.880 1.240 5,320 31,720 1.600 18,680 13,060 620 S40 S60 $10 $50 $40 $50 550 $50 SSO 18 Direct labour expense (She): S 18 S 18 S 18 Actual Cleaning Supply usage (litre/Inbour hour): Commercial Residential 0.19 0.09 0.19 0.09 0.19 0,09 0.19 0,09 sbour variance A ction Database CHING O 19-Budget Argent Student 3 Ex a ch pinderen Formulas Dan Review View Help A A Wap Tot Mega Center 3 KIM No Po $ 5.40 S 5.40 S 5.10 $ 5.40 Actus Cleaning Supply expenses/litrell: Actual Thed overhend: Receptionist Depreciation 6,010 9.225 7.300 990 5.20 9.225 7.MD 950 5,915 9,225 7.450 975 6,325 9,225 7,225 1,215 24,020 36,900 29,955 4,130 Gas Office Supplies 21,856 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,28 1,416 4,703 84,661 4,271 1,837 6,107 109,933 3,370 1.451 4,820 86,767 4,352 1.872 6,224 112,039 15,280 6575 21,856 393,401 17% 17% 17% 17%. Unproductive (unbilled) factor variantes Assumption in Database Run A 4 ENG Autosea F1-udget Assignment Studenty Data Review View top . File Home ment Page Layout Formulas Colbie AA Paide BIV2- 0-A- E Ceboards AM - X Wap Test Merge Center $ - 969 Conditional Formats Formatting Style 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 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 complete the inputs in the spreadsheets above whose tabs are highlighted in yellow). Read this first Static Budget Actual Budget Flexible Budget var Analysis Static and flex H O Type here to search toong SUPER CLEAN Operating budget for the period an Dec '18 w Quarters 7 Sales budget B Sales Commercial 9 Sales residential 10 Total sales 11 $107,300 $60,480 $167,780 $130,610 $73,440 S204,050 $115,070 $64.800 $10 0 $138,380 $72.760 $216,140 5491,360 $276,480 S767,810 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs Read this first stadiget Actus Budget Huble Budget Varalyst and Type here to search Autove Tile Home Page Layout Formulas Data e View * O SUPER CIFAN Operating budget for the period lan Dec '18 19 Labour budget 21 Residential 22 Totallabour 24 Fixed Overhead: 25 Receptionist 26 Depreciation Office Supplies 39 Total Read this first St Budget Actual Buget Hele Budget O Type here to search Home Page Layout Forma t s Review - X SUPER CLEAN Operating results for the period on Dec '18 7 Sales budget Sales Commercial 9 les residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs Actub o Verde On - O Type here to search A B F# Budget Age Studentv File Home men Page Layout Termdan Data Revien vien Help SA TUHOA Merge - $ % 91 -22 Ford Fies SUPER CLLAN Operating results for the period Dec '18 Quarters 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Read the first Static budget Actual Budget Rexible det var Analysis and flex GE * O Type here to search 0 W A Budget Assignment Studentv X - w - -AA 11 O-A B TV E et Mese a Center - S -% Conditional Format SUPER CLEAN Flexible budget for the period lan Dec '18 Quarters 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 75 Variable costs residential 16 Total variable costs Read this first Stabic Budget Actual budget Flexible Budget - Type here to search N e w BTW - - -A- - Mega Cente SUPER CIRAN Flexible budget for the period lan Dec '18 Quarters 19 Labour budget Commercial 21 Residential 22 Total labour 23 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total 30 Set A telier Static and flex Type here to search 9 ondersch - X AutoSave File Home Share Comments insert F19 - Budget Assignment Student P ach Page Layout Formulas Data Review View Help - - AA == Wap Test Custom - OA E Merge Center - 5 - % Delete - Conditional Formats Cell Sort Find Ideas TW - Super Clean Inc Static Budget Variance Actual for the year Static for the year Variance U/E Flexible Budget Variance Flexible for the year Variance Actual for the year 4 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 . Actual Budget Var Analysis Static and Flex variances tabour Flexible fudget . A N 6:06 PM 404 ENG 2015-11-11 Type here to search Autolave F19 - Budget Anigment Studen Such opinder C O - 0 File Home insert Data Review View Help Share Comments Page Layout Formulas -11-AA 11. 0.A- E = BTU Wie Test Merge Center - S - % 16 Labour budget 17 Commercial 18 Residential 19 Total labour 21 Fixed Overhead: 22 Receptionist 23 Depreciation 24 Gas 25 Office Supplies 26 Total Actual Budget Flexible Budget Var Analysis Static and Flex Material arunces about Type here to search 2019-11-11 AutoSave on B File Home Insert w - F19. Budget Assignment - Student - v3 - Ex. Page Layout Formulas Data Review View Help 111 -A A = Wrap Test O A E Merge Center Font Calibri BI General 5 - % 8-8 Conditional Formatas Cell Formatting Table Styles G30 A B C D E Direct Materials - Commercial Standard Quantity - SQ Standard Rate SR Actual Quantity-AQ Standard Rate SR Actual Quantity -AQ Actual Rate -AR Quantity Variance Price Variance Total Variance Explanation for Quantity variance: Explanation for price variance: Direct Materials - Residential Standard Quantity - SQ Actual Quantity-AQ Actual Quantity-AQ Actual Budget Var Analysis Static and Flex Material variances Labour ... Flexible Bludget Type here to search auto save Insert Page Layout Home Formulas Data Peview View Help -11-AA - -A- Wap Test Meige a Center - Conditional Formatas Cell Formatting - Table Styles % S Splert - Format B TW - Actual Quantity-AQ Standard Rate SR Standard Cuantity Standard Rate SR Actualitate AR Quantity Variance Price Variance Total Variance Explanation for Quantity variances Explanation for price variances Material variances V ar Analysis Static and Flex Labour Actual Budget ... Flexible Budget Type here to search Home Data insert Review Help File View Page Layout Formulas - AA == - AA. SR Delete- Wap Test 3 Merge a Center Sorted $ - % 9 Conditional Formas Cell Formatting - Table Styles M BIU - K L M 11 A B C D E G Labour - Commercial 3 Actual Hours -AH 4 Actual Rate AR ActualHours - AH Standard Rate SR Standard Hours - SH Standard Rate SR Ffficiency Variance Rate Variance Total Variance 11 Explanation for Efficiency variance: Explanation for rate variance: Labour - Residential Var Analysis - State and flex Flexible Budget Material variances Labour variances Assum Type here to search de F1-Budget is gemont Student opines - O B TU 0.A- . Meige Center - S -% Conditional Formats Cell Forming Table Styles Sort & Find a Format Font A B C D E F G H I K L M N Actual Hours - All Standard Rate SR Rate Variance Efficiency Variance Explanation for Efficiency variance: Explanation for rate variance Total Flexible Budget Var Analysis Suatic and flex Material variances Labour variances Assum O Type here to search 2010-11-11 Calibri - -AN = ) Wap Test Parameters - budget Quarters 1 Year 4 Selebours): 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours 8 Selling price (S/h: 9 Selling price per hour (commercial) 10 Seling price per hour (residential 4,160 2,900 1.260 5,060 3,530 1.500 4,460 3,110 1,350 5,360 3,740 1,620 19,040 13,280 5,760 S37 S37 S37 S37 S 37 $ 48 S48 S48 S48 S48 12 Direct labour expense (S/hr): S 20 S 20 S 20 S 20 14 Cleaning Supply usage litre / labour hourl: 15 Commercial 16 Residential 0.2 0.1 0.2 0.1 0.2 0.1 0.2 0.1 Material varices variance Assumption out bane Rubrik Type here to search Auto F D 19Budget Agent Studentin Formats Data Review View File Home vert Page Layout Help fonet 14 Cleaning Supply use (litre/Inbourhou): 15 Commercial 16 Residential 0.2 0.1 0.2 0.1 0.2 0.1 0.2 0.1 18 Cleaning Supply expenses/litrell: $ 5.50 $ 5.50 S 5.50 $ 5.50 20 Fixed overhead: 21 Receptionist Depreciation 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 925 9,225 7,650 1.075 25,450 36.900 30,600 4,300 24 Office Supplies Type here to search Budget Arrigment Student P ath opinder GC Forms Data Review ViewHelp General L M N O Parameters actual Sules ( hours: Actualtolal sales Actual sales - commercial Actual sales residential Selling prices/h: Actual selling price commercial Actual selling price-residential 4,020 2,810 1,210 5.220 3,650 1,570 4,120 2.880 1.240 5,320 31,720 1.600 18,680 13,060 620 S40 S60 $10 $50 $40 $50 550 $50 SSO 18 Direct labour expense (She): S 18 S 18 S 18 Actual Cleaning Supply usage (litre/Inbour hour): Commercial Residential 0.19 0.09 0.19 0.09 0.19 0,09 0.19 0,09 sbour variance A ction Database CHING O 19-Budget Argent Student 3 Ex a ch pinderen Formulas Dan Review View Help A A Wap Tot Mega Center 3 KIM No Po $ 5.40 S 5.40 S 5.10 $ 5.40 Actus Cleaning Supply expenses/litrell: Actual Thed overhend: Receptionist Depreciation 6,010 9.225 7.300 990 5.20 9.225 7.MD 950 5,915 9,225 7.450 975 6,325 9,225 7,225 1,215 24,020 36,900 29,955 4,130 Gas Office Supplies 21,856 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,28 1,416 4,703 84,661 4,271 1,837 6,107 109,933 3,370 1.451 4,820 86,767 4,352 1.872 6,224 112,039 15,280 6575 21,856 393,401 17% 17% 17% 17%. Unproductive (unbilled) factor variantes Assumption in Database Run A 4 ENG Autosea F1-udget Assignment Studenty Data Review View top . File Home ment Page Layout Formulas Colbie AA Paide BIV2- 0-A- E Ceboards AM - X Wap Test Merge Center $ - 969 Conditional Formats Formatting Style 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 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 complete the inputs in the spreadsheets above whose tabs are highlighted in yellow). Read this first Static Budget Actual Budget Flexible Budget var Analysis Static and flex H O Type here to search toong SUPER CLEAN Operating budget for the period an Dec '18 w Quarters 7 Sales budget B Sales Commercial 9 Sales residential 10 Total sales 11 $107,300 $60,480 $167,780 $130,610 $73,440 S204,050 $115,070 $64.800 $10 0 $138,380 $72.760 $216,140 5491,360 $276,480 S767,810 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs Read this first stadiget Actus Budget Huble Budget Varalyst and Type here to search Autove Tile Home Page Layout Formulas Data e View * O SUPER CIFAN Operating budget for the period lan Dec '18 19 Labour budget 21 Residential 22 Totallabour 24 Fixed Overhead: 25 Receptionist 26 Depreciation Office Supplies 39 Total Read this first St Budget Actual Buget Hele Budget O Type here to search Home Page Layout Forma t s Review - X SUPER CLEAN Operating results for the period on Dec '18 7 Sales budget Sales Commercial 9 les residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs Actub o Verde On - O Type here to search A B F# Budget Age Studentv File Home men Page Layout Termdan Data Revien vien Help SA TUHOA Merge - $ % 91 -22 Ford Fies SUPER CLLAN Operating results for the period Dec '18 Quarters 19 Labour budget 20 Commercial 21 Residential 22 Total labour 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total Read the first Static budget Actual Budget Rexible det var Analysis and flex GE * O Type here to search 0 W A Budget Assignment Studentv X - w - -AA 11 O-A B TV E et Mese a Center - S -% Conditional Format SUPER CLEAN Flexible budget for the period lan Dec '18 Quarters 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 13 Direct material budget 14 Variable costs commercial 75 Variable costs residential 16 Total variable costs Read this first Stabic Budget Actual budget Flexible Budget - Type here to search N e w BTW - - -A- - Mega Cente SUPER CIRAN Flexible budget for the period lan Dec '18 Quarters 19 Labour budget Commercial 21 Residential 22 Total labour 23 24 Fixed Overhead: 25 Receptionist 26 Depreciation 27 Gas 28 Office Supplies 29 Total 30 Set A telier Static and flex Type here to search 9 ondersch - X AutoSave File Home Share Comments insert F19 - Budget Assignment Student P ach Page Layout Formulas Data Review View Help - - AA == Wap Test Custom - OA E Merge Center - 5 - % Delete - Conditional Formats Cell Sort Find Ideas TW - Super Clean Inc Static Budget Variance Actual for the year Static for the year Variance U/E Flexible Budget Variance Flexible for the year Variance Actual for the year 4 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 . Actual Budget Var Analysis Static and Flex variances tabour Flexible fudget . A N 6:06 PM 404 ENG 2015-11-11 Type here to search Autolave F19 - Budget Anigment Studen Such opinder C O - 0 File Home insert Data Review View Help Share Comments Page Layout Formulas -11-AA 11. 0.A- E = BTU Wie Test Merge Center - S - % 16 Labour budget 17 Commercial 18 Residential 19 Total labour 21 Fixed Overhead: 22 Receptionist 23 Depreciation 24 Gas 25 Office Supplies 26 Total Actual Budget Flexible Budget Var Analysis Static and Flex Material arunces about Type here to search 2019-11-11 AutoSave on B File Home Insert w - F19. Budget Assignment - Student - v3 - Ex. Page Layout Formulas Data Review View Help 111 -A A = Wrap Test O A E Merge Center Font Calibri BI General 5 - % 8-8 Conditional Formatas Cell Formatting Table Styles G30 A B C D E Direct Materials - Commercial Standard Quantity - SQ Standard Rate SR Actual Quantity-AQ Standard Rate SR Actual Quantity -AQ Actual Rate -AR Quantity Variance Price Variance Total Variance Explanation for Quantity variance: Explanation for price variance: Direct Materials - Residential Standard Quantity - SQ Actual Quantity-AQ Actual Quantity-AQ Actual Budget Var Analysis Static and Flex Material variances Labour ... Flexible Bludget Type here to search auto save Insert Page Layout Home Formulas Data Peview View Help -11-AA - -A- Wap Test Meige a Center - Conditional Formatas Cell Formatting - Table Styles % S Splert - Format B TW - Actual Quantity-AQ Standard Rate SR Standard Cuantity Standard Rate SR Actualitate AR Quantity Variance Price Variance Total Variance Explanation for Quantity variances Explanation for price variances Material variances V ar Analysis Static and Flex Labour Actual Budget ... Flexible Budget Type here to search Home Data insert Review Help File View Page Layout Formulas - AA == - AA. SR Delete- Wap Test 3 Merge a Center Sorted $ - % 9 Conditional Formas Cell Formatting - Table Styles M BIU - K L M 11 A B C D E G Labour - Commercial 3 Actual Hours -AH 4 Actual Rate AR ActualHours - AH Standard Rate SR Standard Hours - SH Standard Rate SR Ffficiency Variance Rate Variance Total Variance 11 Explanation for Efficiency variance: Explanation for rate variance: Labour - Residential Var Analysis - State and flex Flexible Budget Material variances Labour variances Assum Type here to search de F1-Budget is gemont Student opines - O B TU 0.A- . Meige Center - S -% Conditional Formats Cell Forming Table Styles Sort & Find a Format Font A B C D E F G H I K L M N Actual Hours - All Standard Rate SR Rate Variance Efficiency Variance Explanation for Efficiency variance: Explanation for rate variance Total Flexible Budget Var Analysis Suatic and flex Material variances Labour variances Assum O Type here to search 2010-11-11