Page 7 - COPR-Oct 2017
P. 7

Operational Excellence Scorecard

                                                    System - 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
                   Dave Nowiski                         Chris Hilton                            Carl Swart
                                     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. Sam El-Dalati                    Don Koenig                             Dr. Tom Welch
      1.1                       MTD      $1200K                     Acute, Actual  $1K                         Adm Group
                                Rolling 12 Avg                      Acute, Budget                               Gen Surg
     1.08                       Target   $1000K                     MHP, Actual  $0K                            Heart Failure
                                                                                                                Septicemia
                                                                    MHP, Budget
                                                                                                                TJR
     1.06                                 $800K                                                                 Vasc Surg
                                                                             -$1K
     1.04                                 $600K
                                                                             -$2K
     1.02                                 $400K
       1                                  $200K                              -$3K

     0.98                                   $0K                              -$4K
        Sep16 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
                 Ronda Lehman                      Cathy Saluga                              Chris Hilton
        6,500                   Actual   0.88                    MTD          35%                      % Salaries, Actual
                                Budget                           Target                                % Salaries, Budget
                                                                 Budget                                % Supplies, Actual
        6,000                                                                 30%                      % Supplies, Budget
                                         0.86
        5,500                                                                 25%
                                         0.84
        5,000                                                                 20%
                                         0.82
        4,500                                                                 15%
        4,000                             0.8                                 10%
            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
















                                                              7
   2   3   4   5   6   7   8   9   10   11   12