Q3 excel download is shown, this is the entire question please help.

F16 xv fx A B c 2 Safety Stock Management Instructions Beginning Inventory Parent 2 Part 1 14 Part 2 9 Quantity per Parent Amount 4 Lot Size 1 12 9 Lead Time 1 1 1 o 80.0% 95.0% 99.0% 14 12 5 0 25 35 45 450 450 250 6 2 8 9 Material Requirements Plan Period 1 Demand 5 6 7 8 10 72 65 30 84 12 Parent 13 Gross Requirements 14 15 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases 16 12 20 Part 1 21 Gross Requirements Scheduled Receipts Projected On Hand (at beginning of period) Net Requirements 21 21 Planned Order Receipts Planned Order Releases 21 21 Part 2 Gross Requirements Scheduled Receipts 30 Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts 11 4 Planned Order Releases 36 What is the Part 1's Net Requirements for Period 5? A/ What is Part 2's Gross Requirements for Period 5? A/ What is Part 2's Planned Order Release for Period 2? A What is Part 2's Projected On-Hand Inventory for Period 6? A What is Part 2's Projected On-Hand Inventory for Period 8? A Previous Page Next Page F16 xv fx A B c 2 Safety Stock Management Instructions Beginning Inventory Parent 2 Part 1 14 Part 2 9 Quantity per Parent Amount 4 Lot Size 1 12 9 Lead Time 1 1 1 o 80.0% 95.0% 99.0% 14 12 5 0 25 35 45 450 450 250 6 2 8 9 Material Requirements Plan Period 1 Demand 5 6 7 8 10 72 65 30 84 12 Parent 13 Gross Requirements 14 15 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases 16 12 20 Part 1 21 Gross Requirements Scheduled Receipts Projected On Hand (at beginning of period) Net Requirements 21 21 Planned Order Receipts Planned Order Releases 21 21 Part 2 Gross Requirements Scheduled Receipts 30 Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts 11 4 Planned Order Releases 36 What is the Part 1's Net Requirements for Period 5? A/ What is Part 2's Gross Requirements for Period 5? A/ What is Part 2's Planned Order Release for Period 2? A What is Part 2's Projected On-Hand Inventory for Period 6? A What is Part 2's Projected On-Hand Inventory for Period 8? A Previous Page Next Page