Deep-dive guide
MOQ Cash Lock Simulator: Is the Bulk Discount Worth the Cash You Freeze?
Executive industry analysis
A minimum order quantity is a supplier's way of protecting its production run. For a seller it is both an opportunity and a trap. The opportunity is a better unit price and a steadier supply. The trap is that you must pay for months of future sales on day one. That payment is cash you cannot use for advertising, new products or a safety buffer, and it is paid before you know whether the product will keep selling at today's rate.
The structure of the problem is a race between two clocks. One clock is the speed at which you sell the batch, measured by monthly sales. The other is the cost of waiting: financing the locked cash, paying for storage and risking that units age, go out of season or are overtaken by a better product. If you sell the batch quickly, the lower unit price is a clear win. If you sell it slowly, the carrying cost and the unsold tail can erase the saving and turn a good deal into a loss.
The domino model follows that race. The MOQ and the unit cost set the cash locked. Cash locked and monthly sales together set how many days the batch takes to sell through. A long cycle raises the monthly carrying cost, which includes financing, storage and the tail of units unsold past their shelf life. The carrying cost then reduces the real margin per unit, and that margin multiplied by sales is the monthly profit averaged over the whole cycle.
The iceberg shows what the unit price leaves out. Above the waterline are the goods themselves and the interest on the cash. Below it are the storage and handling of a bigger batch, the loss on units that outlive their shelf life, the selling costs of channel fees and ads, and the overhead of managing the line. Use the simulator to find the sales speed at which the bulk saving disappears, and compare it with a smaller, more expensive order that keeps your cash free.
Formula and methodology blueprint
The model works per month and averages over the sell-through period. Stock falls steadily as units sell, so on average half the batch is on the shelf. That average stock carries financing and storage. Units still unsold after a shelf life of six months are assumed to clear at a loss, and that loss is spread over the months of the cycle. Selling costs are a share of the price, and a small overhead covers managing the line.
- Sell-through time
- T = MOQ ÷ monthly sales
- Months needed to sell the whole batch at the current rate.
- Cash locked
- L = MOQ × unit cost
- The money paid up front and tied up until the batch sells.
- Carrying cost
- C = (MOQ ÷ 2) × (unit cost × rate ÷ 12 + storage)
- Financing and storage on the average stock held during the cycle.
- Unsold tail
- X = max(MOQ − 6 × sales, 0) × unit cost × 50% ÷ T
- Monthly share of the loss on units that outlive the shelf life.
- Net profit
- Net = sales × (price − cost) − selling costs − C − X − overhead
- Average monthly profit across the cycle. The breaking point is where this reaches zero.
Cascading elasticity
Unit cost is the most elastic input, because it multiplies both the margin on every unit and the cash locked. Sales speed comes next: it divides the cycle, so slow sales raise the tail and the carrying cost together. The MOQ is a threshold. Below the shelf-life limit it adds only financing and storage, and above it the tail begins and costs rise much faster.
Three real-world case studies
Bootstrapped starter
A modest MOQ on a steady seller
A seller buys five hundred units at a time and sells about a hundred and sixty a month. The batch sells through in three months, storage is cheap and the financing cost is small. The saving is real. Loading it shows how a MOQ that matches sales speed pays off.
Scaling mid-market
A high-volume product with a big MOQ
A seller buys twelve thousand units and sells over two thousand a month. The batch moves in about five months and financing is cheap. The large MOQ is simply the normal way to buy. Loading it shows how volume turns a big locked sum into a good deal.
Black-swan crisis
A big MOQ on a product that stalls
A seller accepts a six thousand unit minimum for a lower price, then demand falls to about a hundred and twenty a month. The batch would take four years to sell, financing is expensive and most units outlive their shelf life. Loading it shows how the saving per unit is overwhelmed.
Industry benchmark matrix
| Metric | Danger zone | Industry average | Top 10% elite |
|---|---|---|---|
| Months of sales covered by one purchase | More than 8 | 2–4 | 1–2 |
| Cash locked as multiple of monthly revenue | Above 6× | 1–3× | Below 1× |
| Unit price saving needed to justify a bulk order | Below 5% | 10–20% | Above 25% |
| Annual inventory carrying cost | Above 35% | 20–28% | Below 15% |
| Share of batch still unsold after 6 months | Above 30% | 0–10% | None |
Variables and levers
Minimum order quantity
Units the supplier requires you to buy in one order to get this price.
Lever: Ask for a smaller first order, a split delivery or a staged price, because every extra unit stays on the balance sheet longer.
Units sold per month
How many units of this product you realistically sell each month.
Lever: Prove demand with a small pre-order or test batch before you commit to a large MOQ.
Cost per unit at the MOQ
The landed price per unit you pay when you meet the minimum.
Lever: Compare the discount to the cost of holding; a lower unit price is only worth it if it beats financing and storage.
Selling price per unit
What the customer pays for one unit.
Lever: Protect the selling price, since a lower price shrinks the margin that must repay the cash you locked.
Cost of capital per year
Interest on borrowed money or the return you give up by locking the cash.
Lever: Pay the supplier from cheaper money, or negotiate payment terms, because the cost of capital runs for the whole sell-through period.
Storage per unit per month
Warehouse, shelving and handling allocated to one unit for one month.
Lever: Store the batch in the cheapest suitable space and avoid paying for idle shelf you will not need for months.
How to use this simulator
- 1Enter the supplier's MOQ, the landed unit cost and your selling price.
- 2Enter the number of units you realistically sell per month, not the number you hope to sell.
- 3Read the five domino boxes to see how cash locked turns into sell-through time and carrying cost.
- 4Press Find my breaking point to find the sales speed or cost that ends the saving.
- 5Compare the MOQ with the staged order plan in the Parallel universe tab.
Mistakes to avoid
- Comparing only unit prices. A lower price on a huge batch can cost more once financing, storage and unsold units are counted.
- Using forecast sales instead of recent sales. Optimistic demand shortens the cycle on paper and hides the real tail.
- Forgetting that the cash is locked for the whole cycle. Money tied in one product is not available for ads or a better-selling line.
- Ignoring the shelf life. Units that stay unsold past a season or expiry date often sell at a deep loss.
Frequently asked questions
Is a bulk discount ever worth taking?
Yes, when you sell the batch fast enough that financing, storage and the unsold tail cost less than the saving. This model shows where that stops being true.
What if the supplier will not negotiate the MOQ?
Consider sharing an order with another seller, using a distributor at a higher unit price, staging delivery, or asking for consignment or longer payment terms to offset the cash lock.
Why does the model assume a six-month shelf life?
It is a simple stand-in for fashion, expiry or product-cycle risk. Change the sales speed and MOQ to see how quickly the tail grows, and judge it against your own category.
Does the model include import duties and shipping?
Enter the landed cost per unit, including freight and duties, as the unit cost. Check current rules for your trade lane.
How do I find my breaking point?
Press Find my breaking point. The tool pushes each input to its worse end and reports where monthly profit reaches zero, ranked by how near each one is.
How accurate is this?
It is an educational planning model, not financial advice. Replace the inputs with your own figures and compare them with your supplier quotes and sales history.
This is an educational planning model with stated assumptions. It is not financial, tax or legal advice. Replace the inputs with your own figures and verify important decisions with a qualified professional.