easy work: need to fill in attached excel chart with info. provided...- need work done by 6pm 1/31/14

Project Description:

name of textbook:
health care finance: basic tools for nonfinancial managers, 3e - open resource.
judith j. baker & r.w. baker

task exercise 9–2:
ftes to fill a position metropolis health system (mhs) uses a basic work week of 40 hours throughout the sys- tem. 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 positions. since mhs is a trauma cen- ter the or is staffed 24 hours a day, 7 days a week. at present, staffing is identical for all seven 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 techni- cians 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.

work that needs to be filled in on attached excel sheet:
required 1. set up a staffing requirements worksheet, using the format in exhibit 9-4. 2. compute the number of ftes required to fill the operating room staffing positions.
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 10
1 Current viewersl
179 Total views
Project posted by:


Proposals Reputation Price offered