Q1) Develop a forecasting model to predict attendance for each of the five games by using the trend projections method. [hint: each round will have different prediction formulas]

Q2) what total projected attendance and revenues are expected in 2016 and 2017?

Southwestern University (SWU), a large state college in hired as its head coach in 2009 (in hopes of reaching the elusive Stephenville. Texas, enrolls close to 20,000 students. The sehool is number 1 ranking). attendance at the five Saturday home games a dominant force in the small city, with more students during fall each year inereased. Prior to Flamm's arrival, attendance generally and spring than permanent residents. Always a football powerhouse, SWU is usually in the top 20 by 10,000 just with the announcement of the new coach's arrival. in college football rankings. Since the legendary Phil Flamm was Stephenville and SWU were ready to move to the big time! Southwestern University Football Game Attendance, 2010-2015 "Homecoming games. "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. 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. 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