Marketing homework (needs marketing major’s tutor)

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.