USER FRIENDLY BUDGET SECTION - HEALTH BENEFITS
On narrow screens, each worksheet row is shown as a labeled card.
| Current Year # of Covered Members (Medical & Rx) |
Current Year Annual Cost Estimate per Employee |
Total Current Year Cost |
Prior Year # of Covered Members (Medical & Rx) |
Prior Year Annual Cost per Employee (Average) |
Total Prior Year Cost |
|
|---|---|---|---|---|---|---|
| Active Employees - Health Benefits - Annual Cost | ||||||
| Single Coverage | 18.00 | $13,694.07 | $246,493.26 | 20.00 | $11,969.28 | $239,385.60 |
| Parent & Child | 4.00 | $25,864.32 | $103,457.28 | 3.00 | $21,425.04 | $64,275.12 |
| Employee & Spouse (or Partner) | 10.00 | $27,328.85 | $273,288.50 | 8.00 | $23,938.56 | $191,508.48 |
| Family | 22.00 | $39,554.09 | $870,189.98 | 21.00 | $33,394.32 | $701,280.72 |
| Employee Cost Sharing Contribution (enter as negative - ) | ($325,726.47) | ($283,725.35) | ||||
| Subtotal | 54.00 | $1,167,702.55 | 52.00 | $912,724.57 | ||
| Elected Officials - Health Benefits - Annual Cost | ||||||
| Single Coverage | $0.00 | $0.00 | ||||
| Parent & Child | $0.00 | $0.00 | ||||
| Employee & Spouse (or Partner) | 1 | $25,226.64 | $25,226.64 | 1 | $23,938.56 | $23,938.56 |
| Family | $0.00 | $0.00 | ||||
| Employee Cost Sharing Contribution (enter as negative - ) | ($598.46) | ($598.46) | ||||
| Subtotal | 1.00 | $24,628.18 | 1.00 | $23,340.10 | ||
| Retirees - Health Benefits - Annual Cost | ||||||
| Single Coverage | $0.00 | 1 | $3,663.40 | $3,663.40 | ||
| Parent & Child | $0.00 | $0.00 | ||||
| Employee & Spouse (or Partner) | $0.00 | $0.00 | ||||
| Family | $0.00 | $0.00 | ||||
| Employee Cost Sharing Contribution (enter as negative - ) | ||||||
| Subtotal | 0.00 | $0.00 | 1.00 | $3,663.40 | ||
| GRAND TOTAL | 55.00 | $1,192,330.73 | 54.00 | $939,728.07 |
Note - other health insurances such as dental and vision are not included in this analysis unless included in the employees total premium. Therefore, the total from this sheet may not agree with the budgeted appropriation.
Is medical coverage provided by the SHBP (Yes or No)?
YES
Is prescription drug coverage provided by the SHBP (Yes or No)?
YES