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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!