Labor Management Explorer

My Folder

Product Overview

Labor Management Explorer is an analytics tool that allows managers to understand basic operational and staffing indicators to facilitate more efficient labor force utilization. Users access and dynamically interact with EMR, HR, and Timecard data from multiple sources systems to discover meaningful opportunities for improvement.

For example, users can:

  • Attain actionable information about key metrics such as work hours per unit of service (WHPUOS), overtime hours per unit, and contract staff.
  • Review temp hours, scheduled and unscheduled PTO.
  • Trend various measures over time (compare this year to last year.)

Features

  • Enables manager to understand basic operational and staffing indicators.
  • Facilitates more efficient labor force utilization.
  • Access and dynamic interaction with data from EMR, HR and Time card systems.

Measures

Measures

  • Work hours per unit of service (WHPUOS)
  • Departmental volumes
  • Overtime hours
  • Temp hours
  • Scheduled and unscheduled PTO

Benefits

Benefits Include:

  • Increase near-real-time and retrospective data to analyze staffing levels and ratios to align staffing goals with actual volumes.

See Sample Screenshots of Labor Management Explorer

Data Sources

  • View Table Available Under Deeper View

Labor Management: A Deeper View

Background

In U.S. healthcare,

  • More than $225 billion in spending goes to the salaries and benefits of hospital employees.
  • Labor costs, as a percentage of total hospital spending , are approximately 60%

Users

Labor Management Explorer is intended for those responsible for tracking, reporting, and analyzing staffing metrics enabling efficient, evidence-based coordination of existing and needed labor resources. This usually includes hospital administrators, clinical and operations directors, and unit managers.

  • Leadership responsible for managing labor resources.
  • Any leaders who may want to delve deeper than static reports to identify trends and potential
    improvement areas.

Success Measures

Opportunity Identification:

  • Identify potential $ saved in units with high utilization of premium pay
  • Identify correlation discrepancies between utilization of premium pay and volumes
  • Identify potential savings through reduction of third party vendor solutions

Process Improvements:  

  • Data availability increased from monthly to daily
  • Multiple data sources integrated and consumable for leadership in a consolidated format

Data Sources

All of the data used within Labor Management Explorer are gathered from human resources (HR), time tracking, episode of care, and/or billing data. HR and time tracking data will enable the application to report hours based on an employee’s home department or cost center and to classify the types of hours, such as regular, overtime, or temporary. Episode of care and billing data enable patient volume calculations to give further insight into labor variations.

Content

Possible Sources

Patient statistics/volumes by department forActual and Budget by time period, including:

  • Visits
  • Patient days
  • Discharges
  • Cases
  • Procedures
Billing financials for ‘actual’ volumes, typically calculated from procedures or cost centers, but will vary by department. (Epic, Soarian, Cerner, EPSI)Budgeting or imported spreadsheet for ‘budget’ volumes
Mapping of earnings codes to worked/paid hours Payroll or Time Tracking system (such as Kronos, PeopleSoft, SAP)
Cost center rollup hierarchy for reporting structure Budgeting or Costing system, general ledger (such as EPSI, TSI, PeopleSoft)
Mapping of job code hierarchy (Job Family, Group, Code – such as administrative, clinical, nursing) Human Resources or Time Tracking system (such as Kronos, PeopleSoft or SAP)
Human Resource’s Hours — actual and budget by time period, including:

  • Cost center
  • Job code
  • Earning type codes (Regular, Nonproductive, Contract labor, Over Time (OT), Float, Float OT)
Payroll or Time Tracking system (such as Kronos, PeopleSoft, SAP)Budgeting system or imported spreadsheet for ‘budget’ hours
Target work hours per volume Budgeting or imported spreadsheet for ‘Target’ hours