Hello, I was given a problem for my Supply Chain Management class and it is as follows:

1. Compute the planned order releases and projected on-hand inventory balances for parts A and D for periods 1 through 6 inclusive.

2. Compute the Gross requirements, planned order releases and projected on- hand inventory balances for parts E and F for periods 1 through 6 inclusive.

Part B Inventory 25 Part A Gross Requirements Scheduled Receipts Projected On-hand Inventory 225 Planned Order Releases Q=600; LT=1; SS=0 1 450 250 PartA Inventory-225 Part C Inventory 50 Part 0 Inventory 350 (9) Part E Inventory-300 (1) 2 3 4 625 570 480 505 575 Part F Inventory-1600 (21 Part D Gross Requirements Scheduled Receipts Projected On-hand Inventory 350 Planned Order Releases Q=LFL;LT=1; SS=25 Part E Gross Requirements Scheduled Receipts Projected On-hand Inventory 300 Planned Order Releases Q=150; LT=1; SS=0 Part F Gross Requirements Scheduled Receipts Projected On-hand Inventory 1600 Planned Order Releases Q-LFL; LT-2; SS-50 1 2 600 600 600 600 275 12 380 1 2 3 4 5 600 850 3 4 5 6 0 325 6 3 4 5 6 Part B Inventory 25 Part A Gross Requirements Scheduled Receipts Projected On-hand Inventory 225 Planned Order Releases Q=600; LT=1; SS=0 1 450 250 PartA Inventory-225 Part C Inventory 50 Part 0 Inventory 350 (9) Part E Inventory-300 (1) 2 3 4 625 570 480 505 575 Part F Inventory-1600 (21 Part D Gross Requirements Scheduled Receipts Projected On-hand Inventory 350 Planned Order Releases Q=LFL;LT=1; SS=25 Part E Gross Requirements Scheduled Receipts Projected On-hand Inventory 300 Planned Order Releases Q=150; LT=1; SS=0 Part F Gross Requirements Scheduled Receipts Projected On-hand Inventory 1600 Planned Order Releases Q-LFL; LT-2; SS-50 1 2 600 600 600 600 275 12 380 1 2 3 4 5 600 850 3 4 5 6 0 325 6 3 4 5 6