GolfCo Variance Problem Total Budget Year 1 55,000 Actual Year 1 55,000 New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $ 1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc Clubs Total $ $ 825 400 65,000 60,000 Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $ 42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $360 43 84,700 112,000 New clubs Premium clubs Disc Clubs Total 120,000 2 Disc club volume Disc club price Disc club VMC 410 $ 420 $ $ 185 $ 190 Total Units 232,000 235,000 Due To Volume Rate Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000 Sales $ per Unit 100 00 $ 701 70 52 03 $ 365 06 47 97 $ 336 64 14 87 $ 104 31 14 56 $ 102 16 18 55 $ 130 17 7 42 $ 52 07 11 13 $ 78 10 $ $ 155,775,000 $ 84,700,000 $ 71,075,000 $ 24,500,000 $ 23,500,000 $ 23,075,000 $ 9,230,000 $ 13,845,000 Sales $ per Unit 100 00 $ 662 87 54 37 $ 360 43 45 63 $ 302 45 15 73 $ 104 26 15 09 $ 100 00 14 81 $ 98 19 5 93 $ 39 28 8 89 $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ $ $ $ $ $ ($000's) (7,020) (5) (7,025) (300) 200 (7,125) 2,850 (4,275) 40 Taxes Taxes NI NI GolfCo Variance Problem Sales Variance Total Budget Year 1 55,000 Actual Year 1 55,000 Variance Total $ Volume Price Mix Sum New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc Clubs Total $ $ 825 400 65,000 60,000 VMC Variance Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Variance Total $ Volume Price Mix Sum Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $ 360 43 84,700 112,000 New clubs Premium clubs Disc Clubs Total 120,000 Disc club volume Disc club price Disc club VMC 420 nin $ $ 410 185 $ $ 190 Total Units 232,000 235,000 Due To Volume Rate Mix Total Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000 Sales $ per Unit 100 00 $ 701 70 52 03 $ 365 06 47 97 $ 336 64 14 87 $ 104 31 14 56 $ 102 16 18 55 $ 130 17 7 42 $ 52 07 11 13 $ 78 10 $ $ $ $ $ $ $ $ $ 155,775,000 84,700,000 71,075,000 24,500,000 23,500,000 23,075,000 9,230,000 13,845,000 Sales $ per Unit 100 00 $ 662 87 54 37 $ 360 43 45 63 $ 302 45 15 73 $ 104 26 15 09 $ 100 00 14 81 $ 98 19 5 93 $ 39 28 8 89 $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $000's) $ (7,020) $ (5) $ (7,025) $ (300) $ 200 $ (7,125) $ 2,850 $ (4,275) Taxes 40 Taxes NI NI GolfCo Variance Problem Total Budget Year 1 55,000 Actual Year 1 55,000 New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $ 1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc Clubs Total $ $ 825 400 65,000 60,000 Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $ 42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $360 43 84,700 112,000 New clubs Premium clubs Disc Clubs Total 120,000 2 Disc club volume Disc club price Disc club VMC 410 $ 420 $ $ 185 $ 190 Total Units 232,000 235,000 Due To Volume Rate Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000 Sales $ per Unit 100 00 $ 701 70 52 03 $ 365 06 47 97 $ 336 64 14 87 $ 104 31 14 56 $ 102 16 18 55 $ 130 17 7 42 $ 52 07 11 13 $ 78 10 $ $ 155,775,000 $ 84,700,000 $ 71,075,000 $ 24,500,000 $ 23,500,000 $ 23,075,000 $ 9,230,000 $ 13,845,000 Sales $ per Unit 100 00 $ 662 87 54 37 $ 360 43 45 63 $ 302 45 15 73 $ 104 26 15 09 $ 100 00 14 81 $ 98 19 5 93 $ 39 28 8 89 $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ $ $ $ $ $ ($000's) (7,020) (5) (7,025) (300) 200 (7,125) 2,850 (4,275) 40 Taxes Taxes NI NI GolfCo Variance Problem Sales Variance Total Budget Year 1 55,000 Actual Year 1 55,000 Variance Total $ Volume Price Mix Sum New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc Clubs Total $ $ 825 400 65,000 60,000 VMC Variance Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Variance Total $ Volume Price Mix Sum Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $ 360 43 84,700 112,000 New clubs Premium clubs Disc Clubs Total 120,000 Disc club volume Disc club price Disc club VMC 420 nin $ $ 410 185 $ $ 190 Total Units 232,000 235,000 Due To Volume Rate Mix Total Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000 Sales $ per Unit 100 00 $ 701 70 52 03 $ 365 06 47 97 $ 336 64 14 87 $ 104 31 14 56 $ 102 16 18 55 $ 130 17 7 42 $ 52 07 11 13 $ 78 10 $ $ $ $ $ $ $ $ $ 155,775,000 84,700,000 71,075,000 24,500,000 23,500,000 23,075,000 9,230,000 13,845,000 Sales $ per Unit 100 00 $ 662 87 54 37 $ 360 43 45 63 $ 302 45 15 73 $ 104 26 15 09 $ 100 00 14 81 $ 98 19 5 93 $ 39 28 8 89 $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $000's) $ (7,020) $ (5) $ (7,025) $ (300) $ 200 $ (7,125) $ 2,850 $ (4,275) Taxes 40 Taxes NI NI

