14. Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) . 中 Period Demand | Forecast Error MAD Bias TS 2-OCct 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

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
14. Given the following data for demand at the XYZ Company, calculate the monthly forecast
using a 4-month moving average. Calculate the Forecast, Error, MAD (mean absolute
percentage error), 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
2-May 2021
850
800
2-June 2021
900
2-July 2021
1000
Transcribed Image Text:14. Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), 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 2-May 2021 850 800 2-June 2021 900 2-July 2021 1000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman