|
| |
2009 Payroll - Bills - Balance
Spreadsheet
| Payroll - Bills- Balances |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
31-Dec-08 |
January |
February |
March |
April |
May |
|
June |
| General Fund Bal. |
|
|
23,688 |
|
4,318 |
|
88,215 |
|
360,056 |
|
425,998 |
|
424,721 |
470,930 |
| Liq. Fuel Fund Bal |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Expenses |
|
48,313 |
48,313 |
55,134 |
103,447 |
89,189 |
192,636 |
52,557 |
245,193 |
64,001 |
309,194 |
|
55,695 |
364889 |
| Income |
|
72,001 |
72,001 |
35,764 |
107,765 |
173,086 |
280,851 |
324,398 |
605,249 |
129,943 |
735,192 |
|
100,627 |
835819 |
| Gen. Fund Bills |
|
27,417 |
|
33,047 |
|
68,834 |
|
34,711 |
|
25,275 |
|
|
34710 |
|
| Liq. Fuel Bills |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll# |
|
Pay 1 |
Pay 2 |
Pay 3 |
Pay 4 |
Pay 5 |
Pay 6 |
Pay 7 |
Pay 8 |
Pay 9 |
Pay 10 |
Pay 11 |
Pay 12 |
Pay 13 |
| Road Crew |
|
5,219 |
8,140 |
8,140 |
4,921 |
5,732 |
4,770 |
4,770 |
4,999 |
4,846 |
4,770 |
4,831 |
4,770 |
4,831 |
| Office Staff |
|
2,612 |
2,686 |
2,549 |
2,567 |
2,761 |
3,269 |
6,192 |
3,259 |
3,269 |
9,105 |
3,079 |
4,203 |
3,557 |
| Supervisors |
|
|
1,000 |
0 |
500 |
|
1,300 |
|
1,300 |
|
|
500 |
|
900 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
7,831 |
11,826 |
10,689 |
7,988 |
8,493 |
9,339 |
10,962 |
9,558 |
8,115 |
13,875 |
8,410 |
8,973 |
9,288 |
| Monthly Pay Total |
|
19,657 |
|
18,676 |
|
17,832 |
|
20,520 |
|
30,400 |
|
|
18,261 |
|
|
Supervisor Meeting |
July |
August |
September |
October |
November |
December |
|
General Fund |
|
466,217 |
|
438,596 |
|
474,476 |
|
382,579 |
|
368,522 |
|
-109,128 |
|
|
|
Liquid Fuels Fund |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Expenses |
65,024 |
429,913 |
95,053 |
524,966 |
53,860 |
578,825 |
139,240 |
718,065 |
88,378 |
806,443 |
|
1,331,389 |
|
|
|
Income |
60,311 |
896,130 |
67,432 |
963,562 |
89,739 |
1,053,301 |
47,343 |
1,100,644 |
74,320 |
1,174,964 |
191,798 |
1,222,261 |
|
|
|
Bills - General Fund |
78,977 |
|
37,532 |
|
93,706 |
|
90,794 |
|
93,709 |
|
53,795 |
|
|
|
|
Bills - Liquid Fuels |
|
|
|
|
|
|
|
|
|
Transfers |
|
|
|
|
|
|
|
|
|
|
425,000 |
|
|
|
|
Payroll# |
Pay 14 |
Pay 15 |
Pay 16 |
Pay 17 |
Pay 18 |
Pay19 |
Pay 20 |
Pay 21 |
Pay 22 |
Pay 23 |
Pay 24 |
Pay 25 |
Pay 26 |
Pay 27 |
|
Road Crew |
4,770 |
4,831 |
4,770 |
4,891 |
4,770 |
5,146 |
4,951 |
4,770 |
4,898 |
4,978 |
4,831 |
4,770 |
6,581 |
0 |
|
Office Staff |
3,460 |
3,338 |
3,531 |
3,297 |
3,277 |
3,300 |
2,937 |
3,169 |
3,369 |
3,260 |
3,495 |
3,239 |
3,493 |
752 |
|
Supervisors |
|
400 |
|
500 |
|
|
400 |
500 |
|
0 |
0 |
900 |
0 |
900 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Payroll |
8,230 |
8,569 |
8,301 |
8,688 |
8,048 |
8,446 |
8,288 |
8,439 |
8,267 |
8,237 |
8,326 |
8,909 |
10,074 |
1,652 |
|
Monthly Pay Total |
16,799 |
|
16,989 |
|
16,493 |
|
16,727 |
|
16,504 |
|
28,961 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Transfers |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
300,000 |
Equipment Fund |
|
|
|
|
|
|
|
|
|
|
|
|
|
125,000 |
Slide Fund |
|

Dec
2009
Includes transfer of
$325,000 to
equipment fund &
$125,000
to slide fund

|