LFSO reports

Each report has different parameters. Some parameters are shared by multiple reports, and others are unique to one report.

See Report selection parameters.

This table describes the reports under Birst Reports > Operational Reports > Scheduling > LFSO.

Report Description
Availability Summary Report Shows summary availability information for a selected location over a specified time period. For each day the report shows the number of employees who are scheduled, available, and off.
Note: The Make Availability Reportable task must be run to generate the data for this report.

See Scheduling the Make Availability Reportable task.

Business Performance Report Shows sales results versus payroll costs for a number of locations for the current time period as well as the previous time period as selected by user.

Each row displays the key performance indicators for a store. Clicking on a location will open another report displaying the KPI table as well as the graphs comparing KPIs for the current and previous time period.

Note: This report displays both published and unpublished schedules.
Cost Summary Report The Cost Summary Report shows the total cost of a schedule, which 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 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 for employees, see "Creating employee labor allocation overrides" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.

Enterprise Productivity Report The Enterprise Productivity Report provides information for a location during a given period of time (Week to Date, Month to Date, or Year to Date) for two different volume types.
Forecast Summary Report Shows the daily forecast volume information for a specified start and end date at a given location. This view provides the details of inherited (fixed/dynamic) forecast information for all sublocations. This report also includes staffing details for the specified time period.
Note: The Make Availability Reportable task must be run to generate the data for this report.

See Scheduling the Make Availability Reportable task.

Forecast vs. Actual Labor Performance Report This report is a drill-through report that shows sales versus forecast sales and labor versus forecast labor for a given location. Each row represents a location with key performance indicators (KPIs) aggregated from sub-locations for the selected date interval. Clicking a location in the parent report will drill-through to the corresponding graphs indicating the forecasted and actual sales, labor dollars and hours.
Forecast vs. Schedule vs. Actual Hours By Day Report This report lists the forecasted hours, scheduled hours, actual hours, and variances for a store. A bar graph displays the forecasted, scheduled, and actual hours for the selected store and date range to facilitate comparison. Forecasted hours are determined by labor forecast staffing requirements. Non-working activities such as breaks are excluded from scheduled hours.
Note: This report displays both published and unpublished schedules.
Forecast Wage Cost Report The Forecast Wage Cost Report displays the forecasted number of hours employees are scheduled to work, broken down by hour type, along with the associated cost. Note that this report shows hours and cost as per the last Forecast Wage Cost calculation, which must be run separately to ensure accurate and complete results. The results are grouped by department and store.
Net Staffing By Hours Report This report shows the total number of work hours applied to a schedule that can be filtered by location and/or job. Daily totals as well as schedule totals are provided.
Payroll Variance Report This report shows payroll variance details, including Budget Sales, System Forecast, Manager Adjusted Forecast, and Actual Sales for a selected time period. The report shows four different worksheets.
Productivity Summary Report This report provides productivity information for a specified location for a given time period. The scheduled productivity (based upon forecast volume, scheduled hours, average hourly rate, and projected payroll) is calculated for both volume per hour, and volume per wage dollar. The report will calculate the actual volume per hour, volume per wage dollar and payroll percentage of volume for each sublocation.
Note: The Make Availability Reportable task must be run to generate the data for this report.

See Scheduling the Make Availability Reportable task.

Productivity Variance Report The Productivity Variance Report provides labor information and includes a comparison between productivity standards (as set up for location) and actual productivity. The report also shows the variance between scheduled and actual hours and the variance between projected and actual payroll.
Note: This report displays both published and unpublished schedules.
Schedule Audit Report The Schedule Audit Report allows you to view published schedules for an employee based on the date range selected. In addition, the report also displays schedule detail overrides that have been applied to an employee’s schedule(s). The override information includes details such as the override type, who applied the override, when the override was applied and the status of the override.

The report can be filtered by Team, Employee and Date Range. The schedule detail overrides can be filtered by Override Type and Override Status.

Note: The report will display all published schedules including those without any overrides applied.
Schedule By Employee Report This report shows the daily schedule by employee with optional job filtering.
Schedule Compliance Violations Report For users of LFSO or MVS with schedule compliance, the report lists all the compliance warnings and errors that are incurred for the specified employees, teams, and period.

The schedule period options in the Date Selection parameter are only valid for use in MVS scheduling. The other options (This Week, Next Week, and Previous Week) are valid for both LFSO and MVS scheduling.

You can filter the results by:

  • Type of violation (warning, error)
  • Users who approved a violation(s)
  • State of the violation (approved, unapproved)
Schedule Effectiveness Report This report shows a comparison between schedule requirements and assignments made for each hour of the day. The report shows total hours per day and week, and effectiveness per day and week.
Schedule Effectiveness Summary Report The Schedule Effectiveness Summary report displays the coverage and efficiency per day for the entire schedule of one or more location(s). The report also displays the average coverage and efficiency for each location and sub-location and at higher levels of the hierarchy, allowing executives and managers to see the big picture of schedule quality. The report allows you to set a threshold to highlight coverage and efficiency for periods that are below the specified threshold.
Note: The Schedule Date selected will return the entire schedule on which the date falls. The average coverage and efficiency for the lowest two levels in the hierarchy match what is displayed in the schedule screen, while the average for every other higher level is calculated at the report level based on the average of the lowest level (For example, Department).

The Schedule Report flag and Schedule Date Offset applies when scheduling the report and must be selected so that the system date is utilized to calculate the Schedule Date.

See Coverage and efficiency calculations.

Weekly Time Card Report This report shows the scheduled and actual work start and end times for employees at a specified store. If there is no scheduled start and end time for an employee on a particular day, no data for that type will be displayed (and vice versa). The time period for this report is determined by a user-selected date range, and the employee's department, job, and breaks are also displayed. There is also a time code and hour type cross-tab summary that indicates the hours worked by the employee for each code.