Question: All the information is provided. Question 1 Question 2 Fill in the partially completed inventory record shown here. Put the answers down into the table
All the information is provided.
Question 1


Question 2
Fill in the partially completed inventory record shown here.
Put the answers down into the table (If answer is zero, please enter 0, do not leave any fields blank):
| Item: AB500 | | Parent: None |
| Lot Size Rule: L4L | | Children: AB501, AB511, AB521 |
| Lead Time: 2 week | | | | | | | | | | |
| |
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Gross Requirements | 0 | 0 | 85 | 170 | 85 | 170 | 85 | 170 | 85 | 170 |
| Scheduled Receipts | | | | | | | | | | |
| Projected Available 0 | | | | | | | | | | |
| Planned Orders | | | | | | | | | | |
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 Lot Size Rule: L4L Lead Usage Factor: 2 Beginning Invertory: 4,000 2 3 4 5 6 7 8 9 10 1,600 800 1,600 800 800 0 0 Time(weeks): 2 Week 1 Gross Requirements 800 Scheduled Receipts 0 Projected Available 4,000 3,200 Planned Orders 0 1,600 1,600 1,600 1,600 0 0 800 800 800 0 0 1,600 800 0 0 0 0 0 0 0 800 800 1,600 800 1,600 0 0 0 0 Product: AB511 Lot Size Rule:FOQ=1,200 Lead Usage Factor: 1 Beginning Invertory: 2,600 Time(weeks): 3 2 3 4 5 6 7 8 800 400 800 400 800 400 800 Week 1 Gross Requirements 400 Scheduled Receipts 0 Projected Available 2,600 2,200 Planned Orders 0 0 0 0 1.200 0 0 1,200 1,000 a O OOO OOOOO 1,400 200 1,000 200 200 1,000 1,200 0 0 1,200 0 0 0 Product: AB521 Lot Size Rule: POQ=2 Lead Usage Factor: 2 Beginning Invertory: 2,600 Timelweeks): 2 Week 1 2 3 4 5 6 7 7 8 9 1,600 800 800 1,600 0 1,600 0 0 0 0 Gross Requirements 800 Scheduled Receipts 0 Projected Available 2,600 1,800 Planned Orders 2,200 1,600 800 0 2,200 200 1,600 0 2,400 2,400 1,600 2,400 0 2 2,400 1,600 O 0 0 0 0 o 0 0 0 Average Inventory for AB501 = units Average Inventory for AB511 = units Average Inventory for AB521 = units