Examples of Replenishment Orders for Different Policy Types

This topic explains how replenishment orders are calculated for different policy types.

Min-Max Planning

The following is how a replenishment order is calculated for the min-max policy type:

  • When the Beginning Inventory Position measure (the sum of the Projected Available Balance and On Order measures) equals or falls below the minimum quantity, a replenishment order is triggered.

  • The quantity of the replenishment order is what's required to bring the inventory up to the maximum quantity (provided by Maximum Quantity - Beginning Inventory Position).

Consider the example in the following table:

Measure

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

Day 8

Day 9

Day 10

Day 11

Day 12

Total Demand

10

15

5

15

20

10

15

10

20

15

10

10

Final Minimum Quantity

50

50

50

50

50

50

50

50

50

50

50

50

Final Maximum Quantity

100

100

100

100

100

100

100

100

100

100

100

100

On Hand

25

0

0

0

0

0

0

0

0

0

0

0

Purchase Orders

0

10

0

0

0

0

0

0

0

0

0

0

Total Supply

25

10

0

75

0

0

0

55

0

0

0

55

Projected Available Balance

15

10

5

65

45

35

20

65

45

30

20

65

On Order

10

75

75

0

0

55

55

0

0

55

55

0

Beginning Inventory Position

25

85

80

65

45

90

75

65

45

85

75

65

Planned Replenishments by Order Date

75

0

0

0

55

0

0

0

55

0

0

0

Planned Replenishments by Due Date

0

0

0

75

0

0

0

55

0

0

0

55

Final Inventory Position

100

85

80

65

100

90

75

65

100

85

75

65

The Beginning Inventory Position measure is evaluated every day. On Day 1, the Beginning Inventory Position measure is 25 units, which is less than the Final Minimum Quantity measure of 50 units. Therefore, a replenishment order of 75 units is created (Final Maximum Quantity - Beginning Inventory Position). The order date is Day 1, and the item lead time is 3 days. Therefore, the Planned Replenishments by Due Date measure is updated for Day 4, while the On Order measure reflects 75 units on Days 2 and 3. On Day 4, the order is received in the inventory, and the Total Supply measure is updated.

The sequence is repeated on Days 5 and 9.

Fixed Order Cycle

The following is how a replenishment order is calculated for the fixed order cycle policy type:

  • The replenishment orders are placed on only the open days defined in the associated fixed order cycle calendar.

  • When the Beginning Inventory Position measure (the sum of the Projected Available Balance and On Order measures) falls below the maximum quantity, a replenishment order is triggered.

  • The quantity of the replenishment order is what's required to bring the inventory up to the maximum quantity (provided by Maximum Quantity - Beginning Inventory Position).

Consider the example in the following table:

Measure

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

Day 8

Day 9

Day 10

Day 11

Day 12

Total Demand

10

15

5

15

20

10

15

10

20

15

10

10

Final Maximum Quantity

100

100

100

100

100

100

100

100

100

100

100

100

On Hand

25

0

0

0

0

0

0

0

0

0

0

0

Purchase Orders

0

10

0

0

0

0

0

0

0

0

0

0

Total Supply

25

10

0

75

0

0

0

0

0

0

90

0

Projected Available Balance

15

10

5

65

45

35

20

10

- 10

-25

55

45

On Order

10

75

75

0

0

0

0

0

90

90

0

0

Beginning Inventory Position

25

85

80

65

45

35

20

10

80

65

55

45

Planned Replenishments by Order Date

75

0

0

0

0

0

0

90

0

0

0

0

Planned Replenishments by Due Date

0

0

0

75

0

0

0

0

0

0

90

0

Final Inventory Position

100

85

80

65

45

35

20

100

80

65

55

45

The associated fixed order cycle calendar is open on only Days 1 and 8.

On Day 1, the Beginning Inventory Position measure is 25 units, which is less than the Final Maximum Quantity measure of 100 units. Therefore, a replenishment order of 75 units is placed (Final Maximum Quantity - Beginning Inventory Position). The order date is Day 1, and the item lead time is 3 days. Therefore, the Planned Replenishments by Due Date measure is updated for Day 4, while the On Order measure reflects 75 units on Days 2 and 3. On Day 4, the order is received in the inventory, and the Total Supply measure is updated.

