Import Order Break-Even Quantity: A Worked MOQ Calculator

An import order can show a positive margin and still be too large for the business.

The supplier's minimum order quantity may dilute fixed freight and clearance costs, but it also commits cash before demand is proven. A conventional break-even calculation answers how many units must sell for contribution to cover fixed costs. It does not automatically show when the original cash tied up in the full order returns to the bank account.

For an import decision, calculate both:

Operating break-even units: sales required to cover order-specific fixed costs after each sold unit pays its own variable costs.
Initial cash-recovery units: sales required to replenish the upfront cash committed to the shipment, after sale-triggered cash costs.

Then compare both numbers with the MOQ, a conservative time-bounded sales forecast, cash capacity and inventory risk.

This guide uses an invented 800-unit example. It is not a sales forecast, accounting opinion or market benchmark.

Define the inputs before using a formula

Start with revenue excluding GST where applicable, then separate costs by behaviour. The labels matter because putting the same cost in two places creates false precision.

Input	Meaning in this calculator	Examples
Net sales revenue per unit	revenue retained before costs, excluding GST where appropriate	selling price less routine discounts
Variable product cost per sold unit	economic landed cost attached to each unit sold	product, allocated freight, duty and non-creditable import costs
Variable selling cost per unit	cost triggered by a sale	payment or marketplace fee, pick-and-pack, outbound freight, expected returns allowance
Order-level fixed cost	cost incurred for the order regardless of how many units sell	setup, one-off testing, inspection, broker or fixed campaign preparation
Initial order cash commitment	cash paid before meaningful customer receipts	goods, freight, duty, clearance, delivery, fixed costs and funded GST where relevant
Expected sell-through	units realistically sold within a stated decision period	conservative base case, not total addressable market

The landed-cost model should be completed first. It determines which shipment costs vary with units, which are fixed to the shipment, and whether import GST is a cash-flow item, a permanent cost, or partly both for this importer.

Do not place all landed cost in the fixed-cost numerator and also use landed cost per unit in the contribution denominator. That counts the product twice.

Formula one: operating break-even units

Contribution per unit is the amount each sale contributes after paying the costs caused by producing/importing and selling that unit.

Contribution per unit = net sales revenue − variable product cost − variable selling cost

Then:

Operating break-even units = order-level fixed costs ÷ contribution per unit

Always round up. A result of 177.1 means the 178th unit is needed.

If contribution per unit is zero or negative, there is no finite break-even quantity under the current assumptions. More sales would not repair the unit economics. The business must change price, cost or scope.

Business Queensland's break-even guidance uses fixed costs and profit/contribution relationships, and also cautions businesses to consider a reasonable return for the risk involved. That qualification matters here: zero operating profit does not reward the owner, fund broader overhead, absorb obsolescence or justify a long cash cycle.

Formula two: initial cash-recovery units

An importer commonly pays a deposit, balance, freight, clearance and delivery before receiving substantial customer cash. Unsold inventory may remain an asset for accounting purposes, but the money is still unavailable for the next order or other operating needs.

Use a separate liquidity test:

Cash retained per sale = cash collected per unit − sale-triggered cash costs per unit

Initial cash-recovery units = initial order cash commitment ÷ cash retained per sale

This calculation deliberately treats the upfront inventory payment as part of the cash commitment. Therefore, do not subtract the product cost again from cash retained per sale. Sale-triggered costs still belong in the denominator because they consume cash only when the sale occurs.

The result is a planning threshold, not a full cash-flow forecast. Payment dates, GST/BAS timing, deposits, customer credit terms and overhead outflows still need a dated cash-flow model. Use the China sourcing cash-flow timeline to model those dates.

Worked example: an 800-unit supplier MOQ

Assume a business is considering an 800-unit order with the following invented inputs, all in Australian dollars and excluding GST from sales revenue.

Calculator input	Illustrative amount	Basis
Supplier MOQ	800 units	written supplier quote
Net sales revenue	$44 per unit	planned realised price after routine discounts
Variable landed product cost	$14 per sold unit	completed landed-cost model
Variable selling cost	$12 per sold unit	fulfilment, payment/marketplace and expected sale-related costs
Order-level fixed cost	$3,200	setup, testing, inspection and order-specific fixed charges
Initial order cash commitment	$14,400	800 × $14 plus $3,200 fixed cost
Conservative 12-month sell-through	350 units	internal demand case, not a market fact

Step 1: calculate contribution

$44 − $14 − $12 = $18 contribution per unit

Step 2: calculate operating break-even

$3,200 ÷ $18 = 177.78

Round up: 178 units must sell for contribution to cover the order-level fixed cost.

At 178 units, the model is only just above zero for these order-specific economics. It has not recovered all cash paid for the 800 units, and it has not necessarily covered the business's existing rent, salaries or owner return unless those costs were deliberately included.

Step 3: calculate initial cash recovery

The sale-triggered cost is $12. The $14 product cost is already inside the upfront $14,400 commitment, so it is not subtracted again.

Cash retained per sale = $44 − $12 = $32

$14,400 ÷ $32 = 450 units

The business must sell 450 units to replenish the initial order cash under these simplified assumptions.

At that point, 350 units remain in stock. Their future sale can generate further cash and contribution, but they still face storage, damage, discounting and obsolescence risk.

Step 4: compare with expected sell-through

The conservative 12-month case is 350 units.

Operating result for the order-specific model:

350 × $18 − $3,200 = $3,100

