You are the owner of a franchise that sells mobile phones. Below is a chart showing sells for the past 10 weeks. You want to start forecasting future sells but not sure which forecast method is best. To help you with this decision you decided to use the data below to calculate forecasts using 3 different methods (moving average, weighted moving average and exponential smoothing). You will determine which of the forecasts is best using the MAPE calculation to see which of the forecast is most accurate. Use the outline below to do your analysis.

Week	Mileage
1	48
2	52
3	59
4	58
5	57
6	54
7	56
8	60
9	59
10	62

1. Calculate a 2 week moving average forecast.
2. Calculate a 3 week weighted moving average with weights of 3, 2, 1 with the highest weights given to the most recent data to make them more significant.
3. Calculate the exponential smoothing for the above data using smoothing constants of .1, .3 and .5. Use 40 as the forecast for week 1.
4. Calculate the MAPE for each of the forecasts.
5. Which of the five forecast methods (2 week, 3 week weighted moving average, exponential smoothing of .1, .3 or .5) is best based on the MAPE calculation.