Complete the following MRP matrix for Item X. Determine when orders should be re
ID: 472234 • Letter: C
Question
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
Explanation / Answer
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