Loading...
HomeMy WebLinkAbout9.b.ii. Interim Financial ReportCity of Rosemount Interim Financial Reports For the Month Ending March 31, 2015 1. Cash on Hand Report - All Funds 2. Report of Investment Holdings by Institution 3. Estimated Cash Flow Chart — General Fund 4. Donation & Assignment Balance Worksheet 5. CIP Worksheets - ]wilding CIP - Street CIP - Equipment CIP 6. 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. j -in2 In_Wcn��m� cc�ccpcc,c cc 2c2 ccccccccCc222zcc`0cc cc2ycc tcyc�ycn"yc cR'�c�� 8.5-Ho N N Ili N NN n mmp @_m �m_m rn c c F F c F 1. c °'> j aaroaaAa O-n aQ 'W,, no.uuaa'o. 'Q 'o.n333�3a'� 229 !R � �� oon'o� o�NONNoaaaoo,�a„oo o.c3o�0000 N,aq jN -,3,'o nQ Q .=w�w:nmjzi na ��T ��$ays ggs 8. @e�mww wN w°'�o�� �sl- cg aV m 3333 3� row'-' oVo N 6GGEi� 'i gV Q e9t. N rn NNNNN O D � a m �b ooloso oq p � Na u � DDybm c n a -n o 1O Y N N 0 0 - m o to m p� WW W W W�1 W W W WW WW�,1 WW NN NN NN � O6� rnrnyrnrnrn�rnrntll pdai pm pW O m -0022 A W W W W W W W W WW NNNNNN .W�i�N O��d�2N-Ai W 4Nj0 WPI OINpN pN pN 000 � a Nmym V A W Nr0 +g161 ,fpT Ap pW�1 IAA W N+ OID Ca V Ol ls�?.�Nr.OpmmJrnfnA AA �p SpA WW pN� Wr NW rp Q pN ���pp r1 pNpyy 61001NA0 Vw to InmA W o N }ws+ Ar ,OI�N�A /pVA.�N ebepp]?_P p=j FS W �Wp IO W y�N N A�2 6 3 y �W W W �pWp W W N,tJN 8 .� �1 OAiti V V QI No 41JT a��0u W N q 100 OIN2-0 V W ONW VIA m rW far�Vn r NWIA� til O O O O �A00� W 10 N rJJmm r SA�pA 2O1 LM1 IJO CJ to m q 01 �I O ,D O P. Vl V fA W O O 10 [�VQA;�N Nm oo oNWOW i @ JO Z6 NN N w NY W ,111 NY AJ P. m a r% ,cga8i,'. mii Inw uAi �NNo��WW"11pp lT N1292 . 1W1 U Nm �dAr � N a V�i 0/ 2OmGJ A�OO� VW W N 61d lA [fl Aa �d a fO AA m!OO +wl N N r �Om V12Ay � UVi OqA. NP NtVO 8mS J 2 o Am-g01p W O kick5EiE �kG�T `�k ���aCmm�r� w-�Dxxc'w 4oc�cw 3 m m N Uci N N. 5 Nd' "O N r- N N Vci N N N ry ry N N i' IICi N w H C C C C^ F@ C Q N F .O N C C CG N mm m,@m m_m,�m 2.222 g� Ip ��N�61 22.22 m_m 93w,�rvmrvm,ry v_aN vbwm mm2 m,T@N NN m_ ceccccc`°cccccc ?m a' •ycc�cc�nrvm�rwr����r mm-3@�',, 3.n rowT�= 'o.'n na'n a=n. nano. 'a.a m napp 3'fl mQS� nn�nana QnAaa^aQann R .@ n Nf NNNf rNl"3NNNN aK T^�ugNNa.NNN� >> NN>•NN NNI�i NNa S='Na �, 6Na pNp � N -g0z oC � V v m 92— v N v v rf{ vo- aWbb w N �p N A lJ W JJ W m N O 1O A "m N w Wrni W WW rnrn �imm�'r°ia Nlrna 2A [Aji !)I (ApA�A� AAAP W W 1,y W W W W W W WNNNNNNNANNAAAA�A����$d0000000 # � W NrOINO�yO�NA W Nr0 VNNIA WN -+O N0AA0 VNN� W Nr Of6 D) V m1nA W NrOtO 0iJ 6� Ln WN -+o 1DmJdI LnAwN-�o10mV mUA W Nr O' O . NPI.d[umAto N I.A�� lA 2y9 rD�imV N O N W WImoW VmOVO yy (f�OI�S� Ca JV Wt0 W O V .lppAO q�1A PP rlp W V d p Ory �!0 W NNA r N N MO � WUgyOA�NNy 0U0 0r fOJa O .Np �mmO� WNWw�.VP� tw 0 OVAAAm.c WJ O 4f IoW rnrU oofv 3 C fAM1 V N N W�1 ISD �W,1 O„IN➢ i W J N O (�li Lnd O�w L�J�tUf � -Vi 9 p b — qo by A Nn W A !]I N a m'mw rsA yio ino :P rn 'o ONOr (9 O,P (AUS ,N+ d a Sterling State Bank Data Due Rate Account Amount _..-.._._.__.....__.._._..._._.._._......... ........... 7?????????? 0.44 990005332 $609,907.29 12!31115 Money Market l Savings (No Maturity Date) Totals $009,907.29 Totals (Morgan Stanley) $6,429,994.00 Tortola (Wells Fer9o1 $8,21GA47.00 I l 1 Total Investments $37,736,612.08 j City of Rosemount Monthly Report of Imestment Holdings by institution As of March 31, 2016 Vermillion State Bank Morgan Stanley I Multi -Bank Securities (MBB) (Primevest7 Cetera) I Date Date I Data Due Rate Account# Amount Due Rate Cusip# Amount I Due Rate cusip# Amount ............. .......... .................. ................... 07/26/21 2.50 3134G3YP9 $457,060,00 ..._._._....--- 05116115 ----- ---- ---- ---------------- ----------- --------- 1.85 17264A-SF.6 ---- ------ I $96,000.00 I ---- ------- 06128118 -._._..---------------------- ........... 1.35 149159-HY-4 .........._. $147,495.00 (Saml-Ann) (FHLMC)(101) CID - CIT Bank- Sell Lako City, UT (601) (Monthly) CID -Cathay Bank- Los Angeles, CA (101) 03126123 2.00 48124JKF4 $240,000,00 05115115 1.05 33754J -EZ -4 $245,000.00 07130/18 1.65 308862-CY-5 $249,000.00 (Semi -Ann) CID - JP Morgan Chose, Columbus, CH (202) I (Man$rly) CID - First Bank of Puerto Rloo (2137) (Monthly) CID - Farmers & Merchante Bank - Milford, NE (101) 10112127 2.45 05573JKC7 $240,000,00 07113115 1.15 20451P -AP -1 $200,000.00 55130118 1.75 06424K -AN -0 $200,000.00 (Seml-Ann) CID- BMD Harris Bank, Chicago, IL (101) CID- Compass Bank, Birmingham, AL (6133) (Monthly) CID -Bank of Santa Clanta, CA (607) 1 05131115 2.15 254670-F4-9 $150,000x0 1 11113/18 2.00 20033A -DK -9 $150,000.00 CID- Discover Back of Delaware (606) (Monthly) 011) -Comsnity Capital Bank, Salt Lake Cily, UT (601) Totals $967,060.00 08/24116 1.85 381426-4E.2 $150,000,00 12104/10 1.65 571 WA -1-0-5 $200,000.00 CID - Goldman Sacha Bank, New York, NY (507) 1 (Manthly) CID - Marlin Business Bank, Salt Lake City, UT (101) =w======w= ...... ....mm....... ..www....==w=w 09109116 1.65 3616DT-WR-3 $150,000.00 1 07131/19 1.80 33621J -AE -8 $245,000,00 1 CID - GE Capkal Financial of Utah (602) 1 (Mori CID - Plrst savings Bank Northwest, Renton, WA (101) Anchor Bank 01119117 1.90 06740K -FX -0 $150,000.00 11128119 2,20 02587D -WK -D $245,000,00 1 CID - Barclay's Bank of Delaware (326) 1 CID - American Express Centurion Bank, Salt Lake City, UT (1 grit Date 04127117 2.00 856254-E3.4 $150,000.00 111100 2.35 9020SU-BK-1 $245,000.00 Due Rata Account Amount GIB- State Bank of India, New York (601) (Monthly) CID- Two River State Bank (01) _.._..._..__.. .-.-..... ------- ---..----.---.--- 05131117 1.80 982999 -SO -1 $100,000.00 I 06115115 0.30 95551547585 $1,500,000.013 1 (Monthly) CID-Comonity Bank (farmerly WFNE), Wilmington, DE (601) I 07!13!15 0,35 95851546902 $1,50D,000,00 1 07!26117 1,70 254671 -EQ -9 $96,000.00 I 08103115 0.35 96851547151 $1,000,500.00 I CID- Discover Bank of Delaware(6D7) 1 1 10!03117 1.50 795450P149 $245,000.00 I Totals $4,000,000.00 1 CID -Sallie Mae Bank, Murray UT (1101) I ........ ...... nese__ w ..... ........ea.... 1 12!1 Of 1.45 58403BH25 $200,000.00 I (Monthly) CID -Medallion Bank, Salt Lake City, UT(601) 1 I 03!08118 1,30 050624XK4 $245,000.00 1 fall Bank of Rosemount I CID - Bank Baroda of New York, NY (602) I 1 07117/18 1,60 17284CHW7 $150,000,00 ] Date I CID - GIT Bank - Salt Lake City, UT (603) ] Due Rate Account# Amount I 07!19118 1,90 05568P4G9 $245,000.00 ..._.._.._..... _._..__......__._.-_._._. ----------------- I CID - BMW Bank - Sat Lake City, UT (606) I 08109115 1.85 36161TCH1 $96,000.00 CID - GE Capital Flnanclal of Utah (602) 1 08!29118 1,90 58733AAP4 $200.000.00 Totals (MBS) $1,881,496.00 CID - Mercantil Bank- Coral Gables, FL (601) Totals $0.00 1 07!24119200 02587CAJ9 $245,000.00 ........... .....=e=====__ - CID -American Express Bank, Sell Lake City, L.17(101) ..........y a=e=e=y ______,__ 09111119 2,16 856284298 $95,000.00 C1D - State Bank of India, New York (208) Venture Bank 1 01!22120 1.80 14D42DRD4 $245,000.00 Walls Fargo I CID -Capital One Bank, Glen Allen, VA (606) Date I 02104120 2,00 38148JKC4 $96,001}.00 Date Due Rate Account p Amount I CID- Goldman Sachs Bank, New York, NY (607) Due Rate Cusip# Amount .._.._.._._._ _...._._._.._............. .... _.__..__._._ 1 03126120 1,80 88413QBDD $245,000.00 ....-_._._..--- --------- ----- -------- ----------------- ..__.__._._.._._. DSII 0!15 0,50 5694 $501,284.72 I CID - third federal Bank, Cleveland, CH (603) 31104116 2,05 361599-4J-7 $240,000,00 I 08/28120 2,25 29266MB40 $200,000.00 CID- GE Capital Retell Bank - Draper, UT T1 D1) I CID - Enedrank USA- Sat Lake City, UT(202-50%;203.65%) 06108117 1,85 99000N-FZ-9 $100,000.00 j 09114120 2,25 31938CF74 $200,000.00 (Monthly) CID - Comeniry Rank (formerly WFNB), WIIminglon, DE (601) ] C1D-First Rusin...Bar k- Madison, Wl(601) 07130/19 2.00 319141 -CA -3 $245,000.00 Totals $501,284.72 09125120 2,75 3361 (1 $150,000.00 I CID -First Bank- Highland Park, IL (101) CID- First Premier Bank - Sioux Falls, SD (603) I 11107/19 2.15 320228-KX-4 $200,000.00 09115121 Step 40434AMR7 $149,625,00 1 (Monthly) CID - 1st Flnanclal Bank -Dakota Dunes, SD (507) US Bank= CID - HSBC - McLean, VA (508) I 01121120 1.85 66476C -BAS $247,000.00 ] 02124!22 Step 94986T -JV -0 $245,00000 I (Ruaderly) CID -Northern Bank&Trust - Woburn, MA (607) Data (Quarterly) CID - Wells Fargo Bank of SD (206.405A; 606-20A; 607-40%) I 02120120 2.00 89235M-GZ-8 $245,000.00 Due Rate Account # Amount 02128f22 2.25 947a9PBN3 $245,00000 I CID -Toyota Financial Savings Bank, Henderson, NV (101) »------_--------••-•-••••-•--•••••••••••••••••• •• -----------• (Monthly) CID- Wehster 5 Cents Bank, Webster, MA (603) I 02!02121 Step 318495 -JK -5 $245,000,00 ????7777?7? 0.05 104790484406 $11,985,300.63 I (Monthly) CID-FirstAmericon Bank, Elk Grave Village, Il (601) 12131115 Money Marked Savings I (No Maturity Date) I I I 03131116 2.25 9128260,,41 $102,312.59 (Semi -Ann) (Treasury Note)(202) 02115121 3.63 912826PX2 $220,000.00 (Semi -Ann) (Treasury Note) 1202) 17116!19 2.00 3133EEEFC-9 $499,815,00 06111121 2.00 3134G45J3 $490,197,50 (SemiAnn)(FFCB)(101) {Semi -Ann) (FHLMC) (207) 12130119 2.00 3130A3 -MR -2 $299,961,00 12109121 2.58 3133EEEOD $648,142.95 (Semi -Ann) (FHLB)(101) (Semi -Ann) (FFCB)(601) D1129f2e 2.00 3133EE-AA-8 $600,630,00 06112123 2.50 3t34G45G9 $490,470.50 (Seml-Ann) (FFCB) (601-50%, 606-50%) (Sam] -Ann) (FHLMC)(601) 03109f20 2,00 3130A4 -AB -8 $1,250,000.00 (Semi -Ann) (rHLb) (101) 01!35!20 Step 3136GJAVI $394,416.00 33139f20 2.05 3130A4 JSA $300,000,00 (8emi-Ann) (FNMA) (101) (Seml-Ann) (FHLB)(207-6139A; 607-50%) 03125122 step 313382FG3 $491,290.00 06112120 Step 313403 -VX -5 $495,795.00 (Semi -Ann) (FHLB)(501) (Bemi-Ann) (FHLMC)(601) 05!25!22 Step 313379 -HQ -5 $692,195,00 I 12MI20 2.12 2133EE-VA-5 iiigo,0ooxo (Semi -Ann) (FHLB) (606) I (Saml-Ann) (FFCB) (601-40%; 606-60%) 11109/22 Step 313380-ZG-5 $293,081.00 I 02!11121 200 3133EE-NP-1 $500,000.513 (Semi -Ann) (FHLB) (101-50%, 607-5D%) I (Serol -Ann) (FFCB) (603) 1 121! 9122 Step 313381-F9-2 $974,470.00 I 05!08123 Step 313382-J7-6 $445,221.00 1 (Semi -Ann) (FHLB) (101-50%; 606.50%) I (Seml-Ann) (FHLB) (696) f 02129/23 Step 3133823GG $294,051.00 1 05123123 Step 313383-2W-0 $999,410,00 I (Beml (FHLB) (205-50%; 607-509A) 1 (Semi Ann) (FHLB) (101-50%', 202-50%) _ Totals $13,336,424.08 1 06127123 Stop 313383HR5 $299,626.00 I 05120124 Step 313DA2-OR-D $300,609.00 I (Semi -Ann) (FHLB) (601-50%; 602-6014.) (Semi -Ann) (FHLB) (607) Sterling State Bank Data Due Rate Account Amount _..-.._._.__.....__.._._..._._.._._......... ........... 7?????????? 0.44 990005332 $609,907.29 12!31115 Money Market l Savings (No Maturity Date) Totals $009,907.29 Totals (Morgan Stanley) $6,429,994.00 Tortola (Wells Fer9o1 $8,21GA47.00 I l 1 Total Investments $37,736,612.08 j -n Mansly MINIMUM. utn W W bo 9 A09 DHJIM UJI-1 o oR o3vQ,� Novim Rp Q �W Q it ^ O W o p W N N W m i N w WNWg S� g w �vpg m wo8S88�0000$`gb'� o c .tl 0000w C C N pm1pp WW 9 SP1 OO4 pO O.OpO S m � O P W VAI Ip.�� o y+t 'o cml A {fpm A W p�oo Imn lJe faf1T� IJ N ' W fT a o ' ?1 t1mtT� S N.pImNA o.Wim 4 �O N V P fO 'm L,w mw k7owt"i .Nam'r"'4. 1u N o �+m u cVi�oy uVi p�We WOm G+1O W�kh W O O W W � Vpp W G W S V S W W V o W o w o EiPmA-�V V � VN OO U� Si '�ta19.'�'m�mmwrn'w '$ I,°VV ❑ mNw� cn ��mio woo qwo o N V N N VP b O W m m 0 0 0 m N !D OVI AVI Iy oP W WN ""p' [N1�o Vi NO[ao + p pWp�� !ryry➢ M1N1 C� W N+ A W�� N W A J o V .......... (O N m U 1111Hw NOW 000 oa000SoodSoSSo S S o S S S 0 o S 0 0 o O o S 0 UW m !A A INV W+ A !tV1Ct .N opg pq E.fIlAN p. .N.pp�W�,uu 1NN4.5�y5 QOtl S S S w� W SOW V S N IT S S S ITN m gNN,O X. op 1'q,0i9u611.111 g000w������$SS�oo d,�i p+�Ul O � GI W t.sp O7�G� o So o V V o o V V W w WP IOC O fW V 0 0 0 V +!➢O,OI POI W+ $I m 1OIyJ w�" OyI �Tp 4 ppGN WV pW��Nu V N V p�!DAAO S SS �➢ W Poi W fno S+o O+O in oom N.4o my Zu m`cw4a SSS�SS Eli o�� V SmINnNN P OOC V Y� J W+I IgOSa[Vi1Sm O O� W+J �o� W A tN.l Pu �W N Aq+.^I T mea W m w V+J ONN P �, tdi� A � OO .P N o iNW11N po W 4 m P��+Q W ST _N O4i 4iO+mw OI O �A O u �W Co 'V 6oJlJ N W vvII [[..�� WW pp11 WW OwC IJ Who u� p .R„ S I.� m W fOO' .qP WAN ado A V Co !h TSN+ W W J+J wNN too N W O A I^N.�� h�h11 mNN o m W t'O I'a C1��JII ffV� O O N O fT „W 44II A m V� NOI NW NW m O W W m [ll fn P P 0o N aI -I muv�P Wo iWo O Ol + fh O P A W W 6 O W m o his W 9C fT7 4 O a N � m� W 0o m C o V fJ IJ tl o[n V�� YJ�O o o L+ N oo11 WW WW OO11 G WW qW V W WO V OWSJ VS W � W pp11 }}�� W w o S V �SS�1m L!m � .'¢ "" + $ Rai Rai IIS IVmil m Ww". t�.V mo^+' 1 WAN m Mess.; _ �fJ �6i TA I m N l3 [O aaM� C ��II O _ eC W N N N QIUN O�W [n o00 Vi oA JNm+b W W � W W Ca O m O1a� VWN C 1J q -'N m II o iAp A �p Of11 FT �n i.J i.1 m V oo MINE .l .....�� OJ .�...� 0..... .. O W y W woso[s.1h'moi � W V g W S W m (:lo q W 6i p pd S V VSO V v W W G o W V o G Ip � C1 � II NN l 0 ,j N N + V + W W A [T _ IV m a 4 V V� W W ,19 -• ,W ,m Vt �l + J d N N V A O 1� W II b G tJt � O I � N 'a �3 v'n ral. aNiN�Qi 'w gOq.A Nm NO � O '�'m �i�0o V CoAW.aO m U 'WooN WW .W Lo. Olow WWOO11 WWOOII WW ...�W W 4 V g V —pus W o V V o o V V W W o O w V O O q III g Go CWo W W � J m W m N m V ��pp WW NN P OI P+ J m OI 61 m N u 41 ' J A T � 0 A 6ff..IImm� mw arim. 1 !D N � � cn o o A N o Uv 'm'q r%W$ [Vil'<Vi,ww+ w m o W m m Ili mm�o�mr°'ouggwwopp °� 12 � � n m7a F.1 qa"'�n RW woQOQ�WOI OIW.io � II W N y CN NmuZA �y �. � ."J.-ti-.-�ti-J Oq`P,V`P,O S WW QO11 WW OO�� OW�]WWSVSWW+ISwO m W W q o1 VVOOVV OOWVSOO .3. � A V m yip WN IIS�A n ' VV A+. 111 GI V I N + � N NomS I'ow obi m}S 11a:111 : qO �o!!PON Nlmii y+ + tl�i m oo� oo�om7n V m a to NA In m m o 'J W tV b q ? V A O .. m 4f W pI W � Q W W W O V S W W V o W o W m w O1 V V o o V V w W o o V O O q 0 N m liaison? o U + m N 6W1 Ap .• U1 [iii oW1 m W m N m ,4 ,P IV ,G_ _�09� ,Oy� IwV Oi Q oNj-W+ttlii o9? �Np NW ttJ Im111f1 .P. W W N c.f wAo rn IW V ? Ntwn !l1 VoV �O18 a�J a o41+w m IVii W� OwVWWOVOWWVOWO W Tm 6m_ii�aUj��M� 4mI SVVSSV.,y SSw EII w I'� III w 1+ wmmUSSIoM'w AVEi I.i+ I� m A PIT m �� mom W l'Ooo OSA VNV so +F '. ., N �.J A-' ai ,A +tel ,Oa ,USW Ge !O +wflW� OI o'u�viAOwN N + ��II ... J+JONNJ Am mm J I`Wo iCao ba WHIM A NIT Oa Nm61�P8+W In�N V GS 'J oW v to m u W W o W mpO ttbb.� 1� o .. mow' wN "�o��a��ao �A V pq o w www o °how° -i o'o Y'i o°�i °-1'o'o °-j w'oo woo go Donation and Assignment Balances 3131/2015 Account # ----------------- Description ----------------------------------------------------------------------------------- Balance --------------- ---. 101-22220 Deferred Revenue - Fire Department 13,130.76 101-22221 Deferred Revenue - D.A.R.E. Program 1,195.89 101-22222 Deferred Revenue - Police Department 10,031.36 101-22223 Deferred Revenue - Park & Rec Department 8,226.31 101-22225 Deferred Revenue - Administration 37,605.96 101-24404 FIB Assigned for Armory Debt 265,461,00 101-24405 FIB Assigned for Health Insurance 225,000.00 101-24406 FIB Assigned for Cable TV I Franchise Renewal Costs 5,703.01 101-24419 FIB Assigned for Additional Police Dept. Training 903.81 101-24420 FIB Assigned for SKB Landscape Program 61,700.00 101-24421 FIB Assigned for Outside Schools for Fire Department 5,000.00 101-24423 FIB Assigned for Chess Consultant 5,400.00 101-24424 FIB Assigned for Christmas Light Replacements 13,000.00 101-24425 FIB Assigned for Technology 20,000.00 101-24428 FIB Assigned for Police Reserves 3.31 101-24429 FIB Assigned for Government Bldg Repair & Maintenance 67,834.33 101-24430 FIB Assigned for Parks Maint Repair & Maintenance 185,543.60 101-24451 FIB Assigned for Fuel Reserves 32,711.66 101-24452 FIB Assigned for Street Chemicals and/or Storage Facility 48,000.00 101-24453 FIB Assigned for TH3 Cleanup 100,000.00 101-24454 FIB Assigned for Future Parking Lot Maintenance Costs 378,000.00 101-24455 FIB Assigned for Siren Repairs/Replacements 2,297,54 101-24456 FIB Assigned for Future LED Light Upgrades or Add'I Lights 18,000.00 101-24458 FIB Assigned for Election Equipment 131,732.75 101-24459 FIB Assigned for P.W. Parking Lot 12,338.54 101-24460 FIB Assigned for Non -Recurring Athletic Field Costs 30,000.00 202-24425 FIB Assigned for SKB Trust Fund - Future Projects 1,589,000.00 202-24426 FIB Assigned for HVAC at Steeple Center 97,000.00 202-24427 FIB Assigned for Landscaping at Steeple Center 60,000.00 202-24428 FIB Assigned for Council Chamber Audio Visual Equipment 274,000.00 202-24429 FIB Assigned for Central Park Paver Replacements 5,000.00 202-24430 FB Assigned for Steeple Center Exterior Signs 15,000.00 202-24431 FB Assigned for Community Center Reader Board Sign 17,305.00 202-24433 FIB Assigned for Fire Alarm System for CIC 40,000.00 202-24434 FIB Assigned for St. Joseph's/Library 6,956.75 202-24437 FIB Assigned for Senior Exercise Equipment 41,000.00 202-24438 FIB Assigned for Neighborhood Amenities 41,000.00 202-24439 FIB Assigned for Jaycee Park Batting Cage 22,000.00 202-24440 FIB Assigned for Shade Canopies for Dugouts 30,000.00 203-24430 FIB Assigned for AUAR 20,959.00 203-24431 FIB Assigned for 42152 Costs 180,000.00 203-24432 FIB Assigned for Akron Avenue Corridor Study 47,213.85 203-24433 FIB Assigned for Pedestrian Improvements 178,244,03 207-24455 FIB Assigned for Siren Replacements 2,000.00 207-24480 FIB Assigned for P.C, Hardware 5,828.76 207-24481 FIB Assigned for Fire Dept. Technology Updates 15,557.81 207-24482 FIB Assigned for Security Equipment at City Hall 1,405.00 207-24483 FIB Assigned for 4x4 Brush Truck Replacement (Grass Rig) 22,194.00 207-24484 FIB Assigned for Hose Testers (Fire Dept.) 0.00 207-24485 FIB Assigned for Police Tactical Gear Replacements 2,996.23 207-24487 FIB Assigned for Police Squad 92.00 207-24488 FIB Assigned for City Accounting Software 13,720.05 207-24489 FIB Assigned for City -Wide Software 331,000.00 207-24493 FIB Assigned for Police Photo Imaging Software 4.09 207-24495 FIB Assigned for SCBA Compressor 3,420.00 207-24496 FIB Assigned for Future Equipment Purchases 161,437.37 Projected for 12/31/15 (Does Not Include Future Interest Earnings) City of Rosemount Building CIP Fund - #202 Monthly Review - Audit of CIP Coding Amounts For Month Ending 3/31115 2015 CIP Budget - Departments to Use Following Encoding., 202-49002-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 Year 17 of 20 P.W, Building Addition (Principal) 19,800 521 0.00 19,800.00 Public Works Senior Housing 1 Activity Center Expenses 3,200,000 529 150,869.23 3,049,130.77 General Government (Budget Includes $400,000 SKB Donation) Security Card Entry System 95,000 530 0.00 95,000.00 General Government City Hall Generator 155,000 531 0.00 155,000.00 General Government Covered Benches - Charlie's Park 35,000 533 0.00 35,000.00 Parks & Recreation Remodel Police Offices - Add 1 30,000 534 0.00 30,000.00 General Government Transfers 0 710 0.00 0.00 General Government Year 17 of 20 P.W. Building Addition (Interest) 4,200 611 0.00 4,200.00 Public Works ------------------ -------------------- 3,541,500 153,369.23 -------------------- 3,388,130.77 Sum of Positive Balances -------------------- Only Included Total Levy for 2015 24,000 COH 3131115 3,826,096.40 FIB Assigned for SKB Trust Fund Projects --- ---------------- 1,589,000.00 FIB Assigned for HVAC at Steeple Center 97,000.00 FIB Assigned for Landscaping @ Steeple Ctr. 60,000.00 FIB Assigned for Council Chamber Equip. 274,000.00 FIB Assigned for Central Park Pavers 5,000.00 FIB Assigned for Steeple Center Signs 15,000.00 FIB Assigned for CIC Reader Board Sign 17,305.00 FIB Assigned for CIC Fire Alarm System 40,000.00 FIB Assigned for LibrarylSt. Joe's 6,956.75 FIB Assigned for Senior Exercise Equip. 41,000.00 FIB Assigned for Neighborhood Amenities 41,000.00 FIB Assigned for Jaycee Park Batting Cage 22,000.00 FIB Assigned for Shade Canopies -Dugouts 30,000.00 Reserves Available 411115 --- ---------------- (1,800,296.12) 1st Half 2015 Levy to Receive 7115 12,000.00 (Reed $xx,000 7115) 2nd Half 2015 Levy to Receive 12115 12,000,00 (Reed $xx,000 12115) SKB User Fees Still to Receive in 2015 800,000.00 (Reed $xx,xxx.00 YTD) ($800,000 Total Expected) Total Unassigned Reserves ------ ------------- (976,296.12) Projected for 12/31/15 (Does Not Include Future Interest Earnings) City of Rosemount Street Cl P Fund - #203 Monthly Review - Audit of CIP Coding Amounts For Month Ending 3131115 2015 CIP Budget - Departments to Use Following Encoding: 203-49003-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 JPA Administrative Fees 0 319 0.00 0.00 Public Works Miscellaneous Engineering Fees 0 303 1,968.00 (1,968.00) Public Works CR 73 Design - Bonaire Path to IGH 64,300 530 0.00 64,300.00 Public Works Pavement Management Program 760,000 5311710 0.00 760,000.00 Public Works Pedestrian Improvements Program 125,000 532 0.00 125,000.00 Public Works Costs for Closed Projects 0 5351720 0.00 0.00 Public Works Total Levy for 2015 951,800 4,468.00 760,000 COH 3/31115 FIB Assigned for AUAR FIB Assigned for 42152 Costs FIB Assigned for Akron Ave. Study FIB Assigned for Pedestrian Improvement Reserves Available 411115 1st Half 2015 Levy to Receive 7115 2nd Half 2015 Levy to Receive 12115 SKB User Fees Still to Receive in 2015 ($125,000 Total Expected) Total Unassigned Reserves Projected for 12/31/15 949,300.00 Sum of Positive Balances ------------------ Only Included 2,701,174.10 20,959.00 180, 000.00 47,213.85 178,244.03 - ---------------- 1,325,457.22 380,000.00 (Rec'd $xxx,000 7115) 380,000.00 (Reed $xxx,000 12115) 125,000.00 (Rec'd $xxx,000.00 YTD) 2,210,457.22 City of Rosemount Equipment CIP Fund - #207 Monthly Review- Audit of CIP Coding Amounts For Month Ending 3131!75 2015 CIP Budget - Departments to Use Following Encoding: 207.49007.01-(xxx).00 plus number below by Item Object Spentto Item .................................................. —............... Budget Code Date ...................... ............... ..................... Balance ..... -............... ..... Department ... ...-............................. General Fund Administrative Fees 2,500 317 2,500.00 0.00 Admin Fees Roller (Replace #8129) (Moved to 2016) 0 540 0.00 0.00 Public Works Ground master (Replace#8066) 80,000 541 O.DO 80,000.00 Public Works Ground master (Replace #8073) 80,000 542 0.00 80,000.00 Public Works Tractor (Replace #8409) 110,000 543 0.D0 110,000.00 Public Works 4 Squads (Sell Back 3 and 1 New) 108,000 550 0.00 108,000.00 Police 4x4 Brush Truck Replacement 85,000 551 0,00 85,000.00 Fire Pickup (Replace #8332) 30,000 552 0.00 30,000.00 Public Works Pickup (Replace #8307) 31,000 553 0.00 31,000.D0 Public Works Pickup (Replace #8335) 31,000 554 0.00 31,000.00 Public Works Pickup (Replace#8331) (Moved from 2016) 35,000 555 0.00 35,000.00 Public Works Body Cameras 10,000 580 0.00 10,000.00 Police Replace Police Dept. Long Guns 10,000 581 0.00 10,000,00 Police New Squad Emergency Equipment 22,500 582 0.00 22,500.00 Public Works Squad Set Up & Installation 25,500 583 650.20 24,649,80 Police Paver Trailer Replacement (Moved to 2016) 0 584 0.00 0.00 Police Replace 3 P.W. Laptops 5,100 586 5,100.00 0.00 Finance Replace City iPads 10,000 587 0.00 10,000.00 Finance City -Wide Software 25,000 588 0.00 25,000.00 General Government Phone Server Replacements 20,000 589 0,00 20,000.00 Finance Network/Server/Storage Updates 110,000 590 37,116.33 72,883,67 Finance Platter/Scanner Replacement 16,000 591 0.00 16,000.00 Public Works -------------------- 846,600 45,366.53 --------------------- 266,849.80 * Sum of Positive Balances --------------------- Only Included Total Levy for 2015 540,000 COH 3131115 1,615,166.04 FIB Assigned for Siren Replacements 2,00000 FIB Assigned for P.C. Hardware 5,828.76 FIB Assigned for Fire Dept. Technology 15,557.81 FIB Assigned for CIH Security Equip. 1,405.00 FIB Assigned for 44 Brush Truck -Replace 22,194.00 FIB Assigned for Hose Testers 0.00 FIB Assigned for Police Tactical Gear 2,996.23 FIB Assigned for Police Squad 92.00 FIB Assigned for City's Financial Software 13,720.05 FIB Assigned for City -Wide Soifware 331,000.00 FI5 Assigned for Police Photo Imaging SW 4.09 FIB Assigned for SCBA Compressor 3,420.00 FIB Assigned for Future Equip Purchases 161,437.37 Reserves Available 411/15 788,660,93 1st Half 2015 Levy to Receive 7115 270,000.00 (Rec'd $xxx,000.00 7115) 2nd Half 2015 Levy to Receive 12/15 270,000.00 (Reed $xxx,000.00 12/15) Sale of Old Squad Cars 3,250.00 (Reed $5,750.00) Total Unassigned Reserves - -------------- 1,331,910,93 Projected for 12/31115 ^~- (Does Not Include Future Interest Earnings) z N a���01[]IANo� �{ a3 N 9 0 o v ro l� ro ro IDm,I gf1i N 45# jQ W bV W l]i] W 11i V ul � ,? A 4 e -W Q N IND W NN �1N W W W m m W ArOOAmrr O 0 0 0 0 0 0 0 0 O O O O O O O O O O { o o l o 0 0 0 0 0 0 0 0 0 0 o a o 0 0 o b b Io ola000000ao$$�OOOo000 NY v A W ill 1AI�� E22 j p0m 07 ill N G1 I O Ol D7 0 0 Ip f�O O� N m A� b� p� .ON1 111 pWj i y0 p1 0r0�n]�IA I ,UNC V dgpOdgadq W Od4��yq�Eo ONAN,u�i it W A O O O O O O O O O W O O V O O W W W N II I ;I � V 0w�rn0oNoow�l-y rl 000ro�l vin Wm 0 Ol po IIS m O O W V OOA00 W V W �1A O �P [0O II p, OAOOOO V,IOD 6�Ja V,10D fN0 0,100 ,Om0N II A A O'(r (fl OOA�ONO{O OlOOr0oO1p-+ II In W O fD CO O O r A W O m b N N r b ttl O u W vm�maao��mC�oA��m A � ryary.o � 'a?ld Arc �ff � a� 1 xm3 Wmy^�W^, =p.Wn� �jniNa. Ci u' Avery -1 y pq1 N N r 01 amaLa'�� �W3.Nw ro I m m Q N � W W ppOQ p� OpNp OOOs O 1T 1T p o 2S p,Oq o P. 000000 o p o 00000 O b o 0 0 0 0 0 o b o b 'b 0 b b b 'b boo 0 0 0 0 0 0 0 0 0 o a o 0 0 o b o b o b b rnA .W�11N �[n IWn IPS W W N„pWppp W �� V J W N.P o<Jit [OiIN� [m+1N �I 0a?au cs �f nl ul a00000mcn 00000b � 000Aoow�w�$���y�a'S�goo WA c1t S]I cu O 1.] (-14�I m N OA��OONO+Al Cm31000NO0o00 W O � I 000 W 0000 W 13t OOOOA000000000 O a I r r N p P a. . W boo o . . . p `r� O000i0000�'woaor:�w�00000 , W N N p N m P-,- 0 O I O 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 O 0 O 0 0 0 0100000000000oo0oopoo OO ❑ O0 OoObObObObObObOpOoObbO OnOpO0ObObbO ObObO0O 0 ll b l O O p Op O O O O O O O O O O b O b b b b O I O I O 0 9 Q p p b 0 0 O p 0 0 0 0 0 0 0 O 0 la o oop000bbopbabab0000 itol0 0000000000000000000 l 0 0 0000000000=00000000 Lii l ii O Jococoococc000000000 Jlb of 000000000000000000a Ili l ' O O OQpK]4]q C]p4boQpo0004O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 u o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n II I O D O O O O O O O O O O O 0 0 0 0 0 0 0 0 II O, O O O O O O O O O O O O O O O O b O b b Ik I II ;I o0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 Ii O O OO O O O O o0 0 00 o 0 oO o 0 0 0 o0 o Ob 00 II 11' I I 0 0 0000oo0oaoo0oa00000 u b 0 o 0 0 0 0 0 0 b 0 0 0 0 0 0'b 0 0 II 0 0 00000000=0000000000 O I O o b g q q p p q q p 0 0 0 q q 0 q O D 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 p o 0 0 0 0 0 o a o 0 0 0 0 0 0 0 0 o a o O O O O O O b O 0 O 0 0 0 0 0 0 0 0 0 O 0 0 o o a o o a o 0 0 0 0 0 0 0 0 0 0 0 o O o 0 o o 0 0 o a o 0 0 o a o 0 0 0 0 0 0 0 0 0 0 I to m I � 0 0000000000 0 o a o 0000000 i0 i a O O O b 0 0 0 o O 0 o O 00000000000 I2 I C I� O O O O O O O O O O O O O O O O O O 0 0 0 0 13 I 0 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 0 0 0 o i Q 0 a o 0 0 0 0 0 b 0'r� 0 0'0 b o '0 o a o 0 o o I m l 00-0000 0000a000oboo I o w ��a �i u vvma g EF°Iiaoa.o Ngog mM.EaFF5 S m o N W A °1s V W 0 y m a y 3 g� P, Q v m q v � w 4. m 5, m e "U+M m a 3 S' An"S a cna cn .Nim w rn II y II O ° I'c icilJ m0 fb V N El y 2 a NNo� o A fAD fAD (AD lA° [AAAD 13 3 D ° N N II to < N S� 'M M N ry nim'r000 {{pp N V o �I W IJ W �n W V Ui ww N s-. 3 W 7 A O O l0 ZA d� v� O (il O N 0 0 0 0 iJ p V N W W IVI� W CL m O ik QQ IB N In Q O b b b O 6 b W N W g Ino CD i6 N.-, In, G C w .f�p"{c�a? 0 q EE k 2 q a a ((`�❑���. n_ o CD .o{[pb', 2 2 1 wc ijIff W Y --4 V 00000000paVm " _ p�p 0 o GY (� N _- W Z * O � � a. oSl�y'd N OOOOOOOOMOL 0 O O W N O pO 0 O pO pO O O n m 97 v X W s s N :I v lD (n m N (D OWD .0W P. .AN As f60(OT onOao.Oooa o a o p o p p O p p o p p o O$ 'p0 'QU m o o OO 000 O 0 O 0000ao6 00 0 0 0 0 0 0 0 0 o O o O o 0 a o O O 0 ! 0 0 0'q g O n b'0 0 0 0 0 0 00000o00 0 p 0 0'oo'00 0 0 0 0 0 0'Oa o 0 o 0000000 000000 I , o w ��a �i io N W A °1s V W 0 cna cn .Nim w rn II y II O O L*iA J°1 N (° �V i i O O O W fb V N �j� 0 0 a W DO fD O N O m O q 0 D] O II to m {{pp N V o �I W IJ W Ln O O l0 ZA d� v� O (il O N 0 0 0 0 iJ p W O N O V W CD O O lD s O m N VI OLD O a o CD oIII 1 wc ijIff --4 V 00000000paVm " CDoa 0 w0vO0000pCmOnw 04A400 -01 N N OOOOOOOOMOL 0 O O W N O pO 0 O pO pO O O n OWD 00 (WD 000 F n ; SII m w= co o i pw] N m A W v j W N W N Cn 0 W O AmN mq Nq ppo V V V QD Op W 0000 W O O o V A0 0000 III I Ul W O A V N 10 AA A p p 00 W �N� p O O O O O 6 O d 0 0 6 Ia W 0 0 0 0 0 I ��gGCCC N 01 W0 V NsAA V p0 W 6] OOc000 p O V OOOmDI00000 ! III II � W N s N -+ Oo W oo A (o 1011 s N V s to w V N N 1 p N V fn lD W W N A P!3). o f0 P J Vt BION v(,, O OOS A m0 O O N W 00 s V W 0 0 0 W W O O O O O (D C11 d'J �I�OOOOO S I II N II N N NN N N SO N V V sD1 V oSD V Ns .p (D� Oo'O o 061s 00101q 000 V N 00000 i T O @� Zr ro 0 ill 0 n o 0 l 0 0 o 0 0 0 0 0 0 0 0 o p o o q o o o o 0 o o o o o o g o o 00000000000 000 0 Op 0 o p o p Q 0 p o 0 o p p o 0 0 0 o 0 p O o o p 0 0 0 0 0 0 0 0 o p o o 000 o s o 0 0 o 0 0 o n o o n o n 1= 1 T M y c p 7 � N Q ! 13 3 11 u ! I I ro G o Iln o pnoo'000ao00o00 0 0000000 000000000o `� II q l o g o o O q o o q q q o p p p p! 0000000 O n 0 o n 0 6 0 0 0 0 r o a p W o 0 0 0 0 0 o p o 0 0 00 0 o O g 0 p a p o o p q p 0 p p o o I II 0 II O II 0 O I a o o 0 o o o 0 o 0 o o 0 o O p 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 o p O o o O o o o o o o o O o o o .... O O O O O g 0 0 0 0 6 0 0 0 i I 11 I II Q II p p Q p 4 0 D 0 0 0 0 O a 0 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a o o ' Q II o p I 0 0 0 0 = 0 0 0 0 0 0 0 0 0 g o q 000600000000000'0-01 o o p o 0 0 0 0 o O o 0 0 0 0 0 0 HoH o 0 o o 0 o 0 o o o o o o O o o O O O O O O O O O O O p O 0 O O g o 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 0 l a o 0 o o o 0 o c o o a o o o o o o I ii i � II II q o 0 o g O o q Q q p p p 0 p p p 0 0 0 0 p 0 o p 0 0 0 0 0 0 0 0 0 0 i II o u 0 o o! g o Q 0 o p o 0 p p p o p o o o a o 0 0 0 0 0 0 0 0 0 0 o 0 p 0 0 n O n o 0 o n o 0 0 0 o a 0 o 0 0 o a o 0 0 0 0 0 0 o a o o g o o I l III I ! I ! III III o a o 0 0 0 0 0 0 0 o g o 0 0 papa fl0000=0000000000000 IIo II0 a O 0 0 0 0 0q 0 0 0 0 0 0 0 0 OO g OOOoOooOooO III I � III 1 C �I p o 0o ppa QppOp pOO d 0 0000 f]on0 o000000o do ! D 3 III p o Q o 0 p 0 0 0 o o 0 0 n o [n n o n o 0 0 0 0 0 0 0 0 0 0 0 0 110 o 1 0 o o a o 0 0 0 0 0 0 0 0 0 0 0 o q� o 0 o g o 0 0 0 0 0 0 0 0 0 0 0 0 o S n ! I' 0 lo;0 0 0 0 0 0 0 0 o a o a O o O o 000000000a00O0 0 0 o a o o a o 0 0 0 o a o o a o 0 0 0 0000o0000000000 oo0 9 !m II 0 1 0 00000000000000 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o I z -I r N 5 ahav w,� a 0 r^, ? ..01790.�nC) '' e. w U2 ti o�'ro oa:0, m$' �v� 0 5 3 a [O V (n Q u li if w m A Il W W -M N (J1 NNP1.0 „w� N €a g0o00000000 jlo 0 oa000000000 H8 0 00000008388888 u ii o m m�No rnrn pp� I I y y cn a a i.� wa(nm jj N p pp000O �p W A II m .P p 0000 Ob fnm III m fn E 0 0 0 O O 6 O N m N fat II I I u II a .v rnrn w u- EE N ONl W a N A a O a (0 ii �v � N � moio0S0gti�iao ii.p p II A N (noNA o W omSNnw C, II N a o� 0 o omAON0 rn ca ii II I Ij o f o 0 0 0 0 0 0 0 0 o a o I o 0 0 0 0 0 0 0 0 0 0 0 0 II o o p p p 0 p p o o p o 0 iio o a0000000000 I10 0 o000oa00ooa II p tl 0 0 0 0 0 0 0 0 0 0 0 1� ii ii l 0 0 0 0 o p a .... opa o 0 II o 'tl i o o O o 0 0 0 o O o 0 n a o 0 0 0 0 0 0 0 o p o Q H ii !I ii , o E o 0 0 0 0 0 p 0 0 0 0 ii 0 0� d 0 0 0 0 0 0 0 0 0 0 o I g I a p p p p o p o 0 0 0 o I I o O O 0 0 0 0 0 0 O 0 0 o I o pop 0 o a 0 0 0 a 0 0 o a o 0 0 0 0 6 0 b 0 0 p o l o a o 0 0 0 0 0 0 0 0 0 00 00 a 0 0 0 0 1 0 0 0 0 0 0 0 0 pp '0 0 0 o a 0 'O 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 o a o 0 0 0 0 N N ti ,@ „A � •W ,N fi o A A (n op�o'rnponm �atlmo W I 0 0 N 00 0 0 0 0 0 0 p 0 0 N A 6AY „A p N 00 o A bi o 0 o a oN o o m o p 0p W 00-P-00000 .0 0 0 0 0 p N I Ln Cn 00 Ln On to0oa�'pa00000 A O N o i (n V rn oocow000r�oo0o00 N 0 0 V V .0.0.0 0 0 AIV 0 0 0 0 W O 0 a V o o a G V S o 0 0 0 p Y o a o o a o 0 0 0 0 0 0 0 0 a€ 0 0 0 00000000000 0 0 0 0 00000000000 o l a o a o 0 0 0 o p o Q o 0 0 0 0 '0 0 0 'o '0 0 o a o 0 0 0 0 0c o00oo0o0a0ao0 Q I O o 0 0 0 0 o Q 6 o p p p 0 a o 0 o a o 0 0 0 0 0 a a o 0 Q p tl tl O o 0 0 0 0 0 o a o 0 PIPPPPPPPPPPPPPP 0 0 0 0 0 o a o a o o a o a o O a a 0 0 o a o 0 0 o a a a a 0 0 0 0 0 o p o 0 0 0 0 o p 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 0 0 0 0 0 0 0 0 T 3 T O 3 n D o O v m C M N 4 f n N 37 LO 310 d 0 W w�3 W m 0 N a m r_ K n ! E � S � 0 0 0 0 0 0 o a o o a o 0 0 o S v ao o 'o 0 0 0 0 0 0 0 0 0 0 0 i i Sl o 0 0 0 0 o a 0 o a o o a a j E i O E c 0 0 0 0 0 0 0 0 0 0 0 o a o 0 ! P 0 0000p0p0000000 E: O tl O a o 0 O O o O a O a O O I z E p o p 0 a p p 0 0 0 0 o a o 0 1 6 0 a o 0 0 0 0 0 0 0 0 0 0 0 0 ! v I � I � p C7 C7 opp 000 0 op Ci0 o I � a 0 0 0a 0 0 0 0 0 0 0 0 00 0 0 ! m