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 four of D. D is made of two 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 eight 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.)

Answer 1

Week	3	4	5	6	7	8	9	10
Product Z (Lead time = 2 week)
Available balance								50
Net Requirements								0
Planned order receipts								50
Planned order releases						50		50
Item A ((Lead time = 1 week)
Gross Requirements						100
Available balance						0
Net Requirements						100
Planned order receipts						100
Planned order releases					100
Item B ((Lead time = 1 week)
Gross Requirements						200
Available balance						0
Net Requirements						200
Planned order receipts						200
Planned order releases					200
Item C ((Lead time = 1 week)
Gross Requirements					300
Available balance					0
Net Requirements					300
Planned order receipts					300
Planned order releases				300
Item D ((Lead time = 1 week)
Gross Requirements					400
Available balance					0
Net Requirements					400
Planned order receipts					400
Planned order releases				400
Item E ((Lead time = 3 week)
Gross Requirements				800
Available balance				0
Net Requirements				800
Planned order receipts				800
Planned order releases	800