Hand50Net Requirementsplanned Order Receiptsplanne
Material Requirements Planning POM
The assignment is listed below along with required guidelines.
There are 2 questions to be answered.
The write up should be in 12 font APA format for the written part of the assignment. The calculations should be in Word but also the calculations should be either spelled out in the Word document for all questions and if Excel used to calculate the excel spreadsheets should be provided as well.
Submit correct solutions:
oThe required elements for problem 15-12: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.
oFor problem 15-13: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.
2.Write 1–3 paragraphs that demonstrate your knowledge of the concepts from the assigned reading related to the problem solutions
3.Write 1–3 paragraphs that explain the solution using the concepts from the assigned reading that relate to the solution.
The required elements for problem 15-12: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.
Complete the following MRP matrix for item A:
Item: A |
LLC: 1 |
Period |
|||||||
Lot Size: Mult 50 |
LT: 2 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
Gross Requirements |
10 |
15 |
25 |
75 |
60 |
85 |
45 |
60 |
|
Scheduled Receipts |
|||||||||
Projected on Hand |
50 |
||||||||
Net Requirements |
|||||||||
Planned Order Receipts |
|||||||||
Planned Order Releases |
15-13
For problem 15-13: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.
Complete the following MRP matrix for Item X. Determine when orders should be released and the size of those orders.
Item: X |
LLC: 0 |
Period |
|||||||
Lot Size: Min 50 |
LT: 2 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
Gross Requirements |
25 |
30 |
56 |
25 |
100 |
40 |
30 |
20 |
|
Scheduled Receipts |
50 |
||||||||
Projected on Hand |
30 |
||||||||
Net Requirements |
|||||||||
Planned Order Receipts |
|||||||||
Planned Order Releases |