Viewing Days of Supply

In the Item Summary grid, you can view the number of days that the supply for an item/branch will cover the demand for the item/branch. The system displays the following days of supply fields:

  • Inventory On Hand

  • Days Until 1st Receipt

  • Days Until 2nd Receipt

  • Days of Supply Current

  • Days of Supply After 1st Receipt

  • Days of Supply After 2nd Receipt

Based on whether past due supply is included in or excluded from the on-hand quantity, the number of days of supply until the first and second receipt of material can be a negative value or a positive value. Set the Past Due Supply Quantity processing option for the Planning Console program (P34X200) to 1 to include past due supply in the on-hand quantity.

See Setting Processing Options for the Planning Console Program (P34X200).

This table describes the calculation for the days of supply fields:

Field

Calculation

Inventory On Hand

The system calculates the starting balance as on-hand quantity minus the past due demand.

Days of Supply Current

The system calculates the number of days until the stock level for the item/branch falls below 0. For the calculation, the system considers total demand (independent and dependent) for firm (not planned) demand. The starting on-hand quantity is the on-hand quantity after applying the P34X200 processing options to include in/exclude from on-hand inventory, and this value is retrieved from the Item Summary Work Table table (F34X101W). Demand is aggregated by date and deducted from the starting on-hand quantity until the stock level falls below 0. The system displays a negative value as 0.

Days Until 1st Receipt

The system calculates the number of days from the Start Date until the first receipt of material.

If past due supply is included in the on-hand quantity, this field can have a negative value. If past due supply is not included in the on-hand quantity, this field has a positive value.

Days Until 2nd Receipt

The system calculates the number of days from the Start Date until the second receipt of material.

If past due supply is included in the on-hand quantity, this field can have a negative value. If past due supply is not included in the on-hand quantity, this field has a positive value.

Days After 1st Receipt

The system calculates the number of days until the stock level for the item/branch falls below 0. For the calculation, the system considers total demand (independent and dependent) for firm (not planned) demand. The starting on-hand quantity is the on-hand quantity after applying the P34X200 processing options to include in/exclude from on-hand inventory. For the first receipt, supply is aggregated by date and added to the on-hand quantity on the date of the first receipt. Demand is aggregated by date and deducted from the supply until the stock level falls below 0.

If past due supply is included in the on-hand quantity, the system considers supply records with a date less than the planning horizon start date in the starting balance. If past due supply is excluded from the on-hand quantity, the system ignores supply records with a date less than the planning horizon start date.

Days After 2nd Receipt

The system calculates the number of days until the stock level for the item/branch falls below 0. For the calculation, the system considers total demand (independent and dependent) for firm (not planned) demand. The starting on-hand quantity is the on-hand quantity after applying the P34X200 processing options to include in/exclude from on-hand inventory. For the second receipt, supply is aggregated by date and added to the current supply on the date of the second receipt. Demand is aggregated by date and deducted from the supply until the stock level falls below 0.

If past due supply is included in the on-hand quantity, the system considers supply records with a date less than the planning horizon start date in the starting balance. If past due supply is excluded from the on-hand quantity, the system ignores supply records with a date less than the planning horizon start date.

This table describes the icons that the system displays in the Days Until 1st Receipt and Days Until 2nd Receipt fields:

Icon

Description

Red square

The number of days until the first or second receipt of material is greater than the current days of supply.

Yellow triangle

The number of days until the first or second receipt of material is equal to the current days of supply.

Green circle

The number of days until the first or second receipt of material is less than the current days of supply.

Red X

No receipt exists for the planning horizon.

This table describes the icons that the system displays in the Inventory On Hand field:

Icon

Description

Green circle

The starting on-hand quantity is greater than or equal to 0.

Red square

The starting on-hand quantity is less than 0.