Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017 10-16 CCP Joint Work Session with Financial Commission
AGENDA CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION Monday, October 16, 2017 6:30 p.m. City Hall — City Council Chambers I. Call to Order II. Approval of Agenda III. Enterprise Funds a. Earle Brown Heritage Center b. Centerbrook Golf Course c. BC Liquor IV. Utility Funds a. Water Utility b. Sanitary Sewer Utility c. Storm Drainage Utility d. Streetlight Utility e. Recycling Utility V. Future Budget Discussions/City Council Meetings Work Sessions 1) Removed Oetob30, �T City Coimcil Meetings 1) Utility Rates Adopted November 27, 2017 2) Public Hearing & Budget Adoption December 4, 2017 VI. Adjournment MEMORANDUM - MY COUNCCH...,/Fff1� A1\\JCUL DATE: October 16, 2017 TO: Curt Boganey, City Managa4 FROM: Nathan Reinhardt, Finance Director lK SUBJECT: 2018 Enterprise Fund Budgets Recommendation: It is recommended that the City Council consider providing direction to staff regarding the Enterprise Fund budgets for 2018. Background: Enterprise Funds are programs provided by the City which generate their own revenues for operations and capital maintenance. In the case of the Brooklyn Center Liquor fund, it's expected to generate enough revenue to support capital projects in other funds of the City, thereby reducing the need of funding from the property tax levy. The City operates the following three Enterprise Funds: • BC Liquor • Centerbrook Golf Course • Earle Brown Heritage Center Staff has attached and will present information on the expected revenues and expenditures for operation of the City's Enterprise Funds for 2018. The expenditures include total direct and indirect costs including depreciation of capital assets and administrative costs. Fund narratives, budgeted amounts, and net income information for each fund from 2010 through the 2019 budgets are attached. Strategic Priorities: • Enhanced Community Image Mission: Ensuring nn attractive, clean, safe, inclusive conununio, that enhances the duality of life for all people and preserves the public trust Q O O K L Y CHNVh � h 1 AT TNE�4ENTER City of Brooklyn Center 2018 Budget - Enterprise Funds Summary Revenues Charges for goods and services Investment earnings Miscellaneous Total Revenues Expenditures 60900 61300 61700 Municipal Centerbrook Earle Brown Off -Sale Golf Heritage Liquor Course Center Total $ 6,400,200 $ 249,000 $ 4,982,269 $ 11,631,469 18,512 - 17,937 36,449 2,700 2,250 10,000 14,950 6,421,412 251,250 5,010,206 11,682,868 Enterprise operations 6,142,706 293,770 5,107,282 11,543,758 Total Expenditures/Expenses 6,142,706 293,770 5,107,282 11,543,758 Other Financing Sources and Uses Transfers in - 50,000 - 50,000 Transfers out (232,906) (7,138) (449,561) (689,605) Total Other Financing Sources & Uses (232,906) 42,862 (449,561) (639,605) Net Change in Fund Balance $ 45,800 $ 342 $ (546,637) $ (500,495) Cash Flow Powerpoint Presentation i i 1i '''1 i 11�' ,• 1 1 Department Name: Community Activities, Recreation & Services Earle Brown Heritage Center Department/Division Mission: To deliver a high quality customer experience by providing exceptional customer service and extraordinary food service in an uncommon setting. Department/Division Description: Earle Brown Heritage Center is comprised of four divisions; Convention Center, Administrative Services, Catering Services and Commercial Office Rentals. These Divisions provide for the provision of maintenance, conference services, custodial functions, equipment servicing, development of menus, preparing and serving of food and beverage for events at Earle Brown Heritage Center. Maintenance of buildings and grounds for the commercial office spaces/buildings located at Earle Brown Heritage Center for 3 tenants. A management agreement with Flik International for the food and beverage is currently in place through the year 2019. Ivey Initiatives focused on the achievement of strategic priorities/value propositions Customer Intimacy ® Deliver a High Quality of Service We will strive to maintain our current level of 92% repeat of corporate clients, by reviewing feedback from event evaluations and growing our new creative team, which was initiated in 2014 to foster innovations and enhancements to our customer experience. Community Image ® Premier Conference Facility and Centerpiece for the City of Brooklyn Center In 2018, the Earle Brown Heritage Center will celebrate 28 years of operation as one of the regions premier conference and events facilities, and as a centerpiece of the Brooklyn Center community. Through our 2018 marketing efforts, we will continually highlight Earle Brown Heritage Center and the City of Brooklyn Center. Key Infrastructure Investments ® Increase Capital Fund Transfer In 2018, we are increasing our revenue goals to 4.9 million. By doing so, our goal is to increase our yearly transfer of fiinds into our Capital Improvements Fund from $300,000 to $350,000. Staffing Levels Positions FTEs 2017 2018 2019 ® EBHC Manager 1 1 1 ® Secretary/Receptionist 1 1 1 ® SecretaiyBilling Cleric 1 1 1 ® Operations Director 1 1 1 ® Sales Director 1 1 1 ® Sales Managers 3 3 4 ® Maintenance Custodian 3 3 32 2 2 ® Crew Chiefs 9 9 9 ® Part-time Staff 22 22 23 Total Strategic Fun ctionsBivision(s): Administration Division o This division provides administrative duties for all divisions. Provide a high level of customer service to guests and vendors. ® Convention Center Division o This division is responsible for the daily operations for all events. To promote and sell all rooms, manage food, beverage, audio visual equipment and special requests made by clients. ® Catering Division o This division is responsible for facility owned equipment, product, and building maintenance related to catering. Flik food and beverage contract expenses are found in this area. ® Office Rental o This division responds to any tenant concerns and maintains buildings. Annual Goal and Strategies: 1. Promote and sell the facility in accordance to the 2018 Marketing Plan. a. Participate in five industry associations to network for business b. Add a minimum of 35 new corporate clients c. Work with Flik International, Embassy Suites, and other area hotels on bookings of events. N7 2. Deliver a high quality customer experience a. Build interpersonal relationships with clients to generate higher customer satisfaction, commitment and loyalty. b. Client requests and changes will be responded to quickly. c. Showcase food & beverage services each day based upon client requests and current market trends. 3. Be responsible to our enviromnent by reducing our resource use and food waste. a. Reduce electrical consumption by upgrading light fixtures b. Be part of the Trim Trax program on food waste reduction Annual Operating Goal Performance Measures: Performance Objectives Description of Performance Measure Performance bevels Actual Value Target Value Increase Revenue 4,877,018 4,982,380 Control Expenses (Percentage of Cost to Revenue) 43.15%/62.19% 41.90%/67.00% Customer Satisfaction Rating 99% 100% New Corporate Clients 32 35 Revenue per Event (Corporate) $11,060 $12,130 Increase Misc. Catering Sales $29,367 $32,000 *2016 data EARLE BROWN HERITAGE CENTER (EBHC) FUND - 61700 ENTERPRISE FUND 5586 - COST OF SALES-MISC 5591 - COST OF SALES -LABOR 5592 - COST OF SALES -FOOD 5593 - COST OF SALES -SUPPLIES 5594 - COST OF SALES-MGMT FEES TOTAL COST OF GOODS SOLD TOTAL OPERATING REVENUES OPERATING EXPENSES 6101 - WAGES & SALARIES -FT EMPLOYEES 6102 - OVERTIME -FT EMPLOYEES 6103 - WAGES -PART TIME EMPLOYEES 6104 - OVERTIME -PARTTIME EMPLOYEES 6111 - SEVERANCE PAY 6122 - PERA COORDINATED PLAN 6125 - FICA - SOCIAL SECURITY 6126 - FICA - MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6141 - UNEMPLOYMENT COMPENSATION 6151 - WORKER'S COMP INSURANCE TOTAL PERSONAL SERVICES 6201 - OFFICE SUPPLIES 6202 - COPYING SUPPLIES 6203 - BOOKS/REFERENCE MATERIALS 6211 - CLEANING SUPPLIES 6212 - MOTOR FUELS 6214 - CLOTHING & PERSONAL EQUIPMENT 6215 - SHOP MATERIALS 6216 - CHEMICALS/CHEMICAL PRODUCTS 6217 - SAFETY SUPPLIES 6219 - GENERAL OPERATING SUPPLIES 6223 - BUILDINGS & FACILITIES 6225 - PARK & LANDSCAPE MATERIALS 6226 - SIGNS & STRIPING MATERIALS 6227 - PAINT SUPPLIES 6237 - LAUNDRY SUPPLIES 6239 - OTHER REPAIR & MAINT SUPPLIES 6241 - SMALL TOOLS 6242 - MINOR EQUIPMENT 6243 - MINOR COMPUTER EQUIPMENT TOTAL SUPPLIES - 75 - 2017 - 0.00% 756,025 1,180,142 1,195,165 2015 2016 September 2017 2018 584,286 2019 Object Code / Description Actual Actual YTD Budget Budget Change Budget 61700 - EARLE BROWN HERITAGE CENTER 159,449 0.93% 161,012 135,600 123,600 84,400 126,600 OPERATING REVENUES 2.37% 132,600 2,033,464 2,066,065 1,441,226 2,302,570 2,346,790 4821 - ROOM RENTALS $ 744,607 $ 816,337 $ 590,921 $ 800,000 $ 810,000 1.25% $ 825,000 4822 - LABOR CHARGES 22,287 26,935 14,655 25,000 25,000 0.00% 25,000 4823 - EQUIPMENT RENTALS 374,926 421,967 283,905 440,000 460,000 4.55% 480,000 4825 - COMMON AREA MTNCE 12,220 21,866 16,399 13,063 13,063 0.00% 13,063 4827 -SECURITY SERVICES 21,688 21,050 11,190 28,000 28,000 0.00% 28,000 4828 - CLIENT SERVICES 62,247 56,362 40,572 70,000 70,000 0.00% 70,000 4829 - MISCELLANEOUS 3,120 3,600 2,882 4,500 4,500 0.00% 5,000 4831 - OFFICE RENTALS 100,122 103,175 75,241 103,175 103,175 0.00% 103,175 4842 - SERVICE CHARGES 517,739 535,041 394,686 559,100 580,100 3.76% 592,000 4844 - FOOD & BEVERAGE SALES 2,298,614 2,397,586 1,772,205 2,469,383 2,499,531 1.22% 2,516,500 4845 - LIQUOR/WINE/BEER SALES 292,867 266,889 197,968 345,720 349,900 1.21% 351,900 4848 - MISCELLANEOUS SALES 36,823 29,367 13,999 47,614 39,000 -18.09% 48,000 TOTAL SALES AND USER FEES 4,487,260 4,700,175 3,414,623 4,905,555 4,982,269 1.56% 5,057,638 5586 - COST OF SALES-MISC 5591 - COST OF SALES -LABOR 5592 - COST OF SALES -FOOD 5593 - COST OF SALES -SUPPLIES 5594 - COST OF SALES-MGMT FEES TOTAL COST OF GOODS SOLD TOTAL OPERATING REVENUES OPERATING EXPENSES 6101 - WAGES & SALARIES -FT EMPLOYEES 6102 - OVERTIME -FT EMPLOYEES 6103 - WAGES -PART TIME EMPLOYEES 6104 - OVERTIME -PARTTIME EMPLOYEES 6111 - SEVERANCE PAY 6122 - PERA COORDINATED PLAN 6125 - FICA - SOCIAL SECURITY 6126 - FICA - MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6141 - UNEMPLOYMENT COMPENSATION 6151 - WORKER'S COMP INSURANCE TOTAL PERSONAL SERVICES 6201 - OFFICE SUPPLIES 6202 - COPYING SUPPLIES 6203 - BOOKS/REFERENCE MATERIALS 6211 - CLEANING SUPPLIES 6212 - MOTOR FUELS 6214 - CLOTHING & PERSONAL EQUIPMENT 6215 - SHOP MATERIALS 6216 - CHEMICALS/CHEMICAL PRODUCTS 6217 - SAFETY SUPPLIES 6219 - GENERAL OPERATING SUPPLIES 6223 - BUILDINGS & FACILITIES 6225 - PARK & LANDSCAPE MATERIALS 6226 - SIGNS & STRIPING MATERIALS 6227 - PAINT SUPPLIES 6237 - LAUNDRY SUPPLIES 6239 - OTHER REPAIR & MAINT SUPPLIES 6241 - SMALL TOOLS 6242 - MINOR EQUIPMENT 6243 - MINOR COMPUTER EQUIPMENT TOTAL SUPPLIES - 75 - - - 0.00% 756,025 1,180,142 1,195,165 884,032 1,367,395 1,394,327 1.97% 1,407,992 584,286 616,045 389,470 650,600 663,414 1.97% 669,916 133,436 131,180 83,324 157,975 159,449 0.93% 161,012 135,600 123,600 84,400 126,600 129,600 2.37% 132,600 2,033,464 2,066,065 1,441,226 2,302,570 2,346,790 1.92% 2,371,520 2,453,796 21634,110 1,973,397 21602,985 2,635,479 1.25% 2,686,118 615,023 634,437 482,448 717,325 732,682 2.14% 756,025 2,132 1,483 2,329 1,000 1,000 0.00% 1,000 151,072 144,162 105,914 181,600 171,000 -5.84% 171,000 37 59 139 - - 0.00% - 6,006 6,813 - - - 0.00% - 53,523 51,904 39,138 66,775 67,852 1.61% 69,603 49,168 48,890 36,760 55,202 56,091 1.61% 57,536 11,499 11,434 8,597 12,909 13,120 1.63% 13,458 111,593 118,203 103,552 175,344 185,861 6.00% 196,950 854 3,264 - - - 0.00% - 24,969 23,852 17,813 25,803 27,360 6.03% 27,962 1,025,876 1,044,501 796,690 1,235,958 1,254,966 1.54% 1,293,534 2,277 3,606 2,223 3,400 3,700 8.82% 4,200 1,711 1,989 1,477 2,550 2,800 9.80% 3,300 299 - 30 200 200 0.00% 200 77 1,354 588 3,300 3,300 0.00% 3,300 62 12 79 200 200 0.00% 200 536 768 488 1,040 1,040 0.00% 1,040 123 154 74 650 650 0.00% 650 6,007 5,647 4,970 5,900 5,900 0.00% 6,000 1,354 825 379 1,300 1,300 0.00% 1,300 27,597 25,779 20,577 32,500 32,500 0.00% 33,500 22,724 23,599 21,611 28,000 28,000 0.00% 30,000 4,003 4,716 2,517 5,900 5,900 0.00% 5,900 257 - 220 450 450 0.00% 450 1,415 2,017 1,031 2,750 2,750 0.00% 3,200 6 - 80 80 0.00% 80 6,205 3,115 3,475 9,000 9,000 0.00% 9,000 626 1,210 532 1,200 1,200 0.00% 1,200 45,249 74,218 16,177 98,000 104,000 6.12% 111,000 2,544 5,574 29,802 46,300 10,200 -77.97% 30,000 123,072 154,583 106,250 242,720 213,170 -12.17% 244,520 6301 - ACCTG, AUDIT & FIN'L SERVICES 1,684 1,956 1,561 2,000 2,000 0.00% 2,000 6303 -LEGAL SERVICES 149 151 173 1,000 1,000 0.00% 1,000 6307 - PROFESSIONAL SERVICES 29,285 54,260 23,690 70,900 48,400 -31.73% 41,700 6321 - TELEPHONE/PAGERS 8,735 8,173 5,491 9,922 9,712 -2.12% 9,712 6322 - POSTAGE 554 767 728 2,450 1,800 -26.53% 1,300 6331 -TRAVEL EXPENSE/MILEAGE 643 597 697 1,000 1,000 0.00% 1,000 6333 - FREIGHT/DRAYAGE - - 500 500 0.00% 500 6341 -PERSONNEL ADVERTISING 202 800 800 0.00% 800 6361 - GENERAL LIABILITY INSURANCE 8,967 5,422 2017 2,477 5,197 109.81% 5,509 6362 - PROPERTY INSURANCE 2015 2016 September 2017 2018 -2.66% 2019 Object Code / Description Actual Actual YTD Budget Budget Change Budget 6349 - OTHER ADVERTISING 121,489 117,474 90,170 168,625 189,300 12.26% 194,300 6351 - PRINTING 16,189 2,107 7,348 15,500 16,500 6.45% 17,500 6402 - EQUIPMENT SERVICES 45,026 63,881 88,361 66,300 66,300 0.00% 76,600 6403 - BLDGS/FACILITIES MAINT SERVICE 3,918 3,972 6,626 5,650 51,650 814.16% 35,650 6406 - MULTI -FUNCTION MTNCE 3,023 3,388 1,722 3,600 3,725 3.47% 3,725 6408 - COMMUNICATION/INFO SYSTEMS 118 221 - - - 0.00% - 6409 - OTHER REPAIR & MAINT SVCS 1,308 1,308 981 1,900 1,900 0.00% 1,900 6413 - OFFICE EQUIPMENT 495 - - 4,300 4,300 0.00% 4,500 6415 - OTHER EQUIPMENT 177,567 211,940 118,035 210,500 215,500 2.38% 215,500 6421 - SOFTWARE LICENSE - - - - - 0.00% - 6422 - SOFTWARE MAINT 7,837 7,300 6,717 10,350 10,705 3.43% 10,705 6423 - LOGIS CHARGES 18,064 21,751 13,203 24,377 25,127 3.08% 26,010 6428 - PROTECTION SERVICES 14,955 15,635 8,090 19,000 19,000 0.00% 19,000 6432 - CONFERENCES AND SCHOOLS 7,968 6,362 7,490 16,100 18,200 13.04% 20,100 6433 - MEETING EXPENSES 550 580 390 900 1,200 33.33% 1,400 6434 - DUES & SUBSCRIPTIONS 4,106 4,104 3,950 4,570 4,600 0.66% 4,600 6435 - CREDIT CARD FEES 39,398 42,113 17,921 32,000 33,800 5.63% 34,000 6436 - UNCOLLECTIBLE CHECKS/DEBTS 1,971 (1,253) - - - 0.00% - 6438 - CASH SHORT (OVER) (278) (174) (143) - - 0.00% - 6441 - LICENSES, TAXES & FEES 9,136 9,071 5,929 6,400 6,900 7.81% 6,900 6443 - PRIZE AWARDS/EXPENSE REIMB - - 200 - - 0.00% - 6449 - OTHER CONTRACTUAL SERVICE 42,249 77,441 64,461 43,000 78,000 81.40% 80,500 6451 - MTG PLANNER POINTS-EBHC 3,000 3,000 0.00% 3,000 TOTAL SERVICES & OTHER CHARGES 556,341 653,125 473,791 724,644 814,919 12.46% 813,902 6361 - GENERAL LIABILITY INSURANCE 8,967 5,422 3,993 2,477 5,197 109.81% 5,509 6362 - PROPERTY INSURANCE 26,487 25,577 16,612 26,859 26,144 -2.66% 27,713 6366 - MACHINERY BREAKDOWN INSURANCE 2,397 2,310 1,583 2,470 2,545 3.04% 2,697 TOTAL INSURANCE 37,851 33,309 22,188 31,806 33,886 6.54% 35,919 6381 - ELECTRIC 121,306 129,039 101,381 143,500 153,500 6.97% 153,500 6382 - GAS 41,058 33,022 31,139 44,500 46,500 4.49% 47,500 6383 - WATER 4,104 5,380 3,829 7,480 7,600 1.60% 7,700 6384 - REFUSE DISPOSAL 8,910 8,870 6,362 9,800 9,900 1.02% 10,000 6385 - SEWER 5,984 6,384 4,354 6,500 6,500 0.00% 6,600 6386 -STORM SEWER 3,108 3,106 1,913 5,000 5,000 0.00% 5,100 6389 -STREETLIGHTS 936 936 602 1,200 1,200 0.00% 1,200 TOTAL UTILITIES 185,406 186,737 149,580 217,980 230,200 5.61% 231,600 6494 - DEPRECIATION EXPENSE 620,248 182,004 128,491 188,517 189,351 0.44% 189,351 TOTAL DEPRECIATION 620,248 182,004 128,491 188,517 189,351 0.44% 189,351 TOTAL OPERATING EXPENSES 2,548,794 21254,259 1.676,990 21641,625 2,736,492 3.59% 2,808,826 OPERATING INCOME (LOSS) (94,998) 379,851 296,407 (38,640) (101,013) 161.42% (122,708) NONOPERATING REVENUES 4603 - INTEREST EARNINGS 9,847 16,394 15,387 10,296 17,937 74.21% 17,937 4604 - CHECK PROCESSING FEES 30 30 - - - 0.00% - 4605 - UNREALIZED INVESTMENT GAIN/LOSS 731 (2,802) 0.00% - TOTAL INVESTMENT EARNINGS 10,608 13,622 15,387 10,296 17,937 74.21% 17,937 4606 - OTHER REVENUE 26,096 14,526 11,342 - 10,000 100.00% 10,000 4912 - CAPITAL CONTRIBUTIONS - 131,550 - - 0.00% - 4921 - REFUNDS & REIMBURSEMENTS 10,776 17,145 0.00% TOTAL MISCELLANEOUS 36,872 163,221 11,342 10,000 100.00% 10,000 TOTAL NONOPERATING REVENUES 47,480 176,843 26,729 10,296 27,937 171.34% 27,937 NONOPERATING EXPENSES 6471 - ADMINISTRATIVE SERVICE TRANSFER 93,675 93,675 70,691 94,254 99,561 5.63% 99,561 6476 - CAPITAL PROJECT FUND TRANSFER 247,194 350,000 - 300,000 350,000 16.67% 400,000 6482 - MISC TRANSFER OUT 14,857 0.00% TOTAL TRANSFERS 355,726 443,675 70,691 394,254 449,561 14.03% 499,561 NET CHANGE IN FUND BALANCE _$___a0_3 244) -t--! 13 019 $ 252.445 $ (422,598) $ (522.637) 23.67% $ (594.332) City of Brooklyn Center 1,153,340 767,014 987,228 1,035,594 1,406,677 1,145,848 1,290,156 1,514,003 1,718,059 1,483,978 Earle Brown Heritage Center Cash Flows (208,849) (64,786) 119,684 177,788 128,290 67,167 23,876 72,198 - Revised: 104-17 - Revenues 3,667,199 3,946,297 4,119,660 4,491,190 4,293,056 4,587,603 4,665,991 4,754,515 4,915,851 5,010,206 Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget (5,532,843) 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Revenues 189,351 Cash Balance - Ending $ 767,014 $ 987,228 $ 1,035,594 $ 1,406,677 $ 1,145,848 $ 1,290,156 $ 1,514,003 $ 1,718,059 $ 1,483,978 $ Operating $ 3,542,077 $ 3,834,391 $ 4,048,739 $ 4,458,072 $ 4,271,578 $ 4,518,231 $ 4,487,260 $ 4,700,175 $ 4,905,555 $ 4,982,269 $ 5,057,638 Investment Earnings 10,960 1,653 8,358 3,831 (1,667) 9,170 16,829 22,639 10,296 17,937 17,937 Nonoperating 646 85 62,563 29,287 23,145 60,202 161,902 31,701 - 10,000 10,000 Capital Contributions 113,516 110,168 - - - - - - - - - Transfers Total 3,667,199 3,946,297 4,119,660 4,491,190 4,293,056 4,587,603 4,665,991 4,754,515 4,915,851 5,010,206 5,085,575 Expenditures Cost of Goods Sold 1,816,865 1,954,574 2,085,239 2,193,973 2,134,988 2,089,293 2,033,464 2,066,065 2,302,570 2,346,790 2,371,520 Personal Servcies 926,848 850,538 919,854 920,770 944,189 1,032,898 1,025,875 1,044,498 1,235,958 1,254,966 1,293,534 Supplies 109,075 137,760 137,114 145,899 154,762 172,112 123,072 154,579 242,720 213,170 244,520 Other Services & Charges 477,020 476,987 607,214 786,505 689,656 689,650 697,269 787,466 818,898 914,480 913,463 Insurance 47,949 47,615 48,557 48,176 27,642 40,052 37,852 33,310 31,806 33,886 35,919 Utilities 166,919 193,823 193,000 187,311 207,654 206,821 185,406 186,739 217,980 230,200 231,600 Rent - - - - - - - - - - - Depreciation 624,329 628,867 632,486 672,539 672,394 683,625 620,249 182,005 188,517 189,351 189,351 Capital Outlay - - - 15,261 123,284 111,636 101,031 - - - - Nonoperating - - - - - - - - - - Transfers Out 300,000 200,000 400,000 168,000 262,051 350,000 300,000 350,000 400,000 Total 4,469,005 4,290,164 4,823,464 4,970,434 5,354,569 5,194,087 5,086,269 4,804,662 5,338,449 5,532,843 5,679,907 CashBalance- Beginning 1,153,340 767,014 987,228 1,035,594 1,406,677 1,145,848 1,290,156 1,514,003 1,718,059 1,483,978 1,150,692 Changes in Accruals (208,849) (64,786) 119,684 177,788 128,290 67,167 23,876 72,198 - - - Revenues 3,667,199 3,946,297 4,119,660 4,491,190 4,293,056 4,587,603 4,665,991 4,754,515 4,915,851 5,010,206 5,085,575 Expenditures (4,469,005) (4,290,164) (4,823,464) (4,970,434) (5,354,569) (5,194,087) (5,086,269) (4,804,662) (5,338,449) (5,532,843) (5,679,907) Noncash - Depreciation 624,329 628,867 632,486 672,539 672,394 683,625 620,249 182,005 188,517 189,351 189,351 Cash Balance - Ending $ 767,014 $ 987,228 $ 1,035,594 $ 1,406,677 $ 1,145,848 $ 1,290,156 $ 1,514,003 $ 1,718,059 $ 1,483,978 $ 1,150,692 $ 745,711 F, Earle Brown Heritage Center- Net Income (Excludes Depreciation & Transfers) 600,000 500,000 400,000 300,000 200,000 100,000 (100,000) M 9 2009 Actual 2010 Actual 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2018 Budget 2019 Budget 9 G) Qa U n� W o Tj •� (JJ°� U Q) o r_ f u M � wcJ� y_ ° o U� 0 6 0 E .M � c • ® W �..,� � .0 QJ 5 e chi .(3) ® ' O Qa LILO o ® U u;_= 0 C 0 ._ � M com m -�+ •� (3) 0 0- O .i LU M ° M W dJ � N � ® N u •� (j) w Q) ° Ln UO . E C O w �_ E •� Qa °�o -a wQ) m L: Mu— L 0 > M ® -a-0 ®® 0 G) r -i r -I rH r -I r -I qzt M N m N N r -I r -I r -I r -I r -I M m N m N N r -i r -I r -i r—i r -I M M N m N is N s` N _ U 0 Q N � m b.0U m c6LU V)U cn cn Ln :3 U � c w LL (n 4-1U - • - CO w v ca i v cn v 0 C.) cn O — cn � ir+� v L U c6 ca is aA46 O Q) 0 O ® , > ®L cn t]n V u V O t� z � e CL O '� `.�l1cJ (U 4- xaj ° U_ ° > a) o m U 4. L m E a >. QJ u o 00 N 0 u vt N 0 uj L +r 4- ( O ® �O Q1 L (1)® O U 4J t1n j o to +Ln W u m 4J N �_ (11 C CL u � O L N L i6 -+ L 0 o E° ai ai a, E > u U i 00 O `a 4J rl CU s O U ON O N� a � � L � 4- u p u m U O aA Q1 (/i v =5 Ln L2 2 D 4� > o v c ° ? O t u > � o u �— n o o C7 °� > b.0m L aA _ L E aj (O (a E L U W L v N o s � E 4' O Ou O Qj O m ® v 00 •� L mL O - Q) A ® 4°1 ® V A S s u w LL A O ro 4� o 4d > O U 4J O 4- .Q M C: O t/1 .O L u E O ® � L ° L 4- M E v ® 'o s L E E O G� _ d � O ® co Q = V) U > - O W � O ® O _0 o > C: c0 L S O O L O an ° •- N lA C v u >- O L m QJ (D (32 Q) W 00 N O c -I fB O O 41 O N U L11 C � N (U L L ;om d--+ N Q Q� N U N Q.) O L U (13 W O � � C O c6 O bA C O ® N L F- 0 E u aJ u ® aJ o 4-j ajL U ro Ln � � Q C � CO O �A A a� L a� m O U 1 u U r N � �, f6 � N O N � N 07 L a--+ E, � U 4 O L QJ (10 �V L U � 00® O � `O � ® ® O N • Cil O N N F f� J O o Q1 0 � U N CCS uO 44-1 Ln- N co -0 LAU O � L ®> W QJ aJ N � U = (3j X N N N C6 i p bn SOA N O N v .O m m .� E t a1 O Ln c: N L e L a.� .Y O ® N (� O 0 O O � o2S f� > > E _ U >` O L C Ln n LL O c 0 Q) S Ln L a) Z3 n E L O C ri �_ L N O a) . �?� e E a)0 ® �0 a-0 Q ca eo O U un A A A A A A N (U L L ;om d--+ N Q Q� N U N Q.) O L U (13 W O � � C O c6 O bA C O ® N L F- 0 E u aJ u ® aJ o 4-j ajL U ro Ln � � Q C � CO O �A A a� L a� m 076 tuo � � 0 t � k o ± Q � m / R Ir- � LM n CL� C) 0 � � � 0 « t � k o ± Q o / R Ir- � � n q C) « § � / \ v © EA 6q � O & k � _ u § t » � \ � � 2 ƒ \ \ o ° m ® S d \ 3 G ' > k ) o u cn o R \ 2 & / U U ƒ « u to l C!J b o Lf) Mo o 7 W LAO co — — UO co � ,n— ° c� m je co m s w O0 6 Ln 0� b.0 (1) u V) >- M r'■� � o n EE a Mu fflo -C o U ' f Mu .-J a �� CA u V) �® N 0 n n L U u Mp 4-3 u Mo o UT © N q Mo U •� Q CU 4- Oo U U0 M 0--') c y� co (7 C6 �� Vn q o= UA u lJao c ( (� p� Do cO u o I u= co S.. CIO MO Q _� @) o o ao %,= O PA ra Cash Flow 6 OO 18 i 1 1 � 1. 1 ,1 1! Department Dame: Centerbrook Golf Course Department/Division Mission: To be a premier value Minnesota golf course, offering a challenging, well -conditioned course and exceptional customer service. Department/Division Description: Centerbrook Golf Course is a nine (9) hole, par three (3) golf course, owned by the City of Brooklyn Center. It was built in 1986-87, opened for business in the spring of 1988 and was established as an enterprise fund entity. Enterprise funds were established to account for the financing of self-supporting activities of the City, which render services on a user charge basis to the general public. Ivey Initiatives focused on the achievement of strategic priorities/value propositions Customer Intimacy • Continued focus on increasing awareness of Centerbrook golf and attempting to grow the game locally, with concentration on - Youth - Women - New golfers - Fling golf • Customer Service Continued focus on customer service and improving the customer experience. Staffing Levels Positions FTEs 2017 2018 2019 • Golf Course Superintendent 1 1 1 • Part-time Staff (10 - Seasonal) 1.75 1.75 1.75 Total 2.75 2.75 2.75 Strategic Functions/Division(s): • Customer Service Representative o To provide the highest quality playing conditions possible within the established budget limitations. Centerbrook Golf Course will strive to be an example of environmental sensitivity and aesthetic beauty for the community. • Turf Grass Technician o To provide an exceptional golfing experience for every patron. Our inside services staff will feature knowledgeable, customer focused staff that will provide exemplary customer service. 19 Annual Goal and Strategies: 1. To maintain optimal course conditions within established budget parameters. Limited use of chemicals Turf moisture content monitored Equipment enhancements 2. Continuous improvements and total customer satisfaction in all areas of operation. Customer Service language included in position descriptions Customer service training for all staff Customer service considered as part of annual performance evaluations Annual Operating Goal Performance Measures: Performance Measures Description of Performance Measure Performance Levels Actual Value Actual Value 2016* 2017* Number of Rounds Per Playable Days 87.88 95.79 Revenues Per Playable Day Operating Expenditures Per Round Operating Revenues Per Round Maintenance Cost Per Acre Golf Course Utilization- Actual Rounds Compared to Available Tee Times *Data through September 30th $1,673 $18.82 $19.05 $2,899 32.30% $1,840 $18.44 $19.21 $2,893 33.7% Capital Outlay and Other Initiatives with Significant Budget Impact $1,800 One additional parking lot security camera 20 Target Value 2018 97 $1,850 $18.25 $19.50 $2,850 34% CENTERBROOK GOLF COURSE FUND -61300 ENTERPRISE FUND TOTAL OPERATING REVENUES OPERATING EXPENSES 6101 - WAGES & SALARIES -FT EMPLOYEES 6103 - WAGES -PART TIME EMPLOYEES 6104 - OVERTIME -PART TIME EMPLOYEES 6111 - SEVERANCE PAY 6122 - PERA COORDINATED PLAN 6125 - FICA - SOCIAL SECURITY 6126 - FICA - MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6151 - WORKER'S COMP INSURANCE TOTAL PERSONAL SERVICES 6201 - OFFICE SUPPLIES 6211 - CLEANING SUPPLIES 6212 - MOTOR FUELS 6213 - LUBRICANTS & ADDITIVES 6214 - CLOTHING & PERSONAL EQUIPMENT 6215 - SHOP MATERIALS 6216 - CHEMICALS/CHEMICAL PRODUCTS 6217 - SAFETY SUPPLIES 6219 - GENERAL OPERATING SUPPLIES 6221 - MOTOR VEHICLES 6223 - BUILDINGS & FACILITIES 6225 - PARK & LANDSCAPE MATERIALS 6227 - PAINT SUPPLIES 6239 - OTHER REPAIR & MAINT SUPPLIES 6241 - SMALL TOOLS 6242 - MINOR EQUIPMENT 6243 - MINOR COMPUTER EQUIPMENT TOTAL SUPPLIES 208,225 221,604 197,652 241,500 249,000 3.11% 249.500 61,899 67,949 50,353 2017 74,603 4.55% 77,353 45,011 45,148 2015 2016 September 2017 2018 643 2019 Object Code / Description Actual Actual YTD Budget Budget Change Budget 61300 - CENTERBROOK GOLF COURSE - 0.00% - 5,124 5,366 3,777 5,352 OPERATING REVENUES 4.54% 5,801 6,917 7,292 6,057 7,261 7,462 4771 - GOLF LESSONS $ 355 $ 667 $ 564 $ 3,000 $ 2,000 -33.33% $ 2,000 4773 - GREEN FEES 114,856 113,861 98,280 120,000 120,000 0.00% 120,000 4778 - PASSBOOK 10,541 5,315 12,216 12,500 13,000 4.00% 13,500 4782 - RENTALS 19,231 25,764 26,587 22,000 29,000 31.82% 29,000 4785 - LEAGUE 10,180 11,944 16,193 18,000 18,000 0.00% 18,000 4786 - BEER & WINE COOLER REVENUES 24,312 29,774 27,091 29,000 36,000 24.14% 36,000 4787 - FOOD & BEVERAGE REVENUES 12,711 9,587 8,739 15,000 12,000 -20.00% 12,000 4788 -TAXABLE MERCHANDISE 1,921 10,455 1,695 3,000 3,000 0.00% 3,000 4789 - NON TAXABLE MERCHANDISE 5,177 7,239 5,052 7,000 7,000 0.00% 7,000 4790 - MISCELLANEOUS 5,328 5,678 - 6,000 6,000 0.00% 6,000 4791 - BOTTLED WATER SALES 3,613 1,320 1,235 6,000 3,000 -50.00% 3,000 TOTAL SALES AND USER FEES 208,225 221,604 197,652 241,500 249,000 3.11% 249,500 TOTAL OPERATING REVENUES OPERATING EXPENSES 6101 - WAGES & SALARIES -FT EMPLOYEES 6103 - WAGES -PART TIME EMPLOYEES 6104 - OVERTIME -PART TIME EMPLOYEES 6111 - SEVERANCE PAY 6122 - PERA COORDINATED PLAN 6125 - FICA - SOCIAL SECURITY 6126 - FICA - MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6151 - WORKER'S COMP INSURANCE TOTAL PERSONAL SERVICES 6201 - OFFICE SUPPLIES 6211 - CLEANING SUPPLIES 6212 - MOTOR FUELS 6213 - LUBRICANTS & ADDITIVES 6214 - CLOTHING & PERSONAL EQUIPMENT 6215 - SHOP MATERIALS 6216 - CHEMICALS/CHEMICAL PRODUCTS 6217 - SAFETY SUPPLIES 6219 - GENERAL OPERATING SUPPLIES 6221 - MOTOR VEHICLES 6223 - BUILDINGS & FACILITIES 6225 - PARK & LANDSCAPE MATERIALS 6227 - PAINT SUPPLIES 6239 - OTHER REPAIR & MAINT SUPPLIES 6241 - SMALL TOOLS 6242 - MINOR EQUIPMENT 6243 - MINOR COMPUTER EQUIPMENT TOTAL SUPPLIES 208,225 221,604 197,652 241,500 249,000 3.11% 249.500 61,899 67,949 50,353 71,357 74,603 4.55% 77,353 45,011 45,148 42,211 41,000 45,000 9.76% 45,000 643 765 1,875 750 750 0.00% 750 876 985 - - - 0.00% - 5,124 5,366 3,777 5,352 5,595 4.54% 5,801 6,917 7,292 6,057 7,261 7,462 2.77% 7,633 1,618 1,705 1,417 1,698 1,745 2.77% 1,785 12,708 13,488 10,116 13,488 14,297 6.00% 15,150 2,883 2,339 1,903 2,741 2,347 -14.37% 2,400 137,679 145,037 117,709 143,647 151,799 5.68% 155,872 342 273 47 250 200 -20.00% 200 25 145 - - - 0.00% - 2,764 2,495 2,039 2,900 2,500 -13.79% 2,500 61 181 140 - 200 100.00% 200 40 100 - 100 100.00% 100 55 30 35 - 200 100.00% 200 8,504 7,489 7,884 8,000 8,000 0.00% 8,000 - 53 61 100 100 0.00% 100 3,370 3,571 2,028 2,400 2,400 0.00% 2,500 1,171 761 1,566 600 750 25.00% 750 1,528 1,322 1,587 1,500 1,500 0.00% 1,500 2,319 1,266 2,195 2,500 2,500 0.00% 2,500 - 141 119 250 200 -20.00% 200 230 220 48 250 200 -20.00% 200 1,282 379 776 750 750 0.00% 750 2,360 6,515 1,912 1,500 1,500 0.00% 1,500 609 4,050 100.00% 24,051 25,550 20,437 21,000 25,150 19.76% 21,200 6307 - PROFESSIONAL SERVICES 118 121 954 250 250 0.00% 250 6321-TELEPHONE/PAGERS 1,741 1,649 1,050 1,827 1,712 -6.29% 1,712 6329 -OTHER COMMUNICATION SERVICES 1,365 1,559 1,190 1,600 - -100.00% - 6331 -TRAVEL EXPENSE/MILEAGE - - - 50 --100.00% - 6349 - OTHER ADVERTISING 4,094 2,805 4,959 3,600 4,000 11.11% 4,000 6351 - PRINTING 326 682 262 500 500 0.00% 600 6402 - EQUIPMENT SERVICES 1,605 4,055 2,625 2,500 2,500 0.00% 2,500 6403 - BLDGS/FACILITIES MAINT SERVICE - 1,275 202 750 750 0.00% 750 6415 - OTHER EQUIPMENT 26 14,431 9,559 5,500 9,500 72.73% 9,500 6422 - SOFTWARE MAINT 408 406 346 600 620 3.33% 6423 - LOGIS CHARGES 4,359 5,131 3,377 6,268 6,475 3.30% 6,701 6432 - CONFERENCES AND SCHOOLS 499 539 299 500 500 0.00% 500 6433 - MEETING EXPENSES 224 71 114 100 100 0.00% 100 6434 - DUES & SUBSCRIPTIONS 1,580 1,615 1,615 1,300 1,300 0.00% 1,300 21 6435 - CREDIT CARD FEES 3,758 4,324 1,799 3,300 3,000 -9.09% 300 6438 - CASH SHORT (OVER) (26) 17 10 - - 0.00% 1,000 6441 - LICENSES, TAXES & FEES 400 383 672 500 700 40.00% 700 6449 - OTHER CONTRACTUAL SERVICE 1,312 1,886 674 700 700 0.00% 700 6491 - MERCHANDISE FOR RESALE 31,674 32,524 22,952 23,000 23,000 0.00% 23,000 TOTAL SERVICES & OTHER CHARGES 53,463 73,473 52,659 52,845 55,607 5.23% 52,613 TOTAL UTILITIES 16,334 19,642 18,396 19,150 19,150 0.00% 6361 - GENERAL LIABILITY INSURANCE 3,165 1,710 724 968 1,024 5.79% 1,085 6362 -PROPERTY INSURANCE - 1,906 1,479 2,020 2,091 3.51% 2,216 6364 - DRAM SHOP INSURANCE 970 1,419 1,486 1,076 1,142 6.13% 1,142 6366 - MACHINERY BREAKDOWN INSURANCE 6465 - REPLACEMENT CHARGES 218 175 231 247 6.93% 262 TOTAL INSURANCE 4,135 5,253 3,864 4,295 4,504 4.87% 4,705 6381 - ELECTRIC 9,805 9,804 7,640 8,600 8,600 0.00% 8,600 6382 -GAS 770 811 752 1,000 1,000 0.00% 1,000 6383 - WATER 2,425 5,475 7,483 6,000 6,000 0.00% 6,000 6384 -REFUSE DISPOSAL 1,691 1,897 1,265 1,750 1,750 0.00% 1,750 6385 - SEWER 628 640 495 650 650 0.00% 650 6386- STORM SEWER 1,015 1,015 761 1,150 1,150 0.00% 1,150 TOTAL UTILITIES 16,334 19,642 18,396 19,150 19,150 0.00% 19,150 6461 - FUEL CHARGES 119 103 128 119 171 43.70% 177 6462 - FIXED CHARGES 490 132 1,205 1,808 1,616 -10.62% 1,664 6463 - REPAIR & MAINT CHARGES 3,424 3,768 2,810 2,906 2,640 -9.15% 2,719 6465 - REPLACEMENT CHARGES 249 1,512 7,900 11,850 11,850 0.00% 12,206 TOTAL CENTRAL GARAGE CHARGES 4,282 5,515 12,043 16,683 16,277 -2.43% 16,766 6540- EQUIPMENT &MACHINERY 7,123 7,000 1,800 -74.29% 1,800 TOTAL CAPITAL OUTLAY 8,946 5,154 71123 7,000 1,800 -74.29% 1,800 6494 - DEPRECIATION EXPENSE 18,737 18,788 14,014 19,228 19,483 1.33% 19,500 TOTAL DEPRECIATION 18,737 18,788 14,014 19,228 19,483 1.33% 19,500 TOTAL OPERATING EXPENSES 258.681 293,258 246,245 283,848 293,770 3.50% 291,606 OPERATING INCOME (LOSS) (50,456) (71,654) (48,593) (42,348) (44,770) 5.72% (42,106) NONOPERATING REVENUES 4362 - COUNTY GRANTS/AID 6,746 16,481 - 0.00% 4373 - OTHER GRANTS/AID - - 7,000 -100.00% 4612 - DONATIONS & CONTRIBUTIONS - - - 500 -100.00% - 4921 - REFUNDS & REIMBURSEMENTS 121 22 40 2,250 2,250 0.00% 2,000 TOTAL MISCELLANEOUS 6,867 16,503 40 9,750 2,250 -76.92% 2,000 4915 - TRANSFERS IN 40,000 45,000 - 45,000 50,000 11.11% 50,000 TOTAL NONOPERATING REVENUES 46.867 61,503 40 54,750 52,250 -4.57% 52,000 NONOPERATING EXPENSES 6471 -ADMINISTRATIVE SERVICE TRANSFER 8,946 8,946 5,154 6,872 7,138 3.87% 7,138 NET CHANGE IN FUND BALANCE $ (12,535) $ (19,0971 $ (53.707) $ 5.530 $ 342 93.82% $ 2.756 22 City of Brooklyn Center Centerbrook Golf Course Cash Flows Revised: 10-4-17 Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Revenues Operations $ 249,310 $ 219,159 $ 190,995 $ 207,827 $ 167,280 $ 183,311 $ 208,225 $ 221,604 $ 241,500 $ 249,000 $ 249,500 Investment earnings 81 - - - - - 121 - - - - Nonoperating 92 6 230 200 375 182,186 6,746 16,503 9,750 2,250 2,000 Interfund Proceeds 33,422 66,227 63,778 - 76,813 76,997 - - - - - Transfers 200,000 40,000 45,000 45,000 50,000 50,000 Total 282,905 285,392 255,003 408,027 244,468 442,494 255,092 283,107 296,250 301,250 301,500 Expenditures 2017 Budget 2018 Budget 2019 Budget Personal Services 152,793 147,917 132,935 109,254 121,415 128,453 137,679 145,037 143,647 151,799 155,872 Supplies 18,245 17,011 15,406 19,901 19,537 25,980 24,051 25,548 21,000 25,150 21,200 Other Services & Charges 90,915 90,521 79,205 86,373 86,401 75,758 66,691 87,934 76,400 79,022 76,517 Insurance 7,045 7,485 5,897 4,958 4,605 3,736 4,135 5,253 4,295 4,504 4,705 Utilities 21,664 23,460 21,569 23,535 21,514 18,564 16,334 19,642 19,150 19,150 19,150 Depreciation 28,185 28,184 28,185 28,261 10,787 18,738 18,737 18,788 19,228 19,483 19,500 Capital Outlay - - - - - 176,377 - - 7,000 1,800 1,800 Interfund Payments 163,427 Total 318,847 314,578 283,197 435,709 264,259 447,606 267,627 302,202 290,720 300,908 298,744 Cash Balance - Beginning 8,645 - - - 123 400 - - - 24,758 44,583 Changes in Accruals (888) 1,002 9 (456) 9,281 (14,026) (6,202) 307 - - - Revenues 282,905 285,392 255,003 408,027 244,468 442,494 255,092 283,107 296,250 301,250 301,500 Expenditures (318,847) (314,578) (283,197) (435,709) (264,259) (447,606) (267,627) (302,202) (290,720) (300,908) (298,744) Noncash - Depreciation 28,185 28,184 28,185 28,261 10,787 18,738 18,737 18,788 19,228 19,483 19,500 CashBalance- Ending $ - $ - $ - $ 123 $ 400 $ - $ - $ - $ 24,758 $ 44,583 $ 66,839 Interfund Loan $ 33,422 $ 99,649 $ 163,427 $ - $ 76,813 $ 153,810 $ 144,982 $ 144,982 Interfund Advance $ 792,488 $ 792,488 $ 792,488 $ 792,488 $ 792,488 $ 792,488 $ 792,488 $ 792,488 $(10,000) $(20,000) $(30,000) $(40,000) $(50,000) $(60,000) $(70,000) $(80,000) $(90,000) $(100,000) Centerbrook Golf Course - Net Income (Excludes Depreciation & Transfers) 23 2009 Actual 2010 Actual 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2018 Budget 2019 Budget 23 LL J 0 (D 0 v 0. M 04 N I Q i 00 (3) O 4- O rCD O O CY)Q � O .-. p Co ■ +- Z3 L N LL t_Aco 0 -O N N O � O o � °' U •� U .� > c _ ._ o U _ F5 U) a) c� O v m :�� co a) U) ) U) U) O 4- O � i p (� cn (3)U � r_ •L:~ a U �Eo CL U to p cn N .� O + 0 O — .— N N p Q L O M (n U) U) Q. +- U) a) L. Q a) a) Uov J = N coo -a N U U) � O LO LO 00 N (3) r Co N O r N 00 C rLO 00 N N W L N O r LO 00 N (3) N W L N 4-0 U) d 'a %.. •i� O �"' O O CL 0 a '�^ ^ a i a 14 u O N -O -1--j ±' u) O ON > = � Cn L 4-J L 9 O C: 4— U) U O_ .� C: _ a O 0 U) -0 L O U N ryn V L Q O N cz -C M C: O U) +_ O .� O -0 . CU ® > O C: :tf O N � U) N (6 to Cl. U Q C � O O 'j L U) O N N N C: O -L N L L O M Z O U c_ O cu O a) -� a) L � 0~ .- -EO a) •�E� )o cn N _0 U U aj -O -2 Z xE to U U) U O %C: p I— Q. o m U 14 u � � N L 9 o � o a O 0 ma) L O U N ryn -C 0-0 O O -0 O Q O N 0000(a Cl. U > � O O 'j L U) N N N C: O -L U) L L O M Z O a)0-0 E O O -� W L 0~ cn N _0 U U aj to U U) .o U)0-wU. . cn N x o L . a) O cm E may.- Ln -0 N o i _m U I— U E m� 0 V E O O O O U O -0 O +- NCU 0) > N U o T 0 0 E U U -a M cu 0 0 ■ O O) O v a) m Z 11, a a 0 0 0 o O �- o � c: E O Z3 r- O E U U v � U v 0 V IA1 00 � o CD � � ca C: a� 4-1 U Q � (0 (6 � O N C Q d IA1 00 0 N a1 O Ln O O Ln N ul Ill r- 6 l6 � 00 Zt > ri r1 rl N M 4. ci rl O N N 0) is 00 Lf)r-Ir-i tvj Ql tf)- ih i/} q!} M U a r -I O N M N Ill Ql (11 00 1- 00 O a) p 00 0o M 06 p N 00 r-1 r -I r -I N ilk t/} M (0 u U a � m Lm O m '� •� � ¢ o W a. =a N m � a c _ _ N i cc v a a d x m °�' a w o En w w 0w 0 2 awF°-' L U O Q 0 70 L O 4— O O 00 L O 4— r�7 LL L O .-a U) O 4-j L Ca _>I U E O L- 4- 0 4—O L O 4— O 0 U) M M U 9 I U) lo -11 U) Aa Ca U � -U) � N O MCL T o>IJ_ 0 0 0 ° A -a a3 't Lo O o M p � Ca W v — � U U)Q C :3 U �- U)O O X W u� � O E O U � O � i � • • Narrative • Budget • Cash Flow • Powerpoint presentation 32 2018 Brooklyn Department Budget by 1'; Department Flame: Fiscal & Support Services BC Liquor Stores # 1 & # 2 Department/Division Mission: Operate two municipal retail liquor stores to provide for the controlled sale and distribution of alcoholic beverages in the community. Profits from the operations are used to fund projects benefitting the community and avoiding the necessity of larger property tax levies for such projects. Department/Division Description: The BC Liquor Division of the Fiscal & Support Services Department operates two retail liquor stores under Minnesota Statutes 426 and Chapter 11 of the City's Code of Ordinances. These stores sell a wide variety of products including spirits, wine, beer, cigarettes and sundry items such as glassware, ice and non -intoxicating beverages. Store # 1 is the larger of the two stores in located in the Brookdale Corners shopping center at 5625 Xerxes Avenue. Store# 2 is located in the Boulevard Marketplace shopping center at 6930 Brooklyn Boulevard. The stores operate Monday through Saturday. Special events are provided through a Wine Club, a Beer Club and Platinum Club (joint membership in both Wine and Beer) of BC Liquors. These clubs meet to provide information about the products, sample tastings and special sales opportunities for products featured at the events. Additionally, BC Liquors assists Surly Brewing with its annual Darkness Day celebration. BC Liquor leases space near the Surly Brewing premises and effectively opens a store nearby there to facilitate off - sale distribution of the very popular Surly Darkness beer. Ivey Initiatives focused on the achievement of strategic priorities/value propositions Community Image ® Staff Development ➢ Continue GUEST model training with employees ➢ Continue towards 100% of staff trained on Product Information Trainings (PIT'S) Upkeep of stores ➢ Carts for products continue to disappear, we will add more for customer use. Respond to Customer Needs ➢ In 2018, we will begin the process of assessing our options for store#1 when our lease expires in 2 years. We will do a business site feasibility analysis in 2018 that will look into the possibility of moving or owning store #1. ➢ Sunday sales started July 2, 2017. We have shown a level of success and will continue to assess and adjust staff levels and hours as needed. ® Positive City Image ➢ We will look into replacing all staff uniforms with the new city logo 33 Staffing Levels Positions FTEs 2017 2018 2019 ® Liquor Operations Manager 1 1 1 ® Liquor Store Manager 3 3 3 ® Liquor Store Assistant Manager - - - ® Liquor Store Office Assistant 1 1 1 ® Liquor Store Category Lead FT 1 1 1 ® Liquor Store Category Lead (2-3 - PT Staff) 1.2 1.2 1.2 ® Liquor Store Shift Lead (6 — PT Staff) 3 3 3 ® Store Clerk/Stocker (19-22 - PT staff) 4.5 5.5 5.5 TOTAL 14.7 15.7 15.7 Strategic Functions/Division(s): ® BC Liquor Division o The Division provides for the wholesale purchase, merchandise display, and sale of alcoholic beverages and sundry items. The stores are monitored by clerics and by a system of cameras to discourage theft and assist in identifying theft incidents. Each store prepares deposits of proceeds from the day's sales immediately at the close of the day. The Division also sponsors special events each year such as tasting club events for wine and beer enthusiasts and off -sale services at local brewery events. Every year profits from the liquor department are transferred back to the city for use in capital projects. While the funds are an important part of operating a municipal liquor operation they are not the sole purpose. Alcohol is a substance that should be regulated and monitored, therefore we are diligent in training our staff to be aware when a minor or obviously intoxicated person may be attempting to purchase alcohol and present a danger to our city. Annual Goal and Strategies: 1. Promote and sell alcoholic beverages in a controlled environment which minimizes the risk of unlawful procurement of alcoholic beverages by minors or obviously intoxicated patrons. a. Random compliance checks provided by law enforcement b. Regular training and support of clerks 2. Promote knowledge of alcoholic beverages through Tasting Club events. a. Events scheduled twice per year for solely wine and twice for solely beer with one additional event combining both beer and wine presentations and tasting 3. Provide profitable operations such that dollars may be transferred from the Liquor Fund to the Capital Improvements Fund and other funds as approved by the City Council to lower the need for property tax revenues while subsidizing the repair and maintenance needs of the City. 34 a. Reserve a specified transfer in the budget process Annual Operating Goal Performance Measures: Performance Objectives Description of Performance Levels Performance Measure Previous Value (2016) *Actual Value (2017) Target Value Inventory Variance Levels $14,395 $7,042 (Goal <$12,000) <$10,000 Increase # of memberships 40club — 12 single 33 club — 4 single 70 club — 12 single in Tasting clubs (Goal 70-12) Compliance checks passed 75%(3/4) 100%(4/4) 100% (Goal 100%) Increase social media 97 Likes 176 Likes 200 Likes presence - Facebook (Goal 180) Increase social media 250 Followers 415 Followers 500 Followers presence — Twitter (Goal 450) Increase staff longevity — # 12 7 <6 of staff who did not reach (Goal <6) 90 days of employment *YTD data 35 MUNICIPAL OFF -SALE LIQUOR FUND - 60900 ENTERPRISE FUND 5581 -COST OF SALES -LIQUOR 1,632,920 1,736,928 2017 1,554,903 1,676,700 7.83% 1,706,370 5582 - COST OF SALES -WINE 2015 2016 September 2017 2018 -7.43% 2019 Object Code / Description Actual Actual YTD Budget Budget Change Budget 60900 - BROOKLYN CENTER LIQUOR 27,759 31,976 30,218 35,649 41,984 17.77% 42,752 OPERATING REVENUES 48,977 49,265 37,634 39,531 50,240 27.09% 51,328 4761 - LIQUOR SALES $ 2,298,636 $ 2,417,329 $ 1,832,974 $ 2,253,484 $ 2,430,000 7.83% $ 2,473,000 4762 - WINE SALES 747,797 764,042 528,065 755,958 699,800 -7.43% 685,800 4763 - BEER SALES 2,884,810 2,885,474 2,202,836 2,950,144 3,125,300 5.94% 3,213,360 4764 - SALES -NON TAXABLE 48,759 56,113 53,338 55,702 65,600 17.77% 66,800 4765 -SALES -TAXABLE 76,667 74,134 60,197 62,749 79,500 26.70% 81,200 TOTAL SALES AND USER FEES 6,056,669 6,197,092 4,677,410 6,078,037 6,400,200 5.30% 6,520,160 5581 -COST OF SALES -LIQUOR 1,632,920 1,736,928 1,285,919 1,554,903 1,676,700 7.83% 1,706,370 5582 - COST OF SALES -WINE 502,131 546,978 365,459 502,711 465,367 -7.43% 456,056 5583 - COST OF SALES -BEER 2,179,533 2,204,348 1,678,869 2,285,310 2,420,181 5.90% 2,487,987 5584 - OTHER COSTS OF SALE -NONTAXABLE 27,759 31,976 30,218 35,649 41,984 17.77% 42,752 5585 - OTHER COSTS OF SALE -TAXABLE 48,977 49,265 37,634 39,531 50,240 27.09% 51,328 5587 - INVENTORY VARIANCES 14,893 14,568 6,831 21,000 14,000 -33.33% 14,000 5589 - DELIVERY CHARGES 25,290 27,855 17,782 27,000 26,775 -0.83% 27,325 TOTAL COST OF GOODS SOLD 4,431,503 4,611,918 3,422,712 4,466,104 4,695,247 5.13% 4,785,818 TOTAL OPERATING REVENUES 1,625,166 1,585,174 1,254,698 1,611,933 1,704,953 5.77% 1,734,342 OPERATING EXPENSES 2,652 3,750 1,327 3,400 2,900 -14.71% 4,500 6101 - WAGES & SALARIES -FT EMPLOYEES 299,454 332,471 243,469 360,390 367,708 2.03% 380,115 6102 -OVERTIME -FT EMPLOYEES 1,345 343 58 2,700 1,700 -37.04% 1,000 6103 - WAGES -PART TIME EMPLOYEES 211,021 217,255 155,294 207,500 220,150 6.10% 222,150 6104 - OVERTIME -PART TIME EMPLOYEES 3,501 2,806 1,973 3,500 3,000 -14.29% 3,000 6111 - SEVERANCE PAY 3,177 3,614 1,960 - - 0.00% - 6122 - PERA COORDINATED PLAN 38,567 41,430 30,060 43,081 43,591 1.18% 44,520 6125 - FICA- SOCIAL SECURITY 33,142 35,891 25,965 35,613 36,035 1.18% 36,805 6126 - FICA- MEDICARE 7,751 8,394 6,072 8,330 8,427 1.16% 8,607 6131 -CAFETERIA PLAN CONTRIBUTIONS 38,007 63,928 48,380 80,928 100,079 23.66% 106,050 6141 - UNEMPLOYMENT COMPENSATION 1,565 317 - - - 0.00% - 6151 - WORKER'S COMP INSURANCE 16,021 25,075 17,895 15,392 24,994 62.38% 25,525 TOTAL PERSONAL SERVICES 653,551 731,524 531,126 757,434 805,684 6.37% 827,772 6201 -OFFICE SUPPLIES 1,149 2,361 543 1,300 1,700 30.77% 1,700 6214 - CLOTHING & PERSONAL EQUIPMENT 2,652 3,750 1,327 3,400 2,900 -14.71% 4,500 6219 - GENERAL OPERATING SUPPLIES 17,813 16,589 13,935 19,500 19,500 0.00% 19,500 6223 - BUILDINGS & FACILITIES - - - 2,500 2,500 0.00% 2,500 6239 - OTHER REPAIR & MAINT SUPPLIES - 954 3,163 - 2,000 100.00% 2,000 6242 - MINOR EQUIPMENT 5,413 23,523 3,067 8,000 9,000 12.50% 6,000 6243 - MINOR COMPUTER EQUIPMENT 25,220 2,957 6,823 7,000 2,850 -59.29% 1,600 TOTAL SUPPLIES 52,247 50,134 28,858 41,700 40,450 -3.00% 37,800 6301 - ACCTG, AUDIT & FIN'L SERVICES 3,368 3,912 3,122 4,000 4,000 0.00% 4,000 6303 - LEGAL SERVICES 1,411 - - - - 0.00% - 6307 - PROFESSIONAL SERVICES 14,352 12,942 2,687 21,600 12,000 -44.44% 12,000 6321 - TELEPHONE/PAGERS 3,564 3,345 2,259 3,729 3,792 1.69% 3,792 6331 - TRAVEL EXPENSE/MILEAGE 895 568 731 1,300 900 -30.77% 900 6341 - PERSONNEL ADVERTISING 110 - - 1,000 400 -60.00% 400 6349 - OTHER ADVERTISING 14,032 13,813 720 19,000 13,000 -31.58% 13,000 6351 - PRINTING 1,533 689 - 700 800 14.29% 800 6402 - EQUIPMENT SERVICES 4,493 7,986 5,805 7,000 9,000 28.57% 9,000 6403 - BLDGS/FACILITIES MAINT SERVICE 760 2,720 3,651 4,000 6,000 50.00% 6,000 6406 - MULTI -FUNCTION MTNCE 749 510 272 725 755 4.14% 575 6409 - OTHER REPAIR & MAINT SVCS - - - 1,000 1,000 0.00% 1,000 6422 - SOFTWARE MAINT 11,741 9,969 5,819 12,700 13,200 3.94% - 6423-LOGISCHARGES 21,096 26,198 20,494 26,572 27,378 3.03% 28,333 6428 -PROTECTION SERVICES 1,912 1,773 1,491 1,800 2,000 11.11% 2,000 6431 - SPECIAL EVENTS 10,500 10,524 5,003 8,500 8,500 0.00% 8,500 6432 - CONFERENCES AND SCHOOLS 2,400 2,145 4,148 3,600 5,200 44.44% 4,200 6433 - MEETING EXPENSES 145 61 79 50 50 0.00% 50 6434 - DUES & SUBSCRIPTIONS 4,363 4,810 7,550 7,000 7,000 0.00% 7,000 6435 - CREDIT CARD FEES 81,907 72,298 40,723 84,000 75,000 -10.71% 75,000 6438 - CASH SHORT (OVER) 1,807 1,749 2,048 2,000 2,000 0.00% 2,000 6441 - LICENSES, TAXES & FEES 60 60 - 720 720 0.00% 720 6449 - OTHER CONTRACTUAL SERVICE 7,788 13,249 8,671 8,000 9,000 12.50% 9,000 TOTAL SERVICES & OTHER CHARGES 188,986 189,321 115,273 218,996 201,695 -7.90% 188,270 6361 - GENERAL LIABILITY INSURANCE 5,494 4,765 3,438 4,806 4,920 2.37% 5,216 6362- PROPERTY INSURANCE 2,604 2,715 2,085 2,862 2,974 3.91% 3,153 6364 - DRAM SHOP INSURANCE 6,983 7,459 5,093 7,750 5,500 -29.03% 5,500 6366 - MACHINERY BREAKDOWN INSURANCE 660 630 486 653 688 5.36% 729 TOTAL INSURANCE 15,741 15,569 11,102 16,071 14,082 -12.38% 14,598 6381 - ELECTRIC 42,025 41,718 31,836 47,000 43,500 -7.45% 43,500 6382 -GAS 4,359 3,165 3,120 5,500 5,000 -9.09% 5,000 6383 -WATER 78,295 78,295 58,664 1,000 1,000 0.00% 1,000 TOTAL UTILITIES 46,384 44,883 34,956 53,500 49,500 -7.48% 49,500 6412-BLDGS/FACILITIES 311,553 333,317 238,732 290,640 314,860 8.33% 314,860 TOTAL RENT 311,553 333,317 238,732 290,640 314,860 8.33% 314,860 6461 - FUEL CHARGES 227 71 - 244 - -100.00% - 6462 - FIXED CHARGES 1,007 942 636 954 -100.00% 6463 - REPAIR & MAINT CHARGES 343 739 - 728 -100.00% 6465 - REPLACEMENT CHARGES 1,750 2,300 -100.00% TOTAL CENTRAL GARAGE CHARGES 3,327 1,752 636 4,226 -100.00% 6540 - EQUIPMENT & MACHINERY 85,000 -100.00% TOTAL CAPITAL OUTLAY 85,000 -100.00% 6494 - DEPRECIATION EXPENSE 16,967 20,994 16,307 20,872 21,188 1.51% 21,188 TOTAL DEPRECIATION 16,967 20,994 16,307 20,872 21,188 1.51% 21,188 TOTAL OPERATING EXPENSES 1,288,756 11387,494 976,990 11488,439 1.447,459 -2.75% 1.453,988 OPERATING INCOME 336.410 197.680 277,708 123,494 257,494 108.51% 280,354 NONOPERATING REVENUES 4603 - INTEREST EARNINGS 13,933 18,656 15,054 13,148 18,512 40.80% 18,512 4605 - UNREALIZED INVESTMENT GAIN/LOSS 1,073 (3,038) - 0.00% - TOTAL INVESTMENT EARNINGS 15,006 15,618 15,054 13,148 18,512 40.80% 18,512 4606 - OTHER REVENUE 2,000 2,000 1,544 - - 0.00% - 4921 - REFUNDS & REIMBURSEMENTS 20 5,216 3,912 500 700 40.00% 700 4922 - PROJECT ADMINISTRATION 2,992 2,274 1,740 2,000 2,000 0.00% 2,000 TOTAL MISCELLANEOUS 5,012 9,490 7,196 2,500 2,700 8.00% 2,700 TOTAL NONOPERATING REVENUES 20,018 25,108 22,250 15,648 21,212 35.56% 21,212 NONOPERATING EXPENSES 6471 -ADMINISTRATIVE SERVICE TRANSFER 78,295 78,295 58,664 78,219 82,906 5.99% 82,906 6476 - CAPITAL PROJECT FUND TRANSFER - - - 100,000 150,000 50.00% 150,000 6482 - MISC TRANSFER OUT 216,455 138,935 - - 0.00% TOTAL TRANSFERS 294,750 217,230 58,664 178,219 232,906 30.69% 232,906 NET CHANGE IN FUND BALANCE $ 61.678 _1_5 558 $ 241,294$ (39,0771 $ 45,800 217.20% $ 68.660 37 City of Brooklyn Center Offsale Liquor Store Cash Flows Revised: 10-6-17 Revenues Operating Investment Earnings Nonoperating Total Expenditures Cost of Goods Sold Personal Servcies Supplies Other Services & Charges Insurance Utilities Rent Depreciation Capital Transfers Out Total Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 $ 5,610,108 $ 5,543,026 $ 5,789,346 $ 5,963,908 $ 6,063,231 $ 5,852,465 $ 6,056,668 $ 6,197,094 $ 6,078,037 $ 6,400,200 $ 6,520,160 15,382 2,649 12,556 5,647 (3,723) 13,209 15,006 15,618 13,148 18,512 18,512 8,345 5,128 6,875 8,933 9,103 8,601 5,012 9,490 2,500 2,700 2,700 5,633,835 5,550,803 5,808,777 5,978,488 6,068,611 5,874,275 6,076,686 6,222,202 6,093,685 6,421,412 6,541,372 4,088,278 4,009,751 4,175,906 4,316,716 4,341,225 4,293,383 4,431,501 4,611,919 4,466,104 4,695,247 4,785,818 634,795 618,180 597,503 610,025 646,098 642,642 653,553 731,524 757,434 805,684 827,772 34,669 42,665 22,584 41,819 31,835 79,719 52,247 50,133 41,700 40,450 37,800 230,124 241,909 240,639 234,289 260,548 241,801 270,606 269,369 301,441 284,601 271,176 10,336 9,858 8,773 8,301 13,747 16,677 15,741 15,570 16,071 14,082 14,598 37,867 38,363 40,451 68,452 49,279 45,848 46,384 44,883 53,500 49,500 49,500 269,969 287,687 293,265 296,964 302,772 303,108 311,553 333,317 290,640 314,860 314,860 26,359 18,066 11,281 11,312 28,469 24,328 16,966 20,994 20,872 21,188 21,188 - - - - - - - - 85,000 - - 265,490 230,199 147,488 200,000 200,000 362,190 216,455 138,935 100,000 150,000 150,000 5,597,887 5,496,678 5,537,890 5,787,878 5,873,973 6,009,696 6,015,006 6,216,644 6,132,762 6,375,612 6,472,712 Cash Balance - Beginning 1,318,525 1,424,765 1,453,015 1,740,725 1,987,770 2,073,883 1,858,031 1,916,501 1,909,948 1,891,743 1,958,731 Changes in Accruals 43,933 (43,941) 5,542 45,123 (136,994) (104,759) (20,176) (33,105) 2009 Actual Revenues 5,633,835 5,550,803 5,808,777 5,978,488 6,068,611 5,874,275 6,076,686 6,222,202 6,093,685 6,421,412 6,541,372 Expenditures (5,597,887) (5,496,678) (5,537,890) (5,787,878) (5,873,973) (6,009,696) (6,015,006) (6,216,644) (6,132,762) (6,375,612) (6,472,712) Noncash - Depreciation 26,359 18,066 11,281 11,312 28,469 24,328 16,966 20,994 20,872 21,188 21,188 Cash Balance - Ending $ 1,424,765 $ 1,453,015 $ 1,740,725 $ 1,987,770 $ 2,073,883 $ 1,858,031 $ 1,916,501 $ 1,909,948 $ 1,891,743 $ 1,958,731 $ 2,048,579 Gross Profit - % 27% 28% 28% 28% 28% 27% 27% 26% 27% 27% 27% Growth in Sales - % 2% -1% 4% 3% 2% -3% 3% 2% -2% 5% 2% Cash Reserve Per Policy $ 1,813,188 $ 1,788,722 $ 1,815,804 $ 1,844,124 $ 1,875,585 Excess $ 103,313 $ 121,226 $ 75,940 $ 114,607 $ 172,994 G:\Budget\2018 Budget\Cash Flows\2017 Enterprise Funds 38 609 -Liquor 500,000 Liquor e Net Income (Excludes Depreciation, Transfers & Capital Outlay) - 450,000 400,000 - - -- -- 350,000 300,000 250,000 200,000 150,000 100,000 50,000 2009 Actual 2010 Actual 2011 Actual 2012 2013 2014 2015 2016 2017 2018 2019 Actual Actual Actual Actual Actual Budget Budget Budget G:\Budget\2018 Budget\Cash Flows\2017 Enterprise Funds 38 609 -Liquor eeo O N U .� Com! N -0 � t1') C6 m �� 4-j L O cry � N 0 � O U c o �cr U U Ll - co -_N 4-J 4_j U b.0 0 -� r a..+ O > Ln -0 0 N •N U O U cn — fa N = V)•O 0 O p Q. CLn -u .2 'PME4 O =3 V) O °' CA cr cQ O L- O N 4-J �_ 4-Jp •> • cE U — •N O O — • 4-J X U •� •N � ` v .j -'O v bT p p 0 U U Q 0 N � � �(A N v Q O ca a1 N m 075 Qj U > C- -0 � fa U i N Q a1 N N "a C =3P -a � c t4> c L- a1N ° Q ), E ❑ G � a--+ N aJ W v co a v ° v 1 o +, U E+� >` Qj E-CN G—� Q }' Q L U +-, ❑ n v n O - N N w U ro > C -O i u 4-�� ° - �- a4-JN J v U � '- (� O Q- cn .� v Co 0 p �o N o N i c cv a� v'x ai m° 4 � n N M� Qj L m -0 06 O > -0 a �O 'O U � o wU) 41B 3v C:) LL =1 a) x m C)-.— ca 4- - N ul aJ N m s N N aJ i > a� Ln k.0 � a)+J m QJ L -0 O — �M G a N � ®. ff o o U Ln Ln 2� co n M COm J Q �II Gi o ® L ® in- Q (� 1 V) oca c� v L v CL C6 L 4A o v o O U � O O E "' c O aCld u O L a � v bn Ln � L a� L P4 v '0 O u u ° O� �4 ;4 �-4 �4 �4 �4 o cz O V� CA � CA � � 0 0 0 0 0 0 0 4 u 06 76 LL CL N ,It M rl N N M O N O Q0 -Ln M O 00 O Q0 0 0 0 0 0 o c ON 0 O qzt w d' N l0 �t 00 O I� 00 I, ri Ln O O r-, M Ct' M r�-I m Q0 00 u1 l0 M r -i l0 al 0 tJ) M 00 U E ra Ln N 0� O 0 Ln _ — � cn v � O O O — Q. ' I�tM o w N N +J v aj r -i N N N 00 l0 O 1 x U o_ cn tYcn O N d' N N d' LO N 000 I- d' O O M l0 O M O qzt w d' N l0 �t 00 O I� l0 I, ri O r -I r1 m O Ct' r1 d' m Q0 00 M M r -i � tJ) c O :4-J m �U dJ i Q co N ca i vi U dJ .O L- CL Q m U N 0 N O u M V O M O qzt rH d' ri I� (Z O r -I l0 I, ri O r -I r1 • 9F c O :4-J m �U dJ i Q co N ca i vi U dJ .O L- CL Q m U N 0 N O u M V N Ln N u • 9F cn sem.. a U E ra Ln 0� O 0 Ln Ln 4- — � cn v Ln� NO 0 — Q. 4-)v + o w +J v aj CL x U o_ cn tYcn tY c O :4-J m �U dJ i Q co N ca i vi U dJ .O L- CL Q m U N 0 N O u M V C1A C L 0 E L U N aJ � � O _O C" Q 0 v _0 aJ W _: .E N co � L O Q 0 0 r -I E N 0 LU (D O a� v � C � O 0 -CL U V Ln O V) 4-- O QLN Q W N L U a) U m Q N .E a) U m Q a, L 0 N L CO U m 0 El E U r v CUD 'a 0.-- 0 u'O 4-J N Ln L 0 U a) L a1 N QJ L oN ai _ N 0 N U a) cu Q ai O QJ L 0 L ,C N =5 4- 0 (o 0 = 0 -0 txo C) O -� N -0 'V) N N N O a) ' Lf) Ln � p 0 S a..r 4.., N N U ON CL N 0ai (B 0 � •— a-+ C — _ .� f0 N .o •0- N Mj N a --i L (� 0 N un 00 oo.Nr' : N �.c 00 N >. aj O U c s _ m0 U) to _ E U r v G N c-1 LO v W C L p N 0 o Y O I O p O cn bn O Li- -FuV m N 00 U O Ln J Ql U C � c r -I C O O O LnO O O ^ `� f0 t1} I o —� co I- V ol O O O O -Fu�} O O O _� U 0 Ur c -I (D Ln H Ur d u m Q0 H O a, N � L v Lf) N Cr to o m m Ln ��-I -Q o n U- =3 ih 0) ^ O 0 U LI p N L CL G N c-1 LO J I`V�IETV ORAT`\\MU VIT o 0TY C O UNCMMNANC UL COIV1IMEMON JOt[D\�T 11 WORK S SSI®I`\T DATE: October 16, 2017 TO: Curt Boganey, City Managgo FROM: Nathan Reinhardt, Finance Director W_ SUBJECT: 2018 Public Utility Budgets Recommendation: It is recommended that the City Council/Financial Commission consider providing direction to staff regarding the 2018 public utility budgets and proposed utility rates for 2018. Background: Staff has attached and will present information on the expected expenditures for operation of the City's utility services for 2018. The expenditures include total direct and indirect costs including depreciation of capital assets and administrative costs. Along with those costs are projections of the revenues needed for 2018 and for the next fifteen years to keep operations running smoothly and fund the infrastructure improvements needed in each of the utility systems. The cash flow analysis for each of the five utilities indicate anticipated rate changes necessary to maintain targeted cash balances during the construction of the utility improvements associated with the City's 15 -year Capital Improvement Plan (CIP). Additional information is attached on the City's current and proposed rates shown with data from comparison cities for each utility. For 2018, a rate increase is proposed Storm Sewer in order to maintain cash reserves, fund normal operations, pay for debt service and finance infrastructure improvements. Rates for the various utilities for 2018 are shown in comparison to 2017 below: Fund -Description 2017 Rate 2018 Rate Change Water Base Charge - Residential $14.64 $14.64 No change (quarterly) Consumption Charge - Tier I (0 - 30 gallons) $2.44 $2.44 No change Residential Meters Tier II (31 - 60 gallons) 3.04 3.04 No change Tier III (61 and greater) 4.54 4.54 No change Consumption Charge - (per 1,000 gallons) $3.04 $3.04 No change Non-residential Sanitary Sewer Base Charge (quarterly) $82.42 $82.42 No change Storm Sewer Base Charge (quarterly) $14.48 $14.77 $0.29 /quarter Street Light Base Charge (quarterly) $6.55 $6.55 No change Recycling Base Charge (quarterly) $11.98 $11.98 No change Mission: Ensuring an attractive, clean, safe, inclusive conununio� that enhances the quality of life for all people and preserves the public trust 1 The quarterly utility bill for a household using 18,000 gallons of water (considered the typical residential user) is shown in comparison to 2017 rates as follows: Utility revenue needs are being predominately driven by debt service payments and infrastructure replacement costs identified in the Capital Improvement Plan over the next several years. The 2018 Budget includes a debt issue for the Firehouse Park Area neighborhood reconstruction project and Water Tower No. 2 Reconditioning. The debt would be repaid from a combination of sources that include utility revenues, special assessments and property tax levies. The proposed debt issue for 2018 is as follows: Fund (Revenue Source) Amount Street Reconstruction (tax levy) $2,800,000 Water $58.56 $58.56 $ - Sanitary Sewer 82.42 82.42 - Storm Sewer 14.48 14.77 0.29 Street Light 6.55 6.55 - Recycling 11.98 11.98 - Total $173.99 $174.28 $0.29 Utility revenue needs are being predominately driven by debt service payments and infrastructure replacement costs identified in the Capital Improvement Plan over the next several years. The 2018 Budget includes a debt issue for the Firehouse Park Area neighborhood reconstruction project and Water Tower No. 2 Reconditioning. The debt would be repaid from a combination of sources that include utility revenues, special assessments and property tax levies. The proposed debt issue for 2018 is as follows: Fund (Revenue Source) Amount Street Reconstruction (tax levy) $2,800,000 Water (user fees) 3,390,000 Storm Drainage (user fees) 1,810,000 Special Assessments (assessments) 2,110,000 Bond Discount/Issuance Costs 140,000 Total $10,250,000 Based on a 10 year term and net interest rate of 2.12% the annual payment would be approximately $1,150,000. The sources for the annual debt payments would be comprised of an estimated $326,000 of property tax levy, $369,000 in water user fees, $205,000 in storm sewer user fees, and $260,000 in special assessments. The debt issuance would allow the City to smooth utility rate increases over a period of time and staff feels this is the best approach considering the recent rate increases needed to fund the debt repayments on the PFA loan that was used to construct the City of Brooklyn Center water treatment plant. Strategic Priorities: • Enhanced Community Image • Resident Economic Stability • Inclusive Community Engagement • Targeted Redevelopment • Safe, Secure, Stable Community • Key Transportation Investments Alissio n: Ensuring an attractive, clean, safe, inclusive eom ninny that enhances the quality, of life fon• all people and preserves the public trust Department Dame: Public Works Utilities Division Department Mission: The mission of the Brooklyn Center Public Works Department -Utilities Division for the residents, business owners and visitors of the city is to responsibly provide for the maintenance and operations of the drinking water, sanitary sewer, storm water management and lighting systems in a quality, cost effective manner. Department Description: The Public Works Department is comprised of five divisions, including: Administration/Engineering; Street Maintenance; Park Maintenance; Public Utilities (water, sanitary sewer, storm sewer, street lighting); and Central Garage. The Public Works Department also assists in administrating the capital asset management for the City's public buildings and facilities. The Utilities division provides for the operation, maintenance and management of the City's drinking water system, sanitary sewer collection and conveyance system, storm sewer collection and management system, and street light system. Ivey Initiatives focused on the achievement of strategic priorities/value propositions Inclusive Community Engagement • General Community Outreach In 2018 we will continue the operation of the new water treatment plant. This new community asset must include a component of open and valuable community participation, outreach and education. Infrastructure — Key Investments • Critical Infrastructure Improvements In 2018 we will implement the 24t1' year of the street and utility construction program by providing the needed capital improvements, which increase value to the public infrastructure and provide a catalyst towards other infrastructure improvements and value throughout neighborhoods Citywide. • Capital Improvement Funding Strategy In 2018 a financial strategy that uses a combination of General Obligation Improvement Bonds, Utility Revenue Bonds, and Utility Fund rate adjustments will be used to fiend short fallings in Capital Improvement funding. Staffing Levels Positions FTEs 2017 2018 2019 • Supervisor of Utilities 1 1 1 • Engineering Technician 3 (distributed 1/3 over 49141, 49251 and 49411) 1 1 1 • Maintenance II (4-49141, 2-49251, 2-49411) 8 8 8 • Part Time/Summer Temporary Employees (3- 49141, 2-49251, 1-49411) 2.0 2.0 2.0 TOTAL 12.0 12.0 12.0 Strategic Functions/Division(s): ® Water Utility (4914 1) o We provide for the distribution of the City's potable water to customers. This division includes the operations, administration and utility billing for the utility. The division is managed by the Public Works Director, except for the utility billing component which is managed by the Finance Department. The City has approximately 121 miles of water main, over 1,300 water valves, and almost 1,000 fire hydrants providing service to over 7,000 metered single-family residential connections and approximately 1,600 metered apartments/townhouses/commercial/ industrial customers. Water is supplied from nine municipal wells. A new water treatment plant was opened in 2016. Also included in this division is the maintenance of meters, locating water mains and services, testing of the municipal water supply throughout the system as required, preventative maintenance, and emergency repairs to the City's distribution system and its appurtenances. The utility billing operation prepares and sends out utility bills, receives meter readings and makes estimated readings, and administers collections and assessment for non-payment. Sanitary Sewer Utility (4925 1) o We provide for the collection and conveyance of wastewater through a system of mains and lift stations. Sewage is treated by the Metropolitan Council Environmental Services, whose fees account for approximately 75% of this fund's expenditures. This division is managed by the Public Works Director, except for the utility billing component, which is managed by the Finance Department. The City has approximately 106 miles of sanitaiy sewer ranging in size from 8" to 24" in diameter, and just under 9,000 service connections. Included in this division is the routine and preventative maintenance of the City's collection system and its appurtenances, monitoring of inflow and infiltration, television inspection of the interiors of mains, and customer service such as providing sewer locations. This activity involves the operation and maintenance of the City's ten wastewater lift stations, which includes buildings, equipment, and property. Storm Sewer Utility (49411) o We provide for the collection and management of stormwater throughout the city in compliance with State and Federal regulatory requirements. The Storm Drainage Utility operates and maintains approximately 84 miles of storm sewers and just under 100 storm water management ponds or treatment devices. The Storm Drainage Utility also provides for street sweeping operations and the City's participation in two joint powers Watershed Commissions, which provide for regional planning, surface water quality monitoring, and Wetlands Conservation Act compliance. Streetlight Utility (49571) o We provide for electrical service, maintenance, repair, and replacement of lights owned by the City. The City owns approximately 71 ornamental lights in the Opportunity commercial area, 85 ornamental lights on Brooklyn Boulevard, 40 ornamental lights along Xerxes Avenue, 72 ornamental lights along Bass Lake Rd and 57th Avenue and leases approximately 915 lights from Xcel Energy. Another 97 lights owned by the City are located on traffic signal systems. The Street Light Utility also provides for electrical and maintenance fees paid to Xcel Energy for street lights owned by Xcel Energy. Annual Goal and Strategies: 1. Meet or exceed safe drinking water standards of the State of Minnesota and manage storm water runoff in an efficient and environmentally sensitive manner. a. Manage and enforce the City's Wellhead Protection Plan goals. b. Implement Best Management Practices (BMPs) that support the City's and Watershed's impaired waters Total Maximum Daily Load (TMDL) plans. C. Develop maintenance schedule and manual for Water Treatment Plant maintenance activities 2. Initiate improved, streamlined management strategies and techniques by use of refined methods and technologies. a. Update process flow charting for the utility department and emergency management. b. Automate the monthly well pumping records and reporting to the Minnesota Department of Health. Annual Operating Goal Performance Measures: Performance Objectives Description of Performance Measure Performance Levels -"Actual Value Target Value Number of private wells abandoned and sealed 59 >20 Administration fees to project cost ratio 9.3% <15% Miles of annual street sweeping performed 1,010 miles >990 miles (4 Citywide rounds, 10 rounds of targeted secondat areas Miles of annual sanitaiy sewer televised, cleaned, root -sawed and new pipe 29.6 > or = 19.6 miles (115 of the City's total 97.9 miles Private sanitaiy sewer backups per year (due to City system blockage 0 none *2016 data Capital Outlay and Other Initiatives with Significant Budget Impact ➢ 2018-19 Capital Improvement Projects — See CIP section of Budget ➢ 2018 -Walk Behind Concrete Saw -Budget $35,000 City of Brooklyn Center 3,720,000 2,715,000 2,603,000 375,000 - 2018 Budget - Public Utilities Funds Summary Debt service 1,525,969 425,242 116,650 OT TNECL NiEN - 2,067,861 Utility operations 3,431,713 4,222,214 60100 60200 65100 65200 65300 8,677,682 7,362,456 Sanitary Storm Street 21,748,365 Other Financing Sources and Uses Water Sewer Sewer Lights Recycling Total Revenues 3,390,000 - 1,825,000 - - Charges for goods and services $ 3,829,846 $ 4,333,111 $ 1,651,350 $ 450,500 $ 393,134 $ 10,657,941 Investment earnings 20,952 46,985 46,548 6,636 1,565 122,686 Total Revenues 3,850,798 4,380,096 1,697,898 457,136 394,699 10,780,627 Expenditures Capital outlay 3,720,000 2,715,000 2,603,000 375,000 - 9,413,000 Debt service 1,525,969 425,242 116,650 - - 2,067,861 Utility operations 3,431,713 4,222,214 1,916,601 313,947 383,029 10,267,504 Total Expend itures/Expenses 8,677,682 7,362,456 4,636,251 688,947 383,029 21,748,365 Other Financing Sources and Uses Issuance of debt 3,390,000 - 1,825,000 - - 5,215,000 Transfers out (105,996) (99,426) (99,426) (25,766) (11,169) (341,783) Total Other Financing Sources & Uses 3,284,004 (99,426) 1,725,574 (25,766) (11,169) 4,873,217 Net Change in Fund Balance $ (1,542,880) $ (3,081,786) $ (1,212,779) $ (257,577) $ 501 $ (6,094,521) W -Ta- M�l Budget Cash •Projectiong- Rate Comparisons Proposed WATER UTILITY FUND - 60100 PUBLIC UTILITY FUND 2017 2015 2016 September 2017 2018 2019 Object Code / Description Acbial Actual YTD Budget Budget Change Budget 49141 -WATER UTILITY -OPERATIONS OPERATING REVENUES 4701 - WATER SALES $ 2,185,246 $ 2,801,927 $ 2,419,093 $ 3,263,943 $ 3,424,846 4.93% $ 3,616,338 4702 - FIRE LINES 9,080 9,116 6,809 9,000 9,000 0.00% 9,000 4703 - WATER METER SALES 16,371 10,052 (20,821) 15,000 5,000 -66.67% 5,000 4704 - WATER METER RENTALS 5,575 3,025 125 3,000 3,000 0.00% 3,000 4705 - SERVICE RESTORATION FEES 2,232 1,488 1,010 3,000 3,000 0.00% 3,000 4706 - CONNECTION CHARGES 8,000 5,500 16,500 9,000 9,000 0.00% 9,000 4707 - PENALTIES 98,805 116,389 110,106 95,000 95,000 0.00% 95,000 4708 -TOWER RENTAL FEES 223,674 219,291 - 246,000 256,000 4.07% 256,000 4709 - CERTIFICATION CHARGES 24,510 24,750 25,320 25,000 25,000 0.00% 25,000 TOTAL SALES AND USER FEES 2,573,493 3,191,538 2,558,142 3,668,943 3,829,846 4.39% 4,021,338 TOTAL OPERATING REVENUES 2,573,493 3,191,538 2,558,142 3,668,943 3,829,846 4.39% 4,021,338 OPERATING EXPENSES 6101 - WAGES & SALARIES -FT EMPLOYEES 319,350 334,445 249,700 341,790 350,113 2.44% 360,543 6102 - OVERTIME -FT EMPLOYEES 41,489 54,158 35,019 43,000 48,000 11.63% 48,000 6103 - WAGES -PART TIME EMPLOYEES 22,214 24,640 24,863 22,500 22,105 -1.76% 22,105 6111 - SEVERANCE PAY 6,160 5,204 - - 0.00% - 6122 - PERA COORDINATED PLAN 27,063 29,145 21,354 30,368 31,515 3.78% 32,299 6125 - FICA - SOCIAL SECURITY 22,922 24,285 18,417 25,105 26,053 3.78% 26,701 6126 - FICA - MEDICARE 5,361 5,680 4,307 5,873 6,095 3.78% 6,246 6131 -CAFETERIA PLAN CONTRIBUTIONS 63,540 65,192 51,142 71,486 75,774 6.00% 80,295 6151 - WORKER'S COMP INSURANCE 13,295 13,539 10,170 16,054 17,398 8.37% 17,834 TOTAL PERSONAL SERVICES 521,394 556,288 414,972 556,176 577,053 3.75% 594,023 6201 -OFFICE SUPPLIES 1,769 1,360 939 1,800 1,800 0.00% 1,800 6203 - BOOKS/REFERENCE MATERIALS 292 - - 500 500 0.00% 500 6204 -STATIONARY SUPPLIES 142 827 791 1,610 1,610 0.00% 1,610 6212 - MOTOR FUELS - - 1,031 2,000 100.00% 2,000 6214 - CLOTHING & PERSONAL EQUIPMENT - - 50 250 400 60.00% 400 6216 -CHEM ICALS/CHEMICAL PRODUCTS 76,467 167,221 107,218 180,000 185,000 2.78% 185,000 6217 - SAFETY SUPPLIES 939 422 2,253 1,200 2,700 125.00% 1,200 6219 - GENERAL OPERATING SUPPLIES 3,984 10,914 6,435 11,600 11,600 0.00% 11,600 6223 - BUILDINGS & FACILITIES 1,500 - 42 1,500 1,500 0.00% 1,500 6224 - STREET MAINT MATERIALS 12,513 5,979 1,365 16,000 16,000 0.00% 16,000 6227 - PAINT SUPPLIES 923 1,116 1,240 1,100 1,600 45.45% 1,600 6235 - UTILITY SYSTEM SUPPLIES 8,151 6,772 10,184 16,000 16,000 0.00% 16,000 6239 - OTHER REPAIR & MAINT SUPPLIES 15,655 12,700 10,240 16,000 16,000 0.00% 16,000 6241 -SMALL TOOLS 496 238 391 500 500 0.00% 500 6242 - MINOR EQUIPMENT 37,059 8,057 8,826 20,000 14,600 -27.00% 10,000 6243 - MINOR COMPUTER EQUIPMENT 1,867 10,850 100.00% TOTAL SUPPLIES 161,757 215,606 151,005 268,060 282,660 5.45% 265,710 6301 - ACCTG, AUDIT & FIN'L SERVICES 1,684 2,445 1,952 2,500 2,500 0.00% 2,500 6302 - ARCH, ENG & PLANNING 39,833 34,853 62,228 85,500 35,500 -58.48% 35,500 6307 - PROFESSIONAL SERVICES 25,816 7,003 10,802 33,900 40,400 19.17% 40,400 6321 -TELEPHONE/PAGERS 1,765 2,580 2,319 3,665 4,065 10.91% 4,065 6322 - POSTAGE 4,840 4,840 3,520 6,500 6,500 0.00% 6,500 6329 - OTHER COMMUNICATION SERVICES 1,992 2,521 1,680 2,600 2,680 3.08% 2,680 6331 -TRAVEL EXPENSE/MILEAGE 239 - - 200 200 0.00% 200 6333 - FREIGHT/DRAYAGE - 84 50 50 0.00% 50 6341 - PERSONNEL ADVERTISING - - 160 160 0.00% 160 6342 - LEGAL NOTICES 73 - 100 100 0.00% 100 6351 - PRINTING 152 308 310 500 500 0.00% 500 6402 - EQUIPMENT SERVICES 79,969 85,743 2,315 96,500 4,000 -95.85% 4,000 6403 - BLDGS/FACILITIES MAINT SERVICE 10,000 15,254 7,427 15,000 10,800 -28.00% 10,800 6406 - MULTI -FUNCTION MTNCE - 111 88 500 515 3.00% 515 6409 - OTHER REPAIR & MAINT SVCS - - 1,030 12,400 12,400 0.00% 12,400 6417 - UNIFORMS 640 204 138 800 800 0.00% 800 6422 - SOFTWARE MAINT 314 41 1,136 - - 0.00% 6423 - LOGIS CHARGES 39,880 38,351 25,748 37,099 39,942 7.66% 40,753 6432 - CONFERENCES AND SCHOOLS 1,715 2,003 2,271 2,880 2,880 0.00% 2,880 6434 - DUES & SUBSCRIPTIONS 2,600 2,398 2,976 2,900 2,900 0.00% 3,200 6435 - CREDIT CARD FEES 219 - - 200 200 0.00% 200 6436 - UNCOLLECTIBLE CHECKS/DEBTS - 328 - - 0.00% 6438 - CASH SHORT (OVER) (4) (2) 1 - - 0.00% - 6441 - LICENSES, TAXES & FEES 43,395 71,342 57,112 76,000 76,000 0.00% 76,000 6449 - OTHER CONTRACTUAL SERVICE 127,254 101,162 63,062 75,000 75,000 0.00% 75,000 TOTAL SERVICES & OTHER CHARGES 382,376 371,485 246,199 454,954 318,092 -30.08% 319,203 6361 - GENERAL LIABILITY INSURANCE 20,553 28,977 21,705 34,966 30,676 -12.27% 32,517 6362 - PROPERTY INSURANCE 4,780 6,213 3,877 25,304 5,479 -78.35% 5,808 6366 - MACHINERY BREAKDOWN INSURANCE 1,059 1,260 799 1,057 1,129 6.81% 1,197 TOTAL INSURANCE 26,392 36,450 26,381 61,327 37,284 .39.20% 39,522 6381 - ELECTRIC 126,632 171,472 137,769 190,000 190,000 0.00% 190,000 6382 - GAS 6,377 13,587 13,179 30,000 30,000 0.00% 30,000 6383 - WATER 524 6,819 5,441 - 4,000 100.00% 4,000 6385-SEWER 626 8,138 4,958 4,000 4,000 0.00% 4,000 6386-STORM SEWER 8,712 8,712 6,534 6,400 6,400 0.00% 6,400 6388 - HAZARDOUS WASTE DISPOSAL - - - 1,000 1,000 0.00% 1,000 6389-STREETLIGHTS 2,624 2,624 1,968 1,500 1,500 0.00% 1,500 TOTAL UTILITIES 145,495 211,352 169,849 232,900 236,900 1.72% 236,900 6461 - FUEL CHARGES 4,427 3,374 2,780 4,508 3,427 -23.98% 3,530 6462 - FIXED CHARGES 10,736 9,999 6,695 10,043 9,113 -9.26% 9,386 6463 - REPAIR & MAINT CHARGES 11,102 17,612 4,198 10,260 10,000 -2.53% 10,300 6465 - REPLACEMENT CHARGES 26,575 23,133 14,472 21,708 21,708 0.00% 22,360 TOTAL CENTRAL GARAGE CHARGES 52,840 54,118 28,145 46,519 44,248 -4.88% 45,576 6494 - DEPRECIATION EXPENSE 703,933 1,143,664 1,145,569 1,812,176 1,935,476 6.80% 1,935,476 TOTAL DEPRECIATION 703,933 1,143,664 1,145,569 1,812,176 1,935,476 6.80% 1,935,476 TOTAL OPERATING EXPENSES 1,994,187 2,588,963 2,182,120 3,432,112 3,431,713 -0.01% 3,436,410 OPERATING INCOME 579,306 602,575 376,022 236,831 398,133 68.11% 584,928 NONOPERATING REVENUES 4601 - SPECIAL ASSESSMENTS 39,871 22,256 237,479 0.00% 4607 - SPEC ASSESS INTEREST 16 37 0.00% TOTAL SPECIAL ASSESSMENTS 39,887 22,293 237,479 0.00% 4603 - INTEREST EARNINGS 28,733 13,404 26,252 7,982 20,952 162.49% 20,952 4605 - UNREALIZED INVESTMENT GAIN/LOSS 1,690 (4,591) 0.00% TOTAL INVESTMENT EARNINGS 30,423 8,813 26,252 7,982 20,952 162.49% 20,952 4604-CHECK PROCESSING FEES 460 1,200 1,050 - - 0.00% - 4921 - REFUNDS & REIMBURSEMENTS 24,691 275 10,073 0.00% 4922 - PROJECT ADMINISTRATION 19,966 1,200 0.00% TOTAL MISCELLANEOUS 45,117 2,675 11,123 0.00% 4931 - BOND SALES - - 3,230,000 4,262,000 3,390,000 -20.46% 2,600,000 4932 - PREMIUM ON BOND SALES 19,060 51,037 161,068 0.00% TOTAL DEBT ISSUANCE 19,060 51,037 3,391,068 4,262,000 3,390,000 -20.46% 2,600,000 TOTAL NONOPERATING REVENUES 134,487 84,818 3,665,922 4,269,982 3,410,952 -20.12% 2,620,952 NONOPERATING EXPENSES 6530-IMPROVEMENTS - - 670,947 4,327,000 3,685,000 -14.84% 3,090,000 6540 - EQUIPMENT & MACHINERY 35,000 100.00 TOTAL CAPITAL OUTLAY 670,947 4,327,000 3,720,000 -14.03% 3,090,660-- 6601 - BOND PRINCIPAL 123,750 1,077,750 1,196,750 11.04% 1,501,750 6611 - BOND INTEREST 143,841 209,001 229,322 230,198 327,719 42.36% 345,632 6621 - PAYING AGENT/OTHER FEES 19,921 21,028 33,807 1,500 1,500 0.00% 1,500 TOTAL DEBT SERVICE 163,762 230,029 386,879 1,309,448 1,525,969 16.54% 1,848,882 6471-ADMINISTRATIVE SERVICE TRANSFER 92,103 92,103 71,111 94,815 105,996 11.79% 105,996 TOTALTRANSFERS 92,103 92,103 71,111 94,815 105,996 11.79% 105,996 TOTAL NONOPERATING EXPENSES 255,865 322,132 1,128,937 51731,263 5,351,965 -6.62% 5,044,878 NET CHANGE IN FUND BALANCE $ 457.928 $ 365,261 $ 2,913,007 _ $ (1,224,450) $ (1,542,880) 26.01% $ (1.838.998) M b9 M M R m N n U M n 0 O N a � M tq es aq In � � oM a 01 OcmO O N O O nl° � N O N (m0 V O N a P cV M b9 Ni M a � � m N N M N R 00 N P a` P c» as c» O N F a N V1 m a3 Nc1 O N' M r M O O N N a P C) O a R m m m N O W � N cl m � Mm O o N P P a O m W ey P N W m O a R m m m OMO � N N O N cli of m P R N N m n P N O ti O R m m Wm M m m R O cli PN ai a` ILN M !m P u3 a M m vi - W o � a 0 m cPo umi m YO N N m d m N m fq m n rn n CP a Rm m Cl! N ONO CL cn vi cn P m m Fi a th b m No m M b9 M M R m N n U M n 0 O N a � M tq lA � � oM a 01 OcmO O N O O nl° UN RO N O O N O N (m0 V a P cV M b9 Ni M a � � m N N M N O N P a` P c» as c» F y O O m U O W Nc1 O N' M r O O N N a P C) m ss cn P W -p Mm O N m a O m 3 N m P N m fq m In a P m o u1 m °D of o 0 N N m in ci r NOD O1 a u� N OWi O 'mn or= o N O ro P a` ILN M m 1» u3 M r- S 06 -S - M C1 0 N mmC11 coli r O N V O O M P N n V Om0 10 O M M a� C 10 N P M m m o o r c Mmm�Pn o m c mm'O PP O MN Ocm'InN O cm+1 O Q M f m M'O 0m3 M m nnn�lnm o ' o m c N co ccl Iq o renin c NON 01vm N OC'i C ro[71tm1 PNm r P O C r n M P N m p m r O lO N N P O M r 0 C m r O n M m O m O N r M N P N m m m r N r m N O m n O m r < P M m M 1t0� P N �N'mPn M [70Pm ONOi 10NN hc00 N < mm cm+l omn ooconn N N M m n P O M O cn' 1 M mcl M- n O n N m ' m M M m 1 n P o m P 1 m N m v 10 cm+1 'Nt1 Q m f mNP Nm CJm� c7 mMnommoPo � tnr�io uminvv ocm, lnnm i c0 r-� NcON Or O i lm0 N V P N OMi_ m� P m i �no PO n ' 00In V 1 m mmPP Ou1M m W �Oi a-�10 10 NO P m n P 10 M P m P m 0100 f0N (ha0 m N nP P N m n PO P O aPt{fP�-Nm m ' Om O m ' W NMM 1Mov Ohm � Om e-0 X10 10N0 m I m N mP P "(71 100 1.0 P cm0 r Orj r N r N O n o a m N 1 O n N m m P O P m ;: P'ONmmN O m 00 .NV M Nm '=tw r c+j m m M W O n O m m O m W N m P O m P nrofmp thM M NmMo m N P N m n M m m N O n O M onMrn.- omo t m00 ; NN n. 1N N N m N 00 1N m P m00'01010 M Mm10 N N nv_cn .-�PMCJ N Ma-PnPM•-- N Nln N�M�.-c N ' M W N n O 0 m N m C m loo. m N P�� O m m n R N m P m u>o l0 c N O m N nm 1 N N M P n v0°m N P n r On N r P P N It O V m m n O o omen O N N V O cV X10 m P m M m m P m N mmn P No P n ci M ui v cell nm N rc6� m Pv1m m m n N Ow �2 n N M m r m c- P N m N m N coo m� N n n m P m m n P P Nc0 Nln� v O1 01 'O C p m N C � m a(9m m '1 5,5z a2 a`1ic E w en 'v a -- -- w a a m$ n w W m m y Z cRi c m N R m R r ¢ 01 R S R N a 41 o a o p o p m e ? O m '^ E0a`EL «cv o �0DaZim a2iy mai�awm O O o. m to N y R w v 1Ri R c R v c c s c e n t w- `o- n n a a a c� m R> a c m y O. 6 0 0 0 0 CL N J OI R R N Ol W 4 p o L Ol X O L > O.2m m(- aam0 � 1 0UUO004-F- wUK W 2 N K Ul U U O 0 N 0 O O N N m m v N d � P U ry 1 T L Y � � u N O m U N ' N N N 0 m O r O 0 N o 0 0 0 0 0 0 O OO Oo O N I O n V M M N N N O $110.00 $100.00 $90.00 $80.00 $70.00 $60.00 $50.00 $40.00 $30.00 $20.00 $10.00 WATER UTILITY RATE COMPARISON Residential User -18,000 Gallons - Per Quarter $109.59 $124.71 ��,a``e� �oQe X05 G aeo �eya a � �o 001* The chart above is illustrating the annual comparison of the City's water utility rates with nine other cities which are considered to be similar to Brooklyn Center. All rates presented are for 2017, with the exception of the budgeted 2018 rate for the City of Brooklyn Center. The chart shows the City's water utility rates are the third lowest in the comparison. iff $2,020,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2018A Water Improvements DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I 105% Levy 02/01/2019 - - 29,512.88 29,512.88 30,988.52 02/01/2020 185,000.00 1.400% 39,350.50 224,350.50 235,568.03 02/01/2021 190,000.00 1.500% 36,760.50 226,760.50 238,098.53 02/01/2022 195,000.00 1.550% 33,910.50 228,910.50 240,356.03 02/01/2023 195,000.00 1.650% 30,888.00 225,888.00 237,182.40 02/01/2024 200,000.00 1.800% 27,670.50 227,670.50 239,054.03 02/01/2025 205,000.00 1.950% 24,070.50 229,070.50 240,524.03 02/01/2026 205,000.00 2.150% 20,073.00 225,073.00 236,326.65 02/01/2027 210,000.00 2.280% 15,665.50 225,665.50 236,948.78 02/01/2028 215,000.00 2.450% 10,877.50 225,877.50 237,171.38 02/01/2029 220,000.00 2.550% 5,610.00 225,610.00 236,890.50 Total $2,020,000.00 - $274,389.38 $2,294,389.38 $2,409,108.85 SIGNIFICANT DATES Dated..................................................................................................................................................................................... 5/01/2018 DeliveryDate......................................................................................................................................................................... 5/01/2018 FirstCoupon Date.................................................................................................................................................................. 2/01/2019 Yield Statistics BondYear Dollars.................................................................................................................................................................. $12,925.00 AverageLife.......................................................................................................................................................................... 6.399 Years AverageCoupon.................................................................................................................................................................... 2.1229352% NetInterest Cost (NIC).......................................................................................................................................................... 2.2010784% TrueInterest Cost (TIC)......................................................................................................................................................... 2.1978759% Bond Yield for Arbitrage Purposes......................................................................................................................................... 2.1139112% AllInclusive Cost (AIC).......................................................................................................................................................... 2.3527386% IRS Form 8038 NetInterest Cost.................................................................................................................................................................... 2.1229352% WeightedAverage Maturity................................................................................................................................................... 6.399 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. 30/8,1 [lDImp S I'11R—fl, / lMW— I penr-1, / 0/23/2017 / 8:32AA1 12 $1,410,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2018A Water Tower Painting DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I 105% Levy 02/01/2019 - - 20,599.50 20,599.50 21,629.48 02/01/2020 130,000.00 1.400% 27,466.00 157,466.00 165,339.30 02/01/2021 135,000.00 1.500% 25,646.00 160,646.00 168,678.30 02/01/2022 135,000.00 1.550% 23,621.00 158,621.00 166,552.05 02/01/2023 135,000.00 1.650% 21,528.50 156,528.50 164,354.93 02/01/2024 140,000.00 1.800% 19,301.00 159,301.00 167,266.05 02/01/2025 140,000.00 1.950% 16,781.00 156,781.00 164,620.05 02/01/2026 145,000.00 2.150% 14,051.00 159,051.00 167,003.55 02/01/2027 145,000.00 2.280% 10,933.50 155,933.50 163,730.18 02/01/2028 150,000.00 2.450% 7,627.50 157,627.50 165,508.88 02/01/2029 155,000.00 2.550% 3,952.50 158,952.50 166,900.13 Total $1,410,000.00 - $191,507.50 $1,601,507.50 $1,681,582.88 SIGNIFICANT DATES Dated..................................................................................................................................................................................... 5/01/2018 DeliveryDate......................................................................................................................................................................... 5/01/2018 FirstCoupon Date.................................................................................................................................................................. 2/01/2019 Yield Statistics BondYear Dollars.................................................................................................................................................................. $9,017.50 AverageLife.......................................................................................................................................................................... 6.395 Years AverageCoupon.................................................................................................................................................................... 2.1237316% NetInterest Cost (NIC).......................................................................................................................................................... 2.2019129% TrueInterest Cost (TIC)......................................................................................................................................................... 2.1986808% Bond Yield for Arbitrage Purposes......................................................................................................................................... 2.1139112% AllInclusive Cost (AIC).......................................................................................................................................................... 2.2519015% IRS Form 8038 NetInterest Cost.................................................................................................................................................................... 2.1237316% WeightedAverage Maturity................................................................................................................................................... 6.395 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. 2013A CO Imp X- I71R—Na / W,1 -Ton rr P.auzlieig / 9/25,/2077 / 3:272 AAI 13 o•' 14 15 SEWER UTILITY FUND - 60200 PUBLIC UTILITY FUND 2017 2015 2016 September 2017 2018 2019 Object Code / Description Actual Actual YTD Budget Budget Change Budget 49251 - SEWER UTILITY -OPERATIONS OPERATING REVENUES 4707 - PENALTIES $ 107,501 $ 102,935 $ 77,420 $ 100,000 $ 100,000 0.00% $ 100,000 4721 -SEWER SERVICE 3,986,224 4,102,027 3,147,001 4,258,900 4,233,111 -0.61% 4,449,766 TOTAL SALES AND USER FEES 4,093,725 4,204,962 3,224,421 4,358,900 4,333,111 -0.59% 4,549,766 TOTAL OPERATING REVENUES 4,093,725 4,204,962 3,224,421 4,358,900 4,333,111 -0.59% 4,549,766 OPERATING EXPENSES 6101 - WAGES & SALARIES -FT EMPLOYEES 128,575 128,026 87,311 123,758 130,831 5.72% 135,346 6102 - OVERTIME -FT EMPLOYEES 8,827 15,988 15,584 15,000 15,000 0.00% 15,000 6103 - WAGES -PART TIME EMPLOYEES 13,147 15,061 15,622 15,500 15,200 -1.94% 15,200 6111 - SEVERANCE PAY 158 1,257 - - - 0.00% - 6122 - PERA COORDINATED PLAN 10,305 10,801 7,717 11,547 12,077 4.59% 12,416 6125 - FICA - SOCIAL SECURITY 8,957 9,955 7,455 9,545 9,983 4.59% 10,264 6126 - FICA - MEDICARE 2,095 2,328 1,743 2,232 2,335 4.61% 2,401 6131 - CAFETERIA PLAN CONTRIBUTIONS 24,357 26,414 21,356 31,022 32,883 6.00% 34,845 6141 - UNEMPLOYMENT COMPENSATION 705 1,702 899 - - 0.00% - 6151 - WORKER'S COMP INSURANCE 6,239 6,160 4,553 5,640 6,150 9.04% 6,330 TOTAL PERSONAL SERVICES 203,365 217,692 162,240 214,244 224,459 4.77% 231,802 6201 -OFFICE SUPPLIES 100 - 100 100 0.00% 100 6203 - BOOKS/REFERENCE MATERIALS - - - 200 200 0.00% 200 6204 - STATIONARY SUPPLIES 290 1,543 1,476 3,290 3,290 0.00% 3,290 6214 - CLOTHING & PERSONAL EQUIPMENT - - 50 50 150 200.00% 150 6216 - CHEMICALS/CHEMICAL PRODUCTS 5,554 5,500 5,806 5,500 7,500 36.36% 7,500 6217 - SAFETY SUPPLIES 1,411 995 257 2,500 4,300 72.00% 2,800 6219 - GENERAL OPERATING SUPPLIES 3,654 986 3,051 3,500 3,500 0.00% 3,500 6223 - BUILDINGS & FACILITIES - - 100 100 0.00% 100 6224 - STREET MAINT MATERIALS 5,539 - - 7,500 7,500 0.00% 7,500 6227 - PAINT SUPPLIES 627 627 570 675 675 0.00% 675 6239 - OTHER REPAIR & MAINT SUPPLIES 690 1,353 100 5,000 5,000 0.00% 5,000 6241 -SMALL TOOLS 465 414 123 500 500 0.00% 500 6242 - MINOR EQUIPMENT 34,354 - 789 3,600 2,600 -27.78% 2,600 6243 -MINOR COMPUTER EQUIPMENT 576 4,300 100.00% 1,200 TOTAL SUPPLIES 53,260 11,418 12,222 32,515 39,715 22.14% 35,115 6301-ACCTG, AUDIT & FIN'L SERVICES 1,684 1,956 1,561 2,000 2,000 0.00% 2,000 6302 - ARCH, ENG & PLANNING - 5,165 - 1,900 1,900 0.00% 1,900 6307 - PROFESSIONAL SERVICES 3,353 2,587 3,304 4,400 4,820 9.55% 4,400 6321 -TELEPHONE/PAGERS 676 627 892 1,865 2,215 18.77% 2,215 6322 - POSTAGE 10,340 10,340 7,520 12,700 12,700 0.00% 12,700 6342 - LEGAL NOTICES - 187 - - - 0.00% - 6351 - PRINTING - 240 - 375 375 0.00% 375 6403 - BLDGS/FACILITIES MAINT SERVICE 4,090 8,365 1,600 7,000 7,000 0.00% 7,000 6409 - OTHER REPAIR & MAINT SVCS 64,329 56,113 33,458 70,000 70,000 0.00% 85,000 6422 - SOFTWARE MAINT - - 144 - - 0.00% 6423 - LOGIS CHARGES 36,060 34,085 22,785 32,426 34,004 4.87% 35,189 6432 - CONFERENCES AND SCHOOLS 1,250 2,566 1,068 2,880 2,880 0.00% 2,880 6434 - DUES & SUBSCRIPTIONS 305 314 322 405 405 0.00% 425 6436 - UNCOLLECTIBLE CHECKS/DEBTS - 696 - - - 0.00% - 6441 - LICENSES, TAXES & FEES - - 170 170 0.00% 170 6449 - OTHER CONTRACTUAL SERVICE 13,563 23,913 28,682 38,000 26,000 -31.58% 26,000 TOTAL SERVICES & OTHER CHARGES 135,650 147,154 101,336 174,121 164,469 5.54% 180,254 6361 - GENERAL LIABILITY INSURANCE 31,535 36,425 17,705 30,168 25,024 -17.05% 26,525 6362 - PROPERTY INSURANCE 1,086 1,407 884 1,201 1,249 4.00% 1,324 6366 - MACHINERY BREAKDOWN INSURANCE 275 327 209 274 295 7.66% 313 TOTAL INSURANCE 32,896 38,159 18,798 31,643 26,568 -16.04% 28,162 6381 - ELECTRIC 36,824 38,647 30,272 39,100 39,100 0.00% 39,100 6391 - MET COUNCIL ENVIRON SVCS 2,197,141 2,320,727 2,006,733 2,424,000 2,500,929 3.17% 2,625,975 TOTAL UTILITIES 2,233,965 2,359,374 2,037,005 2,463,100 2,540,029 3.12% 2,665,075 6461 - FUEL CHARGES 13,983 10,644 9,335 14,037 16,793 19.63% 17,297 6462 - FIXED CHARGES 14,240 13,095 9,329 13,994 12,059 -13.83% 12,420 6463 - REPAIR & MAINT CHARGES 14,215 30,600 15,595 18,024 18,000 -0.13% 18,540 6465 - REPLACEMENT CHARGES 79,815 74,748 43,788 65,682 56,082 -14.62% 57,764 TOTAL CENTRAL GARAGE CHARGES 122,253 129,087 78,047 111,737 102,934 -7.88% 106,021 6494- DEPRECIATION EXPENSE 783,500 817,621 607,243 1,020,340 1,124,040 10.16% 1,124,040 TOTAL DEPRECIATION 783,500 817,621 607,243 1,020,340 1,124,040 10.16% 1,124,040 TOTAL OPERATING EXPENSES 3,564,889 3,720,505 3,016,891 4,047,700 4,222,214 4.31% 4,370,469 OPERATING INCOME 528,836 484,457 207,530 311,200 110,897 -64.36% 179,297 15 NONOPERATING REVENUES 4603 - INTEREST EARNINGS 24,158 43,081 42,911 29,697 46,985 58.21% 46,985 4605 - UNREALIZED INVESTMENT GAIN/LOSS 2,530 (9,215) 0.00% TOTAL INVESTMENT EARNINGS 26,688 33,866 42,911 29,697 46,985 58.21% 46,985 4373-OTHER GRANTS/AID 78,372 - - - 0.00% - 4606 - OTHER REVENUE - - 285 0.00% 4921 - REFUNDS & REIMBURSEMENTS 7,236 5,119 0.00% TOTAL MISCELLANEOUS 7,236 83,491 285 0.00% 4931 - BOND SALES - - 1,395,000 2,060,000 -100.00% 1,860,000 4932 - PREMIUM ON BOND SALES 35,277 46,883 69,543 0.00% TOTAL DEBT ISSUANCE 35,277 46,883 1,464,543 2,060,000 -100.00% 1,860,000 TOTAL NONOPERATING REVENUES 69,201 164,240 1,507,739 21089,697 46,985 -97.75% 1,906,985 NONOPERATING EXPENSES 6530-IMPROVEMENTS 698,326 2,565,000 2,715,000 5.85% 2,617,000 TOTAL CAPITAL OUTLAY 698,326 2,565,000 2,715,000 5.85% 2,617,000 6601 - BOND PRINCIPAL 218,753 218,753 315,272 44.12% 448,753 6611 - BOND INTEREST 34,148 51,805 63,540 63,540 108,470 70.71% 95,488 6621 - PAYING AGENT/OTHER FEES 30,491 19,317 14,563 1,500 1,500 0.00% 1,500 TOTAL DEBT SERVICE 64,639 71,122 296,856 283,793 425,242 49.84% 545,741 6471 -ADMINISTRATIVE SERVICE TRANSFER 92,103 92,103 66,914 89,219 99,426 11.44% 99,426 TOTALTRANSFERS 92,103 92,103 66,914 89,219 99,426 11.44% 99,426 TOTAL NONOPERATING EXPENSES 156,742 163,225 1,062,096 2,938,012 3,239,668 10.27% 3,262,167 NET CHANGE IN FUND BALANCE $ 441.295 $ 485,472 $ 653,173 $ (537,115) $ (3,081,786) 473.77% $ (1,175,885) W m m m TV0mmoo 0 N'M&a O M m m V o I" n N v V 10 n r m C O N M V n M O O V N m T V OT m m N m V v V (3iM O v o M y wOrI N M - m m r V r v m V o o m m m N io 0 T n m nv o n M ... Mv v T o 0 0 o N m n m o M V rMNNO m1(1 t� rVIN M o rm M m m nor m N Vi (� r m r m m m 0 0 T m m m m o _ - ocn noR -� Q OMVOmVm .0 O 0 V N V T M V N N m n r T r N M m r m m f0 N rmr mOm T M O O ' m m m' 10(00 N O T N m V O n m T n V mmvMmoO nm v nolo ,Vc 00 001 NN M 'm r r m T (o r T r M r m N N m c m M 0 V m(C 'O N V O p r m O T m V V Tmt0n00Tr 0 M •-OO N r(hMmVMmn N 0 MOV O V V M V N V m 0 0 m M O S M r r (0 m m N r m M r m N m m c o M r m NQ o v m V N p Mp a c V (O �_ N� m O Ct my 1� V N V V O M o N o V Or n 0 r r V T V n M V N N T ow r r m N N m N m M D M c m m N ui m e nm0Tvoovm0 m rvlc m m O v v o o o M m o v O M N M m c ci N rT T T c 0 wNV V o N I v m n Vv M r m N 10 m e v10Nu1MoovMm a ' nmc P-n000m cV at M V OVic (no(oNm�Nrn(0+1�°r1 o (w l°r N I r n 10 m T T O T c (+i N O n �(M(1 C; -OO N4Om1 0 amim e o coo "m vo0V] o a n v N M v M V N n o V r n n n M <<- I - mfo r (O On: M M O O N NIN T m N V O N V M r M (O O r V M O O T V m N m O m 0 0 N V O V o T N VM N M m V� � 0 V O V � O V m N a d T m r m n m T m Cl m T V C V NN Nm V OO V M a0 m r M V V mm0u1 n Omi �N G1 p 'ON mV m N O N T C mh VOir V0 Vm 1(1 m N N V N M V M N M rc(n V N N N m NN V m T N V ON rV N m M M Ui M T ('� N N' ' V mt` of a o nM m y o c rm om-It o0v TL0 cli (q OO n V m o Vm onoe m C1 N O O m N N m V N m O N O V O O m V M 1L1 N V N M V M V M m V V V N m m O 'p (y T T N N r V 10 V N T r V a m (+9 E9 M I CO m VO T m n M m N O O M T m r ' T N O O m M V a G10 00 00 q,31 ON LL') O N m V O m V r- onnm 001(100 M V 0M= V N((1 001 � N Glp 'ON n T O r mr n mm r m N M m m V O V m MMMNMNT V r(O N r rc0m N m N 0 n M V T rmNV T lqq M Tq d V rm m r n r 0rrN m M M H V m m ' Or N(OmN0000 ' m Or 1C1 a dT Ow out IST on or�m o vo c mr roo M Om m 1l1M V r nlno m 41 O 0 'O N To 00 V V m1(1 10 m V ommmvIno CJM NM V N O mu'1 0 m (O� Vw V OM Nm O '•i (O r01 a V rm n N mgr EA (+9 (A H N r10 " m T m m mO0 an ' M n' 0C�a V N' a N m r m r T T O m m m O V O V V , N L r O O r m m M m m V T O m 0 mU U1 r0 'ON M m M V Cl O m M V T T m T V m M N M m N M N N N m rr V m V M O V O m m C M V m V O a` V V N N n V V yr N fA b9 (fl M V R a r m Om 0 C1 r V O V O T Nim mrMON r m r T V T M(OnV MOi M m O co N 00 V N O m 0 M N M MO m M O M M U1 0 'O N M V IV M V m M00"mM m N m O m N N NI V V �O N M m N 0 O 0 a V rm N rN n VvN�'-V O N(� Nm MN Nm V Tr mN ' m OnN00 N li O h m m m Tm T m V m C' N T r r 10 V N O N m V V r m m n N r O r N m m Or Up Vm0r O mm nO V rrNmw N0 rm mw rma V T M VVn.- (O TOT. -M N U Q N N N 'O N m m O r O V 10 c m 1� W u3 (9 V r E9 10 N 0 m 10 0 v W C � >� y s 3 o dcn w m m G3 Z a y m m L C U 0 C N 01 oC1 >. C IL M d C6X y O N C U N W a IL= N u C= 0 ¢ �p 0=00 0 N N .O• 0 0 (JJ Ln C L C N OIC N A a N 0- N d :0 W N 'm N a () almcc.. C O. > O O O o. �_nana C N Y1 d l0 G1 N 0 mm>o_�m L Ul X O j N L jO CZ OO F- aa(nO �ODU OUF- N UK W Z N � Ix w U U SANITARY SEWER UTILITY RATE COMPARISON Residential User -18,000 Gallons - Per Quarter �rr $90.28 $106.41 $113.11 $90.00 $82. $81.60 42 $82.42 _ $80.00 - $70.00 $60.00 $50.00 $40.00 $30.00 $20.00 $10.00 001,� C/ `e* 000 0c, �r The chart above is illustrating the annual comparison of the City's sanitary sewer utility rates with nine other cities which are considered to be similar to Brooklyn Center. All rates presented are for 2017, with the exception of the budgeted 2018 rate for the City of Brooklyn Center. 17 ■ �i The chart above is illustrating the annual comparison of the City's sanitary sewer utility rates with nine other cities which are considered to be similar to Brooklyn Center. All rates presented are for 2017, with the exception of the budgeted 2018 rate for the City of Brooklyn Center. 17 ■ The chart above is illustrating the annual comparison of the City's sanitary sewer utility rates with nine other cities which are considered to be similar to Brooklyn Center. All rates presented are for 2017, with the exception of the budgeted 2018 rate for the City of Brooklyn Center. 17 • Budget • Cash Flow Projections • Rate Comparisons • Proposed Debt Service • Rate Comparison (water, sewer & storm water) 19 20 STORM SEWER UTILITY FUND - 65100 PUBLIC UTILITY FUND 2017 2015 2016 September 2017 2018 2019 Object Code / Description Actual Actual YTD Budget Budget Change Budget 49411 -STORM SEWER UTILITY -OPERATIONS OPERATING REVENUES 4707 - PENALTIES $ 28,148 $ 25,665 $ 18,562 $ 35,000 $ 35,000 0.00% $ 35,000 4731 -STORM DRAINAGE FEES 1,607,407 1,594,637 1,190,155 1,600,000 1,616,350 1.02% 1,649,377 TOTAL SALES AND USER FEES 1,635,555 1,620,302 1,208,717 1,635,000 1,651,350 1.00% 1,684,377 TOTAL OPERATING REVENUES 1,635,555 1,620,302 1,208,717 1,635,000 1,651,350 1.00% 1,684,377 OPERATING EXPENSES 6101 - WAGES & SALARIES -FT EMPLOYEES 132,065 134,438 96,867 132,196 143,796 8.77% 146,672 6102 -OVERTIME -FT EMPLOYEES 1,134 2,193 1,743 1,500 2,000 33.33% 2,000 6103 - WAGES -PART TIME EMPLOYEES 9,975 8,422 7,955 11,000 10,800 -1.82% 10,800 6111 - SEVERANCE PAY 1,703 893 - - 0.00% - 6122 - PERA COORDINATED PLAN 9,990 10,247 7,396 11,022 11,707 6.21% 11,923 6125 - FICA - SOCIAL SECURITY 8,934 9,120 6,864 8,959 9,678 8.03% 9,857 6126 - FICA - MEDICARE 2,090 2,133 1,605 2,095 2,265 8.11% 2,306 6131 - CAFETERIA PLAN CONTRIBUTIONS 18,706 23,932 20,232 32,371 34,313 6.00% 36,360 6151 - WORKER'S COMP INSURANCE 9,198 8,991 6,668 9,612 12,166 26.57% 12,386 TOTAL PERSONAL SERVICES 193,795 200,369 149,330 208,755 226,725 8.61% 232,304 6204 - STATIONARY SUPPLIES 136 818 781 1,540 1,600 3.90% 1,600 6219 - GENERAL OPERATING SUPPLIES 140 3,132 1,654 5,500 5,500 0.00% 5,665 6224 - STREET MAINT MATERIALS 8,180 2,755 3,125 7,500 7,800 4.00% 8,000 6239 - OTHER REPAIR & MAINT SUPPLIES 36,549 18,440 9,660 37,000 38,000 2.70% 38,000 6243 - MINOR COMPUTER EQUIPMENT 8,600 100.00% TOTAL SUPPLIES 45,005 25,145 15,220 51,540 61,500 19.32% 53,265 6301 - ACCTG, AUDIT & FIN'L SERVICES 842 978 781 1,000 1,000 0.00% 1,000 6302 - ARCH, ENG & PLANNING 81,012 17,913 - 20,000 20,000 0.00% 20,000 6307 - PROFESSIONAL SERVICES 5,361 1,457 1,499 1,600 2,000 25.00% 1,600 6322 - POSTAGE 5,060 5,060 3,680 5,940 5,940 0.00% 5,940 6331 - TRAVEL EXPENSE/MILEAGE 696 503 333 600 600 0.00% 600 6342 - LEGAL NOTICES 108 - 40 50 50 0.00% 50 6384 -REFUSE DISPOSAL - 1,947 1,800 3,500 3,600 2.86% 3,700 6409 - OTHER REPAIR & MAINT SVCS 37,163 29,352 21,158 40,000 40,000 0.00% 40,000 6423 - LOGIS CHARGES 20,687 19,484 13,020 18,529 19,431 4.87% 20,108 6432 - CONFERENCES AND SCHOOLS 490 500 500 500 0.00% 500 6434 - DUES & SUBSCRIPTIONS 55,722 55,601 57,045 57,200 56,700 -0.87% 58,300 6436 - UNCOLLECTIBLE CHECKS/DEBTS - 145 0.00% - 6449 - OTHER CONTRACTUAL SERVICE 3,880 13,441 5,523 12,000 12,400 3.33% 12,775 6499 - EXPENSES REIMBURSED 136,606 0.00% TOTAL SERVICES & OTHER CHARGES 347,627 146,381 104,879 160,919 162,221 0.81% 164,573 6361 - GENERAL LIABILITY INSURANCE 3,242 2,429 1,675 1,711 2,367 38.34% 2,509 TOTAL INSURANCE 3,242 2,429 1,675 1,711 2,367 38.34% 2,509 6461 - FUEL CHARGES 6,835 5,418 3,887 7,168 5,655 -21.11% 5,825 6462 - FIXED CHARGES 6,341 5,765 4,047 6,071 5,708 -5.98% 5,879 6463 - REPAIR & MAINT CHARGES 28,637 25,764 18,005 25,399 24,000 -5.51% 24,720 6465 - REPLACEMENT CHARGES 45,963 51,113 36,717 55,075 55,075 0.00% 56,727 TOTAL CENTRAL GARAGE CHARGES 87,776 88,060 62,656 93,713 90,438 -3.49% 93,151 6494 - DEPRECIATION EXPENSE 1,106,276 1,146,109 867,056 1,297,810 1,373,350 5.82% 1,373,350 TOTAL DEPRECIATION 1,106,276 1,146,109 867,056 1,297,810 1,373,350 5.82% 1,373,350 TOTAL OPERATING EXPENSES 1,783,721 1,608,493 1,200,816 1,814,448 1,916,601 5.63% 1,919,152 OPERATING INCOME (LOSS) (148,166) 11,809 7,901 (179,448) (265,251) 47.81% (234,775) NONOPERATING REVENUES 4373 - OTHER GRANTS/AID - 28,116 - - - 0.00% - 4603 - INTEREST EARNINGS 33,171 43,492 38,790 34,894 46,548 33.40% 46,548 4605 - UNREALIZED INVESTMENT GAIN/LOSS 2,678 (9,209) 0.00% TOTAL INVESTMENT EARNINGS 35,849 62,399 38,790 34,894 46,548 33.40% 46,548 4612 - DONATIONS & CONTRIBUTIONS 100 150 250 - - 0.00% - 4912 - CAPITAL CONTRIBUTIONS 1,034,574 185,237 0.00% TOTAL MISCELLANEOUS 1,034,674 185,387 250 0.00% 4931 - BOND SALES - - - 1,825,000 100.00% 2,320,000 4932 - PREMIUM ON BOND SALES 44,707 0.00% TOTAL DEBT ISSUANCE 44,707 1,825,000 100.00% 2,320,000 TOTAL NONOPERATING REVENUES 1,070,523 292,493 39,040 34,894 1,871,548 5263.52% 2,366,548 20 NONOPERATING EXPENSES 6540 - EQUIPMENT & MACHINERY 3,000 100.00 6530-IMPROVEMENTS 1,709,000 2,600,000 52.14% 3,139,000 TOTAL CAPITAL OUTLAY 1,709,000 2,603,000 52.31% 3,139,000 6601 - BOND PRINCIPAL - 95,000 100.00% 105,000 6611 - BOND INTEREST 4,892 18,080 18,080 21,650 19.75% 46,323 6621 - BOND ISSUE COSTS 18,420 0.00% TOTAL DEBT SERVICE 23,312 18,080 18,080 116,650 545.19% 151,323 6471 -ADMINISTRATIVE SERVICE TRANSFER 92,103 92,103 66,914 89,219 99,426 11.44% 99,426 6482 - MISC TRANSFER OUT 45,000 0.00% - TOTALTRANSFERS 137,103 92,103 66,914 89,219 99,426 11.44% 99,426 TOTAL NONOPERATING EXPENSES 137,103 115,415 84,994 11816,299 2,819,076 55.21% 3,389,749 NET CHANGE IN FUND BALANCE $ 785,254 $ 188,887 $ (38,053) $ (1,960.853) $ (1,212,779) -38.15% $ (1,257,976) 21 N N d M O N �p u Nm my d a0 V C N o I . Ila IQ w v c MM M M 1p T6 O1. C u° O C a` mm m O d C d � O C a` mM m Ct a � O A C O C a mm no M M o m O N N c C c O C M m a mo O M N O m c U AC m M rm p O A UC 0N( a` m m a U� 'O t a � <9 m N p I LL V L QI uV Mm c T � Y d O +A+ A A m`3 a T � ILL OI U (n c r =_ LL V y d 7 .c- w a O pm N m .0 M m O • ' • C Omt_ N N N I O c N C mmll o r m a Ci .- m p IC V N c m mm r mM . I III ? N N p M Cl! N - m M 0 OI C t0 mCIp CIm f` nomm0000' mmomMo M NROiMpMUI M m N n m O io v mo n m N m p M 0 0 MM NO170 C) . cormo mo n c r o m p M m O m M N V O I (A M M O N g C m O INO �Npr IN N p C'N n c e mlopN000 o n ' < o m R R Nn i O o r�mMora 0j ;VNv IOM 0 m m 0 r m N N p C n n c M m oO f rmlo NvCi ui tui NmcO1i main pmMOU)00 .t OO -Ir m IN ONm ' M m r O M O p Cl! Oi ap Oi CV YCIO MCI m m m r m N 0 N M CI M n V (mp N_hOMO r� r NOMO N.- f lom m ry �o N M M m r t p N N m N m O m m M m p N M M m m M m m n n N N O Inr mom000v' .-m.-pmOo.- p p m m m M O M p 10 1A IfI N M CI Cl l(j .- vmm rctN0 N M M N. -r Mommv000m' n M m m r m O O M N M p m n M O m m m V' Oi N M M N n r N m M c'N v � N vmom000aM' MN'tIqll MO Imo Ino NCI NNCIn OUI NMM Ci m o m r o 0 0 0 N O m m O I t) O U I nl[)'.iMm MOIO N mm m100 N nN M1�h m�00 N m pn N N c N m p m N p O N O NNNc <IMit m ' mino p smut V p O M m M m M p mmn m or ao 10 M o m a O N r p m m N M_� Ili noM v omn N p — N Omm f A M p m IO N M V m V m N I O M N amb Imo n p nil? m m N m N m m M M M p — m moth v R a n O M M CI O N .- o rn U A A c mw W 5 m N to m v w aN�vy mai fny -olc cm- c m c o.t y=n'o.aa A m m> ncmA A n o o '� o d a`t - o A m A o L �O_zmFt- to o_mO��oUoa�-r LI UU�wzU N N $25.00 - $20.00 $15.00 $10.00 $5.00 OOGOuhl DIDAUN OE U UT Y u TCS COMPARISON Rebidlen- d Usek, - G ev Otunter $14.48 $14. Q eJ��e X05 Gec�e` • Ge��e` N1b O�`�C �to0* ��O $25.00 $28.30 `eta ywa oQe �\`e� ooa ;`�s% \e� ce C� The chart above is illustrating the annual comparison of the City's storm drainage utility rates with eight other cities which are considered to be similar to Brooklyn Center. All rates presented are for 2017, with the exception of the budgeted 2018 rate for the City of Brooklyn Center. The budgeted rates for 2018 represent no change from the 2017 rates. The current rates are providing sufficient cash flows to meet current operating needs as well as future infrastructure needs. 23 1,825,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2018A Storm Drainage Improvements DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I 105% Levy 02/01/2019 - - 26,673.38 26,673.38 28,007.05 02/01/2020 170,000.00 1.400% 35,564.50 205,564.50 215,842.73 02/01/2021 170,000.00 1.500% 33,184.50 203,184.50 213,343.73 02/01/2022 175,000.00 1.550% 30,634.50 205,634.50 215,916.23 02/01/2023 175,000.00 1.650% 27,922.00 202,922.00 213,068.10 02/01/2024 180,000.00 1.800% 25,034.50 205,034.50 215,286.23 02/01/2025 185,000.00 1.950% 21,794.50 206,794.50 217,134.23 02/01/2026 185,000.00 2.150% 18,187.00 203,187.00 213,346.35 02/01/2027 190,000.00 2.280% 14,209.50 204,209.50 214,419.98 02/01/2028 195,000.00 2.450% 9,877.50 204,877.50 215,121.38 02/01/2029 200,000.00 2.550% 5,100.00 205,100.00 215,355.00 Total $1,825,000.00 - $248,181.88 $2,073,181.88 $2,176,840.97 SIGNIFICANT DATES Dated..................................................................................................................................................................................... 5/01/2018 DeliveryDate......................................................................................................................................................................... 5/01/2018 FirstCoupon Date................................................................................................................................................................. 2/01/2019 Yield Statistics BondYear Dollars.................................................................................................................................................................. $11,683.75 AverageLife.......................................................................................................................................................................... 6.402 Years AverageCoupon.................................................................................................................................................................... 2.1241629% NetInterest Cost (NIC).......................................................................................................................................................... 2.2022628% TrueInterest Cost (TIC)......................................................................................................................................................... 2.1990578% Bond Yield for Arbitrage Purposes......................................................................................................................................... 2.1139112% AllInclusive Cost (AIC).......................................................................................................................................................... 2.3538556% IRS Form 8038 NetInterest Cost.................................................................................................................................................................... 2.1241629% WeightedAverage Maturity................................................................................................................................................... 6.402 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. 2018.1 GO Imp X-141 R— P, / prore — / 9/28/2017 / 8:.72.-1.61 Springsted 24 COMBINED WATER, SEWER, AND STORM COMPARISON Racirlantini I Icar . 1R M(1 rg11r%n4z _ Par Oiigrtpr $300.00 $250.00 $200.00 $150.00 $100.00 $50.00 $259.48 The above chart illustrates a combined quarterly bill for Water, Sewer and Storm Utilities at a usage of 18,000 gallons. Please note that the City of White Bear Lake does not operate a Storm Utility. 25 0-e ti ti Ge Ge `*e �r `00.\Q `OO,Fxl° eJ��e The above chart illustrates a combined quarterly bill for Water, Sewer and Storm Utilities at a usage of 18,000 gallons. Please note that the City of White Bear Lake does not operate a Storm Utility. 25 eJ��e e,`esl �o0a Ja�`ea �0 01 X05 r aQ�e e� The above chart illustrates a combined quarterly bill for Water, Sewer and Storm Utilities at a usage of 18,000 gallons. Please note that the City of White Bear Lake does not operate a Storm Utility. 25 • • • • �. • 26 27 STREET LIGHT UTILITY FUND - 65200 PUBLIC UTILITY FUND 2017 2015 2016 September 2017 2018 2019 Object Code / Description Actual Actual YTD Budget Budget Change Budget 49571 - STREET LIGHT -OPERATIONS OPERATING REVENUES 4707 - PENALTIES $ 9,680 $ 8,930 $ 6,660 $ 7,500 $ 7,500 0.00% $ 7,500 4741 - STREET LIGHT SERVICE CHARGE 445,678 444,592 334,091 443,000 443,000 0.00% 443,000 TOTAL SALES AND USER FEES 455,358 453,522 340,751 450,500 450,500 0.00% 450,500 TOTAL OPERATING REVENUES 455,358 453,522 340,751 450,500 450,500 0.00% 450,500 OPERATING EXPENSES 6204 - STATIONARY SUPPLIES 25 87 84 280 280 0.00% 280 6239 - OTHER REPAIR & MAINT SUPPLIES 2,414 2,542 1,571 7,500 7,500 0.00% 7,500 TOTAL SUPPLIES 2,439 2,629 1,655 7,780 7,780 0.00% 7,780 6307 - PROFESSIONAL SERVICES 54 45 28 200 200 0.00% 200 6322 - POSTAGE 880 880 640 1,080 1,080 0.00% 1,080 6409 - OTHER REPAIR & MAINT SVCS 22,042 20,869 4,092 15,500 16,000 3.23% 16,000 6423 - LOGIS CHARGES 5,164 4,872 3,255 4,632 4,858 4.88% 5,027 6436 - UNCOLLECTIBLE CHECKS/DEBTS - 50 - - 0.00% - 6499 - EXPENSES REIMBURSED 4,896 0.00% TOTAL SERVICES & OTHER CHARGES 33,036 26,716 8,015 21,412 22,138 3.39% 22,307 6361 - GENERAL LIABILITY INSURANCE 1,363 1,483 598 1,185 846 -28.61% 897 TOTAL INSURANCE 1,363 1,483 598 1,185 846 -28.61% 897 6381 - ELECTRIC 167,149 165,338 124,250 180,000 180,000 0.00% 180,000 TOTAL UTILITIES 167,149 165,338 124,250 180,000 180,000 0.00% 180,000 6494 -DEPRECIATION EXPENSE 53,567 55,632 41,496 85,183 103,183 21.13% 103,183 TOTAL DEPRECIATION 53,567 55,632 41,496 85,183 103,183 21.13% 103,183 TOTAL OPERATING EXPENSES 257,554 251,798 176,014 295,560 313,947 6.22% 314,167 OPERATING INCOME (LOSS) 197,804 201,724 164,737 154,940 136,553 -11.87% 136,333 NONOPERATING REVENUES 4603 - INTEREST EARNINGS 2,356 5,652 5,682 3,930 6,636 68.85% 6,636 4605 - UNREALIZED INVESTMENT GAIN/LOSS 230 (1,077) 0.00% TOTAL INVESTMENT EARNINGS 2,586 4,575 5,682 3,930 6,636 68.85% 6,636 4921 - REFUNDS & REIMBURSEMENTS 8,900 16,092 0.00% TOTAL MISCELLANEOUS 8,900 16,092 0.00% TOTAL NONOPERATING REVENUES 11,486 20,667 5,682 3,930 6,636 68.85% 6,636 NONOPERATING EXPENSES 6530 - IMPROVEMENTS 3,835 170,000 375,000 120.59% 130,000 TOTAL CAPITAL OUTLAY 3,835 170,000 375,000 120.59% 130,000 6471 - ADMINISTRATIVE SERVICE TRANSFER 20,272 20,272 17,064 22,752 25,766 13.25% 25,766 TOTAL TRANSFERS 20,272 20,272 17,064 22,752 25,766 13.25% 25,766 TOTAL NONOPERATING EXPENSES 24,107 20,272 17,064 192,752 400,766 107.92% 155,766 NET CHANGE IN FUND BALANCE $ 185,183 $ 202.119 $ 153.355$ (33,882) $ (257,577) 660.22% $ (12.797) 27 N om m �amo�vmo m ro�row umi m 1 v mM m o«m<o mv_<n U m 00 O ON � CI O+>O mv_ m Om CDN O a` < w ey w w ul o M M n m m v M o m M m M m ' d Nl(l O mm <N<O v N O V < ylQ � m m N O m CD O mo. O N V v (V V O�1 O V O a w y w w ' d 6 nn<Om< m0O m n< m N N ld < N vm mN � o 6.6 m N 01 A M M O r V m n 616 O N .... a` w w w w ul om ' m v<MmM " o m ' moMm 16 v d o ul N M ul m m o m W v m o o m ul m m< n m m R n m d om ro ad � d c6 � ui ro�Mv 0 O N V V N� M 1M0 KM�m a` m d I m O V V1 a>n<NeD d c'I �tO CDN O N - a` ul o ' n mul mM ' M M ' room m m v o� m m n M <Nlnmm < M O m< n n rnmm N m M (l m V n ON Oil Oi (O QOM O h MOMM a w ey w w ul om ' m N a O v N N n m N O n< O m ui g ri o n m r« m ui v ui of n d0 O N V v m N�M fmd V vN ON ... a` w la w w N a O N N m M Om0 O v i[IO mn y o ON IA o N N V �zN ODO m OO N t0 N MO m m mm ON a` w ay w w N O m O m M 0' v m m -d O O N< O m n M m 0 m m N O m r O n N O n m N N .d..� d O<O m W M m M0 v1 m0 t O mvMN Oh _2 V V N t0 i0 V fO a m vj w w ul v oa O o lflvOmm<O i�MnM o v m OvWN V m Nv N UN O N m W N K M O A m m(17MO O N a` m ill N r M O ' N m v R' N CM 'n �Il m N mm ' -Q O N m N 0 N m N d N m m N m O m m N O m a` w eq w w ul oul ul amMNMo ' m M ' maOMV 16 d ulv m c< M r m o oomN<o m M m m m m v .n my < d 0 V V rM ON N m 0 0 }} em�{{ V mMh V F N O N v v w v3 w w m v u o o o' m n < m M M ul -o oM m y cn m MM Omo m o m m< o m m Mm WM m o m m In wa uoiv A —F v `O u�uviov a w sq w w ul om m oMnoMo ' M' melon �m ulm tomo o m n m<o O f 0 n c n a D O M O m N n m M y My O N IL w ss w w ocmo m�voroo M m memo umi Io -o °1 LQ IQ om'l ammo<o n o n<n m °1� ol6 n �- v morns O N v v n uoi vnon . a` w w w w m 1 rn m N n n OO< (h y r M O y o MN m m N r V �O� O V m m 0 aD DDm VIr m l (1 m 0 2. v v M m l() V tD N a` w rn w w T N N N N m m m M m N 0' O M N m O N m N t0 <NNN V NOD��N� d C w bq w w y IL U >. c= > D 7 o r d m d C o o 7U U rn d a i LL di C d 2 C Win m d c m m Q y v W d ca yd.. G1 d C o- y nL mai t= D¢_¢ d C mO1v acro_ l0 m N>¢ G m -"' d 7 'd Ntr c a> j0 Wio z{- o c d m a(AO-7UUF-F o L d o yUT u�Sz N .• w K R W U U d K N ST a Er Y MGM UTKi T Y RAO OOM P RMIM Re—saden-dal User - Per Quarter --- $12.18 $12.00 $10.00 -� $8.00 $7.05 $6.55 $6.55 $5.77 -- $6.00 $4.92 $5.00 $4.00 $2.00 New Hope Crystal Richfield Brooklyn Brooklyn Golden Valley Shoreview Center - 2017 Center - 2018 The chart above is illustrating the annual comparison of the City's street lighting utility rates with five other cities which are considered to be similar to Brooklyn Center. All rates presented are for 2017, with the exception of the budgeted 2018 rate for the City of Brooklyn Center. The budgeted rates for 2018 represent no change from the 2017 rates. The current rates are providing sufficient cash flows to meet current operating needs as well as future infrastructure needs. 29 I 30 Object Code / Description RECYCLING UTILITY FUND - 65300 PUBLIC UTILITY FUND 2015 2016 Actual Actual 2017 September YTD 2017 Budget 2018 Budget Change 2019 Budget 49311 - RECYCLING OPERATING REVENUES 4707-PENALTIES $ 11,145 $ 11,909 $ 10,340 $ 8,000 $ 8,000 0.00% $ 8,000 4751 - RECYCLING SERVICE FEES 304,289 385,546 296,027 352,354 385,134 9.30% 392,837 TOTAL SALES AND USER FEES 315,434 397,455 306,367 360,354 393,134 9.10% 400,837 TOTAL OPERATING REVENUES 315,434 397,455 306,367 360,354 393,134 9.10% 400,837 OPERATING EXPENSES 6204 - STATIONARY SUPPLIES 25 111 107 150 150 0.00% 150 TOTAL SUPPLIES 25 111 107 150 150 0.00% 150 6301 - ACCTG, AUDIT & FIN'L SERVICES - 28 - - - 0.00% - 6307 - PROFESSIONAL SERVICES 39 - 51 100 100 0.00% 100 6322 - POSTAGE 880 880 640 1,400 1,400 0.00% 1,300 6423 - LOGIS CHARGES 5,164 4,872 3,255 4,632 4,858 4.88% 5,027 6436 - UNCOLLECTIBLE CHECKS/DEBTS - 79 - - - 0.00% - 6449 - OTHER CONTRACTUAL SERVICE 262,541 262,573 196,977 367,377 375,000 2.07% 382,500 TOTAL SERVICES & OTHER CHARGES 268,624 268,432 200,923 373,509 381,358 2.10% 388,927 6361 - GENERAL LIABILITY INSURANCE 1,156 960 1,076 740 1,521 105.54% 1,612 TOTAL INSURANCE 1,156 960 1,076 740 1,521 105.54% 1,612 TOTAL OPERATING EXPENSES 269,805 269,503 202,106 374,399 383,029 2.31% 390,689 OPERATING INCOME (LOSS) 45,629 127,952 104,261 (14,045) 10,105 -171.95% 10,148 NONOPERATING REVENUES 4603 - INTEREST EARNINGS 280 898 1,505 951 1,565 64.56% 1,565 4605 - UNREALIZED INVESTMENT GAIN/LOSS 25 (207) 0.00% TOTAL INVESTMENT EARNINGS 305 691 1,505 951 1,565 64.56% 1,565 NONOPERATING EXPENSES 6471-ADMINISTRATIVE SERVICE TRANSFER 22,478 22,478 7,311 9,769 11,169 14.33% 11,169 TOTAL TRANSFERS 22,478 22,478 7,311 9,769 11,169 14.33% 11,169 NET CHANGE IN FUND BALANCE $ 23,456 $ 106.165 _$98455 _L__L2_28631 $ 501 -102.19% $ 544 31 o O)01 V Mn nmmi0 m ' O m N a m V 0 m m m M N O M O O .V-. 0) m M 0 V 1� V M O V Of N y M W m m - 0 i m moi N EL ws ev M w O m N p m V N m m m m N m N fV r N Q r r m e m K r W M O N V V V V V V a M vj M e» O MN V (mON N r O M Cl! 42t V M 69 m M O ON � V fMO .�- � rrN Gro �tm0 M N V O N fO0 m W-0 -Om mon uVi O N V V V V V O CL ui b9 M 09 O n N V V n n R m< m O Ol Q N V V V V V a` M Fn to w cd O V N D hONO? 1 1 r'VV V V r O d N tj m N VsM� O N CL ` o Nm O�Om m m V 0 m� OHO � M O NN V tAT� �rto0 N m �N r (V c o W N M OVJ V V T GVJ VMV W a` M tg m N o n'n m m n r O 0' O (V O N V O) V O !O O V V Ol N d CM'1 ` M O) N t�•l T M y F» w o Ci nN oo� �umi cmov n �o 0 m m y 0 N N O N O CL` my Nr m MO V r Olf" M O V N O m V m m V t N V m N NN mO' O m� m 'O Om no O N IL` M a M o "N ON ^ V GnO DN� rOfN� 'tO n c (V O N N O NO O- O N O O N a` O.N. o oi •- -o o m n O°'n n n m m o oio y mm V ocom m va0 It FS °' O N a` m vu�m on�m n rnm n O m M m W N N O n I 0) n O ' N m N N M N a 7 A V m V V iD O N M M M M N M M N a` o m N^ V m M O m O m N N N N� H it Om0 mm Mm O4D N O O N n`. e3 y f» O M Mv m rn m m V N (n N O m m n m O <h m v W Ol O) m V N m O> N M t9 m o �r V'O O) m NNN mm M ' O 00 N N V M n NON N m r r N V y � OI O �.-N A Q � C d Q f9 69 m IA C N Ui0 � y O LL d m A C o m a c o m C y L C y A y U 9 d C W U 10 W U m Q n N LL V tTC y Z y V C y jO' V •!� C N> > m m m 9 2 L y� N C y Ol U A mL > ac00 >O St°- ainOS� yUwwz y R LLQ' W U U v K N Cl) O O a 0 C LL 6L m N sl M .r - I V 41 O N m O O O O O O O O V N O V N N Cl) RECYCLING UTILITY RATE COMPARISON Residential User - Per Quarter The chart above is illustrating the annual comparison of the City's recycling utility rates with seven other cities which are considered to be similar to Brooklyn Center. All rates presented are for 2017, with the exception of the budgeted 2018 rate for the City of Brooklyn Center. The City is part of a joint powers organization called the Hennepin Recycling Group (HRG) which manages the recycling program for the member communities. There is no budgeted 2018 rate increase. 33 0 o V) Ul �) UA ILI O CI UA J ° o U 0 p0 pon OE Ju- C e m Mo 0 ® q W ® �' • 0- > 0 0 4-j N n� 0 � n v 0 �� ®� V bA (2) Co L CA c_ ao n o COjc � uo 4O OO a) 0 � 4-, o o o 6 •- cn ,-, E O a, O a) 0- � U L— a) ° 4-J o •— + .. = o O U •� p i M � C)- (1) r -I O m 0L �: s Q > \ L. .0 c L- _ � QJ V) V1 U C -O (A-0 w (A O I LO M bA tt7m m +r LN4 I Ln Ica co tip CD r--4 C I 0 Cl) IT d) 0 d) ij 4-J C7% �-4 0 0FD bD u M �A 0 lu� (U Tt 94 bJD pil PA -t C'7% PLA -t 0 co �1 ro brj' bf) Q •r� . bU 40 ?N bid 0 "o + ' 0 0 0 bf) 03 U q) -+ , i M tl ,M ,4- 00 (u ' Q (L) � . r-4 M C) 0 ,� U cd C41 (U ctro c -a M M 0 s/a va P-1 O Q C`I C-1 a..l p A. A LO it .Ir { f ,,� o "• I�f1 1 'd bb . � cd O }y r • `✓ � �.{ 4 ',w Ln O lu ti Q� � 1, SIJ �i O a I - TU M 4-�Ln �1J 91 1-1 D t ul Idtu tu tu Ln to .pq y �, r L1�1 iet [Q V 0 4 4 � -0 ' td y^� td 11J 'U *+ "a as � in 4 i 2 P, 0 s/a va P-1 O Q C`I C-1 a..l p A. A LO Vl ro W 71 c c— c ,O J jry � T Q 0 0 a--+ O U ggqp VP �I D Cl) W lR '� H jry � Q 4 JA I �4jNWI h��+�11 •-, NWIW 4 Q V 47 0) O ^� �l 8O'� � new Oo U a'' upp 4Y 4i yp h 1u�): 1? CO ui �`• v� f pp U CJ ppfpy Al 3l3 �� 4) C7 a b]47V 4'I 1147 Q4Y Y�%V117} V't G C 0- c1 G ggqp VP �I D Cl) lR '� H jry � Q �4jNWI h��+�11 N4i NWIW 4 Q 47 �l 8O'� � new �inH a'' upp 4Y 4i yp h 1u�): 1? ui �`• v� f pp U yyaa,, ppfpy �b7 4) C7 a b]47V 4'I 1147 Q4Y Y�%V117} V't G f1 c1 G Oa X08 0 3 r1.3 n�a a O �90 rc ES nI Qe � kr a U 0 0 Uu UA 00 0 Q0O a- j 0- E 77 Un Cn L o 0 Oil LfO 00 VO �j C u 0 UAc co °o 4-1 .O C o0 0 �/ j o oj °o CO m No O M p N ~ M U N N O N tl r LO CD M Com)r O N O O 6F 61) L0 � M EH � r (V M 69 F9 (fl LO 00 LO 60- Ea) � Oo LO 69- 619L r- � 00 00 qt (fl 6c3 O UO O N .O O r 00 ' ' O NO O O LO O V) It N 69 LC) N LNC') CY) cMe) N d' 64 i '0• O O N OM LO N r d M 69 00 N i N O N O(V O O (D ,�i N (D N ' O 000 � O N N � Co M M M 64 C\l C14 i i Co � O C) t` O LO 00 M M 64 Co M 00 O M r (D 00 O LO 00 0) N O r CO lq' N O N O N M N r 64 O 0 1- W r O 0 ' O m O- (D O LC) It O 1- O O 0) 't N r CY) CY) O 'tet It O LO Cl) 00 Ln 0 0) 1-: LC) M N O C14 It N It N Cl) LO (D - O t` r N r 1- 0) LC) ti (3) r CD ' O (J) O (0 ' r CD 'ct � r � O O r r LO r ct LC) qT� O r CO t- o (0 O r (O LO CO d• O r N It It O N � N (D ci' r O d d r N W (D ' O M O W' LO ct N N r CO O LC) M r d 00 O M M (0 0 00 r (D LO r r r O r L() (D N O (D r- N N � LO � UO') Iq (0 d LO ((D I� r M r O M O LC) N O (D ' O m O N' 0) N r I- N O r- O O (0 r N O ti N LC) 0) d' O It 00 r N V LC) N O (fl LC) O O O O co m LO((DD M M It LO N 1t N � O (0 (0 r M I- r M CD 00 (0 M O N M M O (D r ' ' O 00 O O LO LC) LO M M M LC) CD N 0 I- 1- M r r M M rl- 6 L() � 6 r d CO r r L) LO N LO M N M 'It r >0) Lai O C � U E U N W � ca) + U U N m 0 (Q O O d :r EQ d. m N O-0 "a c C:G)CL O O O p >05zmmE-- m •• It m ' rn � m 0 LO 00 M O (D qq O 0 ' O H O ' V- O LO O O r O 0) r- 00 N C) It O UO') Iq O A N O r- O LC) O M O �00 M LO N ti It N N I N � CO r-: c7 69 LO co Fir M It O O 00 I- O (C) ' O (D O' ' (0 r- (0 00 N O ti O r CY) ti r 0 r- Cl) 0) r O O O CO (D CD ti r N N (D r (0 LO (D 0) (D M r N C0 N LO N LO N 00 LC) r r I- r M CD 00 (0 M O N M M O (D r ' ' O 00 O O LO LC) LO M M M LC) CD N 0 I- 1- M r r M M rl- 6 L() � 6 r d CO r r L) LO N LO M N M 'It r >0) Lai O C � U E U N W � ca) + U U N m 0 (Q O O d :r EQ d. m N O-0 "a c C:G)CL O O O p >05zmmE-- m •• It m ' rn � m 0 LO LO 0 0 N V- M M V- O N d O O r O 0) CY) N ti CD r N co ' I-- N (o O C O M N LO M 'd r O N r LC) M 000 � (o 000 r f- ' r 0) O r- i � O 'd � O O It M LC) O ct LO (3) O M I` CY) r 00 N (D 00 r 10 69 (0 M ' 00 (D (fl O C O N O N N It le r O N r LC) (O M CD O M LC) ci 000 (D d• N O 00 N (D 00 r 10 69 (0 M ' 00 (D (fl O C O (D O C d' I` It L O W M rl O M LC) O N=3C � N C C (0 La �00 14-N ti Do 00 N � 00 r N 69 LO co ' It LO C0 M � Nd' M 000 r- M M O 00 M N_ ti M ti N M 00 le 00 r Il- 00 r IN LO -,T Ln (o LC) 00 I- O N O ti m 00 r N CO CO r 0) LC) ti ti 0) It LUC) N (D LD LO LO ILO r � (0 LO r N 2 _ C N 06 a U •x LL.. L N W 11 W N O U p U U U 0 cn a) CO c (n O O L p - L (6 (B (0 (n (A (!) C L D. L C= Q Q Q C a ai(n0S�000oUo�l� W CO LO co O I- 64 64 O) C C O C (A C m U L O W U CL N Q (n C N=3C M Q) M 0) N C C (0 La m (C6 CL C m .0 L NU0�Wz a) x O t (n cu 0 U 0 LL O O O O O O O O O O O O O O O O O O O O O O O' O O O 0 O O0 O OO 0 O 0 d M M N N �-1 ci' N m O N c -I m O N O m O N 61 N O N 00 N O N N O N OD N i6 O N W U1 U) U N C O ER N ro CO s lzTN N U O N m N O a U A N N }' O N 0 is t : .Q O N O N O N Q1 c -i O N 00 ci O N t\ O N lD ci O N AF N V 0 U N co n m o 11 M N r � 64 6cl. 6c* 61) 6C4. t& ffl� Q) 4, E U V (( � M 4=� CI E N 3 0 LIM EF} E9 I- M 00 M M � M N N 00 N O ,;T Nt CV 00 w -IM N r - CD LO O lr-� 00 L ry L it a) LL � LL U c Ip W :3 �a 9 U O UO O N III P& ,a7 (6 0 U O Q N O Lf) CF) M 00 O N LO 6q LO ,f* N N 0) lq. 6F) LO ' O N M O ti M I` 00 d' r- Qc) LO 0 00 O I` 0) O 0) (C) O 'IT M Iq 'T r r LO r- 00 r- (3) M CC) M W- 00 00 ' O r 00 O r- Lf) O M N CC) r- M (.0 (C) C) 00 C ) 00 ;T 00 %T Cl) CO r -- CD -O co 00 M N N Ef} N M d' 'T 00 0 N ' M N VN r LO "p N O N N 0 .4) O 00 N o N 00 B n O (f} E9 CIA CO 0) d' Ln M OO r- CO00 O MN LO N +� co O �t N N V 00 j O N 1,-N (CV O `. ICY)t n 00 EF} E9 I- M 00 M M � M N N 00 N O ,;T Nt CV 00 w -IM N r - CD LO O lr-� 00 L ry L it a) LL � LL U c Ip W :3 �a 9 U O UO O N III P& ,a7 (6 0 U O Q N O Lf) CF) M 00 O N LO 6q LO ,f* N N 0) lq. 6F) LO ' O N M O ti M I` 00 d' r- Qc) LO 0 00 O I` 0) O 0) (C) O 'IT M Iq 'T r r LO r- 00 r- (3) M CC) M W- 00 00 ' O r 00 O r- Lf) O M N CC) r- M (.0 (C) C) 00 C ) 00 ;T 00 %T Cl) CO r -- CD -O co 00 M N N Ef} LO N r- N N N M d' M I'- r- LO N ' i O r r LO "p N O N N 0 (D q 00 N N N 00 B O O r- d CIA CO 0) d' Ln M OO r- CO00 O LO M co N �t N 7 -- V 00 j O N 1,-N (CV d' `. ICY)t U) 00 Lf) �1 d M co r- LO 0) d' 1 F C) It m Il- M O O O M ' r O O M O M M O O ti NT d- ON� M OCY) It d M M N� M N 00 It M O N N 00 N r- It LO d" N 00 ti ff 000 O O M O P -: M M M M N N I CO N r- r- 00 LO N 0 M r- r- 4 r- N LO 0 N 0 0 0 O ' LO O r- I` 0 O T CD 'T I� 00 r- r- r- r- O O r- 0 , Lf) M o0 06 'T I` M LO CO M r- N CO N r- It ,;T N O r- 0 LO CO M r- N LO N r- N N N M d' M I'- r- LO N ' i O r r LO "p N O N N 0 (D q I- N LO r- 0 0 I- O V 0) 0) (6 0) d' Ln M OO r- CO00 O LO M r co r- M N 7 -- V 00 j f� r- O 1,-N N t' d' `. N 00 d �1 d N co r- LO 0) d' 1 F C) It m Il- M O O O M ' r M N LO LO (D N O N d- ON� M CO CO M M 00 N 00 O 00 N LO N r- N N N M d' M I'- r- LO N ' O O r r LO "p N O N N 0 lzr � — 0 0 r- r- Nt r- O N N 00 00 N N 0 LO r- r- 00 M CO r- M O LO N r co r- 00 O 7 -- LO N r - M 0) ' d' c'� 0 0 000 ~0 00 IT - l 00 It 0 000 o Lr LO O LO co � O d' CC) N LM N d' O N M r� l N 0) CC) N r- LO 0) r- M to r O r LO r- � 1- V 00 j f� r- O I` O I `. 00 d �1 d N co r- LO 0) d' 1 0 N ( r- N LO Il_ ' 0) Ln O O 0) 00 IT ti O r LO dI" N LO O LO co � O d' CC) N LM N ti M N dM N 0) CC) N r- LO Il- r- CO I-- r I N LO co Lfj r co 0 0 N_ M Ln N N (C) I-- r - ti Lf) O O r CO LO O r co 0) 00 IT ti Lr O CC) 0 r d' O LO co � O d' CC) N N (C) I-- r - ti Lf) O O r � IT I r- I N N CO co O r co 0) 00 IT O 0) O 00 O r M O � d CO O 00 CC) N d' O CO IT r- O � IT I r- I N N r- M N O I- oo I- M — T M 0) M (D ti M 0) r- O Ln M O M M NT d Lf) N O I- co 00 N O O d- L() Iv r- , 00 O I` N 00 r- N I- N r- O I- N 00 �- r- N N r- (C) 0) 0) CO 0) LO 0) r- M r- O IZT LO r- 00 1- Lfj M Ln U -i d `. a) �. 0) C C fa O � i o (n -CU C (n � C � U j ,o ca C a) 06 X p '�- W O a) N a) a) Q to a) +� U (n U 0 U U d a) C o °? N ani O c v, 0 c N Ca E Q d � a) CO c U) '� ca (n (A m ca a�o c c L = Q 0--a -0 m m Q C m >O Szco Q,a-U)0 S�oUoo�-°- NUa�wz y W U U O O O O O O O O O O ' O OOOOOOO O' O' 0 OO 0 O 0 O 0 O O 00 O 00 O 00 O 00 O 0 0 0 Ln d' M M N N rl r -II N M O N ci M O N O M O N Ql N O N 00 N O N r, N O N lD N O N N O N rj N O N m N O N N N O N N O N O N O N Q1 r -I O N 00 rH O N -I O N �-I O N 0 0 0 0 0 0 0 0 0 � 60 � to u 4 6a H3 00 (0 O r � r U O Q N :rte L ry V L (V a. 0000 N 69 O CO V N N d• LO M (f) i O O O C M O I` 0) r r (ii i CDi M Ll 00 lq- O O (Ci 69 0 00 i i M LO O LO LO'Od• N O 00 r r zol I O COY) M r NM O � ' O 00 O O M N N Il - O Oo lq' N M N f` (O r r �- M. M �NN0N000C(o O 00 LO O O O M O O 00 r M O d• N (YM (O 00 M r LO LC) I-- ti N N O O N M M LO r (\ M r I- O O_ 0 0 0 0 KTLO W ' OO d• Iq O O w M O O CM I7 O CO L6 Co N C7 M M Ln r Co C\j CD I— N O (0Y) M N f� - T-7 i COO NMIqLOr-m0mU) 000 M LO LO N C6 (6 LNC) N 1--: (O N M PO N r ;T M r N O CMN LJO O r- Lo O Md• (MO' O M LMC) LO N c) c) co N N O N M M r - r M 0) r 0 LO O M a 00 LO O N U N (17 O LO LO N M r N O �p N P, r a o CD W I� LO M Il- O w O O O O r-7 O V--� M rl O CO a) O M COO N COY) N Lf)O a) W N r r T" a) O O r - LC) r r •p N N ONO O (Oo ONO 69 64 U'o- V1 M d LO m d M o OD04 CO O O C) O Q Q= r UN C C6 V: � a) O � (n :7, �N U a) x o s CL0-U) \ 69 CR O M 70 00) L(7 O a) O W � O �O - N M O M M N 69 f!? (6 V LC) M r N 69 I� O 00 O r � r M W O O (-4 OOO co 69 69 • 0 O N (O � dM f� 0) O r- M r d N a) O �p N d 6a H3 00 (0 O r � r U O Q N :rte L ry V L (V a. 0000 N 69 O CO V N N d• LO M (f) i O O O C M O I` 0) r r (ii i CDi M Ll 00 lq- O O (Ci 69 0 00 i i M LO O LO LO'Od• N O 00 r r zol I O COY) M r NM O � ' O 00 O O M N N Il - O Oo lq' N M N f` (O r r �- M. M �NN0N000C(o O 00 LO O O O M O O 00 r M O d• N (YM (O 00 M r LO LC) I-- ti N N O O N M M LO r (\ M r I- O O_ 0 0 0 0 KTLO W ' OO d• Iq O O w M O O CM I7 O CO L6 Co N C7 M M Ln r Co C\j CD I— N O (0Y) M N f� - T-7 i COO NMIqLOr-m0mU) 000 M LO LO N C6 (6 LNC) N 1--: (O N M PO N r ;T M r N O CMN LJO O r- Lo O Md• (MO' O M LMC) LO N c) c) co N N O N M M r - r M � r N O O O I` m I- m (o LO CO 1;T M N V (D N L(O M r L(O 'lz O r Ln I- O LO V N O CO M LO O N N d LO 00 N M r N C14 r r w c L (n W a) a) c � U O (D d Q) (n oa c c� m fl o o o >oszm�- LO (O r () 0, r r N O N Coa) N (O r N M 00 d 00 'T M T -- co N r CO r N r M ' 0 LO 0 0 h O d COY) w (O O O 00 N M CCD (r0 N N (17 O LO LO N M M O r M r N O O M P, r LO O�_ O O_ 0 0LO ' ' 0�0 O CD W I� LO M Il- O w O O O O r-7 O V--� M rl O CO a) O N r COO N COY) N � r N O O O I` m I- m (o LO CO 1;T M N V (D N L(O M r L(O 'lz O r Ln I- O LO V N O CO M LO O N N d LO 00 N M r N C14 r r w c L (n W a) a) c � U O (D d Q) (n oa c c� m fl o o o >oszm�- LO (O r () 0, r r N O N Coa) N (O r N M 00 d 00 'T M T -- co N r CO r N r M ' 00 r O v- 00 T" O00 N COD O (M N M 't O O M (fl O Ntl 0�0 O M le a) M V - N Lo a) W N 69 (O O N O T" r O r - LC) r r O N ONO O (Oo ONO N U'o- Ln co d LO m d M c (n m OD04 CO 00 N Q Q= •a) -Q�ZZc C C6 V: � cli � (n :7, m co a) d) o 6Fi a) x o s CL0-U) s�DU���H 00) O 0) O M O W U - M O M M N LC) (6 V LC) M 69 I� 0) ' 00 O O M W M OOO co M O N (O � dM f� 0) O r- M r d N M ' -7(4 69 I- LOr ti O q' ti CO r CD (V Or M M LO CO N N O N N 0 d V r V r N 69 a) N N N co N O Lo a) W N CO (O O N O T" r O r - LC) r r CO c - a) a) � C: •0 U U Q V •C: `) v 7 N N U'o- Ln co d LO m d M c (n m 0) CO r 00 O r N Q Q= N co N N rl,' (V c o tm a) 06 a) W U Q- d U) U c - a) a) � C: •0 U U Q V •C: `) v 7 N N U'o- @ O N 'o R= ca _ c N (n 0 'a o c (n m m U) m N ca c v c Q Q= •a) -Q�ZZc mm aci Qcm m a) � (n :7, m co a) d) o i s a) x o s CL0-U) s�DU���H w0C�wz W U U V) m U O O O O O O O O O O O O O O O O O O O O O O O O O O O O 00 O 00 O 0 O 0 00 O Ih' d^ M M N' N c i ri N m 0 N m 0 N O m O N Ql N O N 00 N O N r - r'4 O N N to 16 O � N C W U') N U O m ru co N cn O U r14 m N O N � f6 4� N p N O N � Q M U CD ' N O N O N O N Ql ci O N W c -I O N c -I O N ci O N ►.J im v N LC 0 0 O O C' 00 E L� 0 n -o 0 0 GO m 0 n 00 rn- 1 00 o� ou 0 0 0 0 C) �2 0 Mlt r1uJ U V 00 0 n a to 00 � o U O o M (0 o O 0 0 SOA o M CI 0 Uf) CI_ U/) co Ci 0- 0 0 0 al_ 0 a. E 0 0 41=� 1�4 0 U 0 o� C� r 0 m 0 g "a 0 3 d a N U t v ® O �i O O O O N N V- V- 6% Edi 64i 649, 6ci L O a) N L. m U d d N O 0' d 'a LL W M ai N to rn ao, oy L L � T 6f! V L a M � � � I N O p �4 as f0 C7 � T LO O � LO O O,l a/ I L is ori 69 T 69 L s � M T O 0 oU0 Q M N 0 0 0 0 � N r T O6p9 as 69 69 64 69 61i rn ao, oy �4 as /o J O O,l a/ s }, as M o � E L LO J � 4- cu L— W Q O 4- 0 CC Ta U) 00 O.C 0 1 N J �at4 N aJ 4 m O oo J4 a��y 3 0 LO L 1 70 CC) N U N () O O N ^L n 69 LO Lf) Or U N O O N d d3 69 LC) L _0 CD O U N O .O N ^L I..L 6a 69 LO N O O N (yg E9 LO L O O O O N 6a 69 LO L -a N O O N n 60 - LO L CC) ca O � r U O Q N O N ' O O O Ln L(') NT O LO ' O LO Iq O 'IT LO Ef} 1 O Cl) LO Iq O V LO IT I O M LO(D O O LO Iq 61} 1 O O O O LOC\j co 1 O N 5 L6 LO It 603 O LO O C'7 Ili ( LOI N LO O C.C) LO LO O CA d' LC) M O LO (D M Lf� CY) 00 d' O LO N rl_ co O ' LCA � Ln � 00 O N O O O � O as 1 LCA S M O O LCA LC) O O (9 ) "It r- � � T -- 'IT � LO Ce) N M O ' M � c7 I` 00 O 0 0 (7) N � 0 066 � I` C+0 O LCA amd' 00 O O VO' LC) � � T- O It LO O M O ' M CO � O 00 O (7) O O O � O O � O O O d' amd' 00 OM O VO' LC) � � N O C'7 1- O M O ' 00I- O O O 00 O I` O 00 O � O ~ O ~ amd' O OM O VO' LC) 000 � LO ) "It r- � T- N -- CD O V O O m O ' 00 O d' O 00 O I- CY) 00 O � O ~ O ~ amd' O ti O V- LC) 000 � LO ) "It r- IT � M MMMMNOI N q M LA 04 0000 � 00 r- 00 O 00 O 00 O r- � � O � O ~ amd' CC) LO O L Lr) LC) 000 000 LO ) "It r- IT co MMMMNOI N q M LA 04 0000 � 00 r- rn d0 co O � N O r- Lf) Ln N Iq LO CC) LO O L Lr) LC) LO r LO I dT ' N q M LA IN 0000 � 00 r- � O � � d Ln co I;f C6 a� Ln LO � O (7) L Lr) LC) LO r LO 00 M ' L -o 00 co Cl) O 0000 � O r- IT O O O d' CA M (C) O 06 IT O NT N I' : - d' 00 rmlL Ln m co Cl) I 00 0 Cl) COC) 0000 C`7 (QC) 00 r- O O CA (C) T- W) � (C) O 06 IT O 00 M LO - LO O LC) "T O � le co Cl) I (A O co O C7 ('7 00 0000 r- �CY) � � 1` � ti � (C) O 06 IT O 00 M dam' "t O co Cl) I CO (A O N M O M 0000 O f� O � 1` � ti � (C) O 06 IT O 00 O L O LO I� LC) d � M O Cl) I � (A O N M Co L 00 a) Cl) t7 I- M � O � (C) O 06 IT O 00 00 000 T- O Ln Iq (.0 LO Lf) O Cl) Lo (A O N M � O � 00 1;3- M to Lf") — C)J T- Lf) (C) d' IT LO 00 'T 'T Lf) T- c CY) LO ) "It IT F2 M (n 0) O = c c a� CD U M c06m L QW W CD ,( p U) D� O v c (B i U) (u m .0 p L = (n a) �_ N (U CO c (p (U C3 N c -0 N M N Q cQ- _ • Q Q N c M t� c Q L) C m (,6 C L Q m (cII �O 0 z� awo-smou yUWWZN w W U U F2 M 3 0 LL O O o O O o O O O O O O O O O O O O ON O 00 O 0 lD OV N m O N r N m O N O m O N al N O N 00 N O N r\ N O N O r -I O N 00 r -i O N r, r -I O N N 00 O N C W Ln N 41 C) u N c 00 N In O U V M LO N O N � f6 4� N N 0 O r14 41Q m U c -I N O N i O N O N O r -I O N 00 r -i O N r, r -I O N N T. - to to 3 d L O Z U) d d 'O V N O tb t0 d N V- e- EA 64 EA Ef? 6M 69 a m s Q w N N 3 0 LL LO I` N O N U N (U O O N d 69- � CD <F N 70 N O U N N O O N d 6} Gq N N C-4 CJ O U N (U O O N d (f} Chi O N N- _0 p U OI O �O N n eaGl� 00 U 00 N O O N a. 60 64 � M 70 N C) O O N n O LO M It- N M Co Cfl � � r U O Q N �� O I- I -- O Eft N f - O Ln O 00 O IT IT LO 00r- N O NT 69- O O (A LO (D � M T-� cri T -- (Y) M Ef} M � T- T- LC) T-- 00 (r) 619 - LO Ln d7 d' O O M m ti Cd O O_ N O O ti Iq OC) CA co CY) O M (h LO N O 00 M LCA LO -r-- LO f O O N d" rL CIO O d LO N � (D k, O 0) � r- O (D O T.- O d 00 CD O N Iq or) O M O O ' ti O ' (A �� _M 00 00 d r- V-:, I� � IT Ld d' 00 C:) N M O N O N d m .� co co00 � ti O ' O ti ' O �� O 00 00 d r- V-:, O 00 00 Ld O 00 C:) N M O M N Iq d 00 O ' O O ' 00 �� O 00 00 d d0" V-:, 00 00 � 0) O __ C:) N M O M N Iq d _Y, O M N T'" N T 00 N ' co 0 ' I ti O OC) i LO tii �� 00 00 d 00 V-:, (p 00 � 0) N __ I'll T- M d _Y, O M N T'" N T 00 N ' co 0 ' I ti ()0 , �� N Cli N M 0) � 0) N __ ry') M M M _Y, O M N T'" N T 00 N ' co 0 ' I ti co N LO N N M 2) 2) O __ (D M C M co .� co co00 � L 0 ( m O m (,fl r- ' N cu LU -� ' U Q IT N 0)U C N0) T- V-:, C6 00 r- N N' m qT N (A 0) O N N C m N= co (N M T- co N LO 2) 2) __ C (a .� Cn O (� L 0 ( m U (D Qw C cu LU U ' U Q U) N 0)U C N L U V c u) N :--� L V 0� E O N co C m N= C "o M (C M" C W M 'a Q- r a- N m C L N N Q U p m m jOc� QU)o � U� -S NU�wz N W V U co N LO 3 0 O O O O O O O th O O O O O' O' O O O O O OOO chi -i{�/} tomo to t/>• � t� O m O N rn N O N W N O N r - N O N LD N O N N O N d' N O N U� C 0 C M W N O N N U C m ro m N � N � O fa N u r -I N O N O N O N O N 00 c -i O N r - i -i O N -I O N n �' ® CD O O O O O 64 6�1 O 00 w V N TMI E9 69 64 Vj} 64 0 0 3 0 n a m LL m a) N O LO N IhL