5.b) Treasurer's Report , �. �)
.�'� ,�<:
��ANDIA.
City of Scandia
Treasurer's Report
December 31, 2012
Beginning Balance 12/O1/2012 $1,769,463.33
Receipts 1,013,542.03
Expenditures $ 139,001.49
Payroll 23,078.41 - 162,079.90
Adjustments: Property Tax Adjustment -13,356.45
Childers Credit 5,000.50
Duplicate Receipt -1,298.22
Ending Balance 12/31/2012 $ 1,769,463.33
Submitted by: Colleen Firkus, Treasurer
,
SCANDIA, MN
Expenditure Summary
Current Period: December 2012
2012 2012 December 2012 %of
YTD Budget YTD Amt MTD Amt YTD Balance Budget
GENERALFUND
Administration 8�Finance $374,986.00 $380,655.53 $25,299.39 -$5,669.53 101.51%
City Council $17,839.00 $13,564.60 $410.32 $4,274.40 76.04%
Elections $5,370.00 $6,034.71 $0.00 -$664.71 112.38%
Planning�Building $150,061.00 $278,820.58 $30,435.25 -$128,759.58 185.80%
Police $116,560.00 $56,371.79 $0.00 $60,188.21 48.36%
Fire Dept $294,447.00 $228,610.95 $30,556.88 $65,836.05 77.64%
Public Works $798,101.00 $720,010.78 $51,816.69 $78,090.22 90.22%
Sewer $0.00 $13.56 $0.00 -$13.56 0.00%
Parks&Recreation $50,982.00 $46,221.70 $2,598.63 $4,760.30 90.66%
Community Center $48,164.00 $39,791.77 $2,136.41 $8,372.23 82.62%
Total GENERAL FUND $1,856,510.00 $1,770,095.97 $143,253.57 $86,414.03 95.35%
DEBT SERVICE
Blacktop Project 2007 $165,850.00 $165,850.00 $0.00 $0.00 100.00%
Fire Hall/Public Works Bond $116,675.00 $116,675.00 $0.00 $0.00 100.00%
Equipment Certificate 2010 $80,425.00 $82,532.71 $0.00 -$2,107.71 102.62%
Total DEBT SERVICE $362,950.00 $365,057.71 $295,895.21 -$2,107.71 100.58%
CAPITAL IMPROVEMENTS $99,601.00 $99,601.00 $0.00 $0.00 100.00%
PARK CAPITAL IMPROVEMENTS $4,000.00 $3,574.50 $3,500.00 $425.50 89.36%
EQUIPMENT REPLACEMENT $0.00 $93,913.28 $0.00 -$93,913.28 0.00%
201 SEWER FUND $61,360.00 $83,190.47 $4,024.39 -$21,830.47 135.58%
UPTOWN SEWER $109,584.00 $165,125.03 $5,875.99 -$55,541.03 150.68%
Report Total $2,494,005.00 $2,580,557.96 5156,653.95 -$86,552.96 103.47%
Oo OI T A A A A � � (� 0 �I
� N N � A fOi1 � � O V =
��i, � ; p a a a A � � m �
z O m � x � � � = n m 1-.
� z � m > � D m � p � ��.
Z D
.a m � -+ � '� � � � N ��
A v � � c�
O p
D � � � O � � � w
r � � � � �
m � � � �'�-;
z � �n
�
z
o �
s
vi
N �
U� �(� N �WA � N � N N Z O Dr
OA O N N � ONf �l (T V C O y
O O �p t0 tN0 �A O UOi W V N(� O � =A
N V O 01 W OD �l N � c0 A (11 � =T
y
N � m
�+W � �+ fA N � N O �
� A O(,J tW0 NpD y� � v (Nl� A C
W O (�T Ol N A O (�T W v N(� O�o .�
OD �J N A �I Oo J N � t0 A �l �
M
N fA fA � EA � di fR
� W N � N V JW O N �
�
iwJ� N O A O OWi O Uoi O�o O�o W OND S
N
N d/ fA M fA fA FA (A
O fA fA N Oo
+ Ap� � � � N v m O O�f D
T A (�l� O�D 0� � fA O � Oai V O 9
�
o t0 W (n O � O A Oe 0� W A r
N
� � � � � � �
iD di fA N Oo
W O� �O Oo j � N �1 N
O! A N W N �I O A Of ;
W A � � ONo W fA O c�0 W A � D
{w �D � O O� O A Oo O O W �
N
� � � � � � �
mN iq N d+ N O!
O N � Oo � N V O A W L
C
� N A fN0 W W Ni O (�O � A O�i =
A O1 10 O R� O A Oo Oo A T
N FA
N � (q � � � � N A
O O�o �1 � � N � tW0 O W W �—
(J� (A,J C
t�p O A A O OWl O (�T t�0 v N O �
N (A
N fR �q � fR fR fA fA J �
V t�0 t�D O�i � N � t�(''�O� O W N C
N N W U�i 0� W fA O Ou N W A H
W U� V O O� O (1� t0 �l N O �
N
M m
N fR fR fA (A iR fA fA 1
N ONf V � � � �o W W O N m
Ap A w N t0 O W U1 �
A (NT � W O OWi O UOi t�0 v N V .�
N �
tV0 O O N + N � � O A N 1
�
W W Oo O N t0 � (n (.n tD N m
VI N V N 0� W O Oo N N �l m
OI (T Of OD O T O U� t0 �I O O �
_<
fll
1�0 V N N � N � N N A � �
m
� rn � � o n°'i o v�i � � c�ii o A
O
m
^' '' m
+ J (l� � � W p Oe A O ;
NW OD AA 10 (J� A N O O �
+ A N A ONo OWI O N O�o O V �1
N �l W N O N O 0) W Ol t0 (J