Page 45 - City of Westworth Village FY22 Budget
P. 45
45
Water Fund Detail
Actual Actual Actual Adopted Projected Proposed
ACCT 2018 2019 2020 2021 2021 2022
Water Fund Revenue
Additional Revenue
02-500-525011 Interest Earned $ 1,249 $ 1,919 $ 765 $ 1,600 $ 500 $ 1,000
Total Additional Revenue $ 1,249 $ 1,919 $ 765 $ 1,600 $ 500 $ 1,000
Miscellaneous Revenue
02-500-565012 Miscellaneous Revenue $ 549 $ 652 $ 1,712 $ 500 $ 500 $ 500
02-500-565038 Return Check Charge $ 60 $ 60 $ 30 $ 100 $ 100 $ 100
02-500-565050 Water turn on Fees $ 4,335 $ 6,105 $ 3,890 $ 4,500 $ 4,500 $ 4,500
02-500-565051 Late Fees $ 14,346 $ 13,347 $ 13,458 $ 12,500 $ 18,000 $ 12,500
02-500-565052 Water/Sewer Setup Fees $ 79,239 $ 69,281 $ 45,535 $ 45,000 $ 45,000 $ 45,000
02-500-565055 Water Revenue $ 649,127 $ 631,886 $ 625,661 $ 580,000 $ 586,784 $ 598,520
02-500-565056 Sewer Revenue $ 498,637 $ 490,172 $ 481,888 $ 505,000 $ 517,330 $ 594,929
02-500-565057 Sanitation Revenue $ 130,733 $ 138,778 $ 146,714 $ 138,000 $ 148,954 $ 148,800
02-500-565059 Storm Sewer Fees $ 78,778 $ 81,676 $ 83,372 $ 170,000 $ 169,424 $ 170,000
02-500-XXXXX CLFRF Grant Funding $ 341,573 $ 341,573
Total Miscellaneous Revenue $ 1,455,804 $ 1,431,956 $ 1,402,261 $ 1,455,600 $ 1,832,164 $ 1,916,422
Total Water Revenue $ 1,457,053 $ 1,433,875 $ 1,403,026 $ 1,457,200 $ 1,832,664 $ 1,917,422
Water Fund Expenses
Water Fund
Payroll
02-620-610001 Salaries $ 86,715 $ 89,614 $ 82,673 $ 116,749 $ 163,244 $ 125,061
02-620-610002 TMRS Retirement $ 11,094 $ 10,910 $ 9,171 $ 14,577 $ 24,491 $ 16,251
02-620-610003 Workers compensation $ 451 $ 505 $ 363 $ 2,550 $ 598 $ 2,678
02-620-610004 Unemployement Comp $ 502 $ 389 $ 115 $ 432 $ 753 $ 432
02-620-610005 Group Health Insurance $ 6,591 $ 11,858 $ 17,968 $ 25,200 $ 30,686 $ 26,100
02-620-610006 Medicare $ 1,256 $ 1,208 $ 1,216 $ 1,761 $ 2,379 $ 1,887
02-620-610007 FICA Social Security $ 609 $ 46 $ - $ - $ - $ -
02-620-610008 Overtime Pay $ 2,360 $ - $ 3,486 $ 4,042 $ 5,354 $ 4,213
02-620-610009 Cell Phone Allowance $ 70 $ 368 $ 490 $ 840 $ 1,348 $ 840
02-620-610012 Contract Services $ - $ 6,392 $ 6,983 $ 10,000 $ - $ 10,000
Total Payroll $ 109,648 $ 121,290 $ 122,464 $ 176,152 $ 228,852 $ 187,462
Supplies
02-620-615001 Office Supplies $ 8,129 $ 3,694 $ 3,080 $ 5,000 $ 5,000 $ 5,000
02-620-615002 Supplies $ 87,998 $ 40,362 $ 30,619 $ 35,000 $ 35,000 $ 35,000
02-620-615003 Printing $ 1,278 $ 776 $ 587 $ 1,000 $ 1,000 $ 1,000
02-620-615004 Postage $ 4,347 $ 4,749 $ 4,364 $ 4,300 $ 4,300 $ 4,300
02-620-615005 Electric $ 1,534 $ 1,751 $ 1,265 $ 3,000 $ 3,000 $ 3,000
02-620-615006 Water $ 824 $ 633 $ 702 $ 700 $ 700 $ 700
02-620-615009 Cable/Internet $ 2,892 $ 3,089 $ 3,115 $ 3,000 $ 3,000 $ 3,000
02-620-640000 Gas $ 715 $ 832 $ - $ 1,000 $ 1,000 $ 1,000
Total Supplies $ 107,717 $ 55,887 $ 43,732 $ 53,000 $ 53,000 $ 53,000
Training
02-620-620001 Training $ 5,156 $ 7,512 $ 6,463 $ 8,000 $ 5,000 $ 8,000
02-620-620002 Dues & Memberships $ 3,184 $ 3,307 $ 3,177 $ 3,500 $ 3,500 $ 3,500
Total Training $ 8,340 $ 10,819 $ 9,640 $ 11,500 $ 8,500 $ 11,500
Equipment
02-620-625001 Equipment/Rental $ 4,811 $ 16,740 $ - $ 10,000 $ 5,000 $ 55,000
02-620-625004 Equipment Maintenance $ 6,719 $ 6,971 $ 4,087 $ 7,000 $ 7,000 $ 7,000
02-620-625014 Building Maintenance $ - $ 4,762 $ 4,493 $ 5,000 $ 5,000 $ 5,000
02-620-625021 Contingency Fund $ - $ 16,599 $ - $ 10,000 $ 10,000 $ 10,000
Total Equipment $ 4,811 $ 45,073 $ 8,580 $ 32,000 $ 27,000 $ 77,000
www.cityofwestworth.com