Report: Block Economics:  Block Summary P & L - Full-Founded Costs (#117)

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 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.  You will also get a summary for all selected blocks as the last panel in the report.

Report Columns:

The report has four data columns:

Detail:  Shows the dollar value of costs in each of the cost categories in the report.

Total:  Shows the total revenue, total costs, and total profit.  These totals summarize the detail provided in the "detail" column.

Delivered Volume:  The unit of measure for this column for the given block you are reviewing depends upon the selection you made in the block setup wizard for the step that is labeled "Select Volume Measure Used to Track Production."  The value shown for delivered volume is the sum of the "volume" field on the load slip.  If you modified your conversion factors and reran the regular calculators but NOT the "Recalc Load Volume" calculator, the values shown in this column will not be accurate.

$/Volume:  The ratio of the values shown in the detail column divided by the delivered volume.

Report Sections:

The rows in this report are organized into five parts. 

Part I -- Revenue

Revenue is broken down with one row for each distinct revenue contract associated with that block.

Miscellaneous revenue appears on separate rows as well - one row per Expense Account Code.

Part II -- Includes fully founded costs for own hourly equipment as well as costs associated with subcontractors.

The "Hourly Equipment" costs are calculated by multiplying the productive hours worked for each phase by the fully founded equipment rate.

Note:  Productive hours are those hours associated with Pay Activities whose Pay Activity Type (under the Setup | Pay Activity Types menu item) has the "Production" flag checked.

If you had your own log trucks, there would be a line item labeled "Own Trucks, Load Cost" beneath the "Hourly Equipment Cost" section.

The "Sub Contractors, Load Pay" costs are those costs paid to contractors based on the load slips.  Note that if an employee operates a contractor's piece of equipment, the employee expenses will be included in this section on a separate line item tagged "employee."

The "Sub Contractors, Hourly" section shows hourly payments made to subcontractors.  If the hourly payment is for rental equipment operated by your own employees, the costs of the hourly rental rate will appear in this section tagged as "Rental."

The "Sub Contractors, Activity" section shows payments made to subcontractors based on production slips (e.g., day rates).

Part III -- Employees, Other Activities. 

This section includes hourly labor costs used for rental equipment.  The labor costs are based on the loaded employee rate.

Part IV -- Other Costs

The "Employee Costs - Other Employee Costs" section shows costs for hourly employees where the equipment on the time slip is set to NONE.  (Employee costs when operating a piece of equipment are not included explicitly anywhere in this report, but are included implicitly in the equipment rates.)  It also includes costs for employee production slips (e.g., day rate payments, living out allowances).

The "Employee Costs (Loads)" section shows payments to employees based on the load slip (e.g., employee drivers paid on a percentage of load revenue).

Part V - Miscellaneous Costs

This section will show all miscellaneous expenses (entered under Data Entry | Expenses) for employees as well as contractors that are assigned to this block.  The expenses will be grouped with one line for each distinct expense account code.

The Bottom Panel of the report contains the following line items:

Total Actual Production:  volume (expressed in the unit of measure you used as the "Volume Measure" when you set the block up.  This value comes from the "volume" field on the load tickets on the block for the date range you have selected.

Total Estimated Production:  Tree Counts from the time slips on this block multiplied by the volume / tree ratio on the block.

Cruise Volume:  Taken from the "Cruise Volume" field on the load slip.

Total Trees:    Total Tree Counts from the time slips on the block.

Actual Volume/Trees:  Actual Volume produced on the block divided by actual trees from the tree counts on the time slips.

Estimated Volume/Tree: Value entered in the Block Setup wizard.

• This report will show full found 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 report in the same section as regular load-based trucking payments.
• This report makes NO distinction between Header and Detail records (C_Part_13) for piece-based systems.
• If you pay based on Tree Counts, the costs are not displayed explicitly in this report.  Rather, they are assumed to be captured as part of the full-found rate.