Go Back to Logger's Edge Reports :: Block Economic Reports

Block Profit & Loss by Load Attributes (#145)

Why:

You are looking for a report that will show, for each block, the load count, volume, revenue, costs (by pay activity), and profit, broken down by the attributes you track on the load slip, such as species, product, and crew.

Focus:

This report provides a nice summary of production and profit information related to the block. Specifically, it shows the volume and load counts, by specie/product class, or even by crew (if you track your crew on the load ticket).

Note that the costs in the top portion of the report reflect only load-based costs (not costs based on time sheets, production slips, or miscellaneous expenses) because such costs are not broken down based on the load attributes like species or product.

• Top portion of the report summarizes volumes, revenues, costs delivered from a given block by load attributes such as species, product, or crew. (The attribute selections are based on the "C Parts" enabled on your load ticket.)

• Bottom portion of the report provides a summarized "income statement" format for each block, without the load attribute detail. This portion of the report does include costs associated with time sheets (both operator and equipment costs), production slips, and miscellaneous entries.

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. The second column shows the block description (long name).

• Attributes: You can have this report group the information by one or more load attributes such as species and product. The attributes from which to choose are based on the attributes (that is, "C Parts" within the database) enabled on your load ticket.
• Use Invoice Revenue: When checked, the report will show revenue calculated by the system based on load tickets and revenue rates. If unchecked, the report will show the revenue that has been manually entered during the mill settlement reconciliation process.
• Use Employee Loaded Cost: When checked, any employee costs displayed in the report will be grossed up by the load factor included in the System Configuration window. (See the Payment tab of that window.)
• Note: For report information that is based on load tickets, the report uses the Date Out (not the Date In).

Detailed Description:

The selection criteria determine the date range, blocks, and load attribute breakdown that appear in the report. If you run the report for multiple blocks, you will get one panel per block. The attributes you select will be displayed in the columns of the report. The cost columns are dynamic and depend upon the activities paid in connection with the selected blocks.

For each block, the top portion of the report shows load-based volume & cost information, broken down by the attributes (e.g., species/products) you selected.

The bottom portion of the report shows the same revenue and cost information, but no longer broken down by load attributes. In addition, this section of the report includes both miscellaneous income and expenses that are assigned to the block.

The top portion of the report has the following columns:

• Attribute (e.g., Species, Product): The first set of columns will reflect the attributes (e.g., species, product) you selected when you ran the report.
• Loads: Sum of the load count field on the load slip for all loads represented in the given row.

• Volume: Sum of the volume field from the load slip for all loads represented in the given row. This volume measure is expressed in the unit of measure you choose to use for production reporting when you set up the block.

• Measure: Shows the unit of measure associated with the volume in the prior column.
• Revenue: Revenue associated with the loads represented in that row. If you checked the "Use Invoice Revenue" box when you ran the report, the revenue will reflect the revenue calculated by the system during the invoice calculator. Otherwise, the revenue will reflect the manual entries made during your mills settlement reconciliation process.
• Rev / Volume: Revenue divided by Volume. Reflects the average dollar revenue rate for that row.

• Expense columns (e.g., Cutting, Stumpage, Trucking, Depletion, Logging): The expense columns are dynamic and reflect the pay activities that are relevant for the blocks for which you ran the report.

• Total Expense: Sum of all the expense columns.
• Expense / Volume: Ratio of Total Expense to Volume.
• Profit: Revenue less Total Expense.
• Profit / Volume: Profit divided by Volume.
• Gr Margin (%): Ratio of Profit to Revenue.

The bottom part of the report shows:

• Load Revenue: Same as Revenue shown in the top panel.
• Other Revenue: Revenue entered as miscellaneous income, as well as revenue from charge-outs based on time slips (or production slips).
• Load Cost: Same as Total Expense shown in the top panel.

• Other Cost: Costs associated with time slips, production slips, and miscellaneous expenses associated with the block.

• Profit: Load Revenue + Other Revenue - Load Cost - Other Cost

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.
• For companies that track header versus detail records using C_PART_13, this report bases the load count and volume information on the 'H' records (header records). The dollar figures are based on both 'H' and 'D' (detail) records.

• As of Version 4.8.1 this report will not show revenue or costs for those activities whose "No Costing" flag is set to True. The "No Costing" flag is NOT included by default in Pay Activities (under Setup | Pay Activities), please contact a Caribou Software representative if you wish to enabled this flag.

Report:

Example One:

Shows the report where both the Species & Product attributes were selected.

Example Report 1

Example Two:

Shows the report where only the Product attribute was selected. (Note the column headings are dynamic and are based on the pay activities for that block.)

Example Report 2

Go Back to Logger's Edge Reports :: Block Economic Reports