Question: Develop a spreadsheet model to address the following scenario. Along with coming up with an analytically-substantiated response, the premium here is to develop a clear
Develop a spreadsheet model to address the following scenario. Along with coming up with an analytically-substantiated response, the premium here is to develop a clear and concise spreadsheet model that contains relevant information. A professional football team is preparing its budget for the next year. One component of the budget is the revenue that they can expect from ticket sales. The home venue, Arrowhead Stadium, has five different seating zones with different prices. Key information is given below. The demands are all assumed to be normally distributed. 1. Determine the distribution of total revenue under these assumptions using 250 trials. Summarize the statistical results. Provide your response below in RED font. Seating Zone Seats Available Ticket Price Mean Demand Standard Deviation First level Sideline 15000 $1,000 14500 750 Second Level 5000 $90 4750 500 First Level End Zone 10000 $80 9000 1250 Third Level Sideline 21000 $70 17000 2500 Third Level End Zone 14000 $60 8000 3000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
