Case study for an amusement park offering discounted tickets to Military through

Case study for an amusement park offering discounted tickets to Military through sales channel. 1st tab is case intro, 2nd tab is available data. The main objectives are to answer the following questions with detail/excel formulas that will be transferred into a powerpoint deck (I will make the powerpoint deck!)– 1) Increase overall volume and revenue 2)Shift attendance to middle of week 3)Show monthly trends by product before and after new program implemented in July 2014 4)Show day of week trends by product before and after new program implemented in July 2014 5) Did program achieve desired results? 6) What was the impact to revenue after the program was implemented?

Case study for an amusement park offering discounted tickets to Military through

Case study for an amusement park offering discounted tickets to Military through sales channel. 1st tab is case intro, 2nd tab is available data. The main objectives are to answer the following questions with detail/excel formulas that will be transferred into a powerpoint deck (I will make the powerpoint deck!)– 1) Increase overall volume and revenue 2)Shift attendance to middle of week 3)Show monthly trends by product before and after new program implemented in July 2014 4)Show day of week trends by product before and after new program implemented in July 2014 5) Did program achieve desired results? 6) What was the impact to revenue after the program was implemented?