No idea what this is, please help by explaining what you plan on doing and how to solve the questions/statements. Thank you ! When showing work, please show the cell numbers within excel.

Assignment 1 - ERP Introduction Work must be completed with MS Excel Develop a material requirements plan for end item P and its components, given the tree below. P. A(2) B(3) D(4) C(2) F(2) F(2) 1. Assume that all lead times are one week, and that lot-for-lot ordering is used except for item F which is ordered in multiples of 400 units. 2. One hundred units of P are needed at the start of each of weeks 4 and 8. Beginning inventories are: 20 P, 100 A, and 200 F. 3. Scheduled receipts are: 800 F at the start of week 1