Ms. Winnie Lins company sells computers. Monthly sales for a six-month period are as follows: __________________ Month

Question:

Ms. Winnie Lin’s company sells computers. Monthly sales for a six-month period are as follows:

__________________

Month          Sales

__________________________

Jan               18,000

Feb               22,000

Mar               16,000

Apr               18,000

May              20,000

Jun               24,000


a. Plot the monthly data on a sheet of graph paper.

b. Compute the sales forecast for July using the following approaches: (i) a three-month moving average; (ii) a weighted three-month moving average using .50 for June, .30 for May, and .20 for April.

c. Calculate the MAD for each of the two techniques in part b. Which is the best? Why?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Principles of Supply Chain Management A Balanced Approach

ISBN: 978-1337406499

5th edition

Authors: Joel D. Wisner, Keah Choon Tan, G. Keong Leong

Question Posted: