The URL can be used to link to this page

Home My WebLink About[04e] Financial Reports Council Agenda Item 4 \[e\] MEETING DATE: April 20, 2015 st AGENDA ITEM: Financial Report – 1 Quarter 2015 & March 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 March 31, 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.06% with an average maturity of two years. The federal markets are still at near record lows. The 10-year reported 1.9% and 2-year at 0.56%. 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. st - Interest earnings for 2015 are on a good pace to exceed budgeted amounts. As of March 31, interest earnings received are at 47% of the total 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. Interest earnings through March total $47,447. - Overall, the cash and investments balance decreased $637,961 from the beginning of the year as the 2014 working capital is spent down ahead of the property tax and state aid payments. FUNDS REPORT : General fund - The spent 20% of the 2015 expenditure budget and received 5% 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. Revenues will be low until June and July when property taxes and state aids are received. Enterprise Funds - The show expenses more than revenues accept the sewer fund. The “negative” expense in the sewer fund and revenue in the storm water funds are due to reversing journal entries recorded in January. As more utility revenue is received, the storm water will no longer show negative. The sewer expense is negative due to reversing payables for the Main lift station project and for debt interest payments. The summer’s activity will change the negative. 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 some WAC charges during the year. There was one new home 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. The first quarter is generally slower for construction. The City has an increase in development activity that is anticipated in the second and third quarters. ½ ¢ Sales Tax (fund 200): The sales tax fund has a balance of $1,484,758.60 at the end of March. The City anticipates collecting $3,372,754 in sales tax revenue through 2018; $2,545,332 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 past couple years the economy has shown improvements where people are spending more. Economic reports are indicating spending patterns are continuing to increase in 2015. This should be a positive in sales tax collections. The anticipated expenditures total $1,767,748 leaving approximately $1,648,284 remaining for future projects. The balance includes transfers from the General and Recreational Center funds. In 2013, State Legislation approved the extension of the ½ cent sales tax for the St. Cloud area. In November 2014, the voters in all area cities approved the extension with the first $900,000 collected each year to be spent on three regional projects. The remaining funds will be allocated to each city similar to the previous law. St. Joseph anticipates $11,000,000 to be collected in the extended 20 year period through 2038. CIP REPORTS: - Capital outlay in 2015 has been very slow. Staff is evaluating needs through the equipment certificate. 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, looking for shovel ready lots and studying options for the Farmer’s Market. Also included under EDA is the 201 federal DEED grant for home improvements; $240,003 remains for these projects. - SEH has been busy with designing the 2015 street improvements and moving along the Main lift station upgrades in the first quarter. BUDGET/FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action – Quarterly and March Financial Reports 1st Quarter Reports: Cash Position as of 3/31/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 March 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 3/31/15 Sentry BanMaturity DateInterestCurrent Balance# Securities% of Total k Checking Account (Reconciled)N/A0.15%258,107$ N/A Money Market SavingsN/A0.49%357,949 N/A Bank Certificates of Deposit16-21 months0.98% 21,000,000 avg averages19 months0.65% Total Sentry Bank$1,616,05524% Central MN Credit Union Share Savings AccountN/A0.00%35$ N/A Money Market SavingsN/A0.20%15,656 N/A Power Money Market CheckingN/A0.20%13,548 N/A Jumbo Bank Certificates of Deposit1-36 months0.93% 42,327,147 avg averages13 months0.69% Total CMCU$2,356,38535% Total Deposits3,972,441$ Morgan Stanley Smith Barne y Brokered Money Market SavingsN/A0.01%7,687$ N/A Government Securities/Notes94 months1.50% 1797,304 avg Brokered Certificates of DepositTiered 7-83 months1.86% 141,908,037 avg averages42 months1.84% Total SB$ 41%2,713,028 Total Investments2,713,028$ 2015 YTD Total Deposits and Investments$ Interest Earned6,685,468 Average Interest APY24 months1.06%$47,447 Total Deposits & Investment$ Cash and Investment Balance6,685,468 s Petty Cash AdministrationN/AN/A200$ Police DepartmentN/AN/A75 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 Markets7,687$ 0.11%N/A Brokered Certificates of Deposit1,908,037$ 28.54%3.2 years Government Bonds/Notes797,304$ 11.93%7.8 years Foreign Currency Risk: The City only invests in USA and USA territories. ağƩƉĻƷ {ĻĭǒƩźƷźĻƭ {ğǝźƓŭƭ aƚƓĻǤ ağƩƉĻƷ /5ƭ DƚǝĻƩƓƒĻƓƷ /5ƭ .ƩƚƉĻƩĻķ.ƩƚƉĻƩĻķ /ŷĻĭƉźƓŭ aƚƓĻǤ .ğƓƉ Џі Ͳ ЌБАͲЊБА ЎЉі Ͳ ЌͲЌЋАͲЊЍА Ѝі Ͳ IƚƌķźƓŭƭ ЋЎБͲЊЉА LƓǝĻƭƷƒĻƓƷ ğƓķ /ğƭŷ ЋБі Љі Ͳ Ͳ АͲЏБА ЊͲВЉБͲЉЌА ЊЋі Ͳ АВАͲЌЉЍ (125) (2,390) (22) $ 2,407,867 219,869 857,549 418,563 1,362,681 1,386,807 290,916 131,828 47,546 1,442 9,821 6,074 69,760 54,774 $ 15 RECEIVED15 LEFT $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ (1,442) (4,838) $ 125,553 70,936 48,049 125 279 2,306 25,996 6,337 4,890 41,989 29,888 13,369 1,991$ 365,447 22 - $ $ 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 $ 2,017,152 262,095 70,085 1,129 2,523,921 63,575 1,208,600 116,653 405,000 636,735 1,494,643 1,800,644 264,238 194,166 49,158 - - Cash Balances by Fund/Remaining Budget 1.3 months of cash balanc e City of St. Joseph, Minnesota (46,893) (8,949) $ 511,328$ 707,816 38,710 60,510 11 80 270 16,255 66,242 48,247 14,399 7,607 As of 3/31/15 - - - - $ 2,528,480 300,805 130,595 2,524,000 1,224,855 1,560,885 1,791,695 312,485 1,140 63,845 69,760 405,000 636,735 208,565 56,765 - - 2015 cash decrease(637,961) 868,886497,912940,269279,985104,123105,537225,958236,425 90,56218,1951,484,75940,0953,23941,8391,724,68212,00810,9956,685,46812/31/14 Cash Balance7,323,429 FUNDCASH BALANC E $ 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 $70,936 $290,805 Fund Revenues FundFire $347,369 & $300,805 Expenditures Actual $125,553 to Budget $2,533,420 General Fire $511,328 & General $2,528,480 $3,000,000$2,500,000$2,000,000$1,500,000$1,000,000$500,000 $ wĻǝĻƓǒĻ 9ǣƦĻƓƭĻ υБЉͲЉЉЉ υЊͲЊЋЎͲЊЋЍ υАЉͲЉЉЉ υЏЉͲЉЉЉ υББЌͲВЎЋ υЋВЌͲВЉЉ υЎЉͲЉЉЉ Activity υЍЉͲЉЉЉ υВВЉͲЉЏЏ Funds υЌЉͲЉЉЉ Enterprise υЋЌЋͲЍЎЉ υЋЉͲЉЉЉ υБАͲЉАЍ υАͲЏЉА υЊЉͲЉЉЉ υЊͲВВЊ υ WaterWater LightSewer Refuse υΛЊЉͲЉЉЉΜ Street υЏЏͲЋЎЉ Storm υВЋЍͲЉЎЍ υΛЋЉͲЉЉЉΜ City of St. Joseph Quarterly Water Fund Analysi s As of March 31, 201 5 Fund 601+501, Water/WAC Fund Balance as of December 31, 201(audited)$ 134,048.65 4 WAC fees collected for: Year to Date Revenue:702 MN St \[required to connect by 2016\] Interest Earnings12,334.51 1031-13th Ave NE \[new home\] Water Usage Charge20,628.77 Water Line Charge14,701.74 Penalties/Other Usage Fees(13,816.77) WAC/Trunk Fees6,100.00 Antenna Lease Revenue8,376.87 Bulk Water Sales- Transfers from other Funds- Total Revenue48,325.12 2.64%budget collected 2015 Revenue Budget1,829,570.00 (includes fund 501) Year to Date Expenses by Department: Debt Payments13,265.00 Water Tower Bond Summary - as of 3/31/15: Transfers to Other Funds- Power and Pumping(651.66) Bond issue, net651,806.45 Water Treatment Plant 1(4,554.12) Sewer project portion(83,753.00) Water Treatment Plant 2(20,167.32) Engineering(62,591.81) Distribution- Legal(526.50) Wellhead Protection- Project costs(482,265.18) Water Tower2,961.76 Remaining Balance22,669.96 Water Maintenance(48,609.09) Water Administration(8,486.68) Total Expenses(66,242.11) -41.27%budget expensed 2015 Expense Budget(1,160,885.00) (excludes depreciation) Fund Summary as of December 31, 2014: Water Fund Cash Balance - Fund 601+501 - unaudited $116,131.66 Fund 501$ 12,008.46 Fund 601$104,123.20 The balances represent the cash balance as of 3/31/15. Remaining Unallocated Sales Tax through 2018 Facility Planning364,506.56Facilities364,506.56 Parks and Rec survey/system plan43,358.50Parks Boundary Survey8,272.75Centennial Park Swingset33,284.14 Wobegon Trail Extension200,000.00 CR2/3 Trail Extension Phase I446,713.37 CR2 Trail Extension Phase II/III664,996.90 Wobegon Center Upgrades13,886.181,968,334.02Parks and Trails1,603,241.66Other585.801,968,334.0211,000,000 Board Stipends585.80 Est. Remaining CR 133/College Ave Sidewalks 192,729.8 Transportation- 2 General Fund/Rec Center Fund Transfer General Fund/Rec Center Fund Transfer Est. Remaining CR 2 Trail, Phase II/III Est. Remaining CR 2/3 Trail, Phase I$ Fund Balance as of March 31, 2015 Remaining Sales Tax through 2018 Other earnings/transferred/expensed Projects funded (includes estimated remaining): Spent as of March 31, 2015 Sales Tax Extension approved Nov. 2014 Projected Sales Tax Projected Sales Tax Sales Tax CollectedCR133/College Ave Sidewalk Projec Sales Tax received t Sales Tax Spent Anticipated revenue 2019-2038: (661,000.00) (1,106,548.22)(2,545,332.07) (1,106,548.22) (200.00) 2,545,332.071,484,758.601,648,283.86 43,278.082,696.67 3,372,754.00827,421.93 3,372,754.00 43,278.08 - Balance as of December 31, 2006 (audited)193,167.86Balance as of December 31, 2007 (audited)467,180.27Balance as of December 31, 2008 (audited)687,612.54Balance as of December 31, 2009 (audited)962,642.77 Balance as of December 31, 2010 (audited)1,133,318.88Balance as of December 31, 2012 (audited)1,264,824.39Balance as of December 31, 2013 (audited)1,272,767.43Balance as of December 31, 2014 (audited)1,486,280.36Balance as of December 31, 2015 (Unaudited)1,484,758.60 St. Joseph 1/2 Cent Sales Tax Committe Balance as of December 31, 2011 (audited)1,297,612.6 Opening Fund 2006- e 4 Summary Treasurer's Report - Fund 200 2011 CMCU Building Purchase(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) 2008 Meeting Stipends(420.00)2008 Parks and Recreation Survey(1,279.26)2008 Park and Trail System Plan(42,079.24)2008 Parks Boundary Survey(8,272.75)2009 Meeting Stipends(165.80)2010 Transfer Interest Earnings to Water Fund(86,436.20)2010 Centennial Park Swingset(33,284.14)2011 CR 2/3 trail extension(21,463.82)2011 CR 133/College Ave trail extension(2,878.30)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)2015 CR 2 Trail Extension - Phase II/III(79.50) (1,442.26) 2006 Interest Earnings2,696.64190,471.222007 Interest Earnings12,081.68237,927.002007 Transfer from the General Fund24,003.732008 Interest Earnings21,468.30251,015.222009 Interest Earnings33,184.4024 2,011.63270,108.802010 Interest Earnings20,287.65299,571.59314,646.75360,909.002013 Transfer from Rec Center Fund - Facilities19,274.35380,113.12 2015 Other- As of March 31, 2015 2006 Sales Tax Receipts Collected2007 Sales Tax Receipts Collected2008 Sales Tax Receipts Collected2009 Sales Tax Receipts Collected2010 Sales Tax Receipts Collected2011 Sales Tax Receipts Collected2012 Sales Tax Receipts Collected2013 Sales Tax Receipts Collected2014 Sales Tax Receipts Collected2015 Sales Tax Receipts Collected Cash Balances Only Current Period: March 2015 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance Last Dim 10100 GeneralG 101-10100$1,225,721.48$88,524.74$163,758.93$806,049.57 Employee Retirement ReserveG 102-10100$46,230.00$0.00$0.00$46,230.00 Fire FundG 105-10100$549,418.86$13,268.22$7,135.45$497,912.16 Cable Access FeeG 108-10100$14,515.81$694.30$0.00$16,606.03 Economic DevelopmentG 150-10100$109,443.65$26,261.52$31,802.92$90,561.55 TIF 2-1 MillstreamG 157-10100$17,951.81$63.58$0.00$18,106.19 TIF 2-2 Meat MarketG 158-10100$116.36$0.34$0.00$88.35 State Collected Sales TaxG 200-10100$1,426,025.77$557.74$0.00$1,484,758.60 Park DedicationG 205-10100$40,028.63$154.60$60.00$40,094.80 Charitable GamblingG 215-10100$3,210.53$11.37$0.00$3,238.95 Revolving Loan FundG 250-10100$39,469.77$1,159.29$343.55$41,839.11 2009A CrossoverRefunding BoG 318-10100$345,914.75$1,226.20$0.00$349,302.43 City Hall Refunded, 2005G 322-10100$581.61$602.71$0.00$1,462.19 2011A Refunding Fire HallG 331-10100$73,376.77$272.21$2,200.00$77,048.53 2010B Refundin (Hill/Clover)G 333-10100$254,235.21$906.45$0.00$256,609.17 2011A CO Refund (Interior StsG 338-10100$148,500.78$528.46$9,615.00$141,214.80 2009B GO CIP BondsG 343-10100$7,574.84$27.22$0.00$7,807.21 2010 Equipment CertificatesG 344-10100$5,520.66$19.67$0.00$5,618.36 2010B Street Impr (16th Ave)G 345-10100$224,865.13$796.47$0.00$226,793.57 2011A Pumper Truck CertificatG 346-10100$2,947.05$21.76$2,980.00$4,814.03 2011A GO CIP BondsG 347-10100$13,702.76$665.05$1,460.00$13,882.02 2013 Street Improve BondsG 348-10100$191,194.43$635.75$0.00$175,178.78 2013 Equipment CertificatesG 349-10100$2,615.56$9.84$0.00$2,883.13 2014 Street Impr \[ParkTerraceG 350-10100$196,802.24$2,630.19$0.00$208,140.15 2015 Street ImprovementsG 351-10100$0.00$0.00$0.00$0.00 2015 Equipment CertificatesG 352-10100$0.00$0.00$0.00$0.00 Debt Service ReliefG 390-10100$253,091.43$0.00$0.00$253,927.38 2011A GO CIP BondsG 447-10100$174,042.45$0.00$0.00$174,042.45 2014 Imp Park TerraceG 450-10100$545,623.98$0.00$2,141.50$537,957.44 2015 Street ImprovementsG 451-10100$0.00$0.00$5,517.64-$12,464.81 Capital OutlayG 490-10100$241,034.30$0.00$300.64$240,733.66 Water ExtensionG 501-10100$263.31$5,459.38$0.00$12,008.46 Sewer ExtensionG 502-10100$271,369.27$6,011.44$0.00$279,985.28 Water FundG 601-10100$19,928.22$65,755.92$30,356.84$104,123.20 Sewer FundG 602-10100$299,409.43$45,510.05$21,110.34$105,536.73 Refuse CollectionG 603-10100$225,832.27$23,696.22$24,596.64$225,958.47 Storm Water UtilityG 651-10100$225,324.75$7,884.66$4,991.99$236,425.07 Street Light UtilityG 652-10100$8,552.20$3,357.38$3,340.09$10,995.37 Last Dim 10100$7,204,436.07$296,712.73$311,711.53$6,685,468.38 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$296,712.73$311,711.53$6,685,743.38 Council Month End Revenue Summary Current Period: March 2015 2015March2015 FUNDFUND DescrYTD Budget2015 AmtYTD Amt 101General$2,458,040.00$61,525.22$124,162.52 102Employee Retirement Reserve$67,930.00$0.00$0.00 105Fire Fund$290,805.00$13,249.47$70,936.10 108Cable Access Fee$7,450.00$694.30$1,390.06 150Economic Development$95,595.00$23,331.42$48,048.92 157TIF 2-1 Millstream$0.00$63.58$124.66 158TIF 2-2 Meat Market$0.00$0.34$0.41 200State Collected Sales Tax$0.00$557.74-$1,442.26 205Park Dedication$10,100.00$154.60$278.68 215Charitable Gambling$0.00$11.37$21.60 250Revolving Loan Fund$8,380.00$815.74$2,306.05 3182009A CrossoverRefunding Bonds$272,020.00$1,226.20$2,427.91 322City Hall Refunded, 2005$91,600.00$602.71$582.01 3312011A Refunding Fire Hall$49,750.00$272.21$5,692.10 3332010B Refundin (Hill/Clover)$96,340.00$906.45$1,625.53 3382011A CO Refund (Interior Sts)$126,135.00$528.46$887.29 3432009B GO CIP Bonds$56,100.00$27.22$36.60 3442010 Equipment Certificates$25,600.00$19.67$31.74 3452010B Street Impr (16th Ave)$48,075.00$796.47$1,553.69 3462011A Pumper Truck Certificate$45,810.00$21.76$4,818.32 3472011A GO CIP Bonds$240.00$665.05$1,297.63 3482013 Street Improve Bonds$9,000.00$635.75$1,296.27 3492013 Equipment Certificates$55,250.00$9.84-$1.85 3502014 Street Impr \[ParkTerrace\]$7,625.00$2,630.19$5,748.67 3512015 Street Improvements$0.00$0.00$0.00 3522015 Equipment Certificates$0.00$0.00$0.00 390Debt Service Relief$0.00$0.00$0.00 4502014 Imp Park Terrace$0.00$0.00$0.00 4512015 Street Improvements$0.00$0.00$0.00 490Capital Outlay$69,760.00$0.00$0.00 501Water Extension$424,900.00$5,459.38$6,336.59 502Sewer Extension$2,500.00$6,011.44$4,889.99 601Water Fund$1,404,670.00$56,802.39$41,988.53 602Sewer Fund$1,416,695.00$45,464.19$29,887.53 603Refuse Collection$304,285.00$21,135.85$13,368.68 651Storm Water Utility$126,990.00$7,884.66-$4,838.21 652Street Light Utility$56,765.00$3,357.38$1,991.21 $7,628,410.00$254,861.05$365,446.97 1 Council Month End Revenue -General Fund Current Period: March 2015 2015March2015 FUNDFUND DescrSOURCE DescrYTD Budget2015 AmtYTD Amt FUND 101 General 101GeneralCurrent Ad Valorem Taxes$1,065,885.00$0.00$0.00 101GeneralSpecial Levy- City St. Joe$0.00$0.00$0.00 101GeneralState Sales Tax$0.00$67.86$97.36 101GeneralGas Franchise$29,000.00$0.00$0.00 101GeneralElectric Franchise$54,000.00$1,784.56$3,570.40 101GeneralBeer$575.00$10.00$15.00 101GeneralLiquor$22,260.00$0.00$0.00 101GeneralOutdoor Liquor Permit$2,500.00$750.00$750.00 101GeneralGambling Permits$200.00$40.00$270.00 101GeneralAmusement/Hunting Permit$1,300.00$0.00$0.00 101GeneralExcavation Permit$500.00$0.00$0.00 101GeneralCigarette License$525.00$0.00$0.00 101GeneralCable Franchise Fee$30,500.00$1,328.94$2,680.91 101GeneralBuilding Permits$45,000.00$22,467.15$27,290.62 101GeneralAnimal License$3,150.00$1,380.00$1,390.00 101GeneralRental Housing Registration$23,000.00$0.00$0.00 101GeneralFederal Grants - Other$5,000.00$374.78$0.00 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$0.00$0.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-$10,000.00$3,000.00 101GeneralSale of Maps and Publications$50.00$0.00$2.42 101GeneralAssessments Search$2,500.00$330.00$1,410.00 101GeneralSpecial Hearing$5,000.00$1,050.00$1,050.00 101GeneralAdministration Reimb$11,400.00-$150.11$24.78 101GeneralWeed Cutting$1,000.00$100.00$0.00 101GeneralPark Fees$5,500.00$1,220.00$2,500.00 101GeneralBall Field Donation$250.00$0.00$0.00 101GeneralSchneider Field Rental$1,500.00$0.00$0.00 101GeneralKennel Fees$700.00$40.00$40.00 101GeneralCounty Fines$25,000.00$1,234.81$4,749.56 101GeneralPolicy Fines$22,000.00$1,898.00$4,208.00 101GeneralAccident Report Fee$1,000.00$105.75$213.50 101GeneralSeized Property$500.00$9,040.00$9,040.00 101GeneralSpecial Assessments$2,000.00$0.00$0.00 Council Month End Revenue -General Fund Current Period: March 2015 2015March2015 FUNDFUND DescrSOURCE DescrYTD Budget2015 AmtYTD Amt 101GeneralInterest Earnings$18,500.00$4,190.95$8,004.53 101GeneralInterest Charges$100.00$1.08$0.00 101GeneralCo-op Dividend - LMCIT$18,000.00$0.00$0.00 101GeneralWater Tower Antenna Lease$3,755.00$472.81$930.78 101GeneralAdvertising$2,000.00$200.00$200.00 101GeneralContributions - General$1,500.00$20,000.00$20,000.00 101GeneralContributions - Parks$1,000.00$35.92$35.92 101GeneralSurplus Property$0.00$0.00$0.00 101GeneralReimbursement$27,300.00$3,552.72$3,602.24 101GeneralTransfers from Other Funds$0.00$0.00$0.00 FUND 101 General$2,458,040.00$61,525.22$124,162.52 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$694.30$1,390.06 108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00 FUND 108 Cable Access Fee$7,450.00$694.30$1,390.06 FUND 150 Economic Development 150Economic DevelopmentCurrent Ad Valorem Taxes$94,595.00$0.00$0.00 150Economic DevelopmentFederal Grants - Other$0.00$23,001.00$47,301.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$330.42$747.92 150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00 FUND 150 Economic Development$95,595.00$23,331.42$48,048.92 $2,629,515.00$85,550.94$173,601.50 Council Month End Revenue -Enterprise Funds Current Period: March 2015 FUND2015March2015 FUNDDescrSOURCE DescrYTD Budget2015 AmtYTD Amt FUND 601 Water Fund 601Water FundPenalties and Forfeited Disc$8,000.00$758.59$1,807.11 601Water FundBond Premium Proceeds$0.00$0.00$0.00 601Water FundGeneral Oblig. Bond Proceeds$0.00$0.00$0.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$814.69$546.18 601Water FundCurrent Ad Valorem Taxes$43,500.00$0.00$0.00 601Water FundWater Meter$5,000.00-$1,200.00$315.00 601Water FundConnection/Reconnection fees$200.00$0.00$0.00 601Water FundUndesignated Funds$0.00-$2,225.60-$5,159.64 601Water FundInterest Earnings$41,600.00$6,100.17$12,097.92 601Water FundWater Line Charge$293,135.00$19,762.61$14,701.74 601Water FundSpecial Assessments$200.00$0.00-$10,827.02 601Water FundBulk Water$1,500.00$1,858.34$0.00 601Water FundAmortization of Bond Premium$0.00$0.00$0.00 601Water FundWater Tower Antenna Lease$35,030.00$4,255.21$8,376.87 601Water FundSurplus Property$0.00$0.00$0.00 601Water FundReimbursement$0.00$0.00-$110.00 601Water FundRate Class One$522,860.00$26,635.36$20,628.77 601Water FundState Sales Tax$0.00$43.02-$388.40 FUND 601 Water Fund$1,404,670.00$56,802.39$41,988.53 FUND 602 Sewer Fund 602Sewer FundContributed Revenue$0.00$0.00$0.00 602Sewer FundOther Governmental Unit$2,900.00$0.00$0.00 602Sewer FundSpecial Assessments$200.00$0.00-$297.60 602Sewer FundInterest Earnings$5,075.00$556.13$404.30 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 FundSanitary Sewer Service$423,030.00$21,286.48$11,085.82 602Sewer FundPenalties and Forfeited Disc$4,675.00$536.80$1,091.36 602Sewer FundSewer Line Charge$344,080.00$23,084.78$17,603.65 602Sewer FundTransfers from Other Funds$636,735.00$0.00$0.00 602Sewer FundReimbursement$0.00$0.00$0.00 FUND 602 Sewer Fund$1,416,695.00$45,464.19$29,887.53 FUND 603 Refuse Collection 603Refuse CollecContributions - General$0.00$0.00$0.00 603Refuse CollecContributed Revenue$0.00$0.00$0.00 603Refuse CollecInterest Earnings$4,000.00$796.05$1,582.46 603Refuse CollecSpecial Assessments$200.00$0.00-$233.35 603Refuse CollecRefuse Collection Charges$277,665.00$19,547.68$13,156.13 603Refuse CollecLicenses & Permits$16,920.00$740.00$740.00 603Refuse CollecState Sales Tax$0.00-$659.92-$3,274.58 603Refuse CollecPenalties and Forfeifted Disc$5,500.00$712.04$1,398.02 FUND 603 Refuse Collection$304,285.00$21,135.85$13,368.68 FUND 651 Storm Water Utility 651Storm Water Contributed Revenue$0.00$0.00$0.00 651Storm Water Transfers from Other Funds$0.00$0.00$0.00 651Storm Water Penalties and Forfeifted Disc$2,030.00$150.18$327.57 651Storm Water Special Assessments$4,795.00$0.00-$11,569.63 Council Month End Revenue -Enterprise Funds Current Period: March 2015 FUND2015March2015 FUNDDescrSOURCE DescrYTD Budget2015 AmtYTD Amt 651Storm Water Development Fee$20,000.00$0.00$0.00 651Storm Water Reimbursement$0.00$0.00$0.00 651Storm Water Interest Earnings$2,000.00$815.77$1,628.43 651Storm Water Rate Class One$98,165.00$6,918.71$4,775.42 FUND 651 Storm Water Utility$126,990.00$7,884.66-$4,838.21 FUND 652 Street Light Utility 652Street Light UTransfers from Other Funds$0.00$0.00$0.00 652Street Light USpecial Assessments$50.00$0.00-$33.32 652Street Light UInterest Earnings$25.00$32.33$72.12 652Street Light URate Class One$56,490.00$3,267.07$1,894.43 652Street Light UPenalties and Forfeited Disc$200.00$57.98$57.98 FUND 652 Street Light Utility$56,765.00$3,357.38$1,991.21 $3,309,405.00$134,644.47$82,397.74 Council Month End Expenditure - Summary Current Period: March 2015 2015March2015 DescriptionYTD Budget2015 Amt YTD Amt General$2,458,040.00$136,271.00$511,327.89 Employee Retirement Reserve$68,430.00$0.00$0.00 Fire Fund$300,805.00$7,116.70$38,710.09 Cable Access Fee$2,010.00$0.00$0.00 Economic Development$130,595.00$28,872.82$60,509.86 TIF 2-1 Millstream$570.00$0.00$0.00 TIF 2-2 Meat Market$570.00$0.00$11.15 State Collected Sales Tax$2,524,000.00$0.00$79.50 Park Dedication$63,845.00$60.00$270.00 Charitable Gambling$0.00$0.00$0.00 Revolving Loan Fund$0.00$0.00$0.00 2009A CrossoverRefunding Bon$360,525.00$0.00$0.00 City Hall Refunded, 2005$94,385.00$0.00$0.00 2011A Refunding Fire Hall$74,750.00$2,200.00$2,200.00 2010B Refundin (Hill/Clover)$142,250.00$0.00$0.00 2011A CO Refund (Interior Sts)$144,630.00$9,615.00$9,615.00 2009B GO CIP Bonds$63,200.00$0.00$0.00 2010 Equipment Certificates$31,125.00$0.00$0.00 2010B Street Impr (16th Ave)$65,955.00$0.00$0.00 2011A Pumper Truck Certificate$46,310.00$2,980.00$2,980.00 2011A GO CIP Bonds$23,320.00$1,460.00$1,460.00 2013 Street Improve Bonds$39,970.00$0.00$0.00 2013 Equipment Certificates$54,600.00$0.00$0.00 2014 Street Impr \[ParkTerrace\]$53,835.00$0.00$0.00 2015 Street Improvements$0.00$0.00$0.00 2015 Equipment Certificates$0.00$0.00$0.00 Debt Service Relief$30,000.00$0.00$0.00 2011A GO CIP Bonds$0.00$0.00$0.00 2014 Imp Park Terrace$0.00$2,141.50-$59,658.05 2015 Street Improvements$0.00$5,517.64$12,464.81 Capital Outlay$69,760.00$300.64$300.64 Water Extension$405,000.00$0.00$0.00 Sewer Extension$636,735.00$0.00$0.00 Water Fund$1,560,885.00$21,403.31$66,242.11 Sewer Fund$1,791,695.00$21,064.48-$8,949.27 Refuse Collection$312,485.00$22,036.27$48,246.74 Storm Water Utility$208,565.00$4,991.99$14,398.90 Street Light Utility$56,765.00$3,340.09$7,606.68 $11,815,610.00$269,371.44$707,816.05 Council Month End Expenditure - General Fund Current Period: March 2015 2015March2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt FUND 101 General GeneralCouncil$58,895.00$2,302.05$8,058.86 GeneralLegislative Committees$5,595.00$1,015.00$455.00 GeneralOrdinance & Proceedings$1,600.00$216.00$216.00 GeneralMayor$11,005.00$826.85$1,612.99 GeneralElections$1,000.00$0.00$1,162.50 GeneralGeneral Adminstration$234,870.00$16,966.42$46,679.44 GeneralFinance$122,385.00$8,720.80$25,714.05 GeneralAudit Service$27,000.00$4,500.00$4,500.00 GeneralAssessing$23,500.00$0.00$0.00 GeneralCity Attorney$16,000.00$27.00$2,139.75 GeneralPlanning and Zoning$8,140.00$347.35$437.35 GeneralGeneral Government$20,345.00$2,531.24$7,718.32 GeneralCity Offices$32,655.00$1,824.94$7,178.52 GeneralFacilites and Planning$0.00$0.00$0.00 GeneralCable Access$11,095.00$830.60$2,087.20 GeneralCrime Control & Investigation$956,640.00$60,038.68$181,444.46 GeneralPolice Training$11,750.00$1,425.00$3,980.00 GeneralCommunication Service$11,720.00$1,140.17$2,502.62 GeneralAutomotive Services$54,200.00$1,446.76$4,375.36 GeneralBuilding Inspec. Admistration$92,000.00$7,500.00$15,000.00 GeneralEmergency Management$1,280.00$658.08$666.08 GeneralSignal Lights CSAH 75$0.00$0.00-$90.77 GeneralAnimal Control$965.00$0.00$195.00 GeneralStreet Maintanence$258,795.00$11,138.14$44,605.20 GeneralIce & Snow Removal$106,160.00$6,179.54$35,021.58 GeneralEngineering Fee$28,000.00-$7,854.60$20,585.73 GeneralStreet Cleaning$13,385.00$0.00$608.69 GeneralSkate Park and Ice Rink$5,345.00$988.83$2,358.67 GeneralBall Park$1,750.00$0.00$0.00 GeneralMaintenance Shop$21,915.00$2,540.18$6,245.96 GeneralPark Areas$215,480.00$10,961.97$54,476.42 GeneralCommunity Support$0.00$0.00$0.00 GeneralOther Financing Uses$0.00$0.00$0.00 GeneralFire Protection$104,570.00$0.00$31,392.91 FUND 101 General$2,458,040.00$136,271.00$511,327.89 FUND 102 Employee Retirement Reserve Employee Retirement ReservGeneral Adminstration$68,430.00$0.00$0.00 FUND 102 Employee Retirement Reserve$68,430.00$0.00$0.00 FUND 108 Cable Access Fee Cable Access FeeCable Access$2,010.00$0.00$0.00 FUND 108 Cable Access Fee$2,010.00$0.00$0.00 2 Council Month End Expenditure - General Fund Current Period: March 2015 2015March2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt FUND 150 Economic Development Economic DevelopmentEconomic Development Authority$130,595.00$28,872.82$60,509.86 Economic DevelopmentOther Financing Uses$0.00$0.00$0.00 FUND 150 Economic Development$130,595.00$28,872.82$60,509.86 FUND 490 Capital Outlay Capital OutlayGeneral Adminstration$2,750.00$300.64$300.64 Capital OutlayCrime Control & Investigation$3,000.00$0.00$0.00 Capital OutlayCommunication Service$5,360.00$0.00$0.00 Capital OutlayAutomotive Services$8,500.00$0.00$0.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$0.00 Capital OutlayPark Areas$22,400.00$0.00$0.00 Capital OutlayOther Financing Uses$0.00$0.00$0.00 FUND 490 Capital Outlay$69,760.00$300.64$300.64 $2,728,835.00$165,444.46$572,138.39 Council Month End Expense - Enterprise Funds Current Period: March 2015 2015March2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt FUND 601 Water Fund Water FundBond Payment (P & I)$690,120.00$0.00-$13,265.00 Water FundOther Financing Uses$45,000.00$0.00$0.00 Water FundPower and Pumping$21,950.00-$13.38$651.66 Water FundPurification-Plant 1$42,380.00$1,404.22$4,554.12 Water FundPurification-Plant 2$76,895.00$4,765.44$20,167.32 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-$3,295.65-$2,961.76 Water FundWater Maintenance$218,670.00$16,015.03$48,609.09 Water FundAdministration and General$38,035.00$2,527.65$8,486.68 Water FundDepreciation Expense$400,000.00$0.00$0.00 FUND 601 Water Fund$1,560,885.00$21,403.31$66,242.11 FUND 602 Sewer Fund Sewer FundBond Payment (P & I)$227,020.00$1,725.00-$3,965.00 Sewer FundOther Financing Uses$55,050.00$0.00$0.00 Sewer FundSanitary Sewer Maintenanc$237,440.00$9,138.02$40,863.91 Sewer FundLift Station-Baker Street$9,415.00$226.19$716.74 Sewer FundLift Station-Ridgewood/DBL$3,425.00$166.99$535.66 Sewer FundLift Station-Northland$52,205.00$137.17$483.58 Sewer FundLift Station-CR 121$4,935.00$179.66$627.40 Sewer FundLift Station-Main$787,705.00$6,951.51-$56,687.16 Sewer FundAdministration and General$39,500.00$2,539.94$8,475.60 Sewer FundDepreciation Expense$375,000.00$0.00$0.00 FUND 602 Sewer Fund$1,791,695.00$21,064.48-$8,949.27 FUND 603 Refuse Collection Refuse CollectioWaste Collection$305,985.00$22,036.27$48,246.74 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$22,036.27$48,246.74 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$614.10$3,439.26 Storm Water UtiStorm Water Maintenance$78,515.00$4,377.89$10,959.64 Storm Water UtiDepreciation Expense$100,000.00$0.00$0.00 FUND 651 Storm Water Utility$208,565.00$4,991.99$14,398.90 FUND 652 Street Light Utility Street Light UtiliStreet Lighting$56,765.00$3,340.09$7,606.68 Street Light UtiliOther Financing Uses$0.00$0.00$0.00 FUND 652 Street Light Utility$56,765.00$3,340.09$7,606.68 Council Month End Expense - Enterprise Funds Current Period: March 2015 2015March2015 DescriptionDEPART DescrYTD Budget2015 Amt YTD Amt $3,930,395.00$72,836.14$127,545.16 1 23,953.0422,353.464,557.696,149.685,000.0016,606.0378,619.909,539.8230,096.887,630.0014,261.5910,504.956,412.6178,445.8564,384.113,750.0011,000.0010,000.001,500.0021,250.0060,536.8628,400.0062,300.23 4,749.89267,871.091,700.0082,396.5084,096.50 509,033.34 ProjectBudgetReserveTransferred/SpentBudgetRemaining 201520152015Balance 750.00 1,000.002,000.005,000.008,750.003,000.005,360.004,000.002,000.002,500.002,000.0018,860.006,000.002,000.004,750.0013,000.0016,900.002,000.0058,650.0033,500.0033,500.00 7,000.007,000.00 119,760.00 (2,076.87)(2,076.87)(613.73) 3/31 300.64 1,162.501,463.14 3/31through Summary 2014 1,390.061,390.0624,086.5024,086.50 25,476.56 Availablethrough 4, CodeEquipmentBalanceGrant December 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 2015 Improvement adopted 31, March 2014Capital Final Total Public Works CIP Total Police CIPTotal EDA CIP Total Administration CI P Maintenance490-45201-580Maintenance Shop Equipment Capital of Administration101-41910-300Planning Document Updates Street Sweeping490-43220-580Street Sweeping Equipment Police-Communications490-42151-580Communication Equipment Snow Removal490-43125-580Snow Removal Equipment As Administration490-41430-570Administration Equipment Budget Administration490-41430-581Computer Replacement Fund Streets490-43120-550Street Motor Vehicles Parks490-45202-550Parks Motor Vehicles Streets101-43120-530/230Street ImprovementsStreets490-43120-530Street Improvements Emergency Services490-42500-580Emergency ServicesParks490-45202-530Parks Improvements Election101-41410-xxxElection Equipment Administration490-41430-582Computer SoftwarePolice - Automotive490-42152-580Vehicle/EquipmentEDA Software150-46500-582Computer Software Police - General490-42120-580Police Equipment Streets490-43120-580Street Equipment CIP Cable Access108-41950-580Cable Equipment Parks490-45202-580Parks Equipment Total General Capital Improvement General s Police - Automotive490-42152-581Squad Laptops EDA Projects150-46500-588EDA Programs Police - Automotive490-42152-550Police Squads 2015 DepartmentAccount ΛЋВЏ͵ЉЎΜ ЊͲЌЊЋ͵ЎВЍͲЊЏЌ͵ЌЏЊАͲЎЏЋ͵ЍЉ 17,562.40 ЌЍͲЋЎВ͵ЎБЎЏͲБЋЌ͵ААЍАͲЋЎЉ͵ЉЉЍБͲЉЉЉ͵ЉЉЊЋͲЎЉЊ͵ЉЉЍͲЉЉЉ͵ЉЉЋАͲАББ͵ЏЎЍЍͲЉЉБ͵ЋЎЋͲЏЏЎ͵ЊЎ 46,673.40 ЊͲЎЋА͵ЎАЊБͲЋЏЏ͵ВЋЊВͲЍВЊ͵ВЋБͲЍЎЉ͵ЉЉ 46,208.84 1,312.594,163.36230,326.951,527.57347,775.11 3/31Available BudgetAdjustmentsSpentReserve CodeDepartmentObjectYearDescriptionFunds201520152015Funds ЊͲЉЍВ͵ВБЊЌͲЎЊЉ͵ЉЉ 13,510.0014,559.98 1,049.98 of AvailableGrants/as 3/31 of 12/31/2014as ЊͲЉЎЉ͵ЉЉ 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 ЋВͲЋЎВ͵ЎБЍВͲЌЋЌ͵ААЌАͲЋЎЉ͵ЉЉЌБͲЉЉЉ͵ЉЉЋЋͲАББ͵ЏЎ 185,326.95 ЌЍͲЉЉБ͵ЋЎ 36,173.401,327.57 ЌЉͲЋАЏ͵ВЋЊБͲВВЊ͵ВЋ 56,718.84300,085.09 PurchasedReserve 105-42220-584Fire FightingEquipment Reserve1996/2005Extrication Equip105-42250-580Fire CommunicationOther Equipment2007800 MHz Radios 105-42280-530Fire Station & BuildingEquipment Reserven/aBuilding Repairs 105-42220-580Fire FightingOther Equipmentn/aTurnout Gear/TV105-42220-585Fire FightingFirefighter Equipment2001Ladder Truck #2 105-42220-585Fire FightingFirefighter Equipmentn/aReplacement105-42250-580Fire CommunicationOther Equipmentn/aReplacement105-42270-580Medical ServicesOther Equipmentn/aReplacement 105-42220-585Fire FightingFirefighter Equipment2012Pumper Truck 105-42210-581/582Fire AdministrationComputer Hardware/Software2010/20113 Computers105-42220-585Fire FightingFirefighter Equipment1997Grass Rig #3 105-42220-585Fire FightingFirefighter Equipment2012Rescue Van 105-42280-530Fire Station & BuildingEquipment Reserve2011Sealcoating 105-42220-585Fire FightingFirefighter Equipment20126 Wheeler 105-42220-585Fire FightingFirefighter Equipment1999Tanker #4 105-42220-585Fire FightingFirefighter Equipment2013Air Packs 105-42280-530Fire Station & BuildingImprovements other than Buildin2008Painting Building Hardware/Software than other Improvements Equipment Reserve Equipment Computer Department Equipment Adopted December 4, 2014 Plan EquipmentEquipment Budget Building Improvement Communications Administration Other Services Capital Fire & FightingFightingFighting Station CǒƓķ Joseph Medical 2015 Capital 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 # CMCU (1,266.56)(165.19) 1,700.0043,759.0020,308.949,210.8010,549.51 82,396.50240,003.00 84,096.5 0 CodeNumberEquipmentBalance201520152015Balance ProjectProjectReserveBudgetTransfersSpent2015 (2,076.87) (1,542.27) (534.60)(2,076.87)(47,301.00) 3/31 3/31through Availablethrough ED A 18,500.0012,000.003,000.00 33,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.51 50,973.37287,304.00 CIP 52,673.3 7 CapitalFinal Capital Adopted 2015 2015 2013 CDBG Grant Development Fund Business Demolition Program CSAH 2/3 Collection Street General Business Development/TIF Parkway Business Center BFA Grant/Loan Program Rental Conversions Let's Go Downtown Computer Software EDA-1301EDA-1302 EDA-130EDA-130EDA-130EDA-130EDA-130EDA-130EDA-130 7783459 150-46500-582EDA150-46500-588 DepartmentAccount TOTAL EDA CIP A ED 3,750.005,500.006,250.0012,500.0027,500.0010,723.44 66,223.44 25,475.00119,102.186,500.0042,500.0014,000.004,600.0051,600.007,400.00 294,343.70 36,606.3112,550.0077,350.0020,000.0076,000.00 222,506.31 4,000.00 4,000.00 6,000.00 6,000.00 30,000.00 3,750.0019,416.52 ProjectProjectReserveBudgetTransfersSpentAvailable CodeNumberEquipmentBalance201520152015Balance 3/312015 (3,531.10)(3,531.10) of 12/31/2014Grants/as 2,000.003,000.003,750.007,500.003,750.00 20,000.00 2,000.0020,000.0042,500.002,300.0049,300.002,200.00 128,300.00 1,000.002,000.008,000.001,000.00 12,000.00 1,000.00 1,000.00 4,000.00 4,000.00 10,000.00 Works 2,500.006,250.00Repairs8,750.00Repairs6,973.44 46,223.44 9,416.5214,000.00 166,043.70 Plan40,137.4111,550.00Easements/Acquire75,000.00 214,037.41(1/4)3,000.00 3,000.002,000.0030,000.00 (1/4)1,750.00Replacement20,000.00(1/2)25,475.00(1/4)1,750.00Lining99,102.18Sampler6,500.00LS2,300.00LS2,300.00LS5,200.00Improvements75,350.00Sweeper12,000.00Lighting2,000.00 Public Budget 2014 Expenditures Plan 4, CIP Improvement December 2015 Final Capital Adopted Enterprise L Capital S 2015 Ridgewood Northland (1/2) Foamin St LS g Certificates Programme CR121 Replacemen Baker r Management Main t Enterprise SystemSystem Televising/Root pumpspumpspumpspumpspumps Media Loader Communications Equipment Communications Meter Roof Mapping Quality Water Filter SubmersibleSubmersibleSubmersibleSubmersibleSubmersible #4/5End Handheld Property Water SewerSewerSewer AerialStreetStreet 112 Front TruckTruck Storm Well 2013 WTPWTPWTP 140714011408140214031403140314031403 1403140114021403140414031403140714251407 1401140414051406 1410 WTWTWTWTWTWT SL WWWWWWWWWWWWWWWWWWSSSSSS SS PWPWPWPW 550580220580580580580550530300580580580580580580300530530580510580580580 494404949049410494204942049421494504945049450494504948049480494714947049472494734990049900499004990049900432304316043120 DepartmentAccount 601601601601601601602602602602602602602602602602651651651651651603Lighting652449 Stormwater 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 March 31, 201540,095$ (Unaudited) Adjustments Starting Balance40,095$ Legacy Grant30,000$ Half Cent Sales Tax200,000$ Other Revenues2,700$ 2015 General Levy9,500$ Potential Projects: PotentialProposed Millstream Cottages-phase 223,400$ Jasmine Ln Extension- 10 lots9,140$ Sunset Ridge- phase 2 - 4 lots2,000$ CLC Development - 16 lots8,000$ Ending Balance for 2015282,295$ 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) $ 30,400400$ 400$ 400$ 400$ 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,00010,000$ 10,000$ 10,000$ 10,000$ 10,000$ 50,000$ PTR-12 (Trails) $ 1,5001,500$ 1,500$ 1,500$ 1,500$ 1,500$ 7,500$ PTR-13 (Trees) Total25,900$ 241,900$ 36,900$ 11,900$ 11,900$ 11,900$ 314,500$ Projects - ActualSpent 2014Spent 201515 Snow Town Expenses:Avail. Rev 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 Toilets270$ 2,271$ PTR-06 (Centennial)-$ -$ 2014 YTD 2015 Revenue: PTR-07 (Monument)-$ -$ PTR-08 (Hollow)-$ -$ Interest269$ 801$ PTR-09 (Cloverdale)(20,628)$ -$ Round Up10$ 164$ PTR-10 (East Park)-$ -$ Transfer/Levy4,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-$ Other Project Requests: Park Plan Update-$ 11,500$ The Park Board requests updating the Master Park Plan last completed in 2008.