CITY OF O'NEILL
  WATER FUND
10-1-07 10-1-08 10-1-08 10-1-09
   to    to    to    to
9-30-08 9-30-09 9-30-09 9-30-10
Actual Act+Est Budget Budget
EXPENDITURES
110 Salaries 113,931 121,041 121,041 125,934
130 Employee Insurance 31,039 22,232 34,781 46,942
140 Payroll Taxes 8,492 9,260 9,260 9,634
160 Employee Retirement 3,585 3,507 3,716 3,737
210 Professional Fees 6,544 42,000 43,650 46,450
255 Insurance 12,345 13,845 14,647 14,537
260 Utilities 53,470 41,370 61,100 45,017
290 Miscellaneous 2,538 4,162 3,850 5,350
320 Supplies & Publishing 18,130 16,309 19,562 18,600
330 Parts & Repairs 2,985 1,000 4,450 2,750
340 Gas & Oil 4,128 2,640 5,669 4,200
355 Chemicals 2,284 2,530 3,500 3,000
360 Line Maintenance 8,574 4,500 8,800 4,150
370 Meters 27,489 15,500 22,300 52,000
390 Facility Maintenance 34,163 4,530 33,500 26,500
500 Bad debt 0 0
530 Capital Expenditures 100,000 283,945 303,000 300,000
780 Sales Tax 19,697 19,187 19,000 19,500
TOTAL 449,394 607,558 711,826 728,301
Necessary Cash Reserve 0 0 120,785 102,248
TOTAL REQUIREMENTS 449,394 607,558 832,611 830,549
REVENUES
Fund Balance 302,511 251,772 208,611 313,049
57 Miscellaneous 6,202 2,629 2,000 2,000
78 Sales Tax 18,185 16,000 16,000 16,000
47 Service Billings 295,814 290,000 260,000 280,000
55 Service & Sales 5,093 10,730 5,000 5,000
29 Interest 4,848 2,500 4,000 2,500
Transfers from General  275,000 275,000 150,000
58 Assessments 3,709 6,076 2,000 2,000
77 City Sales Tax 64,804 65,900 60,000 60,000
TOTAL REVENUES 701,166 920,607 832,611 830,549
Less Expenditures 449,394 607,558 832,611 830,549
 
Balance 251,772 313,049 0 0
CITY OF O'NEILL
     WATER FUND
                      Fiscal Year 2009-2010
110 Salaries 125,934
Water/Sewer Supervisor
Present salary 1,689.63 X 13 21,965
Wage adjustment 42.24 X 13 549
Longevity 450
22,964
Water Foreman
Present salary 15.75 X 80 X 26 32,760
32,760
Water Operator II 
Present salary 13.70 X 80 X 26 28,496
 Wage adjustment .34 X 80 X 26  707
Longevity 450
29,653
Water Operator I
Present salary 13.55 X 80 X 26 28,184
Wage adjustment .34 X 80 X 26 707
Longevity 300
29,191
1 Certifications .58 X 80 X 26 1,206
Overtime  
250 hrs X 19.67 4,918
240 hrs X 21.84 5,242
  10,160
130 Employee Insurance   46,942
2.5 family 1,338.66 X 12  40,160
1 employee 408.92 X 12 4,907
2 family dental 58.16 X 12 1,396
1 employee dental 19.71 X 12 237
3.5 employee life 5.75 X 12 242
140 Payroll Taxes 9,634
.0765 X 125,934 9,634
160 Employee Retirement 3,737
.03 X 114,574 3,437
Service fees 300
210 Professional Fees 46,450
Legal fees 40 hours X 110 4,400
Annual audit 1,750
Engineering 35,000
Miscellaneous 3,000
State Health Laboratories 2,300
255 Insurance 14,537
Liability, Fire, Casualty  5,658
Worker's Comp  8,879
260 Utilities 45,017
  Electricity  35,117
Propane 1,200
Telephone  8,500
Cellular phone 200
290 Miscellaneous & Contingent 5,350
Dues : League & Rural Water  550
Training and schooling 2,000
Freight 200
Unanticipated expenses 2,200
Digger's hotline 400
320 Supplies & Publishing 18,600
Postage  5,000
Postage meter rental 350
Publishing 1,000
Computer expense 500
Computer maintenance agreement 2,500
Billing expense 1,900
Office supplies 550
Miscellaneous supplies 3,500
Gloves, boots, and coveralls 500
Uniforms  2,500
Fertilizer, seed and herbicide 300
330 Parts & Repairs 2,750
Parts/repairs vehicle and equipment 1,800
Tires and repair  800
Radio repair  150
340 Gas & Oil 4,200
Gas 3,000
Oil 200
Diesel 1,000
355 Chemicals 3,000
Fluoride 3,000
360 Line Maintenance 4,150
Valves  750
Curb stops  900
Miscellaneous 2,500
370 Meters 52,000
Meters with RTR and parts 3,000
Backflow assemblies 0
Radio read meters 49,000
390 Facility Maintenance 26,500
General maintenance 10,000
RTU and computer repairs 3,000
Service well 3,500
Computer & software upgrade 10,000
530  Capital Expenditures 300,000
Line addition 50,000
New well 250,000
610 Bond Principal 0
0
760 Depreciation Account 0
780 Sales Tax 19,500
19,500