Employee Turnover Statistics Due to Poor Management - Excel by vvx68880

VIEWS: 88 PAGES: 66

More Info
									Diabetes Calculator


      1: Run Scenario



      2: View Results


      3: View
        Additional Data
    AHRQ Diabetes Cost Calculator for Employers
                              Version 1.0, October 2007


The Agency for Healthcare Research and Quality (AHRQ) makes the Diabetes Cost Calculator for
              Employers (The Calculator) available under the following conditions:
   The Calculator may be downloaded for specific individual applications by organizations and
 personal use, providing the following notice is included: The Calculator or any modifications or
 adaptations may not be reproduced, sold, or used for commercial purposes without the specific
                                      permission of AHRQ.

  AHRQ is not responsible for any decisions made by organizations using The Calculator. AHRQ
expects that information derived from The Calculator will be considered as potential contributions to
broader organizational decisionmaking processes and that organizations will consult other sources
   in formulating their decisions. AHRQ makes no warranty, expressed or implied, regarding the
  completeness, accuracy, or currency of any information provided through The Calculator. In no
event will AHRQ, The Lewin Group, Inc., or any organization partnering in the dissemination of The
 Calculator be liable for any decision that is made based solely on the information contained in or
provided by The Calculator. AHRQ, The Lewin Group, Inc., and any organization partnering in the
 dissemination of The Calculator are not liable for any damages, including consequential, special,
   punitive, or exemplary damages resulting from use of The Calculator or any of the information
                                          contained therein.

  The Calculator was funded by AHRQ and developed by researchers at The Lewin Group, Inc.
                           under AHRQ Contract No. 290-04-0011.
  Return to Scenario
                       3rd Quarter 2005 Cost of
                            Living Figures

                       State    Index      Health
                                            Care                     <18
Alaska                  AK          127        138.8                18-44
Alabama                 AL          91.9        87.1                45-64
Arkansas                AR          87.4        90.1                 65+
Arizona                 AZ         101.7       102.6
California              CA         144.1       115.6
Colorado                CO          100        103.1    Year      CPIM

Connecticut             CT         128.1       123.2    1993             202.2
District of Columbia    DC         145.9       116.1    1994             211.3
Delaware                DE         101.3       103.6    1995             220.6
Florida                 FL         102.8       103.5    1996             228.6
Georgia                 GA          94.1        99.4    1997             234.7
Hawaii                  HI         158.7       110.2    1998             242.5
Iowa                    IA          94.4        93.4    1999             250.9
Idaho                   ID          92.9       100.4    2000             261.2
Illinois                IL          94.8        98.1    2001             272.9
Indiana                 IN          95.2        98.2    2002             286.4
Kansas                  KS          90.7        91.2    2003             297.4
Kentucky                KY          91.4        93.6    2004             310.8
Louisiana               LA          97.2         97     2005               324
Massachusetts           MA         120.2       117.6    2006             337.8
Maryland                MD         125.6       110.5
Maine                   ME         127.5       115.5   Medical
                                                       Inflatio
                                                          n                4%
Michigan                MI          99.9        95.6
Minnesota               MN          99.5       102.6
Missouri                MO          90.2        94.2
Mississippi             MS          90.2        95.5
Montana                 MT         101.2       101.4
North Carolina          NC          95.6       106.1
North Dakota            ND          91.4        95.2
Nebraska                NE          88.7        88.5
New Hampshire           NH         127.5       115.5
New Jersey              NJ         133.5       107.9
New Mexico              NM         100.2        104
Nevada                  NV         114.1       109.8
New York                NY         134.5       106.7
Ohio                    OH          96.1        96.6
Oklahoma                OK          88.2        93.7
Oregon                  OR         104.1       107.8
Pennsylvania            PA         104.2         98
Puerto Rico      PR     100      100
Rhode Island     RI    127.1    114.3
South Carolina   SC     95.1    101.1
South Dakota     SD     92.8     90.9
Tennessee        TN     89.7     92.7
Texas            TX     89.2     97.4
Utah             UT     92.8     92.2
Virginia         VA    102.8    100.8
Vermont          VT     117      104
Washington       WA    104.3    117.9
Wisconsin        WI     95.6    100.7
West Virginia    WV      93      92.3
Wyoming          WY    103.2     97.8


Alaska                1.270    1.388
                          Annual cost of care
Annual cost of care for   for individuals         Annual cost of care   Annual cost for
individuals with          without diabetes--      for individuals       care (adjusted by
diabetes--COL Adj         COL Adj                 without diabetes      User)

                $5,746    $              2,394    $            1,725    $              1,730
                $9,378    $              3,907    $            2,815    $              2,884
               $15,892    $              6,622    $            4,771    $              5,316
               $15,858    $              6,607    $            4,760    $               5,782
                                                  $            4,275        User Adj. Scalar
                                                                                         100%
       CPIU               2006 $ CPIM Conv.           2006 $ CPIU
                                                         Conv.
                 144.5                     1.67                 1.41
                 148.2                     1.60                 1.37
                 152.4                     1.53                 1.34
                 156.9                     1.48                 1.30
                 160.5                     1.44                 1.27
                   163                     1.39                 1.25
                 166.6                     1.35                 1.22
                 172.2                     1.29                 1.18
                 177.1                     1.24                 1.15
                 179.9                     1.18                 1.13
                   184                     1.14                 1.11
                 188.9                     1.09                 1.08
                 195.4                     1.04                 1.04
                 203.7                     1.00                 1.00



                   3%
                                                              % w/
                                               Age-adjusted   diagnosed
Annual cost for      Proportion with           diabetes       diabetes--
care (raw data)      diabetes                  cost scalar    employer

$            1,730                     0.2%             2.4                2%   $3,352
$            2,884                     1.7%                            44%      $5,470
$            5,316                     8.2%                            33%      $9,270
$            5,782                     15.3%                          21%       $9,250
                                                                     100%
 Return to Scenario

Average Number of Children Per Family and Per Family With Children, by State
                                Families                      Own children under 18
                                       With own                                 Average per
            State
                                       children                   Average per    family with
                          Total        under 18        Total          family       children
United States            71,787,347    34,588,368    64,494,637            0.90          1.86
Alabama                   1,215,968        561,458      989,799            0.81          1.76
Alaska                      152,337         88,484      174,113            1.14          1.97
Arizona                   1,287,367        608,218    1,197,438            0.93          1.97
Arkansas                    732,261        334,604      601,711            0.82          1.80
California                7,920,049      4,117,036    8,035,222            1.01          1.95
Colorado                  1,084,461        543,588    1,004,792            0.93          1.85
Connecticut                 881,170        419,285      772,790            0.88          1.84
Delaware                    204,590         95,175      172,150            0.84          1.81
District of Columbia        114,166         49,104        88,899           0.78          1.81
Florida                   4,210,760      1,779,586    3,200,461            0.76          1.80
Georgia                   2,111,647      1,051,302    1,899,303            0.90          1.81
Hawaii                      287,068        129,322      239,483            0.83          1.85
Idaho                       335,588        170,463      343,031            1.02          2.01
Illinois                  3,105,513      1,514,561    2,884,036            0.93          1.90
Indiana                   1,602,501        767,836    1,432,898            0.89          1.87
Iowa                        769,684        361,153      686,153            0.89          1.90
Kansas                      701,547        345,091      659,418            0.94          1.91
Kentucky                  1,104,398        516,344      901,105            0.82          1.75
Louisiana                 1,156,438        572,053    1,049,117            0.91          1.83
Maine                       340,685        157,325      279,827            0.82          1.78
Maryland                  1,359,318        662,172    1,194,489            0.88          1.80
Massachusetts             1,576,696        748,865    1,382,189            0.88          1.85
Michigan                  2,575,699      1,236,713    2,347,192            0.91          1.90
Minnesota                 1,255,141        626,291    1,210,443            0.96          1.93
Mississippi                 747,159        363,416      657,312            0.88          1.81
Missouri                  1,476,516        699,779    1,293,406            0.88          1.85
Montana                     237,407        111,807      211,642            0.89          1.89
Nebraska                    443,411        217,636      420,245            0.95          1.93
Nevada                      498,333        238,846      451,743            0.91          1.89
New Hampshire               323,651        158,410      289,296            0.89          1.83
New Jersey                2,154,539      1,025,556    1,880,026            0.87          1.83
New Mexico                  466,515        235,030      445,404            0.95          1.90
New York                  4,639,387      2,231,381    4,155,866            0.90          1.86
North Carolina            2,158,869        995,648    1,744,451            0.81          1.75
North Dakota                166,150         80,453      152,563            0.92          1.90
Ohio                      2,993,023      1,409,912    2,632,157            0.88          1.87
Oklahoma                    921,750        434,793      796,868            0.86          1.83
Oregon                      877,671        410,803      766,709            0.87          1.87
Pennsylvania              3,208,388      1,430,808    2,653,125            0.83          1.85
Rhode Island                265,398        124,867      228,391            0.86          1.83
South Carolina            1,072,822        495,276      875,535            0.82          1.77
South Dakota                194,330         95,180      185,835            0.96          1.95
Tennessee                 1,547,835        707,305    1,239,200            0.80          1.75
                                  Families                      Own children under 18
                                         With own                                 Average per
         State
                                         children                   Average per    family with
                            Total        under 18        Total         family        children
Texas                       5,247,794      2,723,330     5,164,472          0.98           1.90
Utah                          535,294        299,746       663,394          1.24           2.21
Vermont                       157,763         76,409       138,281          0.88           1.81
Virginia                    1,847,796        881,893     1,561,010          0.84           1.77
Washington                  1,499,127        742,481     1,385,475          0.92           1.87
West Virginia                 504,055        213,072       363,929          0.72           1.71
Wisconsin                   1,386,815        665,239     1,273,539          0.92           1.91
Wyoming                       130,497         63,263       118,704          0.91           1.88

Source: U.S. Bureau of the Census, Census 2000 Summary File 1 (SF 1) 100-Percent Data, Tables P34
"Family Type by Presence and Age of Own Children" and P36 "Own Children Under 18 Years by Family
Type and Age".

FOR FURTHER INFORMATION contact:
Fertility and Family Branch
301-763-2416
Percent of private-sector employees enrolled in a health insurance plan that take family coverage by fir


      Industries used in calculator              Characteristics          Total
                                         United States                    36.2%
                                         Agric., fish, forest.            34.4%
Manufacturing                            Mining and manufacturing 43.5%
Construction                             Construction                     37.1%
Trade, transportation, and utilities     Utilities and transp.            40.2%
                                         Wholesale trade                  40.1%
                                         Fin. sys. and real estate        36.9%
                                         Retail trade                     31.8%
Professional and business services       Professional services            33.1%
Education and health services            Other services                   31.9%
Government                               Other services                    0.319
Leisure and hospitality                  Other services                    0.319
Source: Agency for Healthcare Research and Quality, Center for Financing, Access and Cost Trends. 2003 Me
Percent of private-sector employees enrolled in a health insurance plan that take family coverage by fir


      Industries used in calculator             Characteristics         Total
e plan that take family coverage by firm size and selected characteristics

             Less than 10      10-24       25-99       100-999        1,000+     Less than 50 50 or more
              employees employees employees employees employees                   employees employees
                    32.6%         28.8%       30.5%       34.1%           39.7%         30.7%      37.5%
                    37.9%         44.4%       22.5%       34.1%           48.0%         34.9%      34.1%
                    32.0%         34.0%       34.8%       42.8%           46.6%         33.8%      44.7%
                    40.3%         29.9%       38.0%       39.2%           38.1%         35.2%      39.2%
                    35.7%         26.1%       35.0%       38.8%           42.3%         34.0%      41.0%
                    28.8%         31.6%       37.0%       38.1%           45.7%         31.2%      43.1%
                    30.2%         31.2%       27.3%       34.5%           39.4%         30.5%      37.8%
                    31.8%         27.1%       29.9%       28.3%           33.5%         29.5%      32.3%
                    30.4%         25.5%       25.6%       29.3%           37.6%         28.7%      34.2%
                    33.6%         27.6%       24.8%       28.7%           35.5%         28.5%      33.0%
                    33.6%          0.276       0.248       0.287           0.355         0.285       0.33
                     0.336         0.276       0.248       0.287           0.355         0.285       0.33
ncing, Access and Cost Trends. 2003 Medical Expenditure Panel Survey-Instrument Component.
e plan that take family coverage by firm size and selected characteristics

             Less than 10 10-24     25-99    100-999                 1,000+    Less than 50 50 or more
              employees employees employees employees              employees    employees employees
 Return to Scenario                       Construction                                       Manufacturing
                        Non-     Non-     Non-                       Non-     Non-
                       Hispanic Hispanic Hispanic                   Hispanic Hispanic
        State           White    Black    Other   Hispanic % Female White     Black
Alabama                81.56%    13.56%      1.76%        3.12%   12.17%   72.19%   23.40%
Alaska                 84.85%     1.42%      9.69%        4.04%   15.49%   76.72%    3.40%
Arizona                63.22%     1.26%      3.99%       31.53%   12.82%   68.04%    2.60%
Arkansas               85.53%     5.77%      3.69%        5.02%   11.39%   74.38%    8.31%
California             56.03%     2.72%      7.11%       34.14%   12.33%   43.59%    3.22%
Colorado               73.28%     1.41%      2.60%       22.70%   12.88%   76.20%    2.70%
Connecticut            86.24%     3.64%      2.78%        7.34%   10.69%   79.86%    5.85%
Delaware               86.99%     7.65%      2.09%        3.27%   11.35%   75.44%   14.70%
District of Columbia   47.80%    28.25%      3.77%       20.18%   11.17%   58.48%   29.57%
Florida                70.21%     8.39%      2.48%       18.92%   13.40%   65.51%   10.61%
Georgia                63.26%    15.28%      2.33%       19.13%   12.56%   62.17%   25.34%
Hawaii                 56.03%     2.72%      7.11%       34.14%   12.33%   43.59%    3.22%
Idaho                  90.82%     0.11%      2.81%        6.26%   13.55%   83.73%    0.47%
Illinois               79.69%     5.29%      2.43%       12.59%   13.25%   66.51%    8.27%
Indiana                90.54%     4.05%      1.28%        4.13%   13.89%   83.69%    8.52%
Iowa                   94.77%     0.96%      1.44%        2.83%   12.83%   87.92%    3.54%
Kansas                 84.69%     3.04%      2.41%        9.85%   12.37%   81.25%    6.78%
Kentucky               91.34%     4.60%      1.38%        2.67%   12.54%   83.75%   11.58%
Louisiana              74.45%    19.66%      2.06%        3.83%   12.21%   69.88%   24.28%
Maine                  97.58%     0.49%      1.49%        0.44%   11.92%   96.70%    0.36%
Maryland               74.74%    12.38%      2.98%        9.90%   12.23%   74.43%   16.98%
Massachusetts          91.94%     2.28%      3.06%        2.72%   11.52%   83.82%    2.50%
Michigan               88.31%     5.41%      2.25%        4.04%   13.65%   80.36%   11.78%
Minnesota              94.17%     1.32%      2.14%        2.37%   12.65%   87.25%    2.70%
Mississippi            77.75%    18.31%      6.85%        2.69%   11.99%   62.92%   33.28%
Missouri               90.22%     5.07%      2.11%        2.61%   12.58%   83.54%   10.45%
Montana                95.41%     0.16%      2.55%        1.89%   14.56%   93.39%    0.18%
Nebraska               90.23%     2.06%      1.54%        6.17%   11.41%   80.66%    5.36%
Nevada                 65.83%     2.59%      4.01%       27.56%   13.61%   71.55%    4.04%
New Hampshire          97.50%     0.25%      1.23%        1.03%   11.50%   92.44%    0.79%
New Jersey             80.42%     5.19%      2.98%       11.41%   12.14%   65.51%    8.44%
New Mexico             41.17%     0.81%      7.96%       50.05%   13.12%   49.21%    1.28%
New York               71.80%     8.34%      5.74%       14.13%   11.23%   67.88%    7.63%
North Carolina         74.55%     9.33%      2.91%       13.22%   12.42%   70.24%   19.35%
North Dakota           95.84%     0.30%      2.36%        1.50%   13.91%   93.34%    0.97%
Ohio                   91.71%     4.65%      1.51%        2.13%   13.87%   86.20%    9.37%
Oklahoma               75.41%     3.94%      9.06%       11.59%   12.67%   73.63%    7.76%
Oregon                 88.12%     0.74%      3.90%        7.24%   13.38%   81.60%    1.34%
Pennsylvania           92.86%     3.81%      1.27%        2.06%   11.70%   88.41%    4.80%
Rhode Island           91.99%     1.74%      2.48%        3.79%   11.04%   77.27%    2.44%
South Carolina    76.53%      15.55%      1.78%        6.13%     12.24%      68.70%      26.10%
South Dakota      94.93%       0.73%      2.29%        2.06%     11.78%      86.13%       2.73%
Tennessee         83.26%       8.43%      1.36%        6.95%     11.43%      77.22%      17.19%
Texas             49.96%       4.26%      2.02%       43.75%     11.09%      56.45%       8.95%
Utah              84.28%       0.43%      3.06%       12.23%     11.08%      79.32%       0.63%
Vermont           97.61%       0.24%      1.74%        0.41%     11.19%      95.38%       0.44%
Virginia          70.99%      12.63%      4.10%       12.28%     13.27%      64.22%      25.52%
Washington        86.99%       1.53%      5.43%        6.06%     14.39%      80.29%       2.49%
West Virginia     96.94%       1.92%      0.97%        0.17%     10.43%      93.82%       3.81%
Wisconsin         94.00%       1.83%      1.52%        2.64%     13.84%      87.37%       4.36%
Wyoming           95.41%       0.16%      2.55%        1.89%     14.56%      93.39%       0.18%



                 Source: Bureau of Labor Statistics - http://www.bls.gov/lau/table14full04.pdf
