RAW BUDGET DATA - FY 2018 QTR 3

Telecommunications and Regulatory Affairs Expense Categories
AUSTIN CABLE ACCESS FUND BUDGET EXPENDITURES
MISCELLANEOUS
Miscellaneous
Computer Software $7,000.00 $0.00
Maintenance-computer software $0.00 $6,000.00
Other Equipment $1,455,000.00 $401,462.26
Services-other $475,000.00 $457,196.81
Small tools/minor equipment $0.00 $18,244.82
  $1,937,000.00 $882,903.89
GENERAL FUND BUDGET STABILIZATION RESERVE FUND BUDGET EXPENDITURES
MISCELLANEOUS
Miscellaneous
FICA tax $5,759.00 $0.00
Medicare tax $1,347.00 $0.00
Temporary employees $92,894.00 $0.00
  $100,000.00 $0.00
SUPPORT SERVICES FUND BUDGET EXPENDITURES
TELCOMMUNICATIONS AND REGULATORY AFFAIRS
Digital Inclusion
Administrative leave $0.00 $1,256.60
Bad weather pay $0.00 $548.70
Bilingual Pay $0.00 $272.13
Contribution to employees ret $57,030.00 $44,109.41
Emergency leave $0.00 $783.72
Expense refunds ($6,420.00) ($5,407.99)
FICA tax $20,134.00 $14,883.98
Holiday pay $0.00 $11,318.33
Insurance-health/life/dental $66,420.00 $47,968.10
Interdepartmental reimbursements ($175,000.00) ($131,260.00)
Medicare tax $4,709.00 $3,480.95
Minor computer hardware $0.00 $12,564.00
Office furnishings $0.00 $1,335.00
Personal holiday pay $0.00 $2,752.64
Phone allowance $420.00 $339.36
Regular wages - full-time $316,834.00 $208,663.87
Rental-vehicles/buses $0.00 $32.00
Services-other $410,069.00 $86,776.68
Sick pay $0.00 $7,992.05
Stability pay $1,750.00 $1,000.00
Telephone-base cost $6,360.00 $4,868.82
Telephone-long distance $60.00 $0.00
Temporary employees $5,740.00 $0.00
Vacation pay $0.00 $3,947.77
  $708,106.00 $318,226.12
Regulatory Affairs
Administrative leave $0.00 $6,259.57
Advertising/publication $1,000.00 $0.00
Awards and Recognition $975.00 $482.26
Bad weather pay $0.00 $772.38
Bilingual Pay $0.00 $904.95
Bond/Theft/Prof Liab Insurance $150.00 $91.00
Car Sharing Programs $500.00 $0.00
Consultant-others $54,094.00 $6,975.00
Contribution to employees ret $138,414.00 $105,064.95
Educational travel $8,000.00 $4,650.97
Educational/promotional $0.00 $689.16
Emergency leave $0.00 $854.55
Expense refunds $0.00 ($3,616.30)
FICA tax $53,248.00 $36,205.92
Food/Ice $500.00 $164.53
Holiday pay $0.00 $26,887.60
Insurance-health/life/dental $154,980.00 $109,321.90
Interdepartmental reimbursements ($48,442.00) ($36,322.00)
Jury leave $0.00 $247.04
Maintenance-computer software $6,100.00 $5,800.00
Medicare tax $12,711.00 $8,626.22
Memberships $1,650.00 $1,520.00
Mileage reimbursements $1,500.00 $509.07
Military leave $0.00 $1,539.44
Minor computer hardware $1,000.00 $3,714.41
Office furnishings $2,050.00 $545.00
Office supplies $4,430.00 $972.28
Overtime $0.00 $531.15
Parental Leave $0.00 $7,596.00
Parking costs $0.00 $46.00
Personal holiday pay $0.00 $5,088.74
Phone allowance $1,140.00 $921.06
Postage $2,830.00 $537.42
Printing/binding/photo/repr $2,578.00 $124.50
Priority mail/parcel services $150.00 $6.70
Professional registration $100.00 $58.25
Regular wages - full-time $768,966.00 $488,995.06
Rental-copy machines $5,297.00 $2,783.78
Rental-vehicles/buses $0.00 $214.40
Seminar/training fees $8,000.00 $3,300.88
Services-Prepared Food and Catering $1,500.00 $441.77
Services-legal fees $8,120.00 $1,425.00
Services-other $2,409.00 $893.39
Sick pay $0.00 $14,124.79
Small tools/minor equipment $1,622.00 $374.57
Software $3,328.00 $3,562.92
Stability pay $8,250.00 $6,996.32
Subscriptions $468.00 $246.11
Telephone-base cost $1,500.00 $397.44
Telephone-long distance $250.00 $51.24
Temporary employees $97,998.00 $28,381.30
Vacation pay $0.00 $31,325.16
  $1,307,366.00 $881,283.85
TRANSFERS AND OTHER REQUIREMENTS
Other Requirements
Accrued Payroll $3,940.00 $0.00
Insurance-health/life/dental ($13,500.00) $0.00
Personnel savings $13,500.00 $0.00
  $3,940.00 $0.00
Transfers
CTM Support $63,280.00 $63,280.00
Liability Reserve $1,000.00 $1,000.00
  $64,280.00 $64,280.00
TOTALS $4,120,692.00 $2,146,693.86

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.