Lean Tutorial: Production Capacity Template
by Ron Pereira on September 4th, 2008.To view a larger version of this video click here.
Here is a free copy of the production capacity template I use in the video. If you have any questions please feel free to contact me or leave a comment below.
Finally, if you like this style of video please let me know as I may begin to make more of these. Enjoy!
Related Posts:
- Chapter 1 of Lean Hospitals – FREE!
- One Piece Flow versus Mass Production
- The LSS Academy Guide to Lean: Update
- Clean up, Guide to Lean, and more
- Strategies to Sustain Operations Excellence




Loved it! Thanks for taking the time to do these types of videos. I’ve done some of these types of tutorials for work and know they take hours to edit. At least they took me hours.
Thanks, Scott. I really appreciate your kind words.
Great video and tool. I really like the simplicity. Thanks for sharing. One question I have would be accounting for variability, especially for the process times. What are your thoughts on addressing variability in models and tools? I’ve had success in using monte carlo simulation in the past but it can be tricky communicating the results as people are often used to point estimates. I’d greatly value your comments on this if you have any. thanks again!
Thanks for the great question, Scott. There are a number of ways to handle this.
In the past, I’ve noted things with both a measure of central tendency (mean or median) and a measure of dispersion (standard deviation or range). Often times this is powerful since “moving the mean” is not always the key issue at hand.
If this approach is taken then your daily outputs could be stated as min, average (or median), and max. This complicates things for sure but may be a more reliable approach.
I’d be interested to hear how other people handle this.
Good work Ron. I have built a few complicated versions of this, but they don’t work as easily.
[...] Lean Tutorial: Production Capacity Template by Ron Pereira – webcast walks through using a spreadsheet (template included in the post) to manage the production line. [...]
It is a very good and userfriendly template that you have shared. Thanks a lot.
Just one query I have is what is the Auto time that you have mentioned here coz most of the processes here in my organisation in the Assembly dept is manual. Please advice.
[...] capacity. Emerging online video star Ron Pereira of the Lean Six Sigma Academy explains the use of the table of production capacity by process (also called production capacity table) wherein time for tool changes is accounted for. Basically [...]
[...] from the available capacity. Emerging online video star Ron Pereira of the Lean Six Sigma Academy explains the use of the table of production capacity by process (also called production capacity table) wherein time for tool changes is accounted for. Basically [...]