# Question: Reconsider Prob 27 5 3 Ralph Billett realizes that the last value method

Reconsider Prob. 27.5-3. Ralph Billett realizes that the last-value method is considered to be the naive forecasting method, so he wonders whether he should be using another method. Therefore, he has decided to use the available Excel templates that consider seasonal effects to apply various statistical forecasting methods retrospectively to the past three years of data and compare their MAD values.

(a) Determine the seasonal factors for the four quarters.

(b) Apply the last-value method.

(c) Apply the averaging method.

(d) Apply the moving-average method based on the four most recent quarters of data.

(e) Apply the exponential smoothing method with an initial estimate of 25 and a smoothing constant of α = 0.25.

(f) Apply exponential smoothing with trend with smoothing constants of α = 0.25 and β = 0.25. Use initial estimates of 25 for the expected value and 0 for the trend.

(g) Compare the MAD values for these methods. Use the one with April 84 August 108 December 110 the smallest MAD to forecast sales in Quarter 1 of next year.

(h) Use the forecast in part (g) and the seasonal factors to make long-range forecasts now of the sales in the remaining quarters of next year.

(a) Determine the seasonal factors for the four quarters.

(b) Apply the last-value method.

(c) Apply the averaging method.

(d) Apply the moving-average method based on the four most recent quarters of data.

(e) Apply the exponential smoothing method with an initial estimate of 25 and a smoothing constant of α = 0.25.

(f) Apply exponential smoothing with trend with smoothing constants of α = 0.25 and β = 0.25. Use initial estimates of 25 for the expected value and 0 for the trend.

(g) Compare the MAD values for these methods. Use the one with April 84 August 108 December 110 the smallest MAD to forecast sales in Quarter 1 of next year.

(h) Use the forecast in part (g) and the seasonal factors to make long-range forecasts now of the sales in the remaining quarters of next year.

**View Solution:**## Answer to relevant Questions

Mark Lawrence—the man with two first names—has been pursuing a vision for more than two years. This pursuit began when he became frustrated in his role as director of human resources at Cutting Edge, a large company ...Reconsider Prob. 27.9-4. Use the linear regression procedure in the forecasting area of your IOR Tutorial to generate the linear regression line. On the resulting graph that shows this line and the five data points (as blue ...Suppose that the relation between Y and x is given by E(Y׀x) = Bx, Where Y is assumed to be normally distributed with mean Bx and known variance σ2. Also n independent pairs of observations are taken and are denoted by x1, ...Consider the historical data contained in the Excel File “Sales Data 1” on this website. Use ASPE to fit continuous distributions to these data. (a) Which distribution provides the closest fit to the data? What are the ...Reconsider Prob. 29.2-1. Suppose now that the given probabilities, 0.5 and 0.9, are replaced by arbitrary values, α and β, respectively. Solve for the steady-state probabilities of the state of the weather in terms of α ...Post your question