Calculate a forecast of the above demand using a 3- and 5-period moving average.

Day Demand 1 200 2 134 3 157 4 165 5 177 6 125 7 146 8 150 9 182 10 197 11 136 Develop a spreadsheet to answer the following questions. 12 163 • Calculate a forecast of the above demand using a 3- and 5-period moving average. 13 157 • Graph these forecasts and the original data using Excel. What does the graph show? 14 169 • Which of the above forecasts is best? Why?