08-13-12 CC Reg Mtg Agenda
COUNCIL ACTION FORM
Department Council Meeting Item Number
Finance August 13, 2012 3A
Item Description: Verified Claims
From: Michelle Nguyen
Bruce DeJong
Background / Previous Action
Claims for council authorization. The attached claims list includes checks numbered 53240 through
53314 totaling $485,740.93.
Staff Recommendation
Staff recommends approval of the claims list.
8/09/2012 12:02 PM A/P HISTORY CHECK REPORT PAGE: 1
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE: 7/24/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
00051 EFTPS - FEDERAL W/H D 7/31/2012 000000 11,655.46
00092 MN DEPT OF REVENUE D 7/31/2012 000000 2,115.35
20005 WELLS FARGO HEALTH BENEFIT SVC D 7/31/2012 000000 1,474.60
00086 AFSCME COUNCIL 5 - UNION R 7/31/2012 053240 305.92
00053 ICMA RETIREMENT TRUST-302131-4 R 7/31/2012 053241 1,663.50
16625 NCPERS MINNESOTA R 7/31/2012 053242 32.00
00052 PERA R 7/31/2012 053243 7,124.37
00700 ABDO, EICK & MEYERS, LLP R 8/13/2012 053245 17,400.00
01380 ALLIED BLACKTOP CO R 8/13/2012 053246 159,085.74
29306 ALLIED WASTE SERVICES #894 R 8/13/2012 053247 13,741.20
16275 AMERICAN MESSAGING R 8/13/2012 053248 6.39
29449 BARTON SAND & GRAVEL COMPANY R 8/13/2012 053249 50.00
03243 BNR IRRIGATION SERVICES, INC. R 8/13/2012 053250 230.29
04081 CARQUEST AUTO PARTS R 8/13/2012 053251 172.88
17300 CENTERPOINT ENERGY R 8/13/2012 053252 194.59
26100 CENTURY LINK R 8/13/2012 053253 1,007.01
04500 CITY OF CHANHASSEN R 8/13/2012 053255 5,056.87
07600 CITY OF EXCELSIOR R 8/13/2012 053256 14,957.78
24600 CITY OF TONKA BAY R 8/13/2012 053257 328.02
05875 CUB FOODS - SHOREWOOD R 8/13/2012 053258 6.07
05885 CULLIGAN BOTTLED WATER R 8/13/2012 053259 53.66
1 DAVID WESSNER R 8/13/2012 053260 1,000.00
8/09/2012 12:02 PM A/P HISTORY CHECK REPORT PAGE: 2
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE: 7/24/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
29448 DERMCO-LAVINE CONSTRUCTION CO. R 8/13/2012 053261 7,700.00
26110 DEX ONE R 8/13/2012 053262 10.85
29271 DREW KRIESEL R 8/13/2012 053263 1,409.15
07270 ESS BROTHERS & SONS INC R 8/13/2012 053264 442.46
29445 EXCELSIOR PAINT & DESIGN, LLC R 8/13/2012 053265 21.45
12125 FEDEX KINKO'S R 8/13/2012 053266 14.46
07975 FINANCE AND COMMERCE R 8/13/2012 053267 200.35
08500 FRONTIER PRECISION, INC. R 8/13/2012 053268 153.07
08712 G & K SERVICES R 8/13/2012 053269 1,361.23
29362 GENERAL SPORTS CORPORATION R 8/13/2012 053270 147.00
27195 GRAINGER, INC R 8/13/2012 053271 484.79
10000 GROUT, TWILA R 8/13/2012 053272 25.30
29426 HOMEHELP R 8/13/2012 053273 66.00
29447 INCLINE EXTERIORS R 8/13/2012 053274 5,263.96
11375 J & R COMPLETE AUTO & RADIATOR R 8/13/2012 053275 776.13
29291 JOHN DEERE LANDSCAPES R 8/13/2012 053276 80.46
11650 KENNEDY & GRAVEN, CHARTERED R 8/13/2012 053277 277.16
29293 LAKE MINNETONKA ASSOCIATION R 8/13/2012 053278 6,000.00
13100 LANO EQUIPMENT OF NORWOOD, INC R 8/13/2012 053279 11.79
29259 MALKERSON GUNN MARTIN LLP R 8/13/2012 053280 3,533.50
14480 MASON, BRADLEY R 8/13/2012 053281 227.16
15050 MEDIACOM R 8/13/2012 053282 107.05
8/09/2012 12:02 PM A/P HISTORY CHECK REPORT PAGE: 3
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE: 7/24/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
15176 MENARDS R 8/13/2012 053283 208.21
15300 METRO SALES, INC. R 8/13/2012 053284 720.00
17700 MINNETONKA SCHOOL DISTRICT R 8/13/2012 053285 55.00
14050 MTI DISTRIBUTING COMPANY R 8/13/2012 053286 509.69
29368 NORTH STAR PUMP SERVICE R 8/13/2012 053287 1,015.31
19750 NORTHERN TOOL & EQUIPMENT COUN R 8/13/2012 053288 13.94
15900 OFFICE DEPOT R 8/13/2012 053289 325.52
29436 OMANN BROTHERS PAVING, INC. R 8/13/2012 053290 16,775.61
29332 ON SITE SANITATION INC R 8/13/2012 053291 751.06
15000 PAETEC R 8/13/2012 053292 535.13
1 PENTEL SEMINARS INC R 8/13/2012 053293 157.50
22482 SAM'S CLUB R 8/13/2012 053294 346.07
22987 SIR LINES-A-LOT R 8/13/2012 053295 14,159.09
23500 SO LK MTKA POLICE DEPT R 8/13/2012 053296 82,739.14
23185 STERLING FENCE INC R 8/13/2012 053297 51.76
29294 STRATEGIC EQUIPMENT & SUPPLY C R 8/13/2012 053298 57.88
29101 SUN NEWSPAPERS R 8/13/2012 053299 263.74
17200 SUN PATRIOT NEWSPAPERS R 8/13/2012 053300 16.54
23738 T-MOBILE R 8/13/2012 053301 72.39
06000 THE DALE GREEN COMPANY R 8/13/2012 053302 290.70
29443 THE MULCH STORE R 8/13/2012 053303 60.00
25000 TOTAL PRINTING SERVICES R 8/13/2012 053304 989.55
8/09/2012 12:02 PM A/P HISTORY CHECK REPORT PAGE: 4
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE: 7/24/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
25540 UNITED LABORATORIES R 8/13/2012 053305 315.96
70200 VERIZON WIRELESS R 8/13/2012 053306 289.11
29413 VOYAGER FLEET SYSTEMS, INC. R 8/13/2012 053307 3,245.44
27190 WACONIA FARM SUPPLY R 8/13/2012 053308 393.27
29446 WAI NANI SURF & PADDLE R 8/13/2012 053310 350.00
83900 WASTE MANAGEMENT OF WI-MN R 8/13/2012 053311 574.60
29417 WENCK ASSOCIATES, INC. R 8/13/2012 053312 121.50
19800 XCEL ENERGY R 8/13/2012 053313 13,230.14
03325 BOYER FORD TRUCK, INC. E 8/13/2012 999999 213.74
05305 COMMUNITY REC RESOURCES E 8/13/2012 999999 720.90
06572 DELTA DENTAL OF MINNESOTA D 8/01/2012 999999 667.17
07900 HAWKINS, INC. E 8/13/2012 999999 3,053.71
09400 GOPHER STATE ONE CALL E 8/13/2012 999999 274.15
10473 HENN CTY TAXPAYER SVCS PUBLIC E 8/13/2012 999999 30.00
13070 LANDINI, JAMES E 8/13/2012 999999 40.00
15500 METRO COUNCIL ENVMT(WASTEWATER E 8/13/2012 999999 300.00
15885 MIDWEST MAILING SYSTEMS, INC. E 8/13/2012 999999 326.86
18500 WM. MUELLER & SONS, INC. E 8/13/2012 999999 2,498.32
19445 NGUYEN, MICHELLE E 8/13/2012 999999 132.40
20268 PANCHYSHYN, JEAN E 8/13/2012 999999 1,284.60
20300 PAZANDAK, JOSEPH E 8/13/2012 999999 1,797.41
20950 KENNETH N. POTTS, P.A. E 8/13/2012 999999 2,291.66
8/09/2012 12:02 PM A/P HISTORY CHECK REPORT PAGE: 5
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE: 7/24/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
28451 WSB AND ASSOCIATES, INC. E 8/13/2012 999999 13,417.50
29324 HANSEN THORP PELLINEN OLSON, I E 8/13/2012 999999 634.00
* * T O T A L S * * NO INVOICE AMOUNT DISCOUNTS CHECK AMOUNT
REGULAR CHECKS: 71 389,363.46 0.00 389,363.46
HAND CHECKS: 0 0.00 0.00 0.00
DRAFTS: 4 15,912.58 0.00 15,912.58
EFT: 15 27,015.25 0.00 27,015.25
NON CHECKS: 0 0.00 0.00 0.00
VOID CHECKS: 0 VOID DEBITS 0.00
VOID CREDITS 0.00 0.00 0.00
TOTAL ERRORS: 0
VENDOR SET: 01 BANK: 1 TOTALS: 90 432,291.29 0.00 432,291.29
BANK: 1 TOTALS: 90 432,291.29 0.00 432,291.29
REPORT TOTALS: 90 432,291.29 0.00 432,291.29
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 1
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
ABDO, EICK & MEYERS, LLP 8/13/12 AUDIT SERVICES General Fund Professional Svcs 17,400.00_
TOTAL: 17,400.00
AFSCME COUNCIL 5 - UNION 7/31/12 P/R DEDUCTS - UNION DUES General Fund NON-DEPARTMENTAL 305.92_
TOTAL: 305.92
ALLIED BLACKTOP CO 8/13/12 2012 STREET SEAL COAT Street Capital Imp Street Capt Improvemen 159,085.74_
TOTAL: 159,085.74
ALLIED WASTE SERVICES #894 8/13/12 MONTHLY RECYCLING SVCS Recycling Utility Recycling 13,741.20_
TOTAL: 13,741.20
AMERICAN MESSAGING 8/13/12 612-534-3975 & 612-818-591 General Fund Public Works 3.21
8/13/12 612-534-3975 & 612-818-591 Water Utility Water 1.59
8/13/12 612-534-3975 & 612-818-591 Sanitary Sewer Uti Sewer 1.59_
TOTAL: 6.39
BARTON SAND & GRAVEL COMPANY 8/13/12 ASPHALT-CONCRETE DEMO General Fund Public Works 25.00
8/13/12 ASPHALT-CONCRETE DEMO General Fund Public Works 25.00_
TOTAL: 50.00
BNR IRRIGATION SERVICES, INC. 8/13/12 REPAIR IRRIGATION-XCEL BRE Water Utility Water 230.29_
TOTAL: 230.29
BOYER FORD TRUCK, INC. 8/13/12 CLAMP - PP ENG OUT - SEAL General Fund Public Works 213.74_
TOTAL: 213.74
CARQUEST AUTO PARTS 8/13/12 BATTERY-POWER SPORT General Fund Public Works 141.58
8/13/12 BATTERY-POWER SPORT RETURN General Fund Public Works 21.46-
8/13/12 HYDRAULIC HOSE & FITTINGS General Fund Public Works 21.10
8/13/12 OIL FILTERS General Fund Public Works 31.66_
TOTAL: 172.88
CENTERPOINT ENERGY 8/13/12 5755 CTRY CLUB RD General Fund Municipal Buildings 20.25
8/13/12 24200 SMITHTOWN RD General Fund Public Works 63.81
8/13/12 5745 CTRY CLB RD & 25200 H General Fund Park Maintenance 29.33
8/13/12 20630 MANOR RD-WARMING HOU General Fund Park Maintenance 15.56
8/13/12 5735 COUNTRY CLUB RD - SSC Southshore Communi Senior Community Cente 32.61
8/13/12 20405 KNIGHTSBRIDGE RD Water Utility Water 20.21
8/13/12 28125 BOULDER BRIDGE DR Water Utility Water 12.82_
TOTAL: 194.59
CENTURY LINK 8/13/12 952-470-6340 General Fund Municipal Buildings 121.98
8/13/12 952-470-2294 General Fund Public Works 58.26
8/13/12 952-474-7635-SSCC Southshore Communi Senior Community Cente 125.65
8/13/12 612-E45-1785 Water Utility Water 315.39
8/13/12 612-E45-8019 Water Utility Water 236.43
8/13/12 952-470-9605 Water Utility Water 74.65
8/13/12 952-470-9606 Water Utility Water 74.65_
TOTAL: 1,007.01
CITY OF CHANHASSEN 8/13/12 018505-000 ACCT SVC ADDRES Water Utility Water 110.91
8/13/12 018505-001 ACCT SVC ADDRES Water Utility Water 4,945.96_
TOTAL: 5,056.87
CITY OF EXCELSIOR 8/13/12 SANITARY SEWER SERVICE Sanitary Sewer Uti Sewer 7,478.89
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 2
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
8/13/12 SANITARY SEWER SERVICE Sanitary Sewer Uti Sewer 7,478.89_
TOTAL: 14,957.78
CITY OF TONKA BAY 8/13/12 ANNUAL SPRINKLER SYSTEM PR General Fund Public Works 325.00
8/13/12 WATER Water Utility Water 3.02_
TOTAL: 328.02
COMMUNITY REC RESOURCES 8/13/12 MONTHLY COMMISSION SVCS Southshore Communi Senior Community Cente 706.50
8/13/12 MONTHLY COMMISSION ON EVEN Southshore Communi Senior Community Cente 14.40_
TOTAL: 720.90
CUB FOODS - SHOREWOOD 8/13/12 COFFEE FOR ELECTION General Fund Administration 6.07_
TOTAL: 6.07
CULLIGAN BOTTLED WATER 8/13/12 5755 CTRY CLUB RD-DRINKING General Fund Municipal Buildings 53.66_
TOTAL: 53.66
DELTA DENTAL OF MINNESOTA 8/01/12 MONTHLY DENTIST PREMIUM General Fund Unallocated Expenses 667.17_
TOTAL: 667.17
DERMCO-LAVINE CONSTRUCTION CO., INC. 8/13/12 RESURFACE AT CATHCARTH-TEN Park Capital Impro Park Capital Improveme 4,200.00
8/13/12 RESURFACE-CATHCARTH-BASKET Park Capital Impro Park Capital Improveme 2,100.00
8/13/12 RESURFACE-SILVERWD-1/2 BAS Park Capital Impro Park Capital Improveme 1,400.00_
TOTAL: 7,700.00
DEX ONE 8/13/12 SOUTHSHORE COMM CENTER ADS Southshore Communi Senior Community Cente 10.85_
TOTAL: 10.85
DREW KRIESEL 8/13/12 JUN CONTRACT SVC Southshore Communi Senior Community Cente 370.00
8/13/12 JUN EQUIPMENT RENTAL Southshore Communi Senior Community Cente 305.00
8/13/12 JUL CONTRACT SVC Southshore Communi Senior Community Cente 340.00
8/13/12 JUL EQUIPMENT RENTAL Southshore Communi Senior Community Cente 150.00
8/13/12 JUL GEN SUPPLIES Southshore Communi Senior Community Cente 244.15_
TOTAL: 1,409.15
EFTPS - FEDERAL W/H 7/31/12 FEDERAL W/H General Fund NON-DEPARTMENTAL 4,992.23
7/31/12 FICA W/H General Fund NON-DEPARTMENTAL 2,104.17
7/31/12 MEDICARE W/H General Fund NON-DEPARTMENTAL 726.45
7/31/12 FICA W/H General Fund Administration 631.24
7/31/12 MEDICARE W/H General Fund Administration 147.62
7/31/12 FICA W/H General Fund Finance 287.26
7/31/12 MEDICARE W/H General Fund Finance 67.18
7/31/12 FICA W/H General Fund Planning 271.35
7/31/12 MEDICARE W/H General Fund Planning 63.47
7/31/12 FICA W/H General Fund Protective Inspections 189.64
7/31/12 MEDICARE W/H General Fund Protective Inspections 44.35
7/31/12 FICA W/H General Fund City Engineer 164.64
7/31/12 MEDICARE W/H General Fund City Engineer 38.50
7/31/12 FICA W/H General Fund Public Works 869.01
7/31/12 MEDICARE W/H General Fund Public Works 203.24
7/31/12 FICA W/H General Fund Park Maintenance 255.08
7/31/12 MEDICARE W/H General Fund Park Maintenance 59.66
7/31/12 FICA W/H General Fund Recreation 68.10
7/31/12 MEDICARE W/H General Fund Recreation 15.93
7/31/12 FICA W/H Southshore Communi Senior Community Cente 5.55
7/31/12 MEDICARE W/H Southshore Communi Senior Community Cente 1.31
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 3
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
7/31/12 FICA W/H Water Utility Water 132.30
7/31/12 MEDICARE W/H Water Utility Water 30.95
7/31/12 FICA W/H Sanitary Sewer Uti Sewer 173.31
7/31/12 MEDICARE W/H Sanitary Sewer Uti Sewer 40.52
7/31/12 FICA W/H Recycling Utility Recycling 4.77
7/31/12 MEDICARE W/H Recycling Utility Recycling 1.11
7/31/12 FICA W/H Stormwater Managem STORMWATER MANAGEMENT 53.91
7/31/12 MEDICARE W/H Stormwater Managem STORMWATER MANAGEMENT 12.61_
TOTAL: 11,655.46
ESS BROTHERS & SONS INC 8/13/12 MANHOLE ADJ. RINGS General Fund Public Works 442.46_
TOTAL: 442.46
EXCELSIOR PAINT & DESIGN, LLC 8/13/12 STONE, TILE & LAMINATE Southshore Communi Senior Community Cente 21.45_
TOTAL: 21.45
FEDEX KINKO'S 8/13/12 6045 CHASKA RD-PLANS General Fund Protective Inspections 14.46_
TOTAL: 14.46
FINANCE AND COMMERCE 8/13/12 2012 L.S. 5 & 6 REH PROJEC Street Capital Imp Street Capt Improvemen 200.35_
TOTAL: 200.35
FRONTIER PRECISION, INC. 8/13/12 SUPPLIES RENT General Fund City Engineer 55.23
8/13/12 SUPPLIES RENTAL General Fund City Engineer 97.84_
TOTAL: 153.07
G & K SERVICES 8/13/12 CH SVC General Fund Municipal Buildings 127.56
8/13/12 PW SVC General Fund Public Works 1,159.41
8/13/12 SSCC SVC Southshore Communi Senior Community Cente 74.26_
TOTAL: 1,361.23
GENERAL SPORTS CORPORATION 8/13/12 SAFETY CAMP T-SHIRTS General Fund Recreation 147.00_
TOTAL: 147.00
GOPHER STATE ONE CALL 8/13/12 JULY SVC Water Utility Water 137.08
8/13/12 JULY SVC Sanitary Sewer Uti Sewer 137.07_
TOTAL: 274.15
GRAINGER, INC 8/13/12 SUMP PUMP S.E. WELL Water Utility Water 55.96
8/13/12 GLOVES & DISPOSABLES Sanitary Sewer Uti Sewer 295.60
8/13/12 SEAL LIFT Sanitary Sewer Uti Sewer 5.18
8/13/12 FATIMA LIFT STATION PARTS Sanitary Sewer Uti Sewer 128.05_
TOTAL: 484.79
GROUT, TWILA 8/13/12 STEP TO IT MTG-BROOKDALE General Fund Administration 25.30_
TOTAL: 25.30
HANSEN THORP PELLINEN OLSON, INC. 8/13/12 PROJ 12-01-CTY RD 19 TRL S Trail Capital Outl Land & Open Space Fund 634.00_
TOTAL: 634.00
HAWKINS, INC. 8/13/12 CHLORINE CYLINDER Water Utility Water 2,993.71
8/13/12 CHLORINE Water Utility Water 60.00_
TOTAL: 3,053.71
HENN CTY TAXPAYER SVCS PUBLIC RECORDS 8/13/12 EGKF64 -RECORD-EASE WEB General Fund City Engineer 30.00_
TOTAL: 30.00
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 4
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
HOMEHELP 8/13/12 TABLE CLOTHES Southshore Communi Senior Community Cente 66.00_
TOTAL: 66.00
ICMA RETIREMENT TRUST-302131-457 7/31/12 P/R DEDUCTS-DEFERRED COM General Fund NON-DEPARTMENTAL 1,535.96
7/31/12 P/R DEDUCTS-DEFERRED COM General Fund NON-DEPARTMENTAL 127.54_
TOTAL: 1,663.50
INCLINE EXTERIORS 8/13/12 RE-SET GUTTER ON BACK-C.H. General Fund Municipal Buildings 125.00
8/13/12 RE-SET GUTTER-RENTAL HOUSE General Fund Municipal Buildings 350.00
8/13/12 CHIMNEY CAULK/SPLASH-RENTA General Fund Municipal Buildings 350.00
8/13/12 P.W. BLDG-RESET ROOF EDGIN General Fund Public Works 4,218.96
8/13/12 BADGER PARK REPAIR General Fund Park Maintenance 220.00_
TOTAL: 5,263.96
J & R COMPLETE AUTO & RADIATOR 8/13/12 '98FORT L8000-COMPRESSOR/D General Fund Public Works 776.13_
TOTAL: 776.13
JOHN DEERE LANDSCAPES 8/13/12 HERBICIDE General Fund Public Works 80.46_
TOTAL: 80.46
KENNEDY & GRAVEN, CHARTERED 8/13/12 RON JOHNSON LITIGATION General Fund Professional Svcs 277.16_
TOTAL: 277.16
KENNETH N. POTTS, P.A. 8/13/12 MONTHLY PROSECUTION SVC General Fund Professional Svcs 2,291.66_
TOTAL: 2,291.66
LAKE MINNETONKA ASSOCIATION 8/13/12 MILFOIL-PHELPS & GIDEON BA General Fund Park Maintenance 6,000.00_
TOTAL: 6,000.00
LANDINI, JAMES 8/13/12 AUG WELLNESS EXP General Fund City Engineer 40.00_
TOTAL: 40.00
LANO EQUIPMENT OF NORWOOD, INC. 8/13/12 DIPSTICK General Fund Public Works 11.79_
TOTAL: 11.79
MALKERSON GUNN MARTIN LLP 8/13/12 GENERAL MATTERS General Fund Professional Svcs 1,850.00
8/13/12 PERSONNEL General Fund Professional Svcs 906.50
8/13/12 AQUATIC INVASIVE-5490 VINE General Fund Municipal Buildings 777.00_
TOTAL: 3,533.50
MASON, BRADLEY 8/13/12 2012 BOOTS EXP General Fund Public Works 227.16_
TOTAL: 227.16
MEDIACOM 8/13/12 5375 COUNTRY CLUB RD - SSC Southshore Communi Senior Community Cente 107.05_
TOTAL: 107.05
MENARDS 8/13/12 LAMPS General Fund Public Works 208.21_
TOTAL: 208.21
METRO COUNCIL ENVMT(WASTEWATER) 8/13/12 INDUSTRIAL SEWER DISCHRG P Sanitary Sewer Uti Sewer 300.00_
TOTAL: 300.00
METRO SALES, INC. 8/13/12 05/01-08/01 SVC General Fund Municipal Buildings 720.00_
TOTAL: 720.00
MIDWEST MAILING SYSTEMS, INC. 8/13/12 NEWSLETTER SERVICES General Fund Administration 303.33
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 5
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
8/13/12 ADDT'L POSTAGE General Fund Administration 23.53_
TOTAL: 326.86
MINNETONKA SCHOOL DISTRICT 8/13/12 DAMAGE DEPOSIT REFUND Southshore Communi Senior Community Cente 55.00_
TOTAL: 55.00
MISC. VENDOR DAVID WESSNER 8/13/12 27920 SMITHTOWN ROAD Escrow Deposit Age NON-DEPARTMENTAL 1,000.00
PENTEL SEMINARS INC 8/13/12 MANNERLY MANNERS YOUTH CLA Southshore Communi Senior Community Cente 157.50_
TOTAL: 1,157.50
MN DEPT OF REVENUE 7/31/12 STATE W/H General Fund NON-DEPARTMENTAL 2,115.35_
TOTAL: 2,115.35
MTI DISTRIBUTING COMPANY 8/13/12 TIRES GROUNDMASTER General Fund Public Works 162.35
8/13/12 IRRIGATION PARTS General Fund Park Maintenance 347.34_
TOTAL: 509.69
NCPERS MINNESOTA 7/31/12 UNIT #762400 MONTHLY LIFE General Fund NON-DEPARTMENTAL 32.00_
TOTAL: 32.00
NGUYEN, MICHELLE 8/13/12 WELLNESS REIMBERSEMENT General Fund Finance 40.00
8/13/12 JULY MILEAGE General Fund Finance 92.40_
TOTAL: 132.40
NORTH STAR PUMP SERVICE 8/13/12 PARTS FOR L.S.#9 Sanitary Sewer Uti Sewer 1,015.31_
TOTAL: 1,015.31
NORTHERN TOOL & EQUIPMENT COUNT 8/13/12 SPRAYER WAND General Fund Public Works 13.94_
TOTAL: 13.94
OFFICE DEPOT 8/13/12 GEN SUPPLIES General Fund Administration 24.22
8/13/12 GEN SUPPLIES General Fund Administration 1.21
8/13/12 GEN SUPPLIES General Fund Administration 159.50
8/13/12 ELECTION SUPPLIES General Fund Administration 140.59_
TOTAL: 325.52
OMANN BROTHERS PAVING, INC. 8/13/12 P.V.#2-PROJECT 12-02 Street Capital Imp Street Capt Improvemen 16,775.61_
TOTAL: 16,775.61
ON SITE SANITATION INC 8/13/12 BAGER PARK General Fund Park Maintenance 65.96
8/13/12 CATHCART PARK General Fund Park Maintenance 45.96
8/13/12 FREEMAN PARK General Fund Park Maintenance 266.13
8/13/12 SILVERWOOD PARK General Fund Park Maintenance 45.96
8/13/12 SOUTH SHORE SKATE General Fund Park Maintenance 45.96
8/13/12 CHRISTMAS LAKE BOAT ACCESS General Fund Park Maintenance 235.13
8/13/12 CRESENT BEACH General Fund Park Maintenance 45.96_
TOTAL: 751.06
PAETEC 8/13/12 5755 COUNTRY CLUB RD-C.H. General Fund Municipal Buildings 143.68
8/13/12 24200 SMITHTOWN RD-P.W. General Fund Public Works 46.90
8/13/12 BADGER/MANOR/CATHCART PARK General Fund Park Maintenance 145.60
8/13/12 26352 SMTWN RD/28125 BLDR Water Utility Water 98.70
8/13/12 24255 SMITHTOWN ROAD Water Utility Water 100.25_
TOTAL: 535.13
PANCHYSHYN, JEAN 8/13/12 ORGANIZATIONAL BEHAVIOR-BO General Fund Administration 170.00
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 6
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
8/13/12 MANAGEMENT COURSE General Fund Administration 1,114.60_
TOTAL: 1,284.60
PAZANDAK, JOSEPH 8/13/12 EXHASUT FAN BELT General Fund Municipal Buildings 7.50
8/13/12 MILEAGES General Fund Protective Inspections 1,246.30
8/13/12 BLDG CODE REGISTER-1/09 & General Fund Protective Inspections 325.00
8/13/12 ANNUAL SHADE TREE COURSE/C General Fund Protective Inspections 190.00
8/13/12 BOOK-MN TREES General Fund Protective Inspections 14.43
8/13/12 TAPE OFR TRAFFICE COUNTING General Fund City Engineer 14.18_
TOTAL: 1,797.41
PERA 7/31/12 P/R DEDUCTS-PERA General Fund NON-DEPARTMENTAL 3,298.31
7/31/12 P/R DEDUCTS-PERA General Fund Administration 754.89
7/31/12 P/R DEDUCTS-PERA General Fund Finance 358.41
7/31/12 P/R DEDUCTS-PERA General Fund Planning 371.89
7/31/12 P/R DEDUCTS-PERA General Fund Protective Inspections 260.99
7/31/12 P/R DEDUCTS-PERA General Fund City Engineer 192.52
7/31/12 P/R DEDUCTS-PERA General Fund Public Works 1,066.98
7/31/12 P/R DEDUCTS-PERA General Fund Park Maintenance 283.18
7/31/12 P/R DEDUCTS-PERA General Fund Recreation 79.63
7/31/12 P/R DEDUCTS-PERA Southshore Communi Senior Community Cente 6.51
7/31/12 P/R DEDUCTS-PERA Water Utility Water 164.40
7/31/12 P/R DEDUCTS-PERA Sanitary Sewer Uti Sewer 215.69
7/31/12 P/R DEDUCTS-PERA Recycling Utility Recycling 5.57
7/31/12 P/R DEDUCTS-PERA Stormwater Managem STORMWATER MANAGEMENT 65.40_
TOTAL: 7,124.37
SAM'S CLUB 8/13/12 CITY HALL General Fund Municipal Buildings 127.78
8/13/12 PUBLIC WORK General Fund Public Works 218.29_
TOTAL: 346.07
SIR LINES-A-LOT 8/13/12 2012 PAINT STRIPING General Fund Streets & Roadways 14,159.09_
TOTAL: 14,159.09
SO LK MTKA POLICE DEPT 8/13/12 OPERATING BUDGET EXPENSE General Fund Police Protection 82,257.00
8/13/12 HENN CTY PROCESSING FEE General Fund Police Protection 162.66
8/13/12 HENN CTY PROCESSING FEE General Fund Police Protection 319.48_
TOTAL: 82,739.14
STERLING FENCE INC 8/13/12 FENCE REPAIR General Fund Park Maintenance 51.76_
TOTAL: 51.76
STRATEGIC EQUIPMENT & SUPPLY CORPORATI 8/13/12 SPRING PRE RINSE Southshore Communi Senior Community Cente 57.88_
TOTAL: 57.88
SUN NEWSPAPERS 8/13/12 SHWD ACCURACY TEST 08/02 General Fund Administration 23.98
8/13/12 ASHLAND WOODS 07/26 General Fund Planning 41.97
8/13/12 ACCESSORY APT. 07/26 General Fund Planning 35.97
8/13/12 PROJECT 12-06 --07/19 & 07 Street Capital Imp Street Capt Improvemen 161.82_
TOTAL: 263.74
SUN PATRIOT NEWSPAPERS 8/13/12 VOTE ACCURACY TEST 08/04 General Fund Administration 16.54_
TOTAL: 16.54
T-MOBILE 8/13/12 952-463-5836 - ADMIN CEL General Fund Administration 72.39_
TOTAL: 72.39
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 7
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
THE DALE GREEN COMPANY 8/13/12 PUL MIX General Fund Public Works 290.70_
TOTAL: 290.70
THE MULCH STORE 8/13/12 TREE & BRUSH DISPOSAL General Fund Public Works 60.00_
TOTAL: 60.00
TOTAL PRINTING SERVICES 8/13/12 ELECTION INSERT General Fund Administration 141.07
8/13/12 MONTHLY NEWSLETTER General Fund Administration 707.41
8/13/12 SSCC INSERT Southshore Communi Senior Community Cente 141.07_
TOTAL: 989.55
UNITED LABORATORIES 8/13/12 SOAPS FOR PARKS General Fund Park Maintenance 315.96_
TOTAL: 315.96
VERIZON WIRELESS 8/13/12 612-865-3582 - BRAD NIELSE General Fund Planning 71.44
8/13/12 L.S. PHONE SERVICES Sanitary Sewer Uti Sewer 217.67_
TOTAL: 289.11
VOYAGER FLEET SYSTEMS, INC. 8/13/12 GAS THRU 07/24/12 General Fund Public Works 3,245.44_
TOTAL: 3,245.44
WACONIA FARM SUPPLY 8/13/12 ORANGE LINE General Fund Public Works 21.27
8/13/12 VLV BALL General Fund Public Works 40.85
8/13/12 PISTON ASSEMBLY General Fund Public Works 78.17
8/13/12 PAINTING SUPPLIES General Fund Public Works 108.68
8/13/12 IGNITION MODULE - SPARK PL General Fund Public Works 58.08
8/13/12 ORANGE LINE-CLAM PKG General Fund Park Maintenance 85.29
8/13/12 FIN. CHRG General Fund Park Maintenance 0.93_
TOTAL: 393.27
WAI NANI SURF & PADDLE 8/13/12 BEGINNER GROUP CLINIC General Fund Recreation 350.00_
TOTAL: 350.00
WASTE MANAGEMENT OF WI-MN 8/13/12 24200 SMITHTOWN RD-PUB WOR General Fund Public Works 408.53
8/13/12 5735 COUNTRY CLUB RD -SSCC Southshore Communi Senior Community Cente 166.07_
TOTAL: 574.60
WELLS FARGO HEALTH BENEFIT SVCS 7/31/12 P/R DEDUCTS-HSA General Fund NON-DEPARTMENTAL 1,474.60_
TOTAL: 1,474.60
WENCK ASSOCIATES, INC. 8/13/12 PROJ 2739-01 APPLE RD CHAN Stormwater Managem STORMWATER MANAGEMENT 121.50_
TOTAL: 121.50
WM. MUELLER & SONS, INC. 8/13/12 ROAD SERVICES General Fund Public Works 382.44
8/13/12 ROAD SERVICES General Fund Public Works 1,722.30
8/13/12 ROAD SERVICES General Fund Public Works 393.58_
TOTAL: 2,498.32
WSB AND ASSOCIATES, INC. 8/13/12 CATHCART DR & CTRY CLB RD General Fund City Engineer 1,188.00
8/13/12 2012 MILL & OVERLAY Street Capital Imp Street Capt Improvemen 2,574.00
8/13/12 2012 MUNICIPAL WA EXT PLAN Water Utility Water 7,163.00
8/13/12 GIS & CAD SUPPORT Sanitary Sewer Uti Sewer 204.00
8/13/12 6180 MURRAY HILL DRAINAGE Stormwater Managem STORMWATER MANAGEMENT 1,236.00
8/13/12 COVINGTON RD SEDIMENT TRAP Stormwater Managem STORMWATER MANAGEMENT 214.00
8/13/12 COVINGTON RD SEDIMENT TRAP Stormwater Managem STORMWATER MANAGEMENT 288.00
8/13/12 ENGINEERING SUPPORT Stormwater Managem STORMWATER MANAGEMENT 336.50
08-09-2012 12:01 AM C O U N C I L REPORT BY VENDOR- AUGUST 13, 2012 PAGE: 8
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
8/13/12 ENGINEERING SUPPORT Stormwater Managem STORMWATER MANAGEMENT 214.00_
TOTAL: 13,417.50
XCEL ENERGY 8/13/12 XCEL ENERGY General Fund Municipal Buildings 526.62
8/13/12 XCEL ENERGY General Fund Municipal Buildings 3.68
8/13/12 XCEL ENERGY General Fund Public Works 469.77
8/13/12 XCEL ENERGY General Fund Traffic Control/Str Li 31.61
8/13/12 XCEL ENERGY General Fund Traffic Control/Str Li 3,197.95
8/13/12 5700 CTY RD 19 General Fund Traffic Control/Str Li 34.86
8/13/12 5700 CTY RD 19 UNIT LIGHTS General Fund Traffic Control/Str Li 126.37
8/13/12 XCEL ENERGY General Fund Park Maintenance 422.77
8/13/12 5735 COUNTRY CLUB RD Southshore Communi Senior Community Cente 1,000.34
8/13/12 24253 SMITHTOWN ROAD Water Utility Water 1,051.86
8/13/12 XCEL ENERGY Water Utility Water 1,104.86
8/13/12 XCEL ENERGY Water Utility Water 1,890.36
8/13/12 XCEL ENERGY Water Utility Water 2,823.34
8/13/12 XCEL ENERGY Sanitary Sewer Uti Sewer 545.75_
TOTAL: 13,230.14
**PAYROLL EXPENSES 7/30/2012 - 99/99/9999 General Fund Administration 10,412.41
General Fund Finance 4,943.50
General Fund Planning 5,129.57
General Fund Protective Inspections 3,600.09
General Fund City Engineer 2,655.45
General Fund Public Works 14,716.89
General Fund Park Maintenance 4,582.29
General Fund Recreation 1,098.32
Southshore Communi Senior Community Cente 89.67
Water Utility Water 2,267.38
Sanitary Sewer Uti Sewer 2,975.03
Recycling Utility Recycling 76.86
Stormwater Managem STORMWATER MANAGEMENT 902.18_
TOTAL: 53,449.64
=============== FUND TOTALS ================
101 General Fund 228,774.36
402 Park Capital Improvements 7,700.00
404 Street Capital Improvemen 178,797.52
406 Trail Capital Outlay 634.00
490 Southshore Community Ctr. 4,248.82
601 Water Utility 26,100.07
611 Sanitary Sewer Utility 21,212.55
621 Recycling Utility 13,829.51
631 Stormwater ManagementUtil 3,444.10
880 Escrow Deposit Agency 1,000.00
--------------------------------------------
GRAND TOTAL: 485,740.93
--------------------------------------------
TOTAL PAGES: 8
ACCTS RECEIVABLE LISTING
Vendor
DescriptionAccount CodeAmountDateInv #
John PastuckJ. Pastuck Addition expenses-balance101-34104 618.4211/17/042178
David & Susan Bigham19720 Sweetwater Curve101-35101 100.002/13/062219
Cingular WirelessKLM eng Inc-inspection-old market rd tower101-34104 450.003/30/062223
Walt & Holly Jones5520 Covington Road101-35101 100.008/14/062250
Cingular WirelessKLM eng Inc-inspection-W tower/Smithtown Rd101-34104 3,000.009/14/062252
Arbor Creek Development (2006 Svc)
Brenshell Homes, Inc.101-34104 77.002/17/072270
Excelsior Covenant Church (2006 svc)
Excelsior Covenant Church101-34104 768.002/12/072278
Ian/Carol Friendly19825 Chartwell Hill101-35101 200.0010/11/072294
Save-A-Lot/SuperValu Inc23800 State Highway No 7101-35101 400.0010/11/072295
Southshore Senior Center5735 Country Club Road101-35101 200.0010/11/072297
Excelsior Covenant Church ( 2007 svc)
Excelsior Covenant Church101-34104 6,196.0010/22/072299
10 Spring Homes Inc
10 Spring Homes Inc101-34104 3,031.5010/22/072302
Wedgewood Dr/Mallard Ln/Teal Circle
Amesbury Homeowners Assn101-34104 3,610.0012/17/072305
10 Spring Homes Inc20522 Excelsior Blvd- WSB Eng.101-34104 93.002/13/082318
Excelsior Covenant Church (& 2007 svc)
Excelsior Covenant Church101-34104 372.002/13/082319
Elite services Inc/Josh AllenOakview Estates Const Observation101-34104 1,023.002/13/082322
Excelsior Covenant ChurchExcelsior Covenant Church (Nov 2006)101-34104 105.002/14/082323
Oakview Estates Const Observation
Elite services Inc/Josh Allen101-34104 1,002.002/27/082327
Leonard -- Easement vacation/replace title
John Pastuck101-34104 75.006/6/082333
Leonard-Subdivision
Dan Nelson101-34104 500.007/22/082334
David & Janet Finken19990 Sweetwater Curve101-35101 200.008/21/082344
David & Janet Finken19990 Sweetwater Curve101-35101 100.008/26/082345
Excelsior Covenant Church Jul 2008 Svc
Excelsior Covenant Church101-34104 1,104.0010/1/082351
The Grant InstituteGrantwriting workshop-Twila/Julie--Cancelled101-41400-331 1,194.0010/22/082352
Thomas Alt, Sr.23760 Lawtonka Drive101-35101 100.002/11/092382
David & Susan Bigham19720 Sweetwater Curve101-35101 200.003/26/092391
S.E. Water Tower Inspection from KLM Engineering
Classic Protective Coatings101-34104 2,300.008/20/092412
Christopher Sebald20625 Garden Road101-35101 200.009/16/092417
Jeffrey Fox5270 Howards Pt Road101-35101 200.0011/25/092425
Write off these receivables 27,518.92
ACCTS RECEIVABLE LISTING
Vendor
DescriptionAccount CodeAmountDateInv #
T-Mobile USAKLM eng Inc-inv #2761/2682 & eng review101-34104 4,820.003/30/062227
Arbor Creek Development (2006 Svc)
Brenshell Homes, Inc.101-34104 1,000.002/17/072270
10 Spring Homes Inc
10 Spring Homes Inc101-34104 1,200.0010/22/072302
Lake Virginia Woods
Virginia Shores Development101-34104 1,248.0012/11/082366
Lake Virginia Woods- Dec svc
Virginia Shores Development101-34104 662.502/19/092385
Smithtown Tower-Field Inspection of Antenna
T-Mobile USA101-34104 5,000.0012/15/092432
Tonka Football AssociationFall User101-34785 1,130.009/9/112488
Water Tower Field Inspection of Antennas
AT& T101-34104 3,400.0012/29/112502
Retain these receivables 18,460.50
CITY OF SHOREWOOD
ESCROW DEPOSIT DETAIL
AMT DEPAMT RET'DDEPOSITORRECEIPTCK
DATEDEPOSITORProperty Address/Description(credit)(debit)BALANCENO.NO.COMMENTS
11/22/93Katter Dev/Game TrustGideon Woods 15,075.0020781
12/14/93Katter Dev/Game TrustGideon Woods 7,500.00
03/14/94Katter Dev/Game TrustGideon Woods 3,310.0021352
invoice coded wrong -
JE done to move to
escrow 8/97
08/31/97Lan-De-Con Inc invoice for trees 9,955.00JE 8-21
12/22/95North Star TitleGideon Woods - Glen Rd Partnership 4,500.0024593
05/21/96Gideon Woods ConstrGideon Woods - Tree deposit 2,000.0025253
per City Planner & City
Atty - monies
used up for legal fees
incurred
07/28/98Jim Game TrustGideon Woods 11,250.00 18,680.0029018
02/21/97SBA5500 Old Market Rd 4,611.00 4,611.0026543hold as deposit
12/10/99APT Mpls, Inc.West Tower landscape esc 9,750.00 9,750.0031192hold as deposit
08/09/99Ariel CommunicationsStructl Mod W. watertower 5,000.00 5,000.0030594hold as deposit
01/05/01Lundgren Bros Const27125 Marsh Pt Ct - Wetland restoration 600.00 600.0032992
12/13/02Natural Homes 20840 Forest Dr 1,000.00 1,000.0036969
01/08/03Capestone Bldrs Corp20775 Manor Rd - Barrington PUD 100.00 100.0037089
05/16/03Tradewinds Concepts/Design5655 Fairway Dr 100.00 100.0037626
09/04/03Manley Bros Construction5670 Fairway Dr 500.00 500.0038406
10/07/03Schwarz Bldrs Inc24140 Yellowstone Tr 100.00 100.0038096
10/09/03Sharratt Design28210 Woodside Rd 100.00 100.0038108
10/09/03Bosworth, Kelly6140/6170 Lk Linden Dr 100.00 100.0038109
10/28/03Capestone Bldrs20775 Manor Rd - Barrington PUD 200.00 200.0038198
04/07/04Water Street HomesPrelim Plat/CUP 100.00 100.0039070
05/04/04Buell Consulting24283 Smithtown Rd 100.00 100.0039197
06/01/04Ca Ro Le Townsend Inc5680 Manitou 100.00 100.0039331
07/23/04Blume, David5240-5250 Vine 100.00 100.0039581
08/02/04Rogney, Ron & Melanie5950 Grant St 150.00 150.0039610
08/02/04Capestone Builders Corp20755 Manor 300.00 300.0039612
08/02/04Meixner, Tania25625 Birch Bluff Rd 150.00 150.0039620
08/09/04Tradewinds Concepts/Designs5610 Grant Lorenz 200.00 200.0039645
04/05/04Tradewinds5610 Grant Lorenz 100.00 100.0039049
09/21/04Sharrat Designno address on receipt 150.00 150.0039869
09/30/04Carter, Dewey5655 Fairway Dr 1,000.00 1,000.0039933
11/02/04Finch, Mark20250/20090 Excelsior Blvd-zon appl 100.00 100.0040136
01/06/05Clliers Turley Martin TuckerShorewood Shopping /Conditional Use Permit 100.00 100.0040468
01/28/05Paumen Properties5650/5660 Grant Lorenz Rd/sub apple rd 100.00 100.0040574
05/02/05Bridgeland Development5025/5045/5055/5075 Suburban Dr 225.00 225.0040978
05/20/05Parker Scott DevelopersBarrington Lots-replatting 1,000.00 1,000.0041070
06/10/05Vogstrom, Paul26350 Smithtown Rd 100.00 100.0041160
07/14/05Bridgeland Development CoFinal Plat-Parkview 1,000.00 1,000.0041312
10/31/05Kennedy, Mark23975 Yellowstone Trail 100.00 100.0041877
11/14/05Asscending Praise Church5795 Country Club Rd 1,475.00 1,475.0041970Rental deposit for 5795
01/03/06Rohan Lund, IncNO STREET NAME ===????? 150.00 150.0042221
06/28/06Hanna Jr., Ted20965 Forest Drive 300.00 300.0043097
7/31/06 Leonard, St &
Deinard
legal free $285.00
==$15 bal. will return to
prop owner
07/31/06Leonard, St & DeinardLegal fee-hazardous building -42777
Total legal fee is $1065
but a balance is only $
15
then we invoice back
$1050, inv#2253-
9/14/06 --Write-off per
Auditor & Bonnie at the
YE2009
09/15/06Leonard, St & DeinardLegal fee-hazardous building -
11/06/06Jay Anderson19955 Excelsior Blvd 100.00 100.0043771
02/05/07Daniel Nelson25865 Birch Bluff Rd 100.00 100.0044161
04/20/07Alpine Capital LLC27725 Virginia Cove-Tree Preservation 2,000.00 2,000.0044438
06/05/07Hendel Const.5625 Christmas Lake Point 150.00 150.0044633
07/12/07Thomas Scherber5080 Shady Island Trail 150.00 150.0044795
08/31/07Park Midwest23680 State Highway 7 100.00 100.0045027
02/07/08Minnetonka School Dist #27626350 Smithtown Rd 100.00 100.0045670
07/01/08Robert Thomson5050 Suburban Dr 150.00 150.0046251
08/04/08Minnewasta School Dist 27626350 Smithtown Rd 100.00 100.0046339
10/06/09Clearwire Legacy24285 Smithtown Road 1,000.00 1,000.0047696
10/06/09Clearwire Legacy5500 Old Market Road 1,000.00 1,000.0047697
10/06/09Clearwire Legacy26350 Smithtown Road 1,000.00 1,000.0047698
04/23/10South Tonka Little LeagueFreeman park #3 batling cage 100.00 100.0048698
04/04/11Shorewood Ponds Association 100.00 100.0050078
2011 Revenue Recognition54,091.00
04/05/04T-Mobile5500 Old Market Rd 100.00 100.0039052
04/22/05Brendshell Homes5610 Grant Lorenz 1,000.00 1,000.0040930
05/04/05Virginia Shores DevelopmentSmithtown Rd 1,000.00 1,000.0040992
08/25/05Virginia Shorews DevelopmentSmithtown Rd 1,325.00 1,325.0041481
10/04/0510 Spring Inc20520 & 20540 Excelsior Blvd 200.00 200.0041664
09/02/08TTM Operating Corp (AT&T)5500 Old Market Rd 1,000.00 1,000.0046531
09/26/08Frend Rental Homes (10 Spring)20520 Excelsior Blvd 1,000.00 1,000.0046631
26352 Smitthown Road-CUP telecom equip on
Minnewasta Water Towern
10/08/08TTM Operating Corp (AT&T) 1,000.00 1,000.0046675
09/13/10T-Mobile USA5500 Old Market Road 1,000.00 1,000.0049291
2012 Revenue Recognition7,625.00
MEMORANDUM
Date:
August 9, 2012
To:
Mayor Lizee
Council Members
From:
Bruce DeJong, Finance Director
Re:
June, 2012 Quarterly Investment Report
______________________________________________________________
The City’s cash reserves have been invested in both cash flow type of investments to meet
ongoing expenditure needs and longer-term securities with higher returns than money market
funds. It is important to remember our investment priorities in order of concern:
1.Safety – preserving principal;
2.Liquidity – having funds available when needed to pay expenses;
3.Yield – earning market returns for the amount of risk we are willing to accept.
With the investments that the City currently in the portfolio, and with our philosophy of holding
investments to maturity, we are exposed to minimal risk of principal loss. The only expected
change is when investments are marked to market and gains or losses are recognized at year end.
In order to decide what time frames should be targeted for various investments, a cash flow
projection has been prepared. Over the past three years, the city has only had three months
where cash flow is positive – June, July, and December. Those months are when we receive tax
settlements which are just prior to scheduled bond payments. The rest of the months need about
$500,000 on average to cover operating costs. This means that the City should have a mix of
callable and non-callable investments with both short-term cash flow needs being met and longer
maturities targeting major cash needs over the five year maximum investment horizon.
The yield curve has declined slightly throughout the year. We are still occasionally finding
investments in the four year and under time frame that return around 1.0%. I have purchased
Certificates of Deposit to specific months for cash flow needs.
We have a significant amount of funds held in cash and money market while we keep looking for
investments with a reasonable yield. With wire transfer fees, it doesn’t make sense to move
money frequently because the fees may be higher than the interest we can earn. The most
significant risk in this environment is getting stuck with investments at a very low rate when
interest rates start to increase. There is no upside for investing in a long term security at less than
1%. Investments will go down in value when interest rate rise and they go up in a hurry on the
long end when the yield curve is so flat and economic activity picks up. Staff aims to invest
these funds to increase the overall portfolio returns, while maintain flexibility to cover
expenditures as projected using a cash flow estimate.
Please contact me or Mr. Joynes if you have any questions.
Attachment: June, 2012 Investment Summary