The order shows a positive $3,100 contribution after its fixed costs at 350 sales, yet it has not reached the 450-unit initial cash-recovery threshold.

That is not contradictory. Accounting profit recognises the product cost of units as they are sold. Cash flow records that the business paid for all 800 units before sale. The remaining stock can have value while still tying up cash.

Confirm inventory and GST accounting with the business's accountant. The calculator is a commercial decision aid, not a replacement for financial statements.

Compare the MOQ with three thresholds

Do not ask only Is 800 above 178? Compare:

Operating threshold: can the business credibly sell at least 178 units before the product loses relevance or requires discounting?
Cash threshold: can it sell 450 units soon enough to fund the next purchase and normal operations?
Demand threshold: is the 350-unit forecast supported by channel evidence, conversion data, pre-orders, comparable sales or a controlled test?

In the worked example, the MOQ is not rejected automatically. It is held for a cash-capacity decision because the base demand case does not recover the initial commitment in 12 months.

The response might be to negotiate a lower MOQ, stage releases, simplify packaging, use stock materials, share a production run or accept a higher unit price for a smaller test. The lower-MOQ negotiation guide owns that supplier conversation. This calculator supplies the maximum commitment the business can defend.

Test the levers without hiding the trade-offs

A lower price

If variable landed product cost falls from $14 to $13 while everything else holds, contribution rises to $19 and operating break-even falls to 169 units after rounding.

But a lower price tied to a 1,500-unit MOQ may increase total cash exposure. Unit margin improves while liquidity risk worsens. Compare total commitment and sell-through, not just break-even units.

A higher realised selling price

If net revenue increases to $48 and selling costs remain $12, contribution becomes $22. Operating break-even falls to 146 units after rounding.

That scenario is valid only if the realised price is supported. A list price without allowance for routine discounting, marketplace promotions or channel mix is not evidence.

Lower order-level fixed cost

If fixed cost falls from $3,200 to $2,400, operating break-even becomes $2,400 ÷ $18 = 134 units after rounding.

Do not remove testing, inspection or compliance work merely to improve the spreadsheet. Separate avoidable commercial setup from controls needed to make the product safe, conforming and saleable.

Add time and inventory risk

Two orders with the same break-even quantity can have very different risk.

Demand timing: 450 sales in eight weeks and 450 sales in eighteen months have different working-capital consequences.
Seasonality: stock arriving after the selling window may require discounting.
Variant mix: total demand can look adequate while unpopular colours or sizes remain stranded.
Shelf life and obsolescence: fashion, technology, packaging and compliance changes can shorten the viable sales period.
Reorder lead time: too small an order can create a stockout before replenishment; too large an order can hide weak demand.
Quality yield: units held, reworked, replaced or written off alter the saleable denominator.
Customer returns: an expected return allowance should be based on relevant evidence and kept visible, not buried in a margin percentage.

Run at least low, base and high cases for realised selling price, saleable units, variable selling cost and sales velocity. The goal is not to forecast perfectly. It is to discover which assumption must be true for the MOQ to survive.

Do not confuse break-even quantity with economic order quantity

Break-even units answer how much must sell to cover a defined cost base. Economic order quantity is an inventory-management concept that balances ordering and holding costs under its assumptions. A supplier MOQ is the minimum quantity the supplier will accept.

These numbers can be different:

supplier MOQ: what the factory will produce;
operating break-even: what must sell to cover fixed order costs;
cash-recovery threshold: what must sell to replenish committed cash;
demand case: what the business expects to sell in a stated period;
chosen order quantity: the commitment approved after considering all four.

Calling any one of them the minimum viable order without defining the decision creates confusion.

Build the calculator with visible checks

Use separate input, calculation and decision sections. Lock formula cells and give every assumption an owner and date.

Input checks

[ ] planned realised selling price is net of routine discounts and excludes GST where appropriate;
[ ] landed product cost comes from a current low/base/high model;
[ ] import GST treatment has been confirmed and its cash timing is recorded;
[ ] variable selling costs include the channels actually expected;
[ ] fixed costs do not also appear in per-unit landed cost;
[ ] saleable quantity differs from ordered quantity only when supported by a documented assumption;
[ ] expected sell-through covers a stated period and channel;
[ ] supplier MOQ and price breaks are current and specification-equivalent.

Formula checks

[ ] contribution per unit is positive;
[ ] break-even results round up to whole units;
[ ] cash recovery does not subtract prepaid product cost twice;
[ ] low/base/high scenarios update all dependent results;
[ ] the result does not rely on selling more saleable units than the order can provide.

Decision checks

[ ] base demand clears the operating threshold with a reasonable buffer;
[ ] downside demand does not create an unacceptable write-off;
[ ] cash recovery fits the working-capital window;
[ ] expected return exceeds a zero-profit floor;
[ ] a smaller test, staged release or revised MOQ has been compared;
[ ] compliance and quality controls have not been removed to make the numbers pass.

Make the order earn approval

The factory's MOQ is a production constraint, not proof of commercial viability.

Calculate contribution without double counting. Find the operating break-even. Then calculate how many sales replenish the cash committed before launch. Compare both thresholds with a conservative, time-bounded demand case and the business's ability to carry unsold stock.

In the worked example, 178 units cover order-specific fixed costs, but 450 sales are needed to recover the initial $14,400 cash commitment. A 350-unit base case therefore passes the operating-profit test and fails the 12-month cash-recovery test. That is the decision the importer must solve before paying the deposit.

Sources

Need To Source Something From China?

Get In Touch