Consultants in Lean Manufacturing Á Manufacturing Strategy

lean article mnu lead-in

Estimating Cycle Count Requirements

Free Download 

How Many Counts Will You Need?

The only sure way to know is to start counting and observe the results. There are too many variables, too little reliable data and too much effect from selection strategies to accurately predict the required counts per day. It also depends on resources and how fast you want results.

ABC Counts Per YearFigure 17 contains a wealth of information from very simple data. Every Inventory Accuracy program should have something similar to monitor progress and identify problems early. However, the data for such a chart is only available after the program is operating.

In spite of the difficulties and inaccuracies, we still need some sort of advance estimate to design the program and procure resources. One method is to segregate items into the usual ABC classes and guess at the annual count frequency for each class. The table shows typical ranges.

Another approach is to simulate the system with a simple spreadsheet based on statistical theory. Our Cycle Count Estimator uses both approaches.

Strategos Cycle Count Estimator

Our Cycle Count Estimator takes the form of an Excel worksheet. It starts with simple information from past physical inventories and displays Inventory Record Accuracy for given cycle count frequencies for two-years. Up to five scenarios on each display allow comparison of different cycle count rates, Error Creation Rates or count selection strategies. Since it does not account for targeting strategies such as zero-balance counts, actual results are likely to be better than predicted.

Cycle Count Estimator Inputs

Figure 16 Data Inputs for Cycle Count Estimator

Next Page Button

 

 

cycle counting results

Figure 17 Cycle Count Monitoring

cycle counting results

Figure 17 Cycle Count Monitoring

cycle count Estimator Outputs

Figure 17 Cycle Count Monitoring

cycle count Estimator Outputs

Figure 18 Estimator Output Chart

Free Download

Strategos Cycle Count Estimator

■ ■ ■ ■ ■ ■ ■

Contact Webmaster

©_Permissions

SEP 2007  

Strategos-International:  North America - Europe - Australia

Strategos Footer

Lean Briefing Logo

The Free Newsletter

of Lean

Manufacturing Strategy

Lean Briefing Archives

The Strategos Guide To Value Stream and Process Mapping goes far beyond symbols and arrows. In over 163 pages it tells the reader not only how to do it but what to do with it. More info...

Strategos Guide to Value Stream & Process Mapping