Forecasting Ticket Revenue for Orlando Magic Basketball Games For its first two decades of existence, the NBA’s Orlando Magic basketball team set seat prices for its 41- game home schedule the same for each game. If a lower-deck seat sold for $150, that was the price charged, regardless of the opponent, day of the week, or time of the season. If an upper-deck seat sold for $10 in the first game of the year, it likewise sold for $10 for every game. 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 forecasting model he hoped would increase ticket revenue. Perez hypothesized that selling a ticket for similar seats should differ based on demand. 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 the following table). Team Date* Day of the week* Time of year Rating of opponent Additional sales potential Phoenix Suns November 4 Wednesday 0 0 $12,331 Detroit Pistons November 6 Friday 0 1 $29,004 Cleveland Cavaliers November 11 Wednesday 0 6 $109,412 Miami Heat November 25 Wednesday 0 3 $75,783 Houston Rockers December 23 Wednesday 3 2 $42,557 Boston Celtics January 28 Thursday 1 4 $120,212 New Orleans Pelicans February 3 Monday 1 1 $20,459 LA Lakers March 7 Sunday 2 8 $131,020 San Antonio Spurs March 17 Wednesday 2 1 $28,455 Denver Nuggets March 23 Sunday 2 1 $110,561 NY Knicks April 9 Friday 3 0 $44,971 Philadelphia 76ers April 14 Wednesday 3 1 $30,257 *Day of week rated as 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday, 7=Sunday, 8=holiday 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 playoffs (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 = 0.86 with this equation: Y = 14,996+10,801X1 + 23,397X2 +10,784X3 Table above illustrates, for brevity in this case steady, 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. QUESTIONS 1. Use the data in table to build a regression model with day of the week as they only independent variable. 2. Use the data to build a model with rating of the opponent as the sole independent variable. 3. Using Perez’s multiple regression model, what would be the additional sales potential of a Thursday Miami Heat game played during the Christmas holiday? 4. What additional independent variables might you suggest to include in Perez’s model?

Forecasting Ticket Revenue for Orlando Magic Basketball Games For its first two decades of existence, the NBA’s Orlando Magic basketball team set seat prices for its 41- game home schedule the same for each game. If a lower-deck seat sold for $150, that was the price charged, regardless of the opponent, day of the week, or time of the season. If an upper-deck seat sold for $10 in the first game of the year, it likewise sold for $10 for every game. 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 forecasting model he hoped would increase ticket revenue. Perez hypothesized that selling a ticket for similar seats should differ based on demand. 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 the following table). Team Date* Day of the week* Time of year Rating of opponent Additional sales potential Phoenix Suns November 4 Wednesday 0 0 $12,331 Detroit Pistons November 6 Friday 0 1 $29,004 Cleveland Cavaliers November 11 Wednesday 0 6 $109,412 Miami Heat November 25 Wednesday 0 3 $75,783 Houston Rockers December 23 Wednesday 3 2 $42,557 Boston Celtics January 28 Thursday 1 4 $120,212 New Orleans Pelicans February 3 Monday 1 1 $20,459 LA Lakers March 7 Sunday 2 8 $131,020 San Antonio Spurs March 17 Wednesday 2 1 $28,455 Denver Nuggets March 23 Sunday 2 1 $110,561 NY Knicks April 9 Friday 3 0 $44,971 Philadelphia 76ers April 14 Wednesday 3 1 $30,257 *Day of week rated as 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday, 7=Sunday, 8=holiday 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 playoffs (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 = 0.86 with this equation: Y = 14,996+10,801X1 + 23,397X2 +10,784X3 Table above illustrates, for brevity in this case steady, 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. QUESTIONS 1. Use the data in table to build a regression model with day of the week as they only independent variable. 2. Use the data to build a model with rating of the opponent as the sole independent variable. 3. Using Perez’s multiple regression model, what would be the additional sales potential of a Thursday Miami Heat game played during the Christmas holiday? 4. What additional independent variables might you suggest to include in Perez’s model?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section: Chapter Questions

Problem 41P: At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 =...

See similar textbooks