Develop a four-month moving average forecast


Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. 185186A three-month moving average forecast was developed in the section on moving averages.

1.The four-month moving average forecast for Wallace Garden Supply is _13__________. (Please round it to an integer and include no units.)

A.17

B.18

C.19

D.20

2.The Mean Absolute Deviation (MAD) for the above forecast is . (Please round it to two decimal points.) 9.03

 

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 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. Which method do you thins best?

3.The three-year moving average forecast for Wallace Garden Supply is . (Please round it to two decimal points and include no units.)

4The Mean Absolute Deviation (MAD) for the above moving average forecast is . (Please round it to two decimal points.)

Mark for Review What's This?

5.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 What's This?

6.The Mean Absolute Deviation (MAD) for the above weighted moving average forecast is . (Please round it to two decimal points.)

7.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 1's sales would be 410 air conditioners. Please use exponential smoothing with a weight of to answer the following questions.

8.The starting /initial forecast for the sales of Cool-Man air conditioners is _________. (Please round it to an integer and include no units.)

A.400

B.410

C.430

D.450

Reset Selection

Mark for Review What's This?

9.The Year 2 forecast for the sales of Cool-Man air conditioners is (Please round it to an integer and include no units.)

10.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 What's This?

11.The Mean Absolute Deviation (MAD) for the above exponential smoothing forecast is . (Please round it to two decimal points.)

Request for Solution File

Ask an Expert for Answer!!
Other Subject: Develop a four-month moving average forecast
Reference No:- TGS0546988

Expected delivery within 24 Hours