We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

PROBLEM:

Mr. Ali, the production manager of XYZ Company, wants to use a Moving-Average method to forecast the future demand; but not sure whether a 3-period moving-average would yield better forecasts or a 4-period moving-average!

The demand data of last 12 months have been given in following table:

Month

Demand (1000 SKUs)

1

20

2

18

3

21

4

24

5

25

6

27

7

22

8

23

9

30

10

20

11

29

12

22

 

You are required to suggest Mr. Ali a more suitable forecasting method by calculating and analyzing:

  1. 3-period moving average forecasts for months 4 – 12 and its Mean Absolute Deviation (MAD)
  2. 4-period moving average forecasts for months 5 – 12 and its Mean Absolute Deviation (MAD)

NOTE:

  • Show the forecasts along with necessary calculations in tabular form.
  • Compare MAD for both methods and clearly mention your suggested method.
  • You may solve the problem in MS Excel and copy-paste the table in GDB comments.

IMPORTANT INSTRUCTIONS:

  • Your discussion must be based on calculations.
  • The GDB will open and close at above specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
  • Your answer should be relevant to the topic i.e. no definitions & theoretical explanations are required.
  • Do not copy or exchange your answer with other students. Two identical/ copied comments will be marked Zero (0) and may damage your grade in the course.
  • Books, websites and other reading material may be consulted before posting your comments; but copying or reproducing the text from books, websites and other reading materials is strictly prohibited. Such comments will be marked as Zero (0) even if you provide references.
  • Obnoxious or ignoble answer should be strictly avoided.
  • You cannot participate in the discussion after the due date via email.
  • Questions/ queries related to the content of the GDB posted by the students on MDB or via e-mail, will not be replied till the GDB is open.

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..

..How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?..


See Your Saved Posts Timeline

Views: 886

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service