Assume that you are the manager of a shop that assembles power tools, you have just received an order for 55 chain saws, which are to be shipped at the start of week 8. pertinent information on the saw is
Item Lead Time (weeks) on hand Components
Saw 2 15 A(2), B(1), C(4)
A 1 10 E(3), D(1)
B 2 5 D(2), F(3)
C 2 65 E(2), D(2)
D 1 20
E 1 10
F 2 30
Develop the material requirements plan for component E using lot-for-lot ordering. (Leave no cells blank - be certain to enter "0" wherever required)
Item: E(3) & E(2) LT = 1 wk. Beg. Inv. 1 2 3 4 5 6 7 8
Gross requirements _______ ___ ___ ___ ___ ___ ___ ___ ___
Scheduled receipts
Projected on hand ________ _____ ____ ____ ___ ___ _____ ____ _____
Net requirements ________ _____ ____ ____ ____ ____ ____ ____ _____
Planned order receipt ________ _____ _____ ____ ____ ____ ____ ____ _____
Planned order release ________ _______ _____ _____ ____ ____ ____ _____ ______