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,600
Time(weeks): 2
Week

1

2

3

4

5

6

7

8

9

10

Gross Requirements

320 640 320 640 320 640 320 640 0 0

Scheduled Receipts

0 0 0 320 320 640 320 640 0 0

Projected Available 1,600

1,280 640 320 0 0 0 0 0 0 0

Planned Orders

0 320 320 640 320 640 0 0 0 0
Product: AB511 Lead Usage Factor: 1
Lot Size Rule: FOQ=480 Beginning Invertory: 1,040
Time(weeks): 3
Week

1

2

3

4

5

6

7

8

9

10

Gross Requirements 160 320 160 320 160 320 160 320 0 0
Scheduled Receipts 0 0 0 0 480 0 480 0 0 0
Projected Available 1,040 880 560 400 80 400 80 400 80 0 0
Planned Orders 0 0 480 0 480 0 0 0 0 0

Product: AB521 Lead Usage Factor: 2
Lot Size Rule: POQ=2 Beginning Invertory: 1,040
Time(weeks): 2
Week

1

2

3

4

5

6

7

8

9

10

Gross Requirements 320 640 320 640 320 640 320 640 0 0
Scheduled Receipts 0 0 880 0 960 0 960 0 0 0
Projected Available 1,040 720 80 640 0 640 0 640 0 0 0
Planned Orders 880 0 960 0 960 0 0 0 0 0

Average Inventory for AB501 = enter the average inventory in units units

Average Inventory for AB511 = enter the average inventory in units units

Average Inventory for AB521 = enter the average inventory in units units

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!