Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Bias and the TS (tracking signal) . PeriodDemandForecastErrorMADBiasTS2-Oct 2020850 2-Nov 2020950 2-Dec 2020900 2-Jan 20211000 2-Feb 2021950 2-Mar 20211050 2-Apr 2021850 2-May 2021800 2-June 2021900 2-July 20211000

MAD stands for mean absolute deviation. MAD refers to the average of the difference between the…

Answered: Given the following data for demand at…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Bias and the TS (tracking signal) .

Period	Demand	Forecast	Error	MAD	Bias	TS
2-Oct 2020	850
2-Nov 2020	950
2-Dec 2020	900
2-Jan 2021	1000
2-Feb 2021	950
2-Mar 2021	1050
2-Apr 2021	850
2-May 2021	800
2-June 2021	900
2-July 2021	1000