|
Block 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:
Focus of Report is to show 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 loadslip 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:
- Block Code: Code indicated on the final step of the block setup
window.
- Block Name: 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)
- Start Date: Value indicated in the block setup wizard as the
starting date (EFFECTIVE_DATE) for the block
For each block, the columns are as follows:
- Pay Period: Pay Period Code (for any block, 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 Calculator" 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 columns. (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 columns.
- Gross Profit: Revenue less Total Cost columns.
- Avg Rate: Gross Profit divided by Volume columns.
- Gr Margin (%): (Revenue less Total Costs) divided by Revenue.
Key Notes:
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 - Detailed Version:
Note 1: The "Measure" column in the summary portion of the report
shows 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.
Note2: 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.