Executive KPI anaysis and summary to CEO of Hospital

Executive KPI analysis and summary to CEO of Hospital
Summary
The report summarises the overall performance and shows the key areas the company has improved and failed. The month of December shows that the surgical day care trips have improved compared to previous months. On the contrary, bad debts increased to $381,201.12 compared to the preceding month which was 0 which means that a lot has to be done to improve the situation. The number of accounts receivable increased from $8,976,476.48 to $9,170,728.33 which shows improvement. Therefore, the company’s performance, as well as, the realisation of objectives can be achieved if the hospital addresses these bad debts. The article explains the different indicators of presentation which include volume, charges, collection, accounts receivable and unbilled accounts.
Charges and volume
The total costs accumulated in KPI for the company for December amount to $12,226,915.37. On the other hand, the overall expenses billed, Meditech, is $13,332,331.87. Aggregate fees billed that is SSI is 9,376,423.69 dollars. The volume of charges entered was $12,226,915.37. The month had 32 days of IP patient visits but twenty IP visits. The total number of patients who visited the facility requiring surgical day care totaled to 222 people. There was only one observation visit in December and 25 PAT visits. The month had 10 ER visits, and all these visits added up to 278 trips.
Collection
The month of December received the most significant percentage of IP collection rate which was 40 percent of all the months calculated.

The collection had a value of 2,128,735.95 dollars. The proportion of gloss collection for the month equaled to 15 %. Additionally, the percentage of gross accumulation for all outpatients added up to 26.19% while that of ER services was 21.96%. Total SDC services totaled to 7.40%, and SDC services had a total of 7.25%. The sum of all these services collectively added up to 11.47%.
Accounts receivable
For the accounts receivable the total number received from patients was $4,414,713.56 while the total equaled to $9,170,728.33. The total amount from Medicaid was $205,723.27, $1,496,036.52 from Attorney / WC, $4,414,713.56 from self-pay, $519,680.57 from OON insurance, $967,766.65 from BCBS, $1,331,024.01 from IN insurance and $235,783.75 from MCR.
Unbilled
The number of unbilled patients equals to 37, and the value equals to $1,881,579.80. There were five unbilled days for the month.
How the company brings value to partners.
The company has initiated a patient aging 120+ project which has changed the bad debt placement criteria. It involves reviewing of patients balances over 120 aged days by facility requests that resulted in the assignment of 173 accounts for $381,201.12 to a bad debt third party CCB. This working project is led by the ERCM team that reviewed all DOS between 2015-2016. Additionally, there have been decreases in AR insurance and AR 90+ since 2017 from $14.9M in January to $2.9M in December, and they continue to increase. ERCM have continuously improved the reports, working closely with CSH to improve and prevent denials. Also, ERCM started using credit cards payments directly from patients through Number lines’ online vendor. Moreover, continuous work is being done with Abacus software to update rates as they change and develop new pieces in the software. Not only that, but they are also working with CSH to help authorization errors that occur. At the same time, ERCM has developed an update software for scheduling documents, receives all patient inquiries and calls, and handles most of the tasks manually.
Conclusion
Cumberland surgical hospital has excellent performance, and they managed to receive $1,402,867.50 during December. The hospital also has two hundred and seventy-eight visits for only one month which also shows its significant performance. The clinic records most of the information acquired from patients apart from just a few patients. The billed data assists the company to keep records of all patients visiting the hospital and ask for claims from insurance companies. The total accounts receivable by the clinic is $9,170,728.33 which indicates the worth of the hospital. However, severe debts and refunds amount to $381,201.12 and $6,054.24 respectively. These repayments and bad debts mean a significant loss to the hospital because they will have to compensate for the severe deficits and remove the refunds from the total accounts receivable. The hospital should develop a method of eliminating these returns and bad debts to increase its profitability.