 |  |
Back to Reports |
Print Friendly |
Report: Block Economics: Block Profit by Activity Report (#131) |
Why:
You want to see your financial performance on a block based on your own labor costs plus standard hourly costs for your equipment. Where possible, you want the revenue from a particular activity (e.g., trucking) to be matched up with the costs for that activity so that you can see your profitability on each activity (that is, phase) performed within the block.
This report is especially nice for users who break their overall logging revenue rate into rates for each main phase of operation.
Focus:
This report provides a nice summary of your financial performance on the block. It also contains key statistics such as number of loads from the block, and volume per hectare.
This report does NOT show actual machine hour detail associated with the costs.
Note: It is important to understand that this report expresses costs based on the "standard" equipment hourly rates (that is, the rates net of any labor cost assumptions), plus your actual hourly labor costs.
Selection Window:
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 "Only Print Raw Data" is only to be used if you are trying to export the data without subtotals (perhaps for use in another software system).
- The "Fully Loaded Employee Cost" check mark allows you to run the report using straight labor costs (including whatever overtime was paid in connection with the block, or to run it using the "loaded employee rates" you set up for each worker. Checking the box allows you to view labor costs that are "grossed up" based on your loaded employee rates.
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.
The top portion of the report lists out each activity (phase) that was performed on the block. The first few columns show the various types of costs (employee hourly costs, own equipment costs, contractor costs, etc). There are also columns for the revenue for each activity, along with the revenue per volume (e.g., m3), and the gross margin for each phase.
The bottom panel of the report provides a summary profit and loss statement for the block. It essentially restates the information from the top panel in row form rather than column form, and captures some additional costs that are not included in the top of the report. The bottom panel also contains interesting summary statistics about the block.
The top portion of the report has the following columns:
- Activity: The pay activities used on time slips, load slips, or production slips for this block. (Note that the very first column of the report (which contains the block name) displays the activity group to which the various distinct activities belong.)
- Employee Payroll Cost: Includes hourly payroll costs for own employees based on the hours reported on the employee time slips. If the "Use Fully Loaded Costs" checkmark was checked when the report was run, this column will show the hourly costs based on the employee loaded rates, rather than the base pay rates. This column will also contain any payment based on the Tree Counts entered on the load ticket.
- Own Equip Costs: Costs associated with the productive machine hours on the block, where the costs are calculated as productive machine hours x standard hourly equipment cost.
- Own Total Hourly Cost: Sum of Employee Payroll Cost + Own Equip Costs.
- Employee Activity Cost: Costs associated with production slips for employees. If the "Use Fully Loaded Costs" checkmark was checked when the report was run, this column will show the production slip costs based on the employee loaded rates, rather than the base pay rates.
- Employee Load Cost: Costs associated with load-based payments to employees (e.g., costs for employee drivers or operators paid in connection with each load ticket). If the "Use Fully Loaded Costs" checkmark was checked when the report was run, this column will show the costs grossed up by the "load factor" from Basic Setup.
- Contractor Cost: Costs associated with any type of payments to contractors (e.g., hourly non-employee workers, hourly rental equipment owners, contractors paid by production slips, contractors receiving load-ticket-based payments, tree count payment).
- Total Cost: Sum of prior four columns.
- Total Volume: Sum of the volume field for all load tickets. The unit of measure for this field (e.g., m3, tons) is based on the "Volume Measure" selected in the Block Setup Wizard.
- Cost/Volume: Ratio of prior two columns.
- Revenue: Revenue associated with load slips. The revenue will be $0 for a given activity if you have no revenue rates for that particular phase/activity. (Even if the mill pays you one overall rate for logging, you can break that rate into the relevant respective phases when setting up your revenue rates.)
- Profit: Revenue for the given activity less total costs in the "Total Cost" column.
- Profit / Volume: Profit column divided by the volume column.
- Gross Margin: (Revenue - Total Costs) / Revenue.
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 for this block (for all activities) calculated from the volume or weight on the load tickets.
- Other Revenue: Revenue entered as miscellaneous income as well as revenue earned from hourly or production slip charge-outs.
- Total Revenue: Sum of Load Revenue and Other Revenue.
- Cost - Hourly Employees: Sum of hourly employee payment plus own equipment costs from the top panel of the report.
- Cost - Employee Activity: Payments to employees based on production slips. (The costs will be based on the loaded rates if you checked the "Use Loaded Employee Cost" box when you ran the report.)
- Cost - Employee Loads: Payments to employees based on load slips. (The costs will be grossed up by the "load factor" percentage in Basic Setup if you checked the "Use Loaded Employee Cost" box when you ran the report.)
- Cost - Contractors: Actual costs paid to subcontractors from the top panel of the report.
- Miscellaneous Cost: 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. (Expenses are entered under Data Entry | Expenses.)
- 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.
Key Notes:
- 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 equipment 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 appear in the top portion of the report, on a separate row next to the Trucking costs.
- This report makes NO distinction between Header and Detail records (C_Part_13) for piece-based systems.
Report:
Example 1:
Example Report 1 |
||
 |
||
