RAW BUDGET DATA - FY 2021 QTR 4

Location
DEPARTMENT:
Human Resources
Human Resources Expense Categories
EMPLOYEE BENEFITS FUND BUDGET EXPENDITURES
EMPLOYEE DENTAL
Employee Dental
Dental claims $12,748,962.00 $12,388,337.09
Services-benefits management $453,697.00 $332,606.40
  $13,202,659.00 $12,720,943.49
EMPLOYEE MEDICAL
Employee CDHP
CDHP Contribution $0.00 $1,838,587.50
Expense refunds ($325,574.00) ($1,673,448.99)
Health Care Reform Fees & Taxes $0.00 $9,950.79
Medical Claims $12,846,712.00 $13,331,295.13
Prescription plan $1,491,252.00 $1,941,561.80
Services-benefits management $1,134,266.00 $1,188,156.71
Stop loss fee-health insura $772,680.00 $710,861.10
  $15,919,336.00 $17,346,964.04
Employee HMO
Expense refunds ($988,333.00) ($1,073,876.53)
Health Care Reform Fees & Taxes $0.00 $10,835.38
Medical Claims $16,659,061.00 $15,769,648.91
Prescription plan $4,526,947.00 $4,678,138.47
Services-benefits management $832,918.00 $764,969.39
Stop loss fee-health insura $566,887.00 $456,258.53
  $21,597,480.00 $20,605,974.15
Employee PPO
Expense refunds ($6,695,772.00) ($7,696,902.57)
Health Care Reform Fees & Taxes $0.00 $58,357.74
Medical Claims $101,502,274.00 $89,657,459.39
Prescription plan $30,669,209.00 $30,968,555.73
Services-benefits management $5,560,077.00 $5,442,475.68
Stop loss fee-health insura $3,787,600.00 $3,253,418.26
  $134,823,388.00 $121,683,364.23
FULLY FUNDED BY CITY - EMPLOYEE/RETIREE
Fully Funded by City - Employee/Retiree
Child care program costs $1,000,000.00 $491,754.90
Employee bus passes $522,500.00 $75,166.00
Life insurance premiums $1,233,415.00 $770,146.01
Miscellaneous expense $600,000.00 $266,947.50
Services-Wellness Program $0.00 $41,525.00
Services-employee assistance $251,304.00 $252,595.20
Services-medical pmts to Brack $2,650,008.00 $435,087.57
Short-term disability premiums $615,074.00 $607,963.35
  $6,872,301.00 $2,941,185.53
OPTIONAL COVERAGE PAID BY EMPLOYEE
Optional Coverage paid by Employee
Long-term disability premiums $1,866,208.00 $1,873,335.22
Services-legal fees benefit $808,148.00 $804,870.34
Supplemental life ins premiums $5,083,732.00 $5,165,614.22
Vision Program Services $914,617.00 $919,359.06
  $8,672,705.00 $8,763,178.84
OPTIONAL COVERAGE PAID BY RETIREE
Optional Coverage paid by Retiree
Dental HMO Premiums $163,788.00 $155,911.83
Dental claims $0.00 $1,809,255.93
Other health premiums $2,276,253.00 $587,209.62
Services-benefits management $0.00 $73,516.70
Vision Program Services $300,250.00 $321,877.02
  $2,740,291.00 $2,947,771.10
RETIREE MEDICAL
Retiree With Medicare CDHP
CDHP Contribution $0.00 $16,763.23
Expense refunds ($13,686.00) ($19,299.42)
Medical Claims $202,261.00 $47,387.52
Prescription plan $62,688.00 $56,288.74
Services-benefits management $13,553.00 $13,748.70
Stop loss fee-health insura $9,224.00 $8,245.78
  $274,040.00 $123,134.55
Retiree With Medicare HMO
Expense refunds ($665,321.00) ($480,583.33)
Medical Claims $1,901,089.00 $2,326,938.49
Prescription plan $3,047,426.00 $3,047,172.21
Services-benefits management $356,884.00 $343,861.06
Stop loss fee-health insura $242,897.00 $205,245.61
  $4,882,975.00 $5,442,634.04
