Problem 13-9 (Static) Assume you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Lead Time Item (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) 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 Click here for the Excel Data File b. Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "O" wherever required.) E(3) & E(2) LT = 1 week Beg. Inv. 1 2 3 5 6 7 8 Lot size: Lot-for-Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release