|
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 |
|
|
 |
|
|
|
|