| AUSTIN WATER COMMUNITY BENEFIT CHARGE FUND |
BUDGET |
EXPENDITURES |
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Interfund Transfers |
| Trf to Reclaimed Water Fund |
$6,500,823.00 |
$4,625,205.75 |
| Trf to Wastewater Operating Fund |
$3,104,911.00 |
$3,564,054.95 |
| Trf to Water Operating Fund |
$8,025,917.00 |
$4,096,486.44 |
| |
$17,631,651.00 |
$12,285,747.14
|
|
| Other Requirements |
| Customer Assistance Prog Costs |
$925,000.00 |
$306,582.25 |
| Multifamily Cust Asst Prog Costs |
$7,857,468.00 |
$4,651,540.00 |
| |
$8,782,468.00 |
$4,958,122.25
|
|
|
|
| AUSTIN WATER RECLAIMED WATER UTILITY OPERATING FUND |
BUDGET |
EXPENDITURES |
| OTHER UTILITY PROGRAM REQUIREMENTS |
| Other Utility Program Requirements |
| Arbitrage rebate-admin exp |
$451.00 |
$1,123.78 |
| Commercial paper admin exp |
$24,160.00 |
$24,917.51 |
| Util rev bnd commission exp |
$40.00 |
$0.00 |
| |
$24,651.00 |
$26,041.29
|
|
|
| RECLAIMED WATER SERVICES |
| Reclaimed Water Services Support |
| Administrative leave |
$0.00 |
$5,506.70 |
| Allowances/other pay |
$0.00 |
$1,125.00 |
| Books-library |
$250.00 |
$0.00 |
| Building material |
$8,308.00 |
$15,843.23 |
| Chemicals |
$3,200.00 |
$339.00 |
| Clothing/clothing material |
$90.00 |
$0.00 |
| Computer supplies |
$100.00 |
$0.00 |
| Contribution to employees ret |
$48,076.00 |
$37,016.87 |
| Drainage fee expense |
$2,516.00 |
$1,253.20 |
| Educational/promotional |
$1,500.00 |
$0.00 |
| Electric services |
$36,001.00 |
$24,651.81 |
| Electrical/lighting |
$2,040.00 |
$2,768.25 |
| FICA tax |
$34,682.00 |
$26,459.95 |
| Food/Ice |
$800.00 |
$0.00 |
| Fuses and fusing apparatus |
$0.00 |
$663.80 |
| Hardware/wire/steel |
$2,000.00 |
$57.03 |
| Holiday pay |
$0.00 |
$20,514.24 |
| Insurance-health/life/dental |
$81,980.00 |
$56,755.80 |
| Maintenance-grounds |
$3,500.00 |
$0.00 |
| Medicare tax |
$8,111.00 |
$6,188.20 |
| Memberships |
$800.00 |
$0.00 |
| Meters |
$25.00 |
$0.00 |
| Mileage reimbursements |
$100.00 |
$24.12 |
| Minor computer hardware |
$2,100.00 |
$0.00 |
| Miscellaneous expense |
$90.00 |
$0.00 |
| Office furnishings |
$900.00 |
$0.00 |
| Office supplies |
$500.00 |
$10.99 |
| Paint/painting supplies |
$510.00 |
$0.00 |
| Parental Leave |
$0.00 |
$18,237.44 |
| Parts for equipment |
$8,604.00 |
$7,450.29 |
| Personal holiday pay |
$0.00 |
$4,003.68 |
| Phone allowance |
$2,820.00 |
$2,061.50 |
| Pipes and fittings |
$2,100.00 |
$6,381.20 |
| Printing/binding/photo/repr |
$50.00 |
$0.00 |
| Priority mail/parcel services |
$20.00 |
$0.00 |
| Professional registration |
$120.00 |
$0.00 |
| Regular wages - full-time |
$553,866.00 |
$361,456.70 |
| Reimbursement of CIP charge |
($56,841.00) |
($83,165.68) |
| Safety equipment |
$1,120.00 |
$10,082.71 |
| Sand/gravel/stone |
$0.00 |
$1,620.00 |
| Seminar/training fees |
$0.00 |
$500.00 |
| Services-other |
$32,926.00 |
$0.00 |
| Sick pay |
$0.00 |
$6,854.08 |
| Small tools/minor equipment |
$3,000.00 |
$5,527.60 |
| Software |
$5,700.00 |
$4,200.00 |
| Stability pay |
$2,700.00 |
$2,700.00 |
| Street/traff signs/mrkr/pos |
$100.00 |
$0.00 |
| Telephone-base cost |
$1,400.00 |
$0.00 |
| Telephone-cellular phones |
$1,400.00 |
$0.00 |
| Vacation pay |
$0.00 |
$16,505.56 |
| Valves |
$5,900.00 |
$118.70 |
| Welding supplies |
$500.00 |
$0.00 |
| |
$803,664.00 |
$563,711.97
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Debt Transfers |
| Commercial paper interest |
$548,001.00 |
$65,127.52 |
| Trf to Util D/S Separate Lien |
$6,807,708.00 |
$3,967,048.85 |
| |
$7,355,709.00 |
$4,032,176.37
|
|
| Interfund Transfers |
| Administrative Support |
$73,191.00 |
$48,794.00 |
| CTM Support |
$4,957.00 |
$4,957.00 |
| TRF Operating to Debt Defeasance |
$4,000,000.00 |
$3,993,285.08 |
| Trf to CIP Mgm - CPM |
$239,586.00 |
$239,586.00 |
| Trf to Economic Development |
$57,870.00 |
$57,870.00 |
| Trf to General Fund |
$268,034.00 |
$178,689.36 |
| Trf to Reclaimed Water CIP Fnd |
$8,000,823.00 |
$4,846,720.00 |
| |
$12,644,461.00 |
$9,369,901.44
|
|
| Other Requirements |
| Accrued Payroll |
$2,753.00 |
$0.00 |
| Contribution to employees ret |
$54,690.00 |
$35,758.82 |
| |
$57,443.00 |
$35,758.82
|
|
|
|
| AUSTIN WATER WASTEWATER UTILITY OPERATING FUND |
BUDGET |
EXPENDITURES |
| CUSTOMER EXPERIENCE |
| Customer Insights & Solutions |
| Administrative leave |
$0.00 |
$1,718.02 |
| Awards and Recognition |
$91.00 |
$0.00 |
| Bilingual Pay |
$900.00 |
$765.16 |
| Contribution to employees ret |
$21,165.00 |
$19,726.73 |
| Educational travel |
$0.00 |
$1,101.45 |
| Exception vacation |
$0.00 |
$286.64 |
| FICA tax |
$14,610.00 |
$12,840.57 |
| Food/Ice |
$600.00 |
$193.47 |
| Holiday pay |
$0.00 |
$13,539.80 |
| Holidays worked |
$0.00 |
$286.64 |
| Insurance-health/life/dental |
$32,792.00 |
$31,522.20 |
| Medicare tax |
$3,580.00 |
$3,118.03 |
| Mileage reimbursements |
$0.00 |
$285.96 |
| Office supplies |
$0.00 |
$397.67 |
| Overtime |
$0.00 |
$429.96 |
| Personal holiday pay |
$0.00 |
$1,659.60 |
| Personnel savings |
($25,014.00) |
$0.00 |
| Phone allowance |
$570.00 |
$550.50 |
| Regular wages - full-time |
$243,828.00 |
$191,333.21 |
| Sick pay |
$0.00 |
$6,443.56 |
| Stability pay |
$1,500.00 |
$2,000.00 |
| Subscriptions |
$22,750.00 |
$24,272.47 |
| Vacation pay |
$0.00 |
$14,866.56 |
| |
$317,372.00 |
$327,338.20
|
|
| Customer Services |
| Administrative leave |
$0.00 |
$8,151.81 |
| Allowances/other pay |
$0.00 |
$233.50 |
| Awards and Recognition |
$1,275.00 |
$1,017.45 |
| Bilingual Pay |
$6,606.00 |
$5,270.18 |
| Clothing/clothing material |
$3,050.00 |
$2,321.66 |
| Contribution to employees ret |
$182,875.00 |
$127,373.88 |
| Educational travel |
$0.00 |
$518.43 |
| Educational/promotional |
$800.00 |
$0.00 |
| Emergency leave |
$0.00 |
$2,252.40 |
| FICA tax |
$144,302.00 |
$101,961.27 |
| Food/Ice |
$850.00 |
$1,786.48 |
| Holiday pay |
$0.00 |
$57,886.71 |
| Holidays worked |
$4,877.00 |
$6,683.96 |
| Household/cleaning supplies |
$50.00 |
$28.74 |
| Insurance-health/life/dental |
$450,397.00 |
$284,145.60 |
| Jury leave |
$0.00 |
$1,628.52 |
| Medical/dental supplies |
$50.00 |
$12.46 |
| Medicare tax |
$33,826.00 |
$24,115.40 |
| Military leave |
$0.00 |
$184.32 |
| Minor computer hardware |
$2,620.00 |
$2,370.00 |
| Office furnishings |
$3,020.00 |
$617.15 |
| Office supplies |
$2,450.00 |
$4,700.02 |
| Overtime |
$48,965.00 |
$39,126.82 |
| Personal holiday pay |
$0.00 |
$16,075.86 |
| Personnel savings |
($215,007.00) |
$0.00 |
| Phone allowance |
$5,122.00 |
$5,130.99 |
| Professional registration |
$250.00 |
$1,060.00 |
| Regular wages - full-time |
$2,106,669.00 |
$1,274,252.38 |
| Safety equipment |
$100.00 |
$0.00 |
| Seminar/training fees |
$0.00 |
$917.17 |
| Services-interpretation |
$500.00 |
$0.00 |
| Services-other |
$115.00 |
$0.00 |
| Services-translators |
$1,000.00 |
$223.66 |
| Shift differential |
$0.00 |
$5,672.73 |
| Sick pay |
$0.00 |
$55,733.02 |
| Small tools/minor equipment |
$1,000.00 |
$1,366.71 |
| Software |
$515.00 |
$0.00 |
| Stability pay |
$15,621.00 |
$13,521.00 |
| Temporary employees |
$197,933.00 |
$151,944.65 |
| Terminal pay |
$0.00 |
$7,411.98 |
| Training-city wide |
$5,630.00 |
$1,144.19 |
| Vacation pay |
$0.00 |
$84,036.88 |
| Wastewater svcs-interlocal |
$62,400.00 |
$0.00 |
| |
$3,067,861.00 |
$2,290,877.98
|
|
| Public Affairs |
| Administrative leave |
$0.00 |
$3,366.56 |
| Advertising/publication |
$494,991.00 |
$227,355.98 |
| Allowances/other pay |
$0.00 |
$75.00 |
| Awards and Recognition |
$364.00 |
$300.00 |
| Bilingual Pay |
$5,460.00 |
$1,300.44 |
| Call back time |
$1,500.00 |
$2,323.16 |
| Contribution to employees ret |
$61,678.00 |
$51,723.06 |
| Educational travel |
$0.00 |
$1,726.13 |
| Educational/promotional |
$107,500.00 |
$87,357.17 |
| Emergency leave |
$0.00 |
$1,949.04 |
| FICA tax |
$44,742.00 |
$37,854.75 |
| Food/Ice |
$6,000.00 |
$1,673.62 |
| Holiday pay |
$0.00 |
$35,843.58 |
| Holidays worked |
$0.00 |
$408.54 |
| Insurance-health/life/dental |
$131,168.00 |
$100,049.62 |
| Interdepartmental Charges |
$19,478.00 |
$6,551.91 |
| Jury leave |
$0.00 |
$176.92 |
| Medicare tax |
$10,466.00 |
$8,853.43 |
| Memberships |
$750.00 |
$1,895.00 |
| Office supplies |
$3,000.00 |
$1,389.32 |
| On call hours |
$9,125.00 |
$3,585.00 |
| Overtime |
$7,500.00 |
$3,595.73 |
| Personal holiday pay |
$0.00 |
$9,884.75 |
| Personnel savings |
($72,030.00) |
$0.00 |
| Phone allowance |
$7,740.00 |
$4,929.44 |
| Printing/binding/photo/repr |
$58,407.00 |
$4,798.73 |
| Regular wages - full-time |
$710,522.00 |
$501,203.83 |
| Safety equipment |
$200.00 |
$103.26 |
| Services-other |
$178,750.00 |
$6,987.02 |
| Sick pay |
$0.00 |
$19,995.87 |
| Small tools/minor equipment |
$2,875.00 |
$0.00 |
| Software |
$3,000.00 |
$0.00 |
| Stability pay |
$4,750.00 |
$4,750.00 |
| Subscriptions |
$17,600.00 |
$10,395.53 |
| Temporary employees |
$0.00 |
$3,657.95 |
| Terminal pay |
$1,000.00 |
$0.00 |
| Vacation pay |
$0.00 |
$31,371.51 |
| |
$1,816,536.00 |
$1,177,431.85
|
|
|
| ENGINEERING SERVICES |
| Electrical Services |
| Accident pay |
$0.00 |
$152.76 |
| Administrative leave |
$0.00 |
$21,146.23 |
| Advertising/publication |
$313.00 |
$0.00 |
| Allowances/other pay |
$7,140.00 |
$7,648.53 |
| Awards and Recognition |
$592.00 |
$2,097.23 |
| Call back time |
$54,276.00 |
$43,355.42 |
| Clothing/clothing material |
$18,370.00 |
$2,850.00 |
| Contribution to employees ret |
$129,291.00 |
$105,372.30 |
| Educational incentive pay |
$0.00 |
$10,997.07 |
| Elctrcal conductors-hardware |
$0.00 |
$1,136.77 |
| Electrical/lighting |
$129,140.00 |
$18,934.38 |
| Emergency leave |
$0.00 |
$8,873.64 |
| FICA tax |
$93,467.00 |
$88,328.44 |
| Fleet-equip.preventative maint |
$121,699.00 |
$67,314.56 |
| Hardware/wire/steel |
$500.00 |
$38.88 |
| Holiday pay |
$0.00 |
$75,854.30 |
| Holidays worked |
$0.00 |
$1,656.93 |
| Household/cleaning supplies |
$0.00 |
$64.07 |
| Identification |
$0.00 |
$117.68 |
| Insurance-health/life/dental |
$238,732.00 |
$174,657.18 |
| Medicare tax |
$21,862.00 |
$20,658.02 |
| Mileage reimbursements |
$625.00 |
$401.10 |
| Minor computer hardware |
$938.00 |
$2,849.10 |
| Office supplies |
$0.00 |
$32.18 |
| On call hours |
$24,865.00 |
$15,936.00 |
| Other paid leave |
$9,363.00 |
$4,056.88 |
| Overtime |
$80,800.00 |
$137,622.57 |
| Parts for equipment |
$0.00 |
$10,759.78 |
| Parts for vehicles |
$6,332.00 |
$1,305.19 |
| Personal holiday pay |
$0.00 |
$16,101.74 |
| Personnel savings |
($151,186.00) |
$0.00 |
| Phone allowance |
$12,298.00 |
$6,094.62 |
| Professional registration |
$2,488.00 |
$560.00 |
| Regular wages - full-time |
$1,489,574.00 |
$945,228.11 |
| Rental-other equipment |
$6,500.00 |
$0.00 |
| Safety equipment |
$19,649.00 |
$11,882.33 |
| Services-hazardous mat disp |
$500.00 |
$0.00 |
| Services-inspection |
$715.00 |
$0.00 |
| Services-testing |
$7,255.00 |
$0.00 |
| Sick pay |
$0.00 |
$47,008.72 |
| Small tools/minor equipment |
$25,000.00 |
$12,056.95 |
| Software |
$1,462.00 |
$0.00 |
| Stability pay |
$11,424.00 |
$11,200.00 |
| Temporary employees |
$0.00 |
$15,718.21 |
| Terminal pay |
$5,610.00 |
$8,936.93 |
| Transportation-city veh fuel |
$33,493.00 |
$14,032.24 |
| Vacation pay |
$0.00 |
$98,938.40 |
| |
$2,403,087.00 |
$2,011,975.44
|
|
| Facility Engineering |
| Administrative leave |
$0.00 |
$4,038.00 |
| Allowances/other pay |
$0.00 |
$1,612.50 |
| Awards and Recognition |
$569.00 |
$0.00 |
| Contribution to employees ret |
$137,066.00 |
$80,674.55 |
| Dept OH distribtd to indire |
$0.00 |
($134,949.95) |
| Emergency leave |
$0.00 |
$3,174.48 |
| FICA tax |
$98,449.00 |
$56,424.07 |
| Food/Ice |
$1,500.00 |
$268.24 |
| Holiday pay |
$0.00 |
$41,889.74 |
| Holidays worked |
$0.00 |
$107.42 |
| Indirect costs-FMC 74-4 |
$0.00 |
$134,949.95 |
| Insurance-health/life/dental |
$213,148.00 |
$116,716.21 |
| Maintenance-computer hardware |
$1,500.00 |
$0.00 |
| Medicare tax |
$23,269.00 |
$13,496.94 |
| Memberships |
$1,200.00 |
$806.40 |
| Mileage reimbursements |
$1,500.00 |
$1,889.87 |
| Minor computer hardware |
$200.00 |
$117.40 |
| Office furnishings |
$3,500.00 |
$0.00 |
| Office supplies |
$1,185.00 |
$543.80 |
| Overtime |
$750.00 |
$624.12 |
| Personal holiday pay |
$0.00 |
$8,561.32 |
| Personnel savings |
($162,035.00) |
$0.00 |
| Phone allowance |
$2,250.00 |
$3,141.21 |
| Printing/binding/photo/repr |
$75.00 |
$37.50 |
| Professional registration |
$645.00 |
$574.50 |
| Regular wages - full-time |
$1,579,084.00 |
$830,604.87 |
| Reimbursement of CIP charge |
($613,388.00) |
($397,250.05) |
| Safety equipment |
$1,100.00 |
$889.38 |
| Sick pay |
$0.00 |
$16,971.81 |
| Small tools/minor equipment |
$500.00 |
$32.99 |
| Software |
$7,800.00 |
$0.00 |
| Stability pay |
$6,300.00 |
$8,000.00 |
| Temporary employees |
$17,472.00 |
$11,463.90 |
| Terminal pay |
$15,742.00 |
$0.00 |
| Vacation pay |
$0.00 |
$38,731.11 |
| |
$1,339,381.00 |
$844,142.28
|
|
| Instrumentation & Control |
| Administrative leave |
$0.00 |
$22,457.27 |
| Allowances/other pay |
$6,200.00 |
$8,226.42 |
| Awards and Recognition |
$569.00 |
$4,097.96 |
| Books-library |
$1,000.00 |
$0.00 |
| Call back time |
$51,148.00 |
$41,132.62 |
| Clothing/clothing material |
$14,602.00 |
$0.00 |
| Contribution to employees ret |
$108,109.00 |
$77,236.82 |
| Dept OH distribtd to indire |
$0.00 |
($2,530.68) |
| Elctrcal conductors-wire&cable |
$1,250.00 |
$0.00 |
| Electrical/lighting |
$300.00 |
$0.00 |
| Emergency leave |
$0.00 |
$5,833.68 |
| FICA tax |
$81,652.00 |
$58,837.82 |
| Fleet-equip.preventative maint |
$14,378.00 |
$0.00 |
| Food/Ice |
$1,185.00 |
$602.84 |
| Hardware/wire/steel |
$200.00 |
$0.00 |
| Holiday pay |
$0.00 |
$59,205.75 |
| Holidays worked |
$0.00 |
$691.79 |
| Household/cleaning supplies |
$100.00 |
$17.96 |
| Indirect costs-FMC 74-4 |
$0.00 |
$2,530.68 |
| Insurance-health/life/dental |
$227,582.00 |
$154,504.30 |
| Interdepartmental reimbursements |
$0.00 |
($6,098.06) |
| Medicare tax |
$19,104.00 |
$13,760.97 |
| Memberships |
$360.00 |
$115.50 |
| Minor computer hardware |
$773.00 |
$472.28 |
| Office supplies |
$2,943.00 |
$129.05 |
| On call hours |
$14,781.00 |
$14,950.50 |
| Other paid leave |
$12,938.00 |
$5,609.41 |
| Overtime |
$35,506.00 |
$34,632.43 |
| Parts for equipment |
$1,430.00 |
$307.26 |
| Parts for vehicles |
$5,768.00 |
$99.00 |
| Personal holiday pay |
$0.00 |
$15,388.64 |
| Personnel savings |
($127,379.00) |
$0.00 |
| Phone allowance |
$10,933.00 |
$4,825.68 |
| Priority mail/parcel services |
$100.00 |
$0.00 |
| Professional registration |
$533.00 |
$0.00 |
| Regular wages - full-time |
$1,245,417.00 |
$660,783.80 |
| Reimbursement of CIP charge |
$0.00 |
($1,630.58) |
| Services-hazardous mat disp |
$400.00 |
$0.00 |
| Services-testing |
$6,250.00 |
$1,979.83 |
| Sick pay |
$0.00 |
$34,320.40 |
| Stability pay |
$5,672.00 |
$5,336.00 |
| Street/traff signs/mrkr/pos |
$150.00 |
$0.00 |
| Temporary employees |
$60,424.00 |
$0.00 |
| Terminal pay |
$1,650.00 |
$127.61 |
| Training-city wide |
$1,000.00 |
$950.00 |
| Transportation-city veh fuel |
$6,338.00 |
$0.00 |
| Vacation pay |
$0.00 |
$60,627.42 |
| |
$1,813,366.00 |
$1,279,532.37
|
|
| Pipeline CIP Project Delivery |
| Administrative leave |
$0.00 |
$10,518.05 |
| Allowances/other pay |
$0.00 |
$2,400.00 |
| Awards and Recognition |
$614.00 |
$3,119.01 |
| Clothing/clothing material |
$0.00 |
$19.16 |
| Contribution to employees ret |
$120,003.00 |
$91,552.14 |
| Dept OH distribtd to indire |
$0.00 |
($138,170.77) |
| Electrical/lighting |
$60.00 |
$0.00 |
| FICA tax |
$91,221.00 |
$66,403.04 |
| Fleet-equip.preventative maint |
$35,212.00 |
$18,576.96 |
| Food/Ice |
$1,000.00 |
$323.29 |
| Government permits and fees |
$56.00 |
$55.12 |
| Holiday pay |
$0.00 |
$45,367.53 |
| Holidays worked |
$0.00 |
$3,712.91 |
| Household/cleaning supplies |
$50.00 |
$14.67 |
| Indirect costs-FMC 74-4 |
$0.00 |
$138,170.77 |
| Insurance-health/life/dental |
$196,752.00 |
$140,665.77 |
| Jury leave |
$0.00 |
$251.96 |
| Maintenance-buildings |
$1,000.00 |
$0.00 |
| Medicare tax |
$21,336.00 |
$15,691.75 |
| Memberships |
$500.00 |
$334.00 |
| Mileage reimbursements |
$500.00 |
$0.00 |
| Military leave |
$0.00 |
$5,543.12 |
| Minor computer hardware |
$2,000.00 |
$146.98 |
| Office furnishings |
$4,250.00 |
$16.99 |
| Office supplies |
$1,444.00 |
$429.29 |
| Overtime |
$1,000.00 |
$5,293.88 |
| Parking costs |
$0.00 |
$10.00 |
| Personal holiday pay |
$0.00 |
$13,699.04 |
| Personnel savings |
($140,268.00) |
$0.00 |
| Phone allowance |
$4,590.00 |
$3,266.73 |
| Printing/binding/photo/repr |
$500.00 |
$9.37 |
| Priority mail/parcel services |
$100.00 |
$10.95 |
| Professional registration |
$360.00 |
$125.01 |
| Regular wages - full-time |
$1,382,494.00 |
$915,725.31 |
| Reimbursement of CIP charge |
($350,851.00) |
($409,279.33) |
| Rental-other equipment |
$0.00 |
$24.99 |
| Safety equipment |
$1,000.00 |
$985.92 |
| Seminar/training fees |
$0.00 |
$153.40 |
| Sick pay |
$0.00 |
$24,812.48 |
| Small tools/minor equipment |
$500.00 |
$91.17 |
| Software |
$3,000.00 |
$403.33 |
| Stability pay |
$6,000.00 |
$6,000.00 |
| Temporary employees |
$18,208.00 |
$10,079.60 |
| Transportation-city veh fuel |
$4,216.00 |
$1,737.14 |
| Vacation pay |
$0.00 |
$54,831.07 |
| |
$1,406,847.00 |
$1,033,121.80
|
|
| Pipeline Engineering and Operations Support |
| Accident pay |
$0.00 |
$25,312.20 |
| Administrative leave |
$0.00 |
$6,604.47 |
| Allowances/other pay |
$0.00 |
$5,831.35 |
| Books-library |
$800.00 |
$0.00 |
| Call back time |
$30,000.00 |
$32,633.61 |
| Chemicals |
$1,182,921.00 |
$548,386.26 |
| Contribution to employees ret |
$134,910.00 |
$91,507.28 |
| Dept OH distribtd to indire |
$0.00 |
($13,134.01) |
| Educational travel |
$0.00 |
$356.80 |
| Educational/promotional |
$35,000.00 |
$0.00 |
| Emergency leave |
$0.00 |
$3,604.83 |
| FICA tax |
$102,559.00 |
$74,996.43 |
| Fleet-equip.preventative maint |
$14,054.00 |
$2,820.00 |
| Food/Ice |
$200.00 |
$255.42 |
| Grants to subrecipients |
$250,000.00 |
$16,800.00 |
| Holiday pay |
$0.00 |
$36,460.24 |
| Holidays worked |
$0.00 |
$1,211.16 |
| Indirect costs-FMC 74-4 |
$0.00 |
$13,134.01 |
| Insurance-health/life/dental |
$237,742.00 |
$149,163.95 |
| Interdeptl-PW CPM charges |
$10,000.00 |
$4,423.19 |
| Interest on invoices |
$0.00 |
$229.89 |
| Jury leave |
$0.00 |
$296.20 |
| Maintenance-other equipment |
$25,000.00 |
$0.00 |
| Maintenance-pipelines |
$2,950,000.00 |
$1,123,374.91 |
| Medicare tax |
$23,989.00 |
$17,540.11 |
| Memberships |
$125.00 |
$0.00 |
| Mileage reimbursements |
$900.00 |
$197.27 |
| Minor computer hardware |
$2,688.00 |
$2,903.76 |
| Office furnishings |
$250.00 |
$99.96 |
| Office supplies |
$950.00 |
$39.16 |
| On call hours |
$2,250.00 |
$7,731.00 |
| Other Equipment |
$0.00 |
$16,155.00 |
| Other paid leave |
$0.00 |
$2,362.96 |
| Overtime |
$32,000.00 |
$39,649.39 |
| Parental Leave |
$0.00 |
$30,974.40 |
| Personal holiday pay |
$0.00 |
$10,574.53 |
| Personnel savings |
($158,255.00) |
$0.00 |
| Phone allowance |
$7,110.00 |
$10,349.56 |
| Postage |
$0.00 |
$480.46 |
| Printing/binding/photo/repr |
$150.00 |
$0.00 |
| Professional registration |
$481.00 |
$725.00 |
| Regular wages - full-time |
$1,554,217.00 |
$873,262.89 |
| Reimbursement of CIP charge |
($12,385.00) |
($34,932.19) |
| Rental-other equipment |
$589,880.00 |
$359,599.16 |
| Safety equipment |
$300.00 |
$450.65 |
| Services-other |
$2,069,000.00 |
$914,684.16 |
| Sick pay |
$0.00 |
$40,239.21 |
| Small tools/minor equipment |
$14,300.00 |
$4,352.86 |
| Software |
$7,000.00 |
$5,452.66 |
| Stability pay |
$13,650.00 |
$13,700.00 |
| Temporary employees |
$79,162.00 |
$82,032.91 |
| Transportation-city veh fuel |
$612.00 |
$335.85 |
| Vacation pay |
$0.00 |
$44,819.07 |
| |
$9,201,560.00 |
$4,568,047.98
|
|
| SCADA Engineering & Support |
| Administrative leave |
$0.00 |
$4,276.60 |
| Allowances/other pay |
$0.00 |
$3,375.00 |
| Awards and Recognition |
$410.00 |
$0.00 |
| Contribution to employees ret |
$87,433.00 |
$53,403.15 |
| Dept OH distribtd to indire |
$0.00 |
($25,136.73) |
| Emergency leave |
$0.00 |
$3,277.60 |
| FICA tax |
$63,446.00 |
$37,999.29 |
| Food/Ice |
$1,500.00 |
$140.18 |
| Holiday pay |
$0.00 |
$13,430.12 |
| Holidays worked |
$0.00 |
$54.84 |
| Indirect costs-FMC 74-4 |
$0.00 |
$25,136.73 |
| Insurance-health/life/dental |
$147,564.00 |
$76,905.23 |
| Jury leave |
$0.00 |
$219.36 |
| Maintenance-computer hardware |
$30,000.00 |
$10,861.29 |
| Maintenance-computer software |
$195,000.00 |
$81,933.40 |
| Medicare tax |
$14,842.00 |
$8,941.65 |
| Memberships |
$400.00 |
$77.00 |
| Mileage reimbursements |
$700.00 |
$406.79 |
| Minor computer hardware |
$500.00 |
$491.82 |
| Office furnishings |
$1,000.00 |
$0.00 |
| Office supplies |
$1,500.00 |
$35.98 |
| Overtime |
$750.00 |
$38.54 |
| Personal holiday pay |
$0.00 |
$3,230.02 |
| Personnel savings |
($102,212.00) |
$0.00 |
| Phone allowance |
$3,750.00 |
$2,894.81 |
| Printing/binding/photo/repr |
$50.00 |
$0.00 |
| Priority mail/parcel services |
$50.00 |
$0.00 |
| Professional registration |
$80.00 |
$50.00 |
| Regular wages - full-time |
$1,007,233.00 |
$570,645.94 |
| Reimbursement of CIP charge |
($40,711.00) |
($74,605.96) |
| Safety equipment |
$1,000.00 |
$109.12 |
| Sick pay |
$0.00 |
$12,589.94 |
| Software |
$2,500.00 |
$1,796.81 |
| Stability pay |
$6,450.00 |
$6,450.00 |
| Temporary employees |
$5,824.00 |
$0.00 |
| Terminal pay |
$2,500.00 |
$0.00 |
| Training-city wide |
$1,500.00 |
$685.00 |
| Vacation pay |
$0.00 |
$15,305.96 |
| |
$1,433,059.00 |
$835,019.48
|
|
|
| ENVIRONMENTAL, PLANNING, AND DEVELOPMENT SERVICES |
| Environmental, Planning, and Development Support |
| Administrative leave |
$0.00 |
$832.13 |
| Allowances/other pay |
$0.00 |
$337.50 |
| Awards and Recognition |
$114.00 |
$0.00 |
| Books-library |
$1,500.00 |
$664.58 |
| Chemicals |
$50.00 |
$0.00 |
| Contribution to employees ret |
$32,227.00 |
$26,622.32 |
| Educational/promotional |
$200.00 |
$0.00 |
| Emergency leave |
$0.00 |
$1,863.60 |
| FICA tax |
$22,294.00 |
$17,730.25 |
| Fleet-equip.preventative maint |
$3,697.00 |
$3,096.16 |
| Food/Ice |
$650.00 |
$512.04 |
| Holiday pay |
$0.00 |
$19,778.40 |
| Insurance-health/life/dental |
$49,188.00 |
$35,595.02 |
| Medical/dental supplies |
$50.00 |
$0.00 |
| Medicare tax |
$5,466.00 |
$4,470.56 |
| Memberships |
$900.00 |
$0.00 |
| Minor computer hardware |
$1,300.00 |
$160.98 |
| Office supplies |
$650.00 |
$857.69 |
| Overtime |
$0.00 |
$27.85 |
| Personal holiday pay |
$0.00 |
$4,814.40 |
| Personnel savings |
($37,397.00) |
$0.00 |
| Phone allowance |
$1,470.00 |
$1,272.02 |
| Printing/binding/photo/repr |
$200.00 |
$0.00 |
| Priority mail/parcel services |
$50.00 |
$0.00 |
| Regular wages - full-time |
$371,272.00 |
$246,866.31 |
| Safety equipment |
$250.00 |
$502.92 |
| Seminar/training fees |
$0.00 |
$360.00 |
| Sick pay |
$0.00 |
$9,263.39 |
| Small tools/minor equipment |
$4,000.00 |
$2,601.44 |
| Software |
$550.00 |
$0.00 |
| Stability pay |
$4,200.00 |
$4,200.00 |
| Subscriptions |
$850.00 |
$0.00 |
| Transportation-city veh fuel |
$526.00 |
$60.10 |
| Vacation pay |
$0.00 |
$28,392.16 |
| |
$464,257.00 |
$410,881.82
|
|
| Infrastructure Management |
| Administrative leave |
$0.00 |
$4,293.57 |
| Allowances/other pay |
$0.00 |
$1,687.50 |
| Awards and Recognition |
$455.00 |
$0.00 |
| Books-library |
$100.00 |
$0.00 |
| Computer supplies |
$1,900.00 |
$0.00 |
| Contribution to employees ret |
$86,799.00 |
$52,489.15 |
| Educational travel |
$0.00 |
$231.40 |
| FICA tax |
$65,793.00 |
$41,903.23 |
| Food/Ice |
$5,000.00 |
$442.23 |
| Holiday pay |
$0.00 |
$25,079.04 |
| Insurance-health/life/dental |
$163,960.00 |
$94,049.93 |
| Medicare tax |
$15,388.00 |
$9,860.78 |
| Memberships |
$175.00 |
$215.50 |
| Mileage reimbursements |
$50.00 |
$0.00 |
| Minor computer hardware |
$750.00 |
$0.00 |
| Miscellaneous expense |
$0.00 |
$162.03 |
| Office furnishings |
$3,000.00 |
$0.00 |
| Office supplies |
$1,750.00 |
$16.84 |
| Overtime |
$3,000.00 |
$66.70 |
| Parental Leave |
$0.00 |
$7,740.25 |
| Personal holiday pay |
$0.00 |
$6,724.82 |
| Personnel savings |
($101,782.00) |
$0.00 |
| Phone allowance |
$2,400.00 |
$1,776.55 |
| Professional registration |
$100.00 |
$0.00 |
| Regular wages - full-time |
$999,907.00 |
$519,042.39 |
| Safety equipment |
$350.00 |
$0.00 |
| Seminar/training fees |
$0.00 |
$727.51 |
| Sick pay |
$0.00 |
$13,357.45 |
| Stability pay |
$9,150.00 |
$8,650.00 |
| Subscriptions |
$25.00 |
$0.00 |
| Temporary employees |
$49,600.00 |
$62,317.79 |
| Terminal pay |
$5,500.00 |
$0.00 |
| Training-city wide |
$1,000.00 |
$0.00 |
| Vacation pay |
$0.00 |
$40,090.47 |
| |
$1,314,370.00 |
$890,925.13
|
|
| Systems Planning |
| Administrative leave |
$0.00 |
$10,316.34 |
| Allowances/other pay |
$0.00 |
$1,747.50 |
| Awards and Recognition |
$501.00 |
$1,025.00 |
| Clothing/clothing material |
$50.00 |
$0.00 |
| Contribution to employees ret |
$80,321.00 |
$56,286.72 |
| FICA tax |
$63,289.00 |
$43,503.28 |
| Holiday pay |
$0.00 |
$32,580.00 |
| Insurance-health/life/dental |
$152,483.00 |
$93,740.72 |
| Medicare tax |
$14,806.00 |
$10,301.57 |
| Memberships |
$100.00 |
$85.00 |
| Mileage reimbursements |
$347.00 |
$0.00 |
| Minor computer hardware |
$200.00 |
$0.00 |
| Office supplies |
$3,041.00 |
$1,180.47 |
| Overtime |
$500.00 |
$1,626.92 |
| Personal holiday pay |
$0.00 |
$8,139.20 |
| Personnel savings |
($94,005.00) |
$0.00 |
| Phone allowance |
$2,757.00 |
$1,537.68 |
| Professional registration |
$160.00 |
$50.00 |
| Regular wages - full-time |
$925,298.00 |
$544,596.43 |
| Safety equipment |
$250.00 |
$57.50 |
| Services-Software as a Service |
$175,000.00 |
$0.00 |
| Sick pay |
$0.00 |
$25,008.88 |
| Small tools/minor equipment |
$250.00 |
$0.00 |
| Software |
$61,111.00 |
$1,008.12 |
| Stability pay |
$5,215.00 |
$4,800.00 |
| Temporary employees |
$87,500.00 |
$44,377.26 |
| Vacation pay |
$0.00 |
$39,171.26 |
| |
$1,479,174.00 |
$921,139.85
|
|
| Utility Development Services |
| Administrative leave |
$0.00 |
$11,154.38 |
| Allowances/other pay |
$0.00 |
$4,125.00 |
| Awards and Recognition |
$910.00 |
$962.50 |
| Bilingual Pay |
$4,500.00 |
$3,736.34 |
| Books-library |
$1,200.00 |
$189.46 |
| Clothing/clothing material |
$950.00 |
$28.25 |
| Consulting-information technology |
$1,000.00 |
$0.00 |
| Contribution to employees ret |
$194,275.00 |
$131,704.81 |
| Dept OH distribtd to indire |
$0.00 |
($11,938.39) |
| Educational travel |
$0.00 |
$926.19 |
| Emergency leave |
$0.00 |
$1,601.36 |
| FICA tax |
$145,544.00 |
$98,417.13 |
| Fleet-equip.preventative maint |
$14,054.00 |
$9,288.48 |
| Government permits and fees |
$600.00 |
$267.00 |
| Grant cost-support of other |
$45,000.00 |
$0.00 |
| Holiday pay |
$0.00 |
$56,980.66 |
| Holidays worked |
$0.00 |
$176.92 |
| Indirect costs-FMC 74-4 |
$0.00 |
$11,938.39 |
| Insurance-health/life/dental |
$344,316.00 |
$209,319.82 |
| Interdepartmental Charges |
$240,000.00 |
$0.00 |
| Interdepartmental reimbursements |
($113,469.00) |
$0.00 |
| Interdeptl-PW CPM charges |
$35,000.00 |
$0.00 |
| Jury leave |
$0.00 |
$167.67 |
| Laundry expense |
$0.00 |
$157.50 |
| Medicare tax |
$34,036.00 |
$23,018.38 |
| Memberships |
$2,000.00 |
$0.00 |
| Mileage reimbursements |
$500.00 |
$0.00 |
| Minor computer hardware |
$0.00 |
$392.77 |
| Office furnishings |
$500.00 |
$0.00 |
| Office supplies |
$3,000.00 |
$621.34 |
| Overtime |
$20,000.00 |
$13,245.93 |
| Parental Leave |
$0.00 |
$33,662.40 |
| Parking costs |
$0.00 |
$19.50 |
| Personal holiday pay |
$0.00 |
$15,574.36 |
| Personnel savings |
($227,403.00) |
$0.00 |
| Phone allowance |
$7,410.00 |
$5,472.71 |
| Professional registration |
$900.00 |
$841.72 |
| Regular wages - full-time |
$2,238,065.00 |
$1,318,398.21 |
| Reimbursement of CIP charge |
($14,466.00) |
($35,206.14) |
| Safety equipment |
$1,100.00 |
$240.00 |
| Seminar/training fees |
$0.00 |
$5,478.20 |
| Services-IT staffing |
$200,000.00 |
$124,920.16 |
| Services-other |
$1,000.00 |
$0.00 |
| Services-survey |
$1,500.00 |
$19.99 |
| Shift differential |
$0.00 |
$543.24 |
| Sick pay |
$0.00 |
$30,059.26 |
| Small tools/minor equipment |
$687.00 |
$0.00 |
| Software |
$10,000.00 |
$13,641.25 |
| Stability pay |
$20,850.00 |
$20,100.00 |
| Subscriptions |
$400.00 |
$85.00 |
| Temporary employees |
$76,440.00 |
$54,107.79 |
| Terminal pay |
$5,000.00 |
$0.00 |
| Training-city wide |
$0.00 |
$544.83 |
| Transportation-city veh fuel |
$4,972.00 |
$871.70 |
| Vacation pay |
$0.00 |
$66,786.35 |
| |
$3,300,371.00 |
$2,222,642.42
|
|
|
| OPERATIONS |
| Environmental Engineering & Technical Services |
| Administrative leave |
$0.00 |
$48,126.04 |
| Advertising/publication |
$9,007.00 |
$7,070.11 |
| Allowances/other pay |
$21,678.00 |
$21,945.00 |
| Awards and Recognition |
$2,419.00 |
$9,424.51 |
| Bilingual Pay |
$5,880.00 |
$2,075.83 |
| Books-library |
$710.00 |
$74.54 |
| Building material |
$212.00 |
$0.00 |
| Call back time |
$3,600.00 |
$2,208.59 |
| Chemicals |
$142,979.00 |
$79,285.73 |
| Clothing/clothing material |
$5,175.00 |
$107.30 |
| Computer supplies |
$1,375.00 |
$44.48 |
| Consulting-information technology |
$33,100.00 |
$14,559.03 |
| Contribution to employees ret |
$448,076.00 |
$334,503.41 |
| Educational/promotional |
$13,082.00 |
$4,295.23 |
| Electrical/lighting |
$604.00 |
$7.79 |
| Emergency leave |
$0.00 |
$7,907.47 |
| FICA tax |
$338,111.00 |
$254,556.63 |
| Fleet-equip.preventative maint |
$43,882.00 |
$30,133.12 |
| Food/Ice |
$5,900.00 |
$4,617.20 |
| Government permits and fees |
$80,725.00 |
$0.00 |
| Hardware/wire/steel |
$55.00 |
$0.00 |
| Holiday pay |
$0.00 |
$181,158.16 |
| Holidays worked |
$7,150.00 |
$5,345.20 |
| Household/cleaning supplies |
$261.00 |
$18.04 |
| Insurance-health/life/dental |
$950,969.00 |
$646,866.41 |
| Interdepartmental reimbursements |
($287,802.00) |
($165,483.47) |
| Interdeptl-PW CPM charges |
$4,440.00 |
$0.00 |
| Jury leave |
$0.00 |
$512.32 |
| Maintenance-buildings |
$500.00 |
$0.00 |
| Maintenance-computer hardware |
$100.00 |
$0.00 |
| Maintenance-computer software |
$70,080.00 |
$48,880.00 |
| Maintenance-office equipmen |
$550.00 |
$0.00 |
| Maintenance-other equipment |
$71,594.00 |
$26,745.70 |
| Medical/dental supplies |
$1,150.00 |
$91.77 |
| Medicare tax |
$79,080.00 |
$59,733.97 |
| Memberships |
$4,009.00 |
$2,056.00 |
| Mileage reimbursements |
$3,270.00 |
$408.75 |
| Minor computer hardware |
$3,623.00 |
$88.46 |
| Office furnishings |
$326.00 |
$0.00 |
| Office supplies |
$17,114.00 |
$6,566.01 |
| On call hours |
$13,300.00 |
$9,308.00 |
| Overtime |
$164,235.00 |
$115,415.62 |
| Paint/painting supplies |
$55.00 |
$0.00 |
| Parental Leave |
$0.00 |
$17,525.36 |
| Personal holiday pay |
$0.00 |
$44,708.94 |
| Personnel savings |
($524,140.00) |
$0.00 |
| Phone allowance |
$29,411.00 |
$13,857.16 |
| Photographic |
$438.00 |
$70.84 |
| Pipes and fittings |
$55.00 |
$0.00 |
| Printing/binding/photo/repr |
$11,800.00 |
$9,056.25 |
| Priority mail/parcel services |
$3,055.00 |
$1,435.19 |
| Professional registration |
$1,204.00 |
$759.00 |
| Regular wages - full-time |
$5,162,152.00 |
$3,255,831.09 |
| Rental-vehicles/buses |
$1,000.00 |
$50.96 |
| Safety equipment |
$5,880.00 |
$2,779.54 |
| Seminar/training fees |
$0.00 |
$3,450.00 |
| Services-engineering |
$3,250.00 |
$0.00 |
| Services-hazardous mat disp |
$15,155.00 |
$8,263.43 |
| Services-other |
$64,887.00 |
$11,096.84 |
| Services-testing |
$241,000.00 |
$83,814.00 |
| Sick pay |
$0.00 |
$123,502.03 |
| Small tools/minor equipment |
$244,738.00 |
$142,977.81 |
| Software |
$24,154.00 |
$0.00 |
| Stability pay |
$41,100.00 |
$41,100.00 |
| Subscriptions |
$786.00 |
$441.66 |
| Temporary employees |
$252,231.00 |
$117,852.64 |
| Terminal pay |
$45,538.00 |
$2,364.99 |
| Training-city wide |
$10,000.00 |
$590.00 |
| Transportation-city veh fuel |
$7,883.00 |
$12,305.88 |
| Vacation pay |
$0.00 |
$224,812.61 |
| Welding supplies |
$13,630.00 |
$5,836.36 |
| |
$7,915,781.00 |
$5,883,135.53
|
|
| Operations Support |
| Administrative leave |
$0.00 |
$1,812.80 |
| Allowances/other pay |
$0.00 |
$675.00 |
| Awards and Recognition |
$842.00 |
$232.16 |
| Bad weather pay |
$0.00 |
$283.28 |
| Books-library |
$1,375.00 |
$133.41 |
| Clothing/clothing material |
$4,290.00 |
$59.44 |
| Computer supplies |
$275.00 |
$54.29 |
| Contribution to employees ret |
$121,416.00 |
$68,841.52 |
| Educational travel |
$0.00 |
$200.52 |
| Educational/promotional |
$2,000.00 |
$220.19 |
| Emergency leave |
$0.00 |
$4,427.04 |
| FICA tax |
$92,979.00 |
$51,034.52 |
| Food/Ice |
$1,150.00 |
$146.66 |
| Government permits and fees |
$1,000.00 |
$0.00 |
| Holiday pay |
$0.00 |
$27,032.73 |
| Holidays worked |
$0.00 |
$684.55 |
| Insurance-health/life/dental |
$278,732.00 |
$140,738.70 |
| Maintenance-other equipment |
$3,000.00 |
$0.00 |
| Medical/dental supplies |
$50.00 |
$0.00 |
| Medicare tax |
$21,813.00 |
$12,246.39 |
| Memberships |
$410.00 |
$0.00 |
| Mileage reimbursements |
$1,170.00 |
$218.47 |
| Minor computer hardware |
$2,000.00 |
$246.31 |
| Miscellaneous expense |
$100.00 |
$121.29 |
| Office furnishings |
$2,828.00 |
$210.14 |
| Office supplies |
$6,672.40 |
$727.43 |
| Overtime |
$7,159.00 |
$1,427.74 |
| Parking costs |
$10.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$7,973.68 |
| Personnel savings |
($142,836.00) |
$0.00 |
| Phone allowance |
$6,840.00 |
$3,631.16 |
| Postage |
$70.00 |
$0.00 |
| Printing/binding/photo/repr |
$50.00 |
$2.00 |
| Professional registration |
$437.00 |
$0.00 |
| Regular wages - full-time |
$1,398,783.00 |
$715,754.27 |
| Rental-other equipment |
$5,490.00 |
$0.00 |
| Safety equipment |
$200.00 |
$0.00 |
| Services-IT Installations |
$431.60 |
$0.00 |
| Services-other |
$15,000.00 |
$0.00 |
| Shift differential |
$0.00 |
$459.68 |
| Sick pay |
$0.00 |
$11,097.57 |
| Small tools/minor equipment |
$945.00 |
$143.09 |
| Software |
$650.00 |
$0.00 |
| Stability pay |
$10,750.00 |
$9,650.00 |
| Temporary employees |
$87,360.00 |
$45,378.74 |
| Terminal pay |
$0.00 |
$9,227.99 |
| Training-city wide |
$2,000.00 |
$239.43 |
| Vacation pay |
$0.00 |
$30,169.06 |
| |
$1,935,442.00 |
$1,145,501.25
|
|
| Wastewater Collection Operations |
| Accident pay |
$0.00 |
$100,837.07 |
| Administrative leave |
$0.00 |
$146,466.34 |
| Agricultural/horticultural |
$9,546.00 |
$3,911.87 |
| Allowances/other pay |
$45,000.00 |
$79,127.16 |
| Asphalt |
$142,500.00 |
$104,494.75 |
| Awards and Recognition |
$9,340.00 |
$19,294.56 |
| Bilingual Pay |
$35,100.00 |
$28,210.50 |
| Building material |
$15,971.00 |
$52,566.93 |
| Call back time |
$449,411.00 |
$359,723.04 |
| Cement/concrete |
$27,731.00 |
$7,949.82 |
| Chemicals |
$12,490.00 |
$4,566.66 |
| Clothing/clothing material |
$52,557.00 |
$28,398.36 |
| Computer supplies |
$2,304.00 |
$467.87 |
| Const/repair material-other |
$196.00 |
$94.20 |
| Consulting-information technology |
$105,314.00 |
$61,286.46 |
| Contribution to employees ret |
$1,039,325.00 |
$789,881.78 |
| Dept OH distribtd to indire |
$0.00 |
($143,415.91) |
| Dietary hardware |
$130.00 |
$884.23 |
| Drainage fee expense |
$14,591.00 |
$19,619.74 |
| Educational incentive pay |
$60,000.00 |
$112,074.12 |
| Educational travel |
$0.00 |
$839.12 |
| Elctrcal conductors-hardware |
$375.00 |
$220.49 |
| Elctrcal conductors-wire&cable |
$1,345.00 |
$832.21 |
| Electric services |
$543,604.00 |
$397,839.01 |
| Electrical/lighting |
$157,256.00 |
$58,715.53 |
| Emergency leave |
$0.00 |
$16,824.48 |
| FICA tax |
$784,045.00 |
$736,254.38 |
| Fleet-equip.preventative maint |
$2,610,908.00 |
$1,802,465.51 |
| Food/Ice |
$4,076.00 |
$5,807.95 |
| Freight |
$5,296.00 |
$2,777.20 |
| Fuses and fusing apparatus |
$538.00 |
$59.33 |
| Garbage/refuse collection |
$84,370.00 |
$19,647.74 |
| Gas/heating fuels |
$8,500.00 |
$5,566.96 |
| Gasoline/oil/grease |
$10,870.00 |
$9,151.20 |
| Government permits and fees |
$100,000.00 |
$89,808.18 |
| Hardware/wire/steel |
$8,988.00 |
$9,624.47 |
| Holiday pay |
$0.00 |
$413,244.74 |
| Holidays worked |
$50,571.00 |
$57,845.89 |
| Household/cleaning supplies |
$11,108.00 |
$12,631.98 |
| Identification |
$0.00 |
$94.86 |
| Indirect costs-FMC 74-4 |
$0.00 |
$143,415.91 |
| Insurance-health/life/dental |
$2,427,619.00 |
$1,858,909.38 |
| Interdepartmental Charges |
$3,000.00 |
$2,810.00 |
| Interdepartmental reimbursements |
$0.00 |
($16,777.05) |
| Intradepartmental reimbursemnt |
$0.00 |
($15,124.75) |
| Intradeptl chgs-street cut rpr |
$3,000,000.00 |
$2,011,087.60 |
| Jury leave |
$0.00 |
$7,495.44 |
| Maintenance-buildings |
$88,420.00 |
$7,679.17 |
| Maintenance-computer software |
$65,000.00 |
$40,915.60 |
| Maintenance-electric motors |
$16,146.00 |
$0.00 |
| Maintenance-grounds |
$144,932.00 |
$14,682.42 |
| Maintenance-other equipment |
$379,629.00 |
$187,511.32 |
| Maintenance-turbine/generator |
$128,382.00 |
$35,302.09 |
| Maintenance-vehicles |
$6,104.00 |
$0.00 |
| Medical/dental supplies |
$14,284.00 |
$1,293.82 |
| Medicare tax |
$183,382.00 |
$172,303.88 |
| Memberships |
$462.00 |
$0.00 |
| Mileage reimbursements |
$2,241.00 |
$1,256.55 |
| Minor communications equipment |
$0.00 |
$289.64 |
| Minor computer hardware |
$60,395.00 |
$7,577.41 |
| Miscellaneous expense |
$2,704.00 |
$70.32 |
| Office furnishings |
$21,560.00 |
$0.00 |
| Office supplies |
$10,203.00 |
$9,353.89 |
| On call hours |
$222,658.00 |
$188,798.74 |
| Other Equipment |
$159,500.00 |
$130,228.97 |
| Other paid leave |
$0.00 |
$76,837.40 |
| Overtime |
$2,354,866.00 |
$1,887,753.58 |
| Paint/painting supplies |
$7,471.00 |
$1,568.72 |
| Parental Leave |
$0.00 |
$57,270.40 |
| Parts for equipment |
$263,440.00 |
$145,935.86 |
| Parts for vehicles |
$24,600.00 |
$5,181.53 |
| Personal holiday pay |
$0.00 |
$100,603.58 |
| Personnel savings |
($1,214,981.00) |
$0.00 |
| Phone allowance |
$48,136.00 |
$30,581.66 |
| Pipes and fittings |
$675,541.00 |
$591,016.85 |
| Postage |
$3,930.00 |
$4,599.17 |
| Printing/binding/photo/repr |
$2,800.00 |
$1,697.95 |
| Priority mail/parcel services |
$180.00 |
$51.61 |
| Professional registration |
$32,805.00 |
$7,764.56 |
| Radio equipment |
$0.00 |
$846.65 |
| Regular wages - full-time |
$11,973,601.00 |
$7,226,237.55 |
| Reimbursement of CIP charge |
($470,052.00) |
($437,049.48) |
| Relays and relaying equipment |
$1,076.00 |
$636.04 |
| Rental-other equipment |
$125,976.00 |
$63,015.67 |
| Rental-vehicles/buses |
$259.00 |
$0.00 |
| Safety equipment |
$131,694.00 |
$167,618.58 |
| Sand/gravel/stone |
$154,681.00 |
$70,857.33 |
| Security equipment |
$2,042.00 |
$0.00 |
| Seminar/training fees |
$0.00 |
$38,050.00 |
| Services-Dumpster Collection |
$10,480.00 |
$0.00 |
| Services-IT Installations |
$2,652.00 |
$1,167.40 |
| Services-hazardous mat disp |
$763.00 |
$0.00 |
| Services-other |
$653,287.00 |
$291,320.70 |
| Shift differential |
$0.00 |
$10,104.47 |
| Sick pay |
$0.00 |
$338,374.60 |
| Small electric motors-water ut |
$5,382.00 |
$1,545.69 |
| Small tools/minor equipment |
$297,212.00 |
$166,149.45 |
| Software |
$71,903.00 |
$300.00 |
| Stability pay |
$134,545.00 |
$131,186.53 |
| Street/traff signs/mrkr/pos |
$502.00 |
$0.00 |
| Telephone-cellular phones |
$93,647.00 |
$90,909.18 |
| Temporary employees |
$466,877.00 |
$358,919.34 |
| Terminal pay |
$15,250.00 |
$19,826.36 |
| Training-city wide |
$5,126.00 |
$400.00 |
| Transportation-city veh fuel |
$664,130.00 |
$439,460.52 |
| Vacation pay |
$0.00 |
$545,443.23 |
| Valves |
$50,548.00 |
$50,134.73 |
| Welding supplies |
$592.00 |
$0.00 |
| Wireless Communication-instal |
$500.00 |
$0.00 |
| |
$29,931,438.00 |
$22,692,088.54
|
|
| Wastewater Treatment Operations |
| Accident pay |
$0.00 |
$14,847.47 |
| Administrative leave |
$0.00 |
$69,929.43 |
| Advertising/publication |
$12,000.00 |
$12,187.45 |
| Agricultural/horticultural |
$4,200.00 |
$5,431.80 |
| Allowances/other pay |
$26,500.00 |
$48,675.00 |
| Awards and Recognition |
$5,688.00 |
$13,770.12 |
| Boiler equipment |
$5,000.00 |
$0.00 |
| Books-library |
$200.00 |
$0.00 |
| Building material |
$14,000.00 |
$1,275.30 |
| Call back time |
$43,800.00 |
$44,989.33 |
| Cement/concrete |
$2,000.00 |
$0.00 |
| Chemicals |
$11,508,880.00 |
$6,912,783.00 |
| Clothing/clothing material |
$50,295.00 |
$34,428.32 |
| Comp time used |
$0.00 |
$45.78 |
| Computer Hardware |
$0.00 |
$31,675.74 |
| Computer supplies |
$1,300.00 |
$14,374.73 |
| Const/repair material-other |
$607,000.00 |
$248,299.73 |
| Contribution to employees ret |
$812,538.00 |
$548,607.91 |
| Dietary hardware |
$1,000.00 |
$57.94 |
| Drainage fee expense |
$57,648.00 |
$42,376.23 |
| Educational incentive pay |
$72,000.00 |
$72,950.50 |
| Educational/promotional |
$500.00 |
$0.00 |
| Elctrcal conductors-hardware |
$467.00 |
$126.52 |
| Elctrcal conductors-wire&cable |
$4,500.00 |
$1,110.00 |
| Electric services |
$5,628,674.00 |
$4,083,457.82 |
| Electrical/lighting |
$260,155.00 |
$176,375.55 |
| Emergency leave |
$0.00 |
$8,326.51 |
| Exception vacation |
$0.00 |
$6,311.13 |
| FICA tax |
$586,682.00 |
$468,696.65 |
| Fleet-equip.preventative maint |
$308,276.00 |
$364,965.23 |
| Food/Ice |
$6,100.00 |
$3,314.03 |
| Freight |
$9,000.00 |
$3,252.63 |
| Fuses and fusing apparatus |
$1,750.00 |
$52.02 |
| Garbage/refuse collection |
$4,016.00 |
$3,595.04 |
| Gas/heating fuels |
$13,000.00 |
$14,951.20 |
| Gasoline/oil/grease |
$72,000.00 |
$53,030.55 |
| Government permits and fees |
$302,643.00 |
$305,799.81 |
| Hardware/wire/steel |
$15,000.00 |
$7,525.57 |
| Holiday pay |
$0.00 |
$291,120.55 |
| Holidays worked |
$86,100.00 |
$81,439.29 |
| Household/cleaning supplies |
$18,599.00 |
$11,037.04 |
| Insurance-health/life/dental |
$2,049,500.00 |
$1,276,384.42 |
| Interdepartmental Charges |
$131,250.00 |
$131,250.00 |
| Jury leave |
$0.00 |
$2,270.69 |
| Laundry expense |
$12,050.00 |
$11,779.76 |
| Maintenance-aux gen equipment |
$30,000.00 |
$6,281.23 |
| Maintenance-boilers |
$4,000.00 |
$7,125.00 |
| Maintenance-buildings |
$129,104.00 |
$1,681.90 |
| Maintenance-computer software |
$97,000.00 |
$99,358.20 |
| Maintenance-electric motors |
$129,000.00 |
$3,487.37 |
| Maintenance-grounds |
$177,400.00 |
$99,517.20 |
| Maintenance-other equipment |
$116,000.00 |
$22,659.98 |
| Maintenance-turbine/generator |
$389,396.00 |
$207,977.47 |
| Medical/dental supplies |
$1,820.00 |
$570.63 |
| Medicare tax |
$137,209.00 |
$109,614.43 |
| Memberships |
$285.00 |
$0.00 |
| Meters |
$8,935.00 |
$7,780.00 |
| Mileage reimbursements |
$5,500.00 |
$2,644.11 |
| Military leave |
$0.00 |
$3,338.40 |
| Minor computer hardware |
$120,050.00 |
$6,769.61 |
| Office furnishings |
$18,000.00 |
$757.10 |
| Office supplies |
$18,250.00 |
$7,640.91 |
| On call hours |
$35,000.00 |
$33,347.50 |
| Other Equipment |
$343,000.00 |
($4,494.86) |
| Other paid leave |
$0.00 |
$4,996.86 |
| Overtime |
$1,343,645.00 |
$1,101,249.73 |
| Paint/painting supplies |
$8,000.00 |
$3,215.73 |
| Parental Leave |
$0.00 |
$68,523.44 |
| Parts for equipment |
$879,065.00 |
$656,805.27 |
| Personal holiday pay |
$0.00 |
$69,469.70 |
| Personnel savings |
($949,415.00) |
$0.00 |
| Phone allowance |
$21,280.00 |
$6,337.23 |
| Pipes and fittings |
$111,445.00 |
$87,932.86 |
| Postage |
$550.00 |
$0.00 |
| Printing/binding/photo/repr |
$350.00 |
$410.00 |
| Priority mail/parcel services |
$800.00 |
$394.68 |
| Professional registration |
$10,720.00 |
$7,757.75 |
| Radio equipment |
$0.00 |
$7,859.68 |
| Refrigerant components-HVAC |
$1,500.00 |
$0.00 |
| Regular wages - full-time |
$9,360,779.00 |
$5,131,692.39 |
| Relays and relaying equipment |
$35,050.00 |
$1,807.32 |
| Rental-heavy equipment |
$34,000.00 |
$25,669.02 |
| Rental-other equipment |
$22,500.00 |
$5,600.09 |
| Rental-vehicles/buses |
$3,235.00 |
$183.88 |
| Safety equipment |
$298,000.00 |
$176,603.01 |
| Sand/gravel/stone |
$14,500.00 |
$3,832.12 |
| Security equipment |
$52,500.00 |
$241.88 |
| Seminar/training fees |
$0.00 |
$5,761.00 |
| Services-Bio Solid Reuse |
$2,200,000.00 |
$1,824,307.96 |
| Services-Dumpster Collection |
$225,000.00 |
$75,327.79 |
| Services-IT Installations |
$11,500.00 |
$0.00 |
| Services-construction contr |
$15,000.00 |
$0.00 |
| Services-environmnt assessment |
$2,000.00 |
$0.00 |
| Services-hazardous mat disp |
$1,500.00 |
$0.00 |
| Services-other |
$1,027,118.00 |
$822,537.17 |
| Services-testing |
$160,055.00 |
$74,596.75 |
| Shift differential |
$50,191.00 |
$35,243.91 |
| Sick pay |
$0.00 |
$242,409.37 |
| Small electric motors-water ut |
$58,500.00 |
$17,928.83 |
| Small tools/minor equipment |
$324,000.00 |
$290,386.84 |
| Software |
$33,000.00 |
$9,175.00 |
| Stability pay |
$92,000.00 |
$88,300.00 |
| Street/traff signs/mrkr/pos |
$8,000.00 |
$1,627.76 |
| Subscriptions |
$0.00 |
$2,398.00 |
| Telephone-cellular phones |
$10,500.00 |
$0.00 |
| Terminal pay |
$43,236.00 |
$17,665.18 |
| Training-city wide |
$2,000.00 |
$655.00 |
| Transportation-city veh fuel |
$138,216.00 |
$70,765.61 |
| Vacation pay |
$0.00 |
$388,846.25 |
| Valves |
$48,500.00 |
$93,927.51 |
| Wastewater svcs-interlocal |
$820,000.00 |
($130,432.42) |
| Welding supplies |
$7,250.00 |
$1,690.70 |
| |
$41,020,330.00 |
$27,332,634.82
|
|
|
| OTHER UTILITY PROGRAM REQUIREMENTS |
| Other Utility Program Requirements |
| Arbitrage rebate-admin exp |
$12,425.00 |
$4,442.97 |
| Bad Debt Expense |
$786,415.00 |
$400,951.10 |
| Bond issue costs |
$0.00 |
$117,241.20 |
| Claims-auto liability |
$20,000.00 |
$6,655.05 |
| Claims-general liability |
$50,000.00 |
$977.72 |
| Commercial paper admin exp |
$591,920.00 |
$610,330.22 |
| Consultant-financial |
$125,000.00 |
$12,816.87 |
| Consulting-information technology |
$11,250.00 |
$0.00 |
| FICA tax |
$236.00 |
$0.00 |
| Federal unemployment tax co |
$14,500.00 |
$8,118.69 |
| Fire/Extend Coverage Insurance |
$1,045,033.00 |
$905,299.29 |
| Garbage/refuse collection |
$50,000.00 |
$44,323.11 |
| Government permits and fees |
$20,000.00 |
$25,000.00 |
| Grants to subrecipients |
$100,000.00 |
$14,861.09 |
| Interdepartmental Charges |
$1,649,801.00 |
$1,625,000.00 |
| Medicare tax |
$55.00 |
$0.00 |
| Rental-real estate-office |
$264,092.00 |
$132,048.00 |
| Services-Credit Card Fees |
$300,000.00 |
$0.00 |
| Services-legal fees |
$175,000.00 |
$5,600.00 |
| Services-other |
$1,458,246.00 |
$105,846.49 |
| Software |
$61,500.00 |
$72,750.00 |
| Structured settlements |
$50,000.00 |
$25,118.47 |
| Temporary employees |
$3,814.00 |
$0.00 |
| Util rev bnd commission exp |
$3,460.00 |
$2,532.50 |
| |
$6,792,747.00 |
$4,119,912.77
|
|
|
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$63,021.27 |
| Allowances/other pay |
$0.00 |
$11,112.99 |
| Awards and Recognition |
$20,114.00 |
$8,817.96 |
| Bilingual Pay |
$4,500.00 |
$3,792.95 |
| Boiler equipment |
$500.00 |
($23.48) |
| Books-library |
$32,090.00 |
$3,816.92 |
| Building material |
$15,275.00 |
$5,240.13 |
| Call back time |
$0.00 |
$3,031.99 |
| Chemicals |
$5,800.00 |
$3,123.46 |
| Clothing/clothing material |
$24,150.00 |
$10,301.65 |
| Comp time used |
$0.00 |
$386.04 |
| Const/repair material-other |
$10,000.00 |
$2,485.73 |
| Consulting-information technology |
$268,975.00 |
$98,811.75 |
| Contribution to employees ret |
$1,114,844.00 |
$757,013.65 |
| Dept OH distribtd to indire |
$0.00 |
($2,024.08) |
| Drainage fee expense |
$82,395.00 |
$63,227.71 |
| Educational incentive pay |
$0.00 |
$6,153.50 |
| Educational travel |
$162,573.00 |
$147,746.68 |
| Educational/promotional |
$57,000.00 |
$12,217.94 |
| Elctrcal conductors-hardware |
$5,000.00 |
$767.50 |
| Electric services |
$238,800.00 |
$248,754.43 |
| Electrical/lighting |
$27,036.00 |
$121,010.01 |
| Emergency leave |
$0.00 |
$7,426.56 |
| Employee recruiting |
$15,000.00 |
$11,943.50 |
| Exception vacation |
$0.00 |
$247.54 |
| Expense refunds |
($280,000.00) |
($201,712.23) |
| FICA tax |
$825,985.00 |
$571,335.88 |
| Fleet-equip.preventative maint |
$15,465.00 |
$14,820.16 |
| Food/Ice |
$27,975.00 |
$13,877.13 |
| Freight |
$500.00 |
$742.95 |
| Garbage/refuse collection |
$2,500.00 |
$1,083.60 |
| Gas/heating fuels |
$12,300.00 |
$7,177.30 |
| Gasoline/oil/grease |
$600.00 |
$740.23 |
| Government permits and fees |
$3,200.00 |
$0.00 |
| Hardware/wire/steel |
$8,225.00 |
$9,881.61 |
| Holiday pay |
$0.00 |
$388,286.10 |
| Holidays worked |
$0.00 |
$11,952.15 |
| Household/cleaning supplies |
$8,350.00 |
$4,739.77 |
| Indirect costs-FMC 74-4 |
$0.00 |
$2,024.08 |
| Insurance-health/life/dental |
$2,229,856.00 |
$1,382,603.83 |
| Interdepartmental Charges |
$2,500.00 |
$2,938.00 |
| Jury leave |
$0.00 |
$1,083.52 |
| Maintenance-boilers |
$8,300.00 |
$0.00 |
| Maintenance-buildings |
$650,500.00 |
$383,510.34 |
| Maintenance-chillers |
$100,000.00 |
$0.00 |
| Maintenance-computer hardware |
$340,900.00 |
$13,992.63 |
| Maintenance-computer software |
$1,296,779.00 |
$810,355.54 |
| Maintenance-electric motors |
$250.00 |
$0.00 |
| Maintenance-grounds |
$150,000.00 |
$148,852.87 |
| Maintenance-other equipment |
$15,000.00 |
$974.51 |
| Medical/dental supplies |
$650.00 |
$1,631.26 |
| Medicare tax |
$194,871.00 |
$134,796.47 |
| Memberships |
$147,663.00 |
$134,516.74 |
| Mileage reimbursements |
$3,199.00 |
$1,873.28 |
| Military leave |
$0.00 |
$4,166.24 |
| Minor communications equipment |
$0.00 |
$3,678.29 |
| Minor computer hardware |
$314,772.00 |
$209,680.05 |
| Office furnishings |
$22,450.00 |
$33,774.69 |
| Office supplies |
$26,645.00 |
$17,241.86 |
| On call hours |
$6,695.00 |
$9,044.53 |
| Other Equipment |
$16,000.00 |
$31,952.60 |
| Other paid leave |
$0.00 |
$244.15 |
| Overtime |
$58,162.00 |
$90,074.64 |
| Paint/painting supplies |
$950.00 |
$4,510.84 |
| Parental Leave |
$0.00 |
$34,673.84 |
| Parking costs |
$306.00 |
$0.00 |
| Parts for equipment |
$2,500.00 |
$32,177.50 |
| Personal holiday pay |
$0.00 |
$102,487.76 |
| Personnel savings |
($1,304,040.00) |
$0.00 |
| Phone allowance |
$57,870.00 |
$43,490.52 |
| Pipes and fittings |
$3,850.00 |
$8,624.21 |
| Postage |
$0.00 |
$28.84 |
| Printing/binding/photo/repr |
$0.00 |
$192.75 |
| Priority mail/parcel services |
$37,500.00 |
$7,790.00 |
| Professional registration |
$16,078.00 |
$5,168.56 |
| Radio equipment |
$162,500.00 |
$120,181.23 |
| Refrigerant components-HVAC |
$37,000.00 |
$6,526.36 |
| Regular wages - full-time |
$12,843,115.00 |
$7,588,328.83 |
| Reimbursement of CIP charge |
$0.00 |
($5,896.35) |
| Rental-copy machines |
$170,000.00 |
$13,512.14 |
| Rental-other equipment |
$370.00 |
$3,671.45 |
| Rental-real estate-other |
$66,102.00 |
$39,820.00 |
| Rental-vehicles/buses |
$500.00 |
$0.00 |
| Safety equipment |
$181,591.00 |
$132,388.18 |
| Security equipment |
$1,700.00 |
$1,040.87 |
| Seminar/training fees |
$162,073.00 |
$13,259.59 |
| Services - Contractual Electrical |
$50,000.00 |
$1,397.46 |
| Services - Contracutal HVAC |
$275,000.00 |
$395,706.30 |
| Services - Fire Alarms |
$125,000.00 |
$71,369.84 |
| Services-IT |
$70,365.00 |
$7,499.25 |
| Services-IT Installations |
$0.00 |
$3,447.05 |
| Services-IT staffing |
$265,000.00 |
$110,396.92 |
| Services-Platform as a Service |
$219,280.00 |
$61,599.13 |
| Services-Software as a Service |
$481,500.00 |
$381,933.11 |
| Services-hazardous mat disp |
$11,000.00 |
$0.00 |
| Services-inspection |
$10,500.00 |
$947.65 |
| Services-internet/cable |
$38,644.00 |
$18,547.04 |
| Services-janitorial |
$665,000.00 |
$301,777.71 |
| Services-medical/surgical |
$22,650.00 |
$0.00 |
| Services-other |
$294,280.00 |
$153,238.36 |
| Services-security |
$1,083,750.00 |
$808,596.26 |
| Services-testing |
$50,000.00 |
$1,316.50 |
| Shift differential |
$0.00 |
$3,801.38 |
| Sick pay |
$0.00 |
$245,239.37 |
| Small electric motors-water ut |
$3,000.00 |
$0.00 |
| Small tools/minor equipment |
$29,137.00 |
$60,077.04 |
| Software |
$21,275.00 |
$10,577.62 |
| Stability pay |
$86,250.00 |
$77,950.00 |
| Street/traff signs/mrkr/pos |
$60.00 |
$0.00 |
| Subscriptions |
$10,198.00 |
$2,889.24 |
| Telephone-base cost |
$132,500.00 |
$72,586.02 |
| Telephone-cellular phones |
$260,000.00 |
$87,767.58 |
| Temporary employees |
$447,492.00 |
$423,306.13 |
| Terminal pay |
$10,500.00 |
$38,488.93 |
| Toll Road - Tx Tag |
$7,500.00 |
$3,258.22 |
| Training-city wide |
$5,000.00 |
$2,068.50 |
| Transportation fee expense |
$0.00 |
$23,214.48 |
| Transportation-city veh fuel |
$7,284.00 |
$2,890.28 |
| Vacation pay |
$0.00 |
$424,167.27 |
| Valves |
$500.00 |
$6,258.57 |
| Welding supplies |
$550.00 |
$70.26 |
| |
$25,417,524.00 |
$17,784,699.66
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Debt Transfers |
| Commercial paper interest |
$4,211,136.00 |
$1,202,720.12 |
| Tfr to Util D/S Tax/Rev Bonds |
$421,237.00 |
$16,026.14 |
| Tfr to Utility D/S Sub Lien |
$2,058,080.00 |
$2,071,273.94 |
| Trf to GO Debt Service |
$538,974.00 |
$224,941.55 |
| Trf to Util D/S Separate Lien |
$66,433,057.00 |
$41,859,270.22 |
| |
$73,662,484.00 |
$45,374,231.97
|
|
| Interfund Transfers |
| Administrative Support |
$8,002,134.00 |
$5,334,756.00 |
| CTECC Support |
$20,296.00 |
$20,296.00 |
| CTM Support |
$2,732,925.00 |
$1,821,950.00 |
| Regional Radio System |
$388,530.00 |
$259,020.00 |
| TRF CRF to Debt Defeasance |
$12,500,000.00 |
$12,500,000.00 |
| Trf to CIP Mgm - CPM |
$3,680,673.00 |
$2,453,782.00 |
| Trf to Economic Development |
$1,899,503.00 |
$1,266,335.36 |
| Trf to General Fund |
$24,554,309.00 |
$16,369,539.36 |
| Trf to Wastewater CIP Fund |
$60,299,000.00 |
$44,076,331.00 |
| Workers' Compensation |
$679,987.00 |
$453,324.64 |
| |
$114,757,357.00 |
$84,555,334.36
|
|
| Other Requirements |
| Accrued Payroll |
$274,821.00 |
$0.00 |
| Compensation Adjustment |
$36,538.00 |
$0.00 |
| Contribution to employees ret |
$5,462,362.00 |
$3,571,544.79 |
| Interdepartmental Charges |
$208,018.00 |
$138,678.64 |
| Trf to PID Fund |
$37,500.00 |
$37,500.00 |
| Utility Billing System Support |
$9,799,723.00 |
$6,533,148.68 |
| |
$15,818,962.00 |
$10,280,872.11
|
|
|
|
| AUSTIN WATER WATER UTILITY OPERATING FUND |
BUDGET |
EXPENDITURES |
| CUSTOMER EXPERIENCE |
| Advanced Metering Infrastructure |
| Administrative leave |
$0.00 |
$2,064.05 |
| Allowances/other pay |
$0.00 |
$450.00 |
| Awards and Recognition |
$273.00 |
$0.00 |
| Books-library |
$500.00 |
$0.00 |
| Computer supplies |
$1,000.00 |
$0.00 |
| Contribution to employees ret |
$57,995.00 |
$38,629.20 |
| Dept OH distribtd to indire |
$0.00 |
($21,971.03) |
| FICA tax |
$42,164.00 |
$30,989.79 |
| Food/Ice |
$500.00 |
$0.00 |
| Holiday pay |
$0.00 |
$21,514.24 |
| Indirect costs-FMC 74-4 |
$0.00 |
$21,971.03 |
| Insurance-health/life/dental |
$98,376.00 |
$56,125.18 |
| Jury leave |
$0.00 |
$430.16 |
| Medicare tax |
$9,861.00 |
$7,256.56 |
| Memberships |
$500.00 |
$0.00 |
| Mileage reimbursements |
$500.00 |
$0.00 |
| Minor computer hardware |
$250.00 |
$0.00 |
| Office furnishings |
$15,000.00 |
$178.14 |
| Office supplies |
$500.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$7,737.76 |
| Personnel savings |
($74,097.00) |
$0.00 |
| Phone allowance |
$5,820.00 |
$4,523.02 |
| Professional registration |
$500.00 |
$50.00 |
| Regular wages - full-time |
$668,172.00 |
$366,202.85 |
| Reimbursement of CIP charge |
($173,832.00) |
($57,807.08) |
| Rental-other equipment |
$0.00 |
$275.00 |
| Rental-vehicles/buses |
$500.00 |
$0.00 |
| Safety equipment |
$1,000.00 |
$979.08 |
| Sick pay |
$0.00 |
$22,143.46 |
| Small tools/minor equipment |
$1,000.00 |
$2,314.30 |
| Software |
$1,000.00 |
$0.00 |
| Stability pay |
$6,100.00 |
$6,200.00 |
| Temporary employees |
$0.00 |
$49,546.17 |
| Vacation pay |
$0.00 |
$34,010.92 |
| |
$663,582.00 |
$593,812.80
|
|
| Customer Insights & Solutions |
| Awards and Recognition |
$91.00 |
$0.00 |
| Bilingual Pay |
$900.00 |
$550.40 |
| Contribution to employees ret |
$21,165.00 |
$11,511.10 |
| Educational travel |
$0.00 |
$1,101.45 |
| FICA tax |
$14,610.00 |
$7,306.85 |
| Food/Ice |
$600.00 |
$193.46 |
| Holiday pay |
$0.00 |
$7,110.84 |
| Holidays worked |
$0.00 |
$402.88 |
| Insurance-health/life/dental |
$32,792.00 |
$14,855.28 |
| Medicare tax |
$3,580.00 |
$1,893.40 |
| Mileage reimbursements |
$0.00 |
$285.96 |
| Office supplies |
$0.00 |
$398.65 |
| Personal holiday pay |
$0.00 |
$2,417.28 |
| Personnel savings |
($27,329.00) |
$0.00 |
| Phone allowance |
$570.00 |
$598.43 |
| Regular wages - full-time |
$243,828.00 |
$113,783.26 |
| Sick pay |
$0.00 |
$1,611.52 |
| Stability pay |
$1,500.00 |
$2,000.00 |
| Subscriptions |
$22,250.00 |
$24,272.48 |
| Temporary employees |
$0.00 |
$149.50 |
| Vacation pay |
$0.00 |
$9,417.32 |
| |
$314,557.00 |
$199,860.06
|
|
| Customer Services |
| Administrative leave |
$0.00 |
$11,353.17 |
| Allowances/other pay |
$0.00 |
$1,120.50 |
| Awards and Recognition |
$1,272.00 |
$1,194.40 |
| Bilingual Pay |
$7,794.00 |
$5,254.30 |
| Clothing/clothing material |
$3,000.00 |
$2,321.61 |
| Contribution to employees ret |
$188,981.00 |
$124,122.07 |
| Educational travel |
$0.00 |
$518.43 |
| Educational/promotional |
$800.00 |
$0.00 |
| Emergency leave |
$0.00 |
$9,769.62 |
| FICA tax |
$148,824.00 |
$97,673.16 |
| Fleet-equip.preventative maint |
$19,058.00 |
$8,736.16 |
| Food/Ice |
$850.00 |
$1,706.07 |
| Hardware/wire/steel |
$250.00 |
$0.00 |
| Holiday pay |
$0.00 |
$76,894.91 |
| Holidays worked |
$4,563.00 |
$6,030.42 |
| Household/cleaning supplies |
$25.00 |
$28.73 |
| Insurance-health/life/dental |
$467,776.00 |
$292,354.46 |
| Jury leave |
$0.00 |
$252.45 |
| Medical/dental supplies |
$50.00 |
$12.46 |
| Medicare tax |
$34,883.00 |
$22,852.66 |
| Meters |
$717,630.00 |
$470,445.36 |
| Mileage reimbursements |
$25.00 |
$0.00 |
| Minor computer hardware |
$3,320.00 |
$3,052.48 |
| Office furnishings |
$4,685.00 |
$3,763.76 |
| Office supplies |
$1,700.00 |
$5,002.47 |
| Overtime |
$48,965.00 |
$39,239.33 |
| Parental Leave |
$0.00 |
$4,263.60 |
| Personal holiday pay |
$0.00 |
$23,484.10 |
| Personnel savings |
($242,465.00) |
$0.00 |
| Phone allowance |
$5,676.00 |
$4,739.11 |
| Professional registration |
$250.00 |
$1,060.00 |
| Raw water - purchased |
$5,000.00 |
$0.00 |
| Regular wages - full-time |
$2,177,004.00 |
$1,168,171.65 |
| Rental-vehicles/buses |
$50.00 |
$0.00 |
| Safety equipment |
$600.00 |
$0.00 |
| Seminar/training fees |
$0.00 |
$917.15 |
| Services-interpretation |
$500.00 |
$0.00 |
| Services-other |
$115.00 |
$0.00 |
| Services-translators |
$1,000.00 |
$281.71 |
| Shift differential |
$0.00 |
$5,278.11 |
| Sick pay |
$0.00 |
$61,629.69 |
| Small tools/minor equipment |
$1,050.00 |
$2,595.42 |
| Software |
$650.00 |
$0.00 |
| Stability pay |
$16,479.00 |
$14,379.00 |
| Temporary employees |
$197,933.00 |
$124,962.37 |
| Terminal pay |
$6,222.00 |
$7,411.97 |
| Training-city wide |
$6,000.00 |
$1,144.19 |
| Transportation-city veh fuel |
$8,077.00 |
$7,580.88 |
| Vacation pay |
$0.00 |
$93,718.32 |
| |
$3,838,592.00 |
$2,705,316.25
|
|
| Public Affairs |
| Administrative leave |
$0.00 |
$1,380.20 |
| Advertising/publication |
$494,991.00 |
$456,431.81 |
| Allowances/other pay |
$0.00 |
$75.00 |
| Awards and Recognition |
$364.00 |
$200.00 |
| Bilingual Pay |
$5,460.00 |
$1,330.68 |
| Call back time |
$1,500.00 |
$2,323.13 |
| Contribution to employees ret |
$61,678.00 |
$53,932.15 |
| Educational travel |
$0.00 |
$1,726.15 |
| Educational/promotional |
$107,500.00 |
$87,357.21 |
| Exp Reimb - Public Information Requests |
$0.00 |
($684.00) |
| FICA tax |
$44,742.00 |
$39,627.82 |
| Fleet-equip.preventative maint |
$3,809.00 |
$2,820.00 |
| Food/Ice |
$6,000.00 |
$1,673.66 |
| Holiday pay |
$0.00 |
$23,699.74 |
| Holidays worked |
$0.00 |
$85.98 |
| Insurance-health/life/dental |
$131,168.00 |
$104,081.95 |
| Interdepartmental Charges |
$19,478.00 |
$6,551.88 |
| Medicare tax |
$10,466.00 |
$9,267.53 |
| Memberships |
$750.00 |
$1,895.00 |
| Office supplies |
$3,000.00 |
$1,388.64 |
| On call hours |
$9,125.00 |
$3,492.00 |
| Overtime |
$7,500.00 |
$4,418.42 |
| Parental Leave |
$0.00 |
$17,473.68 |
| Personal holiday pay |
$0.00 |
$5,062.48 |
| Personnel savings |
($78,695.00) |
$0.00 |
| Phone allowance |
$7,740.00 |
$4,599.68 |
| Printing/binding/photo/repr |
$162,920.00 |
$121,422.86 |
| Regular wages - full-time |
$710,522.00 |
$531,969.02 |
| Rental-other equipment |
$3,785.00 |
$0.00 |
| Safety equipment |
$200.00 |
$149.34 |
| Services-other |
$178,750.00 |
$6,987.02 |
| Sick pay |
$0.00 |
$22,165.57 |
| Small tools/minor equipment |
$2,875.00 |
($46.08) |
| Software |
$3,000.00 |
$0.00 |
| Stability pay |
$4,750.00 |
$4,750.00 |
| Subscriptions |
$17,600.00 |
$10,395.55 |
| Temporary employees |
$0.00 |
$3,657.95 |
| Terminal pay |
$1,000.00 |
$0.00 |
| Transportation-city veh fuel |
$1,745.00 |
$168.41 |
| Vacation pay |
$0.00 |
$29,774.78 |
| |
$1,923,723.00 |
$1,561,605.21
|
|
| Water Meter Maintenance |
| Accident pay |
$0.00 |
$23,235.49 |
| Administrative leave |
$0.00 |
$27,542.03 |
| Allowances/other pay |
$28,000.00 |
$24,434.77 |
| Awards and Recognition |
$1,775.00 |
$6,572.00 |
| Bilingual Pay |
$32,700.00 |
$11,563.08 |
| Building material |
$500.00 |
$838.02 |
| Call back time |
$86,352.00 |
$68,912.31 |
| Cement/concrete |
$500.00 |
$2,551.10 |
| Chemicals |
$1,242.00 |
$1,156.92 |
| Clothing/clothing material |
$10,557.00 |
$12,179.80 |
| Consultant-others |
$130,815.00 |
$97,110.00 |
| Contribution to employees ret |
$247,747.00 |
$182,106.39 |
| Dietary hardware |
$48.00 |
$340.57 |
| Educational incentive pay |
$0.00 |
$6,877.19 |
| Electrical/lighting |
$4,243.00 |
$341.03 |
| Emergency leave |
$0.00 |
$2,554.88 |
| FICA tax |
$186,638.00 |
$159,194.78 |
| Fleet-equip. vehicle/equipment modification |
$0.00 |
$46,139.02 |
| Fleet-equip.preventative maint |
$230,602.00 |
$126,514.32 |
| Food/Ice |
$1,650.00 |
$3,918.83 |
| Gasoline/oil/grease |
$621.00 |
$348.71 |
| Government permits and fees |
$500.00 |
$915.20 |
| Hardware/wire/steel |
$20,700.00 |
$5,490.24 |
| Holiday pay |
$0.00 |
$98,595.12 |
| Holidays worked |
$0.00 |
$405.23 |
| Household/cleaning supplies |
$3,105.00 |
$2,146.39 |
| Insurance-health/life/dental |
$639,444.00 |
$433,235.94 |
| Jury leave |
$0.00 |
$1,139.84 |
| Medical/dental supplies |
$2,277.00 |
$1,823.04 |
| Medicare tax |
$43,648.00 |
$37,230.99 |
| Meter parts |
$18,112.00 |
$10,366.34 |
| Meters |
$329,174.00 |
$409,667.59 |
| Minor computer hardware |
$362.00 |
$29.97 |
| Office furnishings |
$5,175.00 |
$756.92 |
| Office supplies |
$3,933.00 |
$4,658.64 |
| On call hours |
$43,622.00 |
$31,406.86 |
| Other paid leave |
$0.00 |
$10,419.20 |
| Overtime |
$247,292.00 |
$257,797.77 |
| Paint/painting supplies |
$500.00 |
$307.07 |
| Parental Leave |
$0.00 |
$22,932.50 |
| Parts for equipment |
$621.00 |
$333.90 |
| Parts for vehicles |
$310.00 |
$25,044.57 |
| Personal holiday pay |
$0.00 |
$29,521.89 |
| Personnel savings |
($317,500.00) |
$0.00 |
| Phone allowance |
$17,900.00 |
$14,037.44 |
| Pipes and fittings |
$30,000.00 |
$31,144.37 |
| Postage |
$0.00 |
$1,184.42 |
| Professional registration |
$2,000.00 |
$913.25 |
| Pull boxes,svc boxes,manholes |
$36,378.00 |
$26,686.97 |
| Regular wages - full-time |
$2,854,288.00 |
$1,654,606.84 |
| Rental-vehicles/buses |
$2,000.00 |
$0.00 |
| Safety equipment |
$36,050.00 |
$41,234.83 |
| Seminar/training fees |
$0.00 |
$750.00 |
| Services-other |
$562,759.00 |
$469,779.40 |
| Shift differential |
$1,500.00 |
$1,187.83 |
| Sick pay |
$0.00 |
$101,759.35 |
| Small tools/minor equipment |
$36,225.00 |
$37,938.72 |
| Stability pay |
$27,000.00 |
$29,800.00 |
| Temporary employees |
$101,483.00 |
$122,464.24 |
| Terminal pay |
$1,500.00 |
$437.12 |
| Transportation-city veh fuel |
$57,390.00 |
$54,504.98 |
| Vacation pay |
$0.00 |
$131,231.76 |
| Valves |
$34,776.00 |
$41,970.47 |
| Welding supplies |
$3,208.00 |
$8,610.59 |
| |
$5,809,722.00 |
$4,958,899.03
|
|
|
| ENGINEERING SERVICES |
| Electrical Services |
| Administrative leave |
$0.00 |
$3,793.86 |
| Allowances/other pay |
$5,100.00 |
$4,912.00 |
| Awards and Recognition |
$592.00 |
$156.61 |
| Books-library |
$1,219.00 |
$16.98 |
| Building material |
$750.00 |
$145.40 |
| Call back time |
$20,600.00 |
$9,501.93 |
| Chemicals |
$979.00 |
$371.41 |
| Clothing/clothing material |
$12,153.00 |
$3,569.66 |
| Computer supplies |
$154.00 |
$118.98 |
| Const/repair material-other |
$695.00 |
$107.90 |
| Contribution to employees ret |
$101,585.00 |
$44,139.47 |
| Educational incentive pay |
$0.00 |
$4,257.11 |
| Elctrcal conductors-hardware |
$119.00 |
$0.00 |
| Elctrcal conductors-wire&cable |
$300.00 |
$26.58 |
| Electrical/lighting |
$2,499.00 |
$27,351.15 |
| FICA tax |
$73,441.00 |
$36,855.18 |
| Fleet-equip.preventative maint |
$38,816.00 |
$37,107.81 |
| Food/Ice |
$1,375.00 |
$202.58 |
| Fuses and fusing apparatus |
$60.00 |
$0.00 |
| Gasoline/oil/grease |
$153.00 |
$98.49 |
| Hardware/wire/steel |
$600.00 |
$3,081.21 |
| Holiday pay |
$0.00 |
$3,722.38 |
| Household/cleaning supplies |
$150.00 |
$127.53 |
| Identification |
$299.00 |
$300.50 |
| Insurance-health/life/dental |
$187,564.00 |
$72,501.31 |
| Medical/dental supplies |
$185.00 |
$0.00 |
| Medicare tax |
$17,172.00 |
$8,618.82 |
| Minor computer hardware |
$250.00 |
$106.50 |
| Office furnishings |
$4,590.00 |
$5,088.91 |
| Office supplies |
$3,999.00 |
$2,251.36 |
| On call hours |
$18,982.00 |
$4,523.50 |
| Other paid leave |
$5,000.00 |
$1,569.70 |
| Overtime |
$87,550.00 |
$53,680.43 |
| Paint/painting supplies |
$387.00 |
$128.97 |
| Parts for equipment |
$1,000.00 |
$3,328.20 |
| Personal holiday pay |
$0.00 |
$3,084.43 |
| Personnel savings |
($129,780.00) |
$0.00 |
| Phone allowance |
$8,723.00 |
$2,947.81 |
| Pipes and fittings |
$265.00 |
$402.77 |
| Priority mail/parcel services |
$100.00 |
$0.00 |
| Regular wages - full-time |
$1,170,374.00 |
$471,205.66 |
| Safety equipment |
$5,003.00 |
$1,341.96 |
| Services-hazardous mat disp |
$50.00 |
$0.00 |
| Services-other |
$1,248.00 |
$0.00 |
| Services-testing |
$3,000.00 |
$0.00 |
| Sick pay |
$0.00 |
$7,140.31 |
| Small tools/minor equipment |
$0.00 |
$198.00 |
| Software |
$1,999.00 |
$0.00 |
| Stability pay |
$8,976.00 |
$8,800.00 |
| Telephone-cellular phones |
$1,200.00 |
$0.00 |
| Temporary employees |
$0.00 |
$13,118.99 |
| Terminal pay |
$0.00 |
$7,021.87 |
| Transportation-city veh fuel |
$11,546.00 |
$8,516.55 |
| Vacation pay |
$0.00 |
$16,107.46 |
| Welding supplies |
$118.00 |
$301.32 |
| Wireless Communication-instal |
$800.00 |
$0.00 |
| |
$1,671,940.00 |
$871,949.55
|
|
| Facility Engineering |
| Administrative leave |
$0.00 |
$7,391.62 |
| Allowances/other pay |
$0.00 |
$1,987.50 |
| Awards and Recognition |
$569.00 |
$0.00 |
| Contribution to employees ret |
$125,916.00 |
$82,815.82 |
| Dept OH distribtd to indire |
$0.00 |
($124,134.78) |
| FICA tax |
$90,857.00 |
$60,159.30 |
| Fleet-equip.preventative maint |
$7,528.00 |
$11.16 |
| Food/Ice |
$1,500.00 |
$268.21 |
| Holiday pay |
$0.00 |
$51,654.61 |
| Indirect costs-FMC 74-4 |
$0.00 |
$124,134.78 |
| Insurance-health/life/dental |
$196,752.00 |
$117,411.63 |
| Maintenance-computer hardware |
$1,500.00 |
$0.00 |
| Medicare tax |
$21,492.00 |
$14,342.08 |
| Memberships |
$1,200.00 |
$300.40 |
| Mileage reimbursements |
$1,000.00 |
$380.92 |
| Minor computer hardware |
$200.00 |
$34.85 |
| Office furnishings |
$3,500.00 |
$52.24 |
| Office supplies |
$8,350.00 |
$407.86 |
| Overtime |
$750.00 |
$1,588.15 |
| Parental Leave |
$0.00 |
$23,630.40 |
| Personal holiday pay |
$0.00 |
$13,640.35 |
| Personnel savings |
($160,660.00) |
$0.00 |
| Phone allowance |
$3,510.00 |
$3,130.30 |
| Printing/binding/photo/repr |
$75.00 |
$18.75 |
| Professional registration |
$380.00 |
$50.00 |
| Regular wages - full-time |
$1,450,662.00 |
$756,594.68 |
| Reimbursement of CIP charge |
($416,738.00) |
($366,065.92) |
| Safety equipment |
$1,100.00 |
$793.76 |
| Sick pay |
$0.00 |
$40,677.84 |
| Small tools/minor equipment |
$500.00 |
$0.00 |
| Software |
$4,800.00 |
$0.00 |
| Stability pay |
$11,000.00 |
$11,700.00 |
| Temporary employees |
$17,472.00 |
$14,362.32 |
| Terminal pay |
$12,368.00 |
$17,376.00 |
| Vacation pay |
$0.00 |
$71,159.28 |
| |
$1,385,583.00 |
$925,874.11
|
|
| Instrumentation & Control |
| Administrative leave |
$0.00 |
$3,345.12 |
| Allowances/other pay |
$7,000.00 |
$5,624.78 |
| Awards and Recognition |
$569.00 |
$3,402.04 |
| Building material |
$200.00 |
$0.00 |
| Call back time |
$16,621.00 |
$14,254.33 |
| Chemicals |
$200.00 |
$216.50 |
| Clothing/clothing material |
$14,018.00 |
$7,494.64 |
| Const/repair material-other |
$100.00 |
$0.00 |
| Contribution to employees ret |
$87,062.00 |
$55,067.48 |
| Dept OH distribtd to indire |
$0.00 |
($169.37) |
| Elctrcal conductors-wire&cable |
$1,900.00 |
$96.20 |
| Electrical/lighting |
$1,854.00 |
$3,748.56 |
| FICA tax |
$66,501.00 |
$44,389.95 |
| Fleet-equip.preventative maint |
$22,995.00 |
$42,070.24 |
| Food/Ice |
$258.00 |
$314.64 |
| Gasoline/oil/grease |
$20.00 |
$0.00 |
| Holiday pay |
$0.00 |
$11,555.83 |
| Holidays worked |
$0.00 |
$306.98 |
| Household/cleaning supplies |
$200.00 |
$89.60 |
| Identification |
$567.00 |
$519.01 |
| Indirect costs-FMC 74-4 |
$0.00 |
$169.37 |
| Insurance-health/life/dental |
$182,318.00 |
$101,021.82 |
| Interdepartmental reimbursements |
($21,016.00) |
($447.04) |
| Medical/dental supplies |
$100.00 |
$0.00 |
| Medicare tax |
$15,551.00 |
$10,380.99 |
| Memberships |
$360.00 |
$269.47 |
| Mileage reimbursements |
$1,000.00 |
$521.81 |
| Minor computer hardware |
$773.00 |
$765.91 |
| Office supplies |
$1,133.00 |
$1,207.75 |
| On call hours |
$18,000.00 |
$3,401.50 |
| Other costs |
$2,112.00 |
$190.69 |
| Other paid leave |
$10,557.00 |
$1,541.31 |
| Overtime |
$40,000.00 |
$36,081.43 |
| Paint/painting supplies |
$50.00 |
$0.00 |
| Parts for equipment |
$50.00 |
$270.32 |
| Parts for vehicles |
$5,150.00 |
$5,341.84 |
| Personal holiday pay |
$0.00 |
$3,349.98 |
| Personnel savings |
($112,147.00) |
$0.00 |
| Phone allowance |
$11,560.00 |
$4,067.76 |
| Pipes and fittings |
$1,600.00 |
$1,369.48 |
| Priority mail/parcel services |
$40.00 |
$0.00 |
| Professional registration |
$885.00 |
$210.00 |
| Regular wages - full-time |
$1,003,073.00 |
$605,966.92 |
| Relays and relaying equipment |
$0.00 |
$233.06 |
| Safety equipment |
$22,824.00 |
$8,196.84 |
| Services-hazardous mat disp |
$155.00 |
$0.00 |
| Services-testing |
$5,000.00 |
$4,924.39 |
| Sick pay |
$0.00 |
$8,339.08 |
| Small tools/minor equipment |
$30,835.00 |
$12,811.07 |
| Software |
$2,000.00 |
$0.00 |
| Stability pay |
$4,628.00 |
$4,364.00 |
| Temporary employees |
$60,424.00 |
$46,212.16 |
| Terminal pay |
$0.00 |
$100.26 |
| Training-city wide |
$1,000.00 |
$272.00 |
| Transportation-city veh fuel |
$7,158.00 |
$6,160.10 |
| Vacation pay |
$0.00 |
$6,816.84 |
| |
$1,515,238.00 |
$1,066,437.64
|
|
| Pipeline CIP Project Delivery |
| Administrative leave |
$0.00 |
$6,934.79 |
| Allowances/other pay |
$0.00 |
$2,025.00 |
| Awards and Recognition |
$614.00 |
$2,119.01 |
| Contribution to employees ret |
$100,916.00 |
$66,797.61 |
| Dept OH distribtd to indire |
$0.00 |
($80,355.33) |
| Emergency leave |
$0.00 |
$2,108.80 |
| FICA tax |
$72,537.00 |
$51,307.26 |
| Food/Ice |
$1,000.00 |
$323.30 |
| Holiday pay |
$0.00 |
$41,740.24 |
| Holidays worked |
$0.00 |
$341.20 |
| Indirect costs-FMC 74-4 |
$0.00 |
$80,355.33 |
| Insurance-health/life/dental |
$163,960.00 |
$100,728.80 |
| Jury leave |
$0.00 |
$486.30 |
| Medicare tax |
$16,968.00 |
$11,999.75 |
| Memberships |
$500.00 |
$528.00 |
| Mileage reimbursements |
$1,000.00 |
$0.00 |
| Minor computer hardware |
$100.00 |
$146.96 |
| Office furnishings |
$2,500.00 |
$0.00 |
| Office supplies |
$1,000.00 |
$409.38 |
| Overtime |
$258.00 |
$286.38 |
| Parental Leave |
$0.00 |
$17,462.72 |
| Personal holiday pay |
$0.00 |
$7,514.10 |
| Personnel savings |
($128,929.00) |
$0.00 |
| Phone allowance |
$2,610.00 |
$1,284.32 |
| Printing/binding/photo/repr |
$250.00 |
$9.38 |
| Professional registration |
$200.00 |
$24.99 |
| Regular wages - full-time |
$1,162,600.00 |
$638,354.97 |
| Reimbursement of CIP charge |
($463,484.00) |
($235,944.86) |
| Safety equipment |
$200.00 |
$138.43 |
| Seminar/training fees |
$0.00 |
$153.40 |
| Sick pay |
$0.00 |
$28,592.96 |
| Stability pay |
$4,700.00 |
$3,500.00 |
| Temporary employees |
$60,000.00 |
$48,602.94 |
| Terminal pay |
$0.00 |
$6,737.13 |
| Vacation pay |
$0.00 |
$36,151.66 |
| |
$999,500.00 |
$840,864.92
|
|
| Pipeline Engineering and Operations Support |
| Accident pay |
$0.00 |
$1,060.44 |
| Administrative leave |
$0.00 |
$12,895.20 |
| Allowances/other pay |
$0.00 |
$3,190.87 |
| Awards and Recognition |
$1,456.00 |
$0.00 |
| Books-library |
$200.00 |
$0.00 |
| Building material |
$60.00 |
$0.00 |
| Call back time |
$14,000.00 |
$12,455.27 |
| Clothing/clothing material |
$250.00 |
$229.47 |
| Computer supplies |
$100.00 |
$0.00 |
| Contribution to employees ret |
$170,018.00 |
$111,783.18 |
| Dept OH distribtd to indire |
$0.00 |
($32,314.30) |
| Electrical/lighting |
$50.00 |
$0.00 |
| Emergency leave |
$0.00 |
$5,545.18 |
| FICA tax |
$128,907.00 |
$86,198.69 |
| Fleet-equip.preventative maint |
$22,867.00 |
$16,843.66 |
| Food/Ice |
$350.00 |
$407.70 |
| Holiday pay |
$0.00 |
$72,434.60 |
| Holidays worked |
$0.00 |
$517.14 |
| Household/cleaning supplies |
$20.00 |
$0.00 |
| Indirect costs-FMC 74-4 |
$0.00 |
$32,314.30 |
| Insurance-health/life/dental |
$286,930.00 |
$161,195.69 |
| Interdeptl-PW CPM charges |
$10,000.00 |
$4,422.69 |
| Jury leave |
$0.00 |
$353.20 |
| Maintenance-pipelines |
$1,050,224.00 |
$260,709.38 |
| Medical/dental supplies |
$50.00 |
$0.00 |
| Medicare tax |
$30,150.00 |
$20,436.87 |
| Memberships |
$125.00 |
$0.00 |
| Mileage reimbursements |
$1,900.00 |
$559.14 |
| Minor computer hardware |
$2,688.00 |
$3,315.72 |
| Office furnishings |
$250.00 |
$0.00 |
| Office supplies |
$1,650.00 |
$636.07 |
| On call hours |
$11,250.00 |
$7,062.00 |
| Other paid leave |
$0.00 |
$2,140.19 |
| Overtime |
$45,000.00 |
$34,905.01 |
| Personal holiday pay |
$0.00 |
$16,011.77 |
| Personnel savings |
($217,266.00) |
$0.00 |
| Phone allowance |
$10,590.00 |
$8,354.90 |
| Pipes and fittings |
$2,500.00 |
$2,875.61 |
| Printing/binding/photo/repr |
$200.00 |
$209.55 |
| Professional registration |
$631.00 |
$150.00 |
| Regular wages - full-time |
$1,958,669.00 |
$1,052,558.19 |
| Reimbursement of CIP charge |
($143,444.00) |
($90,861.35) |
| Safety equipment |
$1,300.00 |
$1,798.27 |
| Services-other |
$140,600.00 |
$0.00 |
| Sick pay |
$0.00 |
$46,858.75 |
| Small tools/minor equipment |
$1,850.00 |
$5,739.02 |
| Software |
$6,000.00 |
$5,452.66 |
| Stability pay |
$19,050.00 |
$15,200.00 |
| Temporary employees |
$90,810.00 |
$56,475.24 |
| Terminal pay |
$20,000.00 |
$0.00 |
| Transportation-city veh fuel |
$11,729.00 |
$5,749.97 |
| Vacation pay |
$0.00 |
$93,403.36 |
| |
$3,681,714.00 |
$2,039,273.30
|
|
| SCADA Engineering & Support |
| Administrative leave |
$0.00 |
$11,303.84 |
| Allowances/other pay |
$0.00 |
$3,375.00 |
| Awards and Recognition |
$410.00 |
$0.00 |
| Books-library |
$300.00 |
$0.00 |
| Contribution to employees ret |
$87,433.00 |
$66,170.11 |
| Dept OH distribtd to indire |
$0.00 |
($16,154.25) |
| Exception vacation |
$0.00 |
$255.68 |
| FICA tax |
$63,446.00 |
$47,218.92 |
| Food/Ice |
$1,500.00 |
$140.18 |
| Holiday pay |
$0.00 |
$52,701.16 |
| Holidays worked |
$0.00 |
$255.68 |
| Indirect costs-FMC 74-4 |
$0.00 |
$16,154.25 |
| Insurance-health/life/dental |
$147,564.00 |
$93,992.81 |
| Jury leave |
$0.00 |
$433.92 |
| Maintenance-computer hardware |
$30,000.00 |
$10,861.31 |
| Maintenance-computer software |
$195,000.00 |
$81,933.38 |
| Medicare tax |
$14,842.00 |
$11,100.97 |
| Memberships |
$400.00 |
$77.00 |
| Mileage reimbursements |
$700.00 |
$406.79 |
| Minor computer hardware |
$500.00 |
$491.83 |
| Office furnishings |
$1,000.00 |
$0.00 |
| Office supplies |
$1,500.00 |
$35.98 |
| Overtime |
$750.00 |
$206.38 |
| Parental Leave |
$0.00 |
$3,976.00 |
| Personal holiday pay |
$0.00 |
$11,735.28 |
| Personnel savings |
($111,670.00) |
$0.00 |
| Phone allowance |
$3,750.00 |
$3,552.79 |
| Printing/binding/photo/repr |
$50.00 |
$0.00 |
| Priority mail/parcel services |
$50.00 |
$6.97 |
| Professional registration |
$80.00 |
$50.00 |
| Regular wages - full-time |
$1,007,233.00 |
$613,113.93 |
| Reimbursement of CIP charge |
($9,630.00) |
($47,397.50) |
| Safety equipment |
$1,000.00 |
$109.13 |
| Sick pay |
$0.00 |
$25,698.70 |
| Small tools/minor equipment |
$800.00 |
$0.00 |
| Software |
$2,500.00 |
$1,796.81 |
| Stability pay |
$6,450.00 |
$6,450.00 |
| Temporary employees |
$5,824.00 |
$0.00 |
| Terminal pay |
$2,500.00 |
$0.00 |
| Training-city wide |
$1,500.00 |
$685.00 |
| Vacation pay |
$0.00 |
$56,623.91 |
| |
$1,455,782.00 |
$1,057,361.96
|
|
|
| ENVIRONMENTAL, PLANNING, AND DEVELOPMENT SERVICES |
| Environmental, Planning, and Development Support |
| Administrative leave |
$0.00 |
$815.68 |
| Allowances/other pay |
$0.00 |
$112.50 |
| Awards and Recognition |
$114.00 |
$0.00 |
| Books-library |
$500.00 |
$0.00 |
| Contribution to employees ret |
$22,726.00 |
$15,543.73 |
| FICA tax |
$15,415.00 |
$10,194.24 |
| Food/Ice |
$250.00 |
$512.05 |
| Holiday pay |
$0.00 |
$3,670.56 |
| Insurance-health/life/dental |
$32,792.00 |
$21,160.78 |
| Medicare tax |
$3,857.00 |
$2,647.78 |
| Memberships |
$500.00 |
$0.00 |
| Office supplies |
$250.00 |
$145.11 |
| Overtime |
$0.00 |
$28.86 |
| Personal holiday pay |
$0.00 |
$815.68 |
| Personnel savings |
($28,781.00) |
$0.00 |
| Phone allowance |
$1,470.00 |
$876.88 |
| Regular wages - full-time |
$261,814.00 |
$165,477.31 |
| Seminar/training fees |
$0.00 |
$49.87 |
| Sick pay |
$0.00 |
$3,747.03 |
| Software |
$250.00 |
$0.00 |
| Stability pay |
$2,700.00 |
$2,700.00 |
| Subscriptions |
$500.00 |
$0.00 |
| Vacation pay |
$0.00 |
$7,009.75 |
| |
$314,357.00 |
$235,507.81
|
|
| Infrastructure Management |
| Administrative leave |
$0.00 |
$5,185.40 |
| Allowances/other pay |
$0.00 |
$1,687.50 |
| Awards and Recognition |
$455.00 |
$0.00 |
| Bilingual Pay |
$0.00 |
$2.76 |
| Books-library |
$100.00 |
$0.00 |
| Computer supplies |
$1,900.00 |
$0.00 |
| Contribution to employees ret |
$86,799.00 |
$55,050.09 |
| Dept OH distribtd to indire |
$0.00 |
($284.97) |
| Educational incentive pay |
$0.00 |
$2.62 |
| Educational travel |
$0.00 |
$231.40 |
| FICA tax |
$65,793.00 |
$43,382.06 |
| Fleet-equip.preventative maint |
$3,809.00 |
$2,820.00 |
| Food/Ice |
$5,000.00 |
$976.59 |
| Holiday pay |
$0.00 |
$32,600.97 |
| Indirect costs-FMC 74-4 |
$0.00 |
$284.97 |
| Insurance-health/life/dental |
$163,960.00 |
$97,527.66 |
| Medicare tax |
$15,388.00 |
$10,287.74 |
| Memberships |
$175.00 |
$215.50 |
| Mileage reimbursements |
$50.00 |
$0.00 |
| Minor computer hardware |
$750.00 |
$0.00 |
| Miscellaneous expense |
$0.00 |
$162.04 |
| Office furnishings |
$3,000.00 |
$0.00 |
| Office supplies |
$1,750.00 |
$16.84 |
| Overtime |
$3,000.00 |
$709.42 |
| Parental Leave |
$0.00 |
$4,771.20 |
| Personal holiday pay |
$0.00 |
$8,749.20 |
| Personnel savings |
($111,200.00) |
$0.00 |
| Phone allowance |
$2,400.00 |
$1,698.94 |
| Professional registration |
$200.00 |
$0.00 |
| Regular wages - full-time |
$999,907.00 |
$518,573.11 |
| Reimbursement of CIP charge |
$0.00 |
($824.80) |
| Safety equipment |
$350.00 |
$0.00 |
| Seminar/training fees |
$0.00 |
$727.50 |
| Sick pay |
$0.00 |
$36,115.30 |
| Stability pay |
$9,150.00 |
$8,650.00 |
| Subscriptions |
$25.00 |
$0.00 |
| Temporary employees |
$49,600.00 |
$62,376.59 |
| Terminal pay |
$5,500.00 |
$0.00 |
| Training-city wide |
$1,000.00 |
$0.00 |
| Transportation-city veh fuel |
$0.00 |
$329.59 |
| Vacation pay |
$0.00 |
$39,992.42 |
| |
$1,308,861.00 |
$932,017.64
|
|
| Systems Planning |
| Administrative leave |
$0.00 |
$4,663.80 |
| Advertising/publication |
$37.00 |
$0.00 |
| Allowances/other pay |
$0.00 |
$2,227.50 |
| Awards and Recognition |
$501.00 |
$2,975.00 |
| Books-library |
$200.00 |
$0.00 |
| Consultant-others |
$475,000.00 |
$116,689.60 |
| Contribution to employees ret |
$119,685.00 |
$79,031.71 |
| Educational travel |
$0.00 |
$280.35 |
| FICA tax |
$89,334.00 |
$56,493.52 |
| Food/Ice |
$200.00 |
$406.73 |
| Government permits and fees |
$300.00 |
$112.50 |
| Holiday pay |
$0.00 |
$44,066.32 |
| Insurance-health/life/dental |
$208,229.00 |
$128,237.52 |
| Maintenance-computer software |
$48,889.00 |
$0.00 |
| Medicare tax |
$20,898.00 |
$13,429.58 |
| Memberships |
$100.00 |
$85.00 |
| Mileage reimbursements |
$2,153.00 |
$0.00 |
| Minor computer hardware |
$200.00 |
$0.00 |
| Office supplies |
$1,959.00 |
$1,162.76 |
| Overtime |
$500.00 |
$5,658.67 |
| Parental Leave |
$0.00 |
$60,608.60 |
| Personal holiday pay |
$0.00 |
$13,380.95 |
| Personnel savings |
($152,967.00) |
$0.00 |
| Phone allowance |
$3,063.00 |
$2,340.97 |
| Printing/binding/photo/repr |
$75.00 |
$0.00 |
| Priority mail/parcel services |
$12.00 |
$0.00 |
| Professional registration |
$200.00 |
$50.00 |
| Regular wages - full-time |
$1,378,811.00 |
$730,005.69 |
| Safety equipment |
$250.00 |
$57.50 |
| Services-other |
$82,000.00 |
$0.00 |
| Sick pay |
$0.00 |
$25,548.30 |
| Small tools/minor equipment |
$250.00 |
$0.00 |
| Software |
$50,000.00 |
$62,842.50 |
| Stability pay |
$6,485.00 |
$6,400.00 |
| Temporary employees |
$52,500.00 |
$0.00 |
| Vacation pay |
$0.00 |
$45,944.82 |
| |
$2,388,864.00 |
$1,402,699.89
|
|
| Utility Development Services |
| Administrative leave |
$0.00 |
$14,795.79 |
| Advertising/publication |
$1,000.00 |
$0.00 |
| Allowances/other pay |
$0.00 |
$3,675.00 |
| Awards and Recognition |
$910.00 |
$1,037.50 |
| Bilingual Pay |
$4,500.00 |
$4,154.57 |
| Books-library |
$1,200.00 |
$189.48 |
| Clothing/clothing material |
$500.00 |
$28.25 |
| Contribution to employees ret |
$176,462.00 |
$127,047.90 |
| Dept OH distribtd to indire |
$0.00 |
($12,233.67) |
| Educational travel |
$0.00 |
$652.53 |
| Emergency leave |
$0.00 |
$3,353.84 |
| FICA tax |
$132,478.00 |
$92,600.74 |
| Government permits and fees |
$400.00 |
$51.50 |
| Grant cost-support of other |
$45,000.00 |
$0.00 |
| Holiday pay |
$0.00 |
$85,806.45 |
| Holidays worked |
$0.00 |
$176.92 |
| Indirect costs-FMC 74-4 |
$0.00 |
$12,233.67 |
| Insurance-health/life/dental |
$311,524.00 |
$201,191.48 |
| Interdepartmental Charges |
$240,000.00 |
$0.00 |
| Interdepartmental reimbursements |
($113,470.00) |
$0.00 |
| Interdeptl-PW CPM charges |
$3,750.00 |
$0.00 |
| Laundry expense |
$1,000.00 |
$157.50 |
| Medicare tax |
$30,980.00 |
$21,655.19 |
| Memberships |
$2,000.00 |
$0.00 |
| Mileage reimbursements |
$500.00 |
$0.00 |
| Minor computer hardware |
$1,000.00 |
$412.84 |
| Office furnishings |
$500.00 |
$0.00 |
| Office supplies |
$4,000.00 |
$621.51 |
| Overtime |
$20,000.00 |
$11,542.38 |
| Parking costs |
$0.00 |
$19.50 |
| Personal holiday pay |
$0.00 |
$24,676.86 |
| Personnel savings |
($225,785.00) |
$0.00 |
| Phone allowance |
$4,890.00 |
$3,879.16 |
| Printing/binding/photo/repr |
$100.00 |
$0.00 |
| Professional registration |
$1,500.00 |
$304.96 |
| Regular wages - full-time |
$2,032,843.00 |
$1,184,602.35 |
| Reimbursement of CIP charge |
($14,206.00) |
($36,084.64) |
| Safety equipment |
$650.00 |
$58.50 |
| Seminar/training fees |
$0.00 |
$3,846.20 |
| Services-IT staffing |
$200,000.00 |
$95,135.27 |
| Services-other |
$1,000.00 |
$0.00 |
| Services-survey |
$1,500.00 |
$0.00 |
| Sick pay |
$0.00 |
$50,875.11 |
| Small tools/minor equipment |
$200.00 |
$0.00 |
| Software |
$10,000.00 |
$13,641.25 |
| Stability pay |
$17,850.00 |
$17,100.00 |
| Subscriptions |
$400.00 |
$85.00 |
| Temporary employees |
$76,440.00 |
$17,981.25 |
| Terminal pay |
$5,000.00 |
$0.00 |
| Training-city wide |
$0.00 |
$544.83 |
| Vacation pay |
$0.00 |
$116,049.88 |
| |
$2,976,616.00 |
$2,061,866.85
|
|
| Water Conservation |
| Administrative leave |
$0.00 |
$17,402.79 |
| Advertising/publication |
$13,000.00 |
$1,756.00 |
| Allowances/other pay |
$0.00 |
$4,056.00 |
| Awards and Recognition |
$1,001.00 |
$1,605.00 |
| Bilingual Pay |
$5,400.00 |
$3,946.68 |
| Books-library |
$500.00 |
$0.00 |
| Clothing/clothing material |
$1,700.00 |
$0.00 |
| Commercial Incentives-AWU |
$4,375,000.00 |
$94,135.96 |
| Comp time used |
$0.00 |
$175.46 |
| Contribution to employees ret |
$160,192.00 |
$116,037.82 |
| Educational travel |
$0.00 |
$1,487.76 |
| Educational/promotional |
$2,245.00 |
$2,025.89 |
| Exception vacation |
$0.00 |
$417.44 |
| Expense refunds |
($350,000.00) |
$0.00 |
| FICA tax |
$121,791.00 |
$91,083.76 |
| Fleet-equip.preventative maint |
$32,302.00 |
$14,100.00 |
| Food/Ice |
$500.00 |
$642.42 |
| Help Program-AWU |
$350,000.00 |
$293,443.20 |
| Holiday pay |
$0.00 |
$62,057.94 |
| Holidays worked |
$0.00 |
$1,789.27 |
| Household Efficiency-AWU |
$57,500.00 |
$4,899.47 |
| Insurance-health/life/dental |
$360,712.00 |
$235,221.26 |
| Irrigation Efficiency-AWU |
$28,885.00 |
$15,032.08 |
| Landscape Conversion Rebate-AWU |
$65,000.00 |
$48,602.47 |
| Medicare tax |
$28,484.00 |
$21,301.85 |
| Office supplies |
$5,400.00 |
$2,620.02 |
| Overtime |
$10,000.00 |
$22,350.89 |
| Parental Leave |
$0.00 |
$13,890.60 |
| Personal holiday pay |
$0.00 |
$15,391.22 |
| Personnel savings |
($205,660.00) |
$0.00 |
| Phone allowance |
$3,360.00 |
$2,862.16 |
| Pressure Reduction Valve Rebate-AWU |
$7,000.00 |
$750.00 |
| Printing/binding/photo/repr |
$500.00 |
$0.00 |
| Professional registration |
$3,500.00 |
$728.00 |
| Rainwater Harvesting Rebate-AWU |
$65,556.00 |
$42,243.00 |
| Regular wages - full-time |
$1,845,501.00 |
$1,128,312.65 |
| Safety equipment |
$300.00 |
$347.56 |
| Seminar/training fees |
$0.00 |
$338.62 |
| Services-Prepared Food and Catering |
$10,300.00 |
$4,716.00 |
| Services-other |
$65,000.00 |
$0.00 |
| Shift differential |
$0.00 |
$631.97 |
| Sick pay |
$0.00 |
$42,131.07 |
| Small tools/minor equipment |
$4,000.00 |
$13,081.74 |
| Software |
$250,000.00 |
$0.00 |
| Stability pay |
$14,400.00 |
$16,000.00 |
| Subscriptions |
$500.00 |
$121.05 |
| Temporary employees |
$95,745.00 |
$102,152.00 |
| Training-city wide |
$0.00 |
$3,701.50 |
| Transportation-city veh fuel |
$2,720.00 |
$2,266.14 |
| Vacation pay |
$0.00 |
$80,509.00 |
| Water Services Interlocal |
$900,000.00 |
$638,001.00 |
| |
$8,332,334.00 |
$3,164,366.71
|
|
| Wildland Conservation |
| Administrative leave |
$0.00 |
$11,376.62 |
| Advertising/publication |
$16,500.00 |
$1,286.50 |
| Agricultural/horticultural |
$75,000.00 |
$52,250.77 |
| Allowances/other pay |
$0.00 |
$5,250.00 |
| Awards and Recognition |
$1,274.00 |
$875.00 |
| Bilingual Pay |
$0.00 |
$1,315.56 |
| Books-library |
$994.00 |
$135.45 |
| Building material |
$3,728.00 |
$1,924.93 |
| Cement/concrete |
$600.00 |
$0.00 |
| Chemicals |
$500.00 |
$336.95 |
| Clothing/clothing material |
$6,250.00 |
$2,569.72 |
| Computer supplies |
$1,000.00 |
$69.50 |
| Const/repair material-other |
$3,182.00 |
$121.05 |
| Consultant-others |
$500.00 |
$0.00 |
| Contribution to employees ret |
$199,038.00 |
$141,218.97 |
| Drainage fee expense |
$13,500.00 |
$5,803.52 |
| Educational travel |
$0.00 |
$4,325.30 |
| Educational/promotional |
$17,500.00 |
$9,251.72 |
| Elctrcal conductors-wire&cable |
$144.00 |
$18.72 |
| Electric services |
$20,000.00 |
$14,117.91 |
| Electrical/lighting |
$1,700.00 |
$663.07 |
| Emergency leave |
$0.00 |
$3,212.80 |
| Expense refunds |
($73,823.00) |
($41,592.85) |
| FICA tax |
$164,020.00 |
$116,378.58 |
| Fleet-equip.preventative maint |
$189,796.00 |
$125,359.44 |
| Food/Ice |
$2,900.00 |
$1,480.97 |
| Food/storage for animals |
$2,500.00 |
$876.70 |
| Freight |
$100.00 |
$0.00 |
| Garbage/refuse collection |
$1,000.00 |
$0.00 |
| Gasoline/oil/grease |
$100.00 |
$269.84 |
| Hardware/wire/steel |
$2,000.00 |
$2,474.39 |
| Holiday pay |
$0.00 |
$77,006.60 |
| Holidays worked |
$0.00 |
$66.18 |
| Household/cleaning supplies |
$1,000.00 |
$1,625.49 |
| Improvements to Grounds |
$180,000.00 |
$47,302.39 |
| Insurance-health/life/dental |
$459,088.00 |
$282,517.76 |
| Interdepartmental Charges |
$5,000.00 |
$0.00 |
| Interdepartmental reimbursements |
($21,000.00) |
($24,170.22) |
| Jury leave |
$0.00 |
$105.65 |
| Maintenance-buildings |
$14,700.00 |
$3,904.55 |
| Maintenance-grounds |
$54,000.00 |
$1,316.25 |
| Maintenance-other equipment |
$120.00 |
$545.00 |
| Medical/dental supplies |
$92.00 |
$559.09 |
| Medicare tax |
$38,364.00 |
$27,217.58 |
| Memberships |
$1,400.00 |
$1,097.00 |
| Mileage reimbursements |
$0.00 |
$30.69 |
| Minor computer hardware |
$1,220.00 |
$194.67 |
| Office supplies |
$2,500.00 |
$2,744.86 |
| Overtime |
$6,000.00 |
$4,363.63 |
| Paint/painting supplies |
$200.00 |
$496.24 |
| Parental Leave |
$0.00 |
$25,924.80 |
| Parts for equipment |
$2,900.00 |
$1,191.49 |
| Parts for vehicles |
$2,530.00 |
$653.57 |
| Personal holiday pay |
$0.00 |
$23,525.59 |
| Personnel savings |
($256,632.00) |
$0.00 |
| Phone allowance |
$19,500.00 |
$15,543.83 |
| Photographic |
$2,000.00 |
$0.00 |
| Pipes and fittings |
$2,110.00 |
$1,461.13 |
| Police supplies |
$300.00 |
$179.80 |
| Postage |
$2,650.00 |
$490.45 |
| Printing/binding/photo/repr |
$2,500.00 |
$585.99 |
| Professional registration |
$1,100.00 |
$1,188.19 |
| Regular wages - full-time |
$2,293,056.00 |
$1,372,285.65 |
| Rental-heavy equipment |
$1,000.00 |
$3,016.44 |
| Rental-other equipment |
$15,500.00 |
$3,705.80 |
| Rental-vehicles/buses |
$4,000.00 |
$0.00 |
| Safety equipment |
$14,472.00 |
$17,369.87 |
| Sand/gravel/stone |
$100.00 |
$31.16 |
| Security equipment |
$20,000.00 |
$7,302.34 |
| Seminar/training fees |
$0.00 |
$3,907.52 |
| Services-Prepared Food and Catering |
$6,500.00 |
$1,525.42 |
| Services-court costs |
$550.00 |
$39.00 |
| Services-other |
$1,460,951.00 |
$646,030.04 |
| Services-survey |
$14,872.00 |
$0.00 |
| Services-testing |
$13,000.00 |
$0.00 |
| Sick pay |
$0.00 |
$47,454.36 |
| Small tools/minor equipment |
$52,000.00 |
$30,199.32 |
| Software |
$900.00 |
$0.00 |
| Stability pay |
$21,400.00 |
$18,400.00 |
| Street/traff signs/mrkr/pos |
$1,962.00 |
$0.00 |
| Temporary employees |
$311,292.00 |
$229,200.96 |
| Training-city wide |
$0.00 |
$3,225.00 |
| Transportation-city veh fuel |
$17,095.00 |
$11,692.67 |
| Vacation pay |
$0.00 |
$95,699.82 |
| Valves |
$0.00 |
$59.00 |
| Water service |
$6,000.00 |
$1,669.32 |
| Welding supplies |
$1,600.00 |
$0.00 |
| |
$5,427,895.00 |
$3,451,853.07
|
|
|
| OPERATIONS |
| Environmental Engineering & Technical Services |
| Administrative leave |
$0.00 |
$36,292.78 |
| Advertising/publication |
$3,182.00 |
$1,165.26 |
| Allowances/other pay |
$11,521.00 |
$11,400.00 |
| Awards and Recognition |
$1,903.00 |
$731.23 |
| Bilingual Pay |
$7,320.00 |
$1,870.85 |
| Books-library |
$1,370.00 |
$117.54 |
| Building material |
$106.00 |
$0.00 |
| Chemicals |
$111,125.00 |
$76,492.94 |
| Clothing/clothing material |
$2,911.00 |
$476.34 |
| Computer supplies |
$610.00 |
$0.00 |
| Contribution to employees ret |
$296,857.00 |
$208,604.06 |
| Educational incentive pay |
$6,000.00 |
$6,784.92 |
| Educational travel |
$0.00 |
$2,329.70 |
| Educational/promotional |
$7,700.00 |
$396.11 |
| Electric services |
$18,000.00 |
$8,094.40 |
| Electrical/lighting |
$181.00 |
$0.00 |
| Emergency leave |
$0.00 |
$3,568.84 |
| FICA tax |
$220,042.00 |
$151,928.26 |
| Fleet-equip.preventative maint |
$41,360.00 |
$33,069.84 |
| Food/Ice |
$1,220.00 |
$655.21 |
| Gas/heating fuels |
$2,000.00 |
$1,810.25 |
| Government permits and fees |
$640,487.00 |
$640,186.79 |
| Holiday pay |
$0.00 |
$117,316.89 |
| Holidays worked |
$3,500.00 |
$1,882.77 |
| Household/cleaning supplies |
$160.00 |
$0.00 |
| Insurance-health/life/dental |
$606,652.00 |
$376,693.49 |
| Interdepartmental reimbursements |
$0.00 |
($389.40) |
| Interdeptl-PW CPM charges |
$6,000.00 |
$0.00 |
| Jury leave |
$0.00 |
$332.08 |
| Maintenance-buildings |
$1,500.00 |
$1,616.92 |
| Maintenance-computer hardware |
$250.00 |
$0.00 |
| Maintenance-computer software |
$35,000.00 |
$24,440.00 |
| Maintenance-other equipment |
$42,686.00 |
$34,945.57 |
| Medical/dental supplies |
$460.00 |
$0.00 |
| Medicare tax |
$51,461.00 |
$35,787.44 |
| Memberships |
$3,148.00 |
$2,334.00 |
| Mileage reimbursements |
$2,230.00 |
$937.61 |
| Minor computer hardware |
$1,835.00 |
$143.88 |
| Office furnishings |
$860.00 |
$0.00 |
| Office supplies |
$9,723.00 |
$2,086.13 |
| Overtime |
$53,281.00 |
$28,609.38 |
| Paint/painting supplies |
$91.00 |
$0.00 |
| Parental Leave |
$0.00 |
$29,136.30 |
| Personal holiday pay |
$0.00 |
$27,716.92 |
| Personnel savings |
($378,850.00) |
$0.00 |
| Phone allowance |
$29,410.00 |
$16,302.97 |
| Photographic |
$160.00 |
$0.00 |
| Pipes and fittings |
$820.00 |
$0.00 |
| Printing/binding/photo/repr |
$3,782.00 |
$2,260.51 |
| Priority mail/parcel services |
$5,160.00 |
$3,962.91 |
| Professional registration |
$3,286.00 |
$2,042.00 |
| Raw water - purchased |
$637,700.00 |
$0.00 |
| Regular wages - full-time |
$3,419,964.00 |
$1,999,696.01 |
| Rental-real estate-office |
$210,000.00 |
$143,774.58 |
| Rental-vehicles/buses |
$1,000.00 |
$0.00 |
| Safety equipment |
$5,184.00 |
$2,753.69 |
| Seminar/training fees |
$0.00 |
$2,570.00 |
| Services-appraisal |
$0.00 |
$3,500.00 |
| Services-engineering |
$5,000.00 |
$0.00 |
| Services-hazardous mat disp |
$3,055.00 |
$1,667.94 |
| Services-other |
$7,800.00 |
$4,039.83 |
| Services-testing |
$22,300.00 |
$11,294.37 |
| Sick pay |
$0.00 |
$71,149.87 |
| Small tools/minor equipment |
$98,909.00 |
$52,659.53 |
| Software |
$12,866.00 |
$504.06 |
| Stability pay |
$23,600.00 |
$22,900.00 |
| Subscriptions |
$350.00 |
$153.34 |
| Temporary employees |
$61,432.00 |
$24,939.04 |
| Terminal pay |
$38,500.00 |
$4,999.45 |
| Training-city wide |
$5,000.00 |
$0.00 |
| Transportation-city veh fuel |
$9,721.00 |
$8,433.25 |
| Vacation pay |
$0.00 |
$144,179.29 |
| Welding supplies |
$2,000.00 |
$360.89 |
| |
$6,420,881.00 |
$4,393,708.83
|
|
| Operations Support |
| Administrative leave |
$0.00 |
$13,994.83 |
| Allowances/other pay |
$0.00 |
$1,125.00 |
| Awards and Recognition |
$842.00 |
$382.17 |
| Books-library |
$875.00 |
$132.38 |
| Clothing/clothing material |
$4,290.00 |
$424.47 |
| Computer supplies |
$75.00 |
$54.28 |
| Contribution to employees ret |
$148,974.00 |
$99,441.75 |
| Dept OH distribtd to indire |
$0.00 |
($27.97) |
| Educational travel |
$0.00 |
$200.52 |
| Educational/promotional |
$3,000.00 |
$220.19 |
| Emergency leave |
$0.00 |
$2,233.68 |
| Exception vacation |
$0.00 |
$65.43 |
| FICA tax |
$112,678.00 |
$72,000.75 |
| Food/Ice |
$650.00 |
$206.52 |
| Government permits and fees |
$1,000.00 |
$0.00 |
| Holiday pay |
$0.00 |
$67,277.22 |
| Holidays worked |
$0.00 |
$74.93 |
| Indirect costs-FMC 74-4 |
$0.00 |
$27.97 |
| Insurance-health/life/dental |
$327,920.00 |
$194,154.82 |
| Maintenance-other equipment |
$3,000.00 |
$0.00 |
| Medical/dental supplies |
$50.00 |
$0.00 |
| Medicare tax |
$26,420.00 |
$17,108.53 |
| Memberships |
$200.00 |
$0.00 |
| Mileage reimbursements |
$500.00 |
$218.46 |
| Minor computer hardware |
$2,350.00 |
$246.31 |
| Miscellaneous expense |
$500.00 |
$121.30 |
| Office furnishings |
$5,358.00 |
$210.16 |
| Office supplies |
$6,022.40 |
$879.33 |
| Overtime |
$7,159.00 |
$1,352.64 |
| Parental Leave |
$0.00 |
$2,518.34 |
| Parking costs |
$10.00 |
$0.00 |
| Personal holiday pay |
$0.00 |
$14,684.04 |
| Personnel savings |
($192,048.00) |
$0.00 |
| Phone allowance |
$7,980.00 |
$6,131.45 |
| Postage |
$50.00 |
$145.01 |
| Printing/binding/photo/repr |
$100.00 |
$2.00 |
| Professional registration |
$250.00 |
$50.00 |
| Regular wages - full-time |
$1,716,258.00 |
$961,899.65 |
| Reimbursement of CIP charge |
$0.00 |
($85.13) |
| Rental-other equipment |
$5,490.00 |
$0.00 |
| Safety equipment |
$350.00 |
$1,065.39 |
| Seminar/training fees |
$0.00 |
$75.00 |
| Services-IT Installations |
$431.60 |
$0.00 |
| Services-other |
$515,000.00 |
$0.00 |
| Sick pay |
$0.00 |
$34,677.07 |
| Small tools/minor equipment |
$2,503.00 |
$362.83 |
| Software |
$750.00 |
$0.00 |
| Stability pay |
$9,850.00 |
$10,250.00 |
| Temporary employees |
$87,360.00 |
$24,534.59 |
| Terminal pay |
$0.00 |
$9,227.99 |
| Training-city wide |
$2,000.00 |
$239.46 |
| Vacation pay |
$0.00 |
$70,767.54 |
| |
$2,808,198.00 |
$1,608,670.90
|
|
| Water Distribution Operations |
| Accident pay |
$0.00 |
$136,969.79 |
| Administrative leave |
$0.00 |
$82,134.32 |
| Agricultural/horticultural |
$3,072.00 |
$3,882.64 |
| Allowances/other pay |
$36,838.00 |
$104,458.45 |
| Asphalt |
$101,327.00 |
$107,558.45 |
| Awards and Recognition |
$6,677.00 |
$42,699.46 |
| Bilingual Pay |
$24,300.00 |
$18,110.75 |
| Books-library |
$520.00 |
$0.00 |
| Building material |
$12,375.00 |
$10,009.40 |
| Call back time |
$628,627.00 |
$817,081.49 |
| Cement/concrete |
$63,455.00 |
$39,362.47 |
| Chemicals |
$31,201.00 |
$62,297.87 |
| Clothing/clothing material |
$137,359.00 |
$83,610.58 |
| Comp time used |
$0.00 |
$251.10 |
| Computer supplies |
$12,519.00 |
$1,289.46 |
| Const/repair material-other |
$3,111.00 |
$1,289.63 |
| Consulting-information technology |
$120,686.00 |
$61,286.43 |
| Contribution to employees ret |
$1,106,510.00 |
$763,852.90 |
| Dept OH distribtd to indire |
$0.00 |
($245,448.73) |
| Dietary hardware |
$708.00 |
$2,041.17 |
| Drainage fee expense |
$56,208.00 |
$32,235.70 |
| Educational incentive pay |
$27,884.00 |
$51,004.65 |
| Educational travel |
$0.00 |
$1,656.59 |
| Educational/promotional |
$157.00 |
$0.00 |
| Elctrcal conductors-hardware |
$644.00 |
$0.00 |
| Elctrcal conductors-wire&cable |
$6,075.00 |
$1,934.37 |
| Electric services |
$2,711,262.00 |
$1,949,112.34 |
| Electrical/lighting |
$116,179.00 |
$111,896.78 |
| Emergency leave |
$0.00 |
$13,730.04 |
| Exception vacation |
$0.00 |
$1,395.10 |
| FICA tax |
$824,319.00 |
$776,576.83 |
| Fleet-equip.preventative maint |
$1,989,027.00 |
$1,236,133.89 |
| Food/Ice |
$24,829.00 |
$24,518.38 |
| Freight |
$9,194.00 |
$279.16 |
| Fuses and fusing apparatus |
$500.00 |
$0.00 |
| Garbage/refuse collection |
$15,279.00 |
$4,620.18 |
| Gas/heating fuels |
$7,635.00 |
$5,357.87 |
| Gasoline/oil/grease |
$22,484.00 |
$15,785.71 |
| Government permits and fees |
$354,600.00 |
$336,182.15 |
| Hardware/wire/steel |
$68,959.00 |
$25,468.45 |
| Holiday pay |
$0.00 |
$377,041.98 |
| Holidays worked |
$16,332.00 |
$30,484.06 |
| Household/cleaning supplies |
$19,552.00 |
$13,701.54 |
| Identification |
$0.00 |
$1,642.33 |
| Indirect costs-FMC 74-4 |
$0.00 |
$245,448.73 |
| Insurance-health/life/dental |
$2,869,118.00 |
$1,913,612.67 |
| Interdepartmental Charges |
$19,572.00 |
$25,989.78 |
| Interdepartmental reimbursements |
($103,820.00) |
($4,079.44) |
| Intradepartmental reimbursemnt |
$0.00 |
($8,041.30) |
| Intradeptl charges |
$0.00 |
$1,954.97 |
| Intradeptl chgs-street cut rpr |
$7,000,000.00 |
$4,692,537.72 |
| Jury leave |
$0.00 |
$2,213.73 |
| Maintenance-buildings |
$11,635.00 |
$1,630.39 |
| Maintenance-computer software |
$90,960.00 |
$61,373.40 |
| Maintenance-electric motors |
$40,000.00 |
$2,000.36 |
| Maintenance-grounds |
$65,000.00 |
$15,127.90 |
| Maintenance-hydraulic equipmnt |
$46,007.00 |
$0.00 |
| Maintenance-other equipment |
$18,650.00 |
$6,221.40 |
| Maintenance-pipelines |
$235,000.00 |
$23,000.00 |
| Medical/dental supplies |
$9,588.00 |
$1,439.75 |
| Medicare tax |
$192,796.00 |
$182,098.47 |
| Memberships |
$2,860.00 |
$50.00 |
| Meter parts |
$0.00 |
$46.66 |
| Meters |
$191.00 |
$7,738.22 |
| Mileage reimbursements |
$900.00 |
$0.00 |
| Minor communications equipment |
$69,031.00 |
$13,651.37 |
| Minor computer hardware |
$35,649.00 |
$3,696.09 |
| Miscellaneous expense |
$3,000.00 |
$349.43 |
| Office furnishings |
$15,600.00 |
$30,746.47 |
| Office supplies |
$28,035.00 |
$28,159.09 |
| On call hours |
$219,119.00 |
$136,789.80 |
| Other Equipment |
$115,505.00 |
$27,920.00 |
| Other paid leave |
$0.00 |
$200,254.40 |
| Overtime |
$3,580,459.00 |
$2,828,163.22 |
| Paint/painting supplies |
$20,466.00 |
$16,590.64 |
| Parental Leave |
$0.00 |
$85,241.32 |
| Parts for equipment |
$172,170.00 |
$87,788.03 |
| Parts for vehicles |
$18,534.00 |
$26,518.74 |
| Personal holiday pay |
$0.00 |
$83,266.01 |
| Personnel savings |
($1,415,227.00) |
$0.00 |
| Phone allowance |
$21,448.00 |
$17,691.39 |
| Pipes and fittings |
$2,359,076.00 |
$2,018,007.72 |
| Postage |
$27.00 |
$0.00 |
| Printing/binding/photo/repr |
$1,486.00 |
$1,377.91 |
| Priority mail/parcel services |
$126.00 |
$74.87 |
| Professional registration |
$18,697.00 |
$48,722.21 |
| Pull boxes,svc boxes,manholes |
$58,500.00 |
$132,996.86 |
| Regular wages - full-time |
$12,747,491.00 |
$6,668,024.09 |
| Reimbursement of CIP charge |
($719,974.00) |
($751,558.82) |
| Relays and relaying equipment |
$7,039.00 |
$0.00 |
| Rental-heavy equipment |
$5,000.00 |
$0.00 |
| Rental-other equipment |
$106,976.00 |
$14,270.07 |
| Rental-vehicles/buses |
$150.00 |
$0.00 |
| Safety equipment |
$254,806.00 |
$229,980.82 |
| Sand/gravel/stone |
$866,870.00 |
$478,830.55 |
| Security equipment |
$7,000.00 |
$9,520.39 |
| Seminar/training fees |
$0.00 |
$7,390.55 |
| Services-Software as a Service |
$3,470.00 |
$0.00 |
| Services-construction contr |
$9,500.00 |
$0.00 |
| Services-hazardous mat disp |
$6,303.00 |
$0.00 |
| Services-inspection |
$3,000.00 |
$0.00 |
| Services-other |
$3,400,408.00 |
$1,149,739.05 |
| Shift differential |
$3,300.00 |
$17,847.12 |
| Sick pay |
$0.00 |
$339,902.33 |
| Small electric motors-water ut |
$5,400.00 |
$902.72 |
| Small tools/minor equipment |
$513,248.00 |
$523,988.25 |
| Software |
$4,698.00 |
$3,695.99 |
| Stability pay |
$120,455.00 |
$113,005.00 |
| Street/traff signs/mrkr/pos |
$18,691.00 |
$2,068.00 |
| Telephone-base cost |
$60,126.00 |
$46,688.67 |
| Telephone-cellular phones |
$56,500.00 |
$9,394.23 |
| Temporary employees |
$382,104.00 |
$353,007.17 |
| Terminal pay |
$52,000.00 |
$65,265.53 |
| Training-city wide |
$1,125.00 |
$0.00 |
| Transportation-city veh fuel |
$642,695.00 |
$368,394.83 |
| Vacation pay |
$0.00 |
$464,011.53 |
| Valves |
$532,191.00 |
$360,771.57 |
| Welding supplies |
$3,292.00 |
$3,186.98 |
| Wireless Communication-instal |
$59,500.00 |
$569.00 |
| |
$43,533,926.00 |
$30,540,760.33
|
|
| Water Treatment Operations |
| Accident pay |
$0.00 |
$7,120.78 |
| Administrative leave |
$0.00 |
$72,956.90 |
| Allowances/other pay |
$62,730.00 |
$44,070.00 |
| Awards and Recognition |
$4,960.00 |
$33,103.97 |
| Building material |
$6,500.00 |
$1,986.00 |
| Call back time |
$31,900.00 |
$32,717.32 |
| Chemicals |
$15,089,919.00 |
$9,487,450.95 |
| Clothing/clothing material |
$48,680.00 |
$32,092.51 |
| Computer supplies |
$980.00 |
$1,361.43 |
| Contribution to employees ret |
$671,966.00 |
$463,645.34 |
| Dietary hardware |
$250.00 |
$0.00 |
| Drainage fee expense |
$35,930.00 |
$28,393.29 |
| Educational incentive pay |
$48,920.00 |
$44,865.85 |
| Elctrcal conductors-wire&cable |
$2,000.00 |
$754.67 |
| Electric services |
$8,708,997.00 |
$5,347,126.16 |
| Electrical switchgear |
$500.00 |
$0.00 |
| Electrical/lighting |
$58,850.00 |
$64,012.81 |
| Emergency leave |
$0.00 |
$7,742.30 |
| Exception vacation |
$0.00 |
$4,662.61 |
| FICA tax |
$496,923.00 |
$396,148.11 |
| Fleet-equip. vehicle/equipment modification |
$0.00 |
$4,613.03 |
| Fleet-equip.preventative maint |
$540,298.00 |
$333,319.04 |
| Food/Ice |
$3,400.00 |
$3,932.74 |
| Freight |
$16,000.00 |
$39.35 |
| Fuses and fusing apparatus |
$200.00 |
$6.97 |
| Garbage/refuse collection |
$1,000.00 |
$309.60 |
| Gasoline/oil/grease |
$152,500.00 |
$140,188.15 |
| Government permits and fees |
$1,677.00 |
$0.00 |
| Hardware/wire/steel |
$15,000.00 |
$20,461.00 |
| Holiday pay |
$0.00 |
$246,336.15 |
| Holidays worked |
$81,000.00 |
$79,038.80 |
| Household/cleaning supplies |
$9,592.00 |
$4,701.12 |
| Identification |
$0.00 |
$182.82 |
| Insurance-health/life/dental |
$1,787,164.00 |
$1,141,447.56 |
| Jury leave |
$0.00 |
$862.71 |
| Maintenance-buildings |
$6,000.00 |
$751.94 |
| Maintenance-computer software |
$46,000.00 |
$42,597.27 |
| Maintenance-electric motors |
$31,120.00 |
$0.00 |
| Maintenance-grounds |
$2,000.00 |
$2,794.85 |
| Maintenance-other equipment |
$176,800.00 |
$99,146.00 |
| Medical/dental supplies |
$2,100.00 |
$1,045.12 |
| Medicare tax |
$116,226.00 |
$92,647.51 |
| Mileage reimbursements |
$1,250.00 |
$0.00 |
| Military leave |
$0.00 |
$4,258.56 |
| Minor computer hardware |
$288,088.00 |
$20,863.52 |
| Office furnishings |
$5,000.00 |
$450.67 |
| Office supplies |
$10,795.00 |
$9,188.71 |
| On call hours |
$39,020.00 |
$26,703.50 |
| Other Equipment |
$901,200.00 |
$128,327.82 |
| Overtime |
$1,079,319.00 |
$764,391.15 |
| Paint/painting supplies |
$2,400.00 |
$4,823.99 |
| Parental Leave |
$0.00 |
$35,282.40 |
| Parts for equipment |
$1,445,862.00 |
$736,226.73 |
| Personal holiday pay |
$0.00 |
$61,526.67 |
| Personnel savings |
($861,429.00) |
$0.00 |
| Phone allowance |
$31,740.00 |
$16,219.26 |
| Pipes and fittings |
$96,339.00 |
$84,970.91 |
| Postage |
$100.00 |
$0.00 |
| Priority mail/parcel services |
$2,250.00 |
$402.55 |
| Professional registration |
$11,876.00 |
$8,831.96 |
| Regular wages - full-time |
$7,741,350.00 |
$4,422,743.36 |
| Rental-other equipment |
$46,000.00 |
$6,488.32 |
| Safety equipment |
$96,560.00 |
$104,431.94 |
| Sand/gravel/stone |
$68,200.00 |
$64,605.61 |
| Security equipment |
$30,000.00 |
$1,651.66 |
| Seminar/training fees |
$0.00 |
$13,129.92 |
| Services-IT Installations |
$0.00 |
$2,044.00 |
| Services-environmnt assessment |
$15,394.00 |
$10,821.75 |
| Services-hazardous mat disp |
$10,660.00 |
$0.00 |
| Services-other |
$1,710,127.00 |
$1,112,277.77 |
| Shift differential |
$50,200.00 |
$38,591.61 |
| Sick pay |
$0.00 |
$207,062.32 |
| Small electric motors-water ut |
$4,500.00 |
$0.00 |
| Small tools/minor equipment |
$255,677.00 |
$152,088.93 |
| Stability pay |
$51,200.00 |
$46,300.00 |
| Temporary employees |
$201,121.00 |
$88,935.92 |
| Terminal pay |
$1,000.00 |
$14,082.43 |
| Transportation-city veh fuel |
$200,317.00 |
$157,902.05 |
| Vacation pay |
$0.00 |
$265,296.28 |
| Valves |
$94,926.00 |
$152,950.40 |
| Water service |
$56,000.00 |
$20,475.58 |
| Welding supplies |
$6,540.00 |
$6,751.60 |
| |
$41,951,664.00 |
$27,075,732.58
|
|
|
| OTHER UTILITY PROGRAM REQUIREMENTS |
| Other Utility Program Requirements |
| Arbitrage rebate-admin exp |
$14,446.00 |
$7,963.25 |
| Bad Debt Expense |
$958,938.00 |
$422,265.44 |
| Bond issue costs |
$146,700.00 |
$35,162.80 |
| Bond/Theft/Prof Liab Insurance |
$6,000.00 |
$5,812.85 |
| Claims-auto liability |
$70,000.00 |
$51,818.37 |
| Claims-general liability |
$50,000.00 |
$11,643.36 |
| Commercial paper admin exp |
$591,920.00 |
$610,447.93 |
| Consultant-financial |
$125,000.00 |
$12,816.88 |
| Consulting-information technology |
$11,250.00 |
$0.00 |
| FICA tax |
$236.00 |
$0.00 |
| Federal unemployment tax co |
$17,500.00 |
$7,696.50 |
| Fire/Extend Coverage Insurance |
$2,048,320.00 |
$1,881,687.10 |
| Fleet-equip. vehicle/equipment modification |
$30,000.00 |
$0.00 |
| Garbage/refuse collection |
$50,000.00 |
$44,323.08 |
| General Liability Insurance |
$3,000.00 |
$0.00 |
| Government permits and fees |
$20,000.00 |
$0.00 |
| Grants to subrecipients |
$0.00 |
$13,612.38 |
| Interdepartmental Charges |
$1,669,226.00 |
$1,625,000.00 |
| Legal claims/damages |
$150,000.00 |
$151,000.00 |
| Medicare tax |
$55.00 |
$0.00 |
| Miscellaneous expense |
$0.00 |
$1,386.00 |
| Printing/binding/photo/repr |
$600.00 |
$0.00 |
| Raw water - purchased |
$0.00 |
$2,429.13 |
| Rental-real estate-office |
$264,094.00 |
$132,048.00 |
| Services-Credit Card Fees |
$300,000.00 |
$60,754.86 |
| Services-court costs |
$0.00 |
$11,323.36 |
| Services-legal fees |
$175,000.00 |
$592.25 |
| Services-other |
$1,443,703.00 |
$0.00 |
| Software |
$61,500.00 |
$72,750.00 |
| Temporary employees |
$3,814.00 |
$0.00 |
| Util rev bnd commission exp |
$3,520.00 |
$2,770.00 |
| Wireless Communications-maint |
$51,543.00 |
$0.00 |
| |
$8,266,365.00 |
$5,165,303.54
|
|
|
| SUPPORT SERVICES |
| Departmental Support Services |
| Administrative leave |
$0.00 |
$94,074.54 |
| Allowances/other pay |
$0.00 |
$17,165.38 |
| Awards and Recognition |
$20,161.00 |
$8,686.70 |
| Bilingual Pay |
$4,500.00 |
$3,546.49 |
| Boiler equipment |
$600.00 |
($23.46) |
| Books-library |
$32,090.00 |
$3,816.99 |
| Building material |
$15,475.00 |
$5,249.19 |
| Call back time |
$0.00 |
$3,618.96 |
| Chemicals |
$5,900.00 |
$3,590.30 |
| Clothing/clothing material |
$24,150.00 |
$11,382.23 |
| Comp time used |
$0.00 |
$1,018.75 |
| Const/repair material-other |
$10,000.00 |
$2,485.83 |
| Consulting-information technology |
$268,975.00 |
$98,811.75 |
| Contribution to employees ret |
$1,170,945.00 |
$843,119.05 |
| Dept OH distribtd to indire |
$0.00 |
($1,757.85) |
| Drainage fee expense |
$82,395.00 |
$74,533.40 |
| Educational incentive pay |
$0.00 |
$15,585.87 |
| Educational travel |
$162,573.00 |
$155,975.49 |
| Educational/promotional |
$47,000.00 |
$12,217.96 |
| Elctrcal conductors-hardware |
$5,000.00 |
$767.51 |
| Electric services |
$238,800.00 |
$77,752.41 |
| Electrical/lighting |
$30,136.00 |
$139,564.29 |
| Emergency leave |
$0.00 |
$5,360.88 |
| Employee recruiting |
$15,000.00 |
$8,073.00 |
| Exception vacation |
$0.00 |
$304.96 |
| Expense refunds |
($280,000.00) |
($414,144.70) |
| FICA tax |
$863,561.00 |
$625,514.51 |
| Fleet-equip.preventative maint |
$126,301.00 |
$117,293.70 |
| Food/Ice |
$27,075.00 |
$14,719.37 |
| Freight |
$500.00 |
$704.99 |
| Garbage/refuse collection |
$2,500.00 |
$735.30 |
| Gas/heating fuels |
$10,500.00 |
$9,202.89 |
| Gasoline/oil/grease |
$600.00 |
$649.17 |
| Government permits and fees |
$3,200.00 |
$0.00 |
| Hardware/wire/steel |
$8,225.00 |
$9,762.71 |
| Holiday pay |
$0.00 |
$491,623.46 |
| Holidays worked |
$0.00 |
$16,391.40 |
| Household/cleaning supplies |
$8,450.00 |
$15,930.57 |
| Indirect costs-FMC 74-4 |
$0.00 |
$1,757.85 |
| Insurance-health/life/dental |
$2,377,420.00 |
$1,510,071.58 |
| Interdepartmental Charges |
$2,500.00 |
$2,938.00 |
| Jury leave |
$0.00 |
$5,212.22 |
| Maintenance-boilers |
$4,000.00 |
$0.00 |
| Maintenance-buildings |
$650,500.00 |
$383,158.79 |
| Maintenance-chillers |
$100,030.00 |
$0.00 |
| Maintenance-computer hardware |
$340,900.00 |
$13,992.64 |
| Maintenance-computer software |
$1,298,004.00 |
$810,039.31 |
| Maintenance-electric motors |
$100.00 |
$0.00 |
| Maintenance-grounds |
$150,000.00 |
$149,271.65 |
| Maintenance-other equipment |
$15,000.00 |
$1,109.50 |
| Medical/dental supplies |
$500.00 |
$2,069.91 |
| Medicare tax |
$203,662.00 |
$147,799.90 |
| Memberships |
$147,463.00 |
$134,516.75 |
| Mileage reimbursements |
$3,574.00 |
$3,279.15 |
| Minor communications equipment |
$0.00 |
$3,678.33 |
| Minor computer hardware |
$439,347.00 |
$210,257.19 |
| O&M CONTINGENCY |
$25,000.00 |
$0.00 |
| Office furnishings |
$20,950.00 |
$33,774.73 |
| Office supplies |
$26,945.00 |
$16,109.17 |
| On call hours |
$6,695.00 |
$9,522.47 |
| Other Equipment |
$16,000.00 |
$31,952.60 |
| Overtime |
$58,161.00 |
$84,467.09 |
| Paint/painting supplies |
$950.00 |
$4,596.62 |
| Parental Leave |
$0.00 |
$42,063.60 |
| Parking costs |
$306.00 |
$0.00 |
| Parts for equipment |
$3,500.00 |
$31,883.77 |
| Personal holiday pay |
$0.00 |
$116,530.22 |
| Personnel savings |
($1,496,495.00) |
$0.00 |
| Phone allowance |
$59,130.00 |
$47,401.70 |
| Pipes and fittings |
$4,550.00 |
$8,624.38 |
| Postage |
$0.00 |
$28.87 |
| Printing/binding/photo/repr |
$525.00 |
$192.75 |
| Priority mail/parcel services |
$37,500.00 |
$7,790.00 |
| Professional registration |
$16,579.00 |
$5,168.58 |
| Radio equipment |
$162,500.00 |
$128,494.88 |
| Refrigerant components-HVAC |
$44,000.00 |
$6,526.48 |
| Regular wages - full-time |
$13,489,411.00 |
$8,279,045.89 |
| Reimbursement of CIP charge |
$0.00 |
($5,095.59) |
| Rental-copy machines |
$170,000.00 |
$13,512.14 |
| Rental-other equipment |
$7,870.00 |
$3,671.45 |
| Rental-real estate-other |
$66,398.00 |
$39,820.00 |
| Rental-vehicles/buses |
$500.00 |
$152.75 |
| Safety equipment |
$177,724.00 |
$130,860.87 |
| Security equipment |
$1,700.00 |
$1,040.88 |
| Seminar/training fees |
$162,073.00 |
$20,139.14 |
| Services - Contractual Electrical |
$50,000.00 |
$1,397.46 |
| Services - Contracutal HVAC |
$275,000.00 |
$395,706.28 |
| Services - Fire Alarms |
$125,000.00 |
$71,370.08 |
| Services-IT |
$70,365.00 |
$7,499.24 |
| Services-IT Installations |
$0.00 |
$3,447.05 |
| Services-IT staffing |
$235,000.00 |
$110,396.93 |
| Services-Platform as a Service |
$249,280.00 |
$61,599.13 |
| Services-Software as a Service |
$481,500.00 |
$381,933.10 |
| Services-hazardous mat disp |
$11,000.00 |
$0.00 |
| Services-inspection |
$10,500.00 |
$987.68 |
| Services-internet/cable |
$38,643.00 |
$18,547.08 |
| Services-janitorial |
$665,000.00 |
$301,777.73 |
| Services-medical/surgical |
$22,650.00 |
$0.00 |
| Services-other |
$1,277,280.00 |
$1,328,286.15 |
| Services-security |
$1,083,750.00 |
$808,596.24 |
| Services-testing |
$25,000.00 |
$1,316.50 |
| Shift differential |
$0.00 |
$4,052.08 |
| Sick pay |
$0.00 |
$273,297.31 |
| Small electric motors-water ut |
$2,000.00 |
$0.00 |
| Small tools/minor equipment |
$31,112.00 |
$61,396.27 |
| Software |
$21,275.00 |
$10,577.62 |
| Stability pay |
$87,750.00 |
$81,150.00 |
| Street/traff signs/mrkr/pos |
$60.00 |
$30.00 |
| Subscriptions |
$10,198.00 |
$2,889.25 |
| Telephone-base cost |
$132,500.00 |
$91,623.76 |
| Telephone-cellular phones |
$260,000.00 |
$87,767.51 |
| Temporary employees |
$403,390.00 |
$334,451.21 |
| Terminal pay |
$10,500.00 |
$46,140.66 |
| Toll Road - Tx Tag |
$7,500.00 |
$3,613.18 |
| Training-city wide |
$5,000.00 |
$2,068.50 |
| Transportation fee expense |
$0.00 |
$26.02 |
| Transportation-city veh fuel |
$28,114.00 |
$31,348.01 |
| Vacation pay |
$0.00 |
$562,685.63 |
| Valves |
$250.00 |
$6,258.60 |
| Welding supplies |
$550.00 |
$70.27 |
| |
$27,320,251.00 |
$20,003,038.73
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Debt Transfers |
| Commercial paper interest |
$2,194,028.00 |
$412,606.03 |
| Tfr to Util D/S Tax/Rev Bonds |
$247,436.00 |
$9,413.81 |
| Tfr to Utility D/S Sub Lien |
$1,927,789.00 |
$1,940,138.28 |
| Trf to GO Debt Service |
$69,765.00 |
$52,323.39 |
| Trf to Util D/S Separate Lien |
$92,762,598.00 |
$58,661,238.70 |
| |
$97,201,616.00 |
$61,075,720.21
|
|
| Interfund Transfers |
| Administrative Support |
$9,996,400.00 |
$6,664,266.64 |
| CTECC Support |
$20,296.00 |
$20,296.00 |
| CTM Support |
$2,831,963.00 |
$1,887,975.36 |
| Regional Radio System |
$388,531.00 |
$259,020.64 |
| TRF CRF to Debt Defeasance |
$21,500,000.00 |
$21,500,000.00 |
| Trf to CIP Mgm - CPM |
$1,939,725.00 |
$1,293,150.00 |
| Trf to Economic Development |
$2,032,302.00 |
$1,354,868.00 |
| Trf to General Fund |
$27,528,778.00 |
$18,352,518.64 |
| Trf to Reclaimed Water Fund |
$6,500,000.00 |
$4,333,333.36 |
| Trf to Water CIP Fund |
$36,869,000.00 |
$25,040,568.00 |
| Trf to Water Revenue Stab Rsv |
$2,462,280.00 |
$1,449,262.34 |
| Workers' Compensation |
$679,988.00 |
$453,325.36 |
| |
$112,749,263.00 |
$82,608,584.34
|
|
| Other Requirements |
| Accrued Payroll |
$298,402.00 |
$0.00 |
| Compensation Adjustment |
$36,538.00 |
$0.00 |
| Contribution to employees ret |
$6,070,329.00 |
$3,969,061.57 |
| Interdepartmental Charges |
$208,019.00 |
$138,679.36 |
| Trf to PID Fund |
$37,500.00 |
$37,500.00 |
| Utility Billing System Support |
$15,156,429.00 |
$10,104,286.00 |
| |
$21,807,217.00 |
$14,249,526.93
|
|
|
|
| AUSTIN WATER WILDLAND CONSERVATION FUND |
BUDGET |
EXPENDITURES |
| ENVIRONMENTAL, PLANNING, AND DEVELOPMENT SERVICES |
| Wildland Conservation |
| Services-other |
$265,000.00 |
$36,916.20 |
| Services-testing |
$20,000.00 |
$0.00 |
| |
$285,000.00 |
$36,916.20
|
|
|
|
| WATER INVENTORY FUND |
BUDGET |
EXPENDITURES |
| MISCELLANEOUS |
| Miscellaneous |
| Inventory purchases |
$0.00 |
($130,435.92) |
| |
$0.00 |
($130,435.92)
|
|
|
|
| TOTALS |
$800,262,594.00 |
$543,950,040.36 |
|
