Homework SourseComplete the following MRP matrix for Item X Determine when
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
Release orders in periods 1 through 5 for quantities of 50, 50, 56, 50, and 50 respectively.
| 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 |
Solution
Ans:
The MRP matrix for the item x is given below:
| 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 | 5 | 25 | 25 | 19 | 44 | 0 | 10 | |
| Net Requirements | 31 | 6 | 56 | 40 | 20 | ||||
| Planned Order Receipts | 50 | 50 | 56 | 50 | 50 | ||||
| Planned Order Releases | 50 | 50 | 56 | 50 | 50 |
