Question: Please assist with parts C, D, and E1. Problem 3-22 (Static) Your manager is trying to determine what forecasting method to use. Based on the
Please assist with parts C, D, and E1.
Problem 3-22 (Static) Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecast and specify what procedure you would utilize. MONTH 1 2 ACTUAL DEMAND 62 65 67 68 71 73 76 78 6 B 9 10 11 12 BO 54 85 unur wers to decimal places.) c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast {F} of 61 and an a of 030 (Round your answers to 3 decimal places.) Month Single Exponential Smoothing Forecast 2 3 4 5 6 7 8 9 10 11 12 d. Calculate the exponential smoothing with trend component forecast for perlods 2-12 using an initial trend forecast (T4 of 18, an Initial exponential smoothing forecast (Ft) of 60, an a of 0.30, and a of 0 30 (Round your answers to 3 decimal places.) Month Exponential Smoothing with Trend 2 3 4 5 6 7 8 9 10 11 12 e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4-12. (Round your answers to 3 decimal places.) Mean Absolute Deviation Three-month moving averago Three-month weighted moving average Single exponential smoothing forecast Exponential smoothing with trend



Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
