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

Weekly Production, Summary (#136)

Why:

You are looking for a report that will summarize revenues and costs as well as production by pay period for the life of a block. This report provides a nice picture of the harvesting profile (and corresponding revenues and costs) over time for a given block so that you can see if there were any large time period gaps in harvesting activity.

Focus:

The focus of this report is to show load counts, volumes, revenue, and costs for each block, where the production information on any given block is summarized by pay period. The report provides average $ rates for both revenues and costs, as well as gross margin percentages.

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.

• Summary Data Only - check this box if you wish to see a summation of all blocks taken together, without the individual block detail.

• Use Invoice Revenue - check this box if you want the revenue calculated by the invoice calculator to be used. (If you leave the box unchecked, the system will use the actual revenue that you key in for each load during the mill settlement reconciliation process.)

Detailed Description:

The selection criteria determine the blocks that will appear in the report. The report is based solely on your load slip entries. (Any costs associated with time slips or miscellaneous entries or production slips are omitted from this report.)

For each block, the report shows one row per pay period, with a summary of the load counts, volumes, revenues, and costs associated with the loads in that period on that block.

The header information for each block is:

• BlockCode: Code indicated on the final step of the block setup window.

• BlockName: Name indicated on the final step of the block setup window.

• Hectares (or Acres): Value indicated on the final step of the block setup window (if the field FLOAT_1 is enabled).

• Date Completed: If DATE_2 is enabled in the block setup wizard, then Date Completed will show up in the report.

• Start Date: Value indicated in the block setup wizard as the starting date (EFFECTIVE_DATE) for the block.

• Date Purchased: If DATE_1 is enabled in the block setup wizard, then Date Purchased will show up in the report.

For each block, the columns are as follows:

• Pay Period: Pay Period Code. (For any block, the report will only show those pay periods where load slips are present.)

• PP End Date: Ending Date associated with the selected pay period.
• Loads: Load count. (Summed from the load count field on the load slips summarized in this row.)

• Volume: Sum of the volume (from the volume field on the load slip) of the loads summarized in this row. The unit of measure for the volume is based on the production reporting unit of measure identified for the source block when it was setup.

• Measure: Measure (e.g., Tons, M3, Cords) identified as the "production measure" during the block setup.

• Revenue: Sum of the revenue associated with the load tickets summarized in each row. If the "Use Invoice Revenue" checkmark is checked when you run the report, this value is the sum of the revenue amounts calculated for these loads by the software. If the box is unchecked, then this value is the sum of the revenue amounts keyed directly onto the load slips during the mill settlement reconciliation window.
• Avg Rate: Revenue divided by Volume. (Note that the actual revenue rates you set up in the system may be in a different unit of measure than what is used in this report. This average value is a calculated value based on the revenue and volume columns in the report.)
• Total Cost: Sum of all costs (employee and contractor costs) associated with load slips represented in the relevant row.
• Avg Rate: Total Cost divided by Volume.
• Gr. Profit: Revenue less Total Cost.
• Avg Rate: Gross Profit divided by Volume.
• Gr Margin (%): (Revenue less Total Costs) divided by Revenue.

Key Notes:

• The invoice, employee, and vendor calculators must all be run in order for this report to have costing information.
• The report picks up loads whose Date_Out is within the date range selected.
• The report only includes revenues and costs associated with load slips. It omits revenues or costs associated with miscellaneous entries, time slips, or production slips.

• The report does NOT capture load-based imputed costs for trucks that belong to your company. It only captures explicit payments to employees or vendors based on the load slip. Volumes entered in the "Scale Volume" field on the load slip will only be reflected in this report if there is also a corresponding value in the "volume" field on the load slip for the production measure on the block. If you do not have a value in that field, you may want to consider using the "Inverse Conversions" feature within the Logger's Edge.

Report:

Example One - Detailed View:

Example Report 1 - Detailed

Note: The "Measure" column in the summary portion of the report may show an entry of **** to indicate that the blocks for which the report has been run do not share the same pay basis. The summed volume values are not meaningful in this case.

Example Two - Summary View:

By checking the Summary Data Only checkmark on the report selection window, the report will display only the bottom portion of the report, which shows information for all blocks combined.

Example Report 2 - Summary

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