Standard Hour Incentive Pay Worksheet
Standard hour plans pay for output against an engineered standard. This worksheet lets HR and engineering check what a plan would pay, how efficient each operator is and what labor costs per piece before launching it.
| Operator | Hours worked (h) | Good pieces | Standard pieces per hour | Base hourly wage | Earned hours | Efficiency | Pay (greater of hours or earned hours) | Labor cost per piece | |
|---|---|---|---|---|---|---|---|---|---|
44.2 | 110.5% | $862 | $0 | ||||||
36.8 | 92% | $800 | $0 | ||||||
41 | 107.9% | $861 | $0 | ||||||
49.6 | 124% | $942 | $0 | ||||||
30 | 93.8% | $704 | $0 |
This models a guaranteed-base plan: operators are paid the greater of hours worked or earned hours at their base wage. Plans that pay a bonus share of the gain or tier the pay need different formulas. Check local wage laws for minimum wage and overtime rules before using any incentive plan.
Earned hours straight from your ERP
Optional: we can discuss producing this report from routing standards and labor tickets.
Optional. The tool and every export work without this. No spam.
How to use it
Replace the sample rows with your operators. Enter hours worked, good pieces, the standard pieces per hour from the routing and the base hourly wage. The worksheet calculates earned hours, efficiency, pay and labor cost per piece for each row, plus group efficiency and average cost per piece. Add rows for each operator or each operator-operation combination, and export to Excel to share with payroll or the union.
- Count only good pieces, after scrap and rework
- Use the standard that is in your routing or labor standards table
- Run with last quarter's data before announcing the plan
The calculation
Earned hours equal good pieces divided by the standard rate. Efficiency equals earned hours divided by hours worked. Under a guaranteed-base standard hour plan, pay equals the greater of hours worked and earned hours, times the base wage. That means an operator above standard earns more than a time-based wage, and an operator below standard is protected at base. Cost per piece is pay divided by good pieces.
Reading the result
Compare efficiency across operators on the same operation to see whether the standard is fair. If almost everyone is over 120 percent, the standard is loose and the plan will cost more than expected. If almost nobody reaches 100 percent, the standard is too tight or the process has problems that incentive pay will not solve. Look at labor cost per piece against your cost standard.
Common mistakes
Paying on gross pieces rewards scrap, so use good pieces only. Applying one standard to jobs with different setups creates unfair results, so apply setup time separately. Plans also need a quality gate and a rule for downtime that the operator does not control. Avoid launching without checking wage laws, since some jurisdictions require the incentive to be included in overtime pay.
Frequently Asked Questions
What is an earned hour?
An earned hour is the amount of work equal to one hour at the engineered standard. If the standard is 50 pieces an hour and the operator makes 100 good pieces, they earned two hours regardless of the clock time they spent.
Can I use this for group incentives?
Yes, enter each person's hours and the pieces credited to them. For a team plan, split the team's pieces by hours worked, or use the group efficiency in the summary to apply the same factor to everyone.
How do I handle downtime?
Subtract hours of downtime not caused by the operator from hours worked, or pay it at base wage as a separate line. Leaving it in hours worked would lower efficiency unfairly, so decide the rule up front.
Does this meet overtime law requirements?
Not by itself. In many places incentive earnings must be included when computing the regular rate for overtime. This worksheet only models straight-time pay, so have payroll or counsel review the plan design.
If routing standards and labor tickets live in your ERP, we can build the earned hours and efficiency report directly from them instead of re-keying numbers.
Related Tools
Overall Labor Effectiveness (OLE) Calculator
Measure how well paid labor hours turn into good output, using the same availability, performance and quality structure as OEE.
ERP OperationsLabor Burden Rate Calculator
Convert base wages into a fully burdened hourly rate using payroll taxes, workers comp, retirement match, benefits, and paid time off.
Safety & WorkforceOperator Learning Curve Ramp-Up Cost Calculator
Uses Wright's learning curve to estimate how many units a new operator needs to reach standard time and what the extra labor costs.
Safety & WorkforceSupervisor Span of Control Calculator
Calculates how many production supervisors each shift needs for a target span of control and what any gap costs per year.
More Safety & Workforce tools
See all- Shift Schedule Template (2-2-3 and 4 On 4 Off)
- Absenteeism Cost Calculator for Manufacturing
- Production Operator Certification Checklist
- Production Line Staffing Calculator (Direct Labor)
- Production Operator Skills Matrix Template
- OJT Training Sign-Off Record Template
- Cross-Training Coverage Matrix Worksheet
- Cross-Training Payback Calculator
- Temp Agency vs Direct Hire Cost Calculator