|
Report: Production Costs, Combined, by Actual Volume
(#105)
|
|
Why:
You need a report that shows your equipment costs and production for your
hourly equipment where you keep track of your production on your load slips.
Focus:
Focus of Report is to provide a summary, by block, of your production
costs and your actual delivered production. The report is suited for those
operations that pay their workers on an hourly basis and track their employees
and equipment on their load slips. This report is a companion report to
the report Blocks, Production Costs, Combined, by Estimated Volume,
except that estimated production is replaced with actual delivered production.
Release Notes:
- Version 4.2 added contractor time slips and tree counts. Prior
versions only used employee slips and tree counts
- Version 4.2.fixed bug in block averages where volume/tree and cost/volume
were being reported as zero.
- Version 4.4.14 added a column for volume per hour
Selection Window:
The selection window allows you to filter the report by:
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 "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.
- The "Fully Loaded Employee Cost" option allows you to run the
report using your loaded payroll cost instead of your direct payroll cost
(the default).
Detailed Description:
The report shows payments due for each load on an activity-by-activity basis. The
columns are:
- Block Code: Block where work is performed
- Employee: Worker who performed work
- Eq Code: Equipment Code
- Equipment: Equipment description (suppressed in example report)
- Activity: Work activity
- Hours: Count of hours for the equipment for the activity over the
date range
- Employee Payroll Cost: The payroll cost of employees (includes pay
based on hours, tree counts and tree volume)
- Contractor Pay: Payments to contractors for contractor-owned
equipment and/or contract operators.
- Equip Rate: Standard hourly cost for the equipment.
(Maintenance time is NOT charged out at standard cost)
- Equipment Cost: Internal charge for the use of your equipment (at
standard cost)
- Total Cost: Sum of employee payroll, contractor pay and equipment
cost.
- Hourly rate: Total cost divided by hours. This will be the
effective hourly rate.
- Trees: The sum of Tree Count 1 and Tree Count 2 where they are
recorded on time slips
- M3/Tress: Actual production divided by Tree count -- this
calculated value can be compared to the entry for volume per tree on the
block to gauge how accurate is the estimated ratio.
- Actual Production: The volume of loads delivered in the selected
date range for that block, worker, equipment, activity as recorded on load
slips
- Cost/Volume: Total cost divided by Actual Production.
Where their are no matching load slips the value will be reported as zero.
- Volume/Hour: This is the ratio of your Estimated Production and
the number of hours worked.
Key Notes:
- Report is based solely on time slips (employee and contractor);
Production slips and miscellaneous expenses are excluded.
- Employee and Vendor pay calculators must be run for the report
- The actual delivered volume is calculated by matching time slips with load
slips based on employee, equipment unit, activity and block, all within the
selected date range. For volume to be matched up the employee and
equipment code (as well as the activity and block) must match between
the time slips and the load slip activities
- Matching of time slips and load slips requires that the same activities be
tracked on load slips (even though the activities may not be paid by load slip)
- Equipment cost is based on the equipment standard cost entered for each
unit (Maintenance time is NOT charged out at standard cost).
- Although report shows tree counts, actual production is driven off load
slips -- entry of tree counts is not required.
- Contractor costs will appear if the contractor is both the owner of the
equipment and the operator works for the contractor.
- Certain costs are omitted from this report. These include: (1)
Costs for contractor equipment where the operator is an employee, and (2)
Costs for contractor operators where the equipment is company-owned.
The total trees and production for an entire block is based on the
activity(ies) that are identified as the activity tagged 'Use for Production'
This flag is used to identify the activity that you want to use to govern the
total production for a block. For example, you might have production data
for skidding, bunching and delimbing. Which activity data serves as the
best estimate of overall block production. The 'Use for Production'
indicator is used to resolve this issue.
Example One:
Example Report 1 shows the report where employee payroll costs are calculated
based on each employee's base (as opposed to fully loaded) pay rate. The
column for actual production is based on the load tickets where the employee /
equipment combination are recorded in the loadslip pay activities for each load.
In this example the
worker/equipment data for a block are totaled for all days in the selected date
range. Note that the total trees and production for the block (on line 31)
shows the tree count and production for the activity flagged as the production activity (bunching is the activity that
is flagged as the production indicator, the other activities are not). Thus, the daily
tree counts and production (and cost/volume) for the block are based on the
values for bunching alone.
Example Report 1
Example Two:
Example Report 2 is the same as Report 1, except that the option "Fully
Loaded Employee Cost" has been selected. Note that the employee
payroll cost reflects the higher rates, and that the overall cost and cost/volume are
correspondingly higher.
Example Report 2
