RAW BUDGET DATA - FY 2024 QTR 2

Location
DEPARTMENT:
Human Resources
Human Resources Expense Categories
EMPLOYEE BENEFITS FUND BUDGET EXPENDITURES
EMPLOYEE DENTAL
Employee Dental
Dental claims $12,242,835.00 $6,235,082.15
Services-benefits management $301,518.00 $184,719.90
  $12,544,353.00 $6,419,802.05
EMPLOYEE MEDICAL
Employee CDHP
CDHP Contribution $1,774,750.00 $2,018,880.00
Expense refunds ($2,698,011.00) ($2,138,907.49)
Medical Claims $17,780,315.00 $12,476,538.60
Prescription plan $3,354,353.00 $3,133,033.60
Services-benefits management $1,398,846.00 $1,003,880.37
Stop loss fee-health insura $1,070,856.00 $679,764.90
  $22,681,109.00 $17,173,189.98
Employee HMO
Expense refunds ($1,399,097.00) ($861,780.06)
Medical Claims $16,168,499.00 $7,991,875.90
Prescription plan $5,523,489.00 $2,553,101.62
Services-benefits management $686,560.00 $402,724.36
Stop loss fee-health insura $525,118.00 $272,292.60
  $21,504,569.00 $10,358,214.42
Employee PPO
Expense refunds ($11,569,321.00) ($7,615,341.85)
Medical Claims $113,971,740.00 $48,625,320.47
Prescription plan $40,564,166.00 $19,743,505.98
Services-benefits management $6,085,118.00 $3,550,908.30
Stop loss fee-health insura $4,658,469.00 $3,196,225.30
Third party admn costs to dist $0.00 ($1,400.00)
  $153,710,172.00 $67,499,218.20
FULLY FUNDED BY CITY - EMPLOYEE/RETIREE
Fully Funded by City - Employee/Retiree
Child care program costs $1,005,683.00 $170,493.34
Employee bus passes $200,000.00 $134,501.39
Life insurance premiums $770,034.00 $357,918.07
Miscellaneous expense $500,000.00 $419,425.00
Services-Wellness Program $0.00 $32,925.00
Services-employee assistance $243,866.00 $159,250.00
Short-term disability premiums $564,690.00 $268,105.21
Wellness prgrm- Workers comp medical $1,955,195.00 $608,672.25
  $5,239,468.00 $2,151,290.26
OPTIONAL COVERAGE PAID BY EMPLOYEE
Optional Coverage paid by Employee
Long-term disability premiums $2,067,681.00 $925,449.76
Services-legal fees benefit $865,001.00 $532,853.02
Supplemental life ins premiums $5,573,951.00 $2,953,442.54
Vision Program Services $872,784.00 $538,588.84
  $9,379,417.00 $4,950,334.16
OPTIONAL COVERAGE PAID BY RETIREE
Optional Coverage paid by Retiree
Dental HMO Premiums $140,907.00 $73,853.13
Dental claims $0.00 $1,517,898.02
Other health premiums $3,174,604.00 $0.00
Services-benefits management $0.00 $67,735.00
Vision Program Services $337,965.00 $209,243.62
  $3,653,476.00 $1,868,729.77
RETIREE MEDICAL
Retiree With Medicare Advantage
Medicare Advantage Premiums $0.00 $943,865.60
  $0.00 $943,865.60
Retiree With Medicare CDHP
CDHP Contribution $0.00 $9,524.17
Expense refunds ($18,597.00) ($20,310.42)
Medical Claims $30,924.00 $28,547.25
Prescription plan $46,292.00 $62,054.68
Services-benefits management $13,629.00 $9,784.99
Stop loss fee-health insura $10,221.00 $6,595.62
  $82,469.00 $96,196.29
Retiree With Medicare HMO
Expense refunds ($325,996.00) ($383,660.44)
Medical Claims $1,249,575.00 $1,208,876.14
Prescription plan $1,720,539.00 $1,993,204.39
Services-benefits management $188,001.00 $182,437.91
Stop loss fee-health insura $138,217.00 $123,135.98
  $2,970,336.00 $3,123,993.98
Retiree With Medicare PPO
Expense refunds ($1,551,213.00) ($1,714,070.40)
Medical Claims $10,792,346.00 $7,043,575.44
Prescription plan $11,783,152.00 $10,846,913.87
Services-benefits management $982,104.00 $820,151.04
Stop loss fee-health insura $725,938.00 $553,192.44
  $22,732,327.00 $17,549,762.39
