Question: Your manager has come to you with the following data, showing actual demand for ve periods and forecast results for two different models. He has

Your manager has come to you with the following data, showing actual demand for five periods and forecast results for two different models. He has asked you to tell him which forecast model is “best” and why. Using MFE, MAD, and MAPE, tell him which model is best and why.
ACTUAL FORECAST FORECAST PERIOD DEMAND MODEL 1 MODEL 2 8 248 364

ACTUAL FORECAST FORECAST PERIOD DEMAND MODEL 1 MODEL 2 8 248 364 486 9 357 280 341 10 423 349 416 295 11 286 364 12 444 354 380

Step by Step Solution

3.45 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespac... View full answer

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

Document Format (1 attachment)

Excel file Icon

436-B-M-L-S-C-M (2726).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!