-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Material Requirement and Planning for Given Data
Question
A manufacturing plant produces an end-item A, according to the following bill of materials:
The MPS for the end-item A is given in table 1. The manufacturing / assembly lead times, the lot sizing rules, and the current on-hand inventory for all constituting items are given in table 2. There are scheduled receipts for item C at week 1 (100 pieces) and for item D at week 3 (80 pieces).
Table 1: MPS Quantities
|
MPS Quantities |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
Gross Requirements (Α) |
- |
30 |
- |
50 |
- |
200 |
- |
120 |
180 |
60 |
Table 2: Lead times, lot sizing rules, on-hand inventory
|
Item |
Lead Time |
Lot sizing rule |
On-hand inventory |
|
A |
2 weeks |
Lot-for-Lot |
40 |
|
B |
1 week |
Lot-for-Lot |
20 |
|
C |
2 weeks |
Lot-for-Lot |
20 |
|
D |
3 weeks |
Lot-for-Lot |
300 |
Determine the material requirement plan (fill the following tables).
|
Item: A |
Production Lead Time: 2 weeks |
Lot size rule: Lot-for-Lot |
|||||||||
|
Week No. |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
|
Gross Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Adjusted Scheduled Receipts |
|
|
|
|
|
|
|
|
|
|
|
|
Projected on-hand 40 |
|
|
|
|
|
|
|
|
|
|
|
|
Net Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order receipt |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order release |
|
|
|
|
|
|
|
|
|
|
|
|
Item: B |
Production Lead Time: 1 week |
Lot size rule: Lot for Lot |
|||||||||
|
Week No. |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
|
Gross Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Adjusted Scheduled Receipts |
|
|
|
|
|
|
|
|
|
|
|
|
Projected on-hand 20 |
|
|
|
|
|
|
|
|
|
|
|
|
Net Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order receipt |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order release |
|
|
|
|
|
|
|
|
|
|
|
|
Item: C |
Production Lead Time: 2 week |
Lot size rule: Lot-for-Lot |
|||||||||
|
Week No. |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
|
Gross Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Adjusted Scheduled Receipts |
|
|
|
|
|
|
|
|
|
|
|
|
Projected on-hand 20 |
|
|
|
|
|
|
|
|
|
|
|
|
Net Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order receipt |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order release |
|
|
|
|
|
|
|
|
|
|
|
|
Item: D |
Production Lead Time: 3 weeks |
Lot size rule: Lot for Lot |
|||||||||
|
Week No. |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
|
Gross Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Adjusted Scheduled Receipts |
|
|
|
|
|
|
|
|
|
|
|
|
Projected on-hand 300 |
|
|
|
|
|
|
|
|
|
|
|
|
Net Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order receipt |
|
|
|
|
|
|
|
|
|
|
|
|
Planned order release |
|
|
|
|
|
|
|
|
|
|
|
Summary
This question belongs to operations management and discusses about material requirement and planning.
Word count: NA
Download Full Solution
WHAT OUR STUDENTS SAY
I was really stuck with my signal processing assignment in my third year of engineering and needed serious help. It was then when I came across this wonderful website. The experts here are open to suggestions and unassuming and instead of a situation where they act like they know everything (as in the case of most online tutoring websites) they listened to me and helped me out. I really liked what they did with all my assignments and most importantly helped me get good grades.
Ann Wood Student
I had spent a lot on another online assignment service provider but their quality of work left a lot to be desired and most of the time I was having to redo the whole thing on my own. So I was ending up paying a bomb without getting any results. That is when my friend told me about the great quality and affordable prices of HwA. Once I gave it a try I knew I had hit gold! My grades improved a lot and I have also got a clearer understanding of the concepts of factor markets.
Ahmed Shah Student
I am extremely satisfied with the Visual C++ programming assignment help that I have received from HwA. The professor was very impressed with the quality of documentation and the grades speak for themselves.
Patrick Cairns Student
The most fascinating thing is how they actually respond to quick demand. It was a classic mistake! The actual deadline of my ratio analysis assignment was on 16th and I mentioned to them that it is 26th. Just when I had pinged them on 14th, they instantly delivered me the accounting homework by 15th evening. I was so relieved and thrilled to get in the same.
John Stamford Student
I desperately needed help to understand the topics under public works engineering and did not know where to turn to. Thankfully one of my friends suggested taking the online civil engineering tutoring sessions with HwA. The online tutors not only helped me understand the concepts but also provided reference material and notes to write the assignment essays.
Nadeem Ansari Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.