Question
Company ABC observes the demand of product X over 20 periods as follow: Period Demand Period (units) 68 75 1 2 3 456 7
Company ABC observes the demand of product X over 20 periods as follow: Period Demand Period (units) 68 75 1 2 3 456 7 8 9 10 Requirements: 72 84 87 86 93 96 99 105 11 12 13 14 15 16 17 18 19 20 Demand (units) 100 98 95 103 92 84 67 74 70 59 a) Plot a 10-periods Simple Moving Average (SMA) line against the actual data line over the 20 periods [Suggestion: Use MS Excel to plot the two lines and paste the chart onto MW Word] (5 marks) b) Compute the Mean Absolute Deviation (MAD) for periods 11 to 20. Tabulate your (5 marks) answers. c) Comment on the behaviors of the 10-periods moving average line against the actual data line. (5 marks) Note: Keep your answers to ONE (1) decimal place.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Statistics
Authors: Robert S. Witte, John S. Witte
11th Edition
1119254515, 978-1119254515
Students also viewed these Marketing questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App