data in excel file

Download HW 4 (Excel download) and perform the necessary MRP calculations. Then enter selected values below. What is the Parent's Projected On-Hand Inventory for Period 2? What is the Parent's Planned Order Release for Period 3? What is the Parent's Net Requirements for Period 8? What is Part 1's Gross Requirements for Period 5? What is the Part 1's Net Requirements for Period 7? What is the Part 1's Planned Order Release for Period 7? What is Part 2's Gross Requirements for Period 7? What is Part 2's Planned Order Release for Period 23 What is Part 2's Projected On-Hand Inventory for Period 6? What is Part 2's Planned Order Receipt for Period 5? le Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Management Instructions Safety Stock Beginning Inventory Lead Time Quantity per Parent Lot Size O Amount Parent Part 1 Part 2 458 24 31 500% 500% 500% 5,300 1,900 675 15 500 12 Material Requirements Plan Period Demand 202 72 60 Parent Gross Requirements Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases art 1 HW 4 Part 1 Gross Requirements Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases :6 Part 2 Gross Requirements Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases HW 4