HomeMy WebLinkAbout2012 Budget 08 - Internal Service Funds City of 1�3rookCyn Center
2012 Budget
Internal Service Funds
Internal Service Funds track dollars that come from other sources within the City
operations and fund specific, critical functions of the organization. Revenues and costs
for these services provided to the City organization are tracked separately in order to keep
the costs at a minimum and facilitate funding for legally required benefits or services.
The Internal Service Funds for 2012 are:
• Central Garage Fund
385
This page has been left blank intentionally.
386
City of Brooklyn Center
2012 Budget
FUND: Internal Service Funds-Central Garage—70100
DEPT/ACTIVITY/PROJECT: Central Garage Operations—49951
PROFILE
The Central Garage services and provides fuel for a wide range of vehicles such as fire
trucks, police squad cars, dump trucks, mowers, loaders, pickups and staff cars. The
Central Garage also services minor equipment such as chain saws, weed whips, trailers,
pumps and generators. The Central Garage provides emergency repairs and scheduled
maintenance to keep all City vehicles and equipment operating efficiently.
In addition, the Central Garage coordinates vehicle turnover by determining and charging
departments appropriate monthly amounts to ensure that vehicle replacement funds are
available when vehicles are ready for replacement. On an annual basis, replacement
costs, useful lives and salvage values must be individually determined for the entire fleet
to calculate monthly replacement charges.
The Central Garage's fleet is currently comprised of 141 pieces of capital equipment; an
additional 12 pieces of specialized equipment are also owned and maintained by the
Central Garage. Finally, the Central Garage maintains 104 additional pieces of small
equipment such as small mowers, chain saws, weed trimmers, etc.
DEPARTMENTAL GOALS
• Perform routine and preventive maintenance for the city's vehicles, small
equipment and capital equipment.
• Determine and maintain sufficient cash balances for future replacement of
equipment.
• Purchase new equipment and dispose of old equipment on a scheduled basis.
• Provide departments with detailed monthly billings for fuel usage, repairs and
fixed charges.
EXPENDITURE DETAILS
6212 Motor Fuels
This budget item provides funding for the annual cost of purchasing fuel for the City's
vehicle and equipment fleet. Fuel usage is charged back to individual departments on a
monthly basis. This cost estimate assumes a market rate for fuel of $ 3.55 per gallon in
2012.
6215 Shop Materials
This budget item provides for various small parts used routinely, such as nuts & bolts,
clamps, hoses, wiper blades, etc.
387
6221 Motor Vehicles
This item includes the cost of a variety of parts used in equipment repair and preventative
maintenance. Actual cost varies each year based on amount of repair work required,
accident damage to repair, etc. Cost is charged to repair orders, which are in turn charged
back to the department leasing the vehicle.
6242 Minor Equipment
This item provides for the cost of replacing the Public Works fleet's radios due to the
FCC mandate of migrating the radio system to narrowband in 2012.
6363 Automotive Insurance
This item provides for the cost of insuring the fleet of vehicles and equipment. These
costs are charged back to the department leasing the vehicle. Insurance costs for
equipment (Inland Marine) are included under object cost 6367.
6401 Motor Vehicle Service
This budget item provides funding for equipment repairs provided by outside services.
Examples include body work, transmission overhauls, windshield replacement, and
installation of specialized equipment. Cost is charged to repair orders, which are in turn
charged back to the department leasing the vehicle.
6540 Equipment and Machinery
This budget item provides funding for the purchase of two shop items used in the
performance of heavy vehicle maintenance: a pair of 10-ton capacity portable air jacks,
and, a pair of 12-ton capacity low profile jack stands.
6550 Motor Vehicles
This item includes the scheduled replacement of equipment and vehicles as scheduled in
the Central Garage vehicle fleet replacement cycle. A list of equipment scheduled for
replacement in 2012 is provided on the following page.
PERSONNEL LEVELS
1-Crew Leader
2-Mechanic I
1-Night Service Person
1-Central Garage Administrative Technician
388
CAPITAL OUTLAY
The following equipment and rolling stock items are scheduled replacement in 2012:
City# Dept Description Net Cost
#0019 Parks Bucket Truck w/Aerial $118,000
#0021 Streets Patch Truck $125,000
#0072 Streets Trackless Sidewalk Plow $115,000
40088 Streets Dump Truck $153,000
90208 Parks '/2 Ton Pick Up $ 16,500
90209 Parks Tractor w/Loader $ 35,500
#0259 Parks 72" Groundsmaster Mower $ 20,000
#0300 Police Unmarked Investigation $ 19,500
#0310 Police '/2 Ton Pick Up $ 25,000
#0336 Police Marked Squad $ 30,500
#0337 Police Marked Squad $ 30,500
#0338 Police Marked Squad $ 30,500
#0383 Police Unmarked Investigation $ 19,500
Total C.G. Capital Outlay Requests for 2012 $738,500
389
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
70100 CENTRAL GARAGE
49951 CENTRAL GARAGE OPERATIONS
4000 REVENUES AND EXPENSES
4001 REVENUES
4300 INTERGOVERNMENTAL REVENUE
4360 COUNTY GRANTS
4599 MISCELLANEOUS REVENUE
4600 MISCELLANEOUS REVENUE
4603 INTEREST EARNINGS 38,512- 16,731- 12,300- 19,785- 18,000- 18,000-
4605 UNREALIZED INVESTMENT GAIN/LOS 1,384- 10,843
4606 OTHER REVENUE 2,748- 1,103- 6,670-
4600 MISCELLANEOUS REVENUE 42,643- 6,990- 12,300- 26,455- 18,000- 18,000-
4860 CENTRAL GARAGE
4862 FUEL SALES-INTERNAL 178,500- 225,597- 270,368- 250,918- 279,768- 279,768-
4862.1 FUEL SALES-EXTERNAL 58,023- 92,146- 72,300- 94,894- 116,800- 116,800-
4863 REPLACEMENT CHARGES 546,000- 589,297- 627,418- 595,752- 629,696- 629,696-
4864 OVERHEAD CHARGES 180,883- 185,927- 169,569- 167,335- 170,591- 170,591-
4865 REPAIR/MAINT CHARGES 408,438- 447,785- 522,875- 389,230- 523,625- 523,625-
4860 CENTRAL GARAGE 1,371,844- 1,540,752- 1,662,530- 1,498,128- 1,720,480- 1,720,480-
4599 MISCELLANEOUS REVENUE 1,414,487- 1,547,742- 1,674,830- 1,524,583- 1,738,480- 1,738,480-
4900 OTHER FINANCING SOURCES
4911 SALE OF PROPERTY 17,900- 20,950- 12,000- 27,884-
4915 TRANSFERS IN 15,288-
4919 GAIN ON FIXED ASSET DISPOSAL 22,732- 2,388
4921 REFUNDS&REIMBURSEMENTS 24,161- 44,294- 40,804-
4900 OTHER FINANCING SOURCES 80,082- 62,856- 12,000- 68,687-
4001 REVENUES 1,494,569- 1,610,598- 1,686,830- 1,593,270- 1,738,480- 1,738,480-
6001 EXPENDITURES/EXPENSES
6099 PERSONAL SERVICES
6100 WAGES AND SALARIES
6101 WAGES&SALARIES-FT EMPLOYEES 239,780 250,338 252,940 221,286 254,180 254,180
6102 OVERTIME-FT EMPLOYEES 664 595 800 700 700
6100 WAGES AND SALARIES 240,444 250,933 253,740 221,286 254,880 254,880
6110 OTHER PAYMENTS-NON INSURANCE
6111 SEVERANCE PAY 1,156 1,117
6110 OTHER PAYMENTS-NON INSURANCE 1,156 1,117
6120 RETIREMENT CONTRIBUTIONS
6122 PERA COORDINATED PLAN 16,225 17,587 17,705 16,043 18,427 18,427
6125 FICA 14,401 14,915 15,682 13,115 15,759 15,759
6126 MEDICARE CONTRIBUTIONS 3,368 3,488 3,668 3,067 3,686 3,686
6120 RETIREMENT CONTRIBUTIONS 33,994 35,990 37,055 32,225 37,872 37,872
6130 INSURANCE BENEFITS
6131 CAFETERIA PLAN CONTRIBUTIONS 46,185 48,447 56,400 44,594 53,940 53,940
6130 INSURANCE BENEFITS 46,185 48,447 56,400 44,594 53,940 53,940
6150 WORKER'S COMPENSATION
390
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
6151 WORKER'S COMP INSURANCE 13,575 9,446 9,181 7,065 8,109 8,109
6150 WORKER'S COMPENSATION 13,575 9,446 9,181 7,065 8,109 8,109
6099 PERSONAL SERVICES 335,355 345,933 356,376 305,170 354,801 354,801
6199 SUPPLIES
6200 OFFICE SUPPLIES
6201 OFFICE SUPPLIES 141 335 300 293 300 300
6203 BOOKS/REFERENCE MATERIALS 150 136 150 150
6200 OFFICE SUPPLIES 141 335 450 429 450 450
6210 OPERATING SUPPLIES
6212 MOTOR FUELS 230,141 308,683 400,416 335,376 426,000 426,000
6213 LUBRICANTS&ADDITIVES 14,827 14,960 14,000 11,890 14,000 14,000
6215 SHOP MATERIALS 9,095 7,995 11,000 5,172 9,500 9,500
6217 SAFETY SUPPLIES 171 614 700 599 700 700
6218 WELDING SUPPLIES 3,252 3,736 4,000 3,813 4,500 4,500
6219 GENERAL OPERATING SUPPLIES 837 1,162 1,300 886 1,300 1,300
6210 OPERATING SUPPLIES 258,322 337,150 431,416 357,736 456,000 456,000
6220 REPAIR&MAINT SUPPLIES
6221 MOTOR VEHICLES 79,693 93,064 93,000 81,440 93,000 93,000
6222 TIRES 23,261 15,524 20,000 12,105 18,000 18,000
6226 SIGNS&STRIPING MATERIALS 2
6227 PAINT SUPPLIES 33 216 300 280 300 300
6220 REPAIR&MAINT SUPPLIES 102,987 108,805 113,300 93,824 111,300 111,300
6230 REPAIR&MAINT SUPPLIES-OTHER
6239 OTHER REPAIR&MAINT SUPPLIES 72 32 400 296 200 200
6230 REPAIR&MAINT SUPPLIES-OTHER 72 32 400 296 200 200
6240 SMALL TOOLS&MINOR EQUIPMENT
6241 SMALLTOOLS 1,066 3,090 3,400 2,208 3,400 3,400
6242 MINOR EQUIPMENT 563 474 2,600 53,100 53,100
6243 MINOR COMPUTER EQUIPMENT 1,680 1,700 1,700
6240 SMALL TOOLS&MINOR EQUIPMENT 1,629 5,244 6,000 2,208 58,200 58,200
6199 SUPPLIES 363,152 451,566 551,566 454,493 626,150 626,150
6299 OTHER CHARGES&SERVICES
6300 PROFESSIONAL SERVICES
6305 MEDICAL SERVICES 126
6307 PROFESSIONAL SERVICES 5,550 2,296 3,500 4,805 3,500 3,500
6300 PROFESSIONAL SERVICES 5,676 2,296 3,500 4,805 3,500 3,500
6320 COMMUNICATIONS
6321 TELEPHONE/PAGERS 300 266 300 300
6320 COMMUNICATIONS 300 266 300 300
6330 TRANSPORTATION
6331 TRAVEL EXPENSE/MILEAGE 19
6333 FREIGHT/DRAYAGE 495 1,084 1,400 545 1,400 1,400
6330 TRANSPORTATION 514 1,084 1,400 545 1,400 1,400
6340 ADVERTISING
6341 PERSONNEL ADVERTISING 579
391
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
6340 ADVERTISING 579
6350 PRINTING AND DUPLICATING
6351 PRINTING 392 290 300 287 300 300
6350 PRINTING AND DUPLICATING 392 290 300 287 300 300
6360 INSURANCE
6363 MOTOR VEHICLE INSURANCE 31,486 30,449 53,000 35,141 53,000 53,000
6367 EQUIPMENT(INLAND MARINE) 13,193 13,568 14,000 15,424 14,000 14,000
6360 INSURANCE 44,679 44,017 67,000 50,565 67,000 67,000
6380 UTILITY SERVICES
6388 HAZARDOUS WASTE DISPOSAL 1,394 1,392 2,000 634 2,000 2,000
6380 UTILITY SERVICES 1,394 1,392 2,000 634 2,000 2,000
6400 REPAIR&MAINT SERVICES
6401 MOTOR VEHICLE SERVICES 58,647 56,915 65,000 50,732 65,000 65,000
6402 EQUIPMENT SERVICES 3,053 5,469 5,000 5,762 5,500 5,500
6406 MULTI-FUNCTION MTNCE 500 500
6400 REPAIR&MAINT SERVICES 61,700 62,384 70,000 56,494 71,000 71,000
6410 RENTALS
6417 UNIFORMS 5,076 4,985 3,700 5,853 4,000 4,000
6410 RENTALS 5,076 4,985 3,700 5,853 4,000 4,000
6420 IS SERVICES/LICENSES/FEES
6422 SOFTWARE MAINT 175 13,060 5,950 5,947 6,250 6,250
6423 LOGIS CHARGES 16,835 4,258 3,274 2,539 3,969 3,969
6420 IS SERVICES/LICENSES/FEES 17,010 17,318 9,224 8,486 10,219 10,219
6430 MISCELLANEOUS
6432 CONFERENCES AND SCHOOLS 1,025 778 1,800 866 1,500 1,500
6433 MEETING EXPENSES 12 100 100 100
6434 DUES&SUBSCRIPTIONS 1,603 150 150 150
6430 MISCELLANEOUS 1,025 2,393 2,050 866 1,750 1,750
6440 OTHER EXPENSES
6441 LICENSES,TAXES&FEES 1,034 1,895 2,500 1,130 2,500 2,500
6447 TOWING CHARGES 251 1,665 800 720 800 800
6449 OTHER CONTRACTUAL SERVICE 984 1,481 1,000 1,774 1,300 1,300
6440 OTHER EXPENSES 2,269 5,040 4,300 3,624 4,600 4,600
6460 CENTRAL GARAGE CHARGES
6461 FUEL CHARGES 980 3,920 2,500 2,782 2,500 2,500
6460 CENTRAL GARAGE CHARGES 980 3,920 2,500 2,782 2,500 2,500
6470 TRANSFERS AND OTHER USES
6471 ADMINISTRATIVE SERVICE TRANSFE 32,638 40,705 44,792 41,060 40,426 40,426
6470 TRANSFERS AND OTHER USES 32,638 40,705 44,792 41,060 40,426 40,426
6490 OTHER MISC COSTS/EXPENSES
6494 DEPRECIATION EXPENSE 654,060 638,835
6490 OTHER MISC COSTS/EXPENSES 654,060 638,835
6299 OTHER CHARGES&SERVICES 827,991 824,661 211,066 176,268 208,995 208,995
392
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
6500 CAPITAL OUTLAY
6501 CAPITAL OUTLAY
6540 EQUIPMENT&MACHINERY 4,084 5,596 6,300 5,347 2,850 2,850
6545 OTHER EQUIPMENT 738,500 738,500
6550 MOTOR VEHICLES 575,700 558,923
6501 CAPITAL OUTLAY 4,084 5,596 582,000 564,269 741,350 741,350
6500 CAPITAL OUTLAY 4,084 5,596 582,000 564,269 741,350 741,350
6001 EXPENDITURES/EXPENSES 1,530,581 1,627,757 1,701,008 1,500,201 1,931,296 1,931,296
4000 REVENUES AND EXPENSES 36,013 17,159 14,178 93,070- 192,816 192,816
49951 CENTRAL GARAGE OPERATIONS 36,013 17,159 14,178 93,070- 192,816 192,816
70100 CENTRAL GARAGE 36,013 17,159 14,178 93,070- 192,816 192,816
393
MT
This page has been left blank intentionally.
394