Fill Rate Calculator

Analyze order, line, and unit fill performance instantly. Compare shipped, requested, backordered, and lost sales. Plan smarter replenishment using accurate ecommerce service metrics today.

Calculator Inputs

Enter requested, shipped, and exception quantities to evaluate service quality across orders, order lines, and units.

Reset

Formula Used

Order Fill Rate (%) = (Orders Shipped Complete ÷ Orders Requested) × 100

Line Fill Rate (%) = (Order Lines Filled ÷ Order Lines Requested) × 100

Unit Fill Rate (%) = (Units Shipped ÷ Units Requested) × 100

Perfect Order Rate (%) = (Perfect Orders ÷ Orders Requested) × 100

Backorder Rate (%) = (Backordered Units ÷ Units Requested) × 100

Cancellation Rate (%) = (Canceled Units ÷ Units Requested) × 100

Short Units = Units Requested − Units Shipped

Estimated Lost Revenue = Short Units × Average Unit Price

Units Needed to Hit Target = ((Target Fill Rate ÷ 100) × Units Requested) − Units Shipped

How to Use This Calculator

  1. Enter total customer orders requested during the review period.
  2. Add how many orders shipped complete without shortages.
  3. Provide requested and filled order lines for line-level analysis.
  4. Enter requested, shipped, backordered, and canceled unit counts.
  5. Add the average unit price to estimate lost revenue exposure.
  6. Set a target fill rate to measure the service gap.
  7. Click Calculate Fill Rate to display results above the form.
  8. Use the CSV or PDF buttons to export the current results.

Example Data Table

Period Orders Requested Orders Shipped Lines Requested Lines Filled Units Requested Units Shipped Backordered Units Perfect Orders
January 1,200 1,110 3,850 3,605 9,800 9,305 355 1,038
February 1,340 1,272 4,120 3,980 10,420 10,115 210 1,205
March 1,410 1,320 4,360 4,080 11,200 10,710 335 1,248

FAQs

1. What does fill rate measure in ecommerce?

Fill rate measures how much customer demand you fulfilled immediately from available stock. It shows whether orders, lines, or units shipped completely without shortages.

2. Why track order, line, and unit fill rates separately?

Each view highlights a different service issue. Order rate shows complete orders, line rate shows item assortment coverage, and unit rate shows total product availability.

3. What is a good fill rate target?

Many ecommerce teams target 95% to 99% depending on product category, margin, and customer promises. Premium or subscription brands often aim higher.

4. Does a high fill rate guarantee customer satisfaction?

No. High fill rate helps, but customers also care about delivery speed, order accuracy, packaging quality, and communication during exceptions.

5. How do backorders affect fill rate?

Backorders reduce immediate fulfillment because demand was not met from available inventory. Rising backorders often signal forecasting or replenishment issues.

6. Can this calculator estimate revenue risk?

Yes. It multiplies short units by average unit price to estimate lost revenue exposure, helping teams prioritize inventory recovery efforts.

7. What causes low fill rates most often?

Common causes include inaccurate forecasts, supplier delays, poor safety stock settings, overselling, warehouse errors, and sudden promotional spikes.

8. How often should fill rate be reviewed?

Review it daily for fast-moving catalogs and weekly for slower assortments. Monthly reporting is useful for strategic trend analysis.

Related Calculators

days of inventory calculatorlost sales calculatorcycle service level calculator

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.