5.b) Treasurer's Report (August 31, 2012) . ✓� /�y
i v�
»;� ��t �#..�--.�,.;
P-�; � _�-..
. _ ._ , ,
�����
City of Scandia
Treasurer's Report
August 31, 2012
Beginning Balance 08/O1/2012 $2,919,518.06
Receipts 23,751.59
Expenditures $450,865.15
Payroll 25,672.08 - 476,537.23
Adjustments:
State Surcharges cleared 349.50
Ending Balance 08/31/2012 $ 2,467,081.92
Submitted by: Colleen Firkus, Treasurer
CITY OF SCANDIA
Expenditure Summary
August 2012
2012 2012 August 2012 %of
YTD Budget YTD Amt MTD Amt YTD Balance Budget
GENERAL FUND
Administration&Finance $317,405.32 $242,858.74 $25,393.68 $74,546.58 76.51%
City Council $18,839.00 $8,769.52 $0.00 $10,069.48 46.55%
Elections $5,370.00 $3,110.29 $2,559.48 $2,259.71 57.92%
Planning 8�Building $150,061.00 $195,909.51 $83,368.15 -$45,848.51 130.55%
Police $116,560.00 $56,371.79 $56,062.43 $60,188.21 48.36%
Fire Dept $294,447.00 $156,932.38 $37,168.80 $137,514.62 53.30%
Public Works $798,277.00 $512,797.40 $237,721.69 $285,479.60 64.24%
Sewer $0.00 $13.35 $13.35 -$13.35 0.00%
Parks 8�Recreation $50,982.00 $29,747.03 $3,028.23 $21,234.97 58.35%
Community Center $48,164.00 $29,523.32 $5,817.48 $18,640.68 61.30%
Total GENERAL FUND $1,800,105.32 $1,236,033.33 $451,133.29 $564,071.99 68.66%
DEBT SERVICE
Blacktop Project 2007 $165,850.00 $15,425.00 $0.00 $150,425.00 9.30%
Fire HaII/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 $57,48626 $20,966.26 $3,873.74 93.69%
UPTOWN SEWER $109,584.00 $16,764.93 $4,431.19 $92,819.07 15.30%
Report Total $2,437,600.32 $1,572,961.30 $476,530.74 $864,639.02 64.53%
.
F- O N � � tn O Cfl O I� � M
(q � M N a0 O C7 a0 � M N N
� O N � � (O � N C� � I� �
? M O M C'�� 00 N N � a�0 a�0 c~D
. Q O M N � � N� � y� � �
� N
O N t� � � O (O O � O Q>
J M N � � C�D � N � � � M
�
' 00 M O � N .- CO f� a0 O
CO O M M a0 .-- N CO a0 a0 N
� M N � N .- �
�"' N
W �t aD a0 � O (O O � CO � �
Z C� � M � O M a0 � � � N
� (O O> � aO � N N h N �
-� M � O I� N a0 00 N O
00 � I� � � N dO 00 �Y 1p
CO N r- N .- OO
�
} ap aO O aD � O CO O �- � � �f
� � O�i <M- � a�0 � N � � � OM1
00 � O f� N � ('7 N � �O
N � 1� N � �' a0 � CO M
00 N � � r- � a-- 01
�
J � � � O�i O � M a�D a�0 � � t�C
� O M � 00 � N 00 � tp �t
a - - -
a � r�i °r�° N � � rn rn � i
ao c� r- � .- r- .- o
N
= N n C�O � O � M a�O 0�0 � u M
V � M � � � N � � I� O�
Q � O c0 t� N r- N c'� �
� M f� N .- � � OD �D
� � N � N � e-- � �
N
} I� � � CO N � OD t� � N 1� 00
� a0 � I� M � O sY N CO � O M
Q O tn M � O a0 00 a� M ' a0 t0
� a�0 N � N � M a�0 M 0�0
mO N � CV � � e- e-
W •' N
LL
(/) � tf) `� � CO N t� 00 M (O O � �
W = � O � f� M � O � � � O O
V Z Q ao �n c� � o ao ao �n o ao m
r� ui � co � ui o c o
a � Z N N � N M N � �
J � N
Q LL 'a'7 �
m �
2 Q
UW
0
Z
O
m
� F'
Y � W
:'��'��'�.� � � � W
�t � ti � V
>;�. � � � g �
:� � � -� � o � a w �
N p m V � � a � ? O
N a � a, �- � � � w F'
�`,: ¢ O Q � � � Q w � z �
.:; ' � x 2 a a F- U a w � O
W U w � U Y cn O �
o � g � � � � � a N � W
Z .- 1� O � M � (O N N •-
� O O � O O O O O e- O
tL M M M � �7 �t �Y CO (p a0