Question
Southwestern University Football Game Attendance, 2010-2015 2010 2011 2012 Game Attendees Opponent Attendees Opponent Attendees Opponent 1 34,200 Ric 36,100 Miami 39,500 USC 2 a
Southwestern University Football Game Attendance, 2010-2015 | ||||||
2010 | 2011 | 2012 | ||||
Game | Attendees | Opponent | Attendees | Opponent | Attendees | Opponent |
1 | 34,200 | Ric | 36,100 | Miami | 39,500 | USC |
2a | 39,800 | Texas | 40,200 | Nebraska | 46,500 | Texas Tech |
3 | 38,200 | Duke | 39,100 | Ohio State | 43,100 | Alaska |
4b | 26,900 | Arkansas | 25,300 | Nevada | 27,900 | Arizona |
5 | 35,100 | TCU | 36,200 | Boise State | 39,200 | Baylor |
2013 | 2014 | 2015 | ||||
Game | Attendees | Opponent | Attendees | Opponent | Attendees | Opponent |
1 | 41,900 | Arkansas | 42,500 | Indiana | 46,900 | LSU |
2a | 46,100 | Missouri | 48,200 | North Texas | 50,100 | Texas |
3 | 43,900 | Florida | 44,200 | Texas A&M | 45,900 | South Florida |
4b | 30,100 | Central Florida | 33,900 | Southern | 36,300 | Montana |
5 | 40,500 | LSU | 47,800 | Oklahoma | 49,900 | Arizona State |
- Calculate the average attendance per game for each season
- Using the average attendance from the previous three-years (2013 through 2015), develop Weighted Moving Average forecast for the 2016 and 2017 seasons using the weights of (.5 *most recent*/ .3 / .2).
President Wisner is concerned with demand yield (total revenue) for the season. Look at your average attendance per game for each season. Which games do you notice are consistently above average and which below? Without calculating numbers, we can see a seasonal pattern in the data. In addition to President Wisner’s proposal to increase prices 5%, consider the economic theory of supply & demand and make a recommendation for the peak and valley of seasonality to further increase revenue. Use your data as evidence to support your recommendation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started