Academy/Module 3

Expense Modelling

How much inventory can you actually afford to reorder?

Lesson 5 of 7 3 min

Reordering stock is the biggest single cash decision most store owners make each month — and the easiest one to get wrong. Order too little and you sell out; order too much and your cash is trapped on a shelf while rent, ads and payroll still need paying. Here's how to size it — starting with the question that actually drives the number: what does it cost you just to restock each month?

First question: what does restocking cost each month?

Restocking isn't a one-off — it's a recurring cost. Every month you repurchase roughly what you sold, just to keep the shelves full. So before you ask "can I afford a big reorder?", pin down the recurring number: your monthly repurchase cost. The clean way to project it is to push this month's sales onto next month's costs.

The monthly repurchase cost
  • Next month's restock = units sold this month × average purchase cost per unit
  • That keeps inventory level — you simply rebuy what you sold
  • To grow stock on purpose, multiply by an uplift (e.g. ×1.1 for +10%)

It's exactly the logic a forecast uses to project cost of goods forward: last month's unit sales set this month's restock bill. Here it is across a few months:

B4=B2*B3 (this month's units × purchase cost)
JanFebMarApr
Units sold8209101,050980
Avg purchase cost (€)14141414
Restock cost (€)11,48012,74014,70013,720
Repurchase cost — sell 820 units in January at €14 cost, and you'll spend €11,480 restocking (next month) just to stay level. The cost tracks last month's sales automatically instead of being a guess.

Sell more, and the restock rises with it; sell less, and it falls. If you'd rather build inventory up than just hold it level, multiply by a growth factor:

B4=B2*B3*1.1 (+10% to grow stock)
JanFebMar
Restock to hold level (€)11,48012,74014,700
Growth factor1.101.101.10
Restock to grow +10% (€)12,62814,01416,170
Growing on purpose — multiply by a growth factor to end each month with more stock than you sold. The extra €1,148 in January is the cash cost of building inventory, on top of holding level.

That recurring number is the backbone of every inventory decision — the one figure your cash-flow plan should carry forward each month.

The same projection, without the monthly rebuild

Doing this by hand means re-pulling last month's unit sales and recomputing the restock line every month. Foreqast makes it a built-in driver: cost of goods is projected as previous-month orders × average purchase cost, fed by your real Shopify order volume, so the restock line moves with demand on its own. Change the purchase cost or a growth assumption and every future month updates — and the projected cash-balance line shows at a glance whether a reorder keeps you above your buffer. Here's the same example inside the app:

Forecast Jan 26Feb 26Mar 26Apr 26May 26
Revenue47,56052,78060,90056,84059,160
Shop revenue Σ orders × AOV€47,560€52,780€60,900€56,840€59,160
Orders Shopify8209101,0509801,020
Avg order value Shopify€58€58€58€58€58
Cost of goods11,20011,48012,74014,70013,720
COGS (restocking) Σ prev-month orders × €14€11,200€11,480€12,740€14,700€13,720
Avg purchase cost Manual€14€14€14€14€14
The Foreqast forecast — cost of goods is a driver: previous-month orders × €14. April's projected €14,700 restock is simply March's 1,050 Shopify orders flowing through a month later — the forecast carries it forward with no manual rebuild.

Know your safe reorder before you place it

Foreqast ties your restocking to real order volume and shows the cash-balance impact of any order — so you never trap cash you'll need.

Get early access →

No credit card required.

Prefer to read this on its own? Open the full article.