50 5. Following table represents the sales data from January to April for certai
ID: 2929978 • Letter: 5
Question
50 5. Following table represents the sales data from January to April for certain company: Automobile Battery Sales 28 21 39 34 Month anuary ebruary March pril Use 2 period moving averages to forecast the automobile batteries sales for march through April Find MAD (Mean Absolute Deviation) a. b. 6. Given an actual demand of 125 for current period when forecast of 129 was anticipated. a. b. What is forecast error for current period? For given alpha of 0.5 what would the forecast for the next period by using simple 4Explanation / Answer
Solving question 5 only
a) Forecast for March = (28+21 )/2 = 24.5
Forecast for April = (21+39)/2 = 30
b) MAD = [Mod(24.5-39) + Mod ( 30-34) ]/2 = [14.5+4]/2 = 9.25