Videos
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.
1. Use the data in Table 4.2 to build a regression model with day of the week as the only independent variable.
4. What additional independent variables might you suggest to include in Perez’s model?
Want to see the full answer?
Check out a sample textbook solution
Chapter 4 Solutions
Operations Management
- 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_forwardDemand(box) 10 11 12 13 14 15 and and more less Possibility 0.1 0.18 0.26 0.24 0.12 0.1 A business that will open a gift shop in Los Angeles is considering making and selling love- themed magnets. It is thought that it will not be possible to order new magnets during the fair period, and magnets that are not sold during the fair period will not be sold later. A box of magnets costs the business $100 and generates $460 from its sale. The table includes predictions about demand probabilities. a-) What is the overstocking cost of the business in dollars/box? b-) How many dollars/box is the missing stocking cost?arrow_forwardElsa 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_forward
- Help me with question 3arrow_forwardPower O Exponential Logarithmic O Polynomial QUESTION 9 If you try different startinng values for the changing cells and obtain different solutions: you can be confident there is no solution you can keep the best solution you have found and hope that it is indeed optimal O there must be a mistake in your objective function O there must be a mistake in one of your constraints QUESTION 10 In pricing models (i.e., Example 7.1), elasticity of demand is an input with specifies the: sensitivity of price to changes in demand O sensitivity of demand to changes in price range of demand lovolarrow_forwardQuestion 15, Question 16, Question 17, Question 18, Question 19, Question 20, Question 21, Question 22,arrow_forward
- 29 00:24 1 令.l 50 B/s Question no. 02: A Leading manufacturer of Action Figures is about to introduce four new Action Figures. The accompanying table summarizes price and cost data, combined fixed costs equal $650,000. A marketing research study predicts that for each unit sold of Noyan, 2 units of Dogan, 3 units of Bamsi and 4 units of Turgut will be sold. Action Figures Turgut Bamsi Dogan Novan Selling Price (in dollars) 35 26 24 16 Variable Cost/unit (in dollars) 17 12 12 11 Table 1 a) How many product mix units must be sold to break even? b) How does it translate into sales of individual games?arrow_forwardAnswer A.3 a-barrow_forwardPlease do not give solution in image format thankuarrow_forward
- In past 4 weeks, AOC (Arab oil company) started producing and distributing national engine oil to substitute French Total and Esso brands. Production reported to be in thousands: 2, 4, 3, 5 TG Thousand Gallons). AOC production will be calculated after 5 more weeks.arrow_forwardPrevious Problem Problem List Next Problem (1 point) Using diaries for many weeks, a study on the lifestyles of visually impaired students was conducted. The students kept track of many lifestyle variables including how many hours of sleep obtained on a typical day. Researchers found that visually impaired students averaged 9.2 hours of sleep, with a standard deviation of 2.24 hours. Assume that the number of hours of sleep for these visually impaired students is normally distributed. (a) What is the probability that a visually impaired student gets less than 6.4 hours of sleep? answer: (b) What is the probability that a visually impaired student gets between 6.2 and 8.84 hours of sleep? answer: (c) Thirty percent of students get less than how many hours of sleep on a typical day? answer: hours Note: You can earn partial credit on this problem. Preview My Answers Submit Answers You have attempted this problem 0 times. You have unlimited attempts remaining.arrow_forwardComputer Simulationarrow_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