Question: Can you do Case 2 and Case 3 CASE 2 - As a result of a projected success in the launch year (2023), we predict
Can you do Case 2 and Case 3


CASE 2 - As a result of a projected success in the launch year (2023), we predict that we will see a 5% growth rate from 2023 to 2024. Input the 2024 projections using 5% growth for all items including the market share, and all costs (both fixed and variable expenses). Sales calculations will be based on the new market share figure. The industry's market size will be unchanged. In Excel, right-rlick an your "Bobby Singer" tah and click "Move or Copy". In the dialogue hox that appears, ensure that "Mowe to the end" is selected, and that "create a copy" is checked off. Click okay and a duplicate tab of your base case should appear. CASE 3 - As a financial analyst in the marketing division, you're convinced that for 2025, other things being equal to 2024 figures, if you double the 2023 fixed and variable marketing expenditures then you will increase market share by 50% (from the 2023 number). What will you tell the CEO now, based on your new calculations? (Hints: Base new sales calculation on new units sold \#. Also, instead of 5% growth above, variable marketing expenses will double to 10% of sales, and fixed marketing expenses will simply double) MARKET DYNAMICS: Market Size-Househ Market Share Selling price/unit Variable COGS per unit Variable MSE/unit Variable Packaging/unit Fixed Marketing Fixed Manufacturing Overhead Market Size in Units FINANCIAL MODEL: Sales Variable COGS (total) Variable MSE (total) Variable Packaging (total) Total Variable Costs Fixed Costs Marketing Manufacturing Overhead Total Fixed Costs Operating Incom Breakeven point/units Breakeven point /$ market size HH units/households market share * market size in units
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
