Guides
Your Inventory Budget Is a Calendar, Not a Number
A monthly spending ceiling tells you how much you can buy. It never tells you which week the cash actually runs out.
A monthly ceiling hides the week that hurts
Most buying budgets are a single number with a month attached: say, $8,000 for September, $12,000 for October. (Illustrative figures.) It is an easy number to hold in your head, easy to defend to whoever signs off, and easy to check an order against — add up the cart, compare it to the ceiling, done.
It is also the coarsest possible view of your own cash. A month is a bucket, and a bucket tells you nothing about where inside it the weight sits. Finance teams hit this problem long before retail buyers did, which is why the standard short-horizon tool is a 13-week cash flow forecast — a rolling weekly projection over roughly 90 days, refreshed weekly. The weekly bucket exists for exactly one reason: a monthly forecast can show positive cash for the whole quarter while hiding the single week where several large outflows land on top of each other (Float).
Inventory spending has the same shape. You can clear a monthly ceiling comfortably and still be short in week two, because the ceiling assumed your commitments were spread evenly and they never are.
Three dated facts the flat number leaves out
Three things every buyer already knows are dated, and the flat ceiling drops the date from all three.
What's already committed. Open purchase orders are dollars with a date attached — money spoken for before this cycle's list existed. Assisty's Smart Buying Table already accounts for the units on the way when it sizes a suggestion; its per-row breakdown carries an explicit "Incoming from open POs" line. The ceiling, by contrast, sees no commitment at all until the invoice arrives. Retail's open-to-buy discipline has always subtracted them first:
open-to-buy = planned receipts − on-order commitments
Open-to-buy is calculated for a specific window and refreshed weekly at minimum in season (Toolio) — a window and a refresh cadence, not a standing number.
Terms move the date. The day you place an order and the day the cash leaves are different days, and a flat ceiling implicitly assumes they are the same. Net 30 — full payment due 30 days from the invoice date — is the standard US B2B term, with net 15, 30, and 60 all common; a supplier extending terms is quietly providing you short-term financing (Corpay). Two identical orders placed the same Monday, one net 15 and one net 60, belong in different weeks of your plan.
Sell-through returns the cash. Inventory is not a permanent outflow; it is an outflow that comes back as revenue at a rate you can estimate. Assisty computes every suggestion from your sales velocity, lead times, and incoming stock — which is the same velocity that tells you roughly when a buy converts back into cash.
Same list, different order
Give the same suggestion list to a flat ceiling and to a dated curve and you get two different buys.
| Question | Flat monthly ceiling | Dated cash curve |
|---|---|---|
| What it asks | Does the cart total fit under the number? | Can I pay for this in the week the payment actually lands? |
| Open POs | Invisible until the invoice shows up | Counted as committed dollars on a known date |
| Supplier terms | Ignored — order date and payment date treated as one | The lever that moves an order into a lighter week |
| Sell-through | Not modelled; spend looks permanent | Cash returning at an estimated rate, feeding later weeks |
| Typical failure | Clears the month, short in one week | More upkeep — every date has to be maintained |
| What it changes | Trims the list at the bottom | Re-sequences the list; some orders move earlier, some later |
The practical difference is direction. A ceiling only ever cuts — its single move is fit-to-budget, deferring the least-urgent items and showing exactly what got cut. That is the right move when the constraint is genuinely the total. A curve can also pull forward: an item that would stock out in week three can be ordered now, in a week that has room, rather than deferred into the week that was already heavy.
Building the calendar out of what you already have
A selection that footers at "3 selected · 164 units · $1,276" is a number you can drop into a week — once you know which week its payment lands in. Everything up to that footer is computed for you. The week is the part you supply.
You do not need a treasury system to do this. Most of the inputs already exist in your store data; one of them does not, and it is worth being plain about which.
| Input the calendar needs | Where it comes from |
|---|---|
| How much to buy per SKU | The Smart Buying Table computes each suggestion from your sales velocity, lead times, and incoming stock, then rounds it to your case sizes and caps it at your maximum stock levels |
| Which orders can't wait a week | Findings ranked by money at stake — items that run out before a reorder can land, capital tied up in overstock — each carrying its one-tap fix |
| Which orders can wait | The same money-at-stake ranking also surfaces capital tied up in overstock — e.g. "Winter Scarf holds 240 days of stock — Plan markdown" |
| Which can't even wait for a normal reorder | Stall warnings like "Tea Sampler stalls for 6 days before restock — Expedite," with "Expedite all 3" |
| The cart total for a chosen week | The selection footer, e.g. "3 selected · 164 units · $1,276," split into one PO per supplier |
| A weekly view of demand and stock | Ask for sales, inventory, forecasting, replenishment, lost-revenue, or stock-availability reports — by product, vendor, location, or over time, from the last 7 days to year-over-year — then save or schedule it daily, weekly, or monthly |
| The payment due date per order | Yours to maintain — nothing in the buying table's selection footer or a saved report carries a payment due date. Keep it in your own column and pair it with the figures above. |
That last row is the honest boundary. The buying table prices the order and ranks its urgency; the due date is the one column it doesn't carry. Carrying it yourself — order date, terms, due date — is what turns a list of totals into a dated plan.
Nothing else here requires new work. The refresh cadence does: a scheduled weekly report keeps the demand side current, and open-to-buy's own rule is to re-run it weekly in season. A calendar you built once in January is a number again by March.
A calendar is a forecast too
Treat the cash curve the way you treat a demand forecast: a projection that is wrong in detail and useful in shape. It will not predict the exact week a payment clears. It will reliably show you the week where three commitments land together — which is the week a flat ceiling was never able to see, and the only week the budget was ever really about.