The URL can be used to link to this page

Home My WebLink About2012 Budget 05 - Capital Project Funds City of Broo Center 2012 Bud-get Capital Proieets Funds The Capital Projects set of funds is used to record and keep track of costs for major projects. Often these projects will cross fiscal years and must be kept separate for assessment accounting or funding purposes. Some of the funds act as repositories for capital replacement funds for major assets, such as the Earle Brown Heritage Center or the City's investment in technology. The Capital Projects Funds for 2012 are: • Capital Improvements Fund • Municipal State Aid Construction Fund • Infrastructure Construction Fund • EBHC Capital Projects Fund • Street Reconstruction Fund • Technology Fund 283 This page has been left blank intentionally. 284 City of Brooklyn Center 2012 Budget FUND: Capital Improvements Fund—40100 DEPT/ACTIVITY/PROJECT: Capital Improvements Fund—40100 PROFILE The Capital Improvements Fund provides for the accounting of sources (revenues) and uses (expenditures) of monies available from a number of sources such as the General Fund, enterprise funds and public utility funds. Available funds are used to finance government building and park improvements and to purchase land for public uses such as parks or other public facilities. PROJECTS AND PROGRAMS The City's Capital Improvement Program (CIP) includes a multi-year projection of capital improvement needs for the park system. Projects proposed for 2012 as part of the CIP include the following: • Evergreen Park Fence and Court Reconstruction • Evergreen Park Athletic Field Lighting Replacement • Centennial Park Youth Soccer Field • Orchard Lane Park Shelter and Improvements In order to provide proper cash flows for this fund it is suggested that the following strategy be continued and increased from 2011. The contribution from the BC Liquor Fund to the Capital Improvements Fund should be increased from $ 160,000 per year to $200,000. DEPARTMENTAL GOALS Continue making park improvements in accordance with the multi-year plan and maintain and improve public facilities to provide for adequate function and accessibility to all. PERSONNEL LEVELS No personnel are assigned to this division. CAPITAL OUTLAY Projects as noted above and listed in the 2012 Capital Improvement Program. 285 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11130/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 40100 CAPITAL IMPROVEMENTS FUND 40100 CAPITAL IMPROVEMENTS FUND 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 4320 MISC FEDERAL GRANTS 4,755- 4310 FEDERAL REVENUE 4,755- 4340 STATE REVENUE 4370 OTHER GRANTS/AID 4300 INTERGOVERNMENTAL REVENUE 4,755- 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 2,840- 574- 250- 1,186- 4605 UNREALIZED INVESTMENT GAIN/LOS 115- 929 4606 OTHER REVENUE 263- 238- 4600 MISCELLANEOUS REVENUE 2,955- 92 250- 1,424- 4599 MISCELLANEOUS REVENUE 2,955- 92 250- 1,424- 4900 OTHER FINANCING SOURCES 4915 TRANSFERS IN 9,138- 280,355- 300,000- 4915.1 TRANSFERS FROM LIQUOR FUND 265,490- 230,199- 160,000- 200,000- 200,000- 4915.2 TRANSFERS IN FROM GENERAL FUND 115,900- 4921 REFUNDS&REIMBURSEMENTS 188- 4900 OTHER FINANCING SOURCES 274,815- 626,454- 460,000- 200,000- 200,000- 4001 REVENUES 277,771- 626,362- 460,250- 6,178- 200,000- 200,000- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6120 RETIREMENT CONTRIBUTIONS 6150 WORKER'S COMPENSATION 6199 SUPPLIES 6210 OPERATING SUPPLIES 6220 REPAIR&MAINT SUPPLIES 6240 SMALL TOOLS&MINOR EQUIPMENT 6242 MINOR EQUIPMENT 684 6240 SMALL TOOLS&MINOR EQUIPMENT 684 6199 SUPPLIES 684 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6302 ARCH,ENG&PLANNING 1,323 9,019 6307 PROFESSIONAL SERVICES 132 3,242 6300 PROFESSIONAL SERVICES 1,454 12,262 286 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6330 TRANSPORTATION 6340 ADVERTISING 6342 LEGAL NOTICES 908 328 459 6340 ADVERTISING 908 328 459 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6380 UTILITY SERVICES 6400 REPAIR&MAINT SERVICES 6410 RENTALS 6420 IS SERVICES/LICENSES/FEES 6440 OTHER EXPENSES 6470 TRANSFERS AND OTHER USES 6472 ENGINEERING SERVICE TRANSFER 3,390 18,661 6470 TRANSFERS AND OTHER USES 3,390 18,661 6299 OTHER CHARGES&SERVICES 5,752 31,251 459 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6520 BUILDINGS&FACILITIES 22,311 6530 IMPROVEMENTS 462,732 549,534 350,000 101,387 315,000 315,000 6501 CAPITAL OUTLAY 485,043 549,534 350,000 101,387 315,000 315,000 6602 OTHER DEBT-PRINCIPAL 100,000 6612 OTHER DEBT-INTEREST 6,000 6500 CAPITAL OUTLAY 485,043 549,534 456,000 101,387 315,000 315,000 6001 EXPENDITURES/EXPENSES 491,479 580,785 456,000 101,846 315,000 315,000 4000 REVENUES AND EXPENSES 213,708 45,577- 4,250- 95,668 115,000 115,000 40100 CAPITAL IMPROVEMENTS FUND 213,708 45,577- 4,250- 95,668 115,000 115,000 40100 CAPITAL IMPROVEMENTS FUND 213,708 45,577- 4,250- 95,668 115,000 115,000 287 This page has been left blank intentionally. 288 City. of Broo Center 2012 Budget FUND: Municipal State Aid Construction Fund—40200 DEPT/ACTIVITY/PROJECT: Municipal State Aid Construction—40200 PROFILE The Municipal State Aid Fund is used to account for monies received from the State as a portion of shared taxes collected from gasoline taxes. From this fund, the City is permitted to pay for certain construction and maintenance activities. PROJECTS AND PROGRAMS Several projects are scheduled in the Capital Improvement Program (CIP) for the period of 2012 through 2026. Municipal State Aid allotment payments from Mn/DOT provide funding for maintenance and reconstruction of MSA designated routes within the City. DEPARTMENTAL GOALS • Systematically maintain and rehabilitate as necessary the system of State Aid Streets in accordance with state requirements. EXPENDITURE DETAILS 6224 Street Maintenance Materials This item represents the bulk of the materials used to maintain streets designated as municipal state aid routes. Materials include: hot mix, cold mix, road oil, crack sealant, sand, rock and concrete. 6226 Signs and Striping Material Includes the cost of upgrading sign materials pertaining to current retroreflectivity standards, posts, preformed pavement markings, paint, etc., used for fabricating and installing signs and pavement markings on streets designated as municipal state aid routes. 6404 Street Maintenance Services Provides for annual sealcoating on streets designated as municipal state aid routes. Project areas are forecast over the next five years using a GIS database in conjunction with the street reconstruction program. Costs in this area have also increased due to increases in price for bituminous products. 6530 Improvements Capital infrastructure improvements for street reconstruction as identified in the Capital Improvement Program. Because the Unity Avenue and Logan Neighborhood projects were combined in 2011 there are no major Improvement projects scheduled for 2012. CAPITAL OUTLAY Projects as noted in the 2012 Capital Improvement Program. 289 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/3012011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 40200 MUNICIPAL STATE AID CONSTRUCT 40200 MUNICIPAL STATE AID CONSTRUCT 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4340 STATE REVENUE 4343 MUNICIPAL STATE AID,STREETS-M 90,000- 90,000- 90,000- 90,000- 90,000- 90,000- 4344 MUNICIPAL STATE AID,STREETS-C 709,455- 1,448,939- 688,973- 579,751 737,702- 737,702- 4340 STATE REVENUE 799,455- 1,538,939- 778,973- 489,751 827,702- 827,702- 4360 COUNTY GRANTS 4362 COUNTY GRANTS/AID 40,017- 4360 COUNTY GRANTS 40,017- 4370 OTHER GRANTS/AID 4300 INTERGOVERNMENTAL REVENUE 839,472- 1,538,939- 778,973- 489,751 827,702- 827,702- 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 6,993- 233- 8- 4605 UNREALIZED INVESTMENT GAIN/LOS 262- 4600 MISCELLANEOUS REVENUE 7,255- 233- 8- 4599 MISCELLANEOUS REVENUE 7,255- 233- 8- 4900 OTHER FINANCING SOURCES 4001 REVENUES 846,727- 1,539,172- 778,973- 489,744 827,702- 827,702- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6120 RETIREMENT CONTRIBUTIONS 6150 WORKER'S COMPENSATION 6199 SUPPLIES 6210 OPERATING SUPPLIES 6220 REPAIR&MAINT SUPPLIES 6224 STREET MAINT MATERIALS 28,594 32,015 32,000 29,126 32,000 32,000 6226 SIGNS&STRIPING MATERIALS 4,785 10,827 10,800 10,886 10,800 10,800 6220 REPAIR&MAINT SUPPLIES 33,379 42,842 42,800 40,012 42,800 42,800 6199 SUPPLIES 33,379 42,842 42,800 40,012 42,800 42,800 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6330 TRANSPORTATION 6340 ADVERTISING 290 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6400 REPAIR&MAINT SERVICES 6404 STREET MAINT SERVICES 71,052 86,641 47,200 26,889 47,200 47,200 6400 REPAIR&MAINT SERVICES 71,052 86,641 47,200 26,889 47,200 47,200 6440 OTHER EXPENSES 6470 TRANSFERS AND OTHER USES 6476 CAPITAL PROJECT FUND TRANSFER 983,000 233,529 6470 TRANSFERS AND OTHER USES 983,000 233,529 6299 OTHER CHARGES&SERVICES 71,052 86,641 1,030,200 260,419 47,200 47,200 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 725,626 1,448,176 6501 CAPITAL OUTLAY 725,626 1,448,176 6500 CAPITAL OUTLAY 725,626 1,448,176 6001 EXPENDITURES/EXPENSES 830,056 1,577,659 1,073,000 300,430 90,000 90,000 4000 REVENUES AND EXPENSES 16,671- 38,487 294,027 790,174 737,702- 737,702- 40200 MUNICIPAL STATE AID CONSTRUCT 16,671- 38,487 294,027 790,174 737,702- 737,702- 40200 MUNICIPAL STATE AID CONSTRUCT 16,671- 38,487 294,027 790,174 737,702- 737,702- 291 This page has been left blank intentionally. 292 City of Brook& Center 2012 fudget FUND: Infrastructure Construction Fund—40700 DEPT/ACTIVITY/PROJECT: Infrastructure Construction Fund—40700 PROFILE The Infrastructure Construction Fund was formerly titled the Special Assessment Construction Fund and will continue to account for the financing of improvements funded all or in part by special assessments and transfers from the public utility funds. PROJECTS AND PROGRAMS Projects scheduled in 2012 are listed and described in the Capital Improvement Program section of the Budget. They include: • Storm Water Ponds Dredging and Restoration (Ponds 18-001, 46-001, 12-002, 12-003 and 12-005) • Connections Shingle Creek Restoration Project • Earle Brown/Opportunity Street Light Replacement • 18" Trunk Sanitary Sewer Replacement— Shingle Creek Crossings DEPARTMENTAL GOALS • Reconstruct/rehabilitate streets and utilities to improve infrastructure. • Enhance the appearance of neighborhoods. • Work cooperatively with other agencies to solve mutual problems that affect the City's infrastructure. PERSONNEL LEVELS No personnel are assigned to this division. CAPITAL OUTLAY Projects listed in the 2012 Capital Improvement Program. 293 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/3012011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 40700 INFRASTRUCTURE CONSTRUCTION 40700 INFRASTRUCTURE CONSTRUCTION 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 4320 MISC FEDERAL GRANTS 2,000,000- 636,055 4310 FEDERAL REVENUE 2,000,000- 636,055 4340 STATE REVENUE 4360 COUNTY GRANTS 4362 COUNTY GRANTS/AID 656,689- 88,290 120,000- 120,000- 4360 COUNTY GRANTS 656,689- 88,290 120,000- 120,000- 4370 OTHER GRANTS/AID 4373 OTHER GRANTS/AID 324,992- 219,755 263,000- 263,000- 4370 OTHER GRANTS/AID 324,992- 219,755 263,000- 263,000- 4300 INTERGOVERNMENTAL REVENUE 2,981,681- 944,101 383,000- 383,000- 4399 CHARGES FOR SERVICES 4430 CHGS FOR SERVICES-PUBLIC WORKS 4431 WEED CUTTING CHARGES 23,530- 23,808- 50,000- 84,384- 4434 DISEASED TREE REMOVAL 23,799- 12,397- 20,000- 30,942- 4430 CHGS FOR SERVICES-PUBLIC WORKS 47,329- 36,206- 70,000- 115,326- 4399 CHARGES FOR SERVICES 47,329- 36,206- 70,000- 115,326- 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4601 SPECIAL ASSESSMENTS 168,089- 727,758- 1,122,968- 995,498- 4602 SPECIAL ASSESS-PENALTIES&INT 5,262- 3,394- 44- 4606 OTHER REVENUE 1,174- 1,525- 1,013- 75,000- 75,000- 4607 SPEC ASSESS INTEREST 1,659- 463- 296- 4600 MISCELLANEOUS REVENUE 176,185- 733,140- 1,122,968- 996,850- 75,000- 75,000- 4599 MISCELLANEOUS REVENUE 176,185- 733,140- 1,122,968- 996,850- 75,000- 75,000- 4900 OTHER FINANCING SOURCES 4915 TRANSFERS IN 92,835- 7,621,500- 233,529- 1,157,000- 1,157,000- 4900 OTHER FINANCING SOURCES 92,835- 7,621,500- 233,529- 1,157,000- 1,157,000- 4001 REVENUES 223,514- 3,843,863- 8,814,468- 401,605- 1,615,000- 1,615,000- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6103 WAGES-PART TIME EMPLOYEES 706 6104 OVERTIME-PART TIME EMPLOYEES 7 6100 WAGES AND SALARIES 713 6120 RETIREMENT CONTRIBUTIONS 6125 FICA 44 6126 MEDICARE CONTRIBUTIONS 10 6120 RETIREMENT CONTRIBUTIONS 55 294 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3 6150 WORKER'S COMPENSATION 3 6099 PERSONAL SERVICES 770 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 322 204 6200 OFFICE SUPPLIES 322 204 6210 OPERATING SUPPLIES 6214 CLOTHING&PERSONAL EQUIPMENT 160 6219 GENERAL OPERATING SUPPLIES 294 6210 OPERATING SUPPLIES 294 160 6220 REPAIR&MAINT SUPPLIES 6230 REPAIR&MAINT SUPPLIES-OTHER 6240 SMALL TOOLS&MINOR EQUIPMENT 6199 SUPPLIES 616 160 204 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6302 ARCH,ENG&PLANNING 445,634 546,814 954,250 72,729 6303 LEGAL SERVICES 19,561 3,199 2,500 1,628 6307 PROFESSIONAL SERVICES 45,907 27,376 30,000 6300 PROFESSIONAL SERVICES 511,102 577,388 986,750 74,357 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 772 816 789 6320 COMMUNICATIONS 772 816 789 6330 TRANSPORTATION 6333 FREIGHT/DRAYAGE 45 6330 TRANSPORTATION 45 6340 ADVERTISING 6342 LEGAL NOTICES _ 2,350 2,001 1,470 6340 ADVERTISING 2,350 2,001 1,470 6350 PRINTING AND DUPLICATING 6400 REPAIR&MAINT SERVICES 6405 PARK&LANDSCAPE SERVICES 57,462 53,724 315,000 61,361 6400 REPAIR&MAINT SERVICES 57,462 53,724 315,000 61,361 6430 MISCELLANEOUS 6434 DUES&SUBSCRIPTIONS 82 6438 CASH SHORT(OVER) 15- 17 4- 6430 MISCELLANEOUS 15- 99 4- 6440 OTHER EXPENSES 295 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6441 LICENSES,TAXES&FEES 4,575 1,750 950 6442 COURT AWARDS/SETTLEMENTS 160,800 6440 OTHER EXPENSES 165,375 1,750 950 6460 CENTRAL GARAGE CHARGES 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 413,910 6472 ENGINEERING SERVICE TRANSFER 314,574 388,482 6470 TRANSFERS AND OTHER USES 314,574 388,482 413,910 6490 OTHER MISC COSTS/EXPENSES 6499 EXPENSES REIMBURSED 3,604,491- 5,791,538- 134,052- 6490 OTHER MISC COSTS/EXPENSES 3,604,491- 5,791,538- 134,052- 6299 OTHER CHARGES&SERVICES 2,552,871- 4,767,233- 1,715,660 4,871 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 3,104,400 9,800,608 7,826,840 6,952,193 1,615,000 1,615,000 6501 CAPITAL OUTLAY 31104,400 9,800,608 7,826,840 6,952,193 1,615,000 1,615,000 6500 CAPITAL OUTLAY 3,104,400 9,800,608 7,826,840 6,952,193 1,615,000 1,615,000 6600 DEBT SERVICE 6621 PAYING AGENT/OTHER FEES 237 477 1,119 6600 DEBT SERVICE 237 477 1,119 6001 EXPENDITURES/EXPENSES 553,153 5,034,012 9,542,500 6,958,388 1,615,000 1,615,000 4000 REVENUES AND EXPENSES 329,639 1,190,149 728,032 6,556,783 40700 INFRASTRUCTURE CONSTRUCTION 329,639 1,190,149 728,032 6,556,783 40700 INFRASTRUCTURE CONSTRUCTION 329,639 1,190,149 728,032 6,556,783 296 City of Brook&n Center 2012 Budget FUND: Earle Brown Heritage Center—40800 DEPT/ACTIVITY/PROJECT: Capital Projects This fund provides for the replacement of fully depreciated or obsolete capital items and new capital purchases. CAPITAL OUTLAY—Convention Center 6520 Buildings and Facilities Carriage Hall Wall Panels Unit Cost: $108,000 Less Trade-in: $-0- Total Cost: $108,000 Carriage Hall Area Carpet Unit Cost: $70,000 Less Trade-in: $-0- Total Cost: $ 70,000 Garden City/Harvest Prefunction Area Carpet Unit Cost: $20,000 Less Trade-in: $-0- Total Cost: $ 20,000 6540 Equipment and Machinery Multifunction Printer/Copier/Scanner/Fax Unit Cost: $15,000 Less Trade-in: $-0- Total Cost: $15,000 Electronic Reader Boards for Signage both Inside and Outside Unit Cost: $128,000 Less Trade-in: $-0- Total Cost: $128,000 297 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 40800 EBHC CAPITAL FUND 40800 EBHC CAPITAL FUND 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4310 FEDERAL REVENUE 4320 MISC FEDERAL GRANTS 19,735- 49,566- 4310 FEDERAL REVENUE 19,735- 49,566- 4300 INTERGOVERNMENTAL REVENUE 19,735- 49,566- 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 3,927- 2,849- 1,116- 2,617- 2,617- 4605 UNREALIZED INVESTMENT GAIN/LOS 229- 1,547 4612 DONATIONS&CONTRIBUTIONS 100,000- 4600 MISCELLANEOUS REVENUE 4,157- 101,302- 1,116- 2,617- 2,617- 4599 MISCELLANEOUS REVENUE 4,157- 101,302- 1,116- 2,617- 2,617- 4900 OTHER FINANCING SOURCES 4915 TRANSFERS IN 300,000- 200,000- 496,310- 4921 REFUNDS&REIMBURSEMENTS 109,632- 150,000- 150,000- 4900 OTHER FINANCING SOURCES 409,632- 200,000- 496,310- 150,000- 150,000- 4001 REVENUES 413,789- 121,037- 200,000- 546,992- 152,617- 152,617- 6001 EXPENDITURES/EXPENSES 6240 SMALL TOOLS&MINOR EQUIPMENT 6243 MINOR COMPUTER EQUIPMENT 13,558 857 6240 SMALL TOOLS&MINOR EQUIPMENT 13,558 857 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 479 13,079 55,205 6300 PROFESSIONAL SERVICES 479 13,079 55,205 6340 ADVERTISING 6342 LEGAL NOTICES 129 6340 ADVERTISING 129 6400 REPAIR&MAINT SERVICES 6420 IS SERVICES/LICENSES/FEES 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6512 LAND IMPROVEMENTS 7,649 6520 BUILDINGS&FACILITIES 136,574 103,149 213,000 658,150 198,000 198,000 6530 IMPROVEMENTS 1,824 6540 EQUIPMENT&MACHINERY 33,709 45,170 234,400 164,677 128,000 128,000 6580 INFORMATION SYSTEMS 15,000 15,000 6501 CAPITAL OUTLAY 172,107 155,967 447,400 822,827 341,000 341,000 6500 CAPITAL OUTLAY 172,107 155,967 447,400 822,827 341,000 341,000 298 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6001 EXPENDITURES/EXPENSES 186,144 169,904 447,400 878,160 341,000 341,000 4000 REVENUES AND EXPENSES 227,645- 48,867 247,400 331,168 188,383 188,383 40800 EBHC CAPITAL FUND 227,645- 48,867 247,400 331,168 188,383 188,383 40800 EBHC CAPITAL FUND 227,645- 48,867 247,400 331,168 188,383 188,383 299 This page has been left blank intentionally. 300 City of Broo� Center 2012 Budget FUND: Street Reconstruction Fund—40900 DEPT/ACTIVITY/PROJECT: Street Reconstruction Fund—40900 PROFILE This fund exists for the accounting of revenues used for the reconstruction of streets. A majority of the revenue for this fund is derived from franchise fees. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY Projects as noted and listed in the 2012 Capital Improvement Program. 301 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 40900 STREET RECONSTRUCTION 40900 STREET RECONSTRUCTION 4000 REVENUES AND EXPENSES 4001 REVENUES 4050 TAXES 4160 GENERAL SALES AND USE TAXES 4181 FRANCHISE FEES 656,772- 647,796- 680,000- 498,378- 680,000- 680,000- 4160 GENERAL SALES AND USE TAXES 656,772- 647,796- 680,000- 498,378- 680,000- 680,000- 4050 TAXES 656,772- 647,796- 680,000- 498,378- 680,000- 680,000- 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 17,047- 8,142- 3,637- 8,766- 2,000- 2,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 705- 3,880 4600 MISCELLANEOUS REVENUE 17,751- 4,262- 3,637- 8,766- 2,000- 2,000- 4599 MISCELLANEOUS REVENUE 17,751- 4,262- 3,637- 8,766- 2,000- 2,000- 4900 OTHER FINANCING SOURCES 4001 REVENUES 674,523- 652,058- 683,637- 507,144- 682,000- 682,000- 6001 EXPENDITURES/EXPENSES 6299 OTHER CHARGES&SERVICES 6470 TRANSFERS AND OTHER USES 6482 MISC TRANSFER OUT 6,349 6470 TRANSFERS AND OTHER USES 6,349 6490 OTHER MISC COSTS/EXPENSES 6299 OTHER CHARGES&SERVICES 6,349 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 643,676 592,575 2,006,000 6501 CAPITAL OUTLAY 643,676 592,575 2,006,000 6500 CAPITAL OUTLAY 643,676 592,575 2,006,000 6001 EXPENDITURES/EXPENSES 650,025 592,575 2,006,000 4000 REVENUES AND EXPENSES 24,498- 59,483- 1,322,363 507,144- 682,000- 682,000- 40900 STREET RECONSTRUCTION 24,498- 59,483- 1,322,363 507,144- 682,000- 682,000- 40900 STREET RECONSTRUCTION 24,498- 59,483- 1,322,363 507,144- 682,000- 682,000- 302 City of Broo Center 2012 Budget FUND: Technology Fund - 41000 DEPT/ACTIVITY/PROJECT: Technology Fund - 41000 PROFILE The Technology Fund was created to provide a mechanism to fund and plan for capital projects related to technology which includes the acquisition and replacement of technology. DEPARTMENTAL GOALS To execute the replacement of major technology components and introduce new major technology as planned. EXPENDITURE DETAILS $ 5,250 Server Hardware (Server Replacements) $ 4,000 Network Hardware (Wireless Access Point Replacements at City Hall) $ 35,000 Security Card System (Expansion at General Fund Buildings) $ 50,000 Security Video Surveillance (Expansion at General Fund Buildings) $ 18,000 Multi-Function Devices (East Fire, Police, Public Works Garage Copier Replacements) $ 43,000 WiMax Fiber Optic Infrastructure $155,250 TOTAL Pursuant to the City Council Resolution No. 2003-219, the City Council must authorize expenditures from this fund through the adoption of specific expenditure authorization or approval of a plan for expenditures from this fund. PERSONNEL LEVELS None 303 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 41000 TECHNOLOGY FUND 41000 TECHNOLOGY FUND 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 2,833- 576- 767- 390- 767- 767- 4605 UNREALIZED INVESTMENT GAIN/LOS 102- 466 4600 MISCELLANEOUS REVENUE 2,935- 110- 767- 390- 767- 767- 4599 MISCELLANEOUS REVENUE 2,935- 110- 767- 390- 767- 767- 4900 OTHER FINANCING SOURCES 4915 TRANSFERS IN 70,000- 70,000- 70,000- 70,000- 70,000- 4900 OTHER FINANCING SOURCES 70,000- 70,000- 70,000- 70,000- 70,000- 4001 REVENUES 72,935- 70,110- 70,767- 390- 70,767- 70,767- 6001 EXPENDITURES/EXPENSES 6199 SUPPLIES 6210 OPERATING SUPPLIES 6220 REPAIR&MAINT SUPPLIES 6240 SMALL TOOLS&MINOR EQUIPMENT 6243 MINOR COMPUTER EQUIPMENT 109,630 11,878 42,240 30,452 9,250 9,250 6240 SMALL TOOLS&MINOR EQUIPMENT 109,630 11,878 42,240 30,452 9,250 9,250 6199 SUPPLIES 109,630 11,878 42,240 30,452 9,250 9,250 6299 OTHER CHARGES&SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 64,668 1,645 6300 PROFESSIONAL SERVICES 64,668 1,645 6340 ADVERTISING 6350 PRINTING AND DUPLICATING 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 8,545 6422 SOFTWARE MAINT 940 6423 LOGIS CHARGES 432 6420 IS SERVICES/LICENSES/FEES 432 9,485 6470 TRANSFERS AND OTHER USES 6299 OTHER CHARGES&SERVICES 65,100 11,130 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6540 EQUIPMENT&MACHINERY 67,385 142,250 145,000 40,797 146,000 146,000 6501 CAPITAL OUTLAY 67,385 142,250 145,000 40,797 146,000 146,000 6500 CAPITAL OUTLAY 67,385 142,250 145,000 40,797 146,000 146,000 304 CITY OF BROOKLYN CENTER Budget Report 2009 2010 2011 11/30/2011 2012 2012 Actual Actual Final YTD Recommended Approved Object Code/Description Amount Amount Budget Actual Budget Budget 6001 EXPENDITURES/EXPENSES 242,115 165,258 187,240 71,250 155,250 155,250 4000 REVENUES AND EXPENSES 169,180 95,148 116,473 70,859 84,483 84,483 41000 TECHNOLOGY FUND 169,180 95,148 116,473 70,859 84,483 84,483 41000 TECHNOLOGY FUND 169,180 95,148 116,473 70,859 84,483 84,483 305 This page has been left blank intentionally. 306