Loading...
HomeMy WebLinkAbout5.F.1. City Bill List -4 #5F1 "CONSENT" CITY OF SHAKOPEE Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Julie Linnihan, Finance Director RE: City Bill List DATE: July 1, 2011 Introduction and Background Attached is the print -out showing the division budget status for 2011 based on data entered as of 6/30/2011 with comparison to the similar data of 2010. Approximately 50 % of the budget year is complete, but several billings remain outstanding for June, 2011. • This payment request provides for the 2011 street pavement preservation, in the amount of $372,645.20 to Astech Corporation. • Several payments have been made to contractors for maintenance work on catch basin, manhole and pipe repair. • Transit fund payments have been made to Schmitty & Sons and Scott County Treasurer for May activity and charges. • The first half settlement has been received from Scott County, and finance staff is awaiting the detail breakdown from the County, specific to the property taxes, special assessments, delinquencies and other fees and charges that will be allocated per distribution. 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 $815,025.77 and electronic transfers in the amount of $512,129.69 for a total of $1,327,155.46. . 4. R5509FIN1 LOGIS003 CITY OF SHAKOPEE 7/1/2011 11:37:57 By Co (pb), Div (Totals Only) Monthly Financial Report Page - 1 2011 2011 6/30/2011 2011 < 2010 > Annual Current YTD Budget Per Cent j Prior Year Same Period Prior Per Cent Description Budget Period Actual Balance Used Budget Year YTD Actual Used 01000 GENERAL FUND 11 MAYOR & COUNCIL 202,240.00 4,871.11 80,742.81 121,497.19 39.92 207,820.00 82,987.42 39.93 12 ADMINISTRATION 793,030.00 43,370.90 301,045.70 491,984.30 37.96 755,210.00 307,179.38 40.67 13 CITY CLERK 327,180.00 24,407.19 137,022.02 190,157.98 41.88 325,880.00 138,057.35 42.36 15 FINANCE 794,600.00 36,876.03 501,943.22 292,656.78 63.17 852,100.00 438,199.44 51,43 17 COMMUNITY DEVELOPMENT 495,800.00 30,153.98 188,099.12 307,700.88 37.94 1 468,340.00 230,098.69 49.13 18 FACILITIES 214,610.00 12,046.05 80,552.76 134,057.24 37.53 228,500.00 88,998.24 38.95 20 INFORMATION TECHNOLOGY 207,240.00 14,553.34 88,286.40 118,953.60 42.60 399,400.00 221,172.14 55.38 31 POLICE DEPARTMENT 6,969,270.00 411,595.72 2,983,497.20 3,985,772.80 42.81 6,578,460.00 3,001,810.62 45.63 32 FIRE 1,945,360.00 52,835.14 715,148.00 1,230,212.00 36.76 1,940,080.00 746,646.44 38.49 33 INSPECTION - BLDG - PLMBG -HTG 801,100.00 48,023.17 335,843.95 465,256.05 41.92 765,660.00 370,581.28 48.40 41 ENGINEERING 661,630.00 39,745.90 289,632.60 371,997.40 43.78 663,030.00 246,394.83 37.16 42 STREET MAINTENANCE 2,059,700.00 75,088.99 748,108.57 1,311,591.43 36.32 1,947,510.00 724,963.46 37.23 44 FLEET 122,330.00 27,317.26 95,122.56 27,207.44 77.76 103,550.00 24,908.53 24.05 46 PARK MAINTENANCE 1,576,910.00 78,887.14 528,829.39 1,048,080.61 33.54 1,602,640.00 679,908.67 42.42 65 LIBRARY 304,330.00 6,823.57 106,352.31 197,977.69 34.95 345,150.00 140,356.66 40.67 66 NATURAL RESOURCES 58,400.00 462.57 5,468.14 52,931.86 9.36 54,970.00 17,200.97 31.29 67 RECREATION 2,421,910.00 136,996.25 889,800.30 1,532,109.70 36.74 1 2,411,120.00 1,076,686.87 44.66 91 UNALLOCATED 220,000.00 180.99 654.23 219,345.77 .30 142,000.00 355,253.21- 250.18- 01000 GENERAL FUND 20,175,640.00 1,044,235.30 8,076,149.28 12,099,490.72 40.03 19,791,420.00 8,180,897.78 41.34 02140 TRANSIT 17 COMMUNITY DEVELOPMENT 1,191,270.00 11,740.96 425,561.02 765,708.98 35.72 1,134,450.00 430,069.54 37.91 02140 TRANSIT 1,191,270.00 11,740.96 425,561.02 765,708.98 35.72 1,134,450.00 430,069.54 37.91 02190 EDA 19 EDA 49,730.00 1,224.44 13,761.19 35,968.81 27.67 39,210.00 9,693.96 24.72 02190 EDA 49,730.00 1,224.44 13,761.19 35,968.81 27.67 39,210.00 9,693.96 24.72 R55CKSUM LOG20000 CITY OF SUAKOPEE 7/1/2011 9:35:35 Council Check Summary Page - 1 6/18/2011 - 7/1/2011 Company Amount 01000 GENERAL FUND 560,871.95 02120 FORFEITURE 2,019.33 02140 TRANSIT 92,116.82 04020 PARK RESERVE 1,513.50 04068 FIRE STATION 2 2011 5.10 04069 2011 PROJECTS 7,629.50 07100 SEWER FUND 8,035.18 07300 SURFACE WATER FUND 108,487.36 07805 PARK ASSET I.S. FUND 150.58 07806 INFO TECH 1.S. FUND 11,917.88 07810 BUILDING I.S. FUND 5,081.54 08025 SW METRO DRUG TASK FORCE 10,231.27 08040 ESCROW FUND 6,965.76 Report Totals 815,025.77 R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 1 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 52011 6/30/2011 109764 CORPORATE PAYMENT SYSTEMS 65.11 LOWES #02628* 67197 MAY -11 0673.6202 OPERATING SUPPLIES ICE ARENA MANAGEMENT 11.58- 67198 MAY -11 1000.2080 USE TAX GENERAL FUND 180.04 VIKING INDUSTRIAL CENTER 67198 MAY -11 0673.6202 OPERATING SUPPLIES ICE ARENA MANAGEMENT 69.20 OFFICE MAX 67199 MAY -11 0673.6202 OPERATING SUPPLIES ICE ARENA MANAGEMENT 1.53 LOWES #02628* 67200 MAY -11 0673.6230 BUILDING MAINT SUPPLIES ICE ARENA MANAGEMENT 18.80- 67201 MAY -11 1000.2080 USE TAX GENERAL FUND 292.31 PATRIOT SUPPLY 67201 MAY -11 0673.6230 BUILDING MAINT SUPPLIES ICE ARENA MANAGEMENT 165.63 AUTOZONE #3074 67202 MAY -11 0673.6230 BUILDING MAINT SUPPLIES ICE ARENA MANAGEMENT 8.24 - 67203 MAY -11 1000.2080 USE TAX GENERAL FUND 128.09 B & H PHOTO - VIDEO.COM 67203 MAY -11 0127.6202 OPERATING SUPPLIES TELECOMMUNCATION 194.21 GRAND VIEW LODGE & TENNIS 67204 MAY -11 0121.6475 TRAVEUSUBSISTENCE ADMINISTRATION 19.95 PAY FLOW PRO 67205 MAY -11 0331.6650 CREDIT CARD FEES INSPECTION MANAGEMENT 59.95 PAY FLOW PRO 67206 MAY -11 0671.6650 CREDIT CARD FEES RECREATION MANAGEMENT 85.50 MILLER DAVIS 67207 MAY -11 0111.6210 OFFICE SUPPLIES MAYOR & COUNCIL 1.78- 67208 MAY -11 1000.2080 USE TAX GENERAL FUND 27.72 DISCOUNTCELL 67208 MAY -11 0311.6202 OPERATING SUPPLIES POLICE MANAGEMENT 5.35 USPS 26860008733413030 67209 MAY -11 0311.6332 POSTAGE POLICE MANAGEMENT 1.03- 67210 MAY -11 1000.2080 USE TAX GENERAL FUND 15.98 DISCOUNTCELL 67210 MAY -11 0311.6202 OPERATING SUPPLIES POLICE MANAGEMENT 1.72 67211 MAY -11 1000.2080 USE TAX GENERAL FUND 26.67- DISCOUNTCELL 67211 MAY -11 0311.6202 OPERATING SUPPLIES POLICE MANAGEMENT 15.94 DISCOUNTCELL 67212 MAY -11 0311.6202 OPERATING SUPPLIES POLICE MANAGEMENT 7.00- 67213 MAY -11 7806.2080 USE TAX INFO TECH I.S. FUND 108.76 TAPE4BACKUP.COM 67213 MAY -11 7806.6202 OPERATING SUPPLIES INFO TECH I.S. FUND 99.95 EXPERTS EXCHANGE LLC 67214 MAY -11 0172.6490 SUBSCRIPTIONS /PUBLICATIONS INFORMATION TECHNOLOGY 809.00 TRAIN SIGNAL CORP 67215 MAY -11 0172.6472 CONFERENCE/SCHOOL/TRAINING INFORMATION TECHNOLOGY 13.92 - 67216 MAY -11 7806.2080 USE TAX INFO TECH I.S. FUND 216.37 CABLES TO GO 67216 MAY -11 7806.6202 OPERATING SUPPLIES INFO TECH I.S. FUND 2.47- 67217 MAY -11 1000.2080 USE TAX GENERAL FUND 38.42 ORIENTAL TRADING CO 67217 MAY -11 0674.6211 RECREATION SUPPLIES COMMUNITY CENTER 6.72 RADIOSHACK COR00161489 67218 MAY -11 0675.6202 OPERATING SUPPLIES PARK SERVICES 141.94 HIGH SCORE VIDEO GAMES 67219 MAY -11 0676.6211 RECREATION SUPPLIES TEEN CENTER 54.30 HIGH SCORE VIDEO GAMES 67220 MAY -11 0676.6211 RECREATION SUPPLIES TEEN CENTER 64.45 KERNEL CONCESSION SUPPLY 67221 MAY -11 0676.6250 MERCHANDISE TEEN CENTER 406.11 BEST BUY 00014639 67222 MAY -11 0674.6202 OPERATING SUPPLIES COMMUNITY CENTER 203.05 OFFICE MAX 67223 MAY -11 0676.6202 OPERATING SUPPLIES TEEN CENTER 95.20 STAR TRAC 67224 MAY -11 0674.6240 EQUIPMENT MAINTENANCE COMMUNITY CENTER 21.35 TARGET 00012724 67225 MAY -11 0672.6211 RECREATION SUPPLIES POOL MANAGEMENT 349.49 STAYWELL- KRAMES 67226 MAY -11 0672.6211 RECREATION SUPPLIES POOL MANAGEMENT 160.00 SAFE FOOD TRAINING 67227 MAY -11 0672.6472 CONFERENCE /SCHOOL/TRAINING POOL MANAGEMENT • R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 3 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 8,850.91 112183 6/23/2011 101110 CENTERPOINT ENERGY SERVCIES I 998.45 66960 2200412 0673.6365 GAS ICE ARENA MANAGEMENT 1,497.67 66960 2200412 0678.6365 GAS COMM CSR FACILITIES 2,496.12 112184 6/23/2011 101349 CENTERPOINT ENERGY SERVCIES IN 12.83 66961 MAY 2011 0672.6365 GAS POOL MANAGEMENT 20.79 66961 MAY 2011 0628.6365 GAS PARK BLDGS MAINT 33.27 66961 MAY 2011 0628.6365 GAS PARK BLDGS MAINT 34.79 66961 MAY 2011 0628.6365 GAS PARK BLDGS MAINT 63.75 66961 MAY 2011 0628.6365 GAS PARK BLDGS MAINT 228.25 66961 MAY 2011 0628.6365 GAS PARK BLDGS MAINT 270.40 66961 MAY 2011 0323.6365 GAS FACILITIES - FIRE 389.26 66961 MAY 2011 0323.6365 GAS FACILITIES - FIRE 533.24 66961 MAY 2011 0651.6365 GAS LIBRARY 643.23 66961 MAY 2011 0183.6365 GAS CITY HALL 709.81 66961 MAY 2011 0429.6365 GAS FACILITIES - PW BLDGS 906.99 66961 MAY 2011 0429.6365 GAS FACILITIES - PW BLDGS 1,078.30 66961 MAY 2011 0318.6365 GAS FACILITIES - POLICE 4,924.91 112185 6/23/2011 110065 COMCAST 4.50 66962 877210630025370 0311.6420 EQUIPMENT RENT POLICE MANAGEMENT 9 JUNE2011 4.50 112186 6/23/2011 100139 CONVENTION & VISITORS BUREAU 18,288.51 66963 MAY 2011 0157.6320 LODGING TAX LODGING TAX 18,288.51 112187 6/23/2011 122486 CULHANE, MARY LOU 23.50 66964 MAILBOX REIMB 0424.6202 OPERATING SUPPLIES SNOW /SAND 23.50 112188 6/23/2011 101923 DRIVER AND VEHICLE SERVICES 20.00 2005 NISAN 66965 CASE # 11001259 2121.6240 EQUIPMENT MAINTENANCE DWI FORFEITURE 20.00 112189 6/23/2011 100437 GFOA 505.00 66966 2010 CAFR 0151.6327 OTHER PROF SERVICES FINANCE MANAGEMENT R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 5 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 30.00 66980 JUNE # 4 0671.6327 OTHER PROF SERVICES RECREATION MANAGEMENT 30.00 112199 6/23/2011 122485 RADEMACHER, HEIDI 100.00 REFUND DEPOSIT 66976 HUBER PARK 0675.4798 PARK FACILITY RENTAL PARK SERVICES RENTAL 2011 100.00 112200 6/23/2011 100424 SCOTT CO ATTORNEY'S OFFICE 399.00 ALBERTS 66977 FILE 10011612 2121.4821 FINES & FORFEITS DWI FORFEITURE 399.00 112201 6/23/2011 101239 SHERWIN WILLIAMS CO 164.96 66978 MAY 2011 0672.6230 BUILDING MAINT SUPPLIES POOL MANAGEMENT 629.84 66978 MAY 2011 0673.6230 BUILDING MAINT SUPPLIES ICE ARENA MANAGEMENT 794.80 112202 6/23/2011 121152 THE OKEE DOKEE BROTHERS 400.00 66975 JULY 2011 0675.6325 PERFORMERS/ INSTRUCTORS PARK SERVICES 400.00 112203 6/23/2011 101247 UNITED STATES POSTAL SERVICE 1,500.00 66979 JUNE 2011 0311.6332 POSTAGE POLICE MANAGEMENT POLICE 1,500.00 112204 6/30/2011 101225 APPLE FORD OF SHAKOPEE INC 641.24 67193 JUNE 2011 8827.6420 EQUIPMENT RENT SWMDTF - FORFEITURES 641.24 112205 6/30/2011 120370 AT & T NATIONAL COMPLIANCE CEN 475.00 67167 65353 8827.6327 OTHER PROF SERVICES SWMDTF - FORFEITURES 475.00 112206 6/3012011 122116 CALLRAM, JAVIER 52.00 67168 SWDT 2011 -06 8827.6327 OTHER PROF SERVICES SWMDTF - FORFEITURES 52.00 112207 6/30/2011 100128 CARVER COUNTY 5,000.00 67194 SHERI001731 8025.6003 WAGES FT REG SWMDTF - STATE GRANT 323.34 67195 SHERI01707 8827.6210 OFFICE SUPPLIES SWMDTF- FORFEITURES 782.85 67196 SHER101667 8025.6003 WAGES FT REG SWMDTF- STATE GRANT R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 7 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 44.60 67173 8432790 0411.6334 TELEPHONE ENGINEERING MANAGEMENT 70.73 67173 8432790 0324.6334 TELEPHONE FIRE STATION NO 2 71.42 67173 8432790 0679.6334 TELEPHONE RECREATION PROGRAMS 102.44 67173 8432790 0321.6334 TELEPHONE FIRE MANAGEMENT 107.65 67173 8432790 0421.6334 TELEPHONE STREET MANAGEMENT 109.92 67173 8432790 0672.6334 TELEPHONE POOL MANAGEMENT 188.69 67173 8432790 0651.6334 TELEPHONE LIBRARY 207.95 67173 8432790 0121.6334 TELEPHONE ADMINISTRATION 325.52 67173 8432790 0312.6334 TELEPHONE PATROL 1,352.85 112213 6/30/2011 104883 JORDAN POLICE DEPARTMENT 397.28 67174 1892 8025.6327 OTHER PROF SERVICES SWMDTF - STATE GRANT 397.28 112214 6/30/2011 122496 JOSHI, UNNATI 122.00 67176 25899 0672.4770 LESSONS POOL MANAGEMENT 122.00 112215 6/30/2011 122454 JULIE LINNIHAN CHANGE FUND 5.10 67175 JUNE 2011 4068.6332 POSTAGE FIRE STATION 2 2011 5.10 67175 JUNE 2011 0121.6332 POSTAGE ADMINISTRATION 5.10 67175 JUNE 2011 0123.6332 POSTAGE PERSONNEL - PAYROLL 7.58 67175 JUNE 2011 0121.6210 OFFICE SUPPLIES ADMINISTRATION 8.75 67175 JUNE 2011 0151.6336 PRINTING /PUBLISHING FINANCE MANAGEMENT 9.65 67175 JUNE 2011 0151.6336 PRINTING /PUBLISHING FINANCE MANAGEMENT 14.50 67175 JUNE 2011 0426.6240 EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE 55.78 112216 6/30/2011 100914 KROMINGA, TERRY 2,820.00 REPLACEMENT FOR CK # 112109 67177 JUNE # 2 REPMT 0331.6327 OTHER PROF SERVICES INSPECTION MANAGEMENT 2,820.00 112217 6/30/2011 122497 LASALLE, JONES LANG 465.76 ESCROW REFUND 67178 CUP 11007 8040.2351 DEPOSITS PAYABLE ESCROW FUND 465.76 112218 6/30/2011 122498 LAYER 4 25.00 4TH PLACE 67179 JUNE 2011 0676.6325 PERFORMERS/ INSTRUCTORS TEEN CENTER 25.00 4TH PLACE 67179 JUNE 2011 0675.6325 PERFORMERS/ INSTRUCTORS PARK SERVICES 50.00 CITY OF SHAKOPEE 7/1/2011 9:35:16 R55CKREG LOG20000 Council Check Register Page - 9 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 112228 6/30/2011 120846 SPRINT 60.00 67189 LCI- 103018 8827.6327 OTHER PROF SERVICES SWMDTF- FORFEITURES 60.00 67190 LCI- 103003 8827.6327 OTHER PROF SERVICES SWMDTF - FORFEITURES 60.00 67191 LCI- 102807 8827.6327 OTHER PROF SERVICES SWMDTF - FORFEITURES 180.00 112229 6/30/2011 122501 STROBEL, JANE 118.50 POOL MEMBERSHIP REFUND 67192 JUNE 2011 0672.4762 MEMBERSHIPS POOL MANAGEMENT 118.50 112230 7/1/2011 115060 1ST LINE /LEEWES VENTURES LLC 175.25 66981 94432 0672.6250 MERCHANDISE POOL MANAGEMENT 387.13 66982 94165 0672.6250 MERCHANDISE POOL MANAGEMENT 562.38 112231 7/1/2011 109520 2ND WIND EXERCISE INC 1,811.03 66983 022019554 0321.6202 OPERATING SUPPLIES FIRE MANAGEMENT 1,811.03 112232 71112011 119213 2XL CORPORATION 992.44 66984 119406 0678.6202 OPERATING SUPPLIES COMM CTR FACILITIES 63.84- 66984 119406 1000.2080 USE TAX GENERAL FUND 928.60 112233 7!112011 106832 A & S TRAINING LLC 350.00 66985 A &S# DS -11 -1 0312.6472 CONFERENCE /SCHOOUTRAINING PATROL 350.00 112234 7/1/2011 109606 ABRAKADOODLE 880.00 66986 1513 0679.6325 PERFORMERS/ INSTRUCTORS RECREATION PROGRAMS 880.00 112235 7/1/2011 111133 AG POWER ENTERPRISES INC 26.72 66987 372320 0441.6250 MERCHANDISE FLEET MANAGEMENT 171.00 66988 370474 0426.6240 EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE 470.78 66988 370474 0441.6250 MERCHANDISE FLEET MANAGEMENT 23.50 66989 371331 0441.6250 MERCHANDISE FLEET MANAGEMENT 129.86 66989 371331 0625.6240 EQUIPMENT MAINTENANCE PARK EQUIPMENT MAINTENANCE 821.86 112236 7/1/2011 122080 AMERICAN RED CROSS - MINNESOTA 60.00 66990 11 -02723 0672.6211 RECREATION SUPPLIES POOL MANAGEMENT R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 11 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 112246 7/1/2011 115318 BISEK, JENNIFER 6.00 REIMBURSE PARING FEE 67005 JUNE 2011 0314.6475 TRAVEUSUBSISTENCE RECORDS 6.00 112247 7/1/2011 107768 BOYER TRUCKS 142.71 67006 79925SAV 0441.6250 MERCHANDISE FLEET MANAGEMENT 156.07 67007 80347SAV 0441.6250 MERCHANDISE FLEET MANAGEMENT 46.65 67008 80271SAV 0441.6250 MERCHANDISE FLEET MANAGEMENT 345.43 112248 7/1/2011 100104 BRYAN ROCK PRODUCTS 68.22 67009 S211 JUNE 2011 0427.6215 MATERIALS STREET MAINTENANCE #1 68.22 112249 7/112011 108026 CHIEF SUPPLY 345.00 67010 406390 2120.6202 OPERATING SUPPLIES FORFEITURE 22.19- 67010 406390 2120.2080 USE TAX FORFEITURE 169.49 67011 407301 0312.6202 OPERATING SUPPLIES PATROL 10.90- 67011 407301 1000.2080 USE TAX GENERAL FUND 210.53 67012 407828 2120.6202 OPERATING SUPPLIES FORFEITURE 13.54- 67012 407828 2120.2080 USE TAX FORFEITURE 678.39 112250 7/1/2011 121255 CHRISTIANSON, CANON 42.76 REIMBURSEMENT FOR BIKE PARTS 67013 JUNE 2011 0312.6202 OPERATING SUPPLIES PATROL 42.76 112251 7/1/2011 110940 CLAY, JOHN 426.56 DETROIT LAKES REIMB 67165 MSFDA CONF 2011 0321.6475 TRAVEUSUBSISTENCE FIRE MANAGEMENT 426.56 112252 7/1/2011 100497 COCA -COLA BOTTLING CO 1,075.88 67020 0198013117 0672.6250 MERCHANDISE POOL MANAGEMENT 1,075.88 112253 7/1/2011 100948 CONCRETE CUTTING & CORING INC 59.89 67014 80218 0426.6240 EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE 34.46 67015 80291 0426.6240 EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE 42.70 67016 80139 0622.6202 OPERATING SUPPLIES PARK MAINT /GARBAGE PICKUP 97.58 67017 80120 0426.6240 EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 ` Council Check Register Page - 13 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 30.88 67033 MNSKA67260 0625.6240 EQUIPMENT MAINTENANCE PARK EQUIPMENT MAINTENANCE 8.53 67034 MNSKA67109 0441.6250 MERCHANDISE FLEET MANAGEMENT 159.68 67035 MNSKA67441 7731.6212 UNIFORMS /CLOTHING SURFACE WATER MANAGEMENT 236.73 112263 7/1/2011 100992 FBI -NAA NORWEST CHAPTER 50.00 67036 FBI10009 #2 0312.6472 CONFERENCE /SCHOOL/TRAINING PATROL 50.00 112264 7/1/2011 100379 FLEXIBLE PIPE TOOL CO 131.64 67037 14313 0441.6250 MERCHANDISE FLEET MANAGEMENT 411.24 67038 14306 0441.6250 MERCHANDISE FLEET MANAGEMENT 542.88 112265 7/1/2011 100936 FP MAILING SOLUTIONS INC 65.57 67039 RI00652804 0674.6332 POSTAGE COMMUNITY CENTER 65.57 112266 7/1/2011 100936 FP MAILING SOLUTIONS INC 72.14 67040 RI100653785 0679.6332 POSTAGE RECREATION PROGRAMS 72.14 112267 7/112011 100936 FP MAILING SOLUTIONS INC 118.47 67041 RI100659233 0311.6420 EQUIPMENT RENT POLICE MANAGEMENT 118.47 112268 7/1/2011 122433 GEAR WASH, LLC 838.19 67042 6934 0321.6202 OPERATING SUPPLIES FIRE MANAGEMENT 838.19 112269 7/1/2011 106458 GENERAL SAFETY EQUIPMENT INC 55.00 67043 3700 0321.6202 OPERATING SUPPLIES FIRE MANAGEMENT 55.00 112270 7/1/2011 122492 000GLE, INC 7,650.00 67044 200022585 7806.6410 SOFTWARE - ANNUAL FEES INFO TECH I.S. FUND 7,650.00 112271 7/1/2011 100315 GOPHER SPORT 1,113.88 67045 8327539 0679.6211 RECREATION SUPPLIES RECREATION PROGRAMS 1,113.88 R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 15 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 2,071.87 67062 CASE # 0311.6310 ATTORNEY POLICE MANAGEMENT 11 -PA -0450 2,071.87 112281 7/1/2011 100830 KERN DEWENTER VIERE LTD 3,000.00 FINAL & OMB A -133 SINGLE AUDIT 67063 129876 0151.6327 OTHER PROF SERVICES FINANCE MANAGEMENT 3,500.00 FINAL & OMB A -133 SINGLE AUDIT 67063 129876 0151.6327 OTHER PROF SERVICES FINANCE MANAGEMENT 6,500.00 112282 7/1/2011 100914 KROMINGA, TERRY 2,737.60 67064 JUNE # 2 0331.6327 OTHER PROF SERVICES INSPECTION MANAGEMENT 2,737.60 112283 7/1/2011 114201 LAKE COUNTRY DOOR LLC 5,081.54 67065 17993 7810,1760 IMPROVEMENTS BUILDING I.S. FUND 39.28 67066 17929 0426.6240 EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE 39.27 67066 17929 0625.6240 EQUIPMENT MAINTENANCE PARK EQUIPMENT MAINTENANCE 39.28 67066 17929 7714.6240 EQUIPMENT MAINTENANCE SEWER EQUIP MAINTENANCE 39.28 67066 17929 7731.6240 EQUIPMENT MAINTENANCE SURFACE WATER MANAGEMENT 5.05- 67066 17929 1000.2080 USE TAX GENERAL FUND 2.53- 67066 17929 7100.2080 USE TAX SANITARY SEWER UTILITY FUND 2.53- 67066 17929 7300.2080 USE TAX SURFACE WATER FUND 5,228.54 112284 7/1/2011 122345 LARSON, TOM 126.00 67067 ASE TEST 2011 0441.6472 CONFERENCE/SCHOOL/TRAINING FLEET MANAGEMENT 126.00 112285 7/1/2011 109321 LIGHTHOUSE UNIFORM 40.83 67068 42473 0321.6212 UNIFORMS /CLOTHING FIRE MANAGEMENT 2.63- 67068 42473 1000.2080 USE TAX GENERAL FUND 38.20 112286 7/1/2011 101932 LOFFLER BUSINESS SYSTEMS INC 190.13 67069 1260647 0911.6336 PRINTING /PUBLISHING UNALLOCATED 190.13 112287 7/1/2011 101087 LOGIS 192.00 67070 33793 7806.6314 COMPUTER SERVICES INFO TECH I.S. FUND 125.00 67071 33744 0331.6410 SOFTWARE - ANNUAL FEES INSPECTION MANAGEMENT 182.00 67071 33744 0123.6410 SOFTWARE - ANNUAL FEES PERSONNEL - PAYROLL 554.00 67071 33744 0151.6410 SOFTWARE - ANNUAL FEES FINANCE MANAGEMENT R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 17 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 35.50 67091 37402 0441.6327 OTHER PROF SERVICES FLEET MANAGEMENT 35.50 112296 7/1/2011 101185 MINNESOTA RECREATION & PARK AS 500.00 67092 3993 0674.6480 DUES COMMUNITY CENTER 500.00 112297 7/1/2011 108117 MINNESOTA ROADWAYS CO 283.22 67093 63001 0427.6215 MATERIALS STREET MAINTENANCE 283.22 112298 7/1/2011 122493 MN DEPT OF ADMINISTRATION 375.00 67083 LAW ENF DATA 0314.6472 CONFERENCE/SCHOOL/TRAINING RECORDS WSHOP 2011 250.00 67083 LAW ENF DATA 0319.6472 CONFERENCE/SCHOOUTRAINING CODE ENFORCEMENT WSHOP 2011 625.00 112299 7/1/2011 100484 MN DEPT OF AGRICULTURE 40.00 67088 B42ABR00261831 0429.6240 EQUIPMENT MAINTENANCE FACILITIES - PW BLDGS 40.00 112300 7/1/2011 100184 MN DEPT OF LABOR & IND 20.00 67084 B42ABR002562261 0429.6240 EQUIPMENT MAINTENANCE FACILITIES - PW BLDGS 40.00 67085 B42ABR00265781 0318.6240 EQUIPMENT MAINTENANCE FACILITIES - POLICE 90.00 67086 B42ABR00256091 0678.6240 EQUIPMENT MAINTENANCE COMM CTR FACILITIES 40.00 67087 B42ABR00265871 0323.6240 EQUIPMENT MAINTENANCE FACILITIES - FIRE 10.00 67089 B42ABR0026181I 0323.6240 EQUIPMENT MAINTENANCE FACILITIES - FIRE 20.00 67090 B42ABR00265641 0651.6240 EQUIPMENT MAINTENANCE LIBRARY 220.00 112301 7/1/2011 101169 MTI DISTRIBUTING INC 85.87 67094 795645 -00 0441.6250 MERCHANDISE FLEET MANAGEMENT 85.87 112302 7/1/2011 122399 MULLIN. ELEANOR 936.25 67095 06032011 0313.6327 OTHER PROF SERVICES INVESTIGATION 936.25 112303 7/1/2011 121207 MULTI - SERVICES, INC 446.74 67096 100661 0630.6315 BUILDING MAINT. YOUTH BUILDING 2,421.79 67097 100660 0678.6315 BUILDING MAINT. COMM CTR FACILITIES R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 19 6/18/2011 - 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 810.00 67104 40756 0183.6315 BUILDING MAINT. CITY HALL 2,776.00 112308 7/1/2011 108341 PARROTT CONTRACTING INC 10,722.00 67105 JUNE 2011 7735.6327 OTHER PROF SERVICES CATCH BASIN MAINT 1,740.00 67106 10 -1765 # 1 7713.6327 OTHER PROF SERVICES MANHOLE & PIPE MAINT 784.41 67109 PC11 -11495 0624.6215 MATERIALS ATHLETIC MAINT & FIELDS 13,246.41 112309 7/1/2011 100451 PAULY, DAN 769.70 DETROIT LAKE REIMB 67164 MSFDA CONF 2011 0321.6475 TRAVEL/SUBSISTENCE FIRE MANAGEMENT 769.70 112310 7/1/2011 100610 PAULY, DENNIS 478.64 DETROIT LAKES REIMB 67107 MSFDA CONF 2011 0321.6475 TRAVEVSUBSISTENCE FIRE MANAGEMENT 478.64 112311 7/1/2011 100745 PRIOR LAKE, CITY OF 5,522.65 67108 11 -052 2146.6324 TRANSPORTATION EXPRESS BUSSES 5,522.65 112312 7/1/2011 107864 PROGRESS VALLEY ELECTRIC INC 228.83 67110 5807 0429.6315 BUILDING MAINT. FACILITIES - PW BLDGS 228.83 112313 7/1/2011 119934 QUILL 171.43 67111 4978303 0314.6210 OFFICE SUPPLIES RECORDS 171.43 112314 7/1/2011 101449 RIVERFRONT PRINTING 98.33 67112 2640 0151.6336 PRINTING /PUBLISHING FINANCE MANAGEMENT 98.33 112315 7/1/2011 104866 ROBERT B HILL CO 94.50 67113 252509 0323.6315 BUILDING MAINT. FACILITIES - FIRE 76.95 67114 252301 0651.6230 BUILDING MAINT SUPPLIES LIBRARY 72.72 67115 252296 0318.6230 BUILDING MAINT SUPPLIES FACILITIES - POLICE 58.32 67116 252297 0429.6230 BUILDING MAINT SUPPLIES FACILITIES - PW BLDGS 302.49 112316 7/1/2011 109449 S &T OFFICE PRODUCTS 58.72 67117 01006252 0911.6210 OFFICE SUPPLIES UNALLOCATED R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35 :16 Council Check Register Page - 21 6/18/2011 - 7/1/2011 Check 4 Date Amount Supplier / Explanation PO 4 Doc No Inv No Account No Subledger Account Description Business Unit 1,513.50 67130 3413 6761.6327 104200 OTHER PROF SERVICES GREENFIELD EAST/ PARK MEADOWS 1,513.50 112324 7/1/2011 101235 SHAKOPEE TOWING INC 90.84 67131 150609 2121.6327 OTHER PROF SERVICES DWI FORFEITURE 90.84 67132 154522 2121.6327 OTHER PROF SERVICES DWI FORFEITURE 400.00 67133 152342 2121.6327 OTHER PROF SERVICES DWI FORFEITURE 581.68 112325 7/1/2011 108938 SPORTS UNLIMITED 1,309.00 67124 WEEK JUNE 13 -17 0679.6325 PERFORMERS/ INSTRUCTORS RECREATION PROGRAMS 1,309.00 112326 7/112011 100729 SS DESIGN & PRODUCTION 213.75 67134 9104 0311.6336 PRINTING /PUBLISHING POLICE MANAGEMENT 213.75 112327 7/1/2011 122490 STORK TWIN CITY TESTING CORP 2559.00 67136 TCT00266241N 6779.6312 ENGINEERING CONSULTANTS 11 -1 2011 STREET IMPROVEMENTS 2559.00 112328 711/2011 101236 STRE1CHER'S 857.13 67135 1844085 0321.6212 UNIFORMS /CLOTHING FIRE MANAGEMENT 857.13 112329 7/1/2011 116731 TOWMASTER, INC 65.93 67137 330754 0441.6250 MERCHANDISE FLEET MANAGEMENT 65.93 112330 7/1/2011 101248 UNIFORMS UNLIMITED 59.85 67138 80447 0312.6212 UNIFORMS /CLOTHING PATROL 59.85 112331 7/1/2011 101249 VALLEY SPORTS 500.45 67139 2026 0679.6211 RECREATION SUPPLIES RECREATION PROGRAMS 108.00 67140 VOLLEYBALL 0679.6211 RECREATION SUPPLIES RECREATION PROGRAMS CHAMPS 2011 608.45 112332 7/1/2011 115061 VISTAR CORPORATION 18.68- 67141 31161551 0672.6250 MERCHANDISE POOL MANAGEMENT 45.00 67142 31021687 0672.6250 MERCHANDISE POOL MANAGEMENT R55CKREG LOG20000 CITY OF SHAKOPEE 7/1/2011 9:35:16 Council Check Register Page - 23 6/1812011 — 7/1/2011 Check # Date Amount Supplier / Explanation PO # Doc No Inv No Account No Subledger Account Description Business Unit 112340 7/1/2011 100354 ZARNOTH BRUSH WORKS INC 955.46 67163 0134254 -IN 0441.6250 MERCHANDISE FLEET MANAGEMENT 955.46 815,025.77 Grand Total Payment Instrument Totals Check Total 806,174.86 Transfer Total 8,850.91 Total Payments 815,025.77 Ipbanke • U.S. BANK P.O. BOX 6343 ACCOUNT NUMBER FARGO ND 58125 -6343 STATEMENT DATE 05 -25 -2011 AMOUNT DUE $8.850.91 '� T NEW BALANCE $8,850.91 PAYMENT DUE ON RECEIPT • 11. 1. ii11ni11111III1 gLiii11I 'IIII1i1.111111 AMOUNT ENCLOSED • 000007805 2 AT 0.490 106481097658759 P $ . • CITY OF SHAKOPEE ATTN ACCTS PAYABLE Please make check payable to 129 HOLMES STREET S U.S. BANK SHAKOPEE MN 55379 -1328 U.S. BANK P.O. BOX 790428 ST. LOUIS, MO 63179 -0428 000885091 000885091 tease tear payment coupon at perforation. : "_.... : "..". . . ..." CORP ORAfi E ACGOUNTSUM-MARY::.. ._. :: ..... _. ". ".... Purchases Cash Late CITY OF SHAKOPEE Previous And Other Cash Advance Payment New Balance + Charges + Advances + Fees + Charges - Credits - Payments = Balance Company Total $7.985.85 $8.875.86 $0.00 $.00 $0.00 $24.95 $7.985.85 $8.850.91 CORPORATEAGCOU T' ACCTJUIT1 . ._.. CITY OF SHAKOPEE TOTAL CORPORATE ACTIVITY $7,985.85 CR Post Tran Date Date Reference Number Transaction Description Amount 05-20_05-20 74798261140000000000018 PAYMENT - US BANK CORP TR00000 A 7,985.85 • Y ._.:NEW:AC..1.i1(TT'l.". ":...:.: ..." .... ...:.:_..... "..:.. . " .:..... " .:..:.....:.....: • I CITY OF SHAKOPEE MN • CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $479.46 $0.00 $479.46 t Post Tran Date Date Reference Number Transaction Description Amount 04 -28 04 -27 24767901117118008585202 B & H PHOTO - VIDEO.COM 800 - 9479950 NY 1119.85 • 05 -10 05 -06 24717051129131298877974 GRAND VIEW LODGE & TENNIS NISSWA MN 1;94.21 • 03291271 ARRIVAL: 05-04 -11 .. 05 -12 05 -12 " 24492151132207733500738 P -AY FLOW PRO 888 -883 -9770 NE • . " .. _ -: " • 1 -9.95 05 -12 05 -12 24492151132207733609869 PAY FLOW PRO 888 - 883 -9770 NE • 59:95' 05 -20 05 -19 .24717051139161399809772 MILLER DAVIS 612- 3121554 MN 85.50. • • CUSTOMER SERVICE CALL ACCOUNT NUMBER ACCOUNT SUMMARY PREVIOUS BALANCE 7,985.85 , PURCHASES & 800- 344-5696 OTHER CHARGES 8,875.86 STATEMENT DATE DISPUTED AMOUNT CASH ADVANCES .00 05/25/11 .00 CASH ADVANCE FEES .00 LATE CHARGES PAYMENT .00 SEND BILLING INQUIRIES TO: AMOUNT DUE CREDITS 24.95 PAYMENTS 7,985.85 U.S. BANK P.O. Box 6335 8,850.91 Fargo, ND 58125 - 6335 ACCOUNT BALANCE 8,850.91 1 1 6 ° / E st 4. • Page 1 of 6 ■ i • i Company Name: CITY OF SHAKOPEE Corporate Account Number: Statement Date: 05 -25 -2011 • ..:...... . _..:::.. .:..::.. ......:....._._ RNtWMTIUITY ..:._ .: .._.:.: :.:..:.........: . Post Tran Date Date Reference Number Transaction Description Amount 05 -05 05 -04 74493981124207599600188 DISCOUNTCELL PROVO UT 24.95 CR • 05 -13 05 -12 24493981132207599600332 DISCOUNTCELL 801 -235 -9809 UT 15.94 , LYNN LIPINSKI • CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $10.69 $0.00 $10.69 Post Tran Date Date Reference Number Transaction Description Amount 04 -29 04 -28 24455011118141014286072 WAL -MART #3513 SHAKOPEE MN 10.69 , SHAKOPEE POLICE DEPT II • CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $380.65 $0.00 $380.65 Post Tran Date Date Reference Number Transaction Description Amount 05 -02 04 -30 24765011120286319613859 MOUNTAINS PLUS 206 -686 -8002 WA 380.65 t CRAIG ROBSON • CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $72.87 $0.00 $72.87 Post Tran Date Date Reference Number Transaction Description Amount 05 -09 05 -06 24332391127000017602020 CLEARWATER TRAVEL CLEARWATER MN 28.83 • 05 -09 05 -05 24750761126192802185812 FAMOUS DAVES BBQ NUM 800 - 0000000 MN 44.04 . SHAKOPEE POLICE DEPT • CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $505.40 $0.00 $505.40 Post Tran Date Date Reference Number Transaction Description Amount 04 -28 04 -27 24717051118731180322469 DISCOUNT RUBBER STAMPS 414- 7714150 WI 26.86 • 05 -05 05 -03 24071051124158154238632 PANZANELLA BAKERY AND 952- 4452228 MN 61.92 • • 05 -05 05 -04 24755421125731252760900 COUNTRY INN AND SUITES SHAKOPEE MN 84.60* , 36026 ARRIVAL: 05 -03 -11 / 05 -12 05 -12 24692161132000647660004 ULINE *SHIP SUPPLIES 800 - 295 -5510 IL 70.70 05 -13 05 -11 24323001132253131010112 MARTINIZING DRY CLEANE SHAKOPEE MN 13.52 05 -18 05 -17 24717051138131385057646 THE WILLAPA BAY COMPANY 1 800- 4031424 WA 36.20 05 -19 05-18 24399001138295070654429 BEST BUY 00014639 SHAKOPEE MN 211.60 JEFFERY TATE ' CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $23.14 $0.00 $23.14 I--- Page 3of6 4 i livi i r : .. r ■ Company Name: CITY OF SHAKOPEE Corporate Account Number: Statement Date: 05 -25 -2011 • Post Tran Date Date Reference Number Transaction Description Amount 05 -03 05 -02 24164071122941210421146 RADIOSHACK COR00161489 SHAKOPEE MN 16.97 Department: 00000 Total: $16.97 Division: 00044 Total: $16.97 • PARK DEPT SHAKOPEE _ _ • CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $392.03 $0.00 $392.03 Post Tran Date Date Reference Number Transaction Description Amount 05 -13 05 -12 24692161132000703296354 LOWES #02628* SHAKOPEE MN 53.76 05 -16 05 -13 24445001134100380552982 OFFICE MAX SHAKOPEE MN 187.69 05 -17 05 -16 24692161136000549244598 LOWES #02628* SHAKOPEE MN 67.22 05 -23 05 -20 24692161140000385009828 LOWES #02628* SHAKOPEE MN 83.36 Department: 00000 Total: $392.03 Division: 00062 Total: $392.03 ' JOSHUA BARRICK . CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $743.44 $0.00 $743.44 Post Tran Date Date Reference Number Transaction Description Amount 04 -29 04 -28 24692161118000829905910 LOWES #02628* SHAKOPEE MN 65.11 05 -02 04 -29 24755421119171196753976 VIKING INDUSTRIAL CENTER 651 - 6466374 MN 168.46 05 -05 05 -03 24445001124100347876393 OFFICE MAX SHAKOPEE MN 69.20 05 -06 05-05 24692161125000305066147 LOWES #02628* SHAKOPEE MN 1.53 05 -10 05 -10 24692161130000196393173 PATRIOT SUPPLY 516- 249 -3100 NY 273.51 05 -16 05 -13 24445001134000248782583 AUTOZONE #3074 SHAKOPEE MN 165.63 SHERRY DVORAK • CREDITS PURCHASES CASH ADV TOTAL ACTIVITY $0.00 $35.95 $0.00 $35.95 Post Tran Date Date Reference Number Transaction Description Amount 05 - 04 05 - 02 24418001123123018936308 ORIENTAL TRADING CO 800 - 2280475 NE 35.95 BRADLEY ELLER . CREDITS PURCHASES .CASH ADV TOTAL. ACTIVITY $0.00 $876.57 $0.00 $876.57 Post Tran Date Date Reference Number Transaction Description • Amount 04 -29 04 -28 24164071118941203112906 RADIOSHACK COR00161489 SHAKOPEE MN 6.72 05 -02 04-28 24071051119158127378280 HIGH SCORE VIDEO GAMES SHAKOPEE MN 141.94 05 -16 05 -12 24071051133158187683753 HIGH SCORE VIDEO GAMES SHAKOPEE MN 54.30 05 -19 05 -17 24013391138011619299126 KERNEL CONCESSION SUPPLY JORDAN MN 64.45 i Page 5 of 6 ��