| COMBINED TRANSPORTATION, EMERGENCY & COMMUNICATIONS CTR FUND |
BUDGET |
EXPENDITURES |
| CTECC AND PUBLIC SAFETY IT SUPPORT |
| CTECC Infrastructure and Public Safety |
| Administrative leave |
$0.00 |
$15,240.75 |
| Advertising/publication |
$2,000.00 |
$0.00 |
| Awards and Recognition |
$6,000.00 |
$0.00 |
| Backcharged salary & fringes |
$0.00 |
($42,338.07) |
| Books-library |
$3,194.00 |
$0.00 |
| Call back time |
$0.00 |
$371.04 |
| Clothing/clothing material |
$5,000.00 |
$0.00 |
| Computer supplies |
$6,500.00 |
$2,635.50 |
| Consulting-information technology |
$1,132,021.00 |
$125,317.73 |
| Contribution to employees ret |
$652,103.00 |
$152,424.19 |
| Drainage fee expense |
$15,750.00 |
$4,229.24 |
| Educational travel |
$63,400.00 |
$7,553.78 |
| Electric services |
$631,979.00 |
$151,768.14 |
| Exception vacation |
$0.00 |
$562.17 |
| Expense refunds |
($248,625.00) |
($7,500.00) |
| FICA tax |
$468,042.00 |
$119,732.78 |
| Fleet-equip.preventative maint |
$3,396.00 |
$873.42 |
| Food/Ice |
$10,000.00 |
$0.00 |
| Garbage/refuse collection |
$551.00 |
$116.50 |
| Holiday pay |
$0.00 |
$136,170.99 |
| Insurance-health/life/dental |
$934,572.00 |
$213,780.18 |
| Insurance-temporary employees |
$0.00 |
$10,296.41 |
| Interdepartmental reimbursements |
($221,328.00) |
($41,328.00) |
| Jury leave |
$0.00 |
$563.85 |
| Maintenance-buildings |
$2,438,117.00 |
$344,962.85 |
| Maintenance-computer hardware |
$1,467,375.00 |
$1,046,412.14 |
| Maintenance-computer software |
$7,706,036.00 |
$6,774,580.16 |
| Maintenance-other equipment |
$294,449.00 |
$0.00 |
| Medicare tax |
$109,460.00 |
$28,002.04 |
| Memberships |
$1,000.00 |
$0.00 |
| Mileage reimbursements |
$7,050.00 |
$119.70 |
| Minor computer hardware |
$46,767.00 |
$10,541.77 |
| Office supplies |
$17,645.00 |
$294.75 |
| On call hours |
$0.00 |
$7,632.50 |
| Other paid leave |
$0.00 |
$5,909.39 |
| Overtime |
$23,147.00 |
$7,065.77 |
| Parental Leave |
$0.00 |
$469.00 |
| Personal holiday pay |
$0.00 |
$23,754.47 |
| Personnel savings |
($589,599.00) |
$0.00 |
| Phone allowance |
$33,840.00 |
$10,387.96 |
| Priority mail/parcel services |
$1,000.00 |
$0.00 |
| Regular wages - full-time |
$6,792,764.00 |
$1,400,366.21 |
| Rental-computer hardware |
$225,000.00 |
$237,162.16 |
| Rental-copy machines |
$58,208.00 |
($1.19) |
| Rental-vehicles/buses |
$12,000.00 |
$4,950.00 |
| Seminar/training fees |
$94,535.00 |
$4,759.50 |
| Services-Dumpster Collection |
$0.00 |
$37.01 |
| Services-IT Installations |
$50,000.00 |
$6,967.80 |
| Services-IT staffing |
$1,269,360.00 |
$191,591.00 |
| Services-Infrastructure as a Service |
$1,097,366.00 |
$311,904.42 |
| Services-Platform as a Service |
$1,157,921.00 |
$305,555.00 |
| Services-Software as a Service |
$3,468,188.00 |
$1,248,066.82 |
| Services-internet/cable |
$110,875.00 |
$6,804.77 |
| Services-security |
$2,615,817.00 |
$339,844.14 |
| Sick pay |
$0.00 |
$68,340.23 |
| Small tools/minor equipment |
$80,420.00 |
$824.67 |
| Software |
$35,000.00 |
$0.00 |
| Stability pay |
$40,700.00 |
$38,400.00 |
| Subscriptions |
$500.00 |
$0.00 |
| Telephone-base cost |
$706,000.00 |
$133,988.35 |
| Telephone-cellular phones |
$30,000.00 |
$3,798.91 |
| Telephone-long distance |
$5,000.00 |
$1,099.50 |
| Temporary employees |
$681,829.00 |
$139,908.55 |
| Transportation-city veh fuel |
$2,003.00 |
$391.63 |
| Vacation pay |
$0.00 |
$124,234.36 |
| Wastewater service |
$10,330.00 |
$2,861.48 |
| Water service |
$19,072.00 |
$3,908.53 |
| |
$33,583,730.00 |
$13,686,366.95
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Other Requirements |
| Accrued Payroll |
$33,323.00 |
$0.00 |
| Contribution to employees ret |
$662,856.00 |
$203,955.68 |
| |
$696,179.00 |
$203,955.68
|
|
| Transfers |
| Liability Reserve |
$2,000.00 |
$2,000.00 |
| Workers' Compensation |
$61,053.00 |
$61,053.00 |
| |
$63,053.00 |
$63,053.00
|
|
|
|
| INFORMATION AND TECHNOLOGY FUND |
BUDGET |
EXPENDITURES |
| INFORMATION SECURITY |
| Information Security |
| Administrative leave |
$0.00 |
$1,123.70 |
| Awards and Recognition |
$1,430.00 |
$0.00 |
| Consulting-information technology |
$1,730,586.00 |
$1,080,154.30 |
| Contribution to employees ret |
$334,351.00 |
$81,107.64 |
| Drainage fee expense |
$480.00 |
$0.00 |
| Educational travel |
$25,000.00 |
$0.00 |
| Electric services |
$4,800.00 |
$0.00 |
| FICA tax |
$245,946.00 |
$65,433.04 |
| Food/Ice |
$8,750.00 |
$112.17 |
| Garbage/refuse collection |
$1,980.00 |
$0.00 |
| Holiday pay |
$0.00 |
$78,248.15 |
| Holidays worked |
$0.00 |
$943.66 |
| Insurance-health/life/dental |
$393,504.00 |
$95,854.24 |
| Insurance-temporary employees |
$0.00 |
$6,267.38 |
| Maintenance-buildings |
$1,500.00 |
$2,175.00 |
| Maintenance-computer software |
$595.00 |
$1,795.41 |
| Medicare tax |
$58,411.00 |
$15,411.77 |
| Memberships |
$52,803.00 |
$2,522.16 |
| Minor computer hardware |
$13,646.00 |
$423.20 |
| Office supplies |
$15,344.00 |
$64.93 |
| Overtime |
$0.00 |
$162.08 |
| Personal holiday pay |
$0.00 |
$13,841.78 |
| Personnel savings |
($218,892.00) |
$0.00 |
| Phone allowance |
$26,460.00 |
$9,112.67 |
| Professional registration |
$1,600.00 |
$0.00 |
| Regular wages - full-time |
$3,482,819.00 |
$792,307.32 |
| Rental-copy machines |
$3,300.00 |
$0.00 |
| Rental-real estate-office |
$113,267.00 |
$12,475.72 |
| Seminar/training fees |
$138,653.00 |
$12,675.00 |
| Services-IT staffing |
$1,501,119.00 |
$169,783.72 |
| Services-Software as a Service |
$3,749,883.00 |
$246,253.74 |
| Services-other |
$0.00 |
$13,199.50 |
| Sick pay |
$0.00 |
$11,730.71 |
| Software |
$136,809.00 |
$0.00 |
| Stability pay |
$18,700.00 |
$16,800.00 |
| Subscriptions |
$3,072.00 |
$1,919.00 |
| Telephone-cellular phones |
$0.00 |
$929.82 |
| Temporary employees |
$500,292.00 |
$109,737.76 |
| Vacation pay |
$0.00 |
$51,654.69 |
| Wastewater service |
$1,200.00 |
$0.00 |
| Water service |
$960.00 |
$0.00 |
| |
$12,348,368.00 |
$2,894,220.26
|
|
|
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$14,505.54 |
| Advertising/publication |
$800.00 |
$0.00 |
| Awards and Recognition |
$22,000.00 |
$17,178.46 |
| Backcharged salary & fringes |
$157,120.00 |
$0.00 |
| Books-library |
$0.00 |
$159.99 |
| Consulting-information technology |
$1,204,270.00 |
$1,053,693.56 |
| Contribution to employees ret |
$302,828.00 |
$84,384.30 |
| Educational travel |
$21,732.00 |
$6,164.86 |
| Educational/promotional |
$15,200.00 |
$246.00 |
| Electric services |
$62,851.00 |
$761.70 |
| Emergency leave |
$0.00 |
$995.08 |
| Employee recruiting |
$4,000.00 |
$0.00 |
| Exception vacation |
$0.00 |
$1,243.85 |
| Exp Reimb - Public Information Requests |
$0.00 |
($108.00) |
| FICA tax |
$211,361.00 |
$62,843.28 |
| Facilities Management Support |
$379,664.00 |
$0.00 |
| Federal unemployment tax co |
$15,000.00 |
$0.00 |
| Fleet-equip.preventative maint |
$2,393.00 |
$436.71 |
| Food/Ice |
$31,650.00 |
$1,927.50 |
| Holiday pay |
$0.00 |
$81,036.51 |
| Insurance-health/life/dental |
$491,880.00 |
$132,430.20 |
| Insurance-temporary employees |
$0.00 |
$8,058.06 |
| Interdepartmental Charges |
$1,416.00 |
$0.00 |
| Interdeptl-other |
$1,416.00 |
$0.00 |
| Jury leave |
$0.00 |
$636.09 |
| Maintenance-buildings |
$25,000.00 |
$488.00 |
| Maintenance-computer software |
$1,200.00 |
$0.00 |
| Market Study Adjustment |
$11,666.00 |
$0.00 |
| Medicare tax |
$50,775.00 |
$15,918.23 |
| Memberships |
$3,600.00 |
$2,825.00 |
| Mileage reimbursements |
$100.00 |
$0.00 |
| Minor computer hardware |
$0.00 |
$1,109.34 |
| Office furnishings |
$35,000.00 |
$69.95 |
| Office supplies |
$5,500.00 |
$1,042.27 |
| Overtime |
$3,000.00 |
$134.31 |
| Parental Leave |
$0.00 |
$9,083.15 |
| Personal holiday pay |
$0.00 |
$11,879.82 |
| Personnel savings |
($3,532,942.00) |
$0.00 |
| Phone allowance |
$11,040.00 |
$3,748.96 |
| Postage |
$100.00 |
$0.00 |
| Printing/binding/photo/repr |
$250.00 |
$0.00 |
| Priority mail/parcel services |
$75.00 |
$0.00 |
| Professional registration |
$700.00 |
$0.00 |
| Regular wages - full-time |
$3,154,485.00 |
$761,148.87 |
| Rental-copy machines |
$36,272.00 |
$1,076,047.02 |
| Rental-real estate-office |
$247,252.00 |
$57,922.45 |
| Seminar/training fees |
$30,000.00 |
$592.70 |
| Services-Dumpster Collection |
$500.00 |
$13.35 |
| Services-IT staffing |
$185,648.00 |
$0.00 |
| Services-Platform as a Service |
$250.00 |
$0.00 |
| Services-Prepared Food and Catering |
$100.00 |
$193.75 |
| Services-Software as a Service |
$0.00 |
$3,030.02 |
| Services-internet/cable |
$1,166.00 |
$0.00 |
| Sick pay |
$0.00 |
$35,834.74 |
| Small tools/minor equipment |
$100.00 |
$0.00 |
| Software |
$1,600.00 |
$0.00 |
| Stability pay |
$21,800.00 |
$23,800.00 |
| Telephone-cellular phones |
$15,000.00 |
$4,633.52 |
| Temporary employees |
$314,406.00 |
$104,525.24 |
| Terminal pay |
$109,000.00 |
$0.00 |
| Training-basics |
$3,000.00 |
$0.00 |
| Transportation-city veh fuel |
$200.00 |
$55.30 |
| Vacation pay |
$0.00 |
$68,796.24 |
| |
$3,661,424.00 |
$3,649,485.92
|
|
|
| TECHNOLOGY SERVICES |
| Applications and Business Transformation Services |
| Administrative leave |
$0.00 |
$31,251.10 |
| Advertising/publication |
$100.00 |
$0.00 |
| Backcharged salary & fringes |
$0.00 |
$42,338.07 |
| Bilingual Pay |
$1,800.00 |
$1,107.84 |
| Books-library |
$50.00 |
$0.00 |
| Comp time used |
$0.00 |
$522.70 |
| Consulting-information technology |
$1,655,500.00 |
$183,315.00 |
| Contribution to employees ret |
$1,028,111.00 |
$297,207.15 |
| Educational travel |
$88,250.00 |
$17,718.43 |
| Educational/promotional |
$500.00 |
$30.00 |
| Emergency leave |
$0.00 |
$6,316.97 |
| Exception vacation |
$0.00 |
$527.00 |
| FICA tax |
$693,818.00 |
$219,634.08 |
| Food/Ice |
$4,250.00 |
$351.91 |
| Holiday pay |
$0.00 |
$274,187.27 |
| Holidays worked |
$0.00 |
$343.95 |
| Insurance-health/life/dental |
$1,442,848.00 |
$400,443.70 |
| Insurance-temporary employees |
$0.00 |
$9,401.07 |
| Jury leave |
$0.00 |
$835.14 |
| Maintenance-computer software |
$4,887,844.00 |
$3,395,701.39 |
| Medicare tax |
$162,539.00 |
$51,675.25 |
| Memberships |
$49,950.00 |
$583.26 |
| Mileage reimbursements |
$100.00 |
$0.00 |
| Minor computer hardware |
$5,000.00 |
$0.00 |
| Office supplies |
$1,600.00 |
$32.99 |
| Other 3rd party billings |
($381,037.00) |
$0.00 |
| Overtime |
$26,500.00 |
$3,389.99 |
| Personal holiday pay |
$0.00 |
$51,584.02 |
| Phone allowance |
$51,900.00 |
$16,799.56 |
| Professional registration |
$4,750.00 |
$0.00 |
| Regular wages - full-time |
$10,709,496.00 |
$2,673,149.23 |
| Seminar/training fees |
$190,695.00 |
$3,134.50 |
| Services-IT staffing |
$4,062,520.00 |
$470,866.33 |
| Services-Platform as a Service |
$230,000.00 |
$149,906.04 |
| Services-Prepared Food and Catering |
$1,500.00 |
$0.00 |
| Services-Software as a Service |
$5,532,366.00 |
$3,340,526.25 |
| Services-testing |
$3,000.00 |
$0.00 |
| Sick pay |
$0.00 |
$102,181.26 |
| Small tools/minor equipment |
$500.00 |
$0.00 |
| Software |
$39,100.00 |
($2,621.83) |
| Stability pay |
$74,200.00 |
$78,400.00 |
| Subscriptions |
$8,500.00 |
$0.00 |
| Temporary employees |
$372,000.00 |
$107,306.78 |
| Terminal pay |
$0.00 |
$8,368.38 |
| Vacation pay |
$0.00 |
$299,112.45 |
| |
$30,948,250.00 |
$12,235,627.23
|
|
| Customer Service |
| Administrative leave |
$0.00 |
$16,179.23 |
| Awards and Recognition |
$0.00 |
$423.31 |
| Books-library |
$150.00 |
$0.00 |
| Computer supplies |
$100.00 |
$0.00 |
| Consulting-information technology |
$105,200.00 |
$0.00 |
| Contribution to employees ret |
$371,832.00 |
$101,408.52 |
| Educational travel |
$31,500.00 |
$3,830.17 |
| Emergency leave |
$0.00 |
$811.95 |
| FICA tax |
$298,912.00 |
$107,161.32 |
| Fleet-equip.preventative maint |
$9,577.00 |
$1,746.84 |
| Food/Ice |
$150.00 |
$0.00 |
| Holiday pay |
$0.00 |
$122,034.82 |
| Holidays worked |
$0.00 |
$1,568.67 |
| Insurance-health/life/dental |
$606,652.00 |
$153,240.66 |
| Insurance-temporary employees |
$0.00 |
$66,255.16 |
| Jury leave |
$0.00 |
$257.09 |
| Maintenance-computer hardware |
$25,000.00 |
$0.00 |
| Maintenance-computer software |
$63,880.00 |
$0.00 |
| Medicare tax |
$69,907.00 |
$25,061.94 |
| Memberships |
$990.00 |
$0.00 |
| Mileage reimbursements |
$2,200.00 |
$0.00 |
| Minor computer hardware |
$177,727.00 |
$24,775.60 |
| Office supplies |
$600.00 |
$58.22 |
| On call hours |
$0.00 |
$19,427.00 |
| Overtime |
$24,780.00 |
$11,508.39 |
| Parental Leave |
$0.00 |
$10,324.99 |
| Personal holiday pay |
$0.00 |
$12,295.98 |
| Phone allowance |
$7,440.00 |
$2,677.92 |
| Professional registration |
$2,100.00 |
$0.00 |
| Regular wages - full-time |
$3,873,250.00 |
$913,578.53 |
| Rental-computer hardware |
$1,700,000.00 |
$1,879,568.40 |
| Rental-vehicles/buses |
$26,000.00 |
$5,040.00 |
| Seminar/training fees |
$21,300.00 |
$1,309.25 |
| Services-IT Installations |
$5,000.00 |
$0.00 |
| Services-IT staffing |
$1,026,072.00 |
$146,809.76 |
| Services-Software as a Service |
$486,513.00 |
($312,120.36) |
| Sick pay |
$0.00 |
$57,113.43 |
| Small tools/minor equipment |
$35,000.00 |
$4,469.55 |
| Software |
$24,574.00 |
$458.76 |
| Stability pay |
$28,200.00 |
$28,200.00 |
| Subscriptions |
$39,080.00 |
$17,242.62 |
| Telephone-cellular phones |
$20,000.00 |
$4,968.03 |
| Temporary employees |
$912,381.00 |
$477,832.86 |
| Transportation-city veh fuel |
$800.00 |
$99.47 |
| Vacation pay |
$0.00 |
$89,049.90 |
| Wireless Communications-maint |
$16,900.00 |
$0.00 |
| |
$10,013,767.00 |
$3,994,667.98
|
|
| Infrastructure |
| Administrative leave |
$0.00 |
$10,200.97 |
| Books-library |
$65.00 |
$0.00 |
| Call back time |
$0.00 |
$670.73 |
| Comp time used |
$0.00 |
$1,240.32 |
| Computer supplies |
$100.00 |
$0.00 |
| Consulting-information technology |
$3,370,592.00 |
$471,044.82 |
| Contribution to employees ret |
$854,331.00 |
$219,884.40 |
| Educational travel |
$14,000.00 |
$5,056.26 |
| Emergency leave |
$0.00 |
$4,445.68 |
| FICA tax |
$577,020.00 |
$162,319.06 |
| Fleet-equip.preventative maint |
$22,672.00 |
$4,527.30 |
| Food/Ice |
$150.00 |
$0.00 |
| Holiday pay |
$0.00 |
$193,145.58 |
| Holidays worked |
$0.00 |
$749.06 |
| Insurance-health/life/dental |
$1,196,908.00 |
$298,283.26 |
| Insurance-temporary employees |
$0.00 |
$8,505.73 |
| Interdepartmental Charges |
$1,000.00 |
$0.00 |
| Interdepartmental reimbursements |
($2,110,000.00) |
$0.00 |
| Interdept-Services Carpentry |
$5,000.00 |
$0.00 |
| Interdept-Services Electrical |
$6,000.00 |
$0.00 |
| Interdept-Services HVAC |
$3,000.00 |
$0.00 |
| Maintenance-computer hardware |
$4,367,013.00 |
$437,688.13 |
| Maintenance-computer software |
$2,394,925.00 |
$2,100,733.21 |
| Maintenance-other equipment |
$12,000.00 |
$0.00 |
| Medicare tax |
$135,201.00 |
$38,386.97 |
| Memberships |
$2,950.00 |
$240.00 |
| Minor computer hardware |
$65,000.00 |
$10,697.76 |
| Office supplies |
$200.00 |
$45.92 |
| On call hours |
$0.00 |
$15,378.00 |
| Overtime |
$23,000.00 |
$5,200.77 |
| Parental Leave |
$0.00 |
$3,067.11 |
| Personal holiday pay |
$0.00 |
$33,576.52 |
| Phone allowance |
$46,320.00 |
$14,449.60 |
| Professional registration |
$1,950.00 |
$0.00 |
| Regular wages - full-time |
$8,913,775.00 |
$2,054,252.66 |
| Seminar/training fees |
$62,500.00 |
$9,100.71 |
| Services-IT Installations |
$302,421.00 |
$129,881.73 |
| Services-IT staffing |
$1,520,862.00 |
$661,416.78 |
| Services-Infrastructure as a Service |
$1,009,400.00 |
$284,705.04 |
| Services-Platform as a Service |
$3,395,400.00 |
$331,969.97 |
| Services-Prepared Food and Catering |
$150.00 |
$0.00 |
| Services-Software as a Service |
$17,498,221.00 |
$13,145,504.99 |
| Services-internet/cable |
$869,340.00 |
$742,254.84 |
| Sick pay |
$0.00 |
$65,886.23 |
| Small tools/minor equipment |
$27,000.00 |
$1,070.79 |
| Software |
$13,250.00 |
$0.00 |
| Stability pay |
$63,100.00 |
$62,500.00 |
| Subscriptions |
$400.00 |
$0.00 |
| Telephone-base cost |
$360,000.00 |
$0.00 |
| Telephone-long distance |
$20,000.00 |
$0.00 |
| Temporary employees |
$299,093.00 |
$79,531.55 |
| Toll Road - Tx Tag |
$2,500.00 |
$360.00 |
| Transportation-city veh fuel |
$2,314.00 |
$455.17 |
| Vacation pay |
$0.00 |
$186,191.54 |
| |
$45,349,123.00 |
$21,794,619.16
|
|
| Technology and Strategy |
| Administrative leave |
$0.00 |
$606.37 |
| Consulting-information technology |
$1,123,591.00 |
$0.00 |
| Contribution to employees ret |
$79,338.00 |
$18,850.17 |
| Educational travel |
$22,225.00 |
$0.00 |
| FICA tax |
$52,106.00 |
$13,576.15 |
| Holiday pay |
$0.00 |
$15,927.10 |
| Insurance-health/life/dental |
$114,772.00 |
$27,116.66 |
| Jury leave |
$0.00 |
$499.12 |
| Maintenance-computer software |
$129,000.00 |
$32,199.04 |
| Medicare tax |
$12,185.00 |
$3,175.05 |
| Memberships |
$400.00 |
$0.00 |
| Office supplies |
$500.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$2,737.46 |
| Phone allowance |
$5,700.00 |
$1,447.38 |
| Professional registration |
$400.00 |
$0.00 |
| Regular wages - full-time |
$826,428.00 |
$169,283.51 |
| Seminar/training fees |
$15,000.00 |
$0.00 |
| Services-IT staffing |
$898,760.00 |
$119,256.00 |
| Services-Platform as a Service |
$560,594.00 |
$551,332.54 |
| Services-Software as a Service |
$1,679,036.00 |
$821,770.47 |
| Sick pay |
$0.00 |
$2,535.28 |
| Software |
$1,500.00 |
$0.00 |
| Stability pay |
$8,300.00 |
$6,800.00 |
| Subscriptions |
$400.00 |
$0.00 |
| Vacation pay |
$0.00 |
$26,012.11 |
| |
$5,530,235.00 |
$1,813,124.41
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Other Requirements |
| Accrued Payroll |
$164,725.00 |
$0.00 |
| Contribution to employees ret |
$3,023,814.00 |
$930,404.48 |
| Fire/Extend Coverage Insurance |
$264,318.00 |
$217,876.87 |
| |
$3,452,857.00 |
$1,148,281.35
|
|
| Transfers |
| Liability Reserve |
$10,000.00 |
$10,000.00 |
| Trf to CIP Mgm - CPM |
$9,609.00 |
$2,402.25 |
| |
$19,609.00 |
$12,402.25
|
|
|
|
| TOTALS |
$145,666,595.00 |
$61,495,804.19 |
|
