Page 7 - COPR- January2018
P. 7

Operational Excellence Scorecard

                                                   System - January 2018


       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%
         Jan17  Feb17  Mar17  Apr17  May17  Jun17  Jul17  Aug17  Sep17  Oct17  Nov17  Dec17  Jan17  Feb17  Mar17  Apr17 May17  Jun17  Jul17  Aug17  Sep17  Oct17  Nov17  Dec17  Jan17  Feb17  Mar17  Apr17  May17  Jun17  Jul17  Aug17  Sep17  Oct17  Nov17  Dec17


           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      $1000K                     Acute, Actual  $1K                         Adm Group
                                Rolling 12 Avg                      Acute, Budget                               Gen Surg
     1.08                       Target                              MHP, Actual                                 Heart Failure
                                                                                                                Septicemia
                                                                    MHP, Budget
                                          $800K                               $0K
                                                                                                                TJR
                                                                                                                Vasc Surg
     1.06
                                          $600K                              -$1K
     1.04
                                          $400K                              -$2K
     1.02
                                          $200K
       1                                                                     -$3K
     0.98                                   $0K                              -$4K
        Jan17  Feb17  Mar17  Apr17 May17  Jun17  Jul17 Aug17  Sep17  Oct17  Nov17  Dec17  Jan17  Feb17  Mar17  Apr17  May17  Jun17  Jul17  Aug17  Sep17  Oct17  Nov17  Dec17  Dec16  Jan17  Feb17 Mar17  Apr17 May17  Jun17  Jul17  Aug17  Sep17  Oct17 Nov17
             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%
            Jan17  Feb17  Mar17  Apr17  May17  Jun17  Jul17  Aug17  Sep17  Oct17  Nov17  Dec17  Jan17  Feb17  Mar17  Apr17  May17  Jun17  Jul17  Aug17  Sep17  Oct17  Nov17  Dec17  Jan17  Feb17  Mar17  Apr17  May17  Jun17  Jul17  Aug17  Sep17  Oct17  Nov17  Dec17
















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