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 |
I need help with these because I thought I got them right, but my answers were wrong (included in parenthesis)
1. Average Inventory for AB501 =___________units **(answer is NOT 180)**
2. Average Inventory for AB511 =___________units **(answer is NOT 234)**
3. Average Inventory for AB521 =__________ units**(answer is NOT 261)**
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
