Case Problem: Capital State University Game-Day Magazines The case draws on mate from Chapters 2, 3, 7, and 11 DATA file Magazine CSU TABLE 20.1 Capital State University (CSU) in a leading Midwest University with a strong collegiate foot ball program. Kris Steel serves as CSU's Associate Athletic Director for External Affairs His job responsibilities include negotiating with commercial vendors for services such as concessions at sporting events, event staff and security, and game-day hospitality. Kris brokers deals for corporate sponsonship of CSU atletic programs and amunges for radio and television coverage of CSU athletic events. Kris also manages CSU sports advertising and marketing and sports information-related media relations for print, rade, television, and online Recently, Kris has been examining CSU's business arrangement with the publishing company that prints the game-day sports magarines for CSU home football games. As part of a recent comprehensive university-wide sports media contract, CSU has a new publish ing agreement with its print vender. The magazines typically contain about 60 pages of information on the CSU football team and its opponent for that week. The magazines are sold at vendor stands positioned outside of CSU's football stadium Currently, CSU places one order in July, several months prior to the first home football game, that states how many magazines CSU wants for each home game of the season. The publishing company prints the magazines and ships all magazines to CSU prior to the first game of the season. From data collected in past football seasons, Kris knows that CSU is often off by a con siderable amount in their order quantities. Most weeks, CSU has many leftover magazines. but because the magazines are tailored to each home opponent, they cannot be resold in future weeks. In some weeks in previous football seasons, demand surpassed supply and CSU ran out of football magazines. Currently, CSU determines onder quantities for each home game by looking at the past season's oeder quantities and then adjusting this amount up or down based on a gut feeling on how popular the carest season's game would be in comparison to games in the previous season Kris believes that it should be possible to improve this ordering process. He has located data from the past nine football seasons. Kris has information on the following variables for cach home game: the number of magarines sold, the year the game took place, the week that the game took place during the season, the opponent's preseason ranking, the number of preseason tickets sold for that game, the total game attendance, CSU's presea son rank, the number of the home game within CSU's season, whether or not the game was an in-conference game for CSU, whether or not the game was Homecoming for CSU, the game-day weather, the game-day kickoff temperature, the number of wins and losses for CSU's opponent in the previous season, and the number of wins and losses for CSE in the previous season. These data are in the file Megecine CSU, Table 20.1 displays the data for Years 1 and 2. Kris also noted that the CSU game in Week 1 of Year 8 was somewhat of an anomaly because CSU wore special throwback uniforms to honor the players from their only National Championship season, which greatly increased attendance at that game. Portion of Data Available for Use in Determining How Many CSU Football Magazines to Order 11- 1