5.b) Treasurer's Report (December 31, 2011) � �
i..)� . . .., �iL.i .
1'
City of Scandia
Treasurer's Report
December 31, 2011
Beginning Balance 12/Ol/2011 $1,872,065.89
Receipts 1,077,320.92
Expenditures $ 240,39822
Payroll 19,959.61 - 260,357.83
Adjustments: Health Ins. Overcharge Credited +421.00
Ending Balance 11/30/2011 $ 2,689,449.98
Submitted by: Colleen Firkus, Treasurer
CITY OF SCANDIA
Expenditure Surnmary
December 2011
2011 2011 December 2011 %of
YTD Budget YTD Amt MTD Amt YTD Balance Budget
GENERALFUND
Administration 8 Finance $348,400.00 $306,442.39 $20,435.19 $41,957.61 87.96%
City Council $20,289.00 $19,533.16 $0.00 $755.84 96.27%
Elections $470.00 $470.00 $0.00 $0.00 100.00%
Planning&Building $332,808.00 $331,076.75 $85,179.16 $1,731.25 99.48%
Police $123,307.00 $57,396.81 $0.00 $65,910.19 46.55%
Fire Dept $342,769.20 $295,553.97 $78,001.13 $47,215.23 86.23%
Public Works $665,697.00 $591,096.33 $66,623.59 $74,600.67 88.79%
Sewer $23,042.00 $21,417.24 $49.33 $1,624.76 92.95%
Parks&Recreation $55,882.00 $51,155.03 $3,955.05 $4,726.97 91.54%
Community Center $53,777.00 $56,205.75 $2,359.48 -$2,428.75 104.52%
Tot81 GENERAL FUND $1,966,441.20 $1,730,347.43 $256,602.93 $236,093.77 87.99%
DEBT SERVICE
Blacktop Project2007 $170,980.00 $170,980.00 $0.00 $0.00 100.00%
Fire HaIl/Public Works Bond $115,143.00 $115,143.00 $0.00 $0.50 100.00%
EquipmentCertificates $40,000.00 $8,599.55 $0.00 $31,400.45 21.50%
Total DEBT SERVICE $326,123.00 $294,722.55 $258,061.25 $31,400.95 9.63%
CAPITAL IMPROVEMENTS $18,000.00 $546.12 $0.00 $17,453.88 3.03%
PARK CAPITAL IMPROVEMENTS $14,300.00 $5,478.50 $0.00 $8,821.50 38.31%
EQUIPMENT REPLACEMENT $238,476.00 $36,975.64 $0.00 $201,500.36 15.50%
201 SEWER FUND $63,508.00 $35,877.27 $434.91 $27,630.73 56.49%
Report Total $2,626,848.20 a2,103,947.01 $257,037.84 $522,901.19 80.09%
O) � A A A A W W W �1
� N � A W O � 0 O O C
cmi� N p D D D f.m� T m � �
� � � � � � � m n m
=i �
ce � m D c r m � p D �
,��j Z � ,ZDj � Z C � r
O � � { � � � N ��
� � A � � C O N �
-1 � Z1 p m� m oJ p
r � � � n � �.,,
n � T �
m � � O h�;
D
m � �
z � cn
� W
0
z
0
mn
D
vi
O po
N �- T D
m m rn o cn rn o � w D Z n
� � c�i, � ao o w a m c�'o � =m
V N N O N �I OJ O �I OD j V)
'�1
� � m
in � � � � o �
N � �I (O -+ 00 �1 W W �
t0 N �I O� Ui U� O (1� A D
A W O�D A 0� O t�0 A V r �
O V !D W N �I N O �1 N �
� .� � � � m 3
� w .c°Di, c°on cn .°�° � rn oJo p
�I ? O j W OD (7� 01 aD W �
[A71 O�D O J �I � N � (�11 W=
�1 W
� W O � A J � � m D
A N W N � O (�Tt N (�Jl � �
r"0
N OD OJ J O �I N � (T A f
O) J
W (D W OD Oo � � W
w r.� � w w �t � ao v 3
�+ w rn c°�n � o c�'i� c�'i, m p D
tf� (O �I J N O (l� N -�
V N �I
N t�D � UWi t0 � � O�D L
C
m m j c�D A O (�i+ (�Ti O�i � 2
t0 N W Oo �l N O (n O ITI
N
V N W N N N W
� (O � (�l� f0 � W N N (D L
W W O (P OD 00 00 N O � (O C
O�D � N W O�D � N N O (O OJD �
N � � � D
C
0� � � (AT f0 W W N N O G�
r w Oai c�0 A O o .NA O � � VJ
V -+ W W OD �l N N O t0 W -i
N
m
N �
OND W (O A O N v � m
�I (O (1� N � �I N N � �
� � A (�D A O O A O � A m
O f0 O W W �1 N N O (O O .Z1
N �
j N (J N N N W ..�
0� O A O � N V W O
N OD OI Ut N � �I N N t0 W
(pJ� cn cn bo 0o ao .� o � m
W A � W W � N N O (D � .77
Z
O
m
N W (�11 (A11 N W �I � N (�JI �
m
V (O U�i W OAD � N N (Np O W .71
�
m
N (�
Oi N W N N W m
� O W N N � N V (Nn A �
A O � U1 W OD O m W (1i (1� m
fT W OD t0 A O Ui W J N �
O V A W W J N A (O A W A