You are here: Demand Manager for Administrative Users > How Demand Manager Calculates Staffing Levels

How Demand Manager Calculates Staffing Levels

This topic describes how Demand Manager calculates target staffing. The calculations are the same whether the profile also uses Outcomes-Driven Acuity; the only variable is the number of acuity levels associated with the ADT Adjusted Hours per Patient Day (HPPD). Profiles with Demand Manager use only one acuity level; profiles with both Demand Manager and Outcomes-Driven Acuity use multiple acuity levels.

About Demand Manager

Demand Manager is a real-time demand-driven staffing methodology. It pinpoints the number of staff needed by skill (such as RN and UAP) and by time of day to help each patient achieve better health.

Each nursing unit provides the budgeted direct care hours per patient day by skill. This value represents the care hours (workload) delivered to an average patient on the unit. For example, a patient on the 6N MedSurg unit may need an average six hours of RN direct care and one hour of UAP care per day. In a day with three eight-hour shifts, translating six RN care hours per day into RN: patient ratios for staffing gives us a ratio of 1:4. This means a RN on this unit can care for four patients during each eight-hour shift.

Demand Manager also measures the care workload associated with patient admissions, transfers, and discharges (ADT) as they occur during shifts. Units can improve their scheduling and staffing if they have accurate data about workload associated with actual and projected ADT events. Each unit provides ADT data including how patients arrive (admit versus transfer in) and depart (discharge versus transfer out) and how much time caregivers by skill, on average, spend with each patient to complete the ADT process.

Demand Manager and ADT-Adjusted HPPD

Demand Manager subtracts the amount of care needed to manage patient ADT events from the direct care HPPD, then adds that time back in when the event actually occurs. This maintains a neutral budget with the result matching or being very close to the budgeted hours of direct care. Removing the impact of ADT events from HPPD gives us the ADT Adjusted HPPD. In order to keep the budget neutral, the budgeted direct care HPPD are very close or equal to the calculated HPPD. This is based on each unit’s budgeted census and staffing pattern.

Demand Manager calculates ADT Adjusted HPPD with the following data:

For accuracy, your organization’s registration application should be used to obtain the percentage of patients admitted, discharged, and transferred by profile over the past 6 to 12 months. You should review the ADT percent data in Staff Manager annually and use it to update the demand configuration.

Clinical leaders across similar units usually define the average ADT times by consensus. It is highly recommended that each organization provide these times, as they are influenced by many organization-specific factors.

When a profile’s ADT data is unavailable, Demand Manager uses the following standards:

Critical Care Units

Skill Arrive by Admission Arrive by Transfer In Leave by Discharge Leave by Transfer Out
Percent of patients 75% 25% 20% 80%
RN minutes/event 90 70 70 45
UAP minutes/event 15 15 10 15

Intermediate Care Units

Skill Arrive by Admission Arrive by Transfer In Leave by Discharge Leave by Transfer Out
Percent of patients 70% 30% 45% 55%
RN minutes/event 70 45 50 40
UAP minutes/event 15 15 10 15

Routine Care Units

Skill Arrive by Admission Arrive by Transfer In Leave by Discharge Leave by Transfer Out
Percent of patients 75% 25% 90% 10%
RN minutes/event 60 45 50 40
UAP minutes/event 15 15 10 15>

Rehab Units

Skill Arrive by Admission Arrive by Transfer In Leave by Discharge Leave by Transfer Out
Percent of patients 100% 0% 100% 0%
RN minutes/event 60 0 75 0
UAP minutes/event 15 0 15 0

Variable HPPD Staffing Care Hours/Ratio

For each nursing unit, Demand Manager calculates a budget neutral caregiver to patient ratio by time of day for each skill. It does this using the budgeted daily census, the budgeted staffing pattern for direct patient caregivers, and the ADT-Adjusted HPPD

Demand Manager converts the nurse to patient ratio to hours per patient shift (HPPS) and then calculates the sum of hours. This ensures that the blended HPPD are close to ADT-Adjusted HPPD for the unit.

Sample Calculation of Target Staffing for Demand Manager

Assume a unit provides the following data:

The ADT Percentages and Times would then display as in the following table.

Arrive by Admission Arrive by Transfer In Leave by Discharge Leave by Transfer Out
Percent of patients 37% 63% 75% 25%
RN minutes/event 60 45 60 45
UAP minutes/event 30 20 20 20
Total Time per Event (minutes) 90 65 80 65

The Staffing Pattern for direct caregivers at the budgeted census of 22 is:

Shift Length in Hours Number of RNs Number of UAPs Total Caregivers Hours
7a-11a 4 6 2 8 32
11a-3p 4 6 2 8 32
3p-7p 4 5 2 7 28
7p-11p 4 5 2 7 28
11p-3a 4 4 3 7 28
3a-7a 4 4 3 7 28
Total Hours per Day 24 176
Calculated HPPD
(Total Hours per Day ÷ Budgeted Census)
8.00

The client provides the direct care staffing distribution for the budgeted census of 22 in any combination of periods for each day of the week.

