The URL can be used to link to this page

Home My WebLink About2003 08-18 CCP Joint Work Session with Financial Commission I; AGENDA CITY COUNCIL WORK SESSION FINANCIAL COMMISSION MEETING August 18, 2003 6:30 P.M, Council Commission Conference Room Joint Meeting with Financial Commission 1. Report by Chair Escher on Financial Commission review to date: a. Recommended 2004 Preliminary Tax Levy i. $9,184,878 (amount is $21,500 higher than the 1/3 levy back of lost LGA) 1. Preliminary levy represents 1/3 of LGA loss plus for discussion purposes: a. $10,000 for PRISM b. $11,500 for 5 Cities Senior Transportation b. Recommendation to adopt franchise fee for gas & electric utilities c. Recommendation on Draft 2004 General Fund budget development to date i. Continue in budget development directions identified in materials presented to the Financial Commission on August 4th ii. Divert liquor fund transfer from Capital Projects Fund to General Fund 1. use a portion of that diversion to increase police funding iii. Do not use reserves, to the limited extent they may exist, for operations 1. use for capital projects d. Policy issues for City Council i. Senior Transportation ii. PRISM 2. Discussion of Preliminary Levy and General Fund Budget a. Issues i. Senior Transportation ii. PRISM iii. Shift of $100,000 from Capital Projects to General Fund iv. Direction for continued development of General Fund Budget 1. review components in July 31" memo to Financial Commission b. Continued development directions for General Fund 3. Direction for September 8 City Council meeting a. Preliminary 2004 tax levy Page 1 of 15 b. Preliminary 2004 General Fund budget c. Introduction of franchise fee ordinance i. August 25"' or September 8"' ii. Percentage 3% d. Truth in Taxation Hearing Date: set for December 1 St at 7:00 p.m. 4. Next work session October 20 ( instead of October 6th) a. Need to revise time to 6:30 p.m. b. Enterprise & Utility budgets 5. Miscellaneous 6. Adjourn Page 2 of 15 Financial Commission DRAFT Meeting Minutes July 10, 2003 1. Call to Order The meeting was called to order by Chair Escher at 6:30 PM 2. Roll Call Members Present: Chair Escher, Commissioners Elftman, Nemec, Peterson, Wilkinson and Hruska. Commissioner Blarney arrived at 7:30 PM City Council Liaison: Council Member Bob Peppe Others Present: City Manager Michael McCauley, Fiscal and Support Services Director Douglas Sell and Assistant City Manager Curt Boganey 3. Meetine Minutes Motion by Commissioner Wilkinson, Second by Commissioner Hruska to approve the meeting minutes of June 16, 2003. Motion carried. 4. Approve Aeenda Motion by Commissioner Hruska, Second by Commissioner Wilkinson to approve the agenda as presented. Motion carried. 5. Budcet Discussion Chair Escher summarized the discussion to date and reviewed the budget materials submitted by the City Manager in preparation for this meeting. City Manager McCauley discussed several issues related to the 2004 Budget, potential property taxes, franchise fees and budget reductions. He identified the potential impact of a $560,000 property tax increase on an average home in the City to be $32 -$60. He stated that these are subject to the tax capacity rates and final tax capacity values to be determined later this year. He indicated that an increase in property taxes to homeowners would likely be more significant as the tax capacity value increases and the limited market value cap is diminished. City Manager McCauley indicated that the $560,000 tax levy increase is a fraction of the amount the legislature permitted in the tax bill. The tax bill permits the City to increase the property tax levy to 60% of the lost LGA in 2004. The total amount the City could levy is in excess of $1.0 million. City Manager McCauley reviewed the impact of a potential franchise fee on the community. Such a fee would generate approximately $600,000 of additional income. The suggestion is that should such a franchise fee be recommended, the proceeds would be dedicated to the street reconstruction program. This fee would probably apply to all property types including those that are currently exempt from property taxes. Commissioner Peterson asked about the impact of the budget reductions on current or pending labor contracts. City Manager McCauley indicated that the city is currently paying maintenance personnel at a level that is in the bottom quartile. Police contracts currently pay in the mid -range of comparable communities. City Manager McCauley indicated that the increased property taxes are an item eligible for deduction on individual income taxes as an itemized deduction. The franchise fee does not receive the same treatment. Chair Escher asked if the street reconstruction projects would be accomplished every- other -year rather than every year. Council Member Peppe stated that street reconstruction is a high priority for the Council and this is why the Council has maintained this activity at its current level. City Manager McCauley indicated that every- other -year does present the possibility of some savings over two small projects each year. However, he indicated there is the Page 3 of 15 problem of staffing up /down every- other -year to accommodate this approach. In the end, he believes it maybe more costly to move to an every- other -year program. Commissioner Elftman asked about the "Delinquent Taxes" line and the impact. Mr. McCauley explained that the City dos not collect 100% of the taxes levied in any given year. This allowance permit a realistic explanation of actual collections for cash flow purposes. City Manager McCauley reviewed the areas of the budget he and staff have identified for potential reductions in 2004; the basic budget assumptions for the 2004 Budget; the ongoing efforts to identify additional resources or areas for cost reduction; and, issues concerning wages and benefits. He explained that there is concern that the November state forecast of state revenues may find the state further behind. In turn, this may lead the Governor to further un- allot amounts already committed in 2003 should the state's revenues fall short. This may reduce the City's share of LGA and/or MVHC for 2003 in 2003. Motion by Commissioner Peterson, Second by Commissioner Wilkinson that the Financial Commission is opposed to using City reserves to fund operations and, that the Financial Commission favors the continuation of the street improvement program at its current levels. Motion carried. Chair Escher asked that this recommendation be carried forward to the City Council. Chair Escher indicated that there was consensus among the Commissioners that the direction currently be pursued was acceptable. He suggested that formulation of the 2004 Budget continue in the direction identified by the City Manager. 6. Next Meetiniz The next Financial Commission meting is scheduled for Monday, August 4, 2003 beginning at 7:00 PM in the Council/Commission Conference Room at City Hall. 7. Adjournment Motion by Commissioner Blarney, Second by Commissioner Hruska to adjourn the meeting. Meeting adjourned at 8:10 PM. I Page 4 of 15 1 Materials from August 4th Financial Commission Meeting Page 5 of 15 I To: Financial Commission From: Michael J. McCauley City Manager Date: July 31, 2003 Re: August 4, 2003 Financial Commission Meeting Draft General Fund Budget Since the July 10 Financial Commission meeting, the Draft General Fund Budget has been balanced between revenues and expenditures. Revenues have been increased /decreased: $40,000 Building Permits $40,000 Electrical Permits (and additional cost of inspection added) ($7,397) DARE reimbursement from Anoka Hennepin Schools $ 1,500 Miscellaneous Business License Revenues: $12,666,159 Expenditures: $11615,617 $ 50,542 The Draft General Fund budget continues to reflect: I 1. Removal of $1,043,494 debt levy and transfers. The debt levy remains, but will be directly incorporated into the existing debt service funds rather than collect the levy in the General Fund and transfer it to the debt service funds. This will reflect the accounting changes associated with Government Accounting Standards Board #34. Previously we had included the levy and transfers to have all general fund levies in one fund for ease of review. 2. Loss of $1,680,742 in Local Government Aid. 3. An additional levy of $560,247 (1/3 of $1,680,742). 4. Elimination of General Fund transfers for street reconstruction and capital projects ($480,000 and $125,000 respectively). At the beginning of this process, the target was $560,247 in operating reductions. With reductions in interest income, lodging tax, and recreation/community center fees, the target rose to $785,167 for reductions and additional sources of revenue: I Budgeted Revenues Budgeted Expenditures Page 6 of 15 - 2003 1 $15,408,271; j 2003 I $15,408,271 less debt service ($1,043,494); jLess Debt Transfers ($1,043,494) 3 1 I LGA loss !($1,680,742) j [Less Spec Assessment Const. 1 ($480,000) jInterest reduction ($150,000) jLess Capital Project Transfer ($125,000) Lodging Tax decrease ($40,000) Base Budget $13,759,777 JRecreation revenue ($51,022) 12004 Revenue Base 1 $12,414,363 Communi Center $28 650 Sortfall tY � ( ) � h � _ ($1,345,414) X2004 Base Revenue $12,414,363 jAdditional Tax $560,247 j ( Targeted Reduction /Shifts 1 ($785,167) This July 31 draft may be compared to the July IO last draft by departments: 7 -10 mtg. 1 8 -4 mtg. Groupings 2003 2004 j % cut 2004 % cut jMayor & City Council j $134,303 $130,029 ( -3%j $126,152 1 - 6% Pty Manager i $205,689 $181,205 -12% $179,905 -13% 1City Clerk 1 $164,505 $165,195 0% $163,995 1 -0% !Finance $675,4671 $680,141 1% 1 $686,9081 2% Legal $250,000 $250,000 0%j $250,000 0% Human Resources $225,156 $221,5171 -2% $217,067 -4% Other Gen. Gov't. S1,040,6801 $1,002,506 i -4%1 $1,002,789 j -4% jPolice $5,452,700 $5,251,9011 -4% $5,115,293 1 -6% !Fire $707,844 $691,900 - $691,373 - 2% !Inspections $293,664 $275,233'1 -6%j $316,9951 8% lEmergency Prep. j $61,706 $61,458 1 -0%1 $61,458 -0% jPublic Works Admin. $575,683 $487,1941 -15%j $439,756 -24% Maintenance Streets j $1,359,7891 $1,355,633 1 -0%j $1,270,411 -7% jSocial Services j $93,105 $61,5871 -34%j $83,087 1 -11% 1CARS Administration 1 $154,991 $147,389 I -5%j $147,089 -5% iRecreation Admin i $1,272,869 $1,025,766 -19%1 $1,023,266 1 -20% Maintenance Parks j $1,028,744 $939,766 -9%! $900,857 1 -12% Convention & l iTourism 1 $339,750 $330,000 -3% j $330,000 1 -3% Unallocated._._ .._...__....----..___...._..._..__..----_.._.........___._.__..._._._.....-- r___...___...___._.._....._......___..,_........___......_. ...._.--- .._..._._........_.... ($276,868) ($413,384) 49% ($390,784) i 41% _...__.__........._.._._..'_. _. _ _._ _ ..... ... ...------- _ o ......'__._.___._.___....._._ _.._._ Other Financing $1 648 494 $0 -100%1 $0 - 100% Page 7of15 $15,408,2711 $12,845,036 j $12,615,617 The long term sustainability of the budget is impacted by several of the mechanisms by which we are achieving reductions. In police and fire, grants are being used to purchase equipment that otherwise would require General Fund resources. These grants may or may not continue into the future at their current levels. Loss of grant funding will require increases in police and fire budgets. Additional proposals as the General Fund budget development continues: 1. Shift the $100,000 Liquor Fund transfer from the Capital Projects Fund to the General Fund. Current funds are available in the Capital Projects Fund for some of the major planned improvements. Park projects will require a reassessment given the reduction in funds available for maintenance. Other areas are of greater priority in the sense that a healthier General Fund will provide for maintenance of existing infrastructure. With the delay at Grandview, we have a backlog of projects and sufficient fund balance to accomplish the Grandview improvements. Delaying new park shelters seems to be appropriate. 2. Strongly consider a 2 „ d liquor store as a means of replacing funding for Capital Projects Fund if current contribution is shifted from current liquor operations to the General Fund. This is an item that has several issues and will require City Council discussion of its policy concerns. There are also issues at the State level with studies going forward looking at City enterprises. Some want to force cities out of enterprises such as liquor and others are looking at potentially reducing local government aid based on enterprise revenues. Additional issues are related to wine in grocery stores as a possible change that could impact sales projections. The City Council will be receiving the study. I plan to place discussion of a 2 nd liquor store on the August 18 d joint meeting agenda for the City Council and Financial Commission. 3. Explore reimbursement of Brooklyn Boulevard costs with Tax Increment Financing funds as possible ways to provide more money for street reconstruction program and to replenish unrestricted Economic Development Authority funds. Additional changes in the budget that are not yet fully incorporated in the current draft, include upgrading one of the Engineering Tech positions to at Tech III from the budgeted Tech II position. The shift of a Tech position to the utilities would still occur, but the new position would be in Engineering, rather than in the utilities. (A tech lI would be shifted to the utilities to focus on as builts and utility issues. A tech III would be hired and charged to the General Fund to provide capacity /expertise required by department.) The result would be an overall reduction from 5 technicians to 4 technicians (from 5 General Fund to 3 General Fund and 1 Utilities funded). Senior Transportation and PRISM have been added back into the budget with a corresponding increase of $11,500 and $10,000 respectively in the proposed tax levy. This reflects the discussion on July l O to continue the discussion and review of these two services in the context of specific levies. Mr. Boganey has been researching and reviewing these 2 services. Attached is a memorandum from Mr. Boganey with an overview of that study to aid in evaluating the value and costs of these two Page 8 of 15 I services. I am still weighing whether more funds need to be restored to the police budget to insure the ability to implement initiatives of patrol assignment and outreach. This would impact the budget between $45,000 and $70,000. This draft assumes that DARE is discontinued, except as it is fully reimbursed by the school using DARE. The revenue from the Anoka Hennepin School District has been removed from this draft. We may however provide the service on overtime provided the reimbursement exceeds our costs. This will free up the regular staff time to implement the patrol initiatives and provide coverage for the detective position. This draft reflects reduced clerical support and 42 sworn positions. There were 43 sworn positions identified in the 2003 budget (funds were actually in the budget for 44). With the reorganization plan, the number of budgeted positions would drop to 42. We are currently employing 43 sworn officers under the plan that carries more officers than budget to reflect retirements, injuries, and leaves. Overall we have been within the police budget even when carrying more officers than budgeted. However, with the overall reductions that ability is imperiled. Rather than drop the detective position as first thought, this draft continues 42 sworn positions to support patrol and the reorganization initiatives. To cover the detective position, the DARE equivalency would be assigned to investigation. Minor changes in the budget remain to implement that. Additional reductions in Community Activities and Recreation Services have been identified, but not fully developed. The targeted reductions are an additional $30,000 through redeployment and reconfiguration of staffing. I may be proposing an additional mechanism to encourage shifts in current employment patterns by allowing an employee to shift from full -time to part-time status using a transitional plan. That transitional plan would provide insurance contribution for 12 months, allow the employee to either cash out or carry their accumulated vacation and sick leave for use while working part-time (but not accruing any additional leave), and working 20 — 24 hours per week. This would provide atransition to full retirement or assist in reconfiguration. With the budget balanced, I anticipate making further changes by moving people out of the General Fund into the utilities and reducing the accompanying reimbursements. An example would be the billing clerks for the utilities. Their salaries and benefits are in the General Fund and the General Fund receives reimbursement for those costs. We will also be reviewing allocation of the remaining reimbursements where personnel are not entirely in one fund such as reimbursement for the Finance Director, City Manager, etc. The issue discussed on July 10 remains with respect to insurance contributions and keeping salaries competitive. I would suggest that the continued budget development direct additional savings and revenues to addressing those two issues. Requested Financial Commission direction: 1. Recommend a dollar amount for 2004 preliminary levy that must be adopted at September 8 th meeting a. These drafts assume $9,184,978 operating levy (debt service levies are separate) i. Included in that preliminary levy above the original 1/3 target: Page 9 of 15 I . Five Cities Senior Transportation $11,500 2. PRISM $10,000 2. Recommend introduction of a franchise fee ordinance at 3 %, with all proceeds of the franchise fee used for street reconstruction funding. 3. Recommend a preliminary General Fund Budget to the City Council a. Either i. Current Draft (which will be revised several times between September and December) ii. Current Draft 1. with $100,000 liquor transfer 2. with additional funding for police 4. Date of next meeting with Financial Commission a. Is one needed before August 18 joint meeting b. Date following August 18 joint meeting 5. Agenda for joint meeting on budget issues with the City Council scheduled for August 18 th . 6. Recommend that continued budget development focus additional savings or revenues toward addressing insurance contribution and salary comparability with comparative cities. Materials from the July 101h meeting that remain the same (or changed as noted): 1. Impact of tax increase. We inquired of Hennepin County as to what impact a $560,247 ad valorem tax increase would have on residential taxpayers. Hennepin County provided the assessor with a computer run that was inaccurate. The number supplied by Hennepin County per residence would have generated more money than the $560,247 from residences alone, without considering taxes paid by commercial and multi-family. Y We typically do not receive calculations until Fall in this area from Hennepin County. Thus, we have used a rough estimation process that is subject to substantial revision once actual tax capacity numbers and spreads are performed by Hennepin County. Using 8,371 single family residences comprising roughly 50% of the source of real estate taxes: $560,247 _ 8,371 houses = $67 X 65% = $44.00 per year Homes will also be impacted by virtue of losing limited market value as their taxes are phased into full market value. Again, there is no good data on the amount, but based on past experience, this could be in the rough range of $200+ p er year irrespective of any additional levy. 2. Impact of Franchise fees Page 10 of 15 A 3% franchise fee on gas and electric service would raise approximately $750,000. This would impact residential customers $38.32 per year or $3.19 per month. This is based on the average residential customer: Gas residential charges: $5,147,306 X 3.21% - 8,371 customers = $19.74 per year Electric residential charges: $6,533,985 X 3 %= 11,287 customers = $18.58 per year $19.74 + $18.58 = $38.32 3. Budget Assumptions a. Police, Fire, Low Income Housing, and PERA aids remain at 2003 levels. b. The 3 full -time General Fund positions eliminated in 2003 are not reinstated and the budgeted positions for Aquatics Supervisor (replaced with part-time at lower cost), Administrative Tech, 2 1 Engineering Technician positions (1 would be shifted to utilities), and -ate 2 street/park maintenance full -time positions are eliminated (with some part-time replacement during the summer. c. Resident Communications remain at current level of 6 newsletters and web site. (Reducing newsletters to 4 per year would save $8,000.) d. Social services are reduced by eliminating: i. crni aspei4 aii on $11,599 ii. PRISM (meth,. l trance i4atie f appe i n tmeRts) $ n nnn iii. North Hennepin Mediation $4,000 iv. COOP Northwest $6,418 (may purchase some services however as this has been our primary diversity outreach) e. DARE r �... y to vc -t v Ec1ITi:ilat ° v t DAR" eliminated to staff investi -actions. may be movided on a cost basis to schools through overtime. f. Staff levels maintained to support Earle Brown Days and other civic events g. Funding is eliminated to civic events beyond staff support and overtime for parade. h. Sentence to Serve is retained for litter & projects ($14,000) 1. Fund balances (from excess over minimum in Capital Reserve Emergency Fund and potentially from Liquor fund balance) will be used to support street replacement with Page 11 of 15 additional funds to replace /augment loss of planned General Fund surplus transfers. Greater utility contribution to cost of street projects since many projects are driven by the need to replace lines. Special assessment rates will be increased, but not at too disproportionate a rate relative to past practices. j. Th t ransfer- will be the ' infusion � C ��e �,�aas� -��° t p Projects Fund -ate fund balance will be spent down in that fund for park and general capital improvements. Park & Recreation Commission will be asked to review the current plan and priorities in liLyht of State reductions. k. Personnel recruitment costs (ads, testing, etc.) will be shifted to individual departments without additional funding. This will require a net zero impact in the event of recruitment to replace or hire a full -time employee. -1- Police will retain full patrol levels to support proactive efforts. Grants will be used for equipment and capital wherever possible. PARE is euf ez tly in the ,craft budge* but m ay need t va , i b to A d eteet i o po n bei ng r-e u w u monies may be added to police budget to insure capacity and eliminated DARE positions used to provide some replacement in detective functions. m. Fire operations will be maintained at current levels. Equipment replacement will be funded in short term through grants. n. Community Center and pool will be open. i. Adaptive recreation services will be arranged internally by existing staff, rather than contractually. Summer recreation programs will be fee based to a greater extent. ii. The pool will close at 8:00 p.m. rather than 9:00 p.m. iii. Fees will increase. iv. Donations for events will be allocated in part to overhead, as well as the cost of the event. o. Fireworks and special programs will be held to extent donations are received. Staff levels will remain sufficient to coordinate events. ($15,744 savings from Entertainment in the Parks, $8,000 fireworks, and $2,000 Community Band) p. No warming houses for ice skating and no rink attendants ($14,115 savings and approximately $9.000 in utilities). We ma� eliminate reduce the number of ice rinks to 5 as wel q. Reduced senior recreational programming. More use of volunteers for activities such as senior cards. r. No day care or concessions operations (rely on vending) at Community Center. Page 12 of 15 s. General operations will be maintained in Finance, City Clerk, and Administration (one budgeted and currently unfilled position in administration will be eliminated). t. Park and street maintenance will be at current reduced levels. u. Street sign replacement and markings will be on reduced basis. v. Reserves are used for capital and not operations, except insofar as necessary to respond to potential unallotments by the State. That is, operations are designed to work based on current income. Since there is no reason to believe that the current shifts by the State are temporary, our solutions need to be made during current operations. An exception could be to fund something such as senior transportation to allow a grace period to find alternate funding. This would not have additional operating complications such as those where operations were funded through reserves and then when those were depleted the costs of layoffs would compound the impacts in the following years. 4. Ongoing Efforts a. Dispatch i. The City is part of a multi -city study of dispatch seeking to develop a framework for evaluating and implementing cost savings /consolidation. A consultant has been engaged to start the study. Hennepin County seems amenable to participating. b. Central Garage i. Public Works is studying central garage equipment to identify equipment needs and potential reductions, as well as review current replacement schedules. c. Administrative Penalties i. We have ordinance examples and suggestion from City Attorney that a charter amendment should be undertaken Prior to considering or using' administrative penalties. d. Post - retirement health benefits. i. Human Resources is drafting policy changes to cut -off post- retirement health insurance Payments by the City for employees hired after a specific date and exploring offering mechanisms for employees to save pre -tax dollars for future health care /insurance costs. 5. Issues a. The current draft reflects the full engineering reimbursement of $330,000 from the 2003 and prior years' budgets. This reimbursement reflects the cost of internal design and inspection of street projects. A combination of conservative revenue budgeting g ing Page 13 of 15 and an overall plan of having unspent funds (i.e. not all personnel funds are usually spent in a given year, but we cannot predict where and how long vacancies will occur.) has provided those funds. Until we develop the utility budgets and are able to project a clearer picture of currently vailable monies for street reconstruction the he projection in the current draft General Fund budget of a $330,000 engineering reimbursement is tenuous and even more tenuous in the long term. If we are able to identify tax increment funds that could reimburse for costs on Brooklvn Blvd. we might be able to provide more certaintv to the street reconstruction proiections for the five Year CIP period, along with the franchise fee funds. Further drafts of the budget will need to address this issue. For the present, I am using the 2003 numbers to provide a like comparison as we deal with the loss of LGA in a year that follows an .87% increase in General Fund revenues for budget purposes and will actually see a $1.18 Million shortfall in revenues due to LGA cuts in 2003. b. Wages i. The Current budget does not contain funds for any wage increases beyond step increases or reclassifications. In surveying other cities, there is a range of 0% to 3% of expectations. Most of the following are indications, not actual settlements or decisions: 1. Maplewood 3% (has contracts in place for 2004) 2. Roseville 3% (proposal) 3. Plymouth some groups settled at 3% 4. Fridley 0% 5. St. Louis Park 1.75% 6. Andover 0% 7. Cottage Grove 0% 8. Maple Grove 3% 9. Minnetonka 1 -1.5% 10. Oakdale 1 -2% ii. While several of the above cities are not in our comparison group, Roseville and Maplewood are with increases and Fridley is proposing no increase. Our police wages are generally in the mid range of our comparable cities. Our public works salaries are in the lower range by comparison with our comparable cities. The long term issue we face is that if our comparable cities raise wages, we will have to increase either more later or less sooner. Also, where we have reduced staffing, people have met the challenges in public works. Each 1% salary increase is roughly $71,000 in annual cost. c. Insurance i. We anticipate a 12 -15% increase in the cost of health insurance for 2004 and a sharp increase in deductibles,. The draft budget does not include funds for an increased contribution by the City. It costs the General Fund roughly $14,500 per year for each $10 of contribution for health insurance. The budget reflects all emplovees at the full participation cost. There is an Page 14 of 15 expectation that the current actual level of participation will continue and provide some abilitv to address increased contribution to the cafeteria plan for health insurance. d. Unallotment i. If the November State revenue forecast is below current projections, which is believed to have a real potentiality, I would anticipate that the Governor would impound or unallot some, or all of the December 2003 LGA payments. These monies are what cash flow the following 6 months. The latest reports indicated that State revenue collections were only slightly below the planned level. The foregoing is a general review of the budget development process to date for purposes of soliciting continued Financial Commission reaction and suggestions in the refinement of the General Fund and the priorities for the budget. Page 15 of 15 5 Cities Transportation Summary based on 2002 52 % of rides are to grocery stores. o 15 /o of rides are outside Brooklyn Center with 2l3rds to Wal -Mart. 2,312 one -way rides cost $ 13,804 or $ 5.90 per ride. 80 residents were served at a cost of $172.55 per resident. Taxi Option I ical one -way ride were 3.5 miles at the going rate of 1.60 per mile the cost If the typ would be $ 5.60 per ride. Excluding 350 out of city rides the total annual direct transportation cost would be $ 10,987. Plus administrative cost. Including 350 out of city rides the cost would be $ 12,947.22 plus administrative cost. Taxi Option II Using a more likely average ride would be 2.5 miles @ $ 1.60 = $ 4.00 per ride. 1962 in -city rides would cost $ 7,848 plus administrative cost. A negotiated contracted may result in a lower cost per ride. Assessment: If the city was inclined to continue this program while lowering its deli I does appear feasible with the following caveats: very costs, Option 1. Demand could increase significantly eliminating any savings. 2. Current staff capacity would be required 3. The city would be taking on all of the risks associated with adding a new service, legal costs, liabilities etc. Page 16 5 Cities Transportation UnduPlicated Persons Served Apartments: 61 Homes: 19 Total: 80 Destinations and Riders- one -way Cub Foods: Rainbow Foods: 416 36% Leisure Time: (weekly cards) 300 26% Target: 91 8% Broolcdale: 71 6% Gifal /19art: 58 5% Brooklyn Twins:(iblonthly Activities) 122 10.5% -[ Yerly's: (Golden valley) 45 4% Brunch Lunch: / Cite"( outside Rest 12 1% Senior In Allind.• St. paul Ijistory Center 15 1961, Southdale: 10 1 Forum and Forl {: Westminster Presbyterian 13 1 Total 3 .029,,, 1156 Rides Apartments: 1,494 Homes: 818 Total: 2,312 Italics= Out of Brooklyn Cent 15% of ndes Qualifications for Participation = 60 years of age or person Ivith disability 2002 Cos( $ 13,804. 1d P as PRISM Eligibility —Any resident with preference to elderly and disabled. Summary based on 2003 data (Manager has agreed to revise previously reported data) • The revised data provided indicates there were 1045 medical related one -way rides made (1073 reported) • 69 (222 reported) individual residents received rides at accost of $ 10,000.00 • Average cost per one -way ride $ 10.45 • Average cost per resident served $ 144.93 • The over- whelming majority of the rides, go beyond the City limits; Oakdale Medical Center and North memorial are primary sites. Taxi Cab Option I • @ 1.60 per mile $ 10.67 would fund a one -way ride of 6.67 miles. o A round trip from City Hall to North Memorial is 11 miles which would cost $ 17.60 On its face Option I would not appear to be a cost effective alternative to the current system. Option II • While PRISM appears to be more convenient and easier to access than Metro Mobility. It does appear to be a viable alternative should PRISM go unfunded. • Metro Mobility eligibility standards will exclude some riders; a person must qualify under ADA. The process for qualifying may take up to twenty -one days. The cost of riding will range between $ 2.25 and $ 3.00 per one -way ride Assessment: Taxi Cab Option I does not appear to be a feasible alternative. If we continue the service we will need to monitor it regularly during the year. If we gather more information regarding Metro Mobility eligibility criteria and data regarding our current PRISM riders we may determine that the most cost - effect decision would be to assist our riders with the Metro Mobility eligibility process. Page 18 R5509BUD LOGIS002 CITY OF BROOKL , .. CENTER 7/31/2k, 15:04:05 Fiscal Period: 7 / 03 Budget Report Page - 1 Level Of Rollup 9 2000 2001 2002 7/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 10100 GENERAL FUND 411 MAYOR AND CITY COUNCIL 114,049 122,447 125,799 72,905 134,303 127,529 126,152 126,152 413 CITY MANAGER 178,759 171,580 184,024 101,837 205,689 179,905 179,905 179,905 414 CITY CLERK 149,746 134,144 164,974 77,538 164,505 163,995 163,995 163,995 415 FINANCE 660,590 659,738 681,497 382,928 675,467 686,908 686,908 686,908 416 LEGAL 276,384 262,061 342,716 123,810 250,000 250,000 250,000 250,000 418 HUMAN RESOURCES 183,699 191,595 194,377 125,612 225,156 217,067 217,067 217,067 419 OTHER GENERAL GOVERNMENT 983,761 1,096,417 979,661 612,373 1,040,680 11009,089 1,002,789 1,002,789 421 POLICE 4,434,553 4,684,127 5,088,384 2,906,545 5,452,700 5,115,293 5,115,293 5,115,293 422 FIRE 663,061 665,436 693,021 272,994 707,844 691,373 691,373 691,373 424 INSPECTION SERVICES 300,117 282,582 315,163 157,538 293,664 316,995 316,995 316,995 425 EMERGENCY PREPAREDNESS 43,347 43,246 53,472 31,119 61,706 61,458 61,458 61,458 431 PUBLIC WORKS ADMINISTRATION 651,750 668,292 579,767 228,785 575,663 439,756 439,756 439,756 432 MAINTENANCE - STREETS 1,462,527 1,487,251 1,406,925 591,685 1,359,789 1,270,411 1,270,411 1,270,411 441 SOCIAL SERVICES 95,148 106,034 103,491 67,128 93,105 83,087 83,087 83,087 450 CARS ADMINISTRATION 143,598 139,799 169,646 111,901 154,991 147,389 147,089 147,089 451 RECREATION ADMINISTRATION 1 1,040,137 1,042,112 608,632 1,272,869 1,025,766 1,023,266 1,023,266 452 MAINTENANCE -PARKS 855,401 863,225 814,651 466,243 1,028,744 909,357 900,857 900,857 453 CONVENTION AND TOURISM 408,585 401,681 348,145 121,264 339,750 330,000 330,000 330,000 481 UNALLOCATED EXPENSES 387,029- 404,325- 87,745- 10,178 276,868- 390,784- 390,784- 390,784- 482 OTHER FINANCING SOURCES 1,532,238 1,661,877 1,628,910 510,972 1,648,494 10100 GENERAL FUND 13,825,027 14,277,343 14,828,990 7,581,988 15,408,271 12,634,594 12,615,617 12,615,617 i b Iv UP (D i R5509BUD BC0006V CITY OF BROOKL... CENTER 7 /31 /k., -j 12:12:15 Fiscal Period: 7 / 03 Budget Report Page 1 Level Of Rollup 9 2001 2002 2003 7131/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 10100 GENERAL FUND 10100 GENERAL FUND 4000 REVENUES AND EXPENSES 4001 REVENUES 4050 TAXES 4100 AD VALOREM TAXES 4101 CURRENT AD VALOREM TAXES 7,623,927- 10,042,102- 10,141,725- 4,609,284- 9,174,978- 9,174,978- 4101 CURRENT AD VALOREM TAXES 7,623,927- 10,042,102- 10,141,725- 4,609,284- 9,174,978- 9,174,978- 4102 ALLOWANCE FOR UNCOLLECTIBLE 304,251 275,249 275,249 4120 DELINQUENT AD VALOREM TAXES 45,898 475,214- 83,289- 4150 TAX INCREMENTS 25,115- 39,510- 4154 PENALTIES & INT- DELINQ TAXES 1,623- 3,324 4,153- 4100 AD VALOREM TAXES 7,579,652- 10,539,107- 9,837,474- 4,736,207- 8,899,729- 8,899,729- 4160 GENERAL SALES AND USE TAXES 4161 LODGING TAX 826,957- 717,176- 700,000- 302,917- 660,000- 660,000- 4160 GENERAL SALES AND USE TAXES 826,957- 717,176- 700,000- 302,917- 660,000- 660,000- 4050 TAXES 8,406,609- 11,256,284- 10,537,474- 5,039,124- 9,559,729- 9,559,729- 4199 LICENSES AND PERMITS 4200 LICENSES 4201 LIQUOR LICENSES 104,144- 106,898- 105,000- 23,123- 105,000- 105,000- 4202 BEER LICENSES 75- 4,700- 2,500- 2,700- 2,700- 4203 GARBAGE HAULING LICENSES 3,130- 3,155- 3,000- 2,685- 3,100- 3,100- 4204 CIGARETTE LICENSES 4,090- 2,869- 3,500- 1,019- 3,000- 3,000- 4205 RENTAL DWELLING LICENSES 24,004- 69,223- 68,000- 25,336- 71,000- 71,000- 4206 TAXI CAB LICENSES 1,000- 600- 500- 1,400- 4207 MECHANICAL LICENSES 6,025- 6,169- 4,500- 5,324- 6,000- 6,000- 4208 PAWN SHOP LICENSES 12,000- 12,000- 12,000- 12,000- 12,000- 4209 SERVICE STATION LICENSES 2,877- 2,820- 2,500- 420- 2,800- 2,800- 4210 MOTOR VEHICLE DEALER LICENSES 2,250- 1,750- 2,000- 1,750- 1,750- 1,750- 4211 BOWLING ALLEY LICENSES 725- 720- 720- 720- 720- 4212 AMUSEMENT LICENSES 1,369- 2,130- 2,000- 1,995- 2,000- 2,000- 4213 MISCELLANEOUS BUSINESS LICENSE 2,330- 1,730- 2,500- 4,010- 4,000- 4,000- 4200 LICENSES 164,018- 214,763- 208,720- 67,062- 214,070- 214,070 - l70 CD Iv 4220 PERMITS O R5509BUD BC0006V CITY OF BROOKL . CENTER 7/31/2u„j 12:12:15 Fiscal Period: 7 / 03 Budget Report Page - 2 Level Of Rollup 9 2001 2002 2003 7/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 4221 SIGN PERMITS 3,715- 2,733- 3,000- 1,933- 3,000- 3,000- 4222 BUILDING PERMITS 497,287- 475,471- 310,000- 290,019- 350,000- 350,000- 4223 MECHANICAL PERMITS 77,802- 82,341- 50,000- 50,897- 55,000- 55,000- 4224 SEWER & WATER PERMITS 904- 1,693- 1,000- 1,338- 1,000- 1,000- 4225 PLUMBING PERMITS 40,823- 42,327- 35,000- 35,804- 35,000- 35,000- 4226 ROW PERMIT FEE 8,199- 4,668- 5,000- 4227 ELECTRICAL PERMITS 4228 MISC BUSINESS PERMITS 2,455- 40,000- 40,000- 4220 PERMITS 628,731- 609,233- 404,000- 382,445- 484,000- 484,000- 4199 LICENSES AND PERMITS 792,749- 823,996- 612,720- 449,506- 698,070- 698,070- 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 4311 CIVIL DEFENSE 4,555- 4310 FEDERAL REVENUE 4,555- 4340 STATE REVENUE 4341 LOCAL GOVERNMENT AID 2,179,744- 2,265,267- 2,501,033- 820,292- 820,292- 4342 HACA 1,380,106- 4343 MUNICIPAL STATE AID, STREETS -M 90,000- 90,000- 30,000- 45,000- 4345 PENSION AID -FIRE RELIEF 90,148- 102,269- 92,500- 92,500- 92,500- 4346 PENSION AID - POLICE 228,208- 244,840- 250,000- 250,000- 250,000- 4347 PENSION AID -PERA 34,365- 34,365- 34,365- 34,365- 34,365- 4349 LOW INCOME HOUSING AID 87,738 - 64,808- 59,887- 59,887- 59,887- 4350 SCHOOL CRIME LEVY 1,429- 2,000- 1,400- 2,000- 4351 911 PHONE SERVICE GRANT 18,296- 19,650- 15,000- 6,566- 15,000- 15,000- 4352 POLICE TRAINING GRANT 19,166- 17,393- 15,000- 16,400- 16,400- 4359 OTHER STATE GRANTS /AID 1,527- 3,036- 333- 4340 STATE REVENUE 4,130,727- 2,843,629- 2,999,185- 53,898- 1,288,444- 1,288,444- 4360 COUNTY GRANTS 4370 OTHER GRANTS /AID 4373 OTHER GRANTS /AID 5,525- 4374 POLICE LIAISON / DARE 57,333- 49,396- 4370 OTHER GRANTS /AID 5,525- 57,333- 49,396 - b 4300 INTERGOVERNMENTAL REVENUE 4,135,282- 2,843,629- 2,999,185- 59,423- 1,345,777- 1,337,840 - N R5509BOD BC0006V CITY OF BROOKL,,. i ENTER Fiscal Period: 7 / 03 Budget Report 7/31/2L,_., 12:12:15 Level Of Rollup 9 Page - 3 2001 2002 2003 7/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code /Description Amount Amount Budget 9 Actual Budget Budget 4399 CHARGES FOR SERVICES 4400 CHARGES FOR SERVICES - GENERAL 4403 PLANNING APPLICATION FEES 9,800- 7,700- 5,000- 5,600- 5,000- 5,000- 4404 ZONING CHANGES /SPECIAL USE PER 1,775- 1,775- 2,000- 1,050. 2,000- 2,000- 4405 SALE OF MAPS 8 DOCUMENTS 632- 895- 750- 274- 750- ' 4406 SALE OF PLANS &SPECS 1,284- 1,598- ,500 750- 2- 4407 ASSESSMENT SEARCHES 1 _ 1.700- 1,700- 75- 418- 100- 81- 100- 4408 REINSPECTION FEES 100- 94- 188- 500- 610- 1,000- 4409 SECTION 8 INSPECTIONS 1.000- 13,4$8- 16,848- 12,000- 2,712- 18,300- 4411 FILING FEES 18,300- 183 40- 20. 4412 ABATEMENT FEES 20- 20. 4413 FINAL PLAT &VACATION FEES 405- 360- 500- 495- 450- 450- 750- 650- 250- 125- 250- 4415 TREE CONTRACTOR REGISTRATION 250 - i,zso- 9,164- 1.000- 1,2so- 4400 CHARGES FOR SERVICES- GENERAL 1,100- 1,100- 29,746- 39,637- 24,620- 13,814- 30,67o- 30,670- 4420 CHARGES FOR SERVICES - PUBLIC SA 4421 POLICE REPORT REVENUE 3,831- 3,753- 2,700- 2,391- 2,700- 4422 LICENSE INVESTIGATIONS 2,350- 1,038- 2,000. 2,700. 4423 ANIMAL CONTROL REVENUE 2,550- 2,000- 2,000- 4,079- 3,549- 2,500- 1,245- 2,500- 4424 FIRE ALARM FEES 2,500- 4,200- 2,550- 2,500- 450- 3,000. 4425 BURGLAR ALARM FEES 3,000. 14,750- 10,325- 5,000- 875- 5,000. 4426 TOWING REVENUE 5,000. 1,794- 1,673- 750. 486- 750 - d427 POLICE SERVICE REVENUE 750- 4429 MISC POLICE REVENUE 3,141- 2,549- 1,500- 1,803- 2,000- 2,000- 693- 31- 500- 2,932- 500- 4420 CHARGES FOR SERVICES - PUBLIC SA 34 838_ - 500 25,468- 17,450. 12,732- 18,450- 18,450. 4430 CHGS FOR SERVICES- PUBLIC WORKS 4431 WEED CUTTING CHARGES 1,356- 461- 750. 4430 CHGS FOR SERVICES - PUBLIC WORKS 1,356- 461 - 750- 4470 CHARGES FOR SERVICES -CARS 4471 ADULT RECREATION PROGRAMS 214,627- 188,030- 218,950- 112,656- 213,692- 4472 TEEN RECREATION PROGRAMS 213,692- 5,293- 3,650- 6,800- 4,235- 4,800- 4473 CHILDREN RECREATION PROGRAMS 4,800- 77,773- 78,877- 90,322- 42,056- 47,208- 4474 GENERAL RECREATION PROGRAMS 47,208- 9,459- 4,619- 8,100. 6,612- 7450- 4470 CHARGES FOR SERVICES -CARS , 7,450. 307,152- 275,176- 324,172- 165,559- 273,150- 273,150- M 4480 CHARGES FOR SERVICES -COMM CTR Iv 4461 MEMBERSHIPS- FAMILY 24,453- 25,095 - N 24,000- 21,864- 36,000- 36,000- R5509BUD BC0006V CITY OF BROOKL , .. ,;ENTER Fiscal Period: 7 / 03 Budget Report 7/31/2t,,,- 12:12:15 Level Of Rollup 9 Page - 4 2001 2002 2003 7/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual 4482 MEMBERSHIPS - INDIVIDUAL Budget Budget 28,019- 24,697- 25,000- 22,203- 35,000. 4485 GENERAL ADMISSIONS - INDIVIDUAL 35,000- 83,307- 47,989- 85,000- 37,811- 76,000- 4486 GENERAL ADMISSIONS- GROUPS 76,000- ' 25,010- 20,924- 25,500- 14,348- 21,500- 4487 SWIM LESSONS 21,500- 81,756- 62,948- 81,000- 66,193- 85,000- 4489 LOCKER RENTAL 85,000- 6,305- 3,593- 5,500. 3,468- 5,500- 4491 DAY CARE SERVICES 84 5,500 - 3- 437- 900- 520- 4492 SPECIAL EVENTS 8,175- 10,850- 13,500 3,613- 7,500- 7,500- 4493 GAME ROOM 2,634- 837- 2,500- 1,000- 1,500- 1,500. 4494 MERCHANDISE FOR RESALE 9,277- 6,093- 7,000- 3,580- 7,000- 4495 CONSTITUTION HALL RENTAL 7,930- 10,348_ 12 7,000- 4496 GIFT CERTIFICATE 6,812' 13,000- 13,000- 253 194- 72 4497 CONCESSIONS 33,765- 21,001- 34,500 -_ 7,064- 250- 250- 4480 CHARGES FOR SERVICES -COMM CTR 311,240- 235,005- 316,900- 168,404- 288,250 - 288,250- 4399 CHARGES FOR SERVICES 684,333- 575,748- 663,892- 380,508- 610,520- 610,520. 4500 FINES & FORFEITS 4508 UNCLAIMED EVIDENCE 177_ 3,018- 4510 COURT FINES 4511 COURT FINES 230,408- 278,557- 200,000. 145,120 225,000- 4510 COURT FINES 225,000- 230,408- 278,557- 200,000- 145,120- 225,000 - 225,000- 4500 FINES & FORFEITS 230,584- 281,575- 200,000- 145,120- 225,000- 225,000- - 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4601 SPECIAL ASSESSMENTS 4,415 - 575- 4602 SPECIAL ASSESS - PENALTIES & INT 489- 35- 180- 4603 INTEREST EARNINGS 345,438- 211,198- 300,000- 4604 CHECK PROCESSING FEES 180- 330- 180. 150,000- 150,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 328,391- 5,858 4606 OTHER REVENUE 2,116- 4,207- 75,000- 88 75,000- 75,000- 4607 SPEC ASSESS INTEREST 110- 4600 MISCELLANEOUS REVENUE 681,029- 210,597- 375,000 2 225,000- 225,000- 4599 MISCELLANEOUS REVENUE 681,029- 210,597- 375,000- 272- 225,000- 225,000- 4900 OTHER FINANCING SOURCES UQ 2 4911 SALE OF PROPERTY 2.756- 9,710- lv 4912 CONTRIBUTIONS & DONATIONS 6,428 - W ,052- 410- 75- R5509BUD BCOOO6V CITY OF BROOKL , .. CENTER Fiscal Period: 7 ! 03 Budget Report 7/31/2%, -- 12:12:15 Level Of Rollup 9 Page - 5 2001 2002 2003 7/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 4921 REFUNDS 8 REIMBURSEMENTS 16,776- 89,287- 65,033- 1 4900 OTHER FINANCING SOURCES 21,584- 99,407- 71,537- 4001 REVENUES 14,952,170- 16,091,236- 15,408,271- 6,145,490- 12,664,096- 12,656,159- 4000 REVENUES AND EXPENSES 14,952,170- 16,091,236- 15,408,271- 6,145,490- 12,664,096- 12,656,159- 10100 GENERAL FUND 14,952,170- 16,091,236- 15,408,271- 6,145,490- 12,664,096- 12,656,159- 14,952,170- 16,091,236- 15,408,271- 6,145,490- 12,664,096- 12,656,159- 10100 GENERAL FUND 14,952,170- 16,091,236- 15,408,271- 6,145,490- 12,664,096- 12,656,159- ) b Al 0 CD N R5509BUD LOGIS001 CITY OF BROOKL,., CENTER Fiscal Period: 7 / 03 Budget Report 7/31/2%.-- 15:28:20 Level Of Rollup 9 Page - 1 2000 2001 2002 7/3112003 2003 2004 Actual 2004 2004 Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual 10100 GENERAL FUND Budget Budget Budget Budget 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5586 COST OF SALES -MISC 5580 COST OF GOODS SOLD 21,952 10,261 20,333 20,333 20,333 21,952 10,261 20,333 20,333 20,333 5550 DIRECT COST OF SALES 21 10,261 20,333 20,333 20,333 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 5,773,408 5,894,999 5,904,853 3,448,113 6,582,788 6,146,828 6,146,828 6001 EXPENDITURES /EXPENSES 6,146,828 21,952 10,261 6102 OVERTIME -FT EMPLOYEES 20,333 20,333 20,333 261,592 256,675 296,384 149,034 212,154 238,183 238,183 238,183 6103 WAGES -PART TIME EMPLOYEES 906,071 908,002 931,827 469,061 974,998 847,006 847,006 847,006 6104 OVERTIME -PART TIME EMPLOYEES 6,831 8,418 6,777 935 6106 WAGES - TEMPORARY EMPLOYEES 345 1,019 35,000_ 52,000 52,000_ 52,000 6100 WAGES AND SALARIES 6,948,246 7,068,094 7,140,859 4,067,143 7,804,940 7,284,017 7,284,017 7,284,017 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 6110 OTHER PAYMENTS -NON INSURANCE 71,257 52,453 71,257 52,453 6120 RETIREMENT CONTRIBUTUIONS 6121 PERA BASIC 485 6122 PERA COORDINATED PLAN 197,474 197,425 207,383 122,523 254,946 230,356 230,356 230,356 6123 PERA POLICE & FIRE PLAN 223,470 239,687 255,881 144,183 272,411 6124 PERA DEFINED CONTRIBUTION 239,426 239,426 239,426 1,417 1,820 2,005 1,191 2,065 2,138 2,138 2,138 6125 FICA 6126 MEDICARE CONTRIBUTIONS 361,640 369,294 316,273 156,281 416,386 274,475 274,475 274,475 6127 FIRE RELIEF ASSOCIATION 50,470 52,319 101,903 101,903 101,903 120,175 118,508 118,508_ 119,508 119,508 119,508 119,508 6120 RETIREMENT CONTRIBUTUIONS 904,662 926,735 950,519 476,498 1,065,316 967,806 967,806 967,806 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 561,203 606,018 649,179 428,033 771,000 735,420 735,420 6130 INSURANCE BENEFITS 561,203 606.018 735,420 649,179 428,033 771,000 735,420 735,420 735,420 6140 UNEMPLOYMENT COMPENSATION b 6141 UNEMPLOYMENT COMPENSATION 3,887 5,526 25,028 7,489 M 6140 UNEMPLOYMENT COMPENSATION 3,887 5,526 25,028 tJ 7,489 R5509BUD LOGIS001 CITY OF BROOKL , .. CENTER 7/31/2u -,, 15:28:20 Fiscal Period: 7 / 03 Budget Report Page - 2 Level Of Rollup 9 2000 2001 2002 7/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Bud et 9 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 91,653 90,196 131,124 92,689 177,140 188,356 188,356 188,356 6150 WORKER'S COMPENSATION 91,653 90,196 131,124 92,689 177,140 188,356 188,356 188,356 6099 PERSONAL SERVICES 8,509,650 8,696,568 8,967,968 5,124,304 9,818,396 9,175,599 9,175,599 9,175,599 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 26,425 25,000 23,666 8,749 31,775 26,000 26,000 26,000 6202 COPYING SUPPLIES 827 500 500 500 6203 BOOKS /REFERENCE MATERIALS 7,557 6,348 10,071 3,203 8,950 14,270 14,270 14,270 6204 STATIONARY SUPPLIES 11,003 8,928 1,077 2.100 100 100 100 6200 OFFICE SUPPLIES 44,984 40,276 34,815 12,779 42,825 40,870 40,870 40,870 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 18,009 18,306 17,976 12,271 21,000 21,000 21,000 21,000 6212 MOTOR FUELS 91 6214 CLOTHING & PERSONAL EQUIPMENT 48,917 81,686 58,416 20,540 66,820 66,270 66,270 66,270 6216 CHEMICALS /CHEMICAL PRODUCTS 14,584 13,325 8,873 5,148 18,000 18,000 18,000 18,000 6217 SAFETY SUPPLIES 5,615 9,133 5,668 78 11,800 10,750 10,750 10,750 6219 GENERAL OPERATING SUPPLIES 138,973 138,053 129,148 47,112 165,782 119,007 119,007 119,007 6210 OPERATING SUPPLIES 226,098 260,503 220,171 85,149 283,402 235,027 235,027 235,027 6220 REPAIR & MAINT SUPPLIES 6221 MOTOR VEHICLES 19 192 6223 BUILDINGS & FACILITIES 5,083 5,660 10,137 2,045 13,500 11,500 9,500 9,500 6224 STREET MAINT MATERIALS 122,223 121,453 98,132 44,698 105,000 100,000 100,000 100,000 6225 PARK & LANDSCAPE MATERIALS 23,678 28,292 24,279 3,092 27,500 24,500 24,500 24,500 6226 SIGNS & STRIPING MATERIALS 44,737 33,265 44,544 17,337 45,500 34,000 34,000 34,000 6227 PAINT SUPPLIES 68 500 500 500 6220 REPAIR & MAINT SUPPLIES 195,721 188,690 177,284 67,239 191,500 170,500 168,500 168,500 6230 REPAIR & MAINT SUPPLIES -OTHER 6231 ATHLETIC FIELD SUPPLIES 5,114 6,675 5,942 1,480 6,000 6,000 6,000 6,000 6232 TRAILWAY SUPPLIES 10,000 6233 COURT SUPPLIES 2,225 4,000 4,000 4,000 b 6236 DARE SUPPLIES 4,000 3,901 4,351 4,059 956 4,100 4,100 4,100 4,100 �Q 6239 OTHER REPAIR & MAINT SUPPLIES 36,593 30,517 27,946 10,478 28,250 27,250 27,250 27,250 "6230 REPAIR & MAINT SUPPLIES -OTHER 55,607 43,768 37,948 12,915 42,350 41,350 41,350 41,350 R5509BUD LOGIS001 CITY OF BROOKL... CENTER 7/31/2 ,,., 15:28:20 Fiscal Period: 7 / 03 Budget Report Page - 3 Level Of Rollup 9 2000 2001 2002 7131/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 2,984 2,829 3,778 956 2,750 8,250 7,250 7,250 6242 MINOR EQUIPMENT 4,661 4,489 25,268 4,504 3,700 5,300 5,300 5,300 6243 MINOR COMPUTER EQUIPMENT 15,100 14,800 14,800 6240 SMALL TOOLS & MINOR EQUIPMENT 7,645 7,318 29,047 5,459 6,450 28,650 27,350 27,350 6199 SUPPLIES 530,055 540,556 499,264 183,540 566,527 516,397 513,097 513,097 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 17,850 23,398 23,272 16,161 38,500 24,500 24,500 24,500 6302 ARCH, ENG & PLANNING 872 71,623 11,460 6303 LEGAL SERVICES 203,994 247,306 344,233 126,810 250,000 250,000 250,000 250,000 6305 MEDICAL SERVICES 8,924 13,503 6,577 2,033 14,250 12,075 12,075 12,075 6306 PERSONNEL/LABOR RELATIONS 2,007 2,436 695 90 2,500 6307 PROFESSIONAL SERVICES 59 134,584 49,090 95,500 114,735 114,235 114,235 6308 CHARTER COMMISSION 19 94 350 57 1,500 1,500 1,500 1,500 6309 HUMAN RIGHTS COMMISSION 300 500 600 6319 OTHER PROFESSIONAL SERVICES 202,267 180,167 6300 PROFESSIONAL SERVICES 435,934 467,262 581,833 205,701 402,850 402,810 402,310 402,310 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 120,593 121,402 117,273 57,802 129,971 94,915 94,915 94,915 6322 POSTAGE 53,416 49,777 52,290 28,134 56,300 47,000 47,000 47,000 6323 RADIO COMMUNICATIONS 4,385 13,170 4,954 36 4,769 4,769 4,769 4,769 6324 TELEPROCESSING SERVICES 3,978 2,000 2,000 2 pp0 6329 OTHER COMMUNICATION SERVICES 145 4,344 5,984 2,157 9,400 3,100 3,100 3,100 6320 COMMUNICATIONS 182,516 188,693 180,501 88,129 200,440 151,784 151,764 151,784 6330 TRANSPORTATION 6331 TRAVEL EXPENSE /MILEAGE 7,327 7,916 8,498 4,552 9,830 8,800 8,800 8,800 6332 CONTRACTED TRANSPORTATION 711 9,150 6333 FREIGHT /DRAYAGE 403 522 822 337 150 500 500 500 6339 OTHER TRANSPORTATION EXPENSE '5,563 3,561 4,884 1,456 2,317 2,317 2,317 6330 TRANSPORTATION 13,294 11,999 14,915 6,345 19,130 11,617 11,617 11,617 � 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 12,092 14,093 11,725 3,837 14,000 3,500 3,500 3,500 � 6 42 3 LEGAL NOTICES 9,178 10,214 7,480 4,338 10,320 8,490 8,490 8,490 ' R5509BUD LOGIS001 CITY OF BROOKL,.. VENTER Fiscal Period: 7 / 03 Budget Repoli 7/31/21,.,,, 15:28:20 Level Of Rollup 9 Page - 4 2000 2001 2002 7/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual 6349 OTHER ADVERTISING Budget Budget Budget Budget 10,367 5,772 3,379 1,089 11,000 6340 ADVERTISING 6,000 6,000 6,000 31,637 30,078 22,585 9,264 35,320 17,990 17,990 17,990 6350 PRINTING AND DUPLICATING 6351 PRINTING 43,006 33,661 42,025 22,684 48,450 6350 PRINTING AND DUPLICATING 44,050 44,050 44,050 43,006 33,661 42,025 22,684 48,450 44,050 44,050 44,050 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 109,596 126,413 134,002 133,904 129,780 132,704 6362 PROPERTY INSURANCE 15,210 17,126 19,059 132,704 132,704 24,703 19,275 26,581 26,581 26,581 6364 DRAM SHOP INSURANCE 583 3- 3 I 6366 MACHINERY BREAKDOWN INSURANCE 3,639 3,912 4,261 4,970 4,676 5,159 6368 BONDS INSURANCE 2,868 2,782 2,736 5,159 5,159 6369 OTHER INSURANCE 407 2.196 3,570 1,957 1,957 1,957 6360 INSURANCE 132,304 150,234 160,053 165,776 157,301 166,401 166,401 166,401 6380 UTILITY SERVICES 6381 ELECTRIC 330,441 332,514 171,139 101,515 197,150 6382 GAS 110,778 199,072 106,776 125,239 '145,500 186,650 186,650 186,650 383 WATER 153,000 145,500 145,500 6384 REFUSE DISPOSAL 11,199 11,628 10,623 3,116 13,330 13,130 12,130 12,130 6 6385 SEWER 42,762 41,485 39,833 16,633 49,500 49,850 49,850 49,850 6386 STORM SEWER 11,221 10,362 9,918 4,514 12,100 11,950 11,950 11,950 26,526 29,022 27,320 14,200 6387 HEATING OIL 27,200 27,450 27,450 27,450 4 6388 HAZARDOUS WASTE DISPOSAL ,200 5,700 5,700 5,700 5,700 6389 STREET LIGHTS 2,186 109 500 750 750 750 5,670 2,885 6380 UTILITY SERVICES 532,928 628,282 373,467 268,210 450,980 448,480 439,980 439,980 6400 REPAIR & MAINT SERVICES 6401 MOTOR VEHICLE SERVICES 250 6402 EQUIPMENT SERVICES 124,738 159,628 164,641 41,818 135,145 117,775 117,775 117,775 6403 BLDGS /FACILITIES MAINT SERVICE B19 28 25,405 6,400 8,000 6404 STREET MAINT SERVICES 98,194 ,194 8,000 8,000 90,000 90,000 90,000 6405 PARK & LANDSCAPE SERVICES 9,168 20,021 11,520 13,806 6407 TRAFFIC SIGNALS MAINT 8,000 18,500 18,500 18,500 2,535 3,840 2,934 1,151 3,500 3,500 3,500 6408 COMMUNICATION /INFO SYSTEMS 3,500 I 14,725 14,568 16,283 12,733 24,912 23,482 23,482 23,482 6409 OTHER REPAIR & MAINT SVCS 11,011 23,127 3,443- 6400 REPAIR & MAINT SERVICES 2 7,500 7,200 7.200 7.200 162,797 221,185 318,592 91,924 185,457 268,457 268,457 268,457 UQ CD "6410 RENTALS R5509BUD LOGIS001 CITY OF BROOKL ... -;ENTER Fiscal Period: 7 / 03 Budget Report 7/31/2t,.,,, 15:28:20 Level Of Rollup 9 Page 5 2000 2001 2002 7/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6412 BLDGS /FACILITIES 6413 OFFICE EQUIPMENT 2,484 8.119 300 5,350 5,350 5,350 6415 OTHER EQUIPMENT 2,675 7,447 13,680 13,680 13,680 6417 UNIFORMS 7,292 6,193 6,311 177 13,550 2,400 2,400 2,400 I 171 1,140 6419 OTHER RENTAL EXPENSE 1,750 1,750 1,750 400_ 600 126 750 6410 RENTALS 7,692 6,793 11,766 17,634 13,850 23,180 23,180 23,180 6420 IS SERVICES /LICENSES /FEES 6421 SOFTWARE LICENSE 1,513 1,431 1,500 10,530 10,530 10,530 6422 SOFTWARE MAINT 5,443 3,837 23,169 20,129 22,460 25,720 25,720 25,720 6423 LOGIS CHARGES 247,836 256,983 276,687 239,635 358,811 268,089 268,089 268,089 6428 PROTECTION SERVICES 1,190 1,843 2,122 1,343 2,000 1,600 1,600 1,600 6420 IS SERVICES /LICENSES /FEES 254,470 262,663 303,492 262,538 384,771 305,939 305,939 305,939 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 20,927 7,369 19,643 1,022 49,495 13,150 13,150 13,150 6432 CONFERENCES AND SCHOOLS 106,722 88,014 74,003 28,873 110,180 89,830 6433 MEETING EXPENSES 86,830 86,830 454 536 6,014 2,628 550 2,350 2,350 6434 DUES & SUBSCRIPTIONS 50,586 53,481 53,252 36,619 58,580 52,420 51,043 .2,350 51,043 6435 CREDIT CARD FEES 3,137 3,931 4,321 3,994 3,500 5,300 5,300 5,300 6436 UNCOLLECTIBLE CHECKS /DEBTS 211 931 130 6430 MISCELLANEOUS 182,036 154,138 157,363 73,136 222,305 163,050 158,673 158,673 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 398,610 393,792 344,237 122,560 333,000 332,625 332,625 332,625 6442 COURT AWARDS /SETTLEMENTS 6,123 9,134 6,717 2,489 10,000 15,000 15,000 6443 PRIZE AWARDS /EXPENSE REIMB 6,325 5,150 2,884 15,000 6,325 2,650 2,650 2,650 6444 RELOCATION EXPENSES 6446 CONTINGENCY ACCOUNT 1,931 6447 TOWING CHARGES 69,110 634 560 150 120 6448 PRISONER BOARDING CHARGES 700 700 700 700 81,892 82,831 102,419 57,789 120,000 140,000 140,000 140,000 6449 OTHER CONTRACTUAL SERVICE 262,806 243,810 256,317 144,267 207,865 188,433 186,133 186,133 6440 OTHER EXPENSES 750,065 736,453 714,990 332,040 747,000 679,408 677,108 677,108 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 85,333 103,830 79,617 42,787 96,036 100,350 6462 FIXED CHARGES 503,874 467,595 523,252 253,060 540,266 538,513 100,350 100,350 b 6463 REPAIR & MAINT CHARGES 538,513 538,513 326,053 314,734 337,876 131,336 348,615 348,620 348,620 348,620 M 6465 REPLACEMENT CHARGES 19,021 13,786 18,952 N6460 CENTRAL GARAGE CHARGES 934,281 899,945 940,745 427,182 1,003,869 987,483 987,483 987,483 1 R5509BUD LOGIS001 CITY OF BROOKL _ CENTER 7/31/2%,,,,, 15:28:20 Fiscal Period: 7 / 03 Budget Report Page - 6 Level Of Rollup 9 2000 2001 2002 7/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget 9 Budget Budget Budget 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 317,233- 335,526- 353,374- 206,549- 354,084- 354,084- 354,084- 354,084- 6472 ENGINEERING SERVICE TRANSFER 378,504- 331,978- 330,000- 330,000- 330,000- 330,000- 6473 STORM SEWER TRANSFER 100,000- 100,000- 100,000- 58,333- 100,000- 100,000- 100,000- 100,000- 6474 DEBT SERVICE FUND TRANSFER 258,488 247,697 259,168 119,994 1,043,494 6476 CAPITAL PROJECT FUND TRANSFER 100,000 245,700 285,000 125,000 6477 SPEC ASSESS FUND TRANSFER 394,197 409,044 555,000 480,000 6478 BLDG DEBT SERVICE FUND TRANSFE 779,553 759,436 764,742 390,978 6480 GENERAL FUND REIMBURSEMENT 85,717- 6470 TRANSFERS AND OTHER USES 736,501 894,373 1,324,819 246,090 864,410 784,084- 784,084- 784,084- 6490 OTHER MISC COSTS /EXPENSES 6491 MERCHANDISE FOR RESALE 38,948 37,287 21,441 12,602 39,300 8,200 8,200 8,200 6490 OTHER MISC COSTS /EXPENSES 38,948 37,287 21,441 12,602 39,300 8,200 8,200 8,200 6299 OTHER CHARGES 8 SERVICES 4,438,407 4,723,046 5,168,587 2,229,255 4,775,433 2,894,765 2,879,088 2,879,088 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6512 LAND IMPROVEMENTS 14,069 6520 BUILDINGS 8 FACILITIES 7,692 5,000 6530 IMPROVEMENTS 89,048 81,028 1,400 90,000 6540 EQUIPMENT $ MACHINERY 16,544 85,967 7,985 109,535 27,500 27,500 27,500 6545 OTHER EQUIPMENT 104,031 103,775 6550 MOTOR VEHICLES 11,125 7,339 6560 FURNITURE 6,459 1,104 6,000 6570 OFFICE EQUIPMENT 10,708 1,761 7,405 1,385 1,700 6580 INFORMATION SYSTEMS 87,126 90,071 69,791 25,258 35,680 6501 CAPITAL OUTLAY 330,259 300,518 165,667 34,627 247,915 27,500 27,500 27,500 6500 CAPITAL OUTLAY 330,259 300,518 165,667 34,627 247,915 27,500 27,500 27,500 6600 DEBT SERVICE 6602 OTHER DEBT - PRINCIPAL 16,656 16,656 5,552 6600 DEBT SERVICE 16,656 16,656 5,552 'W001 EXPENDITURES /EXPENSES 13,825,027 14,277,343 14,828,990 7,581,988 15,408,271 12,634,594 12,615,617 12,615,617 (TQ CD tNl 100 GENERAL FUND 13,825,027 14,277,343 14,828,990 7,581,988 15,408,271 O 12,634,594 12,615,617 12,615,617 i