In: Operations Management
1. All forecasts should be rounded to an integer number (regular rounding). Use Excel to do your computations. Each part of the problem should be on a different Excel Sheet/Tab.
Part (a) Use the 6-period moving average method to forecast for these data and for the first six months of the third year. Compute MSD/E, MAD, MAPE, and Bias.
Month (t) | Model 3 A(t) |
1 | 148 |
2 | 125 |
3 | 78 |
4 | 53 |
5 | 25 |
6 | 29 |
7 | 9 |
8 | 68 |
9 | 84 |
10 | 110 |
11 | 147 |
12 | 120 |
13 | 147 |
14 | 109 |
15 | 96 |
16 | 70 |
17 | 42 |
18 | 36 |
19 | 34 |
20 | 28 |
21 | 71 |
22 | 102 |
23 | 103 |
24 | 144 |
Excel calculation and formulae is shown below
Please comment of any doubt
Rate me
Thanks