Fill Rate Calculation
The following diagram gives a high-level perspective of the processing that takes place to generate fill rates in PAI.
There are two types of Fill Rate in PAI:
When stock amount or demand detail records are not available for a particular date for a SKU:
|
Condition
|
Result
|
|---|---|
|
Stock Amount and Order Plan data are not available, but Demand Detail is available
|
The SKU record is considered and the Actual Fill Rate is calculated.
|
|
Stock Amount or Order Plan data is available
|
The SKU record is considered and the Actual Fill Rate is calculated.
|
|
Demand Detail is not available
|
The SKU record for the date is ignored and the Actual Fill Rate is not calculated.
|
|
Demand Detail is available with zero quantity requested
|
The quantity requested, quantity filled, line requested, and line filled is considered as zero and the Actual Fill Rate is calculated as zero.
|
|
All demand detail, Stock Amount, and Order Plan data is not available
|
The SKU record is ignored and the Actual Fill Rate is not calculated.
|
|
Planned Fill Rate is not available (Null)
|
The Planned Fill Rate is considered as zero.
|
|
No record available in the stock level
|
The SKU record is ignored and the Actual Fill Rate is not calculated.
|
|
Net On Hand for the day is negative and the quantity requested is available
|
The On Hand for the day, Actual Fill Rate, and Quantity Filled are considered as zero.
|
Key Points
• Filter the demand details records based on the streams which are only used in planning.
◦ The fill rate is calculated for external demand only, it is not the total demand, which includes internal demand and external demand
◦ External demand is identified for non bin locations using the External Forecast streams with demand streams that have the Use In Total field set to Y.
• On orders arriving due in past and arriving today are considered available for today’s fill rate calculation.