Question: 1/3 SCM 352 Operations Management Session 15: Demand Forecasting Part I Lee auto sales wishes to analyze weekly sales of automobiles. Weekly data for the
1/3 SCM 352 Operations Management Session 15: Demand Forecasting Part I Lee auto sales wishes to analyze weekly sales of automobiles. Weekly data for the number of autos sold for the past 7 weeks (Dt) has been recorded. Forecasting Method: (Simple) Moving Average Method with N=3. Using this method, please forecast weekly auto sales from week 6 to 8.
Week Demand (D) Average (A) Forecast (F)
1 100
2 150
3 130 A3 =D1+D2+D3/3= 100+150+130/3 = 126.67
4 140 A4 = D2+D3+D4 /3 = 150+130+140/3 = 140 F4=126.67
5 120 F5= 140.00
6 110
7 100
8
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
