# Distribution ERP Fill Rate Calculator > Source: https://netray.co/tools/distribution-erp-fill-rate-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Calculate line, unit and complete-order fill rate from your ERP counts and see the revenue and gross margin put at risk by unfilled lines. ## Category supply-chain ## Industry Wholesale Distribution ## Audience - Operations manager - Inventory manager - Customer service manager ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Orders received **Key:** orders_total **Type:** number **Default:** 1850 **Min:** 0 **Step:** 10 **Unit:** orders #### Orders shipped complete **Key:** orders_complete **Type:** number **Default:** 1590 **Min:** 0 **Step:** 10 **Unit:** orders **Help:** All lines shipped in full on the first shipment. #### Order lines requested **Key:** lines_total **Type:** number **Default:** 9400 **Min:** 0 **Step:** 50 **Unit:** lines #### Lines filled in full **Key:** lines_complete **Type:** number **Default:** 8650 **Min:** 0 **Step:** 50 **Unit:** lines #### Units ordered **Key:** units_ordered **Type:** number **Default:** 61200 **Min:** 0 **Step:** 100 **Unit:** units #### Units shipped on time **Key:** units_shipped **Type:** number **Default:** 57400 **Min:** 0 **Step:** 100 **Unit:** units #### Average line value **Key:** avg_line **Type:** number **Default:** 185 **Min:** 0 **Step:** 5 **Unit:** $ #### Short lines that cancel **Key:** cancel_pct **Type:** slider **Default:** 20 **Min:** 0 **Max:** 100 **Step:** 5 **Unit:** % **Help:** Share of unfilled lines the customer buys elsewhere instead of waiting. #### Gross margin **Key:** gm_pct **Type:** number **Default:** 27 **Min:** 0 **Max:** 90 **Step:** 1 **Unit:** % **Outputs:** #### Complete order fill rate **Key:** order_fill **Expr:** orders_complete / max(orders_total, 1) * 100 **Format:** percent **Description:** Share of orders that shipped fully on the first shipment. #### Line fill rate **Key:** line_fill **Expr:** lines_complete / max(lines_total, 1) * 100 **Format:** percent **Primary:** true #### Unit fill rate **Key:** unit_fill **Expr:** units_shipped / max(units_ordered, 1) * 100 **Format:** percent #### Short lines **Key:** short_lines **Expr:** max(lines_total - lines_complete, 0) **Format:** integer #### Revenue lost to cancelled short lines **Key:** rev_risk **Expr:** short_lines * avg_line * cancel_pct / 100 **Format:** currency #### Gross margin lost **Key:** gm_risk **Expr:** rev_risk * gm_pct / 100 **Format:** currency **Primary:** true **Description:** Margin you do not earn because the customer bought the short line elsewhere. **Chart:** #### Margin lost vs share of short lines that cancel **Type:** line **X:** cancel_pct **From:** 0 **To:** 100 **Steps:** 20 **Series:** - gm_risk **Disclaimer:** Results depend on how you define a complete fill, the time window and whether backorders and substitutions are counted. Use the same definition every month so the trend is meaningful. ## Content **Intro:** Fill rate is the number customers feel, yet distributors measure it three different ways and argue about which one is right. This calculator computes line, unit and complete-order fill from plain counts you can pull from Prophet 21, Eclipse or any ERP, and prices the shortfall in margin terms. **Sections:** #### How to use it **Body:** Pull counts for one period, such as a month, from your sales order and shipment data. You need the number of orders, how many shipped complete, the number of lines, how many were filled in full, and units ordered versus units shipped. Add an average line value, your gross margin and an estimate of how many short lines the customer cancels rather than waits for. The result shows each fill measure and the margin lost. Run it per branch or per vendor line to find the weak spots. #### Three ways to measure fill **Body:** Line fill rate counts the share of order lines shipped in full. Unit fill rate counts the share of units shipped. Complete order fill rate counts the share of orders where every line shipped. Order fill is always the harshest, since one short line fails the order, and it is closest to what the customer experiences. Unit fill can look healthy while line fill is poor if a few big lines ship and many small ones do not. Report all three. **Bullets:** - Line fill: lines complete divided by lines ordered - Unit fill: units shipped divided by units ordered - Order fill: complete orders divided by orders - Define on-time against the customer requested date #### Reading the result **Body:** Distributors commonly aim for line fill in the high 90s on stocked items, but the right target depends on your market and what customers will tolerate. Look at the gap between order fill and line fill: a large gap means orders carry many lines and a single short item is dragging many orders down. The margin lost figure is deliberately conservative because it counts only cancelled lines, not the longer term loss of customers who stop calling. #### Common mistakes **Body:** Measuring against the promised date instead of the requested date flatters the number. Excluding lines that were never stocked hides demand you could be capturing. Counting a split shipment as filled counts the order as complete when the customer did not receive it complete. Finally, mixing special order and stock lines in one measure muddies the cause, so measure stocked items separately and fix replenishment where it falls short. **Cta:** If you want fill rate by branch, vendor and customer generated live from your ERP, we can build a read-only dashboard over your order and shipment data. **Faq:** #### What is a good fill rate for a distributor? **Answer:** It varies by market. Many distributors target line fill in the mid to high 90s for stocked items, with lower expectations for special order lines. The better benchmark is your own trend and what your key customers expect. #### Should backorders count as filled? **Answer:** No. A line that ships later is not filled on the first shipment. Track first-shipment fill separately from eventual fill, and report both, because the first measures service and the second measures recovery. #### Why is order fill so much lower than line fill? **Answer:** An order fails if any one line is short. If an order has ten lines and each is 97 percent likely to fill, the chance all ten fill is about 74 percent. Multi-line orders amplify small line shortfalls. #### How do I improve fill rate? **Answer:** Start with the items causing the most short lines, then check their order points, lead times and vendor reliability. Raising safety stock on everything is expensive. Target the specific items and branches where shortages concentrate. ## Search terms fill rate calculator, distribution fill rate formula, line fill rate vs order fill rate, p21 fill rate report, eclipse fill rate, perfect order fill rate, distributor service level metrics, backorder cost calculator --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json