Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2002 10-07 CCP Work Session
• AGENDA CITY COUNCIL WORK SESSION October 7, 2002 6:00 P.M. COUNCIL COMMISSION CONFERENCE ROOM 1 St FLOOR CITY HALL Joint Meeting with Financial Commission 1. Review Audit Services a. Discussion of increased costs for 2002 audit. 2. Capital Improvement Plan a. Discussion of draft and development of plan 3. Utilities a. Water b. Sanitary Sewer c. Stormwater d. Street Light Utility e. Recycling • 4. Draft Enterprise Fund Budgets (non - utility) a. Liquor b. Golf c. Earle Brown Heritage Center 5. Miscellaneous 6. Adjourn • OX City of Brooklyn Center A Millennium Community To: Mayor Kragness and Council Members Lasman, Nelson, Peppe, and Ricker Financial Commission From: Michael J. McCauley City Manager Date: October 3, 2002 Re: Utility Budgets and Capital Improvements Plan The budget work session this Monday will review 1. Proposed increased audit costs 2. Truth in taxation hearing 3. The preliminary work on the Capital Improvement Program 4. Ranges of utility rates to support operations and capital improvement needs 5. Earle Brown Heritage Center 2003 preliminary budget 6. Liquor Store 2003 preliminary budget. • 7. Golf Course budget This meeting is an opportunity to review the draft budgets to see if the direction being developed comports with the Council's direction, with the advice of the Financial Commission. This year has been a very challenging year from a budget and staffing perspective. The General Fund budget development has again been delayed due to uncertainty with the Legislature and the lack of good information on aids and levy limits until the end of August. This is compounded by the .767 of 1% growth in revenue from the combined sources of real estate taxes and local government aids. This also means that the planned use of surplus to fund capital projects such as neighborhood streets and the Capital Improvements Fund will be greatly reduced. There have been and are several staff changes at senior levels. We have recently completed a review of the public works department and are in the process of recruiting a new Public Works Director /City Engineer. While we have been able to maintain day to day operations and work on completing this year's projects, we have not had an adequate opportunity to focus on long range capital planning and have discovered some areas of past effort that have not been as comprehensive as they have been thought to have been. Other staffing issues this year have and will include hiring a new police chief and replacing the Assistant City Manager. With a new public works director /city engineer it is an appropriate juncture to take a fresh look at our capital planning. 0 6301 Shingle Creek Parkway g a way Recreation and Community Center Phone &TDD Number Brooklyn Center, MN 55430 -2199 (763) 569 -3400 City Hall & TDD Number (763) 569 -3300 FAX (763) 569 -3434 FAX (763 ) 569 -3494 www. cityofbrooklyncenter. org • TRUTH IN TAXATION HEARING We have received notification that the calculations for determining whether the City is required to conduct a truth in taxation hearing have been completed. Our decreased levy combined with increased local government aid is less than the threshold for requiring a truth in taxation hearing. The City can conduct a truth in taxation hearing even though it is not required. The Council did set a truth in taxation hearing date, which has been reported in the Sun Post. The cost of having a truth in taxation hearing would be insertion of the required advertisements in the Sun Post. The downside of canceling the truth in taxation hearing would be potential confusion associated with having set a date and the newspaper story reporting the setting of that date. The question for the City Council is whether it wishes to cancel the truth in taxation hearing or continue with the date that was set. CAPITAL IMPROVEMENT PROGRAM The Capital Improvement Program that is being reviewed will implement the 2003 projects contained in the 2002 -2006 Capital Improvement Program. The major change in the Program is inserting a street project in 2004 for the area around Northport School that was not contained in the 2002 -2006 Program and pushing the neighborhood street projects identified for 2004 -2006 in the Capital Improvement Program into the 2005 - • 2007 time frame. This area around Northport is being added in response to Mr. Howard's evaluation that the water utility ssues in this area are critical. This evaluation is shared b Y Y Mr. Hartfiel, Superintendent of Public Works. Mr. Howard had expressed concern that this project had not been part of the Capital Improvement Program. The problems in this area had not been brought to my attention prior to Mr. Howard raising the issue this past Spring, so we are unable to explain why the Public Works Director had not included this project as part of the discussion of priorities. We are not making many changes to the Capital Improvement Program from the 2002- 2006 Program. However, with new personnel being hired and the need to have a more comprehensive planning process, the Capital Improvement Program needs to be re- evaluated in 2003 with the benefit of a fresh look at the City and its priorities. As Ms. Chambers has worked on the Capital Improvement Program, it is apparent that some of the coordination and long range planning we had believe to be in place is not at the desired level. We are removing minor sidewalk repair /improvements from the Capital Improvement Program to Streets operating budget ($10,000 range). We will retain major sidewalk projects in the Capital Improvement Program. Contained in the Capital Improvement Program are projects for Shingle Creek Parkway in 2004 and Earle Brown Drive /Summit Avenue in 2005. With the Smart Growth process, it may not be advisable to undertake these projects until a plan is developed for the area or it is determined that improving these roads will not be impacted by later • development. Xerxes in the Brookdale area has been moved from 2005 to a holding place • in 2008 for the same planning reasons. Working with Hennepin County on the enhancement grant monies available from Hennepin County, this project may be returned to an earlier point. These projects primarily impact MSA funding and thus do not as directly impact the availability of funds for neighborhood street reconstruction, except as to utilities. The Shingle Creek project would directly impact the City's Capital Improvement funds since the City would bear a large assessment in front of the Community Center for the project. The issue of sustainability of the neighborhood street reconstruction program remains unchanged. The inability to increase revenues in the General Fund leaves revenues flat to declining. We may have to return to the use of debt if we are otherwise unable to increase funding for street reconstruction. I do not want to embark on a discussion of debt as a source for neighborhood street reconstruction until the new director of public works is in a position to present a better picture of our needs. A system has been used to weight utility needs and street needs to determine which projects are priorities. However, the system needs to be improved and the evaluations contained in the planning and the program itself. I have been requesting more detail on the evaluation as part of the Capital Improvement Program process with limited success in prior years. Parks will need to be reviewed carefully in 2003 with the Park & Recreation Commission. We need to include the Community Center in that planning to replace equipment and keep the facility at a higher level. That is, we should treat the exercise and other equipment and other furnishings in the Community Center in the same fashion as a • park: scheduled replacement and upgrading. Money for an aggressive skate park is added to the Capital Improvement Program in 2003. The issue of outfield flooding in Central Park needs further study. We have removed debris from the weir at Bass Lake Road and this has improved flow, but may not provide enough relief depending on the water levels. EARLE BROWN HERITAGE CENTER The 2003 preliminary budget for the Heritage Center reflects increased insurance and Logis charges. Revenue forecasts reflect the downturn in the economy, though the Heritage Center has been holding its own in the downturn, seeing a smaller reduction in bookings than other venues such as the Minneapolis Convention Center. As with past years, the budget reflects targets and most capital expenditures will be delayed until profits are actually earned or booked to the point that the expenditures will be covered. We are also looking to implement a capital fund for the Earle Brown Heritage Center so that profits can be placed in the fund for capital expenditures, rather than paying for them out of current operations. This would even out the process and separate operations from major expenditures such as carpet. Other challenges facing the Heritage Center this year have included de- watering and the need to replace the roof over the pre - function area entry to the Hippodrome. • • LIOUOR STORE The Liquor store budget reflects anticipated continuation of established patterns of sales and costs. One item for future consideration is whether an additional store at 69 and Brooklyn Boulevard would result in a net increase in profits and be worth the investment of time etc. UTILITIES The rate studies are being updated to reflect the Capital Improvement Program and additional mandates. The federal government has mandated wellhead protection studies and efforts as part of homeland security that will add cost. As indicated above, there are utility infrastructure needs that may not have been fully reviewed and incorporated in our planning that will need to be assessed in 2003. The rate studies show 3% increases in each of the utilities. I would make the following preliminary recommendations: - Water: 3% to 4% increase o Rationale: utility replacement is driving neighborhood street projects and utility fees need to become larger portion of funding source - Sanitary Sewer: 3 to 4% increase o Same rationale as water • - Street Light Utility: 1 -2 % increase o Rationale: fund should perform sufficiently well in short-term and in absence of identified projects it should not be raised beyond a modest adjustment in only its second year - Storm Water Utility: 3% increase o Rationale: rate increase needed in short-term to get balance in positive territory; this will need adjustment over time with projected balances, but there are unidentified future maintenance issues that may impact planning - Recycling: no increase if not considering annual clean -up and 2 to 3% increase if considering repeating annual clean-up We are also consolidating the number of separate divisions in the utilities, similar to what we are undertaking in the General Fund portion of Public Works, combining operating, facilities, and construction into one division for water and one division for sanitary sewer. RECYCLING Recycling has been and contiues to operate at a stable level. The results of the clean-up: City Trash Scrap Applianoes *Appl. Tans Tat Tans Tot LbsJFH Recycled Tans Rec. Ib&W1 BroMyn Certer 454.05 78.46 1,436.00 100.31 632.82 153.86 178.77 43.46 Crystal 611.17 86.87 1,558.00 105.17 803.21 208.30 19204 49.80 • NewHope 405.00 58.24 935.00 63.11 526.35 205.17 121.35 47.30 TOTAL 1,470.22 223.57 3,979.00 258.58 1,962.37 186.28 49215 46.72 *The State estirretes an a e age vie ght d 135 lbs. per appliance • The cost of the pick up was approximately $310,000 for all three cities combined. The cost per household will have been approximately $14.70. Whether this is something to continue is a question for Council direction. Continuation of the program would require a modest increase in rates over time. If the consortium used fund balance, the increase in rates could be blended over time if the Council wanted to continue the program. In 2003, there still remain sufficient reserves to fund another clean-up without increased rates. GOLF The golf course has suffered its second consecutive year of poor weather that has negatively impacted revenues. Careful management of the operation and previously accumulated capital monies has kept the operational performance profitable and with reserves able to make its capital and loan commitments • SMT City of Brooklyn Center A Millennium Community To: Mayor Kragness and Council Members Lasman, Nelson, Peppe, and Ricker Financial Commission From: Michael J. McCauley City Manager Date: October 3, 2002 Re: Audit Attached is a memorandum from Mr. Sell regarding the 2002 audit. This item is on the agenda to discuss the response to Deloitte & Touche's proposal that is higher than anticipated. My recommendation would be to respond to Deloitte & Touche that their proposal needs to come closer into line with expectations or we will re -open discussions with the other firms that were interviewed last year. If we were to re -open discussions, I would suggest revisiting all of the firms reviewed last year. • 6301 Shingle Creek Parkway Recreation and Community Center Phone & TDD Number Brooklyn Center, MN 55430 -2199 (763) 569 -3400 City Hall & TDD Number (763) 569 -3300 FAX (763) 569 -3434 FAX (763) 569 -3494 www.cityolbrooklyncenter.org Memorandum Date: October 1, 2002 To: Michael J McCauley City Manager From: Douglas Sell Director of Fiscal and Support Services RE: Audit Services We received a proposal for audit services from Deloitte and Touche, the city's current audit firm, for services to be provided regarding our 2002 financial statements and accounts. The proposal has a base cost of $40,500 for an estimated 450 hours of service plus and additional $2,500 for a compliance review of SAS No. 82 relating to information systems. The total proposed cost for 2002 audit services is $43,000 for 450 hours of service. The agreement for 2002 services provided for 393 hours of service at a total cost of $32,625. Applying the same "average hourly" cost model we used when originally evaluating each • proposal in the fall of 2001, it is determined that the average hourly cost for Deloitte and Touche is $95.56 for the services proposed in their letter of September 26, 2002. This represents an increase of $12.54 (over 15 %) per hour over the 2001 rate of $83.02: Mr. Hoffman is proposing an increase of nearly 60 hours (450 hours versus 393 hours) for services to be provided in 2003. The proposal received from Deloitte and Touche provided for a 3% increase to the average hourly rate from year to year. The projected expense in the 2003 budget is $34,500. It is our suggestion that the Deloitte and Touche offer be rejected as it is clearly outside the parameters contained in their proposal from 2001 and well above the budgeted amounts for 2003. We are suggesting that the proposal submitted by the next low proposer be evaluated and, if possible, negotiate an agreement more in line with our ability to pay and expectations for service. We are seeking your direction as firms are scheduling clients for audit services during the October time frame and it is in the City's best interest to come to an agreement to ensure quality services in a timely manner. • Deloitte &Touche LLP 400 One Financial Plaza 120 South Sixth Street Minneapolis, Minnesota 55402 -1844 Tel: (612) 397 -4000 Fax: (612) 397 -4450 • www.us.deloine.com Deloitte & Touche September 26, 2002 Mr. Douglas Sell Director of Fiscal and Support Services City of Brooklyn Center 6301 Shingle Creek Parkway Brooklyn Center, Minnesota 55430 -2199 Dear Mr. Sell: With the end of the year fast approaching, we would like to open discussions with you regarding our professional fees to audit of the City of Brooklyn Center's (the City) financial statements for the year ending December 31, 2001. The City has been a valued client of Deloitte & Touche for more than ten years and we are dedicated to continuing our relationship. As you are no doubt aware, the past year has been one of unprecedented change in our industry. Approximately one year ago, we discussed a number of conditions that continue to impact our • profession and correspondingly, our existing fee arrangement. In addition to those factors, the AICPA has adopted a new auditing standard (Statement on Auditing Standards No. 82 — Consideration of Fraud in a Financial Statement Audit) which requires that we perform additional inquiries and tests of certain transactions to test for the existence of fraud. Our original bid for the 2001 audit was based on an estimate of 393 hours at a cost of $36,250. In December 2001, we mutually agreed to a fee not to exceed $32,625, based on the assumption that our hours would decrease significantly due to the elimination of the disruptions caused by termination of the City Finance Director and turnover of Finance Department staff in 2000. While our hours did decrease from 600 in 2000 to 495 in 2001, they continue to be well in excess of the 393 hours estimated in our proposal and in reality, more closely approximate the level of effort that has been required in years prior to 2000. In our November 2001 proposal, we agreed to perform the audit of the City for 2001, 2002, and 2003 subject to annual review and negotiation of terms (including a price acceptable to both the City and audit firm). Based on the level of effort we have devoted to our audit of the City's financial statements in both 2001 and years prior, the 2001 base fee does not provide an acceptable level of profitability. Accordingly, our fee proposal for 2002 is $43,000 plus expenses, based on the following: • An hourly rate of $88 (consistent with our November 2001 proposal) adjusted by 3% for inflation, multiplied by • Deloitte Touche Tohmatsu • Page 2 September 26, 2002 • An estimated base number of hours of 450 (determined based on an average of our actual hours over the past five years, excluding fiscal 2000), plus • An amount of $2,500 reflecting changes in audit scope necessary due to comply with the provisions of SAS No. 82. As our agreement provides that we review and negotiate terms annually, we wanted to address this issue well in advance of the end of your fiscal year. We also recognize that the City is attempting to keep its costs as low as possible and we would fully understand if you deemed it prudent to request proposals from other firms in order to ensure that you are receiving appropriate value for your fees. We have appreciated the opportunity to have been of service to the City and look forward to continuing our relationship. Sincerely, r i afford W. Hoffman Audit Partner • • 2003 -2008 C P • _ o u Year Project Description riding on Sources General Fund Special Infrastructure Capital Water Utility Sewer Utility Storm Sewer Street Light MSA Grants Total Project Assessment Improvements Improvements Utility Utility Cost Fund Fund Fund 2003 - - - - - -- - - - - I - -- -- - -- -- - - -- J 2003 Central Park Tennis courts conversion to $ 50,000 I I 1 $ 50,000 basketball courts 2003 Grandview Park Shatter bktg, rink, lights - $ - 225,1300 - I I $ 225,000 2003 Twin Lakes Study Water quality study - - _ _ _ -_ I - I $ 65,000 1 1 $ 65,000 2003 73rd Avenue Humboldt to Palmer Lake _ _ I $ 64,390 $ 107,955 $ 61,800 $ 58,350 $ 42,530 1 $ 335,025 2003 Happy Hollow Improv Project Neighborhood street project _ _ $ 437,960 $ 582,792 _ $ 395,500 $ 373,440 $ _ _253,255 $ 51,090 I $ 2,094,037 2003 River Bank Stabilization Project C ooperative project with $ 100,000 1 1 $ 100,000 Corps of Engineers 2003 TH #100 Utilities Relocate public utilities _ I _ _ -__ Is 150,000 $ 100,000 I $ 50,000 1 1 $ 300,000 2003 Evergreen Park Scoreboards _ _ _ _ _ $ 11,600 I _ _ I - I I 1 $ 11,600 2003 Palmer Lake Trail Construct trail - _ - J $ 75,000 J J - - -_ _- I $ 50,000 1 $ 125,000 2003 Aggressive Skate Park Skate park I $ 30,000 I - _ I - I I $ 30,000 Total 2003 $ - - 1 $ 502,350 $ 690,747 $ _ 391,600 j$ 607,300 $ 631,790 1 $ 410,785 J$ 51,090 $ - J$ 50,000 1 $ 3,335,662 2004 -- 2004 Grandview Park Football/Soccer field, rights, - -___ -__- 1 $ 1 J 1 $ 330,000 baseball field and playgmd_ _ 2004 Northport Improv Project Neighborhood street project _I $- __ _ 6 00,000 $ 610,000 610,000 _ $ _ 597,450 $ 555,610 $_ 435,810 I $ 86,620 $ _ 340,000 I $ 3,225,690 2004 Shingle Creek Pkwy Street improvement project L$ _- 2 _ $ 10,000 $ 10,000_ $ - 20,000 1 $ 350,000 I J$ 635,000 2004 Evergreen Park Sidewalks Sidewalk construction I $ 50,000 I I I I $ 50.000 _Total 2004! $ _ - _ _ - J $ _ 845_,000 $ 660,000 $ 330_ ,000 _ $ 607,450 $ 565,6101 $ 455,810 1 $ 86,820 $ 690,000 1 J$ 4,240,890 2005 1 2005 :entrelPark Jyhprg J - - _ -. $ 230,000 $ 230,000 2005 Earle Brown Improv Project :Street improvement project _ _ 1 $ 109,200 _ _ _ J I I $ 156,000 1 I $ 265,200 2005 Tangletown Improv Project South Street Improvement project I $ 726.530 $ 909.490 I $ 641.605 $ 605.805 I $ 456.845 I $ 85.370 I I $ 3,425.645 Total 2005. $ - $ 835,730 $ 909,490 i $ 230,000 J$ 641,605 $ 605,805 I $_ - 456,845 J $ _ - _ 85,370 $ 156,000 J _ _ I $ 3,920,645 I I I I I 2006 2006 Garden City Park Shelter bldg $ 90,000 _ _ - _ _ - - $ 90,000 2006 Kylawn Park Shelter bldg, trails and lights _ $ 190,0001 - _ _ _ _ - - - 1 $ 190,000 2008 Riverdale Park Shelter bldg _- _ - $ 35,0001__ J -_ -_ J $ 35,000 -- 2006 Dupont Avenue Improv Project Street improvement project $ 382,320 - I $ 113,950 $ 107,500 J $ 2.8,860 1 $ _- 268,750 1 $ 899,380 2006 Humboldt Avenue Improv Project Street improvement project $ _ 200,000 _ $ 100,000 $ 50,0001 _ -- f $ 4 J_ I $ 750,000 2006 Tangletown Improv Project North Neighborhood street project - _ $ 490,005 $ - 7 J$ _44_5,815 $ 420,940 ] $_ 3 $ - 59,315 _ _ I_ J$ 2,482,920 m 2008 Lift Station #9 Forceain replacement - _ I $ 200,0001 _ - 1 I I $ 200,000 2006 Lift Station #2 Forcemain and Interceptor I $ 300,000 I I I $ 300,000 Total 2006 $- _ - I $ 1,072,325 $ 761,775 $ - 315.0001$ 6.59,765 _ $ 1,078,440 $ 3 31,930 I $ 59,315 $ 668,750 1 J$ 4,947,300 2007 2007 West Palmer Lake Park Shelter bldg 1 $ 100,000 $ 100,000 2007 Riverwood Improv Project Street improvement project ... J $ 583,480 $ 843,260 _ $ 567.230 __535,590 _$___46__4,060 $ _ 7 _ _ _ _ $ 3,066,890 2007 Freeway Blvd Improv Project Street improvement project - I I $ Total 2007 $ 583,480 $ - 843,280 $ 100,000 1 $ 587,230 $ 535,590 J $ 484,080 $ 73,270 $ 1 1 $ 3,166,690 - - - 1 2006 - 2008 East River Improv Project _ Street Improvement project _ $ 497,460 $ 585,210 _ I $ ___ 269,700 $ 442,100 I $ 321,100 J $ 54,800 $ 110,300 J I $ 2,280,690 2008, Marenatha Improv Project Neighborhood street project ' $ 884,080 $ 935,210 $ 385,260 $ 597,610 I $ _ 435,810 J $__ 86,820_ - _ J _ 1 $ 3,124,770 2008 Northway Drive Improv Project _ _ Street improvement project J J „ I I I I $ 2008 Xerxes Avenue Improv Project Street improvement project 1 $ 231,000 J 10,000 $ 10,000 10,000 J_ 330.000 I $ 591,0W Total 2008 $ 1 $ 915,060 $ 935,210 $ - I $ 395,260 $ 607,610 1 $ 445,8101 $ 86,820 $ 330.0001 1 $ 3.715,770 • CITY OF BROOKLYN CENTER CAPITAL PROJECT FUNDS Special Assessment Construc 2002 2003 Revenues Transfer from Water Utility $ 1,245,545 $ 607,300 Transfer From Sewer Utility $ 1,312,015 $ 631,790 Transfer from Storm Sewer $ 802,830 $ 410,785 Transfer from Street Light $ - $ 51,090 Misc Revenue $ 65,000 $ 65,000 Total Revenue $ 3,425,390 $ 1,765,965 Expenditures Personal Services $ - $ - Supplies $ - $ - Services $ - $ - Depreciation $ - $ - Debt Service $ _ $ - Total Expenditures $ - $ - Capital Outlay $ 3,360,390 $ 2,129,062 Total Cash Requirments $ 3,360,390 $ 2,129,062 Beginning Cash Balance $ 1,114,385 $ 1,179,385 Revenues $ 3,425,390 $ 1,765,965 Expenditures $ (3,360,390) $ (2,129,062) Depreciation Add -back $ - ' $ - Ending Cash Balance $ 1,179,385 $ 816,288 • • CITY OF BROOKLYN CENTER CAPITAL PROJECT FUNDS MSA Fund 2002 2003 Revenues State Shared Revenue $ - $ Misc Revenue $ 30,000 $ 30,000 Total Revenue $ 30,000 $ 30,000 Expenditures Personal Services $ - $ - Supplies $ _ $ _ Services $ _ $ _ Depreciation $ _ $ _ Debt Service $ _ $ _ Total Expenditures $ - $ Capital Outlay $ - $ Total Cash Requirments $ - $ - Beginning Cash Balance $ 512,714 $ 542,714 • Revenues $ 30,000 $ 30,000 Expenditures $ - $ - Depreciation Add -back $ - $ - Ending Cash Balance $ 542,714 $ 572,714 • S CITY OF BROOKLYN CENTER CAPITAL PROJECT FUNDS s .. m Capital Reserve Fund 2002 2003 Revenues Misc Revenue $ 65,000 $ 65,000 Total Revenue $ 65,000 $ 65,000 Expenditures Personal Services $ _ $ _ Supplies $ _ $ _ Services $ _ $ _ Depreciation $ _ $ _ Debt Service $ _ $ _ Total Expenditures $ _ $ _ Capital Outlay $ _ $ _ Total Cash Requirments $ - $ - . Beginning Cash Balance $ 1,341,292 $ 1,406,292 Revenues $ 65,000 $ 65,000 Expenditures $ _ $ _ Depreciation Add -back $ - $ - Ending Cash Balance $ 1,406,292 $ 1,471,292 CITY OF BROOKLYN CENTER CAPITAL PROJECT FUNDS Capital Improvement Fund 2002 2003 Revenues Transfer In General Fund $ 125,000 $ 125,000 Transfer In Liquor Fund $ 100,000 $ 100,000 Debt Payment Golf Course $ 70,000 $ 70,000 Misc Revenue $ 15,000 $ 25,000 Total Revenue $ 310,000 $ 320,000 Expenditures Personal Services $ - $ - Supplies $ _ $ _ Services $ _ $ - Depreciation $ _ $ - Debt Service $ _ $ - Total Expenditures $ - $ - Capital Outlay $ 1,207,800 $ 391,600 Total Cash Requirments $ 1,207,800 $ 391,600 Beginning Cash Balance $ 1,341,292 $ 443,492 Revenues $ 310,000 $ 320,000 Expenditures $ (1,207,800) $ (391,600) Depreciation Add -back $ - $ - Ending Cash Balance $ 443,492 $ 371,892 CAPITAL is IMPROVEMENT u N PROGRAM 0 2002 • 2006 A jL H _ 4 • The Capital Improvement Is Program (CIP) is a planning - document It is intended to u serve as a summary he - mY � - physical improvements' proposed to carry out the City �r strategic and comprehensive plans. Is j December, 2001 is ,.. a n n er�Of BROOKLYN '� VENTER 2002 -2006 CAPITAL IMPROVEMENTS PROGRAM TABLE OF CONTENTS Page Introduction............................................................ ..............................1 • Public Utilities WaterUtility ............................................................ .............................11 Sanitary Sewer Utility ..................................................... .............................13 Storm Drainage Utility .................................................... .............................16 Streets, Sidewalks, and Trails Streets............................................................. .............................18 Sidewalks and Trails ..................................................... ............................... 21 Parks, Public Facilities, and Capital Equipment Parks............................................................ .............................23 Centerbrook Golf Course ............................................... ............................... 26 Government Buildings ................................................... ............................... 27 Miscellaneous Equipment ............................................... ............................... 28 TABLES Table 1: Summary By Functional Area ................................ ............................... 5 Table 2: Summary By Fund ............................................. ............................... 7 Table 3: Summary By Function and Fund ............................ ............................... 9 Table 4: 2001 Projects .................................................... .............................10 Table 5: Water Utility Projected 5 Year Balance ..................... .............................12 Table 6: Water Utility Facilities Future Maintenance or Replacement Needs .................13 Table 7: Sanitary Sewer Utility Fund Projected 5 Year Balance ... .............................15 Table 8: Sanitary Sewer Utility Facilities Future Maintenance or Replacement Needs ......15 Table 9: Storm Drainage Utility 5 Year Projected Balance ......... .............................17 • Table 10: Neighborhood Street and Utility Improvement Program Progress .19 Table 11: Municipal State Aid Fund 5 Year Projected Balance ................................. 20 Table 12: General Fund Contributions to Street Projects 5 Year Projected Balance ......... 21 Table 13: Local State Aid Fund 5 Year Projected Balance ........ ............................... 22 Table 14: Parks Facilities Future Maintenance or Replacement Needs ........................ 25 Table 15: Golf Course Fund 5 Year Projected Balance ............ ............................... 27 Table 16: Capital Improvement Fund 5 Year Projected Balance . ............................... 29 FIGURES Figure 1: By Functional Area ........................................... ............................... 6 Figure 2: By Funding Source ........................................... ............................... 8 APPENDIX Table A: Water Utility ................................................. ............................... Al Map A: Water Facilities ..................................... ............................... A2 Table B: Sanitary Sewer Utility ...................................... ............................... A3 Map B: Sewer Facilities .................................... ............................... A4 Table C: Storm Drainage Utility ..................................... ............................... A5 Map C: Drainage Facilities .................................. ............................... A6 Table D: Sidewalk and Trail Improvements ........................ ............................... A7 Map D: Sidewalk & Trail Facilities ........................ ............................... A8 Table E: Park Improvements .......................................... ............................... A9 Map E: Park Facilities .......................................... ............................A10 Table F: Public Buildings Improvements ............................. ............................All . • Map F: Public Buildings .................................... ............................... Al2 Table G: Street Improvements ...................... t ................... ............................A13 Map G: Street Improvement Projects ..................... ............................... A20 2002 -2006 CAPITAL IMPROVEMENT PROGRAM . INTRODUCTION The Capital Improvement Program (CIP) is a planning document. It is intended to serve as a summary of the physical improvements proposed to carry out the City's strategic and comprehensive plans. The CIP presents a schedule of improvements and an evaluation of the community's financial capabilities, as well as its goals and priorities. In such a way, the community can be assured that it is adequately prepared to meet the demands on its financial resources in the coming years. No document or planning process, however, can anticipate all contingencies or opportunities. Certainly not all of the capital improvements to be undertaken during this time period are known at this time. Rather, the information contained in these tables represents a best estimate of improvements and their costs based on present knowledge and expected conditions. The CIP is a flexible planning tool that provides a means to determine which projects are of highest priority. The City can be responsive to opportunities because it has available a comprehensive listing of its needs which can be evaluated and reprioritized if necessary to take into account new or changing situations. For the purposes of this report, a capital improvement can be defined as any major non - recurring expenditure or any expenditure for physical facilities of government. Typical expenditures are the cost of land acquisition or interest in land; construction of buildings or other structures; construction of roads, utilities, or park improvements; and pursuit of community development . activities. Most capital improvements are typically funded from revenue sources other than the General Fund. Maintenance of these improvements is primarily funded by the General Fund. The CIP is directly linked to the goals and policies, land use and community facility sections of the Comprehensive Plan, since these sections indicate general policies of development, redevelopment, and the maintenance of the community. Consequently, the primary objective of the CIP is to integrate the specific goals, policies, and recommendations contained in the City's plan with its capability to pay for and maintain capital improvements. Meeting Strategic and Annual Goals The City's Comprehensive Plan presents the framework for programming, development and redevelopment within the community. - This Comprehensive Plan identifies several general community goals. ••• Carve out a unique and desirable niche in the Twin Cities by capitalizing on physical attributes such as: location, highway and bus access; sound and diversified housing stock; vibrant mixed -use center; attractive Brooklyn Boulevard Corridor; and interconnected park and open space system. Projects consistent with this goal are: ➢ Completion of park upgrades including playground equipment replacement, shelter renovations and replacement, and addition of amenities and linkages to regional parks. • ➢ City participation in a Hennepin County street improvement project providing a major upgrade to Brooklyn Boulevard, improving safety, increasing capacity, and coordinating with redevelopment and enhancement projects. 4' Gain an increased sense of unity and place by: retrofitting the public elements of the • neighborhoods; focusing and linking these neighborhoods toward an intensified, mixed use retail- office- residential -civic core; making major street corridors and other public spaces highly attractive; and celebrating diversity. Projects consistent with this goal ar - ➢ The continuation of a systematic program of neighborhood street and utility improvement projects designed to upgrade neighborhood infrastructure and improve the appearance of Brooklyn Center neighborhoods. ➢ Landscaping and enhancement projects on Brooklyn Boulevard, and CR 10, Brooklyn Boulevard, and Xerxes Avenue adjacent to Brookdale. ➢ A focus on the redevelopment of mature commercial sites by assisting in the construction of infrastructure improvements, such as regional storm water ponds. Develop a positive public image and strong community esteem. Projects consistent with this goal ar ➢ Construction of an addition to the Community Center and rehabilitation of the existing Community Center and City Hall facilities to provide attractive and functional places for recreational programming, city services, and community • gatherings. •�• Provide cooperative leadership and sound management. Projects consistent with this ago l are. ➢ Continued maintenance and repair of the City's infrastructure, such as: painting and repairing well houses and water towers; rehabilitating sanitary sewer lift stations, repairing storm sewer outfalls; repairing sidewalks and retaining walls; sealcoating streets and trails, and replacing and rehabbing facilities at city parks. These major projects focus on maintaining a high quality of life and neighborhood focus and on redeveloping the community. The program provides for the continuation of the high level of public services which Brooklyn Center has come to expect and to enjoy. Projects in this CIP are also consistent with the City Council's 2002 Goals. These include: Goal 1: Promote the Inclusion of all Residents in Brooklyn Center's Community Life Project-, consistent with the goal ar ➢ The continuation of a public process to review and comment upon proposed • improvement projects, through neighborhood informational meetings, public hearings, and publication in the City newsletter. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 2 • Goal 2: Support Brookdale Redevelopment Projects consistent with the ag�l are: Addition of streetscaping on CR 10, Brooklyn Boulevard and Xerxes Avenue to enhance the attractiveness of the commercial area. Goal 3: Continue and Improve Code Enforcement and Compliance Activities Project-, consistent with the goal are: ➢ Provide leadership by continuing a high standard of maintenance and enhancement. Goal 4: Increase Proactivity Towards Fighting Crime Project-, consistent with the oag 1 are: ➢ The continuation of a systematic program of neighborhood street and utility improvement projects as well as park improvements designed to upgrade neighborhood infrastructure and foster pride in place. Goal 5: Actively Support Northeast Corner of 69th Avenue and Brooklyn Boulevard Redevelopment Projects consistent with the oag 1 are. ➢ City participation in a Hennepin County street improvement project providing a major upgrade to Brooklyn Boulevard, improving safety, increasing capacity, and coordinating with redevelopment and enhancement projects. Goal 6: Complete Community Center and City Hall Retrofitting Project Projects consistent with the goal are: ➢ Construction of an addition to the Community Center and rehabilitation of the existing Community Center and City Hall facilities to provide attractive and functional places for recreational programming, city services, and community gatherings. Goal 7: Continue and Implement Long -Term Financial Planning J!rojects consistent with the goal are: The CIP itself is a very effective long -term planning tool. Goal 8: Support and Promote Major Road and Street Improvement Projects Projects consistent with the goal are: ➢ City participation in a Hennepin County street improvement project providing a major upgrade to Brooklyn Boulevard, improving safety, increasing capacity, and coordinating with redevelopment and enhancement projects. City participation in Segment 4 of the TH 100 Improvements, including the relocation of utilities as necessary, and the improvement of local streets and Twin Lake Park. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 3 Goal 9: Plan for Destination Parks i Projects consistent with the goal are: Completion of park upgrades including playground equipment replacement, shelter renovations and replacement, and addition of amenities and linkages to regional parks in accordance with the adopted Destination Park Plan. Goal 10: Support and Expand Joslyn Site Development Projects consistent with the goal are- ➢ Completion of neighborhood street and utility as well as park improvements in the vicinity of the Joslyn Site, to integrate the redevelopment into the neighborhood and reduce adverse impacts, and to reroute France Avenue to continue access. Goal 11: Continue Traffic Calming Efforts and Expand Information Available to the Public Projects consistent with the goal are_ The continuation of a systematic program of neighborhood street and utility improvement projects designed to upgrade neighborhood infrastructure and to provide an opportunity for neighborhood dialog regarding the most appropriate traffic calming measures. Goal 12: Utilize Recommendations Developed in the Opportunity Site Process to Create a Vision and Plan for Brooklyn Center's Central Business District Projects consistent with the goal are: Addition of streetscaping on CR 10, Brooklyn Boulevard and Xerxes Avenue to enhance the attractiveness of the commercial area. The continuation of a public process to review and comment upon proposed improvement projects, and development of specific priorities and projects. The Plan The detailed tables of proposed improvement projects are organized by functional area -- for example: water system improvements, park upgrades, street projects, etc. The CIP begins with a series of summary tables and graphs showing the overall level of expected need and funding requirements. A summary of the proposed capital improvements by functional area for the five - year period of 2002 through 2006 is shown in Table 1. A summary by funding source is shown in Table 2. Table 3 details the cost by funding source for the proposed improvements, grouped by functional area. Table 4 shows the projects proposed for consideration in 2002. All costs shown are best s i at _ of future costs based on 2001 estimated costs. It must be understood that the scheduling of various improvements, especially those that are related to development or redevelopment, can change substantially from year to year. However, the overall level of improvements shown in this CIP represents the best judgment of what is necessary to maintain infrastructure in good condition, and to provide those facilities that are necessary to support public services through the year 2006. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 4 0 TABLE 1 -Capita| Improvement Program -Sum0Oary by Functional Area 03-Dec-01 PUBLIC UT I MPROVEMENTS: Water Utility Capital Projects $85.000 $0 $150.000 $0 $0 8.000.00 � Sanitary Sewer Utility Capital Projects 813 80.000 280.000 80.000 O 500.000 Storm Drainage Utility Capital Projects 355.000 250.000 200.000 125.000 25.000 200.000 SUBTOTAL $440.813 $330.000 $630.000 $205.000 $25.000 $8.700.000 S0EVVALK/TRA|L|YNPROVEK8ENTG: Off-Street Trails ¢2.083 $125.000 $125.000 mU $O 50.000 Sidewalks 31.511 35.000 50.000 60.000 25.000 O SUBTOTAL $33.594 *iGO.DOO ' $175.000 *60.000 $26.000 $50.000 PARK|/NPROVEyNENTS $493.50 $508.000 $265.000 $29.593 $288.810 $330.000 PUBLIC BUIL DINGS $1.760.959 $2.717.800 $117.000 $820.200 $319.000 $108.000 STREET IMPROVEMENTS: Signals $28.242 $75.000 $U $250.000 $U D State Aid Street Projects 1,152,178 G3U88O O 3QO.U8U 51G.00O 814.8UU � . . . � Neighborhood Street Projects 3,441.734 7.489.895 2.484.062 3.485.845 3.482.920 3.066.890 � Commercial Street Projects U 780.880 U O 155.000 O Landscaping 0 O O 300.000 U 20.000 SUBTOTAL $4.622.154 *8.978.855 $2.484.062 $4.425.846 $3.153.920 *3.701.790 ������� ��T�U ��P ��1 11� �1� ��� ���� �� ���1 M�� �� ��� �1�� �� �1 � ���1 ���� ����� �y�M � ��^~"^"^� v��./^^_ ^p",*"=.,^/~' *"^"-,^^="-'=== `p= ^`=~'=- `p=,~^-`" +^='='".'== `p"°- � � � Page City of Brooklyn Center Capital Improvement Program, 2002 -2006 By Functional Area Trails & State Aid Sidewalks Streets Public Buildings 0 Parks 1% 6% 1070 4% Water 21% Neighborhood Street Improvements Sanitary Sewer 54% Storm 2% Drainage 2% Total 5 Year Proposed Expenditures = $38,405,675 Page 6 TABLE 2 - Capital Improvement Program - Summary by Fund a. : : : : : : : : : : : : : : : . : ���'. 1.:.:.:.:.:.:.:.:.:..:.:.:.:.:.:.:.: 2i��.................................. ��Q� 03- Dec -01 0 ............... ...,........................... , .............. ............................... . WATER UTILITY $1,053,978 $1,389,545 $607,300 $764,105 $465,815 $8,681,180 SANITARY SEWER UTILITY $561,220 $1,392,015 $711,790 $808,305 $440,940 $1,143,090 STORM DRAINAGE UTILITY $395,331 $1,154,790 $495,785 $601,845 $350,070 $690,920 MSA- REGULAR $921,335 $1,433,425 $0 $350,000 $486,000 $268,750 MSA - LOCAL ACCOUNT $251,086 $212,060 $175,000 $115,000 ($277,700) ($214,480) SPECIAL ASSESSMENTS $1,049,797 $1,689,755 $502,350 $1,221,530 $917,705 $965,800 CAPITAL IMPROVEMENTS FUND $2,096,552 $3,207,800 $342,000 $406,793 $577,810 $423,000 GENERAL FUND: STREET CONSTR $884,964 $1,401,585 $745,747 $969,490 $761,775 $843,260 GOLF COURSE FUND $33,000 $18,000 $40,000 $18,000 $30,000 $15,000 STREET LIGHT SERVICE DISTRICT $0 $57,700 $51,090 $85,370 $59,315 $73,270 TIF FUNDS ($358,800) $0 $0 $0 $0 $0 GENERAL OBLIGATION BONDS $0 $0 $0 $0 $0 $0 OTHER GOVERNMENTS /FUNDS $462,650 $735,980 $0 $0 $0 $0 GRAND TOTAL $7,351,113 $12,692,655 $3,671,062 $5,340,438 $3,811,730 $12,889,790 Page 7 i • • City of Brooklyn Center Capital Improvement Program, 2002 -2006 By Funding Source Storm Drainage Special Utility Assessments Sanitary Sewer 9% 14% Utility 12% i Other Funds r n• - 7 4 �, 2% - -z,,.t Capital Improvements Fund xr k a I e i Water Utility 30% General Fund MSA 12% Golf MSA Local Course Regular <1% Total 5 Year Proposed Expenditures = Fund 7% Other Funds Includes State 1 % Grants, ISTEA, etc. $38,405,675 Page 8 • TABLE 3 - Capital Improvement Program - mmary By Function and Fund PUBLIC UTILITY IMPROVEMENTS: Water Utility $85,000 $0 $150,000 $0 $0 8,000,000 Sanitary Sewer Utility 813 80,000 280,000 80,000 0 500,000 Storm Drainage Utility 205,000 250,000 200,000 125,000 25,000 200,000 NSP TIF /Other Govts/Capital Improvements Fund 150,000 0 0 0 0 0 SUBTOTAL $440,813 $330,000 $630,000 $205,000 $25,000 $8,700,000 SIDEWALK/TRAIL IMPROVEMENTS: TRAILS Local State Aid ($47,917) . $65,000 $125,000 $0 $0 50,000 Trail grant 50,000 60,000 SIDEWALKS Local State Aid 31,511 35,000 50,000 60,000 25,000 0 SUBTOTAL $33,594 $160,000 $175,000 $60,000 $25,000 $50,000 PARKIMPROVEMENTS Capital Projects Fund $335,593 $490,000 $225,000 $11,593 $258,810 315,000 Golf Course Fund /Other Funds 158,000 18,000 40,000 18,000 30,000 15,000 SUBTOTAL $493,593 $508,000 $265,000 $29,593 $288,810 $330,000 PUBLIC BUILDINGS Capital Improvements Fund $1,760,959 $2,717,800 $117,000 $395,200 $319,000 108,000 Water Utility 0 0 0 112,500 0 0 Sanitary Sewer Utility 0 0 0 112,500 0 0 Other Governments 0 0 0 0 0 0 GO Bonds 0 0 0 0 0 0 SUBTOTAL $1,760,959 $2,717,800 $117,000 $620,200 $319,000 $108,000 STREETIMPROVEMENTS MSA - Regular $921,335 $1,433,425 $0 $350,000 $486,000 $268,750 MSA - Local 267,492 112,060 0 55,000 (302,700) (264,480) Water Utility 843,978 1,389,545 457,300 651,605 465,815 681,180 Sanitary Sewer Utility 560,407 1,312,015 431,790 615,805 440,940 643,090 Storm Drainage Utility 190,331 904,790 295,785 476,845 325,070 490,920 Street Light Service District 0 57,700 51,090 85,370 59,315 73,270 Special Assessments 1,049,797 1,689,755 502,350 1,221,530 917,705 965,800 Special Assessment Constr Fund 884,964 1,401,585 745,747 969,490 761,775 843,260 TIF Revenue (508,800) 0 0 0 0 0 Other Governments 412,650 675,980 0 0 0 0 SUBTOTAL $4,622,154 $8,976,855 $2,484,062 $4,425,645 $3,153,920 $3,701,790 GRAND70TAL $7,351,113 $12,692,6551 $3,671,0621 $5,340,4381 $3,811,7301 $12,889,790 I TABLE 4 - Capital Improvement Program - 2002 Projects WOV JJ IN Adi OWN ........ Water None $0 Sanitary Sewer Replace lift station cabinets $80,000 $80,000 Storm Drainage Miscellaneous structure improvz ments $50,000 $50,000 Twin Lake improvements $100,000 $100,000 Shingle Creek improvements $100,000 $100,000 Sidewalks & Trails Palmer Lake trails $60,000 $50,000 $110,000 Twin Lake Park trail $15,000 $15.000 Miscellaneous repairs $35,000 $35,000 Parks Centerbrook Golf Course $18,000 JI;18,000 Central $50,000 $50,000 Grandview Park $330,000 $330,000 Northport $10,000 $10,000 'Twin Lake $100,000 $100,000 Public Buildings Civic Center remodelling $2,500,000 $2,500,000 Civic Center parking lots $150,000 $150,000 Central Garage exterior paintinE $50,000 $50,000 Assessments on City property $17,800 $17,800 Streets Azelia/50th $610,000 ($40,000) $50,000 $620,000 Southwest $402,920 $507,460 $868,425 ($40,000) $575,975 $543,840 $278,665 $165,275 $3,302.460 47th/48th $168,000 $197.060 $144.000 $135,960 $51,960 $84,000 $780,980 Garden City South $948,665 $57,700 $577,070 $490,000 $50,000 $669,570 $632,215 $524,265 $187,950 $4,137,435 Happy Hallow $50,000 $50,000 Brooklyn Boulevard $65,980 ($55,000) $10,980 63rd/Brooklyn Blvd signals $75,000 $75,000 GRAND TOTALI $1,401,585 1 $811,680 1$1,252,530 1 1$1,433,425 1 $212,060 1$1,389,545 1 1$1,154,790 1 $437,225 1 $12,692,655 Page 10 1. PUBLIC UTILITIES . a. Water Utility The City's water utility provides service to about 8,950 connections in Brooklyn Center. Through cooperative agreements with the adjacent cities of Brooklyn Park and Robbinsdale, the water utility also provides service to about 100 border customers in those cities where Brooklyn Center has mains but those cities do not. About 12 homes in Brooklyn Center receive their water from the City of Minneapolis. The water utility finances all costs for water supply, distribution, operations and maintenance, and capital improvements. Revenues are generated through water use charges, connection charges, and special assessments. Revenues are also generated through the leasing of space on water towers to private companies for antennas. Use charges are adjusted annually based on a rate study analysis that reviews operations, maintenance, and construction costs and projected water demand. Substantial cash expenditures have been made from the water utility in the past few years. These expenditures are primarily cyclical in nature, such as painting and repairs to the three water towers and replacement of the SCADA system. In 1999, this cycle of larger scale improvements was completed, and it will be several years before items such as tower repainting come up again. The only significant annual expenditures during the off cycle years are associated with neighborhood street projects. In most cases, these represent repairs to the system, rather than substantial replacements. However, in 2000 -2002, the utility is replacing most or all of the water main in the Garden City neighborhood, which historically has had water quality problems and maintenance issues. There are a few other neighborhoods that are known to have "hot" or corrosive soils where substantial replacements are likely to be required, such as the "Tangletown" area of the southeast neighborhood. As a result of these large capital expenditures, the balance in the fund has been reduced considerably. The target balance in this fund is $1 million. While current projections show the fund falling below that in the short term, in the long term the utility does bring the fund balance back up to an acceptable level. 5-Year Improvements Short -term activities relate primarily to routine maintenance, and improvements associated with the Neighborhood Street and Utility Improvement Program. 1. Continue the routine well inspection and maintenance program to assure the continued functioning of the existing wells. 2. Rehabilitate the exterior and make a small addition to well house #4 to enclose electric facilities that are currently on the exterior of the building. This well house is adjacent to the Evergreen Park School playground. 3. Replace existing mains as necessary and make various water distribution system improvements to assure the system's ability to deliver needed capacities to all portions of the City during peak 40 demand periods and for fire protection as a part of the Neighborhood Street and Utility Improvement Program. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page I I Table 5 WATER UTILITY FUND PROJECTED 5 YEAR BALANCE 03 Dec-0 [........ 2�A! �........ �........ �i�0.$.�2#SO•.3':�����....�...5 .... �........�4Et$:........ 1:I~F€Ut k1"F' a $0.98 $0.9 ,. $1.181$ ° 1.241 $1.32 Starting Balance $2,229,616 1 $1,706,675 1 $830,6671 $876,790 1 $844,9701 $1,160,553 Revenues Investment Interest 111,481 85,334 41,533 43,839 42,249 58,028 User Fees 1,225,000 1,225,000 1,375,000 1,475,000 1,550,000 1,650,000 Bond Proceeds 8,000,000 Other 175,000 180,000 185,000 190,000 195,000 200,000 Exoenditures Capital Outlays 1,053,978 1,389,545 607,300 764,105 465,815 8,681,180 SCADA Replacement 0 0 0 0 0 0 Wellhouse rehabilitation 60,000 0 0 0 0 0 Tower painting/repair 0 0 0 0 0 0 Street Improvements 843,978 1,389,545 457,300 651,605 465,815 681,180 TH 100 150,000 Buildings 150,000 0 0 112,500 0 8,000,000 Transfers 0 0 0 0 0 0 Debt Service 56,300 56,300 0 0 0 0 Operating Costs 924,144 920,496 948,111 976,554 1,005,851 1,036,026 Ending Balance $1,706,675 1 $830,6671 $876,7901 $844,970 1 $1,160,553 1 $1,351,374 Note: An $8 million expenditure shown in 2006 is the estimated cost of a future water treatment plant. No decision has yet been made regarding this facility. Should this project be approved, the City would issue revenue bonds in the amount of the actual cost to construct the facility. Long-term Improvements Long -term improvements require detailed evaluation of capacity following the extensive distribution system improvements constructed in the past several years, and future water quality regulations. 1. In 1998, the periodic Water System Analysis study last conducted in 1989 ( "The Black and Veatch study ") was updated. The study concludes that Brooklyn Center's water supply system is adequate, and that no new wells or elevated storage need to be constructed. The emergency water interconnect with Brooklyn Park which was constructed in 1997 is capable of supplying all the City's average day demand should that need arise. An emergency generator capable of starting up a well was purchased in 1998, and electric control modifications were made to several of the wells at the time the adjustable speed drives were installed to accommodate the generator. Water modeling confirms that under most emergency scenarios, as long as the integrity of the distribution system is not breached, water adequate for serving average water needs and providing fireflow would be available. . 2. The study also updated the estimated cost of an iron and manganese removal water treatment plant, should the City desire to construct such a facility. At this time there is no regulatory reason to do so, and alternative methods such as chemical treatment have kept complaints about City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 12 these naturally- occurring minerals to a minimum. Iron and manganese are not aesthetically pleasing in the water, but no health hazards have been identified as a result of their presence. It is estimated that a plant to soften water, remove iron and manganese, and add 1 MGAL ground storage, would cost about $8 million. A suitable site in the City's well field is available, and is reserved for such a future use, and the water distribution system has been designed to accommodate a future plant with few adjustments. Research being conducted at the University of Minnesota suggests and water testing confirms that the levels of iron and manganese being pumped from the Jordan Aquifer are increasing and will continue to increase. It is likely that at some point in the near future, Brooklyn Center will have to consider an iron and manganese removal plant. 3. The following is a listing of major water utility facilities and future major maintenance or replacement needs: Table 6 WATER UTILITY FACILITIES FUTURE MAINTENANCE OR REPLACEMENT NEEDS FACILITY YEAR BUILT ( 5 YEAR LONG TERM I Well #2 (B Blvd) 1959 2007: routine maintenance* Routine maintenance as necessary I Well #3 (at Tower #2) 1961 2007: routine maintenance Routine maintenance as necessary Well #4 (Evergreen W) 1961- 2005: routine maintenance Routine maintenance as necessary 2001: exterior rehab I Well #5 (70th/Camden) 1966 2002: routine maintenance Routine maintenance as necessary Well #6 (69th/Emerson) 1965 2006: routine maintenance Routine maintenance as necessary Well #7 (Evergreen E) 1970 2004: routine maintenance Routine maintenance as necessary Well #8 (Camden/Wdbine) 1977 2006: routine maintenance Routine maintenance as necessary Well #9 (Camden M 1984 2005: routine maintenance Routine maintenance as necessary Well #10 (Camden S) 1990 2003: routine maintenance Routine maintenance as necessary Tower #1 (France) 1958 Inspect coatings in 2006; rehab in 15 -20 years Tower #2 (Dupont) 1960 Inspect coatings in 2006; rehab in 15 -20 years Tower #3 (Centerbrook) 1973 Inspect coatings in 2006; rehab in 15 -20 years SCADA 1998 Periodically upgrade, replace when technologically obsolete * 'Routine maintenance "means the well is shut down and the pumps and shaft are removed and inspected and repaired as necessary. b. Sanitary Sewer Utility The City's sanitary sewer utility provides service to 8,780 customers in Brooklyn Center. Through cooperative agreements with Brooklyn Park and Robbinsdale the utility provides service to about 100 border customers in those cities where Brooklyn Center has mains but they do not. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 13 The sanitary sewer utility finances all costs for operations and maintenance and capital improvements • through sewer use charges, connection charges and special assessments. Charges are adjusted annually based on a rate study analysis that reviews operation, maintenance, and construction costs, as well as sewage treatment charges from the Metropolitan Council Environmental Services (formerly Metropolitan Waste Control Commission), which provides wastewater treatment for the entire Twin City metro area. MCES charges account for about 3/4 the annual operating expenditure of the utility. Substantial cash expenditures have been made from the sanitary sewer utility in the past several years. These expenditures are primarily cyclical or one time in nature. Since 1990 the utility has replaced the two primary lift stations, number 1 in Central Park and number 2 on Lyndale Avenue, and relined or replaced where possible a substantial amount of corrugated metal pipe which was used for some major interceptors in the late 1950s. In 2000, with the reconstruction of two smaller lift stations this cycle of larger scale improvements was completed, and it will be several years before major replacements come up again. Generally, the only significant annual expenditures during the "off cycle" years are associated with neighborhood street projects, for the replacement of mains as necessary. For the past several years, in many project areas the mains have been almost entirely replaced, and that trend is expected to continue. Upcoming major projects are: the possibility of a Corps of Engineers -led project to stabilize the bank of the Mississippi River adjacent to the Mississippi River interceptor between 66th and 67th Avenues; relining two forcemains, one between lift station number 9 and Brookdale and the other at lift station number 2; and the replacement of electric controls at six smaller lift stations. As a result of these large capital expenditures, the balance in the fund has been reduced considerably. The target minimum balance in this fund is $950,000. While current projections show the fund falling below that minimum in the short term, in the long term the utility does bring the fund balance back up to an acceptable level. • 5 Year Improvements Short term activities relate primarily to routine maintenance, and improvements associated with the Neighborhood Street and Utility Improvement Program. 1. Continue routine sewer televising and lift station inspection and maintenance program. 2. Replace any segments of sewer that have been identified as needing replacement by the television inspection program, and as necessary with the Neighborhood Street and Utility Improvement Program. It has been determined that almost one -half of the sanitary sewer pipe in the city is of the ungasketed, clay tile variety. This type of material is highly susceptible to root and groundwater infiltration. On average about half and sometimes all the sewer pipe in the Neighborhood projects has had to be replaced because of extensive root infiltration. Many individual services have also been replaced for the same reason. The projects identified in this 5 year plan are all in areas with known instances of root infiltration, so it is expected that replacements will be substantial. 3. Over three years replace the cabinets and electric controls at the six oldest lift stations. 4. Replace or reline the forcemain from lift #9 (on the west side of Shingle Creek Parkway, across from the Brookdale Square shopping center) south along Shingle Creek Parkway, under CR 10, and across the Brookdale parking lot to the Brookdale trunk main. Construct a similar project on the forcemain at lift station number 2. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 14 • Table 7 SANITARY SEWER UTILITY FUND PROJECTED 5 YEAR BALANCE 3 - a �........�CQ ........... I ....:.:�Q.�, .:.:. :.:....... �1�: 0.. 3 . ........ �tl Q. ��. ............ SkisIITARYEV1(FLITiLfia $50.00 $52.50 I $! I $53.75 I $53.75 $55.00 Staring Balance $857,3401 $1,035,835 1 $545,6491 $693,1591 $797,010 1 $1,254,554 : Revenues Investment Interest 42,867 51,792 27,282 34,658 39,850 62,728 User Fees 2,510,901 2,646,966 2,658,096 2,733,481 2,745,306 2,821,050 Other 1,000 1,000 1,000 1,000 1,000 1,000 Expenditures Capital Outlays 561,220 1,392,015 711,790 808,305 440,940 1,143,090 Replace lifts #10 & 11 73 0 0 0 0 0 River line 740 0 100,000 0 0 0 Street Improvements 560,407 1,312,015 431,790 615,805 440,940 643,090 Interceptors & forcemains 500,000 Other 0 80,000 180,000 192,500 0 0 Operating costs 390,053 397,928 413,078 428,844 445,251 462,327 MCWS Charge 1,425,000 1,400,000 1,414,000 1,428,140 1,442,421 1,456,846 Ending Balance $1,035,835 1 $545,6491 $693,1591 $797,010 1 $1,254,554 1 $1,077,069 • T.n�nu_T_ Tmr r)V&M ents Long term improvements relate specifically to replacement of major facilities. The following is a list of those facilities and their maintenance or replacement needs. Table 8 SANITARY SEWER FACILITIES FUTURE MAINTENANCE OR REPLACEMENT NEEDS FACILITY YR BUILT S YEAR LONGTERM. Lift Station #1 (Garden City) 1997 Monitor, maintain & rehab as necessary Lift Station #2 (Lyndale) 1993 2006: replace forcemain Monitor, maintain & rehab as necessary Lift Station #3 (Palmer Lake) 1982 Maintain & rehab as necessary. Review condition in 2012 Lift Station #4 (Queen & 55th) 1990 Monitor, maintain & rehab as necessary Lift Station #5 (Indiana & 56th) 1990 Monitor, maintain & rehab as necessary Lift Station #6 (France & LakeB) 1988 Monitor, maintain & rehab as necessary Lift Station #7 (Willow Lane) 1990 Monitor, maintain & rehab as necessary I Lift Station #8 (58th & Shores) 2000 Monitor, maintain & rehab as necessary Lift Station #9 (SCP) 2000 2006: replace forcemain Monitor, maintain & rehab as necessary • Lift Station #10 (Freeway) 1985 Maintain & rehab as necessary. Review condition in 2015 SCADA 1998 Upgrade as necessary, replace when obsolete City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 15 C. Storm Drainage Utility • The City's storm drainage system consists of about 82 miles of storm sewer piping and a series of storm water detention ponds. The Local Water Management Plan has established a goal of constructing new and/or replacing old storm sewers plus adding additional storm water ponds to provide adequate drainage for a five year storm. The Plan also requires private developments to provide on -site drainage system and storage necessary to treat storm water and retain all drainage on- site for up to six hours after a five year storm. Substantial capital improvements have been undertaken in the years since the storm drainage utility fund was established in 1990. Through revenue bonds the fund fmanced the acquisition of property and the construction of Bob Cahlander Park, which includes a 4 acre regional storm water detention and water quality pond. These revenue bonds will be retired in 2005. The Shingle Creek Regional Pond was funded by a $2 million grant from the state DTED, TIF, and the City of Minneapolis. The neighborhood projects that have been undertaken in the past several years have had very substantial storm drainage components. As a result, the fund has a very low reserve balance, but is expected to achieve its minimum balance of $540,000 by the end of the five year period. The Shingle Creek and West Mississippi Watershed Management Commission will be updating their management plans in 2001 and 2002. Upon adoption of the Second Generation plans, Brooklyn Center will have to review its Local Water management plan for consistence. The plans will also identify high - priority capital projects that may require a capital contribution from Brooklyn Center. The storm drainage utility finances all costs for storm drainage system operations and maintenance and capital improvements. Capital improvement bonds and special assessments supplement the SDU. • Charges are adjusted annually based on a rate study analysis that reviews all costs relating to the storm drainage system. 5 Year Improvements Z Short term activities include both major water quality improvements and improvements associated with the Neighborhood Street and Utility Improvement Program. 1. Complete storm drainage improvements as necessary with the Neighborhood Street and Utility Improvement Program. Major trunk improvements have been made by several previous projects. Detention and treatment ponding would be constructed where necessary and sites are available. 2. Participate in the Second Generation Plan process conducted by the Shingle Creek and West Mississippi Watershed Management Organizations in 2001 and 2002. It is expected that these management plans will identify various priority projects that may require a capital contribution from Brooklyn Center. 3. Complete several minor structural improvements such as the routine rehabilitation of the Mississippi River outfalls. . 4. Consider improvements to the Twin Lake basin that may be recommended by the Shingle Creek Watershed Management Commission as well as maintenance improvements to the creek. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 16 Table 9 STORM DRAINAGE UTILITY 5 YEAR PROJECTED BALANCE 03-Dec-01 :;....:.. rt"i141f14?I1Mi4�aU1`d4 $10.75 I $11.50 ( $11.50 $11.50 $11.50 I $10.75 Starting Balance $131,4171 $461,7271 $129,7671 $438,0121 $654,664 $1,133,751 ..................... Revenues Misc operating 2,500 2,500 2,500 2,500 2,500 2,500 User Fees 1,118,000 1,196,000 1,196,000 1,196,000 1,196,000 1,118,000 Interest 6,571 23,086 6,488 21,901 32,733 56,688 Exnenditures Capital Outlays 395,331 1,154,790 495,785 601,845 350,070 690,920 Structure improvements 50,000 50,000 50,000 25,000 25,000 0 Civic Center drainage impr 35,000 0 0 0 0 0 Street Improvements 190,331 904,790 295,785 476,845 325,070 490,920 TH 100 50,000 Palmer Lake/TvAn Lakes/Shh 120,000 200,000 100,000 100,000 0 200,000 Transfers Debt Service 240,850 240,850 240,540 239,250 237,210 0 Operating costs 160,579 157,907 160,418 162,654 164,866 167,258 Ending balance $461,7271 $129,7671 $438,0121 $654,664 1 $1,133,751 1 $1,452,760 . T .nn g_term Trn:p rnyem entc The Local Water Management Plan has identified numerous deficiencies and opportunities for improvement. Of particular concern are strategies to improve water quality in Upper and Middle Twin Lakes, to maintain the flow in Shingle Creek, and to complete what is expected to be a series of improvements in the Palmer Lake basin. Potential regional ponding opportunities have also been identified, as well as a series of structural improvements 2. STREETS, SIDEWALKS, AND TRAILS Improvements to streets, sidewalks, and trails are funded from a variety of sources. The largest of these are the Special Assessment Construction Fund, special assessments, the various public utilities, Municipal State Aid, and the Local State Aid Fund. The sources of funds for the Special Assessment Construction Fund are: the General Fund; special assessment revenue bonds; special assessments; and excess funds transferred from bond repayment funds being closed out. The Municipal State Aid Fund is supported by gas tax revenues that are apportioned to the state, counties, and cities to provide for the construction, maintenance, and reconstruction of a network of roadways known as the State Aid System. About 21 miles of City streets are designated MSA streets, and the City receives about $930,000 annually for these improvements. Finally, the Local State Aid Fund consists primarily of excess funds available when special assessments on a state aid project and MSA reimbursement exceed the cost of the project. The LSA Fund is used primarily to finance sidewalk and trail improvements, aesthetic enhancements, and the City's portion of commercial street projects. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 17 a. Streets . The City is responsible for maintaining over 105 miles of streets; about 84 miles are classified as neighborhood streets, and just over 21 miles as Municipal State Aid streets. Capital improvements generally include mill and overlay improvements and total reconstruction. The Pavement Management Program conducted by Braun Intertec in 1992 has been used to help identify the City's street reconstruction needs. From the results of this analysis and an ongoing review of utility needs, a plan to reconstruct or rehabilitate as necessary the City's streets has been developed. This plan has been designated the Neighborhood Street and Utility Improvement Program. When this program began in 1994, it was anticipated that reconstructing or rehabilitating the City's streets could take about 20 years, at a rate of 4 -6 miles of streets per year. On further analysis, it is likely that financial considerations will not allow that pace to be sustained continuously. The amount transferred from the General Fund, whether from the amount budgeted annually for transfer or year- end transfers of excess balance, has not increased to at least keep up with inflation. Accordingly, it is expected that between 3 and 5 miles can be reconstructed annually until 2002. At that point, the size of projects will have to decrease to about 2 to 3 miles per year. In 2005, 2006, and 2007, debt on previous street improvement bonds will be retired. If property tax levy limits are not reenacted, then it is likely that the property tax levy dedicated to servicing that debt can be redirected to the pay as you go projects. This additional levy is relatively small, and would not be sufficient to substantially increase the pace of construction. Realistically, after this second five year program is complete, it will likely take another 20 years to complete the remainder of the City. The policies guiding the designation of streets to be improved are as follows: • 1. Improvements proceed on a neighborhood basis, rather than piecemeal and strictly on "need." This approach has the benefits of a) minimizing construction cost by confining improvements to one area rather than multiple sites throughout the city; b) approaching drainage needs on an area wide basis; and c) allowing for more efficient construction administration and inspection. 2. Brooklyn Center has historically had two methods of identifying "neighborhoods ": planning neighborhoods, and park service districts. These are fairly large areas, which often do not make a suitable base for assessing infrastructure needs. To retain its primary emphasis as one of infrastructure rehabilitation, for the purposes of the Neighborhood Program, storm drainage areas are the basis of identifying neighborhoods. However, in many cases "natural" neighborhoods do not conform precisely to drainage areas, so the boundaries of an improvement area might be amended slightly to define a broader area. It may also for various reasons be prudent to construct improvements to only a portion of a neighborhood at one time. 3. Priorities are established as follows: a) Areas with multiple needs; b) Improvements that could immediately reduce operating costs; C) Areas petitioned for by a majority of the property owners; d) Areas which would complete regional improvements; and e) Improvements that could benefit from being coincident with redevelopment. The following table details progress in past years and projected for the coming 5 years on meeting neighborhood infrastructure improvement needs. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 18 Table 10 . NEIGHBORHOOD STREET AND UTILITY IMPROVEMENT PROGRAM PROGRESS 1 1 Major Projects 1 Local I MSA 1 Total 1 1 1985 -1993 1 1.38 1 4.76 1 6.16 16% 1 1994 Northwest; James/Knox, 53rd to 55th 1.67 0.25 1.92 1 1995 Woodbine; Freeway Blvd; Humboldt, 69th to 73rd 2.73 1.97 4.70 1996 Orchard East; 69th; Logan/James/Knox/57th; Xerxes/53rd 5.59 2.08 7.67 1997 Orchard West; France, 69th to 73rd 4.81 0.50 5.31 1 1998 Bellvue; Lee/68th; James/67th; John Martin Dr 3.22 0.77 3.99 1999 Southeast; Earle Brown Dr east; 66th/Camden 4.27 0.44 4.71 2000 Garden City Central; 73rd, Humboldt to Camden 3.25 0.94 4.19 2001 Garden City North; Halifax/Grimes/France 3.52 - 3.52 1994 -2001 29.05 6.95 35.99 35% 1 2002 Garden City South; Southwest; France/53' /Osseo; 47` 48th 4.81 1.98 6.79 1 2003 Happy Hollow; 73 Humboldt to Penn 1.87 .25 2.12 1 2004 Tangletown S; Shingle Creek Pkwy 2.45 1.15 3.60 2005 Tangletown N; Summit, Earle Brown west leg; Xerxes, 55` 56', 2.63 1.93 4.60 Northway 2006 Riverwood 2.36 - 2.36 1 2002 -2006 1 14.12 1 5.36 i 19.48 1 19% 1 2006 -2010 1 _ 1 12.37 1 2.84 1 15.21 1 15% 2011- 1 .___ • 1 24.55 1 2.85 1 27.40 126% 1 TOTAL i 1 81.47 1 22.76 1 104.22 1 5 Year Tmi rovements 1. Work cooperatively with Hennepin County to accomplish the widening and enhancement of Brooklyn Boulevard from 65th to 71st Avenues. 2. Complete between 2000 -2002 Neighborhood improvements in the Garden City area, that is the residential area between Brooklyn Boulevard and Shingle Creek, from CR 10 to I -694. 3. Complete in 2002 Neighborhood improvements in the Southwest neighborhood: south of Northport Park, and in the Middle Twin Lake neighborhood, north and west of TH 100 and France Avenue, and France Avenue, 53rd, and Old Osseo Road. 4. Complete between 2003 -2006 Neighborhood projects in Tangletown, which includes the area from 53rd to Lilac Drive, west of Logan to Lions Park; in the Happy Hollow neighborhood; on 73 west of Humboldt; and in the Riverwood Neighborhood. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 19 5. Work cooperatively with Mn/DOT to make improvements in the Segment 4 area of TH 100 • that is being upgraded in 2003 and 2004. This includes the construction of a project relocating France Avenue from TH 100 to 5e Avenue to a new alignment on the extended Azelia and 5e Avenues. 6. Complete commercial street improvements on 47th and 48th Avenues south of TH 100; and in the Central Business District, on Shingle Creek Parkway, Summit and Earle Brown, Xerxes, 55` and 56` and Northway. 7. Consider several landscaping and "streetscaping" projects to enhance the appearance of the City and promote neighborhood unity and sense of place. 8. Monitor traffic and install new traffic signals at 55th and 56th Avenues at Xerxes if necessary to control traffic generated by the remodeled Brookdale Shopping Center. Cooperate with Hennepin County to replace the signal at 63` and Brooklyn Boulevard. Table 11 MUNICIPAL STATE AID FUND 5 YEAR PROJECTED BALANCE 03- Dec1 €��RR1 � :::::::::::::::x:::::::::...:24 .�•........... . Starting Balance $373,763 $151,324 1 ($31,129 )-1 r_ $383,090 1 $456,4201 $408,760 Revenues . Intergovernmental 932,986 932,986 946,980 961,180 975,600 990,230 MSA Bond proceeds 1,000,000 Advance 300,000 (300,000) Exoendltures Capital Outlays 1,069,680 1,433,425 0 350,000 486,000 268,750 Other 547,532 75,000 73rd, Humboldt to TH 252 51,473 0 0 0 0 0 Brooklyn Boulevard 375,822 0 0 0 0 Francel53rdlOsseo 0 Shingle Creek Pkwy 350,000 Summit 156,000 Neighborhood Streets 94,853 1,358,425 0 0 330,000 268,750 Transfers 90, 000 90 ,000 90,000 90,000 90,000 90,000 Debt Service 295, 745 292,014 442,761 447,850 447,250 150,000 Balance Dec 31 $151,3241 ($31,129)1 $383„090 $456,420 I $408,7601 $890,2401 Note: By the end of this five year period, a balance will be built up to construct the next series of large MSA street projects in the 2007 -2011 period, including Dupont Avenue and 6P Avenue. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 20 Table 12 ANALYSIS OF GENERAL FUND CONTRIBUTIONS TO STREET PROJECTS 03-Dec-01 Dec- o . ... . Starting Balance $1,203,777 1 $1,019,067 1 $378,5321 $358,6051 $113,835 1 $132,856 Revenues Investment interest 66,210 56,050 20,820 19,720 6,260 7,310 Levy contrib, SA bond debt retired 69,536 143,172 Transfer from GF surplus 225,000 225,000 225,000 225,000 225,000 225,000 General fund contribution 409,044 480,000 .480,000 480,000 480,000 480,000 Expenditures 884,964 1,401,585 745,747 969,490 761,775 843,260 Capital Outlays 884,964 1,401,585 745,747 969,490 761,775 843,260 Bellvue (99,516) 0 0 0 0 0 Logan /James/Knox/57th Azelia SE Neighborhood 0 0 0 0 0 0 Earle Brown Dr (28,151) Garden City Central 32,822 0 0 0 0 0 73rd 0 107,955 Garden City North 899,809 0 Garden City South 40,000 948,665 0 0 0 0 Southwest 40,000 402,920 Tangletown S 55,000 909,490 Happy Hollow 0 50,000 582,792 0 0 0 Tangletown N 0 0 60,000 701,775 0 Riverwood 60,000 843,260 Reforestation Ending Balance $1,019,067 1 $378,5321 $358,6051 $113,8351 $132,8561 $145,078 Long -term Improvements 1. Continue the rehabilitation and reconstruction of'residential streets under the Neighborhood Street and Utility Improvement program. 2. Continue improvements under the Municipal State Aid and commercial street programs. These improvements may be coordinated with Neighborhood projects, or may be stand- alone. b. Sidewalks and Trails A comprehensive sidewalk system that serves all major activity areas and corridors of pedestrian traffic has been established. Only a few segments of this system remain to be completed. In addition, the City has developed a plan for development of a comprehensive trail system to provide recreational trails for pedestrians and transportation trails for bicyclists. Both on -street and off -street trails are being developed, and integrated into the regional trail system which serves the Twin City metropolitan area. Where feasible, trail construction is being coordinated with other construction projects to assure City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 21 lowest cost development of this system. Funding for sidewalk and trail improvements is provided by • an account within the Municipal State Aid Construction fund. Activities included in the CIP are: 5 Year Improvements 1. Continued maintenance and repair of existing sidewalks and trails. The City owns and maintains about 35 miles of sidewalks, and about 12 miles of bicycle /pedestrian trails. 2. Rehabilitation o Palmer f the P Lake and Shingle Creek Trails, including raising settled portions. 3. Completion of the trail link between Twin Lake Park and TH 100, and a trail link between the Shingle Creek Trail and the west side of Brookdale. Table 13 LOCAL STATE AID FUND 5 YEAR PROJECTED BALANCE 0 5- Deo-01 ...........:.:.:I:.:.:.: �1# I� I. Zt10�. �. �QO: �i�D�# 5 . : Starting Balance $488,2061 $311,530 1 $170,0501 $3,5501 $481,7991 $783,589 Revenues u Investment interest 24,410 15,580 8,500 180 24,090 39,180 Grants /Other 50,000 60,000 593,069 • Exnendftures Capital Outlays 251,086 217,060 175,000 115,000 (277,700) (214,480) Sidewalks 31,511 35,000 50,000 60,000 25,000 0 Trails (47,917) 125,000 125,000 0 0 50,000 Street Improvements (414,883) 112,060 0 55,000 (302,700) (264,480) Brooklyn Boulevard 682,375 (55,000) 0 Ending Balance $311,530 $170..050 1 $3,5501 $481,7991 $783,589 1 $1,037,249 Long-term Improvement-, a. Completion of the 53rd Avenue trail link between the Shingle Creek/North Hennepin Trail Loop trail and Bryant Avenue. b. Consideration of the Twin Lake Trail system and Shingle Creek trail head improvements. 3. PARKS, PUBLIC FACILITIES, AND CAPITAL EQUIPMENT Improvements to parks and other public facilities such as the Civic Center, central garage, and fire stations, are made primarily through the Capital Improvements Fund. Certain types of large -scale equipment such as telephone and radio systems are also purchased through the Capital Improvements Fund. The Capital Improvements Fund is funded from a variety of sources, with the largest being the General Fund and proceeds from General Obligation bond sales. In 1997, the Capital Improvements Fund was split into two funds: the $1 million Capital Reserve Emergency Fund, and the Capital City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 22 Improvements Fund. The Capital Improvements Fund is intended for park, building, and other . miscellaneous improvements, while the Capital Reserve Emergency Fund is a restricted fund intended to provide emergency financing for nonreimbursable emergency expenses or emergency cash flow. There is no established minimum balance for the Capital Improvements Fund. Since all the improvements under the following three sections are financed primarily through the Capital Improvements Fund, the table projecting its balance in 5 years follows the final section. a. Parks The Brooklyn Center park system is being systematically renovated based upon input from a series of informational meetings with the community hosted by the Park and Recreation Commission in 1998 and 1999, and a Destination Park Plan developed in 2000. This plan anticipates the continued use of P P P the operating budget to make improvements such as minor equipment (picnic tables, benches, trash receptacles, etc.) replacement; trail repair and sealcoating; minor shelter building and electrical repairs; landscaping enhancements; minor tennis court rehab; etc. Major improvements such as playground replacement; shelter replacement; replacement of field and trail lights; parking lot improvements; etc. would be financed through the Capital Improvements Fund. This lan uses the following principles to establish priorities for improvements: P gP P P P 1. If possible, improve neighborhood parks coincident with neighborhood street and utility improvements. 2. Provide geographic balance in improving parks, so that over a short period of time all • neighborhoods have access to at least one fully improved park. 3. Continue to make improvements to Neighborhood Parks and routine improvements to Destination Parks by regular expenditures from the Capital Improvements Fund. Complete larger -scale improvements at Destination Park when sufficient funding is available from sources such as excess General Fund surplus to supplement annual budgeted spending. 4. If possible, when improving a park complete all improvements comprehensively. For example, complete all playground, shelter, and other large improvements as well as smaller improvements such as replacing picnic tables, trash receptacles, bleachers, and drinking fountains, etc., repairing basketball courts, adding landscaping, sealcoating trails, and replacing signs. 5. Improvements should be made systematically and annually from the Capital Improvements Fund and General Fund, rather than periodically by bond issue . This plan uses the following principles to establish the types of improvements: 1. Five parks have been designated Destination Parks. These parks will have larger playgrounds; larger, heated shelter buildings; lighted rinks and ballfields; lighted ball fields; and other specialized facilities such as tennis courts, or football or soccer fields. These parks are: Central, Grandview, Evergreen, West Palmer, and Kylawn. • 2. Neighborhood parks will generally include playgrounds, basketball courts, ball diamonds, and picnic shelters and picnic areas. Some parks with traditionally strong City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 23 hockey and general skating programs will include lighted rinks and smaller warming • houses. Parks that would continue to have warming houses would be: Orchard Lane and Northport. As specialized facilities in neighborhood parks are to be considered for major capital improvements, the neighborhood, the Park and Recreation Commission, and the Council would review the appropriateness of the facility for the neighborhood and the park before making that investment. 5 Year imnrovements z 1. Continue the systematic improvement of park facilities, with major improvements in the next 5 years to Evergreen, Grandview, Central, East Palmer, Twin Lake, and Kylawn. 2. Revise recreation programming as improvements are made. Long Term improvements 1. Continue the systematic improvement of park facilities: 2. Periodically obtain community input regarding new facilities or recreational needs, and adjust the long -term plan accordingly. • City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 24 Table 14 • PARK FACILITIES FUTURE MAINTENANCE OR REPLACEMENT NEEDS PARK .5 YEAR I LONG TERM . -� I Bellvue Monitor, minor improvements through General Fund Monitor, replace as necessary Cahlander Monitor, minor improvements through General Fund Monitor native plantings Centerbrook GC See section below Monitor, replace as necessary Central -East 2001: add new entrance, trail signage Upgrade playground, add permanent 2002: convert 2 tennis courts to basketball courts bandshell, replace scoreboards 2005: replace ballfield lighting Central -West 2001: relocate rinks Replace shelter 2002: replace trail lights Evergreen 2001: Light and irrigate ball fields Monitor, replace as necessary Firehouse Monitor, minor improvements through General Fund Monitor, replace as necessary Freeway Monitor, minor improvements through General Fund Replace shelter Garden City 2006: replace shelter Monitor, replace as necessary Grandview 2002 -2003: replace shelter, repair tennis courts, move & pave hockey Monitor, replace as necessary rink, build lighted soccer field, replace baseball lights and add outfield fence, expand playground . I Hagel Arboretum Pond & landscaping improvements as necessary Monitor Happy Hollow Monitor, minor improvements through General Fund Monitor, replace as necessary Kylawn 2006: replace shelter, lights, pave hockey rink, repair tennis courts Monitor, replace as necessary Lakeside No improvements Lions Monitor, minor improvements through General Fund Monitor, replace as necessary Marlin Monitor, minor improvements through- General Fund Monitor, replace as necessary North Mississippi Hennepin Parks improvements Northport 2002: replace one softball field with soccer field Replace shelter, lights Orchard Lane Monitor, minor improvements through General Fund Replace shelter, lights Palmer Lake East 2001: replace shelter, lights, relocate and raise trail Monitor, replace as necessary Palmer Lake West 2006: replace shelter, lights, add storage bldg Monitor, replace as necessary Palmer Lake 2001: trail signage Monitor, replace as necessary Riverdale 2006: replace shelter with picnic shelter, lights Monitor, replace as necessary Twin Lake 2002: rehab turf, remove ballfield, replace playground, lights, add Monitor, replace as necessary small parking lot, replace shelter with picnic shelter • I Wangstad Monitor, minor improvements through General Fund Monitor, replace as necessary Willow Lane 2002: reduce basketball courts to one half -court Replace shelter, lights City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 25 b. Centerbrook Golf Course • Centerbrook Golf Course is a nine hole, par three course operated as an enterprise fund. It was built in 1986 -87 with a $1,100,000 loan and $600,000 grant from the Capital Improvements Fund. It opened for business in Spring, 1988. In 1997, a revised financial plan for the golf course restructured the fund's debt and created a capital reserve. Annually, $20,000 is to be contributed toward the reserve to provide for replacement or reconstruction of course facilities. Maintenance equipment is replaced through the Central Garage Internal Service Fund, and is not funded from the capital reserve. In Winter, 1997 -98, the golf course ponds were expanded considerably and other improvements made as a part of the Shingle Creek Regional Pond project. These ponds now serve as part of a series of storm water detention ponds that treat storm water runoff from the Brookdale commercial area and neighborhoods to the north and west, as well as TH 100 and Brooklyn Boulevard. The Storm Drainage Utility budgets for maintenance of these ponds, so they are not a responsibility of the golf course. In 2001 a new storage building for maintenance equipment was constructed. When the golf course was constructed, it was agreed that maintenance equipment would be temporarily housed in the base of water tower #3 until a maintenance building could be built. In early 2001 the tower base started to be used by cellular telephone companies for their antennas, reducing the amount of space available for storage. The new storage building was financed primarily by the lease fees paid to the water utility fund by those companies with antenna facilities, with a contribution from the golf course capital reserve. 5 Year Improvements 1. Complete the maintenance storage building. 2. Replace furnishings and appliances in the clubhouse as necessary. 3. Replace irrigation system controllers and some foot bridges and overlay the parking lot. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 26 Table 15 • GOLF COURSE FUND 5 YEAR PROJECTED BALANCE 03-D ec , 01 1........�. �� .....:., I•....... �: o; t.:.:.:.:. L....:.. ���.:.:.... �...:... �a��a€..... ..�.....- ..�a�s.........L...... ���....:.• :.................. ............................... Target starting operating balance $57,450 1 $58,950 $61,450 $63,320 $65,470 $67,580 Operating Cash Starting Balance $51,4261 $98,843 $123,9451 $151,4751 $182,8321 $214,668 Revenues Fees & rentals 326,359 335,031 345,082 355,434 366,097 377,080 Concessions & merchandise 50,250 53,000 54,590 56,228 57,915 59,652 Interest 6,406 5,000 10,016 10,467 12,469 13,779 Ooeratina Expenditures Operating costs 244,348 257,789 265,523 273,488 281,693 290,144 Cost of sales 36,100 36,300 37,389 38,511 39,666 40,856 Net operating income $102,567 $98,942 $106,776 $110,130 115,122 119,512 Add back depreciation 14,850 16,160 15,754 16,227 16,714 17,215 Loan repayment (50,000) (70,000) (75,000) (75,000) (80,000) (80,000) Contribution from other fund Contribution to capital (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) Operating Cash Ending Balance $98,8431 $123,9451 $151,4751 $182,832 1 $214,6681 $251,395 Capital Reserve Cash Starting Balance 53,982 40,982 42,982 22,982 24,982 14,982 Contribution to capital 20,000 20,000 20,000 20,000 20,000 20,000 Capital Expenditures Capital Outlays $33,000 $18,000 $40,000 $18,000 $30,000 $15,000 Clubhouse impr 5,000 0 0 30,000 0 Ground impr 33,000 13,000 40,000 18,000 0 15,000 Capital Reserve Cash Ending Balance $40,982 $42,982 $22,982 $24,982 $14,982 $19,982 Total Golf Course Ending Balance $139,8251 $166,927 $174 „457 $207,8141 $229,6501 $271,377 Long -term Improvements 1. Continue systematic upgrade of facilities as necessary. C. Government Buildings The City owns and operates several major facilities: City Hall and the Community Center (together, the Civic Center); the Central Garage; and two fire stations. In addition, the City leases space for a municipal liquor store. The City also owns and operates the Earle Brown Heritage Center, a • convention center and Inn complex developed from several buildings formerly housing the historic Earle Brown estate and horse farm. City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 27 The Central Garage was remodeled and expanded in 1994 -95 and underground storage tanks removed . and replaced with a new fuel system. In 1998 -99 a new public safety facility was constructed at Humboldt and 67th Avenues, and the west fire station/liquor store was demolished. A new west fire station was constructed. The east fire station was extensively remodeled. A referendum authorizing the sale of $7.9 million of General Obligation bonds to finance the public safety and fire station work was approved in November, 1997. Improvements to the City Hall and Community Center are being constructed in 2001 -02. These improvements will correct accessibility, mechanical, and space utilization deficiencies. The improvements consist of: a small addition to the Community Center as well as extensive remodeling to make better use of space; remodeling of City Hall to convert the old police station into usable City offices and community space; and reconstruction of the parking lots. Most improvements to the Earle Brown Heritage Center are considered elsewhere and are not comprehended in this study. However, in 1998 -99 several improvements were constructed through the Capital Improvements Fund and were reimbursed from the proceeds of a special $2,500,000 grant in state funds. These improvements included purchase of land for and construction of an overflow parking lot; construction of the G barn; and construction of walkways connecting the major convention buildings and some additional storage space. Proposed major improvements to facilities to be considered over the next several years include: 5 Year Tml rovements 1. Construct an addition to the Community Center to rovide for improved public access and P P P • customer service and to meet ADA accessibility requirements. 2. Remodel the Community Center and City Hall with the emphasis on improved accessibility, better use of space, adherence to code requirements, and routine improvements such as roof replacements and HVAC upgrade. 3. Reconstruct the north and south parking lots at the Civic Center. 4. Paint the exterior of the Central Garage and construct an additional cold storage building to accommodate additional storage needs. Long-term Tmz rovements 1. Monitor community facility needs. Between 2008 -2010, begin community discussions regarding city hall and community center long -term needs. 2. Reroof the Central Garage. d. Miscellaneous Equipment • The City operates a Central Garage Internal Service Fund, which owns all vehicles and major equipment. The cost of owning (depreciation, license, insurance, overhead) and operating (fuel, preventative maintenance and repair) vehicles and equipment is charged back to the departments using City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 28 the equipment. Replacement of existing equipment is financed from the Fund. The addition of equipment is funded from a variety of sources: the General Fund, enterprise funds, etc. The City's policy for the replacement of vehicles and equipment establishes a projected reasonable life cycle for each item. Life cycles are reviewed annually and updated on the basis of experience or changed circumstances. New vehicles and equipment are proposed for addition to existing inventories and replacement schedules when new needs are clearly demonstrated. Vehicle and equipment purchases are generally considered during the annual budget, and are no longer incorporated into the CIP. Routine equipment purchases, such as data processing equipment, are considered through the general fund process and the MIS Strategic Plan, and are no longer incorporated into the CIP. However, major equipment systems due to be considered for replacement that are beyond the scope of routine are included here. For example, in 1998, the telephone systems which service the Civic Center, Central Garage, Heritage Center, Fire Stations, and Liquor stores were replaced. 5 Year T rrinrovements 1. Consider the replacement of the City's public safety and public works radio systems. 2. Begin replacement of emergency sirens Tang -term Improvements 1. Monitor data processing, telecommunications, and other equipment needs Table 16 CAPITAL IMPROVEMENTS FUND 5 YEAR PROJECTED BALANCE 03-Dec-01 '•`• Starting Balance (Net Current Assets) $4,018,051 $3,131,269 1 u u $525,029 1 $629,2791 $673,9461 $554,836 Revenues Investment Interest 241,080 156,560 26,250 31,460 33,700 27,740 Golf course loan payments 50,000 70,000 75,000 75,000 80,000 80,000 Transfer from year -end surplus 115,000 120,000 120,000 120,000 120,000 120,000 One time transfer for CC 574,700 30,000 Budgeted transf from GF /Liq fund 225,000 225,000 225,000 225,000 225,000 225,000 Expenditures Capital Outlays 2,092,562 3,207,800 342,000 406,793 577,810 423,000 Police /Fire stations 17,813 0 0 0 0 0 Civic Center impr 1,650,000 2,650,000 0 0 0 0 Park improvements 335,593 490,000 225,000 11,593 258,810 315,000 Central Garage impr 75,000 50,000 0 225,000 0 0 Emerg sirens & radio sys 0 0 50,000 50,000 300,000 0 City's street assessments 14,156 17,800 67,000 120,200 19,000 108,000 Ending Balance $3,131,269 $525,029 $629279 $673,946 $554,836 1 $584,576 City of Brooklyn Center Capital Improvement Program 2002 -2006 Page 29 APPENDIX • • TABLE A - Capital Improvement &gram - Detail of Capital Outlays • Water Utility CapKI Improvements 03-Dec-01 2.00. 00 EXPENDITURES: All water utility WATER SUPPLY SYSTEM Wellhouse #5 & 6 exterior rehab 77,359 Wellhouse # 4 addn 520 60,000 Loop Palmer Lake Circle Relocate TH 100 crossing 150,000 WATER TOWERS Repair Paint on Tower #1 6,077 Replace Paint on Tower #3 (519) Landscape Tower #1 MISCELLANEOUS Install adjustable speed drives Replace 16" gate valve at Centerbrook 25,000 Water treatment plant 8,000,000 TOTAL EXPENDITURES $83,437 $85,000 $0 $150,000 $0 $0 $8,000,000 FUND SOURCES: Water Utility 83,437 85,000 0 150,000 0 0 8,000,000 TOTAL $83,437 $85,000 $0 $150,000 $0 $0 $8,000,000 Al mCmas .)� � • .,I1� =�7 i.+a 1 ,� Irl r! :�7�• � �I ,. muum .P .CI�� 1. " :��r mall, t! ZY, - 51-E in r ul I SKI ME r Fx =z 4=k I! I 111II rIlI,q 11 R `� � � •, ��■� ' 1� �`. - 77, Its IN r . "i .... ts =ME ....... a A MO lH ....... ........... ua 1111.' ,� ♦m - •.ar.nO o � � ) ,.,� � .�, fir.. 4 I .... .... 7441 M= .......... _. 14 _101 41 1w- Z ERE . ...... T.- ..... - TFmnvr' za' ME ZZ,.= IN ENE Ei I. if Amp r'! .. _ 1� A P: 9; 9; 4r � '2 i�u'nnr \ 1' �� � ,•5 � �1' • ;i�A e ��= � - 1 •_i�'r ■ T � 1/ �` �t9 A �7 ALA a . �_ ,...Ilnl r:. _ r 11 •11 Eiz :z 1- I LIM ME H! MME[ JORAW .w do Alk 411F • • • • TABLE B - Capital Improvement Program - Detail of Capital Outlays Sanitary Sewer Utility Capital Improvements 03-Dec-01 M. EXPENDITURES: All San Sewer Utility LIFT STATIONS Replace Lifts 8 & 9 415,804 73 Replace Lift Station Cabinets 80,000 80,000 80,000 SEWER REPLACEMENT: Stabilize Miss River Interceptor 616 740 100,000 Lift #9 Forcernaln 200,000 Lift #2 Forcemain & Interceptor 300,000 MISCELLANEOUS TH 100 Relocations 100,000 TOTAL EXPENDITURES $416,420 $813 $80,000 $280,000 $80,000 $0 $500,000 FUND SOURCES: Sanitary Sewer Utility 416,420 813 80,000 280,000 80,000 0 500,000 TOTAL $416,420 $813 $80,000 $280,000 $80,000 $0 $500,000 A3 0H.H.-Z N.P. rj. z E5 L sillily NOT, W. Z mx MOU yg � 15! - x - sl 1K 1�a 7 -7 ..... ... . ::7 ...... di CIS_ V4, � _.`� .In t - -E ^ F puum :.: 2 u r nlnn � � 7' • rte 1 `: r r ` �� � .� r •�`�� .0 I It �. u. l . r u. i;:�m �ill:in _ � � r �• U�, f $ } ........... hi —A, v j. 4 PAZ*., WA a Am zr ' A., ' z ZEE "TRA is ....... 6 Aim f Ad ,.'E ■� '- _ ? ,el_ _I _ �k� ���� �,� TABLE C - Capital Improvement &gram - Detail of Capital Outlays • Storm Drainage UtilitITapital Improvements 03-Dec-01 Storm drainage utility EXPENDITURES: except where noted SYSTEM IMPROVEMENTS Misc structure improvements 4,672 50,000 50,000 50,000 25,000 25,000 TH 100 relocations 50,000 WATER TREATMENT IMPROVEMENTS Shingle Creek Regional Pond 78,974 TIF, DTED grant, SDU, Mpts Storm Drainage Utility: to Mpis 78,974 Storm Drainage Utility Twin Lake improvements 100,000 100,000 Shingle Creek improvements 100,000 100,000 Palmer Lake Improvements 50,212 270,000 200,000 TIF, SDU MISCELLANEOUS Civic Center Drainage Improvementr 35,000 TOTAL EXPENDITURES $133,858 $355,000 $250,000 $200,000 $125,000 $25,000 $200,000 FUND SOURCES: Storm Drainage Utility 133,858 205,000 250,000 200,000 125,000 25,000 200,000 Capital Improvements Fund TIF 150,000 Other Governments TOTAL $133,858 $355,000 $250,000 $200,000 $125,000 $25,000 $200,000 A5 • • - - • � u dP '1r•i■ � SIR �I ". � • aa� ` IR - ':Jt ' fir• ' �J _ �� � i s r .,c ► MU, `-4 U •Pllp �.� r,ti� ..� �I 1 -k Mt ZZ uu.n. Y I� u= _Ieeie_ .luutulel■ . �' J {III �.Y unn s i .�� {I� � a ai_ uu� r � � � {llt� 1 I i '■■ � I W r „4w saw 1�1•r'= t uuuu•.�I � fl v gmp +rn 1I♦ r r 1 L: 1. %tt\� n,� 6:• x:1::11 I:: --..'���'� �: - � ,.." �' I � _ a �� ►� 1 : f� `� l�IUn ■ '.- / \ i; uu_' °:� /Ilm mmn.n. s.J - •1.1•r... llll ■aa•••r•iJ ♦ � 7 i — rl �.. - w �`�, 7F '! 11•,r,,ll .a•a• 1.. r� 7 11._ —��� = _ . 1 a.rla 11,••r1!•��• � -;�j�_ a�rrr••j i:. \I \rrrla■i -- 4 "u unr - I�Illr rq !�•a.a , .uuan -• —i.~ Ir Ir_ _ \•i T ma- •IIIIlt1 Y ■ : �l /u fl nunud I ■ I ���I��d �� %� T 7z -Z Er �� -ice _ Irt a / ■ E - si A 4 �ruu iLz dr AM ., ���J� •J.' s 1. _� n ■ � �{■ � - I r • , - 1, a : i,■ _ ; �.A � Ip 111111 .;;. , ' 4 .�. ,� '1i i I' �X[.i -YT r 111 1 \; � �/ • e1 �� la j_ • t ZZ, 1: a .,n. �. 1��ti uu ■LJI - -� -_ -ae_�= I > >L:'e - ---_ :o-1 _ Iinl ulu'. � \i V s 1111111111111 ■ �- .� ([([ ■ fit r, vftiml -����� Ir \.`rtrrrllu f ►. 11 i � i TABLE D - Capital Improvement Program - Detail of Capital Outlays Sidewalk and Trail improvements 03-Dec- 01 EXPENDITURES: Local State Aid except where noted OFF-STREET TRAIL: Miscellaneous park trails 53rd Ave Greenway Trails 12,241 50% DNR match Palmer Lake Trails 2,620. 2,083 110,000 Twin Lake Park trail to TH 100 15,000 Raise SC Trail, 694 to SCP 50,000 Raise Trail by Library 75,000 Brookdale Trail 50,000 SIDEWALK: Miscellaneous repairs 26,308 16.511 35,000 10,000 25,000 Remove Humboldt Ave tree grates 15,000 New S/W Xerxes, 56th to CR 10 50,000 New S/W Evergreen Park east side 50,000 TOTAL EXPENDITURES $41,169 $33,594 $160,000 $175,000 $60,000 $25,000 $50,000 FUND SOURCES: State Aid - Local 41,169 (16,406) 100,000 175,000 60,000 25,000 50,000 DNR/Other 50,000 60,000 TOTAL $41,169 $33,594 $160,000 $175,000 $60,000 $25,000 $50,000 A7 �� ■ _I �ii�rnrrr'u,u 1� - • -. w +r . . u - �:: I I �( -Zi - I. _.Ca Mill IM _ :1% _ -- Yllallltl•l• T . iii. M ,� �� ,�Illlt71 llllp•IOIV L ". ■ G� j �uv - � ii a_ ]. ,1,•. , =" 1111111: r wn OIID � .... • .� II / 1 dam a 11 _I� .T' Il.�N1111 t �� Ill lr r i� �` l r �. - - =i {l�f iiiu. r •rlS w ... n7 ___ //� �' - u ■' ��� I OR '. zi ftj .nnT ulluu . ,i a ar.` ��•'��, _ f j � Sk i lr r �. I � =_ ! I I ua. i ti oii _ 1 uul• ; '� -�j"� i � I A � �.r ) A E, F B • Il ��' �,.. AIF th Ir I • � _,C. � ��� � G I (�_ ! VIII I :111 lr t � �,� . • s r . :::777 / �, �p • J R u� l' I r' � ~�-1 n � G ri b ICI IIIIII L ^ t I • I �� II' 4 II +. 111 � y �E. � 1 ♦ � -_ � � \ V -1 1 ��A) @i �j-y1 nf�,ll�l►. �� f _■ �.� %� . I � ru • _ oIX'' � � L- ■ _ (3, - I 7`1-,.1 I..7x�i.11fl�lI1.11. �1♦Y.Z \. F` � ���IttUr1� � t /� �• 1 I c`ti -st � �1 . • . `G 4 t�rY � _ � ■111/ � I :. -, FM ! d tt „ • =1 tol - • All Z's TABLE �� - �~�����Y �0OC) [�o��^y r�F �~����R�| Out '' ----- -- -- Improvement - - - ^ ~ =wwr Park | F O�-D��-�1 ������;�� ����o EXPENDITURES: ' Arboretum 0 Belivua 5,612 All Cap |mprFund Cahhander except aonoted Central 14.115 36.688 50.000 238.810 Centedbnook Golf Course C|ubhouom|mpr 4.000 5.000 30.000 Golf Course Fund Storage building 197 150.000 � Gnoundu|mpr ' O 4.000 13.000 40.000 18.000 15.000 Golf Course Fund Evergreen 252.581 11.593 20.000 Firehouse 34.853 Freeway 1.507 Garden City 1.582 90,000 Grandview 330.000 225.000 Happy Hollow 23.505 . 1�UO 1QO ��awn . ' 000 Lkmo 1,850 Marlin 1DUOO Northport . Orchard Lane EPa|mar 38.542 Palmer Lake Park VVPalmer 31.076- Riverdale 35.000 Twin Lake 100.000 VVangstmd 4.842 Willow Lane 1.089 � Swing Installs 6.237 Other 84,648 5,000 TOTAL EXPENDITURES $209.531 $493.593 $508.000 $265.000 $29.693 $288.810 $330.000 FUN[) SOURCES: Capital |mprFund $209.334 $335593 *490.000 $225.000 $11.693 $258.810 $315.000 Golf Course 33.000 18.000 40.000 18.000 30.000 15.000 Water Utility Fund 197 125.000 � TOTAL $2UQ531 �4�35Q3 �50O.UOO �2G5.000 �2Q.593 �288.O10 �33O.U0O � . . � Ay i X 04 � 1 u� . u• 1 �,, 'Illllllat I a al a u(y � � iSP aJ t g =' M - �'��/ ` l i uuuun� I �C '.'`� •F 1 -- _ -��.� t� - 1 '�. � _ 1 ��I•Y. � r4 t( 1r\ � � T.. ®. (o(••na( - '�. �I.•S. .� _ _ 'v1 •ud� _� /'..� Ir, r� - -�� r � r J r Lc r c _ • � 7 �,, t T �I _ S • tl'nit _ �Yi: - 7 :1!•irlllC� �l - 1u r i 1. Iv, A � ?I_ .D�.la.rs ® �1�- .I � = ':numua � ��, �•. I_ 1 ^t_ i 5.1 .rr. __ _ _ Ilunu...: _ /� • ►�?n =1 1 =_,. � I11{ � X111 a t r s.''' rum 6 _ inns" 4.r °�■ I ! I � I di a ll �,, _ t ■ i a 11. li �lltt IIIIIIIIT �^ � 1 r � \�\ � �I r ,�. �� � ♦ ,- Vtil' i�urrq�, r'11 Ini(nni 1 • � ` I �i � 3'1 Y'� �Ilua¢ � f 1p 11 to w `uu•� Ilhr i °ii" �� /� _ � � � I f � ��� u nunnllrrr - / � lar I li. �.• t1 1.1 t 11 � �. S w== ,� l -_ _p��llnn�nni •. •la•llln�i � ._ '�'�_ - --- r- _y nitlt S � vp r tml! I_ ~ su n�di . �.° , '� � •'r - ■J_ �� i \lV JYti11il r - L li'r(1' iii• • Xr'� i�� ...... 1 I i■ 117 S, r_ rt n 111 • ;�� _ nv ., .._ ` iz V ® '�l - - 7 � it �a 1 9 uu a p Im t� A _ tz zi �c ( f' �� 111 Ittltllillnl 11 �I: a 1� 2� s S Inmuutll� 1 i �� �,j 1i yy }�f [ a /'S��Imu °' - - -� - - > >�_ � �: _ �IO:..�Si.c�Ni•nn6'�4It Mann■ \,�i �5�. UQUM i '` � � ..1171■ _ ( /i��': r ' �_ a �■ •1■a ',� F� , . � � PI�� L J �� l ■ TABLE F - Capital Improvement *gram - Detail of Capital Outlays Public Building Improvements FA -- J,N, 0 .011J. Rio 0 -- 03-Dec-01 fi : 00 3. Capital Impr Fund EXPENDITURES: except where noted CIVIC CENTER Construct new police station 485,427 (14,901) GO Bonds/CIF Rehabilitate City Hall/Comm Center 52,144 1,500,000 2,500,000 Radio/emergency sirens 50,000 50,000 300,000 Rehab parking lots 150,000 150,000 CENTRAL GARAGE Garage addition , 2,104 Cap Impr Fund, Utilities Paint exterior+ windows 75,000 50,000 Additional cold storage 450,000 Reroof FIRE STATIONS Remodel East Station 100,122 3,990 GO Bonds/CIF New West Station 386,730 32,714 GO Bonds/CIF GO Bonds/CIF EBHC 23,606 State grant funds Assessments on City Property 14,156 17,800 67,000 120,200 19,000 108,000 TOTAL EXPENDITURES $1,050,133 $1,760,959 $2,717,800 $117,000 $620,200 $319,000 $108,000 FUND SOURCES: Capital Improvements Fund 1,050,133 1,760,959 2,717,800 117,000 395,200 319,000 108,000 Water Utility 112,500 0 Sanitary Sewer Utility 112,500 0 Other governments 0 0 0 TOTAL $1,050,133 $1,760,959 $2,717,800 $117,000 $620,200 $319,000 $108,000 All all *1 44 `, �.':. L 'TH K EM, i Mul �'J Y, � nl C uNt'� =� • I,, -= '.q 7 .,� �I _R 5W , gs R= E IWA ilia w = ������ _.i. :iiahr►4 re 'ma .: �l t■ r /: :S fa �� i u lrrrrrn ug l , � +�����`����t� �, ���� 1 3_ l ■� E MlF ■ VF Is ........... l f RAP - 27M ........ A M. Sk ' NAINURNW!, t IAI , Earle Brovin .1,414:1., E" _11� City Hall/ Heritage Center IF 1111V Communi iEl 19 � I i iI� 1. f I ��� ���� 1 �7� I � i j �� i ( �._I ■ I r � Ni. B fil 1_ F F iL ilk 5 s 1� �s = I �.'�� •■ .• ,:/ m u/ v r i � =ni n r r u ■ I I ru li ; wt �„>��:'� �� s�YV I.I llf� �• i� �1 %, ii E ;� I�-1- r J iY �:I I � f ! T� I ` s4 s ����' EE _ �'Y a-° ------ 0 1 II . 4 �w I n _� j? ��\ ��{ H1 as Mal TABLE �� - ���X��a� y00�������00�� ���xf�'| r�f�~��]��| ��wf|��fs '' -__-- -- __,_. ' , Detail Capital Outlays ° Street | 0O8Ot8 03-C]8c-01 ����������������������� �'������������������� ���|������������������������������������������������k������������ EXPENDITURES: SIGNALS Replace lamps withLCDo 28,242 LocaStataAid Pole painting &restoration Local State Aid Xanes/56th&66th 250.800 Special Assessments � G3nd/8nook|yn Blvd (city share) 75.080 K8SA-Regular STATE AID STREETS France Avenue. GQthbuNCih/Limits V N1GA-Regular 181.987 K88A-Regular Local State Aid K8S/�Loum| (122.977) ocm Water Utility Water Utility Sanitary Sewer Utility Sanitary Sewer Utility Storm Drainage Utility (38.010) ' Storm Drainage Utility Special Assessments Special Assessments Earle Brown Drive 28.151 U K8SA-Regular 21.107 K8SA-Regular N1SA-Local 3.947 Local State A]d Water Utility Water Utility Sanitary Sewer Utility 501 Sanitary Sewer Utility � Storm Drainage Utility 2.588 Storm Drainage Utility Gp Assess ConstrFund 28.151 (28.151) Special Assessments Bnooklvn Boulevard. G4thtoNCdxLir 1.449.578 1.056.542 10.980 ROVV:EDA (508.800) ECA ROW: Local State Aid 1.178.737 800.000 Local State Aid Romdway:YNSA 227.477 K8SA-Regular Romdwmy:LSA 246.974 (265.970) (75.800) Local State Aid Profoami000:L8A 21.588 Water Utility 186.240 Water Utility Storm Drainage Utility 56.600 Storm Drainage Utility Enhancements: |STEA 412.650 65.980 |STEA Enhoncamants:LS4 1.279 148.345 20.000 Local State Aid Lighting, Landscaping NSP A1s • TABLE G - Capital lmprovemen�&ogram - Detail of Capital Outlays Street IrMpFovements Owe. . 05-Dec-01 ...... ............... 73rd. Humboldt to TH 252 est 1/16 397,909 (4,364) Sp Assess Constr Fund (5,064) MSA-Regular 186,301 51,473 MSA-Regular MSA-Local 8,354 (55,837) Local State Kid Water Utility 100,256 Water Utility Sanitary Sewer Utility 46,259 Sanitary Sewer Utility Storm Drainage Utility (7,557) Storm Drainage Utility Street Assessments 52,320 Street Assessments Storm Drainage Assessments 17,040 Storm Dr Assessments France/53rd/Osseo MSA-Regular MSA-Regular MSA-Local Local State Aid Water Utility Water Utility Sanitary Sewer Utility Sanitary Sewer Utility Storm Drainage Utility Storm Drainage Utility Street Assessments Storm Drainage Assessments Special Assessments .Azelia/50th (France Relocationi 22,983 100,000 620,000 MSA-Regular MSA-Regular MSA-Local 22,983 100,000 (40,000) Local State AM Water Utility Water Utility Sanitary Sewer Utility Sanitary Sewer Utility Storm Drainage Utility 50,000 Storm Drainage Utility Mn/DOT 610,000 Special Assessments Shinale Cr Pkwv. CR 10 to 1-694 390,000 MSA-Regular 350,000 MSA-Regular MSA-Local (245,000) Local State Aid Water Utility 10,000 Water Utility Sanitary Sewer Utility 10,000 Sanitary Sewer Utility Storm Drainage Utility 20,000 Storm Drainage Utility Special Assessments 245,000 Special Assessments Summit. SCP to TH 100 156,000 MSA-Regular 156,000 MSA-Regular MSA-Local (109,200) Local State Aid Water Utility Water Utility Sanitary Sewer Utility Sanitary Sewer Utility Storm Drainage Utility Storm Drainage Utility Special Assessments 109,200 Special Assessments A14 TABLE G - Capital ImprovemenSogram - Detail of Capital Outlays • Street InTfovements 05-Dec-01 Xerxes. 55th, 56th 360,000 MSA-Regular 330,000 MSA-Regular MSA-Local (231,000) Local State Aid Water Utility 10,000 Water Utility Sanitary Sewer Utility 10,000 Sanitary Sewer Utility Storm Drainage Utility 10,000 Storm Drainage Utility Special Assessments 231,000 Special Assessments Dupont. 1-694 to 69th 614,900 MSA-Regular 268,750 MSA-Regular MSA-Local (284,480) Local State Aid Water Utility 113,950 Water Utility •Sanitary Sewer Utility 107,500 Sanitary Sewer Utility Storm Drainage Utility 26,860 Storm Drainage Utility Street Light SD Street Light SD Street Assessments 301,680 Street Assessments Storm Drainage Assessments 80,640 Storm Dr Assessments -COMMERCIAL STREETS , 47th/48th/Dusharme 780,980 MSA-Local 197,060 Local State Aid Water Utility 144,000 Water Utility Sanitary Sewer Utility 135,960 Sanitary Sewer Utility Storm Drainage Utility 51,960 Storm Drainage Utility Street Light SD 0 Street Light SD Street Assessments 168,000 Street Assessments Storm Drainage Assments 84,000 Storm Dr Assessments i Northway Drive 155,000 MSA-Local 37,500 Local State Kid Water Utility 10,000 Water Utility Sanitary Sewer Utility 10,000 Sanitary Sewer Utility Storm Drainage Utility 10,000 Storm Drainage Utility Street Assessments 87,500 Special Assessments :NEIGHBORHOOD STREETS James/Knox/57th Sp Assess Constr Fund 4,897 Sp Assess Constr Fun( MSA-Regular 364,438 MSA-Regular MSA -Local (349,368) MSA -Local Water Utility Water Utility Sanitary Sewer Utility Sanitary Sewer Utility Storm Drainage Utility (15,070) Storm Drainage Utility TABLE �� - �^�����y UO0X�[�]���yT�� Detail r�f�������l ��n��Ny� ' ----- - --r-- , �� ` ° Street | M0ents 03-Dec-01 BahueNoiahborhood | Gp Assess Conu Fund (90,516) Sp Assess Cono Fund MSA-Re 22.345 M@A-Regular K8SA-Loco| (22.345) NYSA-Loco| Water Utility Water Utility Sanitary Sewer Utility Sanitary Sewer Utility Storm Drainage UU8y Storm Drainage Utility Street Assessments Street Assessments Storm Drainage Assessments Storm DrAssessments SENoiohborhoud Sp Assess ConstrFund 107.605 Sp Assess ConotrFund � K8GA'Ragu|or 18.009 K08A-Regular � YN8A-Lnoe| 14.974 (18.009) K8GA-Looa| Water Utility 09.665 Water Utility Sanitary Sewer Utility 88.507 Sanitary Sewer Ud|ity Storm Drainage UUKy 48.940 ' Storm Drainage Utility Street Assessments Street Assessments � Storm Drainage Assessments Storm OrAssessments Garden Cib/ Central (7/1Geobm) ' Gp Assess ConodrFund 778.700 32.822 Sp Assess ConotrFund YWSA-Regular 312.512 56.499 YNSA-Regular � � K8SA-L000| 159.547 (60.536) KX8A'L000| Water Utility 729.327 18.793 Water Utility Sanitary Sewer Utility 718.301 1.118 Sanitary Sewer Utility Storm Drainage Ud|b/ 587.128 4.274 Storm Drainage Utility Street Assessments 881.710 9treatAooeoomonto Storm Drainage Assessments 293.258 Storm OrAssessments Garden Cih/ North U28ombm\ Sp Assess ConstrFund 44.081 899.809 Sp Assess ConetrFund NY84-Loum| 40.008 yNSA-Lona| Water Utility ' 2.370 640.945 Water Utility Sanitary Sewer Utility 5.007 558.788 Sanitary Sewer Utility Storm Drainage UU|ty 180.941 Storm Drainage Utility Street Assessments 781.003 Street Assessments Storm Drainage Assessments 288.784 Storm OrAssessments TABLE G - Capital Improvemen&ogram - Detail of Capital Outlays Street Movements A* mi-i 03-Dec-01 Garden City South Sp Assess Constr Fund 40,000 948,665 Sp Assess Constr Fund MSA-Regular 490,000 MSA-Regular MSA -Local 50,000 MSA -Local Water Utility 669,570 Water Utility Sanitary Sewer Utility 632,215 Sanitary Sewer Utility Storm Drainage Utilty, 524,265 Storm Drainage Utility Street Light SD 57,700 Street Light SD Street Assessments 577,070 Street Assessments Storm Drainage Assessments 187,950 Storm Dr Assessments Southwest Neiahborhood - Sp Assess Constr Fund 40,000 402,920 Sp Assess Constr Fund MSA-Regular 868,425 MSA-Regular MSA -Local 40,000 (40,000) MSA -Local Water Utility 575,975 Water Utility Sanitary Sewer Utility 543,840 Sanitary Sewer Utility Storm Drainage Utilty 278,565 Storm Drainage Utility Street Light SD 0 Street Light SD Street Assessments 507,460 Street Assessments Storm Drainage Assessments 165,275 Storm Dr Assessments HaDDv Hollow Sp Assess Constr Fund 50,000 582,792 Sp Assess Constr Fund MSA-Regular MSA-Regular MSA -Local MSA -Local Water Utility 395,500 Water Utility Sanitary Sewer Utility 373,440 Sanitary Sewer Utility Storm Drainage Utilty 253,255 Storm Drainage Utility Street Light SD 51;090 Street Light SD Street Assessments 317,775 Street Assessments Storm Drainage Assessments 120,185 Storm Dr Assessments, 73rd. Humboldt to Palmer Lake Sp Assess Constr Fund 107,955 Sp Assess Constr Fund MSA-Regular MSA-Regular MSA -Local MSA -Local Water Utility 61,800 Water Utility Sanitary Sewer Utility 58,350 Sanitary Sewer Utility Storm Drainage Utilty 42,530 Storm Drainage Utility Street Assessments 48,570 Street Assessments Storm Drainage Assessments 15,820 Storm Dr Assessments TABLE �� - ����]��V UQ������������ Detail v�f�^a����| '' --__- _ --,—_ , . Out Street | nts 4 03-Dec-01 1 Tona��wn Q / 55UUO 80B48O Sp/�seuuCons�Fund SpAoaeooCon��Fund . . yN SA-Loca| K8SA-Loco| Water Utility 641.606 Wa Utility 605885 San�orySevwerUtility SaniborySa�arUd|i�y . Storm Drainage UU8y 456.845 Storm Drainage Utility Street Light SD 85.378 Street Light SD Street Assessments 577.570 Street Assessments Storm Drainage Assessments 148.980 Storm OrAssessments � Tann|etownN � Sp Assess ConobFund 60,000 701.775 Gp Assess ConntrFund K�SA'Loca| �SA-Loc | 445815 Water Utility Water Utility . Sanitary Sewer Utility 420.940 Sanitary Sewer Utility Storm Drainage Ubky 305.070 Storm Drainage Utility ' 5B315 SbnadLight SO Street Light SD . Street Assessments 374.135 Street Assessments Storm Drainage Assessments 115.870 Storm DrAssessments Rivorwomd Gp Assess ConotrFund 60,000 843.260 Sp Assess ConstrFund YN�� -Local � K8SA-Loco| ' Water Utility 567.230 Wa Utility Sanitary Sewer Utility 535 Sanitary Sewer Utility Street Light SO 73.270 Street Light SD Storm Drainage UUhy 464.060 Storm Drainage Utility Street Assessments 446. 340 Street Assessments Storm Drainage Assessments 137.140 Storm DrAssessments ENHANCEMENTS Reforestation-project areas 11.270 Paint GQth Avenue parkway fence 30.000 Local State Aid Xerxes Avenue 8treoteuapo 300.000 Local State Aid L000|G�*�/�d BC|PStnoeb`uape TOTAL EXPENDITURES $6.926.980 $4.632.154 $8.976.856 $2.484.062 $4.435.845 *3.163.920 $3.701.790 . A1u �� TABLE ��-�~����@�| K0��3r������63 ����f�^|r�'�^�y������nf����� ^^ ~~^-~- -- Capital ' � '' ----- - -- Out StFeet| OleOtS 03-[]ec-01 FUND SOURCES: MSA - Regular 784,596 921.335 1�33,425 O 350,000 486.000 268,750 MSA - Regular N18A- Local 1.473.711 387.492 112.060 U 55.000 (302.700) (264.480) K8SA'Local � Water Utility 868.163 843.978 1.380.545 467.300 651.605 4G5.816 681.180 Water Utility Sanitary Sewer Utility 864.631 560.407 1.312.015 431.790 615.805 440.940 643.080 Sanitary Sewer Utility � Storm Drainage Utility 658.625 190.331 904.780 285.7$5 478.845 325.070 490.920 Storm Drainage Utility Street Light SD 57.700 61.090 85.370 58.315 73.270 Street Light SO Special Assessments: Streets 987.032 781.003 1.252.530 388.345 1.072.570 801.835 748.020 Street Assessments Special Assessments: Storm Or 310.298 268.794 437.235 136.005 148.960 115.870 217.780 Storm OrAoamaomanto| Special Assessment ConstrFund 982.903 884.964 1.401.586 746.747 969.490 761.776 843.260 Sp Assess Oonmtr Fur d T|F O (508.800) 0 D D 0 D T|F OthmrGovammmnto O 412.650 675.980 O O U O Other Governments TOTAL $8.926.960 $4.622.154 $8.878.855 *2.484.062 $4.425.645 $3.163.820 $3 � ' . � � ' � � � � � Am ►� ��V o �• ,: _ .:iii�•`l,Ifgtult► -: _ ; i1111111u '_ �.w nnunwurC _ .� -� � ;9 _:. i .' _ _ '� _ .� ' -_ • rr 4i�rru►►. 'i uunuu = w .p nunuu- :: .� �r ,} �.a - :7 J ' np! 'rruuh. � ' wunu � � � _ :■•� 111.: r a y 6 �i ;�' `a� ,? 2::7 �� :: — " � ' nu.n.0 Pu u _ ::,� { ■! • .k��y : � �i `'��F ���r4 67 ,:� ?� � 31q i • q _ . uw +u ■1 u■ ■a :: _y i k � 11 ■t'"0. ,; .. �t_■ 4 pin' u. u� .y! i\ �•:.m► ,, nun.. � ?� - �•'ry `ii'�!� '. � itiii +ii:: � u ni i■a � _' *� s act IB �� \�__ _ �_ �� ', .. :� r!_ "� ? -.r� ��,��s r y"�F", � �: �` - uuanru 'S �. � t ur h r►i# r /�� ` r w. -_ ,0 � \� � _ uf� ►nuurG ��t5 , Q � Mtllplu � 'I 'f , ■ � ": _ _ i1_e i- � �= � {fir _np1= • . � 1 �Y�_ � �, _ _ •�+1'�'"I{ 5.�� nun ■' __ ` ,•� - - • r +ii" � � �� _ 4 �� { t ..nn..........1... mull, uuunuw p ::. 8 .m��.: ➢ 1991 i:ui::i i :::iniii::e �� S _ - - =II - _ 7 _� ► til gig � itwii /��� IFiumi ■ ix - __ r i A. ., ::� -_ r .. _ .a :: �� ♦♦nun �.�A....n..........n.�� u iu� � iv . i�► ♦a�i : � �p -±. wn'� uumu uumun.p . ). `�_ I ' _ � I � , " uunn llir -� ii:f�ii: ' '.It 7. , �. :�� iiii: : :iiiiii:ii�wuunii:` - .•`� , � �► �'� ' � r r " ::: °u- `? •. �: ■ _?►Tnntpglllll� �■ .� unnllll V ut'rnnu.u.: �+ ! �I�i . m ��■ un7 : - :runt � - . run 1 n. u.n•oS .• _ it _ C� : � � � = I rltfllll: ,� -- rhp.• � � �I ,,� 1- - � � z :. 7: e? e3 - - - : nn 11 n•mnu `_ _e iiu? • - -_ P � �iT ■d \'d .n`" -� =' _ ? in i r !+ �:::,;� �•�.. i:: ►'� BIB IIi ... __ - = :_■ {{ ��► _ i ii r rrqunum ■►� �■ hf� / /A..� . I _ puou c ro gi BE S IN �Inm' - u■ ���� ��_ C FO C 11: - o m:._ mz uuu +•• r +, t1 I � \ 7� nuum ��'� 'c ele5tlll ■� 1 ■ 7 , i :It ■ 1 1 uwuu �. J► m a g . fi�u 111 ■. is 5 �� � i 7 ! e:ill::d► i:.� _ S , e_ • _ p t a 111 i- - a rWR1, ��• �, ii IIII +IIIrIr1111 I. _ _ _ � __ = = = pmt ►� ���! Y r r ; `,., 1 � _ + °uuunitl r t�',I :u:iiiiii :■t♦�� _ __ ca _ ■IJ3 �: =? Jg . -= - : P. "' Iunuu _ _ wm . uR _ ■ ••• _ e ��■ Lai gmu • • • "■ E � 1= t� + � a nuns �. li 11. 3a • Water Utility Fund • • • Water Utility Fund Rate Analysis 2002 2003 2004 2005 2006 2007 Revenues Water Service $ 1,225,000 $ 1,262,500 $ 1,300,000 $ 1,337,500 $ 1,375,000 $ 1,412,500 Misc. Operating $ 188,000 $ 225,100 $ 225,000 $ 225,000 $ 225,000 $ 225,000 Misc. Non - operating $ 68,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 Total Revenues $ 1,481,000 $ 1,517,600 $ 1,555,000 $ 1,592,500 $ 1,630,000 $ 1,667,500 Expenditures Personal Services $ 298,292 $ 328,477 $ 344,901 $ 362,146 $ 380,253 $ 399,266 Supplies $ 152,050 $ 159,050 $ 163,822 $ 168,736 $ 173,798 $ 179,012 Services $ 434,655 $ 422,555 $ 435,232 $ 448,289 $ 461,737 $ 475,589 Depreciation $ 433,898 $ 588,100 $ 600,000 $ 620,000 $ 640,000 $ 660,000 Debt Service $ _ $ _ $ _ $ $ $ Total Expenditures $ 1,318,895 $ 1,498,182 $ 1,543,954 $ 1,599,171 $ 1,655,789 $ 1,713,867 Capital Outlay $ 1,425,045 $ 608,900 $ 607,450 $ 641,605 $ 659,765 $ 567,230 Total Cash Requirements $ 2,743,940 $ 2,107,082 $ 2,151,404 $ 2,240,776 $ 2,315,554 $ 2,281,097 Cash Reserve Target $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 Beginning Cash Balance $ 1,763,546 $ 934,504 $ 933,122 $ 936,718 $ 908,442 $ 862,889 Revenues $ 1,481,000 $ 1,517,600 $ 1,555,000 $ 1,592,500 $ 1,630,000 $ 1,667,500 Expenditures $ (2,743,940) $ (2,107,082) $ (2,151,404) $ (2,240,776) $ (2,315,554) $ (2,281,097) Depreciation Add -back $ 433,898 $ 588,100 $ 600,000 $ 620,000 $ 640,000 $ 660,000 • Ending Cash Balance $ 934,504 $ 933,122 $ 936,718 $ 908,442 $ 862,889 $ 909,291 Additional Sums Necessary $ 66,878 $ 63,282 $ 91,558 $ 137,111 $ 90,709 to Meet Cash Requirements Current 2003 2004 2005 2006 2007 Assume a 3% Increase $ 0.98 $ 1.01 $ 1.04 $ 1.07 $ 1.10 $ 1.13 Water Sales $ 1,225,000 $ 1,262,500 $ 1,300,000 $ 1,337,500 $ 1,375,000 $ 1,412,500 Cash Balances $ 934,504 $ 933,122 $ 936,718 $ 908,442 $ 862,889 $ 909,291 To sustain a $1.0 million cash balance, an average rate increase of $ .15 would required each year of the five year period. The impact would be as follows on Water Sales Revenues- and Cash Balances. Rate $ 1.15 $ 1.30 $ 1.45 $ 1.60 $ 1.75 $ 1.90 Water Sales $ 187,500 $ 187,500 $ 187,500 $ 187,500 $ 187,500 $ 187,500 Cash Balances $ 1,122,004 $ 1,120,622 $ 1,124,218 $ 1,095,942 $ 1,050,389 $ 1,096,791 Assumptions: Cash basis All assumptions are predicated on Cash Basis presentation. Revenues Rate increases would be 3% per year across the board and are based on 1,250,000 1,000 gallon units billed. All other revenues would remain flat over the five year period. Expenditures Personal services increase at a total rate of 5% per annum. Supplies, Services increase at a total rate of 3% per annum. Depreciation increases at a rate of approximately 3% per annum. • Capital outlay is from the CfP for each year in the five year period. CITY OF BROOKLYN CENTER FUND 60100 • PROPRIETARY FUNDS -WATER UTILITY ^/ATERUTIUT1f 2003 BUDGET 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Operating Statement Revenues Operating Revenues Water Sales $ 1,192,330 $ 1,271,757 $ 1,225,000 $ 489,551 $ 1,262,500 $ - $ Fire Lanes $ 8,670 $ 8,530 $ 8,000 $ 4,320 $ 8,000 $ - $ - Water Meter Sales /Rental $ 2,411 $ 33,361 $ 15,000 $ 5,162 $ 16,300 $ - $ - Penalties $ 73,174 $ 85,998 $ 75,000 $ 42,936 $ 80,000 $ - $ - Tower Rental $ 52,675 $ 97,474 $ 75,000 $ 116,501 $ 100,000 $ $ Misc. Revenue $ 18,961 $ 23,320 $ 15,000 $ 16,020 $ 20,800 $ - $ Subtotal Operating Revenues $ 1,348,221 $ 1,520,440 $ 1,413,000 $ 674,490 $ 1,487,600 $ - $ Non- operating Revenues Investment Earnings $ 103,562 $ 208,501 $ 68,000 $ - $ 30,000 $ - $ Other Revenue $ 45,861 $ 20,764 $ - $ 230 $ - $ - $ _ Subtotal Non - operating Revenues $ 149,423 $ 229,265 $ 68,000 $ 230 $ 30,000 $ - $ - Total Revenues $ 1,497,644 $ 1,749,705 $ 1,481 000 $ 674,720 $ 1,517,600 $ - $ Cost of Goods Sold $ - $ - $ $ - $ - $ - $ - Gross Profit $ 1,497,644 $ 1.749,705 $ 1 481 000 $ 674.720 $ 1,517,600 $ - $ 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Expenses Operating Expenses Other Expenses /Uses Wages and Salaries $ 260,061 $ 252,375 $ 235,959 $ 125,070 $ 258,224 $ - $ - Fringe Benefits $ 54,589 $ 63,427 $ 62,333 $ 34,056 $ 70,253 $ - $ - Supplies $ 114,298 $ 141,696 $ 152,050 $ 68,125 $ 159,050 $ - $ Services $ 477,908 $ 667,929 $ 434,655 $ 206,974 $ 422,555 $ - $ - • Depreciation Expense $ 400,358 $ 414,966 $ 433,898 $ - $ 588,100 $ - $ Capital Outlay $ 972,460 $ 723,507 $ 1,425,045 $ 32,245 $ 608,900 $ - $ Debt Service $ - $ - $ - $ - $ - $ - $ Total Operating Expenses $ 2,279,674 $ 2,254,100 $ 2,743,940 $ 466.470 $ 2,107,082 $ - $ And Other Expenses /Uses Net Income $ (782,030) $ (514,395) $ (1,262,940) $ (589,482) $ - $ - Beginning Cash Balance January 1 $ 2,822,155 $ 2,229,616 $ 1,763,546 $ 934,504 $ 933,122 $ 933,122 Net Income $ (782,030) $ (514,395) $ (1,262,940) $ (589,482) Add Back Depreciation Expense $ 400,358 $ 414,966 $ 433,898 $ 588,100 Other Cash Realted Activities $ (210 867) $ (366 641) $ - $ _ $ $ - Ending Cash Balance December 31 $ 2,229,616 $ 1,763,546 $ 934,504 $ 933,122 $ 933,122 $ 933,122 • CITY OF BROOKLYN CENTER FUND 60100 • WATER UTILITY FUND REVENUE -2003 Page 1 2000 2001 2002 2002 2003 2003 2003 MISCELLANEOUS REVENEEE Actual Actual Budget To Date Request Recommend Adopt 4600 Miscellaneous Revenue 4601 Special Assess- Principal $ 24,003 $ 1,930 4602 Special Assess - Penalties and It $ 15,772 $ 18,323 4603 Interest Earnings $ 103,562 $ 208,501 $ 68,000 $ 30,000 4604 Check Processing Fee $ 180 $ 390 $ 180 4605 Gain or Loss on Inventory 4606 Misc Revenue not Otherwise Cl $ 5,906 $ 121 $ - $ 50 $ - $ - $ - Subtotal Miscellaneous Revenue $ 149,423 $ 229,285 $ 68,000 $ 230 $ 30,000 $ - $ ENTERPRISE FUND REVENUES 4700 Enterprise Fund Revenues Utility Funds 4701 Water Utilfty-Water Sales $ 1,192,330 $ 1,271,757 $ 1,225,000 $ 489,551 $ 1,262,500 4702 Water Utility-Fire Lanes $ 8,670 $ 8,530 $ 8,000 $ 4,320 $ 8,000 4703 Water Utility -Water Meter Sales $ 2,411 $ 29,886 $ 15,000 $ 5,004 $ 16,000 $ - $ 4704 Water Utility -Water Meter Rentals $ 3,475 $ 158 $ 300 4705 Water Utility- Service Restoratioi $ 953 $ 180 $ 270 $ 300 4706 Water Utility- Connection Charge $ 5,500 $ 3,000 $ 5,500 4707 Water Utility- Penalties $ 73,174 $ 85,998 $ 75,000 $ 42,936 $ 80,000 4708 Water Utility -Tower Rental $ 52,675 $ 97,474 $ 75,000 $ 116,501 $ 100,000 4709 Water Utility - Certification Fee $ 18,008 $ 17,640 $ 15,000 $ 12,750 $ 15,000 4711 Water Utility - Mailing List Fee Subtotal Water Utility - Operations $ 1,348,221 $ 1,520,440 $ 1,413,000 $ 674,490 $ 1,487,600 $ - $ - TOTAL REVENUE AND $ 1,497,644 $ 1,749,705 $ 1,481.000 $ 674.720 $ 1,517,600 $ - $ - , O7HER SOURCES . .. -_. • • • City of Brooklyn Center 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Water Utility Fund - 60100 DEPT /ACTIVITY/PROJECT: Operations - 49141 PROFILE This division provides for the distribution of water to customers. Administration and utility billing are also included. The division is managed by the Public Works Director, except for the utility billing component which is managed by the Finance Director, and has been established as an enterprise fund. The City has 114.98 miles of water main, 1,362 water valves, and 975 fire hydrants providing service to 7,311 metered single family residential connections and 1,624 metered apartments /townhouses /commercial /industrial customers. Also included in this division is the maintenance of meters, locating water mains and services, testing of the municipal water supply throughout the system as required, preventative maintenance, and emergency repairs to the City's distribution system and its appurtenances. The utility billing operation prepares and sends out utility bills, receives meter readings • and makes estimated readings, and administers collections and assessment for non- payment. This activity involves the production of water and the maintenance of the City's nine wells and three towers, including buildings, chemical feed equipment, and grounds, as well as monitoring the Jordan Aquifer, which is the City's source of water. Water system improvements are made as part of the neighborhood street reconstruction or other improvement projects. Street and Utility Improvements. Substantial water main improvements are generally completed in association with street improvement projects. The 2003 project consists of the Happy Hollow Neighborhood. It is expected that all of the water mains will be replaced in the project area. DEPARTMENTAL GOALS • Change, read and repair residential and commercial water meters as necessary. • Provide timely locating services as per Gopher State One Call. • Work together with the Engineering Division in reconstruction areas to inspect new water services, mains and disconnects, and provide assistance to customers in construction areas who are receiving new water services. • • Provide fire flow information and assist insurance companies in gathering additional information as needed (i.e., assist in fire flow testing). • • Maintain weekly bacteria testing and daily fluoride testing and reports as required by the State Health Department. • Conduct lead and copper testing as required, and proactive contract and in -house testing for iron, manganese, zinc and calcium/magnesium hardness. • Maintain training sponsored by the Minnesota Department of Health, as well as in house training in right to know, confined space entry and work zone safety. • Continue routine maintenance and emergency repair of fire hydrants, system valves and water mains, and seasonal and routine flushing of water mains. • Prepare and disseminate to all customers EPA - required Consumer Confidence Reports. • Routine and emergency maintenance of wells, continued monitoring of static /pumping levels and well depths. • Maintain chemical feed equipment so as to comply with state guidelines for disinfection, fluoridation and corrosion control. • Preventative maintenance and emergency repairs of electrical controls, telemetry system and building and grounds. • Routine maintenance and repair of the interiors /exteriors of the City's water towers providing for proper seasonal level fluctuation to avoid possible structural damage. • Maintain accurate calibration of all towers. • Perform, in a cost - effective manner, water system improvements as a part of neighborhood street reconstruction or other improvement projects. • Complete the projects included in the 2002 budget, on time and within budget. • Repair, rehabilitate, or reconstruct water facilities as necessary to provide for efficient and effective operations. EXPENDITURE DETAILS 6216 Chemical Products $75,000 Various chemicals are added to City water for disinfection, fluoridation, reduced corrosivity, and to hold the naturally- occurring nuisance mineral manganese in solution. 6219 Operating Supplies $9,500 Various supplies, such as chemical feed equipment, pumps, motors and scales. 6235 Utility System Supplies $50,000 The cost of routinely replacing water meters. Previously, water meters were not budgeted, but were an inventory expense offset by meter deposits placed by new customers. More meters are being systematically replaced, during maintenance calls and in improvement project areas. • 6239 Repair & Maintenance Supplies $14,250 Various supplies used in the maintenance of the distribution system, such as valve box extensions, gate valves, supplies needed for water main breaks, etc. Includes the cost of repair or replacement of mechanical equipment in the pump houses. 6302 Arch, Engineering and Planning $25,000 Well -head protection program as required by the Minnesota Department of Health. 6322 Postage $19,000 Includes the water utility's share of the cost of postage to mail utility bills and meter reading cards. The EPA - required Consumer Confidence Report is now distributed in the City newsletter reducing the postage necessary as the postage costs are now shared for the issue containing the EPA required report. 6351 Printing Svs $4,600 The cost of printing Consumer Confidence Reports for all users of City water. 6381 Utility Service- Electric $100,000 • The cost of pumping water. Reduced from $130,000 to reflect new energy saving equipment and practices. 6403 Repair and Maintenance Svs - Buildings and Facitilites $18,500 Routine electrical repairs in well houses. 6441 Licenses, Taxes, and Fees $55,200 State of Minnesota Water Testing Fee, a charge per water connection. The Water Appropriation Permit fee charged by the DNR for the pumping of groundwater from the Jordan Aquifer. 6449 Other Contractual Service $39,000 Generally, the cost of obtaining assistance from private contractors to repair water main breaks, such as to provide dewatering or specialized equipment not owned by the City. Also includes specialized contractual services such as motor rewinding. Included is $6,000 for a leak survey. This is a contractual service that will proactively check the integrity of the water system. • • PERSONNEL LEVELS 1 Supervisor of Public Utilities 4 Maintenance II 2 Seasonal/Part-Time CAPITAL OUTLAY Item Computer Qty: 1 Unit Cost $1,600 Less Trade -in: $ -0- Total Cost: $1,600 Happy Hollow Neighborhood Project Qty: 1 Unit Cost: $395,500 Less Trade -in: $ -0- Total Cost: $395,5000 • SCADA Computer System Qty: 1 Unit Cost: $56,400 Less Trade -in: $ -0- Total Cost: $56,400 73 Avenue Project Qty: 1 Unit Cost: $61,800 Less Trade -in: $ -0- Total Cost: $61,800 TH #100 Utility Movement Qty: 1 Unit Cost: $150,000 Less Trade -in: $ -0- Total Cost: $150,000 Soil Compactor Qty: 1 Unit Cost: $2,450 Less Trade -in: $200 • Total Cost: $2,250 CITY OF BROOKLYN CENTER FUND 60100 • w , WATER UTILITY FUND DEPT/DIV NO.: . "� ",_ r 491141 =PPERATIONS , Obj Descri °: ption -49141 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONAL SVS WAGES AND SALARIES 6101 Wages and Salaries -FT Emp $ 221,318 $ 215,898 $ 205,428 $ 107,841 $ 224,724 6102 Overtime -FT Emp $ 25,109 $ 21,842 $ 16,000 $ 12,280 $ 19,000 6103 Wages and Salaries -PT Emp $ 13,634 $ 13,699 $ 14,531 $ 4,949 $ 14,500 6104 Overtime -PT Emp 6106 Wages and Salaries -Temp Emr $ 936 $ - 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord $ 12,734 $ 12,353 $ 13,049 $ 6,608 $ 14,279 6123 PERA -FT Emp -Pol &Fire 6124 PERA- Defined Contribution 6125 FICA- Medicare $ 20,266 $ 20,089 $ 18,051 $ 9,962 $ 19,754 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions $ 17,116 $ 26,812 $ 25,800 $ 14,525 $ 30,000 OTHER PAYMENTS 6141 Unemployment Comp OTHER INSURANCE 6151 Workers Comp Ins $ 4,473 $ 4,173 $ 5,433 $ 2,941 $ 6,220 SUBTOTAL PERSONAL $ 314,650 $ 315,802 $ 298,292 $ 159,126 $ 328,477 $ - $ SVS SUPPLIES 2000 2001 2002 2002 2003 2003 2003 OFFICE SUPPLIES Actual Actual Budget To Date Request Recommend Adopt 6201 Office Supplies $ 4,904 $ 3,000 $ 3,000 • 6202 Copying Supplies 6203 Books /Reference Materials $ 300 $ 192 $ 300 6204 Stationary Supplies OPERATING SUPPLIES 6211 Cleaning Supplies 6212 Motor Fuels 6213 Lubricants and Additives 6214 Clothing and Personal Equip 6215 Shop Materials 6216 Chemicals /Chemical Products $ 74,714 $ 74,787 $ 68,000 $ 27,935 $ 75,000 6217 Safety Supples $ 1,532 $ 1,476 $ 2,000 $ 716 $ 2,000 6218 Welding Supplies 6219 General Operating Supplies $ 9,389 $ 8,180 $ 9,500 $ 740 $ 9,500 REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities $ 4,345 $ 749 $ 3,500 $ 83 $ 3,500 6224 Street Maint Materials $ 238 $ 1,000 $ 1,000 6225 Park & Landsacpe Materials 6226 Sign & Striping Materials 6227 Paint Supplies $ 180 6231 Athletic Field Supplies 6232 Trailway Supplies 6233 Court Supplies 6235 Utlity System Supplies $ 14,829 $ 48,107 $ 50,000 $ 22,001 $ 50,000 6236 DARE Supplies 6237 Laundry Supplies 6239 Other Repair & Maintenance SL $ 4,203 $ 8,403 $ 14,250 $ 16,278 $ 14,250 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ 144 $ 104 $ 500 $ 500 6242 Minor Equip $ 90 SUBTOTAL SUPPLIES $ 141,896 $ 152,050 $ 68,125 $ 159,050 $ • Obi Description -49141 2000 2001 2002 2002 2003 2003 2003 • Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs $ 1,275 $ 1,671 $ 1,300 $ 1,195 $ 1,300 6302 Arch, Eng and Planning $ 25,000 6303 Legal $ 581 6305 Medical Svs 6306 Personnel/Labor Relations 6307 Professional Svs $ 8,162 $ 9,133 $ 500 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager $ 264 $ 251 $ 350 $ 295 $ 350 6322 Postage $ 17,562 $ 18,119 $ 19,000 $ 8,951 $ 19,000 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Expense /Mileage $ 143 $ 70 $ 150 $ 150 6332 Contracted Transportation 6333 Freight/Drayage $ 9 6339 Other Transporation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising PRINTING /DUPLICATING 6351 Printing Svs $ 3,154 $ 4.507 $ 3,500 $ 3,408 $ 4,600 5352 Micro - filming Svs INSURANCE 6361 General Liability $ 7,372 $ 10,556 $ 9,000 $ 3,337 $ 9,000 6362 Property Damage $ 856 $ 965 $ 1,000 $ 291 $ 1,000 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown $ 206 $ 221 $ 275 $ 65 $ 275 • 6367 Equipment (Inland Marine) 6368 Bonds 6369 Other Insurance UTILITY SERVICES 6381 Electric $ 113,298 $ 116,826 $ 100,000 $ 33,277 $ 100,000 6382 Gas $ 3,778 $ 7,383 $ 5,000 $ 3,444 $ 5,000 6383 Water 6384 Refuse Disposal 6385 Sewer $ 190 $ 200 $ 210 $ 105 $ 210 6386 Storm Sewer $ 4,060 $ 4,365 $ 4,700 $ 2,431 $ 4,700 6387 Heating oil 6388 Hazardous Waste Disposal 6389 Street Lights $ 423 $ 1,000 CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs $ 535 $ 1,546 $ 18,500 6403 Buildings and Facilities Maint S $ 432 6404 Street Maint Svs 6405 Paris and Landscape Svs $ 310 6407 Traffic Control Maint Svs 6408 Communication/information Sv: $ 595 $ 729 $ 500 $ 414 $ 850 6409 Other Repair and Maint Svs $ 23,464 $ 4,600 $ 1,802 $ 4,600 RENTALS 6411 Land 6412 Buildings /Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Exp • Obj Description -49141 2000 2001 2002 2002 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Recommend Adopt SERVICES /LICENSES/FEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges $ 25,006 $ 27,220 $ 28,610 $ 11,783 $ 27,686 6428 Protection Svs MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ 1,803 $ 1,542 $ 2,200 $ 825 $ 2,200 6433 Meeting Exp 6434 Dues and Subscriptions $ 1,377 $ 1,521 $ 1,500 $ 200 $ 1,600 6435 Credit Card Fees 6436 Uncollectible Checks $ ( 103) 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees $ 52,258 $ 52,396 $ 52,950 $ 30,067 $ 55,200 6442 Court Awards/Settlements $ 252 6443 Prize Awards/Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges - Prisioner 6449 Other Contractual Svs $ 53,842 $ 45,387 $ 20,600 $ 18,261 $ 39,000 CENTRAL GARAGE CHARGES 6461 Fuel Charges $ 1,878 $ 2,711 $ 2,181 $ 1,021 $ 2,247 6462 Fixed Charges $ 14,621 $ 15,501 $ 21,382 $ 11,191 $ 22,023 6463 Repair and Maint Charges $ 11,742 $ 23,149 $ 15,543 $ 3,630 $ 16,009 6464 Multi -use Charges 6465 Replacement Charges $ 13,786 TRANSFERS AND OTHER USES 6471 Administrative Service Transfer $ 129,193 $ 137,467 $ 140,104 $ 70,048 $ 61,055 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out • 6475 Contingency 6476 Special Assessment Transfer -C 6477 Capital Project Transfer -Out $ 170,500 ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales - Taxable 5565 Other Cost of Sales - Nontaxable 5586 Cost of Sales -Mist 5587 Inventory Variances 5588 Merchandise Breakage _5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise - Purchase for Res: 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp 6494 Depreciation Exp $ 400,358 $ 414,966 $ 433,898 $ 588,100 5591 Contractor Pmts - Personal Svs 5593 Contractor Pmts - Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 878,266 $ 1,082,895 $ 858,553 $ 206,974 $ 1,010,855 $ - $ - OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities $ 21,889 6530 Improvements $ 969,223 $ 723,507 $ 1,423,045 $ 8,847 $ 607,300 6540 Equip and Machinery $ 3,237 6550 Motor Vehicles 6560 Furniture 6570 Office Equip 6580 Informabon Systems $ 2,000 $ 1,509 $ 1,600 6590 Leases SUBTOTAL CAPITAL $ 972,460 $ 723,507 $ 1,425,045 $ 32,245 $ 608,900 $ - $ - • OUTLAY Obi Description -49141 2000 2001 2002 2002 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal INTEREST 6611 Bond Interest 6612 Other Debt Interest AGENT/ISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ - $ $ - $ _ $ _ $ _ $ SERVICE TOTAL BUDGET -49141 $ 2,165,376 $ 2,264,100 $ 2,743,940 $ 466,470 $ 2,107,082 $ - $ - • • y ; c • dl WATER UTILITY RATE STUDS 2002 10- Oct -01 bud et budget 1012 _ .. 4. r •,t - @ K v; as r•.., Start of Year C � . ;�.t .�.�. Cash &Investments 2'�� 9'�, �•. - �. �• ��.•�. -.• -.• ,� -�•: II =L : $ _J. 2 '�_� $:1� 7;O fr6:T�_ , - $ �U'6G� •:� 87G.��`J.6, .��. ., :). _.�. «.i. . --1:...!- A.; +1t?e':�:�P_._ ..,.�. . s. r, 7 - ' : ��%, �1�i....._,. �:. �_». �.!-• d.'�x:.x:,�,.s�..:�..7_,...:.,, e�i,,:: Sig ?Au�•;._ EXPEND /TURFS Operations Personal Service $448,079 $438,395 $451,547 $465,093 $479,046 $493,417 Contractual Service 209,590 209,866 216,162 222,647 229,326 236,206 Supplies & Materials 147,000 152,050 156,612 161,310 166,149 171,134 Utilities /Insurance 119,475 120,185 123,791 127,504 131,329 135,269 Depreciation 412,055 433,899 450,000 460,000 470,000 470,000 TOTAL EXPENDITURES $1,336,199 $1,354,395 $1,398,111 $1,436,554 $1,475,851 $1,506,026 REVENUES Billing Revenues $1,225,000 $1,225,000 $1,375,000 $1,475,000 $1,550,000 $1,650,000 Miscellaneous Operating 155,000 160,000 165,000 170,000 175,000 180,000 Bond proceeds Change in Fair Market Value of Inv Miscellaneous Non - operating 20,000 20,000 20,000 20,000 20,000 20,000 TOTAL REVENUES $1,400,000 $1,405,000 $1,560,000 $1,665,000 $1,745,000 $1,850,000 Net Income or Loss $63,801 $50,605 $16 -1,889 $228,446 $269,149 $343,974 Depreciation Add -Back ' $412,055 I $433,899 I $450,000 $460,000 $470,000 I $470,000 :' is rF n: ::: :::;:;:i:::::::• . ......... . 0� � • (70�iiiiiii €i'si ' iii : €i� � : �iiiiii�isiii i �Q�iiiii::iiiii: • fl Non Operating Expenditures ....................................................... ............................... ........... ..................... . Capital Outlay $1,053,978 $1,389,545 $607,300 $764,105 $465,815 $681,180 Debt Service $56,300 $56,300 Non Operating Revenues Interest Earnings $111,481 $85,334 $41,533 $43,839 $42,249 $58,028 Total Net Effect on Fund Balance ($522,941) ($876,007) $46,122 ($31,820) $315,583 $190,821 97 ...• #�' �_4. °': T.T." . . .: �. 'T�� - _j.'.:� ' � ^ -T� ?.. - .TC�,.t_ - il^. n, "'� +- -Tr.^n - - - End of Year ar Cash &Investments 84970'f?' y , ,,.,. �,��..._!,. _, �. J��..�.._ . �. •J.- a;.Ch �,.._,..L, _..:na .,•M. _.. a�._.,...,...L .. .. ..t: . i+ s_'.. r. :.�........�..n,.J.......u...i- r¢2s. .,._ .•.�.(,_ .L. ..as ,;:rG.4 .D..__ .a_.t .- 7�� For Information Cash Balance Target $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 itl2i'` @'iii . iR r ty :tea a I �► ��iii�:�isiii�iiiiiiii:�:iiiii. . :� �:�•.. .../ . A. �1. 124ii €'•i`ii €i�iiii�iiiiiii. . Number of gallons (in 1000s) 1,250,000 1,250,000 • 1,250,000 1,250,000 1,250,000 1,250,000 3b 1 • • Sewer Utility Fund • • • Sewer Utility Fund Rate Analysis 2002 2003 2004 2005 2006 2007 Revenues Sewer Charges $ 2,646,966 $ 2,685,690 $ 2,725,380 $ 2,765,070 $ 2,804,760 $ 2,844,450 Misc. Operating $ - $ - $ - $ _ $ _ $ - Misc. Non - operating $ 31,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 Total Revenues $ 2,677,966 $ 2,715,690 $ 2,755,380 $ 2,795,070 $ 2,834,760 $ 2,874,450 Expenditures Personal Services $ 125,152 $ 120,263 $ 126,276 $ 132,590 $ 139,219 $ 146,180 Supplies $ 18,750 $ 20,100 $ 20,703 $ 21,324 $ 21,964 $ 22,623 Services $ 1,649,726 $ 1,785,147 $ 1,838,701 $ 1,893,862 $ 1,950,678 $ 2,009,199 Depreciation $ 250,148 $ 432,100 $ 445,000 $ 460,000 $ 475,000 $ 490,000 Debt Service $ - $ _ $ - $ _ $ - $ _ Total Expenditures $ 2,043,776 $ 2,357,610 $ 2,430,681 $ 2,507,776 $ 2,586,862 $ 2,668,002 Capital Outlay $ 1,396,315 $ 633,390 $ 565,610 $ 605,805 $ 1,078,440 $ 535,590 Total Cash Requirements $ 3,440,091 $ 2,991,000 $ 2,996,291 $ 3,113,581 $ 3,665,302 $ 3,203,592 Cash Reserve Target $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 Beginning Cash Balance $ 1,003,252 $ 491,275 $ 648,065 $ 852,154 $ 993,643 $ 638,101 Revenues $ 2,677,966 $ 2,715,690 $ 2,755,380 $ 2,795,070 $ 2,834,760 $ 2,874,450 Expenditures $ (3,440,091) $ (2,991,000) $ (2,996,291) $ (3,113,581) $ (3,665,302) $ (3,203,592) Depreciation Add -back $ 250,148 $ 432,100 $ 445,000 $ 460,000 $ 475,000 $ 490,000 • Ending Cash Balance $ 491,275 $ 648,065 $_ 852,154 $ 993,643 $ 638,101 $ 798,960 Additional Sums Necessary $ 301,935 None None None None to Meet Cash Requirements Current 2003 2004 2005 2006 2007 Assume a 3% Increase $ 2.00 $ 2.03 $ 2.06 $ 2.09 $ 2.12 $ 2.15 Sewer Charges $ 2,500,000 $ 2,685,690 $ 2,725,380 $ 2,765,070 $ 2,804,760 $ 2,844,450 Cash Balances $ 491,275 $ 648,065 $ 852,154 $ 993,643 $ 638,101 $ 798,960 To maintain cash balance, an average rate increase of 1.5% would be required. Assumptions: Cash basis All assumptions are predicated on Cash Basis presentation. Revenues Rate increases would be 3% per year across the board based on 1,323,000 1,000 gallon units billed. All other revenues would remain flat over the five year period. Expenditures Personal services increase at a total rate of 5% per annum. Supplies, Services increase at a total rate of 3% per annum. Depreciation increases at a rate of approximately 3% per annum. • Capital outlay is from the CIP for each year in the five year period. • CITY BROOKLYN CENTER¢ FUND 60200 PROPRIETARY FUNDS -SEWER UT1417Y 'SEWERUTII�TY '' � 2003 BUDGET 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Operating Statement Revenues Operating Revenues Sewer Service $ 2,398,323 $ 2,604,199 $ 2,646,966 $ 1,263,465 $ 2,685,690 $ - $ Sewer Connection Charge $ 3,000 Subtotal Operating Revenues $ 2,398,323 $ 2,604,199 $ 2,646,966 $ 1,266,465 $ 2,685,690 $ - $ Non- operating Revenues Investment Earnings $ 54,243 $ 133,186 $ 30,000 $ - $ 30,000 $ - Other Revenue $ 314 $ 1,089 $ 1,000 $ - $ _ $ - Subtotal Non - operating Revenues $ 54,557 $ 134,275 $ 31,000 $ - $ 30,000 $ - $ Total Revenues $ 2,452,880 $ 2,738,474 $ 2,677,966 $ 1,266,465 $ 2,715,690 $ - $ - Cost of Goods Sold $ _ $ - $ - $ _ $ $ _ $ Gross Profit $ 2,452,880 $ 2.738 474 $ 2677.966 $ 1.266,465 $ 2,715.690 $ - $ 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Expenses Operating Expenses Other Expenses/Uses Wages and Salaries $ 95,887 $ 106,752 $ 99,117 $ 66,717 $ 93,652 Fringe Benefits $ 23,277 $ 26,435 $ 26,035 $ 16,548 $ 26,611 - Supplies $ 10,413 $ 15,602 $ 18,750 $ 6,901 $ 20,100 Services $ 1,576,865 $ 1,626,825 $ 1,649,726 $ 824,629 $ 1,785,147 Depreciation Expense $ 213,401 $ 239,381 $ 250,148 $ - $ 432,100 Capital Outlay $ 1,295,282 $ 500,911 $ 1,396,315 $ 726,300 $ 633,390 Debt Service $ - $ - $ _ $ _ $ _ $ _ $ Total Operating Expenses $ 3,215,125 $ 2.515,906 $ 3440091 $ 1.641095 $ 2.991.000 $ - $ - • And Other Expenses /Uses .. ..... ...�- Net Income $ (762,245) $ 222,568 $ (762,125) $ (275,310) $ - $ - Beginning Cash Balance January 1 $ 1,332,556 $ 299,529 $ 1,003,252 $ 491,275 Net Income $ (762,245) $ 222,568 $ (762,125) $ (275,310) Add Back Depreciation Expense $ 213,401 $ 239,381 $ 250,146 $ 432,100 Other Cash Realted Activities $ 86,128 $ 241,774 Ending Cash Balance December 31 $ 299,529 $ 1,003,252 $ 491.275 $ - $ 648,065 $ - $ - • CITY OF BROOKLYN CENTER - - _ FUND 60200 • SEINER UTILITY FUND, REVENUE-2003 Page 1 2000 2001 2002 2002 2003 2003 2003 MISCELLANEOUS REVENEUE Actual Actual Budget To Date Request Recommend Adopt 4600 Miscellaneous Revenue 4601 Special Assess - Principal $ 1 000 4602 Special Assess - Penalties and Ir $ 314 $ 289 4603 Interest Earnings $ 54,243 $ 133,186 $ 30,000 $ 30,000 4604 Check Processing Fee 4605 Gain or Loss on Inventory $ 800 4606 Misc Revenue not Otherwise CI $ - $ - Subtotal Miscellaneous Revenue $ 54,557 $ 134,275 $ 31,000 $ - $ 30,000 $ - $ ENTERPRISE FUND REVENUES 4700 Enterprise Fund Revenues 4721 Sewer Utility-Sewer Service $ 2,398,323 $ 2,604,199 $ 2,646,966 $ 1,263,465 $ 2,685,690 4726 Sewer Utility- Connection Charge $ 3,000 Subtotal Sewer Utility- Operations $ 2,398,323 $ 2,604,199 $ 2,646,966 $ 1,266,465 $ 2,685,690 $ - $ - TOTAL REVENUE AND $ 2,452,880 $ 2,738,474 $ 2,677,966 $ 1,266,465 $ 2,715,690 $ - $ OTHER SOURCES • • City of Orookfyn Center • 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Sanitary Sewer Utility Fund — 60200 DEPT /ACTIVITY/PROJECT: Operations — 49251 PROFILE This division provides for the collection and pumping of sanitary sewage through a system of mains and lift stations. Sewage is treated by the Met Council of Environmental Services, whose fees account for approximately 75% of this fund's expenditures. Administration and utility billing are also included. This division is managed by the Public Works Director, except for the utility billing component which is managed by the Finance Director, and has been established as an enterprise fund. The City has approximately 105.51 miles of sanitary sewer ranging in size from 8" to 24" in diameter, and 8,774 service connections. Included in this division is the routine and preventative maintenance of the City's collection system and its appurtenances, monitoring of inflow and infiltration, television inspection of the interiors of mains, and customer service such as providing sewer locations. • The utility billing operation prepares and sends out utility bills. This activity involves the operation and maintenance of the City's ten waste water lift stations, which includes buildings, equipment, and property. Sewer system improvements are made as part of the neighborhood street reconstruction or other improvement projects. Street and Utility Improvements. Substantial sanitary sewer main improvements are generally completed in association with street improvement projects. In the Happy Hollow Area neighborhood project, it is expected that nearly all main would be replaced. Other Improvements. The control cabinets and electronic controls would be replaced in 2003 at lift stations 4 and 5, in the first year of a three -year program to update this equipment. Provide stabilization of the Mississippi River Bank, north of the freeway, in order to protect the sanitary sewer interceptor that runs from 66 Avenue to 67 Avenue north. The City has been working with the Army Corps of Engineers on the project. The cities contribution will be approximately $100,000. • • DEPARTMENTAL GOALS • Provide timely locating services as per Gopher State One Call. • Work together with the Engineering Division in reconstruction areas to inspect new installations as well as repairs on mains and services. • Continue root sawing of approximately 20 miles of main every year. • Maintain routine line cleaning of known trouble spots, as well as regular routine cleaning to remove grit, grease and roots. • Televise all project areas and trouble spots as identified by city staff and establish repairs and/or repair projects from information obtained. • Monitor inflow and infiltration and take necessary action to reduce or eliminate. • Continue established preventative and regular maintenance program on electrical controls, buildings, and grounds. • Monitor inflow and pump efficiency. • Perform, in a cost - effective manner, sewer system improvements as a part of neighborhood street reconstruction or other improvement projects. • Complete the projects included in the 2003 budget on time and within budget. • Repair, rehabilitate, or reconstruct sanitary sewer facilities as necessary to provide for efficient and effective operations. EXPENDITURE DETAILS • 6216 Chemical Products $5,000 Degreaser and root destroyer used at lift stations. 6219 Operating Supplies $10,000 Marking paint, marking flags, sewer jet parts, blades, motors, etc. Includes $1,900 to purchase a replacement sewer jet hose. 6239 Repair & Maintenance Supplies $3,000 The cost of check valves, sump pumps, floats, float switch controls, etc. 6381 Utility Services- Electric $25,000 The cost of operating lift station pumps. 6391 Met Council Environmental Services $1,440,000 Charges by the Metropolitan Council Environmental Services for processing the City's sewage. • • 6403 Repair and Maintenance Svs- Buildings and Facilities Maint Svs $3,600 Routine electrical repairs to lift stations. 6409 Repair and Maintenance Svs -Other $80,000 Replace lift station cabinets as part of ongoing maintenance program for all lift stations in the City. 6449 Other Contractual Service $12,500 Routine oxygen sensor calibration, gas monitor maintenance, inspection of lift station pumps, generator load banking, etc. Generally, specialized contractual services such as pump rewinding. PERSONNEL LEVELS 2 Maintenance II 2 Seasonal/Part-Time CAPITAL OUTLAY • Item Happy Hollow Neighborhood Project Qty: 1 Unit Cost: $373,440 Less Trade -in: $ -0- Total Cost: $373,440 Riverbank Stabilization Project Qty: 1 Unit Cost: $100,000 Less Trade -in: $ -0- Total Cost: $100,000 73 Avenue Project Qty: 1 Unit Cost: $58,350 Less Trade -in: $ -0- Total Cost: $58,350 TH # 100 Utility Movement • Qty: 1 • Unit Cost: $100,000 Less Trade -in: $ -09- Total Cost: $100,000 • • CITY OF BROOKLYN CENTER FUND 60200 • SEWER UTILITY FUND DEPTIDIV NO.: -_ 48251, OPERATION$ `; Obj Description -49251 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONALSVS WAGES AND SALARIES 6101 Wages and Salaries -FT Emp $ 74,577 $ 86,472 $ 77,342 $ 55,227 $ 79,952 6102 Overtime -FT Emp $ 18,742 $ 18,681 $ 17,000 $ 10,801 $ 9,000 6103 Wages and Salaries -PT Emp $ 2,568 $ 662 $ 4,775 $ 689 $ 4,700 6104 Overtime -PT Emp 6106 Wages and Salaries -Temp Emp $ 937 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord $ 4,790 $ 5,522 $ 5,217 $ 3,638 $ 5,179 6123 PERA -FT Emp -Pol &Fire 6124 PERA - Defined Contribution 6125 FICA - Medicare $ 7,639 $ 8,489 $ 7,582 $ 5,186 $ 7,164 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions $ 9,256 $ 10,847 $ 11,326 $ 6,330 $ 12,000 OTHER PAYMENTS 6141 Unemployment Comp OTHER INSURANCE 6151 Workers Comp Ins $ 1,592 $ 1,577 $ 1,910 $ 1,394 $ 2,268 SUBTOTAL PERSONAL $ 119,164 $ 133,187 $ 125,152 $ 83,265 $ 120,263 SVS 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt SUPPLIES OFFICE SUPPLIES 6201 Office Supplies $ 2,413 $ 174 $ 2,250 $ 17 $ 500 • 6202 Copying Supplies 6203 Books /Reference Materials $ 56 $ 100 6204 Stationary Supplies $ 1,494 OPERATING SUPPLIES 6211 Cleaning Supplies 6212 Motor Fuels 6213 Lubricants and Additives 6214 Clothing and Personal Equip 6215 Shop Materials 6216 Chemicals /Chemical Products $ 4,665 $ 4,534 $ 4,500 $, 2,900 $ 5,000 6217 Safety Supples $ 593 $ 65 $ 1,000 $ - $ 1,000 6218 Welding Supplies 6219 General Operating Supplies $ 1,183 $ 7,429 $ 7,500 $ 1,105 $ 10,000 REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities $ 14 6224 Street Maint Materials 6225 Park & Landsacpe Materials 6226 Sign & Striping Materials 6227 Paint Supplies 6231 Athletic Field Supplies 6232 Trailway Supplies 6233 Court Supplies 6235 Utlity System Supplies - 6236 DARE Supplies 6237 Laundry Supplies 6239 Other Repair & Maintenance 8L $ 606 $ 2,988 $ 3,000 $ 1,259 $ 3,000 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ 266 $ 500 $ 112 $ 500 6242 Minor Equip $ 953 $ 90 SUBTOTAL SUPPLIES $ 10,413 $ 15,602 $ 18,750 $ 6,901 $ 20,100 $ - $ • Obi Description -49251 2000 2001 2002 2002 2003 2003 2003 • Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs $ 1,275 $ 1,671 $ 1,300 $ 1,195 $ 1,300 6302 Arch, Eng and Planning 6303 Legal 6305 Medical Svs 6306 Personnel /Labor Relations 6307 Professional Svs $ 500 $ 500 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager $ 1,523 $ 1,574 $ 1,850 $ 99 $ 1,850 6322 Postage $ 5,215 $ 5,469 $ 5,500 $ 2,368 $ 5,500 6323 Radio Communications 6329 Other Communication Svs $ 516 TRANSPORTATION 6331 Travel Expense/Mileage $ 5 6332 Contracted Transportation 6333 Freight/Drayage 6339 Other Transporation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising PRINTING/DUPLICATING 6351 Printing Svs $ 1,222 6352 Micro-filming Svs INSURANCE 6351 General Liability $ 5,646 $ 6,863 $ 7,000 $ 2,087 $ 7,630 6362 Property Damage $ 255 $ 289 $ 300 $ 87 $ 330 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown $ 61 $ 66 $ 80 $ 19 $ 90 • 6367 Equipment (Inland Marine) 6368 Bonds 6369 Otherinsurance UTILITY SERVICES 6381 Electric $ 23,985 $ 26,766 $ 25,000 $ 9,969 $ 26,000 6382 Gas 6383 Water 6384 Refuse Disposal 6385 Sewer 6386 Storm Sewer 6387 Heating Oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs $ 1,348,709 $ 1,377,544 $ 1,400,000 $ 702,485 $ 1,440,000 REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs $ 38 6403 Buildings and Facilities Maint S $ 128 $ 903 $ 3,600 $ 2,857 $ 3,600 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communication/Information Sve $ 378 $ 500 $ 414 $ 500 6409 Other Repair and Maint Svs $ 80,000 RENTALS 6411 Land 6412 Buildings /Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Exp • Obi Description-49251 2000 2001 2002 2002 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Recommend Adopt SERVICES /LICENSES/FEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges $ 24,926 $ 27,314 $ 28,610 $ 11,783 $ 27,686 6428 Protection Svs MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ 925 $ 863 $ 1,200 $ 1,300 $ 1,200 6433 Meeting Exp 6434 Dues and Subscriptions 6435 Credit Card Fees 6436 Uncollectible Checks 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees $ 124 $ 125 $ 2 $ 125 6442 Court Awards /Settlements $ 1,000 6443 Prize Awards /Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges - Prisioner 6449 Other Contractual Svs $ 12,359 $ 19,851 $ 12,500 $ 5,434 $ 12,500 CENTRAL GARAGE CHARGES - 6461 Fuel Charges $ 7,573 $ 8,329 $ 7,965 $ 2,545 $ 8,204 6462 Fixed Charges $ 35,140 $ 34,116 $ 38,720 $ 17,786 $ 39,882 6463 Repair and Maint Charges $ 21,477 $ 21,728 $ 22,074 $ 17,001 $ 22,736 6464 Multi -use Charges 6465 Replacement Charges $ - TRANSFERS AND OTHER USES 6471 Administrative Service Transfer $ 86,128 $ 91,236 $ 93,402 $ 46,698 $ 106,014 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out • 6475 Contingency 6476 Special Assessment Transfer -Out 6477 Capital Project Transfer -Out ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales - Taxable 5585 Other Cost of Sales- Nontaxable 5586 Cost of Sales -Misc 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTS /EXPENSES 6491 Merchandise- Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales- Banquest Exp 6494 Depreciation Exp $ 213,401 $ 239,381 $ 250,148 $ 432,100 5591 Contractor Pmts - Personal Svs 5593 Contractor Pmts - Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 1,790,266 $ 1,866,206 $ 1,899,874 $ 824,629 $ 2,217,247 OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements $ 1,284,591 $ 500,911 $ 1,396,315 $ 726,300 $ 631,790 6540 Equip and Machinery $ 10,691 6550 Motor Vehicles - 6560 Furniture 6570 Office Equip 6580 Information Systems $ 1,600 6590 Leases • SUBTOTAL CAPITAL $ 1,295,282 $ 500,911 $ 1,396,315 $ 726,300 $ 633,390 $ - $ - OUTLAY ON DescriptionA9251 2000 2001 2002 2002 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal INTEREST 6611 Bond Interest 6612 Other Debt Interest AGENT /ISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ - $ - $ _ $ _ $ _ $ - $ SERVICE TOTAL BUDGET -49251 $ 3,215,125 $ 2,515,906 $ 3,440,091 $ 1,641,095 $ 2,991,000 $ - $ • • • 3c • • Storm Sewer Utility Fund • • I • Storm Sewer Utility Fund Rate Analysis 2002 2003 2004 2005 2006 2007 Revenues Storm Sewer Fees $ 1,196,000 $ 1,235,000 $ 1,274,000 $ 1,313,000 $ 1,352,000 $ 1,391,000 Misc. Operating $ - $ _ $ _ $ _ $ _ $ _ Misc. Non - operating $ 15,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Revenues $ 1,211,000 $ 1,245,000 $ 1,284,000 $ 1,323,000 $ 1,362,000 $ 1,401,000 Expenditures Personal Services $ _ $ _ $ _ $ _ $ _ $ _ Supplies $ 500 $ 10,500 $ 10,815 $ 11,139 $ 11,474 $ 11,818 Services $ 157,407 $ 226,484 $ 233,279 $ 240,277 $ 247,485 $ 254,910 Depreciation $ 182,695 $ 326,600 $ 335,000 $ 344,000 $ 353,000 $ 362,000 Debt Service $ 240,850 $ 239,540 $ 238,250 $ 236,210 $ - $ - Total Expenditures $ 581,452 $ 803,124 $ 817,344 $ 831,626 $ 611,959 $ 628,728 Capital Outlay $ 1,154,790 $ 410,785 $ 455,810 $ 456,845 $ 331,930 $ 464,060 Total Cash Requirements $ 1,736,242 $ 1,213,909 $ 1,273,154 $ 1,288,471 $ 943,889 $ 1,092,788 Cash Reserve Target $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 Beginning Cash Balance $ (21,315) $ (363,862) $ (6,171) $ 339,675 $ 718,204 $ 1,489,315 Revenues $ 1,211,000 $ 1,245,000 $ 1,284,000 $ 1,323,000 $ 1,362,000 $ 1,401,000 Expenditures $ (1,736,242) $ (1,213,909) $ (1,273,154) $ (1,288,471) $ (943,889) $ (1,092,788) Depreciation Add -back $ 182,695 $ 326,600 $ 335,000 $ 344,000 $ 353,000 $ 362,000 • Ending Cash Balance $ (363,862) $ (6,171) $ 339,675 $ 718,204 $ 1,489,315 $ 2,159,528 Additional Sums Necessary $ 546,171 $ 200,325 None None None to Meet Cash Requirements Current 2003 2004 2005 2006 2007 Assume a 3% Increase $ 46.00 $ 47.50 $ 49.00 $ 50.50 $ 52.00 $ 53.50 Storm Sewer Fees $ 1,196,000 $ 1,235,000 $ 1,274,000 $ 1,313,000 $ 1,352,000 $ 1,391,000 Cash Balances $ (363,862) $ (6,171) $ 339,675 $ 718,204 $ 1,489,315 $ 2,159,528 To sustain a $540,000 cash balance, a 3% rate increase would meet the requirement in 2005. Note: The Storm Sewer Utility Fund had net accounts receivables of $258,909 and a due to the Water Utility Fund of $21,315 as of December 31, 2001. Assumptions: Cash basis All assumptions are predicated on Cash Basis presentation. Revenues Rate increases would be 3% per year across the board based on the current rates and charges.O23 All other revenues would remain flat over the five year period. Expenditures Personal services increase at a total rate of 5% per annum. Supplies, Services increase at a total rate of 3% per annum. • Depreciation increases at a rate of approximately 3% per annum. Capital outlay is from the CIP for each year in the five year period. CITY OF BROOKLYN CENTER FUND 65100 • PROPRIETARY FUNDS -STORM SEWER UTILITY STORM SEWER dmilTY„ 3 „ q _ .,,_.•'.. ; 2003 BUDGET 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Operating Statement Revenues Operating Revenues Stone Sewer Fees $ 1.074.619 $ 1 129.502 $ 1 196.000 $ 611195 $ 1.235.000 $ $ - Subtotal Operating Revenues $ 1,074,619 $ 1,129,502 $ 1,196,000 $ 611,195 $ 1,235,000 $ - $ Non- operating Revenues Investment Earnings $ - $ 10,375 $ 15,000 $ - $ 10,000 $ - $ - Other Revenue $ 313,069 $ - Subtotal Non - operating Revenues $ 313,069 $ 10,375 $ 15,000 $ - $ 10,000 $ - $ - Total Revenues $ 1,387,688 $ 1,139,877 $ 1,211,000 $ 611,195 $ 1,245,000 $ - $ Cost of Goods Sold $ $ _ Gross Profit $ 1,387,688 $ 1,139.877 $ 1.211.000 $ 611,195 $ 1,245,000 $ - $ - 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Expenses Operating Expenses Other Expenses /Uses Wages and Salaries $ - $ 808 $ - $ - $ - Fringe Benefits $ - $ 85 $ $ - $ - Supplies $ 475 $ - $ 500 $ 1,276 $ 10,500 Services $ 153,834 $ 191,182 $ 157,407 $ 91,740 $ 226,484 Depreciation Expense $ 153,206 $ 170,302 $ 182,695 $ - $ 326,600 Capital Outlay $ 1,095,165 $ 845,165 $ 1,154,790 $ - $ 410,785 Debt Service $ 239,018 $ 243,276 $ 240,850 $ 222,701 $ 239,540 Total Operating Expenses $ 1,641,698 $ 1,450,818 $ 1,736,242 $ 315,717 $ 1,213,909 And Other Expenses/Uses • Net Income $ (254,010) $ (310.941) $ (525,242) $ 295 $ 31.091 $ - $ Beginning Cash Balance January 1 $ 240,607 $ (83,636) $ (21,315) $ (363,862) Net Income $ (254,010) $ (310,941) $ (525,242) $ 31,091 Add Back Depreciation Expense $ 153,206 $ 170,302 $ 182,695 $ 326,600 Other Cash ReaBed Activities $ (223,439) $ 202,960 Ending Cash Balance December 31 $ (83,636) $ (21,315) $ (363,862) $ - $ (6,171) $ - $ - • • CITY OF BROOKLYN CENTER FUND 65100 5 ?OFtM.SEtNERll_ REVENUE -2003 Page 1 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt MISCELLANEOUS REVENEUE 4600 Miscellaneous Revenue 4601 Special Assess - Principal $ 310,588 $ 268,794 4602 Special Assess- Penalties and Ir $ 2,481 $ 1,570 4603 Interest Earnings $ 10,375 $ 15,000 $ 10,000 4604 Check Processing Fee 4605 Gain or Loss on Inventory 4606 Misc Revenue not Otherwise Cl Subtotal Miscellaneous Revenue $ 313,069 $ 280,739 $ 15,000 $ - $ 10,000 $ - $ - ENTERPRISE FUND REVENUES 4700 Enterprise Fund Revenues 4731 Strm Sewer -Stns Sewer Fees $ 1,074,619 $ 1,129,502 $ 1,196,000 $ 611,195 $ 1,235,000 $ - $ - Subtotal Storm Sewer Utility- Operations $ 1,074,619 $ 1,129,502 $ 1,196,000 $ 611,195 $ 1,235,000 $ $ - TOTAL REVENUE AND $ 1,387,688 $ 1,410,2 $ 1,211.000 $ 6 11,195 $ 1,245,000 $ - $ - OTHER SOURCES • • City of Brook& Center • 2003 Budget gt DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Storm Sewer Utility Fund - 65100 DEPT /ACTIVITY/PROJECT: Operations - 49411 PROFILE This division provides for the collection of stormwater throughout the city. Stormwater is either conveyed to a regional or neighborhood treatment facility such as a pond and then outletted to a surface water, or it is conveyed directly to the surface water. The division is managed by the Public Works Director. The City has 84 miles of storm sewers and nine neighborhood or regional pond or treatment systems. Included in this division is the inspection and maintenance of all structures and lines, preventative maintenance, reimbursement for street sweeping services provided by the street maintenance division, and inspection of private stormwater treatment systems. Also included is the City's participation in two joint powers Watershed Commissions, which provide for regional planning, surface water quality monitoring, and Wetlands Conservation Act compliance. • DEPARTMENTAL GOALS, * Televise all lines in next year's construction projects and approximately an additional 2,000 feet of trouble spots and the next area of scheduled cleaning. * Repair structures (approximately 30 to 40 per year) that are in need of repair or rebuilding now and scheduled cycle of repair. * Clean 8,000 feet of storm sewer lines of sand, debris and roots. * Clean outfalls, skimmers, and ponds as needed. * Inspect public and private ponds and treatment systems. EXPENDITURE DETAILS 6413 Dues & Subscriptions $42,700 Annual dues of the Shingle Creek and West Mississippi Watershed Management Organizations. PERSONNEL LEVELS No personnel are currently assigned to this utility. Work is currently done by street and utility staff and is reimbursed through an administrative transfer. CAPITAL OUTLAY • Item • Happy Hollow Neighborhood Project Qty: 1 Unit Cost: $253,255 Less Trade -in: $ -0- Total Cost: $253,255 Twin Lakes Study Qty: 1 Unit Cost: $65,000 Less Trade -in: $ -0- Total Cost: $65,000 73` Avenue Project Qty: 1 Unit Cost: $42,350 Less Trade -in: $ -0- Total Cost: $42,350 TH #100 Utility Movement Qty: 1 Unit Cost: $50,000 Less Trade -in: $ -0- Total Cost: $50,000 • • • CITY OF BROOKLYN CENTER FUND 65100 STORM SEWER FUND DEPTIDIV NO.: d9b'l1 Obj Description -49411 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONAL SVS WAGES AND SALARIES 6101 Wages and Salaries -FT Emp $ - $ 262 6102 Overtime -FT Emp $ - $ _ 6103 Wages and Salaries -PT Emp $ - $ 546 6104 Overtime -PT Emp $ - $ _ 6106 Wages and Salaries -Temp Emr $ - $ - 6107 Commissions & Boards $ - $ _ OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord $ 14 6123 PERA -FT Emp -Pol &Fire 5124 PERA- Defined Contribution 6125 PICA- Medicare $ 62 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions OTHER PAYMENTS 6141 Unemployment Comp OTHER INSURANCE 6151 Workers Comp Ins $ 9 SUBTOTAL PERSONAL $ - $ 893 $ - $ - $ - $ - $ _ SVS 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt SUPPLIES OFFICE SUPPLIES 6201 Office Supplies $ 1,073 • 6202 Copying Supplies 6203 Books /Reference Materials 6204 Stationary Supplies OPERATING SUPPLIES 6211 Cleaning Supplies 6212 Motor Fuels 6213 Lubricants and Additives 6214 Clothing and Personal Equip 6215 Shop Materials 6216 Chemicals /Chemical Products 6217 Safety Supples 6218 Welding Supplies 6219 General Operating Supplies $ 213 $ 500 $ 203 $ 500 REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities 6224 Street Maint Materials 6225 Park & Landsacpe Materials 6226 Sign & Striping Materials 6227 Paint Supplies 6231 Athletic Field Supplies 6232 Traikvay Supplies 6233 Court Supplies 6235 Utlity System Supplies 6236 DARE Supplies 6237 Laundry Supplies 6239 Other Repair & Maintenance Sup $ 10,000 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools 6242 Minor Equip $ 262 SUBTOTAL SUPPLIES $ 475 $ - $ 500 $ 1,276 $ 10,500 $ • • Obj Descriptlon49411 2000 2001 2002 2002 2003 2003 2003 Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs 6302 Arch, Eng and Planning $ 7,000 6303 Legal 6305 Medical Svs 6306 Personnel/Labor Relations 6307 Professional Svs $ 250 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone/Pager 6322 Postage 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Expense /Mileage 6332 Contracted Transportation 6333 Frerght/Drayage 6339 Other Transporation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising PRI NTI NGIDU PLI CATI NG 6351 Printing Svs 6352 Micro- filming Svs INSURANCE 6361 General Liability $ 2,646 $ 3,604 $ 3,200 $ 1,121 $ 3,500 6362 Property Damage 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown • 6367 Equipment (Inland Marine) 6388 Bonds 6369 Otherinsurance UTILITY SERVICES 6381 Electric 6382 Gas 6383 Water 6384 Refuse Disposal 6385 Sewer 6386 Storm Sewer 6387 Heating Oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 5401 Motor Vehicles Svs 6402 Equipment Svs 6403 Buildings and Facilities Maint Svs 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communication/information Svs 6409 Other Repair and Maint Svs $ 2,000 RENTALS 6411 Land 6412 Buildings /Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Exp • • Obj Description -49411 2000 2001 2002 2002 2003 2003 2003 Page 3 Actual Actual Budget To Date Request Recommend Adopt SERVICES/LICENSES/FEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges 6428 Protection Svs MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools 6433 Meeting Exp 6434 Dues and Subscriptions $ 30,061 $ 29,667 $ 31,000 $ 30,249 $ 42,700 6435 Credit Card Fees 6436 Uncollectible Checks 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees 6442 Court Awards /Settlements 6443 Prize Awards /Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges- Pnsioner 6449 Other Contractual Svs $ 126 $ 150 CENTRAL GARAGE CHARGES 6461 Fuel Charges $ 2,114 $ 2,033 $ 1,825 $ 761 $ 1,880 6462 Fixed Charges $ 14,815 $ 14,991 $ 14,311 $ 6,973 $ 14,740 6463 Repair and Maint Charges $ 4,072 $ 5,887 $ 6,921 $ 2,390 $ 7,130 6464 Multi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer $ 100,000 $ 100,000 $ 100,000 $ 147,534 6472 Engineering Service Transfer -in 6473 Storm Sewer Transfer -Out $ 49,996 6474 Debt Service Transfer -Out • 6475 Contingency 6476 Special Assessment Transfer -Out 6477 Capital Project Transfer -Out $ 35,000 ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales - Taxable 5585 Other Cost of Sales - Nontaxable 5586 Cost of Sales -Misc 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTS /EXPENSES 6491 Merchandise - Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp 6494 Depreciation Exp $ 153,206 $ 170,302 $ 182,695 $ 326,600 5591 Contractor Pmts - Personal Svs 5593 Contractor Pmts - Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 307,040 $ 361,484 $ 340,102 $ 91,740 $ 553,084 $ OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements $ 1,093,363 $ 845,165 $ 1,154,790 $ 410,785 6540 Equip and Machinery 6550 Motor Vehicles 6560 Furniture 6570 Office Equip $ 1,802 6580 Information Systems 6590 Leases • SUBTOTAL CAPITAL $ 1,095,165 $ 845,165 $ 1,154,790 $ - $ 410,785 $ - $ - OUTLAY • Obj Description49411 2000 2001 2002 2002 2003 2003 2003 Page 4 Actual Actual Budget To Date Request Recommend Adopt DEBT SERVICE PRINCIPAL 6601 Bond Principal $ 180,000 $ 190,000 $ 200,000 $ 200,000 $ 210,000 6602 Other Debt Principal INTEREST 6611 Bond Interest $ 58,268 $ 52,416 $ 40,100 $ 22,600 $ 28,790 6612 Other Debt Interest AGENTIISSUE FEES 6621 Agent Fees $ 750 $ 860 $ 750 $ 101 $ 750 6622 Issue Fees SUBTOTAL DEBT $ 239,018 $ 243,276 $ 240,850 $ 222,701 $ 239,540 $ - $ - SERVICE TOTAL BUDGET49411 $ 1,641,698 $ 1,450,818 $ 1,736,242 $ 315,717 $ 1,213,909 $ - $ - • • ST DRAINAGE' UTILITY TE STUDY: 200 10- Oct -01 budge toff 1 r '�S a , .}•! tea, �'._ : F?F „ o:.,3. tt.t �. , d. Start of Year Cash &Investments �� :!.;.� 13.1`�4:'I�< :'y.., 496' 27L `;�<i�:- -, �fi��'51;t. 4.7��599 s��� 695` °. r :1'`1.7fi�293' W . r $. ..!- •._....: :n ":� 3'.:_..,.� -.�r �� .._....A_..__.,. �:�..,1..r...,... , "- ��ix.�... ..._. .r_.: ...1•......1... .. EXPENDITURES Operations Personal Service $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 Contractual Service 56,879 54,057 56,003 58,019 60,108 62,272 Supplies & Materials 500 650 1,100 1,200 1,200 1,300 Utilitiesllnsurance 3,200 3,200 3,315 3,435 3,558 3,686 Depreciation 164,902 182,695 180,000 190,000 200,000 200,000 TOTAL EXPENDITURES $325,481 $340,602 $340,418 $352,654 $364,866 $3 REVENUES Billing Revenues $1,118,000 $1,196,000 $1,196,000 $1,196,000 $1,196,000 $1,118,000 Change in Fair market value Miscellaneous Operating 0 0 0 0 0 0 Miscellaneous Non - operating 2,500 2,500 2,500 2,500 2,500 2,500 TOTAL REVENUES $1,120,500 $1,198,500 $1,198,500 $1,198,500 $1,198,500 $1,120,500 Net Income or Loss $795,019 $857,898 $858,082 $845,846 $833,634 $753,242 Depreciation Add -Back $164,902 I $182,695 I $180,000 $190,000 $200,000 $200,000 5.:: • . Ilabl. ':C r 4 :: l.�Va ...... �....a tta ..�.. n� .1... pia .............. ..........................$..5� 9:�1...........$� ��q 5�3; s��:��p38 °Qt3�:::::�� 0�5���6 € €;• .� ° ©�3 ��..•........�:�..� �.. �.. 0: =0 ON ? Qqq Non Operating Expenditures .. .. .............. .. . . .._..._................._.._. _,__ ................-.. ............_.................. - Capital Outlay $360,331 $1,154,790 $495,785 $601,845 $350,070 $690,920 Debt Service $240,850 $240,850 $240,540 $239,250 $237,210 Non Operating Revenues Interest Earnings $6,571 $24,836 $8,326 $23,830 $34,759 $58,815 Total Net Effect on Fund Balance $365,311 ($330,211) $310,083 $218,581 $481,113 $321,137 End of Year Cash & Investments ..,$.:. �. � - .$'fi: 7 ` `�= z��$,; z , >H�-= '��:$69 $�-`1�.' �:�, �7=d30• -7r. � ::::.. .. .. ... ... ... .'•z.':ir,, v ..1. >._. -.. 'L d? 1. ..,..l.,. -_ _ _ .a _ .. :�... ....a- _•r,.r. , J - .�h.:r�., n1 rf LV:�e v. u,.r_rl:. For Information Proposed Cash Balance Target $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 AN, '..• erlot $10.75 $11.50 $11.50 $11.50 $ ' ........ Residential rat ................. ......... .......... .......... .......... ......... .•�:o:•:5: e p 11.50 $ .7 Schools & govt buildings per acre $53.75 $57.50 $57.50. $57.50 $57.50 $53.75 Multiple family & churches per acre $129.00 $138.00 $138.00 $138.00 $138.00 $129.00 Commercial and Industrial per acre $215.00 $230.00 $230.00 $230.00 $230.00 $215.00 • 3d 1 • • Street Light Utility Fund • • • Street Light Utility Fund Rate Analysis 2002 2003 2004 2005 2006 2007 Revenues Street Light Fees $ 203,704 $ 209,807 $ 216,011 $ 222,322 $ 228,714 $ 235,213 Misc. Operating $ _ $ _ $ _ $ _ $ _ $ _ Misc. Non- operating $ 500 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Revenues $ 204,204 $ 219,807 $ 226,011 $ 232,322 $ 238,714 $ 245,213 Expenditures Personal Services $ _ $ _ $ _ $ _ $ _ $ _ Supplies $ _ $ _ $ - $ $ $ Services $ 146,000 $ 148,234 $ 152,681 $ 157,261 $ 161,979 $ 166,839 Depreciation $ _ $ _ $ _ $ _ $ _ $ Debt Service $ - $ _ $ _ $ _ $ $ Total Expenditures $ 146,000 $ 148,234 $ 152,681 $ 157,261 $ 161,979 $ 166,839 Capital Outlay $ - $ 51,090 $ 86,820 $ 85,370 $ 59,315 $ 73,270 Total Cash Requirements $ 146,000 $ 199,324 $ 239,501 $ 242,631 $ 221,294 $ 240,109 Cash Reserve Target $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Beginning Cash Balance $ - $ 58,204 $ 78,687 $ 65,197 $ 54,887 $ 72,307 Revenues $ 204,204 $ 219,807 $ 226,011 $ 232,322 $ 238,714 $ 245,213 Expenditures $ (146,000) $ (199,324) $ (239,501) $ (242,631) $ (221,294) $ (240,109) Depreciation Add -back $ _ $ _ $ _ $ _ $ - $ • Ending Cash Balance $ 58,204 $ 78 $ 65,197 $ 54,887 $ 72,307 $ 77,411 Additional Sums Necessary $ (28,687) $ (15,197) $ (4,887) $ (22,307) $ (27,411) to Meet Cash Requirements Assume a 3% Increase Current 2003 2004 2005 2006 2007 Residential -per unit annual $ 12.00 $ 12.36 $ 12.72 $ 13.08 $ 13.44 $ 13.80 All others users $ 190.94 $ 196.65 $ 202.55 $ 208.65 $ 214.90 $ 221.35 Total Fees $ 203,704 $ 209,807 $ 216,011 $ 222,322 $ 228,714 $ 235,213 Street Light Fees $ 203,704 $ 209,807 $ 216,011 $ 222,322 $ 228,714 $ 235,213 Cash Balances $ 58,204 $ 78,687 $ 65,197 $ 54,887 $ 72,307 $ 77,411 To sustain a $50,000 cash balance, a rate increase in excess of 3% would be required. Assumptions: Cash basis All assumptions are predicated on Cash Basis presentation. Revenues Rate increases would be 3 %/ year across the board based on customer base of 8,415 residential customers and 538 others All other revenues would remain flat over the five year period. Expenditures Personal services increase at a total rate of 5% per annum. Supplies, Services increase at a total rate of 3% per annum. Depreciation increases at a rate of approximately 3% per annum. • Capital outlay is from the CIP for each year in the five year period. CITY OF BROOKLYN CENTER FUND 65200 • PROPRIETARY FUNDS - STREET LIGHT FUND 2003 BUDGET x 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Operating Statement Revenues Operating Revenues Street Light User Fees $ 203.704 $ 98,159 $ 209,807 $ - $ - Subtotal Operating Revenues $ - $ - $ 203,704 $ 98,159 $ 209,807 $ - $ - Non- operating Revenues Investment Earnings $ 500 $ - $ 10,000 $ - $ _ Subtotal Non - operating Revenues $ - $ - $ 500 $ - $ 10,000 $ - $ Total Revenues $ - $ - $ 204,204 S 98,159 $ 219,807 $ - $ Cost of Goods Sold $ _ $ - $ $ _ $ $ $ Gross Profit $ - $ - $ 204.204 $ 98,159 $ 219,807 $ - $ 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt Expenses Operating Expenses Other Expenses /Uses Wages and Salaries $ 15 $ - $ _ $ - $ _ $ _ $ - Fnnge Benefits $ 2 $ _ $ - $ $ $ $ Supplies $ . $ - $ $ $ $ $ Services $ 137,834 $ 138,101 $ 146,000 $ 58,027 $ 148,234 $ - $ Depreciation Expense $ _ $ - $ - $ $ $ $ Capital Outlay $ _ $ $ _ $ - $ 51,090 $ - $ i Debt Service $ _ $ _ $ - $ - $ $ $ Total Operating Expenses $ 137,851 $ 138,101 $ 146,000 S 58,027 $ 199.324 $ - $ And Other Expenses/Uses • Net Income $ 58,204 $ 20,483 $ - $ Beginning Cash Balance January 1 $ _ $ 58,204 Net Income $ 58,204 $ 20,483 Add Back Depreciation Expense $ - $ - Other Cash Realted Activities Ending Cash Balance December 31 $ 58,204 $ 78,687 CITY OF BROOKLYN CENTER FUND 65200 • STREETLIGHT UTILtTY.FUND ,R, •: ..;`- REVENUE -2003 Page 1 2000 2001 2002 2002 2003 2003 2003 MISCELLANEOUS REVENEEE Actual Actual Budget To Date Request Recommend Adopt 4600 Miscellaneous Revenue 4601 Special Assess - Principal 4602 Special Assess - Penalties and I, 4603 Interest Earnings $ 500 $ 10,000 4604 Check Processing Fee - 4605 Gain or Loss on Inventory 4606 Misc Revenue not Otherwise Cl $ - $ _ $ _ $ _ Subtotal Miscellaneous Revenue $ - $ - $ 500 $ - $ 10,000 $ - $ ENTERPRISE FUND REVENUES 4700 Enterprise Fund Revenues Utility Funds 4741 Street Light User Fees $ 203,704 $ 98,159 $ 209,807 Subtotal Street Light - Operations $ - $ - $ 203.704 $ 98,159 $ 209,607 $ - $ _ TOTAL REVENUE AND $ - $ - $ 204 204 $ 98.159 $ 219,807 $ - $ OTHER SOURCES • City of Brookfyn Center • 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Street Light Utility Fund - 65200 DEPT /ACTIVITY/PROJECT: Street Lights - 49571 PROFILE This division provides primarily for electrical and maintenance fees paid to NSP for street lights owned by NSP. It also provides for electrical service, maintenance, repair, and replacement of lights owned by the City. The City owns approximately 75 ornamental lights, primarily in the Earle Brown commercial area, and leases about 915 lights from NSP. Another 97 lights owned by the City are located on traffic signal posts and mast arms. DEPARTMENTAL GOALS * The City's street light policy provides for at least one street light per intersection and at curves and major driveway entrances. Mid -block street lights are installed by petition when the distance between intersections is greater than 700 feet. • EXPENDITURE 6381 Utility Service- Electric $140,000 Electric utility costs for street lights. PERSONNEL LEVELS None requested. CAPITAL OUTLAY Item Happy Hollow Neighborhood Project g J Qty: 1 Unit Cost: $51,090 Less Trade -in: $ -0- Total Cost: $51,090 • CITY OF BROOKLYN CENTER FUND 65200 • STREET LIGHT UTILITY FUND 'STREE DEPT /DIV NO.: ,• •m:�:- „ , �+tliSi• 3`LIGH7' Obi Description -49571 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONAL SVS WAGES AND SALARIES 6101 Wages and Salaries -FT Emp $ 15 6102 Overtime -FT Emp 6103 Wages and Salaries -PT Emp 6104 Overtime -PT Emp 6106 Wages and Salaries -Temp Emp 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord $ 1 6123 PERA -FT Emp -Pot &Fire 6124 PERA- Defined Contribution 6125 FICA- Medicare $ 1 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions OTHER PAYMENTS 6141 Unemployment Comp OTHERINSURANCE 6151 Workers Comp Ins SUBTOTAL PERSONAL $ 17 $ _ $ _ $ - $ - $ - $ - SVS 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt SUPPLIES OFFICE SUPPLIES 6201 Office Supplies 6202 Copying Supplies • 6203 Books /Reference Materials 6204 Stationary Supplies OPERATING SUPPLIES 6211 Cleaning Supplies 6212 Motor Fuels 6213 Lubricants and Additives 6214 Clothing and Personal Equip 6215 Shop Materials 6216 Chemicals /Chemical Products 6217 Safety Supples 6218 Welding Supplies 8219 General Operating Supplies REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities 6224 Street Maint Materials 6225 Park & Landsacpe Materials 6226 Sign & Striping Materials 6227 Paint Supplies 6231 Athletic Field Supplies 6232 Trailway Supplies 6233 Court Supplies 6235 Utlity System Supplies 6236 DARE Supplies 6237 Laundry Supplies 6239 Other Repair & Maintenance Sup SMALL TOOLS AND MINOR EQUIP 6241 Small Tools 6242 Minor Equip SUBTOTAL SUPPLIES $ _ $ - $ - $ _ $ $ - $ Obj Description-49571 2000 2001 2002 2002 2003 2003 2003 • Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs 6302 Arch, Eng and Planning 6303 Legal 6305 Medical Svs 6306 Personnel/Labor Relations 6307 Professional Svs $ 250 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager 6322 Postage 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Expense /Mileage 6332 Contracted Transportation 6333 Freight/Drayage 6339 Other Transporation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising PRINTING /DUPLICATING 6351 Printing Svs 6352 Micro - filming Svs INSURANCE 6361 General Liability 6362 Property Damage 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown 6367 Equipment (Inland Marine) • 6368 Bonds 6369 Other insurance UTILITY SERVICES 6381 Electric $ 136,877 $ 138,101 $ 140,000 $ 56,497 $ 140,000 6382 Gas 6383 Water 6384 Refuse Disposal 6385 Sewer 6386 Storm Sewer 6387 Heating Oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT U71ITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehides Svs 6402 Equipment Svs $ 595 $ 1,000 6403 Buildings and Facilities Maim Svs 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communicetionflnformation Svs 6409 Other Repair and Maint Svs $ 362 $ 5,000 $ 1,280 RENTALS 6411 Land 6412 Buildings/Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Exp Obj Description -49571 2000 2001 2002 2002 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Recommend Adopt SERVICES /LICENSESIFEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges 6428 Protection Svs MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools 6433 Meeting Exp 6434 Dues and Subscriptions 6435 Credit Card Fees 6436 Uncollectible Checks 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees 6442 Court Awards /Settlements 6443 Prize Awards /Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges- Prisioner 6449 Other Contractual Svs CENTRAL GARAGE CHARGES 6461 Fuel Charges 6462 Fixed Charges 6463 Repair and Maint Charges 6464 Mulfi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -In $ 8,234 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out • 6475 Contingency 6476 Special Assessment Transfer -Out 6477 Capital Project Transfer -Out ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales - Taxable 5585 Other Cost of Sales - Nontaxable 5586 Cost of Sales -Mist 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise- Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales- Banquest Exp 6494 Depreciation Exp 5591 Contractor Pmts - Personal Svs 5593 Contractor Pmts - Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 137,834 $ 138,101 $ 146,000 $ 55,027 $ 148,234 $ - $ - OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements $ 51,090 6540 Equip and Machinery 6550 Motor Vehicles 6560 Furniture 6570 Office Equip _ 6580 Information Systems 6590 Leases SUBTOTAL CAPITAL $ - $ - $ - $ - $ 51,090 $ - $ • OUTLAY Obj Description49571 2000 2001 2002 2002 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal INTEREST 6611 Bond Interest 6612 Other Debt Interest AGENTIISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ _ $ _ $ - $ _ $ _ $ $ SERVICE TOTAL BUDGET49571 $ 137,851 $ 138,101 $ 146,000 $ 58,027 $ 199,324 $ - $ - • • 3e • Reeycling Utility Fund • • Recycling Utility Fund Rate Analysis • 2002 2003 2004 2005 2006 2007 Revenues Recycling Fees $ 211,000 $ 223,839 $ 227,205 $ 230,571 $ 233,937 $ 237,303 Misc. Operating $ _ $ _ $ _ $ _ $ Misc. Non - operating $ 2,498 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Revenues $ 213,498 $ 233,839 $ 237,205 $ 240,571 $ 243,937 $ 247,303 Expenditures Personal Services $ _ $ $ _ $ _ $ _ $ Supplies $ _ $ $ _ $ _ $ $ Services $ 213,498 $ 222,130 $ 228,794 $ 235,658 $ 242,727 $ 250,009 Depreciation $ _ $ _ $ _ $ _ $ $ Debt Service $ _ $ _ $ _ $ _ $ $ Total Expenditures $ 213,498 $ 222,130 $ 228,794 $ 235,658 $ 242,727 $ 250,009 Capital Outlay $ _ $ _ $ _ $ _ $ _ $ Total Cash Requirements $ 213,498 $ 222,130 $ 228,794 $ 235,658 $ 242,727 $ 250,009 Cash Reserve Target $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 Beginning Cash Balance $ 56,045 $ 56,045 $ 67,754 $ 76,165 $ 81,078 $ 82,288 Revenues $ 213,498 $ 233,839 $ 237,205 $ 240,571 $ 243,937 $ 247,303 Expenditures $ (213,498) $ (222,130) $ (228,794) $ (235,658) $ (242,727) $ (250,009) Depreciation Add -back $ _ $ _ $ _ $ _ $ $ Ending Cash Balance $ 56,045 $ 67,754 $ 76,165 $ 81,078 $ 82,288 $ 79,582 • Additional Sums Necessary None None None None None to Meet Cash Requirements Current 2003 2004 2005 2006 2007 User Fee Recylcing $ 6.45 $ 6.65 $ 6.75 $ 6.85 $ 6.95 $ 7.05 Total Fees $ 203,704 $ 223,839 $ 227,205 $ 230,571 $ 233,937 $ 237,303 User Fees Recycling $ 203,704 $ 223,839 $ 227,205 $ 230,571 $ 233,937 $ 237,303 Cash Balances $ 56,045 $ 67,754 $ 76,165 $ 81,078 $ 82,288 $ 79,582 To sustain a $25,000 cash balance, a rate increase of less than 3% would be required. Assumptions: Cash basis All assumptions are predicated on Cash Basis presentation. Revenues Rate increases would be 3% per year across the board based on customer base of 8,415 residential customers. All other revenues would remain flat over the five year period. Expenditures Personal services increase at a total rate of 5% per annum. Supplies, Services increase at a total rate of 3% per annum. Depreciation increases at a rate of approximately 3% per annum. • Capital outlay is from the CIP for each year in the five year period. CITY OF BROOKLYN CENTER FUND 653011 • PROPRIETARY FUNDS-RECYCLING „ 2003 BUDGET 2000 2001 2002 2002 2003 2003 2003 Operating Statement Actual Actual Budget To Date Request Recommend Adopt Revenues Operating Revenues Recycling Charges $ 210,168 $ 211,388 $ 211,000 $ 105,699 $ 223,839 Subtotal Operating Revenues $ 210,168 $ 211,388 $ 211,000 $ 105,699 $ 223,839 $ - $ Non - operating Revenues Investment Earnings $ 2,704 $ 3,589 $ 2,498 $ - $ 10,000 $ _ $ _ Subtotal Non - operating Revenues $ 2,704 $ 3,589 $ 2,498 $ - $ 10,000 $ - $ Total Revenues $ 212,872 $ 214,977 $ 213,498 $ 105,699 $ 233,839 $ - $ _ Cost of Goods Sold $ $ $ $ $ $ $ Gross Profit $ 212,872 $ 214.977 $ 213,498 $ 233,839 $ $ 2000 2001 2002 2002 2003 2003 2003 Expenses Actual Actual Budget To Date Request Recommend Adopt Operating Expenses Other Expenses/Uses Wages and Salaries $ _ $ - $ $ $ $ $ Fringe Benefits $ - $ $ $ $ $ $ Supplies $ - $ $ - $ - $ Services $ 214,889 $ 214,989 $ 213,498 $ - $ 222,130 $ _ $ Depreciation Expense $ - $ $ $ $ $ $ Capital Outlay $ _ $ $ $ $ $ $ - Debt Service $ _ $ $ $ $ $ $ Total Operating Expenses $ 214,889 $ 214 989 $ 213 498 S - $ 222,130 $ - $ And Other Expenses/Uses , Net Income $ (2,017) $ (12) $ - $ 11,709 $ - $ • Beginning Cash Balance January 1 $ 58,074 $ 56,057 $ 56,045 $ 56,045 $ 67,754 Net Income $ (2,017) $ (12) $ - $ 11,709 $ - $ _ Add Back Depreciation Expense $ _ $ - $ $ $ $ Other Cash Realted Activities $ _ $ _ $ $ $ $ Ending Cash Balance December 31 $ 56,057 $ 56,045 $ 56,045 $ - $ 67,754 $ 67,754 $ - • CITY OF BROOKLYN CENTER FUND 65300 • AECYCUNG FUND, : REVENUE -2003 Page 1 2000 2001 2002 2002 2003 2003 2003 MISCELLANEOUS REVENEUE Actual Actual Budget To Date Request Recommend Adopt 4600 Miscellaneous Revenue 4601 Special Assess- Pnncipal 4602 Special Assess - Penalties and Interest 4603 Interest Earnings $ 2,704 s 3,589 $ 2,498 $ 10,000 4604 Check Processing Fee 4605 Gain or Loss on Inventory 4606 Misc Revenue not Otherwise Cl Subtotal Miscellaneous Revenue $ 2,704 $ 3,589 $ 2,498 $ - $ 10,000 $ - $ ENTERPRISE FUND REVENUES 4751 Recycling Charges $ 210,168 $ 211,388 $ 211,000 $ 105,699 $ 223,839 Subtotal Recycling Utility - Operations$ 210,168 $ 211,388 $ 211,000 $ 105,699 $ 223,639 TOTAL REVENUE AND $ 212,872 $ 214,977 $ 213,498 $ 105,699 $ 233,839 OTHER SOURCES — -- i • City of Brooklyn Center 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Recycling Fund - 65300 DEPT /ACTIVITY/PROJECT: Recycling Fund - 49311 PROFILE The recycling fund accounts for the operation and administration of the City's state - mandated curbside recycling program. Revenues are from customer service fees with expenses comprised of amounts paid to the Hennepin Recycling Group (HRG), a four cities consortium for recycling services. DEPARTMENTAL GOALS * To provide bi- weekly collection of recyclables. * To continue an effective curbside recycling program while keeping rates as affordable as possible. * To identify program needs and develop funding mechanisms that provide sufficient revenues. EXPENDITURE DETAILS • 6449 Other Contractual Services $207,000 This represents the City's portion of the contractual services provided under a cooperative agreement. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY None requested. i • CITY OF BROOKLYN CENTER FUND 65300 • RECYCLING DEPT /DIV NO.: 'OPERil710Nfi i ^c_ `?� �sx'.. Obi Description49311 b * 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONALSVS WAGES AND SALARIES 6101 Wages and Salaries -FT Emp 6102 Overtime -FT Emp 6103 Wages and Salaries -PT Emp 6104 Overtime -PT Emp 6106 Wages and Salaries -Temp Emp 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord 6123 PERA -FT Emp -Po1 &Fire 6124 PERA- Defined Contribution 6125 FICA - Medicare 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions OTHER PAYMENTS 6141 Unemployment Comp OTHERINSURANCE 6151 Workers Comp Ins SUBTOTAL PERSONAL $ _ $ _ $ $ $ _ $ _ $ - SVS 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt SUPPLIES OFFICE SUPPLIES 6201 Office Supplies • 6202 Copying Supplies 6203 Books /Reference Materials 6204 Stationary Supplies OPERATING SUPPLIES 6211 Cleaning Supplies 6212 Motor Fuels 6213 Lubricants and Additives 6214 Clothing and Personal Equip 6215 Shop Materials 6216 Chemicals /Chemical Products 6217 Safety Supples 6218 Welding Supplies 6219 General Operating Supplies REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities 6224 Street Maint Materials 6225 Park & Landsacpe Materials 6226 Sign & Striping Materials 6227 Paint Supplies - - 6231 Athletic Field Supplies 6232 Trailway Supplies 6233 Court Supplies 6235 Utlity System Supplies 6236 DARE Supplies 6237 Laundry Supplies 6239 Other Repair & Maintenance Sup SMALL TOOLS AND MINOR EQUIP 6241 Small Tools 6242 Minor Equip SUBTOTAL SUPPLIES $ _ $ - • Obj Description -49311 2000 2001 2002 2002 2003 2003 2003 • Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs 6302 Arch, Eng and Planning 6303 Legal 6305 Medical Svs 6306 Personnel /Labor Relations 6307 Professional Svs 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager 6322 Postage 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Expense /Mileage 6332 Contracted Transportation 6333 FreighUDrayage 6339 Other Transporation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising PRINTING /DUPLICATING 6351 Printing Svs 6352 Micro - filming Svs INSURANCE 6361 General Liability $ 119 $ 143 $ 140 $ 150 6362 Property Damage 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown 6367 Equipment (Inland Marine) • 6368 Bonds 6369 Otherinsurance UTILITY SERVICES 6381 Electric 6382 Gas 6383 Water 6384 Refuse Disposal 6385 Sewer 6386 Storm Sewer 6387 Heating Oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs 6403 Buildings and Facilities Maint Svs 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communication/information Svs 6409 Other Repair and Maint Svs RENTALS 6411 Land 6412 Buildings/Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Exp I Obi Description49311 2000 2001 2002 2002 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Recommend Adopt SERV I CES/LI CENSES/FEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges $ 7,500 $ 7,500 $ 6,358 $ 6,500 6428 Protection Svs MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools 6433 Meeting Exp 6434 Dues and Subscriptions 6435 Credit Card Fees 6436 Uncoliectible Checks 6437 Check Verification 6438 Cash Shortl(Over) OTHER 6441 Auto Licenses, Taxes and Fees 6442 Court Awards /Settlements 6443 Prize Awards/Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges - 6448 Boarding Charges- Prisioner 6449 Other Contractual Svs $ 207,270 $ 207,346 $ 207,000 $ 207,000 CENTRAL GARAGE CHARGES 6461 Fuel Charges 6462 Fixed Charges 6463 Repair and Maint Charges 6464 Multi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -In $ 8,480 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out • 6475 Contingency 6476 Special Assessment Transfer -Out 6477 Capital Project Transfer -Out ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales - Taxable 5585 Other Cost of Sales - Nontaxable 5586 Cost of Sales -Mist 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise- Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp 6494 Depreciation Exp 5591 Contractor Pmts - Personal Svs 5593 Contractor Pmts - Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 214,889 $ 214,989 $ 213,498 $ - $ 222,130 $ - $ OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements 6540 Equip and Machinery 6550 Motor Vehicles 6560 Furniture 6570 Office Equip 6580 information Systems 6590 Leases SUBTOTAL CAPITAL $ - $ _ $ - $ - $ $ $ • OUTLAY ON Description -49311 2000 2001 2002 2002 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal INTEREST 6611 Bond Interest 6612 Other Debt Interest AGENT /ISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ - $ - $ - $ $ $ $ SERVICE TOTAL BUDGET -49311 $ 214,889 $ 214,989 $ 213,498 $ - $ 222,130 $ - $ _ • • • 4a • 1 • Brooklyn Center Liquor Fund • • 1 . CITY OF BROOKLYN CENTER FUND 60900 • PROPRIETARY FUNDS-LIQUOR STRORE DEPT/DN 49611 R dGfMTER j z 2003 BUDGET 2000 2001 2002 2002 2003 2003 2003 Operating Statement Actual Actual Budget To Date Request Request Request Revenues Operating Revenues Liquor Sales $ 1,168,994 $ 1,167,470 $ 1,055,340 $ 1,124,720 $ - $ Wine Sales $ 373,666 $ 400,688 $ 345,180 $ 378,420 Beer Sales $ 1,841,592 $ 1,829,213 $ 1,752,300 $ 1,770,040 $ - $ _ Other Sales - Taxable $ 39,660 $ 35,728 $ 51,150 $ 30,600 $ - $ _ Other Sales Non•Taxabie $ . $ - $ $ $ $ Mlsc Sales $ 159,107 $ 119,387 $ 93,390 $ 96,020 $ $ _ Deposit Revenue $ 1,810 $ (334) $ 2,640 $ 200 $ - $ - Subtotal Operating Revenue $ 3,584,829 $ 3,552,152 $ 3,300,000 $ 3,400,000 $ Non - operating Revenue Investement Earnings $ 18,191 $ 55,236 $ 12,000 $ $ _ $ _ Other Revenue $ 4,189 $ 4,540 $ 5.000 $ 2,000 $ _ $ Subtotal Non - operating Revenue $ 22,380 $ 59,776 $ 17,000 $ 2,000 $ - $ _ Total Revenues $ 3,607,209 $ 3,611,928 $ 3,317,000 $ - $ 3,402,000 $ - $ Less Cost of Goods Sold $ 2,734,319 $ 2,696,529 $ 2,479,583 $ 2,569,193 $ - $ - Gross Profit $ 872,890 $ 915,399 $ 837,417 $ 832,807 $ - $ 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Request Request Expenses Operating Expenses Wages and Benefits $ 415,887 $ 333,851 $ 372,403 $ 377,772 $ $ - Supplies $ 20,989 $ 15,096 $ 13,100 $ 12,100 $ - $ - Services $ 220,450 $ 340,587 $ 204,045 $ 237,256 $ - $ _ • Depreciation $ 45,007 $ 36,488 $ 37,816 $ 38,000 $ - $ Debt Service $ 515 $ - $ $ - $ _ $ Subtotal Operating Expenses $ 702,848 $ 726,022 3 627,384 $ 665,128 $ OtherExpenses/Uses Capital Outlay $ 253,003 $ 8,599 $ - $ - $ - $ Admin Transfer -out $ 100,486 $ 26.761 $ 100,000 $ 100.000 $ - $ - Subtotal Other Expenses/Uses $ 353,489 $ 35,360 $ 100,000 $ 100,000 $ - $ Total Expenses and Other Uses $ 1,056,337 $ 761,382 $ 727,364 $ 765,128 $ $ Net Profit $ (183,447) $ 154,017 $ 110,053 $ 67,679 $ - $ Beginning Cash Balance January 1 $ 412,551 $ 360,557 $ 551,062 $ 698,931 Net Income $ (183,447) $ 154,017 $ 110,053 $ 67,679 Add Back Depreciation $ 45,007 $ 36,488 $ 37,816 $ 38,000 Other Cash Related Activites $ 86.446 $ - $ - $ • $ - $ Ending Cash Balance December 31 $ 360,557 $ 551,062 $ 698,931 $ 804,610 • CITY OF BROOKLYN CENTER FUND 60900 PROPRIETARY FUNDS - LIQUOR STRORE W-A NY6 " GEMTEFR 14 -�'' REVENUE•2003 Page 1 2000 2001 2002 2002 2003 2003 2003 MISCELLANEOUS REVENEUE Actual Actual Budget To Date Request Recommend Adopt 4600 Miscellaneous Revenue 4603 Interest Earnings $ 18,191 $ 55,236 $ 12,000 4604 Check Processing Fee $ 145 $ 110 4605 Gain or Loss on Inventory 4606 Misc Revenue not Otherwise Classified $ 4.1144 $ 4,430 $ 5,000 $ 1,047 $ 2.000 Subtotal Miscellaneous Revenue$ 22,380 $ 59,776 $ 17,000 $ 1,047 $ 2,000 $ - $ ENTERPRISE FUND REVENUES 4760 Enterprise Fund Revenues Liquor Store 4761 Liquor Sales $ 1,168,994 $ 1,167,470 $ 1,055,340 $ 541,217 $ 1,124,720 4762 Beer Sales $ 1,841,592 $ 1,829,213 $ 1,752,300 $ 850,864 $ 1,770,D40 4783 Wine Sales $ 373.666 $ 400,688 S 345,180 $ 182,108 $ 378,420 Subtotal Liquor Operations $ 3,384,252 $ 3,397,371 $ 3,152,820 $ 1,574,189 $ 3,273,180 $ - $ 4764 Sales -Non taxable $ 8,583 4765 Sales - Taxable $ 39,660 $ 35,728 $ 51,150 $ 15,260 $ 30,600 4766 Misc Sales $ 159,107 $ 119,387 $ 93,390 $ 38,133 $ 96,020 4767 Deposit Revenue $ 1.810 $ (334) $ 2,640 $ 24 $ 200 OTHER FINA Subtotal Enterprise Fund Revenues $ 200,577 $ 154,781 $ 147,180 $ 62,000 $ 126,820 $ - $ - 4900 Other Financing Sources 4911 Sale of Property $ 300 4912 Contributions and Donations 4913 Transfer from General Fund 4921 Refunds/Reimbumements $ 73 4923 Prior Year Appropriation Subtotal Other Financing Sources $ - $ 300 $ - $ 73 $ $ - $ - TOTAL REVENUE AND $ 3,607,209 $ 3,612,228 $ 3,317,000 $ 1,637,309 $ 3,402,000 $ - $ • • CITY OF BROOKLYN CENTER FUND 60900 • PROPRIETARY FUNDS - LIQUOR STORE DEPT /DIV NO.:H ry : a;xe Obj Description -49611 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Request Request PERSONAL SVS WAGES AND SALARIES 6101 FT -Wages and Salaries $ 184,506 $ 143,872 $ 189,121 $ 73,082 $ 156,953 6102 FT- Overtime 6103 PT -Wages and Salaries $ 169,921 $ 134,725 $ 125,900 $ 78,975 $ 158,839 6104 PT- Overtime $ 1,136 $ 1,859 $ 523 $ 500 6105 TEMP -Wages and Salaries 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord $ 15,875 $ 13,377 $ 16,028 $ 7,793 $ 17,030 6123 PERA -FT Emp -Pol &Fire 6124 PERA - Defined Contribution 6125 FICA - Medicare $ 26,160 $ 23,431 $ 24,099 $ 11,798 $ 21,558 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins/Cafeteria Plan Contributions $ 14,953 $ 14,762 $ 14,473 $ 9,588 $ 18,000 OTHER PAYMENTS 6141 Unemplyment Comp $ 786 $ 66 OTHERINSURANCE 6151 Workers Comp Ins $ 2,550 $ 2,025 $ 2,782 $ 2,162 $ 4,882 SUBTOTAL PERSONAL $ 415,887 $ 333,851 $ 372,403 $ 183,987 $ 377,772 $ - $ - SVS 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Request Request SUPPLIES ' OFFICE SUPPLIES 6201 Office Supplies $ 450 $ 399 $ 750 6202 Copying Supplies $ 500 $ 200 • 6203 Books /Reference Mateirals 6204 Stationary Supplies $ OPERATING SUPPLIES 6211 Cleaning Supplies 6212 Motor Fuels 6213 Lubricants and Additives 6214 Cloth and Personal Equip $ 2,799 $ 1,150 $ 1,150 6215 Shop Materials 6216 Chemicals/Chemical Products 6217 Safety Supples - 6218 Welding Supplies 6219 General Operating Supplies $ 13,627 $ 14,490 $ 8,000 $ 3,604 $ 8,000 REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities $ 209 9224 Street Malnt Materials 8225 Park & Landsacpe Materials 6226 Sign & Striping Materials 6227 Paint Supplies 6231 Athletic Field Supplies 6232 Trailway Supplies 6233 Court Supplies 6235 Utlity System Supplies 8236 DARE Supplies 6237 Laundry Supplies $ 511 $ 608 $ 1,000 $ 140 $ 500 - 6239 Other $ 397 $ 1,000 $ 162 $ 500 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ 421 $ 200 $ 200 6242 Minor Equip $ 3,025 $ 800 $ 341 $ 800 SUBTOTAL SUPPLIES $ 20,989 $ 15,096 $ 13,100 $ 4,646 $ 12,100 $ - $ • Obj Description -49611 2000 2001 2002 2002 2003 2003 2003 • Page 2 Actual Actual Budget To Date Request Request Request OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs $ 1,913 $ 2,507 $ 1,988 $ 1,828 $ 2,087 6302 Arch, Eng and Planning 6303 Legal $ 175 $ 301 6305 Medical Svs 6306 Personnel/Labor Relations 8307 Professional Svs $ 6,284 $ 2,564 $ 2,000 $ 1,670 $ 2,000 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager $ 6,123 $ 3,860 $ 4,500 $ 1,857 $ 4,500 6322 Postage 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 8331 Travel Exp/Mileage 6332 Contracted Transportation 6333 Freight/Drayage 6339 Other Transporation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising $ 12,266 $ 8,021 $ 15,000 $ 3,634 $ 10,000 PRINTING/DUPLICATING 6351 Printing Svs 6352 Micro-filming Svs INSURANCE 6361 General Liability $ 1,246 $ 1,431 $ 1,760 $ 681 $ 1,918 6362 Property Damage $ 1,286 $ 1,059 $ 2,000 $ 146 $ 2,160 6363 Motor Vehicles 6364 Dram Shop $ 8,697 $ 6,307 $ 7,511 $ 2,955 $ 6,187 6365 Errors and Omissions 6368 Machinery Breakdown $ 309 $ 131 $ 300 $ 32 $ 327 • 6367 Equipment (Inland Marine) 6388 Bonds 6369 Other Insurance UTILITY SERVICES 6381 Electric $ 14,156 $ 15,935 $ 9,000 $ 3,432 $ 9,000 6382 Gas $ 2,174 $ 2,624 $ 3,000 $ 1,805 $ 3,800 6383 Water $ 2 6384 Refuse Disposal $ 2,937 $ 588 $ 300 $ 300 6385 Sewer $ 96 6386 Storm Sewer $ 116 6387 Heating oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs $ 6,455 $ 3,307 $ 2,500 $ 85 $ 2,500 6403 Buildings and Facilities Maint Svs $ 555 $ 446 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communication/Information Svs 6409 Other Repair and Maint Svs $ 2,287 $ 3,000 $ 135 $ 3,000 RENTALS 6411 Land 6412 Buildings/Facilifies $ 117,659 $ 140,873 $ 114,500 $ 71,609 $ 146,500 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Exp ON Description -49611 2000 2001 2002 2002 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Request Request SERVICESILICENSESIFEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges $ 7,938 $ 6,768 $ 10,000 $ 5,814 $ 7,867 6428 Protection Svs $ 1,216 $ 2,979 $ 300 $ 117 $ 300 MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ 28 $ 300 $ 300 6433 Meeting Exp 6434 Dues and Subscriptions $ 620 $ 620 $ 1,000 $ 287 $ 1,000 6435 Credit Card Fees $ 21,309 $ 11,221 $ 23,000 6436 Uncollectible Checks $ 1,913 $ 772 $ 1,800 6437 Check Verification $ 1,500 $ 625 $ 1,500 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees $ 145 $ 104 6442 Court Awards/Settiements $ 1,000 6443 Prize Awards/Expense Reimb 6444 Reoication Exp 6445 Lodging Tax 6446 6447 Towing Charges 8446 Boarding Charges- Prisioner 6449 Other Contractual Svs $ 26,980 $ 22,850 $ 607 $ 3,700 CENTRAL GARAGE CHARGES 6461 Fuel Charges $ 338 $ 110 $ 240 $ 40 6482 Fixed Charges $ 741 $ 684 $ 1,150 $ 387 $ 1,150 6463 Repair and Maint Charges $ 1,140 $ 318 $ 1,046 $ 81 $ 300 6464 Multi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -Out $ 100,486 $ 26,761 $ 100,000 $ 10,905 $ 100,000 6472 Engineering Service Transfer -Out 6473 Storm Sewer Transfer -Out 6474 Debt Service Transfer -Out 6475 Contingency 6476 Special Assessment Transfer -out 6477 Capital Project Transfer -Out $ 110,000 ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor $ 868,342 $ 865,871 $ 789,788 $ 332,733 $ 826,669 5582 Cost of Sales -Wine $ 263,388 $ 275,278 $ 247,270 $ 102,861 $ 257,326 5583 Cost of Sales -Beer $ 1,440,785 $ 1,421,890 $ 1,322,648 $ 529,542 $ 1,375,321 5584 Other Cost of Sales- Taxable $ 29,750 $ 27,161 $ 25,187 $ 8,964 $ 21,879 5585 Other Cost of Sales - Nontaxable $ 13,691 $ 12,635 $ 11,895 $ 4,940 12,410 5588 Cost of Sales -Misc $ 102,789 $ 77,057 $ 85,847 $ 22,684 $ 58,238 5587 Inventory Variances $ 2,906 $ 3,397 $ 3,000 $ 2,202 $ 3,600 5588 Merchandise Breakage - $ 89 $ 730 $ 750 $ 12 $ 250 5589 Delivery Charges $ 12,599 $ 12,510 $ 13,200 $ 8,658 $ 13,500 OTHER MISCELLANEOUS COSTS /EXPENSES 6491 Merchandise- Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp 6494 Depreciation Exp $ 45,007 $ 36,488 $ 37,816 $ 15,570 $ 38,000 5591 Contractor Pmts - Personal Svs 5593 Contractor Pmts - Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 3,100,262 $ 3,100,385 $ 2,821,444 $ 1,146,935 $ 2,944,449 $ - $ - OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities $ 1,357 $ 17,190 6530 Improvements $ 192,771 6540 Equip and Machinery $ 60,232 $ 7,242 $ 1,630 6550 Motor Vehicles 6560 Furniture 6570 Office Equip 6580 Information Systems 6590 Leases SUBTOTAL CAPITAL $ 253,003 $ 8,599 $ - $ 18,820 $ - $ - $ - OUTLAY • • Description -49611 2000 2001 2002 2002 2003 2003 2003 Page 4 Actual Actual Budget To Date Request Request Request Obj DEBT SERVICE PRINCIPAL 6601 Bond Principal 6802 Other Debt Principal INTEREST 6611 Bond Interest 6612 Other Debt Interest $ 515 AGENTIISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ 515 $ - $ $ _ $ _ $ _ $ SERVICE TOTAL BUDGET -49611 $ 3,790,656 $ 3,457,911 $ 3,206,947 $ 1,354,388 $ 3,334,321 $ • • • 4b • • • Centerbrook Golf Course Fund • • CITY OF BROOKLYN CENTER FUND 61300 • PROPRIETARY FUNDS -GOLF COURSE ` CENTER_BROpKGOLFCEILIRSE Golf Course Cash Analysis 2002 2003 Revenues Misc Revenue $ 5,000 $ 5,000 Golf Lessons $ 5,500 $ 5,500 Green Fees $ 273,579 $ 255,000 Passbook Fees $ 26,502 $ 25,000 Rental Fees $ 12,500 $ 11,900 League Fees $ 16,950 $ 16,250 Concessions $ 53,000 $ 53,000 Other Sources $ _ $ - $ 393,031 $ 371,650 Expenditures Personal Services $ 153,118 $ 145,984 Supplies $ 21,900 $ 23,550 Services $ 111,496 $ 114,400 Depreciation $ 16,160 $ 16,000 Debt Service $ 70,000 $ 70,000 Total Expenditures $ 372,674 $ 369,934 capital Outlay $ 18,000 $ 1,600 Total Cash Requirments $ 390,674 $ 371,534 Beginning Cash Balance $ 82,671 $ 117,348 Revenues $ 393,031 $ 371,650 Expenditures $ (374,514) $ (355,534) Depreciation Add -back $ 16,160 $ 16,000 Ending Cash Balance $ 117,348 $ 149,464 • I II i • CITY OF BROOKLYN CENTER FUND 61300 • PROPRIETARY FUNDS -GOLF COURSE CENTERBROOK GOLr- C011RSE r', REVENUE -2003 Page 1 2000 2001 2002 2002 2003 2003 2003 MISCELLANEOUS REVENEUE Actual Actual Budget To Date Request Recommend Adopt 4600 Miscellaneous Revenue 4603 Interest Earnings $ 3,352 $ 12,388 $ 5,000 $ 5,000 4604 Check Processing Fee $ 50 $ 70 4605 Gain or Loss on Inventory 4606 Misc Revenue not Otherwise Classified $ 504 Subtotal Miscellaneous Revenue $ 3,906 $ 12,458 $ 5,000 $ - $ 5,000 $ - $ - ENTERPRISE FUNDS 4700 Golf Course GWtLessotioe_is.,', >'': ?_ _ $ 5,555 $ 3,664 $ 5,500 $ 1,918 $ 5,500 4771 Golf Lessons $ 5,555 $ 3,864 $ 5,500 $ 5,500 Green Fees $ 251,083 $ 219,145 $ 273,579 $ 80,830 $ 255,000 4773 Weekend Rate $ 78,594 $ 62,530 $ 82,912 $ 75,000 4773 Adult Rate $ 97,554 $ 86,376 $ 105,380 $ 100,000 4773 Senior Rate $ 36,789 $ 32,441 $ 41,088 $ 40,000 4773 Junior Rate $ 14,226 $ 10,935 $ 16,435 $ 15,000 4773 Second Round Rate $ 23,918 $ 26,863 $ 27,764 $ 25,OGO Passbook Fear $ 21,824 $ 21,113 $ 26,502 $ 17,637 $ 25,000 4778 Adult Passbook $ 8,145 $ 7,574 $ 8,650 $ 8,000 4778 Senior- Junior Passbook $ 12,665 $ 11,409 $ 15,138 $ 14,500 4778 Weekend Passbook $ 1,014 $ 2,130 $ 2,714 $ 2,500 Re tltaiFees .ey,. „' $ 12,509 $ 11,411 $ 12,500 $ 3,987 $ 11,900 4782 Hand Cart Rental $ 5,068 $ 4,480 $ 5,000 $ 4,800 4782 Motor Cart Rental $ 5,599 $ 5,570 $ 5,5DO $ 5,500 4782 Club Rental $ 1,842 $ 1,361 $ 2,000 $ 1,600 Lea up Fees . - ° IIi $ 12,523 $ 13,478 $ 15,950 $ 16,713 $ 16,250 4785 Couples League $ 1,480 $ 367 $ 1,500 $ 2,000 4785 Men's League $ 2,945 $ 3,054 $ 3,500 $ 3,500 4785 Women's League $ 2,726 $ 4,907 $ 5,800 $ 6,500 4785 Women's Second League $ 1,780 $ 1,470 $ 1,500 4785 Senior League $ 1,587 $ 1,848 $ 2,400 $ 2,000 4785 Junior League $ 2,005 $ 1,832 $ 2,250 $ 2,250 • Subtotal Golf Course - Operations $ 303,494 $ 269,011 $ 335,031 $ 121,085 $ 313,650 $ - $ Concession Sales 4786 Beer Sales $ 16,137 $ 14,061 $ 14,000 $ 3,962 $ 14,500 4787 Food and Beverage $ 6,166 4788 Sales - Taxable $ 3,079 $ 2,638 $ 4,500 $ 1,639 $ 4,000 4790 Misc Sales $ 36,248 $ 33,350 $ 34,500 $ 4,298 $ 34,500 Subtotal Misc Concession Revenues $ 55,464 $ 50,049 $ 53,000 $ 16,065 $ 53,000 $ - $ OTHER FINANCING SOURCES 4900 Other Financing Sources 4911 Sale of Property 4912 Contributions and Donations 4913 Transfer from General Fund 4921 Refunds /Reimbursements 4923 Prior Year Appropriation Subtotal Other Financing Sources $ - $ - $ - $ - $ - $ - $ TOTAL REVENUE $ 362,864 $ 331.518 S 393.031 $ 137,150 $ 371,650 $ - $ AND OTHER FINANCING SOURCES • City of Brooklyn Center 2003 Budget • CAPITAL OUTLAY WORKSHEET FUND: Enterprise/Proprietary Funds -61300 DEPT/DIVISION /ACTIVITY: Centerbrook Golf Course -49721 Ouantitv 1 Unit Cost $1,600 Total Cost $1,600 Trade -in $0 Net Cost $1,600 1. Item Name: Computer 2. Description of item: Standard 3. Describe purpose or need for this item: • Replace computer that will be over five years old. Current computer do not meet the hardware minimum specifications for Windows 2000 operating system. Windows 2000 is the City standard for desktop operating system. Microsoft and LOGIS do not support prior operating system versions, Windows 95 and 98. 4. Describe and estimate ongoing annual operating and maintenance costs. 5. Identify any items to be replaced with the purchase of this additional item. Identify method of disposition, salvage or trade value and recommendation for disposition. Dispose of computer, as according to policy, City Council Resolution 2000 -197. • CITY OF BROOKLYN CENTER FUND 61300 • ,_ . PROPRIETARY FUNDS -GOLF COURSE ... ... �- ... , GO . _. .., -_... ,.. , . DEPT /DIV NO.: CENTER NTER BROpTf LF GpURSE: :: Obj Description49721 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONAL SVS WAGES AND SALARIES 6101 FT -Wages and Salaries $ 37,835 $ 40,036 $ 39,789 $ 11,669 $ 41,122 6102 FT- Overtime 6103 PT -Wages and Salaries $ 91,780 $ 90,104 $ 89,434 $ 40,439 $ 81,500 6104 PT- Overtime $ 702 $ 570 $ 1,102 6105 TEMP -Wages and Salaries 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments 5121 PERA -FT Emp -Basic 6122 PERA -FT Emp-Coord $ 2,491 $ 5,467 $ 7,146 $ 1,362 $ 6,781 6123 PERA -FT Emp -Pol &Fire 6124 PERA- Defined Contribution 6125 FICA - Medicare $ 9,709 $ 9,635 $ 9,886 $ 4,105 $ 9,381 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions $ 4,763 $ 5,423 $ 5,663 $ 3,165 $ 6,000 OTHER PAYMENTS 6141 Unemplyment Comp OTHER INSURANCE 6151 Workers Comp Ins $ 1,169 $ 1,150 $ 1,200 $ 800 $ 1,200 SUBTOTAL PERSONAL $ 148,449 $ 152,385 $ 153,118 $ 62,642 $ 145,984 $ - $ - SVS 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt • SUPPLIES OFFICE SUPPLIES 6201 Office Supplies $ 541 $ 330 $ 750 $ 480 $ 600 6202 Copying Supplies 6203 Books /Reference Mateirals 6204 Stationary Supplies OPERATING SUPPLIES 6211 Cleaning Supplies $ 5 $ 36 $ 15 $ 100 6212 Motor Fuels $ 1,804 $ 1,086 $ 1,300 $ 815 $ 1,500 6213 Lubricants and Additives $ 18 $ 50 6214 Cloth and Personal Equip 6215 Shop Materials $ 23 $ 70 $ 83 6216 Chemicals/Chemical Products $ 2,875 $ 4,328 $ 3,000 $ 497 $ 4,000 6217 Safety Supples 6218 Welding Supplies 6219 General Operating Supplies $ 6,174 $ 11,021 $ 8,000 $ 2,542 $ 8,000 REPAIR AND MAINTENANCE SUPPLIES 5221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities $ 316 $ 1,024 $ 1,000 $ 732 $ 1,000 9224 Street Maint Materials 6225 Park & Landsacpe Materials $ 5,026 $ 4,443 $ 5,800 $ 4,914 $ 5,800 6226 Sign & Striping Materials $ 190 6227 Paint Supplies $ 59 $ 48 6231 Athletic Field Supplies 6232 Treilway Supplies 6233 Court Supplies 6235 Utlity System Supplies 6236 DARE Supplies 6237 Laundry Supplies $ 1,080 $ 1,174 $ 800 $ 718 $ 1,100 6239 Other $ 1,497 $ 345 $ 1,000 $ 49 $ 500 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ 607 $ 160 $ 250 $ 193 $ 250 6242 Minor Equip $ 670 $ 373 $ 650 SUBTOTAL SUPPLIES $ 20,197 $ 24,705 $ 21,900 $ 11,459 $ 23,550 $ • Obi Description-49721 2000 2001 2002 2002 2003 2003 2003 - • Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs $ 510 $ 669 $ 530 $ 487 $ 700 6302 Arch, Eng and Planning 6303 Legal 6305 Medical Svs 6306 Personnel /Labor Relations 6307 Professional Svs $ 692 $ 110 $ 400 $ 274 $ 300 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager $ 6,776 $ 6,981 $ 6,000 $ 3,807 $ 6,000 6322 Postage 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Exp/MAeage 6332 Contracted Transportation 6333 Freight/Drayage 6339 Other Transportation Exp $ 1,737 ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising $ 5,169 $ 3,740 $ 5,000 $ 2,337 $ 4,000 PRINTI N GIDU PLICATIN G 6351 Printing Svs $ 916 6352 Micro - filming Svs INSURANCE 6361 General Liability $ 5,956 $ 6,675 $ 4,000 $ 4,613 $ 6,500 6362 Property Damage $ 847 $ 956 $ 650 $ 651 $ 1,000 6363 Motor Vehicles $ 219 $ 300 6364 Dram Shop $ 1,003 $ 600 $ 900 $ 432 $ 1,000 6365 Errors and Omissions 6366 Machinery Breakdown $ 204 $ 200 $ 100 $ 200 • 6367 Equipment (Inland Marine) 6368 Bonds 6369 Other Insurance UTILITY SERVICES 6381 Electric $ 5,219 $ 5,540 $ 6,000 $ 1,469 $ 6,000 6382 Gas $ 684 $ 1,086 $ 1,500 $ 1,588 $ 1,300 6383 Water $ 5,900 $ 5,087 $ 4,000 $ 208 $ 5,000 6384 Refuse Disposal $ 914 $ 1,394 $ 1,100 $ 868 $ 1,400 6385 Sewer $ 190 $ 405 $ 200 $ 179 $ 400 6386 Storm Sewer $ 701 $ 753 $ 725 $ 403 $ 750 6387 Heating oil $ 10 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs $ 3,262 $ 1,207 $ 3,300 $ 245 $ 3,000 6403 Buildings and Facilities Maint Svs $ 1,621 6404 Street Maint Svs 6405 Park and Landscape Svs $ 2,000 $ - 6407 Traffic Control Maint Svs 6408 Communication /Information Svs $ 95 6409 Other Repair and Maint Svs $ 455 $ 221 $ 24 RENTALS 6411 Land 6412 Buildings /Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment $ 4,422 $ 1,681 $ 9,950 $ 1,206 $ 7,600 6416 Machinery 6417 Uniforms 6419 Other Rental Exp $ 1,758 $ 3,201 • Obj Description49721 2000 2001 2002 2002 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Recommend Adopt SERVI CESlLICENSES /FEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges $ 2,130 $ 2,255 $ 1,679 $ 2,500 6428 Protection Svs $ 459 $ 411 $ 500 $ 457 $ 750 MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ 178 $ 21 $ 250 $ 250 6433 Meeting Exp 6434 Dues and Subscriptions $ 384 $ 454 $ 500 $ 762 $ 500 6435 Credit Card Fees $ 945 $ 584 $ 1,000 6436 Uncollectible Checks $ 44 $ (135) 6437 Check Verification 6438 Cash ShorV(Over) OTHER 6441 Auto Licenses, Taxes and Fees $ 227 $ 10 $ 125 $ 119 $ 100 6442 Court Awards /Settlements 6443 Prize Awards /Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges- Prisioner 6449 Other Contractual Svs $ 1,951 $ 2,570 $ 2,000 $ 2,317 $ 2,250 CENTRAL GARAGE CHARGES 6461 Fuel Charges $ 198 $ 225 $ 251 $ 105 $ 250 6462 Fixed Charges $ 7,658 $ 8,795 $ 12,190 $ 5,832 $ 12,000 6463 Repair and Maint Charges $ 2,811 $ 3,805 $ 4,340 $ 3,885 $ 4,400 6464 Multi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -Out $ 5,332 $ 5,496 $ 8,585 $ 4,289 $ 8,750 6472 Engineering Service Transfer -Out 6473 Storm Sewer Transfer -Out 6474 Debt Service Transfer -Out • 6475 Contingency 6476 Special Assessment Transfer -Out 6477 Capital Project Transfer -Out $ 10,000 ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales•Wine $ 188 5583 Cost of Sales -Beer $ 4,198 $ 3,313 $ 4,200 $ 4,200 5584 Other Cost of Sales - Taxable 5585 Other Cost of Sales- Nontaxable 5586 Cost of Sales -Misc 5587 Inventory Vanances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTS/EXPENSES 6491 Merchandise - Purchase for Resale $ 14,285 $ 14,394 $ 15,000 $ 13,798 $ 15,000 5592 Cost of Sales -Food $ 14,554 $ 12,290 $ 14,500 $ 13,500 5595 Cost of Sales- Banquest Exp $ 3,641 $ 3,702 $ 2,600 $ 3,500 6494 Depreciation Exp $ 13,837 $ 14,736 $ 16,160 $ 7,680 $ 16,000 5591 Cost of Sales -Labor 5593 Cost of Sales Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 116,515 $ 128,454 $ 127,656 $ 60,356 $ 130,400 $ $ - OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities $ 4,250 $ 5,352 6530 Improvements 6540 Equip and Machinery $ 1,063 $ 18,000 $ 4,311 6550 Motor Vehicles 6560 Furniture 6570 Office Equip 6580 Information Systems $ 1,600 6590 Leases SUBTOTAL CAPITAL $ 5,313 $ 5,352 $ 18,000 $ 4,311 $ 1,600 $ - $ • OUTLAY Description -49721 2000 2001 2002 2002 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt Ob) DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal $ 50,000 $ 70,000 $ 70,000 6603 INTEREST 6611 Bond Interest 6612 Other Debt Interest $ 736 6513 AGENT /ISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ 50,000 $ 736 $ 70,000 $ - $ 70,000 $ - $ - SERVICE TOTAL BUDGET -49721 $ 340,474 $ 311,632 $ 390,674 $ 138,770 $ 371,534 $ - $ - • 4c • • EBHC Fund • • • CITY BROOKLYN CENTER FUND 61700 PROPRIETARY FUNDS -EBHC ESHC, REVENUE -2003 2000 2001 2002 2002 2003 2003 2003 Actual Actual Budget To Date Request Recommend Adopt MISCELLANEOUS REVENEUE 4600 Miscellaneous Revenue 4603 Interest Earnings $ 21,087 4604 Check Processing Fee 4605 Gain or Loss on Inventory 4606 Misc Revenue not Otherwise Classified Subtotal Miscellaneous Revenue $ - $ 21,087 $ - $ - $ - $ - $ - 4810 B &B Revenue 4811 B &B Guest Room Rentals $ 180,880 $ 92,483 $ 45,760 $ 17,600 $ 26,400 4812 B &B Facility Rentals $ 19,623 $ 15,182 $ 19,500 $ 4,560 $ 7,800 4813 B &B Merchandise Sales $ 802 $ 279 4814 B &S Equipment Rentals $ 5,301 $ 3,061 $ 2,500 $ 1,425 $ 2,500 4815 B &B Miscellaneous Revenue $ 955 $ 571 $ 358 4845 Catering Svs- Liquor at the B &B $ 1,855 $ 3,075 $ - $ - Subtotal B &B Operations $ 209,416 $ 114,651 $ 67,760 $ 23,943 $ 36,700 $ $ - 4820 Convention Center Revenue 4821 Conv Ctr Room Rentals $ 558,876 $ 696,009 $ 640,000 $ 449,670 $ 610,000 4822 Conv Ctr Labor Charges $ 5,522 $ 10,621 $ 7,000 $ 1,775 $ 6,000 4823 Conv Ctr Equipment Rentals $ 191,345 $ 183,708 $ 170,500 $ 90,868 $ 181,000 4821 Com Ctr Room Rentals -CMP $ 110,522 $ 85,164 $ 69,500 $ 62,125 $ 65,000 4823 Conv Ctr Equipment Rentals -CMP $ 57,034 $ 46,901 $ - 35,000 $ 41,469 $ 70,000 4826 Conv Ctr Dance Floor Rentals $ 48,474 $ 56,236 $ 47,000 $ 27,584 $ 47,000 4827 Conv Ctr Security Services $ 14,602 $ 16,544 $ 12,500 $ 6,290 $ 12,500 4828 Conv Ctr Client Services $ 31,320 $ 31,124 $ 32,500 $ 17,668 $ 32,500 4829 Conv Ctr Misc Sales $ 5,301 $ 2.559 $ 3,000 $ 1,988 $ 4,000 Subtotal Convention Center Operations $ 1,022,996 $ 1,126,866 $ 1,017,000 $ 699,437 $ 1,028,000 $ - $ - 4830 Office Rental Revenue 4831 Office Rentals $ 60,138 $ 62.629 $ 61,425 $ 31,218 $ 61,425 . Subtotal Office Rental Operations $ 60,138 $ 62,629 $ 61,425 $ 31,218 $ 61,425 $ - $ 4840 Catering Services Revenue 4841 Catering Svs -Meal Sales $ 2,006,041 $ 1,860,628 $ 1,955,000 $ 974,080 $ 1,860,500 4842 Catering Svs - Service Charges $ 365,392 $ 355,954 $ 372,540 $ 164,946 $ 334,890 • 4843 Catering Svs - Concessions $ 7,200 $ 7,200 4844 Catering Svs -Food and Beverage Sales $ 28,311 $ 4845 Catering Svs- LiquorNVine /Beer Sales $ 320,510 $ 354,830 $ 336,000 $ 103,221 $ 295,500 4848 Catering Svs -Misc Sales $ 7,754 $ 9,911 $ 6,200 $ 8,935 $ 11,550 4849 Catering Sys-Misc Sales Non - taxable $ 489 $ 4,867 $ - $ 3,000 $ - Subtotal Catering Services Operations $ 2,700,186 $ 2,614,501 $ 2,676,940 $ 1,254,182 $ 2,509,640 $ - $ OTHER FINANCING SOURCES 4900 Other Financing Sources 4911 Sale of Property 4912 Contributions and Donations 4913 Transfer from General Fund 4921 Refunds/Reimbursements $ 549 4923 Prior Year Appropriation Subtotal Other Financing Sources $ 549 $ - $ - $ - $ - $ - - $ - TOTAL REVENUE $ 3,993,285 $ 3,920,647 $ 3,823,125 $ 2,008,780 $ 3,635,765 $ - $ AND OTHER FINANCING SOURCES • City of Brooklyn Center 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Earle Brown Heritage Center - 61700 DEPT /ACTIVITY/PROJECT: Administration - 49851 PROFILE The Administration division provides overall administrative duties for the entire complex including, but not limited to, commercial office, convention center, catering and the Inn on the Farm. DEPARTMENTAL GOALS * Oversee and support the work of the various divisions within the complex * Provide a high level of customer service to guests and vendors EXPENDITURE DETAILS 6432 Conferences and Schools $3,000 • Professional development for General Manager through IAAM (International Association of Assembly Managers) plus computer and other courses for Administration staff PERSONNEL LEVELS 1 EBHC Manager 1 Secretary /Receptionist 1 Secretary /Billing Clerk CAPITAL OUTLAY Item Computer Qty: 1 Unit Cost: $1,600 Less Trade -in: $ -0- Total Cost: $1,600 Printer Qty: 1 Unit Cost: $2,000 • Less Trade -in: $ -0- Total Cost: $2,000 CITY OF BROOKLYN CENTER FUND 61700 • PROPRIETARY FUNDS -EBHC OAt DEPTIDIV NO.: PBHC- ADMINI5TAT( . Obi Description -49851 2000 2001 2002 2002 2003 2003 2003 Page 1 Actual Actual Adopted To Date Request Recommend Adopt PERSONAL SVS WAGES AND SALARIES 6101 FT -Wages and Salaries $ 115,008 $ 121,633 $ 126,221 $ 63,499 $ 135,610 6102 FT- Overtime 6103 PT -Wages and Salaries $ 4,811 6104 PT- Overtime 6105 TEMP -Wages and Salaries 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp-Basic 6122 PERA -FT Emp -Coord $ 6,181 $ 6,272 $ 6,980 $ 3,495 $ 7,471 6123 PERA -FT Emp -Pot &Fire 6124 PERA- Defined Contribution 6125 FICA - Medicare $ 9,142 $ 9,356 $ 9,656 $ 4,913 $ 10,336 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions $ 13,221 $ 16,270 $ 16,990 $ 9,496 $ 18,000 OTHER PAYMENTS 6141 Unemplyment Comp OTHER INSURANCE 6151 Workers Comp Ins $ 504 $ 420 $ 480 $ 377 $ 604 SUBTOTAL PERSONAL $ 148,867 $ 153,951 $ 160,327 $ 81,780 $ 172,021 $ - $ - SVS 2000 2001 2002 2002 2003 2003 2003 SUPPLIES Actual Actual Adopted To Date Request Recommend Adopt OFFICE SUPPLIES 6201 Office Supplies $ 671 6202 Copying Supplies 6203 Books /Reference Materials • 6204 Stationary Supplies - OPERATING SUPPLIES 6211 Cleaning Supplies $ $ 6212 Motor Fuels 6213 Lubricants and Additives 6214 Cloth and Personal Equip 6215 Shop Materials 6216 Chemicals /Chemical Products 6217 Safety Supples 6218 Welding Supplies 6219 General Operating Supplies $ - $ 465 $ - REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities 9224 Street Maint Materials 6225 Park & Landsacpe Materials 6226 Sign & Striping Materials 6227 Paint Supplies 6231 Athletic Field Supplies 6232 Traihvay Supplies 6233 Court Supplies 6235 UOity System Supplies - 6236 DARE Supplies 6237 Laundry Supplies 6239 Other $ (10,000) - SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ 293 6242 Minor Equip SUBTOTAL SUPPLIES $ - $ (8,864) $ - $ 293 $ Obj Description -49851 2000 2001 2002 2002 2003 2003 2003 • Page 2 Actual Actual Adopted To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs $ 2,678 $ 3,510 $ 2,800 $ 2,575 $ 3,000 6302 Arch, Eng and Planning 6303 Legal $ 6,946 $ 4,092 $ 1,500 $ 321 $ 1,500 6305 Medical Svs 6306 Personnel/Labor Relations 6307 Professional Svs $ 1,650 $ 2,000 $ - $ 500 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone/Pager $ $ _ 6322 Postage 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Exp/Mileage $ - $ _ 6332 Contracted Transportation 6333 FreighttDrayage $ 7 6339 Other Transporation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising PRINTINGIDUPLICATING 6351 Printing Svs $ 8 $ _ 6352 Micro - filming Svs INSURANCE 6361 General Liability $ 860 $ 1,405 $ 1,117 $ 948 $ 1,218 6362 Property Damage $ 2,930 $ 3,249 $ 2,927 $ 1,932 $ 3,190 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown S 413 $ 341 $ 350 $ 174 $ 382 _ 6367 Equipment (Inland Marine) 6368 Bonds • 6369 UTILITY SERVICES UTILITY SERVICES 6381 Electric 6382 Gas 6383 Water 6384 Refuse Disposa; 6385 Sewer 6386 Storm Sewer 6387 Heating oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs 6403 Buildings and Facilities Maint Svs 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communication /Information Svs 6409 Other Repair and Maint Svs RENTALS 6411 Land 6412 Buildings /Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Fxp • Obj Description49851 2000 2001 2002 2002 2003 2003 2003 • Page Actual Actual Adopted To Date Request Recommend Adopt SERV ICESILICENSES /FEES 6421 Software License $ 890 $ 500 $ 1,652 $ 1,650 6422 Software Maint 6423 LOGIS Charges $ 22,856 $ 27,909 $ 25,915 $ 10,047 $ 28,629 6428 Protection Svs MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ 2,649 $ 3,D00 $ 1,631 $ 3,000 6433 Meeting Exp 6434 Dues and Subscriptions 6435 Credit Card Fees 6436 Uncollectible Checks 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees 6442 Court Awards /Settlements 6443 Prize Awards/Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges - Prisioner 6449 Other Contractual Svs $ 4,145 $ 2,000 $ 2,000 CENTRAL GARAGE CHARGES 6461 Fuel Charges 6462 Fixed Charges 6463 Repair and Maint Charges 6464 Multi -use Charges 6465 Replacement Charges _ TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -In $ 55,443 $ - 59,035 $ 66,279 S 33,135 $ 68,930 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out 6475 Contingency 6476 Special Assessment Transfer -Out • 6477 Capital Project Transfer -Out ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales - Taxable 5565 Other Cost of Sales- Nontaxable 5586 Cost of Sales -Mist 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise - Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp 6494 Depreciation Exp 5591 Cost of Sales -Labor 5593 Cost of Sales Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 94,681 S 108,335 $ 106,388 $ 52,915 $ 113,499 $ - $ - OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements 6540 Equip and Machinery 6550 Motor Vehicles 6560 Furniture 6570 Office Equip $ - $ 650 $ 3,600 6580 Information Systems $ 1,984 6590 Leases SUBTOTAL CAPITAL $ - $ 1,984 $ 650 $ - $ 3,600 $ - $ - OUTLAY • Description-49851 2000 2001 2002 2002 2003 2003 2003 • Page 4 Actual Actual Adopted To Date Request Recommend Adopt Obi DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal $ 548 6603 INTEREST 6611 Bond Interest 6612 Other Debt Interest $ 1,441 $ 1,235 6613 AGENTIISSUE FEES 6621 Agent Fees 5622 Issue Fees SUBTOTAL DEBT $ 1,441 $ 1,235 $ - $ 548 $ - $ _ $ _ SERVICE TOTAL BUDGET -49851 $ 244,989 $ 256,641 $ 267,365 $ 135,536 $ 289,120 $ - $ • • City of Brooklyn Center 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Earle Brown Heritage Center - 61700 DEPT /ACTIVITY/PROJECT: Convention Center - 49852 PROFILE The Convention Center, in conjunction with the Catering Department, provides a full service conference and event location. Noted for a high level of customer service the facility maintains a significant amount of repeat business among its corporate clientele. The business mix is 66% corporate, 7% social, 3% shows, 10% government/health, and 14% weddings . Economic impact directly affecting Brooklyn Center includes hotel, restaurant, shopping and convention service related business activity (floral, printing, rental, etc.) DEPARTMENTAL GOALS Add a minimum of ten new corporate clients. • - Participate in four trade show opportunities to promote the Heritage Center in the marketplace Participate in four industry associations to network for referral business Combine marketing efforts with North Metro Convention and Visitor's Bureau to attract new or reoccurring large multi -day events Promote the facility in accordance with the 2003 Marketing Plan Host a minimum of two association meetings on -site in conjunction with the North Metro Convention and Visitors Bureau EXPENDITURE DETAILS 6211 Cleaning Supplies $11,900 Increase due to higher product costs and increased client usage 6216 Chemicals /Chemical Products $3,100 Cost increased in drain chemicals and outside pool chemicals 6223 Buildings and Facilities $33,000 • Increased costs due to necessary repairs on aging buildings • 6303 Legal Fees $2,000 Increased to cover negotiation of vendor contracts due for renewal (i.e. Flik Int'1.) 6415 Other Equipment $98,000 Increased rental costs caused by lower level of facility owned equipment PERSONNEL LEVELS 1 Sales Director 2 Sales Managers 1 Maintenance /Operations Supervisor 2 Maintenance Custodians 2 Crew Chiefs Part-time positions which include set -up crew, custodians, and maintenance. CAPITAL OUTLAY Item Carpeting replacement in Carriage Hall • Qty: Coverage for 13,000 square feet Unit Cost: $130,000 installed Less Trade -in: $ -0- Total Cost: $130,000 Chairs, Tables and Staging Qty: To be determined by negotiated pricing at time of purchase Unit Cost: $40,000 Less Trade -in: $ -0- Total Cost: $40,000 Computer Qty: 1 Unit Cost: $1,600 Less Trade -in: $ -0- Total Cost: $1,600 • CITY OF BROOKLYN CENTER FUND 61700 • PROPRIETARY FUNDS -EBHC .. DEPTIDIV NO.: , 49$52 EBHG &DN1f�NT7ONCENTi;Fi��.;;,,. e'_•`.• Obj Description -49852 2000 2001 2002 2001 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONAL SVS WAGES AND SALARIES 6101 FT -Wages and Salaries $ 246,850 $ 261,758 $ 3D4,814 $ 136,194 $ 294,296 6102 FT- Overtime $ 1,547 $ 2,383 $ 1,950 $ 651 $ 1,950 6103 PT -Wages and Salaries $ 127,529 $ 165,053 $ 160,000 $ 84,054 $ 160,000 6104 PT- Overtime $ 1,323 $ 124 $ 600 $ 194 $ 600 6105 TEMP -Wages and Salaries 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord $ 18,480 $ 20,440 $ 27,4D4 $ 11,755 $ 25,264 6123 PERA -FT Emp-Pol &Fire $ 71 $ 111 $ - $ 42 6124 PERA- Defined Contribution 6125 FICA - Medicare $ 28,345 $ 32,795 $ 37,909 $ 16,956 $ 34,949 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafetena Plan Contributions $ 31,398 $ 37,459 $ 39,480 $ 24,021 $ 43,929 OTHER PAYMENTS 6141 Unemplyment Comp $ 611 OTHER INSURANCE _ 6151 Workers Comp Ins $ 6,927 $ 8,393 $ 15,639 $ 6,623 $ 13,783 SUBTOTAL PERSONAL $ 462,470 $ 528,516 $ 587,796 $ 281,101 $ 574,771 $ - $ SVS 2000 2001 2002 2001 2003 2003 2003 SUPPLIES Actual Actual Budget To Date Request Recommend Adopt OFFICE SUPPLIES 6201 Office Supplies $ 3,538 $ 2,583 $ 4,000 $ 1,811 $ 4,000 6202 Copying Supplies 6203 Books/Reference Materials $ 129 $ 150 $ 45 $ 150 6204 Stationary Supplies OPERATING SUPPLIES • 6211 Cleaning Supplies $ 11,481 $ 9.904 $ 8,750 $ 6,560 $ 11,900 6212 Motor Fuels $ 22 $ 21 $ 45 6213 Lubricants and Additives 6214 Cloth and Personal Equip $ 935 $ 1,068 $ 1,400 $ 894 $ 1,400 6215 Shop Materials $ 388 $ 523 $ 500 $ 226 $ 500 6216 Chemicals /Chemical Products $ 1,458 $ 2,133 $ 2,800 $ 1,719 $ 3,100 6217 Safety Suppler $ 289 $ 460 $ 400 $ 190 $ 500 6218 Welding Supplies 6219 General Operating Supplies $ 30,960 $ 25,195 $ 27,900 $ 10,675 $ 28,850 REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities $ 19,344 $ 31,583 $ 27,700 $ 17,419 $ 33,000 9224 Street Maint Materials 6225 Park & Landsacpe Materials $ 2,816 $ 1,144 $ 3,000 $ 1,267 $ 3,000 6226 Sign & Striping Materials $ 710 $ 595 $ 900 $ 121 $ 900 6227 Paint Supplies $ 2,000 $ 834 $ 2,400 6231 Athletic Field Supplies 6232 Treihvay Supplies 6233 Court Supplies 6235 Ullity System Supplies 6236 DARE Supplies 6237 Laundry Supplies 6239 Other $ 5,634 $ 5,151 $ 8,700 $ 899 $ 5,600 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ 806 $ 823 $ 950 $ 451 $ 95O 6242 Minor Equip $ 2,144 SUBTOTAL SUPPLIES $ 78,381 $ 83,456 $ 89,195 $ 43,111 $ 96,250 $ - $ • Obj Description -49852 2000 2001 2002 2001 2003 2003 2003 • Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs 6302 Arch, Eng and Planning 6303 Legal $ 358 $ 1,371 $ 1,000 $ 166 $ 2,000 6305 Medical Svs 6306 PersonneVLabor Relations 6307 Professional Svs $ 151 $ 652 $ 750 $ 716 $ 750 6308 Charier Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone/Pager $ 18,427 $ 18,100 $ 18,000 $ 7,452 $ 18,000 6322 Postage $ 3,298 $ 3,741 $ 4,200 $ 613 $ 4,200 6323 Radio Communications 6329 Other Communication Svs $ 19 TRANSPORTATION 6331 Travel Exp/Mileage $ 838 $ 1,142 $ 975 $ 336 $, 975 6332 Contracted Transportation 6333 Freight/Drayage $ 169 $ 205 $ 100 $ 84 $ 240 6339 OtherTransporetion Exp ADVERTISING 6341 Personnel $ 5,465 $ 1,222 $ 4,500 $ 2,000 6342 Legal Notices 6343 Other Notices 6349 Other Advertising $ 22,614 $ 33,084 $ 46,650 $ 22,505 $ 46,650 PRINTINGIDUPLICATING 6351 Printing Svs $ 10,427 $ 10,566 $ 13,500 $ 2,339 $ 13,500 6352 Micro - filming Svs INSURANCE 6361 General Liability $ 4,506 $ 5,395 $ 4,670 $ 3,312 $ 5,090 6362 Property Damage $ 1,553 $ 2,383 $ 2,045 $ 1,680 $ 2,229 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown $ 217 $ 249 $ 348 $ 156 $ 379 6367 Equipment (Inland Marine) 6368 Bonds • 6369 Other UTILITY Y SERVICES 6381 Electric $ 73,293 $ 82,498 $ 82,000 $ 30,901 $ 82,000 6382 Gas $ 14,909 $ 24,130 $ 40,000 $ 10,172 $ 30,000 6383 Water $ 1,038 $ 952 $ 1,100 $ 415 $ 1,100 6384 Refuse Disposal $ 1,882 $ 1,843 $ 2,000 $ 759 $ 2,000 6385 Sewer $ 1,995 $ 1,836 $ 1,900 $ 853 $ 1,900 6386 Storm Sewer $ 686 $ 729 $ 700 $ 699 $ 1,400 6387 Heating oil 6388 Hazardous Waste Disposal 6389 Street Lights $ 143 CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs $ 32,464 $ 33,558 $ 31,000 $ 17,804 $ 33,500 6403 Buildings and Facilities Maint Svs $ 672 $ - $ _ 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communieation/Inforrnation Svs 6409 Other Repair and Maint Svs $ 6,969 $ 7,816 $ 9,930 $ 4,029 $ 9,930 RENTALS 6411 Land 6412 Buildings/Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment $ 72,604 $ 81,552 $ 75,D00 $ 42,341 $ 98,000 6416 Machinery 6417 Uniforms 6419 Other Rental Exp $ 2,131 • Obj Description -49852 2000 2001 2002 2001 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Recommend Adopt SERV ICESILICENSESIFEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges $ 72 6428 Protection Svs $ 8,706 $ 8,203 $ 9,500 $ 2,958 $ 8,900 MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ 2,284 $ 4,539 $ 4,000 $ 2,479 $ 4,000 6433 Meeting Exp $ 434 $ 281 $ 600 $ 111 $ 450 6434 Dues and Subscriptions $ 3,084 $ 2,314 $ 3,850 $ 1,844 $ 3,850 6435 Credit Card Fees $ 3,544 $ 1,488 6436 Uncollectible Checks $ (158) 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees 6442 Court Awards /Setflements 6443 Prize Awards/Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges- Prisioner 6449 Other Contractual Svs $ 21,746 $ 22,677 $ 23,500 $ 8,442 $ 23,500 CENTRAL GARAGE CHARGES 6461 Fuel Charges 6462 Fixed Charges 6463 Repair and Maint Charges 6464 Multi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -In 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out 6475 Contingency 6476 Special Assessment Transfer -Out • 6477 Capital PS Transfer -Out ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales-Taxable 5585 Other Cost of Sales- Nontaxable 5586 Cost of Sales -Mist 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise - Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp $ 1,484 $ 1,135 $ 950 $ - 6494 Depreciation Exp $ 327,247 $ 334,901 $ 335,000 $ 169,168 $ 335,000 5591 Cost of Sales -Labor 5593 Cost of Sales Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 639,520 $ 692,821 $ 717,768 $ 333,826 $ 731,543 $ - $ OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities $ 23,606 $ 20,000 $ 130,000 6530 Improvements 6540 Equip and Machinery $ 89,269 $ 9,704 $ 20,000 $ 40,000 6550 Motor Vehicles 6560 Furniture 6570 Office Equip $ - $ - $ 1,600 6580 Information Systems 6590 Leases SUBTOTAL CAPITAL $ 112,875 $ 9,704 $ 40,000 $ - $ 171,600 $ - $ - OUTLAY • Description -49852 2000 2001 2002 2001 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt Obj DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal 6603 INTEREST 6611 Bond Interest 6612 Other Debt Interest $ 11,169 6613 AGENT /ISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ 11,169 $ - $ $ _ $ $ $ SERVICE TOTAL BUDGET -49852 $ 1,304,415 $ 1,314,497 $ 1,434,759 $ 658,038 $ 1,574,164 $ - $ - • City of Brooklyn Center 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Earle Brown Heritage Center - 61700 DEPT /ACTIVITY/PROJECT: Catering — 49853 PROFILE The Catering Division of the Heritage Center sells, prepares, and services all food and beverage - related activity. A management contract exists with Flik International, Rye Brook, New York, to oversee this division at the direction of the Heritage Center General Manager. Flik creates menus, determines food pricing, hires staff, provides food and beverage to facility clients, and maintains an inventory of food and small wares, maintains the kitchen and service areas, and services all food - related functions. DEPARTMENTAL GOALS • * Reduce total expenses by one -half of one percent from previous year. * Maintain competitive purchase pricing * Provide a high level of quality product to facility clients * Develop new menu items and increase pricing competitive with the marketplace. EXPENDITURE DETAILS Object codes 4492, 4495, 4496 and 4497 are Flik costs for catering. All other object codes used reflect catering related expenses paid by the Earle Brown Heritage Center. PERSONNEL LEVELS All personnel are provided for under an agreement with Flik, Inc. Wages, benefits and other employee costs are provided for under the agreement. CAPITOL OUTLAY Item Computer Qty: 1 Unit Cost: $1,600 Less Trade -in: $ -0- Total Cost: $1,600 CITY OF BROOKLYN CENTER FUND 61700 • PROPRIETARY FUNDS -EBHC ._'..:- .. DEPT /DIV NO.: � 49883 E9HG•CRTERINGOi!ERATtDNS '�=3�:� _ t "'� ...- . Obi Description -49853 2000 a 2001 2002 2001 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONALSVS WAGES AND SALARIES 6101 FT -Wages and Salaries $ 18,807 $ 18,683 $ 19,500 $ 9,868 $ 19,500 6102 FT- Overtime $ 222 $ 156 $ 106 6103 PT -Wages and Salaries $ 52,011 $ 46,053 $ 61,804 $ 18,051 $ 41,000 6104 PT- Overtime $ 353 $ 4 6105 TEMP -Wages and Salaries $ - $ 39,368 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp-Basic 6122 PERA -FT Emp•Coord $ 3,051 $ 2,715 $ 4,496 $ 1,432 $ 3,346 6123 PERA -FT Emp -Pol &Fire $ - $ _ 6124 PERA- Defined Contribution 6125 FICA - Medicare $ 5,341 $ 4,848 $ 6,220 $ 2,048 $ 4,628 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions $ - _ $ - $ 2,880 OTHER PAYMENTS 6141 Unemplyment Comp OTHER INSURANCE 6151 Workers Comp Ins $ 1,835 $ 1,610 $ 2,336 $ 1,058 $ 3,841 SUBTOTAL PERSONAL $ 81,620 $ 113,433 $ 94,356 $ 32,567 $ 75,195 $ $ SVS 2000 2001 2002 2001 2003 2003 2003 SUPPLIES Actual Actual Budget To Date Request Recommend Adopt OFFICE SUPPLIES 6201 Office Supplies $ 2,495 $ 3,385 $ 2,660 $ 1,510 $ 3,000 6202 Copying Supplies 6203 Books/Reference Materials - • 6204 Stationary Supplies OPERATING NG SUPPLIES 6211 Cleaning Supplies $ 210 $ 22,983 $ 6212 Motor Fuels 6213 Lubricants and Additives 6214 Cloth and Personal Equip 6215 Shop Materials $ 57 $ 60 $ 50 $ 26 $ 50 6216 Chemicals /Chemical Products $ 1,025 $ 210 $ 450 $ 139 $ 450 6217 Safety Supples $ 614 $ 113 $ 300 $ 92 $ 300 6218 Welding Supplies 6219 General Operating Supplies $ 887 $ 847 $ 1,200 $ REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicies 6222 Tires 6223 Buildings & Facilities $ 998 $ 2,003 $ 4,350 $ 848 $ 2,600 9224 Street Maint Materials 6225 Park & Landsacpe Materials $ - $ 545 $ 200 $ - 6226 Sign & Striping Materials $ 108 $ 100 $ 100 6227 Paint Supplies 6231 Athletic Field Supplies 6232 Trailmy Supplies 6233 Court Supplies 6235 Ullity System Supplies 6236 DARE Supplies 6237 Laundry Supplies $ - $ 6239 Other $ 2,158 $ 800 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ - $ 86 $ 6242 Minor Equip $ 849 SUBTOTAL SUPPLIES $ 9,273 $ 31,140 $ 9,310 $ 2,615 $ 6,500 $ - $ • Obi Description -49853 2000 2001 2002 2001 2003 2003 2003 • Page Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs 6302 Arch, Eng and Planning 6303 Legal 6305 Medical Svs 6306 Personnel/Labor Relations 6307 Professional Svs $ - $ 112 $ - 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone/Pager $ 3,875 $ 3,118 $ 3,842 $ 1,454 $ 3,200 6322 Postage $ 89 $ 272 $ 350 $ 90 $ 350 6323 Radio Communications 6329 Other Communication Svs $ - $ 12,000 $ TRANSPORTATION 6331 Travel Exp/Mileage $ 8 $ (49) $ _ 6332 Contracted Transportation 6333 Freight/Drayage 6339 Other Transporation Exp ADVERTISING 6341 Personnel $ - $ 812 $ - 6342 Legal Notices 6343 Other Notices 6349 Other Advertising $ 7,393 $ 7,245 $ 8,500 $ 5,333 $ 8,500 PRINTINGIDUPLICATING 6351 Printing Svs $ 741 $ 949 $ 6352 Micro-filming Svs INSURANCE 6361 General Liability $ 3,856 $ 10,452 $ 12,328 $ 8,772 $ 13,435 6352 Property Damage $ 4,451 $ 5,828 $ 6,261 $ 3,486 $ 6,825 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown $ 593 $ 615 $ 754 $ 324 $ 622 6367 Equipment (Inland Marine) 6368 Bonds • 6369 Other Insurance $ 5,202 UTILITY SERVICES 6381 Electric $ 13,048 $ 14,559 $ 14,700 $ 5,711 $ 14,700 6382 Gas $ 14,909 $ 24,130 $ 32,000 $ 10,172 $ 26,000 6383 Water $ 1,038 $ 952 $ 925 $ 415 $ 925 6384 Refuse Disposal $ 8,483 $ 6,587 $ 8,400 $ 2,946 $ 8,400 6365 Sewer $ 1,995 $ 1,836 $ 1,800 $ 853 $ 1,800 6386 Storm Sewer $ 686 $ 729 $ 680 $ 700 $ 1,400 6387 Heating oil 6388 Hazardous Waste Disposal 6389 Street Lights $ 143 CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs - $ 9,821 $ 7,191 $ 10,000 $ 2,051 $ 8,500 6403 Buildings and Facilities Maint Svs $ - 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs _ 6408 Communication /Information Svs 6409 Other Repair and Maint Svs $ 5,965 $ 63,744 $ 7,800 $ 4,855 $ 8,500 RENTALS 6411 Land 6412 Buildings /Facilities 6413 Once Equip 6414 MIS Equip 6415 Other Equipment $ 583 $ 4,215 $ 1,500 $ 1,500 6416 Machinery 6417 Uniforms 6419 Other Rental Exp $ - $ _ • Obj Description 2000 2001 2002 2001 2003 2003 2003 • Page Actual Actual Budget To Date Request Recommend Adopt SERVICESILICENSESIFEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges 6428 Protection Svs MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ 69 $ _ 6433 Meeting Exp $ Y0 $ 6434 Dues and Subscriptions $ - $ 278 $ 6435 Credit Card Fees $ 11,545 $ 4,105 6436 Unwllectible Checks 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees $ 262 $ 5,910 E 55 6442 Court Awards /Settlements 6443 Prize Awards/Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges- Prisioner 6449 Other Contractual Svs $ 21,050 $ 144,217 $ - $ 4,323 CENTRAL GARAGE CHARGES 6461 Fuel Charges 6462 Fixed Charges 6463 Repair and Mamt Charges 6464 Multi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -In 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out 6475 Contingency 6476 Special Assessment Transfer -Out • 6477 Capital Project FUND Transfer-Out EXPENSES ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor $ $ 5582 Cost of Sales -Wine $ _ 5583 Cost of Sales -Beer $ _ 5584 Other Cost of Sales- Taxable $ _ 5565 Other Cost of Sales - Nontaxable 5586 Cost of Sales -Mist 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise - Purchase for Resale 5592 Cost of Sales -Food $ 520,155 $ 464,290 $ 566,106 $ 162,887 $ 501,150 5595 Cost of Sales - Banquest Exp $ 9,500 6494 Depreciation Exp $ 27,776 $ 28,235 $ 34,000 $ 14,397 $ 34,000 5591 Cost of Sales -Labor $ 1,119,453 $ 984,852 $ 976,877 $ 398,239 $ 975,744 5593 Cost of Sales Supplies $ 203,588 $ 37,815 $ 230,662 $ 51,266 $ 183,140 5594 Contractor Pmts -Other Charges $ 100,000 $ 27,D66 $ 248,000 $ 49,085 $ 114,750 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 2,069,928 $ 1,694,727 $ 2,196,985 $ 731,662 $ 1,913,641 OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements 6540 Equip and Machinery $ (15,786) $ 15,000 6550 Motor Vehides 6560 Furniture 6570 Office Equip 6580 Information Systems $ 1,600 6590 Leases SUBTOTAL CAPITAL $ (15,788) $ - $ 15,000 $ - $ 1,600 $ - $ - OUTLAY • I Description -49853 2000 2001 2002 2001 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt Obi DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal 6603 INTEREST 6611 Bond Interest 6612 Other Debt Interest 6613 AGENTRSSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ - $ - $ - $ - $ - $ - $ - SERVICE TOTAL BUDGET- 49853 +AL1910 $ 2,145,033 $ 2,039,300 $ 2,315,651 $ 766,844 $ 1,996,936 $ - $ _ • • • City of Brookfyn Center 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Earle Brown Heritage Center - 61700 DEPT /ACTIVITY/PROJECT: Office Rental - 49854 PROFILE The D Barn (commercial office building) is currently seventy percent occupied by Blumental's Architecture in a long -term lease. The remaining ground level footage provides a storage area for the audio /visual department and supports the meeting space. The Heritage Center staff, under the direction of the General Manager, provides maintenance and custodial services, lawn care, and snow removal. Rental leases are negotiated by the General Manager. DEPARTMENTAL GOALS * Provide maintenance to building * Respond to tenant concerns in a timely manner. • EXPENDITURE DETAILS 6402 Equipment Services $1,200 Additional funds to address service calls on older building and equipment PERSONNEL LEVELS General Manager oversight. Maintenance and custodial care provided by facility staff under the direction of the Maintenance Supervisor. CAPITAL OUTLAY None requested. • CITY OF BROOKLYN CENTER • FUND 61700 PROPRIETARY FUNDS -EBHC DEPT/DIV NO.: 40464 Obi Description -49854 2000 2001 2002 2001 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt PERSONAL SVS WAGES AND SALARIES 6101 FT -Wages and Salaries $ 1,989 $ 2,010 $ 2,000 $ 1,564 $ 3,000 6102 FT- Overtime 6103 PT -Wages and Salaries $ 3,308 $ 2,588 $ 5,150 $ 1,190 $ 3,000 6104 PT- Overtime 6105 TEMP -Wages and Salaries 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp -Coord $ 274 $ 230 $ 395 $ 152 $ 331 6123 PERA -FT Emp -Pol &Fire 6124 PERA- Defined Contribution 6125 FICA - Medicare $ 390 $ 332 $ 547 $ 188 $ 459 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions $ 480 OTHER PAYMENTS 6141 Unemplyment Comp OTHER INSURANCE 6151 Workers Comp Ins $ 138 $ 116 $ 195 $ 104 $ 305 SUBTOTAL PERSONAL $ 6,099 $ 5,276 $ 8,287 $ 3,198 $ 7,575 $ - $ SVS 2000 2001 2002 2001 2003 2003 2003 SUPPLIES Actual Actual Budget To Date Request Recommend Adopt OFFICE SUPPLIES 6201 Office Supplies 6202 Copying Supplies 6203 Books /Reference Materials • 6204 Stationary Supplies - OPERATING SUPPLIES 6211 Cleaning Supplies $ $ 6212 Motor Fuels 6213 Lubricants and Additives 6214 Cloth and Personal Equip 6215 Shop Materials 6216 Chemicals /Chemical Products 6217 Safety Supples 6218 Welding Supplies 6219 General Operating Supplies $ 348 $ 257 $ 315 $ 350 REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities $ 782 $ 1,373 $ 1,000 $ 305 $ 1,000 9224 Street Maint Materials 6225 Park & Landsacpe Materials $ 50 $ 50 6226 Sign & Striping Materials $ 50 $ 50 6227 Paint Supplies $ 100 $ 33 $ 100 6231 Athletic Field Supplies 6232 TraiWay Supplies 6233 Court Supplies 6235 Utlity System Supplies 6236 DARE Supplies 6237 Laundry Supplies 6239 Other $ 58 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ - $ - 6242 Minor Equip SUBTOTAL SUPPLIES $ 1,130 $ 1,688 $ 1,200 $ 653 $ 1,550 $ • Obj Description -49854 2000 2001 2002 2001 2003 2003 2003 • Page 2 Actual Actual Budget To Date Request Recommend Adopt OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs 6302 Arch, Eng and Planning 6303 Legal $ 201 $ 250 6305 Medical Svs 6306 Personnel /Labor Relations 6307 Professional Svs 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager $ - $ 50 $ 89 $ 60 6322 Postage 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Exp /Mileage 6332 Contracted Transportation 6333 Freight/Drayage 6339 Other Transportation Exp ADVERTISING 6341 Personnel 6342 Legal Notices 6343 Other Notices 6349 Other Advertising PRINTING /DUPLICATING 6351 Printing Svs 6352 Micro - filming Svs INSURANCE 6361 General Liability $ 287 $ 234 $ 359 $ 18 $ 392 6362 Property Damage $ 1,804 $ 1,864 $ 1,767 $ 1,080 $ 1,926 6363 Motor Vehicles 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown $ 263 $ 195 $ 224 $ 96 $ 244 6367 Equipment (Inland Marine) 6368 Bonds • 6369 Otherinsurance SERVICES UTILITY SERVICES 6381 Electric 6382 Gas $ 1,004 $ 1,576 $ 2,438 $ 738 $ 1,650 6383 Water $ 124 $ 106 $ 100 $ 52 $ 125 _ 6384 Refuse Disposal $ 673 $ 832 $ 700 $ 335 $ 800 6385 Sewer $ 195 $ 200 $ 200 $ 107 $ 250 6386 Storm Sewer 6387 Heating oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs $ 496 $ 392 $ 600 $ 1,118 $ 1,200 6403 Buildings and Facilities Maint Svs $ - 6404 Street Maint Svs 6405 Park and Landscape Svs 6407 Traffic Control Maint Svs 6408 Communication /Information Svs 6409 Other Repair and Maint Svs $ 154 $ 359 $ - $ 531 RENTALS 6411 Land 6412 Buildings /Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment 6416 Machinery 6417 Uniforms 6419 Other Rental Exp • - Obj Description-49854 2000 2001 2002 2001 2003 2003 2003 • Page 3 Actual Actual Budget To Date Request Recommend Adopt SE RVICESILICENSES/FEES 6421 Software License 6422 Software Maint 6423 LOGIS Charges 6428 Protection Svs $ 396 MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools 6433 Meeting Exp 6434 Dues and Subscriptions 6435 Credit Card Fees 6436 Uncallectible Checks 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees $ 5,674 S 4,800 $ 2,631 $ 4,800 6442 Court Awards/Settlements 6443 Pdze Awards /Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges - Prisioner 6449 Other Contractual Svs $ 9,285 S 4,479 $ 4,545 $ 2,266 $ 4,950 CENTRAL GARAGE CHARGES 6461 Fuel Charges 6462 Fixed Charges 6463 Repair and Maint Charges 6464 Mulfi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -In 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out 6475 Contingency 6476 Special Assessment Transfer -Out • 6477 Capital Project Transfer -Out ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales - Taxable 5585 Other Cost of Sales - Nontaxable 5586 Cost of Sales -Misc 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise - Purchase for Resale - 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp 6494 Depreciation Exp $ 3,812 S 3,812 S 3,812 E 1,906 $ 3,812 5591 Cost of Sales -Labor 5593 Cost of Sales Supplies 5594 Contractor Pmts -Other Charges 6496 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 18,695 $ 19,723 $ 19,845 $ 10,967 $ 20,209 $ - $ - OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements 6540 Equip and Machinery 6550 Motor Vehicles 6560 Furniture 6570 Office Equip 6580 Information Systems 6590 Leases SUBTOTAL CAPITAL $ _ $ - OUTLAY • Description -49854 2000 2001 2002 2001 2003 2003 2003 • Page 4 Actual Actual Budget To Date Request Recommend Adopt Obj DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal 6603 INTEREST 6611 Bond Interest 6612 Other Debt Interest 6613 AGENTIISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ $ _ $ _ $ - $ _ $ - $ SERVICE TOTAL BUDGET. 49854 $ 25,924 $ 26,687 $ 29,332 $ 14,818 $ 29,334 $ - $ - • • City of Brooklyn Center • 2003 Budget DEPARTMENT /ACTIVITY/PROJECT SUPPORT WORKSHEET FUND: Earle Brown Heritage Center - 61700 DEPT /ACTIVITY/PROJECT: Inn on the Farm - 49855 PROFILE The Inn on the Farm is an historic country Inn that supports the meeting facilities with overnight accommodations. Blocks of eight to ten rooms are contracted per day with no individual overnight accommodations offered. The sales department of the Heritage Center sells the room blocks. Hostess and housekeeping staff are scheduled to cover the contracts only and the Inn is closed all other days. DEPARTMENTAL GOALS * Continue to sell blocks of overnight rooms through facility sales staff. * Cover meeting room usage though catering and conference services staff. • EXPENDITURE DETAILS 6381 Electric $6,000 Anticipate lower costs due to lower volume of bookings 6383 Water $7,000 Anticipate lower usage due to decreased reservations PERSONNEL LEVELS The Heritage Center General Manager supervises all Inn functions. Part-time hostess and housekeepers cover guest services. Maintenance and repair at the Inn are provided by facility staff under the direction of the Maintenance Supervisor. CAPITAL OUTLAY • None requested. CITY OF BROOKLYN CENTER FUND 61700 PROPRIETARY FUNDS -EBHC - DEPTIDIV NO.: > 49$58 Obj Description -49855 2000 2001 2002 2001 2003 2003 2003 Page 1 Actual Actual Budget To Date Request Recommend Adopt P ERSONAL SVS WAGES AND SALARIES 6101 FT -Wages and Salaries $ 13,966 $ 10,782 $ - $ 3,052 $ 4,500 6102 FT- Overtime $ 243 $ 177 $ 32 6103 PT -Wages and Salaries $ 102,872 $ 40,625 $ 12,111 $ 7,315 $ 12,111 6104 PT- Overtime $ 431 $ 98 6105 TEMP -Wages and Salaries 6107 Commissions & Boards OTHER PAYMENTS -NON INS 6111 Severance Payments RETIREMENT CONTRIBUTIONS 6121 PERA -FT Emp -Basic 6122 PERA -FT Emp-Coord $ 5,698 $ 2,278 $ 670 $ 521 $ 918 6123 PERA -FT Emp -Pot &Fire 6124 PERA- Defined Contribution 6125 FICA - Medicare $ 8,946 $ 3,933 $ 927 $ 753 $ 1,271 6127 Fire Relief Association EMPLOYEE BENEFITS 6131 Ins /Cafeteria Plan Contributions $ 794 $ 1,356 $ - $ 720 OTHER PAYMENTS 6141 Unemplymenl Comp $ 2,448 $ 1,707 $ 538 OTHER INSURANCE 6151 Workers Comp Ins $ 1,665 $ 713 $ 178 $ 198 $ 223 SUBTOTAL PERSONAL $ 137,063 $ 61,669 $ 13,886 $ 12,409 $ 19,743 $ - $ - SVS 2000 2002 Actual Adopted SUPPLIES OFFICE SUPPLIES 6201 Office Supplies $ 368 $ 162 $ 150 $ 3 $ 150 6202 Copying Supplies 6203 Books/Reference Materials 6204 Stationary Supplies • OPERATING SUPPLIES 6211 Cleaning Supplies $ 857 $ 41 $ 150 $ 4 $ 150 6212 Motor Fuels 6213 Lubricants and Additives 6214 Cloth and Personal Equip $ 95 $ 30 6215 Shop Materials $ 2 $ 24 $ 60 6216 Chemicals/Chemical Products $ 181 $ 200 $ 200 6217 Safety Supples $ 243 $ 200 $ 100 6218 Welding Supplies 6219 General Operating Supplies $ 6,367 $ 1,277 $ 3,500 $ 252 $ 3,500 REPAIR AND MAINTENANCE SUPPLIES 6221 Motor Vehicles 6222 Tires 6223 Buildings & Facilities $ 1,570 $ 1,675 $ 2,500 $ 477 $ 2,500 9224 Street Maint Materials 6225 Park & Landsacpe Materials $ 930 $ 147 $ 200 $ 112 $ 150 6226 Sign & Striping Matenals 6227 Paint Supplies $ 300 $ 101 $ 300 6231 Athletic Field Supplies 6232 Trailway Supplies 6233 Court Supplies 6235 Ut ity System Supplies 6236 DARE Supplies 6237 Laundry Supplies $ 739 $ 493 $ 450 $ 250 6239 Other $ 302 $ 332 SMALL TOOLS AND MINOR EQUIP 6241 Small Tools $ 69 $ 100 $ 14 $ 100 6242 Minor Equip $ 811 SUBTOTAL SUPPLIES $ 12,534 $ 4,181 $ 7,750 $ 1,023 $ 7,4DD $ - $ • Obj Description49855 2000 2002 • Page 2 Actual Adopted OTHER CHARGES AND SVS PROFESSIONAL SERVICES 6301 Acct, Audit Financial Svs 6302 Arch, Eng and Planning 6303 Legal $ 18 6305 Medical Svs 6306 Personnel /Labor Relations 6307 Professional Svs 6308 Charter Commission 6309 Human Rights Commission COMMUNICATIONS 6321 Telephone /Pager $ 4,437 $ 2,906 $ 3,200 $ 1,183 $ 2,600 6322 Postage $ 192 $ 98 $ 6323 Radio Communications 6329 Other Communication Svs TRANSPORTATION 6331 Travel Exp/Mileage $ $ 6332 Contracted Transportation 6333 Freight/Drayage 6339 Other Transporation Exp ADVERTISING 6341 Personnel $ 3,545 $ 157 $ 300 $ 300 6342 Legal Notices 5343 Other Notices 6349 Other Advertising $ 3,409 $ 1,287 $ - $ _ PRINTINGIDUPLICATING 6351 Printing Svs $ 2,584 $ 872 $ - $ 6352 Micro - filming Svs INSURANCE 6361 General Liability $ 973 $ 1,067 $ 1,374 $ 492 $ 1,200 6362 Property Damage $ 2,270 $ 2,924 $ 2,982 $ 1,818 $ 3,600 6363 Motor Vehicles - 6364 Dram Shop 6365 Errors and Omissions 6366 Machinery Breakdown $ 310 $ 308 $ 359 $ 168 $ 340 6367 Equipment (Inland Marine) 6358 Bonds • 6369 Other Insurance UTILITY SERVICES 6381 Electric $ 10,560 $ 8,294 $ 7,500 $ 2,973 $ 6,000 6382 Gas $ 5,696 $ 8,845 $ 9,000 $ 3,329 $ 7,000 6383 Water $ 538 $ 255 $ 400 $ 87 $ 400 6384 Refuse Disposal $ 896 $ 559 $ 750 $ 331 $ 750 6385 Sewer $ 986 $ 381 $ 600 $ 83 $ 200 6386 Storm Sewer 6387 Healing oil 6388 Hazardous Waste Disposal 6389 Street Lights CONTRACT UTIITY SERVICES 6391 Met Council Environmental Svs REPAIR AND MAINTENANCE SVS 6401 Motor Vehicles Svs 6402 Equipment Svs $ 5,401 $ 4,050 $ 3,500 E 2,909 $ 3,500 6403 Buildings and Facili ies Maint Svs $ _ 6404 Street Maint Svs 6405 Park and Landscape Svs 5407 Traffic Control Maint Svs 6408 Communication /Information Svs 6409 Other Repair and Maint Svs $ 501 $ 893 $ 900 $ 1,118 $ 1,500 RENTALS 6411 Land 6412 Buildings/Facilities 6413 Office Equip 6414 MIS Equip 6415 Other Equipment $ 69 $ 19 $ 100 $ 100 6416 Machinery 6417 Uniforms 6419 Other Rental Exp Obj Description -49855 2000 2002 • Page 3 Actual Adopted SERVICES /LICENSESIFEES 5421 Software License 6422 Software Maint 6423 LOGIS Charges 6426 Protection Svs $ 746 $ 7,175 $ 5,000 $ 1,489 $ 3,500 MISCELLANEOUS 6431 Special Events 6432 Conferences and Schools $ (207) 6433 Meeting Exp $ 9 $ 6434 Dues and Subscriptions $ 500 $ 106 $ - 6435 Credit Card Fees $ 1,447 $ 84 6436 Uncollectible Checks $ 361 6437 Check Verification 6438 Cash Short/(Over) OTHER 6441 Auto Licenses, Taxes and Fees $ 10,336 $ 10,200 $ 5,219 $ 10,200 6442 Court Awards /Settlements 6443 Prize Awards /Expense Reimb 6444 Reolcation Exp 6445 Lodging Tax 6446 6447 Towing Charges 6448 Boarding Charges- Prisioner 6449 Other Contractual Svs $ 21,557 $ 6,687 E 6,500 E 2,909 $ 6,500 CENTRAL GARAGE CHARGES 6461 Fuel Charges 6462 Fixed Charges 6463 Repair and Maint Charges 6464 Multi -use Charges 6465 Replacement Charges TRANSFERS AND OTHER USES 6471 Administrative Service Transfer -In 6472 Engineering Service Transfer -In 6473 Storm Sewer Transfer -In 6474 Debt Service Transfer -Out 6475 Contingency 6476 Special Assessment Transfer -Out • 6477 Capital Project Transfer -Out ENTERPRISE FUND EXPENSES 5581 Cost of Sales- Liquor 5582 Cost of Sales -Wine 5583 Cost of Sales -Beer 5584 Other Cost of Sales- Taxable 5585 Other Cost of Sales - Nontaxable 5586 Cost of Sales -Misc 5587 Inventory Variances 5588 Merchandise Breakage 5589 Delivery Charges OTHER MISCELLANEOUS COSTSIEXPENSES 6491 Merchandise - Purchase for Resale 5592 Cost of Sales -Food 5595 Cost of Sales - Banquest Exp $ 11,788 $ 4,875 $ - $ 6,319 6494 Depreciation Exp $ 51,566 $ 49,349 $ 49,350 $ 24,674 $ 49,350 5591 Cost of Sales -Labor $ 2,570 5593 Cost of Sates Supplies 5594 Contractor Pmts -Other Charges 6498 Engineering Fees Reimb 6499 Salaries Reimb SUBTOTAL $ 128,344 $ 115,821 $ 102,015 E 48,866 $ 103,359 E - $ OTHER CHARGES AND SVS CAPITAL OUTLAY 6510 Land 6520 Buildings and Facilities 6530 Improvements 6540 Equip and Machinery $ 7,810 $ - 6550 Motor Vehicles 6560 Furniture 6570 Office Equip 6580 Information Systems 6590 Leases SUBTOTAL CAPITAL E 7,810 $ - $ - OUTLAY Description -49855 2000 2002 • Page 4 Actual Adopted Obj DEBT SERVICE PRINCIPAL 6601 Bond Principal 6602 Other Debt Principal 6603 INTEREST 6611 Bond Interest 6612 Other Debt Interest $ 11,787 6613 AGENTIISSUE FEES 6621 Agent Fees 6622 Issue Fees SUBTOTAL DEBT $ 11,787 $ - $ - $ - $ SERVICE TOTAL BUDGET. 49855 $ 297,538 $ 181,671 $ 123,651 $ 62,298 $ 130,502 $ • •