OFFLINE TOOL / KANBAN SIZING V1.7
LEAN / 036OFFLINE

Kanban sizing and cards

Number of kanban cards per part from demand, replenishment lead time, safety factor and container quantity, with the stock each loop holds and printable cards with a QR or Data Matrix code.

Input

Paste, open a CSV, TSV, TXT or XLSX file (up to 20 MB), or drop it on the field. Files are read in this browser only.

Columns (9 possible, found by the header names)
Columns

Found by the header names, or in the order Part, Demand per day, Lead time, Container quantity, Description, Safety (%), Kanban type, From, To. Change them if they are wrong.

Part      Demand per day  Lead time  Container qty
BR-1040   480             1.5        60
SC-M6x16  3200            2          1000
Long format
1 row = 1 part

Columns: tab, ; or ,
Decimals: 12,5 or 12.5

Paste measurements to start.

One row per part: demand per day, replenishment lead time (from releasing a card until its full container is back) and the quantity per container. Optional columns by header: Description, Safety (%), Type (Production or Withdrawal), From, To.

Runs in this browser. Data is not uploaded or stored.

Results

—Cards in all loops
—Parts
—Most days of stock

    How the kanban cards are sized

    A kanban loop holds a fixed number of containers, each with its card. When a container is used, its card goes back and authorises making or fetching one more. The number of cards caps the stock of the part and, through Little’s law, its lead time. The formula below is the usual one, not a standard; it sizes a loop for an average demand.

    Formulas

    Worked example (the tool’s example)

    1. Bracket BR-1040: 480 pieces a day, 1.5 days to make and bring a container of 60, safety 10 %: 480 × 1.5 × 1.1 / 60 = 13.2, so 14 cards; the loop holds 840 pieces, 1.75 days.
    2. Screw M6 × 16: 3200 a day, 2 days, boxes of 1000, safety 20 %: 3200 × 2 × 1.2 / 1000 = 7.68 → 8 cards.
    3. Label roll LB-7: 240 a day, 3 days, rolls of 500: 1.58 → 2 cards. All five parts need 44 cards.

    Common mistakes

    Input and files

    Questions

    How many kanban cards do I need?
    The usual formula is N = demand per day × replenishment lead time in days × (1 + safety factor) / quantity per container, rounded up. The lead time is the whole loop: from the moment a card is released until its full container is back at the point of use, waiting and transport included.
    What safety factor should I use?
    It covers the variation of demand and lead time that the average does not. 10 to 20 % is often used to start; lower it as the loop proves stable. A large safety factor hides problems such as unreliable supply instead of fixing them.
    What is the difference between a production and a withdrawal kanban?
    A production kanban authorises the supplying process to make one container; a withdrawal (move) kanban authorises moving one container from a store to the point of use. Both are sized with the same formula, with the lead time of making or of fetching.
    Why should a loop have at least two cards?
    With one card the only container must be used up before it is sent for refilling, so the consumer waits for the whole lead time. With two or more, one container is in use while the others are being refilled.