please help thank you!

Question 4 2 pts A factory has just received an order for 100 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Item Lead Time On Hand Scheduled (weeks) Inventory receipts Order Policy Direct Components End item 2 30 lot for lot A(4), B(3), C(2) 20 88 at week 3 lot for lot D(4) 3 2 B 10 174 at week 4 lot for lot D(3) C 1 100 multiple of 60 D 1 20 min. of 500 Develop the material requirements plan (please print out an empty MRP table to work with), and determine what the "projected available balance" is for component D at week 8. Input should be an exact number MRP Table Item Period 4 5 2 3 6 7 8 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order release Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order release Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order release Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order release Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order release Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order release