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
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
Related questions
Question

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman