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

1

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

+¢αяєℓєѕѕ gιяℓ liked +¢αяєℓєѕѕ gιяℓ's discussion Iss Mien Fail Karn wali Kon C baat thi xD
4 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Iss Mien Fail Karn wali Kon C baat thi xD
4 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Iss Mien Fail Karn wali Kon C baat thi xD
7 minutes ago
+ M.Tariq Malik liked A¥E$Ha's discussion Namaz
8 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Iss Mien Fail Karn wali Kon C baat thi xD
8 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion Diamond Model developed by Michael E. Porter
9 minutes ago
+"Certified Gangster"++ replied to +"Certified Gangster"++'s discussion For all female friends
12 minutes ago
+ M.Tariq Malik added 3 discussions to the group MGT520 International Business
12 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Lets Share yOur desktOp wAllpAper.....  (•ิ‿•ิ)
14 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Lets Share yOur desktOp wAllpAper.....  (•ิ‿•ิ)
14 minutes ago
+¢αяєℓєѕѕ gιяℓ liked +¢αяєℓєѕѕ gιяℓ's discussion The Meaning Of Life.....
15 minutes ago
+"Certified Gangster"++ liked +¢αяєℓєѕѕ gιяℓ's discussion O Shit I am Late xD
16 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MGT520 International Business Lectures Power Point Slides (MGT520 PPTs)
16 minutes ago
+ M.Tariq Malik's 7 discussions were featured
16 minutes ago
+"Certified Gangster"++ liked +++STUDENT+++'s blog post Depression
17 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Apk Haal B Humeri Namaz Jis hai.....
19 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Apk Haal B Humeri Namaz Jis hai.....
20 minutes ago
+¢αяєℓєѕѕ gιяℓ liked +¢αяєℓєѕѕ gιяℓ's discussion تیرے رونے نے فرشتوں کو بھی رلا دیا
20 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion تیرے رونے نے فرشتوں کو بھی رلا دیا
20 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion تیرے رونے نے فرشتوں کو بھی رلا دیا
23 minutes ago

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

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