For its first 2 decades of existence, the NBA’s Orlando Magic basketball team set seat prices for its 41-game home
But when Anthony Perez, director of business strategy, finished his MBA at the University of Florida, he developed a valuable database of ticket sales. Analysis of the data led him to build a
Studying individual sales of Magic tickets on the open Stub Hub marketplace during the prior season, Perez determined the additional potential sales revenue the Magic could have made had they charged prices the fans had proven they were willing to pay on Stub Hub. This became his dependent variable, y, in a multiple-regression model.
He also found that three variables would help him build the “true market” seat price for every game. With his model, it was possible that the same seat in the arena would have as many as seven different prices created at season onset—sometimes higher than expected on average and sometimes lower.
The major factors he found to be statistically significant in determining how high the demand for a game ticket, and hence, its price, would be were:
► The day of the week (x1)
► A rating of how popular the opponent was (x2)
► The time of the year (x3)
For the day of the week, Perez found that Mondays were the least-favored game days (and he assigned them a value of 1). The rest of the weekdays increased in popularity, up to a Saturday game, which he rated a 6. Sundays and Fridays received 5 ratings, and holidays a 3 (refer to the footnote in Table 4.2).
Fernado Medina
TABLE 4.2 Data for Last Year’s Magic Ticket Sales Pricing Model
His ratings of opponents, done just before the start of the season, were subjective and range from a low of 0 to a high of 8. A very high-rated team in that particular season may have had one or more superstars on its roster, or have won the NBA finals the prior season, making it a popular fan draw.
Finally, Perez believed that the NBA season could be divided into four periods in popularity:
► Early games (which he assigned 0 scores)
► Games during the Christmas season (assigned a 3)
► Games until the All-Star break (given a 2)
► Games leading into the play-offs (scored with a 3)
The first year Perez built his multiple-regression model, the dependent variable y, which was a “potential premium revenue score,” yielded an R2 =.86 with this equation:
Table 4.2 illustrates, for brevity in this case study, a sample of 12 games that year (out of the total 41 home game regular season), including the potential extra revenue per game (y) to be expected using the variable pricing model.
A leader in NBA variable pricing, the Orlando Magic have learned that regression analysis is indeed a profitable forecasting tool.
2. Use the data to build a model with rating of the opponent as the sole independent variable.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
OPEARATIONS MANAG.REV CUSTOM 2017
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardBetty, the chief of nursing executive, need to make a decision about buying 340 new hospital beds for patient rooms. After she interviewed nurse managers at the units where the beds were going to be placed, Betty compiled her findings and decided to contact a well-known equipment company to obtain prices and a bid. No bids from other companies were obtained. The equipment company’s executive salesperson, Jim, discussed options at length with her and invited her and her significant other to an upcoming all-expense-paid, lavish junket at a five-star hotel in Hawaii to see demonstrations of the beds and experience a comprehensive sales program. Betty thought, “We badly need some relaxations and stress relief. Hawaii would be so much fun. Would it be wrong for us to go? If you were Betty, what would you do? Justify your answer with ethical framework: theory, approach or principle. Discuss the ethical principles at stake. What breaches are possible? Do you consider this situation a conflict…arrow_forwardneed help asaparrow_forward
- Elsa Corporation, a company that manufactures and markets low-end table computers, asked ourfriend Ms. Market Researcher to create the demand curve for its SD 721 model. She conductedsome market research and gave Elsa the demand curve as well as some additional information:350,000 units of SD 721 will sell at a price of $250.(1) What is the point price elasticity if 500,000 units will sell at a price of $200? (2) What is the point price elasticity if 125,000 units will sell at a price of $305?arrow_forwardDemand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…arrow_forwardComputer Simulationarrow_forward
- B& Co. is a large manufacturer if an electronic product (NM65). It is the market leader in the particular product segment. The market size is increasing due to increasing popularity of its product. B& Co. has received an offer from a manufacturer of electronic products to produce NM 65 on half of B& Co. and directly supply to the customers of the Northern region. The billing on the customer will done by B& Co. The offer is economically attractive. Required: Write a note on what qualitative factors should be considered before deciding in favour or against accepting the offer.arrow_forwardSales of industrial vacuum cleaners at Yarena Supply CO. over the past 13 months are as follows: Sales in P1,000 Month Sales in P1,000 Month 11 January 14 August 14 February 17 September 15 March 12 October 10 April 14 November 15 May 16 December 17 June 11 January 11 July Required suing a moving average with three periods, determine the demand for vacuum cleaners for next February?arrow_forwardexplain discrete -event simulation model with example.arrow_forward
- A property's annual property taxes equaled $7,560. The seller owes the buyer for 20 days c prorated property taxes. Using the 360-day calendar, how much does the seller owe the buyer? $1,950 $360 $2,100 $420arrow_forwardProblem 3-14 (Algo) Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) 4,150 4,25e 3,950 4, 350 4,95e 4,650 5,25e 4,850 5,35e 5,65e 6,25e 5,95e January February March Аpril Мay June July August September October November December a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round Intermedlate calculatlons. Round your answers to 2 decimal places.) Month Forecast January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors…arrow_forwardConsider the following price and dividend data for Ford Motor Company: Dividend ($) Date December 31, 2004 January 26, 2005 April 28, 2005 July 29, 2005 October 28, 2005 December 30, 2005 Price ($) $14.04 $13.43 $9.14 OA. -44.4% OB. -40.2% OC.-42.32% OD. -38.1% $10.74 $8.02 $7.72 $0.12 $0.12 $0.12 $0.12 Assume that you purchased Ford Motor Company stock at the closing price on December 31, 2004 and sold it at the closing price on December 30, 2005. Your realized annual return is for the year 2005 is closest to:arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning