RAW BUDGET DATA - FY 2018 QTR 3

Communications and Public Information Expense Categories
GENERAL FUND BUDGET STABILIZATION RESERVE FUND BUDGET EXPENDITURES
MISCELLANEOUS
Miscellaneous
Services-interpretation $0.00 $1,362.50
Services-other $122,300.00 $15,205.30
Services-translators $0.00 $9,229.89
  $122,300.00 $25,797.69
SUPPORT SERVICES FUND BUDGET EXPENDITURES
COMMUNICATIONS
Community Engagement
Administrative leave $0.00 $2,717.38
Advertising/publication $1,500.00 $246.76
Bilingual Pay $1,800.00 $1,454.04
Books-library $200.00 $0.00
Clothing/clothing material $1,500.00 $0.00
Comp time used $0.00 $2,796.19
Consultant-others $15,000.00 $29,100.00
Contribution to employees ret $109,108.00 $60,646.41
Educational travel $3,300.00 $425.09
Exception vacation $0.00 $319.68
FICA tax $38,108.00 $23,209.78
Food/Ice $2,400.00 $4,237.20
Holiday pay $0.00 $13,964.19
Holidays worked $0.00 $1,265.23
Insurance-health/life/dental $103,320.00 $56,790.00
Insurance-temporary employees $0.00 $3,050.20
Interdepartmental Charges $0.00 $100.00
Jury leave $0.00 $244.68
Medicare tax $8,915.00 $5,428.09
Memberships $1,200.00 $1,625.00
Mileage reimbursements $0.00 $110.21
Office supplies $1,859.00 $1,125.70
Personal holiday pay $0.00 $3,232.50
Phone allowance $2,700.00 $1,599.30
Photographic $1,000.00 $0.00
Postage $200.00 $0.00
Printing/binding/photo/repr $1,400.00 $0.00
Priority mail/parcel services $200.00 $0.00
Regular wages - full-time $606,156.00 $294,559.35
Rental-other equipment $400.00 $0.00
Seminar/training fees $3,900.00 $1,107.07
Services-other $15,900.00 $19,500.00
Services-survey $9,635.00 $0.00
Services-translators $80,000.00 $0.00
Sick pay $0.00 $2,771.82
Small tools/minor equipment $1,700.00 $0.00
Software $525.00 $10,264.54
Stability pay $4,000.00 $1,500.00
Subscriptions $5,670.00 $360.00
Temporary employees $0.00 $41,400.00
Vacation pay $0.00 $17,334.78
  $1,021,596.00 $602,485.19
Media Relations
Administrative leave $0.00 $1,540.12
Advertising/publication $1,000.00 $0.00
Bad weather pay $0.00 $294.96
Books-library $300.00 $0.00
Comp time used $0.00 $8,598.64
Contribution to employees ret $39,662.00 $33,338.70
Educational travel $2,850.00 $0.00
FICA tax $14,541.00 $11,531.45
Food/Ice $500.00 $0.00
Holiday pay $0.00 $8,485.16
Holidays worked $0.00 $347.12
Insurance-health/life/dental $44,280.00 $33,705.00
Maintenance-computer software $3,200.00 $0.00
Medicare tax $3,401.00 $2,696.87
Memberships $1,360.00 $0.00
Mileage reimbursements $0.00 $113.00
Office supplies $500.00 $0.00
Overtime $0.00 $27.06
Personal holiday pay $0.00 $2,259.04
Phone allowance $2,100.00 $1,696.59
Photographic $200.00 $0.00
Postage $100.00 $0.00
Printing/binding/photo/repr $200.00 $0.00
Priority mail/parcel services $100.00 $0.00
Regular wages - full-time $220,349.00 $157,609.44
Rental-other equipment $380.00 $0.00
Seminar/training fees $0.00 $360.00
Services-Software as a Service $0.00 $24,807.60
Services-other $2,733.00 $2,436.00
Services-survey $0.00 $74.00
Sick pay $0.00 $1,719.00
Subscriptions $2,088.00 $110.00
Telephone-base cost $1,000.00 $284.02
Telephone-long distance $250.00 $37.71
Temporary employees $12,076.00 $5,414.31
Vacation pay $0.00 $4,774.35
  $353,170.00 $302,260.14
SUPPORT SERVICES
Departmental Support Services
Administrative leave $0.00 $2,184.05
Awards and Recognition $1,560.00 $793.21
Bad weather pay $0.00 $317.16
Bilingual Pay $0.00 $415.44
Books-library $100.00 $0.00
Comp time used $0.00 $1,586.93
Contribution to employees ret $55,769.00 $50,101.32
Educational travel $1,000.00 $1,813.30
Employee recruiting $0.00 $316.68
FICA tax $18,021.00 $15,708.28
Food/Ice $500.00 $283.23
Holiday pay $0.00 $12,732.16
Insurance-health/life/dental $44,280.00 $36,330.00
Interdepartmental Charges $500.00 $350.40
Jury leave $0.00 $52.86
Medicare tax $4,572.00 $3,891.64
Memberships $775.00 $245.00
Mileage reimbursements $500.00 $0.00
Office supplies $1,792.00 $1,431.14
Parental Leave $0.00 $4,757.42
Personal holiday pay $0.00 $4,067.36
Personnel savings ($71,156.00) $0.00
Phone allowance $2,520.00 $2,111.89
Postage $0.00 $2.04
Printing/binding/photo/repr $700.00 $0.00
Priority mail/parcel services $100.00 $0.00
Regular wages - full-time $309,826.00 $222,425.19
Rental-copy machines $17,162.00 $2,981.04
Rental-real estate-office $125,106.00 $79,591.22
Seminar/training fees $2,500.00 $356.00
Services-other $108,967.00 $78,409.36
Sick pay $0.00 $8,702.39
Small tools/minor equipment $0.00 $248.45
Software $1,500.00 $0.00
Stability pay $3,000.00 $2,500.00
Subscriptions $1,425.00 $1,520.88
Travel City Business $200.00 $176.44
Vacation pay $0.00 $21,720.89
  $631,219.00 $558,123.37
