You must use @Risk:
The revenues from ticket sales at CSU are significant, but the sale of food, beverages, and souvenirs has contributed greatly to the overall profitability of the football program. One particular souvenir is the football program for each game. The distribution of the demand of programs at each game is unknow but information about the last 140 games is available on file Module4_Assignment.xlsx (check under Excel Files Module). Historically, CSU has never seen the demand per game to be fewer than 2,300 programs or more than 2,700 programs.
Each program costs $0.75 to produce and sells for $2.00. Any programs that are not sold are donated to a recycling center and do not produce any revenue. The distribution of the number of programs to print per game(supply) is unknown but information about the last 140 games is available on file Module4_Assignment.xlsx (check under Excel Files Module).
Identify the best distributions to fit your data (and their parameters).Comment on your findings.
Simulate profit per game (iterations = 1,000).
Compute the expected profit per game, median profit and the std. deviation.
What is the probability that profit per game will be between x than y? (pick arbitrary values for x and y)
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here