|
Report: Production, Own Employees (#110)
|
|
Why:
You need a detailed report that shows your employee costs and production for your
workers where you keep track of your production through the use of tree counts
on your time slips.
Focus:
Focus of Report is to provide a summary, by block, of the hours worked
and payroll for your employees. The report provides a breakout of hours by
activity. If tree counts are entered on time slips, the report computes
the estimated production of the employee and the cost per unit of production.
- Report is based solely on employee time slips -- contract workers are
excluded
- Employee pay calculator must be run for the report
- Payroll Cost in report includes: Hourly Pay, Tree Count Pay and Pay
by Tree Volume.
- The usefulness of the report depends on the use of tree counts.
- The volume of production is based on the tree counts multiplied by the
volume/tree entered on the block. If two tree counts are enabled, the
tree count will be the sum of the two tree counts; the volume will be the
sum of the estimated production for each tree count.
- In the Total line for a Block, the "Tree Count" and
"Estimated Production" will NOT be the sum of the items for all
employees, but will be the sum of the items whose activity is flagged as the
production indicator.
Selection Window:
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.
- Fully loaded cost: The cost data can be reported on a direct payroll
basis (the default) or by using the loaded cost for employees.
- Payroll cost includes pay based on time slips, including hourly pay and/or
pay based on tree counts or tree volumes.
Detailed Description:
The report shows payments due for each load on an activity-by-activity basis. The
columns are:
- Block Code: Source Block of the load
- Employee: The employee
- Eq Code: Equipment Code
- Equipment: Equipment description
- Activity: Work activity
- Hours: Count of hours for the employee for the activity over the
date range
- Employee Payroll Cost: Payroll cost for the activity
- Hourly rate: Payroll cost divided by hours. This will be the
average rate taking into account any overtime.
- Trees: The sum of Tree Count 1 and Tree Count 2 on time slips
- M3/Tress: Estimated production divided by Tree count
- Estimated Production: The sum of the two tree counts each
multiplied by the volume per tree for the block (Each tree count is
first multiplied by its respective volume per tree; these two products are
then summed to arrive at estimated production)
- Cost/Volume: Payroll cost divided by Estimated Production.
Where no tree counts are recorded, the value will be reported as zero.
- Volume/Hour: Estimated production divided by hours
Note that in this report the estimated volume per tree is based on the values
you input when you set up a block:
When you set up a block you can enter one or two values for the volume per tree that are associated with the tree counts you enter on time slips.
Key Notes:
- Report is based solely on time slips (employee and contractor);
Production slips and miscellaneous expenses are excluded.
- The Employee pay calculator must be run for the report
- The usefulness of the report depends on the use of tree counts.
- The volume of production is based on the tree counts multiplied by the
volume/tree entered on the block. If two tree counts are enabled, the
tree count will be the sum of the two tree counts; the volume will be the
sum of the estimated production for each tree count.
- Employee payroll cost is calculated as either the direct payroll
cost or the loaded payroll cost based which you select when you run
the report.
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 bunching. Which activity data serves as the
best estimate of overall block production. The 'Use for Production'
indicator is used to resolve this issue.
Report:
Example One:
Example Report 1 shows the report that is based on straight payroll
cost. Note that the total trees for the block BL-62661 (on line 34)
shows the count for the bunching activity alone (bunching is the activity that
is flagged as the production indicator, felling is not). Thus, the tree
counts and production for the block are based on the value for bunching alone.
The block total is especially instructive. It shows the total payroll
cost for the block and total estimated production (again based on the buncher
counts), and the cost per unit of production -- in this case $6.20 / M3.
This is the average cost of production (for employees) in the block. Note
also that this report really only requires that one activity be flagged as
production (e.g. bunching) in order to derive the average payroll costs for a block.
Example Report 1
Example Two:
Example Report 2 is the same as Report 1, except that the fully loaded cost
option has been selected. Note that in this case the payroll costs are
based on the loaded employee rates and that the overall cost per M3 is now $7.05
instead of $6.20 as above.
Example Report 2
