MOQ (minimum order quantity) & carton allocation automatic calculation tool
Just enter the MOQ, quantity, and desired quantity for each SKU. You can automatically compare fractional adjustment proposals (rounding up/rounding down/minimum excess).
*MOQ and quantity will vary depending on transaction conditions. The results of this tool are for reference only. Be sure to follow the supplier's conditions for final confirmation.
Calculation tool (SKU input)
If you enter the MOQ, quantity, and desired quantity for each SKU, three options will be displayed immediately for each line.
| SKU (optional) | Product name (optional) | MOQ (required) | Quantity (required) | Desired quantity (required) | operation |
|---|
MOQ / quantity / desired quantity is an integer greater than or equal to 1. If not entered, it will not be calculated (- will be displayed).
CSV bulk input
You can download templates and import them in bulk by uploading or pasting.
UTF-8 recommended. In the case of Shift-JIS, characters may be garbled.
Presentation of 3 proposals (by SKU)
Recommended automatic selectionTotal/output (based on adopted proposal)
*MOQ and quantity will vary depending on transaction conditions. The results of this tool are for reference only. Be sure to follow the supplier's conditions for final confirmation.
How to use
short steps
- 1. ?? a SKU line and enter MOQ, quantity, and desired quantity.
- 2. Compare 3 options (minimum excess / round up / round down)
- 3. ?? adoption proposals for each SKU and copy or output CSV total
calculation logic
term
MOQ: Minimum order quantity (units)
Quantity: Quantity per carton (units/carton)
Desired quantity: Desired quantity (units)
base = max(desired quantity, MOQ)
Minimum excess: order_min = base
Round up: order_up = ceil(base / number of items) * number of items
Round down: order_down = floor(base / quantity) * quantity (cannot be less than MOQ)
Explanatory sample
Example: MOQ=100, quantity=24, desired quantity=100
- Minimum excess: 100 (full 4 + fraction 4) → carton split
- Round up: 120 (full 5) → ??? rounding up
- Rounding down: 96 → ???t possible below MOQ
?? ?? ??
Is the quantity different for each SKU?
You can support each SKU by adding rows.
How do you decide the fraction?
Three options are automatically presented: round up, round down, and minimum excess, and you can select the option for each SKU.
Can I input data in bulk using CSV?
yes. You can download templates and import them by uploading or pasting.
Why is truncation not possible?
If the quantity after rounding down is less than the MOQ, the transaction conditions will not be met and the order will not be accepted.
Will there be a fraction for the minimum excess?
yes. Priority is given to the minimum quantity that meets the MOQ and desired quantity, so if the quantity is not a multiple of the quantity received, a fraction will be given.
Disclaimer/Precautions
*MOQ and quantity will vary depending on transaction conditions. The results of this tool are for reference only. Be sure to follow the supplier's conditions for final confirmation.