Home insert Page Layou Intert Delore One 11 Calibri A* = A 2 Weap Text Merge Center - BIU Format $ . % *888 Conditional Formats Cell Formatting Table - Styles Styles C Number Clipboard Alignment Font 615 Parameters actual Parameters - budget Out Qur 2 2 4 600 520 5220 500 00 440 Then BUTLER Dohor Buded in 4620 2. 500 2700 19.040 11200 20 20 NO 240 15 150 Sales [hour] A Ath.com Actualid Selline Aculino Abanger 1150 411 30 falingelcome delingee perheen 1 $ 1 4. GB 30 4 411 47 1 671 ET 22 22 23 Direcrabou Cleaning Suppliesow how Com 0.24 24 82 0.24 Os Actual Cleaning upplage labour hou) Comme 022 om 022 011 011 OM 5 Actual Cleaning Supels expense 5 5 Chipsetrel 1550 550 55021 550 5 0 Fixed that Reception Depo 6 5.770 6750 9.250 7.750 20 2,750 Actel Find overhead Recept Deprecio 6760 20 7.750 27.000 37,000 1000 4800 6. 250 7.300 990 NO 2,340 NO 7450 24600 3250 37000 7275 29.365 40 750 24 Ore Spots Omeri 21656 Total no. of hours actually paid to Breakdown Commercial Residenti Actuhou worked Debout 22 453 15200 CS 4.703 4211 1917 57 14563 2310 141 4820 106,049 6224 PRO Heproductive billed lacto 17% 17 1 7% Read this first Input Database Static Budget Actual Budget Flexible Budget Var Anak KG Search for anything O Clipboard C. Merge & Center $ - % -3 Font Alignment Conditional For Formatting Table Styles F25 Ex Number f 5 Input Database 'IF21 G H B D SUPER CLEAN Operating Budget for the period Jan-Dec 18 Quarters 2 3 4 Year 610086 81.130 371.530 386.020 000 1.6 100.0 130 177,750 $276.480 3122180 1154 630 $138 330 1153 780 $581320 2 3 4 5 Sales Commercial 9 Sales residential 10 Totalles 11 12 13 Diteet material budget 15 Variable costs commercial 15 Variable costs residential 56 Total variable costs Marks 2 $3.828 +4,660 $4,105 $1,040 $1262 31 114 14.868 $5322 45219 +4,937 $17,530 $1,337 4.752 16:23 ### $81.190 71,530 $86,020 .... 0.00035 130 331 050 337,250 60010 $35.680 1116.380 12.00 $123200 1432920 18 19 Labour budget 20 Commercial 21 Residential 22 Totallabour 23 24 Fixed Overhead 25 Reception 26 Depreciation 27 Gas 28 Oifice Supplies 29 Total 30 31 32 + 16.750 6.750 16.750 $9.250 9.250 49,250 07.750 $7.750 7.750 1,12511,125 $1.125 124.875 675 324.875 16.750 627.000 59 250 000 37,750 31000 31 125 $4,500 124 825 180.500 Total 34 36 37 Flexible Body Read this first Cover page Actual Budget Static Budget Input Database Search for anything Alignment F28 Numb 'Input Database '!N24 B C 0 SUPER CLEAN Operating results for the period Uan-Dec 18 G H 2 M IN 14 Quarters 1 2 3 Year DONE $75,200 30000 $172080 $223.440 176,350 $227720 373.600 Marks 2 B Sales residential 10 Total sales 1 12 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs EHT 12 15 Labour budget 201 Commercial Residential Torallabour $3,091 $4.015 $666 *864 $3.757 $4,879 $3.168 $682 $3.850 $4,092 $14.366 +880 $3,091 $4,372317,467 $61.82000 3000 30000 $88.440 314.840 *81.840 DUBE 000 $35,200 $90,640 117,040 $410 960 + 24 Fixed Overhead: 25 Fleceptionis 20 Depreciation Gas Olice Supplies 231 Total $6.010$5.770 $5.915 3.250 39.250 9.250 $7.300 +2,940 $7450 $9.90 $950 $975 23,550 $23,990 23,530 $6.325 $24.020 89.250 $37.000 *7275 $29.365 $1.2151 $1,130 $2406.395,185 Total 10 Cover one Read this first wabe Static Budget Actual Budget Fleable Buda F 3 E SUPER CLEAN buble budget for the period Jan Dec 19 Tit 0 1 5 6 7 2 Quarters 3 4 Year Make Sales budget Sales Commercial Sales residents Total sales 80000000 $141360 1498,280 $75.360 153 520 $76.800 $269,760 324,06068860 $21816075040 11 Direct material budget Variable costs commercial Variable costs residential Total variable costs $4,818 $1.235 16 $3802 $1,023 34.825 4.910 31.320 $17.239 $4,637 Labour budget Commercial Beside Toubou 21 $63,950 $66.240 $85,560 $300,380 $36,150 $28,520 $36.800 $129.260 $120.060 194,780 3122.300 $4297640 Fixed Overhead. 25 cp 25 Depreciation 21 G Ofice Supplies 25 TORI 30 91 Total 00 se 31 Read this first Input Database Static Budget Actual Budget Flexible Budget Var Anal HE Search for anything BI Merge Center 05-30 Formatting - Clipboard Font Alignment Number 510 B 0 UF G H Super Clean Inc Static Budget Variance Flexible Budget Variance Actual for the sea Static for the ve Vallance LE Actualthebear Fleible for the sea Variance supe Cleaning Marks UIE F Sales budget Sales Commercial Sales to idential Total sales 535,460 254 140 299,600 305,440 276 480 581.920 $230,020 -$12,340 217 680 535,460 264,140 799,600 1 1 Direct material budget Vantable costs commercial Variable costs residentia Totalwariable costs 14.366 3,091 17.457 17 530 4.752 221282 $3.164 -$1,661 [4.825) F F 287,320 123 640 410.960 Labour budget Commercial Residential Totabour 287320 123 640 410 550 315 440 132.480 433.920 -$18.120 -$8,840 128 9601 U U F 287320 123.640 410,960 21 Fited Overhead Heceptionist Deprecation Gas 25 Office Supplies Total 24.020 37,000 29.965 4,130 95115 27.000 37,000 31000 4,500 99,500 -$2,980 $0 -$1,035 -$370 CCCC 24.020 37.000 29.965 4.130 95115 Total 10 29 Material varia Flexible Budget Actual Budget Var Analysis Static and Flex Static Budget O FI Search for anything General Paste Vi 25 Wrap Text U .. A. Merge & Center B $ - % Condition Formatting Clipboard Font Alignment Number 5 B22 X f D Direct Materials Corner Astutt AGB Actuate AR 0.22 2873 Actually Standard OR 1 024 3,034 Standard Osttir. Stundard : 0.24 3,181 Price V Ginty VIVES To 11 R! Explanation for Quantitat: Explanation for ptics TRASS * 17 Direct Material Revidential A ORA AR OAD SRR Standard Oury-10 Shindo-ER Price has OV Tevarian plastisala. TEA -wluati Tum Material variances Actual Budget Var Analysis - Static and Flex Flexible Budget O RI Search for anything Re Custom Paste A EBE Merge & Center $ % 218_98 Condition Formatting Clipboard Font Alignment 5 Number BS f =B3 B4 Labor Comercial Mark HAWA HOSTAR TASTER A HoursAll Standard Rate Stied HousSH Standard Rote SA 65.000 3 Vorhas Efficient Vernice Toy Vince Leplanation for Etfcicacy Tariance Laplanation for at talase Labour - Residential Arew PAR Actus How AH Stud Rae SR Stand How Sud RSA Ryo Ya Eli Vari Total Vis Explanation for the USA Explisation Contace: Tot Flexible Budget War Analysis Static and flex Material variances Labour variances Rubric Home insert Page Layou Intert Delore One 11 Calibri A* = A 2 Weap Text Merge Center - BIU Format $ . % *888 Conditional Formats Cell Formatting Table - Styles Styles C Number Clipboard Alignment Font 615 Parameters actual Parameters - budget Out Qur 2 2 4 600 520 5220 500 00 440 Then BUTLER Dohor Buded in 4620 2. 500 2700 19.040 11200 20 20 NO 240 15 150 Sales [hour] A Ath.com Actualid Selline Aculino Abanger 1150 411 30 falingelcome delingee perheen 1 $ 1 4. GB 30 4 411 47 1 671 ET 22 22 23 Direcrabou Cleaning Suppliesow how Com 0.24 24 82 0.24 Os Actual Cleaning upplage labour hou) Comme 022 om 022 011 011 OM 5 Actual Cleaning Supels expense 5 5 Chipsetrel 1550 550 55021 550 5 0 Fixed that Reception Depo 6 5.770 6750 9.250 7.750 20 2,750 Actel Find overhead Recept Deprecio 6760 20 7.750 27.000 37,000 1000 4800 6. 250 7.300 990 NO 2,340 NO 7450 24600 3250 37000 7275 29.365 40 750 24 Ore Spots Omeri 21656 Total no. of hours actually paid to Breakdown Commercial Residenti Actuhou worked Debout 22 453 15200 CS 4.703 4211 1917 57 14563 2310 141 4820 106,049 6224 PRO Heproductive billed lacto 17% 17 1 7% Read this first Input Database Static Budget Actual Budget Flexible Budget Var Anak KG Search for anything O Clipboard C. Merge & Center $ - % -3 Font Alignment Conditional For Formatting Table Styles F25 Ex Number f 5 Input Database 'IF21 G H B D SUPER CLEAN Operating Budget for the period Jan-Dec 18 Quarters 2 3 4 Year 610086 81.130 371.530 386.020 000 1.6 100.0 130 177,750 $276.480 3122180 1154 630 $138 330 1153 780 $581320 2 3 4 5 Sales Commercial 9 Sales residential 10 Totalles 11 12 13 Diteet material budget 15 Variable costs commercial 15 Variable costs residential 56 Total variable costs Marks 2 $3.828 +4,660 $4,105 $1,040 $1262 31 114 14.868 $5322 45219 +4,937 $17,530 $1,337 4.752 16:23 ### $81.190 71,530 $86,020 .... 0.00035 130 331 050 337,250 60010 $35.680 1116.380 12.00 $123200 1432920 18 19 Labour budget 20 Commercial 21 Residential 22 Totallabour 23 24 Fixed Overhead 25 Reception 26 Depreciation 27 Gas 28 Oifice Supplies 29 Total 30 31 32 + 16.750 6.750 16.750 $9.250 9.250 49,250 07.750 $7.750 7.750 1,12511,125 $1.125 124.875 675 324.875 16.750 627.000 59 250 000 37,750 31000 31 125 $4,500 124 825 180.500 Total 34 36 37 Flexible Body Read this first Cover page Actual Budget Static Budget Input Database Search for anything Alignment F28 Numb 'Input Database '!N24 B C 0 SUPER CLEAN Operating results for the period Uan-Dec 18 G H 2 M IN 14 Quarters 1 2 3 Year DONE $75,200 30000 $172080 $223.440 176,350 $227720 373.600 Marks 2 B Sales residential 10 Total sales 1 12 13 Direct material budget 14 Variable costs commercial 15 Variable costs residential 16 Total variable costs EHT 12 15 Labour budget 201 Commercial Residential Torallabour $3,091 $4.015 $666 *864 $3.757 $4,879 $3.168 $682 $3.850 $4,092 $14.366 +880 $3,091 $4,372317,467 $61.82000 3000 30000 $88.440 314.840 *81.840 DUBE 000 $35,200 $90,640 117,040 $410 960 + 24 Fixed Overhead: 25 Fleceptionis 20 Depreciation Gas Olice Supplies 231 Total $6.010$5.770 $5.915 3.250 39.250 9.250 $7.300 +2,940 $7450 $9.90 $950 $975 23,550 $23,990 23,530 $6.325 $24.020 89.250 $37.000 *7275 $29.365 $1.2151 $1,130 $2406.395,185 Total 10 Cover one Read this first wabe Static Budget Actual Budget Fleable Buda F 3 E SUPER CLEAN buble budget for the period Jan Dec 19 Tit 0 1 5 6 7 2 Quarters 3 4 Year Make Sales budget Sales Commercial Sales residents Total sales 80000000 $141360 1498,280 $75.360 153 520 $76.800 $269,760 324,06068860 $21816075040 11 Direct material budget Variable costs commercial Variable costs residential Total variable costs $4,818 $1.235 16 $3802 $1,023 34.825 4.910 31.320 $17.239 $4,637 Labour budget Commercial Beside Toubou 21 $63,950 $66.240 $85,560 $300,380 $36,150 $28,520 $36.800 $129.260 $120.060 194,780 3122.300 $4297640 Fixed Overhead. 25 cp 25 Depreciation 21 G Ofice Supplies 25 TORI 30 91 Total 00 se 31 Read this first Input Database Static Budget Actual Budget Flexible Budget Var Anal HE Search for anything BI Merge Center 05-30 Formatting - Clipboard Font Alignment Number 510 B 0 UF G H Super Clean Inc Static Budget Variance Flexible Budget Variance Actual for the sea Static for the ve Vallance LE Actualthebear Fleible for the sea Variance supe Cleaning Marks UIE F Sales budget Sales Commercial Sales to idential Total sales 535,460 254 140 299,600 305,440 276 480 581.920 $230,020 -$12,340 217 680 535,460 264,140 799,600 1 1 Direct material budget Vantable costs commercial Variable costs residentia Totalwariable costs 14.366 3,091 17.457 17 530 4.752 221282 $3.164 -$1,661 [4.825) F F 287,320 123 640 410.960 Labour budget Commercial Residential Totabour 287320 123 640 410 550 315 440 132.480 433.920 -$18.120 -$8,840 128 9601 U U F 287320 123.640 410,960 21 Fited Overhead Heceptionist Deprecation Gas 25 Office Supplies Total 24.020 37,000 29.965 4,130 95115 27.000 37,000 31000 4,500 99,500 -$2,980 $0 -$1,035 -$370 CCCC 24.020 37.000 29.965 4.130 95115 Total 10 29 Material varia Flexible Budget Actual Budget Var Analysis Static and Flex Static Budget O FI Search for anything General Paste Vi 25 Wrap Text U .. A. Merge & Center B $ - % Condition Formatting Clipboard Font Alignment Number 5 B22 X f D Direct Materials Corner Astutt AGB Actuate AR 0.22 2873 Actually Standard OR 1 024 3,034 Standard Osttir. Stundard : 0.24 3,181 Price V Ginty VIVES To 11 R! Explanation for Quantitat: Explanation for ptics TRASS * 17 Direct Material Revidential A ORA AR OAD SRR Standard Oury-10 Shindo-ER Price has OV Tevarian plastisala. TEA -wluati Tum Material variances Actual Budget Var Analysis - Static and Flex Flexible Budget O RI Search for anything Re Custom Paste A EBE Merge & Center $ % 218_98 Condition Formatting Clipboard Font Alignment 5 Number BS f =B3 B4 Labor Comercial Mark HAWA HOSTAR TASTER A HoursAll Standard Rate Stied HousSH Standard Rote SA 65.000 3 Vorhas Efficient Vernice Toy Vince Leplanation for Etfcicacy Tariance Laplanation for at talase Labour - Residential Arew PAR Actus How AH Stud Rae SR Stand How Sud RSA Ryo Ya Eli Vari Total Vis Explanation for the USA Explisation Contace: Tot Flexible Budget War Analysis Static and flex Material variances Labour variances Rubric