Search Ctrl K
Home / Tools
THE FEUTEX TOOLKIT

Retail Open-to-Buy Plan

Estimate purchase capacity from planned sales, markdowns and target ending inventory at retail value.

Ecommerce workspace● Runs in your browser
01 Your input
02 Your result
View or copy raw result data
FormulaPlanned receipts = v.sales+v.markdowns+v.ending_inventory-v.beginning_inventory ; Open to buy = v.sales+v.markdowns+v.ending_inventory-v.beginning_inventory-v.on_order
Sources and model references

Worked example

Inputs

Sales
50000 currency
Markdowns
5000 currency
Ending inventory
80000 currency
Beginning inventory
90000 currency
On order
10000 currency

Expected results

Planned receipts
45000 currency
Open to buy
35000 currency

Load the example in the workspace to reproduce these results. Display rounding does not change the underlying calculation.

How to use this tool

  1. Enter your own assumptions using a consistent currency and period.
  2. Review the scenario outputs and compare alternative inputs.
  3. Check the stated model limits before using the result in an operating plan.

Try this example

{
  "sales": 50000,
  "markdowns": 5000,
  "ending_inventory": 80000,
  "beginning_inventory": 90000,
  "on_order": 10000
}

Accuracy and scope

All inputs must use the same retail valuation basis. Does not convert retail value to merchandise cost or forecast demand.

Is my data uploaded?

This tool runs locally in your browser. Input and output are not sent to a processing server. Copy or download your result before leaving the page.