Monthly sales data for this year for QuikSell Realty are given in Table 2.10. The company wants a forecast of sales for the first quarter of next year (months 13, 14, and 15). Compute the forecasts using the following methods:

a. Last-value method

b. Averaging method

c. Three-month moving average method

d. Exponential smoothing with α = 0.25

e. Holt’s method with α = 0.4 and β = 0.5

f. Given the sales pattern for this year, do any of these methods seem inappropriate for obtaining next year’s forecasts? Is there another method you would recommend to get a better forecast for months 13, 14, and 15?

Transcribed Image Text:

TABLE 2.10 Sales Data for Exercise 2.7 Month Sales 34 33 42 34 123456 2 3 36 43 Month 7 8 9 10 11 12 Sales 34 33 43 31 35 41