MOQ and carton calculator
Enter the MOQ, case pack, and desired quantity for each SKU to compare minimum-excess, round-up, and round-down plans.
MOQ calculator / carton quantity calculator / case pack calculator
How to use
Steps
- Add an SKU row and enter the MOQ, case pack, and desired quantity.
- Compare the minimum-excess, round-up, and round-down plans.
- Select a plan for each SKU, then copy the results or export a CSV.
Terms
- MOQ: Minimum order quantity (units)
- Case pack: Units per carton
- Desired quantity: Requested units
Calculation logic
- base = max(desired quantity, MOQ)
- Minimum excess: order_min = base
- Round up: ceil(base / case pack) × case pack
- Round down: floor(base / case pack) × case pack (must meet the MOQ)
Example
Example: MOQ 100, case pack 24, desired quantity 100
- Minimum excess: 100 units (4 full cartons + 4 units)
- Round up: 120 units (5 full cartons)
- Round down: 96 units (below the MOQ, so unavailable)
FAQ
Can each SKU have a different case pack?
Yes. Add a row for each SKU and enter its case pack.
How do I handle a partial carton?
Compare the minimum-excess, round-up, and round-down options, then choose a plan for each SKU.
Can I enter several SKUs using CSV?
Yes. Download the template and upload the completed CSV, or paste its contents.
Why can't I choose the round-down option?
Rounding down is unavailable when the resulting quantity would be below the MOQ.
Can the minimum-excess option leave a partial carton?
Yes. The minimum quantity meeting the MOQ and desired quantity may leave a partial carton.
Notes
MOQs and case packs depend on your supplier's terms. Use these results as a guide and confirm the final order with your supplier.