-
+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
Chemical engineering problems often used to confuse me. I was searching for some experts who can genuinely help with such solutions. I always loved Chemistry but Chemical Engineering was something completely different. I took help from TheReliableTutor on several occasions and so far they have delivered the reports on time.
Sharon Robinson Student
I had to choose my own research topic for my final year dissertation during my post graduate management course and I was really confused. I was not sure from where I can get a standard response matching the requirements of my New Zealand based university. I must admit that I was lucky to come across HwA as they have experts located in New Zealand who helped me with the assignment and more importantly helped me achieve grades, beyond expectation.
Fiona Nash Student
1. My main concern was the relevant research and reference work that is required in my Masters course in the university. They are very particular about referenced and researched assignments and with the stats experts at TheReliableTutor.com I have never have had to worry about that since the experts provide the most excellent and relevant references in all my assignments which help me get top marks in the class.
Amanda Swift Student
Honestly speaking, most of the online essay writing experts, available on the internet, are US based writers. So, naturally their perspectives are different than what we are being taught in our school. The variation in socio-political viewpoints makes critical impact in the arguments presented in an essay. Luckily, HwA has essay writing experts who have not only passed out from schools from New Zealand but also taught there. So, naturally they understood the need of the argumentative essay I needed, and delivered quality work.
Martin Wilson Student
There are things I failed to get a grasp on in my classes and for that reasons assignments often looked much more challenging for me. However, luckily I came across HwA and from my BSc N course till the final year of my MSc N course I always take their help and get good results.
Jacob Tremblay 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.