Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

Forecasting Ticket Revenue for Orlando Magic Basketball Games

For its first 2 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 Table 4.3). 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:

y = 14,996 + 10,801x1 + 23,397x2 + 10,784x3

Table 4.3 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.

TABLE 4.3 - Data for Last Year's Magic Ticket Sales Pricing Model

TEAM

DATE

DAY OF 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 Rockets

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

L. A. Lakers

March 7

Sunday

2

8

$231,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

Discussion Questions

1. Use the data in Table 4.3 to build a regression model with day of the week as the 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?

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92166542
  • Price:- $40

Guranteed 36 Hours Delivery, In Price:- $40

Have any Question?


Related Questions in Operation Management

Please help provide what to put on presentation slides from

Please help provide what to put on presentation slides from paper also give me what to say in front of the class. Strategies for confronting these problems and issues are generated through a SWOT analysis for Southwest. ...

Snow skiing and snowboarding remain popular hobbies more

Snow skiing and snowboarding remain popular hobbies. More than 10 million people in the United States participate in the activities each year. Ski resorts can be found across the country. The marketplace for equipment co ...

Part 1 post a responsebusiness strategy please respond to

Part 1: Post a Response "Business Strategy" Please respond to the following: Read the article titled, "What Killed Michael Porter's Monitor Group? The One Force That Really Matters," located in Week 1 of the course shell ...

The means of egress for a structure or facility is

The "Means of Egress" for a structure or facility is determined by what? Are fire drills required, and if so, how must drills be conducted? Why must the location points for fire and escape plans be calculated from the fa ...

1 why is it important to find out what others see as our

1. Why is it important to find out what others see as our skills? Do you have an example of something you were told you are good at, that you might not have thought about? How can it help us decide what kind of career we ...

Applied research technologies inc global innovations

Applied Research Technologies, Inc.: Global Innovation's Challenges By Christopher A.Bartlett and Heather beckham. Applied Research Technologies, Inc.: Global Innovation's Challenges 1. As Peter Vyas, how would you handl ...

1 what is the functional requirements for child care

1. What is the functional requirements for Child Care Organisation to introducing the new automated system? 2. Why is it important to gain a basic understanding of the available choices of business forms at the beginning ...

Asking the right questions is an important skill for

Asking the right questions is an important skill for strategic decision makers. Here are some questions that might be useful: How can we do that (don’t ask “Why can’t we do that?”)? How else can we do that? What else cou ...

1 how did uber digitally disrupts the taxi industry2 what

1. How did Uber Digitally Disrupts the Taxi Industry.. 2. What are the advantages to Coca-Cola to change to the beer model? 3. What are the potential downsides to management by exception. 4. Why are continuous improvemen ...

1 in what way is provision of services by independent

1. In what way is provision of services by independent public service providers similar and different from services provided through contracting, networks, and partnerships? 2. The Cajun Navy, Team Rubicon, and First Res ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As