Demand Manager calculates the ADT Impact using the following formula. The formula uses the SUMPRODUCT function, which multiplies groups of numbers together, then adds up the results.

SUMPRODUCT ((Admit time in hours ÷ LOS) * percent of patients admitted) + (Transfer in time in hours ÷ LOS) * percent of patients transferred in + (Discharge time ÷ LOS) * percent of patients discharged + (Transfer out time ÷ LOS) * % of patients transferred out))

All times are total ADT times (all skills) and expressed in hours.

Using the data above, this is:

SUMPRODUCT ((1.50 ÷ 3.88) * 0.37 + (1.08 ÷ 3.88) * 0.63 + (1.33 ÷ 3.88) * 0.75 + (1.08 ÷ 3.88) * 0.25) = 0.65

The Calculated Direct HPPD minus ADT Impact equals the ADT Adjusted HPPD (8.00 - 0.65 = 7.35).

The ADT Adjusted HPPD divided by the Calculated Direct HPPD equals the percent ADT Adjustment (7.35 ÷ 8.00=0.919).

Demand Manager converts the staffing distribution to ADT Adjusted Staffing by multiplying the direct staffing value by the percent ADT Adjustment of 0.919.

Direct Staffing ADT Adjusted Staffing (Direct Staffing * 0.919)
RN UAP RN UAP
7a-11a 6 2 5.52 1.84
11a-3p 6 2 5.52 1.84
3p-7p 5 2 4.60 1.84
7p-11p 5 2 4.60 1.84
11p-3a 4 3 3.68 2.76
3a-7a 4 3 3.68 2.76

Staff Manager makes all Demand target calculations using the ADT Adjusted Staffing.

The ADT-Adjusted Staffing is converted to caregiver to patient ratios by dividing the budgeted census of 22.00 by the ADT Adjusted Staffing:

Calculations Caregiver to Patient Ratio
Time of Day RN UAP RN UAP
7a-11a 22 ÷ 5.52 22 ÷ 1.84 1: 3.99 1: 11.97
11a-3p 22 ÷ 5.52 22 ÷ 1.84 1: 3.99 1: 11.97
3p-7p 22 ÷ 4.60 22 ÷ 1.84 1: 4.79 1: 11.97
7p-11p 22 ÷ 4.60 22 ÷ 1.84 1: 4.79 1: 11.97
11p-3a 22 ÷ 3.68 22 ÷ 2.76 1: 5.98 1: 7.98
3a-7a 22 ÷ 3.68 22 ÷ 2.76 1: 5.98 1: 7.98

Staff Manager uses nurse to patient ratios to configure the minutes of care needed over time. Staffing ratios, by skill, are converted to the minutes of care required each hour. This is done by dividing the patient ratio value by the duration.

Examples: Simple RN/Patient Ratios Converted to Minutes of Care

Staff/Pt. Ratio Length in Minutes Calculation Care minutes required
1:4 60 60 ÷ 4 = 15 15 min. of care in 1 hour for 1 patient
1:3 60 60 ÷ 3 = 20 20 mi. of care in 1 hour for 1 patient
1:2 60 60 ÷ 2 = 30 30 min. of care in 1 hour for 1 patient

Staff/Pt. Ratio Length in Minutes Calculation Care minutes required
1:3.99 60 60 ÷ 3.99=15.04 15.04 minutes of RN care in 1 hour for 1 patient between 0700 and 1500
1:4.79 60 60 ÷ 4.79=12.52 12.52 minutes of RN care in 1 hour for 1 patient between 1500 and 2300
1:5.98 60 60 ÷ 5.98=10.03 10.03 minutes of RN care in 1 hour for 1 patient between 2300 and 0700
1:11.97 60 60 ÷ 11.97=5.01 5.01 minutes of UAP care in 1 hour for 1 patient between 0700 and 2300
1:7.98 60 60 ÷ 7.98=7.52 7.52 minutes of UAP care in 1 hour for 1 patient between 2300 and 0700

Example: Calculating the Number of Caregivers Required for a Shift

Assume that the census at 0700 on Monday was 18 and that no ADT activity was recorded over the next 24 hours. This would result in a census of 18 at 0700 on Tuesday (that is, the same patients were still on the unit).

The target staffing for each ADT adjusted staffing variable would be as follows.

Census of 18, No Turnover
Time Hours per period Target Staffing per patient per shift
RN 0700-1500 (15.04 min/hour * 8 hours) ÷ 60 2.01 hours
RN 1500-2300 (12.52 min/hour * 8 hours) ÷ 60 1.67 hours
RN 2300-0700 (10.03 min/hour * 8 hours) ÷ 60 1.34 hours
UAP 0700-1500 (5.01 min/hour * 8 hours) ÷ 60 0.67 hours
UAP 1500-2300 (5.01 min/hour * 8 hours) ÷ 60 0.67 hours
UAP 2300-0700 (7.52 min/hour * 8 hours) ÷ 60 1.00 hours

The following table outlines what the Target Staffing would be in hours per 8-hour shift by skill for a census of 18 with no patient turnover.

