Tabellab

Cycle Counting & Inventory Accuracy: Count Classes, Count Calendars, Tolerances, Recounts, Variance Value, Root Causes, Location Checks, Adjustments, Shrink & an Accuracy Dashboard

Work through 20 hands-on labs at a fictional electrical wholesaler's distribution centre – measure record accuracy, build count classes and a count calendar, set tolerances, run recounts, value and explain variances, check locations, approve adjustments, track shrink and build an inventory accuracy 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

This course follows a fictional electrical wholesaler's distribution centre through a year of cycle counting. In 20 hands-on spreadsheet labs you compare book and counted quantities, measure hit rate, unit accuracy and value accuracy, and rank SKUs by annual usage value into count classes. You turn count frequencies into a daily plan, a count calendar with working days and the team shifts needed. Later labs cover tolerances by class, recount rules, net versus absolute variance, root-cause codes, unit-of-measure checks with MOD, location audits, cut-off corrections, adjustment approvals, shrink by category, phantom stock, a control group, a wall-to-wall comparison, monthly trends and a final accuracy dashboard.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. DC Count Check: How Accurate Are Our Records?LabFree
  2. Hit or Miss: Hit Rate, Unit and Value AccuracyLab Locked
  3. Count Classes: Ranking SKUs by Annual Usage ValueLab Locked
  4. Count Frequency: Counts per Year and per DayLab Locked
  5. The Count Calendar: Next Count Dates with WORKDAYLab Locked
  6. Counting Capacity: Minutes, Shifts and Team ShiftsLab Locked
  7. Tolerances by Class: Percent and Value Must Both HoldLab Locked
  8. The Recount Rule: Which Counts Get Checked Twice?Lab Locked
  9. Variance Value: Net vs Absolute by ZoneLab Locked
  10. Root Causes: Ranking the Reasons Behind VariancesLab Locked
  11. Unit-of-Measure Errors: Packs vs Eaches with MODLab Locked
  12. Location Accuracy: Right SKU, Right BinLab Locked
  13. Cut-Off: Open Transactions at Count TimeLab Locked
  14. Adjustments: Postings and Approval LevelsLab Locked
  15. Shrink: Net Loss as a Share of ThroughputLab Locked
  16. Service Impact: Phantom Stock and Lost Order LinesLab Locked
  17. A Control Group: Repeat Counts and Process Error RateLab Locked
  18. Cycle Counting vs a Wall-to-Wall CountLab Locked
  19. Monthly Accuracy Trend by Class vs TargetLab Locked
  20. Final Project: The Inventory Accuracy 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