Question

Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec.
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Last year 130 150 155 215 225 230 175 165 155 230 255 280
This year 155 155 205 220 245 250

Answer 1

Answer:

665

Explanation:

The computation fo the demand expected for the third quarter is as follows:

Oct         230

Nov        255

Dec         280          sum 765

Jan          155

Feb          155

March      205         sum 515

April         220

May          245

June         250       sum 715

Mow the third quarter moving average is

= (765 + 515 + 715) ÷ 3

= 665