HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your...

 

Transcribed Image Text:

HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed Excel file. Provide your answers to each of the following parts on a different worksheet (in the provided worksheets for methods #1 and #2 in the same file). The ABC Corporation has collected the following data on its daily sales in the past 4 weeks. The company only operates from Monday to Friday. Period Demand Monday 1 744 Tuesday 2 924 4 Weeks Wednesday 3 1194 Ago Thursday 4 294 Friday 5 564 Monday 6 1104 Tuesday 7 1014 3 Weeks Wednesday 8 1284 ago Thursday 9 474 Friday 10 330 Monday 11 1284 Tuesday 12 816 2 weeks Ago Wednesday 13 1104 Thursday 14 474 Friday 15 924 Monday 16 1284 Tuesday 17 1062 Last week Wednesday 18 1464 Thursday Friday 19 744 20 672 Method#1: Using a weighted moving average of 0.35 [last day], 0.30 [2 days ago] 0.15 [3 days ago], 0.10 [4 days ago], 0.10 [5 days ago], calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Method #2: Assume that the forecast for Monday of 4 weeks ago was 570 units. Using an Exponential Smoothing with a = 0.25, calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Calculate the Mean Squared Error for each of the above methods based on the daily forecasts for the last 15 days. Which method is more accurate? Why? HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed Excel file. Provide your answers to each of the following parts on a different worksheet (in the provided worksheets for methods #1 and #2 in the same file). The ABC Corporation has collected the following data on its daily sales in the past 4 weeks. The company only operates from Monday to Friday. Period Demand Monday 1 744 Tuesday 2 924 4 Weeks Wednesday 3 1194 Ago Thursday 4 294 Friday 5 564 Monday 6 1104 Tuesday 7 1014 3 Weeks Wednesday 8 1284 ago Thursday 9 474 Friday 10 330 Monday 11 1284 Tuesday 12 816 2 weeks Ago Wednesday 13 1104 Thursday 14 474 Friday 15 924 Monday 16 1284 Tuesday 17 1062 Last week Wednesday 18 1464 Thursday Friday 19 744 20 672 Method#1: Using a weighted moving average of 0.35 [last day], 0.30 [2 days ago] 0.15 [3 days ago], 0.10 [4 days ago], 0.10 [5 days ago], calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Method #2: Assume that the forecast for Monday of 4 weeks ago was 570 units. Using an Exponential Smoothing with a = 0.25, calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Calculate the Mean Squared Error for each of the above methods based on the daily forecasts for the last 15 days. Which method is more accurate? Why?