A3 F Assume that your stock of sales merchandise is maintain

A-3 F Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributors sales of each month, compute your forecast sales by each of the three methods requested here personnel call on the first day 204 August a. Using a simple Forecast for b. Using a weighted moving average, what is the forecast for September with weights of o.40, 0.50, and o.10 for June, July, and August Forecast for September (Do not round intermediate calculations. Round your answer to 2 decimal places) constant or 0.40. (Round your answer to 2 decimal places.) Forecast for September References Worksheet

Solution

(Average of At-1,t-2,t-3) Actual 3 MMA June 134 July 174 August 204 September 170.67 Ans A (Average of 0.4*At-1,0.5*t-2,0.1*t-3) Actual 3 MMA June 134 July 174 August 204 September 161.00 Ans B a = 0.4 Ft-1+a*(At-1-Ft-1) Month Actual Demand Forecast June 134 122.00 July 174 126.80 August 204 145.68 September 169.01 Ans C