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

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

Permalink Reply by Rana HM Kamran Sabir(M.Com 4) on May 13, 2017 at 11:54pm

Go to lecture 9 and 10 for correct solution. Thanks

Permalink Reply by + M.Tariq Malik on May 14, 2017 at 10:10am

Please Discuss here about this GDB.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

 

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

 

Please Click on the below link to see…

.... How to Find Your Subject Study Group & Join .... 

Permalink Reply by Amaya khan on May 15, 2017 at 6:56pm

help

Permalink Reply by Rana HM Kamran Sabir(M.Com 4) on May 15, 2017 at 9:59pm

amaya khan plz read lecture 9 and 10 with full concentration. If u have any problem m here for ur help thanks

Permalink Reply by sohail on May 15, 2017 at 10:41pm

kindly check n correct plz

Attachments:
Permalink Reply by Amaya khan on May 16, 2017 at 2:25pm

apka wrong hai 1000 skus b to hai

Permalink Reply by Zubaira Ahmad on May 16, 2017 at 8:11pm

Plzz check this solution and correct ur self. thanks 

Attachments:
Permalink Reply by Rana HM Kamran Sabir(M.Com 4) on May 17, 2017 at 9:51pm

Attachments:
Permalink Reply by az1987 on May 17, 2017 at 10:50pm

error= actual forcasts ye amount kese find krni he

Permalink Reply by Zubaira Ahmad on May 18, 2017 at 1:16pm

az1987 jo apl pass demand ha skus ki us mei sy 3 or 4 moths ki moring average to minas krna ha,

like= 25,000 is actual - 19666.66 forcast = 5333.34 error 

Permalink Reply by dunya naseer on May 18, 2017 at 9:23pm

Permalink Reply by Usman Mirza on May 18, 2017 at 9:15pm

Rana HM Kamran Mistake No.1 = 4 MPA mein 22000 nhi 2250 OK, Mistake No 2 = Name Ali not Ahsan 

RSS

Latest Activity

+ ! ! ! ! ᎠixieᎠuຮt꧂ liked + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
8 minutes ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked + Iuuoɔǝut+'s discussion Har Shaks Naraz hy meri baton sy
8 minutes ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked + M.Tariq Malik's discussion کوئی مشکل پڑے تعویذ بنا سکتے - ہو تم مرے نام پہ ہر داو لگا سکتے ہو
8 minutes ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked + "AS"'s discussion Jesi Ab hai ..
8 minutes ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked + Iuuoɔǝut+'s discussion Farz Karo ....
9 minutes ago
szh786 updated their profile
1 hour ago
+ ՏhehαrZααD + replied to + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
3 hours ago
+ Android updated their profile
3 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" and + Iuuoɔǝut+ are now friends
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut+'s discussion Har Shaks Naraz hy meri baton sy
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + "αяsαℓ " Ќąƶµяɨ •"'s blog post چھوٹا کام
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG replied to + Iuuoɔǝut+'s discussion Har Shaks Naraz hy meri baton sy
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut+'s discussion Farz Karo ....
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + Adeeena's discussion usay pasand hai
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut+'s discussion Investment risk management report Bangladesh
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG replied to + M.Tariq Malik's discussion ایسا بھی میرے دوست فارغ نہیں ہوں - میں بیٹھا ہوں انتظار میں، کب یاد آوں گا
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + M.Tariq Malik's discussion ایسا بھی میرے دوست فارغ نہیں ہوں - میں بیٹھا ہوں انتظار میں، کب یاد آوں گا
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG replied to + M.Tariq Malik's discussion کوئی مشکل پڑے تعویذ بنا سکتے - ہو تم مرے نام پہ ہر داو لگا سکتے ہو
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG replied to + M.Tariq Malik's discussion یہ ان کا ظرف ہے بیٹھے ہیں آستینوں میں - یہ میری خو ہے کہ میں یار یار کرتا ہوں
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + M.Tariq Malik's discussion کوئی مشکل پڑے تعویذ بنا سکتے - ہو تم مرے نام پہ ہر داو لگا سکتے ہو
3 hours ago

Today Top Members 

1 + Iuuoɔǝut+

+ Iuuoɔǝut+
2 + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !

+ ! ! ! ! ! ! ! ! ! ! ! ! ! ! !
3 Muhammad Umar

Muhammad Umar

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

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