|
Time - Hours & Cost, by Worker (#405)
|
|
Why:
You need a detailed report on your hourly employee and contractor costs, by day.
Focus:
Focus of Report is to show a detailed listing of hours worked and costs, by
activity, for each worker -- both employees and contract workers. The cost
includes the direct payroll cost, the cost of equipment and any contractor
costs. The report is often useful in identifying mistakes in time
entries where equipment or activities don't align sensibly with the associated
worker. This report in the analog of the report "Time - Hours
& Cost, by Equipment (#406)," where the entries are group by workers unit
instead of equipment.
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.
- Workers. You can select any or all employees and/or contract
workers.
- Block: Select any or all of your blocks.
- The "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.
- The "Fully Loaded Employee Cost" option allows you to report
costs based on the loaded employee cost or the direct payroll cost (default)

Detailed Description:
The selection criteria determine the date range and employees that appear in
the report. The report is based on time the entries for Employees and Contractors.
The report shows the hours for each employee. The
columns are:
- Worker: Employee or Worker name on the time slip
- Date. The date of the time entry (not date paid)
- Equip Code: Equipment code
- Block: Block (or Tract) where work was performed
- Hours: Hours on the time slip
- Activity: Activity listed on the time slip
- Employee Payroll Cost: Payroll cost for employees. If the
"Fully Loaded Employee Cost" option is selected this column will
report the payroll cost based on the employee's loaded rate. If the
worker is a contract worker, the employee cost will be zero.
- Worker Hourly Rate (Calc): The employee payroll cost divided by the
hours. This rate may differ from an employee's pay rate because it may
reflect a blended rate made up of straight time, overtime or double time
rates.
- Equip Cost (Own): The standard cost of your own equipment (using the
dry rate).
Where the equipment is owned by a subcontractor, this column will be
zero. Note: Where the activity has been coded with a basic
activity type of "Maintenance" the standard cost will be zero --
maintenance hours are not considered production hours for calculation of the
standard cost of equipment.
- Equip Cost (Contractor): This column may reflect three types of
contractor costs: (1) payments for the use of contractor equipment, as
paid by pay contracts; (2) payments for the use of contractor
equipment, where the equipment has been set up as rental equipment; and (3)
payments for the use of contractor operators (workers), as paid by pay
contracts. The scenarios covered here are (1) contract workers
operating contractor equipment; (2) your employees operating contractor
(rental) equipment; and (3) contract workers operating your own equipment.
- Total Equip Cost: Sum of "Equip Cost (Own)" and "Equip Cost
(Contractor)".
- Equip Hourly Rate (Calc): Total Equip Cist divided by Hours
- Total Cost: Sum of "Employee Payroll Costs" and
"Total Equip Cost"
- Total Hourly Rate: "Total Cost" divided by Hours. This
cost is the total hourly rate for the time entry.
Key Notes:
- Report covers employees and contract workers
- The employee and vendor pay calculators must be run in order for entries to
appear in this report.
- The Payroll cost for employees includes pay by tree counts (or tree
volume)
- The entries are grouped by worker and sorted by date.
- Report does not cover pay pay based on production (e.g. per day or
mile), nor employee expenses
- The "Equip Cost - Contractor" column includes cost of contractor operators
where pay is based either on hours or by tree counts (or tree volume)
Report:
Example:
Example Report