Additional Problem 03-07 (Algo) Given the following demand data, compute a simple exponential smoothing forecast for

Question: Additional Problem 03-07 (Algo) Given the following demand data, compute a simple exponential smoothing forecast for alpha values of 0.1 and 0.5. Use the actual value in Period 1 as your starting forecast in Period 2. (Round all your calculations to two decimal points.) Period ActualAdditional Problem 03-07 (Algo)
Given the following demand data, compute a simple exponential smoothing forecast for alpha values of 0.1 and 0.5. Use the actual value in Period 1 as your starting forecast in Period 2. (Round all your calculations to two decimal points.)

Period Actual Demand 1 53 2 54 4 53 4 54 5 55 6 54 7 53 8 53 9 50 10 48 11 45
α = 0.1 α = 0.5 Period Forecast Forecast 1 2 3 4 5 6 7 8 9 10 11 12 Answer: Using Excel: Excel Formulas: Manual Calculations: Exponential Smoothing: Formulas: Ft 1 = At (1 – ) x Ft Given that: Period 1 Actual (At) = Period 2 Forecast (Ft) Therefore: For Alpha = 0.1; Period 2 Forecast (Ft) = 53 Period 3 Forecast =…View the full answer