Page 13 - 10641MHSBRO COPR Report December 2017 FINAL

Operational Excellence Scorecard

Cincinnati - 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
Shane Hardy Dr. Erin Fries Eric Smith Dr. Erin Fries Courtney Seitz
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. Scott Nix Diane Kuhlmann Pat Davis-Hagens Nancy Scheffel Dr. Erin Fries Laura Thomas
1.08 MTD $400K Acute, Actual $1K Adm Group
Rolling 12 Avg Acute, Budget Gen Surg
1.06 Target MHP, Actual $0K Heart Failure
Septicemia
MHP, Budget
$300K TJR
Vasc Surg
1.04
-$1K
1.02 $200K
-$2K
1
$100K
0.98 -$3K
0.96 $0K -$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
Courtney Seitz Dr. Chip Roper Mike Hurlburt Dr. Steve Feagins Ken James
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

13