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.
Please, do not post the same chart that has been floating around this site. It hardly answers the question.
| 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
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
19
44
0
10
30
10
Net Requirements
31
6
56
40
20
Planned Order Receipts
50
50
56
50
50
Planned Order Releases
50
50
56
50
50
Period-1
Project at hand =30-25=5
Period-2
Project at hand =50+5-30=25
Period -3
Net requirement =56-25=31
Planned order receipt=50(Min lot size)
Project at hand=50-31=19
Period-4
Net requirement =25-19=6
Planned order receipt=50(Min lot size)
Project at hand=50-6=44
Period-5
Net requirement =100-44=56
Planned order receipt=56(more than Min lot size of 50)
Project at hand=56-56=0
Period-6
Net requirement =40-0=40
Planned order receipt=50(Min lot size)
Project at hand=50-40=10
Period-7
Net requirement =30-10=20
Planned order receipt=50(Min lot size)
Project at hand=50-20=30
Period-8
Net requirement =20
Project at hand=30-20=10
Planned Order Releases is two period lag with Planned Order Receipts
| 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 | 19 | 44 | 0 | 10 | 30 | 10 |
| Net Requirements | 31 | 6 | 56 | 40 | 20 | ||||
| Planned Order Receipts | 50 | 50 | 56 | 50 | 50 | ||||
| Planned Order Releases | 50 | 50 | 56 | 50 | 50 |