The sequence is repeated on Day 8.

ROP and Order Quantity

The following is how a replenishment order is calculated for the reorder point (ROP) and order quantity policy type:

  • When Beginning Inventory Position measure (the sum of the Projected Available Balance and On Order measures) equals or falls below the ROP, a replenishment order is triggered.

  • The quantity of the replenishment order is the order quantity.

  • If the fixed order quantity isn't defined in the Items table or the default order quantity isn't defined at the segment level in the policy assignment set, replenishment orders are created to bring the inventory to the ROP level.

Consider the example in the following table:

Measure

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

Day 8

Day 9

Day 10

Day 11

Day 12

Total Demand

10

15

5

15

20

10

15

10

40

15

10

10

Final ROP Quantity

50

50

50

50

50

50

50

50

50

50

50

50

On Hand

25

0

0

0

0

0

0

0

0

0

0

0

Purchase Orders

0

10

0

0

0

0

0

0

0

0

0

0

Total Supply

25

10

0

75

0

0

0

75

0

0

0

75

Projected Available Balance

15

10

5

65

45

35

20

85

45

30

20

85

On Order

10

75

75

0

0

75

75

0

0

75

75

0

Beginning Inventory Position

25

85

80

65

45

110

95

85

45

105

95

85

Planned Replenishments by Order Date

75

0

0

0

75

0

0

0

75

0

0

0

Planned Replenishments by Due Date

0

0

0

75

0

0

0

75

0

0

0

75

Final Inventory Position

100

85

80

65

120

110

95

85

120

105

95

85

The order quantity is 75 units, and the Beginning Inventory Position measure is evaluated every day.

On Day 1, the Beginning Inventory Position measure is 25 units, which is less than the Final ROP Quantity measure of 50 units. Therefore, a replenishment order of 75 units (the order quantity) is placed. The order date is Day 1, and the item lead time is 3 days. Therefore, the Planned Replenishments by Due Date measure is updated for Day 4, while the On Order measure reflects 75 units on Days 2 and 3. On Day 4, the order is received in the inventory, and the Total Supply measure is updated.

The sequence is repeated on Days 5 and 9.

ROP and EOQ

The following is how a replenishment order is calculated for the ROP and economic order quantity (EOQ) policy type:

  • When the Beginning Inventory Position measure (the sum of the Projected Available Balance and On Order measures) equals or falls below the ROP, a replenishment order is triggered.

  • The quantity of the replenishment order is the EOQ.

  • If the EOQ can't be calculated at the item-location level or the default EOQ isn't defined at the segment level in the policy assignment set, replenishment orders are created to bring the inventory to the ROP level.

Consider the example in the following table:

Measure

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

Day 8

Day 9

Day 10

Day 11

Day 12

Total Demand

10

15

5

15

20

10

15

10

40

15

10

10

Final ROP Quantity

50

50

50

50

50

50

50

50

50

50

50

50

On Hand

25

0

0

0

0

0

0

0

0

0

0

0

Purchase Orders

0

10

0

0

0

0

0

0

0

0

0

0

Total Supply

25

10

0

75

0

0

0

75

0

0

0

75

Projected Available Balance

15

10

5

65

45

35

20

85

45

30

20

85

On Order

10

75

75

0

0

75

75

0

0

75

75

0

Beginning Inventory Position

25

85

80

65

45

110

95

85

45

105

95

85

Planned Replenishments by Order Date

75

0

0

0

75

0

0

0

75

0

0

0

Planned Replenishments by Due Date

0

0

0

75

0

0

0

75

0

0

0

75

Final Inventory Position

100

85

80

65

120

110

95

85

120

105

95

85

The EOQ is 75 units, and the Beginning Inventory Position measure is evaluated every day.

On Day 1, the Beginning Inventory Position measure is 25 units, which is less than the Final ROP Quantity measure of 50 units. Therefore, a replenishment order of 75 units (the EOQ) is placed. The order date is Day 1, and the item lead time is 3 days. Therefore, the Planned Replenishments by Due Date measure is updated for Day 4, while the On Order measure reflects 75 units on Days 2 and 3. On Day 4, the order is received in the inventory, and the Total Supply measure is updated.

The sequence is repeated on Days 5 and 9.