Five Inventory Questions Every Retail CFO Should Ask

Question one: what investment are we actually carrying?

Start with owned inventory at a defined cost basis and date, then separate open purchase commitments. The worked business holds $120,000 owned stock at cost and has $40,000 open orders. Together they describe $160,000 of held-plus-committed merchandise exposure, not $160,000 of immediately payable cash or a balance-sheet inventory figure.

Core provides the financial-plan and commitment context; Atlas supports analysis on consistent fields. Payment terms, taxes, freight treatment and settlement timing still need the finance ledger. A merchandise snapshot should inform the cash discussion without pretending to replace a dated cash-flow forecast.

Question two: how much aged stock is inside that balance?

Of the $120,000 held stock, $30,000 meets the example’s agreed age definition, 25% of the total. This is a subset, not another $30,000 to add to the exposure. Age alone does not determine an accounting write-down, because expected selling, condition, price and finance policy still matter.

Within that aged subset, a particular option has 300 units at $50 cost, $15,000. Its remaining-window demand is 180 units, leaving 120 projected excess at $6,000 cost. That $6,000 is inside the $15,000 option and the $30,000 aged balance; it must not be added as a separate holding.

Question three: what markdown assumption funds the exit?

At an assumed $100 full price, the option’s unit product GP is $50. A proposed $80 selling price gives $30 GP, so each sale moved from the original price reduces GP by $20 at the unchanged cost. If 120 units all sell at $80 rather than $100, the price effect is $2,400.

That is a conditional price comparison, not proof that a discount creates 120 incremental sales or an approved valuation adjustment. Core’s planning context can show the change in realised-price assumptions. Atlas can support the subsequent outcome review without treating projected GP as money already earned.

Question four: are local forecast errors hiding inside the total?

For a separate completed test, one line was forecast at 100 and sold eighty; another was forecast at 100 and sold 120. Combined forecast and actual both equal 200, but the opposite local errors sum to forty absolute units, or 20% of actuals. This 20% measure is weighted absolute percentage error (WAPE), not directional bias. Aggregate agreement has not eliminated product-level error. A single completed window does not establish persistent bias; review signed errors across comparable periods to assess a repeated tendency to overforecast or underforecast.

The CFO needs this decision-grain view because local overbuy and underbuy can coexist. Keep the evaluation horizon, available-stock context and forecast cutoff explicit. The completed forecast test is separate from the current aged option; it does not prove why that option accumulated or quantify the sales it missed.

Question five: what room remains after commitments?

Assume the approved future intake-cost envelope is $50,000 for a defined period and the $40,000 open orders are all commitments against it. Remaining OTB is $10,000. A new $12,000 proposal exceeds that room by $2,000 unless an accepted change or additional approved funding alters the basis.

Core connects the budget, MFP/WSSI and buying comparison. Do not subtract the $40,000 again if a displayed OTB balance already includes it. Equally, do not call the difference a confirmed cancellation saving: an unaccepted proposal to reduce an order has not yet released financial capacity.

Keep the five answers connected but non-additive

The held balance, aged subset, projected excess, markdown price effect, forecast error and future OTB describe related questions on different bases. Their values are not components of one loss total. A clear CFO review states which are current assets, future commitments, subsets, scenario effects or retrospective measures.

Atlas supports the analysis and Core the planning response. Reconcile product totals to the finance basis before presenting them as comparable. An attractive dashboard can otherwise count the same exposure several times or mix a stock value with a projected margin effect and an unaccepted buying proposal.

Ask for the next decision as well as the number

For this example, the next actions are to review the aged option’s remaining demand and price, investigate local forecast errors and resolve the $2,000 funding gap before any new commitment. Each needs an owner, a deadline and evidence. None is a disposal, markdown or order change executed by the article.

Merchmix Core and Atlas connect the inventory investment to the choices finance needs to understand. The CFO should be able to trace every headline back to its scope and see which decision would change it, without confusing a useful estimate with an accounting outcome or cash already recovered.

Common questions