Loading...
5.b) Treasurer's ReportSCAN DIA Beginning Balance 06/01/2014 Receipts Expenditures Payroll City of Scandia Treasurer's Report June 30, 2014 $ 169,120.27 $ 24.659.89 Adjustments: Transfer Charges recorded Ending Balance 6/30/2014 $ 2,600,911.82 $ 31 875.83 -$193,780.16 M $ 2,439,015.49 ********************************************************* Ending Balance includes the following Investments: Money Market - Rate .25% $ 1,674,140.99 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,882.80 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 FIREHALLIPUBLIC WORKS BOND 2010 EQUIPMENT CERTIFICATES 2011 EQUIPMENT CERTIFICATES 2013 EQUIPMENT CERTIFICATES Total Debt Service CITY OF SCANDIA Expense Summary June 2014 2014 2014 June 2014 % of YTD YTD Budget YTD Amt MTD Amt YTD Balance Budget $344,543.00 $160,629.95 $45,164.69 $183,913.05 46.62% $18,839.00 $68,250.00 $4,916.77 $0.00 $0.00 19.73% $13,92223 $47,500.00 26.10% $41,640.00 $6,110.00 $820.00 $1,322.24 $820.00 $852.24 $40,820.00 $4,787.76 1.97% 21.64% $172,096.00 $166,200.00 $7,009.73 $16,698.64 12.93% $9,981.02 $20,680.00 $149,501.36 $33,300.00 10.05% $1,650.00 $122,068.00 $1,650.00 $309.74 $31,650.00 $0.00 4.95% $121,758.26 0.25% $309,404.00 $159,726.78 $11,735.44 $149,677.22 51.62% $1,076,097.00 $574,036.57 $124,200.01 $502,060.43 53.34% $0.00 $0.00 $0.00 $0.00 0.00% $56,031.00 $27,232.37 $3,870.51 $28,798.63 48.60% $39,707.00 $16,413.66 $1,778.50 $23,293.34 41.34% $2,138,999.00 $961,286.72 $197,582.41 $1,177,712.28 44.94% $150,388.00 $68,250.00 $10,193.75 $0.00 $10,193.75 19.73% $140,194.25 $47,500.00 6.78% $41,640.00 $45,296.31 $820.00 EQUIPMENT REPLACEMENT $820.00 $0.00 $40,820.00 $200,000.00 1.97% $43,330.00 $172,096.00 $41,960.00 $7,009.73 $0.00 12.93% $1,370.00 $20,680.00 96.84% $33,300.00 $14,625.95 $1,650.00 Report Total $1,650.00 $1,120,732.04 $31,650.00 $1,862,910.96 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 $2,203.69 $2,203.69 $45,296.31 4.64% EQUIPMENT REPLACEMENT $200,000.00 $0.00 $0.00 $200,000.00 0.00% 201 SEWER FUND $172,096.00 $22,259.14 $7,009.73 $149836.86 12.93% UPTOWN SEWER $20,680.00 $6,054.05 $819.83 $14,625.95 29.27% Report Total $2,983,643.00 $1,120,732.04 $207,615.66 $1,862,910.96 37.58% W W O A A A A W W C O O O O O O O O C N N W O A W N > O J Z m c N r m -o o m m m -n m () p CO m O O D D p 0 D � r- m 0 � n c �u m c c c m D Z M O< m D �_ m m m p D -� m o Zi z Co C o D A m A m m m W -14 o r O n O K m Z Z Cn CO Cl) O Z 0 my Z y v= vi fA c m D W '69 69 fA W Efl i O � 0)N (19 169 N A 2 D A > O W �J co O W N N N O C Z N J CSA N co (D W W CO W W 00 c0 D 1 co 0 ID co w 07 00 N d) O m 0) N CNA O O W O (A w (30= (1) cn T N fA w EA fA fAW co O N 169(A N W rZi N W 4 J A 69 N (A EA W W C A W J A J A O CA A O) N D O CO W J A (0 CA W (A J (A (A A N co 0) <A J W N N N J CA J O) .� CA O A N O A A W CA O A (A 0) W j Im EA N 49 EA fA [A (A {A 4 > > N m NfA N O 3 A W W O N EA N V) fA [A 0) W D W A CA O N J W (A W 0) W O > V m (O N O W (D J N A OD (A ()i j W W (JA (W0 O co co - O ? m W J 2 fA w IJ wEA [A V) 'A 69 V N O) N to N O s J 460 W O N fA > (A EA EA > W O D A A W J O W J V CA W 0) W J 0) co A m O W CO IJ tf W cn N O r7% V (A O O O U) O) > O N J (A J N O OD 0) W O W A co O Ol 0) N A (— N fA fA EA fA EA 69 H) 0) N 0) N_ (1)(_A N O O O1 1W co O N V3 (A EA to cn 0) O O A CA O OD J J O > O) J > W 3 O CO Q) (A O W (D > W J N J W W N N 0) co O m W A J J W W (fl D O N J 0) O W A (0 (0 O A CA N W N EA S9 H) EA w fA {A A N W N 469 H) N J N J 4u) co O N ffl > (A fA w -+ cn cO J J CA J O W W J CA 0) J _ C N co A CA O w -I _ CA -1 W J W _ W co co 0) O N OD A-4 J W W Z O W J O O 00 0 (D (D O A (A N m m