Manufacturing                              Business and Professional Services                     Leisure and Hospi
   Non-                       Non-     Non-     Non-                       Non-
  Hispanic                   Hispanic Hispanic Hispanic                   Hispanic
   Other   Hispanic % Female White     Black    Other   Hispanic % Female White
    2.46%        1.95%   28.42%   78.19%     18.50%      2.13%      1.17%       47.97%   60.63%
   14.44%        5.44%   32.25%   79.25%      4.07%     12.93%      3.75%       47.37%   60.70%
    6.77%       22.59%   30.32%   74.56%      3.09%      4.76%     17.60%       46.33%   63.86%
    7.72%        9.60%   33.14%   83.80%     11.01%      3.25%      1.94%       47.81%   72.30%
   19.57%       33.63%   34.12%   57.51%      5.75%     15.68%     21.06%       44.10%   45.13%
    6.06%       15.03%   33.06%   81.15%      3.77%      4.77%     10.31%       46.58%   70.89%
    5.22%        9.06%   32.38%   82.42%      6.89%      4.18%      6.51%       46.46%   75.53%
    4.05%        5.81%   31.22%   77.29%     15.66%      3.95%      3.11%       51.56%   74.39%
    7.10%        4.84%   41.45%   56.77%     28.75%      8.31%      6.17%       49.17%   36.02%
    4.48%       19.39%   33.61%   70.32%     10.17%      3.40%     16.11%       46.58%   64.80%
    5.26%        7.23%   32.41%   65.86%     25.22%      4.86%      4.06%       46.38%   52.20%
   19.57%       33.63%   34.12%   57.51%      5.75%     15.68%     21.06%       44.10%   45.13%
    5.62%       10.18%   31.73%   92.05%      0.28%      3.22%      4.45%       49.14%   87.26%
    5.69%       19.53%   31.83%   71.37%     13.44%      5.80%      9.38%       47.33%   60.85%
    2.29%        5.50%   28.54%   85.88%      9.30%      2.17%      2.65%       49.31%   78.83%
    3.71%        4.83%   28.69%   93.19%      2.41%      2.52%      1.89%       50.68%   87.25%
    5.73%        6.25%   28.94%   85.14%      6.45%      3.93%      4.48%       47.41%   74.49%
    2.79%        1.88%   28.30%   86.86%      9.92%      2.28%      0.94%       47.75%   79.14%
    3.10%        2.74%   24.94%   72.92%     21.86%      2.50%      2.72%       48.27%   53.94%
    2.35%        0.59%   29.41%   97.31%      0.38%      1.70%      0.61%       50.24%   94.81%
    5.86%        2.72%   31.59%   67.60%     21.22%      7.11%      4.07%       48.12%   60.59%
    7.57%        6.10%   33.02%   86.62%      3.61%      5.87%      3.90%       45.62%   79.64%
    4.14%        3.72%   27.31%   80.31%     13.35%      3.92%      2.42%       49.36%   77.01%
    6.74%        3.31%   32.60%   89.97%      3.50%      4.33%      2.20%       47.99%   81.70%
    5.02%        2.13%   27.37%   74.34%     22.90%      8.33%      0.85%       48.57%   62.77%
    3.32%        2.69%   30.56%   83.15%     12.19%      2.93%      1.72%       48.47%   76.35%
    2.71%        3.73%   26.46%   95.06%      0.22%      2.68%      2.04%       50.99%   90.60%
    5.45%        8.54%   31.01%   89.68%      4.71%      3.03%      2.58%       48.15%   82.87%
    6.14%       18.27%   28.11%   73.63%      5.94%      7.12%     13.31%       45.59%   58.34%
    3.72%        3.05%   33.97%   95.15%      0.66%      2.63%      1.56%       47.78%   92.39%
    8.05%       18.00%   36.72%   71.74%     10.07%     80.90%     10.10%       45.04%   63.87%
    9.38%       40.13%   32.11%   59.56%      1.68%      6.19%     32.56%       45.47%   44.44%
   10.25%       14.23%   36.88%   66.28%     12.43%      9.27%     12.02%       43.86%   58.91%
    4.55%        5.86%   37.19%   76.95%     16.54%      3.43%      3.08%       47.32%   66.00%
    3.31%        2.38%   24.51%   95.88%      0.38%      2.60%      1.14%       50.56%   92.98%
    2.52%        1.91%   28.78%   85.13%     10.58%      2.87%      1.42%       48.61%   82.68%
   11.77%        6.84%   28.15%   79.80%      7.86%      8.32%      4.02%       47.87%   65.51%
    9.20%        7.86%   27.62%   86.60%      1.46%      6.32%      5.61%       47.25%   77.29%
    3.41%        3.38%   30.37%   85.33%      9.31%      3.03%      2.33%       47.40%   82.83%
    6.82%       13.47%   37.65%   87.03%      3.31%      3.79%      5.87%       47.74%   85.79%
 2.39%    2.80%   33.68%   79.51%   16.54%    1.93%    2.02%   48.43%   66.13%
 6.14%    5.00%   34.11%   96.45%    0.63%    2.10%    0.83%   54.41%   92.78%
 3.03%    2.56%   32.07%   79.76%   16.19%    2.34%    1.72%   48.23%   72.21%
 6.69%   27.91%   29.25%   61.98%   10.53%    5.30%   22.19%   45.54%   44.87%
 6.90%   13.16%   31.27%   88.53%    0.65%    4.04%    6.78%   45.04%   79.04%
 3.40%    0.78%   26.71%   96.41%    0.64%    2.19%    0.76%   50.28%   91.03%
 6.79%    3.47%   31.03%   69.43%   17.58%    8.48%    4.51%   46.36%   55.02%
12.17%    5.05%   28.51%   82.81%    2.90%   10.11%    4.18%   46.61%   72.46%
 1.69%    0.68%   22.15%   93.38%    4.27%    1.86%    0.49%   48.41%   88.38%
 3.28%    4.99%   30.95%   88.99%    5.56%    2.49%    2.96%   50.42%   82.47%
 2.71%    3.73%   26.46%   95.06%    0.22%    2.68%    2.04%   50.99%   90.60%
   Leisure and Hospitality                      Education and Health Care Services
 Non-     Non-                       Non-     Non-     Non-
Hispanic Hispanic                   Hispanic Hispanic Hispanic
 Black    Other   Hispanic % Female White     Black    Other   Hispanic % Female
32.13%      4.33%     2.91%   55.21%   69.65%      26.93%     2.53%      0.89%       74.74%
 5.12%     23.77%    10.41%   49.76%   77.69%       5.52%    12.65%      4.14%       72.97%
 2.13%      7.69%    26.32%   48.07%   74.73%       3.33%     5.90%     16.04%       71.46%
15.69%      6.35%     5.67%   52.64%   80.45%      14.18%     3.97%      1.41%       72.99%
 3.83%     15.78%    35.26%   46.36%   57.14%       7.68%    14.99%     20.20%       70.52%
 2.95%      6.51%    19.65%   49.08%   81.73%       3.86%     3.91%     10.51%       72.13%
 6.67%      6.82%    10.98%   50.40%   82.02%       8.74%     3.94%      5.30%       72.17%
13.37%      5.27%     6.97%   52.98%   76.52%      17.28%     3.49%      2.71%       73.81%
31.63%     13.34%    19.01%   44.71%   37.32%      49.74%     8.23%      4.71%       65.99%
12.86%      6.06%    16.28%   47.93%   66.82%      16.03%     3.99%     13.17%       73.29%
30.81%      6.98%    10.02%   51.10%   63.43%      30.85%     3.60%      2.12%       73.98%
 3.83%     15.78%    35.26%   46.36%   57.14%       7.68%    14.99%     20.20%       70.52%
 0.39%      5.27%     7.08%   53.23%   92.86%       0.35%     3.35%      3.44%       74.02%
11.61%      6.29%    21.25%   48.38%   70.61%      16.38%     6.60%      6.41%       72.28%
10.67%      3.99%     6.52%   54.29%   84.18%      10.79%     2.93%      2.10%       73.48%
 3.68%      4.09%     4.99%   52.92%   92.89%       2.77%     2.82%      1.52%       72.70%
 7.19%      7.08%    11.24%   50.32%   83.69%       8.60%     3.90%      3.82%       74.06%
12.71%      4.52%     3.63%   50.66%   84.18%      12.04%     2.81%      0.96%       73.73%
37.81%      4.38%     3.87%   54.59%   64.60%      30.55%     2.74%      2.11%       74.44%
 0.54%      3.64%     1.01%   57.16%   97.04%       0.49%     1.86%      0.61%       74.22%
22.68%      9.42%     7.31%   49.75%   65.16%      26.14%     6.07%      2.63%       73.17%
 3.73%      9.32%     7.31%   51.33%   84.88%       5.49%     5.41%      4.22%       71.40%
