FTE VARIANCE_CALCULATION

 

 

Order Description

 

 

calculate full-time equivalents for a nursing unit and analyzing a variance scenario.

 

Answer the questions and complete the calculations required for the two sections of the assignment.
• Calculations of full-time equivalents (FTEs)
• Variance analysis
Submit your answers on a Word document, with the heading of Week 4 Assignment. For the questions requiring a written response, please adhere to proper grammar and syntax, and provide references.
For the questions requiring calculations, show all your work and follow the format that has been provided for the calculations in the lesson for Week 4.

 

 

 

PREPARING THE PAPER
Section One—Calculation of Full-Time Equivalents

Personnel Budget Case Study

Linda Watson has recently accepted a position as the assistant administrator for the department of nursing at St. Joseph Hospital. There have been both personnel and financial problems at St.
Joseph Hospital, and recently, the Catholic Healthcare System purchased the hospital. Like Linda, all of the management staff is new. Linda’s first priority is to assist the nurse managers in
preparing their cost centers’ personnel budgets for the coming fiscal year. She has decided to begin with the nurse manager on 1 West, a step-down nursing unit. Linda wants to do extensive data
collection and create a solid base for making projections.
1. Suggest all the information Linda needs to collect to prepare a budget for 1 West; be sure to include background data on the unit itself as it relates to previous budgets, nursing staff, and the
organization. In other words, summarize your approach to this Case Study—briefly state the organization’s goals (customer-service orientation) for the coming year, trends, any changes in trends
that you may anticipate—such as growth in the patient population and the types of data that need to be collected in order to make decisions about staffing levels and ratios.
2. Linda has collected the following information, in addition to what was asked in question number one:

Patient Data:

Average Daily Census 30
Unit Capacity 32
Average HPPD 8.8
Total Care Hours 96,360

Staff Data:

Productive hours/employee/year 1,780
Nonproductive hours/employee/year 300
Total Hours/employee/year 2,080

Skill Mix:

RNs 80%
LVNs 10%
Nurse aides 10%

Average Salary per Employee Category:

RN $40.00/hour
LVN $22.00/hour
Nurses Aide $14.00/hour

Calculate the number of productive full-time equivalents (FTEs) that would be needed. Show your calculations.
3. How many RNs, LVNs, and nurses aides will be needed to staff this unit, assuming staff will be working 12-hour shifts? In other words, how many person-shifts will be required during a 24-hour
period?

Day Shift 50%
Night Shift 50%

4. Assign staff by type and by shift.

Day Shift 50%
Night Shift 50%

5. Convert staff positions to FTE positions.

Section Two—Variance Analysis

Variance Analysis Case Study

During the month of February, an outpatient surgery clinic has incurred a significant unfavorable variance. The director of the clinic is quite concerned, as this has never occurred before. The
director gathers information on total nursing care hours, average hourly rate of the employees, and total patient visits to determine what caused the variance. In addition, the director receives
the patient acuity levels for the month of February.

1. BPi $40.00
2. BQi 5.0 hours per care per patient
3. BQo 340 visits

4. APi $45.00
5. AQi 5.6 hours per care per patient
6. AQo 400 visits

1. Compare the original budget to the flexible budget and calculate the volume variance. Compare the flexible budget to the actual budget and determine the price and quantity variances. Work
through the entire analysis process as presented in your lesson for Week 4, and remember to show your calculations.
2. What factors caused the difference in the variances? Analyze all the factors that made the differences and why the variances occurred.

 

 

 

 

Category Points % Description
Background Information 15 15% Typically, the description of the maximum level of performance is provided here
Calculation of Full-Time Equivalents (FTEs) 10 10%
Shifts Required During a 24-Hour Period
10 10%
Staff Assigned by Type and Shift 10 10%
Staff Positions to FTEs 10 10%
Calculation of Volume Variance 10 10%
Calculations of Price and Quantity 10 10%
Calculation of Total Variance 10 10%
Analysis of Variances 15 15%
100 100
A quality assignment will meet or exceed all of the above requirements.

GRADING RUBRIC
Assignment Criteria Exceptional
(100%)
Outstanding or highest level of performance Exceeds
(88%)
Very good or high level of performance Meets
(80%)
Competent or satisfactory level of performance Needs Improvement
(38%)
Poor or failing level of performance Developing
(0)
Unsatisfactory level of performance
Content
Possible Points = Points

 

