The URL can be used to link to this page

Home My WebLink About18-Finance .. CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION From: Barbara Pachon Subject: Director of Finance Finance C. ..... .', L .,. --' Receive and File the FY 2001-2002 Preliminary Year-End Report and the FY 2002-2003 1st Quarter Report Dept: Date: October 29, 2002 Synopsis of Previous Council Action: June 25, 2002 Resolution 2002-175 (Adopting FY 2002-2003 Final Budget) RECOMMENDATION: 1. Receive and file the FY 2001-2002 Preliminary Year-End Report and the FY 2002- 2003 First Quarter Report. ~~tUd~~ Sig1'lature Contact Person: Barbara Pachon Phone: (909)384-5242 Supporting data attached:Staff ReDort. schedules Ward: FUNDING REQUIREMENTS: Amount: N/A Council Notes: Source: (Acct. No.) ~ . ~;~~Fund Bal~ Finance: <<1 .-VJ' ~ /' Agenda Item No. :fi:-/!? /1/'1!o~ STAFF REPORT SUBJECT Receive and file the FY 2001-2002 preliminary year-end report and the FY 2002-2003 first quarter report. BACKGROUND June 25, 2002, the Mayor and Council adopted Resolution 2002-175, formalizing the adoption of the Final Budget for FY 2002-2003. At this time the Finance Department was also given direction to provide quarterly budget update reports to the Ways and Means Conunittee. On Wednesday, October 23, 2002, the Finance Department presented to the Ways and Means Conunittee the preliminary year-end report for FY 2001-2002 and the first quarter report for FY 2002-2003. Attachment 1 is the preliminary year end report for FY 2001-2002. In sununary, the City's General Fund ended the FY 2001-2002 year with a net $375,085 more than was anticipated. The total revenues and transfers out in the General Fund for FY 2001-2002 came in $704,774 higher than anticipated but there was $329,689 net more in expenditures than anticipated. The major items that accounted for the higher net revenues are Motor Vehicle In-Lieu ($325,365 higher) and Property taxes ($182,919 higher). 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 2001-2002 and revenues not being received until FY 2002-2003. Attachment II is the first quarter budget report for FY 2002-2003. In sununary the first quarter report for FY 2002-2003 shows the City's General fund revenues and expenditures to be on target. The City's Utility Tax revenues are slightly behind projections but other revenues are slightly ahead which makes up the shortfall. The next quarter report is scheduled to be presented in December which will provide more insight into the City meeting its budget projections. FINANCIAL IMPACT The City ended FY 2001-2002 with $375,085 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 2002-2003 operations and budget if these funds are appropriated for use. Staffreconunends the $375,085 of unanticipated balance in the General Fund be placed in the budget reserve. These funds may need to be appropriated at a later date to cover Charter 186 salary increases that appear are going to be over what was estimated in the FY 2002-2003 budget. RECOMMENDATION Receive and file the FY 2001-2002 preliminary year-end report and the FY 2002-2003 first quarter report. . . . .' CITY OF SAN BERNARDINO FINANCE DEPARTMENT INTEROFFICE MEMORANDUM ATTACHMENT 1 TO: Ways and Means Committee FROM: Barbara Pachon, Finance Director ,~.lL~- SUBJECT: FY 2001-2002 Year End Budget Report DATE: October 21, 2002 COPIES: Mayor Valles; Council Members; Fred Wilson, City Administrator; Department Heads Attached, for your review, is a preliminary year end budget report for FY 01-02. 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 02-03 budget process. As in the prior budget updates, each report has been color coded for easy reference. Below is a summary of each report. The first report (white) is a summary report of all funds for FY 01-02. The estimated (unaudited) year end balances for all funds are in line with the estimates used for the FY 02-03 budget process. The second page of the white report is a summary report of the General Fund for FY 01-02. Based on the unaudited year end figures, the General Fund undesignated balance at 6/30/02 is now projected to be $3,452,585. This updated undesignated fund balance is only $375,085 higher than the estimated fund balance used for the FY 02-03 . budget process. It should be noted that all these funds except the $375,085 have been budgeted to be used in FY 02-03. The second report (yellow) is a revenue report comparing actual revenues to the budget and to the revised estimates used for the FY 02-03 budget process. Through June 30, 2002 we collected $693,567 more than the revised revenue estimates used for the FY 02-03 budget process. Property Taxes, Motor Vehicle In-Lieu, and CDBG reimbursement came in higher than anticipated. UUT, Parking Citations, and Sale of Property came in lower than projected. The third and final report (purple) is the Interfund Transfer 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 BERNARDINO SUMMARY OF REVENUES, EXPENDITURES, AND TRANSFERS FISCAL YEAR 2001 . 2002 ESTIMATE ADDITIONS T9rAL DEDUCTIONS ESTIMATED BALANCE ..- -- ~",_...J;.' - - FElR -------- ---------- TOTAL BALANCE " ~ . .,. ~ ~ FUND I TITLE 7-1-01 REVI;NOES IJMNSFER " B.UDpET ,EXPENSESlITRANSFER DEDUCT 6-30-02 1001 GENERAL FUND' 119,414,800 I 90,290,7671 6,477,7071116,183,2741 94,493,0451 6,892,6441101,385,689114,797,5851 SPECIAL RI;VENUE FUNDS: 105 LIBRARY 0 375,141 2631 859 3,007,000 3,007,000 0 3,007,000 0 106 CEMETERY 1305,980 193,563 337 562 225,145 225,145 0 225,145 0 107 CATV 0 98,211 390 346 488,557 488,557 0 488,557 0 108 ASSET FORFEITURE 575,500 549,950 0 1,125,450 363,593 0 363,593 761,857 109 PARKING & BUSINESS IMPR 19,699 33,516 0 53,215 31,690 21,525 53215 0 110 PARKING DISTRICT 22,430 55,879 160,161 238,470 238,470 0 238,470 0 111 AIR QUAlITY-AB 2766 190,700 226,674 0 417,374 71,012 161,500 232,512 184,862 124 ANIMAL CONTROL 0 1,160,463 374766 1 535,229 1,535,229 0 1,535,229 0 128 TRAFFIC SAFETY 0 693,321 0 693,321 0 693,321 693 321 0 132 SEWER LINE MAl NT 2,644,400 1,339,363 0 4,183,763 1,428,329 106,000 1,534,329 2,649,434 133 BASEBALL STADIUM 1641591 199,499 898,075 455,983 455,983 0 455,983 0 247 CULTURAL DEVELOPMENT 0 124,962 0 124,962 0 124,962 124,962 0 501 EMS 318,000 0 150,000 1168,000 0 0 0 1168000 527 REFUSE (147,500) 17,857,306 65,000 17,774,806 15,808,800 1,831,200 17,640,000 134,806 T.El\TJ.\I!:,SP.EGIJ.\~ t;lEV.ENUES : 2,239.65,!l' "'22~!li!8" ~g;OOl:,~7;69. ~3(1,t55;275 :. 23:653~808. ~ 2,a38\5p,8' " z.Q',?~,~'~ k3C,562~959 CAF,:'IT A~,1f80'J E€J: F,UND,S" 122 ARTICLE 8 - L TF /7000 0 0 17,000 49,460 0 49,460 156,460 126 SPECIAL GAS TAX 1,078,400 3 554,867 0 4 633,267 521,110 2,710,000 3,231110 1,402157 129 1/2 CENT SALES & RD TAX 3 005,200 2,371,355 0 5,376,555 2,122,116 204,500 2,326,616 3,049,939 131 SB 300 0 0 0 0 0 0 0 0 135 AB2928 TRAFFIC CONGESTION 1 379 500 515809 0 1 895 309 1 386,142 0 1,386,142 509,167 241 PUBLIC PARK EXTENSION 38,300 1,121 51,500 90921 56,828 0 56,828 34,093 242 STREET CONSTRUCTION /10.100 410,726 0 400,626 651,068 0 651,068 1250 442 243 PARK CONSTRUCTION 765,000 329,498 0 1,094,498 778,732 0 778,732 315,766 244 CEMETERY CONSTR 19200 4,657 0 23,857 357 0 357 23,500 245 SEWER LINE CONSTR 4,920,600 543,678 0 5,464,278 220,625 100,000 320,625 5,143,653 246 INDIAN BINGO 436,700 123,505 0 560,205 1,936 0 1936 558,269 248 STORM DRAIN CONSTR 1 464,400 524.543 0 1,988,943 340,560 100,000 440,560 1,548,383 250 TRAFFIC SYSTEM CONSTR 607,700 212,022 13800 833,522 261 568 25.000 286,568 546,954 257 CITY WIDE AD 994 172.158 62,866 0 235,024 0 235,024 235,024 0 to:F;>;~elo:P'JT';>;l!; Ii'R@"JEGT.S' :J;3',870,05!l. ~' 8,6~,.641 ~~.{qg!30Ql j';?2;59D: OOS; :: 6,3901502, ;l:3.<,4!~~ .~ amI5:Q26) r12-;~Jl7~ ,lNT!>BI\lJ.\I'!ISIiR'(fIGE"F.I!JI\lDS~: . 621 CENTRAL SERVICES FUND 16200 324 122 0 340 322 321 032 0 321 032 19,290 629 LIABILITY INSURANCE 1,996,600 1,887.285 0 3,883,885 2,279,800 200,000 2 479,800 1,404,085 630 TELEPHONE SUPPORT 158 000 1,025,884 0 1,183,884 825,509 0 825 509 358375 631 UTILITY FUND 11,512,300 5,225,653 2800 3,716,153 4441,138 0 4,441,138 1724 985 635 FLEET SERVICES 1,976,100 6,070,206 61,200 8,107506 6,535,300 0 6,535 300 1,572,206 678 WORKER'S COMP 19,877,300 3 034,223 1,694,800 15 148,277 3402,800 0 3 402,800 8,551,077 679 MANAGMT INFO SYSTEM 866,100 3,661,267 96,100 4,623,467 3,366,200 0 3,366,200 1,257.267 TQIA\; lliJERNAJ' SERVICE r (6,376,600) 11'21"228',6!l0. , _"f_8~,900 i!'16\?06:a<r0 ' 21';17."1,779 , 200,OQO k 2J'!3:z.1~1:lal ng',8.64';8'39) TOri\~ tlL[ F,UNDS 129,147.91.6 ~H3,08,1 ,a02 I 13\4Q5,676 11'85,&3S,494 li145';709, 134 113,405,6761:15.9;11"4,8",0 1126,5211:6841 . Estimated ending balances for all funds include the carryover funds. The estimated carryover funds for the General Fund is $1,515.100. " CITY OF SAN BERNARDINO ESTIMATED REVENUES AND EXPENDITURES YEAR END FISCAL YEAR 2001-2002 GENERAL FUND : FY 2001-02 FY 2001-02 FY 2001-02 VARIANCE VARIANCE FINAL REVISED UNAUDITED FINAL BUDI REV ESTIMATE BUDGET ESTIMATE ACTUALS UNAUDIT ACT IUNAUDIT ACT ESTIMATED REVENUE: PropertY Taxes $ 7,310,000 $ 7,476,000 $ 7,658,919 $ 348,919 $ 182,919 Other Taxes 54,164,300 53,023,000 52,806,935 11,357,365 (216,065 Licenses & Permits 5,934,800 6,124,400 6,243,997 309,197 119,597 Fines and Penalties 684,500 843,000 737,340 52,840 (105,660 Use of Monev & PropertY 1,465,000 1,636,000 1,624,029 159,029 (11,971 Intergovernmental 13,752,900 14,068,300 14,691,434 938,534 623,134 Charaes for Services 2,834,800 3,006,000 3,099,307 264,507 93,307 Miscellaneous 3,550,400 3,420,500 3,428,806 1121,594 8,306 Total Estimated Revenues $ 89,696,700 $ 89,597,200 $ 90,290,767 $ 594,067 $ 693,567 Other Finance Sources-Bonds $ 2,000,000 $ 2,000,000 $ - $ 12,000,000 $ 12,000,000 Total Transfers In: $ 6,261,500 $ 6,466,500 $ 6,477,707 $ 216,207 $ 11,207 TOTAL ESTIMATED AVAILABLE: $ 97,958,200 $ 98,063,700 $ 96,768,474 $ (1,189,726) $ (1,295,226) ESTIMATED EXPENDITURES: Mavor $ 1,194,600 $ 880,000 $ 943,335 $ 251,265 $ (63,335 Common Council 455,200 364,700 341,671 113,529 23,029 City Clerk 1,078,000 986,900 1,021,127 56,873 (34,227 City Treasurer 23,900 23,900 23,952 (52 (52 City Attornev 2,025,000 1,925,000 2,047,354 (22,354 (122,354 Code Compliance 3,300,200 3,114,000 2,951,334 348,866 162,666 General Government 3,964,300 2,775,000 2,162,341 1,801,959 612,659 City Administrator 536,600 506,100 496,268 40,332 9,832 Human Resources 414,900 412,900 403,392 11,508 9,508 Finance 1,233,600 1,145,100 1,141,902 91,698 3,198 Civil Service 300,600 239,000 253,557 47,043 (14,557 Development Services 8,967,800 7,832,700 7,465,457 1,502,343 367,243 Fire 20,456,600 20,714,300 21,041,818 (585,218 1327,518 Police 42,437,900 42,238,900 42,004,232 433,668 234,668 Facilities Manaaement 4,417,400 3,993,200 3,762,169 655,231 231,031 Parks, Recreation, & Comm Serv 5,317,200 5,214,300 5,111,370 205,830 102,930 Public Services 3,428,300 3,455,700 3,321,766 106,534 133,934 Total Estimated Expenditures $ 99,552,100 $ 95,821,700 $ 94,493,045 $ 5,059,055 $ 1,328,655 Estimated Expenditure Savinas $ 11,200,000 $ - $ - $ (1,200,000 $ - Carrvover Reauests $ - $ - $ 1,515,100 $ (1,515,100 $ (1,515,100 Total Transfers Out: $ 9,217,900 $ 8,749,400 $ 6,892,644 $ 2,325,256 $ 1,856,756 TOTAL EST DEDUCTIONS: $ 107,570,000 $104,571,100 $ 102,900,789 $ 4,669,211 $ 1,670,311 EXCESS I (DEFICIENCY) OF AVAILABLE OVER DEDUCTIONS $ (9,611,800) $ (6,507,400) $ (6,132,315) $ 3,479,485 $ 375,085 BEGINNING BALANCE 7-1-01 $ 19,414,800 $ 19,414,800 $ 19,414,800 $ - $ - ESTIMATED ENDING BALANCE $ 9,803,000 $ 12,907,400 $ 13,282,485 $ 3,479,485 $ 375,085 BUDGETED RESERVE $ 9,803,000 $ 9,829,900 $ 9,829,900 $ 26,900 $ - EST UNDESIGNATED 6-30-02: $ - $ 3,077 ,500 $ 3,452,585 $ 3,452,585 $ 375,085 ." CITY OF SAN BERNARDINO GENERAL FUND REVENUE REPORT FISCAL YEAR 2001-2002 : PROliEl!JN8~I;S 4001 Current Secured 4002 Current Unsecured 4006 Supplemental 4003 Prior Taxes 4005 Other .,. ola!,T axes.l'iit III ! I J J 6,350,000 6,400,000 380,000 390,000 125,000 240,000 350,000 326,000 105,000 120,000 _~'L.Q:OQQ.l _f.4.l6:0.Q.01 6,536,223 390,014 268,031 353,987 110,664 Q5a:9j,!U 26,700,000 21,686,300 2,275,000 2,250,000 315,000 650,000 288,000 '11II.. .5Aj.164't300~ 27,035,000 27,102,137 19,800,000 19,442,681 2,480,000 2,591,949 2,500,000 2,439,186 320,000 349,621 600,000 593,361 288,000 288,000 53102310001 lIl'!i)i!l.06;~3!il L1<>EtSSES,lANDU1J:ijMljJi~ 4301 Business Registration 4,150,000 4,250,000 4,288,966 4330 Building Permits 460,000 480,000 519,500 4342 EMS Membership 23,000 21,500 19,220 4331 Mechanical Permits 200,000 210,000 220,555 4305 Annual Alarm Permit 275,000 . 215,000 216,158 4362 On Site Permits 200,000 235,000 233,649 4363 On Site Plan Check 100,000 120,000 119,011 4361 Construction Permits 100,000 140,000 159,263 4336 Fire Code Permits 247,600 247,600 256,345 4337 Fire Plan Check 75,000 96,600 100,538 4339 Misc. Fire 0 0 0 4351 Street Cut Permits 11,000 11,000 8,422 4333 Mobile Home Park Permit 28,200 28,200 28,624 4352 Misc Licenses & Permits 30,000 36,500 36,384 4304 Misc Planning Permits 20,000 21,500 23,329 4303 Misc City Clerk Permits 10,000 6,500 7,932 4360 Grading Permits 5,000 5,000 6,101 rl,Total License &~e.ermitOO 111 HlILl ;!lJI 11!1115,9.34:8P,O; lIII.6~12~~ll()j ~1l~9.71 FINES AND PE~L;rIES'~'RiIlf~ 4420 Parking Citations 550,000 4410 General Fines 130,000 4450 Fire Citations 2,500 4421 Vehicle Abatement Fines 2,000 : ;~TotaIFines/Penalties!Jl(~ ,.I~' ~8jl;500.t 730,000 596,172 110,000 138,052 2,500 1,475 500 1,641 ~,~;OOOi ~37:i340J USE OFi",MONE.YiAND PROPERl:Y~ 4520 Land & Building Rental 4505 Interest Earnings 4530 Parking Rental Fee 4922-26 Sale of Property 4540 Vendin9 Machine Commission 'lltllT olal Money:&\Prope 300,000 925,000 56,000 100,000 84,000 j~t$65l000t 355,000 354,186 1,000,000 1,126,289 40,000 37,632 191,000 60,974 50,000 44,948 '~3~;001l MlJll.~lPZ.9' [DJ~ 186,223 10,014 143,031 3,987 5,664 ~l9.1.9J 402,137 (2,243,619) 316,949 189,186 34,621 (56,639) o .~~~ 138,966 59,500 (3,780) 20,555 (58,842) 33,649 19,011 59,263 8,745 25,538 o (2,578) 424 6,384 3,329 (2,068) 1,101 1l11!l~9 46,172 8,052 (1,025) (359) _5~ll!l..0~ 54,186 201,289 (18,368) (39,026) (39,052) ~;59i.(l 136,223 14 28,031 27,987 (9,336) 67,137 (357,319) 111,949 (60,814) 29,621 (6,639) o ~ 38,966 39,500 (2,280) 10,555 1,158 (1,351) (989) 19,263 8,745 3,938 o (2,578) 424 (116) 1,829 1,432 1,101 (814) 126,289 (2,368) (130,026) (5,052) .' CITY OF SAN BERNARDINO GENERAL FUND REVENUE REPORT FISCAL YEAR 2001.2002 : -~~- .~~ lo;, ,J,j"...... : IN;FEe,1'9VE~N~,~ 4603 Motor Vehicle In Lieu 4621 Booking Fee Subvention 4622 ERAF Subvention 4670 CDBG Reimbursement 4670 20% Reimbursement 4670 Tax Increment Reimb. 4606 Homeowne~s Exemption 4626 POST 4673 Water Reimbursement 4625 State-Mandated Costs 4615 Disaster Prep. Program 4607 Off-Highway Vehicle Tax 4619 Mutual AidlDisaster Reimb. 4671 SBIAA Reimbursement .;rotaIElntergover:.nme.ntaIU I . 9,750,000 10,300,000 10,625,365 689,100 689,100 689,066 000 2,170,100 2,095,100 2,304,190 40,800 40,800 40,800 12,300 12,300 12,300 160,000 152,000 102,721 195,000 175,000 257,607 206,000 190,000 207,889 360,000 200,000 191,958 20,000 20,000 3,403 3,600 4,000 4,916 40,000 90,000 153,020 106,000 100,000 98,199 ~- . lI1:3r7i52!90O: .l~8~Q.Qi .t4'!6.!l~~~}4.i CHARGESlF,0,R:SE~VleE1llm ~rr1ll 4731 Plan Check Fee 200,000 250,000 258,126 4880 EMS User Fee 640,000 640,000 626,125 4798 Storm Drain Utility Fee 270,000 280,000 289,827 4815 Weed Abatement 230,000 230,000 209,782 4733 Building Demolition 250,000 340,000 381,954 4747 False Alarm Fee 85,000 80,000 76,538 4714 Develp Projects 110,000 125,000 121,884 4743 Towing Admin Fee 130,000 110,000 99,420 4766 Building Permit Review 3,000 3,000 3,741 4719 HUD Building Inspection 20,000 0 0 4720 Planning Plan Review 70,000 60,000 57,242 4782/4 Public Wk Subdivision 11,000 75,000 72,040 4785 Non Subdivision Str Imp 9,000 1,000 2,081 4711 Subdivision 50,000 15,000 19,585 4718 Environmental 12,000 7,000 8,149 4735 Release Notice of Pendency 25,000 21,000 22,185 4863 Class Registration Fee 13,000 13,000 12,180 4780 Misc Develp. Servs. Charges 20,000 30,000 33,142 4862 Park Energy Fee 12,000 10,000 8,323 4707 Passport Fees 70,000 56,000 58,684 4702 County Contract 250,000 250,000 250,000 4864 Swimming Pool Fee 57,000 57,000 54,047 4861 Progrm/Facility Use Fee 20,000 20,000 21,078 4865 Non-Resident Fees 4,000 5,000 3,786 4710 Misc Development Services 30,000 30,000 26,304 4790-6 Signal MaintfEnergy . 30,000 20,000 86,355 4802 Str Light Energy Fee 7,000 25,000 24,113 4701 Election Filing Fee 1,800 3,000 3,250 4705 Utility Collection Fee 30,000 75,000 74,719 4881 Paramedic Reimb Contract 175,000 175,000 194,647 "Total!€harQ'e\l't1llllli~Jlll -..' .2~834:800! ~O06;O.OO., _3;099;3071/ _f~ 875,365 (34) o 134,090 o o (57,279) 62,607 1,889 (168,042) (16,597) 1,316 113,020 (7,801) ~3~!5.~ 325,365 (34) o 209,090 o o (49,279) 82,607 17 ,889 (8,042) (16,597) 916 63,020 (1,801) 58,126 8,126 (13,875) (13,875) 19,827 9,827 (20,218) (20,218) 131,954 41,954 (8,462) (3,462) 11,884 (3,116) (30,580) (10,580) 741 741 (20,000) 0 (12,758) (2,758) 61,040 (2,960) (6,919) 1,081 (30,415) 4,585 (3,851) 1,149 (2,815) 1,185 (820) (820) 13,142 3,142 (3,677) (1,677) (11,316) 2,684 0 0 (2,953) (2,953) 1,078 1,078 (214) (1,214) (3,696) (3,696) 56,355 66,355 17,113 (887) 1,450 250 44,719 (281) 19,647 19,647 __264;50,~ 1II1 \l3\1S.l1JI .' CITY OF SAN BERNARDINO GENERAL FUND REVENUE REPORT FISCAL YEAR 2001-2002 : --- M)Scg.lt~,~c).l1YiI r~Jl.i . lll- 4906 Water Fund Contr, 1,775,000 1,800,000 1,835,252 4910 Admin Service Charge 375,000 374,000 372,800 4901 Misc. Other Revenue 216,000 100,000 39,921 4912 Off Track Betting 175,000 130,000 137,370 4741 Sale of Photos 105,000 105,000 111,266 4809-10 Mise Dev, Services 5,000 7,000 9,753 4740-5 Police Misc. Receipts 780,000 765,000 773,295 4746 Property Auction 5,000 3,000 3,183 4750 Investigation Fee 11,200 15,000 15,495 4905 Litigation Settlement 25,000 45,000 45,365 4904 Drunk Driver Reimburmt. 5,000 3,000 2,832 4928 Booking Fee Reimburmt. 17,000 16,000 15,605 4911 Restitutions 6,200 25,500 26,607 4924 Damage Claim Recovery 50,000 32,000 40,062 .T,otallMiscellal100~ _:55.0fitOOl _~2~ _rl!l2818Q&! -- 35,252 (1,200) (60,079) 7,370 6,266 2,753 8,295 183 .495 365 (168) (395) 1,107 8,062 ~~~ " CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS - IN FY 2001-02 BUDGET FY 2001-02 FY 2001-02 REVISED UNAUDIT ESTIMATE ACTUAL VARIANCE REV ESTIMATE! UNAUDIT ACT ~~~~=.'"-~~ .-=--~~~- ~~.-~_. , . ~....J_.__ __ . _~... _ __ __ ~ - .~. . . ..--' "From Special Gas Tax For- $ 2,710,000 $ 2,710,000 $ 2,710,000 0 Street Maintenance-$2,335,000 Street Lighting - $375,000 "From Traffic Safety For - 730,000 730,000 693,321 (36,679) Police Costs "From 1/2 Cent Sales & Road Tax For- 190,700 190,700 190,700 0 Administration "From Cultural Development Fund For- 80,000 122,000 124,962 2,962 Funding Fine Arts and Civic and Promotional Costs "From Traffic Systems Const. For- 25,000 25,000 25,000 0 Administration "From AD 994 Fund For- 27,100 190,100 235,024 44,924 Street Lighting and Signals "From Liability Fund For- 200,000 200,000 200,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- 106,000 106,000 106,000 0 Administration "From Transportation Fund For- 161,500 161,500 161,500 0 Traffic Engineering Costs $50,000 MaintlFuel Alt. Fuel Veh $31,500 Crossing Guards $80,000 ~~~~:"-'___-:-:..TtV". " CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS - IN FY 2001-02 FY 2001-02 VARIANCE FY 2001-02 REVISED UNAUDIT REV ESTIMATE! BUDGET ESTIMATE ACTUAL UNAUDIT ACT ~~=--=-==-~~=--~_.r_= __-=~_~ __~_~~____~~____. ~ _. .. _~ "From General Fund For- Operating Costs $ 490,500 $ 436,100 $ 374,766 $ (61,334) ~-_.- .:-=~-~== '=-_= -::::=--~-==--_ .~. = .. __ . . ~'. h n,.. . "From General Fund For- Operating Costs 265,100 302,100 390,346 88,246 ~~~~~~-~-~~=--~._- ---~- - - -"~ -"- ~ "From General Fund For- Operating Costs 2,652,600 2,665,900 2,631,859 (34,041) ~--,------- -'.-"" .-....... . .~--~....,,-~~~_.-~-~~-~.- -- --. "From General Fund For- Park Facilities Improvements 51,500 51,500 51,500 o ~~~~,-~-=---:.-":.._._-_._.__..... -- - "From General Fund For- Street Sweeping 65,000 65,000 65,000 o ~==~=_._--~~~~-~~-- -. ~ "From General Fund For- Repay Operating Loan 150,000 150,000 150,000 o "~~~~"J!U.i "From General Fund For- Operating Costs . .......---,,....-.--~----,~-..-~,,.-.-~-~ ---.-- . Ii 11 ____....,;L. _ . .. _ oJl. _ ~ "L.. __ ~_ _ .;_ . .: 1,036,000 930,000 898,075 (31,925) ~~==--=-:=---_. ---_.- -~~ "From General Fund For- 1,694,800 1,694,800 1,694,800 0 Operating Costs m"t!milEMBliER.'laEl!JNr.! L "From General Fund For- 537,800 352,700 337,562 (15,138) Operating Costs ====~====-~~~=~--_~_ 9 _ _1 "From General Fund For - Bond Proceeds for HUB Project 2,000,000 2,000,000 0 (2,000,000) " CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS - IN FY 2001-02 BUDGET FY 2001-02 FY 2001-02 REVISED UNAUDIT ESTIMATE ACTUAL VARIANCE REV ESTIMA TEl UNAUDIT ACT "'_,,",,""~~_{..'_ ,.,_...,.~~.. ----~_ - .or- --- -- _ ~I ~L-_----'~_.__._....___~._ ...._ .From Parking & Business Impr For- Administration - $21,525 141,600 148,300 160,161 11,861 .From General Fund For- Administration - $138,636 ~"'='l"3"~"W'l-;:r-H=i1;='~-~-~"'"'--"~-'--'"'----" ~ -r"' .. ..." ~~L--.....j,--------,:",,_-_.- . .From General Fund For - Approved MOU Increases 3,200 o o o c==_==~~~~____.~~ _ _.--< .From General Fund For- Approved MOU Increases 4,900 o o o ~=:===C=:=====~~~~.:._ '..: .From General Fund For- Approved MOU Increases 11,800 o o o r"''''''''!n;,l1~'' . q"'. . ow ... -r-----lr--~ -~- - -- -- ~~~~~~'--_~_~~-/-.-C_,__~-' .From General Fund For- Approved MOU Increases 2,800 o 2,800 2,800 "., ,D,.--~~-- lr - .--~~.-._-' ..- -: ~L.________.-J~~__~_~_. __ ~ "tillIi1!FFili.c::F.SJCU: .From General Fund For- Approved MOU Increases 61,200 o 61,200 61,200 I~~'---'--~r-""""""-----'- ----, ~~L--..:J~~_....._.. .From General Fund For - Approved MOU Increases 96,100 o 96,100 96,100 ~-=L-'=-=~ - T. .~_ ~~~__=_.~____L~~__~ __ ~ u ~~.: .From 1/2 Cent Sales/Rd Tax For- Project Costs 13,800 13,800 13,800 o ~~~,: 1_ ~r--~~~ -~c._._~ ~..9. .' CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS. OUT FY 2001-02 BUDGET FY 2001-02 REVISED ESTIMATE FY 2001-02 UNAUDIT ACTUALS VARIANCE REV ESTI UNAUDIT ACT ====~~~~-=-===-=----==~~~~~'. .- -.-., --- ___~I "To Animal Control Fund For- $490,500 $ 436,100 $ 374,766 $ 61,334 Operating Costs "To CATV Fund For- 265,100 302,100 390,346 (88,246) Operating Costs "To Library Fund For- 2,652,600 2,665,900 2,631,859 34,041 Operating Costs "To EMS Fund For- 150,000 150,000 150,000 0 Repay Operating Loan "To Baseball Fund For- 1,036,000 930,000 898,075 31,925 Operating Costs "To Refuse Fund For- 65,000 65,000 65,000 0 Street Sweeping "To Workers Compensation For- 1,694,800 1,694,800 1,694,800 0 Operating Costs "To Public Park Extension For - 51,500 51,500 51,500 0 Park Facilities Improvements "To Parking District For - 94,600 101,300 138,636 (37,336) Operating Costs "To Cemetery For- 537,800 352,700 337,562 15,138 Operating Costs "To Street Construction Fund For - 2,000,000 2,000,000 0 2,000,000 Operating Costs "To Central Services Fund For- 3,200 0 0 0 Approved MOU Increases "To Liability Fund For - 4,900 0 0 0 Approved MOU Increases .' CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 : TRANSFERS - OUT FY 2001-02 FY 2001-02 VARIANCE FY 2001-02 REVISED UNAUDIT REV ESTI BUDGET ESTIMATE ACTUALS UNAUDIT ACT "To Telephone Fund For- 11,800 0 0 0 Approved MOU Increases "To Utility Fund For- 2,800 0 2,800 (2,800) Approved MOU Increases "To Fleet Services Fund For- 61,200 0 61,200 (61,200) Approved MOU Increases "To Information Services Fund For- 96,100 0 96,100 (96,100) Approved MOU Increases ~~".~"~~~~- _. ~ ~_-,,~_______--l~ ~_____-.J r f;:f~9Ji{;~~"~$~-----'---'-"r-"-' ....i;-.~. -~.._.~".-. - -.. '1 .'------------..................-..~~-.... ~.._. -.. ~- ...- - - - ~--' "To General Fund For .. Street Lighting-$375,OOO Street Maintenance-$2,335,OOO 2,710,000 2,710,000 2,710,000 o =--~ ~==-~~=-=- ~~~~'--~ -~:~ ~- ~ ~ - -- --~ "To General Fund For- Police Costs 730,000 730,000 693,321 36,679 .liij.\;)_~S.'W~ "To General Fund For- Administration of Fund $190,700 . 0) Hl'~ Al{ ~-i:- -. ~. ':1 .-- '-"-'--"'--U'--~ --...,.-- - - --'r . - ---- - - --- ~ l _.-. ~",----,,-JLL-.~~..-___---.J~._ _....~ ~ _~ _ _~__ ..j 204,500 204,500 204,500 o "To Traffic Syst Constr Fund For- Project Costs $13,800 ~~-'r-~ .."... -..--.r-----~-...,;-~---.._....'...1 ~__..:...ow_~~'____'___~~~____._J "To General Fund For- Street Lighting and Signals 27,100 190,100 235,024 (44,924) ~_. "-. '-lC--~--"--~'-'~-- -.. - ---J .L____...-...-.____ _.JLL....__ ._________...~~~~~~_~....-___ "To General Fund For- Refund Reserve Excess 200,000 200,000 200,000 o : ." CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS - OUT FY 2001-02 BUDGET FY 2001-02 REVISED ESTIMATE FY 2001-02 UNAUDIT ACTUALS VARIANCE REV EST' UNAUDIT ACT ~~ ==---~~==---_~-=='~'. .~ -. _ ~~ ~ ~~~~_ _- _ _~~_ ~~-='=.J *To Parking District For- Administration of District 47,000 47,000 21,525 25,475 ~~c:.=--=:=--==-=-===.::::~~_=--__~- --._= *To General Fund For - Fine Arts & Civic Promotional 80,000 122,000 124,962 (2,962) ~~' "I --------..-.~--'--------". - -.-.--- ." , - ~~~~L____""____~~ *To General Fund For - Administration of Fund 25,000 25,000 25,000 o ~~:~-=~~---.~~.;r=-.-=~~'~~~~,_~ .~H ~~~~ ~'\ *To General Fund For - Administration of Fund 100,000 100,000 100,000 o =--~~L=- =-_ _ -~~L~L=--~--=___~.~.______~ __ ~~__.~ *To General Fund For- Administration $1,326,200 Lease City Yards $464,000 Lease City Hall $41,000 1,831,200 1,831,200 1,831,200 o ~.~-. '"1t"----.,,--~~~-- -- ----.1 ~~~~--._-~.j *To General Fund For- Administration 100,000 100,000 100,000 o ~ltilBM>>lINillF.J!! *To General Fund For- Administration 106,000 D c=-=~[=_q.,.~~=_-~~_ -_'_..~~ o 106,000 106,000 161,500 ,~-~---r-r~--'-"---'r~"'--'--'------"'-:"!"-'-~ - - . . 'I I C L---_---.:L__---.JL~ . __.~ ""- .~_~. ~_ ~ _......~___...J o ~BW.I~ *To General Fund For - Traffic Engineering $50,000 MainUFuel All. Fuel Veh $31,500 Crossing Guards $80,000 ~ -'"'L ~~~Q, ~l. 161,500 161,500 . "" ~ ',r-"""'" -:-;-;r., 7T.r.i1' TE8?1i'7Y.TtTi\'")" ~~---- C~,l ro.:lM!~ D ~ ~~~~~~_..~_~ ~ ~==. -.----1 i:'l;';;i! -Ol..~~"\i!_./,..t,IIJU;'I"';':i~k".i.,',.llQU!",'lij 11"'J1f"'}(~lUi:-_ii".lr':"<' ! ~. .'. ~ l-- - ~_ - -~_. '. ,._.=..'1l"-'"'" ,"j""",u,".""", , , " ./,-':.J ___----...........-..--..b..O....-____~~~----...........~~ . . CITY OF SAN BERNARDINO FINANCE DEPARTMENT INTEROFFICE MEMORANDUM AITACIlMENT II TO: FROM: Ways and Means Committee fJ(} Ii Barbara Pachon, Finance Director,fJJ1hV-Cv-' FY 2002-2003 Budget Report SUBJECT: DATE: October 21, 2002 COPIES: Mayor Valles; Council Members; Fred Wilson, City Administrator; DepartmentJDivision Heads Attached, for your review, is the first budget report for FY 2002-2003. 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. It should be noted that all Council approved budget amendments for the first quarter have been included in these reports. Below is a summary on each attached report. The first report (White) is an updated summary fort he General Fund for FY 02-03. This report reconciles the current updated FY 02-03 budget back to the original approved FY 02-03 budget. This report also reflects the proposed carryovers from FY 01-02 that will be on the November 4th Council agenda for approval. For this report it has been assumed that all requested carryovers will be approvec;l, as they are routine and were taken into account during the FY 02-03 budget process. As indicated by this report there is $362,785 in fund balance that is not designated. It is suggested these funds be put into the budget reserve to replenish the funds that were taken out and used in the FY 02-03 budget. The second report (Blue) is an update on revenue collections for FY 2002-2003. Through September 30, 2002, we have collected 16.0% of budgeted revenues, which equals $14,431,031. At this same time last year we had collected $14,477,828 in revenues which is 16.0% of the actual amount of revenues collected for FY 2001-2002. The third report (Pink) is the regular expenditure report by Department. Department expenditures through September 30, 2002, are $23,798,537 or 23.8% of the budget. At this same time last year we had expended $22,775,478 or 24.1 % of the actual amount expended. Assuming Departments were going to spend all of their budgets and in equal montWy amounts, 25% of their budgets should be expended by September 30, 2002. It should be noted the budget column for FY 02-03 on this report does not include the proposed carryovers or Charter 186 adjustments. These items will be included on 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 summary report at the bottom of the yellow page indicates the total personnel expenditures for public safety. 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, 2002. Please let me know if you have any questions. . . CITY OF SAN BERNARDINO ESTIMATED REVENUES AND EXPENDITURES FISCAL YEAR 2002-2003 GENERAL FUND APPROVED CARRYOVERS/ UPDATED BUD AMENDMTS/ L,'~ BUDGET BUDGET FY J~~-93 I.'"; <... FY lli.,63 FD BA!. eH~!!IG~ ESTIMATED REVENUE Property Taxes $ 7,526,000 0 $ 7,526,000 Other Taxes 53,803,000 0 53,803,000 Licenses & Permits 5,927,800 0 5,927,800 Fines and Penalties 859.000 0 859,000 Use of Money & Property 1,545,000 0 1,545,000 Intergovernmental 13,587,900 0 13,587,900 Charges for Services 3,167,000 470,000 3,637,000 Miscellaneous 3,413,500 0 3,413,500 Total Estimated Revenues $ 89,829,200 470,000 $ 90,299,200 Total Transfers In $ 6,983,400 0 $ 6,983,400 Other Finance Sources-Bond Proceeds $ - 2,000,000 $ 2,000,000 IQJ ~~E.!iJ::lMbiIJ;gF.l:INDS'I\V.~I~BEE' "!J'".-. ..' :.$~ 96\[1'2,600' '2'470'000' fl" .;J!l!1282~cto;. - ;; ~,. ~ ,,,,. -'-=- ESliIMA:r:ED'EXPENDITI!J~El!. . " , "~, - e. . .. ,.'') " .~ ~ "," , '" - Mavor $ 1,084,500 $ 19,200 $ 1,103,700 Common Council 463,600 28,300 491,900 Citv Clerk 1,054,400 4,200 1,058,600 Citv Treasurer 130,700 0 130,700 Citv Attornev 2,272,800 0 2,272,800 Code Comoliance 2,942,200 234,400 3,176,600 General Government 3,278,700 39,800 3,318,500 Citv Administrator 553,700 0 553,700 Civil Service 289,700 0 289,700 Human Resource 485,200 9,500 494,700 Finance 1,261,800 800 1,262,600 Develooment Services 7,612,700 918,700 8,531,400 Fire 21,305,000 41,000 21,346,000 Police 43,959,900 139,900 44,099,800 Facilities Manaqement 3,950,000 231,900 4,181,900 Parks, Recreation, & Comm Service 5,447,300 246,500 5,693,800 Public Services 3,358,100 83,200 3,441,300 Total Estimated Expenditures $ 99,450,300 $ 1,997,400 $ 101,447,700 Total Estimated Expenditure Savings $ (1,200,000) $ - $ (1,200,000) Total Transfers Out $ 4,554,100 $ 2,000,000 $ 6,554,100 l;~~Slil~~JED_!!l.EID.UC_TIP..N,S. .:'-"~)t,;'~~,,1l~ l$..:I'p2';~.O~4..0.Q/ ,$,.. , ",.;U.9.lf42'.Ql [~::i'l'1'06i8a1~8001 , l~lC~.~:U!~!!~I&t!~ ):'AY.A!!:l\ID;~ 1~~J!MATm.BEGINNING F!lNQ~~I!AN~E " 1!'!i.U~TE;!ll;tWl!!~Ji!;LND BA~l!C;:E l!!lJQ..q~Tgl}r B~ligR!!E "" IBU!:!Q.ET I;2<C~SJi I:(~FIC::LENCY) .~ - "~'ILn(~:~'J!@)I..$; ; I~b 12';~O~:~O~l!Il,$ f,$. 6;9J5,~00'1 $ I, $ 6',9:j5,60'O: 1 $ - 11$ -I $ '.' II\llil!Q!l)!lt 362,78!f 1 $ rmM!!';i!l!l)1 :9i7.i9.7,t,5.B,J;JI 7.m.~;l.8_5J 1 ;,~;9;1,!tll.Q!lll 362; ~8~ 1 ~I ,~. .,.- , r,8.9a;-l,a~ 11$ 362;7,8& I~$, -1.$ "The change in the beginning fund balance is made up of $375,085 of additional balance from FY01-02 and $1,515,100 of estimated expenditure carryover to be requested for approval at the 11/4/02 Council meeting. "The budget reserve is $2,500,000 from FY 98-99; $1,627,400 from FY 99-00; $2,831,600 from FY 00-01 and $2,870,900 from FY 01-02. Used ($2,914,300) of the reserve for FY 02-03. CITY OF SAN BERNARDINO FISCAL YEAR 2002-2003 GENERAL FUND REVENUE REPORT AS OF SEPTEMBER 30, 2002 ~~~ 4001 Current Secured 4002 Current Unsecured 4003 Prior Taxes 4006 Supplemental 4005 Other Total Property Taxes 6,536,223 390,014 353,987 268,031 110,664 7,658,919 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% MA~O.R1RE.VENV . OUR~ 4221 Sales Tax 27,102,137 4,879,816 18.0% 4224 Utility User Tax 19,442,681 3,774,027 19.4% 4603 Motor Vehicle 10,625,365 1,963,010 18.5% 4670 EDA Reimb. - CDBG 2,304,190 257,887 11.2% 4670 EDA Reimb. - 20% 40,800 - 0.0% 4670 EDA Reimb. - Other 12,300 - 0.0% 4201/11 Franchise Tax 2,591,949 129,494 5.0% 4906 Water Fund Contr. 1,835,252 170,972 9.3% Total Major Revenues 63,954,674 11,175,206 17.5% ~I!ERl(illl r 4301 Business Registration 4222 Transient Occupancy 4303 Misc City Clerk 4701 Election Filing Fee 4707 Passport Fees Total City Clerk 4,288,966 2,439,186 7,932 3,250 58,684 6,798,018 885,114 415,997 1,579 2,753 12,194 1,317,637 20.6% 17.1% 19.9% 84.7% 20.8% 19.4% CODBCOMeLI~NCF --[! 4421 Vehicle Abatement 1,641 - 0.0% 4733 Building Demolition 381,954 63,556 16.6% 4735 Release Pendency Notice 22,185 5,475 24.7% 4815 Weed Abatement 209,782 32,027 15.3% Total Code Compliance 615,562 101,058 16.4% ~CJ1\lnE~I'M!-I~~J;MEtlX. 4420 Parking Citations 596,172 116,912 19.6% 4520 Land/Building Rental 354,186 100,461 28.4% 4530 Parking Rental Fee 37,632 6,272 16.7% 4540-41 Vending Machines 44,948 1,426 3.2% Total Facilities Mgmt 1,032,938 225,071 21.8% ~: :mr,~l'lE1 ~. .~ 6,450,000 - 0.0% 390,000 - 0.0% 326,000 - 0.0% 240,000 - 0.0% 120,000 - 0.0% 7,526,000 - 0.0% 27,835,000 5,123,039 18.4% 19,730,000 3,539,311 17.9% 10,500,000 2,024,414 19.3% 2,103,800 17,052 0.8% 40,800 - 0.0% 12,300 - 0.0% 2,480,000 19,931 0.8% 1,800,000 403,265 22.4% 64,501,900 11,127,012 17.3% 4,250,000 1,065,737 25.1% 2,500,000 417,759 16.7% 6,500 1,367 21.0% 3,000 - 0.0% 56,000 21,188 37.8% 6,815,500 1,506,051 22.1% 1,500 94 6.3% 340,000 97,361 28.6% 25,000 5,220 20.9% 230,000 26,454 11.5% 596,500 129,129 21.6% 745,000 161,698 21.7% 355,000 63,081 17.8% 40,000 3,136 7.8% 50,000 1,277 2.6% 1,190,000 229,192 19.3% CITY OF SAN BERNARDINO FISCAL YEAR 2002.2003 GENERAL FUND REVENUE REPORT AS OF SEPTEMBER 30, 2002 r---~~~~---'f-~~r'Tl I~~g~ ~ --'~=-~-~1 ...~.... J'" ;"J ' '.,..' I . _ A- I '...:rITI~~~I:I:;" I ",~i;I' "'~'Ir/r L :;-th_' : -'-'I.--..i...~_...-..........~. _~ EI E 4880 EMS User Fee 626,125 159,808 25,5% 640,000 144,270 22,5% 4881 Paramedic Reimb Contr 194,647 42,649 21,9% 175,000 64,782 37,0% 4702 County Contract 250,000 0,0% 250,000 0,0% 4450 Fire Citations 1,475 700 47,5% 2,500 180 7,2% 4342 EMS Membership 19,220 12,079 62.8% 21,500 12,193 56.7% 4336 Fire Code Permits 256,345 33,943 13.2% 247,600 28,295 11.4% 4337 Fire Plan Check 100,538 21,631 21.5% 115,000 29,419 25.6% 4615 Disaster Prep, Reimb, 3,403 0.0% 20,000 0.0% Total Fire Department 1,451,753 270,810 18.7% 1,471,600 279,139 19.0% B&BKS,l84l!E~ 4864 Swimming Pool Fee 54,047 43,038 79,6% 57,000 46,541 81.7% 4861 ProgrmlFacility Use 21,078 5,531 26,2% 20,000 5,062 25.3% 4862 Park Energy Fee 8,323 1,108 13.3% 10,000 4,615 46.2% 4863 Class Registration 12,180 3,018 24.8% 13,000 2,078 16.0% 4705 Utility Collection 74,719 0.0% 25,000 0,0% 4865 Non-Resident Fees 3,786 2,197 58,0% 5,000 362 7.2% Total Parks Dept 174,133 54,892 31.5% 130,000 58,658 45.1% Q5Y.El!QP.MENTiS~ 4304 Misc Permits 23,329 5,515 23,6% 4330 Building Permits 519,500 109,953 212% 4331 Mechanical Permits 220,555 51,637 23.4% 4333 Mobile Home Park 28,624 - 0.0% 4351 Street Cut Permits 8,422 654 7.8% 4352 Misc, License/Permits 36,384 8,438 23.2% 4360 Grading Permits 6,101 1 ,467 24.0% 4361 Construction Permits 159,263 83,467 52.4% 4362 On Site Permits 233,649 92,066 39.4% 4363 On Site Plan Check 119,011 54,979 46,2% 4710 Misc Planning 26,304 (6,460) -24.6% 4711 Planning Subdivision 19,585 (329) -1.7% 4714 Develp Project 121,884 18,458 15.1% 4718 Environmental 8,149 378 4.6% 4720 Planning Plan Review 57,242 17 ,230 30.1% 4731 Plan Check Fee 258,126 62,676 24.3% 4766 Building Permit Rev 3,741 762 20.4% 4780 Misc Public Work 33,142 5,246 15.8% 478214 PW Subdivision 72,040 55,682 77.3% 4785 Non Subdivision Str 2,081 100 4.8% 4790-6 Sig MainllEnergy 86,355 - 0.0% 4798 Storm Drain Utility 289,827 66,995 23,1% 4802 Str Light Energy Fee 24,113 6,146 25.5% 4810 Misc. Development Serv 9,753 - 0.0% Total Development Servs 2,367,180 635,060 26.8% 21,500 5,750 26.7% 480,000 229,595 47.8% 210,000 84,506 40.2% 28,200 - 0.0% 11,000 1,312 11.9% 36,500 13,078 35.8% 5,000 1,068 21.4% 140,000 4,895 3.5% 235,000 67,001 28.5% 120,000 20,830 17.4% 30,000 5,101 17.0% 15,000 10,511 70.1% 595,000 16,586 2.8% 7,000 (1,927) -27.5% 60,000 30,230 50.4% 225,000 90,558 40.2% 3,000 880 29.3% 30,000 4,586 15.3% 75,000 4,674 6.2% 1,000 - 0.0% 20,000 (550) -2.8% 280,000 34,905 12.5% 25,000 946 3.8% 7,000 - 0.0% 2,660,200 624,535 23.5% CITY OF SAN BERNARDINO FISCAL YEAR 2002-2003 GENERAL FUND REVENUE REPORT AS OF SEPTEMBER 30, 2002 r--:---- -----7"--71~I-"'~l~.-:;;' L_~~~. vJi1i:~J:t1i:iy: '..-:@.hj 'e 4215 Tow Franchise 288,000 72,000 25.0% 4305 Annual Alarm Permit 216,158 27,988 12.9% 4616 POST 257,607 21,705 8.4% 4741 Sale of Photos 111,266 19,490 17.5% 4743 Towing Admin. Fee 99,420 28,840 29.0% 4740-5 Misc. Receipts 773,295 129,971 16.8% 4747 False Alarm Fee 76,538 20,122 26.3% 4904 Drunk Driver Reimb 2,832 640 22.6% 4750 Investigation Fee 15,495 3,107 20.1% 4928 Booking Fee Reimb 15,605 3,669 23.5% 4911 Restitutions 26,607 3,392 12.7% 4746 Property Auction 3,183 0.0% Total Pollee Department 1,886,006 330,924 17.5% ~g;~ Ee 4225 Sales Tax Safety 4505 Interest Eamings 4621 Booking Fee Subvention 4901 Misc. Other Revenue 4912 Off Track Betting 4910 Admin Service Charge 4606 Homeowner Exemption 4410 General Fines 4223 Prop. Transfer Tax 4671 SBIAA Reimbursement 4922-26 Sale of Property 4673 Water Reimbursement 4625 State-Mandated Costs 4619 Mutual Aid/Disaster Remb 4905 Litigation Settlement 4607 Off-Highway Vehicle 4924 Damage Claim Recovery Total Miscellaneous 593,361 1,126,289 689,066 39,921 137,370 372,800 102,721 138,052 349,621 98,199 60,974 207,889 191,958 153,020 45,365 4,916 40,062 4,351,584 104,502 (63,287) 20,503 34,548 8,750 46,227 189,168 14,633 7,002 (21) 5,145 367,170 17.6% -5.6% 0.0% 51.4% 25.1% 0.0% 0.0% 0.0% 0.0% 8.9% 75.8% 91.0% 7.6% 4.6% 0.0% 0.0% 12.8% 8.4% 1~,p..1,,~E~E~!!.l2!~I!.$J.!IJl~~.!!lIi1JIL$~;!Zl1l'JBI~1 -~,,-~-~ YU I'~-'n. ': _=,.;".' ':::.1 } 1:','l'.......;"(1.1J.17 11 (~!..~;..,..~I~lr- ,e{e)':L.j _.... ~&________l.~~___~_.__~ 288,000 72,000 25.0% 215,000 38,597 18.0% 175,000 - 0.0% 105,000 29,350 28.0% 120,000 29,050 24.2% 765,000 13,373 1.7% 80,000 20,691 25.9% 3,000 405 13.5% 15,000 3,082 20.5% 16,000 4,225 26.4% 25,500 3,684 14.4% 3,000 - 0.0% 1,810,500 214,457 11.8% 650,000 103,577 15.9% 1,000,000 (40,770) -4.1% - - 0.0% 100,000 6,654 6.7% 130,000 31,833 24.5% 374,000 - 0.0% 152,000 - 0.0% 110,000 13,556 12.3% 320,000 86,751 27.1% 100,000 - 0.0% 100,000 - 0.0% 190,000 - 0.0% 200,000 - 0.0% 90,000 55,239 61.4% 45,000 (30) -0.1% 4,000 - 0.0% 32,000 6,048 18.9% 3,597,000 262,858 7.3% 1~.l!I!'~91~,qlll~~1 CITY OF SAN BERNARDINO FISCAL YEAR 2002-2003 GENERAL FUND EXPENDITURE REPORT AS OF SEPTEMBER 30, 2002 c----.------.- ~'-~....~~~~ ': L'~?' j j __~ ~...._~..._ ..._~__-"......._~~..-.....-L-~__~ ~ - -"-?BiJil~'-~~"JiIiE -~ ..---....;....,~...._.y._~~ MAYOR 943.335 225.751 23.9% COUNCIL 341,671 84,189 24.6% CITY CLERK 1,021.127 241.523 23.7% CITY TREASURER 23,952 6.180 25.8% CITY ATTORNEY 2,047,354 460,830 22.5% CODE COMPL 2.951,334 605,783 20.5% GENERAL GOVT 2,162.341 690.101 31.9% CITY ADMIN 496.268 118.995 24.0% HUMAN RESOURCES 403.392 96,038 23.8% FINANCE 1.141,902 265,508 23.3% CIVIL SERVICE 253,557 54,930 21.7% DEVELOP SERVICES 7.465,457 1,653,186 22.1% FIRE 21,041.818 4.911,364 23.3% POLICE 42,004.232 10.272.454 24.5% FACILITIES MGMT 3,762,169 885.703 23.5% PARKS 5,111,370 1,391,384 27.2% PUBLIC SERVICES 3.321,766 811,559 24.4% ~~i$B -~~ :---~--~"mrc--~"--- ~- L~~--,----"---......-~,,,-~,~__ __.__ ___ ___~_____ r~ . ?NiF~'" .~ ~~..._-_.~. 1,084.500 229.238 21.1% 463,600 90,201 19.5% 1.054,400 266,006 25.2% 130.700 34,582 26.5% 2,272.800 529,480 23.3% 2,942,200 707.872 24.1% 3,291.000 (40,499) -1.2% 553,700 130,296 23.5% 485,200 107,561 22.2% 1,261,800 285,035 22.6% 289,700 56.825 19.6% 8.082,700 1,767,560 21.9% 21,305.000 5,667.755 26.6% 43,959,900 10,835,435 24.6% 3.950.000 940,260 23.8% 5.605,300 1.463,985 26.1% 3,358.100 726.945 21.6% ~. i2 . ,..... CITY OF SAN BERNARDINO FISCAL YEAR 2002-2003 GENERAL FUND OVERTIME REPORT AS OF SEPTEMBER 30, 2002 @Mmmmm~g#n#mmM@$.~mWMmt#@@MM mUna:UAgj ;;IQW!F$eR1H WUMMfiMMt ~ili@Wge~~lg8U~'t1J9N%Mn{MiM~r:MfMMW i'&lm'ii299~j jg~901t~'?M ielmeNP MAYOR 0 0 0.0% CITY CLERK 1 33 0 0.0% CITY ATTORNEY 920 1 92 0.0% CODE COMPLIANCE 1 0,692 3,000 28. 1 % HUMAN RESOURCES 0 0 0.0% FINANCE 0 0 #DIV/O! DEVELOPMENT SERVICES 88,382 21 ,31 0 24. 1 % FIRE 3,092.795 882.428 28.5% POLICE 2.496,609 558,331 22.4% FACILITIES MANAGEMENT 5,231 2, 1 78 41 .6% PARKS & RECREATION 6.349 1 .901 29.9% PUBLIC SERVICES 1 1 1 .640 41 .443 37. 1 % MIQTAti9I;NeRAPFYNPiHi@j@i! S&1Zl7S1 IiMtn~19Il~r ""''''''2IUI% ~~L.J-.-,.::",:'-__:';':'-).,.,:<} ~%.wv.-,.:-,}-:-.,{-:~ SUMMARY REPORT TOTAL PERSONNEL FOR PUBLIC SAFETY MiAPIIJAti:!.!V,f4S$eeTIm@WAWlMi! WMijJ:U;~QJ~!e;UQN;;@j@@@@H@;jjg9qlt?'99~ .M?'901t~Qq~m lelmeNP.' FIRE 18,249,976 4.437.646 24.3% POLICE 34,554,017 8.328,317 24.1% HSl)QGeT:# N!!:!MWl$eelW @t{W5m@# ;~99i!f~Qq~ fJ~Qq'?t~ggaM i'elmeNP 0 674 0.0% 500 0 0.0% 1 ,000 1 ,794 179.4% 1 1 ,500 5,286 46.0% 0 0 0.0% 800 0 0.0% 54.400 22.525 41 .4% 2.743.900 1 ,083.466 39.5% 1 ,51 1 ,500 632,903 41 .9% 0 1 ,302 0.0% 8.000 1 .444 1 8.1 % 51 .800 6.747 1 3.0% ;;~\~l4lmj @m1i:I~1ID [Mtt.g4~~ I Bl)QgelM i4QgH;$eeill @MtfSMfMW: .". . ..------.-.. ;:?99?t2!lq~! @2!lq?*~qq~;;; ;;~eeNQ 1 8 , 1 43 . 1 00 4 , 967 , 305 27 .4% 3 5 . 777 ,200 8 . 704 , 930 24 3 % CITY OF SAN BERNARDINO FISCAL YEAR 2002-2003 GENERAL FUND PERSONNEL REPORT AS OF SEPTEMBER 30, 2002 lMAQI"'AUlllll!WQU;#)$a:rnll@llW~i@M illllllQ!;$~!!qNiMl.i!I'~1t~qq~MMi~qq1f~gllalllliEXReNQ MAYOR 624,217 149,404 23.9% COUNCIL 234,339 57,475 24.5% CITY CLERK 790,052 183,001 23.2% CITY TREASURER 23,478 5,826 24.8% CITY ATTORNEY 1,363,554 324,651 23.8% CODE COMPL 1,569,507 368,656 23.5% GENERAL GOVT (1,901,474) (455,073) 23.9% CITY ADMIN 426,598 104,811 24.6% HUMAN RESOURCE 274,019 67,503 24.6% FINANCE 910,036 211,677 23.3% CIVIL SERVICE 175,569 44,322 25.2% DEVELOP SERVICE 3,783,513 839,366 22.2% FIRE 18,249,976 4,437,646 24.3% POLICE 34,554,017 8,328,317 24.1% FACILITIES MGMT 1,555,752 380,165 24.4% PARKS 2,862,296 850,497 29.7% PUBLIC SERVICES 1,733,854 402,391 23.2% TQTALGENFUNDW1$67;229j3o.3 1$;16;300.;&351 lOG 24:;2% @l}:J'iIJDPfiTUrm M~I"H#::i$S1%Wlttttm"Nntf 111~g~f~:tM 20022003 END :V::::,. _ '," '.:; ',',_ ';:'-':::::,::=:=::- . .~~~}:. .....,. .:::::.>:.;.>:.,exp,. -:'-' :~:,::,::",,'-':"'::...:.......:::.,.....:.,...-.,..':-....::<::::,:~:::::..._'...._':..._..::::...-,-,_.:-.-.-....:: 740,300 159,228 21.5% 352,800 61,629 17.5% 863,700 224,752 26.0% 102,600 25,478 24.8% 1,535,100 377,391 24.6% 1,744,700 409,159 23.5% 100,000 (503,299) -503.3% 463,500 1 17,634 25.4% 354,600 87,909 24.8% 956,100 206,679 21.6% 226,700 45,420 20.0% 4,430,400 1,016,230 22.9% 18,143,100 4,967,305 27.4% 35,777,200 8,704,930 24.3% 1,772,800 441,569 24.9% 3,1 15,300 810,515 26.0% 1,830,500 438,071 23.9% $ 72;$09AOO $ 17l59o. &00 rt4t3!W t._ ){::::.. :':.....::...::;.:.::':::...:-:..:<J; t. :-:h.r,4,..:.._-:::..-:t.._.;.__-::_-.,j: @@h......,:..,:\::..,::.,.,::;