Question: USE excel to solve this problem Assume that the demand is updated each period by Winters' trend-seasonal method. The smoothing constants are a = 0.2,

USE excel to solve this problem Assume that the demand is updatedUSE excel to solve this problem

Assume that the demand is updated each period by Winters' trend-seasonal method. The smoothing constants are a = 0.2, B = 0.1, y = 0.2. There are T = 7 equally long periods during a year. Assume further that the last update took place at the end of period 13 and resulted as follows js = 5, 613 = 1 F, = g = 1.4, F, = F10 = u1 = 1, F12 = F3 = 0.6 The observed demand in period 14 is 3. Carry out the update and determine the forecast for period 17. Assume that the demand is updated each period by Winters' trend-seasonal method. The smoothing constants are a = 0.2, B = 0.1, y = 0.2. There are T = 7 equally long periods during a year. Assume further that the last update took place at the end of period 13 and resulted as follows js = 5, 613 = 1 F, = g = 1.4, F, = F10 = u1 = 1, F12 = F3 = 0.6 The observed demand in period 14 is 3. Carry out the update and determine the forecast for period 17

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 Finance Questions!