Question

Given the following data, construct a material requirements plan for all components which will result in 200 units of (P) at the beginning of week 6. (Use Excel and submit your answer in the drop box). P A B (3) B (2) Item Currently On- Hand Order Quantity Scheduled Receipt (wk) Lead time 1 0 70 50 A B 30 (wk3) L4L Lot size 100 Lot size 100 3

Answer 1

Item: P,LT=1,Q = L4L, OH = 0	1	2	3	4	5	6
Gross requirement	0	0	0	0	0	200
Scheduled receipts	0	0	0	0	0	0
Projected on hand	0	0	0	0	0	0
Net requirements	0	0	0	0	0	200
Planned order receipts	0	0	0	0	0	200
Planned order releases	0	0	0	0	200	0
Item: A,LT=1,Q = 100,OH = 70	1	2	3	4	5	6
Gross requirement	0	0	0	0	200	0
Scheduled receipts	0	0	30	0	0	0
Projected on hand	70	70	100	100	0	0
Net requirements	0	0	0	0	100	0
Planned order receipts	0	0	0	0	100	0
Planned order releases	0	0	0	100	0	0
Item: B,LT=3,Q = 100, OH = 50	1	2	3	4	5	6
Gross requirement	0	0	0	200	600	0
Scheduled receipts	0	0	0	0	0	0
Projected on hand	50	50	50	50	50	50
Net requirements	0	0	0	150	550	0
Planned order receipts	0	0	0	200	600	0
Planned order releases	200	600	0	0	0	0