# Develop 3 simulation models to predict total revenue for a single 16-game season

## Develop 3 simulation models to predict total revenue for a single 16-game season

Assignment
Imagine that you have been hired as a consultant for Bill Sparks, the Senior Associate Director of
Business Operations for the Athletics Department. To help him and the University of Wyoming
predict revenues for the coming year, you will need to answer the questions below. After
performing the necessary analyses, prepare a short write-up that addresses the questions. The
write-ups will be evaluated on their content and presentation, including logic, organization,
grammar, and spelling. The write-ups should be two to three typed pages (double-spaced), not
including support materials such as diagrams and spreadsheets. Please combine all files into a
single document and submit it to the Blackboard Dropbox by the due date indicated below.
Questions
1. Identify the variables that are likely to be related to ticket and concession sales. [1 point]
2. Use simple linear regression to develop two models: one for predicting ticket sales and one
for predicting concession sales. [2 points]
3. Develop 3 simulation models to predict total revenue for a single 16-game season. One
variable in your simulations should be the team’s win percentage. Use Naïve, Moving
average, Weighted Moving Average(0.7, 0,2 0.2 and 0.1 respectively) and compare the
models. The simulation models should be entered into a spreadsheet to facilitate multiple
replications. [3 points]
4. Assume Sparks’ projection for the team’s win percentage for the upcoming season is
randomly set, with each of the win percentages of the four recent seasons equally likely to
occur in the upcoming season. Provide a forecast for total revenue for the season, assuming
only the minimum number of home games will be played — eight conference games and
eight non-conference games, each eight split evenly between weekends and weekdays.
Your forecast should be based on at least 100 simulated seasons. [2 point]
5. Demonstrate revenue impact analysis by using what-if approaches as follows. [1 point]
– Change win%
– Change the number of games in weekdays and weekends
– Change the number of conference and non-conference
After the comparison, show the most effective strategy Mr. Sparks should take

Get Your Custom Essay Written From Scratch
Are You Overwhelmed With Writing Assignments?
Give yourself a break and turn to our top writers. They’ll follow all the requirements to compose a premium-quality piece for you.