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-10 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-11 season was unknown, and both ticket and concession sales for each game were uncertain.

Assignment Imagine that you have been hired as a consultant for Bill Sparks, the Senior Associate Director of Business Operations for the Athletics Department. To help him and the University of Wyoming predict revenues for the coming year, you will need to answer the questions below. After performing the necessary analyses, prepare a short write-up that addresses the questions. The write-ups will be evaluated on their content and presentation, including logic, organization, grammar, and spelling.

Questions 1. Use simple linear regression to develop two models: one for predicting ticket sales and one for predicting concession sales. 2. Develop 3 simulation models to predict total revenue for a single 16-game season. One variable in your simulations should be the team's win percentage. Use Nave, Moving average, Weighted Moving Average(0.7, 0,2 0.2 and 0.1 respectively) and compare the models. The simulation models should be entered into a spreadsheet to facilitate multiple replications.

				Opponent	Single Game Tickets Sold	Concession Revenues	Single Game Tickets Revenues
Saturday	November	04,	2006	Non-Conference	1,704	3,158	20,448
Tuesday	November	07,	2006	Non-Conference	716	1,839	8,592
Saturday	November	11,	2006	Non-Conference	1,218	5,768	14,616
Wednesday	November	15,	2006	Non-Conference	1,083	4,117	12,996
Saturday	November	18,	2006	Non-Conference	1,755	5,246	21,060
Wednesday	November	29,	2006	Non-Conference	909	2,583	10,908
Wednesday	December	06,	2006	Non-Conference	1,107	3,687	13,284
Saturday	December	16,	2006	Non-Conference	909	4,766	10,908
Wednesday	January	10,	2006	Conference	2,581	4,776	30,972
Saturday	January	13,	2007	Conference	3,694	8,222	44,328
Wednesday	January	24,	2007	Conference	3,462	8,652	41,544
Saturday	January	27,	2007	Conference	2,474	8,908	29,688
Tuesday	February	06,	2007	Conference	1,879	5,290	22,548
Saturday	February	17,	2007	Conference	2,778	7,365	33,336
Wednesday	February	21,	2007	Conference	1,297	5,214	15,564
Saturday	March	03,	2007	Conference	2,380	6,487	28,560
Saturday	November	03,	2007	Non-Conference	995	3,201	11,940
Tuesday	November	06,	2007	Non-Conference	717	2,330	8,604
Saturday	November	10,	2007	Non-Conference	1,266	3,424	15,192
Monday	November	26,	2007	Non-Conference	1,615	2,714	19,380
Saturday	December	08,	2007	Non-Conference	1,469	3,392	17,628
Saturday	December	29,	2007	Non-Conference	1,033	3,132	12,396
Monday	December	31,	2007	Non-Conference	688	1,509	8,256
Saturday	January	05,	2007	Conference	941	3,181	11,292
Wednesday	January	16,	2008	Conference	1,095	2,848	13,140
Saturday	January	26,	2008	Conference	1,894	5,050	22,728
Saturday	February	02,	2008	Conference	1,853	5,598	22,236
Wednesday	February	06,	2008	Non-Conference	660	1,616	7,920
Wednesday	February	13,	2008	Conference	601	1,961	7,212
Tuesday	February	19,	2008	Conference	757	2,490	9,084
Saturday	February	23,	2008	Conference	1,411	4,284	16,932
Saturday	March	01,	2008	Conference	1,664	4,857	19,968
Friday	Novembe	07,	2008	Non-Conference	941	2,102	11,292
Friday	November	14,	2008	Non-Conference	839	2,384	10,068
Wednesday	November	19,	2008	Non-Conference	3,084	2,714	37,008
Saturday	November	22,	2008	Non-Conference	1,559	3,144	18,708
Wednesday	November	26,	2008	Non-Conference	593	2,642	7,116
Saturday	November	29,	2008	Non-Conference	937	3,718	11,244
Tuesday	December	16,	2008	Non-Conference	522	1,838	6,264
Saturday	December	20,	2008	Non-Conference	635	4,083	7,620
Wednesday	January	14,	2009	Conference	1,723	4,968	20,676
Saturday	January	24,	2009	Conference	3,172	6,879	38,064
Tuesday	January	27,	2009	Conference	987	2,100	11,844
Saturday	February	07,	2009	Conference	1,995	5,658	23,940
Wednesday	February	18,	2009	Conference	855	2,374	10,260
Saturday	February	21,	2009	Conference	1,953	5,674	23,436
Wednesday	March	04,	2009	Conference	2,235	6,262	26,820
Saturday	March	07,	2009	Conference	2,972	7,624	35,664
Saturday	November	07,	2009	Non-Conference	2,273	3,504	27,276
Friday	November	13,	2009	Non-Conference	1,534	2,879	18,408
Wednesday	November	18,	2009	Non-Conference	729	1,958	8,748
Saturday	November	21,	2009	Non-Conference	1,483	3,204	17,796
*Friday	November	27,	2009	Non-Conference	742	2,355	8,904
*Saturday	November	28,	2009	Non-Conference	652	1,759	7,824
*Sunday	November	29,	2009	Non-Conference	488	1,521	5,856
Saturday	December	05,	2009	Non-Conference	2,446	2,058	29,352
Sunday	December	20,	2009	Non-Conference	515	3,733	6,180
Wednesday	December	30,	2009	Non-Conference	599	2,201	7,188
Saturday	January	02,	2010	Non-Conference	652	2,526	7,824
Wednesday	January	06,	2010	Conference	583	2,064	6,996
Saturday	January	09,	2010	Conference	1,012	3,745	12,144
Saturday	January	16,	2010	Conference	2,327	6,716	27,924
Wednesday	January	27,	2010	Conference	1,009	2,730	12,108
Wednesday	February	03,	2010	Conference	897	2,036	10,764
Saturday	February	13,	2010	Conference	1,519	4,558	18,228
Saturday	February	20,	2010	Conference	1,335	2,429	16,020
Tuesday	March	02,	2010	Conference	707	1,624	8,484

Annual data for the Previous Four Seasons
season	Year	No. of Season Tickets sold	Win Percentage
2006-2007	2006	4,088	0.619
2007-2008	2007	4,120	0.4
2008-2009	2008	3,844	0.643
2009-2010	2009	3,819	0.323