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

665

Step-by-step 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