Please very important to explain all the transactions answers Chapter 12 Monte Carlo Simulation and Risk Analysis 3. A...

60.1K

Verified Solution

Question

Statistics

Please very important to explain all the transactionsanswers

Chapter 12 Monte Carlo Simulation and RiskAnalysis

3. A professional football team is preparing its budget for thenext year. One component of the budget is the revenue that they canexpect from ticket sales. The home venue, Dylan Stadium, has fivedifferent seating zones with different prices. Key information isgiven below. The demands are all assumed to be normallydistributed.

Seating Zone    Seats available Ticket price   Mean Demand    Standard Deviation

First Level Sideline    15,000    $100.0014,500 750

Second Level    5,000 $90.00    4,750   500

First Level End Zone    10,000    $80.00   9,000 1250

Third Level Sideline 21000 $70.00 17,000 2500

Third Level End Zone    14000 $60.00 8,000 3000

Determine the distribution of total revenue under theseassumptions using an Excel data table with 50 simulated trials.Summarize your results with a histogram.

Answer & Explanation Solved by verified expert
4.2 Ratings (767 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students