Problem $21-9($Algo$)$

Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies $(x)$ is $130$ units. The following is the Bo in inderted form:

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

Below is a table indicating current inventory levels:

$\backslash$table$[[$Item$,x,$A$,8,C,$E$,$E$,$F$,$G$],[$Inventory$,27,18,63,23,190,150,1,300,99]]$

b$.$ What are the net requirements of each item in the MPS$?($Leave no cells blank $-$ be certaln to enter $"$O$"$ wherever required.$)$

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