Loading...
HomeMy WebLinkAbout03.A- Finance 3.A DOC ID: 2931 CITY OF SAN BERNARDINO—REQUEST FOR COUNCIL ACTION Budget From: David Cain M/CC Meeting Date: 02/10/2014 Prepared by: Veronica Martinez, (909) 384- 5242 Dept: Finance Ward(s): All Subject: Mid-Year Budget Review (#2931) Current Business Registration Certificate: Not Applicable Financial Impact: Account Budgeted Amount: «Inert Amount>> Account No. «Inert Account No.>> Account Description: <<Insert Account Description Balance as of: «Inert Date>> Balance after approval of this item: <<Insert Amount>> Please note this balance does not indicate available funding. It does not include non-encumbered reoccurring expenses or expenses incurred,but not yet processed. Motion: Receive and file. Synopsis of Previous Council Action: <<Insert synopsis here>> DISCUSSION Attached is the FY 2013-14 Mid-Year Budget Report. This report is designed to keep the Mayor and Common Council informed of the financial position of the City. This report provides information regarding the City's fiscal performance during FY 2013-14 as well as estimated cash balances available for next fiscal year's budget preparation. On April 22, 2013 the Mayor and Common Council adopted the budget for FYs 2012-13 and 2013-14, which included personnel cost savings assumptions worth $10.7 million and various revenue strategy assumptions worth about $10.2 million, derived from the Pre-pendency Plan, the Nine-point Plan and the Pendency Plan. The budget is a significant step for the City to effectuate a long term plan of adjustment a requirement to exit the Chapter 9 bankruptcy process. Background: Operating results for FY 2012-13 - The preliminary review of General Fund reported total revenues and total expenses for FY 2012-2013 indicates that, due to the diligence of the City's staff,net revenues over expenses exceeded budget. Impact of Economy - The City is beginning to benefit from the improving economy. The recession during the 2008 to 2013 period had a devastating impact on the City. It saw property tax revenues decline by approximately 18%. In addition,revenues from sales tax, franchise fees, Updated:2/6/2014 by Linda Sutherland I Packet Pg. 585 3. 2931 utility user tax, and other fees declined precipitously. Also, the overall labor market exacerbated the already above average unemployment in San Bernardino. Currently, we are seeing positive growth in property values (projected to be 3.7% for FY 2013-14), which is flowing through to the City by way of stronger property tax revenues. In December 2013, 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. Due to the timing of required financial submission related to the bankruptcy, the process was started earlier than usual, and used data captured during the first five months of the fiscal year. The objective was to review year-to-date activity and identify costs savings or cost overruns through the end of the fiscal year. The attached schedules of the mid- year report provide the updated projections for the General Fund and other operating funds in the City. Each schedule of the mid-year report includes an analysis for each fund, budget variances, projected revenue, and proposed budget amendments. The Summary of Mid-Year Recommended Adjustments to Revenues & Expenditures (page 2) provides a summary overview of all the major funds in the City. The first column of numbers provides the un-audited beginning budget cash balances for each fund. The last column of numbers on the report indicates the estimated cash balances for each fund at 6/30/14. Most funds appear to be on target with estimates contained in the FY 2013-14 adopted budget. ANALYSIS The General Fund The "Schedule A - Summary of Mid year Recommended Adjustments to Revenues and Expenditures" (page 2) provides an overview of the General and Other Funds. The adopted budget for the General Fund projected net revenues over expenses to be $6.47 million. Due to higher than anticipated revenues, General Fund revenues and transfers-in, as amended and proposed, are estimated to be about $6.8 million greater than the original budget. Despite the increase in revenues, General Fund deductions, including transfers-out, as amended and proposed, are anticipated to be about $11.62 million more than the original budget resulting in net revenues over expenses of$1,612,399. General Fund Revenues Schedule C "General Fund Revenue Detail Report" (pages 4-6) provides a summary of the General Fund revenue estimates by category and revenue type. It presents line item detail for FY 2012-13 (historical) and for FY 2013-14, including General Fund revenues as adopted, Mayor and Common Council approved amendments, and the mid-year forecasted budget. In total, estimated General Fund revenues (including transfers-in) are projected to be $4.9 million more than budgeted. Discussed below are some of the major highlights regarding General Fund revenues: Property Tax revenues are estimated to be $3.1 million greater than the adopted budget. The major reason for this increase is due to pass-through payments and unanticipated residual tax Updated:2/6/2014 by Linda Sutherland I Packet Pg. 586 i t 2931 increment from City of San Bernardino Successor Agency (formerly the Economic Development Agency). This resulted in $2.3 million of unanticipated revenues. These projected revenues include: • EDA Incremental Tax Payment, Statutory Pass Thru of$246,000; • Incremental Tax Payment,Negotiated Pass Thru of$1,386,852; and • Incremental Tax Payment, Est. Residual Balance Pass thru of$931,935. Staff anticipates the residual balance pass thru payments could vary annually as a result of the dissolution process and on-going dialog between the Successor Agency and the State Department of Finance. Other property tax components, including current secured, current unsecured and prior property taxes had adjustments both up and down, resulting in a net change of$257,501. Property Tax In Lieu of VLF is forecasted to exceed budget assumptions by$413,334. Property Tax In Lieu of VLF revenue is calculated by the State based on the City's assessed valuation and the City is seeing an increase in its assessed valuation, and this was reflected in increased revenues in FY 2012-13. Packet Pg.587 Updated: 2/6/2014 by Linda Sutherland 2931 Sales Tax revenues for FY 2013-14 are anticipated to be about $1.3 million higher than what was originally forecasted in the budget. The City, like most areas in the State, is continuing to see some growth again in sales tax. Utility User Tax revenue is projected to be in line with the budgeted amount of$22.5 million. This is comparable to the $22.47 million received in FY 2012-2013. Measure Z-District Tax revenues are estimated to be slightly higher than the original budget projection. Approximately $305,000 more will be collected in FY 2013-14 for a total of $7,000,000. In FY 2012-13 the City received$6,806,870 in revenue from Measure Z. Transient Occupancy revenues are anticipated to come in at the originally estimated budget amount of$2.6 million. Licenses and Permits revenue, highly dependent on building activity, has had positive growth during this two-year budget cycle. Actual revenues are projected to be $9,324,651, an increase of $639,251 over budget. Of the components of this group, business registration revenues are anticipated to come in at the originally estimated budget amount of$6,514,500. Other license and permit activities in this category (not including business registration) are expected to collect $2.8 million, which is approximately $639,000 greater than budgeted. Actual revenues for FY 2012-13 were $2.7 million. Fees in this revenue category, however, are largely driven by development and building activity and should be viewed as one-time revenue sources. Fines and Penalties revenue is estimated to contribute about $345,000 less than the budget amount. This decrease in revenue is mainly due to parking citations and police administrative civil penalties revenues coming in at less than anticipated levels. This is, in part, due to enforcement personnel being assigned to higher priority, safety-related activities. Money & Property, consisting of rental, parking fee and vending activity is projected to come in at its budgeted amount of$638,000. Intergovernmental Revenues are estimated to be slightly higher than budget estimates by a total of $154,000. The increase comes from various governmental sources, with revenue changes being both up and down. The major contributors to the net increase were an increase in mutual aid revenue, with income estimated at $300,000 for contracted emergency response services; and $177,117 in revenues for providing safety services to the San Bernardino International Airport Authority, under a master service agreement. This agreement is subject to further review and validation. Offsetting these was a decline of$232,559 of revenues from the State of California for mandated services to the community. At this point the program appears to have ended. Charges for Service revenue are expected to be lower than budget projections by $362,000. The majority of the revenue shortfall is from the single family home rental inspection and weed abatement fees. The Single Family Home Rental Program was suspended in June, 2012. Subsequently, the Code Inspection unit was integrated into the Police Department. Initially, the program was slow to be re-initiated. The last factor was a change in the program and required City inspections. Previously, inspections by the City were required annually. Currently, .: inspections by the City are performed every third year, with the other years allowing for home- Updated: 2/6/2014 by Linda Sutherland Packet Pg.588 2931 owner self-certification. As a result fee income is down. Also, the City Clerk's Office stopped processing applications for passports, reducing revenues by$60,000. The Miscellaneous revenue category is projected to collect about $6.1 million or $80,232 more than the original budget. The majority of this revenue is from an amended master service agreement with the Water Department for FY 2013-14, resulting in a $300,000 increase in its administrative contribution. Offsetting this is an anticipated decline in Police miscellaneous receipts of$200,000, and a decline of emergency hazardous materials revenues as the service has ■ been altered. General Fund Expenditures The "Schedule F-Expenditures by Category-All Funds"report provides a list by department of estimated General Fund expenditures. General Fund expenditures are projected to be approximately $128,096,695. Including transfers-out total disbursements are projected to be approximately $131,342,904. This is an increase of $11,623,967 over the adopted budget amount of$119,718,937 for unanticipated costs for non-operational activities. These include the assumption of$3,450,089 of debt previously funded by the EDA and recently disallowed by the State Department of Finance, $2,635,000 of legal and consulting costs related to the bankruptcy, and$1,370,952 of water usage charges, which resulted from a change in the usage policies of the City and the Water Department. Exclusive of these costs, the projected expenditures and transfers-out were higher than budgeted by $3,339,332. These higher costs included Charter 186 costs of $1,285,074, higher than expected compensation costs for the Police Department of $433,281 (including Charter 186 costs and higher benefit costs of$1.1 million, offset by salary savings), and Fire Department costs of$125,830 (including Charter 186 costs, offset by salary savings), additional audit costs for FY 2011-12 and FY 2012-13 of$392,900. Overtime - As in prior years, the current staffing protocol and staffing levels in public safety have resulted in overtime costs in excess of budgeted amounts. Total overtime per the original budget was $7,817,253 for the City. Of that amount, $4,828,730 and $2,136,600 were budgeted for Fire and Police, respectively. Forecasted overtime costs for FY 2013-14 are estimated at $10,874,275. This includes $7,065,300 for Fire and$2,676,108 for Police. Charter 186 - Under the City's Charter Sworn employees' salaries are determined through a survey system. Due to the timing of the survey and calculation, the required amount is not known at the time of the initial budgeting process. As a result, an amendment is made as soon as the salary adjustments are determined. Fire Department - SAFER Grants were awarded to the Fire Department for FYs 2012-13, 2013- 14, and 2014-15. The first grant of$3,363,972 covered FY 2012-13 ($1,681,986) and FY 2013- 14 ($1,681,986); the second of $2,145,096 covered FY 2013-14 ($1,072,548) and FY 2014-15 ($1,072,548). The grants provide for the hiring of firemen and other costs. Fourteen firemen were hired from FY 2012 to FY 2013 under these grants. The City must prepare for alternatives in FY 2014-15 and beyond should this source of funding decline. As in prior fiscal years the Fire Department's budget includes costs that result from mutual aid calls. The City has to cover the costs of these calls but then is reimbursed through the mutual aid system. The City's adopted budget and the current mid-year estimates reflects both the costs in Updated: 2/6/2014 by Linda Sutherland Packet Pg.,-589 2931 the Fire Department budget as well as the revenue reimbursements in the mutual aid revenue account. Previous Mayor and Common Council Actions- As a result of the bankruptcy, and the recall election and special elections, the Mayor and Common Council approved several actions which are reflected in the mid-year report. Specifically, the Mayor and Common Council approved the and increase of$250,000 to pay for the Special Elections, Charter 186 salary adjustments of $1,285,074 and an increase in debt service obligations of$1,157,550. Bankruptcy - The cost to proceed with the bankruptcy is significant. In addition to the external costs associated with professional fees the time requirement of staff is tremendous. For FY 2013-14 staff anticipates the cost for bankruptcy services to be $4.6 million. For FY 2012-13, costs were $3.9 million. One issue noted during the bankruptcy process is the inadequate staffing level in the finance department; which is the primary unit supporting the City's process. As the bankruptcy process has progressed, costs have risen faster than expected due to both extensive mediation activities and to defending ancillary lawsuit challenges by creditors. Dissolution of the Economic Development Agency - As a result of AB 1 X 26, the State of California dissolved all local redevelopment agencies in the state. The impact on most cities has been a significant reduction on community redevelopment, but more importantly, has required cities, including the City of San Bernardino, to expend significant resources to facilitate the dissolution process. In addition, in many instances, the process as administered by the California Department of Finance has impaired the anticipated wind-down process of cities. The City of San Bernardino has encountered numerous problems in requesting and receiving approval for costs associated with the former Economic Development Agency. Specific to the City was the rejection of Economic Development Agency debt, requiring the City to assume payments. The 1999 Certificates of Participation (COPS) debt obligations for South Valle/201 Building, with annual debt service of$637,000 were deemed ineligible obligations for EDA. In addition, another borrowing of$1.6 million from a City administered fund by the EDA was determined by the State of California to be ineligible obligation, resulting in $2.8 million of debt being assumed by the General Fund. Measure Z District Tax As discussed previously, the Measure Z revenues are estimated to be higher than the budget estimates by $305,000. Measure Z expenditures are fully utilized by the Police Department and are assumed as part of the Department's $56.7 million budget. Updated: 2/6/2014 by Linda Sutherland Packet Pg.590 2931 OTHER FUNDS The Schedule Other Funds Revenue Report (pages 7-12) provides a comparative review and updated revenue projections for funds other than the General Fund (Special Revenue Funds, Internal Service Funds, and Enterprise Funds. Based on the updated revenue and expenditure projections for all other funds, the ending balances at June 30, 2014 appear to be on target to what was estimated in the FY 2013-14 adopted budget. Capital Project Funds - For most Capital Project Funds it is assumed that budgeted Public Works projects, in the amount of$13,601,421 will be completed on schedule. Internal Service Funds The City utilizes internal service funds to manage and pay common costs for City departments. These funds include utilities, telecommunications, IT, workers compensation, unemployment insurance, general liability and fleet services. Under this process, costs are paid by a single managing department, which are passed through to the ultimate user department via internal charges. The City staff is currently working on the allocation methodology for the Internal Service Funds. Currently, costs are allocated based on budgeted amounts, which may not fully pass cost along to receiving departments. Specifically, costs for utility costs, workers compensation, and general liability have not been fully assigned to City departments. The fiscal impact is that certain departments may not be aware of, or paying,the true cost of operating. Workers Compensation and Liability Funds - Due to Governmental Accounting Standards Board (GASB) accounting rules, the City is required to show all of the City's unfunded liability for potential claims and judgments in both funds (in essence what the amounts would be if every potential claim and judgment had to be paid at one time). As a resulting of above mentioned reporting requirements, as presented in the Adopted Budget, these funds have significant deficit balances. CONCLUSION The FY 2013-14 Mid-Year Budget Report is one of the first steps in beginning the FY 2014-15 budget preparation process. The factors impacting the City's operations and financial condition are numerous. In developing and implementing a comprehensive plan to bring the City out of bankruptcy, the development of an accurate, balanced and achievable budget is critical. The City's General Fund is still in a very weak condition and efforts need to continue to build the General Fund Reserve to stabilize this fund. The City Manager will be proactively working with each department to develop and present a balanced budget to the Mayor and Common Council that moves the City forward in achieving its financial goals. Supporting Documents: Mid year budget review 2013-14 Final (PDF) Mid-Year Budget Summaries V12 (PDF) �F� Updated:2/6/2014 by Linda Sutherland €i ° MGIAaa 196png aeaA p!W : 6£66 JBUIJ V,4-£60Z N+ainaJ 196pnq aeaA piW :juaw'43e;jd N Q L ri PM" 0. Low d a � `rril u 0 N f,. o e L L MOIAON jeBpn8 ieeA p!W MZ) IBu!.4 VVCWZ mGIAG.J le6pnq ieeA p!W :;u8w43BllV d 1 1 nnalna� ;a6pn8 aeaA pIW : 6£6Z) IeulA t,b-£60Z nnalnaa ;a6pnq aeaA p!w :;uauagae q rn Q � � M a w a a E _0 � U � C� O U O 43 O CO LL 06 CO r CL (D .0 0 N U (D (n N N 0 4a o � L� 's= 4— CL. U) 0 4- CL O cz U O Q U m aD C: tz C aD a > O o O C _0 O o c- 0) E O _0 O n n � CL co i 1 Mainaa ;a6pn8 aeaA piW : x£66 leU1=l t,4-£6OZ Mainaa }a6pnq aeoA piw quawLjoeliv LO ca rn Q Ln ® ° i- ° ° O U cn C- LJL s•� o H a U) U .�c U) ° m N U +, O (3) L C (A r O � C: ��� Q O LZ a) Q CSI TO U) I— E � � W 4— o j 2 ® ° a� L o�* V3 ti) Co. r-v" Q 4) c� 4-j N EO A � � Wnn MOIAON jo6pnq aeaA pIW : t-£66 Iau!_A V -£60Z MOIAOa ;a6pnq aeaA pIW :juauayae};y ca rn Q LO M . ` a �• • a Ah Ak LL " co AAk L 4) r MOIAOa ;a6pn8 weak piw : x£66 leU1=l V6-£60Z MaInaJ }a6pnq aeoA piw :;uawyae}}y ti Q `n vi C/: a CL a Q — Q mw c 75 N lqw (D Q) A) {l7 b9 i O (Yi C r C) C-) LO 160 O � U ill U) (o u� O E ° (n ° � Q) U OZ/1 MaInaa }a6pn8 aeeA piw 6UZ) IBUIJ ti6-£bOZ Malnaa ;a6pnq aeaA piW quawLjoeliv rn LO F4m d D V a.. co *� cn � c Q r, ® :5; c9 (10 cY o 00 00 C oo CD CD U 00 m r � I 0 > C- <t CC O � Co x � � �- o- F- W Y — D x CL n- m Q cfl o 't cJ cn H � v U) o Lo UH � d n I E h Q m W 1 1 1 1 / 1 1 1 M81AGH Ia6png meA pIw : MZ) Iaul_q V6-£60Z M►alnaJ}a6pnq jBeA pIw :Iuawy3e}}y I. E 3' � � k A y ."v N Mahal{ jeBpnq aeaA p!W : 6£6Z) leU1=l ti6-£60Z MainaJ IeBpnq aeoA plW :}uawgoe;;b o CL X, � o co d Rf r W m Lm 7 V/ x IM co cvi %M Cz w CS? N tea_. ry >% � U D Q C). ' Z =3 ddmak C: ILMLAW Q c� ARM Um �- lw O o , JLL 00 U) U) Q 0� o Z3 � .0 w � CY) Z 0 CL uj _ n n n n � m Q Maps aN ;a6pn8 aeaA p!w : 6£6Z) leU1_A V4-£60Z Ma!na.l ja6pnq aeaf( p!w quawpelIV ca c°o M rn d V/ � Y V a c3 E 0 4) 0 CZ C: LM cn Lm C: a) 4) 4) .0 LL CL ca I— ctj �- CC3 Co o- ®— Z 4) cn W � ._ LL 0 — ® '- U L� U •- CL5 -0 m 0 co- 0 LU 0) a) 0 0 tU 0 Z OMO o.. zU 0ry uj n n n C3 Q nnalnab ;a6pn8 aeoA pIw : 4£6Z) IBuIZI V6-£60Z MOIAGa;a6pnq aeaA pIW :;uawgc)e};y N F4m � �- - � oo ri ;rt n. e IL 4-1 1 • , 1 • • ' + • AM IVA uj 1 • 1 • • • + • • • 1 H + • , 1 r • 1 ' 1 • • a • 1 1 • � 1 1 / • 1 1 ' Ma!naN ;e6pn8 aeaA p!W : �NZ) leUlj V4-£60Z Ma!naa;a6pnq aeeA p!W :Iuawgoe;;y o e� o q cm i M a low q) a� d I Y V a i i O Q �a W 1�1 O v V W o ' w� Q i Z M U. • ' J ' ' �a m� OC tr. W W • s ! 1l WZ/0 6/Z MainaU ;a6pn8 aeaA p!W : ►.£6Z) leU[=] V6-£40Z Mainaa;a6pnq weal( p!W :;uewgoeliy LO to LO LO C� N C3) CO N d• � � a VA "' CY) r C� N Ce) N r• cf �- 00 CL CN CD 0 o 0 c: _0 > �. U CY)> 0 0 a I— 0- C:• .�, �. � — 0 0 U) c� cn d c cn 0 M 0 N m Ct5 4- 0 U C v o �. (ll U N ry :'_' CCU } N RS Cy n m 0 U w 75 offoff- ° tv • 0 0 0 0 0 E E cu O v a •o 0 n a. i.L U = t- Ma!ABU ;a6pn8 weak p w : 6£6Z) leUl� VL-£60Z Mainaa 106pnq aea�( piw :;uawgoe};y CD • ,: a 0 v-: vi } 6 C'i M N 60- M x ° 0' 0 00 co N N • . CD co, u � co w • ® 75 • "N r N Cy7 M T-: r' 60. low LO N N LO � LO r tU ice•- CV a; 6 r N r Lf=z, {f} 60. 6 F- Z � U3 �" Cn ry a > IU6 LLI L LJ W W W X W � LL U) I_I W Q!cl) i Q IQ- Lt Q H i- X F- 0 LXU F- W Z W MainaN 196png aeaA piw : 6£6Z) leU1_q t L-£60Z MainaI ja6pnq aeaA piw :tuauayaej;y to o vi `` a a� Y V • Q ` r • N � � �. Q Q • N N M Q) co U � 0 C: (Y) Q � N :3 CY) C`7 - { - CL {g- d' r O ` N � • CU • N CY 4 • r— c- •• CD O CN Ems CD a (D cy) M � � �co (.0- "o o 6q CO s- r v - CL 60=)- i i mmAO U mepn§jo®i mw : K£Z mm] #kE�O®mAGJRBPngjeaft mw :iu w'43e n¥ . . a . = .x. . JUL f : « .. ► ■ ■ MO!AOb ja6pn8 aeaA p!W : �UZ) leU1=l V6-£60Z Mainaa 196pnq aeaA p!W quauayae};d o cli a. � o cc Y .C: x V W tC a 0 -0 C: w D L— > .Q QD r� 4— > V) W L� o `,° Q 00 LL o C''e) ' a) �( I° Z ® o C: Z � .� a� W H ry o W U E H ® C: � Q Z cn �U) > cu o Q cu � o .® _ (1) >1 to 11I � c(/) p c: (10 . z o �- o 0 o � WU J .{.� 0- �- tWZ/OL/Z Mainab 196pn8 aeoA p!W : 6UZ) leU1_A V6-£bOZ Mainaa }a6pnq aeaA p!W :Iuawgoe4lV c a a d Y V R a ^L W 4—j C f r% cr) E cn E w t o o � o a. o C) LLI . o ` U- a) o o •x U) � u- �, •° c C)) UL o c: E � 0 •C: C/) mM � E E � ._ oE o C: IM6 w 0 u.. < co C 1 i nna!naa ;aBpnB aeaA p!W : LUZ) IeU1=l V6-E60Z MO!Aaa ;a6pnq aeaft p!w :}Uauayaej;y m �a IL .a s- CU U- 0 ® Q -i—� T O R LEI ( _® -� co to uj U) .o (1) a) 06 ® a) U) :f= s— M aD L— cv - -U > ICI ._ 1 1 MO!naa ja6pn8 aeok p!W �UZ) IeU1j t,6-£60Z MO!naJ ja6pnq weal( p!W :Iuawgoelly N ca co M d V/ y Y n� V W a -i-a L n L� M �® W 4 �C: E nomn,, o E Za 0 > N a C.) -E ® o CY} U) M I..- .� L ® U 4-a 0 a� ._ }, 4-1 CL Cl) > -� cn m .� y- Q} p tC m w w mom C.. = �" LO a� I— r . .N .a 4-a (D N .0 S. 0 �` - > ® CL IL W ,^ ^. L I-- dffiwwmft� Malnaa ;a6pn8 aeeA p!w : 6£6Z) leu!_A t76-£40Z Ma!naJ ja6pnq aeeA piW :;uauayaellV ca � �\ co a w d Y V -4—j a t; OLD CO O : L ® 0L .O O d- O r �-- Q O x tv D UL _ O � _0 (v Z3 CU 0) -0-0 -0 C: 0� L- Cf) O E I O �- N E ,�. m cu o as r � �-- O � N � 4-a Q OC .. : m I U) >' § Ln �- 0) C: N C: CU QL O Um nnainaN 196pn8 aeaA piw : 6UZ) leUlj tib-£60Z nnainaJ ;aBpnq aeaA piW :Iuewgoe;;y d ai a , , IL ZX '"`fir' •«µr:'e, ,s°''..,.+'' „w„r w°° "�' `""��^"'�.�'" '""�'°�x" w�r,.°"° .r"r'"~,�--",.�� .. „��„ sw ,� :*"� :�' <"".'„ '`w` ..."'.. "'r,�,"��' ""���- ''„ter:✓,,�`�,..����,r" � ,._^ ,.✓" ,,�"� ,p .:"" a^,:s'.°� ,. �,.�,r ',;r"" „„w" x "'a°t*...,�'w'° .r""a .rw .-"`� _,.,w^"f x.!';,`;;,�i,t ��,"'"x`...w`' w`":t'",r'rw`'w �� ter" ,,_ ,„�,• �.w^',,r'�� «`��,,.�"w*'`x �rw' .�' ",r* .� .�'' � a�,, �"�wx,.,•'°�'�",,.�.�•'�w''� ."".'.,,.9 ,,'f.r �,. �'' ,,�� �''�w.r r�,x. ..�' �., .r'`.✓"`�'" f r r .w',w'" �rT "'' ,w�._ r'°'� r,,,x ,w'''°w w'", ,„„"-, w",, ,.w� .^,,' ::-'-,w,�r,�,.,,�''��,,,- ,"`�r�,'x,.��„��,•°�` r � .w" .✓ �% ell �° ��w"/..�* �w° ..'"� „-'A�,.� „"w �' .�✓'��- fr..*`` �x;•^_..w�„"°`�s'�x"" � max' w�"_ '''w .a'° g` "" "'� "w ..�"�"="�w", "i ,^"� °r ""� .wr,-" '' '! ,". w-'' °:x .r°`," .:.^",, ...�, ,fs.-:w,�.,ww,,,�, �,,• x,r r' {; r r r' ,' ,.",�✓. 'F r ,,' ,w r" 1 r'"..w .� ,^ ."' .,,. "e r �✓ r'':"� ,x" w, ,w s',;. -" or ""r'w ,' ''°-,w' w^'`"s F. „w r'""`-.,.w'`r"' '�w,.r�� ..+'.w°".,,�� ,A`,x.'r,��:ri�''�,,� x-"" .,,� - "'"_ ,.' ^,. ✓ �,' _ ✓` r ' .'r °` '� ��ws.w :w' �� w`',"^`s .""'-�ww",r: 'm w°w.�:'x"A�� s,w° x^.:. .r` ,J`��„ r. � f, r s � ;a- �, W' �^ ., w=' ,� �"'��w ✓' �'�„-_"./�":�''"`r .��. ;x x;, "'.� w^"w•` ° '..w w°"� ,` ✓• /r ew' .s ,^''",� x s'`.,-- ,s s:' w`, .r�w.o-�" ,x`'.r"" r , 3.A.b City of San Bernardino Mid-Year Update of General Fund and All Other Fund Budgets GENERAL FUND: Adopted Approved Amended Proposed Mid-Year Budget Amendments Budget Amendments Projection Depart. Revenues 114,735,172 112,844 114,848,016 4,790,751 119,638,767 Transfer In 11,452,986 1,872,548 13,325,534 - 13,325,534 Total Revenue 126,188,158 1,985,392 128,173,550 4,790,751 132,964,301 0 Fund 123 - SAFER U) (2012) 1,072,548 0 3 as Expenses 117,202,937 3,689,177 120,892,114 7,204,581 128,096,695 Transfer Out 2,516,000 - 2,516,000 730,209 3,246,209 Total Expense 119,718,937 3,689,177 123,408,114 7,934,790 131,342,904 rn 3 Net- Rev-Exp 6,469,221 (1,703,785) 4,765,436 (3,144,039) 1,621,397 00 R d Net- Rev-Exp 6,469,221 Revenue 6,776,143 r Expenses 11,623,967 Net- Rev-Exp 1,621,397 N r Vl ALL OTHER FUNDS: Adopted Approved Amended Proposed Mid-Year E Budget Amendments Budget Amendments Projection E U) Revenues 84,634,355 2,429,618 87,063,973 4,153,858 91,217,831 Transfer In 2,558,500 - 2,558,500 730,209 3,288,709 Total Revenue 87,192,855 2,429,618 89,622,473 4,884,067 94,506,540 00 m Expenses 82,177,283 1,355,679 83,532,962 (619,702) 82,913,260 Transfer Out 11,495,486 1,872,548 13,368,034 - 13,368,034 Total Expense 93,672,769 3,228,227 96,900,996 (619,702) 96,281,294 E City Clerk Net- Rev-Exp (5,479,914) (798,609) (7,278,523) 5,503,769 (1,774,754) Q Net- Rev-Exp - Revenue 730,209 Expenses 1,872,548 Net- Rev-Exp (1,142,339) Packet Pg.615 CITY OF SAN BERNARDINO SCHE 3.A.h FY 2013-2014 SUMMARY OF MID-YEAR RECOMMENDED ADJUSTMENS TO REVENUES&EXPENDITURES ESTIMATED I ESTIMATED CASH I ADDITIONS TOTAL DEDUCTIONS TOTAL CASH BALANC FUND/TITLE 7-1-13 1 REVENUES ITRANSFERS AVAILABLE I EXPENSES ITRANSFERS I DEDUCTIONS 6-30-14 001 GENERAL FUND 8,664,806 1$ 119,638,767 $ 13,325.534 1$ 141,629,107 $ 128,096,695 $ 3,246.209 1$ 131,342,904 1$ 10,286,20 SPECIAL REVENUE FUNDS: General Fund Related Funds 105 LIBRARY $ 159,929 $ 43,100 $ 1,700,000 $ 1,903,029 $ 1,716,129 $ 42,500 $ 1,758,629 $ 144,40 106 CEMETERY $ (71,609) 16,550 271,923 $ 216,864 214,865 - $ 214,865 $ 1,99 107 CATV 521,622 262,278 $ 783,900 262,831 $ 262,831 $ 521,06 124 ANIMAL CONTROL 536,534 1,417,500 816,000 $ 2,770,034 2,277,149 $ 2,277,149 $ 492,88 133 BASEBALL STADIUM 49,048 $ 49,048 49,048 $ 49,048 $ 134 SOCCER FIELD COMPLEX 488,157 401,000 - $ 889,157 447,041 - $ 447,041 $ 442,11 Sub-Total $ 1,634,633 $ 2,140,428 $ 2,836,971 $ 6,612,032 $ 4,967,063 $ 42,500 $ 5,009,563 $ 1,602,46 Non-General Fund 004 FEMA(2) $ 45,879 $ - $ - $ 45,879 $ - $ - $ - $ 45,87 108 FED ASSET FORFEITURE 1,163,245 605,000 - $ 1,768,245 708,400 - $ 708,400 1,059,84 �. 111 AIR QUALITY-AB 2766 99,792 255,200 $ 354,992 125,724 70,000 $ 195,724 159,26 Q- 116 EMERGENCY SHELTER GRANT(2) (190,602)1 259,000 $ 68,398 259,000 - $ 259,000 (190,60 t 117 HOME PART INV ACT(2) 313,921 2,400,000 - $ 2,713,921 2,400,000 - $ 2,400,000 313,92 U) 118 DRUG/GANG 146,946 30,300 - $ 177,246 30,385 - $ 30,385 146,86 L- 119 CDBG 2 857,284) 2,847,747 $ 1,990,463 2,861,109 $ 2,861,109 (870,64 0 120 NEIGHBORHOOD STABLIZATION(2) (947,741) 2,120,000 $ 1,172,259 2,120,000 $ 2,120,000 (947,74 121 SBETA 2 (777,838) 3,185,464 $ 2,407,626 3,185,464 $ 3,185,464 (777,83 3 123 GRANTS FUND(2) (3,926,038) 4.609.074 $ 683,036 816,100 3,792,934 $ 4,609,034 (3,925,99 2 127 LOW MOD HOUSING 343,601 $ 343,601 $ - 343,60 -� 128 TRAFFIC SAFETY 889,130 514,489 - $ 1,403,619 651,448 - $ 651,448 752,17 132 SEWER LINE MAINT 2,639,793 3,207,500 $ 5,847,293 2,724,772 700,000 $ 3,424,772 2,422,52 �.. 137 CFD 1033-FIRE STATION M&0 324,623 585,600 $ 910,223 585,600 $ 585,600 324,62 775 PERPETUAL CARE FUND 659,526 $ 659,526 $ 659,52 CA 211 TRIBAL FIRE AGREEMENT 67,971 - $ 67,971 41,019 - $ 41,019 26,95 7 Sub-Total $ 5,077) $ 20,619,374 $ - $ 20,614,297 $ 15,923,421 $ 5,148,534 $ 21,071,955 $ (457,65 m L TOTAL SPECIAL REVENUES 1,629,556 22,759,802 2,836,971 27,226,329 T 20,890,484 5,191,034 26,081,518 1,1 ,81 d CAPITAL PROJECT FUNDS: � 126 SPECIAL GAS TAX $ 302,706 $ 5,939,647 $ - $ 6,242,353 $ 459,823 $ 4,420,000 $ 4,879,823 $ 1,362,53 129 1/2 CENT SALES&ROAD TAX 5,223,361 2,997,716 8,221,077 1,756,754 1,200,000 2,956,754 5,264,32 135 TRAFFIC CONGESTION(1) 816 - 816 - - 81 208 VERDEMONT INFRASTRUCTURE 246,094 246,094 110,000 110,000 136,09 M 242 STREET CONST (744,673) 2,212,300 1,467,627 2,212,300 2,212,300 (744,67 04 243 PARK CONST(1) 168,233 1,200,000 1,368,233 1,368,233 1,368,233 - 244 CEMETERY CONST 52,584 -1 52,584 - 52,58 N 246 PUBLIC IMPROVEMENT 1,080,771 8,000 - 1,088,771 - - - 1,088,77 T- 250 TRAFFIC SYSTEM CONST(1) - N 258 PROPOSITION 1B 64,322 - - 64,322 - - - 64,32 01 TOTAL CAPITAL PROJECTS 6,394,213 12,357,663 S 18,751,878 5,907,110 5,620,000 11,527,110 7,224,76 t4 ASSESSMENT DISTRICT FUNDS: E 254 LANDSCAPE MAINT DIST(1) 1$ (91,902)1$ 1,277.898 1$ 409,238 $ 1,595,234 $ 1,604,374 $ - $ 1.604,374 $ (9,14 E TOTAL ASSESSMENT DISTRICT Is (91,902)1$ 1,277,898 409,238 1 E 1,595,234 1,504,374 $ 1,604,374 (9,14 3 IMPACT FEE FUNDS: �. 245 SEWER LINE CONST DIF $ 2,555,598 $ 252,000 $ $ 2,807,598 $ 331,798 $ $ 331,798 $ 2,475,80 i� 247 CULTURAL DEV 830,819 751,000 1,581,819 357,000 357,000 1,224,81 'D 248 STORM DRAIN CONST 3,561,558 101,000 3,662,558 1,049,191 - 1,049,191 2,613,36 261 LAW ENFORCEMENT DEV 94,500 40,750 135,250 30,385 30,385 104,86 m 262 FIRE PROTECTION DEV 172,568 5,336 177,904 160,930 160,930 16,97 M 263 LOCAL CIRC SYS 708,289 131,505 - 839,794 110,170 - 110,170 729,62 264 REGIONAL CIRC SYST 7,478,655 1,710.000 9,188,655 4,836,736 4,836,736 4,351,91 265 LIBRARY FACILITIES 39,370 42,500 81,870 43,045 43,045 38,82 .� 266 PUBLIC MEETINGS FACILITIES 379,764 4,590 384,354 384,35 267 AQUATICS CENTER FACILITIES 115,477 1,200 116,677 - - 116,67 268 AB 1600 PARKLAND 1,458,010 3,620 - 1,461,630 1,095,080 - 1,095,080 366,55 C 269 QUIMBY ACT PARKLAND 241,642 600 - 242,242 47,791 - 47,791 194,45 TOTAL IMPACT FEE FUNDS 17,636,250 3,001,601 42,500 20,680,351 7,705,126 357,000 8,062,126 1 18,2 V DEBT SERVICE FUNDS: � 306 AD 987 DEBT SERVICE $ 19,108 $ - $ - $ 19,108 $ - $ - $ - $ 19,10 + 356 AD 1015 NEW PINE AVE 25,405 68,000 - 93405 68,000 - 68,000 25,40 a TOTAL DEBT SERVICE FUNDS 44,513 68,000 112,513 68,000 68,0 0 44,51 ENTERPRISE FUNDS: 527 REFUSE $ 3,331,206 24,664,800 1$ 27,996,006 $ 21,051,590 $ 2,200,000 $ 23,251,590 $ 4,744,41 INTERNAL SERVICE FUNDS: 621 CENTRAL SERVICES $ (124,536) $ 149,171 $ $ 24,635 $ 130,997 $ - $ 130,997 $ (106,36 629 LIABILITY 3,322,931 3,146,277 6,469,208 1,848,606 1,848,606 4,620,60 630 TELEPHONE SUPPORT 416,745 1,138,191 1,554,936 1,017,990 1,017,990 536,94 631 UTILITY (1,009,490) 5,613,393 4,603,903 5,725,818 5,725,818 (1,121,91 635 FLEET SERVICES 1,061,652 8,116,662 9,178,314 7,683,184 7,683,184 1,495,13 677 UNEMPLOYMENT (215,831) 283,000 67,169 265,000 265,000 (197,83 678 WORKER COMPENSATION 998.429) 4.332,247 3,333,818 4,489,307 4,489,307 (1,155,48 679 INFORMATION TECHNOLOGY 1,742.479 4.309,126 6,051,605 4,525,674 - 4,525,674 1,525,93 TOTAL INTERNAL SERVICE T 4,195,521 T 27,088,067 31, ,588 1 T 25,635,575 25,ubb,575 1 T 5,597,01 TOTAL ALL FUNDS 41,804,164 210,856,598 16,614,243 269,275,005 211,009,955 16,614,243 227,624,198 41,650,806 Packet Pg. 616 CITY OF SAN BERNARDINO u HISTORICAL SUMMARY OF REVENUES BY FUND SCHE n U FY 2012-2013 THROUGH FY 2013-2014 ADOPTED ACTUALS ADOPTED PROPOSED ADJUSTMENT DESCRIPTION 2012-2013 2012-2013 2013-2014 2013-2014 2013-2014 Unaudited 001 GENERAL FUND $ 114,386,034 $ 115,237,185 $ 114,735,172 $ 119,638,767 4,903,5E 004 FEMA(2) - - - - 105 LIBRARY 69,200 34,259 69,200 43,100 (26,1C 106 CEMETERY 14,550 11,847 14,550 16,550 2,0C 107 CABLE TV 228,607 282,552 227,885 $ 262,278 34,3 108 FEDERAL ASSET FORFEITURE 805,000 516,007 805,000 605,000 (200,OC 111 AIR QUALITY-AB 2766 255,200 261,057 255,200 255,200 116 EMERGENCY SHELTER GRANT(2) 280,971 259,000 259,000 117 HOME PART INVESTMENT ACT(2) 2,386,470 404 2,400,000 2,400,000 a 118 DRUG/GANG 30,300 19,478 30,300 30,300 O z 119 CDBG (2) 2,811,898 1,697,127 2,811,900 2,847,747 35,82 u) 120 NEIGHBORHOOD STABLIZATION (2) 2,915,401 - 2,120,000 2,120,000 `p 121 SBETA 2) 2,678,965 5,294,870 2,678,965 3,185,464 506,4( 123 GRANTS FUND (2) 6,100,416 9,856,179 2,720,386 4,609,074 1,888,6E 124 ANIMAL CONTROL 1,417,500 1,466,523 1,417,500 1,417,500 126 SPECIAL GAS TAX 5,301,927 4,752,312 6,140,429 5,939,647 (200,7E 128 TRAFFIC SAFETY 780,000 860,378 780,000 514,489 (265,51 129 1/2 CENT SALES&ROAD TAX 2,934,364 3,015,796 2,997,716 2,997,716 132 SEWER LINE MAINTENANCE 3,206,000 3,185,339 3,207,500 3,207,500 133 BASEBALL STADIUM - - - - m 134 SOCCER FIELD COMPLEX 401,000 383,400 401,000 401,000 135 TRAFFIC CONGESTION (1) - - - - 137 CFD 1033-FIRE STATION M&O 585,600 591,209 585,600 585,600 208 VERDEMONT INFRASTRUCTURE - (32) - - 211 TRIBAL FIRE AGREEMENT - - - co 242 STREET CONSTRUCTION 378,000 989,732 2,212,300 2,212,300 N 243 PARK CONSTRUCTION (1) 1,384,605 (73) - 1,200,000 1,200,OC N 244 CEMETERY CONSTRUCTION - (7) - - 245 SEWER LINE CONSTRUCTION 112,000 270,293 102,000 252,000 150,OC N 246 PUBLIC IMPROVEMENT 12,000 (140) 8,000 8,000 247 CULTURAL DEVELOPMENT 251,000 747,209 251,000 751,000 500,OC 248 STORM DRAIN CONSTRUCTION 278,000 928,138 276,000 101,000 (175,0C E 254 LANDSCAPE MAINT DISTRICT(1) 1,277,898 1,328,934 1,277,898 1,277,898 :3 U) 258 PROPOSITION 113 - (329) - - r a� 261 LAW ENFORCEMENT DEVELOPMENT 40,750 59,125 40,750 40,750 262 FIRE PROTECTION DEVELOPMENT 250 54,691 250 5,336 5,0E 0 263 LOCAL CIRCULATION SYSTEM 500 209,200 200 131,505 131,3C m 264 REGIONAL CIRCULATION SYSTEM 10,000 1,434,384 10,000 1,710,000 1,700,0( a�i 265 LIBRARY FACILITIES - 637 - - >- 266 PUBLIC MEETINGS FACILITIES 3,500 1,042 3,500 4,590 1,0� 267 AQUATICS CENTER FACILITIES 1,200 344 1,200 1,200 268 AB 1600 PARKLAND - 7,845 - 3,620 3,6 R y 269 QUIMBY ACT PARKLAND 600 30) 600 600 E 306 AD 987 DEBT SERVICE 51,400 69 51,400 - (51,4C v 356 AD 1015 NEW PINE AVE 68,000 64,854 68,000 68,000 527 REFUSE 25,186,600 25,000,590 25,186,600 24,664,800 (521,8C Q 621 CENTRAL SERVICES 149,171 65,868 149,171 149,171 629 LIABILITY 3,146,277 3,137,572 3,146,277 3,146,277 630 TELEPHONE SUPPORT 1,145,191 1,077,289 1,145,191 1,138,191 (7,OC 631 UTILITY 3,705,585 3,772,634 3,705,585 5,613,393 1,907,8C 635 FLEET SERVICES 8,117,662 7,604,898 8,117,662 8,116,662 (1,OC 677 UNEMPLOYMENT 283,000 254,479 283,000 283,000 678 WORKER COMPENSATION 4,342,247 4,333,211 4,342,247 4,332,247 (10,OC 679 INFORMATION TECHNOLOGY 4,333,393 4,138,743 4,333,393 4,309,126 (24,2E GRAND TOTAL 201,868,232 202,947,093 199,369,527 210,856,598 11,487,01 Packet Pg. 617 CITY OF SAN BERNARDINO 3.A.b GENERAL FUND REVENUE DETAIL REPORT SCHED PRELIMINARY BUDGET 2012-13&2013-14 ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 DESCRIPTION 2012-13 2013-2014 2013-2014 2013-2014 2013-2014 PROPERTY TAXES 4001 Current Secured $ 8,678,432 $ 9,078,226 $ 9,078,226 $ 528,084 $ 9,606,310 4002 Current Unsecured 388,987 591,600 591,600 (172,743) 418,857 4003 Prior Taxes 161,406 297,840 297,840 97,840) 200,000 4004 Prior Unsecured 6,393 9,996 9,996 9,996 4005 Property Tax Other 150,871 150,000 150,000 150,000 4006 Supplemental 163,341 156,000 156,000 - 156,000 4009 Negotiated Pass Thru of RDTvIVDA 806,421 231,150 231,150 1,155,702 1,386,852 4010 Residual Balance of RDA/IVDA 330,069 - 931,935 931,935 4011 Statutory Pass Thru of RDA/IVDA 711,825 - 246,000 246,000 4007 Prop Tax In Lieu of VLF 15,746,874 15,915,366 15,915,366 413,334 16,328,700 Q 4121-4126 Other Property Taxes 156,006 1 68,288 68,288 O Total Taxes 1 $ 27,300,625 $ 26,430,178 $ $ 26,430,178 1 $ 3,072,760 1 $ 29,502,938 =u) Y OTHER TAXES 0 4201-4214 Franchise Tax $ 2,917,410 $ 2,880,700 $ 2,880,700 $ 18,300 $ 2,899,000 3 4215 Tow Franchise 428,415 495,600 495,600 (95,600) 400,000 y 4220 Prop Tax In Lieu Sales Tax 7,010,874 7,151,091 7,151,091 104,026 7,255,117 4221 Sales Tax 20,519,428 20,513,753 20,513,753 1,159,534 21,673,287 4222 Transient Occupancy 2,921,980 2,600,000 2,600,000 - 2,600,000 4223 Property Transfer Tax 437,386 400,000 400,000 400,000 4224 Utility User Tax 22,468,359 22,500,000 22,500,000 - 22,500,000 3 4225 Sales Tax Public Safety 943,067 937,125 937,125 59,696 996,821 CO 4227 Measure Z-District Tax 6,806,870 6,694,800 6,694,800 305,200 7,000,000 L Total Taxes $ 64,453,790 $ 64,173,069 $ $ 64,173,069 $ 1,551,156 $ 65,724,225 } LICENSES AND PERMITS 4301 Business Registration $ 6,353,807 $ 6,514,500 $ 6,514,500 $ $ 6,514,500 4303 Misc City Clerk Permits 2,419 5,000 51000 5,000 M 4304 Misc Planning Permits 17,527 27,000 27,000 27,000 4330 Building Permits 787,018 525,000 525,000 525,000 4331 Mechanical Permits 194,590 160,000 160,000 160,000 N 4332-3 Mobile Home Park Permit 3,459 55,400 55,400 55,400 `- 4335-6 Fire Code Permits 302,826 264,000 264,000 264,000 rn 4337 Fire Plan Check 143,573 100,000 100,000 20,000 120,000 .O 4339-42 EMS Membership 9,783 6,000 6,000 - 6,000 m 4351 Street Cut Permits 185,745 320,000 320,000 95,000 415,000 4352 Misc Licenses&Permits 339,052 350,000 350,000 - 350,000 E 4353 Yard Sales Permit Fee 4360 Grading Permits 11,278 10,000 10,000 10,000 *' W 4361 Construction Permits 49,663 70,500 70,500 - 70,500 0 4362 On Site Inspection Fees 502,466 200,000 200,000 374,251 574,251 4363 On Site Plan Check 176,750 78,000 78,000 150,000 228,000 m Total License&Permit $ 9,079,955 $ 8,685,400 $ 8,685,400 $ 639,251 1 $ 9,324,651 to m FINES AND PENALTIES 4401 Unauthorized Sign Fine 0 0 0 0 4410 General Fines $ 57,345 $ 99,000 $ 99,000 $ (9,000) $ 90,000 :-7 4411 Code Admin Citations 185,970 200,000 200,000 200,000 4412 Fire Admin Citations 11,904 10,900 10,900 10,900 4420 Parking Citations 597,282 1,100,000 1,100,000 (315,000) 785,000 t 4422 Fireworks Admin Civil Penalty 3,590 4,000 4,000 4,000 v 4423 General Admin Civil Penalty 669,567 586,000 586,000 586,000 Q 4424-5 Police Admin Civil Penalty 10,313 75,000 75,000 (61,000) 14,000 4426 Building Admin Civil Pen 22,500 5,500 5,500 5,500 4427 Fire Admin Civil Penalty 52,489 35,000 35,000 - 35,000 4428 Code Admin Civil Penalty 116,520 240,800 240,800 1 34,200 275,000 4429 General Administrative Cites 16,205 6,002 6,002 Total Fines/Penalties $ 1,743,683 1 $ 2,356,200 $ 2,356,200 1 $ (344,798)1 $ 2,011,402 USE OF MONEY AND PROPERTY 4505-09 Interest Earnings $ - $ $ - 4520 Land&Building Rental 526,781 530,000 530,000 530,000 4523 ATS Land Rental 87,573 77,000 77,000 77,000 4530 Parking Rental Fee 660 - 4540 Vending Machine Comm. 26,943 31,000 31,000 31,000 4922-26 Sale of Property 1,243 Packet Pg.618 CITY OF SAN BERNARDINO 3.A.b GENERAL FUND REVENUE DETAIL REPORT SCHED PRELIMINARY BUDGET 2012-13&2013-14 ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 DESCRIPTION 2012-13 2013-2014 2013-2014 2013-2014 2013-2014 Total Money&Property $ 643,200 $ 638,000 $ 638,000 $ $ 638,000 INTERGOVERNMENTAL 4603 Motor Vehicle In Lieu $ 198,720 $ - $ - $ - 4606 Homeowner's Exemption 122,794 132,925 132,925 18,364) 114,561 4615 Disaster Prep. Program - 41,600 41,600 (41,600) - 4616 POST 27,685 75,000 75,000 (40,000) 35,000 4619 Mutual Aid/Disaster Reimb. 600,123 300,000 300,000 300,000 600,000 4622 ICEMA Medical Supply Reimbursement 33,608 - - 9,651 9,651 4625 State-Mandated Costs 96,963 300,000 300,000 (232,559) 67,441 4651 Construction Reimb. - Q 4652 Pers Credit C s 4670 EDA&CDBG Reimb. 58,340 m 4671 SBIAA Reimbursement 139,617 145,000 145,000 177,117 322,117 C 4673 Water Reimbursement 1 592,400 1 592,400 1 1 592,400 - 592,400 4695 Recoverable Expense Income - Totallntergovernmental $ 1,870,250 $ 1,586,925 $ 1,586,925 $ 154,245 $ 1,741,170 y CHARGES FOR SERVICE tY 4305 Annual Alarm Permits $ 188,450 $ 200,000 $ 200,000 $ - $ 200,000 +� d 4701 Election Filing Fee - 20,000 20,000 52,049 72,049 4702 County Contract 487,000 487,000 487,000 - 487,000 4705 Utility Collection Fee - m 4707 Passport Fees 4,054 60,000 60,000 (60,000) - 4708 Fire Training Agreement 48,976 44,200 44,200 44,200 a) 4709 Hazardous Material Fee 1,185 10,000 10,000 (10,000) } 4710 Misc Planning/Building Planning/Building 71,529 60,000 60,000 60,000 4711 PW Subdivision File Fee 50,597 40,000 40,000 40,000 4714 Planning Develp Project 294,265 220,000 220,000 220,000 M 4715 CD Technology Fee 71,758 60,000 60,000 60,000 4718 Environmental - 4720 Plan Review Fee 123,024 100,000 100,000 100,000 N 4731 Plan Check Fee 346,470 200,000 200,000 200,000 4733 Prop/Building Abatements 747,103 600,000 600,000 600,000 y 4735 Release Notice of Pendency 9,720 12,000 12,000 12,000 2 4743 PD Towing Release Fee 429,938 385,000 385,000 385,000 m 4745 Code Tow Release Fee 230 1,400 1,400 1,400 £ 4747 False Alarm Fee 101,522 60,000 60,000 60,000 E 4752 Fireworks Regulatory Fee 66,226 62,800 62,800 - 62,800 cn 4753 Fire Archival Fee 4,069 1,500 1,500 1,500 3,000 d 4754 Fire Business Occup Insp 42,410 40,000 40,000 - 40,000 ,0) 4755 Fire Rental Inspections 558,577 550,000 550,000 550,000 4766 Building Permit Review (1,070) 52,000 52,000 52,000 m 4767 Single Family Rental Insp 132,423 430,000 430,000 230,000 200,000 c`C 4768 Adm Cites-SFRIP 99,458 98,000 98,000 98,000 4770 Crime-free Rental Housing 25,150 56,000 56,000 56,000 .a 4779 Blanket Inspection Fee 40,299 34,100 34,100 34,100 4780 Misc Develop Servs Chr s 30,244 40,000 40,000 - 40,000 4784 Plan Subdivision File Fee 1,000 1,000 C 4785 Non Subdivision Str Imp 55,000 55,000 - 55,000 m 4786 Certificate of Completion 2,000 2,000 2,000 s 4789 Archival Fee-Devel Servs 25,547 22,000 22,000 22,000 4795 Signal Maint/Energy 29,287 5,500 5,500 5,500 Q 4798 Storm Drain Utility Fee 252,013 237,000 237,000 237,000 4799 NPDES Bus Inspection 19,031 28,000 28,000 28,000 4802 Str Light Energy Fee - 4810 Misc.Development Services 5,000 5,000 5,000 4815 Weed Abatement 185,575 202,200 202,200 116,644 85,556 4861 Program/Facility Program/Facility Use Fee 57,971 85,000 85,000 85,000 4862 Park Energy Fee 350 6,000 6,000 6,000 4863 Class Registration Fee 1,105 8,500 8,500 8,500 4864 Swimming Pool Fee 75,279 70,000 70,000 70,000 4865 Non-Resident Fees 1,693 1,000 1,000 1,000 4880 EMS User Fee 311,234 300,000 300,000 300,000 4881 Paramedic Reimb Contract 111,624 - Total Charges $ 5,044,315 $ 4,951,200 $ 4,951,200 $ (362,095) $ 4,589,105 Packet Pg.619 CITY OF SAN BERNARDINO 3.A.b GENERAL FUND REVENUE DETAIL REPORT SCHED PRELIMINARY BUDGET 2012-13&2013-14 ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 DESCRIPTION 2012-13 2013-2014 2013-2014 2013-2014 2013-2014 MISCELLANEOUS 4722 C&D Application Fee $ 3,869 $ $ 1,938 $ 1,938 4734 CDBG Demolition 253,630 39,650 39,650 4740 Police Misc. Receipt 917,560 900,000 900,000 (200,000) 700,000 4741 Sale of Photos/Reports 1,203 12,000 12,000 12,000 4742 Pistol Range Fees 80,369 100,000 100,000 100,000 4744 Fingerprint Fee 3,818 5,000 5,000 5,000 4746 Property Auction 6,071 5,000 5,000 5,000 4748 Vehicle Repossession Fee 4,843 4,500 4,500 - 4,500 4749 Crime Prevention Revenue 639 300 300 4750 Investigation Fee 32,230 45,000 45,000 - 45,000 p 4769 Payoff Demand Fee 10,296 - - C 4781 Plan Check Fee-Engineering 42,505 50,000 50,000 50,000 Y 4782 Street Knockdown - C 4901 Misc.Other Revenue 172,964 350,000 350,000 350,000 4903 Refunds and Rebates 90,885 1,500 1,500 1,500 4904 Drunk Driver Reimburmt. - (D 4905 Litigation Settlement 10,000 10,000 - 10,000 5 4906 Water Fund Contribution 3,261,400 3,261,400 3,261,400 336,544 3,597,944 4909 Returned Check Charge 904 - - - �. 4910 Admin Service Charge 367,600 367,600 367,600 m iM 4911 Restitutions 9,808 20,000 20,000 20,000 0 4912 Off Track Betting 74,054 90,000 90,000 90,000 m 4913 Route 66 Rendevous 35,593 - 4924 Damage Claim Recovery 60,360 80,000 112,844 192,844 192,844 d 4926 CID Reimburmt - } 4928 Booking Fee Reimburmt. 20 2,000 2,000 2,000 4930 Sewer Contr.-Water 500,000 500,000 500,000 4931 Water Land Sales - 4933 Hazmat Incident Recovery 3,740 99,200 99,200 98,200 1,000 c") o� 4937 Street Knockdown 34,604 1 11,000 1 11,000 11,000 Total Miscellaneous $ 5,101,365 $ 5,914,200 $ 112,844 $ 6,027,044 $ 80,232 $ 6,107,276 N r TOTAL GENERAL FUND $ 115,237,183 $ 114,735,172 $ 112,844 $114,848,016 $ 4,790,751 $ 119,638,767 > N N L (Q E E U) r d 3 m L d C� C CD G V Q Packet Pg.620 CITY OF SAN BERNARDINO SCHED 3.A.b OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DESCRIPTION ACTUALS I ADOPTED BUDGET AMENDED JPROPOSED PROPOSEI 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENT 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 Unaudited 004 FEMA(2) 4619 State/County Disaster Reimbursement Is I $ Is Is Total FEMA Reimbursements $ is _is $ 105 LIBRARY 4505 Interest on Idle Cash` $ - $ $ 100 $ $ 10( 4698 Donations - 10,000 10,00( 4850 Miscellaneous Receipts 15,101 11,000 11,000 - 11,00( Q 4851 Library Fines 19,126 21,000 21,000 - 21,00( p 4901 Miscellaneous Other Receipts 32 37,200 37,200 1 (36,200) 1,00( N Total Library $ 34,2591 $ 69,200 $ - $ 69,3001$ (26,200)1 $ 43,10( Y O 106 CEMETERY 4505 Interest on Idle Cash' $ (59) $ 50 $ 50 $ $ 5( 4775 Cemetery Burial Fee 8,182 10,000 10,000 10,00( 4776 Sale of Vases 170 500 500 50( 4777 Sale Concrete Boxes 2,748 3,500 3,500 1,500 5,00( 4778 Sale Cemetery Plots 8061 500 500 500 1,00( 4901 Misce Receipts(Transfer from Cemetery Trust) - _ - Total Cemetery $ 11,847 $ 14,550 $ 14,550 $ 2,000 $ 16,55( m L 107 CAN } 4205 PEG Fee Revenue $ 279,585 $ 227,885 $ (16,317) $ 211,568 $ $ 211,561 '0 4699 Program Income (3) 38,710 $ 38,710 $ 38,71( �E 4901 Miscellaneous Other Receipts 2,970 12,000 $ 12,000 $ 12,00( Total Asset Forfeiture $ 282,552 $ 227,885 $ 34,393 $ 262,278 $ $ 262,271 c i 108 FEDERAL ASSET FORFEITURE 4505 Interest on Idle Cash' $ (96) $ 5,000 $ 5,000 $ $ 5,00( T 4672 Asset Forfeiture/Federal DOJ 322,274 450,000 450,000 0 450,00( y 4675 Asset Seizure-Federal Tre 82,371 0 0 0 ( m 4927 Asset Forfeiture 111,457 350,000 350,000 (200,000) 150,00( Total Asset Forfeiture $ 516,007 $ 805,00-01 1 $ 805,0001 $ (200,000) $ 605,00( E E 111 AIR QUALITY-AB 2766 4505 Interest on Idle Cash' $ (6) $ _ $ $ 4626 Rideshare Reimbursement 255,864 250,000 250,000 0 250,00( -a 4906 Water Department 5,200 5,200 5,200 0 5,20( Total Air Quality-AB 2766 $ 261,057 $ 255,200 $ 255,200 $ - $ 255,20( m m 116 EMERGENCY SHELTER GRANT(2) � 4505 Interest on Idle Cash' $ _ $ $ $ 4695 Recoverable Expense Income 259,000 259,000 1 259,00( Total Emergency Solutions $ 259,000 $ 259,000 $ - $ 259,00( C d 117 HOME PART INVESTMENT ACT(2) 1 1 E 4699 Program Income $ 404 $ $ $ $ v 4695 Recoverable Expense Income 2,400,000 2,400,000 2,400,00( Total HOME Grant $ 404 $ 2,400,000 $ 2,400,000 $ - $ 2,400,001 Q 118 DRUG/GANG 4505 Interest on Idle Cash` $ (13) $ 300 $ 300 $ $ 30( 4929 Asset Forfeiture-Drug/Gang 19,492 30,000 30,000 30,00( Total Drug/Gang $ 19,478 $ 30,300 $ 30,300 $ - $ 30,30( 119 CDBG(2) 4505 Interest on Idle Cash' $ $ - $ 35,847 $ 35,84; 4695 Recoverable Expense Income-leave it and res 1,697,127 2,811,900 2,811,900 - 2,811,90( Total CDBG $ 1,697,127 $ 2,811,900 $ 2,811,900 $ 35,847 $ 2,847,74; Packet Pg. 621 CITY OF SAN BERNARDINO $.A.b OTHER FUNDS REVENUE REPORT SCHED FISCAL YEARS 2012-2013&2013-2014 DESCRIPTION ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSE[ 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENT 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 120 NEIGHBORHOOD STABILIZATION 4505 Interest on Idle Cash* $ - $ - $ $ 4695 Recoverable Expense Income 2,120,000 2,120,000 2,120,00( Total NEIGHBORHOOD STABILIZATION $ - $ 2,120,000 $ 2,120,000 $ -t$ 2,120,00( 121 SBETA(2) 4505 Interest on Idle Cash` I Is Is $ Is 4695 Recoverable Expense Income 1 5,294,8701 2,678,9651 506,4991 3,185,4641 1 3,185,46, To 123 GRANTS FUND(2) CL 4505 Interest on Idle Cash* $ $ _ $ N 4695 Recoverable Expense Income 9,629,715 2,720,386 1,888,688 4,609,074 4,609,07, 4696 Recoverable Revenue 198,561 0 4697 Credit NSIP Reimb Revenue 27,903 3 4698 Grant Donations 4699 Program Income j Total Grants Fund $ 9,856,179 $ 2,720,386 $ 1,888,688 $ 4,609,074 $ - $ 4,609,07, r 124 ANIMAL CONTROL 4,525,674 4320 Animal License $ 228,071 $ 250,000 $ 250,000 $ $ 250,00( 3 4352 Miscellaneous License&Permits 2,400 1,000 1,000 1,00( m 4410 General Fines 37,077 30,000 30,000 30,00( 4430 Animal License Penalty 32,060 30,000 30,000 30,00( } 4756 Animal Adoption Fee 72,544 40,000 40,000 40,00( 'C 4757 Contracted Shelter Fee 960,594 967,000 967,000 967,00( 4759 Apprehension Fee 21,745 20,000 20,000 20,00( 4760 Board Fee 40,102 20,000 20,000 20,00( <") 4761 Field Service Fee 200 2,000 2,000 2,00( N_ 4763 Owner Release Fee 17,288 20,000 20,000 20,00( N 4764 Vaccination Fee 23,675 12,000 12,000 12,00( T- 4765 Microchip Fee 26,720 25,000 25,000 25,00( N 4901 Miscellaneous Receipts 4,047 500 500 50( 4922 Sale of Equipment Total Animal Control $ 1,466,523 $ 1,417,500 $ 1,417,500 $ - $ 1,417,50( E E 126 SPECIAL GAS TAX 3 4505 Interest on Idle Cash* $ 26) $ 3,000 $ 3,000 $ $ 3,00( y 4602 HUTA Prop42 Replacement 1,662,967 2,996,044 2,996,044 (143,384) 2,852,66( -� 4607 HUTA R&T 7360 _ 4610 State Aid-2106 662,757 660,323 660,323 138,810 799,11 m 4611 State Aid-2107 1,500,757 1,472,222 1,472,222 (217,989) 1,254,23: 4612 State Aid-2107.5 10,000 10,000 10,000 - 10,00( ) 4614 Prop 111-Highway Users Tax 915,857 998,840 998,840 21,781 1,020,62' 4945 Reimbursement Total Special Gas Tax $ 4,752,312 $ 6,140,4291 1 $ 6,140,429 1 $ (200,782) $ 5,939,64; d 128 TRAFFIC SAFETY E 4440 CVC Fine $ 583,704 $ 780,000 $ 780,000 $ (280,000) $ 500,00( v 4441 Nester Red Lights 276,674 - 14,489 14,485 Total Traffic Safety $ 860,378 $ 780,000 $ 780,000 $ (265,511) $ 514,485 Q 129 1/2 CENT SALES&ROAD TAX 4505 Interest on Idle Cash* $ (402) $ 2,000 $ 2,000 $ $ 2,00( 4613 1/2 Cent Sales Tax 3,016,199 2,995,716 2,995,716 2,995,71E 4630 State Aid Street Construction 4945 Construction Reimbursement Total 1/2 Cent Sales/Road Tax $ 3,015,796 $ 2,997,716 $ 2,997,716 $ - $ 2,997,71E 132 SEWER LINE MAINTENANCE 4505 Interest on Idle Cash* $ 4,491 $ 7,500 1 Is 7,500 1 $ $ 7,50( 4820 Sewer Line Maintenance 3,180,8481 3,200,000 1 1 3,200,000 1 3,200,00( 4903 Refunds and Rebates Packet Pg.622 CITY OF SAN BERNARDINO SCHED 3.A.b OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DESCRIPTION ACTUALS ADOPTED BUDGET I AMENDED PROPOSED PROPOSE[ 2012-2013 BUDGET AMENDMENTS1 BUDGET JADJUSTMENT 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 Total Sewer Line Maintenance $ 3,185,339 $ 3,207,500 $ 3,207,500 $ - $ 3,207,50( 133 BASEBALL STADIUM 4505 Interest on Idle Cash* $ $ _ $ $ 4924 Damage Claim Recovery 4901 Baseball Team Lease Agreement Total Baseball Stadium $ - $ _ $ _ $ 134 SOCCER FIELD COMPLEX 4505 Interest on Idle Cash* $ (37) $ 2,000 $ 2,000 $ $ 2,00( Q. 4520 Land&Building Rental 128,183 125,000 125,000 125,00( p 4528 Sponsorships 250 - - _ v! 4530 Rental Fee-Parking 157,480 180,000 180,000 180,00( Y 4861 Program&Facilities Fee 76,314 75,000 75,000 75,00( 4862 Park Energy Fee 788 4,000 4,000 4,00( 3 4901 Miscellaneous Other Revenue 20,423 15,000 15,000 15,00( Total Soccer Fields $ 383,400 $ 401,000 $ 401,0001 $ 401,00( > d 135 TRAFFIC CONGESTION(1) 4505 Interest on Idle Cash* $ $ $ $ 4635 Traffic Congestion Relief 3 4903 Refunds/Rebates m Total Prop 42 Traffic Congestion $ $ _ d 137 CFD 1033-FIRE STATION M&O p 4505 Interest on Idle Cash* 591,251 4115 CFD 1033 Special Tax $ (43) $ 585,600 $ 585,600 $ $ 585,60( " Total CFD 1033-Fire Station 591, 09 7----5r5,70-0 585,604x rn 208 VERDEMONT INFRASTRUCTURE N 4505 Interest on Idle Cash* $ (32) $ $ $ $ r 4512 Verdemont Infrastructure Fee to Total Verdemont Improvement $ (32)1 $ Is - is -is y ca 211 TRIBAL FIRE AGREEMENT 01 E 4505 Interest on Idle Cash* $ $ $ $ 3 4824 Impact Fee _ _ _ N Total Fire Equipment Acquisition $ $ - $ $ $ 240 INFRASTRUCTURE LOAN(1) Is is $ $ m 242 STREET CONSTRUCTION i`a 4901 Miscellaneous Receipts/Refunds/Rebates $ $ $ $ } 4630 State Aid-Street Construction 2 4658 Federal Aid-FAU 989,732 2,212,300 2,212,300 2,212,30( 4670 EDA Reimbursement _ r 4671 IVDA Reimbursement d 4677 Local Stimulus SANBAG E 4945 Construction Reimbursement/Miscellaneous v Total Street Construction $ 989,7321$ 2,212,300 1 $ 2,212,300 $ Q 243 PARK CONSTRUCTION(1) 4505 Interest on Idle Cash* $ 73 $ - $ _ $ - $ 4620 State Aid Park Development 1,200,000 1,200,00( 4651 Construction Reimbursement 4670 Successor Agency/San Bernardino 4732 Park Development Fee Total Park Construction $ (73) $ - $ - $ 1,200,000 $ 1,200,00( 244 CEMETERY CONSTRUCTION 4505 Interest on Idle Cash* I $ (7) $ $ $ - $ 4778 Sale Cemetery Plots - Total Cemetery Construction $ (7) $ $ $ $ Packet Pg.623 CITY OF SAN BERNARDINO SCHED 3.A.b OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DESCRIPTION ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSE( 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENT 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 245 SEWER LINE CONSTRUCTION 4505 Interest on Idle Cash* $ 4,359 $ 2,000 $ 2,000 $ $ 2,00( 4651 Construction Reimbursement 4821 Sewer Lateral Fee 4822 Sewer Connection Fee 265,934 100,000 100,000 150,000 250,00( Total Sewer Line Construction $ 270,293 $ 102,000 $ 102,000 $ 150,000 $ 252,00( 246 PUBLIC IMPROVEMENT 4505 Interest on Idle Cash* $ (140) $ 8,000 $ 8,000 $ $ 8,00( 4902 Contribution O. O Total Public Improvement Construction $ (140) $ 8,000 $ 8,000 $ $ 8,00( N Y 247 CULTURAL DEVELOPMENT `O 4505 Interest on Idle Cash* $ (60)1 $ 1,000 $ 1,000 $ $ 1,00( 4335 Cultural Development Construction Fee 1 747,2681 250,000 1 250,000 500,000 750,001 m Total Cultural Development Construction $ 747,208 1 $ 251,0001 $ 251,000 $ 500,000 $ 751,00( '> m 248 STORM DRAIN CONSTRUCTION 4505 Interest on Idle Cash* $ (382) $ 1,000 $ 1,000 $ $ 1,001 4651 Construction Reimbursement 3 4819 Area Drainage Plan Fee - m 4818 Storm Drain Fee 928,519 275,000 275,000 (175,000) 100,001 R Total Storm Drain Construction $ 928,1371$ 276,0001 1 $ 276,000 $ (175,000) $ 101,00( >.. 250 TRAFFIC SYSTEM CONST(1) 4505 Interest on Idle Cash* $ $ $ $ 4630 State Aid Street Construction M 4658 Fed Aid Street Construction - - - N 4803 Traffic System Fees 4945 Construction Reimbursement N Total Traffic Systems Construction $ $ _ $ _ $ > U) d 254 LANDSCAPE MAINT DISTRICT(1) 2 4505 Interest on Idle Cash* $ (228) $ 200 1 1 $ 200 $ $ 20( E 4115 Revenue for All ADS 1,329,1621 1,277,698 1,277,698 1,277,691 E Total Landscape Districts $ 1,328,9341 $ 1,277,898 $ - $ 1,277,898 $ - $ 1,277,891 r m 258 PROPOSITION 1B p� 4505 Interest on Idle Cash* _ _ _ � 4628 Pro 1 B Revenue $ $ $ $ m 4945 Construction Reimbursement Total PROP 1 B $ _ $ _ $ $ 261 LAW ENFORCEMENT DEVELOPMENT 4505 Interest on Idle Cash* L$ ��5 (22) $ 750 $ 750 $ $ 75( c 4824 Development Impact Fees 9,146 40,000 40,000 40,00( d Total Law Enforcement Impact Fee 9,125 $ 40,750 $ - $ 40,750 $ - $ 40,75( L v 262 FIRE PROTECTION DEVELOPMENT 4505 Interest on Idle Cash* $ (36) $ 250 $ 250 $ 5,086 $ 5,33E Q 4824 Development Impact Fees 54,727 - _ 4901 Miscellaneous Receipts Total Fire Protection Impact Fee $ 54,691 $ 250 $ - $ 250 $ 5,086 $ 5,33E 263 LOCAL CIRCULATION SYSTEM 4505 Interest on Idle Cash* $ (68) $ 200 $ 200 $ (200) 4824 Development Impact Fees 209,268 131,505 131,50! Total Local Circulation Impact Fee $ 209,200 $ 200 $ 200 $ 131,305 $ 131,50: 264 REGIONAL CIRCULATION SYSTEM 4505 Interest on Idle Cash* $ (779) $ 10,000 $ 10,000 $ - $ 10,00( 4824 Development Impact Fees 1,435,164 1,700,000 1,700,00( Packet Pg.624 CITY OF SAN BERNARDINO SCHED 3 a.b OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DESCRIPTION ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSE[ 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENT 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 4901 Miscellaneous Receipts-Loan Repayment - _ - Total Regional Circulation Impact Fee $ 1,434,384 $ 10,000 $ $ 10,000 $ 1,700,000 $ 1,710,00( 265 LIBRARY FACILITIES 4505 Interest on Idle Cash* (1) _ 4824 Development Impact Fees 638 Total Library Facilities Impact Fee $ 637 1 $ - $ - $ - $ $ 266 PUBLIC MEETINGS FACILITIES 4505 Interest on Idle Cash* I $ (48)1 $ 3,500 1 $ 3,500 $ - $ 3,50( a 4824 Development Impact Fees 1 1,090 1,090 1,09( p Total Public Meetings Facilities Impact Fee $ 1,0421 $ 3,500 $ $ 3,500 1 $ 1,0901 $ 4,591 N Y 267 AQUATICS CENTER FACILITIES O 4505 Interest on Idle Cash* $ (15) $ 1,200 $ 1,200 $ $ 1,20( 4824 Development Impact Fees 358 - - Total Aquatics Center Impact Fee $ 344 $ 1,200 $ $ 1,200 $ $ 1,20( > d d' 268 AB 1600 PARKLAND 4505 Interest on Idle Cash* $ $ $ $ p� 4824 Development Impact Fees 3,620 3,62( Total AB 1600 Parkland Impact Fee is - $ $ - $ 3,6201 $ 3,62( m L R 269 QUIMBY ACT PARKLAND d } 4505 Interest on Idle Cash* $ (200) $ 600 $ 600 $ $ 60( 'O 4824 Development Impact Fees 8,044 - _ Total Quimby Act Parkland Impact Fee $ 7,845 $ 600 $ - $ 600 $ $ 60( M 305 AD 985 INDUSTRIAL PARKWAY(1) 4505 Interest on Idle Cash* $ $ $ $ N 4115 Revenue as from Assessments Districts Total AD 985 Industrial Parkway $ _ $ $ $ _ $ U) 'L 306 AD 987 DEBT SERVICE E 4505 Interest on Idle Cash* $ $ $ $ E 4115 Revenue as from Assessments Districts 51,400 51,400 (51,400) to Total AD 987 Debt Service $ 51,400 $ - $ 51,400 $ (51,400) $ m 311 FIRE STATION DS 4505 Interest on Idle Cash* $ $ $ $ m 4115 Revenue as from Assessments Districts e`o Total Fire Station DS $ _ $ _ $ _ $ $ 356 AD 1015 NEW PINE AVE 4505 Interest on Idle Cash* $ $ $ $ 4115 Revenue as from Assessments Districts 64,858 1 68,000 1 68,000 68,00( 44) Total AD 1015 New Pine Ave. $ 64,858 1 $ 68,000 $ $ 68,000 $ - $ 68,00( E v 527 REFUSE 4505 Interest on Idle Cash* $ - $ 20,000 $ 20,000 $ $ 20,00( Q 4830 Commercial Rubbish 4831 Commercial Bin Rent (203) 400 400 40( 4832 Commercial Bin Service 4,083,039 3,750,000 3,750,000 150,000 3,900,00( 4833 Commercial Special 122,744 126,000 126,000 126,00( 4837 Automated Commercial Rubbish 5,778,089 4,565,900 4,565,900 1,134,100 5,700,00( 4840 Residential Water Billed 11,680,222 13,712,200 13,712,200 (2,112,200) 11,600,00( 4841 Residential"B"Accounts (197) 400 400 - 40l 4843 Dino Bin Service 3,020,901 2,500,000 2,500,000 300,000 2,800,00( 4844 Commercial Penalties 4845 Residential Penalties 4846 Recycling Receipts 224,518 160,700 160,700 6,300 167,00( 4901 Miscellaneous Other Revenue 91,476 351,000 351,000 - 351,00(, 4922 Sale Salvage Matter Packet Pg. 625 CITY OF SAN BERNARDINO SCHED 3.A.b OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013 8,2013-2014 DESCRIPTION ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSE[ 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENT 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 Total Refuse $ 25,000,590 $ 25,186,600 $ $ 25,186,600 $ (521,800) $24,664,80( 621 CENTRAL SERVICES $ 65,868 1 $ 149,171 1 is 149,171 $ $ 149,17' 629 LIABILITY 4505 Interest on Idle Cash' $ (374) $ - $ _ $ $ 4670 Successor Agency/San Bernardino 4897 Interdepartmental Receipts 3,137,946 3,146,277 3,146,277 3,146,27; Total Liability Insurance $ 3,137,572 $ 3,146,277 $ - $ 3,146,277 $ - $ 3,146,27; 630 TELEPHONE SUPPORT C 4893 Water Department Receipts $ 154,630 $ 154,630 $ 154,630 $ $ 154,67( N 4673 Water Reimbursement 9,079 �C 4670 Successor Agency/San Bernardino 7,000 7,000 (7,000) O 4897 Interdepartmental Receipts 910,860 974,561 974,561 974,56 4901/4903 Miscellaneous/SBETA/Assessment Distric 2,728 9,000 9,000 g,pp( Total Telephone Support $ 1,077,297 $ 1,145,191 $ - $ 1,145,191 $ (7,000)L$ l:,l 3 8,19' '> a> 631 UTILITY 4893 Water Department Receipts $ $ $ $ 4897 Interdepartmental Receipts 3,772,646 3,705,585 3,705,585 1,907,808 5,613,39: 3 4903 Misc/Assessment Districts/LED Reimb _ m Total Utility $ 3,772,646 $ 3,705,585 $ - $ 3,705,585 $ 1,907,808 $ 5,613,39: m 635 FLEET SERVICES .� 4670 Successor Agency/San Bernardino $ - $ 1,000 $ 1,000 $ (1,000) 4897 Interdepartmental Receipts 6,759,731 7,666,662 7,666,662 7,666,66; 4901 Misc/Assessment Districts/SBETA - 50,000 50,000 50,00( th 4903 Refunds/Rebates 845,167 400,000 400,000 400,00( N Total Fleet Services $ 7,604,898 $ 8,117,662 $ - $ 8,117,662 7-(1,000)l $ 8,116,66: N 677 UNEMPLOYMENT j 4899 Premiums $ 254.478 $ 283,000 $ 283,000 $ $ 283,00( ayi Total Workers'Compensation $ 254,478 $ 283,000 $ - $ 283,000 $ - $ 283,00( R 678 WORKER COMPENSATION E 4897 Interdepartmental Receipts $ 3,921,210 $ 3,920,247 $ 3,920,247 $ $ 3,920,24; fn 4906 Water Department 412,000 412,000 412,000 0 412,00( m 4670 Successor A ency/San Bernardino 0 10,000 10,000 (10,000) Total Workers'Compensation $ 4,333,210 $ 4,342,247 $ - $ 4,342,247 $ (10,00M T4,332,24 4,332,24; m 679 INFORMATION TECHNOLOGY 4670 Successor Agency/San Bernardino $ 24,267 $ 24,267 $ (24,267) 4673 Water Reimbursement 411,006 522,267 522,267 0 522,26; a 4897 Interdepartmental Receipts 3,724,153 3,767,659 3,767,659 0 3,767,651 4901 Miscellaneous/SBETA/SANCAT/IVDA 3,594 19,200 19,200 0 19,20( Total Information Technology $ 4,138,753 $ 4,333,393 $ -, $ 4,333,393 $ (2-4-267)l $ 4,309,12E GRAND TOTAL $ 87,710,228 $ 84,634,355 $ 2,429,580 $ 87,064,035 $ 4,153,796 1 $91,217,83' Q Packet Pg.626 CITY OF SAN BERNARDINO SCHED 3.A.b HISTORICAL and PROPOSED SUMMARY OF EXPENDITURES BY FUND/DEPARTMENT FY 2012-13 THROUGH FY 2013-14 ADOPTED ACTUALS ADOPTED PROPOSED VARIANCE DESCRIPTION 2012-13 2012-2013 2013-14 2013-14 2013-14 Unaudited GENERAL FUND: Mayor $ 594,479 $ 535,217 $ 495,580 $ 495,580 $ Common Council 662,230 557,046 628,683 628,683 $ - City Clerk 1,021,179 1,195,113 1,495,371 1,849,123 $ 353,752 City Treasurer 221,176 205,747 214,456 214,456 $ - City Attorney 3,555,328 2,727,548 3,461,920 3,327,308 $ (134,612 Code Compliance _ _ $ General Government 4,238,350 5,134,614 3,843,555 7,239,723 $ 3,396,168 Debt Service 1,758,500 922,749 1,758,500 5,208,589 $ 3,450,089 City Manager 1,116,136 645,282 1,065,200 1,065,200 $ - p Human Resources 511,313 470,607 498,379 538,474 $ 40,095 Finance 1,262,926 1,482,255 1,771,286 1,771,286 $ Y Civil Service 399,097 349,835 387,559 445,539 $ 57,980 p Community Development 6,879,435 4,517,647 3,799,650 3,047,601 $ (752,049 Development Services _ _ $ 3 Fire 31,712,999 29,408,382 30,078,535 30,413,324 $ 334,789 m Police 55,670,857 57,071,129 54,956,081 56,751,837 $ 1,795,756 Facilites Management - $ w Parks, Rec.&Comm.Svcs. 4,656,966 4,183,046 4,606,109 6,075,446 $ 1,469,337 v� Public Services _ $ Public Works 8,259,249 6,788,264 8,142,073 9,024,526 $ 882,453 CO $ 122,520,220 $ 116,194,483 $ 117,202,937 $ 128,096,695 $ 10,893,758 ML 'Part of City-Wide reorganization,Code Enforcement moved to Community DevE } Part of City-Wide reorganization,Development Services was combined with Coi 3Part of City-Wide reorganization,Facilities Management moved to Public Works °Part of City-Wide reorganization,Public Services combined with Facilities Mane ' 004 FEMA(2) $ $ $ $ 105 LIBRARY 1,757,329 1,615,048 1,716,129 1,716,129 106 CEMETERY 189,727 89,821 187,429 214,865 27,436 N 107 CABLE TV(1) 228,607 - 227,885 262,831 34,946 108 FEDERAL ASSET FORFEITURE - > 377,400 472,990 377,400 708,400 331,000 w 111 AIR QUALITY-AB 2766 129,142 91,656 125,724 125,724 116 EMERGENCY SHELTER GRANT(2) 280,971 231,124 259,000 259,000 117 HOME PART INVESTMENT ACT(2) 2,386,470 164,596 2,400,000 2,400,000 E E 118 DRUG/GANG 30,481 14,273 30,385 30,385 119 CDBG(2) 2,811,898 1,648,655 2,784,303 2,861,109 76,806 120 NEIGHBORHOOD STABLIZATION(2) 2,915,401 609,030 2,120.000 2,120,000 - pi 121 SBETA(2) 2,678,965 3,245,375 2,678,965 3,185,464 506,499 123 GRANTS FUND(2) 1,902,206 6,441,183 816,100 816,100 CO 124 ANIMAL CONTROL 2,257,980 2,014,105 2,157,003 2,277,149 120,146 d 126 SPECIAL GAS TAX 1,267,547 1,369,838 1,259,823 459,823 (800,000 128 TRAFFIC SAFETY 653,511 278,580 651,448 651,448 - C 129 1/2 CENT SALES&ROAD TAX 388,225 432,106 1,756,754 1,756,754 - 132 SEWER LINE MAINTENANCE 2,179,868 1,519,132 2,625,771 2,724,772 99,001 133 BASEBALL STADIUM 15,240 15,192 49,048 33,856 134 SOCCER FIELD COMPLEX 371,653 251,700 367,080 447,041 79,961 r 135 TRAFFIC CONGESTION(1) v 137 CFD 1033-FIRE STATION M&O 208 VERDEMONT INFRASTRUCTURE - 110,000 110,000 a 211 TRIBAL FIRE AGREEMENT 41,149 12,000 41,019 41,019 240 INFRASTRUCTURE LOAN (1) _ 242 STREET CONSTRUCTION 384,059 141,908 2,217,148 2,212,300 (4,848 243 PARK CONSTRUCTION (1) 195,536 7,511 1,584,499 1,368,233 (216,266 244 CEMETERY CONSTRUCTION 245 SEWER LINE CONSTRUCTION 60,962 85,159 331,798 331,798 246 PUBLIC IMPROVEMENT 247 CULTURAL DEVELOPMENT 248 STORM DRAIN CONSTRUCTION 148,163 95,972 1,049,191 1,049,191 250 TRAFFIC SYSTEM CONST(1) - 254 LANDSCAPE MAINT DISTRICT(1) 1,277,698 1,601,600 1,277,698 1,604,374 326,676 257 CITY WIDE ASSESSMENT DISTRICT 994 216120 Packet Pg.627 CITY OF SAN BERNARDINO HISTORICAL and PROPOSED SUMMARY OF EXPENDITURES SCHEDLIffiF BY FUND/DEPARTMENT FY 2012-13 THROUGH FY 2013-14 ADOPTED ACTUALS ADOPTED PROPOSED VARIAN DESCRIPTION 2012-13 2012-2013 2013-14 2013-14 2013-14 - 258 PROPOSITION 1B $ 2,294,932 $ 2,294,932 $ - $ 261 LAW ENFORCEMENT DEVELOPMENT 30,481 104,542 30,385 30,385 - 262 FIRE PROTECTION DEVELOPMENT 162,870 156,719 115,930 160,930 45,000 263 LOCAL CIRCULATION SYSTEM - 14,412 110,170 110,170 - 264 REGIONAL CIRCULATION SYSTEM 1,244,637 220,357 4,836,736 4,836,736 265 LIBRARY FACILITIES 43,181 3,924 43,045 43,045 266 PUBLIC MEETINGS FACILITIES - _ 267 AQUATICS CENTER FACILITIES 268 AB 1600 PARKLAND 25,400 1,999 1,095,080 1,095,080 269 QUIMBY ACT PARKLAND - 47,791 47,791 305 AD#985 DEBT SERVICE _ Q 306 AD 987 DEBT SERVICE 51,400 51,400 (51,400 t 356 AD 1015 NEW PINE AVE 68,000 11,325 68,000 68,000 In ' Y 527 REFUSE 23,670,362 21,525,978 22,754,916 21,051,590 (1,703,326 O 621 CENTRAL SERVICES 147,723 103,212 145,697 130,997 (14,700 629 LIABILITY 3,134,464 1,330,593 3,126,186 1,848,606 (1,277,580 630 TELEPHONE SUPPORT 984,319 862,107 976,510 1,017,990 41,480 631 UTILITY 3,819,335 5,238,422 3,817,966 5,725,818 1,907,852 635 FLEET SERVICES 8,614,408 5,999,878 7,673,407 7,683,184 9,777 677 UNEMPLOYMENT 265,000 433,039 1 265,000 265,000 - of 678 WORKER COMPENSATION 4,110,632 4,301,300 4,097,746 4,489,307 391,561 679 INFORMATION TECHNOLOGY 4,580,349 3,640,873 4,569,674 4,525,674 (44,000 CO GRAND TOTAL ALL FUNDS $ 200,697,900 1 $ 184,871,457 $ 199,380,220 $ 211,009,955 $ 11,629,735 M N N r y d 'C t0 7 N r d OI 7 Co lC d C t V R Q 216120 Packet Pg.628 CITY OF SAN BERNARDINO 3 A b EXPENDITURES BY CATEGORY-ALL FUNDS SCHED BY DEPARTMENT&FUND MID-YEAR 2013-2014 ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 GENERAL FUND: FUND/TITLE 2013-2014 2013-2014 2013-2014 2013-2014 010 MAYOR $ 495,580 $ 495,580 $ $ 495,581 020 COMMON COUNCIL 628,683 628,683 628,68: 030 CITY CLERK 1,495,371 250,000 1,745,371 103,752 1,849,12: 040 CITY TREASURER 214,456 214,456 214,451 050 CITYATTORNEY 3,461,920 3,461,920 (134,612) 3,327,30 090 GENERAL GOVERNMENT 3,843,555 3,843,555 3,396,168 7,239,72; 090 DEBT SERVICE 1,758,500 1,157,550 2,916,050 2,292,539 5,208,58E 100 CITY MANAGER 1,065,200 1,065,200 - 1,065,201 140 CIVIL SERVICE 387,559 57,980 445,539 - 445,53! N 110 HUMAN RESOURCES 498,379 498,379 40,095 538,47 L 120 FINANCE 1,771,286 1,771,286 1,771,281 O 180 COMMUNITY DEVELOPMENT 3,799,650 (352,595) 3,447,055 (399,454) 3,047,60 200 FIRE 30,078,535 252,959 30,331,494 81,830 30,413,32, 210 POLICE 54,956,081 1,361,710 56,317,791 434,046 56,751,83- j 380 4,606,109 1 4,606,109 1,469,337 6,075,441 400 PUBLIC WORKS 8,142,073 961,573 9,103,646 (79,120) 9,024,52( r TOTAL GENERAL FUND $117,202,937 $ 3,689,177 $ 120,892,114 $ 7,204,581 $ 128,096,69! 6) SPECIAL REVENUE FUNDS: 3 004 FEMA(2) $ $ m 105 LIBRARY 1,716,129 1,716,129 $ 1,716,12! O 106 CEMETERY 187,429 187,429 27,436 214,86! 107 CATV 227,885 34,946 262,831 262,83 108 FEDERAL ASSET FORFEITURE 377,400 341,000 718,400 (10,000) 708,401 111 AIR QUALITY-AB 2766 125,724 125,724 125,72" 116 EMERGENCY SHELTER GRANT(2) 259,000 259,000 259,001 N 117 HOME PART INVESTMENT ACT(2) 2,400,000 2,400,000 2,400,001 N 118 DRUG/GANG 30,385 30,385 30,38! T_ 119 CDBG(2) 2,784,303 76,806 y, , ,861,10! 120 NEIGHBORHOOD STABLIZATION(2) 2,120,000 2,120,000 2,120,001 •� 121 SBETA(2) 2,678,965 506,499 3,185,464 3,185,46, m 123 GRANTS FUND(2) 816,100 816,100 816,101 E 124 ANIMAL CONTROL 2,157,003 118,000 2,275,003 2,146 2,277,14! 127 LOW MOD HOUSING 128 TRAFFIC SAFETY 651,448 651,448 651,44. p� 132 SEWER LINE MAINTENANCE 2,625,771 2,625,771 99,001 2,724,77: 133 BASEBALL STADIUM 15,192 15,192 33,856 49,04 m 134 SOCCER FIELD COMPLEX 367,080 367,080 79,961 447,04 137 CFD 1033-FIRE STATION M&O 211 TRIBAL FIRE AGREEMENT 41,019 41,019 41,01! O 247 CULTURAL DEVELOPMENT TOTAL SPECIAL REVENUE FUNDS $ 18,764,733 $ 1,893,351 $ 20,658,084 $ 232,400 $ 20,890,48 _ CAPITAL PROJECT FUNDS: m 126 SPECIAL GAS TAX $ 1,259,823 $ (800,000) $ 459,823 $ - $ 459,82: E 129 1/2 CENT SALES&ROAD TAX 1,756,754 1,756,754 1,756,75• 0 135 TRAFFIC CONGESTION(1) Q 208 VERDEMONT INFRASTRUCTURE 110,000 110,000 110,001 242 STREET CONSTRUCTION 2,217,148 2,217,148 (4,848) 2,212,301 243 PARK CONSTRUCTION(1) 1,584,499 1,584,499 (216,266) 1,368,23: 244 CEMETERY CONSTRUCTION 245 SEWER LINE CONSTRUCTION 331,798 331,798 - 331,791 246 PUBLIC IMPROVEMENT 248 STORM DRAIN CONSTRUCTION 1,049,191 1,049,191 1,049,19 250 TRAFFIC SYSTEM CONST(1) 258 PROPOSITION 1 B TOTAL CAPITAL PROJECTS FUNDS $ 8,309,213 $ (800,000) $7 7,509,213 $ (221,114) $ 7,288,09! 216120 Packet Pg.629 CITY OF SAN BERNARDINO 3.A.b EXPENDITURES BY CATEGORY-ALL FUNDS SCHED BY DEPARTMENT&FUND MID-YEAR 2013-2014 ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 FUND/TITLE 2013-2014 2013-2014 2013-2014 2013-2014 IMPACT FEE FUNDS: 261 LAW ENFORCEMENT DEVELOPMENT $ 30,385 $ 30,385 $ - $ 30,38! 262 FIRE PROTECTION DEVELOPMENT 115,930 115,930 45,000 160,931 263 LOCAL CIRCULATION SYSTEM 110,170 110,170 - 110,171 264 REGIONAL CIRCULATION SYSTEM 4,836,736 4,836,736 - 4,836,73! 265 LIBRARY FACILITIES 43,045 43,045 - 43,04! 266 PUBLIC MEETINGS FACILITIES - - 267 AQUATICS CENTER FACILITIES - 268 AB 1600 PARKLAND 1,095,080 1,095,080 1,095,081 O 269 QUIMBY ACT PARKLAND 47,791 47,791 - 47,79' N TOTAL IMPACT FEE FUNDS $ 6,279,137 $ - $ 6,279,137 $ 45,000 $ 6,324,13: G LANDSCAPE MAINTENANCE DISTRICT: 3 254 LANDSCAPE MAINTENANCE DISTRICT FUNDS $ 1,277,698 $ 1,277,698 $ 326,676 $ 1,604,37, .j DEBT SERVICE FUNDS: d 306 ASSESSMENT DISTRICT 987 DEBT SERVICE $ 51,400 51,400 (51,400) y 311 FIRE STATION DEBT SERVICE - of 356 ASSESSMENT DISTRICT 1015 NEW PINE AVE 68,000 68,000 68,001 TOTAL DEBT SERVICE FUNDS $ 119,400 $ - $ 119,400 $ (51,400). $ 68,001 m m ENTERPRISE FUNDS: 527 REFUSE $ 22,754,916 $ 22,754,916 1 $ (1.703,326)1 $ 21,051,591 -a TOTAL ENTERPRISE FUND $ 22,754,916 1 $ - $ 22,754,916 1 $ (1,703,326A $ 21,051,591 g INTERNAL SERVICE FUNDS: .- M 621 CENTRAL SERVICES $ 145,697 $ 145,697 $ (14,700) $ 130,99' N 629 LIABILITY 3,126,186 3,126,186 (1,277,580) 1,848,601 630 TELEPHONE SUPPORT 976,510 976,510 41,480 1,017,991 r 631 UTILITY 3,817,966 3,817,966 1,907,852 5,725,817 w 635 FLEET SERVICES 7,673,407 7,673,407 9,777 7,683,18, 2 677 UNEMPLOYMENT(2) 265,000 265,000 - 265,001 R 678 WORKER COMPENSATION 4,097,746 262,328 4,360,074 129,233 4,489,3 0- E 679 INFORMATION TECHNOLOGY 4,569,674 4,569,674 (44,000) 4,525,67, TOTAL INTERNAL SERVICE FUNDS $ 24,672,186 $ 262,328 $ 24,934,514 $ 752,062 $ 25,686,571 r a> GRAND TOTAL EXPENSES $199,380,220 $ 5,044,856 $ 204,425,076 $ 6,584,879 $ 211,009,95! 'otM m R am c a> E L V R Q 216120 Packet Pg.630 CITY OF SAN BERNARDINO '�, , EXPENDITURES BY CATEGORY-ALL FUNDS SCHE BY DEPARTMENT&FUND FISCAL YEAR 2013-2014 PERSONNEL MATERIALS CONTRACT INTERNAL CAPITAL DEBT TOTAL FUND I TITLE SERVICES /OPERATIONS SERVICE SERVICE OUTLAY SERVICE OTHER EXPENSE! ENE A L FUND: 010 Mayor $ 218,962 $ 70,075 $ 90,000 $ 116,543 $ 10 $ 495, 020 Common Council 492,001 43,200 93,485 229 628,' 030 Cq Clerk 850,770 71,183 793,123 133,879 166 1,849, 040 City Treasurer 187,160 10,500 4,000 12,911 53 214,, 050 City Attomey 2,235,179 455,0231 549,745 86,981 = 381 3,327, 090 General Govemment 450,937 360,582 6,428,205 5,208,589 - 12,448, 100 Cq Manager 938,201 26,600 100,402 - 1,065,: 110 Human Resource 326,534 102,387 109,553 7 538; 120 Finance 1,176,946 46,672 323,156 224,376 136 1,771,: 140 Civil Service 369,991 6,309 69,429 190 445, 180 Community Development 1,593,191 69,500 372,100 1,012,440 370 3,047,, 200 Fire 1 27,149,296 812,600 295,600 1 2,063,977 88,500 3,351 30,413, 210 Police 47,620,443 1,230,801 1,015,900 6,859,694 24,999 - 56,751, 380 Parks Recreation&Community 2,268,588 495,600 566,934 2,744,120 204 6,075, 400 Public Works 3,411,855 862,750 1,871,000 2,726,783 151,573 144 9,024, C t SPECIAL REVENUE FUNDS: N Y 004 FEMA 2 $ - $ - $ - $ - $ - $ - $ $ 105 LIBRARY 1,205,149 295,025 26,710 189,141 104 1,716, O 106 CEMETERY 113,952 23,300 19,388 52,224 6,000 21 4. 5 107 CATV 25,000 25,250 182,581 18,000 12,000 262, 108 FED ASSET FORFEITURE 200,100 381,000 115,199 12,100 708, 41 111 AIR QUALITY-AB 2766 92,924 21,400 11,400 8 125,- 116 EMERGENCY SHELTER GRANT 2 259,000 259.' 117 HOME PART INV ACT 2 2,400,000 2,400,E r+ 118 DRUG/GANG 25,385 5,000 30, d 119 CDBG 2 394,158 26,258 1,196,680 1,243,985 28 2,861, 120 NEIGHBORHOOD STABILIZATION FROG 2,120,000 2.120,' 121 SBETA 2 2,313,591 1,695,218 460,065 21,484 97,706 1,402,600 3,185, m 123 GRANTS FUND 2 496,100 65,000 105,000 - 150,000 1 816,• i 124 ANIMAL CONTROL 1,190,743 104,6001 96,000 791,006 94,800 - 2,277, 128 TRAFFIC SAFETY 651,448 651,. 132 SEWER LINE MAINT 1,306,450 221,000 1,027,402 169,920 - 21724, 133 BASEBALL STADIUM - 49,048 49,' 134 SOCCER FIELD COMPLEX 175,615 73,600 21,991 140,250 35,600 15 4471, 137 CFD 1033-FIRE STATION M&0 0 211 TRIBAL FIRE AGREEMENT 22,500 18,519 41.' M 254 LANDSCAPE MAINT DIST(1) 239,866 0 722,0891 642,419 - 1,604, CD TOTAL SPECIAL NU FUNDS N CAPITAL PROJECT FUNDS:126 SPECIAL GAS TAX $ - $ 15,999 $ 443,824 $ 459, T- 129 1/2 CENT SALES&ROAD TAX Mes I 0 1,756,754 1,756, 208 VERDEMONT INFRASTRUCTURE 110,000 110,' d 243 PARK CONST 1 280 1,368,233 280 1,368,. 245 SEWER LINE CONST DIF 3,586 328,212 0 331,' R 248 STORM DRAIN CONST - 1,049,191 1,049, E E IMPACT FEE FUNDS: y 261 LAW ENFORCEMENT DEV $ 385 $ 30,000 $ 30, 262 FIRE PROTECTION DEV 5,000 2,056 153,874 160, r+ 0) 263 LOCAL CIRC SYS - 110,170 110, 264 REGIONAL CIRC SYST - 4,836,736 - 4,836, 3 265 LIBRARY FACILITIES 42,500 545 43,E m 268 AB 1600 PARKLAND 1,095,080 1,095,, ` 269 QUIMBY ACT PARKLAND 1 47,791 47, (C d DEBT ERVI E FUND 'd 306 ASSESSMENT DISTRICT 987 DEBT SERVICE 311 FIRE STATION DS 356 ASSESSMENT DISTRICT 1015 NEW PINE AVE 3,7001 64,300 68,E OJ E 527 REFUSE $ 5,311,421 $ 5,655,800 $ 1,276,763 $ 6,031,0751 1$ 2,775,421 $ 1,108 $ 21,051, TOTAL TE INTERNAL SERVICE FUNDS: Q 621 CENTRAL SERVICES $ 54,522 $ 68,000 $ 5,500 $ 2,975 $ - $ 130,' 629 LIABILITY 201,800 1,540,110 24,000 31,980 50,715 1,848,, 630 TELEPHONE SUPPORT 219,577 751,800 2,562 44,000 51 1,017,' 631 UTILITY 54,773 3,657,587 1,925,200 88,500 242 517251i 635 FLEET SERVICES 1,669,818 5,704,592 15,334 293,235 205 71683, 677 UNEMPLOYMENT 265,000 265,1 678 WORKER COMPENSATION 1 343,001 1 3,471,7301 413,825 36,912 223,839 4,489, 679 INFORMATION TECHNOLOGY 1,455,346 1,632,401 542,490 65,250 185,187 645,000 4,525,E 3.A.b c L w J W 0 0 0 0 0 0 0 CD w O O O O O O 00 M 00 0) M C 0 0 0 0 0 0 0 00 q O O O M O O O M N IT O - O O O O O C4 O A LC) qT 0 0 LO O O LO N 0) O ti N C V O O B O O Ln 0 T- N 00 O O U-) O cD N CA 0) 00 O N N O Ln 0 0 00 f- CO I- M cc N O 'T O f� 00 CD N M N I� LC) CD O O M LO M I- 00 V N N CD I- C"7 N r M M CD H Q O t N 00 O O 00 00 i C C L O O Lr) ' LO 0 E I N O O N N Il- O O t ►� C &A O Co U) 00 CO d > H � Q y 01 - _ m +- 0 0 0 0 0 0 0 CD O O O O O 00 M 00 O U') 0 0 0 0 0 0 0 CO O m Cu Co O O O cM N qT O O m O O O O O Co O O � O) O O Ln N CA 0 f- CD -a _ 3 L O O I- O O Ln 0 00 N O CD N O I- O 00 HN O O O Co I- Co M O O I- qT QO It = CO N M N I` Ln CD CD O a) ti 00 N N N a +• ca CV) r N r r M CL i O O r O Q Q Q 0) C .-+ "O -0 % N N M C= C O O O co m UUU JU N s0. o) CD c c c m 06 E 06 CU m m a ' � -Q (n (n a) a) aa)) E O Q 'E L '= V U Q 0- c- L L O O O LL- � O O "� N N LL LL LL a U) L ca a) a) N N a) a) a) °' f6 L O S � N ?i U U C C C ' m X (n LL Q w 0) 0 N > > > m () a) a) a) ca LL cn 0 c UU �• YO � � � -E U .2e _ tLa �� 0 cc `V L L W V.+ CD Q.. N G X N N O L O O O LL 'o Cu to �a« o � (n n a) N LL p ; LL LL E Ln f� > C LL 0 LL M X X N O Ca LL LL LL m ca � D � � Z Q L N L .. .. LL LL LL LL LL NU —� D � c=a N cent Act Ac: " c♦ Ac: C: Cn Q N LL ,L L L L CU Ca a) a) -0 a) a) a) (n of Cn U Q O O O O O O O J O (D (D z EF= E E E E E E E E E E z E E E E E E U) 0 0 0 0 0 0 0 0 0 0 0 0 D 0 0 0 0 0 0 Z L L L L L L L L L L L L LL L L L L L L V) u LL LL LL LL LL LL LL LL LL LL LL LL a:: LL LL LL LL LL LL �< or_ J W N U. w O O O O O O O O O O O O H N w N N N N N N N 0 0 0 0 O J Z Z r- c- � N N N 'IT ' J Q LU Q 0 � � T- n- � Q LC) Cr Lo 'T CO M ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 O O N (. u) O M O H H 0 0 0 0 0 0 0 0 CD 0 0 0 I- N N Packet Pg. 632 3.A.b L w J ` W O O 00 M 00 O O O O 00 O o 0 0 C) 0 C) 0 0 IT M + o O M 04 14' 0 O O w � O o 0 0 0 0 0 o O M V Xo N O O N LO O M LO Iq O O O O O Cfl O O O N C U) L CD O O r O CD N O r N 00 O O O O O Lf) r- O 00 r O O 1- IT � r- 00 r- CO O O N O O a0 U) O CD �- O Oo I- Iq N N CD O O M LCD CD N Il- Un M N m O O C C'7 e- r r M r N M CD L 0 C!? 00 O O Co 0000 N 4- `••~ o O 14, Y a)^` :3 ' LO O O lf") U-) Z0 W Q N O O M �O 00 00 Cy E Q a) Co) O o 00 Co 00 O O o CD O O O O O o 0 CD U") 3 •0 + o O cM N Iq o O O M O O O o 0 0 o w m Co C O O N CA O N Uf) O 0') ' q ' ' O O o Cfl O O qT O >_ m CD O O r C3� CD C14 O r 00 O O O Lo ti O Lo r -C3 N r 0 or- q q NT rl- co M N O o 0 0 0 0 � � a) 00 I- IT N N (fl O CD N r- U-) Co N � r Q r M r r M r N r O ro r r Q M O CA 4 N �. O � E F= � C N +� Can _ a)LL> > O > = co O ` N C1 C L ° 0) y U) ° U Q Q C cn •� O � _0 -0 -0 L U Q Co) C C C _0 LL C C m O N .z Cu M CTS C :3 -0 E i Cn '� CD Cc C LL C to 0 0 m CY) C C� O 7 Cu 0 CL a) U O C . , rn Cn E C a� Q N N N J a- O � � ca o Y o o o 06 C L 4 a) LLOM m 'rnc C � .. �. caM O � Q (0 f4 L a) d) Cu N Co 0 N > 04 0 .E ° � oo M � � •� �` v O Q O LL 1� •O /� { W C C _ LL LL ,v `V Y � � �' � � � Co00- 000/) Cn � UULL � LL Q L L L L L L L L L L L Ca 0 0 0 0 0 0 0 0 a) O O O t LL LL LL U- LL LL LL LL Cn LL LL LL Ca U I 1 1 1 1 1 1 I I 1 I 1 Z O = a CO «s -a -0 -0 -a -0 -0 -a -0 -a -0 -0 -0 O Q U LL c4 — LL C C C C C C C C C C C C T U Cu C C C C = C (n a) �' LL LL LL LL LL LL LL LL LL LL LL LL 0-1 E Lm -0 E C C C C C C C C C C C C W ° m -a a) a) a) a) a) a) a) a) a) a) a) a) LL O Q -:1 JUm o � 0007CDCDCDCD0CDCD (7CD (q I p o 0 0 0 0 z 0 0 0 0 0 0 0 0 0 0 0 0 o z D F— F— F— F— F— F— F— H I-- F— H F-- Q p U LLLL C) CD 0 0 0 w ~ Cn Q N N N N N = J z r r r r r Q Q z r r r r r CJ U) r M M M M O CD CA N ti ti ti F-- w o 0 0 0 0 -j O N N N N N N N M M � N O F— 0 0 0 o 0 0 Q r r r r r r r r r r r N Ln F— Packet Pg.633 0 f� a� a 0 d- C� a � a O o �o � o0 Eg F10 LL 00 0 LLM CL CL b OZ/O�/Z M W E mo C: U C� O co � O � O O N o co CO CO CO CD O o o N N O C� U N a) — Cll O LL (10 0 < �- ; 0 C: 0 o U _0 cn -� (1) C;) Fp Fn :3 c LJL �--+ C ° ° U) 0 0 Q C _ � Q a� U) a' C) U) m � 0 � Q N Lcn � U) J - 0 , L � Q � � � � w L 0 U .� � - 4 cr-C E — •� ._ 0) C: o U s m C: -0 U o co E LL -., +--� U) 0 0) C (4 0 E .— C: 0 Co c� O CD ° o w E 0 A � CL Cn W n n A c� d- v . oo co N 60- 60- • M 619- • — v m .. 00 N L I *..: N o7 • W � N > � � L r 1 4D LL t7 Loz,oL,z U N o � 0') Q �+ � Y 4� N CD N 6 L C O C: 7�; c O m N o � U a Y CD U LO LL w N Q m W Oly C/) m C7 CC) ma)> pO E O O U) O U � CO U oz/ r H Ile 6 (D � Y U Y Q ° � o 0o Y Y c O 00 Y cfl 0 00q co M 1 0 ( � j 6,2/, LL B H4 o d 1 1 > Q Q � \ O - m x O + I- o �- w ,, n3 x Y � a) 0 I- U m Q c.0 o `t U cn � U CO CO o LO U � � Q M U � � I 40 w U H Q m w U) • • / • 1 1 1 1 / 1 A ' y 0. I LL il LAM cn uj co Fm CL X � W '0 Y L m (1) O LO� 4-0 C) Qq cyi 75 aa) ry Amp >1 CL im O Z LL O � a o J 'C: � c � � o ui 0 C/) CL LU 3 � � U N co Z � U �iD Q � N Q W n n n n KOVU/Z (� Q m 0 L. C) �- }' 0 c� MR V o .C: 0 L C: 0 U 0 0 a) — c� I— a cvi E — ca C� 4- :3 2 '— 0 0- cn — cn Z O U) w � c � �- -0 0 .- 4) c M:� 0--0 LL p o � CO co _ a m 0i E -o co QL —3 o DC �- �n L o � o � LU 0) 0 C: 00 a) o cu Z O C: D- ZU 00� 2i LU 0 n n n c� Q m • � 1 • a) cu E • • cn N :3 a) 'a • cu ^ cu N cn • • C L_ cu Z a) w m cu ai 0 a) cn 1 I— U a) c C: o • o � o � c U •• CU 0 cn cn(t J o W c O o O N O c-p cn cn N O o CU i L 06 0 .�_ cu N U U C6 .0 cu U 1 `n cn >cu a) 0 cn c c U -L a) a) o • a) M cn a) > L v �, CU ca -0 1 cn a) O Q O L • _ W �C �-+ O LL 1:Y � m Q C Q U) J7�OZ/0�/Z n N C O 'O � d W E � O O V m f CO CY) C`7 CY) LO M ^ 00 CN Cv "I- T- O� (D M T- 0 � }6F} 6F} Eft bF} {f} {f} � 60- • • • • • U) N N LL L a) O U) N — U -0 O E N X CU E C/) ~ c(n X N _0 Cv O ca N m J um L O � Q c Cn 0) � Q LL m N O R3 F" 0� > CO U E- LO 0 N 0 M M N O N E L 7 _^` > O a) L O � O > • O 4-0 CZ O � -L O m U) O L 0) O N U O 06 76_ }, p m U) � lL O � � lO � N a--� N T T V O O a� U U 0 as O_ U Q) 4- to a) p a) > O U L Q :tf-0 c x -0 0- -,- c a) co (6 m m Q m OU coo :-5 U) U ^ L LL � >,1 p O � O O O O � N � W Q U � N � ca Q L v E E H a) a) a) a) m O L O p p 0 U (D (D (D (D U Z F- 2 2 E • (C) O � N M (C) 07 M M 00 M T- r— M N ff} CO) V9, 09- } 6f} ot • O 00 00 N N C) C) cyi I` 69- • w C, 00 N M M {f} 60). 6g 60} LO N N LO r*_ LO O CU • 6c r r- w � z p w W W w w X w> LL, 7) LL w (/) LL W W Z (n J Z U) J I > Q la- a- Q la- �- 0 w OF— zw i d' • C) N • N C`7 C) p CY) C: CY) H C) • N (Y) A � _0 CD p a) 0 C`7 j (D d- C= O p V Q . II W1 LLM W '� cn a I OD 0 -0 W W A-5 =3 L > C) -0 (1) (1) `'— > 0 0 2 .> 0 00 U- m N Q I- Z O 0 .- Z IL w -0 LL O w a, w o U E LL D C Q U co Z o n > 0 > O U J � o � Q _0 0 _ (J) W c cn o c� o > � o um w a.. U >- ' 1 r' � I W y i cn �-' •� .- FM �E Q — Z 4- -;n � O o W � Q. U) L 4-a O x � n oU W .U 1, J -0 > O O � O O Z .X (n 0 LL LL O Q Cn _0 E E W E ._ �, E z 0 � C � M LL, W CU LL Q F 0 N 4-5 � O O O - - O � Q Q -1-a C O O .- o U � Cl) W (1) O -� D :3 O Z ry W O LL - W (1) (1) 06 O 0U LL - Z � � E M a) o 2 U c 0- D (D Q a) CD C (n *0 co C) > w 0 Z CL c6 � O U) c� L6 W � � � (D . o i 4 1 N nU) t W A-4 p .i O p > 0 C: U) E oo aD � E o > N p U cn p 'E 0 4o- cm (n M 4- ._ i p U o p p .- m o �. CL LO o a� O N 0 o 0 CN 0 C_ C: >- > C) 0 r tQ •- IL W N N �j >1> W O CO O O C: LO 00 O � � � O c- CL C6 d- O _0 E Q � � O 4� O LL O -0 It :3 C6 LO V .r- m L- T- t/) o f 1 o 1 N E z= CL (D H L Q � N I m I U) >, N- � Ct T- r s.._ (V o) O �. 0) 1 c: N -- O C: C: LL 2t Q _ LL n U) Z 0 U) UA City of San Bernardino Mid-Year Update of General Fund and All Other Fund Budgets GENERAL FUND: Adopted Approved Amended Proposed Mid-Year Budget Amendments Budget Amendments Projection Depart. Revenues 114,735,172 112,844 114,848,016 4,790,751 119,638,767 Transfer In 11,452,986 1,872,548 13,325,534 - 13,325,534 Total Revenue 126,188,158 1,985,392 128,173,550 4,790,751 132,964,301 Fund 123 - SAFER (2012) 1,072,548 Expenses 117,202,937 3,689,177 120,892,114 7,204,581 128,096,695 Transfer Out 2,516,000 - 2,516,000 730,209 3,246,209 Total Expense 119,718,937 3,689,177 123,408,114 7,934,790 131,342,904 Net- Rev-Exp 6,469,221 (1,703,785) 4,765,436 (3,144,039) 1,621,397 Net- Rev-Exp 6,469,221 Revenue 6,776,143 Expenses 11,623,967 Net- Rev-Exp 1,621,397 ALL OTHER FUNDS: Adopted Approved Amended Proposed Mid-Year Budget Amendments Budget Amendments Projection Revenues 84,634,355 2,429,618 87,063,973 4,153,858 91,217,831 Transfer In 2,558,500 - 2,558,500 730,209 3,288,709 Total Revenue 87,192,855 2,429,618 89,622,473 4,884,067 94,506,540 Expenses 82,177,283 1,355,679 83,532,962 (619,702) 82,913,260 Transfer Out 11,495,486 1,872,548 13,368,034 - 13,368,034 Total Expense 93,672,769 3,228,227 96,900,996 (619,702) 96,281,294 City Clerk Net- Rev-Exp (6,479,914) (798,609) (7,278,523) 5,503,769 (1,774,754) Net- Rev-Exp - Revenue 730,209 Expenses 1,872,548 Net- Rev-Exp (1,142,339) 2/10/14 1 OF 19 CITY OF SAN BERNARDINO SCHEDULE A' FY 2013-2014 SUMMARY OF MID-YEAR RECOMMENDED ADJUSTMENS TO REVENUES&EXPENDITURES ESTIMATED CASH ADDITIONS TOTAL DEDUCTIONS TOTAL CASH BALANCE TITLE AV _.0 001 GENERAL FUND 8,664,806 $ 119,638,767 $ 13,325,534 1$ 141,629,107 $ 128,096,695 3,246,209 $ 131,342,904 $ 10,286,203 SPECIAL REVENUE FUNDS: General Fund Related Funds 105 LIBRARY $ 159,929 $ 43,100 $ 1,700,000 $ 1,903,029 $ 1,716,129 $ 42,500 $ 1,758,629 $ 144,400 106 CEMETERY $ 71,609 16,550 271,923 $ 216,864 214,865 - $ 214,865 $ 1,999 107 CATV 521,622 262,278 $ 783,900 262,831 $ 262,831 $ 521,069 124 ANIMAL CONTROL 536,534 1,417,500 816,000 $ 2,770,034 2,277,149 $ 2,277,149 $ 492,885 133 BASEBALL STADIUM 49,048 $ 49,048 49,048 $ 49,048 $ - 134 SOCCER FIELD COMPLEX 488,157 401,000 - $ 889,157 447,041 $ 447,041 $ 442,116 Sub-Total $ 1,634,633 $ 2,140,428 $ 2,836,971 $ 6,612,032 $ 4,967,063 $ 42,500 $ 5,009,563 $ 1,602,469 Non-General Fund 004 FEMA 2 $ 45,879 $ - $ - $ 45,879 $ - $ - $ - $ 45,879 108 FED ASSET FORFEITURE 1,163,245 605,000 $ 1,768,245 708,400 - $ 708,400 1,059,845 111 AIR QUALITY-AB 2766 99,792 255,200 $ 354,992 125,724 70,000 $ 195,724 159,268 116 EMERGENCY SHELTER GRANT 2 190,602 259,000 $ 68,398 259,000 - $ 259,000 190,602 117 HOME PART INV ACT 2 313,921 2,400,000 $ 2,713,921 2,400,000 $ 2,400,000 313,921 118 DRUGIGANG 146,946 30,300 $ 177,246 30,385 $ 30,385 146,861 119 CDBG 2 857,284 2,847,747 $ 1,990,463 2,861,109 $ 2,861,109 870,646 120 NEIGHBORHOOD STABLIZATION 2 947,741 2,120,000 $ 1,172,259 2,120,000 Is 2,120,000 947,741 121 SBETA 2 777,838 3,185,464 $ 2,407,626 3,185,464 $ 3,185,464 777,838 123 GRANTS FUND 2 3,926,038 4,609,074 $ 683,036 816,100 3,792,934 $ 4,609,034 3,925,998 127 LOW MOD HOUSING 343,601 $ 343,601 $ - 343,601 128 TRAFFIC SAFETY 889,130 514,489 $ 1,403,619 651,448 - $ 651,448 752,171 132 SEWER LINE MAINT 2,639,793 3,207,500 $ 5,847,293 2,724,772 700,000 $ 3,424,772 2,422,521 137 CFD 1033-FIRE STATION M&O 324,623 585,600 $ 910,223 1 585,600 $ 585,600 324,623 775 PERPETUAL CARE FUND 659,526 $ 659,526 $ - 659,526 211 TRIBAL FIRE AGREEMENT 67,971 $ 67,971 41,019 - $ 41,019 26,952 Sub-Total $ 5,077 $ 20,619,374 $ $ 20,614,297 $ 15,923,421 $ 5,148,534 $ 21,071,955 $ 457,658 CAPITAL PROJECT FUNDS: 126 SPECIAL GAS TAX $ 302,706 $ 5,939,647 $ $ 6,242,353 $ 459,823 $ 4,420,000 $ 4,879,823 $ 1,362,530 129 1/2 CENT SALES&ROAD TAX 53223,361 2,997,716 8,221,077 1,756,754 1,200,000 2,956,754 5,264,323 135 TRAFFIC CONGESTION 1 816 816 - - 816 208 VERDEMONT INFRASTRUCTURE 246,094 246,094 110,000 110,000 136,094 242 STREET CONST 744,673 2,212,300 1,467,627 23212,300 2,212,300 744,673 243 PARK CONST 1 168,233 1,200,000 1,368,233 1,368,233 1,368,233 0 244 CEMETERY CONST 52,584 52,584 - 52,584 246 PUBLIC IMPROVEMENT 1,080,771 8,000 1,0883771 1,088,771 250 TRAFFIC SYSTEM CONST 1 - 258 PROPOSITION 1B 64,322 64,322 - 64,322 ASSESSMENT DISTRICT FUNDS: 254 LANDSCAPE MAINT DIST 1 $ 91,902 $ 1,277,898 1$ 409,238 1$ 1,595,234 $ 1,604,374 $ $ 1,604,374 1$ 9,140 IMPACT FEE FUNDS: 245 SEWER LINE CONST DIF $ 2,555,598 $ 252,000 $ - $ 2,807,598 $ 331,798 $ - $ 331,798 $ 2,475,800 247 CULTURAL DEV 830,819 751,000 1,581,819 - 357,000 357,000 1,224,819 248 STORM DRAIN CONST 3,561,558 101,000 3,662,558 1,049,191 - 1,049,191 2,613,367 261 LAW ENFORCEMENT DEV 94,500 40,750 135,250 30,385 30,385 104,865 262 FIRE PROTECTION DEV 172,568 5,336 177,904 160,930 160,930 16,974 263 LOCAL CIRC SYS 708,289 131,505 839,794 110,170 110,170 729,624 264 REGIONAL CIRC SYST 7,478,655 1,710,000 9,188,655 4,836,736 4,836,736 4,351,919 265 LIBRARY FACILITIES 39,370 42,500 81,870 43,045 43,045 38,825 266 PUBLIC MEETINGS FACILITIES 379,764 4,590 384,354 - - 384,354 267 AQUATICS CENTER FACILITIES 115,477 1,200 116,677 - - 116,677 268 AB 1600 PARKLAND 1,458,010 3,620 1,461,630 1,095,080 1,095,080 366,550 269 QUIMBY ACT PARKLAND 241,642 600 242,242 47,791 47,791 194,451 DEBT SERVICE FUNDS: 306 AD 987 DEBT SERVICE Is 19,108 $ $ $ 19,108 $ - $ $ - $ 19,108 356 AD 1015 NEW PINE AVE 25,405 68,000 93,405 68,000 68,000 25,405 ENTERPRISE FUNDS: 527 REFUSE $ 3,331,206 $ 24,664,800 $ $ 27,996,006 $ 21,051,590 $ 2,200,000 $ 23,251,590 $ 4,744,416 INTERNAL SERVICE FUNDS: 621 CENTRAL SERVICES $ 124,536 $ 149,171 $ $ 24,635 $ 130,997 $ - $ 130,997 $ 106,362 629 LIABILITY 3,322,931 3,146,277 6,469,208 1,848,606 1,848,606 4,620,602 630 TELEPHONE SUPPORT 416,745 1,138,191 1,554,936 1,017,990 1,017,990 536,945 631 UTILITY 1,009,490 5,613,393 43603,903 5,7253818 5,725,818 1,121,915 635 FLEET SERVICES 1,061,652 8,116,662 9,178,314 7,683,184 7,683,184 1,495,130 677 UNEMPLOYMENT 215,831 283,000 67,169 265,000 265,000 197,831 678 WORKER COMPENSATION 998,429 4,332,247 1 3,333,8181 4,489,3071 4,489,307 1,155,489 679 INFORMATION TECHNOLOGY 1,742,479 4,309,126 6,0513605 4,525,674 4,525,674 1 1,525,931 2/10114 2 OF 19 CITY OF SAN BERNARDINO HISTORICAL SUMMARY OF REVENUES BY FUND SCHEDULE B' FY 2012-2013 THROUGH FY 2013-2014 ADOPTED ACTUALS ADOPTED PROPOSED ADJUSTMENTS DESCRIPTION 2012-2013 2012-2013 2013-2014 2013-2014 2013-2014 Unaudited 001 GENERAL FUND $ 114,386,034 $ 115,237,185 $ 114,735,172 $ 119,638,767 4,903,595 004 FEMA 2 - - - - - 105 LIBRARY 69,200 34,259 69,200 43,100 (26,100 106 CEMETERY 14,550 11,847 14,550 16,550 2,000 107 CABLE TV 228,607 282,552 227,885 $ 262,278 34,393 108 FEDERAL ASSET FORFEITURE 805,000 516,007 805,000 605,000 (200,000) 111 AIR QUALITY-AB 2766 255,200 261,057 255,200 255,200 116 EMERGENCY SHELTER GRANT(2) 280,971 259,000 259,000 - 117 HOME PART INVESTMENT ACT(2) 2,386,470 404 2,400,000 2,400,000 - 118 DRUG/GANG 30,300 19,478 30,300 30,300 - 119 CDBG (2) 2,811,898 1,697,127 2,811,900 2,847,747 35,847 120 NEIGHBORHOOD STABLIZATION 2) 2,915,401 - 2,120,000 2,120,000 121 SBETA(2) 2,678,965 5,294,870 2,678,965 3,185,464 506,499 123 GRANTS FUND 2 6,100,416 9,856,179 2,720,386 4,609,074 1,888,688 124 ANIMAL CONTROL 1,417,500 1,466,523 1,417,500 1,417,500 - 126 SPECIAL GAS TAX 5,301,927 4,752,312 6,140,429 5,939,647 (200,782) 128 TRAFFIC SAFETY 780,000 860,378 780,000 514,489 265,511 129 1/2 CENT SALES & ROAD TAX 2,934,364 3,015,796 2,997,716 2,997,716 - 132 SEWER LINE MAINTENANCE 3,206,000 3,185,339 3,207,500 3,207,500 133 BASEBALL STADIUM - - - - 134 SOCCER FIELD COMPLEX 401,000 383,400 401,000 401,000 135 TRAFFIC CONGESTION(1) - - - - 137 CFD 1033-FIRE STATION M&O 585,600 591,209 585,600 585,600 208 VERDEMONT INFRASTRUCTURE - (32) - - 211 TRIBAL FIRE AGREEMENT - - - - 242 STREET CONSTRUCTION 378,000 989,732 2,212,300 2,212,300 - 243 PARK CONSTRUCTION(1) 1,384,605 (73) - 1,200,000 1,200,000 244 CEMETERY CONSTRUCTION - (7) - - - 245 SEWER LINE CONSTRUCTION 112,000 270,293 102,000 252,000 150,000 246 PUBLIC IMPROVEMENT 12,000 140 8,000 8,000 - 247 CULTURAL DEVELOPMENT 251,000 747,209 251,000 751,000 500,000 248 STORM DRAIN CONSTRUCTION 278,000 928,138 276,000 101,000 (175,000) 254 LANDSCAPE MAINT DISTRICT(1) 1,277,898 1,328,934 1,277,898 1,277,898 258 PROPOSITION 113 - (329) - - 261 LAW ENFORCEMENT DEVELOPMENT 40,750 59,125 40,750 40,750 - 262 FIRE PROTECTION DEVELOPMENT 250 54,691 250 5,336 5,086 263 LOCAL CIRCULATION SYSTEM 500 209,200 200 131,505 131,305 264 REGIONAL CIRCULATION SYSTEM 10,000 1,434,384 10,000 1,710,000 1,700,000 265 LIBRARY FACILITIES - 637 - 266 PUBLIC MEETINGS FACILITIES 3,500 1,042 3,500 4,590 1,090 267 AQUATICS CENTER FACILITIES 1,200 344 1,200 1,200 - 268 AB 1600 PARKLAND - 7,845 - 3,620 3,620 269 QUIMBY ACT PARKLAND 600 (30) 600 600 - 306 AD 987 DEBT SERVICE 51,400 69 51,400 - (51,400) 356 AD 1015 NEW PINE AVE 68,000 64,854 68,000 68,000 - 527 REFUSE 25,186,600 25,000,590 25,186,600 24,664,800 (521,800) 621 CENTRAL SERVICES 149,171 65,868 149,171 149,171 629 LIABILITY 3,146,277 3,137,572 3,146,277 3,146,277 630 TELEPHONE SUPPORT 1,145,191 1,077,289 1,145,191 1,138,191 (7,000) 631 UTILITY 3,705,585 3,772,634 3,705,585 5,613,393 1,907,808 635 FLEET SERVICES 8,117,662 7,604,898 8,117,662 8,116,662 1,000 677 UNEMPLOYMENT 283,000 254,479 283,000 283,000 - 678 WORKER COMPENSATION 4,342,247 4,333,211 4,342,247 4,332,247 (10,000 679 INFORMATION TECHNOLOGY 4,333,393 4,138,743 4,333,393 4,309,126 (24,267) GRAND TOTAL $ 201,868,232 202,947,093 $ 199,367,527 210,856,598 $ 11,487,071 2/10/14 3 OF 19 CITY OF SAN BERNARDINO GENERAL FUND REVENUE DETAIL REPORT SCHEDULE V PRELIMINARY BUDGET 2012-13&2013-14 ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 DESCRIPTION 2012-13 2013-2014 2013-2014 2013-2014 2013-2014 PROPERTY TAXES 4001 Current Secured $ 8,678,432 $ 9,078,226 $ 9,078,226 $ 528,084 $ 9,606,310 4002 Current Unsecured 388,987 591,600 591,600 172,743 418,857 4003 Prior Taxes 161,406 297,840 297,840 97,840 200,000 4004 Prior Unsecured 6,393 9,996 9,996 9,996 4005 Property Tax Other 150,871 150,000 150,000 150,000 4006 Supplemental 163,341 156,000 156,000 - 156,000 4009 Negotiated Pass Thru of RDA/IVDA 806,421 231,150 231,150 1,155,702 1,386,852 4010 Residual Balance of RDA/IVDA 330,069 - 931,935 931,935 4011 Statutory Pass Thru of RDA/IVDA 711,825 - 246,000 246,000 4007 Prop Tax In Lieu of VLF 15,746,874 15,915,366 15,915,366 413,334 16,328,700 4121-4126 Other Property Taxes 156,006 - 68,288 68,288 Total Taxes $ 27,300,625 $ 26,430,178 $ $ 26,430,178 $ 3,072,760 $ 29,502,938 OTHER TAXES 4201-4214 Franchise Tax $ 2,917,410 $ 2,880,700 $ 2,880,700 $ 18,300 $ 2,899,000 4215 Tow Franchise 428,415 495,600 495,600 95,600 400,000 4220 Prop Tax In Lieu Sales Tax 7,010,874 7,151,091 7,151,091 104,026 7,255,117 4221 Sales Tax 20,519,428 20,513,753 20,513,753 1,159,534 21,673,287 4222 Transient Occupancy 2,921,980 2,600,000 2,600,000 - 2,600,000 4223 Property Transfer Tax 437,386 400,000 400,000 400,000 4224 Utility User Tax 22,468,359 22,500,000 22,500,000 - 22,500,000 4225 Sales Tax Public Safety 943,067 937,125 937,125 59,696 996,821 4227 Measure Z-District Tax 6,806,870 6,694,800 6,694,800 305,200 7,000,000 Total Taxes $ 64,453,790 $ 64,173,069 $ $ 64,173,069 $ 1,551,156 $ 65,724,225 LICENSES AND PERMITS 4301 Business Registration $ 6,353,807 $ 6,514,500 $ 6,514,500 $ - $ 6,514,500 4303 Misc City Clerk Permits 2,419 5,000 5,000 5,000 4304 Misc Planning Permits 17,527 27,000 27,000 27,000 4330 Building Permits 787,018 525,000 525,000 525,000 4331 Mechanical Permits 194,590 160,000 160,000 160,000 4332-3 Mobile Home Park Permit 3,459 55,400 55,400 55,400 4335-6 Fire Code Permits 302,826 264,000 264,000 264,000 4337 Fire Plan Check 143,573 100,000 100,000 20,000 120,000 4339-42 EMS Membership 9,783 6,000 6,000 - 6,000 4351 Street Cut Permits 185,745 320,000 320,000 95.000 415,000 4352 Misc Licenses&Permits 339,052 350,000 350,000 - 350,000 4353 Yard Sales Permit Fee - 4360 Grading Permits 11,278 10,000 10,000 10,000 4361 Construction Permits 49,663 70,500 70,500 70,500 4362 On Site Inspection Fees 502,466 200,000 200,000 374,251 574,251 4363 On Site Plan Check 176,750 78,000 78,000 150,000 228,000 Total License&Permit $ 9,079,955 $ 8,685,400 $ 8,685,400 $ 639,251 $ 9,324,651 FINES AND PENALTIES 4401 Unauthorized Sign Fine 0 0 0 0 4410 General Fines $ 57,345 $ 99,000 $ 99,000 $ (9,000) $ 90,000 4411 Code Admin Citations 185.970 200,000 200,000 200,000 4412 Fire Admin Citations 11,904 10,900 10,900 10,900 4420 Parkin Citations 597,282 1,100,000 1,100,000 315,000 785,000 4422 Fireworks Admin Civil Penalty 3,590 4,000 4,000 4,000 4423 General Admin Civil Penalty 669,567 586,000 586,000 586,000 4424-5 Police Admin Civil Penalty 10,313 75,000 75,000 (61.0001 14,000 4426 Building Admin Civil Pen 22,500 5,500 5,500 - 5,500 4427 Fire Admin Civil Penalty 52,489 35,000 35,000 35,000 4428 Code Admin Civil Penalty 116,520 240,800 240,800 34,200 275,000 4429 General Administrative Cites 16,205 - 6,002 6,002 Total Fines/Penalties $ 1,743,683 $ 2,356,200 1 1 $ 2,356,200 $ (344,798)1 $ 2,011,402 USE OF MONEY AND PROPERTY 4505-09 Interest Earnings $ - $ $ - 4520 Land&Building Rental 526,781 530,000 530,000 530,000 4523 ATS Land Rental 87,573 77,000 77,000 77,000 4530 Parking Rental Fee 660 - 4540 Vending Machine Comm. 26,943 31,000 31,000 31,000 4922-26 Sale of Property 1,243 2/10/14 4 OF 19 CITY OF SAN BERNARDINO GENERAL FUND REVENUE DETAIL REPORT SCHEDULE V PRELIMINARY BUDGET 2012-13&2013-14 ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 DESCRIPTION 2012-13 2013-2014 2013-2014 2013-2014 2013-2014 Total Money&Property $ 643,200 $ 638,000 $ 638,000 $ $ 638,000 INTERGOVERNMENTAL 4603 Motor Vehicle In Lieu $ 198,720 $ - $ - $ - 4606 Homeowner's Exemption 122,794 132,925 132,925 18,364 114,561 4615 Disaster Prep. Program - 41,600 41,600 41,600 - 4616 POST 27,685 75,000 75,000 40,000 35,000 4619 Mutual Aid/Disaster Reimb. 600,123 300,000 300,000 300,000 600,000 4622 ICEMA Medical Supply Reimbursement 33,608 - - 9,651 9,651 4625 State-Mandated Costs 96,963 300,000 300,000 232,559 67,441 4651 Construction Reimb. 4652 Pers Credit 4670 EDA&CDBG Reimb. 58,340 - _ _ 4671 SBIAA Reimbursement 139,617 145,000 145,000 177,117 322,117 4673 Water Reimbursement 592,400 592,400 592,400 - 592,400 4695 Recoverable Expense Income - Totalintergovernmental $ 1,870,250 $ 1,586,925 $ 1,586,925 $ 154,245 $ 1,741,170 CHARGES FOR SERVICE 4305 Annual Alarm Permits $ 188,450 $ 200,000 $ 200,000 $ - $ 200.000 4701 Election Filing Fee - 20,000 20,000 52,049 72,049 4702 County Contract 487,000 487,000 487,000 - 487,000 4705 Utility Collection Fee 4707 Passport Fees 4,054 60,000 60,000 60,000 - 4708 Fire Training Agreement 48,976 44,200 44,200 44,200 4709 Hazardous Material Fee 1,185 10,000 10,000 10,000 - 4710 Misc Planning/Building Planning/Building 71,529 60,000 60,000 60,000 4711 PW Subdivision File Fee 50,597 40,000 40,000 40,000 4714 Planning Develp Project 294,265 220,000 220,000 220,000 4715 CD Technology Fee 71,758 60,000 60,000 60,000 4718 Environmental 4720 Plan Review Fee 123,024 100,000 100,000 100,000 4731 Plan Check Fee 346,470 200,000 200,000 200,000 4733 Prop/Building Abatements 747,103 600,000 600,000 600,000 4735 Release Notice of Pendency 9,720 12,000 12,000 12,000 4743 PD Towing Release Fee 429,938 385,000 385,000 385,000 4745 Code Tow Release Fee 230 1,400 1,400 1,400 4747 False Alarm Fee 101,522 60,000 60,000 60,000 4752 Fireworks Regulatory Fee 66,226 62,800 62,800 - 62,800 4753 Fire Archival Fee 4,069 1,500 1,500 1,500 3,000 4754 Fire Business Occup Insp 42,410 40,000 40,000 - 40,000 4755 Fire Rental Inspections 558,577 550,000 550,000 550,000 4766 Building Permit Review 1,070 52,000 52,000 52,000 4767 Single Family Rental Insp 132,423 430,000 430,000 230,000 200,000 4768 Adm Cites-SFRIP 99,458 98,000 98,000 98,000 4770 Crime-free Rental Housing 25,150 56,000 56,000 56,000 4779 Blanket Inspection Fee 40,299 34,100 34,100 34.100 4780 Misc Develop Servs Chr s 30,244 40,000 40,000 - 40,000 4784 Plan Subdivision File Fee 1,000 1,000 4785 Non Subdivision Str Imp 55,000 55,000 - 55,000 4786 Certificate of Completion 2,000 2,000 2,000 4789 Archival Fee-Devel Servs 25,547 22,000 22,000 22,000 4795 Signal Maint/Energy 29,287 5,500 5,500 5,500 4798 Storm Drain Utility Fee 252,013 237,000 237,000 237,000 4799 NPDES Bus Inspection 19,031 28,000 28,000 28,000 4802 Str Light Energy Fee 4810 Misc. Development Services 5,000 5,000 5,000 4815 Weed Abatement 185,575 202,200 202,200 1 16,6j4j 85,556 4861 Program/Facility Use Fee 57,971 85,000 85,000 85,000 4862 Park Energy Fee 350 6,000 6,000 6,000 4863 Class Registration Fee 1,105 8,500 8,500 8,500 4864 Swimming Pool Fee 75,279 70,000 70,000 70,000 4865 Non-Resident Fees 1,693 1,000 1,000 1,000 4880 EMS User Fee 311,234 300,000 300,000 300,000 4881 Paramedic Reimb Contract 111,624 _ Total Charges $ 5,044,315 $ 4,951,200 $ 4,951,200 $ (362,095) $ 4,589,105 2/10/14 5 OF 19 CITY OF SAN BERNARDINO GENERAL FUND REVENUE DETAIL REPORT SCHEDULE V PRELIMINARY BUDGET 2012-13&2013-14 ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 DESCRIPTION 2012-13 2013-2014 2013-2014 2013-2014 2013-2014 MISCELLANEOUS 4722 C&D Application Fee $ 3,869 $ $ 1,938 $ 1,938 4734 CDBG Demolition 253,630 39,650 39,650 4740 Police Misc. Receipt 917,560 900,000 900,000 200,000 700,000 4741 Sale of Photos/Reports 1,203 12,000 12,000 12,000 4742 Pistol Range Fees 80,369 100,000 100,000 100,000 4744 Fingerprint Fee 3,818 5,000 5,000 5,000 4746 Property Auction 6,071 5,000 5,000 5,000 4748 Vehicle Repossession Fee 4,843 4,500 4,500 - 4,500 4749 Crime Prevention Revenue 639 - 300 300 4750Investigation Fee 32,230 45,000 45,000 - 45,000 4769 Payoff Demand Fee 10,296 - 4781 Plan Check Fee-Engineering 42,505 50,000 50,000 50,000 4782 Street Knockdown - 4901 Misc. Other Revenue 172,964 350,000 350,000 350,000 4903 Refunds and Rebates 90,885 1,500 1,500 1,500 4904 Drunk Driver Reimburmt. - 4905 Litigation Settlement 10,000 10,000 - 10,000 4906 Water Fund Contribution 3,261,400 3,261,400 3,261,400 336,544 3,597,944 4909 Returned Check Charge 904 - - - 4910 Admin Service Charge 367,600 367,600 367,600 4911 Restitutions 9,808 20,000 20,000 20,000 4912 Off Track Betting 74,054 90,000 90,000 90,000 4913 Route 66 Rendevous 35,593 - 4924 Damage Claim Recovery 60,360 80.000 112,844 192,844 192,844 4926 CID Reimburmt - 4928 Booking Fee Reimburmt. 20 2,000 2,000 2,000 4930 Sewer Contr.-Water 500,000 500,000 500,000 4931 Water Land Sales - 4933 Hazmat Incident Recovery 3,740 99,200 99,200 98,200 1,000 4937 Street Knockdown 34,604 11,000 11,000 - 11,000 Total Miscellaneous 1 1 $ 5,101,365 $ 5,914,200 $ 112.844 $ 6,027,044 $ 80,232 $ 6,107,276 TOTAL GENERAL FUND $ 115,237,183 $ 114,735,172 1 $ 112,844 1 $114,848,016 $ 4.790,751 1 $ 119,638,767 2/10/14 6 OF 19 CITY OF SAN BERNARDINO SCHEDULED' OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DESCRIP ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED 7 1 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 Unaudited 004 FEMA(2) 4619 State/County Disaster Reimbursement $ $ $ $ Total FEMA Reimbursements is is - Is - 105 LIBRARY 4505 Interest on Idle Cash' $ - $ $ 100 $ $ 100 4698 Donations - 10,000 10,000 4850 Miscellaneous Receipts 15,101 11,000 11,000 11,000 4851 Library Fines 19,126 21,000 21,000 21,000 4901 Miscellaneous Other Receipts 32 37,200 37,200 (36,200) 11000 Total Library is 34,2591 $ 69,200 - is 69,300 (26,200)1 $ 43,100 106 CEMETERY 4505 Interest on Idle Cash' $ 59 $ 50 $ 50 $ - $ 50 4775 Cemetery Burial Fee 8,182 10,000 10,000 10,000 4776 Sale of Vases 170 500 500 500 4777 Sale Concrete Boxes 2,748 3,500 3,500 1,500 5,000 4778 Sale Cemetery Plots 806 1 500 1 500 500 1,000 4901 Misce Receipts(Transfer from Cemetery Trust) Total Cemetery is 11,847 14,5501 is 14,550 $ 2,000 $ 16,550 107 CAN 4205 PEG Fee Revenue $ 279,585 $ 227,885 $ 16,317 $ 211,568 $ - $ 211,568 4699 Program Income 3 38,710 $ 38,710 $ 38,710 4901 Miscellaneous Other Receipts 2,970 12,000 $ 12,000 $ 12,000 Total Asset Forfeiture 282,552 227,885 $ 34,393 262,278 - 262,278 108 FEDERAL ASSET FORFEITURE 4505 Interest on Idle Cash' $ 96 $ 5,000 $ 5,000 $ $ 5,000 4672 Asset Forfeiture/Federal DOJ 322,274 450,000 450,000 0 450,000 4675 Asset Seizure-Federal Tre 82,371 0 0 0 0 4927 Asset Forfeiture 111,457 350,000 350.000 (200,000) 150,000 Total Asset Forfeiture $ 516,007 805,000 $ 805,000 $ (200,000) $ 605,000 111 AIR QUALITY-AB 2766 4505 Interest on Idle Cash" $ 6 $ - $ - $ - 4626 Rideshare Reimbursement 255,864 250,000 250,000 0 250,000 4906 Water Department 5,200 5,200 5,200 0 5,200 Total Air Quality-AB 2766 $ 261,057 $ 255,200 $ 255,200 - $ 255,200 116 EMERGENCY SHELTER GRANT(2) 4505 Interest on Idle Cash' $ $ - $ - $ - 4695 Recoverable Expense Income 259,000 259,000 259,000 Total Emergency Solutions $ 259,000 259,000 $ 259,000 117 HOME PART INVESTMENT ACT(2) 4699 Program Income $ 404 $ - $ - $ $ - 4695 Recoverable Expense Income 2,400,000 2,400,000 2,400,000 Total HOME Grant 404 2,400,000 2,400,000 $ 2,400,000 118 DRUG/GANG 4505 Interest on Idle Cash* $ 13 $ 300 $ 300 $ $ 300 4929 Asset Forfeiture-Drug/Gang 19,492 30.000 30,000 30,000 Total Drug/Gang $ 19,4781$ 30,300 is 30,300 1 $ 30,300 119 CDBG(2) 4505 Interest on Idle Cash' $ $ - $ 35,847 $ 35,847 4695 Recoverable Expense Income-leave it and reseE 1,697,127 2,811,900 2,811,900 - 2,811,900 Total CDBG $ 1,697,127 $ 2,811,900 7 2,811,900 $ 35,847'-F 2,847,747 2/10/14 7 OF 19 CITY OF SAN BERNARDINO SCHEDULED' OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DEOWRWrION ACTUALS ADOPTED BUDGET AMENDED PRUPOSED PROPOSED 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 120 NEIGHBORHOOD STABILIZATION 4505 Interest on Idle Cash" $ - _ $ - $ $ - 4695 Recoverable Expense Income 1 2,120,000 2,120,000 1 2,120,000 Total NEIGHBORHOOD STABILIZATION $ 2,120,000 $ 2,120,000 $ 2,120,000 121 SBETA(2) 4505 Interest on Idle Cash' $ - $ - $ $ - 4695 Recoverable Expense Income 5,294,870 2,678,965 506,499 3,185,464 3,185,464 Total SBETA 5,294,870 $ 2,678,965 506,499 3,185,464 3,185,464 123 GRANTS FUND(2) 4505 Interest on Idle Cash` $ - $ - $ 4695 Recoverable Expense Income 9,629,715 2,720,386 1,888,688 4,609,074 4,609,074 4696 Recoverable Revenue 198,561 4697 Credit NSIP Reimb Revenue 27,903 4698 Grant Donations 4699 Program Income Total Grants Fund $ 9,856,179 2,720,386 $ 1,888,688 4,609,074 4,609,074 124 ANIMAL CONTROL 4,525,674 4320 Animal License $ 228,071 $ 250,000 $ 250,000 $ $ 250,000 4352 Miscellaneous License&Permits 2,400 1,000 1,000 1,000 4410 General Fines 37,077 30,000 30,000 30,000 4430 Animal License Penalty 32,060 30,000 30,000 30,000 4756 Animal Adoption Fee 72,544 40,000 40,000 40,000 4757 Contracted Shelter Fee 960,594 967,000 967,000 967,000 4759 Apprehension Fee 21,745 20,000 20,000 20,000 4760 Board Fee 40,102 20,000 20,000 20,000 4761 Field Service Fee 200 2,000 2,000 2,000 4763 Owner Release Fee 17,288 20,000 20,000 20,000 4764 Vaccination Fee 23,675 12,000 12,000 12,000 4765 Microchip Fee 26,720 25,000 25,000 25,000 4901 Miscellaneous Receipts 4,047 500 500 500 4922 Sale of Equipment - - - Total Animal Control $ 1,466,523 1,417,500 $ 1,417,500 $ 1,417,500 126 SPECIAL GAS TAX 4505 Interest on Idle Cash' $ 26 $ 3,000 $ 3,000 $ $ 3,000 4602 HUTA Prop42 Replacement 1,662,967 2,996,044 2,996,044 143,384 2,852,660 4607 HUTA R&T 7360 - 4610 State Aid-2106 662,757 660,323 660,323 138.810 799,133 4611 State Aid-2107 1.500,757 1,472,222 1.472,222 217,989 1,254,233 4612 State Aid-2107.5 10,000 10,000 10,000 - 10,000 4614 Prop 111-Highway Users Tax 915,857 998,840 998,840 21,781 1,020,621 4945 Reimbursement - - - - Total Special Gas Tax $ 4,752,312 6,140,429 $ 6,140,429 (200,782) $ 5,939,647 128 TRAFFIC SAFETY 4440 CVC Fine $ 583,704 1 $ 780,000 1 1 $ 780,000 1 $ 280,000 $ 500,000 4441 Nester Red Lights 276,674 14,489 1 14,489 Total Traffic Safety $ 860,378 780,000 780,000 (265,511)1 $ 514,489 129 1/2 CENT SALES&ROAD TAX 4505 Interest on Idle Cash` $ 402 $ 2,000 $ 2,000 $ $ 2,000 4613 1/2 Cent Sales Tax 3,016,199 2,995,716 2,995,716 2,995,716 4630 State Aid Street Construction - - 4945 Construction Reimbursement - - Total 1/2 Cent Sales/Road Tax $ 3,015,796 $ 2,997,716 7 2,997,716 $ 2,997,716 132 SEWER LINE MAINTENANCE 4505 Interest on Idle Cash' $ 4,491 $ 7,500 $ 7,500 1 $ $ 7,500 4820 Sewer Line Maintenance 3,180,848 3,200,000 3,200,000 3,200,000 4903 Refunds and Rebates 2/10/14 8 OF 19 CITY OF SAN BERNARDINO SCHEDULED' OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DESCRIPTION ACTUALS ADOPTED BUDGET AMENDED PR POSED PROPOSED 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 Total Sewer Line Maintenance $ 3,185,339 $ 3,207,500 $ 3,207,500 $ - $ 3,207,500 133 BASEBALL STADIUM 4505 Interest on Idle Cash` $ __ - $ - $ $ - 4924 Damage Claim Recover 4901 Baseball Team Lease Agreement Total Baseball Stadium - $ 134 SOCCER FIELD COMPLEX 4505 Interest on Idle Cash' $ 37 $ 2,000 $ 2,000 $ $ 2,000 4520 Land&Building Rental 128,183 125,000 125,000 125,000 4528 Sponsorships 250 - - 4530 Rental Fee-Parking 157,480 180,000 180,000 180,000 4861 Program &Facilities Fee 76,314 75,000 75,000 75,000 4862 Park Energy Fee 788 4,000 4,000 41000 4901 Miscellaneous Other Revenue 20,423 15,000 15,000 15,000 Total Soccer Fields 383,400 401,000 401,000 401,000 135 TRAFFIC CONGESTION(1) 4505 Interest on Idle Cash* $ - $ - $ - $ 4635 Traffic Congestion Relief 4903 Refunds/Rebates Total Prop 42 Traffic Congestion $ $ - 137 CFD 1033-FIRE STATION M&O 4505 Interest on Idle Cash' 591,251 4115 CFD 1033 Special Tax 1 $ (43) $ 585,600 1 1 $ 585,600 1 $ $ 585,600 Total CFD 1033-Fire Station 208 VERDEMONT INFRASTRUCTURE 4505 Interest on Idle Cash` $ 32 $ - $ $ $ - 4512 Verdemont Infrastructure Fee I I - - Total Verdemont Improvement $ - - 211 TRIBAL FIRE AGREEMENT 0 4505 Interest on Idle Cash" $ $ $ - $ - 4824 Impact Fee - Total Fire Equipment Acquisition $ - $ 240 INFRASTRUCTURE LOAN(1) is 242 STREET CONSTRUCTION 4901 Miscellaneous Receipts/Refunds/Rebates $ $ $ $ 4630 State Aid-Street Construction - - 4658 Federal Aid-FAU 989,732 2,212,300 2,212,300 2,212,300 4670 EDA Reimbursement - - - 4671 IVDA Reimbursement 4677 Local Stimulus SANBAG 4945 Construction Reim bursement/Miscellaneous Total Street Construction $ 989,732 2,212,300 2,212,300 is - 2,212,300 243 PARK CONSTRUCTION(1) 4505 Interest on Idle Cash' $ 73 $ - $ - $ - $ - 4620 State Aid Park Development 1,200,000 1,200,000 4651 Construction Reimbursement - - 4670 Successor Agency/San Bernardino - 4732 Park Development Fee Total Park Construction (73) - 1,200,000 1,200,000 244 CEMETERY CONSTRUCTION 4505 Interest on Idle Cash` $ 7 $ $ $ - $ 4778 Sale Cemetery Plots Total Cemetery Construction $ (7) $ - - 2/10/14 9 OF 19 4W 4& CITY OF SAN BERNARDINO SCHEDULED' OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DEWMIPTION ACTUALS I ADOPTED BUDGET AME OSED PROPOSED 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 245 SEWER LINE CONSTRUCTION 4505 Interest on Idle Cash* $ 4,359 $ 2,000 $ 2,000 $ $ 2,000 4651 Construction Reimbursement - - 4821 Sewer Lateral Fee - - 4822 Sewer Connection Fee 265,934 100,000 100,000 150,000 250,000 Total Sewer Line Construction T 270,293 $ 102,000 102,000 $ 150,000 $ 252,000 246 PUBLIC IMPROVEMENT 4505 Interest on Idle Cash' $ 140 $ 8,000 1 $ 8,000 $ $ 8,000 4902 Contribution - Total Public Improvement Construction (140) $ 8,000 8,000 8,000 247 CULTURAL DEVELOPMENT 4505 Interest on Idle Cash* $ 60 $ 1,000 $ 1,000 $ - $ 1,000 4335 Cultural Development Construction Fee 747,268 250,000 250,000 500,000 750,000 Total Cultural Development Construction $ 747,208 $ 251,000 251,000 500,000 751,000 248 STORM DRAIN CONSTRUCTION 4505 Interest on Idle Cash' $ 382 $ 1,000 $ 1,000 $ - $ 1,000 4651 Construction Reimbursement - - 4819 Area Drainage Plan Fee - - 4818 Storm Drain Fee 928,519 275,000 275,000 (175,000) 100,000 Total Storm Drain Construction 928,137 276,000 276,000 (175,000) 101,000 250 TRAFFIC SYSTEM CONST(1) 4505 Interest on Idle Cash` $ - $ $ $ - 4630 State Aid Street Construction 4658 Fed Aid Street Construction 4803 Traffic System Fees 4945 Construction Reimbursement Total Traffic Systems Construction is - $ - $ - 254 LANDSCAPE MAINT DISTRICT(1) 4505 Interest on Idle Cash' $ 228 $ 200 $ 200 $ $ 200 4115 Revenue for All ADS 1.329,162 1,277,698 1,277,698 1,277,698 Total Landscape Districts 1,328,934 $ 1,277,898 1,277,898 1 $ 1,277,898 258 PROPOSITION 1B 4505 Interest on Idle Cash` $ - $ - $ $ - 4628 Prop 1 B Revenue 4945 Construction Reimbursement - - Total PROP 1113 $ - - 261 LAW ENFORCEMENT DEVELOPMENT 4505 Interest on Idle Cash' $ (22) $ 750 $ 750 1 $ $ 750 4824 Development Impact Fees 59.146 40,000 40,000 1 1 40,000 Total Law Enforcement Impact Fee $ 59,125 $ 40,750 $ 40,750 - 40,750 262 FIRE PROTECTION DEVELOPMENT 4505 Interest on Idle Cash' $ 36 $ 250 $ 250 $ 5,086 $ 5,336 4824 Development Impact Fees 54,727 - - 4901 Miscellaneous Receipts - - Total Fire Protection Impact Fee 54,691 $ 250 - $ 250 5,086 5,336 263 LOCAL CIRCULATION SYSTEM 4505 Interest on Idle Cash' $ 68 $ 200 $ 200 $ 200 4824 Development Impact Fees 209,268 - - 131,505 131,505 Total Local Circulation Impact Fee 209,200 200 200 131,305 131,505 264 REGIONAL CIRCULATION SYSTEM 4505 Interest on Idle Cash 1 $ 779 $ 10,000 1 1 $ 10,000 1 $ is 10,000 4824 Development Impact Fees 1,435,164 1,700,000 1,700,000 2/10/14 10 OF 19 CITY OF SAN BERNARDINO SCHEDULED' OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013 8,2013-2014 DESCRIPTRW ACTUALS ADOPTED BUDGET AMENDED PROPOSED PROPOSED 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 4901 Miscellaneous Receipts-Loan Repayment Total Regional Circulation Impact Fee $ 1,434,384 $ 10,000 $ 10,000 1,700,000 $ 1,7107000 265 LIBRARY FACILITIES 4505 Interest on Idle Cash' 1 4824 Development Impact Fees 638 Total Library Facilities Impact Fee 637 - - 266 PUBLIC MEETINGS FACILITIES 4505 Interest on Idle Cash' $ 48 $ 3,500 $ 3,500 $ - $ 3,500 4824 Development Impact Fees 1,090 - - 1,090 1,090 Total Public Meetings Facilities Impact Fee 1,042 3,500 3,500 1,090 4,590 267 AQUATICS CENTER FACILITIES 4505 Interest on Idle Cash` $ 15 $ 1,200 1 $ 1,200 $ - $ 1,200 4824 Development Impact Fees 358 - - Total Aquatics Center Impact Fee $ 344 1,200 1,200 - T 1,200 268 AB 1600 PARKLAND 4505 Interest on Idle Cash' $ $ - $ $ - 4824 Development Impact Fees 3,620 3,620 Total AB 1600 Parkland Impact Fee - $ 3,620 3,620 269 QUIMBY ACT PARKLAND 4505 Interest on Idle Cash` $ 200 $ 600 1 $ 600 $ - $ 600 4824 Development Impact Fees 8,044 1 - Total Quimby Act Parkland Impact Fee 7,845 600 1 $ 600 600 305 AD 985 INDUSTRIAL PARKWAY(1) 4505 Interest on Idle Cash' $ - $ $ $ 4115 Revenue as from Assessments Districts Total AD 985 Industrial Parkway $ 1 $ - $ $ - $ 306 AD 987 DEBT SERVICE 4505 Interest on Idle Cash` $ $ - $ $ 4115 Revenue as from Assessments Districts 51,400 51,400 (51,400) Total AD 987 Debt Service $ 51,400 51,400 (51,400) 311 FIRE STATION DS 4505 Interest on Idle Cash" $ - $ - $ $ 4115 Revenue as from Assessments Districts Total Fire Station DS $ $ $ $ $ 356 AD 1015 NEW PINE AVE 4505 Interest on Idle Cash` $ $ - $ $ 4115 Revenue as from Assessments Districts 64,858 68,000 68,000 1 68.000 Total AD 1015 New Pine Ave. 64,858 68,000 68,000 $ 68,000 527 REFUSE 4505 Interest on Idle Cash' $ - $ 20,000 $ 20,000 $ $ 20,000 4830 Commercial Rubbish - - 4831 Commercial Bin Rent 203 400 400 400 4832 Commercial Bin Service 4,083,039 3,750,000 3,750,000 150,000 3,900,000 4833 Commercial Special 122,744 126,000 126,000 - 126,000 4837 Automated Commercial Rubbish 5,778,089 4,565,900 4,565,900 1,134,100 5,700,000 4840 Residential Water Billed 11,680,222 13,712,200 13,712,200 2,112,200 11,600,000 4841 Residential"B"Accounts 197 400 400 - 400 4843 Dino Bin Service 3,020,901 2,500,000 2,500,000 300,000 2,800,000 4844 Commercial Penalties - 4845 Residential Penalties - 4846 Recycling Receipts 224,518 160,700 160,700 6,300 167,000 4901 Miscellaneous Other Revenue 91,476 351,000 351,000 351,000 2/10/14 11 OF 19 CITY OF SAN BERNARDINO SCHEDULED' OTHER FUNDS REVENUE REPORT FISCAL YEARS 2012-2013&2013-2014 DESCRIPTION ACTUALS ADOPTED BUDGET I AMENDED PROPOSED PROPOSED 2012-2013 BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 2013-2014 2013-2014 2013-2014 2013-2014 4922 Sale Salvage Matter Total Refuse $ 25,000,590 $ 25,186,600 1 $ 25,186,600 $ (521,800) 24,664,800 621 CENTRAL SERVICES $ 65,868 149,171 $ 149,171 $ 149,171 629 LIABILITY 4505 Interest on Idle Cash' $ 374 $ - $ - $ $ - 4670 Successor Agency/San Bernardino - - - 4897 Interdepartmental Receipts 3,137,946 3,146,277 3,146,277 3,146,277 Total Liability Insurance 3,137,572 3,146,277 3,146,277 - 3,146,277 630 TELEPHONE SUPPORT 4893 Water Department Receipts $ 154,630 $ 154,630 $ 154,630 $ $ 154,630 4673 Water Reimbursement 9,079 4670 Successor Agency/San Bernardino 7,000 7,000 7,000 4897 Interdepartmental Receipts 910,860 974,561 974,561 974,561 4901/4903 Miscellaneous/SBETA/Assessment Districtq 2,728 9,000 1 9,000 91000 Total Telephone Support 1,077,297 1,145,191 - is 1,145,191 (7,000) 1,138,191 631 UTILITY 4893 Water Department Receipts $ - $ - $ - $ - 4897 Interdepartmental Receipts 3,772,646 3,705,585 3,705,585 1,907,808 5,613,393 4903 Misc/Assessment Districts/LED Reimb - - - - Total Utility 3,772,646 3,705,585 $ - 3,705,585 1,907,808 5,613,393 635 FLEET SERVICES 4670 Successor Agency/San Bernardino $ - $ 1,000 $ 1,000 $ 1,000 4897 Interdepartmental Receipts 6,759,731 7,666,662 7,666,662 7,666,662 4901 Misc/Assessment Districts/SBETA - 50,000 50,000 50,000 4903 Refunds/Rebates 845,167 400,000 400,000 400,000 Total Fleet Services 7,604,898 8,117,662 8,117,662 (1,000)TI 8,116,662 677 UNEMPLOYMENT 4899 Premiums $ 254,478 $ 283,000 $ 283,000 $ $ 283,000 Total Workers'Compensation 254,478 283,000 283,000 283,000 678 WORKER COMPENSATION 4897 Interdepartmental Receipts $ 3,921,210 $ 3,920,247 $ 3,920,247 $ $ 3,920,247 4906 Water Department 412,000 1 412,000 412,000 0 412.000 4670 Successor Agency/San Bernardino 0 1 10,000 10,000 (10,000) Total Workers'Compensation 4,333,210 4,342,247 4,342,247 (10,000)1 74,332,247 679 INFORMATION TECHNOLOGY 4670 Successor Agency/San Bernardino $ 24,267 $ 24,267 $ 24,267 4673 Water Reimbursement 411,006 522,267 522,267 0 522,267 4897 Interdepartmental Receipts 3,724,153 3,767,659 3,767,659 0 3,767,659 4901 Miscellaneous/SBETA/SANCAT/IVDA 3,594 19,200 19,200 0 19,200 Total Information Technology $ 4,138,753 4,333,393 4,333,393 (24,267) 4,309,126 GRAND TOTAL 87,710,228 84,634,355 2,429,580 87,064,035 4,153,796 91,217,831 2/10/14 12 OF 19 CITY OF SAN BERNARDINO HISTORICAL and PROPOSED SUMMARY OF EXPENDITURES SCHEDULE 'E' BY FUND/DEPARTMENT FY 2012-13 THROUGH FY 2013-14 ADOPTED ACTUALS ADOPTED PROPOSED VARIANCE DESCRIPTION 2012-13 2012-2013 2013-14 2013-14 2013-14 Unaudited GENERAL FUND: Mayor $ 594,479 $ 535,217 $ 495,580 $ 495,580 $ Common Council 662,230 557,046 628,683 628,683 $ City Clerk 1,021,179 1,195,113 1,495,371 1,849,123 $ 353,752 City Treasurer 221,176 205,747 214,456 214,456 $ - City Attorney 3,555,328 2,727,548 3,461,920 3,327,308 $ 134,612 Code Compliance - - $ - General Government 4,238,350 5,134,614 3,843,555 7,239,723 $ 3,396,168 Debt Service 1,758,500 922,749 1,758,500 5,208,589 $ 3,450,089 City Manager 1,116,136 645,282 1,065,200 1,065,200 $ - Human Resources 511,313 470,607 498,379 538,474 $ 40,095 Finance 1,262,926 1,482,255 1,771,286 1,771,286 $ - Civil Service 399,097 349,835 387,559 445,539 $ 57,980 Community Development 6,879,435 4,517,647 3,799,650 3,047,601 $ 752,049 Develo ment Services - - $ - Fire 31,712,999 29,408,382 30,078,535 30,413,324 $ 334,789 Police 55,670,857 57,071,129 54,956,081 56,751,837 $ 1,795,756 Facilites Management - - $ Parks, Rec.&Comm.Svcs. 4,656,966 4,183,046 4,606,109 6,075,446 $ 1,469,337 Public Services - - $ - Public Works 8,259,249 1 6,788,264 8,142,073 9,024,526 1 $ 882,453 $ 122,520,220 $ 116,194,483 $ 117,202,937 $ 128,096,695 $ 10,893,758 'Part of City-Wide reorganization,Code Enforcement moved to Community Deve Part of City-Wide reorganization,Development Services was combined with Cc( 'Part of City-Wide reorganization,Facilities Management moved to Public Works 'Part of City-Wide reorganization,Public Services combined with Facilities Mana, 004 FEMA 2 $ - $ - $ - $ - 105 LIBRARY 1,757,329 1,615,048 1,716,129 1,716,129 - 106 CEMETERY 189,727 89,821 187,429 214,865 27,436 107 CABLE TV 1 228,607 - 227,885 262,831 34,946 108 FEDERAL ASSET FORFEITURE 377,400 472,990 377,400 708,400 331,000 111 AIR QUALITY-AB 2766 129,142 91,656 125,724 125,724 116 EMERGENCY SHELTER GRANT 2 280,971 231,124 259,000 259,000 117 HOME PART INVESTMENT ACT 2 2,386,470 164,596 2,400,000 2,400,000 118 DRUG/GANG 30,481 14,273 30,385 30,385 - 119 CDBG 2 2,811,898 1,648,655 2,784,303 2,861,109 76,806 120 NEIGHBORHOOD STABLIZATION 2 2,915,401 609,030 2,120,000 2,120,000 - 121 SBETA 2 2,678,965 3,245,375 2,678,965 3,185,464 506,499 123 GRANTS FUND 2 1,902,206 6,441,183 - 816,100 816,100 124 ANIMAL CONTROL 2,257,980 2,014,105 2,157,003 2,277,149 120,146 126 SPECIAL GAS TAX 1,267,547 1,369,838 1,259,823 459,823 800,000 128 TRAFFIC SAFETY 653,511 278,580 651,448 651,448 129 1/2 CENT SALES& ROAD TAX 388,225 432,106 1,756,754 1,756,754 - 132 SEWER LINE MAINTENANCE 2,179,868 1,519,132 2,625,771 21724,772 99,001 133 BASEBALL STADIUM 15,240 15,192 49,048 33,856 134 SOCCER FIELD COMPLEX 371,653 251,700 367,080 447,041 79,961 135 TRAFFIC CONGESTION 1 - - - - 137 CFD 1033-FIRE STATION M&O - - 208 VERDEMONT INFRASTRUCTURE - 110,000 110,000 211 TRIBAL FIRE AGREEMENT 41,149 12,000 41,019 41,019 240 INFRASTRUCTURE LOAN 1 - - 242 STREET CONSTRUCTION 384,059 141,908 2,217,148 2,212,300 4,848 243 PARK CONSTRUCTION 1 195,536 7,511 1,584,499 1,368,233 216,266 244 CEMETERY CONSTRUCTION - - 245 SEWER LINE CONSTRUCTION 60,962 85,159 331,798 331,798 246 PUBLIC IMPROVEMENT - - 247 CULTURAL DEVELOPMENT - - 248 STORM DRAIN CONSTRUCTION 148,163 95,972 1,049,191 1,049,191 250 TRAFFIC SYSTEM CONST 1 - - - 254 LANDSCAPE MAINT DISTRICT 1 1,277,698 1,601,600 1,277,698 1,604,374 326,676 257 CITY WIDE ASSESSMENT DISTRICT 994 - - 2/5/2014 10:33 PM 13 OF 19 CITY OF SAN BERNARDINO HISTORICAL and PROPOSED SUMMARY OF EXPENDITURES SCHEDULE 'E' BY FUND/DEPARTMENT FY 2012-13 THROUGH FY 2013-14 ADOPTED ACTUALS ADOPTED 11WROPOSED VARIANCE DESCRIPTION 2012-13 2012-2013 2013-14 2013-14 2013-14 258 PROPOSITION 1B $ 2,294,932 $ 2,294,932 $ $ 261 LAW ENFORCEMENT DEVELOPMENT 30,481 104,542 30,385 30,385 - 262 FIRE PROTECTION DEVELOPMENT 162,870 156,719 115,930 160,930 45,000 263 LOCAL CIRCULATION SYSTEM - 14,412 110,170 110,170 264 REGIONAL CIRCULATION SYSTEM 1,244,637 220,357 4,836,736 4,836,736 265 LIBRARY FACILITIES 43,181 3,924 43,045 43,045 266 PUBLIC MEETINGS FACILITIES - - 267 AQUATICS CENTER FACILITIES - - 268 AB 1600 PARKLAND 25,400 1,999 1,095,080 1,095,080 269 QUIMBY ACT PARKLAND - 47,791 47,791 305 AD#985 DEBT SERVICE - - 306 AD 987 DEBT SERVICE 51,400 51,400 51,400 356 AD 1015 NEW PINE AVE 68,000 11,325 68,000 68,000 527 REFUSE 23,670,362 21,525,978 22,754,916 21,051,590 1,703,326 621 CENTRAL SERVICES 147,723 103,212 145,697 130,997 14,700 629 LIABILITY 3,134,464 1,330,593 3,126,186 1,848,606 1,277,580 630 TELEPHONE SUPPORT 984,319 862,107 976,510 1,017,990 41,480 631 UTILITY 3,819,335 5,238,422 3,817,966 5,725,818 1,907,852 635 FLEET SERVICES 8,614,408 5,999,878 7,673,407 7,683,184 9,777 677 UNEMPLOYMENT 265,000 433,039 265,000 265,000 - 678 WORKER COMPENSATION 4,110,632 4,301,300 4,097,746 4,489,307 391,561 679 INFORMATION TECHNOLOGY 4,580,349 3,640,873 4,569,674 4,525,674 (44,000) GRAND TOTAL ALL FUNDS $ 200,697,900 $ 184,871,457 $ 199,380,220 $ 211,009,955 11,629,735 2/5/2014 10:33 PM 14 OF 19 CITY OF SAN BERNARDINO EXPENDITURES BY CATEGORY-ALL FUNDS SCHEDULE T' BY DEPARTMENT&FUND MID-YEAR 2013-2014 ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 AWL ITITLE 2013-2014 2013-2014 2013-2014 2013-2014 GENERAL FUND: 010 MAYOR $ 495,580 $ 495,580 $ $ 495,580 020 COMMON COUNCIL 628,683 628,683 628,683 030 CITY CLERK 1,495,371 250,000 1,745,371 103,752 1,849,123 040 CITY TREASURER 214,456 214,456 - 214,456 050 CITY ATTORNEY 3,461,920 3,461,920 134,612 3,327,308 090 GENERAL GOVERNMENT 3,843,555 3,843,555 3,396,168 7,239,723 090 DEBT SERVICE 1,758,500 1,157,550 2,916,050 2,292,539 5,208,589 100 CITY MANAGER 1,065,200 1,065,200 - 1,065,200 140 CIVIL SERVICE 387,559 57,980 445,539 - 445,539 110 HUMAN RESOURCES 498,379 498,379 40,095 538,474 120 FINANCE 1,771,286 1,771,286 - 1,771,286 180 COMMUNITY DEVELOPMENT 3,799,650 352,595 3,447,055 399,454 3,047,601 200 FIRE 30,078,535 252,959 30,331,494 81,830 30,413,324 210 POLICE 54,956,081 1,361,710 56,317,791 434,046 56,751,837 380 4,606,109 1 4,606,109 1 1,469,337 1 6,075,446 400 PUBLIC WORKS 8,142,073 961,573 9,103,646 (79,120) 9,024,526 TOTAL GENERAL FUND $117,202,937 $ 3,689,177 $ 120,892,114 $ 7,204,581 $ 128,096,695 SPECIAL REV FUND : 004 FEMA 2 $ - $ - $ - 105 LIBRARY 1,716,129 1,716,129 - 1,716,129 106 CEMETERY 187,429 187,429 27,436 214,865 107 CATV 227,885 34,946 262,831 - 262,831 108 FEDERAL ASSET FORFEITURE 377,400 341,000 718,400 10,000 708,400 111 AIR QUALITY-AB 2766 125,724 125,724 125,724 116 EMERGENCY SHELTER GRANT 2 259,000 259,000 259,000 117 HOME PART INVESTMENT ACT 2 2,400,000 2,400,000 2,400,000 118 DRUG/GANG 30,385 30,385 30,385 119 CDBG 2 2,784,303 76,806 2,861,109 2,861,109 120 NEIGHBORHOOD STABLIZATION 2 2,120,000 2,120,000 2,120,000 121 SBETA 2 2,678,965 506,499 3,185,464 3,185,464 123 GRANTS FUND 2 - 816,100 816,100 816,100 124 ANIMAL CONTROL 2,157,003 118,000 2,275,003 2,146 2,277,149 127 LOW MOD HOUSING - - - 128 TRAFFIC SAFETY 651,448 651,448 - 651,448 132 SEWER LINE MAINTENANCE 2,625,771 2,625,771 99,001 2,724,772 133 BASEBALL STADIUM 15,192 15,192 33,856 49,048 134 SOCCER FIELD COMPLEX 367,080 367,080 79,961 447,041 137 CFD 1033-FIRE STATION M&O - - - 211 TRIBAL FIRE AGREEMENT 41,019 41,019 41,019 247 CULTURAL DEVELOPMENT - TOTAL SPECIAL REVENUE FUNDS $ 18,764,733 $ 1,893,351 $ 20,658,084 1 $ 232,400 1 $ 20,890,484 CAPITAL PROJECT FUNDS: 126 SPECIAL GAS TAX $ 1,259,823 $ 800,000 $ 459,823 $ - $ 459,823 129 1/2 CENT SALES& ROAD TAX 1,756,754 1,756,754 1,756,754 135 TRAFFIC CONGESTION 1 - - 208 VERDEMONT INFRASTRUCTURE 110,000 110,000 110,000 242 STREET CONSTRUCTION 2,217,148 2,217,148 4,848 2,212,300 243 PARK CONSTRUCTION 1 1,584,499 1,584,499 (216,2§61 1,368,233 244 CEMETERY CONSTRUCTION - - 245 SEWER LINE CONSTRUCTION 331,798 331,798 331,798 246 PUBLIC IMPROVEMENT - - 248 STORM DRAIN CONSTRUCTION 1,049,191 1,049,191 1,049,191 250 TRAFFIC SYSTEM CONST 1 - - 258 PROPOSITION 1B - TOTAL CAPITAL PROJECTS FUNDS $ 8,309,213 $ (800,000) $ 7,509,213 $ (72-1,114)1 $ 7,288,099 2/5/2014 10:33 PM 15 OF 19 CITY OF SAN BERNARDINO EXPENDITURES BY CATEGORY-ALL FUNDS SCHEDULE T' BY DEPARTMENT&FUND MID-YEAR 2013-2014 ADOPTED BUDGET AMENDED PROPOSED PROPOSED BUDGET AMENDMENTS BUDGET ADJUSTMENTS 2013-2014 FUND/TITLE 2013-2014 2013-2014 2013-2014 2013-2014 IMPACT FEE FUNDS: 261 LAW ENFORCEMENT DEVELOPMENT $ 30,385 $ 30,385 $ - $ 30,385 262 FIRE PROTECTION DEVELOPMENT 115,930 115,930 45,000 160,930 263 LOCAL CIRCULATION SYSTEM 110,170 110,170 - 110,170 264 REGIONAL CIRCULATION SYSTEM 4,836,736 4,836,736 4,836,736 265 LIBRARY FACILITIES 43,045 43,045 43,045 266 PUBLIC MEETINGS FACILITIES - - 267 AQUATICS CENTER FACILITIES - - 268 AB 1600 PARKLAND 1,095,080 1,095,080 1,095,080 269 QUIMBY ACT PARKLAND 47,791 47,791 47,791 TOTAL IMPACT FEE FUNDS $ 6,279,137 $ - $ 6,279,137 $ 45,000 $ 6,324,137 LANDSCAPE MAINTENANCE DISTRICT: 254 LANDSCAPE MAINTENANCE DISTRICT FUNDS $ 1,277,698 $ 1,277,698 $ 326,676 $ 1,604,374 DEBT SERVICE FUNDS: 306 ASSESSMENT DISTRICT 987 DEBT SERVICE $ 51,400 51,400 51,400 - 311 FIRE STATION DEBT SERVICE - 356 ASSESSMENT DISTRICT 1015 NEW PINE AVE 68,000 68,000 E 68,000 TOTAL DEBT SERVICE FUNDS $ 119,400 $ - $ 119,400 $ (51,400) $ 68,000 ENTERPRISE FUNDS: 527 REFUSE $ 22,754,916 1 $ 22,754,916 1 $ (1,703,326)1 $ 21,051,590 TOTAL ENTERPRISE FUND $ 22,754,916 $ $ 22,754,916 1 $ (1,703,326)1 $ 21,051,590 INTERNAL SERVICE FUNDS: 621 CENTRAL SERVICES $ 145,697 $ 145,697 $ (14,7201 $ 130,997 629 LIABILITY 3,126,186 3,126,186 1,277,580 1,848,606 630 TELEPHONE SUPPORT 976,510 976,510 41,480 1,017,990 631 UTILITY 3,817,966 3,817,966 1,907,852 5,725,818 635 FLEET SERVICES 7,673,407 7,673,407 9,777 7,683,184 677 UNEMPLOYMENT 2 265,000 265,000 - 265,000 678 WORKER COMPENSATION 4,097,746 262,328 4,360,074 129,233 4,489,307 679 INFORMATION TECHNOLOGY 4,569,674 4,569,674 (44,000) 4,525,674 TOTAL INTERNAL SERVICE FUNDS $ 24,672,186 $ 262,328 $ 24,934,514 $ 752,062 $ 25,686,576 GRAND TOTAL EXPENSES $199,380,220 $ 5,044,856 1 $ 204,425,076 $ 6,584,879 1 $ 211,009,955 2/5/2014 10:33 PM 16 OF 19 CITY OF SAN BERNARDINO /± EXPENDITURES BY CATEGORY-ALL FUNDS SCHEDULE V BY DEPARTMENT&FUND FISCAL YEAR 2013-2014 010 Mayor $ 218,962 $ 70,075 $ 90,000 $ 116,543 $ 10 $ 495,590 020 Common Council 492,001 43,200 93,485 229 628,915 030 City Clerk 850,770 71,183 793,123 133,879 166 1,849,122 040 City Treasurer 187,160 10,500 4,000 12,911 53 214,624 050 City Attorney 2,235,179 455,023 549,745 86,981 381 3,327,309 090 General Government 450,937 360,582 6,428,205 5,208,589 - 12,448,313 100 Citv Mana er 938,201 26,600 1 100,402 - 1,065,203 110 Human Resource 326,534 102,387 109,553 7 538,482 120 Finance 1,176,946 46,672 323,156 224,376 136 1,771,286 140 Civil Service 369,991 6,309 69,429 190 445,539 180 Community Development 1,593,191 69,500 372,100 1,012,440 370 3,047,601 200 Fire 27,149,296 812,600 295,600 2,063,977 88,500 3,351 30,413 324 210 Police 47,620,443 1,230,801 1,015,900 6859,694 24,999 - 56,751,837 380 Parks Recreation&Community 2,268,588 495,600 566,934 2,744,120 1 1 1 204 1 6,075,446 400 Public Works 3,411,855 1 862,750 1,871,000 2,726,783 151,573 144 9,024,104 SPECIAL REVENUE FUNDS: 004 FEMA 2 $ - $ - $ - $ - $ - $ - $ - $ - 105 LIBRARY 1205,149 295,025 26,710 189,141 104 1,716,129 106 CEMETERY 113,952 23,300 19,388 52,224 6,000 214,864 107 CAN 25,000 25,250 182,581 18,000 12,000 262,831 108 FED ASSET FORFEITURE 200,100 381,000 115,199 12,100 708,399 111 AIR QUALITY-AB 2766 92,924 21,400 11,400 8 125,732 116 EMERGENCY SHELTER GRANT 2 259,000 259,000 117 HOME PART INV ACT 2 2,400,000 2,400,000 118 DRUG/GANG 25,385 5,000 30,385 119 CDBG 2 394,158 26,258 1196,680 1,243,985 28 2,861,109 120 NEIGHBORHOOD STABILIZATION FROG 2,120,000 2,120,000 121 SBETA 2 2,313,591 1,695,218 460,065 21,484 97,706 1,402,600 3,185,464 123 GRANTS FUND 2 496,100 65,000 105,000 150,000 1 816,099 124 ANIMAL CONTROL 1,190,743 104,600 96,000 791,006 94,800 2,277,149 128 TRAFFIC SAFETY 651,448 651,448 132 SEWER LINE MAINT 1,306,450 221,000 1,027,402 169,920 2,724,772 133 BASEBALL STADIUM 49,048 49,048 134 SOCCER FIELD COMPLEX 175,615 73,600 21,991 140,250 35,600 15 447,040 137 CFD 1033-FIRE STATION M&0 0 0 211 TRIBAL FIRE AGREEMENT 22,500 18,519 41,019 254 LANDSCAPE MAINT DIST 1 239,866 1 0 1 722,089 1 642,419 1,604,374 CAPITAL PROJECT FUNDS: 126 SPECIAL GAS TAX $ $ 15,999 $ 443,824 $ 459,823 129 112 CENT SALES&ROAD TAX Mes I 0 1,756,754 1,756,754 208 VERDEMONT INFRASTRUCTURE 110,000 110,000 243 PARK CONST 1 280 1,368,233 280 1,368,233 245 SEWER LINE CONST DIF 3,586 328,212 0 331,798 248 STORM DRAIN CONST 1,049,191 1,049,191 IMPACT FEE FUNDS: 261 LAW ENFORCEMENT DEV $ 385 $ 30,000 $ 30,385 262 FIRE PROTECTION DEV 5,000 2,056 153,874 160,930 263 LOCAL CIRC SYS 110,170 110,170 264 REGIONAL CIRC SYST 4,836,736 4,836,736 265 LIBRARY FACILITIES 42,500 545 43,045 268 AB 1600 PARKLAND 1,095,080 1,095,080 269 QUIMBY ACT PARKLAND 47,791 1 47,791 DEBT SERVICE FUNDS: 306 ASSESSMENT DISTRICT 987 DEBT SERVICE 311 FIRE STATION DS 356 ASSESSMENT DISTRICT 1015 NEW PINE AVE 3,700 1 1 1 64,300 68,000 527 REFUSE $ 5,311,421 $ 5,655,800 $ 1,276,763 $ 6,031,075 $ 2,775,421 $ 1,108 $ 21,051,587 INTERNAL SERVICE FUNDS: 621 CENTRAL SERVICES $ 54,522 $ 68,000 $ 5,500 $ 2,975 $ - $ 130,997 629 LIABILITY 201,800 1,540,110 24,000 31,980 50,715 1,848,605 630 TELEPHONE SUPPORT 219,577 751,800 2,562 44,000 51 1,017,990 631 UTILITY 54,773 3,657,587 1,925,200 88,500 242 5,725,818 635 FLEET SERVICES 1,669,818 5,704,592 15,334 293,235 205 7,683,184 677 UNEMPLOYMENT 265,000 265,000 678 WORKER COMPENSATION 343,001 3,471,730 413,825 1 36,912 223,839 4,489,307 679 INFORMATION TECHNOLOGY 1,455,346 1,632,401 542,490 65,250 185,187 645,000 4,525,674 2/10/14 17 OF 19 rn LL J 00 0 W \ 0000000c000000 � 000OOMoo rn M o O O O O O O O CO ,t 0 0 0 M O O O M N 0 O O O L 0 O O O O O O C9 O O Lo It O o LO N U O O ti O O Lo- O N M O O O CO N 0-)- CA 00 p .- N O Lo 0 0 00 ti 00 ti M O O N O � 'It O I'- d' 00 a- CD N M N ti LO CD O O M Lo M rl- 00 't N N co ca Crj co r M CO a L a0 N ao O O ao , C It C LO O O LO I LO N ti O O L- ti O M U') 00 M C � F- Q 0 0 0 0 0 0 0 CD O L L CO O O O 00 M 00 O') LO O O O O O O O 00 0 00 O O o M N 't O O .a 0 0 0 0 o CO O M "t co m CA O o Ln N 0 0 I` CD 3 O O I` O O Ln o C6 O (.0 N m T- 0,) 00 m ,w N O Ln O O w co O 't O ti s 00 "t cD N M N f- Ln co O O Q) I` 00 It N N I` 41 to M T N � � � � M �t C a) � r Q sZ Q C CB C C O O O -c o L m co U U U 0 ? v n 00 000 U m c p c c c c c 06 E o6 co m cu _O Q '� V V C2 C2 C2 J O O tQ (0 Q) C -0 '0 L L L O O O C-6 LL C C O (D "J ) Cn LL LL LL n L Co O 4- co (U N (� (n O O O VL/ a) LL -o F- �_ O O C O C L C N U U c c c � : c LL < �, 0 0 w a H LL o O U U — Y CD Q) O L .� -EU .- I I m cz o � � � �+ -p C U ^, �� �� L L O U) m N C 06 CU L L O Cll CU m CB Fz CB E m ,� (n CU N O N N Q i? L O C C O 00 O _0 -° 'a X fl LL C O -O m co O - - L L LL F 0 O C� LL C (n U) -0 p LL LL _ C I I W c I -0 -0 � I 1 U C C M >, C C C LL LL _0 _0 C •0 -O _0 LL CO - C C C X X C C LL c c c Z _ J W N (D N I .L L L L m m (L] W -0 CL] W W LL (n � UT- U) < 0 (D (D (D0 oCDCDJCDCDCD LLU z 0 E E E EF= E E E E E E E z E E E E E E U) Z O o o o o o o o o o o o D o o o o o o z I L L L L L L L L L L L L In 11 LL LL LL LL LL LL LL LL LL LL LL LL = LL LL LL LL LL LL Q Lr -j _ LL- X 0 0 0 0 0 0 0 0 0 0 0 0 H N w N N N N N N N o 0 = 0 0 O Q z Z �- c- N N N � 't J Q 0 = = = T- T- T- T- c- T- c- T- � Q Lo "t Lo qt C9 M 0 w p o 0 0 0 0 0 0 O O o 0 o p o N CO Ln O M F- F- O o 0 0 0 0 0 0 0 0 0 0 H = T- N N = = � rn LL W O 000OOrn ooc00000000000 �t M \o W O O CM It O O O 00 It O o O O O o 0 0 � T- +0 O O N O O N LO O 0) Ln � 0 0 0 0 0 O O O O N N V (1) L (.0 O 0) O CO N O r- N 00 O O O O O In O 00 Nt Qm o o I� It � ti 00 ti M O O N o 0 00 LO O O T- 00 � It N N O o O M LO CO N I� LO M N M M O C T- C1 M N M (0 ^L ry LL L U) 00 O O 00 00 - O O It It Cll I Ln O O Ln Ln O a� I` O O Il- rl- C O M LO 00 00 Ero L 0) 0 0 00 co 00 0') O o O O o 0 0 0 00 O LO -0 + 0 0 co N It o O O 00 O O O O O 00 co O 7 O O O N o o N Ln O 0' ' � ' ' 0 0 0 Co 0 0 't CD m (O O o o O N O 1 00 O O O U') rl O LO L , o O r- �t It ti 00 co N O O CO LO O CD 't 00 Il- N N CO O Co Nrl- LSD co N It ti Q C M 0 rLo r r Q 4O E E L O C C +�. LL Cll 0 C LL a) U) a > > C 0 cz� O Q Q Q _0 0 Ul) o a U _0 _0 Q � -0 L U 0 C C _0 L C D � L U) m � O 0) cB C LL E c cn o o o } �- C C Q) U) -� U Q 06 Q N L (n .L to U) J 0) ^' Q 0 �) m 0 Y Q) O C }, U O U Cll O Q) C: : O . � LL O U CD-73 � (O LL m O O M L C L m m co`X (D C) M (� C CD LL LL LO O E f- Un U) a- U U) U) (D LL U U _ L L L L L L L L > L L L CCcz _0 =3 LL LL LL LL LL LL LL LL (n LL LL LL V 1 I I I 1 1 I 1 1 I I I 0 a >� C/) m -O _0 _0 _0 _0 -O -O -0 -O -O -0 -O 0 U LL O L _ LL C C C C C C C C C C C C I >, U m C C C C C C C C C C C C Un C6 L w O L LL LL LL LL LL LL LL LL LL LL LL LL C C C C C C C C C C C C Lli � C �_ � 0 C6 �_ Cll O O N (ll N N O N CU Cll (ll �, O Q J J U m N J 0 CD U CD CD 0 CD CD CD CD CD CD Un p O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Z c/) z F— F— Z) F— F- F- F- �- F- F- F- F- F- F-- F- �- < Z) LU U- J 0 0 0 C) 0 w ~ N N N N N N = J z � Q Q z= c- � T LU) = CO CO CO CO o (D 0) N I- ti ti O w o C) o 0 0 o — N N N N N N N M M "t N F- (7 C) 0 0 0 0 Q � � T- - c- N LO F-