Question

Forecast for July, using a 4-period weighted moving average. Assume the following weights: 0.4; 0.3; 0.2; and 0.1

Month Actual Demand
January 480
February 520
March 535
April 550
May 590
June 630

a. More than 0 but less than or equal to 500
b. More than 500 but less than or equal to 545
c. More than 545 but less than or equal to 600
d. More than 600 but less than or equal to 650
e. None of the choices are correct

Answer 1

c. More than 545 but less than or equal to 600

Step-by-step explanation:

The computation is shown below:

Forecast for July is

= 0.4 × June + 0.3 × May + 0.2 × April + 0.1 × Mar

= 0.4 × 630 + 0.3 × 590 + 0.2 × 550 + 0.1 × 535

= 592.5

So, it is more than 545 but lower than or equal to 600

Therefore the option c is correct