Please help me solve this excel sheet as the instructor did not attach any instruction to this sheet to complete. Screenshot is attached, please zoom in. BOM SHOULD be clear if zoom in.

they are the same chart split in two for visibility. So please line up and show formulas.

Hem 500 LT= 1 ks Part 50TZI Part 2) Part 50313 Part 5042) LT = 2 ks LT = 1 w LT=3 wks LT= 2 wks Part 81262) Part 8133) LT = 2 ks LT=1 wks Item 500 Period 0 1 2 5 6 7 9 10 250 250 250 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time Part: 501 Lot size Safesteck Period 6 2 3 5 10 500 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = Part: 502 2 Lot size 1000 0 Safe stock Period 0 1 2 4 5 6 7 10 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = Part: 503 Lot size Safety stock Period 1 2 5 6 7 10 800 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = Part: 504 Lot size 1500 Safety steck Period 0 2 3 6 10 Gross requirements Scheduled receipts Projected on hand Planned order releases 500 Lot se 2000 Safestes 0 Lead time Part: 812 Period 2 5 6 10 Gross requirements Scheduled receipts Projected on hand Planned order releases 500 2. Lot se Lead time Part: 813 Safesteck Period 0 2 5 6 7 10 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time 1500 Lot size Saft stock 6 0 1 2 4 5 7 10 ITEM 500 PART 501 PART 502 PART 503 PART 504 PART 812 PART 813