Question: Show work in excel plz or how everything is calculated. 2. The head nurse on 2 South at Henry Hospital is assessing his RN staffing

Show work in excel plz or how everything is calculated.
2. The head nurse on 2 South at Henry Hospital is assessing his RN staffing requirements. The unit serves 5,750 patients per year. One RN can oversee four patients per shift. RNs earns $75,000 per year. (a) Calculate the number of productive days and FTEs needed. (An FTE is 230 productive days per year.) (b) Calculate the cost to meet this need using fulltime only, full-time plus overtime for any fractional FTE, and full-time and part-time employees. What staffing method produces the lowest expense, and how much would be saved over the most expensive methodStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
