Question Completion Status: QUESTION 22 Basic MRP logic. The production requirement is for 200 units of Part A in Period 6. Part A requires Part B. C and D. The BOM tree, lead times, lot sizing, safety stock and Inventory are detailed on the attached spreadsheet & below. Excel File: MGMT365 MT2 Collateral Axlsx Determine the required timing and quantity of all parts, then fill in the blanks below. Enter ONLY numbers .NO TEXT. (Note: The blank MRP records are provided on the spreadsheet for convenience, but they are not required to work through the logic.) The production requirement is 200 units of Part A in Period 6. (Week 6) Parent and The Parent Ty to Om Part A Lofoto Part Lofoto Part Order: Lot for Lor Lofoto Part A Safety Stol Part Leadine w ChildParent Ratio: 2 Part Lead Time Child/Parent Ratio 1 Part Click Save and Submit to save and submit. Click Save All Answers to save all answers Child/Parent Ratio: 2 Part A Planned Order Release of units in period Part B Planned Order Release of units in period Part C Planned Order Release of units in period Part D Planned Order Release of units in period Click Save and Submit to save and submit. Click Save All Answers to save all answers