Question: Please help me understand and solve this assignment! Thanks! The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36

Please help me understand and solve this assignment! Thanks!

The following table contains the demand from the last 10 months:

MONTH ACTUAL DEMAND
1 36
2 35
3 36
4 39
5 41
6 40
7 41
8 43
9 40
10 40

a. Calculate the single exponential smoothing forecast for these data using an of 0.30 and an initial forecast ( F11 ) of 36.

Month Exponential Smoothing
1
2
3
4
5
6
7
8
9
10

b. Calculate the exponential smoothing with trend forecast for these data using an of 0.30, a of 0.20, an initial trend forecast ( T11 ) of 1.00, and an initial exponentially smoothed forecast ( F11 ) of 35.

Month FITt
1
2
3
4
5
6
7
8
9
10

c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts.

Note: Round your intermediate calculations and answers to 2 decimal places.

MAD
Single exponential smoothing forecast
Exponential smoothing with trend forecast

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!