Page 40 - CombinedTest_Neat
P. 40

Actual    Budget     Variance   Prior  Variance %
               Total Admissions                             1,057                                   1,020                                             37                          1,002  4%
               Total Patient Days                             5,013                                   4,500                                           513                          4,352  11%
                     IP Surgeries                                232                                     224                                               8                             243  4%
                     OP Surgeries                                688                                     654                                             34                             732  5%
               Total Surgeries                                920                                      878                                             42                             975  5%
               Total Cath Lab Procedures                               109                                     116                                             (7)   -6%
               Total EIPAs                             2,470                                   2,259                                           211                          2,303  9%
               Stent Volume                                                                             Data Updated
                                                                                                         12/29/2017
               Stent Category  Qty     Vendor   Avg Cost/Cost Per  Total Spend  PY Qty  PY Spend  Notes
               Cardiology DES  54  Abbott              $685   $36,990     72      $50,300 Includes baremetal
                              0    Medtronic          $1,100    $0         0         $0
                              0    Boston (Synergy)   $1,250    $0         0         $0
                              0    Boston (Promus)    $1,100    $0         0         $0
               Peripheral     2    Abbott             $1,350   $2,700     10      $10,108
                              0    Medtronic                               0         $0
                              4    Boston              $700    $2,800      3       $5,100
                              5    Gore (Viabahn)     $3,094  $15,470      0         $0
                              4    Maquet (iCast)     $2,775  $11,100      3       $8,325
               Drug Coated Balloon  22  Bard          $1,509  $33,200     12      $19,200
                              0    Medtronic                    $0         0         $0
               Esophogeal     0                                 $0         0         $0
               Bili           7    Boston Sci          $725    $5,075      7       $5,075
               Carotid        1    Abbott             $1,900   $1,900      2       $3,800
               Total          99                      $1,472  $109,235    109     $101,908
               CRM Volume                                                                               Data Updated
                                                                                                         12/29/2017
               Device Type    Qty      Vendor   Avg Cost/Cost Per  Total Spend  PY Qty  PY Spend  Notes
               Pacer          10   Medtronic          $4,143  $41,433     10      $40,462
               AICD           27 3 2  Medtronic       $22,241  $63,972    11 2    $37,562
                                   Medtronic
                                                        $0
               BIV - AICD
              Kentucky Volume  Total  Prior Year  Current Year  Avg Cost/Cost Per  $0  Total Spend  PY Spend  Volume Impact  Notes  Data Updated
                                   Medtronic
                                                              $28,877
                                                                                   $5,800
                                                      $1,070
               Leads
                                                        $0
                                                      $4,576
                                                              $134,281
               Spine Volume
                                                                                                         12/28/2017
               Case Type
                                                              $311,053
                                                      $15,553
                                        20
                                                                                  $311,053
               Fusion
                                                              $95,000
               Stimulator
                                                      $23,750
                                                                                  $95,000
                                        4
                                                       $738
               Min Invasive
                                                               $5,904
                                                                                   $5,904
                                                        $0
                                                                                     $0
                                                                                     $0
                                                        $0
               Total          0         32 8          $8,008  $411,957    $0      $411,957
               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            30        35            $4,833  $102,545            $24,165
               Hip Revision   1         1             $37,878  $37,878               $0
               Knee           42        26            $3,813  $156,713            -$61,008
               Knee Revision  5         3             $24,000  $8,100             -$48,000
               Shoulder       20        8              $973    $7,782             -$11,673
               Shoulder Revision  0     1             $21,250  $21,250            $21,250
               Elbow          0         0               $0    $10,199                $0
               Ankle          0         0               $0      $0                   $0
               Total          98        74            $11,593  $344,467   $0      -$75,266
               Robotics Volume                                                                          Data Updated
                                                                                                         12/22/2017
               Service Line  Prior Year  Current Year  Avg Cost/Cost Per  Total Spend  PY Spend  Volume Impact  Notes
                                                                                      Pull Data from St Rita Monthly Robotic Volume by
               GYN            0         0               $0                            Surgeon Supply Chain (Procedure tab)
                                                                                      Pull Data from St Rita Monthly Robotic Volume by
               General        0         0               $0                            Surgeon Supply Chain (Procedure tab)
                                                                                      Pull Data from St Rita Monthly Robotic Volume by
               Urology        0         0               $0                            Surgeon Supply Chain (Procedure tab)
               Total          0         0               $0      $0        $0         $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             $11,300  $11,300  $57,000       Pull Data from STRZ Main OR Volume (Heart tab)
               CABG                     8               $0                            Pull Data from STRZ Main OR Volume (Heart tab)
               CTO            0         0               $0    $43,231                 Data Source= Cath Lab volumes
               Total          3         3             $3,767  $54,531   $57,000      $0
   35   36   37   38   39   40   41   42   43   44   45