Question & Answer: Given the following history, use a three-quarter moving average to forecast the demand for the third…..

Please, answer this problem (Forcast for the 3rd quarter).

And show the work please. I need all the calculation.

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

Expert Answer

Answer

the formula used in the moving average (d1 + d2+ d3)/3

Still stressed from student homework?

Get quality assistance from academic writers!

Order now