Page 13 - COPR-Oct 2017
P. 13

Operational Excellence Scorecard

                                                   Cincinnati - 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
                      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%
         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
              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                                                                     -$3K
                                         $100K
     0.98                                                                    -$4K

     0.96                                  $0K                               -$5K
        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
                    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
                                                                              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














                                                             13
   8   9   10   11   12   13   14   15   16   17   18