|
Block Economics:
Block Cruise Volume (#130)
|
|
Why:
This report is useful primarily for U.S. users who purchase their own tracts
of timber. You purchase timber on a lump sum basis and have an expected
volume (by specie and product) for the tract based on your cruise. You
want to monitor the depletion of the tract (both volume and dollar value) as it
is being cut and to determine, upon completion of the tract, whether you had an
under- or over-cut.
Note: depending on the region of the country, you may refer to the
tract as a "timber sale" or as a "block" or "job." This document uses the
terminology "tract."
Focus:
The report is valuable for use in monitoring both the amount of -- and value
of -- the standing timber inventory that you have purchased on a lump sum basis,
but have not yet harvested. This report also provides valuable information
upon completion of a tract because it shows how the tract has "cut out" relative
to how it was cruised, and whether you ultimately made money on the tract.
Finally, the report is also useful for tracts where stumpage is paid on a per
unit basis (rather than lump sum) in that it will allow you to compare actual
deliveries (that is, volumes by specie and product) to the cruise volumes.
(With per unit tracts, of course, the depletion values will be zero, but the
volume information will still be relevant.)
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..
- Note: for report information that is based on load tickets, the
report uses the Date Out (not the Date In).
- Block. You can select any or all of your Blocks. The second
column shows the block description (long name).
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 lump sum purchase price you paid for the tract is reported at the top of
each tract's panel, directly beneath the Trace Code (short name) and Tract Name
(Long Name you assigned during the Tract Setup process). The Lump Sum
amount is the amount you entered when you set up the tract. (The "Lump
Sum" field on the "Blocks" table must be enabled for this value to appear here.)
- Product: This column contains the combination of Product (C_Part_5
in the database) and Species (C_Part_4 in the database). assuming you used
both species and product when you entered your cruise volumes on the tract.
The report will have one row per combination of distinct Product/Species
combination. Note that if there are deliveries for a particular
product/specie combination for which no cruise was entered, the report will
include a row for that product/specie combination (see the last row labeled
"Saw - MX HD (Not Cruised)" in the example report.
- Cruise Volume: the amounts you entered as cruise volume for each
product/specie combination when you set up the tract.
- Measure: the unit of measure you indicated during the cruise setup
for each product/specie combination.
- Acc. Record Volume: Accumulated Record Volume --- that is, the
actual delivered volume for each product/specie combination for the date
range you selected.
- Depletion Rate (Calc): The calculated depletion rate for each
product/specie combination. This value is calculated by dividing the
depletion dollar amounts that the system has calculated during the vendor
pay calculator by the delivered volume so that the rate is expressed in this
report in the unit of measure corresponding to the cruise unit of measure
(regardless of how you set up the depletion rate in the system).
- Remaining Volume: Cruise Volume less the Acc. Record Volume.
- Remaining Depletion Amount: Remaining volume multiplied by the
calculated depletion rate. This amount represents the estimated value
of the timber you have remaining to be harvested on this tract.
- Remaining Percentage: Remaining Volume divided by the Cruise
Volume. Negative percentages mean that you have harvested more volume
than you cruised for a particular product/specie combination.
There are three rows at the bottom of the report:
- Tract Lump Sum Less Actual Depletion: Tract Lump Sum amount shown
at the top of the report less the sum of the Depletion Amounts across all
products/species. This figure shows you the difference between what
you actually paid for the tract, and the value of the timber you have cut
from that tract to date. If this number is negative upon completion of
the tract, then the value of the wood you harvested exceeds the price you
paid for it, and you have an over-cut. The more of those, the better!
- Tract Total Depletion: Sum of the Depletion Dollar Amount Plus the
Remaining Dollar Amount across all products/species. This amount
represents the value of the actual timber you have harvested from the tract,
based on the depletion values you entered in the system. (If you use
the budgeting tool within The Logger's Edge and base your lump sum bid on
the cruise volumes and depletion amounts you entered in our system, this
amount will match your lump sum purchase price identically.)
- Tract Lump Sum Less Tract Total Depletion: Value from the "Tract
Total Depletion" row immediately above less the value of the lump sum
purchase price you paid for the tract. If you paid less for the tract
than your estimate of the value of the timber (that is, if you under-bid
based on your estimated cruise volumes and depletion rates), then the total
depletion should exceed the lump sum amount you paid for the tract, and this
number will be negative. If your bid was identical to your valuation
of the timber, this number should be zero.
Key Notes:
- The report is hard-coded to the activity whose code is "Depletion." If
any other code is used, the report will not show the Depletion Amount or
Depletion Rate properly. The report will work whether "Budgeting" is
enabled in basic setup, or whether the depletion rates are set up explicitly as
vendor pay rates payable to an "internal" land-owner using the pay activity
"Depletion."
- The report does not differentiate between header 'H' and detail 'D'
records
- You must run your vendor calculators before running this report.
Report:
Example:
|
Example Report |
|
|
 |
|
|
|
|