Given the following MRP system structure: A single unit of X is made of 2 units of A and 1 unit of B; A is made of 1 unit of C and 1 unit of D; B is made of 2 units of D and 3 units of E. Assuming there is a requirement of 100 units of final product of X by week 10. The MRP planning template includes Lead time (LT) and inventory level for each unit. Question: What is the net requirement and release times for D? When using the template please note that all on-hand inventory and lead time have been included in the first column of the table: Week 1 2 3 4 5 6 7 8 9 10
X
LT =2
On hand 50
Gross requirements
Scheduled receipts
Project Available balance
Net requirements
Planned order receipt
Planned order release
A
LT = 3
On hand 60
Gross requirements
Scheduled receipts
Project Available balance
Net requirements
Planned order receipt
Planned order release
B
LT = 1
On hand 25
Gross requirements
Scheduled receipts
Project Available balance
Net requirements
Planned order receipt
Planned order release
C
LT = 2
On hand 30
Gross requirements
Scheduled receipts
Project Available balance
Net requirements
Planned order receipt
Planned order release
D
LT = 2
On hand 20
Gross requirements
Scheduled receipts
Project Available balance
Net requirements
Planned order receipt
Planned order release
E
LT = 3
On hand 30
Gross requirements
Scheduled receipts
Project Available balance
Net requirements
Planned order receipt
Planned order release
A. 20 units at week 5 & 50 units at week 3
B. 70 units at week 3 & 70 units at week 5
C. 20 units at week 4 & 50 units at week 6
D. 50 units at week 6 & 20 units at week 4
E. 20 units at week 3 & 50 units at week 5