Problem #2: (15 points, Forecasting Seasonality powerpoint). Note: The book and I have different ways of calculating seasonality. Both will get you the right answer, but in my opinion the book way is a little more complicated than it needs to be. Suppose that you are given the following sales data for the last three years, with Q1 being Quarter 1, etc. Golf Sets Sold Q1 Q2 Q3 Q4 2017 100 150 200 250 2018 150 150 250 350 2019 175 225 300 400 a) Calculate the seasonal adjustment factor (S1, S2, etc.) for Q1, Q2, Q3, and Q4. b) Suppose the linear trend equation is 500 + 200*Year, where 2017 is Year 1, 2018 is Year 2, etc. What would be the prediction for the year 2021? c) Using your forecast for 2021 from b) as F5, now calculate for me my expected sales in Q1, 2, 3, and 4 using the seasonal adjustment factors from a)