Branch Stockout Cost Calculator for Multi-Branch Distributors
At a single branch, a stockout looks like a missed sale. Across a branch network it also creates transfers, expedites and customer drift. This calculator prices the stockout days for one item at one branch.
Your numbers
Customer buys elsewhere instead of waiting.
Truck, driver time and handling per unit moved.
Your results
The remainder of demand is assumed to wait and be filled by backorder at no extra cost. Adjust the percentages to your reality.
Annual stockout cost by stockout days
Sweeps Stockout days per year from 0 to 120, holding your other inputs fixed.
Branch availability analysis
Optional: we can show how branch stockout and transfer data could be pulled together from ERP records.
Optional. The tool and every export work without this. No spam.
How to use it
Choose a fast mover that stocks out occasionally. Enter its average daily demand, the number of stockout days you see per year, and the margin per unit. Estimate three behaviors: how much demand is lost for good, how much is rescued by a transfer from another branch, and what a transfer costs per unit. The remainder is treated as waiting at no extra cost.
- Pull stockout days from daily on-hand snapshots or no-stock lines.
- Use real transfer cost: trucking, labor and handling.
- Run the top 20 items by revenue for each branch.
The formula
Demand during stockouts equals daily units times stockout days. Lost margin equals that demand times the lost share times unit margin. Transfer expense equals demand times the transfer share times transfer cost. The sum is the annual cost. For 14 units a day and 18 stockout days, demand during stockouts is 252 units, so a 35 percent loss rate at 11 dollars margin costs about 970 dollars before transfers.
Reading the result
The cost per stockout day tells you how much a day of extra safety stock is worth. If adding a few days of cover costs less than the stockout days it prevents, increase the branch stocking level. If transfers are the main cost, consider stocking the item centrally or at a closer branch.
Common mistakes
Counting all demand as lost overstates the problem because many contractors will wait for a day or two. Another error is leaving out the demand pattern: if a stockout hits on peak days, daily demand understates it. Use demand on the specific days out of stock where you can.
Frequently Asked Questions
How do I count stockout days?
Use a daily on-hand snapshot or movement history and count days with zero available quantity while the item had demand. If you lack snapshots, estimate from no-stock lines on orders.
What lost sales percentage is typical?
It varies widely by product and customer. Commodity items often lose more demand than specialized items. Estimate from sales rep feedback or test with a range, since the chart shows sensitivity.
Does it apply outside Eclipse?
Yes. The model is generic to any branch-based distributor. The Eclipse label reflects the typical multi-branch use case, not a system integration.
What about substitutes?
Treat substitute sales as recovered demand by lowering the lost percentage. The substitute may have a different margin, which you can reflect in the unit margin.
Netray can help identify stockout days and transfer patterns by branch and item from your ERP data, read-only.
Related Tools
Distributor Backorder Cost and Fill Rate Calculator
Convert line fill rate into the annual cost of backorders, and see the value of improving fill rate by one point.
Supply Chain & InventoryEOQ with Vendor Minimum Order Calculator
Find the economic order quantity, then see what a vendor minimum order quantity costs you per year and how many days of stock it forces.
Costing & FinanceDistributor GMROI and Inventory Turns Calculator
Calculate GMROI, inventory turns and days of inventory for a branch, vendor line or product group, and see how inventory levels move the return.
EpicorP21 Dead Stock Hold vs Liquidate Calculator
Decide whether to keep dead or obsolete stock or sell it down now. Compares the all-in loss of each path and finds the break-even month.
More Supply Chain & Inventory tools
See all- Distributor Vendor Performance Scorecard Worksheet
- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor GMROI Calculator
- Distribution KPI Formula Reference
- Distributor Pricing and Rebate Terms Glossary