Loading...
HomeMy WebLinkAbout26-FinanceMAYOR & COMMON COUNCIL MEETING BACKUP MEETING DATE: March 18, 2002 Mayor & Common Council / GROUP MEETING: Community Development Commission DEPUTY: Linda Hartzel *** No backup materials are included for the following items. *** ITEM # STATUS 13 Continued to April 1, 2002 28 Continued to April 1, 2002 31 Continued to April 1, 2002 CITY OF SAN BERNARDINO -REQUEST FOR COUNCIL ACTION From: Barbara Pachon, Finance Subject: Mid-Year Budget Director Review for Fiscal • - ~ Year 2001-2002 Dept: Finance ~ r . ~i~~~..r,a~,t~ Date: 3/5/02 Synopsis of Previous Council Action: July 9~h, 2001 Resolution 2001-228 approving and adopting the FY 2001-2002 Budget. Recommended motion: That the FY 2001-2002 Mid-Year Budget Report be received and filed. ignature 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/~~/~ Agenda Item No. 2 STAFF REPORT INTRODUCTION Attached is the FY 2001-2002 Mid-Year Budget Analysis report. 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. This report is really the first step in the FY 2002-2003 budget preparation process as it provides information regarding fund balances available for next fiscal year. The only action associated with this report is to receive and file it. Each year in January, 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 I provides the audited beginning budget fund balance for each fund. The last column of ', numbers on this report indicates the estimated balance for each fund at 6/30/02. THE GENERAL FUND Fund Balance -The FY 2000-2001 audit has been completed and the audited, total actual FY 2001-02 beginning General Fund Balance (reserved and unreserved combined) is $19,414,800. Included in this amount are the FY 00-01 General Fund continuing appropriations and encumbrance carryovers in the amount of $932,100. The revised estimate for the FY 2001-02 total ending fund balance (including both reserved and unreserved) is $13,016,700. Of this amount. $9,829,900 is designated as the budgeted reserve (in accordance with the direction of the Mayor and Council during the FY 01-02 budget adoption process). At this time it appears that the remaining undesignated ending General Fund balance will be $3,186,800. This is approximately $3,184,000 higher than projected at the beginning of the fiscal year. This increase is due primarily to higher than anticipated expenditure savings and to increased growth in several revenue sources. Both expenditure savings and key 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 1 Revenues. In total, estimated General Fund revenues are projected to be $899,800 higher than originally budgeted. Sales tax revenue for now is expected to be on target with the original projection of $26,700,000. This is, however, a decrease of $132,389 from the amount collected last fiscal year of $26,832,389. Finance will continue to monitor sales tax and report back to the Mayor and Council any changes once we receive our third quarter reconciliation payment. This payment will be critical because it includes both our third quarter payment and our reconciliation payment of the 2nd quarter which included sales tax collected throughout the holiday season. Vehicle in Lieu Fees (VLF) revenue also experienced continued growth. An additional $550,000 over originally budgeted projections is expected for a total of $10,300,000. However, as the Mayor and Council are aware, the State's current budget crisis could negatively impact this revenue later in the year, depending upon the actions of the Governor and State Legislature. Finance will continue to monitor this revenue and keep the Mayor and Council apprised of any changes in projections. Utility User's Tax revenue is also projected to be on target with the original budgeted amount of $21,686,300. A decrease in revenue for the Enron situation was factored into projections, but this reduction was offset by increases in revenue from other utility service providers. Based on the past six months activity, the City Clerk's Office predicts Transient Occupancy Tax (TOT) will be approximately 11.1% higher ($250,000 more) than originally budgeted, for a total of $2,500,000 expected by the end of the fiscal year. Parking Citation Revenue is expected to be $180,000 more than originally budgeted. Last fiscal year was the first full year that the City utilized the City of Ingelwood's collection services and during that year a large backlog of citation revenue was collected. It was anticipated that parking citation revenue would level off this fiscal year as the backlog of citations was collected; however collection levels have remained consistent. Overall, the revenue category of Charges for Services is expected to be 2% less ($62,300 less) than budgeted amounts. Although a number of Development Services' fee revenues are down (primarily HUD inspection revenue, storm drain utility fees, plan review fees, and subdivision fees) most of this decrease is offset by an increase in plan check fee revenue and public works subdivision fees. The Police Department's Annual Alarm Permit Revenue also in the revenue category of Charges for Services, is expected to be approximately 22% less ($60,000 less) than budgeted, for a revised projection of $215,000. Passport revenue is expected to be approximately 35% less ($25,000 less) than budgeted for a revised estimate of $45,000. The occurrence of surrounding cities starting their own passport programs coupled with the events of September 11d' appear to have impacted this revenue source. 2 The revenue category of Miscellaneous Revenues is projected to be approximately 4% less than budgeted due primarily to a decrease in revenues generated from Off Track Betting and revenues categorized as Miscellaneous Other. Off Track Betting is expected to be $45,000 less than anticipated. Overall, the revenue category of Licenses and Permits is expected to be 1.5% greater ($88,500 more) than originally budgeted. The primary factor contributing to this increase is an increase in Development Services related permits. A projected 53% increase ($40,000 more) in Fire Plan Check revenue also contributed to the overall ', increase in the Licenses and Permits revenue category. i General Fund Expenditures -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 in the General Fund of $2,986,700. Additionally, because the Animal Control fund is estimated to realize savings through a combination of increased revenues and expenditure savings, the transfer from the General Fund to the Animal Control fund has been reduced by $54,400. Anticipated transfers-in to the Cemetery and Stadium Fund for the purpose of eliminating their deficits were also less than anticipated, resulting in savings of $287,500. Combined, these savings are projected to be $3,328,600. This is approximately $2,128,600 more than the target expenditure savings goal of $1,200,000 that was factored in to the adopted budget. Factors contributing to this increase in expenditure savings are discussed in the departmental sections below. The majority of departmental savings are due to either savings in electric or savings resulting from vacant positions. General Government -Included in the adopted General Government budget was $3,900,000 for MOU increases, Charter 186 increases and implementation of the employee class and compensation study. $2,963,800 in costs were incurred, leaving a balance of $936,200. Of the $2,963,800 of costs incurred, $1,635,800 (per prior Council action) was transferred to the Police and Fire Departments for Charter 186 increases. Also in accordance with prior Council action, $854,900 for General Unit increases, $110,100 for Mid-Management increases, and $363,000 for ManagemenUConfidential increases was allocated to General Fund and General Fund supported departments. Savings here may decrease if any further negotiations are settled that involve additional benefits and compensation to employees. During the FY 2001-2002 budget process, the Mayor and Council approved $1,500,000 for the Summer Utility Rebate Program. It is estimated that there will be approximately $279,000 in savings from the originally budgeted amount. ' Police Department -Although overtime is anticipated to be approximately $140,000 higher than the amount expended last fiscal year, (and $691,000 over this year's 3 budgeted amount) savings from vacant full-time positions will offset this increase. (Overtime is expected to be higher than amounts expended last fiscal year due in part to the events related to the September 11`" incident.) Full-time savings were reduced by retirement payoffs totaling approximately $461,000. Garage charges for the Police Department are projected to exceed budgeted amounts by approximately $84,000. According to the Fleet Services Division of the Public Services Department, this is due to an increasing number of former patrol vehicles being "rolled down" for use by administrative and other non-sworn positions in the department. According to Fleet, this ultimately results in savings to the City because it is more cost effective to convert patrol vehicles than it is to buy new vehicles for administrative personnel. The Police Department is also one of the few City departments that did not benefit from the overall savings in electric. According to the Facilities Management Department, the Central Police Station is classified in such a way that it was subjected to increased rates. The Facilities Management Department will continue to explore ways to reduce electric costs at Police facilities. Overall, the Police Department is projected to have savings of $124,100. Development Services -Electric costs for street lighting and traffic signals are budgeted in the Development Services Department budget. Because of rate structure changes made by Edison, coupled with energy saving enhancements (L.E.D. project) made to some of the City's traffic lights, there is an anticipated savings in electric charges of approximately $632,300. Development Services is also anticipated to have approximately $229,800 in savings from vacant positions. This amount could decrease if the department is able to III their vacant positions sooner than estimated. The remainder of savings is various maintenance and operations and contractual accounts throughout the department's twelve (12) divisions. Facilities Management -Electric Charges for City Hall and for the Carousel Mall are budgeted in the Facilities Management budget. Electric charges for City Hall are expected to be approximately $250,000 less than budgeted. However, electric charges for the Carousel Mall are expected to be $113,400 more than budgeted. Savings could change depending on the weather and usage by the various departments in City Hall. Facilities Management will continue to monitor electric expenditures closely and will notify the City Administrator if projections change significantly. Facilities Management is also expected to realize savings from reduced gas and water charges for City Hall, and from savings from unfilled positions. Because Facilities Management's budget was increased for a number of projects this fiscal year that have not been started due to staffing shortages, it has been assumed that these funds will be carried over and eventually spent next fiscal year. 4 Fire Department - The Fire Department is expected to be over budget by approximately $257,700. This is due primarily to increased overtime expenditures related to constant staffing mandates, the events of September 11~" and increased dispatch overtime expenditures. Additionally, the Fire Department had a number of retirements that resulted in payoffs totaling approximately $187,000. The City Treasurer's Office, Human Resources Department and City Attorney's Office are all expected to be on target with their respective budgets. The City Attorney's Office does have approximately $64,900 in salary savings that most likely will be used in part to offset increased costs in other areas of their budget, but may still have savings remaining. The Council Office ($80,500), Civil Service ($61,600), Code Compliance ($73,200) and the Finance Department ($82,500) have savings derived primarily from unfilled positions. City Clerk -savings of $91,100 has been estimated for the City Clerk's Office. This savings is due primarily to savings in election costs and salary savings. The City is still waiting for invoices to be finalized from the County for past elections. Depending upon the amounts of these final invoices, savings may be less than estimated here. Public Services -The primary reason for the overage in the Public Services Department is due to increased overtime expenditures and increased garage charges. The Public Services Department budget was increased for materials for a number of projects. In an effort to complete as many of the projects as possible, Public Service has utilized overtime to expedite projects and to compensate for vacant positions. Public Services will reduce reliance on overtime in the second half of the fiscal year and is working with the Fleet Division to determine which vehicles need to be replaced. Parks and Recreation -The Parks and Recreation Department, like the Police Department, is one of the few City departments that had an increase, not a decrease in electric rates. Electric costs are now estimated to be approximately $200,000 higher than budgeted. Facilities Management will explore options for reducing electric costs for this department in the future. The Parks Department also had a number of retirements that resulted in payoffs of approximately $100,000. Savings in full-time salaries and contractual landscape costs are expected to offset some of the department's overages, but the department's is still expected to be overbudget by approximately $44,800. The City Administrator's Office anticipates savings in part-time salaries of approximately $6,000 and in various maintenance and operations accounts of approximately $11,400. The Mayor's Office realized savings in hiring the Project Manager position for an amount less than originally budgeted. (When the position was originally conceived during the budget process, a salary range and job description had 5 not yet been developed.) Additionally, project contingency funds of approximately $95,100 are not expected to be expended. 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: Refuse Fund -. Revenues are estimated to be approximately $276,800 higher than budgeted, but expenses are also anticipated to be approximately $286,900 than budgeted, so there is only a minor net impact on the Refuse Fund. Increased expenditures are due primarily to increased overtime expenditures (approximately $212,000 more than budgeted), increased garage charges, and increased dump fees costs. These increased costs have been offset in part by full-time salary savings. The Refuse Division estimates that overtime usage will decrease by 15% in the second half of this fiscal year. And, as more new trucks are put into service, garage charges will 'i decrease. The Refuse Fund is estimated to have an ending fund balance of $455,600 at 6/30/02. Fleet Services Fund Fleet is expecting savings of approximately $215,000 in fuel costs this fiscal year. Overages in overtime are offset by full-time and part-time salary savings. All other expenditure categories are on target. Utility Fund - As mentioned earlier in the report, electric costs overall are less than originally anticipated due to conservation measures and final rate structure changes, resulting in an estimated budget savings of approximately $566,600 to the Utility Fund. Gas charges too are expected to be approximately $113,600 less than budgeted due to lower rates and warmer weather. The savings from gas and electric charges are reduced by expected overages in water charges of approximately $92,400. Increased water charges are primarily due to the Water Department's new billing system, which has resulted in the Water Department, discovering a number of meters they were not previously charging the City for. The fund balance deficit projected at 6/30/02 in the Utility Fund is due primarily to costs associated with the recently completed L.E.D. upgrade to a number of the City's traffic signals, The energy savings realized from this project will be used to pay back the Utility Fund for the project costs, ultimately eliminating the deficit in the Utility Fund and generating savings for the General Fund. Baseball Stadium -Revenues are projected to be slightly less than anticipated this fiscal year. It is also anticipated that expenditures will also be less than anticipated. With the implementation of the name sharing agreement with the San Bernardino 6 Arrowhead Credit Union, this fund's revenue and expenditure budgets next fiscal year will be significantly different. The Parks and Recreation Department will keep the Mayor and Council updated on this issue. Because the Mayor and Council approved an increased transfer-in to the Stadium Fund from the General Fund at the 11/5/01 Council meeting, the deficit in the Stadium Fund is expected to be eliminated. The Cemetery Fund overall is on target with original projections. Because an increased I' transfer-in to the Cemetery Fund from the General Fund was approved by the Mayor and Council at the 11/5/01 Council meeting, the deficit in the Cemetery Fund is expected to be eliminated. The Cemetery Fund is expected to exceed maintenance and operations costs by approximately $4,000, but increased revenues will offset this overage. CAN is expecting a fund deficit of approximately $23,400, primarily due to a shortfall in revenues. Although the CAN Fund has approximately $28,600 in full-time salary savings, these savings will be used to offset corresponding overages in part-time and contractual employees. Worker's Compensation - A deficit of approximately $7,955,000 is expected at 6/30/02. The beginning deficit of $9,877,300 at 7/1/01 has been reduced due to increased budgeted transfers into the fund from the General Fund as approved by the Mayor and Council during the FY 2001-2002 budget process and at the 11/5/01 Council Meeting. The deficit in this fund, in addition to the deficits of a few assessment district funds, will continue to be addressed during the FY 2002-2003 budget preparation process. The EMS (Emergency Medical Serviced Fund's deficit has been reduced to $168,000 and will be eliminated during the FY 2002-2003 budget process. TRANSFERS The final set of reports, Transfers In and Transfers Out (purple report) provides the revised estimates for each transfer. As indicated by the report, transfers are generally on target with a few exceptions. The transfer from the General Fund to the Animal Control Fund, as mentioned earlier was reduced by $54,400 due to a combination of increased revenues and expenditure savings. (The Library, Animal Control and CAN funds are subsidized by the General Fund, so savings in these funds is passed on to the General Fund in the form of a decreased transfer-in from the General Fund.) Because FY 2000-2001 ended with approximately $2,195,900 more in the General Fund balance than anticipated, the Mayor and Council at the 11/5/01 Council approved increased transfers from the General Fund to the Worker's Compensation Fund, the Stadium Fund and the Cemetery Fund. $785,400 more was approved as a transfer-into the Worker's Compensation Fund. $306,000 was approved for the Cemetery Fund, but only $120,900 was required to eliminate the Cemetery's deficit. Similarly, $436,000 was approved to be transferred-in to the Baseball Stadium Fund, but only $333,600 was required to eliminate the Stadium Fund's deficit. 7 Although Assessment District 994 expired in 1997, small payments on delinquent taxes have continued to trickle in as properties are sold and back taxes are paid. $155,100 more in back payments were received than anticipated during the FY 2001-2002 budget process. This additional revenue will be transferred to the General Fund. CONCLUSION The FY 20001-2002 Mid-Year Budget Analysis is really the first step in beginning the FY 2002-2003 budget preparation process. The estimates developed during the FY 2001- 2002 Mid-Year process provide the foundation for estimating the City's available beginning fund balances for FY 2002-2003. The Finance Department will keep the Mayor and Council updated on estimated balances as new information is available. Departments that are projecting deficits in areas of their budgets will return to Council for budget amendment requests as necessary. RECOMMENDATION That the FY 2001-02 Mid-Year Budget Report be received and filed. 8 I ~ O O O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 ' O V O O O O O O O O O O O O O O 0 0 0 0 0 0 O O O Z n a0 O O. O OD O 00 O t0 N O f0 M DO 1D O N O f` M r ~ Q 1D M h ~ N M r n r 7 OD 10 r OI 10 DD O r CD ~ ~ N Q Q~ ~ N CO OD f• N C O CD i0 IA M r O IA M N p~ 0 O r N M N r~ N ~- 0 0 M N ~ p ~'p M r N N N N OO ~ Z ~ is ~ Lr. H O O O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 Z O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 O f` M r in O N E Of O O Yf O V a0 ~ O N a0 O O/ h 0 ~- O N r ~7 N T Q~ ~- Of M OD 1D 10 N OI N N Of O V h P 0 a N O h V N 0 0 0 l'f O N M F N N M O h 00 a N 01 CD f` M O O O. O f• ~ O. a ID tp VA O pp m Op ~ O Q M O N~ M N N in ~ O. O u7 ~ W O N ED 7 O tCl N B C to O th e- a O r r r POi f'f r ~- 0p p r O O O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 i O O O O O O O O O O O O O O O ~, O f• W O O N O N OI O N O O N f: O W M r 0 0~ tD r !D C O O N N h Q. f• N 10 H M O O M W O CD O N O CO ~ OD ~ f` f` N ~- OD A ~ r '- V ~ y 00 N ~ N rn i Z ~ °- i ~ W cFj I 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 0 N ~ i y 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 O O 0 0 0 0 0 0 O O O Z C I C~' M O N O Yf t- G O O N 01 m e- O n W O 01 f` O ~- O r V' N ~ N O> t0 CO N r N OD N ~C7 Oi O> r f` O M Ol O O~ O tp O O M 1H ID a N M O f~ M < {O 01 10 t0 Oa O O. O V r f• 7 10 b N O N N F I F V O N O M N of ~ h a s W N a aD ~ M 1A N 01 I Z OOf M) r M r r ~ M Ol ~ r f• ~ ~ 's` Z I Q No ~ Ov7N W O O O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 Z a' rp W I N 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 0 0 7 0 m {al ~ ° a- ~ h N ~ f` O O V O N O~ e• N O t0 r O h O. N ~ f` N V N N t0 ~ H N C p v' C07 M OM'1 ONO fN0 OO t} r N t00 HMO C09 YOf `^~' A A CaD t00 M O W~ M N N N W r M CND N Z Z Q Q~~ M O N M O N V O O n M ~ O~ h~ O! t0 a N h W ~ t0 a, W w ~ 00 M r a} N r '~ 1+f M N r w a } < m X J Z w Q 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 0 0 Q~jN ~ zo 000 0 0 0 000 00 0 0 h w .- so ~ ~ M r cD o o v h o aD M LL~ LL I ~ h N N h OD t0 M O N M r O t'1 N r N lp tO O M M N t0 O N O ~- f0 O Z~ i t0 M N r V Ol r O O O W Q v~ ~ Z {O N t0 N N r o ~ o 'L ~ 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 0 0 O c i y 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 } Q i ~ N N O N N O O Of O O O O O O O O Q7 t0 h O N 0 IA O O O l"i Q' t0 r• t0 O h N N N 00 h N 0 ~ h N N {`7 OO ~ r` a} 0 0 0 0 0 0 0. i Z O n 00 N QD t0 f` N N b n M N M DD O O 10 M N DD N ~ ~ O. G] l(1 M ~ ~ N N ~ M h M M r t0 {O h O 00 b ~ N M r ' r C'1 N r ~ N N N f0 I ~ y 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 0 ~' O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O Z O O N f• fi r: O N O O N N O N CO M r O N CD n O h N O Q < b N Oi N O W N~ of ~ O/ 00 I~ 10 CD O Yf Oi O 10 ~ A N V e ~ O f• ~ N Of 1~ O ~ n r V O M r t0 ~ N M 1D O P ~- y+ ~ M N ~ O O CO tCl M M ~ uD `-' f• O! V ~ tD ~ V p ~ Of r M N v ~ V v h V r O! Z ~ N Z V N Z ~ W Z (~j N ~ LL a ~ w ~ Z p~i~t~i1~-~U ~ ¢ t7 w ~ O U 7~ w~ z Z~ F O a O ~ F N U p Z Q~ Z U Z J X} 06 Z~ U ~ ~- F O O F N~ O Z y W d zj O LL N F VJ F 1- N ~ Q tLL Q LL W F~ Z O N j U W N Q ts. Z W ~ W~~ G F W W F LL U v~ K O U W H F F- ~ W LL m N IL fn LL J F- Y O Z F Z W N Q W Z F" U W U. C Q~~ Q ~, Z } J d' otl D Q: O J~ N y Z J 2' G d W: Q O Z } Z Z J Q W Y W H~ (7 (7 O U J F, J J F Z M a U O~ J m 0 N J U W W J W Y Y 2 a~ U ILLi. W o W W m LL~ Fa- ~ J W Y W W Z~ 'd LL W Q Z J~~ m N R' Q.' ~ V w U M~ y N N LL O m 2 R rL 3 a J O wa~+~ 0 C7 V m U U Q d d~ Q Q fp ~ ~ y y m Q W d' ~ F d N d U y? U N F N~ ~ e- W N /C1 h 40 OI O ~ C N i0 aD OI ~ N M t0 ~ h G! ~ N M N i0 h OD O h ~ O a 0 0 0 0 0 r ~- N N N N N M M M M O N a- y N 1A O ~ ~' ~ ~ ~ t• ~ ~ ~ r ~" r ~ ~ ~ ~ 1I1 1f7 U N N N N N N N N N N i U o 0 0 0 0 0 0 o O ~ a v°+ °n V °o °n °o °n_ N u01 ° ~ oWO N m ~ u01 aN0 0 00 m M O M ~ O Q/ M~ O ~ O b r ~ ~ A ~ N ~ Z Z 0 0 0 0 0 0 0 0 O [C. ~ M ~ 1 _ Of Of Ol N l0 F O N M O OAD N n N n O '~ M O 1~ h 0 1~ r O A F~ N C A N O N ^ , O r O 00 0 0 0 0 0 0 O O O t0 't O O O t00 I ~ N N M W k. 10 Vi r m z ~ o `dF W c~ 1y = 0 0 0 0 0 0 0 0 O O D ~ 4~7 r 10'1 ~ ~ 001 001 00f N O Z ~ 6' F O N M O~~ n N r H M a0 A A O A ~ l0 ~ G r 7 I~ N a m 10 p Z N 0 Z t 1`a ~ N a i~ 0 Z W ~" ~ ~"' 0 0 0 0 0 0 0 0 O p 7 0 m y a 0 O A 1D r t0 O r ~ F N a p h ~ O 00D V IAO 001 N N t0D Z Z Q , tl C M O) O 10 ~ ~ Vl O 00 K W W ',~ ~i ~ e ao vi v aA- m W d> ¢ O a r m W J a y U I Z N~ 000^ a0D N~ ~ 00D t00 y W VJ ~ ri er ~ N m oai m ~ m LL 7 LL I 4~] }O} 2 Q' j ~ 10 W M F E W Z~ G ~ ' ~ U ~ } p i F O ~ 0~ G I 0 0 0 0 0 0 0 0 O Y Q i ~ O N O N~~~ 01 ~ ~ O O 0) 10 N O h h~ i~ I Z O M ~ M M 0) Of N t0 I> M Of Of O ~ Ol t0 O! M ~ r {0 0) N M N ~ p ~ r N U 0 0 0 0 0 0 0 0 O Z N O) O M '- M r O) O mq ~ m i° i n n 100 ~ v Q! r 0 Of a0 0) M r C r r ~- r Oi 10 Oi z "' N r Lr. i O p Z ~ LL ~ O O F U ' ~ Z Q } K f/J. 1=L W ~ 0 N W G U~ d y a 2 Q O Z LL W~ Z Z ~ y Z W 2~ U W F LL W J ~ O y LLy y K W? Q V) ~ J d F F Y (7 Q J J F m W J W d' Z F 6 O Q ~ cWi ~ r~ a 3~~ o W ~' ~ m o ~ v1 a0 a Z N N M M M A h - 0) O) 0) O) Vl 10 10 I CITY OF SAN BERNARDINO ESTIMATED REVENUES AND EXPENDITURES • MIDYEAR FISCAL YEAR 2001.2002 GENERAL FUND VARIANCE FY2001-07 FY2001-02 FAVORABLE! BUDGET- MIDYR EST (UNFAVORABLE) ESTIMATED REVENUE: Property Taxes $ 7,310,000 $ 7,365,600 $ 55,600 Other Taxes 54,164,300 54,415,300 251,000 Licenses & Permits 5,659,800 5,748,300 88,500 Fines and Penalties 684,500 834,500 150,000 Use of Money & Property 1,465,000 1,545,000 80,000 Intergovernmental 13,677,900 14,159,300 481,400 Charges for Services 3,109,800 3,047,500 (62,300) Miscellaneous 3,535,400 3,391,000 (144,400) Total Estimated Revenues $ 89,606,700 $ 90,506,500 $ 899,800 Other Finance Sources-Bond Proceeds $ 2,000,000 $ 2,000,000 $ Total Transfers In: $ 6,261,500 $ 6,417,100 $ 155,600 TOTAL ESTIMATED FUNDS AVAILABLE: $ 97,868,200 $ 98,923,600 $ 1,055,400 ESTIMATED EXPENDITURES: Mayor $ 1,144,600 $ 892,600 $ 252,000 Common Council 455,200 374,700 80,500 City Clerk 1,078,000 986,900 91,100 City Treasurer 23,900 23,900 City Attorney 1,935,000 1,935,000 - Code Compliance 3,300,200 3,227,000 73,200 General Government 4,229,300 3,006,400 1,222,900 City Administrator 536,600 519,200 17,400 Human Resources 414,900 414,900 - Finance 1,233,600 1,151,100 82,500 Civil Service 300,600 239,000 61,600 Development Services 8,967,800 7,932,700 1,035,100 Fire 20,456,600 20,714,300 (257,700) Police 42,338,900 42,214,800 124,100 Facilities Management 4,372,400 4,043,200 329,200 Parks, Recreation, & Comm Service 5,216,500 5,264,300 (47,800) Public Services 3,428,300 3,505,700 (77,400) Total Estimated Expenditures $ 99,432,400 $ 96,445,700. $ 2,986,700 Estimated Expenditure Savings $ (1,200,000) $ - $ (1,200,000) Total Transfers Out: $ 9,217,900 $ 8,876,000 $ 341,900 TOTAL ESTIMATED DEDUCTIONS: $ 107,450,300 $ 105,321,700 $ 2,128,600 EXCESS / (DEFICIENCY) OF AVAILABLE OVER DEDUCTIONS $ (9,582,100) $ (6,398,100) $ 3,184,000 BEGINNINGPUND BALANCE 7-1-01 $,. 18,414,800 $ 19,414,800 $ - ESTIMATED ENDING BALANCE $ 9,832,700 $ 13,016,700 $ 3,184,000 BUDGETED RESERVE $ 9,829,900 $ 9,829,900 $ EST UNDESIGNATED BALANCE 630-02: $ 2,800 $ 3,186,800 $ 3,184,000 CITY OF SAN BERNARDINO ' MIDYEAR GENERAL FUND REVENUE REPORT FISCAL YEAR 2001-2002 ACTUAL DEC YTD` BUDGET FY00 REVISED OVER/(UNDER) DESCRIPTION 2000-2001 FY01-02 `- FY01-02 %GOLL I FY 01-02 . ORIG$UDGET PROPERTYTAXES'-- 4001 Current Secured 6,334,722 3,106,283 6,350,000 49% 6,350,000 0 4002 Current Unsecured 372,253 373,341 380,000 98% 380,000 0 4003 Prior Taxes 358,346 163,036 350,000 47% 350,000 0 4006 Supplemental 166,892 83,797 125,000 67% 175,000 50,000 4005 Other 110,638 52,824 105,000 50% 110,600 5,600 Totaf Property Taxes 7;342,851 3,779;281: 7,31U,004 ~ 52°1° r' 7,365;600 ` , 55,600" OTHER TAXES 4221 Sales Tax 26,832,389 11,640,300 26,700,000 44% 26,700,000 0 4224 Utility User's Tax 17,581,140 8,720,479 21,686,300 40% 21,686,300 0 4201/14 Franchise Tax 2,091,595 386,925 2,275,000 17% 2,311,000 36,000 4215 Tow Franchise 287,857 144,000 288,000 50% 288,000 0 4222 Transient Occupancy Tax 2,272,819 992,164 2,250,000 44% 2,500,000 250,000 4225 Sales Tax Safety 604,185 255,163 650,000 39% 610,000 (40,000) 4223 Real Prop. Transfer Tax 319,373 110,223 315,000 35% 320,000 5,000 Total Taxes 49,989,358 22,249,254 54,164,300 41% 54,415,300` 251.,000 LICENSES AND PERMITS 4301 Business Registrations 4,060,375 1,540,003 4,150,000 37% 4,150,000 0 4330 Building Permits 477,053 205,045 460,000 45% 460,000 0 4331 Mechanical Permits 201,418 92,237 200,000 46% 200,000 0 4362 On Site Permits 198,736 162,547 200,000 81% 225,000 25,000 4363 On Site Plan Check 111,683 87,760 100,000 88% 110,000 10,000 4361 Construction Permits 71,384 95,473 100,000 95% 120,000 20,000 4342 EMS Membership 21,593 17,576 23,000 76% 21,500 (1,500) 4336 Fire Code Permits 169,282 95,185 247,600 38% 247,600 0 4337 Fire Plan Check 113,315 47,951 75,000 64% 115,000 40,000 4351 Street Cut Permits 12,966 5,344 11,000 49% 11,000 0 4333 Mobile Home Park Permits 28,076 752 28,200 3% 28,200 0 4352 Misc Licenses & Permits 52,011 15,922 30,000 53% 30,000 0 4303 Misc City Clerk Permits 9,419 3,951 10,000 40% 5,000 (5,000) 4304 Misc Planning Lic/Permit 20,128 10,724 20,000 54% 20,000 0 4360 Grading Permits 5,352 3,280 5,000 66% 5,000 0 Total License & Permit '` 5,552,791.: 2,383,750 5,659,800 142% i 5,748,300 "- 88;500` FINES AND-PENALTIES 4420 Parking Citations 729,974 322,432 550,000 59% 730,000 180,000 4410 General Fines 113,910 22,839 130,000 18% 100,000 (30,000) 4450 Fire Citations 2,621 725 2,500 29% 2,500 0 4421 Vehicle Abatement 1,656 0 2,000 0% 2,000 0 Total_Fines/Penalties 848,161 345,996 - " 684,500 51% 834,500 "150,000 CITY OF SAN BERNARDINO ' MIDYEAR GENERAL FUND REVENUE REPORT FISCAL YEAR 2001-2002 ACTUAL DECYTD BUDGET= ° FY00 ;;REVISER' OVER/tt1NDER) DESCRIPTION - -- 2000-2001 FY01-02 ' FY01-02 = ° ° /o COLT ri ~ FY~O'#=0 OFtIG`BUDGET USE OF-MONEY & PROPERTY 4505 Interest Earnings 1,605,411 245,411 925,000 27% 1,000,000 75,000 4520 Land & Building Rental 324,382 295,833 300,000 99% 325,000 25,000 4530 Parking Rental Fee 40,110 15,680 56,000 28% 40,000 (16,000) 4922 Sale of Property 83,473 118,808 100,000 119% 130,000 30,000 4540 Vending Machine Commis 8,385 14,446 84,000 17% 50,000 (34,000) TotaPMoney &Property 2,061,761 690,178 1.;465,000 "- 47°(0 ~":?" 1;545,000 ": 8Q000` INTERGOVERNMENTAL 4603 Motor Vehicle In Lieu 9,908,062 4,253,262 9,750,000 44% 10,300,000 550,000 4621 Booking Fee Subvention 689,066 689,066 689,100 100% 689,100 0 4622 ERAF Subvention 608,587 0 0 0% 0 0 4670 CDBG Reimb. 2,584,232 614,679 2,095,100 29% 2,095,100 0 4670 20%Reimb. 84,100 40,800 40,800 100% 40,800 0 4670 Tax Increment Reimb. 74,900 12,300 12,300 100% 12,300 0 4606 Homeowner's Exemption 152,700 23,705 160,000 15% 152,000 (8,000) 4616 POST 235,319 62,389 195,000 32% 200,000 5,000 4625 State-Mandated Costs 429,884 97,312 360,000 27% 240,000 (120,000) 4673 Water Reimbursement 197,681 189,168 206,000 92% 206,000 0 4671 SBIAA Reimbursement 106,055 8,750 106,000 8% 100,000 (6,000) 4615 Disaster Prep. Program 20,662 0 20,000 0% 20,000 0 4607 Off-Highway Vehicle Tax 3,969 0 3,600 0% 4,000 400 4619 Mutual Aid/Disaster Reimb 53,179 74,951 40,000 187% 100,000 60,000 Total Intergovernmental 15,148,396 6,066,382 13,677,900 44% 14,159,300 481:,400 CHARGES FOR: SERVICES 4731 Plan Check Fee 192,596 116,432 200,000 58% 225,000 25,000 4880 EMS User Fee 641,277 306,172 640,000 48% 640,000 0 4798 Storm Drain Utility Fee 247,757 158,135 270,000 59% 250,000 (20,000) 4815 Weed Abatement 247,861 104,535 230,000 45% 230,000 0 4733 Building Demolition 298,410 198,829 250,000 80% 300,000 50,000 4714 Develp Project 98,049 47,947 110,000 44% 100,000 (10,000) 4305 Annual Alarm Permits 213,828 93,094 275,000 34% 215,000 (60,000) 4780 Misc Charges 23,314 12,594 20,000 63% 25,000 5,000 4766 Building Permit Review 2,688 1,321 3,000 44% 3,000 0 4865 Non-Resident Fees 4,230 2,379 4,000 59% 5,000 1,000 4720 Plan Review Fee 65,850 27,912 70,000 40% 60,000 (10,000) 4864 Swimming Pool Fee 60,106 43,038 57,000 76% 57,000 0 4719 HUD Building Inspection 21,829 0 20,000 0% 0 (20,000) 4718 Environmental 11,866 859 12,000 7% 5,000 (7,000) 4785 Non Subdivision Str Imp 18,392 295 9,000 3% 1,000 (8,000) 4863 Class Registration Fee 12,281 6,238 13,000 48% 13,000 0 4711 Subdivision 50,879 5,554 50,000 11% 15,000 (35,000) 4862 Park Energy Fee 11,211 1,483 12,000 12% 10,000 (2,000) CITY OF SAN BERNARDINO ' MIDYEAR GENERAL FUND REVENUE REPORT FISCAL YEAR 2001-2002 ACTUAL DEC YTD BUDGET FY00. "REVISED OVER/(UNDER) DESCRIPTION 2000-2001 FY01-02 '' FY01=02 °!o DOLL FY 01-02 ORiG'BUDGET 4707 Passport Fees 69,106 22,147 70,000 32% 45,000 (25,000) 4702 County Contract 250,216 0 250,000 0% 250,000 0 4861 Program/Facility Use Fee 18,531 7,928 20,000 40% 18,500 (1,500) 4710 Misc. DevelopmentServs 42,784 288 30,000 1% 30,000 0 4743 Towing Release Fee 129,669 51,380 130,000 40% 120,000 (10,000) 4705 Utility Collection Fee 20,211 0 30,000 0% 20,000 (10,000) 4782 Public Wk Subdivision 106,078 56,643 11,000 515% 75,000 64,000 4790 Signal Maint/Energy Fee 28,889 0 30,000 0% 30,000 0 4802 Str Light Energy Fee 8,510 23,167 7,000 331% 8,500 1,500 4701 Election Filing/Copies 159 2,753 1,800 0% 3,000 1,200 4747 False Alarm Fee 93,552 43,743 85,000 51% 93,500 8,500 4735 Release Pendency Notice 24,860 10,544 25,000 42% 25,000 0 4881 Paramedic Reimb Contrac 72,775 74,636 175,000 43% 175,000 0 Total Charges 3,087,764 1,420,046 3,109,800 46°10 3,047,500 (62,300) MISCELLANEOUS 4906 Water Fund Contr. 1,733,392 757,868 1,775,000 43% 1,775,000 0 4910 Admin Service Charge 373,993 372,800 375,000 99% 372,800 (2,200) 4901 Misc. Other Revenue 68,387 25,143 216,000 12% 130,000 (86,000) 4912 Off Track Betting 182,050 61,643 175,000 35% 130,000 (45,000) 4741 Sale of Photos 104,867 50,196 105,000 48% 105,000 0 4740 Police Misc. Receipts 721,585 397,941 765,000 52% 765,000 0 4746 Property Auction 0 0 5,000 0% 0 (5,000) 4911 Restitutions 7,270 16,081 6,200 259% 20,000 13,800 4905 Litigation 166,791 87,230 25,000 349% 40,000 15,000 4904 Drunk Driver Reimburmt. 5,084 400 5,000 8% 2,000 (3,000) 4809/10 Misc Develop. Servs. 6,746 5,256 5,000 105% 7,000 2,000 4928 Booking Fee Reimb. 16,797 8,590 17,000 51% 18,000 1,000 4750 Investigation Fee 10,236 7,028 11,200 63% 11,200 0 4924 Damage Claim Recovery 28,024 6,140 50,000 12% 15,000 (35,000) Total Miscellaneous 3,425,222 1.,796;316 3,535,400 '51% 3,391,000 (144,400) TOTAL GENERAL FUND 87,456,304 38,731',203 89,606,700. 43% 90,506,500 _ 899,800-' CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 2001 - 2002 4618 State Aid-Libraries 214,651 311,681 308,902 309,000 289,500 4850 Miscellaneous Receipts 11,885 13,834 12,549 14,000 12,500 4851 Library Fines 55,476 60,186 63,278 60,000 75,500 4505 Interest on Idle Cash 21,517 25,635 28,502 26,000 27,000 4775 Cemetery Burial Fee 64,171 64,917 59,871 60,000 65,000 4776 Sale of Vases 1,854 2,228 1,415 1,500 1,400 4777 Sale Concrete Boxes 27,953 28,907 27,464 28,000 33,000 4778 Sale Cemetery Plots 57,893 51,334 49,340 47,000 60,000 4901 Misc. Receipts - - 2,000 - ~~Total;Cemetery Fund ~~=~i~~ ..?" ~~8&Bk v z~?~s0~"~~ ~' ;l0~.`L'ARLE~eT~; FUND 4505 Interest on Idle Cash 173 - - 4670 Economic Development Reimb. - - - - 4922 Sale of Equipment 113,414 127,170 121,933 145,000 120,000 ntel G~bIs:;T~1 Funt1 - ~, ~ ' . 4 ~ ~ a ~t~ 3 SST F.,QRF,EkTll~i~~k 4505 Interest on Idle Cash 8,472 11,704 31,314 1,000 25,000 4672 Asset Forfeiture Federal DOJ 131,058 10,741 7,639 - 22,200 4927 Asset Forfeiture 100,325 213,494 297,615 21,300 200,000 4929 Asset Forfeiture-Drug/Gang 16,797 35,089 50,354 4,000 40,000 ~_~Total'Asset Forfeiture Fufid ,-'°_'~,„_ ~ .$,25f,652, _$- '°27°1;038 ' 388;8 ~ lad 109~RARKING/BUSI NESS. IMP.:ROVMTp 4302 Parking/Business Improvement 116,661 138,836 131,284 65,000 65,000 4505 Interest on Idle Cash 957 971 819 500 500 ;i'C,kal;,l?aking/BUSttl~;as Fumd- . ' , ~ . ~,6~8<. 3980_ t?L41r`.#~R~1k'tt~"UISTRI€~;f~F[fi?t 4010 Special Assessment-Land 60,968 72,344 75,382 70,000 70,000 4011 Special Assessment-Phase II 3,766 3,598 20 - 4505 Interest on Idle Cash 929 448 25,113 - 1,000 4530 Rental Fee-Parking 1,588 2;407 2,244 1,200 1,400 4670 Economic Development Reimb. 148,706 145,094 - - - ~QetJtiktg;DiStri k 6E~d .~~ke._: 45051nterest on Idle Cash 5,119 7,524 7,497 8,000 8,000 4626 Rideshare Reimbursement 199,637 207,167 209,297 200,000 210,000 4670 Economic Development Agency - - - 4901 Misc. Receipts - 812 - 1,000 4906 Water Department 3,000 7,606 3,000 3,000 3,000 sD SRo „ • CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 2001 - 2002 X22'# , 4320 Animal License 132,553 194,601 208,274 325,000 341,000 4352 Misc. License & Permits 1,000 1,960 1,456 1,500 1,500 4410 General Fines 20,344 11,999 10,144 20,000 35,000 4430 Animal License Penalty 19,487 35,208 51,114 48,000 55,000 4756 Animal Adoption Fee 15,542 20,114 22,920 22,000 25,000 4757 Contractee Shelter Fee 413,222 482,891 512,511 523,000 618,300 4758 Livestock Fee 2,038 270 - 500 200 4759 Apprehension Fee 22,355 12,908 17,670 17,000 18,000 4760 Board Fee 22,328 8,698 15,437 14,000 15,000 4761 Field Service Fee 1,629 1,471 2,076 1,500 1,500 4763 Owner Release Fee 24,466 33,289 32,423 30,000 33,400 4764 Vaccination Fee 10,284 11,319 13,249 14,000 13,000 4901 Miscellaneous Receipts 17,350 16,063 78,369 18,000 2,000 d?f~~el[118!',~4t1~~1llRd+-. ~' ., ~~~$d ,x. 1~5~fi6292$?TRAF~ICCONC~ESTION~;' ;,,~; 4505 Interest on Idle Cash - - 56,615 45,000 45,000 4635 Traffic Congestion Relief - 1,328,273 560,000 560,000 ::cstaifSeW~a)~tfe<Loilstf~;Fuit! , 126; SPEGIAt.GAS TAX FtiN[?~"~~~~_ 4505 Interest on Idle Cash 12,137 20,899 53,285 20,000 40,000 4610 State Aid-2106 730,316 712,319 664,747 730,000 675,000 4611 State Aid-2107 1,481,603 1,508,824 1,389,782 1,500,000 1,450,000 4612 State Aid-2107.5 10,000 10,000 10,000 10,000 10,000 4614 Prop 111-Highway Users Tax 1,143,737 1,133,323 1,336,938 1,150,000 1,200,000 4945 Reimbursement - 1,735 (1,370) 89,000 :a+TVtaI:~Te7S;FU.tid:,~ '' ~ "...~~ '~:'37,7~,Z93, ' - --_~ "~ _ '::. ". 4505 Interest on Idle Cash 1,064 - 36,373 - 50,000 4830 Commercial Rubbish 396,141 438,496 420,178 425,000 420,000 4831 Commercial Bin Rent 208,507 98,693 102,113 99,000 103,000 4832 Commercial Bin Service 6,128,380 6,567,453 6,689,026 6,700,000 6,800,000 4833 Commercial Special 600,462 539,118 540,749 510,000 560,000 4836 Commercial Bin Service-Malls 18,678 268 - - - 4837 Automated Commercial Rubbish 46,163 41,868 39,779 42,000 30,000 4840 Residential Water Billed 6,747,000 6,981,359 7,113,228 7,150,000 7,250,000 4841 Residential "B" Accounts 475,075 539,837 547,432 600,000 600,000, 4842 Residential Specials 7,206 3,475 50 100 - 4843 Dino Bin Service 1,216,057 1,261,530 1,415,525 1,400,000 1,600,000 4901 Miscellaneous Other Revenue 62,098 115,821 160,100 400,000 200,000 4903 Refunds and Rebates 25 780 - - 4923 Sa~lepySalvtay~geyMater 23,643 {~[6~{,`f3~83 - - - -. ,,,-'~ t&ug~pT°gr~r. ,..u &`iw:alME ._, ,.P. ...- ...-. ""^''.A ' CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 2001 - 2002 4440 CVC Fine 743,639 813,217 651,456 730,000 730,000 , ~,.n 4505 Interest on Idle Cash 88,858 134,682 132,000 100,000 100,000 46131/2 Cent Sales Tax 1,777,820 1,964,227 2,153,541 1,900,000 2,140,000 4945 Construction Reimbursement 6,291 15,000 30,000 111,000 ~'~p~,, _ ~ 8994' 132;SEWER~LIN~;MAINTENANG 4505 Interest on Idle Cash 69,940 118,654 123,022 125,000 125,000 4820 Sewer Line Maint 1,331,684 1,144,707 1,210,488 1,250,000 1,210,000 ` QtaltS@wLine:M2iRteda~t.. v , ' *2~~ ~ . , 't3BP,,"SEBAL°t~ T'AQIi1M n 4520 Land/Building Rental 21,425 88,805 78,165 95,000 10,000 4901 Baseball Team Lease Agreement 144,458 150,655 98,753 144,700 175,000 ~k~I:B~e4~IPS?~Clt,. , ~ ~t3B X49;,S~REE~'CON~STRUQ~IQN~tiNA.,~' 4630 State Aid-Street Constr. - 6,857 1,476,800 1,265,600 4658 Federal Aid-FAU 3,193,835 258,481 117,417 11,622,500 739,000 4945 Construction Reimbursement 866,407 138,929 58,700 330,400 s.4~Total Street ConsfFt Fend "~ `~-.,-K::. 4;060,242- $ x`404,28? ..' X5,1%_, x;+32 „Q~",¢~Dv 24a3tt[?,°+RINCQNSTR1JCrTJON: FUN Der: 4505 Interest on Idle Cash 19,011 38,653 34,433 38,000 35,000 4732 Park Development Fee 159,903 118,345 184,951 150,000 200,000 4901 Park Bond Money - - 2,232,700 2,232,700 4945 Construction Project Reimb. 82,000 10,000 - 400,000 400,000 <ttatlt~E,ansk~GGtioll~pn :$` 60;8-4~ ~ ~;1 kS~ . ;B'~ , . 4505 Interest on Idle Cash 388 731 853 500 500 4778 Sale Cemetery Plots 3,840 2,929 2,925 3,500 3,500 I°~Erttetetgrgnsti:~Fun m.-,-~~;' ;228;,., ; 4505 Interest on Idle Cash 138,471 158,782 316,881 160,000 300,000 4821 Sewer Lateral Fee 13,292 799 446 500 500 4822 Sewer Connection Fee 179,252 130,728 231,223 175,000 230,000 ;#l~~Virei~>i;iri : ` ~ 41#: ~ w , _ _ ~ r -~,~; • ~ CITY OF SAN BERNARDINO SPECIAL REVENUE FUNDS FISCAL YEAR 2001 - 2002 4505 Interest on Idle Cash 10,308 18,820 19,658 15,000 20,000 4945 Reimburse Street Construction - - - 100,000 100,000 4335 Cultural Devel. Constr. Fee 66,397 42,960 117,400 80,000 80,000 4505 Interest on Idle Cash (429) (208) 3,065 - 500 _ 2 RNFif3 tfV"~QNS~~=1?lf~l 4505 Interest on Idle Cash 54,960 112,797 68,241 60,000 50,000 4818 Storm Drain Fee 407,413 354,283 416,515 450,000 200,000 4945 Construction Reimbursement 9,965 - - .~talrStA>rditt#~on . ~" ;' . _ S$ - 2~a4FFIC SY<~TEMS;QO~ISTR,If 4505 Interest on Idle Cash 4,630 6,925 25,244 6,000 15,000 4658 FedlState Aid-Street Construction - - 39,999 60,000 60,000 4803 Traffic System Fees 265,785 143,319 281,243 200,000 200,000 4945 Reimburse StConstr 14,000 - (11,158) 35,000 35,000 `2tSte~'$`ir~h..~. " '~2t7 4057 AD 994 179,758 125,153 103,257 10,000 4910 Administrative Service Charges - - - - ,~T9talCity....Wide"f4D=99h ~.,:, ...a£~a~,' ,$~'~:1~,9.758 ~125;'t:53 ~'0.3.?.~Z~' 62.1:CENTRAt~zSEIj~ICES)rUNf?s ~~-~-~;~# 4897 Interdepartmental 237,729 247,626 269,037 300,000 300,000 4505 Intereston Idle Cash 177,220 185,196 392,162 180,000 250,000 4670 Economic Development Agency 30,000 25,000 - - 4897 Interdepartmental Receipts 1,871,200 1,822,700 1,644,500 1,688,500 1,688,500 4901 Misc. Receipts - - - - 4906 Water Department - - - 4924 Damage Claim Recovery - - . ,. 4541 Telephone Commission 12,692 31,887 9,172 11,900 10,000 4893 Water Dept. Receipts 99,085 145,063 105,764 119,400 100,000 4670 Economic Development Agency 50,138 15,813 833 1,200 1,000 4897 Interdepartmental Receipts 540,711 624,292 727,794 677,200 800,000 4903 Refunds and Rebates 14,452 20,707 32,030 - 5,000 CITY OF SAN BERNARDINO • SPECIAL REVENUE FUNDS • FISCAL YEAR 2001 - 2002 4897 Interdepartmental Receipts 3,110,213 3,345,785 3,542,913 5,176,300 5,176,300 4944 LED Retrofit Reimbursement - - 878,900 D 4670 EDA 9,380 4,333 3,803 200 5,000 4896 Replacement Contribution 539,900 484,400 513,500 739,500 988,200 48971nterdepartmental Receipts 4,228,950 4,777,456 5,080,851 5,137,100 5,137,100 4901/22 Misc, Other Receipts - - 705 - 9. 67$ WQRKERS"COMPENSATIS7i1;FAINDY' 4505 Interest on Idle Cash - - - - - 4897 Interdepartmental Receipts 2,034,086 2,075,020 2,148,414 2,687,400 2,687,400 4899 Premiums - - - 4901 Misc Receipts - 15,000 16 - 4906 Water Department 381,343 306,361 332,880 300,000 300,000 :Cata~/Ugttcers'Compensa6on-fd~ , ~ $,u2415,429 ~~;2;396;38'l. 2;Q$F1;'~„1i3; $~~:na9~t~ntJnfottnatiar~SenJ~~ 4505 Interest on Idle Cash - - 4670 EDA Reimbursement 645 25,248 2,759 4673 Water 385,000 423,826 425,897 335,800 335,800 4897 Interdepartmental Receipts 2,621,946 2,682,000 2,918,500 3,261,400 3,261,400 ~ 4901 Miscellaneous Receipts 343 425 551 - 200 4922 Sale of Equipment 450,000 - Total MIS Funds~;~~ n * . ~'= ..~,'_ ~ :$8:3;457,934 $'.'3;131;499 .,$~3;~4~7.07. '. ;~x5~0,p , `~94Q~ ~ GRAND*~OTA : °' "~?<'s, :~"a ,~": ~$46~~56.s32 ~+~5:It14',-a~aM ~$-kBaQ~1+ a6 " " R1 '; • CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS • FISCAL YEAR 2001-2002 TRANSFERS - IN VARIANCE FY 2001-02 FY 2001-02 FAVORABLEI BUDGET 'MIDYR EST (UNFAVORABLE) TO GENERAL FUND: 'From Special Gas Tax For - 2,710,000 2,710,000 0 Street Maintenance-$2,339,900 Street Lighting - $370,100 *From Traffic Safety For - 730,000 730,000 0 Police Costs *From 1/2 Cent Sales & Road Tax For - 190,700 190,700 0 Administration *From Cultural Development Fund For - 80,000 80,500 500 Fine Arts/Civic & Promotional Costs *From Traffic Systems Constructions For - 25,000 25,000 0 Administration *From AD 994 Fund For- 27,100 182,200 155,100 Street Lighting and Signals *From Liability Fund For - 200,000 200,000 0 Refund Reserve Excess *From Storm Drain Construction For- 100,000 100,000 0 Administration *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 Sewer Line Maintenance Fund For - 106,000 106,000 0 Administration *From Transportation Fund For- 161,500 161,500 0 Traffic Engineering Costs $50,000 MainUFuel for Alt. Fuel Veh $31,500 Crossing Guards $80,000 TOTAL GENERAL FUND $6,261,500- $6,417,100.. 155,600- TO ANIMAL CONTROL FUND: 'From General Fund For - 490,500 436,100 (54,400) Operating Costs ' CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS - IN VARIANCE FY 2001-02 FY 2001-02 FAVORABLE/ BUDGET MIDYR EST (UNFAVORABLE) TO CAN FUND: *From General Fund For- 265,100 265,100 0 Operating Costs TO LIBRARY FUND: `From General Fund For - 2,652,600 2,652,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 - 65,000 65,000 0 Street Sweeping TO EMS FUND: *From General Fund For - 150,000 150,000 0 Repay Operating Loan TO BASEBALL STADIUM: *From General Fund For - 1,036,000 933,600 (102,400) Operating Costs TO WORKERS COMPENSATION FUND: *From General Fund For- 1,694,800 1,694,800 0 Operating Costs TO CEMETERY FUND: *From General Fund For - 537,800 352,700 (185,100) Operating Costs TO STREET CONSTRUCTION FUND: *From General Fund For - 2,000,000 2,000,000 0 Bond Proceeds for HUB Project TO PARKING DISTRICT: `From Parking & Business Impr - $53,700 141,600 148,300 6,700 *From General Fund - $94,600 TO CENTRAL SERVICES FUND: *From General Fund For - 3,200 3,200 0 Approved MOU increases CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS - IN VARIANCE FY 2001-0T FY 2001-OZ FAVORABLE/ BUDGET MIDYR EST (UNFAVORABLE) TO LIABILITY FUND: *From General Fund For - 4,900 4,900 0 Approved MOU increases TOTELEPHONE FUND: 'From General Fund For- 11,800 11,800 0 Approved MOU increases TO UTILITY FUND: *From General Fund For - 2,800 2,800 0 Approved MOU increases TO FLEET SERVICES FUND: *From General Fund For- 61,200 61,200 0 Approved MOU increases TO INFORMATION SYSTEMS FUND: "From General Fund For- 96,100 96,100 0 Approved MOU increases TO TRAFFIC SYSTEMS CONSTR. FUND: "From 1/2 Cent Sales/Rd Tax Fund For - 13,800 13,800 0 Project costs TOTAL OTHER FUNDS $9,278,700 $8,943,500 (335,200) GRAND TOTAL TRANSFERS-IN $15,540,200 $15,360,600 (179,600) • CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS -OUT ~- ~ ~~- c~~x ':VARUCNCE . - FY 2001-02 FY 200?-0Z .;FAVORABLE/. ~ v.n k- BUDGET' MIDYR EST -(t1NFAVORAiBLE)' FROM-GENERAL'FUND: . •To Animal Control Fund For - $490,500 436,100 54,400 Operating Costs `To Library Fund For - 2,652,600 2,652,600 0 Operating Costs 'To CAN For- 265,100 265,100 0 Operating Costs 'To Baseball Fund For - 1,036,000 933,600 102,400 Operating Costs *To EMS Fund For - 150,000 150,000 0 Operating Costs "To Refuse Fund For - 65,000 65,000 0 Street Sweeping 'To Parking District For - 94,600 94,600 0 Operating Costs *To Street Construction Fund For - 2,000,000 2,000,000 0 Bond Proceeds for HUB Project *To Cemetery Fund For- 537,800 352,700 185,100 Operating Costs 'To Workers Compensation Fund For - 1,694,800 1,694,800 0 Operating Costs *To Central Services Fund For - 3,200 3,200 0 Approved MOU increases *To Liability Fund For - 4,900 4,900 0 Approved MOU increases 'To Telephone Fund For - 11,800 11,800 0 Approved MOU increases 'To Utility Fund For - 2,800 2,800 0 Approved MOU increases 'To Fleet Services Fund For- 61,200 61,200 0 Approved MOU increases "To Information Systems Fund For- 96,100 96,100 0 Approved MOU increases ' CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS -OUT ~*•-*_, - . VARU~NCE FY3001-02 FY 2001-02 ,, FAVORABLEI ' BUDGET MIDYR EST ;(UNFAVORABLE): *To Public Park Extension For- 51,500 51,500 0 Park Facilities Improvements 7OTAGGENERALFUND '` $9,21:7,900 :$8,876,000 ~ .:341,900'': FROM-TRAFFIC SAFETY: -_""~ ° •' *To General Fund For - 730,000 730,000 0 Police Costs FROM SPECIAL GAS TAX:' *To General Fund For - 2,710,000 2,710,000 0 Street Maint. Costs-$2,339,900 Street Lighting Costs-$370,100 FROM 1/2 CENT SALES/ROAD TAX: *To General Fund For - 204,500 204,500 0 Administration -$190,700 *To Traffic System Constr. Fund For - Project Costs-$13,800 FROM AD 994: *To General Fund For- 27,100 182,200 (155,100) Street Light and Signals FROM PARKING & BUSINESS IMPR *To Parking District For - 47,000 53,700 (6,700) Administration of District FROM`CULTURAL DEVELOPMENT *To General Fund For- 80,000 80,500 (500) Fine Arts & Civic Promotional Costs FROM TRAFFIC SYSTEM CONSTR *To General Fund For - 25,000 25,000 0 Administration of Fund FROM STORM DRAIN'FUND ' *To General Fund For - 100,000 100,000 0 Administration of Fund FROM REFUSE FUND ~„,w~,..; y ,. w _,., *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 - ~ ~ CITY OF SAN BERNARDINO ' DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 2001-2002 TRANSFERS -OUT ` ° ~ = ;VARIANCE FY 2001-02 FY 2001-02 ...:FAVORABLE/ : - BUDGET. MIDYR EST =(UN~¢VO~dl3lE)' FROM`SEWERtINE-CONS'iR FD '' - 'To General Fund For - 100,000 100,000 0 Administration FROM SEWER LINE MAINT FUND 'To General Fund For - 106,000 106,000 0 Administration FROM LIABILITY FUND ` °' 'To General Fund For- 200,000 200,000 0 Refund Reserve Excess FROMTRANSPORTATION FUND 'To General Fund For- 161,500 161,500 0 Traffic Engineering Costs $50,000 Maint/Fuel for Alt. Fuel Veh $31,500 Crossing Guards $80,000 TOTAL OTHER FUNDS $6,322,300 $6,484,600 (162,300) GRAND TOTAL TRANSFERS-OUT $15,540,200 $15,360,600 19,600'