HomeMy WebLinkAbout8.b. February 2012 Interim Financial Report City of Rsernount
Interim Financial Reports
For the Month Ending February .29, 2012`
1. Cash on Report - All Funds
2. Report of Investment by Institution
3. Estimated Cash Flow Chart — General Fund
4. Donation &Assignment Balance Worksheet
5. CIP Worksheets .
- Building CIP
- Street CIP
Equipment CIP
}
_ .6. a Income Statements
Water Fund
- Sewer Fund
- Storm Water Fund
Note: All of these reports' are . to be used in the proper
context. Some of these reports have figures that
are based'on estimates:
[ ,
r
x,
t r
t
c C
> T71�71TO T�IQ� • 'NW C y y -, - DO �•�t T T T g-tl .-�1 � T TQ D T' t =g g 6 g 0 T I m � l X 2 - 1' 2 2 2 T� 1 , M m 1 OG) -
.a E ,0--0..s.00 , "o ma 3. cco• tr c c c c 5.. ---Sc S _.-- -.-0.. oN +g.... ES- - E.G. .c R. -a C�
m asO �' aaO �'=5" . mm -m `a N ccac + c cc cc'r c c^ cc -- Tc cc ccc c cm Tm
aaaaaNaaaaaaaNyaaWNy,. ayaaaaa�ma a =D
' 0 0 0- c c m m m m m m m m m O m = 3 a m Q° a
� cccc�c 0 c AA �co3ma? cc ccccczcccccccZZcczzz Z c ccca�w c
eo aaoo',Z.Z om ,npc) 000 mo_m O moo...0 OOoomm' nlio0mo omu m m T<0V ck
< << T _ _ _ - aoa 8 m Ocm - ��Z n
ba > = =
Aaacm ... a Cab > >>>>? O »>»> > 00 >>O°° = m
3 ' aam c T m a
a T a L cT ..T
m m a aaaaa3-aanaaaaoa Daao ®o RE-42.44R444 ea0aaa Ea a 2 as aa2 c
C N N 8m88CN j O O ** C C NN p N g Q P 41444'5.. p p ,18 N 8 N N p N p N p N a N N 0 1 1 j N N Q p 0
T +
p p a - 0 a 0
+ 88 88 01888 <°o8000 qa+.� 00 8
+vOm U�m 6a ��n01 n. ztaSa WW WWWN33ww la AN N +NN I ,.. 0.1t .a
= f) T O O m t � Q .. 0 ..... v ... a 0
1 t N 8 w mT O = Se u Egg = N GGD
� 8 O + m m • D = D(7 A,m.,9 u NN mN w N a c 1
O C� +� NNN f�0 + �.
C T m
.
m5
ono .. `
O m
U (� T
8 0 0 0 0 0 0 0 0- 0) p 0 p O 0 0 0 0 0 w t p o pp 1,)(4 0 W W A W W 1 W . )t a W 4 W W W 0 N N N N N N N W N G) ) 0 0 0 A A A W W N N N O O 03 3 O p . 0 0 0 0 0 �_
O IOO 401UAWN +O 0 VUNAW NAWN+ OtDUVOIU >W N OOJUUL WN +:�. A ++ ON +O 'a' GD JOUA W N + 82 a
---
gy m. V V- WW .-....m. tO pp Oy pp l �� O 0 y O p U m a J W UN +0 A V A N >v A _t P o = ll_I • q
, t 0 .) m , f J A 8 BWOOWAU m N N Nm +AA'' V m O j tWp 0m
A J A OD s _
pp 0(�� g ' 4 y W U � J p + L0- N OU p U � � N Wp � N p W .O+ODm as
+ V N VOl A198030NN V N co ( )O 0 1 JN N We'- N8 OO . . . . . ..
. + N 0
g 8 8 U N • + W --
2 m N V A t A E N N V p+p �1pp W U • tai 484 N + N ttopp
pw
88 O 88 (y V O O 8 1' 22 00 000 8 O S V pAp 8 10 a
O m O AA p O- op WWW [.. v::m O ) PP g 0 :S V J VN A p J p t p J
8 A 8 88 V0 1 444 4 8 J N0 N8' 8W 8 1 4g8 4gS 8 m
I: ,.
s
J
+W .N. +
_ m A 0 m W0 - O momw NIJO _N N A VI NN ow A co J A _ N +t
1 + O 000 VU A N - N b 1pp1 O
�p t� 4 4 a V tp CD W O , { 4f A O IO CI U OC W t G p D U
)._
8 t0 O V8- 1, ODO �J
JV Ol 0 t w t � A wpm wo N b g41 t1 N sss r
+" + IN)1 WA +W OWtWT 0 1 0 0 I U �0 p +N Mg., N- MM N O NU tag WJW+A
0
O =
r 2 Z'
6Q n c)
'
_ A ;
cccccc m4 c H cSS Sgcc0:4 § -. ic i g cc -h g CC m s mm 15. �y
r. ccc c cc=c ccc c cc cc c c c = cc W a c ' " - �o =cccaAva 'cccv aa- m =cccc0a.'�oc NoZ
aaaaaaalaaaaaa assess- aamgiaa -fa amEiai;;�mgaTaamaaamaaaaaaaa�55 y
cccccCnWCCCCCC CCCCCCcca,R- 9rcc�. c® C xcx< mn c<ccmccc-gCCCci:ccc<g'cccgcw.2gqc
omom000ammmo om omoomomoaN N. ounm D T_ mv_ 3.a mo3 oomommz *000$rmma =`.o
c c c c c c tt c c c c c c c c c c c c c c m a + a a<< 2 c g c a S * c $ » 6 c m p c c 8 c c. A g c c c c? N c c c 3 3 c c c a 71 c 3 ..§ c
a a a a a a m ik 000= a a 21,21.118.2. c m 0 A a a 4 a m a s N W =a T E a a c a a 3 E a a p D a a a a o a a a a r° a a a_ a m m 0 a
.......28.....8 88 S pp 8 B@ 8g8g S PAM:: 8 S 8 N 8 N M O )M = a a a-= O = N 8 g m N N 8 8 I p 0
J n N N N N D N N p N 1p= N a pp 8 N N N 0 5 # N 8 T
UV OOVO O1�U §> J § § atO a
g m R m f g
5a a
m 1 m a 9a a V m 4, .
- 12,
c a TTtg .5 O .A
0
2
- W
0
r
A
a � g y y >p yp p p T .t
W WWWNNNNNNNNNN gT4WIOt `OWJNNAWN +OmtI Of J�NAW N+003JU0 AWN+0t08J88288 M=
WN tp fA WN +O UA a
l
N
1 O + N r n
p st �,�
U F - V 00+0 01WN_A V W ..1 W W p q
P 0 WW O OV OAO V U mt0 NN 3
t 0 � 1 s t0 0m1 U 0 2:8g O W NA ••J 0 0 . 10 as
0 + iWrOl ipNW W., m0 V
�N(D W0v N . TA
W 1
. 8 88 S 8 x
80 + 8 I..
v JO U
y N V + N m p
N ' l
m W O V 0 Opl _t40 t N � p A � J WV 3 W 3
y W 100 m � 88m • -gg 8 . t 4 J OA V 9 S2 Y ..
N 0 G�
8 2
a Co M6 t0 + W
• CIO tO WOE +� ` 0 0 oN - TV
r 1
A
` L 0
City of Rosemont
Monthly Report of Investment Holdings by Institution
A As of Febnmry 28, 2 012 tt y
(After Fair M f rkat Vakb Adjustnmants) . 4'..
Verml on State Bank " Morgan Sfanlay / Smith Gamey Morgan Staley / Smith Barney
(Continued)
-Date Date . i . Date
Due Rate Account a Amount Due Rate Cusip a Amount Due Rate Cusip a Amour
092821 2.80 55268CKT2 8240,000.00 04/17/12 4.00 085997-40 -9 '(- 696,000.00 07/17/19
(Monthly) CID - MB Financial Bank, Chico IL (101) , C/D -Wash Step -50%; 6-GW-4 5300,000,00
Chicago, Washington Mutual Bank, Utah (606) (Semi -Am) ( FHLMC) (101 -50 %; 608 -50%)
09/30/21 Step 3134G2L75 " 6499,170.00 04/30/12 4.10 085997 -8E -7 f $96,000.00 12/13/19 ' Step 3134G3 -AK-6 9400,164.00
(Semi -Ann) (FHLMC) (101) C/0 - F & M Bank and Trust- Tulsa, OK (601) (Semi -Am) (FHLMC) (101)
9 05/07/12 4.35 140653 -113 $96,000.00 .. 12/13/19 Step 313402 -2E -5 9701281.00
+°,: ' Totals 9739,170.00 0/D - Capmark Bank of Utah (806) 1 (SemiMn) . ( FHLMC) ( 202 -50%; 606 -50%) 'interest Due 3/13 & 9/13•
05/29/12 4.25 085999.1N-0 996,000.00 10/2920 . Shp 313371 -FH-4 $240,240.00
°.motoom: C/D - Branch Banking & Trust, WkreonSalem, NC (603) ( Semi -Am) (FHLB) (202) Martial Call 1/31/12)
07/05/12 5.40 084997 -10-8 596,000.00 0913021 Step 313402 -8/47 5200,210.00
Anchor Bank C/D - Discover Bank of Delaware (101) (Semi -Ann) ( FHLMC) (603)
09/24/12 4.35 086995 -91-3 596,000.00 10/25/21 Step 313402 -U7 -5 9801,672.00
Date - C/D - First Source Bads, South Bend, IN (101). (Semi -Am) ( FHLMC) (601)
Due' Rate Accou Amount 10/29/12 4.70 086998-6A-4 '( 596,000.00 11/1721 • i. Step 313402 -30-5' 9703,108.00 I.
(Mortify) CID - Keybank, Cleveland, OH (607) (Semi-Ann) ( FHLMC) (606)
03119112 025 95851568690 $2,000,000.00 01/23/13 4.50 085993-403 $96,000.00 01/18/22 Step 313376-06 -5 9500,000.00
08/06/12 0.45 95851570172 31, 000, 000.00 C/D - Washington Mutual Bank, Nevada (806) (Semi -Am) (FHLB) (101) "
.•10/15/12 0.45. 95851572051 $1,500,000.00 06/10/13 ' 3.40 17284A-FP-8 $150,000.00 .
C/D - CIT Bank - Salt Lake City, UT (601)
06/10/13' 3.40 140653 -3A-2 • 6150,000.00'
' C/D - Capmark Bank of Utah (602) a
08/06/13. 5.00 36160T -CE-4 996,000.00
Totals $4,600,000.00 CID - GE Capital Fnancial of Utah (101 -50 %; 206 -50 %)
® mairoboomoods omaaommombie 0820/13 1.55 36159C -SW -7 9150,000.00
°M•510321•20 sOCESS C/D - Cole GE Money Bank, Salt Lake City, UT (606) ,
0820/13 1.80 02004M -H6-3 9200,000.00
1st Stab Bank of Roseman C/D = Ally Bank (Formerly GMAC Bank), Utah (807)
09/16/13 5.10 083997 -70-8 596,000.00
Date C/D - Stockman Bank of Montana (603) „ •.
Dab Rate /tomtit t Amount 1126/13 5.00 02586T -8.1-2 696,000.00
t. - C/D - American Ego Centurion Bank, Salt Lake City UT (601)
03/10/14 1.50 • 05967E -AN -9 6200,000.00
C/D - Banco Popular De Puerto Rico (601)
03/24/14 1.50 856284-YS -7 $100,004.00 Totals (Smith Barney) 97,819,57540
C/D - State Bank of India (607) t
Totals 90.00 09/08114 . 125 025870 -CT -3 5150,000.00 ,
minotmomor ae»o moormoomoorm omormitowitoomoo C/D - American Egt Centurion Bank, Salt Lake City UT (206)
09/24/14 325 173120 {V -9 ' 096,000.00
(Monthly) ''C/D - Citibank NA - Nevada (606)
Rosemount National 1028/14 325 06740K -CK -1 596,000.00 Wa.S Fargo (Fomnerly Wachovia)
C/D - Barclays Bank of Delaware (601)
Date 12/01/14 5.00 085991 -5J -2 $96,000.00 Date
Due ' Rate , Account a Amount CID - M&I Marshall & Islay Bank - Milwaukee, WI (602) Due - Rata Cnsip a Amomt
01/16/15 4.85 085993 -1T-0 996,000.00
C/D - Capital One, NA, Virginia (607) t 11/04/16 2.05 36159S-4J -7 " 9240,000.00
01/30/15 4.00 085993-6Z -1 996,000.00 CID - GE Capital Retail Bank - Draper, UT (101)
C/D - Goldman Sachs Bank (101)
05/18/15 1.85 17284A-SF-6 ( 996,000.00
CID - CR Bank - Salt Lake City, UT (601)
Totals $0,00 05/31/16 2.15 254670 -F4-9 9150,000.00
C/D - Discover Bank of Delaware (606)
twarowoomm :Am: itaioommoomma moomoomimonna 08/24/16 1.85 381426-4E -2 5150,000.00
C/D - Goldman Sadly Bank (607)
4 US Bank 09/09/16 1.85 36160T -WR -3 1 6150,000.00
0/0 - GE Capkel Financial of Utah (602)
}
Date 09/30/18 2.00 361590311-7 .696,000.00'
Dun Rate Account a Amount C/D - Cole GE Money Banc, Salt Lake City, UT (803)
01/19/17 1.90 06740K -FX-0 5150,000.00
. C/D - Bardays Bank of Delaware (326) ,
02/24/22 Step 949867JV-0 6245,000.00
C/D - Baday's Banc of Delaware (206-40%; 606 -20 %; 607-40%) 11/16/17 2.10 t 3136FT-JN-0 $503,320.00
(Semi-Ann) (FNMA) (602 -60%; 006 -4050
10/05/18 Step 313402-65 -2 61,000,280.00
(Semi-Am) (FHLMC) (101)
,, 07/17/19 Step' 3134G3 -GW-4 9800,000.00
(Semi -Ann) (FHLMC) (601 - 18.75 %; 603- 18.75%606 - 62.5 %)
04/12/21 Step 3136FR -EX -7 6201,046.00
(Semi -Ann) (FNMA) (207)
r
09/09/21 Step 313375 -DV-6 9300,057.00
(Seal -Ann) ' (FHLB) (601)
09/29/21 ^ Shp 313402,12 -9 5951,415.50
,_ (Sem4Am) ( FHLMC) (101)
09/30/21 Step 313375 -NX -1 $299,889.00
7t977777f/7 0.05 104790484406 611,019,472.70 (Semi -Ann) (FHLB) (606)
12/31/12 Money Market /Savings 09/30/21
(No Motility Date) Step 3134;6 03 61,002,130.00
( Semi -Am) ( FHLMC) (202 -25 %; 803 -25 %; 607 -5096)
. , 102721 Step 3136FT -ER-6 6500,415.00
(Semi-Ann) (FNMA) (101)
112321 Step 313402-46 -5 - 9500,505.00 '
(Semi -Am) ( FHLMC) (101)
1 12/0121 Step 313463 -A1'-7 5500,485.00
i (FHLMC) (801)
122921 Step 313403-0E-4 9300,387.00
I (Semi-Ann) ( FHLMC) (101)
02/22/22 Step 313463 -1S-9' 9999,100.00
,, (Semi-Ann) ( FHLMC) (601 -25 %; 602 -25 %; 606-50 %)
Totals 811,019,472.70 °(Semi-Ann)
022322 Step 313378 -20 -2 9200,000.00
(Semi -Am) (FHLB) (603)
Sterling Stab Bank
Date
Due Rate Account ,Amour
77777777779 1.49 990005332 5602,970.42
12/31/12 Money Market / Savings
(No Maturity Date)
Totals 9602,970.42 Totals 68,299,028.50
•
Total Investments 932,680,317-42
i TT vv � �IO a m �omn ;ci mDO -� �3 aA LRm 8a a qn '�"aa= a .'� .11O o i iH D �' APSi�%n g IF Na9 . E 7 'sm a�o g "<� °OmoN +g,.. p 3 cii
m F a °a R'_ ro 2 3 °0 ^. m 4 g 3' a l g p p 9 og n ;.7 s r• A 3 1 'a+ 8 z 8 0 � - 3 . y is`i S�BEo-VO`> m S omP ° FI " 0 '8 / ' i
Er WI ' T a $ = TT
ig 'CT
o , b Q
LW F
{ - g i ^
4 +iP2g:It e.oa =nl'0 PO ` w :B u ASN
In Yi1 a
b l� w'PAO� m IS 'O`'
s 8 .."i
ss�os'BSNNg"ss i os0008ssos$oo I N
a
l i 0 888888,8888888 8 888888888888888a
> p" _ :
0. 3 a o Ill ° 2' Ni,., vm ^ ' 7" " y 2 2=4tStIw88nbibe 8= n PP 'P ., _ a a l ..
a 5 .1 p P�.4;wwo"ao� WY 'wOSY o ot w i ''' ""' t '40.8 $' 0 S t$ . " ioP g ° is i o R0 0 00 3•
- P W w • -.1 to'8,wP 8 8 888 " 8w w 888888888 P
. pm N -
if + _ W-Op *- " . 0 V +N N O +PW+O +f �P
0 Og CI CY Cl ip �Y y V 41 Ul
a oN b' �R$T- PA -wow �'I o$ OO 000
0 859998t9w899 9 84889888
s
II N N�a o es°.N o o 44 Wn . P me -. - N.w ,.9,.
. s o 7. w . 0 0 0 e
r P "a8 8aywalol88d�8 w 8'PtPSa."8o9mtP.18$8 $$ tNrmU488 8 8NO800 88 P
9 i ° "wm 'b2eaN' " o w ill
p O N+ S N N W + w i a O V P P S S F, W + W O O a N O o 0
■ b b 8 1 N
p S B +VPWNS.SWOOW: , N 88 ... NbOSOSS00
p �
S pV'mar� n' g "w u .i"dbffiL o+ 0
i fm o� n muummooF3� Z om B NU rt 23- 8 mo ==o0P d (7'
p S 4b.:2a4It P0utt8rw N 8te.84.8 °WN8S8 3'
i P _ _ _ _ r ii
P P ANO r " N { "o " "W + � _1Ow' NNNNN Nt�I
a OP P. tl � 'N. W t sg,74; V a W t +twll NP O q 1 +O + bpbp CO ; Ob
a' V ^ 0+ i0 N a O N V N O P O U W b�tO Y A O A W O P 01 O ; V V ; O O O 0 0 + 0 0 R
NBaaa' 8 88P` a'asslV88 9 8 ,88 S V8V888 288 B
N
8 P ;M(lIEirA °u 9,; w °oN w
. „.w t . . _..-0 + iP ms P E
N w ♦ + O . w 0 �p V 0 . N j p
it f� tIi SON g {n G t'!� VbblP �i <w +0 13 P 1 1
it , f� � p WO+bNbO � ' p +NiN O OtNI�OIO+ + +O! + O � VVw Ns N00 - , 8 8
p V P V AP g a a N 8 a O V S 8 888i8 V V V 8 J 8 8 S V S V 0 8 8 V 8 8 8
a t J� tJ m E o a
l':''': 0 O tPWO 4 P NNY.�+ tp 4a E§a V P W ie+U a; ♦ „,;',17;12 �� 3 a g
8 v N S b N a O N V O O O + P+ T u O 0 A O $ V V N b S 'b 8 0 0 P+ $9 0 T S C P A
Y. P V A P b(p 8 V W V V V 0 W 0 0 0 0 V O V 8 V 8 $ V
8 b0�;� W OI OI OO;S S S O qq GG _ S V V wO V V V S S S S V SSS S O O A
� N @ P 8 it NNY� +Atd N W - -. V a „.. N m +
�p I�l �p 8 .�ll {l� �tpp ee q _ j� + O
a tN.lANB� aMOONVNO O ONPaP+ + +N 3C tl „ O �P NVt f J G I b p N tb O' 3333
S OI +000t 0 OI V NObS0000 +0
1p 8 W V V V 8 V V W V V V V V V 8 8 O V 1
P + 0 V a a a; V W OVi V P 8 a 0� 0 8 S S V S W S S S S S S O S S S � '
O � N - r A a . N 1 � T
8 tt , O ,,,b w Pr Nt �i ++4 . Q ' Q OUtONmaOVir�a N s P s t + t � + G
,ti$ w "r�°a tq,m ,two ,t"il$$'_.Ni n"io P § -4-21 a o �u0m'ffi m OS41551g P'8''SpV000 3 G
b N&al;,yN��888,8 8 88LWVit8tv88tt V:St888989888.4888 $ r o
V 111 ot wO j��jOOjj q ^4II �i tttTpp `l' = A w a _ t 0 .. ° w t°O t i �jt + tAA t r. C q ' C q ppII _OI O+tV a ...., �u ms N ,e
�NNaPwavIDONVNpO P O OS+++00J+4 + 001 t +000
pw a w� b +mgl
p' b ls88m�Na�88 8 889w9998998899 9 89888898889888 it g
Y
N
tl ap + b . N O V w + N V O Om
+ y W 0 + . N O r
m yy t V Nt l W P W W S N V N W A + N N O ,... _
4 V P P N� G O qq NCI + O1 tp SbOOST g 2 N
+Y; WV NO O O N P � + +SOI +WO'W + OOt W +000 p
�a88$ 88898 8�8°9e9998t9 899 $98888988 -�
V � WP ({ !l�� ^ 0 WWbNV V aa _ N' g + w' M 01
O =,—a ^ N A W N .+ N P O + O+ y N
tO Pab �pSS NV �I °"�i, �nW QI 10 q - N,:W_ � 51 =S m
N
b a N P 0+ b N a O N V N 0 ; O PPS ' S l+ 0 'P 0 P O OI P V O O 8 P 0 0,6+ 0 0 0 1 1
p b Vag!,: �Siai 8 8SlwV V 8V888V8V888V888 444
P N f O J W V t � Nu C � i ' + � tJ _tP.I W m V N N 2 + +W _ m 0
N " ' W V N S+ . W a N O O N N O O O N P a ++ E O l +•4 O W O P I o i V V N+ S P 0 0 0 + S O O g
"2$88 ..mm888y 8 88 V 82888!818884888 000 L
p P (l.
: W
8 P two -4 N t V . 8 8 .. N.,.....,± P +++ P = P 4. G
pp ��..II tp tt!l�1 88 w � N V P W. + O�I P N N C 0 0 . + P W+ O fp + w O - 0 W V + Y N P WPp31 0 11P P +i0 t O ONPa� + +00 +4WiOPN + -a NN;'P Otfi OOS t i P
3' m 81"88898 8 88�w999899w899 ” 8988898!888!888 -
I
Donation and Assignment Balances
02/29/2012
Account # Description Balance
101 -22220 Deferred Revenue - Fire Department 12,275.76
101 -22221 Deferred Revenue - D.A.R.E. Program 839.13
101 -22222 Deferred Revenue - Police Department 4,561.17
101 -22223 Deferred Revenue - Park & Rec Department 19,816.58
101 - 22225 Deferred Revenue - Administration 37,605.96
101 - 24411' F/B Assigned for Sidewalk /Curb Program 105,460.00
101 -24420 F/B Assigned for SKB Landscape Program 37,100.00
101 -24422 F/B Assigned for City Website Improvements 24,526.00
101 -24423 F/B Assigned for Chess Consultant 5,400.00
101 -24425 F/B Assigned for Technology 20,000.00
101 -24428 F/B Assigned for Police Reserve's 3.31
101 -24429 F/B Assigned for Government Bldg Repair & Maintenance 167,400.00
101 -24430 F/B Assigned for Parks Maint Repair & Maintenance 76,400.00
101 -24434 F/B Assigned for St. Joseph's 10,000.00
101 -24450 F/B Assigned for Community Survey 20,000.00
101 -24451 F /BAssigned for Fuel Reserves 17,711.66
101 -24455 F/B Assigned for Siren Repairs /Replacements 3,934.97 i
101 -24458 F/B Assigned for Election Equipment 139,000.00
101 -24459 F/B Assigned for P.W. Parking Lot 12,338.54
202 -24433 F/B Assigned for Fire Alarm System for C/C 40,000.00
202 -24434 F/B Assigned for St. Joseph's/Library 75,652.78
202 -24435 F/B Assigned for Building Improvements 0.00
203 -24430 F/B Assigned for AUAR 20,959.00
203 -24431 F/B Assigned for 42/52 Costs 180,000.00
207 -24455 F/B Assigned for Siren Replacements 2,000.00
207 -24480 F/B Assigned for P.C. Hardware` 5,518.17
207:24481 F/B Assigned for Fire Dept. Technology Updates 28,119.96
207 -24482 F/B Assigned for Security Equipment at City, Hall 1,405.00
207 -24486 F/B Assigned for Squad Car Setup 2,000.00
207 -24487 F/B Assigned for Police Squad 21,600.32
207 -24488 F/B Assigned for City Accounting Software 13,720.05
207 -24489 F/B Assigned for City -Wide Software 206,000.00
207 -24493 F/B Assigned for Police Photo Imaging Software 2,017.50
207 -24496 F/B 'Assigned for Future Equipment Purchases 165,889.53
} a
{ b
I �
}
` r
a City of Rosemount
Building 'CIP Fund - #202
Monthly Review - Audit of CIP Coding Amounts
For Month Ending 2129112
2012 CIP Budget - Departments to Use Following Encoding: 202 49002- 01 -(xroc).00 plus number below by item
Object Spent to
Item Budget Code Date Balance .Department
General Fund Administrative Fees 2,500 317 2,500.00 0.00 Admin Fees
Year 14 of 20 P.W. , Building Addition (Pi 17,050 521 0.00 17,050.00 Public Works
Replace Council Chamber Equipment 100,000 522 0.00 100,000.00 General Govemment
Central Park Paver Replacement 5,000 523 0.00 5,000.00 Parks & Recreation
Community Center DVR Video Recorder 8,000 524 0.00 8,000.00 Parks & Recreation
Steeple Center Exterior Signs 15,000 525 0.00 15,000.00 Parks &'Recreation
'Community Center Reader Board Sign 23,000 526' 0.00 23,000.00 Parks & Recreation
Community Center Improvements 120,000 527 0.00 120,000.00 Parks & Recreation
Steeple Center Modifications 0 530 1,855.00 (1,855.00)
Genz -Ryan Site Expenditures 0 531 0.00 0.00'
Contingencies 0 xxx 0.00 0.00
Transfers 0 710 0.00° 0.00
Year 14 of 20 P.W. Building Addition (Interest) 6,950 611 0.00 6,950.00' Public Works
297,500 4,355.00 295,000.00 Sum of Positive Balances
Only included
Total Levy for 2012 24,000 COH 2/29/12 2,641,448.47
F/B Assigned for C/C Fire Alarm System 40,000.00
F/B Assigned for Library/St. Joe's 75,652.78
Reserves Available '3/1/2012 2,230,795.69
1st Half 2012 Levy to Receive 7/12 12,000.00 ``"' (Reed $xx,000 7/12)
k �
2nd Half 2012 Levy tb Receive 12/12 12,000.00 (Rec'd $)o,000 12/12)
SKB User Fees Still to Receive in 2012 600,000.00 (Rec'd $xx,xxx.xx YTD)
($600,000 Total Expected)
c ,
Total Unassigned Reserves 2,854 795.69
Projected for 12/31/12
(Does Not Include Future Interest Earnings)
1
. `
C ^
�/ of Rosemount
-Street CIO Fund '#2w3
Monthly Review - Audit of CIP Coding Ain�unts
For Month Ending 2/29/12
2012 CIP Budget Departments to Use Foliowing Encodung 20349003`01fxxxy.00 plus number below by item
Object Spent to
'Itmm - Budget Code Date Balance Department --' ---_---'--___
General Administrative Fees . 2.500 ' 317 2.500.00 ��OO /�bninFuou
JPA Administrative Fees 0 319 0.00 0.00 PubicVVdNks
` ^
Miscellaneous Engineering Fees 0 303 0.00 0.00 Public Works
w '
Akit Avenue Corridor Study 50,000 530 0.00 50,00000 Public Works
Pavement Management Program 720,000 531/710 0.00 720,000.00 Public Works
- �
podastnon|mpmvements Program 12 5.000 532 0.00 125.000.00 Public Works
�
Cu��f�C�aadpn�ec� 0 535/720 0.00 0.00 'Public Works
897.500 2,500.00 895,000.00 * Sum of Positive Balances
� --'
Only Included
Total Levy for 2O12 720.000 COH2/2RK12 1.405.425.23
| '
F/B Assigned for AUAR ' 20,959.00 p/B'/�o�nudibr42/53Coos ^ 180.000.00
° Re&ervea Available 3/1/2O12 309.488.23
1st Half 2O12 360.008.00 <Redd$moc.O0O 7/12>
2nd Half 2O12 Levy ho Receive 12/12 ~360.000.00 (Rec'd$x)x.ODO12/12)
SKB U Foes in 2012 175,000.00 (Redd $soc.)ox(0OYID)
($175,000 Total Expected)
Total UnoSognedRaeemos 1.204.46623
^
� r y
Projected for 12/31/12
(Does Not lnclude Future lnterest Earnings)
� .
/
~ ~
~ |
^ `
^ r
City of Rosemount
Equipment CIP Fund - #207
4 Monthly Review - Audit of CIP Coding Amounts
For Month Ending 2/29/12
2012 CIP Budget =Departments to Use Following Encoding: 207- 49007- 01- (xxx).00 plus number below by item
Object Spent to
Item Budget Code Date Balance 'Department
•
General Fund Administrative Fees 2,500 317 2,500.00 0.00 Admin Fees
Single -Axle Dump Truck (Replace #8330) 135,000 551 0.00 135,000.00 Public Works
Emergency Siren Relocation 10,000 580 0.00 10,000.00 Police
Replace Tactical Gear 15,000 581 0.00 15,000.00 'Police
Police Grant Equipment 0 585 0.00' 0.00 Police
Laserfishe Software Enhancements 26,000 '586 0.00 26,000.00 General Govemment
Pb Workstation Upgrades 40,000 '587 0.00 40,000.00 Finance
City -Wide Software 50,000 588 1 0.00 50,000.00 General Govemrrient
DCC Capital Costs (Year 6 of 7) 62,948 601 9,991.66 52,956.34 Police
341,448 ` 12,491166'- 328,956.34 ` . Sum of Positive Balances
Only Included
- Total Levy for 2012 482,948 COH 2/29/12 1,405,425.23
F /B Assigned for Siren Replacements g re R placeme is 2,000.00
F/B Assigned for P.C. Hardware 5,518.17
F/B Assigned for Fire Dept. Technology 28,119.96 t.
F/B Assigned for C/H Security Equip: 1',405.00
F/B Assigned for Squad Car Setup 2,000.00
,FIB Assigned for Police Squad 21,600.32
F/B Assigned for City's Financial Software 13,720.05
FIB Assigned for City-Wide Software 206,000.00
F/B Assigned for Police Photo Imaging SW 2,017.50
F/B Assigned for Future Equip Purchases 165,889.53
,, Reserves Available 3/1 /2012 628,198.36
1st Half 2012 Levity; Receive 7/12 241,474.00 (Rec'd $toasoo(.00 7/12) ,
2nd Half 2012 Levy to Receive 12/12 241,474.00 (Rec'd $)doc,00c.00 12/12)
Sale of Old Squad Cars 0.00 (Rec'd $0.00)
Police Grant Remibursement. 0.00 (Rec'd $0.00)
Total Unassigned Reserves 1,111,146.36
Projected for 12/31/12
(Does Not Include Future Interest Earnings)
a
A � �
g i 4
t :
2. ° s Iti; E m m ` � -1D� m vSt�3>�cg f��OSVV D
8 0 o m m.m m m m i m m m N y a g 3 E,. m A. m m c D g ° w m ? >> 0 m>> 2 . 2
D 1 tn mmm -t aatnlm2.e m mma 3 ma 72
.A o i 8. 222. ( .1"."'!.‘-' 00, 333g0 1 1 1 3 s w a m A 1 w m = m rd m m a A m o m m H N-
a a o *a ` A °�4 i ningpoAO * -03 W, m .„„, m m *a C )Li m m? •g'<Ntn? 6m
.a. m - - #N rn w w goo* m 5 � @m O.. si % Gm m m 2 g,, g 2
A N m -, c m m g m m T g 1 , m a
- 133.7',062
6$"_ �Nm m� a� Ha c)m
�`O 33 B g -
m 'o x , W w ^ ; - 8w-22 D
N j .......� 5.2N >a �WC p W �H N°NOW12 i
V 0) A 3 < A m g 1 ti D w O C O N m 2 w m D
°R Wbb a � c�a�� a `^,$w... B ° D O,�'N l w
� w a c3v c
2g m � o Q �$ n n m_ m C >_�^$ m
6 ---- to
I b b �8� g 2 c4 g a 'a a�D`g6'i `^ k+
D m m �g =
2 % z mm _ .8);;
g ' D D
m m
1 I �°-: *
N
A O W W N N N A A N � p�p W (!� V b .?,1-.O' (� T
N • CO W - N+NN 0 0 NO) OiA W co V U+O A O 0 5 � 00 5 � 0 88 0 0 0 O 5 � fC C
8 8 ` 88 8 8 8 88 0 888888888 8. § o2502525 ; W
8 8 888888888888888888 8 88888888888888888888
▪ + (. N l ��1 ppp� <
O N pp�O N + N � O Ol CO W (T Na N 01 A + W
A p ot 0) N W OD A�O� W W 80(D0)m 0 0 0 0) "P e N p A p �O 1
U O V iv0 j OOON00 W 000 8o oO O
el m 000 ,IWA8wa000N80oo- W 88888888'1'8880,8888808
N DD�� -, CD CO V C. + N �. + W 7 It
9 o 0 0 0 o 0 0 0 o 0 ) V 0 0 0 � O N V t D -. A, Dpi 0 000 N "g N
O
p pppppp p ppp W• 0 88888888 0 0 W ONO O N pp pp p - M O pW OO p p00fD p
8 t0 88888888288 V8888 v W 'w ° 888 DA/8000 Z
W • W N N N 0 A D { O
+ O CO W C
O 00 0 - CA --.1 W 1.3 C� - CD - -.1 IQ . D1
0 ) • 02898 Q p g+ 054V8 ±8 A p W +
O . , 9O9 O O O O p p p p p - Q N O O O O 0, O O 0 00 d
� p p p p p p p p
D N O 8v 0 V W A O O O O N N O C N CO CO 8 888r 8888 88880/P1088888
i
OI
O 8 O o O O O O'O o O o O o O o O O O 8888888888888888888 9 20009099900000000000 S
k' 8 8 888888888888888888' 8 8 r
3 n 0 4
0
0 9 000000000000000000 0 00000000000oeo000000 to
. gm m ""
8 81888888 8 8888888888 $
g . �»,o
a a
U P 0 00000000 0 00000000000000000000
8 8 888888888888888888 8 888888888888888 -88888 N
r
1
C
.4 0 0 , 00 . 0 0 000000 0 0000009 9 99999999999000000000 1
€ 8 8 888888888888888888 8 88888888888888888888
C
O 0 000000000000000000 '- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 '<
.8 81 8 88888888888888888888
t e
0
o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 . 0 0 0 00 0 0 0 Z
i 8 8:888888888888888888`. 8 88888888888888888888 ''
iL 1
2 O O O O o 0 0 9 0 9 9 9 p 9 0 0 0 0 0 0 00000000000000000000 3
8 8, 888888888888888888" '8 88888888888888888888 1
}
E g
r D
'. ,. O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'0 0 0 0 o p O 0 O 0 0 S
8 8 888888888888888888 8 88888888888888888888
Z
D
I 3
0 9 00000000000000000 - 9 9900e9900000 00000000 Q
8 8 888888888888888888' 8 88888888888888888888
O
m
n
m
O 8 0 0 00 0 O O o 0 0 o O o o O O
O o O O O p 8
o p O o O O o 0 0 0 O p o 0 0 0 0 o O p o p o g
8
8 888
8 8888
p 88888880
.. ;
t
E
m
0 O ,� O ,
g r r
rr .g73c000^ - DvOD0
z�� c
�m m � o. rd - 40m30g
.. m �m ao m m m i o m m � cl
n O mmcnvimmmtn %sk lt A i lgm3mc
3 W om O m m m m m m m m� m 2 23 v m . ^ 3 3: ° -� c m . v ,3
m i 7 7 7 O i g O H O O O O m m E m 7 m i m m A>>^ g m 5 ' m m m g m
a a 7 # 7 8 t00 A22,ttltm t m 0'm ; m 3; TO; c m m my N Ag 0
m �
.m.. OAAAA AAAAO 0 , m 3 m .Zl 0 Tm
o - ° V.R22?.M.T o2 - I < -'2 t''m3`
W. V 8U.iA - . C V N W - V W aos a DD
3 0 66666 o 66A m o 5 ( g N 4, g m4.- 4 i NN tl1 0 V a - j' 0.
A O a p v� v 8 0 0 8 " m y CD 0 9, - 0,
0 8 m A 6 v N N D C 8, 3 3 y c _ n
$oat —
... - - D D . --IT=6 S oo I ° . -3 =
0
v (vo ° 8 ° c ° • �&" • . Dm S my
�. .: � m E 2 •c Dc 8mim
m 0 D
m • m m m v 8 tm c
Z o •m •
m 2.8-1;g,
4 k .4;g-7
m
rt f J v I V ...
CO 7:: .31 8 -0;0N V O. — p V 7 T C
0 -+ c dl V fJt A N0 (� f QQ V (!� O p Q O Q O f44-4.0.1.. J1 O O O A QQ O 1 ,Q c
o 8 8 8 80§ §888880025 §8§888 in
o
8 8 88888888888888„ 8 888888888888888888 j
V W N N V 8 N
N e NO�00 (J •I W S , ..<
'
e N (� 1+ A N C8 8 p N O N i
-4 N Q .4 ( 4) (pp 0 fO - 0Dc CO p p 08 p O p O O O ( N m p p p p O- o, ER ER CD D t p V300 I C5 VV m j NN(Ai( W m�(NO8A8mN 8383 S 88 W 888 m( OD 888(Ei N O O O O O 1
V (V(pp -)08 0) + W 1 '
8 + W c/1 1,3 N' A v 0 CO N c Ca
0 000 V A 8 V 0 0 0 0 0 0 0 A 0 0 0 0 W 0 0 0 8 O m
8 8 8888888 88°°8& — T 88N888888888W88888 j''
S +OB OD _( r N •• _, T
w W N(T O 71 N V Z O OD Of ‘-4,1 O A p NOf � O 1 2
W A o W V - 0)O (ON p O W W V ( ( ( 0 � p O p O Of O p O p O ( O � oeOOO N p O p OO p OO I°
= v N N N t (. (0 A O W 0 -. J O 0 0 + 8 0 0 8 + 8 8 8 (0 ( 0 0 888 8 j `Z
1
m
0 0 00000000000000. 0 000000000000000000 ; S ..
M 8 8 88888888888888 8 888888888888888888 j
0
y n
14' ' 3 ` 0
0 0 00000000000000 0 000000000000000000 !a S
8 8 88888888888888 ,8 8888888888888888888 j rmea
j A 3
3
m o
* c
9 O 099999°9999999 O 000000000000000000 888888888888888888 ' CD
88888888888888 8 8 8 I 4 a
S
L
Le
0, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 j m
8, 8 88888888888888 8 888888888888888888
O O 00000000000000 W 0 000000000000000000 '
. 8 8188888888888888 8 888888888888888888.
i
c
0 000 0 00'0000000000000000 1st
8 8 88888888888888 8 888888888888888888 1
1
O o 00000000000000 O 000000000000000000 j 3
8 8 88888888888888 8 888888888888888888 1 :
R
s
p. o 0 9999980oeo n
8 8 88888888888888 8188
i
!
0 0 00000000000000 0 O O O 0 0 0 0 0 0 O O O O O 0 0 0 0 3
8.8 88888888888888 8 888888888888888888 1 �
IF I F t.
3
0 0 00000000000000 a 800000000000000000 3
8 8 88888888888888 8 888888888888888888
1
m o � �' , o p
I
0 E 3 rr r r r r 93 • . 0. 7
$ ° m DCOf)03 D0
3i 3 ai m ma ' Ng.„,..-.3,0,.5233 Qm = o m�.o. °
° O mmm tn
tnm a
3 W Si m mm ! 53m
.N.
� < mm oA R Q C
I 3' o d oo ° 3 0 ° C . w°- 's
O 3 , 0000
3 3 3 W F, G . m �L` 4 C G m m J y m. m
1 a ao,22 mn, ',70 - mm ° 3 o m I c ima 1 � r ' O m 2c =cow cos, a g mm M - a ° W gT., -z .. n y T�
3 S. _ g ma7 m 7 m 7 A 7 =me 1 C. N0 .. w 0.*
• a33, 7r a 37,.. 7 N 0 < 0 ,-63.!", 8 ^m ° m 5 D
° r o o-0 a o 2 c 0F q A a ° o'° :-(.)8 it. m 8i tt g m ° a
9- a > 7 Y N m � ° D m s4 8 8 D c 8i 3 3 C" v+
5 - -8$ a N_ m ` °m 2 t3
d AA( N l,A �— V CC Q� �� O ' 0 + — ' - n — (g D � ( ....
N NA6N O y �+ D°�am C p l 8D
. b O.... b6 m C D E• Z m N
b m - 7
u 1
t p8 m 1
11 O N - _ + N � Q a > -+ SO 01 CO N V t 8 O (N)1 5 1 to II co
ii g $ ag a $gg § 00250000§ §22500 1 o
818 888888888 8 8888
�
' N W <
w m
8 $i
Ca N.) . p 225093222:-1:-122590 pppp v
v 0 g 000 c,0 O N + ., 88 N 0888 NV 0 00.. 0 I
'
_. e
p m a !ii
,. O 0101 10 A 0 -, W ` m
O 0, d C
C 40 0200020 0 8 0 8 W -4 0 N N , ‘22! 888 0 1 8 0 8 p 88 0 8 E
Iv a 8 8
.888, -88 8 V 8888 !1
1
„ -1, ' .. N co N N V - O * Q
1 - N.) Is) W N O N 0f O A a CO
w 0) p o p ' 9 00 p o p 0 a p ' . � 0, �p 00 p w p OO N p� 11 � 0 00.- 4 0000 1
0 t
- 2 828 8 N 8 A 8 N A 8 8 a' ' 8 8 8 nl A 8 8 8 8 1
,
I a
, I m
0 O 00000000900 O 2222222222222 1
8 8 88888888888 8 888888'8888888 I -n cn
L
i ° 3 n A
I,t 00
23* 2'
I o O 20000. 00.0000 0 - 00 . 00000000000 I1 m
8 8 8 88888 8 88888 8 8 8'8888888888 I ;ca;$
3
m 3 a C
s °
O O 00002200000 0 2000000000000 !!a g
8 88888888 8'8888 1 N w
7
I e
00 02000000000 O 00 y
8 8 8 8 88888 1
I
I
e
O O 00000000000 O 0000000000000 I'e
8 8 88888888888 8 8888888888888
I
s
im
0 2 22222222 O 2222222 I .
8 8 888 8 8888888888888 1
I 1 ,i H
p 8 O O 22222222222 p p p p O p O 0 p p p p p p
0 0 00 0 0 0 0 0 0 00 0 3
O I. 8 0 8 8 0 8 8 0 8 .8 8 0 8 0 0 0 0 0 0 8 0 0 0 p 0 I a.
9
I
O
2 0 p 8 O O o O O 8 p 8 O O p O p O O O O 22222222222 8 p p 8 p p p O O 1 m +
8 '8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 1
. c
o'
O 0,00000000000 0 2000000000000
1
8 8 88888888888 8 8888888888888
13
!' O O 20002200000 0 20020 ; 3
8 8 8888 8 8888888888 1 4