Problem $13-10($Algo$)$

Assume you are the manager of Assembly, Inc. You have just received an order for $29$ units of an industrial robot, which is to be delivered at the start of week $7$ of your schedule Using the following information, determine how many units of subassembly $G$ to order and the timing of those orders, given that subassembly $G$ must be ordered in multiples of $80$ units and all other components are ordered lot$-$for$-$lot. Assume that the components are used only for this particular robot.

$\backslash$table$[[$Item$,$Lead Time $($weeks$),$On Hand,Components$],[$Robot$,2,10,$B$,$ G$,$ C$(3)],[$B$,1,5,$E$,$ F$],[$C$,1,20,$G$(2),$ H$],[$E$,2,4,],[$F$,3,8,-],[$G$,2,15,-],[$H$,1,10,]]$

Click here for the Excel Data File

$\backslash$table$[[$Subassembly G order quantity $($in units$)],[$Order subassembly $G$ at start of week$]]$