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...
-
Bass Company owns 25% of Petit Company. For the current year, Petit reports net income of $150,000 and declares and pays a $60,000 cash dividend. Record Basss equity in Petits net income and the...
-
The following tables show important demographics for China, Bangladesh, and the Philippines for 2012 and projected for 2062. (a) Create matrix B for the 2012 table and matrix A for the 2062 table....
-
ISE Communications was one of the pioneers in using self-managed work teams. The teams were put in place to improve manufacturing flexibility and customer service, both factors being crucial in the...
-
Use Worksheet. Felipe Aguilar has a NOW account at the Second State Bank. His checkbook ledger lists the following checks: Check Number Amount 654 .....................................................
-
What is a private-label mortgage-backed bond? What factors are driving the recent surge in their sale? What factors are driving demand for risk transfer securities? Are they public-traded? Who are...
-
On January 4, 2015, an FI has the following balance sheet (rates = 8 percent) DGAP = [8 (396/450)4] = 4.48 years > 0 The FI manager thinks rates will increase by 0.55 percent in the next three...
-
Dad wants to understand how to stop his son's behavior of begging for candy at the checkout counter. The psychologist teaches him that to stop of behavior, he needs to stop rewarding the behavior....
-
PQR sells one product. The cost card for that product is given below: $ Direct materials 4 Direct labour 5 Variable production overhead 3 Fixed production overhead 2 Variable selling cost 3 The...
-
consider the given code and do the following: 1: int arr[10] = (-5, 10, -7,0); 2: int size= sizeof(arr) / sizeof(arr[0]); 3: printf("Original array: "); 4: for (int i= 0; i < size; i++) { 5:...
-
Artimus Industries issued 10 year bonds with a par value of $1,000 and a 4% coupon rate. When the bonds were issued, the real interest rate was 0.94% and the inflation rate was 2.24%. Given the AAA...
-
Jean Corp. has an EBIT of 900,000 per year that is expected to continue in perpetuity. The unlevered cost of equity for the company is 14 percent, and the corporate tax rate is 35 percent. The...
-
David's television was destroyed in a fire. The television had a useful life of 10 years. The television was purchased three years ago, and its current replacement cost is $1,500. What is the actual...
-
A commodity trading firm was following the trading activity in the copper market and has collected the following data: Copper Futures 3-month: 6-month: SAM Canadian T-bill yields 3-month: $2.8455 per...
-
Under what conditions is the following SQL statement valid?
-
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?
-
Use the magnitudes (Richter scale) of the earthquakes listed in Data Set 16 in Appendix B. In 1989, the San Francisco Bay Area was struck with an earthquake that measured 7.0 on the Richter scale....
-
Which do you think has less variation: the IQ scores of students in your statistics class or the IQ scores of a simple random sample taken from the general population? Why?
-
Based on data from Data Set 17 in Appendix B, the words spoken in a day by women have a mean of 16,215 words and a standard deviation of 7301 words. Consider the women with an unusual word count in a...
Study smarter with the SolutionInn App