Question

GolfCo Variance Problem Total Budget Year 1 55,000 Actual Year 1 55,000 New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $ 1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc  Clubs Total $ $ 825 400 65,000 60,000 Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $ 42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $360 43 84,700 112,000 New clubs Premium clubs Disc  Clubs Total 120,000 2 Disc club volume Disc club price Disc club VMC 410 $ 420 $ $ 185 $ 190 Total Units 232,000 235,000 Due To  Volume Rate Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000   Sales $ per Unit 100 00  $ 701 70 52 03  $ 365 06 47 97  $ 336 64 14 87  $ 104 31 14 56  $ 102 16 18 55  $ 130 17 7 42  $ 52 07 11 13  $ 78 10 $ $ 155,775,000 $ 84,700,000 $ 71,075,000 $ 24,500,000 $ 23,500,000 $ 23,075,000 $ 9,230,000 $ 13,845,000   Sales $ per Unit 100 00  $ 662 87 54 37  $ 360 43 45 63  $ 302 45 15 73  $ 104 26 15 09  $ 100 00 14 81  $ 98 19 5 93  $ 39 28 8 89  $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ $ $ $ $ $ ($000's) (7,020) (5) (7,025) (300) 200 (7,125) 2,850 (4,275) 40  Taxes Taxes NI NI GolfCo Variance Problem Sales Variance Total Budget Year 1 55,000 Actual Year 1 55,000 Variance Total $ Volume Price Mix Sum New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc  Clubs Total $ $ 825 400 65,000 60,000 VMC Variance Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Variance Total $ Volume Price Mix Sum Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $ 360 43 84,700 112,000 New clubs Premium clubs Disc  Clubs Total 120,000 Disc club volume Disc club price Disc club VMC 420 nin $ $ 410 185 $ $ 190 Total Units 232,000 235,000 Due To  Volume Rate Mix Total Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000   Sales $ per Unit 100 00  $ 701 70 52 03  $ 365 06 47 97  $ 336 64 14 87  $ 104 31 14 56  $ 102 16 18 55  $ 130 17 7 42  $ 52 07 11 13  $ 78 10 $ $ $ $ $ $ $ $ $ 155,775,000 84,700,000 71,075,000 24,500,000 23,500,000 23,075,000 9,230,000 13,845,000   Sales $ per Unit 100 00  $ 662 87 54 37  $ 360 43 45 63  $ 302 45 15 73  $ 104 26 15 09  $ 100 00 14 81  $ 98 19 5 93  $ 39 28 8 89  $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $000's) $ (7,020) $ (5) $ (7,025) $ (300) $ 200 $ (7,125) $ 2,850 $ (4,275) Taxes 40  Taxes NI NI GolfCo Variance Problem Total Budget Year 1 55,000 Actual Year 1 55,000 New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $ 1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc  Clubs Total $ $ 825 400 65,000 60,000 Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $ 42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $360 43 84,700 112,000 New clubs Premium clubs Disc  Clubs Total 120,000 2 Disc club volume Disc club price Disc club VMC 410 $ 420 $ $ 185 $ 190 Total Units 232,000 235,000 Due To  Volume Rate Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000   Sales $ per Unit 100 00  $ 701 70 52 03  $ 365 06 47 97  $ 336 64 14 87  $ 104 31 14 56  $ 102 16 18 55  $ 130 17 7 42  $ 52 07 11 13  $ 78 10 $ $ 155,775,000 $ 84,700,000 $ 71,075,000 $ 24,500,000 $ 23,500,000 $ 23,075,000 $ 9,230,000 $ 13,845,000   Sales $ per Unit 100 00  $ 662 87 54 37  $ 360 43 45 63  $ 302 45 15 73  $ 104 26 15 09  $ 100 00 14 81  $ 98 19 5 93  $ 39 28 8 89  $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ $ $ $ $ $ ($000's) (7,020) (5) (7,025) (300) 200 (7,125) 2,850 (4,275) 40  Taxes Taxes NI NI GolfCo Variance Problem Sales Variance Total Budget Year 1 55,000 Actual Year 1 55,000 Variance Total $ Volume Price Mix Sum New club volume New club price New club VMC Budget Units Price Sales $M 55,000 $ 825 $ 45,375 65,000 $ 1,100 $ 71,500 112,000 $ 410 $ 45,920 232,000 $ 701 70 162,795 Actual Units Price Sales $M 55,000 $ 825 $ 45,375 60,000 $1,000 $ 60,000 120,000 $ 420 $ 50,400 235,000 $ 662 87 155,775 $ $ 825 395 New clubs Premium clubs Disc  Clubs Total $ $ 825 400 65,000 60,000 VMC Variance Prem club Volume Prem club price Prem club VMC $ 1,100 $ 650 $ 1,000 $ 665 Variance Total $ Volume Price Mix Sum Budget Units Var Cost VMC $M 55,000 $ 395 $ 21,725 65,000 $ 650 $42,250 112,000 $ 185 $ 20,720 232,000 $365 06 84,695 Actual Units Var Cost VMC $M 55,000 $ 400 $ 22,000 60,000 $ 665 $ 39,900 120,000 $ 190 $ 22,800 235,000 $ 360 43 84,700 112,000 New clubs Premium clubs Disc  Clubs Total 120,000 Disc club volume Disc club price Disc club VMC 420 nin $ $ 410 185 $ $ 190 Total Units 232,000 235,000 Due To  Volume Rate Mix Total Sales VMC Gross Profit Fixed Costs Depreciation EBIT $ $ 162,795,000 $ 84,695,000 $ 78,100,000 $ 24,200,000 $ 23,700,000 $ 30,200,000 $ 12,080,000 $ 18,120,000   Sales $ per Unit 100 00  $ 701 70 52 03  $ 365 06 47 97  $ 336 64 14 87  $ 104 31 14 56  $ 102 16 18 55  $ 130 17 7 42  $ 52 07 11 13  $ 78 10 $ $ $ $ $ $ $ $ $ 155,775,000 84,700,000 71,075,000 24,500,000 23,500,000 23,075,000 9,230,000 13,845,000   Sales $ per Unit 100 00  $ 662 87 54 37  $ 360 43 45 63  $ 302 45 15 73  $ 104 26 15 09  $ 100 00 14 81  $ 98 19 5 93  $ 39 28 8 89  $ 58 91 Sales VMC Gross Profit Fixed Costs Depreciation EBIT $000's) $ (7,020) $ (5) $ (7,025) $ (300) $ 200 $ (7,125) $ 2,850 $ (4,275) Taxes 40  Taxes NI NI

Accepted Answer

The Answer is in the image, click to view ...

Question

GolfCo Variance Problem Total Budget Year 1 55,000 Actual Year 1 55,000 New club volume New club price New club VMC Budget Units Price Sales

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

The Ultimate Beginners Guide To Understanding NFTs

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question