Page 25 - COPR-Oct 2017

Operational Excellence Scorecard

Lima - October 2017

MHP Mission Support Subsidy per Provider Incremental Operating Margin Efficiency Ambulatory Point of Service Collections
Annualized YTD, lower is better Acute care, higher is better % collected, higher is better
Ronda Lehman Dr. Matt Owens Dale Gisi Tim Rieger Heather Hilliard Jill Jacobs
Actual 100% MTD
Budget 100% Copay
$250K 2017 Target Outstanding
Target 80% Target Copay
80%
$200K Target Outstanding
60%
$150K 60%
40%
$100K 40%
20%
$50K 20%
0%
$0K 0%
Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17

Average Inpatient Length of Stay Agency FTE Use Profit/Loss per Medicare Patient by Condition
Observed/Expected, Lower is better Actual dollars, lower is better Rolling 12 month avg, > 0 indicates profit
Cindy Mefferd Dr. Oluremi Ojo Dale Gisi Will Cason Tim Rieger Dr. Jason Bowersock
1.15 MTD $150K Acute, Actual $1K Adm Group
Rolling 12 Avg Acute, Budget Gen Surg
Target MHP, Actual Heart Failure
MHP, Budget $0K Septicemia
1.1 $100K TJR
Vasc Surg
-$1K
1.05 $50K
-$2K
1 $0K
-$3K

0.95 -$50K -$4K
Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Sep16 Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17

wRVU per Provider FTE Medicare Advantage Medical Loss Ratio Hospital Salaries & Supplies as % of Net Patient Revenue
Annualized YTD, higher is better System composite ratio, lower is better Lower is better
Ronda Lehman Dr. Mark Mueller Ronda Lehman Dr. Ed Tremoulis Dale Gisi Tim Rieger
6,500 Actual 0.88 MTD 35% % Salaries, Actual
Budget Target % Salaries, Budget
Budget % Supplies, Actual
% Supplies, Budget
30%
6,000 0.86
25%
5,500 0.84
20%
5,000
0.82
15%
4,500
0.8 10%

4,000 Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17
Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17

25