Why EOQ Overstates What a Cash-Tight Brand Can Order
Economic order quantity minimises ordering and holding cost, never cash risk. Here is how to cap your order size using a 13-week cash forecast.

You have probably done this: worked out the "right" order size, placed it, then spent the next fortnight watching your bank balance with mild panic. The formula you used was likely the economic order quantity, and it did its job perfectly. Its job just was not cash.
This tutorial is about that gap. We will look at what the economic order quantity actually calculates, run the formula line by line, and work through a real example for one Shopify bestseller. Then we will cap the order with the cash you actually have, built from the next 13 weeks of outflows. You will see the two numbers side by side, understand why cash caps the order and not just the cost, and know what to do before you place your next order. It is written for founders doing the books late at night, so we will keep it plain and practical.
What the economic order quantity formula actually calculates
Economic order quantity (EOQ) finds the order size that minimises the sum of ordering cost and holding cost. It has no input for the money in your bank account, so it is an upper bound on a sensible order, not a spending instruction.
Only three inputs go in: annual demand in units (D), the cost of placing one order (S), and the cost of holding one unit for a year (H). Nothing else.
The rule the rest of this piece rests on: order the smaller of the EOQ and what your next 13 weeks of cash outflows can actually fund. For most cash-tight brands, that is not the EOQ.
If you are reading at 11pm: EOQ is a textbook ordering model, taught in operations and supply chain courses, and it usually appears the first time a supplier minimum makes you think about order size. It is one of several order-sizing methods. Not wrong, just incomplete. For the wider picture, see how much stock to order.
The economic order quantity formula, line by line
Here is the whole calculation in one line:
EOQ = √(2 × D × S / H)
D is annual demand in units, S is ordering cost per order, H is holding cost per unit per year. The formula comes from Harris’s 1913 work (historical note), and the derivation is standard operations maths.
Ordering cost is everything that happens once per order: freight and customs set-up, supplier admin fees, inspection and QA, and the staff time to raise, chase and book the delivery. Holding cost is everything a unit costs while it sits: storage, insurance, shrinkage, markdown and obsolescence risk, plus the cash tied up in it. Most founders underestimate holding cost badly.
EOQ sits where the rising holding-cost curve meets the falling ordering-cost curve. The total cost curve is flat near that point, so being 50 to 100 units out rarely costs much.
It assumes steady demand, fixed cost per order, no volume discounts, no lead-time surprises, and no cash limit. That last one is the killer for brands paying for stock before it sells. EOQ is just short for economic order quantity, so both terms mean the same calculation. If you want to turn an order size into a reorder trigger, work out your reorder point.
A worked example: EOQ for one Shopify bestseller
Take one bestseller. Say it sells 12,000 units a year, costs £150 to place an order and £6 to hold one unit for a year. These numbers are illustrative, chosen so the maths is easy to follow.
EOQ = square root of (2 x 12,000 x 150 / 6) = square root of 600,000 = about 775 units per order.
That is roughly 15 orders a year. At a £22 landed unit cost, 775 units takes £17,050 out of the bank in one go.
The formula is perfectly happy. It has just recommended a £17,050 purchase with no reference to whether you have £17,050. Run your own demand, ordering cost and holding cost through the same three inputs, and you will get your own upper bound. If you are comparing tools to hold those inputs, see our guide to best inventory planning software for Shopify brands (2026).
Now cap the order with the cash you actually have
The formula has no idea what is in your bank account. So cap the order with cash. The cash cap is the most you can spend on stock this week without breaking the next 13 weeks of committed outflows. This is our approach, a cash forecast applied to a stock decision, not a published textbook formula.
Work it out as:
Cash in bank + confident receipts − committed outflows over 13 weeks − buffer you refuse to touch
On the same example: £24,000 + £61,000 − £70,000 − £3,000 = £12,000 free for stock.
At £22 a unit, that is about 545 units. The formula said 775. The gap is 230 units and £5,060 of cash you do not have. If you want to test your own numbers, work through the stock order affordability questions.
So the rule has two parts. Use the EOQ as the upper bound, apply the cash cap, and order the smaller of the two.
EOQ versus the cash cap, side by side
Put them side by side and the gap is obvious.
| Metric | Classic economic order quantity | 13-week cash cap |
|---|---|---|
| Order size | 775 units | 545 units |
| Cash required | £17,050 | £12,000 |
| What it optimises | Ordering plus holding cost | Staying solvent with stock on the shelf |
| What it ignores | Your bank balance | The cost trade-off |
That is not a rounding difference. It is a £17,050 hit versus a £12,000 hit in the same week. Close it without spending your buffer: split the order into two deliveries, ask the supplier for longer payment terms, or delay and accept one planned stockout. If the cap sits far below the EOQ every month, suspect cash conversion before order size. See our inventory planning guide and the calculators for the cash flow side.
Why cash caps the order, not just cost
The gap between 775 and 545 units is not a maths error. A Banque de France survey study of almost 8,000 SMEs found short-term credit constraints are as important as long-term ones in investment decisions. It also found the investment penalty is larger when working capital needs rise, and smaller for firms liquid enough to adjust receivables and stock. Stock is working capital. For a Shopify brand, that means when cash is tight the bank balance can bind your stock order before ordering cost versus holding cost does. The EOQ still tells you cost; your cash forecast tells you what you can fund. Build the forecast as set out in our 13-week rolling method. Then check your own bank facility and supplier payment terms, because lending conditions change and no general rule can tell you today's terms.
Where the 13-week cash number comes from
The 13-week cap builds on that liquidity point: it covers a full quarter, so most supplier lead times and payment terms fall inside it, and it catches quarterly bills a monthly view would miss.
Gather your bank balance today, receipts you can bank on, committed bills with due dates, open purchase orders, VAT and payroll dates, ad spend, loan repayments and supplier deposits. Two rules of thumb: count only the receipts you would bet on, and count every outflow you are contractually on the hook for, even the distant ones.
Treating an unconfirmed purchase order or a pipeline deal as cash is the classic error. That is how a 13-week forecast becomes a wish list. For a fuller picture of what cash flow forecasting actually means, see our guide.
A spreadsheet or a cash flow tool both work. The forecast only helps if you read it before you place the order, not after.
What to do before you place your next order
Run the economic order quantity for your top five sellers and write the numbers down. Three inputs per product (annual demand, ordering cost, holding cost) is enough for a first pass.
Build one 13-week cash cap covering the next four weeks of ordering, then order the smaller of the two figures every time. Recut both numbers monthly, because demand and holding cost both move.
If the cap sits well under the EOQ, split the order across two deliveries or ask your supplier for longer payment terms. Do not spend the buffer that keeps payroll safe.
Then read more on cash flow forecasting for Shopify, stock cover, supplier payment terms and purchase order planning, and try the calculators.
Cushion is one place where the cash forecast sees the stock and the stock plan sees the bank, reading bills, balances and payment terms through read-only connections to Shopify, Xero and QuickBooks. Join the waitlist.
FAQs
Does the economic order quantity formula include cash?
No. It takes annual demand, ordering cost and holding cost only. There is no input for your bank balance, overdraft or payment terms.
What is a sensible cash cap for a stock order?
It is what is left after the next 13 weeks of committed outflows and a buffer you refuse to touch. In the worked example that was £12,000, or about 545 units.
Should I ever order more than the EOQ?
Yes, for a one-off reason such as a genuine volume discount or factory shutdown. Check the bigger order against your cash cap, not the formula.
How often should I recalculate?
Recalculate the EOQ monthly for top sellers and quarterly for the rest. Recalculate the cash cap weekly, because it moves faster.
Does the economic order quantity formula include cash?
No. The economic order quantity formula takes just three inputs: annual demand, ordering cost and holding cost. There is no field for your bank balance, your overdraft, or the payment terms your supplier has given you. So it answers a cost question, not a funding question. That is precisely why it can recommend an order you cannot actually pay for. Treat it as a cost benchmark, not permission to spend.
What is a sensible cash cap for a stock order?
So what can you actually spend? Your cash cap is whatever is left after the next 13 weeks of committed outflows and a buffer you refuse to touch. In the worked example, that was £12,000, about 545 units. The buffer matters more than the exact number. Two to four weeks of fixed costs is a common starting point for a small brand. Choose it deliberately, then treat the remainder as the ceiling for any single stock order.
Should I ever order more than the EOQ?
Yes, sometimes. A bigger order can make sense for a one-off reason: a genuine volume discount, a factory shutdown, a shipping rate you can lock in, or a product you know sells out. But test it against the cash cap, not the EOQ. If the larger order breaks your buffer, the discount is being paid for with risk. Ask what the saving is worth against a missed payroll or a supplier bill. If the answer is not clear, split the order or wait.
What if the cash cap says I can barely order anything?
If the cap leaves you barely able to order, that is information, not a verdict. It usually means cash is leaving faster than it arrives, or that too much of it is already sitting in stock you own.
So look at the causes before you shrink the order. Chase what customers owe you, since late receivables are often the quickest cash to free. Renegotiate supplier payment terms. And clear slow-moving stock before you buy more of anything.
Cutting the order is a symptom fix. Fix the cash going out and the cash stuck on shelves, and the cap rises on its own.
How often should I recalculate the economic order quantity?
Once the cash cap looks workable, set a review rhythm rather than recalculating everything constantly. Run the economic order quantity monthly for your top sellers and quarterly for the rest. Demand and holding cost drift, and holding cost shifts fastest when storage gets tight. Recalculate the cash cap weekly, though. It moves far faster than the EOQ ever will, because receipts, bills and payment dates change weekly.
Do I need software to run a 13-week cash forecast?
Not to start. A spreadsheet with one column per week and rows for receipts and outflows will run a 13-week forecast for a handful of SKUs, and the weekly recut you just read about takes minutes. Software starts earning its keep when you are juggling many products, supplier terms and payment dates at once, and when the cash picture and the stock plan keep drifting apart. Until then, the spreadsheet is the cheaper, clearer tool.
Conclusion
EOQ gives you the order size that minimises holding and ordering costs, but it says nothing about whether you can afford to place that order this month. The cash cap does. Run both numbers, compare them in a simple table, and let the lower one set the order. And when the cap looks tight, treat that as information rather than a verdict: chase receivables, renegotiate payment terms, clear slow stock, and the cap rises.
The next step is straightforward. Build a simple 13-week cash forecast in a spreadsheet this week, recut it every Friday, and let it sit beside your stock plan. When you want those two views in one place, Cushion connects your cash forecast and stock plan so each sees the other. Join the waitlist at /waitlist.
Your next order can be both economic and affordable. You just need to see the cash before you commit.



