buisness and finance

Complete Exercises 7.2 and 7.6 on pages 183 and 185 in Quantitative Methods in Health Care Management. Use the Excel document below to record your answers. Save the template to your desktop before using.
• Excel template for Exercises 7.2 and 7.6
7.2: Utilize the information from exercise 6.2 (Nancy the excel I gave you to use. activity, performance rating and observance (in minutes), where pre-and post-examination processing of patients in an outpatient clinic involves various tasks performed by clerks and nurses.
A, Excluding the wait times by patients, recalculate the standard time
B, if there were average of 1,800 patients visits to the outpatient clinic, what would be the standard hours per month?
C, If the target utilization rate of the facility is 80 percent; the indirect support time per visit is 0.10 hour; and the total administrative time by all staff in a given day is five hours, what is the target FTE level for the clinic?
D, If fringe benefits account for 9 percent of the target FTEs, what are the required FTEs?

7.6: Table Ex 7.6
ICU CCU SURG MED PED Ob/GYN
7,000 8,000 8,500 9,000 7,500 6,500

A, Assuming an 85 percent utilization level and that everything else is constant, how many RN FTEs should be hired to satisfy the patient care demand in each unit?

B, The FTEs hired for SURG,MED,PED, and OB/GYN are scheduled for eight-hour shifts on a 5/40 plan, and they will get ten holidays, six sick days, and fifteen paid vacation days per year. How does this information affect your FTEs?

C, The FTEs hired for ICU and CCU are to be scheduled for ten-hour shifts on a 4/40 plan, and ICU and CCU nurses get the same benefits as do other unit nurses. How does this information affect your FTEs?

• Excel template for Exercises 7.2 and 7.6