Sell-Through & Weeks-of-Supply Calculator
Calculate sell-through, stock coverage, inventory variance, and target-unit gap.
Open toolOne Study decision-preparation calculator
Calculate how much inventory the plan still allows you to commit.
Calculate open-to-buy from planned sales, markdowns, reductions, ending inventory, beginning inventory, and current on-order commitments at retail or cost.
Calculator
Reconcile the sales plan with inventory already owned or committed.
Use one planning period and one basis throughout. A negative result means beginning inventory and on-order commitments already exceed the merchandise required by the entered sales, reductions, and ending-stock plan.
Reading the result
Treat open-to-buy as a living control, not a one-time budget.
A positive open-to-buy amount is the remaining merchandise value supported by the entered plan. A negative amount is the value by which beginning inventory and on-order commitments exceed that plan. The converted view helps connect a retail plan with its approximate cash commitment.
Before you act
The quality of the plan depends on current sales and stock records.
The result does not forecast sales, margin, cancellations, returns, shrinkage, vendor timing, cash availability, exchange rates, or assortment requirements. Update it when sales, stock, markdown, or purchase-order information changes.
FAQ
Questions this tool helps frame.
Should I calculate open-to-buy at retail or cost?
Use the basis your merchandise plan and inventory records use, and keep every input on that basis. The calculator can translate the result using the entered gross margin.
What does a negative open-to-buy result mean?
It means beginning inventory and on-order commitments are greater than the merchandise requirement created by the entered plan.
Why are markdowns and reductions added?
They reduce inventory without appearing as planned sales, so the plan needs merchandise to cover them as well.
How often should open-to-buy be updated?
Update it whenever actual sales, markdowns, inventory, cancellations, or purchase orders materially change the plan.
Working notes
Keep the formula with the assumptions.
- Open to Buy = Planned Sales + Planned Markdowns + Other Reductions + Planned Ending Inventory - Beginning Inventory - On OrderEnter every inventory amount on the selected planning basis. When using retail, the target gross margin converts the open-to-buy result to an estimated cost commitment.
- Update the result when the record changesSupplier terms, sales, stock, costs, timing, and channel deductions can change the result materially.
- Continue the operating reviewScaffold, MomentumFinancial, Source4Me
- Check the connected numbersSell-Through & Weeks-of-Supply Calculator, GMROI & Inventory Turnover Calculator, Reorder Point & Safety Stock Calculator, Cash Flow Calculator.
- Prepare the non-financial questionsSupplier Readiness Assessment, Funding Readiness Assessment.
Talk with One Study