Question: Use the data from the case, the forecast model provided (Exhibit 5 of the case), and the spreadsheet provided to create a forecast for the
Use the data from the case, the forecast model provided (Exhibit 5 of the case), and the spreadsheet provided to create a forecast for the new product concept, Montreaux Dark Chocolate with fruit. Be aware that the spreadsheet is only a baseline; you will need to expand the spreadsheet to deal with all of the data in Exhibit 5. You only need to forecast 9 scenarios for each of mediocre, average, excellent quality. Do scenarios for low/low awareness/ACV, medium/medium awareness/ACV, and high/high awareness/ACV. Based on your forecast, select a scenario you would pursue and clearly discuss why you chose that scenario. Do this in 1 spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
