HANDWRITTEN SOLUTION ONLY. NO EXCEL

leeside Food Vending operates vending machines in office buildings, the airport, bus stations, colleges and universities, and other businesses and agencies around town, and operates vending trucks for building and construction sites. The company believes its sandwich sales (in 1000s) follow a seasonal pattern. It has accumulated the following data for sandwich sales per season during the past four years. Season Fall Winter Spring Summer Total 2011 42.7 36.9 51.3 62.9 193.8 2012 44.3 42.7 55.6 64.8 207.4 2013 45.7 34.8 49.3 71.2 201 2014 40.6 41.5 47.3 74.5 203.9 Total 173.3 155.9 203.5 273.4 806.1 (a) Develop a seasonally adjusted forecast model for these sandwich sales data. What is the forecast for each season in 2015 if the total annual sales for 2015 is estimated to be 200? Does the data appear to have a seasonal pattern? Explain. (6+1 = 7 marks) (b) What is the forecast for each of the remaining seasons in 2012 (summer, fall) if the forecast for spring 2012 was 57 and exponential smoothing with a = 0.4 is used? (3 marks) (c) What is the forecast for winter 2015 if Holt's method with a = 0.3 and B = 0.8 is used? If actual sales turn out to be 15% more than the forecasted value, what is the forecast for the spring? (8 marks) (d) Suppose the sales data for 2010 was used in the Trend Projection method to develop a forecast for 2011. Using the trend line, the forecast for spring and summer 2011 was 54 and 60 respectively. What is the forecast fall 2011? (6 marks)