Question

Assume that Product Z is made of two units of A and four units of B. A is made of three units of C and three of D. D is made of three units of E

     Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks.

     Fifty seven units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.)

b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.)

	Period	1	2	3	4	5	6	7	8	9	10
Item Z OH = 0 LT = 2 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item A OH = 0 LT = 1 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item B OH = 0 LT = 1 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item C OH = 0 LT = 1 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item D OH = 0 LT = 1 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item E OH = 0 LT = 3 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases

Answer 1

		Week		1	2	3	4	5	6	7	8	9	10
Item:	Z	Gross requirements		0	0	0	0	0	0	0	0	0	57
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	2	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	0	0	0	0	57
Q =	L4L	Planned order receipts		0	0	0	0	0	0	0	0	0	57
		Planned order releases		0	0	0	0	0	0	0	57	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	A	Gross requirements		0	0	0	0	0	0	0	114	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	1	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	0	0	114	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	0	0	114	0	0
		Planned order releases		0	0	0	0	0	0	114	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	B	Gross requirements		0	0	0	0	0	0	0	228	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	1	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	10	Net requirements		0	0	0	0	0	0	0	228	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	0	0	228	0	0
		Planned order releases		0	0	0	0	0	0	228	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	C	Gross requirements		0	0	0	0	0	0	342	0	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	1	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	0	342	0	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	0	342	0	0	0
		Planned order releases		0	0	0	0	0	342	0	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	D	Gross requirements		0	0	0	0	0	0	342	0	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	1	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	0	342	0	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	0	342	0	0	0
		Planned order releases		0	0	0	0	0	342	0	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	E	Gross requirements		0	0	0	0	0	1026	0	0	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	3	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	1026	0	0	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	1026	0	0	0	0
		Planned order releases		0	0	1026	0	0	0	0	0	0	0