Calculate inventory obsolescence reserves using age-based tiered factors. Estimate reserves by multiplying units, cost, and aging discount rates.
An obsolescence reserve (also called E&O reserve — excess and obsolete) is an accounting provision that estimates the portion of inventory likely to become unsalable. Companies calculate this reserve using age-based tiers: the older the inventory, the higher the risk factor applied.
Typical age factors increase in steps — for example, 0% for items under 6 months old, 25% for 6–12 months, 50% for 12–18 months, 75% for 18–24 months, and 100% for items over 24 months. The reserve for each tier equals Units × Unit Cost × Age Factor.
This calculator applies a four-tier aging model to estimate total obsolescence reserve. Enter the units and unit cost for each age bracket along with the corresponding risk factor to see the total reserve amount and its percentage of total inventory value.
Supply-chain managers, warehouse operators, and shipping coordinators rely on precise obsolescence reserve data to maintain efficiency and control costs across complex distribution networks. Revisit this calculator whenever conditions change to keep your logistics plans aligned with real-world performance.
Obsolescence reserves protect financial statements from overvalued inventory and ensure timely action on aging stock. This calculator quantifies the reserve across multiple age tiers, helping controllers set appropriate provisions and giving operations teams targets for liquidation or disposal. Real-time recalculation lets you model different scenarios quickly, ensuring your logistics decisions are backed by accurate, up-to-date numbers.
Tier Reserve = Units × Unit Cost × Age Factor (%) Total Reserve = Σ(Tier Reserves) Reserve % = (Total Reserve / Total Inventory Value) × 100
Result: Total Reserve = $6,500
Tier 1 (0–6 mo): 1,000 × $20 × 0% = $0. Tier 2 (6–12 mo): 500 × $20 × 25% = $2,500. Tier 3 (12–18 mo): 200 × $20 × 50% = $2,000. Tier 4 (18+ mo): 100 × $20 × 100% = $2,000. Total = $6,500 on $36,000 inventory = 18.1%.
A well-defined policy specifies age brackets, risk factors, review frequency, and approval authority for reserve adjustments. Document the rationale for each factor and review actual write-offs annually to validate assumptions. Auditors expect consistency and evidence-based factor selection.
The reserve is a balance sheet provision — an estimate of future loss. A write-down reduces the carrying value of specific items when NRV drops below cost. A write-off removes inventory from the books entirely when it is scrapped or donated. All three work together to keep inventory valuation accurate.
The best reserve is a small one. Companies that invest in accurate demand forecasting, shorter lead times, and postponement strategies carry less excess inventory and therefore need lower obsolescence provisions. Prevention is always cheaper than writing off dead stock.
An obsolescence reserve is an accounting provision that estimates the value of inventory expected to become unsalable due to age, technology changes, or market shifts. It is recorded as a contra-asset on the balance sheet.
Age factors are typically set by finance and operations based on historical write-off patterns. A common starting point is 0% for fresh stock, 25% at 6 months, 50% at 12 months, 75% at 18 months, and 100% at 24 months.
Excess inventory exceeds foreseeable demand but may still sell over time. Obsolete inventory has no reasonable demand at any price. Both contribute to the E&O reserve but may require different disposal strategies.
Most companies update the obsolescence reserve quarterly as part of the financial close process. Fast-moving industries like electronics or fashion may update monthly due to rapid product life cycles.
Accounting reserves are not always tax-deductible until the inventory is actually disposed of or sold at a loss. Tax treatment varies by jurisdiction — consult a tax advisor for your specific situation.
Yes. The four-tier model in this calculator is a common framework, but you can adjust the age breakpoints and factors to match your company's policy. Some companies use five or six tiers for greater granularity.