|
Hourly Worker Analysis (#407)
|
|
Why:
You need detailed analysis of the cost of production on a cubic meter
basis, by worker and activity. Key statistics in this report are: (1) your
cost per hour for an activity on a block, (2) M3 per hour, by
activity, and (3) cost per M3.
Focus:
Focus of Report is to show a listing of each employee, their hours by machine
and activity. These entries are matched up against the worker, machine and
activities entered on load tickets to estimate the volume produced. The
cost be cubic meter is then calculated as the ratio of the total hourly cost for
the worker and machine to the estimated volume from the associated load tickets.
You must track both the employee and machine by load ticket in order for this
report to have meaning. The report covers both employees and contract
workers.
Selection Window:
The selection window allows you to filter the report by:
- Date Range: You can either select a pay period, or you can simply enter the start and end date directly into the selection criteria window. The Period selection is merely a short-cut for entering a date range, so you can always edit the start and end dates to be any date you choose. For example, you can pick a period defined as 8/1/2004 to 8/12/2004, and then extend the end date by three days to 8/15/2004. If you leave the end time blank, the program will assume you want the entire day for the end date. In the example below, the start date/time is 8/1/2004 00:00:00 (a blank is assumed to be time 00:00:00) and the end date/time is 8/15/2004 00:00:00. Because the end date time is blank (or 00:00:00), the program assumes you want the whole day of the 15th and makes the end date/time 8/16/2004 00:00:00. In the selection query, the program returns records whose start date/time is greater than OR equal to the start/date time and strictly less than the end date/time.
- Worker. You can select any or all workers (the list includes both
employees & contract workers)
- Block: You can select any or all of your blocks
- Activities: You can select all or a subset of activities.
The 'Use Loaded Employee Cost' checkbox is used to toggle between
the direct payroll cost and the loaded payroll cost for employees.
Detailed Description:
The selection criteria determine the date range and employees that appear in
the report.
The report shows the hours by type of time, by activity for each of the
selected employees. The
columns are:
- Worker: Worker name on the time slip
- Equip Code: Machine recorded on the time slip
- Block: Block code recorded on time slip
- Activity: Activity on time slip.
- Hours: Total hours for the date range, worker, machine, block and
activity.
- Employee loaded cost: Employee payroll cost, based on the loaded
rate or direct payroll rate, as indicated by the 'Use Loaded Employee
Cost' checkbox.
- Std. Equip Cost: Cost of your own equipment based on the standard
equipment rate (dry rate).
- Contractor Hourly Cost: The cost the contractor if the worker or
equipment is owned by a subcontractor.
- Total cost: The sum of employee cost, equipment cost and
contractor cost.
- Total cost/hour: Total cost divided by number of hours. This
column shows your full cost per hour for performing the associated activity
for the block.
- "Blue Book" Rate per Hour: The fully founded rate for the machine
unit. You can compare the Blue Book rate against your own Total
Cost/Hour in the prior column to see how your own cost compare against an
industry standard gauge.
- "Blue Book" Cost: The Blue Book rate multiplied by the number of
hours worked.
- M3: Cubic meters of production based on load tickets.
- Cost per M3: Your Total Cost (not Blue Book) divided by M3
production (prior column).
- Budget Cost/M3: Budgeted rate set up as the rate for the activity
and block
- M3/Hour: Cubic meters of production per hour
- Target M3/Hour: This is M3/Hour implied by the 'Blue Book Rate',
which is an hourly rate. It is calculated by taking the Blue Book rate
and dividing by the Budgeted rate (which is a M3 rate). Confused?
The math works as follows: let's assume that a machine has a Blue Book
rate of $150.00/Hr and you have a budgeted rate of $5.00/M3. Dividing
the two, we get 30 M3/Hr. This means that in order to hit our $5.00/M3
budget for the block (given a machine that costs $150/Hr to run), the must
produce at least 30 M3/Hr. You can compare this targeted rate with
your actual M3/hour to see if your productivity is consistent with the
budget for the block.
Budget activity rates are setup under Contracts | Budgeting | Activity Rates.
Key Notes:
- The report handles both employees and contract workers
- Contractor hourly cost only counts contractor pay based on hours, not
production or loads
- The employee and vendor calculators must be run for the report to produce meaningful
results.
- M3 production is based on matching worker time slips with load slips on the
following attributes: Worker, Machine, Activity, Block and Date Range.
Report:
Example:
The panel below shows the first 10 columns of the report. Note that the first
two guys (Tim Andrews and Johnny Lewis) are employees and the third guy (Fred
Willis) is a contractor. Panel 2 below shows the remaining 7 columns.
|
Example Report - Panel 1 |
|
|
 |
Example Two:
|
| |
|
|
| |
Example Report - Panel 2 |
|
| |
 |
|
| |
|
|
|
|
|
