Question: Please answer question in Excel and provide explanation. HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed

Please answer question in Excel and providePlease answer question in Excel and providePlease answer question in Excel and provide explanation.

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 1 Demand 744 2 924 1194 3 4 294 5 6 7 8 Monday Tuesday 4 Weeks Wednesday Ago Thursday Friday Monday Tuesday 3 Weeks Wednesday ago Thursday Friday Monday Tuesday 2 weeks Wednesday Ago Thursday Friday Monday Tuesday Last week Wednesday Thursday Friday 564 1104 1014 1284 474 330 1284 9 10 11 12 13 816 1104 14 474 15 924 16 17 1284 1062 18 19 20 1464 744 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? E3 f X A B F G . 1 1 2 Period D E The ABC Corporation Demand Forecast 744 924 3 1 4 N 4 Weeks Ago 3 1194 3 4 4 5 5 7 3 5 6 294 564 1104 1014 1284 474 3 Weeks ago 8 LO -1 2. 7 8 9 10 330 Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday 11 1284 3 -4 816 2 weeks Ago 1104 -5 -6 -7 474 12 13 14 15 16 17 18 19 20 924 1284 00 1062 9 20 21 2 Last week 1464 744 672 Monday 21 23 -4 25 26 27 28 au This week

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!