11-26-12 CC Reg Mtg Agenda
COUNCIL ACTION FORM
Department Council Meeting Item Number
Finance November 26, 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 53674 through
53772 totaling $140,216.55.
Staff Recommendation
Staff recommends approval of the claims list.
11/20/2012 4:39 PM A/P HISTORY CHECK REPORT PAGE: 2
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE:11/14/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 11/20/2012 000000 15,366.33
00092 MN DEPT OF REVENUE D 11/20/2012 000000 2,811.07
20005 WELLS FARGO HEALTH BENEFIT SVC D 11/20/2012 000000 1,424.60
1 WESMANN, WILLIAM/ROS R 11/26/2012 053674 200.00
00053 ICMA RETIREMENT TRUST-302131-4 R 11/20/2012 053675 1,613.50
00052 PERA R 11/20/2012 053676 6,368.63
29239 ALRICK, LISA LOUISE R 11/26/2012 053678 128.00
29346 ASLESEN, DIANNE M. R 11/26/2012 053679 56.00
29169 BERG, LOIS ANN R 11/26/2012 053680 56.00
1 BOULDER BRIDGE HOA R 11/26/2012 053681 100.00
29170 BOYNTON, KAREN R 11/26/2012 053682 146.00
29171 BRANDHORST, TENA J. R 11/26/2012 053683 72.00
29203 BRECKE, JERRY R 11/26/2012 053684 120.00
29172 BUCHER, MARLYS J. R 11/26/2012 053685 132.00
26100 CENTURY LINK R 11/26/2012 053686 1,138.76
29173 CHINANDER, MARY ANN R 11/26/2012 053688 72.00
29278 CLASSIC CLEANING COMPANY R 11/26/2012 053689 844.31
29348 CLINE, KEN GEORGE R 11/26/2012 053690 120.00
29349 CONLEY, KEVIN SCOTT R 11/26/2012 053691 130.00
29473 COSTELLO, LAUREL R 11/26/2012 053692 84.00
29236 CROSS, DAVID R 11/26/2012 053693 110.00
05885 CULLIGAN BOTTLED WATER R 11/26/2012 053694 40.16
11/20/2012 4:39 PM A/P HISTORY CHECK REPORT PAGE: 3
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE:11/14/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
1 DAN CARLSON R 11/26/2012 053695 300.00
29452 DELMONTE, BRYAN R 11/26/2012 053696 56.00
29472 DEMARS, CATHERINE R 11/26/2012 053697 20.00
26110 DEX ONE R 11/26/2012 053698 21.86
29271 DREW KRIESEL R 11/26/2012 053699 1,027.00
1 EDWARDS MARY R 11/26/2012 053700 1,275.00
07383 ELECTRICAL INSTALLATION & MAIN R 11/26/2012 053701 207.84
29234 ERICKSON, WILLIAM R 11/26/2012 053702 124.00
19950 FERGUSON WATERWORKS #2516 R 11/26/2012 053703 1,061.26
50172 FISH, REBECCA R 11/26/2012 053704 222.00
29244 FRADETTE, KATHLEEN R 11/26/2012 053705 20.00
08712 G & K SERVICES R 11/26/2012 053706 228.43
29211 GAGNE, MARILYN R 11/26/2012 053707 64.00
29209 GAGNE, ROBERT R 11/26/2012 053708 84.00
1 GEORGIA KANDIKO R 11/26/2012 053709 246.00
29212 GERMAN, EUGENE R 11/26/2012 053710 20.00
29224 GREGERSON, VALORIE R 11/26/2012 053711 96.00
10000 GROUT, TWILA R 11/26/2012 053712 75.00
29213 HAUSER, PATRICIA R 11/26/2012 053713 82.00
29206 HERZIG, MICHAEL R 11/26/2012 053714 140.00
29424 JOCHIMS STEPHANIE R 11/26/2012 053715 150.00
29214 KAPOLKA, JOSEPH R 11/26/2012 053716 72.00
11/20/2012 4:39 PM A/P HISTORY CHECK REPORT PAGE: 4
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE:11/14/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
29352 KEELER, WILLIAM CONVERSE R 11/26/2012 053717 76.00
29179 KENDRICK, JAMES EDWARD R 11/26/2012 053718 154.00
11650 KENNEDY & GRAVEN, CHARTERED R 11/26/2012 053719 129.70
12525 KVALSETH, AMY R 11/26/2012 053720 80.00
29180 LABORE, CARLA KAY R 11/26/2012 053721 127.50
29354 LANE, KAREN M. R 11/26/2012 053722 120.00
29181 LARSON, AUDREY L. R 11/26/2012 053723 58.00
29182 LEEBENS, SHIRLEY J. R 11/26/2012 053724 158.00
29183 LEVACK, GORDON R 11/26/2012 053725 56.00
29356 LOUIS, SANDRA S. R 11/26/2012 053726 128.00
29185 LOVE, ELAINE MARIE R 11/26/2012 053727 68.00
13750 LUGOWSKI, JOSEPH R 11/26/2012 053728 125.00
29189 MAJESTIC, JILL DOROTHY R 11/26/2012 053729 204.00
29259 MALKERSON GUNN MARTIN LLP R 11/26/2012 053730 2,682.50
29191 MCDAVITT, PAMELA ANN R 11/26/2012 053731 76.00
1 MCDONALD MICHAEL R 11/26/2012 053732 200.00
29210 MCDONALD, MICHAEL PATRICK R 11/26/2012 053733 58.00
29192 MCDONALD, PAMELA J. R 11/26/2012 053734 52.00
17275 MINNEHAHA CREEK WATERSHED DIST R 11/26/2012 053735 20,554.74
29471 MOORE, REBECCA R 11/26/2012 053736 55.00
14050 MTI DISTRIBUTING COMPANY R 11/26/2012 053737 76.27
29229 NILES, CHARLES ARDEN R 11/26/2012 053738 92.00
11/20/2012 4:39 PM A/P HISTORY CHECK REPORT PAGE: 5
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE:11/14/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
29216 NOACK, JEROME R 11/26/2012 053739 82.00
29218 NOYES, KERRY KATHLEEN R 11/26/2012 053740 84.00
15900 OFFICE DEPOT R 11/26/2012 053741 523.62
29194 OGIN, ELEANOR M. R 11/26/2012 053742 74.00
29332 ON SITE SANITATION INC R 11/26/2012 053743 556.85
29474 ORGANIC DISPOSAL LLC R 11/26/2012 053744 432.00
29195 PAULSEN, CAROL ANN R 11/26/2012 053745 136.00
1 PETRON JON & SHIRA R 11/26/2012 053746 1,050.00
29470 PETRON KAREN R 11/26/2012 053747 76.00
29358 POLSON, CHRISTOPHER CHARLES R 11/26/2012 053748 80.00
29198 RABY, JEAN ANN R 11/26/2012 053749 64.00
29197 RABY, TEDDY T. R 11/26/2012 053750 72.00
1 RICH STEMPEL R 11/26/2012 053751 5,970.00
29451 SACCHET, LAURIE R 11/26/2012 053752 50.00
29453 SCHMID, JOANNE H. R 11/26/2012 053753 64.00
29359 SCHNEIDER, THOMAS E. R 11/26/2012 053754 56.00
22950 SHOREWOOD TRUE VALUE R 11/26/2012 053755 55.16
29360 SIMCOX, LYNDA M. R 11/26/2012 053756 86.00
29454 SKINNER, PHYLLIS R 11/26/2012 053757 56.00
29200 SMELTZER, VIRGIL L. R 11/26/2012 053758 156.00
29201 SPANNAUS, BARBARA R. R 11/26/2012 053759 132.00
1 ST JOHN THE BAPTIST R 11/26/2012 053760 100.00
11/20/2012 4:39 PM A/P HISTORY CHECK REPORT PAGE: 6
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE:11/14/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
29202 STEIN, JANE F. R 11/26/2012 053761 198.00
1 SWIFT HOUSEMOVING R 11/26/2012 053762 200.00
29443 THE MULCH STORE R 11/26/2012 053763 833.26
1 THEMIG MARK R 11/26/2012 053764 150.00
29361 THOMPSON, KYLE B. R 11/26/2012 053765 127.50
23726 TKDA ENGINEERS ARCHITECTS PLAN R 11/26/2012 053766 2,749.49
1 TRIDEN ELLEN R 11/26/2012 053767 100.00
29245 WHITE, SHERRY DAVIS R 11/26/2012 053768 84.00
1 WILLIAMS SCOTT R 11/26/2012 053769 150.00
28350 WOODRUFF, RICHARD R 11/26/2012 053770 32.19
19800 XCEL ENERGY R 11/26/2012 053771 19.47
1 ZIN FAMILY REALTORS R 11/26/2012 053772 150.00
05305 COMMUNITY REC RESOURCES E 11/26/2012 999999 61.36
10576 ADVANCED IMAGING SOLUTIONS INC E 11/26/2012 999999 67.00
13070 LANDINI, JAMES E 11/26/2012 999999 25.00
13525 LINK, CLARE T. E 11/26/2012 999999 165.00
15885 MIDWEST MAILING SYSTEMS, INC. E 11/26/2012 999999 500.00
19435 SPRINT E 11/26/2012 999999 124.57
20300 PAZANDAK, JOSEPH E 11/26/2012 999999 1,051.41
27195 GRAINGER, INC E 11/26/2012 999999 981.42
28900 ZEE MEDICAL SERVICE E 11/26/2012 999999 102.05
29324 HANSEN THORP PELLINEN OLSON, I E 11/26/2012 999999 207.00
11/20/2012 4:39 PM A/P HISTORY CHECK REPORT PAGE: 7
VENDOR SET: 01 City of Shorewood
BANK: 1 BEACON BANK
DATE RANGE:11/14/2012 THRU 99/99/9999
CHECK INVOICE CHECK CHECK CHECK
VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT
29338 BLANCHARD CATERING, INC. E 11/26/2012 999999 292.50
* * T O T A L S * * NO INVOICE AMOUNT DISCOUNTS CHECK AMOUNT
REGULAR CHECKS: 97 57,204.00 0.00 57,204.00
HAND CHECKS: 0 0.00 0.00 0.00
DRAFTS: 3 19,602.00 0.00 19,602.00
EFT: 11 3,577.31 0.00 3,577.31
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: 111 80,383.31 0.00 80,383.31
BANK: 1 TOTALS: 111 80,383.31 0.00 80,383.31
REPORT TOTALS: 113 80,383.31 0.00 80,383.31
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 1
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
ADVANCED IMAGING SOLUTIONS INC 11/26/12 10/15-11/14 SVC General Fund Municipal Buildings 67.00_
TOTAL: 67.00
ALRICK, LISA LOUISE 11/26/12 ELECTION NOV 2012 General Fund Administration 128.00_
TOTAL: 128.00
ASLESEN, DIANNE M. 11/26/12 ELECTION-NOV-2012 General Fund Administration 56.00_
TOTAL: 56.00
BERG, LOIS ANN 11/26/12 ELECTION-NOV-2012 General Fund Administration 56.00_
TOTAL: 56.00
BLANCHARD CATERING, INC. 11/26/12 FALL SOUP CLASS 11/06/12 Southshore Communi Senior Community Cente 292.50_
TOTAL: 292.50
BOYNTON, KAREN 11/26/12 ELECTION-NOV-2012 General Fund Administration 146.00_
TOTAL: 146.00
BRANDHORST, TENA J. 11/26/12 ELECTION-NOV-2012 General Fund Administration 72.00_
TOTAL: 72.00
BRECKE, JERRY 11/26/12 ELECTION-NOV-2012 General Fund Administration 120.00_
TOTAL: 120.00
BUCHER, MARLYS J. 11/26/12 ELECTION NOV 2012 General Fund Administration 132.00_
TOTAL: 132.00
CENTURY LINK 11/26/12 952-470-6340 General Fund Municipal Buildings 121.50
11/26/12 952-470-2294 General Fund Public Works 57.78
11/26/12 952-474-7635-SOUTHSHORE CO Southshore Communi Senior Community Cente 130.97
11/26/12 952-474-7635-SOUTHSHORE CO Southshore Communi Senior Community Cente 127.25
11/26/12 612-E45-1785 Water Utility Water 315.39
11/26/12 612-E45-8019 Water Utility Water 236.43
11/26/12 952-470-9605 Water Utility Water 74.72
11/26/12 952-470-9606 Water Utility Water 74.72_
TOTAL: 1,138.76
CHINANDER, MARY ANN 11/26/12 ELECTION-NOV-2012 General Fund Administration 72.00_
TOTAL: 72.00
CLASSIC CLEANING COMPANY 11/26/12 C.H. SVC General Fund Municipal Buildings 529.03
11/26/12 P.W. SVC General Fund Public Works 315.28_
TOTAL: 844.31
CLINE, KEN GEORGE 11/26/12 ELECTION-NOV-2012 General Fund Administration 120.00_
TOTAL: 120.00
COMMUNITY REC RESOURCES 11/26/12 OKTOBERFEST Southshore Communi Senior Community Cente 42.05
11/26/12 PAMPERRED ME Southshore Communi Senior Community Cente 19.31_
TOTAL: 61.36
CONLEY, KEVIN SCOTT 11/26/12 ELECTION-NOV-2012 General Fund Administration 130.00_
TOTAL: 130.00
COSTELLO, LAUREL 11/26/12 ELECTION-NOV-2012 General Fund Administration 84.00_
TOTAL: 84.00
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 2
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
CROSS, DAVID 11/26/12 ELECTION-NOV-2012 General Fund Administration 110.00_
TOTAL: 110.00
CULLIGAN BOTTLED WATER 11/26/12 5755 CTRY CLUB RD-DRINKING General Fund Municipal Buildings 40.16_
TOTAL: 40.16
DELMONTE, BRYAN 11/26/12 ELECTION-NOV-2012 General Fund Administration 56.00_
TOTAL: 56.00
DEMARS, CATHERINE 11/26/12 ELECTION-NOV-2012 General Fund Administration 20.00_
TOTAL: 20.00
DEX ONE 11/26/12 SOUTHSHORE COMM CENTER ADS Southshore Communi Senior Community Cente 11.01
11/26/12 SOUTHSHORE COMM CENTER ADS Southshore Communi Senior Community Cente 10.85_
TOTAL: 21.86
DREW KRIESEL 11/26/12 CONTRACT SVC Southshore Communi Senior Community Cente 362.00
11/26/12 EQUIPMENT RENTAL Southshore Communi Senior Community Cente 665.00_
TOTAL: 1,027.00
EFTPS - FEDERAL W/H 11/20/12 FEDERAL W/H General Fund NON-DEPARTMENTAL 7,830.76
11/20/12 FICA W/H General Fund NON-DEPARTMENTAL 2,379.65
11/20/12 MEDICARE W/H General Fund NON-DEPARTMENTAL 821.56
11/20/12 FICA W/H General Fund Council 80.60
11/20/12 MEDICARE W/H General Fund Council 18.87
11/20/12 FICA W/H General Fund Administration 455.03
11/20/12 MEDICARE W/H General Fund Administration 106.41
11/20/12 FICA W/H General Fund Finance 306.47
11/20/12 MEDICARE W/H General Fund Finance 71.68
11/20/12 FICA W/H General Fund Planning 296.06
11/20/12 MEDICARE W/H General Fund Planning 69.24
11/20/12 FICA W/H General Fund Protective Inspections 162.62
11/20/12 MEDICARE W/H General Fund Protective Inspections 38.04
11/20/12 FICA W/H General Fund City Engineer 799.33
11/20/12 MEDICARE W/H General Fund City Engineer 186.94
11/20/12 FICA W/H General Fund Public Works 872.24
11/20/12 MEDICARE W/H General Fund Public Works 203.99
11/20/12 FICA W/H General Fund Park Maintenance 67.68
11/20/12 MEDICARE W/H General Fund Park Maintenance 15.83
11/20/12 FICA W/H General Fund Recreation 58.62
11/20/12 MEDICARE W/H General Fund Recreation 13.71
11/20/12 FICA W/H Southshore Communi Senior Community Cente 12.71
11/20/12 MEDICARE W/H Southshore Communi Senior Community Cente 2.96
11/20/12 FICA W/H Water Utility Water 197.38
11/20/12 MEDICARE W/H Water Utility Water 46.16
11/20/12 FICA W/H Sanitary Sewer Uti Sewer 174.18
11/20/12 MEDICARE W/H Sanitary Sewer Uti Sewer 40.73
11/20/12 FICA W/H Recycling Utility Recycling 6.35
11/20/12 MEDICARE W/H Recycling Utility Recycling 1.49
11/20/12 FICA W/H Stormwater Managem STORMWATER MANAGEMENT 23.53
11/20/12 MEDICARE W/H Stormwater Managem STORMWATER MANAGEMENT 5.51_
TOTAL: 15,366.33
ELECTRICAL INSTALLATION & MAINTENANCE 11/26/12 SIGNAL RELAMP General Fund Public Works 207.84_
TOTAL: 207.84
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 3
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
ERICKSON, WILLIAM 11/26/12 ELECTION-NOV-2012 General Fund Administration 124.00_
TOTAL: 124.00
FERGUSON WATERWORKS #2516 11/26/12 WATER METERS Water Utility Water 1,061.26_
TOTAL: 1,061.26
FISH, REBECCA 11/26/12 ELECTION-NOV-2012 General Fund Administration 222.00_
TOTAL: 222.00
FRADETTE, KATHLEEN 11/26/12 ELECTION-NOV-2012 General Fund Administration 20.00_
TOTAL: 20.00
G & K SERVICES 11/26/12 PW SVC General Fund Public Works 228.43_
TOTAL: 228.43
GAGNE, MARILYN 11/26/12 ELECTION-NOV-2012 General Fund Administration 64.00_
TOTAL: 64.00
GAGNE, ROBERT 11/26/12 ELECTION - NOV-2012 General Fund Administration 84.00_
TOTAL: 84.00
GERMAN, EUGENE 11/26/12 ELECTION - NOV-2012 General Fund Administration 20.00_
TOTAL: 20.00
GRAINGER, INC 11/26/12 BULBS-ST LIGHTS/PRKG LOTS General Fund Public Works 981.42_
TOTAL: 981.42
GREGERSON, VALORIE 11/26/12 ELECTION-NOV-2012 General Fund Administration 96.00_
TOTAL: 96.00
GROUT, TWILA 11/26/12 15 YRS ANNIVERSARY General Fund Council 75.00_
TOTAL: 75.00
HANSEN THORP PELLINEN OLSON, INC. 11/26/12 OCT CR 19 TRAIL SVC Park Capital Impro Park Capital Improveme 103.50
11/26/12 OCT CR 19 TRAIL SVC Trail Capital Outl Land & Open Space Fund 103.50_
TOTAL: 207.00
HAUSER, PATRICIA 11/26/12 ELECTION-NOV-2012 General Fund Administration 82.00_
TOTAL: 82.00
HERZIG, MICHAEL 11/26/12 ELECTION NOV 2012 General Fund Administration 140.00_
TOTAL: 140.00
ICMA RETIREMENT TRUST-302131-457 11/20/12 P/R DEDUCTS-DEFERRED COM General Fund NON-DEPARTMENTAL 1,485.96
11/20/12 P/R DEDUCTS-DEFERRED COM General Fund NON-DEPARTMENTAL 127.54_
TOTAL: 1,613.50
JOCHIMS STEPHANIE 11/26/12 FUSED GLASS CLASS 10/28/12 Southshore Communi Senior Community Cente 150.00_
TOTAL: 150.00
KAPOLKA, JOSEPH 11/26/12 ELECTION-NOV-2012 General Fund Administration 72.00_
TOTAL: 72.00
KEELER, WILLIAM CONVERSE 11/26/12 ELECTION-NOV-2012 General Fund Administration 76.00_
TOTAL: 76.00
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 4
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
KENDRICK, JAMES EDWARD 11/26/12 ELECTION-NOV-2012 General Fund Administration 154.00_
TOTAL: 154.00
KENNEDY & GRAVEN, CHARTERED 11/26/12 RON JOHNSON LITIGATION General Fund Professional Svcs 129.70_
TOTAL: 129.70
KVALSETH, AMY 11/26/12 ELECTION-NOV-2012 General Fund Administration 80.00_
TOTAL: 80.00
LABORE, CARLA KAY 11/26/12 ELECTION-NOV-2012 General Fund Administration 127.50_
TOTAL: 127.50
LANDINI, JAMES 11/26/12 5 YRS ANNIVERSARY General Fund Council 25.00_
TOTAL: 25.00
LANE, KAREN M. 11/26/12 ELECTION-NOV-2012 General Fund Administration 120.00_
TOTAL: 120.00
LARSON, AUDREY L. 11/26/12 ELECTION-NOV-2012 General Fund Administration 58.00_
TOTAL: 58.00
LEEBENS, SHIRLEY J. 11/26/12 ELECTION-NOV-2012 General Fund Administration 158.00_
TOTAL: 158.00
LEVACK, GORDON 11/26/12 ELECTION-NOV-2012 General Fund Administration 56.00_
TOTAL: 56.00
LINK, CLARE T. 11/26/12 PARK MTG 11/14/12 General Fund Recreation 165.00_
TOTAL: 165.00
LOUIS, SANDRA S. 11/26/12 ELECTION NOV 2012 General Fund Administration 128.00_
TOTAL: 128.00
LOVE, ELAINE MARIE 11/26/12 ELECTION-NOV-2012 General Fund Administration 68.00_
TOTAL: 68.00
LUGOWSKI, JOSEPH 11/26/12 25 YRS ANNIVERSARY General Fund Council 125.00_
TOTAL: 125.00
MAJESTIC, JILL DOROTHY 11/26/12 ELECTION-NOV-2012 General Fund Administration 204.00_
TOTAL: 204.00
MALKERSON GUNN MARTIN LLP 11/26/12 GENERAL MATTERS General Fund Professional Svcs 1,850.00
11/26/12 XCEL-W GATE TRANSM UPGRADE General Fund Professional Svcs 55.50
11/26/12 AUG-PUBLIC IMPROVEMENT PRO Stormwater Managem STORMWATER MANAGEMENT 777.00_
TOTAL: 2,682.50
MCDAVITT, PAMELA ANN 11/26/12 ELECTION-NOV-2012 General Fund Administration 76.00_
TOTAL: 76.00
MCDONALD, MICHAEL PATRICK 11/26/12 ELECTION-NOV-2012 General Fund Administration 58.00_
TOTAL: 58.00
MCDONALD, PAMELA J. 11/26/12 ELECTION-NOV-2012 General Fund Administration 52.00_
TOTAL: 52.00
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 5
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
MIDWEST MAILING SYSTEMS, INC. 11/26/12 DEC NEWSLETTER POSTAGE General Fund Administration 500.00_
TOTAL: 500.00
MINNEHAHA CREEK WATERSHED DISTRICT 11/26/12 WATERCRAFT INSPECTED-XMAS General Fund Council 20,554.74_
TOTAL: 20,554.74
MISC. VENDOR BOULDER BRIDGE HOA 11/26/12 5970 BOULDER BRIDGE Escrow Deposit Age NON-DEPARTMENTAL 100.00
DAN CARLSON 11/26/12 '12 TEN/UNDER TENNIS GRANT General Fund NON-DEPARTMENTAL 300.00
EDWARDS MARY 11/26/12 6170 RIDGE ROAD Escrow Deposit Age NON-DEPARTMENTAL 900.00
EDWARDS MARY 11/26/12 6170 RIDGE ROAD Escrow Deposit Age NON-DEPARTMENTAL 375.00
GEORGIA KANDIKO 11/26/12 WATERCOLOR CLASS --11/15/1 Southshore Communi Senior Community Cente 246.00
MCDONALD MICHAEL 11/26/12 4695 LAGOON DRIVE Escrow Deposit Age NON-DEPARTMENTAL 200.00
PETRON JON & SHIRA 11/26/12 4865 SUBURBAN DRIVE Escrow Deposit Age NON-DEPARTMENTAL 1,050.00
RICH STEMPEL 11/26/12 5975 CATHCART DRIVE Escrow Deposit Age NON-DEPARTMENTAL 5,970.00
ST JOHN THE BAPTIST 11/26/12 5555 COVINGTON ROAD Escrow Deposit Age NON-DEPARTMENTAL 100.00
SWIFT HOUSEMOVING 11/26/12 26550 SMITHTOWN ROAD Escrow Deposit Age NON-DEPARTMENTAL 200.00
THEMIG MARK 11/26/12 21780 LILAC LANE Escrow Deposit Age NON-DEPARTMENTAL 150.00
TRIDEN ELLEN 11/26/12 4975 KENSINGTON GATE Escrow Deposit Age NON-DEPARTMENTAL 100.00
WESMANN, WILLIAM/ROS 11/26/12 03-590212-00 Water Utility NON-DEPARTMENTAL 200.00
WILLIAMS SCOTT 11/26/12 5955 COUNTRY CLUB ROAD Escrow Deposit Age NON-DEPARTMENTAL 150.00
ZIN FAMILY REALTORS 11/26/12 5820 RIDGE ROAD Escrow Deposit Age NON-DEPARTMENTAL 150.00_
TOTAL: 10,191.00
MN DEPT OF REVENUE 11/20/12 STATE W/H General Fund NON-DEPARTMENTAL 2,811.07_
TOTAL: 2,811.07
MOORE, REBECCA 11/26/12 ELECTION NOV-2012 General Fund Administration 55.00_
TOTAL: 55.00
MTI DISTRIBUTING COMPANY 11/26/12 BELTS & ELECTRONICS-MOWERS General Fund Public Works 76.27_
TOTAL: 76.27
NILES, CHARLES ARDEN 11/26/12 ELECTION-NOV-2012 General Fund Administration 92.00_
TOTAL: 92.00
NOACK, JEROME 11/26/12 ELECTION-NOV-2012 General Fund Administration 82.00_
TOTAL: 82.00
NOYES, KERRY KATHLEEN 11/26/12 ELECTION-NOV-2012 General Fund Administration 84.00_
TOTAL: 84.00
OFFICE DEPOT 11/26/12 GEN OFF SUPPLIES General Fund Administration 189.74
11/26/12 GEN OFF SUPPLIES General Fund Administration 69.40
11/26/12 GEN OFF. SUPPLIES General Fund Administration 57.50
11/26/12 ENVELOPE General Fund Administration 70.20
11/26/12 PLANNING GEN OFF SUPPLIES General Fund Planning 136.78_
TOTAL: 523.62
OGIN, ELEANOR M. 11/26/12 ELECTION-NOV-2012 General Fund Administration 74.00_
TOTAL: 74.00
ON SITE SANITATION INC 11/26/12 BAGER PARK General Fund Park Maintenance 45.96
11/26/12 CATHCART PARK General Fund Park Maintenance 45.96
11/26/12 FREEMAN PARK General Fund Park Maintenance 137.88
11/26/12 SILVERWOOD PARK General Fund Park Maintenance 45.96
11/26/12 SOUTH SHORE SKATE General Fund Park Maintenance 45.96
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 6
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
11/26/12 CHRISTMAS LAKE BOAT ACCESS General Fund Park Maintenance 235.13_
TOTAL: 556.85
ORGANIC DISPOSAL LLC 11/26/12 34 GALLON ORGAN Recycling Utility Recycling 432.00_
TOTAL: 432.00
PAULSEN, CAROL ANN 11/26/12 ELECTION-NOV-2012 General Fund Administration 136.00_
TOTAL: 136.00
PAZANDAK, JOSEPH 11/26/12 FURNACE FILTERS General Fund Municipal Buildings 19.31
11/26/12 JUL-OCT MILES General Fund Protective Inspections 947.10
11/26/12 2012 CCLD FALL SEMINAR 10/ General Fund Protective Inspections 85.00_
TOTAL: 1,051.41
PERA 11/20/12 P/R DEDUCTS-PERA General Fund NON-DEPARTMENTAL 2,948.44
11/20/12 P/R DEDUCTS-PERA General Fund Administration 536.59
11/20/12 P/R DEDUCTS-PERA General Fund Finance 380.87
11/20/12 P/R DEDUCTS-PERA General Fund Planning 405.78
11/20/12 P/R DEDUCTS-PERA General Fund Protective Inspections 224.33
11/20/12 P/R DEDUCTS-PERA General Fund City Engineer 113.74
11/20/12 P/R DEDUCTS-PERA General Fund Public Works 1,095.82
11/20/12 P/R DEDUCTS-PERA General Fund Park Maintenance 87.19
11/20/12 P/R DEDUCTS-PERA General Fund Recreation 68.56
11/20/12 P/R DEDUCTS-PERA Southshore Communi Senior Community Cente 14.86
11/20/12 P/R DEDUCTS-PERA Water Utility Water 247.02
11/20/12 P/R DEDUCTS-PERA Sanitary Sewer Uti Sewer 213.00
11/20/12 P/R DEDUCTS-PERA Recycling Utility Recycling 7.43
11/20/12 P/R DEDUCTS-PERA Stormwater Managem STORMWATER MANAGEMENT 25.00_
TOTAL: 6,368.63
PETRON KAREN 11/26/12 ELECTION NOV-2012 General Fund Administration 76.00_
TOTAL: 76.00
POLSON, CHRISTOPHER CHARLES 11/26/12 ELECTION-NOV-2012 General Fund Administration 80.00_
TOTAL: 80.00
RABY, JEAN ANN 11/26/12 ELECTION-NOV-2012 General Fund Administration 64.00_
TOTAL: 64.00
RABY, TEDDY T. 11/26/12 ELECTION-NOV-2012 General Fund Administration 72.00_
TOTAL: 72.00
SACCHET, LAURIE 11/26/12 ELECTION-NOV-2012 General Fund Administration 50.00_
TOTAL: 50.00
SCHMID, JOANNE H. 11/26/12 ELECTION-NOV-2012 General Fund Administration 64.00_
TOTAL: 64.00
SCHNEIDER, THOMAS E. 11/26/12 ELECTION-NOV-2012 General Fund Administration 56.00_
TOTAL: 56.00
SHOREWOOD TRUE VALUE 11/26/12 BATTERIES General Fund Public Works 16.11
11/26/12 PAINTS General Fund Public Works 5.94
11/26/12 SPRAYER General Fund Public Works 26.71
11/26/12 EPOXY General Fund Public Works 6.40_
TOTAL: 55.16
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 7
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
SIMCOX, LYNDA M. 11/26/12 ELECTION-NOV-2012 General Fund Administration 86.00_
TOTAL: 86.00
SKINNER, PHYLLIS 11/26/12 ELECTION-NOV-2012 General Fund Administration 56.00_
TOTAL: 56.00
SMELTZER, VIRGIL L. 11/26/12 ELECTION NOV 2012 General Fund Administration 156.00_
TOTAL: 156.00
SPANNAUS, BARBARA R. 11/26/12 ELECTION-NOV-2012 General Fund Administration 132.00_
TOTAL: 132.00
SPRINT 11/26/12 10/13-11/12 SVC Water Utility Water 62.28
11/26/12 10/13-11/12 SVC Sanitary Sewer Uti Sewer 62.29_
TOTAL: 124.57
STEIN, JANE F. 11/26/12 ELECTION-NOV-2012 General Fund Administration 198.00_
TOTAL: 198.00
THE MULCH STORE 11/26/12 TREE & BRUSH DISPOSAL General Fund Public Works 833.26_
TOTAL: 833.26
THOMPSON, KYLE B. 11/26/12 ELECTION-NOV-2012 General Fund Administration 127.50_
TOTAL: 127.50
TKDA ENGINEERS ARCHITECTS PLANNERS 11/26/12 VALLEYWD LN/CR REHAB PROJ Street Capital Imp Street Capt Improvemen 2,749.49_
TOTAL: 2,749.49
WELLS FARGO HEALTH BENEFIT SVCS 11/20/12 P/R DEDUCTS-HSA General Fund NON-DEPARTMENTAL 1,424.60_
TOTAL: 1,424.60
WHITE, SHERRY DAVIS 11/26/12 ELECTION-NOV-2012 General Fund Administration 84.00_
TOTAL: 84.00
WOODRUFF, RICHARD 11/26/12 LMC MEETING 11/14/12 General Fund Council 32.19_
TOTAL: 32.19
XCEL ENERGY 11/26/12 5655 MERRY LANE General Fund Park Maintenance 19.47_
TOTAL: 19.47
ZEE MEDICAL SERVICE 11/26/12 FIRST AID SUPPLIES General Fund Public Works 58.25
11/26/12 FIRST AID SUPPLIES General Fund Park Maintenance 43.80_
TOTAL: 102.05
**PAYROLL EXPENSES 11/19/2012 - 99/99/9999 General Fund Council 1,300.00
General Fund Administration 7,401.35
General Fund Finance 5,253.36
General Fund Planning 5,597.09
General Fund Protective Inspections 3,094.34
General Fund City Engineer 12,892.51
11-20-2012 04:38 PM C O U N C I L REPORT BY VENDOR- NOVEMBER 26, 2012 PAGE: 8
VENDOR SORT KEY DATE DESCRIPTION FUND DEPARTMENT AMOUNT_
**PAYROLL EXPENSES General Fund Public Works 15,114.54
General Fund Park Maintenance 1,202.65
General Fund Recreation 945.57
Southshore Communi Senior Community Cente 204.96
Water Utility Water 3,407.16
Sanitary Sewer Uti Sewer 2,937.75
Recycling Utility Recycling 102.48
Stormwater Managem STORMWATER MANAGEMENT 379.48_
TOTAL: 59,833.24
=============== FUND TOTALS ================
101 General Fund 114,411.89
402 Park Capital Improvements 103.50
404 Street Capital Improvemen 2,749.49
406 Trail Capital Outlay 103.50
490 Southshore Community Ctr. 2,292.43
601 Water Utility 5,922.52
611 Sanitary Sewer Utility 3,427.95
621 Recycling Utility 549.75
631 Stormwater ManagementUtil 1,210.52
880 Escrow Deposit Agency 9,445.00
--------------------------------------------
GRAND TOTAL: 140,216.55
--------------------------------------------
TOTAL PAGES: 8
November 12, 2012
Management, Honorable Mayor and City Council
City of Shorewood
Shorewood, Minnesota
To the appropriate representative of those charged with governance of the City of Shorewood(the City):
You have requested that we audit the financial statements of the City, which comprise the statements of the governmental
activities, the business-type activities, each major fund, and the aggregate remaining fund information, which collectively
comprise the basic financial statements of the Cityas of and for the year ending December 31, 2012, and the related notes to the
financial statements.
We are pleased to confirm our acceptance and understanding of the services we are to provide the City for the year ended
December31,2012 by means of this letter. Our audit will be conducted with the objective of our expressing an opinion on the
financial statements.
We will audit the financial statements of the governmental activities, the business-type activities, each major fund, and the
aggregate remaining fund information, which collectively comprise the basic financial statements of the City as of and for the
year ended December31,2012. Accounting standards generally accepted in the United States of America provide for certain
required supplementary information (RSI), such as management’s discussion and analysis (MD&A), to supplement the City’s
basic financial statements. Such information, although not a part of the basic financial statements, is required by the
Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic
financial statements in an appropriate operational, economic, or historical context. As part of our engagement, we will apply
certain limited procedures to the City’s RSI in accordance with auditing standards generally accepted in the United States of
America. These limited procedures will consist of inquiries of management regarding themethods of preparing the information
and comparing the information for consistency with management’s responses to our inquiries, the basic financial statements, and
other knowledge we obtained during our audit of the basic financial statements. We will not express an opinion or provide any
assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or
provide any assurance. The following RSI is required by generally accepted accounting principles(GAAP) andwill be subjected
to certain limited procedures, but will not be audited:
1)Management’s Discussion and Analysis
We have also been engaged to report on supplementary information other than RSI that accompanies the City’s financial
statements. We will subject the following supplementary information to the auditing procedures applied in our audit of the
financial statements and certain additional procedures, including comparing and reconciling such information directly to the
underlying accounting and other records used to prepare the financial statements or to the financial statements themselves, and
other additional procedures in accordance with auditing standards generally accepted in the United States of America and will
provide anopinion on it in relation to the financial statements as a whole:
1)Combining and Individual Fund Financial Statements and Schedules
2)Summary Financial Report –Revenues and Expenditures for General Operations -Governmental Funds
2012 ALG-CL-1.1GAAS Audit Engagement Letter
City of Shorewood
November 12, 2012
Page 2
The following other information accompanying the financial statements will not be subjected to the auditing procedures applied in
our audit of the financial statements, and our auditor’s report will not provide an opinion or any assurance. The Statistical Section
is required to be presented when a Comprehensive Annual Financial Report (CAFR) is issued.
1)Introductory Section
2)Statistical Section
Audit Objective
The objective of our audit is the expression ofopinions as to whether your basic financial statements are fairly presented, in all
material respects, in conformity with generally accepted accounting principles and to report on the fairness of the supplementary
information referred to in the second paragraph when considered in relation to the financial statements as a whole. Our audit will
be conducted in accordance with auditing standards generally accepted in the United States of America (GAAS); and will include
tests of the accounting records and other procedures we consider necessary to enable us to express such opinions.Those standards
require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from
material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the
financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the risks of material
misstatement of the financial statements, whether due to fraud or error. An audit also includes evaluating the appropriateness of
accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating
the overall presentation of the financial statements. Because of the inherent limitations of an audit, together with the inherent
limitations of internal control, an unavoidable risk that some material misstatements may not be detected exists, even thoughthe
audit is properly planned and performed in accordance with GAAS. In making our risk assessments, we consider internal control
relevant to the entity’s preparation and fair presentation of the financial statements in order to design audit procedures that are
appropriate in the circumstances but not for the purpose of expressing an opinion on the effectiveness of the entity’s internal
control. However, we will communicate to you in writing concerning any significant deficiencies or material weaknesses in
internal control relevant to the audit of the financial statements that we have identified during the audit. If our opinions on the
financial statements are other than unqualified (unmodified), we will discuss the reasons with you in advance. If, for any reason,
we are unable to complete the audit or are unable to form or have not formed opinions, we may decline to express opinions or to
issue a report as a result of this engagement.
Management Responsibilities
Our audit will be conducted on the basis that management [and, when appropriate, those charged with governance] acknowledge
and understand that they have responsibilityfor the basic financial statements and all accompanying information as well as all
representations contained therein. We will prepare a general ledger trial balance for use during the audit. Our preparation of the
trial balance will be limited to formatting information in the general ledger into a working trial balance. As part of the audit we
will prepare a draft of your financial statements and related notes. We will also use the financial statements to complete the
Office of the State Auditors’ City Reporting Form. We will also enter the current year capital asset transactions into our software
based on information you provide. You are also responsible for making all management decisions and performing all
management functions; for designating an individual with suitable skill, knowledge, or experience to oversee our assistance with
the preparation of your financial statements and related notes and any other nonattest services we provide; and for evaluating the
adequacy and results of those services and accepting responsibility for them.
Management is responsible for the design, implementation, and maintenance of internal control relevant to the preparation and
fair presentation of financial statements that are free from material misstatement, whether due to fraud or error,establishing and
maintaining effective internal controls, including monitoring ongoing activities; for the selection and application of accounting
principles; and for the fair presentation in the financial statements of the respective financial position of the governmental
activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate
remaining fund information of the Cityand the respective changes in financial position and where applicable, cash flows, in
conformity with U.S. generally accepted accounting principles.
2012 ALG-CL-1.1GAAS Audit Engagement Letter
City of Shorewood
November 12, 2012
Page 3
Management is also responsible for making all financial records and related information available to us and for the accuracy and
completeness of that information. You are also responsible for providing us with (1) access to all information of which you are
aware that is relevant to the preparation and fair presentation of the financial statements, (2) additional information that we may
request for the purpose of the audit, and (3) unrestricted access to persons within the government from whom we determine it
necessary to obtain audit evidence.As part of our audit process, we will request from [management and, when appropriate, those
charged with governance], written confirmation concerning representations made to us in connection with the audit.
Your responsibilities include adjusting the financial statements to correct material misstatements and confirming to us in the
written representation letter that the effects of any uncorrected misstatements aggregated by us during the current engagement and
pertaining to the latest period presented are immaterial, both individually and in the aggregate, to the financial statements taken as
a whole.
You are responsible for the design and implementation of programs and controls to prevent and detect fraud, and for informingus
about all known or suspected fraud or illegal acts affecting the government involving (1) management, (2) employees who have
significant roles in internal control, and (3) others where the fraud or illegal acts could have a material effect on the financial
statements. Your responsibilities include informing us of your knowledge of any allegations of fraud or suspected fraud affecting
the Cityreceived in communications from employees, former employees, regulators, or others. In addition, you are responsible
for identifying and ensuring that the Citycomplies with applicable laws and regulations.
You are responsible for the preparation of the supplementary information in conformity with U.S. generally accepted accounting
principles. You agree to include our report on the supplementary information in any document that contains and indicates that we
have reported on the supplementary information. You also agree to [include the audited financial statements with any presentation
of the supplementary information that includes our report thereon OR make theaudited financial statements readily available to
users of the supplementary information no later than the date the supplementary information is issued with our report thereon].
Your responsibilities include acknowledging to us in the representation letter that (1) you are responsible for presentation of the
supplementary information in accordance with GAAP; (2) that you believe the supplementary information, including its form and
content, is fairly presented in accordance with GAAP; (3) that the methods of measurement or presentation have not changed
from those used in the prior period (or, if they have changed, the reasons for such changes); and (4) you have disclosed to us any
significant assumptions or interpretations underlying the measurement or presentation of the supplementary information.
Professional standards require us to be independent with respect to the City in the performance of our services. Any discussions
that you have with personnel of our firm regarding employment could pose a threat to our independence. Therefore, we request
that you inform us prior to any such discussions so that we can implement appropriate safeguards to maintain our independence.
Audit Procedures -General
GAAS require that we communicate certain additional matters related to the conduct of our audit to those charged with
governance. Such matters include (1) our responsibilities under auditing standards generally accepted in the United States of
America; (2) an overview of the planned scope and timing of the audit;(3) significant findings from the audit, including, among
others: (a) the initial selection of and changes in significant accounting policies and their application; (b) the process used by
management in formulating particularly sensitive accounting estimates and the basis for our conclusions regarding the
reasonableness of those estimates; (c) significant difficulties that we encountered in dealing with management related to the
performance of the audit; (d) audit adjustments that could, in our judgment, either individually or in the aggregate, have a
significant effect on your financial reporting process and uncorrected misstatements of the financial statements that were
determined by management to be immaterial, both individually and in the aggregate, to the financial statements taken as a whole;
(e) any disagreements with management, whether or not satisfactorily resolved, about matters that individually or in the aggregate
could be significant to the financial statements or our report; (f) management representations; (g) our views about matters that
were the subject of management’s consultation with other accountants about auditing and accounting matters; (h) major issues
that were discussed with management in connection with the retention of our services, including, among other matters, any
discussions regarding the application of accounting principles and auditing standards, and if applicable, events or conditions
indicating there could be a substantial doubt about the entity's ability to continue as a going concern for a reasonable period of
time; and (4) other matters as considered necessary or required to be communicated under professional standards.
2012 ALG-CL-1.1GAAS Audit Engagement Letter
City of Shorewood
November 12, 2012
Page 4
An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements;
therefore, our audit will involve judgment about the number of transactions to be examined and the areas to be tested. An audit
also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting
estimates made by management, as well as evaluating the overall presentation of the financial statements. We will plan and
perform the audit to obtain reasonable rather than absolute assurance about whether the financial statements are free of material
misstatement, whether from (1) errors, (2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws
or governmental regulations that are attributable to the entity or to acts by management or employees acting on behalf of the City
Because of the inherent limitations of an audit, combined with the inherent limitations of internal control, and because we will not
perform a detailed examination of all transactions, there is a risk that material misstatementsmay exist and not be detected by us,
even though the audit is properly planned and performed in accordance with U.S. generally accepted auditing standards. In
addition, an audit is not designed to detect immaterial misstatements, or violations of laws or governmental regulations that do not
have a direct and material effect on the financial statements. However, we will inform the appropriate level of management ofany
material errors or any fraudulent financial reporting or misappropriation of assets that come to our attention. We will also inform
the appropriate level of management of any violations of laws or governmental regulations that come to our attention, unless
clearly inconsequential. Our responsibility as an auditor islimited to the period covered by our audit and does not extend to any
later periods for which we are not engaged as auditors.
Our procedures will include tests of documentary evidence supporting the transactions recorded in the accounts, and may include
tests of the physical existence of inventories, and direct confirmation of receivables and certain other assets and liabilities by
correspondence with selected individuals, funding sources, creditors, and financial institutions. We will request written
representations from your attorneys as part of the engagement, and they may bill you for responding to this inquiry. At the
conclusion of our audit, we will require certain written representations from you about the financial statements and related matters.
Audit Procedures-Internal Control
Our audit will include obtaining an understanding of the Cityand its environment, including internal control, sufficient to assess
the risks of material misstatement of the financial statements and to design the nature, timing, and extent of further audit
procedures. An audit is not designed to provide assurance oninternal control or to identify deficiencies in internal control.
However, during the audit, we will communicate to management and those charged with governance internal control related
matters that are required to be communicated under AICPA professionalstandards.
Audit Procedures -Compliance
As part of obtaining reasonable assurance about whether the financial statements are free of material misstatement, we will
perform tests of the City’s compliance with the provisions of applicable laws, regulations, contracts, and agreements. However,
the objective of our audit will not be to provide an opinion on overall compliance and we will not express such an opinion.
2012 ALG-CL-1.1GAAS Audit Engagement Letter
City of Shorewood
November 12, 2012
Page 5
Engagement Administration, Fees, and Other
We may from time to time, and depending on the circumstances, use third-party service providers in serving your account. We
may share confidential information about you with these service providers, but remain committed to maintaining the
confidentiality and security of your information. Accordingly, we maintain internal policies, procedures, and safeguards to protect
the confidentiality of your personal information. In addition, we will secure confidentiality agreements with all service providers
to maintain the confidentiality of your information and we will take reasonable precautions to determine that they have
appropriate procedures in place to prevent the unauthorized release of your confidential information to others. In the event that we
are unable to secure an appropriate confidentiality agreement, you will be asked to provide your consent prior to the sharing of
your confidential information with the third-party service provider. Furthermore, we will remain responsible for the work
provided by any such third-party service providers.
We understand that your employees will prepare all cash or other confirmations we request and will locate any documents
selected by us for testing.
The audit documentation for this engagement is the property of Abdo, Eick & Meyers, LLP and constitutes confidential
information. However, pursuant to authority given by law or regulation, we may be requested to make certain audit
documentation available to anyCognizant or Oversight Agency for Auditor its designee, a federal agency providing direct or
indirectfunding, or the U.S. Government Accountability Office for purposes of a quality review of the audit, to resolve audit
findings, or to carry out oversight responsibilities. We will notify you of any such request. If requested, access to such audit
documentation will be provided under the supervision of Abdo, Eick & Meyers, LLP personnel. Furthermore, upon request, we
may provide copies of selected audit documentation to the aforementioned parties. These parties may intend, or decide, to
distribute the copies or information contained therein to others, including other governmental agencies.
If you intend to publish or otherwise reproduce the financial statements and make reference to our firm, you agree to provideus
with printers' proofs or masters for our review and approval before printing. You also agree to provide us with a copy of the final
reproduced material for our approval before it is distributed.
We expect to begin our audit on approximately April 15, 2013and to issue our reports no later than June 30, 2013.Andrew K.
Berg, CPAis the engagement partner and is responsible for supervising the engagement and signing the report or authorizing
another individual to sign it.
Our fee for these services will beas follows:
Audit$26,050
2012Office of the State Auditor’s Reporting Form595
The fee is based on anticipated cooperation from your personnel and the assumption that unexpected circumstances will not be
encountered during the engagement. If significant additional time is necessary, we will discuss it with you and arrive at a new fee
before we incur the additional costs. Our invoices for these fees will be rendered each month as work progresses and are payable
on presentation. Amounts not paid within 30 days from the invoice date will be subject to a late payment charge of 1 percent per
month (12 percent per year). If for any reason the account is turned over for collections, additional fees will be added to cover
collections cost. In accordance with our Firm policies, work may be suspended if your account becomes 90 days or more overdue
and will not be resumed until your account is paid in full. If we elect to terminate our services for nonpayment, our engagement
will be deemed to have been completed upon written notification of termination, even if we have not completed your auditYou
will be obligated to compensate us for all time expended and to reimburse us for all out-of-pocket expenditures through the date
of termination.
2012 ALG-CL-1.1GAAS Audit Engagement Letter
City of Shorewood
November 12, 2012
Page 6
Except in the event of your failure to make a payment when due, in the event of a dispute related in any way to our services, our
Firm and you agree to discuss the dispute and, if necessary, to promptly mediate in a good faith effort to resolve. We will agree on
a mediator, but if we cannot, either of us may apply to a court having personal jurisdiction over the parties for appointment of a
mediator. We will share the mediator’s fees and expenses equally, but otherwise will bear our own attorneys’ fees and mediation
cost. Participation in such mediation shall be a condition to either of us initiating litigation. In order to allow time for the
mediation, any applicable statute of limitations shall be tolled for a period not to exceed 120 days from the date either of us first
requests in writing to mediate the dispute. The mediation shall be confidential in all respects, as allowed or required by law,
except our final settlement positions at mediation shall be admissible in litigation solely to determine the prevailing party’s
identify for purposes of the award of attorneys’ fees. In the event you fail to make a payment for services or to reimburse for
costs advanced by the Firm on your behalf, the Firm reserves the right to take all legally permissible action, including
commencement of litigation in lieu of mediation, and shall have the right to collect its costs, including reasonable attorney’s fees,
incurred in any such collection or litigation activities.
We appreciate the opportunity to be of service to the Cityand believe this letter accurately summarizes the significant terms of
our engagement. If you have any questions, please let us know. If you agree with the terms of our engagement as described in this
letter, please sign the enclosed copy and return it tous.
Sincerely,
ABDO, EICK & MEYERS, LLP
Certified Public Accountants & Consultants
Andrew K. Berg, CPA
Governmental ServicesPartner
RESPONSE:
This letter correctly sets forth the understanding of the City of Shorewood.
Signature:
Title:
2012 ALG-CL-1.1GAAS Audit Engagement Letter
10A
MEETING TYPE
Regular Meeting
City of Shorewood Council Meeting Item
Title / Subject: Selection of Financial Advisory Firm
Meeting Date: November 26, 2012
Prepared by: Bruce DeJong
Reviewed by: Bill Joynes
Attachment: Resolution
Policy Consideration:
The City should be represented by a financial advisor for bonding issues, financial studies, rate analyses,
and other financial services as the need arises.
Background:
The City Council solicited proposals for financial advisory services from three reputable firms in the
Minnesota market – Ehlers, Northland, and Springsted. The representatives from the firms discussed
their scope of services at the work session on November 13 and council members had an opportunity to
ask questions.
Based on the information presented, staff is comfortable working with each of the three firms and
believes that all are capable of handling any transactions or needs the city may have in the near future.
Staff is presenting this item with a blank for the name of the firm to be completed after discussion at the
meeting.
Financial or Budget Considerations:
A refunding of the water bonds outstanding could provide large savings over the current interest rates.
Options:
The City Council may choose to:
1.Select one of the firms as financial advisor; or
2.Ask staff to seek other proposals from other financial advisory firms.
Recommendation / Action Requested:
Staff recommends that the City Council select one of the firms based on their presentation and scope of
services.
Next Steps and Timelines:
If a financial advisory firm is selected, we will proceed with a call for sale for GO Water Refunding bonds
at the next City Council meeting.
Connection to Vision / Mission:
This process contributes to sound financial management by ensuring low cost financing for city services.
Mission Statement: The City of Shorewood is committed to providing residents quality public services, a
healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial
management through effective, efficient, and visionary leadership.
CITY OF SHOREWOOD, MINNESOTA
RESOLUTION NO. 12-
A RESOLUTION AUTHORIZING THE SELECTION OF
FINANCIAL ADVISORY FIRM
WHEREAS
, Shorewood City Council wishes to engage a financial advisor to evaluate
bond issues and refunding opportunities; and,
WHEREAS
, the City Council has heard presentations and received materials regarding
the qualifications of three reputable local financial advisory firms; and,
WHEREAS
, the Council has considered the fees and scope of services available from
each firm,
NOW, THEREFORE, BE IT RESOLVED
by the City Council of the City of
Shorewood selects _______________ to be its financial advisor to evaluate new bond issues and
refunding opportunities. This selection shall be in effect until revoked or modified by the City
Council at a subsequent official meeting.
th
ADOPTED BY THE CITY COUNCIL
of the City of Shorewood this 26 day of
November, 2012.
_________________________________
ATTEST: Christine Lizée, Mayor
_________________________________
William S. Joynes, Interim City Administrator
MEMORANDUM
Date:
November 21, 2012
To:
Mayor Lizee
Council Members
From:
Bruce DeJong, Finance Director
Re:
October, 2012 Monthly Budget Report
______________________________________________________________
The 2012 General Fund budget continues to track about where we would expect it to be at this
point in the year – a little over last year’s revenues and a little under last year’s expenditures.
Non-tax revenues at this point are 95.1% of the non-tax revenue budget, and that is without the
interest allocation. Overall expenditures are at 72.2% of budget which 4.8% higher than the
prior three year average of 67.4% but slightly lower than last year.
REVENUES
License and permit revenues are above last year, in fact exceeding budget for the full
year.
Charges for service exceed budget primarily because of unbudgeted tree sale revenues.
EXPENDITURES
Administration – The total expenditures are over budget because of salary allocations for
the Park Coordinator, the payment Mr. Heck received for accumulated leave time,
unbudgeted unemployment expense, and because budget allocations didn’t change when
salary increases were approve in January.
Finance – Materials and supplies are over budget because the annual support agreements
for the financial software came in higher than budgeted.
Municipal Buildings – The insurance costs always come at the beginning of the year and
they make up the majority of the budget. In prior years, the insurance wasn’t allocated
until the next year’s payment was made in November.
Public Works – about on track as most of the road repair materials have been purchased
at this point in the year.
Snow and Ice – lack of snow this past spring should keep this under budget.
Parks Maintenance – this could be over budget based on time allocations.
Recreation Programs – expenditures should be well under budget due to time allocations
and much less contractual service being used than was budgeted.
Please contact me or Mr. Joynes if you have any questions.
Attachment: October Monthly Budget Spreadsheet
Monthly Budget Report
October 31, 2012
YTDYTD2012% of 2012ExpectedVariance
2011OctoberAdoptedAnnual% of 2012(Negative)
Year to Date OverviewActual2012BudgetBudgetBudgetor Positive
REVENUE
Property Taxes 2,398,025 2,429,582 4,763,319 51.0%50.3%
Licenses and Permits 130,427 145,062 109,200 132.8%103.7%
Intergovernmental 70,592 35,401 70,401 50.3%100.0%
Charges for Service 36,581 53,038 35,075 151.2%91.3%
Fines and Forfeitures 28,641 50,670 54,500 93.0%78.7%
Miscellaneous 41,686 32,665 63,900 51.1%55.7%
Transfers from other funds - - 40,000 0.0%0.0%
TOTAL 2,705,952 2,746,418 5,136,395
53.5%52.0%$54,796.10
316,836 333,076 95.1%
EXPENDITURES
Council
Personnel 12,595 13,994 16,80083.3%
Materials and Supplies 684 233 3,0007.8%
Support and Services 56,416 50,277 86,31558.2%
Transfers 1,379 13,600
Total 71,074 64,504 119,71553.9%72.3%$22,089.85
Administration
Personnel 318,919 334,326 319,475104.6%
Materials and Supplies 13,639 15,486 24,09564.3%
Support and Services 33,210 55,154 39,935138.1%
Total 365,768 404,966 383,505105.6%81.5%($92,263.48)
Finance
Personnel 133,286 105,175 128,41681.9%
Materials and Supplies 7,786 7,932 7,300108.7%
Support and Services 12,585 7,406 9,15080.9%
Total 153,657 120,513 144,86683.2%77.3%($8,483.29)
Professional Services
175,855 177,097 199,32088.9%89.3%$962.20
Planning and Zoning
Personnel 136,153 156,306 170,66691.6%
Materials and Supplies 203 - 6550.0%
Support and Services 5,792 3,397 9,41236.1%
Total 142,148 159,703 180,73388.4%76.0%($22,345.92)
Municipal Building - City Hall
Materials and Supplies 43,052 32,338 16,500196.0%
Support and Services 101,703 146,092 157,75092.6%
Capital Outlay 1,534 2,441 -
Transfers - - 102,2000.0%
Total 146,289 180,871 276,45065.4%28.7%($101,622.00)
Police
Support Services 831,361 825,185 989,08583.4%
Capital (Public Safety Bldg) 230,068 225,132 225,132100.0%
Total 1,061,429 1,050,317 1,214,21786.5%86.7%$2,004.40
Fire
Support Services 337,131 331,987 332,80599.8%
Capital (Public Safety Bldg) 270,697 277,906 277,906100.0%
Total 607,828 609,893 610,71199.9%99.7%($1,217.70)
Inspections
Personnel 98,981 102,342 118,04986.7%
Materials and Supplies 154 - 2000.0%
Support and Services 2,069 4,443 5,45081.5%
Total 101,204 106,785 123,69986.3%79.0%($9,062.79)
City Engineer
Personnel 79,920 70,601 90,87277.7%
Materials and Supplies 409 144 20072.0%
Support and Services 10,811 12,106 11,960101.2%
Total 91,140 82,851 103,03280.4%71.3%($9,354.84)
Public Works Service
Personnel 322,411 356,948 418,63385.3%
Materials and Supplies 194,968 100,976 172,57558.5%
Support and Services 93,165 102,123 134,43976.0%
Transfers - - 750,0000.0%
Total 610,544 560,047 1,475,64738.0%53.2%$224,533.72
Snow and Ice
Personnel 33,938 19,163 55,02434.8%
Materials and Supplies 14,837 10,247 45,11722.7%
Total 48,775 29,410 100,14129.4%46.3%$16,988.66
Parks Maintenance
Personnel 126,699 92,917 100,98892.0%
Materials and Supplies 15,490 15,725 18,30085.9%
Support and Services 72,500 30,157 26,500113.8%
Total 214,689 138,799 145,78895.2%77.0%($26,542.24)
Recreation Programs
Personnel 32,194 68,35647.1%
Materials and Supplies 1,171 1,50078.1%
Support and Services 14,365 34,15042.1%
Transfers - 42,0000.0%
Total - 47,730 146,00632.7%77.0%$64,694.62
Unallocated - - -0.0%
Total Expenditures 5,223,830
3,790,400 3,733,48672.2%67.4%
Net Revenue less Expenditures (87,435)
(1,084,448) (987,068)
Note: The balanced budget includes the use of $87,435 of fund balance in Transfers in the Revenue section.