1. The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts for the period indicated and error calculations for each type of forecast as indicated below: You can submit your Excel sheet for the answers if you want. However, be sure you answer question G.

1. 150, 155, 155, 162, 170, 175, 172, 155, 170, 172

1. 3 month moving average

1. What is the forecast for week 10?________

1. What is the Mean Absolute Error (MAE). ________________

1. What is the Mean Squared Error (MSE). _______________

1. What is the Mean Absolute Percentage Error (MAPE). ________

1. Weighted moving average. Use the weights of .88, .08 and .04 with .85 being the most current. In the Excel template, .88 should be in cell M15, .08 (L15), .04 (K15).

1. What is the forecast for week 10?________

1. What is the Mean Absolute Error (MAE)? ________________

1. What is the Mean Squared Error (MSE). _______________

1. What is the Mean Absolute Percentage Error (MAPE). ________

1. Exponential smoothing. Use an alpha level of .2

1. What is the forecast for week 10?________

1. What is the Mean Absolute Error (MAE)? ________________

1. What is the Mean Squared Error (MSE) _______________

1. What is the Mean Absolute Percentage Error (MAPE) ________