Question: Hello can I please get this question answered using an excel sheet Consider the monthly demand for the ABC corporation as shown in Table 7-3.
Hello can I please get this question answered using an excel sheet
Consider the monthly demand for the ABC corporation as shown in Table 7-3. Forecast the monthly demand for year 6 using the static method for forecasting. Evaluate the bias, TS, MAD, MAPE, and MSE and the quality of the forecast.
| Sales | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| January | 2000 | 3000 | 2000 | 5000 | 5000 |
| February | 3000 | 4000 | 5000 | 4000 | 2000 |
| March | 3000 | 3000 | 6000 | 4000 | 3000 |
| April | 5000 | 5000 | 3000 | 2000 | 2000 |
| May | 4000 | 5000 | 4000 | 5000 | 7000 |
| June | 6000 | 7000 | 6000 | 7000 | 6000 |
| July | 7000 | 3000 | 7000 | 12000 | 8000 |
| August | 6000 | 8000 | 10000 | 14000 | 10000 |
| September | 10000 | 12000 | 15000 | 16000 | 18000 |
| October | 12000 | 11000 | 15000 | 16000 | 20000 |
| November | 14000 | 16000 | 18000 | 20000 | 22000 |
| December | 8000 | 10000 | 8000 | 12000 | 8000 |
| Total | 80000 | 87000 | 99000 | 117000 | 111000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
