please provide me the answer maintain sequence and give which answer is for which question

2. Use the following MPS, BOM, and inventory record to answer the MRP questions. a) Master Production Schedule: The following table shows the MPS start dates already offset for item A's lead time. Week Week Week 1 2 3 4 5 6 MPS 60 70 40 b) Bill of materials: End item A uses 1 each of component D and 2 each of subassembly C.. Subassembly C uses 2 each of component E c) Inventory records: D E Lot sizing rule FOQ = 50 L4L POQ (P-2) Lead time (weeks) 3 1 1 30 0 30 Beginning on- hand inventory Safety stock 0 0 20 Scheduled receipts 50 (week 1) 30 (week 1) 90 (week 1) Questions: (a) Develop a material requirement plan for item D, D and E (b) What is the largest quantity of projected on hand inventory for any one of the weeks for item D? (c) How many planned order releases are there for item C? (d) What is the planned receipt in week 3 for item E