5.b Treasurer's Report November 2019City of Scandia
Treasurer's Report
SC � NDI � 11/30/2019
Beginning Balance 11/1/2019 $ 4,150,954.02
Receipts $ 52,999.21
Expenditures $ 344,230.38
Payroll $ 27,180.63
$ (371,411.01)
Adjustments:
Ending Balance 11/30/2019 $ 3,832,542.22
Ending Balance includes the following Investments:
17
Checking *102
$
39,796.98
I�,0I
,Q
Money Market *105 - Rate .25%
$
1,824,071.65
CD *2920/4426 - Rate 2.50% 12 mo., 1/29/2020
$
523,822.15
CD *4422 - Rate 2.50% 12 mo., 3/25/2020
$
309,569.81
CD *4424 - Rate 2.00% 12 mo., 7/25/2020
$
432,154.59
CD *4425 - Rate 1.75% 12 mo., 9/28/2020
$
717,664.73
Total Undesignated Funds
$
3,847,079.91
Checking Account *3102
Checks in Transit $ (11,809.74)
Transfer to EDA correct cash account *105
Deposit in transit $ (2,678.45)
Adj: Refund permit $ (49.50)
Total Undesignated Funds $ 3,832,542.22
Scandia EDA *6301 $ 16,789.34
Receipts
Expenditures $ (3,130.00)
Checks in Transit
Deposit in Transit
Total Designated Funds $ 13,659.34
Total Funds $ 3,846,201.56
Submitted by: Colleen Firkus, Treasurer
City of Scandia
�T r Expenditure Summary
S1.�[�'� 17�.� � DIA
$473,133.00
$471,419.01
November -19
$1,713.99 99.64%
CAPITAL IMPROVEMENTS $224,200.00
$171,604.94
$12,47350
$52,59506 7654%
ROAD CONSTRUCTION $0.00
$0.00
2019 YTD Budget
% of YTD
GENERAL FUND
2019 YTD Budget
2019 YTD Amount 2019
MTD Amount
Balance
Budget
Administration & Finance`*
$791,862.00
$774,171.22
$25,931.63
$17,690.78
97.77%
City Council
$31,000.00
$25,230.49
$1,10076
$5,769.51
81.39%
Elections
$2,200.00
$830.00
$000
$1,370.00
37.73%
Planning & Building
$119,200.00
$110,816.89
$11,164.23
$8,38311
92.97%
Police
$136,000.00
$68,127.51
$000
$67,872.49
50.09%
Fire Department
$262,400.00
$235,982.77
$55,57004
$26,41723
89.93%
Public Works
$661,000.00
$517,356.65
$38,150.76
$143,643.35
78.27%
Parks & Recreation
$85,100.00
$60,298.14
$1,73621
$24,801 86
7086%
Community Center
$49,800.00
$34,965.43
$3,25916
$14.83457
70.21%
Total General Fund
$2,138,562.00
$1,827,779.10
$136,912.79
$310,782.90
85.47%
EDA
$80000
$10,190.00
$3,13000
-$9,390.00
1273.75%
CABLE TV
$22,20000
$17,265.59
$000
$4,934.41
77.77%
GATEWAY DONATIONS
$0.00
$0.00
$0.00
$0.00
0.00%
DEBT
2007 ROAD PROJECT BOND
$0.00
$0.00
$0.00
$0.00
0.00%
2013 EQUIPMENT CERTIFICATES
$62.91800
$62,912.50
$3,420.00
$550
99.99%
2015 EQUIPMENT CERTIFICATE
$44,941.00
$43.94600
$0.00
$99500
9779%
2017 EQUIPMENT CERTIFICATE
$35,636.00
$35,328.00
$0.00
$308.00
99.14%
2018 BLACKTOP
$329,638.00
$329,232.51
$212,912.51
$405.49
9988%
$473,133.00
$471,419.01
$216,332.51
$1,713.99 99.64%
CAPITAL IMPROVEMENTS $224,200.00
$171,604.94
$12,47350
$52,59506 7654%
ROAD CONSTRUCTION $0.00
$0.00
$000
$0.00
PARK CAPITAL IMPROVEMENTS
$207,24000
$112,539.91
$4,734.65
$94,700.09
54.30%
EQUIPMENT REPLACEMENT
$73,00000
$72,421 26
$4,384.43
$578.74
9921%
LOCAL ROAD IMPROVEMENT FUND
$368,29000
$138,670.77
$4,009.50
$229,619.23
37.65%
201 SEWER FUND
$137,525.00
$93,783.56
$16,484.58
$43,741.44
68.19%
UPTOWN SEWER
$21,397.00
$9,46854
$517.12
$11,928.46
44.25%
Report Total
$3,666,347.00
$2,925,142.68
$398,979.08
$741,204.32
79.78%
co W W A A A A Aj W t� w N N N — T
O O O O O O O O W N N O C
N N co W A N W V O W V O W N z
m C N r m T m 0 m m m m m m 0 m O G
w T O O D O D c 0 0 O m D O m
X O D C DO n C C C n � m D m
Z 2 m D O E O m m m p n 1 D y
m X 3 m 0 0 0 N m0 < r
X T A m m m o 0
a X v m�� x" z to a
r
0 n T T T
m m Z D D D O
m m m m m Z
Z Z m
m>
ox
A
TD
N EA A N69 60
(ten fA fA EA W Z O D
OAI 69
W W (AD (JJI W N O (D EA EA W A O Z z
OD O O V O N A O w W W a 1 m
O W 69 N O TV O W OOO O co OD O V O O
40 69 69 T
A — m
EA fA fA W
N fA ji A N
N N O fA fA fA m A
W O O A V W EA fA j O C
A pN A V W W N O W � EA W N D
A W OD N N ID O W N A O W w N
W co W to O V (D fA O W O W V W tD M
V to W W V V A O O N co A O O W V
H fA EA
A
69 fA H EA
fA EA — A N N O 69 EA V) W 3
N W A V V EA j (n a
(n N N tD (A (A 00 (n
W N A W (D O A N A O w W
A V W W W V W EAO W O V V W
CIO O W V A 00
O W N O V W x
fA EA fA
A fA EA FA EA
O fA A N � W EA EA 69 N
A W fA O A V O V fA N W D
01 O 00 A W W W W N O (D 19 t9 w O O
to N O j W tD A O N A O W V N
N A WA V CD EA W O ID O V V O W W 22
W A V W W V N O W O (D N O O W W r
fAf9 !A
W EA EA EA FA
V fA fA fA A N W_ fA 69 fA N_
co O w A V O A fA ? EA N
W (D �
CI V O tD V w W O W N A A
W W (D O W V O EA W N O tD W V VW W D
O W W A W V W O A O O A mo
W w A 1
M EA EA
W fA 69 EA 69 EA _
C) fA fA A N W EA fA FA
co O 8 O W V O w -+ 69
W W O O W ) O OD W N O Oy) W A C
iD V W O A W W W W N A A W V W W Z
K) O) O V W EA W N O W W W V O N
A N W V W O co O O A CD O O W OD m
fA fA EA fA
A fA fA fA
V EA fA _ W N O EA EA f9 W
W Oto s to O O O w 69 fA r2 OD
W A O A W N D O w W W O fA fA O L
N OD N (D W W W N W O O W W W A C
coOv W (wit (W11 A O A (AD (Wn OD V (wD (Vn
N fA EA EA
A EA EA D
A fA fA fA (n N O EA 19 EA N C
to O(D tD O O O fA 69 69 EA j A
N A A OD W N tD W t0 W W O EA N N
W C
O A W W N W N W O O W W V_
W A A N W O 0 W A W (D N W V .1t.
W V N O W O N O W V O) O tD A O 1
y
fA fA EA EA m
A
EA EA fA 1
m (�jJ1 �' O �' N '1 N N �' 69 69 f j 3
A A N O (D W (D W W O j 01 W
N N O W N V O (O N W O O W 69 J W m
W O (ODI A N O W O W (AO (WDI W v two N O W W X
fA fA EA fA EA EA EA EA EA EA EA EA EA (A fA fA EA FA
A O N O O n
V W W o A A o O (
ND OD W (J UI W W 0
V OW V W . W N W O O W A V W m
A A N t0 O O N O A W (D N W V W W W m
GI N O W O W (O W (D O W V W O V W W A
w fA fA fA EA EA EA EA EA EA EA EA EA EA EA f9 fA EA
z
w f
co (n O tD m
DA) (AJI V OWI O (D W _(ND W W W ao W :-4 3
N 0) V V i W W W O t0 W O W W W
O W a O O V fD O W co (D A W V N O N m
N O O W A