$\backslash$table$[[$Period$,8,9,101,112],[\backslash$table$[[$Gross$],[$requirements for $50],[$A$]],,60,100],[\backslash$table$[[$Gross$],[$requirements for H$]],120,8,],[$Item$,$On hand,Lead time,Item,On hand,Lead time$],[$A$,0,1,$F$,30,1],[$B$,100,1,$G$,60,2],[$C$,50,2,$H$,50,1],[$D$,80,3,$J$,80,2],[$E$,90,2,$K$,120,3]$

Given the product structure, master production schedule, and inventory status and assuming the requirements for each BOM item is $1$:

$-$ develop a gross requirements plan for Item C

$-$ develop a net requirements plan for Item C

$-$ complete a net material requirements schedule for all items $(10$ schedules in all$),$ assuming the requirements for each BOM item is $1$

$-$ complete a bet material requirements schedule for all $10$ items, assuming the requirement for all items is $1,$ except B$,$ C$,$ and F$,$ which require $2$ each

PLEASE USE EXCEL