Lesson 5 of 6
Cycle counting
8 min
Cycle counting replaces the big annual count with a steady rhythm of small counts. Important items are counted often, unimportant ones rarely, and every item is counted at least once a year. Plant 1710 Detroit uses it because the rotor and alternator lines run six days a week and cannot stop for a full count.
The cycle counting indicator
Each product is assigned a cycle counting indicator (for example A, B, C, D) in its plant-level data; in the classic material master it is the CC physical inventory indicator on the Plant data / storage 1 view. Each indicator is defined per plant in Customizing (transaction OMCO) with:
| Setting | Meaning | Contoso Detroit (example) |
|---|---|---|
| Number of physical inventories per fiscal year | How often items with this indicator are counted | A: 12, B: 6, C: 3, D: 1 |
| Interval | Workdays between counts, derived from the number above and the factory calendar | A: about every 20–25 workdays |
| Float time | Workdays the planned count date may vary | 5 workdays |
| Percentage | Share of consumption or requirement value used to assign the indicator in the ABC analysis | A: 50%, B: 25%, C: 20%, D: 5% |
Cycle counting indicator settings per plant.
Assigning indicators with an ABC analysis
Indicators can be set by hand, but usually an ABC analysis proposes them. MIBC (Set Cycle-Counting Indicator) analyzes consumption or requirements and assigns indicators by the percentages in OMCO. Products whose indicator must not change, such as safety-critical parts, can have the indicator fixed so the ABC run leaves them alone. At Contoso, CMC-RTR-200 and CMC-ALT-100 come out as A; packaging materials as C.
- ClassifyMIBC ABC analysis on consumption value for plant 1710
- AssignIndicators A–D written to products; fixed ones skipped
- Select due itemsPlanned count date = last count date + interval
- Create documentsReport RM07ICN1 (MICN) creates documents for items due in the selected window
- Count and postSame as any count: enter, recount, post differences; last count date updated
- MonitorOverdue items, coverage of the year, difference trends by indicator
Creating cycle count documents
The report RM07ICN1 (Create Physical Inventory Documents for Cycle Counting, transaction MICN) selects products whose planned count date falls in a chosen window. The planned count date is the date of the last physical inventory of unrestricted stock plus the indicator's interval. The report shows a control list first, with overdue items highlighted, and then creates a batch input session that generates the documents. It can include unrestricted, quality inspection and blocked stock. Contoso runs it every Monday for the coming week.
- Jan 6Rotor countedLast count date for CMC-RTR-200 in 171A set on difference posting
- Feb 3DuePlanned count date about one interval later (indicator A)
- Feb 3–10Float timeCount may happen within 5 workdays without being overdue
- Feb 11OverdueIf not counted, the item appears as overdue in the next control list
- Next cycleRecalculatedThe next planned date follows from the new last count date
Cycle counting needs monitoring, because nobody notices a count that never happens. Track three numbers each month: items counted versus due, overdue items by indicator, and difference value by indicator. If A items keep showing differences, the problem is in a process (backflush quantities, receiving, scrap reporting), and counting more often only finds the same error faster.
Auditors look at cycle counting differently from an annual count. Instead of observing one big event, they test that the program covers every item in the year, that counts happen roughly as scheduled, and that the difference rate is low enough to trust the book in between. That makes the coverage and difference reports part of Contoso's audit file. Keep the ABC run, the OMCO settings and the monthly monitoring results together, and record any change to indicators or frequencies with the reason and the approver.
What would you do?
After three months of cycle counting, Detroit's A items show recurring shortages of rotors, always after high production weeks. What is the best next step?
- Cycle counting counts important items more often; every item at least once a year.
- Indicators are defined per plant in OMCO: counts per year, float time and percentage.
- MIBC assigns indicators by ABC analysis; fixed indicators are protected.
- RM07ICN1 (MICN) creates documents for items due: last count date plus interval.
Check your understanding · not graded
Lesson check
1. Where are cycle counting indicators defined per plant?
2. Which transaction runs the ABC analysis that sets cycle counting indicators?
3. How is the planned count date calculated?
4. Which report creates physical inventory documents for cycle counting?