5.b) Treasurer's ReportSCANDIA
Beginning Balance 10/01/2014
Receipts
Expenditures
Payroll
City of Scandia
Treasurer's Report
October 31, 2014
$ 108,761.50
$ 27,925.53
$ 2,906,867.24
$ 43,324.95
-$136,687.03
Adjustments: transfer charges recorded $ 8.00
Marosok stop payment $ 104.50
Ending Balance 10/31/2014 $ 2,813,408.66
*********************************************************
Ending Balance includes the following Investments:
Money Market - Rate .25%
$ 2,047,274.16
Scandia EDA $ 365.72
Savings *3110 — Rate .05% $ 5,008.49 (Childers Credit)
CD *3134 — Rate .40%, 18 mo., 8/05/2015 $ 124,673.38 (Quinnell)
CD *3136 — Rate .50%, 24 mo., 3/21/2015 $ 302,263.26
CD *3137 — Rate .40% 18 mo., 7/21/2015 $ 314,306.46
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
EDA
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
October 2014
2014
2014
October
2014
% of YTD
YTD Budget
YTD Amt
MTD Amt
YTD Balance
Budget
$344,543.00
$256,861.35
$22,993.84
$87,681.65
74.55%
$18,839.00
$14,021.17
$4,384.76
$4,817.83
74.43%
$6,110.00
$3,369.30
$0.00
$2,740.70
55.14%
$166,200.00
$56,631.31
$5,208.53
$109,568.69
34.07%
$122,068.00
$58,460.80
$0.00
$63,607.20
47.89%
$309,404.00
$189,213.26
$13,173.17
$120,190.74
61.15%
$1,076,097.00
$953,633.63
$53,111.45
$122,463.37
88.62%
$0.00
$0.00
$0.00
$0.00
0.00%
$56,031.00
$47,970.55
$3,431.34
$8,060.45
85.61%
$39,707.00
$29,716.37
$4,068.79
$9,990.63
74.84%
$2,138,999.00 $1,609,877.74 $106,371.88 $529,121.26 75.26%
$0.00 $134.28 $0.00 -$134.28 0.00%
$150,388.00
$10,193.75
$0.00
$140,194.25
6.78%
$41,640.00
$1,315.00
$0.00
$40,325.00
3.16%
$43,330.00
$43,330.00
$0.00
$0.00
100.00%
$33,300.00
$1,650.00
$0.00
$31,650.00
4.95%
$66,460.00
$61,335.00
$0.00
$5,125.00
92.29%
$335,118.00 $117,823.75 $0.00 $217,294.25
CAPITAL IMPROVEMENTS
$68,250.00
$27,164.94
$13,700.25
$41,085.06
39.80%
PARK CAPITAL IMPROVEMENTS
$47,500.00
$9,928.69
$0.00
$37,571.31
20.90%
EQUIPMENT REPLACEMENT
$200,000.00
$190,048.10
$0.00
$9,951.90
95.02%
201 SEWER FUND
$173,096.00
$68,356.72
$12,125.04
$104,739.28
39.49°%
UPTOWN SEWER
$20,680.00
$8,802.87
$534.42
$11,877,13
42.57%
Report Total
$2,983,643.00
$2,032,137.09
$132,731.59
$951,505.91
68.11%
W b0 A A A A f i W W W N + T
O+ N N 0 N A W N O (NT C
m C N r m m m m T W m 2
n -moi o0 c A v IDo � o m °
m D Z
AO O m Dr v 1 v v 2 m
Z m 0 m m m m 0
ti m x o z 3 v -Zi z z N
D m v m m A m m A p
O (] T T T
m O O
A
ZZy 1 y N N
O
Z
°
m0
ob
x
oW
n Zn
N V 0 N 0 b 0 0 W W W 0 b
y � T
N m
W M fN fA fA W
A W J A V A O (n A 0 N n
N O A N O A A 0 U O A N 0 W
N �
M W f9 fA bi yf 3
G 0 bI 0 O N f9 N Fp fA b1 � N �
N A N O W V W N W 0 0 O �DA
V N b W O W b V N A 0 0 N
N 0 V 0 O N 0 V (p N V N V n
0 W (n fD O W A O A 0 0 V 2
N �
M f9 fA M N
V fA W O N f9 f9 fp fA 0 O D
A A W V O 0
V 0 (O b O (n 0 + (O N V W V N
O 0 0 W O Ol A b O N 0 U A r
M
N
f9 FM fA f9 fN fA fq
O W IA 0 O N fA + N f9 f9 + N q
O O A N O W V V W 0 V W 3
N N 001 tN0 O N Wb r V 0 J W W
O N V 0 O 0 .P (O tap O A N N ro
N
N
fA W fA N H fA {q
W W V O O 0 O t0 t0 O A OJ N Ot m
N
W
W v t0 V W O O (J + N 0 N 0 (L C
N 0 J O N � (0Il tD W W N 0 N O V C
W �
O N W+ N loll yN � fA f9 f9 W N C
W fp 0 J N � tNl� b t0J W N 00) lW)l O 0 -I
N
0 +l IJJf l0J m �+ A N l0 W OD b Wq 3
W + W
0 N J (a11 N O U b W W N A � m 11
N 0
N W J N 0 0 W N Ol W 0 (p m
W 0 N N N O 0 W W W N 0 0 0 b .21