The following table lists the components needed to assemble an end item, lead times, and quantities on hand.

?

?

Item End B C D E F G H

LT $($ week $)31332323$

Amount on hand $012727133150$

?

Click here for the Excel Data File

?

a $.$ ?If $23$ ?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. $)$

?

?

b $.$ ?An order for the end item is scheduled to be shipped at the start of week $18.$ ?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. $)$