Question: Please help me complete in excel Assignment Exercise 10-2: FTEs to Fill a Position Metropolis Health System (MHS) uses a basic work week of 40
Please help me complete in excel

Assignment Exercise 10-2: FTEs to Fill a Position Metropolis Health System (MHS) uses a basic work week of 40 hours throughout the system. Thus, one full-time employee works 40 hours per week. MHS also uses a standard 24-hour scheduling system of three 8-hour shifts. The Director of Nursing needs to compute the staffing requirements to fill the Operating Room (OR) positions. Since MHS is a trauma center, the OR is staffed 24 hours a day, 7 days a week. At present, staffing is identical for all 7 days of the week, although the Director of Nursing is questioning the efficiency of this method. The Operating Room department is staffed with two nursing supervisors on the day shift and one nursing supervisor apiece on the evening and night shifts. There are two technicians on the day shift, two technicians on the evening shift, and one technician on the night shift. There are three RNs on the day shift, two RNs on the evening shift, and one RN plus one LPN on the night shift. In addition, there is one aide plus one clerical worker on the day shift only. Required 1. Set up a staffing requirements worksheet, using the format in Exhibit 10-4. 2. Compute the number of FTEs required to fill the Operating Room staffing positions
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
