50.1K

Verified Solution

Link Copied!

How do I solve the problem using excel (NOT the @Risk add-in)

2. Based on Ch 12. Suppose you received additional information about Seven Flags. Now you are able to include risk into your analysis. In a typical summer season, the number of adult tickets sold has a normal distribution with a mean of 20,000 and a standard deviation of 2,000 . The number of children's tickets sold has a normal distribution with a mean of 10,000 and a standard deviation of 1,000 . Adult ticket prices are $18 and the children's price is $10. Revenue from food and beverage concessions is estimated to be between $50,000 and $100,000, with a most likely value of $60,000. Likewise, souvenir revenue has a minimum of $20,000, most likely value of $25,000, and a maximum value of $30,000. Variable costs per person (adult or child) are $3, and fixed costs amount to $150,000. Determine the distribution of profit for this business using 500 trials. Plot the distribution. What is the probability that the park will make a profit of $250,000 or less (the CEO is losing sleep over it)? Random value cells should be active in your calculations. 2. Based on Ch 12. Suppose you received additional information about Seven Flags. Now you are able to include risk into your analysis. In a typical summer season, the number of adult tickets sold has a normal distribution with a mean of 20,000 and a standard deviation of 2,000 . The number of children's tickets sold has a normal distribution with a mean of 10,000 and a standard deviation of 1,000 . Adult ticket prices are $18 and the children's price is $10. Revenue from food and beverage concessions is estimated to be between $50,000 and $100,000, with a most likely value of $60,000. Likewise, souvenir revenue has a minimum of $20,000, most likely value of $25,000, and a maximum value of $30,000. Variable costs per person (adult or child) are $3, and fixed costs amount to $150,000. Determine the distribution of profit for this business using 500 trials. Plot the distribution. What is the probability that the park will make a profit of $250,000 or less (the CEO is losing sleep over it)? Random value cells should be active in your calculations

Answer & Explanation Solved by verified expert

See Answer