F20 - Budget Assignment - Student - v5 - Excel Fas Home Insert Draw Page Layout juhi kewan Formulas Data Review View Help Tell me what you want to do ac Calibri ab Gustom Conditional Formatting B 1 U. A My Insert A 30 % Formats Table Delete FE > Clipboard 1:27 Coll Styles Fom Format Alignment Number BS X f Styles B F G H 1 2 3 D E SUPER CLEAN Operating Budget for the period Jan - Dec '18 4 5 1 Quarters 3 2 4 Year Marks 2 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 11 12 13 Direct material budget 14 Variable costs commercial 10 Marblancoidostal Cover page Read this first 2 Static Budget Actual Budget Hexible Budget Var Analysis Search D da ENG Un Page Layout Formulas Da Review View u khes Help Telme what you want to do Colbe 11 Custom B U. A A NO Me hart Conditional Forming Format ustable CS 828 . Delete Bibowo Font B25 Sy B 1 G D SUPER CLEAN Operating results for the period lan - Dec '18 2 3 H 1 Quarters 3 2 4 Year Marks 4 5 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 11 12 13 Direct material budget 14 Variable costs commercial Nicotia Come page Statist Actual Budget Herbliget Vw - Search ENG TEOS 24-11-20 Home int Judith Draw Page Layout Femmes Det F20. Budget Astigan State-5-face May Wew Help Tome you want to de Gardinom Share C wat- P U- A 9 Fortalable Date ting . Patstyles Kort A14 Variable costs B F G H 1 D E SUPER CLEAN Flexible budget for the period Jan Dec '18 NM 4 Quarters 3 1 2 4 Year Marks 5 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 Coverage State Buget Actual Fleable budet Valt 110 o BI Search 00 IME The Home Inert D Page Layout ja kwa 720 - Ridget Art Student Excel Hely Old me what you want to do ET Fonds Date X B p 1 U-A Conditional foming Fom A Delete A Style yes co F G B C D E Super Clean Inc Static Budget Variance Actual for the year Static for the year Variance UZE Flexible Budget Variance Actual for the year flexible for the year Vari 1 2 3 4 Sales budget 5 Sales Commercial 6 Sales residential 7 Total sales B 9 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs Fridge Varis Static and la Search 144 es 09 NE X Calibri 11 B 1 Paste U- A A Clipboard 15 Font Alignmen G26 D E B C Parameters - budget Quarters 3 1 2 4 Year 4,160 2,900 1,260 5,060 3,530 1.530 4,460 3,110 1,350 5,360 3,740 1,620 A 1 2. 3 4 Sales (hours: 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours 3 Selling price (S/hr): 9 selling price per hour commercial) 10 Selling price per hour (residential) 12 Direct labour expense(/hr 13 14 Cleaning Supplyser litre / labour hour 15 Commercial 16 Residential 19,040 13,280 5,760 37 $ $ 37 $ 48 S 37 $ 48. $ 37 S 18 S 37 S 49 $ $ 22$ 22 S 22 $ 22 0.25 0.25 0.15 0.25 0.15 0.15 0.25 0.15 5 5.505 5.505 5.50 S 5.50 6,367 18 Cleaning Supply expenses/litre)) 19 20 Fed overhead: 21 Receptionist 22 Depreciation 23 Gas 24 Offior Supplies 25 26 27 6,163 9.225 7,650 1.075 6363 9,225 7.650 1,075 6,363 9,225 7,650 1,025 7,650 1,073 25.450 36,500 30.000 4.100 Input Database Rubric Search o % Format as Table 60 200 00 -0 Cell Styles Alignment Number Styles M N P Parameters - actual Quarters 2 1 $ 4 Year Sales (hours Actual total sales Actual sales - commercial Actual sales residential Selling prices/h) Actual selline 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 3,720 1,600 18,680 13,060 5,620 540 550 $40 $50 $40 $50 S40 $50 $40 $50 22 22 Direct labour expenses Aceaning Supply petre/abour hour Commercial Residential 0.22 0:11 0.22 011 0.22 0.11 022 0.11 Acts Clean Supply expenses/litre 5 5 5 5 Actualled 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,335 9,225 7,275 1.215 24,020 36,900 22,965 4,130 20.361 Tuttofondemees Beedom Commercial 3,063 3130 1919 1,979 12:1 560 1,25.176 4,055 1.744 5. 127,52 14, 235 126 20:36 but about $401 96.400 9 a F20 - Budget Assignment - Student - v5 - Excel Fas Home Insert Draw Page Layout juhi kewan Formulas Data Review View Help Tell me what you want to do ac Calibri ab Gustom Conditional Formatting B 1 U. A My Insert A 30 % Formats Table Delete FE > Clipboard 1:27 Coll Styles Fom Format Alignment Number BS X f Styles B F G H 1 2 3 D E SUPER CLEAN Operating Budget for the period Jan - Dec '18 4 5 1 Quarters 3 2 4 Year Marks 2 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 11 12 13 Direct material budget 14 Variable costs commercial 10 Marblancoidostal Cover page Read this first 2 Static Budget Actual Budget Hexible Budget Var Analysis Search D da ENG Un Page Layout Formulas Da Review View u khes Help Telme what you want to do Colbe 11 Custom B U. A A NO Me hart Conditional Forming Format ustable CS 828 . Delete Bibowo Font B25 Sy B 1 G D SUPER CLEAN Operating results for the period lan - Dec '18 2 3 H 1 Quarters 3 2 4 Year Marks 4 5 6 7 Sales budget 8 Sales Commercial 9 Sales residential 10 Total sales 11 12 13 Direct material budget 14 Variable costs commercial Nicotia Come page Statist Actual Budget Herbliget Vw - Search ENG TEOS 24-11-20 Home int Judith Draw Page Layout Femmes Det F20. Budget Astigan State-5-face May Wew Help Tome you want to de Gardinom Share C wat- P U- A 9 Fortalable Date ting . Patstyles Kort A14 Variable costs B F G H 1 D E SUPER CLEAN Flexible budget for the period Jan Dec '18 NM 4 Quarters 3 1 2 4 Year Marks 5 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 Coverage State Buget Actual Fleable budet Valt 110 o BI Search 00 IME The Home Inert D Page Layout ja kwa 720 - Ridget Art Student Excel Hely Old me what you want to do ET Fonds Date X B p 1 U-A Conditional foming Fom A Delete A Style yes co F G B C D E Super Clean Inc Static Budget Variance Actual for the year Static for the year Variance UZE Flexible Budget Variance Actual for the year flexible for the year Vari 1 2 3 4 Sales budget 5 Sales Commercial 6 Sales residential 7 Total sales B 9 10 Direct material budget 11 Variable costs commercial 12 Variable costs residential 13 Total variable costs Fridge Varis Static and la Search 144 es 09 NE X Calibri 11 B 1 Paste U- A A Clipboard 15 Font Alignmen G26 D E B C Parameters - budget Quarters 3 1 2 4 Year 4,160 2,900 1,260 5,060 3,530 1.530 4,460 3,110 1,350 5,360 3,740 1,620 A 1 2. 3 4 Sales (hours: 5 Budgeted total sales in hours 6 Budgeted commercial sales in hours 7 Budgeted residential sales in hours 3 Selling price (S/hr): 9 selling price per hour commercial) 10 Selling price per hour (residential) 12 Direct labour expense(/hr 13 14 Cleaning Supplyser litre / labour hour 15 Commercial 16 Residential 19,040 13,280 5,760 37 $ $ 37 $ 48 S 37 $ 48. $ 37 S 18 S 37 S 49 $ $ 22$ 22 S 22 $ 22 0.25 0.25 0.15 0.25 0.15 0.15 0.25 0.15 5 5.505 5.505 5.50 S 5.50 6,367 18 Cleaning Supply expenses/litre)) 19 20 Fed overhead: 21 Receptionist 22 Depreciation 23 Gas 24 Offior Supplies 25 26 27 6,163 9.225 7,650 1.075 6363 9,225 7.650 1,075 6,363 9,225 7,650 1,025 7,650 1,073 25.450 36,500 30.000 4.100 Input Database Rubric Search o % Format as Table 60 200 00 -0 Cell Styles Alignment Number Styles M N P Parameters - actual Quarters 2 1 $ 4 Year Sales (hours Actual total sales Actual sales - commercial Actual sales residential Selling prices/h) Actual selline 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 3,720 1,600 18,680 13,060 5,620 540 550 $40 $50 $40 $50 S40 $50 $40 $50 22 22 Direct labour expenses Aceaning Supply petre/abour hour Commercial Residential 0.22 0:11 0.22 011 0.22 0.11 022 0.11 Acts Clean Supply expenses/litre 5 5 5 5 Actualled 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,335 9,225 7,275 1.215 24,020 36,900 22,965 4,130 20.361 Tuttofondemees Beedom Commercial 3,063 3130 1919 1,979 12:1 560 1,25.176 4,055 1.744 5. 127,52 14, 235 126 20:36 but about $401 96.400 9 a