Calculator inputs
Large: 3 cols · Small: 2 cols · Mobile: 1Choose a primary metric, enter totals, and optionally add SKU rows for a weighted unit fill rate.
Example data table
Use this sample to test the calculator quickly.
| SKU | Ordered | Shipped | Backorder | Fill Rate |
|---|---|---|---|---|
| Gear‑X20 | 1,000 | 980 | 20 | 98.00% |
| Seal‑B11 | 600 | 585 | 15 | 97.50% |
| Valve‑A12 | 400 | 360 | 40 | 90.00% |
| Weighted total | 2,000 | 1,925 | 75 | 96.25% |
Formula used
How to use this calculator
- Pick your primary metric: units, orders, lines, or all.
- Enter totals for orders, lines, and units you track.
- Set a target percent to quantify the performance gap.
- Add SKU rows if you want a weighted unit fill rate.
- Press Calculate Fill Rate to see results above.
- Use the download buttons to export CSV or PDF.
FAQs
1) What does “order fill rate” measure?
It measures the share of orders delivered completely. It ignores partially shipped orders, so it reflects customer‑visible completeness rather than shipped volume.
2) How is unit fill rate different from order fill rate?
Unit fill rate uses quantities shipped versus ordered. Order fill rate uses counts of complete orders. A few missing units can keep an order from being counted as filled.
3) Should partial shipments count as filled?
Usually no, if you want strict completeness. If your operation treats partials as acceptable, track a separate “ship rate” metric to avoid overstating true fill performance.
4) Why does the SKU table use a weighted approach?
Weighting by ordered units prevents small SKUs from skewing results. It matches real demand impact by prioritizing high‑volume items in the overall unit fill rate.
5) What is a good fill rate target?
It depends on lead times, variability, and customer expectations. Many operations aim for 95–98% on stable products, and higher for critical parts. Use service agreements to set targets.
6) How can I reduce backorders shown here?
Reduce variability with better forecasting, improve replenishment timing, and address bottlenecks. Consider safety stock for high‑risk items, and shorten cycle times where possible.
7) Does cancelling orders affect the calculation?
Yes. If you remove cancelled orders from “total orders,” fill rate can rise. Keep a consistent rule: measure fill rate on valid demand only, and track cancellations separately.
8) Can I export results for reporting?
Yes. Use the CSV export for spreadsheets and dashboards. Use the PDF export for sharing a compact summary with stakeholders and attaching to weekly reviews.