5.b Treasurer's Report Oct. 2018IP129.
lMM
Beginning Balance
Receipts
Expenditures
Payroll
Adjustments:
City of Scandia
Treasurer's Report
10/31/2018
10/1/2018
remove duplicate receipt entry
$598,534.91
$39,509.94
$ 4,573,531.57
$ 99,841.82
$ (638,044.85)
$ (403.44)
Ending Balance 10/31/2018 $ 4,034,925.10
Ending Balance includes the following Investments:
Checking *102 $ 28 143.05
Money Market *105 - Rate .25% $ 2,047,324.58
CD *2920 — Rate 1.80% 12 mo., 1/24/2019 $ 511,826.08
CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 $ -
CD *4420/4422 — Rate 1.00% 12 mo., 3/21/2019 $ 302,880.30
CD *4423 - Rate 1.20% 2 mo., 9/23/2018 $ 700,000.00
CD *4424 - Rate 2.40% 12 mo., 7/25/2019 $ 422,434.09
Total Undesignated Funds
Scandia EDA *6301
Checks in Transit
Total Designated Funds
Total Funds
Submitted by: Colleen Firkus, Treasurer
$ 25,564.07
$ 4,012,608.10
$ 25,564.07
$ (3,247.07)
$ 4,034,925.10
City of Scandia
Expenditure Summa
. �,UA D rA p Summary
October 2018
2018 YTD Budget
% of YTD
GENERAL FUND
2018 YTD Budget
2018 YTD Amount
2018 MTD Amount
Balance
Budget
Administration & Finance
$364,000.00
$300.86799
$27,851 65
$63.13201
82.66%
City Council
$19,500.00
$13,86994
$4,481.32
$5,630.06
71.13%
Elections
$6,200.00
$3,050.73
$000
$3,149.27
49.21%
Planning & Building
$126,300.00
$137,805.46
$21,41281
-$11,505.46
109.11%
Police
$127,200.00
$71,889.96
$0.00
$55,310.04
56.52%
Fire Department
$271,500.00
$172,924.16
$23,677.74
$98,575.84
63.69%
Public Works
$1,130,500.00
$844,210.55
$43,637.34
$286,289.45
74.68%
Parks & Recreation
$72,800.00
$54,973.29
$2,605.08
$17,826.71
75.51%
Community Center
$53,100.00
$35,490.62
$4,913.25
$17,609.38
66.84%
Total General Fund
$2,171,100.00
$1,635,082.70
$128,579.19
$536,017.30
75.31%
EDA
$800.00
$4,18140
$0.00
-$3,381.40
0.00%
GATEWAY DONATIONS
$0.00
$5,000.00
$0.00
$0.00
0.00%
CABLE TV
$7.30000
$2,018.75
$0.00
$5,281.25
0.00%
DEBT
2007 ROAD PROJECT BOND
$14,208.00
$18,149.86
$000
-$3,941.86
000%
2013 EQUIPMENT CERTIFICATES
$64,503.00
$60,070.00
$000
$4,433.00
9313%
2015 EQUIPMENT CERTIFICATE
$45,801.00
$45,709.00
$0.00
$92.00
99.80%
2017 EQUIPMENT CERTIFICATE
$36,580.00
$35,921.34
$0.00
$658.66
98.20%
$161,092.00
$159,850.20
$0.00
$1,241.80
99.23%
CAPITAL IMPROVEMENTS
$259,650,00
$191,955.00
$0.00
$67,695.00
73.93%
ROAD CONSTRUCTION
$0.00
$3,744,837.19
$451,68563
-$3,744,837.19
#DIV/O!
PARK CAPITAL IMPROVEMENTS
$18,220.00
$1,318.29
$219.61
$16,901.71
7,24%
EQUIPMENT REPLACEMENT
$165,680.00
$229,837,23
$0.00
-$64,157.23
13872%
LOCAL ROAD IMPROVEMENT FLIP
$6,500,000.00
$4,113,771,74
$496,067.23
$2,386,228.26
6329%
201 SEWER FUND
$64,450.00
$50,321,97
$7,085.59
$14,128.03
78.08%
UPTOWN SEWER
$21,700.00
$1.0.152.68
$91032
$11,547,32
46.79%
Report Total
$9,369,992.00
$10,148,327.15
$1,084,547.57
-$778,335.15
co m 0 A A A A A W W W W N N N T
O O O O O O O O w N N O c
N N m m A N V (n w J O m m z
m C N r m m x n m m m m x 0 m 0 O
to v O p D O D O O 0 � N m 0 z
p m r- n n D v A m m
z * , m y O m m m p
m cZi) -Zi -Zi -zi N m0 < rQ
0
D M v C x x x of O
O C7 T ?t ?t >
K m Z -i --I Oz
M m m m (1)
Z
m�
zN
o=
O co
A49969 n D
EA 69 A A 69 W EA EA (A v Z 3 D
V N (ten Co m v m A W O m O W C z Z
A J J m co (l) N N w N W -+ J W D
0 v W A OAO NW =00 O o O O o O V)
69 T
W EA m
(D 69 (A A A (A (A (A EA vi N
69 J J A (A N O C
J (Jt (n A J OJ J A W O m w (O N D
D1 A (D J m Cn m (D w N w — A J J
to Un A m O O O (n N m W J (n (n 69 A A
V m m N A (n O (O O A O O O U) Un -�
69 (A (A
W (A (A (A
CD (A fA A A -+ O(A co fA J
69 m W A N (A (A N A
T N N m J J W A W A (D (n D >
N A A CO (n (n (n w N Cl) — J (7) M
W D) J (n O O N 69 O m w J (A O 69 A m
w W w m m w O (D -+ O A O O O (n O 2
:A (A (A
P (A 69 69
(A (A co A � 0)69 (A (A O
C. Cn(D m O J A J W A w D) A Dn A
O V N N (D A m (n W N w �(D D)
V (D m CO O N (A D) m W J fA J EA N m
V m O m Cl) O (D O A O U) O O (D r
6A fA
w 69 (A (A
(A
V (A -4 A A N A (A N CA
N J A N 0o O -co W A W w A N
(n m (D O co J (n W N (3) N A
N co W v m J coo O (D co m O (Jn O A
FA (A
(A (A (A (.J (A
V (A 69 w N m m (n M
O N (A m O m N (A A (A 69 N (D L
N A W A W m J w A Cl) A (n N C
O A -� m 07 m J w (n W -� D) -+ m M J
(D N(!t 0) V (J) V O m m N (D (A J O) D) O z
m O N A A (D D) co N D) O V) (D A O m
(A (A (A (A
N (A (A m W w m 4 (A m
00 N (A m m O A N(A (A 69 69 N O
(D O N (D O m A N J (n J c n N Un Cn L
fD O W A (J) -+ O A V m N W O V7 O C
00 C, N N O m N N O co O) J (D m r
O 0o O J N J -+ J N D) U) m U) (D O A
P (A 69 (A
69 (A — (A D
69
00 N (A m A J -+ (OD 0�0 (A H) N m C
fD J m Un W W m (n V (n J (n N G)
00 D)J_ �_ m m W O (D m N W m (D m C
Cn
00 W m A coo W m co N N m (mn Deo N 60) (D A 1
N
A' (A 69 (A (A -I
V W 690J sin N)
� N cn (n EA Hi N O m
W m w N m m A O J (n J E9 69
N N
com J (D O d) m m N w V
J 7 W OD
0a)
O (n O W cn J N J W (n (D (D W
M
A — — 0
W N (D a) v --� O 0mo w 0
A (D (Jt (Jt m d) V N O V (n �I N (Nn CND W
tD (n N W A (D m co m m N co J (D A m
N A N m O m (n w m O W D) J (D N
N m (n (n m W (n A V N Q1 ut W (n m (D