Time of Day RN Hours UAP Hours Total Hours Total Staff Hours ÷ 8 Total RN ÷ 8 Total UAP ÷ 8
0700-1500 36.18 12.06 48.24 6.03 4.52 1.51
1500-2300 30.06 12.06 42.12 5.27 3.76 1.51
2300-0700 24.12 18.00 42.12 5.27 3.02 2.25
TOTAL 90.36 42.12 132.48 16.57 11.30 5.27

Impact of Patient Events: Other Patient Events

Demand Manager allows you to enter Other patient events in order to override or augment the workload generated by Demand to capture the target staffing more accurately. Other patient events can be used to generate the workload associated with a patient’s need for a care companion, caregivers that accompany a patient off the unit, and bedside procedures. Event duration by global skill may be specified for each patient; the caregiver to patient ratios are 1:1, 2:1, or 3:1.

Example 1

A patient has a 1:1 care companion event for global skill PCC (patient care companion) from 0800 -1000. The Other event for PCC is entered as an Add event. What is target nursing workload from 0700 to 1100 for this patient? Assume that there are no other events for the patient.

Target Staffing in Hours for 1 patient 7:00 to 11:00

Formula Used Staffing Hours
Demand Target: 0700-1100 RN (4.0 hours * 15.04 minutes/hour) ÷ 60 minutes 1.00
UAP (4.0 hours * 5.01 minutes/hour) ÷ 60 minutes 0.33
Target Staffing 1.00 RN hours + 0.33 UAP hours 1.33
Other Event Target: 0800-1100 PCC 1:1 for 2 hours 2.00
Total Target Staffing: 0700-1100 2.00 Other Event Target Staffing hours + 1.33 Demand Target Staffing hours 3.33

Example 2

A patient has a 2:1 event for 2 RNs to accompany the patient off the unit from 0800 -1000. The Other event for RN is entered as a Replace event. What is target nursing workload from 0700 to 1100 for this patient? Assume that there are no other events for the patient.

Target Staffing in Hours for 1 patient 7:00 to 11:00

Formula Used Staffing Hours
Demand Target:
RN 0700-0800, 1000-1100
UAP 0700-1100
RN (2.0 hours * 15.04 minutes/hour) ÷ 60 minutes 0.50
UAP (4.0 hours * 5.01 minutes/hour) ÷ 60 minutes 0.33
Target Staffing 0.50 RN hours + 0.33 UAP hours 0.83
Other Event Target: 0800-1100 RN 2:1 for 2 hours 4.00
Total Target Staffing: 0700-1100 4.00 Other Event Target Staffing hours + 0.83 Demand Target Staffing hours 4.83

Demand Manager calculates Demand target staffing in real-time by patient each time an actual or projected event is processed throughout the length of the patient’s progress pattern. In addition, backdating an Other patient event or publishing a backdated configuration that includes a change, such as a change to ADT-adjusted HPPD or the staffing distribution, triggers Demand target staffing re-calculation for past dates.

Impact on Staffing Projections

Projected Demand Target staffing can be seen in the following views and reports.

Projected Target Staffing is calculated as follows for 36 hours from now (now being the current time, regardless of the report period selected).

  1. Target Staffing includes current demand workload values adjusted for time of day and projected departure and discharge event workload as calculated by using the pattern end date as originally assigned or by using updated dates and times entered on the Administer Patient Pattern window (or updated through an alternate source solution) for each patient. Projected departure and discharge dates on the Administer Patient Pattern window must be kept up to date to ensure accurate target staffing calculations.
  2. In reports and views that include direct care and non-direct care global skills, the application pulls target staffing calculated from the workload matrix, which is stored in Workload Planner. This forces the inclusion of non-direct care staff such as managers and clerical staff. Demand targets for demand-driven staff (such as the RNs and UAPs used in this example) or staff associated with an Other Patient event entered in Demand Manager replace the target staffing from Workload Planner. This approach produces an accurate staffing projection for the next 36 hours based on current patients, acuity, and expected departures. From a process perspective, the only data missing is the calculated impact of expected admissions and transfers in. When Demand Manager auto-pushes patterns forward, the projected dates on the Administer Patient Pattern window do not change and departure workload is not calculated. When running reports for past dates, the targets include workload for actual ADT events; the target only includes workload for events that actually occurred.

Beyond 36 hours from now, a 6-week historical average is used to calculate the Projected Demand Target. The average includes the actual demand workload and workload associated with actual admissions, discharges and transfers, but excludes the workload impact of Other patient events.

Summary of Calculations

Demand Manager calculates Target Demand Staffing for each skill in real-time as the unit census changes and as actual and projected patient activities increase or decrease. This means if the configuration changes, such as a change to ADT-Adjusted HPPD or time of day variability, Demand Manager updates the target staffing for all patients based on the effective date of the configuration. The application calculates and recalculates each patient’s future staffing needs each time it processes an event for the patient for the length of their assigned Progress Pattern.

The result is a Demand Management Staffing methodology that:

Related Topics