Question

Assume that you are the manager of a shop that assembles power tools. You have just received an order for 51 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Lead Time (weeks) On Hand Item Saw Components A(2), B(1), C(4) E(3), D(1) D(2), F(3) E(2), D(2) Mowu Develop the material requirements plan for component Eusing lot-for-lot ordering. (Leave no cells blank - be certain to enter "0" wherever required.) Beg. Inv. Item: E(3) & E(2) LT = 1 wk. Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release

Answer 1

Item = E	Beg Inv	1	2	3	4	5	6	7	8
Gross requirements		0	0	0	158	186	0	0	0
Scheduled receipts		0	0	0	0	0	0	0	0
Projected on hand	10	10	10	10	0	0	0	0	0
Net requirements		0	0	0	148	186	0	0	0
Planned order receipt		0	0	0	148	186	0	0	0
Planned order release		0	0	148	186	0	0	0	0

For your reference following MRP plans were also developed to derive MRP for E

Item = Saw	Beg Inv	1	2	3	4	5	6	7	8
Gross requirements		0	0	0	0	0	0	0	51
Scheduled receipts		0	0	0	0	0	0	0	0
Projected on hand	15	15	15	15	15	15	15	15	0
Net requirements		0	0	0	0	0	0	0	36
Planned order receipt		0	0	0	0	0	0	0	36
Planned order release		0	0	0	0	0	36	0	0
Item = A	Beg Inv	1	2	3	4	5	6	7	8
Gross requirements		0	0	0	0	0	72	0	0
Scheduled receipts		0	0	0	0	0	0	0	0
Projected on hand	10	10	10	10	10	10	0	0	0
Net requirements		0	0	0	0	0	62	0	0
Planned order receipt		0	0	0	0	0	62	0	0
Planned order release		0	0	0	0	62	0	0	0

Item = C	Beg Inv	1	2	3	4	5	6	7	8
Gross requirements		0	0	0	0	0	144	0	0
Scheduled receipts		0	0	0	0	0	0	0	0
Projected on hand	65	65	65	65	65	65	0	0	0
Net requirements		0	0	0	0	0	79	0	0
Planned order receipt		0	0	0	0	0	79	0	0
Planned order release		0	0	0	79	0	0	0	0