Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
8.b.i. February 2014 Interim Financial Report
City of Rosemount Interim Financial Reports For the Month Ending February 28, 2014 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. CITY OF ROSEMOUNT CASH ON HAND REPORT February 28,2014 Fund Cash on Fund Cash on Fund Description # Hand Investments Total Fund Description # Hand Investments Total General Fund 101 (76,743.54) 7,731,492.05 7,654,748.51 "Future Use"Fund(2009) 401 DUI Forfeitures Fund 102 44,759.33 44,759,33 McMenomy Property-Project#405 402 Port Authority Fund 201 68,995.67 100,195.14 169,190.81 "Future Use"Fund(2013) 403 Building CIP Fund 202 246,440.37 2,126,520.54 2,372,960.91 "Future Use"Fund(2013) 404 Street CIP Fund 203 87,682.77 1,814,535.47 1,902,218.24 "Future Use"Fund(2008) 405 "Future Use"Fund(2004) 204 Minea/Kogl-Project#407 406 Park Improvements Fund 205 78,839.83 317,931.14 398,770.97 149th St.W.Improvements-Project#446 407 (2,278.30) (2,278.30) Insurance Fund 206 32,347.61 600,049.63 632,397.24 145th St.Pedestrian Improvements-Project#447 408 (41,939.25) (41,939.25) Equipment CIP Fund 207 68,168.95 1,245,063.74 1,313,232.69 "Future Use"Fund(2009) 409 "Future Use"Fund(2011) 208 "Future Use"Fund(2011) 410 "Future Use"Fund(2012) 411 "Future Use"Fund(2009) 412 "Future Use"Fund(2009) 220 CDA Senior Housing-Project#456 413 (4,754.50) (4,754.50) Fire Safety Education Fund 221 1,267.13 1,267.13 "Future Use"Fund(2006) 414 GIS Fund 222 13,594.21 13,594.21 Business Park 2nd Add'n(Pahl Prop.)-Project#413 415 (17,914.05) (17,914.05) "Future Use"Fund(2002) 230 Glen Rose Addition-Project#397 416 13,752.42 120,116.34 133,868.76 "Future Use"Fund(2002) 231 "Future Use"Fund(2011) 417 "Future Use"Fund(2001) 241 "Future Use"Fund(2006) , 418 TIF Downtown-Brockway 242 17,429.28 650,206.33 667,635.61 "Future Use"Fund(2011) 419 "Future Use"Fund(2004) 243 "Future Use"Fund(2011) 420 "Future Use"Fund(2008) 244 "Future Use"Fund(2013) 421 Debt Sery CIP Bonds-2005A 301 3,658.88 80,060.89 83,719.77 "Future Use"Fund(2009) 422 "Future Use"Fund(2011) 302 "Future Use"Fund(2009) 423 D/S Fire Station Refund-20050(Old 1996A) 303 8,221.96 265,620.39 273,842.35 "Future Use"Fund(2009) 424 "Future Use"Fund(2013) 304 "Future Use"Fund(2013) 425 "Future Use"Fund(2011) 426 "Future Use"Fund(2012) 321 "Future Use"Fund(2009) 427 "Future Use"Fund(2013) 322 "Future Use"Fund(2013) 428 Debt Sery Equipment Certificates-2008A 323 3,305.18 3,305.18 "Future Use"Fund(2011) 429 "Future Use"Fund(2003) 324 "Future Use"Fund(2013) 430 "Future Use"Fund(2003) 325 Connemara Trail Improvements-Project#431 431 (55,782.77) (55,782.77) Debt Sery G.O.Improvements-2006B 326 6,859.96 956,850.55 963,710.51 "Future Use"Fund(2012) 432 Debt Sery G.O.Improvements-2011A 327 8,509.99 1,026,053.63 1,034,563.62 "Future Use"Fund(2011) 433 Debt Sery G.O.Improvements-2012A 328 30,696.25 480,171.26 510,867.51 Prestwick Place 4th Addition-Project#444 434 170.12 170.12 Debt Sery G.O.Improvements-2013A 329 57,879.55 295,680.75 353,560.30 "Future Use"Fund(2013) 435 "Future Use"Fund(2003) 330 "Future Use"Fund(2013) 436 "Future Use"Fund(2003) 331 2012 Pavement Management-Project#437 437 (57,872.27) (57,872.27) "Future Use"Fund(2009) 332 2013 Pavement Management-Project#445 438 104,574.98 104,574.98 "Future Use"Fund(2003) 333 Greystone Addition-Project#439 439 26,081.52 26,081.52 "Future Use"Fund(2003) 334 "Future Use"Fund(2006) 440 "Future Use"Fund(2012) 335 "Future Use"Fund(2013) 441 "Future Use"Fund(2008) 336 "Future Use"Fund(2006) 442 "Future Use"Fund(2008) 337 TH 3 Underpass-Project#443 443 (94,611.24) (94,611.24) "Future Use"Fund(2011) 338 "Future Use"Fund(2013) 444 "Future Use"Fund(2011) 339 "Future Use"Fund(2013) 445 "Future Use"Fund 340 Prestwick-Street 9(Pink) 446 24,504.36 24,504.36 Connemara(East) 447 127,071.57 127,071.57 Prestwick Place 7th Addition-Project#448 448 98,299.30 600,025.48 698,324.78 Debt Sery G.O.Taxable TIF 2008A&TIF 2008B 381 2,707.90 60,015.87 62,723.77 Greystone 2nd Addition-Project#449 449 3,437.10 3,437.10 "Future Use"Fund(2012) 382 "Future Use"Fund(2013) 450 Debt Sery G.O.Public Facilities Refunding-2010B 383 10,175.37 365,636.60 375,811.97 Prestwick Place 9th Addition-Project#451 451 (2,779.50) (2,779.50) "Future Use"Fund(2009) 384 Bacardi Avenue Improvements-Project#452 452 (58,526.30) (58,526.30) "Future Use"Fund(2007) 385 Danbury Way Improvements-Project#453 453 (15,655.30) (15,655.30) Bella Vista 2nd Addition-Project#454 454 (18,571.61) (18,571.61) Water Utility Fund 601 75,036.78 5,071,214.78 5,146,251.56 2014 Pavement Management-Project#455 455 (21,276.25) (21,276.25) Sewer Utility Fund 602 135,200.40 1,920,003.50 2,055,203.90 Storm Water Utility Fund 603 41,148.81 2,972,166.03 3,013,314.84 Capital Investment Fund 604 34,667.81 50,121.77 84,789.58 "Future Use"Fund(2011) 620 Water Core Fund 605 36,924.86 40,147.96 77,072.82 "Future Use"Fund(2008) 621 Sewer Core Fund 606 14,824.91 4,025,219.75 4,040,044.66 "Future Use"Fund(2003) 622 Storm Core Fund 607 46,194.92 1,419,027.07 1,465,221.99 "Future Use"Fund(2004) 623 "Future Use"Fund(2009) 624 "Future Use"Fund(2009) 625 "Future Use"Fund(2013) 610 Well#16-Project#416 626 (15,126.50) (15,126.50) D/S G.O.Revenue Water-2007A 611 8,551.60 180,553.09 189,104.69 "Future Use"Fund(2012) 627 "Future Use"Fund(2011) 612 "Future Use"Fund(2004) 628 "Future Use"Fund(2011) 613 "Future Use"Fund(2003) 629 D/S G.O.Utility Revenue Refunding-2010A 614 9,412.75 160,000.00 169,412.75 "Future Use"Fund(2004) 630 "Future Use"Fund(2005) 615 "Future Use"Fund(2005) 631 "Future Use"Fund(2008) 616 "Future Use"Fund(2006) 632 D/S G.O.Revenue Water-2000A 617 6,861.51 140,532.65 147,394.16 "Future Use"Fund 633 "Future Use"Fund(2008) 618 "Future Use"Fund(2011) 619 Arena Fund 650 28,936.93 200,000.00 228,936.93 Totals 1,143,381.46 35,015,212.40 36,158,573.86 r City of Rosemount Monthly Report of Investment Holdings by Institution As of February 28,2014 (After Fair Market Value Adjustments) Vermillion State Bank Morgan Stanley Multi-Bank Securities(MBS) (Primevest) Date Date Date Due Rate Account ft Amount Due Rate Cusip 0 Amount Due Rate- Cusip 0 Amount 07/26/21 2.00 3134G3YP9 $465,725.00 03/10/14 1.50 05967E-AN-9 $200,000.00 0628/18 1.35 149159-HY-4 $147,495.00 (Semi-Mn) (FHLMC)(101) C/D-Banco Popular De Puerto Rico(601) (Monthly) C/D-Cathay Bank-Los Angeles.CA(101) 032823 2.00 48124JKF4 $240,000.00 0324/14 1.50 856284-Y6-7 $100,000.00 07/30/18 1.65 305862-CY-5 $249,000.00 (Semi-Mn) C/D-JP Morgan Chase,Columbus,OH(202) C/D-State Bank of India,New York(607) (Monthly) C/D-Farmers&Merchants Bank-Milford,NE(101) 10/1227 2.45 05573JKC7 $240,000.00 09/08/14 1.25 02587D-CT-3 $150,000.00 08/30/18 1.75 06424K-AN-0 $200,000.00 (Semi-Ann) CID-BMO Harris Bank,Chicago,IL(101) C/D-American Eap Centurion Bank,Salt Lake City,UT(206) (Monthly) C/D-Bank of Santa Clarita,CA(607) 09/24/14 3.25 17312Q-LV-9 $96,000.00 11/13/18 2.00 20033A-DK-9 $150,000.00 (Monthly) C/D-Citibank,NA-Nevada(606) (Monthly) C/D-Comenity Capital Bank,Sett Lake City,UT(601) Totals $945,725.00 1028/14 3.25 06740K-CK-1 $96,000.00 12/04/18 1.85 57116A-HC-5 $200,000.00 C/D-Barclays Bank of Delaware(601) (Monthly) C/D-Marlin Business Bank,Salt Lake City,UT(101) ---- --- 12/01/14 5.00 085991-5J-2 $96,000.00 C/D-M&I Marshall&Islay Bank-Milwaukee,WI(602) Anchor Bank 01/16/15 4.85 085993-IT-0 $96,000.00 C/D-Capital One,NA.,Virginia(607) 072423 Step 313601-05-1 $479,370.00 Date 01/30/15 4.00 085993-6Z-1 $96,000.00 (Semi-Mn) (FNMA)(101) Due Rate Account# Amount C/D-Goldman Sachs Bank(101) 05/18/15 1.85 17284A-SF-6 $96,000.00 07/14/14 020 95851542516 $1,500,000.00 C/D-CIT Bank-Salt Lake City,UT(601) 08/04/14 0.15 95851543636 $1,000,000.00 06/15/15 1.05 33764J-EZ-4 $245,000.00 09/15/14 020 95851543202 $1,500,000.00 (Monthly) C/D-First Bank of Puerto Rico(207) 07/13/15 1.15 20451P-AP-1 $200,000.00 Totals 54,000,000.00 C/D-Compass Bank,Birmingham,AL(603) 05/31/16 2.15 254670-F4-9 $150,000.00 C/D-Discover Bank of Delaware(606) 07/25/16 1.20 25611L-X7-9 $245,000.00 1st State Bank of Rosemount C/D-Coral Bank,Catano,Puerto Rico(603) 0824/16 1.85 3814264E-2 $150,000.00 Date C/D-Goldman Sachs Bank(607) Due Rate Account# Amount 09/09/16 1.85 36160T-WR-3 $150,000.00 C/D-GE Capital Financial of Utah(602) 01/19/17 1.90 06740K-FX-0 $150,000.00 C/D-Barclays Bank of Delaware(326) 04/27/17 2.00 856284-534 $150,000.00 Totals(MBS) $1,425,865.00 C/D-State Bank of India,New York(601) Totals $0.00 05/31/17 1.80 982999-130-1 $100,000.00 -------- ------ --------- City of Rosemount•General Fund#101 Estimated Cash Flow Chad(As Months are Completed.Actual Figures Replace Estimates) Updated Through 2128114 Beginning Balance(Cash&Investments) 8,515,428.82 8,068,119.89 7,654,748.51 6,979,823.51 5,218,898.51 5,557,223.51 4,839,298.51 8,250,673.51 7,532,748.51 6,871,073.51 6,110,148.51 5,392,223.51 (Current Month is Unaudited Previous M/E Balance) (Balance Includes ALL Funds-Allocated&Unallocated) 2014 2013 2014 January February February Year-To-Date Year-To-Date March April May June July August September October November December Budget (Actual) (Estimate) (Actual) (Actual) (Last Year) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) Cash Inflows: 1)Taxes(31010_31040) 8,700,800.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,350,400.00 0.00 0.00 0.00 0.00 4,350,400.00 2)Gravel Taxes(31710) 43,000.00 0.00 0.00 39,275.39 39,275.39 0.00 43,000.00 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 0.00 56,250.00 0.00 0.00 112,500.00 4)Licenses(32110-32180&32240) 59,500.00 1,628.00 4,958.33 902.50 2,530.50 5,976.75 4,958.33 4,958.33 4,958.33 4,958.33 4,958.33 4,958.33 4,958.33 4,958.33 4,958.33 4,958.33 5)Permits(32210-32290,Less 32240) 378,800.00 28,175.41 31,566.87 32,913.88 61,089.29 66,418.07 31,566.67 31,566.87 31,566.67 31,566.67 31,566.67 31,566.67 31,568.67 31,566.67 31,586.67 31,566.67 8)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)State&Other Aids(33401-33830) 300,800.00 0.00 0.00 16,730.00 16,730.00 79,888.06 0.00 0.00 0.00 0.00 150,400.00 0.00 0.00 0.00 0.00 150,400.00 8)Charges for Services(34102.34407) 848,300.00 111,220.19 88,608.33 164,165.96 275,386.15 179,204.04 68,608.33 68,808.33 68,608.33 68,608.33 68,608.33 68,608.33 68,608.33 68,808.33 68,608.33 68,608.33 9)Park Revenues(34718_34790) 140,000.00 1,418.10 11,666.67 1,273.01 2,691.11 2,434.75 11,666.67 11,666.87 11,868.67 11,686.67 11,666.67 11,666.67 11,668.67 11,666.67 11,866.67 11,666.67 10)Court Fines(35101) 125,000.00 0.00 10,416,67 11,986.52 11,986.52 11,389.71 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 10,416.87 11)Interest Earnings(36210&36215) 85,500.00 18,345.99 7,125.00 837.55 19,183.54 29,584.59 7,125.00 7,125.00 7,125.00 7,125.00 7,125.00 7,125.00 7,125.00 7,125.00 7,125.00 7,125.00 12)Other(36101,220,30,80,65,38090&39101) 74,800.00 3,854.82 8,233.33 8,489.02 12,343.64 8,628.23 6,233.33 6,233.33 6,233.33 8,233.33 6,233.33 6,233.33 6,233.33 6,233.33 6,233,33 6,233.33 13)Comm Center Revenues(38080-38154) 103,300.00 7,583.94 8,608.33 5,456.33 13,040.27 10,141.02 8,808.33 8,608.33 8,608.33 8,608.33 8,608.33 8,608.33 8,608.33 8,608.33 8,608.33 8,608.33 14)Steeple Center Revenues(38201-38215) 9,500.00 717.00 791.67 0.00 717.00 1,665.00 791.67 791.67 791.67 791,67 791.67 791.67 791.67 791.67 791.87 791.67 15)Activity Center Revenues(38301-38315) 800.00 0.00 66.67 0.00 0.00 0.00 66.87 66.67 66.67 66.67 66.67 66.67 66.67 66.67 66.67 688.67 16)Transfers In(39202&39203) 3,500.00 3,500.00 0.00 0.00 3,500.00 3,638.35 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Revenues 11,098,600.00 176,443.25 150,041.67 282,030.16 458,473.41 398,968.57 193,041.67 150,041.67 208,291.67 150,041.67 4,650,841.67 150,041.67 208,291.87 150,041.67 150,041.67 4,763,341.87 Cash Outflows: 1)Council(41110) 162,600.00 1,890.75 5,216.67 11,120.68 13,011.41 13,453.07 5,216.67 5,216.67 5,216.67 5,216.67 5,216.67 5,216.67 5,216.87 5,216.67 5,216.67 105,216.67 2)Administration(41320) 505,600.00 35,437.50 42,133.33 32,226.35 87,663.85 65,257.34 42,133.33 42,133.33 42,133.33 42,133.33 42,133.33 42,133.33 42,133.33 42,133.33 42,133.33 42,133.33 3)Elections(41410) 40,000.00 0.00 0.00 2,225.00 2,225.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 40,000.00 4)Finance(41520) 464,800.00 28,525.46 38,733.33 36,846.16 63,371.62 62,357.70 38,733.33 38,733.33 38,733.33 38,733.33 38,733.33 38,733.33 38,733.33 38,733.33 38,733.33 38,733.33 5)General Government(41810) 374,200.00 12,607.74 31,183.33 12,472.95 25,080.69 33,752.34 31,183.33 31,183.33 31,183.33 31,183.33 31,183.33 31,183.33 31,183.33 31,183.33 31,183.33 31,183.33 6)Community Development(41910) 929,300.00 57,745,49 77,441.67 68,074.32 125,819.81 123,910.14 77,441.67 77,441.67 77,441.67 77,441.67 77,441.87 77,441.87 77,441.67 77,441.67 77,441.67 77,441.87 7)Government Buildings(41940) 504,600.00 15,249.10 77,466.67 33,985.54 49,234.64 57,078.49 34,966.67 34,968.67 34,966.67 34,986.87 77,466.67 34,966.67 34,966.67 34,966.67 34,966.67 34,986.67 8)Police(42110) 3,349,700.00 241,690.90 279,141.67 236,780.57 478,471.47 484,736.68 279,141.67 279,141.67 279,141.67 279,141.67 279,141.67 279,141.67 279,141.67 279,141.67 279,141.67 279,141.67 9)Fire(42210) 437,300.00 7,559.00 7,858.33 1,700.99 9,259.99 11,439.72 7,858.33 50,858.33 7,858.33 7,858.33 221,858.33 7,858.33 7,858.33 50,858.33 7,858.33 50,858.33 10)Fleet Maintenance(43100) 677,000.00 30,085.37 56,416.67 43,439.69 79,525.06 67,504.27 56,416.67 56,416.67 56,416.67 56,416.67 56,416.67 56,416.67 56,416.67 58,416.67 56,416.67 56,416.67 11)Street Maintenance(43121) 1,348,300.00 39,199.93 112,358.33 85,893.91 125,093.84 123,920.69 112,358.33 112,358.33 112,358.33 112,358.33 112,358.33 112,358.33 112,358.33 112,358.33 112,358.33 112,358.33 12)Park&Rec(45100) 1,356,800.00 73,558.04 113,066.67 92,587.69 166,145.73 155,258.16 113,066.67 113,066.67 113,066.67 113,066.67 113,066.67 113,066.67 113,066.67 113,066.67 113,066.67 113,066.67 13)Parks Maintenance(45202) 833,400.00 29,742.45 69,450.00 40,734.38 70,476.83 65,315.64 69,450.00 69,450.00 69,450.00 69,450.00 69,450.00 69,450.00 69,450.00 69,450.00 69,450.00 69,450.00 14)Transfers(Arena)&(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 0.00 0.00 0.00 0.00 Total Expenditures 11,098,600.00 577,291.73 910,466.67 698,088.21 1,275,379.94 1,263,984.24 867,966.67 910,966.67 867,966.67 867,966.67 1,239,466.67 867,966.67 867,966.67 910,966.67 867,966.67 1,050,966.67 Liabilities of General Fund Not Available for Spending(Actual Amounts from Previous Month): 1)Accounts Payable(20200) 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)Permit Surcharges(20810.20880) (49,253,11) (54,752.76) (54,752.76) (54,752.76) (54,752.76) (54,752.76) (54,752.76) (54,752.76) (54,752.76) (54,752.76) (54,752.76) (54,752.76) 3)Payroll Liabilities(21701-21740) 63,948.67 64,315.05 64,315.05 64,315.05 64,315.05 64,315.05 64,315.05 64,315.05 64,315.05 64,315.05 64,315.05 64,315.05 4)Deposits Payable(22000&22001) (82,750.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) (83,050.00) 5)As-Built Survey Deposits(22010) (100,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) (110,000.00) 6)Deferred Revenues(22200) (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) (10,375.50) (10,375.50) 7)Fire Dept.Deferred Revenues(22220) (155.76) (155.76) (155.76) (155.76) (155.76) (155.76) (155.76) (155.76) (155.78) (155.76) (155.76) (155,76) 8)D.A.R.E.Deferred Revenues(22221) (1,710.67) (1,710.67) (1,710.67) (1,710.67) (1,710.67) (1,710.87) (1,710.67) (1,710.67) (1,710.87) (1,710.67) (1,710.67) (1,710.67) 9)Police Deferred Revenues(22222) (10,507.95) (6,870.30) (6,670.30) (6,670.30) (6,670.30) (6,670.30) (6,670.30) (6,670.30) (6,670.30) (6,670.30) (6,670.30) (6,670.30) 10)P&R Deferred Revenues(22223) (12,355.57) (12,138.41) (12,138.41) (12,138.41) (12,138.41) (12,138.41) (12,138.41) (12,138.41) (12,138.41) (12,138.41) (12,138.41) (12,138.41) 11)Administration Deferred Revenues(22225) (37,605.96) (37,605.96) (37005.96) (37005.96) (37,605.96) (37,605.96) (37,605.96) (37,805.96) (37,605.96) (37,605.96) (37,605.96) (37,605.96) 12)Sales Tax Payable(22810) (527.54) (216.15) (216.15) (216.15) (216.15) (216.15) (216.15) (216.15) (216.15) (216.15) (216.15) (216.15) 13)F/B Reserved for(24405-24496) (1,227,884.44) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) (1,273,271.39) 14)F/B Reserved for Comp Absences(24401) 924,335.06 964,037.49 964,037.49 964,037.49 964,037.49 964,037.49 964,037.49 964,037.49 964,037.49 984,037.49 964,037.49 964,037.49 Total Liabilities (544,822.77) (561,594.36) (561,594.36) (581,594.38) (581,594.36) (561,594.36) (561,594.38) (561,594.36) (561,594.36) (561,594.36) (561,594.36) (561,594.36) Month-End Amount Available for Spending 7,569,755.57 7,090,467.48 8,979,823.51 6,218,898.51 5,557,223.51 4,839,298.51 8,250,673.51 7,532,748.51 6,871,073.51 6,110,148.51 5,392,223.51 9,104,598.51 Unaudited Ending Balance(Cash 8 Investments) 8,068,119.89 7,654,748.51 Different from Available for Spending Because of: 1)Liabilities Listed Above 2)Other Assets,Uabilites&Changes in Fund Balance """For March Thru December only do"NOT"take off the liability total again-otherwise the effect is duplicated!!!••• """Prior to that,make sure liability total is included in"Month-End Amount Availble"balance^• Donation and Assignment Balances 2/28/2014 Account# Description Balance 101-22220 Deferred Revenue - Fire Department 155.76 101-22221 Deferred Revenue - D.A.R.E. Program 1,710.67 101-22222 Deferred Revenue - Police Department 6,670.30 101-22223 Deferred Revenue- Park & Rec Department 12,138.41 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 8,054.17 101-24419 F/B Assigned for Additional Police Dept. Training 3,403.81 101-24420 F/B Assigned for SKB Landscape Program 61,700.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 104,086.01 101-24430 F/B Assigned for Parks Maint Repair& Maintenance 70,543.60 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 50,000.00 101-24455 F/B Assigned for Siren Repairs/Replacements 2,297.54 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 30,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 17,305.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 202-24436 F/B Assigned for Erickson Shelter 14,000.00 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 128,244.03 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 2,996.23 207-24486 F/B Assigned for Squad AN Equipment 20,000.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 306,000.00 207-24493 F/B Assigned for Police Photo Imaging Software 4.09 207-24496 F/B Assigned for SCBA Compressor 45,000.00 207-24496 F/B Assigned for Future Equipment Purchases 161,437.37 City of Rosemount Building CIP Fund-#202 Monthly Review-Audit of CIP Coding Amounts For Month Ending 2/28/14 2014 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 16 of 20 P.W.Building Addition(Principal) 18,800 521 0.00 18,800.00 Public Works YMCA/DCTC Facility(Year 1 of 2) 1,300,000 525 0.00 1,300,000.00 General Government Senior Housing/Center Expenses 1,600,000 529 0.00 1,600,000.00 General Government Splash Pad 1,000,000 530 0.00 1,000,000.00 General Government Council Chambers&Conference Room 325,000 532 0.00 325,000.00 General Government Repair Community Center Roof 20,000 533 0.00 20,000.00 Parks&Recreation Landscaping at Steeple Center 60,000 534 0.00 60,000.00 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 Jaycee Park Batting Cage 22,000 538 0.00 22,000.00 Parks&Recreation Shade Canopies for Dugouts 30,000 539 0.00 30,000.00 Parks&Recreation Blinds/Shades at Steeple Center 0 560 0.00 0.00 General Government City Hall Front Reception Area Renovation 0 570 16,333.14 (16,333.14) General Government Transfers 0 710 0.00 0.00 General Government Year 16 of 20 P.W.Building Addition(Interest) 5,200 611 0.00 5,200.00 Public Works 4,583,500 18,833.14 4,581,000.00 Sum of Positive Balances Only Included Total Levy for 2014 24,000 COH 2/28/14 2,372,960.91 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 17,305.00 F/B Assigned for C/C Fire Alarm System 40,000.00 F/B Assigned for Library/St.Joe's 6,956.75 F/B Assigned for Erickson Shelter 14,000.00 Reserves Available 3/1/14 (2,406,300.84) 1st Half 2014 Levy to Receive 7/14 12,000.00 (Rec'd$xx,000 7/14) 2nd Half 2014 Levy to Receive 12/14 12,000.00 (Rec'd$xx,000 12/14) SKB User Fees Still to Receive in 2014 2,100,000.00 (Rec'd$xx,000.00 YTD) ($2,100,000 Total Expected) Total Unassigned Reserves (282,300.84) Projected for 12/31/14 (Does Not Include Future Interest Earnings) City of Rosemount Street CIP Fund-#203 Monthly Review-Audit of CIP Coding Amounts For Month Ending 2/28/14 2014 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 0.00 0.00 Public Works Pavement Management Program 740,000 531/710 0.00 740,000.00 Public Works Pedestrian Improvements Program 125,000 532 0.00 125,000.00 Public Works Costs for Closed Projects 0 535/720 0.00 0.00 Public Works 867,500 2,500.00 865,000.00 * Sum of Positive Balances Only Included Total Levy for 2014 740,000 COH 2/28/14 1,902,218.24 F/B Assigned for AUAR 20,959.00 F/B Assigned for 42/52 Costs 180,000.00 F/B Assigned for Akron Ave.Study 50,000.00 F/B Assigned for Pedestrian Improvement 128,244.03 Reserves Available 3/1/14 658,015.21 1st Half 2014 Levy to Receive 7/14 370,000.00 (Rec'd$)ox,000 7/14) 2nd Half 2014 Levy to Receive 12/14 370,000.00 (Redd$xxx,000 12/14) SKB User Fees Still to Receive in 2014 125,000.00 (Rec'd$xxx,000.00 YTD) ($125,000 Total Expected) Total Unassigned Reserves 1,523,015.21 Projected for 12/31/14 City of Rosemount Equipment CIP Fund-#207 Monthly Review-Audit of CIP Coding Amounts For Month Ending 2/28/14 2014 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 Tractor(Replace#8408) 95,000 540 0.00 95,000.00 Public Works Loader(Replace#8421) 245,000 540 0.00 245,000.00 Public Works 4 Squads(Sell Back 3) 78,000 550 0.00 78,000.00 Police 4x4 Brush Truck Replacement 75,000 551 0.00 75,000.00 Fire RTV Kubota(Replace#8401) 15,000 552 0.00 15,000.00 Public Works Pickup(Replace#8344) 45,000 553 0.00 45,000.00 Public Works Hose Testers 12,000 579 0.00 12,000.00 Fire Briefing Room Technology 4,000 580 3,080.00 920.00 Police Replace 2 Lasers 5,000 581 0.00 5,000.00 Police Squad Set Up&Installation 22,500 583 0.00 22,500.00 Police Replace Laptops&Video Equipment in Squads 121,000 584 0.00 121,000.00 Police Replace 6 P.W.Laptops 6,000 586 3,385.00 2,615.00 Finance PC Printer Replacements 10,000 587 0.00 10,000.00 Finance City-Wide Software 25,000 588 0.00 25,000.00 General Government Server Replacements 45,000 589 0.00 45,000.00 Finance PC Workstation Upgrades(2009) 60,000 590 49,392.00 10,608.00 Finance 866,000 58,357.00 807,643.00 * Sum of Positive Balances Only Included Total Levy for 2014 490,000 COH 2/28/14 1,313,232.69 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 2,996.23 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 306,000.00 F/B Assigned for Police Photo Imaging SW 4.09 F/B Assigned for SCBA Compressor 45,000.00 F/B Assigned for Future Equip Purchases 161,437.37 Reserves Available 3/1/14 (4,908.28) 1st Half 2014 Levy to Receive 7/14 245,000.00 (Rec'd$xxx,000.00 7/14) 2nd Half 2014 Levy to Receive 12/14 245,000.00 (Rec'd$xxx,000.00 12/14) Sale of Old Squad Cars 0.00 (Rec'd$7,863.00) Total Unassigned Reserves 485,091.72 Projected for 12/31/14 (Does Not Include Future Interest Earnings) City of Rosemount Water Fund-#601 Income Statement For Month Ending 2/28/14 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 3,931.16 3,931.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Gent Govt Chgs for Services(34109)*Actual* 0.00 100.00 50.00 50.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 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 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 5,563.29 2,811.09 2,752.20 0.00 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 2.86 0.00 2.86 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Rents&Royalties(36220)•Actual•(Antenna Leases) 90,000.00 92,056.23 92,056.23 0.00 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,200,000.00 38,145.04 84,890.32 (46,745.28) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Apartment Water(37120) *Billed* 75,000.00 95.53 79.43 16.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Institutional Water(37125)*Billed* 75,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 Commercial Water(37130)*Billed* 70,000.00 162.25 127.75 34.50 0.00 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 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 Penalties-Water(37160) *Billed* 8,000.00 3,180.47 1,726.85 1,453.62 0.00 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* 35,000.00 2,776.00 1,041.00 1,735.00 0.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,733,500.00 146,012.83 186,713.83 (40,701.00) 0.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) 797,100.00 30,905.63 21,212.58 9,693.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Personnel(49400-77) 112,900.00 16,276.03 7,768.55 8,507.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Technical/Clerical Personnel(49400-78) 150,300.00 19,690.50 8,444.76 11,245.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance Personnel(49400-79) 172,100.00 27,114.71 10,939.59 16,175.12 0.00 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 Watermain Vault(49406-01) 3,000.00 115.84 0.00 115.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well#7(49407-01) 32,100.00 747.76 17.57 730.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well#8(49408-01) 46,400.00 3,044.46 0.00 3,044.46 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well#9(49409-01) 39,800.00 36.27 0.00 36.27 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Rural Water System(49410-01) 17,300.00 550.64 63.73 486.91 0.00 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) 32,300.00 463.82 0.00 463.82 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well#14(49414-01) 39,800.00 1,932.64 0.00 1,932.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Well#15(49425-01) 31,800.00 707.76 0.00 707.76 0.00 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 114.96 0.00 114.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Tower#4(49417-01) 13,700.00 578.00 0.00 578.00 0.00 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) 4,200.00 179.41 0.00 179.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Operating Expenses 1,504,600.00 102,458.43 48,446.78 54,011.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 • 0.00 0.00 Net Income(Loss) 228,900.00 43,554.40 138,267.05 (94,712.65) 0.00 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 2/28/14 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 3,931.16 3,931.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Gent 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* 80,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 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* 25,000.00 912.73 0.00 912.73 0.00 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 10.67 0.00 10.67 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 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' 323,800.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,200,000.00 62,210.58 138,411.85 (76,201.27) 0.00 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 47.32 47.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Institutional Sewer(37225) 'Billed' 23,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 Commercial Sewer(37230) *Billed* 65,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 Industrial Sewer(37240) 'Billed' 47,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 Penalties-Sewer(37260) *Billed* 10,000.00 4,017.70 1,808.94 2,208.76 0.00 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,874,300.00 71,130.16 144,199.27 (73,069.11) 0.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(49450-01) 1,379,600.00 209,307.35 104,359.48 104,947.87 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Personnel(49450-77) 112,900.00 16,275.81 7,768.40 8,507.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Technical/Clerical Personnel(49450-78) 150,300.00 19,690.52 8,444.77 11,245.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance Personnel(49450-79) 171,600.00 27,114.63 10,939.54 16,175.09 0.00 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 42.30 0.00 42.30 0.00 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 55.41 0.00 55.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station#3(49453-01) 5,400.00 314.84 0.00 314.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station#4(49454-01) 17,200.00 223.60 0.00 223.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station#5(49455-01) 8,400.00 462.38 0.00 462.38 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station#6(49456-01) 9,200.00 142.12 0.00 142.12 0.00 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 104.02 0.00 104.02 0.00 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 32.94 0.00 32.94 0.00 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 32.89 0.00 32.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Operating Expenses 1,874,300.00 273,798.81 131,512.19 142,286.62 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Net Income(Loss) 0.00 (202,668.65) 12,687.08 (215,355.73) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A City of Rosemount Storm Water Fund-#603 Income Statement For Month Ending 2/28/14 Budget Figures Y-T-D January February March April May June July August September October November December Revenues: Other State Grants 8 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 3,931.16 3,931.16 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' 20,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 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* 20,000.00 7,177.97 4,002.63 3,175.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Interest Revenues(36215) `Actual* 300.00 1.18 0.00 1.18 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 All Storm Water Bills(37300) *Billed* 900,000.00 69,422.57 44,742.10 24,680.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Penalties-Storm Water(37360) *Billed" 4,700.00 1,459.82 851.83 607.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Other Storm Water 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 945,000.00 81,992.70 53,527.72 28,464.98 0.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(49500-01) 444,400.00 100,235.08 95,979.39 4,255.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Personnel(49500-77) 11,000.00 1,430.90 608.56 822.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Technical/Clerical Personnel(49500-78) 82,800.00 10,809.24 4,598.14 6,211.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance Personnel(49500-79) 89,600.00 13,557.09 5,469.73 8,087.36 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Part-Time Personnel(49500-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 Lift Station#1(Shannon Hills)(49511-01) 1,000.00 17.29 0.00 17.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station#2(Schwarz Pond)(49512-01) 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 Lift Station#3(Birger Pond)(49513-01) 5,000.00 99.86 0.00 99.86 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station#4(Marcotte Pond)(49514-01) 5,500.00 35.53 0.00 35.53 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lift Station#5(Hawkins Pond)(49515-01) 11,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#6(Glendalough 7th)(49516-01) 1,000.00 46.07 0.00 46.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Operating Expenses 660,300.00 126,231.06 106,655.82 19,575.24 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Net Income(Loss) 284,700.00 (44,238.36) (53,128.10) 8,889.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 • 4