please show all work in excel and take a screenshot, NEED PLANNED INVETORY RELEASES

Regular Deluxe 7 Part A Part B Part C Part D 5 7 10 3 Part A Part B Part C Part D Part E 3 13 Part A Part D Part F Part G 3 7 3 Part F Part 1 12 3 Part B Part E 6 4 Part F Part H 25 Part F Part 6 Part 1 9 10 Part Part 1 5 Part G Part H Part 1 12 10 5 Regular Deluxe Part A Part B Part C Part D Part E Part F Part G Part 1 Part 1 Yield 94% 96% 83% 92% 73% 99% 94% 82% 80% 93% 94% Finite Capacity 250 225 1200 700 500 400 900 5000 2000 3500 1500 1 2 3 4 4 s 5 7 8 10 MPS Regular Deluxe 6 300 300 300 9 300 250 300 11 300 250 12 300 250 250 250 250 300 300 300 300 Inventory Status Record for Regular LT = 1 week Gross Requirements Scheduled Receipts On Hand (500) Net Requirements Planned Order Releases 100 600 300 100 500 100 700 100 300 100 0 100 1100 600 700 200 0 0 900 0 300 1 2 3 3 4 5 6 7 8 8 9 10 11 12 250 250 250 250 250 Inventory Status Record for Deluxe LT = 2 weeks Gross Requirements Scheduled Receipts On Hand (70) Net Requirements Planned Order Releases 300 370 70 70 370 370 120 0 370 0 130 250 0 250 250 0 250 250 250 130 250 5 5 7 8 10 11 12 3 Inventory Status Record for Part A LT = 2 weeks Gross Requirements Schedule 500 500 500 On Hand (50) Net Requirements Planned Order Releases 500 500 500 500 500 500 500 4 5 5 6 7 8 9 9 10 11 12 3 Inventory Status Record for Part B LT = 3 weeks Gross Requirements Scheduled Receipts 200 On Hand (100) Net Requirements Planned Order Releases 900 0 2200 4000 1500 2000 2800 4 5 6 7 8 9 10 11 12 2 3 Inventory Status Record for Part C LT = 1 weeks Gross Requirements Scheduled Receipts 500 On Hand (500) Net Requirements Planned Order Releases 500 100 3000 4000 3500 4000 4000 4 5 6 7 8 9 10 11 12 3 Inventory Status Record for Part D LT = 2 weeks Gross Requirements Scheduled Receipts 500 On Hand (50) Net Requirements Planned Order Releases 500 100 1000 2000 200 N 4 5 6 7 8 9 9 10 11 12 1000 1000 3000 1000 2000 2000 4 5 6 7 8 mn 9 10 11 12 5000 10000 15000 15000 15000 2 3 Inventory Status Record for Part E LT - 2 weeks Gross Requirements Scheduled Receipts 500 On Hand (50) Net Requirements Planned Order Releases 3 Inventory Status Record for Part F LT = 1 weeks Gross Requirements Scheduled Receipts 5000 5000 On Hand (3000) Net Requirements Planned Order Releases 1 2 3 Inventory Status Record for Part LT = 2 weeks Gross Requirements Scheduled Receipts 5000 On Hand (6000) Net Requirements Planned Order Releases 2 3 Inventory Status Record for Part H LT = 1 weeks Gross Requirements Scheduled Receipts 500 On Hand (20000) Net Requirements Planned Order Releases 4 5 6 7 00 10 11 12 15000 20000 20000 20000 20000 20000 4 5 6 7 8 10 11 12 28000 20000 28000 28000 20000 3 5 7 8 9 10 11 12 1 2 Inventory Status Record for Part 1 LT = 1 weeks Gross Requirements Scheduled Receipts 500 On Hand (50) Net Requirements Planned Order Releases 7000 7000 7000 7000 7000 7000 Regular Deluxe 7 Part A Part B Part C Part D 5 7 10 3 Part A Part B Part C Part D Part E 3 13 Part A Part D Part F Part G 3 7 3 Part F Part 1 12 3 Part B Part E 6 4 Part F Part H 25 Part F Part 6 Part 1 9 10 Part Part 1 5 Part G Part H Part 1 12 10 5 Regular Deluxe Part A Part B Part C Part D Part E Part F Part G Part 1 Part 1 Yield 94% 96% 83% 92% 73% 99% 94% 82% 80% 93% 94% Finite Capacity 250 225 1200 700 500 400 900 5000 2000 3500 1500 1 2 3 4 4 s 5 7 8 10 MPS Regular Deluxe 6 300 300 300 9 300 250 300 11 300 250 12 300 250 250 250 250 300 300 300 300 Inventory Status Record for Regular LT = 1 week Gross Requirements Scheduled Receipts On Hand (500) Net Requirements Planned Order Releases 100 600 300 100 500 100 700 100 300 100 0 100 1100 600 700 200 0 0 900 0 300 1 2 3 3 4 5 6 7 8 8 9 10 11 12 250 250 250 250 250 Inventory Status Record for Deluxe LT = 2 weeks Gross Requirements Scheduled Receipts On Hand (70) Net Requirements Planned Order Releases 300 370 70 70 370 370 120 0 370 0 130 250 0 250 250 0 250 250 250 130 250 5 5 7 8 10 11 12 3 Inventory Status Record for Part A LT = 2 weeks Gross Requirements Schedule 500 500 500 On Hand (50) Net Requirements Planned Order Releases 500 500 500 500 500 500 500 4 5 5 6 7 8 9 9 10 11 12 3 Inventory Status Record for Part B LT = 3 weeks Gross Requirements Scheduled Receipts 200 On Hand (100) Net Requirements Planned Order Releases 900 0 2200 4000 1500 2000 2800 4 5 6 7 8 9 10 11 12 2 3 Inventory Status Record for Part C LT = 1 weeks Gross Requirements Scheduled Receipts 500 On Hand (500) Net Requirements Planned Order Releases 500 100 3000 4000 3500 4000 4000 4 5 6 7 8 9 10 11 12 3 Inventory Status Record for Part D LT = 2 weeks Gross Requirements Scheduled Receipts 500 On Hand (50) Net Requirements Planned Order Releases 500 100 1000 2000 200 N 4 5 6 7 8 9 9 10 11 12 1000 1000 3000 1000 2000 2000 4 5 6 7 8 mn 9 10 11 12 5000 10000 15000 15000 15000 2 3 Inventory Status Record for Part E LT - 2 weeks Gross Requirements Scheduled Receipts 500 On Hand (50) Net Requirements Planned Order Releases 3 Inventory Status Record for Part F LT = 1 weeks Gross Requirements Scheduled Receipts 5000 5000 On Hand (3000) Net Requirements Planned Order Releases 1 2 3 Inventory Status Record for Part LT = 2 weeks Gross Requirements Scheduled Receipts 5000 On Hand (6000) Net Requirements Planned Order Releases 2 3 Inventory Status Record for Part H LT = 1 weeks Gross Requirements Scheduled Receipts 500 On Hand (20000) Net Requirements Planned Order Releases 4 5 6 7 00 10 11 12 15000 20000 20000 20000 20000 20000 4 5 6 7 8 10 11 12 28000 20000 28000 28000 20000 3 5 7 8 9 10 11 12 1 2 Inventory Status Record for Part 1 LT = 1 weeks Gross Requirements Scheduled Receipts 500 On Hand (50) Net Requirements Planned Order Releases 7000 7000 7000 7000 7000 7000