Background Information 15 Points 13 Points 12 Points 6 Points 0 Points
Background information for budget analysis is thoroughly and clearly identified and stated. Background information for budget analysis is partially identified and stated, but could be more thorough
or clear. Background information for budget analysis lacks thorough and clear statements. Background information for budget analysis is minimally identified and stated. Background information for
budget analysis is not identified or stated.

Calculation of Full-Time Equivalents (FTEs) 10 Points 0 Points
Calculation of FTEs is correct. Calculation of FTEs is incorrect.
Shifts Required During a 24-Hour Period
10 Points 0 Points
Shifts required during a 24-hour period are correctly calculated. Shifts required during a 24-hour period are incorrectly calculated.

Staff Assigned by Type and Shift 10 Points 5 Points 0 Points
Staff assigned by type and shift are correctly calculated.
Staff assigned by type is correctly calculated; staff assigned by shift is incorrectly calculated.
Staff assigned by type is incorrectly calculated; staff assigned by shift is correctly calculated.

Suggest: One of the following is not correctly calculated: staff assigned by type or staff assigned by shift. Both staff assigned by type and by shift are not correctly calculated.

 

Staff Positions to FTEs 10 Points 0 Points
Calculation of staff positions to FTEs is correct. Calculation of staff positions to FTEs is incorrect.
Calculation of Volume Variance 10 Points 0 Points
Calculation of Volume Variance is correct. Calculation of Volume Variance is incorrect.
Calculations of Price and Quantity Variance 10 Points 0 Points
Calculation of Flexible Budget Variance is correct. Calculation of Flexible Budget Variance is incorrect.
Calculation of Total Variance 10 Points 0 Points
Calculation of Total Variance is correct. Calculation of Total Variance is incorrect.
Analysis of Variances 15 Points 13 Points 12 Points 6 Points 0 Points
Analysis of variances is thoroughly and clearly identified and stated. Analysis of variances is adequately identified and stated. Analysis of variances is partially identified and stated. Analysis
of variances is minimally identified and stated. Analysis of variances is not identified and stated.

Content Subtotal 100 of points
Total Points _____of points

LESSION
With the current economic climate of healthcare, the nurse executive needs to be proficient in the management of fiscal and human resources. A key component of the nurse-executive role, as
identified by the American Organization of Nurse Executives (AONE) Nurse Executive Competencies (AONE, 2005) is business skills. Business skills encompass both financial management and human-
resource management. The first step in either area is an assessment of the resources of the organization, the strategic plan for the organization, and current needs of the organization. Without
this assessment, the nurse executive cannot effectively develop and manage resources.
Budget
“What is a budget? In simple terms, a budget is a statement of a financial plan over a period of time. A budget provides guidance on how the resources of an institution will be used to meet its
strategic plan. The organization’s financial performance is measured against the budget. In some healthcare institutions, middle- and upper-level managers’ performance appraisals and incentives are
aligned with the fiscal performance of the institution.
Budgeting Process
The nurse executive will start the budgeting process by comparing the actual results of the prior fiscal year with the proposed budget of that year. This review also involves an evaluation of the
outcomes of the strategic plan against the budget. The next step in the process is to review the current strategic plan, determine the resources needed to meet the goals for patient care, and
establish the needs of the nursing department. To accomplish that step, the nurse executive must have, at minimum, the following data: patient days, patient acuity, length of stay, staffing model,
staff mix, number of open positions by level, number of anticipated vacancies by level, cost of agency staff by unit, projected salary increases and bonuses, cost of staff benefits, educational
needs of the staff in the upcoming fiscal year, and anticipated nonproductive staff time. Other information that will be crucial to the budgeting process will include any anticipated regulatory
changes, regulatory surveys anticipated for the fiscal year, status of equipment on nursing units, and anticipated changes in reimbursement. The nurse executive cannot develop the budget in
isolation. Input by nurse managers, unit directors, the finance department, and the human resource department is critical to a successful budget development cycle.
Calculating a Salary Budget
The salary budget is generally the largest element in the budget of the organization. The salary budget is established by determining the number of full-time-equivalent (FTE) staff needed for the
fiscal year. To prepare a salary budget, the first step is to figure out the volume of work for the coming year. The amount of work performed by a unit/department is referred to as the workload.
Workload can be measured in a variety of ways, such as the number of patient days, number of outpatient visits, and number of operations per day. Each cost center determines the measure that is
most appropriate for its unit of service. The next step of the budget process will be to predict the number of units of service that will be provided the coming year. This is usually based on the
past year’s number of units, plus a predicted incremental increase for the coming year, based on population increases and needs.
Budgeting is based on a patient-classification system, which is the amount of resources used related to different levels or categories of patient acuity. For example, let’s say that a certain
cardiac-observation unit is forecasting 12,500 patient-days for the coming year. Assume that this unit classifies these 12,500 patients into one of four categories: category one being fewest
resources used or lowest acuity; and category four being most resources used or highest acuity patients. Assume that, for category one, the average-patient-care-hours equals 1.5 hours of nursing
care provided to these patients during a 24-hour period; for category two, 5.0 care hours; for category three, 8.0 care hours; and, for category four, 12.0 hours of nursing care is provided to
these patients during a 24-hour period. Hours-per-patient-day (HPPD) is the number of hours of nursing care delivered per patient. To calculate HPPD, the total-care-hours required for the year is
divided by the number of patient days.
Calculating Hours Per-patient-day
1. Establish Hours-Per-Patient-Day (HPPD)
a. Calculate the total-care-hours required for the year:

# of Patient Days X Average Care Hours/24 Hours = Total Care Hours

1 1,000 1.5 = 1,500

2 2,500 5.0 = 12,500

3 4,000 8.0 = 32,000

4 5,000 12.0 = 60,000

12,500 106,000 total-care-hours needed
b. Calculate the hours-per-care-per-patient-day (HPPD):
Total-Care-Hours Required for the Year / Number of Patient Days

106,000 / 12,500 = 8.48 care hours
Thus, for this cardiac observation unit, an average of 8.48 nursing-care hours are provided to patients per a 24-hour period. Once the manager has the workload forecasted, the next step is to
determine the staff requirements for the unit. Staff mix varies from hospital to hospital and may consist of RNs, LPNs, and aides. The manager needs to determine how many full-time equivalents
(FTEs) will be required to provide patient care. One FTE is equivalent to 2,080 hours per year (40 hours per week times 52 weeks). A 0.9 FTE is equivalent to 36 hours per week; a 0.6 FTE is equal
to 24 hours per week. If the manager calculated FTE requirements by dividing total-care-hours by 2,080 to determine the number of FTEs for the unit, this would underestimate the needed FTEs. This
calculation would assume that all 2,080 paid hours were worked by the staff member. However, employees take vacation time, sick leave, and educational days—which are nonworked time, or
nonproductive hours. Instead, we must relate to productive hours rather than paid hours. Data on nonproductive hours are generally provided by the institution’s payroll department and equal between
15–20% of paid hours. In our example, let’s say that productive hours equal 85% of the employee time worked, which would equal 1,768 productive hours.
FTE Calculation
2. Apply HPPD to Census and Determine Full-Time Equivalents (FTEs)
a. Determine FTE requirements for number of expected patient -care hours:
Total Care Hours /1,768 productive hours per FTE
(1,768 = 85% of 2,080; 40 hours per week X 52 weeks per year = 2,080; less vacation, sick, education time)
106,000 / 1,768 = 59.95 FTEs = 60 FTEs
Next, the manager must determine how to allocate the number of FTEs per position type and shifts. To calculate how many staff members will be working every day, first determine the number of care
hours that are required per day.
Staff Requirements
3. Establish Positions by Type and Shift
a. Calculate number of staff required per 24-hour period:
Divide total care hours by 365 days per year

106,000 / 365 = 290 hours of care per day
Assuming employees work 12 hour shifts:
290 / 12 = 24.2 shifts per 24-hour period
Let’s say in our example, 80% of the shifts are allocated to RNs and 20% to aides. Assume that 50% of the RN/aide shifts are for day shift (7a–7p) and 50% for the night shift (7p–7a).
Staff Requirements Continued
3. b. Assign staff by type:
80% RN staff; 20% aides
.80 X 24.2 = 19.4 RN shifts ? 20 RN shifts
.20 X 24.2 = 4.8 aide shifts ? 4 aide shifts
24.2 24
c. Assign staff by shift:
Day Shift Night Shift Total
50% 50%

RNs 9.7 ? 10 9.7 ? 10 19.4 ? 20

Aides 2.4 ? 2 2.4 ? 2 4.8 ? 4
24.2?24
To establish staff positions, it is important to calculate the relationship between shifts per day and FTEs. This is the point where replacement is accounted for as well assuring that the unit is
covered 24/7—the number of staff who are needed to the number of FTEs to be employed.
Staff to FTE
4. Convert Staff Positions to FTE Positions
a. Calculate FTEs by type and shift:
Divide total FTEs required by the 24.2 daily staff shifts
59.95 / 24.2 = 2.48
Each person-shift calls for employing 2.47 FTEs. An adequate number of FTEs are needed to provide coverage for the other 3–4 days out of the week, vacation, sick time, and education time.
Multiply 2.47 by the staff type needed per shift.
RNs days = 2.48 X 10 = 24.8

