HomeMy WebLinkAbout8. City Bill List
.
#8
~ \'COfJ~~I\JT I'
CITY OF SHAKOPEE
Memorandum
TO: Mayor and Council
Mark McNeill, City Administrator
FROM: Gregg Voxland, Finance Director
RE: City Bill List
DATE: May 27, 2004
Introduction and Background
Attached is a print out showing the division budget status for
2004 based on data entered as of 5/27/04.
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 $11,372.86. The actual net expense
amount is $471,304.41.
Action Requested
Move to approve the bills in the amount of $482,677.27.
< .
R5509FIN1 LOGIS003 CITY OF SHAKOPEE 5/27/2004 8:56:31
By Co (pb). Div (Totals Only) Monthly Financial Report Page - 1
2004
2004 6/30/2004 2004 <===================== 2003 =====================>
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 MA VOR & COUNCIL 78.830.00 29.875.41 48,954.59 37.90 I 78.710.00 32,533.08 41.33
12 CITY ADMINISTRATOR 519.800.00 187.781.55 332.018.45 36.13 I 512,780.00 222.350.40 43.36
13 CITY CLERK 276,360.00 84,772.90 191,587.10 30.67 I 290,025.00 108,404,14 37.38
15 FINANCE 620,530.00 270,163.88 350,366.12 43.54 I 598,680.00 211.679.32 35.36
16 LEGAL COUNSEL 452,500.00 128,640.11 323,859.89 28.43 I 422,200.00 130,795.31 30.98
17 COMMUNITY DEVELOPMENT 674,440.00 184,958.58 489,481.42 27.42 I 580,220.00 222,692.53 38.38
18 GENERAL GOVERNMENT BUILDINGS 522,260.00 193,671.42 328.588.58 37.08 I 336,980.00 104,433.35 30.99
31 POLICE DEPARTMENT 3,791,090.00 1.263,926.70 2,527,163.30 33.34 I 3,143,110.00 1,447,705.77 46.06
32 FIRE 1,108,700.00 314,199.60 794,500.40 28.34 I 995,570.00 329,750.94 33.12
33 INSPECTION-BLDG-PLMBG-HTG 654,420.00 245,644.90 408.775.10 37.54 I 632,580.00 297,544.72 47.04
41 ENGINEERING 697.170.00 233.664.49 463.505.51 33.52 I 649,010.00 300,778.91 46.34
42 STREET MAINTENANCE 1,088,370.00 320,511.97 767,858.03 29.45 I 1.033,200.00 349.533.21 33.83
44 SHOP 333,550.00 83,868.69 249,681.31 25.14 I 221.270.00 93,689.31 42.34
46 PARK MAINTENANCE 729.250.00 242,472.55 486,777.45 33.25 I 705.000.00 292.101.04 41.43
91 UNALLOCATED 183,000.00 21,932.99 161,067.01 11.99 I 495,000.00 246.565.54 49.81
---
01000 GENERAL FUND 11,730,270.00 3,806,085.74 7,924,184.26 32.45 I 10.694,335.00 4.390,557.57 41.05
02140 TRANSIT
17 COMMUNITY DEVELOPMENT 687,110.00 125,732.50 561,377.50 18.30 I 634,732.00 187,935.36 29.61
-----.---.-.-- .._-".,..~ ....--.
02140 TRANSIT 687,110.00 125,732.50 561,377.50 18.30 I 634,732.00 187.935.36 29.61
02150 TELECOMMUNICATION
00 N/A 241.780.00 43,078.50 198,701.50 17.82 I 304,590.00 50,749.06 16.66
50 TELECOMM 6,440.00 6,440.00- I 2.777.63
---
02150 TELECOMMUNICATION 241,780.00 49,518.50 192.261.50 20.48 I 304,590.00 53,526.69 17.57
07500 RECREATION FUND
75 RECREATION PROGRAMS 1.701,110.00 585,896.86 1.115,213.14 34.44 I 1,589,470.00 711,562.17 44.77
07500 RECREATION FUND 1,701,110.00 585.896.86 1,115.213.14 34.44 I 1,589,470.00 711,562.11 44.77
, f
R55CKREG LOG22000VO CITY OF SHAKOPEE 5/27/2004 8:42:31
Council Check Register Page - 1
5/14/2004- 6/112004
Check # Amount Vendor / Explanation Account Description Business Unit
-- -
80687 1.957.44 AFLAC AFLAC PAYABLE PAYROLL CLEARING
80688 140.00 APPLE FORD OF SHAKOPEE INC EQUIPMENT RENT SWMDTF - CONTRIBUTIONS
80689 4.583.33 CARVER COUNTY TREASURER WAGES FT REG SWMDTF - CONTRIBUTIONS
80690 1.738.80 CENTERPOINT ENERGY GAS SERVCIE GAS LIBRARY
80691 11.758.64 CONVENTION & VISITORS BUR OTHER PROF SERVICES LODGING TAX
80692 4.729.42 ELAN FINANCIAL SERVICES RECREATION SUPPLIES TEEN CENTER
80693 4.583.33 HUTCHINSON. CITY OF WAGES FT REG SWMDTF - CONTRIBUTIONS
80694 1.582.96 10 S CAPITAL INC EQUIPMENT RENT POLICE MANAGEMENT
80695 61.70 MBA MBA INSURANCE PAYABLE PAYROLL CLEARING
80696 493.00 MN CHILD SUPPORT PAYMENT CTR OTHER DEDUCTIONS PAYROLL CLEARING
80697 56.02 OLSON,BYRON CONTRIBUTIONS SWMDTF - CONTRIBUTIONS
80698 4.583.33 SCOTT CO TREASURER WAGES FT REG SWMDTF - CONTRIBUTIONS
80699 1,179.13 SCOTT CO TREASURERlDPTY REGR EQUIPMENT EQUIPMENT I.S. FUND
80700 62.00 SHAKOPEE, CITY OF DESIGNATED MISCELLANEOUS SWMDTF - CONTRIBUTIONS
80701 101.724.00 SUPERIOR FORD INC EQUIPMENT EQUIPMENT I.S. FUND
80702 3.00 VALLEY FAIR CASH SHORT/OVER FINANCE MANAGEMENT
80703 64.05 XCEL ENERGY ELECTRIC STREET MAINTENANCE
80704 253.11 ADVANTAGE COMMUNICATIONS INC EQUIPMENT MAINTENANCE SHOP MANAGEMENT
80705 312.68 ADVANTAGE PAPER OPERATING SUPPLIES CITY HALL
80706 468.60 AGGREGATE INDUSTRIES OPERATING SUPPLIES STORM DRAINAGE MAINTENANCE
80707 396.12 ALL SAFE FIRE & SECURITY OPERATING SUPPLIES FIRE MANAGEMENT
80708 96.94 AMSTERDAM CO OFFICE SUPPLIES PERSONNEL-PAYROLL
80709 127.33 ANCOM COMMUNICATIONS INC EQUIPMENT MAINTENANCE CIVIL DEFENSE
80710 291.34 APPLE FORD OF SHAKOPEE INC MERCHANDISE SHOP MANAGEMENT
. 80711 1.215.00 APPLIANCE CERTIFIED RECYCLING OTHER PROF SERVICES REFUSE
80712 275.60 BELLE PLAINE COOPERATIVE OTHER PROF SERVICES ATHLETIC FIELDS
80713 245.28 BEST WESTERN KELLY INN TRAVEL/SUBSISTENCE POLICE MANAGEMENT
80714 44.78 BRYAN ROCK PRODUCTS MATERIALS STREET MAINTENANCE
80715 340.80 BURNSVILLE PISTOL RANGE CONFERENCElSCHOOLITRAlNING POLICE MANAGEMENT
80716 2,601.99 CAPESIUS AGENCY INC LIABILITY FIRE MANAGEMENT
80717 477.98 CHIEF SUPPLY OPERATING SUPPLIES FIRE MANAGEMENT
80718 8,045.18 CHOICE ELECTRIC INC OTHERPROFSER~CES YOUTH SOCCER COMPLEX
80719 147.98 CLAREY'S SAFETY EQUIP INC OPERATING SUPPLIES CIVIC CENTER
80720 804.80 COMMERCIAL ASPHALT CO MATERIALS STREET MAINTENANCE
80721 6,778.74 COVERALL OF THE TWIN CITIES IN BUILDING MAINT. FIRE MANAGEMENT
80722 19.89 CUB FOODS SHAKOPEE OPERATING SUPPLIES INSPECTION MANAGEMENT
80723 1.008.90 CY'S UNIFORMS OPERATING SUPPLIES POLICE MANAGEMENT
80724 65.42 DAVIS. JIM TRAVEL/SUBSISTENCE INSPECTION MANAGEMENT
80725 380.74 DE LAGE LANDEN FINANCIAL SERVI EQUIPMENT RENT RECREATION PROGRAMS
80726 59.64 DISPLAY SALES OPERATING SUPPLIES POLICE MANAGEMENT
80727 3,724.95 DRESSEN OIL CO DIESEL GENERAL FUND
R55CKREG LOG22000VO CITY OF SHAKOPEE 5/27/2004 8:42:31
Council Check Register Page - 2
5/14/2004-6/1/2004
Check # Amount Vendor / Explanation Account Description Business Unit
-
80728 2,999.34 ELECTION DATA DIRECT INC OPERATING SUPPLIES ELECTIONS
80729 6.90 ELLER,BRAD RECREATION SUPPLIES RECREATION PROGRAMS
80730 5,005.50 ENVIRONMENTAL SYSTEMS INC EQUIPMENT RENT STORM DRAINAGE MAINTENANCE
80731 95.00 FIRE MARSHALS ASSOC OF MINNESO CONFERENCElSCHOOLffRAINING FIRE INSPECTOR
80732 16.50 FRANCOTYP-POSTAL~INC POSTAGE RECREATION PROGRAMS
80733 929.97 FREMONT INDUSTRIES INC OPERATING SUPPLIES ICE ARENA MANAGEMENT
80734 2,000.60 GOPHER SIGN COMPANY OPERATING SUPPLIES SIGN/STRIPING
80735 1,164.95 GOPHER STATE ONE-CALL INC OTHER PROF SERVICES STORM DRAINAGE MANAGEMENT
80736 750.00 GREENMAN TECHNOLOGIES INC OTHER PROF SERVICES REFUSE
80737 250.00 H&B SPECIALIZED PRODUCTS EQUIPMENT MAINTENANCE CIVIC CENTER
80738 206.37 HENKE, KIM TRAVEL/SUBSISTENCE MIS
80739 34.52 HENNEN'S SHELL AUTO SERVICE CT MOTOR FUELS & LUBRICANTS FIRE MANAGEMENT
80740 5.43 HERMANS'S LANDSCAPE OPERATING SUPPLIES PARK MAl NT
80741 37.57 HUGHES, DANIEL TRAVEL/SUBSISTENCE POLICE MANAGEMENT
80742 50.00 IMI DUES FIRE INSPECTOR
80743 175.00 IDENTISYS EQUIPMENT MAINTENANCE POLICE MANAGEMENT
80744 594.00 INNOVATIVE GRAPHICS OPERATING SUPPLIES RECREATION PROGRAMS
80745 83.75 IOWA PAINT MANUFACTURING CO IN OPERATING SUPPLIES POOL MANAGEMENT
80746 2,841.10 JEFFERSON FIRE & SAFETY INC EQUIPMENT MAINTENANCE FIRE MANAGEMENT
80747 171.71 KESTREL DESIGN GROUP INC OTHER PROF SERVICES NATURAL RESOURCES
80748 3,749.60 KROMINGA, TERRY OTHER PROF SERVICES INSPECTION MANAGEMENT
80749 1,572.30 KUNDE CO INC OTHER PROF SERVICES NATURAL RESOURCES
80750 827.00 LABOR RELATIONS INC OTHER PROF SERVICES PERSONNEL-PAYROLL
80751 239.63 LANO EQUIPMENT INC MERCHANDISE SHOP MANAGEMENT
80752 10.00 LEAGUE OF MN CITIES CONFERENCElSCHOOLffRAINING PERSONNEL-PAYROLL
80753 156.10 LINK LUMBER INC OPERATING SUPPLIES STORM DRAINAGE MAINTENANCE
80754 414.87 LOFFLER BUSINESS SYSTEMS INC PRINTINGIPUBLlSHING UNALLOCATED
80755 70.00 MCFOA DUES CLERK MANAGEMENT
80756 66.192.07 MEDICA HEALTH PAYABLE PAYROLL CLEARING
80757 85.58 MENARDS OPERATING SUPPLIES PUBLIC WORKS BUILDING
80758 2,142.00 METRO SALES INCORPORATED EQUIPMENT MAINTENANCE RECREATION PROGRAMS
80759 65.00 MGSF CONFERENCElSCHOOLffRAINING POLICE MANAGEMENT
80760 116.94 MIDWEST ENGINE SERVICE EQUIPMENT MAINTENANCE TREElWEED
80761 787.00 MINNEAPOLIS FINANCE DEPT OTHER PROF SERVICES PAWN SHOPS
80762 66.23 MN CONWAY FIRE OPERATING SUPPLIES FIRE MANAGEMENT
80763 345.10 MN PLUMBING & HEATING INC BUILDING MAINT. POOL MANAGEMENT
80764 185.00 MN STATE BAR ASSOC CONT. LEGAL CONFERENCElSCHOOLffRAINING PLANNING MANAGEMENT
80765 14.87 NGUYEN,VINH OPERATING SUPPLIES STREET MANAGEMENT
80766 465.00 NOVA CONSULTING GROUP INC BUILDING MAl NT. FIRE MANAGEMENT
80767 1,579.00 PARK NICOLLET CLINIC OTHER PROF SERVICES PATROL
80768 1,998.08 PIONEER PRODUCTS INC OPERATING SUPPLIES FIRE MANAGEMENT
"- ....-
. .'
R55CKREG LOG22000VO CITY OF SHAKOPEE 5/27/2004 8:42:31
Council Check Register Page - 3
511412004- 61112004
Check # Amount Vendor I Explanation Account Description Business Unit
-- -
80769 75.65 PRIEBE,DEB TRANSIT FARES TRANSIT VAN POOL
80770 85.00 PRINTERS SERVICE INC EQUIPMENT MAINTENANCE ICE ARENA MANAGEMENT
80771 210.76 REYNOLDS WELDING SUPPLY CO OPERATING SUPPLIES SHOP MANAGEMENT
80772 373.82 RIVERFRONT PRESS PRINTINGIPUBLlSHING POLICE MANAGEMENT
80773 2,200.00 SCHINDLER ELEVATOR CO BUILDING MAlNT. LIBRARY
80774 20.00 SCOTT CO RECORDER FILING FEES 2003 RECONSTRUCTION
80775 40.00 SCOTT CO RECORDER FILING FEES DEVELOPMENT
80776 106,690.63 SCOTT CO TREASURER OTHER PROF SERVICES CITY HALL
80777 270.30 SCOTT LAKE PET CLINIC OTHER PROF SERVICES ANIMAL CONTROL
80778 909.36 SHAKOPEE SCHOOL DIST 720 MISCELLANEOUS RECREATION PROGRAMS
80779 5,384.88 SHAKOPEE PUBLIC UTILITY COMM BUILDINGS POLICE STATION
80780 28.00 SHAKOPEE VALLEY NEWS SUBSCRIPTIONSIPUBLICATIONS CIVIC CENTER
80781 46.86 SIEMON IMPLEMENT INC EQUIPMENT MAINTENANCE PARK EQUIPMENT MAINTENANCE
80782 99.75 SMEAL FIRE APPARATUS CO EQUIPMENT MAINTENANCE FIRE MANAGEMENT
80783 444.00 SOUTHWEST SUBURBAN INC ADVERTISING RECREATION PROGRAMS
80784 20.314.71 SPRINGSTED INC OTHER PROF SERVICES 04-4 WEST DEANS LAKE
80785 140.29 VARDA SILENT ALARM EQUIPMENT MAINTENANCE POLICE MANAGEMENT
80786 267.86 WATER SAFETY PRODUCTS INC OPERATING SUPPLIES POOL MANAGEMENT
80787 216.20 WEST GROUP PAYMENT CTR SUBSCRIPTIONSIPUBLICATIONS CIVIL
80788 52.370.58 WSB & ASSOC INC ENGINEERING CONSUL TNTS STORM DRAINAGE MANAGEMENT
80789 9.90 AT & T WIRELESS SERVICES TELEPHONE FIRE MANAGEMENT
80790 4,977.60 DELTA DENTAL PLAN OF MN DENTAL INSURANCE PAYROLL CLEARING
80791 70.00 DEYS,DAVID EVIDENCE ROOM DEPOSIT ESCROW FUND
80792 90.00 MCGARNESS,AMY LESSONS POOL MANAGEMENT
80793 17.68 METROCALL TELEPHONE FIRE INSPECTOR
80794 500.00 MN CPV PROG, STATE OF DUES STREET MANAGEMENT
80795 78.30 MN STATE TREASURER'S OFFICE FINES & FORFEITS FORFEITURE
80796 8,465.00 MW JOHNSON CONSTRUCTION RESID LANDSCAPE PAYABLE ESCROW FUND
80797 1,338.70 NEXTEL COMMUNICATIONS TELEPHONE FIRE MANAGEMENT
80798 10.00 PIERSON,STEPHANIE YOUTH ACTIVITIES RECREAnONPROGRAMS
80799 331.91 QWEST TELEPHONE PLANNING MANAGEMENT
80800 2,175.00 RONGITSCH CONST. INC RESID LANDSCAPE PAYABLE ESCROW FUND
80801 562.86 RYLAND HOMES C.O. CHARGE PAYABLE ESCROW FUND
80802 156.60 SCOTT CO ATTORNEY'S OFFICE . FINES & FORFEITS FORFEITURE
80803 3.220.00 TECHNISOURCE - MINNESOTA OTHER PROF SERVICES WEBSITE
80804 1,493.07 UNITED HEAL THCARE INSURANCE CO ACCOUNTS RECEIVABLE - NONSYSTE PAYROLL CLEARING
80805 3,000.00 UNITED STATES POSTAL SERVICE POSTAGE CLERK MANAGEMENT
80806 8.48 VERIZON WIRELESS - BELLEVUE TELEPHONE FIRE MANAGEMENT
482,677.27 Grand T olal
Payment Instrument Totals
R55CKREG LOG22000VO CITY OF SHAKOPEE 5/27/2004 8:42:31
Council Check Register Page - 4
5/14/2004- 6/1/2004
Check # Amount Vendor / Explanation Account Description Business Unit
--- -
Check Total 482.677.27
Total Payments 482,677.27
.~ ."
.. .
R55CKSUM LOG20000 CITY OF SHAKOPEE 5/27/2004 8:43:21
Council Check Summary Page - 1
5/1412004 - 6/1/2004
Company Amount
-
01000 GENERAL FUND 249,820.67
02120 FORFEITURE 234.90
02140 TRANSIT 75.65
02150 TELECOMMUNICATION 3,220.00
02190 EDA 17.46
04020 PARK RESERVE 8.045.18
04021 CAPITAL IMPROVEMENT FUND 3,905.61
04055 2003 PROJECTS 23,882.87
04056 WEST DEANS LAKE 39,134.09
04057 2004 PROJECTS 734.00
07100 SEWER FUND 636.97
07300 STORM FUND 7.657.32
07500 RECREATION FUND 11,423.09
07800 EQUIPMENT I.S. FUND 102,903.13
07810 BUILDING I.S. FUND 5.470.46
08025 SW METRO DRUG TASK FORCE 14,008.01
08040 ESCROW FUND 11.507.86
Report Totals 482,677.27