Retiree Without Medicare CDHP
CDHP Contribution $0.00 $45,461.35
Expense refunds ($93,273.00) ($82,628.47)
Medical Claims $535,855.00 $286,385.35
Prescription plan $226,733.00 $196,334.36
Services-benefits management $49,629.00 $37,898.21
Stop loss fee-health insura $38,003.00 $25,659.94
  $756,947.00 $509,110.74
Retiree Without Medicare HMO
Expense refunds ($403,032.00) ($233,008.58)
Medical Claims $5,348,850.00 $2,048,737.89
Prescription plan $2,563,493.00 $1,052,542.33
Services-benefits management $193,263.00 $108,777.30
Stop loss fee-health insura $147,817.00 $73,550.48
  $7,850,391.00 $3,050,599.42
Retiree Without Medicare PPO
Expense refunds ($2,573,647.00) ($1,599,499.12)
Medical Claims $40,271,994.00 $15,926,738.12
Prescription plan $16,593,290.00 $6,108,835.23
Services-benefits management $1,369,827.00 $749,172.61
Stop loss fee-health insura $1,048,807.00 $506,449.26
  $56,710,271.00 $21,691,696.10
SUPPORT SERVICES
Departmental Support Services
Administrative Support $1,956,516.00 $978,258.00
Consultant-benefits/compensat $400,000.00 $230,416.69
Federal unemployment tax co $300,000.00 $148,313.92
Interdepartmental Charges $744,757.00 $300,655.30
Printing/binding/photo/repr $125,000.00 $20,979.63
Services-benefits management $623,566.00 $61,153.48
Services-medical/surgical $7,500.00 $2,477.85
  $4,157,339.00 $1,742,254.87
GENERAL FUND BUDGET EXPENDITURES
MISCELLANEOUS
Miscellaneous
Training-city wide $465,000.00 $193,666.29
  $465,000.00 $193,666.29
SUPPORT SERVICES FUND BUDGET EXPENDITURES
HUMAN RESOURCES MANAGEMENT SERVICES
Community Services
Contribution to employees ret $20,510.00 $12,787.91
FICA tax $10,466.00 $5,741.36
Food/Ice $500.00 $0.00
Holiday pay $0.00 $5,273.44
Insurance-health/life/dental $29,812.00 $16,148.08
Medicare tax $2,448.00 $1,342.75
Office supplies $550.00 $0.00
Personal holiday pay $0.00 $1,725.76
Phone allowance $1,140.00 $614.04
Regular wages - full-time $165,161.00 $79,591.84
Seminar/training fees $900.00 $0.00
Services-other $0.00 ($880.00)
Services-sign language $25,000.00 $10,781.00
Sick pay $0.00 $2,379.04
Small tools/minor equipment $1,000.00 $0.00
Stability pay $2,500.00 $2,500.00
Vacation pay $0.00 $3,580.32
  $259,987.00 $141,585.54
Employee and Labor Relations
Administrative leave $0.00 $8,101.58
Awards and Recognition $373.00 $158.86
Backcharged salary & fringes $144,497.00 $0.00
Bilingual Pay $0.00 $276.96
Books-library $500.00 $0.00
Comp time used $0.00 $13,005.62
Contribution to employees ret $559,052.00 $322,887.55
Educational travel $4,550.00 $565.10
Emergency leave $0.00 $4,495.30
FICA tax $286,931.00 $157,087.53
Food/Ice $24,300.00 $4,490.50
Holiday pay $0.00 $130,854.04
Holidays worked $0.00 $814.05
Insurance-health/life/dental $782,565.00 $404,944.16
Insurance-temporary employees $0.00 $5,837.94
Jury leave $0.00 $140.60
Maintenance-computer hardware $3,000.00 $1,948.00
Medicare tax $67,343.00 $37,135.95
Memberships $2,750.00 $349.00
Mileage reimbursements $1,555.00 $0.00
Minor computer hardware $250.00 $0.00
Office supplies $4,000.00 $519.65
Overtime $0.00 $3,107.64
Personal holiday pay $0.00 $23,464.77
Personnel savings ($86,806.00) $0.00
Phone allowance $9,180.00 $5,407.36
Printing/binding/photo/repr $53,500.00 $0.00
Professional registration $250.00 $0.00
Regular wages - full-time $4,501,974.00 $1,945,484.92
Regular wages - part-time $106,061.00 $0.00
Rental-copy machines $3,880.00 $0.00
Rental-real estate-office $104,125.00 $52,062.00
Seminar/training fees $3,993.00 $3,320.66
Services-legal fees $175,000.00 $16,750.50
Services-other $60,000.00 $29,806.00
Sick pay $0.00 $103,280.54
Small tools/minor equipment $2,450.00 $0.00
Software $250.00 $0.00
Stability pay $27,100.00 $24,600.00
Subscriptions $1,560.00 $431.58
Temporary employees $0.00 $117,452.81
Terminal pay $0.00 $13,285.95
Travel City Business $8,650.00 $0.00
Vacation pay $0.00 $119,071.92
  $6,852,833.00 $3,551,139.04