13.83%      5.18%     3.98%   54.93%   78.17%      15.39%     4.37%      2.07%       75.11%
 4.11%      7.36%     6.83%   50.36%   89.83%       4.41%     4.32%      1.45%       72.45%
29.89%     17.51%     2.12%   55.86%   64.23%      32.96%     5.81%      0.89%       75.41%
14.57%      5.10%     3.98%   49.43%   80.63%      14.67%     3.29%      1.41%       73.33%
 0.27%      3.87%     5.26%   57.32%   93.66%       0.15%     4.17%      2.02%       75.39%
 5.28%      5.69%     6.17%   52.41%   89.46%       5.33%     3.03%      2.18%       72.08%
 6.68%     13.04%    21.94%   47.43%   75.52%       7.67%     8.38%      8.43%       72.34%
 0.91%      4.44%     2.25%   55.21%   96.28%       0.67%     1.87%      1.18%       76.36%
10.10%      9.30%    16.72%   47.49%   71.44%      14.24%     6.73%      7.58%       73.02%
 1.53%     11.07%    42.97%   50.19%   55.47%      34.49%     1.86%      8.17%       70.86%
 9.69%     11.92%    19.48%   42.66%   64.46%      17.48%     7.75%     10.31%       70.65%
20.59%      5.53%     7.87%   51.98%   73.23%      21.85%     3.40%      1.53%       74.99%
 1.77%      3.70%     1.77%   50.98%   95.17%       0.31%     3.69%      0.83%       72.74%
10.94%      3.84%     2.54%   54.74%   83.05%      12.79%     2.90%      1.26%       74.43%
11.35%     12.39%    10.76%   50.70%   77.16%      10.91%     9.22%      2.70%       73.21%
 1.63%      9.61%    11.47%   53.17%   88.50%       1.82%     5.97%      3.71%       72.60%
 9.04%      4.50%     3.62%   52.86%   84.04%      11.09%     3.03%      1.83%       71.92%
 2.75%      6.49%     4.98%   51.01%   88.23%       3.88%     4.32%      3.56%       71.52%
26.48%    3.55%    3.84%   54.33%   74.03%   22.60%   2.08%    1.29%   75.61%
 1.23%    3.97%    2.03%   52.39%   96.98%    0.66%   1.99%    0.36%   75.38%
19.54%    4.02%    4.23%   51.08%   76.75%   19.65%   2.62%    0.99%   73.06%
 9.86%    5.98%   39.29%   49.35%   58.56%   13.70%   4.92%   22.81%   72.89%
 0.61%    5.80%   14.55%   49.90%   90.83%    0.64%   3.88%    4.65%   68.34%
 0.88%    6.30%    1.78%   48.98%   95.13%    0.58%   2.90%    1.39%   71.23%
20.47%   11.72%   12.79%   51.08%   66.00%   24.37%   6.03%    3.59%   75.82%
 2.90%   15.47%    9.17%   52.22%   82.75%    3.74%   9.62%    3.88%   72.97%
 7.98%    2.89%    0.75%   52.46%   91.04%    5.85%   2.70%    0.42%   74.25%
 6.12%    5.13%    6.28%   53.85%   87.86%    6.74%   3.09%    2.31%   74.57%
 0.27%    3.87%    5.26%   57.32%   93.66%    0.15%   4.17%    2.02%   75.39%
         Trade, Transportation and Utilities                              Government
 Non-     Non-     Non-                       Non-     Non-     Non-
Hispanic Hispanic Hispanic                   Hispanic Hispanic Hispanic
 White    Black    Other   Hispanic % Female White     Black    Other   Hispanic
76.20%      20.64%      2.13%      1.03%       39.19%   70.57%   26.47%      2.09%      0.88%
78.42%       4.05%     13.50%      4.03%       38.78%   80.32%    3.46%     10.77%      3.46%
73.70%       2.79%      4.79%     18.72%       39.55%   69.35%     5%        6.65%       19%
84.64%       9.32%      3.53%      2.51%       38.70%   78.27%   17.34%      2.49%      1.90%
51.52%       5.35%     14.98%     28.14%       38.44%   57.46%   10.80%     12.88%     18.85%
79.48%       3.69%      4.23%     12.59%       40.00%   79.37%    5.36%      3.79%     11.48%
81.48%       7.39%      3.65%      7.48%       40.89%   80.26%   10.77%      2.65%      6.32%
80.12%      13.89%      3.00%      3.00%       40.70%   74.96%   20.13%      2.18%      2.73%
38.94%      44.67%     10.49%      5.90%       34.43%   56.85%   34.27%      5.22%      3.66%
66.95%      10.68%      3.94%     18.42%       39.99%   69.97%   16.86%      2.85%     10.32%
65.31%      26.18%      4.60%      3.91%       38.62%   57.54%   37.91%      2.52%      2.03%
51.52%       5.35%     14.98%     28.14%       38.44%   57.46%   10.80%     12.88%     18.85%
91.66%       0.43%      2.81%      5.09%       41.86%   91.46%    0.60%      3.19%      4.76%
72.87%      11.59%      5.21%     10.33%       39.73%   70.60%   20.59%      2.89%      5.92%
87.71%       7.62%      1.99%      2.69%       41.08%   81.05%   14.73%      1.76%      2.47%
93.73%       2.23%      2.18%      1.86%       39.90%   93.29%    3.74%      1.43%      1.54%
86.03%       5.55%      3.75%      4.67%       39.10%   83.50%    9.61%      3.29%      3.60%
88.53%       8.43%      2.00%      1.04%       38.98%   81.88%   15.29%      1.69%      1.13%
68.73%      25.49%      3.16%      2.62%       40.02%   65.03%   31.29%      1.92%      1.76%
97.37%       0.47%      1.64%      0.51%       40.25%   97.27%    0.53%      1.83%      0.37%
67.54%      23.49%      5.59%      3.37%       39.96%   64.95%   28.45%      4.47%      2.13%
87.29%       3.65%      4.48%      4.58%       40.03%   87.26%    5.79%      3.30%      3.65%
83.36%      10.84%      3.34%      2.46%       42.05%   73.79%   21.54%      2.42%      2.26%
91.04%       3.12%      3.87%      1.96%       40.38%   90.69%    3.67%      3.83%      1.81%
69.58%      26.82%      8.90%      1.21%       38.95%   65.24%   32.26%      4.95%      0.91%
85.78%       9.95%      2.56%      1.70%       38.98%   77.08%   19.31%      2.19%      1.41%
93.99%       0.27%      3.36%      2.38%       35.34%   89.73%    0.36%      7.38%      2.53%
90.38%       4.47%      2.05%      3.11%       37.82%   89.19%    6.53%      2.35%      1.92%
73.47%       5.97%      8.10%     12.46%       40.31%   76.07%   10.04%      6.47%      7.42%
95.55%       0.64%      2.09%      1.72%       42.31%   96.71%    0.63%      1.99%      0.66%
69.46%      10.22%      7.21%     13.11%       38.72%   74.22%   16.06%      3.11%      6.61%
51.81%       1.79%      8.14%     38.26%       40.63%   42.36%    2.49%      8.16%     46.99%
63.60%      11.93%     10.43%     14.03%       36.43%   68.40%   17.71%      4.59%      9.31%
77.48%      16.71%      3.16%      2.65%       38.80%   72.45%   22.63%      3.04%      1.88%
96.98%       0.34%      1.69%      0.99%       37.91%   96.43%    0.66%      1.69%      1.22%
87.78%       8.51%      2.29%      1.42%       41.28%   79.78%   16.80%      1.80%      1.61%
79.54%       7.43%      9.19%      3.84%       37.02%   76.34%   11.02%      9.33%      3.31%
87.31%       1.41%      5.98%      5.30%       39.83%   89.56%    1.63%      5.38%      3.43%
88.44%       7.01%      2.44%      2.11%       40.28%   80.80%   15.21%      1.79%      2.20%
88.43%       2.70%      3.58%      5.28%       40.84%   92.48%    2.83%      2.33%      2.37%
76.29%   19.76%   2.24%    1.72%   40.91%   70.03%   26.90%   1.80%    1.27%
96.82%    0.66%   1.71%    0.81%   37.00%   95.87%    1.07%   1.61%    1.44%
79.36%   16.88%   2.26%    1.50%   37.81%   69.41%   28.26%   1.33%    1.00%
58.10%   10.47%   4.94%   26.49%   37.99%   57.94%   14.95%   3.01%   24.10%
88.87%    0.79%   3.84%    6.49%   40.92%   89.59%   50.79%   3.67%    6.49%
96.44%    0.76%   2.10%    0.71%   40.74%   97.18%    0.24%   2.22%    0.36%
65.33%   22.01%   8.13%    4.53%   42.46%   67.41%   25.01%   4.74%    2.84%
82.63%    3.06%   9.58%    4.73%   41.52%   81.43%    4.97%   9.75%    3.86%
94.73%    3.52%   1.31%    0.44%   38.72%   93.92%    4.17%   1.56%    0.35%
90.35%    4.54%   2.43%    2.68%   41.67%   86.53%    7.66%   3.18%    2.63%
93.99%    0.27%   3.36%    2.38%   35.34%   89.73%    0.36%   7.38%    2.53%
nt                               Other
               Non-     Non-     Non-
              Hispanic Hispanic Hispanic
     % Female White     Black    Other   Hispanic % Female
      43.82%   69.05%   25.74%    2.29%    2.93%   34.62%
      43.22%   80.62%    3.31%   12.90%    3.16%   31.10%
      44.72%   52.35%    1.77%    4.01%   41.87%   36.09%
      47.90%   78.63%    8.68%    4.63%    8.07%   36.02%
      45.73%   38.86%    3.47%    7.22%   50.45%   38.62%
      45.13%   77.68%    2.63%    3.13%   16.56%   38.96%
      43.55%   71.80%    7.49%    4.80%   15.91%   47.49%
      46.98%   76.39%   14.84%    2.72%    6.05%   31.31%
      50.08%   33.16%   30.00%   12.19%   24.64%   59.79%
      44.64%   50.41%   14.57%    2.95%   32.07%   41.84%
      47.67%   53.31%   34.05%    3.43%    9.21%   43.17%
      45.73%   38.86%    3.47%    7.22%   50.45%   38.62%
      48.50%   74.29%    0.49%    3.19%   22.03%   32.06%
      43.31%   72.83%    9.63%    3.72%   13.82%   39.59%
      45.31%   86.71%    7.70%    1.74%    3.85%   35.61%
      47.64%   92.94%    2.22%    2.16%    2.68%   29.64%
      46.51%   81.17%    7.12%    3.24%    8.47%   36.50%
      49.39%   77.44%   10.96%    1.48%   10.12%   35.72%
      47.76%   73.56%   19.61%    3.40%    3.43%   25.15%
      44.35%   96.64%    0.17%    1.99%    1.20%   33.19%
      47.63%   59.70%   21.28%    5.91%   13.12%   50.28%
      41.25%   84.32%    3.30%    4.90%    7.48%   42.42%
      48.85%   76.46%   12.62%    2.95%    7.97%   39.99%
      47.59%   92.62%    1.83%    2.95%    2.59%   31.90%
      46.85%   57.53%   32.62%   19.64%    3.45%   34.98%
      49.18%   83.16%   10.69%    2.86%    3.29%   37.80%
      45.39%   93.30%    0.00%    3.51%    3.18%   34.33%
      45.14%   85.90%    4.64%    3.28%    6.17%   36.75%
      46.11%   61.10%    6.58%    6.97%   25.34%   34.71%
      44.10%   97.10%    0.67%    1.57%    0.67%   43.14%
      41.29%   59.49%   11.98%    5.51%   23.02%   41.95%
      44.27%   44.45%   69.00%   11.45%   43.41%   32.10%
      41.69%   60.14%   13.26%    6.99%   19.62%   48.07%
      43.83%   66.49%   19.33%    3.38%   10.80%   35.15%
      47.25%   95.14%    0.00%    2.97%    1.89%   26.06%
      45.77%   86.36%    8.56%    2.11%    2.97%   36.48%
      40.74%   80.43%    5.58%    7.57%    6.42%   39.73%
      48.99%   75.83%    0.87%    3.83%   19.47%   34.24%
      44.03%   85.38%    5.80%    1.86%    6.96%   31.66%
      41.32%   86.45%    0.85%    3.04%    9.65%   35.66%
