Loading...
HomeMy WebLinkAbout01- Finance CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION From: Barbara Pachon Subject: Mid-Year Budget Review Ali% Director of Finance Fiscal Year 1999-2000 Dept: Finance Date: 3/6/00 Synopsis of Previous Council Action: 7/6/99 Resolution 1999-167 approving and adopting the Final Budget for FY 1999-2000 2/23/00 FY 1999-00 Mid-Year Budget Report referred to full Council by Ways & Means Committee. Recommended motion: That the Mayor and Common Council receive and file the FY 1999 —2000 Mid-Year Budget Report. Signature Contact person: Barbara Pachon, Director of Finance Phone: 5242 Supporting data attached: staff report, Mid-Year Budget Report Ward: FUNDING REQUIREMENTS: Amount: N/A Source: (Acct. No (Acct. Description) Finance: Council Notes: 3�6L # 2- z C Agenda Item * ' STAFF REPORT INTRODUCTION Attached is the Mid-Year Budget Analysis. This report is designed to keep the Mayor and Council informed of the current financial position of the City and to provide an early indication of next fiscal year's budget outlook. Each year in January, the City Administrator's Office and the Finance Department, as well as the individual departments, review revenues and expenditures for the first half of the fiscal year to determine if actuals are on target with projections, or if there is a savings or shortfall from original projections. The attached report includes updated projections with a detailed analysis of the General Fund as well as a summary review of other operating funds. For easy reference, each page of the Mid-Year Budget Review has been color-coded. The Summary of Revenues, Expenditures, and Transfers (blue report) provides a summary overview of all the major funds in the City. The first column of numbers provides the audited beginning fund balance for each fund. The last column of numbers on this report indicates the estimated balance for each fund at 6/30/00. THE GENERAL FUND Fund Balance — The FY 1998-99 audit has been completed and the audited, total actual FY 99-00 beginning General Fund Balance (reserved and unreserved combined) is $5,278,000. Included in this amount are the FY 98-99 General Fund continuing appropriations, encumbrance, and revenue carryovers in the net amount of $418,000. The revised estimate for the FY 99-00 total ending fund balance (including both reserved and unreserved) is $7,386,603. Of this amount $4,127,400 is designated as the budgeted reserve (in accordance with the direction of the Mayor and Council during the FY 99-00 budget adoption process). At this time it appears that the remaining undesignated ending General Fund balance will be $3,259,203. This is approximately $1,150,603 higher than projected at the beginning of the fiscal year. This increase is due primarily to increased growth in several revenue sources. These revenues are discussed in greater detail in their respective section below. General Fund Revenues — The Estimated Revenues and Expenditures General Fund report (pink report) provides a summary of the General Fund revenue estimates by category. The yellow report provides a detailed analysis of the projected General Fund Revenues. The estimated General Fund revenues are projected to be $1,378,800 higher than originally budgeted. Sales tax revenue continues its strong recovery. As reported to the Mayor and Council in the FY 1998-99 Final Report, the final Sales Tax payment to the City last fiscal year occurred after the budget adoption process and was significantly larger than expected. 1 Sales tax receipts as of December 1999 indicate this trend will continue. An additional $1,020,000 over originally budgeted amounts is now anticipated (4.5% increase over <^ original projections). Vehicle in Lieu Fees (VLF) revenue also experience unexpected growth at the end of last fiscal year and this year's receipts to date indicate the growth will continue. An additional $475,000 over originally budgeted projections is expected for a total of $8,875,000. The revenue has not yet been negatively affected by last year's State legislation reducing vehicle registration fees. Reimbursement from the State for State mandated programs is expected to be $235,000 higher than expected. This is due primarily to the State funding full reimbursement of past year's claims that were previously only partially reimbursed. Property Tax revenue appears to be performing slightly better than anticipated and a 2% increase ($158,300) over originally budgeted amounts is projected. Based on the past six months activity, the City Clerk's Office predicts Transient Occupancy Tax (TOT) will be approximately 4.6% higher than originally budgeted, for a total of$1,950,900 expected by the end of the fiscal year. Overall, the revenue category of Charges for Services is expected to be approximately 3.4% ($108,400) less than originally budgeted. Factors contributing to this shortfall include: Revenue from development related fees remain at levels consistent with last fiscal year, but have not continued to grow as originally projected by Development Services. Now that a full year of history exists regarding revenue from the relatively new Passport Program, revenues can be more accurately projected. It is now projected that revenue will be $20,000 less than originally budgeted. The reduction of this estimate is also due in part to the expected opening of passport facilities in three neighboring cities. Code Compliance estimated revenues related to Weed Abatement will be $50,000 less than originally budgeted. Additionally, the newly established "Release of Pendency Notice" fee is projected to reach only 40% of the originally budgeted amount for a total of$20,000. Overall, the revenue category of Licenses and Permits is expected to be 3.8% less than originally budgeted projections. The primary factor contributing to this shortfall is related to Fire Department revenues. The Fire Department expects to collect less than 50% of the originally budgeted amounts for Fire Citations and Fire Plan Check fees. This is attributed in part to the Fire Department's difficulty in filling vacant positions within the Fire Prevention Unit. The Fire Chief will be working with Development Services staff and the City Administrator's Office to resolve these issues. i 2 Expenditures and the Vacancy Factor— The Estimated Revenues and Expenditures General Fund Report (pink report) provides a list by department of the estimated General Fund expenditures. It is projected there will be an estimated expenditure savings (vacancy factor savings) in the General Fund of $2,423,903. Savings from Animal Control, CAN and the Library (these funds are subsidized by the General Fund through transfers) total $84,996. Combined, total expenditure savings are projected to be $2,508,899. This is $8,899 higher than the target expenditure savings goal of $2,500,000. The report entitled Analysis of FY 1999-00 Vacancy Factor (peach report) gives a breakdown of the vacancy factor by department. As was discussed during the budget process, each department was directed to try to achieve the target goal amount of expenditure savings assigned to them. The target amounts were based on previous years' history of expenditure savings. Generally, the majority of expenditure savings are based on staff vacancies. Departments with a large number of vacancies were able to achieve their level of expenditure savings. Departments with fewer vacancies were not able to meet their goals. Of the twenty department/divisions assigned vacancy factors, fourteen will meet or exceed their vacancy factor targets. However, at this time it is projected that the following departments will not be able to meet their target goal amounts: Library, Facilities Management, Development Services, City Attorney, Police Department, and the Fire Department. Facilities Management, Police Department, Library, and Development Services have all been impacted by higher than anticipated electric charges. Facilities Management is currently researching the unusually high electric charges and will make recommendations within the next month. The Police Department, Facilities Management, and Development Services have also been impacted by higher than anticipated garage charges. The Fleet Division has experienced a significant jump in fuel prices, which impacts departments with large fleets, such as the Police Department. The Fire Department was not assigned a vacancy factor goal. It appears that the Fire Department will exceed their budget by $255,100. OTHER FUNDS The Special Revenue Funds Revenue Report (green report) provides a detailed analysis of all the other funds' projected revenues. Estimated expenditures for other funds can be found summarized on the Summary of Revenues, Expenditures, and Transfers Report (blue report). In general, the revenue and expenditure projections for the majority of the other funds are on target with the exception of the following: The Asset Forfeiture Fund is projected to receive an additional $108,100 in revenues due the anticipated resolution of forfeiture cases that have been pending. The Animal Control Fund is projected to have a revenue shortfall of approximately $90,500 below originally budgeted amounts. However, this revenue shortfall will be i �-- offset in part by expected expenditure savings of $75,100. The revenue shortfall is 3 attributed primarily to the delay in hiring part-time employees for the licensing canvassing program. Additionally, the Department has experienced a number of other vacancies, which have affected its ability to collect various fees. The Stadium Fund deficit is projected to be slightly lower than originally projected. As presented to the Mayor and Council earlier this month, the Baseball Stadium Fund anticipates increased revenues from activities related to the marketing contract. However, expenditures are slightly higher than expected due primarily to increased electric costs. CAN has been able to secure more contracts for production than originally anticipated after reorganizing the department last fiscal year and is anticipating a 2.8% increase in revenues over original projections ($25,000). However, some of this increased revenue will be used to fund the cost of per-diem employees that are needed to work on productions as contracts increase. The Refuse Fund is projected to have a deficit of $1,918,400 at the end of the fiscal year, which is higher than originally projected. This is attributed primarily to two factors: increased expenditures for fuel and vehicle maintenance charges and a large number of write-offs for uncollectible accounts. As was explained in the December staff report to the Mayor and Council regarding preventative maintenance inspections (PMI's), Refuse has experienced a high number of truck repairs. Additionally, the Refuse Department conducted a comprehensive review of their accounts and turned a large number of delinquent accounts over to a collection agency. When accounts are turned over to an outside collection agency, the anticipated revenue from those accounts is written off the books. Finally, it appears that revenues will be approximately 1% less than originally budgeted. The City Administrator and the Finance Department are working with Public Services to address these issues and develop recommendations to reduce the fund's projected deficit. The Fleet Division has experienced a significant increase in fuel charges. This impact is passed directly on to user departments, and departments with large fleets such as the Police Department and the Refuse Division are severely impacted. The Fleet Division anticipates that fuel prices may continue to rise and will not be reduced, resulting in an overall increase in fuel costs of approximately $300,000. The Finance Department is working with Public Services to develop recommendations to address this shortfall. The Utility Fund's water charges budget of $93,600 has already been exceeded. This is attributed primarily to changes in the Water Department's billing system. It appears the City is now being charged for water meters that it was never charged for before. The City Administrator is working with the General Manager of the Water Department to resolve the situation. TRANSFERS The final set of reports, Transfers In and Transfers Out (purple report) provides the Crevised estimates for each transfer. As indicated by the report, transfers are generally on target with the following exceptions; the transfer to the Animal control Fund from the 4 General Fund was increased by $23,300 to cover the fund's net shortfall as discussed above; the transfer to the CAN fund was decreased by $30,500 due to increased revenues generated by that fund, and, because traffic safety revenues increased due to new legislation implemented last year, $145,000 additional revenue was transferred from the Traffic Safety fund to the General Fund. CONCLUSION In order to maintain budgetary control, staff will be bringing forward to the Mayor and Council in March a follow-up report that addresses some of the issues brought to the forefront during the Mid-Year review process. This follow-up report will be presented to the Mayor and Council at the same meeting the Mid-Year Report is presented. Due to the complexity of the issues, and the importance of getting the Mid-Year Report to the Ways and Means Committee as soon as possible, bringing these recommendations directly back to the Mayor and Council in one consolidated follow-up report is the most practical, efficient way to handle the issues. RECOMMENDATION Staff recommends that the Mid-Year Budget Report be received and filed. 5 N N N N N N N N N N A U U + + + + + + + + + + + + + U U A A A A p A A A a N 0 4 W w N N N N N + 0 0 0 0 0 O V C. W J OI D A W N + V + W N + ID U Of A N + O fO W V O1 U m y N tiz N Q Z M Q M N V D ..� M m m N N + i W D D -4 a V D 0 0 [ .n O D iO p f 3 A m r O T 3 D m m it z D D N D m m r m y m m p a m m T. m [ y c , M M o m m � ?.+ n Z x 7p_c m W 3 � M z r m T 3 c z ..1 m n A r N m m m o Rl T D A y m m m m m n r n ppp v 2 r m 0 y 9 O y m z D A -4 n r r ao u 4) 0 m 1 m < m iC) 0M0M 0m0 m prz fn (a z D zm0nOzyx -i O - m rmm '� ywmm < m c rm3Om -m{ ztzirA � xc r pD H D0 -4 -4 c Op ,;a z0 1N -' tinmz0 m c -4 9e xr = -4mxz D 'U p 1 m A c z =1 N V1 m 3 O N m N 3 c n yczilnZm � =1 zz c G a R y Z z O m v cinc Omiz c x O z y 1 z m o n O N 3 G z N A A Of tO N W U A N O Of [' QD W 0i W O) O A O) U U O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 O O 0 0 0 0 O O O n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O m N 3 Of O w tp V + T V N M W M O A U + N j A + W OO 01 z D m O J O U N N A A W OO IO 10 O O U T A U N O W U O Of A C A V O V O U O O O O U A O U O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O cm w z m < t7 N z m D m N N + W A z O N N U O N OUO O) N W m c m z m 0 0 0 0° °o °0 0 0 0 0 o z (Nj y D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o D m z m m p N N A N N A W A A N O y ,a D z z g D W W O1 W U O N ao W P .M m V w V �D Ol A U W U U O U W A W A V Of V. O Y + c 0 m p N � O N x ° D S ° z U N ONj N W _ V z p A V OO U V V O� p A O O A A + OD U A w A W 1O U O) O N ID A W tD o W U U A N O W W V e 4 z U A + O O d U V Of Gf Of IJ A V w O U d bU m w W fly W [Ae1 p N O O O O O O O O N O O O U 0 0 0 0 0 0 0 0 0 0 tp �n 0 0 0 0 0 0 0 0 0 0 0 A O O O O O U 0 0 0 0 0 0 0 0 0 0 0 V C m m 2 N z � N + N N w +f 0 0 U O N O r ° U A U Of 01 10 U U O Ol O N O V OI W pp O 0 0 0 0 0 O O O 0 0 0 0 0 + N + W + + O N O A A N W O y N A A W O1 O� OD W pp W O V O b + N W + N W V O C Oy 0 0 0 0 0 0 0 0 0 0 U O O O O U 0 0 0 0 0 0 0 0 0 0 0 IO z 0 0 0 0 0 0 0 0 0 0 0 Oi O O O O O W O 0 0 0 0 0 0 0 0 0 0 V rn G w 3 r > b V V N N w 01 Ip A IO W A O t0 V W ° a m m m m m m m m ae m o e y C -V r 0Zl O O O D O r -4 m y m Z Z m r W Z D m �_ GSim � _ s z m A m T 0 < r m G) ;azo tziim0 z -1 O A O r Z 9 N U A T O m m y p m z m z n < j D ca M i m C N m A m i n o M m O T S Z o c Q z m o m N N C 2 D. N W IbC CmO Oml W W A A v Iy' N V W A W W m m m Y N A A V N 4f ID W N O Z 0 0 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 0 0 m A N _ C N A m W N A W N m 3 A O A V V Obl ONI� CVO N A Z D OO A N O m W m m N W G r1I N O 0 0 0 0 0 0 0 0 O 3 T 2 N + > m m D m A Z O o r C T D m z N r k m m m w A A 1n w w m a D Z z z o a a ' c 0 a w oo a is + in io w M r io m ZO � o N x ° D q O Z w + z o O V W N m W N O y N V O A m N m O N i O A w N m m V m V C d Z C� m W V 4D W A A m [�*1 p N oz w z w+ O m 0 m 0 O N 0 0 O O y O O O O O O 0 0 0 0 0 0 0 0 tv O m W N m W 1p � m W A OD N W fli N �O H O O W N ONI m W Q m 0 0 0 0 0 0 0 0 z W 0 0 0 0 0 0 0 0 y Z y O m 10 N W o � e O O p W t0 N m s m m A w W W A N + O m b W m W Z tH+l V 0 0 0 0 0 0 0 0 n O CITY OF SAN BERNARDINO ESTIMATED REVENUES AND EXPENDITURES MIDYEAR FISCAL YEAR 1999.2000 GENERALFUND VARIANCE FY 1999-00 FY 1999-00 FAVORABLE/ BUDGET MIDYR EST (UNFAVORABLE) ESTIMATED REVENUE: Property Taxes $ 6,993,600 $ 7,151,900 $ 158,300 Other Taxes 42,441,500 43,599,800 1,158,300 Licenses& Permits 5,427,600 5,218,500 (209,100) Fines and Penalties 682,000 665,500 (16,500) Use of Money&Property 1,290,500 1,230,500 (60,000) Intergovernmental 13,388,300 13,906,400 518,100 Charges for Services 3,119,000 3,010,600 (108,400) Miscellaneous 3,343,200 3,281,300 61,900 Total Estimated Revenues $ 76,685,700 $ 78,064,500- $ 1,378,800 Total Transfers In: $ 7,292,800 $ 7,133,500 $ 159,300 TOTAL ESTIMATED FUNDS AVAILABLE: $ 83,978,500 $ 85,198,000. $ 1,219,500 ESTIMATED EXPENDITURES: Mayor $ 655,900 $ 618,855 $ 37,045 Common Council 370,600 360,000 10,600 City Clerk 1,005,800 950,375 55,425 City Treasurer 18,200 18,200 - City Attorney 1,776,000 1,753,900 22,100 Code Compliance 3,019,800 2,516,200 503,600 General Government 2,068,400 2,068,400 - City Administrator 523,400 489,900 33,500 Human Resources 328,500 310,000 18,500 Finance 1,171,600 1,115,800 55,800 Civil Service 274,100 268,811 5,289 Development Services 6,479,300 6,279,300 200,000 Fire 17,973,800 18,228,900 (255,100) Police 36,276,800 35,153,951 1,122,849 Facilities Management 3,182,000 3,045,200 136,800 Parks, Recreation, &Comm Service 4,691,500 4,458,305 233,195 Public Services 2,539,100 2,294,800 244,300 Total.Estimated Expenditures $ 82;354,800 $ 79,930,897' $ 2,423,903 Estimated Vacancy Factor Savings $ 2,500,000 $ - $ 2,500,000 Total Transfers Out: $ 3,165,700 $ 3,158,500 $ 7,200 TOTAL ESTIMATED DEDUCTIONS: 5 $3,020,500 E 83,089,397 $ (68,897) . EXCESS I(DEFICIENCY) OF AVAILABLE.OVER DEDUCTIONS $ 958,000 $ 2,106,603 $ 1,150,603 BEGINNING FUND BALANCE 7-1-99 E 5,278,000 $ 5,278,000 $ ESTIMATED ENDING BALANCE $ 6,236,000 $ 7,386,603 $ 1,150,603 'BUDGETED'RESERVE E 4,127,400 E 4,127,400 E EST UNDESIGNATED BALANCE 6-30-00:1 $ 2,108,600 $ 3,259,203 $ 1,150,603 CITY OF SAN BERNARDINO ANALYSIS OF FY 99- 00 VACANCY FACTOR FY 99-00 FY 99-00 FY 99-00 VACANCY (UNDER)/ BUDGET MIDYEAR UNDER/ FACTOR OVER DEPARTMENT ESTIMATE (OVER) BUD GOAL VAC GOAL MAYOR $ 655,900 $ 618,855 $ 37,045 $ 20,000 $ 17,045 COUNCIL 370,600 360,000 10,600 5,000 5,600 CITY CLERK 1,005,800 950,375 55,425 25,000 30,425 CITY TREASURER 18,200 18,200 CITY ATTORNEY 1,776,000 1,753,900 22,100 25,000 (2,900) CODE COMPLIANCE 3,019,800 2,516,200 503,600 100,000 403,600 GENERAL GOV 2,068,400 2,068,400 CITY ADMIN 523,400 489,900 33,500 20,000 13,500 HUMAN RESOURCES 328,500 310,000 18,500 5,000 13,500 FINANCE 1,171,600 1,115,800 55,800 50,000 5,800 CIVIL SERVICE 274,100 268,811 5,289 2,000 3,289 DEVELOPMENT SVS 6,479,300 6,279,300 200,000 275,000 (75,000) FIRE 17,973,800 18,228,900 (255,100) (255,100) POLICE - 36,276,800 35,153,951 1,122,849 1,393,000 (270,151) FACILITIES 3,182,000 3,045,200 136,800 180,000 (43,200) PARKS & REC 4,691,500 4,458,305 233,195 190,000 43,195 PUBLIC SERVICES 2,539,100 2,294,800 244,300 150,000 94,300 INIMAL CONTROL 1,020,400 945,300 75,100-1 ,000 70,100 .:ATV 343,200 333,304 9,8961 5,000 4,896 LIBRARY 2,747,500 2,747,500 - 50,000 (50,000) TOTAL* $ 86,465,900 $ 83,957,001 $ 2,508,899 $ 2,500,000 $ _ ,:- 8,899 'Code's savings is$180,700 general fund and $322,900 of CDBG demolition money that will be carried over to next year. 'Distribution of Vac Factor: Vacancy Factor to Reserve 1,100,000 Vacancy Factor Bal Budget 1,400,000 Vacancy Factor Excess 8,899 Total 2,508,899 CITY OF SAN BERNARDINO MIDYEAR GENERAL FUND REVENUE REPORT FISCAL YEAR 1999-2000 r ACTUAL I DEC YTD I BUDGET I FY00 REVISED OVER/(UNDER) DESCRIPTION 1998-1999 FY99-00 FY99-00 %COLL FY 99-00 ORIG BUDGET PROPERTY TAXES 4001 Current Secured 6,063,838 2,894,251 6,100,000 47% 6,200,000 100,000 4002 Current Unsecured 386,187 368,304 350,000 105% 378,300 28,300 4003 Prior Taxes 413,666 213,732 400,000 53% 420,000 20,000 4006 Supplemental 75,217 40,292 60,000 67% 60,000 0 4005 Other 86,352 53,665 83,600 64% 93,600 10,000 Total Property Taxes 7,025,260 3,570,244 6,993,600 51% 7,151,900 158,300 OTHER TAXES 4221 Sales Tax 22,433,177 10,455,697 22,500,000 46% 23,520,000 1,020,000 4224 Utility User's Tax 15,092,662 6,569,576 15,000,000 44% 15,000,000 0 4201/15 Franchise Tax 2,016,166 197,629 2,001,500 10% 2,010,500 9,000 4215 Tow Franchise 237,960 159,980 270,000 59% 290,000 20,000 4222 Transient Occupancy Tax 1,892,975 827,867 1,865,000 440/. 1,950,900 85,900 4225 Sales Tax Safety 473,984 223,383 480,000 47% 503,400 23,400 4223 Real Prop. Transfer Tax 350,355 1 93,849 1 325,000 29% 325,000 1 0 Total Taxes 42,497,279 1 18,527,981J 42,441,500 1 44%1 43,599,800 1 1;158,300 =NSES AND PERMITS 4301 Business Registrations 3,823,279 1,513,063 4,000,000 38% 4,021,000 21,000 4330 Building Permits 413,637 189,443 400,000 47% 400,000 0 4331 Mechanical Permits 197,088 99,777 200,000 509/o 200,000 0 4362 On Site Permits 130,114 58,112 146,000 40% 130,000 (16,000) 4363 On Site Plan Check 56,318 22,541 65,000 35% 55,000 (10,000) 4361 Construction Permits 80,627 33,664 70,000 48% 70,000 0 4342 EMS Membership 25,614 20,499 28,800 71% 26,000 (2,800) 4336 Fire Code Permits 109,585 66,540 208,500 32% 133,000 (75,500) 4337 Fire Plan Check 0 6,604 121,000 59/. 25,000 (96,000) 4339 Misc Fire 0 0 17,300 0% 2,000 (15,300) 4351 Street Cut Permits 2,998 5,280 7,500 70% 7,500 0 4333 Mobile Home Park Permits 28,223 2,341 28,000 8% 28,000 0 4352 Misc Licenses & Permits 41,122 20,019 50,000 40% 50,000 0 4303 Misc City Clerk Permits 63,589 17,205 61,500 1 28%1 46,000 (15,500) 4304 Misc Planning Lic/Permit 19,618 11,640 20,000 58% 23,000 3,000 4360 Grading Permits 3,388 470 4,000 12% 2,000 (2,000) Total License & Permit 4,995,200 1 2,067,198 5,427,600 1 8% 5,218,500 (209,100) FINES AND PENALTIES 4420 Parking Citations 535,772 203,169 600,000 34% 550,000 (50,000) 4410 General Fines 83,463 31,352 72,000 449/. 110,000 38,000 0 Fire Citations 4,613 1,150 8,000 14% 3,500 (4,500) � zl Vehicle Abatement 2,725 653 2,000 33% 2,000 0 Total Fines/Penalties 626,573 236,324 682,000 35% 665,500 (16,500) CITY OF SAN BERNARDINO MIDYEAR GENERAL FUND REVENUE REPORT FISCAL YEAR 1999-2000 f ACTUAL I DEC YTD BUDGET TO REVISED OVER/(UNDER) DESCRIPTION 1998-1999 FY99-00 FY99-00 %COLL FY99-00` 1 ORIG BUDGET] USE OF MONEY& PROPERTY 4505 Interest Earnings 780,084 287,820 865,000 33% 865,000 0 4520 Land & Building Rental 224,766 240,694 265,500 91% 265,500 0 4530 Parking Rental Fee 66,617 52,372 70,000 75% 70,000 0 4922 Sale of Property 106,702 3,509 80,000 4% 20,000 (60,000) 4540 Vending Machine Commis 10,107 3,998 10,000 50% 10,000 0 Total Money & Property 1,188,276 589,393 1,290,500 46% 1;230,500 (60,000) INTERGOVERNMENTAL 4603 Motor Vehicle In Lieu 8,376,987 3,371,380 8,400,000 40% 8,875,000 475,000 4621 Booking Fee Subvention 0 689,066 613,700 112% 689,100 75,400 4622 ERAF Subvention 0 410,811 477,400 861/. 462,800 (14,600) 4670 CDBG Reimb. 1,040,599 573,546 2,734,600 21% 2,411,700 (322,900) 4670 20% Reimb. 676,359 4,858 42,800 11% 42,800 0 4670 Tax Increment Reimb. 778,358 207,800 271,400 77% 271,400 0 4606 Homeowner's Exemption 164,018 23,935 175,000 14% 175,000 0 4616 POST 152,447 16,188 130,000 12% 100,000 (30,000) i State-Mandated Costs 219,857 330,869 215,000 154% 450,000 235,000 4b73 Water Reimbursement 179,112 179,212 195,900 91% 195,900 0 4671 SBIAA Reimbursement 89,818 40,590 89,000 46% 89,000 0 4615 Disaster Prep. Program 29,561 0 22,500 0% 20,700 (1,800) 4607 Off-Highway Vehicle Tax 4,964 0 3,000 00/6 3,000 0 4619 Mutual Aid/Disaster Reimb 156,223 30,779 18,000 171% 120,000 102,000 Totallntergovernmental 11,868,303 1 5,879,034 13,388,300 44% 13,906,400 518,100 CHARGES FOR SERVICES 4810 Misc. Develop. Svcs. 24,193 1,687 11,000 15% 3,300 (7,700) 4731 Plan Check Fee 166,983 86,969 197,000 44% 175,000 (22,000) 4880 EMS User Fee 405,130 285,881 400,000 71% 500,000 100,000 4798 Storm Drain Utility Fee 229,862 128,106 275,000 47% 250,000 (25,000) 4815 Weed Abatement 266,198 96,005 250,000 38% 200,000 (50,000) 4733 Building Demolition 704,669 321,200 600,000 54% 600,000 0 4714 Develp Project 71,012 59,109 75,000 79% 100,000 25,000 4305 Annual Alarm Permits 178,512 50,069 150,000 33% 150,000 0 4780 Misc Charges 18,007 8,316 25,000 33% 18,000 (7,000) 4766 Building Permit Review 5,517 719 6,000 12% 3,000 (3,000) 4865 Non-Resident Fees 3,393 1,416 3,500 40% 3,000 (500) 4720 Plan Review Fee 56,142 22,199 60,000 37% 50,000 (10,000) 4864 Swimming Pool Fee 55,638 47,706 58,200 82% 50,000 (8,200) HUD Building Inspection 53,392 16,520 65,000 25%1 30,000 (35,000) a, ,d Environmental 7,586 7,080 10,000 71% 10,000 0 4785 Non Subdivision Str Imp 48,933 3,606 50,000 7% 10,000 1 (40,000) 4863 Class Registration Fee 14,771 1 5,371 15,000 36% 12,000 T (3,000) CITY OF SAN BERNARDINO MIDYEAR GENERAL FUND REVENUE REPORT FISCAL YEAR 1999-2000 I ACTUAL DEC YTD I BUDGET I FY00 REVISED OVER/(UNDER) DESCRIPTION 1998-1999 1 FY99-00 FY99-00 %COLL FY 99-00 ORIG BUDGET 4711 Subdivision 83,954 24,019 75,000 32% 60,000 (15,000) 4862 Park Energy Fee 17,461 10,241 32,000 32% 25,000 (7,000) 4707 Passport Fees 42,461 27,776 90,000 31% 70,000 (20,000) 4702 County Contract 100,000 0 250,000 0% 250,000 0 4861 Program/Facility Use Fee 30,160 11,034 26,000 42% 23,000 (3,000) 4710 Misc. Development Servs 36,796 14,175 22,000 64% 30,000 8,000 4743 Towing Release Fee 131,620 93,480 150,000 1 62% 150,000 0 4705 Utility Collection Fee 21,288 0 36,000 0% -0,000 (6,000) 4782 Public Wk Subdivision 76,378 4,390 12,000 37% 10,000 (2,000) 4790 Signal Maint/Energy Fee 101,069 21,354 10,000 214% 30,000 20,000 4802 Str Light Energy Fee 19,385 0 12,000 0% 12,000 0 4701 Election Filing/Copies 860 7,122 4,000 178% 7,400 3,400 4747 False Alarm Fee 37,157 47,243 80,000 59% 100,000 20,000 4735 Release Pendency Notice 0 0 50,000 0% 20,000 (30,000) 4881 Paramedic Reimb Contrac 0 16,070 19,300 83% 28,900 9,600 Total Charges 3,008,5271 1,418,8631 3,119,000 45% 3,010,600 (108,400) MISCELLANEOUS )6 Water Fund Contr. 1,423,321 607,668 1,375,000 44% 1,425,000 50,000 4a10 Admin Service Charge 410,539 404,400 410,500 999% 404,400 (6,100) 301 Misc. Other Revenue 517,781 17,089 811,200 2% 611,200 (200,000) 4912 Off Track Betting 171,596 77,418 170,000 46% 170,000 0 4741 Sale of Photos 76,435 44,333 75,000 59% 80,000 5,000 4740 Police Misc. Receipts 488,000 408,794 434,200 94% 450,000 15,800 4746 Property Auction 6,726 7,592 15,000 51% 10,000 (5,000) 4911 Restitutions 23,240 4,546 600 758% 8,500 7,900 4905 Litigation 21,229 49,286 25,000 197% 55,000 30,000 4904 Drunk Driver Reimburmt. 4,258 1,838 4,200 44% 4,200 0 4903 Refunds & Rebates 0 0 0 0% 0 0 4928 Booking Fee Reimb. 10,340 7,837 5,000 157% 15,000 10,000 4750 Investigation Fee 13,075 6,012 11,000 55% 15,000 4,000 4924 Damage Claim Recovery 13,602 15,375 6,500 237% 33,000 26,500 Total Miscellaneous 3,180,142 1,652,188 3,343,200 49% 3,281,300 (61,900) TOTAL GENERAL FUND 74,389,560 1 33,941,225 76,685,700 1 44%1 78,064,500 1 1,378,800 CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 1999-2000 ACTUAL ACTUAL ACTUAL BUDGET MID-YR EST DESCRIPTION 1996-97 1997-98 1998-99 1999-00 1999-00 105 LIBRARY FUND 4618 State Aid-Libraries 133,084 187,701 214,651 219,000 311,700 4850 Miscellaneous Recei is 12,564 11,749 11,885 25,000 15,000 4851 Library Fines 53,725 58,173 55,476 76,000 60,000 Total Library Fund 199,373 257,623 282,012 320,000 386,700 106 CEMETERY FUND 4505 Interest on Idle Cash 27,780 24,944 21,517 25,000 25,000 4775 Cemetery Burial Fee 71,093 72,278 64,171 71,000 70,000 4776 Sale of Vases 1,955 1,856 1,854 2,000 2,000 4777 Sale Concrete Boxes 32,096 33,363 27,953 33,000 28,000 4778 Sale Cemetery Plots 51,567 59,212 57,893 60,000 55,000 Total Cemetery Fund 184,491 191,653 173,388 191,000 180,000 107 CABLE TV FUND 4505 Interest on Idle Cash 4,386 1,403 173 0 0 4670 Economic Development Reimb. 0 35,451 0 0 0 4922 Sale of Equipment 70,483 936 113,414 90,000 115,000 Total Cable TV Fund 74,869 37,790 113,587 90,000 115,000 108 ASSET FORFEITURE FUND 4505 Interest on Idle Cash 10,066 9,019 8,472 10,000 8,500 4672 Asset Forfeiture Federal DOJ 16,909 17,997 131,058 0 1,800 4927 Asset Forfeiture 35,490 120,015 100,325 21,300 115,000 4929 Asset Forfeiture-Drug/Gang 6,030 20,060 16,797 3,800 17,900 Total Asset Forfeiture Fund 68,495 167,091 256,652 35,100 143,200 109 PARKING/BUSINESS IMPROVMT FD 4302 Parkin /Business Im rovement 141,386 130,931 116,661 130,000 130,000 4505 Interest on Idle Cash 1,182 1,419 957 1,000 1,000 Total Parkin /Business Fund- 142,568 132,350 117,618 131,000 131,000 110 PARKING DISTRICT FUND. 4010 Special Assessment-Land 152,519 8,703 60,968 58,000 58,000 4011 Special Assessment-Phase 11 29,902 1,767 3,766 0 1,900 4505 Interest on Idle Cash 4,804 3,224 929 2,100 1,200 4530 Rental Fee-Parking 9,538 3,607 1,588 0 1,700 4670 Economic Development Reimb. 39,097 143,312 148,706 158,100 158,100 Total Parking District Fund 235,860 160,613 215,957 218,200 220,900 111 TRANSPORTATION FUND 4505 Interest on Idle Cash 27,232 13,509 5,119 6,500 6,500 4626 Rideshare Reimbursement 194,307 195,392 199,637 180,500 203,400 4670 Economic Development Agency 0 12,151 0 0 0 4916 Van Pool Contributions 2,861 3,000 0 0 0 4906 Water Department 3,000 995 3,000 3,000 3,000 Total Transportation Fund 227,400 225,047 207,756 190,000 212,900 122 ARTICLES -LTF 83,291 1 87,4321 0 1 115,000 175,000 124 ANIMAL CONTROL FUND 4320 Animal License 141,047 153,282 132,553 250,000 197,000 4352 Misc. License& Permits 532 2,000 1,000 1,000 1,500 4410 General Fines 20,637 20,706 20,344 22,500 8,000 4430 Animal License Penalty 12,940 26,799 19,487 20,000 25,000 4756 Animal Adoption Fee 9,644 13,013 15,542 14,000 16,000 4757 Contractee Shelter Fee 362,361 445,302 413,222 425,000 425,000 CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 1999 -2000 ACTUAL ACTUAL ACTUAL BUDGET. MID-YR EST DESCRIPTION 1996-97 1997-98 1998.99. 1999-00 1999-00 4758 Livestock Fee 740 965 2,038 1,000 1,000 4759 Apprehension Fee 25,044 24,588 22,355 24,000 10,000 4760 Board Fee 22,479 21,352 22,328 21,000 10,000 4761 Field Service Fee 1,961 1,605 1,629 1,800 1,000 4763 Owner Release Fee -21,374 21,259 24,466 34,900 32,000 4764 Vaccination Fee 9,124 9,790 10,284 9,500 9,500 4765 Microchip Fee 1,163 0 0 2,000 0 4901 Miscellaneous Receipts 4,627 18.013 17,350 18,000 18,200 Total Animal Control Fund 633,673 . 758,674 702,598 844,700 754,200 126 SPECIAL.GAS TAX FUND 4505 Interest on Idle Cash 71,761 73,346 12,137 35,000 18,000 4610 State Aid-2106 647,184 734,246 730,316 750,000 750,000 4611 State Aid-2107 1,533,085 1,503,320 1,481,603 1,550,000 1,550,000 4612 State Aid-2107.5 10,000 10,000 10,000 10,000 10,000 4614 Prop 111-Highway Users Tax 1,092,404 1,109,801 1,143,737 1,050,000 1,150,000 4945 Reimbursement 165,544 251,808 0 38,000 38,000 Total Gas Tax Fund 3,519,978 3,682,521 3,377,793 3,433;000' ''-3,516,000 527 REFUSE FUND -9505 Interest on Idle Cash 59,535 9,035 1,064 0 1 0 4830 Commercial Rubbish 249,098 236,067 396,141 420,000 420,000 4831 Commercial Bin Rent 398,487 427,169 208,507 0 82,700 4832 Commercial Bin Service 4,930,406 4,928,314 6,128,380 6,517,900 6,517,900 4833 Commercial Special 474,476 603,120 600,462 796,000 500,000 4836 Commercial Bin Service-Malls 79,929 87,147 18,678 0 200 4837 Automated Commercial Rubbish 50,753 59,737 46,163 47,500 44,200 4840 Residential Water Billed 6,066,917 6,064,788 6,747,000 6,652,800 6,800,000 4841 Residential"B"Accounts 364,034 439,582 475,075 528,000 500,000 4842 Residential Specials 0 4,904 7,206 5,400 6,000 4843 Dino Bin Service 1,157,421 1,113,217 1,216,057 1,357,900 11273,000 4849 Sale of Paper/Salvage Material 1,604 0 23,643 0 0 4901 Miscellaneous Other Revenue 33,056 49,462 62,098 50,000 45,000 4903 Refunds and Rebates 10,477 20.897 25 0 0 4923 Sale Salvage Mater 3,241 20,319 0 0 0 .:�Total.Refuse Fund 13,879,434 14,053,758 15,930,499 16,375,500 16,189,000. 1128T FFICSAFETY FUND. 4440(;V(; Fine 1 32,738 1 217,981 11 743,639 1 600,000 745,000 •:.Total Traffic batety Fund 1 32,738 217,981 743,639 600,000 1 745,000 129 1/2 CENT SALES/ROAD TAX FUND 4505 Interest on Idle Cash 126,840 153,135 88,858 120,000 100,000 46131/2 Cent Sales Tax 1,561,591 1,686,253 1,777,820 1,700,000 1,800,000 4627 Measure I Arterial 0 0 0 0 0 4945 Construction Reimbursement 21,466 0 0 0 0 Total 1/2 Cent Sales Tax . 1,709,897 1,839,388 1,866,678 1,820,000- 1,900,000 131 SB 300 4653 SB 300 0 0 46,994 0 1 0 4945 Street Construction 0 0 0 0 0 131 SB 300 0 0 46,994 - : 0 0 CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 1999-2000 ACTUAL ACTUAL- ACTUAL BUDGET MID-YR EST DESCRIPTION 1996-97 1997-98 -1998-99 1999-00 1999-00 132 SEWER LINE MAINTENANCE 4505 Interest on Idle Cash 68,907 93,053 69,940 80,000 80,000 4820 Sewer Line Maint 1,300,603 1,284,585 1,331,664 1,300,000 1,300,000 Total Sewer Line Maintenance . 1,369,510 . 1,377,638 1.401,624 - 1,380,000 1,380,000 133 BASEBALL STADIUM 4520 Land/Buildin Rental 10,000 10,750 21,425 114,000 124,200 4901 Baseball Team Lease A reement 42,326 106,864 144,458 85,900 115,300 Total Baseball Stadium - 52,326 11 f,4514 1 165,8831 199,9001 239,500 242 STREET CONSTRUCTION FUND 4630 State Aid-Street Constr. 162,912 6,804 0 2,126,500 669,000 4658 Federal Aid-FAU 2,572,979 6,050,710 3,193,835 16,252,500 744,500 4901 Miscellaneous Receipts 0 0 0 0 0 4945 Construction Reimbursement 811,246 1,049,951 866,407 683,000 200,000 Total Street Constr. Fund 3,547,137 7,107,465 4,060,242 .19,062,000 1,613,500 243 PARK CONSTRUCTION FUND 4505 Interest on Idle Cash 43,157 29,751 19,011 26,000 24,000 4901 Miscellaneous 0 0 0 0 0 4732 Park Development Fee 56,820 144,719 159,903 140,000 140,000 4945 Construction Project Reimb. 0 0 82,000 10,000 10,000 Total Park Construction Fund 99,977 174,470 260,914 176,000 .174,000 244 CEMETERY CONSTRUCTION FUND 4505 Interest on Idle Cash 707 762 388 500 500 4778 Sale Cemetery Plots 4,213 3,781 3,840 3,500 1 3,500 Total Cemetery Constr. Fund 4,920 4,563 1 4,228 4,000 4,000 245 SEWER LINE CONSTRUCTION FUND 4505 Interest on Idle Cash 180,271 205,606 138,471 200,000 200,000 4821 Sewer Lateral Fee 120 1,619 13,292 2,000 2,000 4822 Sewer Connection Fee 78,921 I 166,677 I 179,252 1 160,000 1 160,000 Total Sewer Line Constr. Fund 259,312 375,902 331,015 362,000 362,000 246 INDIAN BINGO SETTLEMENT FUND 4505 Interest on Idle Cash 14,187 17,654 10,308 12,000 12,000 4902 Indian Bingo Contribution 0 0 0 p O 4945 Reimburse Street Construction 281,906 0 0 0 0 Total Indian Bingo Fund _ 296,093 17,654. 10,308 12,000 12,000 247 CULTURAL DEVELOP FUND 4335 Cultural Devel. Constr. Fee 34,908 95,758 66,397 75,000 75,000 4505 Interest on Idle Cash 542 2,027 (429) 1,000 500 Total Cultural Devel Const Fund 35,510 97,785 65,968 76,000 75,500 248 STORM DRAIN CONSTR FUND 4505 Interest on Idle Cash 114,404 112,423 54,960 115,000 60,000 4818 Storm Drain Fee 224,590 374,688 407,413 330,000 330,000 4945 Construction Reimbursement 1,530,150 45,600 0 0 0 Total Storm Drain Constr, Fund 1;869,144 532,711 462,373 445,000 390,000 CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 1999 -2000 ACTUAL ACTUAL ACTUAL BUDGET MID-YR EST DESCRIPTION 1996-97 1997-98 1998-99 1999-00 1999-00 250 TRAFFIC SYSTEMS CONSTR FUND 4505 Interest on Idle Cash 4,236 731 4,630 2,700 2,700 4658 Fed/State Aid-Street Construction 432,190 96,849 0 0 0 4803 Traffic System Fees 91,539 331,056 265,785 165,000 165,000 4945 Reimburse St Constr (14,001) 12,083 14,000 70,000 70,000 Total Traffic Systems Fund 513,964 440,719 284,415 237,700 =s"-. 237,700 257 CITY WIDE AD 994 4057 AD 994 4,298,242 414,201 179.758 100,000 100,000 4910 Administrative Service Charges 93,303 0 1 0 1 0 0 Total City Wide AD 994 4,391,5451 414,201 179,758 100,000 100,000 621 CENTRAL SERVICES FUND 4897 Interdepartmental 250,007 252,559 237,729 263,900 263,900 Total Central Services Fund 250,007 252,559 237,729 1 263,900 1 263,900 629 LIABILITY.INSURANCE FUND 4505 Interest on Idle Cash - 320,485 140,007 177,220 300,000 300,000 4670 Economic Development Agency 80,000 80,000 30,000 30,000 0 46711VDA/SBIAA 0 0 0 0 0 4897 Interdepartmental Receipts 2,057,000 1,950,566 1,871,200 1,822,700 1,822,700 4901 Misc. Receipts 0 36,376 0 0 0 4906 Water Department 0 0 0 0 0 4924 Damage Claim Receve 141014 1,987 0 0 0 Total Llabili Insurance Fund 2,471,499 2,208,936 1 2,07420 2,152,700 1 2;122,700 630 TELEPHONE SUPPORT FUND 4541 Telephone Commission 28,459 14,414 12,692 16,000 16,000 4893 Water Dept. Receipts 80,215 87,247 99,085 154,700 145,000 4670 Economic Development A enc 101,665 87,516 50,138 33,200 10,000 4897 Interdepartmental Receipts 696,180 526,320 540,711 607,800 600,000 4903 Refunds and Rebates 10,758 29,825 14,452 10,000 17,400 Total Telephone Support Fund 917,277 745,322 717,078 821,700 788,400 631 UTILITY FD-INTERDEPT RECEIPTS 3,426,3551 3,439,1161 3,110,213 1 3,205,000 3,258,300 635 FLEET SERVICES FUND 4670 EDA 0 6,936 9,380 10,700 0 4896 Replacement Contribution 760,019 531,300 539,900 481,400 481,400 4897 Interdepartmental Receipts 3,749,416 3,845,990 4,228,950 4,150,700 4,482,200 4901/22 Misc, Or Receipts (31,446) (141,595) 0 0 0 Total Motor Pool the Fund 4,477,989 4,242,631 4,778,230 4,642,800 4,963,600 678 WORKERS'COMPENSATION FUND 4505 Interest on Idle Cash 0 0 0 0 0 4897 Interdepartmental Receipts 2,188,557 2,066,777 2,034,086 1,985,400 1,985,400 4899 Premiums 134 4,471 0 0 0 4670 Economic Development Agency 0 0 0 10,000 0 4901 Misc Receipts 0 0 0 0 15,000 4906 Water Department 478,756 545,653 381,343 375,000 375,000 4924 Damage Claim Recovery 80,669 0 0 0 0 Total Workers'Compensation Fd 2,748,116 2,616,901 2,415,429 1 2,370,400 7375,400 CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 1999-2000 ACTUAL ACTUAL ACTUAL -BUDGET MID-YR EST DESCRIPTION 1996-97 1997-98 1998-99 1999-00 1999-00 679 Management Information Services 4505 Interest on Idle Cash 4,301 0 0 0 0 4670 EDA Reimbursement 1,350 1,206 645 500 26,000 4673 Water 0 0 385,000 461,900 451,900 4897 Interdepartmental Receipts 2,163,200 2,092,329 2,621,946 2,682,000 2,682,000 4901 Miscellaneous Receipts 655 616 343 700 700 4922 Sale of Equipment 0 0 450,000 0 0 Total MIS Fund 2,160,904 2,094,151 3,457,934 3,145,100 3,170,600 GRAND TOTAL 49,883,652 1 48,072,259 1 48,056,932 63,019,700 46,140,000 CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1999-2000 TRANSFERS - IN VARIANCE FY 1999-00 FY 1999-00 FAVORABLE/ BUDGET MIDYR EST (UNFAVORABLE) TO GENERAL FUND: "From Special Gas Tax For- 2,690,100 2,690,100 0 Street Maintenance-$2,320,000 Street Lighting -$370,100 'From Traffic Safety For- 600,000 745,000 145,000 Police Costs 'From 1/2 Cent Sales & Road Tax For- 190,700 190,700 0 Administration "From Cultural Development Fund For- 76,000 75,500 (500) Funding Fine Arts and Civic and Promotional Costs 'From Traffic Systems Constructions For- 25,000 25,000 0 Administration 'From Parking District For- 66,600 66,600 0 Debt Service Payment `From AD 994 Fund For- 200,000 200,000 0 Street Lighting and Signals 'From Liability Fund For- 500,000 500,000 0 Refund Reserve Excess "From Storm Drain Construction For- 100,000 100,000 0 Administration "From Telephone Support For- 16,000 16,000 0 Telephone Commission & Rebates 'From Refuse Fund For- 1,831,200 1,831,200 0 Administration $1,326,200 Lease City Yards 464,000 Lease City Hall 41,000 'From Sewer Line Construction For- 100,000 100,000 0 Administration "From SB 300 For- 10,000 6,200 (3,800) Administration "From Sewer Line Maintenance Fund For- 100,000 100,000 0 Administration CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1999-2000 TRANSFERS - IN VARIANCE FY 1999-00 FY 1999-00 FAVORABLE/ BUDGET MIDYR EST (UNFAVORABLE) 'From Utility Fund For- 300,000 0 (300,000) Refund Reserve Excess 'From MIS Fund For- 300,000 300,000 0 Refund Reserve Excess 'From Transportation Fund For- 187,200 187,200 0 Traffic Engineering Costs $50,000 Maint/Fuel for Alt. Fuel Veh $31,500 Crossing Guards $105,700 TOTAL GENERAL FUND $7,292,800 $7,133,500 (159,300) TO ANIMAL CONTROL FUND: From General Fund For- 162,800 186,100 23,300 Operating Costs TO CATV FUND: From General Fund For- 248,800 218,300 (30,500) Operating Costs TO LIBRARY FUND: 'From General Fund For- 2,352,600 2,352,600 0 Operating Costs TO PUBLIC PARK EXTENSION: 'From General Fund For- 51,500 51,500 0 Park Facilities Improvements TO REFUSE: "From General Fund For- 75,000 75,000 0 Street Sweeping TO EMS FUND: 'From General Fund For- 75,000 75,000 0 Repay Operating Loan TO BASEBALL STADIUM: "From General Fund For- 200,000 200,000 0 Operating Costs TO PARKING DISTRICT: 'From Parking & Business Impr For- 98,200 98,200 0 Administration TOTAL OTHER FUNDS $3,263,900 $3,256,700 (7,200) GRAND TOTAL TRANSFERS-IN $10,556,700 1$10,390,200 (166,500) CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1999-2000 TRANSFERS -OUT VARIANCE FY 1999-00 FY 1999-00 FAVORABLE/ BUDGET MIDYR EST (UNFAVORABLE) FROM GENERAL FUND: *To Anima; Control Fund For- $162,800 186,100 (23,300) Operating Costs *To Library Fund For- 2,352,600 2,352,600 0 Operating Costs *To CAN For- 248,800 218,300 30,500 Operating Costs *To Baseball Fund For- 200,000 200,000 0 Operating Costs *To EMS Fund For- 75,000 75,000 0 Operating Costs *To Refuse Fund For- 75,000 75,000 0 Street Sweeping *To Public Park Extension For- 51,500 51,500 0 Park Facilities Improvements - TOTAL GENERAL FUND i $3,165,70-0t-$3,158,500 i 7,200 FROM TELECOMMUNICATION FD: *To General Fund For- 16,000 16,000 0 Telephone Commission & Rebates FROM SPECIAL GAS TAX: *To General Fund For- 2,690,100 2,690,100 0 Street Maintenance Costs FROM TRAFFIC SAFETY: *To General Fund For- 600,000 745,000 (145,000) Police Costs FROM 1/2 CENT SALES/ROAD TAX: *To General Fund For- 190,700 190,700 0 Administration of Fund $164,000 FROM AD 994: *To General Fund For- 200,000 200,000 Street Light and Signals FROM PARKING & BUSINESS IMPR *To Parking District For- 98,200 98,200 0 Administration of District CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1999-2000 TRANSFERS - OUT VARIANCE FY 1999-00 FY 1999-00 FAVORABLE/ BUDGET MIDYR EST (UNFAVORABLE) FROM PARKING DISTRICT FUND 'To General Fund For- 66,600 66,600 0 Debt Service Payment FROM CULTURAL DEVELOPMENT 'To General Fund For- 76,000 75,500 500 Fine Arts &Civic Promotional Costs FROM TRAFFIC SYSTEM CONSTR `To General Fund For- 25,000 25,000 0 Administration of Fund FROM SB 300 'To General Fund For- 10,000 6,200 3,800 Administration of Fund FROM STORM DRAIN FUND `To General Fund For- 100,000 100,000 0 Administration of Fund FROM REFUSE FUND 'To General Fund For- 1,831,200 1,831,200 0 Administration $1,326,200 Lease City Yards $464,000 Lease City Hall $41,000 FROM SEWER LINE CONSTR FD `To General Fund For- 100,000 100,000 0 Administration FROM SEWER LINE MAINT FUND 'To General Fund For- 100,000 100,000 p Administration FROM UTILITY FUND `To General Fund For- 300,000 0 300,000 Refund Reserve Excess FROM LIABILITY FUND 'To General Fund For- 500,000 500,000 0 Refund Reserve Excess FROM MIS FUND 'To General Fund For- 300,000 300,000 0 Refund Reserve Excess CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1999.2000 TRANSFERS - OUT VARIANCE FY 1999-00 FY 1999-00 FAVORABLE/ -. BUDGET MIDYR EST (UNFAVORABLE) FROM TRANSPORTATION FUND 'To General Fund For- 187,200 187,200 0 Traffic Engineering Costs $50,000 Maint/Fuel for Alt. Fuel Veh $31,500 Crossing Guards $94,500 TOTAL OTHER FUNDS $7,391,000 $7,231,700 159,300 GRAND TOTAL TRANSFERS-OUT $10,556,700 $10,390,200 166,500 CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION From: Barbara Pachon Subject: Mid-Year Budget Director of Finance Amendments Fiscal Year 1999-2000 Dept: Finance Date: 3/20/00 Synopsis of Previous Council Action: 7/6/99 Resolution 1999-167 approving and adopting the Final Budget for FY 1999-2000 2/23/00 FY 1999-00 Mid-Year Budget Report referred to full Council by Ways & Means Committee. 3/6100 FY 1999-00 Mid-Year Budget Report received and filed by Mayor and Common Council Recommended motion: That the Director of Finance be authorized to amend the FY 1999-00 Budget as outlined in the attached staff report. Signature Contact person: Barbara Pachon, Director of Finance Phone: 5242 Supporting data attached: staff report Ward: FUNDING REQUIREMENTS: Amount: N/A Source: (Acct No (Acct. Descriptlon) Entered intolRecard at Finance: nuacillCmyDevCms Mtg: . Council Notes: by re Agenda Item City u± San 8drnardino 64-1 031>100 STAFF REPORT Introduction The FY 1999-00 Mid-Year Budget Analysis report was presented to the Ways and Means Committee on February 23, 2000. Outlined in the accompanying staff report were a number of issues that were brought to the forefront during the Mid-Year Budget Review process. The purpose of this staff report is to address the budgetary impact of those issues and present recommendations in one consolidated report. These adjustments do not change the ending fund balances proiected in the Mid-Year report. The recommendations were factored into the Mid-Year Report estimates; the recommendations below are to formally amend the budget to match the assumptions made during the Mid-Year review process. The issues in this report are organized by department. Fleet Division Fuel Charges The Fleet Division indicated in their Mid-Year Budget submittal that they would exceed their fuel budget by approximately $300,000. According to the Director of Public Services, the average price of unleaded fuel at Mid-Year 1999-00 was $1.12, which is approximately 31% higher than the average price for FY 1998-99. Based on industry analyst information, Fleet predicts that the average price of fuel could increase up to another 20% by the end of the fiscal year. Based on Fleet's estimates, it is recommended that the Fleet line item for fuel (635-341-5113) be increased by $330,000. Because Fleet is an internal service department, the increase in fuel charges is charged directly back to the user departments. Departments with large fleets, such as the Police Department and the Refuse Division will be most impacted. $115,000 of the $300,000 will come from the Refuse Fund. Savings in Refuse Fund's debt service line item will be transferred to the fuel line item. The use of these savings for increased fuel costs was already factored into the Mid-Year report. Similarly, the Animal Control Fund fuel budget will be increased by $6,000 and the Sewer Fund fuel budget will be increased by $4,000. Animal Control is utilizing salary savings to offset this increase and the Sewer Fund is utilizing savings in the materials and supplies line item. The Police department is the General Fund department most impacted by increasing fuel costs. They will utilize $114,000 in salary savings to offset their anticipated fuel costs. The following General Fund Departments will also utilize salary savings to offset increased fuel costs (as was assumed in the Mid-Year report expenditure analysis): Development Services ($11,000); Fire ($17,000); Facilities Management ($4,000); Code Compliance ($4,000); Parks & Recreation ($11,000); and Public Services ($14,000). It is projected that the General Fund will still meet the budgeted vacancy factor overall after these amendments are approved. 1 Garage Charges: It appears that the Police Department will be over budget on garage charges by approximately $90,000. It is recommended that the Police Department budget be amended and salary savings be utilized to offset the increased garage maintenance charges. Use of salary savings to offset increased fuel costs was factored into the Mid- Year Report. Fire Department Based on past year's history, and the first six months of this fiscal year, it appears that the Fire Department will be over budget by approximately $255,100. The biggest factor contributing to this overage is the high rate of overtime usage. Based on discussions with the Fire Department, it is estimated that the Fire Department will be over their overtime budget by approximately $578,000. This assumes that the usage rate for the second half will be slightly lower (as it has been in prior years). Also, according the Fire Department, $115,000 of the overtime in the first of half of FY 99-00 was attributed to the mutual aid response to the Willow Fire in the Apple Valley area this past fall. The Fire Department does have some vacancies and savings in other areas that will offset this overage of $578,000 by $322,900. Therefore a net increase to the Fire Department budget of $255,100 is anticipated at this time. This estimate was factored into the Mid-Year Report. Police Department In order to track grant expenditures more consistently, all Police Department positions funded by grant funds will be moved into the Police Department's General Fund budget. A corresponding credit will also be budgeted to reflect the amount of the expenditure to be transferred to the grants. This is an accounting change only; there is no net impact to the General Fund or the Police Department's budget. Mayor's Office The Mayor's Office reorganized in August of 1999 and as part of the reorganization included $13,500 for a part-time typist clerk position. The Mayor's Office has been using a temporary agency to fill this position so funds budgeted in part-time salaries need to be moved to the contractual line item since we are paying through an agency, and not paying an employee through payroll. This is an accounting/classification change and there is no net impact to the General Fund. Code Compliance During the FY 1999-00 budget preparation process, Code Compliance was allocated $731,700 in CDBG funding for demolitions. At that time Code Compliance and EDA agreed to let EDA administer $200,000 of the $731,700 and did not include this $200,000 in the Code Compliance's FY 1999-00 budget. Since that time, Code Compliance staff and EDA have determined that $100,000 of the $200,000 should be administered directly by Code Compliance. Additionally, at the 10/18/99 Council meeting, the Mayor and Common Council reallocated an additional $200,000 for Code Compliance demolitions. 2 Combined, these two decisions will increase Code Compliance's demolition budget by $300,000. The budget will also be amended to reflect the $300,000 to be received in revenue reimbursement from EDA, so the net impact to the General Fund is zero. Code Compliance does not anticipate that they will expend all of these funds this fiscal year and will request to carry them over to the next fiscal year. Refuse Fund The Refuse Division utilizes the services of part-time interns to work on recycling projects. $15,000 was included in the Refuse Division's professional contractual budget line item for this expense. However, funds for interns are more appropriately classified as part-time salaries, therefore the $15,000 should be moved to this line item. Additionally, Refuse has identified some grant funds that intern time can be charged to, so a credit in the amount of $15,000 will also be budgeted to reflect this. This is an accounting/classification change that will have no net impact to the Refuse Fund. Sewer Line Maintenance Fund The Sewer Line Maintenance Division utilizes the services of part-time interns to work on special projects. $5,000 was included in the Sewer Line Maintenance Division's professional contractual budget line item for this expense. However, funds for interns are more appropriately classified as part-time salaries, therefore the $5,000 should be moved to this line item. This is an accounting/classification change that will have no net impact to the Sewer Line Maintenance Fund. CAN Per Diem Employees As part of their budget reduction plan during the FY 1999-2000 budget process, CAN eliminated a number of part-time positions and one full time position and decided to contract with per diem employees as needed on special projects. CAN staff now anticipates that they will have more revenue generating contracts than expected and will need to increase their per-diem budget accordingly to accommodate these contracts. $12,000 in salary savings from a vacant position will be transferred to the per-diem line item to cover the cost of per-diem employees for the year. Programming Equipment CAN also purchased $5,300 in equipment required to facilitate the splitting of programming on Channel 3. The equipment was paid out of savings in the CATV materials and supplies line item. These items are more appropriately classified as capital outlay. This is an accounting/classification change only; the expenditure was factored into the Mid-Year budget projections. Recommendation That the Mayor and Common Council authorize the Director of Finance to amend the FY 1999-2000 budget as outlined in the staff report. 3 A A A A A A A A A A A A A A s m nmD O � tpO �° om000 � o . 00 m T M j I O O O O " O O O O O O w N - c � v r c r -n c ON -or -' KKm 35 w w A YmaQ quo °' ofDi �'t017 � mNm � 3 m 0 Nw3m om `� � rn'odmmmOm 9 �pM CD m m ° dp m � t�m � � �io 3 a A a m n n � oM (p D z O co _ C> y 3 � NZI 00 N N@ o TL , m — O o � N w - 3 � � mm° (D CD m � av n � z D n c 3 m c Z < o W a n m o > ? ? m m 3 3 fC N C] Q t> O N O 3 N o. .Zl (D O w C f1 NC r� Q3 Nam W� o 2 w Q N cD w O Q C N w O N 1p N y N � � O w z A p N O to w 71 CL a 0 o 000 i 0 AA � N A 1OW OD � w O d owi T OOJ 0 JA ' O N ANA wrn CO � Omwo) 9Dpp 0A0 0. 8 0 O Z IN °' o � 3 � n3 ci oorn o o om c A 0 0 3 .. aw g - T { o n x n O -0. A c Nm w o w ) w 1C11 c' .0. 3 Ww W m j W N J fA yjTf TOW T O W N A , fO NACp OD _ , D m m a g t�. 3 O 3 y ; m 41 W O % N 0-0 OV N VA W� J Nm am Oi I W90 A M 3 T �OpN AI9J O V OO W G C w f C 0 0o coo � ao co cn -• � � oww � 000 a � y m 3 j � 3 m to c N + W OC O _OwD AN W -0c0 Ncw0 OD W N W � O 0 O O w ow O W W Vt N W A c0 O IV A O w 0 N 001 10 c00 W c011 O N tcpp O N O V A O J C AO V J � OODO w AONCO O W ONON0 OON W 000 01 W a) 6A 01w W mJ �I W W O ( O 4 pp + N V NAN W N0 J US 0 0 o e e o o w O co D 1 o /A-/o v O O m m m m m m m m m m m m m m m m Z 1 N N N N N N N N N N N m m O N N O O O O O O O - 0 0 0 0 ppO O O O O O - - - - - - - - - - - O O O O O O O O O m x '� O W JmN AN + OtDm V N A W N + Z -11 - 00 -4004' OMM 3 m m a t'n m m c o n c c0 m 3 of ' o m D ° m d 3 r c c w OZ � q � 3ccm � Q < � � � 0 < ° 3 � -to aR� U0 CD CDU 3 (? 33N m ° g � o33z �. z1 o °12m � 0 � �" �,:`° mm °l- mo� a »'. z ym � og = SmOVO3r� � A 0m � 3 A -� @o . z 03 3mdm3 < fDTym cn3 ° mho cn ' rm- zp Dmdom3 cmy o � m m 'm v � � Q ro m K m m � '� � D ' m < 0 m 30. (D w �' o.o � c (2� 3m rv, cm `gym � CD00 N N N 'O N V G 7 A TJ C y C y C (j('11 `G z O CD N N �1 N fD ry N1 N .�. O0 m N m CO o �D 3 a m > 0 m o 3 3 5 0 A CD d 0 0 N ° 3 0 + O t0 a t0 v to .NOOOOOAA OO O Omi 0 W 0 N0N0 m 0000000 J tJT +O] O W + 0) m� 0 N W OONN COO W 0JOJ 0 w m m OOA 0) O »W o O N tm00 A woo ow N A 0 tm O O tO �mNN+ + N A(.� W V 00 N + NA NIr(� Op� mODAO + tD d w m � O W mw A ODIAm W W Jm tO 0 " NW — W � m W OmNA (OJIOm W mC NI( W jOON � Ow W m O W W (mT V A O m OpD m V N (NO�t V T 0 0 0 0 O + m + NOt NAV A V O O N O O t]mD m 0 W N A G N V + + AtOOmA NN W OtOmOA + LOON V ' t9 C� W AAA W m A A + N A N W A W + A W m A .21 (44 A A m W O V t W O + N J A N O O J O J O N N m Y O N V V N NN4NlN Om+ m tO m V W W � tOOm J m OD fW n cm00O0O 0N m W m O m . W " W O0W O -40 w 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o e e e e o 0 0 0 0 o e e e o e e O -i m m m m m m 0) &) T w � rnm O OD J p Vp J V O fT p 1 W A W O O 00 00) 0 0 rD- c c � � � � a � 0 c rr -0n -1 � g Co W C-1) 0 0°p0 ooc � � a o � � 0B � P = K oaaa Pxx & m' � � d � � N N N f0 0 d ' j � CO a • c N Z ~ y > 0 C ' 0 3 ' m 3 3 m v < CD 0 0 m 0 > > _ 0 < m 3 d 0 w 0 n m N N O � -4 tD A � � � � � � � O D O O O N O O 0O 0O O S O O CO O n O O 0 � 0 W f00 A�A V�W m N N 10 O�W OND�N f00 ��� (NT V�O�D f00 d O J O O J W O O W M OD W W � d OD J Ut10 mIOWNN OD W NIA WIVm O IrO I _O m�t00) dO t0 V W W � O N N m aD (T IrN N J G� N A N W n N m m DD O cn o Gt tD A A O O AW 2. tD A N O 01 A 0 O W W O W O O m m J 0 N A J N V7 O V OO OD Otil (D NN V V � O AEON W N � R A N N TO) W W W Jw O T W w 0) 0 0) W W W (O 0 O --j tO 0 � W y V J JNO " A O) JJ NV7A W IJ JN W f0 ut m W O) N O O W w W W W W aD N 0 " o N 0 N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 V V V V V V V J -4 J J J 0 A A A W W W W N O O O D 5200 m 0 0 0 O O O O O O O O W N m W N m m W N W N c m O d O c Z m c � o Cox Cl) c a =o m c m m T D 0> P Y _ m v_ m o 4 c p g 2 < m v r: g w d CD a v ° 01 » Om ° mmo 3 w °» n' m °� ? � °--. M - 3 :6 y m D o m °!�o a 3 v C m ' d of N N �' w w D ` m D -g m o.L v o to > > y — n n Y' O M � 0oo � � � � � v obi a � c 'a' 1 A ' '� � � m < Fb' m c o � m 3 o c 3 m 3m "g n v m m o m m °� m co m ' o x o v 2 a v 3 m 1 M D ' m o c � � < N m Oa 0 c 3 N m co O to N N O W O W m 0 N O c OND O O -+ A N N C O N O A O W m m N > m IIr N N N O (V mp > O m 0 W 0000 W�000 W 00 010000 oJ p0�� 00 » m O O O O Cn 0 0 0 0� 0 0 0 0 0 0 0 A A 0 0 A D > c N O W A O O 1 � ( 0 > OA O m O O O D T O T O o W > > m K > W W N 1p ONO _fJD IFN OOG (D W IIN A N N v 0V tp LN > N W fp > (() (D O N mlOm > m(OApOD W> pNN AOmOm N�V A O C N m m W O W IO O m W O A W IO W O O — 0 — ( fD n y p 0 A A . W A .0900 � � 00 D. m OA SO m . p m m A O O O m m m m V O W '0 O N m m m m m m 0 V O O m m (n m m O m 0 0 (O m W I p 0 0 0 0 0 0 0 0 o a o 0 0 0 0 0 0 a o 0 0 0 0 W N fD' > r -I z D 1d T > > m m z X y m v r m 03. m m O W oI m A � M W � � C o O C m 1 1 � o � W N IrrN W O � o Imw a °o O OD J N J N O N T J V d tD J J N r p � m O N If00 W � O Ir O N 1 f! N OD O O O 10 O N fT O W 0 0 o a r Enternd into Record at CnouciliCmvDevcros Mtg: ECONOMIC DEVELOPMENT AGENCY of San Bernardino re tiyencia Item 20-0:01 Cash Flow Analysis TaxIncrement/Bond Proceeds As of February 2000 City ClerkICOC Secy City at Sau 8emardiou 1999-2000 2000-01 2001-02 Fiscal Year Fiscal Year Fiscal Year Projected Tax Increment: 15,728,000 15,700,000 15,700,000 Expenditures: 20% Set-aside 2,666,271 3,140,000 3,140,000 Bond Payments 10,907,300 11,261,194 11,265,950 Bond Fees 90,000 90,000 90,000 Sumitomo Credit Line 800,000 712,500 712,500 County Charges 53,200 53,200 53,200 Pass-through Agreements 454,699 355,593 356.505 Total Expenditures 14,971,470 15,612,487 15,618,155 Amount Available Prior to Other Obligations: 756,530 87,513 81,845 Other Redevelopment Revenues: Interest Earned 574,000 900,000 900,000 Notes/Int Receivable 673,034 551,164 422,542 Rental/Lease Revenue 532,996 573,500 673,500 Mail Security Income 40,000 40,000 0 Miscellaneous 110,000 110,000 110,000 Total Estimated Available: 2,686,560 2,262,177 2,187,887 Other Redevelopment Obligations: Agency Salaries/Benefits 307,875 307,875 307,875 Agency Operations/Admin 332,729 262,000 262,000 Agency Contracts/Agreements 1,434,099 1,052,186 872,186 Agency Property Manage/Maint 439,400 439,400 439,400 General Marketing 53,000 53,000 53,000 General Consulting 28,000 28,000 28,000 NW PAC 45,000 25,000 25,000 Marketing/Spec Events 111,000 111,000 111,000 California Theatre/PEC 260,000 260,000 260,000 Master Sery Agree/City Expenses 1,218,725 618.725 0 Total Expenses 4,229,828 3,157,186 2,358,461 Balance Available/Deficit -1,543,268 -895,009 -170,574 A % O O O O O °0 00 00 0 0 0 0 0 0 O O O 0 00 0 o C 0 m 0 O °m W N 9 O 00 O J C O O O F n m C mm m m to f9 69 di Q IL to 69 (A O O O O O O O O O N O O 0 0 0 0 0 0 0 1 v°j O O O O O O O O O O O O O O O g 0 0 0 fA f9 f9 M m fA H3 w Q � EA fA fA 0 0 0 O O O O 11 _0 0 0 N O O O O O O C 0 0 0 0 p 0 0 O O O O r 4 0 0 0 ° n W (n0 Imo 0 C N m N N l7 1[) 06 N L W O_CL f9 f9 M » (A f9 fA [@1 r m w fA e» D O O O 00 O O C O O O O CO. O O N 0 0 0 0 N O O 0 O O O 0 0 0 O 0 O 0 p O O O O O O O C O O O O O O O O 0 O 0 0 0 O m 0 m 0 O 9 m m 00 o n R w Nm �n w .. v vi o 16� n C6 } n m r6 co c rn Qd f9 e9 m mm V) f9Q E mmof s Z y p 0 0 0 0 0 0 Im N II II II II O N O O O O O O m c 0 0 0 0 IL 200 0 0 0 0 v 0 0 0 0 O N N N N w 3 :$ 0) mm um m 9 > 0 vi m v E cl� nnn QLL H fA to to fA FA H W IL L O p 0 O o o O o 0 0 0 0 0 U N O O 0 0 O O 0 0 0 0 0 c °o o °000 °0 0 -y o° OO O°_ o 0 O O 00 0 O V 0 0 0 0 w ° 1°0 NN o 2 hoNO °mrn r I� Iri .- r f9 k9 f9 fA 69 69 f9 0 w w 19 E9 LL p 0 O O q N 0 0 0 o U u II 0 0 o w u Q ° N No N II N n c y LL N L C d U K" L .0 q N W Z c ) — W m N d � Q Q w o O Z a 4 j C C C C Q Q Q Q 0 O 0 O 00 00 00 0 0 0 0 oo oo oo 0 0 0 0 0 0 0 U) _ J N o 00D 00 C m F c � r ao aCo co 05 f» en f» w Q W e> F» r» N0 O 00 00 00 0 00 O 0 N O 0 0 00 O O O O o 0 0 00 000 �p O O 0 0 O O y 0 0 0 O W o N N O 0 � 00 cq n Lo - - CO c � » eA eA to tfi to » w Q Of of rn <» 00 II N O O O 0 0 O C 2000 p o 0 0 00 0 0000 p N 0 On o (0D 0 O V 0 0 0 N W N_ N O a C y OJ N N, W tt) r � fA t9 to fA fA fA m V } N V3 fA fA 0 0 O 00 O O C 0 0 0 0 p 0 0 O O O O O d 0 0 0 0 N O O O O O O O p 0000 - 00 o O O O O C 0 0 0 0 B O O O O O O O R 0 0 0 0 } C DM t00 W O 00 (00 N U R Coco jy w- 000] 0 WN N W n } t() V (`� M ♦+ C m Qy k9 t9 to EA fA fA fA Q C t/3 fA to E9 = C Zy p o 0 0 0 0 o E y y p 0 0 0 0 0 O W w II II II II N o 0 66 o m ry 0 0 0 o 0 a o00 O o 0 0 0 0 0 N N N N I j 3 p o 0�1 W 1� iD O .0 > 0 vN th N E c n n n n pu' <» » <» f» <» w en W LL s m IO p U N o 0 0 0 0 0 0 0 0 0 Z c o °o °o °o °o °o -y po C po Do O 0 0 00 0 o N O O w 0 0 00 0 O m m O O 2 0 00 W O 16 m v 3 W ' dp fA EA fA di fA fA f9 O M f9 1R fA LL D O O o y A N 0 0 o U II p p O O O w n p 0 O o y 11 N U 0 In 6 L6 O a y O p _ m N N fA fA di fA fA fA m 6"O C 'O (� y E v c y a m a LL 0 x w > x y a y 0� W Z I1 w - m — `� In m U m > � > W a a QQ � 0S I2 Z Qfm 0 Q>c Q>c Q j c Entered into Record at cnunc111Cmy0evcros Mtg: CITY OF SAN BERNARDINO by ,-- 7-- GENERAL FUND PROJECTION re Agenda iYem / FISCAL YEAR 2000-2001 f City ClerkICOC Secy PRELIMINARY City ut San Bernardino ESTIMATE DESCRIPTION FY 2000-2001 Estimated Revenues $ 78,058,700 Transfers In 6 835 600 Total Available $ 84,894,300 Estimated Expenditures $ 84,218,900 Vacancy Factor (1,400,000) Transfers Out 3 158.500 Total Expenses $ 85,977,400 Excess/(Deficiency) of Available over Deduction $ (1,083,100) Beginning Fund Balance $ 7,386,600 Estimated Balance $ 6,303,500 Budgeted Reserve" $ 5,027,400 Budget Excess/(Deficiency)" $ 1,276,100 "At 6/30/2000 the budget reserve is estimated to be $4,127,400. For FY 00-01, $900,000 of the budgeted vacancy factor will go into the budget reserve bringing the reserve to $5,027,400. For FY00-01 it is also recommended that the remaining budget excess of$1,276,100 be added to the budget reserve bringing the reserve total to $6,303,500 by 6/30/01. The Mayors goal is to have a minimal budget reserve of approximately $8,000,000, which is about 10% of the General Fund expenditure budget.