Great Deal! Get Instant \$10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

# 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....

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).

1. Identify the best distributions to fit your data (and their parameters).Comment on your findings.

2. Simulate profit per game (iterations = 1,000).

3. Compute the expected profit per game, median profit and the std. deviation.

4. What is the probability that profit per game will be between x than y? (pick arbitrary values for x and y)

Answered 1 days After Nov 10, 2023

## Solution

Banasree answered on Nov 12 2023
Page | 2
1.Ans.
Descriptive Statistic:
Demand Data

Mean
2480.714286
Standard E
o
11.55426131
Median
2500
Mode
2300
Standard Deviation
136.7118634
Sample Variance
18690.13361
Kurtosis
-1.228260318
Skewness
0.132287275
Range
400
Minimum
2300
Maximum
2700
Sum
347300
Count
140
Largest(1)
2700
Smallest(1)
2300
Confidence Level(95.0%)
22.84482808

Interpretation:
The histogram in the figure shows the distribution of demand for football programs at CSU. The best distribution to accommodate this data is the normal distribution. The normal distribution, also known as the Gaussian distribution, is a bell-shaped distribution that is symmetric about the mean. The overall the distribution is well suited to the requirements of the football program at CSU because the distribution is symmetrical. The average requirement is 2,500 systems, with most sports requiring between 2,300 and 2,700 systems.
2.Ans.