Question

Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for item D. A 400 unit-delivery of product P is due at the beginning of week 7. Use the worksheet Product Structure Tree Inventory Information P Order Currently Scheduled Lead Item On-Hand Recpt (wk) Time Qty LAL P 100 L4L A A FIxed Q 450 Fixed Q = 600 L4L 0 C 90 100 (wk 2) 80 (wk 2) 2 50 2 C D(2 Beg Week# 1 2 3 4 6 7 Inv. 400 Quantity Item: P Gross requirements wk Scheduled receipts Projected on hand LT= Lot size Net requirements Planned-order receipts Planned-order releases Gross requirements wk Scheduled receipts Projected on hand LT Lot size L4L Net requirements Planned-order receipts Planned-order releases Gross requirements wk Scheduled receipts Projected LT= Lot size on hand L4L Net requirements Planned-order receipts Planned-order releases LC

Answer 1

Since the question asks for MRP of only item D, we will skip the other items and create MRP of D only from P. This will include the intermediate item B.

The MRP is shown below

	Week	Beg Inv	1	2	3	4	5	6	7
	Quantity								400
Item P	Gross req								400
LT = 1	Sch rec
LS = L4L	POH	0
	Net req								400
	PO rec								400
	PO rel							400
Item B	Gross req							400
LT = 1	Sch rec
LS = 450	POH	0
	Net req							400
	PO rec							450
	PO rel						450
Item P	Gross req						900
LT = 1	Sch rec			80
LS = L4L	POH	50	50	130	130	130	0
	Net req						770
	PO rec						770
	PO rel				770