|
|
|
CITY OF O'NEILL |
|
|
|
|
|
|
|
|
|
|
|
|
SEWER 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 |
73,189 |
84,849 |
87,960 |
93,498 |
|
| 130 |
Employee Insurance |
20,272 |
22,162 |
22,290 |
30,111 |
|
| 140 |
Payroll Taxes |
5,434 |
6,491 |
6,729 |
7,153 |
|
| 160 |
Employee Retirement |
1,581 |
2,194 |
2,351 |
2,478 |
|
| 210 |
Professional Fees |
8,933 |
9,366 |
27,650 |
45,850 |
|
| 255 |
Insurance |
15,057 |
15,032 |
14,325 |
15,783 |
|
| 260 |
Utilities |
42,873 |
45,568 |
45,560 |
49,189 |
|
| 290 |
Miscellaneous |
14,242 |
5,854 |
9,250 |
7,750 |
|
| 320 |
Supplies & Publishing |
48,259 |
29,242 |
42,062 |
31,600 |
|
| 330 |
Parts & Repairs |
5,445 |
1,812 |
4,950 |
4,950 |
|
| 340 |
Gas & Oil |
5,720 |
3,050 |
7,109 |
6,560 |
|
| 355 |
Lab Supplies |
10,169 |
7,171 |
10,000 |
10,000 |
|
| 360 |
Line Maintenance |
3,864 |
1,030 |
4,500 |
2,500 |
|
| 390 |
Facility Maintenance |
21,267 |
49,136 |
90,000 |
40,000 |
|
| 500 |
Bad debt |
|
0 |
0 |
0 |
|
| 530 |
Capital Expenditures |
168,173 |
254,712 |
295,000 |
336,500 |
|
| 620 |
Interest - Anticipation
Notes |
0 |
0 |
0 |
|
| 760 |
Equipment Replacement
Fund |
0 |
0 |
0 |
|
| 780 |
Sales Tax |
22,187 |
24,042 |
24,000 |
24,000 |
|
| 610 |
Bond Principal - to Debt
Service |
0 |
0 |
0 |
|
| TOTAL |
|
466,665 |
561,711 |
693,736 |
707,922 |
|
|
Necessary Cash Reserve |
0 |
0 |
307,633 |
221,036 |
|
| TOTAL
REQUIREMENTS |
466,665 |
561,711 |
1,001,369 |
928,958 |
|
|
|
|
|
| REVENUES |
|
|
|
|
| Fund Balance |
|
562,343 |
573,358 |
545,369 |
472,958 |
|
| 57 Miscellaneous |
|
820 |
0 |
0 |
0 |
|
| 78 Sales Tax |
|
22,598 |
22,000 |
22,000 |
22,000 |
|
| 47 Service Billings |
|
374,790 |
360,000 |
365,000 |
365,000 |
|
| 55 Service & Sales |
|
1,023 |
1,672 |
1,000 |
1,000 |
|
| 29 Interest |
|
11,419 |
7,800 |
8,000 |
8,000 |
|
| 58 Assessments |
|
2,226 |
4,339 |
0 |
0 |
|
| 77 City Sales Tax |
|
64,804 |
65,500 |
60,000 |
60,000 |
|
|
|
|
|
| TOTAL
REVENUES |
1,040,023 |
1,034,669 |
1,001,369 |
928,958 |
|
|
Less Expenditures |
466,665 |
561,711 |
1,001,369 |
928,958 |
|
| Balance |
|
573,358 |
472,958 |
0 |
0 |
|
|
|
|
|
|
|
CITY OF O'NEILL |
|
|
|
|
SEWER FUND |
|
|
Fiscal Year 2009-2010 |
|
|
| 110 |
Salaries |
|
93,498 |
|
|
Water/Sewer Supervisor |
|
|
Present salary 1,689.63 X
13 |
|
21,965 |
|
|
Wage adjustment 42.24 X
13 |
|
549 |
|
|
Longevity |
|
450 |
|
|
22,964 |
|
|
Lab Technician |
|
|
Present salary 11.41 X 80
X 26 |
|
23,733 |
|
|
Wage adjustment .58 X 80
X 26 |
|
1,206 |
|
|
24,939 |
|
|
Maintentance Operator |
|
|
|
|
Present salary 12.79 X 80
X 26 |
|
26,603 |
|
|
Wage adjustment .32 X 80
X 26 |
|
667 |
|
|
Longevity |
|
300 |
|
|
27,570 |
|
|
|
|
|
1 Certification .58 X 80
X 26 |
|
1,206 |
|
|
|
|
|
|
Overtime |
|
|
90 X 18.83 |
|
|
1,695 |
|
|
|
|
|
|
|
Part Time Employees |
|
|
|
|
Wage 7.85 X 1,040 hours |
|
8,164 |
|
|
Wage 7.25 X 480 hours X 2 |
|
6,960 |
|
|
|
|
15,124 |
|
|
| 130 |
Employee Insurance |
|
30,111 |
|
|
1.5 family 1,338.66 X
12 |
|
24,096 |
|
|
1 employee 408.92 X 12 |
|
4,907 |
|
|
1 family dental 58.16 X
12 |
|
698 |
|
|
1 employee dental 19.71 X
12 |
|
237 |
|
|
2.5 employee life 5.75 X
12 |
|
173 |
|
|
| 140 |
Payroll Taxes |
|
7,153 |
|
|
.0765 X 93,498 |
|
7,153 |
|
|
| 160 |
Employee Retirement |
|
2,478 |
|
|
.03 X 75,929 |
|
2,278 |
|
|
Service fees |
|
200 |
|
|
| 210 |
Professional Fees |
|
45,850 |
|
|
Legal fees hours 40 X 110 |
|
4,400 |
|
|
Annual audit |
|
1,750 |
|
|
Engineering |
|
36,000 |
|
|
Testing laboratories |
|
3,700 |
|
|
| 255 |
Insurance |
|
15,783 |
|
|
Liability, Fire, Casualty |
|
11,323 |
|
|
Worker's Comp |
|
4,460 |
|
|
| 260 |
Utilities |
|
49,189 |
|
|
Electricity |
|
42,489 |
|
|
Propane |
|
2,000 |
|
|
Telephone |
|
4,500 |
|
|
Cellular phone |
|
200 |
|
|
| 290 |
Miscellaneous &
Contingent |
|
7,750 |
|
|
Dues League of
Municipalities |
|
500 |
|
|
Training & schooling |
|
2,000 |
|
|
Freight |
|
350 |
|
|
Unanticipated expenses |
|
4,500 |
|
|
Digger's hotline |
|
400 |
|
|
| 320 |
Supplies & Publishing |
|
31,600 |
|
|
Computer maintenance/
licensing |
|
2,000 |
|
|
Billing & supplies |
|
1,000 |
|
|
Publishing |
|
750 |
|
|
Office and general
supplies |
|
8,500 |
|
|
Yard/tools/parts |
|
2,000 |
|
|
Postage meter rental |
|
350 |
|
|
Postage |
|
3,500 |
|
| |
Boots/gloves/safety gear |
|
1,000 |
|
|
Uniforms |
|
|
2,500 |
|
|
Treatment chemicals |
|
10,000 |
|
|
|
|
| 330 |
Parts & Repairs |
|
4,950 |
|
|
Parts |
|
2,000 |
|
|
Vehicle and
equipment |
|
2,000 |
|
|
Tires and repair |
|
800 |
|
|
Radio repair |
|
150 |
|
|
| 340 |
Gas & Oil |
|
6,560 |
|
|
Gas |
|
4,000 |
|
|
Oil |
|
|
560 |
|
|
Diesel |
|
2,000 |
|
|
| 355 |
Laboratory Supplies and
Equipment |
|
10,000 |
|
|
Lab supplies and
equipment |
|
10,000 |
|
|
| 360 |
Line Maintenance |
|
2,500 |
|
|
Manholes & line
improvements |
|
2,500 |
|
|
| 390 |
Facility Maintenance |
|
40,000 |
|
|
Maintenance/repairs |
|
30,000 |
|
|
Sludge hauling |
|
0 |
|
|
Computer/software upgrade |
|
10,000 |
|
|
| 530 |
Capital Expenditures |
|
336,500 |
|
|
Williams to Douglas - 6th
Street |
|
206,500 |
|
|
Lagoon liner |
|
35,000 |
|
|
Pickup |
|
25,000 |
|
|
Video Camera |
|
20,000 |
|
|
Line addition |
|
50,000 |
|
|
| 610 |
Bond |
|
0 |
|
|
0 |
|
|
| 780 |
Sales Tax |
|
24,000 |
|
|
|
|
24,000 |
|
|
|
| |
|
` |
|
|
|
|
|
|
|
|
|
|