The URL can be used to link to this page

Home My WebLink About[04f] Treasurer's Report Council Agenda Item 4f MEETING DATE: July 20, 2015 AGENDA ITEM: Financial Report – 2nd Quarter 2015 & June 2015 Financial Reports SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: Council adopted the 2015 budget on December 4, 2014. BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to actual position are provided for Council review. The numbers presented are the cash balances as of June 30, 2015. Reversing audit entries have been recorded; thus, a few balances may show negative until activity occurs in 2015. There are a couple points to highlight from the reports. CASH POSITION : - The market rate of return (ROR) is approximately 1.11% with an average maturity of just under two years. The federal markets are still low; however, have increased slightly since the record lows at the beginning of the year. The 10-year reported 2.36% and 2-year at 0.64%. For comparison, I checked the Minnesota 4M Fund rates many cities invest in versus a broker. The th 2-year was 1.00% and 5-year at 2.3% at June 30. St. Joseph has a slightly higher rate of return using the local institutions and broker. The City tiers the maturity dates within the boundaries of the Investment Policy. The tiered maturity dates has helped the City maintain a higher rate of return than the current market. Sentry Bank and the Central MN Credit Union have given the City favorable rates on the money market and CD accounts. nd - After the 2 quarter ended, the global markets have raised many concerns with current conditions in Greece and China. The U.S. markets will react to the global conditions along with the economic conditions in the United States. Some U.S. economic trends have improved, others are still concerning. Unemployment has gone down, gas prices lower than the past few summers, and home sales have increased greatly to improve the economy. Although more people are working and gas prices are down, consumer spending remains low. This will hold down manufacturing indexes. The federal government feels hopeful the economy will recover enough to increase the federal rates this fall for the first time since 2008. Interest earnings will likely remain low until the federal rates can increase. On a positive note, the lower federal rates have kept the bond rates low – favorable for our July bond issue. - Interest earnings for 2015 amounts to $31,450.73, 31% of the budget. The City’s policy is to hold investments until maturity. GASB 31 requires the City to mark investments at the current market value as of the close of each month. In doing so, earnings will show great fluctuations. The alternative would be for the City to invest in money market funds. The money market funds are earning interest similar to the Treasury rates and would equate in much lower returns than the securities we hold. - Overall, the cash and investments balance decreased $319,504 from the beginning of the year. The first half LGA and 30% tax settlement will be received in July. Once received, the cash will st have increased over $300,000 since Jan. 1. FUNDS REPORT : General fund - The spent 44% of the 2015 expenditure budget and received 26% of the revenue budget. Expenditures are mainly operational in nature. Engineering is a bit higher for the first quarter as the result of development costs not yet reimbursed by the developers. Capital expenses were held off until the equipment certificates and state aids are received. Revenues will be low until July when the remaining 30% tax settlement and state aids are received. Enterprise Funds - The show expenses more than revenues accept the water and street light utility fund. The water usage rates were increased to help cover the water treatment plant debt. The st first half interest payment was paid in May, the final half and principal payment is due Dec. 1. It will be ideal for the water revenues to exceed expenses even though the utility billing lags behind monthly expenses due. The funds with expense greater than revenue will balance out at the end of the year once the utility billing can catch up to the monthly disbursements. Water fund analysis (fund 601/501) – The enclosed spreadsheet shows an analysis of the water fund, including the Water fund (601) and the Water Access fund (WAC-501). The City has received $44,000 in WAC charges during the year. There were two new homes that will receive the $5,000 subsidy towards WAC/SAC (not yet shown); and one home paid their WAC fee to connect to City water by 2016. Commercial development has picked up. The Credit Union service center and Rolling Ridge Event Center began construction. Both projects paid WAC/SAC fees. In addition, building permit revenue is near double the budgeted the amount. The increase in development activity is anticipated to continue in the third and fourth quarters. ½ ¢ Sales Tax (fund 200): The sales tax fund has a balance of $1,553,472.37 at the end of June. The City anticipates collecting $3,372,754 in sales tax revenue through 2018 (conservatively); $2,640,009.34 was collected to date. Collections have continually increased over the years, even during most of the recession years. The distribution formula is reviewed annually between the area cities. St. Joseph has gained a higher percentage of the distribution each year. Population and sales taxes paid increased St. Joseph’s share of the distribution. The anticipated expenditures total $2,553,811.72 leaving approximately $862,220.36 remaining for the sales tax funding through 2018. The sales tax extension approved in Nov. 2014 is expected to generate an additional $11,000,000. CIP REPORTS: - Capital outlay in 2015 has been slow pending the equipment certificate issue and state aid proceeds. The police department replaced a squad and purchased radios, a mower was replaced, and the fire department has purchased helmets and a couple sets of turnout gear. The Park Board is conducting a study to prioritize the parks and trails projects. The Fire Board and City Council approved purchasing new chairs and tables for the fire hall. The Fire Board also approved adding monitors into the truck bays. - Other projects include the EDA funding for a TIF development, façade storefront grants, two revolving loans, looking for shovel ready lots and studying options for the Farmer’s Market. Also included under EDA is the 2013 federal DEED grant for home improvements; $229,094 remains of the $600,000 grant for these projects. - SEH has been busy wrapping up 2014 projects, getting 2015 projects ready to begin construction and looking at opportunities for 2016 projects. BUDGET/FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action – Quarterly and June Financial Reports 2nd Quarter Reports: Cash Position as of 6/30/15 Cash and Investment Holdings Chart Cash Balances by Fund/Remaining Budget General & Fire Budget to Actual Expenditures & Revenues Enterprise Funds Activity Graph Quarterly Water Fund Analysis Half Cent Sales Tax Fund Summary June Treasurer’s Reports: Cash and Investment – Council Report Council Month End Revenue Summary Council Month End Revenue – General Fund Council Month End Revenue – Enterprise Funds Council Month End Expenditure Summary Council Month End Expenditure – General Fund Council Month End Expenses - Enterprise Funds Capital Improvement Summary Reports: General Fund Capital Improvement Plan - Summary General Fund Capital Improvement Plan - Fire General Fund Capital Improvement Plan - EDA Enterprise Capital Improvement Plan – Public Works Capital Improvement Budget Summary – Park Board REQUESTED COUNCIL ACTION: Accept the financial reports as presented. City of St. Joseph, Minnesot a Cash Position As of 6/30/15 Sentry BanMaturity DateInterestCurrent Balance# Securities% of Total k Checking Account (Reconciled)N/A0.15%191,682$ N/A Money Market SavingsN/A0.42%523,681 N/A Bank Certificates of Deposit13-18 months0.98% 21,000,000 avg averages16 months0.63% Total Sentry Bank$1,715,36324% Central MN Credit Union Share Savings AccountN/A0.00%$ N/A35 Money Market SavingsN/A0.70% 519,015N/A Power Money Market CheckingN/A0.65% 517,846N/A Jumbo Bank Certificates of Deposit1-33 months1.00% 1,325,6803 avg averages14 months0.87% Total CMCU$2,362,57534% Total Deposits$ 4,077,938 Morgan Stanley Smith Barne y Brokered Money Market SavingsN/A0.00%$ 245,595N/A Government Securities/Notes91 months1.50% 779,4001 avg Brokered Certificates of DepositTiered 3-79 months1.86% 1,900,99214 avg averages38 months1.84% Total SB$ 2,925,98742% Total Investments$ 2,925,987 2015 YTD Total Deposits and Investments$7,003,925Interest Earned Average Interest APY22 months1.11%$31,451 Total Deposits & Investment$ Cash and Investment Balance7,003,925 s Petty Cash AdministrationN/AN/A$ 200 Police DepartmentN/AN/A 75 Total Petty Cash$275 Custodial Credit Risk: All deposits and investments insured by FDIC/SPIC/NCUA or secured by perfected pledged collateral. Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highl y sensitive, interest fluctuating investments. The City attempts to purchase longer termed investments when the interest rates are favorable and depending on cash flow needs to lock into a favorable rate. Credit Risk: There are no instruments exposed to credit risk. Maturity Concentration of Credit Risk: The City invests in various instruments and several financial institutions. % SecuritiesAverages Brokered Money Markets$ 245,5953.51%N/A Brokered Certificates of Deposit$ 1,900,99227.14%2.8 years Government Bonds/Notes$ 779,40011.13%7.6 years Foreign Currency Risk: The City only invests in USA and USA territories. ağƩƉĻƷ {ĻĭǒƩźƷźĻƭ {ğǝźƓŭƭ aƚƓĻǤ ağƩƉĻƷ /5ƭ ЋЋі DƚǝĻƩƓƒĻƓƷ /5ƭ .ƩƚƉĻƩĻķ.ƩƚƉĻƩĻķ /ŷĻĭƉźƓŭ Ͳ aƚƓĻǤ ЊͲЎЏЉͲЎАА .ğƓƉ ЌЌі Ќі IƚƌķźƓŭƭ Ͳ Ͳ ЋͲЌЋЎͲЏБЉ ЊВЊͲЏБЋ LƓǝĻƭƷƒĻƓƷ ğƓķ /ğƭŷ ЋАі Ѝі Ͳ Ͳ ЊͲВЉЉͲВВЋ ЋЍЎͲЎВЎ ЊЊі Ͳ ААВͲЍЉЉ (6,840) (16,484) (4,306) (93,235) (4,814) (19,477) $ 1,874,743 163,481 411,329 381,453 23,368 1,163,945 1,143,349 205,596 105,419 6,446 37,853 15 RECEIVED15 LEFT $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 658,677 127,324 102,435 16,484 12,686 472,216 46,3922,256,586 93,235 3,654 4,814 43,447 21,977 240,725 273,346 98,689 21,571 18,912 $ $ 2,533,420$ 290,805$ 883,545$ 424,900$ 1,404,670$ 1,416,695$ 304,285$ 126,990 $ 95,595$ 10,100$ 8,380$ 69,760$ 2,500$ 56,765 $ -$ -$ - 15 EXP BUD15 SPENT15 LEFT15 BUD RE V (10,400) (47,234) (13,810) (1,163) $ 1,418,071 232,130 42,105 1,134,051 405,000 2,497,957 63,235 636,735 1,329,662 1,453,773 185,235 177,673 38,158 Cash Balances by Fund/Remaining Budget 3.9 months of cash balanc e City of St. Joseph, Minnesota $ 1,110,409 231,223 337,922 127,250 68,675 88,490 11,540 26,043 610 1,163 47,234 90,804 83,570 30,892 18,6082,274,432 As of 6/30/15 - - $ $ 2,528,480 300,805 130,595 1,224,855 405,000 1,140 2,524,000 69,760 636,735 1,560,885 1,791,695 312,485 208,565 63,845 56,765 - - (319,504) 796,863524,335116,968856,198297,073246,341 23,0251,553,47243,1304,9852,096,35349,119137,879232,27616,9157,323,429 6,8682,124 7,003,92 FUNDCASH BALANC5 E $ $ 12/31/14 Cash Balance2015 cash decrease State Collected Sales Ta x Refuse/Compost Fund Capital Project Funds Charitable Gambling Revolving Loan Fun d Sewer Access Fun Water Access FunStreet Light Utility TOTALS d d Park Dedication General Fund Storm Sewe Sewer Fund Debt Funds Water Fund r EDA FundTIF Funds Fire Fund Budget Budget Actual Actual RevRev ExpExp $127,324 $290,805 Fund Revenues FundFire $347,369 & $300,805 Expenditures Actual $658,677 to Budget $2,533,420 General Fire $1,110,409 & General $2,528,480 $500,000 $3,000,000$2,500,000$2,000,000$1,500,000$1,000,000 $ wĻǝĻƓǒĻ 9ǣƦĻƓƭĻ υЍЉЉͲЉЉЉ υЌЌАͲВЋЋ υЌЎЉͲЉЉЉ υЋАЌͲЌЍЏ υЌЉЉͲЉЉЉ υЋЍЉͲАЋЎ υЋЌЊͲЋЋЌ Activity υЋЎЉͲЉЉЉ Funds υЋЉЉͲЉЉЉ Enterprise υЊЋАͲЋЎЉ υЊЎЉͲЉЉЉ υВБͲЏБВ υЊЉЉͲЉЉЉ υЌЉͲБВЋ υЎЉͲЉЉЉ υЊБͲВЊЋυЋЊͲЎАЊ υЊБͲЏЉБ υ WaterWater Light Sewer Refuse Street Storm City of St. Joseph Quarterly Water Fund Analysi s As of June 30, 201 5 Fund 601+501, Water/WAC Fund Balance as of December 31, 201(audited)$ 133,348.65 4 WAC fees collected for: Year to Date Revenue:702 MN St \[required to connect by 2016\] Interest Earnings7,506.43 1031-13th Ave NE \[new home\] Ad Valorem Taxes15,709.31 501 Lanigan Way \[new home\] Water Usage Charge115,351.55Central MN Credit Union \[service center\] Water Line Charge 88,026.24Rolling Ridge Event Center Penalties/Other Usage Fees (3,434.48) WAC/Trunk Fees 44,000.00 Antenna Lease Revenue 16,753.74 Bulk Water Sales 959.10 Transfers from other Funds - Total Revenue 284,871.8915.57%budget collected 2015 Revenue Budget1,829,570.00(includes fund 501) Year to Date Expenses by Department: Debt Payments(66,718.75) Water Tower Bond Summary - as of 6/30/15: Transfers to Other Funds - Power and Pumping Bond issue, net651,806.45(1,069.18) Water Treatment Plant 1(9,807.69) Sewer project portion(83,753.00) Water Treatment Plant 2(40,281.65) Engineering(62,591.81) Distribution -Legal(526.50) Wellhead Protection -Project costs(482,265.18) Water Tower(2,029.79)Remaining Balance22,669.96 Water Maintenance(95,085.46) Water Administration(16,230.75) Total Expenses (231,223.27)-27.06%budget expensed 2015 Expense Budget(1,160,885.00)(excludes depreciation) Fund Summary as of June 30, 2015: Water Fund Cash Balance - Fund 601+501 - unaudited $186,997.27 Fund 501$ 49,118.60 Fund 601$137,878.67 The balances represent the cash balance as of 6/30/15. Remaining Unallocated Sales Tax through 2018 Wobegon Trail Extension200,000.00CR133/College Ave Sidewalk Project688,729.82Community Center \[Colts Academy, includes int\]2,766,705.33Facilities3,131,211.89 43,358.50585.8033,284.14 CR2/3 Trail Extension Phase I446,513.37 CR2 Trail Extension Phase II/III665,076.40 Facility Planning364,506.56 Wobegon Center Upgrades13,886.185,309,418.85Parks and Trails2,177,621.16Other585.805,309,418.8511,000,000 8,272.757,500.00 71,000.0 Transportation- 0 Est. Remaining Millstream Park Shelter Plans Est. Remaining Colts Academy cash funded General Fund/Rec Center Fund Transfer General Fund/Rec Center Fund TransferEst. Remaining Wobegon Trail ExtensionEst. Remaining Wobegon Trail Extension $ Est. Remaining CR 2 Trail, Phase II/III Remaining Sales Tax through 2018 Other earnings/transferred/expensed Fund Balance as of June 30, 2015 Projects funded (includes estimated remaining): Sales Tax Extension approved Nov. 2014 Spent as of June 30, 2015 Projected Sales TaxProjected Sales Tax Sales Tax Collected Sales Tax received Parks and Rec survey/system plan Sales Tax Spent Millstream Park Shelter Planning Anticipated revenue 2019-2038: Centennial Park Swingset quatics Facility Design Parks Boundary Survey (661,000.00)(200,000.00)(496,000.00) (1,132,511.72)(2,640,009.34)(1,132,511.72)(56,800.00) (7,500.00) Board Stipends 43,278.082,696.672,640,009.341,553,472.373,372,754.00732,744.663,372,754.0043,278.08862,220.36 A 193,167.86467,180.27687,612.54962,642.771,133,318.88Balance as of December 31, 2012 (audited)1,264,824.39Balance as of December 31, 2013 (audited)1,272,767.431,486,280.361,553,472.37 1,297,612.6 St. Joseph 1/2 Cent Sales Tax Committee 4 - Summary Treasurer's Report - Fund 200 (110,935.71)2012 CR 2/3 trail extension(330,603.68)2013 Facility Planning(104,427.23)2013 CR 133/College Ave Sidewalk(171,585.40)2014 Facility Planning(149,143.62) (420.00)(165.80)2012 CR 133/College Ave trail extension(16,831.32)2013 CR 2/3 trail extension-Phase I(80,237.25)2013 CR 2 Trail Extension - Phase II(1,538.15)2013 CR 2 Trail Extension - Phase III(566.10)2013 Wobegon Center Upgrades(13,886.18)2014 CR 2/3 trail extension-Phase I(14,208.62)2014 CR 2 Trail Extension - Phase II/III(1,813.15)2014 CR 133/College Ave Sidewalks(1,434.80)( 159.00) (1,279.26)(42,079.24)(8,272.75)2010 Transfer Interest Earnings to Water Fund(86,436.20)(33,284.14)(21,463.82)(2,878.30)(82.00)(14,200.00)(11,602.00) 190,471.2212,081.68237,927.0024,003.7321,468.30251,015.2233,184.40242,011.63270,108.8020,287.65299,571.59314,646.75360,909.002013 Transfer from Rec Center Fund - Facilities19,274.35380,113.1293,235.0 1 2,696.64 As of June 30, 2015 2011 CR 133/College Ave trail extension 2015 CR 2 Trail Extension - Phase II/III 2007 Transfer from the General Fund Balance as of December 31, 2006 (audited)Balance as of December 31, 2007 (audited)Balance as of December 31, 2010 (audited)Balance as of December 31, 2011 (audited)Balance as of December 31, 2014 (audited) Balance as of December 31, 2008 (audited)Balance as of December 31, 2009 (audited) 2006 Sales Tax Receipts Collected2007 Sales Tax Receipts Collected2008 Sales Tax Receipts Collected2008 Parks and Recreation Survey2011 Sales Tax Receipts Collected2012 Sales Tax Receipts Collected2013 Sales Tax Receipts Collected2014 Sales Tax Receipts Collected2015 Sales Tax Receipts Collected 2009 Sales Tax Receipts Collected2010 Sales Tax Receipts Collected Balance as of June 30, 2015 (Unaudited) 2008 Park and Trail System Plan 2010 Centennial Park Swingset 2011 CMCU Building Purchase 2015 Wobegon Trail Extension 2008 Parks Boundary Survey 2011 CR 2/3 trail extension 2015 Community Center 2008 Meeting Stipends 2009 Meeting Stipends 2006 Interest Earnings2007 Interest Earnings2008 Interest Earnings 2009 Interest Earnings2010 Interest Earnings 2015 Aquatics Design Opening Fund 2006 1 Cash Balances Only Current Period: June 2015 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance Last Dim 10100 GeneralG 101-10100$1,225,721.48$448,872.37$187,772.68$746,364.81 Employee Retirement ReserveG 102-10100$46,230.00$0.00$0.00$32,676.62 Fire FundG 105-10100$549,418.86$386.61$10,481.99$524,335.35 Cable Access FeeG 108-10100$14,515.81$804.36$967.88$17,821.99 Economic DevelopmentG 150-10100$109,443.65$45,499.01$13,992.89$116,967.94 TIF 3-1 CMCUG 152-10100$0.00$0.00$250.00-$2,596.51 TIF 2-1 MillstreamG 157-10100$17,951.81$15,020.61$108.60$28,454.11 TIF 2-2 Meat MarketG 158-10100$116.36$1,387.96$46.58$1,429.80 TIF 2-3 Bayou Blues/Alley FlatG 159-10100$0.00$0.00$250.00-$4,262.70 State Collected Sales TaxG 200-10100$1,426,025.77$36,132.38$25,606.25$1,553,472.37 Park DedicationG 205-10100$40,028.63$3,463.72$244.34$43,129.71 Charitable GamblingG 215-10100$3,210.53$4,812.94$835.32$6,868.29 Revolving Loan FundG 250-10100$39,469.77$685.66$600.08$4,984.64 2009A CrossoverRefunding BoG 318-10100$345,914.75$86,033.64$1,294.54$419,210.27 2005 City Hall refundedG 322-10100$581.61$33,473.94$3.34$32,891.30 2011A Refunding Fire HallG 331-10100$73,376.77$8,712.25$302.83$90,750.49 2010B Refundin \[Hill/Clover\]G 333-10100$254,235.21$34,791.44$962.15$288,433.70 2011A CO Refund\[Interior St\]G 338-10100$148,500.78$35,394.24$531.02$176,201.06 2009B GO CIP BondsG 343-10100$7,574.84$20,520.27$24.04$24,065.00 2010 Equipment CertificatesG 344-10100$5,520.66$9,329.62$20.61$14,519.59 2010B Street Impr \[16th Ave\]G 345-10100$224,865.13$8,901.32$843.01$227,215.10 2011A Pumper Truck CertificatG 346-10100$2,947.05$7,974.15$30.21$17,594.00 2011A GO CIP Bonds\[roof/gar\]G 347-10100$13,702.76$148.19$706.66$13,482.24 2013 Street Improve BondsG 348-10100$191,194.43$5,475.53$652.67$175,313.95 2013 Equipment CertificatesG 349-10100$2,615.56$19,971.60$8.15$20,699.00 2014 Street Impr \[ParkTerraceG 350-10100$196,802.24$18,852.93$2,698.52$208,005.04 2015 Street\[Clinton/Northland\]G 351-10100$0.00$61,329.65$44.82$129,082.48 2015 Equipment CertificatesG 352-10100$0.00$0.00$0.00$0.00 2015 Abatement Bonds\[KenneG 353-10100$0.00$0.00$2,200.00-$2,200.00 Debt Service ReliefG 390-10100$253,091.43$7,162.82$0.00$261,090.20 2011CIP Bonds\[Roof/PD garagG 447-10100$174,042.45$0.00$0.00$174,042.45 2014 Imp Park TerraceG 450-10100$545,623.98$0.00$795.00$474,497.56 2015 Street\[Clinton/Northland\]G 451-10100$0.00$0.00$76.50-$32,103.09 2015 Equipment CertificatesG 452-10100$0.00$0.00$0.00$0.00 Capital OutlayG 490-10100$241,034.30$25,192.30$0.00$239,761.53 WAC FundG 501-10100$263.31$13.23$122.21$49,118.60 SAC FundG 502-10100$271,369.27$117.98$1,089.75$297,072.58 Water FundG 601-10100$19,928.22$93,046.12$36,491.66$137,878.67 Sewer FundG 602-10100$299,409.43$102,037.79$15,262.47$2,124.39 Refuse CollectionG 603-10100$225,832.27$36,152.56$27,897.54$232,276.16 Storm Water UtilityG 651-10100$225,324.75$11,508.09$4,700.04$246,341.31 Street Light UtilityG 652-10100$8,552.20$7,260.56$3,661.17$16,915.05 Last Dim 10100$7,204,436.07$1,190,465.84$341,575.52$7,003,925.05 Last Dim 10200 GeneralG 101-10200$275.00$0.00$0.00$275.00 Last Dim 10200$275.00$0.00$0.00$275.00 $7,204,711.07$1,190,465.84$341,575.52$7,004,200.05 Council Month End Revenue Summary Current Period: June 2015 2015June2015 FUNDFUND DescrYTD Budget2015 AmtYTD Amt 101General$2,458,040.00$444,698.34$655,232.54 102Employee Retirement Reserve$67,930.00$0.00$0.00 105Fire Fund$290,805.00-$1,588.38$127,324.30 108Cable Access Fee$7,450.00$675.36$3,444.90 150Economic Development$95,595.00$45,177.63$102,435.37 152TIF 3-1 CMCU$0.00$0.00$0.00 157TIF 2-1 Millstream$0.00$14,957.33$15,097.22 158TIF 2-2 Meat Market$0.00$1,386.70$1,387.18 159TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00 200State Collected Sales Tax$0.00$36,132.38$93,235.01 205Park Dedication$10,100.00$3,313.38$3,653.56 215Charitable Gambling$0.00$4,789.53$4,813.85 250Revolving Loan Fund$8,380.00$573.81$12,685.81 3182009A CrossoverRefunding Bonds$272,020.00$84,739.10$87,460.75 3222005 City Hall refunded$91,600.00$33,470.60$34,373.62 3312011A Refunding Fire Hall$49,750.00$8,409.42$19,394.06 3332010B Refundin \[Hill/Clover\]$96,340.00$33,829.29$41,923.81 3382011A CO Refund\[Interior St\]$126,135.00$34,863.22$35,873.55 3432009B GO CIP Bonds$56,100.00$20,496.23$20,539.39 3442010 Equipment Certificates$25,600.00$9,309.01$9,345.47 3452010B Street Impr \[16th Ave\]$48,075.00$8,058.31$9,802.72 3462011A Pumper Truck Certificate$45,810.00$7,943.94$17,598.29 3472011A GO CIP Bonds\[roof/gar\]$240.00-$558.47$897.85 3482013 Street Improve Bonds$9,000.00$4,822.86$6,266.44 3492013 Equipment Certificates$55,250.00$19,963.45$19,964.02 3502014 Street Impr \[ParkTerrace\]$7,625.00$16,154.41$32,531.06 3512015 Street\[Clinton/Northland\]$0.00$61,284.83$129,082.48 3522015 Equipment Certificates$0.00$0.00$0.00 3532015 Abatement Bonds\[Kennedy\]$0.00$0.00$0.00 390Debt Service Relief$0.00$7,162.82$7,162.82 4502014 Imp Park Terrace$0.00$0.00$0.00 4512015 Street\[Clinton/Northland\]$0.00$0.00$0.00 4522015 Equipment Certificates$0.00$0.00$0.00 490Capital Outlay$69,760.00$25,192.30$46,392.30 501WAC Fund$424,900.00-$108.98$43,446.73 502SAC Fund$2,500.00-$971.77$21,977.29 601Water Fund$1,404,670.00$85,327.49$240,725.16 602Sewer Fund$1,416,695.00$101,903.45$273,346.32 603Refuse Collection$304,285.00$29,575.78$98,689.35 651Storm Water Utility$126,990.00$10,613.69$21,571.38 652Street Light Utility$56,765.00$7,124.73$18,911.71 2 Council Month End Revenue Summary Current Period: June 2015 2015June2015 FUNDFUND DescrYTD Budget2015 AmtYTD Amt $7,628,410.00$1,158,721.79$2,256,586.31 Council Month End Revenue -General Fund Current Period: June 2015 2015June2015 FUNDFUND DescrSOURCE DescrYTD Budget2015 AmtYTD Amt FUND 101 General 101GeneralCurrent Ad Valorem Taxes$1,065,885.00$406,455.70$406,455.70 101GeneralSpecial Levy- City St. Joe$0.00$36.69$36.69 101GeneralState Sales Tax$0.00-$17.70$23.60 101GeneralGas Franchise$29,000.00$0.00$8,035.38 101GeneralElectric Franchise$54,000.00$1,788.57$17,165.62 101GeneralBeer$575.00$1,260.00$1,945.00 101GeneralLiquor$22,260.00$15,200.00$20,200.00 101GeneralOutdoor Liquor Permit$2,500.00$0.00$1,250.00 101GeneralGambling Permits$200.00$0.00$310.00 101GeneralAmusement/Hunting Permit$1,300.00$200.00$225.00 101GeneralExcavation Permit$500.00$250.00$950.00 101GeneralCigarette License$525.00$0.00$0.00 101GeneralCable Franchise Fee$30,500.00$1,309.76$10,883.09 101GeneralBuilding Permits$45,000.00$5,246.45$73,003.17 101GeneralAnimal License$3,150.00$305.00$2,695.00 101GeneralRental Housing Registration$23,000.00$6,131.50$6,211.50 101GeneralFederal Grants - Other$5,000.00$243.08$243.08 101GeneralState Grants and Aids$930.00$0.00$0.00 101GeneralLocal Government Aid$902,580.00$0.00$0.00 101GeneralPERA Rate Increase Aid$1,540.00$0.00$0.00 101GeneralPolice Training Reim$3,500.00$780.00$780.00 101GeneralState Municipal Funds Aid$42,545.00$0.00$24,086.50 101GeneralState Police Aid$50,000.00$0.00$0.00 101GeneralOther Grants/Aids$250.00$0.00$0.00 101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00 101GeneralCounty Grants - Road Maint.$7,745.00$0.00$0.00 101GeneralZoning and Subdivision Fee$1,000.00$0.00$0.00 101GeneralLand Use Deposit Fee$4,000.00$0.00$3,000.00 101GeneralSale of Maps and Publications$50.00$4.00$30.42 101GeneralAssessments Search$2,500.00$180.00$2,430.00 101GeneralSpecial Hearing$5,000.00$800.00$2,100.00 101GeneralAdministration Reimb$11,400.00$0.00$49.56 101GeneralWeed Cutting$1,000.00$0.00$0.00 101GeneralPark Fees$5,500.00$320.00$4,040.00 101GeneralBall Field Donation$250.00$0.00$0.00 101GeneralSchneider Field Rental$1,500.00$100.00$100.00 101GeneralRents and Royalties$0.00$0.00$0.00 101GeneralKennel Fees$700.00$0.00$170.00 101GeneralCounty Fines$25,000.00$2,709.25$12,190.61 101GeneralPolicy Fines$22,000.00$245.00$5,223.00 101GeneralAccident Report Fee$1,000.00$154.50$733.50 101GeneralSeized Property$500.00$0.00$9,040.00 Council Month End Revenue -General Fund Current Period: June 2015 2015June2015 FUNDFUND DescrSOURCE DescrYTD Budget2015 AmtYTD Amt 101GeneralSpecial Assessments$2,000.00$1,889.25$1,889.25 101GeneralInterest Earnings$18,500.00-$3,025.80$5,622.56 101GeneralInterest Charges$100.00$0.00$0.00 101GeneralCo-op Dividend - LMCIT$18,000.00$0.00$0.00 101GeneralWater Tower Antenna Lease$3,755.00$457.97$1,861.56 101GeneralAdvertising$2,000.00$0.00$430.00 101GeneralContributions - General$1,500.00$0.00$20,000.00 101GeneralContributions - Parks$1,000.00$740.12$943.56 101GeneralSurplus Property$0.00$0.00$0.00 101GeneralReimbursement$27,300.00$935.00$5,879.19 101GeneralTransfers from Other Funds$0.00$0.00$0.00 FUND 101 General$2,458,040.00$444,698.34$655,232.54 FUND 102 Employee Retirement Reserve 102Employee Retirement ResInterest Earnings$500.00$0.00$0.00 102Employee Retirement ResTransfers from Other Funds$67,930.00$0.00$0.00 FUND 102 Employee Retirement Reserve$68,430.00$0.00$0.00 FUND 108 Cable Access Fee 108Cable Access FeeCable Franchise Fee$7,450.00$675.36$3,444.90 108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00 FUND 108 Cable Access Fee$7,450.00$675.36$3,444.90 FUND 150 Economic Development 150Economic DevelopmentCurrent Ad Valorem Taxes$94,595.00$34,554.40$34,554.40 150Economic DevelopmentFederal Grants - Other$0.00$10,909.00$58,210.00 150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00 150Economic DevelopmentDEED Housing Reimbursement$0.00$0.00$0.00 150Economic DevelopmentInterest Earnings$1,000.00-$285.77$536.97 150Economic DevelopmentTransfers from Other Funds$0.00$0.00$9,134.00 FUND 150 Economic Development$95,595.00$45,177.63$102,435.37 FUND 152 TIF 3-1 CMCU 152TIF 3-1 CMCUTax Increment$0.00$0.00$0.00 152TIF 3-1 CMCUInterest Earnings$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat 159TIF 2-3 Bayou Blues/Alley Tax Increment$0.00$0.00$0.00 159TIF 2-3 Bayou Blues/Alley Interest Earnings$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00 $2,629,515.00$490,551.33$761,112.81 Council Month End Revenue -Enterprise Funds Current Period: June 2015 FUND2015June2015 FUNDDescrSOURCE DescrYTD Budget2015 AmtYTD Amt FUND 601 Water Fund 601Water FundConnection/Reconnection fees$200.00$0.00$80.00 601Water FundTransfers from Other Funds$442,000.00$0.00$0.00 601Water FundContributed Revenue$0.00$0.00$0.00 601Water FundMDS Test Fee$11,645.00$1,149.12$3,503.68 601Water FundWater Line Charge$293,135.00$28,846.83$88,026.24 601Water FundCurrent Ad Valorem Taxes$43,500.00$15,709.31$15,709.31 601Water FundPenalties and Forfeited Disc$8,000.00$466.85$3,088.42 601Water FundUndesignated Funds$0.00$2,515.38-$2,526.00 601Water FundBulk Water$1,500.00$425.40$959.10 601Water FundSpecial Assessments$200.00$5.93-$10,821.09 601Water FundWater Meter$5,000.00$100.00$3,630.00 601Water FundState Sales Tax$0.00$117.28-$279.49 601Water FundRate Class One$522,860.00$38,127.57$115,351.55 601Water FundInterest Earnings$41,600.00-$6,257.84$7,359.70 601Water FundAmortization of Bond Premium$0.00$0.00$0.00 601Water FundWater Tower Antenna Lease$35,030.00$4,121.66$16,753.74 601Water FundSurplus Property$0.00$0.00$0.00 601Water FundReimbursement$0.00$0.00-$110.00 FUND 601 Water Fund$1,404,670.00$85,327.49$240,725.16 FUND 602 Sewer Fund 602Sewer FundSanitary Sewer Service$423,030.00$53,537.48$136,982.01 602Sewer FundSpecial Assessments$200.00$4.45-$293.15 602Sewer FundInterest Earnings$5,075.00-$90.76$388.13 602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00 602Sewer FundContributions - General$0.00$0.00$0.00 602Sewer FundSurplus Property$0.00$0.00$0.00 602Sewer FundOther Governmental Unit$2,900.00$0.00$0.00 602Sewer FundReimbursement$0.00$0.00$0.00 602Sewer FundPenalties and Forfeited Disc$4,675.00$360.05$2,063.62 602Sewer FundSewer Line Charge$344,080.00$48,092.23$134,205.71 602Sewer FundTransfers from Other Funds$636,735.00$0.00$0.00 602Sewer FundContributed Revenue$0.00$0.00$0.00 FUND 602 Sewer Fund$1,416,695.00$101,903.45$273,346.32 FUND 603 Refuse Collection 603Refuse CollecRefuse Collection Charges$277,665.00$26,712.87$82,192.67 603Refuse CollecContributions - General$0.00$0.00$0.00 603Refuse CollecInterest Earnings$4,000.00-$759.86$1,013.35 603Refuse CollecPenalties and Forfeifted Disc$5,500.00$458.04$2,677.31 603Refuse CollecContributed Revenue$0.00$0.00$0.00 603Refuse CollecLicenses & Permits$16,920.00$1,980.00$15,610.00 603Refuse CollecState Sales Tax$0.00$1,174.54-$2,580.82 603Refuse CollecSpecial Assessments$200.00$10.19-$223.16 FUND 603 Refuse Collection$304,285.00$29,575.78$98,689.35 FUND 651 Storm Water Utility 651Storm Water Development Fee$20,000.00$0.00$0.00 651Storm Water Penalties and Forfeifted Disc$2,030.00$115.10$648.50 651Storm Water Transfers from Other Funds$0.00$0.00$0.00 651Storm Water Rate Class One$98,165.00$9,846.68$30,013.96 651Storm Water Contributed Revenue$0.00$0.00$0.00 651Storm Water Reimbursement$0.00$0.00$0.00 Council Month End Revenue -Enterprise Funds Current Period: June 2015 FUND2015June2015 FUNDDescrSOURCE DescrYTD Budget2015 AmtYTD Amt 651Storm Water Special Assessments$4,795.00$1,449.48-$10,120.15 651Storm Water Interest Earnings$2,000.00-$797.57$1,029.07 FUND 651 Storm Water Utility$126,990.00$10,613.69$21,571.38 FUND 652 Street Light Utility 652Street Light UTransfers from Other Funds$0.00$0.00$0.00 652Street Light USpecial Assessments$50.00$11.56-$21.76 652Street Light UInterest Earnings$25.00-$40.19$40.75 652Street Light URate Class One$56,490.00$7,101.12$18,685.82 652Street Light UPenalties and Forfeited Disc$200.00$52.24$206.90 FUND 652 Street Light Utility$56,765.00$7,124.73$18,911.71 $3,309,405.00$234,545.14$653,243.92 Council Month End Expenditure - Summary Current Period: June 2015 2015June2015 DescriptionYTD Budget2015 Amt YTD Amt General$2,458,040.00$181,297.93$1,096,016.27 Employee Retirement Reserve$68,430.00$0.00$13,553.38 Fire Fund$300,805.00$8,507.00$68,675.10 Cable Access Fee$2,010.00$838.88$838.88 Economic Development$130,595.00$13,671.51$88,489.92 TIF 3-1 CMCU$0.00$250.00$2,596.51 TIF 2-1 Millstream$570.00$45.32$4,624.64 TIF 2-2 Meat Market$570.00$45.32$56.47 TIF 2-3 Bayou Blues/Alley Flat$0.00$250.00$4,262.70 State Collected Sales Tax$2,524,000.00$25,606.25$26,043.00 Park Dedication$63,845.00$94.00$609.97 Charitable Gambling$0.00$811.91$1,162.91 Revolving Loan Fund$0.00$488.23$47,234.23 2009A CrossoverRefunding Bon$360,525.00$0.00$15,125.00 2005 City Hall refunded$94,385.00$0.00$2,362.50 2011A Refunding Fire Hall$74,750.00$0.00$2,200.00 2010B Refundin \[Hill/Clover\]$142,250.00$0.00$8,473.75 2011A CO Refund\[Interior St\]$144,630.00$0.00$9,615.00 2009B GO CIP Bonds$63,200.00$0.00$4,245.00 2010 Equipment Certificates$31,125.00$0.00$412.50 2010B Street Impr \[16th Ave\]$65,955.00$0.00$7,827.50 2011A Pumper Truck Certificate$46,310.00$0.00$2,980.00 2011A GO CIP Bonds\[roof/gar\]$23,320.00$0.00$1,460.00 2013 Street Improve Bonds$39,970.00$0.00$4,835.00 2013 Equipment Certificates$54,600.00$0.00$2,150.00 2014 Street Impr \[ParkTerrace\]$53,835.00$0.00$26,917.50 2015 Street\[Clinton/Northland\]$0.00$0.00$0.00 2015 Equipment Certificates$0.00$0.00$0.00 2015 Abatement Bonds\[Kenned$0.00$2,200.00$2,200.00 Debt Service Relief$30,000.00$0.00$0.00 2011CIP Bonds\[Roof/PD garag$0.00$0.00$0.00 2014 Imp Park Terrace$0.00$795.00$3,801.83 2015 Street\[Clinton/Northland\]$0.00$76.50$32,103.09 2015 Equipment Certificates$153,288.24$0.00$0.00 Capital Outlay$69,760.00$0.00$47,665.07 WAC Fund$405,000.00$0.00$0.00 SAC Fund$636,735.00$0.00$0.00 Water Fund$1,560,885.00$28,773.03$231,223.27 Sewer Fund$1,791,695.00$15,128.13$337,921.86 Refuse Collection$312,485.00$21,320.76$127,249.72 Storm Water Utility$208,565.00$3,805.64$30,892.25 Street Light Utility$56,765.00$3,525.34$18,607.50 Council Month End Expenditure - Summary Current Period: June 2015 2015June2015 DescriptionYTD Budget2015 Amt YTD Amt $11,968,898.24$307,530.75$2,274,432.32 Council Month End Expenditure - General Fund Current Period: June 2015 2015June2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt FUND 101 General GeneralCouncil$58,895.00$10,446.09$23,210.96 GeneralLegislative Committees$5,595.00$420.00$1,855.00 GeneralOrdinance & Proceedings$1,600.00$0.00$492.49 GeneralMayor$11,005.00$905.71$4,132.98 GeneralElections$1,000.00$0.00$1,162.50 GeneralGeneral Adminstration$234,870.00$15,332.92$104,828.29 GeneralFinance$122,385.00$9,766.37$58,167.50 GeneralAudit Service$27,000.00$0.00$26,450.00 GeneralAssessing$23,500.00$0.00$0.00 GeneralCity Attorney$16,000.00$13.50$3,591.25 GeneralPlanning and Zoning$8,140.00$108.00$1,365.43 GeneralGeneral Government$20,345.00$1,408.37$11,754.73 GeneralCity Offices$32,655.00$3,172.35$15,117.08 GeneralFacilites and Planning$0.00$0.00$0.00 GeneralCable Access$11,095.00$830.60$4,579.00 GeneralCrime Control & Investigation$956,640.00$82,514.71$418,773.62 GeneralPolice Training$11,750.00$210.08$7,581.39 GeneralCommunication Service$11,720.00$760.19$5,346.57 GeneralAutomotive Services$54,200.00$2,248.06$15,510.71 GeneralBuilding Inspec. Admistration$92,000.00$7,500.00$39,059.25 GeneralEmergency Management$1,280.00$10.58$817.11 GeneralSignal Lights CSAH 75$0.00$90.77$0.00 GeneralAnimal Control$965.00$0.00$324.50 GeneralStreet Maintanence$258,795.00$10,945.57$86,965.48 GeneralIce & Snow Removal$106,160.00$0.00$35,356.95 GeneralEngineering Fee$28,000.00$0.00$21,494.26 GeneralStreet Cleaning$13,385.00$339.24$9,948.07 GeneralSkate Park and Ice Rink$5,345.00$44.02$2,552.86 GeneralBall Park$1,750.00$270.61$809.56 GeneralMaintenance Shop$21,915.00$2,644.24$12,351.61 GeneralPark Areas$215,480.00$31,315.95$119,596.30 GeneralCommunity Center$0.00$0.00$35.00 GeneralCommunity Support$0.00$0.00$0.00 GeneralOther Financing Uses$0.00$0.00$0.00 GeneralFire Protection$104,570.00$0.00$62,785.82 FUND 101 General$2,458,040.00$181,297.93$1,096,016.27 FUND 102 Employee Retirement Reserve Employee Retirement ReservGeneral Adminstration$68,430.00$0.00$13,553.38 FUND 102 Employee Retirement Reserve$68,430.00$0.00$13,553.38 FUND 108 Cable Access Fee Cable Access FeeCable Access$2,010.00$838.88$838.88 Council Month End Expenditure - General Fund Current Period: June 2015 2015June2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt FUND 108 Cable Access Fee$2,010.00$838.88$838.88 FUND 150 Economic Development Economic DevelopmentEconomic Development Authority$130,595.00$13,671.51$80,538.92 Economic DevelopmentOther Financing Uses$0.00$0.00$7,951.00 FUND 150 Economic Development$130,595.00$13,671.51$88,489.92 FUND 152 TIF 3-1 CMCU TIF 3-1 CMCUEconomic Development Authority$0.00$250.00$1,579.51 TIF 3-1 CMCUOther Financing Uses$0.00$0.00$1,017.00 FUND 152 TIF 3-1 CMCU$0.00$250.00$2,596.51 FUND 159 TIF 2-3 Bayou Blues/Alley Flat TIF 2-3 Bayou Blues/Alley FlEconomic Development Authority$0.00$250.00$412.51 TIF 2-3 Bayou Blues/Alley FlOther Financing Uses$0.00$0.00$3,850.19 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$250.00$4,262.70 FUND 490 Capital Outlay Capital OutlayGeneral Adminstration$2,750.00$0.00$2,194.97 Capital OutlayCrime Control & Investigation$3,000.00$0.00$0.00 Capital OutlayCommunication Service$5,360.00$0.00$2,467.50 Capital OutlayAutomotive Services$8,500.00$0.00$3,000.00 Capital OutlayEmergency Management$2,000.00$0.00$0.00 Capital OutlayStreet Maintanence$11,750.00$0.00$0.00 Capital OutlayIce & Snow Removal$7,000.00$0.00$0.00 Capital OutlayStreet Cleaning$0.00$0.00$0.00 Capital OutlayMaintenance Shop$7,000.00$0.00$6,205.24 Capital OutlayPark Areas$22,400.00$0.00$33,797.36 Capital OutlayOther Financing Uses$0.00$0.00$0.00 FUND 490 Capital Outlay$69,760.00$0.00$47,665.07 $2,728,835.00$196,308.32$1,253,422.73 Council Month End Expense - Enterprise Funds Current Period: June 2015 2015June2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt FUND 601 Water Fund Water FundBond Payment (P & I)$690,120.00$0.00$66,718.75 Water FundOther Financing Uses$45,000.00$0.00$0.00 Water FundPower and Pumping$21,950.00$161.08$1,069.18 Water FundPurification-Plant 1$42,380.00$2,640.92$9,807.69 Water FundPurification-Plant 2$76,895.00$10,551.95$40,281.65 Water FundDistribution$10,000.00$0.00$0.00 Water FundWellhead Protection$2,000.00$0.00$0.00 Water FundStorage-Tower 1$15,835.00$1,128.98$2,029.79 Water FundWater Maintenance$218,670.00$11,824.89$95,085.46 Water FundAdministration and General$38,035.00$2,465.21$16,230.75 Water FundDepreciation Expense$400,000.00$0.00$0.00 FUND 601 Water Fund$1,560,885.00$28,773.03$231,223.27 FUND 602 Sewer Fund Sewer FundBond Payment (P & I)$227,020.00$0.00$24,968.75 Sewer FundOther Financing Uses$55,050.00$0.00$0.00 Sewer FundSanitary Sewer Maintenanc$237,440.00$7,583.23$70,665.18 Sewer FundLift Station-Baker Street$9,415.00$395.24$1,349.32 Sewer FundLift Station-Ridgewood/DBL$3,425.00$393.34$1,188.94 Sewer FundLift Station-Northland$52,205.00$114.26$828.58 Sewer FundLift Station-CR 121$4,935.00$137.51$1,067.83 Sewer FundLift Station-Main$787,705.00$3,304.54$220,571.27 Sewer FundAdministration and General$39,500.00$3,200.01$17,281.99 Sewer FundDepreciation Expense$375,000.00$0.00$0.00 FUND 602 Sewer Fund$1,791,695.00$15,128.13$337,921.86 FUND 603 Refuse Collection Refuse CollectioWaste Collection$305,985.00$21,320.76$127,249.72 Refuse CollectioOther Financing Uses$0.00$0.00$0.00 Refuse CollectioDepreciation Expense$6,500.00$0.00$0.00 FUND 603 Refuse Collection$312,485.00$21,320.76$127,249.72 FUND 651 Storm Water Utility Storm Water UtiOther Financing Uses$18,250.00$0.00$0.00 Storm Water UtiAdministration and General$11,800.00$1,039.40$6,005.70 Storm Water UtiStorm Water Maintenance$78,515.00$2,766.24$24,886.55 Storm Water UtiDepreciation Expense$100,000.00$0.00$0.00 FUND 651 Storm Water Utility$208,565.00$3,805.64$30,892.25 FUND 652 Street Light Utility Street Light UtiliStreet Lighting$56,765.00$3,525.34$18,607.50 Street Light UtiliOther Financing Uses$0.00$0.00$0.00 FUND 652 Street Light Utility$56,765.00$3,525.34$18,607.50 Council Month End Expense - Enterprise Funds Current Period: June 2015 2015June2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt $3,930,395.00$72,552.90$745,894.60 ADM-1 239,486.4979,833.2381,533.23 23,953.0422,353.463,953.364,859.685,000.0017,146.6377,266.179,539.8227,629.387,630.0011,261.5910,504.956,412.6172,978.3564,302.113,750.0011,000.0010,000.001,500.0021,250.0054,331.6218,900.0049,702.87 4,749.891,700.00 471,264.24 ReserveTransferred/SpentBudgetRemaining Balance 18,860.0016,900.0049,150.0033,500.0033,500.00 1,000.002,000.005,000.008,750.003,000.005,360.004,000.002,000.002,500.002,000.006,000.002,000.004,750.007,000.007,000.003,500.002,000.00 750.00 110,260.00 2015 (8,640.14)(8,640.14) 6/30 33,797.3640,084.60 1,162.501,290.004,325.352,467.503,000.005,467.506,205.24 904.97967.88 82.00 41,237.31 20152015 6/30through Summary 2,898.542,898.5424,086.5021,200.0045,286.504,000.004,000.00 52,185.04 Availablethrough BalanceGrant 2014 Plan Expenditures 24,115.5420,353.464,858.335,399.6815,215.9769,942.986,539.8224,736.883,630.0012,261.598,004.954,412.6159,585.8534,297.611,750.006,250.0010,000.001,500.0014,250.0053,536.8615,400.0045,400.232,749.8918 5,134.591,700.0050,973.3752,673.37 367,336.79 4, Improvement 2015 December 30, June Capital Total Public Works CIPTotal EDA CIP Total Administration CIP Total Police CIP adopted 490-45201-580Maintenance Shop Equipment of Capital 101-41910-300Planning Document Updates Street Sweeping490-43220-580Street Sweeping Equipment Police-Communications490-42151-580Communication Equipment As Snow Removal490-43125-580Snow Removal Equipment 490-41430-570Administration Equipment 2015 490-41430-581Computer Replacement Final Equipment 490-43120-550Street Motor Vehicles Fund 490-45202-550Parks Motor Vehicles 101-43120-530/230Street Improvements490-43120-530Street Improvements Emergency Services490-42500-580Emergency ServicesParks490-45202-530Parks Improvements 101-41410-xxxElection Equipment 490-41430-582Computer SoftwarePolice - Automotive490-42152-580Vehicle/Equipment150-46500-582Computer Software Total General Capital Improvements Police - General490-42120-580Police Equipment 490-43120-580Street Equipment 108-41950-580Cable Equipment 490-45202-580Parks Equipment General Police - Automotive490-42152-581Squad Laptops 150-46500-588EDA Programs Police - Automotive490-42152-550Police Squads Code Budget DepartmentAccount Project AdministrationAdministrationAdministrationAdministration EDA Software Cable Access EDA Projects Maintenance Election StreetsStreetsStreetsStreets ParksParks ΛЊͲБЉЌ͵АЏΜ(1,803.76)ΛЋВЏ͵ЉЎΜ ЊͲЌЊЋ͵ЎВ 17,562.40 ЍͲЉЉЉ͵ЉЉЋͲЏЏЎ͵ЊЎ 46,673.40 ЊͲЎЋА͵ЎАЊВͲЋЏЏ͵ВЋЊВͲЍВЊ͵ВЋБͲЍЎЉ͵ЉЉ 1,312.59 ЊАͲЎЏЋ͵ЍЉЌЍͲЋЎВ͵ЎБЎЏͲБЋЌ͵ААЍАͲЋЎЉ͵ЉЉЍБͲЉЉЉ͵ЉЉЊЋͲЎЉЊ͵ЉЉЋЋͲЋВЍ͵ЉЎ 224,832.35 ЍЍͲЉЉБ͵ЋЎ 1,527.5747,208.84337,313.39 6/30Available BudgetAdjustmentsSpentReserve Funds АͲЋЌЎ͵ЉАЏͲЊЉЏ͵ЎБЊЌͲЎЊЉ͵ЉЉ 13,510.0026,851.65 7,235.076,106.58 YearDescriptionFunds201520152015 of AvailableGrants/as 217.97 ЊͲЉЉЉ͵ЉЉ ЋЊА͵ВАЏЊЊ͵ВБ 611.98 1,000.001,829.95 6/30 of as 500.00 ЋͲЉЉЉ͵ЉЉ 200.00 ЊͲЎЉЉ͵ЉЉЊͲЉЉЉ͵ЉЉ ЊͲЉЎЉ͵ЉЉ 1,050.00 ЎЉЉ͵ЉЉ 2,000.00 ЎЉЉ͵ЉЉЎͲЉЉЉ͵ЉЉАͲЎЉЉ͵ЉЉЊЉͲЉЉЉ͵ЉЉЊЉͲЉЉЉ͵ЉЉЎͲЉЉЉ͵ЉЉЋͲЉЉЉ͵ЉЉЎͲЉЉЉ͵ЉЉ 45,000.00 ЊЉͲЉЉЉ͵ЉЉЎЉЉ͵ЉЉ 10,500.00 ЋЉЉ͵ЉЉЎЉЉ͵ЉЉ 3,000.0062,250.00 ΛАВЏ͵ЉЎΜ 262.59 АͲЍЎЉ͵ЉЉ ЋЏЋ͵ЎВЍͲАЊЌ͵ЌЍ 4,713.34 ЊЎͲЎЏЋ͵ЍЉ 15,562.40 ЋВͲЋЎВ͵ЎБЍВͲЌЋЌ͵ААЌАͲЋЎЉ͵ЉЉЌБͲЉЉЉ͵ЉЉАͲЎЉЊ͵ЉЉЋͲЉЉЉ͵ЉЉЋЋͲАББ͵ЏЎЌЍͲЉЉБ͵ЋЎЋͲЊЏЎ͵ЊЎ 36,173.40 ЊͲЌЋА͵ЎА 1,327.57 ЌЉͲЋАЏ͵ВЋЊБͲВВЊ͵ВЋ 56,718.84300,085.09 185,326.95 12/31/2014 Reserve 1996/2005Extrication Equip2007800 MHz Radios n/aBuilding Repairs n/aTurnout Gear/TV 2001Ladder Truck #2 n/aReplacementn/aReplacementn/aReplacement 2012Pumper Truck 105-42210-581/582Fire AdministrationComputer Hardware/Software2010/20113 Computers1997Grass Rig #3 2012Rescue Van 2011Sealcoating 20126 Wheeler 1999Tanker #4 2013Air Packs 105-42280-530Fire Station & BuildingImprovements other than Buildin2008Painting Purchased Building Hardware/Software than Firefighter EquipmentFirefighter EquipmentFirefighter EquipmentFirefighter EquipmentFirefighter EquipmentFirefighter EquipmentFirefighter EquipmentFirefighter Equipment other 105-42280-530Fire Station & BuildingEquipment Reserve105-42280-530Fire Station & BuildingEquipment Reserve Equipment Reserve Object Other Equipment105-42250-580Fire CommunicationOther Equipment105-42250-580Fire CommunicationOther Equipment105-42270-580Medical ServicesOther Equipment Improvements Equipment Reserve Equipment Computer Department Equipment Adopted December 4, 2014 Plan Equipment Equipment Budget Building Improvement Communications Administration Other Services Capital Fire CodeDepartment & FightingFightingFighting Station CǒƓķ Joseph Medical 2015 Capital 105-42220-584Fire Fighting105-42220-585Fire Fighting 105-42220-580Fire Fighting105-42220-585Fire Fighting105-42220-585Fire Fighting105-42220-585Fire Fighting105-42220-585Fire Fighting105-42220-585Fire Fighting105-42220-585Fire Fighting105-42220-585Fire Fighting CźƩĻ FireFireFireFireFireFire St. TotalTotalTotalTotalTotalTotalTotal LƒƦƩƚǝĻƒĻƓƷ /ğƦźƷğƌ Account ƚƷğƌ FD-1401FD-1402FD-1404FD-1403FD-1405FD-1406FD-1407FD-1408FD-1409FD-1417FD-1410FD-1411FD-1412FD-1413FD-1414FD-1415FD-1416 CIP # m, Bayou l o h Pizza ng E CMCU, , Gary's d ce Sli (0.00) 1,700.0043,759.0017,047.189,210.809,816.2579,833.23229,094.00 81,533.2 3 Balance 2015 (8,640.14) (6,890.18)(1,016.70)(733.26)(8,640.14)(58,210.00) 6/30 ReserveBudgetTransfersSpent Balance201520152015 6/30through 2,086.151,748.66165.194,000.00 4,000.0 0 through ED A 18,500.0012,000.003,000.0033,500.00 33,500.0 0 Plan 2014 Expenditures Improvement Budge t 4, December (731.96)(165.19) 12/31/2014 1,700.0025,259.009,851.219,210.807,549.5150,973.37287,304.00 CIP 52,673.3 Available 7 CapitalFinal Capital Adopted 2015 2015 2013 CDBG Grant Development Fund BFA Grant/RLF Loan Program Business Demolition Program CSAH 2/3 Collection Street General Business Development/TIF Parkway Business Center Equipment Rental Conversions Let's Go Downtown Computer Software EDA-1301EDA-1302EDA-1303 CodeNumber EDA-130EDA-130EDA-130EDA-130EDA-130EDA-130 Project 778459 150-46500-582EDA150-46500-588 DepartmentAccount TOTAL EDA CIP Project A ED 64,266.44290,741.60220,864.414,000.00 6,000.00 6,000.00 30,000.00 3,750.005,000.006,250.0012,500.0027,500.009,266.4421,872.903,750.00119,102.1819,416.526,500.0042,500.0014,000.004,600.0051,600.007,400.0034,964.4112,550.0077,350.0020,000.0076,000.004,000.00 ReserveBudgetTransfersSpentAvailable Balance201520152015Balance 6/302015 (1,457.00)(3,602.10)(5,173.00) (1,457.00)(3,602.10)(5,173.00) of 12/31/2014Grants/as 19,500.00166,043.70128,300.00214,037.4112,000.001,000.004,000.00 2,000.002,500.003,750.007,500.003,750.002,000.0020,000.0010,000.0042,500.002,300.0049,300.002,200.001,000.002,000.008,000.001,000.001,000.004,000.00 Works 2,500.006,250.00 46,223.44 9,416.5214,000.0075,350.00 3,000.002,000.0030,000.00 1,750.008,750.0020,000.006,973.4425,475.001,750.0099,102.186,500.002,300.002,300.005,200.0040,137.4111,550.0012,000.0075,000.003,000.002,000.00 Public Budget 2014 Expenditures Plan 4, CIP Improvement December 2015 Final Capital Adopted Enterprise LLS Capital S Replacement 2015 Ridgewood LS Northland Plan Equipment LS (1/2)(1/2) Foamin St LS Improvements g Certificates Programme Easements/Acquire CR121 Replacemen Baker r Management Main t Enterprise SystemSystem (1/4) Televising/Root pumpspumpspumpspumpspumps Media Loader Equipment Communications Communications Meter Sweeper Roof Sampler Mapping RepairsRepairs Lighting Quality Water Lining Filter SubmersibleSubmersibleSubmersibleSubmersibleSubmersible (1/4)(1/4) #4/5 End Handheld Property Water SewerSewerSewer 112AerialStreetStreet Front TruckTruck Storm Well 2013 WTPWTPWTP 140714011408140214031403140314031403 1403140114021403140414031403140714251407 CodeNumber Project140114041406 14051410 WTWTWTWTWTWT SL WWWWWWWWWWWWWWWWWWSSSSSSSS PWPWPWPW 550580220580580580580550530300580580580580580510580580580 580580300530530 4944049490494104942049420494214945049450494504945049480494804947149470494724947349900499004990049900432304316043120 49900 DepartmentAccount 601601601601601601602602602602602602602602602602651651651651651603652450 Stormwater Project Lighting Streets Refuse Water Sewer St. City of St. Joseph Park Board Capital Improvement Budget Summary 2015 Capital Budget Adopted December 4, 2014 General Funds Balance Park Dedication Cash June 30, 2015$ 43,130 (Unaudited) Adjustments Starting Balance$ 43,130 not awarded Legacy Grant$ - Other Revenues$ 2,485 2015 General Levy$ 6,069 Potential Projects: PotentialProposed Millstream Cottages-phase 2$ 2 3,400 Jasmine Ln Extension- 10 lots$ 9 ,140 Sunset Ridge- phase 2 - 4 lots$ 2 ,000 CLC Development - 16 lots$ 8 ,000 Ending Balance for 2015$ 51,684 Projects - Budget 201420152016201720182019Total 15-19 PTR-01 (Millstream)$ - $ -$ 25,000$ - $ -$ - $ 25,000 PTR-02 (Northland)$ - $ -$ - $ - $ -$ - $ - PTR-03 (Klinefelter)$ 4,000$ 150,000$ - $ - $ -$ - $ 150,000 PTR-04 (Wobegon)$ - $ -$ - $ - $ -$ - $ - PTR-05 (Memorial)$ - $ -$ - $ - $ -$ - $ - $ - $ -$ - $ - $ -$ - $ - PTR-06 (Centennial) $ 400$ 30,400$ 400$ 400$ 4 00$ 400$ 32,000 PTR-07 (Monument) PTR-08 (Hollow)$ - $ -$ - $ - $ -$ - $ - $ 10,000$ -$ - $ - $ -$ - $ - PTR-09 (Cloverdale) PTR-10 (East Park)$ - $ 25,000$ - $ - $ -$ - $ 25,000 PTR-11 (West Park)$ - $ 25,000$ - $ - $ -$ - $ 25,000 $ 10,000$ 10,000$ 10,000$ 1 0,000$ 1 0,000$ 10,000$ 50,000 PTR-12 (Trails) $ 1,500$ 1,500$ 1,500$ 1 ,500$ 1 ,500$ 1,500$ 7,500 PTR-13 (Trees) Total$ 25,900$ 241,900$ 36,900$ 1 1,900$ 1 1,900$ 11,900$ 314,500 Projects - ActuaSpent 2014Spent 201515 Snow Town Expenses:Avail. Re lv PTR-01 (Millstream)$ -$ -$ -$ 905 PTR-02 (Northland)$ -$ - Other 15 Expenses:2014 YTD PTR-03 (Klinefelter)$ -$ - PTR-04 (Wobegon)-$ -$ Dog Baggies-$ 269$ PTR-05 (Memorial)-$ -$ A-1 Toilets610$ 2,271$ PTR-06 (Centennial)-$ -$ 2015 Revenue:2014 YTD PTR-07 (Monument)-$ -$ PTR-08 (Hollow)-$ -$ Interest331$ 801$ PTR-09 (Cloverdale)(20,628)$ -$ Round Up46$ 164$ PTR-10 (East Park)-$ -$ Transfer/Levy3,431$ 4,000$ PTR-11 (West Park)-$ -$ Donation-$ 3,628$ PTR-12 (Trails)-$ -$ Park Dedic.-$ PTR-13 (Trees)-$ -$ Total(20,628)$ -$ Available Rev.Millstream 5k Exp: $ 3,024-$ Council approved $7500 half cent sales tax funding Millstream Shelter Architect-$ Other Project Requests: Park Plan Update$ -$11,500 The Park Board requests updating the Master Park Plan last completed in 2008.