Question

Given the following MRP matrix for Item Z, prepare a material requirements plan for component P. Lot-for-lot ordering will be used for component P.

ITEM: Z        Lot Size: Q=100 LT: 1 Project on Hand : 200	Period
	1	2	3	4	5	6	7
Gross Requirements			600		300	270	200
Schedule Receipts		250			150
Project on Hand              200
Net Requirements
Planned Order Receipts
Planned Order Releases

ps fr unit 1 is 100 and i do not have the tree

Answer 1

I assume that for each unit of Z, 100 unit of p is required with L4L method and 1 week of lead time.

Below is the required MRP schedule -

Z LT = 1 Q = 100		On Hand	1	2	3	4	5	6	7
	Gross Requirement		0	0	600	0	300	270	200
	Scheduled Receipts		0	250	0	0	150	0	0
	Projected on Hand	200	200	450	50	50	0	30	30
	Net Requirements		0	0	150	0	100	270	170
	Planned Order Receipts		0	0	200	0	100	300	200
	Planned Order Releases		0	200	0	100	300	200	0
P LT = 1 Q = L4L		On Hand	1	2	3	4	5	6	7
	Gross Requirement		0	20000	0	10000	30000	20000	0
	Scheduled Receipts		0	0	0	0	0	0	0
	Projected on Hand	0	0	0	0	0	0	0	0
	Net Requirements		0	20000	0	10000	30000	20000	0
	Planned Order Receipts		0	20000	0	10000	30000	20000	0
	Planned Order Releases		20000	0	10000	30000	20000	0	0