Problem:
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 |
145 |
165 |
170 |
210 |
220 |
245 |
190 |
180 |
175 |
245 |
270 |
295 |
This year |
145 |
170 |
180 |
235 |
275 |
225 |
Required:
Question 1) What is the forecast for the third quarter? Solve the problem and show all work.