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 Interim Financial Report
City of Rosemount Interim Financial Reports For the Month Ending February 28, 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. 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) Arena Fund 610 3,121.82 3,121.82 611 980.44 190,464.48 191,444.92 612 613 614 220.79 170,000.00 170,220.79 615 616 617 5,816.36 140,462.84 146,279.20 618 619 650 61,336.06 200,000.00 261,336.06 CITY OF ROSEMOUNT CASH ON HAND REPORT Febm" 28, 2013 Fund Description "Future Use" Fund (2009) McMenomy Properly - Project #405 Rosemount Pedestrian 8 Bicycle Plan Park 8 Ride Project "Future Use" Fund (2008) Mkwa/Kogl -Project #407 "Future Use" Fund (2008) "Future Use" Fund (2007) '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 Addi0onr -Project #436 Prestwick Place 2nd Addition - Project #425 2012 Pavement Management -Project #437 2013 Pavement Management -Project #445 Grayslone 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 "Future Use" Fund (2006) "Future Use" Fund (2007) "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.24 404 (8,783.68) 405 406 407 408 409 410 411 412 413 414 415 (17,914.05) 416 33,744.77 417 418 419 420 421 422 423 424 425 426 427 428 (24,760.11) 429 430 (194,411.45) 431 (204,514.56) 432 433 434 119,595.03 435 273,751.53 436 437 (41,108.44) 438 (27,339.43) 439 151,331.21 440 441 (308,270.76) 442 443 (63,318.50) 444 17,578.84 445 71,348.91 446 35,157.52 447 69,280.76 448 (586.60) 449 450 451 452 453 454 455 620 621 622 623 624 625 626 627 628 629 630 631 632 633 Investments Total 292.24 (8,783.68) (17,914.05) 100,057.95 133,802.72 (24,760.11) (194,411.45) (204,514.56) 119,595.03 273,751.53 (41,108.44) (27,339.43) 151,331.21 (308,270.76) (63,318.50) 17,578.84 71,348.91 35,157.52 69,280.76 (586.60) Totals 1,925,000.45 32,559,335.64 34,484,336.09 Fund Cash on Fund Description # Hand Investments Total General Fund 101 (232,359.55) 7,743,785.34 7,511,425.79 DUI Forfeitures Fund 102 37,543.47 37,643.47 Port Authority Fund 201 64,525.89 100,145.15 184,671.04 Building CIP Fund 202 (265,053.60) 3,192,293.96 2,937,240.36 Street CIP Fund 203 402,338.35 1,251,517.89 1,653,856.24 "Future Use" Fund (2004) 204 Park Improvements Fund 205 72,672.85 432,739.47 505,412.32 Insurance Fund 206 28,529.77 647,948.70 676,478.47 Equipment CIP Fund 207 52,043.67 1,417,934.08 1,469,977.75 "Future Use" Fund (2011) 208 "Future Use" Fund (2009) 220 Fire Safety Education Fund 221 868.03 868.03 GIS Fund 222 7,828.58 7,828.58 "Future Use" Fund (2002) 230 "Future Use" Fund (2002) 231 "Future Use" Fund (2001) 241 TIF Downtown - Brockway 242 3,031.51 550,087.46 553,116.97 "Future Use" Fund (2004) 243 "Future Use" Fund (2008) 244 Debt Sery CIP Bonds - 2005A 301 3,882.36 70,018.32 73,900.68 "Future Use" Fund (2011) 302 D/S Fire Station Refund - 2005D (Old 1996A) 303 1,888.89 405,561.30 407,450.19 Debt Sery Comm Center Refunding - 2001E 304 2,922.30 2,922.30 "Future Use" Fund (2012) 321 Debt Serv, Equipment Certificates - 20078 322 (308.46) (308.46) Debt Sery Equipment Certificates - 2008A 323 3,433.14 85,608.26 89,041.40 "Future Use" Fund (2003) 324 "Future Use" Fund (2003) 325 Debt Sery G.O. Improvements - 2006B 326 5,716.73 966,437.53 972,154.26 Debt Sery G.O. Improvements - 2011A 327 95,248.66 935,474.19 1,030,722.85 Debt Sery G.O. Improvements - 2012A 328 73,459.38 30,005.08 103,464.46 "Future Use" Fund (2003) 329 "Future Use" Fund (2003) 330 "Future Use" Fund (2003) 331 "Future Use" Fund (2009) 332 "Future Use" Fund (2003) 333 "Future Use" Fund (2003) 334 "Future Use" Fund (2012) 335 "Future Use" Fund (2008) 336 "Future Use" Fund (2008) 337 "Future Use" Fund (2011) 338 "Future Use" Fund (2011) 339 "Future Use" Fund 340 Debt Sery G.O. Taxable TIF 200aA 8 TIF 20088 381 4,618.91 40,000.00 44,618.91 "Future Use" Fund (2012) 382 Debt Sery G.O. Public Facilities Refunding -2010B 383 2,416.81 365,538.88 367,955.69 "Future Use" Fund (2009) 384 "Future Use" Fund (2007) 385 Water Utility Fund 601 378,276.22 4,264,827.95 4,643,104.17 Sewer Utility Fund 602 359,160.82 1,687,007.97 2,046,168.79 Storm Water Utility Fund 603 158,968.29 2,267,548.49 2,426,516.78 Capital Investment Fund 604 33,777.03 50,038.00 83,815.03 Water Core Fund 605 24,610.38 40,069.71 64,680.09 Sewer Core Fund 606 561,706.92 3,449,585.54 4,011,292.46 Storm Core Fund 607 80,704.40 1,764,177.10 1,844,881.50 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) Arena Fund 610 3,121.82 3,121.82 611 980.44 190,464.48 191,444.92 612 613 614 220.79 170,000.00 170,220.79 615 616 617 5,816.36 140,462.84 146,279.20 618 619 650 61,336.06 200,000.00 261,336.06 CITY OF ROSEMOUNT CASH ON HAND REPORT Febm" 28, 2013 Fund Description "Future Use" Fund (2009) McMenomy Properly - Project #405 Rosemount Pedestrian 8 Bicycle Plan Park 8 Ride Project "Future Use" Fund (2008) Mkwa/Kogl -Project #407 "Future Use" Fund (2008) "Future Use" Fund (2007) '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 Addi0onr -Project #436 Prestwick Place 2nd Addition - Project #425 2012 Pavement Management -Project #437 2013 Pavement Management -Project #445 Grayslone 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 "Future Use" Fund (2006) "Future Use" Fund (2007) "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.24 404 (8,783.68) 405 406 407 408 409 410 411 412 413 414 415 (17,914.05) 416 33,744.77 417 418 419 420 421 422 423 424 425 426 427 428 (24,760.11) 429 430 (194,411.45) 431 (204,514.56) 432 433 434 119,595.03 435 273,751.53 436 437 (41,108.44) 438 (27,339.43) 439 151,331.21 440 441 (308,270.76) 442 443 (63,318.50) 444 17,578.84 445 71,348.91 446 35,157.52 447 69,280.76 448 (586.60) 449 450 451 452 453 454 455 620 621 622 623 624 625 626 627 628 629 630 631 632 633 Investments Total 292.24 (8,783.68) (17,914.05) 100,057.95 133,802.72 (24,760.11) (194,411.45) (204,514.56) 119,595.03 273,751.53 (41,108.44) (27,339.43) 151,331.21 (308,270.76) (63,318.50) 17,578.84 71,348.91 35,157.52 69,280.76 (586.60) Totals 1,925,000.45 32,559,335.64 34,484,336.09 I C/D - Barclays Bank of Delaware (326) I Totals $0.00 I 0427117 2.00 856284 -E34 $150,000.00 I City of Rosemount CID - State Bank of India, New York (601) I I 05131/17 1.80 982999 -80.1 $100,000.00 I US Bank I (Monthly) C/D - Comenity Bank (formerly WFNB), Wilmington, DE (601) I I 0726117 Monody Report of Investment Holdings by Institution CID - Discover Bank of Delaware (607) Due Rate Account 0 Amour I 10/03117 1.50 795450PN9 $245,000.00 I - I CID - Sage MeeBank, Many UT (101) I I 02/2422 Step 94986T.N-0 $245,000.00 I As of February 28, 2013 CID - Wells Fargo Bank of SD (20640%; 606.20 %; 60740%) I I 1 0611220 Step 3134G3 -VX -5 (After Fair Value Market Adjustments) Vermillion State Bank I Morgan Stanley I Morgan Stanley (Continued) (Primevest) I I Date I Date I Date Due Rate Account $ Amount I Due Rate C-ip 6 Amount I Due Rate Cuslp A Amount 07/2621 - 2.00 3134G3YP9 I $502,755.00 I 06110113 3.40 17284A-FP-8 I $150,000.00 I 09106/19 Step 3134G3 -OB-9 $701,295.00 (Semi -Ann) (FHLMC) (101) I CID - CIT Bank - Salt Lake City, UT (601) ( (Semi -Ann) (FHLMC) (202 -50 %; 606 -50 %) 032823 2.00 48124JKF4 $240,000.00 I 06/10/13 3.40 140653 -3A -2 $150,000.00 I 0113020 Step 3136GIAVI $400,000.00 (Semi-Ann) CID - JP Morgan Chase, Columbus, OH (202) I CID - Capmark Bank of Utah (602) I (Semi -Am) (FNMA) (101) 10/1227 2.45 05573JKC7 $240,000.00 I 08/06/13 5.00 361607 -CE -4 $96,000.00 I 052522 Step 313379 -HQ -5 $705,019.00 (Semi -Ann) C/D - BMO Harris Bank, Chicago, IL (101) I C/D - GE Capital Financial of Utah (101 -50 %; 206 -50 %) I (SemFMn) (FHLB) (606) I 0820/13 1.55 36159C -SW -7 $150,000.00 I 1110922 Step 31338G.ZG -5 $296,826.00 C/D - Cole GE Money Bank, Salt Lake City, UT (606) I (Semi -Ann) (FHLB) (101 -50 %; 607 -50 %) Totals $982,755.00 I 0820/13 1.60 02004M -HS-3 $200,000.00 I 12/1922 Step 313381 -E9-2 $997,720.00 I CID - Ally Bank (Formerly GMAC Bank), Utah (607) I (Semi -Ann) (FHLB) (10130%; 606 -50%) I 09/16/13 5.10 083997 -70-8 $96,000.00 I 022723 Step 31338230.6 3300,000.00 I C/D - Stockman Bank of Montana (603) I (SemtAnn) (FHLB) (205 -50%; 60730 %) Anchor Bank I 1126/13 5.00 025867 -BJ -2 $96,000.00 I I CID - American Erp Cenhsion Bank, Salt Lake City, UT (601) I Dab I 03110/14 1.50 05967E -AN -9 $200,000.00 I Due Rata Account 0 Amout I CID - Banco Popular De Puerto Rico (601) ) - I 0324/14 1.50 856284-YS -7 $100,000.00 I 07115113 020 95851576731 $1,500,000.00 I CID - State Bank of India, New York (607) I 09/16/13 020 95851577770 $2,000,000.00 I 09/08114 1.25 02587D -CT -3 $150,000.00 ) 11/OW13 0.20 95851578572 $1,000,000.00 I C/D - Amedcan Exp Confusion Bank, Salt Lake City, UT (206) I 0924114 3.25 173120 -LV -9 $96,000.00 Touts $4,500,000.00 I (Monody) CID - Citibank, NA- Nevada (606) ) - I 1028114 3.25 06740K -CK -1 $96,000.00 I CID - Barclays Bank of Delaware (601) ( 12101114 5.00 085991 -SJ-2 $96,000.00 tat State Bards of Rosemout I CID - MAI Marshal 5 bley Bank - Milwaukee, WI (602) 1 I 01/16115 4.85 085993 -1T-0 $96,000.00 I Data I C/D - Capital One, NA., Virginia (607) I Due Rate Account 0 Amount I 01130/15 4.00 0859933Z -1 $96,000.00 I - I CID - Goldman Sachs Bank (101) I I 05/18/15 1.85 17284A-SF-6 $96,000.00 I CID - CIT Bank - Salt Lake City, UT (601) I I 06/16/15 1.05 33764J -EZ4 $245,000.00 I Totals (Smith Barney) 37,I88,114110.00 I (Monody) CID - Fist Bank of Puerto Rico (207) I Totals $0.00 I 07113/15 1.15 20451 P -AP -1 $200,000.00 I I CID - Compass Bank, Birmingham, AL (603) I a� I 05131116 2.15 254670 -F49 $150,000.00 I CID - Discover Bank of Delaware (606) I Rosemout National I 0725116 1.20 25811 L -X7 -9 $245,000.00 I Wells Fargo (Formerly Wachowls) I C/D - Dora] Bank, Catano, Puerto Rico (603) I Date I 0824116 1.85 3814264E -2 $150,000.00 I Dab Due Rate Account 0 Amman I C/D - Goldman Sarin Bank (607) I Due Rata Cusip 0 Amaet - I 09/09/16 1.85 361607 -WR -3 $150,000.00 I I C/D - GE Capital Financial of Utah (602) I 11/00016 2.05 36159S4J -7 $240,000.00 I 09/30/16 2.00 36159C -3H-7 $96,000.00 I CID - GE Capital Retail Bank - Draper, UT (101) C/D - Cole GE Money Bank, Sae Lake City, UT (603) I 061MI7 1.85 99000N -FZ -9 $100,000.00 I 01119117 1.90 06740K-FX-0 $150,000.00 I (Monthly) CID - Comenity Banc (formerly WFNB). Wilmington. DE (601) I C/D - Barclays Bank of Delaware (326) I Totals $0.00 I 0427117 2.00 856284 -E34 $150,000.00 I I CID - State Bank of India, New York (601) I I 05131/17 1.80 982999 -80.1 $100,000.00 I US Bank I (Monthly) C/D - Comenity Bank (formerly WFNB), Wilmington, DE (601) I I 0726117 1.70 254671 -EQ-9 $96,000.00 1 Date I CID - Discover Bank of Delaware (607) Due Rate Account 0 Amour I 10/03117 1.50 795450PN9 $245,000.00 I - I CID - Sage MeeBank, Many UT (101) I I 02/2422 Step 94986T.N-0 $245,000.00 I I (Quarterly) CID - Wells Fargo Bank of SD (20640%; 606.20 %; 60740%) I I 1 0611220 Step 3134G3 -VX -5 ? ?? ?7? ? ? ? ?? 0.04 104790484406 $10,525,015.82 12/31112 Money Market /Savings (No Maturity Date) Totals $10,526,015.92 SteA"mg Stab Bank Daft Due Rate Account 0 Amount ?7 ?777 ?77 ?? 0.44 990005332 $606,866.32 12131112 Money Market /Savings (No Me" Dab) I (Semi -Am) (FHLMC) (601) 1 03/1422 Step 313463 -QJ-2 1 (Semi -Ann) (FHLB) (607) I 032822 Step 3134G3-SF-8 I (Semi -Am) (FHLMC) (601) I 0711822 Step 313379 -YB-9 I (SemkW) (FHLB) (101) I 072622 Step 313380.2H -9 I (Semi -An) (FHLB) (101) I 072622 Step 313380 -3A -3 I (SemfAnn) (FHLB) (101) I 0811622 Step 313380-AZ-0 I (Semi-Ann) (FHLB) (101 -50%; 20230 %) I 12/0522 Step 313381-BX -2 I (Semi -Ann) (FHLB) (101) I 1210722 Step 313381 -OF -9 I (Semi -Ann) (FHLB) (101) I 1228/22 Step 313381 -LR4 I (Semi-Ann) (FHLB) (603) I 01 /3023 Step 313381SK -2 I (Semi -Ann) (FHLB) (606) I 01/30/23 Step , 3133814)6.5 I (Semi -Aram) (FHLB) (601 -50 %; 606.50 %) $502,910.00 5225,600.75 $926,443.75 s900,208.00 $997,380.00 $1,250,312.50 $1519,905.00 $297,699.00 $34$,941.50 $300,426.00 5350.000.00 $8001000.00 I I Totals $606,866.32 I 1 Totals 58,367,636.60 I I I Total lmresmlants $32,669,335.64 I Cash Outflows: 1) Council (41110) 247,700.00 9,547.47 12,308.33 3,905.60 13,453.07 16,128.24 12,308.33 12,308.33 City of Rosemount - General Fund 0101 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 40,366.67 30,753.31 Estimated Cash Flow Chart (As Mordht are Compheed, Actual Figures Replace Estimates) 74,537.03 - 40,368.67 40,366.67 40,366.87 40,366.67 40,366.67 40,366.67 40,366.67 40,366.67 40,386.67 3) Elections (41410) 22,000.00 Updated Through 2128113 0.00 0.00 0.00 0.00 0.00 0.00 Beginning Balance (Cash & Investments) 0.00 8,085,032.50 0.00 6,000,876.19 0.00 22,000.00 7,511,425.79 8,824,350.79 0,074,275.79 5,423,450.79 4,716,375.79 8,076,000.79 7,425,175.79 6,718,100.79 5,968,025.79 5,317,200.79 (Current Month is Unaudited Previous MIE Balance) 36275.00 36,275.00 36,275.00 38,275.00 36,275.00 36,275.00 5) General Government (41810) 383200.00 11237.42 31,933.33 22,514.92 33,752.34 22,874.03 31,933.33 31,933.33 (Balance Includes *ALL* Funds - Allocated & Unallocated) 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) 898,800.00 57,809.19 74,733.33 88,300.95 123,910.14 128,313.29 74,733.33 74,733.33 74,733.33 74,733.33 74,733.33 74,733.33 2613 2012 74,733.33 74,733.33 7) Govemment Buildings (41940) 540,500.00 21,576.84 37,875.00 35,601.65 57,078.49 70,611.94 37,875.00 37,875.00 2013 January February February Yaar -TaDats Year -To-Dab March April May June July August September October November December 265,650.00 Budget (Aclw() (Estimate) (Actual) (Actual) (Last Year) (Eadmatel (Ertkmile) (Estimate) (Estimate) (Estimate) (Estimate) (Estimate) (Fadmate) (Estbnats) (Fatimal Cash Inflows: 7,833.33 7,833.33 221,833.33 7,833.33 7,833.33 50,833.33 7,833.33 50,833.33 10) Fleet Maintenance (43100) 845,200.00 27,854.58 53,766.67 39,648.89 67,504.27 71,070.53 53,788.67 1) Taxes (31010.31040) 8,571,300.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,288,050.00 0.00 0.00 0.00 0.00 4,288,850.00 2) Gravel Taxes (31710) 20,000.00 0.00 0.00 0.00 0.00 0.00 20.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 58,250.00 0.00 0.00 56,250.00 0.00 0.00 58,250.00 58,250.00 4) Licenses (32110- 32180 & 32240) 53,500.00 3,911.50 4,458.33 2,06525 5,976.75 15,742.00 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 4,458.33 5) Permits (32210 - 32290, Less 32240) 328,800.00 42,854.82 27,400.00 23,563.25 86,418.07 50,599.30 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 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) State & Other Aids (33401 - 33630) 300,100.00 63,493.06 0.00 16,395.00 79,888.06 40,474.50 0.00 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) 683,000.00 90,008.87 53,1(16.87 89,195.17 179,204.04 167,970.18 53,168.67 53,188.67 53,166.67 53,188.87 53,166.67 53,166.67 63,186.67 53,186.67 53,168.67 53,166.87 9) Park Revenues (34718 - 34790) 140,600.00 1,174.35 11,718.67 1,280.40 2,434.75 2,313.25 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 11,716.67 10) Court Fines (35101) 125,000.00 0.00 10,416.67 11,389.71 11,389.71 8,471.38 10,416.67 10,416.67 10,416.67 10,418.67 10,416.67 10,418.67 10,416.67 10,416.67 10,416.67 10,416.67 11) Interest Earnings (38210 &38215) 145,500.00 24,564.79 12,125.00 5,019.80 29,554.59 18,915.98 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,125.00 12) Other (36101,220,30,60,65, 38090 & 39101) 23,700.00 2,964.81 1,975.00 5,863.62 8,828.23 10,076.88 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 1,975.00 13) Comm Center Revenues (38080 - 38154) 101,300.00 4,241.68 8,441.87 5,899.34 10,141.02 18,347.75 8,441.67 8,441.87 8,441.67 8,441.67 8,441.67 8,44147 8,441.67 8,441.87 8,441.67 8,441.87 14) St. Joseph's Revenues (38201- 38215) 21,300.00 505.00 1,775.00 1,160.00 1,865.00 4,100.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 1,775.00 15) Transfers In (39202 & 39203) 3,500.00 3,500.00 0.00 138.35 3,838.35 3,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Revenues 10,728,800.00 237,218.68 131,475.00 161,749.89 398,968.57 340,511.22 151,475.00 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,628,425.00 Cash Outflows: 1) Council (41110) 247,700.00 9,547.47 12,308.33 3,905.60 13,453.07 16,128.24 12,308.33 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 40,366.67 30,753.31 65,257.34 74,537.03 40,386.67 40,368.67 40,366.67 40,366.87 40,366.67 40,366.67 40,366.67 40,366.67 40,366.67 40,386.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 38,275.00 32,114.45 82,357.70 57, 868.30 36,275.00 36, 275.00 36, 275.00 36,275.00 36275.00 36,275.00 36,275.00 38,275.00 36,275.00 36,275.00 5) General Government (41810) 383200.00 11237.42 31,933.33 22,514.92 33,752.34 22,874.03 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 31,933.33 6) Community Development (41910) 898,800.00 57,809.19 74,733.33 88,300.95 123,910.14 128,313.29 74,733.33 74,733.33 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) Govemment Buildings (41940) 540,500.00 21,576.84 37,875.00 35,601.65 57,078.49 70,611.94 37,875.00 37,875.00 37,875.00 37,875.00 80,875.00 37,675.00 37,875.00 37,875.00 37,875.00 37,875.00 8) Police (42110) 3,187,800.00 247,860.14 255,650.00 238,876.54 484,736.68 423, 913.06 265,650.00 265,650.00 265,650.00 265, 850.00 265,650.00 265 ,650.00 265,650.00 265,650.00 265,650.00 285,650.00 9) Fire (42210) 437,000.00 3,328.27 7,833.33 8,111.45 11,439.72 8,612.92 7,833.33 50,633.33 7,833.33 7,833.33 221,833.33 7,833.33 7,833.33 50,833.33 7,833.33 50,833.33 10) Fleet Maintenance (43100) 845,200.00 27,854.58 53,766.67 39,648.89 67,504.27 71,070.53 53,788.67 53,768.87 53,766.67 53,766.87 53,788.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 106,016.67 86,095.79 123,920.69 118,806.28 106,016.67 106,016.67 106,016.87 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 110,200.00 87,135.58 155,258.16 163,241.87 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 110,200.00 13) Parks Maintenance (45202) 739,100.00 27,997.93 61,591.67 37,317.71 65,315.64 78,275.01 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 61,591.67 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 10,728,500.00 577,706.60 838,550.00 888,277.84 1,263,994.24 1,234,250.50 838,550.00 881,550.00 838,550.00 838,650.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): 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 - 20860) (80,860.55) (50,828.10) (50,828.10) (50,826.10) (50,826.10) (50,826.10) (50,826.10) (50,825.10) (50,828.10) (60,828.10) (50,828.10) (50,826.10) 3) Payroll Liabilities (21701 - 21740) 48, 926.48 64, 810.18 54, 810.18 64, 810.18 54,810.18 54,810.18 54,810.18 54, 810.18 54, 810.18 54,810.18 54,810.18 54,810.18 4) Deposits Payable (22000 & 22001) (68,009.90) (69,409.90) (69,409.90) (89,409.90) (69,409.90) (69,409.90) (69,409.90) (69,409.90) (69,409.90) (69,409.90) (69,409.90) (69,409.90) 5) As -Built Survey Deposits (22010) (94,000.00) (106,000.00) (106,000.00) (108,000.00) (106,000.00) (106,000.00) (106,000.00) (106,000.00) (106,000.00) (106,000.00) (108,000.00) (106,000.00) 6) Deferred Revenues (22200) (17,223.64) (17,223.54) (17,223.54) (17,223.64) (17,223.54) (17,223.54) (17,223.54) (17,223.54) (17,223.64) (17,223.54) (17,223.54) (17,223.54) 7) Fire Dept. Deferred Revenues (22220) (1,975.78) (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,920.32) (1,920.32) (1,920.32) (1,920.32) (1,920.32) (1,920.32) (1,920.32) (1,920.32) (1,920.32) (1,920.32) 9) Police Deferred Revenues (22222) (7,810,18) (8,885.18) (8,885.18) (8,865.18) (8,865.18) (8,865.18) (8,885.18) (8,865.18) (8,885.18) (8,865.18) (8,865.18) (8,885.18) 10) P & R Deferred Revenues (22223) (9,520.42) (10,185.76) (10,185.76) (10,185.76) (10,185.76) (10,185.78) (10,185.76) (10,185.76) (10,185.76) (10,185.76) (10,185.76) (10,185.76) 11) Administration Deferred Revenues (22225) (37,605.98) (37,605.96) (37,605.96) (37,805.96) (37,605.96) (37,605.96) (37,605.96) (37,605.98) (37,605.96) (37,605.96) (37,605.96) (37,605.96) 12) Sales Tax Payable (22810) (271.26) (319.02) (319.02) (319.02) (319.02) (319.02) (319.02) (319.02) (319.02) (319.02) (319.02) (319.02) 13) FIB Reserved for (24405.24496) (691,725,00) (921,031.43) (921,031.43) (921,031.43) (921,031.43) (921,031.43) (921,031.43) (921,031.43) (921,031.43) (921,031.43) (921,031.43) (921,031.43) 14) FIB Reserved for Comp Absences (24401) 924,335.06 924,335.06 924,335.06 924,335.06 924,335.06 924,335.08 924,335.00 924,335.06 924,335.06 924,335.06 924,335.06 924,335.06 Total Liabilities (17,661.35) (244,347.73) (244,347.73) (244,347.73) ( 244, 347.73) ( 244, 347.73) (244, 347.73) (244,347.73) (244,347.73) (244,347.73) (244,347.73) (244,347.73) Month -End Amount Available for Spending 7,706,883.23 7,232,000.71 6,824,350.79 6,074,275.79 5.423,450.79 4,718,375.79 8,076,000.79 7,425,175.79 6,718,100.79 5,968,025.79 5,317,200.79 8,940,075.79 Unaudited Ending Balance (Cash & Investments) 8,000,876.19 7,511,425.79 Different from Available for Spending Because of: 1) Liabilities Listed Above 2) Other Assets, Liabililes & Changes in Furst Balance - For March Thru December only do "NOT" take off the liability total again - otherwise the effect Is duplicated) II "- Prior to that, make sure liability total is Included In "Momh -End Amount Avallble" balance """ Donation and Assignment Balances 2/28/2013 Account # ---------- - - - - -- ------------------------------------------------------------------------------- Description - - - - -- Balance --------------- - - -- 101 -22220 Deferred Revenue - Fire Department 105.76 101 -22221 Deferred Revenue - D.A.R.E. Program 1,920.32 101 -22222 Deferred Revenue - Police Department 8,865.18 101 -22223 Deferred Revenue - Park & Rec Department 10,185.76 101 -22225 Deferred Revenue - Administration 37,605.96 101 -24405 FIB Assigned for Health Insurance 225,000.00 101 -24406 FIB Assigned for Cable TV / Franchise Renewal Costs 9,306.43 101 -24419 FIB Assigned for Additional Police Dept. Training 8,000.00 101 -24420 FIB Assigned for SKB Landscape Program 56,100.00 101 -24423 FIB Assigned for Chess Consultant 5,400.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 144,571.67 101 -24430 FIB Assigned for Parks Maint Repair & Maintenance 139,400.00 101 -24450 FIB Assigned for Community Survey 20,000.00 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 -24454 FIB Assigned for Future Parking Lot Maintenance Costs 25,000.00 101 -24455 FIB Assigned for Siren Repairs /Replacements 10,467.07 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 15,000.00 202 -24428 FIB Assigned for Council Chamber Audio Visual Equipment 100,000.00 202 -24429 FIB Assigned for Central Park Paver Replacements 5,000.00 202 -24430 FIB Assigned for Steeple Center Exterior Signs 15,000.00 202 -24431 FIB Assigned for Community Center Reader Board Sign 23,000.00 202 -24432 FIB Assigned for Community Center Improvements 108,000.00 202 -24433 FIB Assigned for Fire Alarm System for C/C 40,000.00 202 -24434 FIB Assigned for St. Joseph's /Library 6,956.75 203 -24430 FIB Assigned for AUAR 20,959.00 203 -24431 FIB Assigned for 42/52 Costs 180,000.00 203 -24432 FIB Assigned for Akron Avenue Corridor Study 50,000.00 203 -24433 FIB Assigned for Pedestrian Improvements 122,030.88 207 -24455 FIB Assigned for Siren Replacements 2,000.00 207 -24480 FIB Assigned for P.C. Hardware 10,018.17 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 -24485 FIB Assigned for Police Tactical Gear Replacements 6,500.00 207 -24487 FIB Assigned for Police Squad 1,548.66 207 -24488 FIB Assigned for City Accounting Software 13,720.05 207 -24489 FIB Assigned for City -Wide Software 256,000.00 207 -24493 FIB Assigned for Police Photo Imaging Software 4.09 207 -24496 FIB 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 2128/13 2013 CIP Budget - Departments to Use Following Encoding: 20249002- 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 0.00 45,000.00 Parks & Recreation Erickson Park Shelter 100,000 528 500.00 99,500.00 Parks & Recreation Senior Housing / Center Expenses 1,400,000 529 7,663.40 1,392,336.60 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 797.12 99,202.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 11,460.52 Sum of Positive Balances 2,960,039.48 Only Included Total Levy for 2013 24,000 COH 2/28/13 2,937,240.36 FIB Assigned for Council Chamber Equip. 100,000.00 FIB Assigned for Central Park Pavers 5,000.00 FIB Assigned for Steeple Center Signs 15,000.00 FIB Assigned for C/C Reader Board Sign 23,000.00 FIB Assigned for C/C Improvements 108,000.00 FIB Assigned for C/C Fire Alarm System 40,000.00 FIB Assigned for Library/St. Joe's 6,956.75 Reserves Available 3/1/13 (320,755.87) 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,00012/13) SKB User Fees Still to Receive in 2013 600,000.00 (Reed $xx,000.00 YTD) ($600,000 Total Expected) Total Unassigned Reserves 303,244.13 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 2/28113 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 0.00 0.00 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 0.00 0.00 Public Works Costs for Closed Projects 0 535/720 0.00 0.00 Public Works 857,500 2,500.00 855,000.00 * Sum of Positive Balances - ---- Only Included Total Levy for 2013 730,000 COH 2/28/13 1,653,856.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 122,030.88 Reserves Available 3/1/13 885,866.36 1st Half 2013 Levy to Receive 7/13 365,000.00 (Reed $xxx,000 7/13) 2nd Half 2013 Levy to Receive 12/13 365,000.00 (Reed $xxx,000 12/13) SKB User Fees Still to Receive in 2013 125,000.00 (Reed $xx,000.00 YTD) ($125,000 Total Expected) Total Unassigned Reserves 1,740,866.36 Projected for 12/31/13 (Does Not Include Future Interest Earnings) City of Rosemount Equipment CIP Fund - #207 Monthly Review - Audit of CIP Coding Amounts For Month Ending 2128113 2013 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 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 0.00 20,000.00 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 3,625.00 57,013.00 Police 615,138 41,381.96 573,756.04 Sum of Positive Balances - ---- Only Included Total Levy for 2013 460,000 COH 2/28/13 1,469,977.75 FIB Assigned for Siren Replacements 2,000.00 FIB Assigned for P.C. Hardware 10,018.17 FIB Assigned for Fire Dept. Technology 15,557.81 FIB Assigned for C/H Security Equip. 1,405.00 FIB Assigned for Police Tactical Gear 6,500.00 FIB Assigned for Police Squad 1,548.66 FIB Assigned for City's Financial Software 13,720.05 FIB Assigned for City -Wide Software 256,000.00 FIB Assigned for Police Photo Imaging SW 4.09 FIB Assigned for Future Equip Purchases 165,889.53 Reserves Available 3/1/13 423,578.40 1st Half 2013 Levy to Receive 7/13 230,000.00 (Reed $)xx,000.00 7/13) 2nd Half 2013 Levy to Receive 12/13 230,000.00 (Reed $xxx,000.0012/13) Sale of Old Squad Cars 6,000.00 (Reed $x,000.00) Total Unassigned Reserves 889,578.40 Projected for 12/31/13 (Does Not Include Future Interest Earnings) Revenues: Other State Grants & Aids (33425) *Actual` Administrative Fee -Other Funds (34106) *Actuar Other Gen't Govt Chgs for Services (34109) *Actual* Principal - Special Assessments (36101) *Actual' Penalties - Special Assessments (36102) *Actual* Interest -Investments (36210) *Actual* Other Interest Revenues (36215) `Actual' Rents & Royalties (36220) *Actual` (Antenna Leases) Contributions (36230) *Actuar Other Revenues (36260) *Actual* Use of Reserve Funds (36265) *Budget Number' Residential Water (37110) *Billed* Apartment Water (37120) *Billed` Institutional Water (37125) *Billed* Commercial Water (37130) *Billed* Industrial Water (37140) *Billed* Penalties - Water (37160) *Billedr Other Water Revenues (37170) *Actual* Water Meter Sales (37180) *Actual* Sale of General Fixed Assets (39101) *Actual` Total Revenues Less: Operating Expenses (All Actual) General Operating (49400 -01) Administrative Personnel (49400 -77) TechnicaXlerical Personnel (49400-78) Maintenance Personnel (49400 -79) Part-Time Personnel (49400 -99) East Side Watennain Vault (49406-01) Well #7 (49407 -01) Well #8 (49408 -01) Well #9 (49409 -01) Rural Water System (49410 -01) Rural Water System #2 (49411 -01) Well #12 (49412 -01) Well #14 (49414 -01) Well #15 (49425 -01) Water Tower #1 (49415 -01) Water Tower #2 (49416.01) Water Tower #4 (49417 -01) East Side Water Tower #3 (49418 -01) Total Operating Expenses Net Income (Loss) City of Rosemount Water Fund - 0601 Income Statement For Month Ending 2128113 Budget Figures Y -T-0 January February March Apra 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 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 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 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 60,000.00 3,902.11 1,382.50 2,519.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00 5.67 0.00 5.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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 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 1,050,000.00 36,883.19 86,362.36 (49,479.17) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 73,000.00 49.46 49.45 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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 65,000.00 120.55 95.55 25.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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 8,000.00 3,536.26 2,021.52 1,514.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 30,000.00 6,599.00 4,059.00 2,540.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 1,557,000.00 141,743.30 173,571.38 (31,828.08) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 630,700.00 33,792.82 21,049.47 12,743.35 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 107,300.00 15,416.91 7,255.15 8,161.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 145,700.00 20,538.00 9,814.85 10,723.15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 165,800.00 25,906.62 11,148.26 14,758.36 0.00 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 3,000.00 118.28 0.00 118.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 29,100.00 2,387.83 1,359.98 1,027.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,900.00 2,400.00 0.00 2,400.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 57,300.00 2,343.76 2,212.69 131.07 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 21,600.00 1,504.27 1,308.18 196.09 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 31,300.00 1,304.79 1,304.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 57,300.00 897.47 0.00 897.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 33,800.00 3,058.42 0.00 3,058.42 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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 2,600.00 104.64 0.00 104.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,500.00 597.69 0.00 597.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,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 1,330,300.00 110,371.70 55,453.37 54,918.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 226,700.00 31,371.60 118,118.01 (86,746.41) 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 -1602 Income Statement For Month Ending 2128/13 Total Operating Expenses 1,782,200.00 254,532.43 133,937.52 120,594.91 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 (176,714.08) 6,939.24 (183,653.32) 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 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 2,172.63 0.00 2,172.63 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 8.58 0.00 8.58 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' 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 68,819.44 136,458.79 (67,639.35) 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 95.72 95.72 0.00 0.00 0100 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0,00 Institutional Sewer (37225) 'Billed' 21,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' 61,000.00 76.13 76.13 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,022.62 1,748.72 2,273.90 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,782,200.00 77,818.35 140,876.76 (63,058.41) 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,315,600.00 191,126.40 105,585.28 85,541.12 0.00 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 15,416.74 7,255.14 8,161.60 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) 145,700.00 20,537.99 9,814.84 10,723.15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0100 0.00 0.00 Maintenance Personnel (49450 -79) 165,300.00 25,906.46 11,148.26 14,758.20 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 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 56.03 0.00 56.03 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) 4,900.00 324.30 0.00 324.30 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) 7,400.00 254.20 0.00 254.20 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) 7,400.00 491.07 0.00 491.07 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) 8,900.00 116.06 0.00 116.06 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 138.24 0,00 138.24 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 57.51 57.51 0.00 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 30.94 0.00 30.94 0.00 0.00 0.00 0.00 0.00 0.00 OAO 0.00 0.00 0.00 Total Operating Expenses 1,782,200.00 254,532.43 133,937.52 120,594.91 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 (176,714.08) 6,939.24 (183,653.32) 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 Revenues: Other State Grants & 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 7th) (49516 -01) Total Operating Expenses Net Income (Loss) a City of Rosemount Stone Water Fund - #603 Income Statement For Montle Ending 2/28/13 eudget 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 3,732.74 3,714.03 18.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 400.00 7.37 0.00 7.37 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 0.00 860,000.00 66,614.66 43,196.56 23,418.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,600.00 1,372.37 726.98 645.39 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 914,000.00 74,260.89 50,134.97 24,125.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 450,400.00 98,522.46 96,688.02 1,834.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,700.00 1,423.94 514.87 809.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 80,600.00 11,366.26 5,490.06 5,876.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 86,400.00 12,953.35 5,574.24 7,379.11 0.00 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 30.24 30.24 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 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 117.12 0.00 117.12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,500.00 29.02 0.00 29.02 0.00 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 47.30 0.00 47.30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 647,600.00 124,489.69 108,397.43 16,092.26 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 266,400.00 (50,228.80) (58,262.46) 8,033.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00