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 Click here for the Excel Data File 8 Additional units End 1 0 End hem The latest week B 3 10 D (3) C 2 9 D 2 25 E 2 11 F 1 32 G 2 3 E (2) H14) E (2) E (2) F (3) a. If 18 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.) H b. An order for the end Item is scheduled to be shipped at the start of week 14. 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 ether)

The followng table lists the components needed to assemble an end rem, lead times, and quantites on hand. Click here forthe Excel Data Fle a. If 18 units of the end hem are to be ascembled, how many additional unts of E are needed? (Hine You dont need to develap an MPP plan to detormine this.) b. An order for the end ftem is scheduled to be shipped at the stant of weok 14 . What is the latest week that the ordir can be atarted and stil be ready to ship on time? (Hint You don't need to develop an Mirs plan for this part ecthec)