Please solve and provide thorough steps to results with the formulas involved. Thank you!

HW #7. Due 5/1 (Fri). This homework is worth 20 points. Given the following data, develop MRP plans for items C, D, E and F. MPS start for end items: The following table shows the MPS start information for two end items: item A and B. For example, we have a plan to start producing 80 units of end item A in week 3. End item Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 150 80 100 B 60 100 Bill of materials: - End item A is made of 1 unit of item C and 1 unit of item D. - Item D is made of 2 units of item E and 2 units of item F. - End item B is made of 1 unit of item C and 2 units of item F. MRP-related information for each item: Item Leadtime Lot sizing (weeks) Safety stock requirement Available on-hand inventory Scheduled receipts 50 80 L4L L4L FOQ (250) FOQ (100) 80 in week 1 None 250 in week 3 200 in week 1 10 30