I need help with exercise 1. I need to know how to do this in excel.

Exercise 1: Using the data given in Table 2, determine if the POS performance is stable using a control chart. Explain why you used the type of control chart you selected.

Holistic Health Systems (HHS) operates 39 hospital facilities and clinics. The executive team has been reviewing key metrics over the last year and identified a need to improve Point of Service Collections or simply known as POS (pronounced P-O-S). POS is a patient payment that is received within 7 days after discharge. Increasing POS is important for HHS because hospitals are 60% less likely to receive payment once the patient leaves the hospital. The cost to collect on the patients account continues to go up while the chance of actually collecting payment goes down if there is a delay in collecting the payment after the patients discharge. Therefore, it is better to not delay collecting the payment.

Increasing POS reduces Bad Debts, provides a better cash position, reduces expenses, and increases patient satisfaction when conducted properly.

POS is calculated by dividing POS Payments by Total Patient Cash Collected.HHS has identified the industry median benchmark for POS as 13.6% and the top 10% POS benchmark as 41.4%. HHSs current POS performance is 35.6% and the executive team has determined that a 5 percentage point increase is needed to stay competitive (target = 40.6%). A Lean Six Sigma team was formed

POS is a metric that heavily relies on the Patient Access team or PA. PA is responsible for several taskspatient scheduling, registration, and financial clearance. The Scheduling tasks are typically completed by a centralized PA team for multiple hospital facilities. During Scheduling, PA reps receive a doctors order for a patient. The order is like a permission slip for specific medical services the doctor deems necessary. The doctor or even the patient related to the order can call Scheduling to reserve an appointment for the services that correspond to what is written in the order. PA reps need to verify that the order is complete and accurate, coordinate time for services, and provide patients with pre-service instructions. After patients information is logged into the scheduling system, it will queue up to the PA registration team to complete the registration process. PA will call the patient and confirm the identity, collect demographics such as address, family, emergency contact, etc. PA registration will also confirm the patients health insurance provider(s). PA registration can be completed at a hospital facility or by a centralized team. Lastly, PA Financial Clearance will verify patient health benefits to ensure they exist and to determine if the procedure or service for the patient is covered. If authorization is required, the PA Financial Clearance will request authorization for services from the patients health insurance provider. Services performed without authorization lead to rejected claims. Also during PA Financial Clearance, the PA rep will Counsel the patient about their liability (how much their insurance provider says they need to pay for the services) and collect the payment. Any payment received is considered POS since its before 7 days post discharge. Financial clearance can also be performed at the hospital facilities or by a centralized team.

Summary patient cash data for HHSs 39 hospital facilities for a year is presented in Table 1. The table also indicates if the PA team for each facility is centralized or not.

Table 2 provides an overall monthly trend for POS Performance.

	POS Payments	All Patient Payments
Jan-14	$ 8,198,401	$ 22,105,614
Feb-14	$ 6,409,335	$ 20,449,785
Mar-14	$ 7,452,507	$ 25,357,473
Apr-14	$ 7,853,058	$ 24,320,414
May-14	$ 7,277,931	$ 24,815,250
Jun-14	$ 8,975,992	$ 20,309,240
July-14	$ 7,349,353	$ 24,904,346
Aug-14	$ 6,804,829	$ 23,349,092
Sep-14	$ 7,898,465	$ 20,829,620
Oct-14	$ 7,888,816	$ 18,506,142
Nov-14	$ 5,834,679	$ 17,386,881
Dec-14	$ 9,021,591	$ 18,659,237
Jan-15	$ 8,717,536	$ 18,956,764
Feb-15	$ 6,623,228	$ 19,008,749
Mar-15	$ 7,696,772	$ 22,971,163
Apr-15	$ 8,312,773	$ 23,437,612
May-15	$ 9,028,170	$ 21,358,646
Jun-15	$ 7,436,050	$ 22,168,016
Jul-15	$ 7,852,119	$ 21,971,590
Aug-15	$ 6,933,100	$ 23,650,610
Sep-15	$ 8,623,086	$ 26,860,403
Oct-15	$ 7,850,627	$ 21,346,585
Nov-15	$ 7,691,110	$ 23,004,295
Dec-15	$ 8,602,245	$ 22,939,623