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: 2,800

Time(weeks): 2

Week

1

2

3

4

5

6

7

8

9

10

Gross Requirements

560

1,120

560

1,120

560

1,120

560

1,120

0

0

Scheduled Receipts

0

0

0

560

560

1,120

560

1,120

0

0

Projected Available 2,800

2,240

1,120

560

0

0

0

0

0

0

0

Planned Orders

0

560

560

1,120

560

1,120

0

0

0

0

Product: AB511

Lead Usage Factor: 1

Lot Size Rule: FOQ=840

Beginning Invertory: 1,820

Time(weeks): 3

Week

1

2

3

4

5

6

7

8

9

10

Gross Requirements

280

560

280

560

280

560

280

560

0

0

Scheduled Receipts

0

0

0

0

840

0

840

0

0

0

Projected Available 1,820

1,540

980

700

140

700

140

700

140

0

0

Planned Orders

0

0

840

0

840

0

0

0

0

0

Product: AB521

Lead Usage Factor: 2

Lot Size Rule: POQ=2

Beginning Invertory: 1,820

Time(weeks): 2

Week

1

2

3

4

5

6

7

8

9

10

Gross Requirements

560

1,120

560

1,120

560

1,120

560

1,120

0

0

Scheduled Receipts

0

0

1,540

0

1,680

0

1,680

0

0

0

Projected Available 1,820

1,260

140

1,120

0

1,120

0

1,120

0

0

0

Planned Orders

1,540

0

1,680

0

1,680

0

0

0

0

0

Average inventory for AB501= ??????

Average inventory for AB511= ?????

Average inventory for AB521= ?????

Please show work. Thank you.

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!