The URL can be used to link to this page

Home My WebLink About2021 10-18 FCAC IT Y C O UNC I L/F INANC I AL C O M M IS S IO N M E E T I NG V I RT UA L meeting being conducted by electronic means in accordance with Minnesota S tatutes, section 13D.021 P ublic portion available for connection via telephone Dial: 1-312-626- 6799 Meeting I D: 81108155657# P asscode: 424490# October 18, 2021 AGE NDA 1.Call to Order The City Council requests that attendees turn off cell phones and pagers during the meeting. A copy of the full City C ounc il packet is available to the public . The packet ring binder is loc ated at the entrance of the council chambers. 2.Roll Call a.City Council Ryan _____ L awrence A nderson _____ Graves _____ Butler _____ Elliott _____ b.F inancial Commission Dwapu _____ I shola _____ Kpaleh _____ Kragness _____ Van Der Werf _____ 3.Approval of Agenda 4.Consideration Items a.Enterprise Funds - B rooklyn Center L iquor - E arle B rown Heritage Center b.Utility Funds - Water Utility - S anitary Sewer Utility - S torm Drainage Utility - S treetlight Utility - Recycling Utility 5.Future Budget Discussion/City Council M eetings a.Public Hearing & Budget Presentation - December 6, 2021 6.Adjournment 2022 Brooklyn Center Department Budget Narrative by Fund Department Name: 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 and sundry items such as glassware, ice and non- intoxicating beverages. Store # 1 is the larger of the two stores in located in Shingle Creek Crossing at 1350 Shingle creek crossing. Store #2 is located in the Boulevard Marketplace shopping center at 6930 Brooklyn Boulevard. The stores operate Sunday through Saturday. Special events are provided through periodic local brewery, distillery and winery trips from BC Liquors. We have a rewards program called BC Buck$ that rewards customers the more points they accure. A market study was completed in 2017 that reviewed operations and potential locations for municipal liquor stores. As part of that review, a financial analysis was completed that illustrated the financial benefit to the City of store ownership instead of leasing. In 2019, City Council approved the purchase of land at 1350 Shingle Creek Crossing to relocate Store #1 from 5625A Xerxes. We opened that new store on March 2nd of 2020. Now we will move on to owning store #2, we will look to purchase land in 2021 and build in 2022 when our lease expires after being in that location for 20 years. Store #2 will be apx 20% smaller than our flagship store in Shingle Creek Crossing. Key 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  Purchase land for store #2 in 2021 and build a store in 2022. • Respond to Customer Needs  We will be upgrading our BC Buck rewards program to include outgoing communication. We will begin collecting text numbers and e-mails to send out digital coupons on customer birthdays, special occasions or if they have not visited ours stores for awhile. We will also look into a delivery option in 2022 or 2023. Staffing Levels Positions FTEs 2021 2022 2023 • Liquor Operations Manager • Liquor Store Manager • Liquor Store Assistant Manager • Liquor Store Category Lead FT • Liquor Store Category Lead (2-3 - PT Staff) • Liquor Store Shift Lead (9 – PT Staff) • Store Clerk/Stocker (19-22 - PT staff) TOTAL 1 2 2 1 1.2 3 5.5 15.7 1 2 2 2 - 4 5 16 1 2 2 2 - 4 5.5 16 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 clerks 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. 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 visiting brewerys and winerys as a community trip. a. Events scheduled three times per year 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. a. Reserve a specified transfer in the budget process Annual Operating Goal Performance Measures: *YTD data Performance Objectives Description of Performance Measure Performance Levels Previous Value (2020) *Actual Value (2021) Target Value Inventory variance levels $21,835 (Goal <$10,000) $269,093 (Goal <$10,000) <$10,000 Increase # rewards members 14,712 (11,000 ) 27351 (18,000 ) 30,000 members Compliance checks passed 100% (4/4) (Goal 100%) 100% (4/4) (Goal 100%) 100% Increase social media presence - Facebook 473 Likes (Goal 450) 748 Likes (Goal 550) 900 Likes Upgrade Business Account Increase social media presence – Twitter 522 Followers (Goal 600) 521 Followers (Goal 700) 700 Followers Increase social media presence – Instagram 212 Followers (Goal 200) 241 Followers (Goal 400) 400 Followers Increase social media presence – LinkedIn 0 Launch in 2021 (Goal 100) 200 Connections Contribution to City’s Capital Improvement Fund $? $? $150,000 2022 Brooklyn Center Department Budget Narrative by Fund Department Name: Community Activities, Recreation & Services The 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: The 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 the Heritage Center. Maintenance is also provided to the buildings and grounds for the commercial office spaces/buildings located at the Heritage Center for 3 tenants. A management agreement with Flik International for the food and beverage is currentl y in place through the year 2026. Key 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 90% repeat 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 2022, the Heritage Center will celebrate 32 years of operation as one of the region’s premier conference and events facilities, and as a centerpiece of the Brooklyn Center community. Through our 2022 marketing efforts, we will continually highlight the Heritage Center and the City of B rooklyn Center. Key Infrastructure Investments • Increase Capital Fund Transfer In 2022, we are setting our revenue goals to 5.1 million. By doing so, our goal is to increase our yearly transfer of funds into our Capital Improvements Fund from $150,000 to $200,000. Staffing Levels Positions FTEs 2021 2022 2023 • EBHC Manager • Secretary/Receptionist • Secretary/Billing Clerk • Operations Director • Sales Director • Sales Managers • Catering Sales Managers • Maintenance Custodian • Crew Chiefs • Part-time Staff Total 1 1 1 1 1 4 2 3 2 9 25 1 1 1 1 1 4 2 3 2 9 25 1 1 1 1 1 4 2 3 2 9 25 Strategic Functions/Division(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 2022 Marketing Plan: a. Participate in five industry associations to network for business. b. Add a minimum of 20 new corporate clients. c. Work with Flik International, Embassy Suites, Marriott Fairfield Inn, and other area hotels on bookings of events. 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 environment 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 Levels *Actual Value Target Value Increase Revenue 1,700,803 5,149,663 Control Expenses (Percentage of Cost to Revenue) 105.64%/115.55% 41.90%/67.00% Customer Satisfaction Rating 96% 100% New Corporate Clients 3 20 Increase Misc. Catering Sales $4,547 $27,000 *2020 data 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49611 - BROOKLYN CENTER LIQUOR OPERATING REVENUES 4761 - LIQUOR SALES 2,098,001$ 1,804,655$ 1,215,561$ 2,250,000$ 2,320,000$ 3.11% 4762 - WINE SALES 544,323 485,579 315,202 550,000 556,000 1.09% 4763 - BEER SALES 2,165,001 1,513,821 959,547 2,390,000 2,320,000 -2.93% 4764 - SALES-NON TAXABLE 54,615 28,705 21,949 65,000 65,000 0.00% 4765 - SALES-TAXABLE 60,837 54,571 38,902 63,200 63,200 0.00% TOTAL SALES AND USER FEES 4,922,777 3,887,331 2,551,161 5,318,200 5,324,200 0.11% 5581 - COST OF SALES-LIQUOR 1,442,144 1,263,751 760,037 1,552,500 1,625,000 4.67% 5582 - COST OF SALES-WINE 379,057 335,979 188,688 366,000 370,000 1.09% 5583 - COST OF SALES-BEER 1,612,803 1,144,458 635,839 1,840,000 1,880,000 2.17% 5584 - OTHER COSTS OF SALE-NONTAXABLE 34,591 15,064 10,140 41,600 42,700 2.64% 5585 - OTHER COSTS OF SALE-TAXABLE 40,838 40,539 20,704 40,500 40,500 0.00% 5587 - INVENTORY VARIANCES 4,736 5,344 5,568 5,000 7,000 40.00% 5589 - DELIVERY CHARGES 22,038 17,460 13,394 24,000 23,000 -4.17% TOTAL COST OF GOODS SOLD 3,536,207 2,822,595 1,634,370 3,869,600 3,988,200 3.06% TOTAL OPERATING REVENUES 1,386,570 1,064,736 916,791 1,448,600 1,336,000 -7.77% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 268,706 284,570 227,150 320,226 357,432 11.62% 6102 - OVERTIME-FT EMPLOYEES 216 352 119 400 500 25.00% 6103 - WAGES-PART TIME EMPLOYEES 207,439 197,070 164,636 168,000 235,651 40.27% 6104 - OVERTIME-PART TIME EMPLOYEES 122 - - 500 200 -60.00% 6111 - SEVERANCE PAY 1,247 2,994 2,667 24,000 - -100.00% 6122 - PERA COORDINATED PLAN 35,737 36,146 29,393 36,880 44,535 20.76% 6125 - FICA - SOCIAL SECURITY 29,909 29,433 24,789 30,486 36,816 20.76% 6126 - FICA - MEDICARE 6,994 7,068 5,798 7,131 8,610 20.74% 6131 - CAFETERIA PLAN CONTRIBUTIONS 53,311 56,745 48,840 75,221 95,634 27.14% 6141 - UNEMPLOYMENT COMPENSATION - 153 - - - 0.00% 6151 - WORKER'S COMP INSURANCE 19,187 22,441 18,670 21,488 27,135 26.28% TOTAL PERSONAL SERVICES 622,868 636,972 522,062 684,332 806,513 17.85% 6201 - OFFICE SUPPLIES 860 843 833 1,200 1,000 -16.67% 6214 - CLOTHING & PERSONAL EQUIPMENT 1,738 767 234 2,000 1,200 -40.00% 6219 - GENERAL OPERATING SUPPLIES 11,104 8,230 28,675 11,000 11,000 0.00% 6223 - BUILDINGS & FACILITIES - - - 2,000 2,000 0.00% 6239 - OTHER REPAIR & MAINTENANCE SUPPLIES 163 100 1,426 2,000 2,000 0.00% 6242 - MINOR EQUIPMENT 2,005 1,558 9,758 3,000 3,000 0.00% 6243 - MINOR COMPUTER EQUIPMENT 3,305 6,707 3,533 2,500 - -100.00% TOTAL SUPPLIES 19,175 18,205 44,459 23,700 20,200 -14.77% 6301 - ACCTG, AUDIT & FIN'L SERVICES 3,648 2,555 2,509 3,000 3,000 0.00% 6307 - PROFESSIONAL SERVICES 8,652 1,521 2,302 5,000 2,500 -50.00% 6321 - TELEPHONE/PAGERS 2,568 2,092 1,676 2,000 2,000 0.00% 6331 - TRAVEL EXPENSE/MILEAGE 834 288 - 1,000 - -100.00% 6333 - FREIGHT/DRAYAGE 92 - - - 5,000 100.00% 6341 - PERSONNEL ADVERTISING - - - - - 0.00% 6349 - OTHER ADVERTISING 2,479 790 119 5,000 2,000 -60.00% 6351 - PRINTING 42 - - 500 200 -60.00% 6402 - EQUIPMENT SERVICES 2,835 3,939 99,671 10,000 10,000 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE 386 26,004 25,126 5,000 5,000 0.00% 6406 - MULTI-FUNCTION MTNCE 763 844 465 1,000 1,000 0.00% 6409 - OTHER REPAIR & MAINT SVCS - - - - - 0.00% 6415 - OTHER EQUIPMENT 503 - - - - 0.00% 6421 - SOFTWARE LICENSE 51 187 - - - 0.00% 6422 - SOFTWARE MAINT 17,096 10,546 5,944 14,500 14,500 0.00% 6423 - LOGIS CHARGES 20,100 18,255 15,667 22,000 22,000 0.00% 6428 - PROTECTION SERVICES 3,959 5,419 1,799 12,000 12,000 0.00% 6431 - SPECIAL EVENTS 575 - - 1,000 1,000 0.00% 6432 - CONFERENCES AND SCHOOLS 3,203 - 1,390 5,000 5,000 0.00% 6433 - MEETING EXPENSES 67 289 63 100 200 100.00% 6434 - DUES & SUBSCRIPTIONS 4,010 4,030 3,819 5,500 5,500 0.00% 6435 - CREDIT CARD FEES 58,679 48,995 29,811 56,000 58,000 3.57% 6438 - CASH SHORT (OVER)3,603 4,087 674 2,000 2,000 0.00% 6441 - LICENSES, TAXES & FEES - 20 - 20 20 0.00% 6449 - OTHER CONTRACTUAL SERVICE 6,155 6,012 104,327 5,000 5,000 0.00% MUNICIPAL OFF-SALE LIQUOR - STORE #1 FUND - 60900 ENTERPRISE FUND 6452 - BC BUCK$ REDEMPTION 45,011 (14,874) - - - 0.00% 6491 - MERCHANDISE FOR RESALE - - 181,789 - - 0.00% TOTAL SERVICES & OTHER CHARGES 185,311 120,999 477,151 155,620 155,920 0.19% 6361 - GENERAL LIABILITY INSURANCE 2,549 2,105 1,936 2,844 3,621 27.32% 6362 - PROPERTY INSURANCE 2,153 7,020 4,459 2,017 5,871 191.08% 6364 - DRAM SHOP INSURANCE 6,367 6,136 4,347 7,025 6,850 -2.49% 6366 - MACHINERY BREAKDOWN INSURANCE 516 1,284 796 476 1,320 177.31% TOTAL INSURANCE 11,585 16,545 11,538 12,362 17,662 42.87% 6381 - ELECTRIC 20,615 19,367 14,516 25,000 25,000 0.00% 6382 - GAS 5,080 14,661 7,466 3,200 10,000 212.50% 6383 - WATER - 289 201 200 300 50.00% 6385 - SEWER - 357 281 200 300 50.00% 6386 - STORM 357 1,762 1,361 200 2,000 900.00% 6389 - STREET LIGHTS 46 186 139 100 200 100.00% TOTAL UTILITIES 26,098 36,622 23,964 28,900 37,800 30.80% 6412 - BLDGS/FACILITIES 239,096 97,617 - 39,492 - -100.00% TOTAL RENT 239,096 97,617 - 39,492 - -100.00% 6494 - DEPRECIATION EXPENSE 18,455 107,432 79,569 160,000 140,000 -12.50% TOTAL DEPRECIATION 18,455 107,432 79,569 160,000 140,000 -12.50% TOTAL OPERATING EXPENSES 1,122,588 1,034,392 1,158,743 1,104,406 1,178,095 6.67% OPERATING INCOME 263,982 30,344 (241,952) 344,194 157,905 -54.12% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 23,122 11,821 4,563 7,650 4,550 -40.52% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 6,560 4,433 - - - 0.00% TOTAL INVESTMENT EARNINGS 29,682 16,254 4,563 7,650 4,550 -40.52% 4320 - MISC FEDERAL GRANTS - 43,479 - - - 0.00% 4606 - OTHER REVENUE 2,975 1,874 3,630 - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS - - 250,258 200 200 0.00% 4922 - PROJECT ADMINISTRATION - - - - - 0.00% TOTAL MISCELLANEOUS 2,975 45,353 253,888 200 200 0.00% TOTAL NONOPERATING REVENUES 32,657 61,607 258,451 7,850 4,750 -39.49% NONOPERATING EXPENSES 6601 - BOND PRINCIPAL - - 100,000 100,000 135,000 35.00% 6611 - BOND INTEREST 24,340 85,751 83,600 83,600 78,900 -5.62% 6621 - PAYING AGENT/OTHER FEES 80,732 1,250 1,250 500 1,250 150.00% TOTAL DEBT SERVICE 105,072 87,001 184,850 184,100 215,150 16.87% 6471 - ADMINISTRATIVE SERVICE TRANSFER 55,271 55,271 58,916 78,555 79,504 1.21% 6476 - CAPITAL PROJECT FUND TRANSFER 325,487 - - 150,000 - -100.00% 6496 - LOSS ON FIXED ASSET DISPOSAL - 34,688 - - - 0.00% 6482 - MISC TRANSFER OUT - - - - - 0.00% TOTAL TRANSFERS 380,758 89,959 58,916 228,555 79,504 -65.21% NET CHANGE IN FUND BALANCE (189,191)$ (85,009)$ (227,267)$ (60,611)$ (131,999)$ 117.78% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49612 - 69TH AVENUE LIQUOR STORE OPERATING REVENUES 4761 - LIQUOR SALES 785,573$ 681,124$ 647,946$ 830,000$ 855,000$ 3.01% 4762 - WINE SALES 202,786 168,043 143,538 206,000 208,000 0.97% 4763 - BEER SALES 939,161 694,091 615,381 1,020,000 990,000 -2.94% 4764 - SALES-NON TAXABLE 30,596 14,217 14,950 34,500 34,500 0.00% 4765 - SALES-TAXABLE 34,460 25,905 24,429 36,000 36,000 0.00% TOTAL SALES AND USER FEES 1,992,576 1,583,380 1,446,244 2,126,500 2,123,500 -0.14% 5581 - COST OF SALES-LIQUOR 555,599 491,244 394,873 573,000 595,000 3.84% 5582 - COST OF SALES-WINE 149,997 118,242 86,054 137,000 138,500 1.09% 5583 - COST OF SALES-BEER 707,035 534,772 401,843 785,500 805,000 2.48% 5584 - OTHER COSTS OF SALE-NONTAXABLE 19,654 7,736 7,373 22,000 22,700 3.18% 5585 - OTHER COSTS OF SALE-TAXABLE 24,435 18,618 16,847 23,000 23,000 0.00% 5587 - INVENTORY VARIANCES 7,506 (12,364) 19,426 5,000 7,000 40.00% 5589 - DELIVERY CHARGES 8,261 8,343 5,869 8,000 8,000 0.00% TOTAL COST OF GOODS SOLD 1,472,487 1,166,591 932,285 1,553,500 1,599,200 2.94% TOTAL OPERATING REVENUES 520,089 416,789 513,959 573,000 524,300 -8.50% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 111,750 108,319 75,137 105,199 107,304 2.00% 6102 - OVERTIME-FT EMPLOYEES 55 - - - - 0.00% 6103 - WAGES-PART TIME EMPLOYEES 112,790 99,036 101,136 105,000 120,000 14.29% 6104 - OVERTIME-PART TIME EMPLOYEES 117 - 8 500 100 -80.00% 6111 - SEVERANCE PAY 3,225 5,599 - - - 0.00% 6122 - PERA COORDINATED PLAN 16,853 15,551 13,221 15,878 17,056 7.42% 6125 - FICA - SOCIAL SECURITY 14,353 12,791 11,207 13,125 14,099 7.42% 6126 - FICA - MEDICARE 3,357 3,095 2,621 3,069 3,297 7.43% 6131 - CAFETERIA PLAN CONTRIBUTIONS 18,606 18,588 16,333 19,795 20,790 5.03% 6151 - WORKER'S COMP INSURANCE 9,050 9,660 7,708 9,251 10,393 12.34% TOTAL PERSONAL SERVICES 290,156 272,639 227,371 271,817 293,039 7.81% 6201 - OFFICE SUPPLIES 326 375 458 500 500 0.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 739 329 - 1,000 500 -50.00% 6219 - GENERAL OPERATING SUPPLIES 4,135 3,031 7,403 3,500 3,000 -14.29% 6223 - BUILDINGS & FACILITIES - - - - - 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES - - 360 - - 0.00% 6242 - MINOR EQUIPMENT 2,583 8,899 6,177 2,000 2,000 0.00% 6243 - MINOR COMPUTER EQUIPMENT 6,107 2,292 2,018 - - 0.00% TOTAL SUPPLIES 13,890 14,926 16,416 7,000 6,000 -14.29% 6307 - PROFESSIONAL SERVICES 750 419 522 1,000 500 -50.00% 6321 - TELEPHONE/PAGERS 1,581 1,857 1,312 2,150 2,150 0.00% 6331 - TRAVEL EXPENSE/MILEAGE 325 - - 200 250 25.00% 6333 - FREIGHT/DRAYAGE 35 - - - 5,000 100.00% 6341 - PERSONNEL ADVERTISING - - - - - 0.00% 6349 - OTHER ADVERTISING 275 - - 1,000 200 -80.00% 6351 - PRINTING - - - - - 0.00% 6402 - EQUIPMENT SERVICES 775 3,862 194 2,000 2,000 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE 4,776 3,028 2,512 2,000 2,500 25.00% 6406 - MULTI-FUNCTION MTNCE 962 214 136 180 - -100.00% 6422 - SOFTWARE MAINT 7,494 2,889 2,512 3,000 3,000 0.00% 6423 - LOGIS CHARGES 8,319 7,748 6,721 9,000 9,000 0.00% 6428 - PROTECTION SERVICES 492 583 91 500 500 0.00% 6432 - CONFERENCES AND SCHOOLS 725 - - 1,000 1,000 0.00% 6433 - MEETING EXPENSES - - - - - 0.00% 6434 - DUES & SUBSCRIPTIONS 1,730 1,730 1,881 2,000 2,000 0.00% 6435 - CREDIT CARD FEES 24,732 20,034 16,390 23,000 23,000 0.00% 6438 - CASH SHORT (OVER)1,507 635 12,813 1,000 1,000 0.00% 6441 - LICENSES, TAXES & FEES 7 13 - 100 20 -80.00% 6449 - OTHER CONTRACTUAL SERVICE 8,827 9,338 7,413 7,000 8,000 14.29% 6452 - BC BUCK$ REDEMPTION 14,646 (4,958) - - - 0.00% 6491 - MERCHANDISE FOR RESALE - - 51,975 - - 0.00% TOTAL SERVICES & OTHER CHARGES 77,958 47,392 104,472 55,130 60,120 9.05% MUNICIPAL OFF-SALE LIQUOR - STORE #2 FUND - 60900 ENTERPRISE FUND 6361 - GENERAL LIABILITY INSURANCE 2,549 2,105 1,935 2,845 3,621 27.28% 6362 - PROPERTY INSURANCE 1,093 1,336 951 1,177 1,653 40.44% 6364 - DRAM SHOP INSURANCE 2,279 2,453 1,722 2,514 2,710 7.80% 6366 - MACHINERY BREAKDOWN INSURANCE 266 248 173 278 270 -2.88% TOTAL INSURANCE 6,187 6,142 4,781 6,814 8,254 21.13% 6381 - ELECTRIC 17,161 17,151 16,038 19,000 19,000 0.00% 6382 - GAS 2,615 1,660 1,046 3,000 2,000 -33.33% 6383 - WATER - - - - - 0.00% TOTAL UTILITIES 19,776 18,811 17,084 22,000 21,000 -4.55% 6412 - BLDGS/FACILITIES 93,360 93,360 83,264 93,360 93,360 0.00% TOTAL RENT 93,360 93,360 83,264 93,360 93,360 0.00% 6510 - LAND - - - 500,000 - -100.00% 6520 - BUILDINGS & FACILITIES - - - - 2,500,000 100.00% 6540 - EQUIPMENT & MACHINERY - - - - - 0.00% TOTAL CAPITAL OUTLAY - - - 500,000 2,500,000 400.00% TOTAL OPERATING EXPENSES 501,327 453,270 453,388 956,121 2,981,773 211.86% OPERATING INCOME 18,762 (36,481) 60,571 (383,121) (2,457,473) 541.44% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 18,239 8,975 4,563 7,650 4,550 -40.52% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 6,560 4,433 - - - 0.00% TOTAL INVESTMENT EARNINGS 24,799 13,408 4,563 7,650 4,550 -40.52% 4320 - MISC FEDERAL GRANTS - 18,005 - - - 0.00% 4606 - OTHER REVENUE - 95 128 - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS 1,811 10,651 11,659 100 100 0.00% TOTAL MISCELLANEOUS 1,811 28,751 11,787 100 100 0.00% TOTAL NONOPERATING REVENUES 26,610 42,159 16,350 7,750 4,650 -40.00% NONOPERATING EXPENSES 6471 - ADMINISTRATIVE SERVICE TRANSFER 27,635 27,635 29,458 39,277 39,752 1.21% TOTAL TRANSFERS 27,635 27,635 29,458 39,277 39,752 1.21% NET CHANGE IN FUND BALANCE 17,737$ (21,957)$ 47,463$ (414,648)$ (2,492,575)$ 501.13% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49851 - EBHC-ADMINISTRATION OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 195,202$ 178,671$ 118,963$ 201,244$ 216,615$ 7.64% 6102 - OVERTIME-FT EMPLOYEES - 384 18 - - 0.00% 6103 - WAGES-PART TIME EMPLOYEES - - - - - 0.00% 6111 - SEVERANCE PAY 3,034 4,410 - - - 0.00% 6122 - PERA COORDINATED PLAN 14,640 13,429 8,924 15,093 16,246 7.64% 6125 - FICA - SOCIAL SECURITY 12,133 10,764 7,470 12,478 13,430 7.63% 6126 - FICA - MEDICARE 2,838 2,543 1,747 2,918 3,141 7.64% 6131 - CAFETERIA PLAN CONTRIBUTIONS 32,982 26,154 16,333 43,549 49,896 14.57% 6151 - WORKER'S COMP INSURANCE 1,424 1,485 936 1,569 1,776 13.19% TOTAL PERSONAL SERVICES 262,253 237,840 154,391 276,851 301,104 8.76% 6223 - BUILDINGS & FACILITIES - - - - - 0.00% 6242 - MINOR EQUIPMENT 250 366 - 2,500 3,000 20.00% 6243 - MINOR COMPUTER EQUIPMENT 25,955 1,844 301 4,000 - -100.00% TOTAL SUPPLIES 26,205 2,210 301 6,500 3,000 -53.85% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 2,509 3,000 3,000 0.00% 6303 - LEGAL SERVICES - 1,026 - 500 500 0.00% 6307 - PROFESSIONAL SERVICES 6,496 1,287 1,023 1,700 2,500 47.06% 6321 - TELEPHONE/PAGERS 901 997 1,031 1,000 1,000 0.00% 6421 - SOFTWARE LICENSE 51 294 - - - 0.00% 6422 - SOFTWARE MAINT 9,774 3,700 1,515 9,000 9,000 0.00% 6423 - LOGIS CHARGES 22,404 20,595 17,730 26,000 26,000 0.00% 6432 - CONFERENCES AND SCHOOLS 1,117 - - 4,000 4,000 0.00% 6449 - OTHER CONTRACTUAL SERVICES - 148 - 200,800 - -100.00% TOTAL SERVICES & OTHER CHARGES 43,479 30,602 23,808 246,000 46,000 -81.30% 6361 - GENERAL LIABILITY INSURANCE 285 346 369 319 542 69.91% 6362 - PROPERTY INSURANCE 6,929 7,666 5,149 7,753 8,016 3.39% 6366 - MACHINERY BREAKDOWN INSURANCE 638 1,000 760 711 1,190 67.37% TOTAL INSURANCE 7,852 9,012 6,278 8,783 9,748 10.99% 6494 - DEPRECIATION EXPENSE 4,973 4,987 3,311 5,000 5,000 0.00% TOTAL DEPRECIATION 4,973 4,987 3,311 5,000 5,000 0.00% TOTAL OPERATING EXPENSES 344,762 284,651 188,089 543,134 364,852 -32.82% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 32,862 11,531 1,045 13,900 5,100 -63.31% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 12,438 - - - - 0.00% TOTAL INVESTMENT EARNINGS 45,300 11,531 1,045 13,900 5,100 -63.31% 4320 - FEDERAL GRANTS - 81,885 - - - 0.00% 4606 - OTHER REVENUE 461 - 7,500 - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS 1,882 4,158 - - - 0.00% TOTAL MISCELLANEOUS 2,343 86,043 7,500 - - 0.00% TOTAL NONOPERATING REVENUES 47,643 97,574 8,545 13,900 5,100 -63.31% NONOPERATING EXPENSES 6471 - ADMINISTRATIVE SERVICE TRANSFER 99,561 99,561 93,822 125,096 125,353 0.21% 6476 - CAPITAL PROJECT FUND TRANSFER 350,000 50,000 - - - 0.00% TOTAL TRANSFERS 449,561 149,561 93,822 125,096 125,353 0.21% NET CHANGE IN FUND BALANCE (746,680)$ (336,638)$ (273,366)$ (654,330)$ (485,105)$ -25.86% EARLE BROWN HERITAGE CENTER (EBHC) - ADMINISTRATION FUND - 61700 ENTERPRISE FUND 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49852 - EBHC-CONVENTION CENTER OPERATING REVENUES 4821 - ROOM RENTALS 1,092,472$ 288,657$ 146,117$ 732,478$ 732,478$ 0.00% 4822 - LABOR CHARGES 35,075 15,479 3,050 45,000 45,000 0.00% 4823 - EQUIPMENT RENTALS 433,806 132,192 45,426 284,940 350,000 22.83% 4825 - COMMON AREA MTNCE 21,866 21,866 16,399 21,000 21,000 0.00% 4827 - SECURITY SERVICES 9,000 850 1,750 15,000 15,000 0.00% 4828 - CLIENT SERVICES 57,448 8,197 8,655 75,000 75,000 0.00% 4829 - MISCELLANEOUS 6,245 1,302 2,700 6,000 6,000 0.00% 4844 - FOOD AND BEVERAGE SALES 13,080 - - - - 0.00% TOTAL SALES AND USER FEES 1,668,992 468,543 224,097 1,179,418 1,244,478 5.52% TOTAL OPERATING REVENUES 1,668,992 468,543 224,097 1,179,418 1,244,478 5.52% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 564,194 418,890 254,859 461,170 675,020 46.37% 6102 - OVERTIME-FT EMPLOYEES 1,382 1,352 1,477 1,750 1,750 0.00% 6103 - WAGES-PART TIME EMPLOYEES 129,409 71,572 38,654 95,000 95,000 0.00% 6104 - OVERTIME-PART TIME EMPLOYEES 590 356 - - - 0.00% 6111 - SEVERANCE PAY 4,175 7,929 16,165 - - 0.00% 6122 - PERA COORDINATED PLAN 46,027 30,732 18,419 41,843 57,882 38.33% 6125 - FICA - SOCIAL SECURITY 42,688 28,841 18,733 34,592 47,851 38.33% 6126 - FICA - MEDICARE 9,983 7,117 4,381 8,092 11,190 38.28% 6131 - CAFETERIA PLAN CONTRIBUTIONS 144,184 100,374 61,727 122,729 182,952 49.07% 6141 - UNEMPLOYMENT COMPENSATION 55 552 - - - 0.00% 6151 - WORKER'S COMP INSURANCE 30,411 23,799 14,467 25,230 36,046 42.87% TOTAL PERSONAL SERVICES 973,098 691,514 428,882 790,406 1,107,691 40.14% 6201 - OFFICE SUPPLIES 650 306 99 1,960 1,960 0.00% 6202 - COPYING SUPPLIES 1,351 23 213 1,260 1,260 0.00% 6203 - BOOKS/REFERENCE MATERIALS - - - 140 140 0.00% 6211 - CLEANING SUPPLIES 633 93 - 2,100 2,100 0.00% 6212 - MOTOR FUELS 107 - - 140 140 0.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 1,264 164 570 1,500 1,500 0.00% 6215 - SHOP MATERIALS 259 8 - 420 420 0.00% 6216 - CHEMICALS/CHEMICAL PRODUCTS 7,036 4,425 1,855 4,060 4,060 0.00% 6217 - SAFETY SUPPLIES 653 62 277 560 560 0.00% 6219 - GENERAL OPERATING SUPPLIES 24,585 10,673 4,128 23,800 23,800 0.00% 6223 - BUILDINGS & FACILITIES 18,724 12,758 526 17,500 17,500 0.00% 6225 - PARK & LANDSCAPE MATERIALS 3,787 955 642 3,920 3,920 0.00% 6226 - SIGNS & STRIPING MATERIALS 334 - - 210 210 0.00% 6227 - PAINT SUPPLIES 1,888 1,001 338 2,100 2,100 0.00% 6237 - LAUNDRY SUPPLIES - - - 56 56 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 3,118 887 1,681 5,600 5,600 0.00% 6241 - SMALL TOOLS 1,234 258 - 840 840 0.00% 6242 - MINOR EQUIPMENT 32,992 20,380 323 39,200 39,200 0.00% 6243 - MINOR COMPUTER EQUIPMENT 4,982 5,183 - 6,000 - -100.00% TOTAL SUPPLIES 103,597 57,176 10,652 111,366 105,366 -5.39% 6303 - LEGAL SERVICES 684 804 291 500 500 0.00% 6307 - PROFESSIONAL SERVICES 24,713 18,354 11,571 24,100 24,100 0.00% 6321 - TELEPHONE/PAGERS 5,960 4,799 3,329 6,000 6,000 0.00% 6322 - POSTAGE 541 336 - 450 450 0.00% 6331 - TRAVEL EXPENSE/MILEAGE 652 39 - 500 500 0.00% 6333 - FREIGHT/DRAYAGE 25 - - 100 100 0.00% 6341 - PERSONNEL ADVERTISING - - - 400 400 0.00% 6349 - OTHER ADVERTISING 92,832 99,661 48,027 82,090 82,090 0.00% 6351 - PRINTING 1,307 276 1,873 5,500 7,500 36.36% 6402 - EQUIPMENT SERVICES 80,315 50,411 19,316 60,000 70,000 16.67% 6403 - BLDGS/FACILITIES MAINT SERVICE 27,094 2,400 1,928 15,000 25,000 66.67% 6406 - MULTI-FUNCTION MTNCE 3,943 1,267 314 2,600 2,600 0.00% 6408 - COMMUNICATION/INFO SYSTEMS - - - - - 0.00% 6413 - OFFICE EQUIPMENT - - - 1,500 1,500 0.00% EARLE BROWN HERITAGE CENTER (EBHC) - CONVENTION CENTER FUND - 61700 ENTERPRISE FUND 6415 - OTHER EQUIPMENT 221,878 78,559 14,516 158,000 225,000 42.41% 6422 - SOFTWARE MAINT 995 1,192 - 2,500 2,500 0.00% 6423 - LOGIS CHARGES - - - - - 0.00% 6428 - PROTECTION SERVICES 14,350 1,863 4,331 13,300 19,000 42.86% 6432 - CONFERENCES AND SCHOOLS 3,865 - - 8,900 8,900 0.00% 6433 - MEETING EXPENSES 1,020 - - 800 1,200 50.00% 6434 - DUES & SUBSCRIPTIONS 1,758 2,105 1,647 3,200 3,200 0.00% 6435 - CREDIT CARD FEES 9,689 4,900 1,801 5,000 5,000 0.00% 6436 - UNCOLLECTIBLE CHECKS/DEBTS (373) (2,510) - - - 0.00% 6438 - CASH SHORT (OVER)762 - - - - 0.00% 6405 - PARK & LANDSCAPE SERVICES 850 - - 3,000 3,000 0.00% 6421 - SOFTWARE LICENSE - 120 - - - 0.00% 6441 - LICENSES, TAXES & FEES 460 240 200 400 400 0.00% 6443 - PRIZE AWARDS/EXPENSE REIMB - - - - - 0.00% 6449 - OTHER CONTRACTUAL SERVICE 21,757 35,104 25,302 48,500 31,000 -36.08% 6451 - MTG PLANNER POINTS-EBHC - - - 3,000 3,000 0.00% TOTAL SERVICES & OTHER CHARGES 515,077 299,920 134,446 445,340 522,940 17.42% 6361 - GENERAL LIABILITY INSURANCE 3,876 5,944 1,080 3,258 1,686 -48.25% 6362 - PROPERTY INSURANCE 8,530 9,432 6,371 9,544 9,937 4.12% 6366 - MACHINERY BREAKDOWN INSURANCE 792 1,240 942 881 1,480 67.99% TOTAL INSURANCE 13,198 16,616 8,393 13,683 13,103 -4.24% 6381 - ELECTRIC 102,841 81,312 67,850 100,000 120,000 20.00% 6382 - GAS 16,247 13,279 10,732 20,000 20,000 0.00% 6383 - WATER 1,933 1,697 2,148 3,200 3,200 0.00% 6384 - REFUSE DISPOSAL 2,984 2,735 1,064 2,300 2,300 0.00% 6385 - SEWER 2,189 2,169 2,258 3,500 3,500 0.00% 6386 - STORM SEWER 1,616 1,390 1,869 3,500 3,500 0.00% 6389 - STREET LIGHTS 468 650 451 600 600 0.00% TOTAL UTILITIES 128,278 103,232 86,372 133,100 153,100 15.03% 6494 - DEPRECIATION EXPENSE 172,852 205,532 136,460 200,000 200,000 0.00% TOTAL DEPRECIATION 172,852 205,532 136,460 200,000 200,000 0.00% 6540 - EQUIPMENT AND MACHINERY - - - - - 0.00% TOTAL CAPITAL OUTLAY - - - - - 0.00% TOTAL OPERATING EXPENSES 1,906,100 1,373,990 805,205 1,693,895 2,102,200 24.10% OPERATING INCOME (237,108) (905,447) (581,108) (514,477) (857,722) 66.72% NONOPERATING REVENUES 4320 - MISC FEDERAL GRANTS - 212,997 - - - 0.00% 4359 - OTHER STATE GRANTS - - 300,000 - - 0.00% 4604 - ADMINISTRATIVE SERVICE TRANSFER - - 30 - - 0.00% 4606 - OTHER REVENUE 38 10 - - - 0.00% 4912 - CAPITAL CONTRIBUTIONS 293,809 43,919 - - - 0.00% 4921 - REFUNDS AND REIMBURSEMENTS - 500 - - - 0.00% TOTAL MISCELLANEOUS 293,847 257,426 300,030 - - 0.00% NET CHANGE IN FUND BALANCE 56,739$ (648,021)$ (281,078)$ (514,477)$ (857,722)$ 66.72% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49853 - EBHC-CATERING OPERATIONS OPERATING REVENUES 4842 - SERVICE CHARGES 567,132$ 133,326$ 58,328$ 397,600$ 617,686$ 55.35% 4844 - FOOD & BEVERAGE SALES 2,419,426 551,852 221,193 2,213,393 2,882,315 30.22% 4845 - LIQUOR/WINE/BEER SALES 259,268 50,768 55,137 275,509 368,664 33.81% 4848 - MISCELLANEOUS SALES 23,058 3,572 2,944 43,540 62,000 42.40% 4849 - MISCELLANEOUS SALES-NONTAXABLE 24,153 975 75 - - 0.00% TOTAL SALES AND USER FEES 3,293,037 740,493 337,677 2,930,042 3,930,665 34.15% 5586 - COST OF SALES-MISC - - - - - 0.00% 5591 - COST OF SALES-LABOR 1,475,167 529,842 188,040 957,462 1,367,804 42.86% 5592 - COST OF SALES-FOOD 628,966 152,414 87,354 500,010 720,579 44.11% 5593 - COST OF SALES-SUPPLIES 148,860 44,097 20,695 113,813 164,183 44.26% 5594 - COST OF SALES-MGMT FEES 132,600 100,000 33,333 103,000 103,000 0.00% TOTAL COST OF GOODS SOLD 2,385,593 826,353 329,422 1,674,285 2,355,566 40.69% TOTAL OPERATING REVENUES 907,444 (85,860) 8,255 1,255,757 1,575,099 25.43% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 23,540 87,604 45,620 117,238 124,685 6.35% 6102 - OVERTIME-FT EMPLOYEES 75 - - - - 0.00% 6103 - WAGES-PART TIME EMPLOYEES 35,682 5,756 576 26,000 26,000 0.00% 6104 - OVERTIME-PART TIME EMPLOYEES 38 69 - - - 0.00% 6111 - SEVERANCE PAY - - 3,360 - - 0.00% 6122 - PERA COORDINATED PLAN 4,222 6,963 3,465 10,743 11,301 5.19% 6125 - FICA - SOCIAL SECURITY 3,715 5,712 3,171 8,881 9,343 5.20% 6126 - FICA - MEDICARE 869 1,366 742 2,077 2,184 5.15% 6131 - CAFETERIA PLAN CONTRIBUTIONS - 20,176 11,880 23,754 33,264 40.04% 6151 - WORKER'S COMP INSURANCE 4,071 1,612 564 4,508 3,041 -32.54% TOTAL PERSONAL SERVICES 72,212 129,258 69,378 193,201 209,818 8.60% 6201 - OFFICE SUPPLIES 1,340 302 - 1,470 1,470 0.00% 6202 - COPYING SUPPLIES 1,334 213 429 1,260 1,260 0.00% 6211 - CLEANING SUPPLIES - - - 210 210 0.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 32 11 - 40 40 0.00% 6215 - SHOP MATERIALS - - - 50 50 0.00% 6216 - CHEMICALS/CHEMICAL PRODUCTS - - - 280 280 0.00% 6217 - SAFETY SUPPLIES 360 71 - 350 350 0.00% 6219 - GENERAL OPERATING SUPPLIES 81 - - 350 350 0.00% 6223 - BUILDINGS & FACILITIES 598 1,124 - 3,500 3,500 0.00% 6227 - PAINT SUPPLIES - - - 50 50 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 75 - - 700 700 0.00% 6242 - MINOR EQUIPMENT 39,629 10,792 - 36,470 42,000 15.16% 6243 - MINOR COMPUTER EQUIPMENT 1,055 340 280 - - 0.00% TOTAL SUPPLIES 44,504 12,853 709 44,730 50,260 12.36% 6307 - PROFESSIONAL SERVICES 9,869 9,140 4,153 16,300 16,300 0.00% 6321 - TELEPHONE/PAGERS 937 869 626 1,000 1,000 0.00% 6322 - POSTAGE - - - 150 250 66.67% 6349 - OTHER ADVERTISING 86,219 80,405 45,744 77,840 77,840 0.00% 6351 - PRINTING 11,920 - 1,705 7,500 10,000 33.33% 6402 - EQUIPMENT SERVICES 10,964 8,913 3,624 21,700 21,700 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE 5,555 2,137 5,644 12,250 13,000 6.12% 6406 - MULTI-FUNCTION MTNCE 4,512 5,576 4,355 5,500 5,500 0.00% 6409 - OTHER REPAIR & MAINT SVCS 1,199 436 327 1,330 1,400 5.26% 6413 - OFFICE EQUIPMENT - - - 1,000 2,000 100.00% 6415 - OTHER EQUIPMENT - - - 500 500 0.00% 6422 - SOFTWARE MAINT - - - 100 100 0.00% 6432 - CONFERENCES AND SCHOOLS 1,117 - - 3,000 4,200 40.00% 6433 - MEETING EXPENSES - - - 200 200 0.00% 6434 - DUES & SUBSCRIPTIONS 470 - - 500 500 0.00% 6435 - CREDIT CARD FEES 38,757 18,108 4,903 30,000 10,000 -66.67% 6436 - UNCOLLECTIBLE CHECKS/DEBTS 4,326 (4,988) - - - 0.00% 6438 - CASH SHORT (OVER)(222) (76) (10) - - 0.00% 6441 - LICENSES, TAXES & FEES - - - - - 0.00% 6449 - OTHER CONTRACTUAL SERVICE 9,398 23,725 17,648 35,500 18,000 -49.30% TOTAL SERVICES & OTHER CHARGES 185,021 144,245 88,719 214,370 182,490 -14.87% EARLE BROWN HERITAGE CENTER (EBHC) - CATERING FUND - 61700 ENTERPRISE FUND 6361 - GENERAL LIABILITY INSURANCE 2,222 2,152 1,592 1,891 2,489 31.62% 6362 - PROPERTY INSURANCE 10,392 11,492 7,798 11,632 12,180 4.71% 6366 - MACHINERY BREAKDOWN INSURANCE 1,021 1,600 1,216 1,138 1,910 67.84% TOTAL INSURANCE 13,635 15,244 10,606 14,661 16,579 13.08% 6381 - ELECTRIC 18,844 15,129 12,568 20,000 26,000 30.00% 6382 - GAS 15,894 12,980 10,504 19,000 19,000 0.00% 6383 - WATER 1,893 1,643 2,190 3,600 3,600 0.00% 6384 - REFUSE DISPOSAL 7,135 1,749 1,266 7,000 7,000 0.00% 6385 - SEWER 2,152 2,122 2,073 2,500 2,500 0.00% 6386 - STORM SEWER 1,616 2,491 1,553 1,600 1,600 0.00% 6389 - STREET LIGHTS 468 650 451 600 600 0.00% TOTAL UTILITIES 48,002 36,764 30,605 54,300 60,300 11.05% 6494 - DEPRECIATION EXPENSE 45,656 45,781 28,928 45,000 45,000 0.00% TOTAL DEPRECIATION 45,656 45,781 28,928 45,000 45,000 0.00% TOTAL OPERATING EXPENSES 409,030 384,145 228,945 566,262 564,447 -0.32% OPERATING INCOME 498,414 (470,005) (220,690) 689,495 1,010,652 46.58% NONOPERATING REVENUES 4320 - MISC FEDERAL GRANTS - 40,837 - - - 0.00% 4912 - CAPITAL CONTRIBUTIONS - - - - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS - - - - - 0.00% TOTAL MISCELLANEOUS - 40,837 - - - 0.00% NET CHANGE IN FUND BALANCE 498,414$ (429,168)$ (220,690)$ 689,495$ 1,010,652$ 46.58% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49854 - EBHC-OFFICE RENTAL OPERATING REVENUES 4831 - OFFICE RENTALS 104,490$ 95,930$ 59,107$ 97,917$ 25,680$ -73.77% TOTAL SALES AND USER FEES 104,490 95,930 59,107 97,917 25,680 -73.77% TOTAL OPERATING REVENUES 104,490 95,930 59,107 97,917 25,680 -73.77% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 2,113 308 - - - 0.00% 6103 - WAGES-PART TIME EMPLOYEES - 14 - 2,100 2,100 0.00% 6122 - PERA COORDINATED PLAN 159 24 - 158 158 0.00% 6125 - FICA - SOCIAL SECURITY 113 17 - 130 130 0.00% 6126 - FICA - MEDICARE 26 4 - 30 30 0.00% 6151 - WORKER'S COMP INSURANCE 145 26 - 156 163 4.49% TOTAL PERSONAL SERVICES 2,556 393 - 2,574 2,581 0.27% 6223 - BUILDINGS & FACILITIES 2,365 - - 700 700 0.00% 6225 - PARK & LANDSCAPE MATERIALS - - - 210 210 0.00% 6226 - SIGNS & STRIPING MATERIALS - - - 105 105 0.00% 6227 - PAINT SUPPLIES - - - 105 105 0.00% TOTAL SUPPLIES 2,365 - - 1,120 1,120 0.00% 6303 - LEGAL SERVICES - 908 - - 500 100.00% 6402 - EQUIPMENT SERVICES 17,023 8,332 - 5,600 5,600 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE - - - 15,000 15,000 0.00% 6441 - LICENSES, TAXES & FEES 7,651 7,838 4,456 6,500 6,000 -7.69% 6449 - OTHER CONTRACTUAL SERVICE 8,270 8,118 5,533 11,000 11,000 0.00% TOTAL SERVICES & OTHER CHARGES 32,944 25,196 9,989 38,100 38,100 0.00% 6361 - GENERAL LIABILITY INSURANCE 31 36 37 34 57 67.65% 6362 - PROPERTY INSURANCE 799 884 611 895 962 7.49% 6366 - MACHINERY BREAKDOWN INSURANCE 102 160 122 114 190 66.67% TOTAL INSURANCE 932 1,080 770 1,043 1,209 15.92% 6381 - ELECTRIC 5,800 6,511 4,499 7,500 7,500 0.00% 6382 - GAS 6,471 5,504 4,511 8,500 8,500 0.00% 6383 - WATER 671 557 615 900 900 0.00% 6384 - REFUSE DISPOSAL 119 - - 700 700 0.00% 6385 - SEWER 752 598 570 600 600 0.00% TOTAL UTILITIES 13,813 13,170 10,195 18,200 18,200 0.00% 6494 - DEPRECIATION EXPENSE 2,402 2,409 1,599 2,500 2,400 -4.00% TOTAL DEPRECIATION 2,402 2,409 1,599 2,500 2,400 -4.00% TOTAL OPERATING EXPENSES 55,012 42,248 22,553 63,537 63,610 0.11% NET CHANGE IN FUND BALANCE 49,478$ 53,682$ 36,554$ 34,380$ (37,930)$ -210.33% EARLE BROWN HERITAGE CENTER (EBHC) - OFFICE RENTALS FUND - 61700 ENTERPRISE FUND 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 60900 - BROOKLYN CENTER LIQUOR OPERATING REVENUES 4761 - LIQUOR SALES 2,883,573$ 2,485,779$ 3,080,000$ 1,863,508$ 3,175,000$ 70.38% 4762 - WINE SALES 747,109 653,622 756,000 458,739 764,000 66.54% 4763 - BEER SALES 3,104,162 2,207,911 3,410,000 1,574,928 3,310,000 110.17% 4764 - SALES-NON TAXABLE 85,211 42,922 99,500 36,900 99,500 169.65% 4765 - SALES-TAXABLE 95,297 80,475 99,200 63,331 99,200 56.64% TOTAL SALES AND USER FEES 6,915,352 5,470,709 7,444,700 3,997,406 7,447,700 86.31% 5581 - COST OF SALES-LIQUOR 1,997,743 1,754,995 2,125,500 1,154,910 2,220,000 92.22% 5582 - COST OF SALES-WINE 529,055 454,222 503,000 274,742 508,500 85.08% 5583 - COST OF SALES-BEER 2,319,839 1,679,230 2,625,500 1,037,682 2,685,000 158.75% 5584 - OTHER COSTS OF SALE-NONTAXABLE 54,246 22,800 63,600 17,513 65,400 273.44% 5585 - OTHER COSTS OF SALE-TAXABLE 65,273 59,157 63,500 37,552 63,500 69.10% 5587 - INVENTORY VARIANCES 12,242 (7,021) 10,000 24,994 14,000 -43.99% 5589 - DELIVERY CHARGES 30,299 25,804 32,000 19,263 31,000 60.93% 6491 - MERCHANDISE FOR RESALE - - - 233,763 - -100.00% TOTAL COST OF GOODS SOLD 5,008,697 3,989,187 5,423,100 2,800,419 5,587,400 99.52% TOTAL OPERATING REVENUES 1,906,655 1,481,522 2,021,600 1,196,987 1,860,300 55.42% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 380,456 392,889 425,425 302,288 464,736 53.74% 6102 - OVERTIME-FT EMPLOYEES 271 352 400 119 500 320.17% 6103 - WAGES-PART TIME EMPLOYEES 320,230 296,106 273,000 265,772 355,651 33.82% 6104 - OVERTIME-PART TIME EMPLOYEES 240 - 1,000 8 300 3650.00% 6111 - SEVERANCE PAY 4,472 8,592 24,000 2,667 - -100.00% 6122 - PERA COORDINATED PLAN 52,590 51,697 52,758 42,615 61,591 44.53% 6125 - FICA - SOCIAL SECURITY 44,261 42,223 43,611 35,996 50,915 41.45% 6126 - FICA - MEDICARE 10,351 10,163 10,200 8,419 11,907 41.43% 6131 - CAFETERIA PLAN CONTRIBUTIONS 71,917 75,333 95,016 65,173 116,424 78.64% 6141 - UNEMPLOYMENT COMPENSATION - 153 - - - 0.00% 6151 - WORKER'S COMP INSURANCE 28,237 32,101 30,739 26,378 37,528 42.27% TOTAL PERSONAL SERVICES 913,025 909,609 956,149 749,435 1,099,552 46.72% 6201 - OFFICE SUPPLIES 1,187 1,218 1,700 1,291 1,500 16.19% 6214 - CLOTHING & PERSONAL EQUIPMENT 2,477 1,096 3,000 234 1,700 626.50% 6219 - GENERAL OPERATING SUPPLIES 15,240 11,261 14,500 36,078 14,000 -61.20% 6223 - BUILDINGS & FACILITIES - - 2,000 - 2,000 100.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 163 100 2,000 1,787 2,000 11.92% 6242 - MINOR EQUIPMENT 4,588 10,457 5,000 15,935 5,000 -68.62% 6243 - MINOR COMPUTER EQUIPMENT 9,412 8,999 2,500 5,551 - -100.00% TOTAL SUPPLIES 33,067 33,131 30,700 60,876 26,200 -56.96% 6301 - ACCTG, AUDIT & FIN'L SERVICES 3,648 2,555 3,000 2,509 3,000 19.57% 6307 - PROFESSIONAL SERVICES 9,402 1,940 6,000 2,824 3,000 6.23% 6321 - TELEPHONE/PAGERS 4,150 3,949 4,150 2,988 4,150 38.89% 6331 - TRAVEL EXPENSE/MILEAGE 1,159 288 1,200 - 250 100.00% 6333 - FREIGHT/DRAYAGE 127 - - - 10,000 100.00% 6341 - PERSONNEL ADVERTISING - - - - - 0.00% 6349 - OTHER ADVERTISING 2,754 790 6,000 119 2,200 1748.74% 6351 - PRINTING 42 - 500 - 200 100.00% 6402 - EQUIPMENT SERVICES 3,610 7,800 12,000 99,865 12,000 -87.98% 6403 - BLDGS/FACILITIES MAINT SERVICE 5,163 29,033 7,000 27,638 7,500 -72.86% 6406 - MULTI-FUNCTION MTNCE 1,724 1,057 1,180 601 1,000 66.39% 6409 - OTHER REPAIR & MAINT SVCS - - - - - 0.00% 6415 - OTHER EQUIPMENT 503 - - - - 0.00% 6421 - SOFTWARE LICENSE 51 227 - - - 0.00% 6422 - SOFTWARE MAINT 24,590 13,435 17,500 8,457 17,500 106.93% 6423 - LOGIS CHARGES 28,419 26,003 31,000 22,389 31,000 38.46% 6428 - PROTECTION SERVICES 4,451 6,001 12,500 1,890 12,500 561.38% 6431 - SPECIAL EVENTS 575 - 1,000 - 1,000 100.00% 6432 - CONFERENCES AND SCHOOLS 3,928 - 6,000 1,390 6,000 331.65% 6433 - MEETING EXPENSES 67 289 100 63 200 217.46% 6434 - DUES & SUBSCRIPTIONS 5,740 5,760 7,500 5,700 7,500 31.58% MUNICIPAL OFF-SALE LIQUOR FUND - 60900 ENTERPRISE FUND 6435 - CREDIT CARD FEES 83,410 69,028 79,000 46,201 81,000 75.32% 6438 - CASH SHORT (OVER)5,110 4,722 3,000 13,487 3,000 -77.76% 6441 - LICENSES, TAXES & FEES 7 33 120 - 40 100.00% 6449 - OTHER CONTRACTUAL SERVICE 14,982 15,350 12,000 111,739 13,000 -88.37% 6452 - BC BUCK$ REDEMPTION 59,657 (19,832) - - - 0.00% TOTAL SERVICES & OTHER CHARGES 263,269 168,428 210,750 347,860 216,040 -37.89% 6361 - GENERAL LIABILITY INSURANCE 5,098 4,210 5,689 3,871 7,242 87.08% 6362 - PROPERTY INSURANCE 3,246 8,356 3,194 5,410 7,524 39.08% 6364 - DRAM SHOP INSURANCE 8,646 8,589 9,539 6,069 9,560 57.52% 6366 - MACHINERY BREAKDOWN INSURANCE 783 1,532 754 969 1,590 64.09% TOTAL INSURANCE 17,773 22,687 19,176 16,319 25,916 58.81% 6381 - ELECTRIC 37,775 36,519 44,000 30,554 44,000 44.01% 6382 - GAS 7,696 16,321 6,200 8,512 12,000 40.98% 6383 - WATER - 289 200 201 300 49.25% 6385 - SEWER - 357 200 281 300 6.76% 6386 - STORM SEWER 357 1,762 200 1,361 2,000 46.95% 6389 - STREET LIGHTS 46 186 100 139 200 43.88% TOTAL UTILITIES 45,874 55,434 50,900 41,048 58,800 43.25% 6412 - BLDGS/FACILITIES 332,456 190,977 132,852 83,264 93,360 12.13% TOTAL RENT 332,456 190,977 132,852 83,264 93,360 12.13% 6462 - FIXED CHARGES - - - - - 0.00% TOTAL CENTRAL GARAGE CHARGES - - - - - 0.00% 6510 - LAND - - 500,000 - - 0.00% 6520 - BUILDINGS & FACILITIES - - - - 2,500,000 100.00% TOTAL CAPITAL OUTLAY - - 500,000 - 2,500,000 100.00% 6494 - DEPRECIATION EXPENSE 18,455 107,432 160,000 79,569 140,000 75.95% TOTAL DEPRECIATION 18,455 107,432 160,000 79,569 140,000 75.95% TOTAL OPERATING EXPENSES 1,623,919 1,487,698 2,060,527 1,378,371 4,159,868 201.80% OPERATING INCOME 282,736 (6,176) (38,927) (181,384) (2,299,568) 1167.79% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 41,362 20,795 15,300 9,127 9,100 -0.30% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 13,120 8,866 - - - 0.00% TOTAL INVESTMENT EARNINGS 54,482 29,661 15,300 9,127 9,100 -0.30% 4320 - FEDERAL GRANTS - 61,483 - - - 0.00% 4606 - OTHER REVENUE 2,975 1,969 - 3,758 - -100.00% 4921 - REFUNDS & REIMBURSEMENTS 1,811 10,651 300 261,917 300 -99.89% 4922 - PROJECT ADMINISTRATION - - - - - 0.00% TOTAL MISCELLANEOUS 4,786 74,103 300 265,675 300 -99.89% TOTAL NONOPERATING REVENUES 59,268 103,764 15,600 274,802 9,400 -96.58% NONOPERATING EXPENSES 6601 - BOND PRINCIPAL - - 100,000 100,000 135,000 35.00% 6611 - BOND INTEREST 24,340 85,751 83,600 83,600 78,900 -5.62% 6621 - PAYING AGENT/OTHER FEES 80,732 1,250 500 1,250 1,250 0.00% TOTAL DEBT SERVICE 105,072 87,001 184,100 184,850 215,150 16.39% 6471 - ADMINISTRATIVE SERVICE TRANSFER 82,906 82,906 117,832 88,374 119,256 34.94% 6476 - CAPITAL PROJECT FUND TRANSFER 325,487 - 150,000 - - 0.00% 6496 - LOSS ON FIXED ASSET DISPOSAL - 34,688 - - - 0.00% 6482 - MISC TRANSFER OUT - - - - - 0.00% TOTAL TRANSFERS 408,393 117,594 267,832 88,374 119,256 34.94% NET CHANGE IN FUND BALANCE (171,461)$ (107,007)$ (475,259)$ (179,806)$ (2,624,574)$ 1359.67% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 61700 - EARLE BROWN HERITAGE CENTER OPERATING REVENUES 4821 - ROOM RENTALS 1,092,472$ 288,657$ 732,478$ 146,117$ 732,478$ 401.30% 4822 - LABOR CHARGES 35,075 15,479 45,000 3,050 45,000 1375.41% 4823 - EQUIPMENT RENTALS 433,806 132,192 284,940 45,426 350,000 670.48% 4825 - COMMON AREA MTNCE 21,866 21,866 21,000 16,399 21,000 28.06% 4827 - SECURITY SERVICES 9,000 850 15,000 1,750 15,000 757.14% 4828 - CLIENT SERVICES 57,448 8,197 75,000 8,655 75,000 766.55% 4829 - MISCELLANEOUS 6,245 1,302 6,000 2,700 6,000 122.22% 4831 - OFFICE RENTALS 104,490 95,930 97,917 59,107 25,680 -56.55% 4842 - SERVICE CHARGES 567,132 133,326 397,600 58,328 617,686 958.99% 4844 - FOOD & BEVERAGE SALES 2,432,506 551,852 2,213,393 221,193 2,882,315 1203.08% 4845 - LIQUOR/WINE/BEER SALES 259,268 50,768 275,509 55,137 368,664 568.63% 4848 - MISCELLANEOUS SALES 23,058 3,572 43,540 2,944 62,000 2005.98% 4849 - MISCELLANEOUS SALES-NON TAXABLE 24,153 975 - 75 - -100.00% TOTAL SALES AND USER FEES 5,066,519 1,304,966 4,207,377 620,881 5,200,823 737.65% 5586 - COST OF SALES-MISC - - - - - 0.00% 5591 - COST OF SALES-LABOR 1,475,167 529,842 957,462 188,040 1,367,804 627.40% 5592 - COST OF SALES-FOOD 628,966 152,414 500,010 87,354 720,579 724.90% 5593 - COST OF SALES-SUPPLIES 148,860 44,097 113,813 20,695 164,183 693.35% 5594 - COST OF SALES-MGMT FEES 132,600 100,000 103,000 33,333 103,000 209.00% TOTAL COST OF GOODS SOLD 2,385,593 826,353 1,674,285 329,422 2,355,566 615.06% TOTAL OPERATING REVENUES 2,680,926 478,613 2,533,092 291,459 2,845,257 876.21% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 785,050 685,472 779,652 419,442 1,016,320 142.30% 6102 - OVERTIME-FT EMPLOYEES 1,457 1,737 1,750 1,495 1,750 17.06% 6103 - WAGES-PART TIME EMPLOYEES 165,091 77,342 123,100 39,230 123,100 213.79% 6104 - OVERTIME-PART TIME EMPLOYEES 628 425 - - - 0.00% 6111 - SEVERANCE PAY 7,208 12,339 - 19,525 - -100.00% 6122 - PERA COORDINATED PLAN 65,048 51,148 67,837 30,808 85,587 177.81% 6125 - FICA - SOCIAL SECURITY 58,648 45,334 56,081 29,374 70,754 140.87% 6126 - FICA - MEDICARE 13,716 11,030 13,117 6,870 16,545 140.83% 6131 - CAFETERIA PLAN CONTRIBUTIONS 177,166 146,704 190,032 89,940 266,112 195.88% 6141 - UNEMPLOYMENT COMPENSATION 55 552 - - - 0.00% 6151 - WORKER'S COMP INSURANCE 36,051 26,922 31,463 15,966 41,026 156.96% TOTAL PERSONAL SERVICES 1,310,118 1,059,005 1,263,032 652,650 1,621,194 148.40% 6201 - OFFICE SUPPLIES 1,990 608 3,430 99 3,430 3364.65% 6202 - COPYING SUPPLIES 2,685 236 2,520 641 2,520 293.14% 6203 - BOOKS/REFERENCE MATERIALS - - 140 - 140 100.00% 6211 - CLEANING SUPPLIES 633 93 2,310 - 2,310 100.00% 6212 - MOTOR FUELS 107 - 140 - 140 100.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 1,295 174 1,540 570 1,540 170.18% 6215 - SHOP MATERIALS 259 8 470 - 470 100.00% 6216 - CHEMICALS/CHEMICAL PRODUCTS 7,036 4,425 4,340 1,855 4,340 133.96% 6217 - SAFETY SUPPLIES 1,013 132 910 277 910 228.52% 6219 - GENERAL OPERATING SUPPLIES 24,666 10,673 24,150 4,128 24,150 485.03% 6223 - BUILDINGS & FACILITIES 21,687 13,882 21,700 526 21,700 4025.48% 6225 - PARK & LANDSCAPE MATERIALS 3,787 955 4,130 642 4,130 543.30% 6226 - SIGNS & STRIPING MATERIALS 334 - 315 - 315 100.00% 6227 - PAINT SUPPLIES 1,888 1,001 2,255 338 2,255 567.16% 6237 - LAUNDRY SUPPLIES - - 56 - 56 100.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 3,193 887 6,300 1,681 6,300 274.78% 6241 - SMALL TOOLS 1,234 258 840 - 840 100.00% 6242 - MINOR EQUIPMENT 72,871 31,538 78,170 323 84,200 25968.11% 6243 - MINOR COMPUTER EQUIPMENT 31,992 7,367 10,000 581 - -100.00% TOTAL SUPPLIES 176,670 72,237 163,716 11,661 159,746 1269.92% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 3,000 2,509 3,000 19.57% 6303 - LEGAL SERVICES 684 2,738 1,000 291 1,500 415.46% 6307 - PROFESSIONAL SERVICES 41,078 28,781 42,100 16,746 42,900 156.18% 6321 - TELEPHONE/PAGERS 7,799 6,665 8,000 4,986 8,000 60.45% 6322 - POSTAGE 541 336 600 - 700 100.00% 6331 - TRAVEL EXPENSE/MILEAGE 652 39 500 - 500 100.00% EARLE BROWN HERITAGE CENTER (EBHC) FUND - 61700 ENTERPRISE FUND 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 6333 - FREIGHT/DRAYAGE 25 - 100 - 100 100.00% 6341 - PERSONNEL ADVERTISING - - 400 - 400 100.00% 6349 - OTHER ADVERTISING 179,052 180,066 159,930 93,772 159,930 70.55% 6351 - PRINTING 13,227 276 13,000 3,579 17,500 388.96% 6402 - EQUIPMENT SERVICES 108,302 67,656 87,300 22,939 97,300 324.17% 6403 - BLDGS/FACILITIES MAINT SERVICE 32,649 4,536 42,250 7,572 53,000 599.95% 6405 - PARK & LANDSCAPE SERVICES 850 - 3,000 - 3,000 100.00% 6406 - MULTI-FUNCTION MTNCE 8,455 6,843 8,100 4,669 8,100 73.48% 6408 - COMMUNICATION/INFO SYSTEMS - - - - - 0.00% 6409 - OTHER REPAIR & MAINT SVCS 1,199 436 1,330 327 1,400 328.13% 6413 - OFFICE EQUIPMENT - - 2,500 - 3,500 100.00% 6415 - OTHER EQUIPMENT 221,878 78,559 158,500 14,516 225,500 1453.46% 6421 - SOFTWARE LICENSE 51 414 - - - 0.00% 6422 - SOFTWARE MAINT 10,769 4,892 11,600 1,515 11,600 665.68% 6423 - LOGIS CHARGES 22,404 20,595 26,000 17,730 26,000 46.64% 6428 - PROTECTION SERVICES 14,350 1,863 13,300 4,331 19,000 338.70% 6432 - CONFERENCES AND SCHOOLS 6,100 - 15,900 - 17,100 100.00% 6433 - MEETING EXPENSES 1,020 - 1,000 - 1,400 100.00% 6434 - DUES & SUBSCRIPTIONS 2,228 2,105 3,700 1,647 3,700 124.65% 6435 - CREDIT CARD FEES 48,446 23,008 35,000 6,704 15,000 123.75% 6436 - UNCOLLECTIBLE CHECKS/DEBTS 3,953 (7,498) - - - 0.00% 6438 - CASH SHORT (OVER)540 (76) - (10) - -100.00% 6441 - LICENSES, TAXES & FEES 8,111 8,078 6,900 4,656 6,400 37.46% 6443 - PRIZE AWARDS/EXPENSE REIMB - - - - - 0.00% 6449 - OTHER CONTRACTUAL SERVICE 39,424 67,096 295,800 48,482 60,000 23.76% 6451 - MTG PLANNER POINTS-EBHC - - 3,000 - 3,000 100.00% TOTAL SERVICES & OTHER CHARGES 776,523 499,963 943,810 256,961 789,530 207.26% 6361 - GENERAL LIABILITY INSURANCE 6,415 8,477 5,502 3,079 4,774 55.05% 6362 - PROPERTY INSURANCE 26,650 29,475 29,824 19,929 31,095 56.03% 6366 - MACHINERY BREAKDOWN INSURANCE 2,554 3,999 2,844 3,039 4,770 56.96% TOTAL INSURANCE 35,619 41,951 38,170 26,047 40,639 56.02% 6381 - ELECTRIC 127,486 102,953 127,500 84,918 153,500 80.76% 6382 - GAS 38,612 31,764 47,500 25,747 47,500 84.49% 6383 - WATER 4,496 3,897 7,700 4,953 7,700 55.46% 6384 - REFUSE DISPOSAL 10,239 4,484 10,000 2,330 10,000 329.18% 6385 - SEWER 5,093 4,888 6,600 4,901 6,600 34.67% 6386 - STORM SEWER 3,232 3,881 5,100 3,422 5,100 49.04% 6389 - STREET LIGHTS 936 1,300 1,200 902 1,200 33.04% TOTAL UTILITIES 190,094 153,167 205,600 127,173 231,600 82.11% 6540 - EQUIPMENT & MACHINERY - - - - - 0.00% TOTAL CAPITAL OUTLAY - - - - - 0.00% 6494 - DEPRECIATION EXPENSE 225,883 258,709 252,500 170,298 252,400 48.21% TOTAL DEPRECIATION 225,883 258,709 252,500 170,298 252,400 48.21% TOTAL OPERATING EXPENSES 2,714,907 2,085,032 2,866,828 1,244,790 3,095,109 148.65% OPERATING INCOME (LOSS)(33,981) (1,606,419) (333,736) (953,331) (249,852) -73.79% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 32,862 11,531 13,900 1,045 5,100 388.04% 4604 - CHECK PROCESSING FEES - - - 30 - -100.00% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 12,438 - - - - 0.00% TOTAL INVESTMENT EARNINGS 45,300 11,531 13,900 1,075 5,100 374.42% 4320 - FEDERAL GRANTS - 335,720 - - - 0.00% 4359 - OTHER STATE GRANTS - - - 300,000 - -100.00% 4606 - OTHER REVENUE 499 10 - 7,500 - -100.00% 4912 - CAPITAL CONTRIBUTIONS 293,809 43,919 - - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS 1,882 4,658 - - - 0.00% TOTAL MISCELLANEOUS 296,190 384,307 - 307,500 - -100.00% TOTAL NONOPERATING REVENUES 341,490 395,838 13,900 308,575 5,100 -98.35% NONOPERATING EXPENSES 6471 - ADMINISTRATIVE SERVICE TRANSFER 99,561 99,561 125,096 93,822 125,353 33.61% 6476 - CAPITAL PROJECT FUND TRANSFER 350,000 50,000 - - - 0.00% TOTAL TRANSFERS 449,561 149,561 125,096 93,822 125,353 33.61% NET CHANGE IN FUND BALANCE (142,052)$ (1,360,142)$ (444,932)$ (738,578)$ (370,105)$ -49.89% EBHC 2021 Budget Presentation Cordell Wiseman, CARS Director Bruce Ballanger, General Manager The Heritage Center Mission: m •To deliver a high quality customer experience by providing exceptional customer service and extraordinary food service in an uncommon setting. Division Description The Heritage Center is comprised of four divisions: Convention Center Administrative Services Catering Services Commercial Office Rentals These Divisions provide for the delivery of maintenance, conference services, custodial functions, equipment servicing, development of menus, preparing and serving of food and beverage for events at the Heritage Center. Maintenance is also provided for buildings and grounds for the commercial office buildings located at the Heritage Center for 3 tenants. A management agreement with Flik International for the food and beverage portion of the operation has been renewed and is in place through the year 2026. Staffing Levels Positions 2021 2022 2023 General Manager 1 1 1 Secretary/Receptionist 1 1 1 Billing Clerk 1 1 1 Operations Director 1 1 1 Sales Director 1 1 1 Sales Managers 4 4 4 Catering Sales Managers 2 2 2 Maintenance Custodians 3 3 3 Crew Chiefs 2 2 2 Part-time FTE’s 9 9 9 TOTALS 25 25 25 Key Initiatives •Customer Intimacy Deliver a High Quality of Service •Our goal is to improve the current level of 90% repeat corporate clients, by reviewing feedback from event evaluations and growing our 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 2022, the Heritage Center will celebrate 32 years of operation as one of the region’s premier conference and events facility, and as a centerpiece of the Brooklyn Center community. Through our 2022 marketing efforts, we will continually highlight the Heritage Center and Brooklyn Center. Key Initiatives •Inclusive Community Engagement Host a City Sponsored Event for the Community •The Heritage Center will work with stakeholders, general public, and local business to host a community experience in 2023 or 2024 when funding becomes available. •Financial Stability Capital Funds Transfer •In 2022, we are working on pre-COVID revenue goals to 5.1 million. By doing so, our objective is to increase the yearly transfer of funds to the Capital Improvements Fund from $150,000 to $200,000. Annual Goals •Promote and sell the facility in accordance to the 2022 Marketing Plan: Participate in three industry associations to network for business. Add a minimum of 20 new corporate clients. Work with Flik International, Embassy Suites, Fairfield Inn and other area hotels on bookings of events. •Deliver a high quality customer experience: Build interpersonal relationships with clients to generate higher customer satisfaction, commitment and loyalty. Client requests and changes will be responded to quickly. Showcase food & beverage services each day based upon client requests and current market trends. •Be responsible to our environment by reducing our resource use and food waste: Reduce electrical consumption by upgrading light fixtures. Be part of the Trim Trax program on food waste reduction. Annual Operating Goal Performance Measures Performance Objectives Description of Performance Measure Performance Levels *Actual Value Target Value Increase Revenue 1,700,803 5,149,663 Control Expenses (Percentage of Cost to Revenue) 105.64%/115.55%41.90%/67.00% Customer Satisfaction Rating 96%100% New Corporate Clients 3 20 Increase Misc. Catering Sales (Décor/Centerpieces) $4,547 $27,000 * 2020 Data Capital Outlay Planned Capital Outlay Requests Planned budget transfer of $0 2021 Projects: Adjusted to 2022 –2024 2021 Projects To Be Completed: None 2022 Projects: Carriage Hall Roof and Camera Security System Server Budget Highlights 2021 COVID vaccine clinic for the State of MN, Hennepin County, & Community Groups October and November return to pre-COVID rentals Received a Minnesota Convention Center Relief Grant from MN DEED for $300,000 2022 Administration Budget: Moved name change to ARP funding request Building and Facilities Maintenance Inn flat roof, small man-lift, and coffee machine Resident Recognition: Corporate & Wedding discount for Brooklyn Center business and couples Questions? 2022 Brooklyn Center Department Budget Narrative Department Name: 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. Key Initiatives focused on the achievement of strategic priorities/value propositions Inclusive Community Engagement • General Community Outreach In 2022 we will continue the operation of the new water treatment plant. The current pandemic precludes community participation, outreach and education. Infrastructure – Key Investments • Critical Infrastructure Improvements In 2022 we will implement the 29th 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 2022 a financial strategy that uses a combination of General Obligation Improvement Bonds, Utility Revenue Bonds, and Utility Fund rate adjustments will be used to fund capital projects. Staffing Levels Positions FTEs 2021 2022 2023 • 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, 3-49411) 9 9 9 • Part Time/Summer Temporary Employees (3- 49141, 2-49251, 1-49411) 2.0 2.0 2.0 TOTAL 13.0 13.0 13.0 Strategic Functions/Division(s): • Water Utility (49141) 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 2,050 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 (49251) 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. The City has approximately 105 miles of sanitary 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 88 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, 145 ornamental lights on Brooklyn Boulevard, 40 ornamental lights along Xerxes Avenue, 72 ornamental lights along Bass Lake Rd and 57th Avenue and leases approximately 920 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 and the city’s traffic signals. 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. 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 Billable engineering project staff time and overtime (Grandview North and Interstate projects) 80% >60% Miles of annual street sweeping performed 1459.1 miles (4 Citywide, 10 targeted) >990 miles (4 Citywide rounds, 10 rounds of targeted secondary areas) Miles of annual sanitary sewer televised, cleaned, root-sawed, lined and new pipe 26 >= 19.6 miles (1/5 of the City’s total 97.9 miles) Private sanitary sewer backups per year (due to City system blockage) 0 0 Drinking Water Regulated Substances: Copper Lead Barium Trihalomethanes Haloacetic Acids Total Chlorine Flouride No violation No violation No violation No violation No violation No violation No violation No violations *2020 data Capital Outlay and Other Initiatives with Significant Budget Impact  2022 Capital Improvement Projects – See CIP section of Budget  2022 Storm Sewer Utility – Plow for Storm Pickup ($10,300)  2022 PW Facility Needs Assessment ($50,000)  2022 Used Forklift {($12,000 total) $4000 Storm; $4000 Sanitary; $4000 Water} 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49141 - WATER UTILITY-OPERATIONS OPERATING REVENUES 4701 - WATER SALES 3,228,802$ 3,727,823$ 2,953,442$ 4,193,482$ 4,266,500$ 1.74% 4702 - FIRE LINES 9,233 9,236 6,952 9,000 10,000 11.11% 4703 - WATER METER SALES (26,493) (11,197) (15,594) (10,000) (10,000) 0.00% 4704 - WATER METER RENTALS 13,741 7,400 4,250 3,000 5,000 66.67% 4705 - SERVICE RESTORATION FEES 2,225 1,043 - 3,000 1,000 -66.67% 4706 - CONNECTION CHARGES - 48,000 1,500 9,000 10,000 11.11% 4707 - PENALTIES 119,821 - - - - 0.00% 4708 - TOWER RENTAL FEES 387,506 391,678 (110,153) 256,000 400,000 56.25% 4709 - CERTIFICATION CHARGES 26,160 32,300 35,150 50,000 40,000 -20.00% TOTAL SALES AND USER FEES 3,760,995 4,206,283 2,875,547 4,513,482 4,722,500 4.63% TOTAL OPERATING REVENUES 3,760,995 4,206,283 2,875,547 4,513,482 4,722,500 4.63% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 364,035 383,130 287,139 392,733 400,036 1.86% 6102 - OVERTIME-FT EMPLOYEES 51,171 45,066 35,559 48,000 48,000 0.00% 6103 - WAGES-PART TIME EMPLOYEES 21,223 18,204 33,961 35,000 35,000 0.00% 6104 - OVERTIME - PT EMPLOYEES 29 - - - - 0.00% 6111 - SEVERANCE PAY 4,334 7,331 - - - 0.00% 6122 - PERA COORDINATED PLAN 31,140 32,115 24,202 34,780 35,329 1.58% 6125 - FICA - SOCIAL SECURITY 26,415 26,665 21,408 28,751 29,205 1.58% 6126 - FICA - MEDICARE 6,178 6,312 5,007 6,724 6,830 1.58% 6131 - CAFETERIA PLAN CONTRIBUTIONS 71,880 75,660 62,700 83,931 88,150 5.03% 6151 - WORKER'S COMP INSURANCE 12,207 15,840 11,078 18,583 19,727 6.16% TOTAL PERSONAL SERVICES 588,612 610,323 481,054 648,502 662,277 2.12% 6201 - OFFICE SUPPLIES 2,048 1,790 171 1,800 1,800 0.00% 6203 - BOOKS/REFERENCE MATERIALS - 90 - 500 500 0.00% 6204 - STATIONARY SUPPLIES - - - 1,610 - -100.00% 6212 - MOTOR FUELS 2,382 2,763 3,561 5,000 5,000 0.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 55 - - 400 400 0.00% 6216 - CHEMICALS/CHEMICAL PRODUCTS 123,353 162,955 143,029 160,000 160,000 0.00% 6217 - SAFETY SUPPLIES 1,477 1,855 6,610 7,500 4,500 -40.00% 6219 - GENERAL OPERATING SUPPLIES 32,881 15,960 18,521 12,600 16,000 26.98% 6223 - BUILDINGS & FACILITIES 782 45,474 933 1,500 11,500 666.67% 6224 - STREET MAINT MATERIALS 5,502 4,615 6,266 10,000 10,000 0.00% 6225 - PARK & LANDSCAPE MATERIALS - 634 60 1,500 1,500 0.00% 6227 - PAINT SUPPLIES 891 1,642 2,492 2,500 3,500 40.00% 6235 - UTILITY SYSTEM SUPPLIES 89,355 41,816 19,369 70,000 70,000 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 22,058 27,767 26,653 40,000 40,000 0.00% 6241 - SMALL TOOLS 1,118 1,415 1,489 5,000 5,000 0.00% 6242 - MINOR EQUIPMENT 5,612 2,786 4,933 17,600 57,600 227.27% 6243 - MINOR COMPUTER EQUIPMENT 26,586 5,233 210 28,000 3,500 -87.50% TOTAL SUPPLIES 314,100 316,795 234,297 365,510 390,800 6.92% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 2,509 3,000 3,000 0.00% 6302 - ARCH, ENG & PLANNING 21,456 6,900 4,246 85,500 85,500 0.00% 6307 - PROFESSIONAL SERVICES 84,119 178,875 64,962 100,000 60,000 -40.00% 6321 - TELEPHONE/PAGERS 4,795 3,659 1,651 4,100 4,100 0.00% 6322 - POSTAGE 2,646 84 - 6,500 - -100.00% 6329 - OTHER COMMUNICATION SERVICES 4,248 6,209 4,109 5,000 5,000 0.00% 6331 - TRAVEL EXPENSE/MILEAGE - - - 200 200 0.00% 6333 - FREIGHT/DRAYAGE 212 - - 50 50 0.00% 6341 - PERSONNEL ADVERTISING - - - 160 160 0.00% 6342 - LEGAL NOTICES - - - 100 100 0.00% 6351 - PRINTING 133 105 52 500 500 0.00% 6402 - EQUIPMENT SERVICES 3,021 1,562 - 5,000 5,000 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE 5,627 7,966 6,415 12,400 7,500 -39.52% 6406 - MULTI-FUNCTION MTNCE 105 151 88 250 250 0.00% 6409 - OTHER REPAIR & MAINT SVCS 22,458 42,602 5,149 24,200 26,200 8.26% 6417 - UNIFORMS 1,593 2,690 1,586 2,000 2,000 0.00% 6421 - SOFTWARE LICENSE 12,900 229 - - - 0.00% 6422 - SOFTWARE MAINT 2,356 - - 1,200 - -100.00% 6423 - LOGIS CHARGES 48,416 53,094 36,182 60,000 60,000 0.00% 6432 - CONFERENCES AND SCHOOLS 3,251 3,410 4,827 8,000 8,000 0.00% 6434 - DUES & SUBSCRIPTIONS 3,078 5,909 1,137 4,000 4,000 0.00% 6435 - CREDIT CARD FEES - - - 200 37,000 18400.00% 6436 - UNCOLLECTIBLE CHECKS/DEBTS 317 - - - - 0.00% 6438 - CASH SHORT (OVER)(1) 1,215 - - - 0.00% 6405 - PARK & LANDSCAPE SERVICES - 2,256 4,367 10,000 10,000 0.00% 6441 - LICENSES, TAXES & FEES 69,941 98,993 78,457 86,500 110,000 27.17% 6443 - PRIZE AWARDS/EXP REIMB - 779 350 - 500 100.00% 6449 - OTHER CONTRACTUAL SERVICE 200,907 207,156 109,259 150,000 150,000 0.00% TOTAL SERVICES & OTHER CHARGES 494,314 626,399 325,346 568,860 579,060 1.79% WATER UTILITY FUND - 60100 PUBLIC UTILITY FUND 6361 - GENERAL LIABILITY INSURANCE 33,873 36,139 25,834 37,345 36,168 -3.15% 6362 - PROPERTY INSURANCE 6,215 8,063 12,217 18,102 17,104 -5.51% 6366 - MACHINERY BREAKDOWN INSURANCE 1,236 1,233 2,034 1,363 2,850 109.10% TOTAL INSURANCE 41,324 45,435 40,085 56,810 56,122 -1.21% 6381 - ELECTRIC 153,039 180,141 157,869 190,000 190,000 0.00% 6382 - GAS 18,866 16,043 20,069 22,600 22,600 0.00% 6383 - WATER 13,950 6,329 11,045 7,000 7,000 0.00% 6385 - SEWER 13,637 4,815 6,561 6,000 6,000 0.00% 6386 - STORM SEWER 9,064 9,336 7,213 8,700 8,700 0.00% 6388 - HAZARDOUS WASTE DISPOSAL - - - - - 0.00% 6389 - STREET LIGHTS 2,624 2,624 1,968 2,600 2,600 0.00% TOTAL UTILITIES 211,180 219,288 204,725 236,900 236,900 0.00% 6461 - FUEL CHARGES 3,425 4,011 2,749 4,100 4,500 9.76% 6462 - FIXED CHARGES 6,921 5,902 9,773 15,008 10,307 -31.32% 6463 - REPAIR & MAINT CHARGES 5,530 15,035 4,177 10,300 10,600 2.91% 6465 - REPLACEMENT CHARGES 22,450 22,450 16,378 24,567 32,267 31.34% TOTAL CENTRAL GARAGE CHARGES 38,326 47,398 33,077 53,975 57,674 6.85% 6494 - DEPRECIATION EXPENSE 1,664,921 1,800,118 1,203,386 1,800,000 - -100.00% TOTAL DEPRECIATION 1,664,921 1,800,118 1,203,386 1,800,000 - -100.00% TOTAL OPERATING EXPENSES 3,352,777 3,665,756 2,521,970 3,730,557 1,982,833 -46.85% OPERATING INCOME 408,218 540,527 353,577 782,925 2,739,667 249.93% NONOPERATING REVENUES 4601 - SPECIAL ASSESSMENTS 45,432 47,046 (233,562) - - 0.00% 4607 - SPEC ASSESS INTEREST 7 - 989 - - 0.00% TOTAL SPECIAL ASSESSMENTS 45,439 47,046 (232,573) - - 0.00% 4603 - INTEREST EARNINGS 76,748 51,801 21,126 32,600 23,600 -27.61% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 47,479 35,329 - - - 0.00% TOTAL INVESTMENT EARNINGS 124,227 87,130 21,126 32,600 23,600 -27.61% 4320 - FEDERAL GRANTS - 18,862 375 - - 0.00% 4604 - CHECK PROCESSING FEES 1,740 1,350 960 - - 0.00% 4606 - OTHER REVENUE 11,573 384 - - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS - 6,392 1,840 - - 0.00% TOTAL MISCELLANEOUS 13,313 26,988 3,175 - - 0.00% 4931 - BOND SALES - - 1,915,659 2,600,000 3,800,000 46.15% 4932 - PREMIUM ON BOND SALES - - - - - 0.00% TOTAL DEBT ISSUANCE - - 1,915,659 2,600,000 3,800,000 46.15% TOTAL NONOPERATING REVENUES 182,979 161,164 1,707,387 2,632,600 3,823,600 45.24% NONOPERATING EXPENSES 6530 - IMPROVEMENTS 243,407 152,258 106,836 3,189,000 4,539,724 42.36% 6540 - EQUIPMENT & MACHINERY - - - 100,000 8,000 -92.00% TOTAL CAPITAL OUTLAY 243,407 152,258 106,836 3,289,000 4,547,724 38.27% 6601 - BOND PRINCIPAL - - 848,750 1,840,750 2,073,250 12.63% 6611 - BOND INTEREST 435,922 462,204 456,806 436,444 472,605 8.29% 6621 - PAYING AGENT/OTHER FEES (4,080) (20,752) 3,437 3,000 3,000 0.00% TOTAL DEBT SERVICE 431,842 441,452 1,308,993 2,280,194 2,548,855 11.78% 6471 - ADMINISTRATIVE SERVICE TRANSFER 105,996 105,996 137,772 183,696 184,625 0.51% TOTAL TRANSFERS 105,996 105,996 137,772 183,696 184,625 0.51% TOTAL NONOPERATING EXPENSES 781,245 699,706 1,553,601 5,752,890 7,281,204 26.57% NET CHANGE IN FUND BALANCE (190,048)$ 1,985$ 507,363$ (2,337,365)$ (717,937)$ -69.28% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49251 - SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707 - PENALTIES 69,853$ -$ -$ -$ -$ 0.00% 4721 - SEWER SERVICE 4,486,810 4,662,342 3,499,960 4,899,185 5,140,000 4.92% TOTAL SALES AND USER FEES 4,556,663 4,662,342 3,499,960 4,899,185 5,140,000 4.92% TOTAL OPERATING REVENUES 4,556,663 4,662,342 3,499,960 4,899,185 5,140,000 4.92% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 132,426 151,647 109,153 155,236 157,260 1.30% 6102 - OVERTIME-FT EMPLOYEES 19,400 18,246 15,996 18,000 18,000 0.00% 6103 - WAGES-PART TIME EMPLOYEES 18,829 31,198 3,773 25,000 25,000 0.00% 6111 - SEVERANCE PAY 1,382 2,455 1,669 - - 0.00% 6122 - PERA COORDINATED PLAN 11,387 12,742 9,386 14,231 14,383 1.07% 6125 - FICA - SOCIAL SECURITY 10,871 12,935 8,434 11,763 11,889 1.07% 6126 - FICA - MEDICARE 2,542 3,042 1,973 2,751 2,781 1.09% 6131 - CAFETERIA PLAN CONTRIBUTIONS 19,592 30,264 23,760 36,423 38,254 5.03% 6141 - UNEMPLOYMENT COMPENSATION 324 - - - - 0.00% 6151 - WORKER'S COMP INSURANCE 5,597 7,805 4,709 8,315 8,766 5.42% TOTAL PERSONAL SERVICES 222,350 270,334 178,853 271,719 276,333 1.70% 6201 - OFFICE SUPPLIES 100 32 - 100 100 0.00% 6203 - BOOKS/REFERENCE MATERIALS - - - 200 200 0.00% 6204 - STATIONARY SUPPLIES - - - 3,000 - -100.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 150 75 - 300 300 0.00% 6216 - CHEMICALS/CHEMICAL PRODUCTS 7,873 7,791 6,841 11,500 11,500 0.00% 6217 - SAFETY SUPPLIES 3,013 2,993 11,972 13,000 12,000 -7.69% 6219 - GENERAL OPERATING SUPPLIES 2,187 2,772 459 3,500 3,500 0.00% 6223 - BUILDINGS & FACILITIES 151 25 - 10,100 30,000 197.03% 6224 - STREET MAINT MATERIALS - 2,557 169 7,500 7,500 0.00% 6227 - PAINT SUPPLIES 778 607 300 675 675 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 2,844 3,817 2,695 5,000 5,000 0.00% 6241 - SMALL TOOLS 154 707 285 1,000 1,000 0.00% 6242 - MINOR EQUIPMENT 843 420 925 2,600 2,600 0.00% 6243 - MINOR COMPUTER EQUIPMENT 760 4,262 70 25,000 3,500 -86.00% TOTAL SUPPLIES 18,853 26,058 23,716 83,475 77,875 -6.71% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 2,509 3,000 3,000 0.00% 6302 - ARCH, ENG & PLANNING 29,625 - - 1,900 1,900 0.00% 6307 - PROFESSIONAL SERVICES 17,744 29,842 6,494 4,820 4,820 0.00% 6321 - TELEPHONE/PAGERS 3,135 2,189 221 3,100 3,100 0.00% 6322 - POSTAGE 5,654 - - 12,700 - -100.00% 6351 - PRINTING - - - 375 375 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE 3,461 3,611 3,765 7,000 7,000 0.00% 6409 - OTHER REPAIR & MAINT SVCS 75,803 65,902 48,118 100,000 100,000 0.00% 6417 - UNIFORMS 700 680 - 1,000 1,000 0.00% 6421 - SOFTWARE LICENSE - 160 - - - 0.00% 6423 - LOGIS CHARGES 38,022 43,843 30,857 45,000 45,000 0.00% 6432 - CONFERENCES AND SCHOOLS 3,252 2,060 478 4,000 4,000 0.00% 6434 - DUES & SUBSCRIPTIONS 410 264 263 425 425 0.00% 6441 - LICENSES, TAXES & FEES - 123 - 300 300 0.00% 6449 - OTHER CONTRACTUAL SERVICE 22,532 42,891 12,989 25,000 25,000 0.00% TOTAL SERVICES & OTHER CHARGES 203,074 194,120 105,694 208,620 195,920 -6.09% 6361 - GENERAL LIABILITY INSURANCE 21,589 19,431 15,365 23,802 21,511 -9.63% 6362 - PROPERTY INSURANCE 1,098 1,426 1,093 1,211 1,530 26.34% 6366 - MACHINERY BREAKDOWN INSURANCE 259 258 198 358 280 -21.79% TOTAL INSURANCE 22,946 21,115 16,656 25,371 23,321 -8.08% 6381 - ELECTRIC 37,066 36,689 25,350 39,100 39,100 0.00% 6391 - MET COUNCIL ENVIRON SVCS 2,576,325 2,653,796 2,063,330 2,552,680 2,646,952 3.69% TOTAL UTILITIES 2,613,391 2,690,485 2,088,680 2,591,780 2,686,052 3.64% 6461 - FUEL CHARGES 11,316 9,929 8,386 13,700 12,700 -7.30% 6462 - FIXED CHARGES 9,287 9,039 14,291 20,021 17,439 -12.90% 6463 - REPAIR & MAINT CHARGES 12,876 10,383 5,269 15,300 15,800 3.27% 6465 - REPLACEMENT CHARGES 58,005 58,005 42,695 64,042 111,841 74.64% TOTAL CENTRAL GARAGE CHARGES 91,484 87,356 70,641 113,063 157,780 39.55% 6494 - DEPRECIATION EXPENSE 991,951 977,861 604,222 1,000,000 1,000,000 0.00% TOTAL DEPRECIATION 991,951 977,861 604,222 1,000,000 1,000,000 0.00% TOTAL OPERATING EXPENSES 4,164,049 4,267,329 3,088,462 4,294,028 4,417,281 2.87% OPERATING INCOME 392,614 395,013 411,498 605,157 722,719 19.43% SEWER UTILITY FUND - 60200 PUBLIC UTILITY FUND NONOPERATING REVENUES 4320 - FEDERAL GRANTS - 8,271 - - - 0.00% 4373 - OTHER GRANTS/AID 455,363 - - - - 0.00% TOTAL INTERGOVERNMENTAL 455,363 8,271 - - - 0.00% 4603 - INTEREST EARNINGS 100,703 100,246 38,601 42,600 47,000 10.33% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 67,716 52,609 - - - 0.00% TOTAL INVESTMENT EARNINGS 168,419 152,855 38,601 42,600 47,000 10.33% 4601 - SPECIAL ASSESSMENTS - 422 - - - 0.00% 4726 - CONNECTION CHARGES (723) - - - - 0.00% 4921 - REFUNDS AND REIMBURSEMENTS - - 1,100 - - 0.00% TOTAL MISCELLANEOUS (723) 422 1,100 - - 0.00% 4931 - BOND SALES - - 1,411,516 1,400,000 1,600,000 14.29% 4932 - PREMIUM ON BOND SALES - - - - - 0.00% TOTAL DEBT ISSUANCE - - 1,411,516 1,400,000 1,600,000 14.29% TOTAL NONOPERATING REVENUES 623,059 161,548 1,451,217 1,442,600 1,647,000 14.17% NONOPERATING EXPENSES 6530 - IMPROVEMENTS 90,226 (195) 117,150 3,056,000 2,492,900 -18.43% TOTAL CAPITAL OUTLAY 90,226 (195) 117,150 3,056,000 2,492,900 -18.43% 6601 - BOND PRINCIPAL - - 577,233 577,233 721,473 24.99% 6611 - BOND INTEREST 179,177 164,501 166,218 153,518 189,126 23.19% 6621 - PAYING AGENT/OTHER FEES 2,365 8,317 2,532 1,500 3,000 100.00% TOTAL DEBT SERVICE 181,542 172,818 745,983 732,251 913,599 24.77% 6471 - ADMINISTRATIVE SERVICE TRANSFER 99,426 99,426 125,058 166,744 167,842 0.66% TOTAL TRANSFERS 99,426 99,426 125,058 166,744 167,842 0.66% TOTAL NONOPERATING EXPENSES 371,194 272,049 988,191 3,954,995 3,574,341 -9.62% NET CHANGE IN FUND BALANCE 644,479$ 284,512$ 874,524$ (1,907,238)$ (1,204,622)$ -36.84% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49411 - STORM SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707 - PENALTIES 17,055$ -$ -$ -$ -$ 0.00% 4731 - STORM DRAINAGE FEES 1,663,149 1,691,946 1,313,913 1,798,694 1,864,694 3.67% TOTAL SALES AND USER FEES 1,680,204 1,691,946 1,313,913 1,798,694 1,864,694 3.67% TOTAL OPERATING REVENUES 1,680,204 1,691,946 1,313,913 1,798,694 1,864,694 3.67% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 206,267 215,822 163,924 226,764 223,403 -1.48% 6102 - OVERTIME-FT EMPLOYEES 1,236 348 1,530 2,500 2,500 0.00% 6103 - WAGES-PART TIME EMPLOYEES 12,785 6,934 808 10,800 10,800 0.00% 6111 - SEVERANCE PAY 1,153 3,030 - - - 0.00% 6122 - PERA COORDINATED PLAN 15,563 16,213 12,409 18,006 17,754 -1.40% 6125 - FICA - SOCIAL SECURITY 13,771 13,735 10,381 14,885 14,676 -1.40% 6126 - FICA - MEDICARE 3,221 3,278 2,428 3,480 3,432 -1.38% 6131 - CAFETERIA PLAN CONTRIBUTIONS 40,732 45,396 37,620 53,842 56,549 5.03% 6141 - UNEMPLOYMENT INSURANCE 527 2,791 - - - 0.00% 6151 - WORKER'S COMP INSURANCE 14,236 16,567 11,680 19,224 21,463 11.65% TOTAL PERSONAL SERVICES 309,491 324,114 240,780 349,501 350,577 0.31% 6204 - STATIONARY SUPPLIES - - - 1,600 - -100.00% 6217 - SAFETY SUPPLIES - - 1,406 250 500 100.00% 6219 - GENERAL OPERATING SUPPLIES 215 525 48 5,500 6,000 9.09% 6224 - STREET MAINT MATERIALS 3,134 3,690 2,394 8,000 8,000 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 12,311 7,704 13,846 30,000 36,000 20.00% 6241 - SMALL TOOLS - - 2,359 250 1,500 500.00% 6243 - MINOR COMPUTER EQUIPMENT - 1,622 281 3,500 - -100.00% TOTAL SUPPLIES 15,660 13,541 20,334 49,100 52,000 5.91% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 2,509 3,000 3,000 0.00% 6302 - ARCH, ENG & PLANNING 68,353 11,151 814 20,000 20,000 0.00% 6307 - PROFESSIONAL SERVICES 1,298 5,271 1,828 2,000 2,000 0.00% 6322 - POSTAGE 2,767 - - 5,940 - -100.00% 6329 - OTHER COMMUNICATION SERVICES - - 29 - - 0.00% 6331 - TRAVEL EXPENSE/MILEAGE 81 - - 500 500 0.00% 6342 - LEGAL NOTICES 42 - - 150 150 0.00% 6351 - PRINTING - - - 1,500 1,500 0.00% 6384 - REFUSE DISPOSAL 3,090 2,800 1,843 3,800 5,000 31.58% 6409 - OTHER REPAIR & MAINT SVCS 29,729 17,544 19,879 31,000 36,000 16.13% 6417 - UNIFORMS 1,050 1,050 - 1,100 1,100 0.00% 6423 - LOGIS CHARGES 24,275 24,067 17,632 24,000 24,000 0.00% 6432 - CONFERENCES AND SCHOOLS 295 - 390 700 700 0.00% 6434 - DUES & SUBSCRIPTIONS 58,244 62,266 60,899 61,565 63,400 2.98% 6449 - OTHER CONTRACTUAL SERVICE 7,564 4,530 12,197 13,000 13,000 0.00% TOTAL SERVICES & OTHER CHARGES 199,524 131,234 118,020 168,255 170,350 1.25% 6361 - GENERAL LIABILITY INSURANCE 3,108 2,759 2,156 3,427 3,018 -11.93% TOTAL INSURANCE 3,108 2,759 2,156 3,427 3,018 -11.93% 6461 - FUEL CHARGES 8,262 8,209 7,565 8,300 9,900 19.28% 6462 - FIXED CHARGES 4,673 4,763 4,833 7,363 5,492 -25.41% 6463 - REPAIR & MAINT CHARGES 19,653 29,649 13,454 17,800 18,300 2.81% 6465 - REPLACEMENT CHARGES 56,900 51,475 34,020 51,030 59,234 16.08% TOTAL CENTRAL GARAGE CHARGES 89,488 94,096 59,872 84,493 92,926 9.98% 6494 - DEPRECIATION EXPENSE 1,437,108 1,431,750 892,230 1,450,000 1,450,000 0.00% TOTAL DEPRECIATION 1,437,108 1,431,750 892,230 1,450,000 1,450,000 0.00% TOTAL OPERATING EXPENSES 2,054,379 1,997,494 1,333,392 2,104,776 2,118,871 0.67% OPERATING INCOME (LOSS)(374,175) (305,548) (19,479) (306,082) (254,177) -16.96% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 118,079 93,458 36,037 49,800 43,200 -13.25% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 66,934 44,656 - - - 0.00% TOTAL INVESTMENT EARNINGS 185,013 138,114 36,037 49,800 43,200 -13.25% 4320 - FEDERAL GRANTS - 24,896 - - - 0.00% 4373 - OTHER GRANTS/AID - - 50,000 305,000 - -100.00% 4612 - DONATIONS & CONTRIBUTIONS 250 - - - - 0.00% 4912 - CAPITAL CONTRIBUTIONS 560,675 391,952 - - - 0.00% TOTAL MISCELLANEOUS 560,925 416,848 50,000 305,000 - -100.00% 4931 - BOND SALES - - 2,215,107 2,400,000 940,000 -60.83% 4932 - PREMIUM ON BOND SALES - - - - - 0.00% TOTAL DEBT ISSUANCE - - 2,215,107 2,400,000 940,000 -60.83% TOTAL NONOPERATING REVENUES 745,938 554,962 2,301,144 2,754,800 983,200 -64.31% STORM SEWER UTILITY FUND - 65100 PUBLIC UTILITY FUND NONOPERATING EXPENSES 6540 - EQUIPMENT & MACHINERY - 27,645 - 75,000 14,400 -80.80% 6530 - IMPROVEMENTS 197,571 179,751 6,181 4,876,000 1,831,207 -62.44% TOTAL CAPITAL OUTLAY 197,571 207,396 6,181 4,951,000 1,845,607 -62.72% 6601 - BOND PRINCIPAL - - 315,000 315,000 355,000 12.70% 6611 - BOND INTEREST 33,826 135,514 128,525 128,525 170,470 32.64% 6621 - BOND ISSUE COSTS 8,415 (16,485) 3,974 1,500 1,500 0.00% TOTAL DEBT SERVICE 42,241 119,029 447,499 445,025 526,970 18.41% 6471 - ADMINISTRATIVE SERVICE TRANSFER 99,426 99,426 126,697 168,929 169,125 0.12% TOTAL TRANSFERS 99,426 99,426 126,697 168,929 169,125 0.12% TOTAL NONOPERATING EXPENSES 339,238 425,851 580,377 5,564,954 2,541,702 -54.33% NET CHANGE IN FUND BALANCE 32,525$ (176,437)$ 1,701,288$ (3,116,236)$ (1,812,679)$ -41.83% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49571 - STREET LIGHT-OPERATIONS OPERATING REVENUES 4707 - PENALTIES 5,753$ -$ -$ -$ -$ 0.00% 4741 - STREET LIGHT SERVICE CHARGE 451,218 449,286 339,591 461,400 460,000 -0.30% TOTAL SALES AND USER FEES 456,971 449,286 339,591 461,400 460,000 -0.30% TOTAL OPERATING REVENUES 456,971 449,286 339,591 461,400 460,000 -0.30% OPERATING EXPENSES 6204 - STATIONARY SUPPLIES - - - 280 - -100.00% 6243 - MINOR COMPUTER EQUIPMENT - 405 10 - - 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 4,138 76 - 7,750 13,750 77.42% TOTAL SUPPLIES 4,138 481 10 8,030 13,750 71.23% 6307 - PROFESSIONAL SERVICES 49 32 23 200 200 0.00% 6322 - POSTAGE 481 - - 1,080 - -100.00% 6351 - PRINTING - - - 100 100 0.00% 6409 - OTHER REPAIR & MAINT SVCS 16,327 20,482 33,106 16,000 20,000 25.00% 6423 - LOGIS CHARGES 6,083 5,452 4,406 6,000 6,000 0.00% 6449 - OTHER CONTRACTUAL SERVICE 381 788 461 300 300 0.00% TOTAL SERVICES & OTHER CHARGES 23,321 26,754 37,996 23,680 26,600 12.33% 6361 - GENERAL LIABILITY INSURANCE 1,640 1,132 664 1,808 930 -48.56% TOTAL INSURANCE 1,640 1,132 664 1,808 930 -48.56% 6381 - ELECTRIC 180,180 182,385 137,023 204,000 200,000 -1.96% TOTAL UTILITIES 180,180 182,385 137,023 204,000 200,000 -1.96% 6494 - DEPRECIATION EXPENSE 69,008 70,101 46,542 80,000 80,000 0.00% TOTAL DEPRECIATION 69,008 70,101 46,542 80,000 80,000 0.00% TOTAL OPERATING EXPENSES 278,287 280,853 222,235 317,518 321,280 1.18% OPERATING INCOME (LOSS)178,684 168,433 117,356 143,882 138,720 -3.59% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 20,219 16,892 10,561 8,500 8,200 -3.53% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 9,917 8,696 - - - 0.00% TOTAL INVESTMENT EARNINGS 30,136 25,588 10,561 8,500 8,200 -3.53% 4912 - CAPITAL CONTRIBUTIONS 456,059 - - - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS 9,886 27,480 36,485 - - 0.00% TOTAL MISCELLANEOUS 465,945 27,480 36,485 - - 0.00% TOTAL NONOPERATING REVENUES 496,081 53,068 47,046 8,500 8,200 -3.53% NONOPERATING EXPENSES 6530 - IMPROVEMENTS 29,691 - - 971,000 571,662 -41.13% TOTAL CAPITAL OUTLAY 29,691 - - 971,000 571,662 -41.13% 6471 - ADMINISTRATIVE SERVICE TRANSFER 25,766 25,766 35,948 47,930 48,051 0.25% TOTAL TRANSFERS 25,766 25,766 35,948 47,930 48,051 0.25% TOTAL NONOPERATING EXPENSES 55,457 25,766 35,948 1,018,930 619,713 -39.18% NET CHANGE IN FUND BALANCE 619,308$ 195,735$ 128,454$ (866,548)$ (472,793)$ -45.44% STREET LIGHT UTILITY FUND - 65200 PUBLIC UTILITY FUND 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49311 - RECYCLING OPERATING REVENUES 4707 - PENALTIES 9,025$ 234$ -$ -$ -$ 0.00% 4751 - RECYCLING SERVICE FEES 395,956 394,261 296,307 395,715 400,000 1.08% TOTAL SALES AND USER FEES 404,981 394,495 296,307 395,715 400,000 1.08% TOTAL OPERATING REVENUES 404,981 394,495 296,307 395,715 400,000 1.08% OPERATING EXPENSES 6204 - STATIONARY SUPPLIES - - - 150 - -100.00% 6225 - PARK & LANDSCAPE MATERIALS 19,550 - - - - 0.00% 6243 - MINOR COMPUTER EQUIPMENT - 405 10 - - 0.00% TOTAL SUPPLIES 19,550 405 10 150 - -100.00% 6307 - PROFESSIONAL SERVICES 43 52 36 100 - -100.00% 6322 - POSTAGE 481 - - 1,200 - -100.00% 6423 - LOGIS CHARGES 10,805 5,452 4,406 6,000 6,000 0.00% 6449 - OTHER CONTRACTUAL SERVICE 367,125 377,444 282,953 381,612 400,000 4.82% TOTAL SERVICES & OTHER CHARGES 378,454 382,948 287,395 388,912 406,000 4.39% 6361 - GENERAL LIABILITY INSURANCE 1,437 1,880 1,053 1,584 1,404 -11.36% TOTAL INSURANCE 1,437 1,880 1,053 1,584 1,404 -11.36% TOTAL OPERATING EXPENSES 399,441 385,233 288,458 390,646 407,404 4.29% OPERATING INCOME (LOSS)5,540 9,262 7,849 5,069 (7,404) -246.06% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 4,596 3,309 1,867 1,900 1,600 -15.79% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 1,948 1,500 - - - 0.00% TOTAL INVESTMENT EARNINGS 6,544 4,809 1,867 1,900 1,600 -15.79% NONOPERATING EXPENSES 6471 - ADMINISTRATIVE SERVICE TRANSFER 11,169 11,169 13,373 17,831 18,211 2.13% TOTAL TRANSFERS 11,169 11,169 13,373 17,831 18,211 2.13% NET CHANGE IN FUND BALANCE 915$ 2,902$ (3,657)$ (10,862)$ (24,015)$ 121.09% RECYCLING UTILITY FUND - 65300 PUBLIC UTILITY FUND City of Brooklyn Center Water Utility Cash Flows Revised: 10-6-21 Prior Projected Change 9.00%9.00%9.00%9.00%5.00%3.00%3.00%2.00%0.00%0.00%-2.00%-3.00%-5.00%-5.00%-5.00%-5.00% Rate Change - Proposed 7.00%5.00%9.00%9.00%9.00%7.00%7.00%7.00%2.00%2.00%0.00%0.00%0.00%0.00%0.00%0.00% Average Residential Fee (18,000 Gallons / Per Qtr.)66.47$ 69.82$ 76.07$ 83.00$ 90.44$ 96.70$ 103.43$ 110.64$ 112.81$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ Per Quarter Change 4.33$ 3.35$ 6.25$ 6.93$ 7.44$ 6.26$ 6.73$ 7.21$ 2.17$ 2.18$ -$ -$ -$ -$ -$ -$ Base Charge 16.61$ 17.44$ 19.01$ 20.72$ 22.58$ 24.16$ 25.85$ 27.66$ 28.21$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ Consumption Charge (0-30)2.77$ 2.91$ 3.17$ 3.46$ 3.77$ 4.03$ 4.31$ 4.61$ 4.70$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ Consumption Charge (30-60)3.45$ 3.62$ 3.95$ 4.31$ 4.70$ 5.03$ 5.38$ 5.76$ 5.88$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ Consumption Charge (60+)5.15$ 5.41$ 5.90$ 6.43$ 7.01$ 7.50$ 8.03$ 8.59$ 8.76$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,206,283$ 4,513,482$ 4,722,500$ 5,147,525$ 5,610,802$ 6,003,558$ 6,423,807$ 6,873,474$ 7,010,944$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ Investment Earnings 87,134 32,600 32,600 19,701 15,679 18,263 22,205 19,098 23,405 26,021 30,670 27,501 31,074 44,792 66,740 86,434 Nonoperating 74,034 - - - - - - - - - - - - - - - Bond Proceeds (PFA) - - - - - - - - - - - - - - - - Bond Proceeds (GO) 1,825,604 2,600,000 3,800,000 - 4,260,000 1,500,000 - - 1,600,000 - - - - - - - Interfund Loans (Reporting) - - - - - - - - - - - - - - - - Transfers In - - - - - - - - - Total 6,193,055 7,146,082 8,555,100 5,167,226 9,886,481 7,521,822 6,446,013 6,892,572 8,634,349 7,177,184 7,181,832 7,178,663 7,182,237 7,195,954 7,217,903 7,237,597 Expenditures Personal Servcies 610,323 648,502 662,277 682,145 702,610 723,688 745,399 767,761 790,793 814,517 838,953 864,121 890,045 916,746 944,249 972,576 Supplies 316,795 340,510 388,910 396,688 404,622 412,714 420,969 429,388 437,976 446,735 455,670 464,783 474,079 483,561 493,232 503,097 Other Services & Charges 932,051 809,531 643,234 656,099 669,221 682,605 696,257 710,182 724,386 738,874 753,651 768,724 784,099 799,781 815,776 832,092 Insurance 45,435 56,810 56,122 57,244 58,389 59,557 60,748 61,963 63,202 64,467 65,756 67,071 68,412 69,781 71,176 72,600 Utilities 219,288 236,900 236,900 241,638 246,471 251,400 256,428 261,557 266,788 272,124 277,566 283,117 288,780 294,555 300,446 306,455 Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Capital Outlay (CIP) 2,515,184 3,084,574 4,539,724 455,000 4,371,000 1,327,000 820,000 394,000 2,413,000 858,000 2,031,000 1,505,000 514,000 196,000 408,000 1,499,000 Capital Outlay (Other) - 100,000 - - - - - - - - - - - - - - Debt Service (Existing) 1,079,960 1,157,641 1,405,464 1,545,037 1,566,998 1,552,978 1,542,084 1,540,090 1,398,112 1,028,553 674,789 392,138 202,000 - - - Debt Service (PFA) 1,140,130 1,140,310 1,140,390 1,140,370 1,140,250 1,141,030 1,140,700 1,140,270 1,140,740 1,141,100 1,140,350 1,140,350 1,140,350 1,140,350 1,140,350 1,140,350 Debt Service (Projected) - - - 439,811 439,811 932,862 1,108,708 1,108,708 1,108,708 1,296,277 1,296,277 1,296,277 1,296,277 856,466 856,466 363,415 Total 8,659,284 9,374,778 10,873,021 7,414,032 11,399,371 8,883,834 8,591,293 8,213,919 10,143,705 8,460,646 9,334,011 8,581,582 7,458,042 6,557,239 6,829,695 7,489,584 Cash Balance - Beginning 3,844,265 3,135,562 2,706,866 2,188,945 1,742,138 2,029,249 2,467,236 2,121,956 2,600,609 2,891,253 3,407,791 3,055,612 3,452,693 4,976,888 7,415,603 9,603,811 Changes in Accruals (42,591) - - - - - - - - - - - - - - - Revenues 6,193,055 7,146,082 8,555,100 5,167,226 9,886,481 7,521,822 6,446,013 6,892,572 8,634,349 7,177,184 7,181,832 7,178,663 7,182,237 7,195,954 7,217,903 7,237,597 Expenditures (8,659,284) (9,374,778) (10,873,021) (7,414,032) (11,399,371) (8,883,834) (8,591,293) (8,213,919) (10,143,705) (8,460,646) (9,334,011) (8,581,582) (7,458,042) (6,557,239) (6,829,695) (7,489,584) Noncash - Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Cash Balance - Ending 3,135,562$ 2,706,866$ 2,188,945$ 1,742,138$ 2,029,249$ 2,467,236$ 2,121,956$ 2,600,609$ 2,891,253$ 3,407,791$ 3,055,612$ 3,452,693$ 4,976,888$ 7,415,603$ 9,603,811$ 11,151,823$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 City of Brooklyn Center Sanitary Sewer Utility Cash Flows Revised: 10-6-21 5.00% 5.00% 5.00% 5.00% 2.00% 2.00% 2.00% 2.00% 2.00% 1.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Rate Change 5.00%5.00%5.00%5.00%3.00%2.00%2.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.89.14$ 93.59$ 98.27$ 103.19$ 106.28$ 108.41$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ Per Quarter Change 4.24$ 4.46$ 4.68$ 4.91$ 3.10$ 2.13$ 2.17$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,662,342$ 4,895,459$ 5,140,000$ 5,397,000$ 5,558,910$ 5,670,088$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ Investment Earnings 152,855 42,600 47,000 31,905 27,096 26,227 26,778 26,440 26,857 24,705 13,121 13,683 9,597 12,151 16,425 18,815 Nonoperating 8,693 - - - - - - - - - - - - - - - Bond Proceeds 1,118,107 1,400,000 1,600,000 - 1,580,000 2,420,000 - - 550,000 - 2,300,000 - - - - - Total 5,941,997 6,338,059 6,787,000 5,428,905 7,166,006 8,116,315 5,810,268 5,809,930 6,360,346 5,808,195 8,096,611 5,797,173 5,793,087 5,795,641 5,799,915 5,802,305 Expenditures Personal Services 270,334 271,719 276,333 284,623 293,162 301,957 311,015 320,346 329,956 339,855 350,050 360,552 371,368 382,509 393,985 405,804 Supplies 26,058 58,475 75,375 76,883 78,420 79,989 81,588 83,220 84,884 86,582 88,314 90,963 93,692 96,503 99,398 102,380 Other Services & Charges 3,034,503 3,042,607 3,089,294 3,151,080 3,214,101 3,278,384 3,343,951 3,410,830 3,479,047 3,548,628 3,619,600 3,691,992 3,765,832 3,841,149 3,917,972 3,996,331 Insurance 21,115 25,371 23,321 23,787 24,263 24,748 25,243 25,748 26,263 26,788 27,324 28,144 28,988 29,858 30,754 31,676 Utilities 36,689 39,100 39,100 39,882 40,680 41,493 42,323 43,170 44,033 44,914 45,812 47,186 48,602 50,060 51,562 53,109 Depreciation 977,861 977,861 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Capital Outlay 3,678,642 3,370,488 2,492,900 1,240,000 2,440,000 2,980,000 461,000 480,000 1,362,000 1,863,000 2,717,000 791,000 220,000 120,000 240,000 590,000 Debt Service (Existing)617,889 743,451 910,599 1,005,807 1,026,854 1,016,645 963,015 776,354 645,010 488,260 484,399 265,169 - - - - Debt Service (Projected)- - - 141,184 145,066 331,924 619,721 623,933 628,260 697,184 701,753 976,077 980,901 800,674 800,674 617,805 Total 8,663,091 8,529,073 7,906,922 6,963,246 8,262,546 9,055,139 6,847,857 6,763,601 7,599,454 8,095,210 9,034,252 7,251,084 6,509,384 6,320,753 6,534,343 6,797,105 Cash Balance - Beginning 6,569,127 4,878,097 3,664,944 3,545,022 3,010,681 2,914,141 2,975,317 2,937,728 2,984,057 2,744,950 1,457,934 1,520,293 1,066,382 1,350,086 1,824,974 2,090,545 Changes in Accruals 52,203 - - - - - - - - - - - - - - - Revenues 5,941,997 6,338,059 6,787,000 5,428,905 7,166,006 8,116,315 5,810,268 5,809,930 6,360,346 5,808,195 8,096,611 5,797,173 5,793,087 5,795,641 5,799,915 5,802,305 Expenditures (8,663,091) (8,529,073) (7,906,922) (6,963,246) (8,262,546) (9,055,139) (6,847,857) (6,763,601) (7,599,454) (8,095,210) (9,034,252) (7,251,084) (6,509,384) (6,320,753) (6,534,343) (6,797,105) Noncash - Depreciation 977,861 977,861 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Cash Balance - Ending 4,878,097$ 3,664,944$ 3,545,022$ 3,010,681$ 2,914,141$ 2,975,317$ 2,937,728$ 2,984,057$ 2,744,950$ 1,457,934$ 1,520,293$ 1,066,382$ 1,350,086$ 1,824,974$ 2,090,545$ 2,095,745$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Capital outlay Cash Balance (ending)Minimum Targeted Balance* City of Brooklyn Center Storm Water Utility Cash Flows Revised: 10-6-21 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Rate Change 3.00% 3.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Residential - Flat Fee / Per Qtr.15.52$ 15.98$ 17.10$ 18.30$ 19.58$ 20.95$ 22.42$ 23.99$ 24.47$ 24.95$ 25.45$ 25.96$ 26.48$ 27.01$ 27.55$ 28.10$ 28.66$ Per Quarter Change 0.45$ 0.47$ 1.12$ 1.20$ 1.28$ 1.37$ 1.47$ 1.57$ 0.48$ 0.49$ 0.50$ 0.51$ 1.53$ 1.56$ 1.59$ 1.62$ 1.65$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Revenues Operating 1,691,946$ 1,742,704$ 1,864,694$ 1,995,222$ 2,134,888$ 2,284,330$ 2,444,233$ 2,615,329$ 2,667,636$ 2,720,989$ 2,775,408$ 2,830,917$ 2,887,535$ 2,945,286$ 3,004,191$ 3,064,275$ 3,125,561$ Investment Earnings 138,112 49,800 43,200 59,825 24,085 29,619 31,156 20,194 25,122 10,795 21,172 38,505 36,135 28,720 38,085 43,887 48,484 Intergovernmental 24,896 305,000 - - - - - - - - - - - - - - - Nonoperating - - - - - - - - - - - - - - - - - Bond Proceeds - 2,200,000 940,000 - 920,000 1,130,000 - - - 2,740,000 1,320,000 - - - - - - Total 1,854,954 4,297,504 2,847,894 2,055,047 3,078,973 3,443,949 2,475,389 2,635,524 2,692,758 5,471,784 4,116,580 2,869,421 2,923,670 2,974,006 3,042,277 3,108,162 3,174,045 Expenditures Personal Servcies 324,114 349,501 350,577 361,094 371,927 383,085 394,578 406,415 418,607 431,165 444,100 457,423 471,146 485,281 499,839 514,834 530,279 Supplies 13,541 49,100 53,600 54,672 55,765 56,881 58,018 59,179 60,362 61,570 62,801 64,057 65,338 66,645 67,978 69,337 70,724 Other Services & Charges 529,352 419,377 434,841 443,538 452,409 461,457 470,686 480,100 489,702 499,496 509,486 519,675 530,069 540,670 551,484 562,513 573,763 Insurance 2,759 3,427 3,018 3,078 3,140 3,203 3,267 3,332 3,399 3,467 3,536 3,607 3,679 3,753 3,828 3,904 3,982 Utilities 2,800 3,800 5,000 5,100 5,202 5,306 5,412 5,520 5,631 5,743 5,858 5,975 6,095 6,217 6,341 6,468 6,597 Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Capital Outlay 2,378,098 3,359,623 1,845,607 2,444,000 1,075,000 1,532,000 1,132,000 350,000 1,610,000 2,952,000 1,430,000 1,129,000 1,446,000 620,000 865,000 1,080,000 2,560,000 Debt Service (existing) 351,397 443,525 525,470 677,050 690,500 697,575 688,675 700,275 574,625 576,275 - - - - - - - Debt Service (projected) - - - 108,795 108,795 216,647 349,118 349,118 349,118 349,118 670,329 825,074 825,074 716,278 716,278 608,426 475,956 Total 5,033,811 6,078,353 4,668,113 5,547,328 4,212,738 4,806,154 4,551,754 3,803,939 4,961,444 6,328,834 4,576,111 4,454,812 4,797,401 3,888,843 4,160,747 4,295,483 5,671,302 Cash Balance - Beginning 5,887,664 4,119,635 3,788,787 3,418,568 1,376,287 1,692,521 1,780,317 1,153,952 1,435,537 616,851 1,209,801 2,200,270 2,064,880 1,641,149 2,176,312 2,507,841 2,770,520 Changes in Accruals (20,922) - - - - - - - - - - - - - - - - Revenues 1,854,954 4,297,504 2,847,894 2,055,047 3,078,973 3,443,949 2,475,389 2,635,524 2,692,758 5,471,784 4,116,580 2,869,421 2,923,670 2,974,006 3,042,277 3,108,162 3,174,045 Expenditures (5,033,811) (6,078,353) (4,668,113) (5,547,328) (4,212,738) (4,806,154) (4,551,754) (3,803,939) (4,961,444) (6,328,834) (4,576,111) (4,454,812) (4,797,401) (3,888,843) (4,160,747) (4,295,483) (5,671,302) Noncash - Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Cash Balance - Ending 4,119,635$ 3,788,787$ 3,418,568$ 1,376,287$ 1,692,521$ 1,780,317$ 1,153,952$ 1,435,537$ 616,851$ 1,209,801$ 2,200,270$ 2,064,880$ 1,641,149$ 2,176,312$ 2,507,841$ 2,770,520$ 1,723,263$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 5,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance - Ending Minimum Targeted Balance* City of Brooklyn Center Street Light Utility Fund Rate Analysis Revised: 10-6-21 Rate Change 0.00%0.00%0.00%0.00%5.00%5.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.6.55$ 6.55$ 6.55$ 6.55$ 6.88$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ Per Quarter Change -$ -$ -$ -$ 0.33$ 0.34$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 449,286$ 449,286$ 460,000$ 460,000$ 483,000$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ Investment Earnings 25,587 8,500 8,200 5,745 3,896 4,259 3,371 2,188 4,725 6,673 9,942 12,978 15,077 17,092 20,072 22,980 Nonoperating - - - - - - - - - - - - - - - - Total 474,873 457,786 468,200 465,745 486,896 511,409 510,521 509,338 511,875 513,823 517,092 520,128 522,227 524,242 527,222 530,130 Expenditures Supplies 481 8,030 8,030 8,191 8,354 8,522 8,692 8,866 9,043 9,224 9,408 9,597 9,789 9,984 10,184 10,388 Other Services & Charges 52,520 71,610 75,731 77,246 78,791 80,366 81,974 83,613 85,285 86,991 88,731 90,506 92,316 94,162 96,045 97,966 Insurance 1,132 1,808 930 949 968 987 1,007 1,027 1,047 1,068 1,090 1,111 1,134 1,156 1,179 1,203 Utilities 182,385 204,000 200,000 204,000 208,080 212,242 216,486 220,816 225,232 229,737 234,332 239,019 243,799 248,675 253,648 258,721 Depreciation 70,101 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Capital Outlay 54,430 608,871 571,662 281,000 170,000 260,000 270,000 50,000 80,000 - 10,000 60,000 60,000 - - - Transfers Out - - - - - - - - - - - - - - - - Total 361,049 974,319 936,353 651,385 546,193 642,116 658,159 444,322 480,608 407,020 423,561 480,232 487,037 433,977 441,057 448,278 Cash Balance - Beginning 917,936 1,152,977 716,444 328,291 222,651 243,355 192,648 125,010 270,026 381,293 568,095 741,626 861,523 976,712 1,146,977 1,313,143 Changes in Accruals 51,116 - - - - - - - - - - - - - - - Revenues 474,873 457,786 468,200 465,745 486,896 511,409 510,521 509,338 511,875 513,823 517,092 520,128 522,227 524,242 527,222 530,130 Expenditures (361,049) (974,319) (936,353) (651,385) (546,193) (642,116) (658,159) (444,322) (480,608) (407,020) (423,561) (480,232) (487,037) (433,977) (441,057) (448,278) Noncash - Depreciation 70,101 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Cash Balance - Ending 1,152,977$ 716,444$ 328,291$ 222,651$ 243,355$ 192,648$ 125,010$ 270,026$ 381,293$ 568,095$ 741,626$ 861,523$ 976,712$ 1,146,977$ 1,313,143$ 1,474,994$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance - Ending Minimum Targeted Balance* City of Brooklyn Center Recycling Fund Rate Analysis Revised: 10-6-21 Rate Change 0.00%0.00%1.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Residential - Flat Fee / Per Qtr.11.98$ 11.98$ 12.10$ 12.34$ 12.59$ 12.84$ 13.09$ 13.36$ 13.62$ 13.90$ 14.17$ 14.46$ Per Quarter Change -$ -$ 0.12$ 0.24$ 0.25$ 0.25$ 0.26$ 0.26$ 0.27$ 0.27$ 0.28$ 0.28$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues Operating 394,495$ 395,715$ 398,440$ 406,409$ 414,537$ 422,828$ 431,284$ 439,910$ 448,708$ 457,682$ 466,836$ 476,173$ Investment Earnings 4,809 1,900 1,600 3,194 3,076 2,953 2,825 2,690 2,550 2,405 2,253 2,094 Total 399,304 397,615 400,040 409,603 417,613 425,781 434,109 442,600 451,259 460,087 469,089 478,267 Expenditures Supplies 405 150 - - - - - - - - - - Other Services & Charges 394,117 406,743 410,810 414,919 423,217 431,681 440,315 449,121 458,104 467,266 476,611 486,143 Insurance 1,880 1,584 1,404 1,418 1,432 1,447 1,461 1,476 1,490 1,505 1,520 1,536 Total 396,402 408,477 412,214 416,337 424,649 433,128 441,776 450,597 459,594 468,771 478,131 487,679 Cash Balance - Beginning 200,047 205,558 194,696 182,521 175,788 168,752 161,405 153,738 145,742 137,406 128,722 119,679 Changes in Accruals 2,609 - - - - - - - - - - - Revenues 399,304 397,615 400,040 409,603 417,613 425,781 434,109 442,600 451,259 460,087 469,089 478,267 Expenditures (396,402) (408,477) (412,214) (416,337) (424,649) (433,128) (441,776) (450,597) (459,594) (468,771) (478,131) (487,679) Noncash - Depreciation - - - - - - - - - - - - Cash Balance - Ending 205,558$ 194,696$ 182,521$ 175,788$ 168,752$ 161,405$ 153,738$ 145,742$ 137,406$ 128,722$ 119,679$ 110,268$ $- $50,000 $100,000 $150,000 $200,000 $250,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Recycling Fund Utility Cash Balance - Ending Public Works Department City Council Work Session, October 18,2021Michael Marsh, Acting Public Works Director and Andrew Splinter, Acting Finance Director Responsibly provide for the maintenance and operations of the City’s infrastructure and facilities in a quality, cost effective manner including: •121 miles of water main, 2,050 valves, 1,000 hydrants, 9,000 metered connections •105 miles sanitary sewer, 9,000 sewer service connections, 10 lift stations •88 miles of storm drains and 100 treatment facilities •270 city-owned ornamental lights, 920 Xcel lights and 100 traffic signal overhead lights Strategic Function –Public Utilities •Water Utility: 1.3 billion gal/yr supplied to customers from 9 wells, 3 water towers, water treatment plant •Sanitary Sewer Utility: Conveyance of 900 million gal/yr of wastewater •Storm Drainage Utility: Maintain approx. 88 miles of drainage pipes, 40 ponds, storm sewer structures •Street Light Utility: Operation of 1300 street lights 2 Public Utilities –Staffing Levels 3 Positions FTEs 2019 2020 2021 Supervisor of Utilities 1 1 1 Engineering Technician 3 (distributed 1/3 over 49141, 49251, 49411) 1 1 1 Maintenance II (4-49141, 2-49251, 2-49411)9 9 9 Part Time/Summer Temporary Employees (3-49141, 2-49251, 1- 49411) 2.0 2.0 2.0 Total 13.0 13.0 13.0 Annual Goals & 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. 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. 4 Utilities Performance Measures 5 Performance Objectives Description of Performance Measure Performance Levels *Actual Value Target Value Billable engineering project staff time and overtime (Grandview North and Interstate projects). 80%>60% Miles of annual street sweeping performed 1459.1 miles (4 Citywide, 10 targeted) >990 miles (4 Citywide rounds, 10 rounds of targeted secondary areas) Miles of annual sanitary sewer televised, cleaned, root-sawed, lined and new pipe 26 >= 19.6 miles (1/5 of the City’s total 97.9 miles) Private sanitary sewer backups per year (due to City system blockage) 0 0 Drinking Water Regulated Substances: Copper Lead Barium Trihalomethanes Haloacetic Acids Total Chlorine Flouride No violation No violation No violation No violation No violation No violation No violation No violations Key Initiatives 6 •2022 CIP •Woodbine area Improvements •Well 7 and WTP HSP 1 Rehabilitation •Lift Station 4 Rehabilitation •I-94 & Dupont 24” steel water main replacement •Water treatment plant redundant water main connection •Freeway and Highway utility crossing replacements •Storm water pond rehab •Storm pickup plow addition •Public Works facility needs survey •Forklift purchase 7 Comparative Cities’ Utility Rates 8 Comparative Cities’ Utility Rates 9 Cash Flow/Rate Projections •Assumptions for Cash Flow/Rate Projections •Includes capital outlay based on 15 –year CIP •Anticipated debt issues include: •Water G.O. Revenue Bonds –2021, 2022, 2024, 2025, 2028 •Sanitary Sewer G.O. Revenue Bonds –2021, 2022, 2024, 2025, 2028, 2030 •Storm Sewer G.O. Revenue Bonds –2021, 2022, 2029, 2030 •3% annual increase in personal services, 2% annual increase in operating expenses 10 Water Utility Rate & Cash 11 Water Utility Cash Flow - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance - Ending Minimum Targeted Balance* Water Utility Rate Comparison 12 $- $20.00 $40.00 $60.00 $80.00 $100.00 $120.00 $140.00 $160.00 $49.16 $69.82 $70.72 $76.07 $83.49 $90.19 $101.17 $96.64 $134.90 $152.94 $158.85 Residential Cost of 18,000 Gallons of Water per Quarter for 2021 Proposed Bond Issue (Water) 13 •Proposed debt issue for $3.8 million of infrastructure improvements identified in the CIP •Annual payments of approximately $400,000 beginning in 2023 (10 years at approximately 2.00%) •Allow the City to smooth rate increases over a period of time Sanitary Sewer Utility Rate/Cash Flow 14 Sanitary Sewer Utility Cash Flow 15 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance (ending)Minimum Targeted Balance* Proposed Bond Issue (Sewer) 16 •Proposed debt issue for $1.6 million of infrastructure improvements identified in the CIP for Grandview Area South Neighborhood reconstruction project. •Annual payments of approximately $170,000 beginning in 2022 (10 years at 2.00%) •Allows the City to smooth rate increases over a period of time Sanitary Sewer Utility Rate Comparison 17 $- $20.00 $40.00 $60.00 $80.00 $100.00 $120.00 $140.00 $79.89 $89.36 $91.36 $93.59 $98.27 $99.65 $104.19 $104.19 $108.54 $115.60 $144.13 Residential Cost of 18,000 Gallons of Sanitary Sewer per Quarter for 2021 Storm Water Utility Rate/Cash Flow 18 Storm Water Utility Cash Flow 19 - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance - Ending Minimum Targeted Balance* Proposed Bond Issue 20 •Proposed debt issue for $940 thousand of infrastructure improvements identified in the CIP. •Annual payments of approximately $100,000 beginning in 2023 (10 years at 2.00%) •Allows the City to smooth rate increases over a period of time Storm Sewer Utility Rate Comparison 21 $- $5.00 $10.00 $15.00 $20.00 $25.00 $30.00 $35.00 Fridley Roseville Brooklyn Center - 2021 Brooklyn Center - 2022 Crystal Richfield Golden Valley New Hope Maplewood Shoreview $9.85 $14.25 $15.52 $15.98 $20.15 $20.35 $25.00 $25.08 $27.25 $32.30 Residential Storm Water Charge per Quarter for 2020 22 Comparative Cities’ Utility Rates Water, Sewer, Storm Water Rate Comparison 23 $- $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 2021 Residential Quarterly total Water, Sewer, and Storm Utility Bill (18,000 gallons) Street Light Utility Rate/ Cash Flow 24 Street Light Utility Cash Flow 25 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance - Ending Minimum Targeted Balance* Street Light Utility Rate Comparison 26 $- $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 $14.00 $16.00 Crystal New Hope Richfield Brooklyn Center - 2020 Brooklyn Center - 2021 Golden Valley Shoreview $5.00 $5.70 $5.77 $6.55 $6.55 $12.42 $14.31 Residential Street Light Charge per Quarter for 2021 Recycling Utility Rate/Cash Flow 27 Recycling Utility Rate Comparison 28 $- $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 $14.00 $16.00 $18.00 $20.00 Roseville Fridley Crystal New Hope Brooklyn Center - 2020 Brooklyn Center - 2021 Maplewood Golden Valley $9.00 $9.83 $11.25 $11.25 $11.98 $11.98 $13.25 $16.00 Residential Recycling Charge per Quarter for 2021 Questions? 29 Technology Capital Project Fund 30 Technology Fund Cash Flow Chart 31 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Technology Fund Expenditures Cash Balance - Ending Questions? 32 2022 Brooklyn Center Department Budget Narrative Department Name: 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. Key Initiatives focused on the achievement of strategic priorities/value propositions Inclusive Community Engagement • General Community Outreach In 2022 we will continue the operation of the new water treatment plant. The current pandemic precludes community participation, outreach and education. Infrastructure – Key Investments • Critical Infrastructure Improvements In 2022 we will implement the 29th 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 2022 a financial strategy that uses a combination of General Obligation Improvement Bonds, Utility Revenue Bonds, and Utility Fund rate adjustments will be used to fund capital projects. Staffing Levels Positions FTEs 2021 2022 2023 • 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, 3-49411) 9 9 9 • Part Time/Summer Temporary Employees (3- 49141, 2-49251, 1-49411) 2.0 2.0 2.0 TOTAL 13.0 13.0 13.0 Strategic Functions/Division(s): • Water Utility (49141) 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 2,050 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 (49251) 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. The City has approximately 105 miles of sanitary 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 88 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, 145 ornamental lights on Brooklyn Boulevard, 40 ornamental lights along Xerxes Avenue, 72 ornamental lights along Bass Lake Rd and 57th Avenue and leases approximately 920 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 and the city’s traffic signals. 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. 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 Billable engineering project staff time and overtime (Grandview North and Interstate projects) 80% >60% Miles of annual street sweeping performed 1459.1 miles (4 Citywide, 10 targeted) >990 miles (4 Citywide rounds, 10 rounds of targeted secondary areas) Miles of annual sanitary sewer televised, cleaned, root-sawed, lined and new pipe 26 >= 19.6 miles (1/5 of the City’s total 97.9 miles) Private sanitary sewer backups per year (due to City system blockage) 0 0 Drinking Water Regulated Substances: Copper Lead Barium Trihalomethanes Haloacetic Acids Total Chlorine Flouride No violation No violation No violation No violation No violation No violation No violation No violations *2020 data Capital Outlay and Other Initiatives with Significant Budget Impact  2022 Capital Improvement Projects – See CIP section of Budget  2022 Storm Sewer Utility – Plow for Storm Pickup ($10,300)  2022 PW Facility Needs Assessment ($50,000)  2022 Used Forklift {($12,000 total) $4000 Storm; $4000 Sanitary; $4000 Water} 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49141 - WATER UTILITY-OPERATIONS OPERATING REVENUES 4701 - WATER SALES 3,228,802$ 3,727,823$ 2,953,442$ 4,193,482$ 4,266,500$ 1.74% 4702 - FIRE LINES 9,233 9,236 6,952 9,000 10,000 11.11% 4703 - WATER METER SALES (26,493) (11,197) (15,594) (10,000) (10,000) 0.00% 4704 - WATER METER RENTALS 13,741 7,400 4,250 3,000 5,000 66.67% 4705 - SERVICE RESTORATION FEES 2,225 1,043 - 3,000 1,000 -66.67% 4706 - CONNECTION CHARGES - 48,000 1,500 9,000 10,000 11.11% 4707 - PENALTIES 119,821 - - - - 0.00% 4708 - TOWER RENTAL FEES 387,506 391,678 (110,153) 256,000 400,000 56.25% 4709 - CERTIFICATION CHARGES 26,160 32,300 35,150 50,000 40,000 -20.00% TOTAL SALES AND USER FEES 3,760,995 4,206,283 2,875,547 4,513,482 4,722,500 4.63% TOTAL OPERATING REVENUES 3,760,995 4,206,283 2,875,547 4,513,482 4,722,500 4.63% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 364,035 383,130 287,139 392,733 400,036 1.86% 6102 - OVERTIME-FT EMPLOYEES 51,171 45,066 35,559 48,000 48,000 0.00% 6103 - WAGES-PART TIME EMPLOYEES 21,223 18,204 33,961 35,000 35,000 0.00% 6104 - OVERTIME - PT EMPLOYEES 29 - - - - 0.00% 6111 - SEVERANCE PAY 4,334 7,331 - - - 0.00% 6122 - PERA COORDINATED PLAN 31,140 32,115 24,202 34,780 35,329 1.58% 6125 - FICA - SOCIAL SECURITY 26,415 26,665 21,408 28,751 29,205 1.58% 6126 - FICA - MEDICARE 6,178 6,312 5,007 6,724 6,830 1.58% 6131 - CAFETERIA PLAN CONTRIBUTIONS 71,880 75,660 62,700 83,931 88,150 5.03% 6151 - WORKER'S COMP INSURANCE 12,207 15,840 11,078 18,583 19,727 6.16% TOTAL PERSONAL SERVICES 588,612 610,323 481,054 648,502 662,277 2.12% 6201 - OFFICE SUPPLIES 2,048 1,790 171 1,800 1,800 0.00% 6203 - BOOKS/REFERENCE MATERIALS - 90 - 500 500 0.00% 6204 - STATIONARY SUPPLIES - - - 1,610 - -100.00% 6212 - MOTOR FUELS 2,382 2,763 3,561 5,000 5,000 0.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 55 - - 400 400 0.00% 6216 - CHEMICALS/CHEMICAL PRODUCTS 123,353 162,955 143,029 160,000 160,000 0.00% 6217 - SAFETY SUPPLIES 1,477 1,855 6,610 7,500 4,500 -40.00% 6219 - GENERAL OPERATING SUPPLIES 32,881 15,960 18,521 12,600 16,000 26.98% 6223 - BUILDINGS & FACILITIES 782 45,474 933 1,500 11,500 666.67% 6224 - STREET MAINT MATERIALS 5,502 4,615 6,266 10,000 10,000 0.00% 6225 - PARK & LANDSCAPE MATERIALS - 634 60 1,500 1,500 0.00% 6227 - PAINT SUPPLIES 891 1,642 2,492 2,500 3,500 40.00% 6235 - UTILITY SYSTEM SUPPLIES 89,355 41,816 19,369 70,000 70,000 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 22,058 27,767 26,653 40,000 40,000 0.00% 6241 - SMALL TOOLS 1,118 1,415 1,489 5,000 5,000 0.00% 6242 - MINOR EQUIPMENT 5,612 2,786 4,933 17,600 57,600 227.27% 6243 - MINOR COMPUTER EQUIPMENT 26,586 5,233 210 28,000 3,500 -87.50% TOTAL SUPPLIES 314,100 316,795 234,297 365,510 390,800 6.92% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 2,509 3,000 3,000 0.00% 6302 - ARCH, ENG & PLANNING 21,456 6,900 4,246 85,500 85,500 0.00% 6307 - PROFESSIONAL SERVICES 84,119 178,875 64,962 100,000 60,000 -40.00% 6321 - TELEPHONE/PAGERS 4,795 3,659 1,651 4,100 4,100 0.00% 6322 - POSTAGE 2,646 84 - 6,500 - -100.00% 6329 - OTHER COMMUNICATION SERVICES 4,248 6,209 4,109 5,000 5,000 0.00% 6331 - TRAVEL EXPENSE/MILEAGE - - - 200 200 0.00% 6333 - FREIGHT/DRAYAGE 212 - - 50 50 0.00% 6341 - PERSONNEL ADVERTISING - - - 160 160 0.00% 6342 - LEGAL NOTICES - - - 100 100 0.00% 6351 - PRINTING 133 105 52 500 500 0.00% 6402 - EQUIPMENT SERVICES 3,021 1,562 - 5,000 5,000 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE 5,627 7,966 6,415 12,400 7,500 -39.52% 6406 - MULTI-FUNCTION MTNCE 105 151 88 250 250 0.00% 6409 - OTHER REPAIR & MAINT SVCS 22,458 42,602 5,149 24,200 26,200 8.26% 6417 - UNIFORMS 1,593 2,690 1,586 2,000 2,000 0.00% 6421 - SOFTWARE LICENSE 12,900 229 - - - 0.00% 6422 - SOFTWARE MAINT 2,356 - - 1,200 - -100.00% 6423 - LOGIS CHARGES 48,416 53,094 36,182 60,000 60,000 0.00% 6432 - CONFERENCES AND SCHOOLS 3,251 3,410 4,827 8,000 8,000 0.00% 6434 - DUES & SUBSCRIPTIONS 3,078 5,909 1,137 4,000 4,000 0.00% 6435 - CREDIT CARD FEES - - - 200 37,000 18400.00% 6436 - UNCOLLECTIBLE CHECKS/DEBTS 317 - - - - 0.00% 6438 - CASH SHORT (OVER)(1) 1,215 - - - 0.00% 6405 - PARK & LANDSCAPE SERVICES - 2,256 4,367 10,000 10,000 0.00% 6441 - LICENSES, TAXES & FEES 69,941 98,993 78,457 86,500 110,000 27.17% 6443 - PRIZE AWARDS/EXP REIMB - 779 350 - 500 100.00% 6449 - OTHER CONTRACTUAL SERVICE 200,907 207,156 109,259 150,000 150,000 0.00% TOTAL SERVICES & OTHER CHARGES 494,314 626,399 325,346 568,860 579,060 1.79% WATER UTILITY FUND - 60100 PUBLIC UTILITY FUND 6361 - GENERAL LIABILITY INSURANCE 33,873 36,139 25,834 37,345 36,168 -3.15% 6362 - PROPERTY INSURANCE 6,215 8,063 12,217 18,102 17,104 -5.51% 6366 - MACHINERY BREAKDOWN INSURANCE 1,236 1,233 2,034 1,363 2,850 109.10% TOTAL INSURANCE 41,324 45,435 40,085 56,810 56,122 -1.21% 6381 - ELECTRIC 153,039 180,141 157,869 190,000 190,000 0.00% 6382 - GAS 18,866 16,043 20,069 22,600 22,600 0.00% 6383 - WATER 13,950 6,329 11,045 7,000 7,000 0.00% 6385 - SEWER 13,637 4,815 6,561 6,000 6,000 0.00% 6386 - STORM SEWER 9,064 9,336 7,213 8,700 8,700 0.00% 6388 - HAZARDOUS WASTE DISPOSAL - - - - - 0.00% 6389 - STREET LIGHTS 2,624 2,624 1,968 2,600 2,600 0.00% TOTAL UTILITIES 211,180 219,288 204,725 236,900 236,900 0.00% 6461 - FUEL CHARGES 3,425 4,011 2,749 4,100 4,500 9.76% 6462 - FIXED CHARGES 6,921 5,902 9,773 15,008 10,307 -31.32% 6463 - REPAIR & MAINT CHARGES 5,530 15,035 4,177 10,300 10,600 2.91% 6465 - REPLACEMENT CHARGES 22,450 22,450 16,378 24,567 32,267 31.34% TOTAL CENTRAL GARAGE CHARGES 38,326 47,398 33,077 53,975 57,674 6.85% 6494 - DEPRECIATION EXPENSE 1,664,921 1,800,118 1,203,386 1,800,000 - -100.00% TOTAL DEPRECIATION 1,664,921 1,800,118 1,203,386 1,800,000 - -100.00% TOTAL OPERATING EXPENSES 3,352,777 3,665,756 2,521,970 3,730,557 1,982,833 -46.85% OPERATING INCOME 408,218 540,527 353,577 782,925 2,739,667 249.93% NONOPERATING REVENUES 4601 - SPECIAL ASSESSMENTS 45,432 47,046 (233,562) - - 0.00% 4607 - SPEC ASSESS INTEREST 7 - 989 - - 0.00% TOTAL SPECIAL ASSESSMENTS 45,439 47,046 (232,573) - - 0.00% 4603 - INTEREST EARNINGS 76,748 51,801 21,126 32,600 23,600 -27.61% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 47,479 35,329 - - - 0.00% TOTAL INVESTMENT EARNINGS 124,227 87,130 21,126 32,600 23,600 -27.61% 4320 - FEDERAL GRANTS - 18,862 375 - - 0.00% 4604 - CHECK PROCESSING FEES 1,740 1,350 960 - - 0.00% 4606 - OTHER REVENUE 11,573 384 - - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS - 6,392 1,840 - - 0.00% TOTAL MISCELLANEOUS 13,313 26,988 3,175 - - 0.00% 4931 - BOND SALES - - 1,915,659 2,600,000 3,800,000 46.15% 4932 - PREMIUM ON BOND SALES - - - - - 0.00% TOTAL DEBT ISSUANCE - - 1,915,659 2,600,000 3,800,000 46.15% TOTAL NONOPERATING REVENUES 182,979 161,164 1,707,387 2,632,600 3,823,600 45.24% NONOPERATING EXPENSES 6530 - IMPROVEMENTS 243,407 152,258 106,836 3,189,000 4,539,724 42.36% 6540 - EQUIPMENT & MACHINERY - - - 100,000 8,000 -92.00% TOTAL CAPITAL OUTLAY 243,407 152,258 106,836 3,289,000 4,547,724 38.27% 6601 - BOND PRINCIPAL - - 848,750 1,840,750 2,073,250 12.63% 6611 - BOND INTEREST 435,922 462,204 456,806 436,444 472,605 8.29% 6621 - PAYING AGENT/OTHER FEES (4,080) (20,752) 3,437 3,000 3,000 0.00% TOTAL DEBT SERVICE 431,842 441,452 1,308,993 2,280,194 2,548,855 11.78% 6471 - ADMINISTRATIVE SERVICE TRANSFER 105,996 105,996 137,772 183,696 184,625 0.51% TOTAL TRANSFERS 105,996 105,996 137,772 183,696 184,625 0.51% TOTAL NONOPERATING EXPENSES 781,245 699,706 1,553,601 5,752,890 7,281,204 26.57% NET CHANGE IN FUND BALANCE (190,048)$ 1,985$ 507,363$ (2,337,365)$ (717,937)$ -69.28% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49251 - SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707 - PENALTIES 69,853$ -$ -$ -$ -$ 0.00% 4721 - SEWER SERVICE 4,486,810 4,662,342 3,499,960 4,899,185 5,140,000 4.92% TOTAL SALES AND USER FEES 4,556,663 4,662,342 3,499,960 4,899,185 5,140,000 4.92% TOTAL OPERATING REVENUES 4,556,663 4,662,342 3,499,960 4,899,185 5,140,000 4.92% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 132,426 151,647 109,153 155,236 157,260 1.30% 6102 - OVERTIME-FT EMPLOYEES 19,400 18,246 15,996 18,000 18,000 0.00% 6103 - WAGES-PART TIME EMPLOYEES 18,829 31,198 3,773 25,000 25,000 0.00% 6111 - SEVERANCE PAY 1,382 2,455 1,669 - - 0.00% 6122 - PERA COORDINATED PLAN 11,387 12,742 9,386 14,231 14,383 1.07% 6125 - FICA - SOCIAL SECURITY 10,871 12,935 8,434 11,763 11,889 1.07% 6126 - FICA - MEDICARE 2,542 3,042 1,973 2,751 2,781 1.09% 6131 - CAFETERIA PLAN CONTRIBUTIONS 19,592 30,264 23,760 36,423 38,254 5.03% 6141 - UNEMPLOYMENT COMPENSATION 324 - - - - 0.00% 6151 - WORKER'S COMP INSURANCE 5,597 7,805 4,709 8,315 8,766 5.42% TOTAL PERSONAL SERVICES 222,350 270,334 178,853 271,719 276,333 1.70% 6201 - OFFICE SUPPLIES 100 32 - 100 100 0.00% 6203 - BOOKS/REFERENCE MATERIALS - - - 200 200 0.00% 6204 - STATIONARY SUPPLIES - - - 3,000 - -100.00% 6214 - CLOTHING & PERSONAL EQUIPMENT 150 75 - 300 300 0.00% 6216 - CHEMICALS/CHEMICAL PRODUCTS 7,873 7,791 6,841 11,500 11,500 0.00% 6217 - SAFETY SUPPLIES 3,013 2,993 11,972 13,000 12,000 -7.69% 6219 - GENERAL OPERATING SUPPLIES 2,187 2,772 459 3,500 3,500 0.00% 6223 - BUILDINGS & FACILITIES 151 25 - 10,100 30,000 197.03% 6224 - STREET MAINT MATERIALS - 2,557 169 7,500 7,500 0.00% 6227 - PAINT SUPPLIES 778 607 300 675 675 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 2,844 3,817 2,695 5,000 5,000 0.00% 6241 - SMALL TOOLS 154 707 285 1,000 1,000 0.00% 6242 - MINOR EQUIPMENT 843 420 925 2,600 2,600 0.00% 6243 - MINOR COMPUTER EQUIPMENT 760 4,262 70 25,000 3,500 -86.00% TOTAL SUPPLIES 18,853 26,058 23,716 83,475 77,875 -6.71% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 2,509 3,000 3,000 0.00% 6302 - ARCH, ENG & PLANNING 29,625 - - 1,900 1,900 0.00% 6307 - PROFESSIONAL SERVICES 17,744 29,842 6,494 4,820 4,820 0.00% 6321 - TELEPHONE/PAGERS 3,135 2,189 221 3,100 3,100 0.00% 6322 - POSTAGE 5,654 - - 12,700 - -100.00% 6351 - PRINTING - - - 375 375 0.00% 6403 - BLDGS/FACILITIES MAINT SERVICE 3,461 3,611 3,765 7,000 7,000 0.00% 6409 - OTHER REPAIR & MAINT SVCS 75,803 65,902 48,118 100,000 100,000 0.00% 6417 - UNIFORMS 700 680 - 1,000 1,000 0.00% 6421 - SOFTWARE LICENSE - 160 - - - 0.00% 6423 - LOGIS CHARGES 38,022 43,843 30,857 45,000 45,000 0.00% 6432 - CONFERENCES AND SCHOOLS 3,252 2,060 478 4,000 4,000 0.00% 6434 - DUES & SUBSCRIPTIONS 410 264 263 425 425 0.00% 6441 - LICENSES, TAXES & FEES - 123 - 300 300 0.00% 6449 - OTHER CONTRACTUAL SERVICE 22,532 42,891 12,989 25,000 25,000 0.00% TOTAL SERVICES & OTHER CHARGES 203,074 194,120 105,694 208,620 195,920 -6.09% 6361 - GENERAL LIABILITY INSURANCE 21,589 19,431 15,365 23,802 21,511 -9.63% 6362 - PROPERTY INSURANCE 1,098 1,426 1,093 1,211 1,530 26.34% 6366 - MACHINERY BREAKDOWN INSURANCE 259 258 198 358 280 -21.79% TOTAL INSURANCE 22,946 21,115 16,656 25,371 23,321 -8.08% 6381 - ELECTRIC 37,066 36,689 25,350 39,100 39,100 0.00% 6391 - MET COUNCIL ENVIRON SVCS 2,576,325 2,653,796 2,063,330 2,552,680 2,646,952 3.69% TOTAL UTILITIES 2,613,391 2,690,485 2,088,680 2,591,780 2,686,052 3.64% 6461 - FUEL CHARGES 11,316 9,929 8,386 13,700 12,700 -7.30% 6462 - FIXED CHARGES 9,287 9,039 14,291 20,021 17,439 -12.90% 6463 - REPAIR & MAINT CHARGES 12,876 10,383 5,269 15,300 15,800 3.27% 6465 - REPLACEMENT CHARGES 58,005 58,005 42,695 64,042 111,841 74.64% TOTAL CENTRAL GARAGE CHARGES 91,484 87,356 70,641 113,063 157,780 39.55% 6494 - DEPRECIATION EXPENSE 991,951 977,861 604,222 1,000,000 1,000,000 0.00% TOTAL DEPRECIATION 991,951 977,861 604,222 1,000,000 1,000,000 0.00% TOTAL OPERATING EXPENSES 4,164,049 4,267,329 3,088,462 4,294,028 4,417,281 2.87% OPERATING INCOME 392,614 395,013 411,498 605,157 722,719 19.43% SEWER UTILITY FUND - 60200 PUBLIC UTILITY FUND NONOPERATING REVENUES 4320 - FEDERAL GRANTS - 8,271 - - - 0.00% 4373 - OTHER GRANTS/AID 455,363 - - - - 0.00% TOTAL INTERGOVERNMENTAL 455,363 8,271 - - - 0.00% 4603 - INTEREST EARNINGS 100,703 100,246 38,601 42,600 47,000 10.33% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 67,716 52,609 - - - 0.00% TOTAL INVESTMENT EARNINGS 168,419 152,855 38,601 42,600 47,000 10.33% 4601 - SPECIAL ASSESSMENTS - 422 - - - 0.00% 4726 - CONNECTION CHARGES (723) - - - - 0.00% 4921 - REFUNDS AND REIMBURSEMENTS - - 1,100 - - 0.00% TOTAL MISCELLANEOUS (723) 422 1,100 - - 0.00% 4931 - BOND SALES - - 1,411,516 1,400,000 1,600,000 14.29% 4932 - PREMIUM ON BOND SALES - - - - - 0.00% TOTAL DEBT ISSUANCE - - 1,411,516 1,400,000 1,600,000 14.29% TOTAL NONOPERATING REVENUES 623,059 161,548 1,451,217 1,442,600 1,647,000 14.17% NONOPERATING EXPENSES 6530 - IMPROVEMENTS 90,226 (195) 117,150 3,056,000 2,492,900 -18.43% TOTAL CAPITAL OUTLAY 90,226 (195) 117,150 3,056,000 2,492,900 -18.43% 6601 - BOND PRINCIPAL - - 577,233 577,233 721,473 24.99% 6611 - BOND INTEREST 179,177 164,501 166,218 153,518 189,126 23.19% 6621 - PAYING AGENT/OTHER FEES 2,365 8,317 2,532 1,500 3,000 100.00% TOTAL DEBT SERVICE 181,542 172,818 745,983 732,251 913,599 24.77% 6471 - ADMINISTRATIVE SERVICE TRANSFER 99,426 99,426 125,058 166,744 167,842 0.66% TOTAL TRANSFERS 99,426 99,426 125,058 166,744 167,842 0.66% TOTAL NONOPERATING EXPENSES 371,194 272,049 988,191 3,954,995 3,574,341 -9.62% NET CHANGE IN FUND BALANCE 644,479$ 284,512$ 874,524$ (1,907,238)$ (1,204,622)$ -36.84% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49411 - STORM SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707 - PENALTIES 17,055$ -$ -$ -$ -$ 0.00% 4731 - STORM DRAINAGE FEES 1,663,149 1,691,946 1,313,913 1,798,694 1,864,694 3.67% TOTAL SALES AND USER FEES 1,680,204 1,691,946 1,313,913 1,798,694 1,864,694 3.67% TOTAL OPERATING REVENUES 1,680,204 1,691,946 1,313,913 1,798,694 1,864,694 3.67% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 206,267 215,822 163,924 226,764 223,403 -1.48% 6102 - OVERTIME-FT EMPLOYEES 1,236 348 1,530 2,500 2,500 0.00% 6103 - WAGES-PART TIME EMPLOYEES 12,785 6,934 808 10,800 10,800 0.00% 6111 - SEVERANCE PAY 1,153 3,030 - - - 0.00% 6122 - PERA COORDINATED PLAN 15,563 16,213 12,409 18,006 17,754 -1.40% 6125 - FICA - SOCIAL SECURITY 13,771 13,735 10,381 14,885 14,676 -1.40% 6126 - FICA - MEDICARE 3,221 3,278 2,428 3,480 3,432 -1.38% 6131 - CAFETERIA PLAN CONTRIBUTIONS 40,732 45,396 37,620 53,842 56,549 5.03% 6141 - UNEMPLOYMENT INSURANCE 527 2,791 - - - 0.00% 6151 - WORKER'S COMP INSURANCE 14,236 16,567 11,680 19,224 21,463 11.65% TOTAL PERSONAL SERVICES 309,491 324,114 240,780 349,501 350,577 0.31% 6204 - STATIONARY SUPPLIES - - - 1,600 - -100.00% 6217 - SAFETY SUPPLIES - - 1,406 250 500 100.00% 6219 - GENERAL OPERATING SUPPLIES 215 525 48 5,500 6,000 9.09% 6224 - STREET MAINT MATERIALS 3,134 3,690 2,394 8,000 8,000 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 12,311 7,704 13,846 30,000 36,000 20.00% 6241 - SMALL TOOLS - - 2,359 250 1,500 500.00% 6243 - MINOR COMPUTER EQUIPMENT - 1,622 281 3,500 - -100.00% TOTAL SUPPLIES 15,660 13,541 20,334 49,100 52,000 5.91% 6301 - ACCTG, AUDIT & FIN'L SERVICES 2,736 2,555 2,509 3,000 3,000 0.00% 6302 - ARCH, ENG & PLANNING 68,353 11,151 814 20,000 20,000 0.00% 6307 - PROFESSIONAL SERVICES 1,298 5,271 1,828 2,000 2,000 0.00% 6322 - POSTAGE 2,767 - - 5,940 - -100.00% 6329 - OTHER COMMUNICATION SERVICES - - 29 - - 0.00% 6331 - TRAVEL EXPENSE/MILEAGE 81 - - 500 500 0.00% 6342 - LEGAL NOTICES 42 - - 150 150 0.00% 6351 - PRINTING - - - 1,500 1,500 0.00% 6384 - REFUSE DISPOSAL 3,090 2,800 1,843 3,800 5,000 31.58% 6409 - OTHER REPAIR & MAINT SVCS 29,729 17,544 19,879 31,000 36,000 16.13% 6417 - UNIFORMS 1,050 1,050 - 1,100 1,100 0.00% 6423 - LOGIS CHARGES 24,275 24,067 17,632 24,000 24,000 0.00% 6432 - CONFERENCES AND SCHOOLS 295 - 390 700 700 0.00% 6434 - DUES & SUBSCRIPTIONS 58,244 62,266 60,899 61,565 63,400 2.98% 6449 - OTHER CONTRACTUAL SERVICE 7,564 4,530 12,197 13,000 13,000 0.00% TOTAL SERVICES & OTHER CHARGES 199,524 131,234 118,020 168,255 170,350 1.25% 6361 - GENERAL LIABILITY INSURANCE 3,108 2,759 2,156 3,427 3,018 -11.93% TOTAL INSURANCE 3,108 2,759 2,156 3,427 3,018 -11.93% 6461 - FUEL CHARGES 8,262 8,209 7,565 8,300 9,900 19.28% 6462 - FIXED CHARGES 4,673 4,763 4,833 7,363 5,492 -25.41% 6463 - REPAIR & MAINT CHARGES 19,653 29,649 13,454 17,800 18,300 2.81% 6465 - REPLACEMENT CHARGES 56,900 51,475 34,020 51,030 59,234 16.08% TOTAL CENTRAL GARAGE CHARGES 89,488 94,096 59,872 84,493 92,926 9.98% 6494 - DEPRECIATION EXPENSE 1,437,108 1,431,750 892,230 1,450,000 1,450,000 0.00% TOTAL DEPRECIATION 1,437,108 1,431,750 892,230 1,450,000 1,450,000 0.00% TOTAL OPERATING EXPENSES 2,054,379 1,997,494 1,333,392 2,104,776 2,118,871 0.67% OPERATING INCOME (LOSS)(374,175) (305,548) (19,479) (306,082) (254,177) -16.96% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 118,079 93,458 36,037 49,800 43,200 -13.25% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 66,934 44,656 - - - 0.00% TOTAL INVESTMENT EARNINGS 185,013 138,114 36,037 49,800 43,200 -13.25% 4320 - FEDERAL GRANTS - 24,896 - - - 0.00% 4373 - OTHER GRANTS/AID - - 50,000 305,000 - -100.00% 4612 - DONATIONS & CONTRIBUTIONS 250 - - - - 0.00% 4912 - CAPITAL CONTRIBUTIONS 560,675 391,952 - - - 0.00% TOTAL MISCELLANEOUS 560,925 416,848 50,000 305,000 - -100.00% 4931 - BOND SALES - - 2,215,107 2,400,000 940,000 -60.83% 4932 - PREMIUM ON BOND SALES - - - - - 0.00% TOTAL DEBT ISSUANCE - - 2,215,107 2,400,000 940,000 -60.83% TOTAL NONOPERATING REVENUES 745,938 554,962 2,301,144 2,754,800 983,200 -64.31% STORM SEWER UTILITY FUND - 65100 PUBLIC UTILITY FUND NONOPERATING EXPENSES 6540 - EQUIPMENT & MACHINERY - 27,645 - 75,000 14,400 -80.80% 6530 - IMPROVEMENTS 197,571 179,751 6,181 4,876,000 1,831,207 -62.44% TOTAL CAPITAL OUTLAY 197,571 207,396 6,181 4,951,000 1,845,607 -62.72% 6601 - BOND PRINCIPAL - - 315,000 315,000 355,000 12.70% 6611 - BOND INTEREST 33,826 135,514 128,525 128,525 170,470 32.64% 6621 - BOND ISSUE COSTS 8,415 (16,485) 3,974 1,500 1,500 0.00% TOTAL DEBT SERVICE 42,241 119,029 447,499 445,025 526,970 18.41% 6471 - ADMINISTRATIVE SERVICE TRANSFER 99,426 99,426 126,697 168,929 169,125 0.12% TOTAL TRANSFERS 99,426 99,426 126,697 168,929 169,125 0.12% TOTAL NONOPERATING EXPENSES 339,238 425,851 580,377 5,564,954 2,541,702 -54.33% NET CHANGE IN FUND BALANCE 32,525$ (176,437)$ 1,701,288$ (3,116,236)$ (1,812,679)$ -41.83% 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49571 - STREET LIGHT-OPERATIONS OPERATING REVENUES 4707 - PENALTIES 5,753$ -$ -$ -$ -$ 0.00% 4741 - STREET LIGHT SERVICE CHARGE 451,218 449,286 339,591 461,400 460,000 -0.30% TOTAL SALES AND USER FEES 456,971 449,286 339,591 461,400 460,000 -0.30% TOTAL OPERATING REVENUES 456,971 449,286 339,591 461,400 460,000 -0.30% OPERATING EXPENSES 6204 - STATIONARY SUPPLIES - - - 280 - -100.00% 6243 - MINOR COMPUTER EQUIPMENT - 405 10 - - 0.00% 6239 - OTHER REPAIR & MAINT SUPPLIES 4,138 76 - 7,750 13,750 77.42% TOTAL SUPPLIES 4,138 481 10 8,030 13,750 71.23% 6307 - PROFESSIONAL SERVICES 49 32 23 200 200 0.00% 6322 - POSTAGE 481 - - 1,080 - -100.00% 6351 - PRINTING - - - 100 100 0.00% 6409 - OTHER REPAIR & MAINT SVCS 16,327 20,482 33,106 16,000 20,000 25.00% 6423 - LOGIS CHARGES 6,083 5,452 4,406 6,000 6,000 0.00% 6449 - OTHER CONTRACTUAL SERVICE 381 788 461 300 300 0.00% TOTAL SERVICES & OTHER CHARGES 23,321 26,754 37,996 23,680 26,600 12.33% 6361 - GENERAL LIABILITY INSURANCE 1,640 1,132 664 1,808 930 -48.56% TOTAL INSURANCE 1,640 1,132 664 1,808 930 -48.56% 6381 - ELECTRIC 180,180 182,385 137,023 204,000 200,000 -1.96% TOTAL UTILITIES 180,180 182,385 137,023 204,000 200,000 -1.96% 6494 - DEPRECIATION EXPENSE 69,008 70,101 46,542 80,000 80,000 0.00% TOTAL DEPRECIATION 69,008 70,101 46,542 80,000 80,000 0.00% TOTAL OPERATING EXPENSES 278,287 280,853 222,235 317,518 321,280 1.18% OPERATING INCOME (LOSS)178,684 168,433 117,356 143,882 138,720 -3.59% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 20,219 16,892 10,561 8,500 8,200 -3.53% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 9,917 8,696 - - - 0.00% TOTAL INVESTMENT EARNINGS 30,136 25,588 10,561 8,500 8,200 -3.53% 4912 - CAPITAL CONTRIBUTIONS 456,059 - - - - 0.00% 4921 - REFUNDS & REIMBURSEMENTS 9,886 27,480 36,485 - - 0.00% TOTAL MISCELLANEOUS 465,945 27,480 36,485 - - 0.00% TOTAL NONOPERATING REVENUES 496,081 53,068 47,046 8,500 8,200 -3.53% NONOPERATING EXPENSES 6530 - IMPROVEMENTS 29,691 - - 971,000 571,662 -41.13% TOTAL CAPITAL OUTLAY 29,691 - - 971,000 571,662 -41.13% 6471 - ADMINISTRATIVE SERVICE TRANSFER 25,766 25,766 35,948 47,930 48,051 0.25% TOTAL TRANSFERS 25,766 25,766 35,948 47,930 48,051 0.25% TOTAL NONOPERATING EXPENSES 55,457 25,766 35,948 1,018,930 619,713 -39.18% NET CHANGE IN FUND BALANCE 619,308$ 195,735$ 128,454$ (866,548)$ (472,793)$ -45.44% STREET LIGHT UTILITY FUND - 65200 PUBLIC UTILITY FUND 2021 2019 2020 September 2021 2022 Object Code / Description Actual Actual YTD Budget Budget Change 49311 - RECYCLING OPERATING REVENUES 4707 - PENALTIES 9,025$ 234$ -$ -$ -$ 0.00% 4751 - RECYCLING SERVICE FEES 395,956 394,261 296,307 395,715 400,000 1.08% TOTAL SALES AND USER FEES 404,981 394,495 296,307 395,715 400,000 1.08% TOTAL OPERATING REVENUES 404,981 394,495 296,307 395,715 400,000 1.08% OPERATING EXPENSES 6204 - STATIONARY SUPPLIES - - - 150 - -100.00% 6225 - PARK & LANDSCAPE MATERIALS 19,550 - - - - 0.00% 6243 - MINOR COMPUTER EQUIPMENT - 405 10 - - 0.00% TOTAL SUPPLIES 19,550 405 10 150 - -100.00% 6307 - PROFESSIONAL SERVICES 43 52 36 100 - -100.00% 6322 - POSTAGE 481 - - 1,200 - -100.00% 6423 - LOGIS CHARGES 10,805 5,452 4,406 6,000 6,000 0.00% 6449 - OTHER CONTRACTUAL SERVICE 367,125 377,444 282,953 381,612 400,000 4.82% TOTAL SERVICES & OTHER CHARGES 378,454 382,948 287,395 388,912 406,000 4.39% 6361 - GENERAL LIABILITY INSURANCE 1,437 1,880 1,053 1,584 1,404 -11.36% TOTAL INSURANCE 1,437 1,880 1,053 1,584 1,404 -11.36% TOTAL OPERATING EXPENSES 399,441 385,233 288,458 390,646 407,404 4.29% OPERATING INCOME (LOSS)5,540 9,262 7,849 5,069 (7,404) -246.06% NONOPERATING REVENUES 4603 - INTEREST EARNINGS 4,596 3,309 1,867 1,900 1,600 -15.79% 4605 - UNREALIZED INVESTMENT GAIN/LOSS 1,948 1,500 - - - 0.00% TOTAL INVESTMENT EARNINGS 6,544 4,809 1,867 1,900 1,600 -15.79% NONOPERATING EXPENSES 6471 - ADMINISTRATIVE SERVICE TRANSFER 11,169 11,169 13,373 17,831 18,211 2.13% TOTAL TRANSFERS 11,169 11,169 13,373 17,831 18,211 2.13% NET CHANGE IN FUND BALANCE 915$ 2,902$ (3,657)$ (10,862)$ (24,015)$ 121.09% RECYCLING UTILITY FUND - 65300 PUBLIC UTILITY FUND City of Brooklyn Center Water Utility Cash Flows Revised: 10-6-21 Prior Projected Change 9.00%9.00%9.00%9.00%5.00%3.00%3.00%2.00%0.00%0.00%-2.00%-3.00%-5.00%-5.00%-5.00%-5.00% Rate Change - Proposed 7.00%5.00%9.00%9.00%9.00%7.00%7.00%7.00%2.00%2.00%0.00%0.00%0.00%0.00%0.00%0.00% Average Residential Fee (18,000 Gallons / Per Qtr.)66.47$ 69.82$ 76.07$ 83.00$ 90.44$ 96.70$ 103.43$ 110.64$ 112.81$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ Per Quarter Change 4.33$ 3.35$ 6.25$ 6.93$ 7.44$ 6.26$ 6.73$ 7.21$ 2.17$ 2.18$ -$ -$ -$ -$ -$ -$ Base Charge 16.61$ 17.44$ 19.01$ 20.72$ 22.58$ 24.16$ 25.85$ 27.66$ 28.21$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ Consumption Charge (0-30)2.77$ 2.91$ 3.17$ 3.46$ 3.77$ 4.03$ 4.31$ 4.61$ 4.70$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ Consumption Charge (30-60)3.45$ 3.62$ 3.95$ 4.31$ 4.70$ 5.03$ 5.38$ 5.76$ 5.88$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ Consumption Charge (60+)5.15$ 5.41$ 5.90$ 6.43$ 7.01$ 7.50$ 8.03$ 8.59$ 8.76$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,206,283$ 4,513,482$ 4,722,500$ 5,147,525$ 5,610,802$ 6,003,558$ 6,423,807$ 6,873,474$ 7,010,944$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ 7,151,162$ Investment Earnings 87,134 32,600 32,600 19,701 15,679 18,263 22,205 19,098 23,405 26,021 30,670 27,501 31,074 44,792 66,740 86,434 Nonoperating 74,034 - - - - - - - - - - - - - - - Bond Proceeds (PFA) - - - - - - - - - - - - - - - - Bond Proceeds (GO) 1,825,604 2,600,000 3,800,000 - 4,260,000 1,500,000 - - 1,600,000 - - - - - - - Interfund Loans (Reporting) - - - - - - - - - - - - - - - - Transfers In - - - - - - - - - Total 6,193,055 7,146,082 8,555,100 5,167,226 9,886,481 7,521,822 6,446,013 6,892,572 8,634,349 7,177,184 7,181,832 7,178,663 7,182,237 7,195,954 7,217,903 7,237,597 Expenditures Personal Servcies 610,323 648,502 662,277 682,145 702,610 723,688 745,399 767,761 790,793 814,517 838,953 864,121 890,045 916,746 944,249 972,576 Supplies 316,795 340,510 388,910 396,688 404,622 412,714 420,969 429,388 437,976 446,735 455,670 464,783 474,079 483,561 493,232 503,097 Other Services & Charges 932,051 809,531 643,234 656,099 669,221 682,605 696,257 710,182 724,386 738,874 753,651 768,724 784,099 799,781 815,776 832,092 Insurance 45,435 56,810 56,122 57,244 58,389 59,557 60,748 61,963 63,202 64,467 65,756 67,071 68,412 69,781 71,176 72,600 Utilities 219,288 236,900 236,900 241,638 246,471 251,400 256,428 261,557 266,788 272,124 277,566 283,117 288,780 294,555 300,446 306,455 Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Capital Outlay (CIP) 2,515,184 3,084,574 4,539,724 455,000 4,371,000 1,327,000 820,000 394,000 2,413,000 858,000 2,031,000 1,505,000 514,000 196,000 408,000 1,499,000 Capital Outlay (Other) - 100,000 - - - - - - - - - - - - - - Debt Service (Existing) 1,079,960 1,157,641 1,405,464 1,545,037 1,566,998 1,552,978 1,542,084 1,540,090 1,398,112 1,028,553 674,789 392,138 202,000 - - - Debt Service (PFA) 1,140,130 1,140,310 1,140,390 1,140,370 1,140,250 1,141,030 1,140,700 1,140,270 1,140,740 1,141,100 1,140,350 1,140,350 1,140,350 1,140,350 1,140,350 1,140,350 Debt Service (Projected) - - - 439,811 439,811 932,862 1,108,708 1,108,708 1,108,708 1,296,277 1,296,277 1,296,277 1,296,277 856,466 856,466 363,415 Total 8,659,284 9,374,778 10,873,021 7,414,032 11,399,371 8,883,834 8,591,293 8,213,919 10,143,705 8,460,646 9,334,011 8,581,582 7,458,042 6,557,239 6,829,695 7,489,584 Cash Balance - Beginning 3,844,265 3,135,562 2,706,866 2,188,945 1,742,138 2,029,249 2,467,236 2,121,956 2,600,609 2,891,253 3,407,791 3,055,612 3,452,693 4,976,888 7,415,603 9,603,811 Changes in Accruals (42,591) - - - - - - - - - - - - - - - Revenues 6,193,055 7,146,082 8,555,100 5,167,226 9,886,481 7,521,822 6,446,013 6,892,572 8,634,349 7,177,184 7,181,832 7,178,663 7,182,237 7,195,954 7,217,903 7,237,597 Expenditures (8,659,284) (9,374,778) (10,873,021) (7,414,032) (11,399,371) (8,883,834) (8,591,293) (8,213,919) (10,143,705) (8,460,646) (9,334,011) (8,581,582) (7,458,042) (6,557,239) (6,829,695) (7,489,584) Noncash - Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Cash Balance - Ending 3,135,562$ 2,706,866$ 2,188,945$ 1,742,138$ 2,029,249$ 2,467,236$ 2,121,956$ 2,600,609$ 2,891,253$ 3,407,791$ 3,055,612$ 3,452,693$ 4,976,888$ 7,415,603$ 9,603,811$ 11,151,823$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 City of Brooklyn Center Sanitary Sewer Utility Cash Flows Revised: 10-6-21 5.00% 5.00% 5.00% 5.00% 2.00% 2.00% 2.00% 2.00% 2.00% 1.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Rate Change 5.00%5.00%5.00%5.00%3.00%2.00%2.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.89.14$ 93.59$ 98.27$ 103.19$ 106.28$ 108.41$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ Per Quarter Change 4.24$ 4.46$ 4.68$ 4.91$ 3.10$ 2.13$ 2.17$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,662,342$ 4,895,459$ 5,140,000$ 5,397,000$ 5,558,910$ 5,670,088$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ 5,783,490$ Investment Earnings 152,855 42,600 47,000 31,905 27,096 26,227 26,778 26,440 26,857 24,705 13,121 13,683 9,597 12,151 16,425 18,815 Nonoperating 8,693 - - - - - - - - - - - - - - - Bond Proceeds 1,118,107 1,400,000 1,600,000 - 1,580,000 2,420,000 - - 550,000 - 2,300,000 - - - - - Total 5,941,997 6,338,059 6,787,000 5,428,905 7,166,006 8,116,315 5,810,268 5,809,930 6,360,346 5,808,195 8,096,611 5,797,173 5,793,087 5,795,641 5,799,915 5,802,305 Expenditures Personal Services 270,334 271,719 276,333 284,623 293,162 301,957 311,015 320,346 329,956 339,855 350,050 360,552 371,368 382,509 393,985 405,804 Supplies 26,058 58,475 75,375 76,883 78,420 79,989 81,588 83,220 84,884 86,582 88,314 90,963 93,692 96,503 99,398 102,380 Other Services & Charges 3,034,503 3,042,607 3,089,294 3,151,080 3,214,101 3,278,384 3,343,951 3,410,830 3,479,047 3,548,628 3,619,600 3,691,992 3,765,832 3,841,149 3,917,972 3,996,331 Insurance 21,115 25,371 23,321 23,787 24,263 24,748 25,243 25,748 26,263 26,788 27,324 28,144 28,988 29,858 30,754 31,676 Utilities 36,689 39,100 39,100 39,882 40,680 41,493 42,323 43,170 44,033 44,914 45,812 47,186 48,602 50,060 51,562 53,109 Depreciation 977,861 977,861 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Capital Outlay 3,678,642 3,370,488 2,492,900 1,240,000 2,440,000 2,980,000 461,000 480,000 1,362,000 1,863,000 2,717,000 791,000 220,000 120,000 240,000 590,000 Debt Service (Existing)617,889 743,451 910,599 1,005,807 1,026,854 1,016,645 963,015 776,354 645,010 488,260 484,399 265,169 - - - - Debt Service (Projected)- - - 141,184 145,066 331,924 619,721 623,933 628,260 697,184 701,753 976,077 980,901 800,674 800,674 617,805 Total 8,663,091 8,529,073 7,906,922 6,963,246 8,262,546 9,055,139 6,847,857 6,763,601 7,599,454 8,095,210 9,034,252 7,251,084 6,509,384 6,320,753 6,534,343 6,797,105 Cash Balance - Beginning 6,569,127 4,878,097 3,664,944 3,545,022 3,010,681 2,914,141 2,975,317 2,937,728 2,984,057 2,744,950 1,457,934 1,520,293 1,066,382 1,350,086 1,824,974 2,090,545 Changes in Accruals 52,203 - - - - - - - - - - - - - - - Revenues 5,941,997 6,338,059 6,787,000 5,428,905 7,166,006 8,116,315 5,810,268 5,809,930 6,360,346 5,808,195 8,096,611 5,797,173 5,793,087 5,795,641 5,799,915 5,802,305 Expenditures (8,663,091) (8,529,073) (7,906,922) (6,963,246) (8,262,546) (9,055,139) (6,847,857) (6,763,601) (7,599,454) (8,095,210) (9,034,252) (7,251,084) (6,509,384) (6,320,753) (6,534,343) (6,797,105) Noncash - Depreciation 977,861 977,861 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Cash Balance - Ending 4,878,097$ 3,664,944$ 3,545,022$ 3,010,681$ 2,914,141$ 2,975,317$ 2,937,728$ 2,984,057$ 2,744,950$ 1,457,934$ 1,520,293$ 1,066,382$ 1,350,086$ 1,824,974$ 2,090,545$ 2,095,745$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Capital outlay Cash Balance (ending)Minimum Targeted Balance* City of Brooklyn Center Storm Water Utility Cash Flows Revised: 10-6-21 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Rate Change 3.00% 3.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Residential - Flat Fee / Per Qtr.15.52$ 15.98$ 17.10$ 18.30$ 19.58$ 20.95$ 22.42$ 23.99$ 24.47$ 24.95$ 25.45$ 25.96$ 26.48$ 27.01$ 27.55$ 28.10$ 28.66$ Per Quarter Change 0.45$ 0.47$ 1.12$ 1.20$ 1.28$ 1.37$ 1.47$ 1.57$ 0.48$ 0.49$ 0.50$ 0.51$ 1.53$ 1.56$ 1.59$ 1.62$ 1.65$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Revenues Operating 1,691,946$ 1,742,704$ 1,864,694$ 1,995,222$ 2,134,888$ 2,284,330$ 2,444,233$ 2,615,329$ 2,667,636$ 2,720,989$ 2,775,408$ 2,830,917$ 2,887,535$ 2,945,286$ 3,004,191$ 3,064,275$ 3,125,561$ Investment Earnings 138,112 49,800 43,200 59,825 24,085 29,619 31,156 20,194 25,122 10,795 21,172 38,505 36,135 28,720 38,085 43,887 48,484 Intergovernmental 24,896 305,000 - - - - - - - - - - - - - - - Nonoperating - - - - - - - - - - - - - - - - - Bond Proceeds - 2,200,000 940,000 - 920,000 1,130,000 - - - 2,740,000 1,320,000 - - - - - - Total 1,854,954 4,297,504 2,847,894 2,055,047 3,078,973 3,443,949 2,475,389 2,635,524 2,692,758 5,471,784 4,116,580 2,869,421 2,923,670 2,974,006 3,042,277 3,108,162 3,174,045 Expenditures Personal Servcies 324,114 349,501 350,577 361,094 371,927 383,085 394,578 406,415 418,607 431,165 444,100 457,423 471,146 485,281 499,839 514,834 530,279 Supplies 13,541 49,100 53,600 54,672 55,765 56,881 58,018 59,179 60,362 61,570 62,801 64,057 65,338 66,645 67,978 69,337 70,724 Other Services & Charges 529,352 419,377 434,841 443,538 452,409 461,457 470,686 480,100 489,702 499,496 509,486 519,675 530,069 540,670 551,484 562,513 573,763 Insurance 2,759 3,427 3,018 3,078 3,140 3,203 3,267 3,332 3,399 3,467 3,536 3,607 3,679 3,753 3,828 3,904 3,982 Utilities 2,800 3,800 5,000 5,100 5,202 5,306 5,412 5,520 5,631 5,743 5,858 5,975 6,095 6,217 6,341 6,468 6,597 Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Capital Outlay 2,378,098 3,359,623 1,845,607 2,444,000 1,075,000 1,532,000 1,132,000 350,000 1,610,000 2,952,000 1,430,000 1,129,000 1,446,000 620,000 865,000 1,080,000 2,560,000 Debt Service (existing) 351,397 443,525 525,470 677,050 690,500 697,575 688,675 700,275 574,625 576,275 - - - - - - - Debt Service (projected) - - - 108,795 108,795 216,647 349,118 349,118 349,118 349,118 670,329 825,074 825,074 716,278 716,278 608,426 475,956 Total 5,033,811 6,078,353 4,668,113 5,547,328 4,212,738 4,806,154 4,551,754 3,803,939 4,961,444 6,328,834 4,576,111 4,454,812 4,797,401 3,888,843 4,160,747 4,295,483 5,671,302 Cash Balance - Beginning 5,887,664 4,119,635 3,788,787 3,418,568 1,376,287 1,692,521 1,780,317 1,153,952 1,435,537 616,851 1,209,801 2,200,270 2,064,880 1,641,149 2,176,312 2,507,841 2,770,520 Changes in Accruals (20,922) - - - - - - - - - - - - - - - - Revenues 1,854,954 4,297,504 2,847,894 2,055,047 3,078,973 3,443,949 2,475,389 2,635,524 2,692,758 5,471,784 4,116,580 2,869,421 2,923,670 2,974,006 3,042,277 3,108,162 3,174,045 Expenditures (5,033,811) (6,078,353) (4,668,113) (5,547,328) (4,212,738) (4,806,154) (4,551,754) (3,803,939) (4,961,444) (6,328,834) (4,576,111) (4,454,812) (4,797,401) (3,888,843) (4,160,747) (4,295,483) (5,671,302) Noncash - Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Cash Balance - Ending 4,119,635$ 3,788,787$ 3,418,568$ 1,376,287$ 1,692,521$ 1,780,317$ 1,153,952$ 1,435,537$ 616,851$ 1,209,801$ 2,200,270$ 2,064,880$ 1,641,149$ 2,176,312$ 2,507,841$ 2,770,520$ 1,723,263$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 5,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance - Ending Minimum Targeted Balance* City of Brooklyn Center Street Light Utility Fund Rate Analysis Revised: 10-6-21 Rate Change 0.00%0.00%0.00%0.00%5.00%5.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.6.55$ 6.55$ 6.55$ 6.55$ 6.88$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ Per Quarter Change -$ -$ -$ -$ 0.33$ 0.34$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 449,286$ 449,286$ 460,000$ 460,000$ 483,000$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ 507,150$ Investment Earnings 25,587 8,500 8,200 5,745 3,896 4,259 3,371 2,188 4,725 6,673 9,942 12,978 15,077 17,092 20,072 22,980 Nonoperating - - - - - - - - - - - - - - - - Total 474,873 457,786 468,200 465,745 486,896 511,409 510,521 509,338 511,875 513,823 517,092 520,128 522,227 524,242 527,222 530,130 Expenditures Supplies 481 8,030 8,030 8,191 8,354 8,522 8,692 8,866 9,043 9,224 9,408 9,597 9,789 9,984 10,184 10,388 Other Services & Charges 52,520 71,610 75,731 77,246 78,791 80,366 81,974 83,613 85,285 86,991 88,731 90,506 92,316 94,162 96,045 97,966 Insurance 1,132 1,808 930 949 968 987 1,007 1,027 1,047 1,068 1,090 1,111 1,134 1,156 1,179 1,203 Utilities 182,385 204,000 200,000 204,000 208,080 212,242 216,486 220,816 225,232 229,737 234,332 239,019 243,799 248,675 253,648 258,721 Depreciation 70,101 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Capital Outlay 54,430 608,871 571,662 281,000 170,000 260,000 270,000 50,000 80,000 - 10,000 60,000 60,000 - - - Transfers Out - - - - - - - - - - - - - - - - Total 361,049 974,319 936,353 651,385 546,193 642,116 658,159 444,322 480,608 407,020 423,561 480,232 487,037 433,977 441,057 448,278 Cash Balance - Beginning 917,936 1,152,977 716,444 328,291 222,651 243,355 192,648 125,010 270,026 381,293 568,095 741,626 861,523 976,712 1,146,977 1,313,143 Changes in Accruals 51,116 - - - - - - - - - - - - - - - Revenues 474,873 457,786 468,200 465,745 486,896 511,409 510,521 509,338 511,875 513,823 517,092 520,128 522,227 524,242 527,222 530,130 Expenditures (361,049) (974,319) (936,353) (651,385) (546,193) (642,116) (658,159) (444,322) (480,608) (407,020) (423,561) (480,232) (487,037) (433,977) (441,057) (448,278) Noncash - Depreciation 70,101 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Cash Balance - Ending 1,152,977$ 716,444$ 328,291$ 222,651$ 243,355$ 192,648$ 125,010$ 270,026$ 381,293$ 568,095$ 741,626$ 861,523$ 976,712$ 1,146,977$ 1,313,143$ 1,474,994$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance - Ending Minimum Targeted Balance* City of Brooklyn Center Recycling Fund Rate Analysis Revised: 10-6-21 Rate Change 0.00%0.00%1.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Residential - Flat Fee / Per Qtr.11.98$ 11.98$ 12.10$ 12.34$ 12.59$ 12.84$ 13.09$ 13.36$ 13.62$ 13.90$ 14.17$ 14.46$ Per Quarter Change -$ -$ 0.12$ 0.24$ 0.25$ 0.25$ 0.26$ 0.26$ 0.27$ 0.27$ 0.28$ 0.28$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues Operating 394,495$ 395,715$ 398,440$ 406,409$ 414,537$ 422,828$ 431,284$ 439,910$ 448,708$ 457,682$ 466,836$ 476,173$ Investment Earnings 4,809 1,900 1,600 3,194 3,076 2,953 2,825 2,690 2,550 2,405 2,253 2,094 Total 399,304 397,615 400,040 409,603 417,613 425,781 434,109 442,600 451,259 460,087 469,089 478,267 Expenditures Supplies 405 150 - - - - - - - - - - Other Services & Charges 394,117 406,743 410,810 414,919 423,217 431,681 440,315 449,121 458,104 467,266 476,611 486,143 Insurance 1,880 1,584 1,404 1,418 1,432 1,447 1,461 1,476 1,490 1,505 1,520 1,536 Total 396,402 408,477 412,214 416,337 424,649 433,128 441,776 450,597 459,594 468,771 478,131 487,679 Cash Balance - Beginning 200,047 205,558 194,696 182,521 175,788 168,752 161,405 153,738 145,742 137,406 128,722 119,679 Changes in Accruals 2,609 - - - - - - - - - - - Revenues 399,304 397,615 400,040 409,603 417,613 425,781 434,109 442,600 451,259 460,087 469,089 478,267 Expenditures (396,402) (408,477) (412,214) (416,337) (424,649) (433,128) (441,776) (450,597) (459,594) (468,771) (478,131) (487,679) Noncash - Depreciation - - - - - - - - - - - - Cash Balance - Ending 205,558$ 194,696$ 182,521$ 175,788$ 168,752$ 161,405$ 153,738$ 145,742$ 137,406$ 128,722$ 119,679$ 110,268$ $- $50,000 $100,000 $150,000 $200,000 $250,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Recycling Fund Utility Cash Balance - Ending Public Works Department City Council Work Session, October 18,2021Michael Marsh, Acting Public Works Director and Andrew Splinter, Acting Finance Director Responsibly provide for the maintenance and operations of the City’s infrastructure and facilities in a quality, cost effective manner including: •121 miles of water main, 2,050 valves, 1,000 hydrants, 9,000 metered connections •105 miles sanitary sewer, 9,000 sewer service connections, 10 lift stations •88 miles of storm drains and 100 treatment facilities •270 city-owned ornamental lights, 920 Xcel lights and 100 traffic signal overhead lights Strategic Function –Public Utilities •Water Utility: 1.3 billion gal/yr supplied to customers from 9 wells, 3 water towers, water treatment plant •Sanitary Sewer Utility: Conveyance of 900 million gal/yr of wastewater •Storm Drainage Utility: Maintain approx. 88 miles of drainage pipes, 40 ponds, storm sewer structures •Street Light Utility: Operation of 1300 street lights 2 Public Utilities –Staffing Levels 3 Positions FTEs 2019 2020 2021 Supervisor of Utilities 1 1 1 Engineering Technician 3 (distributed 1/3 over 49141, 49251, 49411) 1 1 1 Maintenance II (4-49141, 2-49251, 2-49411)9 9 9 Part Time/Summer Temporary Employees (3-49141, 2-49251, 1- 49411) 2.0 2.0 2.0 Total 13.0 13.0 13.0 Annual Goals & 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. 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. 4 Utilities Performance Measures 5 Performance Objectives Description of Performance Measure Performance Levels *Actual Value Target Value Billable engineering project staff time and overtime (Grandview North and Interstate projects). 80%>60% Miles of annual street sweeping performed 1459.1 miles (4 Citywide, 10 targeted) >990 miles (4 Citywide rounds, 10 rounds of targeted secondary areas) Miles of annual sanitary sewer televised, cleaned, root-sawed, lined and new pipe 26 >= 19.6 miles (1/5 of the City’s total 97.9 miles) Private sanitary sewer backups per year (due to City system blockage) 0 0 Drinking Water Regulated Substances: Copper Lead Barium Trihalomethanes Haloacetic Acids Total Chlorine Flouride No violation No violation No violation No violation No violation No violation No violation No violations Key Initiatives 6 •2022 CIP •Woodbine area Improvements •Well 7 and WTP HSP 1 Rehabilitation •Lift Station 4 Rehabilitation •I-94 & Dupont 24” steel water main replacement •Water treatment plant redundant water main connection •Freeway and Highway utility crossing replacements •Storm water pond rehab •Storm pickup plow addition •Public Works facility needs survey •Forklift purchase 7 Comparative Cities’ Utility Rates 8 Comparative Cities’ Utility Rates 9 Cash Flow/Rate Projections •Assumptions for Cash Flow/Rate Projections •Includes capital outlay based on 15 –year CIP •Anticipated debt issues include: •Water G.O. Revenue Bonds –2021, 2022, 2024, 2025, 2028 •Sanitary Sewer G.O. Revenue Bonds –2021, 2022, 2024, 2025, 2028, 2030 •Storm Sewer G.O. Revenue Bonds –2021, 2022, 2029, 2030 •3% annual increase in personal services, 2% annual increase in operating expenses 10 Water Utility Rate & Cash 11 Water Utility Cash Flow - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance - Ending Minimum Targeted Balance* Water Utility Rate Comparison 12 $- $20.00 $40.00 $60.00 $80.00 $100.00 $120.00 $140.00 $160.00 $49.16 $69.82 $70.72 $76.07 $83.49 $90.19 $101.17 $96.64 $134.90 $152.94 $158.85 Residential Cost of 18,000 Gallons of Water per Quarter for 2021 Proposed Bond Issue (Water) 13 •Proposed debt issue for $3.8 million of infrastructure improvements identified in the CIP •Annual payments of approximately $400,000 beginning in 2023 (10 years at approximately 2.00%) •Allow the City to smooth rate increases over a period of time Sanitary Sewer Utility Rate/Cash Flow 14 Sanitary Sewer Utility Cash Flow 15 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance (ending)Minimum Targeted Balance* Proposed Bond Issue (Sewer) 16 •Proposed debt issue for $1.6 million of infrastructure improvements identified in the CIP for Grandview Area South Neighborhood reconstruction project. •Annual payments of approximately $170,000 beginning in 2022 (10 years at 2.00%) •Allows the City to smooth rate increases over a period of time Sanitary Sewer Utility Rate Comparison 17 $- $20.00 $40.00 $60.00 $80.00 $100.00 $120.00 $140.00 $79.89 $89.36 $91.36 $93.59 $98.27 $99.65 $104.19 $104.19 $108.54 $115.60 $144.13 Residential Cost of 18,000 Gallons of Sanitary Sewer per Quarter for 2021 Storm Water Utility Rate/Cash Flow 18 Storm Water Utility Cash Flow 19 - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance - Ending Minimum Targeted Balance* Proposed Bond Issue 20 •Proposed debt issue for $940 thousand of infrastructure improvements identified in the CIP. •Annual payments of approximately $100,000 beginning in 2023 (10 years at 2.00%) •Allows the City to smooth rate increases over a period of time Storm Sewer Utility Rate Comparison 21 $- $5.00 $10.00 $15.00 $20.00 $25.00 $30.00 $35.00 Fridley Roseville Brooklyn Center - 2021 Brooklyn Center - 2022 Crystal Richfield Golden Valley New Hope Maplewood Shoreview $9.85 $14.25 $15.52 $15.98 $20.15 $20.35 $25.00 $25.08 $27.25 $32.30 Residential Storm Water Charge per Quarter for 2020 22 Comparative Cities’ Utility Rates Water, Sewer, Storm Water Rate Comparison 23 $- $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 2021 Residential Quarterly total Water, Sewer, and Storm Utility Bill (18,000 gallons) Street Light Utility Rate/ Cash Flow 24 Street Light Utility Cash Flow 25 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital outlay Cash Balance - Ending Minimum Targeted Balance* Street Light Utility Rate Comparison 26 $- $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 $14.00 $16.00 Crystal New Hope Richfield Brooklyn Center - 2020 Brooklyn Center - 2021 Golden Valley Shoreview $5.00 $5.70 $5.77 $6.55 $6.55 $12.42 $14.31 Residential Street Light Charge per Quarter for 2021 Recycling Utility Rate/Cash Flow 27 Recycling Utility Rate Comparison 28 $- $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 $14.00 $16.00 $18.00 $20.00 Roseville Fridley Crystal New Hope Brooklyn Center - 2020 Brooklyn Center - 2021 Maplewood Golden Valley $9.00 $9.83 $11.25 $11.25 $11.98 $11.98 $13.25 $16.00 Residential Recycling Charge per Quarter for 2021 Questions? 29 Technology Capital Project Fund 30 Technology Fund Cash Flow Chart 31 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Technology Fund Expenditures Cash Balance - Ending Questions? 32