TRANSFERS AND OTHER REQUIREMENTS
Other Requirements
Accrued Payroll $7,711.00 $0.00
Insurance-health/life/dental ($23,400.00) $0.00
Personnel savings $23,400.00 $0.00
  $7,711.00 $0.00
Transfers
CTM Support $112,272.00 $112,272.00
Liability Reserve $1,000.00 $1,000.00
  $113,272.00 $113,272.00
VIDEO PRODUCTION SERVICES
Video Production Services
Administrative leave $0.00 $1,401.80
Bad weather pay $0.00 $1,537.46
Comp time used $0.00 $2,758.78
Contribution to employees ret $87,385.00 $69,973.32
Educational travel $3,800.00 $2,992.84
Educational/promotional $1,550.00 $10.00
Emergency leave $0.00 $206.00
Expense refunds $0.00 ($2,700.00)
FICA tax $34,910.00 $27,336.83
Fleet-equip.preventative maint $4,033.00 $5,166.04
Holiday pay $0.00 $18,791.84
Insurance-health/life/dental $103,320.00 $78,645.00
Interdepartmental reimbursements ($187,797.00) ($150,997.76)
Jury leave $0.00 $266.96
Maintenance-computer hardware $500.00 $0.00
Maintenance-computer software $2,000.00 $0.00
Medicare tax $8,166.00 $6,393.29
Memberships $1,800.00 $2,736.90
Office supplies $550.00 $227.45
Overtime $8,000.00 $234.66
Personal holiday pay $0.00 $3,585.18
Phone allowance $4,500.00 $3,619.57
Priority mail/parcel services $200.00 $463.28
Regular wages - full-time $485,467.00 $291,517.77
Rental-other equipment $300.00 $0.00
Seminar/training fees $2,400.00 $2,050.00
Services-other $154,175.00 $34,701.60
Services-translators $141,640.00 $12,956.39
Sick pay $0.00 $42,650.32
Small tools/minor equipment $21,046.00 $6,400.19
Software $1,320.00 $9.00
Stability pay $6,500.00 $6,500.00
Subscriptions $1,500.00 $583.60
Telephone-base cost $1,000.00 $361.17
Telephone-long distance $75.00 $80.83
Temporary employees $66,616.00 $57,480.19
Toll Road - Tx Tag $0.00 $48.36
Transportation-city veh fuel $1,872.00 $505.00
Travel City Business $500.00 $0.00
Vacation pay $0.00 $26,024.69
  $957,328.00 $554,518.55
WEB DEVELOPMENT
Web Development
Administrative leave $0.00 $2,406.85
Bad weather pay $0.00 $1,826.16
Books-library $100.00 $0.00
Comp time used $0.00 $999.45
Contribution to employees ret $77,524.00 $63,712.51
Educational travel $2,380.00 $0.00
Emergency leave $0.00 $255.36
FICA tax $27,796.00 $25,777.70
Food/Ice $0.00 $509.87
Holiday pay $0.00 $16,503.80
Holidays worked $0.00 $135.46
Insurance-health/life/dental $88,560.00 $67,410.00
Interdepartmental reimbursements $0.00 ($79,173.97)
Medicare tax $6,501.00 $6,028.64
Memberships $800.00 $0.00
Minor computer hardware $500.00 $407.99
Office supplies $700.00 $671.37
Overtime $0.00 $756.98
Personal holiday pay $0.00 $3,135.36
Phone allowance $3,540.00 $2,859.99
Photographic $500.00 $0.00
Printing/binding/photo/repr $4,000.00 $220.00
Regular wages - full-time $430,684.00 $300,176.18
Rental-copy machines $11,200.00 $1,292.07
Rental-other equipment $150.00 $0.00
Seminar/training fees $2,700.00 $0.00
Services-other $14,600.00 $7,159.17
Sick pay $0.00 $11,789.74
Small tools/minor equipment $1,400.00 $1,531.11
Software $5,600.00 $0.00
Stability pay $2,000.00 $2,000.00
Subscriptions $1,173.00 $41.60
Temporary employees $12,076.00 $66,604.02
Travel City Business $200.00 $0.00
Vacation pay $0.00 $15,551.52
  $694,684.00 $520,588.93
TOTALS $3,901,280.00 $2,677,045.87

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.