Salesforce

How is the Order level Delay Days field calculated and what does it represent?

Printable View
« Go Back

Information

 
TitleHow is the Order level Delay Days field calculated and what does it represent?
SummaryExplains how is the Order level Delay Days field calculated and what does it represent
URL NameHowis-the-Order-level-Delay-Days-field-calculated-and-what-does-it-represent
Resolution
The Order Level Delay Days value is an indicator as to whether a Vendor/Source Order line needs to be Accepted in order to protect a weighted average of the Service Level Goals of all the active Items/SKUs in the Vendor/Source.
Valid range is 0 through 5 inclusive:
  • 0 = Order should be placed today or Service may be compromised or further compromised.
  • 1 through 4 = Approximate number of days until the Order will need to be Accepted in order to protect service
  • 5 = Based on current data within AWR/ASR, Service isn’t expected to be in jeopardy if this order is not Accepted for at least 5 days
 
Due Orders without Ordering Restrictions will have a Delay of 0.
Orders that are in the Due category due to Ordering Restrictions such as Order Day in Week may have a Delay value from 0 through 5 based on actual need.
ProductsAdvanced Store Replenishment Client Server; Advanced Store Replenishment GS
Module
VersionAll
Error Message Code
Cause
Additional Information
The Delay is based on a calculation between the expected stock out fields and the specified stock out of all the active Items/SKUs in the Vendor/Source. 
For each active item, the system will calculate:
The Specified Stock Out (ISSO):
 (100 - Service Goal) * 0.1 * Greater of (Effective Order Cycle /buying multiple/minimum quantity) but not gretaer than yearly forecast * Purchase Price
The Expected Stock Out (IESOx):
(Greater (Safety Stock or Presentation stock) + Lead Time) – Balance)* Purchase Price
The system will calculate 6 Expected Stock Out fields. The first represents the IOP, the second is the IOP + 1 day and so on...
 
For each vendor/source order,  you end up with a Specified Stock Out (RSSO)and 6 Expected Stock Outs (RESOx) based on the sum of the item values.
 
How Does It Work?
  • First ESO is greater than the SSO then the order delay will be 0.
  • Second ESO is greater than the SSO then the order delay will be 0.
  • Third ESO is greater than the SSO then the order delay will be 1.
  • Fourth ESO is greater than the SSO then the order delay will be 2.
  • Fifth ESO is greater than the SSO then the order delay will be 3.
  • Sixth ESO is greater than the SSO then the order delay will be 4.
  • Otherwise the order delay will be 5.
Publication StatusPublished
Powered by