Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Consider using a simple moving average model Experiment with models using five weeks and three weeks past data The past data in each region are

Consider using a simple moving average model Experiment with models using five weeks and three weeks past data The past data in each region are given below (week 21 is the week before week 1 in the table 22 is two weeks before week 1. etc.). 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.

WEEK Atlanta Boston Chicago Dallas LA Total -5 45 62 62 42 43 254 -4 38 18 22 35 40 153 -3 30 48 72 40 54 244 -2 58 40 44 64 46 252 -1 37 35 48 43 35 198

Step by Step Solution

3.40 Rating (162 Votes )

There are 3 Steps involved in it

Step: 1

Forecast the 5 weeks moving average and 3 weeks moving average using the below given table Calculate the 5week moving average forecast using excel she... 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_2

Step: 3

blur-text-image_3

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

Statistics Data Analysis And Decision Modeling

Authors: James R. Evans

5th Edition

132744287, 978-0132744287

More Books

Students explore these related Accounting questions