Question: Hello! Please answer using excel. Thank you in advance! The ABC Corporation has collected the following data on its daily sales in the past 4

Hello! Please answer using excel. Thank you in advance!

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. Demand 744 Period 1 2 3 924 1194 4 294 564 1104 7 1014 1284 474 9 10 330 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 11 1284 12 816 1104 474 924 1284 13 14 15 16 17 18 19 20 1062 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

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

PLEASE RESPOND ASAP IN EXCEL SHEET WITH EXCEL FORMULA. THANKS, HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed Excel file. Provide your answers...

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

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

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

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

When we say a result indicates that the difference between two samples is significant at the 5% error level, what does this mean?

The year-end 2018 balance sheet of Brandex Inc. listed common stock and other paid-in capital at $3,000,000 and retained earnings at $5,300,000. The next year, retained earnings were listed at...

From the article Interpersonal Dynamics of Family Meals, which of the following statements is true The short average family meal time should be increased if possible. The short family meal time is a...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...