Problem $21-9($Algo$)$

Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies $(x)$ is $134$ units. The following is the BOM in indented form:

$\backslash$table$[[$ITEM$,$DESCRIPTION,USAGE$],[$X$,$Bracket assembly,$1],[$A$,$Wall board,$3],[$B$,$Hanger subassembly,$2],[$D$,$Hanger casting,$3],[$E$,$Ceramic knob,$1],[$C$,$Rivet head screw,$4],[$F$,$Metal tong,$4],[$G$,$Plastic cap,$1]]$

The following table indicates current inventory levels:

$\backslash$table$[[$Item$,$X$,$A$,$B$,$C$,$D$,$E$,$F$,$G$],[$Inventory$,21,12,65,21,192,172,1,280,100]]$

b$.$ What are the net requirements of each item in the MPS$?$

Note: Leave no cells blank $-$ be certain to enter $"$O$"$ wherever required.

$\backslash$table$[[$Item$,$Net Requirements$],[$X$,],[$A$,],[$B$,],[$C$,],[$D$,],[$E$,],[$F$,],[$G$]]$