HomeMy WebLinkAbout5.F.1. City Bill List
#5F1
"CONSENT"
CITY OF SHAKOPEE
Memorandum
TO: Mayor and Council
Mark McNeill, City Administrator
FROM: Gregg Voxland, Finance Director
RE: City Bill List
DATE: September 11, 2009
Introduction and Back~round
Attached is the print-out showing the division budget status for 2009 based on data entered as of
9/11/2009.
Attached is a regular council bill list for invoices processed to date for council approval.
Included in the checklist are various refunds, returns, and pass through.
Visionin~ Relationship
None perceived routine.
Included in the bill list is payment to Mobile Vision for 5 squad car cameras and related items in the
amount of $37,160.00. Council authorized $32,728.00 for two cameras on December 18, 2007.
Action Reauested
Move to approve the bills in the amount of $l,095,814.07and electronic transfers in the amount of
$390,232.34 for a total of $1,486,046.41.
Funds transferred electronicaly September 2, 2009 to September 11, 2009.
PAYROLL $ 226,343.02
FIT/FICA/MEDICA $ 59,832.21
STATE INCOME TAX $ 12,882.74
PERA $ 53,602.11
HEALTH CARE SAVINGS $ 4,634.08
HEALTH SAVINGS ACCT $ 8,044.80
FLEX SPENDING ACCT $ 333.34
NATIONWIDE DEF COMP $ 14,231.43
ICMA DEFERRED COMP $ 1,568.18
CHILD SUPPORT $ 920.00
BLDG SURCHARGE $ 6,733.73
BANK FEES $ 1,106.70
TOTAL $ 390,232.34
R5509FIN1 LOGIS003 CITY OF SHAKOPEE 9/11/2009 8:54:50
By Co (pb), Div (Totals Only) Monthly Financial Report Page. 1
2009
2009 9/30/2009 2009 <===================== 2008 =====================>
Annual Current YTD Budget Per Cent I Prior Year Same Period Prior Per Cent
__.--Yescription Budget Period Actual Balance Used -L Budget Year YTD Actual Used
--~- ------
01000 GENERAL FUND
11 MAYOR & COUNCIL 165,700.00 18,892.00 101,805.68 63.894.32 61.44 1 177,390.00 109,273.81 61.60
12 CITY ADMINISTRATOR 553,930.00 4,456.07 350,398.69 203,531.31 63.26 I 519,120.00 346,008.25 66.65
13 CITY CLERK 310,200.00 221.00 189,254.61 120,945.39 61.01 I 366,440.00 227,711.24 62.14
15 FINANCE 819,090.00 548,182.57 270,907.43 66.93 I 772,100.00 574,753.09 74.44
16 LEGAL COUNSEL 473,500.00 1,030.95 304,802.62 168,697.38 64.37 I 533,500.00 368,478.70 69.07
17 COMMUNITY DEVELOPMENT 505,820.00 561.25 314,583.38 191,236.62 62.19 I 549,150.00 390,517.69 71.11
18 FACILITIES 236,250.00 10,332.49 180,695.10 55,554.90 76.48 I 309,030.00 179,943.48 58.23
20 INFORMATION TECHNOLOGY 359,170.00 1,923.87 241,000.24 118,169.76 67.10 I 313,120.00 236,728.91 75.60
31 POLICE DEPARTMENT 6,199,710.00 8,517.41 3,999,985.89 2,199,724.11 64.52 I 5,920,620.00 4,295,444.57 72.55
32 FIRE 1,974,480.00 26,458.67 1,028,364.64 946,115.36 52.08 I 1,933,710.00 1,176,454.60 60.84
33 INSPECTION-BLDG-PLMBG-HTG 745,130.00 2,099.73 517.782.06 227,347.94 69.49 I 823,690.00 590,567.99 71.70
41 ENGINEERING 685,300.00 81.00 365,597.75 319,702.25 53.35 I 790,090.00 460,768.29 58.32
42 STREET MAINTENANCE 1,799,020.00 7,383.69 1,309,490.80 489,529.20 72.79 I 1,973,070.00 1,369,087.05 69.39
44 FLEET 103,640.00 36,066.69 113,150.25 9,510.25- 109.18 I 95,990.00 87,532.55 91.19
46 PARK MAINTENANCE 1,495,000.00 15,423.58 961,504.15 533,495.85 64.31 I 1,579,820.00 1,111,899.44 70.38
65 LIBRARY/CONGREGATE DINING 323,380.00 3,370.35 183,473.86 139,906.14 56.74 [ 302,350.00 204,937.69 67.78
66 NATURAL RESOURCES 66,230.00 269.38 19,552.52 46,677.48 29.52 I 128,030.00 78,470.94 61.29
91 UNALLOCATED 150,000.00 494.85 78,163.70 71,836.30 52.11 I 157,240.00 118,575.03 75.41
01000 GENERAL FUND 16,965,550.00 137,582.98 10,807,788.51 6,157,761.49 63.70 I 17,244,460.00 11,927,153.32 69.17
02140 TRANSIT
17 COMMUNITY DEVELOPMENT 1,173,500.00 36,546.49 608,807.70 564,692.30 51.88 I 2,080,840.00 608,323.97 29.23
02140 TRANSIT 1,173,500.00 36,546.49 608,807.70 564,692.30 51.88 I 2,080,840.00 608,323.97 29.23
02150 TELECOMMUNICATION
12 CITY ADMINISTRATOR 225,670.00 2,792.35 124,642.92 101,027.08 55.23 I 336,700.00 147,574.24 43.83
--- ._---~--------~--~.- -----.-
02150 TELECOMMUNICATION 225,670.00 2,792.35 124,642.92 101,027.08 55.23 I 336,700.00 147,574.24 43.83
02190 EDA
19 EDA 116,680.00 58,011.02 58,668.98 49.72 I 123,770.00 38,532.41 31.13
02190 EDA 116,680.00 58,011.02 58,668.98 49.72 I 123,770.00 38,532.41 31.13
07500 RECREATION FUND
75 RECREATION PROGRAMS 2,345,760.00 29,451.76 1,557,422.52 788,337.48 66.39 I 2,250,660.00 1,763,370.92 78.35
07500 RECREATION FUND 2,345,760.00 29,451.76 1,557,422.52 788,337.48 66.39 I 2,250,660.00 1,763,370.92 78.35
R55CKSUM LOG20000 CITY OF SHAKOPEE 9111/2009 8:46:10
Council Check Summary Page - 1
9/2/2009 . 9/11/2009
Company Amount
-
01000 GENERAL FUND 182,117.99
02120 FORFEITURE 12,001.24
02140 TRANSIT 34,137.49
02150 TELECOMMUNICATION 2,734.10
02170 REVOLVING LOAN 4,292.08
03029 1998B IMPROVEMENT 2,100.00
03035 2004B BLDG REFUNDING BONDS 2,750.00
04020 PARK RESERVE 18,900.00
04021 CAPITAL IMPROVEMENT FUND 3,998.00
04065 2008 PROJECTS 1,187.00
04066 2009 PROJECTS 540,746.64
07100 SEWER FUND 238,804.68
07300 SURFACE WATER FUND 7,855.59
07500 RECREATION FUND 29,787.82
07810 BUILDING I.S. FUND 1,725.24
08025 SW METRO DRUG TASK FORCE 4,499.95
08027 TRI.CITY TACTICAL TEAM 703.00
08040 ESCROW FUND 7,473.25
Report Totals 1,095,814.07
R55CKREG LOG22000VO CITY OF SHAKOPEE 9/11/2009 8:49:12
Council Check Register Page - 1
9/2/2009 ..9/11/2009
Check # Amount Vendor I Explanation Account Description Business Unit
-- -
105637 107.33 AMEK CONSTRUCTION BUILDING PERMITS BUILDING INSPECTION
105638 455.53 BELLE PLAINE POLICE DEPARTMENT STATE GRANTS & AIDS POLICE GRANTS
105639 100.00 FIRST PRESBYTERIAN CHURCH PARK FACILITY RENTAL PARK SERVICES
105640 39.00 FOP SOUTH METRO LODGE # 14 CONFERENCElSCHOOLlTRAINING PATROL
105641 741.45 JORDAN POLICE DEPARTMENT STATE GRANTS & AIDS POLICE GRANTS
105642 3,057.41 LAFAYETTE LIFE INSURANCE CO LIFE PAYABLE PAYROLL CLEARING
105643 1,848.00 LAW ENFORCMT LABOR SERVICES UNION DUES PAYABLE PAYROLL CLEARING
1 05644 176,540.55 METRO COUNCIL ENVIRO SERVICES CURRENT USE CHARGES SEWER MANAGEMENT
105645 90.51 MN COMM OF FINANCE TREAS DIV FINES & FORFEITS FORFEITURE
1 05646 1,181.00 MN TEAMSTERS #320 UNION DUES PAYABLE PAYROLL CLEARING
105647 672.00 NCPERS GROUP LIFE INS LIFE PAYABLE PAYROLL CLEARING
105648 693.49 NEW PRAGUE, CITY OF STATE GRANTS & AIDS POLICE GRANTS
105649 199.95 NEXTEL COMMUNICATIONS COMPUTER ACCESS SWMDTF - FORFEITURES
105650 2,045.86 PRIOR LAKE, CITY OF STATE GRANTS & AIDS POLICE GRANTS
1 05651 2,039.00 SAVAGE, CITY OF STATE GRANTS &AIDS POLICE GRANTS
105652 1,000.00 SCHMIDTKE, DOUG PURCHASE OF EVIDENCE SWMDTF - FORFEITURES
105653 1,147.02 SCOTT CO ATTORNEY'S OFFICE FINES & FORFEITS DWI FORFEITURE
105654 2,031.79 SCOTT CO SHERIFF STATE GRANTS & AIDS POLICE GRANTS
105655 2,300.00 SCOTT CO TREASURER WAGES FT REG SWMDTF - FORFEITURES
105656 106.00 SEDLACEK, KATE LESSONS POOL MANAGEMENT
105657 896.08 TIGERDIRECT OPERATING SUPPLIES TELECOMMUNICATION MANAGEMENT
105658 1,000.00 WILLIAMS, MARK PURCHASE OF EVIDENCE SWMDTF. FORFEITURES
105659 688.55 3M TNJ4437 OPERATING SUPPLIES SIGN MAINT
105660 225.00 AL'S AUTOMOTIVE DETAILING MERCHANDISE FLEET MANAGEMENT
105661 1,561.50 ALLIANCE BENEFIT GROUP, OTHER PROF SERVICES PERSONNEL-PAYROLL
105662 386.88 APPLE FORD OF SHAKOPEE INC MERCHANDISE FLEET MANAGEMENT
105663 582.33 ARROW ACE HARDWARE OPERATING SUPPLIES ICE ARENA MANAGEMENT
105664 3,906.38 AVANT GROUP LLC PRINTINGIPUBLlSHING TELECOMMUNICATION MANAGEMENT
105665 1,616.00 BAUER BUILT TIRE & BATT INC MERCHANDISE FLEET MANAGEMENT
105666 128.23 BECKER ARENA PRODUCTS INC BUILDING MAINT SUPPLIES ICE ARENA MANAGEMENT
105667 85.70 BOYER TRUCKS MERCHANDISE FLEET MANAGEMENT
105668 579.18 BRYAN ROCK PRODUCTS MATERIALS CATCH BASIN MAINT
105669 16.99 BTR OF MINNESOTA MERCHANDISE FLEET MANAGEMENT
105670 91.72 C & E AUTO UPHOLSTERY MERCHANDISE FLEET MANAGEMENT
105671 30.00 CALVARY UNITED METH CHURCH OTHER RENT ELECTIONS
105672 203.06 CARLSON SPORTS MARKETING BUILDING MAINT SUPPLIES ICE ARENA MANAGEMENT
105673 374.31 CDW GOVERNMENT INC OPERATING SUPPLIES TELECOMMUNICATION MANAGEMENT
105674 1,209.29 CEMSTONE PRODUCTS CO MATERIALS PARK MAINT/GARBAGE PICKUP
105675 699.30 CENTERPOINT ENERGY SERVCIES IN GAS FACILITIES - POLICE
105676 6,100.00 CENTEX HOMES DEPOSITS PAYABLE ESCROW FUND
105677 83.60 CHOICE ELECTRIC INC BUILDING MAINT. PARK BLDGS MAINT
R55CKREG LOG22000VO CITY OF SHAKOPEE 9/11/2009 8:49:12
Council Check Register Page - 2
9/2/2009 -- 9/11/2009
Check # Amount Vendor I Explanation Account Description Business Unit
--
105678 226.32 CLAREY'S SAFETY EQUIP INC RECREATION SUPPLIES RECREATION PROGRAMS
105679 1,917.75 COCA-COLA BOTTLING CO MERCHANDISE POOL MANAGEMENT
105680 51.99 COMMERCIAL ASPHALT CO MATERIALS CATCH BASIN MAINT
105681 1,693.97 COVERALL OF THE TWIN CITIES IN OTHER PROF SERVICES PARK BLDGS MAINT
105682 85.00 CROSS OF PEACE LUTHERAN CHURCH OTHER RENT ELECTIONS
105683 942.41 CUSTOM REFRIGERATION INC BUILDING MAINT SUPPLIES ICE ARENA MANAGEMENT
105684 30.00 DOCUMENT DESTRUCTION SERVICEL OTHER PROF SERVICES POLICE MANAGEMENT
105685 196.02 DREES, JOHN TRANSPORTATION TRANSIT D.A-R
105686 746.26 EARL F ANDERSEN INC OPERATING SUPPLIES PLAYGROUND MAINT
105687 45.00 ELLER,BRAD PERFORMERSIINSTRUCTORS RECREATION PROGRAMS
105688 29.84 EMERGENCY AUTO TECHNOLOGIES IN MERCHANDISE FLEET MANAGEMENT
105689 1,641.87 F5 NETWORKS INC OPERATING SUPPLIES INFORMATION TECHNOLOGY
105690 122.94 FASTENAL OPERATING SUPPLIES SIGN MAINT
105691 13,679.95 FIRE EQUIP SPECIALTIES OPERATING SUPPLIES FIRE MANAGEMENT
105692 264.64 GLOBAL INDUSTRIAL EQUIP OPERATING SUPPLIES PARK SERVICES
105693 88.00 HATHAWAY CONTROLS,INC OPERATING SUPPLIES FIRE MANAGEMENT
105694 639.97 HIRSHFIELD'S PAINT MFG INC OPERATING SUPPLIES ATHLETIC MAINT & FIELDS
105695 111.30 HOTSY EQUIPMENT OF MINNESOTA EQUIPMENT MAINTENANCE TRUCK WASH
105696 931.14 HUEBSCH CO BUILDING MAINT. COMM CTR FACILITIES
105697 17.60 JENKINS, RUSSELL TRA VEUSUBSISTENCE FACILITIES MANAGEMENT
105698 1,115.75 K M T COMMUNICATIONS ADVERTISING TRANSIT
105699 17,017.96 KELLEY FUELS, INC GASOLINE GENERAL FUND
105700 6,959.19 KENNEDY & GRAVEN CHRTD ATTORNEY AQUATIC BUILDING
105701 2,096.00 KROMINGA, TERRY OTHER PROF SERVICES INSPECTION MANAGEMENT
105702 37,160.81 L3 COMMUNICATIONS OPERATING SUPPLIES DWI FORFEITURE
105703 472.64 LANO EQUIPMENT INC MERCHANDISE FLEET MANAGEMENT
105704 18,937.00 LEAGUE OF MN CITIES DUES MAYOR & COUNCIL
105705 410.94 LINK LUMBER INC MATERIALS CATCH BASIN MAINT
105706 1,971.28 LOCATORS & SUPPLIES INC OPERATING SUPPLIES SURFACE WATER MANAGEMENT
105707 494.85 LOFFLER BUSINESS SYSTEMS INC PRINTING/PUBLISHING UNALLOCA TED
105708 344.00 LOGIS COMPUTER SERVICES INFORMATION TECHNOLOGY
105709 622.68 MACQUEEN EQUIP MERCHANDISE FLEET MANAGEMENT
105710 143.21 MATRIX LASER CARE INC OPERATING SUPPLIES FIRE MANAGEMENT
105711 13.20 MCINTYRE, BRAD TRA VEUSUBSISTENCE FACILITIES MANAGEMENT
105712 6,850.00 MED COMPASS INC OTHER PROF SERVICES FIRE MANAGEMENT
105713 150.00 METRO AUTO SALVAGE INC MERCHANDISE FLEET MANAGEMENT
105714 240.00 MINNESOTA MULCH & SOIL OTHER PROF SERVICES DITCH & POND MAl NT
105715 831.44 MOTOR PARTS MERCHANDISE FLEET MANAGEMENT
105716 328.05 MTI DISTRIBUTING INC MERCHANDISE FLEET MANAGEMENT
105717 1,967.34 MUNICIPAL EMERGENCY SERVICES OPERATING SUPPLIES FIRE MANAGEMENT
105718 41.19 MVEC ELECTRIC PARK BLDGS MAINT
CITY OF SHAKOPEE 9/11/2009 8:49:12
R55CKREG LOG22000VO
Council Check Register Page- 3
9/2/2009 -- 9/11/2009
Check # Amount Vendor I Explanation Account Description Business Unit
- -
105719 533.31 NEENAH FOUNDRY CO OPERATING SUPPLIES CATCH BASIN MAINT
105720 26.40 NIKUNEN,JESSICA TRA VEUSUBSISTENCE PERSONNEL - PAYROLL
105721 9,103.80 OWENS COMPANIES INC BUILDING MAINT. COMM CTR FACILITIES
105722 205.20 PARTEK SUPPLY INC MATERIALS ATHLETIC MAINT & FIELDS
105723 18,900.00 PASS FENCING & GEN MAINT INC EQUIPMENT SOCCER BUILDING
105724 44.33 PRECISION METAL FAB RACING MERCHANDISE FLEET MANAGEMENT
105725 470.25 PRODUCER'S CHOICE OPERATING SUPPLIES PARK MAINT/GARBAGE PICKUP
105726 540.00 PUBLIC SAFETY EQUIPMENT. LLC OTHER PROF SERVICES DWI FORFEITURE
105727 26.00 QUALITY FOOTCARE PERFORMERS/INSTRUCTORS RECREATION PROGRAMS
105728 849.87 QUALITY FORKLIFT SALES AND SER EQUIPMENT MAINTENANCE FIRE MANAGEMENT
105729 40.77 QUILL OFFICE SUPPLIES POLICE MANAGEMENT
105730 135.00 RELIABLE WELDING EQUIPMENT MAINTENANCE PLAYGROUND MAINT
105731 447.29 ROBERT B HILL CO EQUIPMENT MAINTENANCE TRUCK WASH
105732 1,925.52 ROYAL TIRE, INC MERCHANDISE FLEET MANAGEMENT
105733 5,285.00 RW FARMS LLC OTHER PROF SERVICES DITCH & POND MAINT
105734 12,577.50 SAVAGE, CITY OF SEWER SEWER MANAGEMENT
105735 31,524.30 SCOTT CO TREASURER UNIFORMS/CLOTHING TRI-CITY TACTICAL TEAM
105736 536.00 SESACINC OTHER PROF SERVICES TEEN CENTER
105737 4,752.30 SHAKO PEE PUBLIC SCHOOL DIST 7 PRINTINGIPUBLlSHING RECREATION MANAGEMENT
105738 24.44 SHAKOPEE CHEV INC MERCHANDISE FLEET MANAGEMENT
105739 123.12 SHAKOPEE GRAVEL INC MATERIALS DOWNTOWN
105740 601.48 SHAKO PEE PUBLIC UTILITY COMM BUILDING MAINT SUPPLIES PW BLDGIY ARD MAINT
105741 150.00 SHAKOPEE ROTARY CLUB DUES ADMINISTRATION
105742 800.00 SHAKO PEE TOWING INC OTHER PROF SERVICES DWI FORFEITURE
105743 7.37 SINDELAR,JEFF TRA VEUSUBSISTENCE FACILITIES MANAGEMENT
105744 1,236.85 SKYHAWKS SPORTS ACADEMY INC PERFORMERSIINSTRUCTORS RECREATION PROGRAMS
105745 45.05 SOUTHWEST OUTDOOR POWER MERCHANDISE FLEET MANAGEMENT
105746 416.81 SPORT STOP OPERATING SUPPLIES PATROL
105747 4,850.00 SPRINGSTED INC FISCAL AGENT FEES 2004B BLDG REFUNDING BONDS
105748 1,356.02 STREICHER'S UNIFORMS/CLOTHING PATROL
105749 302.09 SUEL PRINTING CO PRINTING/PUBLlSHING PATROL
105750 341.87 SWANK MOTION PICTURES, INC PERFORMERS/INSTRUCTORS PARK SERVICES
105751 534,747.01 VALLEY PAVING, INC IMPROVEMENTS 09-22009 STREET IMPROVEMENTS
105752 213.75 VALLEY SPORTS RECREATION SUPPLIES RECREATION PROGRAMS
105753 47,149.55 VEIT & COMPANY INC IMPROVEMENTS 09-4 2009 CIPP
105754 234.26 VIKING ELEC SUPPLY INC OPERATING SUPPLIES PARK MAINT/GARBAGE PICKUP
105755 5,575.77 VPSIINC TRANSPORTATION TRANSIT VAN POOL
105756 9,572.50 WSB & ASSOC INC DEPOSITS PAYABLE ESCROW FUND
105757 240.05 XCEL ENERGY ELECTRIC STREET MAINTENANCE
105758 696.75 CIT TECHNOLOGY FIN SERV , INC EQUIPMENT RENT POLICE MANAGEMENT
105759 378.83 GENESIS OPERATING SUPPLIES DITCH & POND MAINT
R55CKREG LOG22000VO CITY OF SHAKOPEE 9/11/2009 8:49:12
Council Check Register Page - 4
9/2/2009 - 9/11/2009
Check # Amount Vendor I Explanation Account Description Business Unit
- -
105760 500.00 HAYNES, TRICIA PERFORMERS/INSTRUCTORS PARK SERVICES
105761 54.25 HEILMAN, MAUREEN MEMBERSHIPS CIVIC CENTER
105762 4,292.08 MINNESOTA DEED DUE TO OTHER GOVERNMENTS LONG REVOLVING LOAN
105763 1,021.38 NAPA GENUINE PARTS CO MERCHANDISE FLEET MANAGEMENT
105764 81.86 QWEST TELEPHONE POOL MANAGEMENT
105765 579.38 SAM'S CLUB MERCHANDISE POOL MANAGEMENT
105766 1,500.00 SCOTT CO METH TASK FORCE OTHER PROF SERVICES FORFEITURE
105767 8,514.00 SHAKOPEE PUBLIC UTILITY COMM INSURANCE DIVIDENDSIFEES GENERAL FUND
105768 43,451.22 SHAKOPEE PUBLIC UTILITY COMM ELECTRIC ICE ARENA MANAGEMENT
105769 250.00 SONGER,ERIC PERFORMERS/INSTRUCTORS PARK SERVICES
105770 94.00 TEEKADHARRY, NICO LESSONS POOL MANAGEMENT
1,095,814.07 Grand Total
Payment Instrument Totals
Check Total 1,095,814.07
Total Payments 1,095,814.07