| COMBINED TRANSPORTATION, EMERGENCY & COMMUNICATIONS CTR FUND |
BUDGET |
EXPENDITURES |
| CTECC AND PUBLIC SAFETY IT SUPPORT |
| CTECC Infrastructure and Public Safety |
| Administrative leave |
$0.00 |
$39,859.30 |
| Advertising/publication |
$2,000.00 |
$0.00 |
| Awards and Recognition |
$6,000.00 |
$4,862.94 |
| Backcharged salary & fringes |
$0.00 |
$42,073.69 |
| Books-library |
$3,194.00 |
$3,480.00 |
| Call back time |
$0.00 |
$5,278.21 |
| Clothing/clothing material |
$5,000.00 |
$0.00 |
| Computer Hardware |
$0.00 |
$19,761.17 |
| Computer supplies |
$166,500.00 |
$16,951.85 |
| Consulting-information technology |
$961,000.00 |
$606,810.78 |
| Contribution to employees ret |
$567,124.00 |
$508,613.23 |
| Drainage fee expense |
$15,750.00 |
$16,190.38 |
| Educational travel |
$58,400.00 |
$85,912.19 |
| Electric services |
$631,979.00 |
$588,138.51 |
| 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 |
$400,541.83 |
| Fleet-equip.preventative maint |
$2,670.00 |
$6,565.58 |
| Food/Ice |
$4,500.00 |
$8,465.28 |
| Garbage/refuse collection |
$551.00 |
$464.40 |
| Holiday pay |
$0.00 |
$276,992.58 |
| Holidays worked |
$0.00 |
$2,082.10 |
| Insurance-health/life/dental |
$934,572.00 |
$934,572.00 |
| Insurance-temporary employees |
$0.00 |
$7,162.72 |
| Interdepartmental reimbursements |
($220,000.00) |
($164,236.25) |
| Jury leave |
$0.00 |
$284.16 |
| Maintenance-buildings |
$2,291,661.00 |
$1,982,939.75 |
| Maintenance-computer hardware |
$1,607,850.00 |
$756,707.93 |
| Maintenance-computer software |
$6,744,863.00 |
$6,546,444.72 |
| Maintenance-other equipment |
$287,570.00 |
$79,139.93 |
| Medicare tax |
$104,743.00 |
$93,725.00 |
| Memberships |
$1,000.00 |
$1,835.55 |
| Mileage reimbursements |
$7,050.00 |
$396.76 |
| Minor computer hardware |
$46,767.00 |
$96,654.09 |
| Office supplies |
$17,645.00 |
$77,057.89 |
| On call hours |
$0.00 |
$13,540.00 |
| Other 3rd party billings |
$0.00 |
($244,206.42) |
| Overtime |
$23,147.00 |
$39,383.50 |
| Parental Leave |
$0.00 |
$26,606.64 |
| Personal holiday pay |
$0.00 |
$70,424.75 |
| Personnel savings |
($548,234.00) |
$0.00 |
| Phone allowance |
$34,740.00 |
$35,051.19 |
| Priority mail/parcel services |
$1,000.00 |
$177.61 |
| Regular wages - full-time |
$6,533,685.00 |
$5,088,517.96 |
| Rental-computer hardware |
$200,000.00 |
$47,284.36 |
| Rental-copy machines |
$58,208.00 |
$52,229.63 |
| Rental-real estate-office |
$0.00 |
$40,127.90 |
| Rental-vehicles/buses |
$8,640.00 |
$11,648.99 |
| Security equipment |
$0.00 |
$144,567.30 |
| Seminar/training fees |
$89,535.00 |
$51,891.53 |
| Services-Dumpster Collection |
$0.00 |
$419.88 |
| Services-IT |
$0.00 |
$29,424.00 |
| Services-IT Installations |
$50,000.00 |
$16,427.44 |
| Services-IT staffing |
$836,160.00 |
$599,289.71 |
| Services-Infrastructure as a Service |
$1,023,632.00 |
$532,866.19 |
| Services-Platform as a Service |
$909,945.00 |
$1,411,121.54 |
| Services-Prepared Food and Catering |
$0.00 |
$140.00 |
| Services-Software as a Service |
$2,709,740.00 |
$2,479,122.40 |
| Services-internet/cable |
$113,389.00 |
$97,082.44 |
| Services-security |
$2,355,376.00 |
$1,833,615.07 |
| Sick pay |
$0.00 |
$176,069.83 |
| Small tools/minor equipment |
$74,420.00 |
$18,736.78 |
| Software |
$33,000.00 |
$1,359.46 |
| Stability pay |
$40,800.00 |
$37,800.00 |
| Subscriptions |
$500.00 |
$184.00 |
| Telephone-base cost |
$826,551.00 |
$412,234.36 |
| Telephone-cellular phones |
$84,120.00 |
$24,790.87 |
| Telephone-long distance |
$15,000.00 |
$2,995.00 |
| Temporary employees |
$614,389.00 |
$500,688.78 |
| Terminal pay |
$0.00 |
$25,690.28 |
| Toll Road - Tx Tag |
$0.00 |
$85.20 |
| Transportation-city veh fuel |
$2,911.00 |
$2,260.81 |
| Vacation pay |
$0.00 |
$297,928.04 |
| Wastewater service |
$10,330.00 |
$11,921.14 |
| Water service |
$19,072.00 |
$18,292.82 |
| |
$30,567,635.00 |
$26,916,433.96
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Other Requirements |
| Accrued Payroll |
$28,821.00 |
$28,821.00 |
| Contribution to employees ret |
$642,746.00 |
$642,745.74 |
| |
$671,567.00 |
$671,566.74
|
|
| Transfers |
| Liability Reserve |
$2,000.00 |
$2,000.00 |
| Trf to CTM CIP Fund |
$3,162,601.00 |
$3,162,601.00 |
| Workers' Compensation |
$56,132.00 |
$56,132.00 |
| |
$3,220,733.00 |
$3,220,733.00
|
|
|
|
| INFORMATION AND TECHNOLOGY FUND |
BUDGET |
EXPENDITURES |
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$36,234.03 |
| Advertising/publication |
$800.00 |
$0.00 |
| Allowances/other pay |
$0.00 |
$15,000.00 |
| Awards and Recognition |
$22,000.00 |
$21,349.59 |
| Books-library |
$0.00 |
$264.00 |
| Comp time used |
$0.00 |
$102.03 |
| Computer supplies |
$50.00 |
$0.00 |
| Consulting-information technology |
$833,203.00 |
$1,224,814.00 |
| Contribution to employees ret |
$270,475.00 |
$260,073.79 |
| Educational travel |
$21,732.00 |
$36,806.85 |
| Educational/promotional |
$5,200.00 |
$7,938.56 |
| Electric services |
$62,851.00 |
$12,750.60 |
| 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 |
$196,747.09 |
| Federal unemployment tax co |
$15,000.00 |
$11,604.70 |
| Fleet-equip.preventative maint |
$3,093.00 |
$2,434.20 |
| Food/Ice |
$1,000.00 |
$26,170.23 |
| Holiday pay |
$0.00 |
$140,481.38 |
| Holidays worked |
$0.00 |
$2,738.97 |
| Insurance-health/life/dental |
$508,276.00 |
$508,276.00 |
| Insurance-temporary employees |
$88,184.00 |
$5,372.04 |
| 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 |
$47,019.03 |
| Memberships |
$2,500.00 |
$2,245.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,794.81 |
| Parental Leave |
$0.00 |
$8,733.76 |
| Parking costs |
$0.00 |
$10.00 |
| Personal holiday pay |
$0.00 |
$34,197.80 |
| Personnel savings |
($3,227,073.00) |
$0.00 |
| Phone allowance |
$11,760.00 |
$11,882.80 |
| Postage |
$100.00 |
$0.00 |
| Printing/binding/photo/repr |
$250.00 |
$26.75 |
| Priority mail/parcel services |
$75.00 |
$10.95 |
| Professional registration |
$700.00 |
$229.00 |
| Regular wages - full-time |
$3,116,027.00 |
$2,566,177.19 |
| Rental-copy machines |
$36,272.00 |
($425,255.88) |
| Rental-real estate-office |
$2,039,392.00 |
$671,629.34 |
| Seminar/training fees |
$30,000.00 |
$25,399.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,374.48 |
| 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 |
$88,228.99 |
| 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 |
$26,779.87 |
| Temporary employees |
$246,406.00 |
$200,205.89 |
| Terminal pay |
$109,000.00 |
$0.00 |
| Training-basics |
$3,000.00 |
$349.00 |
| Transportation-city veh fuel |
$219.00 |
$138.67 |
| Vacation pay |
$0.00 |
$175,751.59 |
| |
$4,594,205.00 |
$6,273,718.56
|
|
|
| TECHNOLOGY SERVICES |
| Applications and Business Transformation Services |
| Administrative leave |
$0.00 |
$48,510.26 |
| Advertising/publication |
$100.00 |
$0.00 |
| Awards and Recognition |
$0.00 |
$60.00 |
| Backcharged salary & fringes |
$0.00 |
($42,073.69) |
| Bilingual Pay |
$1,800.00 |
$2,007.96 |
| Books-library |
$50.00 |
$45.99 |
| Comp time used |
$0.00 |
$3,708.49 |
| Consulting-information technology |
$1,803,718.00 |
$1,389,212.22 |
| Contribution to employees ret |
$897,692.00 |
$848,757.86 |
| Educational travel |
$72,750.00 |
$75,651.21 |
| 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 |
$631,942.95 |
| Food/Ice |
$4,250.00 |
$3,592.55 |
| Holiday pay |
$0.00 |
$461,508.72 |
| Holidays worked |
$0.00 |
$2,056.52 |
| Insurance-health/life/dental |
$1,459,244.00 |
$1,459,244.00 |
| Insurance-temporary employees |
$0.00 |
$7,162.72 |
| Jury leave |
$0.00 |
$2,023.95 |
| Maintenance-computer software |
$3,787,978.00 |
$3,790,693.56 |
| Medicare tax |
$156,174.00 |
$148,093.79 |
| Memberships |
$10,850.00 |
$8,467.25 |
| 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) |
($398,441.98) |
| Overtime |
$26,500.00 |
$18,693.37 |
| Parental Leave |
$0.00 |
$31,698.96 |
| Parking costs |
$50.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$104,512.97 |
| Phone allowance |
$25,860.00 |
$52,171.88 |
| Professional registration |
$6,000.00 |
$1,333.97 |
| Regular wages - full-time |
$10,342,039.00 |
$8,469,959.02 |
| Rental-real estate-office |
$0.00 |
$17,187.06 |
| Seminar/training fees |
$164,695.00 |
$85,759.58 |
| Services-IT staffing |
$3,495,075.00 |
$2,805,545.80 |
| Services-Platform as a Service |
$200,000.00 |
$0.00 |
| Services-Prepared Food and Catering |
$1,500.00 |
$139.54 |
| Services-Software as a Service |
$4,186,203.00 |
$3,379,736.47 |
| Services-testing |
$3,000.00 |
$2,000.00 |
| Sick pay |
$0.00 |
$239,176.36 |
| 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 |
$1,825.58 |
| Telephone-long distance |
$100.00 |
$0.00 |
| Temporary employees |
$325,080.00 |
$338,312.31 |
| Terminal pay |
$0.00 |
$62,463.78 |
| Trf to CTM CIP Fund |
$0.00 |
$16,120.00 |
| Vacation pay |
$0.00 |
$576,206.85 |
| |
$27,483,181.00 |
$24,753,022.46
|
|
| Customer Service |
| Administrative leave |
$0.00 |
$37,855.19 |
| 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,223.21 |
| Computer supplies |
$100.00 |
$0.00 |
| Consulting-information technology |
$187,200.00 |
$0.00 |
| Contribution to employees ret |
$326,374.00 |
$301,804.83 |
| Educational travel |
$31,500.00 |
$35,580.69 |
| Emergency leave |
$0.00 |
$4,192.32 |
| FICA tax |
$289,200.00 |
$313,649.50 |
| Fleet-equip.preventative maint |
$12,379.00 |
$9,736.80 |
| Food/Ice |
$150.00 |
$25.16 |
| Holiday pay |
$0.00 |
$170,757.28 |
| Holidays worked |
$0.00 |
$3,219.16 |
| Insurance-health/life/dental |
$606,652.00 |
$606,652.00 |
| Insurance-temporary employees |
$0.00 |
$46,557.68 |
| 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 |
$73,353.47 |
| Memberships |
$990.00 |
$818.00 |
| Mileage reimbursements |
$2,200.00 |
$50.40 |
| Minor computer hardware |
$175,727.00 |
$76,838.95 |
| Office supplies |
$600.00 |
$71.36 |
| On call hours |
$0.00 |
$34,549.00 |
| Overtime |
$29,280.00 |
$44,725.02 |
| Parental Leave |
$0.00 |
$2,545.60 |
| Personal holiday pay |
$0.00 |
$38,043.01 |
| Phone allowance |
$5,880.00 |
$8,731.69 |
| Professional registration |
$4,300.00 |
$184.00 |
| Regular wages - full-time |
$3,760,116.00 |
$2,976,253.34 |
| Rental-computer hardware |
$1,700,000.00 |
$1,461,428.95 |
| Rental-vehicles/buses |
$23,000.00 |
$17,516.12 |
| Seminar/training fees |
$18,300.00 |
$22,821.95 |
| Services-IT Installations |
$1,250.00 |
$4,042.00 |
| Services-IT staffing |
$1,490,832.00 |
$634,827.28 |
| Services-Software as a Service |
$389,041.00 |
$172,850.92 |
| Sick pay |
$0.00 |
$155,248.48 |
| Small tools/minor equipment |
$35,000.00 |
$36,456.78 |
| 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 |
$27,433.22 |
| Temporary employees |
$870,206.00 |
$1,460,527.46 |
| Terminal pay |
$0.00 |
$1,080.41 |
| Transportation-city veh fuel |
$1,464.00 |
$931.60 |
| Vacation pay |
$0.00 |
$210,653.38 |
| Wireless Communications-maint |
$16,095.00 |
$8,113.23 |
| |
$10,244,237.00 |
$9,098,539.55
|
|
| Infrastructure |
| Administrative leave |
$0.00 |
$27,109.11 |
| 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 |
$670.73 |
| Consulting-information technology |
$2,714,690.00 |
$1,622,205.00 |
| Contribution to employees ret |
$710,332.00 |
$659,821.56 |
| Educational travel |
$16,500.00 |
$12,120.21 |
| Emergency leave |
$0.00 |
$7,913.76 |
| Exception vacation |
$0.00 |
$1,488.16 |
| FICA tax |
$540,685.00 |
$496,089.84 |
| Fleet-equip.preventative maint |
$29,306.00 |
$24,914.88 |
| Food/Ice |
$150.00 |
$0.00 |
| Holiday pay |
$0.00 |
$354,483.10 |
| Holidays worked |
$0.00 |
$1,066.49 |
| Insurance-health/life/dental |
$1,180,512.00 |
$1,180,512.00 |
| Insurance-temporary employees |
$0.00 |
$7,610.39 |
| Interdepartmental Charges |
$1,000.00 |
$7.83 |
| Interdepartmental reimbursements |
($1,130,000.00) |
($1,612,943.72) |
| 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,910,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 |
$116,111.01 |
| Memberships |
$2,950.00 |
$1,112.00 |
| Mileage reimbursements |
$250.00 |
$129.50 |
| Minor computer hardware |
$65,000.00 |
$42,287.49 |
| Office supplies |
$1,850.00 |
$268.00 |
| On call hours |
$0.00 |
$27,461.00 |
| Overtime |
$16,000.00 |
$18,815.13 |
| Parental Leave |
$0.00 |
$28,646.40 |
| Parking costs |
$0.00 |
$30.00 |
| Personal holiday pay |
$0.00 |
$83,402.61 |
| Phone allowance |
$37,500.00 |
$49,045.92 |
| Professional registration |
$3,510.00 |
$179.00 |
| Regular wages - full-time |
$8,183,549.00 |
$6,639,402.21 |
| Seminar/training fees |
$63,350.00 |
$26,649.19 |
| Services-IT Installations |
$302,421.00 |
$397,625.66 |
| Services-IT staffing |
$1,192,800.00 |
$1,289,227.07 |
| Services-Infrastructure as a Service |
$898,000.00 |
$1,267,555.31 |
| Services-Platform as a Service |
$2,477,351.00 |
$2,228,172.88 |
| Services-Prepared Food and Catering |
$150.00 |
$0.00 |
| Services-Software as a Service |
$3,975,215.00 |
$5,109,090.81 |
| Services-internet/cable |
$825,540.00 |
$1,140,764.30 |
| Sick pay |
$0.00 |
$160,792.35 |
| Small tools/minor equipment |
$41,143.00 |
$14,621.49 |
| Software |
$16,590.00 |
$2,087.46 |
| 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 |
$306.53 |
| Temporary employees |
$456,188.00 |
$327,550.56 |
| Terminal pay |
$0.00 |
$22,158.70 |
| Toll Road - Tx Tag |
$2,000.00 |
$2,211.90 |
| Transportation-city veh fuel |
$4,870.00 |
$3,041.51 |
| Vacation pay |
$0.00 |
$475,515.14 |
| |
$41,028,972.00 |
$38,859,236.02
|
|
| 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 |
$67,734.75 |
| Educational travel |
$15,000.00 |
$19,698.62 |
| Emergency leave |
$0.00 |
$1,749.12 |
| FICA tax |
$48,601.00 |
$48,268.60 |
| Holiday pay |
$0.00 |
$36,675.84 |
| Insurance-health/life/dental |
$114,772.00 |
$114,772.00 |
| Maintenance-computer software |
$112,000.00 |
$116,567.79 |
| Medicare tax |
$11,364.00 |
$11,288.64 |
| 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,701.80 |
| Professional registration |
$500.00 |
$0.00 |
| Regular wages - full-time |
$770,165.00 |
$680,905.11 |
| Seminar/training fees |
$22,225.00 |
$10,392.00 |
| Services-IT staffing |
$890,160.00 |
$766,588.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 |
$27,053.53 |
| Software |
$1,500.00 |
$0.00 |
| Stability pay |
$8,000.00 |
$8,000.00 |
| Subscriptions |
$500.00 |
$0.00 |
| Vacation pay |
$0.00 |
$38,965.61 |
| |
$5,202,056.00 |
$3,687,523.69
|
|
|
| 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,601,289.86 |
| Fire/Extend Coverage Insurance |
$262,049.00 |
$192,854.04 |
| |
$2,984,493.00 |
$2,915,297.90
|
|
| Transfers |
| Liability Reserve |
$9,000.00 |
$9,000.00 |
| |
$9,000.00 |
$9,000.00
|
|
|
|
| TOTALS |
$126,006,079.00 |
$116,405,071.88 |
|
