Inventory & Kanban Sizing Calculator
Interactive guidance and clear formulas to size kanban cards, safety stock, and reorder points from demand, lead time, and variability, plus a practical governance checklist and worked example.
What this calculator helps you do
Use simple, transparent rules to right-size kanban cards, safety stock, and reorder (rebuild) thresholds so frontline teams can manage visual replenishment without creating fragile supply. The mathematics are intentionally straightforward so you can explain and validate results with operators and buyers.
Inputs (what you need)
- Daily average demand (D) — units consumed per working day.
- Lead time (L) — replenishment lead time in days (time from issue of kanban to receipt).
- Demand standard deviation per day (σd) — typical daily demand variability. If you only have weekly or monthly data, convert to daily units first.
- Service level target — the probability you want to avoid a stockout during lead time (e.g., 95%). We convert this to a z-score below.
- Container (kanban) quantity (Q) — how many units are in each kanban container. If you operate a continuous quantity system, treat Q as the replenishment batch size.
Key formulas (plain language)
We base safety stock on demand variability during lead time, then add average lead-time demand to get the reorder point.
- Average demand during lead time = D × L
- Standard deviation during lead time = sqrt(L) × σd (assumes daily demand variation is independent)
- Safety stock = z × (standard deviation during lead time), where z is the z-score for your service level (e.g., 1.28 for 90%, 1.65 for 95%, 2.33 for 99%)
- Rebuild threshold (reorder point) = (D × L) + safety stock
- Number of kanban cards (N) = ceil(rebuild threshold / Q). Round up so you don't under-supply.
Worked example (so you can follow the math)
Assume: D = 200 units/day, L = 3 days, σd = 50 units/day, target service level = 95% (z ≈ 1.65), Q = 100 units per kanban container.
- Average demand during lead time = 200 × 3 = 600 units.
- Standard deviation during lead time = sqrt(3) × 50 ≈ 86.6 units.
- Safety stock = 1.65 × 86.6 ≈ 143 units.
- Rebuild threshold = 600 + 143 = 743 units.
- Kanban cards N = ceil(743 / 100) = 8 cards (each card represents a 100-unit container).
How to apply the result on the shop floor
- Use the calculated number of kanban cards and container quantity so frontlines can physically manage replenishment: when an empty container (card) returns to the supermarket it triggers a pull.
- If the calculated N feels large, consider increasing container size Q or reducing lead time L before cutting the number of cards — cutting cards without addressing variability and lead time causes stockouts.
- Be explicit about ownership: who refills, who counts kanban cards, and who updates parameters (D, σd, L).
Simple governance checklist for periodic review
Put a short cadence in place so your kanban system stays healthy.
- Monthly: Compare actual average daily demand and variance to the values used. If average demand changes by >10% or variance increases, recalculate.
- Monthly or after a stockout: Review lead-time performance and record causes for any late replenishments.
- Quarterly: Audit physical kanban cards — are all cards in circulation accounted for? Are cards damaged, duplicated, or missing?
- After process changes: If you change lot sizes, container sizes, or suppliers, recalculate immediately.
- Owner: Assign a single owner (planner, team lead, or material handler) responsible for updating parameters and running the calculator.
Practical tips and common mistakes
- Do not cut kanban cards to reduce inventory without first checking variability and lead time — that increases the risk of production stoppage.
- If demand is highly intermittent or lumpy, consider using a time-window approach or smoothing demand with a moving average before estimating σd.
- Shorten lead time more aggressively than you reduce safety stock: lead-time reduction reduces both average lead-time demand and its variability.
- If supplier minimum order quantities or transport constraints force large Q, combine kanban with a small safety buffer at the supermarket to protect production.
- Validate z-score assumptions. Service level is a trade-off: higher service level → more safety stock. Use historical stockout cost estimates to guide your choice.
Next steps
- Gather 30–90 days of daily demand data for the part family you’re sizing; calculate average D and σd.
- Measure current average replenishment lead time L (including supplier and internal process times).
- Pick a service target and container size Q, then run the formulas above and test one line for a pilot.
- Track stockouts, kanban turns, and days of inventory over the pilot. Adjust parameters using the governance checklist.
Why this matters
Kanban is a frontline-friendly way to reduce inventory while protecting production — but only when sizing accounts for variability and lead time. This calculator gives you clear, defendable numbers that teams can understand and adjust together.
Want this as an interactive tool that computes results and saves scenarios for later comparison? We recommend adding a rendered Interactive form that captures your inputs, performs the calculations client-side, and stores scenarios so teams can track changes over time.
Discussion
Comments and conversation will live here.