Question

Prepare a material requirements plan for component D. D can only be ordered in whole cases (50 units per case). One case of D is automatically received every other week, beginning in week 1 (i.e., weeks 1, 3, 5, 7). Also, there are 30 units of B and 20 units of D now on hand. Lead times for all items are a function of quantity: one week for up to 100 units, two weeks for 101 to 200 units, three weeks for 201 to 300 units, and four weeks for 301 or more units.

Part D	Beg. Inv.	1	2	3	4	5	6	7	8
Gross requirements
Scheduled receipts
On hand
Net requirements
Planned-order receipt
Planned-order release

Answer 1

To create the MRP for D, we will have to create the MRP for X & B as well since X&B will help in calculating the requirement for D.

Below if the MRP schedule -

X Q = L4L		On Hand	1	2	3	4	5	6	7	8
Gross Requirement		0	0	0	0	0	80	0	30
Scheduled Receipts		0	0	0	0	0	0	0	0
Projected on Hand	0	0	0	0	0	0	0	0	0
Net Requirements		0	0	0	0	0	80	0	30
Planned Order Receipts		0	0	0	0	0	80	0	30
Planned Order Releases		0	0	0	0	80	0	30	0
B Q = L4L	Gross Requirement		0	0	0	0	160	0	60	0
Scheduled Receipts		0	0	0	0	0	0	0	0
Projected on Hand	30	30	30	30	30	0	0	0	0
Net Requirements		0	0	0	0	130	0	60	0
Planned Order Receipts		0	0	0	0	130	0	60	0
Planned Order Releases		0	0	130	0	0	60	0	0
D Q = 50*	Gross Requirement		0	0	260	0	240	120	90	0
Scheduled Receipts		50	0	50	0	50	0	50	0
Projected on Hand	20	70	70	10	10	20	0	10	10
Net Requirements		0	0	140	0	180	100	40	0
Planned Order Receipts		0	0	150	0	200	100	50	0
Planned Order Releases		150	0	200	0	100	50	0	0

Please Please up vote this answer. I worked a lot to write a perfect answer and understandable to you. Your up vote is so valuable to me. Please. Thank you so much.