Developing a MRP - material requirements plan

Below is needed to be completed.

Please complete the tables for items C, D and E

• Each unit of A is composed of 1 unit of B, 2 units of C, 1 unit of D

• C is composed of 2 units of D, 3 units of E

• Items A, C, D, and E have on-hand inventories of 20, 10, 20, and 10 units, respectively

• Item B has a scheduled receipt of 10 units in period 1

• Item C has a scheduled receipt of 50 units in period 1

• L4L is used for Items A and B

• Item C requires a minimum lot size of 50 units

• D and E are required to be purchased in multiples of 100 and 50, respectively

• Lead times are one period for Items A, B, and C, and two periods for Items D and E

• The gross requirements for A are 30 in period 2, 30 in period 5, and 40 in period 8

Period			1	2	3	4	5	6	7	8	9
Item: A	Gross Requirements			30			30			40
	Scheduled receipts
LT= 1	Projected on hand	20	20	20	0	0	0	0	0	0	0
	Net requirements			10			30			40
Q=	Planned order receipts			10			30			40
L4L	Planned order releases		10			30			40

Period			1	2	3	4	5	6	7	8	9
Item: B	Gross Requirements		10			30			40
	Scheduled receipts		10
LT= 1	Projected on hand
	Net requirements		0	0	0	30	0	0	40
Q=	Planned order receipts					30			40
L4L	Planned order releases				30			40

Period			1	2	3	4	5	6	7	8	9
Item: C	Gross Requirements		20			60			80
	Scheduled receipts
LT= 1	Projected on hand
	Net requirements
Q=	Planned order receipts
min of 50	Planned order releases

Period			1	2	3	4	5	6	7	8	9
Item: D	Gross Requirements
	Scheduled receipts
LT= 2	Projected on hand
	Net requirements
Q=	Planned order receipts
multiples of 100	Planned order releases

Period			1	2	3	4	5	6	7	8	9
Item: E	Gross Requirements
	Scheduled receipts
LT= 2	Projected on hand
	Net requirements
Q=	Planned order receipts
multiples of 50	Planned order releases