Question

In: Statistics and Probability

For its first 2 decades of existence, the NBA’s Orlando Magic basketball team set seat prices...

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).

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

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.

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?

Solutions

Expert Solution

Solution:-

The multiple regression model developed by 'P' director of business strategy is given as follows:

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

where,

y is the additional sales potential per game

x1 is the day of the week

x2 is the rating of the opponent

x3 is the time of the year

For a Thursday 'MH' game played during the Christmas holiday, the values for the three independent variables can be shown as follows :

x1 = Day of the week

= Thursday (christmas holiday)

= 3

x2 = Rating of the opponent

= Rating of 'MH'

= 3

x3 = Time of the year

= Games during Christmas Holiday

= 3

Therefore, inputting the values of the independent variables in the equation, the values for additional sales potential of a Thursday 'MH' game played during the Christmas holiday can be calculated as follows :

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

or, y = 14,996, + 10,801 * 3 + 23,397 * 3 + 10,784 * 3

or, y = 149,942

Therefore, the additional sales potential of a Thursday 'MH' game played during the Christams holiday is $149,942


Related Solutions

For a long time, a western football team set seat prices for its 15-game home schedule...
For a long time, a western football team set seat prices for its 15-game home schedule the same for each game. But when Nawaf Abdulaziz, director of business strategy, finished his IE at the King Abdulaziz University, 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. Studying individual sales of Western tickets on the open Makani marketplace during the prior season, Nawaf determined the...
Teams A and B play in a basketball tournament. The first team to win two games...
Teams A and B play in a basketball tournament. The first team to win two games in a row or a total of three games wins the tournament. What is the number of ways the tournament can occur? 14 12 8 10 How many different rearrangements are there of the letters in the word BUBBLE? 60 100 120 80 How many ways are there to arrange all the words in this tongue twister? CAN YOU CAN A CAN AS A...
Using Word, please complete the 2 requirements below: In January (its first year of existence) of...
Using Word, please complete the 2 requirements below: In January (its first year of existence) of 2017 ABC Corp issued 100,000 shares of 1.00 par stock for $1,750,000. ABC issued 10 year $200,000 bonds at 95 with a stated rate of 9%; and 20 year $400,000 at 105 with a stated rate of 9%. Amortized using the straight-line method. Both pay interest semi-annually.   ABC lastly issued 5% 5-year convertible debt for $105,000, par was 100,000. Interest paid annual on 1/1....
16#2 The following table provides the starting players of a basketball team and their heights Player...
16#2 The following table provides the starting players of a basketball team and their heights Player A B C D E Height (in.) 75 77 78 81 84 a. The population mean height of the five players is: 79 b. Find the sample means for samples of size 2. A, B: ?¯ = A, C: ?¯ = A, D: ?¯ = A, E: ?¯= B, C: ?¯ = B, D: ?¯ = B, E: ?¯ = C, D: ?¯= C,...
A basketball team has 5 players, 3 in ‘‘forward” positions (this includes the ‘‘center”) and 2...
A basketball team has 5 players, 3 in ‘‘forward” positions (this includes the ‘‘center”) and 2 in ‘‘guard” positions. How many ways are there to pick a team if there are 6 forwards, 4 guards, and 2 people who can play forward or guard?
Problem #2: Orlando Corporation is preparing the financial statements for the annual report to its shareholders...
Problem #2: Orlando Corporation is preparing the financial statements for the annual report to its shareholders for the fiscal year ended August 31, 2017. The income from operations for fiscal year 2017 was $1,250,000. The company incurred a 6% interest expense on $3,000,000 of debt, an obligation outstanding for the entire fiscal year that requires interest-only payments. The company uses a 40% effective tax rate for income taxes. The capital structure of Orlando Corporation on September 1, 2016, at the...
The Federal Reserve was founded in 1913. Trace its development over the first two decades of...
The Federal Reserve was founded in 1913. Trace its development over the first two decades of its existence. How was it structured originally until changes were made by the Banking Act of 1935? What role did it play in the recession of 1929 to 1933?
In 2017, the first year of its existence, Spider Ltd's accountant, in preparing both the income...
In 2017, the first year of its existence, Spider Ltd's accountant, in preparing both the income statement and the tax return, developed the following list of items creating differences between accounting and taxable income: 1.    The company sells its merchandise on an installment contract basis. In 2017,Spider elected, for tax purposes, to report the gross profit from these sales in the years the receivables are collected. However, for financial statement purposes, the company recognized all the gross profit in 2017....
In its first year of existence Vail Corp. (a C corporation) reported a loss for tax...
In its first year of existence Vail Corp. (a C corporation) reported a loss for tax purposes of $50,000. In year 2, it reports a $30,000 loss. For year 3, it reports taxable income from operations of $120,000. How much tax will Vail Corp. pay for year 3? Consult the corporate tax rate table provided to calculate your answer.
Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1...
Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started, which is 2/1//19 For example, if the current term started on April 1, 2018, then use April 1, 2017 – March 31, 2018. (Do NOT use these dates. Use the dates that match up with the current term.) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT