Loading...
HomeMy WebLinkAbout28-Finance CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION From: Barbara Pachon Director of Finance Subject: Receive and File the FY 00-01 Preliminary Year-End Report and the FY 01-02 1st Quarter Report and Amend the FY 01-02 Budget. Dept: Finance Date: October 31, 2001 Synopsis of Previous Council Action: July 9th, 2001 Resolution 2001-228 (Adopting FY 2001-2002 Final Budget) RECOMMENDATION: 1. Receive and file the FY 00-01 Preliminary Year-End Report and the FY 01-02 First Quarter Report. 2. Authorize the Director of Finance to amend the FY 01-02 Budget and appropriate $2,195,900 from the unanticipated additional General Fund balance as follows: $668,500 to replenish the General Fund Budget Reserve; $306,000 to transfer to the Cemetery Fund; $436,000 to transfer to the Baseball Fund, and $785, 400 to transfer to the Worker's Compensation Fund. , Contact Person: Barbara Pachon Phone: (909)384-5242 Supporting data attached:Staff Reoort . schedules Ward: FUNDING REQUIREMENTS: Amount: $2.195.900 Source: (Acct. No.) General Fund b~laRce -:! Finance: ~ .-I/d./ ~C I PCJ'1------ Council Notes: I I II /S/ OJ , , Agenda Item No. ,;< .s1 STAFF REPORT SUBJECT: Receive and file the FY 00-0 I preliminary year-end report and the FY 01-02 first quarter report and amend the FY 01-02 budget to appropriate the additional unanticipated General Fund balance in the amount of$2,19S,900. BACKGROUND: On July 9, 2001, the Mayor and Council adopted Resolution 2001-228, formalizing the adoption of the Final Budget for FY 2001-2002. At this time the Finance Department was also given direction to provide quarterly budget update reports to the Ways and Means Committee. On Wednesday, October 31, 200 I, the Finance Department presented to the Ways and Means Committee the preliminary year-end report for FY 00-01 and the first quarter report for FY 01-02. Attachment I is the preliminary year end report for FY 00-0 I. In summary the City's General Fund ended the FY 00-01 year with a net $2,195,904 more than was anticipated. The net available funds in the General Fund for FY 00-01 came in $1,589,825 higher than anticipated and there was a $606,079 net more in expenditure savings. The major items that accounted for the higher net revenues are Sales Tax ($615,289 higher) and Interest Earnings ($680,411 higher). The main reason Interest Earnings came in so high was due to the required yearly adjustment of the City's investments to market value. Since the market was lower at June 30th the value of the City's investments was increased by approximately $438,000. All other City funds did end the fiscal year on target to what was anticipated. The Utility Fund and the Street Construction Fund do show negative balances for year end but this is due to timing differences between expenditures incurred in FY 00-01 and revenues not being received until FY 01-02. Attachment II is the first quarter budget report for FY 01-02. In summary the first quarter report for FY 01-02 shows the City's General Fund revenues and expenditures to be on target. At the Ways and Means Committee meeting it was discussed that probably the next quarter report would provide more insight as to what impacts would be felt by the City regarding the economy and State budget issues. In keeping with the goal of financial stability, staff recommended that the $2,195,900 of additional General Fund balance be used to replenish the General Fund Budget Reserve that was used earlier in the fiscal year and to offset negative fund balances in the Cemetery Fund, the Baseball Fund, and the Workers Compensation Fund. The Ways and Means Committee agreed with this recommendation. FINANCIAL IMPACT: The City ended FY 00-01 with $2,195,900 more in the General Fund balance than was anticipated. Since these funds were not anticipated, there will not be any negative impact to the General Fund FY 01-02 operations and budget if these funds are appropriated for use. Using these unanticipated funds to offset other fund deficits would be in line with the Mayor and Council's number one goal of financial stability for FY 01-02. It is recommended that $668,500 of this unanticipated balance be used to replenish the General Fund Budget Reserve that was used earlier in the fiscal year. It is also recommended that $306,000 be transferred into the Cemetery Fund to offset the negative fund balance that has accumulated in that fund over the years. Another $436,000 is recommended for transfer into the Baseball Fund to help offset the negative balance that has accumulated in that Fund. If in the future the Baseball Fund does begin to generate a positive cash flow, then the excess funds will be used to pay back the General Fund. The final recommendation is to transfer the remaining balance of $785,400 to the Workers Compensation Fund to help offset the growing deficit in this fund. RECOMMENDATION: Receive and file the FY 00-01 preliminary year-end report and the FY 01-02 first quarter report and approve the budget amendment appropriating the additional unanticipated General Fund Balance in the amount of $2,195,900. CITY OF SANBERNARDINO FINANCE DEPART~NT INTEROFFICE~MORANDUM FROM: Barbara Pachon, Director of Finance TO: Ways and Means Committee SUBJECT: FY 2000-2001 Year End Budget Report DATE: October 29,2001 COPIES: Mayor Valles; Council Members; Fred Wilson, City Administrator; Departrnent/Division Heads Attached, for your review, is a preliminary year end budget report for FY 2000-01. The report covers the twelve-month period of July through June. Included in this budget update report is the revenue, and expense reports compared to the final budget and the revised estimates used for the FY 2001-02 budget process. As in the prior budget updates, each report has been color coded for easy reference. Below is a summary on each attached. The first report (white) is a summary report of all funds for FY 2000-01. The estimated (unaudited) year end Balances for all funds are in line with the estimates used for the FY 01-02 budget process with the exception of the Street Construction Funds and the Utility Fund. These two funds show fund balances worse than anticipated due to timing issues between expenses being incurred for projects and the reimbursements not received yet. These two funds should correct themselves in FY 01-02. The second page of the white report is a summary report of the General Fund for FY 2000- 01. Based on the unaudited year end figures, the General Fund undesignated fund balance at 6/30101 is now projected to be $11,415,004. This updated undesignated balance is $2,195,904 higher than the estimated fund balance used for the FY 2001-02 budget process. The second report (yellow) is a revenue report comparing actual revenues to the budget and to the revised estimates used for the FY 2001-02 budget process. Through June 30, 2001 we collected $1,777,404 more than the revised revenue estimates used for the FY 01-02 budget process. The four items below account for the majority of the increased revenues. . Sales Tax - Came in $615,289 higher than projected. . Interest Earnings - Came in $680,411 higher than estimated. . Motor Vehicle In Lieu - Came in $158,062 higher than estimated. . Transient Occupancy - Came in $147,819 higher than estimated. The third and final report (purple) is the Interfnnd Transaction report. This report indicates the unaudited year end amounts transferred into and out of the General Fund as well as into and out of all other Funds held by the City. Please let me know if you have any questions. - , CITY OF SAN BERNARDIND SUMMARY OF REVENUES, EXPENDITURES, AND TRANSFERS UPDATED FY 2000 . 2001 110,947,200 I 87,456,304 I 6,822,421 1105,225,9251 82,503,960 I 3,473,561 I 85,977,521 119,248,404 I _,SHEGIAIlIBEVENUEII;.UNDS' 105 LIBRARY 49,900 384,728 2,389,694 2,824,322 2,824,323 0 2,824,323 (1) 106 CEMETERY (254,100) 168,592 0 (85,508) 220,446 0 220,446 (305,954) 107 CATV 0 121,933 258,925 380,858 380,858 0 380,858 0 108 ASSET FORFEITURE 397,300 386,922 0 784,222 208,709 0 208.709 575,513 109 PARKING & BUSINESS IMP 16,200 132,103 0 148,303 29,823 98,789 128.612 19,691 110 PARKING DISTRICT 28,400 102,759 205,289 336,448 247,404 66,600 314.004 22,444 111 AIR QUAlITY-AB 2766 199,600 220,606 0 420,206 68,024 161,500 229,524 190,682 122 ARTICLE 8 - L TF (1,400) 0 0 (1,400) 5,644 0 5,644 (7,044) 124 ANIMAL CONTROL 0 965,645 165,042 1,130,687 1,130,687 0 1,130,687 0 125 AB 2928 Traffic Congestion 0 1,384,888 0 1,384,888 5,406 0 5,406 1,379,482 126 SPECIAL GAS TAX 618,800 3,453,382 0 4,072,182 283,733 2,710,000 2,993,733 1,078,449 128 TRAFFIC SAFETY 0 651,456 0 651,456 0 651,456 651,456 0 129 1/2 CENT SALES & RD TAX 2,625,800 2,300,541 0 4,926,341 1,730,460 190,700 1,921,160 3,005,181 131 SB 300 FUND 0 0 0 0 0 0 0 0 132 SEWER LINE MAl NT 2,576,600 1,333,510 0 3,910.110 1,142,015 100,000 1,242,015 2,668,095 133 BASEBALL STADIUM (690,500) 176,918 294,200 (219,382) 422,152 0 422,152 (641,534) 501 EMS (393,000) 0 75,000 (318,000) 0 0 0 (318,000) 527 REFUSE (933,700) 17,064,553 75,000 16,205,853 14,777,736 1.831,200 16,608,936 (403,083) '~TOTAL'SPECIAl.!:REVENUES jl'4;239,9OO1 1128:848:5361 1191483}15OJ 136:55.1.:5861 1123:'47!7(420) i1P:820;245,! ~87t.6651 ~,9 ~'CA~JA~p'ROJECT.liUNDS' 241 PUBLIC PARK EXTENSION 51.900 1,152 51,500 104,552 66,282 0 66,282 38,270 242 STREET CONSTRUCTION 164,300 176,117 0 340,417 350,462 0 350,462 (10,045) 243 PARK CONSTRUCTION 813,900 219,385 0 1.033,285 268,246 0 268.246 765,039 244 CEMETERY CONSTR 17,100 3,777 0 20,877 1,745 0 1,745 19,132 245 SEWER LINE CONSTR 4,099,100 548,549 0 4.647,649 18,008 100,000 118,008 4,529,641 246 INDIAN BINGO 417,100 19,658 0 436,758 0 0 0 436,758 247 CULTURAL DEVELOPMENT 0 120,465 0 120,465 0 120,465 120,465 0 248 STORM DRAIN CONSTR 2,730,500 484,756 0 3,215,256 1,650.820 100.000 1,750,820 1,464,436 250 TRAFFIC SYSTEM CONSTR 407,800 335,328 0 743,128 110,436 25,000 135,436 607,692 257 CITY WIDE AD 994 168,900 103,257 0 272,157 0 100,000 100.000 172,157 ~TOTAI:!:CAp'ITA1!'PROJEC:TS ~,870,60lll _2,012;444', "S1!5OO: !!t10:9~:5441 11III2:465;999: llIf.4!l5:465. ~9.1a~46,12 .8;023;0801 . :'I!!IINTERNA"SERVIC:E:FUN06: 621 CENTRAL SERVICES FUND 38,400 269,037 0 307,437 273,940 0 273,940 33,497 629 LIABILITY INSURANCE 1,815,200 2,079,204 0 3,894,404 1,502,039 500,000 2,002,039 1,892,365 630 TELEPHONE SUPPORT (119,900) 875.593 0 755,693 649,829 0 649,829 105,864 631 UTILITY FUND (254,800) 3,542.913 57.700 3,345,813 4.882,742 0 4,882,742 (1,536,929) 635 MOTOR POOL FUND 1,571,500 5,462,315 0 7,033,815 5,542,119 0 5,542,119 1,491,696 678 WORKER'S COMP (8,496,400) 2,461,309 0 (6,035,091 ) 3,246,728 0 3,246,728 (9,281,819) 679 MANAGMT INFO SYSTEM 803,200 3,347,707 0 4,150,907 3,254,632 165,500 3,420,132 730,775 '-'TOTAL~INTERNAC:SERVICE .(4;642,800) "181038;078' _!l7~ZOOJ 1I13:452;9W &191352;0291 _665;SOOi, l!</OlO.1;7ifs29J 1(6:5G4!55J) I....Tor AIAAL~JiUNDf11 . 'Ii P' 12 9,414,900)1 a36,35513621I,1013~.1.li6IIIl.65;033;l"'27o!199:408Il.1 0;394iN.<\I'1~38OI~; 1%2m,7..0;854!1 .The General Fund ending balance at 6130/01 includes the budget reserve of $6,959,000 and the projected carryovers of $932,100. CITY OF SAN BERNARDINO ESTIMATED REVENUES AND EXPENDITURES FY 2000-2001 GENERAL FUND 'i'Y~~"^ ~~., ESTIMATED REVENUE: Property Taxes $ 7,285,000 $ 7,310,000 OtherTaxes 44,533,900 49,395,500 Licenses & Permits 5,639,000 5,841,200 Fines and Penalties 665,500 774,500 Use of Mone & Prope 1,215,400 1,366,000 Inter ovemmental 14,495,900 14,829,700 Char es for Services 2,745,300 2,755,500 Miscellaneous 3.070,000 3,406,500 . Total,Estimated,Revenues'IlC~'t~ tSJ..9,650,OOOr lS;U5;6J.8,!lJl!l ,~~~~ ~~fJ~~~' $ 7,342,851 $ 49,989,358 5,766,619 848,161 2,061,761 15,148,396 2,873,936 3.425,222 t$1!}i'~!i;3~ l$'.J. 32,851 593,858 4,581) 73,661 695,761 318,696 118,436 18,722 IJlEZi4!IM TOTAL TRANSFERS IN;_'_"",r_t."""..:Ji ,$l,6,856,OOO, ($.'l)l!.~0.090J t$A.6.1122;~~1l -,,$~(~8Z;5:l9) ITOT AL ESTIMATED FU NOS AVAILABLE: '.1'$ 86,506,OO!ldl$I.92,6,88,9.09.l1 tS.J~,'2l.l!;'l2!idllf"""""'ll1:~,8~;82!;il ESTIMATED EXPENDITURES: Mil-vor $ 1,018,300 $ 675,000 $ 634,076 $ 40,924 Common Council 427,200 352,200 328,262 23,938 Citv Clerk 1,006,300 945,000 903,404 41,596 City Treasurer 18,300 21,400 21 ,439 (39) Citv-Attomey 1,886,100 1,860,000 1,875,277 (15,277) Code Compliance 3,219,000 3,030,000 2,845,612 184,388 General Government 2,044,100 1,010,000 510,236 499,764 citY Administrator 518,300 518,300 516,481 1,819 Human Resources 394,400 385,600 384,249 1,351 Finance 1,196,800 1,146,800 1,141,331 5,469 Civil Service 279,900 257,900 245,598 12,302 Development Services 6,722,300 6,250,000 6,060,529 189,471 Fire 18,771,300 18,725,900 18,842,245 1116,345) Police 37,297,300 37,750,000 37,739,025 10,975 Facilities Manaoement 3,588,100 3,500,000 3,139,827 360,173 Parks, Recreation, & Comm Service 4,914,800 4,650,000 4,567,139 82,861 Public Services 3,131,200 2,940,000 2,749,230 190,770 Vacancy Factor Budget (1,200,000) - - - F Total Estimated EXp'..nditur..s~,;;. ,$ 85,233,700, $~ 84,018,1 00) ',Si82,503;960; iS~1.M.1~;HOJ ESTlMAl:EO.EXPENDITURE CARRYOVERS $ ~i4'."'; - S~~ ~SBi932,100, IU~,.(932:;l0911 ITOTAIHRANSFERS OUT~I""1;~"",,,, IS 3,608,000 ISIll3;~91,!i,99lll$:iil!3,473,561!I;SffII'~~4,039~1 ITOT AI.!> ESTIMA TEOOEOUCTIONS:@"'r/' I $88,841;7,00 I'S:181 ;515,10011:S_t86,909,621'll$~;4606,079,~ BEGINNING F,UNO BALANCE7~1:P!ll'lljl'':-L:;;;' is.10,967.1299; lS.JJ.O,9.4r,200,S~1.0,94'l,200; ~$ IESTIMA TEO,ENDlNG BA~t-lCE;.6;39.;o,1 :ii.I,SJ8.6'.1;5.00;h$~16;~ 2MOOJI.s..t8,316.304;I,f~2;195;90~!1 IBUDGETEO.RESERVE~,,~1 ~liS.l.6,959,OOOJI,SIi.6,959,OOOjl,s.6,959,OOOII!$M~'IJiJ]_j.Il:l&l I ESTiUNDESIGNA TED BALANCE 6/30/01 :,-?J! I,S 1,652,500 I' SJI!,9,161;400jl,Sj;11:357,3!1411'SP~~2;t9.5,90:l.l1 , CITY OF SAN BERNARDINO GENERAL FUND REVENUE REPORT FISCAL YEAR 2000-2001 , ~4~~~ rf81~l~ IREYI_SI;DEI IkNP.-U'iIl ."~,DESCRIP,TION B(J~, ESTlM.e.l. ,~Tt:J). HRORERJ;y.~TAXES_~~~?~ 4001 Current Secured 6,300,000 6,350,000 6,334,722 4002 Current Unsecured 390,000 380,000 372,253 4006 Supplemental 75,000 125,000 166,892 4003 Prior Taxes 420,000 350,000 358,346 4005 Other 100,000 105,000 110,638 ","'Total.Taxes~iIltJ~l!='~. .f~i285\000. iS7ct310.000J _7.~342:85~il OTHER~TAXESD~%.'~~?' .- 4221 Sales Tax 25,215,000 26,217,100 26,832,389 4224 Utility User Tax 14,150,800 17,644,900 17,581,140 4201/14 Franchise Tax 2,045,100 2,205,500 2,091,595 4222 Transient Occupancy 1,960,000 2,125,000 2,272,819 4223 Prop. Transfer Tax 325,000 315,000 319,373 4225 Sales Tax Public Safety 550,000 600,000 604,185 4215 Tow Franchise 288,000 288,000 287,857 Total Taxes ~'\ll"~~ !ll;~,533,900. .491395;500$ 1[,49.989:3581 LICENSES AND aERMIT.S~ 4301 Business Registration 4,150,000 4,150,000 4,060,375 4330 Building Permits 400,000 460,000 477,053 4342 EMS Membership 25,000 21,000 21,593 4331 Mechanical Permits 200,000 200,000 201,418 4305 Annual Alarm Permit 275,000 215,000 213,828 4362 On Site Permits 130,000 220,000 198,736 4363 On Site Plan Check 60,000 120,000 111,683 4361 Construction Permits 70,000 80,000 71,384 4336 Fire Code Permits 175,000 175,000 169,282 4337 Fire Plan Check 50,000 98,000 113,315 4339 Misc, Fire 0 0 0 4351 Street Cut Permits 9,000 11,000 12,966 4333 Mobile Home Park Permit 28,000 28,200 28,076 4352 Misc Licenses & Permits 30,000 28,000 52,011 4304 Misc Planning Permits 23,000 20,000 20,128 4303 Misc City Clerk Permits 10,000 10,000 9,419 4360 Grading Permits 4,000 5,000 5,352 ,Total License &,Permitlllill!'~ 11:5,639;000 55,841,200- l!I:<l5f766;619i FINES,AND.PE~TIES. 4420 Parking Citations 575,000 640,000 729,974 4410 General Fines 86,000 130,000 113,910 4450 Fire Citations 2,500 2,500 2,621 4421 Vehicle Abatement Fines 2,000 2,000 1,656 Total FineslPenaltieslfllmr-ItIll:'B.l ~,665,500,. _7,,7.4\500i _848,161. , I USEO!;: MONEY"AND.PijORE~1lYa 4520 Land & Buildino Rental 295,400 300,000 324,382 4505 Interest Earnings 800,000 925,000 1,605,411 4530 Parking Rental Fee 70,000 56,000 40,110 4922-26 Sale of Property 40,000 75,000 83,473 4540 Vending Machine Commission 10,000 10,000 .8,385 .~ Total Money'&\P.roperty~_ .:1:215:4001 lli3H366.000! !III'I2,061f1.61C IlUD.q~-I l!; REV,EST/~; ;t\CTUAl! "Ao;rtrA~ 34,722 (15,278) (17,747) (7,747) 91,892 41,892 (61,654) 8,346 1 0,638 5,638 ....57j85:ill~ Jr2i8&.jJ I I 1,617,389 615,289 3,430,340 (63,760) 46,495 (113,905) 312,819 147,819 (5,627) 4,373 54,185 4,185 (143) (143) .5~455;458i "593;858.1 (89,625) (89,625) 77,053 17,053 (3,407) 593 1,418 1,418 (61,172) (1,172) 68,736 (21,264) 51,683 (8,317) 1,384 (8,616) (5,718) (5,718) 63,315 15,315 0 0 3,966 1,966 76 (124) 22,011 24,011 (2,872) 126 (581) (581) 1,352 352 "';'*'127-,619; -B<1(7t4i581) 154,974 69,974 27,910 (16,090 121 121 (344) (344) ~~182i661i ~:3166~1 28,982 24,382 805,411 680,411 (29,890) (15,890) 43,473 8,473 (1,615) (1,615) m&846;36,1t _695WM , CITY OF SAN BERNARDINO GENERAL FUND REVENUE REPORT FISCAL YEAR 2000-2001 INTERGOVERNMENTAI!'.R~j~ 4603 Motor Vehicle In Lieu 9,200,000 9,750,000 9,908,062 4621 Booking Fee Subvention 690,000 689,100 689,066 4622 ERAF Subvention 631,600 608,600 608,587 4670 CDBG Reimbursement 2,907,400 2,462,300 2,584,232 4670 20% Reimbursement 40,800 84,100 84,100 4670 Tax Increment Reimb, 74,900 91,000 74,900 4606 Homeowne~s Exemption 165,000 160,000 152,700 4626 POST 130,000 250,000 235,319 4673 Water Reimbursement 223,200 200,000 197,681 4625 State-Mandated Costs 300,000 360,000 429,884 4615 Disaster Prep, Program 20,000 20,000 20,662 4607 Off-Highway Vehicle Tax 4,000 3,600 3,969 4619 Mutual AidlDisaster Reimb. 20,000 45,000 53,179 4671 SBIM Reimbursement 89,000 106,000 106,055 -,,- Totallntergovemmental~"'iicr~~P#'~ tlll;W495;9001 1!;1:t1829.'700~ f415!'l48;3961 CHARGES FOR SERVICE~>;1i~,~;. 4731 Plan Check Fee 175,000 175,000 192,596 4880 EMS User Fee 550,000 840,000 841,277 4798 Storm Drain UtiiilV Fee 250,000 270,000 247,757 4815 Weed Abatement 200,000 230,000 247,861 4733 Building Demolition 400,000 300,000 298,410 4747 False Alarm Fee 80,000 85,000 93,552 4714 Develp prOiects 110,000 107,000 98,049 4743 Towing Admin Fee 125,000 130,000 129,669 4766 Building Permit Review 3,000 3,000 2,688 4719 HUD Building Inspection 30,000 15,000 21,829 4720 Planning Plan Review 50,000 70,000 65,850 4782/4 Public WK Subdivision 30,000 11,000 106,078 4785 Non Subdivision Str Imp 0 5,000 18,392 4711 Subdivision 45,000 50,000 50,879 4718 Environmental 8,000 12,000 11,866 4735 Release Notice of Pendency 20,000 25,000 24,860 4863 Class Registration Fee 15,000 13,000 12,281 4780 Misc Develp. Servs. Charoes 18,000 20,000 23,314 4862 Park Energy Fee 15,000 12,000 11,211 4707 Passport Fees 70,000 70,000 69,106 4702 County Contract 250,000 250,000 250,216 4864 Swimming Pool Fee 61,300 55,000 60,106 4861 Progrm/Facility Use Fee 23,000 20,000 18,531 4865 Non-Resident Fees 3,000 4,500 4,230 4710 Mise Development Services 30,000 32,500 42,784 4790-6 Signal MainUEneroy 30,000 30,000 28,889 4802 Str Lioht Energy Fee 10,000 7,000 8,510 4701 Election Filing Fee 0 200 159 4705 Utilitv Collection Fee 45,000 30,000 20,211 4881 Paramedic Reimb Contract 99,000 83,300 72,775 ,Total,Charges~ .2~&45:300J Ml:2RJ;5;5001 _2;87;3,936, ~. .JBUDGET~. 'Jt i.HEV EST!' 1I'8CIUAL~ ~ACTUAi:'. 708,062 158,062 (934) (34) (23,013) (13) (323,168) 121,932 43,300 0 0 (16,100) (12,300) (7,300) 105,319 (14,681) (25,519) (2,319) 129,884 69,884 662 662 (31) 369 33,179 8,179 17,055 55 m!W652;496; _3181696l 17,596 17,596 91,277 1,277 (2,243) (22,243) 47,861 17,861 (101,590) (1,590) 13,552 8,552 (11,951) (8,951) 4,669 (331) (312) (312) (8,171) 6,829 15,850 (4,150) 76,078 95,078 18,392 13,392 5,879 879 3,866 (134) 4,860 (140) (2,719) (719) 5,314 3,314 (3,789) (789) (894) (894) 216 216 (1,194) 5,106 (4,469) (1,469) 1,230 (270) 12,784 10,284 (1,111) (1,111) (1,490) 1,510 159 (41) (24,789) (9,789) (26,225) (10,525) ~128:636i . 8':4361 CITY OF SAN BERNARDINO GENERAL FUND REVENUE REPORT FISCAL YEAR 2000-2001 DESCRI~TION "1'~~~~I'ls~1fA\I_rf.1 MISCEL:LANEOUS~~4'-~. ';;if~ 4906 Water Fund Contr. 1,700,000 1,758,000 1,733,392 4910 Admin Service Charge 385,000 375,000 373,993 4901 Misc. Other Revenue 100,000 35,000 68,387 4912 Off Track Betting 170,000 175,000 182,050 4741 Sale of Photos 85,000 105,000 104,867 4809-10 Mise Dev. Services 3,800 2,300 6,746 4740-5 Police Misc. Receipts 535,200 700,000 721,585 4746 Property Auction 7,000 0 0 4750 Investigation Fee 12,000 11,200 10,236 4905 Litigation Settlement 25,000 166,800 166,791 4904 Drunk Driver Reimburmt. 5,000 5,000 5,084 4928 Booking Fee Reimburmt. 15,000 17,000 16,797 4911 Restitutions 2,000 6,200 7,270 4924 Damage Claim Recovery 25,000 50,000 28,024 , Total'Misce"aneous~~ ~3,07;O,OOO .3;406;500! 118?l425!222i I TOTAL'tGENERAL"IIiUND..-1Ilil.illll_79,650,OOOlI1l85:67,8,900,11l81l.'156~~ ~UP,~~.1I: IRfV,E.S~ ..e.'"<3;tIJ&tt MAC:!,l!lACl!!I' 33,392 (11,007) (31,613) 12,050 19,867 2,946 186,385 (7,000) (1,764) 141,791 84 1,797 5,270 3,024 11111111355~ (24,608) (1,007) 33,387 7,050 (133) 4,446 21,585 o (964) (9) 84 (203) 1,070 (21,976) 3 IIllllWl,Of)t3,~_~ila~ CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2000-2001 TRANSFERS - IN FY 2000-01 BUDGET FY 2000-01 REVISED ESTIMATE FY 2000-01 UNAUDIT ACTUAL VARIANCE REV ESTIMATE! UNAUDIT ACT _~6NIii~ 'From Special Gas Tax For- Street Maintenance-$2,335,OOO Street Lighting - $375,000 _~_____,._._w, - 1 ~ - 1----- "_ U D I~~~~ $ 2,710,000 $ 2,710,000 $ 2,710,000 o 'From Traffic Safety For- 745,000 730,000 651,456 (78,544) Police Costs 'From 1/2 Cent Sales & Road Tax For- 190,700 190,700 190,700 0 Administration 'From Cultural Development Fund For - 60,500 110,600 120,465 9,865 Funding Fine Arts and Civic and Promotional Costs 'From Traffic Systems Const. For - 25,000 25,000 25,000 0 Administration 'From Parking District For- 66,600 66,600 66,600 0 Debt Service Payment 'From AD 994 Fund For- 100,000 218,900 100,000 (118,900) Street Lighting and Signals 'From Liability Fund For- 500,000 500,000 500,000 0 Refund Reserve Excess 'From Storm Drain Construction For- 100,000 100,000 100,000 0 Administration 'From Refuse Fund For- 1,831,200 1,831,200 1,831,200 0 Administration $1,326,200 Lease City Yards 464,000 Lease City Hall 41,000 'From Sewer Line Construction For- 100,000 100,000 100,000 0 Administration 'From Sewer Line Maint. Fund For- 100,000 100,000 100,000 0 Administration 'From MIS Fund For - 165,500 165,500 165,500 0 800 Mhz Equipment Refund . CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2000-2001 TRANSFERS - IN 'From Transportation Fund For- Traffic Engineering Costs $50,000 MaintlFuel All. Fuel Veh $31.500 Crossing Guards $80,000 FY 2000-01 BUDGET 161,500 FY 2000-01 REVISED ESTIMATE 161.500 FY 2000-01 UNAUDIT ACTUAL 161.500 .:, Jll' VARIANCE REV ESTIMATE! UNAUDIT ACT o ..~~~ EI\I~L.F.l!INR ~c===J~::-:-=C_==--=~:~= -From General Fund For- Operating Costs $ 312,400 $ 258.900 $ 165,042 $ (93,858) ~;---~I--- -. -[ ~ - -" -, ..- .._.';1 . ~_~~~~---....~___~ 'From General Fund For- Operating Costs 278,000 228,800 258.925 30,125 ~_I---~"~ I' ....-------,----------- ~___ _--.l,___ _~L...---~____'~_~ 'From General Fund For- Operating Costs 2,415,400 2,407.700 2,389.694 (18,006) ~----_.-..-.-.--1r .--r----r-------I'------1 .~io...___._ .L~___'__'__._____________'_____'L____~_ ~---.J 'From General Fund For- Park Facilities Improvements 51,500 51,500 51,500 o ~~r----~-- "( -.--r-------------. .____jL ~~~_______.__~ -From General Fund For- Street Sweeping 75.000 75,000 75,000 o ~. -,-------,~-~--~[- --.._---.', ~-- ______L--L______~_:._ ..... A J _ __ __ ~_--.l -From General Fund For - Repay Operating Loan 75.000 75.000 75.000 o ~~-r---- ---~I"'" -'-,-------.--.~.-, .l_~~~___~L______.l~ 'From General Fund For - Operating Costs 294.200 294.200 294,200 o ~L__----.:.::c:==.:=r:===J~-:----:-J 'From General Fund For - Energy Savings Project o 0 57,700 57,700 CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2000-2001 TRANSFERS. IN FY 2000-01 BUDGET FY 2000-01 REVISED ESTIMATE FY 2000-01 UNAUDIT ACTUAL VARIANCE REV ESTIMATE! UNAUDIT ACT ~~~[.-'~~-~~-_ ~ _ ~-_...-'-J 'From Parking & Business Impr For - Administration - $98,200 204,700 204,700 205,289 589 .From General Fund For- Administration - $106,500 ~~~~~ ~a>>,'NIm6>ir~SF.IiBS1I~ ]~~~.BIl$ll~60-.m11.UWa_ , CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2000-2001 TRANSFERS - OUT FY 2000-01 BUDGET FY 2000-01 REVISED ESTIMATE FY 2000-01 UNAUDIT ACTUALS VARIANCE REV ESTI UNAUDIT ACT Ell O . . 'D ,--------:~,---------,~ ~:L ~ - JL.....~ 1 ~ ~ IL---......;~~_. ..& ~ . ~ . ~----.:~__~ .To Animal Control Fund For- $312,400 $ 258,900 $ 165,042 $ 93,858 Operating Costs .To CATV Fund For- 278,000 228,800 258,925 (30,125) Operating Costs .To Library Fund For - 2,415,400 2,407,700 2,389,694 18,006 Operating Costs .To EMS Fund For- 75,000 75,000 75,000 0 Repay Operating Loan .To Baseball Fund For- 294,200 294,200 294,200 0 Operating Costs .To Refuse Fund For - 75,000 75,000 75,000 0 Street Sweeping .To Utility Fund For - 0 0 57,700 (57,700) Energy Savings Project .To Parking District For- 106,500 106,500 106,500 0 Operating Costs .To Public Park Extension For- 51,500 51,500 51,500 0 Park Facilities Improvements ~~r~lr..~~l.'IT:'?,g;m-7~ .._.".~ ~.il_~~~~~:....::..~__~ ~=--==:J====C=-:====~~ .To General Fund For - Street Lighting-$375,000 Street Maintenance-$2,335,OOO 2,710,000 2,710,000 2,710,000 o CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2000-2001 TRANSFERS - OUT FY 2000-01 BUDGET FY 2000-01 REVISED ESTIMATE FY 2000-01 UNAUDIT ACTUALS VARIANCE REV ESTI UNAUDIT ACT ~,---------,~~~ ~~~~~,-------------.J -To General Fund For- Police Costs 745,000 730,000 651,456 78,544 ~r----C--'-----~'~------'--------'-, ~_ ~ ...____L---....""_-.-J.~_..i -To General Fund For- Administration of Fund 190,700 190,700 190,700 o "I M -To General Fund For - 800 Mhz Equipment Refund 165,500 D, ----... ----I~~~~~-=-==:J o 165,500 165,500 ~Jm.!Or.\--(rrc:rr~~--' ,-....---. --'I -.. 0 "--'- -. ---, .~~~______~__.__----l -To General Fund For - Street Lighting and Signals 100,000 218,900 100,000 118,900 ~c=.==~~~ -To General Fund For- Refund Reserve Excess 500,000 500,000 500,000 o ~=====::;=-=-~L'-::__ _J~_~=-=---=.J -To Parking District For- Administration of District 98,200 98,200 98,789 (589) Ir~~ - 1" . -. -"'1 ...... -. i" c'. ~'-~----, .~_________~ __~~__~___--....J -To General Fund For - Debt Service Payment 66,600 66,600 66,600 o ~~~_____ -0 '[ . ,_ , ______---, ~~~~_______'__~l ___~ _-l _ ~____ ~__~_ . ~ ____-----...J -To General Fund For- Fine Arts & Civic Promotional 60,500 110,600 120,465 (9,865) ~r--'r--~,-~-"~,'-'--'--- .--.---., ~L___.... ...L_.. . .~L_, ~_~__....J -To General Fund For - Administration of Fund 25,000 25,000 25,000 o CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2000-2001 TRANSFERS - OUT FY 2000-01 BUDGET FY 2000-01 REVISED ESTIMATE FY 2000-01 UNAUDIT ACTUALS VARIANCE REV ESTI UNAUDIT ACT .To General Fund For- Administration of Fund 100,000 ~c=====---==-====~ o 100,000 100,000 .To General Fund For- Administration $1,326,200 Lease City Yards $464,000 Lease City Hall $41,000 1,831,200 1,831,200 ~,--------------.-------~-----,-~~--~~~-- I ~~~~_.._-~~ o 1,831,200 .To General Fund For- Administration 100,000 ~~,--------------~:--. ----------, .~L------.J_________~ o 100,000 100,000 .To General Fund For- Administration 100,000 ~c===Jc===J~~===-:::J o 100,000 100,000 .To General Fund For- Traffic Engineering $50,000 MainUFuel Alt. Fuel Veh $31,500 Crossing Guards $80,000 161,500 ~'--------------r------.,----- ------~-I ..___.L-. Jl __ ___ _~~L_________________J~ _ ~~-----1 o 161,500 161,500 ~.:..:..==~~~~ 1~!mil,~IIlEJ9.sJi.e1iSfe"""I~DJ5.6._ ., CITY OF SAN BERNARDINO FINANCE DEPARTMENT INTEROFFICE MEMORANDUM TO: Ways and Means Committee ;aJ~ FROM: Barbara Pachon, Finance Director SUBJECT: FY 2001-2002 Budget Report DATE: October 29, 2001 COPIES: Mayor Valles; Council Members; Fred Wilson, City Administrator; DepartmentlDivision Heads Attached, for your review, is the first budget report for FY 2001-2002. The report covers the three- month period of July through September. Included in this budget report is the revenue, expenditure, overtime, and personnel reports compared to the approved budget. As in the prior budget updates, each report has been color coded for easy reference. Below is a SUll1IDary on each attached report. The first report (White) is an updated SUll1IDary for the General Fund for FY 01-02. This report reconciles the current updated FY 01-02 budget back to the original approved FY 01-02 budget. This report also reflects the proposed carryovers from FY 00-0 I that will be on the November 5th Council agenda for approval. For this report it has been assumed that all requested carryovers will be approved, as they are routine and were already taken into account during the FY 01-02 budget process. As indicated by this report there is $2,195,904 in fund balance that is not designated. It is suggested that $668,500 of this amount be put back into the budget reserve to replace the funds that were used earlier in the year. It is also suggested that the remaining $1,527,400 be transferred as follows; $306,000 to the Cemetery Fund, $436,000 to the Baseball Fund and $785,400 to the Workers Compensation Fund to offset the negative balances in these funds. The second report (Blue) is an update on revenue collections for FY 2000-2001. Through September 30, 2001, we have collected 16.2% of budgeted revenues, which equals $14,477,828. At this same time last year we had collected $13,407,574 in revenues which is 15.3% of the actual amount of revenues collected for FY 2000-200 I. The third report (Pink) is the regular expenditure report by Department. Department expenditures through September 30, 2001, are $22,775,478 or 23.1% of the budget. At this same time last year we had expended $20,028,674 or 24.3% of the actual amount expended. Assuming Departments were going to spend all of their budgets and in equal monthly amounts, 25% of their budgets should be expended by September 30, 2001. It should be noted the Budget column for FY 01-02 on this report does not include the proposed carryovers or Charter 186 adjustments, These items will be included in the next report. The fourth report (Yellow) is the overtime report by Department. This report indicates the amount of overtime budgeted by each Department compared to the actual amount of overtime paid. As in previous years, the Fire and Police Departments are the largest users of overtime. The sUll1IDary report at the bottom of the yellow page indicates the total personnel expenditures for public safety. This report does not include all of the Charter Section 186 salary increases or the budget amendment that was approved by the Mayor and Council. These will be included in the next report. The fifth report (Purple) is the personnel report by Department. This report indicates how much in total personnel (salaries, benefits, overtime, etc.) has been expended compared to the approved budget. Ideally, 25% of the personnel budget should be expended at September 30, 2001. . CITY OF SAN BERNARDINO ESTIMATED REVENUES AND EXPENDITURES FISCAL YEAR 2001-2002 GENERAL FUND ESTIMATEDREVEN.UE~ffio[ W""ccrt";;;,~. Property Taxes Other Taxes Licenses & Permits Fines and Penalties Use of Money & Property Intergovemmenta1 Charges for Services Miscellaneous Total Estimated Revenues Total Transfers In Other Finance Sources-Bond Proceeds TOTAl: ESTIMATE,D.FUNDS'AVAII:ABL:E~ 1~~~R~9.YF.,~~~ BUD;lMEND~Sl ,m-B~~G'j $ 7,310,000 0 $ 7,310,000 54,164,300 0 54,164,300 5,659,600 0 5,659,600 664,500 0 664,500 1,465,000 0 1,465,000 13,505,200 0 13,505,200 3,114,600 0 3,114,600 3,474,400 0 3,474,400 $ 69,378,000 0 $ 89,378,000 $ 6,255,500 0 $ 6,255,500 $ 2,000,000 0 $ 2,000,000 ,$1i97,633,SOO. U-lI'S!hi,~~Q' t_V9t:ji33,SOq, ESTIMA TED,EXPENDITURES~~~*' %~f;!i}~.'r ""~;:,;r.!)Ill'- ~ .. Mavor $ 1,043,300 $ 61 ,400 $ 1,124,700 Common Council 426,600 19,600 446,400 City Clerk 1,019,600 15,000 1,034,600 City Treasurer 23,900 0 23,900 City Attomey 1,675,400 0 1,675,400 Code Compliance 2,611,900 445,000 3,056,900 General Govemment 7,011,300 161,600 7,193,100 City Administrator 522,300 0 522,300 Civil Service 293,300 0 293,300 Human Resource 402,400 0 402,400 Finance 1,160,600 2,400 1,163,000 Development Services 6,596,600 193,000 6,791,600 Fire 19.653,000 73,200 19,726,200 Police 40,973,100 95,200 41,066,300 Facilities Management 4,057,300 213,600 4,271,100 Parks, Recreation, & Comm Service 5,060,600 57,700 5,116,500 Public Services 3,253,100 115,400 3,366,500 Total Estimated Expenditures $ 98,009,100 $ 1,493,500 $ 99,502,600 Total Estimated Expenditure Savings $ (1,200,000) $ - $ (1,200,000) Total Transfers Out $ 7,114,900 $ 107,100 $ 7,222,000 TOTAL ESTIMATED,DEDUCTIONS~f!'it>~ ,,~_'" ;:: ,$103,924;00,01 t$.IiGiIIW,600,6001 .$.MIlU05,S24,600' IEXCESS(DEFlc..IEt!PX.I~AVIiIL:A.BLE:I~,", ~ -"'" ~~ I $1\I,(!i;29.Q;Sjl,01It$..!IIII\l:1i(l,600,600II $lil_(7:89J.ilO,OJI IESTIMA TEDBEGI.N_N.ING"fU!!lQJlhl:A!!I_CE:~" .;"",*1 ,.$.~lj6,1.i!0,400;1,$;"l:l:;,,3;128,004,1"$~~tll,~~8;~Q.4.l1 IESTIMATED ENDING,ftUND BA,LANCE!"wM ~-'" 1,$17;7.9,829,900 1$ ..1,S27,404:1 $i, ~.";3S7,30~il IBUDGETED RESERVEi,'z*9d!!,,; v . ...;~_1;i;.\'~.h,$&!!,829,900 1$ '." (668,SOOIl $ ,9,16MOO;1 IBUDGET EXCESS~(DEFICIENc:.Yl>>;;'~;,i"w'''-ht~'',.,,, , I $ "j, 2,19S,9041$~'~2;19S;9Q~:1 'The change in the beginning fund balance is made up of $2,195,904 of additional balance from FYOO-01 and $932,100 of expenditure carryover requested for approval at the 11/5/01 Council meeting. .'The budget reserve is $2,500,000 from FY 96-99; $1,627,400 from FY 99-00; and $2,631,600 from FY 00-01. For FY 01-02, an additional $2,670,900 has been added to the reserve, CITY OF SAN BERNARDINO FISCAL YEAR 2001-2002 GENERAL FUND REVENUE REPORT AS OF SEPTEMBER 30, 2001 e :AXE 4001 Current Secured 4002 Current Unsecured 4003 Prior Taxes 4006 Supplemental 4005 Other Total Property Taxes 6,334,722 372,253 358,346 166,892 110,638 7,342,851 0,0% 0,0% 0,0% 0,0% 0,0% 0.0% ~';JQBlIJ.EK.Etl.UElSQYB:!=_ESI 4221 Sales Tax 26,832,389 4,701,567 17.5% 4224 Utility User Tax 17,581,140 2,653,905 15,1% 4603 Motor Vehicle 9,908,062 1,680,172 17.0% 4670 EDA Reimb. - CDBG 2,584,232 260,935 10,1% 4670 EDA Reimb, - 20% 84,100 - 0,0% 4670 EDA Reimb. - Other 74,900 - 0.0% 4201/11 Franchise Tax 2,091,595 18,221 0,9% 4906 Water Fund Contr. 1,733,392 373,683 21.6% Total Major Revenues 60,889,810 9,688,483 15.9% ~ITiY.cceE~ 4301 Business License 4,060,375 837,207 20,6% 4222 Transient Occupancy 2,272,819 348,350 15.3% 4303 Mise Ci Clerk 9,419 2,153 22,9% 4701 Election Filing Fee 159 0,0% 4707 Passport Fees 69,106 14,003 20.3% Total City Clerk 6,411,878 1,201,713 18.7% (;.oDE!:G,QMP.I!~NC_ 4421 Vehicle Abatement 1,656 278 16.8% 4733 Building Demolition 298,410 36,897 12.4% 4735 Release Pendency Notic 24,860 5,949 23.9% 4815 Weed Abatement 247,861 26,752 10.8% Total Code Compliance 572,787 69,876 12.2% Ii~CII~ITIESIlMNAGEMENT-l 4420 Parking Citations 729,974 133,904 18,3% 4520 Land/Building Rental 324,382 198,000 61.0% 4530 Parking Rental Fee 40,110 6,272 15.6% 4540-41 Vending Machines 8,385 2,710 32.3% Total Facilities Mgmt 1,102,851 340,886 30.9% - 200 . ~'Il 6,350,000 - 0.0% 380,000 - 0.0% 350,000 - 0.0% 125,000 - 0,0% 105,000 - 0.0% 7,310,000 - 0.0% 26,700,000 4,879,816 18.3% 21,686,300 3,774,027 17.4% 9,750,000 1,963,010 20.1% 1,928,400 257,887 13.4% 40,800 - 0.0% 12,300 - 0.0% 2,275,000 129,494 5.7% 1,775,000 170,972 9,6% 64,167,800 11,175,206 17.4% 4,150,000 885,114 21.3% 2,250,000 415,997 18.5% 10,000 1,579 15.8% 1,800 2,753 152.9% 70,000 12,194 17.4% 6,481,800 1,317,637 20.3% 2,000 - 0.0% 250,000 63,556 25.4% 25,000 5,475 21.9% 230,000 32,027 13.9% 507,000 101,058 19.9% 550,000 116,912 21.3% 300,000 100,461 33,5% 56,000 6,272 11.2% 84,000 1,426 1.7% 990,000 225,071 22.7% CITY OF SAN BERNARDINO FISCAL YEAR 2001-2002 GENERAL FUND REVENUE REPORT AS OF SEPTEMBER 30, 2001 ~a~ E , EN'" 1.1 IF 4880 EMS User Fee 641,277 158,957 24.8% 4881 Paramedic Reimb Contr 72,775 6,428 8.8% 4702 Coun~Contract 250,216 216 0,1% 4450 Fire Citations 2,621 500 19.1% 4342 EMS Membership 21,593 13,949 64,6% 4336 Fire Code Permits 169,282 31,895 18,8% 4337 Fire Plan Check 113,315 28,538 25.2% 4339 Misc. Fire 0.0% 4615 Disaster Prep. Reimb. 20,662 0.0% Total Fire Department 1,291,741 240,483 18.6% ~Jl"~SJ&lRE~BE~'T~O 4864 Swimming Pool Fee 60,106 45,377 75.5% 4861 ProgrmlFacili~ Use 18,531 5,038 27.2% 4862 Park Energy Fee 11,211 3,815 34.0% 4863 Class Registration 12,281 2,343 19,1% 4705 Utili~ Collection 20,211 - 0.0% 4865 Non-Resident Fees 4,230 934 22.1% Total Parks Dept 126,570 57,507 45.4% D~!c!9,p'ME[g~EJ~1l!.~E_ 4304 Mise Permits 20,128 5,974 29,7% 4330 Building Permits 477,053 113,189 23.7% 4331 Mechanical Permits 201,418 49,518 24.6% 4333 Mobile Home Park 28,076 172 0,6% 4351 Street Cut Permits 12,966 3,803 29.3% 4352 Misc. License/Permits 52,011 6,500 12,5% 4360 Grading Permits 5,352 1,598 29.9% 4361 Construction Permits 71,384 59,739 83.7% 4362 On Site Permits 198,736 106,875 53.8% 4363 On Site Plan Check 111,683 64,470 57,7% 4710 Misc Planning 42,784 7,585 17,7% 4711 Plannin!'l Subdivision 50,879 13,621 26.8% 4714 Develp Project 98,049 27,189 27.7% 4718 Environmental 11,866 6,008 50.6% 4719 HUD Building Inspection 21,829 3,840 17.6% 4720 Planning Plan Review 65,850 13,919 21.1% 4731 Plan Check Fee 192,596 36,222 18.8% 4766 Building Permit Rev 2,688 533 19.8% 4780 Mise Public Work 23,314 6,646 28.5% 4782/4 PW Subdivision 106,078 33,157 31.3% 4785 Non Subdivision Str 18,392 4,003 21.8% 4790-6 Sig MainUEnergy 28,889 - 0,0% 4798 Storm Drain Utili~ 247,757 101,005 40.8% 4802 Str Light Energy Fee 8,510 7,092 83.3% 4810 Mise, Development Serv 6,746 - 0.0% Total Development Servs 2,105,034 672,658 32.0% _I 640,000 159,808 25,0% 175,000 42,649 24.4% 250,000 - 0.0% 2,500 700 28.0% 23,000 12,079 52.5% 247,600 33,943 13,7% 75,000 21,631 28.8% - - 0.0% 20,000 - 0.0% 1,433,100 270,810 18.9% 57,000 43,038 75.5% 20,000 5,531 27.7% 12,000 1,108 9,2% 13,000 3,018 23,2% 30,000 - 0.0% 4,000 2,197 64.9% 136,000 54,892 40.4% 20,000 5,515 27.6% 460,000 109,953 23.9% 200,000 51,637 25.8% 28,200 - 0,0% 11,000 654 5,9% 30,000 8,438 28,1% 5,000 1,467 29,3% 100,000 83,467 83.5% 200,000 92,066 46.0% 100,000 54,979 55.0% 30,000 (6,460) -21.5% 50,000 (329) -0.7% 110,000 18,458 16,8% 12,000 378 3.2% 20,000 - 0.0% 70,000 17,230 24.6% 200,000 62,676 31,3% 3,000 762 25.4% 20,000 5,246 26.2% 11,000 55,682 506,2% 9,000 100 1,1% 30,000 - 0.0% 270,000 66,995 24.8% 7,000 6,146 87,8% 5,000 - 0.0% 2,001,200 635,060 31.7% CITY OF SAN BERNARDINO FISCAL YEAR 2001-2002 GENERAL FUND REVENUE REPORT AS OF SEPTEMBER 30, 2001 I-~- P'QI!C E 4215 Tow Franchise 287,857 72,000 25.0% 4305 Annual Alarm Permit 213,828 24,438 11.4% 4616 POST 235,319 0.0% 4741 Sale of Photos 104,867 24,811 23.7% 4743 Towing Admin, Fee 129,669 33,249 25.6% 4740-5 Mise, Receipts 721,585 177,809 24,6% 4747 False Alarm Fee 93,552 22,395 23.9% 4904 Drunk Driver Reimb 5,084 1,835 36.1% 4750 Investigation Fee 10,236 3,042 29.7% 4928 Booking Fee Reimb 16,797 4,719 28.1% 4911 Restitutions 7,270 2,946 40.5% 4746 Property Auction 0,0% Total Police Department 1,826,064 367,244 20.1% MIS.CE!tl!ANEQ!.Ul 4225 Sales Tax Safety 604,185 101,472 16.8% 4505 Interest Earnings 1,605,411 - 0.0% 4621 Booking Fee Subvention 689,066 - 0.0% 4622 ERAF Subvention 608,587 - 0,0% 4901 Misc. Other Revenue 68,387 1,713 2.5% 4912 Off Track Betting 182,050 50,930 28,0% 4910 Admin Service Charge 373,993 - 0.0% 4606 Homeowner Exemption 152,700 - 0.0% 4410 General Fines 113,910 9,291 8.2% 4223 Prop. Transfer Tax 319,373 26,783 8.4% 4671 SBIM Reimbursement 106,055 15,695 14.8% 4922-26 Sale of Property 83,4 73 2,200 2.6% 4673 Water Reimbursement 197,681 178,000 90.0% 4625 State-Mandated Costs 429,884 299,934 69.8% 4903 Refunds & Rebates - - 0,0% 4619 Mutual Aid/Disaster Rem 53,179 19,964 37.5% 4905 Litigation Settlement 166,791 41,791 25,1% 4602 Trailer Coach License - - 0,0% 4607 Off-Highway Vehicle 3,969 - 0,0% 4924 Damage Claim Recovery 28,024 20,951 74.8% Total Miscellaneous 5,786,718 768,724 13.3% lli1TOIA.cI!!.G~Et!F~1~l&U~!2aWlifm~2t3.o~~l'.I1A:W1WJl.5t3Y~1 111~_ 288,000 72,000 25.0% 275,000 27,988 10.2% 195,000 21.705 11,1% 105,000 19,490 18,6% 130,000 28,840 22.2% 765,000 129,971 17.0% 85,000 20,122 23.7% 5,000 640 12,8% 11,200 3,107 27,7% 17,000 3,669 21,6% 6,200 3,392 54,7% 5,000 - 0,0% 1,887,400 330,924 17.5% 650,000 104,502 16.1% 925,000 (63,287) -6.8% 689,100 - 0.0% - - 0,0% 160,000 20,503 12.8% 175,000 34,548 19.7% 375,000 - 0,0% 160,000 - 0.0% 130,000 - 0,0% 315,000 - 0.0% 106,000 8,750 8,3% 100,000 46,227 46.2% 200,000 189,168 94.6% 360,000 14,633 4.1% - - 0.0% 40,000 7,002 17.5% 25,000 (21) -0.1% - - 0.0% 3,600 - 0.0% 50,000 5,145 10.3% 4,463,700 367,170 8.2% lil.l!l~t3J.l!;gILsj'Jjr~l'1/~6~~1 CITY OF SAN BERNARDINO FISCAL YEAR 2001-2002 GENERAL FUND EXPENDITURE REPORT AS OF SEPTEMBER 30, 2001 --- ~Ri"~ 00m200..00:2. E MAYOR 634,076 153,158 24.2% 1,068,300 225,751 21.1% COUNCIL 328,262 77,282 23.5% 428,800 84,189 19.6% CITY CLERK 903,404 201,269 22.3% 1,019,800 241 ,523 23.7% CITY TREASURER 21,439 4.419 20,6% 23,900 6,180 25,9% CITY ATTORNEY 1,875,277 445.422 23,8% 1,875.400 460,830 24.6% CODE COMPL 2,845,612 505,962 17.8% 3,056,900 605,783 19.8% GENERAL GOVT 510,236 198,465 38.9% 7,031,300 690,101 9,8% CITY ADMIN 516,481 128,815 24.9% 522,300 118,995 22.8% HUMAN RESOURCES 384,249 88,152 22.9% 402,400 96,038 23.9% FINANCE 1,141,331 287,428 25.2% 1,180,600 265,508 22.5% CIVIL SERVICE 245,598 60,143 24.5% 293,300 54,930 18.7% DEVELOP SERVICES 6,060,529 1,366,525 22,5% 8,598,800 1,653,186 19.2% FIRE 18,842,245 4,625,061 24,5% 19,653,000 4,911,364 25.0% POLICE 37,739,025 9,329,975 24.7% 40,973,100 10,272.454 25.1% FACILITIES MGMT 3,139,827 687,638 21.9% 4,057,300 885,703 21.8% PARKS 4,567,139 1,223,724 26.8% 5,092,300 1,391,384 27.3% PUBLIC SERVICES 2,749,230 645,236 23.5% 3,293,000 811,559 24.6% T0i'F~1.!IGENlF.I!JNr.l I$jl.2~ll_~BDm!l~lBl.H~ CITY OF SAN BERNARDINO FISCAL YEAR 2001-2002 'GENERAL FUND OVERTIME REPORT AS OF SEPTEMBER 30, 2001 W1\.p;ruAt;t t4JJlJ!i$EI?Ti WMh~mMi m;miP~~mg1!QNmm@iim@@;iHm.'~~Q9i1.M~99gif-Z991M ...exeI;NQ MAYOR 0 0.0% CITY CLERK 0 0 0,0% CITY ATTORNEY 496 39 0.0% CODE COMPLIANCE 7,194 3,276 45.5% HUMAN RESOURCES 0 0 0.0% FINANCE 285 27 9.5% DEVELOPMENT SERVICES 86,714 16,584 19.1% FIRE 2,616,996 822,685 31.4% POLICE 1,962,083 474,361 24.2% FACILITIES MANAGEMENT 5,265 1,423 27.0% PARKS & RECREATION 4,859 2,869 59.0% PUBLIC SERVICES 85,030 15,242 17.9% .iHIQI.A.!;;~eNeR.AgEYNQiM1mMmiF4J1'!!!lil!gg !iml;??!!;P9-~t@m!g!!;9o/ii SUMMARY REPORT TOTAL PERSONNEL FOR PUBLIC SAFETY .HmM@mmM@mt~MttnWWMtMMHltlMMR M~AQ1UI.\Ut t4Ql!lK&:ep~lm :R#%f&HMW .iMmpJ;$gR!Ri!9NiMiMHmMMi;MMj!~~i9q1Iii~9991i?994IigxgJ;;NP! FIRE 16,100,767 3,933,380 24.4% POLICE 31,601,934 7,671,091 243% BUDGET JULfSEPT ;{- ...::::~f ..;:{__i :f.---::.'-..------.:,'@ -Z991t~QQ~i m2QQ1;~Q02i E~ENP ............. ... 0 0 0.0% 500 0 0.0% 1 ,000 1 92 1 9.2% 10,000 3,000 30.0% 0 0 0.0% 800 0 0.0% 54,400 21 ,310 39.2% 2,576,200 882,428 34.3% 1 ,41 1 ,400 558,331 39.6% 0 2,1 78 0.0% 8,000 1 ,901 23.8% 51 ,800 41 ,443 80.0% iAi11!!J!!!!IM Mml;P1A;1~j mi&3~~ BUDGET !;;!UUM&EPif; fMf:m~}@@: ~m.,.-.:'-:,.,-:.,:,-,__>,jr +QOlt~99?'! mg9P1t~gg~iil iJ;;xgJ;;BP. 1 6 , 8 37 , 900 4 , 4 37 ,646 26 .4% 33 ,623 , 5 0 0 8 , 328 , 3 1 7 24 8% CITY OF SAN BERNARDINO FISCAL YEAR 2001-2002 GENERAL FUND PERSONNEL REPORT AS OF SEPTEMBER 30, 2001 '@IAcl..lJAlii@I UUJJSER1! N'.!Mj......UW ~~t:__ -; _ '\i:l _ ,"_ ,.::::::A WM~~E' _ -}mmr ......."............................ ..................................... .......................... l!ll!t~mtIN!lH IH2l:lO(l;20lng i@2OlJO;;2D01iW ige!;NQl ._.....,._.,..._..._._.......,..._.,....-.-_...,-_...,._w,._.......,. ....w,....._.,..w,._...,._.......,-...._.,._._.,.,._._.,....._._._ MAYOR 527,742 128,587 24.4% COUNCIL 233,137 55,642 23.9% CITY CLERK 702,309 172,055 24.5% CITY TREASURER 20,959 4,419 21.1% CITY ATTORNEY 1,262,618 313,573 24.8% CODE COMPL 1,363,154 31 1,706 22.9% GENERAL GOVT (1,710,163) 24,489 -1.4% CITY ADMIN 409,838 98,416 24.0% HUMAN RESOURCE 256,478 62,933 24.5% FINANCE 895,753 224,503 25.1% CIVIL SERVICE 194,224 50,017 25.8% DEVELOP SERVICE 3,174,458 791,41 1 24.9% FIRE 16,100,767 3,933,380 24.4% POLICE 31,601,934 7,671,091 24.3% FACILITIES MGMT 1,456,413 358,910 24.6% PARKS 2,602,725 735,805 28.3% PUBLIC SERVICES 1,545,112 380,920 24.7% IPIAmm;NIllYNPHll l'iflq~@~T~~li "1'1$"317'lJ$1' .m~~ ,-----,_......_,-------,,--,--,--,---,.. ~~:., -::t.,::-,.,:.::-:.},.:::' .',(. .;..:.:::.}H @HMt....:......:::::.....::.:..':: HWeUDGEIIlMM W3U1WKSER1!i u@w:swnnr ..................................... ..................................... ................ 'iii1OO1U200.2til !lH~'f~Qq~Hi i~Q .,....,...,.,--'..,-..--......,.....,.-.-.....-...-.....-.....-.-........ 746,600 149,404 20.0% 315,600 57,475 18.2% 767,500 183,001 23.8% 23,300 5,826 25.0% 1,378,400 324,651 23.6% 1,550,100 368,656 23,8% 2,455,600 (455,073) -18.5% 428,000 104,81 1 24.5% 263,500 67,503 25.6% 937,000 21 1,677 22.6% 208,100 44,322 21.3% 3,962,200 839,366 21.2% 16,837,900 4,437,646 26.4% 33,623,500 8,328,317 24,8% 1,593,200 380,165 23,9% 2,91 1,800 850,497 29.2% 1,671,600 402,391 24.1% l'lt!l~@l1~l?gqf l'if!it~g~~~l @t~I..t:4fij v--:...-:...._