Given the followinghistory, use a three-quarter moving average to forecast the demandfor the third quarter of this year. Note that the 1st quarter isJan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug,Sep; and 4th quarter Oct, Nov, Dec.
JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDECLast year160180190230240260205195185260285310This year180190150250235210
Forecast for the thirdquarter
Expert Answer
3rd quarter –
July = (230+240+260)/3 = 243.3
Aug = (240+260+205)/3 = 235
Sep = (260+205+195)/3 = 220
4th quarter –
Oct = (205+195+185)/3 = 195
Nov = (195+185+260)/3 = 213.3
Dec = (185+260+285)/3 = 243.3