個案總覽

At the University of Wyoming, home games played by the men's basketball team generated significant revenues for the Athletics Department through ticket and concession sales. With the 2009-2010 season ending, it was time to forecast revenues for the upcoming season. Even though ticket prices were already set, providing a revenue forecast was difficult, as the schedule of home games for the 2010-2011 season was not yet known, and both ticket and concession sales for each game were uncertain.

Excel spreadsheet for instructors for product 8B11E034.

At the University of Wyoming, home games played by the men’s basketball team generated significant revenues for the athletics department through ticket and concession sales. With the 2009-2010 season ending, it was time to forecast revenues for the upcoming season. Even though ticket prices were already set, providing a revenue forecast was difficult, as the schedule of home games for the 2010-2011 season was not yet known, and both ticket and concession sales for each game were uncertain. A director of business operations for the athletics department needed to review data from the four most recent seasons and determine the best way to forecast revenues for the upcoming season.