B D E F G r 1 M N D D R S T n V w Year 1 55.000 55,000 Year 55.000 Year 55,000 Years 55.000 Year 55,000 Yuar? 55 000 525 395 (10/0001 110,000 Inc ! (10/0 110,000 (1070) 110,000 ) 110.000 1,100 550 $ 1 Golfo Variance Problem 2 3 New club volume 4 New club price $ 5 New club VMC $ 6 7 Premchub volume 8 Premchubpre $ 9 Premchub VMC 10 21 Dsc dub velime 2 Disc dub price 12 $ 13 Dis du VMC $ 14 75 Sales 16 VMC 17 Fbed Costs 18 Deprawie 12.000 12,000 12.000 00021 120003 12,000 COZI 410 185 $ S $ 19.2950 $ 39,295700 17.445,00 $ 17,445.000 $ 9,200,000 $ 9,200,000 $ 4,200,000 $ 4200000 $ $ $ 19295.00$ 39,295,000 S 99295.00 $ $ 17,445,000 $ 17,445,000 $ 17,445.000 $ 9200.000 $ 9.200,000 $ 9,200,000 $ 4200,000 4,200,000 $ 4200,000 $ HAYVOUS 3350,000 3.399,000 $ 3350,000 5.070,000 $ 5.070,000 $ 5.070,000 $ 19.295,000 $ 17.445,000 $ 9,200,000 $ 4,200,000 $ HASILOCOS 3.390,000 $ 5.070,000 $ 39.295 150 17,445,000 9,200.000 4,200 2.450 5 An1 5 KOLAR 5 S000 EUR $ $ $ 5 5 000AVR S COCOD E $ OCO OBEE 20 Taxes 21 N 3.390,000 $ 5,070,000 $ 3,350.000 5,070,000 $ $ 5,070,000 Le 4200 4.2015 1200/000 1,20KO 200003 1,200 $ 4.2011 $ Deprecatre 24 Capital Expendture S NAC 20 Total Cash Flow $ (29A00/0001 11.400,000 CHU NOVOUS $ S y2/0/000S 9.2000 Sy2000 $ 1,400 DO 9.22,00 S 1007 $ 9.2X100 S 92/000S 3 28 NPVA 10% IRR Perbeck 15,00.653.81 22.46% 3.32 Years 30 32 EE G H M N 0 P a R 5 U v Y W Sales Variance Actual Year 1 55.000 Variance Total S Volume Price Sum Bucact Units Price Sal SM $5,000 $225 $ 45,375 65,000 $1,100 $71,500 112,000 $ 410 $ 45,920 $ 232,000 $701.70 162,795 Actual Units Price Sals SM 55.000 5 825 $ 45,375 GO,000 $ 1.000 $ 60,000 120,000 S 420 $50,400 $ S 235.000 662.87 155,775 $ New clubs Premium clubs Disc Clubs Total $ $ 825 400 60,000 VMC Variance $ 1,000 $ 665 Variance Total $ Volume Price MA Sum B C 1 Galica Variance Problem 2 Total Budget 3 a Year 1 4 New club volume 55,000 5 New club price S 825 6 New club VMC S 395 7 8 Promcluh Volume 55,000 9 Prom club orice $ 1,100 10 Premclub VMC $ 650 11 12 Disc club valume 112 ano 13 Disclub price $ 410 14 Disc club VMC $ 185 15 16 Total Units 232,000 17 118 $ Sales Sper Unit 19 Sales $ 162,795,000 100.00% 5 701.70 - MY $ 84,695,000 52.03% $ 365.06 21 Gross Profit $ 78,100,000 47.97% 5 336.64 22 Fixed Costs $ 24,200,000 14.87 $ 104.31 23 Depreciation $ 23,700.000 14.568 $ 102.16 4 FRIT $ 30,200,000 18.555 $ 130.17 25 Tares 405 $ 17,000,000 7.47% $ 52.07 26 NI $ 10,120,000 11.13%. $ 78.10 Bucat Units Var Cast WMCSM 55,000 $ 395 $ 21,725 65,000 $ 650 $42,250 112,000 $185 $ 20,720 $ 232,000 $365.06 84,695 120,000 New clubs Premium clubs Disc. Clubs Total Actual Var Cost VCSM 55,000 $ 400 $ 22,000 60,000 $ 665 $39,900 120,000 $ 190 $ 22.800 235,00a $ 350,43 84,700 420 $ $ $ 190 235,000 Due To: He Volume Mix Tale $ $ 155,775,000 84,700,000 $ 71,075,000 $ 24,500,000 $ 23,500,000 $ 23,075,000 $ 1,230,000 $ 13,845,000 X Sales Ser Unit 100.00% 6 662.87 54.375 $ 360.13 45.63% $ 302.45 15.73% $ 104.26 15.095 $ 100.00 14.81% $ 98.19 5.93% $39.28 8.89$ 58.91 Sales VMC Grass Profit Fixed Costs Depreciation EBIT Tanes NI 15.000 5 17,0201 $ 151 $ 17,025) $ (300) $ 200 $ 17.125 $ 2,850 $ $ ) 14,275 28 29 30 31 22 23 B D E F G r 1 M N D D R S T n V w Year 1 55.000 55,000 Year 55.000 Year 55,000 Years 55.000 Year 55,000 Yuar? 55 000 525 395 (10/0001 110,000 Inc ! (10/0 110,000 (1070) 110,000 ) 110.000 1,100 550 $ 1 Golfo Variance Problem 2 3 New club volume 4 New club price $ 5 New club VMC $ 6 7 Premchub volume 8 Premchubpre $ 9 Premchub VMC 10 21 Dsc dub velime 2 Disc dub price 12 $ 13 Dis du VMC $ 14 75 Sales 16 VMC 17 Fbed Costs 18 Deprawie 12.000 12,000 12.000 00021 120003 12,000 COZI 410 185 $ S $ 19.2950 $ 39,295700 17.445,00 $ 17,445.000 $ 9,200,000 $ 9,200,000 $ 4,200,000 $ 4200000 $ $ $ 19295.00$ 39,295,000 S 99295.00 $ $ 17,445,000 $ 17,445,000 $ 17,445.000 $ 9200.000 $ 9.200,000 $ 9,200,000 $ 4200,000 4,200,000 $ 4200,000 $ HAYVOUS 3350,000 3.399,000 $ 3350,000 5.070,000 $ 5.070,000 $ 5.070,000 $ 19.295,000 $ 17.445,000 $ 9,200,000 $ 4,200,000 $ HASILOCOS 3.390,000 $ 5.070,000 $ 39.295 150 17,445,000 9,200.000 4,200 2.450 5 An1 5 KOLAR 5 S000 EUR $ $ $ 5 5 000AVR S COCOD E $ OCO OBEE 20 Taxes 21 N 3.390,000 $ 5,070,000 $ 3,350.000 5,070,000 $ $ 5,070,000 Le 4200 4.2015 1200/000 1,20KO 200003 1,200 $ 4.2011 $ Deprecatre 24 Capital Expendture S NAC 20 Total Cash Flow $ (29A00/0001 11.400,000 CHU NOVOUS $ S y2/0/000S 9.2000 Sy2000 $ 1,400 DO 9.22,00 S 1007 $ 9.2X100 S 92/000S 3 28 NPVA 10% IRR Perbeck 15,00.653.81 22.46% 3.32 Years 30 32 EE G H M N 0 P a R 5 U v Y W Sales Variance Actual Year 1 55.000 Variance Total S Volume Price Sum Bucact Units Price Sal SM $5,000 $225 $ 45,375 65,000 $1,100 $71,500 112,000 $ 410 $ 45,920 $ 232,000 $701.70 162,795 Actual Units Price Sals SM 55.000 5 825 $ 45,375 GO,000 $ 1.000 $ 60,000 120,000 S 420 $50,400 $ S 235.000 662.87 155,775 $ New clubs Premium clubs Disc Clubs Total $ $ 825 400 60,000 VMC Variance $ 1,000 $ 665 Variance Total $ Volume Price MA Sum B C 1 Galica Variance Problem 2 Total Budget 3 a Year 1 4 New club volume 55,000 5 New club price S 825 6 New club VMC S 395 7 8 Promcluh Volume 55,000 9 Prom club orice $ 1,100 10 Premclub VMC $ 650 11 12 Disc club valume 112 ano 13 Disclub price $ 410 14 Disc club VMC $ 185 15 16 Total Units 232,000 17 118 $ Sales Sper Unit 19 Sales $ 162,795,000 100.00% 5 701.70 - MY $ 84,695,000 52.03% $ 365.06 21 Gross Profit $ 78,100,000 47.97% 5 336.64 22 Fixed Costs $ 24,200,000 14.87 $ 104.31 23 Depreciation $ 23,700.000 14.568 $ 102.16 4 FRIT $ 30,200,000 18.555 $ 130.17 25 Tares 405 $ 17,000,000 7.47% $ 52.07 26 NI $ 10,120,000 11.13%. $ 78.10 Bucat Units Var Cast WMCSM 55,000 $ 395 $ 21,725 65,000 $ 650 $42,250 112,000 $185 $ 20,720 $ 232,000 $365.06 84,695 120,000 New clubs Premium clubs Disc. Clubs Total Actual Var Cost VCSM 55,000 $ 400 $ 22,000 60,000 $ 665 $39,900 120,000 $ 190 $ 22.800 235,00a $ 350,43 84,700 420 $ $ $ 190 235,000 Due To: He Volume Mix Tale $ $ 155,775,000 84,700,000 $ 71,075,000 $ 24,500,000 $ 23,500,000 $ 23,075,000 $ 1,230,000 $ 13,845,000 X Sales Ser Unit 100.00% 6 662.87 54.375 $ 360.13 45.63% $ 302.45 15.73% $ 104.26 15.095 $ 100.00 14.81% $ 98.19 5.93% $39.28 8.89$ 58.91 Sales VMC Grass Profit Fixed Costs Depreciation EBIT Tanes NI 15.000 5 17,0201 $ 151 $ 17,025) $ (300) $ 200 $ 17.125 $ 2,850 $ $ ) 14,275 28 29 30 31 22 23