5.5 Cycle Counting & Reconciliation
Inventory accuracy is not a "nice to have"; it is the mathematical foundation of your entire operation. If your system says you have 100 parts and you physically have 90, you will eventually shut down the production line. If you have 110, you are over-ordering and bleeding cash. Stop relying on the "Annual Physical Inventory"—a disruptive, expensive theater that fixes nothing for the other 364 days. You must implement a continuous Cycle Counting regime that audits the process, not just the parts.
The Cycle Count Architecture (ABC Logic)
Do not count everything with equal effort. Align your labor with your risk profile. Use the ABC stratification from Section 5.1.
Frequency Rules
- Class A (High Value/Critical): Count Monthly (12x/year). These parts move fastest and carry the highest financial risk.
- Class B (Medium): Count Quarterly (4x/year).
- Class C (Low Value/Bulk): Count Annually (1x/year) OR trigger a "Count on Zero" (count when system shows < 5 units).
Sample Size Calculation
Do not guess. Calculate the daily workload to ensure completion.
- Formula: (Total A SKUs × 12) + (Total B SKUs × 4) + (Total C SKUs × 1) / 250 Working Days = Daily Count Target.
- Execution: Warehouse staff must execute these counts as the first task of the day, before picking begins.
Operational Execution (No Shutdowns)
The warehouse must remain live. Do not freeze the entire building; freeze the Bin.
- Blind Counts: The scanner/sheet must never show the expected system quantity. If the counter sees "100," they will count "100." Make them count what is there.
- Bin Freeze: During the count, the specific bin is locked in the WMS. No picks/put-aways allowed until the count is posted.
- Zero-Crossing Check: If a picker goes to a bin and finds it empty (when system says positive), this is an immediate "Emergency Count" trigger.
Discrepancy Protocol & Root Cause
When the Physical count ≠ System count, do not just "adjust it out." Follow this strict logic path to clean the data.
Step 1: The Blind Recount
- Trigger: Variance detected.
- Action: Send a different person to count the same bin immediately. Do not tell them the first result.
- Result: If Recount = System, the first counter made an error. No adjustment.
Step 2: The Transaction Audit
- Trigger: Recount confirms the variance.
- Action: Review the last 10 transactions (Receipts, Picks, Adjustments). Look for:
- Unposted receipts (material physically there, electronically pending).
- Open pick jobs (material allocated but not moved).
- Unit of Measure (UOM) confusion (e.g., counted 10 packs, system expects 100 units).
Step 3: Adjustment & Categorization (RCA)
You must assign a reason code. "Unknown" is not an acceptable category for A-Items.
Code | Category | Definition | Owner |
RC-RX | Receiving Error | Wrong qty/part received; Label does not match contents. | Receiving Lead |
RC-PK | Picking Error | Picker pulled from wrong bin or grabbed extra units. | Warehouse Manager |
RC-BM | BOM/Process | System backflushed 10, but physics required 12. (Engineering data incorrect). | Manufacturing Eng |
RC-SC | Scrap Unreported | Production damaged parts but threw them in the trash without recording. | Production Lead |
RC-VN | Vendor Variance | Sealed pack contained wrong quantity (Supplier Quality issue). | Quality/Purchasing |
Pro-Tip: If RC-BM (BOM Error) frequency exceeds 5%, your Inventory Accuracy is impossible to fix in the warehouse. You must audit the Engineering Bill of Materials.
The Outputs
1. The Cycle Count Calendar
A dynamic schedule generated by the ERP/WMS. It pushes tasks to scanners automatically. It must track "Percentage Complete" to ensure the annual plan is not falling behind.
2. Variance KPI Dashboard
- IRA (Inventory Record Accuracy): Target > 98%.
- Absolute Variance Value: Target < 0.5% of inventory value.
- Strike Rate: % of counts that required a recount. (Measures counting proficiency).
3. Corrective Action Log
A rolling document tracking recurrent errors.
- Example: "Found consistently short on 0402 resistors. Action: Calibrate reel counters in SMT area."
Final Checklist
Control Point | Setting / Rule | Non-Negotiable |
The "Trust" Rule | Verification Gate | Planners and Buyers must not trust MRP output until IRA is consistently > 95%. Before that, all critical buys require visual bin checks. |
Authority | Write-off Limits | Warehouse Lead < $50; Ops Manager < $500; Finance Director > $500. |
Discipline | Blind Counts | Never display system quantity on the count sheet/scanner. |
Timing | Daily Routine | Counts happen Daily. If you batch them to the end of the month, you will fail. |
Feedback | Loop to Eng | BOM errors found during counts must generate an automatic ticket to Engineering. |