Savings 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
Surgery Exchange PO Cost
Savings Per PO Using Surgery Exchange

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
Surgery Exchange PO Cost
Savings Per PO Using Surgery Exchange

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
Surgery Exchange PO Cost
Savings Per PO Using Surgery Exchange

Express

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

Comparison

Variables from previous page

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