5.b) Treasurer report44
SCANDIA
., W
Beginning Balance 05/01/2014
Receipts
Expenditures
Payroll
City of Scandia
Treasurer's Report
May 31, 2014
$ 154,052.60
$ 23,330.91
Adjustments: Transfer Charges
State Surcharges recorded
Ending Balance 5/31/2014
$ 2,712,968.85
$ 63,633.43
-$177,383.51
-$8.00
$ 1,701.05
$ 2,600,911.82
*********************************************************
Ending Balance includes the following Investments:
Money Market - Rate .25% $ 1,841,809.55
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,502.82
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
FIREHALL/PUBLIC WORKS BOND
2010 EQUIPMENT CERTIFICATES
2011 EQUIPMENT CERTIFICATES
2013 EQUIPMENT CERTIFICATES
Total Debt Service
CITY OF SCANDIA
Expenditure Summary
May 2014
2014 2014 May 2014 % of YTD
YTD Budget YTD Amt MTD Amt YTD Balance Budget
$344,543.00 $115,465.26 $21,654.72 $229,077.74 33.51%
$18,839.00
$4,916.77
$0.00
$13,922.23
26.10%
$6,110.00
$470.00
$0.00
$5,640.00
7.69%
$166,200.00
$6,717.62
$5,779.54
$159,482.38
4.04%
$122,068.00
$309.74
$0.00
$121,758.26
0.25%
$309,404.00
$147,991.34
$13,612.37
$161,412.66
47.83%
$1,076,097.00
$449,836.56
$29,165.82
$626,260.44
41.80%
$0.00
$0.00
$0.00
$0.00
0.00%
$56,031.00
$23,361.86
$4,073.77
$32,669.14
41.69%
$39,707.00
$14,635.16
$2,306.33
$25,071.84
36.86%
$2,138,999.00 $763,704.31 $76,592.55 $1,375,294.69 35.70%
$150,388.00
$10,193.75
$10,193.75
$140,194.25
6.78%
$41,640.00
$820.00
$820.00
$40,820.00
1,97%
$43,330.00
$41,960.00
$0.00
$1,370.00
96.84%
$33,300.00
$1,650.00
$1,650.00
$31,650.00
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
$0.00
$0.00
$47,500.00
0.00%
EQUIPMENT REPLACEMENT
$200,000
$0.00
$0.00
$200,000.00
0.00%
201 SEWER FUND
$173,096.00
$15,249.41
$3,246.28
$157,846.59
8.81%
UPTOWN SEWER
$20,680.00
$5,234.22
$1,294.75
$15,445.78
25.31%
Report Total
$2,983,643.00
$913,116.38
$154,637.33
$2,070,526.62
30.60%
}
Q
c0
N
rn
V
O
0)
0)
�&
N
0
c0
n
N
O
M
M
�
OD
r
LO
r
0)
M
O
(OO
((00
0
W
M
to
r.
(0
-
(fi
r,
r-
0
N
O
Lc
0
-'
O
0
O
N
N
64
69
N
(O
N
co
(Al
69
'
69
69
69
69
C9
N
f9
J_
C
0
0
LO
O
0)
V
0
O
0
O
0
O
O
LO
LO
�
7
N
1
00)
M
O
(OO
IT
co
(n0
d
Q
r-:
O
(o
C6
(D
(»
ri
69
rri
69
r-
r
P-:
(n
06
N
o
O
r-
oO
ri
(»
v
r
v
O
N
EA
6%
N
69
to
6%
N
69
69
'
1
(fl
A
N
N
S
I
N
N
r
N
0)
t`
W
co 0
O
W
r-
(00
N
r`
rO
7
N
OD
d'
N
n
0)
M
O
0
0)
N
n
Q
C
Cl)
Co
oo
(fl
V3,
vi
69
ui
69
ai
N
1-:
GS
0
N
(5
O
rri
0
v
69
0
0
a
N
V3
(N
}
Cl)
co
(O
r
O
(O
co
LO
V
N
7
7
O
603,
N
CD
Vt
M
O
0)
Q
r0
(0O
(N
ONO
O
N
(M
1
(0
OO
1
'C
69
O
69
O
1
V7
N
r-
(A
7
r,
1,
�z
69
OO
OD
S
m
cM
N
EA
(fl
(fl
N
69 69
EA
V3
69
co
N
W
LL
64
(9
S
}
0
00
O
Cl)
h
(0
O
P,
O
r
N
N
N
OO
0
(O
0
1
O
69
(O
OD
O
0)
0
O
OO
Og
U) F
Q)
OD
M
M
0
M
c0
O
c0
0)
OD
N
(O
Q
r`
(O
--i
ZZ
O
N
N
N
O
rl
M
O
Q
J r2
Z
Q
It
N
(A
6%
69
'
N
69
(to
(H
1
69
N
69
O
V
Q LL
HJ
(H
m Q
Sp
UW
0
Z
O
m
(n
(n
(n
z
Y
W
W
W
W
W
Of
W
W
O
U
U
U
{�
LL
LL
L
g
0
J
z
W
z
a
w
Q
A4N
C)
0
CD
j
0
0
U
W
w
a
x
m
g
�
~O
~
U
_j
a
j
z
z
z
m
a
z
W
w
1
Q
Q
U
2
�
w
O
w
U
2
d
a
a
H
Y
a
¢
W
O
W
0
0
>
a
w
7
U
F
U
mw
U
a
Ow
�
MO
LL
W
W
W
JO
N
w
Z
O
r.-
O
O
I
N
r
m
r
I
O
7
O
0
O
0
O
N
O
N
r
I
O
LL
I
M
Cl)
M
cM
Cl)
7
V
V
V
O
(O
00