Cycle Count Plan & Frequency Template

Purpose

This template helps operations and inventory teams implement a focused cycle count program that improves inventory accuracy while minimizing labor and service disruption. It is calibrated to SKU criticality and velocity and includes a repeatable counting procedure, variance investigation form, temporary hold rules, reconciliation steps, and practical tips for running counts during service.

Scope & Definitions

• Cycle Count: A partial inventory count focused on selected SKUs, repeated on a regular cadence.
• A-items: High value, high usage, or critical-to-production SKUs that materially affect cost or guest experience.
• B-items: Moderate value and velocity SKUs that require regular review.
• C-items: Low value/low velocity SKUs that can be counted less frequently.
• Variance: Counted quantity minus expected book quantity (or variance percent = variance / book quantity).

Overview: Grouping & Recommended Frequencies

Assign every SKU to an ABC category using a combination of annual usage value (cost x annual units), recent velocity (sales or usage in POS/production), and criticality to guest experience or operations.

Adjust frequencies for seasonality, promotional periods, or supplier risk. For multi-location operations, consider location-specific ABC splits.

Sample Count Cadence (Example)

• A-items: split into smaller subsets so that a portion is counted each day (e.g., 20% of A-items daily).
• B-items: create a weekly schedule covering all B-items across the week.
• C-items: schedule one block per month or one rotating quarter to cover all C-items.

Standard Cycle Count Procedure (Step-by-step)

1. Prepare: Print count sheets or open the POS/inventory handheld list for the selected SKUs. Ensure receiving and transfers are paused for the counting area or that staff record movements during the count window.
2. Blind vs. Open Counts: Use blind counts (no book quantity) when possible to reduce bias. When blind counts are not possible, use open counts but require a second counter or supervisor verification for A-items.
3. Count: Two-person rule for A-items where practical: counter reads and records, verifier confirms. For B/C items, single counter with spot checks by supervisor is acceptable.
4. Record: Record counted quantity, location, lot code/expiry (if applicable), counter initials, date/time, and any notes (damage, packaging variance, suspect theft, etc.).
5. Immediate Actions for High Variance: If variance exceeds the defined threshold, place item on temporary hold (see rules below) and initiate investigation before adjusting book quantity.
6. Reconcile: Follow the Reconciliation Steps section below to validate and approve adjustments.
7. Document: Save count sheets and investigation records for audit trail and trend analysis.

Count Quality Controls

• Use consistent units (standard cases, eaches, weight conversions) defined in the SKU master.
• Cross-train at least two counters per location to reduce bias and errors from a single person.
• Randomize order of SKUs within a count session to prevent systematic bias from counting the same shelf position each time.
• Use POS sales hold-offs: avoid counting immediately after large deliveries or meal periods when many movements occur.

Variance Investigation Form (Template)

Use this template to capture the facts when a count variance exceeds the threshold (suggested threshold: 2-5% for A-items by value or fixed absolute thresholds such as ±2 units):

Temporary Hold Rules for High Variance Items

• When a variance exceeds the A-item threshold, mark remaining physical stock as Quarantine / Hold and flag the SKU in the POS/inventory system (if supported) to prevent further sales or transfers until resolved.
• Stop replenishment orders for the SKU until investigation completes.
• Restrict access to the counted location and require a supervisor to authorize any movement.
• If stock is needed for service, allow supervised release with documented quantities and reasons.

Reconciliation Steps (Approving Adjustments)

1. Confirm physical recount if initial variance is large or contested.
2. Review receiving records, recent transfers, and POS activity around the count time.
3. Check for lot/packaging/weight differences that could explain quantity mismatches.
4. Decide: Accept adjustment (record reason), escalate (further investigation), or reverse (if error in counting).
5. Record final approved change, approver name, and retain all investigation artifacts for at least one audit cycle.

Using POS Sales Signals to Prioritize Counts

Leverage POS and production usage data to make your counting more efficient:

• Flag SKUs with sudden spikes or drops in sales for immediate review.
• Prioritize counting SKUs with frequent promotions, high spoilage risk, or known supply variability.
• Use sales velocity to break A-item lists into daily micro-lists — count the highest-velocity A-items most often.
• Review week-over-week velocity to detect miscounts (e.g., persistent negative on-hand despite normal sales).

Running Counts Without Closing Operations

Counts can run during service if planned carefully:

• Schedule counts during predictable low-traffic windows where possible (e.g., mid-afternoon prep times).
• Count in discrete zones to avoid interfering with service lines. Communicate zones and holding rules to staff before service starts.
• Use temporary tags (counted / not counted) and clear visible signage in storage areas.
• Record any concurrent activity (ongoing receiving or transfers) and include it in the variance investigation.
• For high-volume A-items, consider short blind counts during a brief pause or at shift change with manager oversight.

KPIs and Targets

• Target inventory accuracy: A-items ≥ 98–99%, B-items ≥ 95–98%, C-items ≥ 90–95% (adapt to company risk tolerance).
• Target time-to-investigate: Initiate investigation within 24 hours of large variance for A-items.
• Track number of corrective adjustments and root-cause categories (receiving error, waste/spoilage, theft, counting error).

Implementation Checklist

1. Run ABC analysis from historical usage and cost data.
2. Build repeating count schedules and assign owners by shift/role.
3. Create printed or digital count sheets and variance forms (use the template above).
4. Train counters and approvers on blind counting, unit conversions, and hold rules.
5. Run a two-week pilot and measure accuracy and labor time.
6. Refine thresholds, frequencies, and processes based on pilot results.

Notes & Next Steps

This template preserves a practical counting approach but can be improved by turning count sheets and the variance investigation form into interactive, storable forms that capture who counted, timestamps, and attach photos or evidence. If you have an integrated POS/inventory system, map SKUs so POS events automatically flag items for priority counting.