Table 3.
Healthcare cost savings estimator tool: a small county.
| Healthcare cost savings estimator tool: CDSMPa | ||||||
|---|---|---|---|---|---|---|
| National study case example | Your local example: if you have data, please enter relevant numbers in cells marked in diagonal stripe for your population. This spreadsheet will make automatic calculations for you. | |||||
| N | % | Change in % | N | % | Change in % | |
| 1. EXAMINE THE PATTERN OF HEALTH CARE UTILIZATION WITHIN YOUR POPULATION | ||||||
| Emergency room (ER) visits | ||||||
| Include number of participants at baseline | 1170 |  |
||||
| Include number of participants reported visiting ER at baseline | 211 | 18% | 16% | |||
| Include number of participants at 6 months | 903 | |||||
| Include number of participants reported visiting ER at the first 6 months | 118 | 13% | 5% | 11% | 5% | |
| Include number of participants at 12 months | 825 | |||||
| Include number of participants reported visiting ER at the second 6 months | 108 | 13% | 5% | 11% | 5% | |
| Hospitalizations | ||||||
| Include number of participants reporting hospitalization at baseline | 164 | 14% |  |
12% | ||
| Include number of participants reporting hospitalization at the first 6 months | 100 | 11% | 3% | 10% | 2% | |
| Include number of participants reporting hospitalization at the second 6 months | 116 | 14% | 0% | 11% | 1% | |
| 2. IDENTIFY MEAN COSTS FOR HEALTH CARE UTILIZATION FROM 2010 MEDICAL EXPENDITURE PANEL SURVEY (MEPS) | ||||||
| Age distribution | Indicate the age distribution for your population | |||||
| Include % for those 18–44 years of age | 10% | Indicate % for those 18–44 |  |
|||
| Include % for those 45–64 years of age | 31% | Indicate % for those 45–64 | ||||
| Include % for those 65+ years of age | 59% | Indicate % for those 65+ | ||||
| ER visits | ||||||
| Mean costs of ER visits for those 18–44 years of age | $ 1,465.00 | $ 1,465.00 | ||||
| Mean costs of ER visits for those 45–64 years of age | $ 1,738.00 | $ 1,738.00 | ||||
| Mean costs of ER visits for those 65+ years of age | $ 1,403.00 | $ 1,403.00 | ||||
| Age-adjusted cost of ER visits | $ 1,513.05 | $ 1,514.77 | ||||
| Cost savings associated with ER visits per person at the first 6 months | $ 75.65 | $ 75.74 | ||||
| Cost savings associated with ER visits per person at the second 6 months | $ 75.65 | $ 75.74 | ||||
| Total cost savings associated with ER visits per person at two time periods | $ 151.31 | $ 151.48 | ||||
| Hospitalizations | ||||||
| Mean costs of hospitalizations for those 18–44 years of age | $ 11,501.00 | $ 11,501.00 | ||||
| Mean costs of hospitalizations for those 45–64 years of age | $ 21,462.00 | $ 21,462.00 | ||||
| Mean costs of hospitalizations for those 65+ years of age | $ 18,554.00 | $ 18,554.00 | ||||
| Age-adjusted cost of hospitalizations | $ 18,750.18 | $ 15,273.16 | ||||
| Cost savings associated with hospitalizations per person at the first 6 months | $ 562.51 | $ 305.46 | ||||
| Cost savings associated with hospitalizations per person at the second 6 months | $– | $ 152.73 | ||||
| Total cost savings associated with hospitalizations per person at two time periods | $ 562.51 | $ 458.19 | ||||
| 3. ESTIMATE COSTS SAVED FROM REDUCED UTILIZATION FOR THE PERIOD OF TIME YOU ARE INTERESTED IN EXAMINING | ||||||
| Based on national information, potential annual health care savings per CDSMP participant from averting ER visits ($ 151.31) and hospitalizations ($ 562.51) can be estimated | $ 713.81 | Potential annual health care savings ($ 151.48 + $ 458.19) | $ 609.67 | |||
| 4. ESTIMATE AVERAGE ANNUAL PROGRAM DELIVERY COSTS | ||||||
| Estimated program delivery costs per person in the National CDSMP study | $ 350.00 | Select your closest program cost per person from the drop-down menu |  |
|||
| 5. DEDUCT ANNUAL PROGRAM COSTS FROM ESTIMATED HEALTH CARE UTILIZATION SAVINGS | ||||||
| Based on national information and using average CDSMP costs per participant ($ 350.00), net cost savings related to ER visits and hospitalizations per CDSMP participant can be estimated | $ 363.81 | Net cost savings ($ 609.67 − $ 438.00) | $ 171.67 | |||
| 6. EXTRAPOLATE TO NATIONAL SAVINGS USING CENSUS DATA COMBINED WITH MEPS DATA 6. CALCULATE YOUR SAVINGS BASED ON POPULATION TO REACH AND NEW AGE DISTRIBUTION | ||||||
| Number of American adults from Census data by age | 234,564,071 | 100% | Number of potential participants reflecting their age distribution |  |
100% | |
| 18-44 | 112,806,642 | 48% | 18–44 | 102 |  |
|
| 45-64 | 81,489,445 | 35% | 45–64 | 66 | ||
| 65+ | 40,267,984 | 17% | 65+ | 32 | ||
| Estimated % of American adults having at least 1 chronic condition from MEPS data by age | 77% | Net Cost Savings based on population to reach and new age distribution | 194.02 | |||
| 18-44 | 71% | |||||
| 45-64 | 84% | |||||
| 65+ | 94% | |||||
| Number of American adults aged 18 and older having at least 1 chronic condition | 180,614,335 | |||||
| Cost savings if you could reach ALL American adults age 18+ having at least 1 chronic condition | $ 65,709,373,342.03 | |||||
| Include % of this population you want to reach | 5% | |||||
| Based on per participant program annual net savings ($ 363.81) for the population you want to reach (5%), national health care savings can be estimated | $ 3,285,468,667.10 | Your healthcare net cost savings by averting ER visits and hospitalizations attributed to CDSMP | $38,803.06 | |||
aBe aware of potential limitations when presenting your data.
The cost estimates presented must be treated as general estimates, as they are not based on precise cost expenditures. Yet, we feel they are robust for purposes of providing ballpark health care utilization costs, program delivery expenses, and estimated net savings to support the widespread dissemination and sustainability of evidence-based chronic disease self-management programs.