Question: FORECASTING Case Study 3 As noted in the class, this case is an extension of the Forecasting Exercise that was done in class (below). Consider
FORECASTING Case Study 3 As noted in the class, this case is an extension of the Forecasting Exercise that was done in class (below). Consider monthly demand for the MiKA Corporation as shown in the Table below. Forecast the monthly demand for year 4 using an adaptive method of your choice, and evaluate the latter using MAD and MSE.
| Sales | Year 1 | Year 2 | Year 3 |
| Jan | 204 | 234 | 230 |
| Feb | 213 | 231 | 231 |
| Mar | 203 | 227 | 229 |
| Apr | 209 | 233 | 234 |
| May | 226 | 238 | 245 |
| Jun | 212 | 227 | 234 |
| Jul | 218 | 245 | 254 |
| Aug | 232 | 226 | 237 |
| Sep | 239 | 222 | 245 |
| Oct | 212 | 232 | 249 |
| Nov | 237 | 226 | 246 |
| Dec | 217 | 232 | 260 |
In particular, Forecast the monthly demand for year 4 using an adaptive method of your choice, evaluate the latter using MAD and MSE, and compare it to Holts model that was done in class.
Below you will find more details about the deliverables. Case Report Perform an analysis on the three-year demand. Prepare a report that summarizes your findings, forecasts, and recommendations. Include the following:
1 A graph of the time series. 2 Choose another appropriate method for forecasting, and report the MAD and MSE. 3 Forecast the demand in year 4 following the better method (Holt or the new method). 4 Recommendations regarding the future and sustainability of MiKa Corporation. P.S. Both Excel File and Word report should be submitted.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
