Page 43 - 10641MHSBRO COPR Report December 2017 FINAL

Operational Excellence Scorecard

Toledo - 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
Todd Warner Olivia Dacre Dr. Thomas Welch Mark Thompson Todd Warner Jed Browning
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. Riaz Chaudhary Dave Wellons Barb Martin Mike Whipple Dr. Thomas Welch Jason Theadore
1.08 MTD $300K Acute, Actual $1K Adm Group
Rolling 12 Avg Acute, Budget Gen Surg
1.06 Target $250K MHP, Actual $0K Heart Failure
MHP, Budget
Septicemia
TJR
Vasc Surg
1.04 $200K -$1K
1.02 $150K -$2K
1 $100K -$3K
0.98 $50K -$4K

0.96 $0K -$5K
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
Olivia Dacre Dr. Mark Cockley Dr. Mark Cockley Todd Warner Craig Albers Mike Whipple
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

43