|
Contracts, Employee Hours,
Summary (#202)
|
|
Why:
You need a summary listing of hours and payroll cost for your employees, by
activity performed, by
revenue contract.
Focus:
Focus of Report is to provide a summary listing, by revenue contract, of the hours worked
and the payroll cost of your employees, broken down by activity. The report provides a breakout of
the total hours and payroll cost by
employee and by
activity. The payroll cost shown in the report is calculated based on the direct
payroll cost or the loaded cost at your option. This report is a companion
report to the report Contracts, Employee Hours, Detailed (#204) in which the
data are reported on a daily basis.
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.
- Contract: You can select any or all of your revenue contracts.
- The "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.
- Fully Loaded Employee Cost: Payroll cost is calculated as the direct
payroll cost (by default), but this option allows you to use the loaded
rates to calculate the payroll cost.
Detailed Description:
The report shows payroll costs for each employee on an activity basis. The
columns are:
- Contract: Revenue Contract
- Employee: Full name of the employee
- Activity: Work activity
- Hours: Count of hours for the employee for the activity over the
date range
- Employee Payroll Cost: Cost for the activity (default is based on standard
cost)
Key Notes:
- Report is based solely on employee time slips (no contractor time is
included).
- Employee pay calculator must be run for the report (employee costs
are computed when the employee calculator is run)
- Payroll cost includes the cost for hourly pay, it does not include
pay based on tree counts and pay based on tree volumes.
- Payroll cost for employees is based on the direct payroll cost (by
default), but can be calculated using loaded rates at your option.
Report:
Example One:
Example Report 1 shows the report where the cost data grouped by revenue
contract and
then by employee.
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 the higher cost for
each employee.
Example Report 2
