# ROI Analysis

 Total Labor Cost Cost of Surgery Exchange Solution Total Cost Savings ROI Per PO Cost Savings Per PO Off Contract Spend Capture \$0

Manual

 Off Contract Spend Capture Manual Labor Cost Labor Cost Using Surgery Exchange Labor Savings Cost of Surgery Exchange Solution Total Cost ROI Manual PO Cost PO Cost using surgery exchange Savings Per PO

Platform Plus

 Off Contract Spend Capture Manual Labor Cost Labor Cost Using Surgery Exchange Labor Savings Cost of Surgery Exchange Solution Total Cost ROI Manual PO Cost PO Cost using surgery exchange Savings Per PO

Platform

 Off Contract Spend Capture Manual Labor Cost Labor Cost Using Surgery Exchange Labor Savings Cost of Surgery Exchange Solution Total Cost ROI Manual PO Cost PO Cost using surgery exchange Savings Per PO

Express

Manual Process Platform Plus Platform Express
Off Contract Spend Capture \$0 \$60,000 \$60,000 \$60,000
Total Labor Cost
Cost of Surgery Exchange Solution \$0
Total Cost
Savings \$0
ROI N/A
Per PO Cost
Savings Per PO N/A

Comparison

prcnt_pos_7 =

pre_surgery =

post_surgery =

labor_costs =

pos_12_mos =

bill_spend =

#### Logic for analysis numbers

Total Labor Cost = D28 + E28
D28=D26*D24
D26=B26*D4
B26=pos_12_mos
D4=43% (STATIC|Frequency of Occurrence)
D24=SUM(D22:D23)
D22=D9/60*B11
D9=pre_surgery
B11=\$25.00 (STATIC|wage rate)
D23=SUM(D18:D19)
D18=(+D13+D15)/60*\$B\$18
D13=30 (STATIC|Non Clinical Labor Minutes)
D15=7 (STATIC|Accounting (Calculating Monthly Accruals and PO/Invoice discrepancies))
B18=\$25.00 (STATIC|wage rate)
D19=D14/60*B19
D14=20 (STATIC|Supervisor/Clinical Labor Minutes. (Resolving Billing, Contract Compliance, Pricing Issues))
B19=\$37.50 (STATIC|wage rate)*1.5
E28=E26*E24
E26=pos_12_mos*57% (STATIC|Frequency of Occurrence)
E24=SUM(E22:E23)
E22=E9/60*\$B\$11
E9=SUM(E7:E8)
E7=10 (STATIC|Total Pre Surgery Labor Minutes Notifications)
E8=40 (STATIC|Pre Surgery Labor Other (Tracking prepaid purchases, unscheduled loaner...) )
B11=\$25.00 (STATIC|wage rate)
E23=SUM(E18:E19)
E18=(+E13+E15)/60*\$B\$18
E13=50 (STATIC|Non Clinical Labor Minutes (Reconciliation, Billing, Data Entry, Paper Filing, Chasing Reps))
E15=10 (STATIC|Accounting (Calculating Monthly Accruals and PO/Invoice discrepancies) )
B18=\$25.00 (STATIC|wage rate)
E19=E14/60*B19
E14=120 (STATIC|Supervisor/Clinical Labor Minutes. (Resolving Billing, Contract Compliance, Pricing Issues) )
B19=\$25.00*1.5 (STATIC|wage rate*1.5)
Cost of Surgery Exchange Solution