HomeMy WebLinkAbout8. Approval of City Bills
.~
~
..
#8
"CONSENT"
,
CITY OF SHAKOPEE
Memorandum
TO: Mayor and Council
Mark. McNeill, City Administrator
FROM: Gregg Voxland, Finance Director
~ RE: City Bill List
DATE: April 28, 2005
Introduction and Background
Attached is a print out showing the division budget status for
2005 based on data entered as of 04/28/05.
Attached is a regular council bill list for invoices processed
to date for council approval.
Included in the checklist are various refunds, returns, pass
through, etc. totaling $78,788.90. The actual net expenditure
amount is $432,927.51.
Action Requested
Move to approve the bills in the amount of $511,716.41.
.
R5509FIN1 LOGIS003 CITY OF SHAKOPEE 4/27/2005 13:44:55 ,
By Co (pb), Div (Totals Only) Monthly Financial Report Page - 1
2005
2005 4130/2005 2005 <===================== 2004 =====================>
Annual Current YTD Budget Per Cent I Prior Year Same Period Prior Per Cent
Description Budget Period Actual Balance Used ..L Budget Year YTD Actual Used
01000 GENERAL FUND
11 MAYOR & COUNCIL 97,470.00 7,652.75 30,407.86 67,062.14 31.20 I 78,830.00 21,963.50 27.86
12 CITY ADMINISTRATOR 466,000.00 24,050.85 109,852.76 356,147.24 23.57 I 525,890.00 144,989.97 27.57
13 CITY CLERK 375,330.00 18,329.97 70,557.24 304,772.76 18.80 I 272,360.00 62,526.35 22.96
15 FINANCE 677,080.00 56,884.45 137,229.87 539,850.13 20.27 I 620,530.00 138,128.81 22.26
16 LEGAL COUNSEL 485,880.00 3,909.43 69,781.27 416,098.73 14.36 I 432,500.00 122.612.31 28.35
17 COMMUNITY DEVELOPMENT 464,270.00 46,020.65 109,330.40 354,939.60 23.55 I 509,190.00 115,156.26 22.62
18 GENERAL GOVERNMENT BUILDINGS 523,140.00 24,062.23 143,299.69 379,840.31 27.39 J 560,830.00 174,347.55 31.09
20 INFORMATION TECHNOLOGY 279,780.00 13,420.20 56,669.57 223,110.43 20.26 I 200,250.00 32,067.13 16.01
31 POLICE DEPARTMENT 4,377,720.00 269,966.08 1,194,127.45 3,183,592.55 27.28 I 3,791,090.00 1,015,800.30 26.79
32 FIRE 1,153,590.00 17,728.15 223,987.68 929,602.32 19.42 I 1,141,700.00 280,469.55 24.57
33 INSPECTION-BLDG-PLMBG-HTG 726,780.00 59,478.20 227,967.85 49B.a12.15 31.37 I 690,920.00 197,301.84 28.56
41 ENGINEERING 822,900.00 51,737.50 213,984.38 608,915.62 26.00 I 717,170.00 183,594.47 25.60
42 STREET MAINTENANCE 1,245,260.00 31,241.89 269,396.78 975,863.22 21.63 I 1,070,870.00 249,849.56 23.33
44 SHOP 390,880.00 55,602.64 150,530.31 240,349.69 38.51 I 333,550.00 66,515.07 19.94
46 PARK MAINTENANCE 1,015,060.00 87,047.89 235,053.28 780,006.72 23.16 I 799,770.00 200,651.46 25.09
91 UNALLOCATED 130,000.00 1,425.00 2,974.02 127,025.98 2.29 I 98,910.00 20,984.15 21.22
01000 GENERAL FUND 13,231,140.00 768,557.88 3,245,150.41 9,985,989.59 24.53 I 11,844,360.00 3,026,958.28 25.56
02140 TRANSIT
17 COMMUNITY DEVELOPMENT 815,890.00 95,544.76 131,417.59 684,472.41 16.11 I 687,110.00 124,397.10 18.10
-~
02140 TRANSIT 815,890.00 95,544.76 131,417.59 684,472.41 16.11 I 687,110.00 124,397.10 18.10
02150 TELECOMMUNICATION
12 CITY ADMINISTRATOR 376,230.00 7,875.19 25,354.60 350,875.40 6.74 I 241,780.00 37,689.39 15.59
02150 TELECOMMUNICATION 376,230.00 7,875.19 25,354.60 350,875.40 6.74 I 241,780.00 37,689.39 15.59
07500 RECREATION FUND
75 RECREATION PROGRAMS 1,986,010.00 110,978.24 539,666.48 1,446,343.52 27.17 I 1,691,110.00 474,672.07 28.07
-----._---"- ~-~,.__._~.~.-
07500 RECREATION FUND 1,986,010.00 110,978.24 539,666.48 1,446,343.52 27.17 I 1,691,110.00 474,672.07 28.07
<
R55CKREG LOG22000VO CITY OF SHAKOPEE 4/27/200513:29:35
)
Council Check Register Page - 1
4/15/200~ 5/1/2005
Check # Amount Vendor I Explanation Account Description Business Unit
- -
84420 1,895.72 AFLAC AFLAC PAYABLE PAYROLL CLEARING
84421 223.44 BABU,RAMESH MEMBERSHIPS CIVIC CENTER
84422 2,258.40 CARVER CO ATTORNEY'S OFFICE FINES & FORFEITS SWMDTF - FORFEITURES
84423 254.77 CENTERPOINT ENERGY GAS SERVCIE GAS BUILDING/SHELTER MAINT
84424 3,375.00 CHillS OF MINNESOTA C.O. CHARGE PAYABLE ESCROW FUND
84425 5,646.40 DELTA DENTAL PLAN OF MN DENTAL INSURANCE PAYROLL CLEARING
84426 2,933.64 ELAN FINANCIAL SERVICES CONFERENCE/SCHOOLlTRAINING FIRE MANAGEMENT
84427 8.25 FRANCOTYP-POSTALlA INC EQUIPMENT RENT POLICE MANAGEMENT
84428 73,590.43 MEDICA HEALTH PAYABLE PAYROLL CLEARING
84429 375.00 MN CHILD SUPPORT PAYMENT CTR OTHER DEDUCTIONS PAYROLL CLEARING
84430 1.129.20 MN COMM OF FINANCE TREAS DIV FINES & FORFEITS SWMDTF - FORFEITURES
84431 150.00 MN DEPT OF HEALTH OPERATING SUPPLIES 05-1 2005 STREET RECONSTRUCTN
84432 240.00 MN POLLUTION CNTRL AGNCY OPERATING SUPPLIES 05-1 2005 STREET RECONSTRUCTN
84433 2,175.00 MW JOHNSON CONSTRUCTION RESID LANDSCAPE PAYABLE ESCROW FUND
84434 5,286.45 200 LEVEE DR APTS UTILITY SERVICE SENIOR CENTER
84435 625.00 ATOM TRA VEUSUBSISTENCE POLICE MANAGEMENT
84436 37,614.74 ABM EQUIPMENT & SUPPLY INC EQUIPMENT EQUIPMENT I.S. FUND
84437 124.60 ADVANCED DISTRIBUTING INC BUILDING MAl NT. CIVIC CENTER
84438 121.44 AMERICAN LAFRANCE AERIALS EQUIPMENT MAINTENANCE FIRE STATION NO 2
84439 249.34 ANCOM COMMUNICATIONS INC EQUIPMENT MAINTENANCE FIRE STATION NO 2
84440 20.00 B & W METAL WORKS INC MERCHANDISE SHOP MANAGEMENT
84441 60.28 BECKER ARENA PRODS INC EQUIPMENT MAINTENANCE ICE ARENA MANAGEMENT
84442 29.78 BENDER,ERIC OPERATING SUPPLIES FIRE STATION NO 2
84443 317.08 BIFFS INC OTHER RENT ATHLETIC MAINT & FIELDS
84444 60.00 BLOOMINGTON, CITY OF CONFERENCE/SCHOOLlTRAINING POLICE MANAGEMENT
84445 4,661.67 BRADLEY & GUZZETTA LLC OTHER PROF SERVICES TELECOMMUNICATION MANAGEMENT
84446 372.36 CANTERBURY PARK HOLDING CORP EQUIPMENT MAINTENANCE POLICE MANAGEMENT
84447 4,136.76 CARROLL FRANCK & ASSOCIATES OTHER PROF SERVICES MAYOR & COUNCIL
84448 75.06 CREATIVE CONCEPTS IN MARKETING RECREATION SUPPLIES CIVIC CENTER
84449 137.21 CUB FOODS SHAKOPEE OPERATING SUPPLIES FIRE STATION NO 2
84450 240.00 DAKOTA COUNTY RECEIVING CENTER OTHER PROF SERVICES POLICE MANAGEMENT
84451 8.52 DAKOTAH SPORT & FITNESS CONFERENCE/SCHOOLlTRAINING POLICE MANAGEMENT
84452 49.58 DICK'S SANITATION INC REFUSE SENIOR CENTER
84453 657.00 DIRECT DIGITAL CONTROLS INC BUILDING MAl NT. LIBRARY
84454 30.00 DOCUMENT DESTRUCTION SERVICE.L OTHER PROF SERVICES POLICE MANAGEMENT
84455 5,817.00 DRESSEN OIL CO DIESEL GENERAL FUND
84456 82.00 ENR SUBSCRIPTIONS/PUBLICATIONS ENGINEERING MANAGEMENT
84457 540.01 EMERGENCY MED PRODS INC OPERATING SUPPLIES POLICE MANAGEMENT
84458 90,267.86 EXTREME EQUIPMENT INC EQUIPMENT EQUIPMENT I.S. FUND
84459 155.26 FACTORY MOTOR PARTS INC MERCHANDISE SHOP MANAGEMENT
84460 150.00 FBINAA - NORWEST CHAPTER CONFERENCE/SCHOOLlTRAINING POLICE MANAGEMENT
.
R55CKREG LOG22000VO CITY OF SHAKOPEE 4/27/2005 13:29:35 ,
Council Check Register Page - 2
4/15/2005- 5/1/2005
Check # Amount Vendor / Explanation Account Description Business Unit
- -
84461 111.55 FERRELLGAS MOTOR FUELS & LUBRICANTS ICE ARENA MANAGEMENT
84462 925.00 FONDER CARPET SERVICES INC OTHER PROF SERVICES TEEN CENTER
84463 572.03 FREMONT INDUSTRIES INC OPERATING SUPPLIES ICE ARENA MANAGEMENT
84464 657.81 GARRETT SPECIALTIES OPERATING SUPPLIES RECREATION PROGRAMS
84465 1,370.66 GATEWAY COMPANIES INC OFFICE SUPPLIES POOL MANAGEMENT
84466 1,076.66 GLOBAL SUPPORT SOFTWARE. CORP EQUIPMENT MAINTENANCE INFORMATION TECHNOLOGY
84467 657.35 GOPHER STATE ONE-CALL INC OTHER PROF SERVICES SEWER MANAGEMENT
84468 57.66 GRAINGER INC BUILDING MAINT SUPPLIES CIVIC CENTER
84469 180.82 GS DIRECT OPERATING SUPPLIES ENGINEERING MANAGEMENT
84470 18.00 HENNEN'S SHELL AUTO SERVICE CT EQUIPMENT MAINTENANCE FIRE STATION NO 2
84471 24.50 HUGHES. DANIEL TRA VEUSUBSISTENCE POLICE MANAGEMENT
84472 74.40 IDENTlSYS OPERATING SUPPLIES DWI FORFEITURE
84473 178.81 IKON OFFICE SOLUTIONS INC EQUIPMENT MAINTENANCE FIRE STATION NO 2
84474 284.00 INNOVATIVE GRAPHICS RECREATION SUPPLIES RECREATION PROGRAMS
84475 150.00 KEEPRS INC\CY'S UNIFORMS OPERATING SUPPLIES POLICE MANAGEMENT
84476 4,636.00 KROMINGA, TERRY OTHER PROF SERVICES INSPECTION MANAGEMENT
84477 120.35 LEAGUE OF MN CITIES OFFICE SUPPLIES ADMINISTRATION
84478 50.00 LOE'S OIL CO OTHER PROF SERVICES POLICE MANAGEMENT
84479 326.70 LOFFLER BUSINESS SYSTEMS INC PRINTING/PUBLISHING UNALLOCATED
84480 111.25 MCPA OPERATING SUPPLIES POLICE MANAGEMENT
84481 647.35 METRO SOUND & LIGHTING RECREATION SUPPLIES TEEN CENTER
84482 891.00 MINNEAPOLIS FINANCE DEPT OTHER PROF SERVICES PAWN SHOPS
84483 4,292.08 MINNESOTA DEED DUE TO OTHER GOVERNMENTS LONG REVOLVING LOAN
84484 225.00 MIXIT PRODUCTIONS DJ SERVICE OTHER PROF SERVICES TEEN CENTER
84485 225.00 MIXIT PRODUCTIONS DJ SERVICE OTHER PROF SERVICES TEEN CENTER
84486 2,242.38 MN PLUMBING & HEATING INC BUILDING MAINT SUPPLIES CUSTODIAN - SHOP
84487 285.00 MN SAFETY COUNCIL DUES STREET MANAGEMENT
84488 12.00 MUL TIHOUSING CREDIT CTL OTHER PROF SERVICES POLICE MANAGEMENT
84489 40.25 MUNICIPAL EMERGENCY SERVICES EQUIPMENT MAINTENANCE FIRE MANAGEMENT
84490 359.81 NATL IMP CORP/SAFETY OPERATING SUPPLIES DARE FINES
84492 150.00 NRG PROCESSING SOLUTIONS, LLC OTHER PROF SERVICES BLVD TREEIWEED
84493 499.33 PERSONAL TOUCH TECHNOLOGIES IN EQUIPMENT MAINTENANCE IT - POLICE
84494 43.43 PRIEBE,DEB TRANSIT FARES TRANSIT VAN POOL
84495 85.00 PRINTERS SERVICE INC EQUIPMENT MAINTENANCE ICE ARENA MANAGEMENT
84496 277.52 PROGRESS VALLEY ELECTRIC INC BUILDING MAl NT. ICE ARENA MANAGEMENT
84497 3,439.35 RAY O'HERRON CO INC OPERATING SUPPLIES 'POLlCE MANAGEMENT
84498 31.95 RIVERFRONT PRESS OFFICE SUPPLIES FINANCE MANAGEMENT
84499 401.60 ROCKMOUNT/NASSAU EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE
84500 80.00 ROEPKE,ALEXANDRA OTHER PROF SERVICES POOL MANAGEMENT
84501 48,274.70 SCOTT CO TREAS"** PROPERTY TAX/SPECIAL ASSESS PARK MANAGEMENT
84502 71,427.88 SCOTT CO TREASURER TRANSPORTATION TRANSIT D-A-R
.
R55CKREG LOG22000VO CITY OF SHAKOPEE 4/27/2005 13:29:35 ,
Council Check Register Page - .3
4/15/2005- 5/1/2005
Check # Amount Vendor / Explanation Account Description Business Unit
--- -
84503 300.81 SHAKOPEE CHEV INC MERCHANDISE SHOP MANAGEMENT
84504 34.16 SHANER, JEANETTE CONFERENCE/SCHOOUTRAINING CLERK MANAGEMENT
84505 350.00 SIMPLEX TIME GRINNELL BUILDING MAl NT. CIVIC CENTER
84506 124.08 SNAP-ON TOOLS CORP TOOLS SHOP MANAGEMENT
84507 2,017.23 SOUTHWEST SUBURBAN INC PRINTING/PUBLISHING CLERK MANAGEMENT
84508 52.50 SPORT STOP OPERATING SUPPLIES POLICE MANAGEMENT
84509 2,000.00 SPRINGSTED INC OTHER PROF SERVICES STORM DEBT SERVICE
84510 215.80 STAR TRIBUNE INC SU BSCRIPTIONS/PUBLlCA TIONS POLICE MANAGEMENT
84511 441.48 STREICHERS MERCHANDISE SHOP MANAGEMENT
84512 261.70 SUEL PRINTING CO PRINTING/PUBLISHING POLICE MANAGEMENT
84513 960.00 UHL COMPANY INC BUILDING MAl NT. CIVIC CENTER
84514 827.65 VOSS LIGHTING BUILDING MAINT SUPPLIES FIRE CUSTODIAN
84515 5,322.72 VPSIINC TRANSPORTATION TRANSIT VAN POOL
84516 237.50 WIRELESS INNOVATIONS EQUIPMENT MAINTENANCE POLICE MANAGEMENT
84517 37,938.73 WSB & ASSOC INC DEPOSITS PAYABLE ESCROW FUND
84518 1,300.00 BARNES,NICHOLAS EVIDENCE ROOM DEPOSIT ESCROW FUND
84519 994.40 CARVER CO ATTORNEY'S OFFICE FINES & FORFEITS SWMDTF - FORFEITURES
84520 12,683.53 CONVENTION & VISITORS BUR OTHER PROF SERVICES LODGING TAX
84521 27.00 DRIVER AND VEHICLE SERVICES DESIGNATED MISCELLANEOUS SWMDTF - FORFEITURES
84522 5,500.00 HENNEPIN CO ATTORNEY'S OFFICE FINES & FORFEITS SWMDTF - FORFEITURES
84523 6,459.00 LMC INS TRUST LIABILITY SWMDTF - FORFEITURES
84524 4,060.65 MCLEOD CO LAW ENFORCEMENT CTR WAGES FT REG . SWMDTF - STATE GRANT
84525 7.34 METROCALL TELEPHONE FIRE INSPECTOR
84526 3,247.20 MN COMM OF FINANCE TREAS DIV FINES & FORFEITS SWMDTF - FORFEITURES
84527 944.84 NEXTEL COMMUNICATIONS TELEPHONE FIRE STATION NO 2
84528 106.95 NFPA OPERATING SUPPLIES FIRE STATION NO 2
84529 14,742.69 NORTHSHORE ADVISORS LLC OTHER PROF SERVICES FINANCE MANAGEMENT
84530 7,500.00 OTTO,PHILLlP EVIDENCE ROOM DEPOSIT SWMDTF - STATE GRANT
84531 4,583.33 SCOTT CO TREASURER WAGES FT REG SWMDTF - STATE GRANT
84532 4,653.33 SHAKOPEE, CITY OF WAGES FT REG SWMDTF - STATE GRANT
84533 322.00 SURONEN,SHEILA EVIDENCE ROOM DEPOSIT SWMDTF - STATE GRANT
84534 1,841.36 UNITED HEAL THCARE INSURANCE CO ACCOUNTS RECEIVABLE - NONSYSTE PAYROLL CLEARING
511,716.41 Grand Total
Payment Instrument Totals
Check Total 511,716.41
Total Payments 511,716.41
..
R55CKSUM LOG20000 CITY OF SHAKOPEE 4/27/2005 13:29:33
,
Council Check Summary Page - 1
4/15/2005 - 5/1/2005
Company Amount
-
01000 GENERAL FUND 202,278.19
02120 FORFEITURE 307.67
02130 DARE FINES 372.07
02140 TRANSIT 73,325.77
02150 TELECOMMUNICATION 3,270.00
02170 REVOLVING LOAN 4,292.08
03023 1995A IMPROVEMENT 200.00
03025 1996A IMPROVEMENT 200.00
03026 1997A FIRE BUILDING BONDS 200.00
03027 1997B IMPROVEMENT 200.00
03029 1998B IMPROVEMENT 200.00
03030 2000A GO IMP BONDS 200.00
03031 2002A GO IMP BONDS 200.00
03032 2002B GO IMP BONDS 200.00
03033 2003A GO IMP BONDS 200.00
04055 2003 PROJECTS 392.00
04059 2005 PROJECTS 535.40
07100 SEWER FUND 328.68
07300 STORM FUND 6,463.29
07500 RECREATION FUND 10,941.17
07800 EQUIPMENT I.S. FUND 127,882.60
07810 BUILDING I.S. FUND 72.70
08025 SW METRO DRUG TASK FORCE 40,841.81
08040 ESCROW FUND 38,612.98
Report Totals 511,716.41