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

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

# GDB last date 18 may 2017

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.

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

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 889

.

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

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

### 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....

## Latest Activity

Muhammad Azam joined + M.Tariq Malik's group

### CS202 Fundamentals of Front End Development

15 seconds ago
Muhammad Azam joined + M.Tariq Malik's group

### CS602 Computer Graphics

58 seconds ago
3 minutes ago
+++STUDENT+++ liked ϝ ι ყ α's discussion When You Block \$omeone.......XD XD !!
4 minutes ago
Muhammad Azam joined + M.Tariq Malik's group

### CS201 Introduction to Programming

4 minutes ago
Muhammad Azam joined + M.Tariq Malik's group

### CS301 Data Structures

5 minutes ago
Muhammad Azam joined + M.Tariq Malik's group

### CS403 Database Management Systems

6 minutes ago
Muhammad Azam joined + M.Tariq Malik's group

### CS304 Object Oriented Programming

6 minutes ago
+ AEO + updated their profile
11 minutes ago
23 minutes ago
25 minutes ago

27 minutes ago
29 minutes ago
30 minutes ago
30 minutes ago
30 minutes ago
30 minutes ago

32 minutes ago
1 hour ago
2 hours ago

1

2

3