Page 58 - CombinedTest_Neat

Data Updated
Data Updated
Data Updated
1/3/2018
1/2/2018
1/2/2018
Notes
Notes
Notes
$58,848 Look at total spend for variance explanation. $85,630 Updated 1/2/2018 -$8,472 $0 $0 $136,006 Data Updated 1/2/2018 Notes $0 $18,939 $60,944 $9,403 -$7,782 $21,250 $10,199 $0 152% $112,953 Data Updated 1/2/2018 Notes 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) $0 Data Updated 1/2/2018 Notes Pull Data from STRZ Main OR Volume (Heart tab) $0 Pull Data from STRZ Main OR Volume (Heart tab) $16,674 Data Source= Cath Lab volumes $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