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

Amount on hand $012727133170$

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 $22$ 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.$)$