-
+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 really needed assistance with my clinical epidemiology assignment while I came across HwA and was thrilled to find that they have expert dealing with that area of nursing. It was really cherishing and the nursing experts here are well experienced and well equipped with the nitty-gritty of a patient care.
Peggy Williams Student
My balance sheet never tallied before I approached HwA for help. I always used to mess things up. My ideas regarding the items to be entered where shady and I needed serious help. The balance sheet experts of HwA were of a great help and now I have gained much confidence in the subject.
Julie Lee Student
I had missed the classes on Isometrics because I had to miss school for some family emergencies. With the existing course load I had not got time to catch up with the topic and so when time came to write the assignment on Isometrics I was absolutely clueless. Thanks to the basic mathematics assignment experts at HwA I was able to not only understand the assignment but also submit the essay on time. The quality of work provided is also very high and I have been noticing an upturn in my overall grades.
Jamal Akhtar Student
1. As my parents are both cost accountants, I thought that accounting is my blood. However, everything is not that easy as I often failed to match my trial balance and was finding it problematic to write my cash-flow statements. I knew I need assistance apart from the help that I get from my accounting professor. So when I saw TheReliableTutor.com, I was happy as they helped me solve my accounting homework. I even got good grades now.
Xavier Giovani Student
The nursing expert of HwA has actually cleared by idea about gastrointestinal anatomy and helped me in several occasions with critical case study solutions involving gastrointestinal issues of the patients.
Matthew Galloway 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.