# Question: The Centerville Water Department provides water for the entire town

The Centerville Water Department provides water for the entire town and outlying areas. The number of acre-feet of water consumed in each of the four seasons of the three preceding years is shown below.

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

(b) After considering seasonal effects, use the last-value method to forecast water consumption next winter.

(c) Assuming that each of the forecasts for the next three seasons is correct, what would the last-value method forecast as the water consumption in each of the four seasons next year?

(d) After considering seasonal effects, use the averaging method to forecast water consumption next winter.

(e) After considering seasonal effects, use the moving-average method based on four seasons to forecast water consumption next winter.

(f) After considering seasonal effects, use the exponential smoothing method with an initial estimate of 46 and a smoothing constant of α = 0.1 to forecast water consumption next winter.

(g) Compare the MAD values of these four forecasting methods when they are applied retrospectively to the last three years.

(h) Compare the MSE values of these four forecasting methods when they are applied retrospectively to the last three years.

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

(b) After considering seasonal effects, use the last-value method to forecast water consumption next winter.

(c) Assuming that each of the forecasts for the next three seasons is correct, what would the last-value method forecast as the water consumption in each of the four seasons next year?

(d) After considering seasonal effects, use the averaging method to forecast water consumption next winter.

(e) After considering seasonal effects, use the moving-average method based on four seasons to forecast water consumption next winter.

(f) After considering seasonal effects, use the exponential smoothing method with an initial estimate of 46 and a smoothing constant of α = 0.1 to forecast water consumption next winter.

(g) Compare the MAD values of these four forecasting methods when they are applied retrospectively to the last three years.

(h) Compare the MSE values of these four forecasting methods when they are applied retrospectively to the last three years.

## Answer to relevant Questions

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 ...Luxury Cruise Lines has a fleet of ships that travel to Alaska repeatedly every summer (and elsewhere during other times of the year). A considerable amount of advertising is done each winter to help generate enough ...If a particle is dropped at time t = 0, physical theory indicates that the relationship between the distance traveled r and the time elapsed t is r = gtk for some positive constants g and k. A transformation to linearity can ...Consider the airline overbooking problem discussed in Sec. 28.5. The spreadsheet model is available on this website. The parameter analysis report generated in Sec. 28.7 (see Fig. 28.32) for this problem suggests that 185 is ...Assume that the probability of rain tomorrow is 0.5 if it is raining today, and assume that the probability of its being clear (no rain) tomorrow is 0.9 if it is clear today. Also assume that these probabilities do not ...Post your question