Use the scenario described below to answer the following question.

You are doing an internship with Macy's and are tasked with forecasting sales so that you can make inventory orders. You have weekly sales data for men's dress shirts in your store from each of the past six weeks. You decide to try both a 3-period moving average and exponential smoothing with = 0.6 to see which model is more accurate and then use that one to make forecasts. The sales data is shown below.

Week

# of Shirts Sold

Week 1

337 shirts sold

Week 2

448 shirts sold

Week 3

425 shirts sold

Week 4

383 shirts sold

Week 5

399 shirts sold

Week 6

402 shirts sold

What is the calculated Mean Squared Error (MSE) for the Exponential Smoothing method? Round intermediate calculations to 4 decimals and your final answer to the nearest whole number. Hint: Excel is your friend and can serve as calculator.