PLEASE USE EXCEL!

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 requirement for each BOM item is $1$

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