Develop forecasting model using regression analysis

Assignment Help Operation Management
Reference no: EM132119794

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.

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

2015 2016 2017 Game Attendance Opponent Attendance Opponent Attendance Opponent 1 41,900 Arkansas 42,500 Indiana 46,900 LSU 2a 46,100 Missouri 48,200 North Texas 50,100 Texas

3 43,900 Florida 44,200

Texas A&M

45,900

South Florida

4b 30,100 Central Florida

33,900 Southern 36,300 Montana

5 40,500 LSU 47,800 Oklahoma 49,900

Arizona State

a Homecoming games. b 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.

3 | P a g e

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 2018 and a 5% increase each year in future prices.

Questions:

(a) Develop a forecasting model using regression analysis, justifying its selection over other techniques, and project attendance through 2019.

Reference no: EM132119794

Questions Cloud

The assumptions made in quantitative easing : Explain the economic and financial aspects and the assumptions made in quantitative easing.
Merchandise replenishment cycle : Assume that Wal-Mart’s merchandise replenishment cycle is no more than 48 hrs.
Risk register for upgrading business to green energy : Create a risk register for upgrading a business to green energy.
Draw the product structure tree with low level coding : Draw the product structure tree with low level coding. Draw the corresponding time-phased diagram showing lead times to scale.
Develop forecasting model using regression analysis : Develop a forecasting model using regression analysis, justifying its selection over other techniques, and project attendance through 2019.
Barrier might have to be overcome when establishing standard : What barriers might have to be overcome when establishing this standard? Why?
Purchase paper from dunder mifflin : You purchase paper from Dunder Mifflin (DM). DM has been your paper supplier for the last 12 years.
Difference between business proposal and business plan : Difference between a business proposal and a business plan?
What is the theoretical flow time for an average pizza : What is the theoretical flow time for an average pizza? Show your work. What is the capacity of the process?

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd