Prepare a material requirements plan for component D$.$ D can only be ordered in whole cases $(50$ units per case$).$ One case of $D$ is automatically received every other week, beginning in week $1($i$.$e$.,$ weeks $1,3,5,7).$ Also, there are $30$ units of $B$ and $20$ units of D now on hand. Lead times for all items are a function of quantity: one week for up to $100$ units, two weeks for $101$ to $200$ units, three weeks for $201$ to $300$ units, and four weeks for $301$ or more units. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$

$\backslash$table$[[$Part D$,$Beg. Inv.,$1,2,3,4,5,6,7,8],[$Gross requirements,,,,,,,,,$],[$Scheduled receipts,,,,,,,,,$],[$On hand,,,,,,,,,$],[$Net requirements,,,,,,,,,$],[$Planned$-$order receipt,,,,,,,,,$],[$Planned$-$order release,,,,,,,,,$]]$