47.08%   63.00%   29.08%   1.90%    6.02%   38.56%
34.32%   92.11%    2.32%   3.44%    2.13%   25.65%
47.73%   72.79%   21.38%   1.96%    3.88%   38.05%
43.57%   55.90%    8.81%   3.38%   31.92%   38.16%
45.53%   82.77%    0.79%   4.64%   11.79%   35.42%
44.64%   97.23%    0.00%   2.13%    0.64%   41.12%
45.14%   53.27%   24.65%   6.93%   15.15%   50.41%
46.03%   68.12%    1.75%   7.78%   22.35%   37.93%
50.45%   94.07%    3.78%   1.76%    0.38%   24.26%
45.56%   91.14%    2.53%   1.75%    4.59%   32.06%
45.39%   93.30%    0.00%   3.51%    3.18%   34.33%
 Return to Scenario
                                                                 Diabetics Receiving
Dependent Age     Dependents     Employee    Covered Lives       Intervention Benefit
<18                       231                          231                               0
18-44                     117         400              517                               6
45-64                      22          75               97                               4
65+                          7         25               32                               3
Total                     377         500              877                              13

                 Non-minority                  Minority
                    Male          Female        Male                      Female
<18                         96         87                 25                            23
18-44                     216         194                 56                            51
45-64                       40         36                 11                            10
65+                         13         12                  4                             3

  Prevalence     Non-minority                  Minority
                    Male          Female        Male                      Female
<18                       0.2%        0.3%            0.2%                          0.1%
18-44                     2.2%        2.1%            2.5%                          2.2%
45-64                     8.9%        6.8%          13.2%                          11.3%
65+                      17.6%       13.2%          22.9%                          21.1%

  w/ Diabetes          Non-minority                            Minority
                      Male        Female         Male                     Female
<18                         0            0                0                             0
18-44                       5            4                1                             1
45-64                       4            2                1                             1
65+                         2            2                1                             1

 w/o Diabetes    Non-minority                  Minority
                    Male          Female        Male                      Female
<18                         96         86                 25                            23
18-44                     211         190                 55                            50
45-64                       37         34                  9                             8
65+                         11         11                  3                             3
                                                      The National Diabetes Statistics Fact Sheet
Diagnosed with diabetes                 26    2.95%   www.cdc.gov/diabetes/pubs/pdf/ndfs_2005.p
Undiagnosed with diabetes               11    1.25%   Undiagnosed/diagnosed
No diabetes                            840   95.80%
                                       877




          Total
                      231
                      517
                       97
                       32


          Total
                       0%
                       2%
                       9%
                      17%


          Total             Employees Only
                        1              -
                       11                9
                        9                7
                        5                4
                       26

          Total
                      230
                      506
                       88
                       27
                      851
Diabetes Statistics Fact Sheet lists the total prevalence of diabetes in 2005 as 20.8 million people (14.6 million are diagnosed and 6.2 million
/diabetes/pubs/pdf/ndfs_2005.pdf
                    0.42
million are diagnosed and 6.2 million are undiagnosed). Based on these numbers 29% of the population are undiagnosed. I'm assuming th
n are undiagnosed. I'm assuming then that this is were we got 29%.
                                                                   November 2004 Median Hourly Wage ($)
  Return to Scenario

           State       State   Construction   Education Govern     Leisure and    Manufacturing
                                              and Health ment      Hospitality
                                               Services

