Question: 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,
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: 1,800 |
| Time(weeks): 2 | ||||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Gross Requirements | 360 | 720 | 360 | 720 | 360 | 720 | 360 | 720 | 0 | 0 |
| Scheduled Receipts | 0 | 0 | 0 | 360 | 360 | 720 | 360 | 720 | 0 | 0 |
| Projected Available 1,800 | 1,440 | 720 | 360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Planned Orders | 0 | 360 | 360 | 720 | 360 | 720 | 0 | 0 | 0 | 0 |
| Product: AB511 | Lead Usage Factor: 1 | |
| Lot Size Rule: FOQ=540 | Beginning Invertory: 1,170 |
| Time(weeks): 3 | ||||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Gross Requirements | 180 | 360 | 180 | 360 | 180 | 360 | 180 | 360 | 0 | 0 |
| Scheduled Receipts | 0 | 0 | 0 | 0 | 540 | 0 | 540 | 0 | 0 | 0 |
| Projected Available 1,170 | 990 | 630 | 450 | 90 | 450 | 90 | 450 | 90 | 0 | 0 |
| Planned Orders | 0 | 0 | 540 | 0 | 540 | 0 | 0 | 0 | 0 | 0 |
| Product: AB521 | Lead Usage Factor: 2 | |
| Lot Size Rule: POQ=2 | Beginning Invertory: 1,170 |
| Time(weeks): 2 | ||||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Gross Requirements | 360 | 720 | 360 | 720 | 360 | 720 | 360 | 720 | 0 | 0 |
| Scheduled Receipts | 0 | 0 | 990 | 0 | 1,080 | 0 | 1,080 | 0 | 0 | 0 |
| Projected Available 1,170 | 810 | 90 | 720 | 0 | 720 | 0 | 720 | 0 | 0 | 0 |
| Planned Orders | 990 | 0 | 1,080 | 0 | 1,080 | 0 | 0 | 0 | 0 | 0 |
Average Inventory for AB501 = _______ units
Average Inventory for AB511 = _______ units
Average Inventory for AB521 = ________ units
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
