COMBINED TRANSPORTATION, EMERGENCY & COMMUNICATIONS CTR FUND |
BUDGET |
EXPENDITURES |
CTECC AND PUBLIC SAFETY IT SUPPORT |
CTECC Infrastructure and Public Safety |
Administrative leave |
$0.00 |
$12,288.75 |
Advertising/publication |
$2,000.00 |
$0.00 |
Awards and Recognition |
$3,705.00 |
$151.99 |
Books-library |
$3,194.00 |
$292.90 |
Call back time |
$0.00 |
$1,700.23 |
Clothing/clothing material |
$5,000.00 |
$0.00 |
Computer supplies |
$6,500.00 |
$2,675.42 |
Consulting-information technology |
$521,000.00 |
$48,192.29 |
Contribution to employees ret |
$761,632.00 |
$364,043.64 |
Drainage fee expense |
$15,000.00 |
$6,111.31 |
Educational travel |
$55,000.00 |
$9,276.98 |
Electric services |
$601,885.00 |
$207,586.48 |
Emergency leave |
$0.00 |
$3,964.80 |
Expense refunds |
($262,988.00) |
($62,988.00) |
FICA tax |
$408,795.00 |
$163,537.57 |
Federal unemployment tax co |
$0.00 |
$5,050.06 |
Fleet-equip.preventative maint |
$2,009.00 |
$2,886.05 |
Food/Ice |
$4,500.00 |
$408.07 |
Garbage/refuse collection |
$525.00 |
$197.60 |
Holiday pay |
$0.00 |
$162,615.45 |
Holidays worked |
$0.00 |
$565.37 |
Insurance-health/life/dental |
$849,642.00 |
$358,984.24 |
Insurance-temporary employees |
$0.00 |
$6,848.28 |
Interdepartmental reimbursements |
($164,000.00) |
$0.00 |
Jury leave |
$0.00 |
$428.08 |
Maintenance-aux gen equipment |
$146,814.00 |
$0.00 |
Maintenance-buildings |
$2,083,328.00 |
$685,555.13 |
Maintenance-chillers |
$161,158.00 |
$0.00 |
Maintenance-computer hardware |
$1,593,850.00 |
$430,077.33 |
Maintenance-computer software |
$5,640,001.00 |
$5,001,473.92 |
Maintenance-other equipment |
$272,013.00 |
$204,048.92 |
Medicare tax |
$95,654.00 |
$38,306.16 |
Memberships |
$0.00 |
$179.00 |
Mileage reimbursements |
$7,050.00 |
$13.40 |
Minor computer hardware |
$46,767.00 |
$3,264.84 |
Office supplies |
$17,645.00 |
$1,406.36 |
Other 3rd party billings |
$0.00 |
($60,281.28) |
Overtime |
$23,147.00 |
$15,666.15 |
Parental Leave |
$0.00 |
$19,304.80 |
Personal holiday pay |
$0.00 |
$14,913.56 |
Personnel savings |
($275,907.00) |
$0.00 |
Phone allowance |
$28,980.00 |
$16,642.87 |
Priority mail/parcel services |
$1,000.00 |
$0.00 |
Regular wages - full-time |
$6,133,257.00 |
$2,051,634.13 |
Rental-computer hardware |
$200,000.00 |
$49,035.56 |
Rental-copy machines |
$58,208.00 |
$0.00 |
Rental-vehicles/buses |
$8,640.00 |
$4,557.00 |
Security equipment |
$0.00 |
$74,548.56 |
Seminar/training fees |
$88,741.00 |
$6,799.01 |
Services-IT |
$0.00 |
$54,687.50 |
Services-IT Installations |
$50,000.00 |
$16,921.79 |
Services-IT staffing |
$490,880.00 |
$174,731.04 |
Services-Infrastructure as a Service |
$957,632.00 |
$453,719.43 |
Services-Platform as a Service |
$909,945.00 |
$974,551.21 |
Services-Software as a Service |
$2,420,670.00 |
$894,981.11 |
Services-internet/cable |
$70,189.00 |
$24,370.99 |
Services-security |
$2,163,249.00 |
$486,698.80 |
Sick pay |
$0.00 |
$76,714.31 |
Small tools/minor equipment |
$74,420.00 |
$208.48 |
Software |
$33,000.00 |
$907.20 |
Stability pay |
$43,800.00 |
$38,100.00 |
Telephone-base cost |
$826,551.00 |
$93,893.37 |
Telephone-cellular phones |
$84,120.00 |
$3,790.38 |
Telephone-long distance |
$15,000.00 |
$2,388.00 |
Temporary employees |
$390,389.00 |
$165,365.58 |
Terminal pay |
$0.00 |
$27,299.27 |
Transportation-city veh fuel |
$1,518.00 |
$988.05 |
Vacation pay |
$0.00 |
$123,503.15 |
Wastewater service |
$9,838.00 |
$4,146.58 |
Water service |
$18,164.00 |
$5,665.13 |
|
$27,703,110.00 |
$13,475,594.35
|
|
|
TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
Other Requirements |
Accrued Payroll |
$27,992.00 |
$0.00 |
Contribution to employees ret |
$455,212.00 |
$0.00 |
|
$483,204.00 |
$0.00
|
|
Transfers |
Liability Reserve |
$2,000.00 |
$0.00 |
Trf to CTM CIP Fund |
$4,648,000.00 |
$2,324,000.00 |
Workers' Compensation |
$51,658.00 |
$0.00 |
|
$4,701,658.00 |
$2,324,000.00
|
|
|
|
INFORMATION AND TECHNOLOGY FUND |
BUDGET |
EXPENDITURES |
COMMUNICATIONS AND TECHNOLOGY MANAGEMENT |
Applications and Business Transformation Services |
Administrative leave |
$0.00 |
$25,900.19 |
Advertising/publication |
$100.00 |
$0.00 |
Awards and Recognition |
$425.00 |
$0.00 |
Bilingual Pay |
$1,800.00 |
$830.88 |
Books-library |
$150.00 |
$0.00 |
Comp time used |
$0.00 |
$1,408.23 |
Computer supplies |
$200.00 |
$0.00 |
Consulting-information technology |
$1,407,680.00 |
$197,168.57 |
Contribution to employees ret |
$1,195,703.00 |
$610,289.01 |
Educational travel |
$74,250.00 |
$17,441.12 |
Educational/promotional |
$500.00 |
$0.00 |
Emergency leave |
$0.00 |
$5,845.52 |
FICA tax |
$637,682.00 |
$267,208.76 |
Food/Ice |
$3,350.00 |
$1,175.52 |
Holiday pay |
$0.00 |
$278,108.33 |
Insurance-health/life/dental |
$1,326,634.00 |
$596,857.88 |
Insurance-temporary employees |
$0.00 |
$4,759.70 |
Interdepartmental reimbursements |
$0.00 |
($2,356.00) |
Jury leave |
$0.00 |
$269.76 |
Maintenance-computer software |
$3,648,464.00 |
$3,047,320.73 |
Medicare tax |
$149,259.00 |
$62,492.32 |
Memberships |
$5,381.00 |
$2,218.87 |
Mileage reimbursements |
$100.00 |
$0.00 |
Minor computer hardware |
$10,000.00 |
$985.72 |
Office supplies |
$2,050.00 |
$109.83 |
Other 3rd party billings |
($381,037.00) |
($98,353.65) |
Overtime |
$20,500.00 |
$8,913.15 |
Parental Leave |
$0.00 |
$1,520.64 |
Parking costs |
$50.00 |
$0.00 |
Personal holiday pay |
$0.00 |
$24,751.00 |
Phone allowance |
$31,260.00 |
$12,306.32 |
Professional registration |
$4,870.00 |
$0.00 |
Regular wages - full-time |
$9,628,743.00 |
$3,409,822.04 |
Rental-real estate-office |
$0.00 |
$7,222.52 |
Seminar/training fees |
$202,195.00 |
$44,754.26 |
Services-IT staffing |
$3,242,322.00 |
$387,296.84 |
Services-Infrastructure as a Service |
$2,000.00 |
$0.00 |
Services-Platform as a Service |
$251,800.00 |
$27,000.00 |
Services-Prepared Food and Catering |
$1,500.00 |
$43.57 |
Services-Software as a Service |
$3,890,408.00 |
$2,560,693.55 |
Services-testing |
$5,000.00 |
$0.00 |
Sick pay |
$0.00 |
$179,157.07 |
Small tools/minor equipment |
$500.00 |
$0.00 |
Software |
$175,060.00 |
$10,786.92 |
Stability pay |
$72,400.00 |
$71,400.00 |
Subscriptions |
$14,000.00 |
$1,875.71 |
Telephone-long distance |
$100.00 |
$0.00 |
Temporary employees |
$558,980.00 |
$143,851.15 |
Terminal pay |
$0.00 |
$4,925.81 |
Trf to CTM CIP Fund |
$0.00 |
$164,156.00 |
Vacation pay |
$0.00 |
$263,743.03 |
|
$26,184,379.00 |
$12,343,900.87
|
|
Customer Service |
Administrative leave |
$0.00 |
$7,506.13 |
Awards and Recognition |
$0.00 |
$300.00 |
Books-library |
$150.00 |
$0.00 |
Call back time |
$0.00 |
$471.60 |
Comp time used |
$0.00 |
$434.34 |
Computer supplies |
$100.00 |
$0.00 |
Consulting-information technology |
$187,200.00 |
$0.00 |
Contribution to employees ret |
$437,837.00 |
$231,238.53 |
Educational travel |
$18,500.00 |
$7,245.58 |
Emergency leave |
$0.00 |
$4,646.16 |
FICA tax |
$266,242.00 |
$122,604.56 |
Fleet-equip.preventative maint |
$16,091.00 |
$4,935.80 |
Food/Ice |
$150.00 |
$0.00 |
Holiday pay |
$0.00 |
$105,192.59 |
Holidays worked |
$0.00 |
$2,466.82 |
Insurance-health/life/dental |
$551,522.00 |
$258,990.36 |
Insurance-temporary employees |
$0.00 |
$18,735.41 |
Maintenance-computer hardware |
$25,000.00 |
$0.00 |
Maintenance-computer software |
$57,150.00 |
$322.74 |
Medicare tax |
$62,266.00 |
$28,673.58 |
Memberships |
$990.00 |
$285.00 |
Mileage reimbursements |
$200.00 |
$680.93 |
Minor computer hardware |
$175,727.00 |
$7,949.97 |
Office supplies |
$600.00 |
$0.00 |
Overtime |
$29,280.00 |
$14,125.70 |
Parental Leave |
$0.00 |
$6,853.28 |
Personal holiday pay |
$0.00 |
$15,701.90 |
Phone allowance |
$5,460.00 |
$2,550.68 |
Professional registration |
$4,000.00 |
$0.00 |
Regular wages - full-time |
$3,525,824.00 |
$1,283,260.33 |
Rental-computer hardware |
$1,700,000.00 |
$749,824.16 |
Rental-vehicles/buses |
$5.00 |
$0.00 |
Seminar/training fees |
$28,300.00 |
$2,120.93 |
Services-IT Installations |
$2,500.00 |
$0.00 |
Services-IT staffing |
$1,498,293.00 |
$334,940.01 |
Services-Software as a Service |
$392,000.00 |
$378,966.58 |
Sick pay |
$0.00 |
$63,894.28 |
Small tools/minor equipment |
$42,000.00 |
$13,522.93 |
Software |
$26,574.00 |
$644.50 |
Stability pay |
$26,000.00 |
$26,500.00 |
Subscriptions |
$39,080.00 |
$30,489.30 |
Telephone-base cost |
$0.00 |
$7,283.00 |
Telephone-cellular phones |
$10,000.00 |
$8,037.20 |
Temporary employees |
$737,004.00 |
$404,761.90 |
Transportation-city veh fuel |
$1,202.00 |
$271.43 |
Trf to CTM CIP Fund |
$0.00 |
$5,400.00 |
Vacation pay |
$0.00 |
$99,556.57 |
Wireless Communications-maint |
$16,095.00 |
$2,825.00 |
|
$9,883,342.00 |
$4,254,209.78
|
|
Infrastructure |
Administrative leave |
$0.00 |
$12,002.02 |
Awards and Recognition |
$250.00 |
$0.00 |
Books-library |
$390.00 |
$0.00 |
Computer supplies |
$3,000.00 |
$67.80 |
Consulting-information technology |
$2,080,760.00 |
$674,374.00 |
Contribution to employees ret |
$1,009,318.00 |
$515,625.81 |
Educational travel |
$15,900.00 |
$1,005.96 |
Emergency leave |
$0.00 |
$2,138.64 |
Exception vacation |
$0.00 |
$2,642.88 |
FICA tax |
$538,728.00 |
$216,984.41 |
Fleet-equip.preventative maint |
$33,883.00 |
$11,672.02 |
Food/Ice |
$150.00 |
$0.00 |
Holiday pay |
$0.00 |
$225,177.67 |
Holidays worked |
$0.00 |
$2,807.60 |
Insurance-health/life/dental |
$1,103,044.00 |
$484,442.40 |
Insurance-temporary employees |
$0.00 |
$5,444.28 |
Interdepartmental Charges |
$1,000.00 |
$0.00 |
Interdepartmental reimbursements |
($1,229,500.00) |
($255,937.44) |
Interdept-Services Carpentry |
$7,000.00 |
$0.00 |
Interdept-Services Electrical |
$6,000.00 |
$0.00 |
Interdept-Services HVAC |
$3,000.00 |
$0.00 |
Jury leave |
$0.00 |
$237.28 |
Maintenance-computer hardware |
$4,002,505.00 |
$721,147.45 |
Maintenance-computer software |
$12,749,772.00 |
$11,644,438.80 |
Maintenance-other equipment |
$0.00 |
$33.98 |
Medicare tax |
$126,049.00 |
$50,746.33 |
Memberships |
$2,950.00 |
$375.00 |
Mileage reimbursements |
$400.00 |
$0.00 |
Minor computer hardware |
$10,000.00 |
$1,939.20 |
Office supplies |
$6,200.00 |
$311.07 |
Overtime |
$20,500.00 |
$8,315.52 |
Parental Leave |
$0.00 |
$4,410.56 |
Personal holiday pay |
$0.00 |
$31,798.89 |
Phone allowance |
$43,620.00 |
$20,095.73 |
Professional registration |
$5,760.00 |
$60.00 |
Regular wages - full-time |
$8,127,849.00 |
$2,771,229.10 |
Seminar/training fees |
$97,000.00 |
$926.00 |
Services-IT Installations |
$301,421.00 |
$41,707.32 |
Services-IT staffing |
$1,349,400.00 |
$510,997.08 |
Services-Infrastructure as a Service |
$860,000.00 |
$427,430.25 |
Services-Platform as a Service |
$2,228,906.00 |
$1,274,492.05 |
Services-Prepared Food and Catering |
$0.00 |
$73.44 |
Services-Software as a Service |
$4,465,137.00 |
$2,896,732.28 |
Services-internet/cable |
$748,465.00 |
$650,981.70 |
Sick pay |
$0.00 |
$83,502.77 |
Small tools/minor equipment |
$112,285.00 |
$5,314.65 |
Software |
$19,930.00 |
$250.00 |
Stability pay |
$69,200.00 |
$65,300.00 |
Subscriptions |
$400.00 |
$0.00 |
Telephone-base cost |
$275,000.00 |
$44,922.91 |
Telephone-long distance |
$5,000.00 |
$227.11 |
Temporary employees |
$451,678.00 |
$158,128.87 |
Terminal pay |
$0.00 |
$59,142.80 |
Toll Road - Tx Tag |
$0.00 |
$691.50 |
Transportation-city veh fuel |
$3,262.00 |
$979.46 |
Trf to CTM CIP Fund |
$0.00 |
$2,660.00 |
Vacation pay |
$0.00 |
$192,082.65 |
|
$39,655,612.00 |
$23,570,129.80
|
|
Technology and Strategy |
Administrative leave |
$0.00 |
$887.58 |
Consulting-information technology |
$754,591.00 |
$1,125.00 |
Contribution to employees ret |
$88,955.00 |
$50,301.49 |
Educational travel |
$30,000.00 |
$582.31 |
Emergency leave |
$0.00 |
$942.72 |
FICA tax |
$45,238.00 |
$21,030.07 |
Holiday pay |
$0.00 |
$22,785.92 |
Insurance-health/life/dental |
$104,342.00 |
$52,170.72 |
Maintenance-computer software |
$88,000.00 |
$32,225.77 |
Medicare tax |
$10,579.00 |
$4,918.32 |
Memberships |
$1,000.00 |
$0.00 |
Office supplies |
$500.00 |
$0.00 |
Personal holiday pay |
$0.00 |
$2,750.32 |
Phone allowance |
$5,700.00 |
$2,856.60 |
Professional registration |
$1,000.00 |
$0.00 |
Regular wages - full-time |
$716,343.00 |
$278,322.92 |
Seminar/training fees |
$44,449.00 |
$313.67 |
Services-IT staffing |
$912,000.00 |
$98,437.00 |
Services-Platform as a Service |
$444,297.00 |
$0.00 |
Services-Software as a Service |
$1,411,539.00 |
$1,154,052.18 |
Sick pay |
$0.00 |
$8,258.06 |
Software |
$1,500.00 |
$0.00 |
Stability pay |
$7,600.00 |
$7,600.00 |
Subscriptions |
$1,000.00 |
$0.00 |
Vacation pay |
$0.00 |
$28,515.68 |
|
$4,668,633.00 |
$1,768,076.33
|
|
|
SUPPORT SERVICES |
Departmental Support Services |
Administrative leave |
$0.00 |
$7,449.68 |
Advertising/publication |
$800.00 |
$0.00 |
Awards and Recognition |
$15,325.00 |
$14,819.46 |
Books-library |
$500.00 |
$0.00 |
Comp time used |
$0.00 |
$80.45 |
Computer supplies |
$2,000.00 |
$0.00 |
Consulting-information technology |
$870,742.00 |
$412,841.00 |
Contribution to employees ret |
$350,709.00 |
$184,810.35 |
Educational travel |
$24,732.00 |
$5,975.15 |
Educational/promotional |
$3,800.00 |
$0.00 |
Electric services |
$62,851.00 |
$13,861.95 |
Emergency leave |
$0.00 |
$1,038.24 |
Employee recruiting |
$10,000.00 |
$0.00 |
FICA tax |
$274,032.00 |
$85,194.53 |
Federal unemployment tax co |
$17,470.00 |
$964.38 |
Fleet-equip.preventative maint |
$4,023.00 |
$1,233.95 |
Food/Ice |
$1,000.00 |
$143.34 |
Holiday pay |
$0.00 |
$84,430.55 |
Holidays worked |
$0.00 |
$579.18 |
Insurance-health/life/dental |
$447,180.00 |
$211,788.28 |
Insurance-temporary employees |
$0.00 |
$1,711.45 |
Interdepartmental Charges |
$4,500.00 |
$0.00 |
Interdeptl-salaries/fringe |
$0.00 |
$46,890.45 |
Jury leave |
$0.00 |
$477.54 |
Maintenance-buildings |
$25,000.00 |
$3,953.00 |
Maintenance-computer software |
$3,000.00 |
$0.00 |
Medicare tax |
$64,917.00 |
$20,490.24 |
Memberships |
$4,150.00 |
$0.00 |
Mileage reimbursements |
$300.00 |
$0.00 |
Office furnishings |
$47,399.00 |
$0.00 |
Office supplies |
$5,620.00 |
$385.37 |
Overtime |
$1,349,738.00 |
$951.57 |
Personal holiday pay |
$0.00 |
$11,808.79 |
Personnel savings |
($6,391,150.00) |
$0.00 |
Phone allowance |
$11,760.00 |
$5,856.52 |
Postage |
$500.00 |
$0.00 |
Printing/binding/photo/repr |
$250.00 |
$0.00 |
Priority mail/parcel services |
$75.00 |
$59.74 |
Professional registration |
$700.00 |
$800.00 |
Regular wages - full-time |
$2,824,191.00 |
$1,031,505.20 |
Rental-copy machines |
$36,272.00 |
$0.00 |
Rental-real estate-office |
$2,055,436.00 |
$1,059,930.92 |
Seminar/training fees |
$28,250.00 |
$49,106.77 |
Services-Dumpster Collection |
$500.00 |
$21.50 |
Services-IT staffing |
$0.00 |
$25,461.00 |
Services-Platform as a Service |
$250.00 |
$119.40 |
Services-Prepared Food and Catering |
$4,167.00 |
$899.76 |
Services-Software as a Service |
$1,440.00 |
$0.00 |
Services-internet/cable |
$1,166.00 |
$320.17 |
Services-security |
$600.00 |
$0.00 |
Sick pay |
$0.00 |
$59,067.74 |
Small tools/minor equipment |
$500.00 |
$0.00 |
Software |
$3,600.00 |
$715.08 |
Stability pay |
$19,700.00 |
$19,200.00 |
Subscriptions |
$2,000.00 |
$0.00 |
Telephone-cellular phones |
$90,000.00 |
$9,165.49 |
Temporary employees |
$1,621,191.00 |
$154,701.00 |
Terminal pay |
$109,000.00 |
$1,206.29 |
Training-basics |
$14,000.00 |
$1,428.00 |
Transportation-city veh fuel |
$97.00 |
$28.03 |
Vacation pay |
$0.00 |
$68,355.36 |
|
$4,024,283.00 |
$3,599,826.87
|
|
|
TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
Other Requirements |
Accrued Payroll |
$113,768.00 |
$0.00 |
Compensation Adjustment |
$8,838.00 |
$0.00 |
Contribution to employees ret |
$1,842,360.00 |
$0.00 |
Fire/Extend Coverage Insurance |
$230,058.00 |
$228,332.86 |
|
$2,195,024.00 |
$228,332.86
|
|
Transfers |
Liability Reserve |
$9,000.00 |
$0.00 |
Trf to CTM CIP Fund |
$4,531,791.00 |
$2,265,895.50 |
|
$4,540,791.00 |
$2,265,895.50
|
|
|
|
TOTALS |
$124,040,036.00 |
$63,829,966.36 |
|