The manager of an opera theater is concerned about overbooking one of his upcoming productions. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The manager of an opera theater is concerned about overbooking one of his upcoming productions. The theater has 300 general admission seats. General admission seats are not reserved, but ticket holders can fill the seats as they arrive. Sometimes there are empty seats at a performance either due to insufficient sales or ticket holders who do not show up for the performance. Tickets cost $50 per seat. Historical records demonstrate that demand for tickets is normally distributed with a mean of 325 tickets and a standard deviation of 25 tickets. Historical records also demonstrate that between 6% and 12% (uniformly distributed) of ticket holders do not show up. (In your model use integers for all demands and for the number of ticket holders who do not show up.) There are no refunds for those who do not show up. The number of tickets sold for each performance will be the smaller of the number of tickets made available for sale or the demand for tickets. If the manager overbooks and more than 300 individuals show up with general admission tickets, those unable to be accommodated with a general admission seat for that performance will be given guaranteed reservations and VIP seats to an upcoming show of their choice. A VIP seat is simply a regular general admission seat within the theater that the manager will mark as "reserved" for a previously bumped customer. Bumped ticket holders do not receive a refund on their ticket, but they do effectively decrease the number of tickets that are available for sale for upcoming shows. For simplicity, assume bumped ticket holders will be accommodated at the next evening's show. For example, if the policy is to make 310 tickets available for each show and there were 20 ticket holders bumped from Tuesday night's performance, then there are only 310-20=290 tickets available for sale for Wednesday night's performance. For purposes of calculating no-shows for Wednesday night's performance, the number of ticket holders would be 20 + the number of tickets sold. L.e., if only 285 of the 290 tickets were sold there may be 285 +20=305 ticket holders show up for seats on Wednesday night (if there were no no-shows Wednesday). Moreover, to keep his customers happy, the manager gives each individual who is bumped $20 worth of gift certificates. Part A) (25 points) Refer to the information above. The manager wishes to explore the impact on profitability if 310 tickets are made available for each show. Simulate this ticket policy for a month (30 days). Use Excel with N-200 replications. What is the average monthly ticket income (less any $20 gift certificates given to bumped customers). Part B) (25 points) Refer to the information above. Suppose that the manager wishes to examine the effect of different ticket availability levels on the average monthly total ticket income (less gift certificates). In specific, the manager wishes to consider ticket availability levels of 300, 310, 320, 330, and 340. Use Excel and construct a Data Table to find the reservation level that maximizes average monthly profit. Use N=200 replications. What is your recommendation? Why? The manager of an opera theater is concerned about overbooking one of his upcoming productions. The theater has 300 general admission seats. General admission seats are not reserved, but ticket holders can fill the seats as they arrive. Sometimes there are empty seats at a performance either due to insufficient sales or ticket holders who do not show up for the performance. Tickets cost $50 per seat. Historical records demonstrate that demand for tickets is normally distributed with a mean of 325 tickets and a standard deviation of 25 tickets. Historical records also demonstrate that between 6% and 12% (uniformly distributed) of ticket holders do not show up. (In your model use integers for all demands and for the number of ticket holders who do not show up.) There are no refunds for those who do not show up. The number of tickets sold for each performance will be the smaller of the number of tickets made available for sale or the demand for tickets. If the manager overbooks and more than 300 individuals show up with general admission tickets, those unable to be accommodated with a general admission seat for that performance will be given guaranteed reservations and VIP seats to an upcoming show of their choice. A VIP seat is simply a regular general admission seat within the theater that the manager will mark as "reserved" for a previously bumped customer. Bumped ticket holders do not receive a refund on their ticket, but they do effectively decrease the number of tickets that are available for sale for upcoming shows. For simplicity, assume bumped ticket holders will be accommodated at the next evening's show. For example, if the policy is to make 310 tickets available for each show and there were 20 ticket holders bumped from Tuesday night's performance, then there are only 310-20=290 tickets available for sale for Wednesday night's performance. For purposes of calculating no-shows for Wednesday night's performance, the number of ticket holders would be 20 + the number of tickets sold. L.e., if only 285 of the 290 tickets were sold there may be 285 +20=305 ticket holders show up for seats on Wednesday night (if there were no no-shows Wednesday). Moreover, to keep his customers happy, the manager gives each individual who is bumped $20 worth of gift certificates. Part A) (25 points) Refer to the information above. The manager wishes to explore the impact on profitability if 310 tickets are made available for each show. Simulate this ticket policy for a month (30 days). Use Excel with N-200 replications. What is the average monthly ticket income (less any $20 gift certificates given to bumped customers). Part B) (25 points) Refer to the information above. Suppose that the manager wishes to examine the effect of different ticket availability levels on the average monthly total ticket income (less gift certificates). In specific, the manager wishes to consider ticket availability levels of 300, 310, 320, 330, and 340. Use Excel and construct a Data Table to find the reservation level that maximizes average monthly profit. Use N=200 replications. What is your recommendation? Why?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
If freeway speeds are normally distributed with a mean of = 70 mph and = 7 mph, find the probability that the speed of a randomly chosen vehicle (a) Exceeds 78 mph; (b) Is between 65 and 75 mph;...
-
The manager of an opera theater considers changing the overbooking policy of his upcoming concerts. Customers make reservations online prior to the concert at no cost and make payment when they show...
-
The manager of an 80-unit apartment complex knows from experience that at a rent of $300, all the units will be full. On the average, one additional unit will remain vacant for each $20 increase in...
-
Analyze the residuals from the regression model on the patient satisfaction data from Exercise 4.49. Comment on the adequacy of the regression model. MTB> Stat> Regression > Regression Normal...
-
Which of the following are characteristic of principalagent conflicts that often exist in a firm? (Note: The entire statement must be true in order to be a correct answer.) a. Managers do not always...
-
Formic acid, HCOOH, is a weak electrolyte. What solute particles are present in an aqueous solution of this compound? Write the chemical equation for the ionization of HCOOH.
-
Graph the following numbers on the number line: 1. -10 2. 4 3. 0
-
Austin Enterprises makes and sells three types of dress shirts. Management is trying to determine the most profitable mix. Sales prices, demand, and use of manufacturing inputs follow: The company...
-
(Efficiency analysis) ALei Industries has credit sales of $154 million a year. ALei's management reviewed its credit policy and decided that it wants to maintain an average collection period of 45...
-
In 2018, Kida Company purchased more than $10 million worth of office equipment 11-6, 11-9 under its special ordering system, with individual orders ranging from $5,000 to $30,000. Special orders...
-
Johnsenn's hydrogen car manufacturing plant leases 50 capital and produces 25 hydrogen cars per period. Johnsenn's short-run cost function is: C ( q, K ) = 15 q 5 where q is the K 5 / 2+200 K number...
-
Sonny Ltd is an upcoming backyard salon situated in Gauteng, South Africa. They have been operating very well ever since they started, the only problem they have is to account for each and every cost...
-
Compare and contrast how Windows systems store user settings with Unix and Linux systems. Which method do you think is more secure? Justify your answer.
-
Suppose: Money supply $80 million Price level = $5.00 Velocity of circulation = 4 times a) Determine the quantity of output, T b) If there is an increase in the money supply by 6% determine the new...
-
Describe the various functions involved in interrupt handling. Indicate the hardware and software that might be involved in their implementation. Discuss the interaction of interrupt driven software...
-
Consider the following statistics for Freedonia GDP Population P 1 9 8 0 $ 7 0 billion 5 . 1 million 2 0 0 0 $ 1 0 0 billion 5 . 3 million Calculate GDP pr capita for the two years ( 6 pts ) By what...
-
content area top Part 1 A trucking company determined that the distance traveled per truck per year is normally distributed, with a mean of 30 thousand miles and a standard deviation of 12 thousand...
-
Imagine a sound wave with a frequency of 1.10 kHz propagating with a speed of 330 m/s. Determine the phase difference in radians between any two points on the wave separated by 10.0 cm.
-
Describe some of the characteristics of Canadian union members and unionized workplaces. Choose at least one of these characteristics and explain what you think are the reasons for this...
-
On April 16, Robert Dion filed an application for decertification of the Builders Union local at Careful Contracting. The union did not fi le a reply to the application, but the employer did. The...
-
Why are some unions opposed to part-time, temporary, and contract work, and other forms of nontraditional work?
-
Paymore Shoes acquired 80 percent of the voting stock of Spire Footwear on February 1, 2014, for \($21\) million. The fair value of the noncontrolling interest at the acquisition date was \($3\)...
-
Pacific Athletic Corporation owns all of the voting stock of Solovair Apparel. Acquisition cost was \($10\) million in excess of Solovairs book value of \($2\) million, and the excess was attributed...
-
Peninsula Industries and Seaport Company, a 90 percent owned subsidiary, engage in extensive intercompany transactions involving raw materials, component parts, and completed products. Peninsula...
Study smarter with the SolutionInn App