Act on the result
Reconcile the count and recovery evidence before assigning an operational action or replacement-sales target.
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
Product businesses reconciling an inventory count difference into a net profit impact.
Outputs
Gross and net shrinkage cost, shrinkage rate and replacement sales needed at the entered contribution rate.
Start here
Value expected and counted inventory on the same date and cost basis before adding any recoverable value.
Use a different tool when: Do not use this to measure inventory turnover and target working-capital change; use Inventory Turnover Planner for that decision. Use this tool to measure the profit impact of an inventory count shortfall.
Commerce & operations
Inventory Shrinkage Impact: gross and net shrinkage cost
Gross and net shrinkage cost, shrinkage rate and replacement sales needed at the entered contribution rate.
Amounts use the same currency as your inputs. No currency conversion is performed.
Inventory Shrinkage Impact
Reconcile expected and counted inventory cost, recoverable value and the replacement sales needed to recover the net loss.
Your numbers stay in this browser
Use the recorded inventory cost expected at the count date. Use one consistent ex-tax currency basis.
Use the physical count valued on the same cost basis. Use one consistent ex-tax currency basis.
Enter insurance, salvage or other recovery attributable to this shrinkage only. Use one consistent ex-tax currency basis.
Use your own contribution rate to translate net loss into sales recovery.
Decision result
Every value is bound to the registered inventory or hospitality engine and keeps the decision components visible on one consistent basis.
- Gross Shrinkage Cost
- 100.00
- Net shrinkage cost
- 80.00
- Shrinkage Rate
- 10%
- Replacement Sales To Recover
- 200.00
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Current scenario80.00Baseline
Lower Recoverable value82.002.00
Higher Recoverable value78.00-2.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.
Gross Shrinkage Cost
Gross Shrinkage Cost
expected inventory cost − counted inventory cost100.00Result100.00
Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Inventory Shrinkage Impact Planner formulas →Inputs used by these formula steps
- Gross Shrinkage CostExpected Inventory Cost
- 1,000
- Gross Shrinkage CostCounted Inventory Cost
- 900
- Gross Shrinkage CostRecoverable Value
- 20
- Gross Shrinkage CostContribution Rate On Replacement Sales
- 0.4
Net shrinkage cost
Net Shrinkage Cost
gross shrinkage cost − recoverable value80.00Result80.00
Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Inventory Shrinkage Impact Planner formulas →Inputs used by these formula steps
- Net Shrinkage CostExpected Inventory Cost
- 1,000
- Net Shrinkage CostCounted Inventory Cost
- 900
- Net Shrinkage CostRecoverable Value
- 20
- Net Shrinkage CostContribution Rate On Replacement Sales
- 0.4
Shrinkage Rate
Shrinkage Rate
gross shrinkage cost / expected inventory cost0.1 percentResult10%
Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Inventory Shrinkage Impact Planner formulas →Inputs used by these formula steps
- Shrinkage RateExpected Inventory Cost
- 1,000
- Shrinkage RateCounted Inventory Cost
- 900
- Shrinkage RateRecoverable Value
- 20
- Shrinkage RateContribution Rate On Replacement Sales
- 0.4
Replacement Sales To Recover
Replacement Sales To Recover
net shrinkage cost / contribution rate on replacement sales200.00Result200.00
Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Inventory Shrinkage Impact Planner formulas →Inputs used by these formula steps
- Replacement Sales To RecoverExpected Inventory Cost
- 1,000
- Replacement Sales To RecoverCounted Inventory Cost
- 900
- Replacement Sales To RecoverRecoverable Value
- 20
- Replacement Sales To RecoverContribution Rate On Replacement Sales
- 0.4
Inputs used
- Expected inventory at cost
- 1,000.00
- Counted inventory at cost
- 900.00
- Recoverable value
- 20.00
- Contribution rate on replacement sales
- 0.4
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 |
|---|---|---|---|---|---|
| contributionRateOnReplacementSales | Use your own contribution rate to translate net loss into sales recovery. | currency units/planning period, ex tax | 0 to 1 | Required | 0.4 |
| countedInventoryCost | Use the physical count valued on the same cost basis. Use one consistent ex-tax currency basis. | currency units/planning period, ex tax | 0 to 10000000 | Required | 900 |
| expectedInventoryCost | Use the recorded inventory cost expected at the count date. Use one consistent ex-tax currency basis. | currency units/planning period, ex tax | 0 to 10000000 | Required | 1000 |
| recoverableValue | Enter insurance, salvage or other recovery attributable to this shrinkage only. Use one consistent ex-tax currency basis. | currency units/planning period, ex tax | 0 to 10000000 | Required | 20 |
Inventory Shrinkage Impact: gross and net shrinkage cost
Treat the net shrinkage result as a count reconciliation, not a diagnosis of theft, waste or process causes.
Formula summary
- Primary formula
- gross shrinkage cost − recoverable value
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest with no recoverable value and a lower contribution rate on replacement sales.
When this estimate can be misleading
- Demand, costs, lead times, tax and targets are user-entered scenarios; no market benchmark is embedded.
- Use one consistent item, period and ex-tax currency basis where money applies.
- This is educational business decision support, not accounting, tax, legal or financial advice.
- Treat the net shrinkage result as a count reconciliation, not a diagnosis of theft, waste or process causes.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- Inventory Count Checklist for a Reliable Stock Baseline
Prepare a controlled physical count, reconcile exceptions and preserve a reliable operational baseline without prescribing valuation treatment.
Read guide
Frequently asked questions
How do I measure the profit impact of an inventory count shortfall?
Reconcile the count and recovery evidence before assigning an operational action or replacement-sales target.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.