Peg distribution - example of gains and losses

Assumptions:

  • The pegs are in the same warehouse.
  • The pegs are for the same item.
  • The peg is a combination of project, element, and activity.
  • The project pegged inventory table is up to date. If not, an update is executed with a loss of one for every step.

The information in the following tables is available in the Project Pegged Inventory (whwmd2560m000) session.

Starting point:

Peg LineProjectElementActivityOn HandInventory GainsInventory LossesExcessATT
1PRO1ELO1ACT0111000
210000
3PRO2ELO2ACT0210010
4PRO3ELO3ACT0310001
5PRO4ELO4ACT0410001
6PRO5ELO5ACT0510000

 

A loss of one results in the removal of peg line 1 as the first gains are decreased.

Peg LineProjectElementActivityOn HandInventory GainsInventory LossesExcessATT
210000
3PRO2ELO2ACT0210010
4PRO3ELO3ACT0310001
5PRO4ELO4ACT0410001
6PRO5ELO5ACT0510000

 

A loss of one results in the removal of peg line 2 as the blank peg is removed.

Peg LineProjectElementActivityOn HandInventory GainsInventory LossesExcessATT
3PRO2ELO2ACT0210010
4PRO3ELO3ACT0310001
5PRO4ELO4ACT0410001
6PRO5ELO5ACT0510000

 

Then a loss of one removes the peg line 3 as an excess quantity exists.

Peg LineProjectElementActivityOn HandInventory GainsInventory LossesExcessATT
4PRO3ELO3ACT0310001
5PRO4ELO4ACT0410001
6PRO5ELO5ACT0510000

 

Then a loss of one removes the peg line 4 as it has ATT and it is alphabetically before line 5.

Peg LineProjectElementActivityOn HandInventory GainsInventory LossesExcessATT
5PRO4ELO4ACT0410001
6PRO5ELO5ACT0510000

 

The next loss removes peg line 5 as it has ATT.

Peg LineProjectElementActivityOn HandInventory GainsInventory LossesExcessATT
6PRO5ELO5ACT0510000

 

The last loss removes peg line 6 which is the last scenario of a decreasing peg inventory.