Finance-AW592 Online Services


Assignment 3


Anne Carroll, your boss, storms into your office—obviously very upset.  “Allen (Hayes, Director of Purchasing) is pushing hard for a change to something called MRP.  I remember studying MRP in college, but we tried it at my previous job and it didn’t work for us.  He is taking a hard line on this and Cooper is backing him.”   She stops for a moment and seems to regain some composure.  “I’m sorry.  These political issues don’t concern you.”


“Look.  I’ve got the Master Production Schedule (MPS) for the Premium Prestige 400-101 that Allen is using to do his pilot testing.  I’d like you to bone up on MRP and develop a materials plan so that I can compare it to Allen’s plan to be sure he knows what he is talking about.  Don’t worry about the packaging.  Allen says we have enough of it to last at least a year because of some sort of purchasing foul-up.  He gave me some information you might need (in Appendix).  I need to know if this MRP thing indicates whether the Master Schedule is feasible from a materials lead time standpoint.  I would also like you to review the data he has collected and let me know how ready you think we are for MRP.  Get back with me as soon as possible.”


With that, Anne turned and left your office.  You grabbed your old POM text, silently thanking your old professor for saying you would regret selling it at the end of the semester.  The few dollars you would have gotten then wouldn’t have made much difference, and having the text now could make all the difference.  You make a mental note to send a contribution to the Alumni Association.


Since this is just a trial study, you figure it would save time to do the MRP tables by hand, in POM for Windows, or on Excel rather than setting it up in an actual MRP program.  So you set up a master MRP matrix in Excel (available for download from the MGT 560 web site) and start to work.


You can read more about our case study assignment help services here.

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to Case Id . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id and must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

Case Approach

Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

Related Services




WEEK 1 2 3 4 5 6 7 8
REQ. 0 0 0 0 20,000 0 0 0




Appendix to Assignment 3


PART NO. LEAD TIME (weeks) PROJECTED ON HAND in WEEK 1 LOT SIZE (multiples) Scheduled Receipts
400-101 1 0 L-4-L 0
SA-304 1 2,000 100 0
S-901 1 10,000 10,000 0
SG-333 2 3,000 1,000 0
SA-506 1 55,000 10,000 0
Cotton String 2 1,000,000 1,000,000 0
Bees Wax 3 5,000 1,000 0
Dowel Rod 3 500,000 12,000 0
AL Bar Stock 5 1,600 1,600 1,600 in Wk 3





For this simulation, I am assuming that the 400-101 is the only product using these materials.  Obviously, this is not really true—all our products use dowel, string and glue—but it makes the pilot study feasible.


I also collected some sample data on our processes.  Here’s what I found


Average lead time variation from suppliers:  ± 10% from committed due date.

Average % shipments rejected at incoming inspection:  0.05%.

Proportion of BOMs without error:  97%.

Proportion of inventory records without error:  81%.

Average change in MPS quantities within 1 week of due date:  ± 1%.

Average change in MPS quantities within 1 month of due date:  ± 5%.


I think that you will like and appreciate the benefits of MRP if you only give it a chance.




product code: Finance-AW592
Looking for best Finance-AW592 online ,please click here