Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
9.b.i. March Interim Financial Reports
City of Rosemount Interim Financial Reports For the Month Ending March 31, 2013 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 - Building 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. Fund Description General Fund DUI Forfeitures Fund Port Authority Fund Building CIP Fund Street CIP Fund "Future Use" Fund (2004) Park Improvements Fund Insurance Fund Equipment CIP Fund "Future Use" Fund (2011) "Future Use" Fund (2009) Fire Safety Education Fund GIS Fund "Future Use" Fund (2002) "Future Use" Fund (2002) "Future Use" Fund (2001) TIF Downtown - Brockway "Future Use" Fund (2004) "Future Use" Fund (2008) Debt Sery CIP Bonds -2005A "Future Use" Fund (2011) D/S Fire Station Refund - 2005D (Old 1996A) Debt Sery Comm Center Refunding - 2001 E "Future Use" Fund (2012) Debt Sery Equipment Certificates - 20078 Debt Sery Equipment Certificates - 2008A "Future Use" Fund (2003) "Future Use" Fund (2003) Debt Sery G.O. Improvements - 20068 Debt Serv, G.O. Improvements - 2011A Debt Sery G.O. Improvements - 2012A "Future Use" Fund (2003) "Future Use" Fund (2003) "Future Use" Fund (2003) "Future Use" Fund (2009) "Future Use" Fund (2003) "Future Use" Fund (2003) "Future Use" Fund (2012) "Future Use" Fund (2008) "Future Use" Fund (2008) "Future Use" Fund (2011) "Future Use" Fund (2011) "Future Use" Fund Debt Sery G.O. Taxable TIF 2008A 8 TIF 20088 "Future Use" Fund (2012) Debt Sery G.O. Public Facilities Refunding -20108 "Future Use" Fund (2009) "Future Use" Fund (2007) Water Utility Fund Sewer Utility Fund Storm Water Utility Fund Capital Investment Fund Water Core Fund Sewer Core Fund Storm Core Fund D/S G.O. Revenue Water -2005C D/S G.O. Revenue Water - 2007A "Future Use" Fund (2011) "Future Use" Fund (2011) D/S G.O. Utility Revenue Refunding - 2010A "Future Use" Fund (2005) "Future Use" Fund (2008) D/S G.O. Revenue Water - 2000A "Future Use" Fund (2008) "Future Use" Fund (2011) Fund Cash on # Hand Investments Total 101 (370,035.75) 7,343,818.81 6,973,783.06 102 37,001.60 37,001.60 201 64,189.70 100,148.99 164,338.69 202 1,046.86 2,841,692.94 2,842,739.80 203 131, 049.73 1, 521, 562.83 1,652,612.56 204 205 70,365.56 432,750.31 503,115.87 206 27,722.25 647,956.45 675,678.70 207 79,545.48 1,417,973.32 1,497,518.80 208 220 221 868.05 868.05 222 7,828.76 7,828.76 230 231 241 242 3,031.58 550,095.13 553,126.71 243 244 301 3,479.95 70,019.09 73,499.04 302 303 1,486.43 405,562.66 407,049.09 304 2,922.37 2,922.37 321 322 (308.46) (308.46) 323 3,433.22 85,611.54 89,044.76 324 325 326 10,695.61 966,470.38 977,165.99 327 3,074.35 1,045,510.07 1,048,584.42 328 58,698.41 100,006.23 158,704.64 329 330 331 332 333 334 335 336 337 338 339 340 381 3,769.02 40,000.00 43,769.02 382 383 2,416.87 365,545.23 367,962.10 384 385 601 510,768.19 4,138,427.97 4,649,196.16 602 88,438.95 1,932,021.41 2,020,460.36 603 256,818.98 2,267,563.84 2,524,382.82 604 25,023.79 80,043.75 105,067.54 605 20,631.77 60,081.22 80,712.99 606 20,579.49 3,998,945.71 4,019,525.20 607 313,653.40 1,538,582.70 1,852,236.10 610 3,121.89 3,121.89 611 549.21 190, 470.63 191, 019.84 612 613 614 220.80 170,000.00 170,220.80 615 616 617 5,816.50 140,467.84 146,284.34 618 619 CITY OF ROSEMOUNT CASH ON HAND REPORT March 31, 2013 Fund Description "Future Use" Fund (2009) McMenomy Property- Project #405 Rosemount Pedestrian 8 Bicycle Plan Park 8 Ride Project "Future Use" Fund (2008) Minea/Kogl- Project #407 149th St. W. Improvements - Project #446 145th St. Pedestrian Improvements - Project #447 "Future Use" Fund (2009) "Future Use" Fund (2011) "Future Use" Fund (2012) "Future Use" Fund (2009) "Future Use" Fund (2006) "Future Use" Fund (2006) Business Park 2nd Add'n(Pahl Prop.) - Project #413 Glen Rose Addition - Project #397 "Future Use" Fund (2011) "Future Use" Fund (2006) "Future Use" Fund (2011) "Future Use" Fund (2011) Glendalough 4th Addition - Project #435 "Future Use" Fund (2009) "Future Use" Fund (2009) "Future Use" Fund (2009) Marshes of Bloomfield- Project #433 "Future Use" Fund (2011) "Future Use" Fund (2009) 2010 Pavement Management- Project #428 "Future Use" Fund (2011) Diamond Path Trail Project - Project #434 Connemara Trail Improvements - Project #431 "Future Use" Fund (2012) "Future Use" Fund (2011) Prestwick Place 4th Addition - Project #444 Prestwick Place 3rd Addition - Project #436 Prestwick Place 2nd Addition - Project #425 2012 Pavement Management - Project #437 2013 Pavement Management - Project #445 Greystone Addition - Project #439 "Future Use" Fund (2006) Civic Campus Connector Trail- Project #441 "Future Use" Fund (2006) TH 3 Underpass- Project #443 Prestwick - Street 4 Prestwick - Street 8 Prestwick - Street 9 Connemara (East) Prestwick Place 7th Addition - Project #448 Greystone 2nd Addition - Project 9449 Prestwick Place 8th Addition - Project #450 "Future Use" Fund (2006) "Future Use" Fund (2006) "Future Use" Fund (2011) "Future Use" Fund (2007) "Future Use" Fund (2008) "Future Use" Fund (2011) "Future Use" Fund (2008) "Future Use" Fund (2003) "Future Use" Fund (2004) "Future Use" Fund (2009) "Future Use" Fund (2009) Well #16- Project #416 "Future Use" Fund (2012) "Future Use" Fund (2004) "Future Use" Fund (2003) "Future Use" Fund (2004) "Future Use" Fund (2005) "Future Use" Fund (2006) "Future Use" Fund Fund Cash on # Hand 401 402 403 292.25 404 (8,892.68) 405 406 407 (7,324.00) 408 409 410 411 412 413 414 415 (17,914.05) 416 33,745.56 417 418 419 420 421 422 423 424 425 426 427 428 (24,760.11) 429 430 (214,405.34) 431 (207,416.06) 432 433 434 118,727.84 435 273,757.96 436 437 (42,226.19) 438 (32,823.93) 439 150,817.52 440 441 (208,270.76) 442 443 (70,734.35) 444 18,054.92 445 73,281.24 446 36,109.69 447 71,157.08 448 (7,336.90) 449 (75.20) 450 451 452 453 454 455 620 621 622 623 624 625 626 627 628 629 630 631 632 633 Investments Total 292.25 (8,892.68) (7,324.00) (17,914.05) 100, 061.79 133, 807.35 (24,760.11) (214,405.34) (207,416.06) 118,727.84 273,757.96 (42,226.19) (32,823.93) 150,817.52 (208,270.76) (70,734.35) 18,054.92 73,281.24 36,109.69 71,157.08 (7,336.90) (75.20) Arena Fund 650 80,043.03 200,000.00 280,043.03 Totals 1,401,712.08 32,751,390.84 34,153,102.92 Vermillion State Bank 3.40 17284A -FP -8 (Primevest) 0113020 Step 3136G1AV1 Date Rate Due Rate Account Amount 072621 2.00 3134G3YP9 $502,755.00 (Semi -Ann) (FHLMC) (101) I $1,500,000.00 I 032823 2.00 48124JKF4 $240,000.00 (SemkAnn) CID - JP Morgan Chase, Columbus, OH (202) 10/1227 2.45 05573JKC7 $240,000.00 (SemkAnn) C /D - SMO Hams Bank, Chicago, IL (101) Totals $982,7SS.00 Anchor Bank Data 3.40 17284A -FP -8 $150,000.00 1 0113020 Step 3136G1AV1 Due Rate Accoum # Amount 1 07115113 - 0.20 95851576731 I $1,500,000.00 I 09/16113 0.20 95851577770 $2,000,000.00 I 11/04113 0.20 95851578572 $1,000,000.00 1 CID - GE Capital Financial of Utah (101 -50%; 206 -50 %) Totals I $4,500,000.00 i 1.55 36159C -SW -7 1st State Bank of Rosemount 11/0922 Step 313380 -ZG -5 Date CID - Cole GE Money Bank, Saft Lake City, UT (606) I Due Rate Accoum # Amount Totals $0.00 I Rosemount National I Date Due Rate Account# Amount Totals $0.00 US Bank Date I Due Rate Account Amount 1 I ? ? ? ? ? ? ? ? ? ?? 0.04 104790484406 $10,525,419.52 12131/12 Money Market / Savings (No Maturity Date) Totals $10,525,419.52 Sterling State Bank Date Due Rate Accoum# Amount ? ? ? ?? ? ? ? ? ?? 0.44 990005332 $606,866.32 12/31/12 Money Market /Savings (No Maturity Date) Totals $606,866.32 City of Rosemount Monthly Report of Investment Holdings by Institution As of March 31, 2013 (After Fair Value Market Adjustments) Morgan Stanley Date Due Rate Cusip a Amount Morgan Stanley (Continued) Date Due Rate Cusip If 06/10113 3.40 17284A -FP -8 $150,000.00 1 0113020 Step 3136G1AV1 Amount CID - CIT Bank - Saft Lake City, UT (601) 1 (Semi -Ann) (FNMA) (101) 06/10/13 3.40 140653 -3A -2 $150,000.00 1 032522 Step 313382FG3 CID - Capmark Bank of Utah (602) I (SernkAnn) (FHLB) (601) 08/06/13 5.00 36160T -CE4 $96,000.00 052522 Step 313379 -HQ -5 CID - GE Capital Financial of Utah (101 -50%; 206 -50 %) (SemkAnn) (FHLB) (606) 0820/13 1.55 36159C -SW -7 $150,000.00 11/0922 Step 313380 -ZG -5 (Monthly) CID - Comenity Bank (formerly WFNB), Wilmington, CID - Cole GE Money Bank, Saft Lake City, UT (606) (Semi -Ann) (FHLB) (101 -50 %; 607 -50 %) 0820113 1.60 02004M -H6 -3 $200,000.00 I 12/1922 Step 313381 -E9 -2 2.00 856284 -E3-4 CID - Ally Bank (Formerly GMAC Bank), Utah (607) I (Semi -Ann) (FHLB) (101 -50 %; 60650 %) 09116113 5.10 083997 -70 -8 $96,000.00 I 02/2723 Step 313382366 CID - Stockman Bank of Montana (603) 1 (Semi -Ann) (FHLB) (205 -50 %; 607 -50 %) 1126/13 5.00 02586T -BJ -2 $96,000.00 I CID - Comenity Bank (formerty WFNB), Wilmington, DE (601) I CID - American Eqi Centurion Bank, Saft Lake City, UT (601) I 03110114 1.50 05967E -AN -9 $200,000.00 I C. - Banco Popular De Puerto Rico (601) 1 1 0324114 1.50 856284 -YS -7 $100,000.00 1 1.50 795450PN9 $245,000.00 CID - State Bank of India, New York (607) 1 09/08/14 1.25 02587D -CT -3 $150,000.00 03/08118 CID - American Exp Centurion Bank, Sall Lake City, UT (206) 1 0924114 3.25 17312Q -LV -9 $96,000.00 1 1 (Monthly) CID - Citibank, NA- Nevada (606) 022422 Step 949867 -JV -0 1028114 3.25 06740K -CK -1 $96,000.00 I (Quarterly) CID - Wells Fargo Bank of SD (20640 %; 606 -20 %; CID - Barclays Bank of Delaware (601) I 12/01114 5.00 085991 -5J -2 $96,000.00 1 07/1622 Step 313379 -YB -9 $800,208.00 CID - M &I Marshall & Islay Bank - Milwaukee, WI (602) 1 01116115 4.85 085993 -1T -0 $96,000.00 1 CID - Capital One, NA., Virginia (607) I $997,380.00 01130/15 4.00 085993 -6Z -1 $96,000.00 1 (SemkAnn) (FHLB) (101) C/O - Goldman Sachs Bank (101) 1 I 05/18115 1.85 17284A -SF-6 $96,000.00 CID - CIT Bank - Saft Lake City, UT (60 1) 1 06115/15 1.05 33764J -EZ-4 $245,000.00 Totals (Smith Bamey) (Monthly) CID - First Bank of Puerto Rico (207) I (Semi -Ann) (FHLB) (101 -50 %; 202 -50 %) 07/13/15 1.15 20451P -AP -1 $200,000.00 12/0522 Step 313381 -BX -2 CID - Compass Bank, Birmingham, AL (603) I 05 /31/16 215 254670 -F4 -9 $150,000.00 I CID - Discover Bank of Delaware (606) 1 $346,944.50 0725116 110 25811 L -X7 -9 $245,000.00 1 Wells Fargo ( Formeriy Wachovia) CID - Dor a I Bank, Cat no, Puerto Rico (603) I 0824116 1.85 3814264E -2 $150,000.00 1 Date Amount $400,000.00 $500,000.00 $705,019.00 $296,826.00 $997,720.00 $300,000.00 $7,630,565.00 Total Investments $32,751,390.84 Totals $8,505,785.00 CID - Goldman Sachs Bank (607) Due Rate Cusip # Amount 09109/16 1.85 36160T -WR -3 $150,000.00 CID - GE Capital Financial of Utah (602) 11/04/16 205 36159S4J -7 $240,000.00 09130116 2.00 36159C -3H -7 $96,000.00 CID - GE Capital Retail Bank - Draper, UT (101) CID - Cole GE Money Bank, Saft Lake City, UT (603) 06/08/17 1.85 99000N -FZ -9 $100,000.00 01/19117 1.90 06740K -FX -0 $150,000.00 (Monthly) CID - Comenity Bank (formerly WFNB), Wilmington, DE (601) CID - Barclays Bank of Delaware (326) 0427/17 2.00 856284 -E3-4 $150,000.00 I CID - State Bank of India, New York (601) I 05131/17 1.80 982999 -80 -1 $100,000.00 1 (Monthly) CID - Comenity Bank (formerty WFNB), Wilmington, DE (601) I 0726117 1.70 254671 -EQ -9 $96,000.00 1 CID - Discover Bank of Delaware (607) 1 10/03117 1.50 795450PN9 $245,000.00 C/O - Sallie MaeBank, Murray UT (101) 1 03/08118 1.30 060624XK4 $245,000.00 1 CID - Bank Barons of New York, NY (602) 1 022422 Step 949867 -JV -0 $245,000.00 06/1220 Step 313463 -VX -5 $502,910.00 (Quarterly) CID - Wells Fargo Bank of SD (20640 %; 606 -20 %; 60740 %) 1 (Semi -Ann) (FHLMC) (601) 07/1622 Step 313379 -YB -9 $800,208.00 (Semi -Ann) (FHLB) (101) 072622 Step 313380 -2H -9 $997,380.00 i (SemkAnn) (FHLB) (101) I 072622 Step 313380 -3A -3 $1,250,312.50 (SemkAnn) (FHLB) (101) 08/1622 Step 313380 -AZ -0 $1,519,905.00 (Semi -Ann) (FHLB) (101 -50 %; 202 -50 %) 12/0522 Step 313381 -BX -2 $297,699.00 (Semi -Ann) (FHLB) If 01) 12/0722 Step 313381 -DF -9 $346,944.50 (Semi -Ann) (FHLB)(101) 128822 Step 313381 -LR4 $300,426.00 (Semi -Ann) (FHLB) (603) 0113023 Step 313381 -SK -2 $350,000.00 (Semi -Ann) (FHLB) (606) 1 0113023 Step 313381 -06 -5 $800,000.00 1 (Semi -Ann) (FHLB) (601 -50 %; 606 -50 %) 1 03/1323 Step 313382 -CE -1 $1,000,000.00 1 (Semi -Ann) (FHLB) (606) Total Investments $32,751,390.84 Totals $8,505,785.00 Unaudited Ending Balance (Cash & Investments) 8,000,876.19 7,511,425.79 6,973,783.06 Different from Available for Spending Because of: 1) Liabilities Listed Above 2) Other Assets, Liabilites & Changes in Fund Balance ' For April Thru December only do "NOT" take off the liability total again - otherwise the effect is duplicatedlll ' Prior to that, make sure liability total is included in "Month -End Amount Availble" balance " City of Rosemount - General Fund #101 Estimated Cash Flow Chart (As Months am Completed, Actual Figures Replace Estimates) Updated Through 3131113 Beginning Balance (Cash & Investments) 8,065,032.50 8,000,875.19 7,511,425.79 6,973,783.06 6,223,708.06 5,572,883.06 4,865,808.06 8,225,433.06 7,574,608.06 6,867,533.06 6,117,458.06 5,466,633.06 (Current Month is Unaudited Previous WE Balance) (Balance Includes "ALL' Funds - Allocated & Unallocated) 2013 January February March March 2013 Year -To -Date 2012 Year -To -Date April May June July August September October November December Budget (Actual) (Actual) (Estimate) (Actual) (Actual) (Last Year) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) Cash Inflows: 1) Taxes (31010 - 31040) 8,577,300.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,288,650.00 0.00 0.00 0.00 0.00 4,288,650.00 2) Gravel Taxes (31710) 20,000.00 0.00 0.00 20,000.00 19,467.20 19,467.20 16,817.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3) Franchise Taxes (31810 & 31811) 225,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,250.00 0.00 0.00 56,250.00 0.00 0.00 56,250.00 56,250.00 4) Licenses (32110 - 32180 & 32240) 53,500.00 3,911.50 2,065.25 4,458.33 1,381.50 7,358.25 21,998.50 4,458.33 4,458.33 4,458.33 4,458.33 4,458.33 4,458.33 4,458.33 4,458.33 4,458.33 5) Permits (32210 - 32290, Less 32240) 328,800.00 42,854.82 23,563.25 27,400.00 16,589.60 83,007.67 120,557.38 27,400.00 27,400.00 27,400.00 27,400.00 27,400.00 27,400.00 27,400.00 27,400.00 27,400.00 6) Federal Grants & Aids (33100) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7) Stale & Other Aids (33401 - 33630) 300,100.00 63,493.06 16,395.00 0.00 20,300.00 100,188.06 47,495.97 0.00 0.00 0.00 150,050.00 0.00 0.00 0.00 0.00 150,050.00 8) Charges for Services (34102 - 34407) 663,000.00 90,008.87 89,195.17 53,166.67 83,453.64 262,657.68 259,066.84 53,166.67 53,166.67 53,166.67 53,166.67 53,166.67 53,166.67 53,166.67 53,166.67 53,166.67 9) Park Revenues (34718 - 34790) 140,600.00 1,174.35 1,260.40 11,716.67 30,721.70 33,156.45 42,616.95 11,716.67 11,716.67 11,716.67 11,716.67 11,716.67 11,716.67 11,716.67 11,716.67 11,716.67 10) Court Fines (35101) 125,000.00 0.00 11,389.71 10,416.67 10,335.01 21,724.72 23,636.75 10,416.67 10,416.67 10,416.67 10,416.67 10,416.67 10,416.67 10,416.67 10,416.67 10,416.67 11) Interest Earnings (36210 & 36215) 145,500.00 24,564.79 5,019.80 12,125.00 33.47 29,618.06 31,691.25 12,125.00 12,125.00 12,125.00 12,125.00 12,125.00 12,125.00 12,125.00 12,125.00 12,125.00 12) Other ( 36101,220,30,60,65, 38090 & 39101) 23,700.00 2,964.61 5,663.62 1,975.00 3,007.68 11,635.91 19,939.70 1,975.00 1,975.00 1,975.00 1,975.00 1,975.00 1,975.00 1,975.00 1,975.00 1,975.00 13) Comm Center Revenues (38080 - 38154) 101,300.00 4,241.68 5,899.34 8,441.67 4,850.00 14,991.02 22,027.45 8,441.67 8,441.67 8,441.67 8,441.67 8,441.67 8,441.67 8,441.67 8,441.67 8,441.67 14) St. Joseph's Revenues (38201- 38215) 21,300.00 505.00 1,160.00 1,775.00 725.00 2,390.00 5,900.00 1,775.00 1,775.00 1,775.00 1,775.00 1,775.00 1,775.00 1,775.00 1,775.00 1,775.00 15) Transfers In (39202 & 39203) 3,500.00 3,500.00 138.35 0.00 0.00 3,638.35 3,500.00 0.00 _______----- 0.00 __________________ 0.00 _______________ ________________ 0.00 0.00 - ___________----- 0.00 _ ------- _ --- __ 0.00 ------- __ - - 0.00 _ -- _ 0.00 - Total Revenues _________-______________ 10,728,600.00 ___ _______________- 237.218.68 ______------ 161,749.89 ___-__ -------------- 151,475.00 ____ ---- 190,864.80 _ ----- ____- ___- 589,833.37 ________------ 615,247.99 ____- 131,475.00 187,725.00 131,475.00 4,570,175.00 187,725.00 131,475.00 131,475.00 187,725.00 4,626,425.00 Cash Outflows: 1) Council (41110) 247,700.00 9,547.47 3,905.60 12,308.33 8,108.62 21,561.69 25,127.90 12,308.33 12,308.33 12,308.33 12,308.33 12,308.33 12,308.33 12,308.33 12,308.33 112,308.33 2) Administration (41320) 484,400.00 34,504.03 30,753.31 40,366.67 29,970.29 95,227.63 109,034.48 40,366.67 40,366.67 40,366.67 40,366.67 40,366.67 40,366.67 40,366.67 40,366.67 40,366.67 3) Elections (41410) 22,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 22,000.00 4) Finance (41520) 435,300.00 30,243.25 32,114.45 36,275.00 49,759.20 112,116.90 87,739.05 38,275.00 36,275.00 36,275.00 36,275.00 36,275.00 36,275.00 36,275.00 36,275.00 36,275.00 5) General Government (41810) 383,200.00 11,237.42 22,514.92 31,933.33 18,588.35 52,340.69 47,588.94 31,933.33 31,933.33 31,933.33 31,933.33 31,933.33 31,933.33 31,933.33 31,933.33 31,933.33 6) Community Development (41910) 896,800.00 57,609.19 66,300.95 74,733.33 65,228.65 189,138.79 194,132.12 74,73133 74,733.33 74,733.33 74,733.33 74,733.33 74,733.33 74,733.33 74,733.33 74,733.33 7) Government Buildings (41940) 540,500.00 21,576.84 35,501.65 37,875.00 30,065.33 87,14182 96,724.64 37,875.00 37,875.00 37,875.00 80,875.00 37,875.00 37,875.00 37,875.00 37,875.00 37,875.00 8) Police (42110) 3,187,800.00 247,860.14 236,876.54 265,650.00 260,626.38 745,363.06 665,529.33 265,650.00 265,650.00 265,650.00 265,650.00 265,650.00 265,650.00 265,650.00 265,650.00 265,650.00 9) Fire (42210) 437,000.00 3,328.27 8,111.45 7,833.33 6,415.94 17,855.66 15,304.82 50,833.33 7,833.33 7,83133 221,833.33 7,833.33 7,833.33 50,833.33 7,833.33 50,833.33 10) Fleet Maintenance (43100) 645,200.00 27,854.58 39,649.69 53,766.67 32,643.03 100,147.30 113,442.97 53,766.67 53,766.67 53,766.67 53,766.67 53,766.67 53,766.67 53,766.67 53,766.67 53,766.67 11) Street Maintenance (43121) 1,272,200.00 37,824.90 86,095.79 106,016.67 112,051.00 235,971.69 208,694.83 106,016.67 106,016.67 106,016.67 106,016.67 106,016.67 106,016.67 106,016.67 106,016.67 106,016.67 12) Park & Rec (45100) 1,322,400.00 68,122.58 87,135.58 110,200.00 99,532.32 254,790.48 245,496.31 110,200.00 110,200.00 110,200.00 110,200.00 110,200.00 110,200.00 110,200.00 110,200.00 110,200.00 13) Parks Maintenance (45202) 739,100.00 27,997.93 37,317.71 61,591.67 36,288.79 101,604.43 116,985.05 61,591.67 61,591.67 61,591.67 61,591.67 61,591.67 61,591.67 61,591.67 61,591.67 61,591.67 14) Transfers (Aetna) & (Debt Service) (49300) 115,000.00 0.00 0.00 0.00 0.00 0.00 0.00 _ - ____ 0.00 ______- _____ 0.00 - __ - - -__ _ 0.00 _________ -_ _ 115,000.00 _ _ _ - 0.00 - 000 0.00 - _ 0.00 _ -- 0 00 Total Expenditures __ - -__ ____ -____--------- 10728,60000 ________- 57770660 ----- . __ 68627764 ______________ ----------- 838,55000 __- ______________ 74927790 2,013,26214 1,925,80044 881,550.00 838550.00 838,550.00 1,210,550.00 838,550.00 838,550.00 881,550.00 838,550.00 1,003,550,00 Liabilities of General Fund Not Available for Spending (Actual Amounts from Previous Month): 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1) Accounts Payable (20200) 2) Permit Surcharges (20810 - 20860) 0.00 (60,860.55) 0.00 (50,826.10) 0.00 (41,000.30) (41,000.30) (41,000.30) (41,000.30) (41,000.30) (41,000.30) (41,000.30) (41,000.30) (41,000.30) (41,000.30) 3) Payroll Liabilities (21701 - 21740) 48,926.48 54,810.18 55,243.56 55,243.56 55,24156 55,243.56 55,243.56 55,243.56 55,243.56 55,243.56 55,243.56 55,243.56 4) Deposits Payable (22000 & 22001) (68,009.90) (69,409.90) (68,909.90) (68,909.90) (68,909.90) (68,909.90) (68,909.90) (68,909.90) (68,909.90) (68,909.90) (68,909.90) (68,909.90) 5) As -Built Survey Deposits (22010) (94,000.00) (106,000.00) (114,000.00) (114,000.00) (114,000.00) (114,000.00) (114,000.00) (114,000.00) (114,000.00) (114,000.00) (114,000.00) (114,000.00) 6) Deferred Revenues (22200) (17,223.54) (17,223.54) (10,375.50) (10,375.50) (10,375.50) (10,375.50) (10,375.50) (10,375.50) (10,375.50) (10,375.50) (10,375.50) (10,375.50) 7) Fire Dept. Deferred Revenues (22220) (1,975.76) (105.76) (105.76) (105.76) (105.76) (105.76) (105.76) (105.76) (105.76) (105.76) (105.76) (105.76) 8) D.A.R.E. Deferred Revenues (22221) (1,920.32) (1,920.32) (1,670.67) (1,670.67) (1,670.67) (1,670.67) (1,670.67) (1,670.67) (1,670.67) (1,670.67) (1,670.67) (1,670.67) 9) Police Deferred Revenues (22222) (7,810.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) (8,865.18) 10)P& R Deferred Revenues (22223) (9,520.42) (10,185.76) (9,353.31) (9,353.31) (9,353.31) (9,353.31) (9,353.31) (9,353.31) (9,353.31) (9,353.31) (9,353.31) (9,353.31) 11) Administration Deferred Revenues (22225) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) 12) Sales Tax Payable (22810) (271.26) (319.02) (1,342.93) (1,342.93) (1,342.93) (1,342.93) (1,342.93) (1,342.93) (1,342.93) (1,342.93) (1,342.93) (1,342.93) 13) FIB Reserved for (24405 - 24496) (691,725.00) (921,031.43) (1,351,002.18) (1,351,002.18) (1,351,002.18) (1,351,002.18) (1,351,002.18) (1,351,002.18) (1,351,002.18) (1,351,002.18) (1,351,002.18) (1,351,002.18) 14) FIB Reserved for Comp Absences (24401) 924,335.06 924,335.06 924,335.06 924,335.06 924,335.06 924,335.06 924,335.06 -___ 924,335.06 ______ -_____ 924,335.06 ------------ _ -__ 924,335.06 _ --- _ ------- __ 924,335.06 924,335.06 Total Liabilities ______------------ (17,661.35) ___- _-- ______ (244,347.73) -____________________ T ------------- (664,653.07) _ ------------- _-------- __- __________---- (664,653.07) _______________ (664,653.07) ___ -_____ _.__ (664,653.07) (664,653.07) - __- ______ (664,653.07) _--- ______ (664,653.07) _- ------- ___ (664,653.07) -------- __------- (664,653.07) ____ -------- ___ (664,653.07) ___- _--------- Month -End Amount Available for Spending 71706,883.23 7,232,000.71 6,288,359.62 - _____ ----- _---- __ ------ _ -___. 6,223,708.06 _- _________- 5,572,883.06 __________ 4,865,808.06 8,225,433.06 7,574,60&06 6,867,533.06 6,117,458.06 5,466,633.06 9,089,508.06 Unaudited Ending Balance (Cash & Investments) 8,000,876.19 7,511,425.79 6,973,783.06 Different from Available for Spending Because of: 1) Liabilities Listed Above 2) Other Assets, Liabilites & Changes in Fund Balance ' For April Thru December only do "NOT" take off the liability total again - otherwise the effect is duplicatedlll ' Prior to that, make sure liability total is included in "Month -End Amount Availble" balance " Donation and Assignment Balances 3/3112013 Account # ---------- - - - - -- ------------------------------------------------------------------------------- Description - - - - -- Balance --------------- - -- 101 -22220 Deferred Revenue - Fire Department 105.76 101 -22221 Deferred Revenue - D.A.R.E. Program 1,670.67 101 -22222 Deferred Revenue - Police Department 8,865.18 101 -22223 Deferred Revenue - Park & Rec Department 9,353.31 101 -22225 Deferred Revenue - Administration 37,605.96 101 -24404 F/B Assigned for Armory Debt 430,000.00 101 -24405 F/B Assigned for Health Insurance 225,000.00 101 -24406 F/B Assigned for Cable TV / Franchise Renewal Costs 9,277.18 101 -24419 F/B Assigned for Additional Police Dept. Training 8,000.00 101 -24420 F/B Assigned for SKB Landscape Program 56,100.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 Reserves 3.31 101 -24429 F/B Assigned for Government Bldg Repair & Maintenance 144,571.67 101 -24430 F/B Assigned for Parks Maint Repair & Maintenance 139,400.00 101 -24450 F/B Assigned for Community Survey 20,000.00 101 -24451 F/B Assigned for Fuel Reserves 32,711.66 101 -24452 F/B Assigned for Street Chemicals and /or Storage Facility 48,000.00 101 -24454 F/B Assigned for Future Parking Lot Maintenance Costs 25,000.00 101 -24455 F/B Assigned for Siren Repairs /Replacements 10,467.07 101 -24456 F/B Assigned for Future LED Light Upgrades or Add'I Lights 18,000.00 101 -24458 F/B Assigned for Election Equipment 131,732.75 101 -24459 F/B Assigned for P.W. Parking Lot 12,338.54 101 -24460 F/B Assigned for Non - Recurring Athletic Field Costs 15,000.00 202 -24428 F/B Assigned for Council Chamber Audio Visual Equipment 100,000.00 202 -24429 F/B Assigned for Central Park Paver Replacements 5,000.00 202 -24430 F/B Assigned for Steeple Center Exterior Signs 15,000.00 202 -24431 F/B Assigned for Community Center Reader Board Sign 23,000.00 202 -24432 F/B Assigned for Community Center Improvements 0.00 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 6,956.75 203 -24430 F/B Assigned for AUAR 20,959.00 203 -24431 F/B Assigned for 42/52 Costs 180,000.00 203 -24432 F/B Assigned for Akron Avenue Corridor Study 50,000.00 203 -24433 F/B Assigned for Pedestrian Improvements 122,030.88 207 -24455 F/B Assigned for Siren Replacements 2,000.00 207 -24480 F/B Assigned for P.C. Hardware 5,828.76 207 -24481 F/B Assigned for Fire Dept. Technology Updates 15,557.81 207 -24482 F/B Assigned for Security Equipment at City Hall 1,405.00 207 -24485 F/B Assigned for Police Tactical Gear Replacements 6,500.00 207 -24487 F/B Assigned for Police Squad 1,548.66 207 -24488 F/B Assigned for City Accounting Software 13,720.05 207 -24489 F/B Assigned for City -Wide Software 256,000.00 207 -24493 F/B Assigned for Police Photo Imaging Software 4.09 207 -24496 F/B Assigned for Future Equipment Purchases 165,889.53 Projected for 12/31/13 (Does Not Include Future Interest Earnings) City of Rosemount Building CIP Fund - #202 Monthly Review - Audit of CIP Coding Amounts For Month Ending 3131113 2013 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 15 of 20 P.W. Building Addition (Principal) 17,050 521 0.00 17,050.00 Public Works Community Center Restroom Improvements 45,000 527 9,092.78 35,907.22 Parks & Recreation Erickson Park Shelter 100,000 528 500.00 99,500.00 Parks & Recreation Senior Housing / Center Expenses 1,400,000 529 7,917.20 1,392,082.80 General Government Splash Pad 300,000 530 0.00 300,000.00 General Government Green Fields (Flint Hills) 800,000 531 0.00 800,000.00 General Government Steeple Center Sound & Light Improvements 100,000 534 1,172.12 98,827.88 General Government HVAC at Steeple Center 100,000 535 0.00 100,000.00 General Government Senior Exercise Equipment 50,000 536 0.00 50,000.00 General Government Neighborhood Amenities 50,000 537 0.00 50,000.00 Parks & Recreation Transfers 0 710 0.00 0.00 General Government Year 15 of 20 P.W. Building Addition (Interest) 6,950 611 0.00 6,950.00 Public Works ------------- - - - - -- ------------ --- - - - - -- 2,971,500 21,182.10 --------------- - - - --- 2,950,317.90 Sum of Positive Balances --------------- - - - - -- Only Included Total Levy for 2013 24,000 COH 3/31/13 2,842,739.80 F/B Assigned for Council Chamber Equip. --------------------- 100,000.00 F/B Assigned for Central Park Pavers 5,000.00 F/B Assigned for Steeple Center Signs 15,000.00 F/B Assigned for C/C Reader Board Sign 23,000.00 F/B Assigned for C/C Improvements 0.00 F/B Assigned for C/C Fire Alarm System 40,000.00 F/B Assigned for Library/St. Joe's 6,956.75 Reserves Available 4/1/13 --------------- - - - - -- (297,534.85) 1st Half 2013 Levy to Receive 7/13 12,000.00 (Reed $xx,000 7/13) 2nd Half 2013 Levy to Receive 12/13 12,000.00 (Reed $xx,000 12/13) SKB User Fees Still to Receive in 2013 600,000.00 (Reed $xx,000.00 YTD) ($600,000 Total Expected) - - - - -- Total Unassigned Reserves --------------- 326,465.15 Projected for 12/31/13 (Does Not Include Future Interest Earnings) City of Rosemount Street CIP Fund - #203 Monthly Review - Audit of CIP Coding Amounts For Month Ending 3/31/13 2013 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,308.31 (1,308.31) Public Works Pavement Management Program 730,000 531/710 0.00 730,000.00 Public Works Pedestrian Improvements Program 125,000 532 0.00 125,000.00 Public Works Brazil Avenue Improvements 0 533 1,057.50 (1,057.50) Public Works Costs for Closed Projects 0 5351720 0.00 0.00 Public Works Total Levy for 2013 857,500 4,865.81 730,000 COH 3/31/13 F/B Assigned for AUAR F/B Assigned for 42/52 Costs F/B Assigned for Akron Ave. Study F/B Assigned for Pedestrian Improvement Reserves Available 4/1/13 1st Half 2013 Levy to Receive 7/13 2nd Half 2013 Levy to Receive 12/13 SKB User Fees Still to Receive in 2013 ($125,000 Total Expected) Total Unassigned Reserves Projected for 12/31/13 (Does Not Include Future Interest Earnings) 855,000.00 * Sum of Positive Balances ------------ - - - - -- Only Included 1,652,612.56 20,959.00 180,000.00 50,000.00 122,030.88 884,622.68 365,000.00 (Reed $xxx,000 7/13) 365,000.00 (Rec'd $xxx,000 12/13) 125,000.00 (Rec'd $xx,000.00 YTD) 1,739,622.68 City of Rosemount Equipment CIP Fund - #207 Monthly Review - Audit of CIP Coding Amounts For Month Ending 3/31/13 2013 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 2 Squads (Sell Back 2) 47,000 550 0.00 47,000.00 Police Additional Pickup - Fire Dept. Officers 35,000 551 0.00 35,000.00 Fire Replace P & R Unit #8603 28,000 552 22,310.46 5,689.54 Public Works Replace Water Truck 110,000 553 0.00 110,000.00 Public Works Dump Truck (Replace #8434) 130,000 554 0.00 130,000.00 Public Works Replace Fire Dept. LDH Hose 8,000 579 0.00 8,000.00 Fire Additional Fire SCBA Compressor 45,000 580 0.00 45,000.00 Fire New Tables for Banquet Room 20,000 581 15,858.54 4,141.46 Park & Rec New Chairs for Banquet Room 29,000 582 12,946.50 16,053.50 Park & Rec Squad Set Up & Installation 15,000 583 0.00 15,000.00 Police Replace Video Equipment in Squads 20,000 584 0.00 20,000.00 Police P.W. Aerator Attachment 15,000 585 0.00 15,000.00 Public Works City -Wide Software 50,000 588 0.00 50,000.00 General Government DCC Capital Costs (Year 7 of 7) 60,638 601 5,437.50 --- --------- - - - --- 55,200.50 Police -------- ------ - - - - -- --------------- 615,138 59,053.00 - - --- 556,085.00 Sum of Positive Balances -------------- - - - - -- Only Included Total Levy for 2013 460,000 COH3/31/13 1,497,518.80 -------------------- F/B Assigned for Siren Replacements 2,000.00 F/B Assigned for P.C. Hardware 5,828.76 F/B Assigned for Fire Dept. Technology 15,557.81 F/B Assigned for C/H Security Equip. 1,405.00 F/B Assigned for Police Tactical Gear 6,500.00 F/B Assigned for Police Squad 1,548.66 F/B Assigned for City's Financial Software 13,720.05 F/B Assigned for City-Wide Software 256,000.00 F/B Assigned for Police Photo Imaging SW 4.09 F/B Assigned for Future Equip Purchases 165,889.53 --------------- Reserves Available 4/1/13 - - - -- 472,979.90 1st Half 2013 Levy to Receive 7/13 230,000.00 (Rec'd $)xx,000.00 7/13) 2nd Half 2013 Levy to Receive 12/13 230,000.00 (Rec'd $)xx,000.00 12/13) Sale of Old Squad Cars 6,000.00 (Rec'd $x,000.00) --------------- Total Unassigned Reserves -- - -- 938,979.90 Projected for 12/31/13 (Does Not Include Future Interest Earnings) City of Rosemount Water Fund - #601 Income Statement For Month Ending 3/31113 Budget Figures Y -T -D January February March April May June July August September October November December Revenues: - Other State Grants & Aids (33425) *Actual* 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Fee -Other Funds (34108) *Actual* 0.00 2,497.40 2,497.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Gen'I Govt Chgs for Services (34109) *Actual* 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Principal - Special Assessments (36101) 'Actual' 50,000.00 97.88 0.00 97.88 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Penalties - Special Assessments (36102) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Interest - Investments (36210) 'Actual' 60,000.00 10,910.43 1,382.50 2,519.61 7,00832 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Interest Revenues (36215) 'Actual' 1,000.00 14.56 0.00 5.67 8.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Rents & Royalties (36220) 'Actual' (Antenna Leases) 80,000.00 88,051.79 77,103.60 10,948.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Contributions (36230) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Revenues (36260) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Use of Reserve Funds (36265) 'Budget Number' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Residential Water (37110) *Billed* 1,050,000.00 69,636.99 86,362.36 (49,479.17) 32,753.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Apartment Water (37120) *Billed* 73,000.00 18,019.70 49.45 0.00 17,970.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Institutional Water (37125) 'Billed' 70,000.00 5,588.08 0.00 0.00 5,588.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commercial Water (37130) *Billed* 65,000.00 11,523.19 95.55 25.00 11,402.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Industrial Water (37140) 'Billed' 70,000.00 25,037.62 0.00 0.00 25,037.62 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Penalties- Water(37160) *Billed* 8,000.00 4,847.66 2,021.52 1,514.74 1,311.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Water Revenues (37170) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Meter Sales (37180) 'Actual' 30,000.00 8,401.00 4,059.00 2,540.00 1,802.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sale of General Fixed Assets (39101) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Revenues --------- ----- ------------------- 1,557,000.00 244,626.30 ------- ------- 173,571.38 -- ----- - -- (31,828.08) - ---- - ----- ------- 102,883.00 -- ------ --------------- 0.00 -- -------- 0.00 ------- --------- 0.00 ------ ------ 0.00 - - ----- 0.00 ------------ 0.00 - ------ ------ 0.00 ----------------- 0.00 --------------- 0.00 Less: Operating Expenses (All Actual) General Operating (49400-01) 630,700.00 53,79183 21,049.47 12,743.35 20,000.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Personnel (49400 -77) 107,300.00 23,578.66 7,255.15 8,161.76 8,161.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Technical /Clerical Personnel (49400 -78) 145,700.00 31,255.52 9,814.85 10,723.15 10,717.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance Personnel (49400 -79) 165,800.00 40,798.53 11,148.26 14,758.36 14,891.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Part-Time Personnel (49400 -99) 8,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 East Side Watennain Vault (49406 -01) 3,000.00 234.96 0.00 118.28 116.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well #7 (49407-01) 29,100.00 4,754.93 1,359.98 1,027.85 2,367.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well #8 (49408 -01) 25,900.00 2,723.17 0.00 2,400.00 323.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well #9 (49409 -01) 57,300.00 2,799.49 2,212.69 131.07 455.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Rural Water System (49410-01) 21,600.00 2,848.96 1,308.18 196.09 1,344.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Rural Water System #2 (49411 -01) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well #12 (49412-01) 31,300.00 2,556.04 1,304.79 0.00 1,251.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well #14 (49414 -01) 57,300.00 2,045.86 0.00 897.47 1,148.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well #15 (49425 -01) 33,800.00 4,339.50 0.00 3,058.42 1,281.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Tower #1 (49415 -01) 1,200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Tower #2 (49416 -01) 2,600.00 222.40 0.00 104.84 117.56 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Tower #4 (49417-01) 3,500.00 1,217.35 0.00 597.69 619.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 East Side Water Tower #3 (49418-01) 6,200.00 1,084.49 0.00 0.00 1,084.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Operating Expenses ---- --' - - - -- ------ 1,330,300.00 - - - - -- 174,252.69 ----- -- - - - - -- - 55,453.37 ------ -- --- - -- -- 54,918.33 -- - --- - 63,880.99 ------ - ----- ---- 0.00 ---- -- 0.00 -- -- ---- ------------- 0.00 -- 0.00 - -- ---- ---- 0.00 ----- --- - -- 0.00 - --- - -- 0.00 ------ --- - - -- -- 0.00 -- --- -- --- - -- 0.00 Netlncome(Loss) -- -- - - -- --- 226,700.00 -- -- ------- - ----------- ----------- --- - ----- 70,373.61 ---------- --- --- -- 118,118.01 - --------- ---------- - - -- (86,746.41) ---------- ---------- -- --- ------- -------- 39,002.01 ===== ----- --- ------ - - -- ----- ---- --- -- 0.00 ------ ---------- - - - -- - -- ---- ---- 0.00 --- --- - - - - -- ---- ---- -------- - 0.00 - - - - -- ---------- - -- - -- ---- ----------- ---- --- 0.00 == - - - - -- ---- - -- 0.00 -------- - -- - -- ---- - -- ---- 0.00 ---------- - --- - - -- -- ---- --- --- 0.00 ---- = - =--- ---- - -- - -- - - - ----- 0.00 ---- =----- ---- - - - - -- - ----- ------ 0.00 --- - ------ --- - - -- - -- City of Rosemount Sewer Fund - #602 Income Statement For Month Ending 3/31113 Budget Figures -- -- ---------------- Y -T -D - -- ---------------- January - --- -------------- February -- ---------------- --- March -------- ----- -------- April -- - - ---- ----------- May ------ June --- ----- -- ------------------ July ---- August - ------ --- September --- ----------- -- October -- °------ ------ November --- --------------- December --- -------- °----' Revenues: Other State Grants & Aids (33425) *Actual* 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Fee -Other Funds (34108) 'Actual' 0.00 2,497.40 2,497.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Gen'I Govt Chgs for Services (34109) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Principal - Special Assessments (36101) 'Actual' 75,000.00 125.83 0.00 125.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Penalties - Special Assessments (36102) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Interest - Investments (36210) 'Actual' 50,000.00 3,562.17 0.00 2,172.63 1,389.54 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Interest Revenues (36215) *Actual* 500.00 17.02 0.00 8.58 8.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Contributions (36230) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Revenue (36260) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Use of Reserve Funds (36265) 'Budget Number' 267,700.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Residential Sewer (37210)'Billed' 1,150,000.00 120,689.96 136,458.79 (67,639.35) 51,870.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Apartment Sewer (37220) 'Billed' 100,000.00 26,932.20 9532 0.00 26,836.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Institutional Sewer (37225) 'Billed' 21,000.00 5,448.22 0.00 0.00 5,448.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Commercial Sewer (37230) 'Billed' 61,000.00 15,563.67 76.13 0.00 15,487.54 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Industrial Sewer (37240) 'Billed' 47,000.00 19,117.45 0.00 0.00 19,117.45 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Penalties - Sewer (37260) 'Billed' 10,000.00 5,954.87 1,748.72 2,273.90 1,932.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Sewer Revenues (37270) *Actual* 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Transfer From_ (39203) 'Actual' 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 - -- 0.00 - 0.00 --- ----- - -- -- -- 0.00 - ---- --- - - - --- Total Revenues ------------------ - 1,782,200.00 - ---------- ----- 199,908.79 ------ --- -- -- -- 140,876.76 ----- - --- - -- -------- (63,058.41) 122,090.44 ---- 0.00 - - -- --- -- 0.00 -- --- - - ---- --- 0.00 ---- - -- - --- --------- 0.00 -- ---- 0.00 ---- --------- 0.00 -- 0.00 0.00 0.00 Less: Operating Expenses (All Actual) General Operating (49450-01) 1,315,600.00 279,783.47 105,585.28 85,541.12 88,657.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Personnel (49450 -77) 107,300.00 23,578.34 7,255.14 8,161.60 8,161.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Technical /Clerical Personnel (49450 -78) 145,700.00 31,255.49 9,814.84 10,723.15 10,717.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance Personnel (49450 -79) 165,300.00 40,798.28 11,148.26 14,758.20 14,891.82 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Part-Time Personnel (49450 -99) 9,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #1 (49451 -01) 2,900.00 809.50 76.49 0.00 733.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #7 (49452 -01) 2,100.00 112.43 0.00 56.03 56.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #3 (49453 -01) 4,900.00 631.00 0.00 324.30 306.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #4 (49454 -01) 7,400.00 469.19 0.00 254.20 214.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #5 (49455 -01) 7,400.00 964.01 0.00 491.07 472.94 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #6 (49456 -01) 8,900.00 226.96 0.00 116.06 110.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #9 (49457 -01) 2,300.00 261.15 0.00 138.24 122.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #8 (49458 -01) 1,900.00 111.59 57.51 0.00 54.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station #10 (49460 -01) 1,500.00 58.62 0.00 30.94 27.68 0.00 0.00 0.00 0.00 0.00 ------ - -- 0.00 --- --- ------ 0.00 ----- - -- - --- 0.00 ------ -- - -- -- 0.00 ----- --- - ----- Total Operating Expenses -- --- ---- -- - -- 1,782,200.00 -- --- ----- ------- 379,060.03 -- - - - - -- 133,937.52 - -- - -- -- --- 120,594.91 - -- - -- ----- 124,527.60 --- ------ -- ----- 0.00 -- - - -- ---- 0.00 --- - ----- - 0.00 -- - --- -- ----- 0.00 0.00 0.00 0.00 0.00 0.00 Net Income (Loss) 0.00 (179,151.24) 6,939.24 (183,653.32) (2,437.16) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Revenues: Other Slate Grants 8 Aids (33425) 'Actual' Administrative Fee -Other Funds (34108) 'Actual' Principal - Special Assessments (36101) 'Actual` Penalties - Special Assessments (36102) `Actual' Interest - Investments (36210) 'Actual' Other Interest Revenues (36215) 'Actual` Contributions (36230) 'Actual' Other Revenues (36260) 'Actual' Use of Reserve Funds (36265) "Budget Number' All Storm Water Bills (37300) `Billed' Penalties - Storm Water (37360) *Billed* Other Storm Water Revenues (37270) 'Actual' Transfer From (39203) *Actual* Total Revenues Less: Operating Expenses (All Actual) General Operating (49500 -01) Administrative Personnel (49500 -77) Technical /Clerical Personnel (49500-78) Maintenance Personnel (49500 -79) Part-Time Personnel (49500-99) Lift Station #1 (Shannon Hills) (49511 -01) Lift Station #2 (Schwarz Pond) (49512 -01) Lift Station #3 (Birger Pond) (49513 -01) Lift Station #4 (Marcotte Pond) (49514 -01) Lift Station #5 (Hawkins Pond) (49515 -01) Lift Station #6 (Glendalough 71h) (49516 -01) Total Operating Expenses Net Income (Loss) City of Rosemount Storm Water Fund - #603 Income Statement For Month Ending 3/31/13 Budget Figures --------- ----- -- ---- Y -T -D -------------------- January ----- ° °--------- -------- February ---- ----- ---- March ------ -------- ----------------° April -- May -------------- -------- June --------- ------------------ July ------------ August ---- -- September ----- -- ------ --- -- October ------------------ November ---- °------------ December ................ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,497.40 2,497.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20,000.00 36.35 0.00 36.35 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30,000.00 6,175.97 3,714.03 18.71 2,443.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 400.00 11.11 0.00 7.37 3.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 860,000.00 154,645.36 43,196.56 23,418.10 88,030.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,600.00 2,944.81 726.98 645.39 1,572.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ----- ---- -- - -- --- 914,000.00 ---------- - - - - -- 166,311.00 - ---- ----- - -- 50,134.97 --- --- - --- -- - 24,125.92 ---- ----- - -- - 92,050.11 -- -- ----- --- --------- 0.00 --- - -- -------- 0.00 -- ------ -------- 0.00 - ------ - -- 0.00 ---- - ----- - 0.00 - --- ----- -- -- -- 0.00 -- --- - - - --- 0.00 - - - - - --- 0.00 --------------- 0.00 450,400.00 105,295.47 96,688.02 1,834.44 6,77101 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,700.00 2,233.04 614.87 809.07 809.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 80,600.00 17,237.71 5,490.06 5,876.20 5,871.45 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 86,400.00 20,399.38 5,574.24 7,379.11 7,446.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00 59.57 30.24 0.00 29.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,000.00 236.26 0.00 117.12 119.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,500.00 56.74 0.00 29.02 27.72 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00 91.28 0.00 47.30 43.98 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 - ----- ------ -- 647,600.00 - - - - -- 145,609.45 - - -- -- 108,397.43 - ---- - -- - -- -- 16,092.26 - - - - -- - 21,119.76 -- --- ------- -- 0.00 ----- -- -- ------ 0.00 - -- --- - ------ 0.00 ---- ---- 0.00 - --- ------ 0.00 ----- -- --- --- --- 0.00 -------- ------ 0.00 -------- ------ 0.00 - --- - -- --- 0.00 ------ -- ---- - - - --- - 266,400.00 -- ------ - - - --- 20,701.55 ---- - - - - --- --------- (58,262.46) - - - - -- ------ 8,033.66 - - - - -- --- 70,930.35 --- --- --- -- ---- 0.00 ----- ---- - - --- ---- 0.00 -- ----- -- -- 0.00 ---- --- - -- - -- ------ 0.00 - - - - -- 0.00 ----- ------ ---- ----- 0.00 - - - --- 0.00 ------- - -- - -- 0.00 --------------- 0.00