Loading...
5.b) Treasurer report44 SCANDIA ., W Beginning Balance 05/01/2014 Receipts Expenditures Payroll City of Scandia Treasurer's Report May 31, 2014 $ 154,052.60 $ 23,330.91 Adjustments: Transfer Charges State Surcharges recorded Ending Balance 5/31/2014 $ 2,712,968.85 $ 63,633.43 -$177,383.51 -$8.00 $ 1,701.05 $ 2,600,911.82 ********************************************************* Ending Balance includes the following Investments: Money Market - Rate .25% $ 1,841,809.55 Savings *3110 — Rate .05% $ 5,005.86 (Childers Credit) CD *3134 — Rate .40%, 18 mo., 8/05/2015 $ 124,547.81 (Quinnell) CD *3136 — Rate .50%, 24 mo., 3/21/2015 $ 301,502.82 CD *3137 — Rate .40% 18 mo., 7/21/2015 $ 313,677.07 Submitted by: Colleen Firkus, Treasurer GENERALFUND Administration & Finance City Council Elections Planning & Building Police Fire Dept Public Works Sewer Parks & Recreation Community Center Total GENERAL FUND DEBT SERVICE BLACKTOP PROJECT 2007 FIREHALL/PUBLIC WORKS BOND 2010 EQUIPMENT CERTIFICATES 2011 EQUIPMENT CERTIFICATES 2013 EQUIPMENT CERTIFICATES Total Debt Service CITY OF SCANDIA Expenditure Summary May 2014 2014 2014 May 2014 % of YTD YTD Budget YTD Amt MTD Amt YTD Balance Budget $344,543.00 $115,465.26 $21,654.72 $229,077.74 33.51% $18,839.00 $4,916.77 $0.00 $13,922.23 26.10% $6,110.00 $470.00 $0.00 $5,640.00 7.69% $166,200.00 $6,717.62 $5,779.54 $159,482.38 4.04% $122,068.00 $309.74 $0.00 $121,758.26 0.25% $309,404.00 $147,991.34 $13,612.37 $161,412.66 47.83% $1,076,097.00 $449,836.56 $29,165.82 $626,260.44 41.80% $0.00 $0.00 $0.00 $0.00 0.00% $56,031.00 $23,361.86 $4,073.77 $32,669.14 41.69% $39,707.00 $14,635.16 $2,306.33 $25,071.84 36.86% $2,138,999.00 $763,704.31 $76,592.55 $1,375,294.69 35.70% $150,388.00 $10,193.75 $10,193.75 $140,194.25 6.78% $41,640.00 $820.00 $820.00 $40,820.00 1,97% $43,330.00 $41,960.00 $0.00 $1,370.00 96.84% $33,300.00 $1,650.00 $1,650.00 $31,650.00 4.95% $66,460.00 $60,840.00 $60,840.00 $5,620.00 91.54% $335,118.00 $115,463.75 $73,503.75 $219,654.25 CAPITAL IMPROVEMENTS $68,250.00 $13,464.69 $0.00 $54,785.31 19.73% PARK CAPITAL IMPROVEMENTS $47,500.00 $0.00 $0.00 $47,500.00 0.00% EQUIPMENT REPLACEMENT $200,000 $0.00 $0.00 $200,000.00 0.00% 201 SEWER FUND $173,096.00 $15,249.41 $3,246.28 $157,846.59 8.81% UPTOWN SEWER $20,680.00 $5,234.22 $1,294.75 $15,445.78 25.31% Report Total $2,983,643.00 $913,116.38 $154,637.33 $2,070,526.62 30.60% } Q c0 N rn V O 0) 0) �& N 0 c0 n N O M M � OD r LO r 0) M O (OO ((00 0 W M to r. (0 - (fi r, r- 0 N O Lc 0 -' O 0 O N N 64 69 N (O N co (Al 69 ' 69 69 69 69 C9 N f9 J_ C 0 0 LO O 0) V 0 O 0 O 0 O O LO LO � 7 N 1 00) M O (OO IT co (n0 d Q r-: O (o C6 (D (» ri 69 rri 69 r- r P-: (n 06 N o O r- oO ri (» v r v O N EA 6% N 69 to 6% N 69 69 ' 1 (fl A N N S I N N r N 0) t` W co 0 O W r- (00 N r` rO 7 N OD d' N n 0) M O 0 0) N n Q C Cl) Co oo (fl V3, vi 69 ui 69 ai N 1-: GS 0 N (5 O rri 0 v 69 0 0 a N V3 (N } Cl) co (O r O (O co LO V N 7 7 O 603, N CD Vt M O 0) Q r0 (0O (N ONO O N (M 1 (0 OO 1 'C 69 O 69 O 1 V7 N r- (A 7 r, 1, �z 69 OO OD S m cM N EA (fl (fl N 69 69 EA V3 69 co N W LL 64 (9 S } 0 00 O Cl) h (0 O P, O r N N N OO 0 (O 0 1 O 69 (O OD O 0) 0 O OO Og U) F Q) OD M M 0 M c0 O c0 0) OD N (O Q r` (O --i ZZ O N N N O rl M O Q J r2 Z Q It N (A 6% 69 ' N 69 (to (H 1 69 N 69 O V Q LL HJ (H m Q Sp UW 0 Z O m (n (n (n z Y W W W W W Of W W O U U U {� LL LL L g 0 J z W z a w Q A4N C) 0 CD j 0 0 U W w a x m g � ~O ~ U _j a j z z z m a z W w 1 Q Q U 2 � w O w U 2 d a a H Y a ¢ W O W 0 0 > a w 7 U F U mw U a Ow � MO LL W W W JO N w Z O r.- O O I N r m r I O 7 O 0 O 0 O N O N r I O LL I M Cl) M cM Cl) 7 V V V O (O 00