2024 – Due Mon 2 16 11 59AM Submit your Montreaux demand forecast and sensitivity

Due Mon, 2/16 (11:59AM).  Submit your Montreaux demand forecast and sensitivity analysis (Answer Q1, Parts A and B from “Session 12”).  Please submit BOTH the .xls file and PDF of the spreadsheet.

• Question #1 for Individual Assignment (submit Parts A and B):
  • Part A – Using the forecast model for the healthy dark chocolate product with fruit tested in the BASES II test in August 2012, what is your forecast of the demand for the chocolate product?
  • Part B – Conduct a sensitivity analysis by using the facts provided regarding consumer awareness, ACV and repeat rates for mediocre, average, and excellent products.
  • Hints:
    • The necessary data is contained in Exhibit 5
    • Refer to the Excel spreadsheet supplement from Digital Coursepack