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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!