5.b Nov. 2017 Treasurer's ReportF
f
M j
Beginning Balance 11/1/2017
Receipts
Expenditures
Payroll
Adjustments:
Ending Balance 11/30/2017
City of Scandia
Treasurer's Report
11/30/2017
Ending Balance includes the following Investments:
$ 208,446.25
$ 24,659.15
Checking *102 $ 22,366.41
Money Market *105 - Rate .25% $ 837,826.01
CD *3138 — Rate 1.20% 18 mo., 7/24/2018 $ 1,109,902.44
CD *2920 — Rate 1.00% 12 mo., 1/24/2018 $ 503,749.06
CD *2921— Rate 1.00% 12 mo., 12/19/2017 $ 401,388.49
CD *4420 — Rate 1.00% 12 mo., 3/21/2018 $ 502,523.72
Total Undesignated Funds
Scandia EDA *6301
Total Designated Funds
Checks in Transit
Deposits in Transit
3rd Quarter State Surcharge paid in October
Total Funds
Submitted by: Colleen Firkus, Treasurer
$ 4,745.47
$ 3,558,959.17
$ 55,846.96
$ (233,105.40)
$ 3,381,700.73
$ 3,377,756.13
$
4,745.47
$
(8,043.14)
$
7,242.27
$
3,381,700.73
N
� City of Scandia
SCANDIA Expenditure Summary
November 2017
2017 YTD Budget
% of YTD
GENERAL FUND
2017 YTD Budget
2017 YTD Amount
2017 MTD Amount
Balance
Budget
Administration & Finance
$342,600.00
$306,337.85
$28,231.43
$36,26215
89.42%
City Council
$18,90000
$14,809.23
$0.00
$4,090.77
78.36%
Elections
$1,300.00
$1,735.50
$905.50
-$435.50
13350%
Planning & Building
$149,000.00
$176,196.50
$19,842.76
-$27,196.50
118.25%
Police
$120,500.00
$64,055.48
$0.00
$56,444.52
53.16%
Fire Department
$244,490.00
$182,512.59
$27,079.26
$61,97741
74.65%
Public Works
$1,371,800.00
$1,107,481.06
$38,476.44
$264,318.94
80.73%
Parks & Recreation
$60,900.00
$57,320.69
$4,881.57
$3,579.31
94.12%
Community Center
$40,200.00
$32,156.36
$2,£04.56
$8043.64
79.99%
Total General Fund
$2,349,690.00
$1,942,605.26
$122,021.52
$407,084.74
82.67%
EDA
$000
$32500
0
-$325.00
0.00%
DEBT
2007 ROAD PROJECT BOND
$77,000.00
$79,31756
$0.00
-$2,31756
0.00%
2010 EQUIPMENT CERTIFICATES
$10,060.00
$10,17713
$0.00
-$117.13
10116%
2011 EQUIPMENT CERTIFICATES
$8,29400
$8,311.93
$0.00
-$17.93
10022%
2013 EQUIPMENT CERTIFICATES
$65,063.00
$65,492.50
$4,575.00
-$42950
10066%
2015 EQUIPMENT CERTIFICATE
$46,36400
$46,41850
$0.00
-$54.50
100.12%
2017 EQUIPMENT CERTIFICATE
$0.00
$2,500.00
$0.00
-$2,500.00
$206,781.00
$209,717.62
$4,575.00
-$2,936.62
101.42%
CAPITAL IMPROVEMENTS
$266,700.00
$13,641.52
$789.62
$253,058.48
511%
PARK CAPITAL IMPROVEMENTS
$44,900.00
$3,76828
$0.00
$41,131.72
8.39%
EQUIPMENT REPLACEMENT
$438,000.00
$195,055.50
$96,063.00
$242,94450
44.53%
LOCAL ROAD IMPROVEMENT FUl`
$50,00000
$5,95000
$0.00
$44,050.00
11.90%
201 SEWER FUND
$62,000.00
$56,554.14
$5,681.79
$5,445.86
91.22%
UPTOWN SEWER
$15.40000
$11,780.16
$692.81
53.619.84
76.49%
Report Total
$3,433,471.00
$2,441,897.48
$229,823.74
$991,573.52
$4.22
OD
O O O O O O O 'Lon
O C
N N aD Q) A V m W N J 0) W z
m C N r m T o m m m m m m m T G) v
cn v O O D D O fJ (J (J (J v c m
0 1 o C xT C C C C C � D W z
O :Em D 0 D x0
Z m 0 Z z z z z z Oo
m Do i N W Y
T T T T T
m m D D D D D
K m --I --I-i -�
Z Z CTn UTi CTA
m> Cn
vx
0 rA
a
w D 3
N 69 fA W A fA fA fA fA V
W fA V V (0 N N E9 J Efl (O O Z
0 0) OW (0 O N69W au O (0 Ot J
W N O OD N W M N N O O O A D 1 A
v cn OO mmAON S
N 0) W OD O O O Cn CO)
T
fA 69m
w 69 69 69 � W
O fA 69 A Ln fA W fA m
Vt N fA 0) Q) O N ffl <A N C
(D A A V (0 V O) W fA N C1i co D
O O 0) O W O A ODW W !A _ O N
O V O N m 0) -tO fA j N O fA O)
co N 0 W co O W J 07 O -<
fA �2
N fA co fA
(O lA fA 0 M fA W fA fA 69 foil 3
(0 fA V V O N D
W (O W A 01 (O V Q7 O W Ot a1 ;u0) Ot A (n W A W 0) W O C!
W Cl) 0) W V N)
j O fA O fA fA fA (0 fA O)
W W O Q1 J W C.0
O V O O O O N S
fA
N
es )) w
69
(0 (fl fA 0 ffA !9 fA (0
N OJ A OV) m (00 co MO W A co
<J) N (0 OD (n Cl) W OD (T Cl) V A S
W W 0) OD W V i O fA O fA f9 fA 01 69 f0
W co N A J W W O V O O O Q1 O Q1 r
fA
N fA (fl fA 69
(JO 69 00
fA V V O - N A fA (D
A Do 0) 0) W (O (O O O J A W 3
A A 0) N W W Oo (n V(n
W V 0) W J !20fA O A fA fA 69 d) fA W D
0) J OD V W W O J N O O O 0) O W
fA
N w co (A CEA fA
A N n fA OD J O N N A fA W L
W O A W d1 (0 W O V A W C
N A (ALn O W U) O O 69 O A fA W (A O) fA N z
W (n 0) V W W O J N O O O 0) O (3) m
fA fA �2
W 69 fA
V fA fA N A fA W EA
f0 Q1 N J W O W Ot O W (O � U C
A V OD A 0) N W W O W N OD
� N W W j A W U fA O (A fA m A EA j r
(0 0) N co V O W A O O W V O 'G
fA fA 69
W
W fA EA V w w w 69 fA A C
OD W pOD W O O A O W O V N C
N O m j m N O O W N O
O N O j N V fA0 fA fA U A fA J to
N N W J W N O W A O O 0) V O O
y
fA 69 69 m
P
(01�n j) fA V m (V)' w fA j) j) fA fA V m
W A N W O O A N O W (0 4 N
fn (0 W W O) W
0 W O W m
OD OD j W N V O OD fA fA 0) A fA W
A A W N O W A O O (n V O .�
W — 0
N V 0 J N Nto 0
O 0
O V O) A OO O !0 W N O W (O V W �
(0 W U O) W aD 01 O W N A m
N V Vt N j aD N A O (O 0) A fA W
t0 J O m W O O W A O O O V O J ;u
z
W 0
4) _ N A _ W i m
+D OD V A OWD A 0 OND N O J (O V A W
V O (O W j O 01 O O7 N m
O)
O 0) W O j N 2 O O) N A W
m A O W W O W OJ 01 V 0 O 0 X