5.b) Treasurer's ReportSCANIDIA
Beginning Balance 10/01/2015
Receipts
Expenditures
Payroll
City of Scandia
Treasurer's Report
October 31, 2015
$ 317,731.87
$ 27.322.80
3,291,347.53
$ 52,664.30
-$345,054.67
Adjustments: Recycling Grant Oct. Deposit $-8,106.00
Safe box fee -35.00
Ending Balance 10/31/2015 $ 2,990,816.16
************************************************************************
Ending Balance includes the following Investments:
Money Market - Rate .25%
CD *3136 — Rate .90%, 24 mo., 3/21/2017
CD *3137 — Rate .80% 18 mo., 1/21/2017
Total Undesignated Investments
Scandia EDA *6301
Childers Credit, Savings *3110 — Rate .05%
Total Designated Investments
Submitted by: Colleen Firkus, Treasurer
$ 2,352,245.67
$ 304,378.68
$ 315,878.67
$ 2,972,503.02
$ 2,895.47
$ 5,010.99
$ 7,906.46
GENERALFUND
Administration & Finance
City Council
Elections
Planning & Building
Police
Fire Dept
Public Works
Parks & Recreation
Community Center
Total GENERAL FUND
EDA
DEBT SERVICE
BLACKTOP PROJECCT 2007
FIREHALUPUBLIC WORKS BOND
2010 EQUIPMENT CERTIFICATES
2011 EQUIPMENT CERTIFICATES
2013 EQUIPMENT CERTIFICATES
2015 EQUIPMENT CERTIFICATES
Total Debt Service
CAPITAL IMPROVEMENTS
PARK CAPITAL IMPROVEMENTS
EQUIPMENT REPLACEMENT
LOCAL ROAD IMPROVEMENT FUND
201 SEWER FUND
UPTOWN SEWER
CITY OF SCANDIA
Expenditure Summary
October 2015
2015 2015 October 2015 % of YTD
YTD Budget YTD Amt MTD Amt YTD Balance Budget
$361,667.00 $267,809.83 $24,422.17 $93,857.17
$20,121.00 $15,002.70 $4,384.76 $5,118.30
$470.00 $300.00 $0.00 $170.00
$71,700.00 $75,056.26 $13,378.78-$3,356.26
$120,989.00 $56,668.77 $0.00 $64,320.23
$271,516.00 $136,468.40 $14,432.95 $135,047.60
$1,039,154.00 $923,493.69 $73,109.61 $115,660.31
$62,246.00 $42,279.21 $4,281.28 $19,966.79
$39,479.00 $26,067.64 $3,564.95 $13,411.36
$1,987,342.00 $1,543,146.50 $137,574.50 $444,195.50
$5,000.00 $365.00 $0.00 $4,635.00
$140,188.00
$7,593.75
$0.00
$132,594.25
$0.00
$0.00
$0.00
$0.00
$42,080.00
$42,080.00
$0.00
$0.00
$32,310.00
$1,155.00
$0.00
$31,155.00
$66,020.00
$61,055.00
$0.00
$4,470.00
$0.00
$2,000.00
$0.00
-$2,000.00
$280,598.00
$113,883.75
$0.00
$166,219.25
$412,000.00 $150.00 $150.00 $411,850.00
$36,000.00 $40,197.68 $1,192.50-$4,197.68
$230,000.00 $83,000.00 $83,000.00 $147,000.00
$550,000.00 $550,747.35 $8,367.00-$747.35
$62,170.00 $144,789.53 $108,197.21-$82,619.53
$19,323.00 $9,306.17 $904.87 $10,016.83
74.05%
74.56%
63.83%
104.68%
46.84%
50.26%
88.87%
67.92%
66.03%
77.65%
7.30%
5.42%
0.00%
100.00%
3.57%
93.23%
0.00%
0.04%
111.66%
36.09%
100.14%
232.89%
48.16%
Report Total $3,582,433.00 $2,486,080.98 $339,386.08 $1,096,352.02 69.40%
OD W O A A A A W W (2 W W w N m
O -+ O O O O O O N O C
N N OD W A (J1 W N -+ O V (n Z
m C N m v m m m m m W m O p
to v O O D D iJ !J rJ p z � D z
0� 0 c X v c c c c m
x O m> v x g v v x m
Z :E x m D r m m m m r O
m '—Zi m —Zi 1 v N
.Z1 m n n n n C O N
ca of o
r p n M '9 'fi 9
m
O
K m
Z m m m m W
O
z
v
mn
z N
v2
wW (WA (WA 69
(D EA EA - D
ON N69 NZ 3
A OJ A w(D EA EA fA DOO OrDZDn(D w DCV DZ -4 W V V O O A N O J (D mW O) O o D"
00 S� -4 CO O) N
(n N O) A O (AOD (D OI N -4 O Cn 2 N
d+ 69 m
w 69 Efl eA to to W
fA W A N (A N In
A O) EA A N Vi (D fA 69 fA OI A C
O mOD 00 V (n W (D J 69 N D
-4W A M � O O s O) O OI W -4 -4— >
N -4W W N O) W w W r2 W O) co
V OD J W J W -4 -4 A to O (n O N
fA T
69 i
EA W A W 69A
(D N N 69 O fA fA fA OD J D
A N W OD A _ J OI (D V N
N N (D OD � O O O) O N O V (n
AONNWV AOO�O (n U) -4 (D O () 2
fA fA
W 69 W ((pp fA 69
O 69 W A W N co
4 A J ONDtn W 4 N W (VO A
00 W 4 O O O) O (J) A -4 O)
-4W W A W N (n ppop w O) 69 O) mO)
W -4 A 00 -4 W -4 -4A co O O O r
fA lfl
N 69 �p
(D 69 S�)t A -4W N
A (O N O 69 O 69 w EA V
W (n .'W O A V V W (D (O N 3
A O W (O W O W O) (D (A A A OI
O W N O) O N A N 00 W fA O) W
V (O (D V W O V A t O O 0 NW)
fA (A
N 69 f�pp
4 (A A A W 69 N O
to (D m - A O W N W 4&9
(VD !� L
Ul
W i W W O WN -+ O W W 0 A A W(D Z
-4 -4 J W (I -4 O W k '0 O 2W m
V _
A
O 0) A W N_ W -4co 00 N 0) N Of W Oo O O N N W L
N (n N (O 00 O J O N ID OD OD OD A C
A OD N O -4 N DI (n O -40 -4 CD A i
O O) (D 0) W J J O O) V A O O O -<
fA
N W 69
AW A Vi 69
WAWW
CN EA (A W (A (A W
N -4 j PI) N co C (n -N— -4 OA — O N (D OD OD 00
40O WODJO OA0) O Inn (.n OD a) V O W
A -i
Cl)
W (� m
N 69 �) W A 4 W N 14. fA to W w m
00 OD 0 W -N N N W N fA O) 3
W O O A O) W W 00 O O N N A p
A7 A N — A O W O J (O OD 00 m W
A A DI (A al N (n (P O j O -4fA j (D W m
W N PI) A OD W N -40 -4 A O W N .il
N — n
(OD -4 W O O N N W (Wn W �
O (n O Of W J W N 00 O O N N (D 0
00 V w O) O O OI O O J O OD OD m V (n m
-4 A N W N A
N W V (D W (n J 0 J A O O) co it