What is Fill Rate Calculator?
▾
Fill rate is a key supply chain service metric that measures the proportion of customer demand that is satisfied from available inventory without backorders or lost sales. A fill rate calculator helps inventory managers, supply chain analysts, and operations teams quantify how well their inventory is meeting demand. There are multiple types of fill rate, each measuring a different dimension of inventory performance. Line fill rate measures the percentage of order lines fulfilled complete on the first shipment. Order fill rate (also called perfect order rate) measures the percentage of orders where all lines are filled completely. Unit fill rate measures the percentage of total units requested that were shipped. Case fill rate — used by grocery and CPG suppliers — measures the percentage of ordered cases actually shipped. Retailers typically require suppliers to maintain 95–98.5% case fill rates, with penalties for failing to meet minimums. Low fill rates result in stockouts, customer dissatisfaction, lost revenue, and in retail, chargebacks. High fill rates require more safety stock and tied-up working capital. The fill rate calculator helps find the optimal balance and also calculates the fill rate improvement needed to meet service level agreements (SLAs). Key inputs include demand history, inventory levels, and lead time variability. Fill rate is distinct from service level (which measures the probability of no stockout during a reorder cycle) but both are used together in safety stock calculations.
DigiCalcs delivers precision-engineered tools for engineers and STEM professionals.
Formula
▾
Unit Fill Rate = (Units Shipped / Units Ordered) × 100
Line Fill Rate = (Order Lines Filled Complete / Total Order Lines) × 100
Order Fill Rate = (Orders Shipped Complete / Total Orders) × 100
Case Fill Rate (CPG) = (Cases Shipped / Cases Ordered) × 100
Fill Rate from Safety Stock: FR = 1 − (Expected Stockout Units per Cycle / Average Demand per Cycle)How to Fill Rate Calculator
▾
- 1Select the fill rate type: unit, line, order, or case fill rate depending on your use case.
- 2Enter total units/lines/orders demanded over the measurement period.
- 3Enter units/lines/orders actually fulfilled completely without backorder.
- 4Divide fulfilled by total demanded and multiply by 100 to get fill rate percentage.
- 5For target-setting: enter your current fill rate and target fill rate, then use the safety stock formula to determine required inventory increase.
- 6For CPG/retail: enter retailer fill rate SLA requirements and calculate penalty exposure for misses.
- 7Review historical fill rate trend — declining fill rate signals inventory or supply chain issues requiring investigation.
Worked Examples
▾
380 units backordered or lost, costing an estimated $11,400 in revenue (at $30 avg order value) and risking customer churn.
Major grocery retailers (Walmart, Kroger, Target) impose 2–3% financial deductions for fill rates below their 98.5% SLA threshold.
144 orders partially shipped, requiring follow-up shipments that add $50–$150 per order in additional freight and handling costs.
Line fill rate analysis with SKU breakdown identifies root cause: the top 3 short-shipped SKUs point to a supplier lead time issue requiring safety stock adjustment.
Real-World Applications
▾
Portfolio managers at asset management firms use Fill Rate Calc to project expected returns across different asset allocations, stress-test portfolios against historical market scenarios, and communicate performance expectations to institutional clients and pension fund trustees.
Individual investors and retirement planners apply Fill Rate Calc to determine whether their current savings rate and investment returns will produce sufficient wealth to fund 25 to 30 years of retirement spending, accounting for inflation and required minimum distributions.
Venture capital and private equity firms use Fill Rate Calc to calculate internal rates of return on fund investments, model exit scenarios for portfolio companies, and benchmark performance against industry standards like the Cambridge Associates index.
Financial advisors use Fill Rate Calc during client reviews to illustrate the compounding benefit of starting early, the impact of fee drag on long-term wealth accumulation, and the trade-off between risk and expected return in diversified portfolios.
Special Cases
▾
Negative or zero return periods
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in fill rate calculator calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
Extremely long time horizons
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in fill rate calculator calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
Lump sum versus periodic contributions
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in fill rate calculator calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
Fill Rate Calc reference data
▾
| Retailer/Industry | Fill Rate SLA | Penalty for Miss | Measurement Period |
|---|---|---|---|
| Walmart (OTIF) | 98.5% | 3% of PO value | Weekly |
| Target | 95% | 2% of PO value | Monthly |
| Amazon Vendor Central | 95% (confirmable) | Lost PO share | Weekly |
| Kroger | 96% | 2.5% deduction | Monthly |
| General B2B SLA | 95–99% | Contractual penalty | Monthly |
Frequently Asked Questions
▾
What is fill rate and how is it calculated?
Fill rate measures the percentage of customer demand that is immediately fulfilled from available stock. Order Fill Rate = (Orders Shipped Complete ÷ Total Orders) × 100. Line Fill Rate = (Order Lines Shipped ÷ Total Order Lines) × 100. Unit Fill Rate = (Units Shipped ÷ Units Ordered) × 100. Each measures something different: 95% unit fill rate might mean only 80% order fill rate if stockouts affect different items across orders. A company shipping 950 of 1,000 ordered units has 95% unit fill rate, but if those 50 missing units span 150 of 500 orders, order fill rate is only 70%.
What is a good fill rate and how do I improve it?
Target fill rates: 95-98% for standard products, 90-95% for slow-moving items, and 98-99.5% for critical/A-items. Higher fill rates require exponentially more safety stock — going from 95% to 99% might double inventory investment. Improvement strategies: better demand forecasting (reduce forecast error by 10%, improve fill rate by 3-5%), ABC analysis (invest safety stock in high-velocity A-items, accept lower fill rates on C-items), reduce supplier lead times, implement vendor-managed inventory for key products, and set reorder points based on demand variability, not just average demand. The cost of a stockout (lost sales, expedited shipping, customer defection) should guide how much inventory investment is justified.
How does fill rate impact customer satisfaction and loyalty?
Fill rate has a significant impact on customer satisfaction and loyalty, as it directly affects the ability to meet customer demand. A high fill rate, such as 95% or higher, indicates that customers are more likely to receive their orders on time and in full, leading to increased satisfaction and loyalty. Conversely, a low fill rate, such as 80% or lower, can lead to stockouts, backorders, and lost sales, resulting in decreased customer satisfaction and loyalty. For example, a study found that a 10% increase in fill rate can lead to a 5% increase in customer satisfaction.
What are some common challenges that can affect fill rate, and how can they be overcome?
Common challenges that can affect fill rate include inventory inaccuracies, supply chain disruptions, and demand variability. To overcome these challenges, inventory managers can implement regular inventory audits to ensure accuracy, diversify their supplier base to mitigate supply chain disruptions, and use demand forecasting techniques, such as exponential smoothing or regression analysis, to better anticipate demand. For instance, a company that experiences seasonal fluctuations in demand can use historical data and statistical models to forecast demand and adjust its inventory levels accordingly, resulting in a fill rate increase from 85% to 92%.
How can fill rate be used in conjunction with other metrics, such as inventory turnover and order fulfillment lead time, to optimize inventory management?
Fill rate can be used in conjunction with other metrics, such as inventory turnover and order fulfillment lead time, to optimize inventory management by providing a more comprehensive view of inventory performance. For example, a company with a high fill rate of 98% but low inventory turnover of 2 may be holding excess inventory, while a company with a lower fill rate of 90% but high inventory turnover of 5 may be experiencing stockouts. By analyzing these metrics together, inventory managers can identify opportunities to optimize inventory levels, reduce costs, and improve customer satisfaction, such as by implementing a just-in-time inventory system or adjusting order fulfillment lead times to better match demand.
Common Mistakes to Avoid
▾
- !
- !
- !
Pro Tip
Implement a 'fill rate dashboard' that shows fill rate by SKU, by customer, and by week. Set automatic alerts when any SKU drops below 95% fill rate — catching individual SKU problems early prevents them from rolling up into SLA violations.
Did you know?
P&G reports that improving fill rate from 95% to 99% typically requires a 40–60% increase in safety stock investment — demonstrating the non-linear relationship between fill rate and inventory costs near perfect service levels.
References
Have a question about this calculator? Get a detailed answer.
Get Weekly Math Tips
Join 12,000+ subscribers who get calculator tips every week.