Risk Management
Administrative leave $0.00 $2,903.78
Bilingual Pay $1,800.00 $969.36
Bond/Theft/Prof Liab Insurance $55,000.00 $35,487.88
Books-library $500.00 $564.00
Consultant-others $0.00 $1,000.00
Contribution to employees ret $123,178.00 $73,789.26
Educational travel $0.00 $878.45
FICA tax $62,372.00 $35,977.20
Fire/Extend Coverage Insurance $2,520,390.00 $2,084,378.99
Government permits and fees $0.00 $6,855.00
Holiday pay $0.00 $30,831.68
Insurance-health/life/dental $149,060.00 $79,498.24
Interdepartmental reimbursements ($409,883.00) ($276,154.42)
Medicare tax $14,587.00 $8,414.02
Memberships $0.00 $230.00
Mileage reimbursements $3,900.00 $307.74
Minor computer hardware $500.00 $0.00
Office supplies $500.00 $249.90
Overtime $0.00 $2.35
Personal holiday pay $0.00 $6,261.40
Phone allowance $1,560.00 $840.28
Regular wages - full-time $991,935.00 $430,959.12
Reimbursement of CIP charge ($200,000.00) $0.00
Safety equipment $0.00 $654.58
Seminar/training fees $4,000.00 $965.00
Sick pay $0.00 $27,817.85
Stability pay $10,700.00 $10,700.00
Subscriptions $0.00 $1,712.56
Temporary employees $0.00 $45,159.62
Vacation pay $0.00 $32,310.66
  $3,330,099.00 $2,643,564.50
Total Rewards
Administrative leave $0.00 $3,685.45
Awards and Recognition $0.00 $100.00
Bilingual Pay $5,400.00 $2,908.08
Comp time used $0.00 $2,016.69
Consultant-benefits/compensat $15,000.00 $0.00
Contribution to employees ret $269,828.00 $150,335.82
Educational travel $500.00 $703.92
Educational/promotional $0.00 $4,600.00
Emergency leave $0.00 $1,046.16
FICA tax $138,648.00 $69,089.04
Food/Ice $1,100.00 $0.00
Holiday pay $0.00 $61,798.84
Insurance-health/life/dental $372,650.00 $183,218.60
Insurance-temporary employees $0.00 $2,053.74
Interdepartmental reimbursements ($1,253,260.00) ($510,295.77)
Jury leave $0.00 $633.92
Medicare tax $32,430.00 $16,157.92
Mileage reimbursements $1,200.00 $65.50
Office supplies $2,200.00 $121.50
Overtime $0.00 $1,424.13
Personal holiday pay $0.00 $16,010.10
Phone allowance $3,120.00 $1,680.56
Printing/binding/photo/repr $18,740.00 $0.00
Regular wages - full-time $2,172,881.00 $924,465.44
Seminar/training fees $7,800.00 $0.00
Services-other $10,000.00 $36,242.20
Sick pay $0.00 $34,703.12
Small tools/minor equipment $1,000.00 $0.00
Stability pay $12,800.00 $10,800.00
Temporary employees $42,000.00 $29,966.56
Terminal pay $0.00 $18,471.38
Vacation pay $0.00 $40,169.93
  $1,854,037.00 $1,102,172.83
