Loading...
5.b Treasurer's Report (11-30-16)a.tig, SCANDIA Beginning Balance 11/01/2016 Receipts Expenditures Payroll Adjustments: void check 34098 City of Scandia Treasurer's Report 11/30/2016 $ 119,696.05 $ 29,941.83 $ 2,512,778.72 $ 37,028.97 $ (149,637.88) $ 58.91 Ending Balance 11/30/2016 $ 2,400,228.72 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *3136 — Rate .90%, 24 mo., 3/21/2017 CD *3137 — Rate .80% 18 mo., 1/21/2017 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Checks in Transit Deposits in Transit Total Funds Submitted by: Colleen Firkus, Treasurer $ 48,737.00 $ 1,757,203.04 $ 307,134.91 $ 318,420.25 $ 5,070.47 $ 2,431,495.20 $ 5,070.47 $ (34,336.95) S $ 2,402,228.72 9CANDILA City of Scandia Expenditure Summary Nov -16 2016 YTD Budget % of YTD GENERAL FUND 2016 YTD Budget 2016 YTD Amount 2016 MTD Amount Balance Budget Administration & Finance $324,84800 $291,31798 $32,58311 $33,53002 89.68% City Council $26,976.00 $14,51891 $1,30763 $12,45709 53.82% Elections $6,150.00 $5,274.82 $2,716.54 $87518 8577% Planning & Building $96,206.00 $90,41227 $7,42253 $5,793.73 93.98% Police $116,19700 $57,15818 $0.00 $59,038.82 49.19% Fire Department $240,576.00 $170,400.84 $52,16303 $70,17516 70.83% Public Works $1,197,153.00 $884,91570 $31,872.49 $312,23730 7392% Parks & Recreation $60,879.00 $46,323.62 $3,839.53 $14,555.38 76.09% Community Center $40,261.00 $29.555.02 $2.582 49 $10.70598 73.41% Total General Fund $2,109,246.00 $1,589,877.34 $134,487.35 $519,368.66 75.38% EDA $0.00 $325.00 $000 -$32500 0.00% DEBT 2010 EQUIPMENT CERTIFICATES $43,010.00 $40,710.00 $000 $2,300.00 94.65% 2011 EQUIPMENT CERTIFICATES $31,185.00 $31,185.00 $30,592.50 $0.00 10000% 2013 EQUIPMENT CERTIFICATES $65,82300 $65,88250 $4,98750 -$59.50 100.09% 2015 EQUIPMENT CERTIFICATE $46,720.00 $47,020.50 $000 -$300.50 10064% $186,738.00 $184,798.00 $35,580.00 $1,940.00 98.96% CAPITAL IMPROVEMENTS $40,00000 $2,37000 $0.00 $37,63000 5.93% PARK CAPITAL IMPROVEMENTS $38,50000 $0.00 $000 $38,50000 000% EQUIPMENT REPLACEMENT $315,000.00 $0.00 $000 $315,000.00 0.00% LOCAL ROAD IMPROVEMENT FUt $1,250,000.00 $917,58686 $34750 $332,41314 73.41% 201 SEWER FUND $50,73000 $52,90746 $6,172.20 -$2,17746 10429% UPTOWN SEWER $16,035.00 $12.608.38 $93426 $3,42662 7863% Report Total $4,006,249.00 $2,760,473.04 $177,521.31 $1,245,775.96 68.90% O N O N O 00 O O) O A O N W N — O N O m (n C m N r O m p v0 a D m p m p m p m p Z m m O p v m °g z m v r m m m m p b,.. m 0 -Zi 3 ( A -1 -4 � N r YI O a m X v m T m m m m V 2 rF+. p n < 3 m K m 0 --1-4 0 0 � 0 Z i (mi> ai m m9 O W Ute) A V (NO 69 A fA W Z 0 z O) co A O 0 O O O N" V) V a Z n V —1 W ? W O) — O) (n -I W W W A = m O) (D O V OO O 00 N fA j W O co (D (n rU O) OD V W m 00 V O m O A O) N Vl N 69 T w fA 49 v, m O 69 fA A A EA N fA fA 69 01 N OD 69 A O V 00 En EA A fA W O) W N V N O N D N O O) N N (n O D O) (n O) A (D O) W O O V W (O W N V (D A A N O CO (O W W () W (D m J O J W OD OD O O O) N O A O) { N � fA fA fi) In -4 v) W A . N T (A 4l CNA 3 � V (A � O O W 4969 A 69 a A N (O N O N O W N N N Oo A Mew NWNWNOAa) O 2n O) J OD O O O N EN fA co EA fA W A .9 N fA 69 69 A to (7) (n (D O) 00 fA N 69 00 a pN O) ' O) N o m (D N O O) N J V) W M OD A (moi) O A (Nn W V OOo (JJ W N OV 22 O V V O OD O O O O) Ot O O O W r � 6A N 69 69 EA co (A EA W A 69 N fA (A 69 A W O) 69 O1 OD (D N OD fA T O) 69 N N N N (O O) O J N O O) N OD N O7 3 co to N O IJ N O O_ O CJ O OD (O A W O O) W N OD A O OD J O W N V W OD 00 O O O W W O J O W 69 d! 69 A (A N Z9 FA fA 69 W Q! O) N W O N OD A 01 W 0 fA A O 69 V J Co O V J O W N O (n A C m 00 O) V V N 4) O O DD W O O CO J OD (n W N O A O) 00 V Z W O A O OD O O OJ W O V O m N _ W O N A _ W _ J N W O N Co O N N O) V OI N O) V (O V V W N N N V Ut () L CD (D DD OD N C.) O) W OD j W co O (AC co A � M O W A N O1 V r O) J O V 00 O O W OD O O A O O -< a � N to <A fA a V fA 69 A EA0 W Z9 (A 69 fA C N N (A In A OD O N N O . O D V N f0 A O J V W N N N V N N O V (D N W O) O) co cn W (O O (n C O) W (O W A O OD C) A N 8 O) J N N V7 O) to m O O W OD O O A O N N 6 m N1 fn w 69 z+ A fA W 69 fA fA (A A m co N 69 O) W (D O N N W 69 Cl) m N ut V W u) V V W ut N N V N N W (O N N W O) IJ W O) O OD N W (O O IV N A N 00 O A N O) V W m N0 (J1 N O 00 O O W 00 O O A O O7 .11 NN.Ni O) O) n W O 0) O 1O W N N N N VV NV V O m N) W 0) W W W O) O V mV�Jm -4 C" O) V a) O O W OD O O A W 11 Z N � A A W N m O N O) W (O N O N N O) OD 3 N m W N O (O O V W O m N OD N 01 W OD (D (D N W W O) DD O W O O (O m W W J O (n co Cl) A W O) W J co (O N V Oo O OD O O W O) W O W O W i0