Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 3

blur-text-image

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

Authors: Robert S. Witte, John S. Witte

11th Edition

1119254515, 978-1119254515

More Books

Students also viewed these Marketing questions

Question

What courses do your students assist with teaching this semester?

Answered: 1 week ago