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. (Leave no cells blank - be certain to enter "0" wherever required. Negative answers should be indicated by a minus sign. Round your forecast answers to 1 decimal place. Then, starting with quarter 1 of year 2, use these rounded forecast values to compute the error and absolute error answers. Enter those answers to 1 decimal place also.)

Problem 12-6 (Algo) 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 capacity to meet demands (given the very high markup on the paddles). Year Year 1 Year Year 5 5 Year 2 Year 6 Quarter Demand 01 18 Q2 20 03 19 04 19 Q1 20 Q2 24 03 16 04 16 Q1 21 Q2 22 03 29 04 31 Q1 30 02 31 03 30 04 40 Quarter Demand 01 41 Q2 37 Q3 51 04 57 01 61 Q2 58 03 62 04 65 01 56 Q2 60 69 03 68 04 71 01 73 02 66 03 69 04 71 Year 3 Year 7 Year 4 Year 8 picture Click here for the Excel Data File 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. (Leave no cells blank - be certain to enter "O" wherever required. Negative answers should be indicated by a minus sign. Round your forecast answers to 1 decimal place. Then, starting with quarter 1 of year 2, use these rounded forecast values to compute the error and absolute error answers. Enter those answers to 1 decimal place also.) Problem 12-6 (Algo) 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 capacity to meet demands (given the very high markup on the paddles). Year Year 1 Year Year 5 5 Year 2 Year 6 Quarter Demand 01 18 Q2 20 03 19 04 19 Q1 20 Q2 24 03 16 04 16 Q1 21 Q2 22 03 29 04 31 Q1 30 02 31 03 30 04 40 Quarter Demand 01 41 Q2 37 Q3 51 04 57 01 61 Q2 58 03 62 04 65 01 56 Q2 60 69 03 68 04 71 01 73 02 66 03 69 04 71 Year 3 Year 7 Year 4 Year 8 picture Click here for the Excel Data File 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. (Leave no cells blank - be certain to enter "O" wherever required. Negative answers should be indicated by a minus sign. Round your forecast answers to 1 decimal place. Then, starting with quarter 1 of year 2, use these rounded forecast values to compute the error and absolute error answers. Enter those answers to 1 decimal place also.)