HomeMy WebLinkAbout16-Finance Department
..--
.~~.~., n",n~ .~
CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION
From: Barbara Pachon, Finance
Director
Subject: Receive and File the
Second Quarter.Budget Report for FY
2004-2005.
Dept: Finance
Date: 2/1/05
Synopsis of Previous Council Action:
August 16, 2004 Resolution 2004-263 approving and adopting the FY 2004-
2005 Budget
January 26, 2005 Ways and Means Committee reviewed the FY 2004-2005
Second Quarter Budget Report
Recommended motion:
That the Mayor and Common Council receive and file the FY 2004-2005 Second
Quarter Bu.dget Report
~~aL
Signa ure
Contact person: Barbara Pachon, Director of Finance
Phone: 5242
Supporting data attached: Ward: All
FUNDING REQUIREMENTS: Amount: N/A
Source:
Council Notes:
Finance: ~~dtL.
/'
Agenda Item No. # / (p
~7/0S'
",\,V" ~",
- '"-~,..
""-n'
,-~
',r IT ,- ""rn c. .'."-."""--'i1:J~NV'"-''''-'T ." 'C,-F-",-W"'~'i'it!l'-
CITY OF SAN BERNARDINO -REQUEST FOR COUNCIL ACTION
STAFF REPORT
SUBJECT
Receive and file the Second Quarter Budget Report for FY 2004-2005.
BACKGROUND
On Wednesday, January 26,2005, the Finance Department presented to the Ways and Means
committee the Second Quarter Budget Report for FY 2004-2005.
Attachment I is the Second Quarter Report for FY 2004-2005. In summary this report shows the
City's General Fund revenues and expenditures to be on target. For some of the major revenue
sources included in the City's budget there has not been any collections yet. These revenues will
start to be collected in January and February. The Mid-Year Report for FY 2004-2005 will be
presented in March and will provide more insight into the City meeting its budget projections.
FINANCIAL IMPACT
There is no financial impact to the City to receive and file this Second Quarter Budget report for'
FY 2004-2005.
RECOMMENDATION
Receive and file the Second Quarter Budget Report for FY 2004-2005.
_C__~"<"
< ""C<W
'''CU'' 'r :-c'- .=~~.'-~' 'c"~nlY'fr~r""" !F~""<:' ".:.c c-"~'Tc"'2',",'_o__ ..
CITY OF SAN BERNARDINO
FINANCE DEPARTMENT
INTEROFFICE MEMORANDUM
A H().o~ fv18Y1+ ~
TO:
Ways and Means Committee
$~
FROM:
Barbara Pachon, Finance Director
SUBJECT: FY 2004-2005 General Fund Budget Report
DATE: January 21,2005
COPIES: Mayor Valles; Council Members; Fred Wilson, City Administrator;
DepartmentlDivision Heads
Attached, for your review, is the second budget report for FY 2004-2005. The report covers the six-
month period of July through December. Included in this budget report is the revenue, expenditure,
overtime, and personnel reports compared to the approved budget. As in prior budget updates, each
report has been color coded for easy reference. Below is a summary on each attached report.
The first report (Blue) is an update on revenue collections for FY 2004-2005. Through December 31,
2004, we have collected 38.6% of budgeted revenues, which equals $40,853,761. At this same time last
year we had collected $39,794,390 in revenues which is 38.3% of the actual amount of revenues
collected for FY 2003-2004. ".
The second report (pink) is the regular expenditure report by Department. Department expenditures
through December 31, 2004, are $56,778,481 or 47.3% of the budget. At this same time last year we had
expended $52,596,923 or 49.9% of the actual amount expended. Assuming Departments.;were going to
spend all of their budgets and in equal monthly amounts, 50% of their budgets should be expended by
December 31,2004.
The third 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 fourth 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, 50% of the personnel budget should be expended at December 31,2004.
Please let me know if you have any questions.
CITY OF SAN BERNARDINO
FISCAL YEAR 2004-2005
GENERAL FUND REVENUE REPORT
AS OF DECEMBER 31, 2004
..,. "
ACTUAL
2003-2004
DE'SCRIPTioN
PROPERTY"T AXES .. .
4001 Current Secured 7,385,445 3,133,489 42.4%
4002 Current Unsecured 449,712 398,426 88.6%
4003 Prior Taxes 388,958 206,373 53.1%
4006 Supplemental 439,855 115,153 26.2%
4005 Other 123,995 50,466 40.7%
4007 Prop Tx In Lieu of VLF - - 0.0%
Total Property Taxes 8,787,965 3,903,907 44,4%
MAJOR REVENUE SOURCES
4221 Sales Tax 32,277 ,342 14,043,484 43.5%
4220 Prop Tx in Lieu Sales Tx - - 0.0%
4224 Utility User Tax 21,802,368 9,062,234 41.6%
4603 Motor Vehicle 12,176,530 1,779,734 14.6%
4670 EDA Reimb. - CDBG 2,593,874 721,795 27.8%
4670 EDA Reimb. - 20% 40,800 40,800 100.0%
4670 EDA Reimb. - Other 83,300 12,300 14.8%
4201/11 Franchise Tax 2,796,720 403,771 14.4%
4906 Water Fund Contr. 1,957,748 798,724 40.8%
Total Major Revenues 73,728,682 26,862,842 36.4%
CITY CLERK
4301 Business Registration 4,808,603 1,714,539 35.7%
4222 Transient Occupancy 2,797,346 1,138,572 40:7%
4303 Misc City Clerk 10,546 4,772 45.2%
4701 Election Filina Fee 10,120 10,199 100.8%
4707 Passport Fees 85,891 38,122 44.4%
Total City Clerk 7,712,506 2,906,204 37.7%
CODE COMPLIANCE
4421 Vehicle Abatement 176 83 47.2%
4411 Admin Citation Fines - - 0.0%
4733 Buildinq Demolition 609,035 257,716 42.3%
4735 Release Pendency Notice 16,047 7,099 44.2%
4815 Weed Abatement 322,678 139,232 43.1%
Total Code Compliance 947,936 404,130 42.6%
FACILITIES MANAGEMENT
4420 Parkinq Citations 868,945 297,032 34.2%
4520 Land/Buildinq Rental 270,033 168,685 62.5%
4530 Parkinq Rental Fee 47,474 24,380 51.4%
4540-41 Vendinq Machines 44,760 15,625 34.9%
Total Facilities Mgmt 1,231,212 505,722 41.1%
7,665,000 3,252,566 42.4%
460,000 402,797 87.6%
395,000 230,057 58.2%
450,000 238,247 52.9%
125,000 35,205 28.2%
8,369,200 - 0.0%
17,464,200 4,158,872 23.8%
26,225,000 12,400,720 47.3%
7,875,000 - 0.0%
22,215,900 9,664,452 43.5%
1,478,300 777,507 52.6%
2,790,800 458,036 16.4%
40,800 40,800 100.0%
83,300 .. 83,300 100.0%
2,802,400 364,241 13.0%
1,960,000 813,044 41.5%
65,471,500 j.24,602,100 37.6%
4,830,000 1,983,668 41.1%
2,800,000 ' 1,187,070 42.4%
10,500 2,583 24.6%
500 - 0.0%
90,000 28,518 31.7%
7,731,000 3,201,839 41.4%
3,000 5,229 174.3%
- 7,020 0.0%
400,000 722,763 180.7%
20,000 9,914 49.6%
300,000 309,506 103.2%
723,000 1,054,432 145.8%
970,500 470,160 48.4%
269,000 243,962 90.7%
50,000 16,381 32.8%
37,000 13,596 36.7%
1,326,500 744,099 56.1%
CITY OF SAN BERNARDINO
FISCAL YEAR 2004-2005
GENERAL FUND REVENUE REPORT
AS OF DECEMBER 31, 2004
,,"'~;~,~':1f: .,1 ~~. '\~A.~JU~, :: JU~-D~F~ ~'.~""'~
,. :+,i"DESCRIPTION.';.~ r"~0~04fi ,r 2003-200"4" 'COLI.:'
FIRE DEPARTMENT ..'-:~
4880 EMS User Fee 498,559 261,513 52.5%
4881 Paramedic Reimb Contr 280,723 129,564 46.2%
4702 County Contract 250,000 - 0.0%
4450 Fire Citations 315 190 60.3%
4342 EMS Membershio 17,477 11,979 68.5%
4336 Fire Code Permits 229,305 92,160 40.2%
4337 Fire Plan Check 129,655 70,099 54.1%
4615 Disaster Prep. Reimb. 27,181 - 0.0%
4751 Fire Aoartment Insoec. 21,675 875 0.0%
4753 Fire Archival Fee - - 0.0%
4754 Fire business Occuo Insp - - 0.0%
4755 fire Rental Inspection - - 0.0%
4752 Fire Wildland Insoec. - - 0.0%
Total Fire Department 1,454,890 566,380 38.9%
PARKS & RECREATION
4864 Swimmina Pool Fee 50,273 41,539 82.6%
4861 Proorm/Facilitv Use 36,666 16,960 46.3%
4862 Park Eneroy Fee 8,853 7,623 86.1%
4863 Class Reoistration 19,815 8,102 ,::40.9%
4705 Utility Collection 40,339 28,802 71.4%
4865 Non-Resident Fees 1,605 495 30.8%
Total Parks Dept 157,551 103,521 65.7%
DEVELOPMENT SERVICES
4304 Misc Permits 24,911 10,959 44.0%
4330 Building Permits 618,186 291,312 47.1%
4331 Mechanical Permits 254,562 114,835 45.1%
4333 Mobile Home Park 29,487 40,086 135.9%
4351 Street Cut Permits 126,328 13,527 10.7%
4352 Misc. License/Permits 90,632 52,008 57.4%
4360 Gradino Permits 11,250 5,809 51.6%
4361 Construction Permits 219,585 85,737 39.0%
4362 On Site Permits 291,009 194,707 66.9%
4363 On Site Plan Check 148,306 107,716 72.6%
4710 Misc Plannina 63,797 20,993 32.9%
4711 Plan nino Subdivision 100,858 43,524 43.2%
4714 Develp Proiect 537,164 79,563 14.8%
4718 Environmental 25,448 4,070 16.0%
4720 Plan nino Plan Review 95,059 41 ,162 43.3%
4731 Plan Check Fee 339,434 145,429 42.8%
4766 Buildino Permit Rev 6,836 2,192 32.1%
4780 Misc Public Work 28,917 14,220 49.2%
4782/4 PW Subdivision 177,119 83,586 47.2%
4785 Non Subdivision Str 43,991 8,927 20.3%
4789 Archival Fee 12,818 1,969 0.0%
4790-6 Sio MainUEneroy 17,342 - 0.0%
4798 Storm Drain Utility 256,644 112,995 44.0%
4802 Str Light Energy Fee 37,821 23,637 62.5%
4810 Misc. Development Serv 6,979 233 3.3%
Total Development Servs 3,564,483 1,499,196 42.1%
.t,~~-t
~CO~L
850,000 275,219 32.4%
259,000 86,376 33.3%
250,000 125,000 50.0%
500 - 0.0%
15,000 9,362 62.4%
235,000 115,268 49.1%
135,000 95,173 70.5%
14,800 1,379 9.3%
50,000 - 0.0%
6,200 - 0.0%
185,400 38,289 20.7%
494,300 - 0.0%
- 425 0.0%
2,495,200 746,491 29.9%
90,800 47',144 51.9%
56,100 28,458 50.7%
10,000 2,925 29.3%
30,000 7,747 25.8%
50,000 15,552 31.1%
2,500 ~ 842 33.7%
239,400 '. 102,668 42.9%
'.
21,500 10,167 47.3%
650,600 442,217 68.0%
270,000 162,642 60.2%
33,000 (10) 0.0%
85,000 19,275 22.7%
70,000 54,523 77.9%
8,000 7,217 90.2%
200,000 145,919 73.0%
315,000 283,043 89.9%
150,000 206,833 137.9%
68,000 22,048 32.4%
98,500 53,360 54.2%
177,600 72,843 41.0%
25,000 9,176 36.7%
95,000 101,136 106.5%
340,000 248,150 73.0%
8,000 2,346 29.3%
54,600 18,382 33.7%
110,000 189,586 172.4%
10,000 71,422 714.2%
10,000 17 ,226 172.3%
25,000 21,258 85.0%
283,000 160,082 56.6%
28,000 7,980 28.5%
8,000 - 0.0%
3,143,800 2,326,821 74.0%
CITY OF SAN BERNARDINO
FISCAL YEAR 2004-2005
GENERAL FUND REVENUE REPORT
AS OF DECEMBER 31, 2004
P,OLlCE DEPMTMENT:1'.~~~';ii
4215 Tow Franchise 288,000 144,000 50.0%
4305 Annual Alarm Permit 216,805 94,254 43.5%
4616 POST 142,444 15,335 10.8%
4741 Sale of Photos 139,279 58,119 41.7%
4743 TowinQ Admin. Fee 153,900 47,390 30.8%
4740-5 Misc. Receipts 800,539 257,348 32.1%
4747 False Alarm Fee 54,013 29,553 54.7%
4904 Drunk Driver Reimb 1,237 661 53.4%
4750 InvestiQation Fee 13,348 6,573 49.2%
4928 BookinQ Fee Reimb 14,986 6,101 40.7%
4911 Restitutions 37,170 21,241 57.1%
4746 Properly Auction 2,945 - 0.0%
Total Police Department 1,864,666 680,575 36.5%
MISCELlANEOUS
4225 Sales Tax Safety 701,088 286,656 40.9%
4930 Sewer Contr. - Water - - 0.0%
4931 Water Land Sales . - - 0.0%
4226 Verdemont Fire Station AD - - 0.0%
4505 Interest Earnings (64,422) 135,164 -209.8%
4621 Bookino Fee Subvention 689,066 689,066 100.0%
4901 Misc. Other Revenue 285,688 17,185 6.0%
4912 Off Track BettinQ 198,217 100,520 50.7%
4910 Admin Service Charge 345,682 345,600 100.0%
4606 Homeowner Exemption 156,542 23,481 15.0%
4410 General Fines 203,692 47,290 23.2%
4223 Prop. Transfer Tax 795,166 237,625 29.9%
4671 SBIAA Reimbursement 124,244 31,457 25.3%
4922-26 Sale of Property 611,631 210,071 34.3%
4673 Water Reimbursement 166,140 150,000 90.3%
4625 State-Mandated Costs 30 20 0.0%
4619 Mutual Aid/Disaster Remb 247,685 83,559 33.7%
4905 Litigation Settlement 32,484 - 0.0%
4607 Off-Hiohwav Vehicle 4,157 - 0.0%
4924 DamaQe Claim Recovery 18,009 4,219 23.4%
Total Miscellaneous 4,515,099 2,361,913 52.3%
I TOTAL GENERAL FUND
I $103,964,990 I $39,794,390 I 38.3-1.1
288,000 140,000 48.6%
225,000 89,106 39.6%
150,000 56,494 37.7%
140,000 55,688 39.8%
180,400 106,650 59.1%
895,300 229,885 25.7%
55,000 23,442 42.6%
1,000 1,018 101.8%
13,000 11,117 85.5%
16,000 4,023 25.1%
25,000 10,855 43.4%
53,000 2,616 4.9%
2,041,700 730,894 35.8%
725,000 322,878 44.5%
500,000 500,000 100.0%
- 475,000 221,116 46.6%
''- 30,000 - O' 0.0%
400,000 220,362 55.1%
689,000 689,066 0.0%
120,000 12,749 10.6%
'180,000 49,304 27.4%
..345,600 349,600 101.2%
156,500 22,098 14.1%
150,000 47,008 31.3%
600,000 300,959 50.2%
220,000 23,405 10.6%
100,000 444 0.4%
275,000 328,000 119.3%
- - 0.0%
220,000 85,911 39.1%
- - 0.0%
5,000 - 0.0%
15,000 12,645 84.3%
5,206,100 3,185,545 61.2%
I $105,842,400 I $4O,853,761:'1~~:6%1
CITY OF SAN BERNARDINO
FISCAL YEAR 2004-2005
GENERAL FUND EXPENDITURE REPORT
AS OF DECEMBER 31, 2004
:~ :~, ;...r,.,.~...~:_",.} ....$ ~, ACTUAL ,JUL - DEC., . ./0. "
", DESCRIPTION 2003-2004 ",2003-2004 EXPEND
MAYOR 980,880 477,347 ' 48.7%
COUNCIL 430,573 199,430 46.3%
CITY CLERK 1,157,503 532,605 46.0%
CITY TREASURER 137,721 64,236 46.6%
CITY ATTORNEY 2,406,585 1,087,909 45.2%
CODE COMPL 2,897,101 1,409,634 48.7%
GENERAL GOVT 6,560,392 3,248,600 49.5%
CITY ADMIN 526,992 264,800 50.2%
HUMAN RESOURCES ' 330,621 153,198 46.3%
FINANCE 1 ,138,693 575,317 50.5%
CIVIL SERVICE 243,147 114,890 47.3%
DEVELOP SERVICES 6,903,208 3,232,887 46.8%
FIRE 24,852,170 12,829,459 51.6%
POLICE 45,513,387 23,032,585 50.6%
FACILITIES MGMT 3,306,084 1,595,635 48.3%
PARKS 5,122,323 2,4 72,892 48.3%
PUBLIC SERVICES 2,805,320 1,305,499 46.5%
TOTAL GEN FUND $105,312,700 $52,596,923 49.90/.
BUDGET";:~ J JUL 0:' D,EC,,' ~!~r~ ~~ %:-'~'"
2004-2005 t 200+2905~. , EXP.END
1,002,000 404,368 40.4%
490,300 208,323 42.5%
1,203,200 578,395 48.1%
146,900 73,070 49.7%
2,445,500 1,176,574 48.1%
3,125,900 1,444,693 46.2%
12,221,700 3,573,317 29.2%
581,800 263,404 45.3%
378,500 176,982 46.8%
1,197,200 540,460 45.1%
230,700 117,021 50.7%
5,1,19,400 2,164,404 42.3%
27,575,700 13,838,053 50.2%
48,471,500 25,107,177 51.8%
4,490,200 2,012,743 44.8%
5,500,400 2,471,134 44.9%
5,915,100 2,628,363 44.4%
$ 120,096,000 $56,778,481 ;( -~.; 47:9%
CITY OF SAN BERNARDINO
FISCAL YEAR 2004-2005
GENERAL FUND OVERTIME REPORT
AS OF DECEMBER 31, 2004
ACTUAL JUL - DEC. %
, DESCRIPTION " 2003-2004 '2003-2004 EXPEND
" ...
MAYOR 0 0 0.0%
CITY CLERK 0 0 0.0%
CITY ATTORNEY 1,086 666 0.0%
CODE COMPLIANCE 31,540 18,297 58.0%
HUMAN RESOURCES 0 0 0.0%
FINANCE 0 0 0.0%
DEVELOPMENT SERVICES 96,975 48,171 49.7%
FIRE 4,461,380 2,517,924 56.4%
POLICE 1,934,798 997,043 51.5%
FACILITIES MANAGEMENT 5,978 2,617 43.8%
PARKS & RECREATION 6,065 7,026 115.8%
PUBLIC SERVICES 86,084 62,060 72.1%
TOTAL GENERAL FUND 6,623,906 3,653,804 55.2%
SUMMARY REPORT
TOTAL PERSONNEL
FOR PUBLIC SAFETY
ACTUAL JUL - DEC %
DESCRIPTION 2003-2004 2003-2004 EXPEND
FIRE 22,611,198 11,567,597 51.2%
POLICE 40,527,327 19,850,587 49.0%
BUDGETiB !rJUE~p~C~ mw/.~
,2004=200S'Z ;'~P04;;~qO.5,' II;XPEND
0 0 0.0%
500 0 0.0%
3,000 345 11.5%
31,500 14,710 46.7%
0 0 0.0%
800 0 0.0%
16,500 5,307 32.2%
4,249,200 2,468,684 58.1%
1,742,600 1,226,425 70.4%
7,200 2,854 0.0%
18,000 8,125 45.1%
46,700 62,811 134.5%
6,116,000 3,789,26~ ' 't\;,~~~~t/o
BUDGET JUL - DEC ~-~'~'~i>_%-s~:.
2004-2005 2004-2005 ' EXPEND
24,533,500 12,289,541 50.1%
43,441,900 21,993,147 50.6%
CITY OF SAN BERNARDINO
FISCAL YEAR 2004-2005
GENERAL FUND PERSONNEL REPORT
AS OF DECEMBER 31, 2004
If.. ~~p~"." ,'- ACTUAL,' ~JUL ,- DEC. .r~~
..~~~_ ,;:i.<' -i :..\ ' .<~ e". :; __.
.,pg!~BIRT.'Q~:j.: ~:200~~20.04~l ~29'p3-200~ \~g~.tiQi
MAYOR 802,109 398,123 49.6%
COUNCIL 327,521 149,531 45.7%
CITY CLERK 877 ,598 421 ,297 48.0%
CITY TREASURER 118,060 54,254 46.0%
CITY ATTORNEY 1,605,074 781,837 48.7%
CODE COMPL 1,851,888 917,997 49.6%
GENERAL GOVT (2,138,169) (1,058,114) 49.5%
CITY ADMIN 476,643 238,569 50.1%
HUMAN RESOURCE 261,828 113,754 43.4%
FINANCE 895,901 452,383 50.5%
CIVIL SERVICE 179,221 88,926 49.6%
DEVELOP SERVICE 4,147,522 1,978,659 47.7%
FIRE 22,611,198 11 ,567,597 51.2%
POLICE 40,527,327 19,850,587 49.0%
FACILITIES MGMT 1,709,002 848,193 49.6%
PARKS 3,081,566 1,520,451 49.3%
PUBLIC SERVICES 1,837,430 956,704 52.1%
TOTAL GEN FUND $79,171,719 $39,280,748 49.6%
~~!JP:G=r4=~.ti
.10"~'Q.M .. 2: ,.. . ~~t;>
673,800 330,256 49.0%
357,900 158,162 44.2%
930,100 456,720 49.1%
123,700 61,534 49.7%
1,701,400 856,187 50.3%
1,792,700 872,402 48.7%
2,830,000 49,637 1.8%
504,600 239,614 47.5%
317,000: . 154,680 48.8%
i
987,30Q '419,915 42.5%
,
179,900 90,873 50.5%
3,523,300 1,635,618 46.4%
24,533,500 12,289,541 50.1%
43,441,900 21,993,147 50.6%
1,837,000 813,008 44.3%
3,259,800 1,515,969 46.5%
2,594,800 1,416,214 54.6%
$89;588,700 $ 43,353,477,r ~"it4.8';~%