The URL can be used to link to this page

Home My WebLink About2013 10-21 CCP Joint Work Session with Financial CommissionAGENDA CITY COUNCIL/FINANCIAL COMMISION JOINT WORK SESSION October 21, 2013 6:30 p.m. City Hall Council Chambers 1.Call to Order 2.Enterprise Funds a.Earle Brown Heritage Center Fund b.Centerbrook Golf Course c.BC Liquor Fund d.Utilities and Fees i.Water Utility ii.Sanitary Sewer Utility iii.Storm Sewer Utility iv.Streetlight Utility v. Recycling Utility 3.Miscellaneous 4.Remaining Actions i. General Fund Departments November 18 th , 2013 (proposed) Budget Hearing December 2, 2013 Budget Adoption December 9, 2013 5.Adjournment 2014 Brooklyn Center Department Budget Narrative by Fund Department Name: Community Activities, Recreation & Services Earle Brown Heritage Center Department/Division Mission: To deliver a high quality customer experience by providing exceptional customer service and extraordinary food service in an uncommon setting. Department/Division Description: Earle Brown Heritage Center is comprised of the Convention Center with Administrative Services, Catering Services and Commercial Office Rentals. These Divisions provide for the provision of maintenance, conference services, custodial functions, development, preparing, equipment servicing, and serving of food and beverage for events at Earle Brown Heritage Center. Maintenance of buildings and grounds of the commercial office spaces/buildings located at Earle Brown Heritage Center for 3 tenants. A management agreement with Flik International for the food and beverage is currently in place through the year 2014. Staffing Levels Positions FTEs 2013 2014 2015 •EBHC Manager 1 1 1 Secretary/Receptionist 1 1 1 Secretary/Billing Clerk 1 1 1 Operations Director 1 1 1 Sales Director 1 1 1 •Sales Managers 2 3 3 •Maintenance Custodian •Crew Chiefs Part-time Staff• 2 2 8 2 2 8 2 2 9 Total 19 20 21 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, food and beverage, audio visual equipment and special request 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 2014 Marketing Plan. a.Participate in five industry associations to network for business b.Add a minimum of 15 new corporate clients c. Work with Flik International, Embassy Suites, Minneapolis Northwest, 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 Goal Performance Measures: 1. Results/Effectiveness Measures •Business tracking of corporate clients •Customer satisfaction ratings 2. Efficiency Measure •Energy consumption •Per quart measurement of food waste 3. Productivity Measure •Average revenue per corporate event •Food and beverage revenue per wedding CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 61700 - EARLE BROWN HERITAGE CENTER 49851 - EBHC-ADMINISTRATION 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -6,698 -4,886 -2,208 0 -4,500 -4,500 4604 CHECK PROCESSING FEES -30 -30 0 4605 UNREALIZED INVESTMENT GAIN/LOSS -1,660 1,055 0 4606 OTHER REVENUE 0 -5,000 -18,126 4600 MISCELLANEOUS REVENUE -8,388 -8,861 -20,334 0 -4,500 -4,500 4599 MISCELLANEOUS REVENUE -8,388 -8,861 -20,334 0 -4,500 -4,500 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS -10,557 -15,261 0 4921 REFUNDS & REIMBURSEMENTS 0 -5,964 -25 4900 OTHER FINANCING SOURCES -10,557 -21,225 -25 4001 REVENUES -18,945 -30,085 -20,359 0 -4,500 -4,500 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 154,753 160,024 121,729 168,031 174,617 178,109 6102 OVERTIME-FT EMPLOYEES 471 46 198 6103 WAGES-PART TIME EMPLOYEES 0 6100 WAGES AND SALARIES 155,224 160,070 121,927 168,031 174,617 178,109 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 1,807 2,580 0 6110 OTHER PAYMENTS-NON INSURANCE 1,807 2,580 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 11,254 11,605 8,840 12,182 12,659 12,913 6125 FICA 9,805 10,342 7,769 10,418 10,826 11,043 6126 MEDICARE CONTRIBUTIONS 2,293 2,419 1,817 2,437 2,532 2,583 6120 RETIREMENT CONTRIBUTIONS 23,352 24,366 18,426 25,037 26,017 26,539 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 27,692 26,337 19,598 32,364 34,629 37,054 6130 INSURANCE BENEFITS 27,692 26,337 19,598 32,364 34,629 37,054 6150 WORKERS' COMPENSATION 6151 WORKERS' COMPENSATION 1,296 1,364 825 1,394 1,450 1,508 6150 WORKER'S COMPENSATION 1,296 1,364 825 1,394 1,450 1,508 6099 PERSONAL SERVICES 209,372 214,717 160,775 226,826 236,713 243,210 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 0 0 0 0 6200 OFFICE SUPPLIES 0 0 0 0 6210 OPERATING SUPPLIES 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 155 0 0 6220 REPAIR & MAINT SUPPLIES 155 0 0 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 1,690 3,109 0 2,000 2,000 2,000 6243 MINOR COMPUTER EQUIPMENT 834 843 2,258 1,000 1,750 6240 SMALL TOOLS & MINOR EQUIPMENT 2,523 3,953 2,258 3,000 3,750 2,000 6199 SUPPLIES 2,523 4,108 2,258 3,000 3,750 2,000 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 3,345 2,391 2,675 3,400 3,400 3,400 6303 LEGAL SERVICES 0 0 0 500 500 500 6307 PROFESSIONAL SERVICES 3,480 2,030 2,912 2,500 2,500 2,500 6300 PROFESSIONAL SERVICES 6,825 4,421 5,586 6,400 6,400 6,400 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 900 900 600 900 900 920 6320 COMMUNICATIONS 900 900 600 900 900 920 6340 ADVERTISING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 2,623 2,636 302 3,260 3,490 803 6362 PROPERTY INSURANCE 8,314 8,182 2,936 10,160 10,875 7,811 6366 MACHINERY BREAKDOWN INSURANCE 463 483 261 600 640 694 6360 INSURANCE 11,400 11,301 3,499 14,020 15,005 9,308 6400 REPAIR & MAINT SERVICES 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 294 0 519 6422 SOFTWARE MAINT 4,856 5,240 6,441 5,500 6,700 6,700 6423 LOGIS CHARGES 17,690 18,846 15,813 24,684 22,119 22,170 6420 IS SERVICES/LICENSES/FEES 22,840 24,086 22,773 30,184 28,819 28,870 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 2,195 1,729 1,342 2,800 3,000 3,200 6430 MISCELLANEOUS 2,195 1,729 1,342 2,800 3,000 3,200 6440 OTHER EXPENSES 6442 COURT AWARDS/SETTLEMENTS 1,581 0 0 6440 OTHER EXPENSES 1,581 0 0 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 74,656 83,036 63,864 85,152 87,700 6476 CAPITAL PROJECT FUND TRANSFER 200,000 0 400,000 200,000 200,000 200,000 6470 TRANSFERS AND OTHER USES 274,656 83,036 463,864 285,152 287,700 200,000 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 25,771 26,265 20,789 30,790 30,790 6490 OTHER MISC COSTS/EXPENSES 25,771 26,265 20,789 30,790 30,790 6299 OTHER CHARGES & SERVICES 346,169 151,738 518,454 370,246 372,614 248,698 6001 EXPENDITURES/EXPENSES 558,064 370,563 681,486 600,072 613,077 493,908 4000 REVENUES AND EXPENSES 539,119 340,477 661,127 600,072 608,577 489,408 49851 - EBHC-ADMINISTRATION 539,119 340,477 661,127 600,072 608,577 489,408 49852 - EBHC-CONVENTION CENTER 4000 REVENUES AND EXPENSES CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4604 CHECK PROCESSING FEES 0 -30 0 4606 OTHER REVENUE -2,306 -370 -176 4609 UNCOLLECTIBLE WRITE OFF 0 0 0 4600 MISCELLANEOUS REVENUE -2,306 -400 -176 4599 MISCELLANEOUS REVENUE -2,306 -400 -176 4800 EBHC 4820 CONVENTION CENTER 4821 ROOM RENTALS -604,105 -646,684 -465,590 -725,000 -730,000 -735,000 4821.1 CMP ROOM RENTALS 0 0 0 0 4822 LABOR CHARGES -19,770 -23,193 -18,687 -13,000 -24,000 -25,000 4823 EQUIPMENT RENTALS -338,540 -391,280 -261,010 -350,000 -370,000 -380,000 4823.1 CMP EQUIPMENT RENTALS 0 0 0 0 4825 COMMON AREA MTNCE -14,152 -8,199 -13,063 -13,063 -13,063 4827 SECURITY SERVICES -26,608 -28,625 -13,150 -26,000 -26,000 -28,000 4828 CLIENT SERVICES -46,391 -59,699 -41,991 -55,000 -60,000 -63,000 4829 MISCELLANEOUS -2,535 -7,180 -2,340 -6,000 -4,500 -4,500 4820 CONVENTION CENTER -1,037,950 -1,170,812 -810,966 -1,188,063 -1,227,563 -1,248,563 4800 EBHC -1,037,950 -1,170,812 -810,966 -1,188,063 -1,227,563 -1,248,563 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS -780,431 4921 REFUNDS & REIMBURSEMENTS -60,227 -7,396 0 4900 OTHER FINANCING SOURCES -840,658 -7,396 0 4001 REVENUES -1,880,914 -1,178,608 -811,143 -1,188,063 -1,227,563 -1,248,563 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 338,921 349,943 256,286 393,973 454,713 463,807 6102 OVERTIME-FT EMPLOYEES 347 1,817 916 0 1,000 1,000 6103 WAGES-PART TIME EMPLOYEES 120,870 109,872 83,995 134,000 139,000 143,170 6104 OVERTIME-PART TIME EMPLOYEES 52 22 95 0 6100 WAGES AND SALARIES 460,190 461,653 341,292 527,973 594,713 607,977 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 3,259 4,865 4,830 6110 OTHER PAYMENTS-NON INSURANCE 3,259 4,865 4,830 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 31,930 32,992 24,250 28,564 32,967 33,626 6125 FICA 29,274 30,242 21,825 32,470 36,810 37,632 6126 MEDICARE CONTRIBUTIONS 6,847 7,075 5,105 5,711 8,609 8,801 6120 RETIREMENT CONTRIBUTIONS 68,051 70,308 51,180 66,745 78,386 80,059 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 76,897 71,859 55,125 86,304 101,873 98,809 6130 INSURANCE BENEFITS 76,897 71,859 55,125 86,304 101,873 98,809 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPOLOYMENT COMPENSATION 2,310 1,792 1,287 6140 UNEMPLOYMENT COMPENSATION 2,310 1,792 1,287 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6150 WORKERS COMPENSATION 6151 WORKERS' COMPENSATION 15,600 16,070 11,857 12,011 12,786 13,617 6150 WORKERS COMPENSATION 15,600 16,070 11,857 12,011 12,786 13,617 6099 PERSONAL SERVICES 626,307 626,547 465,572 693,033 787,758 800,462 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 1,733 1,258 611 1,900 1,300 1,500 6202 COPYING SUPPLIES 1,086 969 592 1,500 1,500 1,500 6203 BOOKS/REFERENCE MATERIALS 25 0 0 100 100 100 6200 OFFICE SUPPLIES 2,843 2,228 1,203 3,500 2,900 3,100 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 1,562 1,139 1,218 4,500 4,500 5,000 6212 MOTOR FUELS 61 83 0 150 200 200 6214 CLOTHING & PERSONAL EQUIPMENT 827 309 627 1,000 1,000 1,000 6215 SHOP MATERIALS 518 165 113 600 600 600 6216 CHEMICALS/CHEMICAL PRODUCTS 3,975 5,454 1,744 5,400 5,500 5,500 6217 SAFETY SUPPLIES 573 767 399 800 800 800 6219 GENERAL OPERATING SUPPLIES 27,750 25,489 15,836 30,000 31,000 32,000 6210 OPERATING SUPPLIES 35,265 33,405 19,938 42,450 43,600 45,100 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 17,232 17,444 12,684 20,000 22,000 22,000 6225 PARK & LANDSCAPE MATERIALS 1,657 1,802 1,897 7,500 5,600 5,600 6226 SIGNS & STRIPING MATERIALS 268 0 0 300 300 300 6227 PAINT SUPPLIES 1,646 2,161 998 2,500 2,500 2,500 6220 REPAIR & MAINT SUPPLIES 20,803 21,407 15,579 30,300 30,400 30,400 6230 REPAIR & MAINT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 97 79 0 80 80 80 6239 OTHER REPAIR & MAINT SUPPLIES 5,437 8,146 5,651 6,000 8,000 8,000 6230 REPAIR & MAINT SUPPLIES-OTHER 5,534 8,226 5,651 6,080 8,080 8,080 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 1,154 1,183 495 1,200 1,200 1,200 6242 MINOR EQUIPMENT 40,226 17,902 3,741 41,534 41,534 42,000 6243 MINOR COMPUTER EQUIPMENT 0 13,905 10,592 27,550 28,695 0 6240 SMALL TOOLS & MINOR EQUIPMENT 41,380 32,990 14,828 70,284 71,429 43,200 6199 SUPPLIES 105,825 98,255 57,199 152,614 156,409 129,880 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6303 LEGAL SERVICES 33 0 0 6307 PROFESSIONAL SERVICES 40,356 12,631 7,958 23,075 11,400 19,000 6300 PROFESSIONAL SERVICES 40,389 12,631 7,958 23,075 11,400 19,000 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 4,135 4,054 3,934 7,135 7,880 7,820 6322 POSTAGE 1,469 515 782 2,500 2,500 2,500 6329 OTHER COMMUNICATION SERVICES -340 0 0 6320 COMMUNICATIONS 5,604 4,229 4,715 9,635 10,380 10,320 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 869 967 491 1,000 1,000 1,000 6333 FREIGHT/DRAYAGE 259 507 54 900 500 500 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6330 TRANSPORTATION 1,128 1,474 545 1,900 1,500 1,500 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 912 745 259 1,300 800 800 6349 OTHER ADVERTISING 28,977 43,216 34,994 58,073 70,050 70,050 6340 ADVERTISING 29,889 43,961 35,253 59,373 70,850 70,850 6350 PRINTING AND DUPLICATING 6351 PRINTING 6,486 7,327 419 7,500 7,500 7,500 6350 PRINTING AND DUPLICATING 6,486 7,327 419 7,500 7,500 7,500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 5,841 5,742 2,749 6,900 7,420 3,501 6362 PROPERTY INSURANCE 10,309 10,146 3,640 12,600 13,480 9,686 6366 MACHINERY BREAKDOWN INSURANCE 574 599 324 740 790 861 6360 INSURANCE 16,724 16,488 6,713 20,240 21,690 14,048 6380 UTILITY SERVICES 6381 ELECTRIC 108,680 107,677 85,758 103,000 105,000 107,000 6382 GAS 17,219 14,388 15,081 27,000 27,000 27,000 6383 WATER 1,165 1,609 886 1,600 1,800 2,000 6384 REFUSE DISPOSAL 1,532 1,496 1,252 2,100 2,100 2,200 6385 SEWER 1,978 2,647 1,476 3,000 3,400 3,600 6386 STORM SEWER 1,553 2,092 1,215 3,000 3,400 3,600 6389 STREET LIGHTS 282 379 344 600 600 600 6380 UTILITY SERVICES 132,410 130,288 106,010 140,300 143,300 146,000 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 31,135 26,197 41,684 37,800 39,200 40,000 6403 BLDGS/FACILITIES MAINT SERVICE 2,611 1,902 1,427 3,000 3,000 3,000 6406 MULTI-FUNCTION MTNCE 351 1,343 1,098 2,500 2,000 2,100 6408 COMMUNICATION/INFOR SYSTEMS 81 0 0 6409 OTHER REPAIR & MAINT SERVICES 0 0 0 0 6400 REPAIR & MAINT SERVICES 34,178 29,442 44,208 43,300 44,200 45,100 6410 RENTALS 6413 OFFICE EQUIPMENT 3,621 2,175 641 2,300 2,300 2,300 6415 OTHER EQUIPMENT 156,977 194,676 106,129 150,000 195,000 195,000 6419 OTHER RENTAL EXPENSE -1,539 0 0 6410 RENTALS 159,059 196,851 106,770 152,300 197,300 197,300 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 0 160 0 600 6428 PROTECTION SERVICES 19,707 17,533 10,046 18,000 19,000 19,000 6420 IS SERVICES/LICENSES/FEES 19,707 17,693 10,046 18,000 19,600 19,000 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 4,457 2,284 415 5,500 5,500 5,500 6433 MEETING EXPENSES 498 433 375 900 900 900 6434 DUES & SUBSCRIPTIONS 2,671 2,898 2,133 3,000 3,000 3,000 6435 CREDIT CARD FEES 3,176 2,675 2,594 3,000 3,000 3,000 6436 UNCOLLECTIBLE CHECKS/DEBTS -829 733 0 6438 CASH SHORT (OVER)-55 17 -7 6430 MISCELLANEOUS 9,917 9,041 5,511 12,400 12,400 12,400 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 200 200 200 6449 OTHER CONTRACTUAL SERVICES 17,352 12,953 11,959 21,400 21,400 21,400 6451 MTG PLANNER POINTS-EBHC 2,894 0 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6440 OTHER EXPENSES 17,552 16,047 12,159 21,400 21,400 21,400 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 303,429 336,326 251,555 325,000 325,000 6490 OTHER MISC COSTS/EXPENSES 303,429 336,326 251,555 325,000 325,000 6299 OTHER CHARGES & SERVICES 776,472 821,799 591,863 834,423 886,520 564,418 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6520 BUILDINGS & FACILITIES 61,510 0 0 6540 EQUIPMENT & MACHINERY 5,049 0 0 6501 CAPITAL OUTLAY 66,559 0 0 6500 CAPITAL OUTLAY 66,559 0 0 6001 EXPENDITURES/EXPENSES 1,575,163 1,546,601 1,114,634 1,680,070 1,830,687 1,494,760 4000 REVENUES AND EXPENSES -305,751 367,993 303,491 492,007 603,124 246,197 49852- EBHC-CONVENTION CENTER -305,751 367,993 303,491 492,007 603,124 246,197 49853 - EBHC-CATERING OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4606 OTHER REVENUE 0 0 -1,995 4609 UNCOLLECTIBLE WRITE OFF 0 0 0 4600 MISCELLANEOUS REVENUE 0 0 -1,995 4599 MISCELLANEOUS REVENUE 0 0 -1,995 4800 EBHC 4840 CATERING SERVICES 4842 SERVICE CHARGES -464,359 -498,368 -337,711 -495,050 -495,350 -510,097 4844 FOOD & BEVERAGE SALES -2,170,033 -2,280,226 -1,579,982 -2,338,400 -2,338,400 -2,409,634 4845 LIQUOR/WINE/BEER SALES -308,170 -363,040 -209,943 -319,750 -319,750 -329,095 4848 MISCELLANEOUS SALES -42,548 -39,996 -32,315 -41,550 -41,550 -42,050 4840 CATERING SERVICES -2,985,109 -3,181,630 -2,159,950 -3,194,750 -3,195,050 -3,290,876 4800 EBHC -2,985,109 -3,181,630 -2,159,950 -3,194,750 -3,195,050 -3,290,876 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS -87,058 4921 REFUNDS & REIMBURSEMENTS 0 -9,543 -1,771 4900 OTHER FINANCING SOURCES -87,058 -9,543 -1,771 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES-LABOR 1,265,168 1,299,077 762,547 1,302,817 1,302,817 1,340,708 5592 COST OF SALES-FOOD 571,750 634,827 365,224 604,622 617,488 634,153 5593 COST OF SALES-SUPPLIES 139,721 148,469 89,871 142,658 142,658 148,093 5594 COST OF SALES-MGMT FEES 108,600 111,600 91,400 114,600 117,600 120,600 5590 EBHC CONTRACT EXPENSES 2,085,239 2,193,973 1,309,042 2,164,697 2,180,563 2,243,554 5550 DIRECT COST OF SALES 2,085,239 2,193,973 1,309,042 2,164,697 2,180,563 2,243,554 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 4001 REVENUES -986,928 -997,200 -854,674 -1,030,053 -1,014,487 -1,047,322 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 24,788 20,839 13,881 6102 OVERTIME-FT EMPLOYEES 0 987 323 6103 WAGES-PART TIME EMPLOYEES 43,855 41,721 23,304 50,100 51,600 51,600 6104 OVERTIME-PART TIME EMPLOYEES 15 0 0 6100 WAGES AND SALARIES 68,658 63,547 37,508 50,100 51,600 51,600 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 3,875 4,266 2,510 3,500 3,600 3,741 6125 FICA 4,273 4,078 2,397 3,100 3,175 3,199 6126 MEDICARE CONTRIBUTIONS 999 953 560 750 775 748 6120 RETIREMENT CONTRIBUTIONS 9,147 9,297 5,467 7,350 7,550 7,688 6150 WORKERS' COMPENSATION 6151 WORKERS' COMPENSATION 3,143 3,035 1,848 2,000 2,000 2,549 6150 WORKER'S COMPENSATION 3,143 3,035 1,848 2,000 2,000 2,549 6099 PERSONAL SERVICES 80,948 75,879 44,823 59,450 61,150 61,837 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 1,005 1,177 567 1,300 1,300 1,300 6202 COPYING SUPPLIES 660 824 592 900 900 900 6200 OFFICE SUPPLIES 1,665 2,002 1,159 2,200 2,200 2,200 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 204 0 0 292 292 300 6214 CLOTHING & PERSONAL EQUIPMENT 32 11 21 40 40 40 6215 SHOP MATERIALS 48 48 48 6216 CHEMICALS/CHEMICAL PRODUCTS 269 338 330 300 350 350 6217 SAFETY SUPPLIES 413 182 201 648 550 550 6219 GENERAL OPERATING SUPPLIES 199 214 0 500 500 500 6210 OPERATING SUPPLIES 1,117 744 552 1,828 1,780 1,788 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 2,210 1,407 3,173 3,000 4,000 4,000 6227 PAINT SUPPLIES 0 0 0 100 100 100 6220 REPAIR & MAINT SUPPLIES 2,210 1,407 3,173 3,100 4,100 4,100 6230 REPAIR & MAINT SUPPLIES-OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 1,510 522 17 1,500 1,500 1,500 6230 REPAIR & MAINT SUPPLIES-OTHER 1,510 522 17 1,500 1,500 1,500 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 12 0 10 6242 MINOR EQUIPMENT 19,516 25,850 21,321 24,000 29,750 30,000 6243 MINOR COMPUTER EQUIPMENT 1,686 12,970 2,788 1,650 5,250 1,785 6240 SMALL TOOLS & MINOR EQUIPMENT 21,214 38,819 24,120 25,650 35,000 31,785 6199 SUPPLIES 27,716 43,494 29,020 34,278 44,580 41,373 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 0 6,455 16,042 16,575 11,400 19,000 CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6300 PROFESSIONAL SERVICES 0 6,455 16,042 16,575 11,400 19,000 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 936 936 975 1,756 1,680 1,715 6322 POSTAGE 326 611 218 400 400 400 6320 COMMUNICATIONS 1,262 1,547 1,194 2,156 2,080 2,115 6330 TRANSPORTATION 6333 FREIGHT/DRAYAGE 0 0 0 0 6330 TRANSPORTATION 0 0 0 0 6340 ADVERTISING 6349 OTHER ADVERTISING 45,321 44,485 35,945 53,462 67,500 67,500 6340 ADVERTISING 45,321 44,485 35,945 53,462 67,500 67,500 6350 PRINTING AND DUPLICATING 6351 PRINTING 8,840 8,523 3,558 6,200 6,200 6,200 6350 PRINTING AND DUPLICATING 8,840 8,523 3,558 6,200 6,200 6,200 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 4,536 4,664 2,417 5,760 6,170 6,431 6362 PROPERTY INSURANCE 13,302 13,092 4,697 15,195 16,250 12,498 6364 DRAM SHOP INSURANCE 950 0 6366 MACHINERY BREAKDOWN INSURANCE 740 773 418 0 1,010 1,111 6360 INSURANCE 18,578 18,529 7,532 21,905 23,430 20,040 6380 UTILITY SERVICES 6381 ELECTRIC 19,965 19,710 15,738 26,000 26,000 26,000 6382 GAS 16,903 14,118 14,818 30,000 30,000 30,000 6383 WATER 1,161 1,689 1,006 2,400 2,400 2,400 6384 REFUSE DISPOSAL 6,651 5,970 4,913 7,000 7,000 7,000 6385 SEWER 2,296 2,547 1,407 2,500 2,500 2,500 6386 STORM SEWER 1,601 1,308 1,057 1,600 1,600 1,600 6389 STREET LIGHTS 282 393 338 600 600 600 6380 UTILITY SERVICES 48,859 45,734 39,277 70,100 70,100 70,100 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 16,796 17,902 12,556 20,000 21,000 21,000 6403 BLDGS/FACILITIES MAINT SERVICE 2,062 1,902 1,110 2,500 2,500 2,500 6406 MULTI-FUNCTION MTNCE 488 489 1,000 800 800 6409 OTHER REPAIR & MAINT SERVICES 1,308 1,308 872 1,404 1,404 1,450 6400 REPAIR & MAINT SERVICES 20,166 21,600 15,026 24,904 25,704 25,750 6410 RENTALS 6413 OFFICE EQUIPMENT 2,420 1,173 0 2,400 2,400 2,400 6415 OTHER EQUIPMENT 0 0 0 500 500 500 6410 RENTALS 2,420 1,173 0 2,900 2,900 2,900 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,494 500 175 1,500 1,500 1,500 6434 DUES & SUBSCRIPTIONS 0 0 0 70 70 70 6435 CREDIT CARD FEES 19,686 20,587 13,451 20,000 21,000 22,000 6436 UNCOLLECTIBLE CHECKS/DEBTS -2,092 3,393 0 0 6438 CASH SHORT (OVER)-45 -64 -55 6430 MISCELLANEOUS 19,043 24,416 13,571 21,570 22,570 23,570 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 0 0 35 6449 OTHER CONTRACTUAL SERVICES 7,530 5,761 5,767 9204,9,204 9,204 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6440 OTHER EXPENSES 7,530 5,761 5,802 9,204 9,204 9,204 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 160,859 167,131 125,006 177,800 182,000 6490 OTHER MISC COSTS/EXPENSES 160,859 167,131 125,006 177,800 182,000 6299 OTHER CHARGES & SERVICES 332,879 345,354 262,951 406,776 423,088 246,379 6001 EXPENDITURES/EXPENSES 441,544 464,727 336,795 500,504 528,818 349,589 4000 REVENUES AND EXPENSES -545,385 -532,472 -517,879 -529,549 -485,669 -697,733 49853 - EBHC-CATERING OPERATIONS -545,385 -532,472 -517,879 -529,549 -485,669 -697,733 49854 - EBHC-OFFICE RENTAL 4000 REVENUES AND EXPENSES 4001 REVENUES 4800 EBHC 4830 OFFICE RENTAL 4831 OFFICE RENTALS -25,680 -105,630 -72,470 -99,487 -96,270 -96,270 4830 OFFICE RENTAL -25,680 -105,630 -72,470 -99,487 -96,270 -96,270 4800 EBHC -25,680 -105,630 -72,470 -99,487 -96,270 -96,270 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 0 -954 0 4900 OTHER FINANCING SOURCES 0 -954 0 4001 REVENUES -25,680 -106,584 -72,470 -99,487 -96,270 -96,270 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 371 721 4,270 0 6102 OVERTIME-FT EMPLOYEES 66 6103 WAGES-PART TIME EMPLOYEES 2,325 2,306 4,188 3,296 4,296 4,300 6100 WAGES AND SALARIES 2,696 3,027 8,525 3,296 4,296 4,300 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 197 219 579 231 238 312 6125 FICA 167 189 546 202 208 267 6126 MEDICARE CONTRIBUTIONS 39 43 128 50 51 62 6120 RETIREMENT CONTRIBUTIONS 403 451 1,253 483 497 641 6150 WORKERS' COMPENSATION 6151 WORKERS' COMPENSATION 128 150 420 210 218 212 6150 WORKER'S COMPENSATION 128 150 420 210 218 212 6099 PERSONAL SERVICES 3,227 3,628 10,198 3,989 5,011 5,153 6199 SUPPLIES 6210 OPERATING SUPPLIES 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 870 42 3,980 1,000 1,000 1,000 6225 PARK & LANDSCAPE MATERIALS 300 300 300 6226 SIGNS & STRIPING MATERIALS 180 0 33 150 150 150 6227 PAINT SUPPLIES 0 0 325 150 150 150 6220 REPAIR & MAINT SUPPLIES 1,049 42 4,338 1,600 1,600 1,600 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6230 REPAIR & MAINT SUPPLIES-OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 9 6230 REPAIR & MAINT SUPPLIES-OTHER 9 6240 SMALL TOOLS & MINOR EQUIPMENT 6243 MINOR COMPUTER EQUIPMENT 9,389 6240 SMALL TOOLS & MINOR EQUIPMENT 9,389 6199 SUPPLIES 1,049 42 13,736 1,600 1,600 1,600 6299 OTHER CHARGES & SERVICES 6340 ADVERTISING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 450 471 41 576 602 107 6362 PROPERTY INSURANCE 1,330 1,309 470 1,580 1,620 1,250 6366 MACHINERY BREAKDOWN INSURANCE 74 77 42 92 101 111 6360 INSURANCE 1,855 1,858 552 2,248 2,323 1,468 6380 UTILITY SERVICES 6381 ELECTRIC 5,498 5,170 4,645 6,000 6,400 7,000 6382 GAS 4,745 4,544 4,922 7,400 7,800 7,800 6383 WATER 320 372 238 500 600 700 6384 REFUSE DISPOSAL 684 684 795 700 700 700 6385 SEWER 485 518 301 600 600 600 6380 UTILITY SERVICES 11,732 11,288 10,901 15,200 16,100 16,800 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 171 3,773 16,054 2,000 3,500 3,500 6403 BLDGS/FACILITIES MAINT SERVICE 141 0 3,500 150 150 150 6400 REPAIR & MAINT SERVICES 312 3,773 19,554 2,150 3,650 3,650 6420 IS SERVICES/LICENSES/FEES 6423 LOGIS CHARGES 0 6420 IS SERVICES/LICENSES/FEES 0 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 5,541 5,937 4,686 6,000 6,000 6,000 6449 OTHER CONTRACTUAL SERVICES 6,684 5,127 4,876 6,600 6,750 6,750 6440 OTHER EXPENSES 12,225 11,064 9,563 12,600 12,750 12,750 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 142,427 142,817 106,820 152,000 160,300 6490 OTHER MISC COSTS/EXPENSES 142,427 142,817 106,820 152,000 160,300 6299 OTHER CHARGES & SERVICES 168,550 170,800 147,390 184,198 195,123 34,668 6001 EXPENDITURES/EXPENSES 172,826 174,470 171,324 189,787 201,734 41,421 4000 REVENUES AND EXPENSES 147,146 67,886 98,854 90,300 105,464 -54,849 49854- EBHC-OFFICE RENTAL 147,146 67,886 98,854 90,300 105,464 -54,849 Total 61700 - EARLE BROWN HERITAGE CENTER -164,870 243,883 545,593 652,830 831,496 -16,977 2014 Brooklyn Center Department Budget Narrative by Fund Department Name: Centerbrook Golf Course Department/Division Mission: To be a premier value Minnesota golf course offering a challenging, well-conditioned course and exceptional customer service. Department/Division Description: Centerbrook Golf Course is a nine (9) hole, par three (3) golf course, owned by the City of Brooklyn Center. It was built in 1986-87 with a loan from the Capital Improvements Fund. It opened for business in the spring of 1988 and was established as an enterprise fund entity. Enterprise funds were established to account for the financing of self-supporting activities of the City, which render services on a user charge basis to the general public. Staffing Levels Positions FTEs 2013 2014 2015 •Golf Course Superintendent 1 1 1 •Part-time Staff 1.50 1.50 1.50 Total 2.50 2.50 2.50 Strategic Functions/Division(s): •Outside Services o To provide the highest quality playing conditions possible within the established budget limitations. Centerbrook Golf Course will strive to be an example of environmental sensitivity and aesthetic beauty for the community. •Inside Services o To provide an exceptional golfing experience for every patron. Our inside services staff will feature knowledgeable, customer focused staff that will provide exemplary customer service. Annual Goal and Strategies: 1.To maintain optimal course conditions within established budget parameters. Limited use of chemicals Turf moisture content monitored Equipment enhancements 2.Continuous improvements and total customer satisfaction in all areas of operation. Customer Service language included in position descriptions Customer service training for all staff Customer service considered as part of annual performance evaluations Annual Goal Performance Measures: 1. Results/Effectiveness Measures •Number of rounds played per playable day Customer satisfaction ratings 2. Efficiency Measure •Revenues generated per round 3. Productivity Measure •Maintenance cost per acre Capital Outlay and Other Initiatives with Significant Budget Impact #6450 $15,000 Storm water pond irrigation pumping station CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 61300 - CENTERBROOK GOLF COURSE 49721 - CENTERBROOK GOLF COURSE 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4604 CHECK PROCESSING FEES -30 0 0 4612 DONATIONS & CONTRIBUTIONS -200 -200 -375 -500 -500 4600 MISCELLANEOUS REVENUE -230 -200 -375 0 -500 -500 4599 MISCELLANEOUS REVENUE -230 -200 -375 0 -500 -500 4770 CENTERBROOK GOLF COURSE 4771 GOLF LESSONS -1,464 -196 -172 -2,250 -3,500 -3,500 4773 GREEN FEES -108,813 -120,435 -85,148 -128,000 -116,000 -120,000 4778 PASSBOOK -18,960 -18,897 -8,832 -23,000 -17,500 -17,500 4782 RENTALS -10,432 -17,044 -12,397 -16,000 -16,500 -16,500 4785 LEAGUE -9,729 -10,756 -27,097 -11,500 -28,500 -30,000 4786 BEER & WINE COOLER REVENUE -24,328 -24,261 -11,116 -27,000 -25,000 -28,000 4787 FOOD & BEVERAGE REVENUES -6,051 -8,676 -8,666 -9,000 -9,250 -10,000 4788 TAXABLE MERCHANDISE -822 -618 -1,220 -1,000 -1,500 -2,000 4789 NON TAXABLE MERCHANDISE -9,186 -5,513 -3,380 -8,000 -6,500 -6,500 4790 MISCELLANEOUS -25 -25 -1,632 -100 -1,750 -2,000 4791 BOTTLED WATER SALES -1,186 -1,406 -1,021 -1,500 -1,500 -1,500 4770 CENTERBROOK GOLF COURSE -190,995 -207,827 -160,681 -227,350 -227,500 -237,500 4900 OTHER FINANCING SOURCES 4915 TRANSFERS IN -200,000 0 0 -20,000 -20,000 4921 REFUNDS & REIMBURSEMENTS 0 0 0 4900 OTHER FINANCING SOURCES 0 -200,000 0 0 -20,000 -20,000 4001 REVENUES -191,225 -408,027 -161,056 -227,350 -248,000 -258,000 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 49,093 47,910 43,081 60,253 61,458 62,687 6102 OVERTIME-FT EMPLOYEES 355 0 6103 WAGES-PART TIME EMPLOYEES 54,770 41,428 27,695 42,500 38,000 38,500 6104 OVERTIME-PART TIME EMPLOYEES 1,308 991 864 1,000 1,000 1,000 6100 WAGES AND SALARIES 105,172 90,684 71,640 103,753 100,458 102,187 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 1,187 172 0 6110 OTHER PAYMENTS-NON INSURANCE 1,187 172 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 6,317 3,962 3,530 4,368 4,456 4,545 6125 FICA 6,111 5,789 4,624 3,736 6,166 6,286 6126 MEDICARE CONTRIBUTIONS 1,429 1,354 1,081 874 1,442 1,467 6120 RETIREMENT CONTRIBUTIONS 13,858 11,105 9,235 8,978 12,064 12,298 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 10,612 4,823 7,935 10,788 11,543 12,351 6130 INSURANCE BENEFITS 10,612 4,823 7,935 10,788 11,543 12,351 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPOLOYMENT COMPENSATION 0 588 394 0 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6140 UNEMPLOYMENT COMPENSATION 0 588 394 0 6150 WORKERS COMPENSATION 6151 WORKERS' COMPENSATION 2,107 1,883 1,669 1,229 2,327 2,368 6150 WORKER'S COMPENSATION 2,107 1,883 1,669 1,229 2,327 2,368 6099 PERSONAL SERVICES 132,935 109,254 90,873 124,748 126,392 129,204 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 270 300 124 400 300 300 6200 OFFICE SUPPLIES 270 300 124 400 300 300 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 148 60 67 100 100 100 6212 MOTOR FUELS 1,543 3,255 3,194 2,500 3,000 3,000 6213 LUBRICANTS & ADDITIVES 2 19 62 200 150 150 6214 CLOTHING & PERSONAL EQUIPMENT 932 64 800 900 900 6215 SHOP MATERIALS 0 10 98 250 250 250 6216 CHEMICALS/CHEMICAL PRODUCTS 4,347 6,236 5,312 9,000 7,500 7,500 6217 SAFETY SUPPLIES 28 46 82 100 100 100 6219 GENERAL OPERATING SUPPLIES 2,180 925 1,282 1,500 1,600 1,700 6210 OPERATING SUPPLIES 8,249 11,484 10,161 14,450 13,600 13,700 6220 REPAIR & MAINT SUPPLIES 6221 MOTOR VEHICLES 638 1,121 0 1,000 1,000 1,000 6223 BUILDINGS & FACILITIES 2,363 1,302 1,108 1,750 1,500 1,500 6225 PARK & LANDSCAPE MATERIALS 2,052 3,415 901 3,000 3,250 3,300 6227 PAINT SUPPLIES 83 57 0 250 250 250 6220 REPAIR & MAINT SUPPLIES 5,136 5,894 2,009 6,000 6,000 6,050 6230 REPAIR & MAINT SUPPLIES-OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 71 352 63 250 300 300 6230 REPAIR & MAINT SUPPLIES-OTHER 71 352 63 250 300 300 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 190 709 174 1,000 1,100 1,200 6242 MINOR EQUIPMENT 1,489 1,162 493 0 6243 MINOR COMPUTER EQUIPMENT 0 0 2,667 2,725 6240 SMALL TOOLS & MINOR EQUIPMENT 1,679 1,871 3,334 3,725 1,100 1,200 6199 SUPPLIES 15,406 19,901 15,691 24,825 21,300 21,550 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 575 301 181 500 500 500 6300 PROFESSIONAL SERVICES 575 301 181 500 500 500 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 1,457 1,462 1,028 1,500 1,500 1,530 6329 OTHER COMMUNICATION SERVICES 787 2,229 1,919 2,600 2,700 6320 COMMUNICATIONS 2,245 3,691 2,947 4,100 4,200 1,530 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 818 116 0 500 300 300 6330 TRANSPORTATION 818 116 0 500 300 300 6340 ADVERTISING 6349 OTHER ADVERTISING 614 791 686 4,500 4,500 4,750 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6340 ADVERTISING 614 791 686 4,500 4,500 4,750 6350 PRINTING AND DUPLICATING 6351 PRINTING 0 382 0 500 500 500 6350 PRINTING AND DUPLICATING 0 382 0 500 500 500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 3,236 2,757 1,697 3,850 4,120 1,254 6362 PROPERTY INSURANCE 1,526 1,194 1,598 1,650 1,765 1,888 6364 DRAM SHOP INSURANCE 878 822 1,610 1,230 1,320 1,412 6366 MACHINERY BREAKDOWN INSURANCE 256 185 222 250 270 289 6360 INSURANCE 5,897 4,958 5,127 6,980 7,475 4,843 6380 UTILITY SERVICES 6381 ELECTRIC 7,880 7,614 7,292 7,500 7,900 8,000 6382 GAS 907 575 642 1,000 900 950 6383 WATER 9,561 11,981 3,128 9,000 500 500 6384 REFUSE DISPOSAL 1,680 1,809 1,120 1,750 1,800 1,800 6385 SEWER 526 542 423 600 650 650 6386 STORM SEWER 1,015 1,015 761 1,100 1,150 1,150 6380 UTILITY SERVICES 21,569 23,535 13,366 20,950 12,900 13,050 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 0 0 440 0 6403 BLDGS/FACILITIES MAINT SERVICE 636 8,280 1,673 2,000 2,000 2,100 6400 REPAIR & MAINT SERVICES 636 8,280 2,113 2,000 2,000 2,100 6410 RENTALS 6415 OTHER EQUIPMENT 6,045 1,746 814 3,500 3,500 3,500 6410 RENTALS 6,045 1,746 814 3,500 3,500 3,500 6420 IS SERVICES/LICENSES/FEES 6422 SOFTWARE MAINT 247 331 293 350 350 350 6423 LOGIS CHARGES 3,484 4,137 2,589 4,230 4,722 4,773 6420 IS SERVICES/LICENSES/FEES 3,731 4,468 2,882 4,580 5,072 5,123 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 476 150 620 500 500 500 6433 MEETING EXPENSES 26 37 6434 DUES & SUBSCRIPTIONS 985 245 1,000 500 1,000 1,000 6435 CREDIT CARD FEES 3,110 2,970 2,534 3,000 3,100 3,200 6438 CASH SHORT (OVER)476 54 -32 6430 MISCELLANEOUS 5,048 3,445 4,159 4,000 4,600 4,700 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 279 229 365 500 500 500 6449 OTHER CONTRACTUAL SERVICES 1,284 465 128 1,000 1,000 1,000 6440 OTHER EXPENSES 1,563 694 493 1,500 1,500 1,500 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 0 176 232 0 6462 FIXED CHARGES 6,603 7,148 6,351 7,992 8,150 6463 REPAIR & MAINT CHARGES 4,970 7,563 1,596 9,085 9,539 6465 REPLACEMENT CHARGES 15,170 18,635 17,757 26,774 26,200 6460 CENTRAL GARAGE CHARGES 26,744 33,522 25,936 43,851 43,889 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 9,855 4,293 6,031 8,041 8,282 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6470 TRANSFERS AND OTHER USES 9,855 4,293 6,031 8,041 8,282 6490 OTHER MISC COSTS/EXPENSES 6491 MERCHANDUSE FOR RESALE 21,330 24,648 16,325 21,000 21,000 21,500 6494 DEPRECIATION EXPENSE 28,185 28,262 8,091 28,825 29,700 30,000 6490 OTHER MISC COSTS/EXPENSES 49,514 52,910 24,415 49,825 50,700 51,500 6299 OTHER CHARGES & SERVICES 134,855 143,129 89,150 155,327 149,918 93,896 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6540 EQUIPMENT & MACHINERY 0 15,000 6,000 6501 CAPITAL OUTLAY 0 0 0 0 15,000 6,000 6500 CAPITAL OUTLAY 0 0 0 0 15,000 6,000 6001 EXPENDITURES/EXPENSES 283,196 272,284 195,714 304,900 312,610 250,650 4000 REVENUES AND EXPENSES 91,970 -135,743 34,658 77,550 64,610 -7,350 49721 - CENTERBROOK GOLF COURSE 91,970 -135,743 34,658 77,550 64,610 -7,350 Total 61300 - CENTERBROOK GOLF COURSE 91,970 -135,743 34,658 77,550 64,610 -7,350 2014 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, cigarettes and sundry items such as glassware, ice and non-intoxicating beverages. Store # 1 is the larger of the two stores in located in the Brookdale Corners shopping center at 5625 Xerxes Avenue. Store# 2 is located in the Boulevard Marketplace shopping center at 6930 Brooklyn Boulevard. The stores operate Monday through Saturday. Special events are provided through a Wine Club, a Beer Club and Platinum Club (joint membership in both Wine and Beer) of BC Liquors. These clubs meet to provide information about the products, sample tastings and special sales opportunities for products featured at the events. Additionally, BC Liquors assists Surly Brewing with its annual Darkness Day celebration. BC Liquor leases space on the Surly Brewing premises and effectively opens a store there to facilitate off-sale distribution of the very popular Surly Darkness beer. Staffing Levels Positions FTEs 2013 2014 2015 •Liquor Operations Manager 1 1 1 •Liquor Store Manager 2 2 2 •Liquor Store Assistant Manager 1 1 1 •Liquor Store Office Assistant 1 1 1 •Liquor Store Category Lead (PT Staff)3 3 3 •Store Clerk/Stocker (PT staff)20 20 20 TOTAL 27 28 28 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. The Division also sponsors special events each year such as tasting club events for wine and beer enthusiasts and off-sale services at local brewery events. Annual Goal and Strategies: 1. Promote and sell alcoholic beverages in a controlled environment which minimizes the risk of unlawful procurement of alcoholic beverages by minors or obviously intoxicated patrons. a.Random compliance checks provided by law enforcement b.Regular Training and support of clerks 2. Promote knowledge of alcoholic beverages through Tasting Club events. a. Events scheduled twice per year for solely wine and twice for solely beer with one additional event combining both beer and wine presentations and tasting 3. Provide profitable operations such that dollars may be transferred from the Liquor Fund to the Capital Improvements Fund and other funds as approved by the City Council to lower the need for property tax revenues while still accomplishing the repair and maintenance need of the City. a. Reserve a specified transfer in the budget process Annual Goal Performance Measures: . Results/Effectiveness Measures •Zero violations of Alcohol Compliance checks performed by law enforcement agencies 2. Efficiency Measure •Utility cost per square foot 3. Productivity Measure •Sales Volume per advertising dollar •Gross Margin per thousand dollars of sales •Net Profit per product category. Capital Outlay and Other Initiatives with Significant Budget Impact (optional) •Replacement the aging camera system at Store #2. Expected Cost of $27,000. CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 60900 - BROOKLYN CENTER LIQUOR 49611 - BROOKLYN CENTER LIQUOR 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -4,891 -3,562 -1,855 -3,000 -3,000 -3,000 4605 UNREALIZED INVESTMENT GAIN/LOSS -1,387 739 0 4606 OTHER REVENUE -2,000 -2,500 -2,000 -1,500 -1,500 -1,500 4600 MISCELLANEOUS REVENUE -8,278 -5,323 -3,855 -4,500 -4,500 -4,500 4599 MISCELLANEOUS REVENUE -8,278 -5,323 -3,855 -4,500 -4,500 -4,500 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES -1,577,629 -1,705,023 -1,291,333 -1,673,706 -1,723,917 -1,775,635 4762 WINE SALES -550,371 -576,899 -403,310 -606,783 -637,121 -637,121 4763 BEER SALES -1,783,997 -1,889,305 -1,489,903 -1,856,069 -1,893,190 -1,968,917 4764 SALES-NON TAXABLE -47,328 -43,190 -31,047 -44,322 -44,322 -42,992 4765 SALES-TAXABLE -59,525 -60,679 -43,066 -59,525 -59,525 -57,739 4760 LIQUOR STORE OPERATIONS -4,018,850 -4,275,097 -3,258,659 -4,240,405 -4,358,075 -4,482,404 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS -2,000 -2,496 -2,798 0 -2,500 4922 PROJECT ADMINISTRATION -2,875 -3,921 -2,835 -4,500 -4,500 -4,500 4900 OTHER FINANCING SOURCES -4,875 -6,417 -5,633 -4,500 -4,500 -7,000 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 991,395 1,090,687 728,512 1,154,857 1,189,502 1,225,188 5582 COST OF SALES-WINE 343,081 371,520 211,102 403,510 423,685 423,685 5583 COST OF SALES-BEER 1,369,643 1,481,804 1,014,786 1,429,173 1,457,756 1,516,066 5584 OTHER COSTS OF SALE-NON TAX 25,032 23,172 13,763 28,366 28,366 27,515 5582 OTHER COST OF SALES-TAX 38,392 39,133 24,801 38,096 38,096 36,953 5587 INVENTORY VARIANCES 1,771 14,143 2,118 12,000 12,000 12,000 5589 DELIVERY CHARGES 19,764 19,896 14,014 18,000 18,000 20,000 5580 COST OF GOODS SOLD 2,789,076 3,040,355 2,009,095 3,084,002 3,167,405 3,261,407 5550 DIRECT COST OF SALES 2,789,076 3,040,355 2,009,095 3,084,002 3,167,405 3,261,407 4001 REVENUES -1,242,927 -1,246,482 -1,259,051 -1,165,403 -1,199,670 -1,232,497 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 171,135 180,105 147,976 211,712 215,946 220,265 6103 WAGES-PART TIME EMPLOYEES 153,101 161,457 111,703 168,000 178,000 183,000 6104 OVERTIME-PART TIME EMPLOYEES 1,834 2,278 2,338 2,500 2,500 2,500 6100 WAGES AND SALARIES 326,070 343,840 262,016 382,212 396,446 405,765 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 1,362 2,229 0 6110 OTHER PAYMENTS-NON INSURANCE 1,362 2,229 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 22,874 24,201 18,344 27,529 28,561 29,237 6125 FICA 20,601 21,869 16,501 23,542 24,424 25,002 6126 MEDICARE CONTRIBUTIONS 4,819 5,114 3,859 5,506 5,712 5,847 6120 RETIREMENT CONTRIBUTIONS 48,294 51,184 38,704 56,577 58,697 60,086 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 28,660 26,337 24,362 33,804 36,170 38,702 6130 INSURANCE BENEFITS 28,660 26,337 24,362 33,804 36,170 38,702 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPOLOYMENT COMPENSATION 701 96 91 6140 UNEMPLOYMENT COMPENSATION 701 96 91 6150 WORKERS' COMPENSATION 6151 WORKERS' COMPENSATION 7,100 7,795 7,035 8,126 10,557 10,807 6150 WORKER'S COMPENSATION 7,100 7,795 7,035 8,126 10,557 10,807 6099 PERSONAL SERVICES 412,187 431,482 332,208 480,719 501,870 515,360 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 570 282 685 1,000 1,000 1,000 6202 COPYING SUPPLIES 0 0 0 0 6200 OFFICE SUPPLIES 570 282 685 1,000 1,000 1,000 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 1,086 1,110 1,014 1,000 1,000 1,500 6219 GENERAL OPERATING SUPPLIES 10,606 11,230 7,329 11,000 11,000 11,000 6210 OPERATING SUPPLIES 11,692 12,340 8,343 12,000 12,000 12,500 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 0 0 0 2,000 2,000 2,000 6220 REPAIR & MAINT SUPPLIES 0 0 0 2,000 2,000 2,000 6230 REPAIR & MAINT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 0 0 0 6230 REPAIR & MAINT SUPPLIES-OTHER 0 0 0 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 191 6242 MINOR EQUIPMENT 364 1,696 394 10,088 6,500 2,000 6243 MINOR COMPUTER EQUIPMENT 1,016 20,246 27,534 31,750 20,725 3,672 6240 SMALL TOOLS & MINOR EQUIPMENT 1,380 21,942 28,119 41,838 27,225 5,672 6199 SUPPLIES 13,641 34,564 37,147 56,838 42,225 21,172 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 4,906 3,985 3,934 5,000 5,000 5,000 6303 LEGAL SERVICES 0 197 0 0 6307 PROFESSIONAL SERVICES 2,791 2,112 2,571 7,000 7,000 7,000 6300 PROFESSIONAL SERVICES 7,697 6,294 6,505 12,000 12,000 12,000 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 2,049 2,171 1,414 2,220 2,500 2,550 6320 COMMUNICATIONS 2,049 2,171 1,414 2,220 2,500 2,550 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 675 704 389 1,000 1,000 1,000 6330 TRANSPORTATION 675 704 389 1,000 1,000 1,000 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 0 252 207 500 500 500 6349 OTHER ADVERTISING 8,309 12,243 3,844 10,000 10,000 15,000 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6340 ADVERTISING 8,309 12,495 4,051 10,500 10,500 15,500 6350 PRINTING AND DUPLICATING 6351 PRINTING 0 0 402 500 500 500 6350 PRINTING AND DUPLICATING 0 0 402 500 500 500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 387 312 1,429 735 786 6362 PROPERTY INSURANCE 309 642 979 1,287 1,377 6364 DRAM SHOP INSURANCE 4,228 4,037 3,893 6,395 6,843 6366 MACHINERY BREAKDOWN INSURANCE 78 174 266 350 370 6360 INSURANCE 5,002 5,165 6,567 8,767 9,376 6380 UTILITY SERVICES 6381 ELECTRIC 16,918 15,781 19,556 17,000 25,000 26,000 6382 GAS 3,370 2,240 1,974 3,500 3,500 3,500 6380 UTILITY SERVICES 20,288 18,022 21,530 20,500 28,500 29,500 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 5,231 938 1,730 5,000 5,000 5,000 6403 BLDGS/FACILITIES MAINT SERVICE 767 1,559 182 3,000 3,000 3,000 6406 MULTI-FUNCTION MTNCE 186 234 215 500 500 515 6409 OTHER REPAIR & MAINT SERVICES 0 0 0 1,000 1,000 6400 REPAIR & MAINT SERVICES 6,184 2,731 2,126 9,500 9,500 8,515 6410 RENTALS 6412 BLDGS/FACILITIES 198,405 203,604 154,948 195,780 195,780 195,780 6410 RENTALS 198,405 203,604 154,948 195,780 195,780 195,780 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 294 0 1,539 0 6422 SOFTWARE MAINT 1,006 5,311 1,930 6,300 6,300 6,300 6423 LOGIS CHARGES 9,350 11,613 8,902 12,982 14,417 14,429 6428 PROTECTION SERVICES 534 547 373 500 500 6420 IS SERVICES/LICENSES/FEES 11,183 17,471 12,744 19,282 21,217 21,229 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 8,716 8,822 5,552 8,500 8,500 8,500 6432 CONFERENCES AND SCHOOLS 939 1,792 2,205 2,200 2,200 2,500 6433 MEETING EXPENSES 15 0 6434 DUES & SUBSCRIPTIONS 2,287 2,304 1,460 2,500 2,500 2,500 6435 CREDIT CARD FEES 57,826 63,092 43,355 62,000 64,000 65,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 0 0 0 0 6438 CASH SHORT (OVER)863 829 403 1,000 1,000 1,000 6430 MISCELLANEOUS 70,631 76,854 52,975 76,200 78,200 79,500 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 20 0 615 200 200 200 6449 OTHER CONTRACTUAL SERVICES 2,304 2,477 1,964 2,500 2,500 2,500 6440 OTHER EXPENSES 2,324 2,477 2,579 2,700 2,700 2,700 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 90 139 122 103 108 229 6462 FIXED CHARGES 536 529 646 560 577 822 6463 REPAIR & MAINT CHARGES 0 45 240 525 552 198 6465 REPLACEMENT CHARGES 1,114 930 1,138 1,050 1,199 1,736 6460 CENTRAL GARAGE CHARGES 1,740 1,644 2,146 2,238 2,436 2,985 6470 TRANSFERS AND OTHER USES CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6471 ADMINISTRATIVE SERVICE TRANSFER 49,557 41,849 30,728 40,970 41,790 6476 CAPITAL PROJECT FUND TRANSFER 135,000 200,000 0 200,000 200,000 200,000 6482 MISC TRANSFER OUT 12,488 0 0 6470 TRANSFERS AND OTHER USES 197,045 241,849 30,728 240,970 241,790 200,000 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 6,417 6,435 15,818 8,550 9,200 6490 OTHER MISC COSTS/EXPENSES 6,417 6,435 15,818 8,550 9,200 6299 OTHER CHARGES & SERVICES 537,951 597,915 314,922 610,707 625,199 571,759 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 0 0 0 6540 EQUIPMENT & MACHINERY 10,279 0 29,454 38,000 6501 CAPITAL OUTLAY 10,279 0 29,454 38,000 6500 CAPITAL OUTLAY 10,279 0 29,454 38,000 6001 EXPENDITURES/EXPENSES 974,059 1,063,961 713,730 1,186,264 1,169,294 1,108,291 4000 REVENUES AND EXPENSES -268,869 -182,521 -545,321 20,861 -30,376 -124,206 49611 - BROOKLYN CENTER LIQUOR -268,869 -182,521 -545,321 20,861 -30,376 -124,206 49612- 69TH AVENUE LIQUOR STORE 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -4,891 -3,562 -1,855 -3,000 -3,000 -3,000 4605 UNREALIZED INVESTMENT GAIN/LOSS -1,387 739 0 4600 MISCELLANEOUS REVENUE -6,278 -2,823 -1,855 -3,000 -3,000 -3,000 4599 MISCELLANEOUS REVENUE -6,278 -2,823 -1,855 -3,000 -3,000 -3,000 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES -569,294 -526,196 -388,221 -546,748 -535,813 -546,529 4762 WINE SALES -226,961 -219,356 -148,168 -240,782 -248,006 -238,085 4763 BEER SALES -924,288 -897,584 -522,237 -707,079 -636,371 -623,643 4764 SALES-NON TAXABLE -21,456 -20,004 -13,217 -20,606 -20,194 -19,184 4765 SALES-TAXABLE -28,496 -25,672 -18,289 -27,366 -26,819 -25,478 4760 LIQUOR STORE OPERATIONS -1,770,496 -1,688,811 -1,090,132 -1,542,581 -1,467,203 -1,452,919 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 0 -16 -38 0 4900 OTHER FINANCING SOURCES 0 -16 -38 0 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 472,904 438,589 303,313 377,256 369,710 377,105 5582 COST OF SALES-WINE 172,943 163,634 102,755 160,084 164,923 158,326 5583 COST OF SALES-BEER 695,319 630,290 331,848 544,450 490,005 480,205 5584 OTHER COSTS OF SALE-NON TAX 15,420 16,191 9,612 13,187 12,924 12,277 5582 OTHER COST OF SALES-TAX 21,152 17,209 11,454 17,514 17,164 16,305 5587 INVENTORY VARIANCES 3,006 4,853 4,454 5,000 5,000 5,000 5589 DELIVERY CHARGES 6,085 5,593 3489 5,800 5,800 6,000 5580 COST OF GOODS SOLD 1,386,829 1,276,360 766,926 1,123,291 1,065,526 1,055,218 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 5550 DIRECT COST OF SALES 1,386,829 1,276,360 766,926 1,123,291 1,065,526 1,055,218 4001 REVENUES -389,944 -415,291 -325,099 -422,290 -404,677 -400,701 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 72,319 68,035 61,373 84,119 85,801 87,517 6103 WAGES-PART TIME EMPLOYEES 78,673 77,327 46,173 72,000 72,000 72,000 6104 OVERTIME-PART TIME EMPLOYEES 1,417 1,422 1,257 1,500 1,500 1,500 6100 WAGES AND SALARIES 152,409 146,784 108,803 157,619 159,301 161,017 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 954 1,418 0 6110 OTHER PAYMENTS-NON INSURANCE 954 1,418 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 10,946 10,469 7,707 11,374 11,440 11,565 6125 FICA 9,837 9,490 6,998 9,728 9,784 9,890 6126 MEDICARE CONTRIBUTIONS 2,300 2,220 1,637 2,274 2,288 2,313 6120 RETIREMENT CONTRIBUTIONS 23,083 22,179 16,342 23,376 23,512 23,768 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 5,447 4,629 3,727 22,536 24,114 25,801 6130 INSURANCE BENEFITS 5,447 4,629 3,727 22,536 24,114 25,801 6140 UNEMPLOYMENT COMPENSATION 6150 WORKERS' COMPENSATION 6151 WORKERS' COMPENSATION 3,424 3,532 2,931 1,792 4,229 4,275 6150 WORKER'S COMPENSATION 3,424 3,532 2,931 1,792 4,229 4,275 6099 PERSONAL SERVICES 185,317 178,542 131,804 205,323 211,156 214,861 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 240 90 123 400 400 300 6202 COPYING SUPPLIES 0 0 0 0 6200 OFFICE SUPPLIES 240 90 123 400 400 300 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 340 263 435 500 500 600 6219 GENERAL OPERATING SUPPLIES 7,972 3,433 2,271 5,000 5,000 4,000 6210 OPERATING SUPPLIES 8,312 3,696 2,706 5,500 5,500 4,600 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 0 0 0 500 500 500 6220 REPAIR & MAINT SUPPLIES 0 0 0 500 500 500 6230 REPAIR & MAINT SUPPLIES-OTHER 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 0 54 0 500 5,500 500 6243 MINOR COMPUTER EQUIPMENT 391 3,415 0 30,875 33,725 18,366 6240 SMALL TOOLS & MINOR EQUIPMENT 391 3,469 0 31,375 39,225 18,866 6199 SUPPLIES 8,942 7,256 2,829 37,775 45,625 24,266 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 1,713 1,084 1,213 1,200 1,200 1,200 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6300 PROFESSIONAL SERVICES 1,713 1,084 1,213 1,200 1,200 1,200 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 1,457 1,462 975 1,500 1,500 1,530 6329 OTHER COMMUNICATION SERVICES 859 985 607 900 0 6320 COMMUNICATIONS 2,316 2,447 1,582 2,400 1,500 1,530 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 344 189 130 300 300 300 6330 TRANSPORTATION 344 189 130 300 300 300 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 142 0 0 200 200 0 6349 OTHER ADVERTISING 4,006 4,404 1,648 6,000 6,000 7,000 6340 ADVERTISING 4,148 4,404 1,648 6,200 6,200 7,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 0 0 172 0 200 6350 PRINTING AND DUPLICATING 0 0 172 0 200 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 590 608 1,429 735 786 6,453 6362 PROPERTY INSURANCE 1,124 886 552 1,110 1,188 2,482 6364 DRAM SHOP INSURANCE 1,766 1,402 1,340 2,200 2,375 6,350 6366 MACHINERY BREAKDOWN INSURANCE 290 239 149 300 317 431 6360 INSURANCE 3,771 3,135 3,471 4,345 4,666 15,716 6380 UTILITY SERVICES 6381 ELECTRIC 17,745 17,399 14,682 18,000 19,000 19,000 6382 GAS 2,418 2,133 1,871 3,000 3,000 3,000 6383 WATER 30,899 0 7,200 7,200 7,200 6380 UTILITY SERVICES 20,162 50,430 16,553 28,200 29,200 29,200 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 124 996 2,762 2,000 2,000 2,500 6403 BLDGS/FACILITIES MAINT SERVICE 366 152 1,812 1,000 1,000 2,000 6406 MULTI-FUNCTION MTNCE 40 84 125 175 180 6400 REPAIR & MAINT SERVICES 490 1,188 4,658 3,125 3,175 4,680 6410 RENTALS 6412 BLDGS/FACILITIES 94,860 93,360 70,020 93,860 93,860 93,860 6410 RENTALS 94,860 93,360 70,020 93,860 93,860 93,860 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 0 0 0 0 6422 SOFTWARE MAINT 393 2,296 685 2,800 2,800 2,800 6423 LOGIS CHARGES 4,130 5,227 3,848 5,564 6,179 6,184 6428 PROTECTION SERVICES 435 475 340 6420 IS SERVICES/LICENSES/FEES 4,958 7,997 4,873 8,364 8,979 8,984 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 0 0 0 0 6432 CONFERENCES AND SCHOOLS 371 465 379 600 600 600 6434 DUES & SUBSCRIPTIONS 1,003 1,016 750 1,000 1,000 1,000 6435 CREDIT CARD FEES 22,760 24,253 14,288 25,000 26,000 27,000 6438 CASH SHORT (OVER)2,748 1,001 383 1,000 1,000 1,000 6430 MISCELLANEOUS 26,881 26,735 15,799 27,600 28,600 29,600 6440 OTHER EXPENSES CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6441 LICENSES, TAXES & FEES 20 20 223 1,000 1,000 500 6449 OTHER CONTRACTUAL SERVICES 2,658 3,000 2,331 2,600 2,600 2,600 6440 OTHER EXPENSES 2,678 3,020 2,554 3,600 3,600 3,100 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 90 139 122 103 108 229 6462 FIXED CHARGES 536 529 248 560 577 822 6463 REPAIR & MAINT CHARGES 0 45 240 525 552 198 6465 REPLACEMENT CHARGES 1,114 930 438 1,050 1,199 1,736 6460 CENTRAL GARAGE CHARGES 1,740 1,644 1,048 2,238 2,436 2,985 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 24,741 20,893 15,341 20,454 21,065 6470 TRANSFERS AND OTHER USES 24,741 20,893 15,341 20,454 21,065 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 4,864 4,877 3,648 4,875 4,875 6490 OTHER MISC COSTS/EXPENSES 4,864 4,877 3,648 4,875 4,875 6299 OTHER CHARGES & SERVICES 193,666 221,403 142,709 206,761 209,656 198,355 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6001 EXPENDITURES/EXPENSES 387,925 407,201 277,341 449,859 466,437 437,482 4000 REVENUES AND EXPENSES -2,020 -8,089 -47,758 27,569 61,760 36,781 49612- 69TH AVENUE LIQUOR STORE -2,020 -8,089 -47,758 27,569 61,760 36,781 Total 60900 - BROOKLYN CENTER LIQUOR -270,888 -190,610 -593,079 48,430 31,384 -87,424 2014 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 administers the capital asset management for the City's public buildings and facilities. The Utilities division provides for the operation, maintenance and management of City's drinking water system, sanitary sewer collection and conveyance system, storm sewer collection and management system, and street light system. Staffing Levels Positions FTEs 2013 2014 2015 •Supervisor of Utilities 1 1 1 •Engineering Technician 3 (distributed 1/3 over 49141, 49251 and 49411) 1 1 1 •Maintenance 11 (4-49141, 2-49251, 2-49411)8 8 8 •Part Time/Summer Temporary Employees (3- 49141,2-49251, 1-49411) 6 6 6 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 1,300 water valves, and almost 1,000 fire hydrants providing service to over 7,000 metered single-family residential connections and approximately 1,600 metered apartments/townhouses/commercial/ industrial customers. Water is supplied from nine municipal wells. 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. This division is managed by the Public Works Director, except for the utility billing component, which is managed by the Fiscal and Support Services Department. The City has approximately 106 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) •We provide for the collection and management of stormwater throughout the city in compliance with State and Federal regulatory requirements. The Storm Drainage Utility operates and maintains approximately 84 miles of storm sewers and just under 100 storm water management ponds or treatment devices. The Storm Drainage Utility also provides for street sweeping operations and the City's participation in two joint powers Watershed Commissions, which provide for regional planning, surface water quality monitoring, and Wetlands Conservation Act compliance. •Streetlight Utility (49571) •We provide for electrical service, maintenance, repair, and replacement of lights owned by the City. The City owns approximately 71 ornamental lights, primarily in the Earle Brown commercial area, 85 ornamental lights on Brooklyn Boulevard, 40 ornamental lights along Xerxes Avenue, 72 ornamental lights along Bass Lake Rd and 57th Avenue and leases approximately 915 lights from Excel Energy. Another 97 lights owned by the City are located on traffic signal systems. The Street Light Utility also provides for electrical and maintenance fees paid to Xcel Energy for street lights owned by Xcel Energy. Annual Goal and Strategies: 1. Meet or exceed safe drinking water standards of the State of Minnesota and manage storm water runoff in an efficient and environmentally sensitive manner. a.Manage and enforce the City's Wellhead Protection Plan goals. b.Implement Best Management Practices (BMPs) that support the City's and Watershed's impaired waters Total Maximum Daily Load (TMDL) plans. c.By 2015, update the City's Wellhead Protection Plan and Local Water Management Plan. d.Implement the developed Action Plan including construction of a new water treatment plant to address the Minnesota Department of Health's health advisory for manganese in Brooklyn Center's drinking water. 2. Initiate improved, streamlined management strategies and techniques by use of refined methods and technologies. a. Develop and initiate process flow charting for the utility department. Annual Goal Performance Measures: 1. Results/Effectiveness Measures •Number of private wells sealed. •Annual Consumer Confidence Report results. 2. Efficiency Measure •Cost per drinking water sample. 3. Productivity Measure •Miles of annual street sweeping performed per sweeper. Capital Outlay and Other Initiatives with Significant Budget Impact > 2014-15 Capital Improvement Projects — See CIP section of Budget CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 60100 -WATER UTILITY FUND 49141 -WATER UTILITY-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 4320 MISC FEDERAL GRANTS o o o 4310 FEDERAL REVENUE o o o 4300 INTERGOVERNMENTAL REVENUE o o o 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -13,718 -8,328 -5,402 -7,000 -7,000 -7,000 4604 CHECK PROCESSING FEES -330 -960 -630 4605 UNREALIZED INVESTMENT GAIN/LOSS -3,205 2,212 0 4606 OTHER REVENUE -7,442 0 -1,797 4600 MISCELLANEOUS REVENUE -24,695 -7,076 -7,829 -7,000 -7,000 -7,000 4650 SPECIAL ASSESSMENTS 4607 SPEC ASSESS INTEREST -34,667 -21,800 0 4650 SPECIAL ASSESSMENTS -34,667 -21,800 0 4599 MISCELLANEOUS REVENUE -59,363 -28,875 -7,829 -7,000 -7,000 -7,000 4700 WATER UTILITY FUND 4701 WATER SALES -1,597,556 -1,878,459 -1,130,539 -2,027,182 -2,169,085 -2,200,000 4702 FIRE LINES -8,794 -8,725 -5,663 -8,000 -8,000 -8,000 4703 WATER METER SALES -12,509 -25,389 -27,879 -12,500 -20,000 -20,000 4704 WATER METER RENTALS -9,472 -2,920 -3,950 -3,000 -3,000 -3,000 4705 SERVICE RESTORATION FEES -5,377 -4,783 -2,830 -4,000 -4,000 -4,000 4706 CONNECTION CHARGES -1,000 -13,500 -12,500 0 -10,000 -10,000 4707 PENALTIES -78,708 -89,441 -72,747 -95,000 -95,000 -95,000 4708 TOWER RENTAL FEES -207,892 -246,793 -236,487 -198,000 -213,322 -223,674 4709 CERTIFICATION CHARGES -26,760 -27,330 -25,410 -21,000 -21,000 -21,000 4700 WATER UTILITY FUND -1,948,067 -2,297,340 -1,518,004 -2,368,682 -2,543,407 -2,584,674 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 0 0 0 4921 REFUNDS & REIMBURSEMENTS -158 -1,439 -5,970 4933 DISCOUNT ON BOND SALES 0 0 0 4900 OTHER FINANCING SOURCES -158 -1,439 -5,970 4001 REVENUES -2,007,588 -2,327,655 -1,531,803 -2,375,682 -2,550,407 -2,591,674 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 296,976 302,729 225,504 306,263 312,387 318,635 6102 OVERTIME-FT EMPLOYEES 39,617 34,284 29,473 39,800 39,800 39,800 6103 WAGES-PART TIME EMPLOYEES 16,251 19,803 17,392 20,600 21,300 22,000 6104 OVERTIME-PART TIME EMPLOYEES 585 50 27 6100 WAGES AND SALARIES 353,428 356,865 272,397 366,663 373,487 380,435 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 3,384 4,412 0 6110 OTHER PAYMENTS-NON INSURANCE 3,384 4,412 0 6120 RETIREMENT CONTRIBUTIONS CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YID 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6122 PERA COORDINATED PLAN 24,403 24,434 18,486 23,437 23,881 24,359 6125 FICA 21,683 22,363 16,644 20,042 20,422 20,830 6126 MEDICARE CONTRIBUTIONS 5,071 5,230 3,892 4,689 4,775 4,871 6120 RETIREMENT CONTRIBUTIONS 51,157 52,027 39,022 48,168 49,078 50,060 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 55,354 52,496 38,479 64,728 69,259 74,107 6130 INSURANCE BENEFITS 55,354 52,496 38,479 64,728 69,259 74,107 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPOLOYMENT COMPENSATION 2,076 0 0 6140 UNEMPLOYMENT COMPENSATION 2,076 0 0 6150 WORKERS COMPENSATION 6151 WORKERS' COMPENSATION 13,258 13,962 10,110 12,909 13,154 13,417 6150 WORKER'S COMPENSATION 13,258 13,962 10,110 12,909 13,154 13,417 6099 PERSONAL SERVICES 478,658 479,762 360,008 492,468 504,978 518,019 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 1,136 1,502 144 1,800 1,800 1,800 6203 BOOKS/REFERENCE MATERIALS 0 0 0 300 300 300 6204 STATIONARY SUPPLIES 1,267 144 1,240 1,610 1,610 1,610 6200 OFFICE SUPPLIES 2,403 1,646 1,385 3,710 3,710 3,710 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 100 0 0 250 250 250 6216 CHEMICALS/CHEMICAL PRODUCTS 86,238 94,841 64,178 100,000 100,000 100,000 6217 SAFETY SUPPLIES 503 302 79 1,200 1,200 1,200 6219 GENERAL OPERATING SUPPLIES 2,872 4,195 2,092 9,600 9,600 9,600 6210 OPERATING SUPPLIES 89,714 99,338 66,348 111,050 111,050 111,050 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 166 467 216 1,500 1,500 1,500 6224 STREET MAINT SUPPLIES 10,906 7,156 7,582 16,000 16,000 16,000 6227 PAINT SUPPLIES 807 389 384 900 900 900 6220 REPAIR & MAINT SUPPLIES 11,879 8,012 8,181 18,400 18,400 18,400 6230 REPAIR & MAINT SUPPLIES-OTHER 6235 UTILITY SYSTEM SUPPLIES 13,111 20,337 11,982 14,000 14,000 14,000 6239 OTHER REPAIR & MAINT SUPPLIES 16,269 9,603 3,708 16,000 16,000 16,000 6230 REPAIR & MAINT SUPPLIES-OTHER 29,380 29,940 15,690 30,000 30,000 30,000 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 465 75 0 500 500 500 6242 MINOR EQUIPMENT 6,733 5,001 2,626 44,000 10,000 44,000 6243 MINOR COMPUTER EQUIPMENT 0 158 2,812 4,000 7,750 10,098 6240 SMALL TOOLS & MINOR EQUIPMENT 7,198 5,234 5,439 48,500 18,250 54,598 6199 SUPPLIES 140,575 144,170 97,043 211,660 181,410 217,758 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 2,230 1,594 1,731 2,200 2,200 2,200 6302 ARCH, ENG & PLANNING 3,841 7,655 52,082 20,000 20,000 20,000 6303 LEGAL SERVICES 0 534 0 6307 PROFESSIONAL SERVICES 10,721 3,839 3,294 9,500 35,000 14,400 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6300 PROFESSIONAL SERVICES 16,792 13,622 57,106 31,700 57,200 36,600 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 2,068 1,913 1,169 2,050 1,900 1,940 6322 POSTAGE 8,027 4,953 3,540 6,210 6,210 6,210 6329 OTHER COMMUNICATION SERVICES 298 312 390 500 1,300 2,650 6320 COMMUNICATIONS 10,393 7,178 5,099 8,760 9,410 10,800 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 0 0 0 200 200 200 6333 FREIGHT/DRAYAGE 171 60 0 50 50 50 6330 TRANSPORTATION 171 60 0 250 250 250 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 153 0 0 160 160 160 6342 LEGAL NOTICES 0 0 0 100 100 100 6340 ADVERTISING 153 0 0 260 260 260 6350 PRINTING AND DUPLICATING 6351 PRINTING 247 460 19 1,400 500 500 6350 PRINTING AND DUPLICATING 247 460 19 1,400 500 500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 18,546 17,603 18,001 24,775 26,500 26,500 6362 PROPERTY INSURANCE 1,990 2,630 4,242 3,840 4,110 5,000 6366 MACHINERY BREAKDOWN INSURANCE 421 618 1,019 710 975 1,500 6360 INSURANCE 20,958 20,851 23,262 29,325 31,585 33,000 6380 UTILITY SERVICES 6381 ELECTRIC 126,440 138,240 94,689 140,000 140,000 140,000 6382 GAS 5,561 5,107 5,804 10,000 10,000 10,000 6385 SEWER 263 271 141 300 300 300 6386 STORM SEWER 6,120 6,120 3,060 6,400 6,400 300 6388 HAZARDOUS WASTE DISPOSAL 1,000 1,000 1,000 6389 STREET LIGHTS 1,113 1,395 837 1,300 1,500 1,500 6380 UTILITY SERVICES 139,498 151,134 104,530 159,000 159,200 153,100 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 71,427 53,909 29,163 100,000 53,000 53,000 6403 BLDGS/FACILITIES MAINT SERVICE 6,522 8,173 14,852 23,000 10,000 10,000 6408 COMMUNICATION/INFOR SYSTEMS 0 0 0 0 6400 REPAIR & MAINT SERVICES 77,950 62,082 44,015 123,000 63,000 63,000 6410 RENTALS 6417 UNIFORMS 536 526 233 800 800 800 6410 RENTALS 536 526 233 800 800 800 6420 IS SERVICES/LICENSES/FEES 6422 SOFTWARE MAINT 276 337 292 375 375 375 6423 LOGIS CHARGES 36,203 34,418 19,124 30,422 39,390 39,656 6420 IS SERVICES/LICENSES/FEES 36,479 34,755 19,416 30,797 39,765 40,031 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,753 1,210 1,020 1,975 2,150 2,150 6434 DUES & SUBSCRIPTIONS 2,108 2,138 2,173 2,550 2,550 2,550 6435 CREDIT CARD FEES 160 180 200 200 6436 UNCOLLECTIBLE CHECKS/DEBTS 173 -73 0 6438 CASH SHORT (OVER)-8 -282 0 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6430 MISCELLANEOUS 4,026 3,153 3,372 4,525 4,900 4,900 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 73,577 72,642 60,112 76,000 76,000 76,000 6449 OTHER CONTRACTUAL SERVICES 67,612 37,881 131,771 70,000 70,000 70,000 6440 OTHER EXPENSES 141,189 110,523 191,883 146,000 146,000 146,000 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 5,381 5,501 4,378 6,897 6,447 6,770 6462 FIXED CHARGES 7,880 8,444 7,340 9,316 9,559 10,000 6463 REPAIR & MAINT CHARGES 7,354 9,450 8,047 20,748 11,572 11,919 6465 REPLACEMENT CHARGES 22,293 28,152 27,955 33,775 32,267 33,880 6460 CENTRAL GARAGE CHARGES 42,907 51,547 47,720 70,736 59,845 62,569 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 71,541 86,585 66,313 88,417 91,069 93,000 6472 ENGINEERING SERVICE TRANSFER -9,236 0 0 6476 CAPITAL PROJECT FUND TRANSFER 42,008 0 0 6470 TRANSFERS AND OTHER USES 104,313 86,585 66,313 88,417 91,069 93,000 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 584,600 622,806 479,688 700,280 735,294 6499 EXPENSES REIMBURSED 0 0 0 0 6490 OTHER MISC COSTS/EXPENSES 584,600 622,806 479,688 700,280 735,294 6299 OTHER CHARGES & SERVICES 1,180,210 1,165,283 1,042,657 1,395,250 1,399,078 644,810 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 0 0 0 1,420,000 1,580,000 1,760,000 6501 CAPITAL OUTLAY 0 0 0 1,420,000 1,580,000 1,760,000 6500 CAPITAL OUTLAY 0 0 0 1,420,000 1,580,000 1,760,000 6600 DEBT SERVICE 6601 BOND PRINCIPAL 101,250 105,000 6611 BOND INTEREST 62,579 61,172 34,739 60,185 58,117 6621 PAYING AGENT/OTHER FEES 563 600 631 0 6600 DEBT SERVICE 63,141 61,772 35,370 161,435 163,117 6001 EXPENDITURES/EXPENSES 1,862,583 1,850,986 1,535,077 3,680,813 3,828,583 3,140,587 4000 REVENUES AND EXPENSES -145,004 -476,668 3,274 1,305,131 1,278,176 548,913 49141 -WATER UTILITY-OPERATIONS -145,004 -476,668 3,274 1,305,131 1,278,176 548,913 Total 60100 -WATER UTILITY FUND -145,004 -476,668 3,274 1,305,131 1,278,176 548,913 CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 60200 - SEWER UTILITY FUND 49251 - SEWER UTILITY-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 4320 MISC FEDERAL GRANTS o o o 4310 FEDERAL REVENUE o o o 4300 INTERGOVERNMENTAL REVENUE 0 0 0 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -12,918 -6,753 -4,845 -5,000 -5,000 -5,000 4605 UNREALIZED INVESTMENT GAIN/LOSS -1,875 1551 0 4606 OTHER REVENUE -883 0 0 4600 MISCELLANEOUS REVENUE -15,676 -5,202 -4,845 -5,000 -5,000 -5,000 4650 SPECIAL ASSESSMENTS 4607 SPEC ASSESS INTEREST -93 -101 0 4650 SPECIAL ASSESSMENTS -93 -101 0 4599 MISCELLANEOUS REVENUE -15,769 -5,303 -4,845 -5,000 -5,000 -5,000 4700 WATER UTILITY FUND 4707 PENALTIES -101,427 -104,511 -78,402 -100,000 -100,000 4700 WATER UTILITY FUND -101,427 -104,511 -78,402 -100,000 -100,000 4720 SEWER UTILITY FUND 4721 SEWER SERVICE -3,372,185 -3,487,918 -2,248,970 -3,619,489 -3,800,464 -3,990,000 4720 SEWER UTILITY FUND -3,372,185 -3,487,918 -2,248,970 -3,619,489 -3,800,464 -3,990,000 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS -20,335 o o 4933 DISCOUNT ON BOND SALES 0 o o 4900 OTHER FINANCING SOURCES -20,335 o o 4001 REVENUES -3,509,715 -3,597,732 -2,332,218 -3,624,489 -3,905,464 -4,095,000 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 108,839 118,389 88,817 119,552 121,943 124,382 6102 OVERTIME-FT EMPLOYEES 11,734 12,072 10,168 19,900 19,900 20,300 6103 WAGES-PART TIME EMPLOYEES 15,661 15,635 11,247 13,900 14,300 14,729 6100 WAGES AND SALARIES 136,235 146,096 110,231 153,352 156,143 159,411 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 810 1,246 0 6110 OTHER PAYMENTS-NON INSURANCE 810 1,246 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 6,866 9,458 7,177 8,667 8,841 9,018 6125 FICA 8,598 9,194 6,785 7,412 7,560 7,711 6126 MEDICARE CONTRIBUTIONS 2,011 2,150 1,587 1,734 1,767 1,802 6120 RETIREMENT CONTRIBUTIONS 17,475 20,802 15,549 17,813 18,168 18,531 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 20,371 21,744 15,835 21,576 23,087 24,702 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6130 INSURANCE BENEFITS 20,371 21,744 15,835 21,576 23,087 24,702 6150 WORKERS COMPENSATION 6151 WORKERS' COMPENSATION 4,901 5,460 3,933 4,374 4,462 4,551 6150 WORKER'S COMPENSATION 4,901 5,460 3,933 4,374 4,462 4,551 6099 PERSONAL SERVICES 179,791 195,348 145,547 197,115 201,860 207,195 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 0 0 0 100 100 100 6203 BOOKS/REFERENCE MATERIALS 200 200 200 6204 STATIONARY SUPPLIES 2,280 295 2,267 3,290 3,290 3,290 6200 OFFICE SUPPLIES 2,280 295 2,267 3,590 3,590 3,590 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 100 0 50 50 50 6216 CHEMICALS/CHEMICAL PRODUCTS 3,001 4,999 3,184 5,000 5,000 5,000 6217 SAFETY SUPPLIES 614 611 79 2,500 2,500 2,500 6219 GENERAL OPERATING SUPPLIES 1,928 2 ,407 1,024 2,800 2,800 2,800 6210 OPERATING SUPPLIES 5,543 8,117 4,286 10,350 10,350 10,350 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 55 0 0 100 100 100 6224 STREET MAINT SUPPLIES 2,123 5,347 676 7,500 7,500 7,500 6227 PAINT SUPPLIES 871 743 255 400 425 425 6220 REPAIR & MAINT SUPPLIES 3,049 6,090 931 8,000 8,025 8,025 6230 REPAIR & MAINT SUPPLIES-OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 211 5,744 35 5,000 5,000 5,000 6230 REPAIR & MAINT SUPPLIES-OTHER 211 5,744 35 5,000 5,000 5,000 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 509 75 0 500 500 500 6242 MINOR EQUIPMENT 9,619 1,919 36,100 3,000 36,100 6240 SMALL TOOLS & MINOR EQUIPMENT 509 9,694 1,919 36,600 3,500 36,600 6199 SUPPLIES 11,592 29,941 9,440 63,540 30,465 63,565 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 1,896 1,594 1,573 2,000 2,000 2,000 6302 ARCH, ENG & PLANNING 0 2,880 866 1,900 1,900 1,900 6303 LEGAL SERVICES 0 0 0 0 6307 PROFESSIONAL SERVICES 2,718 5,260 2,881 3,530 4,730 3,530 6300 PROFESSIONAL SERVICES 4,614 9,734 5,320 7,430 8,630 7,430 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 1,001 983 547 1,100 1,100 1,120 6322 POSTAGE 7,689 10,530 6,580 12,690 12,690 12,690 6320 COMMUNICATIONS 8,690 11,513 7,127 13,790 13,790 13,810 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 0 0 0 0 6330 TRANSPORTATION 0 0 0 0 6350 PRINTING AND DUPLICATING 6351 PRINTING 0 189 0 375 375 375 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6350 PRINTING AND DUPLICATING 0 189 0 375 375 375 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 4,604 3,268 22,000 4,925 5,270 5,650 6362 PROPERTY INSURANCE 652 664 966 950 1,010 1,060 6366 MACHINERY BREAKDOWN INSURANCE 168 179 265 250 275 300 6360 INSURANCE 5,424 4,111 23,231 6,125 6,555 7,010 6380 UTILITY SERVICES 6381 ELECTRIC 39,337 36,171 28,423 35,000 36,000 37,000 6380 UTILITY SERVICES 39,337 36,171 28,423 35,000 36,000 37,000 6390 CONTRACT UTILITY SERVICES 6391 MET COUNCIL ENVIRON SVCS 2,110,890 2,027,787 1,720,158 2,073,426 2,114,215 2,118,708 6390 CONTRACT UTILITY SERVICES 2,110,890 2,027,787 1,720,158 2,073,426 2,114,215 2,118,708 6400 REPAIR & MAINT SERVICES 6403 BLDGS/FACILITIES MAINT SERVICE 5,824 7,555 0 7,000 7,000 7,000 6409 OTHER REPAIR & MAINT SERVICES 62,162 49,322 4,860 65,000 65,000 65,000 6400 REPAIR & MAINT SERVICES 67,985 56,877 4,860 72,000 72,000 72,000 6420 IS SERVICES/LICENSES/FEES 6423 LOGIS CHARGES 24,151 24,617 16,250 25,673 29,374 29,354 6420 IS SERVICES/LICENSES/FEES 24,151 24,617 16,250 25,673 29,374 29,354 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,365 900 1,200 2,150 2,150 2,150 6434 DUES & SUBSCRIPTIONS 241 368 403 230 405 405 6430 MISCELLANEOUS 1,606 1,268 1,603 2,380 2,555 2,555 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 2 25 169 100 170 170 6449 OTHER CONTRACTUAL SERVICES 25,915 13,019 19,972 26,000 26,000 26,000 6440 OTHER EXPENSES 25,916 13,044 20,141 26,100 26,170 26,170 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 16,621 16,971 14,140 21,047 19,847 20,839 6462 FIXED CHARGES 12,174 12,291 10,213 13,121 13,490 13,500 6463 REPAIR & MAINT CHARGES 20,774 26,368 12,712 38,156 23,670 24,380 6465 REPLACEMENT CHARGES 48,395 41,297 58,858 78,478 72,357 75,975 6460 CENTRAL GARAGE CHARGES 97,963 96,926 95,923 150,802 129,364 134,694 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 71,541 86,585 66,313 88,417 91,069 93,800 6472 ENGINEERING SERVICE TRANSFER 0 5,797 0 6476 CAPITAL PROJECT FUND TRANSFER 22,485 0 0 6470 TRANSFERS AND OTHER USES 94,026 92,382 66,313 88,417 91,069 93,800 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 604,837 647,862 533,195 728,770 801,647 6490 OTHER MISC COSTS/EXPENSES 604,837 647,862 533,195 728,770 801,647 6299 OTHER CHARGES & SERVICES 3,085,440 3,022,480 2,522,545 3,230,288 3,331,744 2,542,906 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 0 47,028 0 1,330,000 1,260,000 1,570,000 6501 CAPITAL OUTLAY 0 47,028 0 1,330,000 1,260,000 1,570,000 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6500 CAPITAL OUTLAY 0 47,028 0 1,330,000 1,260,000 1,570,000 6600 DEBT SERVICE 6601 BOND PRINCIPAL 33,750 35,000 6611 BOND INTEREST 20,859 20,391 11,580 20,061 19,373 6621 PAYING AGENT/OTHER FEES 188 200 69 0 6600 DEBT SERVICE 21,046 20,591 11,648 53,811 54,373 6001 EXPENDITURES/EXPENSES 3,297,869 3,315,388 2,689,181 4,874,754 4,878,442 4,383,666 4000 REVENUES AND EXPENSES -211,846 -282,344 356,963 1,250,265 972,978 288,666 49251 - SEWER UTILITY-OPERATIONS -211,846 -282,344 356,963 1,250,265 972,978 288,666 Total 60200 -SEWER UTILITY FUND -211,846 -282,344 356,963 1,250,265 972,978 288,666 CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 65100 - STORM SEWER UTILITY FUND 49411 - STORM SEWER UTILITY-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -18,550 -13,396 -8,345 -10,000 -10,000 -10,000 4605 UNREALIZED INVESTMENT GAIN/LOSS -4,529 2,927 0 4606 OTHER REVENUE -34 -23,263 0 4612 DONATIONS & CONTRIBUTIONS -100 -100 -100 4600 MISCELLANEOUS REVENUE -23,214 -33,832 -8,445 -10,000 -10,000 -10,000 4599 MISCELLANEOUS REVENUE -23,214 -33,832 -8,445 -10,000 -10,000 -10,000 4700 WATER UTILITY FUND 4707 PENALTIES -33,249 -38,071 -22,145 -35,000 -35,000 4700 WATER UTILITY FUND -33,249 -38,071 -22,145 -35,000 -35,000 4730 STORM SEWER UTILITY FUND 4731 STORM DRAINAGE FEES -1,587,722 -1,599,414 -1,014,797 -1,597,370 -1,597,370 -1,600,000 4730 STORM SEWER UTILITY FUND -1,587,722 -1,599,414 -1,014,797 -1,597,370 -1,597,370 -1,600,000 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS -433,336 0 0 4900 OTHER FINANCING SOURCES -433,336 0 0 4001 REVENUES -2,077,520 -1,671,317 -1,045,387 -1,607,370 -1,642,370 -1,645,000 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 120,156 124,908 95,283 125,443 127,952 130,511 6102 OVERTIME-FT EMPLOYEES 1,151 1,430 1,590 1,500 1,500 1,500 6103 WAGES-PART TIME EMPLOYEES 0 0 6,213 10,500 10,815 11,140 6100 WAGES AND SALARIES 121,307 126,338 103,086 137,443 140,267 143,151 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 548 903 0 6110 OTHER PAYMENTS-NON INSURANCE 548 903 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 8,795 9,159 7,023 9,094 9,277 9,463 6125 FICA 7,577 8,113 6,488 7,777 7,932 8,091 6126 MEDICARE CONTRIBUTIONS 1,772 1,897 1,517 1,820 1,855 1,892 6120 RETIREMENT CONTRIBUTIONS 18,144 19,170 15,028 18,691 19,064 19,446 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 21,401 21,706 15,873 21,576 23,087 24,702 6130 INSURANCE BENEFITS 21,401 21,706 15,873 21,576 23,087 24,702 6150 WORKERS COMPENSATION 6151 WORKERS' COMPENSATION 8,143 8,717 6,539 8,495 8,666 8,839 6150 WORKER'S COMPENSATION 8,143 8,717 6,539 8,495 8,666 8,839 6099 PERSONAL SERVICES 169,543 176,834 140,526 186,205 191,084 196,138 6199 SUPPLIES 6200 OFFICE SUPPLIES 6204 STATIONARY SUPPLIES 1,267 138 1,234 1,540 1,540 1,540 CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6200 OFFICE SUPPLIES 1,267 138 1,234 1,540 1,540 1,540 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 125 407 79 500 500 500 6210 OPERATING SUPPLIES 125 407 79 500 500 500 6220 REPAIR & MAINT SUPPLIES 6224 STREET MAINT SUPPLIES 3,942 3,103 2,697 7,500 7,500 7,500 6225 PARK & LANDSCAPE MATERIALS 140 0 0 0 6220 REPAIR & MAINT SUPPLIES 3,942 3,243 2,697 7,500 7,500 7,500 6230 REPAIR & MAINT SUPPLIES-OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 776 1,267 9,182 20,000 35,000 35,000 6230 REPAIR & MAINT SUPPLIES-OTHER 776 1,267 9,182 20,000 35,000 35,000 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 854 0 0 0 6240 SMALL TOOLS & MINOR EQUIPMENT 0 854 0 0 0 6199 SUPPLIES 6,110 5,910 13,191 29,540 44,540 44,540 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 1,896 1,594 1,573 2,000 2,000 2,000 6302 ARCH, ENG & PLANNING 13,950 426 1,750 20,000 100,000 100,000 6307 PROFESSIONAL SERVICES 1,959 1,481 1,670 1,320 1,606 1,366 6300 PROFESSIONAL SERVICES 17,805 3,501 4,994 23,320 103,606 103,366 6320 COMMUNICATIONS 6322 POSTAGE 5,129 2,760 5,940 5,940 5,940 6320 COMMUNICATIONS 5,129 2,760 5,940 5,940 5,940 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 52 142 0 110 110 110 6330 TRANSPORTATION 52 142 0 110 110 110 6340 ADVERTISING 6342 LEGAL NOTICES 26 30 32 50 50 50 6340 ADVERTISING 26 30 32 50 50 50 6350 PRINTING AND DUPLICATING 6351 PRINTING 23 0 0 0 6350 PRINTING AND DUPLICATING 23 0 0 0 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 2,748 2,797 2,870 4,000 4,280 4,580 6360 INSURANCE 2,748 2,797 2,870 4,000 4,280 4,580 6400 REPAIR & MAINT SERVICES 6409 OTHER REPAIR & MAINT SERVICES 8,787 1,100 23,206 20,000 30,000 31,500 6400 REPAIR & MAINT SERVICES 8,787 1,100 23,206 20,000 30,000 31,500 6420 IS SERVICES/LICENSES/FEES 6423 LOGIS CHARGES 13,801 14,194 9,288 14,670 16,785 16,774 6420 IS SERVICES/LICENSES/FEES 13,801 14,194 9,288 14,670 16,785 16,774 6430 MISCELLANEOUS 6434 DUES & SUBSCRIPTIONS 57,288 53,722 53,198 52,718 52,477 54,052 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6430 MISCELLANEOUS 57,288 53,722 53,198 52,718 52,477 54,052 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICES 0 1,098 2,145 5,000 5,000 5,000 6440 OTHER EXPENSES 0 1,098 2,145 5,000 5,000 5,000 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 7,830 10,167 5,885 9,196 11,877 11,877 6462 FIXED CHARGES 4,067 4,182 4,320 5,529 5,570 5,570 6463 REPAIR & MAINT CHARGES 14,563 22,995 17,018 19,079 31,560 31,560 6465 REPLACEMENT CHARGES 51,490 51,059 47,685 63,580 41,455 43,522 6460 CENTRAL GARAGE CHARGES 77,950 88,403 74,908 97,384 90,462 92,529 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 71,541 86,585 66,313 88,417 91,070 93,800 6473 STORM SEWER TRANSFER 0 0 0 0 6482 MISC TRANSFER OUT 9,912 0 0 6470 TRANSFERS AND OTHER USES 81,453 86,585 66,313 88,417 91,070 93,800 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 939,433 982,599 775,431 1,101,744 1,175,000 6499 EXPENSES REIMBURSED 723 0 0 0 6490 OTHER MISC COSTS/EXPENSES 940,156 982,599 775,431 1,101,744 1,175,000 6299 OTHER CHARGES & SERVICES 1,200,064 1,239,323 1,015,145 1,413,353 1,574,780 407,701 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 40,537 78,069 1,875 1,148,000 1,388,000 1,366,000 6540 EQUIPMENT & MACHINERY 12,718 13,000 0 0 6501 CAPITAL OUTLAY 40,537 78,069 14,593 1,161,000 1,388,000 1,366,000 6500 CAPITAL OUTLAY 40,537 78,069 14,593 1,161,000 1,388,000 1,366,000 6001 EXPENDITURES/EXPENSES 1,416,254 1,500,135 1,183,456 2,790,098 3,198,404 2,014,379 4000 REVENUES AND EXPENSES -661,266 -171,182 138,068 1,182,728 1,556,034 369,379 49411 - STORM SEWER UTILITY-OPERATIONS -661,266 -171,182 138,068 1,182,728 1,556,034 369,379 Total 65100 -STORM SEWER UTILITY FUND -661,266 -171,182 138,068 1,182,728 1,556,034 369,379 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 65200 - STREET LIGHT UTILITY FUND 49571 - STREET LIGHT-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -444 -381 -373 -500 -500 -500 4605 UNREALIZED INVESTMENT GAIN/LOSS -17 112 0 4606 OTHER REVENUE 0 -113 0 4600 MISCELLANEOUS REVENUE -461 -381 -373 -500 -500 -500 4599 MISCELLANEOUS REVENUE -461 -381 -373 -500 -500 -500 4700 WATER UTILITY FUND 4707 PENALTIES -6,452 -8,177 -6,623 -7,500 -7,500 4700 WATER UTILITY FUND -6,452 -8,177 -6,623 -7,500 -7,500 4740 STREET LIGHT UTILITY FUND 4741 STREET LIGHT SERVICE CHARGES -272,510 -346,531 -257,690 -402,369 -442,369 -465,000 4740 STREET LIGHT UTILITY FUND -272,510 -346,531 -257,690 -402,369 -442,369 -465,000 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS -18,378 0 0 4900 OTHER FINANCING SOURCES -18,378 0 0 4001 REVENUES -297,801 -355,089 -264,686 -402,869 -450,369 -473,000 6001 EXPENDITURES/EXPENSES 6199 SUPPLIES 6200 OFFICE SUPPLIES 6204 STATIONARY SUPPLIES 101 25 113 280 280 280 6200 OFFICE SUPPLIES 101 25 113 280 280 280 6230 REPAIR & MAINT SUPPLIES-OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 647 0 0 2,500 2,500 2,500 6230 REPAIR & MAINT SUPPLIES-OTHER 647 0 0 2,500 2,500 2,500 6199 SUPPLIES 749 25 113 2,780 2,780 2,780 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6302 ARCH, ENG & PLANNING 0 0 0 0 6307 PROFESSIONAL SERVICES 147 134 43 200 200 200 6300 PROFESSIONAL SERVICES 147 134 43 200 200 200 6320 COMMUNICATIONS 6322 POSTAGE 896 560 1,080 1,080 1,080 6320 COMMUNICATIONS 896 560 1,080 1,080 1,080 6330 TRANSPORTATION 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,608 2,068 1,579 3,000 3,200 3,200 6360 INSURANCE 1,608 2,068 1,579 3,000 3,200 3,200 6380 UTILITY SERVICES 6381 ELECTRIC 165,977 169,125 139,751 185,000 175,000 175,000 6380 UTILITY SERVICES 165,977 169,125 139,751 185,000 175,000 175,000 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6400 REPAIR & MAINT SERVICES 6409 OTHER REPAIR & MAINT SERVICES 16,818 2,364 10,814 15,000 15,000 15,000 6400 REPAIR & MAINT SERVICES 16,818 2,364 10,814 15,000 15,000 15,000 6420 IS SERVICES/LICENSES/FEES 6423 LOGIS CHARGES 3,450 3,515 2,318 3,668 4,196 4,193 6420 IS SERVICES/LICENSES/FEES 3,450 3,515 2,318 3,668 4,196 4,193 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICES 14 0 0 0 6440 OTHER EXPENSES 14 0 0 0 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 15,597 16,244 14,088 18,785 19,350 19,950 6482 MISC TRANSFER OUT 125,442 436 0 6470 TRANSFERS AND OTHER USES 141,039 16,680 14,088 18,785 19,350 19,950 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 28,371 28,449 21,278 33,600 36,900 6490 OTHER MISC COSTS/EXPENSES 28,371 28,449 21,278 33,600 36,900 6299 OTHER CHARGES & SERVICES 357,409 223,246 190,432 260,333 254,926 218,623 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 0 0 0 110,000 40,000 215,000 6501 CAPITAL OUTLAY 0 0 0 110,000 40,000 215,000 6500 CAPITAL OUTLAY 0 0 0 110,000 40,000 215,000 6001 EXPENDITURES/EXPENSES 358,158 223,271 190,545 373,113 297,706 436,403 4000 REVENUES AND EXPENSES 60,356 -131,818 -74,141 -29,756 -152,663 -36,597 49571 - STREET LIGHT-OPERATIONS 60,356 -131,818 -74,141 -29,756 -152,663 -36,597 Total 65200 - STREET LIGHT UTILITY FUND 60,356 -131,818 -74,141 -29,756 -152,663 -36,597 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 65300 - RECYCLING FUND 49311 - RECYCLING 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -20 -15 -34 0 4600 MISCELLANEOUS REVENUE -20 -15 -34 0 4599 MISCELLANEOUS REVENUE -20 -15 -34 0 4700 WATER UTILITY FUND 4707 PENALTIES -11,126 -10,306 -7,933 -5,000 -5,000 -5,000 4700 WATER UTILITY FUND -11,126 -10,306 -7,933 -5,000 -5,000 -5,000 4750 RECYCLING FUND 4751 RECYCLING SERVICE FEES -278,893 -280,430 -179,899 -302,394 -311,466 -320,810 4750 RECYCLING FUND -278,893 -280,430 -179,899 -302,394 -311,466 -320,810 4001 REVENUES -290,040 -290,752 -187,866 -307,394 -316,466 -325,810 6001 EXPENDITURES/EXPENSES 6199 SUPPLIES 6200 OFFICE SUPPLIES 6204 STATIONARY SUPPLIES 152 25 157 150 150 150 6200 OFFICE SUPPLIES 152 25 157 150 150 150 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES 152 25 157 150 150 150 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 171 6 158 100 100 100 6300 PROFESSIONAL SERVICES 171 6 158 100 100 100 6320 COMMUNICATIONS 6322 POSTAGE 896 560 1,100 1,250 1,400 6320 COMMUNICATIONS 896 560 1,100 1,250 1,400 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,472 506 1,089 1,750 1,875 1,613 6360 INSURANCE 1,472 506 1,089 1,750 1,875 1,613 6420 IS SERVICES/LICENSES/FEES 6423 LOGIS CHARGES 3,450 3,515 2,318 3,668 4,196 4,193 6420 IS SERVICES/LICENSES/FEES 3,450 3,515 2,318 3,668 4,196 4,193 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICES 262,636 262,682 175,070 262,635 270,000 278,100 6440 OTHER EXPENSES 262,636 262,682 175,070 262,635 270,000 278,100 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 16,560 18,222 15,605 20,807 21,850 6470 TRANSFERS AND OTHER USES 16,560 18,222 15,605 20,807 21,850 6299 OTHER CHARGES & SERVICES 284,289 285,827 194,800 290,060 299,271 285,406 6001 EXPENDITURES/EXPENSES 284,441 285,852 194,957 290,210 299,421 285,556 CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 4000 REVENUES AND EXPENSES -5,598 -4,900 7,091 -17,184 -17,045 -40,254 49311 -RECYCLING -5,598 -4,900 7,091 -17,184 -17,045 -40,254 Total 65300 - RECYCLING FUND -5,598 -4,900 7,091 -17,184 -17,045 -40,254 P t.,0-0a)Cl).m.ci. wE .4E'o 0octCl)•.■ 63 a)45 '-'El c o 0a) o 00 ..., c co sa) E.t_ 0 •E).'0) -r,5 :42 0) 0coc 0 -c E-i-_-0 E >c '.412 EI -0 0 co 0c < 0 0 0 2 cn a)E.0_5u- 6 _a) Et_io c -a a) w> .- 6 a9 0>c =0o> as La:in 2›co 0 c, .-0— u) (/) ai- m a)u) oc com= 8 & '.4.7-, s_al sa) cn 0 90a) oa n._,=,. a) = c) --c Co a) a) -0 -0>u)'A= .1 0 ES 45 _0 :VI E s_. ui- E c) „2.. E .- '(7) 00E =00 25 2._ as 4- (i) -• (f) 0 C -cEi CD TD :2 0 _ O > a) .> ci sii,-))•73 > O — ..— ,=. .... u) ...5 a 0, 45 a3a c ...E c .7) co (I) .: (D ▪ o .o..= .5 43) (2 .> E o -o 2 tii .") 2 ..i=c 'E -c ii, a) ... ▪ c o.- 1-- > H F-E c-o o< C) 0 La-)_cz3) cLco 1E >, a -0c 0 coK m>a) =2c) = co 2....=n 0O2 —5 17,2) cu 3 a) u 0 (f) -r< =-0 Ti C n Li- 2 = U) c a) 00) 2 CD --Cm. (j)CO co 9 .2) 17).o >, 113 (3, nn (f) zo u) To 2 -C--3 0 0) aiC `Tt C -' o' o -c0 coC!) a) a. 0%= co .02. wc) CD 75 T ° -0': 2 02(1) a) c,N T). 8 D 0) O 0 a) . __c vcs u) 2 0 o_a) a) ,- oF:=, fa T. r_s- . § -1E' _a o -,-(15.- 0.) >, o .00- EL° LL, u) a) = .-. n .3 ..o Ecp_ E .- a) 43- c) c Ecs_a) ou) o E 0 2 0 (/)a) .:E- .-'.ff ,f) w E 0 o cm 2 Co a) a) CI):la 2•i 00E 2° ) I: DCF 45 %... >% = XE °-▪4- ,6 ▪• -17; c a)= a ▪ ) c u) CO ▪ co _ _cl c. m c- (..) > = cc) -0 ,L2 CO x 1-= o -0 _0(1) (") 1E' o 1.-c.) cco .- 45 Tac a) -(T3 t 2 06 "02 cl) (-) E c w s_ c cz E To •s7- o 0 o c c n ft E 02. w v) 18 OHco...p (/) 2L.>= .= 0 c ,9, a) co a) 42 2 (.) w •-- c _c (n a. (I) = 5 a) 4-co a E .§ 0 -E- 'a-) cr w a) a)o la-) u) 0- a T) 46..... E 2 oai 2 " c) sta) .(.3 Co:-;. o ÷' -. CoE• = o..mc -E p 6.4... '...' r---- -ro .a) o o_ 0 0 -co P ctJ D = _C(1) CD 0 171-. < 1 CO 0 0 (1) r_). - 2 r: coa) . 00 0 . . 0 0u) 13 3 2 u) 2CO cC) Co 0(l)ao6- coE fa)G 0 V2 Tii a) 00=. 0 co 4.2 0 •• o_ :' 16a) T) 0)a)a u) es-6 m as E -F2 0 a 6- o CO 0) z c .c d) 0o _o >a) s- ca as c)an (I) CL E ..-0 CO C.)O CO 0 C's a3- 2 a) iii 0 (1)O E 0 Za) o a) 2 =•— .9-7 c). -. crt. a.) 0- .,:713 T ▪ - 0 0 En CI) C a 2 0CO 04 CK n co 0 Co CO0 To o co ii-) ‘1,. 0 ‘1, 1--... Nco E c0 ....= sc) E- u) --5 o -.1) a) L.L. 7Tti >,.cti chCO ca c a) (D To 0 s.. .2•P as oO0 >-07476 CO l a 0 0 "- —-c5 '01:i a' 45 c c as- cm-c• o ..c c (13()O c v -0 a) ._c '15< 1— a 7 772E7 :=111h. 8 CO 4— (-5 4— c c0 Q.)0-5 o CTS_Q Cl) W C(1(1) C3" C L_ LL .(1) CO _QC)- a) c a) u)— sa) E_co a.) > CC3 >' 2a. -0(DoE cc o _• " CCI 76 CO CO 9-COCIOcy)(1)0 a 0 4—(12 -C3 oa) 0 _c 52)o E --C.) 2 wI-' 4— (D "0o-C3 C Ca) coc oo .—2occsww-cr a) e_•— cs_ • %LIC (1) -1;71— la) 0 CO -0 co co c a.)2, -0LI • 4-6 0 .(7) cpo '-'i x o a)•c ('0 o c0 wa) - 0)0)(0-w -oa) .5 (D •c 2c " ▪ tr)O 0 0 cna) (Li a) 00 0 >0 •42 a) a) u) 2 La;w co TO3 E8 a) .(7) 0- 0 E '5La L-,1-1)•o a) aw>(1)-0 _c1O— 8 T)o-) 4- CO0- c • 9.2 •c -o a)(/) c o. _o x(,)>.° • cf)-c 2w Ll=(1) a)1— 0 E U) 0 U) C D O - r) 0 > (1)112 >4.7 • -C.: >1 o.7=-1 w -(7) 0 0 : FT) P . 5 ti , o0-) 01) .° -F , ,0 o o cll (1) GO 0 -00 MCCDc .12 o ww co .4=c — o -2 2 •3c -o 0 _Q • ;—-C 0 a) U)E cj) (7).t3 u)C 0)co 0 76c's c0(0 in cs- (I)CO, — o ECCSS.- CO (T5 "•0 AroOco E CD w = ca) „,'5 7 c73 -c ÷(15•5 c 0)452 E "S3 u) CDCD _ (,) C (73 E.o E w cri (7) 75 -C x.5 (al 5 -(1)-0 2 0_ as cci0 T.,) a).c a) _.(:)+.5 0 -m••■■•■••=1■101111.11/ C. _ C I . 0 ii) "fiCD CT3 -0 wn U) c:i---, RI 0 -0 (/) (T3D(i)_C 105 co>u) E a).— u) a)_0 0 c (..)CO '4C/1 oii ccaU) n E00.z_-.0 8wc CT3 a) t •o -0 a)c)..c.._4J 76 -0 Po D U) C U) C C CD oo_ ccoO(/) c.-7-7,I. ._ 46 '8 a) a) (T5 - (T5C E -0 oo -0 a) T.-) = coca i1 o > 2. ..g. (13 O 8 -E)su2 ._c u) 0_ o-)a, cs) a)M w o c E D C 73_O TO E a) 0) •E wO.2 g w cco . E.T_J c0r 0 Eo 0 D • — ..--• o E a)o o co 0 c 0 a) o t 0 _c D 0 .0 o o c45 n) a)i.-_ •,..,7, CD 00 (1)L- (.0Oa) m C (1) ,_ u) w .0 uic.:. w -.-(7)n ._ a) 8 0_ o iT) Zr) CD -0 o E OEEEOE o 0 0 0Ar_:. ..(_(112).L ÷-,._ _Lt .5 .... 4ri)(1.) ,.,..6 4Cii -Iiij (Z o-e- E -_=,E H w as D D U)E co 0 0 0C 03L. a)o (K3 o s_ 1--- 0- 0 0 0 1— a, 0 () 0 • a)_oco ›Nco pco a (I) ca) 43 D 2E. CD0M 0_ C 2 coco p ...=co 0 Es 65 Li5C) >,•co c a o p(I)co a) o 0) a) .:) T c(1) -0 CO (0) 1-1-2'a) 2c c w ,3)a) (1) ...= 0 2 co>2 2 cov) c3) E 'cT569 a 16 a) (n 2 a) z, E Q=:= 45 E DEz-,Kil _0 0 ›, c 5 O w E tii > n D 0) a) .11 .78n' z 0 ° 'Ci, .z 0to /0m F , )V vrii 0-, 00 0:-E=c)coAE1 0DW`E' E (L)w> =ct3 -5 oo0-w0 @ 0,,-. o (%75 a)co as oa) c cowo .(--) ...=,a) ,-(1) a3o)o U) LL T w...-, co >U) 0 2 8 a)ci--(=,-; T. E ..11-2 ..o ._as 0.,-. 0- -cic 4E1 D (13C < m a) cz 2 0 co E nco>.o co E 8 8 o_.--o r--. 2 0, in (L T5C (D= 4--.o E ., -, a) N...- o wiii ea.-_7_. E2 cy) a) 0>o o La°) oas as co 2oco a) Tj- E a. ascC ), cTI3 O 46 '.4., cs) C >a.) >, as Co 0 C T15 _C0 0 (. • 5'5 (f) .4= win' , cm Ei. -0 E (ID) C) D co a) C -0 o w c 2 (I)12 ,ala) ..E -_.=.4---' ,__ c)-) :mg, o a)- t c 0eu cu >0 o 0= 2 0 2 -3■11E- T, 0 oiCl 0 , o Cl 0 < 03 CC co cr, CO CO 0)01cs, -4: cn to 69 69 01 141 I N-OC.) CO CO 01 09 V) EA 69 E") CO 0(0(0N-- .61; IN (00)03 LOU)01 0. 09 0 (1) 0 (1) 11). V) 61 (.1) 1.11 Zgh-L6 t6.(4-0) 52, 01 0 69 EA to CD -61'01 01o cc?) 0) CV 0 0 0 VI 61 CV 00 0 0 0tO 5)5CV CV CO 41 GO CO GO U) cqo CQ 6t CYC 05 d CN Er) 0 0 61 CO 16 CO 01 aCN (1) V) Gf) 01 oa co (,) 05 N,(7) ACO CO CO 09 IC) ,t 't,TCOCV 0 0 CO 0 ci tri <r) CO GO 0 0 09 ‘caco. .ci•0 •cz) 01 (s)oa)o A 8't C3 0C0 - . CO § 06 co o0.oo " 1-011),- 1 CO 00 01 00 01 0 0ID COI r- c) r I ci GA 09 09 09 09 4.1) 61 61 V) V) e , co c.; < N 0:31 LO,t I I CD C'- U) A6 (.0CO 010.-C3 IC)U1 N.. 0 (;)01 CDd L6 (1) R 1-11 0)C3) T-3 0 CID 3 (0 CO V) COCO VI en 0,cotO CV t - - t ,i, @ ía: to c (1.).._ co u 16 .SC CI) T1 )ft2 E C C) U 0 'P 0) 0 0.) 73 ;:j 0 c C C 0 C ,c•-• 03 in CO 0 a) ...= ca a) fLi a cn •--- . _a) -o C3 1,1 a).(5) 2 V c a - a, 75 0 cto we (19 v, .,..,.-.,;, < La a) u_a) 46 2. 2 ,.... a, , a.) v 03 rO 4 ci, •C C3 re 0 c A , C 0a) in cp , a.) a cr, ..8 .,..Y @ F, m 0 ry .C624 ': iLa)(1) '1a)C '.(3:-.(1)6 •(-)C1:2 .... ›-, 0 r_.. - .( I I cc '' 1 a ac CU> :5 Ti (n to .(2 43 ;.(1- o (.3 C a) E. Li75 0Zty c c a) a)o w ii.1 8, 2 - .t 0 . 0 .-0_. !.-_, t0_ _ -4 Ic a.:, P. 03 > 6' g g 7'3 a. P_ a a ...6. r3 ca.:-: a ri › a 0..04.3 m W CC 31a •4 1-.-- Ce 0 .li C(1.) 1:11 (1) (1) 0 8(ii-it. U) (/) 0 0 I- Li) bc Li) LL) LP LS 2a 69 acooo C 4.;oCI).d .24 'OE! a) co U)'If-j o0.. .0 00 C 0.. -0 *(o o0 0 C75 CO a) ‘-r .c 2 -o CO V) ra a).c C) t.)U) To- c t- o a) la co .20coa) Et? co I-) to '5 e f.E2. cr) r., 0. (1) W0).0 03 ra 2 .... 03 E CO (i) 12 a) iti c 0 (I) a, a.) a o a) .c( v) (... c a) 2g E .8 cib. 2 C troE.a) aL v ) E • 1 3 (?) C ._,. , .-a = (1) (1) 0. .c 8 (t) (0 C)C3 Q. 0. 0 a) a 0 :-i tu co '(.3 g,,, CI - X D 0 co Lcup gio• rinll 0MI s-0'4-.. "CO in 6H ..1.n. I In I-1th q0 0,-1 . ____ _...... iii ToU t.., a)a.0X cilZ a, >c -o Sa 0CU= CY 0)0- CU4-1C13Ce oo o6tn. 4-.ccv c›.Yeooco` MOC•——4.)130 >. U CDCe lti ,. law a.Jaco 2 6 1■11 4.0 Ea)TS 0) m r-:761.-- Ce If?LI- W 00u6ilk .el d '-'•W 8cc 00 0o 00 0 o .0 o 0 0 -cn- tNi 6 t6 »6 4 c‘i ,-, ,-1 irk th ilk 1.4 V} irk n fl 4-1 a) sti) L) .!--, ... aio uc.o a)0-‘-:- a) Q) a) _ M • -..---,> fzu -0 ,r) e > a) cv) .=0 a) = 0 -0 0 0= v)cu 0 -1--; 4-J 0 L- > (D0 V) * M ai0Li? C V) ci . --■0 WI 0 0 C C-1-J C.) 0 co D- O cr) .47:, c=s- M M >" (..)0 LI- (A = 0 a.) C v) 0 oCI = M _CT c E L._ot+-, v_____I •==. .47J Q) E t„, 1 co n --c ()I-1-$ 4-1 0 CU _--' ) E, ci,L) >cu -1-+ 11,i M . —0 -%-i- CI,,= 4=) X 1 • ■••al 'V U -0 tan 49•(i)1■ .1j C M C C i.4= 7-, >'CO 0 '47J St.) r E cu ci,' 476 acu 1 o r6 c o0 1 , 0,=, > 7:5 C 1 ci) , a), v, L_ C6 4-,m o c u bp = 4..., Q.) , CU L-W" V E 75' m(0 L.), o o i---0 0 u cx orA 0 0 ccu • —_C -04-1 v) _0 4-) a) Q.) 0 V)CU>-• 0 C 4-j '' 4_, c • - C13 I- E -1(1)' , >. >-.1-, •- bp 73 0ms u c -0 en 0 • = W Q.) CO s-L._ w — -0 .c E To 0 'a)'a) (1) '5 C --' v) " -C3 >C)_ _ C m r 0 3 • — co 4--; , 4 cr) v) cv) a)0 4-J — a) 0 r.i > c° _a — cu co _c,4- o u _ Q) a_ n .cts c v) 4-,4-° 0 C • - 1: —C . - C ci.) = -a (-) '.1 ■./ CU 44- 41-) X--I V) ai — L- 0 ,.C., a) a L- 0 oco ''E cE ‘-i 4-, 5- v) co co w v) v) U ra Q) 4-, 0 S-- - cc)1 CS,... (1) _0 W -0 CL) .2co 4-, -C3 v) 0 >• C2-2 tf) ti i cL i - -N! = -c c_ i_ con CL .'U MCU M MI = 0CL — 0 _c in C t10 -0 0 -C„ CIA > C 0 a) s_ bip C C .1.7-...." '4-- > ci) 1.- a) 0 C CO inLn 0 0 .I-, > c()CU -C3 CO CO = "-III 4 a) --E3U C ,>-' .c 2 < CD CT v")•co ._ U .i-J V) en co :I-, .4(2, v; _c Ei5 cu CD CI .4-I >, Co/6 LC) L_ = i..1-NI co v) o ,.._ x LID -Ci U 0 .) -1-jcV) d' > 0 s_ Q) 4-j = CC1 0. a-) =4--, co u l'i C >" v-) a) E cu x0 a) -o cu tip " 0 s- Q)a) ro (1° (-1) 0c 1..r) a) • — (3) a)•C I-2 v) (1)0- .— 12 up -1-E' ,.., :-.7, a) -._c4-, >... V) .4-.) a) 4-' co= co ro ,_ cu Ln (1) -n,-- > a) 4_, 5- c .tli_V) -I-, _ -0 _c U ill ca CO U 4-1 4--J Ca 0 7566 C 4-1 CO CUD n -om Lo V) = V) 5- C -I-' -C r- 73 .-0 >. a) co t:(0 rn.- o a) L-- L.) 4-co b (r) v) *,__I- a) 'a (7) = - L_ L_(y) a, 4--,M 00 v) a) -0 +-)C 0-0 a.) a D.(1) CU r," C It +-II---L C Z Ca (1) °CU -Ckj b - ij -51._)" .>C- _CCI) 2 v,v, Q) C 4-, v) s_ .ti) a) a) L.' ,v) k ela 0 -C3 .4_ ▪ , - V) V) V) _c Q.) v) .4_; v) • „- U _C sa.) -C = .1--) V) CO 4-) CU4-, (13 CU (i) _04- 5- CU a) La- co 4-, 7:',_- o 0 (-) — D s_ v) 0 Q) _C S- . ci -a_ >. ... c "0 I--. (.0 v) 0 4_, ro 0 (a -0 °4-) a)0C CD." -C CU 0 0 /4 -0 s_ C 2 " = = 0 c.- = (A 0 to (r) _,4 c 0_.- Cv) (1, ra v) 5- 0_ 0 0- cr cr co __•,— tr) „-..- s_:- 1- 1.., CO 0 a.) • - • - 1- 2-1 L-1 (r) L--‹ (1) ' CU a) cu 2 –C +-j CO v) CO 0 U 0 C rc3 i+.• a) 0oorocum>c--o in " E co co I- +-, C -0 r,- r, Ts .ir, +-, a) L._ „,v) o_ >.Q (/)._(1) ' - ' -'-` %'1 " CO C -0 0 w_ >-Z E 0 7-:Q.) bD U CO s_(1) E "-- :' 0 - • 0,L,-.cc cu >a) > cE To 0 >- '•-, = ■-, > .47, — a) a_ (1) la) • — n c ..+7; a) (12-- cr ,4- cc) _,co = 0 7.-, E 4:3) t 0 1:0_ .> cou =-_ 0 vz .0 _‘2' o v)co ,.. (i) ..4--, R. 0 co a) *5 +E' '5 0 :41" _cp 'id ----D 73 @ /3) 0- Q) C75--0L7 00Q)56 - 0 C:2- 0 'a 4E' " - C 4 - -,0a 5.- 0- -0 T1) 0 V) ::::,- a o H L__ U v.) . - cc) +-, v) < 0 CD Cl 0 cr.) Cf") y cNi 71= ce) (1.) CA ;-1 CA CC (1) ;•-( CA ;—(;•-1 ;-■400 771•.--i •v-I ••-••4 0 0 0 0-) bf) 711 •>-co ..i..7, _t_L)...„= -rl: c `-'_co -0 a) COW „DM Ln C ° 0 CU M C 2 'et0Cl)co (..) 0° Li) s_ .4-)v)S- 1-1- 4==co cu •_. 0 0 _C > o ▪ LI) Q)U Cl) U co ci.,= (A0 >- •Ln 0u _0 73 0 "0 0_sa) 0 (1) M a)CU To -c 4-) -0 _c (/) 0 0 (1) c.r)CU 0 +.3•_. = CUs- +-,4 ,coO75 C-cu CO 0E 1313 CLCU cv L_CD L-(1) 'rowcu --F3 a. =s_ =_c (f) co 0 cu -Pj.)L._+-, uL_. -0 0 v) 0 EOc CD • 4-,t+- ro -00 v) ELn›.... .4_, 0 -Ca) cr) 4-,-o co u cn cr) CO N.> ci w m Lu To..c "e Ln i_— a) (./) -0 •ui ,v) ua. E -.c c v; co c >-(i) E0_,0 a) co• :7 73 CU 14- -0 -C3C :1-1 0 u a)>co E C ...c 6 --F)L_.w a) 2 a) 4J E4-,cn CU oH • E o (i) i-..— 7111.11.11 - CU -C3 C:5 (r) (1)fa) n3 = -C s_. (1) -C0 (0 V) V) 103 -0 14.- C 0 4 _1-0 g v) = coc 4_ = :1-, co .47, (0 ._ 4_, +_,,._ -C op izuC U0 ra C CU .4--) > e-CU-I-) CI) 0 -0 0 s_CU -1-4-)-0 a)C s--›CO 0-- -0 roX 46co c cu a) E co 4--) Ts c .0 v) 13 ›- CU4-1 a j .§ § s_ c s_CD = co C >-D 7u . g 7:3 0 0 (..) 7:5 " .4-, c 0- co 0 (j) cp a) s_ c E 0 ou o _o 4-• 4_ 4_,4-5--C -C >CD 73 .00 0 (1) FT3(I)0 >-0 V) " CU Eta. c to (r) a) c c E (1) ' a •E o — _c c 8 :E)CU :1-° a) • — .§ E cta › (13 o 0-3 6 glE)4)0 -0 0 CU -1--c ci, a) o a) 0 0/,w(./)q--0L._ ro cr)L._coO, 73 0 /-:bp -0 0 C OD 'Li) C 4-;*-E CD L.)5 ""0 w w = -1.--J>0 U- • 0 -CCO 0 (33 (1) W" 2 a 0_ 0_,co c co'› e•W E n 0b.:-co °472 0 LI- U '... LI) 0--c-', (D 0 --- ro an 4-) 1-L a) ra-, (.1) (9 7 0 0 ( 0 0 (I)(/) ts J4.-a co (f)C .=m . , .L_ L10 CU tur e-- 4 9 . -i—J Q) s.—, V) ° —0 O 0 •-1—J '-o ulki— el)41) -0CV 0 v). 5 w __ - cr) (13>. L_ tn O ...0 CO • _4-3 CO - ,..,— 4—) c L.) a, L...; .,__,_, 0 cu 0 0 IA— (A 0. cif) E v)_.0 c cu 0) v)•_.el i (1)0 W 0 E,==.0 , c ...r=3, > •r° E0 ac+..)00u L_ cl (NJ CNI N0 wi w %.---i 1=r) (.01...a) ta_ L4_,CC 0 W 0 0 0 0 0 0 s_0qin • I.,.1 C10 1/40 r-I 1-1 1/40 ,--i ,--1 1/40 i-t(1)1 i>0 "----, ■-1 cr.) rilCr) ----, 71- ON 0 LI),--i .t7t 1"-I rd I 0(1)-4.--,C1 '-' 0 ,--1 E ,-0•.•-1 tr)r , 1 ;-14--,ri) CACr)1-1-I'-, •q-i '70.,-,1 0.-) ''''''',-4 PI I—I •ert.r,r) .2 ,--1•• 'I ..t .._, •ri- 0 aN A .-c) ‘—1 0\...., .....L.t. (1) cr,., H .r1-.., 10 ,-1 ,8 in 4-,C...) , d r4 "0 ;.-4 bb tr.)0 CA (Lu d (i) C'N 0ri0•,„ ---1 o',;--4 71-(1) a0 0 I8 CA .....t-..(1) ■ .0..).1 't 1 . ) ql 4 1 I • 4--,r--1 * • - 4 pi LI .1.1 " c';4-14) 0 Oa\ec'Z'l Cr\it (i)[4 ‘1"4 P-i '71-) •••• 4 cu v)+-J os) 03 _c ro E ul (/' •c eta 73 .--eW 0 0 G) 75 S- 4_)C I- LI- 0 0 a) —. E2.3•9.0 V) ''tn.>, E ° a) ° (1) "a) LA oc E L-._ +-1 0 , , a) E ci)>- 'n4-0 c) -Wm M Cl° 0 tj ) +.•>4 0M 0 0 Li-) 4- 00 >' en o2cucf) .4-) (,)-- 4-1 ..,...r: m '-'@_.3 q— a) tab L_ %-i. . 0 -1-J co o_ (1) v) no (1)C 4-CU VIZ - 9- (r) +J 0.4.rpm 0 4-'cics (1) u °C 0F3 CO a -ci) im 120 C--_-, Cro 4- ," . a) a.) =ii 0= 7:3(a) co 21. >. 0 La (73 bl) 0 +7$. — CP (1) L-', E .1-- 2 E 46j) [2all -a. vi° ,,ci >,4.9 c _._ 16 ._ ._ " 2 iv 0- (4) cu 0 rd a3 n73 0 a_ (-) 05) L) tan vs) -0 +vi Ln+j 0 LO Or —C3 CD -o0_c4-)a) hiiiI g3 1 bUO sa.)-1--;-I—) 1171 0.) (0C COco cu s_ co 0_• _-1-, CU -C30_ = (111 4-) 0 7 CU C -0 COCDd' 12 (1)CDv--I cm E co 7:34--)W c.cr)-0)U M5 GU Cl.)Na)a) c c 0ct-1—.6-% IL (1:5 0 L__. (,)_ Ln L__ •.4_,,0 S— -1--J w 0 c slS— UCCi— CD C a) CU o0 0 -I—) • —- C (13 C. j3 0 CC Dwc5)*-1-7 -1--; ▪otl) ,a) (/) cL CDC E cora 4_) u 2 4_, w(1)CU ci) U -0 (1:3 _ E > L_= a =o -0 ("0 CU n...= u") -CT 2)) _C c_.a) 2 4—I Q a c > o cu 03 U 0co F E 0 a.) 0U 0 a_ ....., Lo,.4. c) 3 33 .3 C\J t0 < 4r...to. ri ii-to rli 0o ,... 3 ' 86o'T. ". 0 ei 80 ci r-...- 8 woo r..: cri d “i ,-. cooi '...f .....! ;.... co el •''N 15 r8 't '•- c, 80 8o 8 9..., 8 0 00 o ?8 8 8 c . g —6in 6CO od coCV ,4) qf '''-' .?00 oi6 .- <I'to ,t.N nry . cl.co -csi 0 Fri ::":10 (4co r- i 8 r-i 01 7, 4. >- 0..i 86 8 8 80 8 8co ,-,eP • 84 2 8 c'r, 1.) d 6't.8 ---i-4-400 o0 OL)')id' CVv-:COco CD (Li co00 COlei lo.4 0tri OD at al to6; co ,Icl .• 2 si,- -.....A 8 2 r;i •pl I-■'it;"..0cq 0001----CO ,i-100. i-,_ i i 1i l 2• V)W ' Lg.tillU i lnal 14- '111 >7Cr41 I■ cr)I - chZ 0I I- Io _ , .. , ■0 ''-i E C (W Et,b 1: C 1 2—occ aa ff,6z uj :a '4ICV O. 4CO WCV :....-0 7 ..,LD -' CE C° ElV — E co c,V ,t1' L0 CO R.'113. 10 8 8.6 In a ao . ci a ;i:.o 4 4 Cl aa oq.'• q a am o8.2.8 A0. 6R 3.; ul Cl 8Cl 0 fg,--000 OP1 M:r2▪ur,I n 4 a, OP 470lo °Fg',930-sr-ogT---888o o 836,Tilo 8g218 0 83 cri owRP 177: 82 0 Cl m o m 0 0 0 190 . 00, , . 0 0 An .m , fil 'A6 ;:oog g6 ei n a, (93 0 10 ON 000 W 4) .16 6.- a E 00— . 00.0 0 ,,, N0- 0 e . 0 . .o.oomdmONm o w q n to ,tn o m nnn 6 4 o o o0 0 0 0 oo88 0. , CD 0 0 . fl to71./n2PCT) g•Ti g ( • 8f71'to • la oo oo.•na 8 T"N.W8T1oo8 N80 I. g qg ,gr •'01 ;1 G h▪o2 0,4 a F02.°00 - 0 .7,ION 10 0) P8A-fiVP- CP_ O WLAS-V0888 0n e, a k 8 •••••co ■"1, rcji <4 oo SAAn; st_nm 4 CA. 0,Op . 0 . . o 822r• • • 1--, . .a 5.1 e 6.:1., nO,. . E o 0, .0 03 03CI. . 0 19 CO 0 .. 0 F.T1 4-i 6 o o o ,e, . g c7, m T f1 6fi. . . . o . G Aa o .n . co .. .o . . . a eI r811 2.51 ,Td 1/1 .. OA FP.0 . . .o 82gn ; m cl ,6 .m N CT,•. o o nry-AH§ o 0 o • CA 0CD 03 CO 00 88CO C9 cO, 0 0 CO .. 6a,o2rgm- , 10 U rEIREM PSEM9-g 0 RIF,E '61tf•t+. oel 0110 83 0 id,.10 0)1<o" cciLi a i Ii 4.1 .1.1 W `.43 It eo, ; ;74 gt2 8L1 °7- 4 4 01Ill dd I amo Ol In 0 00,0 0.0In 0a00DtS Cl It 0 1.71 Cl 09 '03 ci L,- 0 E i.10A1 KEHP' ',1-8 2010V,Iqmg§,am ,.5_5E0sligWsITHAP ":E p_aagOg?Ng.ga_tapaallatOrn.212"°'8E .E.w.paac, 886e4W7g, A ft.E.08 ,S wtireg 8 !EOM 2 .41 (113.5-01 5 1i.1"21 8 258▪cr,0,,d0 en2.32 In '.371 0 0 44 ,..: en r-1 0 t‘i a 1..a)t (13 = Of , s... itu 5. (1.).1,1 til 0 C 0 — CU ID 000 H .- 9)la0I ..... di 0CC ..ro-di >=cl) (75( .B, 11L .4. . c ,--, - 7- 0 C.-..7-4 cl i,-_-) 0 ,- co0 1)L_ 4,-. N a:' 5 2L., -0-al u,_ _ >q..I. ->IDI-0_C0 4e ..-1 o_ ..7 "0 L. to0 CU NI... 0 diIf., ›.di Zu_ •.-rodirn 9) 3 g. 43 0 FE' aal co CT. ' 01lb C CCCCVI a Lo ...a tr. 9 _ cr, C')0VI g4) Ln aS 0 try ,c1coci,:ttri. r• al...A cr. C;ff-,try 0C CD6 C'1-1U" i 06 chV.1 4,1) 0 0 0 0 0 0 0 0 0 M 0 C■ 0 0 0 0 th6 6 6 6 6 6 6 6co kc. in .1- 01 N .1-I trl 4,7 4.5 trl trk V* VA CO T- C \ +-J-O LTA (1) :4-75 0 -1 8 ci8 CO `,;< 17, 11. zcc — <1,1 0 to (13 Co If)CO 1/1 LI") cc cn (L1tcrco 0). NJ r- a! 8 ci8 N 8 8 CO cg 4 q CD 0'1 — 2 cd N:0•1 03SD h 0 01 Oi h !--: tri0■1 ..4.0 8 cc 8 A CO cc -4( co8 cri 8 cc CO r- 0,1 8u-; <si N T- g 6 A E.;-n.A 1 1 ?::2 P Nhi4 u 0,4 V (M -q aMP .'`(=M X 10 11. 1 . .11 19 191900 r F . .00. 19 ! RR.AA g2 9 Fl3PARrig6A6r n- . . , :71 El 9. 19019049 0490490 E.1E 49 49 19 19 4) 19 19 4919 19 WqV Wa48 • F.AltV 4040194149 00000 PAM s E 0-Ev(4 H . 490 4949 0 019000 2" 80 tz-, ; ...N. . 0.0." W6 6guifl 1000049 004000 L2 .EFF,! 'AgEME F:Firtio „„0„ , , 0 .00.. 9. d III 1900 1 ARAA Nmii A MYmn,8 .0. ono 1.4 N MEA N . sf g, -t .‘4•S;■(1 o39 88 58 88:7 00.0 co 51 00. g 0P8 A 'o F o .0. .= a.. 3 823dridstm HA4 0Hd •0iZ N .V8•w.n .0.. e■; "N 1A:j r Cl (.4,f. Wr4Wi711, 0 RR.Rrzt,1 •1/1 . 0 1019010 01901019 2 '1 OgC-84 001000 ...N. 590 149 49001949 00000 000 00 WaMPNE' EmEg EgFr 19 4900049 A ,n 2 ygga". 00(4 0 4919 1910 0 0.00 ■11 .... 0.1 1 1 hPs5AAig -Er16 raL. atoi .,A8P kEW Hi 1 •0 40 r • 712,eA E1V 0 0. O 0 000 g 8 80 4 0 'O ■:1 gg E 7,1 N1ANN O 0494949. CD to -1•11111111 COto co ,r0 0 o 0 0 o0 0 0 c, 6 6 6 6o-, Co 1,-. CDVI VI VI VI 0 0 0 C)CI C3 0 0 6 6 6 6 ,-1- Cr) (-4 (--1to to (') to r88 s II torncn ain •Kr a) 6 e,-, NJ 3,4 i■ i'■86 q 0 il 88 8 8 §ci.,- cdal r) , oi N •- 8 .4N. .-nt .' ..a Acs ,-:CI N. r- 8 oo ■-":1 rn 'A g a,e-i t--ca <06 (NI 01 kr, ,t cv.- .- I-30,=. F 11 w 0 En i 09 <8 M —I 1 CC a CC La :'--“!s r,i ! IIICC (9ZU.1 t ICC CC Cr° ' '0 a.tn 2 0 , ., t- 10 0 coc9 I.i„rstFT. 0 171 g - 0 CL (.9 CC -Thw 8 8 r LO (.0 t's CO Cr) C) (NJ 00. g 0 0 0,0.00 0 .... 0 0.... U) i0000000 t 8.., ,f.), VP) 2„gr, fo° ft E.i y00 EA Cl g!W 24 Vg ft g f1:2 r:1 8S'‘S' o. co°u; g ME.°NR.2g 11, fig ra. 00^N 00. No-22 6 0 0 14. 0 . 0 . A 8 2 8 .151 2 .9 m . ...OW 2 o o 0.0 t P 3- ?.? . C CC .°2 '427Not00.';LVE2 E.*. P 2 . . n F= .00 "ON40."VP.2 . . §66 2 o',=-1 t . ..... '4 g;g8. A W AN 0 ..... 2 E...E6 ..... ri 8 68 . CCC :.--(1.1 713>C(t)"0 0(.9 _ Iva-o_cLI) - .... fu On ri .1 4-,C 8 C‘i s—0 t--1ark0 --rse-oo■-.co 4— " .3I—cu a,.. s—w v) a 6 A -Pm ir II fu,„- ,u 4.... CU _ E 0+4 .... .-i .o)UZI ' a -oo (1) a 0—I CO Lrl r1) C.4-tr)0CtCD 'CI 0 CD Ce Inrnkc;trJ■ .dm WaoX fu2 111, _ ti 00dr\I4,f) 0ci, 41.4 8 0c: ii)d in,-■ v-, 0 41 It RF,E. g 4 St 88A . . .820. ■- It 0 0.000 .NPE. It .4 .4 ;.1," .2 2 2 CI 4 , 8 U E"ni A 8ovei 14 '449490)4) V2A 2" SNRClInt-.T . o ....• V- .iiitiii. 6 odi,ci fi. . •....0 O 2e g 0 . .1.2 8 F 0 .00 0 0 0 .■ 00 60 0. I t ■11 ciaidID St 6 a . •2 !▪Po -2 13; 74i W 000.0 0.000 0.00. 1 F.' 3 2- E, 8.6 It 2.E 4 0.. 3.2 °•21.1 . 0 3 .2 2.E It 3.2 8 8.6c!6 6 E tI • Cl c i4 ci6O Cl 00000 Ottl. 16 M. 0 . o 2 6, :14 If 0. .0. 30 0 0 11 0 ..F tmJrf InAg N3 '3 2., za" 8c7, ss..; _ _ r.- .4Cul .-MI Iri en .t-i0 rq L.st kdV) - ro › g VI15 $44.1 0 0 444' S..._ (I) tCUD In . ti4-,gw0 CY 13) 174 CriLri oo nt CDbJ)&..._ CC •C 4-0 OD•— 1.- t" Z LI= Lj 4-11CD (I)L.4=1(1') .-- CU C W inr 0. ctto -u .-0 (1)G)Ce a.1 4r1 LI.04.1-1 X{-4ter >--"0•2 C.a6 rzr .Da cd C.a r--- aD.ID a aq aui a aaaaU-; o aa c_, th i-i 44n, SO tr)til to VI 4,1) VI 11) Rate Increase Rate/1,000 gallons City of Brooklyn Center Water Fund Cash Flow Analysis 8.00% 6.00% 6.00% 1.51 1.60 1.70 Actual Budget Proposed 25.00% 2.12 Projected 25.00% 2.65 Projected 20.00% 3.19 Projected 5.00% 3.34 Projected 5.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 0.00% 3.51 Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Revenues Water Service $ 2,297,340 $ 2,368,682 $ 2,510,803 $ 3,138,504 $ 3,923,130 $ 4,707,755 $ 4,943,143 $ 5,190,300 $ 5,190,300 $ 5,190,300 $ 5,190,300 $ 5,190,300 $ 5,190,300 $ 5,190,300 $ 5,190,300 $ 5,190,300 $ 5,190,300 Bond Proceeds- CIP projects 1,800,000 2,000,000 2,000,000 Water Treatment Plant 9,200,000 9,200,000 Misc. Operating 21,986 3,700 7,400 11,100 14,800 18,500 22,200 25,900 29,600 33,300 37,000 40,700 44,400 48,100 51,800 55,500 Misc. Non-operating 8,328 7,000 3,530 5,383 2,822 2,887 941 260 403 1,056 310 1,599 2,503 2,334 1 ,825 3 ,539 5,391 Total Revenues $2,327,654 $ 2,375,682 $ 13,518,032 $ 12,351,287 $ 5,937,052 $ 4,725,443 $ 6,960,702 $ 5,212,761 $ 5,215,797 $ 5,218,844 $ 5,223,911 $ 5,228,899 $ 5,233,503 $ 5,237,034 $ 5,240,225 $ 5 ,245,640 $ 5,251,191 Expenditures Personal Services $ 479,762 $ 492,468 $ 502,193 $ 517,259 $ 532,777 $ 548,760 $ 565,223 $ 582,179 $ 599,645 $ 617,634 655,248 $ 674,905 $ 695,153 $ 716,007 $ 737,487 $ 759,612 Supplies 144,169 211,660 178,360 183,711 189,222 194,899 200,746 206,768 212,971 219,360 232,719 239,701 246,892 254,299 261,928 269,786269,786 Services 542,477 694,970 656,419 682,676 709,983 738,382 767,917 798,634 830,579 863,803 934,289 971,660 1,010,527 1,050,948 1,092,986 1,136,7051,136,705 VVTP- Expenditures 285,000 293,550 302,357 -MIN11,427 320,770 330,393 350,514 361,029 371,860 ,„_...&.383,01 tig.394,507 406,3421406,3421 Depreciation 622,805 700,280 735,294 753,676 772,518 791,831 811,627 831,918 852,716 874,034 918,281 941,238 964,769 988,889 1,013,611 1,038,9511,038,951 New Interest-CIP 46,500 31,500 18,000 6,000 New Interest-CIP 54,000 42,000 30,000 18,000 6,000 New Interest-CIP 57,000 51,000 45,000 31,500 10,500 New Interest-WTP 552,000 540,000 525,000 508,500 90,500 471,000 4:50,000 427,500 -76-3,500 377,250 348,750 318,000 1110"-34,25011,7248,250 Debt Service Interest & Fees 61,772 62,435 60,185 57,571 54,575 51,031 46,910 42,347 37,354 31,867 23,903 19,495 12,736 5,634 Total Expenditures $1,850,985 $ 2,161,813 $ 2,132,451 $ 2,793,393 $ 3,115,575 $ 3,215,453 $ 3,251,279 $ 3,350,773 $ 3,394,035 3,438,091 $ 3,479,551 $ 3,524,547 $ 3,578,521 $ 3,643,585 $ 3,711,159 $ 3,784,768 $ 3,859,646 Non-Cash Depreciation $ (622,805)$ (700,280)$ (735,294)$ (753,676)$ (772,518)$ (791,831)$ (811,627)$ (831,918)$ (852,716)(874,034)$ (895,884)$ (918,281)$ (941,238)$ (964,769)$ (988,889)$ (1,013,611)$ (1,038,951) New Principal-CIP 500,000 500,000 400,000 400,000 New Principal-CIP 400,000 400,000 400,000 400,000 400,000 New Principal-CIP 200,000 200,000 200,000 700,000 700,000 New Principal-VVTP 400,000 500,000 550,000 600,00Q_650,000 71) 00 W,60 0 -8-61/M. __.875,000 950,000 1,025,000 1,125,000 1,200,000 . 1,200,000 Debt Service Principal 120,000 123,750 Transfers Cash Capital Outlay 1,770,000 250,000 40,000 30,00030,000 Cash Capital Outlay-VVTP Total Cash Requirement Beginning Cash Balance $1,999,123 $ 2,960,137 $ 2,353,036 $ 3,588,911 $ 1,881,482 $ 1,924,727 $ (627,202)$ 173,598 $ (268,746)$ (704,269)$ 206,768 $ 1,065,762 $ 1,668,396 $ 1,555,867 $ 1,216,585 $ 2,359,540 $ 3,594,023 Changes in Assets/Liabilities (37,210)------ Cash Received 2,327,654 2,375,682 13,518,032 12,351,287 5,937,052 4,725,443 6,960,702 5,212,761 5,215,797 5,218,844 5,223,911 5,228,899 5,233,503 5,237,034 5,240,225 5,245,640 5,251,191 Cash Spent (1,329,430)(2,982,783)(12,282,157)(14,058,716)(5,893,806)(7,277,372)(6,159,902)(5,655,106)(5,651,319)(4,307,807)(4,364,917)(4,626,265)(5,346,032)(5,576,316)(4,097,270)(4,011,158)(4,050,695) Ending Cash Balance $2,960,137 $ 2,353,036 $ 3,588,911 $ 1,881,482 $ 1,924,727 $ (627,202)$ 173,598 $ (268,746)$ (704,269)$ 206,768 $ 1,065,762 $ 1,668,396 $ 1,555,867 $ 1,216,585 $ 2,359,540 $ 3,594,023 $ 4,794,519 Cash Reserve Target (step)$ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,500,000$ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000$ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 Cash Reserve Target (5%/yr)$ 1,215,506 $ 1,276,282 $ 1,340,096 $ 1,407,100 $ 1,477,455 $ 1,551,328 $ 1,628,895 $ 1,710,339 $ 1,795,856$ 1,215,506 $ 1,276,282 $ 1,340,096 $ 1,407,100 $ 1,477,455 $ 1,551,328 $ 1,628,895 $ 1,710,339 $ 1,795,856 $ 1,885,649 $ 1,979,932 $ 2,078,928 $ 2,182,875 $ 2,292,018 $ 2,406,619 $ 2,526,950 $ 2,653,298$ 1,885,649 $ 1,979,932 $ 2,078,928 $ 2,182,875 $ 2,292,018 $ 2,406,619 $ 2,526,950 $ 2,653,298 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items Revenues Rate increases would be as indicated each year and based on a stable customer base and stable consumption Expenditures Personnel Costs increase at a rate of 3% per year Supplies increase at a rate of 3% perannum. Services increase at a rate of 4% per year Depreciation increases at a rate of approximately 2.5% per annum. Existing Debt Debt 2014 CIP Debt VVTP $ 636,163 $ 225,941 898,355 340,305 895,884 City of Brooklyn Center Sanitary Sewer Fund Cash Flow Analysis revised:6126/2013 Rate Increase 3.00%4.00%5.00%5.00%5.00%5.00%5.00%5.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Monthly Residential Fee 22.59 $ 23.49 $ 24.66 $ 25.90 $ 27.19 $ 28.55 $ 29.98 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $ 31.48 $ 31.48 Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Revenues Sewer Charges $ 3,487,918 $ 3,619,489 $ 3,800,463 $ 3,990,487 $ 4,190,011 $ 4,399,512 $ 4,619,487 $ 4,850,461 $ 4,850,461 $ 4,850,461 $ 4,850,461 $ 4,850,461 $ 4,850,461 $ 4,850,461 $ 4,850,461 $ 4,850,461 $ 4,850,461 Bond Proceeds $ -$$$$$ -$ -$ -$ -$ -$ -$$$$$ -$ - Misc. Operating $ 103,061 $ -$$$$ -$ -$ -$ -$ -$ -$$$$$ -$ - Misc. Non-operating $ 6,753 $ 5,000 $ 5,000 $ 4,934 $ 2,821 $ (826)$ (2,459)$ (4,707)$ (5,197)$ (4,767)$ (1,113)$ 3,286 $ 6,907 $ 6,365 $ 5,880 $ 4,621 $ 6,939 Total Revenues $ 3,597,732 $ 3,624,489 $ 3,805,463 $ 3,995,420 $ 4,192,832 $ 4,398,686 $ 4,617,028 $ 4,845,755 $ 4,845,265 $ 4,845,694 $ 4,849,349 $ 4,853,748 $ 4,857,368 $ 4,856,826 $ 4,856,341 $ 4,855,082 $ 4,857,400 Expenditures Personal Services $ 195,347 5 197,115 $ 200,349 5 208,363 $ 216,697 $ 225,365 $ 234,380 5 243,755 $ 253,505 $ 263,646 $ 274,191 $ 285,159 $ 296,565 5 308,428 $ 320,765 $ 333,596 $ 346,940 Supplies $ 29,941 $ 63,540 $ 27,465 $ 28,289 $ 29,138 $ 30,012 $ 30,912 $ 31,839 $ 32,795 $ 33,778 $ 34,792 $ 35,836 $ 36,911 $ 38,018 $ 39,159 $ 40,333 $ 41,543 Services $ 2,374,619 $ 2,501,518 $ 2,585,847 $ 2,663,422 $ 2,743,325 $ 2,825,625 $ 2,910,394 $ 2,997,705 $ 3,087,637 $ 3,180,266 $ 3,275,674 $ 3,373,944 $ 3,475,162 $ 3,579,417 $ 3,686,800 $ 3,797,403 $ 3,911,326 Depreciation $ 647,862 $ 728,770 $ 801,647 $ 825,696 $ 850,467 $ 875,981 $ 902,261 $ 929,329 $ 957,208 $ 985,925 $ 1,015,502 $ 1,045,968 $ 1,077,347 $ 1,109,667 $ 1,142,957 $ 1,177,246 $ 1,212,563 Debt Service Interest & Fees $ 20,590 $ 20,061 $ 16,615 $ 14,706 $ 13,447 $ 12,716 $ 10,806 $ 9,913 $ 8,963 $ 6,910 $ 4,957 $ 3,575 $ 1,788 $ 1,788 $ 1,788 $ 1,788 $ 1,788 Total Expenditures $ 3,268,359 $ 3,511,004 $ 3,631,923 $ 3,740,477 $ 3,853,074 $ 3,969,699 $ 4,088,752 $ 4,212,542 $ 4,340,108 $ 4,470,524 $ 4,605,116 $ 4,744,481 $ 4,887,773 $ 5,037,318 $ 5,191,468 $ 5,350,366 $ 5,514,160 less: Non-Cash Depreciation $ 647,862 $ 728,770 $ 801,647 $ 825,696 $ 850,467 $ 875,981 $ 902,261 $ 929,329 $ 957,208 $ 985,925 $ 1,015,502 $ 1,045,968 $ 1,077,347 $ 1,109,667 $ 1,142,957 $ 1,177,246 $ 1,212,563 plus: Debt Service Principal $ 33,750 $ 33,750 $ 37,500 $ 38,750 $ 40,000 $ 41,250 $ 42,500 $ 45,000 $ 45,000 $ 47,500 $ 50,000 $ 50,000 $ 52,500 $ 52,500 $ 52,500 $ 52,500 $ 52,500 plus: Transfers $ -$ -$$$$$ -$ -$ -$ -$ -$$$ ..-$$ - plus: Cash Capital Outlay $ 47,028 $ 1,330,000 $ 1,260,000 $ 1,570,000 $ 2,062,000 $ 1,672,000 $ 1,950,000 $ 1,640,000 $ 1,310,000 $ 400,000 $ 110,000 $ 200,000 $ 1,130,000 $ 998,000 $ 1,070,000 $ 50,000 $ 30,000 Total Cash Requirement $ 2,701,275 $ 4,145,984 $ 4,127,776 $ 4,523,530 $ 5,104,607 $ 4,806,968 $ 5,178,992 $ 4,968,213 $ 4,737,900 $ 3,932,100 $ 3,749,614 $ 3,948,514 $ 4,992,926 $ 4,978,151 $ 5,171,011 $ 4,275,621 $ 4,384,097 Beginning Cash Balance $ 1,169,534 $ 2,077,227 $ 1,555,732 $ 1,233,419 $ 705,309 $ (206,466)$ (614,748)$ (1,176,711)$ (1,299,170)$ (1,191,805)$ (278,210)$ 821,524 $ 1,726,758 $ 1,591,201 $ 1,469,876 $ 1,155,205 $ 1,734,667 Changes in Assets/Liabilities $ 11,236 $$$ -$$ -$ -$ -$ -$ -$ -$$$$ -$ -$ - Cash Received $ 3,597,732 $ 3,624,489 $ 3,805,463 $ 3,995,420 $ 4,192,832 $ 4,398,686 $ 4,617,028 $ 4,845,755 $ 4,845,265 $ 4,845,694 $ 4,849,349 $ 4,853,748 $ 4,857,368 $ 4,856,826 $ 4,856,341 $ 4,855,082 $ 4,857,400 Cash Spent $ 2,701,275 $ 4,145,984 $ 4,127,776 $ 4,523,530 $ (5,104,607)$ 4,806,968 $ 5,178,992 $ 4,968,213 $ 4,737,900 $ 3,932,100 $ 3,749,614 $ 3,948,514 $ 4,992,926 $ 4,978,151 $ 5,171,011 $ 4,275,621 $ 4,384,097 Ending Cash Balance $ 2,077,227 $ 1,555,732 $ 1,233,419 $ 705,309 $ (206,466)$ (614,748)$ (1,176,711)$ (1,299,170)$ (1,191,805)$ (278,210)$ 821,524 $ 1,726,758 $ 1,591,201 $ 1,469,876 $ 1,155,205 $ 1,734,667 $ 2,207,971 Cash Reserve Target $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 Cash Reserve Target (3%/yr) $ 1,038,091 $ 1,069,233 $ 1,101,310 $ 1,134,350 $ 1,168,380 $ 1,203,432 $ 1,239,535 $ 1,276,721 $ 1,315,022 $ 1,354,473 $ 1,395,107 $ 1,436,960 $ 1,480,069 $ 1,524,471 $ 1,570,205 $ 1,617,311 $ 1,665,831 Cash Reserve Target (35% of Sales)$ 1,085,847 $ 1,140,139 $ 1,197,146 $ 1,257,003 $ 1,319,853 $ 1,385,846 $ 1,455,138 $ 1,455,138 $ 1,455,138 $ 1,455,138 $ 1,455,138 $ 1,455,138 $ 1,455,138 $ 1,455,138 $ 1,455,138 $ 1,455,138 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items. Revenues Rate increases would be as indicated per year and are based on a stable customer base with stable usage. Expenditures Personnel costs increase at a rate of 4% per year Supplies increase at a rate of 3% per year. Serices increase at a rate of 3% per year Depreciation increases at a rate of 3% per year Capital outlay is from the 2014 CIP 2014 Utility Rates & Cash Flows UPDATED 10/21/2013 Rate Increase Per Residential Lot City of Brooklyn Center Storm Sewer Fund Cash Flow Analysis 0.00% 0.00% 0.00% 14.48 14.48 14.48 Actual Budget Proposed 0.00% 14.48 Projected revised 0.00% 14.48 Projected 6/26/2013 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 0.00% 14.48 Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Revenues Storm Sewer Fees 1,599,414 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 $ 1,597,370 Misc. Operating 58,507$ $$ 1,597,370 Misc. Non-operating 13,396 $ 10,000 $ 10,000 $ 13,980 $ 12,799 $ 12,361 $ 11,962 $ 8,501 $ 5,404 $ 3,736 $ 6,722 $ 9,579 $ 12,541 $ 17,560 $ 20,248 $ 22,382 Total Revenues 1,671,317 $ 1,607,370 $ 1,607,370 $ 1,611,350 $ 1,610,169 $ 1,609,731 $ 1,609,332 $ 1,605,871 $ 1,602,774 $ 1,601,106 $ 1,604,092 $ 1,606,949 $ 1,609,911 $ 4 8 1 0 4 $ 1,6 112,74 $ 1,614,930 $ 1,617,618 $ 1,619,752 Expenditures Personal Services 176,834 $ 186,205 $ 189,258 $ 198,721 $ 208,657 $ 219,090 $ 230,044 $ 241,546 $ 253,624 $ 266,305 $ 279,620 $ 293,601 $ 308,281 $ 323,695 $ 339,880 $ 356,874 $ 374,718 Supplies 5,909 $ 29,540 $ 29,915 $ 30,812 $ 31,737 $ 32,689 $ 33,670 $ 34,680 $ 35,720 $ 36,792 $ 37,895 $ 39,032 $ 40,203 $ 41,409 $ 42,652 $ 43,931 $ 45,249 Services 267,723 $ 311,609 $ 301,888 $ 310,945 $ 320,273 $ 329,881 $ 339,778 $ 349,971 $ 360,470 $ 371,284 $ 382,423 $ 393,895 $ 405,712 $ 417,884 $ 430,420 $ 443,333 $ 456,633 Depreciation 984,848 $ 1,101,744 $ 1,175,000 $ 1,210,250 $ 1,246,558 $ 1,283,954 $ 1,322,473 $ 1,362,147 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 Debt Service Interest & Fees -$ -$ -$$ -$$$$ -$ -$ -$$$$$ -$ - Total Expenditures 1,435,314 $ 1,629,098 $ 1,696,061 $ 1,750,728 $ 1,807,224 $ 1,865,614 $ 1,925,964 $ 1,988,344 $ 2,052,825 $ 2,077,392 $ 2,102,950 $ 2,129,540 $ 2,157,208 $ 2,186,000 $ 2,215,963 $ 2,247,150 $ 2,279,611 less: Non-Cash Depreciation 984,848 $ 1,101,744 $ 1,175,000 $ 1,210,250 $ 1,246,558 $ 1,283,954 $ 1,322,473 $ 1,362,147 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 $ 1,403,011 plus: Cash Transfer to GF -$ -$$$$$$ -$ -$$$$$$ -$ -$ plus: Debt Service Principal _$$$$ _$$$ _$$$$ _$$ -$ _$ _$ plus: Cash Equipment Outlay $ 13,000$$ -$$$$$ _$ _$$$ _$$ _$ _$ _ plus: Cash Capital Outlay 78,069 $ 1,148,000 $ 1,388,000 $ 1,366,000 $ 1,159,000 $ 1,128,000 $ 1,871,000 $ 1,754,000 $ 190,000 $ 140,000 $ 290,000 $ 140,000 $ 130,000 $ 240,000 $ 70,000 Total Cash Requirement 528,535 $ 1,688,354 $ 1,909,061 $ 1,906,478 $ 1,719,667 $ 1,709,660 $ 2,474,491 $ 2,380,197 $ 1 :371 09:08 002 $ 2,019,814 :8 185 40 :3008 01 $ 889,938 $ 866,529 $ 1,044,197 $ 922,988 $ 942,952 $ 1,084,138 $ 946,600 Beginning Cash Balance $ 2,824,851 $ 3,877,639 $ 3,796,655 $ 3,494,964 $ 3,199,836 $ 3,090,338 $ 2,990,410 $ 2,125,250 $ 1,350,924 $ 933,884 $ 1,680,608 $ 2,394,762 $ 3,135,183 $ 3,700,896 $ 4,390,082 $ 5,062,060 $ 5,595,540 Changes in Assets/Liabilities $ (89,994)$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ _ Cash Received $ 1,671,317 $ 1,607,370 $ 1,607,370 $ 1,611,350 $ 1,610,169 $ 1,609,731 $ 1,609,332 $ 1,605,871 $ 1,602,774 $ 1,601,106 $ 1,604,092 $ 1,606,949 $ 1,609,911 $ 1,612,174 $ 1,614,930 $ 1,617,618 $ 1,619,752 Cash Spent $ (528,535)$ (1,688,354)$ (1,909,061)$ (1,906,478)$ (1,719,667)$ (1,709,660)$ (2,474,491)$ (2,380,197)$ (2,019,814)$ (854,381)$ (889,938)$ (866,529)$ (1,044,197)$ (922,988)$ (942,952)$(1,084,138)$ (946,600) Ending Cash Balance $ 3,877,639 $ 3,796,655 $ 3,494,964 $ 3,199,836 $ 3,090,338 $ 2,990,410 $ 2,125,250 $ 1,350,924 $ 933,884 $ 1,680,608 $ 2,394,762 $ 3,135,183 $ 3,700,896 $ 4,390,082 $ 5,062,060 $ 5,595,540 $ 6,268,693 Cash Reserve Target $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation with no provisions made for changes in balance sheet items that may affect cash balances. Revenues Rate increase reflect additions to the gross income based on ordinance charges Expenditures Personnel Costs increase at a rate of 5% per year. Supplies and Services increase at a rate of 3% per year. Capital outlay is from the 2014 CIP 2014 Utility Rates & Cash Flows UPDATED 10/21/2013 City of Brooklyn Center Street Light Utility Fund Rate Analysis revised:6/26/2013 Rate Increase 25.26%20.18%10.00%3.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Quarterly Rate per Dwelling U 4.95 5.95 6.55 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Revenues Street Light Fee $ 346,531 $ 402,369 $ 442,369 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 $ 455,640 Misc. Operating $ 8,178 $ -$ -$ -$ -$$$$$ -$$$ -$$$$ - Misc. Non-operating $ 380 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 Total Revenues $ 355,089 $ 402,869 $ 442,869 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 Expenditures Personal Services $ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Supplies $ 25 $ 2,780 $ 2,500 $ 2,575 $ 2,652 $ 2,732 $ 2,814 $ 2,898 $ 2,985 $ 3,075 $ 3,167 $ 3,262 $ 3,360 $ 3,461 $ 3,564 $ 3,671 $ 3,781 Services $ 194,797 $ 226,733 $ 236,893 $ 242,815 $ 248,886 $ 255,108 $ 261,486 $ 268,023 $ 274,723 $ 281,591 $ 288,631 $ 295,847 $ 303,243 $ 310,824 $ 318,595 $ 326,560 $ 334,724 Depreciation $ 28,449 $ 33,600 $ 36,900 $ 37,638 $ 38,391 $ 39,159 $ 39,942 $ 40,741 $ 41,555 $ 42,387 $ 43,234 $ 44,099 $ 44,981 $ 45,881 $ 46,798 $ 47,734 $ 48,689 Debt Service or Transfer $ -$$ -$ -$$$$ -$ -$ -$$$$$ -$$ - Total Expenditures $ 223,271 $ 263,113 $ 276,293 $ 283,028 $ 289,929 $ 296,998 $ 304,241 $ 311,661 $ 319,264 $ 327,053 $ 335,032 $ 343,208 $ 351,584 $ 360,165 $ 368,957 $ 377,965 $ 387,194 Capital Outlay/Transfers $ 285,000 $ 40,000 $ 215,000 $ 260,000 $ 321,000 $ 150,000 $ 90,000 $ 170,000 $ 15,000 $ 60,000 $ 170,000 $ 150,000 $ 150,000 $ 330,000 $ 140,000 $ - Total Cash Requirement $ 223,271 $ 548,113 $ 316,293 $ 498,028 $ 549,929 $ 617,998 $ 454,241 $ 401,661 $ 489,264 $ 342,053 $ 395,032 $ 513,208 $ 501,584 $ 510,165 $ 698,957 $ 517,965 $ 387,194 Beginning Cash Balance $ 10,808 $ 92,810 $ (18,834)$ 144,642 $ 140,392 $ 84,994 $ (37,706)$ 4,135 $ 99,354 $ 107,786 $ 264,260 $ 368,602 $ 355,633 $ 355,170 $ 347,026 $ 151,007 $ 136,916 Changes in Assets/Liabilities $ (78,265)$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Revenues $ 355,089 $ 402,869 $ 442,869 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 $ 456,140 Expenditures $ (223,271)$ (548,113)$ (316,293)$ (498,028)$ (549,929)$ (617,998)$ (454,241)$ (401,661)$ (489,264)$ (342,053)$ (395,032)$ (513,208)$ (501,584)$ (510,165)$ (698,957)$ (517,965)$ (387,194) Depreciation Add-Back $ 28,449 $ 33,600 $ 36,900 $ 37,638 $ 38,391 $ 39,159 $ 39,942 $ 40,741 $ 41,555 $ 42,387 $ 43,234 $ 44,099 $ 44,981 $ 45,881 $ 46,798 $ 47,734 $ 48,689 Ending Cash Balance $ 92,810 $ (18,834)$ 144,642 $ 140,392 $ 84,994 $ (37,706)$ 4,135 $ 99,354 $ 107,786 $ 264,260 $ 368,602 $ 355,633 $ 355,170 $ 347,026 $ 151,007 $ 136,916 $ 254,551 Cash Reserve Target $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation with no provisions made for changes in balance sheet items that may occur from year to year. Revenues Rate increases are based on customer count of 8,415 residential customers and 538 others. Expenditures Supplies and Services increase at a total rate of 3% per annum. Depreciation increases at a rate of approximately 2% per annum. Capital outlay is from the 2014 CIP Budget Proposed Projected 2013 2014 2015 302,394 $ 311,466 $ 320,810 5,000 $ 5,000 $ 5,000 -$$ 307,394 $ 316,466 $ 325,810 $ $ 150 $ 290,060 $ $ $ 290,210 $ $ 290,210 - 155 298,762 298,916 298,916 159 307,725 307,884 307,884 $ $ $ $ $ (6,896) $ - $ 307,394 $ (290,210) $ $ 10,288 $ 10,288 $ $ 316,466 $ (298,916) $ - $ 27,838 $ 27,838 $ - $ 325,810 $ (307,884) $ - $ 45,764 $ 40,000 $ 40,000 $ 40,000 Rate Increase Quarterly Residential Rate City of Brooklyn Center Recycling Fund Rate Analysis 2.00%0.00%3.00%3.00%3.00%3.00%3.00%3.00% 8.43 8.43 8.68 8.94 9.21 9.49 9.77 10.07 Actual 2011 Actual 2012 $ 278,893 $ 11,126 $ 20 $ 280,430 $ 10,306 $ 15 $ 290,039 $ 290,751 $ _$ $ -$ - $ 284,441 $ 267,630 $$ $$ $ 284,441 $ 267,630 $$ $ 284,441 $ 267,630 $ (9,938)$ (7,762) $ (3,422)$ (22,255) $ 290,039 $ 290,751 $ (284,441)$ (267,630) $ -$ - $ (7,762)$ (6,896) $ 40,000 $ 40,000 Projected 2016 Projected 2017 Projected 2017 $ 330,434 $ 5,000 $ - $ 340,347 $ 5,000 $ - $ 350,558 $ 5,000 $ - $ 335,434 $ 345,347 $ 355,558 $ _$ -$ $ 164 $ 169 $ 174 $ 316,956 $ 326,465 $ 336,259 $$$ $$$ $ 317,120 $ 326,634 $ 336,433 $$ _$ $ 317,120 $ 326,634 $ 336,433 $ 45,764 $ 64,077 $ 82,791 $ -$ -$ $ 335,434 $ 345,347 $ 355,558 $ (317,120)$ (326,634)$ (336,433) $ -$ -$ $ 64,077 $ 82,791 $ 101,915 $ 40,000 $ 40,000 $ 40,000 Revenues Recycling Fee Misc. Operating Misc. Non-operating Total Revenues Expenditures Personal Services Supplies Services Depreciation Debt Service Total Expenditures Capital Outlay/Transfers Total Cash Requirement Beginning Cash Balance Changes in Assets/Liabilities Revenues Expenditures Depreciation Add-Back Ending Cash Balance Cash Reserve Target Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Expenditures Supplies and Services increase at a rate of about 3% per annum. Cash Reserve Target The cash reserve target is established by estimating 2 months' service charges from Hennepin Recycling Group Handed out at meeting. Positions FTEs 2013 2014 •Liquor Operations Manager 1 1 o Liquor Store Manager 2 2 •Liquor Store Assistant Manager 1 1 •Liquor Store Office Assistant 1 1 •Liquor Store Category Lead (PT Staff)3 3 •Store Clerk/Stocker (PT staff)20 20 TOTAL 27 28 2015 1 2 1 1 3 20 28 2014 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, cigarettes and sundry items such as glassware, ice and non-intoxicating beverages. Store # 1 is the larger of the two stores in located in the Brookdale Corners shopping center at 5625 Xerxes Avenue. Store# 2 is located in the Boulevard Marketplace shopping center at 6930 Brooklyn Boulevard. The stores operate Monday through Saturday. Special events are provided through a Wine Club, a Beer Club and Platinum Club (joint membership in both Wine and Beer) of BC Liquors. These clubs meet to provide information about the products, sample tastings and special sales opportunities for products featured at the events. Additionally, BC Liquors assists Surly Brewing with its annual Darkness Day celebration. BC Liquor leases space on the Surly Brewing premises and effectively opens a store there to facilitate off-sale distribution of the very popular Surly Darkness beer. Staffing Levels 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. The Division also sponsors special events each year such as tasting club events for wine and beer enthusiasts and off-sale services at local brewery events. Annual Goal and Strategies: 1. Promote and sell alcoholic beverages in a controlled environment which minimizes the risk of unlawful procurement of alcoholic beverages by minors or obviously intoxicated patrons. a.Random compliance checks provided by law enforcement b.Regular Training and support of clerks 2. Promote knowledge of alcoholic beverages through Tasting Club events. a. Events scheduled twice per year for solely wine and twice for solely beer with one additional event combining both beer and wine presentations and tasting 3. Provide profitable operations such that dollars may be transferred from the Liquor Fund to the Capital Improvements Fund and other funds as approved by the City Council to lower the need for property tax revenues while still accomplishing the repair and maintenance need of the City. a. Reserve a specified transfer in the budget process Annual Goal Performance Measures: 1. Results/Effectiveness Measures •Zero violations of Alcohol Compliance checks performed by law enforcement agencies 2. Efficiency Measure •Utility cost per square foot 3. Productivity Measure •Sales Volume per advertising dollar •Gross Margin per thousand dollars of sales •Net Profit per product category. Capital Outlay and Other Initiatives with Significant Budget Impact (optional) •Replacement the aging camera system at Store #2. Expected Cost of $27,000. CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 60900- BROOKLYN CENTER LIQUOR 49611 - BROOKLYN CENTER LIQUOR 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -4,891 -3,562 -1,855 -3,000 -3,000 -3,000 4605 UNREALIZED INVESTMENT GAIN/LOSS -1,387 739 0 4606 OTHER REVENUE -2,000 -2,500 -2,000 -1,500 -1,500 -1,500 4600 MISCELLANEOUS REVENUE -8,278 -5,323 -3,855 -4,500 -4,500 -4,500 4599 MISCELLANEOUS REVENUE -8,278 -5,323 -3,855 -4,500 -4,500 -4,500 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES -1,577,629 -1,705,023 -1,291,333 -1,673,706 -1,723,917 -1,775,635 4762 WINE SALES -550,371 -576,899 -403,310 -606,783 -637,121 -637,121 4763 BEER SALES -1,783,997 -1,889,305 -1,489,903 -1,856,069 -1,893,190 -1,968,917 4764 SALES-NON TAXABLE -47,328 -43,190 -31,047 -44,322 -44,322 -42,992 4765 SALES-TAXABLE -59,525 -60,679 -43,066 -59,525 -59,525 -57,739 4760 LIQUOR STORE OPERATIONS -4,018,850 -4,275,097 -3,258,659 -4,240,405 -4,358,075 -4,482,404 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS -2,000 -2,496 -2,798 0 -2,500 4922 PROJECT ADMINISTRATION -2,875 -3,921 -2,835 -4,500 -4,500 -4,500 4900 OTHER FINANCING SOURCES -4,875 -6,417 -5,633 -4,500 -4,500 -7,000 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 991,395 1,090,687 728,512 1,154,857 1,189,502 1,225,188 5582 COST OF SALES-WINE 343,081 371,520 211,102 403,510 423,685 423,685 5583 COST OF SALES-BEER 1,369,643 1,481,804 1,014,786 1,429,173 1,457,756 1,516,066 5584 OTHER COSTS OF SALE-NON TAX 25,032 23,172 13,763 28,366 28,366 27,515 5582 OTHER COST OF SALES-TAX 38,392 39,133 24,801 38,096 38,096 36,953 5587 INVENTORY VARIANCES 1,771 14,143 2,118 12,000 12,000 12,000 5589 DELIVERY CHARGES 19,764 19,896 14,014 18,000 18,000 20,000 5580 COST OF GOODS SOLD 2,789,076 3,040,355 2,009,095 3,084,002 3,167,405 3,261,407 5550 DIRECT COST OF SALES 2,789,076 3,040,355 2,009,095 3,084,002 3,167,405 3,261,407 4001 REVENUES -1,242,927 -1,246,482 -1,259,051 -1,165,403 -1,199,670 -1,232,497 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 171,135 180,105 147,976 211,712 215,946 220,265 6103 WAGES-PART TIME EMPLOYEES 153,101 161,457 111,703 168,000 178,000 183,000 6104 OVERTIME-PART TIME EMPLOYEES 1,834 2,278 2,338 2,500 2,500 2,500 6100 WAGES AND SALARIES 326,070 343,840 262,016 382,212 396,446 405,765 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 1,362 2,229 0 6110 OTHER PAYMENTS-NON INSURANCE 1,362 2,229 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 22,874 24,201 18,344 27,529 28,561 29,237 6125 FICA 20,601 21,869 16,501 23,542 24,424 25,002 6126 MEDICARE CONTRIBUTIONS 4,819 5,114 3,859 5,506 5,712 5,847 6120 RETIREMENT CONTRIBUTIONS 48,294 51,184 38,704 56,577 58,697 60,086 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 28,660 26,337 24,362 33,804 36,170 38,702 6130 INSURANCE BENEFITS 28,660 26,337 24,362 33,804 36,170 38,702 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPOLOYMENT COMPENSATION 701 96 91 6140 UNEMPLOYMENT COMPENSATION 701 96 91 6150 WORKERS COMPENSATION 6151 WORKERS' COMPENSATION 7,100 7,795 7,035 8,126 10,557 10,807 6150 WORKER'S COMPENSATION 7,100 7,795 7,035 8,126 10,557 10,807 6099 PERSONAL SERVICES 412,187 431,482 332,208 480,719 501,870 515,360 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 570 282 685 1,000 1,000 1,000 6202 COPYING SUPPLIES 0 0 0 0 6200 OFFICE SUPPLIES 570 282 685 1,000 1,000 1,000 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 1,086 1,110 1,014 1,000 1,000 1,500 6219 GENERAL OPERATING SUPPLIES 10,606 11,230 7,329 11,000 11,000 11,000 6210 OPERATING SUPPLIES 11,692 12,340 8,343 12,000 12,000 12,500 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 0 0 0 2,000 2,000 2,000 6220 REPAIR & MAINT SUPPLIES 0 0 0 2,000 2,000 2,000 6230 REPAIR & MAINT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 0 0 0 6230 REPAIR & MAINT SUPPLIES-OTHER 0 0 0 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 191 6242 MINOR EQUIPMENT 364 1,696 394 10,088 6,500 2,000 6243 MINOR COMPUTER EQUIPMENT 1,016 20,246 27,534 31,750 20,725 3,672 6240 SMALL TOOLS & MINOR EQUIPMENT 1,380 21,942 28,119 41,838 27,225 5,672 6199 SUPPLIES 13,641 34,564 37,147 56,838 42,225 21,172 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 4,906 3,985 3,934 5,000 5,000 5,000 6303 LEGAL SERVICES 0 197 0 0 6307 PROFESSIONAL SERVICES 2,791 2,112 2,571 7,000 7,000 7,000 6300 PROFESSIONAL SERVICES 7,697 6,294 6,505 12,000 12,000 12,000 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 2,049 2,171 1,414 2,220 2,500 2,550 6320 COMMUNICATIONS 2,049 2,171 1,414 2,220 2,500 2,550 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 675 704 389 1,000 1,000 1,000 6330 TRANSPORTATION 675 704 389 1,000 1,000 1,000 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 0 252 207 500 500 500 6349 OTHER ADVERTISING 8,309 12,243 3,844 10,000 10,000 15,000 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6340 ADVERTISING 8,309 12,495 4,051 10,500 10,500 15,500 6350 PRINTING AND DUPLICATING 6351 PRINTING 0 0 402 500 500 500 6350 PRINTING AND DUPLICATING 0 0 402 500 500 500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 387 312 1,429 735 786 6362 PROPERTY INSURANCE 309 642 979 1,287 1,377 6364 DRAM SHOP INSURANCE 4,228 4,037 3,893 6,395 6,843 6366 MACHINERY BREAKDOWN INSURANCE 78 174 266 350 370 6360 INSURANCE 5,002 5,165 6,567 8,767 9,376 6380 UTILITY SERVICES 6381 ELECTRIC 16,918 15,781 19,556 17,000 25,000 26,000 6382 GAS 3,370 2,240 1,974 3,500 3,500 3,500 6380 UTILITY SERVICES 20,288 18,022 21,530 20,500 28,500 29,500 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 5,231 938 1,730 5,000 5,000 5,000 6403 BLDGS/FACILITIES MAINT SERVICE 767 1,559 182 3,000 3,000 3,000 6406 MULTI-FUNCTION MTNCE 186 234 215 500 500 515 6409 OTHER REPAIR & MAINT SERVICES 0 0 0 1,000 1,000 6400 REPAIR & MAINT SERVICES 6,184 2,731 2,126 9,500 9,500 8,515 6410 RENTALS 6412 BLDGS/FACILITIES 198,405 203,604 154,948 195,780 195,780 195,780 6410 RENTALS 198,405 203,604 154,948 195,780 195,780 195,780 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 294 0 1,539 0 6422 SOFTWARE MAINT 1,006 5,311 1,930 6,300 6,300 6,300 6423 LOGIS CHARGES 9,350 11,613 8,902 12,982 14,417 14,429 6428 PROTECTION SERVICES 534 547 373 500 500 6420 IS SERVICES/LICENSES/FEES 11,183 17,471 12,744 19,282 21,217 21,229 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 8,716 8,822 5,552 8,500 8,500 8,500 6432 CONFERENCES AND SCHOOLS 939 1,792 2,205 2,200 2,200 2,500 6433 MEETING EXPENSES 15 0 6434 DUES & SUBSCRIPTIONS 2,287 2,304 1,460 2,500 2,500 2,500 6435 CREDIT CARD FEES 57,826 63,092 43,355 62,000 64,000 65,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 0 0 0 0 6438 CASH SHORT (OVER)863 829 403 1,000 1,000 1,000 6430 MISCELLANEOUS 70,631 76,854 52,975 76,200 78,200 79,500 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 20 0 615 200 200 200 6449 OTHER CONTRACTUAL SERVICES 2,304 2,477 1,964 2,500 2,500 2,500 6440 OTHER EXPENSES 2,324 2,477 2,579 2,700 2,700 2,700 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 90 139 122 103 108 229 6462 FIXED CHARGES 536 529 646 560 577 822 6463 REPAIR & MAINT CHARGES 0 45 240 525 552 198 6465 REPLACEMENT CHARGES 1,114 930 1,138 1,050 1,199 1,736 6460 CENTRAL GARAGE CHARGES 1,740 1,644 2,146 2,238 2,436 2,985 6470 TRANSFERS AND OTHER USES CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6471 ADMINISTRATIVE SERVICE TRANSFER 49,557 41,849 30,728 40,970 41,790 6476 CAPITAL PROJECT FUND TRANSFER 135,000 200,000 0 200,000 200,000 200,000 6482 MISC TRANSFER OUT 12,488 0 0 6470 TRANSFERS AND OTHER USES 197,045 241,849 30,728 240,970 241,790 200,000 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 6,417 6,435 15,818 8,550 9,200 6490 OTHER MISC COSTS/EXPENSES 6,417 6,435 15,818 8,550 9,200 6299 OTHER CHARGES & SERVICES 537,951 597,915 314,922 610,707 625,199 571,759 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 0 0 0 6540 EQUIPMENT & MACHINERY 10,279 0 29,454 38,000 6501 CAPITAL OUTLAY 10,279 0 29,454 38,000 6500 CAPITAL OUTLAY 10,279 0 29,454 38,000 6001 EXPENDITURES/EXPENSES 974,059 1,063,961 713,730 1,186,264 1,169,294 1,108,291 4000 REVENUES AND EXPENSES -268,869 -182,521 -545,321 20,861 -30,376 -124,206 49611 - BROOKLYN CENTER LIQUOR -268,869 -182,521 -545,321 20,861 -30,376 -124,206 49612 - 69TH AVENUE LIQUOR STORE 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS -4,891 -3,562 -1,855 -3,000 -3,000 -3,000 4605 UNREALIZED INVESTMENT GAIN/LOSS -1,387 739 0 4600 MISCELLANEOUS REVENUE -6,278 -2,823 -1,855 -3,000 -3,000 -3,000 4599 MISCELLANEOUS REVENUE -6,278 -2,823 -1,855 -3,000 -3,000 -3,000 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES -569,294 -526,196 -388,221 -546,748 -535,813 -546,529 4762 WINE SALES -226,961 -219,356 -148,168 -240,782 -248,006 -238,085 4763 BEER SALES -924,288 -897,584 -522,237 -707,079 -636,371 -623,643 4764 SALES-NON TAXABLE -21,456 -20,004 -13,217 -20,606 -20,194 -19,184 4765 SALES-TAXABLE -28,496 -25,672 -18,289 -27,366 -26,819 -25,478 4760 LIQUOR STORE OPERATIONS -1,770,496 -1,688,811 -1,090,132 -1,542,581 -1,467,203 -1,452,919 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 0 -16 -38 0 4900 OTHER FINANCING SOURCES 0 -16 -38 0 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 472,904 438,589 303,313 377,256 369,710 377,105 5582 COST OF SALES-WINE 172,943 163,634 102,755 160,084 164,923 158,326 5583 COST OF SALES-BEER 695,319 630,290 331,848 544,450 490,005 480,205 5584 OTHER COSTS OF SALE-NON TAX 15,420 16,191 9,612 13,187 12,924 12,277 5582 OTHER COST OF SALES-TAX 21,152 17,209 11,454 17,514 17,164 16,305 5587 INVENTORY VARIANCES 3,006 4,853 4,454 5,000 5,000 5,000 5589 DELIVERY CHARGES 6,085 5,593 3,489 5,800 5,800 6,000 5580 COST OF GOODS SOLD 1,386,829 1,276,360 766,926 1,123,291 1,065,526 1,055,218 CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 5550 DIRECT COST OF SALES 1286,829 1276260 766226 1,123291 1265,526 1,055218 4001 REVENUES -389,944 -415,291 -325,099 -422,290 -404,677 -400,701 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 72,319 68,035 61,373 84,119 85,801 87,517 6103 WAGES-PART TIME EMPLOYEES 78,673 77,327 46,173 72,000 72,000 72,000 6104 OVERTIME-PART TIME EMPLOYEES 1,417 1,422 1,257 1,500 1,500 1,500 6100 WAGES AND SALARIES 152,409 146,784 108,803 157,619 159,301 161,017 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 954 1,418 0 6110 OTHER PAYMENTS-NON INSURANCE 954 1,418 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 10,946 10,469 7,707 11,374 11,440 11,565 6125 FICA 9,837 9,490 6,998 9,728 9,784 9,890 6126 MEDICARE CONTRIBUTIONS 2,300 2,220 1,637 2,274 2,288 2,313 6120 RETIREMENT CONTRIBUTIONS 23,083 22,179 16,342 23,376 23,512 23,768 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 5,447 4,629 3,727 22,536 24,114 25,801 6130 INSURANCE BENEFITS 5,447 4,629 3,727 22,536 24,114 25,801 6140 UNEMPLOYMENT COMPENSATION 6150 WORKERS' COMPENSATION 6151 WORKERS' COMPENSATION 3,424 3,532 2,931 1,792 4,229 4,275 6150 WORKER'S COMPENSATION 3,424 3,532 2,931 1,792 4,229 4,275 6099 PERSONAL SERVICES 185,317 178,542 131,804 205,323 211,156 214,861 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 240 90 123 400 400 300 6202 COPYING SUPPLIES 0 0 0 0 6200 OFFICE SUPPLIES 240 90 123 400 400 300 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 340 263 435 500 500 600 6219 GENERAL OPERATING SUPPLIES 7,972 3,433 2,271 5,000 5,000 4,000 6210 OPERATING SUPPLIES 8,312 3,696 2,706 5,500 5,500 4,600 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 0 0 0 500 500 500 6220 REPAIR & MAINT SUPPLIES 0 0 0 500 500 500 6230 REPAIR & MAINT SUPPLIES-OTHER 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 0 54 0 500 5,500 500 6243 MINOR COMPUTER EQUIPMENT 391 3,415 0 30,875 33,725 18,366 6240 SMALL TOOLS & MINOR EQUIPMENT 391 3,469 0 31,375 39,225 18,866 6199 SUPPLIES 8,942 7,256 2,829 37,775 45,625 24,266 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 1,713 1,084 1,213 1,200 1,200 1,200 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6300 PROFESSIONAL SERVICES 1,713 1,084 1,213 1,200 1,200 1,200 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 1,457 1,462 975 1,500 1,500 1,530 6329 OTHER COMMUNICATION SERVICES 859 985 607 900 0 6320 COMMUNICATIONS 2,316 2,447 1,582 2,400 1,500 1,530 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 344 189 130 300 300 300 6330 TRANSPORTATION 344 189 130 300 300 300 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 142 0 0 200 200 0 6349 OTHER ADVERTISING 4,006 4,404 1,648 6,000 6,000 7,000 6340 ADVERTISING 4,148 4,404 1,648 6,200 6,200 7,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 0 0 172 0 200 6350 PRINTING AND DUPLICATING 0 0 172 0 200 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 590 608 1,429 735 786 6,453 6362 PROPERTY INSURANCE 1,124 886 552 1,110 1,188 2,482 6364 DRAM SHOP INSURANCE 1,766 1,402 1,340 2,200 2,375 6,350 6366 MACHINERY BREAKDOWN INSURANCE 290 239 149 300 317 431 6360 INSURANCE 3,771 3,135 3,471 4,345 4,666 15,716 6380 UTILITY SERVICES 6381 ELECTRIC 17,745 17,399 14,682 18,000 19,000 19,000 6382 GAS 2,418 2,133 1,871 3,000 3,000 3,000 6383 WATER 30,899 0 7,200 7,200 7,200 6380 UTILITY SERVICES 20,162 50,430 16,553 28,200 29,200 29,200 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 124 996 2,762 2,000 2,000 2,500 6403 BLDGS/FACILITIES MAINT SERVICE 366 152 1,812 1,000 1,000 2,000 6406 MULTI-FUNCTION MTNCE 40 84 125 175 180 6400 REPAIR & MAINT SERVICES 490 1,188 4,658 3,125 3,175 4,680 6410 RENTALS 6412 BLDGS/FACILITIES 94,860 93,360 70,020 93,860 93,860 93,860 6410 RENTALS 94,860 93,360 70,020 93,860 93,860 93,860 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 0 0 0 0 6422 SOFTWARE MAINT 393 2,296 685 2,800 2,800 2,800 6423 LOGIS CHARGES 4,130 5,227 3,848 5,564 6,179 6,184 6428 PROTECTION SERVICES 435 475 340 6420 IS SERVICES/LICENSES/FEES 4,958 7,997 4,873 8,364 8,979 8,984 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 0 0 0 0 6432 CONFERENCES AND SCHOOLS 371 465 379 600 600 600 6434 DUES & SUBSCRIPTIONS 1,003 1,016 750 1,000 1,000 1,000 6435 CREDIT CARD FEES 22,760 24,253 14,288 25,000 26,000 27,000 6438 CASH SHORT (OVER)2,748 1,001 383 1,000 1,000 1,000 6430 MISCELLANEOUS 26,881 26,735 15,799 27,600 28,600 29,600 6440 OTHER EXPENSES CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6441 LICENSES, TAXES & FEES 20 20 223 1,000 1,000 500 6449 OTHER CONTRACTUAL SERVICES 2,658 3,000 2,331 2,600 2,600 2,600 6440 OTHER EXPENSES 2,678 3,020 2,554 3,600 3,600 3,100 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 90 139 122 103 108 229 6462 FIXED CHARGES 536 529 248 560 577 822 6463 REPAIR & MAINT CHARGES 0 45 240 525 552 198 6465 REPLACEMENT CHARGES 1,114 930 438 1,050 1,199 1,736 6460 CENTRAL GARAGE CHARGES 1,740 1,644 1,048 2,238 2,436 2,985 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 24,741 20,893 15,341 20,454 21,065 6470 TRANSFERS AND OTHER USES 24,741 20,893 15,341 20,454 21,065 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 4,864 4,877 3,648 4,875 4,875 6490 OTHER MISC COSTS/EXPENSES 4,864 4,877 3,648 4,875 4,875 6299 OTHER CHARGES & SERVICES 193,666 221,403 142,709 206,761 209,656 198,355 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6001 EXPENDITURES/EXPENSES 387,925 407,201 277,341 449,859 466,437 437,482 4000 REVENUES AND EXPENSES -2,020 -8,089 -47,758 27,569 61,760 36,781 49612- 69TH AVENUE LIQUOR STORE -2,020 -8,089 -47,758 27,569 61,760 36,781 Total 60900 - BROOKLYN CENTER LIQUOR -270,888 -190,610 -593,079 48,430 31,384 -87,424 CITY OF BROOKLYN CENTER Budget Report Object !Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 61300 - CENTERBROOK GOLF COURSE 49721 - CENTERBROOK GOLF COURSE 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4604 CHECK PROCESSING FEES -30 0 0 4612 DONATIONS & CONTRIBUTIONS -200 -200 -375 -500 -500 4600 MISCELLANEOUS REVENUE -230 -200 -375 0 -500 -500 4599 MISCELLANEOUS REVENUE -230 -200 -375 0 -500 -500 4770 CENTERBROOK GOLF COURSE 4771 GOLF LESSONS -1,464 -196 -172 -2,250 -3500 -3,500 4773 GREEN FEES -108,813 -120,435 -85,148 -128,000 -116,000 -120,000 4778 PASSBOOK -18,960 -18,897 -8,832 -23,000 -17,500 -17,500 4782 RENTALS -10,432 -17,044 -12,397 -16,000 -16,500 -16,500 4785 LEAGUE -9,729 -10,756 -27,097 -11,500 -28,500 -30,000 4786 BEER & WINE COOLER REVENUE -24,328 -24,261 -11,116 -27,000 -25,000 -28,000 4787 FOOD & BEVERAGE REVENUES -6,051 -8,676 -8,666 -9,000 -9,250 -10,000 4788 TAXABLE MERCHANDISE -822 -618 -1,220 -1,000 -1,500 -2,000 4789 NON TAXABLE MERCHANDISE -9,186 -5,513 -3,380 -8,000 -6,500 -6,500 4790 MISCELLANEOUS -25 -25 -1,632 -100 -1,750 -2,000 4791 BOTTLED WATER SALES -1,186 -1,406 -1,021 -1500 -1,500 -1,500 4770 CENTERBROOK GOLF COURSE -190,995 -207,827 -160,681 -227,350 -227,500 -237,500 4900 OTHER FINANCING SOURCES 4915 TRANSFERS IN -200,000 0 0 -20,000 -20,000 4921 REFUNDS & REIMBURSEMENTS 0 0 0 4900 OTHER FINANCING SOURCES 0 -200,000 0 0 -20,000 -20,000 4001 REVENUES -191,225 -408,027 -161,056 -227,350 -248,000 -258,000 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES-FT EMPLOYEES 49,093 47,910 43,081 60,253 61,458 62,687 6102 OVERTIME-FT EMPLOYEES 355 0 6103 WAGES-PART TIME EMPLOYEES 54,770 41,428 27,695 42,500 38,000 38,500 6104 OVERTIME-PART TIME EMPLOYEES 1,308 991 864 1,000 1,000 1,000 6100 WAGES AND SALARIES 105,172 90,684 71540 103,753 100,458 102,187 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE 1,187 172 0 6110 OTHER PAYMENTS-NON INSURANCE 1,187 172 0 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 6,317 3,962 3,530 4,368 4,456 4,545 6125 FICA 6,111 5,789 4,624 3,736 6,166 6,286 6126 MEDICARE CONTRIBUTIONS 1,429 1,354 1,081 874 1,442 1,467 6120 RETIREMENT CONTRIBUTIONS 13,858 11,105 9,235 8,978 12,064 12,298 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 10,612 4,823 7,935 10,788 11,543 12,351 6130 INSURANCE BENEFITS 10,612 4,823 7,935 10,788 11,543 12,351 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPOLOYMENT COMPENSATION 0 588 394 0 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6140 UNEMPLOYMENT COMPENSATION 0 588 394 0 6150 WORKERS COMPENSATION 6151 WORKERS' COMPENSATION 2,107 1,883 1,669 1,229 2,327 2,368 6150 WORKERS COMPENSATION 2,107 1,883 1,669 1,229 2,327 2,368 6099 PERSONAL SERVICES 132,935 109,254 90,873 124,748 126,392 129,204 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPIES 270 300 124 400 300 300 6200 OFFICE SUPPLIES 270 300 124 400 300 300 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 148 60 67 100 100 100 6212 MOTOR FUELS 1,543 3,255 3,194 2,500 3,000 3,000 6213 LUBRICANTS & ADDITIVES 2 19 62 200 150 150 6214 CLOTHING & PERSONAL EQUIPMENT 932 64 800 900 900 6215 SHOP MATERIALS 0 10 98 250 250 250 6216 CHEMICALS/CHEMICAL PRODUCTS 4,347 6,236 5,312 9,000 7,500 7,500 6217 SAFETY SUPPLIES 28 46 82 100 100 100 6219 GENERAL OPERATING SUPPLIES 2,180 925 1,282 1,500 1,600 1,700 6210 OPERATING SUPPLIES 8,249 11,484 10,161 14,450 13,600 13,700 6220 REPAIR & MAINT SUPPLIES 6221 MOTOR VEHICLES 638 1,121 0 1,000 1,000 1,000 6223 BUILDINGS & FACILITIES 2,363 1,302 1,108 1,750 1,500 1,500 6225 PARK & LANDSCAPE MATERIALS 2,052 3,415 901 3,000 3,250 3,300 6227 PAINT SUPPLIES 83 57 0 250 250 250 6220 REPAIR & MAINT SUPPLIES 5,136 5,894 2,009 6,000 6,000 6,050 6230 REPAIR & MAINT SUPPLIES-OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 71 352 63 250 300 300 6230 REPAIR & MAINT SUPPLIES-OTHER 71 352 63 250 300 300 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 190 709 174 1,000 1,100 1,200 6242 MINOR EQUIPMENT 1,489 1,162 493 0 6243 MINOR COMPUTER EQUIPMENT 0 0 2,667 2,725 6240 SMALL TOOLS & MINOR EQUIPMENT 1,679 1,871 3,334 3,725 1,100 1,200 6199 SUPPLIES 15,406 19,901 15,691 24,825 21,300 21,550 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 575 301 181 500 500 500 6300 PROFESSIONAL SERVICES 575 301 181 500 500 500 6320 COMMUNICATIONS 6321 TELEPHONES/PAGES 1,457 1,462 1,028 1,500 1,500 1,530 6329 OTHER COMMUNICATION SERVICES 787 2,229 1,919 2,600 2,700 6320 COMMUNICATIONS 2,245 3,691 2,947 4,100 4,200 1,530 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 818 116 0 500 300 300 6330 TRANSPORTATION 818 116 0 500 300 300 6340 ADVERTISING 6349 OTHER ADVERTISING 614 791 686 4,500 4,500 4,750 CITY OF BROOKLYN CENTER Budget Report Object / Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6340 ADVERTISING 614 791 686 4,500 4,500 4,750 6350 PRINTING AND DUPLICATING 6351 PRINTING 0 382 0 500 500 500 6350 PRINTING AND DUPLICATING 0 382 0 500 500 500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 3,236 2,757 1,697 3,850 4,120 1,254 6362 PROPERTY INSURANCE 1,526 1,194 1,598 1,650 1,765 1,888 6364 DRAM SHOP INSURANCE 878 822 1,610 1,230 1,320 1,412 6366 MACHINERY BREAKDOWN INSURANCE 256 185 222 250 270 289 6360 INSURANCE 5,897 4,958 5,127 6,980 7,475 4,843 6380 UTILITY SERVICES 6381 ELECTRIC 7,880 7,614 7,292 7,500 7,900 8,000 6382 GAS 907 575 642 1,000 900 950 6383 WATER 9,561 11,981 3,128 9,000 500 500 6384 REFUSE DISPOSAL 1,680 1,809 1,120 1,750 1,800 1,800 6385 SEWER 526 542 423 600 650 650 6386 STORM SEWER 1,015 1,015 761 1,100 1,150 1,150 6380 UTILITY SERVICES 21,569 23,535 13,366 20,950 12,900 13,050 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 0 0 440 0 6403 BLDGS/FACILITIES MAINT SERVICE 636 8,280 1,673 2,000 2,000 2,100 6400 REPAIR & MAINT SERVICES 636 8,280 2,113 2,000 2,000 2,100 6410 RENTALS 6415 OTHER EQUIPMENT 6,045 1,746 814 3,500 3,500 3,500 6410 RENTALS 6,045 1,746 814 3,500 3,500 3,500 6420 IS SERVICES/LICENSES/FEES 6422 SOFTWARE MAINT 247 331 293 350 350 350 6423 LOGIS CHARGES 3,484 4,137 2,589 4,230 4,722 4,773 6420 IS SERVICES/LICENSES/FEES 3,731 4,468 2,882 4,580 5,072 5,123 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 476 150 620 500 500 500 6433 MEETING EXPENSES 26 37 6434 DUES & SUBSCRIPTIONS 985 245 1,000 500 1,000 1,000 6435 CREDIT CARD FEES 3,110 2,970 2,534 3,000 3,100 3,200 6438 CASH SHORT (OVER)476 54 -32 6430 MISCELLANEOUS 5,048 3,445 4,159 4,000 4,600 4,700 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 279 229 365 500 500 500 6449 OTHER CONTRACTUAL SERVICES 1,284 465 128 1,000 1,000 1,000 6440 OTHER EXPENSES 1,563 694 493 1,500 1,500 1,500 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 0 176 232 0 6462 FIXED CHARGES 6,603 7,148 6,351 7,992 8,150 6463 REPAIR & MAINT CHARGES 4,970 7,563 1,596 9,085 9,539 6465 REPLACEMENT CHARGES 15,170 18,635 17,757 26,774 26,200 6460 CENTRAL GARAGE CHARGES 26,744 33,522 25,936 43,851 43,889 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFER 9,855 4,293 6,031 8,041 8,282 CITY OF BROOKLYN CENTER Budget Report Object! Description 2011 Actual Amount 2012 Actual Amount September YTD 2013 Actual 2013 Adopted Budget 2014 Requested Budget 2015 Requested Budget 6470 TRANSFERS AND OTHER USES 9,855 4,293 6,031 8,041 8,282 6490 OTHER MISC COSTS/EXPENSES 6491 MERCHANDUSE FOR RESALE 21,330 24,648 16,325 21,000 21,000 21,500 6494 DEPRECIATION EXPENSE 28185 28262 8,091 28,825 29,700 30,000 6490 OTHER MISC COSTS/EXPENSES 49,514 52,910 24,415 49,825 50,700 51,500 6299 OTHER CHARGES & SERVICES 134,855 143,129 89,150 155,327 149,918 93,896 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6540 EQUIPMENT & MACHINERY 0 15,000 6,000 6501 CAPITAL OUTLAY 0 0 0 0 15,000 6,000 6500 CAPITAL OUTLAY 0 0 0 0 15,000 6,000 6001 EXPENDITURES/EXPENSES 283,196 272,284 195,714 304,900 312,610 250,650 4000 REVENUES AND EXPENSES 91,970 -135,743 34,658 77,550 64,610 -7,350 49721 - CENTERBROOK GOLF COURSE 91,970 -135,743 34,658 77,550 64,610 -7,350 Total 61300 - CENTERBROOK GOLF COURSE 91,970 -135,743 34,658 77,550 64,610 -7,350