RNs nights = 2.48 X 10 = 24.8 (50 RNs)

Aides days = 2.48 X 2 = 4.96

Aides nights = 2.48 X 2 = 4.96 (10 aides)
59.5 FTEs = 60FTEs
Variances
Variance analysis is the difference between the actual results and the planned results, or the amount by which the results vary from the budget. Variances are calculated for three reasons. One is
to aid in preparing the budget for the coming year and future planning. The second reason is to aid in controlling results throughout the current year. By understanding why variances are occurring,
actions can be taken to eliminate some of the unfavorable variances over the coming months. The third reason is to evaluate the performance of units or departments and their managers.
At the end of a given time period, the organization compares actual results with the budget. Most organizations do this on a monthly basis. The simplest approach is to compare the total costs for
the entire organization with the budgeted costs for the organization. For example, suppose a hospital incurred $5 million in expenses and was budgeted for $4 million in expenses for the year; the
organization spent $1 million more than it had budgeted. The difference between the amount budgeted and the amount actually incurred is the total hospital variance. This variance is referred to as
an unfavorable variance because the organization spent more than was budgeted.
The volume variance is defined as the amount of variance caused simply by the fact that the patient volume has changed. For example, if the budget calls for 25,000 patient days, and there were
actually 30,000 patient days, it would be expected that it would be necessary to spend more to care for the additional 5,000 patients. The additional cost of resources needed to care for the
additional 5,000 patients constitutes the volume variance.
The price variance is the portion of the total variance caused by spending more or less per unit—for some resources—than had been anticipated. For example, if the average wage rate for nurses is
more per hour than was anticipated with the use of agency nurse or overtime, it would give rise to a price variance. Price variance could also be related to supplies. The purchasing department
predicts all prices used for supplies; if there is a variance, this may be related to paying higher prices than anticipated for patient supplies.
The third type of variance is the quantity variance. This portion of the overall variance for a particular line item that results from using more of a resource than was expected for a given work
load. For example, if more supplies were used per patient day than expected, that would give rise to a quantity variance, because the quantity, or number, of supplies used per patient day exceeded
expectations. Basically, this variance focuses on how much resources were used. If more nursing care resources were used per patient than was budgeted, this would translate into greater hours-per-
care per patient.
Flexible Budget Variance
Suppose that during the month of May, the 2nd-floor critical-care unit (CCU) at Wagner Hospital incurs a total variance of $57,840U (unfavorable). The unit manager of the CCU is extremely concerned
and wants to find out what caused the variance. To do so, the manager gathers the following information for the month of May: patient days (actual and forecasted), average pay rate for nurses, and
the budgeted hours-per-patient-day.

BPi = budgeted price—$33.00 per-hour budgeted nursing rate
BQi = budgeted quantity—12.0 hours- per- care per patient
BQo = 240 budgeted patient days
APi = $42.00 per-hour actual nursing rate
AQi = 14.0 actual hours-per-care per patient
AQo = 260 actual patient days
Suppose that the CCU had the following line item in their variance report for the month of May:

Actual Budget Variance
Nursing Labor $152,880 $95,040 $57,840 U
1. The first step for the manager is to calculate the original budget in terms of cost per patient day. In order to calculate cost per patient day, the manager multiplies the budgeted price by
budgeted quantity: $33.00 X 12.0 = $396 per patient day. For the month of May, 240 patient days are expected, and the budget is: $396 X 240 = $95,040.

 

Original Budget
BPi X BQi X BQo
$33 X 12.0 X 240
$95,040
2. The next step for the manager is to find the change in volume of the flexible budget. This is the amount the manager would have expected to spend if the actual number of patient days would have
been known. The only change at this point is from BQo of 240 patient days to the new AQo of 260 actual patient days. The manager calculates the flexible budget as follows.

 

Flexible Budget
BPi X BQi X AQo
$33 X 12.0 X 260
$102,960
Then, the manager compares the original budgeted amount to the flexible budgeted amount to determine the volume variance.

Flexible Budget Original Budget
BPi X BQi X AQo BPi X BQi X BQo
$33 X 12.0 X 260 $33 X 12.0 X 240
$102,960 $95,040
Volume Variance

