Excess & Obsolete Inventory by the Numbers: Coverage, Ageing, Excess Quantities, Obsolescence Triggers, Reserve Matrices, Recovery Channels, Write-Down Scenarios, Prevention & a Dashboard
Run the excess and obsolete stock review for a fictional lighting company in 20 hands-on labs – months of cover, excess units and value, ageing layers, dead stock, obsolescence triggers, PO cancellations, reserve matrices and roll-forwards, recovery channels, markdowns, write-down scenarios, root causes, prevention and a final dashboard – with every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In 20 hands-on spreadsheet labs you run the excess and obsolete (E&O) stock review for a fictional lighting company with 30 SKUs. You calculate months of cover with and without open purchase orders, excess units and their value at cost, ageing by receipt layers and days since the last sale. You turn obsolescence triggers into a status, map demand to successor products and check which open orders can still be cancelled. Then you build a reserve matrix and a roll-forward, compare recovery channels, plan a markdown path, test low, base and high demand scenarios, rank root causes, size last-time buys and finish with an E&O dashboard.
Lessons
- Months of Cover: Which SKUs Are Sitting on Excess?Free
- The Base Table: Stock, Open POs, Forecast & Last Sale Locked
- Coverage With and Without Open Purchase Orders Locked
- Excess Units & Value at Cost by Category Locked
- Ageing by Receipt Layers: 0–6 to 24+ Months Locked
- No Movement: Days Since Last Sale & Dead Stock Locked
- Obsolescence Triggers: From Rule Table to Status Locked
- Successor Mapping: Demand Moving to the New SKU Locked
- Open POs: What Can Still Be Cancelled? Locked
- Reserve Matrix: Age Bucket × Status Locked
- Reserve Roll-Forward: Opening to Closing Locked
- Recovery Channels: Net Recovery per Unit Locked
- Best Channel per SKU with MAX and INDEX/MATCH Locked
- Keep or Sell Now: Holding Cost vs Price Decline Locked
- Markdown Path: Price Steps & Cash Recovered Locked
- Write-Down Scenarios: Low, Base & High Demand Locked
- Root Causes: Where the Excess Came From Locked
- Prevention: Minimum Order Quantities & Last-Time Buys Locked
- E&O Trend: Monthly Value & Share of Inventory Locked
- Final Project: The E&O Dashboard Locked
Learner reviews
Be the first to review this course.