UTC Time Physicians Spend with Patients Delivering Care Questions

Activity: Your case study indicates that the medical assistants have expressed concern about their workload variations depending on the average patient scheduled visit (i.e., patient every 15, 20, 30 minutes). Using the Excel dataset, determine the validity of the medical assistants’ concerns. This requirement means you must arrive at a conclusion concerning the concerns and support your decision with evidence from the data. Prepare a workload assessment document in Microsoft Word to fulfill these requirements. This question requires you to analyze the provided dataset, identify workloads, and identify process bottlenecks. Using the case narrative, analyze the data based on the different patient scheduling strategies of 15-minute, 20-minute, and 30-minute intervals. Well constructed answers will also examine the data to determine whether wait times are impacted by specific physicians and/or medical assistants. The analysis required to determine if the MA perspective concerning patient-room turnaround time is a factor to consider includes calculating the following: • • • • Average patient wait times by component and in aggregate (in minutes) for the patient visit process based on patient schedule times (i.e., 15-minute, 20-minute, or 30-minute increments) Average patient wait times by component and in aggregate (in minutes) by physician/MA per each patient schedule time (i.e., 15-minute, 20-minute, or 30-minute increments) Average patient care times by component and in aggregate (in minutes) for the patient visit process based on patient schedule times (i.e., 15-minute, 20-minute, or 30-minute increments) Average patient care times by component and in aggregate (in minutes) by physician/MA per each patient schedule time (i.e., 15-minute, 20-minute, or 30-minute increments) You should use the Excel data and apply a subtotal or pivot table analysis to analyze the data. Discuss the impact of the different scheduling increments on the various value-added and non-valueadded activities that result in patient wait times and patient perception of quality care. Case Narrative: Medical Assistants have been quite vocal in the last year concerning challenges in keeping up with the workload. They have expressed concern that even with new staff, there are times when they cannot keep up with the work required for each patient. The MAs have indicated specific times when workloads are less likely to be completed in the allotted time. The most common criteria have been when patients are scheduled 15 minutes apart. The MAs indicate that there is not enough time between patients to transition from one patient to another without causing schedule delays. The transition requires cleaning the leaving patient room, getting the entering patient room ready, pulling up the entering patient data, and retrieving the entering patient from the lobby. Dr. Millwood is sensitive to the MA concerns because it has been challenging to recruit and retain employees to fill these positions. There is a great deal of competition for MAs in the local market. According to the US Bureau of Labor Statistics, the average pay for an MA is $17.23 per hour, placing the job in direct competition with many other equally paying but less intensive jobs that do not require certification. Bayside has difficulty outcompeting larger 1 physician practices on pay and benefits, so MA job satisfaction is also critical to Dr. Millwood. Dr. Millwood believes that the data he has collected provides insight into possible solutions for the practice. He needs to investigate the following. • What are the average wait times for patients in the clinic across the patient experience (i.e., are there specific process steps where wait times are higher, indicating a bottleneck)? • What is the average time physicians and MAs spend with patients delivering care? • Do average patient wait times differ by physician or MA? • Does evidence exist to support the MA’s contention that scheduling patients 15 minutes apart contributes to longer patient wait times? Submit one(1) Microsoft Word document to the proper dropbox for this activity. You should not submit any Excel or any other format files. You may use a tool such as Excel to perform your analysis, but all of your content should be in your Word document. Embed any supporting evidence from your analysis into your Microsoft Word compatible summary document. 2 Provider, Appointment, Visit Provider Baker, Anthony Baker, Anthony Baker, Anthony Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Castillo, Miles Kumar, Reena Kumar, Reena Kumar, Reena Kumar, Reena Kumar, Reena Kumar, Reena Kumar, Reena Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Robinson, Amelia Stewart, Benjamin Appt Date Scheduled & Time Visit Length 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 15 2/12/2021 15 2/12/2021 15 2/12/2021 15 2/12/2021 15 2/12/2021 15 2/12/2021 15 2/12/2021 15 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 30 2/12/2021 15 Patient Vis Check-In Wait from Check-In Duration To Room 0.45 15.55 0.45 6.35 0.15 24.40 0.18 0.32 2.48 0.37 0.77 0.92 0.87 0.22 0.35 3.13 2.22 14.23 2.82 18.83 0.70 8.33 1.40 27.63 0.85 0.70 1.12 0.68 0.53 2.18 0.43 8.98 2.80 11.00 0.72 3.33 2.35 1.00 2.33 26.85 0.72 0.62 1.98 0.70 4.38 0.10 1.72 1.08 8.25 18.18 1.33 6.08 0.17 4.93 1.60 1.28 2.05 25.15 0.20 5.58 0.37 5.78 0.72 4.13 0.63 38.60 0.28 28.92 0.18 54.53 0.35 17.82 0.60 33.43 0.40 0.75 0.40 26.18 0.22 5.88 0.20 20.70 3.57 60.62 Stewart, Benjamin Stewart, Benjamin Stewart, Benjamin 2/12/2021 2/12/2021 2/12/2021 15 20 30 4.18 0.53 2.27 24.10 3.42 4.17 Patient Visit Components in Minutes MA Patient Care Wait from MA to Physician Patient Duration Physician Care Duration 25.52 5.98 11.33 21.88 26.60 17.13 29.20 43.27 15.03 15.32 32.03 12.17 32.60 4.82 2.65 11.27 1.00 2.77 14.78 35.57 16.72 16.30 21.00 17.82 16.68 36.13 13.38 27.63 26.67 9.02 20.05 45.70 22.53 18.85 17.70 22.12 30.42 3.58 5.58 6.70 26.67 2.98 7.23 25.78 29.65 28.68 39.12 14.77 3.00 14.50 23.72 20.48 28.37 21.18 20.13 14.83 20.73 7.08 12.78 6.25 4.88 13.90 31.57 19.13 8.17 19.95 19.43 14.45 23.13 19.70 11.48 20.08 5.85 8.23 3.65 12.02 10.25 19.38 20.70 9.92 18.75 19.37 4.22 2.03 6.58 1.55 12.22 1.98 12.67 13.17 2.77 0.73 8.07 16.17 18.63 7.18 7.37 0.67 0.70 16.85 11.40 3.40 16.32 18.68 3.02 3.07 27.23 6.23 31.65 12.05 10.92 10.88 0.50 0.08 35.37 12.15 8.45 29.78 2.22 11.43 27.63 19.82 7.27 -8.63 6.02 11.90 Wait Until Check-Out 13.02 17.85 11.65 5.72 13.48 7.32 17.20 6.95 4.83 12.00 16.47 18.75 7.57 18.85 16.25 3.53 12.35 8.45 13.67 24.27 5.50 8.63 2.27 11.93 16.78 17.00 0.00 0.00 19.68 31.15 14.70 22.78 16.92 12.90 11.65 25.08 17.72 13.93 17.40 8.88 8.90 12.27 Follow-Up & Check-Out Duration 7.63 10.72 8.28 12.25 5.70 8.68 4.92 8.12 9.08 5.43 15.33 6.63 12.35 2.35 0.32 5.47 10.98 4.27 5.22 7.50 5.63 11.42 6.03 5.10 6.00 5.88 13.73 10.12 5.33 9.60 2.28 5.35 4.08 10.75 5.38 10.77 10.72 2.23 0.43 7.52 11.38 4.20 6.82 17.67 16.57 9.40 4.15 16.33 10.62 12.02 5.12 23.02 13.33 18.73 9.83 3.50 9.70 Patient Visit Components in Minutes MA Physician Follow-Up Wait from Patient Wait from Patient & CheckAppt Date Check-In Check-In Care MA to Care Wait Until Out & Time Duration To Room Duration Physician Duration Check-Out Duration 2/1/2021 2.53 1.85 11.50 2.00 17.62 29.47 11.05 2/1/2021 0.52 1.28 3.33 32.90 7.57 19.00 9.33 2/1/2021 0.98 11.45 23.07 17.68 6.68 8.33 2.70 2/1/2021 2.62 1.88 28.82 21.58 7.87 1.97 9.73 2/1/2021 1.48 0.53 18.82 29.32 21.52 6.87 11.37 2/1/2021 2.42 3.55 1.97 32.58 21.20 0.00 3.85 2/2/2021 0.38 11.72 26.43 12.85 22.07 11.68 10.83 2/2/2021 0.43 39.68 5.98 17.93 4.22 12.87 14.78 2/2/2021 2.80 10.45 5.28 32.15 14.70 24.98 14.83 2/2/2021 0.32 0.82 1.37 4.45 14.07 21.05 6.48 2/2/2021 1.08 25.75 7.97 30.13 7.43 20.78 11.17 2/2/2021 2.15 8.10 6.88 43.27 11.18 4.95 2.15 2/3/2021 0.33 8.27 10.35 37.00 9.42 13.12 12.53 2/3/2021 1.08 9.13 1.13 5.00 5.18 10.97 9.92 2/3/2021 1.33 2.40 9.57 20.15 31.32 3.38 9.57 2/3/2021 2.85 2.60 15.72 10.57 30.63 4.43 12.38 2/3/2021 0.52 32.65 19.28 15.57 12.47 16.13 4.98 2/3/2021 5.20 0.35 11.23 5.37 9.52 0.00 7.20 2/4/2021 0.40 0.43 17.00 29.95 13.22 31.27 7.25 2/4/2021 0.48 2.35 16.25 16.67 9.72 10.78 5.28 2/4/2021 1.20 2.70 5.80 15.03 24.88 5.58 3.95 2/4/2021 1.93 2.67 4.73 8.55 16.50 10.55 8.52 2/4/2021 5.75 0.93 8.75 0.32 16.20 9.28 1.08 2/4/2021 2.48 5.62 12.95 4.73 13.47 9.92 3.75 2/5/2021 1.05 6.18 24.05 36.88 15.38 6.48 6.35 2/5/2021 0.38 3.50 20.13 43.78 25.50 14.47 11.00 2/5/2021 0.47 11.73 32.60 24.52 9.23 3.95 4.00 2/5/2021 3.32 4.75 20.03 8.58 8.47 19.80 7.50 2/5/2021 0.17 11.18 23.45 7.87 21.90 2.45 12.08 2/5/2021 0.75 31.47 21.60 13.62 2.95 18.02 12.75 2/8/2021 0.42 0.28 9.45 33.87 22.08 18.62 5.80 2/8/2021 0.42 1.55 11.70 5.15 6.20 7.33 12.83 2/8/2021 0.50 1.62 19.98 22.00 16.48 6.95 5.68 2/8/2021 1.60 0.30 18.73 19.40 27.15 9.53 6.10 2/8/2021 6.33 20.38 29.27 14.60 31.57 12.20 13.18 2/8/2021 1.03 2.50 7.48 0.48 2.77 18.77 13.78 2/9/2021 1.70 9.83 17.00 39.00 22.10 7.10 9.12 2/9/2021 0.48 3.00 10.27 8.30 8.60 4.32 12.07 2/9/2021 0.77 33.57 26.65 37.03 30.52 14.75 4.63 2/9/2021 0.68 15.88 9.85 38.63 23.70 10.02 15.00 2/9/2021 2/9/2021 2/10/2021 2/10/2021 2/10/2021 2/10/2021 2/10/2021 2/10/2021 2/11/2021 2/11/2021 2/11/2021 2/11/2021 2/11/2021 2/11/2021 2/12/2021 2/12/2021 2/12/2021 2/12/2021 2/12/2021 2/12/2021 1.35 0.78 1.83 0.27 0.62 0.48 0.70 0.77 0.38 0.75 0.33 5.05 2.60 1.55 0.45 0.35 0.85 1.72 0.40 2.27 11.75 7.60 9.92 9.17 17.57 2.35 1.77 1.40 25.53 1.78 8.28 3.13 5.30 1.97 6.35 3.13 0.70 1.08 26.18 4.17 23.38 14.87 36.88 31.13 9.32 35.80 7.18 14.37 18.77 9.57 10.82 20.15 9.00 16.00 21.88 16.30 30.42 19.70 35.37 16.57 6.08 21.32 13.12 20.78 10.83 8.32 0.92 10.83 22.63 25.65 12.65 17.73 12.80 16.78 26.60 21.00 3.58 11.48 12.15 16.33 6.87 28.62 8.40 8.65 18.20 25.05 29.10 31.73 30.32 16.30 7.47 5.25 14.10 10.42 17.13 17.82 5.58 20.08 8.45 5.12 13.83 7.80 2.50 11.05 14.00 19.75 14.22 8.47 6.23 18.22 6.55 14.73 3.75 9.58 17.85 6.95 7.57 11.93 17.40 18.73 14.42 11.05 13.20 12.85 5.63 11.08 10.42 10.15 10.42 12.18 8.68 12.10 8.80 12.63 10.72 8.12 12.35 5.10 0.43 9.70

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.