Business Intelligence Blog from arcplan
14Feb/121

Business Intelligence at Hospitals: Real-World Examples of Hospital Efficiency & Quality Metrics

by

As both the battalion chief of my local ambulance and rescue squad and a business intelligence consultant, you can imagine that healthcare analytics are near and dear to me. Plus, living in the Philadelphia region, it’s impossible to escape the news of numerous hospital closures every year. So at arcplan, I love working with hospitals and healthcare organizations to build reports and dashboards that track the metrics critical to their survival. All the way back in 2001, Paul Mango and Louis Shapiro of McKinsey & Company argued that hospitals are essentially a commodity business and therefore need to compete on the basis of operational efficiency. This sentiment rings true more than 10 years later, with skyrocketing medical costs, declining insurance reimbursements, and increased utilization by an aging population. Giving hospital executives (and physicians!) access to real-time data has never been more critical to hospital operations.

Hospital executives often report on financial, operational and clinical system metrics which are crucial to ongoing operations and management. The hospitals we’ve worked with often have an overarching goal to provide efficient, quality care to patients, and they need access to their existing data to make sure they are achieving that goal. Important metrics that roll up to the goal of “efficiency” include the average wait time for a hospital bed, physician productivity, nurse turnover rates and the cost per discharge. Metrics that roll up to a “quality” goal include average length of stay, re-admission rates and patient satisfaction. The only way to improve the quality and efficiency of care is to analyze current performance and identify areas for improvement.

One of arcplan’s customers, the largest private operator of healthcare facilities in the world, came to us when they were focusing on efficiency. For more than 5 years, they have used an arcplan-powered business intelligence system (with data from Oracle Essbase and Teradata) to track key metrics and make decisions that improve efficiency of care – specifically in emergency rooms. All of their ERs needed to reduce wait times, shorten lengths of stay, and avoid people leaving the ER without care and treatment. The goal became to have every ER patient seen by a doctor within 45 minutes of arrival.

So what metrics do they track to achieve this goal? Here are a few examples:

Continue reading this post >>

28Jul/110

5 Steps to Better Supplier Quality

by

We work with a number of manufacturing companies around the world that need help staying on top of everything from daily production metrics (like machine utilization and on-time delivery) to complex financial calculations to ensure profitability. But as a business intelligence software provider, one of the most important processes we’ve been tasked with is helping our clients manage supplier quality.

Managing the performance of your suppliers is crucial for controlling costs and improving the quality of your outputs. Experts say that the cost of poor supplier quality may equal more than 10% of an organization’s revenue, so keeping that number under industry standards is simply a smart financial decision. But how do you embark on this journey?

1) Start with a subset of your suppliers.
One company may have potentially hundreds or thousands of suppliers, so determining a subset to begin measuring is imperative. You can roll out your supplier scorecards to every supplier in the future, but for now, let’s get it right with just a few. I suggest ranking your suppliers by how much impact they have on your product. The most critical suppliers that you can’t continue operations without are the ones that you rely on most heavily, so these are a good place to start. In the middle of the list are suppliers who directly impact your product, but you could seek alternatives if the need arises. At the bottom are suppliers that have no direct impact on your product.

2) Set expectations with your suppliers.
Your suppliers may know they have some poor processes that are straining their relationship with you and would relish the chance to improve them. Let your suppliers know that you’re beginning to track metrics that will help establish what needs improvement. This first step – just being honest – goes a long way toward building mutual trust and should force both sides to become invested in the success of the partnership. It is important that both parties communicate and document performance expectations, and have a mutual understanding of those expectations going forward.

3) Determine your metrics for success.
Your management team is probably already measuring a number of things that can be incorporated into your list of metrics. Your finance team is tracking costs; you may have six sigma principles in place to track defective parts per million; and your logistics system probably has metrics related to on-time delivery. I bet you’re even collecting a wealth of data in spreadsheets for monthly reporting. Gather these existing metrics along with any new information you identify as being important – this is the start of your Supplier Scorecards. Here are some sample metrics to consider and how they will help you:

Continue reading this post >>

3Jun/100

The Case for Supply Chain Quality Management: Part 4 – Sample Performance Metrics

by

In our previous post in this series, we talked about the ingredients needed to create a fact-based culture among your internal supply chain teams and your external constituents (suppliers). Today we’re giving you the goods – sample metrics for your Quality Dashboards and Supplier Scorecards.

There are three critical performance drivers in the supply chain – Cost, Quality, and Time – all of which must be objectively managed. Some lend themselves to quantifiable metrics while others are more qualitative. In either case, supplier quality teams need a dashboard and scorecard(s) that makes all required information accessible and easy to consume. Let’s talk a bit more about cost metrics.

Cost:

As much as 60% of the cost of production is purchased material content and 67% of the cost of poor quality is in the non-materials cost. With the proportionately large amount of money being spent on business processes that support production, both the cost of parts and processes must be managed with metrics such as:

Continue reading this post >>