Page 43 - 10640MHSBRO COPR Report November 2017_Neat

Operational Excellence Scorecard

Toledo - November 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%
Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17

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
Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Oct16 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17

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%
Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17 Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17
4,000
Nov16 Dec16 Jan17 Feb17 Mar17 Apr17 May17 Jun17 Jul17 Aug17 Sep17 Oct17

43