Performance Benchmarking Dashboards
Topic: Performance Benchmarking Dashboard Example: Medical Practice Costs Dashboard.
Executive Dashboards display metrics from across an enterprise. We, as business managers and information technology professionals, work hard at compiling, cleaning and delivering the correct data from sources distribution across corporate systems and data stores. Of course, you say, “That’s what we’re trying to accomplish with our enterprise dashboard projects. What are you getting at?”
My point is that usually the point of view of our corporate dashboards is inward. We compare metrics with past periods or targets, but we usually don’t bring into our dashboard targets much in the way of industry metrics.
So, let’s look at performance benchmarking and dashboarding. I came across some interesting management dashboard applications from the MGMA (Medical Group Management Association). Their dashboards specialize in allowing medical practice management users to benchmark the metrics of their facility against industry standards.
I thought this worth highlighting for Dashboard Spy readers, because it’s not often that our dashboard metrics incorporate comparisions against standards external to the enterprise.
The dashboards are simple to use and understand. They are powered by Xcelsius as you can see in this video.
If you can’t play the video of the dashboard example, click on the more link below to bring up the rest of this Dashboards By Example post. I’ll provide screenshots of the dashboards and links to the xcelsius dashboard examples.
Here is the video of the Medical Practice Costs Benchmarking Dashboard (yes, it’s fuzzy, but click on the image and it’ll be sharp when the video runs):
Try out the Medical Practice Costs Dashboard for yourself at the MGMA site.


Accounts Receivable
Amounts owed to the practice by patients, third-party payers, employer groups and unions for feefor-service activities before adjustments for anticipated payment reductions, allowances for adjustments or bad debts. Amounts assigned to “Accounts receivable” are due to “Gross fee-forservice charges.” Assigning a charge into “Accounts receivable” initiates at the time a practice submits an invoice to the payer or patient for payment. For example, if an obstetrics practice establishes an open account for accumulation of charges when a patient is accepted into a prenatal program and the account will not be invoiced until after delivery, then “Accounts receivable” will not reflect these charges until the creation of an invoice. Deletion of charges from “Accounts receivable” is done when the practice receives payment, turns over debt to a collection agency or writes off the account as bad debt. “Accounts payable to patients and payers” are subtracted from “Accounts receivable” before reporting “Accounts receivable.” This is the net amount owed after patient refunds.
Do not include:
1. Capitation payments owed to the practice by HMOs.
Total medical revenue
Add “Total net fee-for-service collections/revenue,” “Net capitation revenue,” and “Net other medical revenue.”
Support staff cost
1. Salaries, bonuses, incentive payments, honoraria and profit distributions;
2. Voluntary employee salary deductions used as contributions to 401(k), 403(b), or Section 125 plans;
3. Compensation for all support staff employed by all of the legal entities working in support of the medical practice represented on this questionnaire;
4. Temporary staff working for temporary agencies;
5. The allocated support staff cost where the practice consists of multiple legal entities. For example, an MSO managing two medical practices and employing one billing clerk who devotes an equal amount of time to each practice would add 50 percent of the one billing clerk’s compensation to the total cost of “Patient accounting”, Cost column, for each managed practice; and
6. Compensation for both full-time and part-time employed support staff.
Do not include:
1. Nonphysician provider cost;
2. Expense reimbursements.
General operating cost
1. Information technology;
2. Drug supply;
3. Medical and surgical supply;
4. Building and occupancy;
5. Furniture and equipment;
6. Administrative supplies and services;
7. Professional liability insurance premiums;
8. Other insurance premiums;
9. Outside professional fees;
10. Promotion and marketing;
11. Clinical laboratory;
12. Radiology and imaging;
13. Other ancillary services;
14. Billing and collections purchased services;
15. Management fees paid to an MSO or PPMC;
16. Miscellaneous operating cost; and
17. Cost allocated to medical practice from parent organization
Do not include:
1. “Cost of sales and/or cost of other medical activities”;
2. Support staff cost;
3. Nonphysician provider cost;
4. “Purchased services for capitation patients”; and
5. “Nonmedical cost.”
Total operating cost
Add “Total support staff cost” and “Total general operating cost.”
Total medical revenue after operating cost
Subtract “Total operating cost” from “Total medical revenue.”
For a related dashboard by the same developer see this post:
Healthcare Xcelsius Dashboard used to Track Physician Compensation
Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.
What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- ITSM Dashboard Screenshots for SAP service level KPIs - Applying technical analysis to IT service level management? ...
- Reasons for Adoption of Dashboards, Scorecards & Performance Alerts ...
- Support Process Dashboards - How the MIT helpdesk tracks client satisfaction through the First Contact support dashboard ...
- Performance Maps - size matters in showing KPIs with heat map enterprise dashboards ...
- Citywide Performance Reporting Dashboard for NYC ...
- Hospital Performance Measures and Improvement Process Metrics ...
- Restaurant Performance Dashboard ...
- 3 Steps for Performance Improvement ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Hospital Financial Management Dashboard
- Restaurant Performance Dashboard
- Business Intelligence Architectural Stack
- 3 Steps for Performance Improvement
- More on the Pie Chart
- Dell IdeaStorm Dashboard
- Excel Tool Tips
- Rube Goldberg Dashboard
- Dashboard Spy White Paper Collection Launches
- Excel Visualization of Olympic Medal Count


