| COMBINED TRANSPORTATION, EMERGENCY & COMMUNICATIONS CTR FUND |
BUDGET |
EXPENDITURES |
| CTECC AND PUBLIC SAFETY IT SUPPORT |
| CTECC Infrastructure and Public Safety |
| Administrative leave |
$0.00 |
$29,204.01 |
| Advertising/publication |
$2,000.00 |
$0.00 |
| Awards and Recognition |
$6,000.00 |
$30.00 |
| Books-library |
$3,194.00 |
$0.00 |
| Call back time |
$0.00 |
$3,119.08 |
| Clothing/clothing material |
$5,000.00 |
$0.00 |
| Computer supplies |
$166,500.00 |
$5,994.03 |
| Consulting-information technology |
$961,000.00 |
$497,400.48 |
| Contribution to employees ret |
$567,124.00 |
$373,336.67 |
| Drainage fee expense |
$15,750.00 |
$10,731.74 |
| Educational travel |
$58,400.00 |
$58,176.93 |
| Electric services |
$631,979.00 |
$369,012.26 |
| Emergency leave |
$0.00 |
$3,584.40 |
| Exception vacation |
$0.00 |
$5,021.11 |
| Expense refunds |
($248,625.00) |
($48,823.00) |
| FICA tax |
$447,815.00 |
$293,232.03 |
| Fleet-equip.preventative maint |
$2,670.00 |
$4,868.40 |
| Food/Ice |
$4,500.00 |
$8,388.17 |
| Garbage/refuse collection |
$551.00 |
$309.60 |
| Holiday pay |
$0.00 |
$207,513.51 |
| Holidays worked |
$0.00 |
$1,450.26 |
| Insurance-health/life/dental |
$934,572.00 |
$591,521.56 |
| Interdepartmental reimbursements |
($220,000.00) |
($164,000.00) |
| Jury leave |
$0.00 |
$284.16 |
| Maintenance-buildings |
$2,291,661.00 |
$746,189.14 |
| Maintenance-computer hardware |
$1,607,850.00 |
$401,073.51 |
| Maintenance-computer software |
$6,744,863.00 |
$6,414,638.97 |
| Maintenance-other equipment |
$287,570.00 |
$79,139.93 |
| Medicare tax |
$104,743.00 |
$68,628.40 |
| Memberships |
$1,000.00 |
$1,063.55 |
| Mileage reimbursements |
$7,050.00 |
$283.50 |
| Minor computer hardware |
$46,767.00 |
$79,642.29 |
| Office supplies |
$17,645.00 |
$74,388.85 |
| On call hours |
$0.00 |
$7,468.00 |
| Other 3rd party billings |
$0.00 |
($122,103.21) |
| Overtime |
$23,147.00 |
$29,248.35 |
| Parental Leave |
$0.00 |
$4,509.60 |
| Personal holiday pay |
$0.00 |
$55,221.37 |
| Personnel savings |
($548,234.00) |
$0.00 |
| Phone allowance |
$34,740.00 |
$25,711.23 |
| Priority mail/parcel services |
$1,000.00 |
$24.86 |
| Regular wages - full-time |
$6,533,685.00 |
$3,733,630.37 |
| Rental-computer hardware |
$200,000.00 |
$41,170.51 |
| Rental-copy machines |
$58,208.00 |
$4,427.35 |
| Rental-real estate-office |
$0.00 |
$40,127.90 |
| Rental-vehicles/buses |
$8,640.00 |
$7,754.99 |
| Security equipment |
$0.00 |
$12,444.16 |
| Seminar/training fees |
$89,535.00 |
$42,794.53 |
| Services-Dumpster Collection |
$0.00 |
$259.80 |
| Services-IT |
$0.00 |
$2,475.00 |
| Services-IT Installations |
$50,000.00 |
$13,520.04 |
| Services-IT staffing |
$836,160.00 |
$421,623.96 |
| Services-Infrastructure as a Service |
$1,023,632.00 |
$532,866.19 |
| Services-Platform as a Service |
$909,945.00 |
$1,205,535.75 |
| Services-Prepared Food and Catering |
$0.00 |
$140.00 |
| Services-Software as a Service |
$2,709,740.00 |
$2,122,915.25 |
| Services-internet/cable |
$113,389.00 |
$50,491.55 |
| Services-security |
$2,355,376.00 |
$1,339,606.66 |
| Sick pay |
$0.00 |
$130,578.25 |
| Small tools/minor equipment |
$74,420.00 |
$7,339.00 |
| 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 |
$344,864.69 |
| Telephone-cellular phones |
$84,120.00 |
$12,416.45 |
| Telephone-long distance |
$15,000.00 |
$2,995.00 |
| Temporary employees |
$614,389.00 |
$359,638.73 |
| Terminal pay |
$0.00 |
$25,690.28 |
| Toll Road - Tx Tag |
$0.00 |
$40.00 |
| Transportation-city veh fuel |
$2,911.00 |
$1,549.03 |
| Vacation pay |
$0.00 |
$209,772.91 |
| Wastewater service |
$10,330.00 |
$8,108.92 |
| Water service |
$19,072.00 |
$10,446.40 |
| |
$30,567,635.00 |
$20,839,866.87
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Other Requirements |
| Accrued Payroll |
$28,821.00 |
$0.00 |
| Contribution to employees ret |
$642,746.00 |
$420,256.83 |
| |
$671,567.00 |
$420,256.83
|
|
| Transfers |
| Liability Reserve |
$2,000.00 |
$2,000.00 |
| Trf to CTM CIP Fund |
$3,162,601.00 |
$1,581,300.50 |
| Workers' Compensation |
$56,132.00 |
$56,132.00 |
| |
$3,220,733.00 |
$1,639,432.50
|
|
|
|
| INFORMATION AND TECHNOLOGY FUND |
BUDGET |
EXPENDITURES |
| COMMUNICATIONS AND TECHNOLOGY MANAGEMENT |
| Applications and Business Transformation Services |
| Administrative leave |
$0.00 |
$37,528.20 |
| Advertising/publication |
$100.00 |
$0.00 |
| Awards and Recognition |
$0.00 |
$30.00 |
| Bilingual Pay |
$1,800.00 |
$1,315.56 |
| Books-library |
$50.00 |
$45.99 |
| Comp time used |
$0.00 |
$2,761.34 |
| Consulting-information technology |
$1,803,718.00 |
$942,484.45 |
| Contribution to employees ret |
$897,692.00 |
$625,621.14 |
| Educational travel |
$72,750.00 |
$36,771.63 |
| Educational/promotional |
$500.00 |
$0.00 |
| Emergency leave |
$0.00 |
$14,385.84 |
| Exception vacation |
$0.00 |
$2,231.03 |
| FICA tax |
$666,610.00 |
$465,591.23 |
| Food/Ice |
$4,250.00 |
$2,543.96 |
| Holiday pay |
$0.00 |
$348,939.82 |
| Holidays worked |
$0.00 |
$342.27 |
| Insurance-health/life/dental |
$1,459,244.00 |
$963,587.36 |
| Jury leave |
$0.00 |
$1,752.67 |
| Maintenance-computer software |
$3,787,978.00 |
$3,546,825.46 |
| Medicare tax |
$156,174.00 |
$109,188.96 |
| Memberships |
$10,850.00 |
$3,525.39 |
| Mileage reimbursements |
$100.00 |
$0.00 |
| Minor computer hardware |
$0.00 |
$3,743.51 |
| Office supplies |
$1,600.00 |
$325.31 |
| Other 3rd party billings |
($381,037.00) |
($199,220.99) |
| Overtime |
$26,500.00 |
$16,012.14 |
| Parental Leave |
$0.00 |
$31,698.96 |
| Parking costs |
$50.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$80,826.62 |
| Phone allowance |
$25,860.00 |
$38,027.15 |
| Professional registration |
$6,000.00 |
$914.97 |
| Regular wages - full-time |
$10,342,039.00 |
$6,196,374.39 |
| Rental-real estate-office |
$0.00 |
$12,352.00 |
| Seminar/training fees |
$164,695.00 |
$65,849.60 |
| Services-IT staffing |
$3,495,075.00 |
$1,807,369.66 |
| 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,207,014.85 |
| Services-testing |
$3,000.00 |
$2,000.00 |
| Sick pay |
$0.00 |
$169,075.67 |
| Small tools/minor equipment |
$500.00 |
$0.00 |
| Software |
$139,800.00 |
$1,469.00 |
| 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 |
$240,235.91 |
| Terminal pay |
$0.00 |
$62,463.78 |
| Trf to CTM CIP Fund |
$0.00 |
$16,120.00 |
| Vacation pay |
$0.00 |
$433,279.19 |
| |
$27,483,181.00 |
$19,365,420.65
|
|
| Customer Service |
| Administrative leave |
$0.00 |
$23,341.09 |
| Awards and Recognition |
$0.00 |
$1,595.00 |
| Books-library |
$150.00 |
$0.00 |
| Call back time |
$0.00 |
$95.58 |
| Comp time used |
$0.00 |
$4,362.80 |
| Computer supplies |
$100.00 |
$0.00 |
| Consulting-information technology |
$187,200.00 |
$0.00 |
| Contribution to employees ret |
$326,374.00 |
$222,931.55 |
| Educational travel |
$31,500.00 |
$15,941.66 |
| Emergency leave |
$0.00 |
$884.64 |
| FICA tax |
$289,200.00 |
$228,574.80 |
| Fleet-equip.preventative maint |
$12,379.00 |
$6,491.20 |
| Food/Ice |
$150.00 |
$0.00 |
| Holiday pay |
$0.00 |
$124,345.91 |
| Holidays worked |
$0.00 |
$2,387.24 |
| Insurance-health/life/dental |
$606,652.00 |
$398,551.84 |
| Jury leave |
$0.00 |
$964.24 |
| Maintenance-computer hardware |
$25,000.00 |
$2,604.00 |
| Maintenance-computer software |
$59,560.00 |
$846.30 |
| Medicare tax |
$67,637.00 |
$53,456.98 |
| Memberships |
$990.00 |
$510.00 |
| Mileage reimbursements |
$2,200.00 |
$28.00 |
| Minor computer hardware |
$175,727.00 |
$63,576.94 |
| Office supplies |
$600.00 |
$39.50 |
| On call hours |
$0.00 |
$18,393.00 |
| Overtime |
$29,280.00 |
$34,132.38 |
| Parental Leave |
$0.00 |
$2,545.60 |
| Personal holiday pay |
$0.00 |
$28,019.42 |
| Phone allowance |
$5,880.00 |
$6,364.27 |
| Professional registration |
$4,300.00 |
$184.00 |
| Regular wages - full-time |
$3,760,116.00 |
$2,209,556.20 |
| Rental-computer hardware |
$1,700,000.00 |
$1,463,508.36 |
| Rental-vehicles/buses |
$23,000.00 |
$10,488.33 |
| Seminar/training fees |
$18,300.00 |
$16,687.73 |
| Services-IT Installations |
$1,250.00 |
$3,868.00 |
| Services-IT staffing |
$1,490,832.00 |
$463,748.15 |
| Services-Software as a Service |
$389,041.00 |
$149,586.77 |
| Sick pay |
$0.00 |
$106,015.62 |
| Small tools/minor equipment |
$35,000.00 |
$27,969.68 |
| Software |
$26,574.00 |
$1,393.75 |
| Stability pay |
$28,400.00 |
$27,000.00 |
| Subscriptions |
$39,080.00 |
$31,725.00 |
| Telephone-base cost |
$0.00 |
$266.96 |
| Telephone-cellular phones |
$20,000.00 |
$18,081.28 |
| Temporary employees |
$870,206.00 |
$1,045,738.77 |
| Terminal pay |
$0.00 |
$21.49 |
| Transportation-city veh fuel |
$1,464.00 |
$662.41 |
| Vacation pay |
$0.00 |
$144,283.93 |
| Wireless Communications-maint |
$16,095.00 |
$5,988.66 |
| |
$10,244,237.00 |
$6,967,759.03
|
|
| Infrastructure |
| Administrative leave |
$0.00 |
$21,668.51 |
| Allowances/other pay |
$0.00 |
$11,250.00 |
| Books-library |
$390.00 |
$0.00 |
| Call back time |
$0.00 |
$214.98 |
| Comp time used |
$0.00 |
$250.72 |
| Computer supplies |
$100.00 |
$269.99 |
| Consulting-information technology |
$2,714,690.00 |
$1,173,780.00 |
| Contribution to employees ret |
$710,332.00 |
$477,026.85 |
| Educational travel |
$16,500.00 |
$2,478.93 |
| Emergency leave |
$0.00 |
$7,627.12 |
| FICA tax |
$540,685.00 |
$359,145.25 |
| Fleet-equip.preventative maint |
$29,306.00 |
$16,609.92 |
| Food/Ice |
$150.00 |
$0.00 |
| Holiday pay |
$0.00 |
$261,749.21 |
| Holidays worked |
$0.00 |
$1,066.49 |
| Insurance-health/life/dental |
$1,180,512.00 |
$742,239.74 |
| Interdepartmental Charges |
$1,000.00 |
$7.83 |
| Interdepartmental reimbursements |
($1,130,000.00) |
($784,696.28) |
| 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 |
$3,923,013.00 |
$3,355,161.97 |
| Maintenance-computer software |
$13,965,645.00 |
$12,474,608.35 |
| Maintenance-other equipment |
$12,000.00 |
$7,412.35 |
| Medicare tax |
$126,722.00 |
$84,083.69 |
| Memberships |
$2,950.00 |
$847.00 |
| Mileage reimbursements |
$250.00 |
$129.50 |
| Minor computer hardware |
$65,000.00 |
$36,360.04 |
| Office supplies |
$1,850.00 |
$55.97 |
| On call hours |
$0.00 |
$15,450.00 |
| Overtime |
$16,000.00 |
$12,608.94 |
| Parental Leave |
$0.00 |
$13,573.12 |
| Parking costs |
$0.00 |
$30.00 |
| Personal holiday pay |
$0.00 |
$67,830.84 |
| Phone allowance |
$37,500.00 |
$36,238.66 |
| Professional registration |
$3,510.00 |
$179.00 |
| Regular wages - full-time |
$8,183,549.00 |
$4,781,773.65 |
| Seminar/training fees |
$63,350.00 |
$20,098.97 |
| Services-IT Installations |
$302,421.00 |
$204,971.35 |
| Services-IT staffing |
$1,192,800.00 |
$722,966.33 |
| Services-Infrastructure as a Service |
$898,000.00 |
$904,017.77 |
| Services-Platform as a Service |
$2,477,351.00 |
$1,809,249.21 |
| Services-Prepared Food and Catering |
$150.00 |
$0.00 |
| Services-Software as a Service |
$3,975,215.00 |
$2,739,589.79 |
| Services-internet/cable |
$825,540.00 |
$978,331.71 |
| Sick pay |
$0.00 |
$117,632.87 |
| Small tools/minor equipment |
$41,143.00 |
$12,725.47 |
| 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 |
$207.12 |
| Temporary employees |
$456,188.00 |
$253,807.62 |
| Terminal pay |
$0.00 |
$22,158.70 |
| Toll Road - Tx Tag |
$2,000.00 |
$1,220.87 |
| Transportation-city veh fuel |
$4,870.00 |
$1,864.70 |
| Vacation pay |
$0.00 |
$331,112.29 |
| |
$41,028,972.00 |
$31,360,323.50
|
|
| Technology and Strategy |
| Administrative leave |
$0.00 |
$598.06 |
| Consulting-information technology |
$1,118,591.00 |
$5,669.25 |
| Contribution to employees ret |
$66,852.00 |
$49,613.85 |
| Educational travel |
$15,000.00 |
$11,496.13 |
| Emergency leave |
$0.00 |
$1,749.12 |
| FICA tax |
$48,601.00 |
$35,362.55 |
| Holiday pay |
$0.00 |
$27,506.88 |
| Insurance-health/life/dental |
$114,772.00 |
$79,458.12 |
| Maintenance-computer software |
$112,000.00 |
$30,960.55 |
| Medicare tax |
$11,364.00 |
$8,270.28 |
| Memberships |
$500.00 |
$200.00 |
| Office supplies |
$500.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$5,702.96 |
| Phone allowance |
$5,700.00 |
$4,166.70 |
| Professional registration |
$500.00 |
$0.00 |
| Regular wages - full-time |
$770,165.00 |
$492,864.80 |
| Seminar/training fees |
$22,225.00 |
$10,392.00 |
| Services-IT staffing |
$890,160.00 |
$552,754.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 |
$22,452.73 |
| Software |
$1,500.00 |
$0.00 |
| Stability pay |
$8,000.00 |
$8,000.00 |
| Subscriptions |
$500.00 |
$0.00 |
| Vacation pay |
$0.00 |
$29,586.25 |
| |
$5,202,056.00 |
$3,093,068.45
|
|
|
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$26,698.46 |
| Advertising/publication |
$800.00 |
$0.00 |
| Allowances/other pay |
$0.00 |
$15,000.00 |
| Awards and Recognition |
$22,000.00 |
$22,174.38 |
| Books-library |
$0.00 |
$149.00 |
| Computer supplies |
$50.00 |
$0.00 |
| Consulting-information technology |
$833,203.00 |
$883,004.00 |
| Contribution to employees ret |
$270,475.00 |
$190,749.43 |
| Educational travel |
$21,732.00 |
$18,939.54 |
| Educational/promotional |
$5,200.00 |
$6,940.49 |
| Electric services |
$62,851.00 |
$11,683.87 |
| Emergency leave |
$0.00 |
$4,486.80 |
| Employee recruiting |
$2,000.00 |
$4,897.30 |
| Exception vacation |
$0.00 |
$1,522.60 |
| FICA tax |
$204,771.00 |
$142,983.58 |
| Federal unemployment tax co |
$15,000.00 |
$5,657.28 |
| Fleet-equip.preventative maint |
$3,093.00 |
$1,622.80 |
| Food/Ice |
$1,000.00 |
$26,135.90 |
| Holiday pay |
$0.00 |
$105,213.34 |
| Holidays worked |
$0.00 |
$1,782.17 |
| Insurance-health/life/dental |
$508,276.00 |
$343,057.28 |
| Insurance-temporary employees |
$88,184.00 |
$0.00 |
| Interdepartmental Charges |
$4,500.00 |
$0.00 |
| Maintenance-buildings |
$25,000.00 |
$7,721.75 |
| Maintenance-computer hardware |
$0.00 |
$1,102.70 |
| Maintenance-computer software |
$1,200.00 |
$0.00 |
| Medicare tax |
$49,230.00 |
$34,313.78 |
| Memberships |
$2,500.00 |
$1,370.00 |
| Mileage reimbursements |
$100.00 |
$0.00 |
| Minor computer hardware |
$0.00 |
$4,440.00 |
| Office furnishings |
$52,789.00 |
$294.95 |
| Office supplies |
$5,500.00 |
$1,568.06 |
| Overtime |
$3,000.00 |
$2,484.90 |
| Parking costs |
$0.00 |
$10.00 |
| Personal holiday pay |
$0.00 |
$27,229.92 |
| Personnel savings |
($3,227,073.00) |
$0.00 |
| Phone allowance |
$11,760.00 |
$8,602.46 |
| 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 |
$45.00 |
| Regular wages - full-time |
$3,116,027.00 |
$1,887,499.77 |
| Rental-copy machines |
$36,272.00 |
$1,098,890.67 |
| Rental-real estate-office |
$2,039,392.00 |
$531,190.34 |
| Seminar/training fees |
$30,000.00 |
$12,769.31 |
| Services-Dumpster Collection |
$500.00 |
$61.80 |
| Services-IT Installations |
$0.00 |
$33,493.80 |
| Services-IT staffing |
$0.00 |
$100,204.00 |
| Services-Platform as a Service |
$250.00 |
$0.00 |
| Services-Prepared Food and Catering |
$4,167.00 |
$1,742.97 |
| 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 |
$62,446.31 |
| 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 |
$15,477.01 |
| Temporary employees |
$246,406.00 |
$131,047.72 |
| Terminal pay |
$109,000.00 |
$0.00 |
| Training-basics |
$3,000.00 |
$349.00 |
| Transportation-city veh fuel |
$219.00 |
$79.51 |
| Vacation pay |
$0.00 |
$119,632.55 |
| |
$4,594,205.00 |
$5,997,819.41
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Other Requirements |
| Accrued Payroll |
$121,154.00 |
$0.00 |
| Contribution to employees ret |
$2,601,290.00 |
$1,700,843.37 |
| Fire/Extend Coverage Insurance |
$262,049.00 |
$192,854.04 |
| |
$2,984,493.00 |
$1,893,697.41
|
|
| Transfers |
| Liability Reserve |
$9,000.00 |
$9,000.00 |
| |
$9,000.00 |
$9,000.00
|
|
|
|
| TOTALS |
$126,006,079.00 |
$91,586,644.65 |
|
