Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the table attached. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1.
|
The three-year moving average forecast for Wallace Garden Supply is . (Please round it to two decimal points and include no units.) Mark for Review Whats This?
|
The Mean Absolute Deviation (MAD) for the above moving average forecast is . (Please round it to two decimal points.) Mark for Review Whats This?
|
The three-year weighted moving average forecast for Wallace Garden Supply is . (Please round it to an integer and include no units.) Mark for Review Whats This?
|
The Mean Absolute Deviation (MAD) for the above weighted moving average forecast is . (Please round it to two decimal points.) Mark for Review Whats This?
|
Based on your previous calculation, which method do you think is the best?
A.3-year moving average. |
|
B.3-year weighted moving average. |
|
|
Sales of Cool-Man air conditioners have grown steadily during the past 5 years as shown in the attached table. The sales manager had predicted, before the business started, that year 1s sales would be 410 air conditioners. Please use exponential smoothing with a weight of a = 0.30 to answer the following questions.
|
The starting /initial forecast for the sales of Cool-Man air conditioners is _________. (Please round it to an integer and include no units.)
Reset Selection
Mark for Review Whats This?
|
The Year 2 forecast for the sales of Cool-Man air conditioners is . (Please round it to an integer and include no units.) Mark for Review Whats This?
|
The Year 6 forecast for the sales of Cool-Man air conditioners is . (Please round it to two decimal points and include no units.) Mark for Review Whats This?
|
The Mean Absolute Deviation (MAD) for the above exponential smoothing forecast is . (Please round it to two decimal points.)
|