appeso questions 1-3. Weekly sales of ballpeen hammers at a home improvement store have been 14.9,30, 22, 34, 12.19.23 over the past 8 weeks. The following table shows the forecasts for weeks 4, 5 and 6 using 3 period Moving Average (MA-3) and Exponential Smoothing with a smoothing constant -0.15 [ES(O.15). Week Actual Demand MA-3 Forecast ES(0.15) Forecast 1 14 2 9 3 30 9 (Note that this is analve forecast actual demand observation in Week 23 4 22 (14.9+30173 17,667 -0.15301408510-12.15 5 34 20 333 0.15(22)+0,85(1215) - 13.628 12 28.667 16684 19 23 ON B (Round your calculations to 3 decimal places) Question 1: What is the period Moving Average (MAS) Forecast for Wook 71 22.667 2 Question 2What is the Period Moving Average IMA 3 Forecast for Week 21667 > Question 3 What is the Exponential Smoothing Forecast for Wook 7, using 2015? 1937 1 point Question 4: What is the Exponential Smoothing Forecast for Week 8 using 0.157 19.31 1 point Using Excel for these calculations can be convenient Question : What is the Mean Absolute Deviation (MAD) considering the actual demand and the MA-s forecasts for Woods 4 to 8 (total periods)? (Note: you wil have to une absolute errors for this calculation, to negative errors should be converted into positive) Type your answer Question: What is the Mean Squared Error (ME) considering the actual demand and the MA forecast for Weeks 1007 Type You Question 7: What is the Mean Absolute Percentage Error (MAPE) considering the actual demand and the MA3 forecasts for Weeks 4 to 87 (Note: you will have to use absolute errors for this calculation) Just type in the number, do not type symbol Type your answer. a 1 point For ESO.15) forecasts for Week 4 to Week, the MAD - 3.90; MSE - 117.25; and MAPE-37.63%. You may want to calculate these for practice Question 8: Which Method is better considering MAPE? MA-3 ES(O.15) A national park carefully monitors the number of international visitors using the park. For the first six months of operations, the following ure wire recorded Month Hol Visitors Month of Visitors 1. January 4 April 640 2. February 183 5. May 1876 3. March 285 6 June 2.550 The trend line equation based on the above data is: F-8074+500.54t. (Try getting this trendline in Excel.) Keep 2 decimal places in your answers, # of Visitors 1000 2500 y=500.54x -807.4 2000 of patrons 1000 500 0 -300 Periods Question 9: What will be the forecast for the number of visitors in July? Type your answer 10 1 point Question 10: What will be the forecast for the number of visitors in September? Type your answer. appeso questions 1-3. Weekly sales of ballpeen hammers at a home improvement store have been 14.9,30, 22, 34, 12.19.23 over the past 8 weeks. The following table shows the forecasts for weeks 4, 5 and 6 using 3 period Moving Average (MA-3) and Exponential Smoothing with a smoothing constant -0.15 [ES(O.15). Week Actual Demand MA-3 Forecast ES(0.15) Forecast 1 14 2 9 3 30 9 (Note that this is analve forecast actual demand observation in Week 23 4 22 (14.9+30173 17,667 -0.15301408510-12.15 5 34 20 333 0.15(22)+0,85(1215) - 13.628 12 28.667 16684 19 23 ON B (Round your calculations to 3 decimal places) Question 1: What is the period Moving Average (MAS) Forecast for Wook 71 22.667 2 Question 2What is the Period Moving Average IMA 3 Forecast for Week 21667 > Question 3 What is the Exponential Smoothing Forecast for Wook 7, using 2015? 1937 1 point Question 4: What is the Exponential Smoothing Forecast for Week 8 using 0.157 19.31 1 point Using Excel for these calculations can be convenient Question : What is the Mean Absolute Deviation (MAD) considering the actual demand and the MA-s forecasts for Woods 4 to 8 (total periods)? (Note: you wil have to une absolute errors for this calculation, to negative errors should be converted into positive) Type your answer Question: What is the Mean Squared Error (ME) considering the actual demand and the MA forecast for Weeks 1007 Type You Question 7: What is the Mean Absolute Percentage Error (MAPE) considering the actual demand and the MA3 forecasts for Weeks 4 to 87 (Note: you will have to use absolute errors for this calculation) Just type in the number, do not type symbol Type your answer. a 1 point For ESO.15) forecasts for Week 4 to Week, the MAD - 3.90; MSE - 117.25; and MAPE-37.63%. You may want to calculate these for practice Question 8: Which Method is better considering MAPE? MA-3 ES(O.15) A national park carefully monitors the number of international visitors using the park. For the first six months of operations, the following ure wire recorded Month Hol Visitors Month of Visitors 1. January 4 April 640 2. February 183 5. May 1876 3. March 285 6 June 2.550 The trend line equation based on the above data is: F-8074+500.54t. (Try getting this trendline in Excel.) Keep 2 decimal places in your answers, # of Visitors 1000 2500 y=500.54x -807.4 2000 of patrons 1000 500 0 -300 Periods Question 9: What will be the forecast for the number of visitors in July? Type your answer 10 1 point Question 10: What will be the forecast for the number of visitors in September? Type your