5.b) Treasurer's Report (June 30, 2013) . S . b�
�� �
��� ' - ;�-,
.d+4� L;
�+C�i►�TI�IA
City of Scandia
Treasurer's Report
June 30, 2013
Beginning Balance 06/O1/2013 $2,155,857.86
Receipts 10,142,24
Expenditures $ 109,022.79
Payroll 23,105.86 - 132,128.65
Adjustments: Safe Box -35.00
Ending Balance 06/30/2013 $2,033,836.45
Submitted by: Colleen Firkus, Treasurer
CITY OF SCANDIA
Expenditure Summary
June 2013
2013 2013 June 2013 %ofYTD
YTD Budget YTD Amt MTD Amt YTD Balance Budget
GENERALFUND
Administration&Finance $384,931.00 $177,690.53 $22,475.82 $207,240.47 46.16%
City Council $19,861.00 $4,582.76 $0.00 $15,278.24 23.07%
Elections $470.00 $470.00 $0.00 $0.00 100.00%
Planning 8�Building $68,796.00 $54,845.13 $13,704.25 $13,950.87 79.72%
Police $118,759.00 -$60,801.46 $0.00 $179,560.46 -51.20%
Fire Dept $324,467.00 $86,391.02 $12,818.58 $238,075.98 26.63%
Public Works $908,842.00 $255,828.33 $73,153.51 $653,013.67 28.15%
Sewer $0.00 $0.00 $0.00 $0.00 0.00%
Parks&Recreation $66,323.00 $21,296.94 $3,803.29 $45,026.06 32.11%
Community Center $40,188.00 $16,723.21 $2,618.45 $23,464.79 41.61%
Total GENERAL FUND $1,932,637.00 $557,026.46 $128,573.90 $1,375,610.54 28.82%
DEBT SERVICE
BLACKTOP PROJECT 2007 $160,619.00 $12,809.38 $0.00 $147,809.62 7.98%
FIREHALL/PUBLIC WORKS BOND $112,875.00 $6,437.50 $0.00 $106,437.50 5.70%
2010 EQUIPMENT CERTIFICATES $44,440.00 $42,480.00 $0.00 $1,960.00 95.59%
2011 EQUIPMENT CERTIFICATES $34,200.00 $2,100.00 $2,100.00 $32,100.00 6.14%
Total Debt Service $352,134.00 $63,826.88 $2,100.00 $288,307.12 28.85%
CAPITAL IMPROVEMENTS $30,000.00 $4,018.21 $4,01821 $25,981.79 13.39%
PARK CAPITAL IMPROVEMENTS $103,000.00 $1,450.00 $1,450.00 $101,550.00 1.41%
EQUIPMENT REPLACEMENT $300,000.00 $0.00 $0.00 $300,000.00 0.00%
201 SEWER FUND $51,615.00 $27,665.71 $1,383.03 $23,949.29 53.60%
UPTOWN SEWER $20,618.00 $740.89 $721.72 $19,877.11 3.59%
Report Total $2,790,004.00 $654,728.15 $132,128.65 $2,135,275.85 23.47%
00 � � A �P � W W W W -� �l
� N N � � � N —� O � � Z
cn v � p D D fmJ TmJ T W m �
� O cn c � � c c m n m
m � -� .v -v = � `�, .._;
� � '�T' z � � z z E -�v � ��}q
� m � � � -D -� -� v �,
o � � � � c� c�
O N
D � � � � � W o w
r � � -� c� ���
n T � �
� � � � j`��.':
Z � � W
O
Z
�
mn
z �
v =
v► � � o0
N � D � D
� tn t� rfl En c� 3 r
� rn c�n � nNi �» w c� ao � � C p Z
Vf N J U7 � CO CTt � N W N
cc -� cn o iv w � �o cn a� o D -Z-� n
O�D N v CO O N � O O�D � � �N � = N
� � �
N m
<f� ffl Efl EA EA EA � �
� C�O �J � N C�O C�7i � N W C�It C
� �
� �
O A � O�o ONo � O ffl A O�o � A �
01 �1 N �l O N � O 00 � N '�
EA Efl
N EA Efl tfl 1fl Efl Ef�
3
t�D (�D '.� N N � v N W A O�D D
A v �W A W � W O CD C�T A � 2
b'/ EA
N ffl fA ff� EA EA Efl
N N N � N O
A O ffl CJ7 N fA �l Efl �l W 6> D
W O N 00 N CO �I N � —� N �
� �
V N �N � (WO O � 4fl � � CJO �
� N W A W � W O CO �J Vt O r
d'!
N f� tfl ffl (fl Efl Efl Efl
� � N N CO
CT� (O ffl Ut N EA �l �l W CO
<7f A N N N CO W � � N 3
00 � � N W .P (T Efl 00 �I N
O�D � � O�D W � (�J� O CO � C�fl O �
�
N Efl ffl fA fA ffl Efl Efl
O � N N W
W 00 f� CJ� N Efl �1 �1 W �1
W (O W A N �I W � � A. C
OD CO N O W (O U7 !A 00 J O Z
�I CJt Oo N CO CTt � EA � CO W
N � 00 O W � Ut O Cfl �I CT A I'17