5.b Treasurer's Report November 2018V f
CAN DLA
Beginning Balance 11/1/2018
Receipts
Expenditures
Payroll
Adjustments: reclass Spec Assess fund 307
City of Scandia
Treasurer's Report
11/30/2018
$ 378,563.21
$ 25,427.46
$ 4,034,925.10
$ 46,325.66
$ (403,990.67)
$ 13.36
Ending Balance 11/30/2018 $ 3,677,273.45
Ending Balance includes the following Investments:
Checking *102
Money Market *105 - Rate .25%
CD *2920 — Rate 1.80% 12 mo., 1/24/2019
CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018
CD *4420/4422 — Rate 1.00% 12 mo., 3/21/2019
CD *4423 - Rate 1.20% 2 mo., 9/23/2018
CD *4424 - Rate 2.40% 12 mo., 7/25/2019
Total Undesignated Funds
Scandia EDA *6301
Total Designated Funds
$ 36,469.79
$ 1,676,716.47
$ 511,826.08
$ 302,880.30
$ 700,000.00
$ 422,434.09
$ 23,259.57
$ 3,650,326.73
$ 23,259.57
Checks in Transit $ (12,932.96)
Deposits in Transit $ 16,606.75
reclass Spec Assess fund 307 $ 13.36
Total Funds $ 3,677,273.45
Submitted by: Colleen Firkus, Treasurer
lvCity of Scandia
SCANDIA Expenditure Summary
Nov -18
2018 YTD Budget
% of YTD
GENERAL FUND
2018 YTD Budget
2018 YTD Amount
2018 MTD Amount
Balance
Budget
Administration & Finance
$364,000.00
$325,137.96
$24,269.97
$38,862.04
89.32%
City Council
$19,500.00
$14,422.81
$552.87
$5,077.19
73.96%
Elections
$6,200.00
$5,245.37
$2,194.64
$954.63
84.60%
Planning & Building
$126,300.00
$147,752.52
$9,947.06
-$21,452.52
116.99%
Police
$127,200.00
$71,889.96
$0.00
$55,310.04
56.52%
Fire Department
$276,310.00
$189,251.94
$16,327.78
$87,058.06
68.49%
Public Works
$1,130,500.00
$882,726.84
$38,516.29
$247,773.16
78.08%
Parks & Recreation
$72,800.00
$57,231.49
$2,258.20
$15,568.51
78.61%
Community Center
$53,100.00
$38,721.07
$3,230.45
$14,378.93
72.92%
Total General Fund
$2,175,910.00
$1,732,379.96
$97,297.26
$443,530.04
79.62%
EDA
$80000
$10,108.40
$5,927.00
-$9,308.40
0.00%
GATEWAY DONATIONS
$0.00
$5,000.00
$0.00
$0.00
0.00%
CABLE TV
$7,300.00
$2,018.75
$0.00
$5,281.25
0.00%
DEBT
2007 ROAD PROJECT BOND
$14,20800
$18,149.86
$0.00
-$3,941.86
0.00%
2013 EQUIPMENT CERTIFICATES
$64,503.00
$64,067.50
$3,997.50
$435.50
99.32%
2015 EQUIPMENT CERTIFICATE
$45,801.00
$45,709.00
$0.00
$92.00
99.80%
2017 EQUIPMENT CERTIFICATE
$36,58000
$35,921.34
$0.00
$658.66
88.2M
$161,092.00
$163,847.70
$3,997.50
-$2,755.70
101.71%
CAPITAL IMPROVEMENTS
$259,650.00
$204,485.00
$12,530.00
$55,165.00
78.75%
ROAD CONSTRUCTION
$0.00
$3,847,771.05
$102,933.86
43,847,771.05
#DIV/0!
PARK CAPITAL IMPROVEMENTS
$18,220.00
$1,382.74
$64.45
$16,837.26
7.59%
EQUIPMENT REPLACEMENT
$165,680.00
$229,83723
$0.00
-$64,157.23
138.72%
LOCAL ROAD IMPROVEMENT FUt
$6,500,000.00
$4,388,013.11
$274,241.37
$2,111,986.89
67.51%
201 SEWER FUND
$64,450.00
$52,258.36
$1,936.39
$12,191.64
81.08%
UPTOWN SEWER
$21,700.00
$11,050.73
$89805
$10,649.27
50.93%
Report Total
$9,374,802.00
$10,648,153.03
$499,825.88
-$1,273,351.03
co
W
0
A
A
A
A
A
j
j
j
W
N
N
N
—
m
N
m
A
N
m
C
N
00
V
V)
W
V
O
(N))
N
O
p
y
0
m
m
W
x
0
m
0
O
(/)C
x
m
�
p
�
p
m
D
0
1
D
C
�
D
�
co
O
�
z
*
x
m
n
o
�
3
1xm
AZ
D
w
r
m
D
v
?
1
1
v
m
O
0
�
m
m
m
00
NOi
��ph
m
T
J
0
A
D
aD
H [moi
O<
T
T
-n
>
m
0
Z
n
n
n`
m
D
D
D
Z
K
m
m
m
z
G7
Z
L7
(A
m0
zcn
vx
0 0
A
1.969
TD
6A
69
A
A
69
W
6A
EA
6A-4
Z
3 5
V
N
O
0)
J
Q)
A
W
8
W
C
Z z
PfA
-2
W
D
n
A
W
V
0)
V
A
0)
O
OD
W
(n
O
N
0
W
NW
00
N
W
W
V
Ln
69
69
V
A
W
W
M
--1
m
00
O
O
O
V
Ln
O
A
O
A
O
O
O
(T
W
{
x (1)
W
EA
W
m
m
G1
W
69
(D
69
69
A
A
69
j
69
469
6A
69
N
A
V
(-A))
(J/)
A
J
8
V
A
W
W
00
69
(NO
(0
))
N
A
J
D
w
(n
(0
A
00
OD
0)
0)
O
00
O
69
(0
N
W
O
N
W
W
J
-+
(n
A
(n
69
V
A
J
A
.;a
J
W
OD
N
A
Ot
O
(0
O
A
O
O
O
(n
N
{
W
69
69
W
W
69
69
C?
N
CO
V
W
A
ANN
N
0)
W
W
(O
(An
Z
W
A
0)
A
V
—
(It
OD
O
(n
O
W
N
6A
cn
0)
W
N
W
J
J
m
0
W
0)
co
0)
OD
W
O
O
OD
W
O
A
69
O
O
O
69
O
441
N
(0
m
W
69
FA
P
E9
69
69
V
69
69
O
W
V
A
_
O)
W
A
69
69
A
w
O
A
t0
m
V
W
m
(Nn
O
V
N
N
(0
A
OD
0)
W
N
CO
(0
(3)
V
V
(0
W
OD
co
O
V7
O
N
W
69
O
0)
of
00
W
O
V
A
6A
O
V
(n
fA
O
N
O
00
(0
r
69
W
fA
69
69
69
V
69
69
�
A
A
N
69
169
A
69
N
CD
cn
N
N
V
A
N
OD
O
00
W
A
W
W
A
Ln3
W
00
A
(D
N
8
W
O
O
(0
N
V
N
69
0)
0)
W
OO
N
W
0)
c0
EA
V
69
N
0)
j
D
N
OD
Cl)
J
(Y)
V
OD
O
(D
O
0)
O
0)
O
A
{
W
69
69
(A
W
69
69
V
O
69
N
fA
69
00
(0
O
N07
00
Q1
N
(n
FA
fA
A
69
fA
EA
N
CO
(O
O
O
A
A
W
W
A
O
W
Qo
Oo
V
J
W
W
(n
A
W
j
W
D)
A
-+
CO
N
(n
U
V
C
z
(O
N
00
(n
O
O
N
V
A
(n
A
J
co
O
0)
0)
(0
W
N
N
Co
(Y)
6A
O
V
(n
0)
co
0)
A
O
O
m
W
EA
69
69
J
69
69
N
N
00
69
N
'En
EA
OD
m
W
W
O
0
A
m
N
(A
EA
fA
[A
ffl
69
N
0)
O
(D
O
N
DJ
O
8
A
00
J
(n
J
0)
N
0)
cn
L.
ID
O
W
A
(n
8
W
A
V
CO
N
CO
—
O
(0
0
C
00
O
N
O
0)
O
O
J
W
N
V
j
Cn
J
O
N
W
m
O
0
EA
00
V
(n
O
(0
O
m
A
r
{
W
69
69
69
W
W
69
D
O
69
69
0
N
OJ
0)
EA
EA
Z9
(A
A
C
00N
(O
V
69
O)
W
(n
A
W
V
W
au
(0
OD
(n
J
Ln
V
N
(n
m
N
Gi
00
O)
Q)
OD
W
O
(O
Co
N
W
69
;9
00
(D
W
C
OD
-W.
O
A
(A
Oo
W
W
N
0)
A
au
N
N
O
N
W
0)
O)
(n
Oo
J
cn
O
0)
c0
(D
j
Cl)
{
CO)
A69
'En
m
N
69
69
cn
N
cn
cn
fA
(A
A
m
V
W
j
6A
W
(D
V
(n
Co
E9
C9
N
O
3
W
N
D)
W
A
O
V
U
J
'6
0)
N
cam
V7
W
A
f0
OD
V
00
O
W
0)
69
J
V
OO
W
O
0)
V
O
co
(n
f0
V
N
J
Ot
OD
0)
aD
co
O
co
N
W
X
W
69
69
69
69
EA
69
6A
(A
69
W
6A
69
W
69
69
6A
-P,
W
W
A
N
O
Ln
(0
(n
p
V
Q)
V
O
N
W
O
J
C
V
N
N
p0
O
(O
(n
N
W
A
O
00
c0
0)
co
N
Cl)
-4
c0
A
ca
N
A
N
Oo
O
co
0)
W
OD
O
W
O
V
(0
j
m
(n
Q)
m
0)
00
W
(n
A
V
N
01
00
0)
00
(D
W
69
6A
(A
69
V)
03
6A
69
fA
w
69
6fl
6A
W
6fl
69
z
w
O
W
V
W
W
N
(D
N
Oo
.
N
U
j
a
N
N
V
m
m
V
O
O
0n
V
W
O
V
(.n
_
A
O
QO
3
N
Q)
W
Cl)
N
V
i
O
CO
N
W
W
O
0)
W
V
A
O
N
O
W
(0
01
O
W
0)
V
N
V
O
m
W
4
0
Cl)
W
0
12
Q)
N
0)
cn
W
N
A
X