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

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. SPREADSHEET AND CASE ATTACHED.