Skip Navigation Archive: U.S. Department of Health and Human Services
Archive: Agency for Healthcare Research Quality
Archive print banner
Instructions for Using the Diabetes Cost Calculator for Employers

This information is for reference purposes only. It was current when produced and may now be outdated. Archive material is no longer maintained, and some links may not work. Persons with disabilities having difficulty accessing this information should contact us at: Let us know the nature of the problem, the Web address of what you want, and your contact information.

Please go to for current information.

The calculator can generate several executive summary reports. The files are generated in Microsoft® Word®. For users without access to Word®, HTML versions of the report templates are provided, indicating field codes and their definitions so that users can create their own reports.

@#$_n001 [Today's Date]

Diabetes Cost Calculator for Employers
Executive Summary for @#$_n002 [employer name]

Current Impact and Costs of Diabetes
Of the @#$_n003 [estimated number of organization's employees and covered dependents. Users enter the number of employees. Based on that information and other information that they enter, the calculator generates an assumption about the total number of dependents who are covered] employees and dependents receiving medical coverage from @#$_n002 [employer name], the calculator estimates that @#$_n004 [estimated number of employees and dependents diagnosed with diabetes] are diagnosed with diabetes and @#$_n005 [estimated number of employees and dependents who have diabetes but have not been diagnosed] have undiagnosed diabetes. The estimated annual cost attributed to diabetes for your organization is $@#$_n006 [estimated annual cost of diabetes]. This includes $@#$_n007 [organization's estimated direct medical expenditures for diabetes] in direct medical expenditures and $@#$_n008 [organization's estimated lost productivity costs] in lost productivity costs.

Chart 1:
@#$_Chart001 [covered lives by estimated diabetes status]

Improving Health and Costs
The calculator is based on evidence showing that improved glycemic control in people with diabetes results in lower medical costs and lower costs attributable to lost productivity. You elected to estimate the impact on your diabetes-related direct and indirect costs of reaching the goal to have @#$_n019 [percentage of the organization's employees and dependents that user projects will reach the targeted HbA1c level] of your organization's employees and dependents with diabetes have a hemoglobin A1c (HbA1c)1 of @#$_n020 [target HbA1c level that the user estimates some portion of the organization's employees and dependents will achieve] or below. While you may have set an ambitious goal, the national standard for diabetic quality of care is a target HbA1c level of less than 7 percent. Chart 2 shows how the distribution of HbA1c levels for your organization would shift if @#$_n019 [percentage of the organization's employees and dependents that user projects will reach the targeted HbA1c level] of individuals with diabetes reached the target HbA1c level of @#$_n020 [target HbA1c level that the user estimates some portion of the organization's employees and dependents will achieve].

Chart 2:
@#$_Chart002 [estimated Hemoglobin A1c distribution before and after intervention]

This reduction in average HbA1c level would lower your organization's annual health care costs by an estimated $@#$_n011 [estimated savings in direct health expenditures that the calculator generates] or $@#$_n012 [estimated per person with diabetes savings that the calculator generates] per person receiving the intervention, which includes $@#$_n015 [estimated productivity savings that the calculator generates] in indirect savings due to improved productivity.2 See Chart 3 below. It is important to note that these estimates do not include the potential costs of the interventions that would help your organization reach the target HbA1c level.

Chart 3:
@#$_Chart003 [gross annual savings broken out by savings from reduced direct health care expenditures and reduced lost productivity costs]

1. For diabetes patients, HbA1c levels indicate how successfully patients are managing their condition, with lower levels indicating greater success.
2. The estimated cost savings may be lower because the primary studies were cross-sectional, not longitudinal. This means that in estimating the costs of care for individuals at different HbA1c levels, they did not distinguish between the costs for people who had maintained those levels for long periods of time and people whose HbA1c levels may have been higher or lower in the past.

Return to Instructions


The information on this page is archived and provided for reference purposes only.


AHRQ Advancing Excellence in Health Care