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 Unit.  You can select any or all equipment units.  The equipment unit list is only for your equipment; contractor-owned equipment is not on the list.
• Your report can be sorted by date or by equipment unit.  Example Report 1 (see below) is based on sorting by day; Example Report 2 (see below) is based on sorting by equipment unit.
• Your report can be run in Summary mode by checking the "Summary Data Only" checkmark.  This version of the report will consolidate the daily detail into one row per equipment.
• The "Only Print Raw Data" option generates a report with the report detail, but with no subtotals or totals.

The selection criteria determine the date range and equipment that appear in the report. 

The report shows the utilization for all company owned equipment, by Pay Activity Type.  When time slips are entered, you are required to identify the activity that is performed by the worker/equipment (see below)

Each activity is assigned to a basic "Pay Activity Type," such as "REG PROD" or "EQ_MAINT".  These basic activity types are used to classify the more detailed pay activities.  The Pay Activity Types are shown below (and can be found under the menu item Setup | Pay Activity Types in the main program):

Note that although there are 13 pay activities above, they are all mapped into one of seven Pay Activity Types

These Pay Activity Types are used to classify all time in the Equipment Utilization Report.  Each Activity Type will have its own column in the report.

The report shows the utilization for all company owned equipment.  The columns are:

• Date.  The date of the time slip (not date paid)
• Equipment Unit:  The description (not code) field for the equipment unit
• Tot Available Hours:  The total hours for the equipment unit, except for hours coded as maintenance time.  In the basic activities list above, there is a column called "Maintenance Time."  Activity Types with a value equal to 1 in this column will be EXCLUDED from the Total Available Hours.  In general, the only Pay Activity Type meeting this criteria is "EQ_MAINT."
• Production Hours:  Total hours for time coded as production time.  In the Pay Activity Type list above, there is a check box for "Production Time".  Any activity that is coded to a basic activity type checked as "Production Time" will be included as Production Hours.  Hours coded as non-maintenance, non-production time will be counted as available hours, but not production hours.  For example,  the pay activity "DOWN" (Down Time), is coded as basic type "OTHER" (Other Non-Chargeable Time).  Thus, down hours would be included as available time, but not as production time.
• Production Utilization.  Percentage of Total Available Hours that are Production Hours.  This Percentage provides a measure of the percentage of time the machine spent engaged in productive versus non-productive activities. 
• Basic Activity Columns (Maintenance, Non Work Paid Time, Other Chargeable, ...).  The columns show the time by type of pay activity.

• The report is based on the time entries for (1) Employees, (2) Equipment, and (3) Contractor Time, where the contractor is using your equipment.  (Note:  In release 4.1.x, the selection only worked against the time entries for (1) Employees and (2) Equipment.  Release 4.2 added (3) Contractor Time.)
• It is important to recognize that this report defines utilization in a very particular way:  it is the percent of total hours spent in a given day (or over a period of time, if run in summary mode) that are spent on productive activities.  For this report to be meaningful, each machine must have time entries that account for a full day's worth of time, and these time entries must NOT be coded as pure maintenance time.  For example, suppose a machine is out of commission for a day because a mechanic spent an entire day fixing it.  If his time was entered against an activity whose Type is excluded from Total Available Hours, and the normal operator for this machine is using another piece of equipment, then this report will not show the day as counting against the utilization for the broken unit.  To get around the problem, the data entry person should also enter an Equipment Time Slip with 8 hours of Down time.

Example Report 1 shows the report where the selection "Sort by Date/Time" has been selected  This version of the report is useful in that it shows the production history by day for all your equipment and indicates the average production utilization by date and over the selected date range.

Examples:

1)    Delimber 103 (line 3):  Delimber 103 has 8 hours of Delimbing (classed as Reg Prod) and 0.5 hours of Maintenance.  Total available hours are 8 hours (Maintenance does not count) and production utilization is 100.0%

2)    Feller Buncher 311 (line 4):  Feller Buncher 311 has 7.5 hours of Bunching (classed as Reg Prod) and 2.0 hours of Down time.  Total available hours are 9.5 hours (Down does count) and production utilization is 78.95% (=7.5/9.5)

3)   Skidder 101 (line 7): Skidder 101 has 7.0 hours of skidding (classed as Reg Prod), 0.5 hours of Maintenance, and 1 hours of Down time.   Total available hours are 8.0 hours (Maintenance does not count; Down does count) and production utilization is 87.50% (=7/8)

	Example Report 1

Example Report 2 shows the report where the selection "Sort by Equipment Unit" has been selected.  This version of the report is useful in that it shows the production history for each piece of equipment and indicates its specific production utilization over the selected date range.

	Example Report 2