Download HW 1 (Excel download) and perform the necessary MRP calculations. Then enter selected values below.

What is the Parent's Planned Order Receipts for Period 3?

What is the Parent's Planned Order Release for Period 4?

What is the Parent's Projected On-Hand Inventory for Period 7?

What is Part 1's Gross Requirements for Period 3?

What is the Part 1's Projected On-Hand Inventory for Period 5?

What is the Part 1's Net Requirements for Period 8?

What is Part 2's Gross Requirements for Period 4?

What is Part 2's Planned Order Release for Period 3?

What is Part 2's Projected On-Hand Inventory for Period 6?

What is Part 2's Planned Order Release for Period 2?

1 Management Instructions 2 Safety Stock Quantity per Parent 3 0 Amount 4 Beginning Inventory 12 3 108 Parent Part 1 Part 2 Lot Size 60 70 24 Lead Time 1 1 2 a 50.0% 50.0% 50.0% 5 6 7 5 2 5,300 1,900 675 300 500 300 8 Material Requirements Plan 9 Period 1 Demand 2 3 4 5 6 6 7 8 44 - 105 40 10 12 Parent Gross Requirements 13 14 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements 15 16 Planned Order Receipts 17 Planned Order Releases 18 20 Part 1 Gross Requirements 21 22 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements 23 24 Planned Order Receipts 25 Planned Order Releases 26 28 Part 2 Gross Requirements 29 Scheduled Receipts 30 Projected On-Hand 31 (at beginning of period) Net Requirements 32 Planned Order Receipts 33 Planned Order Releases 34 1 Management Instructions 2 Safety Stock Quantity per Parent 3 0 Amount 4 Beginning Inventory 12 3 108 Parent Part 1 Part 2 Lot Size 60 70 24 Lead Time 1 1 2 a 50.0% 50.0% 50.0% 5 6 7 5 2 5,300 1,900 675 300 500 300 8 Material Requirements Plan 9 Period 1 Demand 2 3 4 5 6 6 7 8 44 - 105 40 10 12 Parent Gross Requirements 13 14 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements 15 16 Planned Order Receipts 17 Planned Order Releases 18 20 Part 1 Gross Requirements 21 22 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements 23 24 Planned Order Receipts 25 Planned Order Releases 26 28 Part 2 Gross Requirements 29 Scheduled Receipts 30 Projected On-Hand 31 (at beginning of period) Net Requirements 32 Planned Order Receipts 33 Planned Order Releases 34