|
Report: Block Block
Equipment Budgeted Hours Report (#147)
|
|
Why:
You need a report that shows your actual machine hours and costs by phase
within a block along with budgeted information for two primary purposes:
Purpose 1: to see how far along you are with a certain phase on a block
while the block is being harvested. The report will use budgeted productivity
per hour ratios that you set up in the system in conjunction with your actual
hours to allow you to estimate the volume you've harvested, even before the wood
has been delivered.
Purpose 2: to see how your actual productivity per phase (e.g., actual
volume delivered per hour of harvesting work) compared to your budgeted
productivity (volume per hour ratios that the mill expected you to achieve for a
given phase) upon completion of a block.
Focus:
This report is most popular among Canadian users who own most of their own
machines, who generally pay operators of those machines by the hour, and who
receive targeted productivity rates for each phase of operation from the mill(s)
to which they deliver.
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.
- Note: for report information that is based on load tickets, the
report uses the Date Out (not the Date In).
- Block. You can select any or all of your block.

Detailed Description:
The selection criteria determine the date range and blocks that appear in the report. If you run the report for multiple blocks, you will get one panel per block.
Generally, you will want to run this report for a date range encompassing the
entire lifespan of the block.
Each panel in the report begins with a header for the selected block.
The header includes:
- Block: block where work is performed
- Description: The Description of the block where the work is performed
- Cruise Volume: volume amount entered in the cruise filed in the
block setup wizard
- Delivered Volume: volume based on the load tickets whose date_out
is within the date range you selected for the report.
The body of the report lists each piece of equipment used on the block,
grouped by phase (that is, by "Activity Group"). The columns are:
- Phase: Phase (that is, the "Activity Group") associated with the Activity coded on the time slip.
- Eq Code: The code for the equipment unit.
- Activity: Specific Pay Activity coded on the time slip for the
particular machine/block combination.
- Actual Prod. Hours: Total hours for time coded as production time. Each
pay activity in the system belongs to a particular pay activity type.
These "types" can be flagged as "Production Time".
Time for any activity that is coded to a basic activity type checked as "Production Time" will be included as Production Hours.
(See the Setup | Pay Activity Types menu item.)
- Actual Prod: Actual Production from the block. If you do
NOT track equipment on your load tickets, then this column will show total
volume from the load tickets for this block. If you DO track
equipment on your load tickets, then this column will show the actual volume
from the load tickets for this block and the specific machine displayed in
the given row.
- Actual Prod / Hr: Ratio of Actual Production column to the
Productive Hours column.
- Budgeted Prod / Hr: Ratio showing the Production you expect to harvest
per hour. This value is set up under the Contract | Budgeting menu
item in the main system.
- Estimated Production: Estimated volume, which is calculated as
the Budgeted Production per Hour ratio
multiplied by the actual productive hours worked by that particular machine unit.
- Estimated Prod / Cruise (%): Estimated Production as a Percentage
of the Cruise Volume (shown at the top of the report). This percentage
provides an estimate of how close that particular phase is to being
completed for the block (assuming the cruise volume was accurate, and
assuming the estimated production per hour was accurate).
- Delivered / Estimated Prod: Ratio of the total volume delivered
to date relative to the estimated production (shown two columns prior).
Prior to completion of the block, this column provides an estimate of how
much of the volume that you've cut has been delivered to the mill.
After completion of the block, this column shows whether you harvested more
or less per hour than your target. Values over 100% indicate that you
have actually harvested more volume per hour than you were targeting ---
that is, you have been more productive in that phase than your target.
- Estimated Prod - Delivered: This is the difference between the
estimated volume that has been harvested (based on hours worked and targeted
volume per hour ratios) and the actual volume that has been delivered.
Whenever the prior column is less than 100%, this column will show a
positive number. This number is an estimate of the volume you have
harvested, but that has not yet been delivered.
Key Notes:
-
The report is based on timeslip entries only. Company owned equipment time is included on the report,
as well as time entries for subcontractor-owned machines. (The report
picks up hours entered under the employee time slips menu item, the
subcontractor time slips menu item, and the equipment time slips menu item.)
- The report only includes hours whose Pay Activity belongs to an Activity
Type that is marked as production. (See the Setup | Pay Activity Types
menu item to determine which activity types have the production flag set to
True.)
- The report does not differentiate between header 'H' and detail 'D'
records
- You do NOT need to run the calculators for this report.
Report:
Example
|
Example |
|
|
 |
|
|
|
|