Healthcare
Frequent Inaccuracies in a Multi-Facility Nursing Home Reports
Information was being entered into Excel spreadsheets at several nursing facilities and forwarded to corporate headquarters for strategic decision making reasons. Because of the complexity of filling out the spreadsheet and the frequent turn over of personnel the data was often wrong.
A secondary issue was the need to manually combine the supplied spreadsheets into an enterprise level report.
After reviewing the complex logic necessary in compiling daily information we proposed and developed a secured web site as a solution to simplify and streamline this data collection.
Secure and simplified data entry forms were made available online for each facility. The logic necessary to manipulate the daily information was changed from a manual interpretation of rules to an automated process built into the software.
Elsewhere, facility and enterprise level reports were made available at a moments notice by simply selecting the facility(s) and a date range.
Employees were able to fill out information quickly with little training which resulted in an estimated
21 hour/month savings
Instant, accurate analysis reports at both a facility and enterprise level were made available with an estimated
7 hour/month savings
Return on Investment* |
||
1 Year Savings |
$28,224 |
|
3 Year Savings |
$84,672 |
|
5 Year Savings |
$141,120 |
|
*Yearly Savings = 28 hour/month * 12 month * $84/hour = $28,224 / year |
"John designed and developed an impressive web based application that gave us a centralized location for data entry and scheduling adjustments" |
|||
|
|||
"...this application provided a simple powerful report generator that created complex scheduling matrices at the push of a button" |
|||
|
|||
"The projects he undertook were significant, both in scope and success. The projects impacted virtually every department in the company; Operations, Sales, Engineering, and Human Resources" |
|||
|
|||
"It is clear that John has the knowledge, experience, and expertise to understand problems not just from a technical point of view, but also from a business and manufacturing perspective." |
|||
|
|||
"These applications allowed us to create a multitude of reports and charts at the click of a button for our facility’s own use as well as required reports for our corporate office." |
|||
|
|||
"John is personable, forward thinking and the results he produced were always welcomed by me and my staff." |
|||
|
|||
"...this multi-user application made things noticeably easier and provided fast accurate reports required for quality audits as well as OSHA and State requirements." |
|||
|
|||
"This complete process, from initial discussion to final product, was handled with an obvious understanding of our needs and obvious respect for our time." |
|||
|
|||
©2020 ORDERED CHAOS INC. All Rights Reserved.