Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Months of Cover: Which SKUs Are Sitting on Excess?LabFree
  2. The Base Table: Stock, Open POs, Forecast & Last SaleLab Locked
  3. Coverage With and Without Open Purchase OrdersLab Locked
  4. Excess Units & Value at Cost by CategoryLab Locked
  5. Ageing by Receipt Layers: 0–6 to 24+ MonthsLab Locked
  6. No Movement: Days Since Last Sale & Dead StockLab Locked
  7. Obsolescence Triggers: From Rule Table to StatusLab Locked
  8. Successor Mapping: Demand Moving to the New SKULab Locked
  9. Open POs: What Can Still Be Cancelled?Lab Locked
  10. Reserve Matrix: Age Bucket × StatusLab Locked
  11. Reserve Roll-Forward: Opening to ClosingLab Locked
  12. Recovery Channels: Net Recovery per UnitLab Locked
  13. Best Channel per SKU with MAX and INDEX/MATCHLab Locked
  14. Keep or Sell Now: Holding Cost vs Price DeclineLab Locked
  15. Markdown Path: Price Steps & Cash RecoveredLab Locked
  16. Write-Down Scenarios: Low, Base & High DemandLab Locked
  17. Root Causes: Where the Excess Came FromLab Locked
  18. Prevention: Minimum Order Quantities & Last-Time BuysLab Locked
  19. E&O Trend: Monthly Value & Share of InventoryLab Locked
  20. Final Project: The E&O DashboardLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy