Page 115 - CombinedTest_Neat
P. 115

Actual    Budget     Variance          Variance %
               Total Admissions  705        800         (95)             -12%
               Total Patient Days                       0               #DIV/0!
                     IP Surgeries  131      154         (23)             -15%
                     OP Surgeries  361      330         31                9%
               Total Surgeries   492        484         8                 2%
               Total Cath Lab Procedures  96  70        26                37%
               Total EIPAs                              0               #DIV/0!
               Stent Volume                                                                             Data Updated
                                                                                                         12/29/2017
               Stent Category  Qty     Vendor   Avg Cost/Cost Per  Total Spend  PY Qty  PY Spend  Notes
               Cardiology DES  60  Abbott              $685   $41,100
                                   Medtronic          $1,100    $0
                                   Boston (Synergy)   $1,250    $0
                              28   Boston (Promus)    $1,100  $30,800
               Peripheral          Abbott
                                   Medtronic
                                   Boston
                                   Gore (Viabahn)
                                   Maquet (iCast)
               Drug Coated Balloon  Bard
                                   Medtronic
               Esophogeal
               Bili
               Carotid        4    Abbott             $1,900   $7,600
               Total          92                      $1,207  $79,500
               CRM Volume                                                                               Data Updated
                                                                                                         12/29/2017
               Device Type    Qty      Vendor   Avg Cost/Cost Per  Total Spend  PY Qty  PY Spend  Notes
               Pacer          7    Medtronic          $3,998  $27,983
               AICD           4    Medtronic          $14,101  $56,405
               BIV - AICD     19 0  Medtronic          $736   $13,980
                                                        $0
               Leads
              Toledo Volume  Total  Prior Year  Current Year  Avg Cost/Cost Per  Total Spend  PY Spend  Volume Impact  Notes  Data Updated
                                                        $0
                                                        $0
                                                      $3,139
                                                              $98,368
               Spine Volume
                                                                                                         12/28/2017
               Case Type
                              34
               Fusion
                                                      $8,407
                                        37
                                                                                  $25,221
                                                              $311,053
                                        4
                              0
                                                      $10,085
               Stimulator
                                        8
                              9
                                                      $1,694
               Min Invasive
                                                                                   -$1,694
                                                              $13,555
                                                        $0
                                                                                     $0
                                                        $0    $40,338             $40,338
                                                                                     $0
               Total          43        49            $4,037  $364,946    $0      $63,864
               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            13        13            $7,888  $102,545               $0
               Hip Revision   3         6             $6,313  $37,878             $18,939
               Knee           11        18            $8,706  $156,713            $60,944
               Knee Revision  0         2             $4,050   $8,100              $8,100
               Shoulder       2         1             $7,782   $7,782              -$7,782
               Shoulder Revision  0     2             $10,625  $21,250            $21,250
               Elbow          0         1             $10,199  $10,199            $10,199
               Ankle          0         0               $0      $0                   $0
               Total          29        43            $6,945  $344,467    $0      $111,649
               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                      14              $0                            Surgeon Supply Chain (Procedure tab)
                                                                                      Pull Data from St Rita Monthly Robotic Volume by
               General                  31              $0                            Surgeon Supply Chain (Procedure tab)
                                                                                      Pull Data from St Rita Monthly Robotic Volume by
               Urology                  13              $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                      0               $0                            Pull Data from STRZ Main OR Volume (Heart tab)
               CABG           15        15              $0                            Pull Data from STRZ Main OR Volume (Heart tab)
               CTO                      5             $8,646  $43,231                 Data Source= Cath Lab volumes
               Total          15        15            $2,882  $43,231     $0         $0
   110   111   112   113   114   115   116   117   118   119   120