Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
1996 10-07 CCP Work Session
AGENDA CITY COUNCIL WORK SESSION OCTOBER 7, 1996 7:00 P.M. CONFERENCE ROOM B I. Council Items: 1) Council items for discussion II. Staff Items: 1) Discussion of correspondence from Rep. Carruthers regarding historical society. 2) 1996 recreation funding requests: - youth football 3) 1997 funding requests: discussion of how Council wishes to proceed ® 4) General Budget Overview discussion (materials presented at meeting) 5) Liquor Draft Budget 6) Draft Water, Sewer and Storm Sewer Budgets and proposed rates for 1997 7) Brooklyn Boulevard options and discussions 8) Capital Projects for 1997: further discussion/projects to be presented for Council establishment 9) Communications Tower policy discussion i • Phil Carruthers Minnesota • State Representative y District 47B �,� ;_', , �,. House of Brooklyn Center, Brooklyn Park � ` Representatives MAJORITY LEADER Iry Anderson, Speaker CHAIR, RULES AND LEGISLATIVE ADMINISTRATION COMMITTEES: TAXES; WAYS AND MEANS; LEGISLATIVE AUDIT COMMISSION LEGISLATIVE COMMISSION ON PLANNING AND FISCAL POLICY; LEGISLATIVE COORDINATING COMMISSION August 15, 1996 Mr. Michael McCauley, City Manager City of Brooklyn Center 6301 Shingle Creek Parkway Brooklyn enter MN 55430 yn , Dear Mike: There recently was an editorial in the Brooklyn Center Sun -Post newspaper about the need for a museum to preserve local history in the Brooklyn Center and northwest suburban area. The editorial suggested that the City of Brooklyn Center seek state assistance in building such a museum. I followed up with the fiscal analyst to the House Capital Investment Committee. He put together some information, a copy of which I am enclosing with this letter. I would be more than happy to work with the City on such a project, if that is the City's desire. If the City is interested, please feel free to contact me. Sincerely, Phil Carruthers State Representative, 47B House Majority Leader • Enclosure 861 70th Avenue North, Brooklyn Center, Minnesota 55430 (612) 560 -5515 State ice w ding, 100 Constitution Ave., St. Paui, Minnesota 55155 -1298 — T6 - 1 - 27296 3709 Fax (612) 296 -2553 TDD (612) 296 -9896 ��� s Minnesota House of Representatives August 7, 1996 To: Rep. Phil Carruthers Majority Leader From: Greg Crowe, Fiscal Analyst Capital Investment Commi ee Subject: State Bond Funds for Brooklyn Center You asked about getting state bond dollars for the City of Brooklyn Center for a museum to preserve local history in the Brooklyn Center, Brooklyn Park and northwest suburban area. As you know, projects which end up being funded in the bonding bill come from legislation offered by individual members, and from the administration through the Department of Finance's • capital bonding process, and in some cases, projects are brought forward through both processes. Obviousl if you want a project to be considered only by the Legislature, you would have a bill drafted, by Alan Hopeman in House Research for example, which authorizes the bonds to be sold for the project. Alternatively, or in conjunction with that Legislation, the City of Brooklyn Center could apply for the bond funds through the administration. In order to do that, the City would need to contact Lee Mehrliens (296- 1700), the Department of Finance's Capital Budget Coordinator, to obtain the capital budget instructions and application forms. The instructions and forms are not available until late January of odd - numbered years, in anticipation of a bonding bill in the next even - numbered session. I have attached a copy of 1996 instructions and forms so that you can share them with the City to understand what type of information will be requested from them. I can't guarantee that the forms will be the same, but they should be similar. In addition, I spoke with Lee Mehrkens, and he stated that in all likelihood, in the next capital appropriations cycle, political subdivisions (such as the City of Brooklyn Center) which apply for grants would be required to complete only Form D and Form E. Again, we are several months away from the applications being made available, so things might change. I hope this is helpful. If you have any additional questions of me, please feel free to call me at 296 -7165. In addition, you can have the city manager call me if you feel that would be helpful. Public Services Department i s MEMORANDUM Govt TO: Michael McCauley Buildings FROM: Jim Glasoe Engineering SUBJ: 1996 Fundlifg Application - Brooklyn Center Youth Football Streets DATE: October 2, 1996 I T O Parks As you may recall, at their June meeting, the Parks and Recreation Public Utilities Commission discussed the 1996 nonprofit funding application of the Brooklyn Center Youth Football Program. At that meeting they unanimously passed a motion recommending the City Council allocate $2,000 for the program in 1996. This R recommendation was subject to the submission of a current financial t statement from the group. A submission that I thought was never made. Central In a phone conversation this morning with the president of the football Garage program, she indicated that when applying for funding as a part of the 1997 budget, she included an extra copy of the financial statement to be attached to the 1996 application. As these two processes were kept totally separate, I was unaware of the submission. As all materials are now in and complete, I am forwarding them to you for consideration by the City Council. For Council reference, Recreation Director Arnie Mavis indicates the budget allocation for this funding can be found under budget code #5736 -4220, Community Center Program Supplies and Equipment. This is supported by an almost $10,000 balance in this program budget. Although the purchase of equipment as a mechanism for funding was questioned in February of this year, the 1996 budget had already been approved with the above noted allocation. If you have any questions, or would like additional information, please let me know. • cc: Diane Spector, Director of Public Services Parks and Recreation Commission APPLICATION FOR CONTR-kCTUAL SERVICES CITY OF BROOKLYN CENTER (FOR NONPROFIT ORGA-'vIZATION /PROGRAM /ACES; -CY) Date Submitted (Deadline is June 1 for consideration for the following Fiscal year, January I to December 31.) Applicant Organization /Program/Agencv Name: c 1 --G 4 1 Address (, S M ne N City, State, Zip - Phone Number �� 1a,) SAC I ci s 7� v Contact Person: PROGRAM OVERVIEW l- 1. Generally describe the. organization., including its mission, date established, services, and goals. qo �ccvrc�e- I�c�tQe.cS,�,'� c��8 P;;c�e in c.om(� � �'�re 'r) ro \e mo( Q.\S 2. Explain the areas of expertise of the organization, including a description of the range Of s c apability. J- - icy q:;s�1 vv J , )v �1� c�c S e Paces`�s o r 00l kANjva cs uu; + Cooi e o 31,Q coz��` o� comt'�� �� Q a�•.�. 3. Describe the t2.rget group for services of the organization. �' S �c�5 ��x• arc L�cm 'rl�e IS Lj ;f-f, c.� M'Irch 1994 4. Describe how the organization is rnarLeted, and to what geog- aphicaI and demographical areas. 4.�e + � t �CS p...'� t�?Ocd' off' {ro�'h. (�.,'�- a�� c��aS :S�e..nf c•J� S�r'�S CLS .n .-ht �., c�1' f 5. Discuss the methodology employed in measuring the effecdveness of the organization. G . c,0 O1 C: nQ- I s L:.cc. I S�ue,ro.� l�cu; � aC� BLDGET Current Budget Yr. Requested Year — Actual Budget Year DOLLAR AMOUNT REQUESTED FROM CITY S Do Qd S TOTAL ORGANIZATION BUDGET S S CITY AMOUNT AS % OF TOTAL BU DG - . 7 • `.`'o OF TOTAL BUDGET FOR OVERHEAD AND ADMINISTRATION COSTS % % 6. List specific secured and anticipated sources of contributions availabit to the applicant. SECURED (S) OR SOURCE AMOUNT ANTICIPATED (A) :ctid 8500.00 (� - nn P CAP cx 2nGo— S 50 reGe�nce- o.ao � - � aA: b. C. a 1 p0G.0Z) t000 c� , jfocv ',-a e 1000 Gro rc9UcEcc� 7. List all other funding organizations explored and the ou ut tc ',l ome ..,�,(J �,ece� a�sasn�ao�o � c 2 �'""`�� 4Q I3. Describe how Brooklyn Center benetus from the services provided. 14. a. Discuss possible alternative sources for those services available within the community. j Qt✓' "n cz. Ld b. Describe why those alternative services are not fulfilling the current needs. 15. State the total numbers of people from all communities who participate or receive direct benefits, and describe how these numbers were determined. PROJECTED TOTAL • TOTAL SERVED TO BE SERVED LAST YEAR NEXT YEAR boo o� POA S ,U)A: o -D 4 f o r Crc�..�ore.uJ 10`6 e- c�colle.� p� otre CC_,` `G,ue<ac�e of lo. a. State the numbers of residents from Brooklyn Center only who are served, and describe how these numbers were determined. PROTECTED TOTAL TOTAL SERVED TO BE SERVED LAST YEAR NEXT YEAR t30 IGS-Ig0 te ��U t2:c:cc�eQ C'.Uecace- pa_4 cL� ion recv r b. What ue:cent of the total residents served are from Brooklyn Center? 90 - 9 5'� ,nn. ORGANIZATION NEED i7. Whac would be the consequences to your organization of not receiving the amount requested? C��Se o� c c�?S =�; o- c,; pc 'ee lou;V nq fhz nw» The following supporting documentation must accompany this application. If any item is not enclosed, please explain why not. 1. Financial statement for the preceding Fiscal year. 2. Proposed budget for the upcoming fiscal year. 3. Data (backup documentation) substantiating the need for this service in Brooklyn Center. / J 4. Pr0of of nonprofit status. 5. List of current Board of Directors. o. Job descriptions and resumes of key personnel. J 7. Statistical or other dam measuring effectiveness of the organization. Signature Date Title Primary voLunt' =_r Oual_t'ications Kur': W. Schuman 561 - 9576 995 quipment and fooC5311 advisor- Crandview Park 1x95 Coach a` grookiyn Centar High Schooi i985--1994 Coach at Grandview Park Jeanne M. Schuman 561 - 9576 _994 - 1996 Financial advisor, fund raising chairman and play and parent advisor Worked in accounting and administrative Pos v 1985 - 1996 3 a n involved parent Two Year degree =n account and Steve Peterson c - 9026 959 -1996 Coach at Grandview Park, assistant parent and player advisor. Dave Mal "t'.irISOn Coach at Willow Lane Park, financi -1 advisor >ince; the : e= ,uipmEnt chairman`• 'Firs:. game parent and player adv��or , O 1= C t m E N ro H • (D ? n V7 C r 7C 0 G) f� P a G O_ a o a -n u r• -t N O -t ;0U><�7 (J (D r - S (o 0 O (U SL - t fi• -1 (D 7:3 r C Uf r* n" n o (fl a (F rr J , I Question S 1 Uo not have i-he recorus ror 1995 completed. Upcoming budget 'For ,zQ6 to be completed by June 1, 1996 C The continuinS sign -up or youth is substantiation enough 'or the need to continue to support 180 - 200 ^ youths -n our community 7 Those who continue the tradition of Brooklyn Center F=ootball, Centaurs Dray Darnell Charlie Campbell Brice Darnell Eric Sacowski i=lav Darnell Steve yachish Doug Benson Andy Benson A � .a�� of Wnneso, 9E c SECRETARY O F' STATE CERTIFICATE OF INCORPORATION I, Joan Anderson Growe, Secretary of State of Minnesota, do certify that: Articles of Incorporation, duly signed and acknowledged under oath, have been filed on this date in the Office of the Secretary of State, for the incorporation of the following corporation, under and in accordance with the provisions of the chapter of Minnesota Statutes listed below. This corporation is now legally organized under the laws of Minnesota. Corporate Name: Brooklyn Center Youth Football, Inc. Corporate Charter Number: IM-266 Chapter Formed Under: 317A This certificate has been issued on 05/24/1995. Secretary of State. q1 ,1 1 1 jjj� Wx r NZ X. ITT 1 7, A� 1 . Financial Statement to be completed July 1, 1996 for proc --ding year. 2 Financial Statement to be completed August 1, 1996 for upcoming year (dependent on City Support) Our Season runs from 08/01/96 to 11115/96. all purchases and funds rec'd are within those dates. Budgets and financial are completed at that time. 3. Rosters for the past two preceding years showing continuous sign -up of 200 Brooklyn Center youths for both arks. Continuous ntnnuous su rt for the suppo 25 s of e.�ti stcnce P� Y� with many children of those who were in the program in its earlier years. 4. Certificate of Non -Profit Incorporation attached. 5. Board Members Jeanne Schuman President Stave Peterson Vic;-.President Mk Randall Secretary Kurt Schuman Treasurer 6- Jesnne X Schuman Assoc. Degree in Acct, 9yrs acct, park experience and a concerned parent Approves all purchases, all fund- raising, coordinates sign -ups and gives tournament direction. Approves all coaches and carries out all park policies. Kurt Schuman Graduate of Brooklyn Center High School, former Grandview Player. 1 r Asst Vann Y Y y F ootball Coach, 12 yrs experience at Grandview Park (both as coach and Treasurer) !Mike Randall Attorney at Law, 5yr Coach at Grandview Park, conc=rncd parent Steve Peterson 7 Yre experience with Granview Park as coach and 2 yrs as Vic �Presidcnt as weI1. Coach liaison, assists in all other areas and approvals as needed, 'All positions within our park are volunteer, we have a rn.inimum of 2 coached per team for k-6th. 7 . The ciT=iveness of the organization is measured by the continuing sign -up and those from the Youth program that make it to varsity at Brooklyn Center High School. We arc trying to rebuild the tradition of B.C. Football and pride in the community as a whole. MINUTES OF THE PROCEEDINGS OF THE PARKS AND RECREATION COMMISSION FOR THE CITY OF BROOKLYN CENTER IN THE COUNTY OF HENNEPIN AND THE STATE OF MINNESOTA REGULAR SESSION JUNE 18, 1996 CITY HALL CALL TO ORDER Chair Sorenson called the meeting to order at 6:20 p.m. ROLL CALL Chairperson Sorenson, Commissioners Lasman, Ebert, Russell, and Shinnick were present. Commissioners Peterson and Mead were absent. Also in attendance were Mayor Myrna Kragness, Councilmember Kathleen Carmody and Public Services Coordinator Jim Glasoe. APPROVAL OF MINUTES - June 18, 1996 Chair Sorenson noted that the item on the Twin Lakes Task Force should read, "... the ordinance extends `personal watercraft' rules to all watercraft. " There was a motion by Commissioner Russell, seconded by Commissioner Ebert to approve the minutes of the June 18, 1996 Parks and Recreation Commission meeting as amended. The motion passed. COUNCIL LIAISON REPORT Councilmember Carmody reported that the Council is interested in setting up joint meetings with each of the Commissions during the next few months. An October joint meeting with the Parks and Recreation Commission will be investigated. Chair Sorenson asked Councilmember Carmody to speak regarding a June 6 memorandum from the City Manager regarding "conflict of interest" of Commission members who are also employed by the City in some capacity. Chair Sorenson felt having employees on Commissions could actually be of benefit as these members not only know the needs of the community, but also know how programs and services are provided. Councilmember Carmody indicated that current Commissioners would be allowed to serve out their terms according to the new policy. Mayor Kragness added that this decision does not stem from any current "conflicts," but is intended to avoid any in the future. FUNDING APPLICATION - Brooklyn Center Youth Football Public Services Coordinator Glasoe referred to the contractual services application of the Brooklyn Center Youth Football, and provided copies of a page that was missing from the original application. After some discussion, a motion was made by Commissioner Shinnick, seconded by Commissioner Russell to recommend to the City ouncil that 2 000 be approved fo tY $ PP r youth football pending submission of a current financial statement. SET MEETING DATE The next meeting will be September 17, 1996, at 6:30 p.m. in Conference Room A of City Hall. MEETING ADJOURNED Commissioner Shinnick made a motion seconded b Commissioner Russell to adjourn y � th e meeting at 7:04 p.m. The motion passed. I Budget Brooklyn Center Youth Football Actual Expenditures for 1995 Proposed Budgets for 1996, 1997 1995 1996 1997 Actual Budgeted Budgeted Revenues Sign -up Fees 6,930 7,000 " 7,000 Donations City of B.C. 2,000 2,000 2,000 Lions 500 1,000 1,000 Car Wash 287 240 275 Misc. 475 325 325 Leased Equip 925 1,250 1,500 Banquet 500 630 630 Candy Sales 4,500 4,500 4,500 Total Revenues 511,617 $12,445 512,730 Expenses Leased Expansion Add'l Equip 2,457 4,300 2,000 Printing /Postage 60 50 60 Misc Parts 125 150 175 Storage 48 0 125 Uniforms Pants /Pads 1,100 0 450 Jerseys 2,000 2,100 2,300 Referees 1,346 1,375 1,425 Banquet 647 700 750 Trophies 1,450 1,500 1,550 Candy (for sales) 2,000 2,000 2,000 Prizes for Sales 93 90 100. Misc. Office Supplies 237 100 100 Scholarships 0 0 1,000 $11,563 $12,365 $12,035 Total 554 $80 $695 Inflation has been taken into account. Revenue based on sign -ups of 200 players cg 35.00, keeping price as low as possible. " Lease program goal to be reached by end of 1996 season, maintenance and replacement to begin in 1997 - Looking to build funds for future equipment purchases and ability to maintain reasonable prices to include everyone. Page 1 of 1 Sudget Brooklyn Center Youth Football Actual Expenditures for 1995 • Proposed Budgets for 1996 1997 P 9 1995 1996 1997 Actual Budgeted Budgeted Revenues Sign -up Fees 6,930 7,000 ' 7,000 ' Donations City of B.C. 2,000 2,000 2,000 Lions 500 1,000 1,000 Car Wash 287 240 275 Misc. 475 325 325 Leased Equip 925 1,250 1,500 Banquet 500 630 630 Candy Sales 4,500 4,500 4,500 Total Revenues 511,617 $12,445 $12,730 Expenses Leased Expansion Add'I Equip 2,457 4,300 " 2,000 Printing /Postage 60 50 60 Misc Parts 125 150 175 Storage 48 0 125 • Uniforms Pants /Pads 1,100 0 450 Jerseys 2,000 2,100 2,300 Referees 1,346 1,375 1,425 Banquet 647 700 750 Trophies 1,450 1,500 1,550 Candy (for sales ) 2,000 2,000 2,000 Prizes for Sales 93 90 100 Misc. Office Supplies 237 100 100 Scholarships 0 0 1,000 $11,563 512,365 $12,035 Total $54 Sao $695 Inflation has been taken into account. ' Revenue based on sign -ups of 200 players (g 35.00, keeping price as low as possible. Lease program goal to be reached by end of 1996 season, maintenance and replacement to begin in 1997 Looking to build funds for future equipment purchases and ability to maintain reasonable prices to include everyone. Page 1 of 1 Public Services Department Govt Buildings H I Engineering June 19, 1996 Streets To: Michael McCauley From: Jim Glasoe ;✓' Parks f Subject: Funding Recommendation, Brooklyn Center Youth Football Program 0 ram g Utilities At their meeting last evening, the Parks and Recreation Commission Recreation discussed the non-profit funding application of the Brooklyn Center Youth Football Program. This request was for funding in 1996. After some discussion, a motion was unanimously passed recommending • Central the City Council allocate $2, 000 for the Brooklyn Center Youth Football Garage Program. This recommendation was subject to the submission of a current financial statement by the program. I have provided notice to the football program regarding the need for the statement. If you have any questions regarding the above motion, would like a copy of the application, or desire additional information, please let me know. cc: Parks and Rrecreation Commission Diane Spector • a Public Services Department (Ll rc 1H Govt Buildings MEMORANDUM �� Engineering TO: Jeanne Schuman Streets FROM: Jim Glasoe Parks SUBJ: Funding Recommendation, Brooklyn Center Youth Football Program Public DATE: September 18, 1996 Utilities On June 19, 1996, I sent you a correspondence regarding your 1996 Recreation nonprofit funding application. In that memo, (copy enclosed) I indicated that the Parks and Recreation Commission had passed a motion • recommending the City Council allocate $2,000 for the Brooklyn Center Central Youth Football program. Garage However, that recommendation was subject to the submission of a current financial statement. To date, no statement has been forwarded to our office. As a result, the above funding recommendation was never brought to the City Council for consideration. Consequently, I am returning the equipment invoice recently forwarded to Joel Erickson as I am unable to process it. If you have any questions regarding the above information, please feel free to call me at X69 -3340. enc . (2) cc: Michael 1 McCauley, City Manager Diane Spector, Director of Public Services Parks and Recreation Commission • • Public Services Department Et;i Lill ME Govt Buildings \ Ili Engineering June 19, 1996 Streets To: Jeanne Schuman From: Jim Glasoe Parks Subject. Funding Re� Brooklyn Center Youth Public Football Program Utilities At their meeting last evening, the Parks and Recreation Commission Recreation discussed your 1996 non-profit funding application. After some discussion, a motion was unanimously passed recommending the City Council allocate $2, 000 for the Brooklyn Center Youth Football • Central Program. However, this recommendation was subject to the submission i Garage S of a current financial statement by your organization. Although your application indicated a statement would be completed approximately July 1, we will need it as soon as possible. If you have any questions regarding the above request, or need additional information, please call me 569 -3340. cc: Parks and Reecreation Commission Diane Spector • st River Gca!1 — — 7 7, - iESt - 1 n DAI'E Ir .�� ORDER .NO - -t i SHIP TO TO r . ........ ...... ............... ......................... .. .. . ...... _... — . ............. .. ............... .... _.. ............ ......... f i SALESPERSON DATE SHIPPED SHIPPED VIA F.O.B. POINT I TE}R, MS ~ QUANTITY DESCRIPTION UNIT PRICE TOTAL' O ,J: ? i � 1 L —r. , > .._.`.`"_j � ✓ '.� s;� L� f i t. i�+ ✓', —,C'f C + 1� IJ t / ( lv '\J \ � ` ......., t, +W 1. tv cc .............. ......................... ....... ............... .............. _ ... _ .... _........ .............................. _ .. ..... .................... ...-............... Yi .. ...... ..._....,..... ....... .............. ........... .......................... ........... . ..........................._... Dt .. .......... .....c,.,....._.. .... .. _ .............._. ........._.. I ............................................................................................. ............................... .................................................. ............................... . s 3 .............. ...... . .. ............. ............... ...... F., . V V ............. .... ...... ...... ......... ......._ ��,.............. ..... ......... ..... - ... ..... .__....... ..... _ ..... I __....... .... ...� ......... ... _ ... ....... ........... ...... ... .. r ... ........ .. . ................ ... I , ....... .. . .... ..... .......... ... .. ...... ............ _ . . .. .. ........ ... ... . ... ... .... ...... ......._ �.. .... ... ...... ... ......... ............... .......... ................ .. .. .. ... ....... .. ............................ .................. ....... .. .. ... ...... .. ........ - ......... .... ... .. .. _..._... __.... .... i ....... f.. ..................... ... . ..... ....... .... .... _. ..... ............__..........._ .... .. . .. ....... ....... f... I ................... .................... .. .. .. ......... ! .. . I I . i i . ...... . .... . ........... . . __ . ................. . i L . I I � I I DUPLICATE , J n aa, CITY OF BROOKLYN CENTER LIQUOR STORE REVENUES Humboldt Liquor Store 6/30/95 1995 6/30/96 1996 1995 Final 1997 Gross Liquor YTD Final YTD Budget Multi 1.06 Est Profit Cost Liab Ins Revenues Revenues Revenues Revenues Revenues Revenues Percen Of Sales 0.00438 Liquor 3521 129,297 265,530 129,768 261,800 281,462 280,000 25.70% 208,040 1,226.40 Wine 3522 33,270 75,124 38,199 77,000 79,631 78,500 27.00% 57,305 343.83 Beer 3523 209,351 428,221 211,130 443,000 453,914 450,000 22.40% 349,200 1,971.00 Mix NT 3524 7,945 5,994 7,939 6,000 6,354 6,000 28.90% 4,266 26.28 Mix Taxable 3525 10,526 11,000 11,158 11,000 29.40% 7,766 48.18 Miscellaneous 3526 13,298 26,728 13,551 28,000 28,332 28,000 28.90% 19,908 122.64 393,161 812,123 400,587 826,800 860,850 853,500 646,485 3,738.33 nextbdgt \dept511 \REVENUE.XLS Store1 9/24/962:57 PM • 0 CITY OF BROOKLYN CENTER LIQUOR STORE REVENUES Boulevard Liquor Store 6/30/95 1995 6/30/96 1996 1995 Final 1997 Gross Liquor YTD Final YTD Budget Multi 1.06 Est Profit Cost Liab Ins Revenues Revenues Revenues Revenues Revenues Revenues Percen Of Sales 0,00438 Liquor 3521 139,764 293,546 138,882 315,000 311,159 312,000 25.70% 231,816 1,366.56 Wine 3522 43,610 96,238 50,821 101,000 102,012 102,000 28.00% 73,440 446.76 Beer 3523 207,982 423,473 212,611 455,500 448,881 450,000 22.40% 349,200 1,971.00 Mix NT 3524 8,610 5,751 9,407 5,525 6,096 6,000 28.90% 4,266 26.28 Mix Taxable 3525 13,066 11,700 13,850 13,000 29.40% 9,178 56.94 Miscellaneous 3526 17,115 37,653 21,644 33,000 39,912 40,000 28.90% 28,440 175.20 417,081 869,727 433,365 921,725 921,911 923,000 696,340 4,042.74 nextbdgt \dept511\REVENUE.XLS Store2 9/24/962:57 PM • • CITY OF BROOKLYN CENTER LIQUOR STORE REVENUES Northbrook Liquor Store 6/30/95 1995 6/30/96 1996 1995 Final 1997 Gross Liquor YTD Final YTD Budget Multi 1.06 Est Profit Cost Liab Ins Revenues Revenues Revenues Revenues Revenues Revenues Percent Of Sales 0.00438 Liquor 3521 147,681 319,176 162,368 315,300 338,327 340,000 25.70% 252 1,489.20 Wine 3522 42,271 95,815 47,249 96,200 101,564 102,000 28.00% 73,440 446.76 Beer 3523 247,906 526,848 283,862 558,200 558,459 560,000 22.40% 434,560 2,452.80 Mix NT 3524 10,047 6,539 10,196 6,475 6,931 7,000 28.90% 4,977 30.66 Mix Taxable 3525 14,527 15,550 15,399 15,000 29.40% 10,590 65.70 Miscellaneous 3526 21,360 46,024 26,726 46,600 48,785 50,000 28.90% 35,550 219.00 469,265 1,008,929 530,401 1,038,325 1,069,465 1,074,000 811,737 4,704.12 nextbdgt \dept51 MEVENUEALS Store3 9/24/962:57 PM deptsum 0 CITY OF BROOKLYN CENTERONNESOTA DEPAR TMENT! I 9/24/96 RECOMMENDED 1997 WAGES & BENEFITS DEPT, NO. 511 TOTAL COMPENSATION PROJECTION 2,088 3.00% 4142 ANNUAL HOURS ANNUAL PERA 4146 4154 4151 4152 4153 TOTAL GRADE MONTHLY ANNUAL Increase COORD FICA W/C HEALTH LIFE DENTAL FRINGE TOTAL POSITION EMPLOYEE CURR PROD HOURLY Projected Projected 4.48* 7.65% INSUR INSUR INSUR INSUR BENEFITS COMPENS Liquor Stores Manager Olson C29F C29G 4,665 M 55,980 57,659 2,583 4,411 703 2,600 22 187 10,507 68,166 Liquor Supervisor Mueller C8G C8G 2,777 M 33,324 34,324 1,538 2,626 419 2,600 22 187 7,391 41,715 Liquor Supervisor Lachance C8G C8G 2,777 M 33,324 34,324 1,538 2,626 419 4,500 22 9,104 43,428 -- -- -- --- -- -- -- - --- - - - - -- - - - -- - -- --- - --- -- --- - - - - -- - ---- -- TOTAL FULL -TIME 122,628 126,307 5,659 9,662 1,541 9,700 66 374 27,002 153,309 STORE #1 PART -TIME HOURS Cashier /Asst Level G 1,600 10.040 H 16,064 16,546 741 1,266 202 2,209 18,755 Clerk Level G 277 8.550 H 2,368 2,439 109 187 30 326 2,765 Clerk Level F 2,850 7.930 H 22,601 23,279 1,043 1,781 284 3,108 26,386 Clerk Level E 100 7.420 H 742 764 34 58 9 102 866 Clerk Level D 280 6.900 H 1,932 1,990 89 152 24 266 2,256 Clerk Level C 100 6.500 H 650 670 30 51 8 89 759 Clerk Level B 1,770 6.250 H 11,063 11,394 510 872 139 1,521 12,916 Clerk Level A 1,575 6.000 H 9,450 9,734 436 745 119 1,299 11,033 - -- -- -- - -- - - - -- - -- - -- -- - --- -- - - -- STORE TOTAL 8,552 64,869 66,815 2,993 5,111 815 8,920 75,735 STORE #2 PART -TIME HOURS Clerk Level G 1,270 8.550 H 10,859 11,184 501 856 136 1,493 12,677 Clerk Level F 4,524 7.930 H 35,875 36,952 1,655 2,827 451 4,933 41,885 Clerk Level E 0 7.420 H 0 0 0 0 0 0 0 Clerk Level D 440 6.900 H 3,036 3,127 140 239 38 417 3,545 Clerk Level C 80 6.500 H 520 536 24 41 7 72 607 Clerk Level B 50 6.250 H 313 322 14 25 4 43 365 Clerk Level A 324 6.000 H 1,944 2,002 90 153 24 267 2,270 STORE TOTAL 6,688 52,546 54,123 2,425 4,140 660 7,225 61,348 STORE 113 PART -TIME HOURS Clerk Level G 2,600 8.550 H 22,230 22,897 1,026 1,752 279 3,057 25,954 Clerk Level F 1,770 7.930 H 14,036 14,457 648 1,106 176 1,930 16,387 Clerk Level E 0 7.420 H 0 0 0 0 0 0 0 Clerk Level D 280 6.900 H 1,932 1,990 89 152 24 266 2,256 Clerk Level C 700 6.500 H 4,550 4,687 210 359 57 626 5,312 Clerk Level B 700 6.250 H 4,375 4,506 202 345 55 602 5,108 Clerk Level A 870 6.000 H 5,220 5,377 241 411 66 718 6,094 STORE TOTAL 6,920 52,343 53,913 2,415 4,124 658 7,197 61,111 ---------------------- -- -------- ----- ---------- - - -`-- - ------ - ------ ---- -- - - - - -- - - - -- --- - -- ---- -- - -- - -- - -- - --- --- TOTAL 292,387 301,158 13,492 23,039 3,674 9,700 66 374 50,345 351,503 store 40 0 0/24/96 CITY OF BROOKLYN CENTER, MINNESOTA DEPARTMENT: LIOUOR RECOMMENDED 1997 WAGES & BENEFITS DEPT. NO, 511 TOTAL COMPENSATION PROJECTION 3.00°0 4142 ANNUAL PERA 4146 4154 4151 4152 4153 TOTAL Increase COORD FICA W/C HEALTH LIFE DENTAL FRINGE TOTAL POSITION EMPLOYEE Projected 4.48 7.65% INSUR INSUR INSUR INSUR BENEFITS COMPENS Liquor Stores Manager Olson 28,830 1,292 2,205 352 2,600 22 187 6,658 35,487 Liquor Supervisor Mueller 0 0 0 0 0 0 0 0 0 Liquor Supervisor Lachance 0 0 0 0 0 0 0 0 0 - - - - - -- - - - - -- - - - - -- - - - -- - - - - -- - - -- - -- - - - - -- - - - - - -- TOTAL FULL -TIME 28,830 1,292 2,205 352 2,600 22 187 6,658 35,487 STORE #1 PART -TIME HOURS Cashier /Asst Level G 1,600 16,546 741 1,266 202 0 0 0 2,209 18,755 Clerk Level G 276 2,439 109 187 30 0 0 0 326 2,765 Clerk Level F 2,850 23,279 1,043 1,781 284 0 0 0 3,108 26,386 Clerk Level E 12 764 34 58 9 0 0 0 102 866 Clerk Level_ D 290 1,990 89 152 24 0 0 0 266 2,256 Clerk Level C 70 670 30 51 8 0 0 0 89 759 Clerk Level B 1,770 11,394 510 872 139 0 0 0 1,521 12,916 Clerk Level A 1,575 9,734 436 745 119 0 0 0 1,299 11,033 STORE TOTAL 8,443 66,815 2,993 5,111 815 8,920 75,735 -------------------------- - - - - -- - - - - - -- - - - - -- - - - - -- - - - -- - - - - -- - - -- - - - -- - - - - -- - - - - - -- 95,645 4,285 7,317 1,167 2,600 22 187 15,578 111,223 store 410 0/24/96 CITY OF BROOKLYN CENTER, MINNESOTA DEPARTMENT: LIQUOR RECOMMENDED 1997 WAGES & BENEFITS DEPT, NO, 511 TOTAL COMPENSATION PROJECTION 3.006 4142 ANNUAL PERA 4146 4154 4151 4152 4153 TOTAL Increase COORD FICA W/C HEALTH LIFE DENTAL FRINGE TOTAL POSITION EMPLOYEE Projected 4.480 7.656 INSUR, INSUR INSUR INSUR BENEFITS COMPENS Liquor Stores Manager Olson 14,415 646 1,103 176 0 0 0 1,924 16,339 Liquor Supervisor Mueller 34,324 1,538 2,626 419 2,600 22 187 7,391 41,715 Liquor Supervisor LaChance 0 0 0 0 0 0 0 0 0 - - - - - -- - - - - -- - - - - -- - - - -- - - - - -- - - -- - - - -- - - - - -- - - - - - -- TOTAL FULL -TIME 48,739 2,183 3,729 595 2,600 22 187 9,316 58,054 STORE #2 PART -TIME HOURS Clerk Level G 1,270 11,184 501 856 136 0 0 0 1,493 12,677 Clerk Level F 4,770 36,952 1,655 2,827 451 0 0 0 4,933 41,885 Clerk Level E 0 0 0 0 0 0 0 0 0 0 Clerk Level D 440 3,127 140 239 38 0 0 0 417 3,545 Clerk Level C 80 536 24 41 7 0 0 0 72 607 Clerk Level B 50 322 14 25 4 0 0 0 43 365 Clerk Level A 325 2,002 90 153 24 0 0 0 267 2,270 - - - -- - - - -- - -- - -- -- - - -- - - - - -- STORE TOTAL 6,935 54,123 2,425 4,140 660 7,225 61,348 -------------------------- - - - - -- - - - - - -- - - - - -- - - - - -- - - - -- - - - - -- - - -- - - - -- - - - - -- - - - - - -- 102,861 4,608 7,869 1,255 2,600 22 187 16,541 119,402 store 40 /24/96 CITY OF BROOKLYN CENTER, MINNESOTA DEPARTMENT: LIQUOR RECOMMENDED 1997 WAGES & BENEFITS DEPT, NO. 511 TOTAL COMPENSATION PROJECTION 3.00% 4142 ANNUAL PERA 4146 4154 4151 4152 TOTAL Increase COORD FICA W/C HEALTH LIFE FRINGE TOTAL POSITION EMPLOYEE Projected 4.48% 7.65% INSUR INSUR INSUR BENEFITS COMPENS Liquor Stores Manager Olson 14,415 646 1,103 176 0 0 1,924 16,339 Liquor Supervisor Mueller 0 0 0 0 0 0 0 0 Liquor Supervisor LaChance 34,324 1,538 2,626 419 4,500 22 9,104 43,428 - - - - - -- - - - - -- - - - - -- - - - -- - - - - -- - - -- - - - - -- - - - - -- TOTAL FULL -TIME 48,739 2,183 3,729 595 4,500 22 11,029 59,767 STORE #3 PART -TIME HOURS Clerk Level G 2,600 22,897 1,026 1,752 279 0 0 3,057 25,954 Clerk Level F 1,770 14,457 648 1,106 176 0 0 1,930 16,387 Clerk Level E 0 0 0 0 0 0 0 0 0 Clerk Level D 150 1,990 89 152 24 0 0 266 2,256 Clerk Level C 620 4,687 210 359 57 0 0 626 5,312 Clerk Level B 660 4,506 202 345 55 0 0 602 5,108 Clerk Level A 870 5,377 241 411 66 0 0 718 6,094 STORE TOTAL 6,670 53,913 2,415 4,124 658 7,197 61,111 -------------------------- - - - - -- - - - - - -- - - - - -- - - - - -- - - - -- - - - - -- - - - - - -- - - - - - -- 102,652 4,599 7,853 1,252 4,500 22 18,226 120,878 0 CITY OF BROON CENTER 0 MANAGER RECOMD BUDGET WORKSHEET BY DIVISION 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED DIV HUMBOLDT LIQUOR 651 4100 WAGES OF REGULAR EMPLOYEES 19,092 19,916 28,300 14,740 28,830 28,830 4112 OVERTIME OF REGULAR EMPLOYEES 194 0 0 12 0 0 4130 WAGES OF PART-TIME EMPLOYEES 59,386 59,473 61,400 42,914 66,815 66,815 4131,OVERTIME OF PART-TIME EMPLOYEE 41 0 0 0 0 0 4133 VACATION PAY 3,989 4,325 0 3,336 0 0 4134 HOLIDAY PAY 2,011 2,400 0 1,246 0 0 4135 SICK LEAVE PAY 2,364 3,314 0 204 0 0 4199 SALARIES REIMBURSED 15,608 15,000 11,700 7,792 0 0 SALARIES AND WAGES TOTAL 102,684 104,427 101,400 70,243 95,645 95,645 4142 PERA COORDINATED PLAN 3,045 3,089 4,000 2,069 4,285 4,285 4143 PERA POLICE & FIRE PLAN 22 0 0 0 0 0 4146 FICA 6,467 6,859 7,000 4,737 7,317 7,317 4151 HEALTH INSURANCE 2,913 1,123 3,840 749 2,600 2,600 4152 LIFE INSURANCE 20 10 22 7 22 22 4153 DENTAL INSURANCE 262 136 360 85 187 187 4154 WORKERS COMPENSATION INSURANCE 1,409 1,447 1,500 817 1,167 1,167 4158 DISABILITY INSURANCE 0 0 0 177 0 0 FRINGE BENEFITS TOTAL 14,138 12,664 16,722 8,640 15,578 15,578 4210 OFFICE SUPPLIES 96 49 200 0 200 200 4217 PAPER SUPPLIES 0 0 500 0 500 500 CITY OF BROO& CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 2 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4220 OPERATING SUPPLIES 2,185 2,885 2,000 1,994 2,000 2,000 4223 CLEANING SUPPLIES 0 188 0 0 0 0 4230 REPAIR & MAINTENANCE SUPPLIES 334 588 500 164 750 750 4231 EQUIPMENT PARTS 0 0 0 80 0 0 4233,BUILDING REPAIR SUPPLIES 0 170 250 86 1,000 1,000 4241 LAUNDRY 103 107 100 91 100 100 SUPPLIES TOTAL 2,719 3,986 3,550 2,414 4,550 4,550 4310 PROFESSIONAL SERVICES 50 997 0 0 0 0 4312 LEGAL SERVICES 0 66 0 0 0 0 4313 AUDIT & FINANCIAL SERVICES 1,020 1,036 1,077 1,064 825 825 CONSULTING TOTAL 1,070 2,100 1,077 1,064 825 825 4322 TELEPHONE SERVICES 1,527 1,653 1,620 1,119 1,650 1,650 4340 ADVERTISING 0 100 0 0 0 0 4346 ADVERTISING - PRINT 720 526 500 506 1,000 1,000 COMMUNICATIONS TOTAL 2,248 2,279 2,120 1,625 2,650 2,650 4380 REPAIR & MAINTENANCE 312' 447 250 820 1,235 1,235 4382 EQUIPMENT REPAIR & MAINTENANCE 850 149 1,000 1,022 1,000 1,000 4383 BUILDINGS REPAIRS 130 0 500 0 1,000 1,000 4388 ELECTRICAL REPAIRS 125 0 0 0 500 500 4393 EQUIPMENT RENTALS 144 144 150 12 0 0 CITY OF BRON CENTER MANAGER- RECOMD BUDGET WORKSHEET BY DIVISION Page 3 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4397 LOGIS CHARGES 6,546 2,220 1,345 1,035 1,924 1,924 4398 PROTECTIVE SERVICES 410 410 410 274 410 410 REPAIR, RENTAL, & MAINTENANCE TOTAL 8,518 3,370 3,655 3,163 6,069 6,069 4400 OTHER CONTRACTUAL SERVICES 2,262 419 2,000 152 2,000 2,000 4401 CREDIT CARD FEES 0 469 400 329 450 450 4402 UNCOLLECTABLE CHECKS 234 468 150 126 400 400 4403 CASH OVER AND SHORT 511 804 250 715 300 300 4405 CHECK VERIFICATION FEES 2,084 1,912 2,000 1,284 2,000 2,000 4410 MISCELLANEOUS 179 179 250 89 250 250 4411 CONFERENCES AND SCHOOLS 29 0 50 0 50 50 4412 MEETING EXPENSES 8 0 0 0 0 0 4413 DUES & SUBSCRIPTIONS 0 160 100 205 100 100 4414 LICENSES, TAXES, & FEES 83 123 200 83 200 200 OTHER CONTRACTUAL SERVICES TOTAL 5,391 4,534 5,400 2,983 5,750 5,750 4440 FUEL CHARGES 85 83 68 43 82 82 4441 FIXED CHARGES 882 967 1,026 677 659 659 4442 REPAIR & MAINTENANCE CHARGES 94 157 133 88 159 159 4443 MULTI -USE HOURLY CHARGES 0 93 0 45 32 32 CENTRAL GARAGE RENTAL RATES TOTAL 1,061 1,299 1,227 853 932 932 4461 GENERAL LIABILITY INSURANCE 425 818 475 468 840 840 CITY OF BROOIDN CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 4 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4462 PROPERTY INSURANCE 377 355 375 184 390 _ 390 4463 BOILER & MACHERY INSURANCE 0 0 0 65 70 70 4469 LIQUOR LIABILITY INSURANCE 3,310 2,962 3,350 1,923 3,738 3,738 INSURANCE TOTAL 4,112 4,135 4,200 2,640 5,038 5,038 4481 ELECTRIC SERVICE 6,951 7,555 7,000 4,483 7,500 7,500 4482 GAS SERVICE 559 563 600 433 750 750 4484 WATER SERVICE 239 244 300 39 300 300 4485 SANITARY SEWER SERVICE 485 454 600 85 600 600 4487 SOLID WASTE DISPOSAL 267 273 300 283 250 250 4488 STORM WATER DRAINAGE 161 177 180 93 150 150 i UTILITIES TOTAL 8,661 9,266 8,980 5,416 9,550 9,550 4550 FURNITURE & FIXTURES 750 0 0 0 0 0 � 4551 OFFICE FURNITURE & EQUIPMENT 548 110 0 490 0 0 4552 OTHER EQUIPMENT 649 0 0 984 0 0 CAPITAL OUTLAYS TOTAL 1,947 110 0 1,474 0 0 I 4611 INTEREST 14,491 12,639 10,622 6,180 6,936 6,936 DEBT SERVICE TOTAL 14,491 12,639 10,622 6,180 6,936 6,936 4702 ADMINISTRATIVE SERVICE TRANS 0 0 0 0 9,085 9,085 TRANSFERS TO OTHER FUNDS TOTAL 0 0 0 0 9,085 9,085 CITY OF BROON CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 5 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4800 INVENTORY VARIANCES 1,781 2,758 1,200 574 1,200 1,200 4801 MERCHANDISE BREAKAGE 0 113 250 90 250 250 4802 DELIVERY CHARGE COST OF SALES 2,154 2,546 2,200 1,742 2,500 2,500 4821 LIQUOR COST OF SALES 187,025 195,461 196,350 111,558 208,040 208,040 4822, WINE COST OF SALES 50,655 51,967 53,900 31,128 57,305 57,305 4823 BEER COST OF SALES 326,301 328,801 345,540 188,490 349,200 349,200 4824 NON TAX MIX COST OF SALES 3,743 4,496 4,260 1,871 4,266 4,266 4825 TAXABLE MIX COST OF SALES 7,379 6,946 7,810 4,670 7,766 7,766 4826 MISCELLANEOUS COST OF SALES 19,636 18,722 19,320 11,348 19,908 19,908 I COST OF SALES TOTAL 598,674 611,809 630,830 351,471 650,435 650,435 4920 DEPRECIATION EXPENSE 7,715 10,398 12,000 6,441 11,600 11,600 4995 CONTINGENCY ACCOUNT 0 0 2,500 0 3,000 3,000 OTHER EXPENDITURES TOTAL 7,715 10,398 14,500 6,441 14,600 14,600 HUMBOLDT LIQUOR TOTAL 773,428 783,014 804,283 464,607 827,643 827,643 I CITY OF BROAN CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 6 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED - - - - -- -------- - - - - -- ------- - - - - -- DIV BOULEVARD LIQUOR 652 4100 WAGES OF REGULAR EMPLOYEES 40,488 39,792 44,000 28,159 48,739 48,739 4112 OVERTIME OF REGULAR EMPLOYEES 0 12 0 23 0 0 4130 WAGES OF PART -TIME EMPLOYEES 50,209 50,867 51,000 34,878 54,123 54,123 4131,OVERTIME OF PART -TIME EMPLOYEE 0 0 0 36 0 0 4133 VACATION PAY 1,898 2,066 0 2,162 0 0 4134 HOLIDAY PAY 1,388 1,490 0 760 0 0 4135 SICK LEAVE PAY 717 747 0 127 0 0 4199 SALARIES REIMBURSED 17,036 15,000 11,700 7,792 0 0 SALARIES AND WAGES TOTAL 111,736 109,975 106,700 73,938 102,862 102,862 4142 PERA COORDINATED PLAN 3,394 3,365 3,700 2,534 4,608 4,608 I 4146 FICA 7,099 7,182 7,500 5,016 7,869 7,869 i 4151 HEALTH INSURANCE 2,246 2,807 3,840 1,872 2,600 2,600 4152 LIFE INSURANCE 20 26 22 17 22 22 4153 DENTAL INSURANCE 262 341 360 211 187 187 4154 WORKERS COMPENSATION INSURANCE 1,617 1,646 1,700 860 1,255 1,255 FRINGE BENEFITS TOTAL 14,638 15,367 17,122 10,510 16,541 16,541 4210 OFFICE SUPPLIES 360 -119 200 0 200 200 4217 PAPER SUPPLIES 0 0 500 0 500 500 4220 OPERATING SUPPLIES 2,661 3,995 2,000 1,547 2,000 2,000 4226 CHEMICAL PRODUCTS 0 87 0 0 0 0 CITY OF BRAIN CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 7 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4230 REPAIR & MAINTENANCE SUPPLIES 355 357 500 0 500 Soo 4233 BUILDING REPAIR SUPPLIES 0 500 250 621 500 Soo 4241 LAUNDRY 22 17 100 16 100 100 SUPPLIES TOTAL 3,398 4,837 3,550 2,185 3,800 3,800 4310 PROFESSIONAL SERVICES 339 605 0 0 0 0 4312 LEGAL SERVICES 0 66 0 0 0 0 4313 AUDIT & FINANCIAL SERVICES 1,020 1,036 1,077 1,064 825 825 CONSULTING TOTAL 1,359 1,707 1,077 1,064 825 825 4322 TELEPHONE SERVICES 1,571 1,455 1,500 979 1,500 1,500 4340 ADVERTISING 2,201 100 1,000 0 1,000 1,000 4346 ADVERTISING - PRINT 1,651 1,334 1,000 1,661 1,000 1,000 COMMUNICATIONS TOTAL 5,423 2,889 3,500 2,640 3,500 3,500 4380 REPAIR & MAINTENANCE CONTRACT 0 319 250 820 1,235 1,235 4382 EQUIPMENT REPAIR & MAINTENANCE 24 148 1,000 261 1,000 1,000 4388 ELECTRICAL REPAIRS 584 0 0 0 0 0 4393 EQUIPMENT RENTALS 144 144 150 12 150 150 4397 LOGIS CHARGES 7,117 2,504 1,345 1,035 1,924 1,924 4398 PROTECTIVE SERVICES 208 208 210 138 210 210 REPAIR, RENTAL, & MAINTENANCE TOTAL 8,078 3,323 2,955 2,267 4,519 4,519 4400 OTHER CONTRACTUAL SERVICES 1,915 363 2,000 182 2,000 2,000 CITY OF BROC& CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 8 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4401 CREDIT CARD FEES 0 538 400 365 - 450 450 4402 UNCOLLECTABLE CHECKS 380 471 200 210 275 275 4403 CASH OVER AND SHORT -15 1,380 250 154 250 250 4405 CHECK VERIFICATION FEES 2,375 2,178 2,000 1,045 2,0.00 2,000 4410,MISCELLANEOUS 342 196 250 98 250 250 4411 CONFERENCES AND SCHOOLS 29 0 50 0 50 50 4412 MEETING EXPENSES 8 0 0 0 0 0 4413 DUES & SUBSCRIPTIONS 457 160 100 205 100 100 4414 LICENSES, TAXES, & FEES 83 123 200 83 200 200 4421 JANITORIAL SERIVICE 0 88 0 168 0 0 OTHER CONTRACTUAL SERVICES TOTAL 5,573 5,497 5,450 2,511 5,575 5,575 4440 FUEL CHARGES 85 83 69 43 83 83 I 4441 FIXED CHARGES 882 967 1,027 677 660 660 4442 REPAIR & MAINTENANCE CHARGES 94 157 134 88 160 160 4443 MULTI -USE HOURLY CHARGES 0 0 0 45 32 32 CENTRAL GARAGE RENTAL RATES TOTAL 1,061 1,207 1,230 853 935 935 4461 GENERAL LIABILITY INSURANCE 425 818 475 468 840 840 i 4462 PROPERTY INSURANCE 395 347 365 208 375 375 I 4463 BOILER & MACHERY INSURANCE 0 0 0 63 70 70 4469 LIQUOR LIABILITY INSURANCE 3,725 3,670 4,125 2,166 4,043 4,043 CITY OF BROO& CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 9 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED INSURANCE TOTAL 4,545 4,836 4,965 2,904 5,328 5,328 4481 ELECTRIC SERVICE 4,997 5,369 4,500 3,513 4,500 4,500 4482 GAS SERVICE 1,575 1,602 2,000 1,167 2,250 2,250 4484 WATER SERVICE 16 16 20 8 20 20 c 4485 SANITARY SEWER SERVICE 63 63 60 32 60 60 4487 SOLID WASTE DISPOSAL 257 257 350 171 250 250 UTILITIES TOTAL 6,908 7,308 6,930 4,891 7,080 7,080 4550 FURNITURE & FIXTURES 480 0 0 0 0 0 4551 OFFICE FURNITURE & EQUIPMENT 600 3 0 430 0 0 4552 OTHER EQUIPMENT 0 0 0 984 0 0 CAPITAL OUTLAYS TOTAL 1,080 3 0 1,414 0 0 4702 ADMINISTRATIVE SERVICE TRANS 0 0 0 0 9,657 9,657 TRANSFERS TO OTHER FUNDS TOTAL 0 0 0 0 9,657 9,657 4800 INVENTORY VARIANCES 168 -813 750 -95 750 750 4801 MERCHANDISE BREAKAGE 0 115 250 121 250 250 4802 DELIVERY CHARGE COST OF SALES 2,929 2,865 2,500 1,889 2,800 2,800 4821 LIQUOR COST OF SALES 221,104 220,898 236,250 120,416 231,816 231,816 4822 WINE COST OF SALES 64,493 70,358 70,700 42,882 73,440 73,440 4823 BEER COST OF SALES 354,038 331,756 355,290 194,024 349,200 349,200 4824 NON TAX MIX COST OF SALES 3,620 4,082 3,925 2,009 4,266 4,266 S CITY OF BROON CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 10 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4825 TAXABLE MIX COST OF SALES 8,379 9,858 8,310 5,855 9,178 9,178 4826 MISCELLANEOUS COST OF SALES 23,818 26,964 22,770 18,342 28,440 28,440 COST OF SALES TOTAL 678,548 666,082 700,745 385,443 700,140 700,140 4920 DEPRECIATION EXPENSE 2,747 4,839 6,400 2,870 5,580 5,580 P 4922 LOSS ON FIXED ASSET DISPOSAL 551 0 0 0 0 0 4995 CONTINGENCY ACCOUNT 0 0 2,500 0 3,000 3,000 OTHER EXPENDITURES TOTAL 3,298 4,839 8,900 2,870 8,580 8,580 -- --- - - - - -- --- - -____ BOULEVARD LIQUOR TOTAL 845,644 827,869 863,124 493,488 869,342 869,342 CITY OF BROGAN CENTER • MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 11 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED - - - - - -- -------- - - - - -- ------- - - - - -- DIV NORTHBROOKL LIQUOR 653 4100 WAGES OF REGULAR EMPLOYEES 35,882 40,760 43,750 28,147 48,740 48,740 4130 WAGES OF PART -TIME EMPLOYEES 49,571 47,105 50,100 31,664 ,6 4 53,913 53,913 4133 VACATION PAY 1,976 1,926 0 2,290 0 0 4134, HOLIDAY PAY 1,388 1,490 0 760 0 0 4135 SICK LEAVE PAY 3,752 539 0 0 0 0 4199 SALARIES REIMBURSED 18,356 15,000 11,700 7,792 0 0 SALARIES AND WAGES TOTAL 110,924 106,820 105,550 70,654 102,653 102,653 4142 PERA COORDINATED PLAN 3,315 3,236 3,500 2,146 4,599 4,599 4146 FICA 6,844 6,761 7,135 4,623 7,853 7,853 4151 HEALTH INSURANCE 3,840 4,581 3,840 3,174 4,500 4,500 4152 LIFE INSURANCE 20 26 22 17 22 22 4153 DENTAL INSURANCE 0 68 360 42 0 0 4154 WORKERS COMPENSATION INSURANCE 1,521 1,576 1,600 816 1,252 1,252 4156 UNEMPLOYMENT COMPENSATION 0 1 0 5 0 0 FRINGE BENEFITS TOTAL 15,540 16,249 16,457 10,824 18,226 18,226 4210 OFFICE SUPPLIES 0 49 200 0 200 200 4217 PAPER SUPPLIES 0 0 500 0 500 500 4220 OPERATING SUPPLIES 1,871 3,077 2,000 1,534 2,000 2,000 4230 REPAIR & MAINTENANCE SUPPLIES 391 823 250 0 500 500 4233 BUILDING REPAIR SUPPLIES 0 113 0 11 0 0 CITY OF BROOON CENTER • MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 12 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4241 LAUNDRY 172 178 150 151 150 150 SUPPLIES TOTAL 2,435 4,240 3,100 1,696 3,350 3,350 4310 PROFESSIONAL SERVICES 50 260 0 0 0 0 4312 LEGAL SERVICES 100 66 0 0 0 0 t 4313 AUDIT & FINANCIAL SERVICES 1,020 1,036 1,077 1,064 825 825 CONSULTING TOTAL 1,170 1,362 1,077 1,064 825 825 4322 TELEPHONE SERVICES 1,548 1,537 1,550 1,038 1,575 1,575 4340 ADVERTISING 0 100 0 0 0 0 4346 ADVERTISING - PRINT 420 526 500 508 1,000 1,000 COMMUNICATIONS TOTAL 1,968 2,163 2,050 1,547 2,575 2,575 4380 REPAIR & MAINTENANCE CONTRACT 216 372 250 820 1,235 1,235 I 4382 EQUIPMENT REPAIR & MAINTENANCE 24 1,021 1,000 202 1,000 1,000 4383 BUILDINGS REPAIRS 86 0 0 0 0 0 4388 ELECTRICAL REPAIRS 408 0 0 408 250 250 4392 BUILDING RENTALS 35,410 32,584 37,000 26,934 37,000 37,000 4393 EQUIPMENT RENTALS 144 144 150 12 0 0 4397 LOGIS CHARGES 7,682 2,751 1,345 1,035 1,924 1,924 4398 PROTECTIVE SERVICES 545 547 550 349 550 550 REPAIR, RENTAL, & MAINTENANCE TOTAL 44,515 37,419 40,295 29,759 41,959 41,959 4400 OTHER CONTRACTUAL SERVICES 2,103 107 2,000 0 2,000 2,000 • CITY OF BRAN CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 13 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED -------- - - - - -- -------- - - - - -- -------------- ------------- 4401 CREDIT CARD FEES 0 589 425 466 475 475 4402 UNCOLLECTABLE CHECKS 545 476 250 259 400 400 4403 CASH OVER AND SHORT 204 -36 100 -23 300 300 4405 CHECK VERIFICATION FEES 1,611 1,738 1,500 1,080 1,500 1,500 4410, MISCELLANEOUS 196 196 250 98 250 250 4411 CONFERENCES AND SCHOOLS 29 0 50 0 50 50 4412 MEETING EXPENSES 8 0 0 0 0 0 4413 DUES & SUBSCRIPTIONS 0 160 100 205 100 100 4414 LICENSES, TAXES, & FEES 83 123 200 83 200 200 4421 JANITORIAL SERIVICE 0 0 0 158 0 0 OTHER CONTRACTUAL SERVICES TOTAL-- 4,778- 3,353 4,875 2,325 5,275 5,275 4440 FUEL CHARGES 85 83 69 43 83 83 4441 FIXED CHARGES 882 967 1,027 677 660 660 4442 REPAIR & MAINTENANCE CHARGES 94 157 134 88 160 160 4443 MULTI -USE HOURLY CHARGES 0 0 0 0 32 32 CENTRAL GARAGE RENTAL RATES TOTAL 1,061 1,207 1,230 808 935 935 4461 GENERAL LIABILITY INSURANCE 425 818 475 468 840 840 4462 PROPERTY INSURANCE 200 182 210 148 215 215 4463 BOILER & MACHERY INSURANCE 0 0 0 35 40 40 4469 LIQUOR LIABILITY INSURANCE 4,037 3,969 4,000 2,462 4,704 4,704 • CITY OF BROOK CENTER MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 14 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED INSURANCE TOTAL 4,662 4,970 4,685 3,113 5,799 5,799 4481 ELECTRIC SERVICE 5,532 6,064 6,000 3,941 6,000 6,000 4482 GAS SERVICE 754 657 1,000 541 1,000 1,000 4484 WATER SERVICE 113 117 200 0 200 200 4487 SOLID WASTE DISPOSAL 267 273 350 283 250 250 UTILITIES TOTAL 6,666 7,110 7,550 4,765 7,450 7,450 4550 FURNITURE & FIXTURES 380 0 0 0 0 0 4551 OFFICE FURNITURE & EQUIPMENT 52 424 0 0 0 0 4552 OTHER EQUIPMENT 433 0 0 984 0 0 CAPITAL OUTLAYS TOTAL 865 424 0 984 0 0 4702 ADMINISTRATIVE SERVICE TRANS 0 0 0 0 11,342 11,342 TRANSFERS TO OTHER FUNDS TOTAL 0 0 0 0 11,342 11,342 4800 INVENTORY VARIANCES 500 770 600 573 600 600 4801 MERCHANDISE BREAKAGE 0 52 250 75 250 250 4802 DELIVERY CHARGE COST OF SALES 2,965 3,161 2,500 2,094 2,800 2,800 4821 LIQUOR COST OF SALES 234,711 236,504 236,500 140,883 252,620 252,620 4822 WINE COST OF SALES 62,324 67,809 67,340 38,695 73,440 73,440 4823 BEER COST OF SALES 398,216 409,630 435,395 261,176 434,560 434,560 4824 NON TAX MIX COST OF SALES 4,333 4,418 4,595 2,227 4,977 4,977 4825 TAXABLE MIX COST OF SALES 10,768 10,110 11,040 6,334 10,590 10,590 • CITY OF BROO *N CENTER • MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 15 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED 4826 MISCELLANEOUS COST OF SALES 31,485 32,834 32,155 22,856 35,550 35,550 COST OF SALES TOTAL 745,301 765,288 790,375 474,913 815,387 815,387 4920 DEPRECIATION EXPENSE 5,254 4,808 6,400 2,904 5,900 5,900 4995 CONTINGENCY ACCOUNT- 0- 0 2,500 0 3,000 3,000 OTHER EXPENDITURES TOTAL 5,254 4,808 8,900 2,904 8,900 8,900 NORTHBROOKL LIQUOR TOTAL 94S,139 955,413 986,144 605,356 1,024,676 1,024,676 I i • CITY OF BRAN CENTER • MANAGER RECOMD BUDGET WORKSHEET BY DIVISION Page 16 1997 BUDGET 1996 1997 1997 Object Code & Description 1994 1995 ADOPTED AS OF DEPT MANAGER Division Code & Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED RECOMMENDED DIV UNDEFINED 999 4700 PERMANENT TRANSFERS 14,549 0 0 0 0 0 4701 TRANSFERS TO GENERAL FUND 100,000 100,000 100,000 0 100,000 100,000 TRANSFERS TO OTHER FUNDS TOTAL 114,549 100,000 100,000 0 100,000 100,000 Q UNDEFINED TOTAL 114,549 100,000 100,000 0 100,000 100,000 LIQUOR STORES FUND TOTAL 2,678,759 2,666,296 2,753,551 1,563,451 2,821,661 2,821,661 I I I I • • C ITY OF LIROOKL,�i'G117'I3R f4AIIAGBR RP:C'OMD BUDGET WORKSIIGF3'I' 11Y I)lVlS10f'I I'ayr 1'7"2. 1997 BUDGE'"T 1996 1997 1997 object Code G Descripei.o)1 1994 1095 ADOPTED AS OF DEPT MANAGER Divisi011 Coc.ic r;. Description ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED R00014141•:NDI•:D I)IV kI:CYCI,IfJG F11ND 665 1220 OPERATING SOPPL.II:S - - - 554 -- - - - - 0 -- 60 0 — 0 700 700 ;1) PP1,II,S TOTA1, 554 0 600 0 700 700 1391 1,()(; P; C'IIARGI {!; G, 000 G,000 lU, 0(1U 6,, f,f,4 l. U, 0011 111, 000 -- - - -- - - - -- ... -- - - - --- -- - - -- -- -- I:hl'A1R, RRNTAI,, 1, MAII)'I'II.NANCE 'TOTAL 6,000 G,000 10,000 6, l O, 00(1 10, 000 1.100 O'1 ('011TRAC" IJAI, SFRV [CI; S 111, 44'7 7.08, 90H - ,209 139 573 209,000 209, UOO OTHER CONTRACI'UAI, SI :ItV ICI :S TOTAL 111 , 447 208, 9011 209,000 139,573 229, O00 20 ot0 1.161 C;ENERAI, I.IABfl.lTY INSURANCE? 87 1 - 308 _ 400 2 86 300 300 IIISURAIWE, 'I'OTA1, 877. 308 400 286 300 300 PECYCLING FUND TOTAI, 110,072 2.15, 216 220,000 146,522 220,000 221), UOO i IV; AND PE FOSE F OUD TOTAL, 1.18, 872 215,216 220,000 146, 522 220,000 220,000 , CITY OF BROOKLrIT EN-I R 14AHMER RRCOI.ID BUDGET NIORKS11EET BY IJTVTSIUt1 Page 173 1.997 BIJDGFT "bjeCt Code T, I)e ^cript: ion 1996 1997 199'1 1994 1995 ADOPTrD AS OF DEPT 1•inWAC;Eft -- Division - Code -h- Description ACTUAL ACTUAL, DUr)(.E'1 Up/31/96 REQUGSTE'D RE( :Ot•it4EtJD1:O I(IV WA'T'ER FACILITY t4AItT'I'EtJAITCE 6'/U 1 100 WAGES OF REGULAR I7r4PI,OYI31,S 22, 612 32, 837 28,678 19,398 72,902 '12,902 11 12 OVERTIMP OF RI ?(,III,AR E341 5, 829 6, 2, 318 4, 177 3, 846 1, 846 1130 WAGES I ' I'AIZ•1'-'1'11 I1.111I,OYf?r;S 4 1.p 92 412 1.,2 6 54 - -- -- --- - - -- - - _ 9 , 476 9 ' ' 176 A(,AR 11'.S Atli) I TOTA1, ' = = = 78 = 859 40, 654 31, 408 24, 228 86,224 8r,, 77.1 1 14 1 PERA HAS, I C P1,AIJ 4 24 0 ( 1 PEIZn t :UUItD i IIA'I'lil> PLAIJ l , 2 1, .15 1,40'7 1,056 3,863 1,861 146 F1 CA 2, 164 3,043 2,4113 ],836 6,596 6,506 1 S1 HEALTH INSURANCE, 0 1,423 2,640 2, 278 8,640 8,f,4 1J 1157. LIFE I11S11RAMC E D 10 20 16 44 44 153 DENTAI, INSURANCE 0 63 317 91 360 160 154 WURKERS COMPENSATION 111SURANCE 823 1, "15F, 1, 339 "7 73 - - - -- - - -- - - -- - 2, 633 -2, G P ItIGE 81?•tJl•:FITS 'TOTAL. 4, 263 11, 0.13 8,126 6,050 22,136 22, 1 36 '120 OPERATING SUPPLIES 38 4,702 1,000 41 3,000 3,000 7.3 CLEA111th; St1PP1,11• :S 0 0 50 0 50 ;0 '."1.6 (:IIEMIC'AI, PRODUCTS 0 q ]o,000 5 11 (1 727 SAFFTY SUPPLIES 3'171 0 380 0 U 0 ,'-30 REPAIR G MAII)TENANCL SUPPLIES 5,448 1,232 5,500 773 is - loo 15, 71)11 11 EQU I PME11 PARTS 0 20 0 (J 0 0 '11 BUILDUP REPAIR SUPPLIES 238 636 2,400 140 2, 2,400 14 S' IM-r MAINTETI LICE MATERIALS 0 5,309 0 0 0 n CL'J'Y OF 131 {OOKLy9c'ts'tl'I'IiR MAI1AGER REC014D BUDGET WORKSHEET BY DIVISION Page 1'14 1997 11UD(3 E'1' 1996 199 1 011'1 )Itject C'<ul, k Uescrillt -)Olt 1999 1995 ADOP'1'I•:D AS OF DEPT 11ANAGI:R Division Code & DescripCiOn ACTIJAI, AC9'l1AI, Hl1UGli'!' 00 /31/96 RI:QIJES'('ED RI {C))ftI11:NDI:D 47.43 ITIA TY SYS'1'E1.1 SIJPPI.,IES - - - - 3§0 -- - -- 32 - - -95 4,4 04 0 0 !O)PPI,IL•'S TOTAL, 6,499 11, 932 19,425 5, 364 21,150 21,150 •1351 LEGAL 110'I'10E PU13LICATIOtl —` 0 _ —_- 0 - 250 0 0 0 ''(!t•111UNICATION S TOTAL 0 0 250 0 0 0 4 1110 REPAIR 1. MAINTENANCE, COUITPACf' 2,19G (1 2 , 260 0 0 0 •1142 EQUIP11E11T REPAIR & MAMTEIJAl10E 0 0 500 2,05 3,'110 3,770 1103 11111LUINGS I?EI'AIRS _ - 1 1 690 30 6,000 0 2,200 2,2U11 PEA'A1R, RENTAL, & MAINTEIIANCF. TOTA1, 3,88r, 30 6, - /Go 2,057 5,970 ';,'1'111 •1400 OTHER CONTRAC TIJAI, SERVICES 7, 513 26,362 0, 930 1,480 0 0 -1114 LICENSES, 'TAXES, & FEI S 5, 147 5,718 6,000 5,'14'1 0 0 ()T HER CON'T'RACTUAL SERVICES TOTA1, 12,660 32,000 14,930 7, 22 0 0 1440 FI)E1, CHARGES 0 8 0 7 0 I1 1.141 FIXED CHARGES 0 5J9 510 345 0 0 1442 REPAIR & MA I NTEIIANCE CHARGES 0 90 2'70 20 0 0 ' l 143 14111-TI OSE II(MRI.Y CIIARGI S G, 38 1.3,'!511 8,350 5,131 0 Il 'fal'1'RAL, GARAGi? REN'T'AL, RATES TOTA1, 6, 31) 1 14,366, 9, 1 38 5,503 0 (1 1.181 ELECTRIC S;1:RVICE 13 ©,960 140,536 55,211. 99,21.2 145,0113 145,R(33 1 GAS SERVICE 4,488 4,402 0 3,274 5,511'1 5,!)111 11114 WATER SERVICE. 30 0 0 0 0 0 CITY OF BROURLY10311TE:R MANMGE:R RECOMD BUDGET WORKSIIEE'P BY DIVIS10I1 Paw! 775 1997 BUDGET 1996 1997 1997 I je(C Cod b Uescriht_ion 1994 1995 ADOPTED AS OF DEPT MANAGEI( Divi S i oll Code 6 Description ACTIJAI, ACTUAL, B(IDG ET 08/31/96 RE I ?E J141.11• :111)1 ?1) 1 SANITARY SEWER SERVICE 1.70 170 0 85 76G 766 Mill STORM WATER DRIIIIIAGE - 7 , E3-1 1 - -__ 3,_096 0 1,624 3_000 3, 000 ')TILI'1'IES TOTA1, 196,472 198,204 55,2.11. 109,195 155,236 1!i'i,23(1 1',60 CON S7'Rl1CTJOff CONTRACTS -.-- 5, 987 25,()00 17,060 11,500 1 7 , SllO 'APITAI, OIJULAYS TO 14,590 5, 487 2f>, 000 1 0GO 7 1 , 500 1 1 ,'i00 1 O20 DEPPEC1ATIOrI EXIT {riSls 0 66,210 69, 440 0 !i'7, 000 Yl, 000 1422 LOSS Off FIXED A SSF-l' DISPOSAL, 0 494 0 0 0 — 0 HIER f:Y.PE:NUl'1'lli'.L:S TOTA1, 0 66,'104 69,440 0 5 - 7,000 5'1,()()0 IATEIR FACILITY MAINTEIIIANCE TOTA1, 223,615 327, 2 , 688 7'11., 684 359, 2.16 3511, 216 i CITY OF IIIZ(�OKI,0ci-,u'rL :R MANAGER RECOMU BODGET l'IORYSIIEET BY DIVTSIOIJ 1997 BUDGET 1996 1997 1997 ')hject. Cori,:! f, Uescripti.on 1994 . 1995 ADOPTED AS OF DEPT l4 /VJACIi1Z - -- Di vision - Code & - Descript: iolt ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED ItF:CCN1t1l;NNh:f) UIV 6fA'1'Eft O!'! ?RA'!'IONS 6 71 4100 WAGES OF REGULAR El•1PI,OYEI' %S 102,699 110,672 138,'1].9 68,376 114,724 114, •124 •1112 OVERTIME OE' REC;ULAR 1:f1PLOYEI ?S 10,962 12,867 7,726 9,623 0 0 1114 1111 PAY 459 0 0 0 0 0 1 1 30 WAGES OF T'AR'E' -TIME I•3>1Pl,0YI ?I ?S 5, 582 1, 6, 381, 5 8, X03 824 8211 •11 31 OVER'T'IME: OF PART -TIME: I;h1PI,OYBE 0 O 0 6 O 0 � M3 VACA'T'ION PAY 16, 468 14, 764 0 9,292 0 (1 •1 1 34 1101,1 DAY PAY 10, 847 .1.1 , •1.05 0 4 , 929 0 0 11 15 SI('Y. IJ;AVI; PAY - 1,459 11,935 U 3,979 0 U 1 199 SALARIES REIMHURS!'I) 7 - 1, 560 _ - 0 U --- 119 - -c - 3 -- 5 09 _ -- --- ]]5,652 7 G, 040 ! ;ALAIZIES AND WAGES TOTA1, = == 244 = 062 - - 2811 -5(i3 - -- 268 = 483 - - 780 = 748 - - - 115,548 1141 PERA BASIC I'I.AII 6 55 p 0 0 0 1142 PERA COORDINATED PI,AU 6, 722 /, 274 6,H47 4, 322 5, 17'1 1' /7 -1146, FICA 11,663 13,331 11,692 7,910 8,8.19 8,1119 IPiI U[;AI 1'II INSURANCE 19,6113 12, 2 12,661 G, 9G'; 77,240 11,240 115 2 LIFE. II)S11RANCE 142 all 92 48 66 G6 'x11.53 DENTAI. 1NSl11ZANCt' 883 5261 1,501 274 547 x 1 15.1 WORYER S COMPEI)SATIOIJ 111SURANCI, ----- 3, 4 15 - 5 618 G, 240 3, 037 3,582 3, 5132 '1 R IIIGE BEIIEFITS TOTAI, 42,515 39,113 39, 033 22,555 29, 451 29,451 1210 OFF[CI?. SUPPLIES 0 124 50 0 50 50 11. 1 .7. PN.I11 1) FORMS 1,207 1., 4 01 2,000 1,466 2,000 CITY OP irftoOJ:t,Yr! (_;•1Jt'r:rt 0 MANAGER RECOMD BUDGET 1•JORKSIIL'ET I3Y DIVISION 1 99 7 13UI)GE'I' 7.996, 1 997 1 ` +O ,ject Code & Dr sr ril,(.io0 1994 1995 ADOPTED AS Of DEPT hintd/+(;i:R Division Co(le f. Descripti.oll ACTIJAL AC'T'UAL, BUDGET 08/31/96 REQUESTED It IiCO1.1141•JIUED 20 OPERATIM; SIIPPI,IVS 3,641. 3,163 4,890 2,224 4,300 4,300 ).5 SHOP SUPPIA ES 504 28 0 0 0 0 26 CIIEMICA1, PRODUCTS 55, 336 57,310 53, 000 13,249 63,000 C, 3, () O() 27 SAPf;TY S(IPPI,l I?S 803 7 " ").0 1 , 100 163 1,400 l , 400 t0 REVAIR & t•1AItITENANCE SUPPLIES 7,612 11, 571 10,200 5,900 0 0 13 BUILDING PETAIR SUPI'L,fES 0 42 0 126 0 0 J4 STRE'EIT MAIDTI•31ANCE t-1ATE'RIALS 1 , 373 939 3,300 130 0 0 16 SIGIIS & STIPHIG MATERIALS 130 O U 0 0 0 40 SMALL, 'POOLS 888 0 500 46 500 500 43 UT'ILI'TY SYS7'h.l•i SUPPLIES 1_621 __-0 -_ -- 700 0 7 00 700 IT 1,I ES 'I'OT'A►, 73,115 '75,303 75, 740 53,911 71,950 71 , 950 10 PROFESSIONAL SERVICE'S 0 1,560 0 2,540 0 0 12 LE SERVICES 0 148 0 0 0 0 , 13 AUDIT & FINANCIAL., SERVICES 1,2"15 1,295 1, 345 _ 1 ,330 —__ 1, 3 - _ 'rf;Ili;i'IIJ(; TOTAL, 1,275 3, oo I 1,345 3,870 1, 375 1 , 375 2) POSTAGE 14,259 1 18,000 11,158 18,000 lti 3 O(1U )'). '1'lil,l:i'IIOrIE: S {:ItVIC'1:5 591) 632 600 499 632 632 74 DELIVERY SP:RVICIs 0 80 0 0 0 0 14 USE OF PERSONAL AUTO o 18 0 0 0 u A) PR1NTIN(; 0 288 0 U U 0 it LEGAL t!O'I'1(:I: PUBMCA'TIOtl 0 0 0 —_ 0 ^__ 250 _____ 250 CITY OF BROOKIAENTER 0 MANAGER REC0141) BUDGET WORKSHEET BY I)IVJSIOII 1997 BIJDGIi'J' 1996 1997 1 sp97 Object codf! 1, Desci ipt.ioll 1994 1995 ADOPTED AS OF DEPT rtnr�n� l;It Division Code & Description ACTUAI, ACTIJAI, BUDGET 08/31/96 RE:QUES'1'ED RI:('OI4M1•:IJUIa) (_0111•11JNI CAT 1011 S 'I.OTAI, 34,858 1. f3, 11.5 10,600 11,656 18,982 78, 882 •1780 REPAIR & t•1AE11'I'E:IIAIICF CONTRACT 0 435 0 0 0 U 4386 COMI.IUNICATIOil SYSTEM MAINT 1,383 1,219 1,200 '182 0 0 •1397 LOGIS CIIAI',GG :S 10 e- 492 9, f3i5 21., 564 14 ,168 25025 25,025 oe -- - - - - -- - -- - - -- - -- - -- - - -- - l:l:l'AI R, RENTAL, 1< MAIIITENANCE, TOTAL 11,875 11 , 469 22,764 14,950 25,025 4 OTIIER CONTRACTUAL SERVICES 12,105 1 2, 10 16,0 4 , 227 19, 0(10 1 9, 000 1.102 UNCOI.LECI•ABLE C'ItECKS 149 0 0 0 0 (1 1 CONFERIi310ES AND SCIIOOI,S 1, •188 1 , 003 1,600 698 l , 600 1 , (,00 4 4 l 3 DOES & SUBSCRIPTIONS 98 1,667 '100 '15 '100 700 4414 1,I(_Et1SES, TAXES, & 1'EES 46,206 46, 369 46,100 34,774 58,000 50,000 14 1 C LAINS, PAY 1 -1ENT 0 1, 05 1 0 0 0 1) 141'1 BOOKS ACID RI:FEREIICE MATERIALS U 65 SU - - 99 200 200 OTHER COtlTPAC:T(JAI, SERVICES TOTAI, f,(►, 3.17 62,265 64,520 39,072 ' /9,'i00 70, 500 4440 FUEL CIIAIMES 0 20 U 19 13 13 1441 FIXED C'11ARGE S 6, 708 1 , 3.34 1 , 370 886 963 46 S 1442 REPAIR & t• IAIU•1MANCL (:IIARC;i ?S 700 304 715 50 6961 6 1443 MULTI -USE. IIOURI,Y CIfAHGE,S 26, 84.8 36, 109 40,045 17,409 51,836 51 , [136 1 REPLACEMENT CHARGES -_ - - -- U - /5 -- 0 -- -- 0 - - - - - 0 - - - - --- 0 'E11TRAI, C,ARAGE RENTAL, RATES TOTAL 34,256 37, 841 42,070 18, 365 53, 5(18 5 ;u11 1 Cb ;tIERAL 1,IA1311,11T INSURANCE 'l, 907 8, 909 9,1()0 8, 990 9, 100 9, IuU CITY OF 13ROOKIAENTER ( o MANAGER RECOMD MIDGET WORKS11EE1' 13Y DI V IS LOII Pale 1'19 1997 BUDGET 1996 1997 1997 Phiecl Cod- 11 DescripC.ion 1994 1995 ADOPTED AS OP DEPT MANAUFJJ Division Code k Descripl -Aon ACTUAL ACTUAL BUDGET 08/31/96 REQUESTED 10 "CO1 ME'11DED 1 PROPP.RTY INSURANCE 4,370 4,072 4,500 4,164 4,300 4,3 1463 FMILP'R 6 I.1A(:III:RY INSURANCE -_- __ - 0 - - - - -- -_ - -� '133 1,000 1,000 INSURANCE TOTA1, 12,277 12,981 13,600 13,88'7 14,400 14 ` 1.181 FtiLI:('I'Rlt_' SERVICE 1,902 1,G17 90,672 968 0 0 PP 1111r) SANITARY SEWER SERVICE 0 0 766 O 0 0 1487 SOLID WASTE DISPOSAI, _- 58 8 -_ ` 1, 584 36,000 U 0 0 ilI 11,ITI ES TO'I'At, 2,490 3,201 107, 438 968 0 0 1551 OFTICP PURUITURP F EQLJfP14E11'l' 0 457 0 2,360 0 U 1 O'I'LIER IiQI)11'141 ?1!T -- U - -- - U - -- 0 - -- 0 -- 13,430 -- - 13,430 ''APITAL OUTLAYS TOTA1. 0 457 0 2,360 1.3, 430 .1 3, 430 1702 ADM I III STRA'f1VI: SI:RVIC1 TRANS _ 0 0 - 0 0 117, 819 117, 81 9 CRANSFEMS TO OTUER F'UI11)S TOTAL 0 0 0 0 1.1 819 11 4920 DETIZECIATION L•'XPEUSE 2 1 '15,041 - 1 78 ,560 0 1 G5,000 -- 165,000 'I'IIl:It EXPENDI'!'URRS TOTA1, 236,850 175,041 178, 56,0 0 165, 00() r 6'., 000 ':)NH-l*R OPEPATIOU'; TOTA1. 733, 9211 - 127, 3 812,153 363,145 - 105,808 705, 888 CITY OF BROOK1,01-34 ER t1n1lAt;ER RECOMD MIDGET 4lORY.SIIEf;'(' BY DIVIStc)tj facie IRO 1997 BUDGET 1996 1997 199 , )hjert Code 1, Opsci ilwion 1994 1995 ADOPTED AS OP DEPT h1AtJAGER Division Cod,- h Description ACTUAL A/'TOAI, IIUDGIT (1£1/31/96 REQUES•I'ED RECOHMEU "IV 4JA•►•ER CONSTRUCTION PROJECTS 6,72 MM 4lAGES OF REGUI,AR EI•iPLOYI ES 169 O O 0 O p 4112 OVERTIME' OF REGULAR EMPLOYIs[:S - 66 - p ' AND WAGES TOTAL 235 O p p O O -1142 PERM ('OORDINATE'D PLAN ] 1 O p p p 0 .1146 PICA 1R 0 0 0 0 11 11'14 VIORY-ER S COMPEN SATI011 l ISORANCIs - - - -- - - -_ _-- - - -_ -p -_ -- — p - p O O I REIIRPI'I'S '1'O'I'AI' 34 O 0 O -- p - -- - -- - - -�, i 1443 1.11)1;1'1 -USE IIOURLY CHARGES _ 3 — —_ 0 _— O 0 (A-31TRAI, GARAGE RE11TAI, RATES TOTAL, 3 O 0 U 0 p WATER COIIS'1'I?0('I•IUN PRO,JEC'I'S TOTAL 2 O 0 0 It O IC I I I I CITY OF BROOKIAIJTER MANAGER RGC_'OMD BUDGET WORKSHEET BY DIVISION f'at'e 182 1997 RUI)f;G'1' !1>jecC Code k Descri >fior) 1996 1.997 199 I 1994 1995 ADOPTEID Its OF DEPT 1.1AtlMJI;R Divi:;ion Cor.1e & De,cript -ion ACTUAL, ACTUAL I1UDG1:'I' 0©/.31/96 REQUESTED RI'.C'U11hll:IlDI:U Ov 11Nl)I:F[NI;D 999 1100 PERNAM -11T THANSFI.RS —_ 1'17. 2 _ O _- - -_ -- 0 — 0 0 0 RANSFERS TO O FIll,R 1- TOTnL 14-7,022 rl 0 0 - —0 -0 'Q7 � LO ON FIXED ASSET DISPOSAI. 5, 063 0 w FIFER I•:XI'ENDI'fUl(is '1.OTAI, 5,063 0 0 (1 0 u INDETIrn:D TOTA1, 1'.;2,005 0 0 0 0 (1 ATER UT11,ITY FUND TOTAL 1,109,909 1,054,901 1,(173,!)41 534,1129 1,065,104 .1,0cC Io') ill CITY OF 13ROOKLMEWITIR l MA1)AGER RECO(4D RU1)m-:'I' 47ORY.SIIEET By DIViSIUPt I',lcle 183 1997 BUDGET 1996 1997 1991 't,iec t. Cod't F. DescriplAoll 3994 1995 ADOPT1.0 AS OF 1)E PT 14Al)A(;I ?R Division Code & Descr i l,l i.on ACTUAL ACTUAL (311UG('I' 08/31/96 REQUESTED RECOMMENDED 111V SEWER PAC•ILI MAINTENANCE 675 1100 WAGES OF REGULAR Et4I'L,OYEI3S 20, 149 20,323 22,4 1.6, 59'7 33, 464 3 3, 1rol 1 1 12 OVp:R'i'IM OF RE'GIILAR EMPLOYEES 13,476 '7, 6 3, 245 4,501 7, 693 /, 693 1130 WAGES O!' PART- '1'.IME EI.IPLOYEFS - 2 99 393 2 06 -_ 374 0 U AI.ARIj AND WAGE, TOTAL 211,924 28,395 25,923 21,472 41,157 41 ,1!i'/ 1 1 4 1 PERA BASIC PI'Atl 0 2 0 U o 0 1 14 "2. PERA COC)RDI DA•I ED PI.All l , 282 1,254 1 , 161 945 1 , 844 1 , 844 1 14 6 FICA 2,1`19 2,132 1,983 1,622 3,148 3, 1 1 1'i I IIIiAI l'll I DSUPADC'li 0 1 , 040 2,069 3,54o 2, 400 2, 6M) 1 152 I-IFE I NSIJRAN E 0 7 15 11 22 22 1153 DEUTAL INSURAUCE 0 41 248 60 360 360 1154 WORY.ERS C•Ot•IPI•a)SA•1'IOI.1 IDSIJRAIICI: 79 4 -_- 1_076 _ 1,1185 5 91. 1, 196 _ 1, 19G FRIIJGE 13ENE'I'ITS TOTAL 4,255 5,551 6,561 4,769 9, 170 9, 1 , :'.10 OFFiCH SUPPLIES 0 0 0 343 0 0 1'2.20 0I SI1PI'l.l ES 1,055 1 70 l , 100 124 U U 1226 CIIE'MICAl, PRODUCTS 2,612 2,400 2,500 3, 157 U 0 1 227 SAFETY SUPI1I,1ES 48 0 50 0 U 0 230 REPAIR & MAiNTEINANCE SUPPLIES - 4,965 - _ - _1,571 4, 1 46 2,000 2 ,(1(10 ;1)ITI,11 S TO 8, 700 4,141 7,650 3,770 2,000 2,000 '110 PROPEL ;S 101 JAI, 5P:RVICES ---- -- - - - U - -- 15,699 - - -- 0 5 6,343 U U CITY OF 17ROOKI,0Ia1'YER MAIIAGF.R REC0141) [3l1UGls'I' WORY.SIU3l:'1' IlY DIVE SIOtl 11a ! 1114 1.997 BUDGET 1996 199'7 1997 (4 )iocl -odd & Uescril�Cion 1994 1995 ADOPTPD AS OF DEPT MANAGER Division Ccxle & Description ACTUAL A CTUAL BUDGET 08/31/96 REQUESTPD REC'OMMENDE'D ON Slll;l'Lrl , 'I'()TA1, 0 15, 699 0 56,343 0 0 •1 322 'YELGPIIUNI St:RVI(:GS 0 526 340 393 500 500 43 LEGA1, U!)'1 [C'1: P081,,ICATf011 — - -- ° - - - -- - - 0 - -_ -- ° - -- 15 0 0 0 "ONMUN I ('AT 11)OS TOTAL 0 526 340 543 500 500 , 1380 R EPA I R 1, MA I UTI- 31ANCE CONTRACT 7 011 0 140 0 0 0 1 AUTO I"UM PMEINT REPAIR 374 1 , 085 0 0 0 0 4 1116 C0141 r CAT I OU SYSTEM MA UI'I' — - - -- - - ° - -_— - 3 yq 0 0 0 U PFPAIR, REII I - A1,, I. M A INTENANCE •L'O'YAL, 4112 7,4•19 140 0 0 0 -1400 OTHEIl1 COUTPACYUAI, SERVICES 2,203 1,945 3,000 571 0 0 4414 LICP:FISI S, TAXES, F FRGS 240 0 O'I'IIER CONTRACTUAL SEIRV I CES TOTA1, 2,203 1 , 94 5 3 , 000 811 0 0 14.10 FUEL CIIAIM S 0 208 64 57 0 0 4141 FIXED CHARGES 0 10, 931 11,028 6,827 0 0 1 REPAIR 1, MAINTENANCE. CHARGE'S 0 1, 150 221 172 1) 0 14 rtUl,'1'1 -U:.E 11011LI,Y CIIARCEIS 8 '122 9, 825 13, 096 9 592 U II 'G!1'I'RAL GARAGE RE11TAL RATES TOTAL 8,722 22,114 24,409 16,648 0 0 1401 ELECTRIC SERVICE, 19 ,86r, 19,186 -_ 8,019 14,225 20 ,500 _ - - 20, 500 'JTI 1, fTf ES TOTA1, 19, 866 19,186 8,()19 14,225 20,500 20, 500 I'', 10 0111 El? IMI'IN)Vlih11.11I'." ; 0 0 0 1 , 092 0 0 CITY OF BROOK LY r,'N'1'ER 0 MAIIAGER RECOMD BUDGET WORKSHEET BY DIVISION Faye 185 199 BUDGET 1996 1997 1997 )h jecL Code & Desc ri ILL i on 1994 1995 ADOP'T'ED AS OF DEPT MAWACHR Division Code & Descript: ion AC "I'IJAI, ACTUAI, BUDGET 08 /31/96 REQUES'I'Ell RL•:COMfII;IlDI:I) 1 1 012 OTHER F.UIII I'ttlal'1' 0 0 0 2,31 0 0 1560 CONSTRUC "I'IOil CONTRACTS 0 �T_ -- 0 0 275,026 0 0 ''APJ'i'AL OUTLAYS TOTAL, 0 0 0 278,435 0 0 19 20 DE' PRECIATIOil EXPEUSE 0 43, 592 ---- 66,500 0 42,000 a ')"T'ITE'R EXPENUITURI•:S 'I'OT'A[, 0 43, 592 66,500 0 42,000 47-, 000 '1)•;411:8 FACII,ITIE.S MAIIIT'ENANC'F. TOTAL 73,153 342,627 1 542 39 115,327 11 5, 327 I I I' CITY OF' UROOY.LAReNrF:R MA11AGER REC0141) BUDGET WORKSIIEL•'T BY DIVISIOtl Pa�l� Hif, 19 9'1 l3000E:'1' 1996 1997 1997 -L j ncL Curie 1. D"sct. i pl. i oll 1.994 1995 ADOPTED AS OF DEPT I- IAIIA(;IU? - - -- Division Ccxle & DescripLion ACTOAL ACTOAI, [3IIDGE'I' 08/31/96 REQUESTED RI ?Col-V41•:11DED i1IV SE19EIt OPERATIONS 676 - -- 1 1110 WAGES OF REGULAR FT41'LOYEES 46,259 50,r,913 62, 367 30, 924 66, 928 66, it 112 OVER'T'IME' OF REGULAR EMPLOYEE'S 6,769 `�, 098 2,164 5,440 3, 846 1, 846 1 1 30 WAGES OF PART-TIME, Eh1PLOYEI %`' 2,054 ] , 2G 1 3 , 2.96 1,407 0 0 1 199 `;IAI.AR i ES I?EIt11i1)R SED 89, 375 73, 040 '/7, 102 50,69G 0 U ;ALARIES ADD 1 TOTAL 144,457 1- 34,(196 144,9'29 88,466 /0,774 10,'174 I 1 1 4 1 PIRA BASIC PLAII 0 2 0 0 U O 1142 PERA COORI)IIIATED PLAN 2,378 2,67H 3,03H 1 , 629 3, I'll 1116 Fl CA 4,133 4,5 5,189 2,843 5,414 `;,414 1151 IIEAI;I'II IUSURAIICE' 0 1, 011 5,616 3,722 •7, 1.00 /, 100 11.52 LIFT: IDSORADCE 0 49 39 26 44 44 I 1 53 DED9'AI, (USURAIICI' 0 2'10 652 133 1117 ] fl'/ 15.1 4IORY.F:RS COt•1PENSATIOil III SURANCP 1, 347 2, 278 7. 643 1, 025 2., 154 ?., - -- - -- - - -- - - - - - - - -- 2, - - - ---- - - - - -- - - - PAIGE 111-111-:1-11'S 'I'OTA1, - 7,1150 16, 858 17, 17'1 9, 3 1 8, O "/0 I fi, I1' /(1 1210 OFFICE* SWITIJE'S 0 124 30 0 350 3`;0 ?12 PRlll•ED FORMS 371 1,395 2,400 1,162 2,40U 1,400 220 OPERATING SUPPLIES 7.,U92 4,409 !i,610 225 4,000 4,000 226 CHEMICAL PRODUCTS 0 0 0 0 3, 200 3,200 "1."1.7 S AFETY SUPPLIES 663 670 650 486 700 100 2:10 REPAIR & MA111TEIIAlICE SUPPLIES 5, 328 286 2,000 0 500 500 2 ISUII,DIIIG REPAIR SUPPLIES 0 0 480 0 0 0 oz/'/ ox/'/ n oul'| 0 s11 Gil s7001os oov ,I I. 000'// 000'1.1 cI's 000 '1.r vs/'r yot sonrxxyo '/voA..'_)va/wu il'.111.1.o oot. � oc scz'or 01.9'91 Ptl. 'vc yPs'o s1,o'T/ ''|vx/mo 'xru|y � c,m'�� ���`��---- hTT FTT ��� FIT 5-1 6----- �Z_P_o l---- uuoxvxz xMn/ L61. � » » o o 0 1.x o o�nvx.1uv`D u)/m/o�/|/vw 61h ooc'c oot'c ozs'x oo/'c |yn'c m1'1 wozo/S *orIvJ/n0000» vo` os/'I. oo,'t, ono'u rPo's gos't 11vA.0.1. x/w/-IvJ/mIm«) � -_'_--- 0 -'__-_---- 0 0_-___--__' � _____-_-- �� _- . ouu��xwuuvx� ort/ o o o o m o x:)/xxxx /xxxnao I osr'z as/'| 661 onn frn oos sao/xxuc xwxumy� xz`' 000'v oon'o 7oI'P 000'* mc's ovo'c x �m In/ ,,..,~.... ....,..�.. ..~~....~ .......... ..,~..~~,. ......~..~ wz'cr sW/ �zv'c s/c'z ' ox|U1oo^, �iT _0 EP _C---- ���'�----- ���'l �[�'f nnn/xxso 'IV /»/mo/^ v .unov V s/ o o o o ns'x o o n o16'11 n » » naz/xxeo 'Ivvxnuauxouo o/,/ � non'I 1 000 [1 616'l ucu'r, 696 '9 oCv'o 'mzm. xa i;.uo` ��7 ------ OST ------ 7 ------ osT-----_- h --------' 0 --------- ,ar|o.n/s woLLsAu /�r||zn lm/ � oos oos v^ oos n nnn x1,xu 'nvos on^ o o o o o w z/vIxu�vn u11x1.1's 1 mxxs vst o o o o CS 13 voe mv/xn�vu s/uv�au�/vo zyxx�s w�/ 'owmwwcx�x nn�on�k}au os/rc/no «x:v//vo xaon uo nv oxLu/c^m soor t »v,/ mo/ cooz o^oc �uooun Lna| t . 11 1 oh'a /|o/s|xm xo Iauxsxuoo �n�unn owoonx oxcxoxxi 0 unAu 'mmMxx An A.11rn C I TY OF BROOK LO'1'sfi'I ER 0 MANAGER RECOf41) BUDGET 4IORKSIIEET HY DIVISIOEI Page. 188 1.99 BUDGET 3,996 1997 1997 ''Meet Code & De ,cript..i_Oil 1994 . 1995 ADOPTED AS OF DEPT I•IA11A(ll•:It Divisioll Code & Description ACTUAl, ACTUAL BUDGET 08/37./96 REQUES'T'ED ItI:COtdh11 ?UDI:U 1413 DUES 11 S1311',(01? Ik''I ' fON; 320 59 320 0 321) 31O 1414 1,10EINSE:S, TAXES, F. FFE`' 15 55 50 23 50 SU 1 4 1 5 CI,A 114S PAYMENT 0 150 0 0 U 0 1.121 SANITARY SI•:I•II:R DISPOSAL CHARGE — 1.,395, "l61 1,42.1,330 1,431,659 669,229 — 1,450,000 1,150,000 !!, I'1'IIliR,,COt1'I'RAC'1'UAL. SPRVICE:S TOTAL 1,406,1.78 1.,430, - 198 1,450,149 869, 794 1,460,490 1,4611,490 1440 FUFI, CHARGES 203 325 100 89 361 361 1441 PIXFD CHARGES 5, 235 1'1, 098 17,249 10,G78 17, 388 1 I88 1442 RE:I'AIR & MAINTE:IIANCE (-'IIARGES 400 1 ,'199 347 269 2, 130 2, 130 144 1 I-IM, 'I -USE, IIOI)RE,Y CIIARGES 12, 94 1 S, 129 32, 248 20, 299 26,031 26, 031 1 1I•:1 C'IIARGI ?S - - - - 0 - 28,356 -_ 0 0 0 0 ( 'F:11TRAI, GAPA(;E RE:NTAI, RATER TOTAL 18,'185 62,707 49.944 31,335 45,910 )",910 1161. GENETAI, LIAHI I,ITY IIISI)RANCP 18, 208 4, - 14r 'i, OU(1 'i, 022 S,200 'i, 2110 14612 PROPERTY I NSURANC'E 1 , 104 l , 07.8 1,200 1 , 052 1 , 2110 1 , 200 '1463 HO (1 ER I, t•1ACIIE:RY I tISURANCE 0 185 I NSURANCE TOTAI, 19,312 5,774 6,200 6,260 G,400 6, 400 1481 EI,FCTUIC SERVICE 0 O 12,543 0 O O 1485 SANITARY SFFIFR SERVICI. 0 0 0 119, 305 0 0 1487 SOLID WASTE DISPOSAL -- 26 — -- 0 - - - - 0 0 O 0 iJT11,ITIE'S TOTAI, 26 0 J2,543 119,305 0 U 1!S!i2 OTIII:R EQUIPMENT 0 0 3,6150 0 3,650 3,650 CITY OF BROOKLOENTER • MANAGER RECOMD BUDGET t•IORY.SNEWU BY DIVISION Page IH9 1997 BUDGET 1996 1997 1997 ' il, j e,cl. Code 6 Detacr i pL i on 1994 1995 ADUP rED AS OF DEPT MANAGER Division code & Description AC'T'UAL A CTUAL BUDGET 08/31/96 REQUESTED PECOMMEIJI)EI 1'.60 CONSITUCTION CONTRACTS 0 �, 840 0 0 0 I) CAPITAI, O()'I'I,AYS TOTAL 0 5,840 3,650 0 3,650 1,( 1612 PAYI A EHT FINS 300 0 0 0 0 0 1GN1' SERVICE TOTAL, 300 0 (1 0 o I1 a 1702 ADMINI )TRATIVE SERVICE TRANS 0 0 0 0 7e, s46 - - 78, 51 6 TRANSFERS TO OTHER FUNDS TOTAI, 0 0 0 O 'le, 546 78, 546 1920 DEPREC• NrlUII EXPENSE 110, ess 70,540 108, 500 0 90,000 90,000 1922 I,OSS 011 FIXED ASSET DISPOS - - -- U — 1 , 041 0 0 0 0 �'I'IIER EXPIaJDITURF. S 'TOTAL 1 l0, 855 71 , S(f2 108, soo 0 9(1, (1(1(1 90, 000 ';Pa•IER op!Utxi'IONS TU•I•A1, 1, 735, 057 1 , 751, 939 1 , 840,601 1 , 160, 979 1 , 830, 399 1 I I 0 CITY OF IIROOKIOT,311'ER MANAGER RECOMD BUDGET WORKSIIL;E'P BY DIVISION Par3r. 190 1.99 HUD(IE'1' 1996, 1997 1997 Ot�ject Code & ur�sr ri1�L .ran 1994 1995 ADOPTED AS OF DEPT MAMA(;F:R Division Code k Descript-jcan ACTUAL ACTUAL BUDGET 00/31 /96 REQUESTED RI;COF1tJI•:!lUI;D 111V SEVIVIR COtIS'I•f2UC'floll PRom.:(.1'S 617'1 1 100 WAGES OF ItF.GI1LAR EMPLOYE 60 H47 0 1,70G (1 O 1112 OVEIRTIME OF IZE(;OI,AR EMPLOYEE*` 0 113 0 0 0 0 1 1 .10 4IA(;f:.`; OF PART - TI Mii EMPLOYF•ES 56 0 0 0 0 (1 `;ALAR j,.ES AND VIAGES TOTAI, 116 960 0 1 1 4 2 PH.ItA ('OORD f tIAT D PLAN 3 43 0 76 0 (l 41x6 FICA H 71 0 125 0 0 J 154 110IMEIPS C'C)1•M'EWMI 1011 INSURANCE 3 2'1 0 17 0 0 FRIMGIi HEN FITS TOTAL 13 1.11 0 219 U 0 , 11')1 LEGAL 110TIC[; P11HIACATION _ - - - -- 0 - -_ -- 0 0 139 0 0 r'Ottt•tUlIIC'ATIONS '1 0 0 0 139 Q 0 1443 MULTI ()!;[-: HOURLY CIIARG(S (;ARA(;I: Rf'11TAI, RA'Z'ES TOTAL 0 04 0 O O 0 f"WER COMF;'I'RI,C "I'MIJ PROJECTS TOTAL 129 1 , l fib 0 2,064 0 0 CITY OF 13ROOYhoE*H E'R MANAGER RECOMD HUDGRT WORKSHEET BY DIViS1OIJ Page 191 1997 BUDGET 1996 1997 199'1 ()l jecC code- F. Description 1994 1995 A DOPTED AS OF DEPT MAIIAGER Division code & Descri.pt: -inn ACTUA1, ACTUAL BUDGET 08/31/96 REQUESTED I?t:C(�tilil:llDl:D DIV 999 - - -- 1 100 PERJIADRIII' TRANSFERS _218, 828 -- _ - - 0 _ -_ - -_0 0 0 U I i ?f�IJt;t'I:RS TO OTHER FUNDS •I'OTM, 218, 0213 0 0 0 (J 0 I JUDE' FItIED TOTAi, 21.8, 820 0 0 0 0 0 `; MI SEWER FUND TOTAI, 2, 027, 166 1, 901 ,'152 1,983,113 1,560,058 1,945,726 1 , 94' >, V26 • CITY OF HROOK19:1iE1TER • MAIJAGEIR REC0I4D BUDGET 410RKSIIEE'r U! DIVISION I'ru1,� 192 1.997 BUDGET 1996 1997 1997 object Code & Description 1994 1995 ADOPTED AS OF DEPT I•tAt1A( -;l;R Division Code & Description ACTUAL AC UAI, I)UUCI 1' 011/31/96 REQUESTED RECOMMENDED DIV STORM SL191:R OPERATIONS 680 , 1100 WAGES OF EI.11 2,10 2,369 0 8, 725 0 (1 1112 OVFI?Tlh11 -: OI' REGULAR I:I•IPLOYIsIiS 44 o U 83 U o 4130 WAGES OF PART- I'll•IE !a4!'LOYEI:S 0 0 0 924 0 (1 1 199 SALAR 1 P ;S REIMBURSED 100,000 100,000 1u0, Ou0 66,664 lJ U ' ;AI,AR 1 V'5; AND I)A(,I T OTA1, 1 0'1. , 1 5 1 102, 3119 100;000 76 , 3 96 U 0 4142. PERA ('001 ?1)11)A'1'1'.D PIWI 96 107 0 395 (J tJ 1146 F1 CA 164 173 U 729 0 0 1154 17c)RYI:RS CUI1PIa1SA'I'IUt! IDSiJRAIICfi _ — -- 30 _ -- _ - 39 O 335 0 U FRINGE 111.111- 't'1'S TOT'A1. 290 319 0 1,458 0 U 4210 OFFICE SUPPLIES 16 U 0 U 900 900 , 1220 OPERATING SUPPLIES 0 25 0 455 0 0 ( '.1230 REPAIR 1, l4AINT'ENAUCE SUPPLIES 3,162 0 3,000 0 0 0 •1134 STREG[' HAm MATERIALS (1 0 0 11 3 0 (J UPP1,IES TOTA1 3, 1 25 3,000 568 900 cJ00 ' c` ;I•;RVIUPS 3,266 ,1,819 44,000 34 ?.' /) U, 000 : 000 1110 I R011s.;. ;IUtIAI, c •> •, ULTIDC TOTAI, 3,266 51,619 44,000 34,2'79 20,000 2(1, 13"21 POSTAGH 0 0 500 0 500 5uu 1324 DELIVE'VY SERVICE; 21 0 30 18 (1 U 1 134 USE ON PER[3011AL AUTO 0 14 90 0 90 qO CITY OF HROOKI,Y I✓tl•IER 0 t4AlIA( RECO191) BUDGET 41ORKSIiE1'1' 13Y UIVIS1O11 1.997 HUDGI;'1' 1996 1.997 II, jec1: Co(l f, I)n�:cr i ht i oII 1.991 1.995 ADOPTED AS OF DEPT I•tAllAt;l:f) Ui v i � i (uI Co(lrt f Uescri ht i oll AC" I'UAI, ACPI)A1, 13UUG1.'1' 00/31/9G I?EQULS'1'Pl) RI;C(,I1D1Ktll)I:U I 1`10 I'RIItYIlit; 0 0 -_- - 1,OOo 0 1,000 1,000 Irlanitl l Cn'r I C H:; '10TAI, 21 1 1,620 1.8 1 , 590 1 , 590 1400 OHIER CON'IVACTIIAI, SERVICES 25, 644 3, 111 F3 2, 000 0 2, 000 z, Uno I4 1 1 Co ltFER1 •:1WE'S AND SCI10OL S 295 26 0 0 0 0 s 1 DOES & SUHS(ARIPTIOIIS 9, 0 0 10, OOO 0 33,100 13,400 1.117 HOOKS AND REFERENCE HAT RIAI,S U )THER COVI'RACTUAL SEIWICES TOTA1, 35,013 3, 852 12,000 U 35,400 15,400 1.190 FUE1, CHARGES 569 526 461 510 530 530 1141 FIXED CIIARGVS 10, 036 10,082 10,689 7, 1 l ), 265 1 1,265 1442 REPAIR 1, HAItlTEIVAIICE CHARGES 5,744 7,'151 11,148 0, 539 8, 582 8, 502 1.14 3 1101,11-USE HOURLY CHARGES 30 146 0 5, 960 152 1 !i 1444 ►t I;PLA(.'D:1l.NT CHARGES o U o 0 9,000 �), 000 'f:U'I'RAI, GARAr;I? PEII I'AI, RA'I'D:.`; TOTA1. 16, .1'/9 19, 105 1.9, 290 22, 184 31 , 53 l ► , !i 37 I 1461 (;F.t1ERAl, 1AA1311,ITY :INSURANCE 2,100 2, 1 16 2,500 1,957 2,500 ?.,S)U I USUPANCE T(YI'A1, 2,100 2, 1 ).6 2,500 1 , _957 2,500 'l., SOU ISC,O CONS'i'R0( "1'I( >tl CONTRACTS U 0 0 U 25,000 25,000 'APITA1, OUTLAYS TOTAL 0 0 0 U 25,000 '7.5, 000 6 110 uGHT SEPVI PR PAYI4I;NT o 0 110,o00 . 110,000 155 155, 6� 11. W'E'IR iST 30,208 90, 625 88,315 811,315 82,595 82, 595 • CITY OF BROOMOCE31T :R • r4Annc1:R RECO111) 1311D0fi'I' U101tl<SIIIsE'1' 13Y DIV1SlOpl Paw. 194 1.997 13UDGE 1996 1997 199 "i ul>jecC Cock! & Descript:iol) 1994 1995 AD(HITED AS OP DEPT t•1AIlA01:R Division Code f, Descr i pl i oO ACTUAL, AC TUAI, [31J000'1' 011/31/96 REQUESTED 1(I:COI•Ihtl {JII H:U '1612 PAYIIR; AC;I:U'I' 1 IiliS -- - - - -_ — _ 0 - _- - - -- - 300 ------- 0 500 500 I?I:13'I' SERVICE; 'I.OTA1, 30, 2011 90, 925 198,015 198,315 238, 1704 STORM SI;IJI;R WAGE Rl:Th1UU11S1:(11 ?tJ'I 0 0 o 0 100 000 10o, 000 '1'PAI SFERS TO OTIII:R FIJtlD:; 'I•OTA1, U U 0 0 100, 000 100, 000 a 1920 DEPRECIATI()I1 RXIIIJISIi 32,000 0 57, (100 5'/ 000 f)'I'IIE:R EXPENDITURES TOTA1, Ilfifl !i, 471 32,000 0 5' /, 00() !�' /, 000 STORK SEWER OPI-MATIOIlS TOTAL 193,494 2'/6, 035 413, 233 335,174 512,022 '312,022 I I I • CITY OF 13ROOKLOENTER • MANAGER RECOND BUDGET WORKSHEET BY DIVISIOU Pr1ye 195 1997 13UDGEIT 1996 1997 1997 I,ject Code & UescI iptiOil 1994 1995 ADOPTED AS OF DEPT hiA11A(;I ?It Division, Cole & Description ACTUAL ACTUAL l3UDGE'I' 011 /31/96 REQLIES'1'Iill RGCOr4Mi ?r1Uf;D I)IV S'1'(,iltl SEWER C(,r1S'I'RL1( "1'1014 PROJ 681 1 100 WAGES OF REGILIMIl EMPLOYEES 44 0 0 33, 394 0 0 1112 OVER'I'IhiR OF RfMA,AR ENPLOYEPS O 0 0 5,440 0 0 ; 1 SO HAM-:!; OF PART TIME. Er•1PLOYEIES 0 0 (1 2,836 0 (1 IM 1 1 (AVERT I VIE OF PART TIME h:h1PL))Y►;i 0 0 0 546 0 0 ''IJ,AR I ES AND WAGES •I ()TA1. 44 0 0 12, ,'.16 0 0 1141 PER IfA!-;1(' PLAN 0 0 u 119H 0 u 1142 PERA l'Ou IMIAT D P1,AN 2 0 0 1,379 0 U 11 FICA 3 0 0 2,488 0 11 115,1 HORKEItS C1)NPF:NSAT1011 INSURANCE 1 0 _ 0 5 0 0 i B131E.FITS TOTA1, G 0 0 5,344 0 0 1220 OPERATING SUIT[,IE'S 0 0 0 41 0 0 1235 LANDSCAPHIG MATERIAI,S O - - - -- 0 _ 0 14 ;UI'PLIES TO 0 0 0 55 0 0 1 110 1'1•'.OFESSI))NAL SERVICES 17,724 !i, 3!2 U (,6,052 0 0 I li 1 11 1,1 ?C;A1, SERV I CAS 2, 047 0 0 1 , 382 tl 0 113 AUDIT & FIIIAI)CIAI, SERVICIiS q00 O 0 0 0 0 'u17.` <lli;i'IW; '1'f)•I'AI, 20,171 5,152 0 67,414 0 0 13 "1.4 DELIVh:RY SERVICE: 0 0 0 0 0 0 1 1 5 1 I,I;GAI, 1101 I CH 1 1 CAT ION 0 0 0 3 59 0 0 • CITY OF PROOKIOE1J'1') l? MANAGER RECOND BUDGET WORKS11EPT HY DIVISIOIJ Pa(ye 196 199 BUDGET 1996 1997 1997 11)jec t Cof Ie 1, Des c r i 1) U i of 1994 1995 . ADOPTED AS OF 1) E'sPT t•1AIINXI? Division Code k De,cripLiul► ACTIJAI, Ac "MAf, E3UDGE'(' 08/31/96 REQUESTED RI?C(II4t4I;NDI?I) '(I . 11•1111(•A3'I(kDS •IOTA 1, 366 0 ,) 1411(! OTHER CONTRA(•TUAI, SKRVICES O U O 2,090 0 0 •1410 NISCI•:Ll,A(J6OUf; 20, 1 30 0 1.127 UtSlsnSl:D '1'Rfa: 1I•;1.10VA1, ('011TUACT 0 0 700 0 0 - - - -- . -. )IIIRR COUIRAC•11 UAI, SERV1Cf:5 TOTA1, 20,130 0 0 2,790 0 l) 44 1 1 14111;1'1 IL`;IS IIO111t1,Y CIIARGEIS 0 1, 102 0 TIFITAI, C;AVA(1) RENTAL, PATHS TO•I'A1, 1 `, 1 0 CAPITAL 011H,AY I,AI1D U 11 0 3 , 37.7 (► (, l')12 R IG11 OF WAY r, F,ASIi141 - :1IT COSTS 0 0 0 -19 0 0 1!i60 CON STRUC'1•IOIJ CONTRACTS .1, 248 0 69, 331 0 1► 0 ''AP1TA1, OU'1'1,AYS TOTM, 1,248 0 0 72,639 0 0 ;•I'OI'.t•l ShIJP:R C011STRUCTION PRO.J TOTAI, 41, S98 5, '3`i2 0 191, 94 '1 0 0 • CITY OF 13R0Orl,*EN'1'fsR • I.IAIJA(;GR VE04-11) 13111)(,ET WORKSHEF1' 13Y DIVISION 1.997 BUDGET 1.996 1997 1997 I,j,wl, Codf 1, Desc•ri ion 1994 1995 AD))PTE'D AS OF DEPT MANAGER Division Codo F, Descript -ion ACTIIAI, AC_TOA1, BUDGET 08/31 /96 RIiQi1GS'1'I D Ith:C'l)hiFU:rll,l:J, Ijiv UNDEFINED a99 1 100 PI•aU3ANGNT TRANSFERS ]. "2.8, 3S8 U Q 0 0 0 1PANSUFU S TO () FI1r /US TOTA1 128, 358 U 0 0 0 0 1922 I,()SS ()fl I'IXE:D ASSET DISPOSAI, 1,428 0 5 l IIkiR I:XI'1•:IIDI' OPH S '1OTA1. 7, 42.13 0 0 0 0 0 �INDEFINED TOTA1, 135,787 0 0 f) 0 U TOPI -I SE'WEP FOOD "1'OTAI, 370, 079 281, 386 4 13, 233 527,121 512,022 S12,022 i ' 1997 Utility Study i + ++ Prepared for Brooklyn Center City Council By the Public Services Department October 3, 1996 IL City of Brooklyn Center 1997 Utility Rate Study Summary The City Council annually reviews established public utility rates to ensure their adequacy in meeting financial goals. The Public Services Department strives to meet these goals while keeping rates as affordable as possible. The total utility bill paid by a resident of Brooklyn Center continues to be lower than in most area communities. Water Utility: The schedule at the end of the Water Utility report labeled Option 1 shows a continuation of minimal rate increases. This option meets all utility financial requirements. Option 2 shows the projected effect of maintaining the existing rate schedule. With the exception of the periodic painting of P P P g water towers and the possible need for a water Average Residential. 1996 1997 treatment facility in the future, most capital Utility Customer Charge Charge'' outlays in the water utility will be main replacements associated with neighborhood street improvements and other infrastructure repair. Recycling 525.80 $25:80 To preserve flexibility and to provide for a Water $110.80 $114.66 revenue cushion, it is recommended that the Sanitary Sewer $170.00 $175.00 Council adopt the rates shown on Option 1. Storm Draina 9 $32.OQ $33.OQ This would result in a small increase in rates in a _ 1997, with rates raised to $0.89. per 1000 gallons. Total $336.60 $348.46 Major improvement projects scheduled for 1997 include: water main replacement as a part of the ase Percent Incre 3.4� France Avenue reconstruction, water mom replacements associated with the 1997 neighborhood street reconstruction and other water quality projects. Sanitary Sewer Utility: Option 1 shows the projected effect of small rate increases over the next four years. Option 2 shows the impact of no increase for 1997, followed by small increases the next three years. Staff recommends Option 1, as it provides for an infusion of dollars into a fund that has spent almost half its fund balance for system improvements the past two years. This option would result in a rate increase to $43.75 per quarter for a typical residential customer. Capital improvements for 1997 will include; replacement of some sanitary sewer lines as a part of the i 1997 neighborhood g borhood street improvement program, sanitary sewer improvements associated with the • France Avenue street improvement project, and other minor infrastructure or equipment repair. Storm Drainage Utility: The schedules labeled Option 1, 2 and 3 show the financial impact of each on the existing rate schedule. Option 1 provides for small increases in rates over the next four years. Option 2 would include a more significant increase for 1997 with minimal increases the following years. Option 3 would include no increase for 1997 and marginal increases in subsequent years. The Phase I study of the City's storm drainage system, (Storm Water Management Plan) has been substantially Average Senior Utility 1996 1997 completed. A Phase II study will, with Customer Charge Charge council approval, be completed in 1997. An essential part of this process will be the development of a financial plan, which will be implemented in 1997 and Recycling $25.80 $25.80 subsequent years. Water $28.00 $29.00 Given the uncertainty regarding what Sanitary Sewer $93.60 $96.00 types of future requirements and projects Storm Drainage $32.00 $33.00 will need to be funded from the utility, along with the volume of work already identified, staff recommends Council Total $179:40 $183.80 adopt the rates shown in Option 1. This percent Increase 3.40 IL would provide a sufficient revenue cushion and ensure the integrity of the fund. • Adopting Option 1 would result in a rate increase from $32.00 per base acre in 1996 to $33.00 per acre in 1997. The average residential quarterly rate per lot would increase from $8.00 in 1996, to $8.25 in 1997. Capital improvements scheduled for 1997 include: Construction of the Shingle Creek Regional Pond, storm sewer work associated with the neighborhood street reconstruction and other water quality improvements. It should be noted that the attached spread sheets do not include any costs associated with the Shingle Creek Regional Pond. Staff is pursuing several funding options regarding this $3.1 million dollar project. It is probable that a portion of the cost would be paid for by the utility. Recycling Utility: The Hennepin Recycling Group (HRG) has adopted their budget for 1997 and it maintains current service levels with no increase in fees for 1997. Rates will remain at $2.15 per month. Utility Hook Up Charges Hook up charges are increased annually based on inflation. Charges were increased 3.0 percent, based on the increase in the Consumer Price Index from August 1995 to July 1996. ® Summary: Staff recommends small increases in water, sanitary sewer and storm drainage rates for 1997. If the recommended rates are adopted, the annual utility bill of the average customer would increase by approximately 3.4%. BROOKLYN CENTER WATER UTILITY 1997 RATE REVIEW Background The City Council on October 10, 1995 adopted Resolution 95 -224, which established water rates for 1996. The Council annually reviews established rates for their adequacy and makes adjustments as necessary. Water Utility Financial Performance, 1995 In 1992, the Council approved a policy change regarding the use of interest earnings to subsidize rates. Previously, one half of interest earnings were used to offset operating costs; starting in 1992, this subsidy was phased out 20 percent per year. As of 1995, the phase out is complete and interest earnings will no longer be used to offset operating costs. The water utility's financial performance in 1995 was as expected. While projected revenues were lower than expected as a result of the wet summer, expenditures were also lower, as less water was pumped and treated. The resulting net operating income, (operating revenues minus operating expenditures) was 3 % higher than budgeted. It is estimated that revenues and expenditures in 1996 will be about as projected. While it is estimated that operating costs will be up slightly, revenues from a very dry summer should be sufficient to cover the increases. The net impact is an expected net income of about $7,000. Of note in the 1997 operating budget is a reduction in utility costs of approximately $25,000. This savings is possible as a result of a recent energy management study of the water utility. The report noted revisions to operating procedures and other energy conservation recommendations that will provide significant savings. Capital Outlays The major capital improvement projects planned for 1997 include water main improvements associated with the France Avenue and Orchard West neighborhood street improvement program and other infrastructure repairs including coating repairs and repainting of tower #2. With the exception of periodic painting water towers and the possible need for a water treatment facility in the future, most capital outlays in the water utility will continue to be main replacements associated with neighborhood street improvements and other minor infrastructure repair. • Rate Setting Considerations The attached schedule labeled Option 1 shows a continuation of modest rate increases. This option meets all utility financial requirements. Option 2 shows the projected effect of maintaining the existing rate schedule for 1997, followed by modest increases thereafter. Recommendation To preserve flexibility and to provide for a revenue cushion, it is recommended that the Council adopt the rates shown on Option 1. This would result in a small increase in rates in 1997, with rates raised to $0.89 per 1000 gallons. While it might be possible to go another year without an increase, subsequent increases may need to be much larger than the rate of inflation. This would likely result in more questions from the citizens asking for justification in the increase. Impact of Recommended Rate Increase Table 2 below illustrates the impact the recommended rate increase would have on the summer water bills of various types of customers. The summer bill is typically the highest bill of the year. • Table 2 Impact of Recommended Water Base Rate Increase Summer Water Bills of Various Customers Type of Customer 1996 1997 Charge Charge RESIDENTIAL Low Use (Minimum) $7.00 $7.25 Average Use (38) 32.68 33.82 High Use (116) 99.76 103.24 Apartment, 36 Units (630) 541.80 561.00 COMMERCIAL Car Dealership (235) $202.10 $209.15 • . 1 Heavy Commercial Use 743.04 768.96 • Table 4 is a summary of 1997 water rates per 1000 gallons for a number of Metro area cities. Brooklyn Center continues to have one of the lower rates in the area. Table 4 1997 Water Rates of Various Metro Area Cities CITY PER CITY PER 1000 G 1000 G Minneapolis $1.59 Brooklyn Park $1.20 Bloomington 1.55 Maple Grove 0.90 Golden Valley 1.50 Fridley 0.90 New Hope 1.40 Blaine 0.90 • Crystal 1.40 Brooklyn Center 0.89 Richfield 1.37 Anoka 0.85 Robbinsdale 1.34 T Plymouth 0.75 Other Fees and Charges The water utility rate schedule contains a number of fees and charges in addition to rates for service. The following list describes each fee or charge and its current level. Fees A. 518 " X 314 " Water Meter Property owners are currently charged $50.00 for a water meter when a water account is opened with the City. The City then buys the water meter from the property owner when the water account is closed, and the new owner is then charged for the water meter when the new account is opened. Since most of the water meters in the City are • of this size, it is administratively convenient to charge the same fee to all accounts. B. 3/4" or Larger Water Meter • Property owners requiring water meters larger than the standard residential water meter are charged the cost of the meter plus a $2.00 administrative fee. Since there are far fewer of the larger meters, . it is not as difficult to administer the buy -back of the water meters. C. Fire Protection Inspection Property owners with fire sprinkler systems are charged an annual fire inspection fee of $50.00 to test the fire sprinkler system. D. Private Fire Hydrant Maintenance Property owners who have privately owned fire hydrants located on their property are billed the cost of labor, materials, equipment and overhead whenever the City performs maintenance of their fire hydrants. Charges A. Delinquent Account Charge • The present delinquent account charge is $3.00 or 10 percent of the utility bill, whichever is greater. It applies to the bill as a whole. B. Certification to Taxes The special assessment service charge for delinquent accounts recovers the cost of certification with the County Auditor of the delinquent amounts to taxes. It is recommended that this fee remain at $30.00, which is consistent with the certification fee for diseased tree and weed destruction. C. Restoration of Service - Monday to Friday, Except Holidays, Between the Hours of 7 :30 a.m. to 3:00 p.m. The restoration of service charge during working hours is $25.00, and includes the cost of one hour labor, labor additive, and vehicle rental. It is charged in all instances where a customer's water has been turned off, whether by a customer's request or for non- payment of utility bills. D. Restoration of Service - Anytime Saturdays, Sundays and Holidays and Between the Hours of 3: 00 p. m. and 7 :30 a.m. on Monday Through Friday Except Holidays • Restoration of service during off hours is much more expensive because Public Utility • employees are called back to work for a minimum of two hours at overtime pay. The restoration of service charge is $75.00 during these hours. E. Delinquent Meter Reading The delinquent meter reading charge is designed to motivate water customers into reading their own meter and forwarding the meter reading card to the City for billing. The current charge is: $2.00 the first and second consecutive time a reading card is not returned. The charge increases to $5.00 the third time, and to $10 the fourth time. After four quarters, the customer must either submit a reading card or schedule a meter reading, or face water shutoff. F. Water Hookup Charge Properties that have never been assessed, or not fully assessed for water are charged a hookup charge when water hookup is requested. The charge is intended to cover the cost of the lateral water main, supply, and trunk capital investment in the water system. It is calculated on a per lot basis for single family residential and on a linear foot plus square foot basis for all other properties. It is established annually by resolution. G. Hydrant Meter Charges • The hydrant meter charges are for meters that attach to fire hydrants used as a temporary water connection, usually for construction projects. The City has two sizes of hydrant meters, 5/8" x 3/4" and 2 1 /2 ". The charges for the smaller meter include $100.00 deposit, $1.00 per day rental, $20.00 minimum charge, and the cost of the water used at the prevailing water rate. The charges for the larger meter include $700.00 deposit, $7.00 per day rental or $100.00 per month rental, $35.00 minimum charge and the cost of water used at the prevailing water rate. H. Curb Stop Stand Pipe Repair City crews are called in to repair curb stop stand pipes for private properties due to damage or settling. In cases where the curb stop stand pipe is bent or otherwise damaged, a substantial amount of time can be involved in repair. A standard charge of $40.00 is charged for each curb stop stand pipe repair. e: \eng \pubuti1 \rates \watrat97 • 1 • TABLE A Capital Improvement *gram - Detail of Capital Outlays • Water Utility Capital Improvements 24-Sep-96 p 2fl0Qt6 IFIN:D SfSURC)E= I. EXPENDITURES: WATER DISTRIBUTION SYSTEM France Avenue 118,700 69th, Shingle Creek Pkwy to Dupont 610,000 All Water utility Neighborhood Street Improvements 700,000 1,001,050 350,000 350,000 350,000 350,000 1,750,000. WATER SUPPLY SYSTEM 2 MG Reservoir & Pumping Station 3,300,000 Construct Well #11 1,000,000 WATER TOWERS Repair Paint on Tower #1 180,000 Repair Paint on Tower #2 250,000 Replace Paint on Tower #3 625,000 Landscape Tower #1 MISCELLANEOUS Replace water meters 250,000 250,000 250,000 Routine Well Maintenance 17,000 25,000 25,000 30,000 30,000 30,000 150,000 SCADA Hardware & Software Update SCADA Replacement 25,000 175,000 Replace Fuel Tanks 25,000 TOTAL EXPENDITURES $1,327,000 $1,444,750 $1,425,000 $810,000 $630,000 $380,000 $6,200,000 FUND SOURCES: Water Utility 1,327,000 1,444,750 1,425,000 810,000 630,000 380,000 6,200,000 TOTAL 1 $1,327,000 $1,444,750 $1,425,000 $810,000 $630,000 $380,000 $6,200,000 WATER _ITY RATE STUDY: 1997 OFO 1 : Modest Increases EG` ii i:i ii!i:i<:i j>r t i........2 <k = :. 1 1 994 996.:.::::.;:...::;..:.. 1 9? Start of Year Cash & Investments ' 44;4 0 1 ,�,$4 419,fi60 `,$3,61at11la9, "$2? „ :$. $d1,8$4;2081643,5? EXPENDITURES Operations Personal Service 319,984 376,422 347,050 335,931 346,009 356,389 367,081 Contractual Service 136,830 154,878 98,669 101,629 104,678 107,818 111,053 Supplies & Materials 79,614 87,234 95,165 98,020 100,961 103,989 107,109 Heat, Light, & Power /insurance 148,962 151,405 162,649 145,781 153,070 160,724 168,760 Vehicle Operating Costs 40,646 43,218 51,208 49,000 54,000 59,000 60,770 State Connection Surcharge $0.00 $0.00 $46,100.00 $46,000.00 46,000 $46,000 $46,000 TOTAL EXPENDITURES $726,036.00 $813,157.00 $800,841.00 $776,361.00 $804,717.45 $833,920.37 $860,772.46 REVENUES Billing Revenues $962,369 $968,257 $1,032,000 $1,068,000 $1,104,000 $1,224,000 $1,262,250 Miscellaneous Operating 91,320 80,577 60,000 60,000 60,000 60,000 60,000 Miscellaneous Non - operating 17,608 11,049 10,000 10,000 10,000 10,000 10,000 TOTAL REVENUES $1,071,297 $1,059,883 $1,102,000 $1,138,000 $1,174,000 $1,294,000 $1,332,250 I Atrailable. rva ital :C ©ntrif . 1111 .::::;:::::: ;;:::::<::::;:: >: > ?::. <; <. >::: >:::: >:.3.. 6: ;::::? : >:: ".:::2tiCfi'26: ' >:::.::::::> p ..... :::::::.:::< ;::: >36t3.$3: r wl( 080 >:::::7:: 4$:: #393 1999 2t?b6 Non Operating Expenditures Capital Outlay (829,420) (350,265) (1,327,000) (1,444,750) (1,425,000) (810,000) (630,000) Non Operating Revenues Interest Earnings 266,561 290,593 256,340 211,709 161,168 109,284 95,327 Total Net Effect on Fund Balance (217,598) 187,054 (769,501) (871,402) (894,550) (240,636) (63,195) End of Year Cash & Investments $4;23260�' `$4,419,66U, S3a�`f),159, $2,778175$ „$ y 1 X643;572 ° 1,580;37,,6? For Information r d: R1tea?.e OQO .; :;.;...::: ::<.: 0 8x::.. $0 8!� $ 0 89 ........ $f! Q ........ ......:.:..$Q. �(3 99 WATER LOUTY RATE STUDY: 1997 O 2: No Increase 1997, Modest Increases There gRr ....... .......... ............... .. .. ... ............ .......... ........... ... . .... . 1 4 :eqr ............. ............ . .. ...... : 0 . 0 ........... ............ ............. ... .......... ...... ............... ......... ....... ....................... ........ ...... .............. ....... Start of Year Cash & investments WE EXPENDITURES Operations Personal Service 319,984 376,422 347,050 335,931 346,009 356,389 367,081 Contractual Service 136,830 154,878 98,669 101,629 104,678 107,818 111,053 Supplies & Materials 79,614 87,234 95,165 98,020 100,961 103,989 107,109 Heat, Light, & Power/insurance 148,962 151,405 162,649 145,781 153,070 160,724 168,760 Vehicle Operating Costs 40,646 43,218 51,208 49,000 54,000 59,000 60,770 State Connection Surcharge $0.00 $0.00 $46,100.00 $46,000.00 46,000 $46,000 $46,000 TOTAL EXPENDITURES $726,036.00 $813,157.00 $800,841.00 $776,361.00 $804,717.45 $833,920.37 $860,772.46 REVENUES Billing Revenues $962,369 $968,257 $1,032,000 $1,032,000 $1,080,000 $1,198,500 $1,249,500 Miscellaneous Operating 91,320 80,577 60,000 60,000 60,000 60,000 60,000 Miscellaneous Non-operating 17,608 11,049 10,000 10,000 10,000 10,000 10,000 TOTAL REVENUES $1,071,297 $1,059,883 $1,102,000 $1,102,000 $1,150,000 $1,268,500 $1,319,500_ ........ ... ..... .......... . . ......... Non Operating Expenditures Capital Outlay (829,420) (350,265) (1,327,000) (1,444,750) (1,425,000) (810,000) (630,000) Non Operating Revenues Interest Earnings 266,561 290,593 256,340 211,709 159,080 105,683 90,038 To AaLNe_tEjfect on Fund Balance (217,598) 187,054 (769,501) (907,402) (920,638) (269,737) (81,234) End of Year Cash & Investments $4232 2 , For Information ........ .. ........ ..... ....... ........ ......... ................................... ........... .................... .............. ....... ........... ............... ................ ......... ...... Q.. �p .. _ .. AM 0: 1 099 .......................... ..... ... ....................... ..... .'a. ............... . ... .. .......... . .. ... . ... ...... d ................... ............. ........... ...... ............................... ..... BROOKLYN CENTER SANITARY SEWER UTILITY . 1997 RATE REVIEW Background The City Council on October 10, 1995 adopted Resolution 95 -225, which established sanitary sewer rates for 1996. The Council annually reviews established rates for their adequacy and makes adjustments as necessary. Sanitary Sewer Utility Financial Performance, 1995 In 1992, the Council approved a policy change regarding the use of interest earnings to subsidize rates. Previously, one half of interest earnings were used to offset operating costs; starting in 1992, this subsidy was phased out a rate of 20 percent per year. As of 1995, the phase out is complete and no interest earnings are shown to offset expenditures. The sanitary sewer utility's financial performance in 1995 was about as expected despite higher than anticipated charges from the Metropolitan Council, Environmental Services (MCES). These charges account for approximately seventy five percent of the expenditures in ® this utility. Although MCES charges were underestimated by $85,000, this increase was offset by lower than anticipated expenditures for the remainder of the utility and stronger than anticipated revenues. Revenues for 1996 are coming in as expected and should be sufficient to cover expenditures. Capital Outlays Substantial outlays were made for 1996 projects that included the replacement of Lift Station #1, replacement of some sanitary sewer lines as a part of the 1996 neighborhood street improvement program, and for the sanitary main improvements associated with the 69th Avenue street improvement project. Capital projects planned for 1997 include replacement of some sanitary sewer lines as a part of the 1997 neighborhood street improvement program, sanitary main improvements associated with the France Avenue street improvement project, and other minor infrastructure or equipment repair. • Rate Setting Considerations • Option 1 shows the projected effect of small rate increases over the next four years. Option 2 shows the impact of no increase for 1997, followed by small increases the next three years. The most important consideration regarding the sanitary sewer rates is the need for capital improvements. The sanitary sewer fund has financed several major capital improvements in the past few years, and several major projects are contemplated for the coming few years. Each of these projects are necessary improvements. While in preparing a capital improvement program they may be moved from one year to another, these major projects must be undertaken in order to maintain the integrity of the system. Among these improvements are the replacement, or re- lining in place, of considerable sections of corrugated metal sewer main and sanitary sewer replacement as a part of the ongoing neighborhood street reconstruction program. Recommendation Staff recommends Option 1, as it provides for an infusion of dollars into a fund that has spent almost half its fund balance for system improvements the past two years. Impact of Recommended Rate Increase Table 2 below illustrates the impact the recommended rate increase would have on the summer sanitary sewer bills of various types of customers. The summer bill is typically the highest of the four quarters. Table 2 Impact of Recommended Sanitary Sewer Base Rate Increase Summer Quarterly Utility Bills of Various Customers Type of Customer 1996 Charge 1997 Charge RESIDENTIAL Senior $23.40 $24.00 Residential 42.50 43.75 Apartment, 36 Units 1,071.00 1,102.00 COMMERCIAL Car Dealership $399.00 $410.00 Heavy Commercial Use 1,468.80 1,512.00 Table 3 is a summary of 1997 sanitary sewer rates per 1000 gallons for a number of Metro area cities. Brooklyn Center is in about the middle of the range of rates in the area. Table 3 1997 Quarterly Sanitary Sewer Charges of Various Metro Area Cities (Converted to Quarterly Rate Where Necessary) CITY PER CITY PER QUARTER QUARTER Hopkins $61.60 Plymouth 42.30 Fridley 56.25 Anoka 40.00 New Hope 56.25 Crystal 38.10 Champlin 56.00 Bloomington 34.80 • Brooklyn Park 54.00 Golden Valley 34.00 Maple Grove 46.00 Richfield 29.00 Brooklyn Center 43.75 Robbinsdale 29.00 Blaine 43.70 Other Fees and Charges The sanitary sewer utility rate schedule contains a number of fees and charges in addition to rates for service. The following list describes each fee or charge and its current level and describes any recommended amendment. Fees The only fee for sanitary sewer service is the SAC (Service Availability Charge) unit charge, which is established by Metropolitan Council, Environmental Services. This fee goes directly to MCES. • Charges • A. Delinquent Account Charge The present delinquent account charge is $3.00 or 10 percent of the utility bill. It applies to the bill as a whole. B. Certification to Taxes The special assessment service charge for delinquent accounts recovers the cost of certification with the County Auditor of the delinquent amounts to taxes. The charge is currently $30 which matches the certification fee for diseased tree and weed destruction accounts. C. Line Cleaning Charge e g The line cleaning charge recovers the cost of cleaning City sanitary sewer lines due to misuse by the property owner. The most common infraction is grease build -up due to improper sewering of restaurant greases. The charge is actual labor, materials, • equipment, and overhead. D. Sanitary Sewer Hookup Charge Properties that have never been assessed, or not fully assessed for sanitary sewer, are charged a hookup charge when water hookup is requested. The charge is intended to cover the cost of the lateral sanitary sewer main and is calculated on a linear foot basis. It is established annually by resolution. e:\eng\pubuti1\rates\sewrat97 • • • • 1 1 TABLE B - Capital Improvement Program - Detail of Capital Outlays Sanitary Sewer Utility Capital Improvements ..:....::. .::::. EXPENDITURES: All San Sewer Utility LIFT STATIONS Replace Lift #1 and Forcemain 1,000,000 Replace Lifts 10 & 11 275,000 SEWER REPLACEMENT: Neighborhood Street Improvements 800,000 514,750 300,000 300,000 300,000 300,000 1,500,000 France Avenue 31,500 MISCELLANEOUS INTRAC Replacement 25,000 150,000 Replace Fuel Tanks 25,000 TOTAL EXPENDITURES $1,800,000 $596,250 $450,000 $575,000 $300,000 $300,000 $1,500,000 FUND SOURCES: Sanitary Sewer Utility 1,800,000 596,250 450,000 575,000 300,000 300,000 1,500,000 TOTAL $1,800,000 $596,250 $450,000 $575,000 $300,000 $300,000 $1,500,000 SANITARqPEWER RATE STUDY: 1997 0FWN 1: Modest Increase '(2y ?'( ? iii %: '''astz2Ys'l j1 % ?ii!5 2 l y ''''' ?s` < >G'. :..:: 1996 ......::::.::: ::;;•;;::.;:.;:.:199 .;.•:: •:.:;.:........:.:.... #.: 9 ::.::. 9935:.::;. ::;:..;:..;:.:.:;::;:.;:.:.::.2 4. :......:. Start of Year Cash & Investments X98 „7149 s EXPENDITURES Operations Personal Service 185,623 186,002 194,590 209,883 216,179 222,665 229,345 Contractual Service 50,869 137,176 63,859 67,052 70,405 73,925 77,621 Supplies & Materials 18,330 11,110 19,470 20,444 21,466 22,539 23,666 Heat, Light, & Power /Insurance 19,891 24,960 20,562 21,590 22,670 23,803 24,993 Vehicle Operating Costs 27,508 0 0 0 1 0 0 Subtotal: City O &M Expense $302,221.00 $359,248.00 $298,481.00 $318,968.55 $330,719.32 $342,931.69 $355,624.98 ]VICES Charges $1,297,134.00 $1,427,330.00 $1,431,659.00 $1,488,925.36 $1,548,482.37 $1,610,421.67 $1,674,838.54 TOTAL EXPENDITURES $1,599,355.00 $1,786,578.00 $1,730,140.00 $1,807,893.91 $1,879,201.69 $1,953,353.36 $2,030,463.52 REVENUES Billing Revenues $2,126,822 $2,282,067 $2,237,415 $2,275,597 $2,363,760 $2,545,085 $2,657,493 Miscellaneous Operating 0 0 0 O 0 0 0 Miscellaneous Non - operating 11,961 4,270 1,000 1,000 1,000 1,000 1,000 TOTAL REVENUES $2,138,783 $2,286,337 $2,238, $2,27 6,597 $2,364,760 $2,546,085 $2,658,493 IP # #998 .1998Af?0 Non Operating Expenditures Capital Outlay (965,070) (1,280,515) (1,800,000) (596,250) (450,000) (575,000) (300,000) Non Operating Revenues Interest Earnings 152,233 238,419 166,858 101,615 100,111 107,980 115,271 Total Net Effect on Fund Balance (273,409) (542,337) (1,124,867) (25,931) 135,670 125,712 443,300 End of Year Cash &Investments ,, . „1..~193 .. , ..2,876,8,56 2 175;9$9 1S, 26,05, Sz1$6f77 $1f X439 $2`430;739 For Information Residential Accounts ::::.. Qi78ttC - e:1': <:i'- :::;: .::; �s:'..: i;:<::%:`.: Yi: i':;:::'<' isi::::... G2. 5 'it1 ":::: : % < ; %;::' Ci'; <': <:i "i . .: .... ........ ......... S.... . $ ... . 0.:::..::.. .. .. X42 : 50 ;:.: >.; >:: ` :::::>`: $43.7�a :.. . . . Senior Accounts Auart ..Ch0r. e .....:............................:........... ................ 5.23....Q...... ......................5,73,.... .........................5.23,. :.;;:::: >.. . ,tti ..................... ......................... . Y .......................................................................................................................................................................................... 4...U.......................... X24.75....................... ...25..8.........:.....:....... . .....................................................::...:.:.:::.:::::::::::::::.:::::::::..:.:::.:..::::::::::............:::::::::.:: : :......:.::::::..::.................::..::.:: x..2..6...:60::. ............. ::... :.. . :.:.: Hl7EP.. ER1( 35Q '.:GhS 070:;:::::';<::: >: ................ ...... ..::.. _:::.::....:..::............ .....:.::..:::.:....:::....:..1 .713.......................... $ #. 75..... ........................5.1..8Q ..::.:.:..;.;;:;.;:.:> :;:.;;.1.:9fi::::.:.::':''.;::; .:.. _... ...... : ::::::::::::::::::::::::::: ::. .::::::::......::::::::.:::: SANITAR EWER RATE STUDY: 1997 O N 2: No Increase 1997, Modest Increases There r. IX . ....... ............................... 1 : 9. 96 :::::::::::::::::::::::.:...: t. 997.............................. 3. ;�9.......:......:::.:::::::::. 3.9.3 :.:::.:::::::::............ ................ Start of Year Cash &Investments $30 ?2t? EXPENDITURES Operations Personal Service 185,623 186,002 194,590 209,883 216,179 222,665 229,345 Contractual Service 50,869 137,176 63,859 67,052 70,405 73,925 77,621 Supplies & Materials 18,330 11,110 19,470 20,444 21,466 22,539 23,666 Heat, Light, & Power /Insurance 19,891 24,960 20,562 21,590 22,670 23,803 24,993 Vehicle Operating Costs 27,508 0 0 0 0 0 Subtotal: City O &M Expense $302,221.00 $359,248.00 $298,481.00 $318,968.55 $330,719.32 $342,931.69 $355,624.98 MCES Charges $1,297,134.00 $1,427,330.00 $1,431,659.00 $1,488,925.36 $1,548,482.37 $1,610,421.67 $1,674,838.54 TOTAL EXPENDITURES $1,599,355.00 $1,786,578.00 $1,730,140.00 $1,807,893.91 $1,879,201.69 $1,953,353.36 $2,030,463.52 REVENUES Billing Revenues $2,126,822 $2,282,067 $2,237,415 $2,226,603 $2,363,760 $2,564,943 $2,667,410 Miscellaneous Operating 0 0 0 0 0 0 0 Miscellaneous Non - operating 11,961 4,270 1,000 1,000 1,000 1,000 1,000 TOTAL REVENUES $2,138,783 $2,286,337 $2,238,415 $2,227,603 $2, 364,76 0 $2,565,943 $2,668,410 Auadable:Ga 1talGontrltaut�atl........ X505 >a 4 #9.7Q. x48.5 5612,55;:. &37, 46» 3995::::::::: > 1999..... >. Non Operating Expenditures Capital Outlay (965,070) (1,280,515) (1,800,000) (596,250) (450,000) (575,000) (300,000) Non Operating Revenues Interest Earnings 152,233 238,419 166,858 101,615 97,270 104,974 113,242 Total Net Effect on Fund Balance (273,409) (542,337) (1,124,867) (74,926) 132,828 142,563 451,189 End of Year Cash &Investments ,' ;419,��'1„ 3 x2,87G.856 $.� 751 98 s 51 677Q63 h $f� .," 'f 5 s ,.3;64 , I, 3 For Information Residential Accounts :. nua +rt ; Gltiar':`:::...>>::<::::>::; :::..•:. >.;:;:::::`: >:::•'.>;:. A2s .. p::::;:r.':. >:::> , >;: xt Y ..:. $ . 542 50 ,; _ 542 30 X420 $48 00 $47 5tf : $49 OQ Senior Accounts s 1 8i' >:>:E:.>' :::::.. q G;. ,... Ru�ltar _Oh.. a. ,:. fi23.....�1 4 9 .... ..::..... ::::::... 523.. .:: €23 $25 ,4#1..:.: :.: $Z3 8 : >::::: >r; c:: : '#: 5...: ,l H1�T PER: 1QQQ GAG :..:... .: .: S 70 ... .:..... $1 70 :; S1 7f3........ $1 BQ....:... $!1 9Q ;;3 92 : 57;96 BROOKLYN CENTER STORM DRAINAGE UTILITY • 1997 RATE REVIEW Background The City Council on October 10, 1995 adopted Resolution 95 -226, which established storm drainage utility rates for 1995. The Council annually reviews established rates for their adequacy and makes adjustments as necessary. A Phase I study of the City's storm drainage system, the Storm Water Management Plan, has been substantially completed. A Phase II study will, with council approval, be initiated in 1997. An essential part of this process will be the development of a financial plan, which will be implemented in 1997 and subsequent years. Storm Drainage Utility Financial Performance, 1995 The storm drainage utility's financial performance in 1995 was better than anticipated. Although operating revenues and expenditures came in about as expected, lower than anticipated capital expenditures left the retained earnings higher than originally anticipated. To a great extent this was a result of a portion of the cost of the storm water pond at 63rd and Brooklyn Boulevard being shifted to 1996. • Operating revenues for 1996 are coming in about as expected and should be sufficient to cover expenditures Capital Outlays Some major projects have already been identified for 1997 including the construction of the Shingle Creek Regional Pond. As Council has already determined that revitalization of Brookdale is a high priority project, any expansion plans must be preceded by addressing the storm water runoff from the property. Although financing of the pond has not been identified, it is assumed that a portion will be paid from the Storm Drainage Utility. Storm drainage components of several street improvement projects including France Avenue and Orchard West have also been identified. Table C on the following page details the program of capital improvements outlined in the Capital Improvements Program. • • Options The schedules labeled Option 1 and 2 show the financial impact of each on the existing rate schedule. Option 1 provides for a small increases in rates for the next four years. Option 2 would include a more significant increase in 1997 and minimal increases in following years. Option 3 would include no increase for 1997 and marginal increases in subsequent years. Given the uncertainty regarding the funding of the Shingle Creek Regional Pond, the uncertainty of future requirements and projects that will need to be funded from the utility, along with the volume of work already identified, staff recommends Council adopt the rates shown in Option 1 This would provide for an adequate revenue cushion and ensure the integrity of the fund. Adopting Option 2 would result in a rate increase from $32.00 per base acre in 1996 to $34.00 per acre in 1997. The average residential quarterly rate per lot would increase from $8.00 in 1996, to $8.50 in 1997. RECOMMENDATION It is recommended that the rate increase established for 1997 in Option 1, be implemented. Rates for the various classes of property would be increased as follows: RECOMMENDED QUARTERLY 1997 STORM DRAINAGE UTILITY RATES [ Classification/Land Use 1996 1997 BASE RATE $32.00 $33.00 1: Cemeteries, Golf Courses 8.00 8.25 2: Parks 15.75 16.20 3: Single Family, Duplex, Townhouse 8.00 /lot 8.25/lot 4: Schools, Government Buildings 40.00 41.25 5: Multiple Family, Churches 96.00 99.00 6: Commercial and Industrial 150.00 165.00 7: Vacant Land As As Assigned Assigned • The table below details the 1997 storm drainage charges of area cities for residential • properties. 1997 RESIDENTIAL STORM DRAINAGE UTILITY RATES CITY QUARTERLY CITY QUARTERLY RATE RATE Hopkins $9.00 Roseville $4.38 Richfield 8.55 New Hope 4.20 Bloomington 8.31 Robbinsdale 3.10 Brooklyn Center 8.25 Fridley 2.80 New Hope 4.80 Golden Malley 2.50 Note: Cities on the lower end of the quarterly rate scale typically fund only their watershed district dues, and in some cases some other minor operational costs for the utility. Cities on the upper end are actively constructing storm drainage improvements from the fund. • e: \eng \pubuul, rates \sdurat97 • TABLE C - Capital Improvement legram s - Detail of Ca ital Outla P P P Y Storm Drainage Utility Capital Improvements > 24-Se p-96 :::::..:.::.;:>;;;;:;;;;;; :.:....::..:::.:::....:....::::.::..::.::....... ..:..:..:...............:::.... ........................................:..................:.:..:..:::.:... 4�2fC?..:;;..IF:U.NO:.SO.URE::;;:;.: EXPENDITURES: SYSTEM IMPROVEMENTS Miscellaneous structure improvments 50,000 50,000 50,000 All storm drainage utility France Avenue (33,150) Neighborhood Street Improvements 1,150,000 229,650 300,000 300,000 300,000 300,000 1,625,000 WATER TREATMENT IMPROVEMENTS Shingle Creek Regional Pond 3,100,000 Not yet established Brooklyn Blvd Redevelopment Pond 250,000 MISCELLANEOUS Complete Phase II Studies 50,000 50,000 Surface Water Study 50,000 1/2 SDU, 1/2 Capital Impr Fund TOTAL EXPENDITURES s1,15o,000 $3 ,696,500 1 $400,0001 $300,000 1 $300,000 1 $300,000 1 $1,675,000 FUND SOURCES: Storm Drainage Utility 1,150,000 571,500 400,000 300,000 300,000 300,000 1,675,000 Capital Improvements Fund 25,000 Special Assessments /Other 0 3,100,000 TOTAL $1,150,000 1 $3,696,500 1 $400,0001 $300,0001 $300,000 $300,0001 $1,675,000 STORM DFOAGE UTILITY RATE STUDY: 1997 O 1: Modest Increase . .. ... ..... Start of Year Cash & investments EXPENDITURES Operations Personal Service 102,491 102,708 60,000 60,000 62,160 64,398 66,716 Contractual Service 96,228 80,141 50,000 50,000 51,800 53,665 55,597 Supplies & Materials 3,178 25 40,000 40,000 41,440 42,932 44,477 Other operating 2,100 2,116 22,298 11,000 11,396 11,806 12,231 TOTAL EXPENDITURES $203,997 $184,990 $172,298 $161,000 $166,796 $172,801 $179,021 REVENUES Billing Revenues $685,011 $788,897 $332,000 $858,000 $884,000 $910,000 $936,000 Miscellaneous Operating 0 0 0 0 0 0 0 Miscellaneous Non-operating 0 0 0 0 0 0 0 TOTAL REVENUES $685,011 $788,897 $832,000 $858,000 $884,000 $910,000, $936,000 ....... .... 'AMA . . .... . U ................ ...... Non Operating Expenditures Capital Outlay (685,000) (1,204,471) (1,150,000) (571,500) (400,000) (300,000) (300,000) Debt Service 1,830,000 (90,925) (198,815) (241,595) (243,520) (244,700) (245,200) Non Operating Revenues Interest Earnings 2,294 (18,044) 75,964 40,401 36,011 42,373 55,996 Total Net Effect on Fund Balance 1,628,308 (709,533) (613,149) (75,694) 109,695 234,872 267,774 %7 End of Year Cash & Investments i Iwo j For Information ............. ............. SASE: .......... ............... ............ 3.6 0(�! 8 : T . . . ..... ....... 0 . ...... .... Residential rate per lot $6.75 $7.50 $8.00 $8.25 $8.75 $9.00 Schools & govt buildings per acre $33.75 $37.50 $40.00 $41.25 $42.50 $43.75 $45.00 Multiple family & churches per acre $81.00 $90.00 $96.00 $99.00 $102.00 - $105.00 $108.00 Commercial and industrial per acre $135.00 $150.00 $160.00 $165.00 $170.00 $175.00 $180.00 STORM D AGE UTILITY RATE STUDY: 1997 O N 2: Larger 1997 Increase, Modest Increases Th fter < 25` % < :::: > ::'< r >i:; ?;ii ? %'` 2:i2i: >f< . >::.;: ,; ;;•.: <;;:.;::.;•. >:: x.986 i f� ?9F 19;1:9 .... ..... ,:. :::::. •:. ;.:.:::.; �4....::...:. ::::. Start of Year Cash & Investments ' 3 j EXPENDITURES Operations Personal Service 102,491 102,708 60,000 60,000 62,160 64,398 66,716 Contractual Service 96,228 80,141 50,000 50,000 51,800 53,665 55,597 Supplies & Materials 3,178 25 40,000 40,000 41,440 42,932 44,477 Other operating 2,100 2,116 22,298 11,000 11,396 11,806 12,231 TOTAL EXPENDITURES $203,997 $184,990 $172,298 $161,000 $166,796 $172,801 $179,021 REVENUES Billing Revenues $685,011 $788,897 $832,000 $884,000 $910,000 $936,000 $962,000 Miscellaneous Operating 0 O 0 0 0 0 0 Miscellaneous Non - operating 0 0 0 0 0 0 0 ° TOTAL REVENUES $685,011 $788,897 $832,000 $8 84,000 $910,000 $936,000 $962,000 A1ai1;3Le.:Ca �tal :Carltrlb:w 1 :. vas Non Operating Expenditures Capital Outlay (685,000) (1,204,471) (11150,000) (571,500) (400,000) (300,000) (300,000) Debt Service 1,830,000 (90,925) (198,815) (241,595) 1243,520) (244,700) (245,200) Non Operating Revenues Interest Earnings 2,294 (18,044) 75,964 40,401 37,519 45,476 60,787 Total Net Effect on Fund Balance 1,628,308 (709,533) (613,149) (49,694) 137,203 263,976 298,566 End of Year Cash & Investments ` Icios *x 1ioo_ w 'I For Information BASE:FiATE:F' F1 ACRE.......:.. _ X27 ., ....,.::... :::... :::.•:. :;:..: >;::......::::.:..00 :.::.:.:.: >:::,...... . C C .... ::. >;..;:;;:.53 .. .OQ 53 .4�4� X :.:.:........::...::::::..:................................... ............................... :...:..:..537 <tJO.,; Residential rate per lot $6.75 $7.50 $8.00 $8.50 $8.75 $9.00 $9.25 Schools & govt buildings per acre $33.75 $37.50 $40.00 $42.50 $43.75 $45.00 $46.25 Multiple family& churches per acre $81.00 $90.00 $96.00 $102.00 $105.00 $108.00 $111.00 Commercial and industrial per acre $135.00 $150.00 $160.00 $170.00 $175.00 $180.00 $185.00 STORM DOIAGE UTILITY RATE STUDY: 1997 O 3: No increase in 1997, Modest Increases ThAofter 99 495 ....... .... ... . ..... Start of Year Cash & investments EXPENDITURES Operations Personal Service 102,491 102,708 60,000 60,000 62,160 64,398 66,716 Contractual Service 96,228 80,141 50,000 50,000 51,800 53,665 55,597 Supplies & Materials 3,178 25 40,000 40,000 41,440 42,932 44,477 Other operating 2,100 2,116 22,298 11,000 11,396 11,806 12,231 TOTAL EXPENDITURES $203,997 $184,990 $172,298 $161,000 $166,796 $172,801 $179,021 REVENUES Billing Revenues $685,011 $788,897 $832,000 $832,000 $884,000 $910,000 $936,000 Miscellaneous Operating 0 0 0 0 0 0 0 Miscellaneous Non-operating 0 0 0 0 0 0 0 TOTAL REVENUES $685,011 $788,897 $832,000 $832,000 $884,000 $910,000 $936,000 2 Non Operating Expenditures Capital Outlay (685,000) (1,204,471) (1,150,000) (571,500) (400,000) (300,000) (300,000) Debt Service 1,830,000 (90,925) (198,815) (241,595) (243,520) (244,700) (245,200) Non Operating Revenues Interest Earnings 2,294 (18,044) 75,964 40,401 34,503 40,778 54,308 Total Net Effe on Fund Balance 1,628,308 (709,533) (613,149) (101,694) 108,187 233,277 266,086 End of Year Cash & Investments W0. 1 1 For Information ... .. ... ... .................. - 3 .................. . .. , 0, , I 32 dix: ... ...... . 3 AC X SASE: T 7 . .. ............ ....... Residential rate per lot $6.75 $7.60 $8.00 $8.25 $8.50 $8.75 $9.00 Schools & govt buildings per acre $33.75 $37.50 $40.00 $41.25 $42.50 $43.75 $45.00 Multiple family & churches per acre $81.00 $90.00 $96.00 $99.00 $102.00 $105.00 $108.00 Commercial and industrial per acre $135.00 $150.00 $160.00 $165.00 $170.00 $175.00 $180.00 „F BROOKLYN CENTER RECYCLING UTILITY • 1997 RATE REVIEW Background The City Council on October 10, 1995 adopted Resolution 95 -227, which established recycling utility rates for 1996. The Council annually reviews established rates for their adequacy and makes adjustments as necessary. Recycling Financial Performance The recycling fund is primarily comprised of fees paid to Hennepin Recycling Group (HRG) for recycling services and, the charges to individual households to cover those costs. Some incidental expenditures and revenues are included for container sales and supplies. The recycling utility's financial performance was as expected for 1995 with net operating income P g (revenues minus expenditures) ending at $2,594. This slim operating income was due in part to a decision by HRG to provide a number of indoor /outdoor recycling containers for its member communites. Performance for 1996 is projected to provide for a net operating income of approximately $15,000. Rate Setting Considerations The Hennepin Recycling Group (HRG) has established and approved their 1997 operating budget. In that budget, HRG has indicated that Hennepin County will not decrease the recycling entitlement currently given to all HRG Communities. As a result, HRG has indicated that there will be no need for an increase in fees for 1997. The rate will be maintained at $2.15 per household per month. Recommendation It is recommended that the rate increase established for 1997 in table 1, be implemented as planned, Rates would be maintained as follows: TABLE 1 RECOMMENDED RECYCLING UTILITY RATES Recycling Rate Per Month 1996 1997 • Residential Households (Per Month) $2.15 $2.15 Residential Households (Annual) $25.80 $25.80 s -r 1997 WATER AND SANITARY SEWER HOOKUP RATES • BACKGROUND Utility hookup rates are adjusted annually to account for inflation. This year the change in the Twin Cities Consumer Price Index was 3.0 percent. Accordingly, the proposed water and sanitary sewer hookup rates for calendar year 1997 have been increased 3.0 percent. RECOMMENDATION Approve the following hookup rates: Current Rates Proposed Rates Type of Property /Assessment 1996 1997 WATER HOOKUP Single Family Residence With $3,500.00 $3,605.00 Service* Single Family Residence Without 2,675.00 2,755.25 Service* Frontage (front 135 feet) $35.65 per front foot $36.72 per front foot Area (area outside front 135 feet) $11.00 per 100 square feet $11.33 per 100 square feet Service Hookup $825.00 $850.00 SANITARY 'SEWER HOOKUP Frontage $20.72 per front foot $21.34 per front foot Service Hookup $825.00 $850.00 * The difference between these two rates are: "With service" means a service was installed to the property line at the time the water main was installed, but the property did not hook up to city water and was never assessed for the service. "Without service" means no service was ever installed. A property now choosing to hook up would pay the hook up charge to the city, and hire a private plumber to install a service out to the water main. • v Projec 53rd Brookdale Pond Orchard Ln France Ave Fire Police /City Hall Liquor Net Sou EDA $1,000,000 CDBG $393,000 CDBG Loan $1,157,000 Capital /Gen. Fund $567,950 $3,200,000 Tax Increment $1,900,000 MN State Aid $288,400 Local State Aid $50,000 ($29,950) Utility Funds $150,000 $1,745,450 $117,050 Income(Sales) $250,000 Bonds $3,200,000 $300,000 Special Assessments $1,362,100 $127,500 Gr $200,000 $100,000 _ TOTAL $3,200,000 $2,000,000 $3,675,500 $503,000 $3,200,000 $3,500,000 $0 Gross Impact of Major Projects: Cash* Spent , Begining Balance Infl Endin EDA $1,000,000 $2,400,000 $1,400,000 CDBG $393,000 CDBG Loan $1,157,000 $0 ($1,157,000) or HUD loan Capital /Gen. Fund $3,767,950 $4,700,000 $500,000 $1,432,050 Tax Increment $1,900,000 $3,000,000 $1,100,000 MN State Aid $288,400 Local State Aid $20,050 Utility Funds $2,012,500 $6,098,717 $1,527,342 $5,613,559 Income(Sales) $250,000 Building Bonds $3,500,000 Special Assessments $1,489,600 Grants $300,000 $16,078,500 $16,198,717 $8,388,609 *Note: some funds have substantial loans receivable Project Cost $3,200,000 ($1,000,000)EDA Trust ($250,000) land sales & building sales ($200,000) Water, sewer & local aid ($393,000) current & next CDBG ($200,000) State Grant (applied, not recieved) $1,157,000 CDBG loan/ or loan internal pay back CDBG or partial use TIF housing component Current Rate CDBG Years Repayment annual $200,000 5 $1,000,000 rehab loan $60,000 5 $300,000 Section 108 HUD loans 5 times annual CDBG = $1,250,000 must repay in 6 years F � MEMORANDUM DATE: October 4, 1996 TO: Michael McCauley, City Manager FROM: Diane Spector, Director of Public Servic SUBJECT: Brooklyn Boulevard Improvement Project On 10/2/96 representatives of the City and Hennepin County met to discuss strategies for the improvement of Brooklyn Boulevard from 65th to 71 st. The following persons were in attendance: BROOKLYN CENTER: Michael McCauley, Brad Hoffman, Diane Spector, Scott Brink HENNEPIN COUNTY: Jim Grube, Bruce Polaczyk, Craig Twinem, Dave Swenson At issue was the potential cost of right of way acquisition for the road widening project, and the lack of information regarding the cost of potential damages and environmental cleanup. As you know, the preliminary design of the widening project and of the enhancements project has been completed, and the environmental assessment has been completed and submitted to the Federal Highway Administration, which has just issued a Finding of No Significant Impact (FONSI). The purpose of the meeting was to brainstorm ideas for either raising everyone's level of comfort in going ahead with the project as proposed, or redefining the project to achieve some level of improvement at a lesser financial risk. Three options were identified: 1) Consider reconstructing only a part of the roadway, specifically the segment from I694.to 69th Avenue, then applying the funds budgeted for the entire corridor to this segment. The other segments would be programmed for future improvement, when additional fiends are available. 2) Purchase right of way as it becomes available over the next five to seven years, then construct the improvement five to seven years from now. 3) Mill and overlay the entire segment, with the only improvement being the installation of a continuous median from I694 to 69th. The County has received $1.6 million in Intermodal Surface Transportation Efficiency Act (ISTEA) funding for the roadway project, and the City $500,000 for the enhancement project. The next step in the process of determining the future of Brooklyn Boulevard improvements is to meet with Mn/DOT to determine if the first option identified above would meet the traffic safety and capacity objectives expressed in the ISTEA application. If Mn/DOT is of the opinion that the objectives would not be met, then it would not approve the use of the ISTEA funding for this option. If option 2 were to be pursued, both the County and the City would decline the use of the ISTEA funding, and would reapply for funding for the period 2001 -2002. There is no guarantee that this application would be approved, but the previous application did very well in the funding competition. Finally, if Option 3 were to be pursued, it is likely that the property owners on both sides of the street would be concerned over the loss of some access to their properties. Next Steps Hennepin County will schedule a meeting with Bob Brown, District State Aid Engineer, to review options. It is hoped that this meeting can take place before the end of the month. Hennepin County is also prepared to hire a consultant to conduct Phase I environmental studies, to get a better handle on the probable extent of potential contamination. MEMORANDUM TO: Michael McCauley, City Manager FROM: Scott Kline, Chief of Police DATE: October 7, 1996 SUBJECT: Mobile Computing Device (MCD) Project Update The following is the time line for the installation of the MOD's in the ten marked police squad cars: October 7, 1996 Delivery of Brooklyn Center's Ten Badger GT486N Computers to LOGIS October 21, 1996 Installation of Software ( "debugged" and tested by software vendor) October 24 -31, 1996 System Testing LOGISBrooklyn Center October 22 -31, 1996 Training of Brooklyn Center Police Personnel (administrators, officers, dispatchers) October 31, 1996 Mounting Completed in Ten Marked Police Squads November 1-7,1996 Live Operations Begins The following features will be operational on the MCD's when "live" operations begins: ► Car to Car Communication ► Car to Dispatch Communication ► MCD Messaging among all Users on the Police System ► Ability to have Call for Service Dispatched ► Ability to Acknowledge a Dispatched Call for Service ► Ability to Time Stamp Arrival at Scene for a Call for Service ► Ability to Pull a Case Number for a Call for Service ► Ability to Add Comments about a Call for Service ► Ability to Notify Officer of Previous Calls for Service to Location of Current Call ► Ability to Display Current Status of all Units ► Ability to Inquire Brooklyn Center's Records System Memorandum to M. McCauley Page 2 October 7, 1996 The following are future features of the MCD's and their time line: ► Car to State Communication (drivers license, registration information) December 1996 ► Car to Hennepin County Communication (warrant information) First quarter of 1997 The city has the following funds allocated for the MCD project: $31,548 Software Development (Resolution 94 -252) Paid December 1994 $13,230 1996 Budget Contractual (4400) Monthly LOGIS Module Charge $345 per month (November and December $690) Monthly RAM Air Time Charge $99 per month/per unit (November and December $1,980) Monthly State Charge $30 per month/per unit (December $300) Maintenance (one year parts and labor included) Transfer $4,354 to Capital Other Equipment (4552) for Ten Mounts $75,020 1996 Budget Capital Other Equipment (4552) Purchase of Ten Badger GT -486N and Mounts (Resolution 96 -96) Purchase Order Number 94003 - Ten Badger GT -486N Units and One -third Cost for LOGIS Badger Unit ($72,974) Ten mounts will be $640 each - Transfer $4,354 from Contractual (4400) to increase Capital Other Equipment (4552) to $79,374 Memorandum to M. McCauley Page 3 October 7, 1996 $500 1996 Budget Capital Mobile (4553) RAM System Radio Modem Registration (ten units at $50 each) By the end of 1996 the city would have spent approximately $113,992 on the MCD project. This includes software development, the purchase of ten laptop computers and mounts, and operation costs for November and December 1996. Annual operating expenses are the following (budgeted in 1997): Monthly LOGIS Module Charge $345 per month ($4,140) Monthly RAM Air Time Charge $99 per month/per unit ($11,880) Monthly State Charge $30 per month/per unit (December $3,600) Maintenance ($2,000) Total annual operating expenses are budgeted at 23,500. This budgeted amount includes some funds for the future features in 1997. Without extensive work it is unknown if the Badger GT486N units would be compatible with the Hennepin County system. We can only assume that this would be an extensive project and require a fair amount of software development. The current Mobile Digital Terminal (MDT) of Hennepin County is a Motorola 9100 terminal. Rental of the units is $1,190 per unit/per year. A five -year commitment must be made when renting the units. In addition, there is a $30 per month/per unit access charge for communication to the state. Under the Hennepin County MDT's we would be able to have car to car, car to state and car to Hennepin County communication. We would have to rent units for dispatch if we would want car to dispatch communication. The Hennepin County units would not be compatible with our current computer system. The cost for twelve MDT's from Hennepin County for the five -year commitment would be $71,400. An additional $4,320 annually would be expended for the state communication. SK:pph