6.b Treasurer's Report November 2020aUg114, City of Scandia
Treasurer's Report
SC NAI A 11/30/2020
Beginning Cash Balance 11/1/2020
$ 4,223,313.52
Receipts Checking
$ 13,138.23
Transfers to Checking
$ 421,000.00
Receipts Money Mrkt
$ 13,502.24
Receipts Investments
$
Expenditures
$ (489,763.76)
Payroll
$ (30,479.41)
Transfers
$ (421,000.00)
Total Disbursements $ (941,243.17)
Adjustments:
Ending Cash Balance 11/30/2020
$ 3,729,710.82
Ending Balance includes the following Investments:
Checking *102
Beg Bal
$
66,392.81
Credits
$
434,138.23
Debits
$
(470,438.95)
End Bal
$ 30,092.09
Money Market *105 - Rate .25%
Beg Bal
$
2,157,243.05
rate change from 1.25%
Credits
$
20,386.42
Debits
$
(421,000.00)
End Bal
$ 1,756,629.47
Investments
CD *4422 - Rate .90% 12 mo., 3/25/2021 $ 314,859.82
CD *4424 - Rate .30% 12 mo., 7/25/2021 $ 439,056.14
CD *4425 - Rate 1.75% 12 mo., 9/28/2021 $ 730,257.71
CD *4426 - Rate 1.60% 12 mo., 1/29/2021 $ 533,461.38
Total Investments $ 2,017,635.05
Total Bank & Investment Accounts $ 3,804,356.61
Checks in Transit *3102 $ (74,843.51)
Deposit in transit checking $ 197.72
Deposit in transit money market
Total Adjusted Undesignated Funds $ 3,729,710.82
Scandia EDA *6301 Bal 10/31/20 $ 25,298.76
Receipts $ -
Expenditures $ (75.00)
Checks in Transit $ (295.00)
Deposit in Transit
Total Designated Funds $ 24,928.76
Total Funds $ 3,754,639.58
Submitted by: Colleen Firkus, Treasurer
City of Scandia
SCANDIAExpenditure Summary
November-20
2020 YTD Budget % of YTD
GENERAL FUND 2020 YTD Budget 2020 YTD Amount 2020 MTD Amount Balance Budget
Administration & Finance" $404,600.00 $784,63352 $446,285.85 -$380,033.52 19393%
City Council $21,00000 $13,98699 $0.00 $7,013.01 66.60%
Elections $6,40000 $8,50304 $2,586.40 -$2,103.04 132.86%
Planning & Building $131,40000 $92,20730 $8,990.62 $39,192.70 70.17%
Police $139,10000 $51,15548 -$18,613.01 $87,944.52 3678%
Fire Department $296,11400 $164,310.48 -$31,583.88 $131,803.52 55.49%
Public Works $690,70000 $529,696.81 $37,010.38 $161,003.19 76.69%
Parks & Recreation $77,60000 $82,616.16 $2,95979 -$5,016.16 106.46%
Community Center $49,50000 $33,292.74 $6,11525 $16,207.26 6726%
Total General Fund $1,816,414.00 $1,760,402.52 $453,751.40 $56,011.48 96.92%
COVID-19 RELIEF 0 $307,561 41 $307,561 41 -$307,561 41
EDA $800.00 $69500 $37000 $105.00 000%
CABLE TV $8,920.00 $3,16840 $000 $5,751 60
GATEWAY DONATIONS $0.00 $0.00 $000 $000 000%
DEBT
2013 EQUIPMENT CERTIFICATI $66,560.00 $63,915.00 $0.00 $2,64500 9603%
2015 EQUIPMENT CERTIFICATI $43,99500 $43,494.50 $000 $50050 98.86%
2017 EQUIPMENT CERTIFICATI $34,94800 $34,54400 $000 $404.00 9884%
2018 BLACKTOP $327,17500 $326,67002 $270,587.51 $50498 9985%
$472,678.00 $468,623.52 $270,587.51 $4,054.48 99.14%
CAPITAL IMPROVEMENTS $430,00000 $126,28747 -$80,465.86 $303,712.53 29.37%
PARK CAPITAL IMPROVEMENT $81,62000 $30,943 12 $000 $50,676.88 3791%
EQUIPMENT REPLACEMENT $256,000.00 $93,49807 $0.00 $162,501 93 36.52%
LOCAL ROAD IMPROVEMENT F $637,000.00 $398,51561 $000 $238,48439 6256%
BIG MARINE SEWER FUND $240,90850 $177,294.93 $17,572.26 $63,61357 7359%
UPTOWN SEWER $22,44700 $7.62743 $48678 $14,81957 33.98%
Report Total $3,966,787.50 $3,374,617.48 $969,863.50 $592,170.02
O 0 I- m O N F� NN O V 0 0 O
ED V N M I: 0 N O N w r aD 0 M w V N N V
Vi 0 00 0 O M N O O 00 (D I� 0 OD
C M C 00 V I- � M 0 OD 0 O N 0 V V
W f� 63 0 N (D V3 N N N M
> V3 V3 0 V 0 Vi ! w V3 r
O Vi 69 Vi (y M
Z V3 V! dt V3
W 000 00 Cl) I� 0 h O I� O O (O 0) M V I� 0 r 0 r
m 0 O M
63 M Oct 00 0 r N N O I` ((7 O C.)- CI(D
p fD OD V N O 0 OD 00 V 0 M W
F (O V3 Vi O V M (O V N N N N V
(� M 69 (A 00 V V3 13 Vi N V3 N
V3 V
O 3 V3 Vi 60 V V
Vi V3 V3 V9
w 00 O 47 O N
m N 00 m M I: V3 0 h O O N (D 0 M (D CA O_ O CII n
O I- U7 0 00 O OD (D 00 Cl) N O f0 O N M
w - 000 1� N N 0 00 0 N V O O (O W)
W 04 0Nv
Vi O 0 V V NMONN
a V3 u9 ei v
W u9 v3 V3 V3 V3
U)
N O O 0 0 0 o N 0 o f` r 0 w
0 Co to h 0 I- O h O M m 0 N OD V 0 N 0 N
w O O 0 4) 0 Oct 0 -L m Cl! 00 h O (D V N N
1-7 M W V Il- N n M coM N O M 47 00
V3 V3 O V (D O V3 N M N N V
Q
'001 M V3 �-' `-' Vi O V V) V3 (D Vi (D
Vi V3 603 69
V3 V3 V3 V3 dt
m M 000 N - 0 � O � o � 00 m 000 O v 407 m M m
7 V O E9 (O 00 00 0 M (O N 0 00 0 V (D N 0
ID 0 00 V I,, N I` 00 0 O N O N 0 N
V3 V3 O V 0 NN co w N 00
0 M V3 V3 O V Vi E9 69 1I 0 h
0 - 0 0 V V
Vi w V3 d9 V3
W (O
Z V M I- 63 00 0 V CA N N 0 0 00 0 0 M 0 N
D O N n 0 M V I,, OD I, M CA V 0 n OD (D
(3 0 M 0 N co M N O M OCT N N W)
ON vi CO M N W N M 7 N CO
00 V3 O N V3 V3 V3 M 69 M
V3 _ 6p, 6 - M M
6-3 V3 V3 69
Q 009 0 I� V3 M V 0LE) 00i N 009 Oro � W V M O 0 00
I� _ � (O co V I- I- N V V Il (D 00 I
V 0 O (O N MM M V V P N O
N N Vi (O N M 47 OD N M M N (D
OD V3 f9 f9 �-' V3 O M V3 V) Vi O 69 (D
63 63 6% M M
V3 V! Vl V3
Qom' (O t` �_ (D 0 O 0 M a0 0 h
a � 4) f� M � v0 uN7 0M I00 � CO O N M 0 v
Q Lo 0 0 0 m (D N M OD M OD O N v
0 f9 b` 9 CO N 0 0 M 0 N 0 0 N
0 V3 Vi V3 O (O M Vi 0 Vi O
V3 - - v3 .1 M v
69 v3 m V3
= N V 47 I- N V M 00 0 N N 47 0 W (0 N
L) 0 h P_ (D LO V 4) M 00 M (D N 0 O O
W N 0 p- M 47 V V 0 N 0) V N 0 N N W
Q I- 0 0 Oi (D N I- O N LO N I-- (D M Di
V3 Ev fA V 47 V V3 N V VN
O V3 V3 O
V360 V3
613 69 63 V3 63
0 V to p- N V M m 0 I� o N 0 w (D
h N I:0 4 V 0 Cl)_ ) 00 (D N V M M O V
Q (O V 69 I� M M V C 0 I, 0 M_ V 0 00 N O
D N (D 0 0 0 ID N I- 0 0 O Cl)
M 0 V (D M O
M V3 f9 V (17 M N V N V
m
63 69 O ID V3 63 63 M m M
W v3 v3 v v
IL V3 6% 0 63 V3
N M M I, N M 00 N 0 (Dr. -00 (D CO
LLI F a' LO I� co LO (O co 00 N I- M O ?
() z Q 0 00 I- MV N (O N N N I` (O N N 7
z p 7 v Vi 63 m (D N I- OD -7 M V 00 (D h M O
Q z V V3 V 0 M 0 0 V N N M
i 'L Q N V3 Vi O N (O V3 V3 V3 (D 0 N
V3
60
m Q ' V3 V3 Vi VN
=O
UW
F- ~
(A uJ (A Z
U) �LU
Q Q Q w W � Z
U U U W >
_ Q I� I� LL V U O o Q
Ww IL Wp CD W O w O W ?.- F
N -1 o U U U aly (n m
W D N F- F- F- LL LL F.w W ~
J w a z z z a a z a0 z W N
0 U p w w w O QU w ¢ O
O w LU w a a a F ga
w O CD W U > > > U d � � U (D OF U Q
g p p p g a Q a p a CO o
O 0 U U w m w w w m U a w -i m w w
7 O O N M O M 47 00 O O 10 O O CIJO N O N
LL — N N N M M M M M V V V V (D (D OD N