5.b) Treasurer's ReportSCANDIA
Beginning Balance 11/01/2014
Receipts
Expenditures
Payroll
Adjustments:
Ending Balance 11/30/2014
City of Scandia
Treasurer's Report
November 30, 2014
$ 303,849.44
$ 23,400.45
$2,813,408.66
$ 28,924.28
-$327,249.89
$ 2,515,083.05
************************************************************************
Ending Balance includes the following Investments:
Money Market - Rate .25%
CD *3136 — Rate .50%, 24 mo., 3/21/2015
CD *3137 — Rate .40% 18 mo., 7/21/2015
Total Undesignated Investments
Quinnell CD *3134 — Rate .40%, 18 mo., 8/05/2015
Scandia EDA *6301
Childers Credit, Savings *3110 — Rate .05%
Total Designated Investments
Submitted by: Colleen Firkus, Treasurer
$ 1,746,366.50
$ 302,263.26
$ 314,306.46
$ 2,362,936.22
$ 124,799.08
$ 865.72
$ 5,008.49
$ 130,673.29
GENERALFUND
Administration & Finance
City Council
Elections
Planning & Building
Police
Fire Dept.
Public Works
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
CAPITAL IMPROVEMENTS
PARK CAPITAL IMPROVEMENTS
EQUIPMENT REPLACEMENT
201 SEWER FUND
UPTOWN SEWER
CITY OF SCANDIA
Expenditure Guideline
November 2014
2014
2014
November
2014
% of YTD
YTD Budget
YTD Amt
MTD Amt
YTD Balance
Budget
$344,543.00
$275,916.96
$19,055.61
$68,626.04
80.08%
$18,839.00
$14,021.17
$0.00
$4,817.83
74.43%
$6,110.00
$5,624.68
$2,255.38
$485.32
92.06%
$166,200.00
$63,706.99
$7,075.68
$102,493.01
38.33%
$122,068.00
$58,460.80
$0.00
$63,607.20
47.89%
$309,404.00
$198,859.50
$9,646.24
$110,544.50
64.27%
$1,076,097.00
$986,799.86
$33,166.23
$89,297.14
91.70%
$56,031.00
$52,341.21
$4,370.66
$3,689.79
93.41%
$39,707.00
$33,898.95
$4,182.58
$5,808.05
85.37%
$2,138,999.00 $1,689,630.12 $79,752.38 $449,368.88 78.99%
$0.00 $134.28 $0.00 -$134.28 0.00%
$150,388.00
$150,387.50
$140,193.75
$0.50
100.00%
$41,640.00
$42,135.00
$40,820.00
-$495.00
101.19%
$43,330.00
$43,330.00
$0.00
$0.00
100.00%
$33,300.00
$33,300.00
$31,650.00
$0.00
100.00%
$66,460.00
$66,955.00
$5,620.00
-$495.00
100.74%
$335,118.00
$336,107.50
$218,283.75
-$989.50
$68,250.00
$27,164.94
$13,700.25
$41,085.06
39.80%
$47,500.00
$9,928.69
$0.00
$37,571.31
20.90%
$200,000.00
$190,048.10
$0.00
$9,951.90
95.02%
$173,096.00
$93,504.86
$25,148.14
$79,591.14
54.02%
$20,680.00
$9,448.36
$645.49
$11,231.64
45.69%
Report Total $2,983,643.00 $2,355,966.85 $323,829.76 $627,676.15 78.96%
W
m
m
N
Q
N
m
m
m
b
O
N
m
m
m
O
z m
b m
m
Q
W
o
m
r
m
o
n
N
m o
iO
N
Z
(p
b_
r
N
A
❑
N
LL'
b
b
m
N
m
W
W
N
O
N
r
N b
W
N
m
N
m
N
m
h
b
m
p
b
r
m
A
m
N
N
m
N
m
O
m
m
(7
W
r m
N
m
Cml
N
W
N
IQO
H
CW]
m
r
H
� O
FF
H
H
H
Vr
N
Q
N
N W
�
�
W
H
H
N
r
M
N
W
b_
W_
Z
m
l0
r
n
Q
m
b
O
.
0
m .
r
b
O
b
Q
m b
N
H
H
H
H
H
H H
H
Nm
WQ
W
V
m
O
m
Qm
n
^
m
N N
M
m
A
A
b
r
m
O
b
b
W W
b
N
r
{mp
H
H
N
A
q
O
m
N
m O
mN
N
N
J
Q
m
m
O
W
Q
m
O
m
b
m O
a
m
m
H
w
of
H
w
H
n
n
ai
o
n
ei
d a
O
N
H
N
m
N
h
H
M
=
A
r
N
r
N
W
r
0
N
O
m
r
N N
�
A
m
b
m
b
imp
19
Q
M
yN�
A
W
AH
b
O
S
m
m
pW
N A
O
N
rH
19
N
�
m
q
m n
�
w
Y
C9
m
b
b
m
Q
O
N
Q
O b
m
pQ
yN
yyQ
W
LL
y
h
❑F
a
W
m
m
Cl
m
m
m
W
m
N
m
A b
= Z-J
O
(V
lV
(V
t7
O
Oi
F
17
�
�
r V
5$
❑
2 O
H
UW
Z
m
H
K
W
W
O
U
U
U
0
^rL,Ua
Q
K
s
rc
J
a
w¢
W
a
U
U
aK
K
3
z
z
z
g
LL
z
w
N
w
w
w
a
WZ
Q
U
w
�
O
a
Y
U
b
O
U
w
O
g
¢
a
a
WW
a
Z
(�
W
m
LL
W
W
U
�W
❑J
N
J
W
N
LL
O
N