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. |