For Part A, download the spreadsheet and fill out the model to get the baseline case (I believe the tab is called “Student Template”). The goal of Part B (sensitivity analysis) is to analyze how adjustments to the marketing plan impact the baseline forecast at the three levels of repurchase — e.g., what would the forecast look like if you were to assume low-support (awareness), low-ACV and mediocre repeat rate? Med-support, med-ACV and mediocre repeat rate? And so on. Hint – there are 9 forecasts in total.
Marketing homework (needs marketing major’s tutor)
