With the spreadsheet below what numbers would you fill in for each column based on Bottlers and then a whole other set of spreadsheet for Concentrated Manufactures?

What numbers or low, med, and high would you put in the blank column.

Module 1 - Five Forces Strategy Excel Tool 2.0 - Excel FILE HOME INSERT PAGE LAYOUT ? 19 - 5 x FORMULAS DATA REVIEW VIEW ACROBAT Cut Eric Hull . Calibri 12 - A" A " BE Copy Be Wrap Text General EX AutoSum . AY H Paste Format Painter BIU - B- &-A Merge & Center Conditional Format as Cell Fill - Insert Delete Format Sort & Find & Formatting . Table S Styles * & Clear . Filter . Select . Clipboard Font Alignment Number Styles Cells Editing M4 A D E F G H M 90 91 Evaluating the Overall Attractiveness of the Industry Weights 92 93 0.00 20%% 94 1. Overall Intensity of Rivalry 95 0.00 20% 96 2. Overall Intensity of Buyer Power 97 0.00 20% 98 3. Overall Intensity of Supplier Power 0.00 20% 99 100 4. Overall Threat of New Entrants 0.00 20% 101 102 5. Overall Threat of Substitutes 0.00 103 104 Overall Industry Attractiveness (5 = most attractive, 1 = least attractive 105 106 107 108 109 Instructions Five Forces + 91F 1 11:33PM 7/8/2022 P3 w READY O Type here to search DELLFILE HOME Module 1 - Five Forces Strategy Excel Tool 2.0 - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ACROBAT ? 2 - 1 Cut Eric Hull Calibri 12 - A" A" BB Copy Wrap Text General EX AutoSum . Paste A BIU- B - BA- Fill - Format Painter Merge & Center ~ Conditional Format as Cell Insert Delete Format Sort & Find & Formatting Table . Styles & Clear * Clipboard Filter ~ Select Font Alignment Number Styles Cells Editing M4 : X V fx E F G H L M 74 Overall attractiveness of industry based on assessment of threat of new entrants (5 = most attractive, 1 = least attractive) 0.00 75 76 Evaluating the Threat of Substitutes Weights 77 2 4 5 78 High Med LOW 20% 79 1. Customer awareness of substitutes: ability to recognize brands from substitute industry 80 Notes/Sources: Worse 20% Better Same 81 2. Availability of subsititues 82 Notes Sources: Lower Higher 20% Same 83 3. Price of substitutes 84 NotestSources: 20% Better Same Worse 85 4. Performance of substitutes 20% 86 Notes/Sources: Med High Lower 87 5. Customer switching costs 88 Notes/Sources 0.00 89 Overall attractiveness of industry based on assessment of threat of substitutes (5 = most attractive, 1 = least attractive) 90 Weights 91 Evaluating the Overall Attractiveness of the Industry 92 93 Instructions Five Forces + 91F A 9608 READ O ICE N Type here to search DELLFILE HOME Module 1 - Five Forces Strategy Excel Tool 2.0 - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ACROBAT X Cut Eric Hull . Calibri 12 - A" A" EG Copy Wrap Text General Z AutoSum . Asp Paste Format Painter BIU- - D-A- Merge & Center Fill . $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting Table Styles. Clear Clipboard Filter . Select Font Alignment Number Styles Cells Editing M4 x v fx C D E F G H Evaluating the Threat of New Entrants Weights 55 5 56 2 3 33% 57 1. Incumbent firm's cost advantage 58 1.1 Size of scale economies: measured as the slope of the scale curve -95% 85-95% 80-85% 40% 62 1.5 Market share required to break even 63 Notes Sources: 33%% 25%% 64 2. Other incumbent firm advantages Weak Neutral Strong 25% 65 2.1 Strength of incumbents' brands (how influential in customer purchase decisions?) Low Med High 25% 66 2.2 Size of switching cost for incumbents' customers Med High Low 25% 67 2.3 Degree to which network effects affect buying decision Low Med High 68 2.4 Cost for entrants to comply with government regulations 1 33% 69 NotesiSources: 50%% 10-15% 5-10% 0-5% 70% 60-70% 50-60% 40-50% 5% 25% 1.3 Demand (incumbent industry growth rate) High Med Low 25% 28 1.4 Possibility of buyer backward integration 29 Notes Sources: 1 50% 30 2. Buyer industry price sensitivity 10-15% >15% 17% 70% 17% 1. Number and Relative Size of Competitors: Top 4 competitors combined market share Notes/Sources: 17% 2. Degree of industry product standardization 15% 25% 2.1 Difference between competitors in price of similar product .00% 75% 50% 25% 0% 25% 2.2 What % of industry's products are sold at discount 25% Low Med High 2.3 Customer's ability to recognize brands from industry High 25% Low Med 2.4 Degree of switching costs Notes/Sources: 100% 4. Unused industry production capacity: % of industry wide production capacity in use Notes/Sources Low 17% High Med 5. Degree to which firms have high fixed costs, high storage costs, or highly perishable goods 17% Notes/Sources: High Med 6. Extent of exit barriers 0.00 Notes/Sources: Overall attractiveness of industry based on assessment of rivalry (5 = most attractive, 1 = least attractive) KI + Instructions Five Forces 91FADG08 17:3 718/ M ADY X O Type here to search DELL Home