You must show detailed numerical analysis and quantitative formulas in an Excel Model ?(xlsx file submission) (step-by-step) to get credit in this question. ?Ron, the dire

You must show detailed numerical analysis and quantitative formulas in an Excel Model  (xlsx file submission) (step-by-step) to get credit in this question.

 Ron, the director at the Annenberg Theater, is planning his pricing strategy for a musical to be held in  a 400-seat theater. He sets the full price at $120 and estimates demand at this price to be normally  distributed with mean 300 and standard deviation of 100. Ron also decides to offer student-only  advance sale tickets discounted 75% off the full price. Demand for the discounted student-only tickets  is usually abundant and occurs well before full price ticket sales. a. Suppose Ron sets a 300-seat booking limit for the student-only tickets. What is the number  of full-price tickets that Ron expects to sell? b. Compute the Expected Total Revenue for Ron considering the arrangement in part a. c. Based on a review of the show in another city, Ron updates his demand forecast for full-price  tickets to be normal with mean of 200 and standard deviation of 50, but he does not change  the ticket prices. What is the optimal protection level for full-price seats?