Report: Block Economics:  Block Hourly Cost Report (#134)

The selection window allows you to filter the report by:

• Date/Time.  You can directly ender a date/time range for the start and end dates for your report.  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.  You do not need to select a period -- this selection is merely used to facilitate the entry of the state and end dates.  If you select a period, you can always edit the state 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.
• Block.  You can select any or all of your Blocks.  The second column shows the block description (long name).
• The "Show Non-Tracked Activity" check mark ensures that hours spent on activities other than those activities you track on the activity tab of the load slip itself will appear on the report.  In general, we recommend that you check this option. 
• The "Use Truck Cycle Time" checkmark allows you to see hours reported for each truck based on the number of trips they made to each block-destination combination and the trip cycle times that you set up for each trip.  This option is nice if you do not track time slips for your drivers because it provides you with an estimate of the total hours it took to haul the wood on this block. 

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.

The top portion of the report (labeled with "Activities on Block") shows hours and cost information for those phases where the machine is tracked on the activity tab of the load slip. 

The middle portion of the report (labeled with "Activities Not on Block") shows hours and cost information for those activities where the machine is not tracked on the activity tab of the load slip.  (If you do not track any information on the activity tab of the load slip, all your data will appear in this portion of the report.) 

The bottom panel of the report provides a summary profit and loss statement for the block, where the costs are based on the full found hourly equipment rates (rather than the standard hourly equipment rates plus each worker's actual hourly wages).   

The top and middle portions of the report have the following columns: 

• Eq Code:  The equipment unit number (code) used on the time slip and/or load slip for this block. 
• Equip Type:  The Equipment Type indicated for this equipment unit in the equipment setup table. 
• Activity:  The activity used on the time slip and/or load slip for this machine's hours (and volume). 
• Hours:  Hours entered on the time card for that equipment/activity/block combination.
• Equip Rate:  Full Found Hourly Equipment rate set up for this piece of equipment.  (If there was a rate increase during the life of the block, this value will reflect the average rate used for the hours worked on this block.).

Note #1:  for users with load-based rather than hourly truck costing, this rate will be the rate per unit expressed in the truck costing rate setup table (e.g., per tonne or tonne-hour or distance traveled)

• Actual Cost (Sub Equipment):  Costs incurred by a subcontractor for hourly work performed with his equipment. 

Note #1:  if you have an employee operator running a contractor piece of rental equipment, the employee's hourly loaded payroll costs will be included in this column. 

Note #2:  for the trucking phase, this column will show the trucking payments made to subcontractors where the payment is based on the weight or volume of the load ticket.  That is, the payment will appear in this column even though the payment is not based on hours worked.  If the contract truck is operated by one of your employee drivers, the cost of that employee driver will appear in this column as well, where the system-wide loaded cost factor (setup under File | System Configuration) has been applied as an uplift to the employee's costs.

• Fully Founded Equip Cost:  Costs calculated by multiplying the hours worked for the given machine/phase by the full-found equipment rate for that machine.
• Actual Production:  If equipment unit numbers are tracked on the back tab of the load slip for this given phase and machine, this column will show the volume for those tickets with this machine/phase combination.  If activities are not tracked on the load slip, this column will be blank for the machine/phase combination.  The total volume harvested on the block will, however, appear in the phase total row.
• Prod/Hour:  Actual Production (volume) for this machine/activity combination divided by the total hours worked for the machine/activity combination. 
• Total Cost/Production:  The sum of the actual Cost - Sub Equipment and Fully Founded Equip Cost columns divided by the actual production (volume) for that machine/activity combination.
• Total Cost/Hour:  The sum of the actual Cost - Sub Equipment and Fully Founded Equip Cost columns divided by the hours for that machine/activity combination.

The bottom portion of the report provides a summary profit and loss report for the block, along with a set of key statistics such as load count, total volume, etc.  The rows are as follows:

• Load Revenue:  All revenue associated with revenue contracts that are load-based. 
• Other Revenue:  All revenue associated with fixed fee or hourly charge-out revenue contracts.  (Note:  miscellaneous income entered with the revenue contract set to NONE will be omitted from this report entirely.)
• Total Revenue:  Sum of Load Revenue and Other Revenue.
• Cost - Own Equipment:  Fully founded equipment and truck costs taken from the "Fully Founded Equip Cost" Column in the top and middle portion of the report.
• Cost - SubCntr Equipment:  Actual costs for subcontractor equipment taken from the Actual Cost (Sub Equipment) column in the top and middle portion of the report.   Note:  if you have an employee operator running a contractor piece of rental equipment, the employee's hourly loaded payroll costs will be included in this amount.
• Other Contractor Costs: Payments to contractors based on production slips plus payments to contractors based on hourly time slips where the equipment and truck on the time slip are both set to NONE.
• Other Contr Cost (Loads): Payments to contractors that are based on load slips, but that are not captured in the top and middle portion of the report.  For example, if you have a contract buncher whom you pay based on the m3 from the load slips, his volume will appear in the top portion of the report (if you track his equipment unit # on the back tab of the load slips), but his costs will not appear above.  Rather, they are captured in this line item.
• Other Employee Costs:  Employee production slip payments; employee time slips where the equipment and truck are both NONE. Note that loaded employee costs will be reported here.
• Other Employee Costs - Loads:  Payments to employees based on the load slips.  For example, if you have an employee loaderman whom you pay based on the tonnage of the load slips for the given block he loaded, his volume will appear in the top portion of the report (assuming you track his equipment on the load slip activity tab), but his costs do not appear above.  Rather, they appear in this row.  They are loaded costs where the load is based on the system-wide percentage specified in the basic setup table.
• Miscellaneous Costs:  This section of expenses will have one line item per account code for miscellaneous employee and contractor expense entries made in connection with this block.
• Total Cost:  Sum of all Cost rows shown in the bottom portion of the report.
• Total Profit/Loss:  Total Revenue less Total Cost
• Gross Margin:  Total Profit/Loss divided by Total Revenue
• Load Count:  Count of the number of ticket entries.  (This count does NOT make use of the Load Count field on the load slip.)
• Tonnes:  Total weight from the load ticket converted into Tonnes.  (The unit of measure used for this field is taken from the entry made on the General tab of the File | System Configuration menu item (the entry for "Weight Unit for Reports").
• M3:  Total of the volume field from the load slip.  (The unit of measure is taken from the production unit of measure on the block setup.)
• Cruise:  Value taken from the Cruise entry on the last page of the block setup wizard.
• Hectares:  Value taken from the Hectares entry on the last page of the block setup wizard.  (This field is FLOAT_1 on the block table.)
• M3/Hectares:  Ratio of M3 and Hectare fields shown above.

• The load count values on this report treat each record in the system as a ticket.  For users that enter multiple "splits" for a given physical load, the load count field will not be accurate.
• This report will show full found costs only for those activities whose pay activity type (under Setup | Pay Activities) has the Production flag set to True.  (Non-productive hours are not costed explicitly because the equipment hourly costs build in a certain amount of assumed down time.)
• You must run the calculators before you run this report.
• Costs for Activities (other than "Trucking") whose "Is Pay Like Trucking" flag is set to True will ONLY appear in the bottom section of the report, either in the Line Item "Other Employee Costs (Loads)" or "Other Contractor Costs (Loads)".
• This report makes NO distinction between Header and Detail records (C_Part_13) for piece-based systems.
• If the user has multiple rows on the activity tab of the load slip (i.e., split loads where there are two loaders, for example, associated with the same load of wood), this report will split the volumes up amongst the pieces of equipment.
• If you pay based on Tree Counts, the costs are not displayed explicitly in this report.  Rather, they are assumed to be captured as part of the full-found rate.