Picking breakdown for mixed case and each

Calculate the shortest picking candidates from required quantity, units per case, and stock (case/each).

(EN) picking breakdown / case and each calculator

Find the shortest picking mix quickly even when case and each are mixed Multiple lots are supported by simply adding rows If short, shortage quantity and alternatives are shown Warehouse constraints such as no-open-case are reflected

How to use

  1. Enter required quantity and units per case.
  2. Enter stock by lot and add rows if needed.
  3. Choose the rule and constraints, then run calculation.
  4. Share the recommended breakdown by copy/CSV/print.

Sample

No shortage (standard)
Input: required 125 / units per case 24 / lot A: case 5, each 3 / rule: case first
Output: case 4 (96) + each 29 = total 125 (no shortage), picking lines 2
With shortage (alternatives)
Input: required 125 / units per case 24 / total stock 108 / show shortage candidates ON
Output: shortage 17, max shippable breakdown and relaxed-constraint alternatives

Remainder optimization rules

  • Shortage = max(0, required - (case × unitsPerCase + each))
  • Shortest means minimum picking lines (tie: fewer lots and openings)
  • When short, show max shippable plan and relaxed-constraint alternatives

FAQ (multi lot, rules, shortage)

How do I enter multiple lots?

Add lot rows in the stock section. Lot name is optional.

Can I prioritize each first or case first?

Switch rule (case first / each first / yield first) to update recommendation and candidates.

What happens when stock is short?

The tool shows shortage quantity, max shippable breakdown, and alternatives such as quantity adjustment and relaxed constraints.

What does shortest picking mean?

In this tool, shortest means fewer picking instruction lines.

Notice

  • If you have warehouse rules such as no-open-case or no-lot-mix, set them in constraints before calculation.
  • This tool is an operational guide. Final decisions must follow your validation and shipping rules.

Paste stock input (TSV/CSV)

Column order: lot, case stock, each stock, priority, memo (priority/memo optional)