Problem 13-2 (Algo) The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item LT (week) Amount on hand End 1 0 B 3 7 D 1 22 1 12 E 1 8 F 1 26 G 1 3 H 1 I-O 00 Click here for the Excel Data File Endrom B12) C DO E E12 E FO G2 H141 a. If 17 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 8121 DO E121 FO G2 E 14) E (2) a. If 17 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 12 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 . A1 X fx Item B D E F G H 1 End B C D E F G H Item LT (wk) Amount on hand 3 1 1 0 1 12 1 22 1 8 1 3 26 1 0 7