HomeMy WebLinkAbout2012 10-29 CCP Joint Session with Financial Commission AGENDA
CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION
October 29, 2012
6:30 p.m.
City Hall—City Council Chambers
1. Call to Order
II. Introduction and Overview—City Manager/Director of Finance
III. Earle Brown Heritage Center
IV. BC Liquor Stores 91 and #2
V. Utility Rates
VI. Next Meeting—November 5, 2012
VII. Miscellaneous
VIII. Adjournment
2013 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 2 tenants.
A management agreement with Flik International for the food and beverage is currently in place until
2014.
Staffing Levels
Positions FTEs 2012 2013 2014
• 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 Mangers 2 2 3
• Maintenance Custodian 2 2 2
• Crew Chiefs 2 2 2
• Part-time Staff
7 8 9
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.
1
i
• Catering Division
o This division is responsible for facility owned equipment, product, and building
maintenance related to food.
The food and beverage contract expenses are found in the 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 2013 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
2
SUMMARY
2009 2010 2011 October YTD 2012 2013 2014
Object Description Actual Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Amount Actual Budget Budget Budget
61700-EARLE BROWN HERITAGE CENTER
4000 REVENUES AND EXPENSES
4001 REVENUES
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4603 INTEREST EARNINGS -10,695 -4,268 -6,698 -3,255 -6,767 -6,700 -6,700
4604 CHECK PROCESSING FEES -30 0 - -30 -30 ',
4605 UNREALIZED INVESTMENT GAIN/LOSS -266 2,615 -1,660 0
4606 OTHER REVENUE -372 -75 -2,306 -374
4609 UNCOLLECTIBLE WRITE OFF 0 11,552 0 0
4600 MISCELLANEOUS REVENUE -11,362 9,824 -10,695 -3,660 -6,767 -6,700 -6,700
4599 MISCELLANEOUS REVENUE -11,362 9,824 -10,695 3,660 -6,767 -6,700 -6,700
4800 EBHC
4820 CONVENTION CENTER
4821 ROOM RENTALS -623,785 -579,419 -604,105 -504,213 -720,000 -725,000 -730,000
4821.1 CMP ROOM RENTALS 0 0 0 0 0
4822 LABOR CHARGES -10,740 -10,520 -19,770 -17,378 -12,850 -13,000 -13,000
4823 EQUIPMENT RENTALS -248,709 -295,322 -338,540 -287,714 -300,000 350,000 -360,000
4823.1 CMP EQUIPMENT RENTALS 0 0 0 0 0
4825 COMMON AREA MTNCE -9,798 -13,063 -13,063
4826 DANCE FLOOR RENTALS 0 0 0 0 0
4827 SECURITY SERVICES -23,975 -21,125 -26,608 -24,150 -26,000 -26,000 -27,000
4828 CLIENT SERVICES -37,834 -40,640 -46,391 -43,765 -50,500 -55,000 -57,000
4829 MISCELLANEOUS -2,535 -3,705 -2,535 -6,790 -3,000 -6,000 -6,000
4820 CONVENTION CENTER -947,579 -950,730 -1,037,950 -893,806 -1,112,350 -1,188,063 -1,206,063
4630 OFFICE RENTAL
4831 OFFICE RENTALS -25,680 -101,660 -25,680 -74,610 -99,480 -99,487 -99,487
4830 OFFICE RENTAL -25,680 -101,660 -25,680 -74,610 -99,480 -99,487 -99,487
4840 CATERING SERVICES
4842 SERVICE CHARGES -384,036 -429,929 -464,359 -373,794 -516,650 -495,350 -495,350
4844 FOOD&BEVERAGE SALES -1,859,779 -2,033,558 -2,170,033 -1,695,952 -2,198,500 -2,338,400 -2,430,800
4845 LIQUORNVINE/BEER SALES -284,928 -282,835 -308,170 -286,625 -302,000 -319,750 -321,000
4848 MISCELLANEOUS SALES -40,075 -47,230 -42,548 -31,653 -40,992 -41,550 -42,000
4840 CATERING SERVICES -2,568,819 -2,793,552 -2,985,109 -2,388,024 -3,056,142 -3,195,050 -3,289,150
4800 EBHC -3,542,077 -3,845,943 -4,048,739 -3,356,440 -4,269,972 -4,482,600 -4,594,700
4900 OTHER FINANCING SOURCES
4912 CAPITAL CONTRIBUTIONS -113,516 -110,168 -878,046 0I
4921 REFUNDS&REIMBURSEMENTS -244 -10 -60,227 0
4900 OTHER FINANCING SOURCES -113,760 -110,178 -938,273 0
5550 DIRECT COST OF SALES
5580 COST OF GOODS SOLD
i
5590 EBHC CONTRACT EXPENSES
5591 COST OF SALES-LABOR 1,168,497 1,199,944 1,265,168 926,474 1,319,621 1,302,817 1,348,550 I
5592 COST OF SALES-FOOD 415,028 509,847 571,750 455,548 565,748 604,622 624,900
5593 COST OF SALES-SUPPLIES 130,740 139,760 139,721 108,799 128,115 142,658 148,000
5594 COST OF SALES-MGMT FEES 102,600 105,023 108,600 83,700 111,600 114,600 117,600
5590 EBHC CONTRACT EXPENSES 1,816,865 1,954,574 2,085,239 1,574,522 2,125,084 2,164,697 2,239,050
5550 DIRECT COST OF SALES 1,816,865 1,954,574 2,085,239 1,574,522 2,125,084 2,164,697 2,239,050
4001 REVENUES -1,850,335 -1,991,722 -2,912,468 -1,785,578 -2,151,655 -2,324,603 -2,362,350
6001 EXPENDITURES/EXPENSES '.
6099 PERSONAL SERVICES '..
6100 WAGES AND SALARIES ',..
6101 WAGES&SALARIES-FT EMPLOYEES 526,619 466,372 518,833 408,740 547,663 562,004 583,004 '..
6102 OVERTIME-FT EMPLOYEES 713 1,152 818 989 0
6103 WAGES-PART TIME EMPLOYEES 169,099 166,836 167,050 121,171 180,800 187,396 193,995
6104 OVERTIME-PART TIME EMPLOYEES 39 213 67 0 0 0 0
3
SUMMARY
2009 2010 2011 October 2012 2013 2014
Object I Description Actual Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Amount Actual Budget Budget Budget
6100 WAGES AND SALARIES 696,469 634,575 686,768 530,900 728,463 749,400 776,999
6110 OTHER PAYMENTS-NON INSURANCE
6111 SEVERANCE 9,771 6,153 5,066 0
6110 OTHER PAYMENTS-NON INSURANCE 9,771 6,153 5,066 0
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 44,726 42,178 47,256 37,700 52,886 44,477 46,105
6125 FICA 44,047 40,595 43,519 33,922 45,226 46,190 47,873
6126 MEDICARE CONTRIBUTIONS 10,301 9,494 10,178 7,933 10,578 8,948 9,280
6120 RETIREMENT CONTRIBUTIONS 99,074 92,267 100,953 79,556 108,690 99,615 103,258
6130 INSURANCE BENEFITS
6131 CAFETERIA PLAN CONTRIBUTIONS 97,678 93,002 104,589 73,114 118,668 118,668 118,668
6130 INSURANCE BENEFITS 97,678 93,002 104,589 73,114 118,668 118,668 118,668
6140 UNEMPLOYMENT COMPENSATION
6141 UNEMPOLOYMENT COMPENSATION 1,232 857 2,310 1,186 0 0
6140 UNEMPLOYMENT COMPENSATION 1,232 857 2,310 1,186 0 0 ',
6150 WORKERS'COMPENSATION '..
6151 WORKERS'COMPENSATION 22,625 23,685 20,168 15,432 21,482 15,615 16,144
6150 WORKER'S COMPENSATION 22,625 23,685 20,168 15,432 21,482 15,615 16,144
6099 PERSONAL SERVICES 926,848 850,538 919,854 700,188 977,303 983,298 1,015,069
6199 SUPPLIES
6200 OFFICE SUPPLIES
6201 OFFICE SUPPIES 1,780 3,762 2,738 2,018 3,604 3,200 3,200
6202 COPYING SUPPLIES 1,569 2,224 1,746 1,991 1,550 2,400 2,500
6203 BOOKS/REFERENCE MATERIALS 0 38 25 0 100 100 100
6200 OFFICE SUPPLIES 3,349 6,024 4,509 4,010 5,254 5,700 5,800
6210 OPERATING SUPPLIES
6211 CLEANING SUPPLIES 3,989 4,654 1,766 1,139 4,792 4,792 5,292
6212 MOTOR FUELS 0 33 61 65 100 150 200 '.
6214 CLOTHING&PERSONAL EQUIPMENT 540 802 859 256 1,000 1,040 1,040 '..
6215 SHOP MATERIALS 589 153 518 80 648 648 648
6216 CHEMICALSICHEMICAL PRODUCTS 4,445 4,832 4,244 4,080 5,600 5,700 5,800
6217 SAFETY SUPPLIES 856 908 986 867 1,348 1,448 1,448
6219 GENERAL OPERATING SUPPLIES 25,471 26,239 27,949 17,581 30,800 30,500 31,500
6210 OPERATING SUPPLIES 35,890 37,621 36,382 24,068 44,288 44,278 45,928
6220 REPAIR&MAINT SUPPLIES '...
6223 BUILDINGS&FACILITIES 15,988 21,571 20,311 12,750 24,000 24,000 26,000
6225 PARK&LANDSCAPE MATERIALS 2,418 2,704 1,657 1,742 4,700 7,800 5,900
6226 SIGNS&STRIPING MATERIALS 835 14 447 0 600 450 450
6227 PAINT SUPPLIES 2,546 1,981 1,646 1,170 2,746 2,750 2,750
6220 REPAIR&MAINT SUPPLIES 21,788 26,269 24,062 15,662 32,046 35,000 35,100
6230 REPAIR&MAINT SUPPLIES-OTHER
6237 LAUNDRY SUPPLIES 0 0 97 79 50 80 80
6239 OTHER REPAIR&MAINT SUPPLIES 4,093 7,324 6,947 4,858 7,296 7,500 9,500
6230 REPAIR&MAINT SUPPLIES-OTHER 4,093 7,324 7,044 4,937 7,346 7,580 9,580
6240 SMALL TOOLS&MINOR EQUIPMENT
6241 SMALL TOOLS 799 1,072 1,166 886 1,226 1,200 1,200
6242 MINOR EQUIPMENT 38,412 53,344 61,432 34,107 69,484 67,534 67,534
6243 MINOR COMPUTER EQUIPMENT 4,745 6,105 2,520 27,718 27,950 30,200 7,775
6240 SMALL TOOLS&MINOR EQUIPMENT 43,956 60,521 65,118 62,710 98,660 98,934 76,509
6199 SUPPLIES 109,075 137,759 137,114 111,386 187,594 191,492 172,917
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6301 ACCTG,AUDIT&FIN'L SERVICES 3,057 2,965 3,345 2,391 3,000 3,400 3,400
6303 LEGAL SERVICES 506 738 33 0 500 500 500
4
SUMMARY
2009 2010 2011 October YTD 2012 2013 2014
Object Description Actual Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Amount Actual Budget Budget Budget
6307 PROFESSIONAL SERVICES 16,723 32,643 43,836 17,112 36,650 42,150 42,150
6300 PROFESSIONAL SERVICES 20,285 36,346 47,214 19,502 40,150 46,050 46,050
6320 COMMUNICATIONS
6321 TELEPHONES/PAGES 8,303 7,928 5,971 4,461 6,736 9,791 9,391
6322 POSTAGE 1,414 1,579 1,795 1,041 2,900 2,900 2,900
6320 COMMUNICATIONS 9,718 9,508 7,766 5,501 9,636 12,691 12,291
6330 TRANSPORTATION
6331 TRAVEL EXPENSE/MILEAGE 1,138 739 869 670 1,200 1,000 1,000
6333 FREIGHT/DRAYAGE 276 195 259 457 296 900 900
6330 TRANSPORTATION 1,414 934 1,128 1,127 1,496 1,900 1,900
6340 ADVERTISING
6341 PERSONNEL ADVERTISING 1,060 958 912 334 2,300 1,300 1,300 '',,
6349 OTHER ADVERTISING 88,053 83,294 74,298 66,096 90,535 111,535 111,535 '..
6340 ADVERTISING 89,113 84,253 75,210 66,431 92,835 112,835 112,835
6350 PRINTING AND DUPLICATING
6351 PRINTING 7,191 5,453 15,327 14,645 12,980 13,700 13,700
6350 PRINTING AND DUPLICATING 7,191 5,453 15,327 14,645 12,980 13,700 13,700
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 15,352 12,551 13,450 11,509 16,178 16,496 17,682
6362 PROPERTY INSURANCE 30,662 33,164 33,256 28,497 40,825 39,535 42,225
6364 DRAM SHOP INSURANCE 0 950 1,010
6366 MACHINERY BREAKDOWN INSURANCE 1,936 1,900 1,851 1,676 2,251 1,432 1,531
6360 INSURANCE 47,949 47,615 48,557 41,682 59,254 58,413 62,448
6380 UTILITY SERVICES
6381 ELECTRIC 110,985 120,742 134,142 112,048 130,000 135,000 137,000
6382 GAS 39,771 53,812 38,867 26,195 64,400 64,400 64,400
6383 WATER 1,801 2,339 2,646 2,524 2,800 4,500 4,800
6384 REFUSE DISPOSAL 9,290 9,031 8,867 5,144 10,096 9,800 9,800
6385 SEWER 2,525 4,274 4,759 3,893 4,500 6,100 6,500
6386 STORM SEWER 2,168 3,076 3,155 2,381 3,300 4,600 5,000
6389 STREET LIGHTS 380 549 565 549 620 1,200 1,200
6380 UTILITY SERVICES 166,919 193,823 193,000 152,734 215,716 225,600 228,700
6400 REPAIR&MAINT SERVICES
6402 EQUIPMENT SERVICES 36,744 42,166 48,102 34,751 56,700 59,800 62,200
6403 BLDGS/FACILITIES MAINT SERVICE 3,741 4,351 4,815 3,170 7,500 5,650 5,650
6406 MULTI-FUNCTION MTNCE 351 1,191 4,450 3,500 3,850
6408 COMM UNICATION/INFOR SYSTEMS 0 0 81 0
6409 OTHER REPAIR&MAINT SERVICES 1,199 1,417 1,308 1,090 1,704 1,404 1,404
6400 REPAIR&MAINT SERVICES 41,684 47,934 54,656 40,203 70,354 70,354 73,104
6410 RENTALS
6413 OFFICE EQUIPMENT 6,067 5,908 6,041 3,107 3,320 4,700 4,700
6415 OTHER EQUIPMENT 103,600 114,289 156,977 135,946 110,996 150,500 150,500
6419 OTHER RENTAL EXPENSE 1,539 -1,539 0
6410 RENTALS 109,667 121,735 161,479 139,053 114,316 155,200 155,200
6420 IS SERVICES/LICENSES/FEES
6421 SOFTWARE LICENSE 0 0 294 160
6422 SOFTWARE MAINT 2,593 4,825 4,856 4,990 5,500 5,500 5,500
6423 LOGIS CHARGES 15,498 18,429 17,690 13,870 23,463 24,684 25,173
6428 PROTECTION SERVICES 13,890 18,013 19,707 15,299 17,000 18,000 19,000
64201S SERVICES/LICENSES/FEES 31,982 41,268 42,547 34,320 45,963 48,184 49,673
6430 MISCELLANEOUS
6432 CONFERENCES AND SCHOOLS 7,440 232 8,146 1,484 8,400 9,800 9,000
6433 MEETING EXPENSES 1,967 834 498 362 900 900 900
6434 DUES&SUBSCRIPTIONS 3,681 2,810 2,671 2,837 3,070 3,070 3,070
6435 CREDIT CARD FEES 15,186 16,924 22,862 17,243 21,000 23,000 23,000
6436 UNCOLLECTIBLE CHECKS/DEBTS 13,455 -10,104 -2,921 0 5,000 0 0 '..
6438 CASH SHORT(OVER) -103 -34 -100 -56
5
SUMMARY
2009 2010 2011 October YTD 2012 2013 2014
Object/Description Actual Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Amount Actual Budget Budget Budget
6430 MISCELLANEOUS 41,626 10,663 31,155 21,870 38,370 36,770 35,970 '..
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 22,137 5,429 5,741 5,147 10,000 6,000 6,000
6442 COURT AWARDS/SETTLEMENTS 1,052 0 1,581 0
6449 OTHER CONTRACTUAL SERVICES 33,152 39,209 31,567 16,356 38,903 37,204 37,204
6451 MTG PLANNER POINTS-EBHC 2,694
6440 OTHER EXPENSES 56,341 44,638 38,889 24,398 48,903 43,204 43,2041
6460 CENTRAL GARAGE CHARGES
6470 TRANSFERS AND OTHER USES
6471 ADMINISTRATIVE SERVICE TRANSFER 68,001 74,256 74,656 62,277 74,656 85,152 87,700
6476 CAPITAL PROJECT FUND TRANSFER 300,000 0 200,000 0 200,000 200,000 200,000
6470 TRANSFERS AND OTHER USES 368,001 74,256 274,656 62,277 274,656 285,152 287,700
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 624,329 628,867 632,486 504,404 666,375 685,590 698,090
6490 OTHER MISC COSTS/EXPENSES 624,329 628,867 632,486 504,404 666,375 685,590 698,090
6299 OTHER CHARGES&SERVICES 1,616,217 1,347,293 1,624,070 1,128,146 1,691,004 1,795,643 1,820,865
6500 CAPITAL OUTLAY
6501 CAPITAL OUTLAY
6520 BUILDINGS&FACILITIES 61,510 0
6540 EQUIPMENT&MACHINERY 5,049 0
6501 CAPITAL OUTLAY 66,559 0
6500 CAPITAL OUTLAY 66,559 0
6001 EXPENDITURES/EXPENSES 2,652,141 2,335,589 2,747,598 1,939,720 2,855,901 2,970,433 3,008,851
4000 REVENUES AND EXPENSES 801,806 343,867 -164,870 154,142 704,246 645,830 646,501
61700-EARLE BROWN HERITAGE CENTER 801,806 343,867 -164,870 154,142 704,246 645,830 646,501
6
i
ADMINISTRATION
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
61700-EARLE BROWN HERITAGE CENTER
49851-EBHC-ADMINISTRATION
4000 REVENUES AND EXPENSES
4001 REVENUES
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4603 INTEREST EARNINGS -4,268 -6,698 -3,255 -6,767 -6,700 -6,700
4604 CHECK PROCESSING FEES -30 -30
4605 UNREALIZED INVESTMENT GAIN/LOSS 2,615 -1,660 0
4606 OTHER REVENUE 0 0 0
4600 MISCELLANEOUS REVENUE -1,653 -8,388 -3,285 -6,767 -6,700 -6,700
4599 MISCELLANEOUS REVENUE -1,653 -8,388 -3,285 -6,767 -6,700 -6,700
4900 OTHER FINANCING SOURCES
4912 CAPITAL CONTRIBUTIONS -10,557 0
4921 REFUNDS&REIMBURSEMENTS -10 0 0
4900 OTHER FINANCING SOURCES -10 -10,557 0
4001 REVENUES -1,663 -18,945 -3,285 -6,767 -6,700 -6,700
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 114,400 154,753 118,674 161,716 168,031 174,617
6102 OVERTIME-FT EMPLOYEES 273 471 30
6100 WAGES AND SALARIES 114,673 155,224 118,704 161,716 168,031 174,617
6110 OTHER PAYMENTS-NON INSURANCE
6111 SEVERANCE 2,332 1,807 0
6110 OTHER PAYMENTS-NON INSURANCE 2,332 1,807 0
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 8,040 11,254 8,606 11,724 12,182 12,659
6125 FICA 7,251 9,805 7,440 10,026 10,418 10,826
6126 MEDICARE CONTRIBUTIONS 1,696 2,293 1,740 2,345 2,437 2,532
6120 RETIREMENT CONTRIBUTIONS 16,987 23,352 17,785 24,095 25,037 26,017
6130 INSURANCE BENEFITS
6131 CAFETERIA PLAN CONTRIBUTIONS 25,875 27,692 18,479 32,364 32,364 32,364
6130 INSURANCE BENEFITS 25,875 27,692 18,479 32,364 32,364 32,364
6150 WORKERS'COMPENSATION
6151 WORKERS'COMPENSATION 1,839 1,296 985 1,342 1,394 1,450
6150 WORKER'S COMPENSATION 1,839 1,296 985 1,342 1,394 1,450
6099 PERSONAL SERVICES 161,706 209,372 155,953 219,517 226,826 234,448
6199 SUPPLIES
6200 OFFICE SUPPLIES
6201 OFFICE SUPPIES 336 0 0 0 0 0
6200 OFFICE SUPPLIES 336 0 0 0 0 0
6210 OPERATING SUPPLIES
6219 GENERAL OPERATING SUPPLIES 0 0 0 0 0 0
6210 OPERATING SUPPLIES 0 0 0 0 0 0
6220 REPAIR&MAINT SUPPLIES
6223 BUILDINGS&FACILITIES 155 0 0 0
7
ADMINISTRATION
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object I Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6220 REPAIR&MAINT SUPPLIES 155 0 0 0
6240 SMALL TOOLS&MINOR EQUIPMENT
6242 MINOR EQUIPMENT 0 1,690 1,509 3,950 2,000 2,000
6243 MINOR COMPUTER EQUIPMENT 1,412 834 843 850 1,000
6240 SMALL TOOLS&MINOR EQUIPMENT 1,412 2,523 2,352 4,800 3,000 2,000
6199 SUPPLIES 1,748 2,523 2,507 4,800 3,000 2,000
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6301 ACCTG,AUDIT&FIN'L SERVICES 2,965 3,345 2,391 3,000 3,400 3,400
6303 LEGAL SERVICES 141 0 0 500 500 500
6307 PROFESSIONAL SERVICES 7,508 3,480 0 2,500 2,500 2,500
6300 PROFESSIONAL SERVICES 10,614 6,825 2,391 6,000 6,400 6,400
6320 COMMUNICATIONS
6321 TELEPHONES/PAGES 1,168 900 600 900 900 900
6320 COMMUNICATIONS 1,168 900 600 900 900 900
6340 ADVERTISING
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 2,803 2,623 2,290 3,434 3,260 3,490
6362 PROPERTY INSURANCE 8,291 8,314 7,124 10,864 10,160 10,875
6366 MACHINERY BREAKDOWN INSURANCE 475 463 419 583 600 640
6360 INSURANCE 11,569 11,400 9,833 14,881 14,020 15,005
6400 REPAIR&MAINT SERVICES
6420 IS SERVICES/LICENSES/FEES
6421 SOFTWARE LICENSE 0 294 0
6422 SOFTWARE MAINT 4,825 4,856 4,990 5,500 5,500 5,500
6423 LOGIS CHARGES 18,429 17,690 14,640 23,463 24,684 25,173
6420 IS SERVICES/LICENSES/FEES 23,254 22,840 19,630 28,963 30,184 30,673
6430 MISCELLANEOUS
6432 CONFERENCES AND SCHOOLS 0 2,195 1,229 2,400 2,800 3,000
6430 MISCELLANEOUS 0 2,195 1,229 2,400 2,800 3,000
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 0 0 0
6442 COURT AWARDS/SETTLEMENTS 1,581 0
6440 OTHER EXPENSES 0 1,581 0
6470 TRANSFERS AND OTHER USES
6471 ADMINISTRATIVE SERVICE TRANSFER 74,256 74,656 62,277 74,656 85,152 87,700
6476 CAPITAL PROJECT FUND TRANSFER 0 200,000 0 200,000 200,000 200,000
6470 TRANSFERS AND OTHER USES 74,256 274,656 62,277 274,656 285,152 287,700
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 25,633 25,771 19,699 29,325 30,790 30,790
6490 OTHER MISC COSTS/EXPENSES 25,633 25,771 19,699 29,325 30,790 30,790
6299 OTHER CHARGES&SERVICES 146,495 346,169 115,659 357,125 370,246 374,468
6001 EXPENDITURES/EXPENSES 309,949 558,064 274,119 581,442 600,072 610,916
400D REVENUES AND EXPENSES 308,286 539,119 270,834 574,675 593,372 604,216
8
ADMINISTRATION
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
49851-EBHC-ADMINISTRATION 308,286 539,119 270,834 574,675 593,372 604,216
Total 61700-EARLE BROWN HERITAGE CENTER 308,286 539,119 270,834 574,675 593,372 604,216
CONVENTION CENTER
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
61700-EARLE BROWN HERITAGE CENTER
49852-EBHC-CONVENTION CENTER
4000 REVENUES AND EXPENSES
4001REVENUES
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4604 CHECK PROCESSING FEES 0 0 0
4606 OTHER REVENUE -75 -2,306 -374
4609 UNCOLLECTIBLE WRITE OFF 4,586 0 0
4600 MISCELLANEOUS REVENUE 4,511 -2,306 -374
4599 MISCELLANEOUS REVENUE 4,511 -2,306 -374
4800 EBHC
4820 CONVENTION CENTER
4821 ROOM RENTALS -579,419 -604,105 -479,329 -720,000 -725,000 -730,000
4821.1 CMP ROOM RENTALS 0 0 0 0
4822 LABOR CHARGES -10,520 -19,770 -15,903 -12,850 -13,000 -13,000
4823 EQUIPMENT RENTALS -295,322 -338,540 -274,670 -300,000 -350,000 -360,000
4823.1 CMP EQUIPMENT RENTALS 0 0 0 0
4825 COMMON AREA MTNCE -8,709 -13,063 -13,063
4826 DANCE FLOOR RENTALS 0 0 0 0
4827 SECURITY SERVICES -21,125 -26,608 -20,825 -26,000 -26,000 -27,000
4828 CLIENT SERVICES -40,640 -46,391 -39,293 -50,500 -55,000 -57,000
4829 MISCELLANEOUS -3,705 -2,535 -6,595 -3,000 -6,000 -6,000
4820 CONVENTION CENTER -950,730 -1,037,950 -845,324 -1,112,350 -1,188,063 -1,206,063
4800 EBHC -950,730 -1,037,950 -845,324 -1,112,350 -1,188,063 -1,206,063
4900 OTHER FINANCING SOURCES
4912 CAPITAL CONTRIBUTIONS -110,168 -780,431 0
4921 REFUNDS&REIMBURSEMENTS 0 -60,227 0
4900 OTHER FINANCING SOURCES -110,168 -840,658 0
4001 REVENUES -1,056,387 -1,880,914 -845,698 -1,112,350 -1,188,063 -1,206,063
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 328,230 338,921 263,955 385,947 393,973 408,387
6102 OVERTIME-FT EMPLOYEES 682 347 688 0
6103 WAGES-PART TIME EMPLOYEES 121,035 120,870 83,254 129,000 134,000 139,000
6104 OVERTIME-PART TIME EMPLOYEES 156 52 0 0 0 0
6100 WAGES AND SALARIES 450,103 460,190 347,897 514,947 527,973 547,387
6110 OTHER PAYMENTS-NON INSURANCE
6111 SEVERANCE 3,821 3,259 0
6110 OTHER PAYMENTS-NON INSURANCE 3,821 3,259 0
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 30,271 31,930 24,765 37,336 28,564 29,608
6125 FICA 29,010 29,274 22,377 31,927 32,470 33,664
6126 MEDICARE CONTRIBUTIONS 6,785 6,847 5,235 7,467 5,711 5,922
6120 RETIREMENT CONTRIBUTIONS 66,066 68,051 52,377 76,730 66,745 69,194
6130 INSURANCE BENEFITS
6131 CAFETERIA PLAN CONTRIBUTIONS 67,127 76,897 50,443 86,304 86,304 86,304
6130 INSURANCE BENEFITS 67,127 76,897 50,443 86,304 86,304 86,304
10
CONVENTION CENTER
1
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 SeptemberYTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6140 UNEMPLOYMENT COMPENSATION
6141 UNEMPOLOYMENT COMPENSATION 857 2,310 1,186 0 0
6140 UNEMPLOYMENT COMPENSATION 857 2,310 1,186 0 0
6150 WORKERS'COMPENSATION
6151 WORKERS'COMPENSATION 18,037 15,600 11,676 17,836 12,011 12,476
6150 WORKER'S COMPENSATION 18,037 15,600 11,676 17,836 12,011 12,476
6099 PERSONAL SERVICES 606,011 626,307 463,580 695,817 693,033 715,361
6199 SUPPLIES
6200 OFFICE SUPPLIES
6201 OFFICE SUPPIES 2,130 1,733 850 2,300 1,900 1,900
6202 COPYING SUPPLIES 1,539 1,086 785 950 1,500 1,600
6203 BOOKS/REFERENCE MATERIALS 38 25 0 100 100 100
6200 OFFICE SUPPLIES 3,707 2,843 1,635 3,350 3,500 3,600
6210 OPERATING SUPPLIES
6211 CLEANING SUPPLIES 4,374 1,562 1,139 4,500 4,500 5,000
6212 MOTOR FUELS 33 61 65 100 150 200
6214 CLOTHING&PERSONAL EQUIPMENT 791 827 245 1,000 1,000 1,000
6215 SHOP MATERIALS 153 518 80 600 600 600
6216 CHEMICALS/CHEMICAL PRODUCTS 4,832 3,975 3,751 5,300 5,400 5,500
6217 SAFETY SUPPLIES 564 573 667 700 800 800
6219 GENERAL OPERATING SUPPLIES 25,853 27,750 16,258 30,000 30,000 31,000
6210 OPERATING SUPPLIES 36,601 35,265 22,205 42,200 42,450 44,100
6220 REPAIR&MAINT SUPPLIES
6223 BUILDINGS&FACILITIES 15,377 17,232 11,270 20,000 20,000 22,000
6225 PARK&LANDSCAPE MATERIALS 2,704 1,657 1,742 4,400 7,500 5,600
6226 SIGNS&STRIPING MATERIALS 14 268 0 300 300 300
6227 PAINT SUPPLIES 1,911 1,646 1,170 2,500 2,500 2,500
6220 REPAIR&MAINT SUPPLIES 20,005 20,803 14,182 27,200 30,300 30,400
6230 REPAIR&MAINT SUPPLIES-OTHER
6237 LAUNDRY SUPPLIES 0 97 79 50 80 80
6239 OTHER REPAIR&MAINT SUPPLIES 7,200 5,437 4,336 5,196 6,000 8,000
6230 REPAIR&MAINT SUPPLIES-OTHER 7,200 5,534 4,415 5,246 6,080 8,080
6240 SMALL TOOLS&MINOR EQUIPMENT
6241 SMALL TOOLS 1,072 1,154 886 1,226 1,200 1,200
6242 MINOR EQUIPMENT 41,209 40,226 6,796 41,534 41,534 41,534
6243 MINOR COMPUTER EQUIPMENT 1,773 0 12,779 13,125 27,550 3,000
6240 SMALL TOOLS&MINOR EQUIPMENT 44,054 41,380 20,460 55,885 70,284 45,734
6199 SUPPLIES 111,568 105,825 62,898 133,881 152,614 131,914
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6303 LEGAL SERVICES 597 33 0
6307 PROFESSIONAL SERVICES 25,135 40,356 11,931 20,575 23,075 23,075
6300 PROFESSIONAL SERVICES 25,732 40,389 11,931 20,575 23,075 23,075
6320 COMMUNICATIONS
6321 TELEPHONES/PAGES 5,441 4,135 2,797 4,900 7,135 6,835
6322 POSTAGE 931 1,469 527 2,500 2,500 2,500
6320 COMMUNICATIONS 6,372 5,604 3,323 7,400 9,635 9,335
6330 TRANSPORTATION 1 1
CONVENTION CENTER
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object I Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6331 TRAVEL EXPENSE/MILEAGE 739 869 670 1,200 1,000 1,000
6333 FREIGHT/DRAYAGE 195 259 457 200 900 900
6330 TRANSPORTATION 934 1,128 1,127 1,400 1,900 1,900
6340 ADVERTISING
6341 PERSONNEL ADVERTISING 958 912 290 2,300 1,300 1,300
6349 OTHER ADVERTISING 37,976 28,977 27,074 46,273 58,073 58,073
6340 ADVERTISING 38,934 29,889 27,364 48,573 59,373 59,373
6350 PRINTING AND DUPLICATING
6351 PRINTING 3,599 6,486 957 7,500 7,500 7,500
6350 PRINTING AND DUPLICATING 3,599 6,486 957 7,500 7,500 7,500
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 4,967 5,841 4,760 6,755 6,900 7,420
6362 PROPERTY INSURANCE 10,281 10,309 8,834 12,384 12,600 13,480
6366 MACHINERY BREAKDOWN INSURANCE 589 574 520 690 740 790
6360 INSURANCE 15,837 16,724 14,113 19,829 20,240 21,690
6380 UTILITY SERVICES
6381 ELECTRIC 98,592 108,680 79,384 99,000 103,000 105,000
6382 GAS 23,833 17,219 10,898 27,000 27,000 27,000
6383 WATER 1,029 1,165 1,056 1,200 1,600 1,800
6384 REFUSE DISPOSAL 1,914 1,532 929 2,100 2,100 2,100
6385 SEWER 1,933 1,978 1,731 2,000 3,000 3,400
6386 STORM SEWER 1,538 1,553 1,553 1,800 3,000 3,400
6389 STREET LIGHTS 275 282 266 300 600 600
6380 UTILITY SERVICES 129,113 132,410 95,818 133,400 140,300 143,300
6400 REPAIR&MAINT SERVICES
6402 EQUIPMENT SERVICES 31,623 31,135 14,231 35,700 37,800 39,200
6403 BLDGS/FACILITIES MAINT SERVICE 2,003 2,611 1,427 3,000 3,000 3,000
6406 MULTI-FUNCTION MTNCE 351 1,049 2,725 2,500 2,750
6408 COMMUNICATION/INFOR SYSTEMS 0 81 0
6409 OTHER REPAIR&MAINT SERVICES 109 0 0 300 0 0
6400 REPAIR&MAINT SERVICES 33,734 34,178 16,707 41,725 43,300 44,950
6410 RENTALS
6413 OFFICE EQUIPMENT 3,535 3,621 1,934 2,310 2,300 2,300
6415 OTHER EQUIPMENT 112,039 156,977 134,621 110,000 150,000 150,000
6419 OTHER RENTAL EXPENSE 1,539 -1,539 0
6410 RENTALS 117,113 159,059 136,556 112,310 152,300 152,300
6420 IS SERVICES/LICENSES/FEES
6421 SOFTWARE LICENSE 0 0 160
6428 PROTECTION SERVICES 18,013 19,707 12,809 17,000 18,000 19,000
6420 IS SERVICES/LICENSES/FEES 18,013 19,707 12,969 17,000 18,000 19,000
6430 MISCELLANEOUS
6432 CONFERENCES AND SCHOOLS 232 4,457 255 4,500 5,500 4,500
6433 MEETING EXPENSES 834 498 362 900 900 900
6434 DUES&SUBSCRIPTIONS 2,810 2,671 2,562 3,000 3,000 3,000
6435 CREDIT CARD FEES 2,178 3,176 1,868 4,000 3,000 3,000
6436 UNCOLLECTIBLE CHECKS/DEBTS -2,706 -829 0
6438 CASH SHORT(OVER) -1 -55 0
6430 MISCELLANEOUS 3,347 9,917 5,047 12,400 12,400 11,400
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 200 12 200 200
CONVENTION CENTER
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object I Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6442 COURT AWARDS/SETTLEMENTS 0 0 0
6449 OTHER CONTRACTUAL SERVICES 23,371 17,352 8,309 21,400 21,400 21,400
6451 MTG PLANNER POINTS-EBHC 2,894
6440 OTHER EXPENSES 23,571 17,552 11,403 21,400 21,400 21,400
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 300,582 303,429 252,245 318,600 325,000 325,000
6490 OTHER MISC COSTS/EXPENSES 300,582 303,429 252,245 318,600 325,000 325,000
6299 OTHER CHARGES&SERVICES 716,881 776,472 589,560 762,112 834,423 840,223
i
6500 CAPITAL OUTLAY
6501 CAPITAL OUTLAY
6520 BUILDINGS&FACILITIES 61,510 0
6540 EQUIPMENT&MACHINERY 5,049 0
6501 CAPITAL OUTLAY 66,559 0
6500 CAPITAL OUTLAY 66,559 0
6001 EXPENDITURES/EXPENSES 1,434,460 1,575,163 1,116,038 1,591,810 1,680,070 1,687,498
4000 REVENUES AND EXPENSES 378,072 -305,751 270,340 479,460 492,007 481,435
49852-EBHC-CONVENTION CENTER 378,072 -305,751 270,340 479,460 492,007 481,435
Total 61700-EARLE BROWN HERITAGE CENTER 378,072 -305,751 270,340 479,460 492,007 481,435
13
CATERING
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
61700-EARLE BROWN HERITAGE CENTER
49853-EBHC-CATERING OPERATIONS
4000 REVENUES AND EXPENSES
4001 REVENUES
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4609 UNCOLLECTIBLE WRITE OFF 6,966 0 0
4600 MISCELLANEOUS REVENUE 6,966 0 0
4599 MISCELLANEOUS REVENUE 6,966 0 0
4800 EBHC
4840 CATERING SERVICES
4842 SERVICE CHARGES -429,929 -464,359 -350,803 -516,650 -495,350 -495,350
4844 FOOD&BEVERAGE SALES -2,033,558 -2,170,033 -1,602,285 -2,198,500 -2,338,400 -2,430,800
4845 LIQUOR/WINE/BEER SALES -282,835 -308,170 -265,335 -302,000 -319,750 -321,000
4848 MISCELLANEOUS SALES -47,230 -42,548 -29,830 -40,992 -41,550 -42,000
4840 CATERING SERVICES -2,793,552 -2,985,109 -2,248,254 -3,058,142 -3,195,050 -3,289,150
4800 EBHC -2,793,552 -2,985,109 -2,248,254 -3,058,142 -3,195,050 -3,289,150
4900 OTHER FINANCING SOURCES
4912 CAPITAL CONTRIBUTIONS 0 -87,058 0
4900 OTHER FINANCING SOURCES 0 -87,058 0
5550 DIRECT COST OF SALES
5580 COST OF GOODS SOLD
5590 EBHC CONTRACT EXPENSES
5591 COST OF SALES-LABOR 1,199,944 1,265,168 926,474 1,319,621 1,302,817 1,348,550
5592 COST OF SALES-FOOD 509,847 571,750 454,926 565,748 604,622 624,900
5593 COST OF SALES-SUPPLIES 139,760 139,721 108,799 128,115 142,658 148,000
5594 COST OF SALES-MGMT FEES 105,023 108,600 83,700 111,600 114,600 117,600
5590 EBHC CONTRACT EXPENSES 1,954,574 2,085,239 1,573,899 2,125,084 2,164,697 2,239,050
5550 DIRECT COST OF SALES 1,954,574 2,085,239 1,573,699 2,125,084 2,164,697 2,239,050
4001 REVENUES -832,012 -986,928 -674,354 -933,058 -1,030,353 -1,050,100
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 22,376 24,788 16,172
6102 OVERTIME-FT EMPLOYEES 198 0 197
6103 WAGES-PART TIME EMPLOYEES 43,344 43,855 32,878 48,600 50,100 51,600
6104 OVERTIME-PART TIME EMPLOYEES 57 15 0
6100 WAGES AND SALARIES 65,974 68,658 49,247 48,600 50,100 51,600
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 3,599 3,875 3,237 3,524 3,500 3,600
6125 FICA 4,096 4,273 3,142 3,013 3,100 3,175
6126 MEDICARE CONTRIBUTIONS 957 999 734 705 750 775
6120 RETIREMENT CONTRIBUTIONS 8,652 9,147 7,114 7,242 7,350 7,550
6150 WORKERS'COMPENSATION
6151 WORKERS'COMPENSATION 3,594 3,143 2,281 2,304 2,000 2,000
6150 WORKER'S COMPENSATION 3,594 3,143 2,281 2,304 2,000 2,000
6099 PERSONAL SERVICES 78,220 80,948 58,641 58,146 59,450 61,150
14
CATERING
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6199 SUPPLIESi
6200 OFFICE SUPPLIES
6201 OFFICE SUPPIES 1,296 1,005 789 1,304 1,300 1,300
6202 COPYING SUPPLIES 684 660 542 600 900 900
6200 OFFICE SUPPLIES 1,981 1,665 1,331 1,904 2,200 2,200
6210 OPERATING SUPPLIES
6211 CLEANING SUPPLIES 280 204 0 292 292 292
6214 CLOTHING&PERSONAL EQUIPMENT 11 32 11 0 40 40
6215 SHOP MATERIALS 48 48 48
6216 CHEMICALS/CHEMICAL PRODUCTS 0 269 329 300 300 300
6217 SAFETY SUPPLIES 343 413 141 648 648 648
6219 GENERAL OPERATING SUPPLIES 386 199 0 800 500 500
6210 OPERATING SUPPLIES 1,020 1,117 480 2,088 1,828 1,828
6220 REPAIR&MAINT SUPPLIES
6223 BUILDINGS&FACILITIES 3,232 2,210 1,259 3,000 3,000 3,000
6227 PAINT SUPPLIES 0 0 0 96 100 100
6220 REPAIR&MAINT SUPPLIES 3,232 2,210 1,259 3,096 3,100 3,100
6230 REPAIR&MAINT SUPPLIES-OTHER
6239 OTHER REPAIR&MAINT SUPPLIES 123 1,510 522 2,100 1,500 1,500
6230 REPAIR&MAINT SUPPLIES-OTHER 123 1,510 522 2,100 1,500 1,500
6240 SMALL TOOLS&MINOR EQUIPMENT
6241 SMALL TOOLS 12 0
6242 MINOR EQUIPMENT 12,135 19,516 25,802 24,000 24,000 24,000
6243 MINOR COMPUTER EQUIPMENT 2,920 1,686 11,843 13,975 1,650 4,775
6240 SMALL TOOLS&MINOR EQUIPMENT 15,055 21,214 37,645 37,975 25,650 28,775
6199 SUPPLIES 21,411 27,716 41,237 47,163 34,278 37,403
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6307 PROFESSIONAL SERVICES 0 0 5,180 13,575 16,575 16,575
6300 PROFESSIONAL SERVICES 0 0 5,180 13,575 16,575 16,575
6320 COMMUNICATIONS
6321 TELEPHONES/PAGES 1,319 936 624 936 1,756 1,656
6322 POSTAGE 649 326 514 400 400 400
6320 COMMUNICATIONS 1,968 1,262 1,138 1,336 2,156 2,056
6330 TRANSPORTATION
6333 FREIGHT/DRAYAGE 0 0 0 96 0 0
6330 TRANSPORTATION 0 0 0 96 0 0
6340 ADVERTISING
6349 OTHER ADVERTISING 45,318 45,321 34,214 44,262 53,462 53,462
6340 ADVERTISING 45,318 45,321 34,214 44,262 53,462 53,462
6350 PRINTING AND DUPLICATING
6351 PRINTING 1,854 8,840 0 5,480 6,200 6,200
6350 PRINTING AND DUPLICATING 1,854 8,840 0 5,480 6,200 6,200
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 4,293 4,536 4,052 5,442 5,760 6,170
6362 PROPERTY INSURANCE 13,266 13,302 11,399 15,980 15,195 16,250
6364 DRAM SHOP INSURANCE 0 950 1,010
6366 MACHINERY BREAKDOWN INSURANCE 760 15 740 670 890
CATERING
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6360 INSURANCE 18,319 18,578 16,121 22,312 21,905 23,430
6380 UTILITY SERVICES
6381 ELECTRIC 18,020 19,965 14,564 26,000 26,000 26,000
6382 GAS 23,389 16,903 10,691 30,000 30,000 30,000
6383 WATER 1,014 1,161 1,193 1,200 2,400 2,400
6384 REFUSE DISPOSAL 6,429 6,651 3,702 7,000 7,000 7,000
6385 SEWER 1,918 2,296 1,773 1,900 2,500 2,500
6386 STORM SEWER 1,538 1,601 828 1,500 1,600 1,600
6389 STREET LIGHTS 275 282 284 320 600 600
6380 UTILITY SERVICES 52,581 48,859 33,033 67,920 70,100 70,100
6400 REPAIR&MAINT SERVICES
6402 EQUIPMENT SERVICES 8,013 16,796 13,166 19,500 20,000 21,000
6403 BLDGS/FACILITIES MAINT SERVICE 2,229 2,062 1,427 3,996 2,500 2,500
6406 MULTI-FUNCTION MTNCE 142 1,725 1,000 1,100
6409 OTHER REPAIR&MAINT SERVICES 1,308 1,308 981 1,404 1,404 1,404
6400 REPAIR&MAINT SERVICES 11,550 20,166 15,715 26,625 24,904 26,004
6410 RENTALS
6413 OFFICE EQUIPMENT 2,372 2,420 1,173 1,010 2,400 2,400
6415 OTHER EQUIPMENT 2,250 0 0 996 500 500
6410 RENTALS 4,622 2,420 1,173 2,006 2,900 2,900
6430 MISCELLANEOUS
6432 CONFERENCES AND SCHOOLS 0 1,494 0 1,500 1,500 1,500
6434 DUES&SUBSCRIPTIONS 0 0 0 70 70 70
6435 CREDIT CARD FEES 14,746 19,686 15,375 17,000 20,000 20,000
6436 UNCOLLECTIBLE CHECKS/DEBTS -7,398 -2,092 0 5,000 0 0
6438 CASH SHORT(OVER) -32 -45 -56
6430 MISCELLANEOUS 7,316 19,043 15,319 23,570 21,570 21,570
6440 OTHER EXPENSES
6449 OTHER CONTRACTUAL SERVICES 9,089 7,530 3,861 9,204 9,204 9,204
6440 OTHER EXPENSES 9,089 7,530 3,861 9,204 9,204 9,204
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 160,226 160,859 125,348 168,900 177,800 182,000
6490 OTHER MISC COSTS/EXPENSES 160,226 160,859 125,348 168,900 177,800 182,000
6299 OTHER CHARGES&SERVICES 312,843 332,879 251,102 385,286 406,776 413,501
i
6001 EXPENDITURES/EXPENSES 412,474 441,544 350,980 490,595 500,504 512,054
4000 REVENUES AND EXPENSES -419,538 -545,385 -323,374 -442,463 -529,849 -538,046
49853-EBHC-CATERING OPERATIONS -419,538 -545,385 -323,374 -442,463 -529,849 -538,046
Total 61700-EARLE BROWN HERITAGE CENTER -419,538 -545,385 -323,374 -442,463 -529,849 -538,046
16
OFFICE RENTAL
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object I Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
61700-EARLE BROWN HERITAGE CENTER
49854-EBHC-OFFICE RENTAL
4000 REVENUES AND EXPENSES
4001 REVENUES
4800 EBHC
4830 OFFICE RENTAL
4831 OFFICE RENTALS -101,660 -25,680 -68,460 -99,480 -99,487 -99,487
4830 OFFICE RENTAL -101,660 -25,680 -68,460 -99,480 -99,487 -99,487
4800 EBHC -101,660 -25,680 -68,460 -99,480 -99,487 -99,487
4900 OTHER FINANCING SOURCES
4001 REVENUES -101,660 -25,680 -68,460 -99,480 -99,487 -99,487
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 1,367 371 634 0
6103 WAGES-PART TIME EMPLOYEES 2,458 2,325 1,865 3,200 3,296 3,395
6100 WAGES AND SALARIES 3,825 2,696 2,499 3,200 3,296 3,395
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 268 197 181 302 231 238
6125 FICA 239 167 156 260 202 208
6126 MEDICARE CONTRIBUTIONS 56 39 36 61 50 51
6120 RETIREMENT CONTRIBUTIONS 563 403 373 623 483 497
6150 WORKERS'COMPENSATION
6151 WORKERS'COMPENSATION 214 128 120 0 210 218
6150 WORKER'S COMPENSATION 214 128 120 0 210 218
6099 PERSONAL SERVICES 4,601 3,227 2,991 3,823 3,989 4,110
6199 SUPPLIES
6210 OPERATING SUPPLIES
6220 REPAIR&MAINT SUPPLIES
6223 BUILDINGS&FACILITIES 2,962 870 0 1,000 1,000 1,000
6225 PARK&LANDSCAPE MATERIALS 300 300 300
6226 SIGNS&STRIPING MATERIALS 0 180 0 300 150 150
6227 PAINT SUPPLIES 70 0 0 150 150 150
6220 REPAIR&MAINT SUPPLIES 3,032 1,049 0 1,750 1,600 1,600
6199 SUPPLIES 3,032 1,049 0 1,750 1,600 1,600
6299 OTHER CHARGES&SERVICES
6340 ADVERTISING
6349 OTHER ADVERTISING 0 0 0
6340 ADVERTISING 0 0 0
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 487 450 407 547 576 602
6362 PROPERTY INSURANCE 1,327 1,330 1,140 1,597 1,580 1,620
6366 MACHINERY BREAKDOWN INSURANCE 76 74 67 88 92 101
6360 INSURANCE 1,890 1,855 1,614 2,232 2,248 2,323
6380 UTILITY SERVICES
6381 ELECTRIC 4,130 5,498 4,002 5,000 6,000 6,000
6382 GAS 6,590 4,745 3,513 7,400 7,400 7,400
6383 WATER 296 320 275 400 500 600
17
i
OFFICE RENTAL
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6384 REFUSE DISPOSAL 689 684 513 996 700 700
6385 SEWER 424 485 388 600 600 600
6380 UTILITY SERVICES 12,129 11,732 8,691 14,396 15,200 15,300
6400 REPAIR&MAINT SERVICES
6402 EQUIPMENT SERVICES 2,530 171 3,773 1,500 2,000 2,000
6403 BLDGS/FACILITIES MAINT SERVICE 120 141 0 504 150 150
6400 REPAIR&MAINT SERVICES 2,650 312 3,773 2,004 2,150 2,150
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 5,229 5,541 4,947 10,000 6,000 6,000
6449 OTHER CONTRACTUAL SERVICES 6,749 6,684 3,440 8,299 6,600 6,600
6440 OTHER EXPENSES 11,978 12,225 8,388 18,299 12,600 12,600
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 142,427 142,427 107,113 149,550 152,000 160,300
6490 OTHER MISC COSTS/EXPENSES 142,427 142,427 107,113 149,550 152,000 160,300
6299 OTHER CHARGES&SERVICES 171,073 168,550 129,579 186,481 184,198 192,673
6001 EXPENDITURES/EXPENSES 178,706 172,826 132,570 192,054 189,787 198,383
4000 REVENUES AND EXPENSES 77,046 147,146 64,110 92,574 90,300 98,896
49854-EBHC-OFFICE RENTAL 77,046 147,146 64,110 92,574 90,300 98,896
Total 61700-EARLE BROWN HERITAGE CENTER 77,046 147,146 64,110 92,574 90,300 98,896
�g
Earle Brown Heritage Center
2013 Budget Targets
2013 2013 Over/
Revenues Budget Target (Under)
Total Convention Center 1,188,063 1,188,063
Total Catering Revenue 3,195,050 3,195,050
Office Rental 99,487 99,487
Nonoperating Revenue 6,700 6,700
4,489,300 4,489,300
As a%of
Budget Catering Target Over/
Cost of Sales 2013 Rev % (Under)
Flik Cost of Sales 2,164,697
EBHC Cat. Personal Serv. 59,450
2,224,147 69.61% 67.00% 2.61%
Asa%of
Budget Total Target Over/
Operating Expenses 2013 Rev.YTD % (Under)
Total Personal Services 923,848 20.58% 20.00% 0.58%
Supplies
Office&Operating Supplies 49,978
Repair& Maintenance Supplies 81,972
Small Tools&Minor Equipment 98,934
Total Supplies 230,884 5.14% 3.50% 1.64%
Services&Other Charges
Advertising& Printing 112,835
Communications 12,691
Contractual Services 79,888
Insurance 58,413
Other 49,470
Professional Services 46,050
Repair&Maintenance 70,354
Rentals 155,200
Taxes& Licenses 6,000
Interest
Total Serv. &Other charges 590,901 13.16% 11.00% 2.16%
Utilities 225,600 5.03% 5.50% -0.47%
Administrative Service 85,152 1.90% 1.90% 0.00%
Total Operating Expenses 2,056,385 45.81% 41.90% 3.91%
19
�E TE
AN HISTORIC RESTORATION
Conference & Event Center
2013
ADVERTISING AND MARKETING PLAN
EARLE BROWN HERITAGE CENTER
6155 Earle Brown Drive
Brooklyn Center, MN 55430
www.earlebrown.com
763-569-6300
Earle Brown Heritage Center 2013 Marketing Plan pg. 1
20
i
OUR MISSION STATEMENT:
It is the mission of the Earle Brown Heritage Center to deliver a high quality customer
experience by providing exceptional customer service and extraordinary food service in an
uncommon historic setting.
OUR MARKETING PARTNER:
Russell Herder, 222 9t" Street, Suite 850, Minneapolis, MN 55402 is the agency of record for
2012. Brand Manager, Emily Halva, is the direct contact and can be reached at 612-455-2360.
We are currently reviewing agencies for 2013. No decision has been made at this time.
FACILITY ASSESSMENT:
Development of the yearly advertising and marketing plan begins with a review of identified
strengths and weaknesses as listed below. Comparison with assessments from prior years will
find that there is not significant change in these areas.
Strengths: Weaknesses:
• Historically significant • Shuttling difficulties for clients
• Onsite audiovisual • Distance from airport/Airport Shuttle Difficulties
• Freeway/highway access&free parking • Lack of corporate development in North and
• Seasonal outdoor courtyard&completion of West communities
Garden City Ballroom Patio • Loss of corporate tenants in area commercial
• Award winning onsite catering buildings
• Unique meeting space • Lack of area attractions and amenities
• Experienced,dedicated staff • Interior decor of Carriage Hall is showing
• Competitive pricing extensive wear,including dated lighting fixtures
• Within 10 minutes of downtown Mpls. • Lighting issues in some ballrooms
• Now connected to adjacent hotel via link • Lack of attractions within walking distance
• Strong repeat client base • Lack of private business center
• Access to Hilton W.Wide&Meet Mpls. leads
• Completion of updated marketing tools(Sales Kits-
Corporate,Corporate Social&Wedding) Opportunities:
• Meet Minneapolis North sponsorship funds to
Threats: attract new business to facility
• State planners building Request for Proposal to 0 Continue to offer a joint invoice for clients
predetermined site specifications between Earle Brown Heritage Center and
• Economy causes increased competition Embassy Suites
• Larger corporations creating their own onsite . Building relationships with competitors for referral
meeting facilities business Cvent membership provides p p opportunity
• Slow economic growth creates less profit in mtgs to connect with multiple meeting planning
• Ability of competition to waive room rental with companies
overnight accommodations • Partner with Compass/FLIK on referral programs
• Limited quantity of hotel guest rooms due to Hilton for future business
Honors Program • Addition of"Wedding Wire", new online website
• Long standing competitor completes major for brides
renovation&changes hotel flag to Marriott • Joint advertising effort with Embassy Suites,
® More wedding venues openings around area Country Inn&Suites and Crowne Plaza
Earle Brown Heritage Center 2013 Marketing Plan pg. 2
21
i
i
MARKETING OBJECTIVES:
• To continue development of brand recognition of our product
• To catch people's eye: one-of-a-kind facility
• To develop and retain new business
• To correct impressions: no horses or museum
• To compete with other facilities in the market place
• To provide positive identification of Brooklyn Center
• To solicit our facility as a corporate and social venue
• To continue building Metro-wide/Regional awareness of the facility
• To maximize facility bookings
• To enhance lead development for the sales departments
• To attract more Association business
CLIENT MIX AND FINANCIAL REVENUE PERCENTAGES:
(Based on 2012 events—see charts below)
#of events % of events %of total revenue
7 1.3% Consumer Show provides 3% revenue
282 54% Corporate provides 36% revenue
33 6.3% Corporate Social provides 7% revenue
42 8% Government provides 11% revenue
22 4.2% Other Social provides 5% revenue
104 20% Weddings provides 26% revenue
32 6.2% Association provides 12% revenue
522 Total Events
BUSINESS AND MARKETING DEVELOPMENT PLANS:
• Utilize targeted local and regional publications to deliver message.
• Continue to increase web site presence by purchasing enhanced listings.
• Attend strategic corporate/meetings related organizations to promote the facility and
develop new business.
• Market the facility through the on-site industry related events & partnership with
Embassy Suites.
• Attend trade shows to market the facility (i.e. Meeting Professionals International,
Midwest Society of Association Executives, Meet Minneapolis & Minneapolis Northwest
CVB, Brooklyn Center Business Association, North Hennepin Chamber of Commerce, etc.)
• Continually update the facility web site yearly as this is the as necessary
The 2013 campaign will include all of the following Directory Listings, Web Placements, Print
Ads and Trade Shows. Special events and agency fees appear following each listing.
Earle Brown Heritage Center 2013 Marketing Plan pg. 3
22
�I
i
DIRECTORY LISTINGS:
(Listings that are generally at no charge)
North Hennepin Chamber Directory (includes web address)
Brooklyn Center Resource Guide
Twin City Bridal Wedding Directory (cost included in print ad)
Business Journal—Top 25 List (currently 13t" of 25)
Midwest Society of Association Executives
Meetings Media
Minneapolis Meeting Planner Guide
Meetings and Conventions Gavel
MN Hospitality Journal
WEB SITE LISTINGS:
theKnot.com (included with ad)
TwinCityBridal.com (included with ad)
Meetingsites.net
Mywedding.com (national site)
Mytwincitieswedding.com (local site)
Mnbride.com
Weddingwire.com
Perfect Wedding Guide
meetingpages.com
meetingsfocus.com
CVent.com
Wedding Wire
PRINT AD PLACEMENTS:
Social: Perfect Wedding Guide—Full Page Ad/Three Insertions
Web Listing— Included
Circulation 50,000
TC Bridal—Half page ad/One Insertion
One Page Advertisement in the MN Bride Resource Guide
Web Page & Profile—Included
Circulation 25,000
The Knot—Full Page Ad/Two Insertions
Web Listing—Included
Pageviews—3,000,000
207 4E
Earle Brown Heritage Center 2013 Marketing Plan pg. 4
23
MN Bride Resource Guide—One Ad / Half Page Insertions
Web Listing— Included
Circulation—50,000
Corporate: MN Meetings & Events—Three Half Page Ads/Co-Branding
One Full Page Ad—Co-Branding
MN Meetings & Events online Ad & Email Blast Included
MSAE—four color ad—half page insertion
Meeting Pages—four color ad—half page insertion
MN Hospitality Journal —four color ad —third page insertion
MSAE Resource Guide
TRADE SHOW EXHIBITING:
January 13—Twin City Bridal Show (Minneapolis Convention Center)
February 24—Perfect Wedding Guide Bridal Show (IMS)
March 10—Twin City Bridal Show (Minneapolis Convention Center)
June 6—Midwest Society of Association Executives Annual Meeting and Expo
October 6—Unveiled (Minneapolis Convention Center)
October 13—Twin City Bridal Show (Minneapolis Convention Center)
October 27—PWG/Earle Brown Heritage Center Wedding Show
Executive Tastings/Hosted (1 per year) and Bridal Tastings (3 per year)
2013 Marketing Budget:
The advertising, public relations and web site focus are all budgeted. Russell Herder
Advertising/Marketing Agency is charged with making the appropriate print ad placements
while working directly with the Heritage Center.
EBHC Budget figures for 2013 include:
Sales Promotion $16,000
Creative Production $39,650
VMN Guide $1,200
Co-Branded Marketing $5,000
Pay-Per-Click Campaign $22,200
Social Media $4,400
Menu Updates $3,000
Website Updates/Enhancements $10,000
Media Planning/Placements $49,735
Total 2013 Marketing/Advertising Budget $151,185.00
Earle Brown Heritage Center 2013 Marketing Plan pg. 5
49852 49853
6307
Creative $ 22,075.00 $ 16,575.00
Co-Branded Marketing $ 1,000.00 $ -
Total $ 23,075.00 $ 16,575.00 $ 39,650.00
2012 $ 20,575.00 $ 13,575.00 $ 34,150.00
6349
Media Placement $ 25,573.00 $ 24,162.00
VMN Guide $ 1,200.00 $ -
Co-Branded Marketing $ 5,000.00 $ -
Pay-Per-Click $ 11,100.00 $ 11,100.00
Social Media $ 2,200.00 $ 2,200.00
Website $ 5,000.00 $ 5,000.00
Menu Updates $ - $ 3,000.00
Sales Promotion $ 8,000.00 $ 8,000.00
Total $ 58,073.00 $ 53,462.00
2012 $ 46,273.00 $ 44,262.00
Total Budgeted $ 81,148.00 $ 70,037.00 $ 151,185.00
2012 $ 124,685.00
$ 26,500.00
24
N M O O r- O ti O t- N co O 00
"0 N r- N (D N t- L) O O 0 0 t- N O O t,
U O O Ln LO O ' M O Cl) (Y) ' 0) Cl) O
co U M r1' t� N 'V' 00 It 00 00 606 00 P- 00 a0(
U p O) N O r- O � 00 t` ti O 00
'p N O) O O ,*' O d_ N M I` O O (D tt`
W "T - N L6) Lo r
69- Eq 64 69 69 EPr 60 64 61) 69- 64 64 60 ffl 64 64 6H 69-(!,
N M M 00 t- O O) O (Y) Ln (o G O N
Cl) V' t� O L[) N (Y) t- O r- M tl- t- O I-
CY) ' T CO - O r- 0 0 O 0 0 "t co O O T
U r- L() Ni O (3 M M t� 00 O O (6 ti O O 00 00
U p r- 00 O 00 6) t- (Y) (D O (D t- 00 W O 00
•�N 00 00 r- 0) M (D Cl) N Ln 1- 00 LO (D r-
L V N Ln vi v r
0..
6R UF} 69 69 6R 63 (fl Eg 64 6f} 6f) 69 64 Qf EPr 09, 691 691 60
O Cl) 00 � 00 O C) O Nt O d' O 00 �• O Ln
-d N 00 O 00 't (3) O O N O N - O N O 00
U M ' M t� 00 d_ 't O ' Cl) O Cl) O ' ti M O et
U (fl O �• d' O M O O 00 00 606 M d• 00 Mpl
U p00 00 tl- 00 M Cl) O) LO O U) L6) 00 Ln O I-
N t` tl- O - o) M M N N It t` t` rt• O I-
d d <- (Ni Ln Ln r �t r
6q 69 60 6q HT O? (H 61} ER ER 69 69 6 T (R 69 64 64 6R EA
�- LO r- Ln It Ln O LO O LO O Lo Ln O O
-6 a) o) 00 N O d• - (Y) r- O tl- - 00 ti O r
U Lo ' N 00 L6) - 00 ti O ' N O N M ' 00 N O O
CJ Ln O O LC) 00 Ln .1 00 N O N O O N 00 M
U O 00 LT It r- I. 00 01 LO O L) - a) LO 0) LO
O N (D (D O - O N M N M t` (o CO O n
Ln Ln r d' Ln r
n v
69 69 W, 64 Eg EH EA 64 (Pr 69 69 61) 69 69 61Y 69 (Pr to H}
O O O Q) ti LO O O - O r O r O O
-6 O 0 CD M - r- LO O O O O N O O O r
U t- ' t- IT 0 0 t- (D 0 ' O Cl 0 � ' ti' O O M
U •ct (o L() N N O o0 � O r- �t r r- 00 CD
tl- N M O) It O M O 'T O r
O Lf) (fl O •- O N M c N N M M N M r
N LO Ln e-
69 6q 64 64 64 6R 69 69 69 H-) 64 69 of 64 V- 6f} 64 69 ER
O O O 00 N Cl) t- O O 0 0 O O O r
70 O O O m t0) m m O M 0 (l) O O M O N
Cl) M ' r Cl) N '�t O CO Lq ' O d) ' M r LO h
N M O M O d LC) Ln O Lr) �!- O LO LO
p_p 00 00 Co O (fl 00 M O M N 00 M 00 CD
O N V' d: O c- d7 r O (A N (o It - O W
n d d N 14 Ln c- V7 v r
69 61)- EA EH 61} 61Y EA 61Y U? Ef3 EPr 64 Vf U)- 64 (Pr Vf 6R vil
N I` 6) Cl) d• O •d• LO LO O LO N 0) L!) Lo r
O co O O N oo tl- 00 O 00 M M 00 t` co
O M Lo M O M ' O O O) 00 ' tl_ O Cl) a)
LL 6) O M t� P- V• L) O O O O N O O O e
'3
p O N r 00 N N M 00 O 00 M tl_ 00 (O N
.c N N N O - 00 - O t` N O O N O (o (D
U m d d• N d d <- d dam' r N
U (A ER Ei} 61!} 64 61) (Pr 60- 61Y 61) Eg 69 6R W, 6q 01} 6- 0}Efl
L T
L
+' G7 M Cl) LP) 'It 't Ln O M O r- r- (D 00 6) LO (D O N
M (() 00 00 U) r 00 M 00 L6) M O NT N t- 00 d• 00 M fl-
L tl- Lt) - cp 00 .- LO N d• L() M LO N N 00 It N d• 00
U O
00 N O N cr t� Ln N M N M (3) t� 0) N A N N \°
N
= U �t (D r N Co 0) 00 M M M t` Ln M A N L6) M (D
d Q N O .- O r tom• O O O It O O CD c
U r d d N d V d r N 00
>= N 69 6Y} fA ER 69 6R 6)- 64 6A (Pr 6'v<fl 6Pr (Pr 69 6H EA 69 to L U 0
0 c 00 0) 00 O LO 'd• r- 't It d• N o) �' r 00 .� Ln M M
o 3: O Co N CO M N r- O M (D 00 N O M N U) - - O
o M ' � �- LO t- t- LO M I ' It O (o t- Ct 00 N (6 U (D N N
m j O M O r 00 Ili M O O � Ln M O 00 h m U N Lo
4- (� O M Cl) Ln CO - Ln N O a) M d• M O N 00 L O L LO
0 U N 00 00 00 - ti 6) M N N � Qo N M O) rn L (0 O
> L Q M M r- d' C U a0 >,N N
U W ER ElJ (fl 61)- 64 EA 64 69 64 Eg 64 Efl 6fl 6H 6, 6q 6A UY 6A c p U N M
o N a i 0,
U c o a) L
a) m(r) a U
�+ (� :3 o a
G C a) OL o
U
c (t3 U V +�' U LO
0)
a)
a�i a -a c n Q cn s o o Z N
aa) aL) a o > w Ln C7 m (n a " °) u, a�i o U U) E cii o 0
� -a •- c
U (B X F-• L6 c CL !Q (6 N N
c o O Z c o •°� v o c W V c 0) c c U a a N c c •� v
C) U () U cn a _ - L � w c c a) a) N - 7 = (n U O Q.
> (n ( a L a Z N a= - a ;° 0) (>3 > p_ a'O N N M > �' a
� U � F° wai) U) C)0 �-° C) mUww0w Q UQ ma (nco
25
I
2013 Brooklyn Center Department Budget Narrative b Fund
Y P g Y
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 2012 2013 2014
• Liquor Operations Manager 1 1 1
• Liquor Store Manager 2 2 2
• Liquor Store Assistant Manager 0 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
26
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 a local brewery eve
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 of the display racking in the large refrigerated storage in Store # 1.
Expected Cost of$ 38,000.
27
i
SUMMARY
2009 2010 2011 October YTD 2012 2013 2014
Object Description Actual Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Amount Actual Budget Budget Budget
60900-BROOKLYN CENTER LIQUOR
4000 REVENUES AND EXPENSES
4001 REVENUES
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4603 INTEREST EARNINGS -14,897 -6,454 -9,782 -4,786 -6,000 -6,000 -6,000
4605 UNREALIZED INVESTMENT GAIN/LOSS -485 3,805 -2,774 0
4606 OTHER REVENUE -1,500 -1,500 -2,000 -2,000 -1,500 -1,500 -1,500
4600 MISCELLANEOUS REVENUE -16,882 -4,148 -14,556 -6,786 -7,500 -7,500 -7,500
4599 MISCELLANEOUS REVENUE -16,882 -4,148 -14,556 -6,786 -7,500 -7,500 -7,500
4760 LIQUOR STORE OPERATIONS
4761 LIQUOR SALES -2,081,625 -2,029,345 -2,146,923 -1,603,476 -2,184,674 -2,220,454 -2,259,730
4762 WINE SALES -636,260 -674,030 -777,332 -562,140 -870,223 -847,565 -885,127
4763 BEER SALES -2,718,373 -2,682,176 -2,708,265 -1,940,344 -2,576,306 -2,563,148 -2,529,561
4764 SALES-NON TAXABLE -82,488 -66,032 -68,785 -49,647 -56,608 -64,928 -64,516
4765 SALES-TAXABLE -91,362 -91,444 -88,021 -63,571 -88,439 -86,891 -86,344
4760 LIQUOR STORE OPERATIONS -5,610,108 -5,543,027 -5,789,346 -4,219,181 -5,776,250 -5,782,986 -5,825,278
4900 OTHER FINANCING SOURCES
4921 REFUNDS&REIMBURSEMENTS -2,835 -216 -2,000 -1,712 -2,000
4922 PROJECT ADMINISTRATION -4,008 -3,412 -2,875 -2,913 -2,500 -4,500 -4,500
4900 OTHER FINANCING SOURCES -6,843 -3,628 -4,875 -4,625 -4,500 -4,500 -4,500
5550 DIRECT COST OF SALES
5560 COST OF GOODS SOLD
5581 COST OF SALES-LIQUOR 1,420,855 1,376,800 1,464,299 1,100,574 1,482,082 1,532,113 1,559,212
5582 COST OF SALES-WINE 442,269 462,461 516,023 361,480 585,486 563,594 588,608
5583 COST OF SALES-BEER 2,068,467 2,038,094 2,064,962 1,466,509 1,963,402 1,973,623 1,947,761
5584 OTHER COSTS OF SALE-NON TAX 51,608 38,926 40,452 30,515 36,794 41,553 41,290
5582 OTHER COST OF SALES-TAX 65,646 62,545 59,544 41,521 57,485 55,610 55,260
5587 INVENTORY VARIANCES 15,526 8,132 4,776 14,986 14,000 17,000 17,000
5589 DELIVERY CHARGES 23,907 22,794 25,849 17,051 23,800 23,800 23,800
5580 COST OF GOODS SOLD 4,088,278 4,009,751 4,175,906 3,052,635 4,163,049 4,207,293 4,232,931
5550 DIRECT COST OF SALES 4,086,278 4,009,751 4,175,906 3,052,635 4,163,049 4,207,293 4,232,931
4001 REVENUES -1,545,556 -1,541,052 -1,632,872 -1,177,957 -1,625,201 -1,587,693 -1,604,347
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 279,294 265,313 243,453 190,146 251,000 295,831 297,831
6103 WAGES-PART TIME EMPLOYEES 218,350 219,884 231,774 180,764 228,000 240,000 240,000
6104 OVERTIME-PART TIME EMPLOYEES 5,254 2,985 3,252 3,554 4,500 4,000 4,000
6100 WAGES AND SALARIES 502,898 488,182 476,479 374,464 483,500 539,831 541,831
6110 OTHER PAYMENTS-NON INSURANCE
6111 SEVERANCE 4,984 3,482 2,315 0
6110 OTHER PAYMENTS-NON INSURANCE 4,984 3,482 2,315 0
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 32,719 32,960 33,820 26,519 34,000 38,903 38,903
6125 FICA 32,203 31,173 30,438 23,688 31,000 33,270 33,270
6126 MEDICARE CONTRIBUTIONS 7,531 7,290 7,118 5,540 7,350 7,780 7,780
6120 RETIREMENT CONTRIBUTIONS 72,454 71,423 71,377 55,748 72,350 79,953 79,953
6130 INSURANCE BENEFITS
6131 CAFETERIA PLAN CONTRIBUTIONS 40,767 42,114 34,108 22,971 43,152 56,340 56,340
6130 INSURANCE BENEFITS 40,767 42,114 34,108 22,971 43,152 56,340 56,340
6140 UNEMPLOYMENT COMPENSATION
6141 UNEMPOLOYMENT COMPENSATION 1,414 716 701 0 0 0
6140 UNEMPLOYMENT COMPENSATION 1,414 716 701 0 0 0
6150 WORKERS'COMPENSATION
28
JI
I
SUMMARY
2009 2010 2011 October YTD 2012 2013 2014
Object Description Actual Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Amount Actual Budget Budget Budget
6151 WORKERS'COMPENSATION� 12,278 12,263 10,524 8,381 11,394 9,918 9,953
6150 WORKER'S COMPENSATION 12,278 12,263 10,524 8,381 11,394 9,918 9,953
6099 PERSONAL SERVICES 634,795 618,180 597,503 461,564 610,396 686,042 688,077
6199 SUPPLIES
6200 OFFICE SUPPLIES
6201 OFFICE SUPPIES 1,672 829 809 317 1,400 1,400 1,400
6202 COPYING SUPPLIES 0 80 0 0 0 j
6200 OFFICE SUPPLIES 1,672 908 809 317 1,400 1,400 1,400
6210 OPERATING SUPPLIES
6214 CLOTHING&PERSONAL EQUIPMENT 1,514 304 1,426 877 1,500 1,500 1,500
6219 GENERAL OPERATING SUPPLIES 12,971 10,550 18,578 11,328 15,500 16,000 16,000
6210 OPERATING SUPPLIES 14,486 10,854 20,003 12,205 17,000 17,500 17,500
6220 REPAIR&MAINT SUPPLIES
6223 BUILDINGS&FACILITIES 1,805 0 0 0 2,500 2,500 2,500
6220 REPAIR&MAINT SUPPLIES 1,805 0 0 0 2,500 2,500 2,500
6230 REPAIR&MAINT SUPPLIES-OTHER
6237 LAUNDRY SUPPLIES 0 30 0 0
6230 REPAIR&MAINT SUPPLIES-OTHER 0 30 0 0
6240 SMALL TOOLS&MINOR EQUIPMENT
6242 MINOR EQUIPMENT 5,821 8,937 364 1,750 7,500 10,588 5,500
6243 MINOR COMPUTER EQUIPMENT 10,885 21,936 1,407 31,130 19,450 62,625 34,000
6240 SMALL TOOLS&MINOR EQUIPMENT 16,707 30,873 1,771 32,881 26,950 73,213 39,500
6199 SUPPLIES 34,669 42,665 22,584 45,403 47,850 94,613 60,900
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6301 ACCTG,AUDIT&FIN'L SERVICES 4,495 4,377 4,906 3,985 5,000 5,000 5,000
6303 LEGAL SERVICES 251 259 0 0 0
6307 PROFESSIONAL SERVICES 17,232 3,085 4,504 6,583 6,300 8,200 8,200
6300 PROFESSIONAL SERVICES 21,978 7,722 9,410 10,568 11,300 13,200 13,200
6320 COMMUNICATIONS
6321 TELEPHONES/PAGES 5,226 4,397 3,507 2,724 3,880 3,720 3,720
6329 OTHER COMMUNICATION SERVICES 859 672 850 900 945
6320 COMMUNICATIONS 5,226 4,397 4,365 3,396 4,730 4,620 4,665
6330 TRANSPORTATION
6331 TRAVEL EXPENSE/MILEAGE 858 546 1,019 644 1,150 1,300 1,300
6330 TRANSPORTATION 858 546 1,019 644 1,150 1,300 1,300
6340 ADVERTISING
6341 PERSONNEL ADVERTISING 264 0 142 130 800 700 700
6349 OTHER ADVERTISING 19,060 14,456 12,315 8,550 17,500 16,000 16,000
6340 ADVERTISING 19,324 14,456 12,457 8,680 18,300 16,700 16,700
6350 PRINTING AND DUPLICATING
6351 PRINTING 774 442 0 0 700 500 5001.
6350 PRINTING AND DUPLICATING 774 442 0 0 700 500 500
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 852 994 977 903 1,200 1,470 1,572
6362 PROPERTY INSURANCE 1,475 1,516 1,433 1,494 1,750 2,397 2,565
6364 DRAM SHOP INSURANCE 7,628 6,977 5,994 5,368 7,323 8,595 9,218
6366 MACHINERY BREAKDOWN INSURANCE 380 370 369 401 450 650 687
6360 INSURANCE 10,336 9,858 8,773 8,165 10,723 13,112 14,042
6380 UTILITY SERVICES
6381 ELECTRIC 31,492 32,268 34,663 27,436 34,000 35,000 36,000
6382 GAS 6,375 6,095 5,786 3,687 6,800 6,500 6,500
6383 WATER 0 7,200 7,200 '..
29
SUMMARY
2009 2010 2011 October YTD 2012 2013 2014
Object Description Actual Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Amount Actual Budget Budget Budget
6380 UTILITY SERVICES 37,867 38,363 40,451 31,123 40,800 48,700 49,700
6400 REPAIR&MAINT SERVICES
6402 EQUIPMENT SERVICES 2,680 6,872 5,355 1,354 7,000 7,000 7,000
6403 BLDGS/FACILITIES MAINT SERVICE 5,119 5,495 1,132 1,711 6,500 4,000 4,000
6406 MULTI-FUNCTION MTNCE 186 171 500 625 690
6409 OTHER REPAIR&MAINT SERVICES 0 0 0 295 1,000 1,000
6400 REPAIR&MAINT SERVICES 7,798 12,367 6,674 3,530 14,000 12,625 12,690
6410 RENTALS
6412 BLDGS/FACILITIES 269,969 287,687 293,265 248,887 289,140 289,640 289,640
6410 RENTALS 269,969 287,687 293,265 248,887 289,140 289,640 289,640
6420 IS SERVICES/LICENSES/FEES
6421 SOFTWARE LICENSE 440 509 294 0 0
6422 SOFTWARE MAINT 961 2,740 1,399 6,867 2,815 9,100 9,100
6423 LOGIS CHARGES 13,880 12,951 13,480 12,586 16,635 18,546 19,154
6428 PROTECTION SERVICES 1,385 1,342 969 763
6420 IS SERVICES/LICENSES/FEES 16,667 17,542 16,141 20,218 19,450 27,646 28,254
6430 MISCELLANEOUS
6431 SPECIAL EVENTS 7,320 8,030 8,716 4,747 8,000 8,500 8,500
6432 CONFERENCES AND SCHOOLS 1,485 1,790 1,310 2,257 3,100 2,800 2,800
6434 DUES&SUBSCRIPTIONS 3,225 3,006 3,290 2,514 3,300 3,500 3,500
6435 CREDIT CARD FEES 70,201 76,678 80,585 63,767 85,000 87,000 90,000
6436 UNCOLLECTIBLE CHECKS/DEBTS 100 0 0 0
6438 CASH SHORT(OVER) 2,383 1,832 3,611 1,203 2,000 2,000 2,000
6430 MISCELLANEOUS 84,614 91,436 97,512 74,487 101,400 103,800 106,800
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 248 60 40 20 300 1,200 1,200
6442 COURT AWARDS/SETTLEMENTS 3,214 0 0 0 0
6449 OTHER CONTRACTUAL SERVICES 6,872 5,275 4,961 3,786 5,000 5,100 5,100
6440 OTHER EXPENSES 10,334 5,335 5,001 3,806 5,300 6,300 6,300
6460 CENTRAL GARAGE CHARGES
6461 FUEL CHARGES 241 245 180 192 300 206 216
6462 FIXED CHARGES 1,072 1,087 1,073 796 1,200 1,120 1,154
6463 REPAIR&MAINT CHARGES 484 140 0 90 1,000 1,050 1,104
6465 REPLACEMENT CHARGES 2,251 2,207 2,229 1,396 2,200 2,100 2,398
6460 CENTRAL GARAGE CHARGES 4,048 3,679 3,481 2,473 4,700 4,476 4,872
I
6470 TRANSFERS AND OTHER USES j
6471 ADMINISTRATIVE SERVICE TRANSFER 53,546 73,689 74,298 47,057 75,000 61,424 62,855
6476 CAPITAL PROJECT FUND TRANSFER 265,490 230,199 135,000 0 200,000 200,000 200,000
6482 MISC TRANSFER OUT 12,488 0
6470 TRANSFERS AND OTHER USES 319,036 303,888 221,786 47,057 275,000 261,424 262,855
I
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 26,359 18,066 11,281 8,484 24,000 13,425 14,075
6490 OTHER MISC COSTS/EXPENSES 26,359 18,066 11,281 8,484 24,000 13,425 14,075
6299 OTHER CHARGES&SERVICES 835,188 815,781 731,617 471,519 820,693 817,468 825,593
6500 CAPITAL OUTLAY
6501 CAPITAL OUTLAY
6530 IMPROVEMENTS 3,548 0 0
6540 EQUIPMENT&MACHINERY 4,957 6,753 10,279 96,040 138,600 38,000 0
6501 CAPITAL OUTLAY 4,957 10,301 10,279 96,040 138,600 38,000 0
I
6500 CAPITAL OUTLAY 4,957 10,301 10,279 96,040 138,600 38,000 0
6001 EXPENDITURES/EXPENSES 1,509,609 1,486,927 1,361,983 1,074,526 1,617,539 1,636,123 1,574,570
4000 REVENUES AND EXPENSES -35,947 -54,124 -270,888 -103,432 -7,662 48,430 -29,777
60900-BROOKLYN CENTER LIQUOR -35,947 -54,124 -270,888 -103,432 -7,662 48,430 -29,777
30
STORE # 1
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
60900-BROOKLYN CENTER LIQUOR
49611-BROOKLYN CENTER LIQUOR
4000 REVENUES AND EXPENSES
4001 REVENUES
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4603 INTEREST EARNINGS -3,227 -4,891 -2,393 -3,000 -3,000 -3,000
4605 UNREALIZED INVESTMENT GAIN/LOSS 1,903 -1,387 0
4606 OTHER REVENUE -1,500 -2,000 -1,500 -1,500 -1,500 -1,500
4600 MISCELLANEOUS REVENUE -2,824 -8,278 -3,893 -4,500 -4,500 -4,500
4599 MISCELLANEOUS REVENUE -2,824 -8,278 -3,893 -4,500 -4,500 -4,500
4760 LIQUOR STORE OPERATIONS
4761 LIQUOR SALES -1,497,048 -1,577,629 -1,226,006 -1,652,324 -1,673,706 -1,723,917
4762 WINE SALES -467,331 -550,371 -404,984 -629,841 -606,783 -637,121
4763 BEER SALES -1,775,160 -1,783,997 -1,402,071 -1,855,479 -1,856,069 -1,893,190
4764 SALES-NON TAXABLE -45,510 -47,328 -34,087 -37,576 -44,322 -44,322
4765 SALES-TAXABLE -61,675 -59,525 -44,338 -59,675 -59,525 -59,525
4760 LIQUOR STORE OPERATIONS -3,846,725 -4,018,850 -3,111,487 -4,234,895 -4,240,405 -4,358,075
4900 OTHER FINANCING SOURCES
4921 REFUNDS&REIMBURSEMENTS -216 -2,000 -1,696 -2,000
4922 PROJECT ADMINISTRATION -3,412 -2,875 -2,913 -2,500 -4,500 -4,500
4900 OTHER FINANCING SOURCES -3,628 -4,875 -4,609 -4,500 -4,500 -4,500
5550 DIRECT COST OF SALES
5580 COST OF GOODS SOLD
5581 COST OF SALES-LIQUOR 1,009,446 991,395 788,456 1,120,936 1,154,857 1,189,502
5582 COST OF SALES-WINE 317,896 343,081 263,911 423,757 403,510 423,685
5583 COST OF SALES-BEER 1,319,157 1,369,643 1,098,588 1,414,060 1,429,173 1,457,756
5584 OTHER COSTS OF SALE-NON TAX 26,998 25,032 18,578 24,424 28,366 28,366
5582 OTHER COST OF SALES-TAX 41,948 38,392 28,626 38,789 38,096 38,096
5587 INVENTORY VARIANCES 6,591 1,771 11,175 10,000 12,000 12,000
5589 DELIVERY CHARGES 17,102 19,764 13,079 18,000 18,000 18,000
5580 COST OF GOODS SOLD 2,739,138 2,789,076 2,222,413 3,049,966 3,084,002 3,167,405
5550 DIRECT COST OF SALES 2,739,138 2,789,076 2,222,413 3,049,966 3,084,002 3,167,405
4001 REVENUES -1,114,038 -1,242,927 -897,576 -1,193,929 -1,165,403 -1,199,670
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 184,886 171,135 134,616 175,000 211,712 211,712
6103 WAGES-PART TIME EMPLOYEES 148,407 153,101 115,698 160,000 168,000 168,000
6104 OVERTIME-PART TIME EMPLOYEES 1,530 1,834 5,274 2,500 2,500 2,500
6100 WAGES AND SALARIES 334,823 326,070 255,587 337,500 382,212 382,212
6110 OTHER PAYMENTS-NON INSURANCE
6111 SEVERANCE 2,208 1,362 0
6110 OTHER PAYMENTS-NON INSURANCE 2,208 1,362 0
i
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 22,457 22,874 18,040 23,000 27,529 27,529
6125 FICA 21,191 20,601 16,093 21,000 23,542 23,542
6126 MEDICARE CONTRIBUTIONS 4,956 4,819 3,763 5,000 5,506 5,506
6120 RETIREMENT CONTRIBUTIONS 48,603 48,294 37,896 49,000 56,577 56,577
31
STORE # 1
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 SeptemberYTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6130 INSURANCE BENEFITS
6131 CAFETERIA PLAN CONTRIBUTIONS 36,438 28,660 18,479 32,364 33,804 33,804
6130 INSURANCE BENEFITS 36,438 28,660 18,479 32,364 33,804 33,804
6140 UNEMPLOYMENT COMPENSATION
6141 UNEMPOLOYMENT COMPENSATION 716 701 0 0 0
6140 UNEMPLOYMENT COMPENSATION 716 701 0 0 0
6150 WORKERS'COMPENSATION
6151 WORKERS'COMPENSATION 8,414 7,100 5,610 7,794 8,126 8,126
6150 WORKER'S COMPENSATION 8,414 7,100 5,610 7,794 8,126 8,126
6099 PERSONAL SERVICES 431,202 412,187 317,572 426,658 480,719 480,719
6199 SUPPLIES
6200 OFFICE SUPPLIES
6201 OFFICE SUPPIES 572 570 227 1,000 1,000 1,000
6202 COPYING SUPPLIES 80 0 0 0
6200 OFFICE SUPPLIES 652 570 227 1,000 1,000 1,000
6210 OPERATING SUPPLIES
6214 CLOTHING&PERSONAL EQUIPMENT 304 1,086 614 1,000 1,000 1,000
6219 GENERAL OPERATING SUPPLIES 7,731 10,606 8,175 11,000 11,000 11,000
6210 OPERATING SUPPLIES 8,035 11,692 8,789 12,000 12,000 12,000
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 30 0 0
6230 REPAIR&MAINT SUPPLIES-OTHER 30 0 0
6240 SMALL TOOLS&MINOR EQUIPMENT
6242 MINOR EQUIPMENT 8,597 364 1,696 7,000 10,088 5,000
6243 MINOR COMPUTER EQUIPMENT 12,657 1,016 19,531 16,715 31,750 18,000
6240 SMALL TOOLS&MINOR EQUIPMENT 21,254 1,380 21,227 23,715 41,838 23,000
6199 SUPPLIES 29,971 13,641 30,243 38,715 56,838 38,000
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6301 ACCTG,AUDIT&FIN'L SERVICES 4,377 4,906 3,985 5,000 5,000 5,000
6303 LEGAL SERVICES 259 0 0 0
6307 PROFESSIONAL SERVICES 1,936 2,791 5,823 5,000 7,000 7,000
6300 PROFESSIONAL SERVICES 6,572 7,697 9,808 10,000 12,000 12,000
6320 COMMUNICATIONS
6321 TELEPHONES/PAGES 2,123 2,049 1,447 2,330 2,220 2,220
6320 COMMUNICATIONS 2,123 2,049 1,447 2,330 2,220 2,220
6330 TRANSPORTATION
6331 TRAVEL EXPENSE/MILEAGE 497 675 553 750 1,000 1,000
6330 TRANSPORTATION 497 675 553 750 1,000 1,000
6340 ADVERTISING
6341 PERSONNEL ADVERTISING 0 0 130 500 500 500
6349 OTHER ADVERTISING 10,678 8,309 5,575 12,500 10,000 10,000
32 j
STORE # 1
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object f Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6340 ADVERTISING 10,678 8,309 5,705 13,000 10,500 10,500
6350 PRINTING AND DUPLICATING
6351 PRINTING 442 0 0 500 500 500
6350 PRINTING AND DUPLICATING 442 0 0 500 500 500
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 408 387 451 600 735 786
6362 PROPERTY INSURANCE 362 309 802 600 1,287 1,377
6364 DRAM SHOP INSURANCE 4,906 4,228 3,985 5,200 6,395 6,843
6366 MACHINERY BREAKDOWN INSURANCE 89 78 216 150 350 370
6360 INSURANCE 5,765 5,002 5,454 6,550 8,767 9,376
I
6380 UTILITY SERVICES
6381 ELECTRIC 16,122 16,918 10,857 17,000 17,000 17,000
6382 GAS 3,403 3,370 1,814 3,800 3,500 3,500
6380 UTILITY SERVICES 19,526 20,288 12,671 20,800 20,500 20,500
6400 REPAIR&MAINT SERVICES
6402 EQUIPMENT SERVICES 6,068 5,231 358 5,000 5,000 5,000
6403 BLDGS/FACILITIES MAINT SERVICE 3,842 767 1,559 5,000 3,000 3,000
6406 MULTI-FUNCTION MTNCE 186 161 500 500 550
6409 OTHER REPAIR&MAINT SERVICES 0 0 295 1,000 1,000
6400 REPAIR&MAINT SERVICES 9,910 6,184 2,373 10,500 9,500 9,550
i
6410 RENTALS
i
6412 BLDGS/FACILITIES 194,327 198,405 155,214 195,780 195,780 195,780
6410 RENTALS 194,327 198,405 155,214 195,780 195,780 195,780
6420 IS SERVICES/LICENSES/FEES
6421 SOFTWARE LICENSE 382 294 0 0
6422 SOFTWARE MAINT 1,838 1,006 4,729 1,900 6,300 6,300
6423 LOGIS CHARGES 10,752 9,350 9,063 11,644 12,982 13,408
6428 PROTECTION SERVICES 751 534 407
6420 IS SERVICES/LICENSES/FEES 13,723 11,183 14,199 13,544 19,282 19,708
6430 MISCELLANEOUS
6431 SPECIAL EVENTS 8,030 8,716 4,747 8,000 8,500 8,500
6432 CONFERENCES AND SCHOOLS 1,469 939 1,234 2,500 2,200 2,200
6434 DUES&SUBSCRIPTIONS 2,119 2,287 1,764 2,500 2,500 2,500
6435 CREDIT CARD FEES 52,988 57,826 46,097 60,000 62,000 64,000
6436 UNCOLLECTIBLE CHECKS/DEBTS 100 0 0 0
6438 CASH SHORT(OVER) 570 863 724 1,000 1,000 1,000
6430 MISCELLANEOUS 65,276 70,631 54,565 74,000 76,200 78,200
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 20 20 0 200 200 200
6442 COURT AWARDS/SETTLEMENTS 0 0 0
6449 OTHER CONTRACTUAL SERVICES 2,452 2,304 1,807 2,500 2,500 2,500
6440 OTHER EXPENSES 2,472 2,324 1,807 2,700 2,700 2,700
6460 CENTRAL GARAGE CHARGES
6461 FUEL CHARGES 122 90 96 150 103 108
6462 FIXED CHARGES 543 536 398 600 560 577
6463 REPAIR&MAINT CHARGES 70 0 45 500 525 552
6465 REPLACEMENT CHARGES 1,103 1,114 698 1,100 1,050 1,199
6460 CENTRAL GARAGE CHARGES 1,839 1,740 1,237 2,350 2,238 2,436
6470 TRANSFERS AND OTHER USES 33
STORE # 1
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6471 ADMINISTRATIVE SERVICE TRANSFER 46,670 49,557 31,387 50,000 40,970 41,790
6476 CAPITAL PROJECT FUND TRANSFER 230,199 135,000 0 200,000 200,000 200,000
6482 MISC TRANSFER OUT 12,488 0
6470 TRANSFERS AND OTHER USES 276,869 197,045 31,387 250,000 240,970 241,790
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 17,122 6,417 4,826 19,000 8,550 9,200
6490 OTHER MISC COSTS/EXPENSES 17,122 6,417 4,826 19,000 8,550 9,200
6299 OTHER CHARGES&SERVICES 627,140 537,951 301,246 621,804 610,707 615,460
6500 CAPITAL OUTLAY
6501 CAPITAL OUTLAY
6530 IMPROVEMENTS 3,548 0 0
6540 EQUIPMENT&MACHINERY 6,753 10,279 96,040 138,600 38,000 0
6501 CAPITAL OUTLAY 10,301 10,279 96,040 138,600 38,000 0
6500 CAPITAL OUTLAY 10,301 10,279 96,040 138,600 38,000 0
6001 EXPENDITURES/EXPENSES 1,098,614 974,059 745,101 1,225,777 1,186,264 1,134,179
4000 REVENUES AND EXPENSES -15,424 -268,869 -152,475 31,848 20,861 -65,491
49611 -BROOKLYN CENTER LIQUOR -15,424 -268,869 -152,475 31,848 20,861 -65,491
Total 60900-BROOKLYN CENTER LIQUOR -15,424 -268,869 -152,475 31,848 20,861 -65,491
34
STORE # 2
CITY OF BROOKLYN CENTER !
Budget Report
2010 2011 SeptemberYTD 2012 2013 2014
Object/Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
60900-BROOKLYN CENTER LIQUOR
49612-69TH AVENUE LIQUOR STORE
4000 REVENUES AND EXPENSES
4001 REVENUES
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4603 INTEREST EARNINGS -3,227 -4,891 -2,393 -3,000 -3,000 -3,000
4605 UNREALIZED INVESTMENT GAIN/LOSS 1,903 -1,387 0
4600 MISCELLANEOUS REVENUE -1,324 -6,278 -2,393 -3,000 -3,000 -3,000
4599 MISCELLANEOUS REVENUE -1,324 -6,278 -2,393 -3,000 -3,000 -3,000
4760 LIQUOR STORE OPERATIONS
4761 LIQUOR SALES -532,297 -569,294 -377,472 -532,350 -546,748 -535,813
4762 WINE SALES -206,698 -226,961 -157,157 -240,382 -240,782 -248,006
4763 BEER SALES -907,016 -924,288 -538,273 -720,827 -707,079 -636,371
4764 SALES-NON TAXABLE -20,521 -21,456 -15,560 -19,032 -20,606 -20,194
4765 SALES-TAXABLE -29,769 -28,496 -19,233 -28,764 -27,366 -26,819
4760 LIQUOR STORE OPERATIONS -1,696,302 -1,770,496 -1,107,694 -1,541,355 -1,542,581 -1,467,203
4900 OTHER FINANCING SOURCES
4921 REFUNDS&REIMBURSEMENTS 0 0 -16 0
4900 OTHER FINANCING SOURCES 0 0 -16 0
5550 DIRECT COST OF SALES
5580 COST OF GOODS SOLD
5581 COST OF SALES-LIQUOR 367,354 472,904 312,118 361,146 377,256 369,710
5582 COST OF SALES-WINE 144,565 172,943 117,568 161,729 160,084 164,923
5583 COST OF SALES-BEER 718,937 695,319 367,921 549,342 544,450 490,005
5584 OTHER COSTS OF SALE-NON TAX 11,928 15,420 11,937 12,370 13,187 12,924
5582 OTHER COST OF SALES-TAX 20,598 21,152 12,895 18,696 17,514 17,164
5587 INVENTORY VARIANCES 1,541 3,006 3,810 4,000 5,000 5,000
5589 DELIVERY CHARGES 5,692 6,085 3,848 5,800 5,800 5,800
5580 COST OF GOODS SOLD 1,270,613 1,386,829 830,099 1,113,083 1,123,291 1,065,526
5550 DIRECT COST OF SALES 1,270,613 1,386,829 830,099 1,113,083 1,123,291 1,065,526
4001 REVENUES -427,014 -389,944 -280,005 -431,272 -422,290 -404,677
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 80,427 72,319 50,776 76,000 84,119 86,119
6103 WAGES-PART TIME EMPLOYEES 71,477 78,673 57,354 68,000 72,000 72,000
6104 OVERTIME-PART TIME EMPLOYEES 1,455 1,417 1,341 2,000 1,500 1,500
6100 WAGES AND SALARIES 153,359 152,409 109,471 146,000 157,619 159,619
6110 OTHER PAYMENTS-NON INSURANCE
6111 SEVERANCE 1,274 954 0
6110 OTHER PAYMENTS-NON INSURANCE 1,274 954 0
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 10,503 10,946 7,815 11,000 11,374 11,374
6125 FICA 9,982 9,837 7,000 10,000 9,728 9,728
6126 MEDICARE CONTRIBUTIONS 2,334 2,300 1,638 2,350 2,274 2,274
6120 RETIREMENT CONTRIBUTIONS 22,820 23,083 16,452 23,350 23,376 23,376
6130 INSURANCE BENEFITS
6131 CAFETERIA PLAN CONTRIBUTIONS 5,676 35 5,447 3,196 10,788 22,536 22,536
STORE # 2
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object I Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6130 INSURANCE BENEFITS 5,676 5,447 3,196 10,788 22,536 22,536
6140 UNEMPLOYMENT COMPENSATION
6150 WORKERS'COMPENSATION
6151 WORKERS'COMPENSATION 3,849 3,424 2,557 3,600 1,792 1,827
6150 WORKER'S COMPENSATION 3,849 3,424 2,557 3,600 1,792 1,827
6099 PERSONAL SERVICES 186,978 185,317 131,677 183,738 205,323 207,358
6199 SUPPLIES
6200 OFFICE SUPPLIES
6201 OFFICE SUPPIES 256 240 90 400 400 400
6202 COPYING SUPPLIES 0 0 0 0
6200 OFFICE SUPPLIES 256 240 90 400 400 400
6210 OPERATING SUPPLIES
6214 CLOTHING&PERSONAL EQUIPMENT 0 340 263 500 500 500
6219 GENERAL OPERATING SUPPLIES 2,819 7,972 2,569 4,500 5,000 5,000
6210 OPERATING SUPPLIES 2,819 8,312 2,832 5,000 5,500 5,500
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 340 0 54 500 500 500
6243 MINOR COMPUTER EQUIPMENT 9,279 391 1,083 2,735 30,875 16,000
6240 SMALL TOOLS&MINOR EQUIPMENT 9,619 391 1,137 3,235 31,375 16,500
6199 SUPPLIES 12,694 8,942 4,060 9,135 37,775 22,900
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6307 PROFESSIONAL SERVICES 1,150 1,713 760 1,300 1,200 1,200
6300 PROFESSIONAL SERVICES 1,150 1,713 760 1,300 1,200 1,200
6320 COMMUNICATIONS
6321 TELEPHONES/PAGES 2,274 1,457 974 1,550 1,500 1,500
6329 OTHER COMMUNICATION SERVICES 859 672 850 900 945
6320 COMMUNICATIONS 2,274 2,316 1,646 2,400 2,400 2,445
6330 TRANSPORTATION
6331 TRAVEL EXPENSE/MILEAGE 49 344 91 400 300 300
6330 TRANSPORTATION 49 344 91 400 300 300
6340 ADVERTISING
6341 PERSONNEL ADVERTISING 0 142 0 300 200 200
6349 OTHER ADVERTISING 3,777 4,006 2,975 5,000 6,000 6,000
6340 ADVERTISING 3,777 4,148 2,975 5,300 6,200 6,200
6350 PRINTING AND DUPLICATING
6351 PRINTING 0 0 0 200
6350 PRINTING AND DUPLICATING 0 0 0 200
6360 INSURANCE
6361 GENERAL LIABILITY INSURANCE 586 590 451 600 735 786
6362 PROPERTY INSURANCE 1,154 1,124 692 1,150 1,110 1,188
6364 DRAM SHOP INSURANCE 2,072 36 1,766 1,383 2,123 2,200 2,375
STORE # 2
i
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6366 MACHINERY BREAKDOWN INSURANCE 282 290 185 300 300 317
6360 INSURANCE 4,093 3,771 2,711 4,173 4,345 4,666
6380 UTILITY SERVICES
6381 ELECTRIC 16,145 17,745 13,699 17,000 18,000 19,000
6382 GAS 2,692 2,418 1,792 3,000 3,000 3,000
6383 WATER 7,200 7,200
6380 UTILITY SERVICES 18,837 20,162 15,491 20,000 28,200 29,200
6400 REPAIR&MAINT SERVICES
6402 EQUIPMENT SERVICES 804 124 996 2,000 2,000 2,000
6403 BLDGS/FACILITIES MAINT SERVICE 1,653 366 152 1,500 1,000 1,000
6406 MULTI-FUNCTION MTNCE 10 125 140
6400 REPAIR&MAINT SERVICES 2,457 490 1,158 3,500 3,125 3,140
6410 RENTALS
6412 BLDGS/FACILITIES 93,360 94,860 70,020 93,360 93,860 93,860
6410 RENTALS 93,360 94,860 70,020 93,360 93,860 93,860
6420 IS SERVICES/LICENSES/FEES
6421 SOFTWARE LICENSE 127 0 0 0
6422 SOFTWARE MAINT 903 393 2,138 915 2,800 2,800
6423 LOGIS CHARGES 2,199 4,130 3,969 4,991 5,564 5,746
6428 PROTECTION SERVICES 590 435 356
6420 IS SERVICES/LICENSES/FEES 3,819 4,958 6,463 5,906 8,364 8,546
6430 MISCELLANEOUS
6431 SPECIAL EVENTS 0 0 0 0
6432 CONFERENCES AND SCHOOLS 321 371 465 600 600 600
6434 DUES&SUBSCRIPTIONS 887 1,003 750 800 1,000 1,000
6435 CREDIT CARD FEES 23,690 22,760 17,670 25,000 25,000 26,000
6438 CASH SHORT(OVER) 1,262 2,748 479 1,000 1,000 1,000
6430 MISCELLANEOUS 26,160 26,881 19,364 27,400 27,600 28,600
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 40 20 20 100 1,000 1,000
6449 OTHER CONTRACTUAL SERVICES 2,823 2,658 1,869 2,500 2,600 2,600
6440 OTHER EXPENSES 2,863 2,678 1,889 2,600 3,600 3,600
6460 CENTRAL GARAGE CHARGES
6461 FUEL CHARGES 122 90 96 150 103 108
6462 FIXED CHARGES 543 536 398 600 560 577
6463 REPAIR&MAINT CHARGES 70 0 45 500 525 552
6465 REPLACEMENT CHARGES 1,103 1,114 698 1,100 1,050 1,199
6460 CENTRAL GARAGE CHARGES 1,839 1,740 1,237 2,350 2,238 2,436
6470 TRANSFERS AND OTHER USES
6471 ADMINISTRATIVE SERVICE TRANSFER 27,019 24,741 15,670 25,000 20,454 21,065
6470 TRANSFERS AND OTHER USES 27,019 24,741 15,670 25,000 20,454 21,065
6490 OTHER MISC COSTS/EXPENSES
S
TH XPEN S E
6494 DEPRECIATION EXPENSE 944 4,864 3,658 5,000 4,875 4,875
6490 OTHER MISC COSTS/EXPENSES 944 4,864 3,658 5,000 4,875 4,875
6299 OTHER CHARGES&SERVICES 188,641 193,666 143,133 198,889 206,761 210,133
6500 CAPITAL OUTLAY
6501 CAPITAL OUTLAY
6540 EQUIPMENT&MACHINERY 0 37 0 0
STORE # 2
CITY OF BROOKLYN CENTER
Budget Report
2010 2011 September YTD 2012 2013 2014
Object I Description Actual Actual 2012 Adopted Proposed Proposed
Amount Amount Actual Budget Budget Budget
6501 CAPITAL OUTLAY 0 0 0
6500 CAPITAL OUTLAY 0 0 0
6001 EXPENDITURES/EXPENSES 388,313 387,925 278,869 391,762 449,859 440,391
4000 REVENUES AND EXPENSES -38,700 -2,020 -1,136 -39,510 27,569 35,714
49612-69TH AVENUE LIQUOR STORE -38,700 -2,020 -1,136 -39,510 27,569 35,714
Total 60900-BROOKLYN CENTER LIQUOR -38,700 -2,020 -1,136 -39,510 27,569 35,714
38
CO O - I- M r M O I, O r- O tif� O O
'a (D O N 00 00 LO 00 It O V' 00 00 "T c- It
N O M LO M M (D N V• �- ' of O M V• ' M M r r
U 00 O V- 00 Ln O O I` V' M O M 00 00 Cl) IT h
N p O O LO O N r- C)) O O O r 0 r- V'
p N ti ti I- I- O N CO 00 r (D 00
ulx 64 K-) 64 64 K} EA 64 64 64 64 64 64 (f} 64 Yf ec) 64 ka
N O .-- M (D LO (O (3) O I` O [- co M 0 0
TJ O O V• V• V" M LO M I` I- O h- LO It r- 00
N 00 OD V• O - O 00 O O ' O O O It ' O O O d'
U r 00 cv V• M N LO O M M V• OI;i (O M V• M 00
O p O N I- U� 1- 00 r O 0 0 I- N O r O
p N LO LO M r- Cl) N LO I` LO Ln 00
EA 64 (!> 64 69 EA 64 64 (4 U) 64 64 64 64 V) 64 64 69 69
LO O I- N I`- N V• O N LO O LO It N LO N M
-O N O I- O LO co LO M co O O O N O O Cl) LO
N N M M M V• O (O 00 ' M O M 00 ' V CO 00
U rn a) I- co 6) co O V• M O O M r M (9
0) p - Cl) �t LO (O V• N O N LO M N r- P-
0-N M M I� (O (D r- N M r- CO Cl) ti(D (O V (D (O I (O (O r i
64 64 64 64 64 64 ER K-T 64 64 64 63 64 69 Efl U� Q9 69 Ef}
O O O 00 N CO O) O LO N O N Cl) 00 N LO V'
"a I- O N W N I- N LO O I- O r O O r- 6) N
N r M M N 00 M 00 M M ' L' O LO V N LO M 00
U LO O IT O i,- - O O M Cl) O Cl) r O M M O
N p M It N LO 11 O lqt O V• co d LO
0(y r r I- M LO 6) N
d CO (D L (O - M (O r
Efl 69 (H (t} 69 64 64 64 64 64 64 64 64 64 64 64 64 69 69
(9 O co Cn co co V- O O O) O O V' O O O M
•a I` O ff - N 00 (O r LO Cl) O M CLl r M LO O
N V' M M (9 M ti r O LO ' O M ' (D LO It
U (9 O d• O M O N 00 M O O O I- O O M r
N p LO I� O M N r r O O O Cl) I- O - Cl)
'p(14 6) 6) I- (D M I-- N O � O O I`
n L() LO V' LO Ln r LO L r
64 64 69 64 64 64 64 64 64 64 64 64 EA H> 69 (f} ER 64 d}
M O - I-- N N co co LO O LO O LO I- I- Ln LO et
'O CO O CO - t - V' O N O - O c- co N (O
N O LO V O O co O N V• O V' O V• V ' O � V• M
0 co N I` V• V' (O r- M 00 Cl) O Cl) N � M M h
° C) 00 O M (A O O - Cl) V- O V• I- O � - M
Q.O r r- (.O (D N M N 00 I` 00 ti
O N _ ., `
LO LO LO LO LO v r
EA 64 64 64 H) 6)- 64 64 69 64 EA H>Uf 64 64 64 64 64(/>
'I
O O O O M O M 0 0 0 OD O 00 LO O 00 O ti
LO O O LO m L() V• V• O O M O Cl) N Ln M O M
N LO LO N M M M O O (9 LO O LO � ' N LO O d'
0)_ (p V' f� 00 O I� (O M V 00 O O O O W O V• N
p r- 00 r M (O N M 00 O 00 It 00 00 N h
7 N r r- ( LO - r LO N I- I- I` I-- h
m LO LO V' LO LO - LO LO r
64 64 (f} (f} (fl 64 64 64 64 64 64 6>V! 64 64 64 64 64(F}
I- LO O 00 M d' 00 (D N 00 O LO - 00 O R- LO
O I� LO Cl) O 00 N O M O 00 O 00 CO O 00 N C
L LO M LO O LO V O N ' V' d' 00 O M O M N h O
W N j O (O N 00 N (N LO O) I- M M It 00 (C) •- O N
c 3 o 00 .— o (n N (o l- (o v — LO OO p - d
0) O Q N r- OD LO M V_ - (D 00 (D h
U Ln L() �' L() L() - Ln LL6 [� (n
s 64 64 (» 64 69 (» 60- 64 64 64 64 64(> (» 64 (» 64 64 09-
rn
o ) I` 00 O V• O LO I- - M O O 00 LO N CO CO Lf)
O U N N T O 00 (D - LO (D I- O I` M V• O I- (O r
O` L. O - M 00 �- (D O0 r- O 'd• r (.D r- 6) 00 (D O O (6
Co o 7 C) M LO N O 00 N I� O M M O (O V• M O (D 00 M m
y_ V' LO - VT I- O M co O N LO (A - LO
U O LO LO (D LO O N N V• ,T v LO It "I
0 J Q N Ln L() V' L(•) LO r L() L6 r U
U OUO 64 va 61) (» (» 69 69- 64 69 64 64 61) 69 64 64 64 69 V4<A o
U)
C
0) U
C @ J (6
(0 O O D L UOi O (n
(n ° a� (n (n Q m iii c
a� «� n -0 0 U) m Q s O
(L6 O c i N O o W c c L U C N C (n rn Q
w n0 > C� io 06 °- cp _c (n a�i . io U +' (n E
o ° ip (n w x _ a (a
E O Z c •°� v o ° � U c ° I� n
0) ° 0) ° Q. 0 a) -- ' c c N N � L U)CL a
0 7 O x O ZI O O N 7 p (0 O O -C O X N C N (6 -
Q' C) k— WIZcf) cAU0c0 U c0Ull� W0w Q U <
39
City of Brooklyn Center G`,l Finance Utility with Rate Changes Only
Water Fund Calsh Flow Analysis
Rate Increase 3.00% 4.00% 4.00% 8.00% 9.00% 12.00% 15.00% 15.00% 15.00% 15.00% (8.00%) (a 00%) (8.00%) (8.00%) (8.003'.)
Rate/1,000 gallons 1.29 1.34 1.40 1.51 1.65 1.85 2.12 2.44 2.81 3.23 2.97 2.73 2.51 2.31 2.13
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Pr-
2009 2010 2011 2012 1 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenues IN
Water Service S 1,974,100 S 1,929,058 $ 1,948,067 S 2,204,708 $ 2,368,682 S 2,652,924 S 3,050,862 $ 3,508,492 $ 4,034,766 $ 4,639,980 $ 4,268,782 $ 3,927,279 $ 3,613,097 $ 3,324,049 $ 3,058,125 $ 2
Bond Proceeds $ - S 1,719,422 $ - $ - $ - $ - S - $ - $ - $ - $ - $ - $ - S - $
Misc.Operating $ 2,596 S 1,057 $ 42,598 $ - S 3,700 $ 7,400 S 11,100 $ 14,800 $ 18,500 $ 22,200 $ 25,900 $ 29,6CO $ 33,300 $ 37,000 S 40,700 $
Misc.Non-operating $ 50,442 S 34,519 $ 16,923 $ 12,000 $ 81,331 $ 64,429 $ 47,107 $ 44,493 S 32,327 $ 5,620 S 36,633 S 63,487 $ 80,582 $ 128,899 S 171,929 $
Total Revenues $ 2,027,138 $ 3,684,056 S 2,007,588 $ 2,216,708 $ 2,453,713 $ 2,724,753 $ 3,109,070 S 3,567,785 S 4,085,593 $ 4,667,801 S 4,331,315 S 4,020,365 $ 3,726,979 S 3,489,948 $ 3,270,754 $
Expenditures
Personal Services $ 421,975 $ 485,939 S 478,658 $ 478,177 S 494,914 $ 502,193 $ 517,259 $ 532,777 S 548,760 $ 565,223 S 582,179 $ 599,645 $ 617,634 S 636,163 $ 655,248 S
Supplies $ 161,552 S 148,599 S 140,575 S 175,650 S 244,020 $ 178,360 $ 183,711 S 189,222 S 194,899 $ 200,746 $ 206,768 $ 212,971 S 219,360 S 225,941 $ 232,719 $
Services S 2,258,839 $ 504,585 $ 595,610 S 678,023 S 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 S 767,917 $ 798,634 $ 830,579 S 863,803 S 898,355 $ 934,289 S
Depreciation S 598,180 $ 550,662 $ 584,600 S 690,558 S 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 S 811,627 $ 831,918 $ 852,716 S 874,034 $ 895,884 S 918,281 $
New Interest
Debt Service Interest 8,Fees S $ 94,701 $ 63,141 S 63,928 S 62,185 S 60,185 $ 57,571 $ 54,575 $ 51,031 S 46,910 $ 42,347 $ 37,354 S 31,867 S 23,903 S 19,495 $
Total Expenditures $ 3,438,546 $ 1,784,486 $ 1,862,584 S 2,086,336 $ 2,196,139 S 2,132,451 $ 2,194,893 $ 2,259,075 $ 2,324,903 S 2,392,423 $ 2,461,846 $ 2,533,265 $ 2,606,697 $ 2,680,246 $ 2,760,033 $ 2
less:Non-Cash Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 S 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 $ 895,884 $ 918,281 $
New Principal
plus:Debt Service Principal $ - $ 105,000 $ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 $ 112,750 $ 116,250 $ 116,250 $ 120,000 S 123,750 S 131,250 $ 135,000 S
plus:Transfers $ - $ 53,262 $ - $ - - $ - $ - $ - $ - S - $ - $ - $ - $ - S - $ - S
plus:Cash Capital Outlay $ 437,423 S 975,158 $ 1,127,897 $ ?w $ 1,420,000 S 1,800,000 $ 1,650,000 S 2,378,000 S 3,330,000 $ 1,937,000 S 1,690,000 $ 1,650,000 S 260,000 S 140,000 $ 300,000 S 1
Total Cash Requirement $ 3,279,789 S 2,208,982 S 2,510,881 $ 1,497,028 ;it 5 3,017,109 S 3,302,157 $ 3,196,216 S 3,973,306 S 4,975,822 S 3,634,046 $ 3,436,179 S 3,450,549 S 2,116,414 S 2,055.612 $ 2,276,751 S
Beginning Cash Balance $ 2,068,255 $ 1,147,687 $ 2,546,948 $ 1,991,361 r $ 2,711,041 $ 2,147,645 $ 1,570,241 $ 1,483,095 S 1,077,573 S 187,344 $ 1,221,099 S 2,116,235 S 2,086,052 $ 4,296,617 5 5,730,953 $ E
Changes in Assets/Liabilities S 332,083 $ (75,813) $ (52,294) $ - I $ - $ - $ - $ - S - S - S - $ - S - $ - S - $
Cash Received $ 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 S 2,453,713 $ 2,724,753 $ 3,109,070 $ 3,567,785 $ 4,OB5,593 $ 4,667,801 $ 4,331,315 $ 4,020,366 $ 3,726,979 5 3,489,948 S 3,270.,754 $
Cash Spent S 3,279,789 $ 2,208,982 S 2,510,881 $ 1,497,028 S 3,017,109 S 3,302,157 $ 3,196,216 $ 3,973,306 $ 4,975,822 S 3,634,046 $ 3,436,179 $ 3,450,549 $ 2,116,414 $ 2,055,612 $ 2,276,751 $
Ending Cash Balance $ 1,147 687 $ 2,546,948 $ 1,991,361 $ 2,711,041 5 2,147,645 $ 1,570,241 $ 1,483,095 $ 1,077,573 $ 187,344 $ 1,221,099 $ 2,116,235 S 2,686,052 $ 4,296,617 S 5,730,953 $ 6,724,956 $ E
Cash Reserve Target(step) S 1;000,000 $ 1,200,000 S 1,200,000 $ 1,300,000 i $ 1,300,000 $ 1,300.,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 S 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 S
Cash Reserve Target(5%lyr) S 1,050,000 $ 1,102,500 $ 1,157,625 S 1,215,506 $ 1,276,282 S 1,340,096 S 1,407,100 $ 1,477,455 $ 1,551,328 $ 1,628,895 S 1,710,339 S 1,795,856 $ 1,BB5,649 S 1,979,932 $ 2,078,928 $
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_
City of Brooklyn Center Finance by Adjusting Rates and Using Minima[ Debt
Water Fund Calsh Flow Analysis
Rate Increase a00% 4.00% 4.00% 8.00% 9.00% 9.00% 9.00% 9.0091. 9.00% 9.00% 0.00% 0.00% 0.00% 0.00•/. (3.0031.) (3.00.1.)
Ratell,000 gallons 1.29 1.34 1.40 1.51 1.65 1.80 1.96 2.13 2.33 2.54 2.54 2.54 2.54 2.54 2.46 2.39
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024
Revenues
Water Service S 1,974,100 S 1,929,058 $ 1,948,067 $ 2,204,708 $ 2,368,682 S 21581,863 $ 2,814,231 $ 3,067,512 $ 3,343,588 S 3,644,511 $ 3,644,511 S 3,644,511 $ 3,644,511 S 3,644,511 $ 3,535,176 $ 3,429,120
Bond Proceeds $ - $ 1,719,422 $ - $ - $ - $ - S - $ 1,500,000 $ - $ - -
Misc.Operating S 2,596 $ 1,057 $ 42,598 $ - $ 3,700 $ 7,400 $ 11,100 $ 14,800 $ 18,500 $ 22,200 $ 25,900 S 29,600 $ 33,300 $ 37,000 S 40,700 S 44,400
Misc.Non-operating $ 50,442 $ 34,519 S 16,923 $ 12,000 $ 81,331 $ 64,429 $ 44,975 S 35,198 $ 9,524 S 6,398 S 1,787 $ 3,220 $ 1,556 $ 19,517 $ 68,880 $ 109,920
Total Revenues $ 2,027,138 $ 3,684,056 S 2,007,588 S 2,216,708 S 2,453,713 $ 2,653,693 $ 2,870,307 S 3,117,510 S 4,871,612 $ 3,673,109 S 3,672,198 S 3,677,331 $ 3,679,367 $ 3,701,028 S 3,644,756 $ 3,583,440
Expenditures
Personal Services $ 421,975 $ 485,939 $ 478,658 $ 478,177 $ 494,914 $ 502,193 $ 517,259 $ 532,777 $ 548,760 $ 565,223 S 582,179 S 599,645 $ 617,634 S 636,163 $ 655,248 S 674,905
Supplies $ 161,552 S 148,599 S 140,575 $ 175,650 ! $ 244,020 $ 178,360 $ 183,711 $ 189,222 $ 194,899 $ 200,746 S 206,768 $ 212,971 $ 219,360 $ 225,941 $ 232,719 $ 239,701
Services $ 2,258,839 S 504,585 S 595,610 $ 678,023 S 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 $ 767,917 S 798,634 $ 830,579 $ 863,803 $ 898,355 $ 934,289 $ 971,660
Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 S 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 S 831,918 $ 852,716 $ 874,034 $ 895,884 $ 918,281 S 941,238
New Interest S 42,750 S 38,250 S 32,250 $ 14,250
Debt Service Interest&Fees S - $ 94,701 S 63,141 $ 63,928 $ 62,185 $ 60,185 $ 57,571 S 54,575 S 51,031 S 46,910 $ 42,347 $ 37,354 $ 31,867 S 23,903 $ 19,495 S 12,736
Total Expenditures S 3,438,546 $ 1,784,486 $ 1,862,584 $ 2,086,336 $ 2,196,139 $ 2,132,451 $ 2,194,893 $ 2,259,075 S 2,324,903 $ 2,435,173 $ 2,500,096 S 2,565,515 $ 2,620,947 S 2,680,246 $ 2,760,033 S 2,840,241
less:Non-Cash Depreciation S 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 S 735,294 $ 753,676 $ 772,518 S 791,831 $ 811,627 $ 831,918 S 852,716 $ 874,034 S 895,884 $ 918,281 S 941,238
New Principal $ 150,000 $ 150,000 $ 250,000 $ 950,000
plus:Debt Service Principal $ - S 105,000 $ 101,250 $ 101,250 S 105,000 S 105,000 S 108,750 $ 112,750 $ 116,250 S 116,250 $ 120,000 $ 123,750 $ 131,250 $ 135,000 $ 138,750
plus:Transfers $ - $ 53,262 S - $ - $ - $ - S - $ - $ - $ - $ - $ - $ - S - $ - S -
plus:Cash Capital Outlay $ 437,423 S 975,158 $ 1,127,897 $ - S 1,420,000 S 1,800,000 $ 1,650,000 $ 2,378,000 S 3,330,000 $ 1,937,000 $ 1,690,000 $ 1,650,000 $ 260,000 $ 140,000 $ 300,000 S 1,570,000
Total Cash Requirement $ 3,279,789 S 2,208,982 $ 2,510,881 S 1,497,028 $ 3,017,109 $ 3,302,157 S 3,196,216 $ 3,973,306 S 4,975,822 $ 3,826,796 S 3,624,429 $ 3,732,799 $ 3,080,664 S 2,055,612 $ 2,276,751 S 3,607,753
Beginning Cash Balance S 2,068,255 $ 1,147,687 $ 2,546,948 S 1,991,361 ! $ 2,711,041 $ 2,147,645 S 1,499,181 $ 1,173,271 $ 317,475 $ 213,265 $ 59,578 $ 107,348 $ 51,880 S 650,583 $ 2,296,000 $ 3,664,004
Changes in Assets/Liabilities $ 332,083 $ (75.813) $ (52,294) $ - $ - S - S - S - s - S - $ - S - $ - $ - $ - $ -
Cash Received $ 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 $ 2,453,713 $ 2,653,693 S 2,870,307 $ 3,117,510 S 4,871,612 $ 3,673,109 $ 3,672,198 $ 3,677,331 $ 3,679,367 $ 3,701,028 S 3,644,756 $ 3,583,440
Cash Spent $ 3,279,789 $ 2,208,982 $ 2,510,881 S 11497,028 $ 3,017,109 $ 3,302,15 $ 3,196,216 $ 3,973,306 S 4,975,822 $ 3,826,796 $ 3,624,429 S 3,732,799 $ 3,080,664 $ 2,055,612 $ 2,276,751 $ 3,607,753
Ending Cash Balance $ 1,147,687 $ 2,546 948 $ 1,991,361 $ 2,711,041 $ 2,147 645 $ 1,499,181 $ 1,173,271 $ 317,475 $ 213,265 $ 69,576 $ 107,348 $ 61,880 $ 650,583 $ 2,296,000 $ 3,664,004 $ 3 639 691
Cash Reserve Target(step) $ 1,000,000 $ 1,200,000 $ 1,200,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 S 1,500,000 S 1,500,000 S 1,500,000 $ 1,500,000 $ 1,500,000
Cash Reserve Target(5%/yr) $ 1,050,000 $ 1,102,500 $ 1,157,625 $ 1,215,506 $ 1,276,282 $ 1,340,096 $ 1,407,100 S 1,477,455 $ 1,551,328 $ 1,628,89.5 $ 1,710,339 $ 1,795,856 $ 1,885,649 $ 1,979,932 $ 2,078,928 $ 2,182,875
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.
City of Brooklyn Center �i Finance by Issuing Debt and Stabilizing Rates
Water Fund Calsh Flow Analysis
Rate Increase 3.00% 4.00% 4.00% 8.00% 7.00% 7.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 0.00% 0.00% 0.00% 0.00%
Ratel1,000 gallons 1.29 1.34 1.40 1.51 1.62 1.73 1.83 1.95 2.06 2.19 2.32 2.46 2.46 2.46 2.46 2.46
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Pr.
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024
Revenues
Water Service S 1,974,100 S 1,929,058 $ 1,948,067 $ 2,204,708 $ 2,359,038 $ 2,524,170 S 2,675,620 S 2,836,158 S 3,006,327 $ 3,186,707 $ 3,377,909 S 3,580,584 $ 3,580,584 $ 3,580,584 $ 3,580,584 S 3,580,584 s 3,
Bond Proceeds S - $ 1,719,422 S - S - - S - $ - $ - S 3,330,000 $ - $ - S - $ - $ - S - S - $
Misc.Operating S 2,596 $ 1,057 $ 42,598 $ - S 3,700 $ 7,400 $ 11,100 S 14,800 S 18,500 S 22,200 $ 25,900 $ 29,600 S 33,300 S 37,000 $ 40,700 S 44,400 $
Misc.Non-operating S 50,442 $ 34,519 S 16,923 $ 12,000 S 81,331 $ 64,140 S 42,947 S 28,950 S 3,852 S 37,403 $ 15,386 S 4,717 $ 287 $ 27,532 S 51,182 $ 69,694 S
Total Revenues S 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 S 2,444,069 S 2,595,710 $ 2,729,667 S 2,879,908 S 6,350,975 S 3,246,309 $ 3,419,195 S 3,614,901 S 3,613,597 $ 3,645,115 S 3,672,466 S 3,694,678 $ 3,
Expenditures
Personal Services $ 421,975 $ 485,939 $ 478,658 $ 478,177 $ 494,914 $ 502,193 $ 517,259 S 532,777 S 548,760 $ 565,223 S 582,179 S 599,645 $ 617,634 $ 636,163 S 655,248 S 674,905 S
Supplies $ 161,552 $ 148,599 S 140,575 $ 175,650 $ 244,020 $ 178,360 $ 183,711 $ 189,222 S 194,899 $ 200,746 $ 206,768 S 212,971 $ 219,360 S 225,941 S 232,719 $ 239,701 S
Services S 2,258,839 $ 504,585 $ 595,610 $ 678,023 ' $ 694,740 $ 656,419 $ 682,676 S 709,983 $ 738,382 $ 767,917 S 798,634 $ 830,579 $ 863,803 S 898,355 $ 934,289 S 971,660 S 1,
Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 $ 700,280 $ 735,294 S 753,676 $ 772,518 $ 791,831 $ 811,627 S 831,918 S 852,716 $ 874,034 $ 895,884 $ 918,281 $ 941,238 $
New Interest S 96,150 $ 88,650 S 81,150 $ 69,900 S 51,150 S 28,650 S 6,700
Debt Service Interest&Fees $ - $ 94,701 $ 63,141 S 63,928 S 62,185 S 60,185 $ 57,571 $ 54,575 $ 51,031 $ 46,910 S 42,347 S 37,354 S 31,867 S 23,903 $ 19,495 $ 12,736 $
Total Expenditures S 3,438,546 $ 1,784,486 $ 1,862,584 $ 2,086,336 $ 2,196,139 $ 2,132,451 S 2,194,893 $ 2,259,075 $ 2,324,903 $ 2,488,573 $ 2,550,496 $ 2,614,415 $ 2,676,597 $ 2,731,396 S 2,788,683 S 2,848,941 $ 2,
less:Non-Cash Depreciation $ 596,180 S 550,662 $ 584,600 $ 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 S 791,831 S 811,627 $ 831,918 S 852,716 S 874,034 $ 895,884 S 918,281 $ 941,238 S
New Principal $ 250,00D S 250,000 S 250,000 $ 500,000 $ 750,000 S 750,000 $ 580,000
plus: Debt Service Principal $ - $ 105,000 $ 101,250 $ 101,250 S 105,000 $ 105,000 S 108,750 $ 112,750 $ 116,250 S 116,250 S 120,000 $ 123,750 $ 131,250 S 135,000 S 138,750 S
plus:Transfers $ - S 53,262 $ - $ - $ - $ - S - $ - $ - $ - $ - S - $ - $ - $ - $ - S
plus:Cash Capital Outlay $ 437,423 $ 975,158 $ 1,127,897 $ - $ 1,420.000 S 1,800,000 S 1,650,000 $ 2,378,000 $ 3,330,000 $ 1,937,000 S 1,690 000 $ 1,650,000 S 260,000 $ 140,000 $ 300,000 S 1,570,000 S 1,
Total Cash Requirement S 3,279,789 $ 2,208,982 $ 2,510,881 S 1,497,028 $ 3,017,109 $ 3,302,157 $ 3,196,216 $ 3,973,306 $ 4,975,822 $ 3,980,196 S 3,774,829 S 3,781,699 S 2,686,314 $ 2,856,762 S 3,055,401 S 4,196,453 $ 3,
Beginning Cash Balance S 2,068,255 $ 1,147,687 $ 2,546,948 S 1,991,361 $ 2,711,041 $ 2,138,001 S 1,431,554 $ 965,005 $ (128,394) $ 1,246,759 S 512,873 $ 157,240 S (9,558) S 917,724 S 1,706,078 S 2,323,143 $ 1,
Changes in Assets/Liabilities S 332,083 S (75,813) $ (52,294) $ - $ - S - $ - $ - $ - $ - S - S - $ - S - $ - $ - S
Cash Received S 2,027,138 $ 3,684,056 $ 2,007,588 $ 2,216,708 $ 2,444,069 S 2,595,710 $ 2,729,667 $ 2,879,908 $ 6,350,975 $ 3,246,309 $ 3,419,195 $ 3,614,901 $ 3,613,597 S 3,645,115 $ 3,672,466 $ 3,694,678 S 3,
Cash Spent $ (3,279,789) $ (2,208,982) $ 2,510,881 $ 1,497,028 $ 3,017,109 S 3,302,157 $ (3,196,216) $ 3,973,306 $ 4,975,822 $ 3,980 196 S (3,774,829) S (3,781,699) $ 2,686,314 S 2,856,762 $ 3,055,401 S 4,196,453 $(3
Ending Cash Balance $ 1,147,687 $ 2,546,948 $ 1,991,361 S 2,711,041 $ 2,138,001 S 1,431,554 $ 965,005 $ 128,394 $ 1,246,759 $ 512,873 $ 157,240 $ 9,556 S 917,724 $ 1,706,078 $ 2,323,143 $ 1,821,368 $ 1,
Cash Reserve Target(step) S 1,000,000 $ 1,200,000 S 1,200,000 S 1,300,000 $ 1,300,000 S 1,300,000 S 1,400,000 $ 1,400,000 S 1,400,000 $ 1,400,000 S 1,400,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 1,500,000 S 1,500,000 S 1,
Cash Reserve Target(5%lyr) $ 1,050,000 $ 1,102,500 $ 1,157,625 $ 1,215,506 $ 1,276,282 $ 1,340,096 S 1,407,100 $ 1,477,455 $ 1,551,328 $ 1,628,895 $ 1,710,339 $ 1,795,856 S 1,885,649 S 1,979,932 S 2,078,928 $ 2,182,875 $ 2,
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 30% perannum.
Services increase at a rate of 4%per year
Depreciation increases at a rate of approximately 2.S D/.per annum.
Z7 City of Brooklyn Center D Sell More Debt, Earlier, To Stabilize Rates
Water Fund Calsh Flow Analysis
Rate Increase 3.00% 4.00% 4.00•% 8.0051. 6.00% 6.00% 6.00% 6.00°/ 6.00.10 6.00% 6.00% 0.00% 0.001 0.001 0.00% 0.00%
Rate/1,000 gallons 1.29 1.34 1.40 1.51 1.60 1.70 1.80 1.91 2.02 2.14 2.27 2.27 2.27 2.27 2.27 2.27
Actual Actual Actual Budget Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024
Revenues
Water Service $ 1,974,100 S 1,929,058 S 1,948,067 S 2,204,708 S 2,368,682 S 2,510,803 S 2,661,451 S 2,821,138 S 2,990,406 $ 3,169,831 $ 3,360,021 S 3,360,021 $ 3,360,021 $ 3,360,021 $ 3,360,021 $ 3,360,021
Bond Proceeds $ - $ 1,719,422 $ - S - $ - $ 1,800,000 $ - $ 2,000,000 S - $ 2,000,000 $ - $ - $ - $ - $ - $ -
Misc.Operating $ 2,596 $ 1,057 $ 42,598 $ - $ 3,700 $ 7,400 $ 11,100 $ 14,800 $ 18,500 $ 22,200 $ 25,900 $ 29,600 $ 33,300 S 37,000 $ 40,700 $ 44,400
Misc.Non-operating $ 50,442 $ 34,519 $ 16,923 S 12,000 $ 81,331 $ 64,429 $ 96,844 $ 67,644 S 79,607 $ 3,172 $ 18,032 $ 3,544 $ 25,549 $ 7,538 $ 10,533 $ 23,253
Total Revenues S 2,027,138 S 3,684,056 $ 2,007,588 $ 2,216,708 $ 2,453,713 $ 4,382,632 $ 2,769,395 $ 4,903,582 $ 3,088,514 $ 5,188,859 S 3,403,953 $ 3,386,076 $ 3,367,772 S 3,389,483 $ 3,411,254 $ 3,427,674
Expenditures
Personal Services $ 421,975 $ 485,939 $ 478,658 $ 478,177 $ 494,914 S 502,193 $ 517,259 $ 532,777 S 548,760 $ 565,223 S 582,179 $ 599,645 $ 617,634 $ 636,163 $ 655,248 $ 674,905
Supplies $ 161,552 $ 148,599 $ 140,575 $ 175,650 $ 244,020 S 178,360 $ 183,711 $ 189,222 S 194,899 $ 200,746 S 206,768 $ 212,971 $ 219,360 $ 225,941 $ 232,719 $ 239,701
Services $ 2,258,839 $ 504,585 $ 595,610 $ 678,023 $ 694,740 $ 656,419 $ 682,676 $ 709,983 $ 738,382 S 767,917 $ 798,634 $ 830,579 $ 863,803 $ 898,355 $ 934,289 $ 971,660
Depreciation $ 596,180 $ 550,662 $ 584,600 $ 690,558 S 700,280 $ 735,294 $ 753,676 S 772,518 $ 791,831 S 811,627 $ 831,918 $ 852,716 S 874,034 $ 895,884 $ 918,281 $ 941,238
New Interest $ 46,500 S 31,500 $ 18,000 S 6,000
New Interest $ 54,000 S 42,000 S 30,000 S 18,000 $ 6,000
New Interest $ 57,000 $ 51,000 S 45,000 $ 31,500 $ 10,500
Debt Service Interest&Fees $ $ 94,701 S 63,141 S 63,928 $ 62,185 $ 60,185 $ 57,571 S 54,575 $ 51,031 $ 46,910 $ 42,347 $ 37,354 S 31,867 $ 23,903 S 19,495 $ 12,736
Total Expenditures S 3,438,546 5 1,784,486 S 1,862,584 S 2,086,336 $ 2,196,139 $ 2,132,451 $ 2,241,393 S 2,290,575 $ 2,396,903 $ 2,440,423 $ 2,548,846 $ 2,602,265 S 2,657,697 S 2,711,746 S 2,770,533 $ 2,840,241
less:Non-Cash Depreciation S 596,180 $ 550,662 $ 584,600 S 690,558 $ 700,280 $ 735,294 $ 753,676 $ 772,518 $ 791,831 $ 811,627 $ 831,918 $ 852,716 $ 874,034 S 895,884 $ 918,281 $ 941,238
New Principal $ 500,000 $ 500,000 $ 400,000 $ 400,000
New Principal $ 400,000 $ 400,000 S 400,000 $ 400,000 $ 400,000
New Principal $ 200,000 $ 200,000 S 200,000 S 700,000 S 700,000
plus:Debt Service Principal $ - S 105,000 $ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 S 112,750 $ 116,250 $ 116,250 $ 120,000 $ 123,750 $ 131,250 $ 135,000 $ 138,750
plus:Transfers $ - S 53,262 S - $ - $ - $ - $ - $ - S - $ - $ - $ - $ - $ - $ - $ -
plus:Cash Capital Outlay $ 437,423 S 975,158 $ 1,127,897 $ $ 1,420,000 S 1,800,000 $ 1,650,000 $ 2,378,000 S 3,330,000 $ 1,937,000 S 1,690,000 $ 1,650,000 S 260,000 $ 140,000 $ 300,000 $ 1,570,000
Total Cash Requirement $ 3,279,789 S 2,208,982 S 2,510,881 $ 1,497,028 $ 3,017,109 S 3,302,157 $ 3,742,716 $ 4,504,806 $ 5,847,822 $ 4,482,046 S 4,123,179 S 4,119,549 S 2,767,414 $ 2,787,112 $ 2,987,251 $ 3,607,753
Beginning Cash Balance $ 2,068,255 S 1,147,687 $ 2,546,948 S 1,991,361 $ 2,711,041 $ 2,147,645 $ 3,228,121 S 2,254,799 $ 2,653,575 $ (105,734) $ 601,080 $ (118,146) S (851,619) $ (251,261) $ 351,110 $ 775,113
Changes in Assets/Liabilities $ 332,083 S (75,813) $ (52,294) $ - $ - $ - $ - $ -
Cash Received $ 2,027,138 S 3,684,056 $ 2,007,588 S 2,216,708 $ 2,453,713 $ 4,382,632 $ 2,769,395 S 4,903,582 $ 3,088,514 $ 5,188,859 S 3,403,953 S 3,386,076 $ 3,367,772 $ 3,389,483 $ 3,411,254 S 3,427,674
Cash Spent $ 3,279,789 S 2,208,982 $ 2,510,881 S 1,497,028 S 3,017,109 $ 3,302,157 $ 3,742,716 S 4,504,806 S 5,847,822 $ 4,482,046 S 4,123,179 $ 4,119,549 $ 2,767,414 $ 2,787,112 $ 2,987,251 $ 3,607,753
Ending Cash Balance $ 1,147,687 $ 2,546 948 $ 1,991,361 5 2,711
1,041 $ 2,147,645 $ 3,225,121 $ 2,254,799 $ 2,653,575 $ (105,734) $ 601,080 $ (118,146) $ (851,619) $ 251,261 $ 351,110 $ 775,113 $ 595,034
Cash Reserve Target(step) $ 1,000,000 $ 1,200,000 $ 1,200,000 S 1,300,000 $ 1,300,000 $ 1,300,000 S 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,400,000 $ 1,500,000 S 1,500,000 S 1,500,000 $ 1,500,000 $ 1,500,000
Cash Reserve Target(5%1yr) $ 1,050,000 $ 1,102,500 $ 1,157,625 $ 1,215,506 $ 1,276,282 $ 1,340,096 S 1,407,100 $ 1,477,455 $ 1,551,328 $ 1,628,895 S 1,710,339 $ 1,795,856 S 1,885,649 $ 1,979,932 $ 2,078,928 S 2,1.82,875
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 41/.per year
Depreciation increases at a rate of approximately 2.51/6 per annum.
N N O O O
Lr) O lD
c N O
I
C
m N c1 N
w O 0
Ln N
W N
C > D
® c0 v p
U
CL '� •� •L ','
Y @ u
C U Q1
� � L
L o 3 -a
v o cc
�0 0 0
m o 0
N N lh O N
a � m rn
00 N Ci^ M
r4 r-4
`" � d• N
v
@ N
"O
a L =
m
CL v
i O
L
4J
L ra 3 -o
UO rru
Ln 00
N N co O
-i O
c0 O 14
Ln O Ln
Ln m
N
7 N h to
a N N
N c i ri
Y Ln
co C: Y 0
D O
n '3 0 r0
U E
c Q) C .O
41 c
r0 E -o
U vO�- OU � V} V? V?
Lr) N m 00 O
lD rn N �D O
ri m Lti rn
N N
�' lD
N U)
O
+ m
Q
C +C N
O'
r0 _T
CL _N N
d O
U N
� O
O u
v O ru
L ro v
E00 V)- V)- j/}
U 4- L
Y
co
L
N
m
Y
Y
m
L
Y
L
ro
O
* r
i
U ti O
r0 L } N
cr m N Of m
Y Y C U N Ln
cc or E � Ln
� � U
cu r1l
O O O O
sti
N
O
N
l7
N
O
N
LCl
O
N
5•
N
O
N
i
m
N
O
JJ N
Iry i
N
�J O
N
O O u
O
9 N
O]
00
O
N Q
lV
�L W
CJ
N
Lf}
O
CV
rqm
O
O O O O O O O O
Ln O Ln O Ln O UC O
m m N N H H O O
suolleS 000'Z aad siellop