5.b) Treasurer's reportSiGANDD�
Beginning Balance 07/01/2014
Receipts
Expenditures
Payroll
Adjustments:
Ending Balance 7/31/2014
City of Scandia
Treasurer's Report
July 31, 2014
$ 215,936.79
$ 38,852.18
$ 2,439.015.49
$ 1.229,085.30
-$ 254,788.97
$ 3,413,311.82
*********************************************************
Ending Balance includes the following Investments:
Money Market - Rate .25%
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,659,956.57
$ 5,007.86 (Childers Credit)
$ 124,547.81 (Quinnell)
$ 301,882.80
$ 313,989.89
CITY OF SCANDIA
Expense Summary
July 2014
2014 2014 July 2014 % of YTD
YTD Budget YTD Amt MTD Amt YTD Balance Budget
GENERALFUND
Administration & Finance
$344,543.00
$182,840.86
$22,210.91
$161,702.14
City Council
$18,839.00
$9,505.82
$4,589.05
$9,333.18
Elections
$6,110.00
$1,322.24
$0.00
$4,787.76
Planning & Building
$166,200.00
$31,961.05
$15,262.41
$134,238.95
Police
$122,068.00
$309.74
$0.00
$121,758.26
Fire Dept.
$309,404.00
$156,490.88
-$3,235.90
$152,913.12
Public Works
$1,076,097.00
$624,395.53
$50,358.96
$451,701.47
Sewer
$0.00
$0.00
$0.00
$0.00
Parks & Recreation
$56,031.00
$31,151.53
$3,919.16
$24,879.47
Community Center
$39,707.00
$18,506.15
$2,092.49
$21,200.85
Total GENERAL FUND $2,138,999.00 $1,056,483.80 $95,197.08 $1,082,515.20
DEBT SERVICE
BLACKTOP PROJECT 2007
$150,388.00
$10,193.75
$0.00
$140,194.25
FIREHALUPUBLIC WORKS BOND
$41,640.00
$1,315.00
$1,315.00
$40,325.00
2010 EQUIPMENT CERTIFICATES
$43,330.00
$43,330.00
$1,370.00
$0.00
2011 EQUIPMENT CERTIFICATES
$33,300.00
$1,650.00
$0.00
$31,650.00
2013 EQUIPMENT CERTIFICATES
$66,460.00
$61,335.00
$495.00
$5,125.00
Total Debt Service
CAPITAL IMPROVEMENTS
PARK CAPITAL IMPROVEMENTS
EQUIPMENT REPLACEMENT
201 SEWER FUN
UPTOWN SEWER
$335,118.00 $117,823.75 $3,180.00 $217,294.25
$68,250.00 $13,464.69 $0.00 $54,785.31
$47,500.00 $9,928.69 $7,725.00 $37,571.31
$200,000.00 $109,280.10 $109,280.10 $90,719.90
$173,096.00 $31,418.88 $9,159.74 $141,677.12
$20,680.00 $6,987.12 $933.07 $13,692.88
53.07%
50.46%
21.64%
19.23%
0.25%
50.58%
58.02%
0.00%
55.60%
46.61%
49.39%
6.78%
3.16%
100.00%
4.95%
92.29%
19.73%
20.90%
54.64%
18.15%
33.79%
Report Total $2,983,643.00 $1,345,387.03 $224,654.99 $1,638,255.97 45.09%
Cb (A O A A A A W W W W W N T
Z
m c N r m v c> m m 0 55 [5; m m o
O 1 o O p x Dm c p p m y D z
o7 O M D T. -o m O m
O
N m O z z z z r
m o 1 v N
,Z1 m X O 0 0 C o N
D m m m m m W a
p n n c<
< m C7 C7 (7 p
M D D D A
m m m m m co
mm m m m co
C3
O
z
v
my
Z
ox
EA OD
W D E5
Z
O W CNO O W N N N O Z
N J CT N (A O 0 W (b W W (b (D D 1 m
000 W COT 0) O CT 0) N (Nli O O O (WJi x V>
T
N �
EA Efl EA 4fl EA �
A Cb J A V A O (T A (A N D
O l0 w J A w (T (b [T J CT CT 0)
A N (b to 4A J 4 N N N J CT J w a>
Vt O A N o A A rn cn O A cn W w <
EA Eli
N Efl Efl EA Efl EA fH
A W EA (b O N Efl N EA Efl EA �> � OW D
w Efl
N Efl Efl t.9 EA w EA
V N W N VI N O
l) (A > (P O D
A w A W J O (P J J (T w W (A J .Q
W A CT O W O _ IJ A (b Ui CT O A
V (A CO O O (T fD (O N J m J N
O 0 (A (b O fA A (O > O (T CT (T A r
N Efl fA (fl Efl EJi (fl Efl
A N (P N_ ffl Efl N O
O (lo EA (b O N EA CT Hi EA (n (A
O O A O O (b J V (T > (A V > W 3
CO CO m CT O w O > (T V m J W W
O N J 0 (31 O m N A O O O A (T N tU �
EA
N (fl EA EA EA EA EA EA
A N (P N EA V1 N J
N J 69 CIo 169m > Cn EA E) > CT O L
V V CT J O (b (b J CP
C.11 J - C
W (100 O CWT A v W Z
CO W V O O fA O O CO O A (T N (T m
EA
W
11 N N (T N W CT
)
O
W (T (O W O A CD 0 (b O (3) L
m w <n J cn cn o <n rn w O <n r