Please help me with questions 7.2 and 7.6 using the excel attachment. I need it by morning please
Please help me with questions 7.2 and 7.6 using the excel attachment. I need it by morning please
Observation (in minutes)Activity12345679101112Registration1.15364845464644.915.65Co-Payment0.9579118129611912109.458.98vital signs0.969811129810128121110.009.60Placement to exam room0.98354635365474.644.54Examination1181519221812192116211718.0018.00Test order entry1.024735411912111498.098.25Referral requests1.11111016989779769.009.99Follow up1.08353434453353.824.12appointmentschedulingJob OTJob NTa. Excluding the wait times, recalculate the standard times.b. If there were an average of 1,800 patient visits to the outpatient clinic, what would be the standard hours per month?c. If the target utilization rate is 80%; the indirect support time per visit is 0.10 hour; and total admin time is 5 hoursper day, what is target FTE level?d. If fringe benefits account for 9% of the target FTEs, what are the required FTEs? (That is, what are the FTEs required per year, based on 52 weeks, 40 hoursPerformanceRatingObserved TimeNormalTime
EX 7.6Average RN minutes needed on a daily basis in various unitsUtilization:0.85ICUCCUCURGMEDPEDOB/GYN700080008500900075006500a) RN FTEs(Assume the RN works 8 hours/day, and 1 hour=60 minutes.)b)Calculation of “Coverage Factor” for 5/40 plan (That is, calculate the coverage factor, and then use this factor to determine how this will affect FTEs.)c)Calculation of “Coverage Factor” for 10/40 plan(That is, calculate the coverage factor, and then use this factor to determine how this will affect FTEs.)
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
