for number one, please use the premium rates of each golf ball and year 2012.
i think i did it wrong.
for questions 2 and 3:
elevate: cost =7.75
elevate: price =27.00
sert Page Layout Tell me what you want to do... as ,Trace Precedents 5 Define Name . Use in Formula , Trace Dependents o ntly Financial Logical Tent Date& Lookup&Math &More Name ed Create from Selection | Remove Arrows . . . Time-Reference . Tig. Function Library Functions Manager Defined Names Formula Exhibit 1 - U.S. golf equipment and ball sales (retail dollar sales, current) Total equipment, ind balls (millions, USD) Golf balls (millions, USD) % change vs. prior % change vs. prior year Year 2,911 2007 552 2008 2,752 5.5% 536 -2.9% 2009 2,433 11.6% 495 2010 2,384 479 -3.2% -2.0% 2011 2,414 1.3% 464 2012 2,628 8.9% 483 4,1% Source: Mintel Exhibit 2 Market share by units, dollars sales, and channel US retail unit sales 2008 2010 2012 36.7% 25.1% 38.0% 17.1%| 14.2% Premiera 16.3% 15.7%, 16.396 14.7% 9.3% 8.1% 8.3% US retail dollar sales 2010 201 58.796 56 55.2% Premmera 12.5% 13.2% 15.0% 19.3% 18.5% Bantam 17.3% Carlsbad 10.5% 11.0% 9.3% Altius share, dollar sales 68.0% 67.6%| 67,5% 45.5% Off-Course 50.8% 47.9% Dollar sales by channel 45.9% 45.2% Off-Course 54.8% 541% 55.8% select nanufacturers (average price per dozen) e retail AnswerSheet Worksheet ExhibitsTogether Ex1-Goltf equipment s sales Ex 2 - Market share Ex 3 - Pricing & margins x3 Altius Gol' Case A Define Name . %Use in Formula . AutoSum Recently Financial Logical Text Date & Lookup & Math & UsedTime Reference T More Name Create from Selection Trig- Functions Manager Defined Names Function Library 67.5%) On-Course 68.0% 67.6% Off-Course 47.9% 50.8% 45.5% Dollar sales by channel 2008 2010 2012 45.9% 45.2% 44.2% Off-Course 54,1% 54.8% 55.8% xhibit 3- Pricing and margins, select manufacturers (average price per dozen) Average retail price per dozen Altius Premiera Carlsbad Bantam Premium Victor Tx* Flight BCE $48 $44 $45 $45 Md-Range Merion $35 $36 $36 44 Value Pegasus $27 $27 $25 Canterbury Pegasus X $18 $21 $19 gross e)margin % (est.) 15% 20% 20% 20% Manuf gross margin % 70% 55-60% 55-60% " Top-selling ball for each manufacturer shown in bold -Pror generation Viector builis were aleso sold at the same erice.... Anceersheet Worksheet ExhibitsTogetherEx1-Golf equpment sales Ex2-Market shareEx 3-Pricing Alia Golf Case AL- 11 BADM 7100 ns-To answer these questions please use the information from the case and the the other pages of this worksheet to calculate the requested values below. nd the readings and marketing math video helpful to do prior to attempting this. Answer cells are Highlighted in Yellow. ase show the formula through which you calculated the numbers in each cell. ws me to give partial credit and better feedback. ) what are the gross profits (in Millions of Dollars) and Market Share (on a UNIT BASIS Point Valut ( Carlsbad, and Bantam (in Millions of Dolars) for 2012? Assume: MFR. Margins for Carlsbad, Premiera and Bantam are at the upper end of range in Ex.3 Altius Premiera Bantam Carlsbad Gross Profits 186.6 $ 43.5 50.1 24.1 $ 5.3 2.5 $3.4 $ 2.9 MSPV 25%) what are the retailer gross profits (per unit in S) for Altius's 3 product offerings Victor TX Victor Elevate Retail Margin (s/Unit) (25%) what are the manufacturer unit contributions (in S) for Altius's 3 product offerings Victor TX Victor Elevate Unit Contribution 14.40 11.70 $ 7.75 AnswerSheet worksheet Ex 1 , Gor equipment sales EshbasTogether | Ex 2 . Market share Ex BAtius Golf Case As. BADM sert Page Layout Tell me what you want to do... as ,Trace Precedents 5 Define Name . Use in Formula , Trace Dependents o ntly Financial Logical Tent Date& Lookup&Math &More Name ed Create from Selection | Remove Arrows . . . Time-Reference . Tig. Function Library Functions Manager Defined Names Formula Exhibit 1 - U.S. golf equipment and ball sales (retail dollar sales, current) Total equipment, ind balls (millions, USD) Golf balls (millions, USD) % change vs. prior % change vs. prior year Year 2,911 2007 552 2008 2,752 5.5% 536 -2.9% 2009 2,433 11.6% 495 2010 2,384 479 -3.2% -2.0% 2011 2,414 1.3% 464 2012 2,628 8.9% 483 4,1% Source: Mintel Exhibit 2 Market share by units, dollars sales, and channel US retail unit sales 2008 2010 2012 36.7% 25.1% 38.0% 17.1%| 14.2% Premiera 16.3% 15.7%, 16.396 14.7% 9.3% 8.1% 8.3% US retail dollar sales 2010 201 58.796 56 55.2% Premmera 12.5% 13.2% 15.0% 19.3% 18.5% Bantam 17.3% Carlsbad 10.5% 11.0% 9.3% Altius share, dollar sales 68.0% 67.6%| 67,5% 45.5% Off-Course 50.8% 47.9% Dollar sales by channel 45.9% 45.2% Off-Course 54.8% 541% 55.8% select nanufacturers (average price per dozen) e retail AnswerSheet Worksheet ExhibitsTogether Ex1-Goltf equipment s sales Ex 2 - Market share Ex 3 - Pricing & margins x3 Altius Gol' Case A Define Name . %Use in Formula . AutoSum Recently Financial Logical Text Date & Lookup & Math & UsedTime Reference T More Name Create from Selection Trig- Functions Manager Defined Names Function Library 67.5%) On-Course 68.0% 67.6% Off-Course 47.9% 50.8% 45.5% Dollar sales by channel 2008 2010 2012 45.9% 45.2% 44.2% Off-Course 54,1% 54.8% 55.8% xhibit 3- Pricing and margins, select manufacturers (average price per dozen) Average retail price per dozen Altius Premiera Carlsbad Bantam Premium Victor Tx* Flight BCE $48 $44 $45 $45 Md-Range Merion $35 $36 $36 44 Value Pegasus $27 $27 $25 Canterbury Pegasus X $18 $21 $19 gross e)margin % (est.) 15% 20% 20% 20% Manuf gross margin % 70% 55-60% 55-60% " Top-selling ball for each manufacturer shown in bold -Pror generation Viector builis were aleso sold at the same erice.... Anceersheet Worksheet ExhibitsTogetherEx1-Golf equpment sales Ex2-Market shareEx 3-Pricing Alia Golf Case AL- 11 BADM 7100 ns-To answer these questions please use the information from the case and the the other pages of this worksheet to calculate the requested values below. nd the readings and marketing math video helpful to do prior to attempting this. Answer cells are Highlighted in Yellow. ase show the formula through which you calculated the numbers in each cell. ws me to give partial credit and better feedback. ) what are the gross profits (in Millions of Dollars) and Market Share (on a UNIT BASIS Point Valut ( Carlsbad, and Bantam (in Millions of Dolars) for 2012? Assume: MFR. Margins for Carlsbad, Premiera and Bantam are at the upper end of range in Ex.3 Altius Premiera Bantam Carlsbad Gross Profits 186.6 $ 43.5 50.1 24.1 $ 5.3 2.5 $3.4 $ 2.9 MSPV 25%) what are the retailer gross profits (per unit in S) for Altius's 3 product offerings Victor TX Victor Elevate Retail Margin (s/Unit) (25%) what are the manufacturer unit contributions (in S) for Altius's 3 product offerings Victor TX Victor Elevate Unit Contribution 14.40 11.70 $ 7.75 AnswerSheet worksheet Ex 1 , Gor equipment sales EshbasTogether | Ex 2 . Market share Ex BAtius Golf Case As. BADM
