Download Q 5 (Excel download) and perform the necessary MRP calculations. Then enter selected values below. What is the Parent's Net Requirements for Period 1? A/ What is the Parent's Planned Order Receipts for Period 4? A What is the Parent's Projected On-Hand Inventory for Period 5? What is Part 1's Gross Requirements for Period 6? What is the Part 1's Planned Order Receipt for Period 5? What is the Part 1's Net Requirements for Period 5? 3 A What is Part 2's Gross Requirements for Period 5? A What is Part 2's Planned Order Release for Period 5? A/ 12 What is Part 2's Projected On-Hand Inventory for Period 3? 4/ 15 What is Part 2's Projected On-Hand Inventory for Period 8? 18 anagement Instructions Quantity por Parent Lead Time 1 Amount Beginning Inventory 19 355 98 Parent Part 1 Part 2 Lot Size 60 140 24 Safety Stock P 500 700 190 a 96.0% 90.0% 80.0% 10 3 NIN 90 400 105 terial Requirements Plan Period 1 Derrand 2 3 5 8 70 115 110 60 40 ant Gross Requirements Scheduled Receipts Projected On Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Grous Requirements Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases 2 Gross Requirements 50 50 Scheduled Receipts Projected On-Hand (at beginning of period Net Requirements Planned Order Receipts