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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!