Question: Problem 3 - 7 ( Static ) The following table contains the demand from the last 1 0 months: table [ [ MONTH ,

Problem 3-7(Static)
The following table contains the demand from the last 10 months:
\table[[MONTH,\table[[ACTUAL],[DEMAND]]],[1,31],[2,34],[3,33],[4,35],[5,37],[6,36],[7,38],[8,40],[9,40],[10,41]]
a. Calculate the single exponential smoothing forecast for these data using an a of 0.30 and an initial forecast (F) of 31.(Round your intermediate calculations and answers to 2 decimal places.)
Answer is complete and correct.
\table[[Month,\table[[Exponential],[Smoothing]]],[1,31.00],[2,31.00],[3,31.90],[4,32.23],[5,33.06],[6,34.24],[7,34.77],[8,35.74],[9,37.02],[10,37.91]]
b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a of 0.30, an initial trend forecast (T?) of 1, and an initial exponentially smoothed forecast (F1) of 30.(Round your intermediate calculations and answers to 2 decimal places.)
Answer is not complete.
\table[[Month,FITt],[1,32.00
 Problem 3-7(Static) The following table contains the demand from the last

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!