HomeMy WebLinkAbout8. City Bill List
~
:#=2
,,~
CITY OF SHAKOPEE \\c.o~S~lVl"
Memorandum
TO: Mayor and Council
Mark McNeill, City Administrator
FROM: Gregg Voxland, Finance director
RE: City Bill List
DATE: February 26, 2004
Introduction and Background
Attached is a print out showing the division budget status for
2003 and 2004 based on data entered as of 3/01/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 $34,164.15. The actual net expense
amount is $366,758.21.
Action Requested
Move to approve the bills in the amount of $400,922.36.
. .,
R5509FINl lOGIS003 CITY OF SHAKOPEE 2/26/2004 10:16:15
By Co (pb), Div (Tolals Only) Monthly Financial Report Page - 1
2003
2003 12/31/2003 2003 <===================== 2002 =====================>
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 78,710.00 4,358.78 71.310.06 7,399.94 90.60 \ 90,820.00 76,653.09 84.40
12 CITY ADMINISTRATOR 512,780.00 48,084.49 476,167.68 36,612.32 92.86 I 558,150.00 539,968.06 96.74
13 CITY CLERK 290,025.00 27,930.82 236,682.77 53,342.23 81.61 I 325,000.00 251,562.11 77.40
15 FINANCE 598,680.00 42,224.58 567,036.32 31.643.68 94.71 I 675,470.00 591,969.02 87.64
16 LEGAL COUNSEL 422,200.00 18,024.15 276,667.66 145,532.34 65.53 I 424,500.00 350,954.75 82.67
17 COMMUNITY DEVELOPMENT 580,220.00 92,972.40 485.713.04 94,506.96 83.71 I 758.910.00 581,243.77 76.59
18 GENERAL GOVERNMENT BUILDINGS 336,980.00 87,589.67 300,793.23 36,186.77 89.26 I 375,200.00 229,266.53 61.11
31 POLICE DEPARTMENT 3,143.110.00 399.623.31 3.150,157.98 7.047.98- 100.22 I 2,981,100.00 2,976,254.92 99.84
32 FIRE 995,570.00 96,860.96 975,655.95 19,914.05 98.00 I 1,026,480.00 889,390.11 86.64
33 INSPECTION-BLDG-PLMBG-HTG 632,580.00 81,022.67 648,673.80 16,093.80- 102.54 I 585,230.00 555,383.87 94.90
41 ENGINEERING 649,010.00 64,950.02 610,214.13 38,795.87 94.02 I 658,730.00 645.676.43 98.02
42 STREET MAINTENANCE 1.033,200.00 178.276.93 895,908.24 137,291.76 86.71 I 963.840.00 1,006,999.78 104.48
44 SHOP 221,270.00 30.580.40 200,492.31 20,777.69 90.61 I 188,780.00 195.130.62 103.36
46 PARK MAINTENANCE 705,000.00 76,252.96 671,780.98 33,219.02 95.29 I 691,600.00 622,098.59 89.95
91 UNALLOCATED 495,000.00 1,076.35- 318.722.11 176,277.89 64.39 I 363,630.00 109,454.77 30.10
01000 GENERAL FUND 10,694,335.00 1,247,675.79 9.885,976.26 808,358.74 92.44 I 10.667,440.00 9,622,006.42 90.20
02140 TRANSIT
17 COMMUNITY DEVELOPMENT 634,732.00 76,778.75 450.834.58 183,897.42 71.03 I 603,870.00 411.095.66 68.08
02140 TRANSIT 634,732.00 76,778.75 450.834.58 183,897.42 71.03 I 603,870.00 411,095.66 68.08
02150 TELECOMMUNICATION
00 NIA 304,590.00 16,482.27 244,480.50 60,109.50 80.27 I 176,195.57
50 TELECOMM 45,433.88 45,433.88- I
--
02150 TELECOMMUNICATION 304.590.00 16,482.27 289,914.38 14,675.62 95.18 I 176,195.57
07500 RECREATION FUND
75 RECREATION PROGRAMS 1,589,470.00 135,072.60 1.532.132.82 57,337.18 96.39 I 1,480,660.00 1 ,482,323.50 100.11
07500 RECREATION FUND 1.589,470.00 135,072.60 1 ,532.132.82 57,337.18 96.39 I 1,480,660.00 1.482.323.50 100.11
. ,
R5509FIN1 LOGIS003 CITY OF SHAKOPEE 2/26/2004 9;37;42
By Co (pb), Div (Totals Only) Monthly Financial Report Page - 1
2004
2004 3/31/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 YearYTD Actual Used
01000 GENERAL FUND
11 MAYOR & COUNCIL 78,830.00 9,851.58 68,978.42 12.50 I 78,710.00 18,733.89 23.80
12 CITY ADMINISTRATOR 519,800.00 65,495.09 454,304.91 12.60 I 512,780.00 102,503.56 19.99
13 CITY CLERK 276,360.00 31,425.43 244,934.57 11.37 I 290,025.00 48,194.87 16.62
15 FINANCE 620,530.00 43,104.50 577,425.50 6.95 I 598,680.00 73,499.20 12.28
16 LEGAL COUNSEL 452.500.00 59,412.84 393,087.16 13.13 I 422.200.00 58,396.07 13.83
17 COMMUNITY DEVELOPMENT 674,440.00 65,281.56 609,158.44 9.68 I 580,220.00 98,087.92 16.91
18 GENERAL GOVERNMENT BUILDINGS 522,260.00 59,823.96 462,436.04 11.45 I 336,980.00 40,938.92 12.15
31 POLICE DEPARTMENT 3,791,090.00 511,957.96 3.279,132.04 13.50 I 3,143,110.00 674,739.74 21.47
32 FIRE 1,108,700.00 83,740.50 1,024,959.50 7.55 I 995,570.00 132,396.13 13.30
33 INSPECTION-BLDG-PLMBG-HTG 654,420.00 87,493.09 566,926.91 13.37 I 632,580.00 130,204.75 20.58
41 ENGINEERING 697,170.00 87,683.25 609,486.75 12.58 I 649,010.00 136,737.05 21.07
42 STREET MAINTENANCE 1,088,370.00 108,716.78 979,653.22 9.99 I 1,033,200.00 146.497.61 14.18
44 SHOP 333,550.00 30,080.59 303,469.41 9.02 I 221,270.00 46,600.12 21.06
46 PARK MAINTENANCE 729,250.00 72.345.54 656,904.46 9.92 I 705,000.00 121,732.38 17.27
91 UNALLOCATED 183.000.00 322.33 182,677.67 .18 I 495,000.00 1,131.15- .23-
01000 GENERAL FUND 11,730,270.00 1,316,735.00 10,413,535.00 11.23 I 10,694,335.00 1,828,131.06 17.09
02140 TRANSIT
17 COMMUNITY DEVELOPMENT 687,110.00 23,345.16 663,764.84 3.40 I 634,732.00 10.737.49 1.69
02140 TRANSIT 687.110.00 23,345.16 663,764.84 3.40 I 634,732.00 10,737.49 1.69
02150 TELECOMMUNICATION
00 N/A 241,780.00 11.261.66 230,518.34 4.66 I 304,590.00 20,057.09 6.58
02150 TELECOMMUNICATION 241,780.00 11,261.66 230,518.34 4.66 I 304,590.00 20.057.09 6.58
07500 RECREATION FUND
75 RECREATION PROGRAMS 1,701.110.00 196,221.96 1,504,888.04 11.53 I 1,589,470.00 286,636.57 18.03
07500 RECREATION FUND 1,701,110.00 196,221.96 1,504,888.04 11.53 I 1,589,470.00 286,636.57 18.03
, ,
'-
R55CKREG LOG22000VO CITY OF SHAKOPEE 2/26/2004 9:33:27
Council Check Register Page - 1
2/13/2004- 311/2004
Check # Amount Vendor 1 Explanation Account Description Business Unit
- -
79849 188.31 ANDERSON,TRISH CASH SHORTIOVER FINANCE MANAGEMENT
79850 8.100.00 BENSON-0RTHA ASSOCIATES C.O. CHARGE PAYABLE ESCROW FUND
79851 4,410.44 CENTERPOINT ENERGY GAS SERVCIE GAS LIBRARY
79852 10,275.33 CONVENTION & VISITORS BUR OTHER PROF SERVICES LODGING TAX
79853 8.25 FRANCOTYP-POSTALlA INC POSTAGE POLICE MANAGEMENT
79854 110.00 HAWLEY,GARY MISC BUSINESS PERMITS CLERK MANAGEMENT
79855 110.00 HENNEN,JANET MISC BUSINESS PERMITS CLERK MANAGEMENT
79856 3.273.10 KILLMER ELECTRIC CO INC OTHER PROF SERVICES STREET MANAGEMENT
79857 9.90 MN STATE TREASURER'S OFFICE FINES & FORFEITS FORFEITURE
79858 2,128.00 ORRIN THOMPSON HOMES RESID LANDSCAPE PAYABLE ESCROW FUNO
79859 7.51 QWEST DEX ADVERTISING CIVIC CENTER
79860 4,200.00 S W METRO DRUG TASK FORCE OTHER PROF SERVICES FORFEITURE
79861 19.80 SCOTT CO ATTORNEY'S OFFICE FINES & FORFEITS FORFEITURE
79862 10,050.00 SHAKOPEE 62 PARTNERSHIP ROW 2003 RECONSTRUCTION
79863 110.00 STOCKER,ANN MISC BUSINESS PERMITS CLERK MANAGEMENT
79864 47,093.00 UNITED LAND LLC ROW 2003 RECONSTRUCTION
79865 488.41 ADVANCED BUSINESS SYS INC EQUIPMENT MAINTENANCE PLANNING MANAGEMENT
79866 120.00 BCNTRAINING & DEV CONFERENCE/SCHOOL/TRAINING POLICE MANAGEMENT
19867 26.85 BRAMBILLAS INC MERCHANDISE SHOP MANAGEMENT
79868 112.50 CANTERBURY CAR WASH EQUIPMENT MAINTENANCE INSPECTION MANAGEMENT
79869 3,130.30 CARGILL SALT DIV MATERIALS SNOWISAND
79870 451.12 CATCO MERCHANDISE SHOP MANAGEMENT
79871 2,098.00 CLAREY'S SAFETY EQUIP INC OPERATING SUPPLIES FIRE MANAGEMENT
79872 64.98 CUB FOODS SHAKOPEE OTHER PROF SERVICES POLICE MANAGEMENT
79873 14.25 DAVIS,ANITA TRAVElJSUBSISTENCE CLERK MANAGEMENT
79874 1,460.00 DAVISON, SCOTT BUILDING MAINT. PUBLIC WORKS BUILDING
79875 600.00 DONALD SALVERDA & ASSOC CONFERENCE/SCHOOL/TRAINING ADMINISTRATION
79876 3,477.00 DRESSEN OIL CO DIESEL GENERAL FUND
79877 30.00 DUNN-RITE SHOES & REPAIR . OTHER PROF SERVICES FIRE MANAGEMENT
79878 181.85 EMERGENCY MED PRODS INC OPERATING SUPPLIES FIRE MANAGEMENT
79879 20.00 FIRE INSTRUCTORS ASSN OF MN DUES FIRE MANAGEMENT
79880 400.00 FS TECHNOLOGY GROUP LLC OTHER PROF SERVICES POLICE STATION
79881 360.00 G C BENTLEY ASSOC INC ENGINEERING CONSULTANTS 2003 RECONSTRUCTION
79882 328.90 GOPHER STATE ONE-CALL INC OTHER PROF SERVICES SEWER MANAGEMENT
79883 142.96 HEARTLAND TIRE lNC MERCHANDISE SHOP MANAGEMENT
79884 9.15 HUGHES, DANIEL TRAVEUSUBSISTENCE POLICE MANAGEMENT
79885 163.05 INFRATECH INC EQUIPMENT MAINTENANCE FIRE MANAGEMENT
79886 101.18 INTOXIMETERS INC OPERATING SUPPLIES POLICE MANAGEMENT
79887 3,542.58 K M T COMMUNICATIONS OTHERPROFSER~CES TRANSIT D-A-R
79888 18.00 KLIMEK, EILEEN TRAVEUSUBSISTENCE FINANCE MANAGEMENT
79889 3,932.80 KROMINGA, TERRY OTHER PROF SERVICES INSPECTION MANAGEMENT
R55CKREG LOG22000VO CITY OF SHAKOPEE 2/26/2004 9:33:27
Council Check Register Page - 2
2/13/2004-3/1/2004
Check # Amount Vendor / Explanation Account Description Business Unit
-
79890 3,618.87 LANO EQUIPMENT INC EQUIPMENT EQUIPMENT I.S. FUND
79891 87.76 LEEK, R MICHAEL TRAVEL/SUBSISTENCE TRANSIT
79892 297.00 LOFFLER BUSINESS SYSTEMS INC PRINTING/PUBLISHING UNALLOCATED
79893 12.154.65 LOGIS OFFICE SUPPLIES MIS
79894 875.00 MCALLISTER, ROBERT OTHER PROF SERVICES ANIMAL CONTROL
79895 971.00 MINNEAPOLIS FINANCE DEPT OTHER PROF SERVICES PAWN SHOPS
79896 40.00 MINNESOTA CORRECTIONS ASSOCIAT OTHER PROF SERVICES POLICE MANAGEMENT
79897 5.00 MINNESOTA STATE UNIVERSITY OTHER PROF SERVICES POLICE MANAGEMENT
79898 140.00 MN BUILDING CODES, STATE OF CONFERENCElSCHOOLJTRAINING INSPECTION MANAGEMENT
79899 200.00 MOCIC TRAVEL/SUBSISTENCE POLlCE MANAGEMENT
79900 34.00 MPPOA OPERATING SUPPLIES POLICE MANAGEMENT
79901 120.35 NEOPOST INC OFFICE SUPPLIES CLERK MANAGEMENT
79902 304.95 NFPA OPERATING SUPPLIES FIRE MANAGEMENT
79903 2,212.20 NORTHWEST ASSOCIATED CONSUL TAN OTHER PROF SERVICES LONG RANGE
79904 21.37 PETERSON,NICOLE TRAVEL/SUBSISTENCE PLANNING MANAGEMENT
79905 77.39 PITSCHNEIDER, TOM TELEPHONE FIRE MANAGEMENT
79906 50.50 PRIEBE.DEB TRANSIT FARES TRANSIT VAN POOL
79907 615.36 RIVERFRONT PRESS OFFICE SUPPLIES UNALLOCATED
79908 62.339.44 SCOTT CO TREASURER PRINTING/PUBLlSHING 04-1 WEINANDT ACRES ST RECON
79909 360.00 SEH OTHER PROF SERVICES STREET MANAGEMENT
79910 52.00 SHAKOPEE CHAMBER OF COMMERCE TRAVEL/SUBSISTENCE POLICE MANAGEMENT
79911 438.79 SHAKOPEE GRAVEL INC MATERIALS SNOWISAND
79912 919.76 SHAKOPEE PUBLIC UTILITY COMM ENGINEERING CONSULTANTS 04-4 WEST DEANS LAKE
79913 335.00 SHAKOPEE TOWING INC OTHER PROF SERVICES FORFEITURE
79914 363.41 SHERWIN WILLIAMS CO OPERATING SUPPLIES PUBLIC WORKS BUILDING
79915 128.12 SIEMON IMPLEMENT INC EQUIPMENT MAINTENANCE PARK EQUIPMENT MAINTENANCE
79916 603.27 ST JOSEPH EQ INC EQUIPMENT MAINTENANCE EQUIPMENT MAINTENANCE
79917 152.79 STEVE TUPYS TIRE SERV INC MERCHANDISE SHOP MANAGEMENT
79918 219.41 UNIFORMS UNLIMITED OPERATING SUPPLIES POLICE MANAGEMENT
79919 20.00 VOXLAND,GREGG TRAVEL/SUBSISTENCE FINANCE MANAGEMENT
79920 5,560.37 VPSIINC TRANSPORTATION TRANSIT VAN POOL
79921 111.25 W S DARLEY & CO OPERATING SUPPLIES ARE MANAGEMENT
79922 495.01 WM MUELLER & SONS MATERIALS STREET MAINTENANCE
79923 110,213.78 WSB & ASSOC INC ENGINEERING CONSULTANTS 2003 RECONSTRUCTION
79924 305.39 ZARNOTH BRUSH WORKS INC MERCHANDISE SHOP MANAGEMENT
79925 9.90 AT & T WIRELESS SERVICES TELEPHONE FIRE MANAGEMENT
79926 1,974.88 AFLAC AFLAC PAYABLE PAYROLL CLEARING
79927 598.55 CENTERPOINT ENERGY GAS SERVCIE GAS BUILDING/APPARATUS
79928 45.00 CONCEPT BUILDERS LLC C.O. CHARGI; PAYABLE ESCROW FUND
79929 4,802.65 DELTA DENTAL PLAN OF MN DENTAL INSURANCE PAYROLL CLEARING
79930 3,155.44 ELAN FINANCIAL SERVICES RECREATION SUPPLIES RECREATION PROGRAMS
" o'
'. .
R55CKREG LOG22000VO CITY OF SHAKOPEE 2126/2004 9:33:27
Council Check Register Page - 3
2/13/2004-3/112004
Check # Amount Vendor 1 Explanation Account Description Business Unit
-
79931 1,582.96 I 0 S CAPITAL INC EQUIPMENT RENT POLICE MANAGEMENT
79932 130.50 JIM CARLSON LEASING CO EQUIPMENT RENT SW METRO DRUG TASK FORCE
79933 1,771.29 K M T COMMUNICATIONS OTHER PROF SERVICES TRANSIT D-A-R
79934 2,130.00 LINK CONSTRUCTION CO RESID LANDSCAPE PAYABLE ESCROW FUND
79935 63,091.50 MEDICA HEALTH PAYABLE PAYROLL CLEARING
79936 7.34 METROCALL TELEPHONE FIRE INSPECTOR
79937 484.50 MN CHILD SUPPORT PAYMENT CTR OTHER DEDUCTIONS PAYROLL CLEARING
79938 160.00 MN DEPT OF PUBLIC SAFETY CONFERENCEISCHOOLfTRAINING POLICE MANAGEMENT
79939 2,144.47 MW JOHNSON CONSTRUCTION RESID LANDSCAPE PAYABLE ESCROW FUND
79940 416.00 NCPERS GROUP LIFE INS LIFE PAYABLE PAYROLL CLEARING
79941 360.00 SHAKOPEE PUBLIC UTILITY COMM ENGINEERING CONSULTANTS 2003 RECONSTRUCTION
79942 1,493.07 UNITED HEAL THCARE INSURANCE CO ACCOUNTS RECEIVABLE - NONSYSTE PAYROLL CLEARING
79943 700.00 UNITED STATES POSTAL SERVICE POSTAGE POLICE MANAGEMENT
79944 45.52 VALLEY PONTIAC GMC MOTOR FUELS & LUBRICANTS SW METRO DRUG TASK FORCE
79945 8.08 VERIZON WIRELESS - BELLEVUE TELEPHONE FIRE MANAGEMENT
400,922.36 Grand Total
Payment Instrument Totals
Check Total 400,922.36
Total Payments 400,922.36
. .
R55CKSUM LOG20000 CITY OF SHAKOPEE 2/26/2004 9:33:55
Council Check Summary Page - 1
2/13/2004 - 3/1/2004
Company Amount
-
01000 GENERAL FUND 129,862.84
02120 FORFEITURE 4,564.70
02140 TRANSIT 73,193.31
04021 CAPITAL IMPROVEMENT FUND 1,940.50
04054 CR16/CR83 PROJECT 657.76
04055 2003 PROJECTS 79,773.90
04056 WEST DEANS LAKE 80,049.75
04057 2004 PROJECTS 4,823.50
07100 SEWER FUND 164.45
07300 STORM FUND 1,581.58
07500 RECREATION FUND 3,486.30
07800 EQUIPMENT l.S. FUND 3,618.87
07810 BUILDING I.S. FUND 2,481.41
08025 SW METRO DRUG TASK FORCE 176.02
08040 ESCROW FUND 14,547.47
Report Totals 400,922.36