$7,920 U
The difference between the original budget and the flexible budget is caused by a difference in the number of patient days. The volume variance is 7,920 U. Since patient days are higher than
expected, cost will be higher than expected. However, the manager notes that $49,920 of the variance still remains to be unaccounted for.
3. At this point, the manager compares the flexible budget to the actual budget in order to find the flexible-budget variance. The actual hours-per care, the actual average-price paid-per=nurse,
and the actual number- of-patient-days are used.

Actual Budget Flexible Budget
APi X AQi X AQo BPi X BQi X AQo
$42 X 14.0 X 260 $33 X 12.0 X 260
$152,880 $102,960
Flexible Budget

Variance

$49,920 U
4. The manager is simply breaking down the total variance into parts. Next, the manager combines the volume variance with the flexible-budget variance to determine the total variance.

Actual Budget Flexible Budget Original Budget
APi X AQi X AQo BPi X BQi X AQo BPi X BQi X BQo
$42 X 14.0 X 260 $33 X 12.0 X 260 $33 X 12.0 X 240
$152,880 $102,960 $95,04
Flexible Budget Volume
Variance Variance
$49,920 U $7,920 U
Total Variance

$57,840 U
At this point, the total variance has been broken down into a flexible-budget variance and volume variance. The flexible-budget variance is of greater concern to the nurse manager. The volume
variance is from changes in patient days and is usually outside of the manager’s control.
5. In order to find out what is causing the greatest variance in the flexible budget, the manager separates the budget into two pieces: the price variance (average nursing rate per hour) and the
quantity variance (hours per care). First, the manager determined if any part of the variance in the flexible budget was caused by differences in the quantity—or, nursing-care hours. In other
words, did the added patient days have an effect on the quantity of nursing time per patient? To do this, a new budget category is created, called the subcategory. The subcategory is compared to
the flexible budget—which equals the difference between actual patient-care hours compared to the patient-care hours that were budgeted. The AQo is the actual volume for both categories. The BQi is
the budgeted price-per-hour-of-nursing- time. The only difference between the two categories is the AQi, or the patient-care hours.

Subcategory Flexible Budget
BPi X AQi X AQo BPi X BQi X AQo
$33 X 14.0 X 260 $33 X 12.0 X 260
$120,120 $102,960
Quantity Variance

$17,160
The quantity variance, or hours per care, was related to the patient population being more acuity ill, thus requiring more patient-care hours, and usage of agency personnel who were not as
efficient in caring for patients due to their unfamiliarity with the institution.
Second, the manager determines if some part of the flexible-budget variance was caused by differences in nursing-rate per hour. The Qi, or quantity (patient-care hours), is the actual value for
both. The Qo, or the volume, is the actual value for both. The price is the only difference. Thus, to calculate the price variance, compare the subcategory to the actual budget—this is the
difference between the average hourly rate paid to nurses versus the average hourly rate budgeted.

Actual Budget Subcategory
APi X AQi X AQo BPi X AQi X AQo
$42 X 14.0 X 260 $33 X 14.0 X 260
$152,880 $120,120
Price Variance

$32,760
The price variance of $32,760 results from the fact that, on average, $42 was paid per hour for nursing time instead of the budgeted $33. This was due to an excessive amount of overtime and use of
agency nurses due to a greater workload of patients and a nursing shortage (i.e., several senior nurses retired, several nurses changed units/hospitals/careers due to burn-out, and hospital has a
policy to hire only seasoned critical-care nurses to work in their CCU).
6. Finally, the manager incorporates the price and quantity variance together to note how they compromise the flexible-budget variance:

Actual Budget Subcategory Flexible Budget
APi X AQi X AQo BPi X AQi X AQo BPi X BQi X AQo
$42 X 14.0 X 260 $33 X 14.0 X 260 $33 X 12.0 X 260
$152,880 $120,120 $102,960
Price Variance Quantity Variance
$32,760 $17,160
Flexible Budget

Variance

$49,920
In conclusion, it can be determined that the total variance was caused by only a slight increase in patient volume, yet a higher acuity of patients—causing a greater usage of overtime and agency
nurse utilization resulting in a higher average rate paid to nurses.

Actual Subcategory Flexible Budget Original Budget
APi X AQi X AQo BPi X AQi X AQo BPi X BQi X AQo BPi X BQi X BQo
$42 X 14.0 X 260 $33 X 14.0 X 260 $33 X 12.0 X 260 $33 X 12.0 X 240
$152,880 $120,120 $102,960 $95,040
Price Variance Quantity Variance
$32,760 $17,160
Flexible Budget Variance Volume Variance

$49,920 $7,920
Total Variance

$57,840
FTE Practice
FTE Calculations