Open-to-Buy Planning for a Small Fashion Business

Open-to-buy answers a practical question: after planned sales, markdowns, inventory targets, goods already on order, and open commitments, how much additional inventory may the buyer consider purchasing?

It is not a bank balance, profit forecast, purchase order, or permission to spend. A mathematically positive OTB can coexist with weak cash, late inventory, excessive units, poor category balance, or commitments recorded on a different cost basis.

The value comes from a disciplined monthly reconciliation and a buyer who can explain every assumption.

Pick one basis and label it

An OTB plan can be maintained at retail value or cost. Do not combine them in the same formula. If the plan is at retail, on-order and open purchase orders need a comparable retail value using an approved markup assumption. If it is at cost, sales and markdown effects require compatible cost treatment.

State whether figures include tax, freight, duties, discounts, returns, shrink, transfers, consignment, marketplace inventory, or goods in transit. Record currency and exchange-rate date. A small business may start with one basis, but it still needs documented conversions to cash and margin.

The basic retail-basis planned-purchase equation is:

planned sales + planned markdowns + planned ending inventory − beginning inventory

Available OTB then subtracts inventory already on order and open purchase-order commitments according to the company’s defined policy. Some systems and organizations structure timing differently, so document the formula used and reconcile it to the general ledger and inventory system.

Build a clean beginning inventory

Beginning inventory must reflect what the business actually controls at the period boundary. Reconcile point-of-sale, ecommerce, warehouse, store, returns, damaged goods, samples, consignment, transfers, and goods in transit. Investigate negative stock and stale variants.

The Census Bureau’s Monthly Retail Trade definitions describe merchandise inventories as the value of goods held for sale at period end and explain that an inventory-to-sales ratio relates inventory to a month of sales. National estimates are not a boutique target, but they demonstrate why valuation basis and timing need definitions.

Shopify’s current Inventory reports include month-end snapshots, inventory value, daily sales, sell-through, remaining inventory, adjustment history, and ABC analysis. Platform metrics have date ranges, processing delays, and plan-specific availability. Export the underlying records and reconcile exceptions before using them in OTB.

Plan sales by category and channel

Start with a category-month plan, then roll up. A single store total can hide too much outerwear and too little knitwear. Use historical sales where comparable, current selling, seasonality, confirmed events, channel capacity, and known closures or launches.

Separate base, low, and high cases. Document which sales are full-price, promotional, marketplace, wholesale, preorder, or pop-up. Returns should be recognized consistently with the plan’s sales definition.

The Census Bureau publishes current Monthly Retail Trade time series, including clothing and clothing-accessories stores, plus inventory and sales reports. Use these as external context, not as a substitute for the business’s own category, customer, climate, and channel data. Government series are revised and have sampling limitations.

Plan markdowns as a decision, not a leftover

Markdowns reduce expected inventory value and margin. Plan them by category, reason, timing, and owner. Distinguish temporary promotions, permanent markdowns, employee discounts, damaged inventory, and clearance.

Public company filings illustrate why markdown judgment matters. SEC-filed retail disclosures commonly explain that inventory valuation and gross margin depend on estimates of demand, age, markdown timing, and shrink. A small business does not need a public-company accounting system, but it should not hide expected markdowns outside the buying plan.

Review aged inventory, weeks of supply, size fragmentation, sell-through, return reasons, and exit options. A markdown plan is not evidence that a product will sell at the reduced price.

Set an ending-inventory target

Ending inventory should support the next period’s planned sales and assortment needs without treating every category alike. Consider lead time, reorder ability, minimums, delivery reliability, presentation minimums, size curves, safety stock, shelf life, seasonality, and cash.

The Census Bureau’s Monthly Retail Trade Inventories Report publishes inventory and inventory-to-sales estimates with reliability materials. A boutique should create its own target by category and track forecast error. An aggregate national ratio cannot determine the correct stock for an independent LA retailer.

Use units alongside value. A high-value accessory can distort dollar inventory while a low-cost basics category has a unit shortage. Review breadth, depth, sizes, and locations.

Record commitments before they become surprises

The OTB ledger needs every approved purchase order, deposit, in-transit order, cancellation, backorder, and amendment. Record expected receipt month, currency, terms, incoterm where relevant, landed-cost assumption, cancellation right, and owner.

Do not subtract only the deposit. The full commitment matters to inventory planning, while cash planning needs the payment schedule. Reconcile supplier confirmations and the system weekly during volatile periods.

If a delivery moves from October to November, move the receipt and revisit both months. Do not merely change a date to make October OTB appear available.

Add the cash and margin views

A retail-basis OTB figure needs a planned cost conversion. Then map deposits, balances, freight, duties, taxes, and operating cash. Compare with available cash and approved credit after payroll, rent, marketing, returns, and other obligations.

Model initial margin, expected markdowns, returns, channel fees, and landed cost. Buying more because OTB is positive can still reduce cash and margin if the assortment is weak.

Keep the invoice and payment workflow separate from editorial or planning automation. For FashionMember, this project never reads or changes the existing invoice system.

Our fictional six-month plan

FashionMember created content/data/FM-131-open-to-buy-plan.csv and the deterministic script scripts/fm131-open-to-buy.php. The six invented rows use a retail basis and calculate planned purchases and available OTB after on-order inventory and open purchase orders.

The fictional total planned purchases equal $302,400 and fictional available OTB equals $153,300. Five months route to review-ready because the invented data-reconciliation and owner fields are present. February routes to hold because its data is not reconciled.

Those totals are not cash, profit, credit, a demand forecast, inventory valuation, purchase authorization, or recommendation. They omit units, category mix, cost conversion, payment timing, returns, cancellations, receipts, taxes, and actual commitments. The numbers exist only to make the arithmetic inspectable.

Run a weekly exception meeting

Update actual sales, returns, markdowns, receipts, cancellations, and commitments. Compare plan and actual by category and channel. Investigate the largest dollar and unit variances. Record decisions and owners.

Use AI for bounded support: normalize exports, flag stale purchase orders, summarize variances, and generate questions. Keep formulas deterministic and visible. Do not let a model change sales plans, cancel orders, contact suppliers, or authorize purchases.

Measure whether OTB improves forecast error, aged inventory, full-price sell-through, cash predictability, and buyer workload over complete seasons. Avoid declaring success because one month ended under budget.

A small fashion business does not need a complicated planning platform to benefit. It needs consistent definitions, reconciled commitments, category judgment, and the discipline to separate available OTB from money it can safely spend.

Sources and verification

• U.S. Census Bureau: Monthly Retail Trade definitions — official inventory and inventory-to-sales definitions and valuation context.
• U.S. Census Bureau: Monthly Retail Trade Inventories Report — current official inventory, ratio, adjustment, and reliability resources.
• U.S. Census Bureau: Monthly Retail Trade time series — current official clothing-store and broader retail sales series.
• U.S. Census Bureau: Annual Retail Trade Survey — official sales, purchases, inventories, margins, expenses, and benchmark context.
• Shopify: Inventory reports — current first-party snapshots, sell-through, remaining inventory, adjustment, and ABC report definitions.
• SEC filing example: Merchandise inventory and markdown judgment — primary issuer disclosure illustrating inventory, demand, markdown, and gross-margin estimation; not a boutique benchmark.