|
Equipment Utilization, Detailed (#112)
|
|
Why:
You are looking for a report that will show, for each block, the
machine units that worked on that block along with the number of total hours and
total productive hours for each machine. You also want to see
the total estimated production for each machine for which you record tree
counts.
Focus:
Focus of Report is to show the production hours and total hours, by equipment
unit, grouped by equipment type, on a block-by-block basis. The data are
organized to show the tree counts and estimated production (based on the volume
per tree on the block) on a per productive hour basis. The
report shows the productivity (volume per hour) for each equipment unit that
tracks tree counts, on a block-by-block basis. This report is a companion
report to the report: Blocks (Production) - Equipment Utilization, Summary
in which the daily data are presented without as much equipment productivity
detail (and in a slightly different layout).
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.
- Block. You can select any or all of your blocks.
Detailed Description:
The selection criteria determine the date range and blocks that appear in
the report. The report is based on time the entries for Employees, Contractors,
and Equipment.
The report shows the hours for each piece of equipment, grouped by equipment
type. The columns are:
- Block: Block where work was performed
- Total Machine Hours: Total hours for the machine. Unlike most
other reports, this report actually includes maintenance hours
(hours whose pay activity belongs to an activity type where the "maintenance
time" field is non-zero) in the total hours figure.
- Production Hours: Hours for activities on time slips coded as a pay
activity type where the "PRODUCTION" flag is checked.
- "Conifer" Count: Tree count for the first tree count
field (labeled conifer in this example)
- "Aspen" Count: Tree count for the second tree count field
(labeled aspen in this example). This column is only shown where the
second tree count is enabled on the Time Entry form
- Avg Tree/Vol: Ratio of the tree count column (or the sum of the
tree count columns if using two tree counts) divided by the total production
calculated in the last column of the report.
- Vol/Prod Hours: Ratio of the value in the Total Production column divided by
the value in the Production Hours column
- Vol/Total Hours: Ratio of the value in the Total Production column divided by
the value in the Production Hours column
- Pct Production Time: Production Hours expressed as a Percent of
Total Hours
- Total Production: Sum of the tree counts multiplied by the volume per
tree (as entered for the block). If two tree counts are
used, this figure multiplies each tree count by its volume per tree ratio
and sums the two values to get total production.
Key Notes:
Key Notes:
- Because this report includes revenue and cost data, all calculators must be
up to date in order for this report to be accurate.
- Report covers both your own equipment and contractor equipment.
- The report is based on time sheet entries for Employees, Contractors,
and Equipment.
- Summary statistics depend on tree count entries.
- The report uses the "IS_PRODUCTION" flag on a specific activity to determine
the overall block's tree counts and production statistics. (For
example, if both bunchers and delimbers record tree counts, only one of the two activities
-- bunching or limbing -- should be marked
with the "IS_PRODUCTION" set to True. The activity whose
IS_PRODUCTION flag is true will be the one whose tree counts are displayed in the
report totals.)
- Production is based on tree counts and the estimated volume per tree on a
block
- Production hours are based on activities on time slips whose pay activity
type is flagged as a "PRODUCTION" type (see menu item Setup | Pay Activity
Types)
- Time Slips with an equipment unit of NONE are excluded from this report.
Report:
Example One:
Example Report 1
