BUDGET
WORKSHEET FISCAL YEAR |
2005 |
|
|
|
Rev |
|
|
|
|
|
|
215.E911 Fund |
|
11 |
|
|
|
|
|
|
Month |
|
DEPARTMENT |
ADMINISTATOR |
COMMISION |
Percent |
|
|
Actual |
Actual |
Actual |
Actual |
Project |
Budget |
REQUEST |
RECOMMENDED |
APPROVED |
Change |
|
|
2001 |
2002 |
2003 |
2004 |
2004 |
2004 |
2005 |
2005 |
2005 |
2004-05 |
Revenues |
|
|
|
Sale of Maps & Publications |
34.1930 |
605 |
419 |
315 |
165 |
165 |
500
|
300 |
300 |
300 |
-40% |
Alltel |
34.2501 |
7,976
|
6,651
|
7,812
|
7,452
|
7,452
|
15,600
|
7,500
|
7,500
|
7,500
|
-52% |
Bellsouth |
34.2502 |
23,977
|
11,913
|
21,231
|
18,622
|
21,000
|
29,400
|
21,000
|
21,000
|
21,000
|
-29% |
Hart
Telephone |
34.2503 |
116,797
|
157,532
|
128,956
|
113,298
|
113,000
|
158,000
|
120,000
|
120,000
|
120,000
|
-24% |
Alltel Comm |
34.2505 |
6,689
|
9,336
|
6,440
|
4,968
|
5,000
|
150
|
5,000
|
5,000
|
5,000
|
3233% |
AT&T
Cell |
34.2506 |
101 |
237 |
97 |
96 |
105 |
150
|
105 |
105 |
105 |
-30% |
Cingular Wireless |
34.2507 |
34,165
|
45,068
|
9 |
17,857
|
18,000
|
92,400
|
18,000
|
18,000
|
18,000
|
-81% |
Bellsouth Corp |
34.2508 |
|
11,923
|
4,778
|
4,656
|
4,656
|
|
4,700
|
4,700
|
4,700
|
|
Bellsouth Mobility |
34.2509 |
2,365
|
4,793
|
33,934
|
34,823
|
34,822
|
|
35,000
|
35,000
|
35,000
|
|
Sprint Spec |
34.2510 |
520 |
596 |
313 |
|
- |
700
|
|
-100% |
Triton Pcs |
34.2511 |
198 |
2,186
|
1,263
|
610 |
610 |
2,800
|
600 |
600 |
600 |
-79% |
Verizon |
34.2512 |
4,056
|
6,357
|
5,819
|
11,383
|
11,383
|
7,600
|
12,000
|
12,000
|
12,000
|
58% |
Access Intergrated Network |
34.2514 |
88 |
17,647
|
728 |
|
- |
900
|
|
-100% |
Cellco Partnership |
34.2515 |
232 |
|
299 |
485 |
529 |
|
400 |
400 |
400 |
|
New South |
34.2516 |
|
151 |
122 |
75 |
75 |
|
75 |
75 |
75 |
#DIV/0! |
Nextel |
34.2517 |
|
478 |
475 |
680 |
680 |
500
|
680 |
680 |
680 |
36% |
TriTel |
34.2518 |
|
3 |
202 |
|
- |
|
#DIV/0! |
Trac phone |
34.2519 |
|
2,866
|
447 |
450 |
1,500
|
450 |
450 |
450 |
|
T Mobile |
34.2520 |
|
113 |
204 |
223 |
|
225 |
225 |
225 |
|
Z-Tel |
34.2521 |
|
224 |
124 |
135 |
|
135 |
135 |
135 |
|
Vartec |
34.2522 |
|
52 |
61 |
67 |
|
70 |
70 |
70 |
|
Tax Partners |
34.2523 |
|
17,666
|
|
|
sprint |
34.2524 |
|
145 |
640 |
|
640 |
640 |
640 |
|
triton |
34.2525 |
|
282 |
443 |
|
450 |
450 |
450 |
|
Athens cell |
34.2526 |
|
59 |
698 |
|
700 |
700 |
700 |
|
onstar |
34.2527 |
|
56 |
99 |
|
100 |
100 |
100 |
|
Interest/Investments/escrow |
|
7,866
|
35,202
|
8,041
|
2,646
|
2,887 |
4,000
|
2,800
|
2,800
|
2,800
|
-30% |
|
39.1100 |
|
|
29,200
|
|
|
|
|
|
|
|
Total Revenues |
|
205,635
|
310,492
|
271,497
|
220,532
|
221,238 |
314,200
|
230,930
|
230,930
|
230,930
|
-27% |
|
|
|
|
|
Expenditures |
|
|
|
|
Regular employees |
51.1100 |
17,768
|
19,646
|
27,668
|
83,450
|
91,036 |
133,615
|
138,053
|
138,053
|
138,053
|
3% |
Group insurance |
51.2100 |
2,488
|
3,194
|
2,730
|
7,214
|
7,870 |
15,770
|
16,000
|
16,000
|
16,000
|
1% |
FICA |
51.2200 |
1,359
|
1,400
|
1,995
|
5,276
|
5,756 |
10,222 |
10,561 |
10,561 |
10,561
|
3% |
Retirement contributions |
51.2400 |
240 |
211 |
310 |
298 |
325 |
1,000
|
1,000
|
1,000
|
1,000
|
0% |
|
|
|
|
Maint/E911 System |
52.1010 |
90,957
|
48,143
|
|
8,000
|
8,000
|
14,000
|
14,000
|
14,000
|
75% |
Access Charges -Hart Telco |
52.1011 |
|
1,385
|
4,300
|
3,870
|
4,222 |
5,160
|
5,160
|
5,160
|
5,160
|
0% |
ANI Charges - Hart Telco |
52.1012 |
|
11,222
|
48,042
|
42,390
|
57,000
|
57,000
|
57,000
|
57,000
|
57,000
|
0% |
ANI/ALI Charges Bell South |
52.1013 |
|
1,040
|
12,480
|
9,385
|
10,238 |
12,500
|
12,500
|
12,500
|
12,500
|
0% |
Extended ALI Bell South |
|
|
4,600
|
4,600
|
4,600
|
|
ANI/ALI Charges Alltel |
52.1014 |
|
637 |
7,668
|
5,100
|
5,564 |
7,700
|
7,700
|
7,700
|
7,700
|
0% |
E911 Data Base Updates-Hart
Telco |
52.1015 |
|
23,644
|
11,222
|
|
- |
|
#DIV/0! |
Cingular Wireless |
52.1016 |
|
8,209
|
3,965
|
2,745
|
2,995 |
3,400
|
4,000
|
4,000
|
4,000
|
18% |
Verizon |
52.1017 |
|
1,123
|
1,225 |
1,200
|
3,600
|
3,600
|
3,600
|
200% |
AT&T
Cell |
|
|
- |
|
|
Sprint Spec |
|
|
- |
|
|
Triton Pcs |
|
|
- |
|
|
Weather Service |
52.1020 |
|
1,018
|
1,056
|
1,056
|
1,056
|
1,056
|
1,056
|
1,056
|
1,056
|
0% |
Other professional svcs |
52.1210 |
1,245
|
578 |
|
500
|
500 |
|
-100% |
Disposal |
52.2110 |
255 |
525 |
634 |
579 |
632 |
830
|
830 |
830 |
830 |
0% |
Maint |
52.2200 |
|
280 |
|
- |
3,400
|
3,400
|
3,400
|
3,400
|
0% |
Pest control |
52.2205 |
670 |
|
35 |
|
- |
|
#DIV/0! |
Outside Labor |
52.2206 |
|
487 |
|
500
|
500 |
500 |
500 |
0% |
Communications/telephone |
52.3200 |
14,685
|
25,398
|
22,752
|
18,371
|
27,600
|
27,600
|
27,600
|
27,600
|
27,600
|
0% |
Postage |
52.3210 |
102 |
69 |
73 |
34 |
500 |
500
|
500 |
500 |
500 |
0% |
Printing & Binding |
52.3400 |
|
50
|
|
-100% |
Travel |
52.3500 |
328 |
533 |
223 |
172 |
500 |
500
|
1,000
|
600 |
600 |
20% |
Dues and Fees |
52.3600 |
|
150 |
|
95 |
120 |
120
|
120 |
120 |
120 |
0% |
Training |
52.3700 |
|
155 |
600 |
600
|
600 |
600 |
600 |
0% |
Energy |
53.1200 |
2,564
|
13,587
|
10,923
|
11,168
|
12,183 |
15,500
|
15,500
|
15,000
|
15,000
|
-3% |
Office supplies |
53.1710 |
2,789
|
1,289
|
818 |
713 |
1,500
|
1,500
|
1,500
|
1,500
|
1,500
|
0% |
Parts |
53.1750 |
|
274 |
90 |
200 |
1,000
|
1,000
|
500 |
500 |
-50% |
signs |
53.1720 |
|
2,093
|
|
|
Gasoline |
53.1790 |
130 |
|
- |
|
#DIV/0! |
UHF Radio/Ant |
|
|
- |
|
|
Recording System |
|
|
- |
|
|
Machinery and Equipment |
54.2000 |
|
820 |
1,252
|
2,554
|
5,000
|
5,000
|
|
-100% |
computers |
54.2400 |
|
29,879
|
409 |
|
|
|
54.2410 |
|
7,955
|
|
|
Principal |
58.1000 |
|
47,266
|
151,887
|
|
#DIV/0! |
Interest |
58.2000 |
|
8,608
|
9,008
|
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
Total Expenditures |
|
135,580 |
251,311 |
327,679 |
195,838 |
244,121 |
314,223 |
328,280 |
326,380 |
326,380 |
4% |
|
|
|
|
|
|
|
|
|
REVENUES MINUS EXPENDITURES |
|
(86,605) |
262,901
|
(56,182) |
24,694
|
(22,883) |
(23) |
(97,350) |
(95,450) |
(95,450) |
|
|
|
|
|
|
|
|
NOTE NEED 2003 AUDIT
TO DETERMINE WHAT ACTUAL REVENUES ARE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|