Retiree With Medicare PPO
Expense refunds ($3,650,643.00) ($1,932,147.33)
Medical Claims $9,732,900.00 $9,143,539.38
Prescription plan $16,721,349.00 $16,660,504.21
Services-benefits management $1,395,349.00 $1,379,639.61
Stop loss fee-health insura $949,679.00 $825,336.31
  $25,148,634.00 $26,076,872.18
Retiree Without Medicare CDHP
CDHP Contribution $0.00 $37,935.06
Expense refunds ($18,610.00) ($54,507.85)
Medical Claims $517,745.00 $322,742.82
Prescription plan $85,239.00 $95,868.14
Services-benefits management $38,399.00 $38,921.92
Stop loss fee-health insura $26,134.00 $23,283.53
  $648,907.00 $464,243.62
Retiree Without Medicare HMO
Expense refunds ($401,410.00) ($289,137.26)
Medical Claims $5,430,164.00 $5,056,456.54
Prescription plan $1,838,612.00 $1,982,302.27
Services-benefits management $210,629.00 $206,785.79
Stop loss fee-health insura $143,354.00 $123,489.00
  $7,221,349.00 $7,079,896.34
Retiree Without Medicare PPO
Expense refunds ($2,175,256.00) ($1,638,987.37)
Medical Claims $28,320,868.00 $28,201,967.74
Prescription plan $9,963,511.00 $10,695,877.46
Services-benefits management $1,153,662.00 $1,170,419.02
Stop loss fee-health insura $785,186.00 $700,103.81
  $38,047,971.00 $39,129,380.66
SUPPORT SERVICES
Departmental Support Services
Administrative Support $1,956,516.00 $1,956,516.00
Consultant-benefits/compensat $820,000.00 $440,745.35
Federal unemployment tax co $260,000.00 $309,489.02
Interdepartmental Charges $569,966.00 $630,157.82
Printing/binding/photo/repr $125,000.00 $14,337.42
Services-benefits management $583,830.00 $592,559.36
Services-medical/surgical $7,500.00 $4,512.74
  $4,322,812.00 $3,948,317.71
GENERAL FUND BUDGET EXPENDITURES
MISCELLANEOUS
Miscellaneous
Training-city wide $465,000.00 $307,085.86
  $465,000.00 $307,085.86
SUPPORT SERVICES FUND BUDGET EXPENDITURES
CIVIL RIGHTS
Civil Rights
Electric services $0.00 $4,995.27
  $0.00 $4,995.27
HUMAN RESOURCES MANAGEMENT SERVICES
Community Services
Bad weather pay $0.00 $2,296.32
Contribution to employees ret $26,866.00 $27,957.70
Emergency leave $0.00 $1,046.88
FICA tax $9,372.00 $9,060.86
Food/Ice $500.00 $0.00
Grant cost-support of other $46,223.00 $46,223.00
Holiday pay $0.00 $6,888.96
Insurance-health/life/dental $29,520.00 $29,520.00
Medicare tax $2,193.00 $2,119.08
Office supplies $550.00 $0.00
Personal holiday pay $0.00 $959.64
Phone allowance $420.00 $420.16
Professional registration $0.00 $380.00
Regular wages - full-time $149,255.00 $128,626.01
Seminar/training fees $900.00 $0.00
Services-other $36,203.00 $18,608.50
Sick pay $0.00 $4,187.52
Small tools/minor equipment $1,000.00 $0.00
Stability pay $1,500.00 $1,500.00
Vacation pay $0.00 $5,248.44
  $304,502.00 $285,043.07