Alabama                 AL           $13.71      $15.13   $12.47          $9.18           $11.17
Alaska                  AK           $24.96      $19.79   $13.63         $12.84           $15.11
Arizona                 AZ           $14.57      $16.50   $10.76         $10.70           $11.97
Arkansas                AR           $13.14      $14.45   $12.02          $8.98           $11.24
California              CA           $19.98      $20.75   $17.62         $12.19           $11.57
Colorado                CO           $16.97      $18.10   $17.14         $11.95           $13.28
Connecticut             CT           $21.67      $20.85   $19.14         $13.35           $15.12
Delaware                DE           $17.12      $18.74   $13.87         $11.76           $12.91
District of Columbia    DC           $19.53      $20.19   $19.22         $16.08           $18.08
Florida                 FL           $13.96      $16.63   $14.66         $10.99           $11.42
Georgia                 GA           $14.18      $16.81   $13.08         $10.87           $12.11
Hawaii                  HI           $23.28      $19.54   $14.02         $12.81           $11.52
Idaho                   ID           $14.19      $15.71   $14.29          $9.40           $11.96
Illinois                IL           $24.64      $17.31   $16.96         $11.27           $12.83
Indiana                 IN           $18.17      $15.79   $13.84         $10.09           $13.78
Iowa                    IA           $16.28      $15.15   $15.11          $9.27           $13.18
Kansas                  KS           $15.21      $15.28   $14.05          $9.54           $12.76
Kentucky                KY           $15.14      $15.74   $12.00          $9.69           $13.22
Louisiana               LA           $14.19      $15.66   $11.14          $8.75           $13.95
Maine                   ME           $15.44      $16.14   $14.06         $10.41           $13.33
Maryland                MD           $16.73      $20.02   $16.77         $12.20           $14.07
Massachusetts           MA           $21.74      $20.25   $18.32         $13.82           $14.79
Michigan                MI           $20.02      $18.57   $17.58         $12.01           $15.64
Minnesota              MN            $21.86      $18.27   $15.10         $12.25           $14.30
Mississippi             MS           $12.41      $14.31   $11.04          $9.09           $11.19
Missouri               MO            $19.13      $15.47   $13.04         $10.72           $12.35
Montana                 MT           $15.70      $14.62   $14.51          $9.01           $12.15
Nebraska                NE           $14.63      $15.74   $13.81          $9.98           $12.53
Nevada                  NV           $18.55      $19.32   $13.84         $12.15           $12.52
New Hampshire           NH           $16.23      $17.56   $15.83         $11.76           $13.81
New Jersey              NJ           $22.36      $20.33   $17.25         $12.62           $13.35
New Mexico             NM            $13.31      $16.15   $13.12          $9.87           $11.80
New York                NY           $21.29      $19.43   $18.30         $13.70           $12.99
North Carolina          NC           $13.67      $15.96   $13.33         $10.52           $12.15
North Dakota            ND           $14.87      $15.22   $14.02          $9.52           $12.80
Ohio                    OH           $18.38      $17.90   $14.90         $11.01           $14.05
Oklahoma                OK           $13.44      $14.21   $12.59          $9.68           $11.91
Oregon                  OR           $18.07      $18.43   $17.10         $11.81           $13.54
Pennsylvania            PA           $17.18      $17.37   $14.80         $10.51           $13.89
Puerto Rico             PR           $19.23      $19.04   $18.64         $12.69           $12.92
Rhode Island            RI           $13.65      $15.64   $12.72          $9.86           $12.75
South Carolina          SC           $12.82      $14.88   $13.44          $9.44           $11.52
South Dakota            SD           $13.75      $15.36   $12.24         $11.24           $12.38
Tennessee               TN           $12.64      $16.40   $14.73          $9.79           $11.73
Texas                   TX           $15.07      $15.57   $14.55         $10.90           $11.57
Utah                    UT           $15.30      $16.60   $15.22         $11.60           $12.95
Vermont                    VT            $15.39       $17.67   $15.15          $12.13              $12.69
Virginia                   VA            $20.83       $18.69   $18.79          $12.87              $14.91
Washington                WA             $15.78       $14.77   $11.26           $8.78              $12.71
West Virginia             WV             $19.31       $17.86   $15.48          $11.10              $14.22
Wisconsin                  WI            $16.29       $15.94   $14.77           $9.19              $14.26
Wyoming                   WY             $16.29       $15.94   $14.77           $9.19              $14.26
Alaska                  $ 28.46
FirmSize Key Scalar         1.00
                         Scalar
18-44                     0.900    $      25.61
45-64                     1.100    $      31.30
65+                       1.200    $      34.15

Source: US Department of Labor Bureau of Labor Statistics, May 2005 (http://www.bls.gov/oes/current/oessrcst.htm)
Median Hourly wages were not identified for government and estimate wages are provided.
No data were identified that addressed firm size scalars for the categories needed. Estimated scalars are provided.
ian Hourly Wage ($)


             Other     Professional and       Trade,           All
                           Business       Transportation,   industri
                                            and Utilities      es

               $9.61            $24.38             $11.80
              $13.25            $26.39             $16.70
               $7.65            $24.72             $12.92
               $9.58            $20.96             $11.59
               $9.09            $31.52             $14.18
               $9.36            $28.02             $14.53
              $10.70            $30.89             $15.10
              $10.61            $28.21             $13.82
              $11.25            $37.36             $15.14
               $8.16            $24.49             $12.33
               $9.06            $25.95             $12.99
              $11.08            $25.53             $13.78
               $9.50            $22.18             $12.48
              $10.50            $27.93             $14.14
              $10.13            $22.91             $13.13
               $9.99            $22.92             $12.68
               $9.98            $24.03             $12.81
               $9.23            $22.25             $12.32
               $9.49            $21.73             $11.47
              $11.49            $23.15             $12.65
               $9.91            $28.92             $13.67
              $10.88            $30.95             $15.03
              $10.30            $27.90             $14.60
              $10.77            $27.82             $14.56
               $8.85            $20.27             $11.09
               $8.86            $24.58             $12.89
               $9.75            $18.90             $12.20
               $9.58            $23.20             $12.80
              $10.97            $25.77             $13.88
              $11.04            $25.77             $13.65
              $10.52            $31.66             $14.98
               $7.24            $24.09             $12.88
              $10.56            $30.62             $14.67
               $9.31            $24.28             $12.66
               $9.46            $20.99             $12.41
              $10.10            $25.91             $13.17
               $8.66            $22.02             $11.84
              $11.42            $24.90             $13.96
               $9.85            $25.23             $13.07
              $10.48            $27.39             $13.61
               $9.25            $22.85             $11.96
               $9.30            $19.88             $11.66
               $8.96            $22.96             $12.55
               $7.62            $26.30             $12.19
               $9.07            $23.50             $13.28
              $10.32            $24.78             $12.88
                 $9.94   $29.72   $12.92
                $10.78   $29.27   $15.44
                 $9.19   $20.51   $11.04
                $10.83   $25.17   $13.65
                $10.12   $20.20   $13.84
                $10.12   $20.20   $13.84




current/oessrcst.htm)

scalars are provided.
                                                                              Diabetes Calculator For
                                                                                  ABC Company
Company Information




                                          Enter your Company Name here.                                  ABC Company
      Select your company's Primary State from the drop-down menu.                                              Alaska
            Select your company's Industry from the drop-down menu.                         Professional and business services


    Enter your company's Number of Covered Employees in each age
  category here. If you know the Turnover Rate in each age category,                       3.5
                                          you can enter that as well.

                                                                                           # of Employees
                                                                            Age    .                                 Average Hourly Wage        Default Average Hourly Wage
                                                                      18-44                              400                                    $                    25.61
                                                                      45-64                               75                                    $                    31.30
                                                                        65+                               25                                    $                    34.15
                                                                      Total                              500
Optional Information (currently set to state or regional averages)                     Your Company's Info                  Default
       Enter your company's % Employees with family coverage here.                                                                     29%
    Enter the average number of children per employee with family
                                                   coverage here.                                                                     1.97
                                         Percent minority employees                                                                    21%
                                           Percent female employees                                                                    47%
                   Employee annual turnover rate, age 18-44 (optional)                                                                 27%
                   Employee annual turnover rate, age 45-64 (optional)                                                                 17%

                     Employee annual turnover rate, age 65+ (optional)                                                                  24%
                               Average health care cost per employee                                                 $                7,671
                                                        Average HbA1C level                                                           8.49%
Number of Covered Lives With Diabetes
                                                                             Age   .   Your Company's Info            Your Company's Info       Default                       Estimated
                                                           <18                                                                         0                               1                    1
                                                         18-44                                                                         0                              11                   11
                                                         45-64                                                                         0                               9                    9
                                                           65+                                                                         0                               5                    5
      Estimated Number of Covered Lives with Diagnosed Diabetes                                                                        0                              26                   26
         Total Number of Covered Lives Without Diagnosed Diabetes                                                                                                    851                  851




            Total Number of Covered Lives with Diagnosed Diabetes                                         26

          Total Number of Covered Lives with Undiagnosed Diabetes                                         11

Annual Per Capita Health Care Expenditures



         Average annual cost of covered life for employees and dependents                        Total               Per Diabetic Population
                                                    With diagnosed diabetes                          $12,800

                                          Without diabetes or undiagnosed                                $3,900



               Total expenditures for diagnosed diabetic covered lives                                                                  $0
      Total expenditures for non-diabetic + undiagnosed covered lives                                                                   $0
                      Total expenditures directly attributable to diabetes                         $100,000                         $3,869                            100%
                            Total expenditures not attributed to diabetes                                                          ($3,869)                             0%




Impact on Costs of Reducing HbA1c Levels




HbA1c Levels for Diabetic Covered Lives                                                    Estimated Before              Estimated After        Company Info
                                                             6-7                                                 2                          9
                                                             7-8                                                10                         11
                                                             8-9                                                 5                          2
                                                            9 - 10                                               2                          3
                                                              >10                                                6                          1

Estimated per capita savings associated with a 1% point reduction in
HbA1c Levels
                                                From a level of 7% to 6%               $                    -
                                                From a level of 8% to 7%               $                        69
                                                From a level of 9% to 8%    $                 317
                                                From a level of 10% to 9%   $                 620


Disease Management Interventions (Select One)

                                                                            Average Reduction in
                                                                               Median HbA1c                                    Default
                         Diabetes Disease or Care Management
1                                                                                           1.09%                          $                25.00
                         Provider Education
                                                                                            1.10%
                         Patient Education
                                                                                          0.70%
                         Patient Reminders                                                0.60%
                         Pollypill                                                        0.87%
Or, select your own HbA1c reduction goal (new mean)                                       7.50%                                                 1
Or, select your own HbA1c reduction goal (% below specfied goal)                         65.00% at or below HbA1c of:                       7.50%



Select a goal for percent of diabetic covered lives receiving the                        50.00%
intervention you selected above.                                                             10.0

                                                                                  Medical               Productivity            Total

