Answered step by step
Verified Expert Solution
Question
1 Approved Answer
dont know how this need explanation step by step Pears Pears @ [ X P Do H P Final Watch $ 20221 Do H C
dont know how this need explanation step by step
Pears Pears @ [ X P Do H P Final Watch $ 20221 Do H C | Che * Cours * Cours resources FindCCP Fiver Msg f roller C | Che C | Che Search+ - X https://mylab.pearson.com/Student/PlayerHomework.aspx?homeworkld=631358247&questionld=11&flushed=false&cld=7067433&back=http A" . .. DSOM 311 Business Analytics II (1) Latoya Marsh 12/13/22 10:31 PM =Homework: Chapter 12 Question 11, 12.4.25 HW Score: 20.31%, 3.86 of 19 points Part 1 of 2 O Points: 0 of 1 Save The Kelly Theater produces plays and musicals for a regional audience. For a typical performance, the theater sells at least 250 tickets and occasionally reaches its capacity of 600 seats. Most often, about 450 tickets are sold. Question list K The fixed cost for each performance is normal with a mean of $2,400 and a standard deviation of $255. Ticket prices range from $30 to $70 depending on the location of the seat. Of the 600 seats, 150 are priced at $70, 200 at 655, and the remaining at $30. Of all the tickets sold, the $55 seats sell out first. If the total demand is at least 500, then all the $70 seats sell out. If not, then between 50% and 75% of the $70 seats sell, with the remainder being the $30 seats. If, however, the total demand is less than or equal to 350, then the number of $70 and $30 seats sold are usually split evenly. The theater runs 160 performances per year and incurs an annual fixed cost of $2 million. Develop a simulation model to evaluate the profitability of the theater using 50 trials. What is the distribution of annual net profit and the risk of losing money over a year? Click the icon to view a sample of 50 simulation trial results. O Question 8 O Question 9 Say the values of the number of tickets sold, fixed cost per performance, and performances per year are entered in cells B3, B4, and B5, respectively, the cost of a seat for the $70 seats, the $55 seats, and the $30 seats are entered in cells A8, A9, and A10, respectively, the number of seats available for the $70 seats, the $55 seats, and the $30 seats are entered in cells B8, B9, and B10, respectively, and the number of seats sold for the $70 seats, the $55 seats, and the $30 seats are entered in cells C8, C9, and C10, respectively. Then, for the Monte Carlo simulation, the number of $70 seats sold is randomly generated using Question 10 the Excel formula ROUND(IF(B3>= |,IF(B3],B -B|]-B ,0.5*(B|-B|\\)). The fixed cost per performance is randomly generated using the Excel formula =ROUND(NORM.INV(RAND().].),2). (Type whole numbers. Use ascending order.) O Question 11 Question 12 O Question 13 O Question 14 Help me solve this View an example Get more help - Clear all Check answer 44OF Clear Search X 10:31 PM 12/13/2022 DStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started