Question: D. Quantitative Analysis 1. (20 points) The demands for a product for periods 1-4 are shown in the table below. Use exponential smoothing with trend

D. Quantitative Analysis 1. (20 points) The
D. Quantitative Analysis 1. (20 points) The
D. Quantitative Analysis 1. (20 points) The demands for a product for periods 1-4 are shown in the table below. Use exponential smoothing with trend adjustment to forecast the demand for period 5. Let a = 0.2, B = 0.3, and let the initial trend value be 4 and the initial forecast be 200 (both are given in the table) (a) Complete the table below and predict the demand for Period 5. Note that AE stands for the absolute error. Gt AE Actual Demand 200 212 214 222 St 200.00 Ft 200 Period t+1 1 2 3 4 5 4.00 Also, show the calculations for calculating S., G1 and F. (in period 2) (b) Calculate the MAE based on the actual demands given. (c) Based on the actual demands for the first 4 periods forecast the demand for period 5 using linear regression method. (d) Assume the actual demand for period 5 is 236, which method - exponential smoothing linear regression - performs better based on the actual demand for period 5? Why do yo think so

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!