Problem 18-22 (Algo) Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecasts and specify what procedure you would utilize MONTH 2 ACTUAL DEMAND 63 66 601 69 70 72 73 73 23 76 85 30 5 10 11 12 a. Calculate the simple three-month moving average forecast for periods 4-12. (Round your answers to 3 decimal places.) ints Month Three-Month Moving Averago 4 Book 5 6 Print Heterences 7 8 9 10 11 12 b. Calculate the weighted three-month moving average for periods 4-12 using weights of 0.50 (for the period 2-1): 0.40 (for the period 1-2). and 0.10 (for the period 1-3). (Do not round intermediate calculations. Round your answers to 1 decimal place.) Month Three-Month Welighted Moving Average 4 5 000 7 8 9 10 11 12 0.5 points c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F) of 62 and on a of 0.30. (Do not round Intermediate calculations. Round your answers to 3 decimal places.) Book Month Single Exponential Smoothing Forecast Prim Nances 2 3 4 5 6 7 9 10 11 12 d. Calculate the exponential smoothing with trend component forecast for periods 2-12 using an initial trend forecast (Ts of 190, an initial exponential smoothing forecast (F) of 61, an a of 0.30, and a 5 of 0.30. (Do not round intermediate calculations. Round your answers to 3 decimal places.) 0.5 points Month Exponential Smoothing with Trend Paint Reference 2 3 4 5 8 9 10 11 12 05 points e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4-12. (Do not round Intermediate calculations. Round your answers to 3 decimal places.) Print Mean Absolute Deviation References Three-month moving average Three-month weighted moving average Single exponential smoothing forecast Exponential smoothing with trond -2. Which forecasting method do you prefer? O Exponential smoothing with trend forecast Three month moving average Single exponential smoothing forecast Three-month weighted moving average