Employee and Labor Relations
Administrative leave $0.00 $5,307.31
Awards and Recognition $0.00 $30.00
Bad weather pay $0.00 $14,913.16
Books-library $650.00 $0.00
Comp time used $0.00 $5,483.07
Contribution to employees ret $343,678.00 $241,658.52
Emergency leave $0.00 $353.28
Exception vacation $0.00 $1,075.06
FICA tax $119,200.00 $83,445.40
Food/Ice $4,300.00 $719.06
Holiday pay $0.00 $60,489.05
Holidays worked $0.00 $586.96
Insurance-health/life/dental $324,720.00 $324,720.00
Interdepartmental Charges $2,357,848.00 $2,260,866.78
Maintenance-computer hardware $750.00 $2,724.00
Medicare tax $27,877.00 $19,515.57
Memberships $0.00 $219.00
Mileage reimbursements $1,555.00 $154.56
Minor computer hardware $0.00 $49.99
Office supplies $2,200.00 $1,580.52
Other paid leave $0.00 $7,236.81
Personal holiday pay $0.00 $11,366.66
Phone allowance $3,780.00 $4,090.00
Printing/binding/photo/repr $53,500.00 $0.00
Professional registration $250.00 $0.00
Regular wages - full-time $1,909,330.00 $1,095,382.03
Seminar/training fees $10,200.00 $1,114.10
Services-legal fees $174,000.00 $0.00
Sick pay $0.00 $25,603.18
Small tools/minor equipment $1,050.00 $0.00
Stability pay $9,500.00 $10,000.00
Temporary employees $0.00 $81,131.50
Terminal pay $0.00 $1,505.86
Vacation pay $0.00 $59,285.75
  $5,344,388.00 $4,320,607.18
Risk Management
Administrative leave $0.00 $6,145.28
Bad weather pay $0.00 $11,832.78
Bilingual Pay $1,800.00 $1,800.24
Bond/Theft/Prof Liab Insurance $25,000.00 $14,005.45
Books-library $500.00 $0.00
Clothing/clothing material $0.00 $327.57
Contribution to employees ret $144,649.00 $157,460.12
Emergency leave $0.00 $986.40
FICA tax $50,410.00 $52,246.67
Fire/Extend Coverage Insurance $1,646,784.00 $1,676,352.28
Holiday pay $0.00 $37,446.48
Insurance-health/life/dental $132,840.00 $132,840.00
Interdepartmental reimbursements ($323,961.00) ($490,951.50)
Medicare tax $11,789.00 $12,218.84
Memberships $0.00 $255.00
Mileage reimbursements $3,900.00 $0.00
Minor computer hardware $500.00 $0.00
Office supplies $500.00 $486.22
Personal holiday pay $0.00 $6,448.24
Phone allowance $1,140.00 $1,314.00
Regular wages - full-time $803,589.00 $733,520.69
Reimbursement of CIP charge ($150,000.00) ($128,082.11)
Seminar/training fees $4,000.00 $1,793.49
Services-other $60,000.00 $29,074.00
Sick pay $0.00 $11,837.73
Stability pay $6,500.00 $6,500.00
Temporary employees $0.00 $768.00
Vacation pay $0.00 $35,228.85
  $2,419,940.00 $2,311,854.72
Total Rewards
Administrative leave $0.00 $5,872.03
Bad weather pay $0.00 $26,742.42
Books-library $2,600.00 $0.00
Comp time used $0.00 $3,681.42
Contribution to employees ret $364,279.00 $306,390.69
Educational travel $500.00 $0.00
Educational/promotional $900.00 $550.00
Emergency leave $0.00 $2,875.28
Exception vacation $0.00 $317.92
FICA tax $126,135.00 $106,657.14
Food/Ice $500.00 $0.00
Holiday pay $0.00 $74,710.78
Holidays worked $0.00 $317.92
Insurance-health/life/dental $369,000.00 $369,000.00
Interdepartmental reimbursements ($1,011,590.00) ($868,821.36)
Medicare tax $29,500.00 $24,944.00
Mileage reimbursements $1,000.00 $0.00
Office supplies $2,200.00 $2,024.18
Other paid leave $0.00 $3,178.00
Overtime $0.00 $425.51
Personal holiday pay $0.00 $12,595.74
Phone allowance $2,700.00 $3,873.42
Printing/binding/photo/repr $18,740.00 $31,800.00
Priority mail/parcel services $200.00 $0.00
Regular wages - full-time $2,023,770.00 $1,424,926.20
Seminar/training fees $7,800.00 $4,334.00
Services-other $50,000.00 $37,925.50
Sick pay $0.00 $29,558.30
Small tools/minor equipment $1,000.00 $0.00
Stability pay $8,000.00 $6,500.00
Temporary employees $0.00 $100,887.65
Terminal pay $0.00 $8,606.48
Vacation pay $0.00 $64,478.61
  $1,997,234.00 $1,784,351.83
