Excel Spreadsheet

ISPI LA Business Impact Calculator

You must be logged in to download this document
Reviews
Shared by: ocak
Stats
views:
248
rating:
not rated
reviews:
0
posted:
1/10/2008
language:
English
pages:
0
WLP Business Impact Calculator Is it worth doing? 1. Better claims quality/decreased overpayments Variable # clms ovrpd pwk # of associates Assumption 48 weeks per year 48 Total Annual Business Impact $0 $ average overpay 2. Increase claims productivity Variable # FTEs impacted increase in # claims prhr Assumptions # hours per year 1,920 Total Annual Business Impact cost per claim $4 $ - 3. Increase calls answered or decrease average handle time Variable # FTEs impacted change in sec per call Assumptions # weeks per year 48 Total Annual Business Impact cost per call $6 $ - 4. Improve single call resolution (reduce repeat calls) Variable # FTEs impacted decrease in # calls prhr Assumptions # hours per year 1,920 Total Annual Business Impact cost per call $6 $ - 5. Decrease penalties and performance guarantees. Variable Assumption $ saved per penalty ave # penlts/grts per year 1,200 6. Decrease in associate ramp-up time Variable # FTEs impacted decrease ramp-up time wk Total Business Impact $ - Assumptions Annual Business Impact Total $ per associate week $1,000 $ - 7. Cost avoidance for litigation/legal exposure Variable Assumption # cases per year ave $ per litigtn/settlemnt Total Business Impact $15,000 8. Decrease associate turnover - Non-Exempt Variable Assumption # decrease turnover ave $ per turnover $25,000 9. Decrease associate turnover - Exempt Variable Assumption # decrease turnover ave $ per turnover $50,000 $ - Total Business Impact $ - Total Business Impact $ $0 - TOTAL BUSINESS IMPACT Intervention Cost Calculator Analysis Design Develop Implement Measure Impact Variables Assumptions # Hrs Completion $ Intervention cost per hour $50 $50 $50 $50 $50 Grand Total Cost Total Cost $ $ $ $ $ $0 WLP SVA Calculator Total Business Impact Total Cost SVA % #DIV/0! Legend: Variable Input Fixed Input Calculated Formula Other Assumptions Total WellPoint Associates = 42,000 Average Claims Processed Per Day = 120 Total WellPoint CCAs = 14,800 Total WellPoint Claims Processors = 8,000 Benefits as % of Salary = 30% CCA Calls Handled Per Day = 60 Average Turnover Cost = $25,000 for Non-Exempt and $50,000 for Non-Exempt Average Cost Per CCA/Claims Processor = $25 per hour with benefits Average Cost Per Intervention Hour = $50 per hour

Related docs
premium docs
Other docs by ocak
Template Project Scale[1]
Views: 4294  |  Downloads: 674
Strategic Asset Plans[1]
Views: 2284  |  Downloads: 539
Steering Committee Charter template[1]
Views: 5163  |  Downloads: 661
Status Report Management Process Flow example[1]
Views: 4964  |  Downloads: 1081
Status Report Example
Views: 7546  |  Downloads: 1774
Scope Statement Development Instructions[1]
Views: 2129  |  Downloads: 90
Schedule Of Excess Risks[1]
Views: 1002  |  Downloads: 31
Risk Value Assessment Tool
Views: 1787  |  Downloads: 144
Risk Response Plan
Views: 1205  |  Downloads: 55
Risk Model Template Tool instructions
Views: 606  |  Downloads: 32
Risk Mitigation Worksheet Template
Views: 1607  |  Downloads: 88
Risk Matrix
Views: 1208  |  Downloads: 77
Risk Management Work Breakdown Structure
Views: 1337  |  Downloads: 168