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
Operations Management: Sustainability and Supply Chain Management (12th Edition)
- “Implementing a Performance Management Communication Plan at Accounting, Inc.” Evaluate Accounting Inc.’s communication plan. Specifically, does it answer all of the questions that a good communication plan should answer? Which questions are left unanswered? How would you provide answers to the unanswered questions? “Implementing an Appeals Process at Accounting, Inc.” If you were to design an appeals process to handle these complaints well, what would be the appeal process? Describe the recommended process and why.arrow_forwardThe annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200 per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk ordering as given below. Can the manager reduce his costs by taking advantage of either of these discounts? Recommend the best ordering policy for the store. Order size Unit cost (Rs.) 1 – 49 pcs. 20.00 50 – 149 pcs. 19.50 150 – 299 pcs. 19.00 300 pcs. or more 18.00arrow_forwardHelp answer showing level work and formulasarrow_forward
- I need to forecast using a 3-Period-Moving-Average-Monthly forecasting model which I did but then I need to use my forecast numbers to generate a Master Production Schedule (MPS) I have to Start with actual sales (my own test data numbers) for August-2022 Oct-2022 i need to create MPS to supply demand starting November-2022 April 2023 I just added numbers without applying formulas to the mps on the right side of the spreadsheet because I do not know how to do it. The second image is the example of what it should look like. Thank You.arrow_forwardSolve the following Question 1. How do volume and variety affect the process selection and layout types? Discuss 2. How is the human resource aspect important to operation function? Discuss 3. Discuss the supply network design and its impact on the overall performance of the organization.arrow_forwardHelp with question?arrow_forward
- What are some good examples of bullet points on a resume for a Christian Elementary School?arrow_forwardWhat is an example of a cover letter for a Christian School Long-Term Substitute Teaching position?arrow_forwardThe supply chain is a conventional notion, but organizations are only really interested in making products that they can sell to customers. Provided they have reliable supplies of materials and reasonable transport for finished products, logistics is irrelevant. Do you think this is true? If yes, explain, and if no, clearly explain as well.arrow_forward
- working as a program operations managerarrow_forward12 X1, X230 1 x =0x2 write the Following linear Programming model by 1- general Form Canonical Forms Canonical formY 2- Standard Form Max Z=35X+ 4 X 2 +6 X3 ST. X+2X2-5x3 = 40 3X, + 6X2 + 7x 3 = 30 7x, +lox2 x3 = 50 X3 X 2 X 3 <0arrow_forwarda/ a Minimum cost assign each worker for one job at Jobs J1 12 33 WI 2 4 6 W2 5 W3 5 33 6 7arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningPractical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,