Production per hour = (60/0.75) x 80%= 64 pieces of garments His performance rate (efficiency) is 80%. Let’s say Satish is working on an operation of a standard time of 0.75 minutes. expected performance rate (efficiency percentage).When you use this method, you need the following information Formula used -Ĭalculated Production/Hour target efficiency = (60/Operation standard time) X Target Efficiency% In the following example, I have shown it at 100% and Target efficiency (60%). Calculate estimated production per hour at target efficiency%. Related post: How to calculate the hourly production target of a production line?ġ. OR if you know the standard time of a specific operation and you know the skill level of the operator, we can estimate production without doing a cycle time study. At the end of this post, I have given Excel file download link.Įstimated production per hour from a workstation is calculated based on operators’ skills and operation cycle time. I will be sharing an Excel template for calculating production per hour. I will use examples of the garment manufacturing sector.

Then, I will show you the estimated production from each workstation (each operator). In the post, I will be showing you how you can calculate the estimated production per hour of a line in an Excel sheet. In the manufacturing sectors whatever items you are making, often you need to estimated hourly production and sometimes you may need to convert total production volume done by an employee (or workstation) into production per hour. Calculation of hourly production is required for many purposes.

Hours calculator excel template