Cost                                                                        $               3,900                          $                3,900
Gross Savings                                                               $               2,800   $            50,900    $               53,700
Net Savings                                                                 $               (1,100) $            50,900    $               49,800
Per Participant                                                                   Medical               Productivity            Total

Cost                                                                        $                 300                          $                 300
Gross Savings                                                               $                 220   $              3,940   $                4,160
Net Savings                                                                 $                 (80) $               3,940   $                3,860
                                                                                  Medical               Productivity            Total
At current HbA1c level                                                      $           100,000     $           107,600                  $207,600
At target HbA1c level                                                       $           101,100     $            56,700                  $157,800




                  This tool was developed under the auspices of the Agency for Healthcare Research and Quality through contract number 290-04-0011,
                                              although its contents are solely the responsibility of The Lewin Group, Inc.




Does employer provide paid sick leave?                                                          1
                                                                                September 23, 2010

                     Diabetes Cost Calculator for Employers
                         Executive Summary for ACME
Current Impact and Costs of Diabetes
Of the 111,503 employees and dependents receiving medical coverage from ACME, the calculator
estimates that 1,740 are diagnosed with diabetes and 739 have undiagnosed diabetes. The estimated
annual cost attributed to diabetes for your organization is $9,617,500. This includes $2,667,500 in
direct medical expenditures and $6,950,000 in lost productivity costs.

Chart 1:

                  Covered Lives by Estimated Diabetes Status



                                   2611
                                  3%1%


                                                     Diagnosed with diabetes

                                                     Undiagnosed with diabetes

                                                     No diabetes
                            840
                           96%




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 of Patient Education for improving control of diabetes on your organization's
diabetes-related direct and indirect costs.
The best available summary of the evidence[1] found that on average, Patient Education programs
reduced median Hemoglobin A1c (HbA1c)[2] levels by 0.007 points. The calculator estimates that
a reduction of this level among covered lives with diabetes would shift the distribution of HbA1c

Chart 2:


                                              Estimated HbA1c Distribution
                                12

                                10
             # Diabetes Cases




                                    8

                                    6

                                    4

                                    2

                                -
                                        ≥10        9 to 9.9       8 to 8.9       7 to 7.9         6 to 6.9
                                                              HbA1c Level

                                                  Before Intervention        After Intervention



This reduction in average HbA1c level would lower your organization's annual health care costs by
an estimated $847,100 or $980 per person receiving the intervention. This includes $-63,500 in
medical savings from improved Patient Education, $156,600 in increased costs to implement the
intervention, and $910,600 in indirect savings due to improved productivity.[3] See Chart 3 below.
These estimates include the costs of the intervention (if entered) and are based on your projection
that 50% of covered lives with diabetes would receive the intervention.



[1] Shojania KG, Ranji SR, Shaw LK, Charo LN, Lai JC, Rushakoff RJ, McDonald KM, Owens DK. Diabetes Mellitus
Care. Vol. 2 of : Shojania KG, McDonald KM, Wachter RM, Owens DK. Closing The Quality Gap: A Critical Analysis
of Quality Improvement Strategies. @#$_n023
[2] For diabetes patients, hemoglobin A1c (HbA1c) levels indicate how successfully patients are managing their
condition with lower levels indicating greater success.
[3] 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.
Chart 3:


                      Gross Savings

           $60,000


           $50,000


           $40,000


           $30,000


           $20,000


           $10,000


               $-


                     Medical     Productivity   Total
Save                       ComboBox1
Company Information        TextBox1
Company Information        ComboBox1
Company Information        ComboBox2
Company Information        TextBox2
Company Information        TextBox3
Company Information        TextBox4
Covered Lives              TextBox5
Covered Lives              TextBox6
Covered Lives              TextBox7
Covered Lives              TextBox8
_OLD_                      _OLD_
Additional Employee Info   OptionButton7
Additional Employee Info   OptionButton8
Additional Employee Info   TextBox73
Additional Employee Info   TextBox74
Additional Employee Info   TextBox75
Goal                       CheckBox1
Goal                       CheckBox2
Interventions              OptionButton1
Interventions              OptionButton2
Interventions              OptionButton3
Interventions              OptionButton4
Goal                       OptionButton5
Goal                       OptionButton6
Interventions              ComboBox3
Interventions              ComboBox4
Interventions              ComboBox5
Interventions              ComboBox6
Interventions              ScrollBar2
Goal-Mean                  ScrollBar1
Goal-Percentile            ScrollBar3
Goal-Percentile            ScrollBar4
Diabetes Information       TextBox86
Interventions              OptionButton17
Interventions              OptionButton18
Interventions              OptionButton19
Interventions              OptionButton20
Interventions              OptionButton21
Interventions              OptionButton22
Interventions              ComboBox7
Interventions              ComboBox8
Interventions              ComboBox9
Interventions              ComboBox10
Interventions              ComboBox11
Interventions              ComboBox12
Interventions              OptionButton16
_OLD_                      _OLD_
_OLD_                      _OLD_
_OLD_                      _OLD_
_OLD_                      _OLD_
Diabetes Information       OptionButton23
Diabetes Information      OptionButton24
_OLD_ Diabetes Information_OLD_Label217
_OLD_ Diabetes InformationOptionButton25
_OLD_ Diabetes InformationOptionButton26
Diabetes Information      OptionButton27
Diabetes Information      OptionButton28
Diabetes Information      OptionButton29
Diabetes Information      OptionButton30
Diabetes Information      OptionButton31
Diabetes Information      OptionButton32
Diabetes Information      TextBox134
Diabetes Information      TextBox135
Diabetes Information      TextBox136
Diabetes Information      TextBox137
Diabetes Information      TextBox138
_OLD_ Diabetes InformationTextBox138
_OLD_ Diabetes InformationTextBox117
_OLD_ Diabetes InformationTextBox118
_OLD_ Diabetes InformationTextBox119
_OLD_ Diabetes InformationTextBox120
_OLD_ Diabetes InformationTextBox121
_OLD_ Diabetes InformationTextBox122
_OLD_ Diabetes InformationTextBox123
_OLD_ Diabetes InformationTextBox124
Diabetes Information      TextBox125
Diabetes Information      TextBox126
Diabetes Information      TextBox127
Diabetes Information      TextBox128
Diabetes Information      TextBox129
Covered Lives             TextBox30
Interventions             OptionButton33
Interventions             ComboBox13
Scenario Name                                              Example
Company Name                                               ABC Company
State                                                      Alaska
Industry                                                   Professional and business services
# Employees Age 18-44                                                    400
# Employees Age 45-64                                                     75
# Employees Age 65+                                                       25
Percent of employees selecting family medical coverage
Average Number of Children
Percent Minority Employees
Percent Female Employees
NO LONGER PART OF MODEL
Employer provides paid sick leave: YES                          TRUE
Employer provides paid sick leave: NO                           FALSE
Hourly Wage: Age 18-44
Hourly Wage: Age 45-64
Hourly Wage: Age 65+
Choose Intervention                                             TRUE
Choose Goal                                                     FALSE
Disease or Care Manangement                                     TRUE
Provider Education                                              FALSE
Patient Education                                               FALSE
Patient Reminders                                               FALSE
Reduce average HbA1c level                                      TRUE
Shift a portion of population below target HbA1c level          FALSE
Disease or Care Manangement: Average Cost                  25
Provider Education: Average Cost
Patient Education: Average Cost
Patient Reminders: Average Cost
anticipated % of diabetics participating in intervention                 50
Target average HbA1c level                                              750
target HbA1c level                                                      750
percent of covered lives to be at or below this goal                     57
average HbA1c level of the population with diabetes
Sulfonylureas                                                   FALSE
Non- Sulfonylureas Secretagogues                                FALSE
Alpha-Glucosidase Inhibitors                                    FALSE
Biguanides                                                      FALSE
Thiazolidinediones (TZDs)                                       FALSE
Nutritional Supplement                                          FALSE
Sulfonylureas: Value
Non- Sulfonylureas Secretagogues: Value
Alpha-Glucosidase Inhibitors: Value
Biguanides: Value
Thiazolidinediones (TZDs): Value
Nutritional Supplement: Value
Oral Antidiabetes Therapies                                     FALSE




