| COMBINED TRANSPORTATION, EMERGENCY & COMMUNICATIONS CTR FUND |
BUDGET |
EXPENDITURES |
| CTECC AND PUBLIC SAFETY IT SUPPORT |
| CTECC Infrastructure and Public Safety |
| Administrative leave |
$0.00 |
$39,485.34 |
| Advertising/publication |
$2,000.00 |
$0.00 |
| Awards and Recognition |
$6,000.00 |
$561.70 |
| Backcharged salary & fringes |
$0.00 |
$77,186.96 |
| Books-library |
$3,194.00 |
$0.00 |
| Call back time |
$0.00 |
$5,171.65 |
| Clothing/clothing material |
$5,000.00 |
$0.00 |
| Computer Hardware |
$0.00 |
$19,761.17 |
| Computer supplies |
$166,500.00 |
$15,971.01 |
| Consulting-information technology |
$961,000.00 |
$560,439.60 |
| Contribution to employees ret |
$567,124.00 |
$489,219.97 |
| Drainage fee expense |
$15,750.00 |
$14,825.72 |
| Educational travel |
$58,400.00 |
$82,733.43 |
| Electric services |
$631,979.00 |
$531,330.40 |
| Emergency leave |
$0.00 |
$5,553.60 |
| Exception vacation |
$0.00 |
$6,184.11 |
| Expense refunds |
($248,625.00) |
($48,823.00) |
| FICA tax |
$447,815.00 |
$384,481.22 |
| Fleet-equip.preventative maint |
$2,670.00 |
$6,159.88 |
| Food/Ice |
$4,500.00 |
$8,388.17 |
| Garbage/refuse collection |
$551.00 |
$425.70 |
| Holiday pay |
$0.00 |
$275,635.06 |
| Holidays worked |
$0.00 |
$2,082.10 |
| Insurance-health/life/dental |
$934,572.00 |
$755,482.76 |
| Insurance-temporary employees |
$0.00 |
$5,819.71 |
| Interdepartmental reimbursements |
($220,000.00) |
($164,000.00) |
| Jury leave |
$0.00 |
$284.16 |
| Maintenance-buildings |
$2,291,661.00 |
$1,353,152.09 |
| Maintenance-computer hardware |
$1,607,850.00 |
$756,707.93 |
| Maintenance-computer software |
$6,744,863.00 |
$6,500,243.97 |
| Maintenance-other equipment |
$287,570.00 |
$79,139.93 |
| Medicare tax |
$104,743.00 |
$89,968.90 |
| Memberships |
$1,000.00 |
$1,123.55 |
| Mileage reimbursements |
$7,050.00 |
$396.76 |
| Minor computer hardware |
$46,767.00 |
$85,254.79 |
| Office supplies |
$17,645.00 |
$76,806.69 |
| On call hours |
$0.00 |
$12,596.00 |
| Other 3rd party billings |
$0.00 |
($122,103.21) |
| Overtime |
$23,147.00 |
$38,864.84 |
| Parental Leave |
$0.00 |
$22,097.04 |
| Personal holiday pay |
$0.00 |
$68,346.02 |
| Personnel savings |
($548,234.00) |
$0.00 |
| Phone allowance |
$34,740.00 |
$33,716.91 |
| Priority mail/parcel services |
$1,000.00 |
$24.86 |
| Regular wages - full-time |
$6,533,685.00 |
$4,881,360.89 |
| Rental-computer hardware |
$200,000.00 |
$41,170.51 |
| Rental-copy machines |
$58,208.00 |
$43,697.47 |
| Rental-real estate-office |
$0.00 |
$40,127.90 |
| Rental-vehicles/buses |
$8,640.00 |
$10,691.99 |
| Security equipment |
$0.00 |
$84,323.30 |
| Seminar/training fees |
$89,535.00 |
$51,401.53 |
| Services-Dumpster Collection |
$0.00 |
$349.92 |
| Services-IT |
$0.00 |
$28,995.00 |
| Services-IT Installations |
$50,000.00 |
$16,427.44 |
| Services-IT staffing |
$836,160.00 |
$570,189.71 |
| Services-Infrastructure as a Service |
$1,023,632.00 |
$532,866.19 |
| Services-Platform as a Service |
$909,945.00 |
$1,296,061.76 |
| Services-Prepared Food and Catering |
$0.00 |
$140.00 |
| Services-Software as a Service |
$2,709,740.00 |
$2,426,205.59 |
| Services-internet/cable |
$113,389.00 |
$74,885.14 |
| Services-security |
$2,355,376.00 |
$1,664,085.26 |
| Sick pay |
$0.00 |
$166,753.26 |
| Small tools/minor equipment |
$74,420.00 |
$9,537.45 |
| Software |
$33,000.00 |
$1,359.46 |
| Stability pay |
$40,800.00 |
$37,800.00 |
| Subscriptions |
$500.00 |
$0.00 |
| Telephone-base cost |
$826,551.00 |
$385,001.65 |
| Telephone-cellular phones |
$84,120.00 |
$21,095.30 |
| Telephone-long distance |
$15,000.00 |
$2,995.00 |
| Temporary employees |
$614,389.00 |
$468,472.60 |
| Terminal pay |
$0.00 |
$25,690.28 |
| Toll Road - Tx Tag |
$0.00 |
$40.00 |
| Transportation-city veh fuel |
$2,911.00 |
$2,088.97 |
| Vacation pay |
$0.00 |
$291,049.92 |
| Wastewater service |
$10,330.00 |
$10,992.76 |
| Water service |
$19,072.00 |
$16,280.83 |
| |
$30,567,635.00 |
$25,272,834.57
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Other Requirements |
| Accrued Payroll |
$28,821.00 |
$28,821.00 |
| Contribution to employees ret |
$642,746.00 |
$618,024.75 |
| |
$671,567.00 |
$646,845.75
|
|
| Transfers |
| Liability Reserve |
$2,000.00 |
$2,000.00 |
| Trf to CTM CIP Fund |
$3,162,601.00 |
$2,371,950.75 |
| Workers' Compensation |
$56,132.00 |
$56,132.00 |
| |
$3,220,733.00 |
$2,430,082.75
|
|
|
|
| INFORMATION AND TECHNOLOGY FUND |
BUDGET |
EXPENDITURES |
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$35,667.21 |
| Advertising/publication |
$800.00 |
$0.00 |
| Allowances/other pay |
$0.00 |
$15,000.00 |
| Awards and Recognition |
$22,000.00 |
$27,558.03 |
| Books-library |
$0.00 |
$149.00 |
| Comp time used |
$0.00 |
$102.03 |
| Computer supplies |
$50.00 |
$0.00 |
| Consulting-information technology |
$833,203.00 |
$1,203,079.00 |
| Contribution to employees ret |
$270,475.00 |
$250,170.31 |
| Educational travel |
$21,732.00 |
$31,762.37 |
| Educational/promotional |
$5,200.00 |
$7,097.49 |
| Electric services |
$62,851.00 |
$12,477.68 |
| Emergency leave |
$0.00 |
$4,486.80 |
| Employee recruiting |
$2,000.00 |
$19,517.76 |
| Exception vacation |
$0.00 |
$1,522.60 |
| FICA tax |
$204,771.00 |
$188,410.90 |
| Federal unemployment tax co |
$15,000.00 |
$11,604.70 |
| Fleet-equip.preventative maint |
$3,093.00 |
$2,231.35 |
| Food/Ice |
$1,000.00 |
$26,135.90 |
| Holiday pay |
$0.00 |
$139,231.22 |
| Holidays worked |
$0.00 |
$2,738.97 |
| Insurance-health/life/dental |
$508,276.00 |
$437,650.28 |
| Insurance-temporary employees |
$88,184.00 |
$4,476.70 |
| Interdepartmental Charges |
$4,500.00 |
$0.00 |
| Maintenance-buildings |
$25,000.00 |
$9,048.80 |
| Maintenance-computer hardware |
$0.00 |
$1,102.70 |
| Maintenance-computer software |
$1,200.00 |
$0.00 |
| Medicare tax |
$49,230.00 |
$44,937.93 |
| Memberships |
$2,500.00 |
$1,826.00 |
| Mileage reimbursements |
$100.00 |
$0.00 |
| Minor computer hardware |
$0.00 |
$4,968.96 |
| Office furnishings |
$52,789.00 |
$1,365.75 |
| Office supplies |
$5,500.00 |
$3,765.17 |
| Overtime |
$3,000.00 |
$2,769.36 |
| Parental Leave |
$0.00 |
$7,486.08 |
| Parking costs |
$0.00 |
$10.00 |
| Personal holiday pay |
$0.00 |
$33,925.72 |
| Personnel savings |
($3,227,073.00) |
$0.00 |
| Phone allowance |
$11,760.00 |
$11,414.18 |
| Postage |
$100.00 |
$0.00 |
| Printing/binding/photo/repr |
$250.00 |
$26.75 |
| Priority mail/parcel services |
$75.00 |
$0.00 |
| Professional registration |
$700.00 |
$229.00 |
| Regular wages - full-time |
$3,116,027.00 |
$2,455,927.24 |
| Rental-copy machines |
$36,272.00 |
$3,886.08 |
| Rental-real estate-office |
$2,039,392.00 |
$688,241.34 |
| Seminar/training fees |
$30,000.00 |
$21,664.81 |
| Services-Dumpster Collection |
$500.00 |
$75.15 |
| Services-IT Installations |
$0.00 |
$34,989.80 |
| Services-IT staffing |
$0.00 |
$142,762.00 |
| Services-Platform as a Service |
$250.00 |
$0.00 |
| Services-Prepared Food and Catering |
$4,167.00 |
$3,098.22 |
| Services-Software as a Service |
$1,440.00 |
$1,300.95 |
| Services-internet/cable |
$1,166.00 |
$268.08 |
| Services-other |
$0.00 |
$76,722.65 |
| Services-security |
$300.00 |
$0.00 |
| Sick pay |
$0.00 |
$86,426.96 |
| Small tools/minor equipment |
$100.00 |
$0.00 |
| Software |
$1,600.00 |
$715.08 |
| Stability pay |
$21,100.00 |
$19,400.00 |
| Subscriptions |
$0.00 |
$2,619.40 |
| Telephone-cellular phones |
$15,000.00 |
$22,263.09 |
| Temporary employees |
$246,406.00 |
$172,809.08 |
| Terminal pay |
$109,000.00 |
$0.00 |
| Training-basics |
$3,000.00 |
$349.00 |
| Transportation-city veh fuel |
$219.00 |
$108.62 |
| Vacation pay |
$0.00 |
$172,539.78 |
| |
$4,594,205.00 |
$6,450,114.03
|
|
|
| TECHNOLOGY SERVICES |
| Applications and Business Transformation Services |
| Administrative leave |
$0.00 |
$47,746.88 |
| Advertising/publication |
$100.00 |
$0.00 |
| Awards and Recognition |
$0.00 |
$30.00 |
| Backcharged salary & fringes |
$0.00 |
($77,186.96) |
| Bilingual Pay |
$1,800.00 |
$1,869.48 |
| Books-library |
$50.00 |
$45.99 |
| Comp time used |
$0.00 |
$3,708.49 |
| Consulting-information technology |
$1,803,718.00 |
$1,232,804.87 |
| Contribution to employees ret |
$897,692.00 |
$816,413.36 |
| Educational travel |
$72,750.00 |
$62,209.52 |
| Educational/promotional |
$500.00 |
$0.00 |
| Emergency leave |
$0.00 |
$23,152.56 |
| Exception vacation |
$0.00 |
$3,345.98 |
| FICA tax |
$666,610.00 |
$607,295.53 |
| Food/Ice |
$4,250.00 |
$2,543.96 |
| Holiday pay |
$0.00 |
$460,023.28 |
| Holidays worked |
$0.00 |
$2,056.52 |
| Insurance-health/life/dental |
$1,459,244.00 |
$1,226,555.90 |
| Insurance-temporary employees |
$0.00 |
$5,819.71 |
| Jury leave |
$0.00 |
$2,023.95 |
| Maintenance-computer software |
$3,787,978.00 |
$3,790,693.56 |
| Medicare tax |
$156,174.00 |
$142,329.43 |
| Memberships |
$10,850.00 |
$5,550.30 |
| Mileage reimbursements |
$100.00 |
$0.00 |
| Minor computer hardware |
$0.00 |
$4,022.80 |
| Office supplies |
$1,600.00 |
$325.31 |
| Other 3rd party billings |
($381,037.00) |
($199,220.99) |
| Overtime |
$26,500.00 |
$17,746.60 |
| Parental Leave |
$0.00 |
$31,698.96 |
| Parking costs |
$50.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$103,060.01 |
| Phone allowance |
$25,860.00 |
$50,198.17 |
| Professional registration |
$6,000.00 |
$1,333.97 |
| Regular wages - full-time |
$10,342,039.00 |
$8,125,162.22 |
| Rental-real estate-office |
$0.00 |
$15,643.06 |
| Seminar/training fees |
$164,695.00 |
$79,037.87 |
| Services-IT staffing |
$3,495,075.00 |
$2,644,389.40 |
| Services-Platform as a Service |
$200,000.00 |
$0.00 |
| Services-Prepared Food and Catering |
$1,500.00 |
$0.00 |
| Services-Software as a Service |
$4,186,203.00 |
$3,218,812.67 |
| Services-testing |
$3,000.00 |
$2,000.00 |
| Sick pay |
$0.00 |
$222,775.05 |
| Small tools/minor equipment |
$500.00 |
$0.00 |
| Software |
$139,800.00 |
$4,007.98 |
| Stability pay |
$75,900.00 |
$73,100.00 |
| Subscriptions |
$8,500.00 |
$916.63 |
| Telephone-long distance |
$100.00 |
$0.00 |
| Temporary employees |
$325,080.00 |
$314,790.58 |
| Terminal pay |
$0.00 |
$62,463.78 |
| Trf to CTM CIP Fund |
$0.00 |
$16,120.00 |
| Vacation pay |
$0.00 |
$556,564.03 |
| |
$27,483,181.00 |
$23,703,980.41
|
|
| Customer Service |
| Administrative leave |
$0.00 |
$37,776.85 |
| Awards and Recognition |
$0.00 |
$1,595.00 |
| Books-library |
$150.00 |
$0.00 |
| Call back time |
$0.00 |
$691.21 |
| Comp time used |
$0.00 |
$5,165.57 |
| Computer supplies |
$100.00 |
$0.00 |
| Consulting-information technology |
$187,200.00 |
$0.00 |
| Contribution to employees ret |
$326,374.00 |
$290,659.42 |
| Educational travel |
$31,500.00 |
$33,367.59 |
| Emergency leave |
$0.00 |
$4,192.32 |
| FICA tax |
$289,200.00 |
$297,848.54 |
| Fleet-equip.preventative maint |
$12,379.00 |
$8,925.40 |
| Food/Ice |
$150.00 |
$0.00 |
| Holiday pay |
$0.00 |
$165,323.68 |
| Holidays worked |
$0.00 |
$3,219.16 |
| Insurance-health/life/dental |
$606,652.00 |
$504,496.00 |
| Insurance-temporary employees |
$0.00 |
$37,604.28 |
| Jury leave |
$0.00 |
$964.24 |
| Maintenance-computer hardware |
$25,000.00 |
$19,944.27 |
| Maintenance-computer software |
$59,560.00 |
$846.30 |
| Medicare tax |
$67,637.00 |
$69,658.06 |
| Memberships |
$990.00 |
$679.00 |
| Mileage reimbursements |
$2,200.00 |
$28.00 |
| Minor computer hardware |
$175,727.00 |
$76,838.95 |
| Office supplies |
$600.00 |
$71.36 |
| On call hours |
$0.00 |
$31,269.00 |
| Overtime |
$29,280.00 |
$41,673.20 |
| Parental Leave |
$0.00 |
$2,545.60 |
| Personal holiday pay |
$0.00 |
$37,724.61 |
| Phone allowance |
$5,880.00 |
$8,396.95 |
| Professional registration |
$4,300.00 |
$184.00 |
| Regular wages - full-time |
$3,760,116.00 |
$2,861,834.09 |
| Rental-computer hardware |
$1,700,000.00 |
$1,463,508.36 |
| Rental-vehicles/buses |
$23,000.00 |
$15,682.34 |
| Seminar/training fees |
$18,300.00 |
$21,688.96 |
| Services-IT Installations |
$1,250.00 |
$4,042.00 |
| Services-IT staffing |
$1,490,832.00 |
$588,147.78 |
| Services-Software as a Service |
$389,041.00 |
$167,291.07 |
| Sick pay |
$0.00 |
$146,840.30 |
| Small tools/minor equipment |
$35,000.00 |
$32,407.00 |
| Software |
$26,574.00 |
$1,393.75 |
| Stability pay |
$28,400.00 |
$27,000.00 |
| Subscriptions |
$39,080.00 |
$40,488.38 |
| Telephone-base cost |
$0.00 |
$266.96 |
| Telephone-cellular phones |
$20,000.00 |
$22,873.46 |
| Temporary employees |
$870,206.00 |
$1,343,255.39 |
| Terminal pay |
$0.00 |
$1,080.41 |
| Transportation-city veh fuel |
$1,464.00 |
$844.58 |
| Vacation pay |
$0.00 |
$201,522.41 |
| Wireless Communications-maint |
$16,095.00 |
$7,429.76 |
| |
$10,244,237.00 |
$8,629,285.56
|
|
| Infrastructure |
| Administrative leave |
$0.00 |
$25,977.43 |
| Allowances/other pay |
$0.00 |
$15,000.00 |
| Books-library |
$390.00 |
$0.00 |
| Call back time |
$0.00 |
$837.08 |
| Comp time used |
$0.00 |
$250.72 |
| Computer supplies |
$100.00 |
$269.99 |
| Consulting-information technology |
$2,714,690.00 |
$1,559,428.00 |
| Contribution to employees ret |
$710,332.00 |
$633,254.22 |
| Educational travel |
$16,500.00 |
$8,455.44 |
| Emergency leave |
$0.00 |
$7,913.76 |
| Exception vacation |
$0.00 |
$1,488.16 |
| FICA tax |
$540,685.00 |
$475,933.13 |
| Fleet-equip.preventative maint |
$29,306.00 |
$22,838.64 |
| Food/Ice |
$150.00 |
$0.00 |
| Holiday pay |
$0.00 |
$353,582.86 |
| Holidays worked |
$0.00 |
$1,066.49 |
| Insurance-health/life/dental |
$1,180,512.00 |
$956,019.92 |
| Insurance-temporary employees |
$0.00 |
$6,715.05 |
| Interdepartmental Charges |
$1,000.00 |
$7.83 |
| Interdepartmental reimbursements |
($1,130,000.00) |
($1,163,204.42) |
| Interdept-Services Carpentry |
$5,000.00 |
$0.00 |
| Interdept-Services Electrical |
$6,000.00 |
$0.00 |
| Interdept-Services HVAC |
$3,000.00 |
$0.00 |
| Jury leave |
$0.00 |
$933.84 |
| Maintenance-computer hardware |
$3,923,013.00 |
$3,903,056.57 |
| Maintenance-computer software |
$13,965,645.00 |
$12,596,247.06 |
| Maintenance-other equipment |
$12,000.00 |
$17,088.84 |
| Medicare tax |
$126,722.00 |
$111,396.95 |
| Memberships |
$2,950.00 |
$982.00 |
| Mileage reimbursements |
$250.00 |
$129.50 |
| Minor computer hardware |
$65,000.00 |
$41,775.49 |
| Office supplies |
$1,850.00 |
$55.97 |
| On call hours |
$0.00 |
$25,505.00 |
| Overtime |
$16,000.00 |
$17,913.19 |
| Parental Leave |
$0.00 |
$27,335.68 |
| Parking costs |
$0.00 |
$30.00 |
| Personal holiday pay |
$0.00 |
$81,647.17 |
| Phone allowance |
$37,500.00 |
$47,203.78 |
| Professional registration |
$3,510.00 |
$179.00 |
| Regular wages - full-time |
$8,183,549.00 |
$6,346,149.01 |
| Seminar/training fees |
$63,350.00 |
$26,649.19 |
| Services-IT Installations |
$302,421.00 |
$415,663.21 |
| Services-IT staffing |
$1,192,800.00 |
$1,232,643.03 |
| Services-Infrastructure as a Service |
$898,000.00 |
$912,149.87 |
| Services-Platform as a Service |
$2,477,351.00 |
$2,183,352.75 |
| Services-Prepared Food and Catering |
$150.00 |
$0.00 |
| Services-Software as a Service |
$3,975,215.00 |
$4,119,215.81 |
| Services-internet/cable |
$825,540.00 |
$1,096,142.84 |
| Sick pay |
$0.00 |
$153,294.89 |
| Small tools/minor equipment |
$41,143.00 |
$13,719.18 |
| Software |
$16,590.00 |
$1,844.95 |
| Stability pay |
$62,300.00 |
$61,300.00 |
| Subscriptions |
$400.00 |
$191.44 |
| Telephone-base cost |
$275,000.00 |
$0.00 |
| Telephone-long distance |
$20,000.00 |
$287.60 |
| Temporary employees |
$456,188.00 |
$310,126.98 |
| Terminal pay |
$0.00 |
$22,158.70 |
| Toll Road - Tx Tag |
$2,000.00 |
$1,850.87 |
| Transportation-city veh fuel |
$4,870.00 |
$2,750.11 |
| Vacation pay |
$0.00 |
$465,525.34 |
| |
$41,028,972.00 |
$37,142,330.11
|
|
| Technology and Strategy |
| Administrative leave |
$0.00 |
$1,181.10 |
| Consulting-information technology |
$1,118,591.00 |
$7,644.00 |
| Contribution to employees ret |
$66,852.00 |
$65,146.05 |
| Educational travel |
$15,000.00 |
$15,635.84 |
| Emergency leave |
$0.00 |
$1,749.12 |
| FICA tax |
$48,601.00 |
$46,432.70 |
| Holiday pay |
$0.00 |
$36,675.84 |
| Insurance-health/life/dental |
$114,772.00 |
$101,529.82 |
| Maintenance-computer software |
$112,000.00 |
$116,567.79 |
| Medicare tax |
$11,364.00 |
$10,859.27 |
| Memberships |
$500.00 |
$200.00 |
| Office supplies |
$500.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$7,872.96 |
| Phone allowance |
$5,700.00 |
$5,482.50 |
| Professional registration |
$500.00 |
$0.00 |
| Regular wages - full-time |
$770,165.00 |
$654,429.74 |
| Seminar/training fees |
$22,225.00 |
$10,392.00 |
| Services-IT staffing |
$890,160.00 |
$755,948.00 |
| Services-Platform as a Service |
$523,920.00 |
$517,622.25 |
| Services-Software as a Service |
$1,491,206.00 |
$1,198,641.97 |
| Sick pay |
$0.00 |
$24,746.89 |
| Software |
$1,500.00 |
$0.00 |
| Stability pay |
$8,000.00 |
$8,000.00 |
| Subscriptions |
$500.00 |
$0.00 |
| Vacation pay |
$0.00 |
$37,184.41 |
| |
$5,202,056.00 |
$3,623,942.25
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Other Requirements |
| Accrued Payroll |
$121,154.00 |
$121,154.00 |
| Contribution to employees ret |
$2,601,290.00 |
$2,501,240.25 |
| Fire/Extend Coverage Insurance |
$262,049.00 |
$192,854.04 |
| |
$2,984,493.00 |
$2,815,248.29
|
|
| Transfers |
| Liability Reserve |
$9,000.00 |
$9,000.00 |
| |
$9,000.00 |
$9,000.00
|
|
|
|
| TOTALS |
$126,006,079.00 |
$110,723,663.72 |
|
