5.b) Treasurer's Report (September 30, 2012) `
"�',�,r:.=�� ��• ^,''":.
������
City of Scandia
Treasurer's Report
September 30, 2012
Beginning Balance 09/O 1/2012 $2,467,081.92
Receipts 98,930.64
Expenditures $ 119,166.80
Payroll 22,842.86 - 142,009.66
Adj ustments:
Ending Balance 09/30/2012 $ 2,424,002.90
Submitted by: Colleen Firkus, Treasurer
CITY OF SCANDIA
Expenditure Summary
September 2012
2012 2012 September 2012 %of
YTD Budget YTD Amt MTD Amt YTD Balance Budget
GENERAL FUND
Administration 8�Finance $329,725.49 $276,962.20 $34,103.46 $52,763.29 84.00%
City Council $18,839.00 $8,769.52 $0.00 $10,069.48 46.55%
Elections $5,370.00 $3,265.78 $155.49 $2,104.22 60.82%
Planning&Building $150,061.00 $222,196.35 $26,286.84 -$72,135.35 148.07%
Police $116,560.00 $56,371.79 $0.00 $60,18821 48.36%
Fire Dept $294,447.00 $167,355.92 $10,423.54 $127,091.08 56.84%
Public Works $798,277.00 $552,100.54 $39,303.14 $246,176.46 69.16%
Sewer $0.00 $13.35 $0.00 -$13.35 0.00%
Parks&Recreation $50,982.00 $38,021.72 $8,274.69 $12,960.28 74.58%
Community Center $48,164.00 $32,238.64 $2,715.32 $15,925.36 66.94%
Total GENERAL FUND $1,812,425.49 $1,357,295.81 $121,262.48 $455,129.68 74.89%
DEBT SERVICE
Blacktop Project 2007 $165,850.00 $15,425.00 $0.00 $150,425.00 9.30%
Fire Hall/Public Works Bond $116,675.00 $8,337.50 $0.00 $108,337.50 7.15%
Equipment Certificate 2010 $80,425.00 $45,400.00 $0.00 $35,025.00 56.45%
Total DEBT SERVICE $362,950.00 $66,682.50 $0.00 $293,787.50 24.30%
CAPITAL IMPROVEMENTS $99,601.00 $99,601.00 $0.00 $0.00 100.00%
PARK CAPITAL IMPROVEMENTS $4,000.00 $0.00 $0.00 $4,000.00 0.00%
EQUIPMENT REPLACEMENT $0.00 $93,913.28 $0.00 -$93,913.28 0.00%
201 SEWER FUND $61,360.00 $61,880.79 $4,394.53 -$520.79 100.85%
UPTOWN SEWER $109,584.00 $33,124.07 $16,359.14 $76,459.93 30.23%
Report Total $2,449,920.49 $1,714,977.45 $142,016.15 $734,943.04 70.00%
� � c� � rn �n o � o c� w �n a
W � M N OD O EA M aO 1� f� N sF
m N N � b CO O> N CO �A f� �
W m M N � � 69 N n � N �
aEA fA EA EA EA f�9 fA N
W �
�
H O N I� O� �A O t0 O f� N eO
y � t'7 N t0 O fA f7 00 � fh N N
� O N tn tn CO Q� N (O � f� h
� O M N � � fA N � EA � �
Q fA 69 EA (i9 d9 b9 N
G9 y�
} O N 1� � � O (O O �7 � O Of
�J st M N OD O b9 M 00 W �A tn O
� f") N � ln (O � N h N 1� M
' CO O M M a0 N N 0�0 W � N
� dM9 � � t9 � d�9 fA � EA �
N
� p
W V' � 00 V' O fD O � (O V� �
Z f0 � � fA 00 � � N N n N �
-�j � '�Y O N N N 0�0 a�0 'R N
6�9 � (A b9 � � fA � fi9 �
�
a V O�i aM- fA a�D � m N � O> CO O>
� N ,7 O N � '0' a0 O�i C�O M
69 � Vf fA � 69 69 � b9 �
W
J � M CO CO er O CO O � M Q� O
f� CO � O EA M c0 CO Y) 7 10
� O C� st fA CO � N OO � CO �
a
a � M � N N 'at � m C�O N
� E�A fA fA � fA V� � H9 N
�
= aD M OD aO ln O (O O � O N 1[f
V � cr'� v � � � rn N � � � a
a � M � N N est- .�- ' 0�0 t0
� b�9 6N9 69 6N9 � 69 V) � N
�
} 1� a � CO N 1� 00 � � N h CO
� tO ln 1� c'� � O � N (O LL7 O M
Q O �f'7 M � O e0 a0 c0 M � OD t0
� C�0 N � N � N � 0�0 � OD
m � � � � � d9 fR 69 N
LL � �
t�_
U� � � � O� CO N t� 00 M CO O h 1p
Z C�O � M � O 0�0 � � O � C�0_ O�i
�� � I� � f� CO � N � O � O
m O ' N 6N9 ff1 � � � � � N
ff3 y�
��
Q�
U
0
Z
O
m
N �"
Y � W
, ,i.� �
Q �
��
�i: O U � U
�.(� � lL d
� N � � � g �
o �
N N � V a � � � � O
�Q a � F- w
/, u a � z � � z � u�
t,��{� a ° Q � � � Q � � z �
-.yr � Y = a ¢ H V w � O
W U � U Y a v> O �
w
Z C� m � �w U u�i a w N � w
� O O � � O O O O O N O
LL M c�7 M � sf � � c0 c0 00