Develop a forecasting model justifying its selection over other techniques and project attendance through 2009?

Answer 1

Question Forecasting Attendance at SWU Football Games. Southwestern University (SWU) a large state college in Stephenville, Texas, 30 miles southwest of the Dallas/Fort Worth metroplex, enrolls close to 20,000 students. In a typical town-gown relationship, the school is a dominate force in the small city, with more student during the fall and spring than permanent residents. A longtime football powerhouse, SWU is a member of the Big Eleven conference and is usually in the top 20 in college football rankings. To bolster its chances of reaching the elusive and long-desired number-one ranking, in 2002 SWU hired the legendary Bo Pitterno as its head coach. Although the number-one ranking remained out of reach, attendance at the five Saturday home games increased. Prior to Pitterno'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 tables indicates attendance at each game for the past six years. One of Pitterno'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. Pitterno had wanted dormitories solely for this athletes in the stadium as an additional feature of any expansion. SWU's president, Dr. Matty Starr, decided it was time for his vice president of development to forecast when the existing stadium would "max out". He also sought a revenue projection, assuming an average ticket price of $20 in 2008 and a 5% increase each year in future prices. 1. Develop a forecasting model, justifying its selection over other techniques, and project attendance through 2009. 2. What revenues are to be expected in 2008 and 2009? 3. Give the school's options. 2002 GAME ATTENDEES OPPONENT 1 34,200 Baylor 2 39,800 Texas 3 38,200 LSU 4 26,900 Arkansas 5 35,100 USC 2003 GAME ATTENDEES OPPONENT 1 36,100 Oklahoma 2 40,200 Nebraska 3 39,100 UCLA 4 25,300 Nevada 5 36,200 Ohio State 2004 Game ATTENDEES OPPONENT 1 35,900 TCU 2 46,500 Texas Tech 3 43,100 Alaska 4 27,900 Arizona 5 39,200 Rice 2005 GAME ATTENDEES OPPONENT 1 41,900 Arkansas 2 46,100 Missouri 3 43,900 Florida 4 30,100 Miami 5 40,500 Duke 2006 Game ATTENDEES OPPONENT 1 42,500 Indiana 2 48,200 North Texas 3 44,200 Texas A&M 4 33,900 Southern 5 47,800 Oklahoma 2007 Game ATTENDEES OPPONENT 1 46,900 LSU 2 50,100 Texas 3 45,900 Prairie View A&M 4 36,300 Montana 5 49,900 Arizona State Question Forecasting Attendance at SWU Football Games. Southwestern University (SWU) a large state college in Stephenville, Texas, 30 miles southwest of the Dallas/Fort Worth metroplex, enrolls close to 20,000 students. In a typical town-gown relationship, the school is a dominate force in the small city, with more student during the fall and spring than permanent residents. A longtime football powerhouse, SWU is a member of the Big Eleven conference and is usually in the top 20 in College Football rankings. To bolster its chances of reaching the elusive and long-desired number-one ranking, in 2002 SWU hired the legendary Bo Pitterno as its head coach. Although the number-one ranking remained out of reach, attendance at the five Saturday home games increased. Prior to Pitterno'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 tables indicates attendance at each game for the past six years. One of Pitterno'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. Pitterno had wanted dormitories solely for this athletes in the stadium as an additional feature of any expansion. SWU's president, Dr. Matty Starr, decided it was time for his vice president of development to forecast when the existing stadium would "max out". He also sought a revenue projection, assuming an average ticket price of $20 in 2008 and a 5% increase each year in future prices. 1. Develop a forecasting model, justifying its selection over other techniques, and project attendance through 2009. 2. What revenues are to be expected in 2008 and 2009? 3. Give the school's options.