|
FINANCIAL STATEMENT
<br />WATER FUND
<br />31 -Dec-09
<br />INCOME: 2009 COMPARED INCOME BALANCE
<br />BUDGET TO 200$ TO DATE IN BUDGET
<br />300
<br />Water Sales
<br />250,000.00
<br />311,199.73
<br />289,493.88
<br />116%
<br />(39.493 88)
<br />301
<br />Interest Income
<br />3,000.00
<br />6,259.31
<br />5,393.17
<br />180%
<br />(2.393 17)
<br />302
<br />Other Income
<br />7,000.00
<br />7,825.00
<br />5,662.00
<br />81%
<br />1,338.00
<br />•302.1
<br />Grants
<br />0
<br />261,783.14
<br />412,839.45
<br />(412.839 45)
<br />M.2
<br />(-531-�04.7-697-
<br />303
<br />Water Taps
<br />18,000.00
<br />12,000.00
<br />16,000.00
<br />100%
<br />0.00
<br />Total
<br />276,000.00
<br />1,118,926.60
<br />1,260,436.19
<br />457%
<br />(984.43619)
<br />EXPENSES:
<br />2009
<br />COMPARED
<br />EXPENSES
<br />BALANCE
<br />BUDGET
<br />TO 2008
<br />TO DATE
<br />IN BUDGET
<br />400
<br />Administration Expenses
<br />3,200.00
<br />3,296.80
<br />3,343.10
<br />104%
<br />(143 10)
<br />401
<br />Water Salaries
<br />72,661.00
<br />69,908.30
<br />72,567.96
<br />100%
<br />93.04
<br />401.1
<br />Retirement
<br />4,111.00
<br />3,982.94
<br />4,111.49
<br />100%
<br />(0 49)
<br />402
<br />Employee Health Insurance
<br />8,862.00
<br />10,031.83
<br />7,563.08
<br />85%
<br />1,298.92
<br />403
<br />FICA Expense
<br />5,297.00
<br />5,129.89
<br />5,297.31
<br />100%
<br />(0 3 1 )
<br />403.1
<br />FPPA Benefits
<br />305.00
<br />281.24
<br />304.56
<br />100%
<br />0.44
<br />403.2
<br />FPPA Death & Disability
<br />99.00
<br />91.40
<br />98.99
<br />100%
<br />0.01
<br />404
<br />Repairs and Maintenance
<br />8,000.00
<br />3,637.09
<br />5,451.39
<br />68%
<br />2,548.61
<br />405
<br />Gasoline and Diesel
<br />1,000.00
<br />569.22
<br />281.91
<br />28%
<br />718.09
<br />405
<br />Water Supplies
<br />12,000.00
<br />18,141.40
<br />8,960.44
<br />75%
<br />3,039.56
<br />406.1
<br />Distribution Piping
<br />2,500.00
<br />882.93
<br />248.88
<br />10%
<br />2,251.12
<br />406.2
<br />Metering Equipment
<br />15,000.00
<br />10,319.09
<br />5,641.41
<br />38%
<br />9,358.59
<br />407
<br />Utilities
<br />8,200.00
<br />8,074.39
<br />8,587.87
<br />105%
<br />(387 87)
<br />408
<br />Engineering
<br />5,000.00
<br />2,527.50
<br />11,307.44
<br />226%
<br />(6.307 44)
<br />409
<br />Audit
<br />1,800.00
<br />1,800.00
<br />1,800.00
<br />100%
<br />0.00
<br />410
<br />Equipment and Expenses
<br />5,000.00
<br />2,057.04
<br />1,708.70
<br />34%
<br />3,291.30
<br />412
<br />Water Samples/Testing
<br />5,400.00
<br />5,779.99
<br />4,945.00
<br />92%
<br />455.00
<br />413
<br />State Permit Fees
<br />310.00
<br />310.00
<br />1,410.00
<br />455%
<br />(1.100 00)
<br />413.1
<br />Workshops and Certifications
<br />1,000.00
<br />233.41
<br />215.00
<br />22%
<br />785.00
<br />414
<br />Depreciation
<br />41,000.00
<br />0.00
<br />1,761.10
<br />4%
<br />39,238.90
<br />415
<br />Other Expenses
<br />1,000.00
<br />1,291.34
<br />250.26
<br />25%
<br />749.74
<br />416
<br />Water Attorney Fees
<br />7,500.00
<br />9,881.97
<br />6,508.85
<br />87%
<br />991.15
<br />417
<br />Computer Update
<br />1,500.00
<br />271.00
<br />1,208.67
<br />81%
<br />291.33
<br />419
<br />Office Supplies
<br />900.00
<br />599.98
<br />0.00
<br />0%
<br />900.00
<br />420
<br />Publication Costs
<br />800.00
<br />366.44
<br />66.43
<br />8%
<br />733.57
<br />420.1
<br />Insurance
<br />2,360.00
<br />2,360.00
<br />0.00
<br />0%
<br />2,360.00
<br />421
<br />Impact Loan - Interest
<br />835.00
<br />1,175.95
<br />596.48
<br />71%
<br />238.52
<br />421.1
<br />Impact Loan - Principal
<br />11,931.00
<br />11,589.40
<br />11,929.61
<br />100%
<br />1.39
<br />423
<br />Reserve Funds
<br />113,995.08
<br />0.00
<br />0.00
<br />0%
<br />113,995.08
<br />423.1
<br />Earmarked Reserve Funds
<br />43,000.00
<br />0.00
<br />0.00
<br />0%
<br />43,000.00
<br />425
<br />CWRPD Loan
<br />2,361.04
<br />0.00
<br />2,361.04
<br />100%
<br />0.00
<br />425.1
<br />CWRPD - Interest
<br />1,771.88
<br />0.00
<br />1,771.88
<br />100%
<br />0.00
<br />426
<br />Capital Improvements
<br />200,000.00
<br />781,802.37
<br />1,076,642.05
<br />538%
<br />(876.642 05)
<br />Total
<br />58$,699.00
<br />956,392.91
<br />1,246,940.90
<br />212%
<br />(658,241.90)
<br />Page 5
<br />
|