Cost Summary Report

Report Type: Designer report

The Cost Summary Report shows the total cost of a schedule that can be filtered by location. Daily totals are provided for scheduled hours, paid time off, scheduled cost, actual hours, and actual cost.

The Cost Summary report is a report that displays three separate sets of summary information. All three summary queries are cross tab reports. The first cross-tab displays the Total Cost, Total Hours and Total Cost % by timecode or by hour type (page 1). The second cross-tab displays the Total Cost, Total Hours and Total Cost % by Timecode/Hour Type and by Job (page 1). The third cross-tab displays cost and hours by Team, by Day Part, by Job and by Timecode/Hour Type (page 2). The total cost, which is based on the dates selected, is also displayed at the very top of the report.

This report requires that you set different jobs for the employee of the team under Employee Labor Allocation, which you can access via Maintenance > Employees > Employee Basic Information - Override > Employee Overrides. For more information on setting default labor allocations foremployees, see "Creating employee labor allocation overrides" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.

This table describes the content of the Cost Summary Report:

Report selection parameters Report output fields
  • Budget Method.

    Select one of these budget types to specify the source of budget information:

    • None: No budget type is used.
    • FTE: The budget is derived using the number of full-time equivalents (FTEs) that may be applied.
    • Payroll as a % of Revenue: The budget (in dollars) is derived from a percentage of the forecast revenue.
    • Payroll Cost per Volume Unit: The budget is derived from a fixed cost per unit.
    • Total Hours: The budget (in hours) is derived from the forecast.
  • Budget Method Parameter: Specify the value of the budget type parameter.
  • FTE Hours/Week: Specify the number of hours of work per week that is equivalent to a FTE of 1.0.
  • Location: Select the locations to include in the report.
  • Team
  • Start Date
  • End Date
  • Show Parameters

For more information on these parameters, see Report selection parameters.

  • Returns
    • Forecast
    • Actual
    • Total
  • Revenue
    • Forecast
    • Actual
    • Total
  • Team
    • Average Rate
    • Scheduled Hours
    • Paid Time Off Hours
    • Scheduled Cost
    • Actual Cost
  • Total Scheduled Hours
  • Total Actual Hours
  • Total Scheduled Cost
  • Total Actual Cost
  • Total Realized Hours