In 4 months period for the forecast is derived by 40% of actual sales (in units)
ID: 354761 • Letter: I
Question
In 4 months period for the forecast is derived by 40% of actual sales (in units) for the recent month 30% of two months ago 20% of three months. Ago, 10% of four months ago. The actual unit sales where. Month 1 =120 Month 2 = 150 Month 3 = 95 Month 4= 110 What is the forecast for month 5 In 4 months period for the forecast is derived by 40% of actual sales (in units) for the recent month 30% of two months ago 20% of three months. Ago, 10% of four months ago. The actual unit sales where. Month 1 =120 Month 2 = 150 Month 3 = 95 Month 4= 110 What is the forecast for month 5 10% of four months ago. The actual unit sales where. Month 1 =120 Month 2 = 150 Month 3 = 95 Month 4= 110 What is the forecast for month 5Explanation / Answer
Forecast for month 5
= 40%/100 x Actual sales of month 4 + 30%/100 x actual sales for month 3 + 20%/100 x actual sales for month 2 + 10%/100 x actual sales for month 1
= 0.4 x 110 + 0.3 x 95 + 0.2 x 150 + 0.1 x 120
= 44 + 28.5 + 30 + 12
= 114.5
FORECAST FOR MONTH 5 = 114.5
FORECAST FOR MONTH 5 = 114.5