5.b) Treasurer's ReportISM
• r - -
owl 1-7
C1 u 1 DI 1
Beginning Balance 11 /01 /2015
Receipts
Expenditures
Payroll
Adjustments: Safe box fee
City of Scandia
Treasurer's Report
November 30, 2015
$ 720,708.22
$ 23.487.52
$1990,816.16
$ 38,389.96
-$744,195.74
35.00
Ending Balance 11/30/2015 $ 2,285,045.38
************************************************************************
Ending Balance includes the following Investments:
Checking * 102 $ 35,689.14
Money Market *105 - Rate .25% $ 1,621,192.44
CD *3136 — Rate .90%, 24 mo., 3/21/2017 $ 304,378.68
CD *3137 — Rate .80% 18 mo., 1/21/2017 $ 315,878.66
Total Undesignated Funds $ 2,277,138.92
Scandia EDA *6301 $ 2,895.47
Childers Credit, Savings *3110 — Rate .05% $ 5,010.99
Total Designated Funds $ 7,906.46
Total Funds S 2,285,045.38
Submitted by: Colleen Firkus, Treasurer
GENERALFUND
Administration & Finance
City Council
Elections
Planning & Building
Police
Fire Dept
Public Works
Parks & Recreation
Community Center
Total GENERAL FUND
EDA
DEBT SERVICE
BLACKTOP PROJECCT 2007
2010 EQUIPMENT CERTIFICATES
2011 EQUIPMENT CERTIFICATES
2013 EQUIPMENT CERTIFICATES
2015 EQUIPMENT CERTIFICATE
Total Debt Service
CAPITAL IMPROVEMENTS
PARK CAPITAL IMPROVEMENTS
EQUIPMENT REPLACEMENT
LOCAL ROAD IMPROVEMENT FUND
201 SEWER FUND
UPTOWN SEWER
CITY OF SCANDIA
Expenditure Summary
December 2015
2015
2015
December
2015
% of YTD
YTD Budget
YTD Amt
MTD Amt
YTD Balance
Budget
$361,667.00
$299,900.68
$7,642.47
$61,766.32
82.92%
$20,121.00
$15,002.70
$0.00
$5,118.30
74.56%
$470.00
$1,172.37
$0.00
-$702.37
249.44%
$71,700.00
$87,636.78
$0.00
-$15,936.78
122.23%
$111,105.00
$56,668.77
$0.00
$54,436.23
51.00%
$282,865.00
$161,774.85
$0.00
$121,090.15
57.19%
$1,164,327.00
$986,172.51
$7,737.70
$178,154.49
84.70%
$62,246.00
$43,443.30
$193.89
$18,802.70
69.79%
$39,479.00
$31,904.13
$0.00
$7,574.87
80.81 %
$2,113,980.00 $1,683,676.09 $15,574.060 $430,303.91 79.64%
$5,000.00 $365.00 $0.00 $4,635.00 7.30%
$140,188.00
$390,187.50
$0.00
-$249,999.50
278.33%
$42,080.00
$42,080.00
$0.00
$0.00
100.00%
$32,310.00
$32,310.00
$0.00
$0.00
100.00%
$66,020.00
$61,550.00
$0.00
$4,470.00
93.23%
$0.00
$2,000.00
$0.00
-$2,000.00
0.00%
$280,598.00
$528,027.50
$0.00
-$247,529.50
$412,000.00
$9,137.20
$0.00
$402,862.80
2.22%
$36,000.00
$42,416.18
$0.00
-$6,416.18
117.82%
$230,000.00
$214,938.00
$0.00
$15,062.00
93.45%
$550,000.00
$585,082.64
$0.00
-$35,082.64
106.38%
$62,170.00
$158,804.09
$1,002.85
-$96,634.09
255.44%
$19,323.00
$10,639.82
$246.40
$8,683.18
55.06%
Report Total $3,709,071.00 $3,233,186.52 $16,823.31 $475,884.48 87.17%
m m m A A A A !� � c w N -n2N N W m A O2 m W N O OV K) Z
m c N r m m (i m m m m T W m p
cn m o O O D D 0 O D 0 35y O z
c� 0 c � � c c c c m
O D 3 n D D
m O z m z z z z C r
m m 0 0 C N
O m m m m m ca o hac,
m m m m m m r J
'o n cn
00
m m 0 0 0 0
m 9 D D D D X
z (m/7 (m/7 (mA N W
O
z
0
mD
z
o=
4604 W 69 C O D
rf W A N (A N m D 3 r
A f0 N N A bi w (A fA 69 m O C O z
W W EA W V (0 V m N <0 O] J (A (0 z
V � 0 V J � O m � O A N O V ID � 1
W m O 0 03 j V W m N 2 m
cn N (D A O Lt W (0 cn N V O Ot
fA <A -n
w m
69 fA w w A N (A N 69 N M
- 69 CD m � -
W 9) N (O V) J N(0
CaV OD WO O O (P w V J
N J OD (O m W m
V m V OD J W S
V V A OD O ut O N j
N �
fA 69 W A W N A
A 01 (mil ONo A : U1 (0fA 69 � N D
N N m m O O m O (n O V (n
N O m N W N m m m (D m (A m m m n
A (n N m V W V V A m O O N O S
N (A
W fA fA (Aq 69 69
W w N CD 69 N fT (A fA EA (A v cW0 D
V A w J 00 m J m (D m A
00 w V O (D _ m O Ut A V m ,-p
V OD co A W N ' N 00 m m 69 m m
00 V A co V W V V A (D O O O T ,
EA (A
N (A 69 69 fA 69
(D 69 N A W N
CAJ f0 (T O (A O (A (A (A J
(n O A J _ V W (0 (O yi N 3
A O Cl) (D W o m m (D (n A m
V W Ov NvWW AAOO -<
yA 69
N fA fA fA to fA
VD w VI j fA O (A 0 ( (A w V m
00 A m A N N W t0 (O ((AA C
N m 00 O N O OD m Cn A A w Z
W J N W m O CJ A m W WW N J J V W N V O m A O O m W m
N
A
O m A W W J
00 00 m m j N W 01 V
OI m N 50 N m W m O O N N W C
N 0 N m CO O J O N (D OD OD m A r
O m W 00f V W v v O OVI J A O 601 O j
!`D cA (A (A fA vD EA (A D
V 60
N 49 (A w w A_
C
(W N W m fA W
WW N V V Ln m W O O N N (D
A N J O A O N (0 m m OJ
coNAWODvO OA wO O (n (n OD CDV O Ol C A
y
(A 6 y
w
id (A (A 69 A fA W N fA fA W fJ m
00 m EA m N N W m fA m
W O O A W m W OD O O N N A W
N A N— A O W O v (0 co co w W m
W N N A coNW N V O j OV A O m N m
N 0
t0 w m W N
W J m O O N N W m m O
O (A O m W V m N m O O N N (0 o
00 J Cl) m O O (n O O J (O m m co V m
cn V A N V1 N A O O O J OD A
N W V (0 W U• V O J A O m OJ A
z
N 0
co m ut N O W N J
m N W 0J J N OD O O 0 N m
O W V A V O V O O V N m V co J m
(n (mn D.
co W W W O O 14 m A O W m N M