Page 19 - COPR-Oct 2017
P. 19

Operational Excellence Scorecard

                                                   Kentucky - 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
             Chris Miller   Dr. David Mauterer   Alan Archbold   Dr. David Mauterer      Ashley Britton    Christine Thomas
                                     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
             Cyndy Kern    Dr. Dawn Pingleton     Levi Loverkamp   Janet Simerly        Alan Archbold    Dr. David Mauterer
     1.15                       MTD       $60K                      Acute, Actual  $1K                         Adm Group
                                Rolling 12 Avg                      Acute, Budget                               Gen Surg
                                Target                              MHP, Actual  $0K                            Heart Failure
                                          $40K                      MHP, Budget                                 Septicemia
      1.1                                                                                                       TJR
                                                                                                                Vasc Surg
                                                                             -$1K
                                          $20K
     1.05                                                                    -$2K
                                           $0K
                                                                             -$3K
       1
                                         -$20K
                                                                             -$4K
     0.95                                -$40K                               -$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
          Christine Thomas   Dr. David Mauterer  Kelly Nicholls   Ronda Jones           Alan Archbold   Wayne Reid
        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














                                                             19
   14   15   16   17   18   19   20   21   22   23   24