Loading...
HomeMy WebLinkAbout11-019 CC Resolution RESOLUTION NO. 11-19 I� � A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF TEMECULA AMENDING THE FISCAL YEAR 2010-11 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 2010-11 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 2010-11 Gas Tax, State Transportation, `-- Recovery Act JAG Funding, Energy Efficiency Conservation Block Grant, Community Development Block Grant, AB 2766, Law Enforcement, Measure A, and Debt Service Fund 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 Mid-Year Budget. Section 6. That the Fiscal Year 2010-11 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 2011/Resos 11-19 1 PASSED, APPROVED, AND ADOPTED by the City Council of the City of Temecula this 22" day of February, 2011. Ron Roberts, Mayor ATTEST: . v Susan W. Jones, MMC ity Cler [SEAL] , � R:/Resos 2011/Resos 11-19 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. 11-19 was duly and regularly adopted by the City Council of the City of Temecula at a meeting thereof held on the 22 day of February, 2011, by the following vote: AYES: 5 COUNCIL MEMBERS: Comerchero, Edwards, Naggar, Washington, Roberts NOES: 0 COUNCIL MEMBERS: None ABSENT: 0 COUNCIL MEMBERS: None ABSTAIN: 0 COUNCIL MEMBERS: None , Susan . Jones, MMC City Clerk R:/Resos 2011/Resos 11-19 3 .� `' � �L`7 '.^+'' ' ..-:..�� ''f ( -h"� � � .. . n � ��� � � CFy' . /��l�r "` k- � �. t '� I.� � ? 1 � ,;:", ^ �� `� ��' �.'� °f "' : ��� �� � — �NC�I $�r* ,, �'�,' � '' =a���A'��'RF\O1T1 a PtSa� t) �"�` `� ^ :��. � �- z � : �. � �t1! �PPt} N � �S x Exhibit A FY 2010-11 Mid-Year Budget General Fund ��� � � , � , �� ��� � -----._,,,e,� � �� G � J - ' � �� a �� x _ � � ° ,_ _� K _ , II���iM ,- +' F ` r ,. 1 • �t� T` w� � (t�c �� � ry � +r ` u.. ..�. t,' �� , �.''�� �.'``�.�``.�";��1F` t 1 'i, � .:'' ��`�'.ti.'�.,��'��K1J `�x�l � �., ` � �'�l1� Q . �,s.�':.`�^v,'�,..ti t.. ,�i�: � , � . ��,i...� :. ,. s ' t Summary of Revenues, Expenditures, and Changes in Fund Balances FY2010-11 Mid-Year Budget 2009-10 2010-11 2010-11 2010-11 Proposed °/a Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 50,129,542 53,822,771 23,801,151 53,214,734 (608,037) -1.1% Expenditures by Dept: CityCouncil 415,839 431,769 202,596 431,769 - 0.0% CommunitySupport 144,619 137,150 39,754 137,150 - 0.0% CityManager 1,284,075 1,339,669 655,080 1,344,917 5,248 0.4% Economic Development 849,071 948,889 379,974 921,144 (27,745) -2.9% CityClerk 990,897 1,155,053 513,991 1,155,053 - 0.0% City Attomey 628,892 821,300 373,999 821,300 - 0.0% Finance 1,980,041 2,222,777 1,055,186 2,222,777 - 0.0% Human Resources 507,366 573,429 284,712 573,429 - 0.0% Planning 2,021,128 1,512,922 551,840 1,577,922 65,000 4.3% BuildingB�Safety 2,177,463 2,406,570 1,081,431 2,406,570 - 0.0% Land Development 1,401,784 1,355,331 669,283 1,278,637 (76,694) -5.7% PublicWorks 4,089,849 4,386,453 1,560,687 4,471,370 84,917 1.9% CIPAdmin 2,296,222 2,215,314 1,093,655 2,203,314 (12,000) -0.5% Police 20,032,249 21,270,449 9,067,897 21,222,874 (47,575) -0.2% Fire 4,301,464 4,443,578 2,159,444 4,262,578 (181,000) -4.1% Animal Control 156,000 449,160 59,625 434,160 (15,000) -3.3% Non-Departmental: - 0.0% RESTContribution 5,602,941 6,191,147 3,229,596 6,191,147 - 0.0% Retiree Medical Contribution 308,532 275,000 137,271 275,000 - 0.0°/a PropertyTaxAdmin 189,045 189,045 - 182,671 (6,374) 3.4% CFD88-12Tax 1,501,360 1,577,721 - - (1,577,721)• -100.0% Total Expenditures 50,878,837 53,902,726 23,116,021 52,113,782 (1,788,944) -3.3% Excess of Revenues Over (Under) Expenditures (749,295) (79,955) 685,130 1,100,952 1,180,907 Operating Transfers Out: Debt Service - Civic Center COPs (1,540,387) (7,675,774) (1,010,000) (7,951,319) (275,545) Total Revenues over Civic Center COPs (2,289,682) (7,755,729) (324,870) (6,850,367) 905,362 Bond Call CFD 88-12 (4,800,000) (4,769,968) � (4,800,000) - Total Revenues over Bond Call CFD 88-12 (2,289,682) (12,555,729) (5,094,838) (11,650,367) 905,362 TransfertoCapitallmprovementFund (1,587,951) (15,181,534) (11,015,000) (15,181,534) - TotalRevenuesoverClPTransfer (3,877,633) (27,737,263) (16,109,838) (26,831,901) 905,362 Excess of Revenues Over (Under) Expe�ditures and Operating Transfers Out (3,877,633) (27,737,263) (16,109,838) (26,831,901) 905,362 .fi p *--^.-�--- � � �� '�-'�' . �.;T'°� �° � tF��.'^-,:.�.,.... ,� CZ.- � t,*� � . '� Y� ,``� � �i;�'�1" ' � + I�� �� ���� .. - I C. t�9� /� r � # �} ...c :;�c� r � s � . `�'V�, ,1�,� `!�l.�W ��Q �� ��' „. Summary of Revenues, Expenditures, and Changes in Fund Balances FY2010-11 Mid-Year Budget 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Fund Balance, Beg. of Year 49,222,067 45,344,434 45,344,434 45,344,434 - 0.0% Revenues 50,129,542 53,822,771 23,801,151 53,214,734 (608,037) -1.1% Expenditures (50,878,837) (53,902,726) (23,116,021) (52,113,782) 1,788,944 -3.3% Operating Transfers Out: DebtService (1,540,387) (7,675,774) (1,010,000) (7,951,319) (275,545) 3.6% CapitallmprovementFund (1,587,951) (15,181,534) (11,015,000) (15,181,534) - 0.0% CFD 88-12 payoff - (4,800,000) (4,769,968) (4,800,000) - 0.0% Fund Balance, End of Year 45,344,434 17,607,171 29,234,596 18,512,533 905,362 5.1% Detail of Fund Balance: Reserved for long-term advance to RDA 669,188 668,187 468,199 468,199 (199,988) -29.9% Reserved fordeposits and prepaid items 11,385 107,959 39,540 39,540 (68,419) -63.4% Reserved for inventory 3,058 3,586 3,058 3,058 (528) -14.7% Reserved for encumbrances 12,302,358 - 12,302,358 - - 0.0°/a Unreserved: Designated for economic uncertainty (20% of Appropriations) 10,787,864 10,780,545 10,780,545 10,422,756 (357,789) -3.3% Secondarydesignated fund balance reserve (Civic Center Savings) 6,876,195 4,280,250 4,074,082 6,012,165 1,731,916 40.5% Designated forcomprehensive annualleave 1,429,853 962,864 962,864 962,864 - 0.0% Designated for open space/Dutch Villages 150,000 150,000 150,000 150,000 - 0.0% DesignatedforfutureClP 1,286,922 - - 0.0% Designated for unrealized gains 653,780 653,780 453,950 453,950 (199,830) -30.6% Designated for COP Prepayment 11,173,831 - - - 0.0% 45,344,434 17,607,171 29,234,596 18,512,533 905,362 5.1% ''TH�E }�, � ��: � -'�� � �� � j' ����� �?� � �� �" �. _ _'� Irr` ��9� • � � �� <��I.D.�' IQNS ��W Q TOTt7UN • n -. -. � :1. • � � t � �. � � �- _��.. �...__�� _. �o..���'� General Fund Revenue Detail FY2010-11 Mid-Year Operating Budget FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACCT ACTUAL YTD @ CURRENT MID YEAR NO 001 GENERAL FUND REVENUE 12/31(10 BUDGET ESTIMATES $ CHANGE % CHANGE DEPT 161 PLANNING -Various 461,635 300,618 627,578 851,849 224,271 35.74% -Grants - 248,200 248,200 - 0.00% DEPT 162 BUILDING & SAFETY - -Various 1,306,180 629,920 1,272,445 1,272,445 - 0.00% DEPT 163 LAND DEVELOPMENT -Various 483,952 528,072 210,060 645,647 435,587 207.36% DEPT 164 PUBLIC WORKS -NPDES Permit Fee 5,229 2,541 3,276 3,276 - 0.00% DEPT 170 POLICE 4055 -Citations and Bookings 111,320 43,939 225,373 � 141,373 (84,000) -37.27% 4044+ -Miscellaneous 122,570 45,727 113,565 113,565 - 0.00% 4067 -Vehicle Impound Fees 152,144 69,808 153,700 153,700 - 0.00% 4076 -Reimbursements 150,152 59,173 102,500 108,619 6,119 5.97% 4083+ -Grants 70,594 45,285 23,055 116,455 93,400 405.12% DEPT 171 FIRE -Various 520,505 242,483 357,307 376,724 19,417 5.43% 4083 -Grants 33,278 22,472 24,121 24,121 - 0.00% DEPT 199 NON-DEPARTMENTAL 4010 -PropertyTax , 4,772,056 2 4,486,242 4,743,424 257,182 5.73% 4012 -PropertyTax(Unsecured) 263,387 209,711 231,820 261,807 29,987 12.94% 4013 -Supplemental Tax -AB 2345 167,599 42,140 42,140 42,140 0.00% 4016 -Property Transfer Tax 458,581 247,830 390,863 496,607 105,744 27.05% 4018 -Franchise Fees 3,155,013 1,191,870 3,228,893 3,073,423 (155,470) -4.81°/a 4020 -TransientOccupancyTax 1,961,994 1,047,431 1,878,174 2;154,541 276,367 14.71% 4023 -Sales and Use Tax - Triple Flip 4,607,650 3,458,967 5,961,944 6 508,909 8.54% 4024 -Sales and Use Tax-State of Calif 17,565,204 7,101,569 18,324,653 18,166,874 (157,779) -0.86% 4025 -FEMA Grants - 15,263 125,912 125,912 - 0.00% 4028 -Homeowner Property Tax Relief 75,146 35,476 70,156 73,844 3,688 5.26% 4043 -Motor Vehicle in Lieu - Tripte Flip 5,969,038 2,970,122 5,664,618 5,940,244 275,626 4.87% 4046 -Motor Vehicle in Lieu -State of Calif 715,940 . 128,687 613,929 811,085 197,156 32.11% 4047 -Vehicle Code Fines 614,176 • 345,512 845,928 692,641 (153,287) -18.12% 4053 -Bids & Proposals 9,760 2,050 11,220 11,220 - 0.00% 4056 -Business Licenses 301,931 35,245 325,380 325,380 - 0.00% 4059 -Rightof WayAdvertising 22,950 12,760 19,080 31,950 12,870 67.45% Various -Miscellaneous 150,967 44,320 17,500 19,163 1,663 9.50% 4065 -Investment Interest 862,900 175,675 464,927 361,800 (103,127) -22.18% 4069 -Interest Earnings-RDA Loan Repayment 238,633 238,633 238,633 238,633 - 0.00% 4076 -Reimbursements-Miscellaneous 131,600 25,223 59,920 59,920 - 0.00% 4078 -Reimbursements - Pechanga Intergovemmental Agreem - 2,000,000 - (2,000,000) -100.00% 4082 -Reimbursements - Redevelopment Agency 110,000 55,000 110,000 110,000 - 0.00% 4083 -Reimbursements-Capital Imprvmnt Prgrm 2,246,083 1,062,694 2,213,314 2,203,314 (10,000) -0.45% 4090 Operating Transfer In-Gas Tax 1,334,148 985,034 1,579,623 2,664,009 1,084,386 68.65% 4090 Operating Transfer In-Prop 42 675,516 - 1,006,362 55,000 (951,362) -94.53% 4090 Operating Transfer In-COPS 147,740 - 100,000 100,000 - 0.00% 4090 Operating Transfer In-Other 10,000 10,000 300,000 - (300,000) -100.00% 4400 -Financing Reimbursement 200,000 84,000 192,500 168,000 (24,500) -12.73% 4545 -Chan e in Fair Value of Investments 56,029 243,024 - 243,024 243,024 0.00% TOTAL GENERAL FUND 50,129,542 23,801,151 53,822,771 53,214,734 608,037 -1.13% T ,.r - i - 4- �C. � l"�� �. X ... - - , �a . � { � t �TwE °��"'�''��...''� � � ��(� ��: �� ' ' � �, s _ �.�'. �� � � ti �. ib' � i � r� -�'' 1 �►89� , "Q� 1;��i�t�s Nr�+��? Ni��es" Exhibit B FY 2010-11 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 _ .--�-� � -...,�>.��.,, � , T �� �'� .�� ly � � � �� .11�� � �,� W? � � � �i� ����— ��� � � � E _ . �:��:��t;� ,�.. , , , ;�; �:: �; O�:b.Tiu��,o�s N�w�+D ��rr Ir+ 89x « • . tin Gas Tax Fund 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Year to Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) TotalRevenues 1,656,190 1,579,623 1,258,241 2,585,985 1,006,362 63.7% Total Expenditures - - - - - 0.0% Excess of Revenues Over (Under) Expenditures 1,656,190 1,579,623 1,258,241 2,585,985 1,006,362 63.7% OperatingTransfersOut (1,334,148) (1,579,623) (985,034) (2,664,009) (1,084,386) 68.6% Excess of Revenues Over (Under) Expenditures and Operating Transfers Out 322,042 - 273,207 (78,024) (78,024) Fund Balance, Beg. of Year - 322,042 322,042 322,042 Fund Balance, End of Year 322,042 322,042 595,249 244,018 F•Y" � ' �'_ j l� ��^`''}���—�' '`-��� � {, � �_ /� � . �� �� � ..�� � . p / V �rw 1 .., �? ^''+.a ';..��� � �N�i �� �.» �i E`�;. . � k '�,"� <� � � �'` � °�� � ��� ;' � ,J� � a ��. . ' `- Inic �89= _� . . .�r � � �, : -, , . r �x _�' `�_: � �R � r<"��.o:Tt� �, �.=N�w C�?t�ti ` t � . " , State Transportation Fund 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) TotalRevenues 952,856 1,027,759 4,296 6,744 (1,021,015) -99.3°/a Total Expenditures - - - - - 0.0% Excess of Revenues Over (Under) Expenditures 952,856 1,027,759 4,296 6,744 (1,021,015) -99.3% Operating Transfers Out: To General Fund (675,516) (1,006,362) - (55,000) 951,362 -94.5% ToCIP (261,100) (1,279,835) (970,389) (1,279,835) - Excess of Revenues Over (Under) Expenditures and Operating Transfers0ut 16,240 (1,258,438) (966,093) (1,328,091) (69,653) Fund Balances, Beg. of Year 1,458,996 1,475,236 1,475,236 1,475,236 Fund Balances, End ofYear 1,475,236 216,798 509,143 147,145 �,,,r, d;f �, . �ti......� r � , l.,r,,,� T�� , �t `� ��� � , �. � �-rr � ( J ' � ,� _ . � y.A � � { � � `+�,.4 � '+� �'`�� , , � _ }� � � "_"�r It�c'.��9a91�* ;t� . «�l,[?"� �7iT,,IOPlS ,� . �'�PAOItTt1AI .� " Recovery Act JAG Fund 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 22,683 96,655 8,805 96,655 - 0.0% Total E�enditures 22,683 96,655 8,805 96,655 - 0.0% Excess of Revenues Over (Under) Expenditures - - - - - 0.0% Fund Balances, Beg. of Year - - - - Fund Balances, End of Year - - - - \ ,�� ��'1, „r -�-.`�� �a � f �` _� ?. � �� r+ `� � � � � � ,,.TNE ��;� r.,�- �_-' � �# ..rf I� �'' �, � . `�" =�� �� � .�li� _�tr Iric. '1�9� s..€ w �,"� �. K � ,. v _ '�" �"4w fiw�nc�►oHS °N�w Energy Efficiency Conservation Block Grant Fund 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current YeartoDate Revised Increase Ir�crease Actuals Budget Actuals Budget (Decrease) �Decrease) Total Revenues - 940,700 58,143 940,700 - 0.0% Total Expenditures - 346,124 6,315 346,124 - 0.0% Excess of Revenues Over (Under) Expenditures - 594,576 51,828 594,576 - 0.0% Operating Transfers Out: CIP Fur1d - (594,576) (51,828) (594,576) - 0.0% Excess of Revenues Over (Under) Expenditures and Operating Transfers Out - - - - - 0.0°/a Fund Balances, Beg. ofYear - - - - Fund Balances, End of Year - - - - ��--- � �e'' !��' -r,� � � .� � � y � ��� W C � � '�� � � .� . � _ � � ,✓�tlPr - �yz� •��6� ���� � f �; .,, `� �� :� � ; �ii +�,'�, 1 lt� _ � �� `�y.�.d � • .. � � t,7; � , �� Y � � � n� � ��� ��� � ��? � "I� � ' ai� N� `:,O�rc��HR�s" CDBG Fund 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 882,798 1,444,860 355,271 1,444,860 - 0.0% Total Expenditures 56,180 57,793 5,688 57,793 - 0.0% � Excess of Revenues Over (Under) Expenditures 826,618 1,387,067 349,583 1,387,067 - 0.0% Operating Transfers Out: CIP Fund (826,618) (1,387,067) (349,583) (1,387,067) - 0.0% Excess of Revenues Over (Under) Expenditures and Operating Transfers Out - - - - - 0.0% Fund Balances, Beg. of Year - - - - Fund Balances, End ofYear - - - - 'l�e =,.�.'���� ��� ��_ �,� �� ' ��� �`�� .�, .� t *.: : x �� lL.t � ' �' _ "�� INe 'I 89,� ,x �.�� � ,� � � �, �� �����:� ��, `„ ;�� �� } Uw�Tw�r�iaas` N w {�t�o AB 2766 Fund 2009-10 2010-11 2010-11 2010-11 Proposed % • Audited Current YeartoDate Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 122,487 116,085 34,444 122,127 6,042 5.2% Total Expenditures - - 13,199 13,199 0.0% Excess of Revenues Over (Under) Expenditures 122,487 116,085 34,444 108,928 (7,157) -6.2% Operating Transfers Out: CIP Fund . - (630,176) (10,000) (630,176) - 0.0% General Fund (10,000) (10,000) (10,000) 10,000 -100.0% Excess of Revenues Over (Under) • Expenditures and Operating Transfers Out 112,487 (524,091) 14,444 (521,248) 2,843 -0.5% Fund Balances, Beg. ofYear 429,150 541,637 541,637 541,637 Fund Balances, End ofYear 541,637 17,546 556,081 ' 20,389 �"���`�'G� �--' � `�"_"`^=-'-- '� �� j� �-c .3 C—�,",r. ;�"� �THE C�,� �'`'�*.« � ,��' - ' �� ��u�' � � � � ��'t�.� � � � ���;� `�` �r�c� a�� � � � � "���Ta��'to�S�I���� Oa�ci� -Law Enforcement Fund 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 147,740 100,000 - 100,000 - 0.0% Total Expenditures - - - - - 0.0% Excess of Revenues Over (Under) Expenditures 147,740 100,000 - 100,000 - 0.0% Operating Transfers Out: To General Fund (147,740) (100,000) (100,000) - 0.0% Excess of Revenues Over (Under) Expenditures and Operating Transfers Out - - - - - 0.0% Fund Balances, Beg. of Year - - - - Fund Balances, End of Year - - - - � � �,�' �°�,�� ��' xR ' � ( �� � �., . '� � # �Tt�e� _ ��`.� , '~ . �i � --�. 1 .] . "` � 7°" � y � � q�t"-,. �� �.�: ° _ � � � � �� _ `' Ir�c'.19$9� ,-- ��,�k �� "t� � �T�nrrior�s ,N �v��{���m�u��rr�s" MeasureA Fund 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current YeartoDate Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 1,915,487 1,885,823 966,613 2,000,607 114,784 6.1 °/a TotalE�enditures 597,275 1,212,713 408,481 1,212,713 - 0.0% Excess of Revenues Over (Under) Expenditures 1,318,212 673,110 558,132 787,894 114,784 17.1% Operating Transfers Out: To CIP (2,375,574) (4,892,734) - (4,892,734) - 0.0% Excess of Revenues Over(Under) Expenditures and Operating Transfers Out (1,057,362) (4,219,624) 558,132 (4,104,840) 114,784 -2.7% Fund Balances, Beg. of Year 8,417,999 7,360,637 7,360,637 7,360,637 Fund Balances, End of Year 7,360,637 3,141,013 7,918,769 3,255,797 J � _„�-"``. C} �. _� �Y,.J C..�.:.,._@».. ' t ' "..., ��? . . T � .P `= � ;� y �k �� ����� �,� ,11; �, � , E (�`�,�, `��,� �'�•w ,� �..,�1 � ; .{ � ,�, ;. r � �„ 7 t _ .„ INC��4� _ – ,— � �a �,_:;�:£ �. . �. ' - � ,T '�rr.�o�s.N�wrO...�'�n:r�t�i��" Debt Service Fund—Civic Center COPs . 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Yearto Date Revised Increase Increase Actuals Budget Actuals Budget (Decrease) (Decrease) Total Revenues 5,915 - 1,042 1,055 1,055 0.0% Total E�enditures 1,578,772 8,061,943 1,009,969 8,337,488 275,545 3.4% Excess of Revenues Over(Under) Expenditures (1,572,857) (8,061,943) (1,008,927) (8,336,433) (274,490) 3.4% Operating Transfers In: GeneralFund 1,540,387 7,675,774 1,010,000 7,951,319 275,545 3.6% Operating Transfers Out: CIP Fund (30,525) - - - - 0.0% Excess of Revenues Over (Under) Expenditures and Operating TransfersOut (62,995) (386,169) 1,073 (385,114) 1,055 -0.3% Fund Balances, Beg. of Year 856,787 793,792 793,792 793,792 Fund Balances, End of Year 793,792 407,623 794,865 408,678 "� � ��--. .,,.-`_'�.�,-'°�w. ° ��'�'ij"T`..,p �' � �� � � �' �� � � ��M' T� � , � ,� �.�1 ����' (� {�, ��� ' _�. � � � ,� _ r�����a9� � � � ' OHS � .��. ; ��� �.. R x �� � �NEW O �,R�.lN t�S. ��;� �� �_����.-,� � � . Other Funds-Revenue Detail ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 100 GAS TAX FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4700 -Gas Tax 2106 355,595 174,880 317,848 317,848 - 0.00% 4701 -GasTax2105 543,398 279,334 531,620 531,620 - 0.00% 4702 -Gas Tax 2107 747,197 380,342 720,155 720,155 - 0.00% 4704 -Gas Tax 2107.5 10,000 10,000 10,000 - 0.00% 4706 -Gas Tax 2103 - 423,685 - 1,006,362 1,006,362 0.00°/a TOTALGASTAXFUND 1,656,190 1,258,241 1,579,623 2,585,985 1,006,362 63.71% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 101 ST. TRANSPORTATION FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4065 -Investmentlnterest 18,925 4,296 21,397 6,744 (14,653) -68.48% 4160 -Traffic Con estion Relief 933,931 1,006,362 - 1,006,362 -100.00% TOTAL ST. TRANSPORT. FUND 952,856 4,296 1,027,759 6,744 1,021,015 -99.34% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 130RECOVERYACTJAGFUNDING REVENUE 12/31/10 BUDGET ESTIMATES $CHANGE %CHANGE 4025 -JAG Grant 22,683 8,805 96,655 96,655 - 0.00% TOTAL RECOVERY ACT JAG FUND 22,683 8,805 96,655 96,655 - 0.00% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 131 ENERGY EFFICIENCY CONSERVATION ACTUAL YTD @ CURRENT MID YEAR NO BLOCK GRANT FUNDING REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4025 Grants - 58,143 940,700 940,700 - 0.00% TOTAL EECBG FUND - 58,143 940,700 940,700 - 0.00% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 Al: I UAL Y I U(CU (:UKKtN I MIU YtAK NO 140 CDBG FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4081 -Communit Develo mentBlockGrant 882,798 355,271 1,444,860 1,444,860 - 0.00% TOTAL CDBG FUND 882,798 355,271 1,444,860 1,444,860 - 0.00% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 A(: I UAL Y I U((ll (:UKKtN I MIU YtAK NO 150 AB 2766 REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4048 -AB2766 Revenues 116,176 31,558 116,085 116,085 - 0.00% 4065 -Investment Interest 6,311 2,886 - 6,042 6,042 0.00% TOTAL A62766 FUND 122,487 34,444 116,085 122,127 6,042 5.20% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 160 LAW ENFORCEMENT FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4065+454 -Investment Interest 21 - - - 0.00% 4085 -A83229 COPS 147,719 100,000 100,000 - 0.00% TOTAL LAW ENFORCEMENT FUND 147,740 - 100,000 100,000 - 0.00% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 AC: I UAL Y I U(CV C:UFZFZtN I MIU YtAK NO 170 MEASURE A FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4065+454 -Investment Interest 100,961 39,777 117,823 83,607 (34,216) -29.04% 4085 -Measure A 1,814,526 926,836 1,768,000 1,917,000 149,000 8.43% TOTAL MEASURE A FUND 1,915,487 966,613 1,885,823 2,000,607 114,784 6.09% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 370 DEBT SERVICE FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4065 -Investment Interest 5,915 1,042 - 1,055 1,055 0.00% 4090 -O eratin Transferin 1,540,387 1,010,000 7,675,774 7,951,319 275,545 3.59% TOTAL DEBT SERVICE FUND 1,546,302 1,011,042 7,675,774 7,952,374 276,600 3.60% f ,� - �; ,= j�,�;;r-�_ �`_ �=�...� n f i . � x.� ' � 1 r ,.Tt+e � , � _�..�- � � ; ' � Y � _.� ,��`� "'�.�_ � �.�� �' � • ��'�� . � � . � IN � ,:"O�a:'CHAnmot�s N�v+r � "�"ira•u��cr , „ _.� p Exhibit C FY 2010-11 Mid-Year Budget Internal Service Funds � Ks :�:'���'3 { `�� ��`" � - R CJ � ����� . T �� ��' � i� ':. �" r r , ��. � ��� � ° _`, � �� �, � � i ��, � "� ��� T "` � ` ` INC. �89� = � - °.� � ,,,. � V . ; , r:: . : �' "Q.w T�o �=r I+J� �O�rorrntN . �r�s" Internal Service Funds Summary of Revenues, Expenditures, and Changes in Fund Balances 2009-10 2010-11 2010-11 2010-11 Proposed % Audited Current Year to Date Revised Inaease Increase Actuals Budget Actuals Budget (Decrease) (Deaease) Total Revenues by Fund: Insurance 781,007 877,335 401,451 871,971 (5,364) -0.6% Vehicles 159,020 40,272 29,590 38,168 (2,104) -5.2% Information Systems 1,907,228 2,244,406 1,072,793 2,242,171 (2,235) -0.1% Support Services 396,799 458,120 180,866 456,955 (1,165) -0.3% Facilities 812,985 1,281,529 368,759 1,280,984 (545) 0.0% Total Revenues 4,057,039 4,901,662 2,053,459 4,890,249 (11,413) -0.2% Total Expenditures by Fund: Insurance 1,178,833 877,471 401,373 908,080 30,609 3.5% Vehicles 324,121 263,880 140,879 263,880 - 0.0% Information Systems 2,097,260 2,238,905 1,066,780 2,238,905 - 0.0% Support Services 365,821 422,445 166,841 422,445 - 0.0% Facilities 783,990 1,248,822 354,922 1,248,822 - 0.0% Total Expenditures 4,750,025 5,051,523 2,130,795 5,082,132 30,609 0.6% Excess of Revenues and Operating Transfers Over (Under) Expenditures (692,986) (149,861) (77,336) (191,883) (42,022) Retained Earnings, Beg. of Year 4,281,456 3,588,470 3,588,470 3,588,470 Retained Earnings, End ofYear 3,588,470 3,438,609 3,511,134 3,396,587 � _ r-~ � � 1, � � r-t '�� ��� S � � T�� ���� � . t�� � ��, ��- ;�;� ��. � � _� . � �- � � h ��` � a � ���.� ��� j �� �` h'' .a.�. .�i. .";.::. � �( ;*`?:� <�`v..:L,. ,_;�� `+s.�!`X,y�l+? .�. a�:�;-`.�.� �.�.p Internal Services Funds-Revenue Detail ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR � NO 300 INSURANCE FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4065+454 -Investment Interest 11,624 4,246 14,535 9,171 (5,364) -36.90% 4076 -Charges for Services 765,778 396,630 862,800 862,800 - 0.00% 4086 Special Event Insurance Fees 1,525 575 - - 0.00% 4095 -Claims Recovery 2,080 - - 0.00% TOTAL INSURANCE FUND 781,007 401,451 877,335 871,971 5,364 -0.61% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 310 VEHICLES FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4065+454 -Investment Interest 11,915 5,111 12,772 10,668 (2,104) -16.47% 4076 -Charges for Services 134,192 24,479 27,500 27,500 - 0.00% 4550 -Gain on Dis osal of Assets 12,913 - 0.00% TOTAL VEHICLES FUND 159,020 29,590 40,272 38,168 2,104 -5.22% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 320 INFO SYSTEMS FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE %CHANGE 4065+454 -Investment Interest 5,899 2,026 6,806 4,571 (2,235) -32.84% 4076 -Char esforServices 1,901,329 1,070,767 2,237,600 2,237,600 - 0.00% TOTAL INFO SYSTEMS FUND 1,907,228 1,072,793 2,244,406 2,242,171 2,235 -0.10% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 330 SUPPORT SERVICES FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE %CHANGE 4065+454 -Investment Interest 4,219 1,684 4,720 3,555 (1,165) -24.68% 4076 -Charges for Services 392,580 179,182 453,400 453,400 - 0.00% TOTAL SUPPORT SERVICES FUND 396,799 180,866 458,120 456,955 1,165 -0.25% ACCT FY 09-10 FY 10-11 FY 10-11 FY 10-11 ACTUAL YTD @ CURRENT MID YEAR NO 340 FACILITIES FUND REVENUE 12/31/10 BUDGET ESTIMATES $ CHANGE % CHANGE 4065+454 -Investmentlnterest 1,915 827 2,429 1,884 (545) -22.44% 4076 -Char esforServices 811,070 367,932 1,279,100 1,279,100 - 0.00% TOTAL FACILITIES FUND 812,985 368,759 1,281,529 1,280,984 545 -0.04%