Develop a forecasting model, justifying its selection over other techniques, and project attendance at each home game through 2017. What revenues are to be expected in 2016 and 2017? Discuss the school’s

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Southwestern University

Southwestern University (SWU), a large state college in Stephenville, Texas, enrolls close to 20,000 students. The school is a dominant force in the small city, with more students during fall and spring than permanent residents.

Always a football powerhouse, SWU is usually in the top 20 in college football rankings. Since the legendary Phil Flamm was hired as its head coach in 2009 (in hopes of reaching the elusive number 1 ranking), attendance at the five Saturday home games each year increased. Prior to Flamm’s arrival, attendance generally averaged 25,000 to 29,000 per game. Season ticket sales bumped up by 10,000 just with the announcement of the new coach’s arrival Stephenville and SWU were ready to move to the big time!

The immediate issue facing SWU, however, was not NCAA ranking. It was capacity. The existing SWU stadium, built in 1953, has seating for 54,000 fans. The following table indicates attendance at each game for the past 6 years.

Southwestern University Football Game Attendance, 2010-2015 2010

GAME

ATTENDEES

OPPONENT

1

34,200

Rice

2a

39,800

Texas

3

38,200

Duke

4b

26,900

Arkansas

5

35,100

TCU

2011

 

 

GAME

ATTENDEES

OPPONENT

1

36,100

Miami

2a

40,200

Nebraska

3

39,100

Ohio State

4b

25,300

Nevada

5

36,200

Ohio State

2012

 

 

GAME

ATTENDEES

OPPONENT

1

35,900

USC

2a

46,500

Texas Tech

3

43,100

Alaska

4b

27,900

Arizona

5

39,200

Baylor

 

 

2013

 

 

GAME

ATTENDEES

OPPONENT

1

41,900

Arkansas

2a

46,100

Missouri

3

43,900

Florida

4b

30,100

Central Florida

5

40,500

LSU

2014

 

 

GAME

ATTENDEES

OPPONENT

1

42,500

Indiana

2a

48,200

North Texas

3

44,200

Texas A&M

4b

33,900

Southern

5

47,800

Oklahoma

2015

 

 

GAME

ATTENDEES

OPPONENT

1

46,900

LSU

2a

50,100

Texas

3

45,900

South Florida

4b

36,300

Montana

5

49,900

Arizona State

 

  • Refers to Homecoming
  • During the fourth week of each season, Stephenville hosted a hugely popular Southwestern crafts festival. This event brought tens of thousands of tourists to the town, especially on weekends, and had an obvious negative impact on game attendance.

 

 

 

One of Flamm’s demands upon joining SWU had been a stadium expansion, or possibly even a new stadium. With attendance increasing, SWU administrators began to face the issue head-on. Flamm had wanted dormitories solely for his athletes in the stadium as an additional feature of any expansion.

SWU’s president, Dr. Joel Wisner, decided it was time for his vice president of development to forecast when the existing stadium would “max out.” The expansion was, in his mind, a given. But Wisner needed to know how long he could wait. He also sought a revenue projection, assuming an average ticket price of $50 in 2016 and a 5% increase each year in future prices.

Discussion Questions

  1. Develop a forecasting model, justifying its selection over other techniques, and project attendance at each home game through 2017.
  2. What revenues are to be expected in 2016 and 2017?
  3. Discuss the school’s
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 2 images

Blurred answer
Knowledge Booster
Introduction to Service marketing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.