Step 2a: Do you have information on HbA1c levels: YES           FALSE
Step 2a: Do you have information on HbA1c levels: NO          TRUE
NO LONGER USED: Average HbA1c levels/Distribution of levels
NO LONGER USED: Average HbA1c levels/Distribution of levels
NO LONGER USED: Average HbA1c levels/Distribution of levels
Step 1a: Yes                                                  FALSE
Step 1a: No                                                   TRUE
Step 2b: distribution of HbA1c levels                         FALSE
Step 2b: average HbA1c levels                                 TRUE
Step 1b: total                                                TRUE
Step 1b: distribution                                         FALSE
Step 1b: age < 18
Step 1b: age 18 - 44
Step 1b: age 45 - 64
Step 1b: age 64+
Step 1b: total
HbA1c level by Age Group: Age 64+: HbA1c 8-9
HbA1c level by Age Group: Age <18: HbA1c 9-10
HbA1c level by Age Group: Age 18 - 44: HbA1c 9-10
HbA1c level by Age Group: Age 45 -64: HbA1c 9-10
HbA1c level by Age Group: Age 64+: HbA1c 9-10
HbA1c level by Age Group: Age <18: HbA1c 10+
HbA1c level by Age Group: Age 18 - 44: HbA1c 10+
HbA1c level by Age Group: Age 45 -64: HbA1c 10+
HbA1c level by Age Group: Age 64+: HbA1c 10+
HbA1c level: 6-7
HbA1c level: 7-8
HbA1c level: 8-9
HbA1c level: 9-10
HbA1c level: 10+
Number of covered children
Polypill                                                      FALSE
Polypill
ssional and business services
 Return to Scenario
Graph 1
                               Covered Lives by Age Group


                                                    32
                                       97
                                                   4%             231
                                      11%
                                                                 26%




                                            517
                                           59%
                                    <18         18-44    45-64      65+
Graph 2
                      Covered Lives by Estimated Diabetes Status


                                           26 11
                                          3% 1%




                                                                        Diagnosed with diabetes

                                                                        Undiagnosed with diabetes

                                                                        No diabetes


                                    840
                                   96%




Graph 3               Medical Cost of Diabetes as Percent of Total Health Care
                                           Expenditures

                                           $0
                                           0%
                                                                                      Total expenditures directly
                                                                                      attributable to diabetes


                                                                                      Total expenditures not
                                                                                      attributed to diabetes


                                                     $100,000
                                                      100%




Graph 4
                                                Estimated HbA1c Distribution
                                 12
             # Diabetes Cases




                                 10
                                  8
                                  6
                                  4
                                  2
                                 -
                                          ≥10         9 to 9.9         8 to 8.9       7 to 7.9         6 to 6.9
                                                                 HbA1c Level
                                                         Before Intervention      After Intervention




Graph 5
                                       Relationship between HbA1c and Productive Capacity

                                120%

                                100%
          Productive Capacity




                                80%

                                60%

                                40%

                                20%

                                 0%
                                  0%
                                          ≥10       9 to 9.9     8 to 8.9    7 to 7.9   6 to 6.9

                                                          HbA1c Level



Graph 6
                                    Relationship between HbA1c and Absenteeism

                                 4.0%


                                 3.0%
          Absentee Rate




                                 2.0%


                                 1.0%


                                 0.0%
                                           ≥10      9 to 9.9      8 to 8.9   7 to 7.9   6 to 6.9
                                                               HbA1c Level




Graph 7
                                        Relationship between HbA1c and Employment Retention


                                 100%
          Employment Retention




                                 80%


                                 60%


                                 40%


                                 20%


                                  0%
                                          ≥10       9 to 9.9      8 to 8.9   7 to 7.9    6 to 6.9
                                                               HbA1c Level
Graph 8
                                       Relationship between HbA1c and Medical Cost per Year


                                   $5,500
           Medical Cost per Year



                                   $5,000


                                   $4,500


                                   $4,000


                                   $3,500


                                   $3,000
                                                ≥10         9 to 9.9      8 to 8.9     7 to 7.9   6 to 6.9
                                                                       HbA1c Level




Graph 9
                                      Medical and Productivity Costs Attributed to Diabetes


                                               $20,500 , 10%




                                                                       $100,000 ,
                                                                         48%
                                                      $87,100 ,
                                                        42%




                                                  Medical      Productivity     Absenteeism




Graph 10
                                            Costs Attributed to Diabetes per Participant
                                            $790
                                           , 10%


                                                   $3,869 , 48%
                                   $3,370 , 42%




                             Medical       Productivity         Absenteeism




Graph 11   Age Distribution of Covered Lives

                            32
                    97     4%
                   11%

                                  231
                                 26%                    <18
                                                        18-44
                                                        45-64
                                                        65+

                          517
                         59%




           Covered Lives by Estimated Diabetes Status
Graph 12



                                    26       Diagnosed with
                                   3%        diabetes
                                   11        Undiagnosed with
            840                    1%        diabetes
           96%                               No diabetes




Graph 13
             Intervention Costs and Benefits per Participant
                    Intervention Costs and Benefits per Participant

            $4,500
            $4,000
            $3,500
            $3,000
            $2,500
            $2,000
            $1,500
            $1,000
             $500
               $-
             $(500)          Cost           Gross Savings               Net Savings
           $(1,000)

                                       Medical   Productivity   Total
Graph 14
                         Total Intervention Costs and Benefits

           $60,000

           $50,000

           $40,000

           $30,000

           $20,000

           $10,000

                $-
                              Cost           Gross Savings              Net Savings
           $(10,000)

                                       Medical   Productivity   Total
Graph 15
                           Annual Costs Attributed to Diabetes

           $250,000

           $200,000
           $200,000

           $150,000

           $100,000

            $50,000

                   $-
                        Medical             Productivity                  Total

                             At current HbA1c level      At target HbA1c level

Graph 16
                        Gross Savings per Participant

           $4,500
           $4,000
           $3,500
           $3,000
           $2,500
           $2,000
           $1,500
           $1,000
            $500
              $-

                                               Medical        Productivity        Total

Graph 17
                                  Gross Savings

           $60,000

           $50,000

           $40,000

           $30,000
           $30,000

           $20,000

           $10,000

               $-

                                              Medical     Productivity      Total

Graph 18
                      Annual Costs Attributed to Diabetes

           $250,000

           $200,000

           $150,000

           $100,000

            $50,000

                $-
                       Medical             Productivity             Total

                           At Current HbA1c Level   At Target HbA1c Level
th diabetes

with diabetes
ditures directly



ditures not




    6 to 6.9
  6 to 6.9




Retention
Total
Total
                    Key                              Col1                            Col2
Construction                                                    1                                       1
Manufacturing                                                   6                                       7
Professional and business services                             11                                      13
Leisure and hospitality                                        16                                      19
Education and health services                                  21                                      25
Trade, transportation, and utilities                           26                                      31
Government                                                     31                                      37
Other                                                          36                                      43

Non-Hispanic White                                              1
Non-Hispanic Black                                              2
Non-Hispanic Other                                              3
Hispanic                                                        4


                FirmSizeKey                  % w/ family coverage                  Rounding
0                                                                4                                         -3
10                                                               5                                         -3
25                                                               6                                         -3
100                                                              7                                         -4
1000                                                             8                                         -4

Discount Rate                                                  6%


Construction
Manufacturing
Professional and business services
Leisure and hospitality
Education and health services
Trade, transportation, and utilities
Government
Other
All Industries




Average Monthly Cost Per Participant        Intervention
                                        0                       1    Diabetes Disease or Care Management
                                        5                       2    Provider Education
                                       10                       3    Patient Education
                                       15                       4    Patient Reminder
                                       20                      11    the Polypill
                                       25
                                       30
                                       35
 40
 45            Sentences for generating Word reports:
 50            The best available summary of the evidence[1] found tha
 55            Evidence from Archimedes,[1] a mathematical simulatio
 60
 65            Footnotes for generating Word reports:
 70   part 1   Shojania KG, Ranji SR, Shaw LK, Charo LN, Lai JC, Rushak
 75   part 2   Technical Review 9 (Contract No. 290-02-0017 to the St
 80
 85   part 1   Eddy D. Estimates of the effect of Metformin 1000 mg o
 90   part 2
 95
100
Col3
      3
      7
      9
      6
      4
     10
      5
      8




Wage
Scalar
 0.850
 0.850
 0.850
 1.000
 1.150




 1.09%
 1.10%
 0.70%
 0.60%
 0.87%
the evidence[1] found that on average, Diabetes Disease or Care Management programs reduced median Hemoglobin A1c (HbA1c)[2] lev
a mathematical simulation model, indicated that the polypill could reduce Hemoglobin A1c (HbA1c) [2] levels by 0.87%.


, Charo LN, Lai JC, Rushakoff RJ, McDonald KM, Owens DK. Diabetes Mellitus Care. Vol. 2 of : Shojania KG, McDonald KM, Wachter RM, Owens D
No. 290-02-0017 to the Stanford University-UCSF Evidence-based Practice Center). AHRQ Publication No. 04-0051-2. Rockville, MD: Agenc

t of Metformin 1000 mg on HbA1c levels in a representative sample of people age 8-80 with diabetes in the US. Provided by Archimedes, Inc
an Hemoglobin A1c (HbA1c)[2] levels by 0.0109 points.
els by 0.87%.


cDonald KM, Wachter RM, Owens DK. Closing The Quality Gap: A Critical Analysis of Quality Improvement Strategies.
o. 04-0051-2. Rockville, MD: Agency for Healthcare Research and Quality. September 2004.

e US. Provided by Archimedes, Inc., San Francisco, CA; 2006.

								
To top