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.

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

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

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


See Your Saved Posts Timeline

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)

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

+ Click Here To Join (Our facebook study Group)

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

Latest Activity

Muhammad Azam joined + M.Tariq Malik's group
15 seconds ago
Muhammad Azam joined + M.Tariq Malik's group
58 seconds ago
+++STUDENT+++ replied to ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
3 minutes ago
+++STUDENT+++ liked ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
4 minutes ago
Muhammad Azam joined + M.Tariq Malik's group
4 minutes ago
Muhammad Azam joined + M.Tariq Malik's group
5 minutes ago
Muhammad Azam joined + M.Tariq Malik's group
6 minutes ago
Muhammad Azam joined + M.Tariq Malik's group
6 minutes ago
+ AEO + updated their profile
11 minutes ago
+ Iuuoɔǝut+ replied to + Iuuoɔǝut+'s discussion Islam in the Middle of Christianity
23 minutes ago
彡JK彡 ❤️ replied to + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
25 minutes ago
彡JK彡 ❤️ replied to + !! SARAH's discussion Beauty Of Fear !!
27 minutes ago
彡JK彡 ❤️ replied to + Iuuoɔǝut+'s discussion Islam in the Middle of Christianity
29 minutes ago
彡JK彡 ❤️ liked + Iuuoɔǝut+'s discussion Islam in the Middle of Christianity
30 minutes ago
彡JK彡 ❤️ liked + ! ✨ ░S░I░N░G░E░R's discussion Pride for Pakistan (Gold Medal in World Beach Games' 90kg Category)
30 minutes ago
彡JK彡 ❤️ liked + Iuuoɔǝut+'s blog post Things about Arabic Language in an info graphic
30 minutes ago
彡JK彡 ❤️ liked + "αяsαℓ " Ќąƶµяɨ •"'s blog post نظر لگنا کیا ہے اور بُری نظر انسان کے جسم پر کیسے اثر انداز ہوتی ہے
30 minutes ago
彡JK彡 ❤️ posted a discussion
32 minutes ago
+ ! ✨ ░S░I░N░G░E░R liked + Iuuoɔǝut+'s discussion Qatta Taluq....
1 hour ago
+ Iuuoɔǝut+ replied to + Iuuoɔǝut+'s discussion Qatta Taluq....
2 hours ago

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

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