Spreadsheet: louise_kitchen__22823__SSMB Benefit Estimates For NETCO
Sheet: Enron Rate Chart

 |  |  | MEDICAL PLANS |  |  |  |  | Dental Plans |  | Vision Plan |  | AD&D |  |  | LIFE INSURANCE |  |  |  |  | LTD | LTD | LTD | LTD |  |  | EMPLOYEE COSTS
 | [NAME] |  | Cigna Network PPA | United Health Care Network | United Health Care EPO | Cigna $1,250 Deductible |  | Enron Dental Plan |  | VSP |  | AD&D Per $1,000 of Coverage | AD&D Per $1,000 of Coverage |  | Employee Life Insurance Per $1,000 | Spouse Life Insurance Per $1,000 | Dependent Life Insurance |  |  | LTD Monthly Premium | LTD Monthly Premium | LTD Monthly Premium | LTD Monthly Premium |  |  | Flex Dollars | Items 2, 5, 6, 7, 9, 14 | Items 2, 5, 6, 8, 9, 10, 11, 15 | Annual Cost | Benefit Cost as a Percentage of Salary
 | EO |  | Employee Only-EO |  |  |  |  | EO |  | EO |  | EO | EF |  | EE | SP | DEP |  |  | 40% | 50% | 65% | 75% |  |  |  |  |  | Column AC
 |  |  |  |  |  |  |  |  |  |  |  | 1000 |  |  | 0.07 | 0.07
 | Item |  | 1 | 2 | 3 | 4 |  | 5 |  | 6 |  | 7 | 8 |  | 9 | 10 | 11 |  |  | 12 | 13 | 14 | 15 |  |  | Monthly | Monthly | Monthly
24000 | <25,000 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
25000 | $25,000-$39,999 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
40000 | $40,000-$59,999 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
60000 | $60,000-$79,999 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
80000 | $80,000-$99,999 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
100000 | $100,000-$149,000 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
150000 | $150,000-$199,000 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
200000 | $200,000-$299,999 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
300000 | $300,000-$499,999 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
500000 | >500,000 |  | 198.95 | 207.23 | 188.92 | 112.94 |  | 34.03 |  | 8.76 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -328.58
 | ES |  | Employee & Spouse/Domestic Partner-ES |  |  |  |  | ES |  | ES |  | EO | EF |  | EE | SP | DEP |  |  | 40% | 50% | 65% | 75%
24000 | <25,000 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
25000 | $25,000-$39,999 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
40000 | $40,000-$59,999 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
60000 | $60,000-$79,999 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
80000 | $80,000-$99,999 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
100000 | $100,000-$149,000 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
150000 | $150,000-$199,000 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
200000 | $200,000-$299,999 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
300000 | $300,000-$499,999 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
500000 | >500,000 |  | 373.55 | 381.78 | 349.49 | 208.94 |  | 59.05 |  | 13.74 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -391.91
 | EC |  | Employee & Children-EC |  |  |  |  | EC |  | EC |  | EO | EF |  | EE | SP | DEP |  |  | 40% | 50% | 65% | 75%
24000 | <25,000 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
25000 | $25,000-$39,999 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
40000 | $40,000-$59,999 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
60000 | $60,000-$79,999 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
80000 | $80,000-$99,999 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
100000 | $100,000-$149,000 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
150000 | $150,000-$199,000 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
200000 | $200,000-$299,999 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
300000 | $300,000-$499,999 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
500000 | >500,000 |  | 322.16 | 330.44 | 302.27 | 180.7 |  | 47.34 |  | 14.03 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -365.33
 | EF |  | Employee & Family-EF |  |  |  |  | EF |  | Family |  | EO | EF |  | EE | SP | DEP |  |  | 40% | 50% | 65% | 75%
24000 | <25,000 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
25000 | $25,000-$39,999 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
40000 | $40,000-$59,999 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
60000 | $60,000-$79,999 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
80000 | $80,000-$99,999 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
100000 | $100,000-$149,000 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
150000 | $150,000-$199,000 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
200000 | $200,000-$299,999 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
300000 | $300,000-$499,999 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
500000 | >500,000 |  | 486.43 | 494.71 | 453.4 | 271.05 |  | 76.07 |  | 22.62 |  |  |  |  |  |  | 0.42 |  |  |  |  |  |  |  |  | -440.66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVG