The URL can be used to link to this page

Home My WebLink About01- City Manager c c c - DOC ill: 1758 CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION Budget From: Charles McNeely MlCC Meeting Date: 04/03/2012 Prepared by: Rebecca Garcia, (909) 384-5122 Dept: City Manager Ward(s): All Subjeet: Mid-Year Budget Review for FY 2011-2012 Financial Imnact: None. Motion: Receive and file the FY 2011-2012 Mid-Year Report. Svnonsis of Previous Council Action: June 29, 2011 Resolution 2011-212 approved the FY 2011-2012 City of San Bernardino final budget. SunnortiDl! Documents: Mid Year Report.RCA (PDF) Mid Year Report.Staff Report(PDF) MillYEARRET (PDF) BUDREVEXP (GF ESTIMATED REVENUES EXPENDITURES) (PDF) BUDGFREV (GENERAL FUND REVENUE REPORT) FY 2012 FINAL(PDF) BUDSRF (Other Funds Revenue Report) M FY 2012 (PDF) BUDTRANSI (TRANSFERS IN) (PDF) BUDTRANSO (TRANSFERS OUT) (PDF) Updated: 3/29/2012 by Linda Sutberland Pagel c c /.",.- \..... CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION - From: Jason Simpson Director of Finance Subject: Mid-Year Budget Review for FY 2011-2012 Dept: Finance Date: March 28, 2012 Council Date: April 3, 20121 Synopsis of Previous Council Action: June 29, 2011 Resolution 2011-212 approved the FY 2011-2012 City of San Bernardino final budget. Recommended motion: That the FY 2011-2012 Mid-Year Report be received and filed. Signature Contact person: Jason Simpson, Director of Finance Phone: 5242 Supporting data attached: Staff Report, Attachments Ward: All FUNDING REQUIREMENTS: Amount: Source: Finance: Council Notes: Agenda Item: No.: N ~ Cl N . ~ ~ Cl N ~ ~ .e iI .. '> ~ - .. <II ." " lD ~ .. ~ :!! ::!! 00 on .. :::. <I: o 0:: t: 8- ~ ~ .. .. > :!! ::!! '" c .. E "" " .. ~ c c c CITY OF SAN BERNARDINO -REQUEST FOR COUNCIL ACTION STAFF REPORT INTRODUCTION Attached is the FY 2011-12 Mid-Year Budget Report. This report is designed to keep the Mayor and Council informed of the financial position of the City. This report provides information regarding estimated fund balances available for next fiscal year's budget preparation. On June 29, 2011, the City adopted its final budget for FY 2011-12. The adopted budget was the second year of a two year budget. On Augnst 23,2010, the Council adopted the City Manager's modified budget strategies which included 8% budget reductions from all Departments. These budget reductions were accomplished in two tiers and were necessary to help balance both the FY 2010-2011 as well as the FY 2011-2012 budget. Finance, working with each Department, implemented the adopted budget reductions, and the budget reduction were included in the fmal FY 2011-2012 adopted budget. In January, the Finance Department, as well as each individual department, began the annual Mid- Year budget review process to evaluate in detail the revenues and expenditures for the first half of the fiscal year to determine if actuals were on target after the full 8% budget reductions were implemented. The attached schedules of the Mid-Year Report provide the updated projections for the General Fund for all other operating funds in the City. Each schedule of the Mid-Year Report includes a page number for easy reference and identification. The Summary of Revenues, Expenditures, and Transfers (page 6) provides a summary overview of all the major funds in the City. The first column of numbers provides the beginning budget fund balances for each fund. The last column of numbers on the report indicates the estimated balances for each fund at 6/30/12. Most funds appear to be on target with what was estimated in the FY 2011-12 budget. The General Fund, however, is projected to have a $3.8 million shortfall. THE GENERAL FUND The "Estimated Revenues and Expenditures - General Fund" report (page 7) provides an overview of the General Fund. The first column provides the updated adopted budget for the General Fund for FY 2011-12. The FY 2011-12 budget has been updated to reflect the approved continuing appropriations/encumbrance carryovers as well as any other Council approved budget amendments. The second column provides the current updated estimates for all the General Fund revenues and expenditures. The third and final column provides the variance between what was budgeted and what is now estimated. In summary, the General Fund revenues and transfers in are estimated to be about $342,300 more than the budget estimates. Total General Fund deductions are anticipated to be about $4,147,600 more than the budget estimates. These two items combine for a total estimated net shortfall of $3,805,300. This net shortfall assumes the General Fund budget reserve is maintained at the current $622,300. In addition to this net shortfall of $3,805,300 the General Fund has outstanding loan liabilities in the estimated amount of $3.6 million to EDA and the I - N ~ <> ~ ~ ~ <> N ~ ~ ,g II " t II: - " '" ... " ID ~ .. ~ ... :iii III .... ~ 1:: o a. " II: E Ul ,: o a. " II: ~ .. " >- ... i '" c " E .<; u ll! <( c c /' \. Regional Circulation Development Impact Fee Fund (DIFF), which on the City's financial statement balance sheet will reflect a net negative $3 million. General Fund Revenues The "Estimated Revenues and Expenditures - General Fund" report provides a summary of the General Fund revenue estimates by category. The "General Fund Mid-Year Revenue Report" (pages 8- 10) provides line item detail for projected General Fund revenues. In total, estimated General Fund revenues are projected to be $530,400 more than what was budgeted. Discussed below are some of the major highlights regarding General Fund revenues: Property Tax revenues are estimated to be a net $645,200 less than the budget. The major reason for this shortfall is from the Prop Tax In Lieu ofVLF. Since this revenue is calculated by the State based on the City's assessed valuation and the City again had a decline last fiscal year in its assessed valuation this revenue was reduced for FY 2011-12. Current secured and Supplemental Property Taxes were also slightly less than anticipated. Sales Tax revenues for FY 2011-12 are anticipated to be about $1.2 million higher than what was anticipated in the budget. The City, like most areas in the State, continues to see growth again in its Sales Tax and Property Tax In Lieu of Sales Tax revenues. Utility User Tax revenue is projected to come in at budget. If weather temperatures are more or less aggressive during the second half of the year than this projected revenue estimate could change. Measure Z-District Tax revenues are estimated to be higher than the original budget projections. Approximately $577,800 more will be collected in FY 2011-12 fora total of$6,227,800. In FY 2007-08 the City actually received $6,511,475 in revenue from Measure Z which was about $300,000 more than what is being received in FY 2011-12. Transient Occupancy and Business Registration net revenues are also anticipated to be slightly more than originally estimated in the budget. Transient Occupancy revenues are estimated to be $100,000 less than the budget and Business Registration is estimated to be $200,000 higher for a net gain of$IOO,OOO to the General Fund. Licenses and Permits revenue, highly dependent on building activity, is showing some growth and is coming in about $546,000 above budget (not including business registration). Overall, the category (not including business registration) is expected to collect $2,378,900, which is approximately $600,000 more than last fiscal year. Fines and Penalties revenue is estimated to bring in about $499,700 less than the budget amount. This decrease in revenue is mainly due to the Administrative Civil Penalties, Administration Citations and Parking Citation revenues being less than anticipated. Money & Property as well as Intergovernmental Revenues are estimated to be slightly less than budget estimates by a total of $385,500. Motor Vehicle in Lieu and Interest Earning revenues account for the majority of the decreased revenues. 2 - N - o N , - - o N >- II. ~ .e ~ .. ): .. 0:: - .. '" " " III ~ .. ~ :5! :IE co "' .... ~ 1:: o c. ~ II: J! Ul t: 8- .. 0:: ~ .. ~ :5! :IE ., c .. E .c u ~ ,"0 Charges for Service revenue are expected to be slightly higher than budget projections by $77,100. The majority of the revenues in this category are anticipated to be about what was anticipated in the budget. The Miscellaneous revenue category is projected to collect about $472,300 less than the original budget. The majority of this revenue shortfall is due to less revenue in the Misc. Other Revenue account than what was anticipated in the budget. There are not anyone time revenue collections that are anticipated in FY 11-12 that were received in prior fiscal years. General Fund Exuenditures The "Estimated Revenues and Expenditures - General Fund" report also provides a list by department of estimated General Fund expenditures. General Fund expenditures (including transfers out) are projected to be approximately $132,833,900. General Fund departmental budgets and transfers-out combine for a shortfall of $2,847,600. This shortfall added to the projected savings goal of$I,300,000 that was already factored into the budget combines for a net estimated deduction shortfall of $3,805,300 for FY 2011 -12. Generally speaking, most departments are projected to have a budget savings. There are three Departments that are anticipated to be over budget. These three Departments include the City Clerk Department, Fire Department, and the Police Department. On March 5, 2012, the Mayor and Common Council approved a budget adjustment of $939,100 for the City Attorney's Office for the costs associated with outside litigation. The City Attorney's Office would have been over budget had the Council not approved the request for additional funding. The City Clerk Department is projected to be over budget by $233,800. There are two main reasons for this overage. First, at the December 5, 2011, Council meeting the City Clerk's office presented a request for an additional $200,000, which was needed for the February run-off election that was not anticipated at the time the budget was adopted. At the December 5 meeting, the City Clerk proposed attempting to utilize savings in the Department to off-set the costs and address the issue at the mid-year. Since no action was taken at the December 5 meeting to amend the City Clerk's budget for these additional costs, there remains an anticipated budget shortfall of $200,000 for this item. Second, the remaining net budget shortfall is the result of payoffs to employees who resigned/retired during FY 2011-12. The Fire Department is projected to be over budget by $2,872,600. The majority of this shortfall is due to the Fire Safety Union not having a 10% pay reduction that was anticipated and included in the FY 2011-12 adopted budget. The remaining net budget shortfall of approximately $1.1 million includes $775,000 in employee payoffs due to resignations/retirements and the remainder is related to overtime costs. Due to the constant staffing provision in the Fire Safety Memorandum of Understanding (MOU) most vacant positions have to be filled with overtime which costs additional money. The Police Department is the last Department projected to be over budget and the shortfall is estimated at $913,400. This net budget shortfall is the result of employee payoffs due to resignations/retirements in the amount of $1,135,509. As is the case with other City 3 - N - o N . - - o N it ~ .l! ;C .. 'S: .. a: 1; '" ." ::l III ~ .. ~ :!! :I! 0) on .. - - t: o 0. &! It: .. - Ul ~ o 0. .. a: ~ .. .. > :!! :I! '" c .. E .s:; " .. ~ $'"~ ~""d;fi departments, with fewer positions, there are less vacant positions to generate enough savings to cover the additional overtime costs that are needed and cover the employee payoffs. OTHER FUNDS The Special Revenue Funds Revenue Report (pages 11-16) provides a three-year history and updated revenue projections for funds other than the General Fund (Special Revenue Funds, Internal Service Funds, and Enterprise Funds). Estimated expenditures for these funds can be found summarized on the Summary of Revenues, Expenditures, and Transfers Report (page 6). Special Revenue Funds - For most of the Special Revenue Funds the estimated ending fund balance at June 30, 2012, is in line with what was anticipated in the adopted budget. The Asset Forfeiture Fund is anticipated to end the year with a positive balance of $556,862 which is about $380,000 more than what was anticipated in the budget. The Refuse Fund is anticipated to end the year with about a $1.2 million shortfall. This shortfall is the result of not enough increased business and no additional rate adjustments being done this fiscal year to cover anticipated expenses. This overage will need to be addressed because the City's General Fund cannot cover this shortfall. Capital Project Funds - For most Capital Project Funds, it is assumed that any budgeted projects not completed in FY 2011-12 will be carried over into the new fiscal year; therefore no savings in expenditures is anticipated. Although projects may have been budgeted in full, in reality, the completion usually spans multiple fiscal years. Internal Service Funds - Three of the Internal Service Funds (ISF) are projected to the end FY 2011-12 in worse financial shape than originally anticipated in the FY 2011-12 budget. The three ISF are the Liability Fund, Fleet Services Fund, and Workers Compensation Fund. Below is a brief discussion on each of these funds. The Liability Fund was originally anticipated to end FY 2011-12 with a negative $422,600. Based on current case activity it is now anticipated this fund will end FY 2011-12 with over a $3.3 million negative ending fund balance. This ending fund balance includes current estimated expenditures as well as estimated future judgments and claims payable. The Fleet Services Fund has a $240,000 lower beginning fund balance than originally anticipated and it is projected to be about $500,000 over budget for FY 2011-12. Higher gas prices and higher maintenance costs on old vehicles primarily contribute to the overage. This overage needs to be addressed by either reducing expenditures or having user Departments pay more for Fleet costs. The Workers Compensation Fund is projected to end FY 2011-12 with about a $1 million increased negative fund balance than what was originally anticipated. Because of GASB accounting rules, the City is required to show all of the City's unfunded liability for potential claims and judgments (in essence what the amounts would be if every potential claim and judgment had to be paid at one time). Therefore, as presented in the Adopted Budget, there is a significant deficit balance. The City, over the course of the last several years, has worked to try 4 - N ~ <> "i ~ ~ <> .. >- IL ~ .e ~ .. ;;: .. II: - .. '" " " III ~ .. .. >;- :!! :!! '" on .... ~ - t:: o c. .. II: it: .. - f/l t: o c. .. II: ~ .. .. >- :!! :!! ;; s:: .. E .s:: u .. l:< <l ...... I to reduce the deficit balances by ensuring that the charges to departments are appropriate and reducing costs when possible. However, there has been an increase in Workers Compensation costs related to injury and illness, and the City's budget charges have not been able to keep pace. CONCLUSION The FY 2011-12 Mid-Year Budget Report is one of the first steps in beginning the FY 2012-13 budget preparation process. Tbe estimates developed during the FY 2011-12 mid-year process provide the foundation for estimating the City's available fund balances for FY 2012-13. A major concern that needs to be noted is that the City's General Fund continues to be in an increasing weakening condition and immediate changes need to be made to reverse this financial condition, build the General Fund Reserve, and stabilize this fund. If these efforts are not made, insolvency or bankruptcy may result. Tbe Council has an opportunity to resolve the issue and change the City's course. If not, control may be taken out ofthe Council's hands. RECOMMENDATION That the FY 2011-12 Mid-Year Budget Report be received and filed. 5 lilt.,.:: 1 N ~ o "i ~ ~ o .. > ... ~ .2 ~ " :;; " '" - .. '" " ::l In ~ .. .. >; :!! :;; CD "' ... ~ - 1: o 0. .. '" ll:: .. - "! 1: &. .. '" ~ .. " > :!! :;; ., l:: .. E '" l) ~ <( ~..111 ".... CITY OF SAN BERNARDINO SUMMARY OF REVENUES, EXPENDITURES, AND TRANSFERS MID YEAR FISCAL YEAR 2011 - 2012 - 2,044,100 1114,495,700 113,111,100 1129,650,900 1130,065,600 1 2,748,300 1132,633,900 I (3,163,000) 105 LIBRARY 33100 72200 2100000 2 205 300 2 205 300 2 205 300 0 106 CEMETERY 44 328 157900 0 202 228 145600 145 600 56 628 108 ASSET FORFEITURE 597 462 418000 1015462 458 600 458 600 556 862 118 DRUG/GANG FUND 80229 50600 130 829 20 000 20 000 110829 111 AIR QUAlITY-AB 2766 100 025 251 900 351 925 257 500 70 000 327 500 24 425 119 Commun Block Grant 0 3 583 000 3 583 000 3 583 000 3 583 000 0 124 ANiMAl CONTROL 118200 1 476 000 383 300 1 977 500 1 977 500 1 977 500 0 128 TRAFFIC SAFETY 204211 1 752 200 1547989 552 200 1 200 000 1 752 200 204,211 132 SEWER LINE MAINT 2 008 594 3218000 5 228 594 3715700 1510900 5226 600 6 133 BASEBALL STADIUM 0 57 372 57 372 - 57 372 0 N 134 SOCCER COMPLEX 305 975 409 500 715 475 453 100 453100 262 375 ~ 0 775 PERPETUAL CARE FUND 340000 340 000 134 400 134 400 205 600 ~ ~ 137 CFD 1033-Fire Station M&O 221 585 900 585 679 585600 585 600 79 ~ 211 FIRE EQUIP ACQUISITION FD 113900 113900 80 000 33,900 0 N 208 VERDEMONTINFRASTRUCT 257917 257 917 257 900 17 ~ 527 REFUSE 406,09 24,823,803 28 014,800 1,190,997 ~ 2 II " ! . CD ... " SPECiAl GAS TAX 611608 5489 300 6100908 2 242 900 3 620 000 5 862 900 238 008 Ol 112 CENT SALES & RD TAX 2 699 885 2 405 000 5104865 3 754 800 1 350 000 5104800 65 ~ : ',AB2928 TRAFFIC CONGST 6420 0 0 6420 0 0 6420 >; INFRASTRUCTURE BK LOAN 9078 9078 0 9078 :!! 241 PUBLIC PARK EXTENSION 4500 4500 0 4500 ::!! 242 STREET CONSTRUCTION 3 661 864 26425 300 22 763 436 22 824 700 22 624 700 61264 .. 243 PARK CONSTRUCTION 667662 1 457 800 2125462 2 049 600 2 049 600 75 862 :g 244 CEMETERY CONSTR 52 339 600 52 939 5000 5000 47,939 .... 245 SEWER LINE CONSTR 3 589 720 115000 3,704 720 3479700 225 000 3 704 700 20 ~ 246 PUBLIC IMPROVEMENT 1 134 022 1000 1 135022 881 000 881 000 254 022 .... W 247 CULTURAL DEVELOPMENT 397 730 201 000 598 730 357 000 357 000 241730 It: 248 STORM DRAIN CONSTR 3 245 733 178,000 3 423 733 132700 3 369 800 54133 It: cC 258 PROP 1 B FUND 2,816,246 2,816,246 2,294 800 521,446 W >- c i LAW ENFORCEMENT IMP 132820 52 300 185120 148 700 148 700 36 420 ~ FIRE PROTECTION IMPACT 333 536 25 700 359 236 160 300 160 300 198936 " LOCAL CIRCULATION SYST 521 863 24 000 545863 514400 514400 31463 E .c: REGIONAL CIRCULATION SY 5745141 521 000 6266 141 6 200 500 6 200 500 65,641 u .. LIBRARY FACILITIES IMPACT 16096 25100 41196 41000 41000 196 ~ PUBLIC MEETINGS FAC IMP 396 345 10500 406 845 0 406 845 AQUATICS CENTER FAC IMP 114629 7200 121829 0 121,829 AB1600 PARKLAND IMPACT 1 712935 52 000 1 764 935 1 179 200 585 735 QUIMBY ACT PARKLAND IMP 242,770 5,300 248,070 47,800 200,270 53152 165 400 112248 130 200 130 200 17 952 1 147028 3153900 2 006 872 5006100 338 100 5,344 200 3 337 328 94 300 1 289 700 1,384 000 1 301 900 1 301 900 82,100 82812 3714900 3 632 088 3882100 3882100 250012 160 480 7 625 000 7 785480 8145000 8,145000 359 520 10202606 3 844 300 6 358 306 4415900 4415900 10774206 178,608 4,448,300 4,626,908 4,417,200 4,417,200 209,708 "GF owes about $3.6m in loans which the liability on the balance sheet makes the undesignated fund balance an estimated negativ -Beginning fund balance and expenditures include the approved carryover funds from FY 10-11. - CITY OF SAN BERNARDINO GENERAL FUND MID-YEAR REVENUE REPORT FISCAL YEAR 2011-2012 ~ N ~ 0 ~ 4001 urrent ecured 11,621,490 774967 9,4 7 9,700,00 9,500,000 20 ,000 ~ ~ 4002 Current Unsecured 603,367 573,633 592,374 600,000 580 000 20,000 0 N 4003 Prior Taxes 904,956 943,324 5885n 600,000 550,000 50,000 >- 4005 OtI1er 167060 158 997 160,808 175000 165,000 10,000 LL ~ 4006 Su lemental 903,455 347167 175,520 300,000 200,000 100,000 .e 4007 P Tx In Ueu ofVLF 18,588,204 17,017,692 18,017,079 18,000,000 15,734,800 (265,200 ~ ): ~ t> 4201/14 Franchise Tax 3,091,966 2,688,512 2800,783 2,880,700 2,880,700 0 '" ." 4215 Tow Franchise 421,542 437461 384 047 495,600 495,600 0 ::l III 4220 Prop Tx In Lieu Sales Tax 6,520,295 4,266,819 5,654,406 6,191,100 8,278,200 87,100 ~ .. 4221 Sales Tax 17,276,647 16,145282 17,958,068 18,366,400 19,581,300 1,194,900 ~ 4222 Transient Occu an 2,517,102 2,222,113 2,507,283 2,600,000 2,500,000 100,000 :!! 4223 Pro . Transfer Tax 390,814 393 821 531,343 500,000 500,000 0 ::I! 4224 Util" User Tax 24,355,172 22,630,460 22,089,888 22 500,000 22,500,000 0 4225 Sales Tax Public Safe 663,890 761,482 790 344 900,000 850,000 50,000 ., on .. 4227 Measure Z - District Tax 5,804,472 5,157,200 5,766,495 5,650,000 8,227,800 577,800 ~ -' <( z ii: 4301 Business R istration 6,197,871 5,641,347 5,996 091 6,000,000 6,200,000 200,000 N 4303 Mise Ci Clerk Permits 2,383 4,477 4,119 4,000 4,000 0 ~ 0 4304 Mise Plannin Permits 22,715 18,054 30,248 22,000 27,000 5.000 N t 4330 Buildin Permits 498,626 545 164 489,493 500,000 500,000 0 4331 Mechanical Permits 144,792 161319 157,881 160,000 160,000 0 ~ 4333 Mobile Home Park Permil 26,169 51,424 49 837 51400 51.400 0 0 4336 Fire Code Permits 385,377 357,942 365,779 360,000 360,000 0 11. w 4337 Fire Plan Check 141,512 99,671 103,753 100,000 100,000 0 a: 4342 EMS Membershi 2,172 30,319 9,555 20,000 11,000 9,000 w ::> 4351 Street Cut Permits 295,086 418,071 183,369 150,000 400,000 250,000 z w 4352 Mise Licenses & Permits 500,325 462,902 213,246 300,000 450,000 150,000 ~ 4353 Yard Sales Permit Fee 0 0 0 0 0 0 a: 4360 Gradin Permits 9,628 7,201 6,647 5,000 2,000 3,000 <:I 4361 Construction Permits 122,992 56 222 41,620 25,000 70,500 45,500 z ::> 4362 On Sile Ins ction Fees 623.489 104 328 151,825 100,300 200,000 99,700 LL 4363 On Site Plan Check 209,377 25,780 106,559 35,000 43,000 8,000 -' ~ w z w Cl 4401 Unauthorized Si n Fine 0 0 0 10,000 1,000 9,000 - > 4410 General Fines 135,876 245,664 102,896 200,000 200,000 0 w 4411 Code Admin. Cilations 182,982 582,836 259.499 550,000 260,000 290,000 a: LL 4412 Fire Admin. Citations 96,767 64,976 73,570 60,000 60,000 0 Cl <:I 4420 Parkin Cilations 1,145,492 1,152,652 936,594 1,150,000 1,050,000 100,000 ::> 4422 Fieworks Adm Civil Pena 15,n9 7,223 8,114 10,000 10,000 0 III ... 4423 General Admin Civil Pena 609,714 1,087,553 551,940 100,000 400,000 300,000 c " 4424 Police Admin Civil Pena 26,386 51764 73,459 100,000 50,000 50,000 E 4426 Buildin Admin Civil Penal 5500 13,000 7,940 3,000 3,000 0 .s:; u 4427 Fire Admin Civil Penal 26,215 36,657 80,094 100,000 35,000 65,000 ! 4428 Code Admin Civil Pena 5,400 136,787 189,320 600,000 312,800 287,200 29 Genral Admin Cities 0 0 0 1,000 2,500 1,500 4505 Interest Eamin s 198,928 110208 20,754 200,000 20,000 180,000 4520 Land & Buildin Rental 487,584 602,361 526 604 530,000 530 000 0 4523 A TS Land Rental 10805 47,394 76 377 77,000 77,000 0 4530 Parkin Rental Fee 550 300 660 0 0 0 4540 Vendin Machine Comm. 38,669 29,175 26634 30,000 31,000 1,000 4922/4925 Sale of Pro 5,120 1,964,718 2,546,549 0 0 0 4603 Motor Vehicle In Lieu 817737 711559 946 143 324,400 0 324,400 4606 Homeowner's Exem tion 134,091 141765 122189 130,000 130000 0 4615 Disaster Pre . Pr ram 22,497 27,783 0 38,700 41,600 2,900 4616 POST 100,877 96 838 70,154 50,000 70,000 20,000 4619 Mutual AidJDisaster Reimb. 795,269 506,326 828,155 600,000 600,000 0 4621 Bookin Fee Subvention 0 0 0 0 0 0 4625 State-Mandated Costs 86,703 255,962 256,505 200,000 300,000 100,000 4651 Construction Reimb. 22,012 0 0 0 0 0 4670 EDA & CDBG Reimb. 5,318.450 3 935 920 3,446,951 1,287,500 1 267,500 0 4671 SBIAA Reimbursement 153,530 159,630 162790 150,000 145,000 5.000 4673 Water Reimbursement 349,600 356,600 775,059 527,700 527,700 0 CITY OF SAN BERNARDINO GENERAL FUND MID-YEAR REVENUE REPORT FISCAL YEAR 2011-2012 ~ 202,957 200,394 178,918 - 4701 Election Fiiinn Fee 1,084 14,874 976 4702 Countv Contract 487,000 487 000 487,000 4705 Utilitv Collection Fee 0 0 0 4707 Passoort Fees 67,458 72,032 61972 4708 Fire Trainina Aareement 107,147 69,380 76,428 4709 Hazardous Material Fee 42,463 5,992 4,990 4710 Mise PlanninolBuildino 111,707 105,528 79,151 4711 PW Subdivision File Fee 28,548 18,629 28,488 4714 Plannino Develn Proiect 301,612 184,841 182 460 4715 CD Technolonv Fee 43,855 50,343 38,523 4718 Environmental 719 0 3,000 4720 Plan Review Fee 73,462 59,306 75,047 4731 Plan Check Fee 230,880 172,672 203,181 4733/4734 Proo/Buildinn Abate 765,997 726,641 1,301,753 4735 Release Notice of Pende"'" 7,316 18,502 12344 4743 PO Towina Release Fee 543,470 366,285 383,351 4745 Code Tow Release Fee 960 5,261 2,970 4747 False Alarm Fee 55,806 50,944 67,231 4748 Vehicle Reoossession Fee 0 0 6,370 4752 Fireworks Reoulatorv Fee 67,233 65,756 69,838 4753 Fire Archival Fee 2,908 1,621 1,414 4754 Fire Business Occun InsD 39,110 38,100 46,961 4755 Fire RentallnsD8Cl:ions 540,541 578,649 551,948 4766 Buildina Permit Review 71,430 63,681 34,240 4767 Sinnle Familv Rentallnso 310,809 499,594 596,669 4768 Adm Cites-SFRIP 0 149,182 104,429 l. 4770 Crime-free Ranta Housina 0 0 0 4779 Blanket Insoaction Fee 0 1,168 32,904 4780 Mise Deveioo Servs Chrc s 96,408 41,896 57,935 4782/4784 Plan Subdivision Fees (19,356 327 24,924 - N - C> ~ - - C> N ~ ~ .2 ~ ! 1i '" " ::l ID ~ .. ~ " i CD '" ... - - 260,000 220,000 140,000 20,000 20,000 0 487 000 487,000 0 0 0 0 60,000 60,000 0 104,000 85,000 (19,000 1,000 43,000 42,000 60,000 51,000 (9,000 20,000 30,000 10,000 200,000 220 000 20,000 40,000 58,000 18,000 0 0 0 60,000 70,000 10,000 200,000 200,000 0 750,000 750,000 0 15,000 12,000 (3,000 518,900 518,900 0 5,000 1,400 (3,600 100,000 100,000 0 0 0 0 67,000 62,800 14,200 2,000 1,500 500 40,000 44,000 4,000 550,000 550,000 0 50,000 52,000 2,000 600,000 735,000 135,000 120,000 98,000 122,000 104,100 56,000 148,100 34,100 34,100 0 50,000 40,000 (10,000 10,000 1,000 (9,000 ... cC z ii: N - C> N ~ ;=- II: o II. W II: w :::J Z W ~ II: C Z :::J IL ... ~ w z w !:!.. > W II: IL Cl C :::J ID .., c .. E .c u .. ~ - CITY OF SAN BERNARDINO GENERAL FUND MID.YEAR REVENUE REPORT FISCAL YEAR 2011-2012 ~ ... 4785 Non Subdivision Str 1m 174.480 27,682 34 402 30 000 30,000 0 ~ 0 4786 Certificate of Com letion 14,656 4,031 7,038 5,000 2,000 3,000 "I ~ 4789 Archival Fee - Devel Servs 24 976 22 353 18938 22,000 22,000 0 ~ 0 4795 Si nal MaintlEne 33,089 20,104 19,768 20,000 0 20,000 ... 4798 Storm Drain Utir Fee 271,148 237 698 227 261 250 000 237 000 13,000 t 4799 NPDES Bus Ins etian 0 7,001 22 482 15,000 28,000 13,000 ~ .2 4802 Str Li ht Ener Fee 16,800 2,938 178 0 0 0 ~ 4810 Misc. Develo ment SelVi 6,936 3,373 3,373 5.000 5.000 0 4815 Weed Abatement 150,733 174,268 168,804 175,000 202,200 27,200 ~ 4861 P rmIFacili Use Fee 67,233 49,159 107,869 70,000 85,000 15,000 a: - 4862 Park Ene Fee 5,095 6742 5420 6.000 6,000 0 .. '" 4863 Class Re istration Fee 6,865 6,158 12,680 8,000 8,500 500 "D " 4864 Swimmin Pool Fee 51.483 68,784 58,332 50,000 70,000 20,000 CD ~ 4865 Non-Resident Fees 2,767 1,502 1,610 1,000 1,000 0 .. 4880 EMS User Fee 260 086 449 482 383.837 400,000 400,000 0 ~ 4881 Paramedic Reimb Contract 410,445 385,005 343,072 355,200 320,000 35,200 "D i III ... ~ 4740-5 Police Misc. Recei ts 882574 1,005 530 1188636 900,000 1,100,000 200,000 - 4741 Sale of Photos IRe rts 15,187 8,132 9,843 15,000 12,000 3,000 ... <( 4742 Pistol Ran e Fees 0 26,895 108,205 50,000 100,000 50,000 z 4746 Pro Auction 3,886 12,186 5,434 7,000 5,000 2,000 iL ... 4750 Investi alian Fee 43,010 35,238 34,227 45,000 45,000 0 ~ 0 4901 Misc. Other Revenue 441 035 2.468743 659 036 895 300 200,000 695,300 ... 4904 Drunk Driver Reimburmt. 0 0 0 0 0 0 t 4905 Litigation Settlement 135,681 1,317 10,341 0 0 0 ~ 4906 Water Fund Contr. 2,397,359 2,354,414 2,637,060 2,672,300 2,672,300 0 0 4910 Admin Service Cha e 384,800 375,300 367,600 367,600 367,600 0 l1. 4911 Restitutions 11,468 15,542 19,017 20,000 20,000 0 w a: 4912 Off Track Bellin 110,107 91986 78,547 100,000 90,000 10,000 w 4924 Damage Clain Recovery 80,617 109,568 80,711 80,000 80,000 0 :;) z 4926 CID Reimburmt 0 125 438 100000 0 0 0 w > 4928 Bookin Fee Reimburmt. 3,274 2,112 2,017 2,000 2,000 0 w 4930 Sewer Contr. - Waler 500,000 500,000 500,000 500,000 500,000 0 a: Q 4931 Water Land Sales 52,782 0 0 0 0 0 z 4933 Hazmat Incident Recove 0 1,748 18,114 20,000 8,000 12,000 :;) II. 4937 Street Knockdown 0 0 17,785 10,000 10,000 0 ... ~ w z w !:!. ~ a: II. Cl Q :;) CD .;.: c .. E .c u .. C ~ CITY OF SAN BERNARDINO OTHER FUNDS MID-YEAR REVENUE REPORT FISCAL YEAR 2011 - 2012 11 30,000 5,000 o o 4505 Interest on Idle Cash 9,536 1,694 10,000 5,000 5,000 4775 Cemete Burial Fee 22,715 13,727 10,000 11,500 1,500 4776 Sale of Vases 430 500 500 500 0 4777 Sale Concrete Boxes 10,066 5237 5,000 4,500 500 4778 Sale Camete Plots 4,687 2,574 2,000 2,000 0 4901/4938 Mise Recei UPe 0 318,700 134,400 134,400 0 4320 Animal License 349477 273,151 273,973 300,000 270,000 30,000 4352 Misc. License & Permits 1,175 1,025 825 500 500 0 4410 General Fines 26,595 15,460 27,638 25,000 25,000 0 4430 Animal License Penalt 37,150 20,700 27,620 25,000 25,000 0 4756 Animal Ado tion Fee 47,233 39,190 39,712 35,000 40,000 5,000 4757 Contractee Shelter Fee 779,644 750,890 907,720 1,014,800 1,014,800 0 4759 A rehension Fee 32,466 15,900 2,056 20,000 20,000 0 4760 Board Fee 14,723 16,154 37 20,000 20,000 0 4761 Field Service Fee 15 65 115 200 200 0 4763 Owner Release Fee 24,718 17,748 20,439 25,000 25,000 0 4764 Vaccination Fee 16437 14,683 13140 14,000 10,000 4,000 4765 Microchi Fee 78,654 24,315 22 060 23,000 25,000 2,000 01 Miscellaneous Recel ts 124 656 457 500 500 0 22 Sale of Equipment 0 0 0 0 0 0 CITY OF SAN BERNARDINO OTHER FUNDS MID.YEAR REVENUE REPORT FISCAL YEAR 2011 .2012 12 4505 Interest on Idle Cash 26,510 4,571 46 5,000 1,000 4,000 4602 HUTA Pro 2 Re laeement 0 0 1,964,191 2,276,900 2,276,900 0 4607 HUTA R&T 7360 0 0 0 0 0 0 4610 Slate Aid-2106 678,076 695,310 658,354 676,000 676,000 0 4611 State Aid-2107 1,467,881 1,493,358 1,429,002 1,441,900 1,441,900 0 4612 State Aid-2107.5 10,000 10,000 0 10,000 10,000 0 4614 Pro 111-Hi hwa Users Tax 1,102,887 1,120,482 1,062,330 1 ,083,SOO 1,083,500 0 4945 Reimbursement 0 0 0 0 0 0 62,098 2,570,323 o o 33,285 2,259,537 o o 11,572 2,313,044 o o 35,000 2,500,000 o o 5,000 2,400,000 o o 30,000 100,000 o o 71,086 3,059,926 o 54,069 3,122,218 o S06 3,164,303 o 25,000 4,175,000 o 18,000 3,200,000 o 7,000 975,000 o 4505 Interest on Idle Cash 5,033 4,110 1,475 5,000 5,000 0 4520 Land & Buildin Rental 111,677 154,392 136,185 120,000 130,000 10,000 4528 S onsorshi 5 0 0 6,324 0 0 0 4530 Rental Fee - Parkin 211,236 206,611 178,392 200,000 180,000 20,000 4861 Pro ram & Facilities Fee 85,555 77,560 77,251 80,000 80,000 0 4862 Park Ener Fee 3,978 5,254 4,360 4,000 4,000 0 4901 Mise Other Revenue 0 0 10,270 4,000 10,500 6,500 9,647 1,736,686 o 16,421 1,849,954 o CITY OF SAN BERNAROINO OTHER FUNOS MIO.YEAR REVENUE REPORT FISCAL YEAR 2011 .2012 13 . ------ 4505 Interest on Idle Cash 4512 Verdemant Infrastruction Fee 4630 State Aid-Street Constr, 0 0 2,017,403 0 0 0 4658 Federal Aid-FAU 1 ,888,984 22 458 6,388,515 17,377,100 17,377,100 0 4670 EDA Reimbursement 0 204,642 0 202,700 202,700 0 4671 IVDA Reimbursement 0 0 0 660,000 660,000 0 4677 Local Stimulus SAN BAG 0 0 0 2,898,700 2,898,700 0 4901 Mise Recei tsIRefunds/Rebates 0 0 250,000 1,702,400 1,702,400 0 4945 Construction Reimbursement/Mise 149,316 821,685 473,066 3,584,400 3,584,400 0 4505 Interest on Idle Cash 1,607 12,826 3543 5,000 1,000 4,000 4620 State Aid Park Dev 610,016 0 723,773 1,120,800 1,120,600 0 4651 Construction Reimbursement 0 0 0 0 336,000 336,000 4670 EDA Reimbursement 0 0 0 0 0 0 4732 Park Development Fee 0 0 1,292 0 0 0 14,722 o 4505 Interest on Idle Cash 4630 State Aid Street Construction 2,797 o o o o o o o o o o o CITY OF SAN BERNARDINO OTHER FUNDS MID-YEAR REVENUE REPORT FISCAL YEAR 2011 - 2012 14 78,846 1 ,903,800 o 2,191 44,684 o 5,000 50,000 o 700 25,000 o 4,300 25,000 o 152,266 691,916 106,458 303,296 31,435 165,050 29,000 10,000 o CITY OF SAN BERNARDINO OTHER FUNDS MID-YEAR REVENUE REPORT FISCAL YEAR 2011 - 2012 15 4423 General Admin Civil 0 4505 Interest on Idle Cash 19,127 25,350 0 2,100 300 1,800 4830 Commercial Rubbish 64,822 49,395 3,003 3,600 0 3,600 4831 Commercial Bin Rent 25,599 601 697 800 400 400 4832 Commercial Bin Service 10,140,807 10,561,275 4,839,911 5,079,600 3,750,000 1,329,600 4833 Commercial S eciat 1,129,203 1 ,178,787 998,534 1,214,700 126,000 1,088,700 4837 Automated Commercial Rubbish 0 0 4,536,256 4,220,200 4,565,900 345,700 4840 Residential Water Billed 9,418,919 10,155,752 11,665,108 13,542,900 13,712,200 169,300 4841 Residential "B" Accounts 1,324,896 1 ,328,661 213,805 0 400 400 4843 Dino Bin Service 2,830,053 2,509371 2,130,203 1,956,400 2,500,000 543,600 4844 Commercial Penalties 19,274 34,659 3,147 3,800 0 3,800 4845 Residential Penalties 1,849 2,112 321 400 0 400 4846 Ree clin Recei ts 224,240 253,680 138,495 160,700 160,700 0 4901 Miscellaneous Other Revenue 689,985 442,168 646,520 607,700 351,000 256,700 4922 Sale Salva e Mater 86,253 130,408 3,569 0 0 0 4936 Collections Proceed 0 0 0 0 0 0 11,261 7,120,565 89,914 o 3,406,571 323,496 o 3,494,300 350,000 o 3,494,300 350,000 o CITY OF SAN BERNARDINO OTHER FUNDS MID-YEAR REVENUE REPORT FISCAL YEAR 2011 - 2012 16 . ------ 4670 EDA Reimbursement 4673 Water Reimbursement 4897 lnterde artmental Racei ts 4901 MisclSBETAlSANCAT/IVDA o 710,700 3,444,400 366,328 o 539,600 3,147,900 6,181 35,584 557,850 3,953,800 9,950 51,400 461,900 3,934,000 1,000 51,400 461,900 3,934,000 1,000 o o o o c c CITY OF SAN BERNARDINO - DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2011-2012 C TRANSFERS - IN MID - YEAR VARIANCE FY 2011-12 ESTIMATE MID-YEAR! BUDGET FY 2011-12 BUDGET 'From Special Gas Tax For- $ 3,620,000 $ 3,620,000 0 Street Maintenance-$3, 130,000 Street Lighting - $490,000 N 'From Traffic Safety For- 1,400,000 1,200,000 (200,000) ~ 0 Police Costs ~ ~ ~ 0 ... 'From 1/2 Cent Sales & Road Tax For- 1,350,000 1,350,000 0 >- Administration - $250,000 ... ~ Street Main!. - $500,000 .e Street Lighting - $600,000 ~ ): 'From Cultural Development Fund For- 357,000 ~ 357,000 0 - II Fine Arts & Civic/Promotional $357,000 '" ... ::I 01 ~ .. 'From Storm Drain Construction For - 132,700 132,700 0 ~ Administration :!! ::E C 'From Refuse Fund For - 3,721,800 3,721,800 0 ., .... Administration $3,929,900 ... ~ NPDES Coord 66,600 i Lease City Yards 600,000 Ul Lease City Hall 55,200 II: w Street impact 500,000 ... Ul CommunicallGrants 30,000 z ~ Tree Trim Costs 70,000 C- Ui 'From Sewer Line Construction For- 225,000 225,000 0 z Administration i:! l- e :::> 'From Sewer Line Main!. Fund For- 1,510,900 1,510,900 0 01 Administration $1,412,100 '" c Right of Way Charge $254,900 II E Tree Trim Costs 30,000 .c u Reimb Sewer Lift Costs $252,600 ! 'From CFD 1033-Fire Station Fund For - 573,700 585,600 11,900 Maintenance & Operation Costs 'From Transportation Fund For- 70,000 70,000 0 Traffic Engineering Costs $40,000 C MainllFuel AI!. Fuel Veh $30,000 IC:::~~ CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2011-2012 c TRANSFERS - IN MID - YEAR ESTIMATE FY 2011-12 338,100 VARIANCE MID-YEAR! BUDGET 'From Liability Fund For- City Attorney Dept Budget FY 2011-12 BUDGET 338,100 - o .. ~ co "1 ~ ~ co N t ~ .Ii! ~ ~ *Qi '" " " ID ~ .. ~ :s! ::l! C CD .... .. ~ ~ &! w IL '" Z ~ I- - iii z ~ l- e ::l ID ... c " E .c u .. li! c 1IP""W"7, ..........-, 'To General Fund For- Administration of Fund c lIIIP""l"',"," . ~~-;. - c c c CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2011-2012 - 0 N ~ C> ~ ~ ~ C> ... > ... ~ .2 ~ ~ - " .. ... 0 " al ~ .. " >;- :!! :l! '" '" ... ~ ;:- ::> 0 Ul Ill: w ... Ul Z ~ '=- 0 Ul Z ~ l- e ::> al ~ " E .c " .. li TRANSFERS - OUT MID - YEAR ESTIMATE FY 2011-12 VARIANCE MID-YRI BUDGET FY 2011-12 BUDGET Administration $3,929,900 Lease City Yards $ 600,000 Lease City Hall $ 55,200 Street Impact $ 500,000 NPDES Coord. $ 66,600 CommunicUGrant $ 30,000 Tree Tim Costs 70,000 3,721,800 3,721,800 'To General Fund For- Administration $1,412,100 Right of Way Charges $254,900 Tree Trim $ 30,000 Reimb Sewer Lift Costs $252,600 1,510,900 1,510,900 11:::::,