|
CITY OF SONORA |
|
|
||||||
|
BUDGET WORKSHEET |
|
|
||||||
|
FOR YEAR ENDING SEPTEMBER 30, 2011 |
|
|
||||||
|
|
RECAP |
|
|
|
$0.04 TAX INCREASE (.5100) |
|||
|
|
|
2006-07 |
2007-08 |
2008-09 |
2009-10 |
2010-11 |
INCREASE |
|
|
10 -GENERAL
FUND |
|
ACTUAL |
ACTUAL |
ACTUAL |
AMENDED |
BUDGET |
(DECREASE) |
|
|
RECAP |
Pg |
AUDITED |
AUDITED |
AUDITED |
BUDGET |
REQUEST |
OVER 2009-10 |
COMMENTS |
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUE |
1 |
2,054,954 |
2,068,486 |
1,797,809 |
1,609,850 |
1,646,331 |
36,481 |
|
|
OPERATING EXPENDITURES |
1 |
1,559,435 |
1,679,104 |
1,670,087 |
1,687,620 |
1,652,685 |
(34,935) |
|
|
OPERATING SURPLUS (DEFICIT) |
|
495,519 |
389,382 |
127,722 |
(77,770) |
(6,354) |
71,416 |
|
|
CAPITAL OUTLAY EXPENDITURES |
1 |
111,207 |
103,704 |
342,231 |
2,000 |
73,000 |
71,000 |
|
|
SURPLUS BEFORE TRANSFERS |
|
384,312 |
285,678 |
(214,509) |
(79,770) |
(79,354) |
416 |
|
|
TRANSFERS IN (OUT) |
1 |
(30,085) |
(33,500) |
(108,000) |
(21,000) |
80,062 |
101,062 |
|
|
NET SURPLUS (DEFICIT) |
|
354,227 |
252,178 |
(322,509) |
(100,770) |
708 |
101,478 |
|
|
CASH AT 9/30/10 |
|
|
|
|
|
947,230 |
|
|
|
PROJECTED CASH 9/30/11 |
|
|
|
|
|
947,938 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2006-07 |
2007-08 |
2007-08 |
2009-10 |
2010-11 |
INCREASE |
|
|
11
-FORFEITED PROPERTY |
|
ACTUAL |
ACTUAL |
ACTUAL |
AMENDED |
BUDGET |
(DECREASE) |
|
|
RECAP |
Pg |
AUDITED |
AUDITED |
AUDITED |
BUDGET |
REQUEST |
OVER 2009-10 |
COMMENTS |
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUE |
17 |
40 |
621 |
- |
626 |
1,115 |
489 |
|
|
OPERATING EXPENDITURES |
17 |
- |
- |
- |
626 |
- |
(626) |
|
|
OPERATING SURPLUS (DEFICIT) |
|
40 |
621 |
- |
- |
1,115 |
1,115 |
|
|
TRANSFERS IN (OUT) |
17 |
(1,415) |
- |
- |
- |
- |
- |
|
|
NET SURPLUS (DEFICIT) |
|
(1,375) |
621 |
- |
- |
1,115 |
1,115 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2006-07 |
2007-08 |
2007-08 |
2009-10 |
2010-11 |
INCREASE |
|
|
12 -ST
MAINT SALES TAX |
|
ACTUAL |
ACTUAL |
ACTUAL |
AMENDED |
BUDGET |
(DECREASE) |
|
|
RECAP |
Pg |
AUDITED |
AUDITED |
AUDITED |
BUDGET |
REQUEST |
OVER 2009-10 |
COMMENTS |
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUE |
19 |
151,351 |
189,382 |
115,684 |
80,000 |
87,500 |
7,500 |
|
|
OPERATING EXPENDITURES |
19 |
- |
- |
- |
37,000 |
35,000 |
(2,000) |
|
|
OPERATING SURPLUS (DEFICIT) |
|
151,351 |
189,382 |
115,684 |
43,000 |
52,500 |
9,500 |
|
|
CAPITAL OUTLAY EXPENDITURES |
19 |
- |
- |
- |
- |
100,000 |
100,000 |
|
|
NET SURPLUS (DEFICIT) |
|
151,351 |
189,382 |
115,684 |
43,000 |
(47,500) |
(90,500) |
|
|
CASH AT 9/30/10 |
|
|
|
|
|
366,000 |
|
|
|
PROJECTED CASH 9/30/11 |
|
|
|
|
|
318,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2006-07 |
2007-08 |
2007-08 |
2009-10 |
2010-11 |
INCREASE |
|
|
20 -AIRPORT
FUND |
|
ACTUAL |
ACTUAL |
ACTUAL |
AMENDED |
BUDGET |
(DECREASE) |
|
|
RECAP |
Pg |
AUDITED |
AUDITED |
AUDITED |
BUDGET |
REQUEST |
OVER 2009-10 |
COMMENTS |
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUE |
21 |
67,811 |
102,120 |
101,261 |
46,850 |
148,862 |
102,012 |
|
|
OPERATING EXPENDITURES |
21 |
155,185 |
172,935 |
132,283 |
121,960 |
124,800 |
2,840 |
|
|
OPERATING SURPLUS (DEFICIT) |
|
(87,374) |
(70,815) |
(31,022) |
(75,110) |
24,062 |
99,172 |
|
|
TRANSFERS IN (OUT) |
21 |
31,500 |
33,500 |
108,000 |
21,000 |
24,938 |
3,938 |
|
|
NET SURPLUS (DEFICIT) |
|
(55,874) |
(37,315) |
76,978 |
(54,110) |
49,000 |
103,110 |
|
|
OTHER CASH FLOW SOURCES (USES) |
21 |
55,568 |
47,253 |
48,513 |
53,000 |
(49,000) |
(102,000) |
|
|
NET CASH FLOW |
|
(306) |
9,938 |
125,491 |
(1,110) |
- |
1,110 |
|
|
CASH AT 9/30/10 |
|
|
|
|
|
890 |
|
|
|
PROJECTED CASH 9/30/11 |
|
|
|
|
|
890 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2006-07 |
2007-08 |
2007-08 |
2009-10 |
2010-11 |
INCREASE |
|
|
30 -WATER
FUND |
|
ACTUAL |
ACTUAL |
ACTUAL |
AMENDED |
BUDGET |
(DECREASE) |
|
|
RECAP |
Pg |
AUDITED |
AUDITED |
AUDITED |
BUDGET |
REQUEST |
OVER 2009-10 |
COMMENTS |
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUE |
25 |
707,321 |
829,408 |
904,147 |
885,710 |
939,000 |
53,290 |
|
|
OPERATING EXPENDITURES |
25 |
553,189 |
565,856 |
644,061 |
676,780 |
643,497 |
(33,283) |
|
|
OPERATING SURPLUS (DEFICIT) |
|
154,132 |
263,552 |
260,086 |
208,930 |
295,503 |
86,573 |
|
|
TRANSFERS IN (OUT) |
25 |
(3,920) |
- |
- |
- |
(111,000) |
(111,000) |
|
|
NET SURPLUS (DEFICIT) |
|
150,212 |
263,552 |
260,086 |
208,930 |
184,503 |
(24,427) |
|
|
OTHER CASH FLOW SOURCES (USES) |
25 |
- |
(700) |
114,704 |
(83,210) |
(112,300) |
(29,090) |
|
|
NET CASH FLOW |
|
150,212 |
262,852 |
374,790 |
125,720 |
72,203 |
(53,517) |
|
|
CASH AT 9/30/10 |
|
|
|
|
|
1,682,720 |
|
|
|
PROJECTED CASH 9/30/11 |
|
|
|
|
|
1,754,923 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2006-07 |
2007-08 |
2007-08 |
2009-10 |
2010-11 |
INCREASE |
|
|
40 -SEWER
FUND |
|
ACTUAL |
ACTUAL |
ACTUAL |
AMENDED |
BUDGET |
(DECREASE) |
|
|
RECAP |
Pg |
AUDITED |
AUDITED |
AUDITED |
BUDGET |
REQUEST |
OVER 2009-10 |
COMMENTS |
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUE |
31 |
653,668 |
669,581 |
728,772 |
751,500 |
769,600 |
18,100 |
|
|
OPERATING EXPENDITURES |
31 |
620,861 |
535,907 |
652,035 |
532,130 |
729,651 |
197,521 |
|
|
OPERATING SURPLUS (DEFICIT) |
|
32,807 |
133,674 |
76,737 |
219,370 |
39,949 |
(179,421) |
|
|
TRANSFERS IN (OUT) |
31 |
3,920 |
- |
- |
- |
111,000 |
111,000 |
|
|
NET SURPLUS (DEFICIT) |
|
36,727 |
133,674 |
76,737 |
219,370 |
150,949 |
(68,421) |
|
|
OTHER CASH FLOW SOURCES (USES) |
31 |
- |
(500) |
(116,201) |
(320,000) |
(150,000) |
170,000 |
|
|
NET CASH FLOW |
|
36,727 |
133,174 |
(39,464) |
(100,630) |
949 |
101,579 |
|
|
CASH AT 9/30/10 |
|
|
|
|
|
55,370 |
|
|
|
PROJECTED CASH 9/30/11 |
|
|
|
|
|
56,319 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2006-07 |
2007-08 |
2007-08 |
2009-10 |
2010-11 |
INCREASE |
|
|
50
-SANITATION FUND |
|
ACTUAL |
ACTUAL |
ACTUAL |
AMENDED |
BUDGET |
(DECREASE) |
|
|
RECAP |
Pg |
AUDITED |
AUDITED |
AUDITED |
BUDGET |
REQUEST |
OVER 2009-10 |
COMMENTS |
|
|
|
|
|
|
|
|
|
|
|
OPERATING REVENUE |
36 |
488,925 |
535,156 |
557,222 |
532,500 |
531,000 |
(1,500) |
|
|
OPERATING EXPENDITURES |
36 |
458,338 |
500,594 |
681,420 |
597,325 |
522,675 |
(74,650) |
|
|
OPERATING SURPLUS (DEFICIT) |
|
30,587 |
34,562 |
(124,198) |
(64,825) |
8,325 |
73,150 |
|
|
TRANSFERS IN (OUT) |
36 |
- |
- |
- |
- |
(105,000) |
(105,000) |
|
|
NET SURPLUS (DEFICIT) |
|
30,587 |
34,562 |
(124,198) |
(64,825) |
(96,675) |
(31,850) |
|
|
OTHER CASH FLOW SOURCES (USES) |
36 |
- |
- |
3,927 |
6,200 |
6,200 |
- |
|
|
NET CASH FLOW |
|
30,587 |
34,562 |
(120,271) |
(58,625) |
(90,475) |
(31,850) |
|
|
CASH AT 9/30/10 |
|
|
|
|
|
96,375 |
|
|
|
PROJECTED CASH 9/30/11 |
|
|
|
|
|
5,900 |
|
|