1. Develop a forecast with a three-period moving average and a four-period moving average. Identify which method is better by comparing MAD, MSE and MAPE.

4. Develop a budget for 2012 and 2013 by using a forecast for attendance by analyzing the forecasts you developed in Question1 to question 4. Justify the selection of the method.

Forecasting Football Game Attendance SWU hired the legendary Bo Pitterno as its head coach. at Southwestem University Although the number-one ranking remained out of reach, Southwestern University (SWU), a large state college in Ste- attendance at the five Saturday home games each year inphenville, Texas, 30 miles southwest of the Dallas/Fort Worth creased. Prior to Pitterno's arrival, attendance generally metroplex, enrolls close to 20,000 students. In a typical town- averaged 25,000 to 29,000 per game. Season ticket sales gown relationship, the school is a dominant force in the small bumped up by 10,000 just with the announcement of the city, with more students during fall and spring than permanent new coach's arrival. Stephenville and SWU were ready to residents. move to the big time! A longtime football powerhouse, SWU is a member of The immediate issue facing SWU, however, was not the Big Eleven conference and is usually in the top 20 in NCAA ranking; it was capacity. The existing SWU stadium, college football rankings. To bolster its chances of reaching built in 1953, has seating for 54,000 fans. The table on the next the elusive and long-desired number-one ranking, in 2006 page indicates attendance at each game for the past six years: 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. Source: J. Heizer and B. Render. Operations Management, 10th ed., 2011. Reprinted by permission of Pearson Education, Inc., Upper Saddle River, NJ. One of Pitterno's demands upon joining SWU had been a assuming an average ticket price of $20 in 2012 and a 5% instadium expansion, or possibly even a new stadium. With atten- crease each year in future prices. dance increasing, SWU administrators began to face the issue head-on. Pitterno had wanted dormitories in the stadium, solely for his athletes, as an additional feature of any expansion. SWU's president, Dr. Marty 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, Forecasting Football Game Attendance SWU hired the legendary Bo Pitterno as its head coach. at Southwestem University Although the number-one ranking remained out of reach, Southwestern University (SWU), a large state college in Ste- attendance at the five Saturday home games each year inphenville, Texas, 30 miles southwest of the Dallas/Fort Worth creased. Prior to Pitterno's arrival, attendance generally metroplex, enrolls close to 20,000 students. In a typical town- averaged 25,000 to 29,000 per game. Season ticket sales gown relationship, the school is a dominant force in the small bumped up by 10,000 just with the announcement of the city, with more students during fall and spring than permanent new coach's arrival. Stephenville and SWU were ready to residents. move to the big time! A longtime football powerhouse, SWU is a member of The immediate issue facing SWU, however, was not the Big Eleven conference and is usually in the top 20 in NCAA ranking; it was capacity. The existing SWU stadium, college football rankings. To bolster its chances of reaching built in 1953, has seating for 54,000 fans. The table on the next the elusive and long-desired number-one ranking, in 2006 page indicates attendance at each game for the past six years: 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. Source: J. Heizer and B. Render. Operations Management, 10th ed., 2011. Reprinted by permission of Pearson Education, Inc., Upper Saddle River, NJ. One of Pitterno's demands upon joining SWU had been a assuming an average ticket price of $20 in 2012 and a 5% instadium expansion, or possibly even a new stadium. With atten- crease each year in future prices. dance increasing, SWU administrators began to face the issue head-on. Pitterno had wanted dormitories in the stadium, solely for his athletes, as an additional feature of any expansion. SWU's president, Dr. Marty 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