What additional independent variables might you suggest

Assignment Help Operation Management

Reference no: EM131358128

Problem -

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:

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.

Southwestern University Football Game Attendance, 2010-2015
Game	2010		2011		2012
Game	Attendees	Opponent	Attendees	Opponent	Attendees	Opponent
1	34,200	Rice	36,100	Miami	35,900	USC
2^a	39,800	Texas	40,200	Nebraska	46,500	Texas Tech
3	38,200	Duke	39,100	Ohio State	43,100	Alaska
4^b	26,900	Arkansas	25,300	Nevada	27,900	Arizona
5	35,100	TCU	36,200	Boise State	39,200	Baylor

Game	2013		2014		2015
Game	Attendees	Opponent	Attendees	Opponent	Attendees	Opponent
1	41,900	Arkansas	42,500	Indiana	46,900	LSU
2^a	46,100	Missouri	48,200	North Texas	50,100	Texas
3	43,900	Florida	44,200	Texas A&M	45,900	South Florida
4^b	30,100	Central Florida	33,900	Southern	36,300	Montana
5	40,500	LSU	47,800	Oklahoma	49,900	Arizona State

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?

Reference no: EM131358128

Questions Cloud

Determine if restrictions on elastic constants are satisfied : The following data has been obtained experimentally for a composite based on an unidirectional carbon-epoxy prepreg (MR50 carbon fiber at 63% by volume in LTM25 epoxy). Determine if the restrictions on elastic constants are satisfied.

How information system and technology ought : An IS/IT Strategy is a planning document that clarifies how information system and technology ought to be used as a major aspect of an organization's overall business procedure and ought to be intended to support the association's overall plan of ..

Discuss about the tcp/ip and the osi model : Network Architecture Paper: Using either the OSI Reference Model or the TCP/IP Protocol Suite, describe how each layer of the Model/Suite represents the communication flow between organizational levels and across departments/division of an actual ..

Derive an expression for the failure moment per unit : Derive an expression for the moment of inertia per unit area in terms of the ratio r = h/b.- Derive an expression for the failure moment per unit area in terms of the ratio r = h/b, for a constant material strength Fx.

What additional independent variables might you suggest : Using Perez's multiple-regression model, what would be the additional sales potential of a Thursday Miami Heat game played during the Christmas holiday? What additional independent variables might you suggest to include in Perez's model

Demonstrating your exception handling : You decide to upload your recent project to a programming community website for feedback, and one thing that community users keep pointing to is the lack of exception handling.

List the steps involved in posting payments : List the steps involved in posting payments from secondary insurance companies. List the steps involved in posting payments from electronic Remittance Advices.

Design a box section to be used as a cantilever beam : Design a box section to be used as a cantilever beam of length L = 2 m subject to a tip load P = 1000 N. Limit the tip deflection δ to 1/300 of the span L of the beam.

Why are user roles are necessary for linux : Why are user roles are necessary for Linux. How are these roles and permissions similar or different from other user types in other operating systems?

User Account

All Pages