Moving Average and Exponential Smoothing, please answer all, thanks!

1 1 point Weekly sales of a hammer at a home improvement store have been 9, 25, 22, 35, 12. & 15 over the past 6 weeks. The following table shows the forecasts until week 5, using 3 periods Moving Average (MA-3) and Exponential Smoothing with a-0.15 [ES(O.15)). Week Actual Demand MA-3 Forecast ES(0.15) Forecast 1 9 2 25 9 (Note that this is a naive forecast: actual demand observation in Week 1) 3 22 0.15/25)+0.85(9) 11.4 4 35 19+25+22)/3- 0.15(22)+0.85(11.4) - 18,667 12.99 5 12 27.333 16.292 6 15 ? 7 ? Round your calculations to 3 decimal places in each step.) What is the 3 Period Moving Average (MA-3) Forecast for Week 6? Type your answer. UN 1 point What is the 3 Period Moving Average (MA-3) Forecast for Week 7? Type your answer 3 1 point What is the Exponential Smoothing Forecast for Week 6, using a=0.15? Type your answer 4 1 point What is the Exponential Smoothing Forecast for Week 7 using a= 0.15 Type your answer 5 1 point A national park carefully monitors the number of international visitors using the park. For the first six months of operations, the following figures were recorded Month of Visitors Month of Visitors 1. January 133 4. April 640 2. February 183 5.May 1.876 3. March 285 6. June 2550 The trend line equation based on the above data is: F--307.4+ 500.54t. (Try getting this trendline in Excel.) What will be the forecast for the number of visitors in August? Type your answer 6 I point The following applies to Questions 6 - 10. Keep 3 decimal places in answers The following table provides actual monthly demand observations and forecasts based on two different methods (Moving Averages and Exponential-Smoothing, Demand Moving-Averages Exponential-Smoothing Forecast Forecast 22 17 12 34 20 12 28 22 15 23 21 AN 13 16 19 16 What is the Mean Absolute Deviation (MAD) considering the actual demand and the Moving-Averages forecasts? (Note: you will have to use absolute errors for the calculation, i.e., negative errors should be converted into positive.) Type your answer 7 spoint What is the Mean Absolute Percentage Error (MAPE) considering the actual demand and the Moving Averages forecasts? (Just type in the number; do not type '%' symbol.) Type your answer 8 1 point What is the Mean Absolute Deviation (MAD) considering the actual demand and the Exponential-Smoothing forecasts? Type your answer 1 point What is the Mean Absolute Percentage Error (MAPE) considering the actual demand and the Exponential-Smoothing forecasts? Type your answer 10 1 point Based on the MAPE measures (calculated for Questions 2 and 4), which method has performed better? Moving Averages Exponential Smoothing