Dr. Raymond Hill, Director of Surgery, for Forest Medical Center in Lake Park, Illinois, received some recent statistics concerning data on the surgeries performed in his center during 2019.

public health discussion question

Dr. Raymond Hill, Director of Surgery, for Forest Medical Center in Lake Park, Illinois, received some recent statistics concerning data on the surgeries performed in his center during 2019. He was somewhat surprised to see the high number of what is classified as “late surgeries.” He has asked you, a quality analyst, to examine this data. He requests the following items from you:
Create a scatter plot in Excel of the number of late surgeries versus the overall number of surgeries.
Create a run chart in Excel for the number of late surgeries and a run chart for the overall number of surgeries for 2019.
Create separate control charts in Excel for the number of late surgeries and the overall number of surgeries with a 95% confidence level. Show all calculations that you use to arrive at these control charts.
In a Word document, draw two conclusions regarding these three analyses regarding the late surgeries at Forest Medical Center.
Late Surgeries versus Overall Surgeries
Month
Number of Surgeries
Number of Late Surgeries
January
435
112
February
401
129
March
572
186
April
409
103
May
577
89
June
329
156
July
467
156
August
301
94
September
235
89
October
325
127
November
378
156
December
444
124
Total
4873
1432
PROBLEM TWO
Dr. Amanda Guzik, head of infectious diseases for Forest Medical Center in Lake Park Illinois, asks you to analyze the following influenza data that she has collected over five years from cases that were treated at this medical center.
Use Excel to create a run chart for the data.
Use Excel to create a control chart with a 95% confidence level for this data. Include the mean, the LCL, and the UCL. Show all calculations that you use to arrive at these control charts.
In a Word document, draw two conclusions from these charts regarding the influenza cases that the Forest Medical Center had treated.
Submit Word document(s) and Excel file(s) showing your responses and calculations.
Influenza Data by Quarter
Year
Quarter
# of Cases of Influenza Observed
1
1
3452
1
2
346
1
3
483
1
4
3984
2
1
4120
2
2
376
2
3
429
2
4
3583
3
1
4219
3
2
385
3
3
392
3
4
3614
4
1
3568
4
2
439
4
3
326
4
4
4103
5
1
4209
5
2
396
5
3
411
5
4
4008
Dr. William Jones has been the director of the health center clinic at East-Southern Kentucky Community College (ESKCC) for about six months. Having been a part of a much larger medical center in the past, he has seen the benefits of total quality management (TQM) and feels that it would help improve the operations at the ESKCC clinic. He has made some positive changes to the staffing of the clinic, but now feels that he must tackle making improvements to its operations. Consequently, he has created a TQM team (of which you are a part) and has made certain that they have received the necessary training to start examining the various processes within the health center’s operations.
The ambulatory health service department of the ESKCC health center clinic has received increased complaints from the ESKCC student body and staff concerning the services it offers in its walk-in urgent care clinic. Dr. Jones feels that this center would be an excellent starting point for the TQM team.
THE DATA
The team is presented with the following data regarding student/staff complaints:
Patient Complaint Data
Month Complaint Type 1 Complaint Type 2 Complaint Type 3 Complaint Type 4 Complaint Type 5 Complaint Type 6 Total Visits
September 31 41 17 48 13 115 841
October 21 27 8 41 11 52 971
November 11 48 11 24 28 31 1175
December 71 44 12 17 38 12 1042
January 15 30 12 14 17 41 671
February 21 62 6 12 8 51 1631
March 27 95 16 23 6 4 1512
April 47 34 3 13 15 3 781
May 4 21 2 17 18 2 473
Total 248 402 87 209 154 311 9097
Complaint Type Descriptions
Complaint Type Complaint Description
1 The quality of service received.
2 Waiting time was too long.
3 Follow-up care was not available.
4 Clinic was hard to find in the health center.
5 The medical care/treatment took too long.
6 The medical center could not find the individual’s medical records.
THE PATIENT REVIEW PROCESS
The process for a patient (either a student or a staff member) coming in because of a problem is as follows:
When a patient arrives at the clinic, the patient first sees the receptionist, who checks to see if the patient was seen before. If so, the receptionist pulls the medical record from the file. If the patient is new, the receptionist has the patient complete the necessary forms and creates a medical record.
Patients are seen by the physician in the order they arrive. If one of the two examination rooms is empty, the nurse escorts the patient to the examination room and records the patient’s medical complaint. If no examination rooms are available, the nurse escorts the patient to a waiting area until an examination room is available.
When the patient is in the examination room, the nurse performs routine tests. The nurse then writes the complaint and findings on a medical examination form, a form that will be subsequently filed with the patient’s medical record.
The physician examines the patient and orders medical tests, if necessary. A diagnosis and treatment plan is presented to the patient by the physician; a written copy of this plan and any other appropriate instructions are written on the medical examination form.
When the physician releases the patient, the patient returns to the receptionist, who prepares a bill. If the patient has health insurance, the bill is sent to the health insurance carrier.
The patient leaves after either paying the bill (by cash, check, or credit card) or signing the forms to authorize payment by his or her health insurance company. If the health insurance company refuses to pay or partially pays the bill, the receptionist bills the patient by mail. Any patient with an unpaid bill or bad credit history is refused subsequent treatment until the old bill is paid.
INSTRUCTIONS
As a member of the ESKCC TQM team, you are asked to put together a report that recommends improvements to the overall patient process. Create a 4?6 page report in a Word document (copy and paste any charts created in Excel) addressing the following tasks:
Construct a Pareto Chart for the data regarding complaints to the health center that is presented in Table 1. Describe two conclusions from examining this data.
Develop a control chart for the waiting time complaint (complaint #2). Explain how the control chart is developed and show the calculation process.
Illustrate the causes for Complaint #2 in a fishbone diagram. (Note: refer to the readings for examples.)
Develop a flow chart for the process that the clinic uses for a patient who comes into the ambulatory center. Draw two conclusions from examining the flow chart regarding either or both of the following:
How the process affects the patient.
Potential sources of unnecessary complexity.
Determine three improvements to streamline the patient process based on the insights that you gain from examining the process flow chart as well as your understanding of total quality management concepts from your course readings.
Requirements: long enough to provide a vallid response

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.