Maintenance Backlog Capacity & Recovery Planner
Translate executable backlog into crew-weeks, recovery capacity, target gaps, and skill constraints.
Open toolInventory economics · Analyzer
E&O Inventory Exposure Analyzer
Separate excess/obsolete quantity risk from economic exposure, carrying burden and accounting judgments, then rank inventory items by the action that deserves review first.
Deterministic methodology · Explicit assumptions · No raw plant inputs sent to analytics
Excess and obsolete inventory is not just an aging-report problem. Exposure can build when usable on-hand plus unavoidable commitments exceed defensible future demand, or when engineering and product-lifecycle changes reduce the chance that inventory will ever be consumed as planned.
This analyzer separates three questions that are often mixed together: how much quantity is operationally at risk, how much economic value remains exposed after a credible recovery path, and how much additional carrying burden accumulates if the inventory remains unresolved. It does not convert those outputs into an accounting reserve or write-down percentage.
How the E&O exposure model works
- For each item, calculate available committed supply as usable on-hand quantity plus only the purchase or production commitments that cannot realistically be canceled, returned or redirected.
- Calculate quantity at risk as max(0, usable on-hand + non-cancelable commitments − defensible future demand). Lifecycle status is displayed as decision context but does not multiply quantity or value by an arbitrary obsolescence percentage.
- Calculate at-risk carrying value as quantity at risk × unit carrying value. This is the value attached to the operationally at-risk quantity, not an accounting write-down recommendation.
- Calculate entered recoverable value as quantity at risk × credible recoverable value per at-risk unit. Recovery can represent reuse, return, resale or salvage, but feasibility and timing must be validated outside the calculator.
- Calculate economic exposure after entered recovery as max(0, at-risk carrying value − recoverable value). The floor at zero prevents an entered recovery assumption from creating a modeled accounting gain.
- Calculate carrying burden as at-risk carrying value × annual carrying rate × review-horizon years. The carrying rate is supplied by the user from company policy or documented cost components; the tool does not insert an industry default.
- Rank items by unrecovered economic exposure plus carrying burden so the largest management exposure is reviewed first. Lifecycle context is used only as a tie-breaker when the economic priority impact is equal.
- Compare recover/return/salvage, dispose-now and retain-through-horizon scenarios using the entered economics. These comparisons support disposition discussion; they are not journal entries, reserve calculations or GAAP/IFRS conclusions.
Worked example: three-item E&O review
The prefilled example reviews three items using a 22% annual carrying-rate assumption over 12 months. Controller module A has 110 units at risk and Legacy drive C has 55; Sensor B has no excess under the entered demand horizon. Portfolio quantity at risk is 165 units, at-risk carrying value is 16,500 USD, entered recoverable value is 4,400 USD, economic exposure after recovery is 12,100 USD, and modeled carrying burden is 3,630 USD. Legacy drive C ranks first because its unrecovered exposure plus carrying burden is largest. The recovery scenario ranks ahead of disposal and retention under the entered assumptions, but that ranking is an economic decision aid—not an accounting write-down.
Assumptions and limitations
- Future demand quality is the most important upstream assumption. Forecast error, substitutions, service obligations, engineering changes and end-of-life decisions can materially change quantity at risk.
- Only genuinely unavoidable commitments should be included. Flexible purchase orders, transferable materials or returnable supply can overstate exposure when treated as non-cancelable.
- Unit carrying value, recoverable value and disposal cost must use a consistent currency and valuation basis appropriate to the decision. The tool does not reconcile book, standard, replacement or market value.
- The annual carrying rate is a planning input, not a benchmark. Use company policy or documented components and avoid double counting costs already represented elsewhere.
- Lifecycle status is context, not a write-down schedule. An active item can still have excess quantity, and a discontinued item does not automatically imply a 100% write-down.
- Disposition scenarios assume entered recovery and disposal economics are attainable. Validate contractual, regulatory, quality, tax and operational constraints before acting.
- The result is management decision support. Finance and accounting should determine any reserve, lower-of-cost/NRV treatment, impairment or write-off under the organization’s applicable policies and standards.
Frequently asked questions
Is quantity at risk the same as obsolete inventory or a write-down?
No. Quantity at risk is an operational screen based on supply versus defensible future demand. Obsolescence classification and any accounting reserve or write-down require additional lifecycle, recovery and finance/accounting judgment.
Should open purchase orders always be included as commitments?
No. Include only quantities you genuinely cannot cancel, return or redirect before they become exposure. Treating flexible supply as non-cancelable can materially overstate E&O risk.
What demand horizon should I use?
Use a horizon that is defensible for the item and decision: for example remaining product demand, service obligations, an approved phase-out window or another documented consumption period. The calculator deliberately does not impose a universal number of months.
Where should the inventory carrying rate come from?
Use an approved company rate or a documented build-up of relevant carrying-cost components. Do not use the 22% worked-example value as an industry benchmark.
Why is carrying burden separate from economic exposure?
Economic exposure measures the at-risk carrying value that is not covered by the entered recovery assumption. Carrying burden is the additional cost of continuing to hold that at-risk value through the selected review horizon. Keeping them separate reduces double counting and makes the decision logic explicit.
What if expected salvage or return value exceeds carrying value?
The analyzer floors unrecovered economic exposure at zero and raises a warning. It does not recognize a gain; validate the recovery estimate and let finance/accounting determine the appropriate treatment.
Can I use this instead of an ERP or inventory-aging report?
It is designed as a focused decision layer, not an inventory system of record. Use ERP, MRP or warehouse data to build trustworthy item inputs, then use this model to make the quantity/value assumptions and disposition tradeoffs explicit.