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$)13331111$

Amount on hand $07122283260$

Click here for the Excel Data File

Note: If you click the Hint link on the left you can watch a walk$-$through of the problem using different numbers.

a$.$ If $23$ units of the end item are to be assembled, how many additional units of E are needed? $($Hint: It will be easier to work through this if you redraw the BOM and add in the information on leadtime and how many units of each are in stock.$)$

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: Find the longest leadtime path in the product $($also called cumulative leadtime$)$ and then subtract it from $17.)$