The Chief of Staff is reviewing data on the length of hospital stays and finds readmission rates within 30 days have jumped over the last quarter. Knowing Medicare and insurance payments are delayed in situations like this, the Chief realizes that not only is patient care a concern but there are financial impacts as well. After conferring with his staff, the Chief asks the Quality Office to look into why readmissions have jumped. Knowing this is high priority, the Quality Office jumps on the request and starts evaluating the data, only to find that there may an issue with the cleanliness of patient rooms. They go to the head of custodial services, and he tells them a contract was awarded a few months back for a new custodial service. He proudly says, “we saved a ton of money over the old contractor”.Are you starting to “put two and two together”? An operational process such as custodial services is extremely important in maintaining a sanitary environment in a hospital, so what does the operational manager do in this scenario? In the assignments below, students get the opportunity to explore quality issues in health care organizations, conduct analysis of data to determine if quality is being compromised, and then formulate recommendations to improve quality in a process. In addition, you’ll learn how to use statistical process control (SPC) to monitor process improvement following the implementation of a planned intervention.Problems to be completed from Kros and Brown (2013):Chapter 9 – Q6, Q9 (pp. 316-317)Chapter 10 – Q4, Q5, Q6, and Q7 (pp. 344-347)Mini-case Study: Delayed Room Cleaning Dilemma (pp.320-321). There are five categories of causes of room cleaning delays: patient check-out orders delayed, cleaning staff shortage, room occupied, order for patient check-out canceled, or other. Using a scatter plot and Pareto diagram, help Leigh develop a way to explain her idea to her co-workers. Include dialogue Leigh could use to help clarify her point.DirectionsThe students are expected to carefully read the assignment instructions, then thoroughly and explicitly address each question.Microsoft Excel will be used to perform the mathematical computations and graphs; however, the questions and their corresponding responses should be written up in a Microsoft Word document. IMPORTANT: Make certain that there is a detailed description of how the calculations were performed.While there is no minimum number of references that need to be utilized to support the completion of this assignment, it is generally understood that outside sources, including the text, will be necessary to complete the problems.The document must adhere to the APA writing style in terms of using in-text citations and the listing of sources on the references page.The Microsoft Word document and Excel spreadsheet are to be uploaded to Submit Assignment.

based on what you wrote in the week 2 research work, complete the uploaded assignment. the first file I am uploading is the work you did for me last week and the second one is the assignment you need to do