Diamond Theater produces plays and musicals for a regional audience. The theater's business has the following characteristics: The theater has a total of 350 seats. The seats are categorized into two levels: Level 1: 150 seats priced at $76 Level 2: 200 seats priced at $50. The fixed cost for each performance is random and follows a Normal distribution with a mean of $2,500 and a standard deviation of $500. The demand for a typical performance follows a discrete probability distribution as given below: Each customer requests level 1 seats with a probability of 0.42. As a result, the number of customers requesting the level 1 seats follows a Binomial distribution with a success probability of 0.42. Customers requesting the level 1 seats would not accept the level 2 seats if level 1 is sold out. The Diamond Theater.xlsx file includes a spreadsheet model template to derive the theater's profit per show. The template is missing some parameters and calculations (highlighted with yellow background). First, fill in the spreadsheet model with the correct Excel formulas to complete the template. Then, run a Monte Carlo simulation study with 5000 trials using a data table. Notice that the Excel file also have a data table template. Answer the following questions based on the results of the simulation study. a) Calculate the mean profit per show in the simulation study. Which of the values given below in the drop-down menu is the closest to the mean you calculated? b) Calculate the probability that the profit per show will be above $18,000. Which of the values given below in the drop-down menu is the closest to the probability you calculated?Data link: https://docs.google.com/spreadsheets/d/19UxcUnZIm5J7K7p0DGcUH-6cMuNWSkYs2lf3vM3dupU/edit?usp=sharing 16724024attachment1.png

\f