5.b) Treasurer's ReportSCAN DIA
Beginning Balance 06/01/2014
Receipts
Expenditures
Payroll
City of Scandia
Treasurer's Report
June 30, 2014
$ 169,120.27
$ 24.659.89
Adjustments: Transfer Charges recorded
Ending Balance 6/30/2014
$ 2,600,911.82
$ 31 875.83
-$193,780.16
M
$ 2,439,015.49
*********************************************************
Ending Balance includes the following Investments:
Money Market - Rate .25% $ 1,674,140.99
Savings *3110 — Rate .05% $ 5,005.86 (Childers Credit)
CD *3134 — Rate .40%, 18 mo., 8/05/2015 $ 124,547.81 (Quinnell)
CD *3136 — Rate .50%, 24 mo., 3/21/2015 $ 301,882.80
CD *3137 — Rate .40% 18 mo., 7/21/2015 $ 313,677.07
Submitted by: Colleen Firkus, Treasurer
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
FIREHALLIPUBLIC WORKS BOND
2010 EQUIPMENT CERTIFICATES
2011 EQUIPMENT CERTIFICATES
2013 EQUIPMENT CERTIFICATES
Total Debt Service
CITY OF SCANDIA
Expense Summary
June 2014
2014 2014 June 2014 % of YTD
YTD Budget YTD Amt MTD Amt YTD Balance Budget
$344,543.00 $160,629.95 $45,164.69 $183,913.05 46.62%
$18,839.00
$68,250.00
$4,916.77
$0.00
$0.00
19.73%
$13,92223
$47,500.00
26.10%
$41,640.00
$6,110.00
$820.00
$1,322.24
$820.00
$852.24
$40,820.00
$4,787.76
1.97%
21.64%
$172,096.00
$166,200.00
$7,009.73
$16,698.64
12.93%
$9,981.02
$20,680.00
$149,501.36
$33,300.00
10.05%
$1,650.00
$122,068.00
$1,650.00
$309.74
$31,650.00
$0.00
4.95%
$121,758.26
0.25%
$309,404.00
$159,726.78
$11,735.44
$149,677.22
51.62%
$1,076,097.00
$574,036.57
$124,200.01
$502,060.43
53.34%
$0.00
$0.00
$0.00
$0.00
0.00%
$56,031.00
$27,232.37
$3,870.51
$28,798.63
48.60%
$39,707.00
$16,413.66
$1,778.50
$23,293.34
41.34%
$2,138,999.00 $961,286.72 $197,582.41 $1,177,712.28 44.94%
$150,388.00
$68,250.00
$10,193.75
$0.00
$10,193.75
19.73%
$140,194.25
$47,500.00
6.78%
$41,640.00
$45,296.31
$820.00
EQUIPMENT REPLACEMENT
$820.00
$0.00
$40,820.00
$200,000.00
1.97%
$43,330.00
$172,096.00
$41,960.00
$7,009.73
$0.00
12.93%
$1,370.00
$20,680.00
96.84%
$33,300.00
$14,625.95
$1,650.00
Report Total
$1,650.00
$1,120,732.04
$31,650.00
$1,862,910.96
4.95%
$66,460.00
$60,840.00
$60,840.00
$5,620.00
91.54%
$335,118.00 $115,463.75 $73,503.75 $219,654.25
CAPITAL IMPROVEMENTS
$68,250.00
$13,464.69
$0.00
$54,785.31
19.73%
PARK CAPITAL IMPROVEMENTS
$47,500.00
$2,203.69
$2,203.69
$45,296.31
4.64%
EQUIPMENT REPLACEMENT
$200,000.00
$0.00
$0.00
$200,000.00
0.00%
201 SEWER FUND
$172,096.00
$22,259.14
$7,009.73
$149836.86
12.93%
UPTOWN SEWER
$20,680.00
$6,054.05
$819.83
$14,625.95
29.27%
Report Total
$2,983,643.00
$1,120,732.04
$207,615.66
$1,862,910.96
37.58%
W W O A A A A W W C
O O O O O O O O C
N N W O A W N > O J Z
m c N r m -o o m m m -n m () p
CO m O O D D p 0 D � r- m
0 � n c �u m c c c m D Z
M
O<
m D �_ m m m p D
-� m o Zi z Co
C o
D
A m A m m m W -14 o
r
O n
O
K m
Z Z Cn CO Cl)
O
Z
0
my
Z y
v=
vi fA c m D
W '69 69 fA W Efl i
O � 0)N (19 169 N A 2 D
A > O W �J co O W N N N O C Z
N J CSA N co (D W W CO W W 00 c0 D 1
co 0 ID co w 07 00 N d) O m 0) N CNA O O W O (A w (30= (1)
cn T
N fA w EA fA fAW
co O N 169(A N W rZi
N W 4 J A 69 N (A EA W W C
A W J A J A O CA A O) N D
O CO W J A (0 CA W (A J (A (A
A N co 0) <A J W N N N J CA J O) .�
CA O A N O A A W CA O A (A 0) W j
Im EA
N 49 EA fA [A (A {A
4 > > N m NfA N O 3
A W W O N EA N V) fA [A 0) W D
W A CA O N J W (A W 0) W O >
V m (O N O W (D J N A OD (A ()i j
W W (JA (W0 O co co - O ? m W J 2
fA w
IJ wEA [A V) 'A 69
V N O) N to N O
s J 460 W O N fA > (A EA EA > W O D
A A W J O W J V CA W 0) W J
0) co A m O W CO IJ tf W cn N O r7%
V (A O O O U) O) > O N J (A J N
O OD 0) W O W A co O Ol 0) N A (—
N fA fA EA fA EA 69 H)
0) N 0) N_ (1)(_A N O
O O1 1W co O N V3 (A EA to cn 0)
O O A CA O OD J J O > O) J > W 3
O CO Q) (A O W (D > W J N J W W
N N 0) co O m W A J J W W (fl D
O N J 0) O W A (0 (0 O A CA N W
N EA S9 H) EA w fA {A
A N W N 469 H) N J
N J 4u) co O N ffl > (A fA w -+ cn cO
J J CA J O W W J CA 0) J _ C
N co A CA O w -I _ CA -1 W J W _
W co co 0) O N OD A-4 J W W Z
O W J O O 00 0 (D (D O A (A N m m