# SECTION #: NAME: 2) A coffee chain sells temperature controlled smart mugs at \$150 each. The monthly

SECTION #: NAME: 2) A coffee chain sells temperature controlled smart mugs at \$150 each. The monthly sales of mugs for the last twelve months were: 3 Month Moving Average 3 Month 6 Month Moving Average 6 Month MSE Month Sales MSE January 825 February 756 March 808 April 950 678 May June 875 695 July 589 August September 690 October 890 November 1030 1525 December (a) Compute a 3-month moving average demand forecast for each month from June through December Do your work below and fill in table above. (Round forecasts to nearest whole unit.) (3 points) (b) Compute a 5-month moving average demand forecast for each month from June through December Do your work below and fill in the table above. (Round forecasts to nearest whole unit.) (3 points) (c) Calculate the MSE (Mean Squared Error) covering June to December for each method. Box your answer. (3 points) (d) Which method is more likely to have a better forecast performance? Box your answer. (1 point)