Workforce Planning and Support
Administrative leave $0.00 $12,517.80
Advertising/publication $65,000.00 $22,486.26
Awards and Recognition $0.00 ($135.00)
Bilingual Pay $3,600.00 $2,001.04
Books-library $1,200.00 $13,328.70
Comp time used $0.00 $2,407.68
Contribution to employees ret $485,475.00 $269,981.06
Educational travel $4,200.00 $1,140.65
Educational/promotional $37,400.00 $9,576.30
Electric services $30,000.00 $0.00
Emergency leave $0.00 $3,971.04
Employee recruiting $10,500.00 $88,918.21
Expense refunds $0.00 ($35,131.00)
FICA tax $252,582.00 $126,768.89
Food/Ice $14,600.00 $5,804.77
Garbage/refuse collection $1,000.00 $0.00
Holiday pay $0.00 $110,789.09
Holidays worked $0.00 $1,239.11
Insurance-health/life/dental $655,864.00 $321,719.44
Insurance-temporary employees $0.00 $2,396.03
Jury leave $0.00 $777.84
Maintenance-buildings $20,000.00 $0.00
Maintenance-computer software $88,919.00 $0.00
Maintenance-office equipmen $1,000.00 $0.00
Medicare tax $59,071.00 $29,647.50
Memberships $1,950.00 $200.00
Mileage reimbursements $3,200.00 $202.65
Minor computer hardware $32,500.00 $0.00
Office furnishings $10,000.00 $0.00
Office supplies $10,500.00 $9,723.02
Overtime $0.00 $1,345.71
Personal holiday pay $0.00 $20,113.24
Phone allowance $8,520.00 $5,923.44
Photographic $660.00 $0.00
Printing/binding/photo/repr $5,500.00 $8.10
Regular wages - full-time $3,909,455.00 $1,601,972.09
Rental-real estate-office $1,441,498.00 $452,380.61
Seminar/training fees $20,500.00 $12,936.28
Services-Credit Card Fees $0.00 $3.50
Services-Prepared Food and Catering $0.00 $1,796.58
Services-Software as a Service $29,950.00 $13,390.00
Services-investigations $72,000.00 $22,666.95
Services-other $105,500.00 $3,568.20
Services-translators $0.00 $880.00
Sick pay $0.00 $83,417.62
Small tools/minor equipment $11,400.00 $0.00
Software $500.00 $0.00
Stability pay $32,400.00 $28,900.00
Subscriptions $113,000.00 $108,961.50
Telephone-base cost $1,000.00 $0.00
Temporary employees $120,000.00 $89,767.67
Terminal pay $0.00 $47,163.95
Vacation pay $0.00 $110,637.69
Wastewater service $3,533.00 $0.00
Water service $20,000.00 $0.00
  $7,683,977.00 $3,606,164.21
SUPPORT SERVICES
Departmental Support Services
Accident pay $0.00 $7,744.46
Administrative leave $0.00 $4,210.48
Allowances/other pay $973,129.00 $0.00
Awards and Recognition $7,150.00 $2,153.59
Books-library $3,000.00 $0.00
Comp time used $0.00 $441.45
Computer supplies $12,000.00 $30.87
Consultant-others $20,000.00 $0.00
Contribution to employees ret $191,060.00 $99,249.44
Educational travel $1,390.00 $11,694.89
Educational/promotional $2,000.00 $4,180.23
Emergency leave $0.00 $1,224.60
Exception vacation $0.00 $359.37
Exp Reimb - Public Information Requests $0.00 ($702.38)
FICA tax $117,126.00 $45,811.59
Food/Ice $66,500.00 $11,660.52
Holiday pay $0.00 $41,787.23
Holidays worked $0.00 $839.59
Insurance-health/life/dental $208,684.00 $101,857.12
Interdepartmental reimbursements ($251,816.00) ($112,723.68)
Interdeptl-other $4,384.00 $0.00
Jury leave $0.00 $365.51
Maintenance-buildings $90,000.00 $2,810.00
Maintenance-computer hardware $2,500.00 $0.00
Maintenance-computer software $15,000.00 $0.00
Maintenance-other equipment $1,000.00 $0.00
Medicare tax $28,138.00 $11,164.10
Memberships $10,250.00 $1,734.90
Mileage reimbursements $1,000.00 $0.00
Minor computer hardware $46,868.00 $0.00
Office furnishings $83,100.00 $1,818.82
Office supplies $38,711.00 $1,139.44
Personal holiday pay $0.00 $5,446.88
Personnel savings ($1,459,815.00) $0.00
Phone allowance $9,720.00 $4,556.44
Postage $12,840.00 $0.00
Printing/binding/photo/repr $16,000.00 $1,228.13
Professional registration $2,946.00 $229.00
Regular wages - full-time $1,538,577.00 $620,777.26
Rental-copy machines $60,000.00 $0.00
Rental-office equipment $3,374.00 $231.00
Rental-real estate-office $239,914.00 $105,223.50
Seminar/training fees $15,000.00 $5,448.27
Services-Software as a Service $0.00 $143.97
Services-internet/cable $4,480.00 $2,112.54
Services-interpretation $0.00 $86.30
Services-legal fees $0.00 $15,592.50
Services-other $34,446.00 $8,055.60
Sick pay $0.00 $19,299.04
Small tools/minor equipment $7,000.00 $354.00
Software $30,000.00 $4,567.00
Stability pay $8,900.00 $7,600.00
Subscriptions $5,000.00 $3,075.62
Telephone-base cost $5,002.00 $709.23
Telephone-cellular phones $6,000.00 $2,049.58
Telephone-long distance $3,000.00 $0.00
Temporary employees $383,278.00 $48,732.47
Terminal pay $50,000.00 $0.00
Vacation pay $0.00 $32,006.42
  $2,646,836.00 $1,126,376.89
TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS
Other Requirements
Accrued Payroll $60,888.00 $0.00
Compensation Adjustment $527.00 $0.00
Contribution to employees ret $985,636.00 $344,972.67
  $1,047,051.00 $344,972.67
Transfers
CTM Support $2,124,585.00 $1,062,292.50
Liability Reserve $26,000.00 $26,000.00
  $2,150,585.00 $1,088,292.50
WORKERS' COMPENSATION FUND BUDGET EXPENDITURES
COURT AND LEGAL FEES
Court and Legal Fees
Miscellaneous expense $714,763.00 $382,180.81
Services-legal fees $252,513.00 $73,680.36
  $967,276.00 $455,861.17
INDEMNITY PAYMENTS
Indemnity Payments
Payments to survivors $959,331.00 $368,861.91
WC terminal payments $140,325.00 $98,808.38
Weekly payments $7,655,265.00 $2,340,119.96
  $8,754,921.00 $2,807,790.25
INTERDEPARTMENTAL AND EXPENSE REFUNDS
Expense Refunds
Interdepartmental reimbursements ($7,655,265.00) ($2,260,154.43)
Subrogation ($100,000.00) ($103,046.96)
  ($7,755,265.00) ($2,363,201.39)
MEDICAL EXPENSES AND CLAIMS RESERVE
Medical Expenses and Claims Reserve
Claims accrual - FSD only $333,356.00 ($891,866.00)
Drugs $748,233.00 $196,490.07
Medical/dental supplies $1,385,210.00 $360,683.89
Services-chiropractic $772,353.00 $584,634.08
Services-hospital inpatient $372,591.00 $59,438.16
Services-hospital outpatient $927,381.00 $254,046.37
Services-medical/surgical $4,062,417.00 $1,477,646.71
Services-physical therapy $1,032,467.00 $446,270.68
Third party admn costs to dist $0.00 $1,648,584.51
Wellness prgrm- Workers comp medical $38,490.00 $22,376.02
  $9,672,498.00 $4,158,304.49
OPERATIONS AND ADMINISTRATION
Operations and Administration
Administrative Support $1,391,569.00 $695,784.48
Interdepartmental Charges $540,438.00 $239,705.97
Services-actuary $1,985,939.00 $1,049,718.81
Services-auditing $80,000.00 $0.00
Training-city wide $30,000.00 $0.00
  $4,027,946.00 $1,985,209.26
SETTLEMENTS AND IMPAIRMENTS
Settlements and Impairments
Weekly payments $1,369,327.00 $491,308.66
  $1,369,327.00 $491,308.66
TOTALS $367,299,752.00 $180,461,465.14

The comparison of actual expenditures to budget may appear inconsistent. That is because base wages for personnel are fully budgeted in the expense categories regular wages:full-time, regular wages:part-time, or regular wages:civil service. The budget does not assume expenditure levels for the various leave categories, such as sick pay, vacation pay, or jury leave. However, actual expenses for various leave categories are recorded based on timesheet coding. The result is that actual expenditures for regular wages are spread across multiple expense categories while the budget is shown in one expense category.

Personnel savings is budgeted to account for the likely savings in personnel costs generated through attrition. However, the savings is realized in the expense categories regular wages:full-time, regular wages:part-time and regular wages:civil service. Therefore, the actual expenditures in the personnel savings expense category will always be zero.

The data contained on this website is for informational purposes only. Certain Austin Energy budget items have been excluded as competitive matters under Texas Government Code Section 552.133 and City Council Resolution 20051201-002.