Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Management would like you to experiment with some forecasting models to determine what should be used in a new system to be implemented. The new

Management would like you to experiment with some forecasting models to determine what should be used in a new system to be implemented. The new system is programmed to use one of two forecasting models: simple moving average or exponential smoothing.
WEEK 5432112345678910111213
Atlanta 433333573534453534543321564535265640
Boston 622345483238314042444752256840374152
Chicago 502571354243342748456664322688354446
Dallas 322535544429323738445565604538363842
LA 354046363835424546466543353940465050
Total 222146230230191179184184208233266245208223241180229230
a. Consider using a simple moving average model. Experiment with models using five weeks and three weeks past data. (Round your answers to 2 decimal places.)
3-week MA
5-week MA
b. Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 weeks) mean absolute deviation, mean absolute percent error, and tracking signal as criteria. (Negative values should be indicated by a minus sign. Round all answers to 2 decimal places. Enter "MAPE" answers as a percentage rounded to 2 decimal places.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Time Management For Writers

Authors: Katie Forrest

1st Edition

1711795860, 978-1711795867

More Books

Students also viewed these General Management questions