Loading...
HomeMy WebLinkAbout2012 Budget 07 - Enterprise Funds City of Brook& Center 2012 Budget Enterprise Funds Enterprise Funds are those programs provided by the City which generate their own revenues for operations and capital maintenance. In some cases these funds are expected to generate enough revenue to support capital projects in other funds, thereby reducing the need for use of the property tax levy. The City of Brooklyn Center operates three Enterprise Funds: • Brooklyn Center Liquor • Centerbrook Golf Course • Earle Brown Heritage Center 339 This page has been left blank intentionally. 340 City of Brooklyn Center 2012 Budget FUND: Liquor Operations Fund—60900 DEPT/ACTIVITY/PROJECT: Liquor Store Operations—49611 and 49612 PROFILE This year will represent the tenth full year of operations at the Xerxes Avenue (Store #1) site, and the seventh year at the 69th and Brooklyn Boulevard (Store #2) site, which opened in January 2004. The profits from the City's retail liquor operations are used to support the costs of park maintenance and expansion, building maintenance and expansion, and other activities that would otherwise require property tax levy increases. DEPARTMENTAL GOALS • Build on recently implemented staff training and development efforts to improve customer service and satisfaction. • Continued growth in sales volume through promotion and sales activities. • Increase the cash equity in the fund in anticipation of replacement or enhancement to keep the facilities looking fresh and clean • Continue the Tasting Club development (3 wine events per year and 3 beer tasting events per year, one of each being a shared event in Summer) and other marketing efforts to add growth in the area of greatest profitability. EXPENDITURE DETAILS 6471 Administrative Service Transfer Out $75,000 Provides for costs of services from personnel provided for in other funds for administrative, financial and support services at BC Liquor(information technology, central garage and HR). 6476 Capital Project Fund Transfer $200,000 This item provides for a base transfer of$ 200,000 to the Capital Projects Fund to support community infrastructure improvements, primarily in the parks. PERSONNEL LEVELS 1-Operations Manager 2-Store Managers 1-Office Manager Part-time and seasonal as necessary CAPITAL OUTLAY 6540 Equipment and Machinery $ 138,600 Repair and Upgrade of Cooler Section in Store 1 341 CITY OF BROOKLYN CENTER SUMMARY t]V Budget Report VV��® ^IR i 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual 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- 4,000- 7,844- 6,000- 6,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 485- 3,805 4606 OTHER REVENUE 1,500- 1,500- 1,500- 2,000- 1,500- 1,500- 4600 MISCELLANEOUS REVENUE 16,882- 4,148- 5,500- 9,844- 7,500- 7,500- 4599 MISCELLANEOUS REVENUE 16,882- 4,148- 5,500- 9,844- 7,500- 7,500- 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES 2,081,625- 2,029,345- 2,070,000- 1,910,479- 2,184,674- 2,184,674- 4762 WINE SALES 636,260- 674,030- 640,000 674,316- 870,223- 870,223- 4763 BEER SALES 2,718,373- 2,682,176- 2,700,000- 2,483,557- 2,576,306- 2,576,306- 4764 SALES-NON TAXABLE 82,488- 66,032- 85,000- 62,985- 56,608- 56,608- 4765 SALES-TAXABLE 91,362- 91,444- 93,000- 79,719- 88,439- 88,439- 4760 LIQUOR STORE OPERATIONS 5,610,108- 5,543,027- 5,588,000- 5,211,056- 5,776,250- 5,776,250- 4900 OTHER FINANCING SOURCES 4921 REFUNDS&REIMBURSEMENTS 2,835- 216- 2,000- 2,000- 2,000- 4922 PROJECT ADMINISTRATION 4,008- 3,412- 2,000- 2,102- 2,500- 2,500- 4900 OTHER FINANCING SOURCES 6,843- 3,628- 2,000- 4,102- 4,500- 4,500- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 1,420,855 1,376,800 1,450,000 1,301,015 1,482,082 1,482,082 5582 COST OF SALES-WINE 442,269 462,461 435,000 447,828 585,486 585,486 5583 COST OF SALES-BEER 2,068,467 2,038,094 2,085,000 1,894,230 1,963,402 1,963,402 5584 OTHER COSTS OF SALE-NONTAXABLE 51,608 38,926 56,000 36,749 36,794 36,794 5585 OTHER COSTS OF SALE-TAXABLE 65,646 62,545 61,800 53,934 57,485 57,485 5587 INVENTORY VARIANCES 15,526 8,132 13,200 5,762 14,000 14,000 5589 DELIVERY CHARGES 23,907 22,794 20,800 21,191 23,800 23,800 5580 COST OF GOODS SOLD 4,088,278 4,009,751 4,121,800 3,760,709 4,163,049 4,163,049 5550 DIRECT COST OF SALES 4,088,278 4,009,751 4,121,800 3,760,709 4,163,049 4,163,049 4001 REVENUES 1,545,556- 1,541,052- 1,473,700- 1,464,292- 1,625,201- 1,625,201- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 279,294 265,313 236,653 222,481 251,000 251,000 6103 WAGES-PART TIME EMPLOYEES 218,350 219,884 243,700 209,618 228,000 228,000 6104 OVERTIME-PART TIME EMPLOYEES 5,254 2,985 6,100 3,252 4,500 4,500 6100 WAGES AND SALARIES 502,898 488,182 486,453 435,351 483,500 483,500 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 4,984 3,482 6110 OTHER PAYMENTS-NON INSURANCE 4,984 3,482 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 32,719 32,960 34,051 30,739 34,000 34,000 6125 FICA 32,203 31,173 30,163 27,563 31,000 31,000 6126 MEDICARE CONTRIBUTIONS 7,531 7,290 7,054 6,446 7,350 7,350 342 CITY OF BROOKLYN CENTER SUMMARY Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6120 RETIREMENT CONTRIBUTIONS 72,454 71,423 71,268 64,748 72,350 72,350 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 40,767 42,114 45,120 29,603 43,152 43,152 6130 INSURANCE BENEFITS 40,767 42,114 45,120 29,603 43,152 43,152 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,414 716 698 6140 UNEMPLOYMENT COMPENSATION 1,414 716 698 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 12,278 12,263 11,722 9,517 11,394 11,394 6150 WORKER'S COMPENSATION 12,278 12,263 11,722 9,517 11,394 11,394 6099 PERSONAL SERVICES 634,795 618,180 614,563 539,916 610,396 610,396 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,672 829 1,400 809 1,400 1,400 6202 COPYING SUPPLIES 80 200 6200 OFFICE SUPPLIES 1,672 908 1,600 809 1,400 1,400 6210 OPERATING SUPPLIES 6214 CLOTHING&PERSONAL EQUIPMENT 1,514 304 1,200 1,426 1,500 1,500 6219 GENERAL OPERATING SUPPLIES 12,971 10,550 14,000 17,006 15,500 15,500 6210 OPERATING SUPPLIES 14,486 10,854 15,200 18,431 17,000 17,000 6220 REPAIR&MAINT SUPPLIES 6223 BUILDINGS&FACILITIES 1,805 3,500 2,500 2,500 6220 REPAIR&MAINT SUPPLIES 1,805 3,500 2,500 2,500 6230 REPAIR&MAINT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 30 6230 REPAIR&MAINT SUPPLIES-OTHER 30 6240 SMALL TOOLS&MINOR EQUIPMENT 6242 MINOR EQUIPMENT 5,821 8,937 2,800 324 7,500 7,500 6243 MINOR COMPUTER EQUIPMENT 10,885 21,936 7,500 1,407 19,450 19,450 6240 SMALL TOOLS&MINOR EQUIPMENT 16,707 30,873 10,300 1,731 26,950 26,950 6199 SUPPLIES 34,669 42,665 30,600 20,972 47,850 47,850 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG,AUDIT&FIN'L SERVICES 4,495 4,377 4,400 4,906 5,000 5,000 6303 LEGAL SERVICES 251 259 6307 PROFESSIONAL SERVICES 17,232 3,085 6,000 2,857 6,300 6,300 6300 PROFESSIONAL SERVICES 21,978 7,722 10,400 7,763 11,300 11,300 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 5,226 4,397 2,375 2,882 3,880 3,880 6329 OTHER COMMUNICATION SERVICES 850 794 850 850 6320 COMMUNICATIONS 5,226 4,397 3,225 3,676 4,730 4,730 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 858 546 850 972 1,150 1,150 343 CITY OF BROOKLYN CENTER SUMMARY Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6330 TRANSPORTATION 858 546 850 972 1,150 1,150 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 264 1,500 142 800 800 6349 OTHER ADVERTISING 19,060 14,456 19,000 8,136 17,500 17,500 6340 ADVERTISING 19,324 14,456 20,500 8,278 18,300 18,300 6350 PRINTING AND DUPLICATING 6351 PRINTING 774 442 1,000 700 700 6350 PRINTING AND DUPLICATING 774 442 1,000 700 700 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 852 994 1,254 1,083 1,200 1,200 6362 PROPERTY INSURANCE 1,475 1,516 1,898 1,589 1,750 1,750 6364 DRAM SHOP INSURANCE 7,628 6,977 8,727 6,654 7,323 7,323 6366 MACHINERY BREAKDOWN INSURANCE 380 370 463 410 450 450 6360 INSURANCE 10,336 9,858 12,342 9,736 10,723 10,723 6380 UTILITY SERVICES 6381 ELECTRIC 31,492 32,268 33,000 32,059 34,000 34,000 6382 GAS 6,375 6,095 8,000 5,082 61800 6,800 6380 UTILITY SERVICES 37,867 38,363 41,000 37,141 40,800 40,800 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 2,680 6,872 7,000 643 7,000 7,000 6403 BLDGS/FACILITIES MAINT SERVICE 5,119 5,495 6,500 713 6,500 6,500 6406 MULTI-FUNCTION MTNCE 171 500 500 6400 REPAIR&MAINT SERVICES 7,798 12,367 13,500 1,527 14,000 14,000 6410 RENTALS 6412 BLDGS/FACILITIES 269,969 287,687 289,140 269,808 289,140 289,140 6410 RENTALS . 269,969 287,687 289,140 269,808 289,140 289,140 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 440 509 294 6422 SOFTWARE MAINT 961 2,740 1,052 1,255 2,815 2,815 6423 LOGIS CHARGES 13,880 12,951 13,366 12,476 16,635 16,635 6428 PROTECTION SERVICES 1,385 1,342 885 6420 IS SERVICES/LICENSES/FEES 16,667 17,542 14,418 14,910 19,450 19,450 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 7,320 8,030 7,700 7,146 8,000 8,000 6432 CONFERENCES AND SCHOOLS 1,485 1,790 2,100 1,310 3,100 3,100 6434 DUES&SUBSCRIPTIONS 3,225 3,006 3,300 3,021 3,300 3,300 6435 CREDIT CARD FEES 70,201 76,678 75,000 72,980 85,000 85,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 100 6438 CASH SHORT(OVER) 2,383 1,832 2,000 3,478 2,000 2,000 6430 MISCELLANEOUS 84,614 91,436 90,100 87,936 101,400 101,400 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 248 60 350 40 300 300 6442 COURT AWARDS/SETTLEMENTS 3,214 6449 OTHER CONTRACTUAL SERVICE 6,872 5,275 81000 4,558 5,000 5,000 6440 OTHER EXPENSES 10,334 5,335 8,350 4,598 5,300 5,300 6460 CENTRAL GARAGE CHARGES 344 CITY OF BROOKLYN CENTER SUMMARY Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6461 FUEL CHARGES 241 245 320 180 300 300 6462 FIXED CHARGES 1,072 1,087 1,023 983 1,200 1,200 6463 REPAIR&MAINT CHARGES 484 140 200 1,000 1,000 6465 REPLACEMENT CHARGES 2,251 2,207 2,230 2,043 2,200 2,200 6460 CENTRAL GARAGE CHARGES 4,048 3,679 3,773 3,206 4,700 4,700 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 53,546 73,689 74,298 68,107 75,000 75,000 6476 CAPITAL PROJECT FUND TRANSFER 265,490 230,199 135,000 200,000 200,000 6470 TRANSFERS AND OTHER USES 319,036 303,888 209,298 68,107 275,000 275,000 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 26,359 18,066 20,260 10,341 24,000 24,000 6490 OTHER MISC COSTS/EXPENSES 26,359 18,066 20,260 10,341 24,000 24,000 6299 OTHER CHARGES&SERVICES 835,188 815,781 738,156 527,999 820,693 820,693 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 3,548 6540 EQUIPMENT&MACHINERY 4,957 6,753 73,192 5,049 138,600 138,600 6501 CAPITAL OUTLAY 4,957 10,301 73,192 5,049 138,600 138,600 6500 CAPITAL OUTLAY 4,957 10,301 73,192 5,049 138,600 138,600 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 1,509,609 1,486,927 1,456,511 1,093,936 1,617,539 1,617,539 4000 REVENUES AND EXPENSES 35,947- 54,124- 17,189- 370,357- 7,662- 7,662- 60900 BROOKLYN CENTER LIQUOR 35,947- 54,124- 17,189- 370,357- 7,662- 7,662- 345 STORE # 1 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual 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 7,448- 3,227- 2,000- 3,922- 3,000- 3,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 243- 1,903 4606 OTHER REVENUE 1,500- 1,500- 1,500- 2,000- 1,500- 1,500- 4600 MISCELLANEOUS REVENUE 9,191- 2,824- 3,500- 5,922- 4,500- 4,500- 4599 MISCELLANEOUS REVENUE 9,191- 2,824- 3,500- 5,922- 4,500- 4,500- 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES 1,506,324- 1,497,048- 1,500,000- 1,405,473- 1,652,324- 1,652,324- 4762 WINE SALES 437,561- 467,331- 440,000- 476,066- 629,841- 629,841- 4763 BEER SALES 1,817,733- 1,775,160- 1,810,000- 1,626,510- 1,855,479- 1,855,479- 4764 SALES-NON TAXABLE 55,539- 45,510- 60,000- 43,540- 37,576- 37,576- 4765 SALES-TAXABLE 60,875- 61,675- 64,000- 54,003- 59,675- 59,675- 4760 LIQUOR STORE OPERATIONS 3,878,032- 3,846,725- 3,874,000- 3,605,593- 4,234,895- 4,234,895- 4900 OTHER FINANCING SOURCES 4921 REFUNDS&REIMBURSEMENTS 2,804- 216- 2,000- 2,000- 2,000- 4922 PROJECT ADMINISTRATION 4,008- 3,412- 2,000- 2,102- 2,500- 2,500- 4900 OTHER FINANCING SOURCES 6,812- 3,628- 2,000- 4,102- 4,500- 4,500- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 1,024,531 1,009,446 1,050,000 880,147 1,120,936 1,120,936 5582 COST OF SALES-WINE 300,355 317,896 299,000 296,666 423,757 423,757 5583 COST OF SALES-BEER 1,377,408 1,319,157 1,400,000 1,250,847 1,414,060 1,414,060 5584 OTHER COSTS OF SALE-NONTAXABLE 35,039 26,998 39,000 22,665 24,424 24,424 5585 OTHER COSTS OF SALE-TAXABLE 43,422 41,948 42,300 34,539 38,789 38,789 5587 INVENTORY VARIANCES 12,126 6,591 10,000 2,921 10,000 10,000 5589 DELIVERY CHARGES 17,430 17,102 15,000 16,174 18,000 18,000 5580 COST OF GOODS SOLD 2,810,311 2,739,138 2,855,300 2,503,960 3,049,966 3,049,966 5550 DIRECT COST OF SALES 2,810,311 2,739,138 2,855,300 2,503,960 3,049,966 3,049,966 4001 REVENUES 1,083,724- 1,114,038- 1,024,200- 1,111,657- 1,193,929- 1,193,929- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 183,092 184,886 150,459 155,734 175,000 175,000 6103 WAGES-PART TIME EMPLOYEES 148,268 148,407 169,500 138,518 160,000 160,000 6104 OVERTIME-PART TIME EMPLOYEES 2,942 1,530 3,500 1,834 2,500 2,500 6100 WAGES AND SALARIES 334,302 334,823 323,459 296,086 337,500 337,500 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 3,091 2,208 6110 OTHER PAYMENTS-NON INSURANCE 3,091 2,208 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 21,618 22,457 22,641 20,746 23,000 23,000 346 CITY OF BROOKLYN CENTER STORE Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6125 FICA 21,356 21,191 20,056 18,629 21,000 21,000 6126 MEDICARE CONTRIBUTIONS 4,995 4,956 4,690 4,357 5,000 5,000 6120 RETIREMENT CONTRIBUTIONS 47,969 48,603 47,387 43,732 49,000 49,000 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 35,192 36,438 33,840 24,988 32,364 32,364 6130 INSURANCE BENEFITS 35,192 36,438 33,840 24,988 32,364 32,364 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,414 716 698 6140 UNEMPLOYMENT COMPENSATION 1,414 716 698 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 8,165 8,414 7,794 6,408 7,794 7,794 6150 WORKER'S COMPENSATION 8,165 8,414 7,794 6,408 7,794 7,794 6099 PERSONAL SERVICES 430,133 431,202 412,480 371,912 426,658 426,658 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,237 572 1,000 570 1,000 1,000 6202 COPYING SUPPLIES 80 150 6200 OFFICE SUPPLIES 1,237 652 1,150 570 1,000 1,000 6210 OPERATING SUPPLIES 6214 CLOTHING&PERSONAL EQUIPMENT 1,060 304 800 1,086 1,000 1,000 6219 GENERAL OPERATING SUPPLIES 9,169 7,731 10,000 9,605 11,000 11,000 6210 OPERATING SUPPLIES 10,229 8,035 10,800 10,691 12,000 12,000 6220 REPAIR&MAINT SUPPLIES 6223 BUILDINGS&FACILITIES 1,285 2,500 2,000 2,000 6220 REPAIR&MAINT SUPPLIES 1,285 2,500 2,000 2,000 6230 REPAIR&MAINT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 30 6230 REPAIR&MAINT SUPPLIES-OTHER 30 6240 SMALL TOOLS&MINOR EQUIPMENT 6242 MINOR EQUIPMENT 5,316 8,597 2,000 324 7,000 7,000 6243 MINOR COMPUTER EQUIPMENT 7,448 12,657 5,000 1,016 16,715 16,715 6240 SMALL TOOLS&MINOR EQUIPMENT 12,764 21,254 7,000 1,340 23,715 23,715 6199 SUPPLIES 25,515 29,971 21,450 12,601 38,715 38,715 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG,AUDIT&FIN'L SERVICES 4,495 4,377 4,400 4,906 5,000 5,000 6303 LEGAL SERVICES 251 259 6307 PROFESSIONAL SERVICES 16,811 1,936 5,000 1,904 5,000 5,000 6300 PROFESSIONAL SERVICES 21,557 6,572 9,400 6,811 10,000 10,000 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 2,891 2,123 1,475 1,668 2,330 2,330 6320 COMMUNICATIONS 2,891 2,123 1,475 1,668 2,330 2,330 6330 TRANSPORTATION 347 CITY OF BROOKLYN CENTER STORE Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6331 TRAVEL EXPENSE/MILEAGE 554 497 600 628 750 750 6330 TRANSPORTATION 554 497 600 628 750 750 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 185 1,000 500 500 6349 OTHER ADVERTISING 13,345 10,678 14,000 5,432 12,500 12,500 6340 ADVERTISING 13,530 10,678 15,000 5,432 13,000 13,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 590 442 800 500 500 6350 PRINTING AND DUPLICATING 590 442 800 500 500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 352 408 627 542 600 600 6362 PROPERTY INSURANCE 476 362 663 558 600 600 6364 DRAM SHOP INSURANCE 5,249 4,906 6,137 4,693 5,200 5,200 6366 MACHINERY BREAKDOWN INSURANCE 92 89 163 144 150 150 6360 INSURANCE 6,169 5,765 7,590 5,937 6,550 6,550 6380 UTILITY SERVICES 6381 ELECTRIC 15,989 16,122 16,500 15,745 17,000 17,000 6382 GAS 3,242 3,403 4,000 3,034 3,800 3,800 6380 UTILITY SERVICES 19,232 19,526 20,500 18,778 20,800 20,800 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 644 6,068 5,000 519 5,000 5,000 6403 BLDGS/FACILITIES MAINT SERVICE 5,119 3,842 5,000 558 5,000 5,000 6406 MULTI-FUNCTION MTNCE 171 500 500 6400 REPAIR&MAINT SERVICES 5,762 9,910 10,000 1,247 10,500 10,500 6410 RENTALS 6412 BLDGS/FACILITIES 176,109 194,327 195,780 182,728 195,780 195,780 6410 RENTALS 176,109 194,327 195,780 182,728 195,780 195,780 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 308 382 294 6422 SOFTWARE MAINT 683 1,838 789 915 1,900 1,900 6423 LOGIS CHARGES 9,520 10,752 9,356 8,681 11,644 11,644 6428 PROTECTION SERVICES 639 751 489 6420 IS SERVICES/LICENSES/FEES 11,150 13,723 10,145 10,379 13,544 13,544 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 7,320 8,030 7,000 7,146 8,000 8,000 6432 CONFERENCES AND SCHOOLS 1,076 1,469 1,500 939 2,500 2,500 6434 DUES&SUBSCRIPTIONS 2,258 2,119 2,500 2,099 2,500 2,500 6435 CREDIT CARD FEES 48,068 52,988 50,000 52,465 60,000 60,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 100 6438 CASH SHORT(OVER) 1,463 570 1,000 781 1,000 1,000 6430 MISCELLANEOUS 60,184 65,276 62,000 63,431 74,000 74,000 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 183 20 200 20 200 200 6442 COURT AWARDS/SETTLEMENTS 3,214 6449 OTHER CONTRACTUAL SERVICE 3,677 2,452 5,000 2,139 2,500 2,500 6440 OTHER EXPENSES 7,074 2,472 5,200 2,159 2,700 2,700 348 T CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 121 122 160 90 150 150 6462 FIXED CHARGES 536 543 512 492 600 600 6463 REPAIR&MAINT CHARGES 242 70 100 500 500 6465 REPLACEMENT CHARGES 1,125 1,103 1,115 1,021 1,100 1,100 6460 CENTRAL GARAGE CHARGES 2,024 1,839 1,887 1,603 2,350 2,350 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 26,773 46,670 49,557 45,427 50,000 50,000 6476 CAPITAL PROJECT FUND TRANSFER 265,490 230,199 135,000 200,000 200,000 6470 TRANSFERS AND OTHER USES 292,263 276,869 184,557 45,427 250,000 250,000 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 17,122 17,122 19,260 5,882 19,000 19,000 6490 OTHER MISC COSTS/EXPENSES 17,122 17,122 19,260 5,882 19,000 19,000 6299 OTHER CHARGES&SERVICES 636,210 627,140 544,194 352,111 621,804 621,804 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 3,548 6540 EQUIPMENT&MACHINERY 3,049 6,753 73,192 5,049 138,600 138,600 6501 CAPITAL OUTLAY 3,049 10,301 73,192 5,049 138,600 138,600 6500 CAPITAL OUTLAY 3,049 10,301 73,192 5,049 138,600 138,600 6001 EXPENDITURES/EXPENSES 1,094,907 1,098,614 1,051,316 741,673 1,225,777 1,225,777 4000 REVENUES AND EXPENSES 11,183 15,424- 27,116 369,983- 31,848 31,848 49611 BROOKLYN CENTER LIQUOR 11,183 15,424- 27,116 369,983- 31,848 31,848 349 CITY OF BROOKLYN CENTER STORE Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 49612 69TH AVENUE LIQUOR STORE 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 7,448- 3,227- 2,000- 3,922- 3,000- 3,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 243- 1,903 4600 MISCELLANEOUS REVENUE 7,691- 1,324- 2,000- 3,922- 3,000- 3,000- 4599 MISCELLANEOUS REVENUE 7,691- 1,324- 2,000- 3,922- 3,000- 3,000- 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES 575,301- 532,297- 570,000- 505,006- 532,350- 532,350- 4762 WINE SALES 198,700- 206,698- 200,000- 198,250- 240,382- 240,382- 4763 BEER SALES 900,640- 907,016 890,000- 857,046- 720,827- 720,827- 4764 SALES-NON TAXABLE 26,949- 20,521- 25,000- 19,445- 19,032- 19,032- 4765 SALES-TAXABLE 30,488- 29,769- 29,000- 25,717- 28,764- 28,764- 4760 LIQUOR STORE OPERATIONS 1,732,077- 1,696,302- 1,714,000- 1,605,463- 1,541,355- 1,541,355- 4900 OTHER FINANCING SOURCES 4921 REFUNDS&REIMBURSEMENTS 31- 4900 OTHER FINANCING SOURCES 31- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 396,323 367,354 400,000 420,867 361,146 361,146 5582 COST OF SALES-WINE 141,914 144,565 136,000 151,161 161,729 161,729 5583 COST OF SALES-BEER 691,059 718,937 685,000 643,383 549,342 549,342 5584 OTHER COSTS OF SALE-NONTAXABLE 16,569 11,928 17,000 14,084 12,370 12,370 5585 OTHER COSTS OF SALE-TAXABLE 22,224 20,598 19,500 19,395 18,696 18,696 5587 INVENTORY VARIANCES 3,401 1,541 3,200 2,841 4,000 4,000 5589 DELIVERY CHARGES 6,477 5,692 5,800 5,017 5,800 5,800 5580 COST OF GOODS SOLD 1,277,967 1,270,613 1,266,500 1,256,749 1,113,083 1,113,083 5550 DIRECT COST OF SALES 1,277,967 1,270,613 1,266,500 1,256,749 1,113,083 1,113,083 4001 REVENUES 461,832- 427,014- 449,500- 352,636- 431,272- 431,272- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 96,202 80,427 86,194 66,748 76,000 76,000 6103 WAGES-PART TIME EMPLOYEES 70,082 71,477 74,200 71,100 68,000 68,000 6104 OVERTIME-PART TIME EMPLOYEES 2,312 1,455 2,600 1,417 2,000 2,000 6100 WAGES AND SALARIES 168,596 153,359 162,994 139,265 146,000 146,000 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 1,893 1,274 6110 OTHER PAYMENTS-NON INSURANCE 1,893 1,274 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 11,102 10,503 11,410 9,993 11,000 11,000 6125 FICA 10,847 9,982 10,107 8,934 10,000 10,000 6126 MEDICARE CONTRIBUTIONS 2,536 2,334 2,364 2,089 2,350 2,350 6120 RETIREMENT CONTRIBUTIONS 24,485 22,820 23,881 21,015 23,350 23,350 350 STORE CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 5,575 5,676 11,280 4,614 10,788 10,788 6130 INSURANCE BENEFITS 5,575 5,676 11,280 4,614 10,788 10,788 6140 UNEMPLOYMENT COMPENSATION 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 4,113 3,849 3,928 3,109 3,600 3,600 6150 WORKER'S COMPENSATION 4,113 3,849 3,928 3,109 3,600 3,600 6099 PERSONAL SERVICES 204,663 186,978 202,083 168,004 183,738 183,738 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 435 256 400 240 400 400 6202 COPYING SUPPLIES 50 6200 OFFICE SUPPLIES 435 256 450 240 400 400 6210 OPERATING SUPPLIES 6214 CLOTHING&PERSONAL EQUIPMENT 454 400 340 500 500 6219 GENERAL OPERATING SUPPLIES 3,802 2,819 4,000 7,400 4,500 4,500 6210 OPERATING SUPPLIES 4,256 2,819 4,400 7,740 5,000 5,000 6220 REPAIR&MAINT SUPPLIES 6223 BUILDINGS&FACILITIES 520 1,000 500 500 6220 REPAIR&MAINT SUPPLIES 520 1,000 500 500 6230 REPAIR&MAINT SUPPLIES-OTHER 6240 SMALL TOOLS&MINOR EQUIPMENT 6242 MINOR EQUIPMENT 505 340 800 500 500 6243 MINOR COMPUTER EQUIPMENT 3,437 9,279 2,500 391 2,735 2,735 6240 SMALL TOOLS&MINOR EQUIPMENT 3,943 9,619 3,300 391 3,235 3,235 6199 SUPPLIES 9,154 12,694 9,150 8,371 9,135 9,135 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 422 1,150 1,000 953 1,300 1,300 6300 PROFESSIONAL SERVICES 422 1,150 1,000 953 1,300 1,300 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 2,336 2,274 900 1,215 1,550 1,550 6329 OTHER COMMUNICATION SERVICES 850 794 850 850 6320 COMMUNICATIONS 2,336 2,274 1,750 2,008 2,400 2,400 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 304 49 250 344 400 400 6330 TRANSPORTATION 304 49 250 344 400 400 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 79 500 142 300 300 6349 OTHER ADVERTISING 5,715 3,777 5,000 2,703 5,000 5,000 6340 ADVERTISING 5,794 3,777 5,500 2,845 5,300 5,300 351 CITY OF BROOKLYN CENTER STORE Budget Report 2009 2010 2011 11130/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6350 PRINTING AND DUPLICATING 6351 PRINTING 184 200 200 200 6350 PRINTING AND DUPLICATING 184 200 200 200 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 500 586 627 542 600 600 6362 PROPERTY INSURANCE 999 1,154 1,235 1,031 1,150 1,150 6364 DRAM SHOP INSURANCE 2,380 2,072 2,590 1,961 2,123 2,123 6366 MACHINERY BREAKDOWN INSURANCE 287 282 300 266 300 300 6360 INSURANCE 4,167 4,093 4,752 3,800 4,173 4,173 6380 UTILITY SERVICES 6381 ELECTRIC 15,503 16,145 16,500 16,314 17,000 17,000 6382 GAS 3,133 2,692 4,000 2,049 3,000 3,000 6380 UTILITY SERVICES 18,635 18,837 20,500 18,363 20,000 20,000 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 2,036 804 2,000 124 2,000 2,000 6403 BLDGS/FACILITIES MAINT SERVICE 1,653 1,500 156 1,500 1,500 6400 REPAIR&MAINT SERVICES 2,036 2,457 3,500 280 3,500 3,500 6410 RENTALS 6412 BLDGS/FACILITIES 93,860 93,360 93,360 87,080 93,360 93,360 6410 RENTALS 93,860 93,360 93,360 87,080 93,360 93,360 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 132 127 6422 SOFTWARE MAINT 279 903 263 340 915 915 6423 LOGIS CHARGES 4,360 2,199 4,010 3,795 4,991 4,991 6428 PROTECTION SERVICES 746 590 395 6420 IS SERVICES/LICENSES/FEES 5,516 3,819 4,273 4,531 5,906 5,906 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 700 6432 CONFERENCES AND SCHOOLS 409 321 600 371 600 600 6434 DUES&SUBSCRIPTIONS 968 887 800 922 800 800 6435 CREDIT CARD FEES 22,133 23,690 25,000 20,515 25,000 25,000 6438 CASH SHORT(OVER) 920 1,262 1,000 2,697 1,000 1,000 6430 MISCELLANEOUS 24,430 26,160 28,100 24,505 27,400 27,400 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 65 40 150 20 100 100 6449 OTHER CONTRACTUAL SERVICE 3,195 2,823 3,000 2,419 2,500 2,500 6440 OTHER EXPENSES 3,260 2,863 3,150 2,439 2,600 2,600 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 121 122 160 90 150 150 6462 FIXED CHARGES 536 543 511 492 600 600 6463 REPAIR&MAINT CHARGES 242 70 100 500 500 6465 REPLACEMENT CHARGES 1,125 1,103 1,115 1,021 1,100 1,100 6460 CENTRAL GARAGE CHARGES 2,024 1,839 1,886 1,603 2,350 2,350 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 26,773 27,019 24,741 22,680 25,000 25,000 6470 TRANSFERS AND OTHER USES 26,773 27,019 24,741 22,680 25,000 25,000 352 STORE # 2 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Cade/Description Amount Amount Budget Actual Budget Budget 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 9,237 944 1,000 4,458 5,000 5,000 6490 OTHER MISC COSTS/EXPENSES 9,237 944 1,000 4,458 5,000 5,000 6299 OTHER CHARGES&SERVICES 198,978 188,641 193,962 175,888 198,889 198,889 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6540 EQUIPMENT&MACHINERY 1,908 6501 CAPITAL OUTLAY 1,908 6500 CAPITAL OUTLAY 1,908 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 414,702 388,313 405,195 352,262 391,762 391,762 4000 REVENUES AND EXPENSES 47,130- 38,700- 44,305- 374- 39,510- 39,510- 49612 69TH AVENUE LIQUOR STORE 47,130- 38,700 44,305- 374- 39,510- 39,510- 60900 BROOKLYN CENTER LIQUOR 35,947- 54,124- 17,189- 370,357- 7,662- 7,662- 353 This page has been left blank intentionally. 354 City offtookyn Center 2012 Budget FUND: Centerbrook Golf Course—61300 DEPT/DIVISION/ACTIVITY: Centerbrook Golf Course—49721 PROFILE Centerbrook Golf Course is a nine (9) hole, par three (3) course, owned by the City of Brooklyn Center. It was built in 1986-87 with a loan from the Capital Improvements Fund. It opened for business in the spring of 1988 and was established as an enterprise fund entity. Enterprise funds were established to account for the financing of self- supporting activities of the City, which render services on a user charge basis to the general public. Historically, between 12,000 and 24,000 rounds of golf are played each year at Centerbrook. In addition, about 250 people will take golf lessons. As a result of recent experience, projections for the 2012 budget have been calculated at 15,000 rounds. For the 2012 budget, significant changes are planned for both frill and part-time personnel. The Grounds Superintendent position has been replaced with a Golf Manager position. This position is now responsible for both club house and grounds supervision. Part-time position descriptions and pay rates have been revised to reflect current market conditions. For 2012, revenues and expenses related to beer sales at the Dudley softball tournament are included in this fund. This is permissible, as the golf course holds a liquor license and liquor liability insurance coverage. The current golf course loan repayment schedule is formula based. The formula dictates that the end of year cash balance, minus the first four months of anticipated expenditure in the upcoming year, minus any capital contribution, is to be made as partial payment for the original loan. DEPARTMENTAL GOALS • Enhance marketing efforts (including cross marketing activities with area courses) to attract additional golfers. • Assure that the course and clubhouse is clean and well maintained, so as to compliment marketing efforts. • Pursue cost saving strategies with neighboring golf courses. • Expand league and lesson offerings to raise the number of persons participating. • Continue analysis of merchandise selection, pricing and display for changes that would increase revenues. 355 EXPENDITURE DETAILS 6103 Part-Time $49,000 Clubhouse staff, rangers, part-time golf professional and maintenance workers. 6212 Motor Fuels $2,000 Fuel for mowers and other golf course equipment. 6216 Chemical Products $6,000 Herbicides, insecticides, snow mold treatment and other chemical used to maintain the fairways and greens. 6219 Operating Supplies $2,000 The cost of various supplies such as office supplies, towels, cleaning materials, etc. 6225 Landscape Materials $3,000 Fertilizer, grass seed, sod, etc, plus the cost of flowers in the various planters throughout the course and at the clubhouse. 6307 Other Advertising $6,000 Advertising to promote leagues, open play and tournaments. 6415 Rentals $4,500 The cost of leasing golf carts for rental to patrons. PERSONNEL LEVELS 1-Golf Manager CAPITAL OUTLAY Due to current cash flow projections, no capital investment is planned for 2012.. 356 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 61300 CENTERBROOK GOLF COURSE 49721 CENTERBROOK GOLF COURSE 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 81- 4604 CHECK PROCESSING FEES 30- 4612 DONATIONS&CONTRIBUTIONS 200- 4600 MISCELLANEOUS REVENUE 81- 230- 4599 MISCELLANEOUS REVENUE 81- 230- 4770 CENTERBROOK GOLF COURSE 4771 GOLF LESSONS 1,644- 1,464- 2,000- 1,464- 2,000- 2,000- 4773 GREEN FEES 137,287- 128,750- 152,500- 108,754- 128,000- 128,000- 4778 PASSBOOK 25,688- 23,229- 26,000- 18,855- 23,000- 23,000- 4782 RENTALS 12,524- 11,817- 13,000- 10,432- 10,000- 10,000- 4785 LEAGUE 10,283- 9,809- 13,000- 9,729- 11,000- 11,000- 4786 BEER&WINE COOLER REVENUES 37,135- 24,840- 38,000- 24,325- 28,000- 28,000- 4787 FOOD&BEVERAGE REVENUES 6,424- 5,507- 7,500- 6,051- 6,000- 6,000- 4788 TAXABLE MERCHANDISE 824- 1,081- 1,500- 822- 1,000- 1,000- 4789 NON TAXABLE MERCHANDISE 15,874- 11,023- 15,000- 9,132- 9,700- 9,700- 4790 MISCELLANEOUS 200- 300- 500- 25- 100- 100- 4791 BOTTLED WATER SALES 1,425- 1,339- 1,750- 1,186- 1,200- 1,200- 4770 CENTERBROOK GOLF COURSE 249,309- 219,159- 270,750- 190,775- 220,000- 220,000- 4900 OTHER FINANCING SOURCES 4915 TRANSFERS IN 14,000- 14,000- 4921 REFUNDS&REIMBURSEMENTS 92- 6- 4900 OTHER FINANCING SOURCES 92- 6- 14,000- 14,000- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 4001 REVENUES 249,483- 219,164- 270,750- 191,005- 234,000- 234,000- 6001 EXPENDITURES/EXPENSES 60gg PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 49,282 49,282 49,828 43,429 45,360 45,360 6103 WAGES-PART TIME EMPLOYEES 70,893 68,007 60,000 53,424 49,000 49,000 6104 OVERTIME-PART TIME EMPLOYEES 1,349 872 1,000 1,308 1,000 1,000 6100 WAGES AND SALARIES 121,523 118,161 110,828 98,160 95,360 95,360 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 2,573 1,587 6110 OTHER PAYMENTS-NON INSURANCE 2,573 1,587 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 5,645 6,301 7,720 5,891 7,256 7,256 6125 FICA 7,386 7,012 6,838 5,661 6,205 6,205 6126 MEDICARE CONTRIBUTIONS 1,727 1,640 1,599 1,324 1,452 1,452 6120 RETIREMENT CONTRIBUTIONS 14,758 14,953 16,157 12,876 14,913 14,913 357 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 9,877 10,355 11,280 9,345 10,788 10,788 6130 INSURANCE BENEFITS 9,877 10,355 11,280 9,345 10,788 10,788 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,898 74 6140 UNEMPLOYMENT COMPENSATION 1,898 74 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 2,164 2,788 2,537 1,956 2,021 2,021 6150 WORKER'S COMPENSATION 2,164 2,788 2,537 1,956 2,021 2,021 6099 PERSONAL SERVICES 152,793 147,917 140,802 122,337 123,082 123,082 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 247 57 400 270 400 400 6200 OFFICE SUPPLIES 247 57 400 270 400 400 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 46 71 100 95 100 100 6212 MOTOR FUELS 1,824 1,913 2,000 1,543 2,000 2,000 6213 LUBRICANTS&ADDITIVES 328 55 200 2 200 200 6214 CLOTHING&PERSONAL EQUIPMENT 100 100 100 6215 SHOP MATERIALS 207 41 200 200 200 6216 CHEMICALS/CHEMICAL PRODUCTS 4,696 7,280 5,000 4,347 6,000 6,000 6217 SAFETY SUPPLIES 71 77 200 28 100 100 6219 GENERAL OPERATING SUPPLIES 2,741 869 1,750 2,180 2,000 2,000 6210 OPERATING SUPPLIES 9,914 10,306 9,550 8,196 10,700 10,700 6220 REPAIR&MAINT SUPPLIES 6221 MOTOR VEHICLES 1,823 268 500 638 300 300 6223 BUILDINGS&FACILITIES 1,026 2,227 2,000 1,733 2,000 2,000 6225 PARK&LANDSCAPE MATERIALS 3,916 2,774 3,000 2,052 3,000 3,000 6227 PAINT SUPPLIES 254 148 250 83 200 200 6220 REPAIR&MAINT SUPPLIES 7,019 5,417 5,750 4,507 5,500 5,500 6230 REPAIR&MAINT SUPPLIES-OTHER 6239 OTHER REPAIR&MAINT SUPPLIES 328 165 400 71 300 300 6230 REPAIR&MAINT SUPPLIES-OTHER 328 165 400 71 300 300 6240 SMALL TOOLS&MINOR EQUIPMENT 6241 SMALL TOOLS 161 135 300 190 250 250 6242 MINOR EQUIPMENT 575 319 500 589 500 500 6243 MINOR COMPUTER EQUIPMENT 611 6240 SMALL TOOLS&MINOR EQUIPMENT 736 1,066 800 779 750 750 6199 SUPPLIES 18,245 17,011 16,900 13,824 17,650 17,650 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 632 262 750 575 600 600 6300 PROFESSIONAL SERVICES 632 262 750 575 600 600 6320 COMMUNICATIONS 358 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6321 TELEPHONE/PAGERS 3,245 2,391 900 1,215 1,550 1,550 6329 OTHER COMMUNICATION SERVICES 850 722 850 850 6320 COMMUNICATIONS 3,245 2,391 1,750 1,937 2,400 2,400 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 842 775 750 818 750 750 6330 TRANSPORTATION 842 775 750 818 750 750 6340 ADVERTISING 6349 OTHER ADVERTISING 977 1,523 2,000 597 6,000 6,000 6340 ADVERTISING 977 1,523 2,000 597 6,000 6,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 182 142 800 6350 PRINTING AND DUPLICATING 182 142 800 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 3,377 3,391 4,250 3,914 4,188 4,188 6362 PROPERTY INSURANCE 1,557 1,592 1,990 1,847 1,976 1,976 6364 DRAM SHOP INSURANCE 1,849 2,248 2,810 1,110 1,188 1,188 6366 MACHINERY BREAKDOWN INSURANCE 262 254 315 311 335 335 6360 INSURANCE 7,045 7,485 9,365 7,183 7,687 7,687 6380 UTILITY SERVICES 6381 ELECTRIC 7,025 7,817 6,750 7,444 7,200 7,200 6382 GAS 1,187 1,091 1,500 809 1,300 1,300 6383 WATER 9,658 11,288 7,000 3,587 10,000 10,000 6384 REFUSE DISPOSAL 2,292 1,748 1,800 1,393 2,000 2,000 6385 SEWER 506 511 600 395 600 600 6386 STORM SEWER 994 1,004 1,000 761 1,000 1,000 6380 UTILITY SERVICES 21,664 23,460 18,650 14,390 22,100 22,100 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 325 6403 BLDGS/FACILITIES MAINT SERVICE 1,826 2,797 2,000 636 2,000 2,000 6400 REPAIR&MAINT SERVICES 2,151 2,797 2,000 636 2,000 2,000 6410 RENTALS 6415 OTHER EQUIPMENT 4,463 4,463 4,500 6,045 4,500 4,500 6410 RENTALS 4,463 4,463 4,500 6,045 4,500 4,500 6420 IS SERVICES/LICENSES/FEES 6422 SOFTWARE MAINT 290 276 299 247 299 299 6423 LOGIS CHARGES 3,036 4,086 3,661 2,746 4,271 4,271 6420 IS SERVICES/LICENSES/FEES 3,326 4,362 3,960 2,993 4,570 4,570 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 163 150 250 476 250 250 6434 DUES&SUBSCRIPTIONS 853 923 750 985 750 750 6435 CREDIT CARD FEES 2,837 2,922 2,600 3,103 3,000 3,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 67 6438 CASH SHORT(OVER) 994 65- 476 6430 MISCELLANEOUS 4,914 3,930 3,600 5,039 4,000 4,000 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 311 237 250 279 250 250 359 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6449 OTHER CONTRACTUAL SERVICE 1,032 1,921 1,500 601 1,500 1,500 6440 OTHER EXPENSES 1,343 2,158 1,750 879 1,750 1,750 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 5 6462 FIXED CHARGES 6,638 6,728 6,365 6,054 6,776 6,776 6463 REPAIR&MAINT CHARGES 8,612 7,161 8,400 4,970 8,652 8,652 6465 REPLACEMENT CHARGES 13,396 13,362 15,173 13,906 14,623 14,623 6460 CENTRAL GARAGE CHARGES 28,650 27,251 29,938 24,931 30,051 30,051 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 9,375 21,377 9,855 9,034 9,855 9,855 6470 TRANSFERS AND OTHER USES 9,375 21,377 9,855 9,034 9,855 9,855 6490 OTHER MISC COSTS/EXPENSES 6491 MERCHANDISE FOR RESALE 29,472 19,090 23,000 22,033 22,500 22,500 6494 DEPRECIATION EXPENSE 28,185 28,185 31,700 25,836 28,183 28,183 6490 OTHER MISC COSTS/EXPENSES 57,656 47,274 54,700 47,869 50,683 50,683 6299 OTHER CHARGES&SERVICES 146,466 149,650 144,368 122,926 146,946 146,946 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6520 BUILDINGS&FACILITIES 1,342 6501 CAPITAL OUTLAY 1,342 6500 CAPITAL OUTLAY 1,342 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 318,846 314,578 302,070 259,087 287,678 287,678 4000 REVENUES AND EXPENSES 69,363 95,413 31,320 68,082 53,678 53,678 49721 CENTERBROOK GOLF COURSE 69,363 95,413 31,320 68,082 53,678 53,678 61300 CENTERBROOK GOLF COURSE 69,363 95,413 31,320 68,082 53,678 53,678 360 City of Brook&n Center 2012 Budget FUND: Earle Brown Heritage Center—61700 DEPT/ACTIVITY/PROJECT: Summary—49851, 49852, 49853, 49854 PROFILE The following pages provide a summary presentation of the budget plan for the entire Earle Brown Heritage Center operation. Following the summary are the individual divisional plans that make up the summary plan. 361 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/3012011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual 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- 3,250- 5,538- 6,767- 6,767- 4604 CHECK PROCESSING FEES 30- 30- 4605 UNREALIZED INVESTMENT GAIN/LOS 266- 2,615 4606 OTHER REVENUE 372- 75- 2,164- 4609 UNCOLLECTIBLE WRITE OFFS 11,552 4600 MISCELLANEOUS REVENUE 11,362- 9,824 3,250- 7,732- 6,767- 6,767- 4599 MISCELLANEOUS REVENUE 11,362- 9,824 3,250- 7,732- 6,767- 6,767- 4800 EBHC 4810 INN ON THE FARM 4820 CONVENTION CENTER 4821 ROOM RENTALS 623,785- 579,419- 675,000- 594,844- 720,000- 720,000- 4821.1 CMP ROOM RENTALS 25,000- 4821 ROOM RENTALS 623,785- 579,419- 700,000- 594,844- 720,000- 720,000- 4822 LABOR CHARGES 10,740- 10,520- 10,800- 19,670- 12,850- 12,850- 4823 EQUIPMENT RENTALS 248,709- 295,322- 290,000- 334,291- 300,000- 300,000- 4823.1 CMP EQUIPMENT RENTALS 1,000- 4823 EQUIPMENT RENTALS 248,709- 295,322- 291,000- 334,291- 300,000- 300,000- 4827 SECURITY SERVICES 23,975- 21,125- 21,000- 24,808- 26,000- 26,000- 4828 CLIENT SERVICES 37,834- 40,640- 43,200- 45,846- 50,500- 50,500- 4829 MISCELLANEOUS 2,535- 3,705- 3,000- 2,535- 3,000- 3,000- 4820 CONVENTION CENTER 947,578- 950,731- 1,069,000- 1,021,994- 1,112,350- 1,112,350- 4830 OFFICE RENTAL 4831 OFFICE RENTALS 25,680- 101,660- 25,680- 23,540- 99,480- 99,480- 4830 OFFICE RENTAL 25,680- 101,660- 25,680- 23,540- 99,480- 99,480- 4840 CATERING SERVICES 4842 SERVICE CHARGES 384,036- 429,929- 410,000- 438,950- 516,650- 516,650- 4844 FOOD&BEVERAGE SALES 1,859,779- 2,033,558- 2,134,999- 2,067,180- 2,198,500- 2,198,500- 4845 LIQUORM/INE/BEER SALES 284,928- 282,835- 295,000- 275,766- 302,000- 302,000- 4848 MISCELLANEOUS SALES 40,075- 47,230- 41,001- 39,698- 40,992- 40,992- 4840 CATERING SERVICES 2,568,819- 2,793,552- 2,881,000- 2,821,594- 3,058,142- 3,058,142- 4800 EBHC 3,542,077- 3,845,943- 3,975,680- 3,867,128- 4,269,972- 4,269,972- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 113,516- 110,168- 4921 REFUNDS&REIMBURSEMENTS 244- 10- 59,010- 4900 OTHER FINANCING SOURCES 113,760- 110,178- 59,010- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES-LABOR 1,168,497 1,199,944 1,342,477 1,172,230 1,319,621 1,319,621 5592 COST OF SALES-FOOD 415,028 509,847 495,210 540,164 565,748 565,748 5593 COST OF SALES-SUPPLIES 130,740 139,760 123,104 131,333 128,115 128,115 362 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 5594 COST OF SALES-MGMT FEES 102,600 105,023 108,600 99,550 111,600 111,600 5590 EBHC CONTRACT EXPENSES 1,816,865 1,954,574 2,069,391 1,943,276 2,125,084 2,125,084 5550 DIRECT COST OF SALES 1,816,865 1,954,574 2,069,391 1,943,276 2,125,084 2,125,084 4001 REVENUES 1,850,334- 1,991,722- 1,909,539- 1,990,594- 2,151,655- 2,151,655- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 526,619 466,372 525,043 474,025 547,663 547,663 6102 OVERTIME-FT EMPLOYEES 713 1,152 809 6103 WAGES-PART TIME EMPLOYEES 169,099 166,836 188,449 157,635 180,800 180,800 6104 OVERTIME-PART TIME EMPLOYEES 39 213 67 6100 WAGES AND SALARIES 696,469 634,575 713,492 632,535 728,463 728,463 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 9,771 6,153 6110 OTHER PAYMENTS-NON INSURANCE 9,771 6,153 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 44,726 42,178 49,944 43,379 52,886 52,886 6125 FICA 44,047 40,595 44,238 39,721 45,226 45,226 6126 MEDICARE CONTRIBUTIONS 10,301 9,494 10,346 9,290 10,578 10,578 6120 RETIREMENT CONTRIBUTIONS 99,074 92,267 104,528 92,390 108,690 108,690 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 97,678 93,002 124,080 91,328 118,668 118,668 6130 INSURANCE BENEFITS 97,678 93,002 124,080 91,328 118,668 118,668 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,232 857 2,090 6140 UNEMPLOYMENT COMPENSATION 1,232 857 2,090 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 22,625 23,685 24,446 18,571 21,482 21,482 6150 WORKER'S COMPENSATION 22,625 23,685 24,446 18,571 21,482 21,482 6099 PERSONAL SERVICES 926,848 850,538 966,546 836,915 977,303 977,303 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,780 3,762 3,604 2,404 3,604 3,604 6202 COPYING SUPPLIES 1,569 2,224 1,550 1,746 1,550 1,550 6203 BOOKS/REFERENCE MATERIALS 38 100 25 100 100 6200 OFFICE SUPPLIES 3,349 6,024 5,254 4,175 5,254 5,254 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 3,989 4,654 5,592 1,766 4,792 4,792 6212 MOTOR FUELS 33 100 61 100 100 6214 CLOTHING&PERSONAL EQUIPMENT 540 802 1,000 799 1,000 1,000 6215 SHOP MATERIALS 589 153 548 518 648 648 6216 CHEMICALS/CHEMICAL PRODUCTS 4,445 4,832 6,600 2,541 5,600 5,600 6217 SAFETY SUPPLIES 856 908 1,344 895 1,348 1,348 6219 GENERAL OPERATING SUPPLIES 25,471 26,239 30,596 25,312 30,800 30,800 6210 OPERATING SUPPLIES 35,890 37,621 45,780 31,892 44,288 44,288 363 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11130/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6220 REPAIR&MAINT SUPPLIES 6223 BUILDINGS&FACILITIES 15,988 21,571 27,448 19,453 24,000 24,000 6225 PARK&LANDSCAPE MATERIALS 2,418 2,704 4,700 1,657 4,700 4,700 6226 SIGNS&STRIPING MATERIALS 835 14 600 447 600 600 6227 PAINT SUPPLIES 2,546 1,981 2,746 1,446 2,746 2,746 6220 REPAIR&MAINT SUPPLIES 21,788 26,269 35,494 23,003 32,046 32,046 6230 REPAIR&MAINT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 50 97 50 50 6239 OTHER REPAIR&MAINT SUPPLIES 4,093 7,324 7,296 5,370 7,296 7,296 6230 REPAIR&MAINT SUPPLIES-OTHER 4,093 7,324 7,346 5,467 7,346 7,346 6240 SMALL TOOLS&MINOR EQUIPMENT 6241 SMALL TOOLS 799 1,072 1,226 525 1,226 1,226 6242 MINOR EQUIPMENT 38,412 53,344 60,534 35,386 69,484 69,484 6243 MINOR COMPUTER EQUIPMENT 4,745 6,105 2,600 2,520 27,950 27,950 6240 SMALL TOOLS&MINOR EQUIPMENT 43,956 60,521 64,360 38,431 98,660 98,660 6199 SUPPLIES 109,075 137,759 158,234 102,969 187,594 187,594 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG,AUDIT&FIN'L SERVICES 3,057 2,965 3,000 3,345 3,000 3,000 6303 LEGAL SERVICES 506 738 500 33 500 500 6307 PROFESSIONAL SERVICES 16,723 32,643 41,150 42,045 36,650 36,650 6300 PROFESSIONAL SERVICES 20,285 36,346 44,650 45,423 40,150 40,150 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 8,303 7,928 6,750 5,050 6,736 6,736 6322 POSTAGE 1,414 1,579 3,400 1,615 2,900 2,900 6320 COMMUNICATIONS 9,718 9,508 10,150 6,665 9,636 9,636 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 1,138 739 1,200 640 1,200 1,200 6333 FREIGHT/DRAYAGE 276 195 444 212 296 296 6330 TRANSPORTATION 1,414 934 1,644 852 1,496 1,496 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 1,060 958 2,304 912 2,300 2,300 6349 OTHER ADVERTISING 88,053 83,294 83,125 67,225 90,535 90,535 6340 ADVERTISING 89,113 84,253 85,429 68,137 92,835 92,835 6350 PRINTING AND DUPLICATING 6351 PRINTING 7,191 5,453 12,980 14,652 12,980 12,980 6350 PRINTING AND DUPLICATING 7,191 5,453 12,980 14,652 12,980 12,980 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 15,352 12,551 15,309 13,644 16,178 16,178 6362 PROPERTY INSURANCE 30,662 33,164 38,179 34,307 40,825 40,825 6366 MACHINERY BREAKDOWN INSURANCE 1,936 1,900 2,184 1,909 2,251 2,251 6360 INSURANCE 47,949 47,615 55,672 49,860 59,254 59,254 6380 UTILITY SERVICES 6381 ELECTRIC 110,985 120,742 120,370 125,141 130,000 130,000 6382 GAS 39,771 53,812 82,370 34,025 64,400 64,400 364 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11130/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6383 WATER 1,801 2,339 2,060 2,474 2,800 2,800 6384 REFUSE DISPOSAL 9,290 9,031 10,096 7,818 10,096 10,096 6385 SEWER 2,525 4,274 4,084 4,419 4,500 4,500 6386 STORM SEWER 2,168 3,076 3,100 2,897 3,300 3,300 6389 STREET LIGHTS 380 549 552 519 620 620 6380 UTILITY SERVICES 166,919 193,823 222,632 177,292 215,716 215,716 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 36,744 42,166 56,700 42,054 56,700 56,700 6403 BLDGS/FACILITIES MAINT SERVICE 3,741 4,351 7,500 4,498 7,500 7,500 6406 MULTI-FUNCTION MTNCE 286 4,450 4,450 6408 COMMUNICATION/INFO SYSTEMS 81 6409 OTHER REPAIR&MAINT SVCS 1,199 1,417 1,704 1,199 1,704 1,704 6400 REPAIR&MAINT SERVICES 41,684 47,934 65,904 48,117 70,354 70,354 6410 RENTALS 6413 OFFICE EQUIPMENT 6,067 5,908 5,700 5,368 3,320 3,320 6415 OTHER EQUIPMENT 103,600 114,289 108,296 153,555 110,996 110,996 6419 OTHER RENTAL EXPENSE 1,539 1,539- 6410 RENTALS 109,667 121,735 113,996 157,384 114,316 114,316 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 294 6422 SOFTWARE MAINT 2,593 4,825 5,500 4,673 5,500 5,500 6423 LOGIS CHARGES 15,498 18,429 19,816 15,709 23,463 23,463 6428 PROTECTION SERVICES 13,890 18,013 15,000 18,350 17,000 17,000 6420 IS SERVICES/LICENSES/FEES 31,982 41,268 40,316 39,026 45,963 45,963 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 7,440 232 8,400 5,646 8,400 8,400 6433 MEETING EXPENSES 1,967 834 882 457 900 900 6434 DUES&SUBSCRIPTIONS 3,681 2,810 4,170 2,671 3,070 3,070 6435 CREDIT CARD FEES 15,186 16,924 13,526 21,406 21,000 21,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 13,455 10,104- 5,000 5,000 6438 CASH SHORT(OVER) 103- 34- 96- 6430 MISCELLANEOUS 41,626 10,663 26,978 30,083 38,370 38,370 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 22,137 5,429 5,279 10,000 10,000 6442 COURT AWARDS/SETTLEMENTS 1,052 6449 OTHER CONTRACTUAL SERVICE 33,152 39,209 36,103 28,184 38,903 38,903 6440 OTHER EXPENSES 56,341 44,638 36,103 33,463 48,903 48,903 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 68,001 74,256 74,656 68,435 74,656 74,656 6476 CAPITAL PROJECT FUND TRANSFER 300,000 200,000 200,000 200,000 6470 TRANSFERS AND OTHER USES 368,001 74,256 274,656 68,435 274,656 274,656 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 624,329 628,867 712,919 579,779 666,375 666,375 6490 OTHER MISC COSTS/EXPENSES 624,329 628,867 712,919 579,779 666,375 666,375 6299 OTHER CHARGES&SERVICES 1,616,217 1,347,293 1,704,029 1,319,168 1,691,004 1,691,004 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 365 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6520 BUILDINGS&FACILITIES 61,510 6540 EQUIPMENT&MACHINERY 5,049 6501 CAPITAL OUTLAY 66,559 6500 CAPITAL OUTLAY 66,559 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 2,652,141 2,335,589 2,828,809 2,325,611 2,855,901 2,855,901 4000 REVENUES AND EXPENSES 801,807 343,867 919,270 335,016 704,246 704,246 61700 EARLE BROWN HERITAGE CENTER 801,807 343,867 919,270 335,016 704,246 704,246 366 City of Broo� Center 2012 Budget FUND: Earle Brown Heritage Center—61700 DEPT/ACTIVITY/PROJECT: Administration—49851 PROFILE The Administration division provides overall administrative duties for the entire complex including, but not limited to, commercial office, convention center, and catering DEPARTMENTAL GOALS • Oversee and support the work of the various divisions within the complex. • Provide a high level of customer service to guests and vendors. EXPENDITURE DETAILS 6242 Minor Equipment $3,950 Main office boardroom updating with curtains, LCD monitor & decor. PERSONNEL LEVELS 1-EBHC Manager 1- Secretary/Receptionist 1-Secretary/Billing Clerk CAPITAL OUTLAY See Capital Projects Fund 367 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11130/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual 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 10,695- 4,268- 3,250- 5,538- 6,767- 6,767- 4604 CHECK PROCESSING FEES 30- 4605 UNREALIZED INVESTMENT GAIN/LOS 266- 2,615 4606 OTHER REVENUE 285- 4600 MISCELLANEOUS REVENUE 11,246- 1,653- 3,250- 5,568- 6,767- 6,767- 4599 MISCELLANEOUS REVENUE 11,246- 1,653- 3,250- 5,568- 6,767- 6,767- 4900 OTHER FINANCING SOURCES 4921 REFUNDS&REIMBURSEMENTS 244- 10- 4900 OTHER FINANCING SOURCES 244- 10- 4001 REVENUES 11,490- 1,663- 3,250- 5,568- 6,767- 6,767- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 160,853 114,400 155,655 141,393 161,716 161,716 6102 OVERTIME-FT EMPLOYEES 273 464 6100 WAGES AND SALARIES 160,853 114,673 155,655 141,857 161,716 161,716 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 2,335 2,332 6110 OTHER PAYMENTS-NON INSURANCE 2,335 2,332 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 10,855 8,040 10,896 10,285 11,724 11,724 6125 FICA 10,119 7,251 9,651 8,859 10,026 10,026 6126 MEDICARE CONTRIBUTIONS 2,367 1,696 2,257 2,072 2,345 2,345 6120 RETIREMENT CONTRIBUTIONS 23,341 16,987 22,804 21,215 24,095 24,095 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 29,649 25,875 33,840 24,100 32,364 32,364 6130 INSURANCE BENEFITS 29,649 25,875 33,840 24,100 32,364 32,364 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 1,316 1,839 1,463 1,179 1,342 1,342 6150 WORKER'S COMPENSATION 1,316 1,839 1,463 1,179 1,342 1,342 6099 PERSONAL SERVICES 217,493 161,706 213,762 188,351 219,517 219,517 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 76 336 6200 OFFICE SUPPLIES 76 336 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 35 6210 OPERATING SUPPLIES 35 368 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6220 REPAIR&MAINT SUPPLIES 6240 SMALL TOOLS&MINOR EQUIPMENT 6242 MINOR EQUIPMENT 839 1,690 3,950 3,950 6243 MINOR COMPUTER EQUIPMENT 917 1,412 900 834 850 850 6240 SMALL TOOLS&MINOR EQUIPMENT 1,755 1,412 900 2,523 4,800 4,800 6199 SUPPLIES 1,867 1,748 900 2,523 4,800 4,800 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG,AUDIT&FIN'L SERVICES 3,057 2,965 3,000 3,345 3,000 3,000 6303 LEGAL SERVICES 339 141 500 500 500 6307 PROFESSIONAL SERVICES 3,254 7,508 2,500 3,480 2,500 2,500 6300 PROFESSIONAL SERVICES 6,649 10,614 6,000 6,825 6,000 6,000 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,200 1,168 900 750 900 900 6320 COMMUNICATIONS 1,200 1,168 900 750 900 900 6330 TRANSPORTATION 6340 ADVERTISING 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 3,226 2,803 3,264 2,705 3,434 3,434 6362 PROPERTY INSURANCE 7,593 8,291 9,545 8,577 10,864 10,864 6366 MACHINERY BREAKDOWN INSURANCE 481 475 545 477 583 583 6360 INSURANCE 11,300 11,569 13,354 11,759 14,881 14,881 6400 REPAIR&MAINT SERVICES 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 294 6422 SOFTWARE MAINT 2,593 4,825 5,500 4,673 5,500 5,500 6423 LOGIS CHARGES 15,498 18,429 19,816 15,709 23,463 23,463 6420 IS SERVICES/LICENSES/FEES 18,092 23,254 25,316 20,677 28,963 28,963 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,684 2,400 695 2,400 2,400 6430 MISCELLANEOUS 1,684 2,400 695 2,400 2,400 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 140 6440 OTHER EXPENSES 140 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 68,001 74,256 74,656 68,435 74,656 74,656 6476 CAPITAL PROJECT FUND TRANSFER 300,000 200,000 200,000 200,000 6470 TRANSFERS AND OTHER USES 368,001 74,256 274,656 68,435 274,656 274,656 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 25,633 25,633 29,412 23,624 29,325 29,325 369 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/3012011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6490 OTHER MISC COSTS/EXPENSES 25,633 25,633 29,412 23,624 29,325 29,325 6299 OTHER CHARGES&SERVICES 432,698 146,495 352,038 132,764 357,125 357,125 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 652,058 309,949 566,700 323,638 581,442 581,442 4000 REVENUES AND EXPENSES 640,568 308,286 563,450 318,070 574,675 574,675 49851 EBHC-ADMINISTRATION 640,568 308,286 563,450 318,070 574,675 574,675 370 City of Brook& Center 2012 Budget FUND: Earle Brown Heritage Center—61700 DEPT/ACTIVITY/PROJECT: Convention Center—49852 PROFILE The Convention Center, in conjunction with the Catering Department, provides a full service conference and event location. Economic impact directly affecting Brooklyn Center includes hotel, restaurant, shopping and convention service related business activity (floral, printing, rental, etc.) DEPARTMENTAL GOALS • Promote the facility in accordance with the 2012 Marketing Plan. • Participate in five industry associations to network for referral business. • Add a minimum of ten new corporate clients. • Participate in four trade show opportunities to promote the Heritage Center in the marketplace. • Combine out-state and out-of-state advertising with the Minneapolis Northwest Convention and Visitor's Bureau to attract new business. • Continue to reduce our energy usage through retro-fitting fixtures and following ReTap Engineering study. • Actively work with the Embassy Suites for future business development that is complimentary and lucrative to both facilities. EXPENDITURE DETAILS PERSONNEL LEVELS 1- Sales Director 2- Sales Managers 1- Operations Director 2- Maintenance Custodians 2- Crew Chiefs Plus part-time staff positions which include set-up crew, custodians, and maintenance. CAPITAL OUTLAY See Capital Projects Fund 371 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 49852 EBHC-CONVENTION CENTER 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4604 CHECK PROCESSING FEES 30- 4606 OTHER REVENUE 86- 75- 2,164- 4609 UNCOLLECTIBLE WRITE OFFS 4,586 4600 MISCELLANEOUS REVENUE 116- 4,511 2,164- 4599 MISCELLANEOUS REVENUE 116- 4,511 2,164- 4800 EBHC 4820 CONVENTION CENTER 4821 ROOM RENTALS 623,785- 579,419- 675,000- 594,844- 720,000- 720,000- 4821.1 CMP ROOM RENTALS 25,000- 4821 ROOM RENTALS 623,785- 579,419- 700,000- 594,844- 720,000- 720,000- 4822 LABOR CHARGES 10,740- 10,520- 10,800- 19,670- 12,850- 12,850- 4823 EQUIPMENT RENTALS 248,709- 295,322- 290,000- 334,291- 300,000- 300,000- 4823.1 CMP EQUIPMENT RENTALS 1,000- 4823 EQUIPMENT RENTALS 248,709- 295,322- 291,000- 334,291- 300,000- 300,000- 4827 SECURITY SERVICES 23,975- 21,125- 21,000- 24,808- 26,000- 26,000- 4828 CLIENT SERVICES 37,834- 40,640- 43,200- 45,846- 50,500- 50,500- 4829 MISCELLANEOUS 2,535- 3,705- 3,000- 2,535- 3,000- 3,000- 4820 CONVENTION CENTER 947,578- 950,731- 1,069,000- 1,021,994- 1,112,350- 1,112,350- 4800 EBHC 947,578- 950,731- 1,069,000- 1,021,994- 1,112,350- 1,112,350- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 113,516- 110,168- 4921 REFUNDS&REIMBURSEMENTS 59,010- 4900 OTHER FINANCING SOURCES 113,516- 110,168- 59,010- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 4001 REVENUES 1,061,210- 1,056,388- 1,069,000- 1,083,168- 1,112,350- 1,112,350- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 343,987 328,230 368,388 310,136 385,947 385,947 6102 OVERTIME-FT EMPLOYEES 667 682 345 6103 WAGES-PART TIME EMPLOYEES 126,929 121,035 134,000 113,898 129,000 129,000 6104 OVERTIME-PART TIME EMPLOYEES 39 156 52 6100 WAGES AND SALARIES 471,622 450,103 502,388 424,431 514,947 514,947 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 7,436 3,821 6110 OTHER PAYMENTS-NON INSURANCE 7,436 3,821 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 30,493 30,271 35,167 29,363 37,336 37,336 6125 FICA 29,979 29,010 31,149 26,741 31,927 31,927 6126 MEDICARE CONTRIBUTIONS 7,012 6,785 7,285 6,255 7,467 7,467 372 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/3012011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6120 RETIREMENT CONTRIBUTIONS 67,484 66,066 73,601 62,359 76,730 76,730 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 68,029 67,127 90,240 67,228 86,304 86,304 6130 INSURANCE BENEFITS 68,029 67,127 90,240 67,228 86,304 86,304 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,232 857 2,090 6140 UNEMPLOYMENT COMPENSATION 1,232 857 2,090 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 18,018 18,037 19,994 14,373 17,836 17,836 6150 WORKER'S COMPENSATION 18,018 18,037 19,994 14,373 17,836 17,836 6099 PERSONAL SERVICES 633,822 606,011 686,223 570,481 695,817 695,817 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,419 2,130 2,300 1,516 2,300 2,300 6202 COPYING SUPPLIES 938 1,539 950 1,086 950 950 6203 BOOKS/REFERENCE MATERIALS 38 100 25 100 100 6200 OFFICE SUPPLIES 2,358 3,707 3,350 2,627 3,350 3,350 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 3,989 4,374 5,300 1,562 4,500 4,500 6212 MOTOR FUELS 33 100 61 100 100 6214 CLOTHING&PERSONAL EQUIPMENT 540 791 1,000 767 1,000 1,000 6215 SHOP MATERIALS 589 153 500 518 600 600 6216 CHEMICALS/CHEMICAL PRODUCTS 4,445 4,832 6,300 2,272 5,300 5,300 6217 SAFETY SUPPLIES 494 564 696 573 700 700 6219 GENERAL OPERATING SUPPLIES 23,805 25,853 29,796 25,113 30,000 30,000 6210 OPERATING SUPPLIES 33,861 36,601 43,692 30,865 42,200 42,200 6220 REPAIR&MAINT SUPPLIES 6223 BUILDINGS&FACILITIES 14,397 15,377 24,448 16,550 20,000 20,000 6225 PARK&LANDSCAPE MATERIALS 2,418 2,704 4,400 1,657 4,400 4,400 6226 SIGNS&STRIPING MATERIALS 607 14 300 268 300 300 6227 PAINT SUPPLIES 2,506 1,911 2,500 1,446 2,500 2,500 6220 REPAIR&MAINT SUPPLIES 19,929 20,005 31,648 19,921 27,200 27,200 6230 REPAIR&MAINT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 50 97 50 50 6239 OTHER REPAIR&MAINT SUPPLIES 3,590 7,200 5,196 3,860 5,196 5,196 6230 REPAIR&MAINT SUPPLIES-OTHER 3,590 7,200 5,246 3,957 5,246 5,246 6240 SMALL TOOLS&MINOR EQUIPMENT 6241 SMALL TOOLS 799 1,072 1,226 513 1,226 1,226 6242 MINOR EQUIPMENT 20,561 41,209 41,534 14,829 41,534 41,534 6243 MINOR COMPUTER EQUIPMENT 2,342 1,773 13,125 13,125 6240 SMALL TOOLS&MINOR EQUIPMENT 23,701 44,054 42,760 15,342 55,885 55,885 6199 SUPPLIES 83,439 111,568 126,696 72,712 133,881 133,881 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6303 LEGAL SERVICES 167 597 33 373 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11130/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6307 PROFESSIONAL SERVICES 13,469 25,135 38,650 38,565 20,575 20,575 6300 PROFESSIONAL SERVICES 13,636 25,732 38,650 38,598 20,575 20,575 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 5,840 5,441 4,914 3,520 4,900 4,900 6322 POSTAGE 1,080 931 3,000 1,305 2,500 2,500 6320 COMMUNICATIONS 6,919 6,372 7,914 4,825 7,400 7,400 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 1,138 739 1,200 640 1,200 1,200 6333 FREIGHT/DRAYAGE 254 195 348 212 200 200 6330 TRANSPORTATION 1,392 934 1,548 852 1,400 1,400 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 1,060 958 2,304 912 2,300 2,300 6349 OTHER ADVERTISING 55,837 37,976 40,101 25,635 46,273 46,273 6340 ADVERTISING 56,897 38,934 42,405 26,547 48,573 48,573 6350 PRINTING AND DUPLICATING 6351 PRINTING 4,122 3,599 7,500 5,812 7,500 7,500 6350 PRINTING AND DUPLICATING 4,122 3,599 7,500 5,812 7,500 7,500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 6,221 4,967 6,119 5,795 6,755 6,755 6362 PROPERTY INSURANCE 9,315 10,281 11,835 10,635 12,384 12,384 6366 MACHINERY BREAKDOWN INSURANCE 588 589 677 592 690 690 6360 INSURANCE 16,124 15,837 18,631 17,022 19,829 19,829 6380 UTILITY SERVICES 6381 ELECTRIC 90,125 98,592 95,000 101,406 99,000 99,000 6382 GAS 17,396 23,833 33,892 15,064 27,000 27,000 6383 WATER 863 1,029 1,200 1,065 1,200 1,200 6384 REFUSE DISPOSAL 1,681 1,914 2,100 1,343 2,100 2,100 6385 SEWER 1,271 1,933 2,000 1,811 2,000 2,000 6386 STORM SEWER 1,142 1,538 1,800 1,403 1,800 1,800 6389 STREET LIGHTS 200 275 300 257 300 300 6380 UTILITY SERVICES 112,678 129,113 136,292 122,350 133,400 133,400 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 15,313 31,623 35,700 26,113 35,700 35,700 6403 BLDGS/FACILITIES MAINT SERVICE 2,063 2,003 3,000 2,453 3,000 3,000 6406 MULTI-FUNCTION MTNCE 286 2,725 2,725 6408 COMMUNICATION/INFO SYSTEMS 81 6409 OTHER REPAIR&MAINT SVCS 109 300 300 300 6400 REPAIR&MAINT SERVICES 17,376 33,734 39,000 28,933 41,725 41,725 6410 RENTALS 6413 OFFICE EQUIPMENT 3,839 3,535 3,500 3,241 2,310 2,310 6415 OTHER EQUIPMENT 103,600 112,039 107,300 153,555 110,000 110,000 6419 OTHER RENTAL EXPENSE 1,539 1,539- 6410 RENTALS 107,439 117,113 110,800 155,257 112,310 112,310 6420 IS SERVICES/LICENSES/FEES 6428 PROTECTION SERVICES 13,890 18,013 15,000 18,350 17,000 17,000 6420 IS SERVICES/LICENSES/FEES 13,890 18,013 15,000 18,350 17,000 17,000 374 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 4,292 232 4,500 3,607 4,500 4,500 6433 MEETING EXPENSES 1,967 834 882 457 900 900 6434 DUES&SUBSCRIPTIONS 3,646 2,810 4,100 2,671 3,000 3,000 6435 CREDIT CARD FEES 1,950 2,178 1,750 3,049 4,000 4,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 2,875 2,706- 6438 CASH SHORT(OVER) 6 1- 55- 6430 MISCELLANEOUS 14,736 3,347 11,232 9,728 12,400 12,400 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 186 200 200 6442 COURT AWARDS/SETTLEMENTS 1,052 6449 OTHER CONTRACTUAL SERVICE 19,788 23,371 18,600 15,558 21,400 21,400 6440 OTHER EXPENSES 21,025 23,571 18,600 15,758 21,400 21,400 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 296,044 300,582 338,154 278,143 318,600 318,600 6490 OTHER MISC COSTS/EXPENSES 296,044 300,582 338,154 278,143 318,600 318,600 6299 OTHER CHARGES&SERVICES 682,278 716,881 785,726 722,174 762,112 762,112 6500 CAPITAL OUTLAY 6520 BUILDINGS&FACILITIES 61,510 6540 EQUIPMENT&MACHINERY 5,049 6500 CAPITAL OUTLAY 66,559 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 1,399,539 1,434,460 1,598,645 1,431,926 1,591,810 1,591,810 4000 REVENUES AND EXPENSES 338,329 378,072 529,645 348,758 479,460 479,460 49852 EBHC-CONVENTION CENTER 338,329 378,072 529,645 348,758 479,460 479,460 375 This page has been left blank intentionally. 376 City of Brook�fjn Center 2012 ftfget FUND: Earle Brown Heritage Center—61700 DEPT/ACTIVITY/PROJECT: Catering—49853 PROFILE The Catering Division of the Heritage Center prepares, and services all food and beverage-related activity. A management contract exists with Flik International, Rye Brook, New York, to oversee this division at the direction of the Heritage Center General Manager. Flik creates menus, determines food pricing, hires staff, and provides food and beverage to facility clients. Contractually, Flik International maintains an inventory of food and small wares, maintains the kitchen and service areas, and services all food-related functions. DEPARTMENTAL GOALS • Provide a high level of quality product to facility clients. • Continue to create menu solutions that meet client needs. • Maintain competitive purchase pricing. • Develop new menu items and increase pricing competitive with the marketplace. • Maintain a clean and safe work environment. EXPENDITURE DETAILS Object codes 5591, 5592, 5593 and 5595 are Flik costs for catering. A base contracted management fee of $111,600 is paid to Flik International. All other object codes used reflect catering related expenses paid by the Earle Brown Heritage Center. 6242 Minor Equipment $24,000 Purchase of a new banquet hot cart $12,000. Purchase of china, glass, and silver per Flik contract for $12,000. 6307 Professional Services $13,575 Funds for advertising & market campaign by Russell Herder, agency of record. PERSONNEL LEVELS All food preparation and food service management staff are provided for under an agreement with Flik. Wages, benefits and other employee costs in this division are City employees that provide direct services to the Catering operation. CAPITAL OUTLAY See Capital Projects Fund 377 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11130/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 49853 EBHC-CATERING OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4609 UNCOLLECTIBLE WRITE OFFS 6,966 4600 MISCELLANEOUS REVENUE 6,966 4599 MISCELLANEOUS REVENUE 6,966 4800 EBHC 4840 CATERING SERVICES 4842 SERVICE CHARGES 384,036- 429,929- 410,000- 438,950- 516,650- 516,650- 4844 FOOD&BEVERAGE SALES 1,859,779- 2,033,558- 2,134,999- 2,067,180- 2,198,500- 2,198,500- 4845 LIQUOR/WINE/BEER SALES 284,928- 282,835- 295,000- 275,766- 302,000- 302,000- 4848 MISCELLANEOUS SALES 40,075- 47,230- 41,001- 39,698- 40,992- 40,992- 4840 CATERING SERVICES 2,568,819- 2,793,552- 2,881,000- 2,821,594- 3,058,142- 3,058,142- 4800 EBHC 2,568,819- 2,793,552- 2,881,000- 2,821,594- 3,058,142- 3,058,142- 4900 OTHER FINANCING SOURCES 5550 DIRECT COST OF SALES 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES-LABOR 1,168,497 1,199,944 1,342,477 1,172,230 1,319,621 1,319,621 5592 COST OF SALES-FOOD 415,028 509,847 495,210 540,164 565,748 565,748 5593 COST OF SALES-SUPPLIES 130,740 139,760 123,104 131,333 128,115 128,115 5594 COST OF SALES-MGMT FEES 102,600 105,023 108,600 99,550 111,600 111,600 5590 EBHC CONTRACT EXPENSES 1,816,865 1,954,574 2,069,391 1,943,276 2,125,084 2,125,084 5550 DIRECT COST OF SALES 1,816,865 1,954,574 2,069,391 1,943,276 2,125,084 2,125,084 4001 REVENUES 751,954- 832,012- 811,609- 878,318- 933,058- 933,058- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 20,368 22,376 22,125 6102 OVERTIME-FT EMPLOYEES 46 198 6103 WAGES-PART TIME EMPLOYEES 39,348 43,344 50,649 41,536 48,600 48,600 6104 OVERTIME-PART TIME EMPLOYEES 57 15 6100 WAGES AND SALARIES 59,761 65,974 50,649 63,677 48,600 48,600 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 3,093 3,599 3,545 3,544 3,524 3,524 6125 FICA 3,686 4,096 3,140 3,962 3,013 3,013 6126 MEDICARE CONTRIBUTIONS 862 957 734 926 705 705 6120 RETIREMENT CONTRIBUTIONS 7,640 8,652 7,419 8,432 7,242 7,242 6130 INSURANCE BENEFITS 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3,066 3,594 2,730 2,898 2,304 2,304 6150 WORKER'S COMPENSATION 3,066 3,594 2,730 2,898 2,304 2,304 6099 PERSONAL SERVICES 70,467 78,220 60,798 75,006 58,146 58,146 378 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 285 1,296 1,304 888 1,304 1,304 6202 COPYING SUPPLIES 631 684 600 660 600 600 6200 OFFICE SUPPLIES 915 1,981 1,904 1,548 1,904 1,904 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 280 292 204 292 292 6214 CLOTHING&PERSONAL EQUIPMENT 11 32 6215 SHOP MATERIALS 48 48 48 6216 CHEMICALS/CHEMICAL PRODUCTS 300 269 300 300 6217 SAFETY SUPPLIES 363 343 648 323 648 648 6219 GENERAL OPERATING SUPPLIES 1,631 386 800 199 800 800 6210 OPERATING SUPPLIES 1,993 1,020 2,088 1,027 2,088 2,088 6220 REPAIR&MAINT SUPPLIES 6223 BUILDINGS&FACILITIES 1,027 3,232 2,004 2,033 3,000 3,000 6227 PAINT SUPPLIES 40 96 96 96 6220 REPAIR&MAINT SUPPLIES 1,068 3,232 2,100 2,033 3,096 3,096 6230 REPAIR&MAINT SUPPLIES-OTHER 6239 OTHER REPAIR&MAINT SUPPLIES 503 123 2,100 1,510 2,100 2,100 6230 REPAIR&MAINT SUPPLIES-OTHER 503 123 2,100 1,510 2,100 2,100 6240 SMALL TOOLS&MINOR EQUIPMENT 6241 SMALL TOOLS 12 6242 MINOR EQUIPMENT 17,012 12,135 19,000 18,868 24,000 24,000 6243 MINOR COMPUTER EQUIPMENT 1,487 2,920 1,700 1,686 13,975 13,975 6240 SMALL TOOLS&MINOR EQUIPMENT 18,499 15,055 20,700 20,566 37,975 37,975 6199 SUPPLIES 22,978 21,411 28,892 26,684 47,163 47,163 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 13,575 13,575 6300 PROFESSIONAL SERVICES 13,575 13,575 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,264 1,319 936 780 936 936 6322 POSTAGE 334 649 400 309 400 400 6320 COMMUNICATIONS 1,598 1,968 1,336 1,089 1,336 1,336 6330 TRANSPORTATION 6333 FREIGHT/DRAYAGE 22 96 96 96 6330 TRANSPORTATION 22 96 96 96 6340 ADVERTISING 6349 OTHER ADVERTISING 31,970 45,318 43,024 41,590 44,262 44,262 6340 ADVERTISING 31,970 45,318 43,024 41,590 44,262 44,262 6350 PRINTING AND DUPLICATING 6351 PRINTING 3,068 1,854 5,480 8,840 5,480 5,480 6350 PRINTING AND DUPLICATING 3,068 1,854 5,480 8,840 5,480 5,480 6360 INSURANCE 379 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/3012011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6361 GENERAL LIABILITY INSURANCE 5,186 4,293 5,318 4,680 5,442 5,442 6362 PROPERTY INSURANCE 12,160 13,266 15,272 13,723 15,980 15,980 6366 MACHINERY BREAKDOWN INSURANCE 770 760 875 764 890 890 6360 INSURANCE 18,115 18,319 21,465 19,166 22,312 22,312 6380 UTILITY SERVICES 6381 ELECTRIC 16,521 18,020 20,996 18,627 26,000 26,000 6382 GAS 17,034 23,389 40,000 14,782 30,000 30,000 6383 WATER 695 1,014 600 1,111 1,200 1,200 6384 REFUSE DISPOSAL 6,777 6,429 7,000 5,848 7,000 7,000 6385 SEWER 983 1,918 1,684 2,156 1,900 1,900 6386 STORM SEWER 1,026 1,538 1,300 1,493 1,500 1,500 6389 STREET LIGHTS 180 275 252 261 320 320 6380 UTILITY SERVICES 43,216 52,581 71,832 44,279 67,920 67,920 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 18,098 8,013 19,500 15,770 19,500 19,500 6403 BLDGS/FACILITIES MAINT SERVICE 1,678 2,229 3,996 1,904 3,996 3,996 6406 MULTI-FUNCTION MTNCE 1,725 1,725 6409 OTHER REPAIR&MAINT SVCS 1,199 1,308 1,404 1,199 1,404 1,404 6400 REPAIR&MAINT SERVICES 20,974 11,550 24,900 18,873 26,625 26,625 6410 RENTALS 6413 OFFICE EQUIPMENT 2,228 2,372 2,200 2,127 1,010 1,010 6415 OTHER EQUIPMENT 2,250 996 996 996 6410 RENTALS 2,228 4,622 3,196 2,127 2,006 2,006 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,464 1,500 1,344 1,500 1,500 6434 DUES&SUBSCRIPTIONS 35 70 70 70 6435 CREDIT CARD FEES 13,236 14,746 11,776 18,357 17,000 17,000 6436 UNCOLLECTIBLE CHECKS/DEBTS 10,580 7,398- 5,000 5,000 6438 CASH SHORT(OVER) 109- 32- 41- 6430 MISCELLANEOUS 25,206 7,316 13,346 19,660 23,570 23,570 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 7,064 9,089 9,204 6,688 9,204 9,204 6440 OTHER EXPENSES 7,064 9,089 9,204 6,688 9,204 9,204 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 160,226 160,226 180,253 147,454 168,900 168,900 6490 OTHER MISC COSTS/EXPENSES 160,226 160,226 180,253 147,454 168,900 168,900 6299 OTHER CHARGES&SERVICES 313,689 312,843 374,132 309,767 385,286 385,286 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6001 EXPENDITURES/EXPENSES 407,134 412,474 463,822 411,457 490,595 490,595 4000 REVENUES AND EXPENSES 344,819- 419,538- 347,787- 466,861- 442,463- 442,463- 49853 EBHC-CATERING OPERATIONS 344,819- 419,538- 347,787- 466,861- 442,463- 442,463- 380 City of Brook& Center 2012 fudget FUND: Earle Brown Heritage Center—61700 DEPT/ACTIVITY/PROJECT: Office Rental—49854 PROFILE The D Barn (commercial office building) is rented to Oliver and Company, the Embassy Suites hotel owner. No formal plans have been submitted to date for space design. Rental payments will start when the link is completed. Innovative Presentations continues in the former Inn for their office area. DEPARTMENTAL GOALS • Provide maintenance to building. • Respond to tenant concerns in a timely manner. EXPENDITURE DETAILS PERSONNEL LEVELS Maintenance and custodial care provided by facility staff under the direction of the Maintenance Supervisor. CAPITAL OUTLAY See Capital Projects Fund 381 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 49854 EBHC-OFFICE RENTAL 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4800 EBHC 4830 OFFICE RENTAL 4831 OFFICE RENTALS 25,680- 101,660- 25,680- 23,540- 99,480- 99,480- 4830 OFFICE RENTAL 25,680- 101,660- 25,680- 23,540- 99,480- 99,480- 4800 EBHC 25,680- 101,660- 25,680- 23,540- 99,480- 9%480- 4900 OTHER FINANCING SOURCES 4001 REVENUES 25,680- 101,660- 25,680- 23,540- 99,480- 99,480- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES&SALARIES-FT EMPLOYEES 1,411 1,367 1,000 371 6103 WAGES-PART TIME EMPLOYEES 2,822 2,458 3,800 2,200 3,200 3,200 6100 WAGES AND SALARIES 4,233 3,825 4,800 2,571 3,200 3,200 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 285 268 336 188 302 302 6125 FICA 262 239 298 160 260 260 6126 MEDICARE CONTRIBUTIONS 61 56 70 37 61 61 6120 RETIREMENT CONTRIBUTIONS 609 563 704 385 623 623 6130 INSURANCE BENEFITS 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 224 214 259 122 6150 WORKER'S COMPENSATION 224 214 259 122 6099 PERSONAL SERVICES 5,066 4,601 5,763 3,078 3,823 3,823 6199 SUPPLIES 6210 OPERATING SUPPLIES 6220 REPAIR&MAINT SUPPLIES 6223 BUILDINGS&FACILITIES 564 2,962 996 870 1,000 1,000 6225 PARK&LANDSCAPE MATERIALS 300 300 300 6226 SIGNS&STRIPING MATERIALS 228 300 180 300 300 6227 PAINT SUPPLIES 70 150 150 150 6220 REPAIR&MAINT SUPPLIES 791 3,032 1,746 1,049 1,750 1,750 6230 REPAIR&MAINT SUPPLIES-OTHER 6240 SMALL TOOLS&MINOR EQUIPMENT 6199 SUPPLIES 791 3,032 1,746 1,049 1,750 1,750 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 382 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6320 COMMUNICATIONS 6349 OTHER ADVERTISING 246 6320 COMMUNICATIONS 246 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 718 487 608 463 547 547 6362 PROPERTY INSURANCE 1,594 1,327 1,527 1,372 1,597 1,597 6366 MACHINERY BREAKDOWN INSURANCE 98 76 87 76 88 88 6360 INSURANCE 2,410 1,890 2,222 1,912 2,232 2,232 6380 UTILITY SERVICES 6381 ELECTRIC 4,339 4,130 4,374 5,108 5,000 5,000 6382 GAS 5,340 6,590 8,478 4,179 7,400 7,400 6383 WATER 243 296 260 298 400 400 6384 REFUSE DISPOSAL 832 689 996 627 996 996 6385 SEWER 271 424 400 452 600 600 6380 UTILITY SERVICES 11,025 12,129 14,508 10,663 14,396 14,396 6400 REPAIR&MAINT SERVICES 6402 EQUIPMENT SERVICES 3,333 2,530 1,500 171 1,500 1,500 6403 BLDGS/FACILITIES MAINT SERVICE 120 504 141 504 504 6400 REPAIR&MAINT SERVICES 3,333 2,650 2,004 312 2,004 2,004 6410 RENTALS 6420 IS SERVICES/LICENSES/FEES 6440 OTHER EXPENSES 6441 LICENSES,TAXES&FEES 21,811 5,229 5,079 10,000 10,000 6449 OTHER CONTRACTUAL SERVICE 6,300 6,749 8,299 5,938 8,299 8,299 6440 OTHER EXPENSES 28,111 11,978 8,299 11,017 18,299 18,299 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 142,427 142,427 165,100 130,558 149,550 149,550 6490 OTHER MISC COSTS/EXPENSES 142,427 142,427 165,100 130,558 149,550 149,550 6299 OTHER CHARGES&SERVICES 187,552 171,073 192,133 154,462 186,481 186,481 6001 EXPENDITURES/EXPENSES 193,409 178,706 199,642 158,589 192,054 192,054 4000 REVENUES AND EXPENSES 167,729 77,046 173,962 135,049 92,574 92,574 49854 EBHC-OFFICE RENTAL 167,729 77,046 173,962 135,049 92,574 92,574 383 This page has been left blank intentionally. 384