2) (20 points) Seasonality: The data in the table below (and avallable online) represent monthly gross sales for Ska Brewing Company from 2009 to 2012. This is real (old) data, let's help Ska forecast 2013.... a) Sum up the totals for each year and fill in the blanks below b) Forecast demand for each month and the total for 2013 using linear regression. What is your best estimate for total sales in 2013? Note: This table is transposed compared to the seasonality example we looked at in class -- in this case, you will be forecasting horizontally c) Graph the monthly data and forecasts (preferably in a different color) in chronological order to display the seasonal pattern. Insert the graph here: d) Determine the slope for each month and fill in the blanks below. According to the slopes, which two months are growing the fastest (at about the same rate)? e) Interpret the slope for the two fastest growing months and interpret the annual slope VD 13 Slope January February March April May June July August September October November December Total 9 $203,481 $180,674 5238,095 5242,372 $298.188 $314.763 $347,825 $352,121 5330,011 $314,756 $231,514 $245,591 10 $277,782 $235,592 5366,604 5284,723 $387,369 S449,907 5440,999 $495,822 $417 572 $460,234 $325 238 $355 135 11 $329,313 $333, 726 $352,353 5371,315 $622,500 $574,599 $528.422 $633,860 $422,091 $540,636 $323,034 $405.686 12 $385,117 $401,677 5436,746 5545,825 $669,204 $592.670 $623.534 $574,901 $546, 299 5737822 $549,011 $460.188