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

Please help me complete in excel Assignment Exercise 10-2: FTEs to Fill

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!