A B D E F H J 1 Management Instructions 2 Safety Stock Beginning Inventory Quantity per Parent 3 Amount 45 Parent Part 1 Part 2 Lot Size 144 350 48 4 5 6 7 Lead Time 1 2 2 4 24 45 80.0% 90.0% 90.0% 35 108 25 20 45 25 & Material Requirements Plan 9 Period 1 2 3 4 5 6 7 8 Demand 70 115 110 10 60 40 NE 12 Parent Gross Requirements 13 Scheduled Receipts 14 Projected On-Hand 15 (at beginning of period) Net Requirements Planned Order Receipts 16 17 18 Planned Order Releases 20 Part 1 Gross Requirements 21 Scheduled Receipts 22 Projected On-Hand 23 (at beginning of period) Net Requirements 24 25 Planned Order Receipts 26 Planned Order Releases 28 Part 2 Gross Requirements 29 30 Scheduled Receipts Projected On-Hand 31 (at beginning of period) Net Requirements 32 Planned Order Receipts 33 34 Planned Order Releases Download HW 12 (Excel download) and perform the necessary MRP calculations. Then enter selected values below. What is the Parent's Projected On-Hand Inventory for Period 4? A/ What is the Parent's Net Requirements for Period 4? What is the Parent's Planned Order Receipts for Period 4? What is Part 1's Gross Requirements for Period 3? What is the Part 1's Net Requirements for Period 5? A What is the Part 1's Planned Order Receipts for Period 4? A/ What is Part 2's Gross Requirements for Period 7? What is Part 2's Planned Order Release for Period 2? What is Part 2's Projected On-Hand Inventory for Period 5? What is Part 2's Planned Order Release for Period 6? A B D E F H J 1 Management Instructions 2 Safety Stock Beginning Inventory Quantity per Parent 3 Amount 45 Parent Part 1 Part 2 Lot Size 144 350 48 4 5 6 7 Lead Time 1 2 2 4 24 45 80.0% 90.0% 90.0% 35 108 25 20 45 25 & Material Requirements Plan 9 Period 1 2 3 4 5 6 7 8 Demand 70 115 110 10 60 40 NE 12 Parent Gross Requirements 13 Scheduled Receipts 14 Projected On-Hand 15 (at beginning of period) Net Requirements Planned Order Receipts 16 17 18 Planned Order Releases 20 Part 1 Gross Requirements 21 Scheduled Receipts 22 Projected On-Hand 23 (at beginning of period) Net Requirements 24 25 Planned Order Receipts 26 Planned Order Releases 28 Part 2 Gross Requirements 29 30 Scheduled Receipts Projected On-Hand 31 (at beginning of period) Net Requirements 32 Planned Order Receipts 33 34 Planned Order Releases Download HW 12 (Excel download) and perform the necessary MRP calculations. Then enter selected values below. What is the Parent's Projected On-Hand Inventory for Period 4? A/ What is the Parent's Net Requirements for Period 4? What is the Parent's Planned Order Receipts for Period 4? What is Part 1's Gross Requirements for Period 3? What is the Part 1's Net Requirements for Period 5? A What is the Part 1's Planned Order Receipts for Period 4? A/ What is Part 2's Gross Requirements for Period 7? What is Part 2's Planned Order Release for Period 2? What is Part 2's Projected On-Hand Inventory for Period 5? What is Part 2's Planned Order Release for Period 6