In our last installment in the piece work series, we discussed how to set up piece work in CLIP. In this post we will discuss how to pull reports for employee efficiency and payroll.
Employee Efficiency Report
The most essential report for piece work is the employee efficiency report. The employee efficiency report will give you the information needed to analyze your crews and to complete payroll. This report can be accessed from the menus at the top of the screen in CLIP.
Click on Reports > Employee > Efficiency Report > Report Hours only.
After clicking on it, you can select the date, crew range, specific employee id and layout options.
This is the setup I most commonly use:
Click “Output” to preview or print the report. Here is the report:
Here is an explanation of the most important columns:
Budgeted Man Hours: Total budgeted man hours completed.
Actual Man Hours: Total time spent on all jobs (not including travel time)
Paid Hours: Total working hours (from beginning to end of day)
Actual vs Budgeted: Compares time spent on property to budgeted man hours.
Actual vs Paid: How much of the clock time was spent on jobsites.
Budgeted vs Paid: Compares budgeted man hours to total clock time.
This report is a great resource for your crews. Providing this report on a daily or weekly basis gives the crew an accurate measurement of their efficiency so they can see where improvement is necessary.
The most important column for the crews to pay attention to is the Budgeted vs. Paid. If they are above 100% in this column that means that they are doing well. If they are less than 100%, they need to improve.
How to Use this Report for Payroll
Run the efficiency report using the dates for the payroll payroll period.
Review the report to ensure that everything is correct.
For payroll, you are going to use two columns: Budgeted Hours and Payroll Hours.
Budgeted Man Hours
Your employees will be paid total Budgeted Man hours x their hourly rate. For example:
98 hours x $12.00/hr = $1176.00
Payroll Hours (total working hours)
Because of minimum wage laws, the total working hours for your employees must be tracked.* Your employees must be paid at least minimum wage (including any applicable overtime) for the actual hours they were on the clock. If their piece work pay is less than this, you must pay them the minimum wage instead.
Example:
Enrique Salvador gets paid $9.00/hr on piece work. He was on the clock for 40 hours during the payroll week. In that time, he completed 28 budgeted hours of work. We need to check the following two calculations:
Piece Work
$9.00 x 28 = $252.00
Minimum Wage
$7.25 x 40 = $290.00
In this scenario, we would be required to pay Enrique the minimum wage of $290.00. Hopefully, this won’t happen frequently because that would be 70% efficiency on Enrique’s part.
I have attached a spreadsheet here that you can use for checking piece work pay against minimum wage.
Minimum Wage Check Spreadsheet
That’s it! With the Budgeted Man Hours and Payroll Hours from the Employee Efficiency Report, you have everything you need to calculate payroll.
Questions? Feel free to email me or post a comment.
In this series:
1. Why Piece Work? (Part 1 & Part 2)
2. How to to set up and track Piece Work in CLIP (Part 1 & Part 2).
3. Tips for implementing Piece Work in your company.
4. Common Objections.
5. Q & A (send me your questions)
*Disclaimer: I am not a lawyer or legal expert. It is your responsibility to make sure you are in compliance with all applicable laws in your area.