When entering Piece Rate data to a Piece Tracker Job, the Piece Rate is automatically calculated if the Pieces per Hour is not 0, and the Prevailing Wage is used in the calculation. For example, if a Job is being added or changed and the Pieces per Hour is 100, the Piece Rate will be automatically set to: Prevailing Wage/100.
The Prevailing Wage is defined in 'Setup - Piece Tracker', and is set for a span of time and is also based on 'Job Type' for each job. Using 'Job Types', it is possible to have multiple Prevailing Wages.
Note: If there are multiples spans that meet the criteria for a Job, the Prevailing Wage that gets used in the Piece Rate calculation will always be the latest date span.
Here is an example of a Prevailing Wage setup:
In the example above, if a Job has no Job Type, then the Prevailing Wage would be either $8.15, or $8.66 depending on the date of the Job Details. If a Job has a Job Type of 'Piece Work - $10', then the Prevailing Wage would be $10. A different Job with a Job Type of 'Piece Work - $11' would have a Prevailing Wage of $11.
If the Prevailing Wage is $8.66, the Piece Rate would be 8.66/100 or .0866. The Piece Rate will be rounded UP to the nearest 4 decimal places.
IMPORTANT: the Prevailing Wage must be setup in a Date Span or the payroll report will not be accurate.
Entering Piece Rate Data to a Job
Assuming the Prevailing Wage is set up, it is only necessary to enter the Pieces per Hour to a Job. The Piece Rate will be automatically calculated and added to the Job. And like the Prevailing Wage, the Pieces per Hour can also change from time to time. To accommodate this change, use the Dates Spans to establish the Pieces per Hour for each job based on the dates:
IMPORTANT: the Pieces per Hour must be saved with the Job or the payroll report will not be accurate.
Adding a New Prevailing Wage
When the Prevailing Wage changes, a date span can be added with the new Prevailing Wage. The Piece Rates for all jobs that are based on the Prevailing Wage can be automatically recalculated by clicking the 'Piece Rate Recalc' button.