Page 25 - 10641MHSBRO COPR Report December 2017 FINAL

Operational Excellence Scorecard

Lima - December 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%
Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17

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
Dr. Kevin Casey 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
Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17

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
6,000 0.86 30%
25%
5,500 0.84
20%
5,000
0.82
15%
4,500
0.8 10%
Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17
4,000
Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov17

25