Forecasting Scenario: Ajax Manufacturing is an electronic test equipment manufacturing firm that markets a certain piece of specialty test equipment. Ajax has several competitors who currently market similar pieces of equipment. While customers have repeatedly indicated they prefer Ajax's test equipment, they have historically proven to be unwilling to wait for Ajax to manufacture this certain piece of equipment on demand and will purchase their test equipment from Ajax's competitors in the event Ajax does not have the equipment available in inventory for immediate delivery. Thus, the key to Ajax successfully maintaining market share for this particular piece of equipment has been to have it available in stock for immediate delivery. Unfortunately, it is a rather expensive piece of equipment to maintain in inventory. Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Actual Number of Sold Units 33 36 32 35 33 34 34 38 37 36 38 36 37 39 35 Period 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Actual Number of Sold Units 38 37 37 37 35 37 34 35 34 36 32 35 33 38 37 31 ? Forecast ? Thus, the president of Ajax Manufacturing is very interested in accurately forecasting market demand in order to ensure he has adequate inventory available to meet customer demand without incurring undue inventory costs. His sales department has provided historical data (in the table above) regarding market demand for this certain piece of specialty electronics test equipment for the past 30 months. Model 1: Answer the following questions. Question 1 Calculate the projected demand for the test equipment for the time periods 4 - 31 based upon a 3month moving average forecast model. What is the projected demand for period 31? 36.67 37.33 36.33 36.00 Question 2 Calculate the mean absolute deviation (MAD) for the 3-month moving average forecast for each of the time periods 4 through 30 and for the model. 2.037 1.605 1.593 1.420 Question 3 Calculate the mean squared error (MSE) for the 3-month moving average forecast for time periods 4 through 30 and for the model. 3.31 4.10 4.40 6.77 Question 4 Calculate the mean absolute percent error (MAPE) for the 3-month moving average forecast for time periods 4 through 30 and for the model. 5.52% 4.41% 4.44% 3.96% Question 5 Calculate the Standard Error for the model. 2.105 2.704 1.892 2.181 Question 6 Calculate the Bias for the model. 0.2346 0.2716 0.3086 0.3827 Model 2: Answer the following questions. Question 7 Calculate the projected demand for the test equipment for the time periods 4 - 31 based upon a 3month moving average forecast model for which the weighting factor for actual demand one month ago is 3, the weighting factor for actual demand two months ago is 2, and the weighting factor for actual demand three months ago is 1. What is the projected demand for period 31? 37.17 36.67 37.67 38.67 Question 8 Calculate the mean absolute deviation (MAD) for the 3-month weighted moving average forecast for each of the time periods 4 through 30 and for the model. 2.086 1.593 1.642 1.420 Question 9 Calculate the mean squared error (MSE) for the 3-month weighted moving average forecast for time periods 4 through 30 and for the model. 3.325 4.004 4.274 6.626 Question 10 Calculate the mean absolute percent error (MAPE) for the 3-month weighted moving average forecast for time periods 4 through 30 and for the model. 5.67% 4.55% 4.10% 3.96% Question 11 Calculate the Standard Error for the model. 1.895 2.080 2.675 2.148 Question 12 Calculate the Bias for the model. 0.222 0.296 0.370 0.259 Model 3: Answer the following questions. Question 13 Calculate the projected demand for the test equipment for the time periods 1 - 31 based upon using an exponential smoothing forecast model for which alpha = 0.25. Assume the Forecast is equal to the Demand for period 1. What is the projected demand for period 31? 36.05 36.87 36.26 35.65 Question 14 Calculate the mean absolute deviation (MAD) for the exponential smoothing forecast for each of the time periods 1 through 30 and for the model. 1.485 1.644 1.623 2.000 Question 15 Calculate the mean squared error (MSE) for the exponential smoothing forecast for time periods 1 through 30 and for the model. 6.172 4.173 3.558 4.373 Question 16 Calculate the mean absolute percent error (MAPE) for the exponential smoothing forecast for time periods 1 through 30 and for the model. 4.16% 4.51% 5.45% 4.57% Question 17 Calculate the Standard Error for the model 2.164 2.572 2.114 1.952 Question 18 Calculate the Bias for the model. 0.354 0.435 0.407 0.516 Model 4: Answer the following questions. Question 19 Calculate the projected demand for the test equipment for the time periods 1 - 31 based upon using a Regression forecast model. What is the projected demand for period 31? 36.53 37.01 36.51 36.00 Question 20 Calculate the mean absolute deviation (MAD) for the Regression forecast for each of the time periods 1 through 30 and for the model. 1.616 1.795 1.703 1.979 Question 21 Calculate the mean squared error (MSE) for the Regression forecast for time periods 1 through 30 and for the model. 3.523 4.027 4.379 5.623 Question 22 Calculate the mean absolute percent error (MAPE) for the Regression forecast for time periods 1 through 30 and for the model. 5.06% 4.58% 4.80% 5.50% Question 23 Calculate the Standard Error for the model. 2.166 1.943 2.077 2.454 Question 24 Calculate the Bias for the model. 0.435 0.296 0.595 0.000 Question 25 Discuss the correlation between the two variables and is the relationship significant at the 95% level of confidence? The calculated r = 0.1573 is not significant at the 0.05 level of confidence The calculated r = 0.1740 is not significant at the 0.05 level of confidence The calculated r = 0.1728 is not significant at the 0.05 level of confidence The calculated r = 0.1182 is not significant at the 0.05 level of confidence Question 26 Based upon using mean absolute deviation (MAD) as a measure of forecast accuracy, which of the preceding forecast models provides the greatest degree of forecasting accuracy, and which of the preceding forecast models provides the least degree of forecasting accuracy The Model 1 or 2 provides the greatest degree of accuracy while Model 4 provides the least. The Model 1 provides the greatest degree of accuracy while Model 4 provides the least. The Model 4 provides the greatest degree of accuracy while Model 2 provides the least. The Model 4 provides the greatest degree of accuracy while Model 3 provides the least. Question 27 Based upon using Bias as a measure of forecast accuracy, which of the preceding forecast models provides the greatest degree of forecasting accuracy, and which of the preceding forecast models provides the least degree of forecasting accuracy? The Model 1 provides the greatest degree of accuracy while Model 3 provides the least. The Model 3 provides the greatest degree of accuracy while Model 2 provides the least. The Model 4 provides the greatest degree of accuracy while Model 3 provides the least. The Model 4 provides the greatest degree of accuracy while Model 1 provides the least. Question 28 Based upon using the Standard Error as a measure of forecast accuracy, which of the preceding forecast models provides the greatest degree of forecasting accuracy, and which of the preceding forecast models provides the least degree of forecasting accuracy? The Model 2 provides the greatest degree of accuracy while Model 1 provides the least. The Model 1 provides the greatest degree of accuracy while Model 3 provides the least. The Model 4 provides the greatest degree of accuracy while Model 1 provides the least. The Model 4 provides the greatest degree of accuracy while Model 3 provides the least