1 The following table lists the components needed to assemble an end item, lead times, and quantities on hand. 6.66 points Item LT (week) Amount on hand no End 2 0 B 2 11 00 NO D 2 26 E 1 12 F 2 28 G 1 6 INO eBook Click here for the Excel Data File Hint End Item Print B (2) D (3) E 21 F(3) G (2) E (2) H14) E (2) a. If 20 units of the end item are to be assembled, how many additional units of E are needed? (Hint You don't need to develop an MRP plan to determine this.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 17. What is the latest week that the order can be started and still be ready to ship on time? (Hint You don't need to develop an MRP plan for this part either.) The latest week 2 The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. 6.66 points Item End L K B J G H Lead Time 2 2 3 3 2 Amount on Hand 0 11 16 21 29 30 7 0 Direct Components L(2), C(1), K(3) B(2), J(3) G(2), B(2) H(4), B(2) eBook 3 2 Hint Print Click here for the Excel Data File a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint: You don't need to develop an MRP plan.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 11. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don't need to develop an MRP plan.) The latest week Check my work m. Assume you are the manager of a shop that assembles power tools. You have just received an order for 58 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: 6.68 points Lead Time (weeks) Item Saw A B D E F 1 2 2 eBook On Hand 15 10 5 65 20 10 30 Components A(2), B(1), C(4) E(3), D(1) D(2), F(3) E(2), D(2) Print 1 2 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.) Beg. Inv. 2 6 8 E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release