solved Week 4 – Milestone 2Posted Mar 22, 2021 12:01 AMWe
Week 4 – Milestone 2Posted Mar 22, 2021 12:01 AMWe are starting week 4. This week we have Milestone 2 due. For this milestone you will be completing two tabs in the workbook – Contribution Margin Analysis and Breakeven Analysis.CONTRIBUTION MARGIN ANALYSISChoose pricing for all three categories (Collars, Leashes, Harnesses)Calculate the Contribution Margin for each category using the variable costs calculated in Milestone 1BREAKEVEN ANALYSISCalculate the Breakeven Units for all three categories using the Sales Price you chose, the Fixed Costs calculated in Milestone 1 and the Contribution Margins calculated above.Calculate the Breakeven Units for two other Target Profit $’s for each of the three categories.Round up your breakeven units …. You cannot sell your customer a partial product or service!Below are a few more reminders (I know I posted this in Week 2, but it never hurts to be reminded!)