Question: 1. Calculate a forecast using a simple three-month moving average. 2. Calculate a forecast using a three-period weighted moving average. Use weights of 0.60,0.30, and

1. Calculate a forecast using a simple three-month moving average. 2. Calculate a forecast using a three-period weighted moving average. Use weights of 0.60,0.30, and 0.10 for the most recent period, the second most recent period, and the third most recent period, respectively. 3. Calculate a forecast using the exponential smoothing method. Assume the forecast for period 1 is 9,500. Use alpha = 0.40. 4. Once you have calculated the forecasts based on the above data, determine the error terms by comparing them to the actual sales for 2012 given below: PERIOD TIRES USED 2016 January 10,696 February 9,665 March 10,179 April 11,760 May 9,150 June 9,571 July 8,375 August 11,826 September 10,696 October 11,212 November 9,750 December 9,380 5. Based on the three methods used to calculate a forecast for TFY, which method produced the best forecast? Why? What measures of forecast error did you use? How could you improve upon this forecast
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
