Loading...
HomeMy WebLinkAbout5. 2010/2011 Assistant City Administrator Budgets 5. CITY OF SHAKO PEE 2010/2011 GENERAL FUND BUDGET DIVISION: FACILITIES MISSION STATEMENT: To provide for the daily and long-term operation and preventative maintenance of government buildings. ACTIVITY: The Facilities Division budget provides for the operation and maintenance of City Hall. In addition, staffing provided through the Facilities budget also provides for operation and. maintenance of the Library, Congregate Dining, Fire Stations, Police Station, Public Works buildings, Community Center and Youth Building. Operating costs for these buildings as well as staff time are charged to the respective division budgets. Actual Budgeted Requested Requested 2008 2009 2010 2011 Expenditures $269,190 $236,250 $274,740 $278,580 Population 33,660 33,860 34,000 34,200 Expenditure/Capita $8.00 $6.98 $8.08 $8.15 Square feet maintained Staff 2008 2009 2010 2011 Facilities Supervisor 1 1 1 1 Maintenance 1 1 2 2 Custodian 3 3 4 4 OBJECT DESCRIPTION: Description of lines items: Salaries (Full-Time): Full-time Facilities Maintenance Supervisor, Facilities Maintenance Workers (2), and Custodians (4). Part-time custodian wages for weekend and substitute custodians. Operating Supplies (6202): Items used in daily care of City Hall, such as paper products, garbage bags, cleaning products ($4,500). Tools and equipment for facilities staff (used across all buildings) ($1,100) Office Supplies (6210): Office supplies ($500). 1 Motor Fuels (6222): Fuel for 3 vehicles, $3,000 ($3,300 for 2011). Building Maintenance Supplies (6230): HV AC filters; lighting products; plumbing, electrical, and other repair supplies; miscellaneous building repair ($3,500). Building Maintenance Professional Services (6315): Ongoing maintenance and operation of buildings including: mechanical service contracts for heating, cooling, and electrical; elevator service agreements; fire alarm and security system monitoring and testing; exterior window cleaning; lock, door, and glass replacement( $20,000). Equipment Maintenance: Shop charges for vehicle maintenance, $4,000 ($4,200 for 2011). Telephone (6334): Desk and Cell Phones for 3 employees ($1000). Insurance (6350): Property insurance for City Hall ($2,800). Liability and auto insurance for Facilities Division ($2,540). Utilities (6360): Water, sewer, natural gas, electricity, and storm sewer for City Hall($40,OOO). Rentals (6400~6435): Building fund rental charges for Facilities staff ($8,160); Rent on 3 staff vehicles and snow removal equipment ($830). Conferences/Schools/Training (6472) Registration fees for staff training ($500). Travel (6475): Mileage reimbursement for custodian's building-to-building travel ($1200). Dues (6480): Boilers licenses ($100). 2 R5509BUD SH005PV CITY OF SHAKOPEE 7/21/2009 14:09:04 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 6 I 09 Level Of Rollup 6 2007 2008 6/30/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Bud gel 01000 GENERAL FUND 18 F ACILlTI ES 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 84,787 83,479 46,182 67,810 92,020 94,540 6100 BENEFITS 40,309 56,091 23,213 58,200 86,490 86,990 6001 WAGES & BENEFITS 125,096 139,570 69,396 126,010 178,510 181,530 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 10,623 12,044 3,975 20,900 15,100 15,400 6300 PROFESSIONAL SERVICES 84,394 65,440 23,037 31,000 24,000 24,200 6330 COMMUNICATIONS 1,604 738 284 1,100 1,000 1,000 6350 INSURANCE 5,503 8,395 6,200 5,340 5,520 6360 UTILITY SERVICE 33,956 36,666 15,127 40,000 40,000 40,000 6400 RENTALS 2,868 5,172 4,620 9,240 8,990 9,130 6470 DUESfTRAININGfTRAVEL 705 1,160 310 1,800 1,800 1,800 6200 SUPPLIES AND SERVICES 139,654 129,615 47,352 110,240 96,230 97,050 6500 DEPRECIATION 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 268 -~-~ 6600 MISCELLANEOUS 268 6700 CAPITAL OUTLAY 6730 BUILDINGS 24,652 6740 EQUIPMENT 2,565 -- 6700 CAPITAL OUTLAY 27,217 6800 DEBT SERVICE --- 6000 EXPENDITURES 292,235 269,185 116,748 236,250 274,740 278,580 - --~ --- 18 FACILITIES 292,235 269,185 116,748 236,250 274,740 278,580 01000 GENERAL FUND 292,235 269,185 116,748 236,250 274,740 278,580 3 Facilities 2010-11 Budget 2010 2011 2010 2011 2010 2011 0181 0181 0183 0183 Object # Description Manage. Manage. City Hall City Hall Total Total 6002 Wages FT - Reg. $ 53,020 $ 53,020 $ 39,000 $ 41,520 S 92,020 $ 94,540 6005 Wages OT - Reg. 6122 PERA 3,710 3,710 2,730 2,910 6,440 6,620 6124 FICA 4,060 4,060 2,980 3,180 7,040 7,240 6135 Health 41 ;190 41 ,190 41,190 41,190 6139 PEHP 2,100 2,100 2,100 2,100 6140 Life 800 800 800 800 6145 Dental 3,360 3,360 3,360 3,360 6170 Workers Camp 2,440 2,440 1,920 2,040 4,360 4,480 6180 Compensated Absences 11,200 11,200 11,200 11 ,200 6185 OPEB 10,000 10,000 10,000 10,000 Total Personnel 131,880 131,880 46,630 49,650 178,510 181,530 6202 Operating Supplies 1,100 1,100 4,500 4,500 5,600 5,600 6210 Office Supplies 500 500 500 500 6212 Clothing / Uniforms 1,000 1,000 1,000 1,000 6222 Motor Fuels & Lubricants 3,000 3,300 3,000 3,300 6230 Building Maintenance 3,500 3,500 3,500 3,500 6240 Equipment Maintenance 1,500 1,500 1,500 1,500 6315 Building Maintenance 20,000 20,000 20,000 20,000 6316 Equipment Maintenance 4,000 4,200 4,000 4,200 6327 Other Prof Services 6332 Postage 6334 Telephone 1,000 1,000 1,000 1,000 6352 Liability Insurance 1,880 1,940 1,880 1,940 6354 Property Insurance 2,800 2,900 2,800 2,900 6356 Auto Insurance 660 680 660 680 6360 Utility Service 6362 Electric Service 27,270 27,250 27,270 27,250 6364 Water 250 250 250 250 6365 Gas 11,850 11 ,850 11,850 11,850 6366 Sewer 360 370 360 370 6368 Storm 270 280 270 280 6400 Rentals 6425 Equipment Rent (IS FUND) 830 830 830 830 6430 Building Rent (IS FUND) 8,160 8,300 8,160 8,300 6435 Other Rent 6472 Conf / School/Training 500 500 500 500 6475 Travel/Subsistence 1,200 1,200 1,200 1,200 6480 Dues 100 100 100 100 Total Supplies & Services 25,430 26,150 70,800 70,900 96,230 97,050 6740 Capital Expenditures Total $ 157.310 S 158,030 $ 117,430 $ 120,550 $ 274,740 $ 278,580 4 CITY OF SHAKO PEE 2010/2011 GENERAL FUND BUDGET DIVISION: INFORMATION TECHNOLOGY (IT) MISSION STATEMENT: The mission of the IT Division is as follows: Provide effective IT support services for the City's seven departments. ACTIVITIES: IT funds all of the operations, maintenance and replacement of the City's computer systems. IT funds system resources, operating systems, equipment replacement, word processing, spreadsheet, database, and other "general use" applications. To do this, the City currently employs a full-time IT Coordinator and IT Specialist. Additional consulting services and the City's internet service are provided by Local Government Information Services (LOGIS). Actual Budgeted Requested Requested 2008 2009 2010 2011 Expenditures $294,800 $359,170 $392,810 $386,180 Population 33,660 33,860 34,000 34,200 Expenditure/Capita $8.76 $10.61 $11.55 $11.29 Pieces of equipment maintained Data storage Employees 2008 2009 2010 2011 IT Coordinator 1 1 1 1 IT Specialist 1 1 1 1 OBJECT DESCRIPTION: Description of line items Wages & Benefits: Salaries: liT Coordinator, liT Specialist. Supplies & Services: 2010 -- Server replacement ($3,530), new 48-port switch ($5,000), PC replacement $8,000. 2011- Software ($12,500); PC Replacement ($8,000); additional server w/ HBA ($4,500). Rentals: Payment to LOGIS for Internet, Network Wellness and general R & D charge ($15,000), annual software license & service agreement renewals ($82,000 in 2010, $87,000 in 2011). 5 Dues/Training/Travel: $6,000 Capital: For 2010: Phone System Upgade ($19,300), expansion / enhancement of Disaster Recovery system ($18,000), SAN upgrade and additional storage ($35,000). For 2011: Operating System (Windows) Upgrade - $25,000; additional storage drives for City Hall SAN $25,000, 6 R5509BUD SH005PV CITY OF SHAKOPEE 7/21/2009 14:09:41 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 6 I 09 Level Of Rollup 6 2007 2008 6/3012009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code I Description Amount Amount Actual Budget Budget Budget ---------~ 01000 GENERAL FUND 20 INFORMATION TECHNOLOGY 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 112,523 119,098 59,192 130,690 130,750 133,240 6100 BENEFITS 32,268 34,197 15,656 43,250 38,580 38,960 6001 WAGES & BENEFITS 144,790 153,296 74,847 173,940 169,330 172,200 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 88,310 84,387 11 ,462 129,000 19,000 27,250 6300 PROFESSIONAL SERVICES 14,888 5,324 5,218 15,000 15,000 15,000 6330 COMMUNICATIONS 2,041 2,572 923 1,750 1,750 1,780 6350 INSURANCE 1,768 2,671 2,520 2,570 2,650 6400 RENTALS 20,014 38,705 69,045 21,960 105,160 110,300 6470 DUESrrRAININGrrRAVEL 5,435 7,843 7,000 7,000 7,000 6200 SUPPLIES AND SERVICES 132,456 141,502 86,648 177 ,230 150,480 163,980 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6740 EQUIPMENT 12,968 7,311 8,000 73,000 50,000 6700 CAPITAL OUTLAY 12,968 7,311 8,000 73,000 50,000 6800 DEBT SERVICE 6000 EXPENDITURES 290,214 294,798 168,807 359,170 392,810 386,180 -~- ------>--- 20 INFORMATION TECHNOLOGY 290,214 294,798 168,807 359,170 392,810 386,180 01000 GENERAL FUND 290,214 294,798 168,807 359,170 392,810 386,180 7 Info Tech 2010-11 Budget ~-- 2010 2011 0172 0172 Object # Description IT IT 6002 Wages FT - Reg, $ 130,750 $ 133,240 6122 PERA 9,150 9,330 6124 FICA 10,000 10,190 6135 Health 11 ,830 11,830 6139 PEHP 600 600 6140 Life/L TD 630 630 6145 Dental 960 960 6170 Workers Comp 550 560 6180 Compensated Absences 2,000 2,000 6185 OPEB 2,860 2,860 Total Personnel 169,330 172,200 6202 Operating Supplies 18,000 26,000 6210 Office Supplies 1,000 1,250 6314 Computer Services 10,000 10,000 6316 Equipment Maintenance 5,000 5,000 6327 Other Prof Services 6334 Telephone 1,000 1,000 6339 Computer Access 750 780 6352 Liability Insurance 2,550 2,630 6356 Auto Insurance 20 20 6410 LOG I S/software 97,000 102,000 6430 Building Rent (IS FUND) 8,160 8,300 6472 Conf / School/ Training 5,000 5,000 6475 Travel/Subsistence 1,000 1,000 6490 Su bscri ptions/Pu blications 1,000 1,000 Total Supplies & Services 150,480 163,980 6740 Capital Expenditures 73,000 50,000 Total $ 392,810 $ 386,180 8