BUDGET
WORKSHEET FISCAL YEAR |
2006 |
|
|
|
|
Rev |
|
|
|
|
|
|
|
215.E911 Fund |
|
|
|
|
|
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Month |
|
|
DEPARTMENT |
ADMINISTATOR |
COMMISION |
Percent |
|
|
|
Actual |
Actual |
Actual |
Actual |
Actual |
Project |
Budget |
REQUEST |
RECOMMENDED |
APPROVED |
Change |
|
|
|
2001 |
2002 |
2003 |
2004 |
2005 |
2005 |
2005 |
2006 |
2006 |
2006 |
2005-06 |
REMARKS |
Revenues |
|
|
|
|
|
|
|
|
|
|
|
|
|
Sale of Maps &
Publications |
34.1930 |
605 |
419 |
315 |
168 |
12 |
13 |
300 |
|
|
|
-100% |
moved to GF |
Alltel |
34.2501 |
7,976 |
6,651 |
7,812 |
8,666 |
2,486 |
2,712 |
7,500 |
7,500 |
7,500 |
7,500 |
0% |
|
Bellsouth |
34.2502 |
23,977 |
11,913 |
21,231 |
23,263 |
22,467 |
24,509 |
21,000 |
24,000 |
24,000 |
24,000 |
14% |
|
Hart
Telephone |
34.2503 |
116,797 |
157,532 |
128,956 |
150,669 |
112,210 |
150,000 |
120,000 |
150,000 |
150,000 |
150,000 |
25% |
|
Alltel Comm |
34.2505 |
6,689 |
9,336 |
6,440 |
6,174 |
9,735 |
10,620 |
5,000 |
7,000 |
7,000 |
7,000 |
40% |
|
AT&T
Cell |
34.2506 |
101 |
237 |
97 |
108 |
79 |
86 |
105 |
105 |
105 |
105 |
0% |
|
Cingular Wireless |
34.2507 |
34,165 |
45,068 |
9 |
35,705 |
457 |
499 |
18,000 |
500 |
500 |
500 |
-97% |
|
Bellsouth Corp |
34.2508 |
|
11,923 |
4,778 |
4,656 |
|
- |
4,700 |
4,700 |
4,700 |
4,700 |
|
|
Bellsouth Mobility |
34.2509 |
2,365 |
4,793 |
33,934 |
34,823 |
18,247 |
19,906 |
35,000 |
35,000 |
35,000 |
35,000 |
|
|
Sprint Spec |
34.2510 |
520 |
596 |
313 |
|
20 |
22 |
|
|
|
|
|
out of business |
Triton Pcs |
34.2511 |
198 |
2,186 |
1,263 |
841 |
572 |
624 |
600 |
600 |
600 |
600 |
0% |
|
Verizon |
34.2512 |
4,056 |
6,357 |
5,819 |
15,287 |
26,776 |
29,210 |
12,000 |
16,000 |
16,000 |
16,000 |
33% |
|
Access Intergrated
Network |
34.2514 |
88 |
17,647 |
728 |
|
71 |
77 |
|
|
|
|
|
|
Cellco Partnership |
34.2515 |
232 |
|
299 |
823 |
|
- |
400 |
400 |
400 |
400 |
|
|
New South |
34.2516 |
|
151 |
122 |
90 |
22 |
24 |
75 |
75 |
75 |
75 |
0% |
|
Nextel |
34.2517 |
|
478 |
475 |
812 |
1,011 |
1,103 |
680 |
900 |
900 |
900 |
32% |
|
TriTel |
34.2518 |
|
3 |
202 |
2 |
15 |
16 |
|
|
|
|
|
|
Trac phone |
34.2519 |
|
|
2,866 |
447 |
|
- |
450 |
450 |
450 |
450 |
|
|
T Mobile |
34.2520 |
|
|
113 |
228 |
283 |
309 |
225 |
225 |
225 |
225 |
|
|
Z-Tel |
34.2521 |
|
|
224 |
159 |
176 |
192 |
135 |
150 |
150 |
150 |
|
|
Vartec |
34.2522 |
|
|
52 |
68 |
|
- |
70 |
70 |
70 |
70 |
|
|
Tax Partners |
34.2523 |
|
|
17,666 |
|
|
- |
|
|
|
|
|
|
sprint |
34.2524 |
|
|
145 |
832 |
930 |
1,015 |
640 |
1,000 |
1,000 |
1,000 |
|
|
triton |
34.2525 |
|
|
282 |
443 |
218 |
238 |
450 |
450 |
450 |
450 |
|
|
Athens cell |
34.2526 |
|
|
59 |
1,960 |
|
- |
700 |
700 |
700 |
700 |
|
|
onstar |
34.2527 |
|
|
56 |
126 |
106 |
129 |
100 |
100 |
100 |
100 |
|
|
excel |
34.2528 |
|
|
|
|
58 |
63 |
|
|
|
|
|
|
ids |
34.2529 |
|
|
|
|
55 |
60 |
|
|
|
|
|
|
virgin |
34.2530 |
|
|
|
|
410 |
447 |
|
|
|
|
|
|
ga rsa 3 |
34.2531 |
|
|
|
|
146 |
159 |
|
|
|
|
|
|
NEGA ltd partner |
34.2532 |
|
|
|
|
59,252 |
64,639 |
|
60,000 |
60,000 |
60,000 |
|
|
new cingular wireless |
34.2533 |
|
|
|
|
3,464 |
3,779 |
|
3,500 |
3,500 |
3,500 |
|
|
ga rsa 1 |
34.2534 |
|
|
|
|
149 |
163 |
|
|
|
|
|
|
ga rsa 2 |
34.2535 |
|
|
|
|
64 |
70 |
|
|
|
|
|
|
nuvox |
34.2536 |
|
|
|
|
44 |
48 |
|
|
|
|
|
|
Interest/Investments/escrow |
39.1100 |
7,866 |
35,202 |
35,000 |
4,040 |
6,476 |
7,065 |
2,800 |
7,000 |
7,000 |
7,000 |
150% |
|
add to match audit |
|
|
|
33,233 |
279 |
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Revenues |
|
205,635 |
310,492 |
301,467 |
290,669 |
266,011 |
317,796 |
230,930 |
320,425 |
320,425 |
320,425 |
39% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenditures |
|
|
|
|
|
|
|
|
|
|
|
|
|
Regular employees |
51.1100 |
17,768 |
19,646 |
27,668 |
124,432 |
100,219 |
109,330 |
131,153 |
120,633 |
120,633 |
120,633 |
-8% |
note
1 |
Part Time Wages |
|
|
|
|
|
|
|
|
20,914 |
20,914 |
20,914 |
|
|
Gross Wages |
51.1135 |
|
|
|
|
|
6,899 |
6,899 |
4,300 |
|
|
|
|
Group insurance |
51.2100 |
2,488 |
3,194 |
2,730 |
12,948 |
11,827 |
12,902 |
16,000 |
17,040 |
17,040 |
17,040 |
7% |
|
FICA |
51.2200 |
1,359 |
1,400 |
1,995 |
8,289 |
7,667 |
8,364 |
10,561 |
11,157 |
10,828 |
9,228 |
-13% |
|
Retirement contributions |
51.2400 |
240 |
211 |
310 |
580 |
979 |
1,068 |
1,000 |
1,200 |
1,200 |
1,200 |
20% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Maint/E911 System |
52.1010 |
90,957 |
48,143 |
|
|
3,336 |
14,000 |
14,000 |
14,000 |
14,000 |
14,000 |
0% |
|
Access Charges -Hart
Telco |
52.1011 |
|
1,385 |
4,300 |
5,160 |
3,870 |
4,222 |
5,160 |
5,160 |
5,160 |
5,160 |
0% |
|
ANI Charges - Hart Telco |
52.1012 |
|
11,222 |
48,042 |
56,520 |
42,390 |
57,000 |
57,000 |
57,000 |
57,000 |
57,000 |
0% |
|
ANI/ALI Charges Bell
South |
52.1013 |
|
1,040 |
12,480 |
11,465 |
13,368 |
14,583 |
12,500 |
14,700 |
14,700 |
14,700 |
18% |
|
Extended ALI Bell South |
|
|
|
|
|
|
4,600 |
4,600 |
|
|
|
|
|
ANI/ALI Charges Alltel |
52.1014 |
|
637 |
7,668 |
7,012 |
5,701 |
6,219 |
7,700 |
7,700 |
7,000 |
7,000 |
-9% |
|
E911 Data Base
Updates-Hart Telco |
52.1015 |
|
23,644 |
11,222 |
|
|
- |
|
|
|
|
|
|
Cingular Wireless |
52.1016 |
|
8,209 |
3,965 |
2,745 |
11,996 |
13,087 |
4,000 |
5,400 |
5,400 |
5,400 |
35% |
|
Verizon |
52.1017 |
|
|
|
1,440 |
300 |
327 |
3,600 |
3,600 |
3,600 |
3,600 |
0% |
|
AT&T
Cell |
|
|
|
|
|
|
- |
|
|
|
|
|
|
Sprint Spec |
|
|
|
|
|
|
- |
|
|
|
|
|
|
Triton Pcs |
|
|
|
|
|
|
- |
|
|
|
|
|
|
Weather Service |
52.1020 |
|
1,018 |
1,056 |
1,056 |
1,116 |
|
1,056 |
1,200 |
1,200 |
1,200 |
14% |
|
Other professional svcs |
52.1210 |
1,245 |
578 |
|
|
|
|
|
|
|
|
|
|
Disposal |
52.2110 |
255 |
525 |
634 |
662 |
771 |
841 |
830 |
1,000 |
830 |
830 |
0% |
|
Maint |
52.2200 |
|
280 |
|
|
|
- |
3,400 |
3,400 |
3,400 |
3,400 |
0% |
recording system |
Pest control |
52.2205 |
670 |
|
35 |
|
|
- |
|
|
|
|
|
|
Outside Labor |
52.2206 |
|
487 |
|
338 |
|
|
500 |
500 |
500 |
500 |
0% |
|
Communications/telephone |
52.3200 |
14,685 |
25,398 |
22,752 |
29,808 |
23,735 |
25,893 |
27,600 |
26,500 |
26,500 |
26,500 |
-4% |
note 2 |
Postage |
52.3210 |
102 |
69 |
73 |
470 |
50 |
55 |
500 |
500 |
500 |
500 |
0% |
|
Printing & Binding |
52.3400 |
|
|
|
|
|
- |
|
|
|
|
|
|
Travel |
52.3500 |
328 |
533 |
223 |
567 |
407 |
444 |
600 |
600 |
600 |
600 |
0% |
|
Dues and Fees |
52.3600 |
|
150 |
|
95 |
95 |
104 |
120 |
120 |
120 |
120 |
0% |
|
Training |
52.3700 |
|
|
|
489 |
85 |
93 |
600 |
600 |
600 |
600 |
0% |
|
Energy |
53.1200 |
2,564 |
13,587 |
10,923 |
15,406 |
12,213 |
13,323 |
15,000 |
15,000 |
15,000 |
15,000 |
0% |
|
Office supplies |
53.1710 |
2,789 |
1,289 |
818 |
1,710 |
1,100 |
1,200 |
1,500 |
1,500 |
1,500 |
1,500 |
0% |
|
Parts |
53.1750 |
|
|
274 |
764 |
467 |
509 |
500 |
500 |
500 |
500 |
0% |
|
signs |
53.1720 |
|
2,093 |
|
|
|
|
|
|
|
|
|
|
Gasoline |
53.1790 |
130 |
|
|
|
|
- |
|
|
|
|
|
|
UHF Radio/Ant |
|
|
|
|
|
|
- |
|
|
|
|
|
|
Recording System |
|
|
|
|
|
|
- |
|
|
|
|
|
|
Machinery and Equipment |
54.2000 |
|
820 |
1,252 |
3,052 |
|
|
|
50,000 |
50,000 |
50,000 |
|
|
computers |
54.2400 |
|
29,879 |
409 |
|
|
|
|
|
|
|
|
|
|
54.2410 |
|
|
7,955 |
|
|
|
|
|
|
|
|
|
Principal |
58.1000 |
|
47,266 |
151,887 |
|
|
|
|
|
|
|
|
|
Interest |
58.2000 |
|
8,608 |
9,008 |
|
|
|
|
|
|
|
|
|
add to match audit |
|
|
|
35,596 |
(987) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Expenditures |
|
135,580 |
251,311 |
363,275 |
284,021 |
241,692 |
295,062 |
326,379 |
384,224 |
378,725 |
377,125 |
16% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Rev-exp (fund balance
transfer) |
|
(86,605) |
|
(32,608) |
6,648 |
24,319 |
22,734 |
(95,449) |
(63,799) |
(58,300) |
(56,700) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
full time employees |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Exepected Fund Bal 2006 |
|
|
$ 283,028 |
|
|
|
|
|
|
|
|
|
|
Exepected Fund Bal 2005 |
|
|
$ 339,728 |
|
|
|
|
|
|
|
|
|
|
Fund Bal 2004 |
|
|
$
435,177 |
|
|
|
|
|
|
|
|
|
|
Un. Res. Fund Balance 03 |
|
|
$
428,529 |
|
|
|
|
|
|
|
|
|
|
FUND BALANCE 9/30/2002 |
|
|
$
461,137 |
|
|
|
|
|
|
|
|
|
|
FUND BALANCE 9/30/2001 |
|
|
$
198,236 |
|
|
|
|
|
|
|
|
|
|
FUND BALANCE 9/30/2000 |
|
|
$
284,841 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
note 1:
recommend increasing Loraines Pay grade from 10 to 11 |
|
|
|
|
|
|
|
|
|
note 2: fire
station phones where included here but moved to 203 account, courthouse
security phones added |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|