Complete the following MRP matrix for item D:

$\backslash$table$[[$Item:$,$D$,,$LLC:$,1,$Period$],[$Lot Size:,Mult,$250,$LT:$,2,1,2,3,4,5,6,7,8],[$Gross Requirements,$280,250,430,585,180,550,650,950],[$Scheduled Receipts,$0,250,0,0,200,20,0,0],[$Projected on Hand,,,,,,,,$],[$Net Requirements,,,,,,,,$],[$Planned Order Receipts,,,,,,,,$],[$Planned Order Releases,,,,,,,,$]]$

Answer:

$\backslash$table$[[$Item:$,$D$,,$LLC:$,1,$Period$],[$Lot Size:,Mult,$250,$LT Use excel to complete the following MRP matrix for item A:

$\backslash$table$[[\backslash$table$[[$Item: A$],[$Lot Size: Mult $50]],\backslash$table$[[\backslash$table$[[$LLC: $1],[$LT: $2]]]],$Period$],[1,2,3,4,5,6,7,8],[$Gross Requirements,,$10,15,25,75,60,85,,45,,60],[$Scheduled Receipts$],[$Projected on Hand,$50,,,,,,,,],[$Net Requirements$],[$Planned Order Receipts$],[$Planned Order Releases,,,,,,,,,$]]$:$,2,1,2,3,4,5,6,7,8],[$Gross Requirements,$280,250,430,585,180,550,650,950],[$Scheduled Receipts,$0,250,0,0,200,20,0,0],[$Projected on Hand,$170,170,240,155,175,145,245,45],[$Net Requirements,$80,0,260,345,0,355,505,705],[$Planned Order Receipts,$250,0,500,500,-0,500,750,750],[$Planned Order Releases,$500,500\backslash$deg $,0,500,750,750,0,0]]$

Explain how they get these answers please, I understand the formula for projected on hand. I don't understand how to populate the last three rows.