On Demand Webinar | Basic | Operations Management
Does your health system prepare food for patients, or operate its cafeteria? Does your health system launder its own linens? Does your health system handle all of its IT infrastructure and security?<br><br>No. Why? Because other organizatio...
On Demand Webinar | Intermediate | Operations Management
Many healthcare organizations struggle to navigate a rapidly changing accounts payables landscape to improve their cash and working capital positions as interest rates fluctuate and competition intensifies. The lack of modern AP strategy ca...
On Demand Webinar | Update | Operations Management
Findings from a nationwide study of factors influencing total cost of care indicate that components of market structure may have significant value in explaining variations in baseline costs across healthcare markets. The findings also sugge...
On Demand Webinar | Overview | Operations Management
Many healthcare organizations suffer with reporting challenges that result in wasted time, duplication of effort, or inaccurate data. Labor-intensive rekeying and copying of data into spreadsheets is often the culprit, but these processes c...
Article | Operations Management

Medication dashboard’s basic structure can be replicated, customized

Article | Operations Management

Medication dashboard’s basic structure can be replicated, customized

The dashboard developed by Penn-Presbyterian Medical Center (PPMC) in Philadelphia draws on a range of data sources unique to the health system’s IT structure and environment. However, the basic structure of the dashboard can be replicated and customized to fit any other organization’s needs, capabilities and data sources. Here is a link to an Excel template that can provide a basis for developing such a dashboard:

Excel template

The idea of building an anesthesia dashboard came about when the Medication Value Committee at PPMC became aware of the sheer number of purchases to be investigated and data to be sifted through. When initiating their data review, the PPMC Medication Value Committee focused primarily on the medical center’s purchasing patterns as a good proxy for utilization.

The goal was to keep it simple, using Excel to group and trend the extracts from PPMC’s purchasing system and publish the monthly results in the dashboard, which would be the focus of the committee’s review.

Although the committee initially relied on the National Data Code associated with the drugs for review, committee members quickly realized that a higher level of grouping was needed. The AHFS [American Hospital Formulary Service] Pharmacologic-Therapeutic Classification allowed purchases to be categorized in a more meaningful way.

The committee met to review how the data was grouped to make sense of purchase patterns, bulk purchases, shortage purchases and substitutions used.

A key component of the dashboard was marking the time frames associated with intervention periods and trending the impact. As the committee began asking more questions of the data, they developed tables and formulas for further refining the views. The dashboard remains a continuous work in process.


Related Articles | Operations Management

Case Study | Financial Sustainability

Optimal use of APPs can enhance a health system’s post-COVID-19 financial recovery

A strategy by Excela Health in Pennsylvania focused on integrating and optimizing its the advanced practice provider workforce can serve as a road map for how best to pursue such an undertaking.

Case Study | Care Management

How Orlando Health improved its bottom line by optimizing observation services

Orlando Health in central Florida offers a case example of how to effectively manage patients in observation status to reduce average length of stay for these patients, thereby, freeing up capacity for care of patients with higher-acuity conditions.

How To | Financial Sustainability

Financial Sustainability Report: June 2020

The June issue of the Financial Sustainability Report provides a broad range of new guidance for healthcare finance leaders on how to adapt and thrive in healthcare’s emerging new world in the aftermath of COVID-19.

How To | Financial Sustainability

3 objectives for an innovative and practical revenue cycle work-from-home program

To develop a sustainable remote-work policy for revenue cycle staff, healthcareganizations must address concerns about staff morale, team cohesion and protection of cash flow.