1. If Ood Genuine Ale decided to move to a relative price index of 95% with no change in their dollar sales, what would their Average Price Per Unit, their Total Units Sold and Unit Market Share be? Assume that the total market in dollars and units does?not change. Use the blank space below to show your work.

Required Average Price Per Unit _____________

Total Units Sold _____________

Unit Market Share _____________

?

Transcribed Image Text:

Excel File Edit View Insert Format Tools ●●● AutoSave or OFF A B 9. C .... Home Insert Draw Page Layout Formulas Data Calibri (Body) BTU ~ fix 138 A 2 7 A 9 10 11. 17 14 15 15 17 15 19 23 24 Paste 28 25 25 31 Lia ✓ B + X it of Households ('000's) Penetration Rate it of Households Buying Frequency (Trips or Transactions) $ Purchases / Household Unit Purchases / Household 21 22 Unit Sales ('000's) Average $/Transaction Average Price / Unit Units/Trip Sales ($'000's) Market Share (in dollars) 14 Market Share (in units) 2,000,000 48.00% 960.000 Total Beer Market 16.35 $535.20 210 $32.73 Ăˆ A™ A E Note: Cells highlighted in yellow are inputs provided from consumer research (e.g. Nielsen Homescan) If a cell is highlighted in blue, the correct formula must be entered into that cell. Inputting all of the formulas correctly will result in the correct metrics being generated in cells that currently show "0" or "#DIV/0!" $513,792,000 201,600,000 D $32.73 $2.55 12.84 . Data 16,498 Review == == 2,000,000 31.00% 620.000 Window Help Akash Market Size & Market Share Learning Exercise V1- Base Spreadsheet (1) View Tell me 7.85 $198.35 112 Bad Wolf Beer $25.27 ** $122,977,000 24% 6.792.000 3% 48% 37% 3 $25.27 $1.77 14.27 Wrap Text Merge & Centre OCT 2 Cyberman's Ale 2,000,000 10.50% 210,000 5.68 $152.83 39 Penetration Index Frequency (Trips) Index $ Purchases / Household Index Unit Purchases / Household Index 53% Average $/ Purchase Index 77% Average Price / Unit Index (Relative Price Index - RPI 710% Units / Purchase Index 111% Note: It is accumed for this ovamele that we are using "statistical" units so that the volume of each unit is the same for everchrand + Exercise I - Base Spreadsheet Ready Accessibility: Investigate $26.91 $32,094,300 8,190,000 4% Number K² - % 22% 35% 29% 19% 82% 154% 31% % 9 $26.91 $3.92 3.92 K L tv The following indices are based on comparing the metrics for a specific brand to the comparable metric for the total market. 65% 26% 31% 29% 22% 97% 135% 2% 2,000,000 12.50% 250,000 Dalek-table Draft 4.99 $157.83 46 $31.63 $39,457,500 = D Conditional Format Cell Formatting as Table Styles 11,500,000 9 M A J $31.63 $3.43 0.29 Ood Genuine Ales 2,000,000 28.30% 566.000 11.87 $242.35 109 $20.42 59% 73% 45% $137,170,100 27% 61,620,420 31% 52% 62% 3·2·E· 87% 71% Insert Delete A V F $20.42 $2.23 9.17 □ệ Q 8 Sun 2 Oct 23:32 . Format !!! Q R Share ÅP. O. ۰۵۰ Sort & Find & Filter Select ■ G . Comments Analyse Data TU V + 84% Excel File Edit View Insert Format Tools ●●● AutoSave or OFF A B 9. C .... Home Insert Draw Page Layout Formulas Data Calibri (Body) BTU ~ fix 138 A 2 7 A 9 10 11. 17 14 15 15 17 15 19 23 24 Paste 28 25 25 31 Lia ✓ B + X it of Households ('000's) Penetration Rate it of Households Buying Frequency (Trips or Transactions) $ Purchases / Household Unit Purchases / Household 21 22 Unit Sales ('000's) Average $/Transaction Average Price / Unit Units/Trip Sales ($'000's) Market Share (in dollars) 14 Market Share (in units) 2,000,000 48.00% 960.000 Total Beer Market 16.35 $535.20 210 $32.73 Ăˆ A™ A E Note: Cells highlighted in yellow are inputs provided from consumer research (e.g. Nielsen Homescan) If a cell is highlighted in blue, the correct formula must be entered into that cell. Inputting all of the formulas correctly will result in the correct metrics being generated in cells that currently show "0" or "#DIV/0!" $513,792,000 201,600,000 D $32.73 $2.55 12.84 . Data 16,498 Review == == 2,000,000 31.00% 620.000 Window Help Akash Market Size & Market Share Learning Exercise V1- Base Spreadsheet (1) View Tell me 7.85 $198.35 112 Bad Wolf Beer $25.27 ** $122,977,000 24% 6.792.000 3% 48% 37% 3 $25.27 $1.77 14.27 Wrap Text Merge & Centre OCT 2 Cyberman's Ale 2,000,000 10.50% 210,000 5.68 $152.83 39 Penetration Index Frequency (Trips) Index $ Purchases / Household Index Unit Purchases / Household Index 53% Average $/ Purchase Index 77% Average Price / Unit Index (Relative Price Index - RPI 710% Units / Purchase Index 111% Note: It is accumed for this ovamele that we are using "statistical" units so that the volume of each unit is the same for everchrand + Exercise I - Base Spreadsheet Ready Accessibility: Investigate $26.91 $32,094,300 8,190,000 4% Number K² - % 22% 35% 29% 19% 82% 154% 31% % 9 $26.91 $3.92 3.92 K L tv The following indices are based on comparing the metrics for a specific brand to the comparable metric for the total market. 65% 26% 31% 29% 22% 97% 135% 2% 2,000,000 12.50% 250,000 Dalek-table Draft 4.99 $157.83 46 $31.63 $39,457,500 = D Conditional Format Cell Formatting as Table Styles 11,500,000 9 M A J $31.63 $3.43 0.29 Ood Genuine Ales 2,000,000 28.30% 566.000 11.87 $242.35 109 $20.42 59% 73% 45% $137,170,100 27% 61,620,420 31% 52% 62% 3·2·E· 87% 71% Insert Delete A V F $20.42 $2.23 9.17 □ệ Q 8 Sun 2 Oct 23:32 . Format !!! Q R Share ÅP. O. ۰۵۰ Sort & Find & Filter Select ■ G . Comments Analyse Data TU V + 84%

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Required Average Price Per Unit 5 Total ... View the full answer