5.b Treasurer's Report (11-30-16)a.tig,
SCANDIA
Beginning Balance 11/01/2016
Receipts
Expenditures
Payroll
Adjustments: void check 34098
City of Scandia
Treasurer's Report
11/30/2016
$ 119,696.05
$ 29,941.83
$ 2,512,778.72
$ 37,028.97
$ (149,637.88)
$ 58.91
Ending Balance 11/30/2016 $ 2,400,228.72
Ending Balance includes the following Investments:
Checking *102
Money Market *105 - Rate .25%
CD *3136 — Rate .90%, 24 mo., 3/21/2017
CD *3137 — Rate .80% 18 mo., 1/21/2017
Total Undesignated Funds
Scandia EDA *6301
Total Designated Funds
Checks in Transit
Deposits in Transit
Total Funds
Submitted by: Colleen Firkus, Treasurer
$ 48,737.00
$ 1,757,203.04
$ 307,134.91
$ 318,420.25
$ 5,070.47
$ 2,431,495.20
$ 5,070.47
$ (34,336.95)
S
$ 2,402,228.72
9CANDILA
City of Scandia
Expenditure Summary
Nov -16
2016 YTD Budget
% of YTD
GENERAL FUND
2016 YTD Budget
2016 YTD Amount
2016 MTD Amount
Balance
Budget
Administration & Finance
$324,84800
$291,31798
$32,58311
$33,53002
89.68%
City Council
$26,976.00
$14,51891
$1,30763
$12,45709
53.82%
Elections
$6,150.00
$5,274.82
$2,716.54
$87518
8577%
Planning & Building
$96,206.00
$90,41227
$7,42253
$5,793.73
93.98%
Police
$116,19700
$57,15818
$0.00
$59,038.82
49.19%
Fire Department
$240,576.00
$170,400.84
$52,16303
$70,17516
70.83%
Public Works
$1,197,153.00
$884,91570
$31,872.49
$312,23730
7392%
Parks & Recreation
$60,879.00
$46,323.62
$3,839.53
$14,555.38
76.09%
Community Center
$40,261.00
$29.555.02
$2.582 49
$10.70598
73.41%
Total General Fund
$2,109,246.00
$1,589,877.34
$134,487.35
$519,368.66
75.38%
EDA
$0.00
$325.00
$000
-$32500
0.00%
DEBT
2010 EQUIPMENT CERTIFICATES
$43,010.00
$40,710.00
$000
$2,300.00
94.65%
2011 EQUIPMENT CERTIFICATES
$31,185.00
$31,185.00
$30,592.50
$0.00
10000%
2013 EQUIPMENT CERTIFICATES
$65,82300
$65,88250
$4,98750
-$59.50
100.09%
2015 EQUIPMENT CERTIFICATE
$46,720.00
$47,020.50
$000
-$300.50
10064%
$186,738.00
$184,798.00
$35,580.00
$1,940.00
98.96%
CAPITAL IMPROVEMENTS
$40,00000
$2,37000
$0.00
$37,63000
5.93%
PARK CAPITAL IMPROVEMENTS
$38,50000
$0.00
$000
$38,50000
000%
EQUIPMENT REPLACEMENT
$315,000.00
$0.00
$000
$315,000.00
0.00%
LOCAL ROAD IMPROVEMENT FUt
$1,250,000.00
$917,58686
$34750
$332,41314
73.41%
201 SEWER FUND
$50,73000
$52,90746
$6,172.20
-$2,17746
10429%
UPTOWN SEWER
$16,035.00
$12.608.38
$93426
$3,42662
7863%
Report Total
$4,006,249.00
$2,760,473.04
$177,521.31
$1,245,775.96
68.90%
O
N
O
N
O
00
O
O)
O
A
O
N
W
N
—
O N O
m
(n
C
m
N
r
O
m
p
v0
a
D
m
p
m
p
m
p
m
p
Z
m m O p
v m
°g
z
m
v
r
m
m
m
m
p
b,..
m
0
-Zi
3
(
A
-1
-4
�
N r
YI
O
a
m
X
v
m
T
m
m
m
m
V 2
rF+.
p
n
<
3
m
K
m
0
--1-4
0
0
�
0
Z
i
(mi>
ai
m
m9
O W
Ute) A V (NO 69 A fA W Z 0 z
O) co A O 0 O O O N" V) V a Z n
V —1 W ? W O) — O) (n -I W W W A
= m
O) (D O V OO O 00 N fA j W O co (D (n rU
O) OD V W m 00 V O m O A O) N Vl
N 69 T
w fA 49 v, m
O 69 fA A A EA N fA fA 69 01
N OD 69 A O V 00 En EA A fA W
O) W N V N O N D N O O) N N (n O D
O) (n O) A (D O) W O O V W (O W N
V (D A A N O CO (O W W () W (D
m J O J W OD OD O O O) N O A O) {
N �
fA fA fi)
In -4 v) W A . N T (A 4l CNA
3
� V (A � O O W 4969 A 69 a
A N (O N O N O W N N N Oo A
Mew NWNWNOAa) O 2n
O) J OD O O O
N
EN fA co EA fA W A .9 N fA 69 69 A
to (7) (n (D O) 00 fA N 69 00 a
pN O) ' O) N o m (D N O O) N J V) W M
OD A (moi) O A (Nn W V OOo (JJ W N OV 22
O V V O OD O O O O) Ot O O O W r
� 6A
N 69 69 EA
co (A EA W A 69 N fA (A 69 A
W O) 69 O1 OD (D N OD fA T O) 69 N
N N N (O O) O J N O O) N OD N O7 3
co to N O IJ N O O_ O CJ O OD
(O A W O O) W N OD A O OD J O
W N V W OD 00 O O O W W O J O
W 69 d! 69 A (A N Z9 FA fA 69 W
Q! O) N W O N OD A 01 W 0 fA A
O 69 V J Co O V J O W N O (n A C
m 00 O) V V N 4) O O DD W O
O CO J OD (n W N O A O) 00 V Z
W O A O OD O O OJ W O V O m
N _
W
O N A _ W _ J
N W O N Co O N N O) V
OI N O) V (O V V W N N N V Ut () L
CD (D DD OD N C.) O) W OD j W co O (AC
co A � M O W A N O1 V r
O) J O V 00 O O W OD O O A O O -<
a �
N to <A fA a
V fA 69 A EA0
W Z9 (A 69 fA C
N N (A In A OD O N N O . O
D V N f0 A O J V W N N N V N N
O V (D N W O) O) co cn W (O O (n C
O) W (O W A O OD C) A N 8 O) J N
N V7 O) to m O O W OD O O A O N
N
6 m
N1
fn w 69 z+ A fA W 69 fA fA (A A m
co N 69 O) W (D O N N W 69
Cl) m
N ut V W u) V V W ut N N V N N W
(O N N W O) IJ W O) O OD N W (O O IV
N A N 00 O A N O) V W m
N0
(J1 N O 00 O O W 00 O O A O O7 .11
NN.Ni O) O) n
W
O 0)
O 1O
W N N N N VV NV
V O m N) W 0) W W W O) O V mV�Jm -4 C"
O) V a) O O W OD O O A W
11
Z
N �
A A W N m
O N O) W (O N O N N O) OD 3
N m W N O (O O V W O m N OD N 01 W
OD (D (D N W W O) DD O W O O (O m
W W J O (n co Cl) A W O) W J co
(O N V Oo O OD O O W O) W O W O W i0