5.b) Treasurer's ReportBeginning Balance 12/01/2015
Receipts
Expenditures
Payroll
City of Scandia
Treasurer's Report
December 31, 2015
$ 122,177.60
$ 39,728.31
Adjustments: NSF check
NSF bank charge
Duplicate receipt entry
Ending Balance 12/31 /2015
$ 2,285,045.38
$ 1,135,994.98
-$161,905.91
-214.25
- 4.00
1 142.10
$ 3,257,774.10
************************************************************************
Ending Balance includes the following Investments:
Checking * 102 $-8,129.16
Money Market * 105 - Rate .25% $ 2,637,055.86
CD *3136 — Rate .90%, 24 mo., 3/21/2017 $ 305,061.66
CD *3137 — Rate .80% 18 mo., 1/21/2017 $ 315,878.66
Total Undesignated Funds $ 3,249,867.02
Scandia EDA *6301 $ 2,595.47
Childers Credit, Savings *3110 — Rate .05% $ 5,01.1.61
Total Designated Funds $ 7,907.08
Total Funds 3,257,774.10
Submitted by: Colleen Firkus, Treasurer
GENERALFUND
Administration & Finance
City Council
Elections
Planning & Building
Police
Fire Dept
Public Works
Parks & Recreation
Community Center
Total GENERAL FUND
EDA
DEBT SERVICE
BLACKTOP PROJECCT 2007
2010 EQUIPMENT CERTIFICATES
2011 EQUIPMENT CERTIFICATES
2013 EQUIPMENT CERTIFICATES
2015 EQUIPMENT CERTIFICATE
Total BLACKTOP PROJECCT 2007
CAPITAL IMPROVEMENTS
PARK CAPITAL IMPROVEMENTS
EQUIPMENT REPLACEMENT
LOCAL ROAD IMPROVEMENT FUND
201 SEWER FUND
UPTOWN SEWER
SCANDIA, MN
Expenditure Summary
December 2015
2015 2015 December 2015 % of YTD
YTD Budget YTD Amt MTD Amt YTD Balance Budget
$361,667.00 $340,118.67 $47,860.46 $21,548.33
$20,121.00
$15,002.70
$0.00
$5,118.30
$470.00
$1,172.37
$0.00
-$702.37
$71,700.00
$98,010.77
$10,373.99
-$26,310.77
$111,105.00
$56,668.77
$0.00
$54,436.23
$282,865.00
$173,701.61
$11,926.76
$109,163.39
$1,164,327.00 $1,034,443.12
$56,008.31
$129,883.88
$62,246.00
$54,794.22
$11,544.81
$7,451.78
$39,479.00
$33,881.40
$1,977.27
$5,597.60
$2,113,980.00 $1,807,793.63 $139,691.60 $306,186.37
$5,000.00 $365.00
$140,188.00 $390,187.50
$42,080.00 $42,080.00
$32,310.00 $32,310.00
$66,020.00 $66,950.00
$0.00 $2,000.00
$140,188.00 $533,527.50
$412,000.00 $9,137.20
$36,000.00 $47,272.56
$230,000.00 $214,938.00
$550,000.00 $586,903.14
$0.00 $4,635.00
$0.00-$249,999.50
$0.00
$0.00
$0.00
$0.00
$5,400.00
-$930.00
$0.00
-$2,000.00
$5,400.00
-$252,929.50
$0.00 $402,862.80
$4,856.38-$11,272.56
$0.00 $15,062.00
$1,820.50-$36,903.14
$62,170.00 $169,531.18 $11,729.94-$107,361.18
$19,323.00 $11,592.01 $1,198.59 $7,730.99
94.04%
74.56%
249.44%
136.70%
51.00%
61.41 %
88.84%
88.03%
85.82%
85.52%
7.30%
278.33%
100.00%
100.00%
101.41 %
0.00%
2.22%
131.31 %
93.45%
106.71 %
272.69%
59.99%
Report Total $3,709,071.00 $3,381,060.22 $164,697.01 $328,010.78 91.16%
N
m
m
o
m
V
0
0
(mn
(Mn
rn
mM
m ar
W
M
m
m
n
m
lt
O
O
m
—
O
m
N
m
M r
m
n
(n
N
(D
O
N
r
M
W
V
u)
N
V
V
M
1
N
U
vi
W
m
r
m
r
m
Cl!
r
O
O
n
O
n
V
f•
M O
N
N
N
N
O
m
N
n
m
M
W
O
M
N
n
V
r
cn
(NO cD
>
N
N
O
N
Z
n
w
m
n
m
m
m
r
m
O
m
1
rn
O
o
O
o
N
o
W
o
N
(q
M
n n
rn CC
O
F
m
(O
N
N
(n
O
C.)N
O
m
N
(D
n
No
C')
(D
N
O
m
cn O
r m
U
cl
Cl)
Cl)
m
O
N
N
Cl)
m
m
n
O
m
V
n
n
O
r
N
M
m
a
%
N
N
w
M
m
m
a0
O
�
n
n
O
O
(A
c7
N
O
(A
V
N
N
It
v! N
fsO�
N
N
O
O
NN
m
M
co
m
}
O
o Pi
W
Cl)
N
�
FA
N
M
H049
r
M
m
m
mm CO
a
w
H
V
co
o
V
n
m
o
n
m
M
((1
(n
O
o (O
m
m
I�
m
f9
n
m
o
rn
n
(�
o
o
M
v
N
o
V
n
v
r aD
LQ a
N
O
o
m
(1)
m
M
n
r
N
M
M
m
()
Cl)
M
m
N
m
H
Q
699
mm
m
rl
N
m
}
O
to
n
O
n
m
o
r
n
M
m
m
to O
m
m
m
n
m
o
m
n
N
o
O
(n
h
n
N
O
r
m
O
m
N
Cl!
m V
m N
r
N
N
N
m
M
m
N
m
N
m to
m
m
m CO
O
m
w
m
ON
n
n
N
CMD
O?
V
(O
a
(00
m
N
m
O
O
(n(1
M
N
N
O
n
m
tD
(h
u] (n
n
io
m
m
Cl)N
N
V
(D
O
r
N
m
m
Lo
Gi
o
m
r
n
in
i9
m m
m
m
m
M
m
N
m
(y
}
N
M
cn
m
O
m
O
V
r
O
M
n
m
m
n
Q
?
(O
m
m
(
(A
a
(O
N
O
O
(7
m
m
N
M
M O
O V
N
m
m
Cl)
n
n
n
El)
m
m
m
O
.9
m
n
O
N•
m
W04 V
m at
N
m
J_
O
O
o
m
V
r
n
Cl)r
m
n a0
m0
(DID
CO
N
O
N
N
V
m
m r
LL
Q
"'»
!m0
mm
O
O
r
Cl) a0
Cl)N
69
o
Cl)
Lo
Itvm
N
Cl)
LO
m (O
m O
m
b9
^
(i9
w
�
a
(_:
m
((1
(oO
U)
(00
0)OD
N
(n0
N
m
in
co
O N
a.
Q
N
rm
O
n
cn
m
O
(D
(O
r
O
O
m
m
N N
V
N
m
m
m
O
M
4]
N
YM]
m
m
m
m
mM
m
m
�
}
N
O
(n
O
m
V
n
n
M
r
m
r
m n
Q
m
m
n
M
r
N
Cl)
m
m
m
O
m
m
(n
m
o
N
o
Cl)
M
m
a
n N
(� r_
Ci
m
m
m
mm
m
r-
m
ao
(D
o
v
Nm
m
N
m
V
V
m
mm
mN
m
W
cl
LL
m
U) =
}
(n
O
n
N
(n
m
m
(A
O
V
co
N (A
W F
0
n
o
N
v
o
m
o
�
or
(r-
m
n
m
mm
V»
mm
m
g�
a
0
(D
�
N
v,
"
0
rn V
Q LL
n
m
m
m
m
49 m
m0
m
w
U w
0
Z
O
N
Z
N
(A
(n
O
Z
Y
w
w
w
w
w
w
U
U
U
w
>
(i
LL
LL
U
O
Rf,
v
w
w
a
a
a
C
o
p
m
w
W
w
w
W
W
F-
d6slf
N
O
5
U
U
U
U
w
LL
Q'
3
O
Z
QO
~
Z
Z
Z
Z
2a
W
((1)
./]
Q
OF-
Q
2
2
2
2
J
w
�
Z
3
w
=
a
m
a
m
�
U
w
U
0
s
Y
LL
Q
w
O
w
w
o
w
w
s
w
s
w
s
w
a
m
5
w
U
�
U
Z
:)
C7
w
m
I-O
(LL
:
N
M
0
L)
V
m
m
N
N
D
N
w
LL
N
N
M
M
M
m
MIt
v
It(00
m
co
1