Act on the result
Compare the target-unit gap with remaining stock and the time left in the selling period.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Retailers deciding whether inventory needs replenishment, promotion or markdown action.
Outputs
Available, sold and remaining units, sell-through, inventory value, gross margin and target sales gap.
Start here
Enter beginning units and receipts, then reconcile sold units before choosing a target sell-through rate.
Use a different tool when: Do not use this to compare annualised gross margin earned with average inventory investment; use Gross Margin Return on Inventory Planner for that decision. Use this tool to set a sell-through target before markdown or replenishment decisions.
Commerce & operations
Retail Sell-through: available
Available, sold and remaining units, sell-through, inventory value, gross margin and target sales gap.
Amounts use the same currency as your inputs. No currency conversion is performed.
Retail Sell-through
Use your own inventory and commercial records on one consistent cohort, period, valuation and tax basis.
Your numbers stay in this browser
Usable units held at the start of the cohort period.
Whole units added to the cohort during the period.
Whole units sold from the available cohort.
Measured selling price applied to sold units. Use one consistent ex-tax currency basis.
Inventory cost assigned to each unit. Use one consistent ex-tax currency basis.
Whole observed days in the cohort period.
Enter your own cohort target; this is not a demand forecast.
Decision result
Review the inventory result and its component rows on one consistent period and quantity basis.
- Available units
- 150
- Sell-through rate
- 60%
- Remaining units
- 60
- Remaining inventory cost
- 1,200.00
- Sales revenue
- 4,500.00
- Gross margin
- 2,700.00
- Target units sold
- 105
- Additional units to target
- 15
- Observed units sold per day
- 3
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Entered scenario0.60Baseline
Lower Target sell-through rate0.600.00
Higher Target sell-through rate0.600.00
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Available units
Available units
beginning units + units received150 unitsResult150
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Available unitsBeginning Units
- 100
- Available unitsUnits Received
- 50
- Available unitsUnits Sold
- 90
- Available unitsSelling Price Per Unit Ex Tax
- 50
- Available unitsUnit Cost Ex Tax
- 20
- Available unitsElapsed Days
- 30
- Available unitsTarget Sell Through Rate
- 0.7
Sell-through rate
Sell-through rate
units sold / available units0.6 decimal rateResult60%
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Sell-through rateBeginning Units
- 100
- Sell-through rateUnits Received
- 50
- Sell-through rateUnits Sold
- 90
- Sell-through rateSelling Price Per Unit Ex Tax
- 50
- Sell-through rateUnit Cost Ex Tax
- 20
- Sell-through rateElapsed Days
- 30
- Sell-through rateTarget Sell Through Rate
- 0.7
Remaining units
Remaining units
available units − units sold60 unitsResult60
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Remaining unitsBeginning Units
- 100
- Remaining unitsUnits Received
- 50
- Remaining unitsUnits Sold
- 90
- Remaining unitsSelling Price Per Unit Ex Tax
- 50
- Remaining unitsUnit Cost Ex Tax
- 20
- Remaining unitsElapsed Days
- 30
- Remaining unitsTarget Sell Through Rate
- 0.7
Remaining inventory cost
Remaining inventory cost
remaining units × unit cost1,200 , ex taxResult1,200.00
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Remaining inventory costBeginning Units
- 100
- Remaining inventory costUnits Received
- 50
- Remaining inventory costUnits Sold
- 90
- Remaining inventory costSelling Price Per Unit Ex Tax
- 50
- Remaining inventory costUnit Cost Ex Tax
- 20
- Remaining inventory costElapsed Days
- 30
- Remaining inventory costTarget Sell Through Rate
- 0.7
Sales revenue
Sales revenue
units sold × selling price per unit4,500 , ex taxResult4,500.00
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Sales revenueBeginning Units
- 100
- Sales revenueUnits Received
- 50
- Sales revenueUnits Sold
- 90
- Sales revenueSelling Price Per Unit Ex Tax
- 50
- Sales revenueUnit Cost Ex Tax
- 20
- Sales revenueElapsed Days
- 30
- Sales revenueTarget Sell Through Rate
- 0.7
Gross margin
Gross margin
units sold × (selling price − unit cost)2,700 , ex taxResult2,700.00
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Gross marginBeginning Units
- 100
- Gross marginUnits Received
- 50
- Gross marginUnits Sold
- 90
- Gross marginSelling Price Per Unit Ex Tax
- 50
- Gross marginUnit Cost Ex Tax
- 20
- Gross marginElapsed Days
- 30
- Gross marginTarget Sell Through Rate
- 0.7
Target units sold
Target units sold
available units × target sell-through rate105 unitsResult105
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Target units soldBeginning Units
- 100
- Target units soldUnits Received
- 50
- Target units soldUnits Sold
- 90
- Target units soldSelling Price Per Unit Ex Tax
- 50
- Target units soldUnit Cost Ex Tax
- 20
- Target units soldElapsed Days
- 30
- Target units soldTarget Sell Through Rate
- 0.7
Additional units to target
Additional units to target
maximum of zero and target units less sold units15 unitsResult15
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Additional units to targetBeginning Units
- 100
- Additional units to targetUnits Received
- 50
- Additional units to targetUnits Sold
- 90
- Additional units to targetSelling Price Per Unit Ex Tax
- 50
- Additional units to targetUnit Cost Ex Tax
- 20
- Additional units to targetElapsed Days
- 30
- Additional units to targetTarget Sell Through Rate
- 0.7
Observed units sold per day
Observed units sold per day
units sold / elapsed days3 units/dayResult3
Uses the exact shared engine result and user-entered inventory records or scenarios. Raw engine precision is retained until display; whole-pack rounding occurs only in the engine.
Retail Sell-through Planner formulas →Inputs used by these formula steps
- Observed units sold per dayBeginning Units
- 100
- Observed units sold per dayUnits Received
- 50
- Observed units sold per dayUnits Sold
- 90
- Observed units sold per daySelling Price Per Unit Ex Tax
- 50
- Observed units sold per dayUnit Cost Ex Tax
- 20
- Observed units sold per dayElapsed Days
- 30
- Observed units sold per dayTarget Sell Through Rate
- 0.7
Inputs used
- Beginning units
- 100
- Units received
- 50
- Units sold
- 90
- Selling price per unit
- 50.00
- Unit cost
- 20.00
- Elapsed days
- 30
- Target sell-through rate
- 70%
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| beginningUnits | Usable units held at the start of the cohort period. | whole units/cohort period | 0 to 100000000 | Required | 100 |
| elapsedDays | Whole observed days in the cohort period. | whole elapsed days/cohort period | 1 to 100000 | Required | 30 |
| sellingPricePerUnitExTax | Measured selling price applied to sold units. Use one consistent ex-tax currency basis. | currency units/unit, ex tax | 0 to 10000000 | Required | 50 |
| targetSellThroughRate | Enter your own cohort target; this is not a demand forecast. | decimal fraction of available cohort units sold | 0 to 1 | Required | 0.7 |
| unitCostExTax | Inventory cost assigned to each unit. Use one consistent ex-tax currency basis. | currency units/unit, ex tax | 0 to 10000000 | Required | 20 |
| unitsReceived | Whole units added to the cohort during the period. | whole units/cohort period | 0 to 100000000 | Required | 50 |
| unitsSold | Whole units sold from the available cohort. | whole units/cohort period | 0 to 100000000 | Required | 90 |
Retail Sell-through: available
Use sell-through only after reconciling the full available inventory pool; units received alone are not the denominator when beginning stock exists.
Formula summary
- Primary formula
- units sold / available units.
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest lower unit revenue, higher unit cost and a stricter target before replenishing or marking down.
When this estimate can be misleading
- Use one consistent inventory cohort, planning period, valuation basis and ex-tax currency basis where money applies.
- Targets, prevention rates and planned values are user-entered scenarios, not benchmarks or demand forecasts.
- Operational feasibility flags identify the entered constraints; they do not guarantee supplier availability or sales.
- This is educational business decision support, not accounting, tax, legal or financial advice.
- Use sell-through only after reconciling the full available inventory pool; units received alone are not the denominator when beginning stock exists.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- Markdown Timing and Margin Recovery
Compare the contribution recovered by a markdown with holding cost, sell-through evidence and the cost of waiting.
Read guide
Frequently asked questions
How do I set a sell-through target before markdown or replenishment decisions?
Compare the target-unit gap with remaining stock and the time left in the selling period.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.