Page 59 - CombinedTest_Neat

Data Updated 1/2/2018 Data Updated 1/2/2018 Data Updated 1/3/2018 Data Updated 1/2/2018 152% Data Updated 1/2/2018 Data Updated 1/2/2018

Look at total spend for variance explanation. Pull Data from St Rita Monthly Robotic Volume by Surgeon Supply Chain (Procedure tab) Pull Data from St Rita Monthly Robotic Volume by Surgeon Supply Chain (Procedure tab) Pull Data from St Rita Monthly Robotic Volume by Surgeon Supply Chain (Procedure tab) Pull Data from STRZ Main OR Volume (Heart tab) Pull Data from STRZ Main OR Volume (Heart tab) Data Source= Cath Lab volumes

Notes Notes Notes Notes

Notes Notes Updated 1/2/2018

$58,848 $85,630 -$8,472 $0 $0 $136,006 $0 $18,939 $60,944 $9,403 -$7,782 $21,250 $10,199 $0 $112,953 $0 $0 $16,674 $16,674

PY Spend PY Spend Volume Impact Volume Impact Volume Impact Volume Impact

-5% -9% -16% -5% -8% 22% -1% $0 $0 $128,000 $128,000 $13,519 $13,519

Variance % PY Qty PY Qty PY Spend PY Spend PY Spend PY Spend

1,663 7,157 280 1,169 1,449 3,346 $43,155 $0 $0 $23,100 $9,500 $75,755 $27,983 $56,405 $71,980 $12,465 $168,833 $311,053 $85,630 $13,555 $410,238 $102,545 $37,878 $156,713 $9,403 $7,782 $21,250 $10,199 $0 $345,771 $106,470 $106,470 $52,800 $43,231 $96,031

Prior Total Spend Total Spend Total Spend Total Spend Total Spend Total Spend

(92) (632) (48) (57) (105) 47 (21) $685 $1,100 $1,250 $1,100 $1,900 $1,207 $3,998 $14,101 $17,995 $567 $0 $0 $6,110 $8,407 $17,126 $1,694 $0 $0 $5,445 $7,888 $6,313 $8,706 $3,134 $7,782 $10,625 $10,199 $0 $6,831 $6,654 $0 $0 $2,218 $0 $2,779 $8,646 $3,808

Variance Avg Cost/Cost Per Avg Cost/Cost Per Avg Cost/Cost Per Avg Cost/Cost Per Avg Cost/Cost Per Avg Cost/Cost Per

1,790 7,430 300 1,089 1,389 211 3,393
Abbott Medtronic Boston (Synergy) Boston (Promus) Abbott Medtronic Boston Gore (Viabahn) Maquet (iCast) Medtronic Abbott Medtronic Medtronic St Jude Medtronic Current Year Current Year
Budget Vendor Vendor Current Year 37 5 8 50 Current Year 13 6 18 3 1 2 1 0 44 16 33 13 62 0 19 5 13

1,698 6,798 252 1,032 1,284 258 3,372 Bard

Actual Qty 63 21 5 89 Qty 7 4 4 22 37 Prior Year 30 0 13 43 Prior Year 13 3 11 0 2 0 0 0 29 Prior Year 61 Prior Year 13 13

IP Surgeries OP Surgeries

Total Admissions Total Patient Days Total Surgeries Total Cath Lab Procedures Total EIPAs Stent Volume Stent Category Cardiology DES Peripheral Drug Coated Balloon Esophogeal Bili Carotid Total CRM Volume Device Type Pacer AICD BIV - AICD Leads Total Spine Volume Case Type Fusion Stimulator Lima Volume Min Invasive Total Orthopedic Volume TJR Procedure Hip Hip Revision Knee Knee Revision Shoulder Shoulder Revision Elbow Ankle Total Robotics Volume Service Line GYN General Urology Total CV Volume Service Line AAA CABG CTO Total