5.b) Treasurer's Report�l(.:ANDIA
Beginning Balance 08/01/2014
Receipts
Expenditures
Payroll
City of Scandia
Treasurer's Report
August 31, 2014
$ 329,173.10
$ 24,534.15
$ 3,413,311.82
$ 26,648.01
-$ 353.707.25
Adjustments: Transfer Charges* $ -8.00
Service Charges* $ -23.25
*Account fell below minimum daily balance.
Ending Balance 8/31/2014 $ 3,086,221.33
*********************************************************
Ending Balance includes the following Investments:
Money Market - Rate .25%
Scandia EDA
Savings *3110 — Rate .05%
CD *3134 —Rate .40%, 18 mo., 8/05/2015
CD *3136 — Rate .50%, 24 mo., 3/21/2015
CD *3137 — Rate .40% 18 mo., 7/21/2015
Submitted by: Colleen Firkus, Treasurer
$ 2,310,508.16
$ 500.00
$ 5,007.86 (Childers Credit)
$ 124,673.38 (Quinnell)
$ 301,882.80
$ 313,989.89
GENERALFUND
Administration & Finance
City Council
Elections
Planning & Building
Police
Fire Dept.
Public Works
Sewer
Parks & Recreation
Community Center
Total GENERAL FUND
DEBT SERVICE
BLACKTOP PROJECT 2007
FIREHALUPUBLIC WORKS BOND
2010 EQUIPMENT CERTIFICATES
2011 EQUIPMENT CERTIFICATES
2013 EQUIPMENT CERTIFICATES
Total Debt Service
CAPITAL IMPROVEMENTS
PARK CAPITAL IMPROVEMENTS
EQUIPMENT REPLACEMENT
201 SEWER FUND
UPTOWN SEWER
CITY OF SCANDIA
Expense Summary
August 2014
2014
2014
August
2014
% of YTD
YTD Budget
YTD Amt
MTD Amt
YTD Balance
Budget
$344,543.00
$204,501.09
$21,660.23
$140,041.91
59.35%
$18,839.00
$9,505.82
$0.00
$9,333.18
50.46%
$6,110.00
$3,344.18
$2,021.94
$2,765.82
54.73%
$166,200.00
$41,554.39
$9,593.34
$124,645.61
25.00%
$122,068.00
$58,460.80
$58,151.06
$63,607.20
47.89%
$309,404.00
$165,603.75
$9,112.87
$143,800.25
53.52%
$1,076,097.00
$849,249.21
$224,853.68
$226,847.79
78.92%
$0.00
$0.00
$0.00
$0.00
0.00%
$56,031.00
$34,158.71
$3,007.18
$21,872.29
60.96%
$39,707.00
$23,062.97
$4,556.82
$16,644.03
58.08%
$2,138,999.00 $1,389,440.92 $332,957.12 $749,558.08 64.96%
$150,388.00 $10,193.75
$41,640.00 $1,315.00
$43,330.00 $43,330.00
$33,300.00 $1,650.00
$66,460.00 $61,335.00
$335,118.00 $117,823.75
$0.00 $140,194.25
$0.00 $40,325.00
$0.00 $0.00
$0.00 $31,650.00
$0.00 $5,125.00
$0.00 $217,294.25
$68,250.00
$13,464.69
$0.00
$54,785.31
$47,500.00
$9,928.69
$0.00
$37,571.31
$200,000.00
$109,280.10
$0.00
$90,719.90
$173,096.00
$48,620.81
$17,201.93
$124,475.19
$20,680.00
$7,837.48
$850.36
$12,842.52
6.78%
3.16%
100.00%
4.95%
92.29%
19.73%
20.90%
54.64%
28.09%
37.90%
Report Total $2,983,643.00 $1,696,396.44 $351,009.41 $1,287,246.56 56.86%
C7 O) O) A A A A W W W W W N T
m c N r m Tn m m m T W m O p
(D v O 0 D a D 0 0 p s- o m
o -4 n c X T c c c m D z
p * m r n D 3 3 D 1 m
N m O z 3 z z z [ r
1 m A 0
00 m m A A m m m c
r �
r A A A A A 0 A
$ O
1 -➢i -Di
71
z � N y W
O
z
O
m�
zN
ox
wOw
L 0 a
> 3
r
Z z
N V 0 IV W> O oD OD W W W OD co a -.40 m
a (On m o 0 N UNi o o V o N < 2 W
T
N m
t� fA fA fA fA EA �
A W V A o N 9D N C
O OJ W V A N N W 0 J N 0
N O pp m � V pp N N N J 0 J O
A N O A A G7 N O A 0 G7 W �
M 69
N � Vi Hi EA Hi f9 >
A W Vi N O N EA N 69 fA fA �> W 3
W A 0 O W V W 0 W m W O p
Ol N N V7 O N A O A N O V 2
b VI
N di di to di (A Hi
V N O N 69 N O
� J S9 00 O N EA > 69 69 69 > O O a
A A W V O N V V N W m do V S
V 0) NO O 0 C7
O 00 O OD O CO A co O 0 0 0 A r
fA
N V3 ffl fA fA EA EA fA
O ao Hi aD O N Efl N fA fA 0 O
t0 (O ON O 4l (O >_ 4P
O N V co
N O A (WT
tl1
N EA fA fA EA (fl Efl f9
V V 0 V O W p W
fW0 W O O 000 O co
fM
W
W 0 (00 W (O > A N O .OND D O 9 C
W w 00 OD O O IJ O IV 0 W
� O W fT V (T Ol 0 Oi O W O 0 r
M ffl
pOD N � J pN � fA ONS N � N W N (Nli C
W W W O (O .P O OO OD O yy V C
w (VO (NI J N W (0T co W W N 0) N 0 O