#
Question :
61) Given the following data, calculate the three-year moving averages

61) Given the following data, calculate the three-year moving averages for years 4 through 10.

Year |
Demand |

1 |
74 |

2 |
90 |

3 |
59 |

4 |
91 |

5 |
140 |

6 |
98 |

7 |
110 |

8 |
123 |

9 |
99 |

62) What is the forecast for May based on a weighted moving average applied to the following past demand data and using the weights: 4, 3, 2 (largest weight is for most recent data)?

Nov. |
Dec. |
Jan. |
Feb. |
Mar. |
April |

37 |
36 |
40 |
42 |
47 |
43 |

63) Weekly sales of copy paper at Cubicle Suppliers are provided in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week 8 with the more accurate method.

__Week____Sales (cases)__

117

221

327

431

519

617

721