Question: 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

Please use the posted Excel template for this

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 3 1194 4 294 5 564 6 1104 7 1014 8 1284 9 474 10 330 Monday Tuesday 4 Weeks Wednesday Ago Thursday Friday Monday Tuesday 3 Weeks ago Wednesday Thursday Friday Monday Tuesday 2 weeks Ago Wednesday Thursday Friday Monday Tuesday Last week Wednesday Thursday Friday 11 1284 12 816 13 1104 14 474 15 924 16 1284 17 1062 18 1464 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

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!

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

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

HST 4 0 0 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 (...

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

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

Assignment on Forecasting (15 marks) Use the Excel template for this question and submit your completed Excel file. Provide your answers to each of the following parts on a different worksheet (but...

HELPPPP HELPP?????? Background:SpecDine Inc, located in Guelph, Ontario, is a manufacturer of dining tables and chairs. Thecompany employs 50 employees. Alex McGill is the new plant operations...

If the scaling laws are applied to the Byron Jackson pump of Prob. 11.28 for the same impeller diameter, determine (a) The speed for which the shut-off head will be 280 ft; (b) The speed for which...

When a certain commodity is sold for p dollars per unit, consumers will buy D(p) = 40,000 p units per month. It is estimated that t months from now, the price of the commodity will be p(t) = 0.4t...

I am searching for the correct answer to this general accounting problem with proper accounting rules. Evergreen Consulting performed the following service transactions during 2023: - Service 1:...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...