We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

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

Looking for Something at Site? Search Below

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.


+ 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?)

+ Click Here To Join (Our facebook study Group)


Views: 958

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

HELP SUPPORT

This is a member-supported website. Your contribution is greatly appreciated!

Latest Activity

+M.Tariq Malik replied to +M.Tariq Malik's discussion CS614 Current Final Term Papers Spring 2020 & Past Solved Papers, MCQs in the group CS614 Data Warehousing
1 minute ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS614 Current Final Term Papers Spring 2020 & Past Solved Papers, MCQs in the group CS614 Data Warehousing
2 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS614 Current Final Term Papers Spring 2020 & Past Solved Papers, MCQs in the group CS614 Data Warehousing
5 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS712 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group CS712 Distributed DBMS
7 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS712 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group CS712 Distributed DBMS
7 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS712 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group CS712 Distributed DBMS
7 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion CS712 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More
7 minutes ago
+M.Tariq Malik's 3 discussions were featured
7 minutes ago

Today Top Members 

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

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

.