Procesos De Manufactura

Homework 3
(Due Feb 12th)


1. Ben Swanson, owner and manager of Swanson’s Department Store, has decided to use statistical forecasting to get a better handle on the demand for his majorproducts. However, Ben now needs to decide which forecasting method is most appropriate for each category of product. One category is major household appliances, such as washing machines, which have arelatively stable sales level. Monthly sales of washing machines last year are shown below.

|Month |Sales |Month |Sales |Month|Sales |
|January |23 |May |22 |September |21 |
|February |24|June |27 |October |29 |
|March |22 |July |20 |November|23 |
|April |28 |August |26 |December |28 |

(a) Considering that the saleslevel is relatively stable, which of the most basic forecasting methods—the last-value method or the averaging method or the moving-average method—do you feel would be most appropriate for forecastingfuture sales? Why?
(b) Use the last-value method retrospectively to determine what the forecasts would have been for the last 11 months of last year. What is MAD?
(c) Use the averaging methodretrospectively to determine what the forecasts would have been for the last 11 months of last year. What is MAD?
(d) Use the moving-average method with n=3 retrospectively to determine what theforecasts would have been for the last 9 months of last year. What is MAD?
(e) Use their MAD values to compare the three methods.
(f) Do you feel comfortable on drawing a definitive conclusion...