Loading...
HomeMy WebLinkAbout12-020 CC Resolution RESOLUTION NO. 12-20 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF TEMECULA AMENDING THE FISCAL YEAR 2011-12 ANNUAL OPERATING BUDGET THE CITY COUNCIL OF THE CITY OF TEMECULA DOES HEREBY RESOLVE AS FOLLOWS: Section 1. The purpose of this review is to conduct an analysis of revenues and expenditures to ensure that the City maintains a prudent and healthy fiscal position. Section 2. That each year a mid-year review is conducted of City operating budgets. Section 3. That the mid-year review has been completed and the recommended adjustments are reflected in the attached schedules for the City's General Fund, Special Revenue and Internal Service Funds. Section 4. That the Fiscal Year 2011-12 General Fund Annual Operating Budget is hereby amended in accordance with the attached, hereto as Exhibit A, General Fund Mid-Year Budget. Section 5. That the Fiscal Year 2011-12 Gas Tax, State Transportation, Recovery Act JAG Funding, Energy Efficiency Conservation Block Grant, Community Development Block Grant, AB 2766, Law Enforcement, Measure A, Debt Service Fund — Civic Center COPs and 2011 Financing Lease 2001 and 2008 COPs Annual Operating Budget are hereby amended in accordance with the attached, hereto as Exhibit B, Gas Tax, State Transportation, Recovery Act JAG Funding, Energy Efficiency Conservation Block Grant, Community Development Block Grant, AB 2766, Law Enforcement, Measure A, Debt Service Fund — Civic Center COPs and 2011 Financing Lease 2001 and 2008 COPs Fund Mid-Year Budget. Section 6. That the Fiscal Year 2011-12 Internal Service Funds Budgets are hereby amended in accordance with the attached, hereto as Exhibit C, Internal Service Funds Mid-Year Budget. Section 7. The City Clerk shall certify adoption of the resolution. R:/Resos 2012/Resos 12-20 1 PASSED, APPROVED, AND ADOPTED by the City Council of the City of Temecula this 28th day of February, 2012. , J .;/, i � : � /' � � � `,� � ,� ,� ___ uck Washington, Mayor ATTEST: � Susan W Jon s, MMC ity� CI [S EAL] R:/Resos 2012/Resos 12-20 2 STATE OF CALIFORNIA ) � . COUNTY OF RIVERSIDE ) ss CITY OF TEMECULA ) I, Susan W. Jones, MMC, City Clerk of the City of Temecula, do hereby certify that the foregoing Resolution No. 12-20 was duly and regularly adopted by the City Council of the City of Temecula at a meeting thereof held on the 28th day of February, 2012, by the following vote: AYES: 5 COUNCIL MEMBERS: Comerchero, Edwards, Naggar, Roberts, Washington NOES: 0 COUNCIL MEMBERS: None ABSENT: 0 COUNCIL MEMBERS: None ABSTAIN: 0 COUNCIL MEMBERS: None Susan W Jones, MMC City Clerk R:/Resos 2012/Resos 12-20 3 T ,�'„� , � ,� ' °.-..� �`� `y,��. ..�.w,,:� �� r � � ,� ����� � .,. � ° �� � �;� �� � ��°k� � t . � ,�.� �� . ' � � �� JN $�n a p�� . .r, ,��"�"�.�r�r . � a, �t 't � �'?� ` � m °rss .�z X�/'n,' , t , : r, ';.sS �� � e ExhibitA � FY 2011-12 Mid-Year Budget General Fund S.� ..rT' �� "'"'^'°- _ � �C'r'f"�y �.°�'� � �u �"� � �....�.,q,��._ . { .F "� y � r»` i. w � IY�� �' �� • ,� `�,.,_. ��,"�'', � ' � `.w �y-+�' �"d. �y r ' ° r�' . . . .. . . ., . _, � - �� �� �tt� ' � . . h .. �O�:n�`r'., , t � = N ��Q.� y� ��.U.r� �s x, �� � s, �, , �� a., r r `�:„�' '"' .� � [�S` Summary of Revenues, Expenditures, and Changes in Fund Balances FY 2011-12 Mid-Year Budget 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 56,210,729 53,990,443 22,817,719 54,134,208 143,765 0.3% Expenditures by Dept: CityCouncil 395,405 449,642 203,561 449,642 - 0.0% CommunitySupport 129,878 134,650 57,424 134,650 - 0.0% CityManager 1,341,835 1,545,282 675,146 1,563,638 18,356 1.2% Economic Development 781,048 733,249 318,553 680,834 (52,415) -7.1% CityClerk 1,104,368 1,142,988 562,232 1,144,766 1,778 02% CityAttorney 906,667 821,300 388,031 821,300 - 0.0% Finance 2,134,051 2,244,070 1,073,396 2,240,249 (3,821) -02% Human Resources 539,305 585,271 292,970 585,271 - 0.0% Planning 1,241,365 1,779,310 722,374 1,963,289 183,979 10.3% Building & Safety 2,167,678 2,078,171 928,465 2,015,848 (62,323) -3.0% Land Development 1,261,480 1,140,885 553,675 1,140,885 - 0.0% Public Works 3,822,203 4,860,234 1,990,322 4,860,234 - 0.0% CIPAdmin 2,175,423 2,238,698 1,119,285 2,238,698 - 0.0°/a Police 20,926,405 21,461,442 10,411,704 21,369,642 (91,800) -0.4% Fire 4,160,971 4,450,282 2,179,946 4,440,282 (10,000) -0.2% Animal Control 344,083 409,160 95,154 329,160 (80,000) -19.6% Non-Departmental: PropertyTaxAdmin 182,729 184,498 221,788 221,788 37,290 202% RESTConVibution 5,391,147 6,807,103 3,663,479 6,207,103 (600,000) -8.8% Retiree Medical Contribution 327,040 327,040 154,088 315,040 (12,000) -3.7% Total E�enditures 49,333,081 53,393,275 25,611,593 52,722,319 (670,956) -1.3% Excess of Revenues Over � (Under) Expenditures 6,877,648 597,168 (2,793,874) 1,411,889 814,721 Operating Transfers Out: 2011 Financing Lease - 2001 & 2008 COPs - - - (688,461) (688,461) Debt Service - Civic Center COPs (1,574,431) (1,578,738) (1,016,599) (1,019,099) 559,639 Bond Call CFD 88-12 (4,769,968) - - - - Total Revenues/Deficit over Debt Service 533,249 (981,570) (3,810,473) (295,671) 685,899 Pavement Management Program - (826,126) - (826,126) - Ciryand Parks Facility Improvements - (750,000) (70,982) (750,000) - Transferto Capital Improvement Fund (13,799,370) (936,215) (239,169) (936,215) - Total CIP Transfers (13,799,370) (2,512,341) (310,151) (2,512,341) - Excess of Revenues Over (Under) Expenditures and Operating Transfers Out (73,266,121) (3,493,911) (4,120,624) (2,808,012) 685,899 ��^ ;�•�� �� �,,> l � -�.W.. �* � ,� "q'�+J . � �x t� ��'� C-�� TflB s �s t �' 1 � � � � � �"1� I � � � � n� ����� � '�� 'rI. ,�`'��W QPAC)BZ'!'�JP1�['FF,.�M Summary of Revenues, Expenditures, and Changes in Fund Balances FY 2011-12 Mid-Year Budget 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current Year to Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Fund Balance, Beg. of Year 45,344,434 32,078,313 32,078,313 32,078,313 - 0.0% Revenues 56,210,729 53,990,443 22,817,719 54,134,208 143,765 0.3% Expenditures (49,333,081) (53,393,275) (25,611,593) (52,722,319) 670,956 -1.3% Operating Transfers Out: Bond Call CFD 88-12 (4,769,968) - - - - 0.0°/a DebtService-CivicCenterCOPs (1,574,431) (1,578,738) (1,016,599) (1,019,099) 559,639 -35.4% Debt Service - 2011 Financing Lease - - - (688,461) (688,461) 0.0% Transfer to Capitai Improvement Fund (13,799,370) (936,215) (239,169) (936,215) - 0.0% Pavement Manageme� Program - (826,126) - (826,126) - 0.0% Cityand Park Facilities hnprovements - (750,000) (70,982) (750,000) - 0.0% EstimatedBudgetSavings - 1,500,000 1,500,000 900,000 (600,000) -40.0% Fund Balance, End of Year 32,078,313 30,084,402 29,457,689 30,170,301 85,899 0.3% Detail of Fund Balance: Reserved for long-term advance to RDA 468,199 - - - - 0.0% Reserved for deposits and prepaid items 117,807 39,540 39,540 39,540 - 0.0% Reserved for inventory 3,058 3,058 3,058 3,058 - 0.0% Reserved for encumbrances 139,841 - - - - 0.0% Unreserved: Designated foreconomic uncertainty (20%ofAppropriations) 10,642,975 10,678,655 10,678,655 10,544,464 (134,191) -1.3% Secondarydesignated fund balance reserve 9,608,580 8,295,511 7,668,798 8,515,601 220,090 2.7% Designated for comprehensive annual leave 1,460,068 1,429,853 1,429,853 1,429,853 - 0.0% Designated for Dutch Villages 150,000 150,000 150,000 150,000 - 0.0% Designated forfuture CIP: Various CIP Projects 564,030 564,030 564,030 564,030 - 0.0% Pavement Managemerrt 5,010,000 5,010,000 5,010,000 5,010,000 - 0.0% Cityand Park Facilities Improvements 750,000 750,000 750,000 750,000 - 0.0% TheaterConstruction 2,879,175 2,879,175 2,879,175 2,879,175 - 0.0% Designated for unrealized gains 284,580 284,580 284,580 284,580 - 0.0% 32,078,313 30,084,402 29,457,689 30,170,301 85,899 0.3% �± �, �.� ,�' '.'� . "'s""� % r �"� � '�'�'C`" y.. i � ��� ��� (�, • ..,,�� � � .s��ct� ., ` . , Y ' . ��.. °- �....�.� � +*R �f�C� � µ r �} ux�� `6f '�%%, �. �"�+� �s s� ;k',++.,�.f f ?`w"� r "� f 1 °� ,Y. �,�, h ,..y.sn.. ,,���°r �:'. � � � �� �: a ,4v1e.i {� ��� General Fund Revenue Detail FY 2011-12 Mid-Year Operating Budget FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # 190 GENERAL FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE iT61 Planning I -Various 593,619 299,512 660,219 660,219 - 0.00% -Grants 2,585 248,200 248,200 - 0.00% 162 Building 8 Safety. ��-� -Various 1,295,002 534,461 1,331,607 1,133,912 (197,695) -14.85% !163 tand Development -� -Various 896,511 492,590 264,597 664,067 399,470 150.97% '164 Public Works -� -NPDES Pertnit Fee 4,541 752 3,276 3,276 - 0.00% (170 Police �� 4055 -Citations and Bookings 95,030 45,909 110,575 101,750 (8,825) -7.98% 4044+4-Miscellaneous 104,294 50,589 113,565 101,180 (12,385) -10.91% 4067 -Vehicle Impound Fees 135,808 57,764 153,700 115,528 (38.172) -24.84% 4076 -Reimbursements 140,516 80,058 102,500 160,116 57,616 56.21% 4083+4-Grants 78,602 24,750 10,203 71,789 61,586 603.61% 1171 Fire � �� -Various 574,540 325,747 465,730 634,072 168,342 36.15% 4083 -Grants 37,003 13,039 - - - 0.00% 199 Non-Departmental ` 4010 -Property Tax 4,658,241 2,580,665 4,790,858 4,790,858 - 0.00% 4012 -Property Tax (Unsecured) 225,449 233,892 264,425 264,425 - 0.00% 4013 -SupplementaiTax-AB2345 108,403 - 42,140 42,140 - 0.00% 4016 -PropertyTransferTax 433,290 191,486 491,713 409,577 (82,136) -16.70% 4018 -Franchise Fees 3,219,084 1,182,369 3,366,101 3,392,096 25,995 0.77% 4020 -Transient Occupancy Tax 2,168,747 1,183,503 2,204,749 2,447,108 242,359 10.99% 4023 -Sales and Use Tax - Triple Flip 6,470,853 3,299,092 6,130,519 6,459,653 329,134 5.37% 4024 -Sales and Use Tax - State of Calif 18,624,314 6,197,660 19,102,828 19,532,505 429,677 2.25% 4025 -FEMA Grants 210,627 28,406 - 28,406 28,406 0.00% 4028 -Homeowner Property Tax Relief 73,793 11,536 74,582 76,906 2,324 3.12% 4043 -Nbtor Vehicle in Lieu - Triple Flip 5,940,244 2,977,581 5,980,044 5,940,244 (39,800) -0.67% 4046 -Motor Vehicle in Lieu - State of Calif 473,637 51,960 811,085 51,960 (759,125) -93.59% 4047 -Vehicle Code Fines 729,368 300,307 773,508 645,777 (127,731) -16.51% 4053 -Bids 8 Proposals 2,610 4,500 6,300 9,000 2,700 42.86% 4056 -Business Licenses 288,878 52,465 300,000 300,000 - 0.00% 4059 -Right of Way Advertising 25,810 34,830 40,680 67,380 26,700 65.63% Various -Miscellaneous 104,942 25,525 45,572 45,572 - 0.00% 4065 -Investment Interest 314,164 95,028 329,700 200,000 (129,700) -39.34% 4069 -Interest Earnings-RDA Loan Repayment 238,633 - 238,633 - (238,633) -100.00% 4076 -Reimbursements-Miscellaneous 463,073 35,088 42,000 66,000 24,000 57.14% 4076 -Reimbursements - Tribal Gaming Special Distribution Fund 185,000 - - - - 0.00% 4082 -Reimbursements - Redevelopment Agency 110,000 55,000 110,000 110,000 - 0.00% 4083 -Reimbursements-Capital Imprvmnt Prgrm 2,120,354 1,055,601 2,238,698 2,238,698 - 0.00% 4090 Operating Transfer In-Gas Tax 1,907,438 1,298,676 2,879,136 2,879,136 - 0.00% 4090 Operating Transfer In-Prop 42 199,880 - - - - 0.00°/a 4090 Operating Transfer In-Law Enforcement Fund 149,555 11,402 100,000 177,767 77,767 77.77°/a 4400 -Financing Reimbursement 175,000 81,500 163,000 163,000 - 0.00% 4545 -Change in Fair Value of Investments (245,299) (98,109) - (98,109) (98,109) 0.00% 4651 -Settlement 2,879,175 - - - - 0.00% TOTAL GENERAL FUND 56,210,729 22,817,719 53,990,443 54,134,208 143,765 0.27% �. � �,. .:,.� ,, "_� Tr�e�� �' f ��, � � j � - �''` ' � g. `�' `� A �.. ^y.,�. �? �'� .1 �� �� .� �`�m+- �t� � � � t ' 'HC�� � . � :t.. .s , �� ".fl � '!�AAC:?R'�.�i'Et7' S" Exhibit B FY 2011-12 Mid-Year Budget Gas Tax Fund State Transportation Fund Recovery Act JAG Fund Energy Efficiency Conservation Block Grant Fund CDBG Fund AB 2766 Fund Law Enforcement Fund Measure A Fund Debt Service Fund Certificates of Participation (COPs) 2011 Financing Lease 2001 & 2008 COPs ^M �,, ,� •-. �,•—+�--� e .� � �`-�.- � �� .--.-�-... _ r _ ( �,;�TH6 ^ �- � �,1 � _�j�'�� I � �� '. ;-� � , , �,, . ` tY � x �. '�- •,� �• �� ' . '�! � {. ' � �✓. t �QQ .. _ � ' 41'�����{i�a� �;� ��� Y ."O,w T r�o�s �N�w:O��vxr�r�s° Gas Tax Fund 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current YeartoDate Re�ised Increase Irxxease Actuals Budget Achrals Budget (Decrease) (Decrease) Total Re�nern�es 2,597,046 2,601,233 1,313,660 2,687,419 86,186 3.3% Tohal E�endihues - - - - - 0.0% Excess of Revenues O�er (Under) E�endilures 2,597,046 2,601,233 1,313,660 2,687,419 86,186 3.3% Operating Transfers Out: To Vebcle and Equiment Furxi - (113,260) (113,260) (113,260) - 0.0% To General Firid (1,907,438) (2,879,136) (1,298,676) (2,879,136) - 0.0% Excess of Re�enues Ower (Under) E�endiGPes and Operating Transfers Out 689,608 (391,163) (98,276) (304,977) 86,186 -22.0% Fiuid Balance, Beg. ofYear 322,042 1,011,650 1,011,650 1,011,650 Fi.md Balance, End ofYear 1,011,650 620,487 913,374 706,673 � �' F �' . �� �,�T-J'�„�... ' ." � k��� ' ,� y ��� .. � ?+'° �-"b � � �u �� � CJ � 4 t. y '' � I� ��' � - "�' y � .� � .� _ � ,#: � �r�'� � 's' � � .�" !(:► ' �EW {��R7t7N�'1'( � State Transportation Fund 201a11 2011-12 2011-12 2011-12 Proposed % Audited Ci.urertt YeartoDate Revised Uxxease Increase Actuals Budget Achrals Budget (Decrease) (Decrease) Total Re�erxaes 4,478 - - - - 0.0% Total E�endihues - - - - - 0.0% Excess of Re�nenues O�er (Under) E�enditures 4,478 - - - - 0.0% Operating Transfers Out To General Furx1 (199,880) - - - - 0.0% To CIP (1,279,835) - - - - 0.0% Excess of Rereru�es Over (Under) E�enditures and Operating Transfers0ut (1,475,237) - - - - 0.0°/a Fund Balances, Beg. ofYear 1,475,237 - - - Fund Balances, End of Year - - - - ; ���� " �-T---;s �� ...W � �. � � �' � � <,.� t , . . _, � -r T,H�,e e,� ,r, _ � . �. � � : ,_� A� � =��� �, � � � � � � � � � .. x �. r _ , ', k s.:,. E�- cf � ;Y ���.�} ,t ��� � '`!'el`�����.���'�.���1i�M Recovery Act JAG Fund 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current Year to Date Revised Increase Increase Achrals Budget Actuals Budget (Decrease) (Decrease) Total Reeerwes 23,517 73,104 15,215 73,104 - 0.0% Total E�endihires 23,517 73,104 15,215 73,104 - 0.0% Exr:ess of Revenues Over (Under) E�enditures - - - - - 0.0% Fund Balances, Beg. of Year - - - - Fund Balances, End of Year - - - - �- � � ���� � A C ;31../� � �,�°,� Tt�ne �•f � , ���, � �� �' _��''V �, � '�:. ° k .�� � � _ Iri�. :� � r . �; "`Ql:[} • .RAl7 � � �� 17'E 'n Energy Efficiency Conservation Block Grant Fund 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Currer�t Year to Date Revised trKxease Increase Ach�als Budget Actuals Budget (Decrease) (Decrease) Tohal Reeenues 197,217 743,483 4,816 743,483 - 0.0% Total E�enditures 11,183 303,741 2,579 303,741 - 0.0% Excess of Re�enues ONer (Under) E�endihues 186,034 439,742 2,237 439,742 - 0.0% Operating Transfers OuL CIP Fund (186,034) (439,742) (2,237) (439,742) - 0.0% Ezcess of Re�nenues Ouer (Under) E�enditures and Operating Transfers Out - - - - - 0.0% Fund Balances, Beg. of Year - - - - Fiuid Balances, End of Year - - - - � �;r��—._..�.,__ ,.� :� r� .� �� s � ? -� ; Tx � �- � [ � r �� �►� - �' —�� `�' , `� � ;�, �„. � ,�; II�'S.'�f ��` "(�lA, „L Q `� ��' `V fF.s� CDBG Fund 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current Year to Date Re�ised Increase Increase Actuals Budget Acxuals Budget (Decrease) (Decrease) Total Re�enues 468,997 1,025,788 70,459 1,025,788 - 0.0°/a Total E�endihares 44,607 45,310 7,260 45,310 - 0.0% Excess of Re�eriues Over (Urxier) E�endihues 424,390 980,478 63,199 980,478 - 0.0% Operating Transfers Out CIP Fund (424,390) (980,478) (63,199) (980,478) - 0.0% Excess of Re�ern�es O�er (Under) E�endihues and Operating Trdnsfers Out - - - - - 0.0% Fund Balances, Beg. of Year - - - - Fund Balances, End of Year - - - - . ,_ �_������ � =-� � � '�I_ � ...� q ��* � } � � � � �,s. . C"�*:� i � ° k '� � �� �E �� / �`� ,. � �'� � . ' v'z +� , ' � '� _ . . .��'� +� �� N �� , n .� . ' - �'-� , ' .:�.,=���.%..� ... ;,'„�:; . ...:-- .. ..% .-< , ��,�, �..>:� ' � �.:.: �� _ �. , , ���{�i.Q � � CP.IQ� � � ka'� � t � S.; AB 2766 Fund 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current Yearto Date Revised hicrease Increase Achials Budget Actuals Budget (Decrease) (Decrease) Total Re�ern�es 119,102 129,557 39,150 129,057 (500) -0.4% Tohal E�endihues 10,000 24,000 1,636 27,000 3,000 12.5% E�ess of Re�nern�es Over (Under) E�enditures 109,102 105,557 37,514 102,057 (3,500) -3.3% Operating Transfers Out To CIP Furld - (651,216) (478,698) (651,216) - 0.0% To General Fiaid (10,000) - - - - 0.0% E�ess of Re�nenues Over (Under) E�enditures and Operating Tr22r1Sfer50ut 99,102 (545,659) (441,184) (549,159) (3,500) 0.6% Fund Balances, Beg. of Year 541,637 640,739 640,739 640,739 Fund Balances, End of Year 640,739 95,080 199,555 91,580 , �. ,� � , j^ C , T-�,°.-'°'�`-- .r ,_ � - t. --w_-_ �� � , � � T - " � � . � , 1 , . t° � � �`�` r < a� , � xa �� ,,,,� � � ,� -�� . ' .�Gr� . ; � '. _ INC 89� u ; �-�, � � ��� ' �,OL[) { � � 'ORPC) � t'C� S�� Law Enforcement Fund 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Currer�t YeartoDate Re�rised Increase Increase Achials Budget Achials Budget (Decrease) (Decrease) Tohal Re�enues 149,554 100,000 11,402 177,767 77,767 77.8% Tohal E�enditures - - - - - 0.0°/a E�ess of Reveiu�es Over (Under) E�enditures 149,554 100,000 11,402 177,767 77,767 77.8% Operating Trarufers Out To General Fiaid (149,554) (100,000) (11,402) (177,767) (77,767) 77.8% Ezcess of Revenues Ouer (Under) E�enditures and Operating Transfers Out - - - - - 0.0% Fund Balances, Beg. of Year - - - - Fund Balances, End of Year - - - - �� �--.. � �� ��----- =.,,...,,. ,� C— r� TM Ttiie �� � � � �� '�; ►� �11.i� '`�- ` `"� � � ��� _ �� � e��P � � f' — � �, , ."C�I,A �I'NA17�1'ION3 =N�Y :OF' N " , Measure A Fund 201a11 2011-12 2011-12 2011-12 Proposed % Audited C�urer�t YeartoDate Revised Increase hicrease Actuals Budget Achials Budget (Decrease) (Decrease) Total Re�erwes 2,287,497 2,222,503 926,155 2,301,239 78,736 3.5% Total E�enditures 660,507 869,242 528,825 869,242 - 0.0% E�ess of Re�enues Orer (Under) E�endihues 1,626,990 1,353,261 397,330 1,431,997 78,736 5.8% Operating Transfers Out: (177,625) (9,390,864) (2,724,369) (9,390,864) - 0.0% Excess of Revenues O�ner (Under) E�endih�res and Operating TransfersOut 1,449,365 (8,037,603) (2,327,039) (7,958,867) 78,736 -1.0°/a Fund Balances, Beg. of Year 7,360,637 8,810,002 8,810,002 8,810,002 Fund Balances, End of Year 8,810,002 772,399 6,482,963 851,135 �,, .� „ �"� � � ---`d` �` � y ��� THe �' = �"'°� � �. �`�' � � �� � � � `� � , � ' 1C � ` � �' � � .� - � . � � , , f �;, " '�-,t k. � ;� f, r�'' r :��r� ' �y � $ „".(��.n ��"i�nrrcotv`s���w:+���iim�tr� , es" Debt Service Fund—Civic Center COPs 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Currerrt YeartoDate Revised Increase Increase Actuals Budget Achials Budget (Decrease) (Decrease) Total Reverxies 5,535 - 1,262 1,262 1,262 0.0% u Total E�enditures 1,577,288 24,274,969 24,510,562 24,513,062 238,093 1.0% E�ess of Re�nenues O�ner (Under) E�enditures (1,571,753) (24,274,969) (24,509,300) (24,511,800) (236,831) 1.0% Operating Transfers In: 2011 FirranCing Lease (395) 22,696,231 22,696,231 22,696,231 - 0.0% Generdl Fund 1,574,431 1,578,738 1,016,599 1,019,099 (559,639) 0.0% Ez�ess of Re�enues Over (Under) E�endihues and Operating Tr2nsfeB Out 2,678 - (796,470) (796,470) (796,470) 0.0% Fimd Balances, Beg. of Year 793,792 796,470 796,470 796,470 Fund Balances, End of Year 796,470 796,470 - - �. �,.�'- - � - -•-.;.�. ` = , .� �- � ,�* � � > . ,- Ttte .� . r . � � � � : � �, � , :� g ` � �'.3 '� �� � � ���C �4? .a,��, - �v ��,; ° ��Q1.Dx�'� ` I °���1N � fTtES° 2011 Financing Lease 2001 & 2008 COPs 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current YeartoDate Re�ised Increase Increase Achrals Budget Actuals Budget (Decrease) (Decrease) Total Revernaes - 26,835,001 26,835,000 26,835,001 - 0.0% Total E�endihires - 208,779 198,764 897,240 688,461 329.8% Excess of Re�enues Over (Under) E�enditures - 26,626,222 26,636,236 25,937,761 (688,461) -2.6% Operating Transfers W(Out): From General Fund - - - 688,461 688,461 0.0% To 2001 COPs (TCSD) - (3,929,991) (3,929,991) (3,929,991) - 0.0% To 2008 COPs (City) - (22,696,231) (22,696,231) (22,696,231) - 0.0°/a Ezcess of Re�rnies Over (Under) E�endihues and Operating Transfers In and Out - - 10,014 - - 0.0% Fund Balances, Beg. of Year - - - - Fund Balances, End of Year - - 10,014 - _'_--��" `�""-��. _ � �,,.. "'„ �,.� � y � �-� Tr Z '.3�' TNE � �• � � � �I �� i �� ��� �,�J_ � ��� :iJ.� ,� � � INC:1989�' � - _.,b,,_ �_� � �' . � � "O�:o� TRanrrtoHS N�v, � rrr ° Special Revenue Funds-Revenue Detail FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # 100 GAS TAX FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4065+4545 -Investment Interest 2,299 4,854 - 9,000 9,000 0.00% 4700 -Gas Tax 2106 331,851 148,750 365,000 282,175 (82,825) -22.69% 4701 -Gas Tax 2105 538,841 244,074 542,685 469,845 (72,840) -13.42°/a 4702 -GasTax2107 719,656 356,755 732,419 672,316 (60,103) -8.21% 4704 -Gas Tax 2107.5 10,000 - 10,000 10,000 - 0.00% 4706 -GasTax2103 994,399 559,227 951,129 1,244,083 292,954 30.80% TOTAL GAS TAX FUND 2,597,046 1,313,660 2,601,233 2,687,419 86,186 3.31% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # 101 STATE TRANSPORATION FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4065 -Investment Interest 4,478 - - - - 0.00% TOTAL STATE TRANSPORTATION FUND 4,478 - - - - 0.00% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # 130 RECOVERY ACT JAG FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4025 -JAG Grant 23,517 15,215 73,104 73,104 - 0.00°/a TOTAL RECOVERYACT JAG FUND 23,517 15,215 73,104 73,104 - 0.00% FY 2011-12 131 ENERGY EFFICIENCY CONSERVATION FY 2010-11 YTD FY 2011-12 Mid Year Acct # BLOCK GRANT FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4025 Grants 197,217 52,530 743,483 743,483 - 0.00% TOTAL EECBG FUND 197,217 52,530 743,483 743,483 - 0.00% FY 2011-12 140 COMMUNITY DEVELOPMENT BLOCK FY 2010-11 YTD FY 2011-12 Mid Year Acct # GRANT FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4081 -Community Development Block Grant 468,997 70,459 1,025,788 1,025,788 - 0.00% TOTAL CDBG FUND 468,997 70,459 1,025,788 1,025,788 - 0.00% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # 150 AB 2766 FUND Revenue 12/31/11 Budget Estimates $ CHANGE °/a CHANGE 4048 -AB2766 Revenues 113,568 36,460 124,057 124,057 - 0.00% 4065 -Investment Interest 5,534 2,690 5,500 5,000 (500) -9.09% TOTAL A62766 FUND 119,102 39,150 129,557 129,057 (500) -0.39% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # 160 LAW ENFORCEMENT FUND Revenue 12l31/11 Budget Estimates $ CHANGE % CHANGE 4065+4545 -Investment Interest 18 - - - - 0.00% 4085 -AB3229 (COPS) 149,536 11,402 100,000 177,767 77,767 77.77% TOTAL LAW ENFORCEMENT FUND 149,554 11,402 100,000 177,767 77,767 77.77% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # 170 MEASURE A FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4065+4545 -Investment Interest 76,452 36,915 77,600 70,000 (7,600) -9.79% 4725 -Measure A 2,211,045 889,240 2,144,903 2,231,239 86,336 4.03% TOTAL MEASURE A FUND 2,287,497 926,155 2,222,503 2,301,239 78,736 3.54% ,a ��..� �,� ,g —�.�,.,: __ � � ; ; �^' ����~�, "� , � - 1 � �.i r 'r - �>,.,, � ��.,� y _� j .. ��nC: `1 , x s `- y y � y " - *�; � :�.� ,; t ,, , 4 i '`�� •"�, i��,. _ �M..�"'" � INC� � �; h. � � ' ` `.� ,.; � N � ,�-.��. ,.„�,' (�ld).`,� i�"� '{� �<• ,,, �� � � �� B Special Revenue Funds—Revenue Detail FY 2011-12 FY2010-11 YfD FY2011-12 MidYear Acct # 370 DEBT SERVICE FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4065 -Investment Interest 5,535 1,262 - 1,262 1,262 0.00% 4090 -Operating Transfer In 1,574,431 23,712,830 24,274,969 23,715,330 (559,639) -2.31% TOTAL DEBT SERVICE FUND 1,579,966 23,714,092 24,274,969 23,716,592 (558,377) -2.30% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct # t95 2011 FINANCING LEASE 2001 & 2008 COP: Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4090 -0perating Transfer In - - - 688,461 688,461 0.00°/a 4810 -Financing Proceeds - 26,835,000 26,835,001 26,835,001 - � 0.00% TOTAL DEBT SERVICE FUND - 26,835,000 26,835,001 27,523,462 688,461 2.57% . 1 , � ,�^'..�. �,_ - �k...- '�` ' . r f ? � Tt,� ;' ����... � � �l, � - � �� ��: . �.� � �. �.� f �- :_�' ,„r� r.� s,� �l �� >'aM� ,'��1.D';I'�At7 C1NS�I�HW'� N t�$ Exhibit C FY 2011-12 Mid-Year Budget Internal Service Funds T�ie � .___��``" � � t `��`�".'°` r ,� � ;��?`'��' � � ��, '` , � �� ;�, I�` 1(�r� ', � . ,,;� , -� � �, 11.i � _ _ ; IHC��! 89a _ - 9 .., „$ ` � , ✓ s;�i � e u. .. t'" ��f'� �'� ��i �v� ' � ���, � ,.,�,� �j� � Insurance Fund Summary of Revenues, Expenditures, and Changes in Net Assets 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Current Year to Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Re�ernaes 870,715 908,900 426,575 908,900 - 0.0% Total E�enses 790,676 908,949 417,753 908,949 - 0.0% E�ess of Reoenues O�er (Under) E�enses 80,039 (49) 8,822 (49) - 0.0°/a Net Assets, Beg. of Year 500,221 580,260 580,260 580,260 Net Assets, End of Year 580,260 580,211 589,082 580,211 ' � „ � _' �J�42 M � :THE V � � � ; A ,� � �� k�` . � �`�. -�'�,. ,,� . ���' �� • � � �� � � i NC � � {^� '�..� v.r ,,, i>a=-- .«� iA.rn` :,�,. ' � aO�i'=l�. � �' '1�1 �;V � �a Vehicles and Equipment Fund Summary of Revenues, Expenditures, and Changes in Net Assets 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Currer�t Yearto Date Re�sed hicrease Increase Achrals Budget Achials Budget (Decrease) (Decrease) Total Re�enues 45,357 229,600 132,488 229,600 - 0.0% Total E�enses 260,938 208,706 120,382 208,706 - 0.0% E�ess of Re�enues Ouer (Under) E�enses (215,581) 20,894 12,106 20,894 - 0.0% Operating Transfers In (Out): Ges Tax Fund - 113,260 113,260 113,260 - 0.0% Ex�ess of Reueru�es and Operating TransfersO�er(Under)E�enditures (215,581) 134,154 125,366 134,154 - NetAssets, Beg. ofYear 1,875,081 1,659,500 1,659,500 1,659,500 Net Asseis, End of Year 1,659,500 1,793,654 1,784,866 1,793,654 �r" �� � '`'�"' "`�- '' � T -. ��� r,'� ,_.��'� s .-- . '�'},:. (. r e T»�e - � � � `.�� F� I� �.." � � H +�' _ Ir+ '989f _ . .�s�^ 2 ',� �'� r � A� � � :" r��},3�„) �.. k; ":. � .�::;Yi� : .6. :;_ � :�g Information Technology Fund Summary of Revenues, Expenditures, and Changes in Net Assets 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Currer�t Year to Date Revised trxrease Increase Achrals Budget Ach�als Budget (Decrease) (Decrease) Total Re�erwes 2,144,039 2,099,000 913,514 2,099,000 - 0.0% Total E�enses 2,123,305 2,099,552 890,213 2,099,552 - 0.0% E�ess of Re�ern�es Ouer (Under) E�enses 20,734 (552) 23,301 (552) - 0.0% NetAssets, Beg. ofYear 713,386 734,120 734,120 734,120 Net AsseCs, End of Year 734,120 733,568 757,421 733,568 � y[� ^.a..,. •r (� = `�� ""°'�� �.'� C `�' i.�� � _ lJ/ � �� �. �H .�3.� �- � � � (�-- �_ �� � .. . �� _�„ .�a � � :l�i _ �` � �:[ c �89 � � . . . � -x��R �� "� �a� T . �N� ���o � x ° w�n az Support Services Fund Summary of Revenues, Expenditures, and Changes in Net Assets 201a11 2011-12 2011-12 2011-12 Proposed % Audited C�urerrt Year to Date Re�ised trxrease Increase Achials Budget Actuals Budget (Decrease) (Decrease) Total Re�rxies 432,746 450,800 190,539 450,800 - 0.0% Total E�enses 404,852 415,336 185,439 415,336 - 0.0% Ewcess of Revenues Ouer (Urxler) E�enses 27,894 35,464 5,100 35,464 - 0.0% Net Assets, Beg. of Year 306,691 334,585 334,585 334,585 Net Assets, End of Year 334,585 370,049 339,685 370,049 '�r�" ��`��� 4; � -=-•�� �* J , r �,.,--i' "�,,rt.� t. �'TH � , �- f �, � �"-3� �• � r�;�, � ' �- �= � �,��p� , � � '�. �'� t � ""z �, �lr -"s �`���` ������ � +� ,- �� � �,y ;� ��r� �.;; �, � ;,� ...',��"��. .v e . �¢ � � �a... 3'z , �, ,s ,a �"'u �v � '� ;y� . � ..;'N -a:.; ',�,,£ P �_. � r `� ..•�Y'.� ` �{QI`t�r l�l.�` �:l ' � Facilities Fund Summary of Revenues, Expenditures, and Changes in Net Assets 2010-11 2011-12 2011-12 2011-12 Proposed % Audited Currerrt YeartoDate Revised Uxrease Increase Achials Budget Achials Budget (Decrease) (Decrease) Total Revenues 835,116 1,442,300 603,791 1,442,300 - 0.0% Total E�erses 804,652 1,400,498 586,777 1,400,498 - 0.0% Ez�ess of Revenues O�er (Under) E�enses 30,464 41,802 17,014 41,802 - 0.0% NetAssets, Beg. ofYear 193,091 223,555 223,555 223,555 NetAssels,EndofYear 223,555 265,357 240,569 265,357 'CHE ���� ,�,:� C '�'"°'F.I��._. „�, __ � c.J'� 7 �` ��i � � � �(� � �� ': � r � .��.�,ir �� :?� `� ,�' � ' T � ' ' `, �:. � � ��� �� �'� ` . s r � •. � � .. ,-. ,'.: . � �., . k �p�R�JA( {�S .., �° C�t,a T ot�s ' N�r=O rr � t Internal Services Funds-Revenue Detail FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct# 300 INSURANCE FUND Revenue 12/31/11 Budget Estimates $ CHANGE °/a CHANGE 4065+4545 -Investrnent Interest 6,719 2,607 8,700 8,700 - 0.00% 4076 -Charges for Services 862,796 413,118 900,200 900,200 - 0.00% 4086 -Special Event Insurance Fees 1,200 850 - - 0.00% 4095 -Claims Recovery - 10,000 - - 0.00% TOTAL INSURANCE FUND 870,715 426,575 908,900 908,900 - 0.00% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct# 310 VEHICLES AND EQUIPMENT FUND Revenue 12/31/11 Budget Estimates $ CHANGE % CHANGE 4065+4545 -Investmentlnterest 9,567 4,252 9,800 9,800 - 0.00% 4076 -Charges for Services 27,091 128,236 219,800 219,800 - 0.00% 4090 -Operating Transfers In-Gas Tax Fund - 113,260 113,260 113,260 - 0.00% 4550 -Gain on Disposal of Assets 8,699 - - 0.00% TOTAL VEHICLES AND EQUIPMENT FUND 45,357 245,748 342,860 342,860 - 0.00% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct# 3201NFORMATIONTECHNOLOGYFUND Revenue 12/31/11 Budget Estimates $CHANGE %CHANGE 4065+4545 -Investrnentlnterest 4,585 2,170 4,500 4,500 - 0.00% 4076 -Charges for Services 2,139,454 911,344 2,094,500 2,094,500 - 0.00% TOTAL INFO TECHNOLOGY FUND 2,144,039 913,514 2,099,000 2,099,000 - 0.00% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct# 330 SUPPORT SERVICES FUND Revenue 12/31/11 Budget Estimates $ CHANGE %CHANGE 4065+4545 -Investment Interest 3,264 1,467 3,300 3,300 - 0.00% 4076 -Charges for Services 429,482 189,072 447,500 447,500 - 0.00% TOTAL SUPPORT SERVICES FUND 432,746 190,539 450,800 450,800 - 0.00% FY 2011-12 FY 2010-11 YTD FY 2011-12 Mid Year Acct# 340 FACILITIES FUND Revenue 12/31/11 Budget Estimates $ CHANGE %CHANGE 4065+4545 -Investrnentlnterest 1,755 681 1,800 1,800 - 0.00% 4076 -ChargesforServices 833,361 603,110 1,440,500 1,440,500 - 0.00% TOTAL FACILITIES FUND 835,116 603,791 1,442,300 1,442,300 - 0.00%