| AUSTIN WATER COMMUNITY BENEFIT CHARGE FUND |
BUDGET |
EXPENDITURES |
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Interfund Transfers |
| Trf to Reclaimed Water Fund |
$6,157,340.00 |
$2,995,123.97 |
| Trf to Wastewater Operating Fund |
$5,433,532.00 |
$5,433,532.00 |
| Trf to Water Operating Fund |
$10,599,543.00 |
$6,021,739.87 |
| |
$22,190,415.00 |
$14,450,395.84
|
|
| Other Requirements |
| Customer Assistance Prog Costs |
$975,000.00 |
$989,481.38 |
| Multifamily Cust Asst Prog Costs |
$8,019,648.00 |
$7,131,993.00 |
| |
$8,994,648.00 |
$8,121,474.38
|
|
|
|
| AUSTIN WATER RECLAIMED WATER UTILITY OPERATING FUND |
BUDGET |
EXPENDITURES |
| OTHER UTILITY PROGRAM REQUIREMENTS |
| Other Utility Program Requirements |
| Arbitrage rebate-admin exp |
$835.00 |
$1,358.65 |
| Commercial paper admin exp |
$51,536.00 |
$37,011.11 |
| Util rev bnd commission exp |
$34.00 |
$0.00 |
| |
$52,405.00 |
$38,369.76
|
|
|
| RECLAIMED WATER SERVICES |
| Reclaimed Water Services Support |
| Administrative leave |
$0.00 |
$7,575.46 |
| Allowances/other pay |
$0.00 |
$300.00 |
| Books-library |
$268.00 |
$0.00 |
| Building material |
$1,606.00 |
$0.00 |
| Chemicals |
$4,350.00 |
$0.00 |
| Clothing/clothing material |
$1,096.00 |
$16.04 |
| Computer supplies |
$107.00 |
$0.00 |
| Const/repair material-other |
$0.00 |
$264.47 |
| Contribution to employees ret |
$59,168.00 |
$55,704.92 |
| Drainage fee expense |
$2,516.00 |
$1,862.52 |
| Educational/promotional |
$1,057.00 |
$0.00 |
| Electric services |
$34,000.00 |
$43,151.56 |
| Electrical/lighting |
$3,043.00 |
$19,222.99 |
| FICA tax |
$38,567.00 |
$35,638.02 |
| Food/Ice |
$857.00 |
$96.24 |
| Fuses and fusing apparatus |
$500.00 |
$0.00 |
| Hardware/wire/steel |
$2,142.00 |
$4,034.51 |
| Holiday pay |
$0.00 |
$26,294.47 |
| Household/cleaning supplies |
$0.00 |
$58.42 |
| Insurance-health/life/dental |
$81,980.00 |
$70,629.44 |
| Maintenance-electric motors |
$19,000.00 |
$0.00 |
| Maintenance-grounds |
$5,135.00 |
$0.00 |
| Medicare tax |
$9,022.00 |
$8,334.69 |
| Memberships |
$857.00 |
$261.00 |
| Meters |
$27.00 |
$0.00 |
| Mileage reimbursements |
$157.00 |
$122.38 |
| Minor computer hardware |
$2,107.00 |
$170.00 |
| Miscellaneous expense |
$96.00 |
$0.00 |
| Office supplies |
$536.00 |
$83.00 |
| Overtime |
$0.00 |
$370.45 |
| Paint/painting supplies |
$511.00 |
$0.00 |
| Parts for equipment |
$32,000.00 |
$23,118.78 |
| Personal holiday pay |
$0.00 |
$6,130.45 |
| Personnel savings |
($52,148.00) |
$0.00 |
| Phone allowance |
$2,820.00 |
$2,373.14 |
| Pipes and fittings |
$9,107.00 |
$443.10 |
| Printing/binding/photo/repr |
$54.00 |
$0.00 |
| Priority mail/parcel services |
$21.00 |
$0.00 |
| Professional registration |
$629.00 |
$500.00 |
| Regular wages - full-time |
$616,338.00 |
$502,595.84 |
| Reimbursement of CIP charge |
($117,311.00) |
($89,827.37) |
| Relays and relaying equipment |
$0.00 |
$45.44 |
| Safety equipment |
$53,817.00 |
$36,026.41 |
| Services-other |
$20,097.00 |
$9,212.00 |
| Sick pay |
$0.00 |
$5,885.21 |
| Small tools/minor equipment |
$9,641.00 |
$4,591.02 |
| Software |
$6,007.00 |
$4,284.00 |
| Stability pay |
$2,900.00 |
$3,000.00 |
| Street/traff signs/mrkr/pos |
$107.00 |
$0.00 |
| Telephone-base cost |
$1,500.00 |
$0.00 |
| Telephone-cellular phones |
$1,400.00 |
$0.00 |
| Terminal pay |
$0.00 |
$4,986.26 |
| Vacation pay |
$0.00 |
$32,336.13 |
| Valves |
$6,320.00 |
$0.00 |
| Welding supplies |
$500.00 |
$0.00 |
| |
$862,504.00 |
$819,890.99
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Debt Transfers |
| Commercial paper interest |
$707,898.00 |
$212,440.82 |
| Trf to Util D/S Separate Lien |
$7,009,265.00 |
$6,075,608.57 |
| |
$7,717,163.00 |
$6,288,049.39
|
|
| Interfund Transfers |
| Administrative Support |
$78,314.00 |
$71,787.87 |
| CTM Support |
$6,536.00 |
$6,536.00 |
| TRF Operating to Debt Defeasance |
$3,000,000.00 |
$2,995,123.97 |
| Trf to CIP Mgm - CPM |
$309,231.00 |
$283,461.75 |
| Trf to Economic Development |
$104,560.00 |
$104,560.00 |
| Trf to General Fund |
$290,669.00 |
$266,446.62 |
| Trf to Reclaimed Water CIP Fnd |
$4,657,340.00 |
$4,139,285.00 |
| |
$8,446,650.00 |
$7,867,201.21
|
|
| Other Requirements |
| Accrued Payroll |
$3,090.00 |
$3,090.00 |
| Contribution to employees ret |
$59,922.00 |
$53,808.44 |
| |
$63,012.00 |
$56,898.44
|
|
|
|
| AUSTIN WATER WASTEWATER UTILITY OPERATING FUND |
BUDGET |
EXPENDITURES |
| CUSTOMER EXPERIENCE |
| Customer Services |
| Administrative leave |
$0.00 |
$38,930.82 |
| Allowances/other pay |
$0.00 |
$3,835.78 |
| Awards and Recognition |
$1,800.00 |
$1,077.35 |
| Bilingual Pay |
$7,200.00 |
$9,007.34 |
| Clothing/clothing material |
$4,029.00 |
$391.71 |
| Comp time used |
$0.00 |
$441.03 |
| Contribution to employees ret |
$252,896.00 |
$306,770.50 |
| Educational travel |
$0.00 |
$2,728.06 |
| Educational/promotional |
$3,275.00 |
$1,783.13 |
| Emergency leave |
$0.00 |
$6,531.90 |
| Exception vacation |
$0.00 |
$573.42 |
| FICA tax |
$176,316.00 |
$207,060.67 |
| Food/Ice |
$3,220.00 |
$2,800.05 |
| Hardware/wire/steel |
$289.00 |
$0.00 |
| Holiday pay |
$0.00 |
$201,856.04 |
| Holidays worked |
$7,000.00 |
$9,405.75 |
| Household/cleaning supplies |
$103.00 |
$0.00 |
| Insurance-health/life/dental |
$500,078.00 |
$547,244.02 |
| Insurance-temporary employees |
$0.00 |
$34,400.89 |
| Interdepartmental Charges |
$59,825.00 |
$59,824.43 |
| Jury leave |
$0.00 |
$2,428.65 |
| Medical/dental supplies |
$98.00 |
$0.00 |
| Medicare tax |
$41,661.00 |
$49,673.57 |
| Mileage reimbursements |
$45.00 |
$327.81 |
| Minor computer hardware |
$2,506.00 |
$0.00 |
| Office furnishings |
$0.00 |
$570.95 |
| Office supplies |
$5,370.00 |
$2,497.93 |
| Other paid leave |
$0.00 |
$25,000.59 |
| Overtime |
$56,700.00 |
$61,844.45 |
| Parental Leave |
$0.00 |
$5,328.96 |
| Personal holiday pay |
$0.00 |
$59,490.93 |
| Personnel savings |
($220,258.00) |
$0.00 |
| Phone allowance |
$8,280.00 |
$15,208.13 |
| Professional registration |
$331.00 |
$375.00 |
| Regular wages - full-time |
$2,634,349.00 |
$2,392,907.89 |
| Safety equipment |
$650.00 |
$543.74 |
| Seasonal employees |
$0.00 |
$11,113.38 |
| Seminar/training fees |
$0.00 |
$576.60 |
| Services-translators |
$1,071.00 |
$0.00 |
| Shift differential |
$0.00 |
$8,660.90 |
| Sick pay |
$0.00 |
$205,520.84 |
| Small tools/minor equipment |
$110.00 |
$109.60 |
| Software |
$579.00 |
$0.00 |
| Stability pay |
$16,950.00 |
$33,600.00 |
| Subscriptions |
$22,750.00 |
$26,532.98 |
| Temporary employees |
$208,116.00 |
$197,519.70 |
| Terminal pay |
$0.00 |
$7,611.14 |
| Training-city wide |
$4,000.00 |
$0.00 |
| Vacation pay |
$0.00 |
$289,163.63 |
| Wastewater svcs-interlocal |
$62,400.00 |
$0.00 |
| |
$3,861,739.00 |
$4,831,270.26
|
|
| Public Affairs |
| Administrative leave |
$0.00 |
$11,336.01 |
| Advertising/publication |
$52,000.00 |
$62,710.49 |
| Awards and Recognition |
$570.00 |
$100.00 |
| Bilingual Pay |
$1,800.00 |
$2,618.53 |
| Call back time |
$3,000.00 |
$3,917.18 |
| Contribution to employees ret |
$88,960.00 |
$107,714.20 |
| Educational/promotional |
$130,516.00 |
$118,341.18 |
| Emergency leave |
$0.00 |
$1,428.38 |
| Exception vacation |
$0.00 |
$60.29 |
| FICA tax |
$59,131.00 |
$71,339.50 |
| Food/Ice |
$3,000.00 |
$1,646.25 |
| Holiday pay |
$0.00 |
$75,407.03 |
| Holidays worked |
$500.00 |
$674.83 |
| Insurance-health/life/dental |
$155,762.00 |
$173,421.66 |
| Interdepartmental Charges |
$17,602.00 |
$12,056.69 |
| Jury leave |
$0.00 |
$238.37 |
| Medicare tax |
$13,832.00 |
$16,685.59 |
| Memberships |
$250.00 |
$0.00 |
| Office supplies |
$3,000.00 |
$861.07 |
| On call hours |
$5,000.00 |
$5,224.00 |
| Overtime |
$5,000.00 |
$5,189.70 |
| Personal holiday pay |
$0.00 |
$19,536.05 |
| Personnel savings |
($78,510.00) |
$0.00 |
| Phone allowance |
$7,020.00 |
$8,082.59 |
| Printing/binding/photo/repr |
$60,160.00 |
$26,812.02 |
| Regular wages - full-time |
$926,676.00 |
$888,636.89 |
| Safety equipment |
$200.00 |
$568.45 |
| Services-other |
$41,400.00 |
$7,814.42 |
| Sick pay |
$0.00 |
$41,619.25 |
| Small tools/minor equipment |
$2,833.00 |
$1,780.24 |
| Software |
$2,000.00 |
$0.00 |
| Stability pay |
$5,350.00 |
$9,800.00 |
| Subscriptions |
$21,650.00 |
$12,025.95 |
| Temporary employees |
$12,766.00 |
$10,142.14 |
| Terminal pay |
$1,209.00 |
$0.00 |
| Vacation pay |
$0.00 |
$91,540.39 |
| |
$1,542,677.00 |
$1,789,329.34
|
|
| Special Services |
| Administrative leave |
$0.00 |
$23,323.86 |
| Advertising/publication |
$9,275.00 |
$8,736.66 |
| Allowances/other pay |
$11,400.00 |
$3,187.28 |
| Awards and Recognition |
$1,080.00 |
$1,050.89 |
| Bilingual Pay |
$4,580.00 |
$5,023.61 |
| Books-library |
$110.00 |
$0.00 |
| Building material |
$200.00 |
$0.00 |
| Call back time |
$3,600.00 |
$2,816.46 |
| Chemicals |
$204.00 |
$0.00 |
| Clothing/clothing material |
$2,000.00 |
$1,508.21 |
| Computer supplies |
$385.00 |
$178.77 |
| Consulting-information technology |
$60,000.00 |
$60,000.00 |
| Contribution to employees ret |
$207,980.00 |
$198,632.00 |
| Educational/promotional |
$13,082.00 |
$11,634.72 |
| Electrical/lighting |
$300.00 |
$0.00 |
| Emergency leave |
$0.00 |
$1,938.15 |
| FICA tax |
$150,533.00 |
$141,828.54 |
| Fleet-equip.preventative maint |
$37,901.00 |
$27,545.54 |
| Food/Ice |
$4,750.00 |
$4,271.85 |
| Holiday pay |
$0.00 |
$104,974.37 |
| Household/cleaning supplies |
$160.00 |
$0.00 |
| Insurance-health/life/dental |
$377,108.00 |
$328,825.12 |
| Insurance-temporary employees |
$0.00 |
$23,726.51 |
| Interdepartmental reimbursements |
($409,440.00) |
($257,713.56) |
| Jury leave |
$0.00 |
$670.26 |
| Maintenance-other equipment |
$2,294.00 |
$0.00 |
| Medical/dental supplies |
$1,000.00 |
$203.20 |
| Medicare tax |
$35,207.00 |
$33,170.03 |
| Memberships |
$1,131.00 |
$906.50 |
| Minor computer hardware |
$3,323.00 |
$2,660.34 |
| Office supplies |
$9,520.00 |
$4,757.69 |
| On call hours |
$15,000.00 |
$12,535.00 |
| Overtime |
$40,700.00 |
$36,706.54 |
| Parental Leave |
$0.00 |
$15,040.97 |
| Personal holiday pay |
$0.00 |
$24,968.94 |
| Personnel savings |
($184,857.00) |
$0.00 |
| Phone allowance |
$13,460.00 |
$7,464.02 |
| Photographic |
$260.00 |
$0.00 |
| Pipes and fittings |
$55.00 |
$0.00 |
| Printing/binding/photo/repr |
$11,897.00 |
$8,994.00 |
| Professional registration |
$1,320.00 |
$1,000.00 |
| Regular wages - full-time |
$2,166,481.00 |
$1,749,777.23 |
| Safety equipment |
$3,300.00 |
$2,382.81 |
| Seminar/training fees |
$0.00 |
$1,534.95 |
| Services-hazardous mat disp |
$55.00 |
$0.00 |
| Services-other |
$12,455.00 |
$5,400.00 |
| Sick pay |
$0.00 |
$52,763.99 |
| Small tools/minor equipment |
$17,348.00 |
$10,634.77 |
| Software |
$12,000.00 |
$0.00 |
| Stability pay |
$17,250.00 |
$23,711.44 |
| Subscriptions |
$226.00 |
$220.00 |
| Temporary employees |
$235,123.00 |
$171,442.06 |
| Terminal pay |
$18,500.00 |
$9,175.06 |
| Toll Road - Tx Tag |
$0.00 |
$64.75 |
| Training-city wide |
$4,000.00 |
$295.00 |
| Transportation-city veh fuel |
$7,166.00 |
$10,245.00 |
| Vacation pay |
$0.00 |
$119,830.87 |
| |
$2,919,422.00 |
$2,998,044.40
|
|
|
| ENGINEERING AND TECHNICAL SERVICES |
| Engineering and Technical Services Operations |
| Accident pay |
$0.00 |
$1,627.55 |
| Administrative leave |
$0.00 |
$75,199.52 |
| Advertising/publication |
$313.00 |
$0.00 |
| Allowances/other pay |
$17,886.00 |
$13,891.60 |
| Awards and Recognition |
$1,560.00 |
$0.00 |
| Books-library |
$2,000.00 |
$0.00 |
| Call back time |
$108,586.00 |
$121,208.40 |
| Clothing/clothing material |
$43,241.00 |
$21,217.92 |
| Contribution to employees ret |
$285,052.00 |
$280,019.46 |
| Dept OH distribtd to indire |
$0.00 |
($1,719.41) |
| Educational incentive pay |
$14,500.00 |
$15,181.82 |
| Elctrcal conductors-wire&cable |
$1,250.00 |
$1,195.20 |
| Electrical/lighting |
$130,940.00 |
$44,864.58 |
| Emergency leave |
$0.00 |
$10,187.95 |
| FICA tax |
$187,532.00 |
$199,388.42 |
| Fleet-equip.preventative maint |
$141,348.00 |
$101,638.24 |
| Food/Ice |
$266.00 |
$252.01 |
| Gasoline/oil/grease |
$75.00 |
$69.28 |
| Hardware/wire/steel |
$900.00 |
$791.93 |
| Holiday pay |
$0.00 |
$152,062.41 |
| Holidays worked |
$0.00 |
$27.02 |
| Household/cleaning supplies |
$100.00 |
$56.74 |
| Indirect costs-FMC 74-4 |
$0.00 |
$1,719.41 |
| Insurance-health/life/dental |
$472,544.00 |
$441,215.15 |
| Jury leave |
$0.00 |
$460.27 |
| Medicare tax |
$43,855.00 |
$46,632.49 |
| Memberships |
$360.00 |
$0.00 |
| Mileage reimbursements |
$625.00 |
$161.41 |
| Minor computer hardware |
$1,735.00 |
$583.23 |
| Office supplies |
$3,032.00 |
$1,017.08 |
| On call hours |
$40,090.00 |
$49,450.50 |
| Other paid leave |
$22,301.00 |
$14,587.17 |
| Overtime |
$142,556.00 |
$209,334.11 |
| Parts for equipment |
$3,373.00 |
$2,903.02 |
| Parts for vehicles |
$10,350.00 |
$9,326.06 |
| Personal holiday pay |
$0.00 |
$37,460.44 |
| Personnel savings |
($253,214.00) |
$0.00 |
| Phone allowance |
$21,319.00 |
$16,556.34 |
| Priority mail/parcel services |
$100.00 |
$0.00 |
| Professional registration |
$2,021.00 |
$1,207.99 |
| Regular wages - full-time |
$2,969,291.00 |
$2,218,331.76 |
| Reimbursement of CIP charge |
($2,789.00) |
($5,192.47) |
| Rental-other equipment |
$3,500.00 |
$3,358.70 |
| Safety equipment |
$19,972.00 |
$19,839.36 |
| Services-hazardous mat disp |
$3,400.00 |
$0.00 |
| Services-inspection |
$715.00 |
$0.00 |
| Services-testing |
$14,438.00 |
$6,355.45 |
| Sick pay |
$0.00 |
$126,557.24 |
| Small tools/minor equipment |
$25,090.00 |
$27,483.82 |
| Software |
$1,462.00 |
$0.00 |
| Stability pay |
$17,025.00 |
$29,754.55 |
| Street/traff signs/mrkr/pos |
$150.00 |
$30.00 |
| Temporary employees |
$26,134.00 |
$26,615.31 |
| Terminal pay |
$17,724.00 |
$837.37 |
| Toll Road - Tx Tag |
$100.00 |
$104.77 |
| Training-city wide |
$1,000.00 |
$0.00 |
| Transportation-city veh fuel |
$42,240.00 |
$14,493.51 |
| Vacation pay |
$0.00 |
$212,604.74 |
| |
$4,586,048.00 |
$4,550,949.42
|
|
| Facility Engineering |
| Administrative leave |
$0.00 |
$11,536.72 |
| Allowances/other pay |
$0.00 |
$788.21 |
| Awards and Recognition |
$750.00 |
$0.00 |
| Books-library |
$0.00 |
$705.69 |
| Contribution to employees ret |
$161,272.00 |
$161,164.43 |
| Dept OH distribtd to indire |
$0.00 |
($253,191.46) |
| Emergency leave |
$0.00 |
$4,215.91 |
| FICA tax |
$105,896.00 |
$102,213.42 |
| Food/Ice |
$1,500.00 |
$217.01 |
| Holiday pay |
$0.00 |
$82,801.68 |
| Indirect costs-FMC 74-4 |
$0.00 |
$253,191.46 |
| Insurance-health/life/dental |
$213,148.00 |
$193,792.65 |
| Maintenance-computer hardware |
$500.00 |
$114.18 |
| Medicare tax |
$25,134.00 |
$24,492.22 |
| Memberships |
$1,200.00 |
$743.83 |
| Mileage reimbursements |
$2,000.00 |
$1,724.97 |
| Minor computer hardware |
$200.00 |
$14.68 |
| Office supplies |
$1,000.00 |
$254.19 |
| Overtime |
$750.00 |
$278.54 |
| Personal holiday pay |
$0.00 |
$24,685.00 |
| Personnel savings |
($143,479.00) |
$0.00 |
| Phone allowance |
$3,540.00 |
$5,698.50 |
| Printing/binding/photo/repr |
$75.00 |
$20.43 |
| Professional registration |
$645.00 |
$225.00 |
| Regular wages - full-time |
$1,679,927.00 |
$1,393,076.21 |
| Reimbursement of CIP charge |
($478,341.00) |
($757,319.80) |
| Safety equipment |
$1,100.00 |
$1,565.98 |
| Seasonal employees |
$0.00 |
$8,952.32 |
| Sick pay |
$0.00 |
$48,935.01 |
| Small tools/minor equipment |
$500.00 |
$5.70 |
| Software |
$4,800.00 |
$0.00 |
| Stability pay |
$7,400.00 |
$15,200.00 |
| Temporary employees |
$42,432.00 |
$31,337.27 |
| Terminal pay |
$17,376.00 |
$5,590.18 |
| Vacation pay |
$0.00 |
$117,579.66 |
| |
$1,649,325.00 |
$1,480,609.79
|
|
| Pipeline Capital Improvement Projects |
| Administrative leave |
$0.00 |
$16,122.64 |
| Allowances/other pay |
$0.00 |
$1,223.81 |
| Awards and Recognition |
$870.00 |
$509.69 |
| Clothing/clothing material |
$600.00 |
$16.15 |
| Contribution to employees ret |
$149,290.00 |
$163,987.49 |
| Dept OH distribtd to indire |
$0.00 |
($162,821.21) |
| Educational/promotional |
$250.00 |
$0.00 |
| Electrical/lighting |
$75.00 |
$0.00 |
| Emergency leave |
$0.00 |
$2,023.01 |
| FICA tax |
$102,281.00 |
$107,371.46 |
| Fleet-equip.preventative maint |
$36,576.00 |
$21,072.21 |
| Food/Ice |
$591.00 |
$217.35 |
| Holiday pay |
$0.00 |
$81,291.67 |
| Holidays worked |
$0.00 |
$4,855.75 |
| Household/cleaning supplies |
$107.00 |
$0.00 |
| Indirect costs-FMC 74-4 |
$0.00 |
$162,821.21 |
| Insurance-health/life/dental |
$204,950.00 |
$203,633.63 |
| Maintenance-buildings |
$665.00 |
$0.00 |
| Medicare tax |
$24,043.00 |
$25,151.00 |
| Memberships |
$551.00 |
$75.00 |
| Mileage reimbursements |
$501.00 |
$251.14 |
| Military leave |
$0.00 |
$8,254.26 |
| Minor computer hardware |
$1,959.00 |
$1,258.92 |
| Office supplies |
$1,603.00 |
$513.06 |
| On call hours |
$0.00 |
$118.00 |
| Overtime |
$746.00 |
$807.72 |
| Parking costs |
$200.00 |
$104.00 |
| Personal holiday pay |
$0.00 |
$22,132.06 |
| Personnel savings |
($137,474.00) |
$0.00 |
| Phone allowance |
$4,590.00 |
$4,757.89 |
| Priority mail/parcel services |
$12.00 |
$0.00 |
| Professional registration |
$522.00 |
$236.00 |
| Regular wages - full-time |
$1,555,114.00 |
$1,432,712.45 |
| Reimbursement of CIP charge |
($529,284.00) |
($479,683.41) |
| Safety equipment |
$985.00 |
$704.45 |
| Seasonal employees |
$0.00 |
$41,365.86 |
| Sick pay |
$0.00 |
$41,660.83 |
| Small tools/minor equipment |
$887.00 |
$709.18 |
| Software |
$1,293.00 |
$0.00 |
| Stability pay |
$6,350.00 |
$9,828.13 |
| Temporary employees |
$91,840.00 |
$0.00 |
| Terminal pay |
$0.00 |
$14,556.68 |
| Transportation-city veh fuel |
$4,471.00 |
$2,112.58 |
| Vacation pay |
$0.00 |
$101,148.55 |
| |
$1,525,164.00 |
$1,831,099.21
|
|
| Pipeline Engineering and Operations Support |
| Administrative leave |
$0.00 |
$18,983.00 |
| Allowances/other pay |
$0.00 |
$3,825.11 |
| Books-library |
$800.00 |
$139.00 |
| Call back time |
$0.00 |
$65,660.81 |
| Chemicals |
$1,054,440.00 |
$556,005.93 |
| Contribution to employees ret |
$166,850.00 |
$172,006.13 |
| Dept OH distribtd to indire |
$0.00 |
($18,596.50) |
| Educational travel |
$0.00 |
$1,187.84 |
| Educational/promotional |
$111,129.00 |
$45,581.57 |
| FICA tax |
$118,855.00 |
$120,960.85 |
| Fleet-equip.preventative maint |
$14,598.00 |
$3,718.22 |
| Food/Ice |
$240.00 |
$155.99 |
| Government permits and fees |
$670.00 |
$630.00 |
| Grants to subrecipients |
$150,000.00 |
$26,901.31 |
| Holiday pay |
$0.00 |
$103,506.17 |
| Holidays worked |
$0.00 |
$2,029.37 |
| Indirect costs-FMC 74-4 |
$0.00 |
$18,596.50 |
| Insurance-health/life/dental |
$237,742.00 |
$220,845.51 |
| Insurance-temporary employees |
$0.00 |
$5,395.01 |
| Interdepartmental Charges |
$320.00 |
$300.00 |
| Interdeptl-PW CPM charges |
$10,000.00 |
$6,099.70 |
| Jury leave |
$0.00 |
$447.10 |
| Maintenance-other equipment |
$28,732.00 |
$22,464.68 |
| Maintenance-pipelines |
$2,500,000.00 |
$1,816,318.71 |
| Medicare tax |
$27,797.00 |
$28,290.45 |
| Memberships |
$125.00 |
$0.00 |
| Mileage reimbursements |
$1,030.00 |
$671.61 |
| Minor computer hardware |
$794.00 |
$437.49 |
| Office supplies |
$935.00 |
$570.59 |
| On call hours |
$2,653.00 |
$10,656.50 |
| Other paid leave |
$0.00 |
$5,522.09 |
| Overtime |
$31,492.00 |
$80,461.06 |
| Parking costs |
$135.00 |
$126.10 |
| Personal holiday pay |
$0.00 |
$24,156.91 |
| Personnel savings |
($148,838.00) |
$0.00 |
| Phone allowance |
$14,250.00 |
$16,207.72 |
| Postage |
$1,710.00 |
$1,621.55 |
| Printing/binding/photo/repr |
$150.00 |
$0.00 |
| Professional registration |
$996.00 |
$893.28 |
| Regular wages - full-time |
$1,738,032.00 |
$1,424,407.84 |
| Reimbursement of CIP charge |
($43,895.00) |
($51,537.16) |
| Rental-other equipment |
$808,000.00 |
$659,103.87 |
| Safety equipment |
$1,260.00 |
$731.39 |
| Services-other |
$2,518,062.00 |
$1,395,575.60 |
| Sick pay |
$0.00 |
$64,562.51 |
| Small tools/minor equipment |
$42,543.00 |
$6,769.39 |
| Software |
$6,960.00 |
$6,921.45 |
| Stability pay |
$15,300.00 |
$22,093.75 |
| Temporary employees |
$149,362.00 |
$37,746.81 |
| Toll Road - Tx Tag |
$40.00 |
$36.86 |
| Transportation-city veh fuel |
$649.00 |
$168.16 |
| Vacation pay |
$0.00 |
$138,029.21 |
| |
$9,563,918.00 |
$7,067,387.04
|
|
| SCADA Engineering & Support |
| Administrative leave |
$0.00 |
$21,999.69 |
| Allowances/other pay |
$0.00 |
$1,863.81 |
| Awards and Recognition |
$510.00 |
$0.00 |
| Computer Hardware |
$49,200.00 |
$0.00 |
| Contribution to employees ret |
$103,537.00 |
$148,043.18 |
| Dept OH distribtd to indire |
$0.00 |
($43,248.63) |
| Emergency leave |
$0.00 |
$1,476.31 |
| FICA tax |
$67,434.00 |
$92,995.48 |
| Food/Ice |
$886.00 |
$121.12 |
| Holiday pay |
$0.00 |
$95,917.67 |
| Holidays worked |
$0.00 |
$86.24 |
| Indirect costs-FMC 74-4 |
$0.00 |
$43,248.63 |
| Insurance-health/life/dental |
$139,366.00 |
$174,357.03 |
| Jury leave |
$0.00 |
$583.82 |
| Maintenance-computer hardware |
$6,854.00 |
$0.00 |
| Maintenance-computer software |
$361,041.00 |
$239,777.21 |
| Medicare tax |
$15,808.00 |
$21,932.83 |
| Memberships |
$440.00 |
$193.00 |
| Mileage reimbursements |
$702.00 |
$582.19 |
| Minor computer hardware |
$95,506.00 |
$18,541.11 |
| Office supplies |
$1,803.00 |
$9.99 |
| Overtime |
$560.00 |
$0.00 |
| Parental Leave |
$0.00 |
$23,156.24 |
| Personal holiday pay |
$0.00 |
$21,320.65 |
| Personnel savings |
($91,566.00) |
$0.00 |
| Phone allowance |
$4,380.00 |
$7,008.52 |
| Printing/binding/photo/repr |
$52.00 |
$0.00 |
| Priority mail/parcel services |
$6.00 |
$0.00 |
| Professional registration |
$116.00 |
$50.00 |
| Regular wages - full-time |
$1,078,526.00 |
$1,152,269.16 |
| Reimbursement of CIP charge |
($73,595.00) |
($129,260.10) |
| Safety equipment |
$485.00 |
$482.40 |
| Sick pay |
$0.00 |
$57,306.44 |
| Small tools/minor equipment |
$0.00 |
$654.26 |
| Software |
$2,119.00 |
$17,853.71 |
| Stability pay |
$6,950.00 |
$16,000.00 |
| Terminal pay |
$3,023.00 |
$0.00 |
| Training-city wide |
$1,248.00 |
$0.00 |
| Vacation pay |
$0.00 |
$168,316.25 |
| |
$1,775,391.00 |
$2,153,638.21
|
|
|
| ENVIRONMENTAL, PLANNING, AND DEVELOPMENT SERVICES |
| Environmental, Planning, and Development Support |
| Administrative leave |
$0.00 |
$4,469.79 |
| Allowances/other pay |
$450.00 |
$116.25 |
| Awards and Recognition |
$150.00 |
$0.00 |
| Books-library |
$1,686.00 |
$907.42 |
| Chemicals |
$53.00 |
$0.00 |
| Contribution to employees ret |
$39,665.00 |
$49,049.23 |
| Educational travel |
$0.00 |
$787.80 |
| Educational/promotional |
$206.00 |
$0.00 |
| Emergency leave |
$0.00 |
$4,953.12 |
| FICA tax |
$24,426.00 |
$30,681.24 |
| Fleet-equip.preventative maint |
$3,840.00 |
$4,097.72 |
| Food/Ice |
$384.00 |
$262.79 |
| Holiday pay |
$0.00 |
$28,917.55 |
| Holidays worked |
$0.00 |
$446.87 |
| Insurance-health/life/dental |
$49,188.00 |
$57,500.21 |
| Medical/dental supplies |
$98.00 |
$0.00 |
| Medicare tax |
$6,077.00 |
$7,746.50 |
| Memberships |
$991.00 |
$391.00 |
| Minor computer hardware |
$1,273.00 |
$1,707.68 |
| Office supplies |
$1,001.00 |
$1,674.42 |
| Overtime |
$200.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$9,636.23 |
| Personnel savings |
($34,852.00) |
$0.00 |
| Phone allowance |
$1,470.00 |
$1,770.08 |
| Printing/binding/photo/repr |
$210.00 |
$0.00 |
| Priority mail/parcel services |
$50.00 |
$35.84 |
| Regular wages - full-time |
$413,161.00 |
$389,215.93 |
| Safety equipment |
$121.00 |
$142.71 |
| Seminar/training fees |
$0.00 |
$7.57 |
| Sick pay |
$0.00 |
$19,354.47 |
| Small tools/minor equipment |
$5,000.00 |
$3,800.47 |
| Software |
$212.00 |
$0.00 |
| Stability pay |
$4,350.00 |
$7,200.00 |
| Subscriptions |
$779.00 |
$308.68 |
| Terminal pay |
$0.00 |
$26,812.04 |
| Transportation-city veh fuel |
$559.00 |
$150.49 |
| Vacation pay |
$0.00 |
$50,817.34 |
| |
$520,748.00 |
$702,961.44
|
|
| Infrastructure Management |
| Administrative leave |
$0.00 |
$16,013.98 |
| Allowances/other pay |
$2,000.00 |
$831.83 |
| Awards and Recognition |
$600.00 |
$233.76 |
| Books-library |
$250.00 |
$0.00 |
| Clothing/clothing material |
$400.00 |
$0.00 |
| Computer supplies |
$1,500.00 |
$0.00 |
| Consultant-others |
$25,000.00 |
$0.00 |
| Contribution to employees ret |
$101,876.00 |
$114,041.69 |
| Educational travel |
$0.00 |
$252.40 |
| FICA tax |
$71,093.00 |
$77,975.50 |
| Food/Ice |
$700.00 |
$1,297.26 |
| Holiday pay |
$0.00 |
$80,901.78 |
| Insurance-health/life/dental |
$163,960.00 |
$163,746.50 |
| Insurance-temporary employees |
$0.00 |
$5,579.19 |
| Jury leave |
$0.00 |
$171.24 |
| Maintenance-computer software |
$4,000.00 |
$4,709.60 |
| Medicare tax |
$16,691.00 |
$18,383.54 |
| Memberships |
$2,000.00 |
$0.00 |
| Mileage reimbursements |
$50.00 |
$57.28 |
| Minor computer hardware |
$750.00 |
$0.00 |
| Office supplies |
$1,750.00 |
$575.59 |
| Overtime |
$3,000.00 |
$10.52 |
| Personal holiday pay |
$0.00 |
$20,401.53 |
| Personnel savings |
($90,500.00) |
$0.00 |
| Phone allowance |
$2,190.00 |
$4,055.11 |
| Professional registration |
$225.00 |
$132.00 |
| Regular wages - full-time |
$1,061,178.00 |
$903,511.80 |
| Safety equipment |
$350.00 |
$108.94 |
| Seminar/training fees |
$0.00 |
$601.45 |
| Sick pay |
$0.00 |
$57,353.00 |
| Small tools/minor equipment |
$400.00 |
$0.00 |
| Software |
$0.00 |
$70.84 |
| Stability pay |
$8,300.00 |
$18,231.25 |
| Subscriptions |
$25.00 |
$0.00 |
| Temporary employees |
$79,040.00 |
$56,793.00 |
| Terminal pay |
$5,500.00 |
$12,287.03 |
| Training-city wide |
$1,000.00 |
$0.00 |
| Vacation pay |
$0.00 |
$119,214.25 |
| |
$1,463,328.00 |
$1,677,541.86
|
|
| Systems Planning |
| Administrative leave |
$0.00 |
$19,340.22 |
| Allowances/other pay |
$3,000.00 |
$877.31 |
| Awards and Recognition |
$690.00 |
$0.00 |
| Clothing/clothing material |
$51.00 |
$28.93 |
| Contribution to employees ret |
$116,067.00 |
$129,012.53 |
| Educational travel |
$0.00 |
$104.15 |
| Emergency leave |
$0.00 |
$1,587.04 |
| Exception vacation |
$0.00 |
$736.32 |
| FICA tax |
$80,739.00 |
$85,359.12 |
| Holiday pay |
$0.00 |
$69,245.40 |
| Holidays worked |
$0.00 |
$633.40 |
| Insurance-health/life/dental |
$181,176.00 |
$175,435.51 |
| Medicare tax |
$18,964.00 |
$20,066.58 |
| Memberships |
$110.00 |
$135.00 |
| Mileage reimbursements |
$500.00 |
$28.29 |
| Minor computer hardware |
$196.00 |
$0.00 |
| Office supplies |
$3,656.00 |
$861.36 |
| Overtime |
$4,000.00 |
$743.38 |
| Personal holiday pay |
$0.00 |
$20,154.15 |
| Personnel savings |
($103,659.00) |
$0.00 |
| Phone allowance |
$2,064.00 |
$3,252.14 |
| Professional registration |
$1,000.00 |
$25.00 |
| Regular wages - full-time |
$1,209,010.00 |
$1,083,583.96 |
| Safety equipment |
$121.00 |
$406.59 |
| Seasonal employees |
$0.00 |
$42,188.27 |
| Services-Software as a Service |
$175,000.00 |
$200,183.90 |
| Shift differential |
$0.00 |
$9.10 |
| Sick pay |
$0.00 |
$44,673.97 |
| Small tools/minor equipment |
$232.00 |
$0.00 |
| Stability pay |
$4,970.00 |
$10,218.75 |
| Temporary employees |
$91,520.00 |
$0.00 |
| Vacation pay |
$0.00 |
$103,238.44 |
| |
$1,789,407.00 |
$2,012,128.81
|
|
| Utility Development Services |
| Administrative leave |
$0.00 |
$42,913.38 |
| Allowances/other pay |
$5,600.00 |
$1,707.67 |
| Awards and Recognition |
$1,260.00 |
$54.99 |
| Bilingual Pay |
$5,400.00 |
$6,440.83 |
| Books-library |
$500.00 |
$77.62 |
| Clothing/clothing material |
$950.00 |
$0.00 |
| Contribution to employees ret |
$241,873.00 |
$254,289.02 |
| Dept OH distribtd to indire |
$0.00 |
($31,835.65) |
| Educational travel |
$0.00 |
$1,847.29 |
| Emergency leave |
$0.00 |
$698.76 |
| FICA tax |
$159,662.00 |
$169,803.58 |
| Fleet-equip.preventative maint |
$14,598.00 |
$8,295.32 |
| Food/Ice |
$0.00 |
$642.38 |
| Government permits and fees |
$700.00 |
$297.56 |
| Grant cost-support of other |
$15,000.00 |
$0.00 |
| Holiday pay |
$0.00 |
$188,724.75 |
| Holidays worked |
$0.00 |
$580.42 |
| Indirect costs-FMC 74-4 |
$0.00 |
$31,835.65 |
| Insurance-health/life/dental |
$352,514.00 |
$333,218.84 |
| Insurance-temporary employees |
$0.00 |
$8,551.13 |
| Interdepartmental Charges |
$60,000.00 |
$1,505.00 |
| Interdepartmental reimbursements |
($189,100.00) |
($29,068.25) |
| Interdeptl-PW CPM charges |
$10,000.00 |
$0.00 |
| Jury leave |
$0.00 |
$1,392.54 |
| Laundry expense |
$0.00 |
($125.77) |
| Medicare tax |
$37,349.00 |
$39,758.32 |
| Memberships |
$1,200.00 |
$0.00 |
| Mileage reimbursements |
$500.00 |
$69.98 |
| Minor computer hardware |
$1,000.00 |
$418.58 |
| Office supplies |
$1,000.00 |
$501.78 |
| Overtime |
$20,000.00 |
$24,060.67 |
| Parking costs |
$0.00 |
$48.50 |
| Personal holiday pay |
$0.00 |
$55,029.62 |
| Personnel savings |
($216,842.00) |
$0.00 |
| Phone allowance |
$7,470.00 |
$7,989.67 |
| Professional registration |
$900.00 |
$2,170.73 |
| Regular wages - full-time |
$2,519,491.00 |
$1,886,134.81 |
| Reimbursement of CIP charge |
($34,659.00) |
($94,443.78) |
| Safety equipment |
$1,280.00 |
$1,092.12 |
| Seasonal employees |
$0.00 |
$8,160.00 |
| Seminar/training fees |
$0.00 |
$3,483.93 |
| Services-IT staffing |
$250,000.00 |
$156,920.26 |
| Services-other |
$1,000.00 |
$0.00 |
| Services-survey |
$1,500.00 |
$0.00 |
| Shift differential |
$0.00 |
$751.88 |
| Sick pay |
$0.00 |
$133,821.27 |
| Small tools/minor equipment |
$200.00 |
$0.00 |
| Software |
$15,000.00 |
$15,309.50 |
| Stability pay |
$20,900.00 |
$42,700.00 |
| Subscriptions |
$400.00 |
$95.00 |
| Temporary employees |
$21,840.00 |
$71,690.07 |
| Terminal pay |
$5,000.00 |
$25,094.80 |
| Transportation-city veh fuel |
$5,273.00 |
$590.55 |
| Vacation pay |
$0.00 |
$334,092.81 |
| |
$3,338,759.00 |
$3,707,388.13
|
|
|
| OPERATIONS |
| Environmental Engineering & Technical Services |
| Administrative leave |
$0.00 |
$42,075.07 |
| Allowances/other pay |
$16,950.00 |
$4,387.50 |
| Awards and Recognition |
$2,160.00 |
$1,351.50 |
| Bilingual Pay |
$0.00 |
$2,210.51 |
| Books-library |
$350.00 |
$296.30 |
| Chemicals |
$151,775.00 |
$99,778.33 |
| Clothing/clothing material |
$4,200.00 |
$1,318.48 |
| Comp time used |
$0.00 |
$435.11 |
| Computer supplies |
$1,018.00 |
$0.00 |
| Contribution to employees ret |
$338,993.00 |
$326,219.35 |
| Educational travel |
$0.00 |
$0.01 |
| Emergency leave |
$0.00 |
$5,951.16 |
| FICA tax |
$223,773.00 |
$216,850.91 |
| Fleet-equip.preventative maint |
$7,680.00 |
$8,195.44 |
| Food/Ice |
$300.00 |
$0.00 |
| Government permits and fees |
$146,400.00 |
$511.51 |
| Holiday pay |
$0.00 |
$152,495.05 |
| Holidays worked |
$8,065.00 |
$6,307.47 |
| Insurance-health/life/dental |
$582,058.00 |
$512,111.44 |
| Jury leave |
$0.00 |
$937.72 |
| Maintenance-buildings |
$500.00 |
$0.00 |
| Maintenance-computer hardware |
$100.00 |
$0.00 |
| Maintenance-computer software |
$72,158.00 |
$85,596.00 |
| Maintenance-other equipment |
$91,819.00 |
$121,691.10 |
| Medical/dental supplies |
$150.00 |
$0.00 |
| Medical/lab equipment |
$0.00 |
$23,890.61 |
| Medicare tax |
$52,523.00 |
$51,101.07 |
| Memberships |
$3,066.00 |
$941.00 |
| Mileage reimbursements |
$2,324.00 |
$538.81 |
| Minor computer hardware |
$2,100.00 |
$815.62 |
| Office supplies |
$9,055.00 |
$6,848.11 |
| Overtime |
$123,895.00 |
$100,451.83 |
| Parental Leave |
$0.00 |
$18,645.13 |
| Parking costs |
$100.00 |
$31.06 |
| Personal holiday pay |
$0.00 |
$42,362.49 |
| Personnel savings |
($299,141.00) |
$0.00 |
| Phone allowance |
$11,560.00 |
$14,290.65 |
| Printing/binding/photo/repr |
$257.00 |
$14.34 |
| Priority mail/parcel services |
$2,800.00 |
$932.09 |
| Professional registration |
$1,500.00 |
$552.50 |
| Regular wages - full-time |
$3,531,183.00 |
$2,814,217.77 |
| Rental-vehicles/buses |
$1,000.00 |
$0.00 |
| Safety equipment |
$3,800.00 |
$3,030.51 |
| Seasonal employees |
$0.00 |
$39,590.86 |
| Seminar/training fees |
$0.00 |
($500.00) |
| Services-engineering |
$1,000.00 |
$0.00 |
| Services-hazardous mat disp |
$12,828.00 |
$5,181.85 |
| Services-other |
$18,926.00 |
$17,934.35 |
| Services-testing |
$254,685.00 |
$187,467.00 |
| Sick pay |
$0.00 |
$128,247.11 |
| Small tools/minor equipment |
$271,450.00 |
$202,636.99 |
| Software |
$400.00 |
$0.00 |
| Stability pay |
$27,000.00 |
$34,371.92 |
| Subscriptions |
$8,416.00 |
$323.40 |
| Temporary employees |
$52,648.00 |
$0.00 |
| Terminal pay |
$30,000.00 |
$15,719.26 |
| Training-city wide |
$2,000.00 |
$0.00 |
| Transportation-city veh fuel |
$1,194.00 |
$703.46 |
| Vacation pay |
$0.00 |
$202,441.89 |
| Welding supplies |
$14,630.00 |
$6,976.03 |
| |
$5,789,648.00 |
$5,508,477.67
|
|
| Operations Support |
| Administrative leave |
$0.00 |
$3,786.22 |
| Allowances/other pay |
$0.00 |
$300.00 |
| Awards and Recognition |
$210.00 |
$0.00 |
| Books-library |
$1,124.00 |
$0.00 |
| Clothing/clothing material |
$1,250.00 |
$0.00 |
| Computer supplies |
$55.00 |
$0.00 |
| Consultant-others |
$51,551.00 |
$0.00 |
| Contribution to employees ret |
$45,662.00 |
$49,663.27 |
| Emergency leave |
$0.00 |
$3,539.75 |
| FICA tax |
$28,164.00 |
$28,839.70 |
| Food/Ice |
$591.00 |
$0.00 |
| Government permits and fees |
$1,033.00 |
$0.00 |
| Holiday pay |
$0.00 |
$19,320.54 |
| Insurance-health/life/dental |
$49,188.00 |
$46,582.68 |
| Maintenance-other equipment |
$5,374.00 |
$5,910.87 |
| Medicare tax |
$6,977.00 |
$7,468.45 |
| Memberships |
$451.00 |
$64.50 |
| Mileage reimbursements |
$1,171.00 |
$169.43 |
| Minor computer hardware |
$490.00 |
$0.00 |
| Office supplies |
$900.00 |
$117.12 |
| Personal holiday pay |
$0.00 |
$3,576.90 |
| Personnel savings |
($49,811.00) |
$0.00 |
| Phone allowance |
$1,770.00 |
$2,322.15 |
| Postage |
$75.00 |
$0.00 |
| Professional registration |
$634.00 |
$75.00 |
| Regular wages - full-time |
$475,647.00 |
$451,401.18 |
| Rental-other equipment |
$7,709.00 |
$624.34 |
| Safety equipment |
$97.00 |
$0.00 |
| Sick pay |
$0.00 |
$8,572.50 |
| Small tools/minor equipment |
$645.00 |
$0.00 |
| Software |
$627.00 |
$0.00 |
| Stability pay |
$3,650.00 |
$5,800.00 |
| Terminal pay |
$0.00 |
$3,309.57 |
| Vacation pay |
$0.00 |
$25,991.32 |
| |
$635,234.00 |
$667,435.49
|
|
| Wastewater Collection Operations |
| Accident pay |
$0.00 |
$221,791.60 |
| Administrative leave |
$0.00 |
$226,951.92 |
| Agricultural/horticultural |
$9,558.00 |
$4,590.00 |
| Allowances/other pay |
$87,177.00 |
$51,064.86 |
| Asphalt |
$146,575.00 |
$170,534.64 |
| Awards and Recognition |
$11,670.00 |
$3,754.87 |
| Bilingual Pay |
$54,498.00 |
$32,348.93 |
| Building material |
$68,380.00 |
$89,838.47 |
| Call back time |
$565,161.00 |
$514,677.74 |
| Cement/concrete |
$12,531.00 |
$11,245.39 |
| Chemicals |
$13,119.00 |
$16,037.35 |
| Clothing/clothing material |
$78,116.00 |
$87,056.07 |
| Comp time used |
$0.00 |
$357.01 |
| Computer supplies |
$2,373.00 |
$833.33 |
| Const/repair material-other |
$200.00 |
$597.65 |
| Consulting-information technology |
$256,868.00 |
$94,918.41 |
| Contribution to employees ret |
$1,322,740.00 |
$1,207,557.02 |
| Dept OH distribtd to indire |
$0.00 |
($190,888.26) |
| Dietary hardware |
$889.00 |
$980.62 |
| Drainage fee expense |
$15,028.00 |
$35,896.23 |
| Educational incentive pay |
$95,100.00 |
$148,453.28 |
| Elctrcal conductors-hardware |
$386.00 |
$59.07 |
| Elctrcal conductors-wire&cable |
$1,385.00 |
$0.00 |
| Electric services |
$559,920.00 |
$624,105.20 |
| Electrical/lighting |
$162,559.00 |
$131,672.30 |
| Emergency leave |
$0.00 |
$27,244.05 |
| FICA tax |
$881,691.00 |
$988,578.13 |
| Fleet-equip.preventative maint |
$2,942,660.00 |
$2,533,315.51 |
| Food/Ice |
$5,758.00 |
$10,577.74 |
| Freight |
$5,455.00 |
$1,094.77 |
| Fuses and fusing apparatus |
$554.00 |
$367.33 |
| Garbage/refuse collection |
$87,004.00 |
$29,021.17 |
| Gas/heating fuels |
$13,303.00 |
$8,638.99 |
| Gasoline/oil/grease |
$11,394.00 |
$13,972.10 |
| Government permits and fees |
$100,500.00 |
$148,682.92 |
| Hardware/wire/steel |
$11,428.00 |
$8,922.26 |
| Holiday pay |
$0.00 |
$563,738.51 |
| Holidays worked |
$97,394.00 |
$90,082.16 |
| Household/cleaning supplies |
$19,023.00 |
$23,263.77 |
| Identification |
$0.00 |
$307.38 |
| Indirect costs-FMC 74-4 |
$0.00 |
$190,888.26 |
| Insurance-health/life/dental |
$2,833,721.00 |
$2,397,079.22 |
| Insurance-temporary employees |
$0.00 |
$18,354.47 |
| Interdepartmental Charges |
$3,000.00 |
$1,328.86 |
| Interdepartmental reimbursements |
$0.00 |
($776.55) |
| Intradeptl chgs-street cut rpr |
$3,300,000.00 |
$3,133,569.08 |
| Jury leave |
$0.00 |
$4,041.08 |
| Maintenance-buildings |
$91,073.00 |
$9,514.77 |
| Maintenance-computer software |
$0.00 |
$63.95 |
| Maintenance-electric motors |
$16,630.00 |
$35,458.06 |
| Maintenance-grounds |
$125,000.00 |
$62,147.73 |
| Maintenance-other equipment |
$404,068.00 |
$237,883.43 |
| Maintenance-turbine/generator |
$150,000.00 |
$69,480.27 |
| Maintenance-vehicles |
$7,878.00 |
$3,350.46 |
| Medical/dental supplies |
$6,443.00 |
$1,493.00 |
| Medicare tax |
$206,191.00 |
$231,200.03 |
| Memberships |
$509.00 |
$63.95 |
| Mileage reimbursements |
$3,308.00 |
$2,215.24 |
| Minor computer hardware |
$20,937.00 |
$12,714.04 |
| Miscellaneous expense |
$2,704.00 |
$27.98 |
| Office supplies |
$18,862.00 |
$10,893.82 |
| On call hours |
$265,310.00 |
$231,256.52 |
| Other Equipment |
$326,200.00 |
$417,795.28 |
| Other paid leave |
$0.00 |
$215,459.26 |
| Overtime |
$2,453,325.00 |
$2,400,288.23 |
| Paint/painting supplies |
$8,679.00 |
$2,096.29 |
| Parental Leave |
$0.00 |
$50,557.53 |
| Parts for equipment |
$344,886.00 |
$98,786.70 |
| Parts for vehicles |
$27,000.00 |
$8,470.16 |
| Personal holiday pay |
$0.00 |
$152,831.88 |
| Personnel savings |
($1,162,879.00) |
$0.00 |
| Phone allowance |
$62,516.00 |
$39,105.39 |
| Pipes and fittings |
$697,643.00 |
$930,807.38 |
| Postage |
$10,333.00 |
$4,198.83 |
| Printing/binding/photo/repr |
$3,021.00 |
$2,969.44 |
| Priority mail/parcel services |
$185.00 |
$38.78 |
| Professional registration |
$24,048.00 |
$13,145.84 |
| Pull boxes,svc boxes,manholes |
$0.00 |
$15.23 |
| Radio equipment |
$0.00 |
$190.58 |
| Regular wages - full-time |
$13,778,602.00 |
$9,474,999.74 |
| Reimbursement of CIP charge |
($455,230.00) |
($591,786.16) |
| Relays and relaying equipment |
$1,108.00 |
$2,329.67 |
| Rental-other equipment |
$196,120.00 |
$103,827.33 |
| Rental-vehicles/buses |
$267.00 |
$0.00 |
| Safety equipment |
$229,515.00 |
$207,819.53 |
| Sand/gravel/stone |
$166,133.00 |
$117,266.75 |
| Seasonal employees |
$0.00 |
$22,336.69 |
| Security equipment |
$2,500.00 |
$2,995.00 |
| Seminar/training fees |
$0.00 |
$8.59 |
| Services-Dumpster Collection |
$13,415.00 |
$0.00 |
| Services-IT Installations |
$2,732.00 |
$0.00 |
| Services-hazardous mat disp |
$848.00 |
$0.00 |
| Services-other |
$1,268,882.00 |
$516,179.90 |
| Shift differential |
$14,800.00 |
$13,460.06 |
| Sick pay |
$0.00 |
$523,195.47 |
| Small electric motors-water ut |
$5,542.00 |
$449.18 |
| Small tools/minor equipment |
$325,770.00 |
$289,747.72 |
| Software |
$890.00 |
$0.00 |
| Stability pay |
$136,350.00 |
$176,811.99 |
| Street/traff signs/mrkr/pos |
$545.00 |
$0.00 |
| Telephone-cellular phones |
$246,456.00 |
$95,371.51 |
| Temporary employees |
$233,143.00 |
$418,387.88 |
| Terminal pay |
$22,593.00 |
$28,599.21 |
| Toll Road - Tx Tag |
$0.00 |
$2,718.84 |
| Transportation-city veh fuel |
$535,314.00 |
$583,931.05 |
| Vacation pay |
$0.00 |
$838,576.89 |
| Valves |
$76,160.00 |
$80,773.89 |
| Welding supplies |
$610.00 |
$44.00 |
| Wireless Communication-instal |
$500.00 |
$0.00 |
| |
$34,694,553.00 |
$31,829,289.69
|
|
| Wastewater Treatment Operations |
| Accident pay |
$0.00 |
$57,655.65 |
| Administrative leave |
$0.00 |
$105,155.32 |
| Advertising/publication |
$16,135.00 |
$0.00 |
| Agricultural/horticultural |
$5,722.00 |
$3,122.39 |
| Allowances/other pay |
$67,300.00 |
$16,575.00 |
| Awards and Recognition |
$7,920.00 |
$5,758.13 |
| Boiler equipment |
$4,000.00 |
$0.00 |
| Books-library |
$225.00 |
$80.00 |
| Building material |
$12,018.00 |
$5,281.46 |
| Call back time |
$39,800.00 |
$83,251.18 |
| Cement/concrete |
$554.00 |
$490.75 |
| Chemicals |
$12,383,880.00 |
$9,377,836.76 |
| Clothing/clothing material |
$61,885.00 |
$45,859.96 |
| Computer supplies |
$300.00 |
$119.43 |
| Const/repair material-other |
$605,233.00 |
$533,431.44 |
| Contribution to employees ret |
$1,016,101.00 |
$860,603.66 |
| Dietary hardware |
$1,000.00 |
$0.00 |
| Drainage fee expense |
$58,595.00 |
$63,634.80 |
| Educational incentive pay |
$87,000.00 |
$100,766.36 |
| Educational/promotional |
$516.00 |
$2,411.42 |
| Elctrcal conductors-hardware |
$417.00 |
$1,062.51 |
| Elctrcal conductors-wire&cable |
$2,156.00 |
$6,454.20 |
| Electric services |
$5,974,316.00 |
$5,779,550.58 |
| Electrical/lighting |
$293,045.00 |
$382,388.06 |
| Emergency leave |
$0.00 |
$19,768.22 |
| Exception vacation |
$0.00 |
$5,546.63 |
| FICA tax |
$662,303.00 |
$667,087.99 |
| Fleet-equip. vehicle/equipment modification |
$1,000.00 |
$0.00 |
| Fleet-equip.preventative maint |
$320,218.00 |
$489,477.26 |
| Food/Ice |
$4,995.00 |
$5,710.59 |
| Freight |
$8,000.00 |
$13,930.48 |
| Fuses and fusing apparatus |
$1,086.00 |
$71.65 |
| Garbage/refuse collection |
$6,100.00 |
$5,499.70 |
| Gas/heating fuels |
$9,839.00 |
$23,139.87 |
| Gasoline/oil/grease |
$86,910.00 |
$75,057.30 |
| Government permits and fees |
$319,004.00 |
$310,389.47 |
| Hardware/wire/steel |
$14,624.00 |
$15,862.61 |
| Holiday pay |
$0.00 |
$392,804.11 |
| Holidays worked |
$90,512.00 |
$125,299.32 |
| Household/cleaning supplies |
$22,750.00 |
$16,087.42 |
| Insurance-health/life/dental |
$2,164,272.00 |
$1,695,689.48 |
| Interdepartmental Charges |
$131,250.00 |
$131,250.00 |
| Jury leave |
$0.00 |
$1,910.44 |
| Laundry expense |
$13,950.00 |
$12,880.60 |
| Maintenance-aux gen equipment |
$20,000.00 |
$3,434.44 |
| Maintenance-boilers |
$10,000.00 |
$0.00 |
| Maintenance-buildings |
$79,055.00 |
$8,369.25 |
| Maintenance-computer hardware |
$1,500.00 |
$1,689.74 |
| Maintenance-computer software |
$7,800.00 |
$32,583.36 |
| Maintenance-electric motors |
$124,450.00 |
$62,501.52 |
| Maintenance-grounds |
$201,400.00 |
$107,089.20 |
| Maintenance-other equipment |
$122,425.00 |
$13,604.79 |
| Maintenance-turbine/generator |
$287,000.00 |
$218,182.16 |
| Medical/dental supplies |
$2,635.00 |
$851.00 |
| Medicare tax |
$154,890.00 |
$156,012.46 |
| Memberships |
$314.00 |
$0.00 |
| Meters |
$10,000.00 |
$0.00 |
| Mileage reimbursements |
$3,009.00 |
$2,156.42 |
| Military leave |
$0.00 |
$3,358.85 |
| Minor computer hardware |
$153,919.00 |
$28,748.65 |
| Office furnishings |
$0.00 |
$1,451.55 |
| Office supplies |
$20,120.00 |
$12,703.18 |
| On call hours |
$35,000.00 |
$48,193.50 |
| Other Equipment |
$318,380.00 |
$311,338.79 |
| Other paid leave |
$0.00 |
$16,814.51 |
| Overtime |
$1,320,328.00 |
$1,589,146.26 |
| Packing supplies |
$0.00 |
$22.31 |
| Paint/painting supplies |
$7,165.00 |
$11,786.58 |
| Parental Leave |
$0.00 |
$60,162.08 |
| Parts for equipment |
$903,479.00 |
$887,025.11 |
| Personal holiday pay |
$0.00 |
$98,503.48 |
| Personnel savings |
($899,498.00) |
$0.00 |
| Phone allowance |
$7,140.00 |
$16,919.81 |
| Pipes and fittings |
$113,757.00 |
$89,436.13 |
| Postage |
$53.00 |
$0.00 |
| Printing/binding/photo/repr |
$960.00 |
$379.50 |
| Priority mail/parcel services |
$850.00 |
$1,433.57 |
| Professional registration |
$14,863.00 |
$16,095.02 |
| Radio equipment |
$0.00 |
$62.06 |
| Regular wages - full-time |
$10,584,163.00 |
$7,183,559.84 |
| Relays and relaying equipment |
$33,358.00 |
$26,168.16 |
| Rental-heavy equipment |
$40,000.00 |
$40,264.46 |
| Rental-other equipment |
$22,510.00 |
$13,587.56 |
| Rental-vehicles/buses |
$2,265.00 |
$7,126.31 |
| Safety equipment |
$395,373.00 |
$218,144.86 |
| Sand/gravel/stone |
$50,000.00 |
$7,957.75 |
| Seasonal employees |
$0.00 |
$75,031.51 |
| Security equipment |
$5,000.00 |
$2,969.15 |
| Services-Bio Solid Reuse |
$2,445,000.00 |
$2,267,830.93 |
| Services-Dumpster Collection |
$232,000.00 |
$112,190.39 |
| Services-IT Installations |
$3,507.00 |
$0.00 |
| Services-construction contr |
$15,000.00 |
$380.52 |
| Services-hazardous mat disp |
$1,500.00 |
$0.00 |
| Services-other |
$2,040,390.00 |
$1,710,105.12 |
| Services-testing |
$154,000.00 |
$136,329.17 |
| Shift differential |
$50,691.00 |
$49,441.48 |
| Sick pay |
$0.00 |
$349,441.02 |
| Small electric motors-water ut |
$60,505.00 |
$14,640.94 |
| Small tools/minor equipment |
$354,429.00 |
$442,475.02 |
| Software |
$31,900.00 |
$34,719.67 |
| Stability pay |
$91,000.00 |
$110,976.93 |
| Street/traff signs/mrkr/pos |
$6,188.00 |
$18,954.63 |
| Subscriptions |
$3,000.00 |
$0.00 |
| Telephone-cellular phones |
$10,500.00 |
$0.00 |
| Temporary employees |
$0.00 |
$8,453.54 |
| Terminal pay |
$54,593.00 |
$44,582.30 |
| Toll Road - Tx Tag |
$0.00 |
$557.62 |
| Training-city wide |
$0.00 |
$321.95 |
| Transportation-city veh fuel |
$146,575.00 |
$86,019.17 |
| Vacation pay |
$0.00 |
$567,122.55 |
| Valves |
$91,788.00 |
$76,326.15 |
| Wastewater svcs-interlocal |
$820,000.00 |
$431,801.71 |
| Welding supplies |
$6,027.00 |
$3,542.11 |
| |
$45,267,187.00 |
$39,280,030.00
|
|
|
| OTHER UTILITY PROGRAM REQUIREMENTS |
| Other Utility Program Requirements |
| Arbitrage rebate-admin exp |
$10,008.00 |
$5,005.78 |
| Bad Debt Expense |
$536,415.00 |
$855,617.61 |
| Bond issue costs |
$68,000.00 |
$191,227.04 |
| Claims-auto liability |
$20,000.00 |
$9,515.50 |
| Claims-general liability |
$50,000.00 |
$0.00 |
| Commercial paper admin exp |
$1,262,632.00 |
$905,511.72 |
| Compensation Adjustment |
$188,387.00 |
$0.00 |
| Consultant-financial |
$125,000.00 |
$12,760.00 |
| Educational/promotional |
$479,263.00 |
$0.00 |
| FICA tax |
$403.00 |
$0.00 |
| Facilities Management Support |
$262,935.00 |
$241,023.75 |
| Federal unemployment tax co |
$14,500.00 |
$22,688.03 |
| Fire/Extend Coverage Insurance |
$1,250,390.00 |
$924,985.71 |
| Food/Ice |
$0.00 |
$547.20 |
| Garbage/refuse collection |
$52,000.00 |
$53,737.12 |
| Government permits and fees |
$25,000.00 |
$39,194.73 |
| Grants to subrecipients |
$50,000.00 |
$14,571.40 |
| Interdepartmental Charges |
$589,300.00 |
$3,900.00 |
| Market Study Adjustment |
$32,816.00 |
$0.00 |
| Medical/dental supplies |
$0.00 |
$43,296.20 |
| Medicare tax |
$94.00 |
$0.00 |
| Rental-real estate-office |
$1,159.00 |
$0.00 |
| Services-Credit Card Fees |
$60,000.00 |
$0.00 |
| Services-Software as a Service |
$11,250.00 |
$0.00 |
| Services-appraisal |
$0.00 |
$2,125.00 |
| Services-legal fees |
$175,000.00 |
$82.00 |
| Services-other |
$1,942,274.00 |
$55.00 |
| Shift differential |
$190,605.00 |
$0.00 |
| Software |
$61,500.00 |
$81,400.00 |
| Structured settlements |
$50,000.00 |
$31,092.06 |
| Temporary employees |
$6,498.00 |
$0.00 |
| Util rev bnd commission exp |
$6,042.00 |
$2,721.25 |
| Wastewater svcs-interlocal |
$62,400.00 |
$0.00 |
| Wireless Communications-maint |
$15,373.00 |
$0.00 |
| |
$7,599,244.00 |
$3,441,057.10
|
|
|
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$264,320.18 |
| Allowances/other pay |
$17,309.00 |
$7,135.16 |
| Awards and Recognition |
$31,230.00 |
$11,990.55 |
| Bilingual Pay |
$5,400.00 |
$2,127.84 |
| Boiler equipment |
$500.00 |
$0.00 |
| Books-library |
$3,084.00 |
$1,371.78 |
| Building material |
$17,740.00 |
$4,023.59 |
| Call back time |
$4,774.00 |
$2,698.84 |
| Chemicals |
$3,227.00 |
$10,177.63 |
| Clothing allowances |
$0.00 |
$2,203.16 |
| Clothing/clothing material |
$29,032.00 |
$15,780.99 |
| Communications Equipment |
$0.00 |
$6,166.46 |
| Comp time used |
$0.00 |
$66.92 |
| Const/repair material-other |
$4,000.00 |
$3,455.38 |
| Consulting-information technology |
$103,154.00 |
$70,380.73 |
| Contribution to employees ret |
$1,487,062.00 |
$1,570,733.62 |
| Dept OH distribtd to indire |
$0.00 |
($1,234.80) |
| Drainage fee expense |
$82,395.00 |
$91,869.50 |
| Educational incentive pay |
$10,100.00 |
$16,853.36 |
| Educational travel |
$180,613.00 |
$187,894.98 |
| Educational/promotional |
$54,643.00 |
$42,864.05 |
| Elctrcal conductors-hardware |
$1,700.00 |
$208.77 |
| Electric services |
$338,800.00 |
$378,573.44 |
| Electrical/lighting |
$137,816.00 |
$150,793.54 |
| Emergency leave |
$0.00 |
$42,264.86 |
| Employee recruiting |
$14,318.00 |
$14,897.61 |
| Exception vacation |
$0.00 |
$4,792.67 |
| Expense refunds |
($280,000.00) |
($450,060.19) |
| FICA tax |
$997,158.00 |
$1,047,119.93 |
| Fleet-equip.preventative maint |
$16,065.00 |
$24,565.89 |
| Food/Ice |
$48,555.00 |
$32,005.30 |
| Freight |
$250.00 |
$2,959.79 |
| Garbage/refuse collection |
$1,700.00 |
$1,496.95 |
| Gas/heating fuels |
$6,500.00 |
$13,870.74 |
| Gasoline/oil/grease |
$1,072.00 |
$918.24 |
| Government permits and fees |
$500.00 |
$266.11 |
| Hardware/wire/steel |
$14,050.00 |
$6,232.34 |
| Holiday pay |
$0.00 |
$1,100,622.26 |
| Holidays worked |
$930.00 |
$20,319.00 |
| Household/cleaning supplies |
$15,113.00 |
$7,782.11 |
| Indirect costs-FMC 74-4 |
$0.00 |
$1,234.80 |
| Insurance-health/life/dental |
$2,533,182.00 |
$2,393,271.47 |
| Insurance-temporary employees |
$0.00 |
$51,561.87 |
| Interdepartmental Charges |
$3,500.00 |
$0.00 |
| Jury leave |
$0.00 |
$5,308.25 |
| Maintenance-boilers |
$3,000.00 |
$0.00 |
| Maintenance-buildings |
$653,900.00 |
$525,206.52 |
| Maintenance-chillers |
$1,000.00 |
$0.00 |
| Maintenance-computer hardware |
$311,465.00 |
$71,162.77 |
| Maintenance-computer software |
$1,124,323.00 |
$632,581.79 |
| Maintenance-electric motors |
$250.00 |
$804.30 |
| Maintenance-grounds |
$200,000.00 |
$232,206.17 |
| Maintenance-other equipment |
$3,050.00 |
$2,921.01 |
| Medical/dental supplies |
$21,796.00 |
$20,698.52 |
| Medicare tax |
$235,260.00 |
$247,019.98 |
| Memberships |
$162,112.00 |
$168,916.41 |
| Mileage reimbursements |
$8,829.00 |
$2,553.85 |
| Minor communications equipment |
$0.00 |
$2,271.45 |
| Minor computer hardware |
$318,601.00 |
$276,624.55 |
| Office furnishings |
$87,500.00 |
$2,491.39 |
| Office supplies |
$24,951.00 |
$19,142.37 |
| On call hours |
$19,894.00 |
$13,477.50 |
| Other Equipment |
$0.00 |
$40,860.40 |
| Other paid leave |
$0.00 |
$10,459.55 |
| Overtime |
$79,340.00 |
$135,358.13 |
| Paint/painting supplies |
$8,100.00 |
$1,057.64 |
| Parental Leave |
$0.00 |
$98,412.82 |
| Parking costs |
$300.00 |
$0.00 |
| Parts for equipment |
$16,988.00 |
$41,194.64 |
| Personal holiday pay |
$0.00 |
$279,951.94 |
| Personnel savings |
($1,342,466.00) |
$0.00 |
| Phone allowance |
$69,678.00 |
$101,782.48 |
| Pipes and fittings |
$11,240.00 |
$5,842.25 |
| Postage |
$0.00 |
$42.19 |
| Printing/binding/photo/repr |
$825.00 |
$162.22 |
| Priority mail/parcel services |
$47,500.00 |
$29,018.00 |
| Professional registration |
$15,155.00 |
$5,484.65 |
| Radio equipment |
$137,500.00 |
$15,664.88 |
| Refrigerant components-HVAC |
$20,000.00 |
$35,614.69 |
| Regular wages - full-time |
$15,490,210.00 |
$12,582,932.23 |
| Regular wages - part-time |
$0.00 |
$5,026.95 |
| Reimbursement of CIP charge |
($12,026.00) |
($5,050.51) |
| Rental-copy machines |
$182,100.00 |
$105,504.79 |
| Rental-other equipment |
$25,481.00 |
$25,897.16 |
| Rental-real estate-other |
$93,900.00 |
$90,176.93 |
| Rental-vehicles/buses |
$500.00 |
$734.26 |
| Safety equipment |
$165,828.00 |
$80,799.06 |
| Seasonal employees |
$0.00 |
$140,105.69 |
| Security equipment |
$3,150.00 |
$23,377.55 |
| Seminar/training fees |
$109,524.00 |
$57,804.35 |
| Services - Contractual Electrical |
$58,400.00 |
$2,895.88 |
| Services - Contractual General Trades |
$550.00 |
$0.00 |
| Services - Contracutal HVAC |
$500,000.00 |
$424,504.75 |
| Services - Fire Alarms |
$85,000.00 |
$69,402.56 |
| Services-IT |
$74,141.00 |
$0.00 |
| Services-IT Installations |
$3,000.00 |
$2,199.42 |
| Services-IT staffing |
$372,600.00 |
$303,550.00 |
| Services-Platform as a Service |
$390,474.00 |
$108,762.82 |
| Services-Software as a Service |
$736,307.00 |
$1,039,548.33 |
| Services-hazardous mat disp |
$1,111.00 |
$0.00 |
| Services-inspection |
$6,000.00 |
$1,144.00 |
| Services-internet/cable |
$46,795.00 |
$17,910.76 |
| Services-janitorial |
$640,000.00 |
$483,294.51 |
| Services-medical/surgical |
$37,500.00 |
$23,051.25 |
| Services-other |
$159,249.00 |
$102,840.17 |
| Services-pest control |
$25,000.00 |
$16,566.31 |
| Services-security |
$1,142,550.00 |
$956,167.97 |
| Services-testing |
$8,000.00 |
$617.76 |
| Severance pay |
$0.00 |
$2,180.68 |
| Shift differential |
$0.00 |
$5,187.40 |
| Sick pay |
$0.00 |
$673,967.08 |
| Small electric motors-water ut |
$1,000.00 |
$0.00 |
| Small tools/minor equipment |
$72,050.00 |
$133,259.91 |
| Software |
$22,507.00 |
$30,978.06 |
| Stability pay |
$191,900.00 |
$179,400.00 |
| Street/traff signs/mrkr/pos |
$15.00 |
$0.00 |
| Subscriptions |
$4,304.00 |
$1,615.00 |
| Telephone-base cost |
$136,475.00 |
$53,687.78 |
| Telephone-cellular phones |
$267,800.00 |
$107,865.15 |
| Temporary employees |
$575,835.00 |
$463,097.33 |
| Terminal pay |
$5,605.00 |
$64,061.19 |
| Toll Road - Tx Tag |
$8,000.00 |
$1,042.35 |
| Training-city wide |
$5,661.00 |
$0.00 |
| Transportation fee expense |
$20,000.00 |
($37,577.04) |
| Transportation-city veh fuel |
$7,726.00 |
$5,623.83 |
| Vacation pay |
$0.00 |
$1,375,592.89 |
| Valves |
$3,294.00 |
$36,727.26 |
| Welding supplies |
$530.00 |
$0.00 |
| |
$29,793,609.00 |
$29,937,344.55
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Debt Transfers |
| Commercial paper interest |
$3,893,436.00 |
$5,210,966.26 |
| Interest payment D/S funds |
$0.00 |
$7,755.96 |
| Principal payment D/S funds |
$0.00 |
$364,986.50 |
| Tfr to Util D/S Tax/Rev Bonds |
$380,498.00 |
$7,755.96 |
| Tfr to Utility D/S Sub Lien |
$0.00 |
$114.14 |
| Trf to GO Debt Service |
$665,319.00 |
$649,294.00 |
| Trf to Util D/S Separate Lien |
$87,099,911.00 |
$69,869,280.95 |
| |
$92,039,164.00 |
$76,110,153.77
|
|
| Interfund Transfers |
| Administrative Support |
$8,562,283.00 |
$7,848,759.38 |
| CTECC Support |
$15,850.00 |
$15,850.00 |
| CTM Support |
$3,285,868.00 |
$3,012,045.63 |
| Regional Radio System |
$419,466.00 |
$384,510.50 |
| TRF CRF to Debt Defeasance |
$10,000,000.00 |
$9,990,163.62 |
| TRF Operating to Debt Defeasance |
$900,000.00 |
$900,000.00 |
| Trf to CIP Mgm - CPM |
$3,554,667.00 |
$3,258,444.75 |
| Trf to Economic Development |
$2,023,856.00 |
$1,855,201.37 |
| Trf to General Fund |
$26,555,943.00 |
$24,342,947.75 |
| Trf to Wastewater CIP Fund |
$90,150,000.00 |
$82,361,490.00 |
| Workers' Compensation |
$755,129.00 |
$692,201.62 |
| |
$146,223,062.00 |
$134,661,614.62
|
|
| Other Requirements |
| Accrued Payroll |
$329,156.00 |
$329,156.00 |
| Contribution to employees ret |
$6,070,317.00 |
$5,451,020.80 |
| Interdepartmental Charges |
$219,850.00 |
$201,529.13 |
| Trf to PID Fund |
$37,500.00 |
$37,500.00 |
| Utility Billing System Support |
$9,624,403.00 |
$8,822,369.42 |
| |
$16,281,226.00 |
$14,841,575.35
|
|
|
|
| AUSTIN WATER WATER UTILITY OPERATING FUND |
BUDGET |
EXPENDITURES |
| CUSTOMER EXPERIENCE |
| Advanced Metering Infrastructure |
| Administrative leave |
$0.00 |
$8,809.32 |
| Allowances/other pay |
$1,000.00 |
$375.00 |
| Awards and Recognition |
$480.00 |
$277.52 |
| Books-library |
$563.00 |
$60.74 |
| Clothing/clothing material |
$1,000.00 |
$936.62 |
| Computer supplies |
$449.00 |
$0.00 |
| Contribution to employees ret |
$90,339.00 |
$77,307.32 |
| Dept OH distribtd to indire |
$0.00 |
($34,605.54) |
| FICA tax |
$62,586.00 |
$52,650.68 |
| Food/Ice |
$327.00 |
$2,471.77 |
| Holiday pay |
$0.00 |
$35,265.70 |
| Holidays worked |
$0.00 |
$362.84 |
| Indirect costs-FMC 74-4 |
$0.00 |
$34,605.54 |
| Insurance-health/life/dental |
$131,168.00 |
$98,195.37 |
| Interdepartmental Charges |
$0.00 |
$4,381.44 |
| Medicare tax |
$14,635.00 |
$12,313.40 |
| Memberships |
$550.00 |
$0.00 |
| Mileage reimbursements |
$474.00 |
$0.00 |
| Minor computer hardware |
$468.00 |
$58.69 |
| Office supplies |
$506.00 |
$0.00 |
| Overtime |
$0.00 |
$276.19 |
| Personal holiday pay |
$0.00 |
$10,490.71 |
| Personnel savings |
($80,933.00) |
$0.00 |
| Phone allowance |
$8,800.00 |
$7,419.15 |
| Professional registration |
$571.00 |
$704.59 |
| Regular wages - full-time |
$941,040.00 |
$664,543.58 |
| Reimbursement of CIP charge |
($69,000.00) |
($90,237.48) |
| Rental-other equipment |
$500.00 |
$0.00 |
| Rental-vehicles/buses |
$553.00 |
$0.00 |
| Safety equipment |
$1,500.00 |
$2,154.30 |
| Services-other |
$36,500.00 |
$0.00 |
| Sick pay |
$0.00 |
$28,010.07 |
| Small tools/minor equipment |
$2,000.00 |
$2,044.87 |
| Software |
$969.00 |
$0.00 |
| Stability pay |
$6,400.00 |
$7,900.00 |
| Temporary employees |
$57,200.00 |
$51,623.06 |
| Vacation pay |
$0.00 |
$57,266.25 |
| |
$1,210,645.00 |
$1,035,661.70
|
|
| Customer Services |
| Administrative leave |
$0.00 |
$1,934.79 |
| Allowances/other pay |
$1,100.00 |
$2,956.92 |
| Awards and Recognition |
$1,800.00 |
$1,271.30 |
| Bilingual Pay |
$7,200.00 |
$4,237.18 |
| Clothing/clothing material |
$3,925.00 |
$317.75 |
| Contribution to employees ret |
$252,896.00 |
$157,775.37 |
| Educational travel |
$0.00 |
$4,002.54 |
| Educational/promotional |
$3,500.00 |
$1,783.11 |
| Employee recruiting |
$0.00 |
$595.39 |
| FICA tax |
$176,639.00 |
$110,591.46 |
| Fleet-equip.preventative maint |
$15,854.00 |
$11,534.16 |
| Food/Ice |
$2,802.00 |
$2,793.79 |
| Hardware/wire/steel |
$126.00 |
$255.52 |
| Holiday pay |
$0.00 |
$10,404.49 |
| Holidays worked |
$7,000.00 |
$6,032.86 |
| Household/cleaning supplies |
$53.00 |
$0.00 |
| Insurance-health/life/dental |
$500,078.00 |
$289,222.31 |
| Insurance-temporary employees |
$0.00 |
$27,843.40 |
| Interdepartmental Charges |
$99,087.00 |
$99,087.57 |
| Medical/dental supplies |
$88.00 |
$0.00 |
| Medicare tax |
$41,737.00 |
$26,302.78 |
| Meters |
$713,089.00 |
$668,571.05 |
| Mileage reimbursements |
$75.00 |
$327.82 |
| Minor computer hardware |
$3,329.00 |
$0.00 |
| Office furnishings |
$0.00 |
$570.95 |
| Office supplies |
$5,370.00 |
$2,734.98 |
| On call hours |
$0.00 |
$424.00 |
| Overtime |
$56,698.00 |
$61,526.36 |
| Personnel savings |
($232,620.00) |
$0.00 |
| Phone allowance |
$7,980.00 |
$6,956.20 |
| Professional registration |
$353.00 |
$2,799.35 |
| Raw water - purchased |
$5,000.00 |
$2,899.00 |
| Regular wages - full-time |
$2,634,349.00 |
$1,593,859.21 |
| Safety equipment |
$1,007.00 |
$124.81 |
| Seasonal employees |
$0.00 |
$11,113.38 |
| Seminar/training fees |
$0.00 |
$576.58 |
| Services-interpretation |
$0.00 |
$321.16 |
| Services-other |
$50,000.00 |
$38,322.94 |
| Services-translators |
$1,071.00 |
$881.76 |
| Shift differential |
$7,000.00 |
$6,158.87 |
| Sick pay |
$0.00 |
$4,424.69 |
| Small tools/minor equipment |
$1,116.00 |
$3,237.25 |
| Software |
$697.00 |
$0.00 |
| Stability pay |
$16,950.00 |
$443.75 |
| Subscriptions |
$22,250.00 |
$26,532.97 |
| Temporary employees |
$213,316.00 |
$170,946.10 |
| Terminal pay |
$6,202.00 |
$0.00 |
| Toll Road - Tx Tag |
$0.00 |
$1.72 |
| Training-city wide |
$4,124.00 |
$109.75 |
| Transportation-city veh fuel |
$7,497.00 |
$9,796.65 |
| Vacation pay |
$0.00 |
$14,377.35 |
| |
$4,638,738.00 |
$3,386,981.34
|
|
| Public Affairs |
| Administrative leave |
$0.00 |
$100.91 |
| Advertising/publication |
$1,467,562.00 |
$1,144,710.88 |
| Awards and Recognition |
$570.00 |
$400.00 |
| Bilingual Pay |
$1,800.00 |
$843.47 |
| Call back time |
$3,000.00 |
$1,229.39 |
| Contribution to employees ret |
$88,960.00 |
$55,373.26 |
| Educational/promotional |
$130,516.00 |
$118,341.23 |
| Exp Reimb - Public Information Requests |
$0.00 |
($468.00) |
| FICA tax |
$59,131.00 |
$36,632.77 |
| Fleet-equip.preventative maint |
$3,169.00 |
$0.00 |
| Food/Ice |
$3,000.00 |
$1,646.34 |
| Holiday pay |
$0.00 |
$100.65 |
| Holidays worked |
$100.00 |
$100.65 |
| Insurance-health/life/dental |
$155,762.00 |
$94,381.73 |
| Interdepartmental Charges |
$17,602.00 |
$12,056.41 |
| Medicare tax |
$13,832.00 |
$8,566.06 |
| Memberships |
$250.00 |
$0.00 |
| Office supplies |
$3,000.00 |
$854.04 |
| On call hours |
$5,000.00 |
$5,751.00 |
| Overtime |
$5,000.00 |
$11,121.03 |
| Personal holiday pay |
$0.00 |
$326.98 |
| Personnel savings |
($78,510.00) |
$0.00 |
| Phone allowance |
$7,020.00 |
$4,841.28 |
| Printing/binding/photo/repr |
$167,271.00 |
$133,923.46 |
| Regular wages - full-time |
$926,676.00 |
$572,325.55 |
| Safety equipment |
$200.00 |
$568.43 |
| Services-other |
$1,041,400.00 |
$7,814.49 |
| Sick pay |
$0.00 |
$117.88 |
| Small tools/minor equipment |
$2,833.00 |
$1,780.27 |
| Software |
$2,000.00 |
$0.00 |
| Stability pay |
$5,350.00 |
$0.00 |
| Subscriptions |
$21,650.00 |
$12,026.08 |
| Temporary employees |
$12,766.00 |
$10,142.14 |
| Terminal pay |
$997.00 |
$0.00 |
| Toll Road - Tx Tag |
$0.00 |
$5.19 |
| Transportation-city veh fuel |
$1,620.00 |
$532.56 |
| Vacation pay |
$0.00 |
$918.32 |
| |
$4,069,527.00 |
$2,237,064.45
|
|
| Special Services |
| Administrative leave |
$0.00 |
$6,297.62 |
| Advertising/publication |
$3,500.00 |
$3,438.32 |
| Allowances/other pay |
$6,000.00 |
$1,162.72 |
| Awards and Recognition |
$1,080.00 |
$1,050.89 |
| Bilingual Pay |
$3,700.00 |
$4,254.55 |
| Books-library |
$900.00 |
$550.93 |
| Building material |
$106.00 |
$0.00 |
| Clothing/clothing material |
$1,061.00 |
$814.34 |
| Computer supplies |
$110.00 |
$55.92 |
| Contribution to employees ret |
$119,004.00 |
$89,475.68 |
| Educational/promotional |
$2,800.00 |
$1,098.15 |
| Emergency leave |
$0.00 |
$2,232.48 |
| FICA tax |
$77,749.00 |
$56,842.55 |
| Fleet-equip.preventative maint |
$31,238.00 |
$29,520.48 |
| Food/Ice |
$1,250.00 |
$1,067.96 |
| Holiday pay |
$0.00 |
$35,402.47 |
| Holidays worked |
$0.00 |
$345.37 |
| Household/cleaning supplies |
$110.00 |
$0.00 |
| Insurance-health/life/dental |
$213,148.00 |
$146,680.58 |
| Jury leave |
$0.00 |
$637.61 |
| Maintenance-other equipment |
$200.00 |
$156.39 |
| Medical/dental supplies |
$310.00 |
$0.00 |
| Medicare tax |
$18,182.00 |
$13,293.39 |
| Memberships |
$1,720.00 |
$658.32 |
| Minor computer hardware |
$2,500.00 |
$0.00 |
| Office supplies |
$2,592.00 |
$804.62 |
| Overtime |
$200.00 |
$18,168.97 |
| Personal holiday pay |
$0.00 |
$7,865.30 |
| Personnel savings |
($106,149.00) |
$0.00 |
| Phone allowance |
$9,420.00 |
$3,413.05 |
| Photographic |
$170.00 |
$0.00 |
| Pipes and fittings |
$542.00 |
$0.00 |
| Printing/binding/photo/repr |
$3,500.00 |
$1,794.00 |
| Priority mail/parcel services |
$500.00 |
$0.00 |
| Professional registration |
$3,165.00 |
$2,246.00 |
| Regular wages - full-time |
$1,239,634.00 |
$817,085.33 |
| Safety equipment |
$3,184.00 |
$1,424.72 |
| Seminar/training fees |
$0.00 |
$503.96 |
| Services-hazardous mat disp |
$55.00 |
$0.00 |
| Sick pay |
$0.00 |
$15,686.57 |
| Small tools/minor equipment |
$6,746.00 |
$2,125.12 |
| Software |
$2,000.00 |
$0.00 |
| Stability pay |
$8,250.00 |
$6,100.00 |
| Terminal pay |
$18,500.00 |
$0.00 |
| Training-city wide |
$2,000.00 |
$0.00 |
| Transportation-city veh fuel |
$2,681.00 |
$3,333.71 |
| Vacation pay |
$0.00 |
$43,555.88 |
| |
$1,681,658.00 |
$1,319,143.95
|
|
| Water Meter Maintenance |
| Accident pay |
$0.00 |
$14,210.73 |
| Administrative leave |
$0.00 |
$35,752.01 |
| Allowances/other pay |
$32,100.00 |
$16,084.34 |
| Awards and Recognition |
$2,580.00 |
$2,314.81 |
| Bilingual Pay |
$18,000.00 |
$14,316.46 |
| Building material |
$500.00 |
$524.02 |
| Call back time |
$98,880.00 |
$87,468.00 |
| Cement/concrete |
$500.00 |
$113.84 |
| Chemicals |
$1,279.00 |
$975.11 |
| Clothing/clothing material |
$16,567.00 |
$21,547.87 |
| Contribution to employees ret |
$323,059.00 |
$284,981.23 |
| Dietary hardware |
$300.00 |
$288.35 |
| Educational incentive pay |
$10,000.00 |
$9,601.28 |
| Electrical/lighting |
$2,132.00 |
$339.51 |
| Emergency leave |
$0.00 |
$7,024.37 |
| Exception vacation |
$0.00 |
$32.55 |
| FICA tax |
$226,135.00 |
$228,066.39 |
| Fleet-equip. vehicle/equipment modification |
$10,000.00 |
$3,761.88 |
| Fleet-equip.preventative maint |
$191,834.00 |
$162,314.25 |
| Food/Ice |
$3,500.00 |
$4,837.35 |
| Gasoline/oil/grease |
$640.00 |
$423.59 |
| Government permits and fees |
$500.00 |
$1,465.00 |
| Hardware/wire/steel |
$21,321.00 |
$6,076.21 |
| Holiday pay |
$0.00 |
$144,744.17 |
| Holidays worked |
$1,000.00 |
$429.56 |
| Household/cleaning supplies |
$3,198.00 |
$2,238.72 |
| Insurance-health/life/dental |
$705,028.00 |
$568,294.94 |
| Insurance-temporary employees |
$0.00 |
$38,947.29 |
| Jury leave |
$0.00 |
$872.72 |
| Medical/dental supplies |
$2,345.00 |
$695.27 |
| Medicare tax |
$52,879.00 |
$53,337.93 |
| Meter parts |
$40,655.00 |
$102,652.26 |
| Meters |
$449,049.00 |
$713,010.12 |
| Minor computer hardware |
$373.00 |
$2,048.46 |
| Office furnishings |
$0.00 |
$275.48 |
| Office supplies |
$5,330.00 |
$7,834.60 |
| On call hours |
$44,931.00 |
$44,401.28 |
| Other paid leave |
$0.00 |
$14,596.97 |
| Overtime |
$254,711.00 |
$407,315.23 |
| Paint/painting supplies |
$500.00 |
$569.42 |
| Parental Leave |
$0.00 |
$61,063.35 |
| Parts for equipment |
$640.00 |
$6,015.43 |
| Parts for vehicles |
$3,605.00 |
$2,658.46 |
| Personal holiday pay |
$0.00 |
$31,313.57 |
| Personnel savings |
($269,316.00) |
$0.00 |
| Phone allowance |
$18,598.00 |
$18,181.16 |
| Pipes and fittings |
$30,900.00 |
$35,965.43 |
| Postage |
$600.00 |
$1,158.80 |
| Professional registration |
$2,000.00 |
$3,306.64 |
| Pull boxes,svc boxes,manholes |
$37,469.00 |
$11,257.37 |
| Regular wages - full-time |
$3,365,220.00 |
$2,301,065.80 |
| Rental-vehicles/buses |
$2,000.00 |
$1,563.28 |
| Safety equipment |
$27,132.00 |
$32,242.05 |
| Services-other |
$1,082,542.00 |
$124,196.84 |
| Shift differential |
$1,500.00 |
$891.71 |
| Sick pay |
$0.00 |
$133,735.46 |
| Small tools/minor equipment |
$68,540.00 |
$54,734.86 |
| Stability pay |
$32,200.00 |
$38,352.34 |
| Temporary employees |
$213,325.00 |
$184,400.04 |
| Terminal pay |
$1,495.00 |
$26,023.72 |
| Toll Road - Tx Tag |
$0.00 |
$355.77 |
| Transportation-city veh fuel |
$57,912.00 |
$73,388.97 |
| Vacation pay |
$0.00 |
$226,181.53 |
| Valves |
$49,251.00 |
$43,198.84 |
| Welding supplies |
$9,594.00 |
$10,273.73 |
| |
$7,255,033.00 |
$6,426,308.72
|
|
|
| ENGINEERING AND TECHNICAL SERVICES |
| Engineering and Technical Services Operations |
| Accident pay |
$0.00 |
$10,798.84 |
| Administrative leave |
$0.00 |
$23,454.35 |
| Allowances/other pay |
$13,210.00 |
$5,211.56 |
| Awards and Recognition |
$1,560.00 |
$244.13 |
| Books-library |
$1,469.00 |
$1,360.19 |
| Building material |
$918.00 |
$84.84 |
| Call back time |
$38,338.00 |
$26,270.64 |
| Chemicals |
$700.00 |
$338.25 |
| Clothing/clothing material |
$34,766.00 |
$17,605.60 |
| Computer supplies |
$154.00 |
$107.97 |
| Const/repair material-other |
$150.00 |
$87.04 |
| Contribution to employees ret |
$229,335.00 |
$185,391.91 |
| Educational incentive pay |
$6,500.00 |
$9,419.17 |
| Elctrcal conductors-hardware |
$116.00 |
$0.00 |
| Elctrcal conductors-wire&cable |
$3,526.00 |
$3,263.79 |
| Electrical/lighting |
$5,315.00 |
$19,212.98 |
| Emergency leave |
$0.00 |
$3,246.80 |
| FICA tax |
$151,202.00 |
$130,341.08 |
| Fleet-equip.preventative maint |
$51,419.00 |
$105,555.15 |
| Food/Ice |
$1,741.00 |
$1,617.03 |
| Fuses and fusing apparatus |
$300.00 |
$384.74 |
| Gasoline/oil/grease |
$206.00 |
$54.04 |
| Hardware/wire/steel |
$1,300.00 |
$1,540.04 |
| Holiday pay |
$0.00 |
$59,713.00 |
| Holidays worked |
$0.00 |
$42.57 |
| Household/cleaning supplies |
$1,033.00 |
$837.92 |
| Identification |
$692.00 |
$398.24 |
| Insurance-health/life/dental |
$380,048.00 |
$272,977.71 |
| Interdepartmental reimbursements |
($21,016.00) |
$0.00 |
| Medical/dental supplies |
$387.00 |
$13.60 |
| Medicare tax |
$35,360.00 |
$30,481.62 |
| Memberships |
$360.00 |
$158.00 |
| Mileage reimbursements |
$1,000.00 |
$570.32 |
| Minor computer hardware |
$1,447.00 |
$1,129.95 |
| Office supplies |
$5,786.00 |
$4,538.78 |
| On call hours |
$36,982.00 |
$24,079.00 |
| Other costs |
$2,112.00 |
$134.94 |
| Other paid leave |
$15,557.00 |
$6,825.78 |
| Overtime |
$137,705.00 |
$131,103.75 |
| Paint/painting supplies |
$457.00 |
$218.88 |
| Parts for equipment |
$8,860.00 |
$8,437.32 |
| Parts for vehicles |
$1,140.00 |
$200.94 |
| Personal holiday pay |
$0.00 |
$15,636.13 |
| Personnel savings |
($203,851.00) |
$0.00 |
| Phone allowance |
$20,497.00 |
$12,756.72 |
| Pipes and fittings |
$1,775.00 |
$2.90 |
| Priority mail/parcel services |
$165.00 |
$117.69 |
| Professional registration |
$885.00 |
$0.00 |
| Regular wages - full-time |
$2,388,909.00 |
$1,704,451.12 |
| Safety equipment |
$38,427.00 |
$26,728.02 |
| Services-hazardous mat disp |
$205.00 |
$0.00 |
| Services-other |
$1,285.00 |
$388.69 |
| Services-testing |
$11,090.00 |
$4,066.91 |
| Sick pay |
$0.00 |
$33,536.49 |
| Small tools/minor equipment |
$30,835.00 |
$37,041.10 |
| Software |
$3,999.00 |
$949.02 |
| Stability pay |
$13,575.00 |
$19,334.33 |
| Telephone-cellular phones |
$1,200.00 |
$0.00 |
| Temporary employees |
$26,134.00 |
$21,788.06 |
| Terminal pay |
$15,729.00 |
$2,875.91 |
| Toll Road - Tx Tag |
$30.00 |
$110.90 |
| Training-city wide |
$1,000.00 |
$804.45 |
| Transportation-city veh fuel |
$17,361.00 |
$20,220.28 |
| Vacation pay |
$0.00 |
$76,562.65 |
| Welding supplies |
$118.00 |
$0.00 |
| |
$3,519,503.00 |
$3,064,823.83
|
|
| Facility Engineering |
| Administrative leave |
$0.00 |
$3,995.95 |
| Allowances/other pay |
$2,000.00 |
$636.79 |
| Awards and Recognition |
$750.00 |
$0.00 |
| Books-library |
$0.00 |
$705.69 |
| Consultant-others |
$180,000.00 |
$45,715.28 |
| Contribution to employees ret |
$153,098.00 |
$93,905.11 |
| Dept OH distribtd to indire |
$0.00 |
($140,977.86) |
| Emergency leave |
$0.00 |
$834.45 |
| FICA tax |
$100,949.00 |
$59,273.70 |
| Fleet-equip.preventative maint |
$6,262.00 |
$0.00 |
| Food/Ice |
$1,500.00 |
$217.01 |
| Holiday pay |
$0.00 |
$32,242.53 |
| Holidays worked |
$0.00 |
$115.78 |
| Indirect costs-FMC 74-4 |
$0.00 |
$140,977.86 |
| Insurance-health/life/dental |
$196,752.00 |
$127,823.55 |
| Interpeptl-PW PMD charges |
$20,000.00 |
$3,164.34 |
| Maintenance-computer hardware |
$500.00 |
$150.26 |
| Medicare tax |
$23,978.00 |
$13,985.06 |
| Memberships |
$1,200.00 |
$397.50 |
| Mileage reimbursements |
$1,000.00 |
$1,228.68 |
| Minor computer hardware |
$200.00 |
$103.47 |
| Office supplies |
$1,000.00 |
$236.41 |
| Overtime |
$2,000.00 |
$669.68 |
| Personal holiday pay |
$0.00 |
$7,534.91 |
| Personnel savings |
($135,484.00) |
$0.00 |
| Phone allowance |
$4,800.00 |
$3,171.74 |
| Printing/binding/photo/repr |
$80.00 |
$20.43 |
| Professional registration |
$400.00 |
$120.00 |
| Regular wages - full-time |
$1,594,786.00 |
$877,315.26 |
| Reimbursement of CIP charge |
($496,526.00) |
($417,045.06) |
| Safety equipment |
$1,100.00 |
$1,886.68 |
| Seasonal employees |
$0.00 |
$19,668.63 |
| Sick pay |
$0.00 |
$15,603.24 |
| Small tools/minor equipment |
$500.00 |
$13.60 |
| Software |
$4,800.00 |
$0.00 |
| Stability pay |
$11,500.00 |
$7,303.08 |
| Temporary employees |
$42,432.00 |
$0.00 |
| Terminal pay |
$17,376.00 |
$0.00 |
| Transportation-city veh fuel |
$827.00 |
$0.00 |
| Vacation pay |
$0.00 |
$30,706.45 |
| |
$1,737,780.00 |
$931,700.20
|
|
| Pipeline Capital Improvement Projects |
| Administrative leave |
$0.00 |
$9,462.24 |
| Allowances/other pay |
$0.00 |
$667.02 |
| Awards and Recognition |
$870.00 |
$450.23 |
| Contribution to employees ret |
$122,007.00 |
$85,915.56 |
| Dept OH distribtd to indire |
$0.00 |
($83,856.57) |
| FICA tax |
$79,152.00 |
$59,333.88 |
| Food/Ice |
$634.00 |
$217.35 |
| Holiday pay |
$0.00 |
$35,541.16 |
| Indirect costs-FMC 74-4 |
$0.00 |
$83,856.57 |
| Insurance-health/life/dental |
$172,158.00 |
$109,453.49 |
| Insurance-temporary employees |
$0.00 |
$10,296.41 |
| Medicare tax |
$18,511.00 |
$13,876.17 |
| Memberships |
$646.00 |
$621.00 |
| Mileage reimbursements |
$249.00 |
$136.59 |
| Minor computer hardware |
$1,321.00 |
$1,290.92 |
| Office supplies |
$450.00 |
$432.42 |
| Overtime |
$173.00 |
$0.00 |
| Parking costs |
$200.00 |
$104.00 |
| Personal holiday pay |
$0.00 |
$7,250.54 |
| Personnel savings |
($113,438.00) |
$0.00 |
| Phone allowance |
$970.00 |
$844.62 |
| Professional registration |
$228.00 |
$125.00 |
| Regular wages - full-time |
$1,270,905.00 |
$784,595.16 |
| Reimbursement of CIP charge |
($345,099.00) |
($239,269.22) |
| Safety equipment |
$630.00 |
$408.25 |
| Sick pay |
$0.00 |
$28,404.10 |
| Stability pay |
$4,250.00 |
$4,771.87 |
| Temporary employees |
$0.00 |
$64,990.49 |
| Vacation pay |
$0.00 |
$37,082.57 |
| |
$1,214,817.00 |
$1,017,001.82
|
|
| Pipeline Engineering and Operations Support |
| Administrative leave |
$0.00 |
$10,740.77 |
| Allowances/other pay |
$0.00 |
$1,902.47 |
| Awards and Recognition |
$1,860.00 |
$500.00 |
| Bilingual Pay |
$0.00 |
$553.92 |
| Building material |
$25.00 |
$19.94 |
| Call back time |
$0.00 |
$9,867.71 |
| Clothing/clothing material |
$770.00 |
$732.16 |
| Computer supplies |
$250.00 |
$18.30 |
| Contribution to employees ret |
$199,298.00 |
$144,351.59 |
| Dept OH distribtd to indire |
$0.00 |
($21,094.62) |
| Educational travel |
$0.00 |
$1,097.30 |
| Emergency leave |
$0.00 |
$1,371.81 |
| FICA tax |
$135,468.00 |
$100,671.44 |
| Fleet-equip.preventative maint |
$19,023.00 |
$17,370.64 |
| Food/Ice |
$460.00 |
$369.13 |
| Holiday pay |
$0.00 |
$49,239.54 |
| Holidays worked |
$0.00 |
$988.62 |
| Household/cleaning supplies |
$95.00 |
$87.18 |
| Indirect costs-FMC 74-4 |
$0.00 |
$21,094.62 |
| Insurance-health/life/dental |
$270,534.00 |
$179,793.26 |
| Insurance-temporary employees |
$0.00 |
$4,453.73 |
| Interdeptl-PW CPM charges |
$10,000.00 |
$6,099.33 |
| Maintenance-pipelines |
$965,000.00 |
$391,408.62 |
| Medical/dental supplies |
$35.00 |
$32.92 |
| Medicare tax |
$31,808.00 |
$23,634.20 |
| Memberships |
$125.00 |
$0.00 |
| Mileage reimbursements |
$1,450.00 |
$773.11 |
| Minor computer hardware |
$202.00 |
$0.00 |
| Office supplies |
$1,650.00 |
$1,415.92 |
| On call hours |
$12,206.00 |
$11,128.50 |
| Other paid leave |
$0.00 |
$1,930.23 |
| Overtime |
$40,047.00 |
$44,333.19 |
| Parking costs |
$15.00 |
$10.00 |
| Personal holiday pay |
$0.00 |
$12,847.92 |
| Personnel savings |
($177,294.00) |
$0.00 |
| Phone allowance |
$10,050.00 |
$9,383.42 |
| Pipes and fittings |
$13,000.00 |
$11,400.32 |
| Printing/binding/photo/repr |
$210.00 |
$55.00 |
| Professional registration |
$631.00 |
$420.41 |
| Regular wages - full-time |
$2,076,054.00 |
$1,341,302.29 |
| Reimbursement of CIP charge |
($112,665.00) |
($60,794.34) |
| Safety equipment |
$2,350.00 |
$1,939.41 |
| Services-other |
$122,355.00 |
$0.00 |
| Sick pay |
$0.00 |
$14,381.67 |
| Small tools/minor equipment |
$38,532.00 |
$8,745.07 |
| Software |
$7,612.00 |
$6,487.80 |
| Stability pay |
$16,600.00 |
$10,806.25 |
| Street/traff signs/mrkr/pos |
$35.00 |
$30.00 |
| Temporary employees |
$90,810.00 |
$43,524.32 |
| Terminal pay |
$20,000.00 |
$21,849.99 |
| Transportation-city veh fuel |
$10,060.00 |
$7,925.40 |
| Vacation pay |
$0.00 |
$66,104.07 |
| |
$3,808,661.00 |
$2,501,304.53
|
|
| SCADA Engineering & Support |
| Administrative leave |
$0.00 |
$452.03 |
| Allowances/other pay |
$0.00 |
$536.19 |
| Awards and Recognition |
$510.00 |
$0.00 |
| Books-library |
$338.00 |
$0.00 |
| Computer Hardware |
$49,200.00 |
$0.00 |
| Contribution to employees ret |
$103,537.00 |
$43,134.53 |
| Dept OH distribtd to indire |
$0.00 |
($21,326.40) |
| Educational incentive pay |
$1,500.00 |
$0.00 |
| FICA tax |
$67,434.00 |
$27,098.34 |
| Food/Ice |
$1,000.00 |
$121.12 |
| Indirect costs-FMC 74-4 |
$0.00 |
$21,326.40 |
| Insurance-health/life/dental |
$139,366.00 |
$51,467.19 |
| Maintenance-computer hardware |
$6,857.00 |
$0.00 |
| Maintenance-computer software |
$361,106.00 |
$241,388.20 |
| Medicare tax |
$15,808.00 |
$6,335.70 |
| Memberships |
$440.00 |
$193.00 |
| Mileage reimbursements |
$700.00 |
$582.21 |
| Minor computer hardware |
$216,197.00 |
$2,219.63 |
| Office supplies |
$1,518.00 |
$9.99 |
| Overtime |
$750.00 |
$0.00 |
| Personnel savings |
($91,538.00) |
$0.00 |
| Phone allowance |
$4,380.00 |
$1,730.30 |
| Printing/binding/photo/repr |
$50.00 |
$0.00 |
| Priority mail/parcel services |
$50.00 |
$0.00 |
| Professional registration |
$91.00 |
$50.00 |
| Regular wages - full-time |
$1,078,526.00 |
$449,738.19 |
| Reimbursement of CIP charge |
($64,378.00) |
($63,324.24) |
| Safety equipment |
$1,000.00 |
$600.25 |
| Sick pay |
$0.00 |
$717.54 |
| Small tools/minor equipment |
$851.00 |
$652.22 |
| Software |
$3,171.00 |
$17,853.71 |
| Stability pay |
$6,950.00 |
$0.00 |
| Terminal pay |
$5,000.00 |
$0.00 |
| Vacation pay |
$0.00 |
$1,381.29 |
| |
$1,910,414.00 |
$782,937.39
|
|
|
| ENVIRONMENTAL, PLANNING, AND DEVELOPMENT SERVICES |
| Environmental, Planning, and Development Support |
| Allowances/other pay |
$150.00 |
$33.75 |
| Awards and Recognition |
$150.00 |
$60.00 |
| Books-library |
$563.00 |
$0.00 |
| Contribution to employees ret |
$27,971.00 |
$20,362.17 |
| Educational travel |
$0.00 |
$787.80 |
| FICA tax |
$16,781.00 |
$12,016.49 |
| Food/Ice |
$164.00 |
$262.79 |
| Holiday pay |
$0.00 |
$1,924.78 |
| Holidays worked |
$0.00 |
$446.87 |
| Insurance-health/life/dental |
$32,792.00 |
$22,588.53 |
| Medicare tax |
$4,289.00 |
$3,029.27 |
| Memberships |
$550.00 |
$0.00 |
| Office supplies |
$253.00 |
$972.95 |
| Overtime |
$200.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$1,135.58 |
| Personnel savings |
($24,544.00) |
$0.00 |
| Phone allowance |
$1,470.00 |
$1,194.81 |
| Regular wages - full-time |
$291,351.00 |
$204,579.82 |
| Seminar/training fees |
$0.00 |
$7.57 |
| Sick pay |
$0.00 |
$568.08 |
| Software |
$317.00 |
$0.00 |
| Stability pay |
$2,850.00 |
$0.00 |
| Subscriptions |
$463.00 |
$169.68 |
| Vacation pay |
$0.00 |
$893.74 |
| |
$355,770.00 |
$271,034.68
|
|
| Infrastructure Management |
| Administrative leave |
$0.00 |
$149.95 |
| Allowances/other pay |
$2,000.00 |
$475.98 |
| Awards and Recognition |
$600.00 |
$234.30 |
| Books-library |
$250.00 |
$0.00 |
| Clothing/clothing material |
$400.00 |
$0.00 |
| Computer supplies |
$1,500.00 |
$0.00 |
| Consultant-others |
$25,000.00 |
$0.00 |
| Contribution to employees ret |
$101,876.00 |
$51,834.98 |
| Educational travel |
$0.00 |
$252.40 |
| FICA tax |
$71,093.00 |
$37,762.46 |
| Fleet-equip.preventative maint |
$3,169.00 |
$3,718.22 |
| Food/Ice |
$700.00 |
$1,293.51 |
| Holiday pay |
$0.00 |
$1,462.94 |
| Insurance-health/life/dental |
$163,960.00 |
$81,738.11 |
| Insurance-temporary employees |
$0.00 |
$4,717.22 |
| Maintenance-computer software |
$4,000.00 |
$4,709.60 |
| Medicare tax |
$16,691.00 |
$8,830.34 |
| Memberships |
$2,000.00 |
$0.00 |
| Mileage reimbursements |
$50.00 |
$57.27 |
| Minor computer hardware |
$750.00 |
$0.00 |
| Office supplies |
$1,750.00 |
$567.72 |
| Overtime |
$3,000.00 |
$0.00 |
| Personnel savings |
($90,500.00) |
$0.00 |
| Phone allowance |
$2,690.00 |
$1,664.14 |
| Professional registration |
$225.00 |
$132.00 |
| Regular wages - full-time |
$1,061,178.00 |
$536,900.03 |
| Reimbursement of CIP charge |
($1,880.00) |
$0.00 |
| Safety equipment |
$350.00 |
$220.10 |
| Seasonal employees |
$0.00 |
$12,987.45 |
| Seminar/training fees |
$0.00 |
$601.46 |
| Sick pay |
$0.00 |
$2,823.84 |
| Small tools/minor equipment |
$400.00 |
$0.00 |
| Software |
$0.00 |
$70.83 |
| Stability pay |
$8,300.00 |
$750.00 |
| Subscriptions |
$25.00 |
$13.00 |
| Temporary employees |
$79,040.00 |
$54,725.37 |
| Terminal pay |
$5,500.00 |
$0.00 |
| Toll Road - Tx Tag |
$0.00 |
$44.96 |
| Training-city wide |
$1,000.00 |
$0.00 |
| Transportation-city veh fuel |
$0.00 |
$450.89 |
| Vacation pay |
$0.00 |
$1,458.12 |
| |
$1,465,117.00 |
$810,647.19
|
|
| Systems Planning |
| Administrative leave |
$0.00 |
$7,641.16 |
| Advertising/publication |
$40.00 |
$100.00 |
| Allowances/other pay |
$3,000.00 |
$622.69 |
| Awards and Recognition |
$690.00 |
$0.00 |
| Books-library |
$225.00 |
$91.24 |
| Call back time |
$0.00 |
$107.22 |
| Consultant-others |
$523,109.00 |
$244,871.38 |
| Contribution to employees ret |
$131,286.00 |
$92,272.40 |
| Educational travel |
$0.00 |
$184.14 |
| Emergency leave |
$0.00 |
$1,635.91 |
| FICA tax |
$88,527.00 |
$59,658.89 |
| Food/Ice |
$131.00 |
$465.76 |
| Government permits and fees |
$362.00 |
$0.00 |
| Holiday pay |
$0.00 |
$28,433.97 |
| Holidays worked |
$0.00 |
$2,074.68 |
| Insurance-health/life/dental |
$195,932.00 |
$123,036.56 |
| Medicare tax |
$20,786.00 |
$14,062.08 |
| Memberships |
$110.00 |
$135.00 |
| Mileage reimbursements |
$500.00 |
$28.27 |
| Minor computer hardware |
$135.00 |
$0.00 |
| Office supplies |
$1,982.00 |
$669.90 |
| Overtime |
$4,000.00 |
$0.00 |
| Parental Leave |
$0.00 |
$19,719.03 |
| Personal holiday pay |
$0.00 |
$9,948.57 |
| Personnel savings |
($116,506.00) |
$0.00 |
| Phone allowance |
$2,496.00 |
$2,064.68 |
| Printing/binding/photo/repr |
$80.00 |
$0.00 |
| Priority mail/parcel services |
$12.00 |
$0.00 |
| Professional registration |
$1,000.00 |
$25.00 |
| Regular wages - full-time |
$1,367,530.00 |
$837,724.81 |
| Safety equipment |
$163.00 |
$539.00 |
| Seasonal employees |
$0.00 |
$25,589.07 |
| Sick pay |
$0.00 |
$17,280.78 |
| Small tools/minor equipment |
$266.00 |
$0.00 |
| Software |
$65,843.00 |
$68,761.00 |
| Stability pay |
$5,730.00 |
$4,000.00 |
| Temporary employees |
$57,408.00 |
$0.00 |
| Vacation pay |
$0.00 |
$36,159.79 |
| |
$2,354,837.00 |
$1,597,902.98
|
|
| Utility Development Services |
| Administrative leave |
$0.00 |
$2,112.15 |
| Advertising/publication |
$500.00 |
$0.00 |
| Allowances/other pay |
$5,000.00 |
$1,017.04 |
| Awards and Recognition |
$1,260.00 |
$55.01 |
| Bilingual Pay |
$5,400.00 |
$3,855.73 |
| Books-library |
$500.00 |
$77.63 |
| Clothing/clothing material |
$500.00 |
$0.00 |
| Contribution to employees ret |
$219,950.00 |
$155,370.77 |
| Dept OH distribtd to indire |
$0.00 |
($33,047.35) |
| Educational travel |
$0.00 |
$1,847.31 |
| FICA tax |
$145,160.00 |
$101,416.34 |
| Food/Ice |
$0.00 |
$642.43 |
| Government permits and fees |
$400.00 |
$0.00 |
| Grant cost-support of other |
$15,000.00 |
$0.00 |
| Holiday pay |
$0.00 |
$582.40 |
| Holidays worked |
$0.00 |
$245.70 |
| Indirect costs-FMC 74-4 |
$0.00 |
$33,047.35 |
| Insurance-health/life/dental |
$319,722.00 |
$209,379.33 |
| Interdepartmental Charges |
$75,000.00 |
$0.00 |
| Interdepartmental reimbursements |
($189,100.00) |
($28,175.85) |
| Interdeptl-PW CPM charges |
$10,000.00 |
$0.00 |
| Laundry expense |
$1,000.00 |
($125.77) |
| Medicare tax |
$33,958.00 |
$23,748.00 |
| Memberships |
$2,000.00 |
$0.00 |
| Mileage reimbursements |
$200.00 |
$69.97 |
| Minor computer hardware |
$1,000.00 |
$418.70 |
| Office supplies |
$1,000.00 |
$501.91 |
| Overtime |
$20,000.00 |
$9,476.05 |
| Parking costs |
$0.00 |
$48.50 |
| Personnel savings |
($197,503.00) |
$0.00 |
| Phone allowance |
$4,950.00 |
$3,964.84 |
| Printing/binding/photo/repr |
$100.00 |
$0.00 |
| Professional registration |
$500.00 |
$579.50 |
| Regular wages - full-time |
$2,291,122.00 |
$1,606,681.03 |
| Reimbursement of CIP charge |
($34,658.00) |
($97,081.05) |
| Safety equipment |
$772.00 |
$584.99 |
| Seasonal employees |
$0.00 |
$5,760.00 |
| Seminar/training fees |
$0.00 |
$2,838.94 |
| Services-IT staffing |
$250,000.00 |
$156,920.27 |
| Services-other |
$1,000.00 |
$0.00 |
| Services-survey |
$1,500.00 |
$0.00 |
| Sick pay |
$0.00 |
$5,090.58 |
| Small tools/minor equipment |
$200.00 |
$0.00 |
| Software |
$15,000.00 |
$15,309.50 |
| Stability pay |
$17,900.00 |
$700.00 |
| Subscriptions |
$400.00 |
$95.00 |
| Temporary employees |
$21,840.00 |
$26,933.65 |
| Terminal pay |
$5,000.00 |
$0.00 |
| Vacation pay |
$0.00 |
$7,640.20 |
| |
$3,046,573.00 |
$2,218,580.80
|
|
| Water Conservation |
| Administrative leave |
$0.00 |
$23,343.10 |
| Advertising/publication |
$3,000.00 |
$0.00 |
| Allowances/other pay |
$5,000.00 |
$1,350.00 |
| Awards and Recognition |
$1,380.00 |
$1,059.77 |
| Bilingual Pay |
$5,400.00 |
$5,193.00 |
| Books-library |
$563.00 |
$115.31 |
| Clothing/clothing material |
$1,392.00 |
$817.76 |
| Commercial Incentives-AWU |
$3,875,000.00 |
$248,176.62 |
| Comp time used |
$0.00 |
$202.75 |
| Contribution to employees ret |
$203,786.00 |
$190,317.66 |
| Educational travel |
$0.00 |
$8,411.11 |
| Educational/promotional |
$12,410.00 |
$5,678.51 |
| Emergency leave |
$0.00 |
$1,940.32 |
| Exception vacation |
$0.00 |
$2,789.67 |
| Expense refunds |
($350,000.00) |
($350,000.00) |
| FICA tax |
$139,583.00 |
$130,214.12 |
| Fleet-equip.preventative maint |
$26,872.00 |
$22,309.32 |
| Food/Ice |
$327.00 |
$445.63 |
| Grants to subrecipients |
$15,000.00 |
$15,000.00 |
| Help Program-AWU |
$350,000.00 |
$326,729.49 |
| Holiday pay |
$0.00 |
$88,007.16 |
| Holidays worked |
$0.00 |
$4,693.21 |
| Household Efficiency-AWU |
$71,410.00 |
$8,356.90 |
| Insurance-health/life/dental |
$377,108.00 |
$320,890.18 |
| Insurance-temporary employees |
$0.00 |
$15,668.45 |
| Irrigation Efficiency-AWU |
$22,660.00 |
$3,997.98 |
| Jury leave |
$0.00 |
$81.10 |
| Landscape Conversion Rebate-AWU |
$80,000.00 |
$66,259.68 |
| Medicare tax |
$32,640.00 |
$30,453.31 |
| Office supplies |
$5,464.00 |
$3,927.82 |
| Overtime |
$21,000.00 |
$27,923.66 |
| Parental Leave |
$0.00 |
($234.56) |
| Parking costs |
$0.00 |
$257.45 |
| Personal holiday pay |
$0.00 |
$28,048.99 |
| Personnel savings |
($189,201.00) |
$0.00 |
| Phone allowance |
$4,020.00 |
$3,174.25 |
| Pressure Reduction Valve Rebate-AWU |
$10,713.00 |
$1,200.00 |
| Printing/binding/photo/repr |
$5,000.00 |
$0.00 |
| Professional registration |
$4,500.00 |
$1,636.00 |
| Rainwater Harvesting Rebate-AWU |
$69,826.00 |
$47,803.86 |
| Regular wages - full-time |
$2,122,805.00 |
$1,646,168.83 |
| Safety equipment |
$195.00 |
$1,068.41 |
| Seasonal employees |
$0.00 |
$12,028.88 |
| Seminar/training fees |
$0.00 |
$5,483.80 |
| Services-Prepared Food and Catering |
$5,000.00 |
$6,395.86 |
| Services-other |
$45,000.00 |
$19,428.83 |
| Shift differential |
$0.00 |
$703.10 |
| Sick pay |
$0.00 |
$75,166.70 |
| Small tools/minor equipment |
$17,000.00 |
$0.00 |
| Software |
$2,000.00 |
$0.00 |
| Stability pay |
$17,900.00 |
$19,902.08 |
| Subscriptions |
$463.00 |
$151.00 |
| Temporary employees |
$101,166.00 |
$103,849.56 |
| Terminal pay |
$0.00 |
$653.21 |
| Toll Road - Tx Tag |
$0.00 |
$18.21 |
| Transportation-city veh fuel |
$2,525.00 |
$2,391.63 |
| Vacation pay |
$0.00 |
$121,745.15 |
| Water Services Interlocal |
$900,000.00 |
$778,060.25 |
| |
$8,018,907.00 |
$4,079,455.08
|
|
| Wildland Conservation |
| Accident pay |
$0.00 |
$307.67 |
| Administrative leave |
$0.00 |
$17,770.49 |
| Advertising/publication |
$4,000.00 |
$0.00 |
| Agricultural/horticultural |
$73,500.00 |
$74,728.81 |
| Allowances/other pay |
$8,500.00 |
$2,400.00 |
| Asphalt |
$500.00 |
$0.00 |
| Awards and Recognition |
$1,740.00 |
$145.75 |
| Bilingual Pay |
$1,800.00 |
$1,731.00 |
| Books-library |
$750.00 |
$0.00 |
| Building material |
$4,000.00 |
$968.26 |
| Building/Remodel |
$10,500.00 |
$9,861.00 |
| Cement/concrete |
$1,000.00 |
$0.00 |
| Chemicals |
$2,000.00 |
$460.05 |
| Clothing/clothing material |
$10,000.00 |
$370.88 |
| Computer supplies |
$200.00 |
$0.00 |
| Const/repair material-other |
$7,500.00 |
$1,203.69 |
| Consultant-others |
$35,000.00 |
$8,625.00 |
| Contribution to employees ret |
$255,275.00 |
$226,989.10 |
| Drainage fee expense |
$8,500.00 |
$9,062.15 |
| Educational travel |
$0.00 |
$9,542.10 |
| Educational/promotional |
$16,000.00 |
$6,415.03 |
| Electric services |
$28,000.00 |
$21,696.54 |
| Electrical/lighting |
$1,000.00 |
$421.94 |
| Emergency leave |
$0.00 |
$4,841.25 |
| Expense refunds |
($75,000.00) |
($62,714.52) |
| FICA tax |
$187,262.00 |
$166,028.00 |
| Fleet-equip.preventative maint |
$157,888.00 |
$166,197.10 |
| Food/Ice |
$2,200.00 |
$1,198.50 |
| Food/storage for animals |
$2,000.00 |
$0.00 |
| Freight |
$0.00 |
$58.50 |
| Gasoline/oil/grease |
$0.00 |
$876.35 |
| Hardware/wire/steel |
$2,500.00 |
$3,095.57 |
| Holiday pay |
$0.00 |
$117,894.48 |
| Holidays worked |
$0.00 |
$205.52 |
| Household/cleaning supplies |
$1,000.00 |
$1,556.77 |
| Improvements to Grounds |
$63,000.00 |
$39,190.23 |
| Insurance-health/life/dental |
$475,484.00 |
$382,786.34 |
| Insurance-temporary employees |
$0.00 |
$47,900.69 |
| Interdepartmental reimbursements |
($21,000.00) |
$0.00 |
| Interest on invoices |
$0.00 |
$24.34 |
| Interpeptl-PW QMD charges |
$5,400.00 |
$81.29 |
| Jury leave |
$0.00 |
$1,737.17 |
| Maintenance-buildings |
$20,000.00 |
$1,611.62 |
| Maintenance-grounds |
$80,000.00 |
$4,836.47 |
| Maintenance-other equipment |
$500.00 |
$976.99 |
| Medical/dental supplies |
$300.00 |
$86.84 |
| Medicare tax |
$43,795.00 |
$38,829.11 |
| Memberships |
$1,000.00 |
$0.00 |
| Minor computer hardware |
$1,000.00 |
$69.95 |
| Office supplies |
$3,000.00 |
$1,273.62 |
| Other paid leave |
$0.00 |
$8,941.86 |
| Overtime |
$19,000.00 |
$9,515.66 |
| Paint/painting supplies |
$100.00 |
$794.85 |
| Parental Leave |
$0.00 |
$41,640.35 |
| Parts for equipment |
$2,000.00 |
$759.82 |
| Parts for vehicles |
$2,000.00 |
$882.00 |
| Personal holiday pay |
$0.00 |
$26,397.10 |
| Personnel savings |
($221,438.00) |
$0.00 |
| Phone allowance |
$16,980.00 |
$21,676.57 |
| Photographic |
$1,000.00 |
$0.00 |
| Pipes and fittings |
$1,000.00 |
$3,426.40 |
| Police supplies |
$500.00 |
$0.00 |
| Postage |
$1,000.00 |
$723.27 |
| Printing/binding/photo/repr |
$2,500.00 |
$753.24 |
| Professional registration |
$1,000.00 |
$528.11 |
| Regular wages - full-time |
$2,659,108.00 |
$1,918,967.25 |
| Rental-heavy equipment |
$3,000.00 |
$0.00 |
| Rental-other equipment |
$10,000.00 |
$7,016.67 |
| Rental-vehicles/buses |
$500.00 |
$50.00 |
| Safety equipment |
$4,500.00 |
$8,402.54 |
| Sand/gravel/stone |
$7,500.00 |
$3,400.36 |
| Security equipment |
$42,000.00 |
$626.45 |
| Seminar/training fees |
$0.00 |
$3,841.50 |
| Services-Prepared Food and Catering |
$6,500.00 |
$1,176.25 |
| Services-court costs |
$0.00 |
$354.55 |
| Services-legal fees |
$300.00 |
$0.00 |
| Services-other |
$2,190,800.00 |
$788,769.05 |
| Services-survey |
$10,000.00 |
$12,875.85 |
| Services-testing |
$15,000.00 |
$5.93 |
| Sick pay |
$0.00 |
$92,008.48 |
| Small tools/minor equipment |
$65,000.00 |
$24,233.80 |
| Software |
$500.00 |
$0.00 |
| Stability pay |
$21,500.00 |
$21,100.00 |
| Street/traff signs/mrkr/pos |
$3,000.00 |
$56.96 |
| Temporary employees |
$321,000.00 |
$302,081.25 |
| Terminal pay |
$0.00 |
$15,013.44 |
| Toll Road - Tx Tag |
$0.00 |
$595.62 |
| Training-city wide |
$0.00 |
$250.95 |
| Transportation-city veh fuel |
$15,868.00 |
$19,399.47 |
| Vacation pay |
$0.00 |
$152,982.02 |
| Valves |
$200.00 |
$1,866.65 |
| Water service |
$6,000.00 |
$2,638.56 |
| Welding supplies |
$1,000.00 |
$186.72 |
| |
$6,629,012.00 |
$4,805,281.19
|
|
|
| OPERATIONS |
| Environmental Engineering & Technical Services |
| Administrative leave |
$0.00 |
$34,843.22 |
| Allowances/other pay |
$10,800.00 |
$2,887.50 |
| Awards and Recognition |
$1,500.00 |
$1,041.91 |
| Bilingual Pay |
$0.00 |
$351.37 |
| Books-library |
$550.00 |
$247.27 |
| Chemicals |
$111,104.00 |
$104,966.74 |
| Clothing/clothing material |
$3,850.00 |
$2,862.19 |
| Contribution to employees ret |
$251,785.00 |
$228,365.48 |
| Educational incentive pay |
$7,500.00 |
$10,385.50 |
| Educational travel |
$0.00 |
($1,214.15) |
| Educational/promotional |
$100.00 |
$0.00 |
| Electric services |
$18,000.00 |
$16,579.98 |
| Emergency leave |
$0.00 |
$3,751.92 |
| Exception vacation |
$0.00 |
$1,288.49 |
| FICA tax |
$167,783.00 |
$152,691.65 |
| Fleet-equip.preventative maint |
$3,169.00 |
$14,872.88 |
| Food/Ice |
$200.00 |
$0.00 |
| Gas/heating fuels |
$2,000.00 |
$1,484.23 |
| Government permits and fees |
$776,100.00 |
$642,393.09 |
| Holiday pay |
$0.00 |
$101,074.41 |
| Holidays worked |
$3,000.00 |
$4,525.27 |
| Insurance-health/life/dental |
$418,098.00 |
$351,188.26 |
| Jury leave |
$0.00 |
$229.55 |
| Maintenance-buildings |
$1,500.00 |
$315.00 |
| Maintenance-computer hardware |
$250.00 |
$0.00 |
| Maintenance-computer software |
$36,198.00 |
$49,518.00 |
| Maintenance-other equipment |
$44,500.00 |
$29,553.08 |
| Medicare tax |
$39,432.00 |
$35,718.10 |
| Memberships |
$4,450.00 |
$1,423.00 |
| Mileage reimbursements |
$1,950.00 |
$817.90 |
| Office supplies |
$5,100.00 |
$2,829.28 |
| Overtime |
$45,000.00 |
$42,438.09 |
| Parental Leave |
$0.00 |
$65,882.36 |
| Parking costs |
$0.00 |
$31.06 |
| Personal holiday pay |
$0.00 |
$27,601.06 |
| Personnel savings |
($222,599.00) |
$0.00 |
| Phone allowance |
$18,800.00 |
$17,411.26 |
| Printing/binding/photo/repr |
$600.00 |
$421.47 |
| Priority mail/parcel services |
$5,180.00 |
$960.05 |
| Professional registration |
$1,300.00 |
$618.50 |
| Raw water - purchased |
$600,000.00 |
$458,028.00 |
| Regular wages - full-time |
$2,622,684.00 |
$1,933,266.26 |
| Rental-real estate-office |
$258,843.00 |
$222,130.39 |
| Rental-vehicles/buses |
$2,000.00 |
$0.00 |
| Safety equipment |
$5,075.00 |
$2,801.11 |
| Seasonal employees |
$0.00 |
$20,032.53 |
| Seminar/training fees |
$0.00 |
$115.00 |
| Services-hazardous mat disp |
$3,000.00 |
$2,017.61 |
| Services-other |
$7,800.00 |
$4,717.50 |
| Services-testing |
$47,000.00 |
$23,575.43 |
| Sick pay |
$0.00 |
$82,865.38 |
| Small tools/minor equipment |
$143,000.00 |
$47,027.24 |
| Software |
$14,143.00 |
$0.00 |
| Stability pay |
$15,500.00 |
$17,226.94 |
| Subscriptions |
$5,850.00 |
$161.60 |
| Temporary employees |
$63,176.00 |
$16,330.10 |
| Terminal pay |
$20,000.00 |
$10,049.19 |
| Toll Road - Tx Tag |
$0.00 |
$38.51 |
| Training-city wide |
$3,000.00 |
$0.00 |
| Transportation-city veh fuel |
$6,343.00 |
$7,639.85 |
| Vacation pay |
$0.00 |
$134,905.39 |
| Welding supplies |
$1,500.00 |
$478.27 |
| |
$5,576,114.00 |
$4,933,761.27
|
|
| Operations Support |
| Administrative leave |
$0.00 |
$1,716.23 |
| Allowances/other pay |
$0.00 |
$300.00 |
| Awards and Recognition |
$210.00 |
$0.00 |
| Books-library |
$563.00 |
$0.00 |
| Clothing/clothing material |
$1,024.00 |
$0.00 |
| Computer supplies |
$11.00 |
$0.00 |
| Contribution to employees ret |
$62,797.00 |
$42,513.36 |
| FICA tax |
$39,404.00 |
$24,790.10 |
| Food/Ice |
$327.00 |
$0.00 |
| Government permits and fees |
$1,206.00 |
$0.00 |
| Holiday pay |
$0.00 |
$14,158.03 |
| Insurance-health/life/dental |
$65,584.00 |
$36,777.77 |
| Maintenance-other equipment |
$5,911.00 |
$5,910.87 |
| Medicare tax |
$9,606.00 |
$6,378.01 |
| Memberships |
$220.00 |
$64.50 |
| Mileage reimbursements |
$485.00 |
$169.43 |
| Minor computer hardware |
$337.00 |
$0.00 |
| Office supplies |
$759.00 |
$117.15 |
| Overtime |
$0.00 |
$52.22 |
| Personal holiday pay |
$0.00 |
$2,059.46 |
| Personnel savings |
($55,454.00) |
$0.00 |
| Phone allowance |
$4,170.00 |
$2,900.08 |
| Postage |
$34.00 |
$157.36 |
| Printing/binding/photo/repr |
$54.00 |
$27.50 |
| Professional registration |
$285.00 |
$75.00 |
| Regular wages - full-time |
$654,133.00 |
$397,810.50 |
| Reimbursement of CIP charge |
($194.00) |
$0.00 |
| Rental-other equipment |
$3,142.00 |
$663.93 |
| Safety equipment |
$98.00 |
($138.80) |
| Services-other |
$17,990.00 |
$0.00 |
| Sick pay |
$0.00 |
$2,988.10 |
| Small tools/minor equipment |
$686.00 |
$0.00 |
| Software |
$817.00 |
$0.00 |
| Stability pay |
$4,050.00 |
$1,900.00 |
| Vacation pay |
$0.00 |
$26,629.63 |
| |
$818,255.00 |
$568,020.43
|
|
| Water Distribution Operations |
| Accident pay |
$0.00 |
$213,960.72 |
| Administrative leave |
$0.00 |
$173,164.79 |
| Agricultural/horticultural |
$1,890.00 |
$600.79 |
| Allowances/other pay |
$104,276.00 |
$68,368.41 |
| Asphalt |
$141,627.00 |
$121,454.22 |
| Awards and Recognition |
$9,750.00 |
$7,303.32 |
| Bilingual Pay |
$29,100.00 |
$25,767.10 |
| Books-library |
$520.00 |
$0.00 |
| Building material |
$15,043.00 |
$12,354.10 |
| Call back time |
$827,957.00 |
$1,308,512.65 |
| Cement/concrete |
$25,645.00 |
$8,860.37 |
| Chemicals |
$81,152.00 |
$66,449.76 |
| Clothing/clothing material |
$125,850.00 |
$120,633.93 |
| Comp time used |
$0.00 |
$1,266.60 |
| Computer supplies |
$7,016.00 |
$2,993.54 |
| Const/repair material-other |
$3,111.00 |
$1,685.99 |
| Consulting-information technology |
$256,869.00 |
$94,918.43 |
| Contribution to employees ret |
$1,329,075.00 |
$1,156,968.39 |
| Dept OH distribtd to indire |
($160,000.00) |
($379,042.74) |
| Dietary hardware |
$875.00 |
$1,871.40 |
| Drainage fee expense |
$57,000.00 |
$48,337.92 |
| Educational incentive pay |
$14,603.00 |
$70,186.59 |
| Educational travel |
$0.00 |
$541.95 |
| Educational/promotional |
$169.00 |
$0.00 |
| Elctrcal conductors-hardware |
$49,000.00 |
$13.55 |
| Elctrcal conductors-wire&cable |
$6,175.00 |
$349.25 |
| Electric services |
$2,855,050.00 |
$2,865,777.03 |
| Electrical/lighting |
$115,778.00 |
$107,935.93 |
| Emergency leave |
$0.00 |
$16,714.30 |
| Exception vacation |
$0.00 |
$1,527.16 |
| FICA tax |
$922,493.00 |
$1,052,709.57 |
| Fleet-equip.preventative maint |
$1,953,415.00 |
$1,529,921.33 |
| Food/Ice |
$35,944.00 |
$40,048.00 |
| Freight |
$2,978.00 |
$3,369.85 |
| Fuses and fusing apparatus |
$536.00 |
$202.08 |
| Garbage/refuse collection |
$10,072.00 |
$5,540.65 |
| Gas/heating fuels |
$7,000.00 |
$9,842.51 |
| Gasoline/oil/grease |
$32,347.00 |
$22,598.51 |
| Government permits and fees |
$374,560.00 |
$368,817.78 |
| Hardware/wire/steel |
$90,726.00 |
$45,804.82 |
| Holiday pay |
$0.00 |
$531,132.76 |
| Holidays worked |
$31,762.00 |
$51,420.65 |
| Household/cleaning supplies |
$23,212.00 |
$19,288.71 |
| Identification |
$0.00 |
$316.74 |
| Indirect costs-FMC 74-4 |
$0.00 |
$379,042.74 |
| Insurance-health/life/dental |
$3,003,256.00 |
$2,432,285.56 |
| Insurance-temporary employees |
$0.00 |
$22,383.50 |
| Interdepartmental Charges |
$15,362.00 |
$0.00 |
| Interdepartmental reimbursements |
($81,071.00) |
($159,453.51) |
| Intradeptl chgs-street cut rpr |
$7,700,000.00 |
$7,311,661.23 |
| Jury leave |
$0.00 |
$3,612.52 |
| Maintenance-buildings |
$6,153.00 |
$14,367.24 |
| Maintenance-computer hardware |
$19,000.00 |
$9,145.60 |
| Maintenance-electric motors |
$95,000.00 |
$0.00 |
| Maintenance-grounds |
$75,000.00 |
$6,419.32 |
| Maintenance-hydraulic equipmnt |
$4,000.00 |
$0.00 |
| Maintenance-other equipment |
$107,180.00 |
$11,625.33 |
| Maintenance-pipelines |
$130,000.00 |
$18,663.82 |
| Medical/dental supplies |
$12,952.00 |
$1,782.99 |
| Medicare tax |
$215,737.00 |
$247,036.10 |
| Memberships |
$3,011.00 |
$50.00 |
| Meters |
$90.00 |
$489.16 |
| Mileage reimbursements |
$900.00 |
$0.00 |
| Minor communications equipment |
$63,530.00 |
$14,200.02 |
| Minor computer hardware |
$21,426.00 |
$41,716.23 |
| Miscellaneous expense |
$3,536.00 |
$731.73 |
| Office furnishings |
$0.00 |
$3,613.94 |
| Office supplies |
$38,516.00 |
$33,646.71 |
| On call hours |
$227,051.00 |
$198,389.40 |
| Other Equipment |
$292,896.00 |
$53,591.20 |
| Other paid leave |
$0.00 |
$501,136.87 |
| Overtime |
$3,637,405.00 |
$3,702,290.82 |
| Paint/painting supplies |
$23,749.00 |
$28,342.96 |
| Parental Leave |
$0.00 |
$97,767.06 |
| Parts for equipment |
$97,083.00 |
$144,231.38 |
| Parts for vehicles |
$56,881.00 |
$12,696.99 |
| Personal holiday pay |
$0.00 |
$130,639.18 |
| Personnel savings |
($1,206,352.00) |
$0.00 |
| Phone allowance |
$24,213.00 |
$24,625.27 |
| Pipes and fittings |
$2,665,130.00 |
$2,773,448.83 |
| Postage |
$27.00 |
$0.00 |
| Printing/binding/photo/repr |
$2,478.00 |
$2,128.76 |
| Priority mail/parcel services |
$27.00 |
$111.00 |
| Professional registration |
$80,293.00 |
$31,297.98 |
| Pull boxes,svc boxes,manholes |
$113,605.00 |
$88,649.66 |
| Radio equipment |
$0.00 |
$6,012.99 |
| Regular wages - full-time |
$13,844,424.00 |
$8,701,436.11 |
| Reimbursement of CIP charge |
($619,202.00) |
($1,014,240.65) |
| Relays and relaying equipment |
$0.00 |
$345.52 |
| Rental-heavy equipment |
$1,000.00 |
$0.00 |
| Rental-other equipment |
$13,740.00 |
$13,972.54 |
| Rental-vehicles/buses |
$166.00 |
$0.00 |
| Safety equipment |
$377,357.00 |
$295,799.22 |
| Sand/gravel/stone |
$920,800.00 |
$615,245.99 |
| Seasonal employees |
$0.00 |
$87,552.99 |
| Security equipment |
$8,360.00 |
$18,831.52 |
| Seminar/training fees |
$0.00 |
$10,748.00 |
| Services-IT Installations |
$28,000.00 |
$23,783.66 |
| Services-Software as a Service |
$16,000.00 |
$15,453.07 |
| Services-construction contr |
$9,749.00 |
$0.00 |
| Services-hazardous mat disp |
$4,900.00 |
$0.00 |
| Services-inspection |
$3,000.00 |
$0.00 |
| Services-internet/cable |
$46,116.00 |
$3,703.60 |
| Services-other |
$2,818,882.00 |
$1,979,809.07 |
| Shift differential |
$19,741.00 |
$17,852.89 |
| Sick pay |
$0.00 |
$402,505.01 |
| Small electric motors-water ut |
$30,665.00 |
$13,417.72 |
| Small tools/minor equipment |
$732,912.00 |
$680,031.94 |
| Software |
$11,041.00 |
$3,808.95 |
| Stability pay |
$123,650.00 |
$156,730.40 |
| Street/traff signs/mrkr/pos |
$6,212.00 |
$160.00 |
| Telephone-base cost |
$64,408.00 |
$63,278.21 |
| Telephone-cellular phones |
$71,054.00 |
$14,234.20 |
| Temporary employees |
$858,947.00 |
$431,769.28 |
| Terminal pay |
$51,833.00 |
$31,204.68 |
| Toll Road - Tx Tag |
$0.00 |
$2,222.20 |
| Transportation-city veh fuel |
$539,701.00 |
$466,941.69 |
| Vacation pay |
$0.00 |
$709,008.65 |
| Valves |
$774,329.00 |
$656,283.87 |
| Welding supplies |
$13,295.00 |
$2,796.97 |
| Wireless Communication-instal |
$5,204.00 |
$569.00 |
| |
$47,606,924.00 |
$42,394,126.29
|
|
| Water Treatment Operations |
| Accident pay |
$0.00 |
$50,338.47 |
| Administrative leave |
$0.00 |
$113,905.57 |
| Allowances/other pay |
$51,630.00 |
$15,150.00 |
| Awards and Recognition |
$6,660.00 |
$4,956.48 |
| Building material |
$8,219.00 |
$1,327.95 |
| Call back time |
$40,800.00 |
$24,201.80 |
| Chemicals |
$16,377,807.41 |
$11,955,139.39 |
| Clothing/clothing material |
$65,600.00 |
$25,889.98 |
| Comp time used |
$0.00 |
$793.73 |
| Computer supplies |
$1,500.00 |
$0.00 |
| Const/repair material-other |
$0.00 |
$576.98 |
| Contribution to employees ret |
$818,871.00 |
$724,415.81 |
| Dietary hardware |
$139.00 |
$0.00 |
| Drainage fee expense |
$36,027.00 |
$46,303.96 |
| Educational incentive pay |
$64,920.00 |
$72,493.03 |
| Elctrcal conductors-wire&cable |
$2,500.00 |
$109.49 |
| Electric services |
$8,312,267.00 |
$8,137,440.86 |
| Electrical switchgear |
$536.00 |
$149.99 |
| Electrical/lighting |
$226,034.00 |
$145,361.97 |
| Emergency leave |
$0.00 |
$14,833.76 |
| Exception vacation |
$0.00 |
$6,409.47 |
| FICA tax |
$542,696.00 |
$547,620.86 |
| Fleet-equip.preventative maint |
$449,462.00 |
$444,766.55 |
| Food/Ice |
$6,427.00 |
$2,734.54 |
| Freight |
$15,500.00 |
$1,901.09 |
| Fuses and fusing apparatus |
$214.00 |
$55.94 |
| Garbage/refuse collection |
$1,042.00 |
$427.70 |
| Gasoline/oil/grease |
$215,646.59 |
$193,314.20 |
| Government permits and fees |
$800.00 |
$0.00 |
| Hardware/wire/steel |
$23,023.00 |
$13,875.71 |
| Holiday pay |
$0.00 |
$324,472.24 |
| Holidays worked |
$117,000.00 |
$118,473.42 |
| Household/cleaning supplies |
$12,203.00 |
$4,396.16 |
| Insurance-health/life/dental |
$1,836,352.00 |
$1,495,601.68 |
| Interpeptl-PW CSD charges |
$50,060.00 |
$32,517.44 |
| Jury leave |
$0.00 |
$449.12 |
| Maintenance-buildings |
$3,173.00 |
$0.00 |
| Maintenance-computer software |
$0.00 |
$1,251.66 |
| Maintenance-electric motors |
$19,381.00 |
$0.00 |
| Maintenance-grounds |
$2,573.00 |
$6,730.55 |
| Maintenance-other equipment |
$181,528.00 |
$82,019.70 |
| Medical/dental supplies |
$2,631.00 |
$448.18 |
| Medicare tax |
$126,911.00 |
$128,072.59 |
| Mileage reimbursements |
$1,186.00 |
$0.00 |
| Minor computer hardware |
$500.00 |
$7,070.12 |
| Office furnishings |
$0.00 |
$203.30 |
| Office supplies |
$12,578.00 |
$6,731.65 |
| On call hours |
$42,200.00 |
$35,685.00 |
| Other Equipment |
$305,401.43 |
($29,159.51) |
| Other paid leave |
$0.00 |
$779.18 |
| Overtime |
$1,168,000.00 |
$1,008,907.39 |
| Paint/painting supplies |
$6,051.00 |
$4,686.03 |
| Parental Leave |
$0.00 |
$11,465.69 |
| Parts for equipment |
$1,122,709.00 |
$749,387.14 |
| Personal holiday pay |
$0.00 |
$89,660.87 |
| Personnel savings |
($712,680.00) |
$0.00 |
| Phone allowance |
$21,600.00 |
$21,868.58 |
| Pipes and fittings |
$153,000.00 |
$100,561.69 |
| Priority mail/parcel services |
$500.00 |
$0.00 |
| Professional registration |
$13,216.00 |
$7,048.50 |
| Regular wages - full-time |
$8,530,004.00 |
$6,128,773.62 |
| Rental-other equipment |
$15,724.00 |
$5,430.93 |
| Safety equipment |
$230,500.00 |
$164,487.95 |
| Sand/gravel/stone |
$87,655.00 |
$46,378.45 |
| Seasonal employees |
$0.00 |
$83,294.00 |
| Security equipment |
$54,592.00 |
$34,036.77 |
| Services-IT Installations |
$4,800.00 |
$4,793.31 |
| Services-construction contr |
$0.00 |
$15,666.47 |
| Services-environmnt assessment |
$16,490.00 |
$10,821.75 |
| Services-hazardous mat disp |
$2,177.00 |
$294.61 |
| Services-inspection |
$370.00 |
$370.00 |
| Services-other |
$1,640,739.57 |
$1,052,637.35 |
| Shift differential |
$54,500.00 |
$52,157.93 |
| Sick pay |
$0.00 |
$286,381.88 |
| Small electric motors-water ut |
$4,107.00 |
$0.00 |
| Small tools/minor equipment |
$293,740.00 |
$322,971.76 |
| Software |
$0.00 |
$141.67 |
| Stability pay |
$53,300.00 |
$88,186.55 |
| Temporary employees |
$148,211.00 |
$90,347.51 |
| Terminal pay |
$997.00 |
$11,531.91 |
| Toll Road - Tx Tag |
$0.00 |
$363.15 |
| Transportation-city veh fuel |
$199,864.00 |
$179,544.28 |
| Vacation pay |
$0.00 |
$432,918.79 |
| Valves |
$194,940.00 |
$118,663.68 |
| Water service |
$57,086.00 |
$22,764.63 |
| Welding supplies |
$8,548.00 |
$2,343.28 |
| |
$43,352,739.00 |
$35,909,125.88
|
|
|
| OTHER UTILITY PROGRAM REQUIREMENTS |
| Other Utility Program Requirements |
| Arbitrage rebate-admin exp |
$12,565.00 |
$9,645.57 |
| Bad Debt Expense |
$708,938.00 |
$859,034.30 |
| Bond issue costs |
$78,429.00 |
$41,667.96 |
| Bond/Theft/Prof Liab Insurance |
$6,000.00 |
$5,090.76 |
| Claims accrual - FSD only |
$0.00 |
$300,057.00 |
| Claims-auto liability |
$70,000.00 |
$124,801.62 |
| Claims-general liability |
$50,000.00 |
$33,244.47 |
| Commercial paper admin exp |
$1,262,632.00 |
$905,842.64 |
| Compensation Adjustment |
$188,388.00 |
$0.00 |
| Consultant-financial |
$125,000.00 |
$12,760.00 |
| Educational/promotional |
$479,263.00 |
$0.00 |
| FICA tax |
$403.00 |
$0.00 |
| Facilities Management Support |
$262,936.00 |
$241,024.67 |
| Federal unemployment tax co |
$26,000.00 |
$9,546.73 |
| Fire/Extend Coverage Insurance |
$2,598,967.00 |
$1,999,939.59 |
| Fleet-equip. vehicle/equipment modification |
$30,000.00 |
$0.00 |
| Food/Ice |
$0.00 |
$547.20 |
| Garbage/refuse collection |
$52,000.00 |
$53,737.11 |
| General Liability Insurance |
$3,000.00 |
$0.00 |
| Government permits and fees |
$20,000.00 |
$755.22 |
| Grants to subrecipients |
$0.00 |
$14,329.23 |
| Interdepartmental Charges |
$606,700.00 |
$0.00 |
| Legal claims/damages |
$150,000.00 |
$635,500.00 |
| Market Study Adjustment |
$32,816.00 |
$0.00 |
| Medical/dental supplies |
$0.00 |
$43,296.20 |
| Medicare tax |
$94.00 |
$0.00 |
| Other Equipment |
$68,938.00 |
$0.00 |
| Raw water - purchased |
$5,000.00 |
$336.91 |
| Rental-real estate-office |
$1,158.00 |
$0.00 |
| Safety equipment |
$28,019.00 |
$0.00 |
| Services-Credit Card Fees |
$60,000.00 |
$51,534.09 |
| Services-Software as a Service |
$11,250.00 |
$0.00 |
| Services-appraisal |
$0.00 |
$2,125.00 |
| Services-court costs |
$0.00 |
$16,250.80 |
| Services-legal fees |
$175,000.00 |
$33,942.50 |
| Services-other |
$840,159.00 |
$398,299.00 |
| Shift differential |
$190,605.00 |
$0.00 |
| Software |
$61,500.00 |
$81,400.00 |
| Temporary employees |
$6,498.00 |
$0.00 |
| Util rev bnd commission exp |
$6,504.00 |
$3,410.00 |
| Wireless Communications-maint |
$15,372.00 |
$0.00 |
| |
$8,234,134.00 |
$5,878,118.57
|
|
|
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$40,440.13 |
| Allowances/other pay |
$20,584.00 |
$6,632.27 |
| Awards and Recognition |
$31,290.00 |
$12,020.84 |
| Bilingual Pay |
$5,400.00 |
$1,334.16 |
| Boiler equipment |
$500.00 |
$0.00 |
| Books-library |
$3,072.00 |
$1,371.86 |
| Building material |
$17,740.00 |
$4,052.67 |
| Call back time |
$3,674.00 |
$5,551.10 |
| Chemicals |
$3,180.00 |
$10,243.67 |
| Clothing allowances |
$0.00 |
$1,396.84 |
| Clothing/clothing material |
$27,858.00 |
$14,630.87 |
| Communications Equipment |
$0.00 |
$6,166.46 |
| Const/repair material-other |
$4,000.00 |
$3,455.48 |
| Consulting-information technology |
$103,155.00 |
$70,380.72 |
| Contribution to employees ret |
$1,496,597.00 |
$1,060,804.64 |
| Drainage fee expense |
$82,395.00 |
$151,664.06 |
| Educational incentive pay |
$3,700.00 |
$12,704.70 |
| Educational travel |
$180,614.00 |
$187,753.82 |
| Educational/promotional |
$53,243.00 |
$42,977.98 |
| Elctrcal conductors-hardware |
$1,700.00 |
$208.78 |
| Electric services |
$185,000.00 |
$606,647.98 |
| Electrical/lighting |
$137,834.00 |
$150,725.59 |
| Emergency leave |
$0.00 |
$6,371.06 |
| Employee recruiting |
$14,318.00 |
$11,961.95 |
| Expense refunds |
($450,000.00) |
($751,898.02) |
| FICA tax |
$1,000,465.00 |
$699,288.17 |
| Fleet-equip.preventative maint |
$105,067.00 |
$168,003.63 |
| Food/Ice |
$48,476.00 |
$35,084.24 |
| Freight |
$162.00 |
$2,959.96 |
| Garbage/refuse collection |
$4,416.00 |
$4,175.78 |
| Gas/heating fuels |
$19,371.00 |
$16,753.98 |
| Gasoline/oil/grease |
$1,000.00 |
$918.29 |
| Government permits and fees |
$500.00 |
$266.11 |
| Hardware/wire/steel |
$13,350.00 |
$5,779.93 |
| Holiday pay |
$0.00 |
$127,644.54 |
| Holidays worked |
$367.00 |
$12,331.22 |
| Household/cleaning supplies |
$12,129.00 |
$10,712.65 |
| Insurance-health/life/dental |
$2,549,578.00 |
$1,661,858.31 |
| Insurance-temporary employees |
$0.00 |
$31,257.08 |
| Interdepartmental Charges |
$1,784.00 |
$0.00 |
| Jury leave |
$0.00 |
$302.77 |
| Maintenance-boilers |
$3,000.00 |
$0.00 |
| Maintenance-buildings |
$650,750.00 |
$524,328.13 |
| Maintenance-chillers |
$1,000.00 |
$0.00 |
| Maintenance-computer hardware |
$246,480.00 |
$71,162.16 |
| Maintenance-computer software |
$1,123,772.00 |
$632,654.42 |
| Maintenance-electric motors |
$250.00 |
$804.31 |
| Maintenance-grounds |
$200,000.00 |
$232,206.19 |
| Maintenance-other equipment |
$3,250.00 |
$3,152.02 |
| Medical/dental supplies |
$21,141.00 |
$22,786.65 |
| Medicare tax |
$236,030.00 |
$165,336.80 |
| Memberships |
$162,223.00 |
$168,916.42 |
| Mileage reimbursements |
$6,842.00 |
$3,234.01 |
| Minor communications equipment |
$0.00 |
$2,271.46 |
| Minor computer hardware |
$317,054.00 |
$276,670.59 |
| Office furnishings |
$87,500.00 |
$2,641.44 |
| Office supplies |
$25,042.00 |
$18,020.08 |
| On call hours |
$19,894.00 |
$14,261.50 |
| Other Equipment |
$0.00 |
$40,860.41 |
| Other paid leave |
$0.00 |
$368.98 |
| Overtime |
$84,537.00 |
$157,007.64 |
| Paint/painting supplies |
$8,100.00 |
$1,254.50 |
| Parental Leave |
$0.00 |
$7,306.80 |
| Parking costs |
$300.00 |
$0.00 |
| Parts for equipment |
$16,538.00 |
$41,255.00 |
| Personal holiday pay |
$0.00 |
$36,970.70 |
| Personnel savings |
($1,350,608.00) |
$0.00 |
| Phone allowance |
$68,619.00 |
$64,010.36 |
| Pipes and fittings |
$11,045.00 |
$5,842.40 |
| Postage |
$0.00 |
$42.19 |
| Printing/binding/photo/repr |
$825.00 |
$162.23 |
| Priority mail/parcel services |
$47,500.00 |
$29,018.00 |
| Professional registration |
$13,558.00 |
$5,346.11 |
| Radio equipment |
$137,500.00 |
$15,599.49 |
| Refrigerant components-HVAC |
$20,000.00 |
$35,759.46 |
| Regular wages - full-time |
$15,589,520.00 |
$10,494,143.66 |
| Regular wages - part-time |
$0.00 |
$5,026.95 |
| Reimbursement of CIP charge |
($9,268.00) |
$0.00 |
| Rental-copy machines |
$182,100.00 |
$105,504.77 |
| Rental-other equipment |
$29,666.00 |
$25,897.16 |
| Rental-real estate-other |
$93,900.00 |
$90,176.94 |
| Rental-vehicles/buses |
$500.00 |
$734.26 |
| Safety equipment |
$260,917.00 |
$81,444.81 |
| Seasonal employees |
$0.00 |
$32,578.89 |
| Security equipment |
$3,150.00 |
$23,377.55 |
| Seminar/training fees |
$225,858.00 |
$128,898.79 |
| Services - Contractual Electrical |
$38,329.00 |
$2,895.87 |
| Services - Contractual General Trades |
$2,984.00 |
$0.00 |
| Services - Contracutal HVAC |
$500,000.00 |
$425,448.27 |
| Services - Fire Alarms |
$85,000.00 |
$69,403.23 |
| Services-IT |
$74,141.00 |
$0.00 |
| Services-IT Installations |
$3,000.00 |
$2,199.42 |
| Services-IT staffing |
$372,600.00 |
$303,550.00 |
| Services-Platform as a Service |
$390,474.00 |
$108,762.83 |
| Services-Software as a Service |
$736,307.00 |
$1,044,316.23 |
| Services-hazardous mat disp |
$807.00 |
$0.00 |
| Services-inspection |
$152.00 |
$1,295.38 |
| Services-internet/cable |
$46,795.00 |
$29,270.13 |
| Services-janitorial |
$640,000.00 |
$503,628.82 |
| Services-medical/surgical |
$37,500.00 |
$23,051.25 |
| Services-other |
$1,059,265.00 |
$1,000,978.67 |
| Services-pest control |
$25,000.00 |
$16,026.31 |
| Services-security |
$1,142,550.00 |
$956,168.01 |
| Services-testing |
$8,000.00 |
$617.76 |
| Services-vacant lot clearing |
$2,700.00 |
$0.00 |
| Shift differential |
$3,400.00 |
$5,265.27 |
| Sick pay |
$0.00 |
$95,183.89 |
| Small electric motors-water ut |
$1,000.00 |
$0.00 |
| Small tools/minor equipment |
$78,465.00 |
$134,102.62 |
| Software |
$22,909.00 |
$30,978.07 |
| Stability pay |
$192,700.00 |
$11,300.00 |
| Street/traff signs/mrkr/pos |
$965.00 |
$699.39 |
| Subscriptions |
$4,304.00 |
$1,615.00 |
| Telephone-base cost |
$136,475.00 |
$42,328.48 |
| Telephone-cellular phones |
$267,800.00 |
$107,865.10 |
| Temporary employees |
$529,062.00 |
$337,334.20 |
| Terminal pay |
$5,498.00 |
$11,374.89 |
| Toll Road - Tx Tag |
$8,166.00 |
$1,484.87 |
| Training-city wide |
$6,056.00 |
$0.00 |
| Transportation-city veh fuel |
$26,095.00 |
$40,367.35 |
| Vacation pay |
$0.00 |
$209,983.59 |
| Valves |
$3,129.00 |
$36,727.32 |
| Welding supplies |
$530.00 |
$0.00 |
| |
$30,673,162.00 |
$23,556,192.72
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Debt Transfers |
| Commercial paper interest |
$2,477,641.00 |
$1,596,433.47 |
| Interest payment D/S funds |
$0.00 |
$4,555.88 |
| Principal payment D/S funds |
$0.00 |
$214,394.50 |
| Tfr to Util D/S Tax/Rev Bonds |
$223,506.00 |
$4,555.89 |
| Tfr to Utility D/S Sub Lien |
$0.00 |
$105.03 |
| Trf to GO Debt Service |
$244,621.00 |
$228,196.00 |
| Trf to Util D/S Separate Lien |
$94,313,096.00 |
$76,678,401.52 |
| |
$97,258,864.00 |
$78,726,642.29
|
|
| Interfund Transfers |
| Administrative Support |
$10,696,148.00 |
$9,804,802.37 |
| CTECC Support |
$15,850.00 |
$15,850.00 |
| CTM Support |
$3,398,182.00 |
$3,115,000.13 |
| Regional Radio System |
$419,466.00 |
$384,510.50 |
| TRF CRF to Debt Defeasance |
$20,000,000.00 |
$20,006,546.49 |
| TRF Operating to Debt Defeasance |
$12,733,211.00 |
$12,731,322.91 |
| Trf to CIP Mgm - CPM |
$1,915,630.00 |
$1,755,994.13 |
| Trf to Economic Development |
$2,251,619.00 |
$2,063,984.12 |
| Trf to General Fund |
$27,955,557.00 |
$25,635,093.88 |
| Trf to Reclaimed Water Fund |
$6,500,000.00 |
$5,958,333.37 |
| Trf to Water CIP Fund |
$37,520,000.00 |
$33,664,540.00 |
| Trf to Water Revenue Stab Rsv |
$2,464,552.00 |
$2,030,210.47 |
| Workers' Compensation |
$755,128.00 |
$692,200.63 |
| |
$126,625,343.00 |
$117,858,389.00
|
|
| Other Requirements |
| Accrued Payroll |
$354,544.00 |
$354,544.00 |
| Contribution to employees ret |
$6,602,620.00 |
$5,929,017.28 |
| Interdepartmental Charges |
$219,850.00 |
$201,529.13 |
| Trf to PID Fund |
$37,500.00 |
$37,500.00 |
| Utility Billing System Support |
$13,597,011.00 |
$12,463,926.75 |
| |
$20,811,525.00 |
$18,986,517.16
|
|
|
|
| AUSTIN WATER WILDLAND CONSERVATION FUND |
BUDGET |
EXPENDITURES |
| ENVIRONMENTAL, PLANNING, AND DEVELOPMENT SERVICES |
| Wildland Conservation |
| Services-other |
$245,000.00 |
$113,215.53 |
| Services-testing |
$40,000.00 |
$3,937.00 |
| |
$285,000.00 |
$117,152.53
|
|
|
|
| WATER INVENTORY FUND |
BUDGET |
EXPENDITURES |
| MISCELLANEOUS |
| Miscellaneous |
| Inventory purchases |
$0.00 |
($218,170.14) |
| |
$0.00 |
($218,170.14)
|
|
|
|
| TOTALS |
$895,344,702.00 |
$773,917,312.01 |
|