Question: 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

HANDWRITTEN SOLUTION ONLY. NO EXCEL

HANDWRITTEN SOLUTION ONLY. NO EXCEL leeside Food

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!