The URL can be used to link to this page

Home My WebLink About2013 03-19 CCPCity of Gem Lake, MN City Council Meeting March 19, 2013 Call To Order of City Council Meeting — By Mayor Uzpen at 7:_P.M. Call of Roll Uzpen Artig-Swomley Lindner Others in Attendance: Sign-up Sheet Approval of City Council Minutes and Agenda • City Council Agenda for this meeting (Accept Agenda) • Minutes of the City Council Meeting for February Committee Reports • None Old Business • News Letter Ideas Public Hearing • None New Business Kuny Bosak • Claims for February 2013 • Monthly Financial Reports • Presentations from the public, five minutes maximum presentation • Open Items for the Council Members to bring up. Future Council Meetings • Workshop Meeting, April 8 at 7:00 P.M. • Next City Council Meeting, April 16 at 7:00 P.M. Adjournment • The meeting adjourned at Claims For Payment CITY OF GEM LAKE Period Ending. 3/19/2013 Signatures Approving Claims Date of Approval Robert Uzpen, Mayor Jim Lindner, Council Gretchen Artig-Swomley, Council Faith Kuny, Council Rick Bosak, Council Tom Kelly, Finance Officer Fund Totals 1 1 $ Amount General Fund 19,588.99 Parks & Playgrounds 0.00 2004 Debt Service Fund 0.00 2006 Debt Service Fund 0.00 2007 Debt Service Fund 0.00 City Hall Construction Fund 0.00 Scheuneman Road Improvements 0.00 Hoffman Road Improvements 0.00 Sewer Fund 4.35 Investment Trust Fund 0.00 Total All Funds 19,593.34 Included above are the pre -paid checks paid on FEBRUARY 28, 2013 317113 at 12:03:31.70 Page: 1 City of Gem Lake Check Register - Prepaid Checks For the Period From Feb 28, 2013 to Feb 28, 2013 Filter Criteria includes: Report order is by Check Number. Check # Date Payee Amount 8801 2/28/13 Centuryl-ink 107.08 8802 2128/13 Julie Newkirk 200.00 8803 2/28/13 Press Publications 14.55 8804 2/28113 SEH 292.26 Total 613.89 3/7113 at 12:07:29.43 Page: 1 City of Gem Lake Check Register For the Period From Mar 19, 2013 to Mar 19, 2013 Filter Criteria includes: Report order is by Check Number. Check # Date Payee Amount 3/19/13 Sage Software Inc. 795.74 8805 3/19113 Gretchen Artig-Swomley 190.24 8806 3/19/13 Faith A. Kuny 190.24 8807 3/19/13 Robert L. Uzpen Jr 375,60 8808 3/19/13 James A. Lindner 190.24 8809 3/19/13 Rick Bosak 190.24 8810 3/19/13 Clifton LarsonAllen LLP 2,800.00 8811 3/19/13 FedEx Office 221.53 8812 3/19113 Kelly & Lemmons, PA 926.75 8813 3/19/13 Metropolitan Council 1,340,83 8814 3119113 Ramsey County 222.65 8815 3/19/13 T.A. Schifsky & Sons, Inc. 6,726.88 8816 3/19/13 VOID 8817 3/19/13 Waste Management of WI -MN 882.46 8818 3/19/13 City of White Bear Lake 1,441.91 8819 3/19/13 White Bear Township 1,897.26 8820 3/19113 VOID 8821 3/19113 Xcel Energy 582.53 8822 3/19/13 Gopher State One Call 4.35 Total 18,979.45 N N N �1 W s s s s s s N N F3 N CD C`O CD CO CD CD OD OD OD C`D W W W W W W W W W W W Do m 03 00 co co 00 00 OD co00 (b s s co OO OD 00 s co p co O 00 O OD O (Jl A W N 1 O ? W N s 8 1 1 1 1 1 1 1 1 1 J 1 1 1 .1 1 1 1 1 0 1 0 J J 1 0 0 0 1 1 1 1 0000000000000000 00 00 00 00 00 00 00 00 00 oc 0000000000000000 00 00 00 00 00 00 00 00 00 01 41�4--�,4141��, -�,IL-11Ja� -'-�� 1k sA _.� 1A Ll. - 4t , sA W WWsWWWWWWWCWWW sW OssN Os 0— 0" 0" O— OO 21 Os O- (C w0 —0 s(31 Co s1CO s sNNsN NsNs—N NssN sN —N N�sN NsNsO O O O sO O O O O _s O O OO O? O n000000000000 0 00000c N A? N N AP N N A A A N N? W w w w N O 0 0 N 00 0 Ch N 0 0 0 CJ7 N 0 0 s O CJ1 O O CT w N C w AAOCnAAAO(PAAA004A -! Cb A N — N 1 N — 4 wW N)CO mom N)W w !) owwtN xm j-�:D T""Tl TC- 0m UJL -0-0 L C-)= U1C DDr:3DDD�3DDDDDD1 w v m 0> mz m e c 1 j= c f- ZNrrZA W rrZNZrrO ;i7 .� m Z O r t. in m (D (_O -U D ;sm�p—cm—I cn 0 r- go N) X N Z N cn r z1 = m. �Zw�R�Zww�RoZwZ�Row < cn o N rD p0 O o c n row r0 0 Dpz DOzz DOZO Dz o D m w o �k 4' �_mmp m( z 0 z 00 z 0 z0 n m 3 N CD m zi D m m D c T c o O �� a o� �= o m = 0 =� Z o.� n m o� v -n g w U) m y � n O 00 O 0 � �m m r--n D w g N m DO -00 r s m S o m > m � z �� w n m G� w D;o m _ W Z N m 0 O cn w N W N 000DNNAAANNAAWNN0 N ? N N O CNO s O O 1 co00DN N O � O N A O V AO(D0N't,oGoN�CO O O CJi N O O N N N O O N O N ON O 00 V CA O N CT O O W 0 0 0 J O O CJI Cn W 0 0(J1 O co 0 cn Cn W Cn w O (n CT O s N N O CA O N A O .-4 JA f n co CVT W O m CA O 000 A T Cl) N 7. N 0 n S c n CL CD �T CD U O O D o n n O C CS O 3 CD n 77 c 3 r m o CD � O p w ti CD -0 rt n 9 CD D C1 °o 9CL o, p0 O w � a. O N -41 Q cD G) 00(D 3 O_ 03 W ` O (D O = 1 3 fl1 � y CD N v� o Q w D O C 7 M � 0 O Q M D O C 7 T i W J W i W i W W W W oo co �j N 00 00 00 OD 0 co Cl? cD 00 O0 00 CC) 00 07 00 —1 O) 0) [n i i .-i 1 J i i i i J i i 1 i i i i i i i O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000 O O O O 80 0 0 0 0 0 O O O O O O O O O O O O O O O 000 O O O O O O O -N (D (D (D fD (D (D ai 4N. CD A 07 O 1 N N O CO i O O O A A O O O O O O N N O 0 0 0 0 0 0 O O O 000 O O N 0 0 000 O O O O O O N N O O O i 0 0 0 00 000 O O CT W W i W W W W WW N CbOW N0 CO Du (n CD W i — C)MU1MW000 W (DOO ?.A O (,)TI o m X22 < O :-p-00m-uc>w-0m�0 O nK� DD K D < -4Cn O D NmD �oD�_Dw�- m IUE—O W;K 0 mm 3�-I 0 �w m �m m0>> jC7(7�cm mfnmcn��°�—ID�G�m� c�22 ?_0o �22 -3 00 N 0 �� cND� O 0,ZOj�Z� z�� W W (o W W 0C) n IZTI T.T.zG� Ca N m (D m �� cm 90 m D N� � cnwoo � g cam n v -- m =3 nm w cn W) ram- m m7N x w rmm w �m —CE 3 m 7 �mz J 0 me w Q0 g2� zX O� z m NN �� Ul A W �Oi-- .4W :�OAUtNN00 A V W U1(D w0NOm Un-4m0U7000 -4 W� U1 00 U1 U1 OD OMUIOOOM0O0000 C)Ul 00 U1 DD � A Ut O A 00 N 00 CD c A i N W co CW31 Cl) � T d CD n (SD a O CD w Y. O U O O D o- n O Ot C O- .O. � Ci v m O 77 c 3 a m CD r m mO v N 0 -Oi (D Q� CD 7 I 0 O. d m Q. (A T , O 00 m B Q.Iz m N h a' rD G) M cD CO o :3' r wow O � 3 v m N o� o � 3 T C 3 CD G!. :i D 3 O C W W d N C3 00 0 V 00 W d (C CD N M L Ccc C O d "r J N N cia LE LL OLL L 'Fu C ao m �-D L C LOC' L y 0 O 0 (D ca 0 Y U a) L U N N S U C m U L G 3 O E Q W Q U W 2 U m Cnl V O m E O u c a� U) N O E Q a x a m a N N N N (0 LO m 0 m m r- Cl) r r �- e- N N I` N (V 0) i r rco ti ti o N N N N M �- r M r r 00 0 0 0 0 0 0 0 0 0 0 0 0 (O (D 6) N Cl) N N Lo N 0 0 0 0 0 0 O O O O O 0 M O 0 r O O N N U) N N M m m m m ca ccaa V) V) U) cn T E 0 Cl) U)c a) C M C N c M Q 7 � J o 2 L�_ Y J Q NOS �O� .� -000 EO°) Y00 U00� COP LO co 0Or LL00M 000� mOpM (a00� �00c) �oOM cm LO M M V' r0 cli 00 0 0 0 0 0 0 M M r 0 0 Cn M r CM M co 2 ii CITY OF GEM LAKE CASH AND INVESTMENT BALANCE STATEMENT As of 02/28/13 Fiscal Year: 2013 Cash and Investments Balance Balance Name of Fund 2/1/2013 Receipts Disbursements 2/28/2013 General Fund $360,427.15 $15,230.60 $24,529.59 $351,128.16 Parks and Playgrounds $38,323.64 $0.00 $0.00 $38,323.64 2004 Debt Service Fund $68,170.58 $0.00 $0.00 $68,170.58 2006 Debt Service Fund $96,896.88 $0.00 $0.00 $96,896.88 2007 Capital Improvement Bonds $49,281.62 $0.00 $0.00 $49,281.62 Street Improvement $130,076.89 $0.00 $0.00 $130,076.89 Scheuneman Road Improvemetns ($39,508.27) $0.00 $0.00 ($39,508.27) Hoffman Road Improvements $25,705.00 $0.00 $0.00 $25,705.00 Sewer Enterprise Fund $341,079.64 $1,824.92 $1,476.98 $341,427.58 Investment Trust Fund $2.02 $0.94 $0.00 $2.96 $1,070,455.15 $17,056.46 $26,006.57 $1,061,505.04 Premier Checking $11 1,043.41 Premier CD's $0.00 Wells Fargo Investments $937,680.50 Wells Fargo Money Market $12,781.13 $1,061,505.04 NOTE: Cash balance in the Investment Trust Fund represents the interest received in Jan & Feb 2013. Interest will be distributed to the various funds quarterly based on average cash balance. MATURE DATE PURCH DATE BANK/BROKER TYPE FEBRUARY CASH & INVESTMENTS NAME Cusip#. YIELD INT. RATE # DAYS AS OF 2/28/2013 PREMIER BANK CHK GENERAL FUND 6005590 0.05% 0.05010 30 $111.043.41 WELLS FARGO MMKT PRIME INVESTMENT FUND 12970216 0.01% 0.01% 30 $12,781.13 1/2/14 114113 WELLS FARGO CD BEAL BANK USA 07370VUH9 0.55% 0.55% 363 S245.000.00 12/31/14 12/31/12 WELLS FARGO CO SAFRA NATIONAL BANK 78658AAY4 0,50% 0.50% 730 $140,000.00 10119/16 10/19/12 WELLS FARGO CD GE CAPITAL BANK 3616OXX44 1.35% 1.35% 1461 $245.000.00 10/17/17 10/17/12 WELLS FARGO CD GOLDMAN SACHS 38143AN27 1.55% 1.55% 1826 $100.000.00 4/4/22 4/4112 WELLS FARGO CD GOLDMAN SACHS 38143ANZ4 2.90% 2.90% 3650 $40,000.00 2/1123 8/12/11 WELLS FARGO GO BOND SHORVIEW MINN BLD BONDS 3.20% 4.80% 4188 $167.680.50 1.26% 1.46% 1,535 $1,061,505.04 City of Gem Lake GENERAL FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Mnth YTD YTD YTD ]3ttdpe Actual Variancu %Comolete Budget Actual Variant: °oCam let REVENUES Property Taxes Current Property Taxes $ 199,606.00 $ 0.00 199,606.00 0.00 $ 199,606.00 $ 0.00 199,606.00 0.00 Fiscal Disparity Taxes 4,636.00 0.00 4,636.00 0.00 4,636.00 0.00 4,636,00 0.00 Licenses and Permits General Business Licenses 1,700.00 500.00 1,200.00 29.41 1,700.00 500.00 1,200.00 29,41 On -Sale Liquor License 4,400.00 2,200,00 2,200.00 50.00 4,400.00 2,200.00 2,200.00 50.00 Tobacco License 500.00 500.00 0.00 100,00 500.00 500.00 0.00 100.00 Charitable Gambling License 500.00 500.00 0.00 100.00 500.00 500.00 0.00 100.OD Contractor License 500.00 200.00 300.00 40.00 500.00 20000 300.00 40.00 Building Permits 2,000.00 2,673.75 (673.75) 133.69 2,000,00 2,673.75 (673.75) 133.69 Plumbing Permits 350.00 355.00 (5.00) 101.43 350.00 355.00 (5.00) 101.43 Mechanical Permits 250.00 215.00 35.00 86.00 250.00 215.00 35.00 86.00 Electrical Permits 500.00 205.00 295.00 41.00 500.00 205.00 295,00 41.00 NPDES Permit 0.00 100.00 (100,00). 0.00 0.00 100.00 (100.00) 0.00 Fire Marshall Inspection 2,250.00 0.00 2.250.00 0.00 2,250.00 0.00 2,25000 0.00 Septic Inspection Fee 3,000.00 0.00 3,000.00 0.00 3,000.00 0.00 3,000.00 0.00 State Permit Charge 100.00 235.50 (135.50) 235.50 100.00 235.50 (135.50) 235.50 Administration Fee 350.00 0,00 350.00 0.00 350.00 0.00 350.00 0.00 Sewer Contractor License 0.00 300,00 (300.00) 0.00 0.00 300,00 (300.00) 0.00 Dog Licenses 200.00 0.00 200.00 0.00 200,00 0.00 200.00 0.00 Intergovernmental Revenues County Grants & Aids 0.00 34.48 (34.48) 0.00 0.00 34.48 (34.48) 0.00 SCORE Recycling Grant 831.00 0.00 831.00 0.00 831.00 0.00 831.00 0.00 Cable TV Franchise Fees 4,000.00 0.00 4,000.00 0.00 4,000.00 0.00 4,000,00 0.00 Police State Aid 3,642.00 0.00 3,642.00 0.00 3,642.00 0.00 3,642.00 0.00 Charges for Services Planning Fees 0.00 100.00 (100.00) 0.00 0,00 100.00 (100.00) 000 Plan Review 400.00 1,737.94 (1,337.94) 434.49 400.00 1,737.94 (1,337.94) 434.49 Investmenr Admin Charge 339.00 0.00 339.00 0.00 339.00 0.00 339.00 000 Fines and Forfeits Fines 2,000.00 140,00 1,860,00 7.00 2,000.00 14000 1,860.00 7.00 Miscellaneous Interest Earnings 3,125.00 0.00 3,125.00 0.00 3,125.00 0.00 3,125.00 0.00 Charitable Gambling Contributi 3,000.00 0.00 3,000.00 0.00 3,000.00 0.00 3,000.00 0,00 Miscellaneous 400.00 0.00 400.00 0.00 400.00 0.00 400.00 0.00 Insurance Policy Dividends 300.00 0.00 300.00 0.00 300.00 0.00 300.00 0.00 Facility Rental 22,000.00 0.00 22,000.00 0.00 22,000.00 0.00 22,000.00 0,00 Total Revenues 260,879.00 9,996,67 250,882.33 3,83 260,879.00 9,996.67 250,882.33 3.83 EXPENDITURES City Council Wages and Salaries 5,356.00 0.00 5,356.00 0.00 5,356.00 0.00 5,356,00 0.00 Employer Paid Insurance 410.00 0.00 410.00 0.00 410.00 0.00 410.OD 0.00 Conference Registrations 1,000.00 0.00 1,000.00 0.00 1,000.00 0.00 1,000.00 0.00 Council Contingency 26,498.00 0.00 26,498,00 0.00 26,498.00 0.00 26,499,00 0.00 Elections Administration 6,000.00 O.OD 6,000.00 0.00 6,000,00 0.00 6,000.00 0.00 Repairs & Maint - Contractual 450.00 0.00 450.00 0.00 450.00 0.00 450.00 0.00 Financial Administration Auditing Services 8,480.00 000 8,480.00 0,00 8,480.00 0.00 8,480.00 0.00 Financial Services J 30,000.00 1,02850 28,971 50 3.43 30,000.00 1,029.50 28,971.50 343 Computer Services 600.00 1,17000 (570.00) 195.00 600.00 1,170.00 (570.00) 195.00 3/12/2013 at B:54 AM City of Gem Lake GENERAL FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Mnth YTD YTD YTD Budge Actual Variance % .om Iyle Budge I ctual Variance %Cnmole!S Legal Services Prosecution 2,000.00 125.00 1,875.00 6.25 2,000.00 125.00 1,875.00 6.25 Legal 12,000.00 1,528.50 10,471.50 1274 12,000 00 1,528.50 10,471.50 12.74 Clerk/General Government Wages and Salaries 12,000.00 0.00 12,000.00 0.00 12,000.00 0,00 12,000LO 0.00 Office Supplies 2,000.00 175.87 1,824.13 8.79 2,000.00 175.87 1,824.13 8.79 Postage 1,500.00 0.45 1,499.55 0.03 1,500.00 0.45 1,499.55 0.03 Administration 4,000.00 342.00 3,658.00 8.55 4,000.00 342.00 3,658.00 8.55 Miscellaneous 200.00 000 200.00 0.00 200.00 0.00 200.00 0.00 Web Site 1,000,00 300.00 700.00 30.00 1,000,00 300.00 700.00 30.00 Mileage 250,00 8.47 241.53 3.39 250.00 8,47 241,53 3,39 Recording Secretary 2.600.00 400.00 2,200DO 15.38 2,600.00 400.00 2,200.00 15.38 Computer Services 1,500.00 0,00 1,500.00 0.00 1,500.00 0.00 1,500.00 0.00 Legal Notice Publication 1,000.00 (36.36) 1,036.36 (3.64) 1,000.00 (36.36) 1,036.36 (3.64) Newsletter/Public Relations 2,500.00 0.00 2,500.00 0.00 2,500.00 0.00 2,500.00 0.00 General Liability Insurance 1,800.00 0.00 1,800.00 0.00 1,800.00 0.00 1,800.00 0.00 Vehicle Insurance 65.00 0.00 65,00 0.00 65.00 0.00 65,00 0.00 Public Officials Liablithy 150.00 0.00 150.00 0.00 150.00 0.00 150.00 0.00 Recycling Collection 9,000.00 1,720.90 7,279.10 19.12 9,000.00 1,720,90 7,279.10 19.12 League of MN Cities 525.00 0.00 525.00 0.00 525.00 0.00 525.00 0.00 RCLLG 125.00 125.00 0.00 100.00 125-00 125.00 0.00 100.00 Subscriptions 20.00 0.00 20.00 0.00 20.00 0.00 20.00 000 Gambling Distributions 3,000.00 0,00 3,000,00 0.00 3,000.00 0.00 3,000.00 0.00 Planning and Zoning Professional Services 30.00 0.00 30.00 0.00 30.00 0.00 30.00 0,00 Engineering 1,000.00 292.26 707.74 29,23 1,000.00 292,26 707.74 29.23 Administration 3,000.00 (39.00) 3,039.00 (1.30) 3,000.00 (39.00) 3,039.00 (1.30) Recording Secretary 1,500.00 0.00 1.500.00 0.00 1,500.00 0.00 1,500.00 0.00 1 Heritage Hall Operating Supplies 1,500.00 0.00 1,500.00 0.00 1,500.00 0.00 1,500.00 0.00 Professional Services 2,000.00 67,00 1,933.00 3.35 2,000.00 67.00 1,933.00 3.35 Contract Services 1,500.00 0.00 1,500.00 0.00 1,500.00 0.00 1,500.00 0.00 Telephone 1,500.00 214.16 1,285.84 14.28 1,500.00 214,16 1,285,84 14.28 Property Insurance 750.00 0.00 750.00 0.00 750.00 0.00 750.00 0.00 Electric Service 3,000.00 345.83 2,654.17 11.53 3,000.00 345.83 2,654.17 11.53 Gas Service 1,500.00 272.09 1,227.91 18.14 1,500.00 272.09 1.227.91 18.14 Water/Sewer Utilities 600.00 0.00 600.00 0.00 600.00 0.00 600.00 000 Repairs & Maint- Contractual 1,600.00 247.50 1,352.50 15.47 1,600.00 247.50 1,352.50 15.47 Reparis & Maint - Building 2,000.00 0.00 2,000.00 0.00 2,000,00 0.00 2,000.00 0.00 Buildings & Structures 500.00 0.00 500.00 0.00 500.00 0.00 500.00 0.00 Police Regular Law Enforcement 78,525,00 15,102.96 63,422.04 19.23 78,525,00 15,102.96 63,422.04 1923 Special Law Enforcement 5,910.00 0.00 5,910,00 0.00 5,910,00 0.00 5,910.00 000 Dispatch Costs 2,675.00 222.65 2,452.35 8.32 2,675.00 222.65 2,452.35 832 Fire Fire Services 13,825.00 2,243.50 11,581.50 16.23 13,825.00 2,243.50 11,581.50 16.23 Fire Marshall Service 3,850,00 640.32 3,209.68 16.63 3,850.00 640.32 3,209.68 16.63 Animal Control Animal Removal 100.00 0.00 100.00 0.00 100.00 0.00 100.00 0.00 Animal Enforcement 300.00 0.00 300.00 0.00 300.00 0.00 300,00 000 Building Inpsection Computer Services 0.00 757.77 (757.77) 0.00 0.00 757.77 (757.77) 0.00 Building Inspections 5,00000 120.00 4,880.00 2.40 5,000.00 120,00 4,880.00 2.40 Building Secretary I,000.DO 0,00 1,000.00 0.00 1,000.00 000 1,000,00 0.00 Computer Services 800.00 0.00 800.00 0.00 800.00 0.00 800.00 0.00 Road Maintenance Signs, Sign Repair Materials 500,00 0.00 500.00 0.00 500.00 0.00 500.00 0,00 J Engineering 4,000.00 0.00 4,000.00 0.00 4,000.00 0.00 4,000.00 0.00 NPDES Administration 10,000.00 0.00 10,000.00 0.00 10,000.00 0.00 10,000.00 0.00 311212013 at 8:54 AM City of Gem Lake GENERALFUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Mnth YTD YTD YTD Budect Actual Variance %Complete Budge Actual Variance %Comnlele Street Lights 1,200.00 9616 1,103.84 8.01 1,200.00 96.16 1,103.94 8.01 ROW Maintenance 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 Street Repairs 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 Dues & Subscriptons 50.00 39.58 10.42 79.16 50.00 39.58 10.42 79.16 lee and Snow Removal Salt and Sand 10,000.00 2,592.00 7,408.00 25.92 10,000.00 2,592.00 7,408.00 2592 Sales Tax 600.00 155.93 444.07 25.99 600.00 t55.93 444.07 25.99 Repairs&Maint- Contractual 1,000.00 0.00 1,000.00 0.00 1,000.00 0.00 1,000.00 0.00 Snow Plowing 10,000.00 5,488.53 4,511.47 54.89 10,000.00 5,488.53 4,511.47 54.89 Otber Financing Uses Total Expenditures 311,344.00 35,747.57 275,596.43 11.48 311,344.00 35,747.57 275 596.43 11.48 Excess Rev Over (Under) Exp (5 50 465.00) (S 25.750.90) (24.714.10) 51.03 ($ 50,465.00) ($ 25,750.90) (24,714.10) 51.03 3/1212013 at 8:54 AM City of Gem Lake PARKS AND PLAYGROUNDS FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Moth Curr Mnth YTD YTD YTD u e Actual Variance %Complete Budget Actual Variance %Complete REVENUES Interest Earnings $ 350.00 $ 0.00 (350.00) 0.00 $ 350.00 $ 0.00 350.00 0.00 Total Revenues 350.00 0.00 (350,00) 0.00 350.00 0.00 350.00 0.00 EXPENDITURES Total Expenditures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Excess Rev Over (Under) Exp $ 350.00 $ 000 (350.00) 0.00 $ 350.00 $ 0.00 350.00 0,00 3/12/2013 at 8:55 AM City of Gem Lake 2004 DEBT SERVICE FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Moth Curr Mnth Curr Mnth YTD YTD YTD Budge Actual Variance % Complete Budget Actual Variance %Complete REVENUES Current Special Assessments $ 40,641.00 $ 0.00 (40,641.00) 0.00 $ 40,641.00 $ 0.00 40,641.00 0.00 Penalties & Interest 6,096.00 0.00 (6,096 00) 0.00 6,096.00 0.00 6,096.00 0.00 Interest Earnings 749.00 0.00 (749.00) 0.00 749.00 0.00 749.00 0.00 Total Revenues 47,486.00 000 147,486.00) 0.00 47,486.00 0.00 47.486.00 0.00 EXPENDITURES Principal 62.710.00 31,068.00 (31,642.00) 49.54 62,710.00 31,068.00 31,642.00 49.54 Interest 7,932.00 4,253.17 (3,678,83) 53.62 7,932.00 4,253.17 3,678.83 53.62 Fiscal Agent Fees 50.00 000 (50.00) 0.00 50.00 0.00 50.00 000 Total Expenditures 70,692.00 35,321 17 (35,370.83) 49.96 70,69100 35,321.17 35.370.83 49.96 Excess Rev Over (Under) Exp (S 23 206.00) (S 35,321.17) (12.1 15.17) 152.21 ($ 23,206,00) ($ 35,31-1.17) 12.1 15.17 15221 3112/2013 at 8:57 AM �1 City of Gem Lake 2006 DEBT SERVICE FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Mnth YTD YTD YTD Rudeet Actual Variance %Comnletc Bum Actual Variance %Complete REVENUES Current Special Assessments $ 14,600.00 $ 0.00 (14,600.00) 0.00 $ 14,600.00 $ 0.00 14,600.00 000 Penal ites & Interest 3,445.00 0.00 (3,445,00) 000 3,445.00 0.00 3,445.00 000 Interest Earnings 1,073.00 0.00 (1,073.00) 0.00 1,073.00 0.00 1,073.00 000 Total Revenues 19,118,00 0.00 (19.118.00) 0.00 19,119.00 0.00 19,118.00 0.00 EXPENDITURES Principal 25,000.00 25,000.00 0.00 100.00 25,000.00 25,000.00 0.00 100.00 Interest 5,267.00 2,902.50 (2,364.50) 55.11 5,267.00 2,902.50 2,364.50 55.11 Fiscal Agent Fees 50.00 000 (50,00) 0.00 50.00 0.00 50,00 0.00 Total Expenditures 30,317.00 27,902.50 (2,414.50) 9204 30,317 00 27,902.50 2,414.50 9204 Excess Rev Over (Under) Exp (S 11.199.00) (S 27 902.50) (16.703 50) 249.15 ($ 11,199.00) ($ 27,902.50) 16,703 50 249.15 311212013 at 8:58 AM City of Gem Lake 2007 DEBT SERVICE FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curt Mntli Curr Mnth Curr Mnth YTD YTD YTD Budw Actual Variance %Comnletc Bud eu Aglud Variance %Comnleta REVENUES Current Property Taxes $ 50,700.00 $ 0.00 (50,700,00) 0.00 $ 50,700.00 $ 0.00 50,700.00 0.00 lnlerestEamings 520.00 0.00 (520.00) 0.00 520,00 000 520.00 0.00 Total Revenues 51.220.00 000 (51,22000) 0.00 51,220.00 0,00 51,220.00 0.00 F,RPF.NDITURES Principal 15,000,00 15,000.00 0.00 100.00 15,000.00 15,000.00 0.00 100.00 Interest 33,555.00 16,927.50 (16,627.50) 50.45 33,555.00 16,927.50 16,627.50 50.45 Fiscal Agent Fees 550.00 550.00 000 100.00 550.00 550.00 0.00 100.00 Total Expenditures 49.105.00 32.477 SO (16,627.50) 66.14 49,105.00 32,477.50 16,627.50 66.14 Excess Rev Over (Under) Exp S 2,115.00 (S 32,477 50) (34,592.50) (1,535.58) S 2,115.00 (S 32.477.50) 34,592.50 (1,535.58) 3/1212013 at 9:00 AM REVENUES Interest Earnings Total Revenues EXPENDITI)RF.S Construction Total Expenditures Excess Rev Over (Under) Exp City of Gem Lake IMPROVEMENTFUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Moth YTD YTD YTD Budge Actual V ra inncc %Complete Budeet Actual Variance % Comnletc $ 912.00 $ 0.00 (912,00) 0.00 $ 912.00 $ 0.00 912.00 0.00 912.00 0.00 (912.00) 0.00 912.00 0.00 912.00 0.00 45,000.00 0.00 (45,000.00) 45,000.00 0.00 (45,000.00) ($ 44,098 00) $ 0.00 44.088.00 0.00 45,000.00 0.00 45,000.00 0.00 0.00 45,000.00 0.00 45,000.00 0.00 0.00 ($ 44,088.00) $ 0.00 (44,088.00) 0.00 3/1212013 at 8:01 AM City of Gem Lake SCHEUNEMAN ROAD IMPROVEMENTS Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Mnth YTD YTD YTD Budget Actual Variance %Comnlctc Budget Actual Varian o I REVENUES Current Special Assessments $ 16,285.00 $ 0.00 (16,285.00) 0.00 $ 16,285.00 $ 0.00 16,285.00 0.00 Penalties & Interest 671.00 0.00 (671.00) 0.00 671.00 0.00 671.00 0.00 Interest Earnings (507,00) 0.00 507.00 0.00 (507.00) 0.00 (507.00) 0.00 Total Revenues 16,449.00 0,00 (16,449.00) 0.00 16,449.00 0.00 16,449.00 000 EXPENDITURES Total Expenditures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Excess Rev Over (Under) Exp $ 16.449.00 S 0.00 (16,449.00) 0.00 S 16.449.00 S 0.00 16,449.00 0.00 311212013 at 9:02 AM REVENUES Interest Earnings Total Revenues EXPENDITURES City of Gem Lake 14OFFMAN ROAD IMPROVEMENTS Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 urr Mnth Curt Mnth Curr Mnth YTD audttct Actual Variance %Complete Budeet $ 236.00 $ 0.00 (236.00) 0.00 $ 236.00 $ 236.00 0.00 (236.00) 0.00 236.00 0.00 236.00 0.00 YTD YTD Actual V riance %Complete 000 236.00 0.00 Total Expenditures 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Excess Rev Over (Under) Exp 5 236.00 $ 0.00 (236,00) 0.00 $ 236.00 $ 0.00 236,00 0.00 3112t2013 at 9:03 AM City of Gem Lake SEWER ENTERPRISE FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Ninth YTD YTD YTD Butte Actual Variance %u Comnleic Bud eet Actual Variance %Comnlae REVENUES Local SAC $ 0.00 $ 1,000.00 1,000.00 0.00 $ 0.00 $ 1,000.00 (1,000.00) 0.00 Metro SAC 0.00 2,365.00 2,365.00 0.00 0.00 2,365.00 (2,365.00) 0,00 Residential Sewer Revenues 9,600.00 0,00 (9,600.00) 0.00 9,600.00 0.00 9,600.00 0.00 Commercial Sewer Revenues 32,000.00 0.00 (32,000.00) 0.00 32,000.00 0.00 32,000.00 0.00 Interest Earnings 2,884.00 0.00 (2,884.00) 0.00 2,884.00 0.00 2,884.00 0.00 Total Revenues 44,484.00 3,365.00 (41,11900) 7.56 44,484.00 3,365.00 41.119.00 7.56 EXPENDITURES Office Supplies 500.00 0.00 (500.00) 0.00 500.00 0.00 500.00 0.00 Postage 200.00 0,00 (200,00) 0.00 200.00 0.00 200.00 0.00 Auditing Services 2,120.00 0.00 (2,120.00) 0.00 2,120.00 0.00 2,120.00 0.00 Engineering 2,500.00 0.00 (2,500.00) 0.00 2,500.00 0.00 2,500.00 0.00 MCES Charges 16,090.00 2,681.66 (13,408.34) 16.67 16,090.00 2,681.66 13,408,34 16.67 Locates 550.00 113.15 (436.85) 20,57 550.00 113.15 436.85 20.57 Financial Services 4,000.00 0.00 (4,000,00) 0.00 4,000.00 0.00 4,000.00 0.00 Computer Services 575.00 0.00 (575.00) 0.00 575.00 0.00 575.00 0.00 Repairs & Maint - Contractual 4,000.00 0.00 (4,000.00) 0.00 4,000.00 0.00 4,000.00 0,00 Depreciation 12,500.00 0.00 (12,500,00) 0.00 12,500.00 0.00 12,500.00 0.00 Sewer Televise/Flushing 8,000.00 0.00 (8,000.00) 0.00 8,000.00 0.00 8,000.00 0.00 Total Expenditures 51.035 00 2,794.81 (48,240.19) 5.48 51,035.00 2,794.81 48,240.19 5.48 Excess Rev Over (Under) Exp ($ 6,551.00) $ 570.19 7,121.19 (8.70) (5 6,551.00) S 570 19 (7,121 19) (8.70) 3/1212013 al 9:05 AM City of Gem Lake INVESTMENT TRUST FUND Budgeted Statement of Revenues and Expenditures For the Two Months Ending February 28, 2013 Curr Mnth Curr Mnth Curr Mnth YTD YTD Budge Aqww Variance % Comolete Budge t Actual Varince %Complete REVENUES Interest Earnings $ 0.00 $ 2.65 2.65 0.00 $ 0.00 $ 2.65 (2.65) 0.00 Total Revenues 0.00 2.65 2.65 0.00 0.00 2.65 (2.65) 0.00 3/12/2013 at 9:07 AM