The URL can be used to link to this page

Home My WebLink About2003 10-20 CCP Joint Work Session with Financial Commission AGENDA CITY COUNCIL WORK SESSION October 20, 2003 6:30 P.M. COUNCIL COMMISSION CONFERENCE ROOM 1" FLOOR CITY HALL Joint Meeting with Financial Commission 1. Utilities a. Water b. Sanitary Sewer c. Stormwater d. Street Light Utility e. Recycling 2. Draft Enterprise Fund Budgets (non - utility) a. Golf b. Earle Brown Heritage Center 3. Rough Draft Capital Improvement Plan 4. November 17' Meeting i. Finalize General Fund for Truth in Taxation and Adoption ii. Wage and insurance negotiations iii. Liquor Fund iv. Capital Improvement Plan 5. Miscellaneous 6. Adjourn City of Brooklyn Center A Millennium Community To: Mayor and City Council Members Financial Commission Members From: Michael J. McCauley City Manager Date: October 16, 2003 Re: October 20 Work Session The utility rate study performed in 2002 for the period 2003 — 2007 assumed a general rate increase of 3% per year to achieve cash balance targets, operating cost coverage, and capital expenditures, primarily related to street reconstruction projects. Mr. Blomstrom and Mr. Sell have reviewed those rate studies and Mr. Blomstrom's review for the rough draft Capital Improvement Plan and the proposed utility rates is attached. The proposal for rates is as follows: 1. Utilities a. The draft budget will be high on revenues in the budget because they were premised on last year's rate study. They will be revised to reflect the lower rate increases that are being proposed for water and sanitary sewer and the absence of rate increases for storm water and recycling. b. Rates: i. Attached is a chart showing how Brooklyn Center rates compare to our neighboring cities. Our water rates are in the lower range. If federal or state regulations change, especially with respect to manganese, we may have to construct a pre - treatment plant that would increase rates substantially for debt service. ii. Our sanitary sewer rates are in the middle of neighboring cities. iii. Our storm sewer rates are in the higher due to the capital projects that have been undertaken and debt service. Some cities are in a different stage in their stormwater infrastructure undertakings. c. Water i. 2.8% increase 1. This level of rate increase will result in cash balances at the end of the period just under the cash reserve target balance, while sustaining the water improvements contained in the street reconstruction program. d. Sanitary Sewer i. 2.8% increase 1. This level of rate increase will result in cash balances above the target at the end of the 5 year period and roughly at the 6301 Shingle Creek Parkway Recreation and Community Center Phone & TDD Number Brooklyn Center, MN 55430 -2199 (763) 569 -3400 City Hall & TDD Number (763) 569 -3300 FAX (763) 569 -3434 FAX (763) 569 -3494 www.cityofbrooklyncenter. org target at the end of 2004, from a projected balance below the target at the end of 2003. The sanitary sewer sewer rates will support the capital improvements. e. Stormwater i. NO increase in rates 1. The Stormwater utility will be retiring bonds in 2005/6 that will impact its revenue needs. We need to develop a plan for the servicing of regional storm water detention ponds. We are also proposing to use storm water utility funds for the cost of curb and gutter construction in street projects since the curb and gutter are an integral part of the collection system for storm water. Further development of this planning may result in a proposed reduction in storm water rates. f. Street Light Utility i. 3% rate increase 1. The street light utility is not generating enough revenue to sustain the costs of street lights involved in the street reconstruction projects. We may need to propose a higher rate of increase in 2005 or 2006 when such a rate increase could be offset or perhaps more than offset by a reduction in the storm water rates. 2. We are reviewing a possible use of franchise money to cover this deficit in street light revenues since this is all part of the funding mix to sustain the street reconstruction program. g. Recycling i. NO increase in rates 1. The recycling fund continues to spend down its fund balance. The 3 city group is reviewing city wide clean up days again and using some fund balance to fund that and to phase in increased rates. The rates for recycling have not increased in a number of years. 2. Draft Enterprise Fund Budgets (non - utility) a. Golf i. The golf course had another weather challenged year. Attached is a memorandum from Jim Glasoe reviewing golf course operating results. The budgeted loan repayment for 2003 will have to be reduced from its current accelerated level to an adjusted amount consistent with the level of profits achieved this year. b. Earle Brown Heritage Center i. The Draft Earle Brown Heritage Center budget projects a small net cash flow on slightly lower projected revenues. ii. Some adjustments to the draft remain to be made to increase CMP Room rental from $30,000 to $53,000 and decrease rental $13,000. 3. Rough Draft Capital Improvement Plan a. The enclosed memorandum from Todd Blomstrom is a very rough draft of the development of the capital improvement plan that is an extension of the 2003 -2007 plan to 2004 -2008. The ability to do 2 projects in 2008 is dependent on a number of variables related to fund availability and transfers. i. One of the transfers being considered would be approximately $180,000 of monies received in connection with housing bond refundings that was placed in the General Fund this year upon receipt. 4. November 17"' Meeting i. Finalize General Fund for Truth in Taxation and Adoption 1. Identification of specific areas by Council or Financial Commission 2. Anticipate additional reduction in Public Works full time employee count due to employee leaving to work for Blaine. (This also raises issue of wage competitiveness as this is the second employee in last year+ to leave for Blaine.) ii. Wage and insurance negotiations 1. Negotiations have commenced. a. There continues to be a range of contract settlements. b. Insurance will increase in cost around 13% or so and deductibles are being doubled. c. Important to note that State settlement is hard to fully decipher based on steps and their health plan will still be less expensive to employees than our plan and many others. iii. Liquor Fund 1. The draft budget is being revised to incorporate the pro forma for 2 stores now that the lease has been approved. 5. Miscellaneous 6. Adjourn 3 Ctyaf MEMORANDUM BROOBLYN CENTER DATE: October 15, 2003 TO: Michael McCauley, City Manager FROM: Todd Blomstrom, Director of Public Works 'rA 177 SUBJECT: Capital Improvement Program and Rate Analysis Capital Improvement Program Attached for your review is the preliminary 5 -year Capital Improvement Program (CIP) for the 2004 budget. The revised CIP is based on projects previously identified in the 2003 budget with the following modifications. 1. Construction costs have been adjusted to 2004 levels using the ENR Construction Cost Index. This index adjusts for annual increases in construction labor and material costs. 2. The CIP was extended out to the year 2008 with additional street and utility reconstruction projects as identified in the neighborhood street improvement program. 3. The 73 Avenue reconstruction project originally schedule for 2003 was rescheduled for 2004 construction. This project will be completed jointly with the City of Brooklyn Park. 4. The recently created street construction fund was added to the CIP. 5. Construction costs for curb & gutter drainage improvements on non -MSA streets were transferred to the storm water utility fund. Rate Analysis A preliminary rate analysis was completed for the water, sewer, storm sewer and street light utilities as well as the street construction fund to determine appropriate annual rate adjustments. These adjustments were determined based on the need to maintain adequate fund balances during completion of the projects identified for construction in the CIP. The attached tables provide the details of the analysis performed for each fund. The table below summarizes the proposed 2004 rate adjustments as compared to the estimated rate adjustments included in the 2003 CIP. Annual Adjustment Fund 2003 CIP 2004 CIP Water Utility 3% 2.8% Sewer Utility 3% 2.8% Storm Sewer Utility 3% 0% Street Light Utility 3% 3% Street Construction See Below Water Utility Fund — A proposed 2.8 percent annual rate adjustment over five years will maintain a fund balance above the cash reserve target through 2007 and will result in a deficit of 8 percent below the cash reserve target in 2008. One of the street reconstruction projects in 2008 may need to be delayed as described in the street construction fund narrative below. Sanitary Sewer Utility Fund — A proposed 2.8 percent annual rate adjustment over five years will provide approximately $280,000 over the cash reserve target through 2008. This additional fund balance may be necessary to address new sewer system requirements currently being considered by the Environmental Protection Agency. Storm Sewer Utility Fund —No increase in rate is proposed at this time. The current rate will adequately fund the storm sewer utility for the 2004 CIP. Although the current rate analysis indicates that the fund balance will exceed the cash reserve target, a substantial increase in expenditures is expected due to the NPDES Phase II requirements initiated by the Environmental Protection Agency in 2003. These additional expenditures will be determined during 2004 and included in the 2005 CIP. A rate increase may be necessary in 2005. Street Light Utility — A 3.0 percent increase is proposed for the 2004 budget. The current funding analysis shows that this increase will not be adequate to fund the capital expenditures included in the current 2004 CIP. These expenditures are associated with the neighborhood street reconstruction program. It is recommended that a portion of the street light capital expenditures (approx. 30 %) be transferred to the street construction fund in order to meet the cash reserve target through 2008. Street Construction Fund — The rate analysis assumes an initial fund transfer into the street construction fund of approximately $1,300,000 and an initial annual revenue amount of $650,000. It is also assumed that the annual revenue amount will be derived from the proposed franchise fee and this amount will increase in proportion to an annual increase in electric rates of 3 percent. Cash reserves would be maintained through 2007, but drop substantially in 2008. This indicates that one of the street projects identified in the neighborhood street reconstruction program for 2008 will likely need to be delayed until 2009 if additional funding is not available. 5 2004 - 2006 Capital Improvement Program City of Brooklyn Center October 16, 2003 Funding Year Project Description Sources Special Street Capital Water Utility Sewer Utility Storm Sewer Street Light MSA Grants Total Project Assessment Construction Improvements Utility Utility Cost Collections Fund Fund 2004 2004 Grandview Park Football /Soccer field, lights, baseball field and playground $ 338,200 $ 338,200 2004 73rd Avenue Humboldt to Palmer Lake $ 66,000 $ 97,000 $ 63,300 $ 59,800 $ 57,200 $ 343,300 2004 Northport Improvement Project Neighborhood street project $ 614,900 $ 548,200 $ 612,300 $ 569,400 $ 523,500 $ 85,000 $ 348,400 $ 3,301,700 2004 Shingle Creek Pkwy Street improvement project $ 271,600 $ 10,300 $ 10,300 $ 20,500 $ 358,700 $ 671,400 2004 Evergreen Park Sidewalks Sidewalk construction $ 51,200 $ 51,200 Total 2004 $ 952,500 $ 696,400 $ 338,200 $ 685,900 $ 639,500 $ 601,200 $ 85,000 $ 707,100 $ 4,705,800 2005 2005 Central Park Lighting $ 235,700 $ 235,700 2005 Earle Brown Improvement Project Street improvement project $ 111,900 $ 159,900 $ 271,800 2005 Tangletown Improvement Project South Street improvement project $ 744,600 $ 817,400 $ 657,500 $ 620,800 $ 582,800 $ 86,500 $ 3,509,600 Total 2006 $ 856,500 $ 817,400 $ 235,700 $ 657,500 $ 620,800 $ 582,800 $ 86,500 $ 159,900 $ 4,017,100 2006 2006 Garden City Park Shelter bldg $ 92,200 $ 92,200 2006 Kylawn Park Shelter bldg, trails and lights $ 194,700 $ 194,700 2006 Riverdale Park Shelter bldg $ 35,900 $ 35,900 2006 Dupont Avenue Improvement Project Street improvement project $ 391,800 $ 116,800 $ 110,200 $ 27,500 $ 275,400 $ 921,700 2006 Humboldt Avenue Improvement Project Street improvement project $ 205,000 $ 102,500 $ 51,200 $ 410,000 $ 768,700 2006 Tangletown Improvement Project North Neighborhood street project $ 502,200 $ 684,700 $ 456,900 $ 431,400 $ 408,600 $ 60,800 $ 2,544,600 2006 Lift Station #9 Pump replacements and forcemain replacement $ 205,000 $ 205,000 2006 Lift Station #2 Pump, FM, and Interceptor replacements $ 307,400 $ 307,400 Total 2006 $ 1,099,000 $ 684,700 $ 322,800 $ 676,200 $ 1,105,200 $ 436,100 $ 60,800 $ 685,400 $ 5,070,200 2007 2007 West Palmer Lake Park Shelter bldg $ 102,500 $ 102,500 2007 Riverwood Improvement Project Street improvement project $ 597,900 $ 757,900 $ - $ 581,300 $ 548,900 $ 581,900 $ 75,100 $ 3,143,000 2007 Freeway Blvd Improvement Project Street improvement project $ 307,400 $ 20,500 $ 51,200 $ 20,500 $ 409,900 $ 809,500 Total 2007 $ 905,300 $ 757,900 $ 102,500 $ 601,800 $ 600,100 $ 602,400 $ 75,100 $ 409,900 $ 4,055,000 2008 2008 East River Improv Project Street improvement project $ 509,800 $ 525,900 $ 276,400 $ 453,100 $ 402,900 $ 56,200 $ 113,000 $ 2,337,300 2008 Maranatha Improv Project Neighborhood street project $ 701,000 $ 840,500 $ 394,800 $ 612,400 $ 564,500 $ 89,000 $ 3,202,200 2008 Northway Drive Improv Project Street improvement project $ 123,000 $ 8,200 $ 8,200 $ 7,200 $ 146,600 2008 Xerxes Avenue Improv Project Street improvement project $ 236,700 $ 10,300 $ 10,300 $ 10,300 $ 338,200 $ 605,800 Total 2008 $ 1,570,500 $ 1,366,400 $ - $ 689,700 $ 1,084,000 $ 984,900 $ 145,200 $ 451,200 $ 6,291,900 Notes Estimated costs are adjusted from 2003 CIP using ENR Construction Cost Index Projects scheduled for 2008 are under further study. One of these projects may be delayed until 2009 based on funding availability Non -MSA curb 6 gutter costs have been transferred to Storm Water Utility Water Utility Fund Rate Analysis 2003 2004 2005 2006 2007 2008 Revenues Water Service $ 1,262,500 $ 1,297,850 $ 1,334,190 $ 1,371,547 $ 1,409,950 $ 1,449,429 Misc. Operating $ 225,100 $ 228,800 $ 234,500 $ 238,200 $ 241,900 $ 245,600 Misc. Non - operating $ 30,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Revenues $ 1,517,600 $ 1,536,650 $ 1,578,690 $ 1,619,747 $ 1,661,850 $ 1,705,029 Expenditures Personal Services $ 328,477 $ 352,318 $ 369,934 $ 388,431 $ 407,852 $ 428,245 Supplies $ 159,050 $ 170,250 $ 175,358 $ 180,618 $ 186,037 $ 191,618 Services $ 425,555 $ 438,322 $ 451,471 $ 465,015 $ 478,966 $ 493,335 Depreciation $ 588,100 $ 578,000 $ 610,000 $ 630,000 $ 650,000 $ 670,000 Debt Service $ 0 $ $ $ $ $ Total Expenditures $ 1,501,182 $ 1,538,890 $ 1,606,763 $ 1,664,064 $ 1,722,855 $ 1,783,197 Capital Outlay $ 667,550 $ 685,900 $ 673,938 $ 710,433 $ 648,073 $ 761,300 Total Cash Requirement $ 2,168,732 $ 2,224,790 $ 2,280,700 $ 2,374,497 $ 2,370,928 $ 2,544,497 Cash Reserve Target $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 Beginning Cash Balance $ 1,541,308 $ 1,478,276 $ 1,368,136 $ 1,276,126 $ 1,151,376 $ 1,092,299 Revenues $ 1,517,600 $ 1,536,650 $ 1,578,690 $ 1,619,747 $ 1,661,850 $ 1,705,029 Expenditures $ (2,168,732) $ (2,224,790) $ (2,280,700) $ (2,374,497) $ (2,370,928) $ (2,544,497) Depreciation Add -Back $ 588,100 $ 578,000 $ 610,000 $ 630,000 $ 650,000 $ 670,000 Ending Cash Balance $ 1,478,276 $ 1,368,136 $ 1,276,126 $ 1,151,376 $ 1,092,299 $ 922,831 Additional sums necessary $ 77,169 to meet Cash Reserve Target Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Revenues Rate increases would be 2.8% per year across the board and are based on 1.25 billion gallons billed per year. Expenditures Supplies and Services increase at a total rate of 3% annum. Depreciation increases at a rate of approximately 3% per annum. Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period. Revised 10/16/03 Sewer Utility Fund Rate Analysis 2003 2004 2005 2006 2007 2008 Revenues Sewer Charges $ 2,725,380 $ 2,804,760 $ 2,884,140 $ 2,963,520 $ 3,042,900 $ 3,129,000 Misc. Operating $ 0$ 0$ 0$ 0$ 0$ 0 Misc. Non - operating $ 30,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Revenues $ 2,755,380 $ 2,814,760 $ 2,894,140 $ 2,973,520 $ 3,052,900 $ 3,139,000 Expenditures Personal Services $ 120,263 $ 148,142 $ 155,549 $ 163,327 $ 171,493 $ 180,068 Supplies $ 20,100 $ 17,315 $ 17,834 $ 18,369 $ 18,921 $ 19,488 Services $ 1,865,647 $ 1,742,398 $ 1,794,670 $ 1,848,510 $ 1,903,965 $ 1,961,084 Depreciation $ 432,100 $ 458,000 $ 470,000 $ 485,000 $ 500,000 $ 0 Debt Service $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Total Expenditures $ 2,438,110 $ 2,365,855 $ 2,438,053 $ 2,515,206 $ 2,594,379 $ 2,160,640 Capital Outlay $ 633,390 $ 639,500 $ 636,320 $ 1,161,151 $ 646,242 $ 1,196,533 Total Cash Requirement $ 3,071,500 $ 3,005,355 $ 3,074,373 $ 3,676,357 $ 3,240,621 $ 3,357,173 Cash Reserve Target $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 $ 950,000 Beginning Cash Balance $ 682,184 $ 798,164 $ 1,065,569 $ 1,355,336 $ 1,137,499 $ 1,449,778 Revenues $ 2,755,380 $ 2,814,760 $ 2,894,140 $ 2,973,520 $ 3,052,900 $ 3,139,000 Expenditures $ (3,071,500) $ (3,005,355) $ (3,074,373) $ (3,676,357) $ (3,240,621) $ (3,357,173) Depreciation Add -Back $ 432,100 $ 458,000 $ 470,000 $ 485,000 $ 500,000 $ 0 Ending Cash Balance $ 798,164 $ 1,065,569 $ 1,355,336 $ 1,137,499 $ 1,449,778 $ 1,231,605 Additional sums necessary $ 151,836 to meet Cash Reserve Target Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Revenues Rate increases would be 2.8% per year across the board and are based on 1.323 billion gallons billed per year. Expenditures Supplies and Services increase at a total rate of 3% annum. Depreciation increases at a rate of approximately 3% per annum. Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period. Revised 10/16/03 C� Storm Sewer Utility Fund Rate Analysis 2003 2004 2005 2006 2007 2008 Revenues Storm Sewer Fees $ 1,235,000 $ 1,235,000 $ 1,235,000 $ 1,235,000 $ 1,235,000 $ 1,235,000 Misc. Operating $ 0$ 0$ 0$ 0$ 0$ 0 Misc. Non - operating $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Revenues $ 1,245,000 $ 1,245,000 $ 1,245,000 $ 1,245,000 $ 1,245,000 $ 1,245,000 Expenditures Personal Services $ 0 $ 18,898 $ 19,843 $ 20,835 $ 21,877 $ 22,971 Supplies $ 20,500 $ 20,900 $ 21,527 $ 22,173 $ 22,838 $ 23,523 Services $ 236,848 $ 83,013 $ 85,503 $ 88,068 $ 90,711 $ 93,432 Depreciation $ 326,600 $ 514,000 $ 523,000 $ 532,000 $ 541,000 $ 550,000 Debt Service $ 239,540 $ 238,250 $ 236,210 $ 0 $ 0 $ 0 Total Expenditures $ 823,488 $ 875,061 $ 886,083 $ 663,076 $ 676,425 $ 689,926 Capital Outlay $ 410,785 $ 601,200 $ 597,370 $ 458,178 $ 648,719 $ 1,087,145 Total Cash Requirement $ 1,234,273 $ 1,476,261 $ 1,483,453 $ 1,121,254 $ 1,325,144 $ 1,777,071 Cash Reserve Target $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 $ 540,000 Beginning Cash Balance $ 343,221 $ 680,548 $ 963,287 $ 1,247,834 $ 1,903,580 $ 2,364,436 Revenues $ 1,245,000 $ 1,245,000 $ 1,245,000 $ 1,245,000 $ 1,245,000 $ 1,245,000 Expenditures $ (1,234,273) $ (1,476,261) $ (1,483,453) $ (1,121,254) $ (1,325,144) $ (1,777,071) Depreciation Add -Back $ 326,600 $ 514,000 $ 523,000 $ 532,000 $ 541,000 $ 550,000 Ending Cash Balance $ 680,548 $ 963,287 $ 1,247,834 $ 1,903,580 $ 2,364,436 $ 2,382,365 Additional sums necessary to meet Cash Reserve Target Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Revenues Rate increases would be 2.8% per year across the board based on current rates and charges. Expenditures Supplies and Services increase at a total rate of 3% annum. Depreciation increases at a rate of approximately 3% per annum. Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period. This analysis does not include future maintenance costs associated with new NPDES Phase II requirements from EPA NPDES Phase II costs will be developed and incorporated into 2005 Rate Analysis Revised 10/16/03 Street Light Utility Fund Rate g tY Analysis Y 2003 2004 2005 2006 2007 2008 Revenues Street Light Fee $ 205,575 $ 211,742 $ 218,095 $ 224,637 $ 231,376 $ 238,318 Misc. Operating $ 0$ 0$ 0$ 0$ 0$ 0 Misc. Non - operating $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Revenues $ 215,575 $ 221,742 $ 228,095 $ 234,637 $ 241,376 $ 248,318 Expenditures Personal Services $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Supplies $ 2,500 $ 2,900 $ 2,987 $ 3,077 $ 3,169 $ 3,264 Services $ 145,000 $ 156,193 $ 160,879 $ 165,705 $ 170,676 $ 175,797 Depreciation $ 0$ 0$ 0$ 0$ 0$ 0 Debt Service $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Total Expenditures $ 147,500 $ 159,093 $ 163,866 $ 168,782 $ 173,845 $ 179,061 Capital Outlay $ 51,090 $ 85,000 $ 88,663 $ 63,878 $ 80,860 $ 160,274 Total Cash Requirement $ 198,590 $ 244,093 $ 252,528 $ 232,660 $ 254,706 $ 339,334 Cash Reserve Target $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Beginning Cash Balance $ 30,361 $ 47,346 $ 24,995 $ 561 $ 2,539 $ (10,790) Revenues $ 215,575 $ 221,742 $ 228,095 $ 234,637 $ 241,376 $ 248,318 Expenditures $ (198,590) $ (244,093) $ (252,528) $ (232,660) $ (254,706) $ (339,334) Depreciation Add -Back $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Ending Cash Balance $ 47,346 $ 24,995 $ 561 $ 2,539 $ - 10,790 $ - 101,807 Additional sums necessary $ 49,439 $ 47,461 $ 60,790 $ 151,807 to meet Cash Reserve Target Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Revenues Rate increases would be 2.8% per year across the board based on customer base of 8,415 residential customers and 538 others. All other revenues would remain flat over the five year period. Expenditures Supplies and Services increase at a total rate of 3% annum. Depreciation increases at a rate of approximately 3% per annum. Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period. Based on this analysis, a portion of annual reconstruction project street light costs will need to be funded from other sources Revised 10/16/03 Street Construction Fund Rate Analysis 2003 2004 2005 2006 2007 2008 Revenues Fund Transfer $ 1,300,000 $ 650,000 $ 668,200 $ 686,910 $ 706,143 $ 725,915 Misc. Operating $ 0$ 0$ 0$ 0$ 0$ 0 Misc. Non - operating $ 0 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 Total Revenues $ 1,300,000 $ 655,000 $ 673,200 $ 691,910 $ 711,143 $ 730,915 Expenditures Personal Services $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Supplies $ 0$ 0$ 0$ 0$ 0$ 0 Services $ 0$ 0$ 0$ 0$ 0$ 0 Depreciation $ 0$ 0$ 0$ 0$ 0$ 0 Debt Service $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Total Expenditures $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Capital Outlay $ 0 $ 696,400 $ 837,835 $ 719,363 $ 816,175 $ 1,508,250 Total Cash Requirement $ 0 $ 696,400 $ 837,835 $ 719,363 $ 816,175 $ 1,508,250 Cash Reserve Target $ $ 800,000 $ 800,000 $ 800,000 $ 800,000 $ 800,000 Beginning Cash Balance 9 9 $ 0 $ 1,300,000 $ 1,258,600 $ 1,093,965 $ 1,066,512 $ 961,479 Revenues $ 1,300,000 $ 655,000 $ 673,200 $ 691,910 $ 711,143 $ 730,915 Expenditures $ 0 $ (696,400) $ (837,835) $ (719,363) $ (816,175) $ (1,508,250) Depreciation Add -Back $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Ending Cash Balance $ 1,300,000 $ 1,258,600 $ 1,093,965 $ 1,066,512 $ 961,479 $ 184,144 Additional sums necessary $ 615,856 to meet Cash Reserve Target Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Revenues Transfer /deposit estimated to increases at 2.8% per year based on anticipated electric rates. Expenditures Capital outlay is from the 2004 CIP and adjusted for estimated ENR Construction Index for each year in the five year period. Revised 10/16/03 l l Water Rates per 1000 gallons Quarterly Storm Utility Plymouth $ 0.75 Fridley $ 3.02 Maple Grove $ 0.90 Roseville $ 4.60 St. Louis Park $ 0.93 Brooklyn Park $ 5.50 Brooklyn Center $ 1.01 St. Louis Park $ 6.00 Fridley $ 1.08 Robbinsdale $ 6.21 Brooklyn Park $ 1.30 Crystal $ 6.63 Robbinsdale $ 1.60 Golden Valley $ 8.00 Richfield $ 1.74 Richfield $ 9.06 Champlin $ 1.94 Plymouth $ 9.75 Roseville $ 2.23 Br000klyn Center $ 11.85 Golden Valley $ 3.00 New Hope $ 12.15 Minneapolis $ 3.14 Champlin none Crystal $ 3.24 Maple Grove none New Hope $ 3.49 Minneapolis none Quarterly Sanitary Sewer Rates Quarterly Recycling Roseville $ 43.00 Crystal $ 43.79 Richfield $ 1.80 Champlin $ 44.75 Fridley $ 3.02 Golden Valley $ 48.00 Maple Grove $ 5.00 Maple Grove $ 50.25 Roseville $ 5.50 Plymouth $ 50.75 Champlin $ 5.95 Brooklyn Park $ 51.25 Plymouth $ 6.00 Brooklyn Center $ 54.10 Brooklyn Center $ 6.45 St. Louis Park $ 56.53 Crystal $ 6.45 Robbinsdale $ 57.00 New Hope $ 6.45 Fridley $ 59.25 Brooklyn Park $ 6.75 Richfield $ 60.25 Golden Valley $ 8.00 New Hope $ 74.95 Robbinsdale $ 11.97 Minneapolis $ 109.06 Minneapolis none St. Louis Park none I City of Brooklyn Center Residential Utility Costs 2003 2004 Water 15,300 gallons per quarter $ 15.45 $ 15.88 Sanitary Sewer Flat rate per quarter $ 54.10 $ 55.61 Senior - Sanitary Sewer $ - Storm Sewer Flat rate per quarter $ 11.85 $ 11.85 Street Light Utility Flat rate per quarter $ 3.03 $ 3.12 Recycling Flat rate per quarter $ 6.45 $ 6.45 Total Quarterly Bill $ 90.88 $ 92.92 2003 Seniors 2004 Senior Water 15,300 gallons per quarter $15.45 $15.88 Sanitary Sewer Flat rate per quarter Senior - Sanitary Sewer $29.75 $29.75 Storm Sewer Flat rate per quarter $11.85 $11.85 Street Light Utility Flat rate per quarter $3.03 $3.12 Recycling Flat rate per quarter $6.45 $6.45 Total Quarterly Bill $66.53 $67.05 City of Brooklyn Center A Millennium Community Memorandum To: Michael McCauley, City Manager From: Jim Glasoe, Director of Community Activities, Recreation and Services Date: 10/15/2003 Re: Centerbrook Financial Review By consensus, most golf course operators would agree that 2001, 2002 and 2003 have not been good years for Minnesota golf courses. Adverse weather conditions, the proliferation of additional courses, along with a struggling economy have left many courses literally fighting for their survival. In 2001, a late start to the golfing season, a wet spring and summer, and a larger than normal number of 90+ degree days added up to a golfing season with a poorer than expected financial performance. In 2002, we encountered similar obstacles, only much worse. When all was totaled, the summer /fall of 2002 was the fourth wettest on record. It was not only the amount of rain, but also the timing of the rainfall that effected play. Many of the summer weekends were lost totally, or in part, due to poor weather. Weekends are historically our strongest times for play. In addition to the rain, we, experienced more 90+ degree days than normal. In wet or hot conditions rounds played are very minimal. Untold revenues were lost as a result of this rain/heat mixture. In addition to the lost rounds, the effects of 9/11/2001 and its impact on the economy are still being felt. When they do golf, players are not spending as much as they have in the past on merchandise and concessions. Revenues in both of these areas were down significantly. For 2002, Centerbrook ended the year with a net income of just over $4,500. This necessitated our scheduled loan repayment ($50,000) be largely funded from reserves. 6301 Shingle Creek Parkway Recreation and Community Center Phone & TDD Number Brooklyn Center, MN 55430 -2199 (763) 569 -3400 City Hall & TDD Number (763) 569 -3300 FAX (763) 569 -3434 FAX (763) 569 -3494 www.cityofbrooklyncenter.org As a result of our recent experience, our financial plan for 2003 included minimal capital, or improvement expenditures. Reductions were also made in staffing hours, and merchandise and equipment purchases. In addition, we did not approve discretionary expenditures in 2003 until positive revenue streams were verified. For all our good intentions, financial success has remained allusive in 2003. Once again, "Mother Nature" has not provided us with normal weather conditions. After a slightly early course opening, (March 19, typically last week in March) rain dominated the weather scene. In April, we had rain on 11 of the 30 days. In May, we had at least a trace of rain on 13 of the 31 days. In June, weather extremes seem to have become the new norm. Rain days were less often, but rain amounts much larger. When it did rain, it rained in bunches. One late June rain event caused the complete closure of the course for a four -day period, and limited play for another week. High water in the golf course ponds, which also serve as storm water ponds, took a full two weeks to recede. In addition to the impact on play and loss of revenues created by the flooding, over $2,500 was spent to repair the course after the water receded. When it got hot, it got very hot and stayed that way. For August and September alone, we had 10 days where the high temperature was above 90 degrees. Conversely, when it got cool, it got really cool. For a 15 -day stretch in late September and early October, temperatures averaged almost 11 degrees below normal. Also unexpected for 2003, was the $11,340 spent to remove underground fuel tanks and replace them with above ground tanks. These expenditures were not anticipated in the budget. Despite these obstacles, our staffing, purchases and related expenditure reductions have allowed the financial performance of the golf course to remain only slightly behind projections. The net profit for Centerbrook as of 9/30/03 is just over $41,000. For 2004, our financial plan projects reductions in both staffing, purchases and in our anticipated rounds played. Each year between 30,000 and 35,000 rounds of golf are played at Centerbrook. In addition, about 200 people will take lessons. As a result of recent experience, rounds projections for the 2004 budget have been reduced to 30,000. Projections for 2002 and 2003 were 31,500 and 31,000 respectively. 1, along with the rest of our Centerbrook staff, recognize that the golf course's financial performance has been less than satisfactory over the past few years. However, we are confident that, with the budget adjustments we have made, along with normal weather, the results in 2004 will be markedly improved. 1 �✓'� I hope the above information provides you with adequate detail regarding Centerbrook's recent financial history and expectations for 2004. Please let me know if you have questions, or would like additional information. Water Utility Fund 17 City of Brooklyn Center 2004 Budget FUND: Water Utility Fund — 60100 DEPT /ACTIVITY/PROJECT: Operations — 49141 PROFILE This division provides for the distribution of water to customers. Administration and utility billing are also included. The division is managed by the Public Works Director, except for the utility billing component which is managed by the Fiscal Services Department, and has been established as an enterprise fund. The City has 114.98 miles of water main, 1,362 water valves, and 975 fire hydrants providing service to 7,311 metered single - family residential connections and 1,624 metered apartments /townhouses /commercial /industrial customers. 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. This activity involves the production of water and the maintenance of the City's nine wells and three towers, including buildings, chemical feed equipment, and grounds, as well as monitoring the Jordan Aquifer, which is the City's source of water. Water system improvements are made as part of the neighborhood street reconstruction or other improvement projects. Street and Utility Improvements. Substantial water main improvements are generally completed in association with street improvement projects. The 2004 project consists of the Northport Improvement Project and Reconstruction of Shingle Creek Parkway. DEPARTMENTAL GOALS * 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 proactive contract 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 l U 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. * 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. * Maintain accurate calibration of all towers. * Perform, in a cost - effective manner, water system improvements as a part of neighborhood street reconstruction or other improvement projects. * Complete the projects included in the 2004 budget, on time and within budget. * Repair, rehabilitate, or reconstruct water facilities as necessary to provide for efficient and effective operations. EXPENDITURE DETAILS 6204 Stationary Supplies $1,200 Water Utility portion of the cost for billing envelopes. 6216 Chemical Products $78,000 Chemicals are added to City water for disinfection, fluoridation, reduced corrosivity, and to hold the naturally - occurring nuisance mineral manganese in solution. 6219 Operating Supplies $9,500 Materials and supplies, such as chemical feed equipment, pumps, motors and scales to maintain operation of the water system. 6227 Paint Supplies $300 The cost of paint supplies for Gopher State One Call utility locates. 6235 Utility System Supplies $50,000 The cost of routinely replacing water meters. More meters are being systematically replaced, during maintenance calls and in the street and utility improvement project areas. 6239 Repair & Maintenance Supplies $14,250 Various supplies used in the maintenance of the distribution system, such as valve box extensions, gate valves, sensors, and supplies needed for repairing water main breaks. Includes the cost of repair or replacement of mechanical equipment in the pump houses. 6242 Minor Equipment $2,300 Replacement of soil compactor that was included in the 2003 budget as a capital outlay. Purchase was delayed until 2004. Equipment needed to compact excavation trenches after water main repairs. I 6302 Architect, Engineering and Planning $18,300 Assistance in preparing Vulnerability Assessment and Emergency Response Plan and Phase II of the Well -head protection program 5 500 as require ( $6,500) , $ , b p p g ( ) q Y the Minnesota Department of Health and Federal EPA. Includes cost of water system leak survey ($6,300). 6321 Telephone/Pager $445 Includes one on -call pager and one cellular telephone for on -call personnel. 6322 Postage $17,300 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 Svs $1,725 The cost of printing water meter reading cards and Consumer Confidence Reports for all users of City water. 6381 Utility Service- Electric $113,000 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 Svs $15,500 Routine electrical repairs to well pumps and water tower controls. Removal, maintenance service and re- installation of Well No. 7 in 2004. 6441 Licenses, Taxes, and Fees $57,900 State of Minnesota Water Testing Fee, a charge per water connection. The Water Appropriation Permit fee charged by the DNR for the pumping of groundwater from the Jordan Aquifer. Water Operator licensing fees. Increase in this amount reflects increases in the fees charged to the utility by state agencies. �d 6449 Other Contractual Service $40,200 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. PERSONNEL LEVELS 1 Supervisor of Public Utilities 4 Maintenance II 2 Seasonal /Part-Time CAPITAL OUTLAY Item Northport Improvement Project Qty: 1 Unit Cost: $606,900 Less Trade -in: $ -0- Total Cost: $606,900 73` Avenue Project Qty: 1 Unit Cost: $62,800 Less Trade -in: $ -0- Total Cost: $62,800 Shingle Creek Parkway Improvement Project Qty: I Unit Cost: $10,200 Less Trade -in: $ -0- Total Cost: $10,200 R5509BUD BCOOO6V CITY OF BROOKL, ,v CENTER 8/25/2Uua 10:22:30 Fiscal Period: 8 / 03 Budget Report Page - 1 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 60100 WATER UTILITY FUND 491 WATER UTILITY 49141 WATER UTILITY - OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4601 SPECIAL ASSESSMENTS 1,930- 405- 4602 SPECIAL ASSESS - PENALTIES & INT 18,323- 3,409- 3,642- 4603 INTEREST EARNINGS 103,254- 48,416- 30,000- 31- 10,000- 10,000- 4604 CHECK PROCESSING FEES 390- 510- 46- 4605 UNREALIZED INVESTMENT GAINILOS 105,247- 1,340 4606 OTHER REVENUE 31- 100- 20- 4607 SPEC ASSESS INTEREST 17,364- 4600 MISCELLANEOUS REVENUE 229,176 - 68,864- 30,000- 3,739- 10,000- 10,000- 4599 MISCELLANEOUS REVENUE 229,176- 68,864- 30,000- 3,739- 10,000- 10,000- 4700 WATER UTILITY FUND 4701 WATER SALES 1,278,533- 1,066,752- 1,262,500- 614,887- 1,300,000- 1,300,000- 4702 FIRE LINES 8,530 - 18,407- 8,000- 5,270- 8,000- 8,000- 4703 WATER METER SALES 29,886- 16,800- 16,000- 9,490- 15,000- 15,000- 4704 WATER METER RENTALS 3,475- 4,839- 300- 1,288- 500- 500- 4705 SERVICE RESTORATION FEES 180- 300- 300- 60- 300- 300- 4706 CONNECTION CHARGES 5,500- 29,000- 5,500- 8,000- 5,000- 5,000- 4707 PENALTIES 85,998- 93,067- 80,000- 23,293- 80,000- 80,000- 4708 TOWER RENTAL FEES 97,474- 116,501- 100,000- 100,000- 100,000- 4709 CERTIFICATION CHARGES 17,640- 25,680- 15,000- 3,068- 20,000- 20,000- 4700 WATER UTILITY FUND 1,527,215- 1,371,346- 1,487,600- 665,356- 1,528,800- 1,528,800- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 6,686 8,270 740 4900 OTHER FINANCING SOURCES 6,686 8,270 740 4001 REVENUES 1,749,705- 1,431,940- 1,517,600- 668,354- 1,538,800- 1,538,800- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 4) 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 191,560 185,047 224,724 137,323 234,481 234,481 I R5509BUD BCOOO6V CITY OF BROOKL - CENTER 8/25/2Uvd 10:22:30 Fiscal Period: 8 / 03 Budget Report Page - 2 Level Of Rollup 9 2001 2002 2003 8/3112003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code I Description Amount Amount Budget Actual Budget Budget 6102 OVERTIME -FT EMPLOYEES 13,056 14,976 19,000 20,616 24,209 24,209 6103 WAGES -PART TIME EMPLOYEES 13,471 15,284 14,500 6,298 17,220 17,220 6106 WAGES - TEMPORARY EMPLOYEES 936 6100 WAGES AND SALARIES 219,023 215,308 258,224 164,236 275,910 275,910 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 10,665 10,909 14,279 8,733 15,258 15,258 6125 FICA 17,378 14,994 19,754 10,559 17,106 17,106 6126 MEDICARE CONTRIBUTIONS 1,905 2,469 4,001 4,001 6120 RETIREMENT CONTRIBUTIONS 28,043 27,809 34,033 21,761 36,365 36,365 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 21,388 19,024 30,000 18,861 32,754 32,754 6130 INSURANCE BENEFITS 21,388 19,024 30,000 18,861 32,754 32,754 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3,603 4,003 6,220 3,731 7,289 7,289 6150 WORKER'S COMPENSATION 3,603 4,003 6,220 3,731 7,289 7,289 6099 PERSONAL SERVICES 272,058 266,144 328,477 208,589 352,318 352,318 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 193 3,000 42 3,000 3,000 6203 BOOKSIREFERENCE MATERIALS 191 300 300 300 6204 STATIONARY SUPPLIES 1,099 1,200 1,200 6200 OFFICE SUPPLIES 1,099 385 3,300 42 4,500 4,500 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 735 160 315 315 6216 CHEMICALS /CHEMICAL PRODUCTS 2,799 75,000 42,282 78,000 78,000 6217 SAFETY SUPPLIES 1,477 769 2,000 1,685 1,685 6219 GENERAL OPERATING SUPPLIES 4,164 1,406 9,500 3,615 9,200 9,200 6210 OPERATING SUPPLIES 5,641 5,709 86,500 46,056 89,200 89,200 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 3,500 3,200 3,200 6224 STREET MAINT MATERIALS 1,000 622 1,000 1,000 6227 PAINT SUPPLIES 282 452 300 300 [1 6220 REPAIR & MAINT SUPPLIES 282 4,500 1,074 4,500 4,500 V 6230 REPAIR & MAINT SUPPLIES -OTHER R5509BUD BC0006V CITY OF BROOKL , , CENTER 8125/2Vu.5 10:22:30 Fiscal Period: 8 / 03 Budget Report Page - 3 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6235 UTILITY SYSTEM SUPPLIES 48,107 41,968 50,000 12,341 50,000 50,000 6239 OTHER REPAIR & MAINT SUPPLIES 3,521 6,967 14,250 1,403 14,250 14,250 6230 REPAIR & MAINT SUPPLIES -OTHER 51,628 48,935 64,250 13,743 64,250 64,250 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 104 500 43 500 500 6242 MINOR EQUIPMENT 90 1,509 50 7,300 7,300 6240 SMALL TOOLS & MINOR EQUIPMENT 194 1,509 500 93 7,800 7,800 6199 SUPPLIES 58,562 56,819 159,050 61,008 170,250 170,250 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 2,285 798 1,300 1,062 1,500 1,500 6302 ARCH, ENG & PLANNING 25,000 11,738 18,300 18,300 6303 LEGAL SERVICES 113 6307 PROFESSIONAL SERVICES 691 2,036 1,500 1,500 6319 OTHER PROFESSIONAL SERVICES 2,856 6300 PROFESSIONAL SERVICES 5,142 1,489 26,300 14,949 21,300 21,300 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 251 477 350 626 1,200 1,200 6322 POSTAGE 18,119 5,796 19,000 6,450 17,300 17,300 6320 COMMUNICATIONS 18,370 6,274 19,350 7,076 18,500 18,500 6330 TRANSPORTATION 6331 TRAVEL EXPENSE /MILEAGE 70 92 150 8 150 150 6330 TRANSPORTATION 70 92 150 8 150 150 6350 PRINTING AND DUPLICATING 6351 PRINTING 3,408 6,217 4,600 592 1,725 1,725 6350 PRINTING AND DUPLICATING 3,408 6,217 4,600 592 1,725 1,725 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 10,556 9,579 12,000 8,863 8,804 8,804 6362 PROPERTY INSURANCE 965 1,033 1,000 1,445 1,596 1,596 6366 MACHINERY BREAKDOWN INSURANCE 221 239 275 377 428 428 6360 INSURANCE 11,742 10,851 13,275 10,685 10,828 10,828 6380 UTILITY SERVICES 6381 ELECTRIC 100,000 52,664 115,000 115,000 s R5509BUD BC0006V CITY OF BROOKL - CENTER 8/25/2uua 10:22:30 Fiscal Period: 8 / 03 Budget Report Page - 4 Level Of Rollup 9 2001 2002 2003 8/3112003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6382 GAS 5,000 5,514 7,200 7,200 6385 SEWER 210 162 210 210 6386 STORM SEWER 4,700 3,758 4,700 4,700 6388 HAZARDOUS WASTE DISPOSAL 1,000 1,000 6389 STREET LIGHTS 1,000 641 1,000 1,000 6380 UTILITY SERVICES 110,910 62,738 129,110 129,110 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 147 18,500 2,074 15,500 15,500 6403 BLDGS /FACILITIES MAINT SERVICE 9,688 6405 PARK & LANDSCAPE SERVICES 310 6408 COMMUNICATION /INFO SYSTEMS 729 552 850 552 750 750 6409 OTHER REPAIR & MAINT SVCS 102- 460 4,600 4,600 4,600 6417 UNIFORMS 46 354 650 650 6400 REPAIR & MAINT SERVICES 937 1,204 23,950 12,667 21,500 21,500 6420 IS SERVICES/LICENSES /FEES 6423 LOGIS CHARGES 27,220 28,566 27,686 10,445 22,865 22,865 6420 IS SERVICES/LICENSES /FEES 27,220 28,566 27,686 10,445 22,865 22,865 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,542 1,947 2,200 685 2,150 2,150 6434 DUES & SUBSCRIPTIONS 1,521 432 1,600 1,528 1,550 1,550 6436 UNCOLLECTIBLE CHECKS /DEBTS 104- 89- 6438 CASH SHORT (OVER) 6430 MISCELLANEOUS 2,959 2,290 3,800 2,213 3,700 3,700 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 46,243 47,555 55,200 29,326 58,900 58,900 6449 OTHER CONTRACTUAL SERVICE 27,861 26,778 39,000 23,993 29,700 29,700 6440 OTHER EXPENSES 74,104 74,333 94,200 53,319 88,600 88,600 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 2,711 2,116 2,247 1,371 2,504 2,504 6462 FIXED CHARGES 15,501 23,100 22,023 12,505 23,793 23,793 6463 REPAIR & MAINT CHARGES 23,149 8,198 16,009 3,601 15,370 15,370 6465 REPLACEMENT CHARGES 13,786 ^ 6460 CENTRAL GARAGE CHARGES 55,147 33,414 40,279 17,477 41,667 41,667 rL/ 6470 TRANSFERS AND OTHER USES R5509BUD BC0006V CITY OF BROOKLi,� CENTER 8/25/2Vuo 10:22:30 Fiscal Period: 8 / 03 Budget Report Page - 5 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6471 ADMINISTRATIVE SERVICE TRANSFE 136,853 140,104 61,055 40,703 6476 CAPITAL PROJECT FUND TRANSFER 170,500 6470 TRANSFERS AND OTHER USES 307,353 140,104 61,055 40,703 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 414,966 4,286,914 588,100 578,000 578,000 6494.1 ASSET THRESHOLD CHANGE EXPENSE 1,614,746 6494 DEPRECIATION EXPENSE 414,966 5,901,660 588,100 578,000 578,000 6499 EXPENSES REIMBURSED 11,629 685,900 685,900 6490 OTHER MISC COSTS /EXPENSES 414,966 5,901,660 588,100 11,629 1,263,900 1,263,900 6299 OTHER CHARGES & SERVICES 921,417 6,206,494 1,013,655 244,501 1,623,845 1,623,845 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 607,300 88,522 6540 EQUIPMENT & MACHINERY 2,250 6580 INFORMATION SYSTEMS 58,000 1,055 6501 CAPITAL OUTLAY 667,550 89,578 6500 CAPITAL OUTLAY 667,550 89,578 6600 DEBT SERVICE 6612 OTHER DEBT - INTEREST 3 6600 DEBT SERVICE 3 6001 EXPENDITURES /EXPENSES 1,252,036 6,529,457 2,168,732 603,679 2,146,413 2,146,413 4000 REVENUES AND EXPENSES 497,669- 5,097,517 651,132 64,675- 607,613 607,613 49141 WATER UTILITY- OPERATIONS 497,669- 5,097,517 651,132 64,675- 607,613 607,613 49142 WATER UTILITY- FACILITIES 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 23,817 29,805 l 6102 OVERTIME -FT EMPLOYEES 8,745 8,585 6103 WAGES -PART TIME EMPLOYEES 229 560 v R5509BUD BCOOO6V CITY OF BROOKLi,. ;ENTER 8/2512 (jv. 10:22:30 Fiscal Period: 8 / 03 Budget Report Page - 6 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6100 WAGES AND SALARIES 32,792 38,950 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 1,660 2,096 6125 FICA 2,672 2,867 6126 MEDICARE CONTRIBUTIONS 188 6120 RETIREMENT CONTRIBUTIONS 4,332 5,151 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 5,423 7,548 6130 INSURANCE BENEFITS 5,423 7,548 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 567 775 6150 WORKER'S COMPENSATION 567 775 6099 PERSONAL SERVICES 43,114 52,423 6199 SUPPLIES 6210 OPERATING SUPPLIES 6216 CHEMICALS /CHEMICAL PRODUCTS 74,787 57,891 6219 GENERAL OPERATING SUPPLIES 3,871 1,079 6210 OPERATING SUPPLIES 78,659 58,970 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 749 6227 PAINT SUPPLIES 180 6220 REPAIR & MAINT SUPPLIES 749 180 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 5,027 12,839 6230 REPAIR & MAINT SUPPLIES -OTHER 5,027 12,839 6199 SUPPLIES 84,435 71,989 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6380 UTILITY SERVICES 6381 ELECTRIC 116,826 90,723 6382 GAS 7,384 4,951 n ' 6385 SEWER 200 210 VJ 6386 STORM SEWER 4,365 4,862 "� 6389 STREET LIGHTS 846 R5509BUD BCOOO6V CITY OF BROOKL CENTER 8/25/2U Fiscal Period: 8 / 03 Budget Report Page - 7 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6380 UTILITY SERVICES 128,774 101,591 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 485 710 6409 OTHER REPAIR & MAINT SVCS 672 7,635 6400 REPAIR & MAINT SERVICES 1,157 8,345 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 6,152 6,026 6449 OTHER CONTRACTUAL SERVICE 17,399 2,270 6440 OTHER EXPENSES 23,551 8,297 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 6299 OTHER CHARGES & SERVICES 153,483 118,233 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 10,742 3,098 6501 CAPITAL OUTLAY 10,742 3,098 6500 CAPITAL OUTLAY 10,742 3,098 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 291,773 245,743 I � 49142 WATER UTILITY- FACILITIES 291,773 245,743 49143 WATER UTILITY- CONSTRUCTION 4921 REFUNDS & REIMBURSEMENTS 1,000- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 521 6102 OVERTIME -FT EMPLOYEES 41 6100 WAGES AND SALARIES 562 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 29 6125 FICA 40 A R5509BUD BCOOO6V CITY OF BROOKL i . CENTER 8/25/2Ur 10:22:30 Fiscal Period: 8 / 03 Budget Report Page - 8 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6120 RETIREMENT CONTRIBUTIONS 69 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3 6150 WORKER'S COMPENSATION 3 6099 PERSONAL SERVICES 634 6199 SUPPLIES 6210 OPERATING SUPPLIES 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 79- 6319 OTHER PROFESSIONAL SERVICES 79 79- 6300 PROFESSIONAL SERVICES 79 157- 6470 TRANSFERS AND OTHER USES 6299 OTHER CHARGES & SERVICES 79 157- 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 79- 79 6501 CAPITAL OUTLAY 79- 79 6500 CAPITAL OUTLAY 79- 79 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 634 79- 49143 WATER UTILITY- CONSTRUCTION 634 1,079- 60100 WATER UTILITY FUND 491 WATER UTILITY 205,262- 5,342,182 651,132 64,675- 607,613 607,613 60100 WATER UTILITY FUND 205,262- 5,342,182 651,132 64,675- 607,613 607,613 Sewer Utility Fund �a City of (Brooklyn Center 2003 Budget FUND: Sanitary Sewer Utility Fund — 60200 DEPT /ACTIVITY/PROJECT: Operations — 49251 PROFILE This division provides for the collection and pumping of sanitary sewage through a system of mains and lift stations. Sewage is treated by the Met Council of Environmental Services, whose fees account for approximately 75% of this fund's expenditures. Administration and utility billing are also included. This division is managed by the Public Works Director, except for the utility billing component which is managed by the Fiscal Services Department, and has been established as an enterprise fund. The City has approximately 105.51 miles of sanitary sewer ranging in size from 8" to 24" in diameter, and 8,774 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. The utility billing operation prepares and sends out utility bills. This activity involves the operation and maintenance of the City's ten waste water lift stations, which includes buildings, equipment, and property. Sewer system improvements are made as part of the neighborhood street reconstruction or other improvement projects. Street and UtWl Improvements. Substantial sanitary sewer main improvements are generally completed in association with street improvement projects. In the Northport neighborhood project, it is expected that nearly all main would be replaced. Other Improvements. The control cabinets and electronic controls would be replaced in 2004 at lift stations 6 and 7, in the second year of a three -year program to update this equipment. Completion of the project to stabilization of the Mississippi River Bank, north of the freeway, in order to protect the sanitary sewer interceptor that runs from 66`" Avenue to 67 Avenue north. The City has been working with the Army Corps of Engineers on the project. 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 of approximately 20 miles of main every year. • 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 and take necessary action to reduce or eliminate. • 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. • Complete the projects included in the 2004 budget on time and within budget. • Repair, rehabilitate, or reconstruct sanitary sewer facilities as necessary to provide for efficient and effective operations. EXPENDITURE DETAILS 6216 Chemical Products $5,000 Degreaser and root destroyer used at lift stations. 6219 Operating Supplies $10,000 Marking paint, marking flags, sewer jet parts, blades, motors, etc. Includes $1,900 to purchase a replacement sewer jet hose. 6239 Other Repair & Maintenance Supplies $3,000 The cost of check valves, sump pumps, floats, float switch controls, etc. 6381 Utility Services- Electric $26,000 The cost of operating lift station pumps. 6391 Met Council Environmental Services $1,440,000 Charges by the Metropolitan Council Environmental Services for processing the City's sewage. 6403 Repair and Maintenance Svs- Buildings and Facilities Maint Svs $3,600 Routine electrical repairs to lift stations. 6409 Repair and Maintenance Svs -Other $80,000 Replace lift station cabinets as part of ongoing/recurring maintenance program for all lift stations in the City. 7 6449 Other Contractual Service $92,500 Routine oxygen sensor calibration, gas monitor maintenance, inspection of lift station pumps, generator load banking, etc. Generally, specialized contractual services such as pump rewinding. There are several sewer lines that are part of the system that require repair and/or service. This is part of an ongoing maintenance issue and not an item that should be included as part of the CIP. The line on Kyle Avenue has been cause for concern for several years. It has not given rise to any claims for sewer backup damages from residents. However, it is simply a matter of time before this line is a major issue based on the most recent televising of the line. It is severely damaged and needs replacement. The estimated cost is $65,000. A second line that has been the subject of at least two insurance claims for backup sewer damage to residences in the Camden area should be replaced. The cost to replace this segment of the damaged line is $15,000. PERSONNEL LEVELS 2 Maintenance II Seasonal /Part-Time CAPITAL OUTLAY Item Happy Hollow Neighborhood Project Qty: 1 Unit Cost: $373,440 Less Trade -in: $ -0- Total Cost: $373,440 Riverbank Stabilization Project Qty: 1 Unit Cost: $100,000 Less Trade -in: $ -0- Total Cost: $100,000 73` Avenue Project Qty: 1 Unit Cost: $58,350 Less Trade -in: $ -0- Total Cost: $58,350 TH # 100 Utility Movement Qty: 1 Unit Cost: $100,000 Less Trade -in: $ -09- Total Cost: $100,000 Computer Qty: 1 Unit Cost: $1,600 Less Trade -in: $ -0- Total Cost: $1,600 R5509BUD SC0006V CITY OF BROOKL,.. CENTER 8/25/2 ,,,, 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 1 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 60200 SEWER UTILITY FUND 492 SEWER UTILITY 49251 SEWER UTILITY - OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4310 FEDERAL REVENUE 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4602 SPECIAL ASSESS - PENALTIES & INT 3- 4603 INTEREST EARNINGS 43,897- 30,000- 10,000- 10,000- 4605 UNREALIZED INVESTMENT GAINILOS 1,218 4606 OTHER REVENUE 800- 100- 27,375- 4607 SPEC ASSESS INTEREST 268- 4600 MISCELLANEOUS REVENUE 800- 43,050- 30,000- 27,375- 10,000- 10,000- 4599 MISCELLANEOUS REVENUE 800- 43,050- 30,000- 27,375- 10,000- 10,000- 4720 SEWER UTILITY FUND 4721 SEWER SERVICE 2,646,631- 2,725,380- 1,590,398- 2,804,760- 2,804,760- 4726 CONNECTION CHARGES 15,000- 4,000- 4921 REFUNDS & REIMBURSEMENTS 2,273 4720 SEWER UTILITY FUND 2,661,631- 2,725,380- 1,592,124- 2,804,760- 2,804,760- 4001 REVENUES 800- 2,704,681- 2,755,380- 1,619,500- 2,814,760- 2,814,760- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 63,296 72,631 79,952 45,772 90,710 90,710 6102 OVERTIME -FT EMPLOYEES 9,109 8,457 9,000 5,703 18,900 18,900 6103 WAGES -PART TIME EMPLOYEES 221 1,666 4,700 5,253 5,740 5,740 6106 WAGES - TEMPORARY EMPLOYEES 937 6100 WAGES AND SALARIES 73,562 82,754 93,652 56,729 115,350 115,350 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 3,722 4,468 5,179 2,846 6,379 6,379 6125 FICA 5,581 5,775 7,164 3,595 7,152 7,152 6126 MEDICARE CONTRIBUTIONS 585 841 1,672 1,672 6120 RETIREMENT CONTRIBUTIONS 9,303 10,829 12,343 7,282 15,203 15,203 R5509BUD BC0006V CITY OF BROOKL,..;ENTER 8/25/2u,,,, 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 2 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 5,423 5,844 12,000 8,271 14,214 14,214 6130 INSURANCE BENEFITS 5,423 5,844 12,000 8,271 14,214 14,214 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 1,020 1,282 2,268 1,534 3,375 3,375 6150 WORKER'S COMPENSATION 1,020 1,282 2,268 1,534 3,375 3,375 6099 PERSONAL SERVICES 89,308 100,709 120,263 73,816 148,142 148,142 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 174 17 500 77 100 100 6203 BOOKS /REFERENCE MATERIALS 56 100 200 200 6204 STATIONARY SUPPLIES 731 1,200 1,200 6200 OFFICE SUPPLIES 961 17 600 77 1,500 1,500 6210 OPERATING SUPPLIES 6214 CLOTHING & PERSONAL EQUIPMENT 315 315 6216 CHEMICALS /CHEMICAL PRODUCTS 5,000 3,000 3,000 6217 SAFETY SUPPLIES 65 469 1,000 1,200 1,200 6219 GENERAL OPERATING SUPPLIES 4,321 6,440 10,000 598 3,000 3,000 6210 OPERATING SUPPLIES 4,386 6,909 16,000 598 7,515 7,515 6220 REPAIR & MAINT SUPPLIES 6227 PAINT SUPPLIES 242 300 300 6220 REPAIR & MAINT SUPPLIES 242 300 300 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 1,763 3,000 3,110 7,500 7,500 6230 REPAIR & MAINT SUPPLIES -OTHER 1,763 3,000 3,110 7,500 7,500 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 266 112 500 500 500 6242 MINOR EQUIPMENT 90 50 6240 SMALL TOOLS & MINOR EQUIPMENT 356 112 500 50 500 500 6199 SUPPLIES 7,466 7,038 20,100 4,077 17,315 17,315 6299 OTHER CHARGES & SERVICES R5509BUD BC0006V CITY OF BROOKL , .. ;ENTER 8/25/21,,,,, 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 3 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 1,673 1,495 1,300 1,062 1,500 1,500 6303 LEGAL SERVICES 81 6307 PROFESSIONAL SERVICES 817 500 1,487 4,700 4,700 6319 OTHER PROFESSIONAL SERVICES 500 6300 PROFESSIONAL SERVICES 2,173 2,312 1,800 2,631 6,200 6,200 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 251 11 1,850 243 1,680 1,680 6322 POSTAGE 5,470 10,858 5,500 6,140 4,700 4,700 6320 COMMUNICATIONS 5,720 10,869 7,350 6,383 6,380 6,380 6330 TRANSPORTATION 6331 TRAVEL EXPENSE /MILEAGE 5 15 6342 LEGAL NOTICES 213 6330 TRANSPORTATION 5 228 6350 PRINTING AND DUPLICATING 6351 PRINTING 491 3,474 351 6350 PRINTING AND DUPLICATING 491 3,474 351 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 6,863 4,314 7,630 4,210 4,612 4,612 6362 PROPERTY INSURANCE 289 320 330 382 400 400 6366 MACHINERY BREAKDOWN INSURANCE 66 71 90 115 131 131 6360 INSURANCE 7,218 4,705 8,050 4,707 5,143 5,143 6380 UTILITY SERVICES 6381 ELECTRIC 21,487 26,000 13,451 25,600 25,600 6380 UTILITY SERVICES 21,487 26,000 13,451 25,600 25,600 6390 CONTRACT UTILITY SERVICES 6391 MET COUNCIL ENVIRON SVCS 1,377,544 1,418,614 1,440,000 851,583 1,494,000 1,494,000 6390 CONTRACT UTILITY SERVICES 1,377,544 1,418,614 1,440,000 851,583 1,494,000 1,494,000 6400 REPAIR & MAINT SERVICES 6403 BLDGS /FACILITIES MAINT SERVICE 140 3,600 5,741 4,000 4,000 6408 COMMUNICATION /INFO SYSTEMS 516 552 500 552 560 560 6409 OTHER REPAIR & MAINT SVCS 555 80,000 3,362 82,000 82,000 6400 REPAIR & MAINT SERVICES 516 1,247 84,100 9,655 86,560 86,560 R5509BUD SCOOO6V CITY OF BROOKL ... CENTER 8/25/2 ,,.. 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 4 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6420 IS SERVICES /LICENSES/FEES 6423 LOGIS CHARGES 27,314 28,527 27,686 15,715 22,865 22,865 6432 CONFERENCES AND SCHOOLS 863 1,300 1,200 960 1,310 1,310 6420 IS SERVICES /LICENSES /FEES 28,177 29,827 28,886 16,675 24,175 24,175 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 2 125 71 100 100 6449 OTHER CONTRACTUAL SERVICE 2,065 1,569 92,500 3,365 23,600 23,600 6440 OTHER EXPENSES 2,065 1,571 92,625 3,435 23,700 23,700 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 8,329 7,347 8,204 4,351 8,680 8,680 6462 FIXED CHARGES 34,116 35,679 39,882 22,328 36,750 36,750 6463 REPAIR & MAINT CHARGES 21,728 27,485 22,736 12,777 25,210 25,210 6460 CENTRAL GARAGE CHARGES 64,173 70,512 70,822 39,455 70,640 70,640 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 91,236 93,402 106,014 70,676 6470 TRANSFERS AND OTHER USES 91,236 93,402 106,014 70,676 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 3,269,105 432,100 458,000 458,000 6494.1 ASSET THRESHOLD CHANGE EXPENSE 388,897 6494 DEPRECIATION EXPENSE 3,658,002 432,100 458,000 458,000 6499 EXPENSES REIMBURSED 68,396 639,500 639,500 6490 OTHER MISC COSTS /EXPENSES 3,658,002 432,100 68,396 1,097,500 1,097,500 6299 OTHER CHARGES & SERVICES 1,579,318 5,316,021 2,297,747 1,087,627 2,839,898 2,839,898 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 631,790 54,256 6580 INFORMATION SYSTEMS 1,600 1,055 6501 CAPITAL OUTLAY 633,390 55,312 6500 CAPITAL OUTLAY 633,390 55,312 4 6600 DEBT SERVICE R5509BUD BC0006V CITY OF BROOKL , .. CENTER 8/25/2,... 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 5 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6612 OTHER DEBT - INTEREST 3 6600 DEBT SERVICE 3 6001 EXPENDITURES /EXPENSES 1,676,092 5,423,768 3,071,500 1,220,834 3,005,355 3,005,355 4000 REVENUES AND EXPENSES 1,675,292 2,719,087 316,120 398,666- 190,595 190,595 49251 SEWER UTILITY- OPERATIONS 1,675,292 2,719,087 316,120 398,666- 190,595 190,595 49252 SEWER UTILITY- FACILITIES 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4602 SPECIAL ASSESS - PENALTIES & INT 289- 4603 INTEREST EARNINGS 59,238- 4605 UNREALIZED INVESTMENT GAINILOS 73,948- 4600 MISCELLANEOUS REVENUE 133,475- 4599 MISCELLANEOUS REVENUE 133,475- 4720 SEWER UTILITY FUND 4721 SEWER SERVICE 2,604,199- 4720 SEWER UTILITY FUND 2,604,199- 4001 REVENUES 2,737,674- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 20,943 23,190 6102 OVERTIME -FT EMPLOYEES 12,572 14,384 6103 WAGES -PART TIME EMPLOYEES 350 964 6100 WAGES AND SALARIES 33,865 38,538 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 1,684 2,030 6125 FICA 2,733 2,767 6126 MEDICARE CONTRIBUTIONS 274 IL 6120 RETIREMENT CONTRIBUTIONS 4,417 5,071 R5509BUD BCOOO6V CITY OFBROOKLi,..;ENTER 8/25/21,.,., 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 6 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 5,423 5,844 6130 INSURANCE BENEFITS 5,423 5,844 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 557 728 6150 WORKER'S COMPENSATION 557 728 6099 PERSONAL SERVICES 44,262 50,180 6199 SUPPLIES 6200 OFFICE SUPPLIES 6210 OPERATING SUPPLIES 6216 CHEMICALS /CHEMICAL PRODUCTS 4,534 4,507 6219 GENERAL OPERATING SUPPLIES 3,108 6210 OPERATING SUPPLIES 7,642 4,507 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 14 6220 REPAIR & MAINT SUPPLIES 14 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 1,225 2,630 6230 REPAIR & MAINT SUPPLIES -OTHER 1,225 2,630 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES 8,867 7,152 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 1,323 270 6320 COMMUNICATIONS 1,323 270 6330 TRANSPORTATION r 6350 PRINTING AND DUPLICATING R5509BUD BCOOO6V CITY OFBROOKL,.. ;ENTER 8/25/2u- 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 7 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6360 INSURANCE 6380 UTILITY SERVICES 6381 ELECTRIC 26,766 2,242 6380 UTILITY SERVICES 26,766 2,242 6390 CONTRACT UTILITY SERVICES 6400 REPAIR & MAINT SERVICES 6409 OTHER REPAIR & MAINT SVCS 903 16,705 6400 REPAIR & MAINT SERVICES 903 16,705 6420 IS SERVICES /LICENSES /FEES 6430 MISCELLANEOUS 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 16,717 121,455 6440 OTHER EXPENSES 16,717 121,455 6460 CENTRAL GARAGE CHARGES 6470 TRANSFERS AND OTHER USES 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 239,381 6494 DEPRECIATION EXPENSE 239,381 6490 OTHER MISC COSTS /EXPENSES 239,381 6299 OTHER CHARGES & SERVICES 285,089 140,671 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 338,218 198,003 R5509BUD BC0006V CITY OF BROOKL , .. CENTER 8/25/2. 10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 8 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code ! Description Amount Amount Budget Actual Budget Budget 4000 REVENUES AND EXPENSES 2,399,455- 198,003 49252 SEWER UTILITY- FACILITIES 2,399,455- 198,003 49253 SEWER UTILITY- CONSTRUCT 4921 REFUNDS & REIMBURSEMENTS 3,000- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 2,233 6103 WAGES -PART TIME EMPLOYEES 92 6100 WAGES AND SALARIES 2,325 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 116 6125 FICA 176 6120 RETIREMENT CONTRIBUTIONS 292 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 13 6150 WORKER'S COMPENSATION 13 6099 PERSONAL SERVICES 2,630 6199 SUPPLIES 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 149 6210 OPERATING SUPPLIES 149 6199 SUPPLIES 149 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 12,532 6300 PROFESSIONAL SERVICES 12,532 6470 TRANSFERS AND OTHER USES 6480 GENERAL FUND REIMBURSEMENT 315 6499 EXPENSES REIMBURSED 8,634 6470 TRANSFERS AND OTHER USES 8,949 6299 OTHER CHARGES & SERVICES 21,482 V R5509BUD BCOOO6V CITY OFBROOKL,,.CENTER 8/25/2,,- .10:23:02 Fiscal Period: 8 / 03 Budget Report Page - 9 Level Of Rollup 9 2001 2002 2003 8131/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 2,630 21,630 49253 SEWER UTILITY- CONSTRUCT 2,630 18,630 60200 SEWER UTILITY FUND 492 SEWER UTILITY 721,533- 2,935,721 316,120 398,666- 190,595 190,595 60200 SEWER UTILITY FUND 721,533- 2,935,721 316,120 398,666- 190,595 190,595 P Storm Sewer Utility Fund us City of B rookCyn Center 2003 (Budget FUND: Storm Sewer Utility Fund - 65100 DEPT /ACTIVITY/PROJECT: Operations - 49411 PROFILE This division provides for the collection of stormwater throughout the city. Stormwater is either conveyed to a regional or neighborhood treatment facility such as a pond and then outletted to a surface water, or it is conveyed directly to the surface water. The division is managed by the Public Works Director. The City has 84 miles of storm sewers and nine neighborhood or regional pond or treatment systems. Included in this division is the inspection and maintenance of all structures and lines, preventative maintenance, reimbursement for street sweeping services provided by the street maintenance division, and inspection of private stormwater treatment systems. Also included is 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 * Televise all lines in next year's construction projects and approximately an additional 2,000 feet of trouble spots and the next area of scheduled cleaning. * Repair structures (approximately 30 to 40 per year) that are in need of repair or rebuilding now and scheduled cycle of repair. * Clean 8,000 feet of storm sewer lines of sand, debris and roots. * Clean outfalls, skimmers, and ponds as needed. * Inspect public and private ponds and treatment systems. EXPENDITURE DETAILS 6239 Repair and Maintenance Supplies -Other $20,000 Provides for supplies when city employees perform the maintenance and repairs on system structures and facilities as part of ongoing maintenance items. 6409 Repair and Maintenance Svs -Other $12,000 Provides for repair services on the Shingle Creek weir as part of the ongoing maintenance in this area. Additional amounts are provided for unscheduled maintenance as issues and problems arise in and along the system. 6413 Dues & Subscriptions $44,464 Annual dues of the Shingle Creek and West Mississippi Watershed Management Organizations. u �P PERSONNEL LEVELS No personnel are currently assigned to this utility. Work is currently done by street maintenance and utility maintenance personnel and is reimbursed through an administrative transfer. CAPITAL OUTLAY Item Happy Hollow Neighborhood Project Qty: 1 Unit Cost: $253,255 Less Trade -in: $ -0- Total Cost: $253,255 Twin Lakes Study Qty: 1 Unit Cost: $65,000 Less Trade -in: $ -0- Total Cost: $65,000 73` Avenue Project Qty: 1 Unit Cost: $42,350 Less Trade -in: $ -0- Total Cost: $42,350 TH #100 Utility Movement Qty: 1 Unit Cost: $50,000 Less Trade -in: $ -0- Total Cost: $50,000 K� R5509BUD BCOOO6V CITY OF BROOKL ... CENTER 8/25/2,,,., 10:23:49 Fiscal Period: 8 / 03 Budget Report Page - 1 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 65100 STORM SEWER UTILITY FUND 494 STORM SEWER UTILITY 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 4601 SPECIAL ASSESSMENTS 268,794- 428,460- 4602 SPECIAL ASSESS - PENALTIES & INT 1,570- 27- 17- 4603 INTEREST EARNINGS 5,837- 10,000- 10,000- 10,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 10,375- 162 4606 OTHER REVENUE 12,405- 4607 SPEC ASSESS INTEREST 1,386- 4600 MISCELLANEOUS REVENUE 280,739- 435,548- 10,000- 12,422- 10,000- 10,000- 4599 MISCELLANEOUS REVENUE 280,739- 435,548- 10,000- 12,422- 10,000- 10,000- 4730 STORM SEWER UTILITY FUND 4731 STORM DRAINAGE FEES 1,129,502- 1,223,644- 1,235,000- 751,336- 1,274,000- 1,274,000- 4730 STORM SEWER UTILITY FUND 1,129,502- 1,223,644- 1,235,000- 751,336- 1,274,000- 1,274,000- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 150,994- 1,030 4900 OTHER FINANCING SOURCES 150,994- 1,030 4001 REVENUES 1,410,241- 1,810,186- 1,245,000- 762,728- 1,284,000- 1,284,000- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 14,339 14,339 6103 WAGES -PART TIME EMPLOYEES 547 6100 WAGES AND SALARIES 547 14,339 14,339 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 793 793 cA R5509BUD BC0006V CITY OF BROOKL ... CENTER 8/25/2,.,, 10:23:49 Fiscal Period: 8 / 03 Budget Report Page - 2 Level Of Rollup 9 2001 2002 2003 8131/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6125 FICA 42 889 889 6126 MEDICARE CONTRIBUTIONS 208 208 6120 RETIREMENT CONTRIBUTIONS 42 1,890 1,890 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 2,472 2,472 6130 INSURANCE BENEFITS 2,472 2,472 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3 197 197 6150 WORKER'S COMPENSATION 3 197 197 6099 PERSONAL SERVICES 592 18,898 18,898 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 35 430 430 6203 BOOKS /REFERENCE MATERIALS 3,000 6200 OFFICE SUPPLIES 3,000 35 430 430 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 153 500 500 500 6239 OTHER REPAIR & MAINT SUPPLIES 20,000 1,935 20,000 20,000 6210 OPERATING SUPPLIES 153 20,500 1,935 20,500 20,500 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES 3,153 20,500 1,971 20,930 20,930 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 110 676 100 500 500 6302 ARCH, ENG & PLANNING 7,000 34,799 6303 LEGAL SERVICES 638 6307 PROFESSIONAL SERVICES 369 619 500 500 6300 PROFESSIONAL SERVICES 110 1,045 7,000 36,155 1,000 1,000 6320 COMMUNICATIONS 6322 POSTAGE 4,906 2,423 1,700 1,700 6320 COMMUNICATIONS 4,906 2,423 1,700 1,700 R5509BUD BCOOO6V CITY OF BROOKL , .. CENTER 8125/2u -- 10:23:49 Fiscal Period: 8 / 03 Budget Report Page - 3 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6330 TRANSPORTATION 6331 TRAVEL EXPENSE /MILEAGE 7 6330 TRANSPORTATION 7 6350 PRINTING AND DUPLICATING 6351 PRINTING 1,570 159 6350 PRINTING AND DUPLICATING 1,570 159 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 3,604 1,932 3,500 1,569 1,730 1,730 6360 INSURANCE 3,604 1,932 3,500 1,569 1,730 1,730 6400 REPAIR & MAINT SERVICES 6409 OTHER REPAIR & MAINT SVCS 10,000 12,000 905 12,000 12,000 6400 REPAIR & MAINT SERVICES 10,000 12,000 905 12,000 12,000 6420 IS SERVICES/LICENSES /FEES 6423 LOGIS CHARGES 5,259 6420 IS SERVICES /LICENSES /FEES 5,259 6430 MISCELLANEOUS 6434 DUES & SUBSCRIPTIONS 29,667 30,249 42,700 42,689 44,464 44,464 6430 MISCELLANEOUS 29,667 30,249 42,700 42,689 44,464 44,464 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 391 281 290 290 6440 OTHER EXPENSES 391 281 290 290 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 2,033 1,850 1,880 974 2,239 2,239 6462 FIXED CHARGES 14,991 13,931 14,740 7,745 14,350 14,350 6463 REPAIR & MAINT CHARGES 5,887 4,723 7,130 2,020 5,240 5,240 6460 CENTRAL GARAGE CHARGES 22,910 20,504 23,750 10,739 21,829 21,829 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 147,534 31,689 6473 STORM SEWER TRANSFER 100,000 100,000 66,667 6482 MISC TRANSFER OUT 35,000 6494 DEPRECIATION EXPENSE 170,302 474,574 326,600 514,000 514,000 6494.1 ASSET THRESHOLD CHANGE EXPENSE 270,059 R5509BUD BCOOO6V CITY OF BROOKL , .. CENTER 8/25/2u- 10:23:49 Fiscal Period: 8 / 03 Budget Report Page - 4 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6494 DEPRECIATION EXPENSE 170,302 744,633 326,600 514,000 514,000 6499 EXPENSES REIMBURSED 29,913 510,700 510,700 6470 TRANSFERS AND OTHER USES 305,302 844,633 474,134 128,269 1,024,700 1,024,700 6299 OTHER CHARGES & SERVICES 361,593 915,229 563,084 228,456 1,107,713 1,107,713 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 410,785 6580 INFORMATION SYSTEMS 300- 6501 CAPITAL OUTLAY 300- 410,785 6500 CAPITAL OUTLAY 300- 410,785 6600 DEBT SERVICE 6601 BOND PRINCIPAL 210,000 210,000 6611 BOND INTEREST 52,416 35,850 28,790 14,957 6621 PAYING AGENT /OTHER FEES 750 851 750 845 6600 DEBT SERVICE 53,166 36,701 239,540 225,801 6001 EXPENDITURES /EXPENSES 415,051 955,082 1,233,909 456,227 1,147,541 1,147,541 4000 REVENUES AND EXPENSES 995,191- 855,103- 11,091- 306,500- 136,459- 136,459- 49411 STORM SEWER UTILITY- OPERATIONS 995,191- 855,103- 11,091- 306,500- 136,459- 136,459- 49412 STORM SEWER UTILITY- FACILITIES 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6199 SUPPLIES 6299 OTHER CHARGES & SERVICES 6490 OTHER MISC COSTS /EXPENSES 6600 DEBT SERVICE 49413 STORM SEWER UTILITY- CONSTRUCT 4921 REFUNDS & REIMBURSEMENTS 3,000- 6001 EXPENDITURES /EXPENSES R5509BUD BC0006V CITY OF BROOKL , .. CENTER 8/25/2,... 10:23:49 Fiscal Period: 8 / 03 Budget Report Page - 5 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 262 6100 WAGES AND SALARIES 262 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 14 6125 FICA 20 6120 RETIREMENT CONTRIBUTIONS 34 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 6 6150 WORKER'S COMPENSATION 6 6099 PERSONAL SERVICES 301 6199 SUPPLIES 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 31,887 6300 PROFESSIONAL SERVICES 31,887 6320 COMMUNICATIONS 6350 PRINTING AND DUPLICATING 6411 LAND 8,500 6350 PRINTING AND DUPLICATING 8,500 6470 TRANSFERS AND OTHER USES 6480 GENERAL FUND REIMBURSEMENT 454 6499 EXPENSES REIMBURSED 3,595 6470 TRANSFERS AND OTHER USES 4,050 6299 OTHER CHARGES & SERVICES 44,437 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 227 13,556 6501 CAPITAL OUTLAY 227 13,556 6500 CAPITAL OUTLAY 227 13,556 Y R5509BUD BCOOO6V CITY OF BROOKL , .. CENTER 8/2512,,., 10:23:49 Fiscal Period: 8 / 03 Budget Report Page - 6 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6600 DEBT SERVICE 6001 EXPENDITURES /EXPENSES 528 57,993 49413 STORM SEWER UTILITY - CONSTRUCT 528 54,993 65100 STORM SEWER UTILITY FUND 494 STORM SEWER UTILITY 994,662- 800,111- 11,091- 306,500- 136,459- 136,459- 65100 STORM SEWER UTILITY FUND 994,662- 800,111- 11,091- 306,500- 136,459- 136,459- . I A Street Light Utility Fund rr i City of (Brooklyn Center 2003 Budget FUND: Street Light Utility Fund - 65200 DEPT /ACTIVITY/PROJECT: Street Lights - 49571 PROFILE This division provides primarily for electrical and maintenance fees paid to NSP for street lights owned by NSP. It also provides for electrical service, maintenance, repair, and replacement of lights owned by the City. The City owns approximately 75 ornamental lights, primarily in the Earle Brown commercial area, 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 * The City's street light policy provides for at least one street light per intersection and at curves and major driveway entrances. Mid -block street lights are installed by petition when the distance between intersections is greater than 700 feet. EXPENDITURE DETAILS 6239 Repair and Maintenance Supplies -Other $2,500 Provides for maintenance supplies for City owned and operated street lights in and along the Earle Brown Center, Brooklyn Blvd and intersection lighting at those intersections with semaphores. These are not Excel responsibilities under the current maintenance contract. 6381 Utility Service- Electric $140,000 Electric utility costs for street lights. 6409 Repair and Maintenance Svs -Other $5,000 Provides for contractual services for maintenance of those street lights that are not Excel energy's responsibilities for service. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY Item Happy Hollow Neighborhood Project Qty: 1 Unit Cost: $51,090 Less Trade -in: $ -0- Total Cost: $51,090 R5509BUD BC0006V CITY OF BROOK, ..q CENTER 8/25/k_j 14:20:30 Fiscal Period: 8 / 03 Budget Report Page - 1 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 65200 STREET LIGHT UTILITY FUND 495 STREET LIGHT UTILITY 49571 STREET LIGHT - OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 993- 10,000- 5,000- 5,000- 4605 UNREALIZED INVESTMENT GAIN /LOS 28 4606 OTHER REVENUE 2,065- 4600 MISCELLANEOUS REVENUE 966- 10,000- 2,065- 5,000- 5,000- 4599 MISCELLANEOUS REVENUE 966- 10,000- 2,065- 5,000- 5,000- 4740 STREET LIGHT UTILITY FUND 4741 STREET LIGHT SERVICE CHARGE 213,078- 205,575- 117,085- 207,465- 207,465- 4740 STREET LIGHT UTILITY FUND 213,078- 205,575- 117,085- 207,465- 207,465- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 171 4900 OTHER FINANCING SOURCES 171 4001 REVENUES 214,044- 215,575- 118,979- 212,465- 212,465- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 6 400 400 6200 OFFICE SUPPLIES 6 400 400 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 2,500 2,500 2,500 6230 REPAIR & MAINT SUPPLIES -OTHER 2,500 2,500 2,500 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES 2,500 6 2,900 2,900 J 6299 OTHER CHARGES & SERVICES R5509BUD BCOOO6V CITY OF BROOKS... CENTER 8125%4,._, 14:20:30 Fiscal Period: 8 / 03 Budget Report Page - 2 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIML SERVICES 115 500 500 6307 PROFESSIONAL SERVICES 63 260 500 500 6300 PROFESSIONAL SERVICES 178 260 1,000 1,000 6320 COMMUNICATIONS 6322 POSTAGE 836 403 1,550 1,550 6320 COMMUNICATIONS 836 403 1,550 1,550 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 9 15 6330 TRANSPORTATION 9 15 6350 PRINTING AND DUPLICATING 6351 PRINTING 267 27 6350 PRINTING AND DUPLICATING 267 27 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 66 1,009 1,378 1,378 6360 INSURANCE 66 1,009 1,378 1,378 6380 UTILITY SERVICES 6381 ELECTRIC 133,938 140,000 88,057 144,500 144,500 6380 UTILITY SERVICES 133,938 140,000 88,057 144,500 144,500 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 331 6409 OTHER REPAIR & MAINT SVCS 3,283 5,000 113 7,500 7,500 6400 REPAIR & MAINT SERVICES 3,614 5,000 113 7,500 7,500 6420 IS SERVICES/LICENSES /FEES 6423 LOGIS CHARGES 875 6420 IS SERVICES /LICENSES /FEES 875 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 13,817 47 265 265 6471 ADMINISTRATIVE SERVICE TRANSFE 2,774 6499 EXPENSES REIMBURSED 89,000 89,000 6440 OTHER EXPENSES 13,817 2,821 89,265 89,265 R5509BUD BC0006V CITY OF BROOKL . CENTER 8/25/2....,, 14:20:30 Fiscal Period: 8 / 03 Budget Report Page - 3 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 51,090 6501 CAPITAL OUTLAY 51,090 6299 OTHER CHARGES & SERVICES 152,726 196,090 93,580 245,193 245,193 6001 EXPENDITURES /EXPENSES 152,726 198,590 93,586 248,093 248,093 4000 REVENUES AND EXPENSES 61,318- 16,985- 25,393- 35,628 35,628 49571 STREET LIGHT - OPERATIONS 61,318- 16,985- 25,393- 35,628 35,628 495 STREET LIGHT UTILITY 61,318- 16,985- 25,393- 35,628 35,628 65200 STREET LIGHT UTILITY FUND 61,318- 16,985- 25,393- 35,628 35,628 I I Recycling Utility Fund s`I City of Brook(yn Center 2004 (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. EXPENDITURE DETAILS 6449 Other Contractual Services $227,065 This represents the City's portion of the contractual services provided under a cooperative agreement. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY None requested. I I R5509BUD LOGIS006 CITY OF BROOKLYN CENTER 10/16/200315:49:01 Fiscal Period: 10 / 03 Budget Report Page - 1 Level Of Rollup 7 2000 2001 2002 10131/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 65300 RECYCLING FUND 493 RECYCLING 49311 RECYCLING 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 4,556- 3,714- 2,632- 10,000- 2,500- 2,500- 2,500- 4605 UNREALIZED INVESTMENT GAIN/LOS 1,851 3,875- 73 4606 OTHER REVENUE 2,248- 4600 MISCELLANEOUS REVENUE 2,704- 7,589- 2,559- 2,248- 10,000- 2,500- 2,500- 2,500- 4599 MISCELLANEOUS REVENUE 2,704 7,589- 2,559- 2,248- 10,000- 2,500- 2,500- 2,500- 4750 RECYCLING FUND 4751 RECYCLING SERVICE FEES 210,168- 211,388- 210,954 158,599- 223,839- 224,000- 224,000- 224,000- 4750 RECYCLING FUND 210,168- 211,388- 210,954- 158,599- 223,839- 224,000- 224,000- 224,000- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 187 4900 OTHER FINANCING SOURCES 187 4001 REVENUES 212,872- 218,977- 213,512- 160,660- 233,839- 226,500- 226,500- 226,500- 4 6001 EXPENDITURES/EXPENSES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 6 6200 OFFICE SUPPLIES 6 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 119 500 500 500 6307 PROFESSIONAL SERVICES 65 221 500 500 500 6300 PROFESSIONAL SERVICES 184 221 1,000 1,000 1,000 6320 COMMUNICATIONS 6322 POSTAGE 866 439 1,550 1,550 1,550 6320 COMMUNICATIONS 866 439 1,550 1,550 1,550 '%, 6330 TRANSPORTATION R5509BUD LOGIS006 CITY OF BROOKLYN CENTER 10/16/200315:49:01 Fiscal Period: 10 / 03 Budget Report Page - 2 Level Of Rollup 7 2000 2001 2002 10/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6331 TRAVEL EXPENSE/MILEAGE 1 6330 TRANSPORTATION 1 6350 PRINTING AND DUPLICATING 6351 PRINTING 277 29 6350 PRINTING AND DUPLICATING 277 29 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 119 143 179 210 150 216 216 216 6360 INSURANCE 119 143 179 210 150 216 216 216 6420 IS SERVICES/LICENSES /FEES 6423 LOGIS CHARGES 7,500 7,500 6,341 2,781 6,500 5,081 5,081 5,081 6420 IS SERVICES/LICENSES /FEES 7,500 7,500 6,341 2,781 6,500 5,081 5,081 5,081 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 207,270 207,346 207,364 155,541 207,000 227,065 227,065 227,065 6471 ADMINISTRATIVE SERVICE TRANSFE 7,067 8,480 6440 OTHER EXPENSES 207,270 207,346 207,364 162,608 215,480 227,065 227,065 227,065 6299 OTHER CHARGES & SERVICES 214,889 214,989 215,211 166,289 222,130 234,912 234,912 234,912 6001 EXPENDITURES /EXPENSES 214,889 214,989 215,211 166,295 222,130 234,912 234,912 234,912 4000 REVENUES AND EXPENSES 2,017 3,989- 1,698 5,635 11,709- 8,412 8,412 8,412 49311 RECYCLING 2,017 3,989- 1,698 5,635 11,709- 8,412 8,412 8,412 493 RECYCLING 2,017 3,989- 1,698 5,635 11,709- 8,412 8,412 8,412 65300 RECYCLING FUND 2,017 3,989- 1,698 5,635 11,709- 8,412 8,412 8,412 Centerbrook Golf Course Fund G� City of Brooklyn Center 2004 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 30,000 and 35,000 rounds of golf are played at Centerbrook. In addition, about 200 people will take lessons. The 2004 budget assumes 30,000 rounds will be played. DEPARTMENTAL GOALS * Enhance marketing efforts (including a customer service component) to attract additional golfers. * Assure that the course and clubhouse is clean and well maintained so as to compliment marketing efforts. * Continued improvements in tee time scheduling, cash reporting and inventory control. * Increase league and lesson offerings to increase the number of persons participating by 5 %. * Continue analysis of merchandise selection, pricing and display for changes that would increase revenues. EXPENDITURE DETAILS 6103 Part -Time $71,000 Clubhouse staff, rangers, part-time golf professional, seasonal golf course manager, and maintenance workers. Motor Fuels $1,800 Fuel for mowers and other golf course equipment. The increasing cost of fuel necessitates an increase in budget 6219 Operating Supplies $9,000 The cost of various supplies such as scorecards, towels, cleaning materials, etc. 6216 Chemical Products $6,000 Herbicides, insecticides, snow mold treatment and other chemical used to maintain the fairways and greens. Vendor price increases have necessitated an increase in this line item. 6225 Landscape Materials $6,000 Fertilizer, grass seed, sod, etc, plus the cost of flowers in the various planters throughout the course and at the clubhouse. 6415 Rentals $7,600 The cost of leasing golf carts for rental to patrons. PERSONNEL LEVELS 1 Grounds Supervisor CAPITAL OUTLAY None requested. I R5509BUD LOGij006 CITY OF BROOKLI .. ;ENTER 10/15/2,,,, 9:17:55 Fiscal Period: 10 / 03 Budget Report Page - 1 Level Of Rollup 7 2000 2001 2002 10/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 61300 CENTERBROOK GOLF COURSE 497 CENTERBROOK GOLF COURSE 49721 CENTERBROOK GOLF COURSE 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 6,555- 6,569- 2,679- 5,000- 4,000- 4,000- 4,000 - 4604 CHECK PROCESSING FEES 50- 70- 4605 UNREALIZED INVESTMENT GAIN/LOS 3,203 5,819- 74 4606 OTHER REVENUE 221- 4600 MISCELLANEOUS REVENUE 3,402- 12,458- 2,604- 221- 5,000- 4,000- 4,000- 4,000- 4599 MISCELLANEOUS REVENUE 3,402- 12,458- 2,604- 221- 5,000- 4,000- 4,000- 4,000- 4770 CENTERBROOK GOLF COURSE 4771 GOLF LESSONS 5,555- 4,405- 2,310- 4,324- 5,500- 2,500- 2,500- 2,500- 4773 GREEN FEES 251,084 219,145- 186,518- 183,604- 255,000- 258,695- 258,695- 258,695- 4778 PASSBOOK 21,824- 21,113- 25,379- 28,804- 25,000- 33,550- 33,550- 33,550- 4782 RENTALS 12,509- 11,411- 10,403- 10,564 11,900- 10,000- 10,000- 10,000- 4785 LEAGUE 12,522- 13,478- 15,110- 13,412- 16,250- 15,500- 15,500- 15,500- 4786 BEER & WINE COOLER REVENUES 16,136- 14,061- 10,141- 11,308- 14,500- 14,000- 14,000- 14,000- 4787 FOOD & BEVERAGE REVENUES 18,439- 17,726- 12,832- 11,443- 12,000- 12,000- 12,000- 4788 TAXABLE MERCHANDISE 3,079- 2,638- 3,153- 3,681- 4,000- 4,000- 4,000- 4,000- 4789 NON TAXABLE MERCHANDISE 17,299- 14,789- 10,732- 9,874 10,000- 10,000- 10,000- 4790 MISCELLANEOUS 510- 835- 220- 264 - 34,500- 1,000- 1,000- 1,000- 4791 BOTTLED WATER SALES 1,866- 2,105- 1,500- 1,500- 1,500- 4770 CENTERBROOK GOLF COURSE 358,957- 319,600- 278,664 279,382- 366,650- 362,745- 362,745- 362,745- 4900 OTHER FINANCING SOURCES 4911 SALE OF PROPERTY 800- 4921 REFUNDS & REIMBURSEMENTS 16,000- 4900 OTHER FINANCING SOURCES 16,800- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5582 COST OF SALES -WINE 188 5583 COST OF SALES -BEER 4,198 3,313 4,200 5586 COST OF SALES -MISC 18,195 15,992 5580 COST OF GOODS SOLD 22,393 19,493 4,200 R5509BUD LOGIS006 CITY OF BROOKLI .. „ENTER 1011512,... 9:17:55 Fiscal Period: 10 / 03 Budget Report Page - 2 Level Of Roliup 7 2000 2001 2002 10/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 5550 DIRECT COST OF SALES 22,393 19,493 4,200 4001 REVENUES 339,966- 312,566- 298,068- 279,603- 367,450- 366,745- 366,745- 366,745- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 37,836 40,036 32,329 31,311 41,122 41,114 41,114 41,114 6103 WAGES -PART TIME EMPLOYEES 91,780 90,104 91,301 57,898 81,500 71,000 71,000 71,000 6104 OVERTIME -PART TIME EMPLOYEES 702 570 1,133 139 6100 WAGES AND SALARIES 130,317 130,710 124,762 89,348 122,622 112,114 112,114 112,114 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 2,491 5,464 3,170 3,445 6,781 2,274 2,274 2,274 6125 FICA 9,709 9,635 8,321 5,411 9,381 2,550 2,550 2,550 6126 MEDICARE CONTRIBUTIONS 1,141 1,265 597 597 597 6120 RETIREMENT CONTRIBUTIONS 12,200 15,098 12,632 10,121 16,162 5,421 5,421 5,421 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 4,763 5,423 5,844 4,911 6,000 6,180 6,180 6,180 6130 INSURANCE BENEFITS 4,763 5,423 5,844 4,911 6,000 6,180 6,180 6,180 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 69 345 6140 UNEMPLOYMENT COMPENSATION 69 345 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 1,169 1,150 1,605 1,662 1,200 781 781 781 6150 WORKER'S COMPENSATION 1,169 1,150 1,605 1,662 1,200 781 781 781 6099 PERSONAL SERVICES 148,450 152,382 144,912 106,386 145,984 124,496 124,496 124,496 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 541 330 622 270 600 600 600 600 6204 STATIONARY SUPPLIES 916 6200 OFFICE SUPPLIES 541 1,246 622 270 600 600 600 600 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 5 36 15 111 100 150 150 150 R5509BUD LOGIS006 CITY OF BROOKLI ...;ENTER 10/15/2u- 9:17:55 Fiscal Period: 10 / 03 Budget Report Page - 3 Level Of Rollup 7 2000 2001 2002 10/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6212 MOTOR FUELS 1,804 1,086 2,120 1,601 1,500 1,800 1,800 1,800 6213 LUBRICANTS & ADDITIVES 18 24 29 50 6214 CLOTHING & PERSONAL EQUIPMENT 200 200 200 200 6215 SHOP MATERIALS 23 70 83 91 6216 CHEMICALS /CHEMICAL PRODUCTS 2,875 4,328 5,477 1,717 4,000 6,200 6,200 6,200- 6217 SAFETY SUPPLIES 23 100 100 100 6219 GENERAL OPERATING SUPPLIES 6,174 11,021 3,672 2,119 8,000 9,000 9,000 9,000 6210 OPERATING SUPPLIES 10,881 16,559 11,590 5,691 13,650 17,450 17,450 17,450 6220 REPAIR & MAINT SUPPLIES 6221 MOTOR VEHICLES 140 896 762 1,311 6223 BUILDINGS & FACILITIES 316 128 878 180 1,000 500 500 500 6225 PARK & LANDSCAPE MATERIALS 5,026 4,443 7,495 6,315 5,800 6,000 6,000 6,000 6227 PAINT SUPPLIES 59 86 100 100 100 6220 REPAIR & MAINT SUPPLIES 5,540 5,466 9,222 7,806 6,800 6,600 6,600 6,600 6230 REPAIR & MAINT SUPPLIES -OTHER 6237 LAUNDRY SUPPLIES 1,080 1,174 1,500 1,100 6239 OTHER REPAIR & MAINT SUPPLIES 1,547 345 711 84 500 500 500 500 6230 REPAIR & MAINT SUPPLIES -OTHER 2,627 1,520 2,210 84 1,600 500 500 500 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 607 160 625 115 250 500 500 500 6242 MINOR EQUIPMENT 670 4,950 1,843 650 1,000 1,000 1,000 6240 SMALL TOOLS & MINOR EQUIPMENT 607 830 5,575 1,959 900 1,500 1,500 1,500 6199 SUPPLIES 20,196 25,620 29,219 15,810 23,550 26,650 26,650 26,650 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 510 669 653 417 700 800 800 800 6307 PROFESSIONAL SERVICES 274 1,215 300 1,250 1,250 1,250 6319 OTHER PROFESSIONAL SERVICES 692 110 6300 PROFESSIONAL SERVICES 1,202 778 926 1,632 1,000 2,050 2,050 2,050 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 6,776 6,981 6,973 3,578 6,000 4,920 4,920 4,920 Q � 6320 COMMUNICATIONS 6,776 6,981 6,973 3,578 6,000 4,920 4,920 4,920 6330 TRANSPORTATION R5509BUD LOGIS006 CITY OF BROOKLl,. „ENTER 10/15/21,. 9:17:55 Fiscal Period: 10 / 03 Budget Report Page - 4 Level Of Rollup 7 2000 2001 2002 10/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6331 TRAVEL EXPENSE/MILEAGE 23 100 100 100 6339 OTHER TRANSPORTATION EXPENSE 1,737 6330 TRANSPORTATION 1,737 23 100 100 100 6340 ADVERTISING 6349 OTHER ADVERTISING 5,169 3,740 2,558 2,546 4,000 4,000 4,000 4,000 f e 6340 ADVERTISING 5,169 3,740 2,558 2,546 4,000 4,000 4,000 4,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 506 1,000 1,000 1,000 6350 PRINTING AND DUPLICATING 506 1,000 1,000 1,000 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 5,956 6,675 7,517 6,627 6,500 7,220 7,220 7,220 6362 PROPERTY INSURANCE 847 956 1,281 1,707 1,000 2,153 2,153 2,153 6363 MOTOR VEHICLE INSURANCE 300 6364 DRAM SHOP INSURANCE 1,003 600 32 32 1,000 34 34 34 6366 MACHINERY BREAKDOWN INSURANCE 204 219 173 226 200 252 252 252 6360 INSURANCE 8,010 8,449 9,003 8,591 9,000 9,659 9,659 9,659 6380 UTILITY SERVICES 6381 ELECTRIC 5,219 5,540 5,325 3,914 6,000 6,000 6,000 6,000 6382 GAS 684 1,086 1,973 1,575 1,300 2,000 2,000 2,000 6383 WATER 5,900 5,087 2,918 4,887 5,000 3,600 3,600 3,600 6384 REFUSE DISPOSAL 914 1,394 2,346 1,486 1,400 2,000 2,000 2,000 6385 SEWER 190 405 389 422 400 500 500 500 6386 STORM SEWER 701 753 806 623 750 800 800 800 6387 HEATING OIL 10 6380 UTILITY SERVICES 13,617 14,264 13,758 12,906 14,850 14,900 14,900 14,900 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 3,262 1,207 245 984 3,000 6403 BLDGS /FACILITIES MAINT SERVICE 9,315 3,250 3,250 3,250 6408 COMMUNICATION /INFO SYSTEMS 95 6409 OTHER REPAIR & MAINT SVCS 1,648 1,621 799 6400 REPAIR & MAINT SERVICES 4,910 2,828 1,139 10,299 3,000 3,250 3,250 3,250 6410 RENTALS 6415 OTHER EQUIPMENT 6,179 4,882 4,791 6,071 7,600 7,600 7,600 7,600 6410 RENTALS 6,179 4,882 4,791 6,071 7,600 7,600 7,600 7,600 R5509BUD LOGIS006 CITY OF BROOKLY- ;ENTER 10/15/20ue 9:17:55 Fiscal Period: 10 / 03 Budget Report Page - 5 Level Of Rollup 7 2000 2001 2002 10/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6420 IS SERVICES/LICENSES /FEES 6421 SOFTWARE LICENSE 70 70 70 6422 SOFTWARE MAINT 206 240 240 240 6423 LOGIS CHARGES 2,130 2,255 2,777 2,572 2,500 2,635 2,635 2,635 6428 PROTECTION SERVICES 459 411 625 590 750 1,200 1,200 1,200 6420 IS SERVICES/LICENSES /FEES 2,589 2,666 3,402 3,368 3,250 4,145 4,145 4,145 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 178 21 75 220 250 200 200 200 6434 DUES & SUBSCRIPTIONS 384 454 762 459 500 500 500 500 6435 CREDIT CARD FEES 702 945 1,176 1,633 1,000 1,200 1,200 1,200 6436 UNCOLLECTIBLE CHECKS /DEBTS 56 44 15- 6438 CASH SHORT (OVER) 504- 439- 24- 38- 6430 MISCELLANEOUS 816 1,025 1,975 2,274 1,750 1,900 1,900 1,900 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 227 2,580 119 188 100 100 100 100 6442 COURT AWARDSISETTLEMENTS 3,040 6449 OTHER CONTRACTUAL SERVICE 221 3,206 2,146 2,250 3,200 3,200 3,200 6440 OTHER EXPENSES 227 2,801 3,325 5,374 2,350 3,300 3,300 3,300 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 198 225 186 395 250 228 228 228 6462 FIXED CHARGES 7,658 8,796 11,957 6,048 12,000 12,316 12,316 12,316 6463 REPAIR & MAINT CHARGES 2,811 3,805 6,860 6,126 4,400 4,810 4,810 4,810 6460 CENTRAL GARAGE CHARGES 10,668 12,826 19,003 12,569 16,650 17,354 17,354 17,354 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 5,332 5,496 8,585 7,292 8,750 9,000 9,000 9,000 6476 CAPITAL PROJECT FUND TRANSFER 10,000 6470 TRANSFERS AND OTHER USES 5,332 15,496 8,585 7,292 8,750 9,000 9,000 9,000 6490 OTHER MISC COSTS /EXPENSES 6491 MERCHANDISE FOR RESALE 14,285 14,394 27,820 25,223 32,000 25,500 25,500 25,500 6494 DEPRECIATION EXPENSE 13,837 14,736 65,220 20,934 16,000 28,000 28,000 28,000 \ 6490 OTHER MISC COSTS /EXPENSES 28,121 29,129 93,040 46,157 48,000 53,500 53,500 53,500 C 6299 OTHER CHARGES & SERVICES 93,616 107,604 168,984 122,678 126,200 136,678 136,678 136,678 R5509BUD LOGIS006 CITY OF BROOKLN - %;ENTER 10/15/2uus 9:17:55 Fiscal Period: 10 / 03 Budget Report Page - 6 Level Of Rollup 7 2000 2001 2002 10/31/2003 2003 2004 2004 2004 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6580 INFORMATION SYSTEMS 1,600 6501 CAPITAL OUTLAY 1,600 6500 CAPITAL OUTLAY 1,600 6600 DEBT SERVICE 6602 OTHER DEBT - PRINCIPAL 55,000 55,000 55,000 55,000 6612 OTHER DEBT - INTEREST 737 6600 DEBT SERVICE 737 55,000 55,000 55,000 55,000 6001 EXPENDITURES /EXPENSES 262,263 286,342 343,115 244,874 352,334 342,824 342,824 342,824 4000 REVENUES AND EXPENSES 77,704 26,223- 45,046 34,729- 15,116- 23,921- 23,921- 23,921- 49721 CENTERBROOK GOLF COURSE 77,704- 26,223- 45,046 34,729- 15,116- 23,921- 23,921- 23,921- 497 CENTERBROOK GOLF COURSE 77,704 26,223- 45,046 34,729- 15,116- 23,921- 23,921- 23,921- 61300 CENTERBROOK GOLF COURSE 77,704- 26,223- 45,046 34,729- 15,116- 23,921- 23,921- 23,921 - I EBHC Fund 7 Y City of Brooklyn Center 2004 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, catering and the Inn on the Farm. 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 6243 Minor Computer Equipment $1,200 Provides for the replacement of an outdated computer /monitor 6432 Conferences and Schools $3,500 Professional development for General Manager through IAAM (International Association of Assembly Managers) and for educational speakers related to training for facility staff PERSONNEL LEVELS 1 -EBHC Manager 1- Secretary/Receptionist 1- Secretary/Billing Clerk CAPITAL OUTLAY None Requested City of (Brooklyn Center 2004 (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. Noted for a high level of customer service the facility maintains a significant amount of repeat business among its corporate clientele. The business mix is 66% corporate, 9% social, 4% shows, 10% government/health, and 11 % weddings. Economic impact directly affecting Brooklyn Center includes hotel, restaurant, shopping and convention service related business activity (floral, printing, rental, etc.) DEPARTMENTAL GOALS * Add a minimum of ten new corporate clients. * Participate in four trade show opportunities to promote the Heritage Center in the marketplace * Participate in four industry associations to network for referral business * Combine marketing efforts with North Metro Convention and Visitor's Bureau to attract new or reoccurring large multi -day events * Promote the facility in accordance with the 2004 Marketing Plan * Host a minimum of two association meetings on -site in conjunction with the North Metro Convention and Visitors Bureau EXPENDITURE DETAILS 6321 Telephone/Pagers $10,900 Reduced cost for telephone services due to renegotiated service contracts with Qwest 6243 Minor Computer Equipment $1,200 Replacement of one outdated computer /monitor 6307 Professional Services $4,000 Provides for consulting fees to determine ISDN /DSL /T1 line needs to address client needs within the convention center. PERSONNEL LEVELS 1- Sales Director 2- Sales Managers 1- Maintenance /Operations Supervisor 2- Maintenance Custodians 2- Crew Chiefs Plus part -time staff positions which include set -up crew, custodians, and maintenance. i CAPITAL OUTLAY LCD Projector Qty: 1 Unit Cost: $7,995 Less Trade -in: $ -0- Total Cost $7,995 Replacement of Incandescent Lighting Controller for Carriage Hall Qty: 1 Unit Cost: $15,000 Less Trade -in: $ -0- Total Cost: $15,000 Replacement of Southern Doors in Carriage Hall Qty: 1 Unit Cost: $37,441 Less Trade -in: $ -0- Total Cost: $37,441 Parking Lot Repair Qty: 1 Unit Cost: $70,000 Less Trade -in: $ -0- Total Cost: $70,000 'i City o C Broo C y f kyn Center 2004 (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 ricin , hires staff, and e provides food and beverage P g p g 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 * Continue to create menu solutions that meet client needs * Maintain competitive purchase pricing * Provide a high level of quality product to facility clients * Develop new menu items and increase pricing competitive with the marketplace. EXPENDITURE DETAILS Object codes 5591, 5592, 5593 and 5595 are Flik costs for catering. A base contracted management fee of $100,000 is paid to Flik International. All other object codes used reflect catering related expenses paid by the Earle Brown Heritage Center. 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 None requested i - 7 Y City of BrookCyn Center 2004 Budget FUND: Earle Brown Heritage Center - 61700 DEPT /ACTIVITY/PROJECT: Office Rental - 49854 PROFILE The D Barn (commercial office building) is currently seventy percent occupied by Blumental's Architecture in a long -term lease. The remaining ground level footage provides a storage area for the audio /visual department and supports the meeting space. The Heritage Center staff, under the direction of the General Manager, provides maintenance and custodial services, lawn care, and snow removal. Rental leases are negotiated by the General Manager. DEPARTMENTAL GOALS * Provide maintenance to building * Respond to tenant concerns in a timely manner. EXPENDITURE DETAILS 6223 Repair and Maintenance Supplies- Buildings and Facilities $6,500 Provides for repair and maintenance supplies for maintenance of the office areas within the EBHC and includes filter, cleaning equipment pars, etc. Carpet replacement for the second floor office area in the Blacksmith Shop (Innovative Presentation and Conference Services offices) and costs for moving equipment to facilitate the replacement are included in this line item. 6382 Utility Services -Gas $1,925 Represents gas expense to heat the office portion of the facility. PERSONNEL LEVELS Maintenance and custodial care provided by facility staff under the direction of the Maintenance Supervisor. CAPITAL OUTLAY None requested. City of Brooklyn Center 2004 Budget FUND: Earle Brown Heritage Center - 61700 DEPT /ACTIVITY/PROJECT: Inn on the Farm - 49855 PROFILE The Inn on the Farm is an historic country Inn that supports the meeting facilities with overnight accommodations. Blocks of eight to ten rooms are contracted per day with no individual overnight accommodations offered. The sales department of the Heritage Center sells the room blocks. Hostess and housekeeping staff are scheduled to cover the contracts only and the Inn is closed all other days. DEPARTMENTAL GOALS * Continue to sell blocks of overnight rooms through facility sales staff. * Cover meeting room usage though catering and conference services staff. EXPENDITURE DETAILS 6210 General Operating Supplies $2,800 Provides for supply items such as water softener salt, bed and bath linens, and paper products. 6223 Repair and Maintenance Supplies - Buildings and Facilities $2,500 Provides for supply items such as miscellaneous hardware for repairs, consumable supplies such as filter and mops, etc. 6441 Licenses; Taxes and Fees $10,534 Provides for Inn on the Farm share of the property taxes on the EBHC facility and the Hennepin County license fee. PERSONNEL LEVELS The Heritage Center General Manager supervises all Inn functions. Part-time hostess and housekeepers cover guest services. Maintenance and repair at the Inn is provided by facility staff under the direction of the Maintenance Supervisor. CAPITAL OUTLAY None requested. Z I R5509BUD BCOOO6V CITY OF BROOKL 8/25/20 ., 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 1 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 61700 EARLE BROWN HERITAGE CENTER 498 CONVENTION CENTER OPERATIONS 49851 EBHC - ADMINISTRATION 4603 INTEREST EARNINGS 20,817- 4605 UNREALIZED INVESTMENT GAIN/LOS 577 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 121,633 128,839 135,105 80,602 136,516 136,516 6100 WAGES AND SALARIES 121,633 128,839 135,105 80,602 136,516 136,516 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 6,272 7,099 7,471 4,457 7,550 7,550 6125 FICA 9,356 8,916 10,336 5,021 8,464 8,464 6126 MEDICARE CONTRIBUTIONS 1,025 1,174 1,980 1,980 6120 RETIREMENT CONTRIBUTIONS 15,628 17,040 17,807 10,653 17,994 17,994 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 16,270 17,534 18,000 12,407 18,540 18,540 6130 INSURANCE BENEFITS 16,270 17,534 18,000 12,407 18,540 18,540 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 420 1,468 604 1,580 747 747 6150 WORKER'S COMPENSATION 420 1,468 604 1,580 747 747 6099 PERSONAL SERVICES 153,951 164,881 171,516 105,242 173,797 173,797 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 671 6200 OFFICE SUPPLIES 671 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 465 6210 OPERATING SUPPLIES 465 6240 SMALL TOOLS & MINOR EQUIPMENT 6242 MINOR EQUIPMENT 294 6243 MINOR COMPUTER EQUIPMENT 1,200 1,200 t 6240 SMALL TOOLS & MINOR EQUIPMENT 294 1,200 1,200 ""'i 6199 SUPPLIES 1,135 294 1,200 1,200 R5509BUD BC0006V CITY OF BROOKLYI, ;ENTER 8/25/20t,,, 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 2 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT & FIN'L SERVICES 3,51 3,451 3 000 2,129. 6303 LEGAL SERVICES 4,092 321 1,500 1,500 1,500 6307 PROFESSIONAL SERVICES 500 1,250 2,000 2,000 6319 OTHER PROFESSIONAL SERVICES 2,000 6300 PROFESSIONAL SERVICES 9,602 4,273 4,500 3,379 3,500 3,500 6330 TRANSPORTATION 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,405 1,953 1,518 1,325 2,559 2,559 6362 PROPERTY INSURANCE 3,249 3,562 3,190 2,261 4,182 4,182 6366 MACHINERY BREAKDOWN INSURANCE 341 351 382 229 420 420 6360 INSURANCE 4,996 5,866 5,090 3,815 7,161 7,161 6420 IS SERVICES/LICENSES /FEES 6421 SOFTWARE LICENSE 3,454 1,650 490 490 6422 SOFTWARE MAINT 1,882 2,550 2,550 6423 LOGIS CHARGES 27,909 30,120 28,629 17,761 15,560 15,560 ` 6420 IS SERVICES /LICENSES /FEES 27,909 33,574 30,279 19,643 18,600 18,600 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 2,649 2,824 3,000 1,981 3,500 3,500 6430 MISCELLANEOUS 2,649 2,824 3,000 1,981 3,500 3,500 6440 OTHER EXPENSES 6442 COURT AWARDS /SETTLEMENTS 10,000- 6449 OTHER CONTRACTUAL SERVICE 4,145 2,000 6440 OTHER EXPENSES 5,855- 2,000 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 59,035 66,279 68,930 45,593 6476 CAPITAL PROJECT FUND TRANSFER 100,000 6494 DEPRECIATION EXPENSE 21,474 35,212 35,212 6470 TRANSFERS AND OTHER USES 59,035 166,279 68,930 67,067 35,212 35,212 6299 OTHER CHARGES & SERVICES 98,335 212,815 113,799 95,886 67,973 67,973 CN- R5509BUD BC0006V CITY OF BROOKLYN .,ENTER 8/25/200 ,4:19:55 Fiscal Period: 8 / 03 Budget Report Page - 3 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6580 INFORMATION SYSTEMS 3,600 3,258 6501 CAPITAL OUTLAY 3,600 3,258 6500 CAPITAL OUTLAY 3,600 3,258 6600 DEBT SERVICE 6612 OTHER DEBT - INTEREST 824 1,098 561 1,000 1,000 6600 DEBT SERVICE 824 1,098 561 1,000 1,000 6001 EXPENDITURES /EXPENSES 254,245 379,088 288,915 204,946 243,970 243,970 49851 EBHC - ADMINISTRATION 254,245 358,849 288,915 204,946 243,970 243,970 49852 EBHC- CONVENTION CENTER 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 17,907- 1,736- 269- 4604 CHECK PROCESSING FEES 30- 30- 4605 UNREALIZED INVESTMENT GAIN/LOS 3,179- 4606 OTHER REVENUE 35- 4600 MISCELLANEOUS REVENUE 21,117- 1,736- 334- 4599 MISCELLANEOUS REVENUE 21,117- 1,736- 334- 4800 EBHC 4820 CONVENTION CENTER 4821 ROOM RENTALS 696,009- 744,771- 610,000- 333,710 - 640,000- 640,000- 4821.1 CMP ROOM RENTALS 83,974- 91,816- 65,000- 41,375 - 30,000- 30,000- 4821 ROOM RENTALS 779,983- 836,587- 675,000- 375,085- 670,000- 670,000- 4822 LABOR CHARGES 10,501- 5,050- 6,000- 3,103- 6,000- 6,000- 4823 EQUIPMENT RENTALS 183,708- 170,176- 181,000- 107,221- 181,000- 181,000 - 4823.1 CMP EQUIPMENT RENTALS 46,568- 70,508- 70,000- 13,606- 30,000- 30,000- 4823 EQUIPMENT RENTALS 230,276- 240,684- 251,000- 120,827- 211,000- 211,000- R5509BUD BCOOO6V CITY OF BROOKLYi, -ENTER 8/25/20U- ,4:19:55 Fiscal Period: 8 / 03 Budget Report Page - 4 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 4826 DANCE FLOOR RENTALS 56,236- 49,724- 47,000- 19,368- 47,000- 47,000- 4827 SECURITY SERVICES 16,419- 14,400- 12,500- 6,600- 12,500- 12,500- 4828 CLIENT SERVICES 31,074- 33,435- 32,500- 18,661- 42,000- 42,000- 1 4829 MISCELLANEOUS 2,556- 3,483- 4,000- 2,777- 4,000- 4,000- ' 4820 CONVENTION CENTER 1,127,046- 1,183,362- 1,028,000 - 546,421- 992,500- 992,500- 4800 EBHC 1,127,046- 1,183,362- 1,028,000 - 546,421- 992,500- 992,500- 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 375- 305- 4900 OTHER FINANCING SOURCES 375- 305 - 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5586 COST OF SALES -MISC 1,135 1,632 5580 COST OF GOODS SOLD 1,135 1,632 5550 DIRECT COST OF SALES 1,135 1,632 4001 REVENUES 1,147,027- 1,185,474- 1,028,000- 545,428- 992,500- 992,500- 6001 EXPENDITURES /EXPENSES r 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 W AGES 8 SALAR -FE, EMP LOYEES 261,758 277 144 293,811 _ 180,_099 32 321,219 6102 OVERTIME -FT EMPLOYEES 2,383 850 1,950 _ 166 850 850 6103 WAGES -PART TIME EMPLOYEES 165,053 142,686 160,000 92,948 160,000 160,000 6104 OVERTIME -PART TIME EMPLOYEES 124 363 600 400 400 6100 WAGES AND SALARIES 429,317 421,043 456,361 273,210 482,469 482,469 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 20,440 22,556 25,236 14,587 26,681 26,681 6123 PERA POLICE 8 FIRE PLAN 111 42 29 6125 FICA 32,795 29,019 34,911 16,514 29,914 29,914 6126 MEDICARE CONTRIBUTIONS 3,127 3,867 6,997 6,997 6120 RETIREMENT CONTRIBUTIONS 53,347 54,744 60,147 34,997 63,592 63,592 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 37,459 44,343 48,000 32,631 49,440 49,440 6130 INSURANCE BENEFITS 37,459 44,343 48,000 32,631 49,440 49,440 R5509BUD BCOOO6V CITY OF BROOKLYn, -ENTER 8/25/200.. ,4:19:55 Fiscal Period: 8 / 03 Budget Report Page - 5 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 736 22 6140 UNEMPLOYMENT COMPENSATION 736 22 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 8,393 10,293 10,978 8,680 10,325 10,325 6150 WORKER'S COMPENSATION 8,393 10,293 10,978 8,680 10,325 10,325 6099 PERSONAL SERVICES 528,516 531,159 575,486 349,540 605,826 605,826 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 2,583 2,771 4,000 2,048 3,000 3,000 6202 COPYING SUPPLIES 501 1,200 1,200 6203 BOOKS /REFERENCE MATERIALS 129 45 150 100 100 6200 OFFICE SUPPLIES 2,712 2,816 4,150 2,549 4,300 4,300 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 9,904 11,717 11,900 5,765 11,900 11,900 6212 MOTOR FUELS 21 6214 CLOTHING & PERSONAL EQUIPMENT 1,068 1,376 1,400 298 1,300 1,300� 6215 SHOP MATERIALS 523 717 500 397 700 700 6216 CHEMICALS /CHEMICAL PRODUCTS 2,133 2,853 3,100 3,384 3,000 3,000 yy � '• 6217 SAFETY SUPPLIES 460 557 500 232 550 550 \ E t 6219 GENERAL OPERATING SUPPLIES 25,195 22,732 28,850 12,393 35,000 35,000 6210 OPERATING SUPPLIES 39,304 39,951 46,250 22,469 52,450 52,450 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 14,499 23,859 33,000 6,050 28,000 28,000 6225 PARK & LANDSCAPE MATERIALS 1,144 1,555 3,000 1,643 2,000 2,000 6226 SIGNS & STRIPING MATERIALS 595 289 900 600 600 6227 PAINT SUPPLIES 1,273 2,400 970 1,500 1,500 6220 REPAIR & MAINT SUPPLIES 16,237 26,976 39,300 8,662 32,100 32,100 6230 REPAIR & MAINT SUPPLIES -OTHER A 6239 OTHER REPAIR & MAINT SUPPLIES 5,151 3,973 5,600 2,493 4,500 4,500 6230 REPAIR & MAINT SUPPLIES -OTHER 5,151 3,973 5,600 2,493 4,500 4,500 �` 6240 SMALL TOOLS & MINOR EQUIPMENT R5509BUD BCOOO6V CITY OF BROOKLYN. -ENTER 8/25/20u- 4:19:55 Fiscal Period: 8 / 03 Budget Report Page - 6 Level Of Rollup 9 2001 2002 2003 8/3112003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6241 SMALL TOOLS 823 877 950 402 950 950 6242 MINOR EQUIPMENT 2,144 4,120" " 6243 MINOR COMPUTER EQUIPMENT C1.200 1,200 6240 SMALL TOOLS & MINOR EQUIPMENT 2,967 4,997 950 402 2 1SU 6199 SUPPLIES 66,371 78,713 96,250 36,575 95,500 95,500 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6302 ARCH, ENG & PLANNING 669 6303 LEGAL SERVICES 1,371 225 2,000 771 1,500 1,500 6307 PROFESSIONAL SERVICES ..-^ " ° " °`' "" .771• 750 6,997 4,000 4,000 6319 OTHER PROFESSIONAL SgRVEC9"S� 723 6300 PROFESSIONAL SERVICES 2,095 1,666 2,750 7,768 5,500 5,500 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 18,100 16,953 18,000 9,134 13,350 13,350 6322 POSTAGE 3,741 3,169 4,200 2,527 4,500 4,500 6329 OTHER COMMUNICATION SERVICES 19 6320 COMMUNICATIONS 21,842 20,141 22,200 11,660 17,850 17,850 6330 TRANSPORTATION 6331 TRAVEL EXPENSE /MILEAGE 1,142 801 975 318 800 800 6333 FREIGHT /DRAYAGE 205 232 240 36 6330 TRANSPORTATION 1,347 1,033 1,215 354 800 800 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 1,222 2,000 2,000 2,000 6349 OTHER ADVERTISING 33,084 45,191 46,650 35,063 46,800 46,800 6340 ADVERTISING 34,305 45,191 48,650 35,063 48,800 48,800 6350 PRINTING AND DUPLICATING 6351 PRINTING 10,566 5,669 13,500 3,761 11,500 11,500 6350 PRINTING AND DUPLICATING 10,566 5,669 13,500 3,761 11,500 11,500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 5,395 4,269 5,090 2,460 5,105 5,105 6362 PROPERTY INSURANCE 2,383 4,147 2,229 2,863 5,299 5,299 6366 MACHINERY BREAKDOWN INSURANCE 249 414 379 290 532 532 6360 INSURANCE 8,028 8,831 7,698 5,613 10,936 10,936 R5509BUD BCOOO6V CITY OF BROOKL ( -ENTER 8/25/20u- 44:19:55 Fiscal Period: 8 / 03 Budget Report Page - 7 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6380 UTILITY SERVICES 6381 ELECTRIC 82,498 73,600 82,000 48,627 82,000 82,000 6382 GAS 24,130 14,546 30,000 16,727 30,000 30,000 6383 WATER 952 869 1,100 490 1,300 1,300 6384 REFUSE DISPOSAL 1,844 1,675 2,000 636 1,800 1,800 6385 SEWER 1,836 1,770 1,900 985 2,500 2,500 6386 STORM SEWER 729 1,316 1,400 750 1,800 1,800 6389 STREET LIGHTS 250 127 300 300 6380 UTILITY SERVICES 111,989 94,027 118,400 68,540 119,700 119,700 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 50,643 25,046 33,500 2,504 25,700 25,700 6403 BLDGS /FACILITIES MAINT SERVICE 12,200 7,777 15,000 15,000 6405 PARK & LANDSCAPE SERVICES 1,501 4,125 4,125 6409 OTHER REPAIR & MAINT SVCS 7,816 11,164 9,930 381 800 800 6400 REPAIR & MAINT SERVICES 58,459 48,410 43,430 12,162 45,625 45,625 6410 RENTALS 6413 OFFICE EQUIPMENT 865 2,442 G 4,200`"`°"° 6415 OTHER EQUIPMENT 81,552 86,421 98,000 50,789 98,000 98,000 ~' 6419 OTHER RENTAL EXPENSE 2,131 3u 400 -- 400 - - '*` W 6410 RENTALS 83,683 87,286 98,000 53,261 102,600 102,600 6420 IS SERVICES/LICENSES /FEES 6428 PROTECTION SERVICES 7,136 8,900 3,496 6,800 6,800 6420 IS SERVICES /LICENSES /FEES 7,136 8,900 3,496 6,800 6,800 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 4,539 3,319 4,000 2,366 4,000 4,000 6433 MEETING EXPENSES 281 171 450 131 450 450 6434 DUES & SUBSCRIPTIONS 2,314 2,472 3,850 2,579 3,850 3,850 6435 CREDIT CARD FEES 3,544 2,614 826 2,450 2,450 6436 UNCOLLECTIBLE CHECKSIDEBTS 1,150- 1,551 5- 6438 CASH SHORT (OVER) 6430 MISCELLANEOUS 9,528 10,127 8,300 5,896 10,750 10,750 vA 6440 OTHER EXPENSES c � 6441 LICENSES, TAXES & FEES 3 10 6449 OTHER CONTRACTUAL SERVICE 30,880 36,015 23,500 9,796 23,500 23,500 R5509BUD BC0006V CITY OF BROOKLI„ ;ENTER 8/25/20u- 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 8 Level Of Rollup 9 8 2001 2002 2003 8/31/2003 2004 2004 ; Actual Actual Final YTO Requested Recommended 1, Object Code / Description Amount Amount Budget Actual Budget Budget 6461 FUEL CHARGES 1,649 6440 OTHER EXPENSES 30,880 37,667 23,500 9,806 23,500 23,500 �. 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 334,901 460,850 335,000 159,987 262,878 262,878 r " 6494.1 ASSET THRESHOLD CHANGE EXPENSE 287,819 }} 6494 DEPRECIATION EXPENSE 334,901 748,669 335,000 159,987 262,878 262,878 f saR , 6490 OTHER MISC COSTS /EXPENSES 334,901 748,669 335,000 159,987 262,878 262,878 ! '' ITAL ".� OU TLAY � CES 707,622 6500 OTHER CHARGES & SERV °" ",, 1,115,853 - x 377,368 667 .. 6520 BUILDINGS & FACILITIES 19,590 130,000 122,441 122,441 6540 EQUIPMENT & MACHINERY 19,536 40,000 7,995 7,995 i` ttt 6580 INFORMATION SYSTEMS 1,600 1,028 -- -- ..: - 6500 CAPITAL OUTLAY --, ..- .- ....,..,. 39,127 171,600 1,028 130,436 1.�Q43fiw.,,�.,..•• -•. -- -- 1 6600 DEBT SERVICE 6612 OTHER DEBT - INTEREST 411 5 6600 DEBT SERVICE 411 5 6001 EXPENDITURES /EXPENSES 1,302,920 1,764,851 1,574,879 764,515 1,499,001 1,499,001 4000 REVENUES AND EXPENSES 155,893 579,378 546,879 219,087 506,501 506,501 49852 EBHC- CONVENTION CENTER 155,893 579,378 546,879 219,087 506,501 506,501 49853 EBHC- CATERING OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4840 CATERING SERVICES 4842 SERVICE CHARGES 355,954- 305,475- 334,890- 199,974- 331,756- 331,756- 4843 CONCESSIONS 7,200- 12,300- 12,300- 4844 FOOD & BEVERAGE SALES 1,860,628- 1,625,399- 1,860,500- 1,010,129- 1,835,891- 1,835,891- 4844.1 FOOD & BEVERAGE SALES, INN 28,311- 13,215- 7,266- 4845 LIQUOR/WINE/BEER SALES 354,830- 229,530- 295,500- 141,698- 269,365- 269,365 - R5509BUD BC0006V CITY OF BROOKS ..a CENTER 8/25/k, i 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 9 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 4845.1 LIQUOR/WINE /BEER SALES, INN 3,075- 1,093- 142- 4848 MISCELLANEOUS SALES 10,040- 15,388- 11,550- 9,104- 4849 MISCELLANEOUS SALES -NON TAXABL 5,043- 3,000- 435- 9 . 4840 CATERING SERVICES 2,617,881- 2,193,100- 2,509,640- 1,368,746- 2,449,312- 2,449,312- 4800 EBHC 2,617,881- 2,193,100- 2,509,640- 1,368,746- 2,449,312- 2,449,312- / 4900 OTHER FINANCING SOURCES 4921 REFUNDS & REIMBURSEMENTS 430- 1,130- 4900 OTHER FINANCING SOURCES 430- 1,130- 5550 DIRECT COST OF SALES 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES -LABOR 1,024,220 939,223 975,744 546,257 874,719 874,719 5592 COST OF SALES -FOOD 483,429 381,403 501,150 223,480 439,595 439,595 5593 COST OF SALES - SUPPLIES 151,682 129,443 183,140 77,267 262,426 262,426 5594 COST OF SALES -MGMT FEES 27,066 117,804 114,750 58,333 100,000 100,000 5590 EBHC CONTRACT EXPENSES 1,686,397 1,567,874 1,774,784 905,337 1,676,740 1,676,740 5595 COST OF SALES- BANQUET EXPENSES 3,937 5550 DIRECT COST OF SALES 1,686,397 1,571,811 1,774,784 905,337 1,676,740 1,676,740 4001 REVENUES 931,484- 621,718- 734,856- 464,540- 772,572- 772,572- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 18,683 19,921 19,500 9,527 6102 OVERTIME -FT EMPLOYEES 156 157 106 6103 WAGES -PART TIME EMPLOYEES 46,053 40,318 41,000 12,036 41,000 41,000 6104 OVERTIME -PART TIME EMPLOYEES 4 6100 WAGES AND SALARIES 64,891 60,400 60,500 21,669 41,000 41,000 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 2,715 3,090 3,346 1,105 2,268 2,268 6125 FICA 4,848 4,040 4,628 1,364 2,542 2,542 6126 MEDICARE CONTRIBUTIONS 505 319 595 595 6120 RETIREMENT CONTRIBUTIONS 7,563 7,635 7,974 2,787 5,405 5,405 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 2,880 R5509BUD BCOOO6V CITY OF BROOKL , , CENTER 8/25/2 s 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 10 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 2,880 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 1,610 1,954 1,440 941 225 225 6150 WORKER'S COMPENSATION 1,610 1,954 1,440 941 225 225 6099 PERSONAL SERVICES 74,064 69,988 72,794 25,398 46,630 46,630 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 2,733 2,259 3,000 1,060 1,500 1,500 6202 COPYING SUPPLIES 501 1,500 1,500 6200 OFFICE SUPPLIES 2,733 2,259 3,000 1,561 3,000 3,000 6210 OPERATING SUPPLIES 6215 SHOP MATERIALS 60 26 50 50 50 6216 CHEMICALS /CHEMICAL PRODUCTS 210 139 450 200 200 6217 SAFETY SUPPLIES 113 228 300 69 300 300 6219 GENERAL OPERATING SUPPLIES 1,816 11 3 6210 OPERATING SUPPLIES 2,200 404 800 72 550 550 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 2,003 1,199 2,600 859 2,600 2,600 6225 PARK & LANDSCAPE MATERIALS 105 6226 SIGNS & STRIPING MATERIALS 100 100 100 6227 PAINT SUPPLIES 69 100 100 6220 REPAIR & MAINT SUPPLIES 2,108 1,268 2,700 859 2,800 2,800 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 124 200 200 6230 REPAIR & MAINT SUPPLIES -OTHER 124 200 200 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 87 6242 MINOR EQUIPMENT 15,496 6240 SMALL TOOLS & MINOR EQUIPMENT 87 15,496 6199 SUPPLIES 7,128 19,427 6,500 2,617 6,550 6,550 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES R5509BUD BC0006V CITY OF BROOKL , , CENTER 8 /25 /k-,i 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 11 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6303 LEGAL SERVICES 83 1,500 1,500 6307 PROFESSIONAL SERVICES 189 6300 PROFESSIONAL SERVICES 272 1,500 1,500 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 3,118 2,577 3,200 1,239 3,660 3,660 6322 POSTAGE 272 193 350 191 300 300 6320 COMMUNICATIONS 3,390 2,771 3,550 1,430 3,960 3,960 6330 TRANSPORTATION 6340 ADVERTISING 6349 OTHER ADVERTISING 7,245 6,346 8,500 6,416 8,000 8,000 6340 ADVERTISING 7,245 6,346 8,500 6,416 8,000 8,000 6350 PRINTING AND DUPLICATING 6351 PRINTING 949 6350 PRINTING AND DUPLICATING 949 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 10,452 7,843 13,435 2,571 3,397 3,397 6362 PROPERTY INSURANCE 5,828 4,999 6,825 2,863 5,298 5,298 6366 MACHINERY BREAKDOWN INSURANCE 615 494 822 290 532 532 6360 INSURANCE 16,896 13,336 21,082 5,724 9,227 9,227 6380 UTILITY SERVICES 6381 ELECTRIC 14,559 13,246 14,700 8,581 14,700 14,700 6382 GAS 24,130 14,546 26,000 16,727 26,000 26,000 6383 WATER 952 869 925 490 1,210 1,210 6384 REFUSE DISPOSAL 6,587 6,445 8,400 3,684 8,400 8,400 6385 SEWER 1,836 1,770 1,800 985 2,200 2,200 6386 STORM SEWER 729 1,316 1,400 750 1,600 1,600 6389 STREET LIGHTS 250 127 300 300 6380 UTILITY SERVICES 48,793 38,442 53,225 31,342 54,410 54,410 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 8,007 4,783 8,500 5,438 8,900 8,900 6403 BLDGS /FACILITIES MAINT SERVICE 2,978 3,200 3,200 6409 OTHER REPAIR & MAINT SVCS 7,157 9,308 8,500 872 1,600 1,600 6400 REPAIR & MAINT SERVICES 15,163 14,090 17,000 9,287 13,700 13,700 R5509BUD BCOOO6V CITY OF BROOKL . N CENTER 8 /25 /k��J 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 12 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6410 RENTALS 6413 OFFICE EQUIPMENT 733 1,711 3,000 3,000 6415 OTHER EQUIPMENT 2,254 1,500 1,000 1,000 6410 RENTALS 2,254 - 733 1,500 1,711 4,000 4,000 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,000 6435 CREDIT CARD FEES 11,545 8,312 6,500 9,200 9,200 6436 UNCOLLECTIBLE CHECKS /DEBTS 2,134- 9,288 6438 CASH SHORT (OVER) 47- 12 37- 6430 MISCELLANEOUS 9,364 18,612 6,463 9,200 9,200 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 290 109 6449 OTHER CONTRACTUAL SERVICE 144,217 7,101 3,722 7,300 7,300 6440 OTHER EXPENSES 144,507 7,210 3,722 7,300 7,300 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 28,235 28,845 34,000 80,519 145,014 145,014 6494.1 ASSET THRESHOLD CHANGE EXPENSE 91,049 6494 DEPRECIATION EXPENSE 28,235 119,894 34,000 80,519 145,014 145,014 6490 OTHER MISC COSTS /EXPENSES 28,235 119,894 34,000 80,519 145,014 145,014 6299 OTHER CHARGES & SERVICES 276,796 221,435 138,857 146,887 256,311 256,311 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6580 INFORMATION SYSTEMS 1,600 1,028 6501 CAPITAL OUTLAY 1,600 1,028 6500 CAPITAL OUTLAY 1,600 1,028 6001 EXPENDITURES /EXPENSES 357,988 310,850 219,751 175,930 309,491 309,491 4000 REVENUES AND EXPENSES 573,496- 310,868- 515,105- 288,610- 463,081- 463,081- 49853 EBHC- CATERING OPERATIONS 573,496- 310,868- 515,105- 288,610- 463,081- 463,081- 49854 EBHC -OFFICE RENTAL 4000 REVENUES AND EXPENSES R5509BUD BC0006V CITY OF BROOKL r N CENTER 8 /25 /2uvd 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 13 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4800 EBHC 4830 OFFICE RENTAL 4831 OFFICE RENTALS 62,629- 62,620- 61,425- 41,009- 58,656- 58,656- 4830 OFFICE RENTAL 62,629- 62,620- 61,425- 41,009- 58,656- 58,656- 4800 EBHC 62,629- 62,620- 61,425- 41,009- 58,656- 58,656- , 4900 OTHER FINANCING SOURCES 4001 REVENUES 62,629- 62,620- 61,425- 41,009- 58,656- 58,656- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES 6 SALARIES -FT EMPLOYEES 2,010 3,048 3,000 768 6103 WAGES -PART TIME EMPLOYEES 2,588 2,884 3,000 942 3,000 3,000 6100 WAGES AND SALARIES 4,598 5,932 6,000 1,710 3,000 3,000 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 230 328 331 95 166 166 6125 FICA 332 375 459 102 186 186 6126 MEDICARE CONTRIBUTIONS 49 24 44 44 6120 RETIREMENT CONTRIBUTIONS 562 751 790 221 396 396 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 480 6130 INSURANCE BENEFITS 480 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 116 192 142 73 142 142 6150 WORKER'S COMPENSATION 116 192 142 73 142 142 6099 PERSONAL SERVICES 5,277 6,876 7,412 2,004 3,538 3,538 6199 SUPPLIES 6210 OPERATING SUPPLIES 6217 SAFETY SUPPLIES 62 6219 GENERAL OPERATING SUPPLIES 257 359 350 443 425 425 R5509BUD BCOOO6V CITY OF BROOKS... CENTER 8/25/'`4 , 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 14 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6210 OPERATING SUPPLIES 257 359 350 505 425 425 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 1,373 532 1,000 521 6,500 6,500 6225 PARK & LANDSCAPE MATERIALS 115 50 50 50 6226 SIGNS & STRIPING MATERIALS 50 50 50 6227 PAINT SUPPLIES 68 100 134 100 100 6220 REPAIR & MAINT SUPPLIES. 1,373 715 1,200 655 6,700 6,700 6230 REPAIR & MAINT SUPPLIES -OTHER 6239 OTHER REPAIR & MAINT SUPPLIES 58 6230 REPAIR & MAINT SUPPLIES -OTHER 58 6240 SMALL TOOLS & MINOR EQUIPMENT 6199 SUPPLIES 1,688 1,074 1,550 1,160 7,125 7,125 6299 OTHER CHARGES & SERVICES 6300 PROFESSIONAL SERVICES 6320 COMMUNICATIONS 6321 TELEPHONE /PAGERS 37 60 6320 COMMUNICATIONS 37 60 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 234 186 392 138 204 204 6362 PROPERTY INSURANCE 1,864 2,028 1,926 1,298 2,407 2,407 6366 MACHINERY BREAKDOWN INSURANCE 195 200 244 131 242 242 6360 INSURANCE 2,294 2,414 2,562 1,567 2,853 2,853 6380 UTILITY SERVICES 6382 GAS 1,576 1,068 1,650 1,251 1,925 1,925 6383 WATER 106 106 125 62 125 125 6384 REFUSE DISPOSAL 832 705 800 524 800 800 6385 SEWER 200 212 250 127 290 290 6380 UTILITY SERVICES 2,714 2,091 2,825 1,964 3,140 3,140 6400 REPAIR & MAINT SERVICES A 6402 EQUIPMENT SERVICES 392 1,739 1,200 6403 BLDGS /FACILITIES MAINT SERVICE 1,419 1,500 1,500 Y 6409 OTHER REPAIR & MAINT SVCS 359 269 R5509BUD BC0006V CITY OF BROOKL ... CENTER 8/25/2_., 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 15 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6415 OTHER EQUIPMENT 2,003 6400 REPAIR & MAINT SERVICES 751 2,009 1,200 3,422 1,500 1,500 6420 IS SERVICES /LICENSES /FEES 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 5,674 5,263 4,800 3,291 5.640 5,640 6449 OTHER CONTRACTUAL SERVICE 4,479 4,443 4,950 2,924 6440 OTHER EXPENSES 10,153 9,705 9,750 6,215 5,640 5,640 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 3,812 3,812 3,812 19,687 35,799 35,799 6494.1 ASSET THRESHOLD CHANGE EXPENSE 30,492 6494 DEPRECIATION EXPENSE 3,812 34,304 3,812 19,687 35,799 35,799 6490 OTHER MISC COSTS /EXPENSES 3,812 34,304 3,812 19,687 35,799 35,799 6299 OTHER CHARGES & SERVICES 19,724 50,560 20,209 32,856 48,932 48,932 6500 CAPITAL OUTLAY 6001 EXPENDITURESIEXPENSES 26,688 58,510 29,171 36,020 59,595 59,595 4000 REVENUES AND EXPENSES 35,940- 4,110- 32,254- 4,989- 939 939 49854 EBHC - OFFICE RENTAL 35,940- 4,110- 32,254- 4,989- 939 939 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 92,483- 29,150- 26,400- 22,880- - 27,400- 27,400- 4812 FACILITY RENTALS 16,372- 9,110- 7,800- 4,150- 7,800- 7,800- 4813 MERCHANDISE SALES 279- 4814 EQUIPMENT RENTALS 3,394- 1,965- 2,500- 915- 1,600- 1,600- 4815 MISCELLANEOUS 563- 424- 115- 4810 INN ON THE FARM 113,090- 40,649- 36,700- 28,060- 36,800- 36,800- R5509BUD BCOUO6V CITY OF BROOKL... CENTER 8/25/2,_.. 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 16 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 4800 EBHC 113,090- 40,649- 36,700- 28,060- 36,800- 36,800- 4900 OTHER FINANCING SOURCES 5550 DIRECT COST OF SALES - ' 5580 COST OF GOODS SOLD 5586 COST OF SALES -MISC 7,445 6,319 5580 COST OF GOODS SOLD 7,445 6,319 5550 DIRECT COST OF SALES 7,445 6,319 b 4001 REVENUES 105,645- 40,649- 30,381- 28,060- 36,800- 36,800- 6001 EXPENDITURES /EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES & SALARIES -FT EMPLOYEES 10,782 5,823 4,500 2,765 6102 OVERTIME -FT EMPLOYEES 177 34 6103 WAGES -PART TIME EMPLOYEES 40,625 18,576 12,111 7,374 12,111 12,111 6104 OVERTIME -PART TIME EMPLOYEES 98 6100 WAGES AND SALARIES 51,681 24,433 16,611 10,139 12,111 12,111 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 2,278 1,183 918 400 670 670 6125 FICA 3,933 1,602 1,271 612 751 751 6126 MEDICARE CONTRIBUTIONS 207 143 176 176 6120 RETIREMENT CONTRIBUTIONS 6,211 2,992 2,189 1,155 1,597 1,597 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 1,356 720 6130 INSURANCE BENEFITS 1,356 720 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 1,707 865 11 6140 UNEMPLOYMENT COMPENSATION 1,707 865 11 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 713 496 395 210 571 571 6150 WORKER'S COMPENSATION 713 496 395 210 571 571 R5509BUD BCOOO6V CITY OF BROOKL , .. CENTER 8/25/2u- 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 17 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6099 PERSONAL SERVICES 61,669 28,785 19,915 11,516 14,279 14,279 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 162 3 150 100 100 6200 OFFICE SUPPLIES 162 3 150 100 100 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 41 19 150 28 150 150 6214 CLOTHING & PERSONAL EQUIPMENT 30 6215 SHOP MATERIALS 24 15 6216 CHEMICALS /CHEMICAL PRODUCTS 200 200 200 6217 SAFETY SUPPLIES 98 100 100 100 6219 GENERAL OPERATING SUPPLIES 1,277 2,656 3,500 229 2,800 2,800 6210 OPERATING SUPPLIES 1,371 2,789 3,950 257 3,250 3,250 6220 REPAIR & MAINT SUPPLIES 6223 BUILDINGS & FACILITIES 1,586 3,769 2,500 635 2,500 2,500 6225 PARK & LANDSCAPE MATERIALS 147 201 150 68 150 150 6226 SIGNS & STRIPING MATERIALS 64 6227 PAINT SUPPLIES 434 300 344 450 450 6220 REPAIR & MAINT SUPPLIES 1,733 4,467 2,950 1,048 3,100 3,100 6230 REPAIR & MAINT SUPPLIES -OTHER 6237 LAUNDRY SUPPLIES 493 250 27 150 150 6239 OTHER REPAIR & MAINT SUPPLIES 332 9 300 300 6230 REPAIR & MAINT SUPPLIES -OTHER 825 9 250 27 450 450 6240 SMALL TOOLS & MINOR EQUIPMENT 6241 SMALL TOOLS 14 100 42 6240 SMALL TOOLS & MINOR EQUIPMENT 14 100 42 6199 SUPPLIES 4,092 7,282 7,400 1,374 6,900 6,900 6299 OTHER CHARGES & SERVICES e� 6300 PROFESSIONAL SERVICES 6320 COMMUNICATIONS �1� 6321 TELEPHONE /PAGERS 2,906 2,234 2,600 1,074 3,310 3,310 R5509BUD BCOOO6V CITY OF BROOKL ... CENTER 8/25/2'u- 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 18 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actu Bud v - Budget 6322 POSTAGE 98 6320 COMMUNICATIONS 3,004 2,234 2,600 1,074 3,310 3,310 6340 ADVERTISING 4 ..�..,x, •.. v< , , ,. -m,_ :_. 6341 PERSONNEL ADVERTISING 157 300 300 300 6349 OTHER ADVERTISING 1,287 6340 ADVERTISING 1,444 300 300 300 6350 PRINTING AND DUPLICATING 6351 PRINTING 872 34 6350 PRINTING AND DUPLICATING 872 34 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,067 761 1,200 431 741 741 6362 PROPERTY INSURANCE 2,924 3,246 3,600 2,034 3,749 3,749 6366 MACHINERY BREAKDOWN INSURANCE 308 322 340 206 376 376 6360 INSURANCE 4,298 4,329 5,140 2,671 4,866 4,866 6380 UTILITY SERVICES 6381 ELECTRIC 8,294 6,455 6,000 4,182 6,000 6,000 6382 GAS 8,845 4,670 7,000 5,168 8,200 8,200 6383 WATER 255 182 400 111 300 300 6384 REFUSE DISPOSAL 559 690 750 503 750 750 6385 SEWER 381 186 200 138 350 350 6380 UTILITY SERVICES 18,333 12,182 14,350 10,101 15,600 15,600 I 6400 REPAIR & MAINT SERVICES 6402 EQUIPMENT SERVICES 4,139 3,274 3,500 146 1,750 1,750 6403 BLDGS /FACILITIES MAINT SERVICE 1,326 1,750 1,750 6409 OTHER REPAIR & MAINT SVCS 893 2,737 1,500 125 150 150 6400 REPAIR & MAINT SERVICES 5,031 6,011 5,000 1,597 3,650 3,650 6410 RENTALS 6415 OTHER EQUIPMENT 20 100 103 100 100 6410 RENTALS 20 100 103 100 100 6420 IS SERVICES /LICENSES /FEES A 6428 PROTECTION SERVICES 2,894 3,500 2,173 2,800 2,800 6420 IS SERVICES/LICENSES /FEES 2,894 3,500 2,173 2,800 2,800 6430 MISCELLANEOUS R5509BUD BCOOO6V CITY OF BROOKL , .. CENTER 8/25/2..., 14:19:55 Fiscal Period: 8 / 03 Budget Report Page - 19 Level Of Rollup 9 2001 2002 2003 8/31/2003 2004 2004 Actual Actual Final YTD Requested Recommended Object Code / Description Amount Amount Budget Actual Budget Budget 6434 DUES & SUBSCRIPTIONS 106 6435 CREDIT CARD FEES 1,447 187 129 6436 UNCOLLECTIBLE CHECKS /DEBTS 361 126- 6438 CASH SHORT (OVER) 24- 6430 MISCELLANEOUS 1,890 61 129 6440 OTHER EXPENSES 6441 LICENSES, TAXES & FEES 10,336 10,438 10,200 6,217 10,534 10,534 6449 OTHER CONTRACTUAL SERVICE 13,862 5,719 6,500 3,549 5,200 5,200 6440 OTHER EXPENSES 24,198 16,157 16,700 9,766 15,734 15,734 6490 OTHER MISC COSTS /EXPENSES 6494 DEPRECIATION EXPENSE 49,349 88,576 49,350 50,378 88,576 88,576 6494.1 ASSET THRESHOLD CHANGE EXPENSE 24,700 6494 DEPRECIATION EXPENSE 49,349 113,276 49,350 50,378 88,576 88,576 6490 OTHER MISC COSTS /EXPENSES 49,349 113,276 49,350 50,378 88,576 88,576 6299 OTHER CHARGES & SERVICES 108,440 157,178 97,040 77,993 134,936 134,936 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6001 EXPENDITURES /EXPENSES 174,201 193,245 124,355 90,882 156,115 156,115 4000 REVENUES AND EXPENSES 68,556 152,596 93,974 62,822 119,315 119,315 49855 EBHC -INN ON THE FARM 68,556 152,596 93,974 62,822 119,315 119,315 498 CONVENTION CENTER OPERATIONS 130,742- 775,844 382,409 193,257 407,644 407,644 61700 EARLE BROWN HERITAGE CENTER 130,742- 775,844 382,409 193,257 407,644 407,644 V