Assignment (topic concerned: Forecasting)
Problem1
Car sales at Amandeep Motor's Kanpur for are shown below. Develop a 3-week moving average forecast system and find the forecast for 6th, 7th, 8th & 9th weeks respectively.
|
Week
|
Auto Sales
|
|
1
|
8
|
|
2
|
10
|
|
3
|
9
|
|
4
|
11
|
|
5
|
10
|
|
6
|
13
|
|
7
|
12
|
|
8
|
13
|
|
9
|
-
|
Problem 2:
Maruti's decides to forecast auto sales by weighting the three weeks as follows:
|
Weights Applied
|
Period
|
|
3
|
Last week
|
|
2
|
Two weeks ago
|
|
1
|
Three weeks ago
|
|
6
|
Total
|
Calculate the forecast for 6th, 7th, 8th & 9th weeks respectively
Problem 3:
If the Amandeep Motor wand's to uses simple exponential smoothing with to forecast demand. Calculate the demand forecast for the 6th, 7th, 8th & 9th weeks, respectively.
Problem 4:
Evaluate the accuracy of smoothing constant using MAD, examine critically? Do you suggest any new value of alpha?
The students have to submit max 3 pages (Font size 12 Times Roman, single spaces, margin 1 inch by 1 inch).