5.b) Treasurer's ReportBeginning Balance 08/01/2015
Receipts
Expenditures
Payroll
City of Scandia
Treasurer's Report
August 31, 2015
386,657.76
$ 25,130.02
$ 4,078,533.73
$ 55,577.06
-$411,787.78
Adjustments: State Surcharges +$1,162.61
Ending Balance 08/31/2015 $ 3,723,485.62
************************************************************************
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
Quinnell CD *3134 — Rate .40%, 18 mo., 8/05/2015
Scandia EDA *6301
Childers Credit, Savings *3110 — Rate .05%
Total Designated Investments
Submitted by: Colleen Firkus, Treasurer
$ 3,064,363.22
$ 303,689.76
$ 315,247.73
$ 3,683,300.71
$ 0.00
$ 2,895.47
$ 5,010.36
$ 7,905.83
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
August 2015
2015 2015 August 2015 % of YTD
YTD Budget YTD Amt MTD Amt YTD Balance Budget
$361,667.00 $211,299.51 $24,216.00 $150,367.49
$20,121.00 $10,617.94-$15.00 $9,503.06
$470.00 $300.00 $0.00 $170.00
$71,700.00 $47,789.15 $9,328.96 $23,910.85
$120,989.00 $56,668.77 $56,359.61 $64,320.23
$271,516.00 $111,549.68 $7,977.12 $159,966.32
$1,039,154.00 $826,275.83 $274,807.03 $212,878.17
$62,246.00 $31,403.18 $3,654.36 $30,842.82
$39,479.00 $20,519.31 $2,438.64 $18,959.69
$1,987,342.00 $1,316,423.37 $378,766.72 $670,918.63
$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,965.00
$0.00
$2,000.00
$0.00
-$2,000.00
$280,598.00
$113,883.75
$0.00
$166,714.25
$412,000.00
$0.00
$0.00
$412,000.00
$36,000.00
$7,215.08
$505.00
$28,784.92
$230,000.00
$0.00
$0.00
$230,000.00
$550,000.00
$209,092.82
$147,297.82
$340,907.18
$62,170.00
$32,293.67
$4,475.33
$29,876.33
$19,323.00
$7,242.72
$769.16
$12,080.28
58.42%
52.77%
63.83%
66.65%
46.84%
41.08%
79.51 %
50.45%
51.98%
66.24%
7.30%
5.42%
0.00%
100.00%
3.57%
92.48%
0.00%
0.00%
20.04%
0.00%
38.02%
51.94%
37.48%
Report Total $3,582,433.00 $1,686,516.41 $531,814.03 $1,895,916.59 47.08%
_O O O O O O O W W W W W O N O T
N N DD W A ---• U) W N O -I M Z
m C N r m -0 0 m m m m T co m G
n - OO c X T p c c O m D D z
p O m > t o _ 0 m
Z m m > r m m m m r 0 r
m o Z Z -Zi
0 m m m m m m co 0 N
r � o
N
O T T T T
m O
K m � � � �
Z W
O
z
0
4A
w w lw (A 169
w w w
�
co
V W -I vy O W
(WN N � OWi A O Uri W
�� <n IU9
a) r; co(Oo
V W A m O O UT
V 0000 -J OWO v W - v
EA
W Efl Efl Ki 69
-� fn Z s w A w
A COii W N) cn A C)
A (OT N 0) v W -4 v
40
W (co (JI N CATS EA O
4 A di v au QO
00 (A) -I O O _
coV-4 A OODD v W -I v
EA
IV 69 69 fAco 69
(A
W Un ' O A v 6-9
A O W (O W O w
O" v (NO (w0 O� W O v
m0
zN
a
O al
69 N (T D 3m r
z D
D � (D co � C O Z
e» D z m
(O (OJl - N -40
v O (N)7 = CO)
69 m
m
� N al
� C co q Ea N D
A ((D WO - (n O co
{p
fA
69
N A 3
74
W W � N
.'a
n
A ((D O O Cil 00 - m
EW
Efl �
N W
(OJT CEO o A T
OODD ((D 0) 69 0) 0) 0) M
A co O O - O - r
ffl
EA
N _
� 69 69
W o Co N
A A O O - Ut N -<
40 fp
N EH 40 69
V 69 i A A W i (A N O
w (O EA Ui j j w O EA Ut 4r.9 w O
N j N in
W U) OD O O (O (O A A (O Z
W -J N W U1 O W A W Efl Cn DD
W N �1 v v W (n �I O d) A O (Z) O) W m
EA
A
O O A
OD 00 O) O i N w U7 �l
O) d) N (O N C7 W O O O N N W L.
N U) N co w O -I O N 0 w OD OD A C
O 0) coN0 - W v v 00 0) OJ A O v 0) O
N
N ODD f!) ()IA A 69 W N N W (WT w W C
W N 4I v (J7 d) W 00 O O N N 0 Gi
A (T A_ - v O A O N) 0 w OD 00 j C
CO -J (T A N W Ut O -J O -I EA -I co in
m 0 O Ut M W O0 -1 O d) v A O - O A --I