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: 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 " 0 " wherever required.)