Using the same data forecast demand using exponential


Assume that you are the production manager for Fast Current Kayaks of Washington State. One of the products that you make and sell is the "Fast Current" sea touring kayak paddle. You are responsible for ensuring that there is enough production capac- ity to meet demands (given the very high markup on the paddles).

Year

Quarter

Demand

Year

Quarter

Demand

Year 1

Q1

18

Year 5

Q1

42

 

Q2

19

 

Q2

38

 

Q3

18

 

Q3

59

 

Q4

17

 

Q4

58

Year 2

Q1

19

Year 6

Q1

60

 

Q2

21

 

Q2

61

 

Q3

18

 

Q3

62

 

Q4

19

 

Q4

62

Year 3

Q1

20

Year 7

Q1

64

 

Q2

24

 

Q2

65

 

Q3

28

 

Q3

66

 

Q4

32

 

Q4

68

Year 4

Q1

30

Year 8

Q1

69

 

Q2

31

 

Q2

68

 

Q3

34

 

Q3

67

 

Q4

40

 

Q4

68

a. Given the data shown above, beginning in quarter 1 of year 2, use a moving average based on four quarters to predict the demand in each quarter.

b. Using the same data, forecast demand using exponential smoothing. You are given an initial forecast for year 1, quarter 1 of 17. When generating your forecasts, assume that the smoothing coefficient is 0.10.

c. Which of the forecasting procedures performed the best? Why? Hint: Plot the demand data to better understand what is going on.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Using the same data forecast demand using exponential
Reference No:- TGS01190183

Expected delivery within 24 Hours