The URL can be used to link to this page

Home My WebLink About2010 11-01 CCP Joint Work Session with Financial Commisson ** REVISED ** Joint Budget Meeting Monday, November 01, 2010 6:30 p.m. City Council and Financial Commission Council Chambers 1. Call to Order • November 01, 2010, Review Utility Funds, Rates, and Enterprise Funds 2. Review Next Steps a. November 15, 2010, Budget Work Session with Financial Commission b. November 22, 2010, Adopt Utility Rates, Pay Plan, and Cafeteria Contribution c. November 29, 2010, 2011 Budget and Taxation Presentation and Hearing d. December 13, 2010, Adopt Final Tax Levy and Final Budgets 3. Adjournment 2011 Enterprise Funds Budgets City of Brooklyn Center Joint Council/Commission Work Session Monday,, 1 November 7.010 Introduction • Funds that produce enough revenue to support their own operations and maintenance. Property Tax Levies are not required for Enterprise Funds. • Utilities : • Water Fund • Sanitary Sewer Fund • Storm Sewer Fund • Street Light Fund • Recycling Fund • Other Enterprises: • BC Liquor (2 stores) • Centerbrook Golf Course • Earle Brown Heritage Center Water Fund • Maintain and Operate the Public Water Supply • Provide locating services as per Gopher State One Call • Provide fire flow information • Weekly bacteria testing, daily fluoride testing • Lead, copper, iron, manganese, zinc, and calcium/magnesium hardness testing • Training for safety and right-to-know • Maintenance flushing of mains and hydrants • EPA Consumer Confidence reports • Maintain and monitor chemical feed equipment • Maintenance and repair of water towers; interior and exterior • Maintain electrical systems, SCADA systems, telemetry systems • Done in an efficient and cost effective manner Water Fund WATER FUND 2010 2011 $ Change % Change Water Sales 2,048,227 2,130,156 , 81,929 4.00% Other Revenue 20,000 9,200 (10,800): (54.00%) 2,068,227 2,139,356 71,129 3.44% Personal Services 452 678 467 575 14,897 3.291% Supplies 1821740 172,990 (9,750) :Other Costs 571,737 580,747 9,010 1.58% Depreciation 637,900 638,079 179 0.03% _s 1,845,055 1,859,391 14,336 : 0.78% _ .. r Net Operations 223,172 279,965 56 793 25.45% Capital Improvements 1,257,000 1,314,400 571400 4.57% Debt Service 158,438 194,936 36,498 23.04% Water Fund CITY OF BROOKLYN CENTER WATER FUND CASH FLOW ANALYSIS NORMAL SCHEDULE Rate Increase 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% Rate/1,000 gallons 1.29 1.34 1.39 1.45 1.51 1.57 1.63 1.69 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Water Service $ 1,974,100 $ 2,048,227 $ 2,130,156 $ 2,215,362 „ $ 2,303,977 $ 2,396,136 $ 2,49.1,981111$ 2,591,661 Bond Proceeds $-_ $ 1,744,875 $. $ $ $ $ Misc. Operating $ 2,596 $ 6,296 $ 9,996 $ 13,696 : $ 17,396 $ 21,01961,11$ 24J166 $ 28,496 Misc. Non-operating ,44 $ 502 $ 34,431 $ 65,831 $ 47,945 $ 70,307 $ 60,397 $ 52,679 $ 48,894 Total Rewn es $ 2,027,138 $ 3,833,829 $ 2,205,983 $ 2,277,003 $ 2,391,680 $ 2,477,629 $ 2,569,456 $ 2,669,051 Expenditures Personal Services 5 ces $ 421,975 $ 452,678 $ 467,575 $ 481,602 $ 496, 0 $ 510,932 $ 526,260 $ 542,048 11 Supplies $ 1 82 61,552 $ 1 ,740 $ 172,990 $ 178,180 $ 183,525 $ 189,031 $ 194,702 $ 200,543 Services $. 2,258,839 $ 571,737 $ 652,288 ! $ 678,380 $ 705,515 $ 733,735 $ 763,085 $ 793,608 Depreciation $ 596,180 $ 637,900 $ 638,079 $ 654,031 ,$ 670,382 $ 687,141 $ 704,320 $ 721,928 Debt Service Interest Fees $ - $ 89,936 $ 63,678 $ 62,185 ' $ 60,185 $ 57,571 $ 54,575 Total Expenditures $ 3,438,546 $ 1,845,055 $ 2,020,868 $ 2,055,870 $ 2,117,657 $ 2,181,024 , $ 2,245,937 $ 2,312,701 less: Non-Cash Depreciation $ 596,180 $ 637,900 $ 638,079 $ 654,031 $ 670,382 $ 687,141 $ 704,320 $ 721,928 plus: Debt Service Principal 05 $ $ 105,000 $ 101,250 ' $ 101,250 $ 1 ,000 $ 105,000 $ 108,750 plus: Transfers _ $ $ _ $ _ - $utl $ 1. plus: Cash Capital Outlay $ 437,423 $ 1,580,000 $ 1,314,400 $ 28,500 $ 1,173,500 $ 1,136,000 $ 1,049,000 $ 1,877,500 Total Cash Requirement $ 3,279 789 $ 2,787,155 $ 2,802,189 $ 1,531,589 $ 2,722,025 $ 2,734,883 $ 2,695,617 ! $ 3,577,023 Beginning Cash Balance $ 2,068,255 $ 1,147,687 $ 2,194,361 $ 1,598,155 ; $ 2,343,568 ! $ 2,013,223 $ 1,755,968 $ 1,629,807 Changes in Assets/Liabilities $ 332,083 $ - $ - $ - $ - $ $ Cash Received $ 2,027,138 $ 318331829 $ 2,205,983 $ 2,277,003 $ 21391,680 $ 2,477,629 $ 2,569,456 $ 2,669,051 Cash Spent $ (3,279,789) $ (2,787,155) $ (2,802,189) $ (1,531,589) $ (2,722,025)', $ (2,734,883), $ (2,695,617)' $ (3,577,023), Ending Cash Balance $ 1,147,687 $ 2,194,361 $ 1,598,155 $ 2,343,568 $ 2,013,223 $ 1,755,968 $ 1,629,807 $ 721,835 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 Cash Reserve Target(5°/dyr) $ 1,050,000 $ 1,102,500 $ 1,157,625 $ 1,215,506 $ 1,276,282 $ 1,340,096 $ 1,407,100 $ 1,477,455 Water Fund . ... . . _... .._...... .. . . .. . ... . ......... . . . . . ..... ... _....... . . ... . ...... . .. . ... .... .. ..... . . . ... ...... ... . . . ......... ... . ... . . .. . Water Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 4.00% 5.00% 5.00% 6.00% 6.25% 5.00% 3.00% Rate per 1000 gallons: 1.29 ° 1.34 1.41 1.48 . 1.57 : 1.67 1.75 1.80 2011 Cash Analysis Rate Increase: 3.00% 4.00% 4.00% 4.00% 4.00% , 4.00% , 4.00% 4.00% ' Rate per 1000 gallons: 1.29 1.34 1.40 1.45 1.51 1.57 1.63 1.70 Sanitary Sewer Fund • Locate services as per Gopher State One Call • Routine line cleaning to clear grit, grease, roots • Root Sawing program • Televise sewers in project areas and trouble spots • Monitor inflow and infiltration • Monitor, repair and rehabilitate lift stations and force mains i Sanitary Sewer Fund SANITARY SEWER FUND 2010 2011 _ $ Change % Change Sewer Charges 3,280,497 31378,911 98,414 3.00% Other Revenue 28,000 61200 (21,800) (77.86%) 31308,497 3,385,111 76,614 2.32% Personal Services 190,931 198,973 8f 042 4.21% Supplies 25,380 25,350..:;_ Other Costs 2,425,648 „(111787) (0.48%) Depreciation 577,600 601,694 241094 4.170/0 31231,346 3,251,665 20,319 0.63% Net Operations 77,151 133,446 ` 56,295 72.97% Capital Improvements 11342,862 824,600 (518,262) (38.59%) Debt Service 52,813 64,979 12,166 23.04% Sanitary Sewer Fund CITY OF BROOKLYN CENTER SANITARY SEWER FUND CASH FLOW ANALYSIS NORMAL SCHEDULE Rate Increase 1.00% 1.00% 3.00% 4.00% 4.00% 4.00%" 4.00% 4.00% Monthly Residential Fee $ 21.08 $ 21.29 $ 21.93 $ 22.81 $ 23.72 $ 24.67 $ 25.65 $ 26.68 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Sewer Charges $ 3,315,597 $ 3,280,497 $ 3,378,912 ' $ 3,514,068 " $ 3,654,631 $ 3,800,816 $ 3,952,849 $ 4,110,963 ,96 Bond Proceeds $ - $ 5134 $ $ _ $ $ $ $ - Misc. Operating $ $ _ $ _$ $ $ _ $ $ - Misc. Non-operating $ 26,045 $ 16,000 $ 6,177 $ 5,265 $ 7,777 $ 6,172 $ 4,514 $ 3,798 Total Revenues $ 3,341,642 $ 3,810,461 $ 3,385,089 $ 3,519,333 $ 3,662,408 $ 3,806,988 $ 3,957,363 $ 4,114,761 Expenditures Personal Services $ 161,746 $ 190,931 $ 1981568 $ 206,511 $ 214,771 $ 223,362 $ 232,297 $ 241,589 Supplies $ 8,606 $ 25,380 $ "26,141 $ 26,926 "$ 27,733 $ 28,565 $ 29,422 $ 30,305 Services $ 3,005,243 $ 2,437,435 $ 2,510,558 $ 2,585,875 $ 2,663,451 $ 2,743,355 $ 2,825,655 $ 2,910,425 Depreciation $ 550,108 $ 577,600 $ 515,000 $ 530,450 ' $ 546,364 $ 562,754 $ 579,637 $ 597,026 Debt Service Interest& Fees $" - $ 20,312 $ 19,581 $ 18,768 $ 17,834 $ 16,615 $ 14,706 $ 13,447 Total Expenditures $ 3,725,703 ! $ 3,251,658 $ 3,269,849 $ 3,368,529 $ 3,470,153 $ 3,574,652 ` $ 3,681,717 ' $ 3,792,792 less: Non-Cash Depreciation $ 550,108 $ 577,600 $ 515,000 $ 530,450 $ 546,364 $ 562,754 $ 579,637 $ 597,026 plus: Debt Service Principal $ - $ 32,500 $ 33,750 $ 33,750 $ 35,000 $ 37,500 $ 38,750 $ 40,000 plus: Transfers _ $ - $ $ $ $ _ $ $ $ plus: Cash Capital Outlay $ 428,648 $ 1,532,000 "$ 824,600 $ 19,500 $ 1,105,000 $ 1,172,000 $ 995,500 $ 1,010,500 ' Total Cash Requirement $ 3,604,243 $ 4,238,558 $ 3,613,199 $ 2,891,329 . $ 4,063,790 $ 4,221,397 $ 4,136,330 ; $ 4,246,266 Beginning Cash Balance $ 2,191,302 $ 1,972,466 $ 1,544,369 $ 1,316,260 $ 1,944,264 $ 1,542,882 $ 1,128,473 $ 949,505 Changes in Assets/Liabilities $ 43,765 $ $ $ $ $ $ - $ - Cash Received $ 313411642 $ 3,810,461 $ 3,385,089 $ 3,519,333 $ 3,662,408 $ 3,806,988 $ 3,957,363 ' $ 4,114,761 Cash Spent $ (3,604,243) $ (4,238,558) $ (3,613,199) $ (2,891,329) $ (4,063,790) $ (4,221,397), $ (4,136,330) $ (4,246,266), Ending Cash Balance $ 1,972,466 $ 1,544,369 $ 1,316,260 $ 1,944,264 $ 1,542,882 $ 1,128,473 $ 949,505 $ 818,001 Cash Reserve Ta rge t $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 ' $ 950,000 $ 950,000 Cash Reserve Target(3%dyr) $ 950,000 ! $ 978,500 $ 1,007,855 $ 1,038,091 $ 1,069,233 $ 1,101,310 $ 1,134,350 $ 1,168,380 Sanitary Sewer Fund Sanitary Sewer Utility Fund . 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 1.00% 1.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.0091b Quarterly Rate per Dwelling: $ 21.08 $ 21.29 $ 22.14 $ 23.03 $ 23.95 $ 24.91 $ 25.90 $ 26.94 2011 Cash Analysis Rate Increase: 1.00% 1.00% 3.00% 4.00% 4.00%: 4.00% 4.00% 4.00% Quarteriy Rate per Dwelling: $ 21.08 $ 21.29 $ 21.93. $_ 22.81 $ 23.72 $ 24.67 $ 25.65 . $ 26.68 Storm Sewer Fund • Street sweeping operations • Storm sewer televising • Clean and inspect outfalls, skimmers, ponds, sediment structures per NPDES requirements • Inspect private ponds and treatment systems Storm Sewer F STORM SEWER FUND 2010 2011 $ Change %° Change Storm Sewer Charges 11581,554 11,59711370 15,816 1.00% Other Revenue 24,000 ' 31882 (20,118) (83.83%)' 1,605,554 1,601,252 (4t302)I _ (0.27%) Personal Services 159,915 162,155 2,240 1.40% Supplies 28f.0.0011 ;; 28,800 800 1 2.86%° Other Costs 3471712 271,953 (75f759)"'', (21.79%) Depreciation 901,375 9971475 96,100 10.66% 1,437,002 1,460,383 231381 1.63% Net Operations 168,552 140,869 (271683): (16.42%) Capital Improvements 1,936,000 1,917,000 (191004 (0.98%)' Debt Service _ _ _ 0.00% Storm Sewer Fund City of Brooklyn Center Storm Sewer Fund Cash Flow Analysis NORMAL SCHEDULE Rate Increase. _3.00% 1.00% 1.00%o a o o o a 2.00% 2.00% 2.00%' 2.00% 2.00% Per Residential Lot 14.19 14.34 14.48 14.77 15.06 15.36 15.67 15.99 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 .Revenues Storm Sewer Fees $ 1,577,679 $ 1,581,554 $ 1 62 ,597,370 $ 1,629,317 $ 1,661,903 $ 1,695,141 $ 1,729,044 $ 1,763, 5 Misc. Operating $ - $ $ $ $ $ $ $ - Misc. Non-operating `$ 26,255 $ 9,200 $ 3,882 ; $ 755 $ 4,567 $ 5,649 $ 6,118 $ 7,155 Total Revenues $ 1,603,934 $ 1,590,754 $ 1,601,251 $ 1,630,072 $ 1,666,470 $ 1,700,790 $ 1,735,162 $ 1,770,780 Expenditures Personal Services $ 66,003 $ 159,915 $ 162,155 $ 170,263 $ 178,776 $ 187,715 $ 197,100 s $ 206,955 Supplies $ 10,351 $ 28,000 $ 28,800 $ 29,664 $ 30,554 $ 31,471 $ 32,415 $ 33,387 Services $ 343,296 $ 244,712 $ 274,935 $ 283,183 $ 291,679 $ 300,429 $ 309,442 $ 318,725 Depreciation $ 858,450 $ 901,375 $ 997,475 $ 1,027,399 $ 1,058,221 ' $ 1,089,968 ' $ 1,122,667 : $ 1,156,347 Debt Service Interest & Fees $ - $ - $ - $ - $ - $ - $ - $ - Total Expenditures $ 1,278,100 $ 1,334,002 $ 1,463,365 $ 1,510,509 $ 1,559,230 $ 1,609,582 `; $ 1,661,624 $ 1,715,414 . less: Non-Cash Depreciation $ 858,450 $ 901,375 $ 997,475 $ 1,027,399 $ 1,058,221 $ 1,089,968 $ 1,122,667 $ 1,156,347 plus: Cash Transfer to GF $ 100,000 $ 100,000 $ - $ - plus: Debt Service Principal $ _ $ $.. ... $ $ plus: Transfers _ $ _ $ _ $ _ $ $ $ - $ plus: Cash Capital Outlay $ 11015,061 $ 2,230,800 $ 1,917,000 $ 194,000 $ 895,000 $ 1,064,000 $ 937,000 > $ 1,267,000 Total Cash Requirement $ 1,534,711 $ 2,763,427 ! $ 2,382,890 $ 677,110 $ 1;396,008 $ 1,583,614 $ 1,475,957 $ 1,826,068 Beginning Cash Balance $ 1,929,535 $ 2,143,141 $ 970,468 $ 188,829 $ 1,141,792 $ 1,412,254 $ 1,529,430 $ 1,788,635 Changes in Assets/Liabilities $ 144,383 $ - $ - $ - $ - $ - $ - $ - Cash Received $ 1,603,934 $ 1,590,754 $ 1,601,251 $ 1,630,072 $ 1,666,470 $ 1,700,790 ' $ 1,735,162 $ 1,770,780 Cash Spent $ (1,534,711) $ (2,763,427) $ (2,382,890) $ (677,110), $ (1,396,008) $ (1,583,614) $ (1,475,957) $ (1,826,068) Ending Cash Balance $ 2,143,141 $ 970,468 $ 188,829 $ 1,141,792 $ 1,412,254 $ 1,529,430 $ 1,788,635 $ 1,733,347 Cash Reserve Target $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 Storm Sewer Fund Storm Sewer Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 1.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Quarterly per Residential Lot: 14.19 14.33 14.76 15.20 15.66 16.13 16.61 17.11 2011 Cash Analysis Rate Increase: 3.00% 1.00% 1.00% 2.00% 2.00% 2.00% : 2.00% 2.00% Quarterly per Residential Lot:' 14.19 14.33 14.48 14.77 15.06 15.36 15.99 I St r eet Light Fund • Maintain and operate the system • System composition : • 268 ornamental street lights • 97 street lights at traffic signal posts and mast arms • 915 street lights owned by Xcel Energy • City pays electricity Street Light Fund STREET LIGHT FUND 2010 2011 $ Change % Change Service Charges ~ 259,426 2671209 7,783 3.00% Other Revenue 11000 500 (500) (50.00%) ' 260,426 267,709 7,283 2.80% Personal Services Supplies 2,500 21560 60 Other Costs 228,832 2201497 (8,335) (3„64%) Depreciation - 8,700 8,700 0.00% 231f332 231f757 425 0. 18% Net Operations 29,094 35,952 61858 23.57% Capital Improvements 78,000 107,000 291000 37.18% Debt Service - - 0.000/0 Street Light Fund CITY OF BROOKLYN CENTER STREET LIGHT FUND CASH FLOW ANALYSIS Rate Increase 2.00% 3.00% 3.00% 3.00% 3.00% 5.00% 5.00% 3.00% 11 Quarterly Rate per Dwelling 3.73 3.84' 3.95 4.07 4.19 4.40 4.62 4.76 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Street Light Fee $ 253,754 $ 259,426 $ 267,209 $ 275,225 $ 283,482 $ 297,656 $ 312,539 $ 321,915 Misc. Operating $ $ $ $ Misc. Non-operating $ 1,067 $ 500 $ 500 $ - $ 500 $ 500 $ 500 $ 500 Total Revenues $ 254,821 ' $ 259,926 $ 267,709 $ 275,225 $ 283,982 $ 298,156 $ 313,039 $ 322,415 Expenditures _ Personal Services $ $ $ $ $ $ $ $ .Supplies $ 839 $ 2,500 $ 2,560 $ 2,637 $ 2,716 $ 2,797 $ 2,881 $ 2,968 Services $ 213,615 $ 228,832 ' $ 220,469 $ 225,981 $ 231,630 $ 237,421 $ 243,357 $ 249,440 Depreciation $ 5,566 $ $ 8,700 $ 8,874 $ 9,051 $ 9,233 $ 9,417 $ 9,606 Debt Service or Transfer $ $ $ _._ $ $ $ $ $ Total Expenditures $ 220,020 $ 231,332 $ 231,729 $ 237,492 $ 243,398 $ 249,451 $ 255,655 $ 262,014 Capital Outlay/Transfers $ - $ 78,000 $ 107,000 $ - $ 79,000 S 57,000 $ 98,000 $ 50,000 1. Total Cash Requirement $ 220,020 ' $ 309,332 $ 338,729 $ 237,492 $ 322,398 $ 306,451 $ 353,655 $ 312,014 Beginning Cash Balance $ 72,996 $ 117,678 $ 68,272 $ 5,952 $ 52,559 $ 23,195 $ 24,132 Changes in Assets/Liabilities $ 4,315 $ - $ - $ - $ - $ - $ - $ - Revenues $ 254,821 $ 259,926 $ 267,709 $ 275,225 $ 283,982 $ 298,156 $ 313,039 $ 322,415 Expenditures $ (220,020)' $ (309,332) $ (338,729) $ (237,492) $ (322,398) $ (306,451) $ (353,655) $ (312,014) Depreciation Add-Back $ 5,566 $ - $ 8,700 $ 8,874 $ 9,051 $ 9,233 $ 9,417 $ 9,606 Ending Cash Balance $ 117,678 ! $ 68,272 $ 5,952 $ 52,559 $ 23,195 $ 24,132 $ (7,067) $ 12,940 Cash Reserve Target $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50;000 $ 50,000 Light Fun Street Street Light Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 2.00% , 3.00% 4.00% 5.00910 5.00% 5.00% 5.00% 3,00% ' Quarterly Rate per Dwelling: 3.73 3.84 4.00 4.20 4.41 4.63 4.86 5.00: 2011 Cash Analysis Rate Increase: 2.00% 3.00% 3.00% 3.00% 3.00% 5.00% 5.00% 3.00% Quarterly Rate per Dwelling: 3.73 3.84 3.95 4.07 4.19 1 4.40 1 4.62 1 4.76! Recycling Fund • Bi -weekly collection of recyclables • Cooperative effort with New Hope and Crystal in the Hennepin Recycling Group ( HRG ) • The City may add bi -annual curb-side pick up beginning in 2012for the additional charge of $ 2 . 70 per quarter per household . Recycling Fund RECYCLING FUND 2010 2011 $ Change % Change Service Charges 284f242 2891927 51685 2.00% Other Revenue - - - 0.00% 284,242 289,927 51685 2.00% Personal Services - - 0.00% Supplies - 0.00% Other Costs 273,087 2791739 6,652 2.44% Depreciation - - - 0.00% 273,087 279,739 6,652 1 2.44% Net Operations 11f155 10 188 (967)' (8.67%0) Capital Improvements - - - 0.00% Debt Service - 0.00% Recycling Fund City of Brooklyn Center _ Recycling Fund Rate Analysis Rate In 3.00% 6.00% 2.00% 3.00%' 3.00% 3.00% 3.00% 3.00% Quarterly Residential Rate 7.80, 8.27 8.43 8.68 8.94 9.21 9.49' 9.77 Actual Budget Proposed Projected Projected Projected Projected Projected _ 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Recycling Fee $ 267,316 $ 284,242 $ 289,927 $ 298,625 ' $ 307,583 $ 316,811 $ 326,315 $ 336,105 Misc. Operating $ $ $ Misc. Non-operating $ 25 Total Revenues $ 267,341 $ 284,242 $ 289,927 $ 298,625 ` $ 307,583 $ 316,811 $ 326,315 , $ 336,105 Expenditures Personal Services - Supplies $ 61 Services $ 275,997 $ 273,087 $ 279,739 $ 288,131 $ 296,775 $ 305,678 $ 314,849 $ 324,294 Depreciation $ - $ $ $ - $ Debt Service $ $. -$ $ $.._.. $....._ $ Total Expenditures $ 276,058 $ 273,087 $ 279,739 $ 288,131 $ 296,775 $ 305,678 $ 314,849 $ 324,294 Capital Outlay/Transfers Total Cash Requirement $ 276,058 $ 273,087 $ 279,739 $ 288,131 $ 296,775 $ 305,678 $ 314,849 $ 324,294 Beginning Cash Balance $ (4,354) $ (14,337) $ (3,182) $ 7,006 $ 17,499 $ 28,308 $ 39,440 $ 50,907 Changes in Assets/Liabilities $ (1,266) $ $ - $ - $ $ Revenues $ 267,341 $ 284,242 $ 289,927 $ 298,625 $ 307,583 $ 316,811 $ 326,315 $ 336,105 Expenditures $ (276,058) $ (273,087) $ (279,739) $ (288,131) $ (296,775) $ (305,678) $ (314,849) $ (324,294)' Depreciation Add-Back $ $ $ $ _ $ $ _ $ - $ - Ending Cash Balance $ (14,337) $ (3,182) $ 7,006 $ 17,499 ' $ 28,308 $ 39,440 $ 50,907 $ 62,717 Cash Reserve Target $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 • Rec v �c in Fund Recycling Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 6.00% 3.00% 3.00% ° 3.00% 3.00% 3.00% Quarterly Residential Rate: 7.80 8.27 8.52 8.77 9.03 9.31 9.58 9.87 20].1 Cash Analysis Rate Increase: 3.00% 6.00% 2.00% 3.00% 3.00% 3.00% 1 3.00% 3.00% Quarterly Residential Rate: 7.80 8.27 8.43 8.68 8.94 9.21 9.49 9.77' BC Liquor Fund • Two Locations • Xerxes Avenue and Bass Lake Road • Brooklyn Boulevard and 69th Avenue • Continually improve customer service and satisfaction to build customer base • Growth in sales through promotion and sale activities • Generate sufficient cash flow to keep facilities up to date , clean and attractive • Wine Club quarterly meetings • Provide funding for City's Capital Projects Fund; at least $ 135,000 per year BC Liquor Fund BC LIQUOR FUND 2010 2011 $ Change % Change Sa les 51543,500 51588f 000 = 44,500 0.80% less: Cost of Sales 4,042,040 4,121,800 79,760 1.97% Gross Profit 11501,460 11466,200 (35,260) (2.35%) Personal Services 6121882 614,563 1,681 0.27% Supplies 74 792 30,600 (44 192 . 59.09% PP ) ) Other Costs 580,690 582,896 2,206 0.38% Capital Transfer, 135,000 135,000 - 0.00% Depreciation 27,600 20,260 (71340) 0.00% 11430,964 11383,319 . ...... (471645) (3.33%) Net Operations 70,496 821881 12,385 17.57% Capital Improvements - 73,192 73,192 0.00% Debt Service - 0.00% BC Liquor Fund City of Brooklyn Center _ BC Liquor Cash Flows Actual Budget Proposed Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 Revenues Customer Receipts $ 5,610,108 $ 5,543,500 $ 5,588,000 $ 5,643,880 $ 5,700,319 $ 5,757,322 $ 5,814,895 Misc. Operating $ 8,345 . $ 2,850 $ 3,500 $ 9,800 $ 9,800 $ 9,800 $ 9,800 Misc. Non-operating $ 15,382 $ 16,000 $ 4,000 $ 14,297 $ 14,822 $ 15,089 $ 15,081 Total Revenues $ 5,633,835 ' $ 5,562,350 $ 5,595,500 $ 5,667,977 $ 5,724,941 $ 5,782,211 $ 5,839,776 Expenditures Personal Services $ 634,795 $ 612,882 $ 614,563 $ 639,146 $ 664,711 $ 691,300 $ 718,952 Supplies $ 34,669 $ 74,792 $ 30,600 $ 31,518 $ 32,464 $ 33,437 $ 34,441 Seances $ 548,296 $ 580,690 $ 573,496 $ 590,701 $ 608,422 $ 626,675 $ 645,475 Cost of Good Sold $ 4,088,278 $ 4,042,040 $ 4,121,800 $ 4,148,252 $ 4,189,734 $ 4,231,632 $ 4,2731948 Depreciation $ 26,359 $ 27,600 $ 20,260 $ 26,500 $ 26,500 $ 26,500 $ 26,500 Debt Transfer $ $ _ $ $ _ _ $ $ $ Total Expenditures $ 5,332,397 $ 5,338,004 $ 5,360,719 $ 5,436,116 $ 5,521,831 $ 5,609,543 $ 5,699,315 Capital Transfer $ 265,490 $ 135,000 $ 208,192 $ 200,000 $ 200,000 $ 200,000 $ 200,000 Total Cash Requirement $ 5,597,887 $ 5,473,004 $ 5,568,911 $ 5,636,116 $ 5,721,831 $ 5,809,543 ? $ 5,899,315 Beginning Cash Balance $ 1,318,525 $ 1,424,765 $ 1,541,711 $ 1,588,560 $ 1,646,921 $ 1,676,531 $ 1,675,698 Changes in Assets/Liabilities $ 43,933 $ $ $ $ $ $ Revenues $ 5,633,835 $ 5,562,350 $ 5,595,500 $ 5,667,977 $ 5,724,941 $ 5,782,211 $ 5,839,776 Expenditures $ (5,597,887) $ (5,473,004)' $ (5,568,911) $ (5,636,116) $ (5,721,831) $ (5,809,543) $ (5,899,315) Depreciation Add-Back $ 26,359 $ 27,600 $ 20,260 $ 26,500 $ 26,500 $ 26,500 $ 26,500 Ending Cash Balance $ 1,424,765 $ 1,541,711 $ 1,588,560 $ 1,646,921 $ 1,676,531 $ 1,675,698 $ 1,642,659 Ce I nterbrook Golf Course • Opened in 1988 • Nine hole Executive Course • 20,000+ rounds per year • Lessons, Leagues, Tournaments • Enhance marketing efforts to attract golfers • Pursue cost saving strategies with neighboring courses • Expand leagues and lessons Centerbrook G If Course F u n d o CENTERBROOK GOLF COURSE FUND 2010 2011 $ Change % Change Sales 2721250 270,750 (1,500) (0.55%) less: Cost of Sales 26,000 23,000 (3,000) (11.54%) Gross Profit 246,250 247f750 115010 0.61%o Personal Services 1331 123 140,802 7,679 5.77% Supplies 21,050 16,900 (4150) (19.71%) Other Costs 87,288 89,668 2,380 2.73% Depreciation 29,600 31,700 2,100 0.00% 271,061 279,070 8,009 2.95% Net Operations (24,811) (31,320) (6,509) 26.23% Capital Improvements - - - 0.000/ Debt Service - 0.00% Centerbrook Golf Cour se F u nd City of Brooklyn Center _ Centerbrook Golf Course Cash Flows Actual Actual Budget Proposed Projected Projected Projected Projected 2008 2009 2010 2011 2012 2013 2014 2015 Revenues Course Fees $ 253,824 $ 249,310 $ 272,250 $ 270,750 $ 276,165 $ 281,688 $ 287,322 $ 293,069 Misc. Operating $ 92 " $ -$ $ $ Misc. Non-operaing $ 870 _ 81 $ t $ Total Revenues $ 254,694 $ 249,483 $ 272,250 $ 270,750 $ 276,165 $ 281,688 $ 287,322 $ 293,069 Expenditures Personal Services $ 146,453 $ 152,793 $ 133,123 $ 140,802 $ 143,618 $ 146,490 $ 149,420 $ 152,409 Supplies $ 20,606 $ 18,245 " $ 21,050 $ 16,900 : $ 17,238 ' $ 17,583 $ 17,934 $ 18,293 Services $ 106,337 $ 119,724 $ 113,288 $ 112,668 $ 114,358 $ 116,073 $ 117,814 $ 119,582 Depreciation $ 27,244 $ 28,185" $ 29,600" $ . 31,700 $ 29,600 "$ 29,600 " $ " 29,600 " $ 29,600 Debt Transfer $_ $ $ $ $ $ $ _ Total Expenditures $ 300,640 , $ 318,947 $ 297,061 $ 302,070 $ 304,814 $ 309,747 $ 314,769 $ 319,883 Capital Outlay _ $ 25,879 $ $ _ $ . $ $ $ $ Total Cash Requirement $ 326,519 $ 318,947 $ 297,061 $ 302,070 $ 304,814 $ 309,747 $ 314,769 $ 319,883 Beginning Cash Balance $ 50,970 $ 8,645 " $ (33,422) $ (28,633) $ (28,253) $ (27,302) $ (25,760) $ (23,607); Changes in Assets/Liabilities $ 2,256 $ (788) $ $ $ $ - $ _ - $ - Revenues $ 254,694 $ 249,483 $ 272,250 $ 270,750 $ 276,165 $ 281,688 $ 287,322 $ 293,069 Expenditures $ (326,519) $ (318,947) $ (297,061) $ (302,070) $ (304,814) $ (309,747) $ (314,769) $ (319,883) Depreciation Add-Back $ 27,244 $ 28,185 $ 29,600 $ 31,700 $ 29,600 $ 29,600 $ 29,600 $ 29,600 Ending Cash Balance $ 8,645 $ (33,422) $ (28,633) $ (28,253) $ (27,302) $ (25,760) $ (23,607) $ (20,822)' Earle Brown Heritage Center Fund • Meeting, Conference and Convention Center • Administration • Convention Center Operations • Catering Operations (with Flik) • Office Rental • Promote facility in accordance with 2011 Marketing Plan • Add 10 new corporate clients • Actively work with Embassy Suites to develop synergistic ventures • Combine Greater Minnesota and out-of-state advertising efforts with Visit Minneapolis North Earle Br own Heritage C Fund EARLE BROWN HERITAGE CENTER FUND 2010 2011 $ Change % Change Convention Ctr. Sales 1,016,300 1,069,000 52,700 5.19%o Office rental 25,680 25,680 0.00% Other Revenues 9,000 3,250 Catering Sales 2,645,802 21881,000 235,198 8 89% less: Cost of Sales (1,826,803) (2,069,391) (242,588) 13.28% Gross Profit 1,869,979 1,909,539 39,560 2.12% Personal Services 960,250 966,546 61296 0.66% Supplies 165,122 158,234 (6,888) (4.17%)' Other Costs 817,257 791,110 (26,147) (3.20%) Capital Transfer 200,000 200,000 - 0.00% Depreciation 651,625 712,919 611294 9.41% 21794,254 ' 2,828,809 34,555 1.24% Net Operations (924,275) (919,270) 51005 (0.54%): Capital Improvements 283,000 145,000 (138,000); 0.00% Debt Service - - 0.00% Earle Br®wn Heritage Center Fund City of Brooklyn Center Earle Brown Heritage Center Cash Flows Actual Actual Budget Proposed Projected Projected Projected Projected 2008 2009 2010 2011 2012 2013 2014 2015 Revenues Customer Receipts $ 3,831,972 $ 3,542,077 $ 3,687,782 $ 3,946,677 $ 4,144,011 $ 4,351,211 $ 4,568,772 $ 4,797,211 Misc. Operating $ 2,936 '_$ 646 , $ $ _ $ 9,800 $ 9,800 $ 9,800 $ 9,800 Misc. Non-operating $ 31,443 $ 10,960 $ 9,000 $ 3,250 $ 2,180 $ 2,678 $ 3,638 $ 5,098 Total Revenues $ 3,866,351 $ 3,553,683 $ 3,696,782 $ 3,949,927 $ 4,155,991 $ 4,363,689 $ 4,582,210 $ 4,812,109 Expenditures Personal Services $ 894,062 $ 926,848 $ 966,250 $ 966,546 $ 995,542 $ 1,025,409 $ 1,056,171 $ 1,087,856 Supplies $ 123,906 $ 109,075 $ 165,122 $ 158,234 $ 162,981 $ 167,870 $ 172,907 $ 178,094 Services $ 798,840 $ 691,888 $ 817,257 $ 801,910 $ 821,958 $ 842,507 $ 863,569 $ 885,159 Cost of Good Sold $ 1,875,280 $ 1,816,865 $ 1,826,803 $ 2,069,391 $ 2,020,205 $ 2,121,216 $ 2,227,276 $ 2,338,640 Depreciation $ 579,118 ; $ 624,329 ' $ 651,625 $ 712,919 $ 575,000 $ 575,000 $ 575,000 $ 575,000 Debt Transfer $ $ $ $ _. $ $ $ $ Total Expenditures $ 4,271,206 $ 4,169,005 $ 4,427,057 $ 4,709,000 $ 4,575,686 $ 4,732,001 $ 4,894,923 $ 5,064,749 Capital Transfer $ 235,000 $ 300,000 $ 200,000 $ 200,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 Total Cash Requirement $ 4,506,206 $ 4,469,005 $ 4,627,057 $ 4,909,000 $ 4,675,686 $ 4,832,001 $ 4,994,923 . $ 5,164,749 Beginning Cash Balance $ 1,151,030 $ 1,153,340 $ 767,014 ' $ 488,364 $ 242,210 $ 297,514 $ 404,202 $ 566,489 Changes in Assets/Liabilities $ 63,047 `$ (95,333) $ - $ - $ - $1 1 1 - $ - $ - Revenues $ 3,866,351 $ 3,553,683 $ 3,696,782 $ 3,949,927 $ 4,155,991 $ 4,363,689 $ 4,582,210 ' $ 4,812,109 Expenditures $ (4,506,206)' $ (4,469,005) $ (4,627,057) $ (4,909,000)' $ (4,675,686) $ (4,832,001) $ (4,994,923) $ (5,164,749) .Depreciation Add-Back $ 579,118 $ 624,329 $ 651,625 $ 712,919 $ 575,000 $ 575,000 $ 575,000 $ 575,000 Ending Cash Balance $ 1,153,340 $ 7672014 $ 488,364 $ 242,210 $ 297,514 $ 404,202 $ 566,489 $ 788,849 City of Brook& Center 2011 Budget FUND: Water Utility Fund — 60100 DEPT /ACTIVITY/PROJECT: Operations — 49141 PROFILE potable water to customers. for the distribution of The Water Utility Division provides P This division includes the operations, administration and utility billing for the utility. The division is managed by the Public Works Director, except for the utility billing component which is managed by the Fiscal Services Department. The City has approximately 115 miles of water main, 1,377 water valves, and 975 fire hydrants providing service to 7,314 metered single - family residential connections and 1,635 metered apartments /townhouses /commercial /industrial customers. Water is supplied from nine municipal wells. Also included in this division is the maintenance of meters, locating water mains and services, testing of the municipal water supply throughout the system as required, preventative maintenance, and emergency repairs to the City's distribution system and its appurtenances. The utility billing operation prepares and sends out utility bills, receives meter readings and makes estimated readings, and administers collections and assessment for non- payment. Substantial water main improvements are generally completed in association with the neighborhood street reconstruction program or other improvement projects. 2011 projects consist of reconstruction of some mains in the East Palmer Lake and Logan area neighborhoods and miscellaneous building maintenance projects at municipal wells. DEPARTMENTAL GOALS • Provide routine and 24 -hour emergency on -call maintenance service for the public water supply system. • Change, read and repair residential and commercial water meters as necessary. • Provide timely locating services as per Gopher State One Call. • Work together with the Engineering Division in reconstruction areas to inspect new water services, mains and disconnects, and provide assistance to customers in construction areas who are receiving new water services. • Provide fire flow information and assist insurance companies in gathering additional information as needed (i.e., assist in fire flow testing). • Maintain weekly bacteria testing and daily fluoride testing and reports as required by the State Health Department. • Conduct lead and copper testing as required, and in- house testing for iron, manganese, zinc and calcium/magnesium hardness. • Maintain training sponsored by the Minnesota Department of Health, as well as in house training in right to know, confined space entry and work zone safety. • Continue routine maintenance and emergency repair of fire hydrants, system valves and water mains, and seasonal and routine flushing of water mains. 1 • Prepare and disseminate to all customers EPA- required Consumer Confidence Reports. • Routine and emergency maintenance of wells, continued monitoring of static /pumping levels and well depths. • Maintain chemical feed equipment so as to comply with state guidelines for disinfection, fluoridation and corrosion control. • Preventative maintenance and emergency repairs of electrical controls, telemetry system and building and grounds. • Routine maintenance and repair of the interiors /exteriors of the City's water towers providing for proper seasonal level fluctuation to avoid possible structural damage. • Perform, in a cost - effective manner, water system improvements as a part of neighborhood street reconstruction or other improvement projects. • Repair, rehabilitate, or reconstruct water facilities as necessary to provide for efficient and effective operations. EXPENDITURE DETAILS 6204 Stationary Supplies Water Utility portion of the cost for billing envelopes. Cost distribution: 1/3 Water, 1/3 Sewer, 1/9 Storm Drainage, 1/9 Street Light and 1/9 Recycling Utility. 6216 Chemical Products Chemicals for the water distribution system to provide for disinfection, fluoridation, reduced corrosivity, and to hold the naturally - occurring nuisance mineral manganese in solution. 6219 Operating Supplies Materials and supplies, such as chemical feed equipment, pumps, motors and scales to maintain operation of the water system. 6227 Paint Supplies Paint supplies for Gopher State One Call utility locates and painting of hydrants. 6235 Utility System Supplies Purchase of new meters for new installations and miscellaneous meter parts and supplies. 6239 Repair & Maintenance Supplies Various supplies used in the maintenance of the distribution system, such as valve box extensions, gate valves, sensors, supplies needed for repairing water main breaks, and repair or replacement of mechanical equipment in the pump houses. 6242 Minor Equipment Replacement of equipment used for Water system operations. Four Chemical Scales $3,190 Locator $ 950 Miscellaneous Items $3,000 2 6302 Architect, Engineering and Planning Design assistance with SCADA system components, leak detection, Water tower structural analysis for tower antennae, technical assistance with the water system model. 6307 Professional Services This item provides funding for approximately 20 percent of the cost of a safety consultant to provide required safety training mandated by OSHA. Remaining portion of safety consultant cost is charged to storm, sanitary, engineering and streets. 6321 Telephone /Pagers The cost for two on -call utility pagers, five on -call utility cellular telephones and the telephone connection serving the city's SCADA system. 6322 Postage , Includes the water utility's share of the cost of postage to mail utility bills and meter reading cards. The EPA - required Consumer Confidence Report is now distributed in the City newsletter reducing the postage necessary as the postage costs are now shared for the issue containing the EPA required report. 6351 Printing The cost of printing water meter reading cards for all users of City water. 6381 Utility Service- Electric The electrical power cost of pumping water. Actual amount will depend on water demand, which is influenced by annual rainfall amounts. 6402 Repair and Maintenance Services Routine rehabilitation of well pumps, controls, chemical feed systems. 6403 Building / Facilities Maintenance Services Routine building and HVAC maintenance and repairs for municipal well buildings. Cost previously included in CARS budget. Also includes cost for cleaning exterior of elevated storage tanks. 6441 Licenses, Taxes, and Fees The cost for the State of Minnesota Water Testing Fee (a charge per water connection totaling approx. $60,000 per year) and the Water Appropriation Permit fee charged by the DNR for the pumping of groundwater from the Jordan Aquifer (approx. $15,850). This object code also includes the cost for Water Operator licensing fees ($150 per year). 6449 Other Contractual Service The cost of obtaining assistance from private contractors to repair water main breaks, such as to provide dewatering or specialized equipment not owned by the City. Also includes water utility portion of payment for Gopher State One Call charges, monthly bacteria testing of water system, water utility portion of bill stuffing services, and repairs to communication control systems. 3 I 6530 Improvements Water Utility portion of street and utility improvement projects scheduled for 2011 within the Capital Improvement Program and capital outlay costs provided below. PERSONNEL LEVELS 1- Supervisor of Public Utilities 4- Maintenance 11 3- Seasonal/Part-Time One Engineering Technician is distributed over the Water, Sanitary Sewer and Storm Sewer utilities. CAPITAL OUTLAY See 2011 Capital Improvement Program Summary 4 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 60100 WATER UTILITY FUND 49141 WATER UTILITY - OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 4320 MISC FEDERAL GRANTS 1,057- 4310 FEDERAL REVENUE 1,057- 4300 INTERGOVERNMENTAL REVENUE 1,057- 4599 MISCELLANEOUS, REVENUE 4600 MISCELLANEOUS REVENUE 4601 SPECIAL ASSESSMENTS 1,012- 4603 INTEREST EARNINGS 49,709- 7,304 20,000- 6,184 9,200- 9,200- 4604 CHECK PROCESSING FEES 510- 570- 600- 4605 UNREALIZED INVESTMENT GAIN /LOS 3,139- 509 - 4606 OTHER REVENUE 14 62- 4607 SPEC ASSESS INTEREST 33,939- 41,617- 174- 4600 MISCELLANEOUS REVENUE 87,282- 51,013- 20,000- 7,021- 9,200- 9,200- 4599 MISCELLANEOUS REVENUE 87,282- 51,013- 20,000- 7,021- 9,200- 9,200 - 4700 WATER UTILITY FUND 4701 WATER SALES 1,658,342- 1,638,135- 1,649,277- 1,063,228- 1,795,156- 1,795,156 - 4702 FIRE LINES 8,951- 8,868- 10,150- 5,691- 9,000- 9,000- 4703 WATER METER SALES 7,142- 16,210- 11,900- 6,517- 9,000- 9,000- 4704 WATER METER RENTALS 646- 5,180- 2,100- 684- 1,000- 1,000- 4705 SERVICE RESTORATION FEES 3,610- 5,664 700- 4,130- 4,000- 4,OOD- 4706 CONNECTION CHARGES 1,000- 31 10,000- 6,500- 2,000- 2,000- 4707 PENALTIES 91,293- 82,053- 150,000- 48,942- 80,OOD- 80,000- 4708 TOWER RENTAL FEES 137,600- 163,600- 163,600- 195,484- 195,000- 195,000 - 4709 CERTIFICATION CHARGES 58,950- 54,360- 50,500- 51,300- 35,000- 35,000- 4700 WATER UTILITY FUND 1,967,534 1,974,100- 2,048,227- 1,382,475- 2,130,156- 2,130,156- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 301,701- 4919 GAIN ON FIXED ASSET DISPOSAL 2,359 4921 REFUNDS i REIMBURSEMENTS 1,664 2,026- 2,123- 4933 DISCOUNT ON BOND SALES 17,625 4900 OTHER FINANCING SOURCES 695 303,727- 15,502 4001 REVENUES 2,054,122- 2,328,840- 2,068,227- 1,375,051- 2,139,356- 2,139,356- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 283,018 264,588 290,165 204,310 290,165 290,165 6102 OVERTIME -FT EMPLOYEES 38,624 35,794 36,000 30,077 36,000 36,000 6103 WAGES -PART TIME EMPLOYEES 17,200 11,019 16,000 20,543 16,000 16,000 6104 OVERTIME -PART TIME EMPLOYEES 12 6100 WAGES AND SALARIES 338,842 311,401 342,165 255,053 342,165 342,165 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 3,705 5,917 6110 OTHER PAYMENTS -NON INSURANCE 3,705 5,917 5 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 20,895 20,269 20,311 16,403 23,951 23,951 6125 FICA 20,807 19,384 17,990 15,511 21,214 21,214 6126 MEDICARE CONTRIBUTIONS 4,871 4,597 4,207 3,627 4,961 4,961 6120 RETIREMENT CONTRIBUTIONS 46,573 44,250 42,508 35,541 50,126 50,126 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 47,922 48,204 57,240 39,276 59,784 59,784 6130 INSURANCE BENEFITS 47,922 48,204 57,240 39,276 59,784 59,784 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 12,465 12,204 10,765 11,165 15,500 15,500 6150 WORKER'S COMPENSATION 12,465 12,204 10,765 11,165 15,500 15,500 6099 PERSONAL SERVICES 449,507 421,975 452,678 341,036 467,575 467,575 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 349 923 1,800 12 1,800 1,800 6203 BOOKS/REFERENCE MATERIALS 118 300 300 300 6204 STATIONARY SUPPLIES 743 504 1,300 752 1,300 1,300 6200 OFFICE SUPPLIES 1,209 1,427 3,4D0 764 3,400 3,400 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 50 150 250 250 250 6216 CHEMICALS /CHEMICAL PRODUCTS 100,221 119,033 100,000 68,501 100,000 100,000 6217 SAFETY SUPPLIES 643 1,049 1,200 492 1,200 1,200 6219 GENERAL OPERATING SUPPLIES 4,224 8,353 9,600 9,644 9,600 9,600 6210 OPERATING SUPPLIES 105,138 128,434 110,950 78,887 111,050 111,050 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 3,152 1,500 971 1,500 1,500 6224 STREET MAINT MATERIALS 2,886 •16,000 2,175 16,000 16,000 6227 PAINT SUPPLIES 568 954 800 824 900 900 6220 REPAIR & MAINT SUPPLIES 568 6,992 18,300 3,971 18,400 18,400 6230 REPAIR & MAINT SUPPLIES -OTHER 6235 UTILITY SYSTEM SUPPLIES 16,420 10,748 15,OD0 3,130 14,000 14,000 6239 OTHER REPAIR & MAINT SUPPLIES 9,097 8,719 18,000 4,930 16,000 16,000 6230 REPAIR & MAINT SUPPLIES -OTHER 25,517 19,467 33,000 8,060 30,000 30,000 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 290 .500 106 500 500 6242 MINOR EQUIPMENT 4,116 3,026 14,090 8,202 7,140 7,140 6243 MINOR COMPUTER EQUIPMENT 1,917 1,915 2,500 2,499 2,500 2,500 6240 SMALL TOOLS & MINOR EQUIPMENT 6,034 5,231 17,090 10,806 10,140 10,140 6199 SUPPLIES 138,466 161,552 182,740 102,488 172,990 172,990 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 1,664 1,663 1,750 21,100 2,000 2,000 6302 ARCH, ENG & PLANNING 33,123 67,884 20,000 4,705 20,000 20,000 6303 LEGAL SERVICES 315 1,119 6307 PROFESSIONAL SERVICES 5,831 9,696 7,100 2,232 14,270 14,270 6 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6300 PROFESSIONAL SERVICES 40,933 80,361 28,850 28,037 36,270 36,270 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,325 1,362 1,565 1,007 2,250 2,250 6322 POSTAGE 21,463 14,036 20,000 5,041 20,000 20,000 6329 OTHER COMMUNICATION SERVICES 277 481 540 332 500 500 6320 COMMUNICATIONS 23,065 15,879 22,105 6,381 22,750 22,750 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 196 58 200 200 200 6333 FREIGHT /DRAYAGE 11 50 54 50 50 6330 TRANSPORTATION 206 58 250 54 250 250 6340 ADVERTISING 6342 LEGAL NOTICES 363 68 100 64 100 100 6340 ADVERTISING 363 68 100 64 100 100 6350 PRINTING AND DUPLICATING 6351 PRINTING 505 709 500 362 1,450 1,450 6350 PRINTING AND DUPLICATING 505 709 500 362 1,450 1,450 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 9,975 15,447 19,865 20,583 20,000 20,000 6362 PROPERTY INSURANCE 2,115 2,031 2,550 2,430 2,600 2,600 6366 MACHINERY BREAKDOWN INSURANCE 507 430 536 488 550 550 6360 INSURANCE 12,598 17,908 22,951 23,502 23,150 23,150 6380 UTILITY SERVICES 6381 ELECTRIC 138,453 134,601 140,000 78,633 140,000 140,000 6382 GAS 11,496 7,136 10,000 4,025 10,000 10,000 6385 SEWER 250 253 300 128 300 300 6386 STORM SEWER 5,829 6,000 5,700 3,030 5,700 5,700 6388 HAZARDOUS WASTE DISPOSAL 1,000 1,000 1,000 6389 STREET LIGHTS 1,027 1,050 1,100 541 1,100 1,100 6380 UTILITY SERVICES 157,055 149,040 158,100 86,356 158,100 158,100 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 78,224 81,719 10,000 100,000 100,000 6403 BLDGS/FACILITIES MAINT SERVICE 3,341 7,749 27,000 9,277 14,000 14,000 6408 COMMUNICATIONANFO SYSTEMS 1,668 1,668 1,700 1,700 6400 REPAIR & MAINT SERVICES 81,564 91,137 36,668 9,277 115,700 115,700 6410 RENTALS 6417 UNIFORMS 781 758 800 408 800 800 6410 RENTALS 781 758 800 408 800 800 6420 IS SERVICES/LICENSES /FEES 6421 SOFTWARE LICENSF 224 6422 SOFTWARE MAINT 354 296 372 335 400 400 6423 LOGIS CHARGES 22,186 32,152 33,273 20,562 36,197 36,197 6420 IS SERVICES /LICENSES /FEES 22,764 32,448 33,645 20,897 36,597 36,597 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,287 2,128 2,450 1,228 2,450 2,450 6434 DUES & SUBSCRIPTIONS 1,683 1,796 1,800 2,108 2,524 2,524 6436 UNCOLLECTIBLE CHECKS/DEBTS 775- 868- 7 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6438 CASH SHORT (OVER) 1 64 4 6430 MISCELLANEOUS 2,195 3,120 4,250 3,340 4,974 4,974 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 76,802 74,474 76,000 62,749 76,000 76,0D0 6449 OTHER CONTRACTUAL SERVICE 49,764 75,932 56,000 34,7D9 56,000 56,000 6440 OTHER EXPENSES 126,566 150,406 132,000 97,458 132,000 132,000 6460 CENTRAL GARAGE CHARGES 6461 FUELCHARGES 7,346 4,141 8,457 4,242 6,553 6,553 6462 FIXED CHARGES 6,818 7,849 7,956 6,003 7,569 7,569 6463 REPAIR & MAINT CHARGES 11,207 13,358 12,700 10,568 19,184 19,184 6465 REPLACEMENT CHARGES 19,122 19,653 18,997 14,258 15,300 15,300 6460 CENTRAL GARAGE CHARGES 44,492 45,001 48,110 35,070 48,606 48,606 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 61,055 57,883 81,408 53,359 6472 ENGINEERING SERVICE TRANSFER 226 3,891 6470 TRANSFERS AND OTHER USES 61,281 61,773 81,408 53,359 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 611,328 596,180 637,900 412,996 638,079 638,079 6499 EXPENSES REIMBURSED 25,726 6490 OTHER MISC COSTS/EXPENSES 611,328 621,905 637,900 412,996 638,079 638,079 6299 OTHER CHARGES & SERVICES 1,185,698 1,270,571 1,209,637 777,561 1,218,826 1,218,826 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 1,584,449 1,257,000 5,350- 1,314,400 1,314,400 6501 CAPITAL OUTLAY 1,584,449 1,257,000 5,350- 1,314,400 1,314,400 6500 CAPITAL OUTLAY 1,584,449 1,257,000 5,350- 1,314,400 1,314,400 6600 DEBT SERVICE 6601 BOND PRINCIPAL 97,500 105,000 105,000 6611 BOND INTEREST 60,938 87,686 87,686 6621 PAYING AGENT /OTHER FEES 6,563 2,250 2,250 6600 DEBT SERVICE 158,438 6,563 194,936 194,936 6001 EXPENDITURES /EXPENSES 1,773,670 3,438,547 3,260,493 1,222,296 3,368,727 3,368,727 4000 REVENUES AND EXPENSES 280,451- 1,109,707 1,192,266 152,754 1,229,371 1,229,371 49141 WATER UTILITY - OPERATIONS 280,451- 1,109,707 1,192,266 152,754 1,229,371 1,229,371 8 P CITY OF BROOKLYN CENTER WATER FUND CASH FLOW ANALYSIS NORMAL SCHEDULE Rate Increase 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% Rate /1,000 gallons 1.29 1.34 1.39 1.45 1.51 1.57 1.63 1.69 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Water Service $ 1,974,100 $ 2,048,227 $ 2,130,156 $ 2,215,362 $ 2,303,977 $ 2,396,136 $ 2,491,981 $ 2,591,661 Bond Proceeds $ - $ 1,744,875 $ - $ - $ - $ - $ - $ - Misc.Operating $ 2,596 $ 6,296 $ 9,996 $ 13,696 $ 17,396 $ 21,096 $ 24,796 $ 28,496 Misc. Non - operating $ 50,442 $ 34,431 $ 65,831 $ 47,945 $ 70 $ 60,397 $ 52,679 $ 48,894 Total Revenues $ 2,027,138 $ 3,833,829 $ 2,205,983 $ 2,277,003 $ 2,391,680 $ 2,477,629 $ 2,569,456 $ 2,669,051 Expenditures Personal Services $ 421,975 $ 452,678 $ 467,575 $ 481,602 $ 496,050 $ 510,932 $ 526,260 $ 542,048 Supplies $ 161,552 $ 182,740 $ 172,990 $ 178,180 $ 183,525 $ 189,031 $ 194,702 $ 200,543 Services $ 2,258,839 $ 571,737 $ 652,288 $ 678,380 $ 705,515 $ 733,735 $ 763,085 $ 793,608 Depreciation $ 596,180 $ 637,900 $ 638,Q79 $ 654,031 $ 670,382 $ 687,141 $ 704,320 $ 721,928 Debt Service Interest & Fees $ - $ 89 $ 63 $ 62,185 $ 60,185 $ 57,571 $ 54,575 Total Expenditures $ 3,438,546 $ 1,845,055 $ 2,020,868 $ 2,055,870 $ 2,117,657 $ 2,181,024 $ 2,245,937 $ 2,312,701 less: Non -Cash Depreciation $ 596,180 $ 637,900 $ 638,079 $ 654,031 $ 670,382 $ 687,141 $ 704,320 $ 721,928 �p plus: Debt Service Principal $ - $ 105,000 $ 101,250 $ 101,250 $ 105,000 $ 105,000 $ 108,750 plus: Transfers $ - $ - $ - $ - $ - $ - $ - $ plus: Cash Capital Outlay $ 437 $ 1 $ 1 $ 28.500 $ 1 $ 1 $ 1,049,000 $ 1,877,500 Total Cash Requirement $ 3,279,789 $ 2,787,155 $ 2 $ 1,531,589 $ 2,722,025 $ 2,734,883 $ 2,695,617 $ 3,577,023 Beginning Cash Balance $ 2,068,255 $ 1,147,687 $ 2,194,361 $ 1,598,155 $ 2,343,568 $ 2,013,223 $ 1,755,968 $ 1,629,807 Changes in Assets /Liabilities $ 332,083 $ - $ - $ - $ - $ - $ - $ - Cash Received $ 2,027,138 $ 3,833,829 $ 2,205,983 $ 2,277,003 $ 2,391,680 $ 2,477,629 $ 2,569,456 $ 2,669,051 Cash Spent $ (3 $ (2,787 $ (2,802,189) $ (1 $ (2 $ (2,734 $ (2,695 $ (3,577,023) Ending Cash Balance $ 1,147,687 $ 2,194 $ 1,598J55 $ 2,343,568 $ 2,013,223 $ 1,755,968 $ 1,629,807 $ 721,835 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 Cash Reserve Target (5 %lyr) $ 1,050,000 $ 1,102,500 $ 1,157,625 $ 1,215,506 $ 1,276,282 $ 1,340,096 $ 1,407,100 $ 1,477,455 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. i Water Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 4.00% 5.00% 5.00% 6.00% 6.25% 5.00% 100% Rate per 1000 gallons: 1.29 1.34 1.41 1.48 1.57 1.67 1.75 1.80 2011 Cash Analysis Rate Increase: 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% Rate per 1000 gallons: 1.29 1.34 1.40 1.45 1.51 1.57 1.63 1.70 10 City of �roo Center 2011 Budget FUND: Sanitary Sewer Utility Fund — 60200 DEPT /ACTIVITY /PROJECT: Operations — 49251 PROFILE This division provides for the collection and conveyance of wastewater through a system of mains and lift stations. Sewage is treated by the Metropolitan Council Environmental Services, whose fees account for approximately 75% of this fund's expenditures. This division is managed by the Public Works Director, except for the utility billing component, which is managed by the Fiscal and Support Services Department. The City has approximately 106 miles of sanitary sewer ranging in size from 8" to 24" in diameter, and 8,798 service connections. Included in this division is the routine and preventative maintenance of the City's collection system and its appurtenances, monitoring of inflow and infiltration, television inspection of the interiors of mains, and customer service such as providing sewer locations. This activity involves the operation and maintenance of the City's ten wastewater lift stations, which includes buildings, equipment, and property. Sewer system improvements are made as part of the neighborhood street reconstruction program or other improvement projects. DEPARTMENTAL GOALS • Provide timely locating services as per Gopher State One Call. • Work together with the Engineering Division in reconstruction areas to inspect new installations as well as repairs on mains and services. • Continue root sawing program to maintain conveyance capacity. • Maintain routine line cleaning of known trouble spots, as well as regular routine cleaning to remove grit, grease and roots. • Televise all project areas and trouble spots as identified by city staff and establish repairs and/or repair projects from information obtained. • Monitor inflow and infiltration rates. • Continue established preventative and regular maintenance program on electrical controls, buildings, and grounds. • Monitor inflow and pump efficiency. • Perform, in a cost - effective manner, sewer system improvements as a part of neighborhood street reconstruction or other improvement projects. • Repair, rehabilitate, or reconstruct sanitary sewer facilities as necessary to provide for efficient and effective operations. 11 EXPENDITURE DETAILS 6204 Stationary Supplies Sanitary Sewer Utility portion of the cost for billing envelopes. Cost distribution: 11 Water, 1/3 Sewer, 1/9 Storm Drainage, 1/9 Street Light and 1/9 Recycling Utility. 6216 Chemical Products Degreaser and root remover chemicals used at lift stations. 6219 Operating Supplies Marking paint, marking flags, sewer jet parts, blades, motors, etc. Item includes the cost for miscellaneous parts to repair sanitary sewer maintenance equipment. 6239 Other Repair & Maintenance Supplies The cost of check valves, sump pumps, float, switches and replacement of lift station control valves at Lift Station No. 1 6302 Arch, Eng & Planning Technical assistance by a consultant to assist with lift station operational issues that may arise throughout the year. 6307 Professional Services Engineering for SCADA system maintenance and for OSHA training consultant. This item provides funding for approximately 20 percent of the cost of a safety consultant to provide required safety training mandated by OSHA. Remaining portion of safety consultant cost is charged to storm, water, engineering and streets. 6321 Telephone/Pager The cost of four cellular telephones and 50% of three pagers for on -call personnel. 6381 Utility Services- Electric The electrical cost of operating lift station pumps. 6391 Met Council Environmental Services Charges by the Metropolitan Council Environmental Services for processing the City's wastewater. Brooklyn Center is billed 1.19% of the total metropolitan wastewater charges from MCES, Brooklyn Center's share is $2,059,604.20 for 2011. 6403 Repair and Maintenance Svs- Buildings and Facilities Maint Svs Routine electrical repairs to lift stations and annual building maintenance of Lift Station Nos. 1 and 2. 6409 Repair and Maintenance Svs -Other Annual maintenance for emergency generators ($7,930) miscellaneous unscheduled repairs for sanitary sewer failures ($3,600) and initiation of a program for annual sanitary sewer televising inspections ($53,000). . 12 6449 Other Contractual Service Routine oxygen sensor calibration, gas monitor maintenance, inspection of lift station pumps, generator load banking, etc. This item also includes specialized contractual services such as pump rewinding and isolated sewer repairs that are not part of the scheduled improvements included in the CIP. 6530 Capital Outlay Sewer Utility portion of street and utility improvement projects scheduled for 2011 within the Capital Improvement Program. PERSONNEL LEVELS 2 Maintenance 11 2 Seasonal /Part-Time One Engineering Technician is distributed over the Water, Sanitary Sewer and Storm Sewer utilities. CAPITAL OUTLAY See 2011 Capital Improvement Program Summary 13 This page has been left blank intentionally. 14 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9130/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 60200 SEWER UTILITY FUND 49251 SEWER UTILITY- OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 1,057- 4320 MISC FEDERAL GRANTS 1,057- 4310 FEDERAL REVENUE 4300 INTERGOVERNMENTAL REVENUE 1,057- 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 68,199 25,106 28,000 6,659 6,200 6,200 4603 INTEREST EARNINGS 4605 UNREALIZED INVESTMENT GAIN /LOS 3,325- 811- 4606 OTHER REVENUE 387- 4607 SPEC ASSESS INTEREST 147- 129- 4707 PENALTIES 87,624- 79,608 56,223 4600 MISCELLANEOUS REVENUE 159,682- 105,654 28,000- 62,882- 6,200- 6,200- 4599 MISCELLANEOUS REVENUE 159,682- 105,654- 28,000- 62,882- 6,200- 6,200- 4720 SEWER UTILITY FUND 4721 SEWER SERVICE 3,176,491- 3,235,989- 3,280,497- 2,080,327- 3,378,911- 3,378,911- 4720 SEWER UTILITY FUND 3,176,491- 3,235,989- 3,280,497- 2,080,327- 3,378,911- 3,378,911- 4900 OTHER FINANCING SOURCES 5,875 4933 DISCOUNT ON BOND SALES 5,875 4900 OTHER FINANCING SOURCES 4001 REVENUES 3,336,173- 3,341,643- 3,308,497- 2,138,390- 3,385,111- 3,385,111- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 107,155 95,527 113,997 72,916 113, 113,997 500 6102 OVERTIME -FT EMPLOYEES 17,372 11,281 19,500 9,345 19,500 19,500 6103 WAGES -PART TIME EMPLOYEES 6,612 12,210 12,000 13,889 12,000 12,000 6100 WAGES AND SALARIES 131,139 119,018 145,497 96,150 145,497 145,497 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 1,149 2,006 6110 OTHER PAYMENTS -NON INSURANCE 1,149 2,006 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 8,091 7,208 7,979 5,757 10, 10,184 x,338 7 7,068 5,593 9,0021 21 9,021 6125 FICA ' 6126 MEDICARE CONTRIBUTIONS 1,950 1,703 1,653 1,308 2,110 2,110 6120 RETIREMENT CONTRIBUTIONS 18,378 16,193 16,700 12,658 21,315 21,315 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 20,672 19,838 24,840 16,242 25,944 25,944 6130 INSURANCE BENEFITS 20,672 19,838 24,840 16,242 25,944 25,944 6150 WORKER'S COMPENSATION 15 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6151 WORKER'S COMP INSURANCE 4,567 4,690 3,894 4,284 6,217 6,217 6150 WORKER'S COMPENSATION 4,567 4,690 3,894 4,284 6,217 6,217 6099 PERSONAL SERVICES 175,905 161,746 190,931 129,334 198,973 198,973 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 7 100 100 100 6203 BOOKS /REFERENCE MATERIALS 200 200 200 6204 STATIONARY SUPPLIES 1,337 908 1,400 1,353 1,400 1,400 6200 OFFICE SUPPLIES 1,337 915 1,700 1,353 1,700 1,700 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 50 50 50 6216 CHEMICALS /CHEMICAL PRODUCTS 5,072 2,937 5,000 5,000 5,000 6217 SAFETY SUPPLIES 1,107 1,297 2,500 21 2,500 2,500 6219 GENERAL OPERATING SUPPLIES 4,394 523 2,830 257 2,800 2,800 6210 OPERATING SUPPLIES 10,573 4,757 10,380 278 10,350 10,350 6220 REPAIR & MAINT SUPPLIES 6224 STREET MAINT MATERIALS 7,500 362 7,500 7,500 6227 PAINT SUPPLIES 88 300 955 300 300 6220 REPAIR &MAINT SUPPLIES 88 7,800 1,317 7,800 7,800 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 4,750 2,587 5,000 3,691 5,000 5,000 6230 REPAIR & MAINT SUPPLIES -OTHER 4,750 2,587 5,000 3,891 5,000 5,000 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 347 500 107 500 500 6243 MINOR COMPUTER EQUIPMENT 1,942 6240 SMALL TOOLS & MINOR EQUIPMENT 1,942 347 500 107 500 500 6199 SUPPLIES 18,691 8,606 25,380 6,947 25,350 25,350 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 1,574 1,580 1,750 8,132 6302 ARCH, ENG & PLANNING 579 1,378 1,900 468 1,900 1,900 6307 PROFESSIONAL SERVICES 3,188 2,277 3,700 1,898 4,090 4,090 6300 PROFESSIONAL SERVICES 5,342 5,235 7,350 10,499 5,990 5,990 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 340 312 400 356 1,300 1,300 6322 POSTAGE 6,800 6,961 5,950 5,041 5,665 5,665 6320 COMMUNICATIONS 7,140 7,272 6,350 5,398 6,965 6,965 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 68 70 70 70 6330 TRANSPORTATION 68 70 70 70 6340 ADVERTISING 6350 PRINTING AND DUPLICATING 6351 PRINTING 215 546 375 163 375 375 6350 PRINTING AND DUPLICATING 215 546 375 163 375 375 16 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 4,307 3,838 4,815 5,719 6,120 6,120 6362 PROPERTY INSURANCE 693 665 835 798 854 854 6366 MACHINERY BREAKDOWN INSURANCE 202 171 215 195 208 208 6360 INSURANCE 5,202 4,674 5,865 6,712 7,182 7,182 6380 UTILITY SERVICES 6381 ELECTRIC 35,093 33,106 35,000 24,108 35,000 35,000 6380 UTILITY SERVICES 35,093 33,106 35,000 24,108 35,000 35,000 6390 CONTRACT UTILITY SERVICES 6391 MET COUNCIL ENVIRON SVCS 1,915,444 2,015,724 2,075,475 1,772,144 2,059,605 2,059,605 6390 CONTRACT UTILITY SERVICES 1,915,444 2,015,724 2,075,475 1,772,144 2,059,605 2,059,605 6400 REPAIR & MAINT SERVICES 6403 BLDGS/FACILITIES MAINT SERVICE 2,892 7,000 1,070 7,000 7,000 6408 COMMUNICATION /INFO SYSTEMS 1,585 6409 OTHER REPAIR & MAINT SVCS 47,270 72,830 64,530 36,792 64,530 64,530 6400 REPAIR & MAINT SERVICES 50,163 74,415 71,530 37,862 71,530 71,530 6410 RENTALS 6420 IS SERVICES /LICENSES/FEES 6421 SOFTWARE LICENSE 224 6423 LOGIS CHARGES 22,186 22,749 22,836 14,258 24,141 24,141 6420 IS SERVICES/LICENSES/FEES 22,410 22,749 22,836 14,258 24,141 24,141 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,190 1,332 1,525 1,033 1,525 1,525 6434 DUES & SUBSCRIPTIONS 23 130 100 230 150 150 6430 MISCELLANEOUS 1,213 1,463 1,625 1,263 1,675 1,675 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 2 2 2 6449 OTHER CONTRACTUAL SERVICE 19,027 31,399 26,000 19,002 26,000 26,000 6440 OTHER EXPENSES 19,028 31,400 26,000 19,004 26,000 26,000 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 17,712 12,389 22,704 10,665 19,618 19,618 6462 FIXED CHARGES 11,054 12,296 12,416 9,306 11,751 11,751 6463 REPAIR & MAINT CHARGES 19,097 29,400 24,075 15,206 35,280 35,280 6465 REPLACEMENT CHARGES 54,718 57,314 54,619 40,967 48,925 48,925 6460 CENTRAL GARAGE CHARGES 102,580 111,399 113,814 76,144 115,574 115,574 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 95,225 57,883 71,145 53,359 71,541 71,541 6472 ENGINEERING SERVICE TRANSFER 1.867 6470 TRANSFERS AND OTHER USES 95,225 59,750 71,145 53,359 71,541 71,541 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 553,549 550,108 577,600 438,127 601,694 601,694 6499 EXPENSES REIMBURSED 25,726 6490 OTHER MISC COSTS/EXPENSES 553,549 575,834 577,600 438,127 601,694 601,694 6299 OTHER CHARGES & SERVICES 2,812,603 2,943,635 3,015,035 2,459,040 3,027,342 3,027,342 17 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 611,715 1,342,200 796- 824,600 824,600 6501 CAPITAL OUTLAY 611,715 1,342,200 796- 824,600 824,600 6500 CAPITAL OUTLAY 611,715 1,342,200 796- 824,600 824,600 6600 DEBT SERVICE 6601 BOND PRINCIPAL 32,500 35,000 35,000 6611 BOND INTEREST 20,313 29,229 29,229 6621 PAYING AGENT /OTHER FEES 2,188 750 750 6600 DEBT SERVICE 52,813 2,188 64,979 64,979 6001 EXPENDITURES/EXPENSES 3,007,199 3,725,702 4,626,359 2,596,713 4,141,244 4,141,244 4000 REVENUES AND EXPENSES 328,974- 384,059 1,317,862 458,323 756,133 756,133 49251 SEWER UTILITY- OPERATIONS 328,974- 384,059 1,317,862 458,323 756,133 756,133 18 j CITY OF BROOKLYN CENTER SANITARY SEWER FUND CASH FLOW ANALYSIS NORMAL SCHEDULE Rate Increase 1.00% 1.00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% Monthly Residential Fee $ 21.08 $ 21.29 $ 21.93 $ 22.81 $ 23.72 $ 24.67 $ 25.65 $ 26.68 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Sewer Charges $ 3,315,597 $ 3,280,497 $ 3,378,912 $ 3,514,068 $ 3,654,631 $ 3,800,816 $ 3,952,849 $ 4,110,963 Bond Proceeds $ - $ 513,964 $ - $ - $ - $ - $ - $ - Misc. Operating $ - $ - $ - $ - $ - $ - $ - $ Misc. Non - operating $ 26,045 $ 16,000 $ 6,177 $ 5,265 $ 7,777 $ 6,172 $ 4,514 $ 3,798 Total Revenues $ 3,341,642 $ 3,810,461 $ 3,385,089 $ 3,519,333 $ 3,662,408 $ 3,806,988 $ 3,957,363 $ 4,114,761 Expenditures Personal Services $ 161,746 $ 190,931 $ 198,568 $ 206,511 $ 214,771 $ 223,362 $ 232,297 $ 241,589 Supplies $ 8,606 $ 25,380 $ 26,141 $ 26,926 $ 27,733 $ 28,565 $ 29,422 $ 30,305 Services $ 3,005,243 $ 2,437,435 $ 2,510,558 $ 2,585,875 $ 2,663,451 $ 2,743,355 $ 2,825,655 $ 2,910,425 Depreciation $ 550,108 $ 577,600 $ 515,000 $ 530,450 $ 546,364 $ 562,754 $ 579,637 $ 597,026 Debt Service Interest & Fees $ - $ 20,312 $ 19,581 $ 18,768 $ 17,834 $ 16,615 $ 14,706 $ 13,447 Total Expenditures $ 3,725,703 $ 3,251,658 $ 3,269,849 $ 3,368,529 $ 3,470,153 $ 3,574,652 $ 3,681,717 $ 3,792,792 less: Non -Cash Depreciation $ 550,108 $ 577,600 $ 515,000 $ 530,450 $ 546,364 $ 562,754 $ 579,637 $ 597,026 plus: Debt Service Principal $ - $ 32,500 $ 33,750 $ 33,750 $ 35,000 $ 37,500 $ 38,750 $ 40,000 plus: Transfers $ - $ - $ - $ - $ - $ - $ - $ �o plus: Cash Capital Outlay $ 428,648 $ 1,532,000 $ 824,600 $ 19,500 $ 1,105,000 $ 1,172,000 $ 995,500 $ 1,010,500 Total Cash Requirement $ 3,604,243 $ 4,238,558 $ 3,613,199 $ 2,891,329 $ 4,063,790 $ 4,221,397 $ 4,136,330 $ 4 ,246, 266 Beginning Cash Balance $ 2,191,302 $ 1,972,466 $ 1,544,369 $ 1,316,260 $ 1,944,264 $ 1,542,882 $ 1,128,473 $ 949,505 Changes in Assets /Liabilities $ 43,765 $ - $ - $ - $ - $ - $ - $ - Cash Received $ 3,341,642 $ 3,810,461 $ 3,385,089 $ 3,519,333 $ 3,662,408 $ 3,806,988 $ 3,957,363 $ 4,114,761 Cash Spent $ 3,604,243 $ 4,238,558 $ 3,613,199 $ (2,891,329 ) $ 4,063,790) $ 4,221,397 $ 4,136,330 $ 4,246,266 Ending Cash Balance $ 1,972,466 1,544,369 $ 1,316,260 $ 1,944,264 $ 1,542,882 $ 1,128,473 $ 949,505 $ 818,001 Cash Reserve Target: $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 Cash Reserve Target (3 % /yr. $ 950,000 $ 978,500 $ 1,007,855 $ 1,038,091 $ 1,069,233 $ 1,101,310 $ 1,134,350 $ 1,168,380 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet items. Revenues Rate increases would be as indicated per year and are based on a stable customer base with stable usage. Expenditures Personnel costs increase at a rate of 4% per year Supplies increase at a rate of 3% per year. Serices increase at a rate of 3% per year Depreciation increases at a rate of 3% per year Capital outlay is from the 2011 CIP Sanitary Sewer Utility Fund 2009 2010 r4.O 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 1.00% 1.00% 4.00% 4.00% 4.00% 4.00% 4.00% Quarterly Rate per Dwelling: $ 21.08 $ 21.29 $ 23.03 $ 23 .95 $ 24.91 $ 25.90 $ 26.94 2011 Cash Analysis Rate Increase: 1.00% 1.00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% Quarterly Rate per Dwelling: $ 21.08 $ 21.29 $ 21.93 $ 22.81 $ 23.72 $ 24.67 $ 25.65; $ 26.68 20 City of (Brook&n Center 2011 Budget FUND: Storm Drainage Utility Fund — 65100 DEPT /ACTIVITY /PROJECT: Operations — 49411 PROFILE This division provides for the collection and management of stormwater throughout the city in compliance with State and Federal regulatory requirements. The Storm Drainage Utility operates and maintains approximately 84 miles of storm sewers and 88 storm water management ponds or treatment devices. The Storm Drainage Utility also provides for street sweeping operations and the City's participation in two joint powers Watershed Commissions, which provide for regional planning, surface water quality monitoring, and Wetlands Conservation Act compliance. DEPARTMENTAL GOALS • Perform street sweeping operations to reduce sediment discharge to surface waters. • Televise storm sewer pipe to identify damaged or failed pipe segments. • Repair deteriorated drainage pipes and structures. • Clean and inspect outfalls, skimmers, ponds and sediment structures per NPDES requirements. • Inspect public and private ponds and treatment systems. EXPENDITURE DETAILS 6239 Repair and Maintenance Supplies -Other Provides for supplies when city employees perform the maintenance and repairs on system structures and facilities as part of ongoing maintenance items. 6307 Professional Services This item provides funding for approximately 20 percent of the cost of a safety consultant to provide required safety training mandated by OSHA. Remaining portion of safety consultant cost is charged to water, sanitary, engineering and streets. 6409 Repair and Maintenance Svs -Other Provides for ongoing maintenance and repair services on the Shingle Creek weir; provides funding for the cost of replacement castings, rip rap, catch basins and other pipe storm s materials needed to address unscheduled repairs to the City's drainage g system; , provides for a portion of the annual maintenance of infiltration basins along Bass Lake Road, Dupont Avenue and in Riverdale Park; provides for the annual maintenance of the pervious concrete along Dupont Avenue; and provides for the annual maintenance services provided by Tree Trust pertaining to Citywide storm drainage and ponding system maintenance. 6434 Dues & Subscriptions Annual dues of the Shingle Creek and West Mississippi Watershed Management Organizations. 21 III 6461 Fuel Charges Fuel costs for operating 1 -Ton utility truck and two street sweepers assigned to the Storm Sewer Utility Budget. 6462 Fixed Charges Replacement and overhead charges for 1-Ton utility truck and two street sweepers assigned to the Storm Sewer Utility Budget. 6463 Repair & Maintenance Charges Repair and maintenance charges for 1 -Ton utility truck and two street sweepers assigned to the Storm Sewer Utility Budget. 6530 Capital Outlay Reimbursement for Storm Sewer Utility portion of annual street and utility improvement project costs. PERSONNEL LEVELS 2 Full -Time Maintenance II One Engineering Technician is distributed over water, sewer and storm sewer utilities. CAPITAL OUTLAY See 2011 Capital Improvement Program Summary. 22 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 65100 STORM SEWER UTILITY FUND 49411 STORM SEWER UTILITY - OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4340 STATE REVENUE 4370 OTHER GRANTS /AID 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 45,746- 25,184 24,000- 6,276- 3,882- 3,882- 4605 UNREALIZED INVESTMENT GAINILOS 2,933- 1,071- 4612 DONATIONS & CONTRIBUTIONS 200- 200- 150- 4707 PENALTIES 26,214 26,938- 18,258- 4600 MISCELLANEOUS REVENUE 75,092- 53,394 24,000- 24,684 3,882- 3,882- 4599 MISCELLANEOUS REVENUE 75,092- 53,394 24,000- 24,684 3,882- 3,882- 4730 STORM SEWER UTILITY FUND 4731 STORM DRAINAGE FEES 1,526,822- 1,550,741- 1,581,554 1,008,553- 1,597,370- 1,597,370- 4730 STORM SEWER UTILITY FUND 1,526,822- 1,550,741- 1,581,554 1,008,553- 1,597,370- 1,597,370- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 1,457,408- 114,441- 25,258- 4900 OTHER FINANCING SOURCES 1,457,408- 114,441- 25,258- 4001 REVENUES 3,059,323- 1,718,576- 1,605,554 1,058,49 1,601,252- 1,601,252- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 55,346 43,904 109,500 44,546 109,500 109,500 6102 OVERTIME -FT EMPLOYEES 1,701 1,363 1,000 969 1,000 1,000 6100 WAGES AND SALARIES 57,047 45,267 110,500 45,515 110,500 110,500 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 99 352 6110 OTHER PAYMENTS -NON INSURANCE 99 352 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 3,706 3,055 7,665 3,186 7,735 7,735 6125 FICA 3,646 2,852 6,788 2,832 6,850 6,850 6126 MEDICARE CONTRIBUTIONS 853 667 1,589 662 1,604 1,604 6120 RETIREMENT CONTRIBUTIONS 8,205 6,573 16,042 6,681 16,189 16,189 613 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 10,901 9,905 25,920 9,037 27,072 27,072 6130 INSURANCE BENEFITS 10,901 9,905 25,920 9,037 27,072 27,072 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3,458 3,905 7,453 3,922 8,394 8,394 6150 WORKER'S COMPENSATION 3,458 3,905 7,453 3,922 8,394 8,394 6099 PERSONAL SERVICES 79,710 66,003 159,915 65,155 162,155 162,155 23 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6199 SUPPLIES 6200 OFFICE SUPPLIES 6204 STATIONARY SUPPLIES 743 504 752 800 800 6200 OFFICE SUPPLIES 743 504 752 800 800 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 624 422 500 31 500 500 6224 STREET MAINT MATERIALS 2,988 7,500 1,105 7,500 7,500 6210 OPERATING SUPPLIES 624 3,410 8,000 1,136 8,000 8,000 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 9,890 6,437 20,000 728 20,000 20,000 6230 REPAIR & MAINT SUPPLIES -OTHER 9,890 6,437 20,000 728 20,000 20,000 6240 SMALL TOOLS & MINOR EQUIPMENT 6243 MINOR COMPUTER EQUIPMENT 1,917 6240 SMALL TOOLS & MINOR EQUIPMENT 1,917 6199 SUPPLIES 13,174 10,351 28,000 2,616 28,800 28,800 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 1,574 1,573 1,620 1,525 1,700 1,700 6302 ARCH, ENG & PLANNING 10,526 20,000 20,000 20,000 6307 PROFESSIONAL SERVICES 203 277 250 321 1,340 1,340 6300 PROFESSIONAL SERVICES 12,304 1,850 21,870 1,846 23,040 23,040 6320 COMMUNICATIONS 6322 POSTAGE 2,100 2,100 2,100 6320 COMMUNICATIONS 2,100 2,100 2,100 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 48 6330 TRANSPORTATION 48 6340 ADVERTISING 6342 LEGAL NOTICES 32 25 25 25 6340 ADVERTISING 32 25 25 25 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 2,618 2,193 2,740 3,415 2,500 2,500 6360 INSURANCE 2,618 2,193 2,740 3,415 2,500 2,500 6400 REPAIR & MAINT SERVICES 6409 OTHER REPAIR & MAINT SVCS 1,539 3,542 20,000 20,000 20,000 6400 REPAIR & MAINT SERVICES 1,539 3,542 20,000 20,000 20,000 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 224 6423 LOGIS CHARGES 12,334 12,996 13,049 8,150 13,795 13,795 6420 IS SERVICES/LICENSES /FEES 12,558 12,996 13,049 8,150 13,795 13,795 6430 MISCELLANEOUS 24 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9130/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6434 DUES & SUBSCRIPTIONS 49,501 51,847 50,626 50,802 58,434 56,434 6430 MISCELLANEOUS 49,501 51,847 50,628 50,802 58,434 58,434 6440 OTHER EXPENSES 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 7,290 4,378 7,569 3,847 6,914 6,914 6462 FIXED CHARGES 3,743 4,122 4,118 3,106 3,958 3,958 6463 REPAIR & MAINT CHARGES 13,058 13,189 14,000 18,570 17,640 17,640 6465 REPLACEMENT CHARGES 48,597 59,119 37,493 29,050 52,006 52,006 6460 CENTRAL GARAGE CHARGES 72,688 80,809 63,180 54,573 80,518 80,518 6470 TRANSFERSAND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 47,534 57,883 71,145 53,359 71,541 71,541 6473 STORM SEWER TRANSFER 100,000 100,000 100,000 75,000 6470 TRANSFERS AND OTHER USES 147,534 157,883 171,145 128,359 71,541 71,541 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 763,536 858,450 901,375 664,985 997,475 997,475 6499 EXPENSES REIMBURSED 22,051 6490 OTHER MISC COSTS/EXPENSES 763,536 880,501 901,375 664,985 997,475 997,475 6299 OTHER CHARGES & SERVICES 1,062,357 1,191,621 1,246,087 912,155 1,269,428 1,269,428 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 10,125 1,936,000 1,917,000 1,917,000 6501 CAPITAL OUTLAY 10,125 1,936,000 1,917,000 1,917,000 6500 CAPITAL OUTLAY 10,125 1,936,000 1,917,000 1,917,000 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 1,155,241 1,278,100 3,370,002 979,926 3,377,383 3,377,383 4000 REVENUES AND EXPENSES 1 440,475- 1,764,448 78,569- 1,776,131 1,776,131 49411 STORM SEWER UTILITY - OPERATIONS 1,904,082- 440,475- 1,764,448 78,569- 1,776,131 1,776,131 25 This page has been left blank intentionally. 26 City of Brooklyn Center Storm Sewer Fund Cash Flow Analysis NORMAL SCHEDULE Rate Increase 3.00% 1.00% 1.00% 2.00% 2.00% 2.00% 2.00% 2.00% Per Residential Lot 14.19 14.34 14.48 14.77 15.06 15.36 15.67 15.9 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Storm Sewer Fees $ 1,577,679 $ 1,581,554 $ 1,597,370 $ 1,629,317 $ 1,661,903 $ 1,695,141 $ 1,729,044 $ 1,763,625 Misc. Operating $ - $ $ $ Misc. Non - operating $ 26,255 $ 9,200 $ 3,882 $ 755 $ 4,567 $ 5,649 $ 6,118 $ 7,155 Total Revenues $ 1,603,934 $ 1,590,754 $ 1,601,251 $ 1,630,072 $ 1,666,470 $ 1,700,190 $ 1,735,162 $ 1,770,780 Expenditures Personal Services $ 66,003 $ 159,915 $ 162,155 $ 170,263 $ 178,776 $ 187,715 $ 197,100 $ 206,955 Supplies $ 10,351 $ 28,000 $ 28,800 $ 29,664 $ 30,554 $ 31,471 $ 32,415 $ 33,387 Services $ 343,296 $ 244,712 $ 274,935 $ 283,183 $ 291,679 $ 300,429 $ 309,442 $ 318,725 Depreciation $ 858,450 $ 901,375 $ 997,475 $ 1,027,399 $ 1,058,221 $$ 1,089,968 $$ 1,122,667 $$ 1,156,347 Debt Service Interest & Fees $ - $ $ - $ $ Total Expenditures $ 1,278,100 $ 1,334,002 $ 1,463,365 $ 1,510,509 $ 1,559,230 $ 1,609,582 $ 1,661,624 $ 1,715,414 less: Non -Cash Depreciation $ 858,450 $ 901,375 $ 997,475 $ 1,027,399 $ 1,058,221 $ 1,089,968 $ 1,122,667 $ 1,156,347 plus: Cash Transfer to GF $ 100,000 $ 100,000 $ - $ - $ _ $ $ $ lv p lus: Debt Service Principal $ - $ - $ $ $ �1 plus: Transfers $ $ - $ $ $ $ $ $ plus: Cash Capital Outlay $ 1,015,061 $ 2,230,800 $ 1,917,000 $ 194,000 $ 895,000 $ 1,064,000 $ 937,000 $ 1,267,000 Total Cash Requirement $ 1 534 711 $ 2 763 427 $ 2,382 890 $ 677,110 $ 1,396,008 $ 1,583,614 $ 1,475,957 $ 1,826,068 Beginning Cash Balance $ 1,929,535 $ 2,143,141 $ 970,468 $ 188,829 $ 1,141,792 $ 1,412,254 $ 1,529,430 $ 1,788,635 Changes in Assets /Liabilities $ 144,383 $ - $ $ $ $ Cash Received $ 1,603,934 $ 1,590,754 $ 1,601,251 $ 1,630,072 $ 1,666,470 $ 1,700,790 $ 1,735,162 $ 1,770,780 Cash Spent $ (1 534 711) $ (2 763 427) $ (2 382 890) $ (677 110) $ (1 396 0 08) $ (1 583 614) $ (1 475 957) $ (1,826,06 Ending Cash Balance $ 2,143,141 $ 970,468 $ 188,829 $ 1,141,792 $ 1,412,254 $ 1,529,430 $ 1,788,635 $ 1,733 347 Cash Reserve Target $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation with no provisions made for changes in balance sheet items that may affect cash balances. Revenues Rate increase reflect additions to the gross income based on ordinance charges Expenditures Personnel Costs increase at a rate of 5% per year. Supplies and Services increase at a rate of 3% per year. Capital outlay is from the 2011 CIP C I P uti I ity ratre s 200th rj2024. xlsx Storm Sewer Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 1.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Quarterly per Residential Lot: 14.19 14.33 14.76 15.20 15.66 16.13 16.61 17.11 2011 Cash Analysis Rate Increase: 3.00% 1.00% 1.00% 2.00% 2.00% 2.00% 2.00% 2.00% Quarterly per Residential Lot: 14.19 14.33 14.48 14.77 15.06 15.36 15.67 15.99 28 City of Brook&n Center 2011 Budget FUND: Street Light Utility Fund — 65200 DEPT /ACTIVITY/PROJECT: Street Lights — 49571 PROFILE The Street Light Utility provides for electrical and maintenance fees paid to Xcel Energy for street lights owned by Xcel Energy. It also provides for electrical service, maintenance, repair, and replacement of lights owned by the City. The City owns approximately 71 ornamental lights, primarily in the Earle Brown commercial area, 85 ornamental lights on Brooklyn Boulevard, 40 ornamental lights along Xerxes Avenue, 72 ornamental lights along Bass Lake Rd and 57`" Avenue and leases about 915 lights from NSP. Another 97 lights owned by the City are located on traffic signal posts and mast arms. DEPARTMENTAL GOALS • Maintain and operate the City's street light system. • Reduce energy consumption and costs by updating and implementing more cost effective and advanced technology pertaining to the Citywide street light system. EXPENDITURE DETAILS 6239 Repair and Maintenance Supplies -Other Provides for maintenance supplies for City owned and operated street lights in and along the Earle Brown Center, Brooklyn Blvd, Xerxes Avenue, Bass Lake Road, 57 Avenue and intersection lighting at intersections with traffic signal systems. 6381 Utility Service - Electric Electric utility costs for street lights. 6409 Repair and Maintenance Svs -Other Provides for contractual services for maintenance of those street lights that are not Xcel Energy's responsibilities for service. 6530 Improvements Reimbursement for Street Light Utility portion of annual street and utility improvement project costs. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY See 2011 Capital Improvement Program Summary 29 i This page has been left blank intentionally. 30 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 913012010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 65200 STREET LIGHT UTILITY FUND 49571 STREET LIGHT - OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 3,827- 1,027- 1,000- 363- 500- 500- 4605 UNREALIZED INVESTMENT GAIN /LOS 110- 40- 4707 PENALTIES 5,458- 5,089 3,638- 4600 MISCELLANEOUS REVENUE 9,396- 6,156- 1,000- 4,000- 500- 500- 4599 MISCELLANEOUS REVENUE 9,396- 6,156- 1,000- 4,000- 500- 500- 4740 STREET LIGHT UTILITY FUND 4741 STREET LIGHT SERVICE CHARGE 244,802- 248,664- 259,426- 164,732- 267,209- 267,209 - 4740 STREET LIGHT UTILITY FUND 244,802- 248,664 259,426- 164,732- 267,209- 267,209- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 329,577- 3,135 4900 OTHER FINANCING SOURCES 329,577- 3,135- 4001 REVENUES 583,775- 257,956- 260,426- 168,732- 267.709- 267,709- 6001 EXPENDITURES/EXPENSES 6199 SUPPLIES 6200 OFFICE SUPPLIES 6204 STATIONARY SUPPLIES 59 40 60 60 60 6200 OFFICE SUPPLIES 59 40 60 60 60 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 856 799 2,500 2,500 2,500 6230 REPAIR & MAINT SUPPLIES -OTHER 856 799 2,500 2,500 2,500 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES. 915 839 2,500 60 2,560 2,560 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6302 ARCH, ENG & PLANNING 12,000 6307 PROFESSIONAL SERVICES 93 121 50 50 50 6300 PROFESSIONAL SERVICES 93 121 12,000 50 50 50 6320 COMMUNICATIONS 6322 POSTAGE 1,575 6320 COMMUNICATIONS 1,575 6330 TRANSPORTATION 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,162 1,062 1,335 1,494 1,400 1,400 6360 INSURANCE 1,162 1,062 1,335 1,494 1,400 1,400 31 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/3012010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6380 UTILITY SERVICES 6381 ELECTRIC 159,106 172,240 180,000 107,070 185,000 185,000 6380 UTILITY SERVICES 159,106 172,240 180,000 107,070 185,000 185,000 6400 REPAIR & MAINT SERVICES 6409 OTHER REPAIR & MAINT SVCS 6,218 24,638 15,000 1,538 15,000 15,000 6400 REPAIR & MAINT SERVICES 6,218 24,638 15,000 1,538 15,000 15,000 6420 IS SERVICES /LICENSES/FEES 6423 LOGIS CHARGES 3,262 2,035 3,449 3,449 6420 IS SERVICES/LICENSES /FEES 3,262 2,035 3,449 3,449 6440 OTHER EXPENSES 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 14,909 15,553 15,660 11,745 15,598 15,598 6482 MISC TRANSFER OUT 50,175 6470 TRANSFERS AND OTHER USES 65,084 15,553 15,660 11,745 15,598 15,598 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 5,566 4,175 8,700 8,700 6490 OTHER MISC COSTS/EXPENSES 5,566 4,175 8,700 8,700 6299 OTHER CHARGES & SERVICES 231,662 219,180 228,832 128,107 229,197 229,197 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 78,000 8,392 107,000 107,000 6501 CAPITAL OUTLAY 78,000 8,392 107,000 107,000 6500 CAPITAL OUTLAY 76,000 8,392 107,000 107,000 6001 EXPENDITURES/EXPENSES 232,578 220,020 309,332 136,559 338,757 338,757 4000 REVENUES AND EXPENSES 351,198- 37,936- 48,906 32,173- 71,048 71,048 49571 STREET LIGHT - OPERATIONS 351,198- 37,936- 48,906 32,173- 71,048 71,048 65200 STREET LIGHT UTILITY FUND 351,198- 37,936- 48,906 32,173- 71,048 71,048 32 �r CITY OF BROOKLYN CENTER STREET LIGHT FUND CASH FLOW ANALYSIS Rate Increase 2.00% 3.00% 3.00% 3.00% 3.00% 5.00% 5.00% 3.00% Quarterly Rate per Dwelling U 3.73 3.84 3.95 4.07 4.19 4.40 4.62 4.76 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Street Light Fee $ 253,754 $ 259,426 $ 267,209 $ 275,225 $ 283,482 $ 297,656 $ 312,539 $ 321,915 Misc. Operating $ - $ - $ - $ - $ - $ - $ - $ - Misc. Non - operating $ 1,067 $ 500 $ 500 $ - $ 500 $ 500 $ 500 $ 500 Total Revenues $ 254,821 $ 259,926 $ 267,709 $ 275,225 $ 283,982 $ 298,156 $ 313,039 $ 322,415 Expenditures Personal Services $ - $ - $ - $ - $ - $ - $ - $ - Supplies $ 839 $ 2,500 $ 2,560 $ 2,637 $ 2,716 $ 2,797 $ 2,881 $ 2,968 Services $ 213,615 $ 228,832 $ 220,469 $ 225,981 $ 231,630 $ 237,421 $ 243,357 $ 249,440 Depreciation $ 5,566 $ - $ 8,700 $ 8,874 $ 9,051 $ 9,233 $ 9,417 $ 9,606 Debt Service or Transfer $ - $ - $ - $ - $ - $ - $ - $ - Total Expenditures $ 220,020 $ 231,332 $ 231,729 $ 237,492 $ 243,398 $ 249,451 $ 255,655 $ 262,014 Capital Outlay/Transfers $ - $ 78,000 $ 107,000 $ - $ 79,000 $ 57,000 $ 98,000 $ 50,000 Total Cash Requirement $ 220,020 $ 309,332 $ 338,729 $ 237,492 $ 322,398 $ 306,451 $ 353,655 $ 312,014 v� I, Beginning Cash Balance $ 72,996 $ 117,678 $ 68,272 $ 5,952 $ 52,559 $ 23,195 $ 24,132 $ (7,067) Changes in Assets /Liabilities $ 4,315 $ - $ - $ - $ - $ - $ - $ - Revenues $ 254,821 $ 259,926 $ 267,709 $ 275,225 $ 283,982 $ 298,156 $ 313,039 $ 322,415 Expenditures $ (220,020) $ (309,332) $ (338,729) $ (237,492) $ (322,398) $ (306,451) $ (353,655) $ (312,014) Depreciation Add -Back $ 5,566 $ - $ 8,700 $ 8,874 $ 9,051 $ 9,233 $ 9,417 $ 9,606 Ending Cash Balance $ 117,678 $ 68,272 $ 5,952 $ 52,559 $ 23,195 $ 24,132 $ (7,067) $ ' 12,940 Cash Reserve Target $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation with no provisions made for changes in balance sheet items that may occur from year to year. Revenues Rate increases are based on customer count of 8,415 residential customers and 538 others. Expenditures Supplies and Services increase at a total rate of 3% per annum. Depreciation increases at a rate of approximately 2% per annum. Capital outlay is from the 2011 CIP Street Light Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 2.00% 3.00% 4.00% 5.00% 5.00% 5.00% 5.00% 3.00% Quarterly Rate per Dwelling: 3.73 3.84 4.00 4.20 4.41 4.63 4.86 5.00 2011 Cash Analysis Rate Increase: 2.00% 3.00% 3.00% 3.00% 3.00% 5.00% 5.00% 3.00% Quarterly Rate per Dwelling: 3.73 3.84 3.95 4.07 4.19 4.40 4.62 4.76 34 City of Brook& Center 2011 Budget FUND: Recycling Fund - 65300 DEPT /ACTIVITY /PROJECT: Recycling Fund - 49311 PROFILE The recycling fund accounts for the operation and administration of the City's state - mandated curbside recycling program. Revenues are from customer service fees with expenses comprised of amounts paid to the Hennepin Recycling Group (HRG), a four cities consortium for recycling services. DEPARTMENTAL GOALS * To provide bi- weekly collection of recyclables. * To continue an effective curbside recycling program while keeping rates as affordable as possible. * To identify program needs and develop funding mechanisms that provide sufficient revenues. REVENUE DETAILS 4751 Recycling Service Fees Projection is based on monthly rate of $ 2.81 per household ($ 8.43 per quarter) for bi- weekly pickup of recyclables. This represents a 2.0% increase over the monthly fee of $ 2.75666 ($ 8.27 per quarter) charged in 2010 EXPENDITURE DETAILS 6449 Other Contractual Services Projection is based on a monthly charge of $ 2.50 per household ($ 7.50 per quarter) from Hennepin Recycling Group (HRG) for pickup and processing of recyclables by Waste Management plus an administrative fee for HRG operations. This is an increase of $ .05 per month (2.0 %) from HRG. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY None requested. 35 This page has been left blank intentionally. 36 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9130/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 65300 RECYCLING FUND 49311 RECYCLING 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 103- 25- 1 4707 PENALTIES 9,048- 7,969- 6,274 - 4600 MISCELLANEOUS REVENUE 9,151- 7,994- 6,276- 4599 MISCELLANEOUS REVENUE 9,151- 7,994- 6,276- . 4750 RECYCLING FUND 4751 RECYCLING SERVICE FEES 250,726- 259,347- 284,242- 174,788- 289,927- 289,927- , 284 . 4750 RECYCLING FUND 250,726- 259,347- 242- 174,788- 289,927- 289,927- , 4900 OTHER FINANCING SOURCES 4001 REVENUES 259,877- 267,341- 264,242- 181,064 289,927- 289,927- 6001 EXPENDITURES /EXPENSES 6199 SUPPLIES 6200 OFFICE SUPPLIES 6204 STATIONARY SUPPLIES 89 61 90 6200 OFFICE SUPPLIES 89 61 90 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES 89 61 90 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 128 165 171 120 120 6300 PROFESSIONAL SERVICES 128 165 171 120 120 6320 COMMUNICATIONS 6330 TRANSPORTATION 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,581 1,405 1,765 1,788 1,910 1,910 6360 INSURANCE 1,581 1,405 1,765 1,768 1,910 1,910 6420 IS SERVICES/LICENSES /FEES 6423 LOGIS CHARGES 6,167 6, 3 2,035 3.449 3,449 6420 IS SERVICES /LICENSES /FEES 6,167 6,498 3,262 2,035 3,449 3,449 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 243,109 252,377 252,400 193,261 257,700 257,700 6440 OTHER EXPENSES 243,109 252,377 252,400 193,261 257,700 257,700 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 14,909 37 15,553 15,660 11,745 16,560 16,560 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/3012010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6470 TRANSFERS AND OTHER USES 14,909 15,553 15,660 11,745 16,560 16,560 6299 OTHER CHARGES & SERVICES 265,894 275,998 273,087 209,000 279,739 279,739 6001 EXPENDITURES/EXPENSES 265,983 276,058 273,087 209,090 279,739 279,739 4000 REVENUES AND EXPENSES 6,106 8,717 11,155- 28,026 10,188- 10,188- 49311 RECYCLING 6,106 8,717 11,155- 28,026 10,188- 10,188- 65300 RECYCLING FUND 6,106 8,717 11,155- 28,026 10,188- 10,188- 38 .3rw City Brooklyn Center Recycling Fund Rate Analysis Rate Increase 3.00% 6.00% 2.00% 3.00% 3.00% 3.00% 3.00% 3.00% Quarterly Residential Rate 7.80 8.27 8.43 8.68 8.94 9.21 9.49 9.77 Actual Budget Proposed Projected Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 2016 Revenues Recycling Fee $ 267,316 $ 284,242 $ 289,927 $ 298,625 $ 307,583 $ 316,811 $ 326,315 $ 336,105 Misc. Operating $ - $ - $ - $ - $ - $ - $ $ Misc. Non - operating $ 25 $ - $ - $ - $ - $ - $ $ Total Revenues $ 267,341 $ 284,242 $ 289,927 $ 298,625 $ 307,583 $ 316,811 $ 326,315 $ 336,105 Expenditures Personal Services $ - $ - $ - $ - $ - $ $ - $ - Supplies $ 61 $ - $ - $ - $ - $ - $ $ - Services $ 275,997 $ 273,087 $ 279,739 $ 288,131 $ 296,775 $ 305,678 $ 314,849 $ 324,294 Depreciation $ - $ - $ - $ - $ - $ - $ $ Debt Service $ - $ - $ - $ - $ $ $ $ Total Expenditures $ 276,058 $ 273,087 $ 279,739 $ 288,131 $ 296,775 $ 305,678 $ 314,849 $ 324,294 w Capital Outlay/Transfers $ - $ - $ - $ - $ - $ - $ - $ ` Total Cash Requirement $ 276,058 $ 273,087 $ 279,739 $ 288,131 $ 296,775 $ 305,678 $ 314,849 $ 324,294 Beginning Cash Balance $ (4,354) $ (14,337) $ (3,182) $ 7,006 $ 17,499 $ 28,308 $ 39,440 $ 50,907 Changes in Assets /Liabilities $ (1,266) $ - $ - $ - $ - $ - $ - $ - Revenues $ 267,341 $ 284,242 $ 289,927 $ 298,625 $ 307,583 $ 316,811 $ 326,315 $ 336,105 Expenditures $ (276,058) $ (273,087) $ (279,739) $ (288,131) $ (296,775) $ (305,678) $ (314,849) $ (324,294) Depreciation Add -Back $ - $ - $ - $ - $ - $ - $ - $ Ending Cash Balance (14,337) (3,182) 7,006 17,499 28,308 $ 39,440 50,907 62,717 Cash Reserve Target $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Expenditures Supplies and Services increase at a rate of about 3% per annum. Cash Reserve Target The cash reserve target is established by estimating 2 months' service charges from Hennepin Recycling Group This page has been left blank intentionally. 4{� Recycling Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 6.00% 3.00, °% 3.00% 3.00% 3.00% 3.00% 3.00% Quarterly Residential Rate: 7.80 8.27 8.52 8.77 9.03 9.31 9.58 9.87 2011 Cash Analysis Rate Increase: 3.00% 6.00% 2.00% 3.00% 3.00% 3.00% 3.00% 3.00% Quarterly Residential Rate: 7.80 8.27 8.43 8.68 8.94 9.21 9.49 9.77 41 Water Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 4.00% 5.00% 5.00% 6.00% 6.25% 5.00% 3.00% Rate per 1000 gallons: 1.29 1.34 1.41 1.48 1.57 1.67 1.75 1.80 2011 Cash Analysis Rate Increase: 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% Rate per 1000 gallons: 1.29 1.34 1.40 1.45 1.51 1.57 1.63 1.70 Sanitary Sewer Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 1.00% 1.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% Quarterly Rate per Dwelling: $ 21.08 $ 21.29 $ 22.14 $ 23.03 $ 23.95 $ 24.91 $ 25.90 $ 26.94 2011 Cash Analysis Rate Increase: 1.00% 1.00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% Quarterly Rate per Dwelling: $ 21.08 $ 21.29 $ 21.93 $ 22.81 $ 23.72 $ 24.67 $ 25.65 $ 26.68 Storm Sewer Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 1.00% 3.00% 3.00% 3.00% 3.00% 3.00% 300% Quarterly per Residential Lot: 14.19 14.33 14.76 15.20 15.66 16.13 16.61 17.11 2011 Cash Analysis Rate Increase: 3.00% 1.00% 1.00% 2.00% 2.00% 2.00% 2.00% 2.00% Quarterly per Residential Lot: 14.19 14.33 14.48 14.77 15.06 15.36 15.67 15.99 Street Light Utility Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 2.00% 3.00% 4.00% 5.00% 500% 5.00% 5.00% 3.00% Quarterly Rate per Dwelling: 3.73 3.84 4.00 4.20 4.41 4.63 4.86 1 5.00 2011 Cash Analysis Rate Increase: 2.00% 3.00% 3.00% 3.00% 3.00% 5.00% 5.00% 3.00% Quarterly Rate per Dwelling: 3.73 3.84 3.95 4.07 4.19 4.40 4.62 4.76 Recycling Fund 2009 2010 2011 2012 2013 2014 2015 2016 2010 Cash Analysis Rate Increase: 3.00% 6.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Quarterly Residential Rate: 7.80 8.27 8.52 8.77 9.03 9.31 9.58 9.87 2011 Cash Analysis Rate Increase: 3.00% 6.00% 2.00% 3.00% 3.00% 3.00% 3.00% 3.00% Quarterly Residential Rate: 7.80 8.27 8.43 8.68 8.94 9.21 9.49 9.77 a City of Brooklyn Center 2011 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 #0 site, and the seventh year at the 69`" 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 to im efforts rove • Build on recently implemented staff training and development p 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 wine club and other marketing efforts to add growth in the area of greatest profitability EXPENDITURE DETAILS 6471 Administrative Service Transfer Out $74,298 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 $135,000 This item provides for a base transfer of $ 135,000 to the Capital Projects Fund to support community infrastructure improvements, primarily in the parks. PERSONNEL LEVELS 1- Operations Manager 2 -Store Managers I - Office Manager Part-time and seasonal as necessary The Assistant Store Manager position was removed from the operational budget beginning in 2011 to increase profitability. CAPITAL OUTLAY 6540 Equipment and Machinery $73,192 Repair and Upgrade of Cooler Section in Store 1 $ 56,192 Security Camera upgrades in Stores 1 and 2 $ 17,000 43 This page has been left blank intentionally. 44 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 31,929- 14,897- 16,000- 3,559- 4,000 4,000 4605 UNREALIZED INVESTMENT GAIN /LOS 1,989- 485 4606 OTHER REVENUE 1,500- 1,500- 1,000 1,500- 1,500 4600 MISCELLANEOUS REVENUE 35,418- 16,882- 16,000- 4,559- 5,500 5,500 4599 MISCELLANEOUS REVENUE 35,418- 16,882- 16,000- 4,559- 5,500- 5,500- 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES 2,027,101- 2,081,625- 2,068,500- 1,461,485- 2,070,000- 2,070,000- 4762 WINE SALES 634,077- 636,260- 625,000- 459,929 - 640,000- 640,000- 4763 BEER SALES 2,635,304 2,718,373- 2,660,000- 1,917,332- 2,700,000- 2,700,000- 4764 SALES -NON TAXABLE 101,165- 82,488- 95,000- 51,270- 85,000- 85,000- 4765 SALES- TAXABLE 86,881- 91,362- 95,000- 68,547- 93,000- 93,000- 4760 LIQUOR STORE OPERATIONS 5,484,529- 5,610,108- 5,543,500- 3,958,563- 5,588,000- 5,588,000- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 1,127- 2,835- 250- 45 4922 PROJECT ADMINISTRATION 3,186- 4,008- 2,600- 2,419- 2,000 2,000 4900 OTHER FINANCING SOURCES 4,313- 6,843- 2,850- 2,464- 2,000- 2,000 - 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES - LIQUOR 1,400,686 1,420,855 1,428,000 991,232 1,450,000 1,450,000 5582 COST OF SALES -WINE 431,909 442,269 428,640 317,206 435,000 435,000 5583 COST OF SALES -BEER 2,003,811 2,068,467 2,026,000 1,450,195 2,085,000 2,085,000 5584 OTHER COSTS OF SALE - NONTAXABLE 65,742 51,608 62,300 30,106 56,000 56,000 5585 OTHER COSTS OF SALE - TAXABLE 59,557 65,646 62,300 46,839 61,800 61,800 5587 INVENTORY VARIANCES 11,334 15,526 13,300 7,693 13,200 13,200 5589 DELIVERY CHARGES 24,659 23,907 21,500 14,433 20,800 20,800 5580 COST OF GOODS SOLD 3,997,698 4,088,278 4,042,040 2,857,705 4,121,800 4,121,800 5550 DIRECT COST OF SALES 3,997,698 4,088,278 4,042,040 2,857,705 4,121,800 4,121,800 4001 REVENUES 1,526,562- 1,545,556- 1,520,310- 1,107,682- 1,473,700- 1,473,700 - 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 255,898 279,294 281,033 202,622 236,653 236,653 6103 WAGES -PART TIME EMPLOYEES 219,136 218,350 224,000 160,488 243,700 243,700 6104 OVERTIME -PART TIME EMPLOYEES 5,347 5,254 6,100 2,785 6,100 6,100 6100 WAGES AND SALARIES 480,381 502,898 511,133 365,895 486,453 486,453 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 3,456 4,984 6110 OTHER PAYMENTS -NON INSURANCE 3,456 4,984 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 30,182 32,719 19,671 24,786 34,051 34,051 6125 FICA 30,345 32,203 17,427 23,221 30,163 30,163 6126 MEDICARE CONTRIBUTIONS 7,097 7,531 4,074 5,431 7,054 7,054 45 CITY OF BROOKLYN CENTER SUMMARY Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6120 RETIREMENT CONTRIBUTIONS 67,624 72,454 41,172 53,438 71,268 71,268 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 34,801 40,767 54,000 32,619 45,120 45,120 6130 INSURANCE BENEFITS 34,801 40,767 54,000 32,619 45,120 45,120 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,414 6140 UNEMPLOYMENT COMPENSATION 1,414 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 11,425 12,278 6,577 8,854 11,722 11,722 6150 WORKER'S COMPENSATION 11,425 12;278 6,577 8,854 11,722 11,722 6099 PERSONAL SERVICES 597,687 634,795 612,882 460,806 614,563 614,563 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,632 1,672 1,400 772 1,400 1,400 6202 COPYING SUPPLIES 153 250 80 200 200 6200 OFFICE SUPPLIES 1,785 1,672 1,650 852 1,600 1,600 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 474 1,514 1,100 1,200 1,200 6219 GENERAL OPERATING SUPPLIES 15,958 12,971 15,000 7,542 14,000 14,000 6210 OPERATING SUPPLIES 16,432 14,486 16,100 7,542 15,200 15,200 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 312 1,805 2,400 3,500 3,500 6220 REPAIR & MAINT SUPPLIES 312 1,805 2,400 3,500 3,500 6230 REPAIR & MAINT SUPPLIES -OTHER 6237 LAUNDRY SUPPLIES 32 30 6230 REPAIR & MAINT SUPPLIES -OTHER 32 30 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 1,045 5,821 22,800 761 2,800 2,800 6243 MINOR COMPUTER EQUIPMENT 4,229 10,885 31,842 15,634 7,500 7,500 6240 SMALL TOOLS & MINOR EQUIPMENT 5,274 16,707 54,642 16,395 10,300 10,300 6199 SUPPLIES 23,836 34,669 74,792 24,819 30,600 30,600 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 4,498 4,495 4,650 4,377 4,400 4,400 6303 LEGAL SERVICES 251 259 6307 PROFESSIONAL SERVICES 198 17,232 12,350 8,281 6,000 6,000 6300 PROFESSIONAL SERVICES 4,696 21,978 17,000 12,917 10,400 10,400 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 5,179 5,226 5,825 6,877 2,375 2,375 6322 POSTAGE 316 6329 OTHER COMMUNICATION SERVICES 850 850 6320 COMMUNICATIONS 5,179 5,226 5,825 7,193 3,225 3,225 6330 TRANSPORTATION 46 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9130/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6331 TRAVEL EXPENSE/MILEAGE 457 858 800 457 850 850 6330 TRANSPORTATION 457 858 800 457 850 850 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 2,322 264 1,500 1,500 1,500 6349 OTHER ADVERTISING 9,892 19,060 19,000 12,464 19,000 19,000 6340 ADVERTISING 12,214 19,324 20,500 12,464 20,500 20,500 6350 PRINTING AND DUPLICATING 6351 PRINTING 145 774 700 442 1,000 1,000 6350 PRINTING AND DUPLICATING 145 774 700 442 1,000 1,000 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 916 852 1,070 865 1,254 1,254 6362 PROPERTY INSURANCE 1,533 1,475 1,850 1,328 1,898 1,888 6364 DRAM SHOP INSURANCE 8,619 7,628 9,380 6,118 8,727 8,727 6366 MACHINERY BREAKDOWN INSURANCE 447 380 490 325 463 463 6360 INSURANCE 11,514 10,336 12,790 8,635 12,342 12,342 6380 UTILITY SERVICES 6381 ELECTRIC 31,087 31,492 32,000 24,551 33,000 33,000 6382 GAS 9,943 6,375 8,500 3,564 8,000 8,000 6380 UTILITY SERVICES 41,030 37,867 40,500 28,115 41,000 41,000 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 1,260 2,680 6,432 7,000 7,000 6403 BLDGS/FACILITIES MAINT SERVICE 2,229 5,119 1,400 3,782 6,500 6,500 6400 REPAIR & MAINT SERVICES 3,489 7,798 1,400 10,214 13,500 13,500 6410 RENTALS 6412 BLDGS/FACILITIES 243,925 269,969 289,140 216,457 289,140 289,140 6410 RENTALS 243,925 269,969 289,140 216,457 289,140 289,140 6420 IS SERVICES /LICENSES /FEES 6421 SOFTWARE LICENSE 593 440 15,657 6,462 6422 SOFTWARE MAINT 821 961 1,721 1,561 1,052 1,052 6423 LOGIS CHARGES 9,747 13,880 13,273 8,829 13,366 13,366 6428 PROTECTION SERVICES 719 1,385 1,129 6420 IS SERVICES /LICENSES /FEES 11,880 16,667 30,651 17,981 14,418 14,418 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 6,440 7,320 7,200 4,549 7,700 7,700 6432 CONFERENCES AND SCHOOLS 1,678 1,485 2,100 1,544 2,100 2,100 6434 DUES & SUBSCRIPTIONS 2,553 3,225 3,500 2,200 3,300 3,300 6435 CREDIT CARD FEES 61,406 70,201 60,000 56,361 75,000 75,000 6438 CASH SHORT (OVER) 1,327 2,383 1,650 1,464 2,000 2,000 6430 MISCELLANEOUS 73,404 84,614 74,450 66,138 90,100 90,100 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 40 248 700 20 350 350 6442 COURT AWARDS /SETTLEMENTS 3,214 6449 OTHER CONTRACTUAL SERVICE 9,665 6,872 8,500 3,334 8,000 8,000 6440 OTHER EXPENSES 9,705 10,334 9,200 3,354 8,350 8,350 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 479 241 350 178 320 320 47 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6462 FIXED CHARGES 947 1,072 1,086 815 1,023 1,023 6463 REPAIR & MAINT CHARGES 283 484 400 113 200 200 6465 REPLACEMENT CHARGES 2,119 2,251 2,208 1,655 2,230 2,230 6460 CENTRAL GARAGE CHARGES 3,828 4,048 4,044 2,762 3,773 3,773 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 51,420 53,546 73,690 55,267 74,298 74,298 6476 CAPITAL PROJECT FUND TRANSFER 135,000 265,490 135,000 95,199 135,000 135,000 6470 TRANSFERS AND OTHER USES 186,420 319,036 208,690 150,466 209,298 209,298 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 26,431 26,359 27,600 13,550 20,260 20,260 6490 OTHER MISC COSTS/EXPENSES 26,431 26,359 27,600 13,550 20,260 20,260 6299 OTHER CHARGES & SERVICES 634,319 835,188 743,290 551,145 738,156 738,156 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 3,548 6540 EQUIPMENT & MACHINERY 4,957 6,753 73,192 73,192 6501 CAPITAL OUTLAY 4,957 10,301 73,192 73,192 6500 CAPITAL OUTLAY 4,957 10,301 73,192 73,192 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 1,255,841 1,509,609 1,430,964 1,047,072 1,456,511 1,456,511 4000 REVENUES AND EXPENSES 270,721- 35,947- 89,346- 60,811- 17,189- 17,189- 60900 BROOKLYN CENTER LIQUOR 270,721- 35,947- 89,346- 60,811- 17,189- 17,189 - 48 STORE # 1- XERXES "E. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 15,965- 7,448- 8,000- 1,780- 2,000- 2,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 994- 243- 4606 OTHER REVENUE 1,500- 1,500 1,000- 1,500- 1,500- 4600 MISCELLANEOUS REVENUE 18,459- 9,191- 8,000- 2,780- 3,500- 3,500- 4599 MISCELLANEOUS REVENUE 18,459- 9,191- 8,000- 2,780- 3,500- 3,500- 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES 1,473,865- 1,506,324- 1,500,000- 1,077,426- 1,500,000- 1,500,000- 4762 WINE SALES 441,702- 437,561- 433,000- 317,762 - 440,000- 440,000- 4763 BEER SALES 1,804,618- 1,817,733- 1,836,500- 1,323,400- 1,810,000- 1,810,000- 4764 SALES - NONTAXABLE 68,428- 55,539- 64,000- 35,693- 60,000- 60,000- 4765 SALES - TAXABLE 56,746- 60,875 - 64,000- 46,208 - 64,000- 64,000- 4760 LIQUOR STORE OPERATIONS 3,845,359- 3,878,032- 3,897,500- 2,800,489- 3,874,000- 3,874,000- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 868- 2,804- 250- 4 4922 PROJECT ADMINISTRATION 3,186- 4,008- 2,600- 2,419- 2,000- 2,000- 4900 OTHER FINANCING SOURCES 4,054- 6,812- 2,850- 2,464 2,000- 2,000- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES - LIQUOR 1,014,466 1,024,531 1,035,000 726,210 1,050,000 1,050,000 5582 COST OF SALES -WINE 297,663 300,355 300,000 217,129 299,000 299,000 5583 COST OF SALES -BEER 1,369,459 1,377,408 _ 1,400,000 998,061 1,400,000 1,400,000 5584 OTHER COSTS OF SALE - NONTAXABLE 44,087 35,039 42,300 21,080 39,000 39,000 5585 OTHER COSTS OF SALE - TAXABLE 38,880 43,422 42,300 31,367 42,300 42,300 5587 INVENTORY VARIANCES 8,918 12,126 9,500 6,128 10,000 10,000 5589 DELIVERY CHARGES 17,275 17,430 15,500 10,818 15,000 15,000 5580 COST OF GOODS SOLD 2,790,747 2,810,311 2,844,600 2,010,792 2,855,300 2,855,300 5550 DIRECT COST OF SALES 2,790,747 2,810,311 2,844,600 2,010,792 2,855,300 2,855,300 4001 REVENUES 1,077,125- 1,083,724 1,063,750- 794,941- 1,024,200- 1,024,200- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 164,847 183,092 186,262 142,126 150,459 150,459 6103 WAGES -PART TIME EMPLOYEES 143,873 148,268 155,000 108,973 169,500 169,500 6104 OVERTIME -PART TIME EMPLOYEES 2,812 2.942 3,500 1,441 3,500 3,500 6100 WAGES AND SALARIES 311,531 334,302 344,762 252,540 323,459 323,459 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 2,205 3,091 6110 OTHER PAYMENTS -NON INSURANCE 2,205 3,091 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 19,380 21,618 13,037 17,018 22,641 22,641 49 STORE # 1- XERXES "E. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6125 FICA 19,600 21,356 11,550 15,894 20,056 20,056 6126 MEDICARE CONTRIBUTIONS 4,584 4,995 2,700 3,717 4,690 4,690 6120 RETIREMENT CONTRIBUTIONS 43,563 47,969 27,287 36,629 47,387 47,387 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 29,312 35,192 43,200 28,319 33,840 33,840 6130 INSURANCE BENEFITS 29,312 35,192 43,200 28,319 33,840 33,840 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,414 6140 UNEMPLOYMENT COMPENSATION 1,414 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 7,398 8,165 4,359 6,117 7,794 7,794 6150 WORKER'S COMPENSATION 7,398 8,165 4,359 6,117 7,794 7,794 6099 PERSONAL SERVICES 394,010 430,133 419,608 323,604 412,480 412,480 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,143 1,237 1,000 533 1,000 1,000 6202 COPYING SUPPLIES 135 200 80 150 150 6200 OFFICE SUPPLIES 1,277 1,237 1,200 612 1,150 1,150 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 332 1,060 800 800 800 6219 GENERAL OPERATING SUPPLIES 11,220 9,169 10,000 5,536 10,000 10,000 6210 OPERATING SUPPLIES 11,552 10,229 10,800 5,536 10,800 10,800 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 312 1,285 1,900 2,500 2,500 6220 REPAIR & MAINT SUPPLIES 312 1,285 1,900 2,500 2,500 6230 REPAIR & MAINT SUPPLIES -OTHER 6237 LAUNDRY SUPPLIES 32 30 6230 REPAIR & MAINT SUPPLIES -OTHER 32 30 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 859 5,316 22,300 421 2,000 2,000 6243 MINOR COMPUTER EQUIPMENT 2,572 7,448 18,150 9,014 5,000 5,000 6240 SMALL TOOLS & MINOR EQUIPMENT 3,430 12,764 40,450 9,434 7,000 7,000 6199 SUPPLIES 16,605 25,515 54,350 15,613 21,450 21,450 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 4,498 4,495 4,650 4,377 4,400 4,400 6303 LEGAL SERVICES 251 259 6307 PROFESSIONAL SERVICES 80 16,811 7,841 5,230 5,000 5,000 6300 PROFESSIONAL SERVICES 4,577 21,557 12,491 9,866 9,400 9,400 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 2,959 2,891 3,225 1,514 1,475 1,475 6320 COMMUNICATIONS 2,959 2,891 3,225 1,514 1,475 1,475 6330 TRANSPORTATION 50 STORE # 1- XERXES "E. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6331 TRAVEL EXPENSE/MILEAGE 130 554 500 408 600 600 6330 TRANSPORTATION 130 554 500 408 600 600 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 1,903 185 1,000 1,000 1,000 6349 OTHER ADVERTISING 6,629 13,345 14,000 9,284 14,000 14,000 6340 ADVERTISING 8,532 13,530 15,000 9,284 15,000 15,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 102 590 500 442 800 800 6350 PRINTING AND DUPLICATING 102 590 500 442 800 800 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 424 352 535 433 627 627 6362 PROPERTY INSURANCE 839 476 850 464 663 663 6364 DRAM SHOP INSURANCE 5,900 5,249 6,580 4,301 6,137 6,137 6366 MACHINERY BREAKDOWN INSURANCE 134 92 170 113 163 163 6360 INSURANCE 7,297 6,169 8,135 5,312 7,590 7,590 6380 UTILITY SERVICES 6381 ELECTRIC 15,502 15,989 16,500 12,208 16,500 16,500 6382 GAS 5,006 3,242 4,500 1,985 4,000 4,000 6380 UTILITY SERVICES 20,508 19,232 21,000 14,193 20,500 20,500 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 310 644 5,690 5,000 5,000 6403 BLDGS /FACILITIES MAINT SERVICE 128 5,119 1,400 3,362 5,000 5,000 6400 REPAIR & MAINT SERVICES 438 5,762 1,400 9,052 10,000 10,000 6410 RENTALS 6412 BLDGS/FACILITIES 150,565 176,109 195,780 146,437 195,780 195,780 6410 RENTALS 150,565 176,109 195,780 146,437 195,780 195,780 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 569 308 9,953 6,335 6422 SOFTWARE MAINT 513 683 1,090 1,291 789 789 6423 LOGIS CHARGES 5,846 9,520 9,291 7,385 9,356 9,356 6428 PROTECTION SERVICES 336 639 618 6420 IS SERVICES /LICENSES/FEES 7,264 11,150 20,334 15,629 10,145 10,145 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 6,440 7,320 6,500 4,549 7,000 7,000 6432 CONFERENCES AND SCHOOLS 1,418 1,076 1,500 1,223 1,500 1,500 6434 DUES & SUBSCRIPTIONS 1,866 2,258 2,700 1,555 2,500 2,500 6435 CREDIT CARD FEES 41,679 48,068 42,000 38,737, 50,000 50,000 6438 CASH SHORT (OVER) 963 1,463 1,000 528 1,000 1,000 6430 MISCELLANEOUS 52,365 60,184 53,700 46,592 62,000 62,000 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 20 183 500 200 200 6442 COURT AWARDS /SETTLEMENTS 3,214 6449 OTHER CONTRACTUAL SERVICE 5,094 3,677 5,000 1,636 5,000 5,000 6440 OTHER EXPENSES 5,114 7,074 5,500 1,636 5,200 5,200 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 240 121 250 89 160 160 51 STORE # 1- XERXES AVE. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6462 FIXED CHARGES 474 536 543 408 512 512 6463 REPAIR & MAINT CHARGES 142 242 200 57 100 100 6465 REPLACEMENT CHARGES 1,060 1,125 1,104 828 1,115 1,115 6460 CENTRAL GARAGE CHARGES 1,914 2,024 2,097 1,381 1,887 1,887 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 34,280 26,773 36,845 33,774 49,557 49,557 6476 CAPITAL PROJECT FUND TRANSFER 117,000 265,490 135,000 95,199 135,000 135,000 6470 TRANSFERS AND OTHER USES 151,280 292,263 171,845 128,973 184,557 184,557 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 17,169 17,122 17,200 12,841 19,260 19,260 6490 OTHER MISC COSTS/EXPENSES 17,169 17,122 17,200 12,841 19,260 19,260 6299 OTHER CHARGES & SERVICES 430,214 636,210 528,707 403,561 544,194 544,194 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 3,548 6540 EQUIPMENT & MACHINERY 3,049 6,753 73,192 73,192 6501 CAPITAL OUTLAY 3,049 10,301 73,192 73,192 6500 CAPITAL OUTLAY 3,049 10,301 73,192 73,192 6001 EXPENDITURES/EXPENSES 840,829 1,094,907 1,002,665 753,079 1,051,316 1,051,316 4000 REVENUES AND EXPENSES 236,296- 11,183 61,085- 41,862- 27,116 27,116 49611 BROOKLYN CENTER LIQUOR 236,296- 11,183 61,085- 41,862- 27,116 27,116 52 STORE # 2 - BROOKLYN BLVD. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 15,965- 7,448- 8,000- 1,780- 2,000- 2,000 - 4605 UNREALIZED INVESTMENT GAIN/LOS 994- 243- 4600 MISCELLANEOUS REVENUE 16,959- 7,691- 8,000- 1,780- 2,000- 2,000- 4599 MISCELLANEOUS REVENUE 16,959- 7,691- 8,000- 1,780- 2,000- 2,000- 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES 553,236- 575,301- 568,500- 384,059- 570,000- 570,000- 4762 WINE SALES 192,375- 198,700- 192,000- 142,167- 200,000- 200,000- 4763 BEER SALES 830,686- 900,640- 823,500- 593,932- 890,000- 890,000- 4764 SALES -NON TAXABLE 32,737- 26,949- 31,000- 15,577- 25,000- 25,000- 4765 SALES- TAXABLE 30,136- 30,488- 31,000- 22,339- 29,000 29,000- 4760 LIQUOR STORE OPERATIONS 1,639,170- 1,732,077- 1,646,000- 1,158,074- 1,714,000• 1,714,000- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 259- 31- 4900 OTHER FINANCING SOURCES 259- 31- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES - LIQUOR 386,220 396,323 393,000 265,022 400,000 400,000 5582 COST OF SALES -WINE 134,247 141,914 128,640 100,078 136,000 136,000 5583 COST OF SALES -BEER 634,351 691,059 626,000 452,134 685,000 685,000 5584 OTHER COSTS OF SALE - NONTAXABLE 21,655 16,569 20,000 9,026 17,000 17,000 5585 OTHER COSTS OF SALE - TAXABLE 20,678 22,224 20,000 15,472 19,500 19,500 5587 INVENTORY VARIANCES 2,416 3,401 3,800 1,565 3,200 3,200 5589 DELIVERY CHARGES 7,385 6,477 6,000 3,616 5,800 5,800 5580 COST OF GOODS SOLD 1,206,951 1,277,967 1,197,440 846,913 1,266,500 1,266,500 5550 DIRECT COST OF SALES 1,206,951 1,277,967 1,197,440 846,913 1,266,500 1,266,500 4001 REVENUES 449,437- 461,832- 456,560- 312,941- 449,500- 449,500- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 91,051 96,202 94,771 60,496 86,194 86,194 6103 WAGES -PART TIME EMPLOYEES 75,264 70,082 69,000 51,515 74,200 74,200 6104 OVERTIME -PART TIME EMPLOYEES 2,535 2,312 2,600 1,344 2,600 2,600 6100 WAGES AND SALARIES 168,849 168,596 166,371 113,355 162,994 162,994 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 1,251 1,893 6110 OTHER PAYMENTS -NON INSURANCE 1,251 1,893 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 10,803 11,102 6,634 7,768 11,410 11,410 6125 FICA 10,745 10,847 5,877 7,327 10,107 10,107 6126 MEDICARE CONTRIBUTIONS 2,513 2,536 1,374 1,714 2,364 2,364 6120 RETIREMENT CONTRIBUTIONS 24,061 24,485 13,885 16,809 23,881 23,881 53 STORE # 2 - BROOKLYN BLVD. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 5,489 5,575 10,800 4,300 11,280 11,280 6130 INSURANCE BENEFITS 5,489 5,575 10,800 4,300 11,280 11,280 6140 UNEMPLOYMENT COMPENSATION 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 4,027 4,113 2,218 2,738 3,928 3,928 6150 WORKER'S COMPENSATION 4,027 4,113 2,218 2,738 3,928 3,928 6099 PERSONAL SERVICES 203,677 204,663 193,274 137,201 202,083 202,083 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 490 435 400 239 400 400 6202 COPYING SUPPLIES 18 50 50 50 6200 OFFICE SUPPLIES 508 435 450 239 450 450 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 142 454 300 400 400 6219 GENERAL OPERATING SUPPLIES 4,737 3,802 5,000 2,006 4,000 4,000 6210 OPERATING SUPPLIES 4,880 4,256 5,300 2,006 4,400 4,400 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 520 500 1,000 1,000 6220 REPAIR & MAINT SUPPLIES 520 500 1,000 1,000 6230 REPAIR & MAINT SUPPLIES -OTHER I 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 186 505 500 340 800 800 6243 MINOR COMPUTER EQUIPMENT 1,657 3,437 13,692 6,621 2,500 2,500 6240 SMALL TOOLS & MINOR EQUIPMENT 1,843 3,943 14,192 6,961 3,300 3,300 6199 SUPPLIES 7,231 9,154 20,442 9,207 9,150 9,150 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 119 422 4,509 3,051 1,000 1,000 6300 PROFESSIONAL SERVICES 051 1 000 1 CES 119 422 4,509 000 , 6320 COMMUNICATIONS 6321 TELEPHONEIPAGERS 2,221 2,336 2,600 5,362 900 900 6322 POSTAGE 316 6329 OTHER COMMUNICATION SERVICES 850 850 6320 COMMUNICATIONS 2,221 2,336 2,600 5,679 1,750 1,750 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 328 304 300 49 250 250 6330 TRANSPORTATION 328 304 300 49 250 250 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 419 79 500 500 500 6349 OTHER ADVERTISING 3,263 5,715 5,000 3,180 5,000 5,000 6340 ADVERTISING 3,682 5,794 5,500 3,180 5,500 5,500 54 STORE # 2 - BROOKLYN BLVD. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6350 PRINTING AND DUPLICATING 6351 PRINTING 44 184 200 200 200 6350 PRINTING AND DUPLICATING 44 184 200 200 200 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 492 500 535 433 627 627 6362 PROPERTY INSURANCE 694 999 1,000 864 1,235 1,235 6364 DRAM SHOP INSURANCE 2,719 2,380 2,800 1,816 2,590 2,590 6366 MACHINERY BREAKDOWN INSURANCE 312 287 320 211 300 300 6360 INSURANCE 4,217 4,167 4,655 3,324 4,752 4,752 6380 UTILITY SERVICES 6381 ELECTRIC 15,585 15,503 15,500 12,343 16,500 16,500 6382 GAS 4,937 3,133 4,000 1,580 4,000 4,000 6380 UTILITY SERVICES 20,522 18,635 19,500 13,922 20,500 20,500 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 950 2,036 742 2,000 2,000 6403 BLDGS/FACILITIES MAINT SERVICE 2,101 420 1,500 1,500 6400 REPAIR & MAINT SERVICES 3,050 2,036 1,162 3,500 3,500 6410 RENTALS 6412 BLDGS/FACILITIES 93,360 93,860 93,360 70,020 93,360 93,360 6410 RENTALS 93,360 93,860 93,360 70,020 93,360 93,360 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 25 132 5,704 127 6422 SOFTWARE MAINT, 308 279 631 270 263 263 6423 LOGIS CHARGES 3,901 4,360 3,982 1,444 4,010 4,010 6428 PROTECTION SERVICES 383 746 511 6420 IS SERVICES /LICENSES /FEES 4,616 5,516 10,317 2,352 4,273 4,273 6430 MISCELLANEOUS 6431 SPECIAL EVENTS 700 700 700 6432 CONFERENCES AND SCHOOLS 261 409 600 321 600 600 6434 DUES & SUBSCRIPTIONS 688 968 800 645 800 Boo 6435 CREDIT CARD FEES 19,727 22,133 18,000 17,644 25,000 25,000 6438 CASH SHORT (OVER) 364 920 650 935 1,000 1,000 6430 MISCELLANEOUS 21,039 24,430 20,750 19,546 28,100 28,100 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 20 65 200 20 150 150 6449 OTHER CONTRACTUAL SERVICE 4,571 3,195 3,500 1,698 3,000 3,000 6440 OTHER EXPENSES 4,591 3,260 3,700 1,718 3,150 3,150 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 239 121 100 89 160 160 6462 FIXED CHARGES 473 536 543 408 511 511 6463 REPAIR & MAINT CHARGES 142 242 200 57 100 100 6465 REPLACEMENT CHARGES 1,060 1,125 1,104 828 1,115 1,115 6460 CENTRAL GARAGE CHARGES 1,914 2,024 1,947 1,381 1,886 1,886 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 17,140 26,773 36,845 21,493 24,741 24,741 6476 CAPITAL PROJECT FUND TRANSFER 18,000 55 STORE # 2 - BROOKLYN BLVD. CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6470 TRANSFERS AND OTHER USES 35,140 26,773 36,845 21,493 24,741 24,741 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 9,262 9,237 10,400 708 1,000 1,000 6490 OTHER MISC COSTSIEXPENSES 9,262 9,237 10,400 708 1,000 1,000 6299 OTHER CHARGES & SERVICES 204,105 198,978 214,583 147,584 193,962 193,962 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 415,013 414,702 428,299 293,992 405,195 405,195 40DO REVENUES AND EXPENSES 34,425- 47,130- 28,261- 18,949 - 44,305- 44,305- 49612 69TH AVENUE LIQUOR STORE 34,425- 47,130- 28,261- 18,949 - 44,305- 44,305- 60900 BROOKLYN CENTER LIQUOR 270,721- 35,947- 89,346- 60,811- 17,189- 17,189 - 56 City of Brooklyn Center BC Liquor Cash Flows Actual Budget Proposed Projected Projected Projected Projected 2009 2010 2011 2012 2013 2014 2015 Revenues Customer Receipts $ 5,610,108 $ 5,543,500 $ 5,588,000 $ 5,643,880 $ 5,700,319 $ 5,757,322 $ 5,814,895 Misc. Operating $ 8,345 $ 2,850 $ 3,500 $ 9,800 $ 9,800 $ 9,800 $ 9,800 Misc. Non - operating $ 15,382 $ 16,000 $ 4,000 $ 14,297 $ 14,822 $ 15,089 $ 15,081 Total Revenues $ 5,633,835 $ 5,562,350 $ 5,595,500 $ 5,667,977 $ 5,724,941 $ 5,782,211 $ 5,839,776 Expenditures Personal Services $ 634,795 $ 612,882 $ 614,563 $ 639,146 $ 664,711 $ 691,300 $ 718,952 Supplies $ 34,669 $ 74,792 $ 30,600 $ 31,518 $ 32,464 $ 33,437 $ 34,441 Services $ 548,296 $ 580,690 $ 573,496 $ 590,701 $ 608,422 $ 626,675 $ 645,475 Cost of Good Sold $ 4,088,278 $ 4,042,040 $ 4,121,800 $ 4,148,252 $ 4,189,734 $ 4,231,632 $ 4,273,948 Depreciation $ 26,359 $ 27,600 $ 20,260 $ 26,500 $ 26,500 $ 26,500 $ 26,500 v, Debt Transfer $ - $ - $ - $ - $ - $ - $ - Total Expenditures $ 5,332,397 $ 5,338,004 $ 5,360,719 $ 5,436,116 $ 5,521,831 $ 5,609,543 $ 5,699,315 Capital Transfer $ 265,490 $ 135,000 $ 208,192 $ 200,000 $ 200,000 $ 200,000 $ 200,000 Total Cash Requirement $ 5,597,887 $ 5,473,004 $ 5,568,911 $ 5,636,116 $ 5,721,831 $ 5,809,543 $ 5,899,315 Beginning Cash Balance $ 1,318,525 $ 1,424,765 $ 1,541,711 $ 1,588,560 $ 1,646,921 $ 1,676,531 $ 1,675,698 Changes in Assets /Liabilities $ 43,933 $ - $ - $ - $ - $ - $ - Revenues $ 5,633,835 $ 5,562,350 $ 5,595,500 $ 5,667,977 $ 5,724,941 $ 5,782,211 $ 5,839,776 Expenditures $ (5,597,887) $ (5,473,004) $ (5,568,911) $ (5,636,116) $(5,721,831) $(5,809,543) $(5,899,315) Depreciation Add -Back $ 26,359 $ 27,600 $ 20,260 $ 26,500 $ 26,500 $ 26,500 $ 26,500 Ending Cash Balance $ 1,424,765 $ 1,541,711 $ 1,588,560 $ 1,646,921 $ 1,676,531 $ 1,675,698 $ 1,642,659 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. This page has been lelt blank intentionally. 58 City of Brook& Center 2011 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. Each year between 20,000 and 25,000 rounds of golf are played at Centerbrook. In f recent experience, projections As a result o , addition about 250 people will take lessons. p P p p for the 2011 budget have been calculated at 21,000 rounds. For the 2011 budget, the revenues and expenses related to beer sales at the Dudley softball tournament are included in this fund. This was done to provide a new revenue stream for the golf course and 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. EXPENDITURE DETAILS 6103 Part-Thine $60,000 Clubhouse staff, rangers, part-time golf professional, seasonal golf course manager, and maintenance workers. 59 6212 Motor Fuels $2,000 Fuel for mowers and other golf course equipment. 6216 Chemical Products $5,000 Herbicides insecticides, snow mold treatment and other chemical used to maintain the fairways and greens. 6219 Operating Supplies $1,750 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. 6415 Rentals $4,500 The cost of leasing golf carts for rental to patrons. PERSONNEL LEVELS 1- Grounds Supervisor CAPITAL OUTLAY Cash flows do not allow the $ 24,900 in planned capital investment to occur. 60 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/3012010 2011 2011 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 858- 81- 4605 UNREALIZED INVESTMENT GAIN /LOS 12 4600 MISCELLANEOUS REVENUE 870- 81- 4599 MISCELLANEOUS REVENUE 870- 81- 4770 CENTERBROOK GOLF COURSE 4771 GOLF LESSONS 1,580- 1,644 1,750- 1,464 2,000- 2,000- 4773 GREEN FEES 147,589- 137,287- 155,000- 117,391- 152,500- 152,500- 4778 PASSBOOK 22,943- 25,688- 26,000- 23,124 26,000- 26,000- 4782 RENTALS 13,470- 12,524 13,000- 10,664 13,000- 13,000- 4785 LEAGUE 12,094 10,283- 13,000- 9,975- 13,000- 13,000- 4786 BEER & WINE COOLER REVENUES 32,431- 37,135- 38,000- 24,431- 38,000- 38,000- 4787 FOOD & BEVERAGE REVENUES 7,108- 6,424 7,500- 5,260- 7,500- 7,500- 4788 TAXABLE MERCHANDISE 1,519- 824 2,000- 1,057- 1,500- 1,500- 4789 NON TAXABLE MERCHANDISE 12,870- 15,874 13,500- 10,393- 15,000- 15,000- 4790 MISCELLANEOUS 479- 200- 500- 300- 500- 500- 4791 BOTTLED WATER SALES 1,741- 1,425- 2,000- 1,267- 1,75D- 1,750- 4770 CENTERBROOK GOLF COURSE 253,823- 249,309- 272,250- 205,325- 270,750- 270,750 - 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 92- 4900 OTHER FINANCING SOURCES 92- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 4001 REVENUES 254,693- 249,483- 272,250- 205,325- 270,750- 270,750- 6001 EXPENDITURESIEXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 48,027 49,282 49,092 36,065 49,828 49,828 6103 WAGES -PART TIME EMPLOYEES 70,087 70,893 64,000 59,269 60,000 60,000 6104 OVERTIME -PART TIME EMPLOYEES 1,678 1,349 1,200 872 1,000 1,000 6100 WAGES AND SALARIES 119,792 121,523 114,292 96,205 110,828 110,828 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 1,447 2,573 6110 OTHER PAYMENTS -NON INSURANCE 1,447 2,573 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 4,997 5,645 3,436 5,096 7,720 7,720 6125 FICA 7,279 7,386 3,044 5,658 6,838 6,838 6126 MEDICARE CONTRIBUTIONS 1,702 1,727 712 1,323 1,599 1,599 6120 RETIREMENT CONTRIBUTIONS 13,979 14,758 7,192 12,076 16,157 16,157 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 9,115 9,877 10,800 7,765 11,280 11,280 61 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 9,115 9,877 10,800 7,765 11,280 11,280 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,898 6140 UNEMPLOYMENT COMPENSATION 1,898 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 2,120 2,164 839 2,187 2,537 2,537 6150 WORKER'S COMPENSATION 2,120 2,164 839 2,187 2,537 2,537 6099 PERSONAL SERVICES 146,453 152,793 133,123 118,234 140,802 140,802 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 355 247 500 57 400 400 6200 OFFICE SUPPLIES 355 247 500 57 400 400 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 35 46 200 71 100 100 6212 MOTOR FUELS 3,058 1,824 1,500 1,913 2,000 2,000 6213 LUBRICANTS & ADDITIVES 33 328 250 55 200 200 6214 CLOTHING & PERSONAL EQUIPMENT 100 100 100 6215 SHOP MATERIALS 123 207 250 41 200 200 6216 CHEMICALS /CHEMICAL PRODUCTS 4,123 4,696 5,000 4,110 5,000 5,000 6217 SAFETY SUPPLIES 14 71 250 77 200 200 6219 GENERAL OPERATING SUPPLIES 1,283 2,741 2,000 869 1,750 1,750 6210 OPERATING SUPPLIES 8,669 9,914 9,550 7,136 9,550 9,550 6220 REPAIR & MAINT SUPPLIES 6221 MOTOR VEHICLES 553 1,823 1,750 232 500 500 6223 BUILDINGS & FACILITIES 2,799 1,026 2,500 1,391 2,000 2,000 6225 PARK & LANDSCAPE MATERIALS 6,513 3,916 5,000 2,049 3,000 3,000 6227 PAINT SUPPLIES 134 254 250 148 250 250 6220 REPAIR & MAINT SUPPLIES 9,999 7,019 9,500 3,820 5,750 5,750 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 263 328 500 45 400 400 6230 REPAIR & MAINT SUPPLIES -OTHER 263 328 500 45 400 400 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 225 161 500 135 300 300 6242 MINOR EQUIPMENT 169 575 500 319 500 500 6243 MINOR COMPUTER EQUIPMENT 925 611 6240 SMALL TOOLS & MINOR EQUIPMENT 1,319 736 1,000 1,066 800 800 6199 SUPPLIES 20,606 18,245 21,050 12,123 16,900 16,900 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 473 632 750 262 750 750 6300 PROFESSIONAL SERVICES 473 632 750 262 750 750 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 3,196 3,245 3,300 1,711 900 900 6329 OTHER COMMUNICATION SERVICES 850 850 6320 COMMUNICATIONS 3,196 3,245 3,300 1,711 1,750 1,750 62 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE. 842 750 556 750 750 6330 TRANSPORTATION 842 750 556 750 750 6340 ADVERTISING 6349 OTHER ADVERTISING 1,061 977 2,000 1,485 2,000 2,000 6340 ADVERTISING 1,061 977 2,000 1,485 2,000 2,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 852 182 1,000 142 800 Boo 6350 PRINTING AND DUPLICATING 852 182 1,000 142 800 800 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 4,109 3,377 4,300 3,967 4,250 4,250 6362 PROPERTY INSURANCE 1,621 1,557 1,950 1,863 1,990 1,990 6364 DRAM SHOP INSURANCE 17 1,849 2,320 2,628 2,810 2,810 6366 MACHINERY BREAKDOWN INSURANCE 309 262 325 297 315 315 6360 INSURANCE 6,056 7,045 8,895 8,755 9,365 9,365 6380 UTILITY SERVICES 6381 ELECTRIC 6,839 7,025 6,250 6,098 6,750 6,750 6382 GAS 1,844 1,187 2,000 676 1,500 1,500 6383 WATER 7,958 9,658 7,000 8,166 7,000 7,000 6384 REFUSE DISPOSAL 2,186 2,292 1,800 1,259 1,800 1,800 6385 SEWER 501 506 600 383 600 600 6386 STORM SEWER 966 994 900 753 1,000 1,000 6380 UTILITY SERVICES 20,293 21,664 18,550 17,335 18,650 18,650 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 276 325 500 6403 BLDGS/FACILITIES MAINT SERVICE 2,744 1,826 2,000 753 2,000 2,000 6400 REPAIR & MAINT SERVICES 3,020 2,151 2,500 753 2,000 2,000 6410 RENTALS 6415 OTHER EQUIPMENT 4,766 4,463 4,500 3,719 4,500 4,500 6410 RENTALS 4,766 4,463 4,500 3,719 4,500 4,500 6420 IS SERVICES /LICENSES/FEES 6422 SOFTWARE MAINT 302 290 203 276 299 299 6423 LOGIS CHARGES 2,525 3,036 3,512 2,836 3,661 3,661 6420 IS SERVICES/LICENSES/FEES 2,827 3,326 3,715 3,112 3,960 3,960 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 288 163 350 150 250 250 6434 DUES & SUBSCRIPTIONS 732 853 600 923 750 750 6435 CREDIT CARD FEES 2,424 2,837 2,500 2,709 2,600 2,600 6436 UNCOLLECTIBLE CHECKS/DEBTS 67 6438 CASH SHORT (OVER) 39- 994 58- 6430 MISCELLANEOUS 3,405 4,914 3,450 3,725 3,600 3,600 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 205 311 250 237 250 250 6449 OTHER CONTRACTUAL SERVICE 1,174 1,032 1,500 1,554 1,500 1,500 6440 OTHER EXPENSES 1,379 1,343 1,750 1,791 1,750 1,750 63 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 989 5 950 6462 FIXED CHARGES 6,640 6,638 6,718 5,048 6,365 6,365 6463 REPAIR & MAINT CHARGES 4,834 8,612 6,700 7,161 8,400 8,400 6465 REPLACEMENT CHARGES - 13,725 13,396 13,360 10,022 15,173 15,173 6460 CENTRAL GARAGE CHARGES 26,188 28,650 27,728 22,231 29,938 29,938 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 6,420 9,375 8,400 16,033 9,855 9,855 6470 TRANSFERS AND OTHER USES 6,420 9,375 8,400 16,033 9,855 9,855 6490 OTHER MISC COSTS /EXPENSES 6491 MERCHANDISE FOR RESALE 26,402 29,472 26,000 17,523 23,000 23,000 6494 DEPRECIATION EXPENSE 27,244 28,185 29,600 21,138 31,700 31,700 6490 OTHER MISC COSTS /EXPENSES 53,646 57,656 55,600 38,661 54,700 54,700 6299 OTHER CHARGES & SERVICES 133,581 146,466 142,888 120,271 144,368 144,368 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6520 BUILDINGS & FACILITIES 500 1,342 6501 CAPITAL OUTLAY 500 1,342 6500 CAPITAL OUTLAY 500 1,342 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 301,140 318,846 297,061 250,627 302,070 302,070 4000 REVENUES AND EXPENSES 46,447 69,363 24,811 45,302 31,320 31,320 49721 CENTERBROOK GOLF COURSE 46,447 69,363 24,811 45,302 31,320 31,320 61300 CENTERBROOK GOLF COURSE 46,447 69,363 24,811 45,302 31,320 31,320 64 AM City of Brooklyn Center Centerbrook Golf Course Cash Flows Actual Actual Budget Proposed Projected Projected Projected Projected 2008 2009 2010 2011 2012 2013 2014 2015 Revenues Course Fees $ 253,824 $ 249,310 $ 272,250 $ 270,750 $ 276,165 $ 281,688 $ 287,322 $ 293,069 Misc. Operating $ - $ 92 $ - $ - $ $ - $ - $ Misc. Non - operating $ 870 $ 81 $ - $ - $ - $ - $ - $ ' Total Revenues $ 254,694 $ 249,483 $ 272,250 $ 270,750 $ 276,165 $ 281,688 $ 287,322 $ 293,069 Expenditures Personal Services $ 146,453 $ 152,793 $ 133,123 $ 140,802 $ 143,618 $ 146,490 $ 149,420 $ 152,409 Supplies $ 20,606 $ 18,245 $ 21,050 $ 16,900 $ 17,238 $ 17,583 $ 17,934 $ 18,293 Services $ 106,337 $ 119,724 $ 113,288 $ 112,668 $ 114,358 $ 116,073 $ 117,814 $ 119,582 Depreciation $ 27,244 $ 28,185 $ 29,600 $ 31,700 $ 29,600 $ 29,600 $ 29,600 $ 29,600 Debt Transfer $ - $ - $ - $ - $ $ - $ - $ Total Expenditures $ 300,640 $ 318,947 $ 297,061 $ 302,070 $ 304,814 $ 309,747 $ 314,769 $ 319,883 Capital Outlay $ 25,879 $ - $ - $ - $ - $ - $ $ Total Cash Requirement $ 326,519 $ 318,947 $ 297,061 $ 302,070 $ 304,814 $ 309,747 $ 314,769 $ 319,883 Beginning Cash Balance $ 50,970 $ 8,645 $ (33,422) $ (28,633) $ (28,253) $ (27,302) $ (25,760) $ (23,607) Changes in Assets /Liabilities $ 2,256 $ (788) $ - $ - $ - $ - $ $ - Revenues $ 254,694 $ 249,483 $ 272,250 $ 270,750 $ 276,165 $ 281,688 $ 287,322 $ 293,069 Expenditures $ (326,519) $ (318,947) $ (297,061) $ (302,070) $ (304,814) $ (309,747) $ (314,769) $ (319,883) Depreciation Add -Back $ 27,244 $ 28,185 $ 29,600 $ 31,700 $ 29,600 $ 29,600 $ 29,600 $ 29,600 Ending Cash Balance $ 8,645 $ (33,422) $ (28,633) $ (28,253) $ (27,302) $ (25, $ (23,607) $ (20,822) Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. This page has been left blank intentionally. 66 City of (Brooklyn Center 2011 (Budget FUND: Earle Brown Heritage Center — 61700 — 4 851 49852 49853, 49854 Summa 9 DEPT/ACTIVITY/PROJECT: Summary i 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. 67 This page has been left blank intentionally. 68 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 29,685- 10,695- 9,000- 2,219- 3,250- 3,250- 4604 CHECK PROCESSING FEES 30- 4605 UNREALIZED INVESTMENT GAIN /LOS 1,757- 266- 4606 OTHER REVENUE 1,054- 372- 286- 4609 UNCOLLECTIBLE WRITE OFFS 11,552 4600 MISCELLANEOUS REVENUE 32,497- 11,362- 9,000- 9,047 3,250- 3,250- 4599 MISCELLANEOUS REVENUE 32,497- 11,362- 9,000- 9,047 3,250- 3,250- 4800 EBHC 4810 INN ON THE FARM 4811 GUEST ROOM RENTALS 8,470- 4812 FACILITY RENTALS 175- 4814 EQUIPMENT RENTALS 30- 4810 INN ON THE FARM 8,675- 4820 CONVENTION CENTER 4821 ROOM RENTALS 626,884- 623,785= 650,000- 435,288- 675,000- 675,000- 4821.1 CMP ROOM RENTALS 52,492- 25,000- 25,000- 25,000- 4821 ROOM RENTALS 679,376- 623,785- 675,000- 435,288- 700,000- 700,000- 4822 LABOR CHARGES 12,673- 10,740- 10,500- 8,193- 10,800- 10,800- 4823 EQUIPMENT RENTALS 288,431- 248,709- 260,000- 223,935- 290,000- 290,000- 4823.1 CMP EQUIPMENT RENTALS 25,435- 10,000- 1,000- 1,000- 4823 EQUIPMENT RENTALS 313,866- 248,709- 270,000- 223,935- 291,000- 291,000- 4826 DANCE FLOOR RENTALS 8,360- 4827 SECURITY SERVICES 23,725- 23,975- 21,000- 14,975- 21,000- 21,000- 4828 CLIENT SERVICES 33,406- 37,834- 37,000- 29,772- 43,200- 43,200- 4829 MISCELLANEOUS 2,606- 2,535- 2, 800- 2, 340- 3,0 00- 3, 000- , 4820 CONVENTION CENTER 1,074,012- 947,578- 1,016,300- 714,503- 1,069,000- 1,069,000- 4830 OFFICE RENTAL 4831 OFFICE RENTALS 57,183- 25,680- 25,680- _ 95,240- 25,680- 25,680- 4830 OFFICE RENTAL 57,183- 25,680- 25,680- 95,240- 25,680- 25,680- 4840 CATERING SERVICES 4842 SERVICE CHARGES 400,949- 384,036- 398,000- 301,801- 410,000- 410,000- 4844 FOOD & BEVERAGE SALES 1,977,759- 1,859,779- 1,921,552- 1,425,454- 2,134,999- 2,134,999- 4844.1 FOOD & BEVERAGE SALES, INN 166- 4845 LIQUORMWNE /BEER SALES 269,242- 284,928- 273,000- 208,670- 295,000- 295,000- 4848 MISCELLANEOUS SALES 43,146- 40,075- 53,250- 33,181- 41,001- 41,001- 4849 MISCELLANEOUS SALES -NON TAXABL 840- 4840 CATERING SERVICES 2,692,103- 2,568,819- 2,645,802 - 1,969,105- 2,881,000- 2,881,000- 4800 EBHC 3,831,972- 3,542,077- 3,687,782- 2,778,848- 3,975,680- 3,975,680- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 326,415- 113,516- 4921 REFUNDS & REIMBURSEMENTS 1,882- 244- 4900 OTHER FINANCING SOURCES 328,297- 113,760 - 69 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5586 COST OF SALES -MISC 35 5580 COST OF GOODS SOLD 35 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES -LABOR 1,184,215 1,168,497 1,151,891 887,225 1,342,477 1,342,477 5592 COST OF SALES -FOOD 456,066 415,028 440,650 353,182 495,210 495,210 5593 COST OF SALES - SUPPLIES 132,364 130,740 128,662 101,320 123,104 123,104 5594 COST OF SALES -MGMT FEES 102,600 102,600 105,600 78,623 108,600 108,600 5590 EBHC CONTRACT EXPENSES 1,875,245 1,816,865 1,826,803 1,420,349 2,069,391 2,069,391 5550 DIRECT COST OF SALES 1,875,280 1,816,865 1,826,803 1,420,349 2,069,391 2,069,391 4001 REVENUES 2,317,486- 1,850,334- 1,869,979- 1,349,452- 1,909,539- 1,909,539- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES - 506,729 526,619 541,406 343,444 525,043 525,043 6102 OVERTIME -FT EMPLOYEES 1,556 713 807 6103 WAGES -PART TIME EMPLOYEES 177,404 169,099 172,800 124,395 188,449 188,449 6104 OVERTIME -PART TIME EMPLOYEES 39 213 6100 WAGES AND SALARIES 685,689 696,469 714,206 468,859 713,492 713,492 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 4,755 9,771 6110 OTHER PAYMENTS -NON INSURANCE 4,755 9,771 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 41,550 44,726 49,998 31,028 49,944 49,944 6125 FICA 43,718 44,047 44,281 29,757 44,238 44,238 6126 MEDICARE CONTRIBUTIONS 10,224 10,301 10,357 6,960 10,346 10,346 6120 RETIREMENT CONTRIBUTIONS 95,492 99,074 104,636 67,744 104,528 104,528 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 85,704 97,678 118,800 69,769 124,080 124,080 6130 INSURANCE BENEFITS 85,704 97,678 118,800 69,769 124,080 124,080 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 302 1,232 463 6140 UNEMPLOYMENT COMPENSATION 302 1,232 463 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 22,119 22,625 22,608 17,160 24,446 24,446 6150 WORKER'S COMPENSATION 22,119 22,625 22,608 17,160 24,446 24,446 6099 PERSONAL SERVICES 894,062 926,848 960,250 623,995 966,546 966,546 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,388 1,780 3,408 2,921 3,604 3,604 6202 COPYING SUPPLIES 1,955 1,569 2,496 849 1,550 1,550 6203 BOOKS /REFERENCE MATERIALS 31 38 100 100 6200 OFFICE SUPPLIES 3,374 3,349 5,904 3,809 5,254 5,254 70 - SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 5,193 3,989 6,456 3,831 5,592 5,592 6212 MOTOR FUELS 15 40 33 100 100 6214 CLOTHING & PERSONAL EQUIPMENT 856 540 1,000 576 1,000 1,000 6215 SHOP MATERIALS 206 569 552 104 548 548 6216 CHEMICALS /CHEMICAL PRODUCTS 3,566 4,445 7,000 4,580 6,600 6,600 6217 SAFETY SUPPLIES 1,104 856 1,344 731 1,344 1,344 6219 GENERAL OPERATING SUPPLIES 25,686 25,471 30,896 19,837 30,596 30,596 6210 OPERATING SUPPLIES 36,626 35,890 47,288 29,692 45,780 45,780 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 20,374 15,988 29,448 15,053 27,448 27,448 6225 PARK & LANDSCAPE MATERIALS 1,559 2,418 4,200 2,693 4,700 4,700 6226 SIGNS & STRIPING MATERIALS 151 835 900 600 600 6227 PAINT SUPPLIES 2,302 2,546 2,446 1,344 2,746 2,746 6220 REPAIR & MAINT SUPPLIES 24,386 21,788 36,994 19,090 35,494 35,494 6230 REPAIR & MAINT SUPPLIES -OTHER 6237 LAUNDRY SUPPLIES 28 50 50 50 6239 OTHER REPAIR & MAINT SUPPLIES 5,250 4,093 7,296 4,559 7,296 7,296 6230 REPAIR & MAINT SUPPLIES -OTHER 5,278 4,093 7,346 4,559 7,346 7,346 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 963 799 1,056 829 1,226 1,226 6242 MINOR EQUIPMENT 44,872 38,412 60,534 16,256 60,534 60,534 6243 MINOR COMPUTER EQUIPMENT 8,407 4,745 6,000 5,717 2,600 2,600 6240 SMALL TOOLS & MINOR EQUIPMENT 54,242 43,956 67,590 22,801 64,360 64,360 6199 SUPPLIES 123,906 109,075 165,122 79,951 158,234 158,234 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 3,238 3,057 3,150 2, 3,000 3,000 141 6303 LEGAL SERVICES 308 506 500 141 500 800 6307 PROFESSIONAL SERVICES 10,251 16,723 41,520 26,722 41,150 41,150 6300 PROFESSIONAL SERVICES 13,797 20,285 45,170 29,828 44,650 44,650 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 8,339 8,303 6,950 5,623 6,750 6,750 6322 POSTAGE 2,450 1,4 14 3,0 00 1, 062 3,40 3,400 6320 COMMUNICATIONS 10,790 9,718 11,950 6,685 10,150 10,150 6330 TRANSPORTATION 6331 TRAVEL EXPENSE /MILEAGE 1,196 1,138 1,200 447 1,200 1,200 6333 FREIGHT /DRAYAGE 333 276 444 137 444 444 6330 TRANSPORTATION 1,529 1,414 1,644 584 1,644 1,644 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 3,332 1,060 2,304 676 2,304 2,304 6349 OTHER ADVERTISING 75,413 88,053 74,600 56,392 83,125 83,125 6340 ADVERTISING 78,745 89,113 76,904 57,069 85,429 85,429 6350 PRINTING AND DUPLICATING 6351 PRINTING 8,594 7,191 10,980 4,117 12,980 12,980 6350 PRINTING AND DUPLICATING 8,594 7,191 10,980 4,117 12,980 12,980 71 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 18,101 15,352 18,435 10,638 15,309 15,309 6362 PROPERTY INSURANCE 31,231 30,662 35,115 26,594 38,179 38,179 6366 MACHINERY BREAKDOWN INSURANCE 2,256 1,936 2,280 1,529 2,184 2,184 6360 INSURANCE 51,588 47,949 55,830 38,761 55,672 55,672 6380 UTILITY SERVICES 6381 ELECTRIC 126,141 110,985 144,366 91,073 120,370 120,370 6382 GAS 78,525 39,771 88,478 38,153 82,370 82,370 6383 WATER 1 1,801 1,956 1,646 2,060 2,060 6384 REFUSE DISPOSAL 9,733 9,290 10,496 6,178 10,096 10,096 6385 SEWER 2,080 2,525 2,552 3,101 4,084 4,084 6386 STORM SEWER 2,758 2,168 2,904 2,307 3,100 3,100 6389 STREET LIGHTS 491 380 552 412 552 552 6380 UTILITY SERVICES 221,067 166,919 251,304 142,870 222,632 222,632 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 69,556 36,744 56,700 32,310 56,700 56,700 6403 BLDGS /FACILITIES MAINT SERVICE 5,362 3,741 7,500 3,400 7,500 7,500 6408 COMMUNICATION /INFO SYSTEMS 536 6409 OTHER REPAIR & MAINT SVCS 1,315 1,199 1,704 1,090 1,704 1,704 6400 REPAIR & MAINT SERVICES 76,770 41,684 65,904 36,801 65,904 65,904 6410 RENTALS 6413 OFFICE EQUIPMENT 5,540 6,067 5,300 4,271 5,700 5,700 6415 OTHER EQUIPMENT 149,890 103,60 1 05,996 82, 488 108,296 108,29 6410 RENTALS 155,430 109,667 111,296 86,760 113,996 113,996 6420 IS SERVICES /LICENSES /FEES 6421 SOFTWARE LICENSE 149 6422 SOFTWARE MAINT 2,649 2,593 3,676 4,575 5,500 5,500 6423 LOGIS CHARGES 13,362 15,498 19,989 14,229 19,816 19,816 6428 PROTECTION SERVICES 16,148 13, 890 15, 000 1 1,536 15, 1 5,000 6420 IS SERVICES /LICENSES /FEES 32,309 31,982 38,665 30,340 40,316 40,316 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 6,222 7,440 8,400 232 8,400 8,400 6433 MEETING EXPENSES 924 1,967 722 779 882 882 6434 DUES & SUBSCRIPTIONS 3,486 3,681 4,170 2,610 4,170 4,170 6435 CREDIT CARD FEES 16,250 15,186 16,380 13,096 13,526 13,526 6436 UNCOLLECTIBLE CHECKS /DEBTS 1,538 13,455 6438 CASH SHORT (OVER) 54- 103- 32 - 6430 MISCELLANEOUS 28,366 41,626 29,672 16,685 26,978 26,978 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 20,747 22,137 11,300 4,121 6442 COURT AWARDS /SETTLEMENTS 1,052 6449 OTHER CONTRACTUAL SERVICE 31,115 33,152 32,382 24,068 36,103 36,103 6440 OTHER EXPENSES 51,862 56,341 43,682 28,189 36,103 36,103 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 67,994 68,001 74,256 55,692 74,656 74,656 6476 CAPITAL PROJECT FUND TRANSFER 235,000 300,000 200,000 200,000 200,000 6470 TRANSFERS AND OTHER USES 302,994 368,001 274,256 55,692 274,656 274,656 72 SUMMARY CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 579,118 624,329 651,625 471,650 712,919 712,919 6490 OTHER MISC COSTS /EXPENSES 579,118 624,329 651,625 471,650 712,919 712,919 6299 OTHER CHARGES & SERVICES 1,612,957 1,616,217 1,668,882 1,006,032 1,704,029 1,704,029 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 2,630,925 2,652,141 2,794,254 1,709,978 2,828,809 2,828,808 4000 REVENUES AND EXPENSES 313,439 801,807 924,275 360,527 919,270 919,270 61700 EARLE BROWN HERITAGE CENTER 313,439 801,807 924,275 360,527 919,270 919,270 73 This page has been left blank intentionally. 74 City of Brook& Center 2011 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 6423 Logis Charges $21,199 Includes increases in charges for system support. PERSONNEL LEVELS 1 -EBHC Manager 1- Secretary /Receptionist 1- Secretary /Billing Clerk CAPITAL OUTLAY See Capital Projects Fund 75 This page has been left blank intentionally. 76 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 29,685- 10,695- 9,000- 2,219- 3,250- 3,250- 4605 UNREALIZED INVESTMENT GAIN /LOS 1,757- 266- 4606 OTHER REVENUE 285- 4600 MISCELLANEOUS REVENUE 31,443- 11,246- 9,000- 2,219- 3,250- 3,250- 4599 MISCELLANEOUS REVENUE 31,443- 11,246- 9,000- 2,219- 3,250- 3,250- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 153- 244 4900 OTHER FINANCING SOURCES 153- 244- 4001 REVENUES 31,595- 11,490- 9,000- 2,219- 3,250- 3,250- 6001 EXPENDITUREWEXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 150,555 160,853 162,960 77,024 155,655 155,655 6102 OVERTIME -FT EMPLOYEES 155 6100 WAGES AND SALARIES 150,555 160,853 162,960 77,178 155,655 155,655 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 1,242 2,335 6110 OTHER PAYMENTS -NON INSURANCE 1,242 2,335 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 9,780 10,855 11,407 5,401 10,896 10,896 6125 FICA 9,462 10,119 10,104 4,772 9,651 9,651 6126 MEDICARE CONTRIBUTIONS 2,213 2,367 2,363 1,116 2,257 2,257 6120 RETIREMENT CONTRIBUTIONS 21,455 23,341 23,874 11,288 22,804 22,804 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 25,466 29,649 32,400 19,134 33,840 33,840 6130 INSURANCE BENEFITS 25,466 29,649 32,400 19,134 33,840 33,840 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 1,290 1,316 1,272 1,424 1,463 1,463 6150 WORKER'S COMPENSATION 1,290 1,316 1,272 1,424 1,463 1,463 6099 PERSONAL SERVICES 200,008 217,493 220,506 109,024 213,762 213,762 6199 SUPPLIES 620D OFFICE SUPPLIES 6201 OFFICE SUPPLIES 76 336 6200 OFFICE SUPPLIES 76 336 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 35 6210 OPERATING SUPPLIES 35 6220 REPAIR & MAINT SUPPLIES 77 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 839 6243 MINOR COMPUTER EQUIPMENT 917 1,500 1,412 900 900 6240 SMALL TOOLS & MINOR EQUIPMENT 1,755 1,500 1,412 900 900 6199 SUPPLIES 1,867 1,500 1,748 900 900 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 3,238 3,057 3,150 2,965 3,000 3,000 6303 LEGAL SERVICES 308 339 500 141 500 500 6307 PROFESSIONAL SERVICES 2,200 3,254 2,500 7,508 2,500 2,500 6300 PROFESSIONAL SERVICES 5,746 6,649 6,150 10,614 6,000 6,000 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,200 1,275 768 900 900 6320 COMMUNICATIONS 1,200 1,275 768 900 900 6330 TRANSPORTATION 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 1,168 6340 ADVERTISING 1,168 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 4,138 3,226 3,820 2,471 3,264 3,264 6362 PROPERTY INSURANCE 7,596 7,593 8,665 6,649 9,545 9,545 6366 MACHINERY BREAKDOWN INSURANCE 546 481 560 382 545 545 6360 INSURANCE 12,281 11,300 13,045 9,502 13,354 13,354 6400 REPAIR & MAINT SERVICES 6408 COMMUNICATION/INFO SYSTEMS 536 6400 REPAIR & MAINT SERVICES 536 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 100 6422 SOFTWARE MAINT 2,649 2,593 3,676 4,575 5,500 5,500 6423 LOGIS CHARGES 13,362 15,498 19,989 14,229 19,816 19,816 6420 IS SERVICES /LICENSES/FEES 16,111 18,092 23,665 18,804 25,316 25,316 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,720 1,684 2,400 2,400 2,400 6430 MISCELLANEOUS 1,720 1,684 2,400 2,400 2,400 C-440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 140 6440 OTHER EXPENSES 140 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 67,994 68,001 74,256 55,692 74,656 74,656 PIT TRANSFER 235 000 300 6476 CAPITAL PROJECT FUND TRA S , 000 200,000 200,000 200,000 6470 TRANSFERS AND OTHER USES 302,994 368,001 274,256 55,692 274,656 274,656 78 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 30,892 25,633 30,275 19,224 29,412 29,412 6490 OTHER MISC COSTS/EXPENSES 30,892 25,633 30,275 19,224 29,412 29,412 6299 OTHER CHARGES & SERVICES 371,448 432,698 351,066 114,605 352,038 352,038 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 571,456 652,058 573,072 225,377 566,700 566,700 4000 REVENUES AND EXPENSES 539,861 640,568 564,072 223,159 563,450 563,450 49851 EBHC - ADMINISTRATION 539,861 640,568 564,072 223,159 563,450 563,450 79 This page has been left blank intentionally. 80 City of Orookfyn Center 2011 (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 2011 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 Visit Mim North Convention and Visitor's Bureau to attract new business. • Actively work with the Embassy Suites for future business development that is complimentary and lucrative to both facilities EXPENDITURE DETAILS 6349 Other Advertising $40,101 Funds for advertising and marketing campaign. 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 81 This page has been left blank intentionally. 82 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 1,054 86- 286 - 4609 UNCOLLECTIBLE WRITE OFFS 4,586 4600 MISCELLANEOUS REVENUE 1,054 116- 4,300 4599 MISCELLANEOUS REVENUE 1,054 116- 4,300 4800 EBHC 4820 CONVENTION CENTER 4821 ROOM RENTALS 626,884 623,785- 650,000- 435,288- 675,000- 675,000 - 4821.1 CMP ROOM RENTALS 52,492- 25,000- 25,000- 25,000- 4821 ROOM RENTALS 679,376- 623,785- 675,000- 435,288- 700,000- 700,000- 4822 LABOR CHARGES 12,673- 10,740- 10,500- 8,193- 10,800- 10,800 - 4823 EQUIPMENT RENTALS 288,431- 248,709- 260,000 - 223,935- 290,000- 290,000- 4823.1 CMP EQUIPMENT RENTALS 25,435 10,000- 1,000- 1,000- 4623 EQUIPMENT RENTALS 313,866- 248,709- 270,000- 223,935- 291,000- 291,000- 4826 DANCE FLOOR RENTALS 8,360 4827 SECURITY SERVICES 23,725- 23,975- 21,000- 14,975- 21,000 21,000 4828 CLIENT SERVICES 33,406- 37,834 37,000- 29,772- 43,200- 43,200- 4829 MISCELLANEOUS 2,606- 2,535 2,800 2,340 3,000 3,000 4820 CONVENTION CENTER 1,074,012- 947,578- 1,016,300- 714,503- 1,069,000- 1,069,000- ' 4800 EBHC 1,074,012- 947,578- 1,016,300- 714,503- 1,069,000- 1,069,000- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 234,244 113,516 - 4921 REFUNDS & REIMBURSEMENTS 250- 4900 OTHER FINANCING SOURCES 234,494 113,516- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 4001 REVENUES 1,309,560- 1,061,210- 1,016,300- 710,203- 1,069,000- 1,069,000- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 324,540 343,987 378,446 248,111 368,388 368,388 6102 OVERTIME -FT EMPLOYEES 1,355 667 513 6103 WAGES -PART TIME EMPLOYEES 122,789 126,929 127,000 89,714 134,000 134,000 6104 OVERTIME -PART TIME EMPLOYEES 39 156 6100 WAGES AND SALARIES 448,684 471,622 505,446 338,495 502,388 502,368 6110 OTHER PAYMENTS -NON INSURANCE 6111 SEVERANCE PAY 3,513 7,436 6110 OTHER PAYMENTS -NON INSURANCE 3,513 7,436 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 27,321 30,493 35,381 22,704 35,167 35,167 83 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6125 FICA 28,905 29,979 31,338 21,683 31,149 31,149 6126 MEDICARE CONTRIBUTIONS 6,761 7,012 7,330 5,072 7,285 7,285 6120 RETIREMENT CONTRIBUTIONS 62,988 67,484 74,049 49,459 73,601 73,601 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 60,237 68,029 86,400 50,635 90,240 90,240 6130 INSURANCE BENEFITS 60,237 68,029 86,400 50,635 90,240 90,240 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 302 1,232 463 6140 UNEMPLOYMENT COMPENSATION 302 1,232 463 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 16,693 18,018 18,729 12,920 19,994 19,994 6150 WORKER'S COMPENSATION 16,693 18,018 18,729 12,920 19,994 19,994 6099 PERSONAL SERVICES 592,418 633,822 684,624 451,972 686,223 686,223 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 638 1,419 2,004 1,585 2,300 2,300 6202 COPYING SUPPLIES 1,275 938 1,596 425 950 950 6203 BOOKS /REFERENCE MATERIALS 31 38 100 100 6200 OFFICE SUPPLIES 1,944 2,358 3,600 2,048 3,350 3,350 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 5,189 3,989 6,300 3,551 5,300 5,300 6212 MOTOR FUELS 15 40 33 100 100 6214 CLOTHING & PERSONAL EQUIPMENT B56 540 1,000 565 1,000 1,000 6215 SHOP MATERIALS 206 589 504 104 500 500 6216 CHEMICALS /CHEMICAL PRODUCTS 3,566 4,445 6,700 4,580 6,300 6,300 6217 SAFETY SUPPLIES 521 494 696 472 696 696 6219 GENERAL OPERATING SUPPLIES 23,730 23,805 29,796 19,680 29,796 29,796 6210 OPERATING SUPPLIES 34,083 33,861 45,036 28,985 43,692 43,692 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES' 15,648 14,397 26,448 11,878 24,448 24,448 6225 PARK & LANDSCAPE MATERIALS 1,559 2,418 3,900 2,693 4,400 4,400 6226 SIGNS & STRIPING MATERIALS 607 600 300 300 6227 PAINT SUPPLIES 2,116 2,506 2,200 1,344 2,500 2,500 6220 REPAIR & MAINT SUPPLIES 19,322 19,929 33,148 15,915 31,648 31,648 6230 REPAIR & MAINT SUPPLIES -OTHER 6237 LAUNDRY SUPPLIES 50 50 50 6239 OTHER REPAIR & MAINT SUPPLIES 4,361 3,590 5,196 4,435 5,196 5,196 6230 REPAIR & MAINT SUPPLIES -OTHER 4,361 3,590 5,246 4,435 5,246 5,246 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 963 799 1,056 829 1,226 1,226 6242 MINOR EQUIPMENT 29,181 20,561 41,534 4,121 41,534 41,534 6243 MINOR COMPUTER EQUIPMENT 4,637 2,342 1,500 1,482 6240 SMALL TOOLS & MINOR EQUIPMENT 34,761 23,701 44,090 6,431 42,760 42,760 6199 SUPPLIES 94,491 83,439 131,120 57,815 126,696 126,696 6299 OTHER CHARGES & SERVICES 84 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6300 PROFESSIONAL SERVICES 6303 LEGAL SERVICES 167 6307 PROFESSIONAL SERVICES 8,051 13,469 39,020 19,214 38,650 38,650 6300 PROFESSIONAL SERVICES 8,051 13,636 39,020 19,214 38,650 38,650 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 6,026 5,840 6,350 3,952 4,914 4,914 6322 POSTAGE 2,152 1,080 3,000 740 3,000 3,000 6320 COMMUNICATIONS 8,178 6,919 9,350 4,692 7,914 7,914 633D TRANSPORTATION 6331 TRAVEL EXPENSEIMILEAGE 1,196 1,138 1,200 447 1,200 1,200 6333 FREIGHT /DRAYAGE 258 254 348 137 348 348 6330 TRANSPORTATION 1,454 1,392 1,548 584 1,548 1,548 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 2,164 1,060 2,304 676 2,304 2,304 6349 OTHER ADVERTISING 37,463 55,837 38,600 24,588 40,101 40,101 6340 ADVERTISING 39,627 56,897 40,9D4 25,264 42,405 42,405 6350 PRINTING AND DUPLICATING 6351 PRINTING 4,605 4,122 6,5DO 2,263 7,500 7,500 6350 PRINTING AND DUPLICATING 4,605 4,122 6,500 2,263 7,500 7,500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 6,107 6,221 7,54D 3,997 6,119 6,119 6362 PROPERTY INSURANCE 9,040 9,315 10,585 8,244 11,835 11,835 6366 MACHINERY BREAKDOWN INSURANCE 652 588 685 474 677 6 6360 INSURANCE 15,798 16,124 18,810 12,715 18,631 18,631 6380 UTILITY SERVICES 6381 ELECTRIC 101,128 90,125 114,996 74,274 95,000 95,000 6382 GAS 32,510 17,396 40,000 16,946 33,892 33,892 6383 WATER 561 863 1,200 718 1,200 1,200 6384 REFUSE DISPOSAL 1,803 1,681 2,000 1,426 2,100 2,100 6385 SEWER 984 1,271 2,000 1,397 2,000 2,000 6386 STORM SEWER 1,479 1,142 1,800 1,153 1,800 1,800 6389 STREET LIGHTS 261 200 300 206 300 300 6380 UTILITY SERVICES 138,725 112,678 162,296 96,120 136,292 136,292 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 41,303 15,313 35,700 25,526 35,700 35,700 6403 BLDGS /FACILITIES MAINT SERVICE 2,329 2,063 3,000 1,527 3,000 3,000 6409 OTHER REPAIR & MAINT SVCS 116 300 109 300 300 6400 REPAIR & MAINT SERVICES 43,747 17,376 39,000 27,162 39,000 39,000 641D RENTALS 6413 OFFICE EQUIPMENT 3,375 3,839 3,500 2,547 3,500 3,500 6415 OTHER EQUIPMENT 149,347 103,600 105,ODO 80,888 107,300 107,300 6410 RENTALS 152,721 107,439 108,500 83,436 110,800 110,800 642D IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 50 6428 PROTECTION SERVICES 15,207 13,890 15,ODO 11,536 15,000 15,ODO 6420 IS SERVICES/LICENSES/FEES 15,256 13,890 15,000 11,536 15,000 15,000 85 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 3,942 4,292 4,500 232 4,500 4,500 6433 MEETING EXPENSES 924 1,967 722 779 882 882 6434 DUES & SUBSCRIPTIONS 3,486 3,646 4,100 2,610 4,100 4,100 6435 CREDIT CARD FEES 2,741 1,950 2,604 1,529 1,750 1,750 6436 UNCOLLECTIBLE CHECKS /DEBTS 716 2,875 6438 CASH SHORT (OVER) 1- 6 1- 6430 MISCELLANEOUS 11,809 14,736 11,926 5,150 11,232 11,232 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 195 186 200 6442 COURT AWARDS /SETTLEMENTS 1,052 6449 OTHER CONTRACTUAL SERVICE 16,695 19,788 18,600 12,293 18,600 18,600 6440 OTHER EXPENSES 16,890 21,025 18,600 12,493 18,600 18,600 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 264,827 296,044 310,850 225,436 338,154 338,154 6490 OTHER MISC COSTS /EXPENSES 264,827 296,044 310,850 225,436 338,154 338,154 6299 OTHER CHARGES & SERVICES 721,690 682,278 782,304 526,064 785,726 785,726 6500 CAPITAL OUTLAY 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 1,408,599 1,399,539 1,598,048 1,035,851 1,598,645 1,598,645 4000 REVENUES AND EXPENSES 99,039 338,329 581,748 325,648 529,645 529,645 49852 EBHC- CONVENTION CENTER 99,039 338,329 581,748 325,648 529,645 529,645 86 City of Brooklyn Center 2011 Budget 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 $108,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 $19,000 Purchase of china, glass, and silver. 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 87 This page has been left blank intentionally. 88 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 400,949- 384,036- 398,000- 301,801- 410,000- 410,000- 4844 FOOD & BEVERAGE SALES 1,977,759- 1,859,779- 1,921,552- 1,425,454- 2,134,999- 2,134,999- 4844.1 FOOD & BEVERAGE SALES, INN 166- 4845 LIQUORMANE/BEER SALES 269,242- 284,928- 273,000- 208,670- 295,000- 295,000- 4848 MISCELLANEOUS SALES 43,146- 40,075- 53,250- 33,181- 41,001- 41,001- 4849 MISCELLANEOUS SALES -NON TAXABL 840- 4840 CATERING SERVICES 2,692,103- 2,568,819- 2,645,802- 1,969,105- 2,881,000- 2,881,000- 4800 EBHC 2,692,103- 2,568,819- 2,645,802- 1,969,105- 2,881,000- 2,881,000- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 18,930 - 4900 OTHER FINANCING SOURCES 18,930- 5550 DIRECT COST OF SALES 5586 COST OF SALES -MISC 35 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES -LABOR 1,184,215 1,168,497 1,151,891 887,225 1,342,477 1,342,477 5592 COST OF SALES -FOOD 456,066 415,028 440,650 353,182 495,210 495,210 5593 COST OF SALES- SUPPLIES 132,364 130,740 128,662 101,320 123,104 123,104 5594 COST OF SALES -MGMT FEES 102,600 102,600 105,600 78,623 108,600 108,600 5590 EBHC CONTRACT EXPENSES 1,875,245 1,816,865 1,826,803 1,420,349 2,069,391 2,069,391 5550 DIRECT COST OF SALES 1,875,280 1,816,865 1,826,803 1,420,349 2,069,391 2,069,391 4001 REVENUES 835,753- 751,954 818,999 - 541,790- 811,609- 811,609- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 18,430 20,368 17,900 6102 OVERTIME -FT EMPLOYEES 46 139 6103 WAGES -PART TIME EMPLOYEES 40,217 39,348 42,000 32,807 50,649 50,649 6104 OVERTIME-PART TIME EMPLOYEES 57 6100 WAGES AND SALARIES 58,647 59,761 42,000 50,903 50,649 50,649 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 2,671 3,093 2,940 2,762 3,545 3,545 6125 FICA 3,629 3,686 2,604 3,160 3,140 3,140 6126 MEDICARE CONTRIBUTIONS 848 862 609 739 734 734 6120 RETIREMENT CONTRIBUTIONS 7,148 7,640 6,153 6,661 7,419 7,419 6130 INSURANCE BENEFITS 6150 WORKER'S COMPENSATION 89 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6151 WORKER'S COMP INSURANCE 2,863 3,066 2,412 2,693 2,730 2,730 6150 WORKER'S COMPENSATION 2,863 3,066 2,412 2,693 2,730 2,730 6099 PERSONAL SERVICES 68,659 70,467 50,565 60,257 60,798 60,798 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 750 285 1,404 1,001 1,304 1,304 6202 COPYING SUPPLIES 680 631 900 425 600 600 6200 OFFICE SUPPLIES 1,430 915 2,304 1,425 1,904 1,904 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 156 280 292 292 6214 CLOTHING & PERSONAL EQUIPMENT 11 6215 SHOP MATERIALS 48 48 48 6216 CHEMICALS /CHEMICAL PRODUCTS 300 300 300 6217 SAFETY SUPPLIES 583 363 648 259 648 648 6219 GENERAL OPERATING SUPPLIES 1,190 1,631 1,100 157 800 800 6210 OPERATING SUPPLIES 1,773 1,993 2,252 707 2,088 2,088 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 686 1,027 2,004 3,003 2,004 2,004 6227 PAINT SUPPLIES 40 96 96 96 6220 REPAIR & MAINT SUPPLIES 686 1,068 2,100 3,003 2,100 2,100 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 825 503 2,100 123 2,100 2,100 6230 REPAIR & MAINT SUPPLIES -OTHER 825 503 2,100 123 2,100 2,100 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 14,919 17,012 19,000 12,135 19,000 19,000 6243 MINOR COMPUTER EQUIPMENT 3,770 1,487 3,000 2,823 1,700 1,700 6240 SMALL TOOLS & MINOR EQUIPMENT 18,689 18,499 22,000 14,958 20,700 20,700 6199 SUPPLIES 23,403 22,978 30,756 20,217 28,892 28,892 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,214 1,264 1,325 903 936 936 6322 POSTAGE 299 334 322 400 400 6320 COMMUNICATIONS 1,512 1,598 1,325 1,225 1,336 1,336 6330 TRANSPORTATION 6333 FREIGHT/DRAYAGE 75 22 96 96 96 6330 TRANSPORTATION 75 22 96 96 96 6340 ADVERTISING 6349 OTHER ADVERTISING 37,951 31,970 36,000 31,804 43,024 43,024 6340 ADVERTISING 37,951 31,970 36,000 31,804 43,024 43,024 6350 PRINTING AND DUPLICATING 6351 PRINTING 3,989 3,068 4,480 1,854 5,480 5,480 6350 PRINTING AND DUPLICATING 3,989 3,068 4,480 1,854 5,480 5,480 90 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 6,379 5,186 6,140 3,749 5,318 5,318 6362 PROPERTY INSURANCE 11,571 12,160 13,880 10,638 15,272 15,272 6366 MACHINERY BREAKDOWN INSURANCE 839 770 900 612 875 B75 6360 INSURANCE 18,789 18,115 20,920 14,998 21,465 21,465 6380 UTILITY SERVICES 6381 ELECTRIC 17,846 16,521 24,996 13,597 20,996 20,996 6382 GAS 32,510 17,034 40,000 16,639 40,000 40,000 6383 WATER 445 695 552 707 600 600 6384 REFUSE DISPOSAL 6,705 6,777 7,500 4,291 7,000 7,000 6385 SEWER 634 983 348 1,386 1,684 1,684 6386 STORM SEWER 1,279 1,026 1,104 1,153 1,300 1,300 6389 STREET LIGHTS 231 180 252 206 252 252 6380 UTILITY SERVICES 59,650 43,216 74,752 37,979 71,832 71,832 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 19,489 18,098 19,500 5,834 19,500 19,500 6403 BLDGS/FACILITIES MAINT SERVICE 2,754 1,678 3,996 1,753 3,996 3,996 6409 OTHER REPAIR & MAINT SVCS 1,199 1,199 1,404 981 1,404 1,404 6400 REPAIR & MAINT SERVICES 23,442 20,974 24,900 8,569 24,900 24,900 6410 RENTALS 6413 OFFICE EQUIPMENT 2,166 2,228 1,800 1,724 2,200 2,200 6415 OTHER EQUIPMENT 543 996 1,600 996 996 6410 RENTALS 2,709 2,228 2,796 3,324 3,196 3,196 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 559 1,464 1,500 1,500 1,500 6434 DUES & SUBSCRIPTIONS 35 70 70 70 6435 CREDIT CARD FEES 13,423 13,236 13,776 11,567 11,776 11,776 6436 UNCOLLECTIBLE CHECKSIDEBTS 905 10,580 6438 CASH SHORT (OVER) 53- 109- 31- 6430 MISCELLANEOUS 14,834 25,206 15,346 11,536 13,346 13,346 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 35 6449 OTHER CONTRACTUAL SERVICE 6,642 7,064 7,278 6,935 9,204 9,204 6440 OTHER EXPENSES 6,677 7,064 7,278 6,935 9,204 9,204 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 158,768 160,226 168,000 120,169 180,253 180,253 6490 OTHER MISC COSTS/EXPENSES 158,768 160,226 168,000 120,169 180,253 180,253 6299 OTHER CHARGES & SERVICES 328,394 313,689 355,893 238,393 374,132 374,132 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6001 EXPENDITURES/EXPENSES 420,457 407,134 437,214 318,867 463,822 463,822 4000 REVENUES AND EXPENSES 415,296- 344,819- 381,785- 222,923- 347,787- 347,787- 49853 EBHC- CATERING OPERATIONS 415,296- 344,819- 381,785- 222,923 - 347,787- 347,787- 91 This page has been left blank intentionally. 92 City of (Brooklyn Center 2011 Budget FUND: Earle Brown Heritage Center — 61700 DEPT /ACTIVITY /PROJECT: Office Rental — 49854 PROFILE The D Barn (commercial office building) will have a new tenant as Oliver and Company, the Embassy Suites hotel owner, converts the building into a Salon and Spa to compliment the hotel and convention center guests following the completion on the connectin g walkway (Link). Innovative Presentations continues in the former Inn in their office area. DEPARTMENTAL GOALS • Provide maintenance to building. • Respond to tenant concerns in a timely mariner. EXPENDITURE DETAILS 6402 $1,500 Provides for repair and maintenance of buildings mechanical, electrical, and structural needs. PERSONNEL LEVELS Maintenance and custodial care provided by facility staff under the direction of the Maintenance Supervisor. CAPITAL OUTLAY See Capital Projects Fund 93 This page has been left blank intentionally. 94 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 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 57,183- 25,680- 25,680- 95,240- 25,680- 25,680- 4830 OFFICE RENTAL 57,183- 25,680- 25,680- 95,240- 25,680- 25,680- 4800 EBHC 57,183- 25,680- 25,680- 95,240- 25,680- 25,680- 4900 OTHER FINANCING SOURCES 4001 REVENUES 57,183- 25,680- 25,680- 95,240- 25,680- 25,680 - 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 2,291 1,411 409 1,000 1,000 6103 WAGES -PART TIME EMPLOYEES 3,519 2,822 3,800 1,874 3,800 3,800 6100 WAGES AND SALARIES 5,810 4,233 3,800 2,284 4,800 4,800 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 378 285 270 160 336 336 6125 FICA 360 262 235 142 298 298 6126 MEDICARE CONTRIBUTIONS 84 61 55 33 70 70 6120 RETIREMENT CONTRIBUTIONS 823 609 560 335 704 704 6130 INSURANCE BENEFITS 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 292 224 195 123 259 259 6150 WORKER'S COMPENSATION 292 224 195 123 259 259 6099 PERSONAL SERVICES 6,924 5,066 4,555 2,742 5,763 5,763 6199 SUPPLIES 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 232 6210 OPERATING SUPPLIES 232 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 1,009 564 996 171 996 996 6225 PARK & LANDSCAPE MATERIALS 300 300 300 6226 SIGNS & STRIPING MATERIALS 93 228 300 300 300 6 PAINT SUPPLIER_ 14 150 150 150 6220 REPAIR & MAINT SUPPLIES 1,116 791 1,746 171 1,746 1,746 6230 REPAIR & MAINT SUPPLIES -OTHER 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES 1,346 791 1,746 171 1,746 1,746 95 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/3012010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6320 COMMUNICATIONS 6349 OTHER ADVERTISING 246 6320 COMMUNICATIONS 246 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 473 718 935 422 608 608 6362 PROPERTY INSURANCE 1,020 1,594 1,985 1,064 1,527 1,527 6366 MACHINERY BREAKDOWN INSURANCE 72 98 135 61 87 87 6360 INSURANCE 1,565 2,410 3,055 1,547 2,222 2,222 6380 UTILITY SERVICES 6381 ELECTRIC 356 4,339 4,374 3,203 4,374 4,374 6382 GAS 2,613 5,340 8,478 4,569 8,478 8,478 6383 WATER 126 243 204 222 260 260 6384 REFUSE DISPOSAL 1,109 832 996 461 996 996 6385 SEWER 250 271 204 318 400 400 6380 UTILITY SERVICES 4,454 11,025 14,256 8,772 14,508 14,508 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 943 3,333 1,500 950 1,500 1,500 6403 BLDGS /FACILITIES MAINT SERVICE 120 504 120 504 504 6400 REPAIR & MAINT SERVICES 1,D63 3,333 2,004 1,070 2,004 2,004 6410 RENTALS 6420 IS SERVICES /LICENSES/FEES 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 7,041 21,811 11,300 3,921 6449 OTHER CONTRACTUAL SERVICE 4,672 6,300 6,504 4,840 8,299 8,299 6440 OTHER EXPENSES 11,713 28,111 17,804 8,762 8,299 8,299 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 35,873 142,427 142,500 106,820 165,100 165,100 6490 OTHER MISC COSTSIEXPENSES 35,873 142,427 142,500 106,820 165,100 165,100 6299 OTHER CHARGES & SERVICES 54,666 187,552 179,619 126,970 192,133 192,133 6001 EXPENDITURES/EXPENSES 62,939 193,409 185,920 129,884 199,642 199,642 4000 REVENUES AND EXPENSES 5,756 167,729 160,240 34,644 173,962 173,962 49854 EBHC- OFFICE RENTAL 5,756 167,729 160,240 34,644 173,962 173,962 96 City of Brook& Center 2011 Budget FUND: Earle Brown Heritage Center — 61700 DEPT /ACTIVITY /PROJECT: Inn on the Farm — 49855 PROFILE Operations at the Inn on the Farm were discontinued in June of 2008. 97 This page has been left blank intentionally. 98 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 49855 EBHC -INN ON THE FARM 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4800 EBHC 4810 INN ON THE FARM 4811 GUEST ROOM RENTALS 8,470- 4812 FACILITY RENTALS 175- 4814 EQUIPMENT RENTALS 30- 4810 INN ON THE FARM 8,675- 4800 EBHC 8,675- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 73,241- 4921 REFUNDS & REIMBURSEMENTS 1,479- 4900 OTHER FINANCING SOURCES 74,720- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 4001 REVENUES 83,395- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 10,913 6102 OVERTIME -FT EMPLOYEES 200 6103 WAGES -PART TIME EMPLOYEES 10,880 6100 WAGES AND SALARIES 21,993 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 1,399 6125 FICA 1,361 6126 MEDICARE CONTRIBUTIONS 318 6120 RETIREMENT CONTRIBUTIONS 3,079 6130 INSURANCE BENEFITS 6140 UNEMPLOYMENT COMPENSATION 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 981 6150 WORKER'S COMPENSATION 981 vw9 PERSONAL SERVICES 26,053 6199 SUPPLIES 6200 OFFICE SUPPLIES 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 4 6219 GENERAL OPERATING SUPPLIES 533 6210 OPERATING SUPPLIES 538 99 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 913012010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 3,032 6226 SIGNS & STRIPING MATERIALS 59 6227 PAINT SUPPLIES 172 6220 REPAIR & MAINT SUPPLIES 3,263 6230 REPAIR & MAINT SUPPLIES -OTHER 6237 LAUNDRY SUPPLIES 28 6239 OTHER REPAIR & MAINT SUPPLIES 63 6230 REPAIR & MAINT SUPPLIES -OTHER 91 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 772 6240 SMALL TOOLS & MINOR EQUIPMENT 772 6199 SUPPLIES 4,664 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,100 6320 COMMUNICATIONS 1,100 6340 ADVERTISING 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,004 6362 PROPERTY INSURANCE 2,004 6366 MACHINERY BREAKDOWN INSURANCE 147 6360 INSURANCE 3,155 6380 UTILITY SERVICES 6381 ELECTRIC 6,810 6382 GAS 10,893 6383 WATER 206 6384 REFUSE DISPOSAL 116 6385 SEWER 212 6380 UTILITY SERVICES 18,238 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 7,622 6403 BLDGS/FACILITIES MAINT SERVICE 160 6400 REPAIR & MAINT SERVICES 7,982 6410 RENTALS 6420 IS SERVICES/LICENSES/FEES 6428 PROTECTION SERVICES 941 6420 IS SERVICES/LICENSES/FEES 941 6430 MISCELLANEOUS 6435 CREDIT CARD FEES 86 100 CITY OF BROOKLYN CENTER Budget Report 2008 2009 2010 9/30/2010 2011 2011 Actual Actual Final YTD Recommended Approved Object Code / Description Amount Amount Budget Actual Budget Budget 6436 UNCOLLECTIBLE CHECKS/DEBTS 83- 6430 MISCELLANEOUS 3 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 13,476 6449 OTHER CONTRACTUAL SERVICE 3,106 6440 OTHER EXPENSES 16,582 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 88,758 6490 OTHER MISC COSTS/EXPENSES 88,758 6299 OTHER CHARGES & SERVICES 136,758 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 167 474 RE / , 6001 EXPENDITU S EXPENSES 4000 REVENUES AND EXPENSES 84,079 49855 EBHC -INN ON THE FARM 84,079 61700 EARLE BROWN HERITAGE CENTER 313,439 801,807 924,275 360,527 919,270 919,270 101 This page has been left blank intentionally. 102 PM City of Brooklyn Center Earle Brown Heritage Center Cash Flows r Actual Actual Budget Proposed Projected Projected Projected Projected 2008 2009 2010 2011 2012 2013 2014 2015 Revenues Customer Receipts $ 3,831,972 $ 3,542,077 $ 3,687,782 $ 3,946,677 $ 4,144,011 $ 4,351,211 $ 4,568,772 $ 4,797,211 Misc. Operating $ 2,936 $ 646 $ - $ - $ 9,800 $ 9,800 $ 9,800 $ 9,800 Misc. Non - operating $ 31,443 $ 10,960 $ 9,000 $ 3,250 $ 2,180 $ 2,678 $ 3,638 $ 5,098 Total Revenues $ 3,866,351 $ 3,553,683 $ 3,696,782 $ 3,949,927 $ 4,155,991 $ 4,363,689 $ 4,582,210 $ 4,812,109 Expenditures Personal Services $ 894,062 $ 926,848 $ 966,250 $ 966,546 $ 995,542 $ 1,025,409 $ 1,056,171 $ 1,087,856 Supplies $ 123,906 $ 109,075 $ 165,122 $ 158,234 $ 162,981 $ 167,870 $ 172,907 $ 178,094 Services $ 798,840 $ 691,888 $ 817,257 $ 801,910 $ 821,958 $ 842,507 $ 863,569 $ 885,159 Cost of Good Sold $ 1,875,280 $ 1,816,865 $ 1,826,803 $ 2,069,391 $ 2,020,205 $ 2,121,216 $ 2,227,276 $ 2,338,640 Depreciation $ 579,118 $ 624,329 $ 651,625 $ 712,919 $ 575,000 $ 575,000 $ 575,000 $ 575,000 Debt Transfer $ - $ - $ - $ - $ - $ - $ - $ - Total Expenditures $ 4,271,206 $ 4,169,005 $ 4,427,057 $ 4,709,000 $ 4,575,686 $ 4,732,001 $ 4,894,923 $ 5,064,749 C) Capital Transfer $ 235,000 $ 300,000 $ 200,000 $ 200,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 w Total Cash Requirement $ 4,506,206 $ 4,469,005 $ 4,627,057 $ 4,909,000 $ 4,675,686 $ 4,832,001 $ 4,994,923 $ 5,164,749 Beginning Cash Balance $ 1,151,030 $ 1,153,340 $ 767,014 $ 488,364 $ 242,210 $ 297,514 $ 404,202 $ 566,489 Changes in Assets /Liabilities $ 63,047 $ (95,333) $ - $ - $ - $ - $ - $ - Revenues $ 3,866,351 $ 3,553,683 $ 3,696,782 $ 3,949,927 $ 4,155,991 $ 4,363,689 $ 4,582,210 $ 4,812,109 Expenditures $ (4,506,206) $ (4,469,005) $ (4,627,057) $ (4,909,000) $ (4,675,686) $(4,832,001) $ (4,994,923) $ (5,164,749) Depreciation Add -Back $ 579,118 $ 624,329 $ 651,625 $ 712,919 $ 575,000 $ 575,000 $ 575,000 $ 575,000 Ending Cash Balance $ 1,153,340 $ 767,014 $ 488,364 $ 242,210 $ 297,514 $ 404,202 $ 566,489 $ 788,849 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Revenues from 2011 through 2015 projected to grow 5% per year Cost of Goods Sold is 48.75% of Total Customer Receipts Cash Transfer to Capital dropped to $ 100,000 per year in 2012 -2015. This allows the CIP to continue. Personal Services rise by 3% per year 2012 -2015 Supplies costs rise by 3% per year 2012 -2015 Services costs rise 2.5% per year 2012 -2015 I This page has been left blank intentionally. 104 City of Brook& Center 2011 Budget FUND: Earle Brown Heritage Center — 40800 DEPT /ACTIVITY /PROJECT: Capital Projects This fund provides for the replacement of fully depreciated or obsolete capital items and new capital purchases. CAPITAL OUTLAY — Convention Center 6520 Buildings and Facilities Carriage Hall Carpet Unit Cost: $70,000 Less Trade -in: $ -0- Total Cost: $70,000 Carriage Hall divider wall Unit Cost: $35,000 Less Trade -in: $ -0- Total Cost: $35,000 6540 Equipment and Machinery Replace Combi Oven Unit Cost: $40,000 Less Trade -in: $ -0- Total Cost: $40,000 105 i i I i This page has been left blank intentionally. I 106 EARLE BROWN HERITAGE CENTER 2008 -2035 CAPITAL IMPROVEMENT PLAN (revised August 20, 2010) Acquisition Acquisition Estimated Acquisition or Capital Item Year Cost Useful Life Replacement Year Estimated Cost Rotunda roof & CH metalwork 19891 20 2008 $ 2,500 (insurance) Energy Management System (HVAC) 1999 $ 15,500 10 2008 $ 49,300 Compactor 1990 $ 11,375 20 2008 $ 17,775 Inn carpet Earle Brown House 1989 2008 $ 30,000 Main large mar uee +electronics 1989 19 2008 $ 30,000 $ 129,575 Replace S Carriage Hall door /windows 1989 Jul -09 $ 45,000 CH Wall Panels 1989 $ 72,000 15 Jul -09 $ 108,000 Facility Security System New 10 Aug-09 $ 35,000 CH Electronic Reader Board New 15 Jun -09 $ 35,000 Replace 0 Barn roof 1989 20 May-09 $ 24,000 Phone System 1998 $ 32,000 10 May-09 $ 40,000 $ 287,000 Replace chiller 1989 20 2010 $ 160,000 Replace 2 boilers jCovention Center 19891 14 2010 $ 15,000 C /H /GC Electronic Reader Boards New 2010 $ 60,000 Replace Harvest /Blacksmith roof 1990 20 2010 $ 20,000 Replace Stable Roof 1990 20 2010 $ 28 $ 283,000 �� ; ,,. .. MOTT 77 Carriage Hall carpet 2005 $ 50,000 6 2011 $ 70,000 Replace combi oven 1990 $ 14,165 15 2011 $ 40,000 CH divider wall (repair/replace) 1989 20 2011 $ 35,000 $ 145,000 Hippodrome roof a dm 1990 $ 91,575 20 -30 2012 $ 100,000 Replace 2 boilers Inn 1989 20 2012 $ 15,000 Tack/Morgan/Hall carpet 2004 $ 15,000 7 2012 $ 30,000 Replace Garden City carpet* 2006 6 2012 $ 35,000 $ 180,000 Replace Harvest/Lo bby/Hall carpet 2006 $ 20,000 7 2013 $ 45,000 Replace Inn roofs 1989 20 -25 2013 $ 45,000 $ 90,000 Add kitchen walk -in cooler 1990 $ 3,664 2014 $ 30,000 Ca tain'slEstate(Loft Carpet 2007 $ 18,000 7 2014 $ 25,000 Replace Harvest divider walls 1999 15 2014 $ 20,000 Replace staging 1990 $ 19,925 15 2014 $ 38,000 $ 113,000 Parking lot mill and overlay (East lots 1999 16 2015 $ 70 000 $ 70,000 2016 $ Carriage Hall carpet 2011 $ 50,000 6 2017 $ 50,000 $ 50,000 Tack/Morgan/Hall carpet 2011 $ 15,000 7 2018 $ 30,000 $ 30,000 Replace Garden City carpet 2012 7 2019 $ 35,000 $ 35,000 Main kitchen dishwasher 2005 $ 75,000 15 2020 $ 75,000 Replace Harvest/Lobby/Hall carpet 2013 $ 40,000 7 2020 $ 50,000 Man Lift 2005 $ 15 15 2020 $ $ 140 000 ,. `. a......_. `7.< ,�a. ; a. �.,, m 107 i Acquisition Acquisition Estimated Acquisition or Capital Item Year Cost Useful Life Replacement Year Estimated Cost Parking lot mill and overlay 2005 $ 70,000 16 2021 $ 70,000 Replace Admin Office carpet 2006 $ 18,000 15 2021 $ 23,000 Sealcoat original parking lot 2013 $ 15,000 0 2021 $ 15,000 $ 108,000 Replace one boiler 2007 $ 15,000 15 2022 $ 15,000 $ 15,000 Carriage Hall carpet 2017 $ 50,000 6 2023 $ 50,000 Sealcoat both East parking lots 2015 $ 15,000 8 2023 $ 15,000 $ 65,000 2024 $ Tack/Morgan/Hall carpet 2018 $ 15,000 7 2025 $ 15 $ 85,000 i is ,rive. l'earu6t4fal 7 y Replace Garden City carpet 2019 $ 30,000 7 2026 $ 30,000 $ 30,000 Replace Harvest/Lobby/Hall carpet 2020 $ 40,000 7 2027 $ 40,000 $ 40,000 Captain's/Estate/Loft Carpet 2021 $ 18,000 7 2028 $ 30,000 $ 30,000 Carriage Hall carpet 2023 $ 50,000 6 2029 $ 50,000 $ 50,000 2030 $ Five Year 3vb #o$a/ .. s. , . :�- .xr 1© e �. 2031 $ - Tack/Morgan/Hall carpet 2025 $ 15,000 7 2032 $ 15,000 $ 15,000 Garden City carpet 2026 $ 30,000 7 2033 $ 30,000 Replace one boiler 2018 $ 10,000 15 2033 $ 15,000 $ 45,000 Harvest /Lobby/Hall carpet 2027 $ 40,000 7 2034 $ 40,000 $ 40,000 Ca tarn s /Estate /Loft carpet 2028 $ 30 000 7 2035 $ 30 $ 30 F�ve':Year'Sutiiotai w z ',, This report encompasses all anticipated capital expenditures (items exceeding $10,000) from 2008 -2035. All dollar amounts are shown in 2008 dollars, with appropriate yearly increases projected where possible. H:Admin /Budget/Multiple Year Capital Plan Date Order Revised 8/20/2010 108