SWU is a large state college situated in city T where the sign-up student capacity is close to 20,000. SWU is known for its football team, which falls in top 20 rankings. With the aim of reaching number 1 ranking, Person PF was hired as the head coach in 2012. Since then, the attendance of Saturday games increased each year. Attendance ranged from 25,000 to 29,000 per game. The season ticket has increased by 10,000 just when the declaration of the new head coach was made. SWU faced an issue apart from increasing the NCAA ranking. The old stadium, which was constructed in 1953 with a seating capacity of 54,000, was the major concern of SWU. The newly appointed head coach demanded the reconstruction of the old stadium with separate dormitories for his players. With the expanding attendance, the President, Person J, wanted his Vice President to forecast with the past data and discover how long it would take the stadium to reach its maximum capacity. The average ticket price was $50 in 2019 and there was a 5% raise each year in the future. The attendance data from 2013 to 2018 is given. To develop: Forecasting model and forecast the attendance through 2020.

Question

Want to see the full answer?

Answer 1

Question

Chapter 4, Problem 1CS

Summary Introduction

Case summary:

SWU is a large state college situated in city T where the sign-up student capacity is close to 20,000. SWU is known for its football team, which falls in top 20 rankings. With the aim of reaching number 1 ranking, Person PF was hired as the head coach in 2012. Since then, the attendance of Saturday games increased each year.

Attendance ranged from 25,000 to 29,000 per game. The season ticket has increased by 10,000 just when the declaration of the new head coach was made. SWU faced an issue apart from increasing the NCAA ranking. The old stadium, which was constructed in 1953 with a seating capacity of 54,000, was the major concern of SWU.

The newly appointed head coach demanded the reconstruction of the old stadium with separate dormitories for his players. With the expanding attendance, the President, Person J, wanted his Vice President to forecast with the past data and discover how long it would take the stadium to reach its maximum capacity. The average ticket price was $50 in 2019 and there was a 5% raise each year in the future. The attendance data from 2013 to 2018 is given.

To develop: Forecasting model and forecast the attendance through 2020.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Galaxy Co. sells virtual reality (VR) goggles, particularly targeting customers who like to play video games. Galaxy procures each pair of goggles for $150 from its supplier and sells each pair of goggles for $300. Monthly demand for the VR goggles is a normal random variable with a mean of 157 units and a standard deviation of 41 units. At the beginning of each month, Galaxy orders enough goggles from its supplier to bring the inventory level up to 140 goggles. If the monthly demand is less than 140, Galaxy pays $20 per pair of goggles that remains in inventory at the end of the month. If the monthly demand exceeds 140, Galaxy sells only the 140 pairs of goggles in stock. Galaxy assigns a shortage cost of $40 for each unit of demand that is unsatisfied to represent a loss-of-goodwill among its customers. Management would like to use a simulation model to analyze this situation. (Use at least 1,000 trials.) (a) What is the average monthly profit (in dollars)? (Round your answer to the…

Hospital administrators must schedule nurses so that the hospital's patients are provided adequate care. At the same time, careful attention must be paid to keeping costs down. From historical records, administrators can project the minimum number of nurses required to be on hand for various times of day and days of the week. The objective is to find the minimum total number of nurses required to provide adequate care. Nurses start work at the beginning of one of the four-hour shifts given below (except for shift 6) and work for 8 consecutive hours. Hence, possible start times are the start of shifts 1 through 5. Also, assume that the projected required number of nurses factors in time for each nurse to have a meal break. Formulate and solve the nurse scheduling problem as an integer program for one day for the data given below. (Let x = number of nurses who start work at the beginning of shift t, t = 1, 2, 3, 4, 5.) Shift Time Minimum Number of Nurses Needed 1 12:00 A.M. - 4:00 A.M.…

The Kolkmeyer Manufacturing Company uses a group of six identical machines, each of which operates an average of 23 hours between breakdowns. With randomly occurring breakdowns, the Poisson probability distribution is used to describe the machine breakdown arrival process. One person from the maintenance department provides the single-server repair service for the six machines. Management is now considering adding two machines to its manufacturing operation. This addition will bring the number of machines to eight. The president of Kolkmeyer asked for a study of the need to add a second employee to the repair operation. The service rate for each individual assigned to the repair operation is 0.40 machines per hour. (a) Compute the operating characteristics if the company retains the single-employee repair operation. (Round your answers to four decimal places. Report time in hours.) W L = q W = ✓ X h × h (b) Compute the operating characteristics if a second employee is added to the…