Workforce Planning and Support
Administrative leave $0.00 $15,620.37
Advertising/publication $20,000.00 $20,999.01
Awards and Recognition $0.00 $30.00
Bad weather pay $0.00 $39,751.30
Bilingual Pay $1,800.00 $2,007.96
Books-library $1,200.00 $575.72
Comp time used $0.00 $1,809.09
Contribution to employees ret $527,741.00 $501,167.15
Educational travel $400.00 $0.00
Educational/promotional $12,400.00 $11,732.95
Electric services $66,550.00 $12,104.27
Emergency leave $0.00 $4,020.18
Employee recruiting $2,500.00 $17,825.00
Exception vacation $0.00 $202.29
Expense refunds $0.00 ($15,150.00)
FICA tax $184,320.00 $171,753.20
Food/Ice $8,100.00 $107.61
Garbage/refuse collection $1,359.00 $408.00
Holiday pay $0.00 $123,232.08
Holidays worked $0.00 $448.39
Identification $20,000.00 $0.00
Insurance-health/life/dental $531,360.00 $531,360.00
Insurance-temporary employees $0.00 $11,440.62
Maintenance-buildings $0.00 $4,119.26
Maintenance-computer software $57,000.00 $72,636.68
Maintenance-office equipmen $1,000.00 $0.00
Medicare tax $43,110.00 $40,168.14
Memberships $500.00 $1,929.00
Mileage reimbursements $2,706.00 $0.00
Minor computer hardware $46,500.00 $1,537.65
Office furnishings $18,728.00 $599.96
Office supplies $8,203.00 $11,339.38
Other paid leave $0.00 $11,862.40
Overtime $0.00 $1,431.68
Personal holiday pay $0.00 $21,359.15
Phone allowance $9,780.00 $8,665.99
Photographic $660.00 $0.00
Printing/binding/photo/repr $500.00 $1,090.26
Regular wages - full-time $2,931,865.00 $2,206,804.76
Rental-real estate-office $1,240,471.00 $1,345,781.21
Seminar/training fees $17,600.00 $1,508.88
Services-Credit Card Fees $0.00 $336.32
Services-IT Installations $0.00 $2,374.65
Services-Software as a Service $14,950.00 $20,670.00
Services-internet/cable $0.00 $281.31
Services-investigations $60,000.00 $30,472.42
Services-other $70,000.00 $2,809.61
Sick pay $0.00 $71,988.50
Small tools/minor equipment $13,900.00 $0.00
Stability pay $29,500.00 $30,500.00
Telephone-base cost $10,000.00 $0.00
Temporary employees $0.00 $160,994.11
Terminal pay $0.00 $34,045.97
Vacation pay $0.00 $155,748.23
Wastewater service $3,533.00 $231.12
Water service $10,600.00 $14,429.39
  $5,968,836.00 $5,707,161.22
SUPPORT SERVICES
Departmental Support Services
Administrative leave $0.00 $3,225.02
Advertising/publication $0.00 $116.82
Allowances/other pay $403,793.00 $0.00
Awards and Recognition $7,150.00 $2,994.10
Bad weather pay $0.00 $17,858.57
Books-library $3,000.00 $0.00
Call back time $0.00 $900.00
Comp time used $0.00 $455.11
Computer supplies $12,000.00 $0.00
Consultant-others $20,000.00 $91.38
Contribution to employees ret $238,732.00 $215,446.57
Educational travel $1,390.00 ($487.67)
Educational/promotional $2,000.00 $750.00
Emergency leave $0.00 $1,701.60
Employee recruiting $0.00 $475.00
Exception vacation $0.00 $289.56
Exp Reimb - Public Information Requests $0.00 ($891.00)
FICA tax $96,470.00 $75,704.55
Food/Ice $61,500.00 $6,270.96
Holiday pay $0.00 $52,871.72
Insurance-health/life/dental $191,880.00 $191,880.00
Insurance-temporary employees $7,971.00 $664.26
Interdepartmental reimbursements ($220,934.00) ($551,704.69)
Interdept-Services Electrical $0.00 $8,689.52
Interdeptl-other $4,384.00 $0.00
Jury leave $0.00 $113.13
Maintenance-buildings $80,000.00 $21,149.21
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 $23,871.00 $18,758.35
Memberships $10,250.00 $3,950.00
Mileage reimbursements $1,000.00 $0.00
Minor computer hardware $16,160.00 $21,538.99
Office furnishings $65,000.00 $26,784.14
Office supplies $44,496.00 $5,968.24
Overtime $0.00 $188.67
Personal holiday pay $0.00 $8,319.04
Personnel savings ($1,241,090.00) $0.00
Phone allowance $8,100.00 $8,102.38
Postage $12,840.00 $7,774.35
Printing/binding/photo/repr $25,930.00 $5,201.93
Priority mail/parcel services $0.00 $11.00
Professional registration $2,000.00 $2,244.00
Regular wages - full-time $1,326,292.00 $992,373.51
Rental-copy machines $60,000.00 $62,501.30
Rental-office equipment $3,374.00 $396.00
Rental-real estate-office $292,574.00 $316,857.92
Seminar/training fees $15,000.00 $3,008.67
Services-internet/cable $4,480.00 $6,500.44
Services-other $25,440.00 $55,091.13
Sick pay $0.00 $5,999.27
Small tools/minor equipment $7,500.00 $1,512.09
Software $30,000.00 $13,959.35
Stability pay $7,948.00 $7,000.00
Subscriptions $5,000.00 $2,895.41
Telephone-base cost $5,002.00 $3,351.06
Telephone-cellular phones $6,000.00 $9,212.53
Telephone-long distance $3,000.00 $5,123.39
Temporary employees $303,848.00 $158,462.40
Terminal pay $50,000.00 $9.12
Vacation pay $0.00 $73,159.18
  $2,041,851.00 $1,874,817.58
TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS
Other Requirements
Accrued Payroll $79,800.00 $79,800.00
Insurance-health/life/dental ($236,898.00) ($236,898.00)
Personnel savings $236,898.00 $0.00
  $79,800.00 ($157,098.00)
Transfers
CTM Support $2,379,171.00 $2,379,171.00
Liability Reserve $18,000.00 $18,000.00
  $2,397,171.00 $2,397,171.00
WORKERS' COMPENSATION FUND BUDGET EXPENDITURES
COURT AND LEGAL FEES
Court and Legal Fees
Miscellaneous expense $24,000.00 $196,825.72
Services-court costs $3,000.00 $0.00
Services-legal fees $4,500.00 $0.00
  $31,500.00 $196,825.72
INDEMNITY PAYMENTS
Indemnity Payments
Payments to survivors $683,050.00 $532,226.44
WC terminal payments $348,055.00 $159,197.05
Weekly payments $2,307,560.00 $3,835,397.99
  $3,338,665.00 $4,526,821.48
INTERDEPARTMENTAL AND EXPENSE REFUNDS
Expense Refunds
Interdepartmental reimbursements ($2,307,560.00) ($3,683,207.95)
Subrogation ($75,000.00) ($233,369.05)
  ($2,382,560.00) ($3,916,577.00)
MEDICAL EXPENSES AND CLAIMS RESERVE
Medical Expenses and Claims Reserve
Claims accrual - FSD only $1,304,740.00 $3,146,039.00
Drugs $631,797.00 $399,952.50
Expense refunds $0.00 $3,960.00
Medical/dental supplies $491,669.00 $990,786.60
Services-chiropractic $292,172.00 $265,441.00
Services-hospital inpatient $523,823.00 $143,246.10
Services-hospital outpatient $1,496,325.00 $866,721.41
Services-medical pmts to Brack $67,881.00 $41,641.98
Services-medical/surgical $2,625,414.00 $2,093,291.96
Services-physical therapy $798,774.00 $682,101.87
Third party admn costs to dist $0.00 ($0.01)
  $8,232,595.00 $8,633,182.41
OPERATIONS AND ADMINISTRATION
Operations and Administration
Administrative Support $1,391,569.00 $1,391,569.00
Interdepartmental Charges $460,127.00 $518,332.25
Services-actuary $1,280,237.00 $1,321,143.42
Services-auditing $60,500.00 $4,500.00
Services-medical/surgical $463,125.00 $154,916.95
Training-city wide $30,000.00 $0.00
  $3,685,558.00 $3,390,461.62
SETTLEMENTS AND IMPAIRMENTS
Settlements and Impairments
Weekly payments $1,276,882.00 $917,633.33
  $1,276,882.00 $917,633.33
TOTALS $319,576,210.00 $301,858,197.77

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.