Report

Use this report to review machine hours (and costs) for one or more pieces of equipment. This report is especially useful if you want to see how many hours an equipment unit spent performing a particular activity within a specific block or across all blocks. It is also useful in identifying mistakes in time entries where equipment or activities don't align sensibly with the associated worker.

Focus:

The focus of the report is to show a detailed listing (by day) for each piece of equipment showing the hours worked (and corresponding costs), the block in which the work was performed, and the activity that was performed. The report includes both your own equipment and contractor equipment. The report can either be run using: direct payroll costs, the standard cost of equipment, and any contractor costs; or fully founded costs (rather than actual payroll costs and standard equipment costs), plus contractor costs. This report is the analog of the report "Time - Hours & Cost, by Worker (#405)," but the entries are group by equipment unit instead of 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.
Equipment. You can select any or all equipment units (your own or contractor-owned).
Block: Select any or all of your blocks.
Activity: Select any or all activities.
The "Use Fully Founded Equip Cost" checkmark allows you to run the report using fully-founded equipment hourly rates, rather than standard rates plus actual payroll costs. (If you check this box, the selection for the "Use Loaded Employee Cost" box is irrelevant because employee costs will not be used at all.)
The "Use Loaded Employee Cost" checkmark allows you to report costs based on the loaded employee cost (if checked) or the direct payroll cost (if unchecked). If you check this box, you should UNCHECK the "Use Fully Founded Equipment Cost" box. Otherwise, your payroll costs will appear as zero in this report, regardless of the checkmark you choose for using Loaded Employee Costs.

Detailed Description:

The selection criteria determine the date range, equipment, blocks, and activities that appear in the report. The report is based on time the entries for Employee Time Slips, Subcontractor Time Slips, and Equipment Time Slips.

The report shows the hours for each equipment unit. The columns are:

Equipment: Equipment description (rather than Equipment Code)
Date. The date of the time entry (not date paid)
Worker: Employee or Contract Worker code on the time slip
Block: Block 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, and the column heading will be "Employee Loaded Cost.") If the worker is a contract worker, the employee cost will be zero.
Worker Hourly Rate (Calc): The employee payroll cost (or contract worker labor 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. Additionally, if you run the report using the Employee Loaded Cost, this rate will reflect the load factor.
Equip Cost (Own): The standard cost of your own equipment (based on 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 "Maint" the standard cost will also 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) hourly payments for the use of contractor equipment (where the equipment is operated by a contractor as well); (2) hourly payments for the use of rental equipment (in which case you have a separate operator payment) and (3) payments for the use of contracted operators operating your own equipment. (For this third scenario, the costs in this column are actually contract labor costs, rather than contract equipment costs.)
Total Equip Cost: Sum of "Equip Cost (Own)" and "Equip Cost (Contractor)"
Equip Hourly Rate (Calc): Total Equip Cost divided by Hours
Total Cost: Sum of "Employee Payroll Costs" (or "Employee Loaded Costs") and "Total Equip Cost"
Total Hourly Rate: "Total Cost" divided by Hours. This cost is the total hourly rate for the time entry.

Note: if the "Use Fully Founded Equip Cost" checkmark is checked, the Employee Payroll Cost column and the Worker Hourly Rate column will show as zero, since the Equipment cost has an assumed labor component in it. The equipment cost column will be based the fully founded rate instead of the dry rate.

Time - Hours & Cost, by Equipment (#406)

Why:

Focus:

Selection Window:

Detailed Description:

Key Notes:

Report:

Example 1:

Example 2:

	Detail View

	Summary View