doing a practice final please help

12. (25 points) Complete the MRP calculations for the simple product shown below Numbers next to each item identify the usage rates For example, the usage rate for item A is 2 BI Item X L4L On Hand Lead Time B0 1 6 1 70 70 2 100 3 120 4 50 5 85 7 110 8 70 100 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release Item A FOQ+ On Hand Lead Time 150 30 1 1 2 3 5 6 200 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release Item B FPO On Hand Lend Time 2 320 1 2 3 6 7 8 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release Item C FOOX On Hand Lead Time 250 0 2 1 2 3 5 6 8 650 660 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release