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: December 11, 2009
Introduction and Back~round
Attached is the print-out showing the division budget status for 2009 based on data entered as of
12/11/2009.
Attached is a regularcouncil 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.
Action Requested
Move to approve the bills in the amount of $502,613.63 and electronic transfers in the amount of
$370,834.49 for a total of $873,448.12.
Funds transferred electronicaly December 2, 2009 to December 11, 2009
PAYROLL $ 211,784.06
FIT /FICA!MEDICA $ 56,930.60
STATE INCOME TAX $ 12,391.16
PERA $ 53,847.64
HEALTH CARE SAVINGS $ 8,069.37
HEALTH SAVINGS ACCT $ 3,730.82
FLEX SPENDING ACCT $ 3,333.50
NATIONWIDE DEF COMP $ 15,007.46
ICMA DEFERRED COMP $ 1,568.18
CHILD SUPPORT $ 920.00
SLDG INSP SURCHG PYMT $ 2,742.48
BANK FEES $ 509.22
TOTAL $ 370,834.49
R5509FIN1 LOGIS003 CITY OF SHAKOPEE 121101200915:59:12
By Co (pb), Div (Totals Only) Monthly Financial Report Page - 1
2009
2009 1213112009 2009 <==============~====== 2008 =====================>
Annual Current YTD Budget Per Cent I Prior Year Same Period Prior Per Cent
__.._____[)_e~c!iption ______ Budget Period Actual Balance Used ~ Budget Year YTD Actual Used
01000 GENERAL FUND
11 MAYOR & COUNCIL 165,700.00 812.30 117,935.32 47,764.68 71.17 I 177,390.00 124,870.40 70.39
12 ADMINISTRATION 553,930.00 18,390.67 479,607.80 74,322.20 86.58 I 519,120.00 472.425.83 91.01
13 CITY CLERK 310,200.00 6,177.62 260,884.70 49,315.30 84.10 I 366.440.00 317,842.72 86.74
15 FINANCE 819,090.00 14,520.85 701,207.92 117,882.08 85.61 I 772,100.00 744,002.89 96.36
16 LEGAL COUNSEL 473,500.00 24.75 418,065.25 55.434.75 88.29 I 533,500.00 557,546.53 104.51
17 COMMUNITY DEVELOPMENT 505,820.00 18,143.55 437,518.47 68,301.53 86.50 I 549,150.00 542,773.18 98.84
18 FACILITIES 236,250.00 9,132.29 195,972.42 40,277.58 82.95 I 309,030.00 269,185.08 87.11
20 INFORMATION TECHNOLOGY 359,170.00 10,075.82 301,030.35 58,139.65 83.81 I 313,120.00 294,797.76 94.15
31 POLICE DEPARTMENT 6,199,710.00 210,353.71 5,472,110.47 727,599.53 88.26 I 5,920,620.00 5,808,764.23 98.11
32 FIRE 1,974,480.00 19,974.99 1,657,223.68 317,256.32 83.93 I 1,933,710.00 1,857,479.99 96.06
33 INSPECTION-BLDG-PLMBG-HTG 745,130.00 29,276.66 710,194.22 34,935.78 95.31 I 823,690.00 786,716.76 95.51
41 ENGINEERING 685,300.00 22,605.25 501,794.39 183,505.61 73.22 I 790,090.00 645,784.54 81.74
42 STREET MAINTENANCE 1,799,020.00 29,996.17 1,570,127.05 228,892.95 87.28 I 1,973,070.00 1,793,945.81 90.92
44 FLEET 103,640.00 15,134.94 136,204.75 32,564.75- 131.42 I 95,990.00 141,633.16 147.55
46 PARK MAINTENANCE 1,495,000.00 32,699.48 1,262,095.83 232,904.17 84.42 I 1,579,820.00 1,479,314.57 93.64
65 L1BRARYICONGREGATE DINING 323,380.00 4,977.52 250,726.43 72,653.57 77.53 I 302,350.00 283,780.83 93.86
66 NATURAL RESOURCES 65,820.00 1,888.31 32,519.52 33,300.48 49.41 I 128,030.00 100,497.64 78.50
91 UNALLOCATED 150,000.00 603.54 78,732.40 71,267.60 52.49 I 157,240.00 67,661.00 43.03
01000 GENERAL FUND 16,965,140.00 444,788.42 14,583,950.97 2,381,189.03 85.96 I 17,244,460.00 16,269,022.92 94.46
02140 TRANSIT
17 COMMUNITY DEVELOPMENT 1,173,500.00 54,053.18 909,696.88 263,803.12 77.52 I 2,080,840.00 1,055,268,48 50.71
02140 TRANSIT 1,173,500.00 54,053.18 909,696.88 263,803.12 77.52 I 2,080,840.00 1,055,268.48 50.71
02150 TELECOMMUNICATION
12 ADMINISTRATION 225,670.00 4,050.61 154,669.30 71,000.70 68.54 I 336,700.00 219,501.78 65.19
02150 TELECOMMUNICATION 225,670.00 4,050.61 154,669.30 71,000.70 68.54 I 336,700.00 219,501.78 65.19
02190 EDA
19 EDA 116,680.00 806.33 62,196.32 54,483.68 53.31 I 123,770.00 72,416.24 58.51
02190 EDA 116,680.00 806.33 62,196.32 54,483.68 53.31 I 123,770.00 72,416.24 58.51
07500 RECREATION FUND
75 RECREATION PROGRAMS 2,407,360.00 55,374.67 2,022,190.19 385,169.81 84.00 I 2,209,140.00 2,300,671.17 104.14
07500 RECREATION FUND 2,407,360.00 55,374.67 2,022,190.19 385,169.81 84.00 I 2,209,140.00 2,300,671.17 104.14
R55CKSUM LOG20000 CITY OF SHAKOPEE 12/10/200915:47:08
Council Check Summary Page - 1
12/2/2009 - 12/11/2009
Company Amount
-
01000 GENERAL FUND 107,561.19
02120 FORFEITURE 779.76
02140 TRANSIT 51,915.52
02170 REVOLVING LOAN 4,292.08
03042 2010A GO IMP BONDS 150.00
04021 CAPITAL IMPROVEMENT FUND 2,700.26
04066 2009 PROJECTS 17,579.97
04067 2010 PROJECTS 5,302.00
07100 SEWER FUND 191,528.50
07300 SURFACE WATER FUND 12,517.07
07500 RECREATION FUND 15,685.66
07800 EQUIPMENT I.S. FUND 9,097.20
08025 SW METRO DRUG TASK FORCE 80.00
08027 TRI-CITY TACTICAL TEAM 174.00
08040 ESCROW FUND 82,861.70
08050 INVESTMENT TRUST FUND 388.72
Report Totals 502,613.63
R55CKREG LOG22000VO CITY OF SHAKOPEE 12/10/200915:53:04
Council Check Register Page- 1
12/2/200S..12/11/2009
Check # Amount Vendor / EXplanation Account Description Business Unit
- -
106549 3,223.18 BRANDL ANDERSON RESID LANDSCAPE PAYABLE ESCROW FUND
106550 3,250.00 CENTEX HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106551 3,250.00 COLLEGE CITY HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106552 80.00 DRIVER AND VEHICLE SERVICES EQUIPMENT MAINTENANCE SWMDTF - FORFEITURES
106553 3,250.00 F&B CONSTRUCTION RESID LANDSCAPE PAYABLE ESCROW FUND
106554 12,793.90 FIELDSTONE FAMILY HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106555 27.89 GREGG VOXLAND/PETTY CASH POSTAGE CLERK MANAGEMENT
106556 3,250.00 KNOBLAUCH BLDRS LLC RESID LANDSCAPE PAYABLE ESCROW FUND
106557 3,250.00 MATT AMY HOMES RESID LANDSCAPE PAYABLE ESCROW FUND
106558 2,250.00 MCDONALD CONSTRUCTION RESID LANDSCAPE PAYABLE ESCROW FUND
106559 176,540.55 METRO COUNCIL ENVIRO SERVICES CURRENT USE CHARGES SEWER MANAGEMENT
106560 161.75 MN DNR WATERS WATER ATHLETIC MAINT & FIELDS
106561 543.35 NAPA GENUINE PARTS CO MERCHANDISE FLEET MANAGEMENT
106562 40.00 OFFICE OF THE SECRETARY OF STA DUES POLICE MANAGEMENT
106563 3,179.18 PIETSCH BUILDERS INC RESIO LANDSCAPE PAYABLE ESCROW FUND
106564 26.36 QWEST TELEPHONE POLICE MANAGEMENT
106565 6,500.00 SHAMROCK BUILDERS RESID LANDSCAPE PAYABLE ESCROW FUND
106566 900.00 UNITED STATES POSTAL SERVICE POSTAGE POLICE MANAGEMENT
106567 1,000.00 WELSH CONSTRUCTION, LLC DEPOSITS PAYABLE ESCROW FUND
106568 6,500.00 WOODDALE alLDERS RESID LANDSCAPE PAYABLE ESCROW FUND
106569 684.00 ABRAKADOODLE PERFORMERS/INSTRUCTORS RECREATION PROGRAMS
106570 967.42 ACS FIREHOUSE SOLUTIONS SOFTWARE-ANNUAL FEES FIRE MANAGEMENT
106571 1,183.59 ALEX AIR APPARATUS, INC EQUIPMENT MAINTENANCE FIRE MANAGEMENT
106572 1,548.00 ALLIANCE BENEFIT GROUP, OTHER PROF SERVICES PERSONNEL. PAYROLL
106573 9,476.97 AMERICAN ENVIROMENTAL LLC OTHER PROF SERVICES SEWER MANAGEMENT
106574 333.33 ARROW ACE HARDWARE OPERATING SUPPLIES ATHLETIC MAINT & FIELDS
106575 138.03 BIFFS INC OTHER RENT CIVIC CENTER
106576 544.81 BOYER TRUCKS MERCHANDISE FLEET MANAGEMENT
106577 716.93 BRYAN ROCK PRODUCTS MATERIALS STREET MAINTENANCE
106578 6,490.00 CARTEGRAPH INC SOFTWARE-ANNUAL FEES SURFACE WATER MANAGEMENT
106579 330.41 CHRYSLER JEEP MERCHANDISE FLEET MANAGEMENT
106580 1,438.50 CINTAS - 7541NC UNIFORMS/CLOTHING PARK MANAGEMENT
106581 32.30 CINTAS FIRST AID & SAFETY OPERATING SUPPLIES STREET MANAGEMENT
106582 295.04 CIT TECHNOLOGY FIN SERV , INC EQUIPMENT RENT POLICE MANAGEMENT
106583 90.00 CMS OTHER PROF SERVICES SNOW/SAND
106584 3,843.25 CRABTREE COMPANIES INC PRINTING/PUBLISHING POLICE MANAGEMENT
106585 28.92 CUB FOODSSHAKOPEE OPERATING SUPPLIES POLICE MANAGEMENT
106586 1,229.47 CUMMINS N POWER LLC OTHER PROF SERVICES LIFT STATION MAINT
106587 346.96 DOCUMENT DESTRUCTION SERVICE.L OTHER PROF SERVICES BUILDING INSPECTION
106588 781.22 DOOR WORKS BUILDING MAINT SUPPLIES PARK BLDGS MAINT
106589 13.11 DOYLE, MARIE M TRANSPORTATION TRANSIT VAN POOL
R55CKREG lOG22000VO CITY OF SHAKO PEE 12/10/200915:53:04
Council Check Register Page - 2
12/2/2009--12/11/2009
Check # Amount Vendor / Explanation Account Description Business Unit
- -
106590 206.44 DREES, JOHN TRANSPORTATION TRANSIT VAN POOL
106591 1.617.27 ESRIINC SOFTWARE.ANNUALFEES SURFACE WATER MANAGEMENT
106592 456.11 FASTENAL BUILDING MAINT SUPPLIES CITY HALL
106593 1,075.00 FIRST STUDENT, INC TRANSPORTATION RECREATION PROGRAMS
106594 683.10 FORCE AMERICA INC MERCHANDISE FLEET MANAGEMENT
106595 1,586.25 G C BENTLEY ASSOC INC OTHER PROF SERVICES TRANSIT
106596 510.55 GOPHER STATE ONE-CALL INC OTHER PROF SERVICES SURFACE WATER MANAGEMENT
106597 178.02 HENNEN'S SHELL AUTO SERVICE CT MERCHANDISE FLEET MANAGEMENT
106598 924.70 HUEBSCH CO BUILDING MAl NT. COMM CTR FACILITIES
106599 80.00 IPMA-HR SUBSCRIPTIONS/PUBLICATIONS POLICE MANAGEMENT
106600 159.24 J & R RADIATOR CORP MERCHANDISE FLEET MANAGEMENT
106601 15.40 JENKINS, RUSSELL TRA VEUSUBSISTENCE FACILITIES MANAGEMENT
106602 50.00 JEURISSEN,L1SA OPERATING SUPPLIES FLEET MANAGEMENT
106603 9,097.20 JOHN DEERE GOVERNMENT & NATION EQUIPMENT EQUIPMENT LS. FUND
106604 849.25 K M T COMMUNICATIONS ADVERTISING TRANSIT
106605 18,595.37 KELLEY FUELS, INC GASOLINE GENERAL FUND
106606 4,548.00 KENNEDY & GRAVEN CHRTD DEPOSITS PAYABLE ESCROW FUND
106607 1.304.87 LAB SAFETY SUPPLY OPERATING SUPPLIES FIRE MANAGEMENT
106608 120.00 LEAGUE OF MN CITIES CONFERENCElSCHOOUTRAINING MAYOR & COUNCIL
106609 1,457.10 LEAGUE OF MN CITIES INSURANCE LIABILITY PATROL
106610 113.00 LIBERTY TIRE RECYCLING LLC OTHER PROF SERVICES REFUSE & CLEAN-UP DAY
106611 49.70 LINK LUMBER INC OPERATING SUPPLIES CATCH BASIN MAINT
106612 212.25 LOCATORS & SUPPLIES INC OPERATING SUPPLIES SEWER MANAGEMENT
106613 335.50 LOFFLER BUSINESS SYSTEMS INC PRINTING/PUBLISHING UNALLOCA TED
106614 11,605.00 LOGIS SOFTWARE-ANNUAL FEES PLANNING MANAGEMENT
106615 75.00 MAMA TRAVEL/SUBSISTENCE ADMINISTRATION
106616 2,605.63 MATRIX LASER CARE INC OFFICE SUPPLIES FIRE MANAGEMENT
106617 14.30 MCINTYRE, BRAD TRA VEUSUBSISTENCE FACILITIES MANAGEMENT
106618 25.65 MID-COUNTRY FAVRICATING. INC MERCHANDISE FLEET MANAGEMENT
106619 522.01 MOTOR PARTS MERCHANDISE FLEET MANAGEMENT
106620 4,164.92 MUNICIPAL EMERGENCY SERVICES OPERATING SUPPLIES FIRE MANAGEMENT
106621 40.41 MVEC ELECTRIC STREET MAINTENANCE
106622 3,440.63 NEXTEL COMMUNICATIONS TELEPHONE POLICE MANAGEMENT
106623 125.00 NUSTAR EQUIPMENT MAINTENANCE CAR WASH
106624 1,951.99 OFFICE OF ENTERPRISE TECHNOLOG TELEPHONE POLICE MANAGEMENT
106625 210.35 OPEN DOOR IND OPERATING SUPPLIES FIRE MANAGEMENT
106626 2,643.70 OWENS COMPANIES INC BUILDING MAl NT. COMM CTR FACILITIES
106627 232.20 PITSCHNEIDER, TOM TRA VEUSUBSISTENCE FIRE MANAGEMENT
106628 731.10 QUILL OFFICE SUPPLIES POLICE MANAGEMENT
106629 133.86 RAMY TURF PRODUCTIONS OPERATING SUPPLIES DITCH & POND MAl NT
106630 691.26 REED BUSINESS INFORMATION PRINTING/PUBLISHING 09-1 FULLER STREET TRAIL
R55CKREG LOG22000VO CITY OF SHAKOPEE 12/10/200915:53:04
Council Check Register Page - 3
12/2/2009--12/11/2009
Check # Amount Vendor / Explanation Account Description Business Unit
-
106631 12.00 RELIABLE WELDING OPERATING SUPPLIES FLEET MANAGEMENT
106632 78.02 RIVERFRONT PRESS PRINTING/PUBLISHING PATROL
106633 542.93 RIVERS EDGE CONCRETE INC EQUIPMENT MAINTENANCE TRANSIT CIRCULATOR
106634 6,825.00 RW FARMS LLC OTHER PROF SERVICES SWEEPING
106635 1,007.50 SAVAGE, CITY OF SEWER SEWER MANAGEMENT
106636 39.65 SCHMITT, JOHN TRA VEUSUBSISTENCE MAYOR & COUNCIL
106637 43,065.53 SCHMITTY & SONS SCHOOL BUSES, TRANSPORTATION EXPRESS
106638 612.50 SCOTT CO TREASURER SOFTWARE-ANNUAL FEES INFORMATION TECHNOLOGY
106639 23,254.86 SHAKOPEE CROSSINGS LIMITED PAR DEPOSITS PAYABLE ESCROW FUND
106640 22,607.12 SHAKOPEE PUBLIC UTILITY COMM PERA AID GENERAL FUND
106641 91.91 SHAKOPEETOWINGINC OTHER PROF SERVICES DWI FORFEITURE
106642 2.53 SINDELAR,JEFF TRAVEUSUBSISTENCE FACILITIES MANAGEMENT
106643 254.48 SOUTHWEST OUTDOOR POWER EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE
106644 22.41 STREICHER'S UNIFORMS/CLOTHING PATROL
106645 331.31 TOWMASTER, INC MERCHANDISE FLEET MANAGEMENT
106646 28.10 TWIN CITY HARDWARE BUILDING MAINT SUPPLIES PARK BLDGS MAINT
106647 550.00 UNIVERSITY OF MINNESOTA CONFERENCEiSCHOOLlTRAINING ENGINEERING MANAGEMENT
106648 32.77 UPS STORE # 4009 EQUIPMENT MAINTENANCE PATROL
106649 1,420.57 VIKING INDUSTRIAL CENTER OPERATING SUPPLIES FIRE MANAGEMENT
106650 5,575.77 VPSIINC TRANSPORTATION TRANSIT VAN POOL
106651 177 .79 WESTSIDE EQUIP EQUIPMENT MAINTENANCE MAINT - FUEL SYSTEM
106652 241.22 WM MUELLER & SONS MATERIALS STREET MAINTENANCE
106653 10,308.50 WSB & ASSOC INC ENGINEERING CONSULTANTS 10-1 2010 STREET IMPROVEMENTS
106654 235.46 XCEL ENERGY ELECTRIC STREET MAINTENANCE
106655 1,125.27 XIOTECH INC SOFTWARE-ANNUAL FEES INFORMATION TECHNOLOGY
106656 20.83 ZACKS OPERATING SUPPLIES DITCH & POND MAINT
106657 283.93 ZEP MANUFACTURING CO EQUIPMENT MAINTENANCE SEWER EQUIP MAINTENANCE
106658 802.24 ZIEGLER INC EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE
106659 150.00 BEUSSMAN,MARK SA PREPAY 09-2 2009 STREET IMPROVEMENTS
106660 401.71 CIT TECHNOLOGY FIN SERV , INC EQUIPMENT RENT NATURAL RESOURCES
106661 1,331.72 FREMONT INDUSTRIES INC OPERATING SUPPLIES ICE ARENA MANAGEMENT
106662 6,362.80 GECKLER & ASSOCIATES RESID LANDSCAPE PAYABLE ESCROW FUND
106663 3,065.64 LAFAYETTE LIFE INSURANCE CO LIFE PAYABLE PAYROLL CLEARING
106664 1,764.00 LAW ENFORCMT LABOR SERVICES UNION DUES PAYABLE PAYROLL CLEARING
106665 80.00 MCMA SECRETARIAT DUES ADMINISTRATION
106666 4,292.08 MINNESOTA DEED DUE TO OTHER GOVERNMENTS LONG REVOLVING LOAN
106667 227.20 MN COMM OF FINANCE TREAS DIV FINES & FORFEITS FORFEITURE
106668 1,182.00 MN TEAMSTERS #320 UNION DUES PAYABLE PAYROLL CLEARING
106669 216.00 MX LOGIC INC SOFTWARE-ANNUAL FEES INFORMATION TECHNOLOGY
106670 672.00 NCPERS GROUP LIFE INS LIFE PAYABLE PAYROLL CLEARING
106671 82.00 RETTKE, BRIDGET UNIFORMS/CLOTHING TRI-CITY TACTICAL TEAM
R55CKREG LOG22000VO CITY OF SHAKOPEE 12/10/200915:53:04
Council Check Register Page - 4
12/2/200&-12/11/2009
Check # Amount Vendor / Explanation Account Description Business Unit
-.----..---- ~
106672 615.70 SAM'S CLUB OFFICE SUPPLIES POLICE MANAGEMENT
106673 454.40 SCOTT CO ATTORNEY'S OFFICE FINES & FORFEITS FORFEITURE
106674 28,108.43 SHAKO PEE PUBLIC UTILITY COMM ELECTRIC ICE ARENA MANAGEMENT
106675 92.00 WYCKOFF, JEFF UNIFORMS/CLOTHING TRI-CITY TACTICAL TEAM
502,613.63 Grand Total
Payment Instrument Totals
Check Total 502,613.63
Total Payments 502,613.63