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 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!

The ABC Corporation Period Demand Forecast 4 Weeks Ago Monday 1 744 Tuesday 2 924 Wednesday 3 1194 Thursday 4 294 Friday 5 564 3 Weeks ago Monday 6 1104 Tuesday 7 1014 Wednesday 8 1284 Thursday 9 474...

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...

MSc Applied Research Project Please answer question (C) Introduction: Section A Fri 31st Jan 2020 Teams should prepare a 10 minute presentation: Venue: Safari Annexe O'Donovan's Road Time:...

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...

Please tell me if my balance sheet is correct or not, and if I am wrong please tell me the answer and how to solve for the answer please! Thank you. I uploaded the balance sheet in two halves so it...

An urn initially contains b black and w white balls. At each stage, we add r black balls and then withdraw, at random, r balls from the b + w + r balls in the urn. Show that E[number of white balls...

Find the slope of the tangent line to each of the following curves at 0 = rr/3. a. r = 2 cos b. r = 1 + sin c. r = sin 2 d. r = 4 - 3 cos

Public companies are required to adopt the Control Objectives for Information and Related Technology framework under SOX. Select one: TrueO False

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...