Page 34 - CombinedTest_Neat
P. 34

Actual    Budget     Variance   Prior  Variance %
               Total Admissions                             1,134                                   1,231                                           (97)                          1,035  -8%
               Total Patient Days                             4,803                                   5,071                                         (268)                          4,625  -5%
                     IP Surgeries                                163                                     214                                           (51)                             201  -24%
                     OP Surgeries                                550                                     484                                             66                             378  14%
               Total Surgeries                                713                                      698                                             15                            579   2%
               Total Cath Lab Procedures                                 30                                       52                                           (22)   -42%
               Total EIPAs                             2,211                                   2,165                                             46                          1,916  2%
               Stent Volume                                                                             Data Updated
                                                                                                         12/29/2017
               Stent Category  Qty     Vendor   Avg Cost/Cost Per  Total Spend  PY Qty  PY Spend  Notes
               Cardiology DES  31  Abbott              $749   $23,219     53      $41,075
                              0    Medtronic            $0      $0         0         $0
                              3    Boston (Synergy)   $1,250   $3,750      7       $8,750
                              0    Boston (Promus)      $0      $0         0         $0
               Peripheral     1    Abbott             $1,300   $1,300      0         $0
                              0    Medtronic            $0      $0         0         $0
                              0    Boston               $0      $0         0         $0
                              1    Gore (Viabahn)     $3,792   $3,792      0         $0
                              0    Maquet (iCast)       $0      $0         0         $0
               Drug Coated Balloon  42  Bard          $1,471  $61,800     17      $23,950
                              0    Medtronic            $0      $0         0         $0
               Esophogeal     0                         $0      $0         0         $0
               Bili           1                        $725    $725        6       $6,092
               Carotid        0    Abbott               $0      $0         0         $0
               Total          79                       $663   $94,586
               CRM Volume                                                                               Data Updated
                                                                                                         12/29/2017
               Device Type    Qty  Medtronic    Avg Cost/Cost Per  $0  Total Spend  PY Qty  6 2  PY Spend $26,848  Notes
                                       Vendor
              Mercy West Volume  Leads  Prior Year  Medtronic  3  Avg Cost/Cost Per  $0  Total Spend  PY Spend $52,976  Volume Impact  Notes  Data Updated
               Pacer
                              8
                                                              $33,140
                                                      $4,143
               AICD
                                                              $64,217
                                                                                  $39,841
                                                      $16,054
                              4
                                   Medtronic
               BIV - AICD
                              0
                              18
                                                                          14
                                                                                  $14,735
                                                      $1,215
                                                              $21,875
                                                        $0
                                                              $119,233
                                                      $3,569
               Total
               Spine Volume
                                                                                                         12/28/2017
               Case Type
                                      Current Year
                                                              $21,608
                                                      $7,203
                              9
                                                                                  -$43,216
               Fusion
                                        0
               Stimulator
                                                        $0
                              0
                                                        $0
                                        0
                              0
               Min Invasive
                                                                          $0
                                                                $0
                                                                                     $0
                                                                                     $0
                                                        $0
                                                        $0      $0        $0         $0
                                                                                     $0
               Total          9         3             $1,441  $21,608   $52,976   -$43,216
               Orthopedic Volume                                                                        Data Updated
                                                                                                         12/28/2017
               TJR Procedure  Prior Year  Current Year  Avg Cost/Cost Per  Total Spend  PY Spend  Volume Impact  Notes
               Hip            20        15            $4,738  $71,065  $100,975    -$9,894                  $5,049
               Hip Revision   3         3             $8,235  $24,706   $19,867      $0                     $6,622
               Knee           25        25            $4,384  $109,612  $118,600     $0                     $4,744
               Knee Revision  2         1             $7,955   $7,955   $20,822    -$7,955                 $10,411
               Shoulder       4         6             $8,140  $48,837   $31,990   $16,279                   $7,998
               Shoulder Revision  1     0               $0      $0      $2,729       $0                     $2,729
               Elbow          0         0               $0      $0                   $0          #DIV/0!
               Ankle          0         0               $0      $0                   $0          #DIV/0!
               Total          55        50            $4,181  $262,175  $294,983   -$1,570
               Robotics Volume                                                                          Data Updated
                                                                                                         12/22/2017
               Service Line  Prior Year  Current Year  Avg Cost/Cost Per  Total Spend  PY Spend  Volume Impact  Notes
               GYN            14        17            $1,501  $25,519   $22,848
               General        0         0               $0      $0        $0
               Urology        2         3             $1,287   $3,861   $3,685
               Total          16        16             $929   $29,380   $26,533      $0
               CV Volume                                                                                Data Updated
                                                                                                         12/22/2017
               Service Line  Prior Year  Current Year  Avg Cost/Cost Per  Total Spend  PY Spend  Volume Impact  Notes
               AAA            3         1             $19,381  $19,381  $101,594
               CABG           7         9             $4,771  $42,937   $32,622
               CTO
               Total          10        10            $12,076  $62,319  $134,216     $0
   29   30   31   32   33   34   35   36   37   38   39