Using the inventory records completed, calculate the average inventory level of AB501, AB511, AB521. Assume that the remaining inventory after the gross requirements are satisfied, is used in another production cycle. Product: AB501 Lead Usage Factor: 2 Lot Size Rule: L4L Beginning Invertory: 4,000 Time(weeks): 2 Week 1 2 3 4 5 6 7 9 10 Gross Requirements 800 1,600 800 1,600 800 1,600 800 1,600 0 Scheduled Receipts 0 0 0 800 800 1,600 800 1,600 0 0 Projected Available 4,000 3,200 1,600 800 O O 0 0 o 0 Planned Orders 800 800 1,600 800 1,600 0 0 0 Product: AB511 Lead Usage Factor: 1 Lot Size Rule: FOQ=1,200 Beginning Invertory: 2,600 Time(weeks): 3 Week 1 1 N 3 4 5 6 8 9 10 Gross Requirements 400 800 400 800 400 800 400 800 0 0 Scheduled Receipts 0 0 0 0 1,200 0 1,200 0 0 0 Projected Available 2,600 2,200 1,400 1,000 200 1,000 200 1,000 200 0 0 Planned Orders 0 1,200 0 1,200 0 0 0 O 0 Product: AB521 Lead Usage Factor: 2 Lot Size Rule: POQ=2 Beginning Invertory: 2,600 Time(weeks): 2 Week 1 2 3 4 5 6 7 8 9 10 Gross Requirements 800 1,600 800 1,600 800 1,600 800 1,600 0 0 Scheduled Receipts 0 2,200 O 2,400 O 2,400 o d O Scheduled Receipts 0 0 2,200 0 2,400 0 2,400 0 0 0 Projected Available 2,600 1,800 200 1,600 0 1,600 0 1,600 0 0 0 Planned Orders 2,200 0 2,400 0 2,400 0 0 0 0 0 Average Inventory for AB501 = units Average Inventory for AB511 = units Average Inventory for AB521 = units