HomeMy WebLinkAbout5.F.1. City Bill List
#5F1
"CONSENT"
CITY OF SHAKO PEE
Memorandum
TO: Mayor and Council
Mark McNeill, City Administrator
FROM: Gregg Voxland, Finance Director
RE: City Bill List
DATE: October29,2009
Introduction and Background
Attached is the print-out showing the division budget status for 2009 based on data entered as of
10/30/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.
Visioning Relationship
None perceived routine.
Action ReQuested
Move to approve the bills in the amount of $531A13.92 and electronic transfers in the amount of
$380,614.45 for a total of $912,028.37.
Funds transferred electronicaly October 17,2009 to October 30,2009.
. PAYROLL $ 221,285.69
FIT /FICA/M EDICA 61,158.42
STATE INCOME TAX 13,243.44
PERA 53,685.39
HEALTH CARE SAVINGS 12,741.14
HEALTH SAVINGS ACCT
FLEX SPENDING ACCT
NATIONWIDE DEF COMP 11,600.48
ICMA DEFERRED COMP 1,568.18
CHILD SUPPORT
AFLAC 3,840.53
SALES & USE TAX
FUEL TAX 1,491.18
BANK FEES
TOTAL $ 380,614.45
R5509FIN1 LOGIS003 CITY OF SHAKOPEE 10/29/200911 :42:55
By Co (pb), Div (Totals Only) Monthly Financial Report Page - 1
2009
2009 11/30/2009 2009 <===================== 2008 ~====================>
Annual Current YTD Budget Per Cent I Prior Year Same Period Prior Per Cent
---_._-~.,--- Description Budget Period Actual Balance Used I Budget Year YTD Actual Used
- -_._-~--~ --_._~--~---_. --------._---~._-_.- --.....--
01000 GENERAL FUND
11 MAYOR & COUNCIL 165,700.00 110,146.09 55,553.91 66.47 I 177,390.00 119.350.50 67.28
12 CITY ADMINISTRATOR 553,930.00 414,787.36 139,142.64 74.88 I 519,120.00 418.739.40 80.66
13 CITY CLERK 310,200.00 226,935.47 83,264.53 73.16 I 366.440.00 280.616.45 76.58
15 FINANCE 819.090.00 651,089.89 168,000.11 79.49 I 772,100.00 668.511.51 86.58
16 LEGAL COUNSEL 473,500.00 306,095.36 167,404.64 64.65 I 533,500.00 506,098.90 94.86
17 COMMUNITY DEVELOPMENT 505,820.00 383,408.34 122,411.66 75.80 I 549,150.00 462,595.27 84.24
18 FACILITIES 236,250.00 202,390.54 33,859.46 85.67 I 309,030.00 213,520.00 69.09
20 INFORMATION TECHNOLOGY 359,170.00 271,044.88 88,125.12 75.46 I 313,120.00 269,513.62 86.07
31 POLICE DEPARTMENT 6,199.710.00 4,794.023.36 1,405,686.64 77.33 I 5,920,620.00 5,128,770.13 86.63
32 FIRE 1.974,480.00 1,446,242.90 528,237.10 73.25 I 1,933,710.00 1,618,373.96 83.69
33 INSPECTION-BLDG-PLMBG-HTG 745.130.00 624,290.19 120,839.81 83.78 I 823,690.00 718,320.73 87.21
41 ENGINEERING 685,300.00 438,232.68 247,067.32 63.95 I 790,090.00 553,149.65 70.01
42 STREET MAINTENANCE 1.799,020.00 1,421,876.60 377,143.40 79.04 I 1,973,070.00 1,573,127.17 79.73
44 FLEET 103,640.00 143,371.82 39,731.82- 138.34 I 95.990.00 94.833.55 98.80
46 PARK MAINTENANCE 1,495,000.00 1,118,939.23 376,060.77 74.85 I 1,579,820.00 1,297,361.82 82.12
65 LIBRARY/CONGREGATE DINING 323.380.00 207,942.41 115,437.59 64.30 I 302.350.00 249,848.70 82.64
66 NATURAL RESOURCES 66,230.00 27,200.96 39,029.04 41.07 I 128,030.00 99,695.03 77.87
91 UNALLOCATED 150,000.00 78,725.71 71,274.29 52.48 I 157,240.00 66,700.79 42.42
~---~- ....-----.-.----..-- ~_.
01000 GENERAL FUND 16,965,550.00 12,866,743.79 4,098,806.21 75.84 I 17,244,460.00 14,339,127.18 83.15
02140 TRANSIT
17 COMMUNITY DEVELOPMENT 1.173.500.00 850,258.96 323,241.04 72.45 I 2,080,840.00 831,313.30 39.95
-~- ----------."..- ._>~-
02140 TRANSIT 1.173,500.00 850,258.96 323,241.04 72.45 I 2.080.840.00 831,313.30 39.95
02190 EDA
19 EDA 116,680.00 59,660.02 57,019.98 51.13 I 123,770.00 39.985.42 32.31
~--~~- --~~._-- -- ."----.-------- .'---- --...------..- .-.._-
02190 EDA 116,680.00 59,660.02 57.019.98 51.13 I 123,770.00 39.985.42 32.31
07500 RECREATION FUND
75 RECREATION PROGRAMS 2,407,360.00 1,779,242.25 628,117.75 73.91 I 2,250.660.00 2,070,544.53 92.00
-~- ------ -...- ------------.--.-"..,-- ... ------_.,--
07500 RECREATION FUND 2,407,360.00 1.779,242.25 628,117.75 73.91 I 2,250,660.00 2,070,544.53 92.00
R55CKSUM LOG20000 CITY OF SHAKO PEE 10/29/200911:36:59
Council Check Summary Page - 1
10/16/2009 - 11/1/2009
~~~pany Amount
-
01000 GENERAL FUND 183,774.78
02120 FORFEITURE 1,892.33
02140 TRANSIT 157,033.45
02170 REVOLVING LOAN 4,292.08
04020 PARK RESERVE 6,009.74
04021 CAPITAL IMPROVEMENT FUND 990.00
07100 SEWER FUND 6,661.28
07300 SURFACE WATER FUND 1,055.17
07500 RECREATION FUND 6,581.70
08025 SW METRO DRUG TASK FORCE 18.316.60
08040 ESCROW FUND 143.518.27
08050 INVESTMENT TRUST FUND 1,288.52
Report Totals 531,413.92
R55CKREG LOG22000VO CITY OF SHAKOPEE 10/29/200911:36:41
Council Check Register Page- 1
10/16/200911/1/2009
Check # Amount Vendor / Explanation j\ccount ~~cript~n_ Business Unit
_u_" --- --.-----....---
106098 450.00 A TOUCH OF MAGIC PERFORMERS/INSTRUCTORS CIVIC CENTER
106099 639.00 APPLE FORD OF SHAKOPEE INC EQUIPMENT RENT SWMDTF - FORFEITURES
106100 40.00 BAKKE, STEPHANIE YOUTH ACTIVITIES RECREATION PROGRAMS
106101 489.41 BELLE PLAINE POLICE DEPARTMENT STATE GRANTS & AIDS POLICE GRANTS
106102 225.00 BRIO BRASS PERFORMERS/INSTRUCTORS PARK SERVICES
106103 5.260.75 CARVER COUNTY WAGES FT REG SWMDTF - FORFEITURES
106104 893.07 CENTERPOINT ENERGY SERVCIES IN GAS PARK BLDGS MAINT
106105 21,750.00 CENTEX HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106106 8,750.00 CHARLES MERRITT HOMES INC RESID LANDSCAPE PAYABLE ESCROVY FUND
106107 200.00 COLONY PLAZA INC OTHER PROF SERVICES SWMDTF - FORFEITURES
106108 168.95 COMCAST COMPUTER ACCESS INFORMATION TECHNOLOGY
106109 15,269.50 CONVENTION & VISITORS BUREAU LODGING TAX LODGING TAX
106110 3,250.00 D R HORTON RESID LANDSCAPE PAYABLE ESCROW FUND
106111 7,651.70 DELTA DENTAL PLAN OF MN DENTAL INSURANCE PAYROLL CLEARING
106112 333.46 DICK'S SANITATION INC SA PREPAY REFUSE CERTIFICATION
106113 20.00 DRIVER AND VEHICLE SERVICES EQUIPMENT MAINTENANCE DWI FORFEITURE
106114 20.00 DRIVER AND VEHICLE SERVICES EQUIPMENT MAINTENANCE DWI FORFEITURE
106115 16,048.79 FIELDSTONE FAMILY HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106116 1,500.00 FLATEGRAFF, TOREY RESID LANDSCAPE PAYABLE ESCROW FUND
106117 2.250.00 GECKLER & ASSOCIATES RESID LANDSCAPE PAYABLE ESCROW FUND
106118 2,300.00 HUTCHINSON POLICE DEPT WAGES FT REG SWMDTF - MATCH
106119 1,068.33 JORDAN POLICE DEPARTMENT STATE GRANTS &AIDS POLICE GRANTS
106120 3,250.00 KEYLAND HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106121 114.00 KHAN, SAIRA LESSONS ICE ARENA MANAGEMENT
106122 84,758.00 KT J LIMITED PARTNERSHIP EIGHTE DEPOSITS PAYABLE ESCROW FUND
106123 94,380.73 MEDICA HEALTH PAYABLE PAYROLL CLEARING
106124 3,250.00 MINKS CUSTOM HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106125 4.292.08 MINNESOTA DEED DUE TO OTHER GOVERNMENTS LONG REVOLVING LOAN
106126 242.00 MN COMM OF FINANCE TREAS DIV FINES & FORFEITS FORFEITURE
106127 216.00 MX LOGIC INC SOFTWARE-ANNUAL FEES INFORMATION TECHNOLOGY
106128 61.90 NAPA AUTO PARTS OPERATING SUPPLIES SWMDTF - FORFEITURES
106129 1,366.77 NEW PRAGUE, CITY OF STATE GRANTS & AIDS POLICE GRANTS
106130 199.95 NEXTEL COMMUNICATIONS TELEPHONE SWMDTF - FORFEITURES
106131 83.00 NUGENT. SUE YOUTH ACTIVITIES RECREATION PROGRAMS
106132 1,616.21 PRIOR LAKE, CITY OF STATE GRANTS & AIDS POLICE GRANTS
106133 3,146.47 SAVAGE, CITY OF STATE GRANTS & AIDS POLICE GRANTS
106134 484.00 SCOTT CO ATTORNEY'S OFFICE FINES & FORFEITS FORFEITURE
106135 2,523.52 SCOTT CO SHERIFF STATE GRANTS & AIDS POLICE GRANTS
106136 4,775.00 SCOTT CO TREASURER WAGES FT REG SWMDTF - FORFEITURES
106137 2,380.00 SHAKOPEE, CITY OF WAGES FT REG SWMDTF - STATE GRANT
106138 6.38 SORTUM,MICHAEL OPERATING SUPPLIES CIVIC CENTER
R55CKREG LOG22000VO CITY OF SHAKOPEE 10/29/200911 :36:41
Council Check Register Page - 2
10/16/200fl11/1/2009
Check # Amount Vendor / Explanation Account Description Business Unit
~ --~--_._----_...-
106139 83.88 XCEL ENERGY ELECTRIC STREET MAINTENANCE
106140 2,500.00 SCHMIDTKE, DOUG PURCHASE OF EVIDENCE SWMDTF - FORFEITURES
106141 82.50 WEATHERGUARD CONSTRUCTION MISCELLANEOUS GENERAL FUND
106142 984.10 2XL CORPORATION OPERATING SUPPLIES COMM CTR FACILITIES
106143 260.66 A TO Z AUTOGLASS MERCHANDISE FLEET MANAGEMENT
106144 1,310.86 ADVANTAGE COMMUNICATIONS INC EQUIPMENT MAINTENANCE INFORMATION TECHNOLOGY
106145 112.49 AG POWER ENTERPRISES, INC MERCHANDISE FLEET MANAGEMENT
106146 277.35 ANCOM COMMUNICATIONS INC EQUIPMENT MAINTENANCE FIRE MANAGEMENT
106147 867.47 APPLE FORD OF SHAKOPEE INC MERCHANDISE FLEET MANAGEMENT
106148 30.00 AVCAM DUES PATROL
106149 895.00 BDM CONSULTING ENGINEERS. PLC ENGINEERING CONSULTANTS NATURAL RESOURCES
106150 12.22 BOSEK,L YLE TRAVEL/SUBSISTENCE INSPECTION MANAGEMENT
106151 106.28 BOYER TRUCKS MERCHANDISE FLEET MANAGEMENT
106152 35.68 BREEGGEMANN,THOMAS TRAVEL/SUBSISTENCE FIRE MANAGEMENT
106153 989.21 BRYAN ROCK PRODUCTS MATERIALS ATHLETIC MAINT & FIELDS
106154 162.41 C & E AUTO UPHOLSTERY MERCHANDISE FLEET MANAGEMENT
106155 32.33 COW GOVERNMENT INC OPERATING SUPPLIES RECORDS
106156 671.28 CERTIFIED APPLIANCE RECYCLING OTHER PROF SERVICES REFUSE & CLEAN-UP DAY
106157 464.00 CHOICE ELECTRIC INC BUILDING MAl NT. PARK BLDGS MAINT
106158 295.04 CIT TECHNOLOGY FIN SERV , INC EQUIPMENT RENT POLICE MANAGEMENT
106159 879.31 CLAREY'S SAFETY EQUIP INC EQUIPMENT MAINTENANCE FIRE MANAGEMENT
106160 22.15 COLEMAN, RICK TRAVEL/SUBSISTENCE FIRE MANAGEMENT
106161 142.03 COMMERCIAL ASPHALT CO MATERIALS STREET MAINTENANCE
106162 130.17 CRETEX CONCRETE PRODUCTS NORTH OPERATING SUPPLIES MANHOLE MAINT
106163 1,023.91 CUSTOM REFRIGERATION INC BUILDING MAl NT. ICE ARENA MANAGEMENT
106164 67.00 DAKOTA COUNTY RECEIVING CENTER OTHER PROF SERVICES PATROL
106165 12.22 DAVIS, JIM TRAVEL/SUBSISTENCE INSPECTION MANAGEMENT
106166 1,340.43 DELTA FOREMOST MATERIALS SNOW/SAND
106167 5,476.93 DETERMAN BROWNIE, INC OTHER PROF SERVICES SEWER MANAGEMENT
106168 220.75 DUBBES TURF FARM MATERIALS ATHLETIC MAINT & FIELDS
106169 2,651.94 EARL F ANDERSEN INC IMPROVEMENTS PROVIDENCE-WESTCHESTER PARK
106170 56.22 EMERGENCY AUTO TECHNOLOGIES IN EQUIPMENT MAINTENANCE PATROL
106171 1,843.67 EMERGENCY MEDICAL PRODUCTS IN OPERATING SUPPLIES PATROL
106172 16.03 EXECUTIVE OCEAN OTHER PROF SERVICES FIRE MANAGEMENT
106173 206.10 FASTENAL OPERATING SUPPLIES PARK MAl NT/GARBAGE PICKUP
106174 888.75 G C BENTLEY ASSOC INC OTHER PROF SERVICES TRANSIT
106175 182.20 GENERAL SAFETY EQUIPMENT EQUIPMENT MAINTENANCE FIRE MANAGEMENT
106176 12.22 GRAMPRE. JIM TRAVEL/SUBSISTENCE INSPECTION MANAGEMENT
106177 319.98 HIRSHFIELD'S PAINT MFG INC OPERATING SUPPLIES ATHLETIC MAINT & FIELDS
106178 597.90 HYDROLOGIC WATER MANAGEMENT IN OPERATING SUPPLIES ATHLETIC MAINT & FIELDS
106179 607.50 INETIUM, LLC COMPUTER SERVICES INFORMATION TECHNOLOGY
R55CKREG LOG22000VO CITY OF SHAKOPEE 10/29/200911 :36:41
Council Check Register Page- 3
10/16/200011/1/2009
Check # Amount Vendor / Explanation Account Description Business Unit
-_.~-.- -- . .._----~---- --"
106180 5,540.25 KELLEY FUELS, INC DIESEL GENERAL FUND
106181 22,99 KLIMEK, EILEEN TRAVEUSUBSISTENCE FINANCE MANAGEMENT
106182 90.45 KRIESEL, DAVID TRAVEL/SUBSISTENCE INSPECTION MANAGEMENT
106183 2.093.60 KROMINGA, TERRY OTHER PROF SERVICES INSPECTION MANAGEMENT
106184 227.00 LAKE COUNTRY DOOR LLC OPERATING SUPPLIES CAR WASH
106185 237.26 LANDSCAPE STRUCTURES INC OPERATING SUPPLIES PLAYGROUND MAINT
106186 190.50 LIBERTY TIRE RECYCLING LLC MERCHANDISE FLEET MANAGEMENT
106187 118.48 LOCATORS & SUPPLIES INC . UNIFORMS/CLOTHING STREET MANAGEMENT
106188 349.17 LOFFLER BUSINESS SYSTEMS INC PRINTING/PUBLISHING UNALLOCATED
106189 11,845.00 LOGIS SOFTWARE-ANNUAL FEES PLANNING MANAGEMENT
106190 128.18 LUBRICATION TECHNOLOGIES INC MOTOR FUELS & LUBRICANTS PARK EQUIPMENT MAINTENANCE
106191 25.00 MAMA TRA VEUSUBSISTENCE ADMINISTRATION
106192 147.00 MALONE,THOMAS M PERFORMERS/ INSTRUCTORS RECREATION PROGRAMS
106193 3,000.00 MARKS,CRYSTAL CONFERENCE/SCHOOL/TRAINING PATROL
106194 312.08 MATRIX LASER CARE INC OFFICE SUPPLIES POLICE MANAGEMENT
106195 100.00 MENDOZA, ERIKA OTHER PROF SERVICES INVESTIGATION
106196 110.75 MINNESOTA PLUMBING & HEATING I BUILDING MAINT. LIBRARY
106197 656.94 MJB MACHINERY OPERATING SUPPLIES FLEET MANAGEMENT
106198 150.00 MN DEPT OF TRANSPORTATION CONFERENCE/SCHOOL/TRAINING STREET MANAGEMENT
106199 515.00 MN MAINTENANCE EXPO CONFERENCElSCHOOL/TRAINING STREET MANAGEMENT
106200 3,564.40 MUNICIPAL EMERGENCY SERVICES OPERATING SUPPLIES FIRE MANAGEMENT
106201 389.63 NEOPOST INC OPERATING SUPPLIES CLERK MANAGEMENT
106202 252.00 NETZ, ANNA PERFORMERS/INSTRUCTORS RECREATION PROGRAMS
106203 116.26 NORTHLAND CHEMICAL CORP OPERATING SUPPLIES ICE ARENA MANAGEMENT
106204 2,346.64 OFFICE OF ENTERPRISE TECHNOLOG TELEPHONE POLICE MANAGEMENT
106205 168.00 ONCE UPON A STAR PERFORMERS/INSTRUCTORS RECREATION PROGRAMS
106206 3,357.80 PANNIER OPERATING SUPPLIES PARK RESERVE
106207 113,29 PRECISION METAL FAB RACING MERCHANDISE FLEET MANAGEMENT
106208 143.50 PROGRESS VALLEY ELECTRIC INC BUILDING MAl NT. ICE ARENA MANAGEMENT
106209 104.04 QUILL OFFICE SUPPLIES POLICE MANAGEMENT
106210 203.00 RIDGEVIEW MEDICAL CENTER OTHER PROF SERVICES RECORDS
106211 78.02 RIVERFRONT PRESS PRINTING/PUBLISHING POLICE MANAGEMENT
106212 4,814.11 SANDY'S PROMOTIONAL STUFF OPERATING SUPPLIES FIRE MANAGEMENT
106213 41.065.79 SCHMITTY & SONS SCHOOL BUSES, TRANSPORTATION EXPRESS
106214 109,503.14 SCOTT CO TREASURER TRANSPORTATION TRANSIT D-A-R
106215 990.00 SHAKO PEE PUBLIC UTILITY COMM OTHER PROF SERVICES 09-7 CHURCH ADDITION
106216 547.12 SHAKOPEE TOWING INC OTHER PROF SERVICES FORFEITURE
106217 2,628.61 SIMPLEXGRINNELL LP BUILDING MAINT. FACILITIES - POLICE
106218 875.65 TATE, JEFF TRA VEUSUBSISTENCE POLICE MANAGEMENT
106219 5,575.77 VPSIINC TRANSPORTATION TRANSIT VAN POOL
106220 195.98 WESTSIDE EQUIP OPERATING SUPPLIES PW BLDGIYARD MAINT
R55CKREG LOG22000VO CITY OF SHAKOPEE 10/29/200911 :36:41
Council Check Register Page- 4
10/16/2009 11/1/2009
Check # Amount Vendor / Explanation Account Description Business Unit
- ------..
106221 2,673.50 WSB & ASSOC INC ENGINEERING CONSUL TNTS ENGINEERING DEVELOPER PROJECTS
106222 210.48 XCEL ENERGY ELECTRIC STREET MAINTENANCE
106223 304.43 ZACKS OPERATING SUPPLIES SEWER MANAGEMENT
106224 50.00 AVCAM CONFERENCElSCHOOLrrRAINING PATROL
106225 1,708.32 CENTERPOINT ENERGY SERVCIES I GAS ICE ARENA MANAGEMENT
106226 15.66 CENTERPOINT ENERGY SERVCIES IN GAS POOL MANAGEMENT
106227 401.71 CIT TECHNOLOGY FIN SERV , INC EQUIPMENT RENT RECREATION PROGRAMS
106228 155.32 LOPEZ, CONCEPTION PARK FACILITY RENTAL PARK SERVICES
106229 135.99 MN COMM OF FINANCE TREAS DIV FINES & FORFEITS FORFEITURE
106230 271.97 SCOTT CO ATTORNEY'S OFFICE FINES & FORFEITS FORFEITURE
531,413.92 Grand Total
Payment Instrument Totals
Check Total 531,413.92
Total Payments 531.413.92