Master Schedule Creation
diamante130
c939738.xlsxforecast
| Date | Actual Demand | Forecast |
| 1-Jan-20 | 2500 | |
| 1-Feb-20 | 2700 | |
| 1-Mar-20 | 3000 | |
| 1-Apr-20 | 2600 | |
| 1-May-20 | 3200 | |
| 1-Jun-20 | 3000 | |
| 1-Jul-20 | 3192.00 | |
| 1-Aug-20 | 3196.47 | |
| 1-Sep-20 | 3194.18 | |
| 1-Oct-20 | 3192.99 | |
| 1-Nov-20 | 3194.00 | |
| 1-Dec-20 | 3190.25 | |
| 1-Jan-21 | 3195.20 | |
| 1-Feb-21 | 3194.18 | |
| 1-Mar-21 | 3186.26 | |
| 1-Apr-21 | 3192.87 | |
| 1-May-21 | 3189.44 | |
| 1-Jun-21 | 3200.11 | |
| 1-Jul-21 | 3193.17 | |
| 1-Aug-21 | 3197.07 | |
| 1-Sep-21 | 3194.18 | |
| 1-Oct-21 | 3192.99 | |
| 1-Nov-21 | 3194.00 | |
| 1-Dec-21 | 3190.25 | |
Actual Demand
43831 43862 43891 43922 43952 43983 2500 2700 3000 2600 3200 3000
mad
| Actual Demand | Forecast | A-F | Absolute | Forecast 2 | A-F | ABS | |
| January | 2500 | 2000 | 500 | 500 | 3192 | -692 | 692 |
| February | 2700 | 2800 | -100 | 100 | 3196.47 | -496.47 | 496.47 |
| March | 3000 | 3200 | -200 | 200 | 3194.18 | -194.18 | 194.18 |
| April | 2600 | 2800 | -200 | 200 | 3192.99 | -592.99 | 592.99 |
| May | 3200 | 3500 | -300 | 300 | 3194 | 6 | 6 |
| June | 3000 | 3300 | -300 | 300 | 3190.25 | -190.25 | 190.25 |
| average | 266.6666666667 | average | 361.9816666667 |
