The URL can be used to link to this page

Home My WebLink About[04c] Financial Report Council Agenda Item 4 \[c\] MEETING DATE: February 2, 2015 th AGENDA ITEM: Financial Report – 4 Quarter 2014 & December 2014 Financial Reports SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A strd PREVIOUS COUNCIL ACTION: Council accepted the 1 - 3 quarters and October/November Financial Reports. 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 December 31, 2014. Year-end audit entries are not reflected. The final 2014 numbers will be presented in April with the audit presentation. There are a couple points to highlight from the reports. CASH POSITION : - The market rate of return (ROR) is approximately 1.003% with an average maturity of just over two years. The final seven-year CD’s paying 4.85-5% matured in December. There are no investment options near this level. As a result, the ROR is down at the end of the year. On st December 31 the 10-year Treasuries were 2.17%; 2-year Treasury is 0.67%. The markets are usually a little higher the end of December. On January 14, 2015, the 30-year treasury hit its record low of 2.39%. The 10-year reported 1.8% and 2-year at 0.46%. 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. - Interest earnings for 2014 have rebounded in comparison to 2013. 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. Since the City holds investments until maturity, investment earnings over the life of a security will be healthy. 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 December total $185,066. - Overall, the cash and investments balance decreased $1,692,471 from the beginning of the year as bond proceeds and reserves were paid down. FUNDS REPORT : General fund - The spent 103% of the 2014 budget and received 103% of the revenue budget. Expenditures are mainly operational in nature. A couple areas with higher than expected expenditures include snow plowing, attorney services (negotiations and litigation), planning & zoning (new developments/power line study), and engineering (projects/developments). On the revenue side: taxes, police aid and assessments were higher than budgeted. Enterprise Funds - The show expenses more than revenues accept street light and sewer. The reports show 12 months of expenses and 10 months utility revenue received. The revenues will show positive after year-end entries are booked. The amounts include debt interest payments and operational activity for the year. The proceeds for the 2014A water revenue bonds issued in June were removed from the revenues as well as the 2012A crossover refunding bond payments. The crossover bonds were paid with proceeds left in an escrow account held at Northland Securities. 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. The Kennedy Community School expansion began. The Graceview 4 and the Bayou Blues and Flats developments have been approved. Rivers Bend 3 and the Professional Plat development are still in process. Construction (WAC fees) is anticipated to pick up once the developments go in. At the end of 2014, beginning 2015, five new home permits were issued. The water tower project is near completion with a few punch list items to correct. ½ ¢ Sales Tax (fund 200): The sales tax fund has a balance of $1,426,025.77 at the end of December. The City anticipates collecting $3,372,754 in sales tax revenue through 2018; $2,465,806.41 was collected to date. Collections the past couple of years have been higher. 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. Also, the economy is showing improvements where people are spending more. The anticipated expenditures total $1,755,341 leaving approximately $1,661,277 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 2014 included server and computer upgrades, squad lease and equipment, seal coating and crack filling, sign replacement, copier, mailer and Cloverdale Park improvements. Fire equipment included replacing turnout gear. The enterprise funds purchased a line tracer and spent funds televising and repairing sewer lines. - Other projects include the EDA funding for a hotel study, commercial lot development/redevelopment and continued façade storefront grants. Also included under EDA is the federal DEED grant for home improvements. Council approved studies for Facilities, Aquatic amenities and power pole relocation. - SEH has been busy with Park Terrace improvements, Water Tower refurbishment, Main Lift Station improvements and wrapping up the 2013 projects. The 2015 project planning began also. Engineering is also involved in the new developments and cellular antenna upgrades. It has been a busy project year for SEH. BUDGET/FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action – Quarterly and December Financial Reports 4th Quarter Reports: Cash Position as of 12/31/14 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 December 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, Minnesota Cash Position As of 12/31/14 Sentry BankMaturity DateInterestCurrent Balance# Securities% of Total Checking Account (Reconciled)N/A0.15%91,041$ N/A Money Market SavingsN/A0.50%1,104,781 N/A Bank Certificates of Deposit19-24 months0.98% 2100,000 avg averages22 months0.52% Total Sentry Bank$1,295,82121% Central MN Credit Union Share Savings AccountN/A0.00%35$ N/A Money Market SavingsN/A0.20%15,648 N/A Power Money Market CheckingN/A0.20%12,551 N/A Jumbo Bank Certificates of Deposit4-39 months0.93% 42,322,200 avg averages16 months0.69% Total CMCU$2,350,43437% Total Deposits3,646,255$ Morgan Stanley Smith Barne y Brokered Money Market SavingsN/A0.01%288$ N/A Government Securities/Notes97 months1.50% 1787,400 avg Brokered Certificates of DepositTiered 10-79 months1.83% 141,870,493 avg averages44 months1.80% Total SB$ 42%2,658,181 Total Investments2,658,181$ Total Deposits and Investments$6,304,436 Average Interest APY27 months1.00% 2014 YTD Cash Held With Fiscal Agent - Northland SecuritiesInterest Earned (2012A Crossover Refunding Bonds) Brokered Money Market SavingsN/A0.00% -$185,066 avg Total Cash Held With Fiscal Agent$- Total Deposits, Investments & Cash w/Fiscal Agent$ Cash and Investment Balance6,304,436 Petty Cash AdministrationN/AN/A200$ Police DepartmentN/AN/A75 Total Petty Cash$275 : All deposits and investments insured by FDIC/SPIC/NCUA or secured by perfected pledged collateral. Custodial Credit Risk Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highly 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. : There are no instruments exposed to credit risk. Credit Risk Maturity Concentration of Credit Risk: The City invests in various instruments and several financial institutions. % SecuritiesAverages Brokered Money Markets288$ 0.00%N/A Brokered Certificates of Deposit1,870,493$ 29.67%1.7 years Government Bonds/Notes787,400$ 12.49%4.0 years State/Local Government Securities-$ 0.00%N/A Foreign Currency Risk: The City only invests in USA and USA territories. ağƩƉĻƷ {ĻĭǒƩźƷźĻƭ {ğǝźƓŭƭ aƚƓĻǤ ağƩƉĻƷ /5ƭ DƚǝĻƩƓƒĻƓƷ /5ƭ .ƩƚƉĻƩĻķ.ƩƚƉĻƩĻķ /ŷĻĭƉźƓŭ aƚƓĻǤ .ğƓƉ ЌБі Ͳ ЋͲЍЋЋͲЋЉЉ ЊБі Ͳ ЊͲЊЌЌͲЉЊЎ IƚƌķźƓŭƭ Њі Ͳ ВЊͲЉЍЊ LƓǝĻƭƷƒĻƓƷ ğƓķ /ğƭŷ Љі Ͳ ЌЉі ЋББ Ͳ ЊͲБАЉͲЍВЌ ЊЌі Ͳ АБАͲЍЉЉ $ (71,226) (229,492) (41,338) (299,145) (8,502) (3,256) (179) (703,753) (2,070,734) (56,829) (37,767) (376,384) 3,540 332,854 54,575 52,880 2,438 FUNDCASH BALANCE14 EXP BUD14 SPENT14 LEFT14 BUD REV14 RECEIVED14 LEFT $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2,499,296 278,440 360,087 41,338 299,145 8,502 3,256 8,559 1,589,608 2,070,734 56,829 37,767 1,554,554 990,066 232,450 66,250 50,587$ 10,147,469 $ $ 2,428,070$ 281,980$ 130,595$ 8,380$ 885,855$ 1,178,170$ 1,322,920$ 287,025$ 119,130$ 53,025 $ -$ -$ -$ -$ -$ -$ - $ (77,539) (257,337) (37,429) (145,887) (3,995) (485,892) (1,434,262) (355,050) (4,951,728) (987,410) 86,187 27,292 42,285 170,791 7,166 - - Cash Balances by Fund/Remaining Budget 0.5 months of cash balance City of St. Joseph, Minnesota $ 2,410,079 210,793 387,932 37,429 145,887 23,108 3,995 2,002,852 1,518,342 355,050 6,394,498 2,516,465 293,900 87,074 45,859$ 16,433,263 As of 12/31/14 - - $ 2,332,540 1,442,770 296,980 130,595 50,400 1,516,960 84,080 1,529,055 336,185 257,865 53,025 - - - - - - (69,429)2014 cash increase(1,692,471) 1,294,498561,21384,14018,0631,426,02640,0553,21039,4211,653,0901,063,65657,393268,772303,724225,849226,0508,7047,204,43612/31/13 Cash Balance8,896,907 $ State Collected Sales Tax Refuse/Compost Fund Capital Project Funds Revolving Loan Fund Charitable Gambling Sewer Access Fund Water Access Fund TOTALS Street Light Utilit y Park Dedication General Fund Storm Sewer Sewer Fund Debt Funds Water Fund EDA FundTIF Funds Fire Fund Budget Budget Actual Actual RevRev ExpExp $278,440 $281,980 Fund Revenues FundFire $347,369 & $296,980 Expenditures Actual $2,499,296 to Budget $2,428,070 General Fire $2,410,079 & General $2,332,540 $3,000,000$2,500,000$2,000,000$1,500,000$1,000,000$500,000 $ wĻǝĻƓǒĻ 9ǣƦĻƓƭĻ υЊͲЊЋЎͲЊЋЍ υЊͲЋЉЉͲЉЉЉ υВВЉͲЉЏЏ υББЌͲВЎЋ υВЋЍͲЉЎЍ υЊͲЉЉЉͲЉЉЉ υБЉЉͲЉЉЉ Activity Funds υЏЉЉͲЉЉЉ Enterprise υЍЉЉͲЉЉЉ υЋВЌͲВЉЉ υЋЌЋͲЍЎЉ υЋЉЉͲЉЉЉ υБАͲЉАЍ υЏЏͲЋЎЉ υЎЉͲЎБА υЍЎͲБЎВ υ LightWaterWater Sewer Refuse Street Storm City of St. Joseph Quarterly Water Fund Analysis As of December 31, 201 4 Fund 601+501, Water/WAC Fund Balance as of December 31, 201(audited)$ 88,093.51 3 WAC fees collected for: 437-7th Ave SE - partial \[$5000 credit\] Year to Date Revenue: Interest Earnings25,605.80 *Kennedy expansion - partial Water Usage Charge399,684.32Millstream Villages 8-plex - deferred charges due Water Line Charge192,718.17323 Lanigan Way - Partial \[$5000 credit\] Penalties/Other Usage Fees8,953.49 20-17th Ave SE - partial past hookup due WAC/Trunk Fees59,613.11 1215 Minnesota St - past hookup due Antenna Lease Revenue33,042.84 1314 Minnesota St - partial past hookup due Bulk Water Sales1,140.80 130 Colman Ct Net Bond Proceeds651,806.45126 Colman Ct Transfers from other Funds200,000.00434-7th Ave SE - partial \[$5000 credit\] Total Revenue1,572,564.9878.15%budget collected 2014 Revenue Budget1,178,170.00 (includes fund 501) (excludes bond proceeds) Year to Date Expenses by Department: Debt Payments(643,342.76) * Transfers to Other Funds(131,178.00)Water Tower Bond Summary - as of 12/31/14: Power and Pumping(12,966.03) Bond issue, net651,806.45 Water Treatment Plant 1(16,050.47) Sewer project portion(83,753.00) Water Treatment Plant 2(83,863.56) Engineering(62,591.81) Distribution(2,936.78) Legal(526.50) Wellhead Protection(408.81) Project costs(484,452.18) Water Tower(551,391.48)Remaining Balance20,482.96 Water Maintenance(199,310.00) Water Administration(31,246.67) Total Expenses(1,672,694.56)103.91%budget expensed 2014 Expense Budget(1,082,770.00) (excludes depreciation) (excludes water tower project) Fund Summary as of December 31, 2014: Water Fund Cash Balance - Fund 601+501 - unaudited $(12,036.07) Fund 501$ 57,392.53 Fund 601$(69,428.60) * Amounts exclude activity recorded in the bond escrow fund for the 2012A crossover refunded bonds. The balances represent the cash balance as of 12/31/14. Remaining Unallocated Sales Tax through 2018 Est. Remaining CR 133/College Ave Sidewalks General Fund/Rec Center Fund Transfer General Fund/Rec Center Fund Transfer 1,755,341.19 Parks and Trails1,390,248.831,755,341.19 CR2/3 Trail Extension Phase I433,300.04 CR2 Trail Extension Phase II/III664,917.40 CR133/College Ave Sidewalk Project193,229.82Facilities364,506.5611,000,000 Fund Balance as of December 31, 201 Parks and Rec survey/system plan43,358.50Parks Boundary Survey8,272.75 Centennial Park Swingset33,284.14 Wobegon Center Upgrades13,886.18 Board Stipends585.80 Other585.80 364,506.5 Est. Remaining CR 2 Trail, Phase II/III 4 Transportation- 6 Est. Remaining CR 2/3 Trail, Phase I Remaining Sales Tax through 2018 Other earnings/transferred/expensed Projects funded (includes estimated remaining): Spent as of December 31, 2014 $ Sales Tax Exemption approved Nov. 2014 Projected Sales Tax Projected Sales Tax Sales Tax Collected Sales Tax received Sales Tax Spent Anticipated revenue 2019-2038: (1,085,755.39)(2,465,806.41) (1,085,755.39)(661,000.00) (7,500.00) (500.00) 2,465,806.411,426,025.77 3,372,754.00 3,372,754.001,661,276.69 906,947.59 43,278.08 2,696.67 43,278.08 Plannin g y Facilit 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 (Unaudited)1,426,025.77 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 1,297,612.6 Opening Fund 2006- 4 St. Joseph 1/2 Cent Sales Tax Committee 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 Park and Trail System Plan(42,079.24)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)2012 CR 133/College Ave trail extension(16,831.32)2013 CR 2/3 trail extension-Phase I(80,237.25)2013 Wobegon Center Upgrades(13,886.18)2014 CR 2 Trail Extension - Phase II/III(1,813.15) 2008 Parks and Recreation Survey(1,279.26)2008 Parks Boundary Survey(8,272.75)2011 CR 133/College Ave trail extension(2,878.30)2013 CR 2 Trail Extension - Phase II(1,538.15)2014 CR 133/College Ave Sidewalks(1,434.80) 2008 Meeting Stipends(420.00)2009 Meeting Stipends(165.80)2013 CR 2 Trail Extension - Phase III(566.10) 2006 Sales Tax Receipts Collected190,471.222007 Sales Tax Receipts Collected237,927.002008 Sales Tax Receipts Collected251,015.222009 Sales Tax Receipts Collected242,011.632010 Sales Tax Receipts Collected270,108.802011 Sales Tax Receipts Collected299,571.592012 Sales Tax Receipts Collected314,646.752013 Sales Tax Receipts Collected360,909.002014 Sales Tax Receipts Collected299,145.20 2007 Interest Earnings12,081.682007 Transfer from the General Fund24,003.732008 Interest Earnings21,468.302009 Interest Earnings33,184.402010 Interest Earnings20,287.652013 Transfer from Rec Center Fund - Facilities19,274.35 2006 Interest Earnings2,696.642014 CR 2/3 trail extension-Phase I6,504.71 As of December 31, 2014 audited ) ( Balance as of December 31, 2011 Cash Balances Only Current Period: December 2014 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance Last Dim 10100 GeneralG 101-10100$1,214,534.57$1,086,538.77$197,319.51$1,233,752.03 Employee Retirement ReserveG 102-10100$0.00$0.00$0.00$46,230.00 Fire FundG 105-10100$487,027.32$760.61$23,200.57$561,213.11 Cable Access FeeG 108-10100$6,152.02$704.38$0.00$14,515.81 Economic DevelopmentG 150-10100$116,317.66$47,494.57$104,942.43$84,140.41 TIF 2-1 MillstreamG 157-10100$14,115.17$14,946.97$13,447.37$17,945.37 TIF 2-2 Meat MarketG 158-10100$34.13$2,015.71$1,914.92$118.07 State Collected Sales TaxG 200-10100$1,340,119.29$35,622.39$69.50$1,426,025.77 Park DedicationG 205-10100$54,660.10$28.38$210.16$40,054.50 Charitable GamblingG 215-10100$3,947.46$1.08$0.01$3,210.38 Revolving Loan FundG 250-10100$30,853.05$686.36$0.15$39,420.83 2009A CrossoverRefunding BoG 318-10100$378,931.21$84,296.95$1.75$345,419.36 2007 Refunding (98/99 St BonG 320-10100$90,198.50$19,704.56$0.00$0.00 City Hall Refunded, 2005G 322-10100$3,801.11$44,377.45$0.07$87.25 2011A Refunding Fire HallG 331-10100$96,884.08$11,628.77$0.24$73,237.41 2010B Refundin (Hill/Clover)G 333-10100$279,471.00$25,827.99$248.80$259,253.00 2011A CO Refund (Interior StsG 338-10100$149,631.78$54,157.27$0.34$148,380.86 2007 St Imprv-E Side/Jade/8 AG 341-10100$451,442.33$8,863.84$0.00$0.00 2009B GO CIP BondsG 343-10100$5,161.41$31,360.99$0.06$7,227.93 2010 Equipment CertificatesG 344-10100$3,597.49$15,728.63$0.04$5,395.06 2010B Street Impr (16th Ave)G 345-10100$215,136.47$37,833.76$0.87$224,736.42 2011A Pumper Truck CertificatG 346-10100$1,559.67$10,091.46$0.00$2,862.56 2011A GO CIP BondsG 347-10100$12,286.67$10,386.46$0.72$13,540.43 2013 Street Improve BondsG 348-10100$85,292.99$5,842.35$0.77$88,202.05 2013 Equipment CertificatesG 349-10100$5,190.81$25,328.46$0.13$3,288.58 2014 Street Impr \[ParkTerraceG 350-10100$0.00$10,331.92$4.01$192,427.50 Debt Service ReliefG 390-10100$288,442.46$2,886.48$0.00$289,031.21 2011A GO CIP BondsG 447-10100$174,042.45$0.00$0.00$174,042.45 2013 Imp Cedar/Baker/RidgewG 448-10100$105,698.76$0.00$0.00$102,955.76 2013 Equipment CertificatesG 449-10100$200,495.55$0.00$0.00$0.00 2014 Imp Park TerraceG 450-10100$0.00$0.00$6,796.80$545,623.98 Capital OutlayG 490-10100$202,751.95$0.00$0.00$241,034.30 Water ExtensionG 501-10100$44.48$34,642.82$0.09$57,392.53 Sewer ExtensionG 502-10100$585,859.32$18,783.25$1.98$268,771.85 Water FundG 601-10100$3,590.04$97,412.97$41,789.84-$69,428.60 Sewer FundG 602-10100$1,829,479.67$92,651.54$75,210.53$303,724.36 Refuse CollectionG 603-10100$254,336.58$29,934.07$25,990.01$225,849.34 Storm Water UtilityG 651-10100$205,799.32$12,351.02$2,613.33$226,050.40 Street Light UtilityG 652-10100$20.14$11,929.58$10,260.86$8,703.80 Last Dim 10100$8,896,907.01$1,885,151.81$504,025.86$7,204,436.07 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 Last Dim 10300 Water FundG 601-10300$4,682,985.00$9,973.87$0.00$0.00 Last Dim 10300$4,682,985.00$9,973.87$0.00$0.00 $13,580,167.01$1,895,125.68$504,025.86$7,204,711.07 Council Month End Revenue Summary Current Period: December 2014 2014December2014 FUNDFUND DescrYTD Budget2014 AmtYTD Amt 101General$2,420,620.00$1,066,090.09$2,445,270.55 102Employee Retirement Reserve$0.00$0.00$46,230.00 105Fire Fund$281,980.00$721.03$278,439.57 108Cable Access Fee$7,450.00$704.38$7,795.78 150Economic Development$130,595.00$47,493.94$360,086.92 157TIF 2-1 Millstream$0.00$14,946.90$37,306.97 158TIF 2-2 Meat Market$0.00$2,015.71$4,031.17 200State Collected Sales Tax$0.00$35,622.39$299,145.20 205Park Dedication$0.00$28.22$8,501.53 215Charitable Gambling$0.00$1.07$3,256.44 250Revolving Loan Fund$8,380.00$686.21$8,559.02 3182009A CrossoverRefunding Bonds$219,545.00$84,295.20$299,447.18 3202007 Refunding (98/99 St Bond)$30,340.00$19,704.56$44,789.40 322City Hall Refunded, 2005$94,100.00$44,129.88$93,466.38 3312011A Refunding Fire Hall$52,445.00$11,628.53$52,300.49 3332010B Refundin (Hill/Clover)$101,630.00$25,826.69$119,270.43 3382011A CO Refund (Interior Sts)$53,860.00$54,156.93$138,653.23 3412007 St Imprv-E Side/Jade/8 Av$54,250.00$8,863.84$25,689.13 3432009B GO CIP Bonds$66,800.00$31,360.93$66,445.95 3442010 Equipment Certificates$33,500.00$15,728.59$33,349.09 3452010B Street Impr (16th Ave)$37,830.00$37,832.89$76,218.23 3462011A Pumper Truck Certificate$43,935.00$10,091.46$42,935.57 3472011A GO CIP Bonds$22,240.00$10,385.74$24,476.38 3482013 Street Improve Bonds$21,130.00$5,841.58$15,040.13 3492013 Equipment Certificates$54,250.00$25,328.33$54,767.45 3502014 Street Impr \[ParkTerrace\]$0.00$10,327.91$274,232.41 390Debt Service Relief$0.00$2,886.48$228,526.21 4472011A GO CIP Bonds$0.00$0.00$0.00 4482013 Imp Cedar/Baker/Ridgewood$0.00$0.00$0.00 4492013 Equipment Certificates$0.00$0.00$0.00 4502014 Imp Park Terrace$0.00$0.00$1,986,653.80 490Capital Outlay$0.00$0.00$84,080.00 501Water Extension$0.00$34,642.73$56,828.92 502Sewer Extension$0.00$18,781.27$37,767.10 601Water Fund$1,178,170.00$93,598.45$1,554,554.36 602Sewer Fund$1,322,920.00$92,614.40$990,066.06 603Refuse Collection$287,025.00$28,683.60$232,450.43 651Storm Water Utility$119,130.00$12,350.06$66,250.35 652Street Light Utility$53,025.00$7,928.10$50,587.15 $6,695,150.00$1,855,298.09$10,147,468.98 Council Month End Revenue -General Fund Current Period: December 2014 2014December2014 FUNDFUND DescrSOURCE DescrYTD Budget2014 AmtYTD Amt FUND 101 General 101GeneralCurrent Ad Valorem Taxes$1,087,245.00$572,532.15$1,142,635.57 101GeneralSpecial Levy- City St. Joe$0.00$0.00$0.00 101GeneralState Sales Tax$0.00$0.00$0.00 101GeneralGas Franchise$28,000.00$0.00$20,870.43 101GeneralElectric Franchise$52,000.00$3,657.09$46,039.44 101GeneralBeer$375.00$230.00$510.00 101GeneralLiquor$24,000.00$3,450.00$22,260.00 101GeneralOutdoor Liquor Permit$2,500.00$0.00$150.00 101GeneralGambling Permits$120.00$0.00$235.00 101GeneralAmusement/Hunting Permit$1,000.00$385.00$1,355.00 101GeneralExcavation Permit$300.00$0.00$2,450.00 101GeneralCigarette License$525.00$75.00$525.00 101GeneralCable Franchise Fee$30,000.00$1,389.75$26,632.62 101GeneralBuilding Permits$45,000.00$27,602.82$52,022.11 101GeneralAnimal License$3,150.00$30.00$3,220.00 101GeneralRental Housing Registration$22,000.00$0.00$21,554.50 101GeneralFederal Grants - Other$5,000.00$0.00$7,000.61 101GeneralState Grants and Aids$0.00$950.00$950.00 101GeneralLocal Government Aid$873,160.00$436,586.00$873,172.00 101GeneralPERA Rate Increase Aid$1,540.00$770.50$1,541.00 101GeneralPolice Training Reim$3,500.00$0.00$2,896.29 101GeneralState Municipal Funds Aid$6,180.00$0.00$7,545.00 101GeneralState Police Aid$48,000.00$0.00$55,150.22 101GeneralOther Grants/Aids$250.00$0.00$0.00 101GeneralOther Governmental Unit$10,000.00$0.00$10,000.00 101GeneralCounty Grants - Road Maint.$7,750.00$8,520.03$8,520.03 101GeneralZoning and Subdivision Fee$1,000.00$0.00$1,300.00 101GeneralLand Use Deposit Fee$4,000.00$0.00$6,885.00 101GeneralSale of Maps and Publications$50.00$0.00$52.75 101GeneralAssessments Search$2,500.00$120.00$1,770.00 101GeneralSpecial Hearing$4,500.00$0.00$3,850.00 101GeneralAdministration Reimb$11,600.00$0.00$176.32 101GeneralWeed Cutting$1,000.00$0.00$500.00 101GeneralPark Fees$5,500.00$0.00$5,040.00 101GeneralBall Field Donation$500.00$0.00$0.00 101GeneralSchneider Field Rental$2,700.00$0.00$855.00 101GeneralKennel Fees$500.00$40.00$556.00 101GeneralCounty Fines$27,000.00$1,764.20$24,064.86 101GeneralPolicy Fines$35,000.00$1,445.00$11,175.00 101GeneralAccident Report Fee$1,000.00$45.75$1,014.75 101GeneralSeized Property$500.00$0.00$3,090.00 101GeneralSpecial Assessments$1,500.00$698.77$5,174.91 Council Month End Revenue -General Fund Current Period: December 2014 2014December2014 FUNDFUND DescrSOURCE DescrYTD Budget2014 AmtYTD Amt 101GeneralInterest Earnings$15,000.00$263.13$15,386.97 101GeneralInterest Charges$100.00$0.00$613.13 101GeneralCo-op Dividend - LMCIT$15,000.00$10,746.35$10,746.35 101GeneralWater Tower Antenna Lease$3,550.00$468.51$3,671.52 101GeneralAdvertising$2,000.00$230.00$1,320.00 101GeneralContributions - General$1,500.00$0.00$1,000.00 101GeneralContribution - Health Ins Div$0.00$0.00$0.00 101GeneralContributions - Parks$1,000.00$4.00$2,681.46 101GeneralSurplus Property$0.00$0.00$0.00 101GeneralReimbursement$32,025.00-$1,913.96$30,140.68 101GeneralTransfers from Other Funds$0.00-$4,000.00$6,971.03 FUND 101 General$2,420,620.00$1,066,090.09$2,445,270.55 FUND 102 Employee Retirement Reserve 102Employee Retirement ResInterest Earnings$0.00$0.00$0.00 102Employee Retirement ResTransfers from Other Funds$0.00$0.00$46,230.00 FUND 102 Employee Retirement Reserve$0.00$0.00$46,230.00 FUND 108 Cable Access Fee 108Cable Access FeeCable Franchise Fee$7,450.00$704.38$7,795.78 108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00 FUND 108 Cable Access Fee$7,450.00$704.38$7,795.78 FUND 150 Economic Development 150Economic DevelopmentCurrent Ad Valorem Taxes$130,095.00$67.70$69,947.38 150Economic DevelopmentFederal Grants - Other$0.00$47,375.00$271,636.00 150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$16,751.78 150Economic DevelopmentDEED Housing Reimbursement$0.00$0.00$0.00 150Economic DevelopmentInterest Earnings$500.00$51.24$1,751.76 150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00 FUND 150 Economic Development$130,595.00$47,493.94$360,086.92 $2,558,665.00$1,114,288.41$2,859,383.25 Council Month End Revenue -Enterprise Funds Current Period: December 2014 FUND2014December2014 FUNDDescrSOURCE DescrYTD Budget2014 AmtYTD Amt FUND 601 Water Fund 601Water FundPenalties and Forfeited Disc$7,190.00$701.05$8,953.49 601Water FundBond Premium Proceeds$0.00$0.00$10,602.45 601Water FundGeneral Oblig. Bond Proceeds$0.00$0.00$660,000.00 601Water FundTransfers from Other Funds$337,500.00$0.00$200,000.00 601Water FundContributed Revenue$0.00$0.00$0.00 601Water FundMDS Test Fee$11,645.00$1,131.52$8,917.25 601Water FundCurrent Ad Valorem Taxes$0.00$1,851.60$0.00 601Water FundWater Meter$5,000.00$1,460.00$3,132.80 601Water FundConnection/Reconnection fees$500.00$0.00$50.00 601Water FundUndesignated Funds$0.00$1,472.64-$1,839.97 601Water FundInterest Earnings$35,990.00$10,703.26$45,279.49 601Water FundWater Line Charge$239,785.00$26,843.01$192,718.17 601Water FundSpecial Assessments$800.00$2,687.42-$91.42 601Water FundBulk Water$1,000.00$0.00$1,140.80 601Water FundAmortization of Bond Premium$0.00$0.00$0.00 601Water FundWater Tower Antenna Lease$33,005.00$4,216.49$33,042.84 601Water FundSurplus Property$0.00$0.00$0.00 601Water FundReimbursement$0.00$0.00$74.80 601Water FundRate Class One$505,530.00$44,219.89$395,252.31 601Water FundState Sales Tax$225.00-$1,688.43-$2,678.65 FUND 601 Water Fund$1,178,170.00$93,598.45$1,554,554.36 FUND 602 Sewer Fund 602Sewer FundSanitary Sewer Service$433,200.00$54,257.13$316,299.00 602Sewer FundOther Governmental Unit$0.00$2,827.50$2,827.50 602Sewer FundSpecial Assessments$350.00$1,929.29-$261.20 602Sewer FundInterest Earnings$5,075.00$197.98$23,629.61 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 FundReimbursement$3,000.00$0.00$0.00 602Sewer FundPenalties and Forfeited Disc$4,145.00$396.84$5,470.38 602Sewer FundSewer Line Charge$269,400.00$33,005.66$206,347.77 602Sewer FundTransfers from Other Funds$607,750.00$0.00$435,753.00 602Sewer FundGeneral Oblig. Bond Proceeds$0.00$0.00$0.00 602Sewer FundBond Premium Proceeds$0.00$0.00$0.00 602Sewer FundContributed Revenue$0.00$0.00$0.00 FUND 602 Sewer Fund$1,322,920.00$92,614.40$990,066.06 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$77.86$3,509.81 603Refuse CollecSpecial Assessments$500.00$239.45-$122.75 603Refuse CollecRefuse Collection Charges$258,150.00$26,677.15$208,797.76 603Refuse CollecLicenses & Permits$18,875.00$0.00$16,740.00 603Refuse CollecState Sales Tax$0.00$1,343.71-$2,651.20 603Refuse CollecPenalties and Forfeifted Disc$5,500.00$345.43$6,176.81 FUND 603 Refuse Collection$287,025.00$28,683.60$232,450.43 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 Council Month End Revenue -Enterprise Funds Current Period: December 2014 FUND2014December2014 FUNDDescrSOURCE DescrYTD Budget2014 AmtYTD Amt 651Storm Water Penalties and Forfeifted Disc$2,000.00$83.79$1,630.26 651Storm Water Special Assessments$350.00$2,465.89-$15,114.31 651Storm Water Development Fee$20,000.00$0.00$0.00 651Storm Water Reimbursement$0.00$0.00$0.00 651Storm Water Interest Earnings$550.00$78.25$3,168.91 651Storm Water Rate Class One$96,230.00$9,722.13$76,565.49 FUND 651 Storm Water Utility$119,130.00$12,350.06$66,250.35 FUND 652 Street Light Utility 652Street Light UTransfers from Other Funds$0.00$0.00$0.00 652Street Light USpecial Assessments$25.00$41.88$29.11 652Street Light UInterest Earnings$100.00$3.29$28.45 652Street Light URate Class One$52,700.00$7,882.93$50,529.59 652Street Light UPenalties and Forfeited Disc$200.00$0.00$0.00 FUND 652 Street Light Utility$53,025.00$7,928.10$50,587.15 $2,960,270.00$235,174.61$2,893,908.35 Council Month End Expenditure - Summary Current Period: December 2014 2014December2014 DescriptionYTD Budget2014 Amt YTD Amt General$2,332,540.00$178,180.00$2,409,928.79 Employee Retirement Reserve$0.00$0.00$0.00 Fire Fund$296,980.00$23,160.99$210,792.84 Cable Access Fee$8,500.00$0.00$150.31 Economic Development$130,595.00$104,941.80$387,932.15 TIF 2-1 Millstream$0.00$13,447.30$33,481.33 TIF 2-2 Meat Market$0.00$1,914.92$3,947.30 State Collected Sales Tax$0.00$69.50$145,886.86 Park Dedication$50,400.00$210.00$23,108.36 Charitable Gambling$0.00$0.00$3,995.03 Revolving Loan Fund$0.00$0.00$0.00 2009A CrossoverRefunding Bon$354,900.00$0.00$354,700.00 2007 Refunding (98/99 St Bond$120,170.00$0.00$135,786.02 City Hall Refunded, 2005$97,985.00-$247.50$97,582.50 2011A Refunding Fire Hall$76,150.00$0.00$76,047.50 2010B Refundin (Hill/Clover)$139,550.00$247.50$139,595.00 2011A CO Refund (Interior Sts)$141,980.00$0.00$141,877.50 2007 St Imprv-E Side/Jade/8 A$291,670.00$0.00$477,237.28 2009B GO CIP Bonds$64,800.00$0.00$64,645.00 2010 Equipment Certificates$31,850.00$0.00$31,650.00 2010B Street Impr (16th Ave)$66,855.00$0.00$66,655.00 2011A Pumper Truck Certificate$42,010.00$0.00$41,660.00 2011A GO CIP Bonds$23,670.00$0.00$23,320.00 2013 Street Improve Bonds$9,870.00$0.00$12,087.50 2013 Equipment Certificates$55,500.00$0.00$56,625.00 2014 Street Impr \[ParkTerrace\]$0.00$0.00$81,804.91 Debt Service Relief$0.00$0.00$201,578.30 2011A GO CIP Bonds$0.00$0.00$0.00 2013 Imp Cedar/Baker/Ridgew$0.00$0.00-$9,659.81 2013 Equipment Certificates$0.00$0.00$50,174.69 2014 Imp Park Terrace$0.00$6,796.80$1,441,029.82 Capital Outlay$84,080.00$0.00$36,797.65 Water Extension$0.00$0.00$0.00 Sewer Extension$0.00$0.00$355,050.00 Water Fund$1,442,770.00$28,001.45$6,394,497.86 Sewer Fund$1,529,055.00$75,173.39$2,516,465.43 Refuse Collection$336,185.00$24,739.54$293,899.75 Storm Water Utility$257,865.00$2,612.37$87,074.47 Street Light Utility$53,025.00$2,259.38$45,858.71 $8,038,955.00$461,507.44$16,433,263.05 Council Month End Expenditure - General Fund Current Period: December 2014 2014December2014 DescriptionDEPART DescrYTD Budget2014 Amt YTD Amt FUND 101 General GeneralCouncil$49,550.00$2,185.02$43,779.41 GeneralLegislative Committees$6,020.00$140.00$3,180.33 GeneralOrdinance & Proceedings$1,350.00$256.50$1,916.61 GeneralMayor$10,995.00$1,050.10$10,556.94 GeneralElections$3,000.00$104.77$5,722.45 GeneralGeneral Adminstration$221,425.00$15,219.02$203,076.13 GeneralFinance$118,970.00$7,767.73$114,388.03 GeneralAudit Service$25,950.00$0.00$25,950.00 GeneralAssessing$23,500.00$0.00$22,359.15 GeneralCity Attorney$17,000.00$313.00$25,369.97 GeneralPlanning and Zoning$7,400.00$747.47$11,022.72 GeneralGeneral Government$19,080.00$1,513.29$19,626.15 GeneralCity Offices$28,945.00$1,788.75$28,169.64 GeneralFacilites and Planning$0.00$0.00$0.00 GeneralCable Access$11,065.00$830.60$9,889.16 GeneralCrime Control & Investigation$908,340.00$84,504.92$851,040.50 GeneralPolice Training$7,650.00$343.07$7,495.55 GeneralCommunication Service$11,185.00$895.34$9,850.79 GeneralAutomotive Services$51,100.00$6,661.25$48,039.30 GeneralBuilding Inspec. Admistration$92,000.00$7,500.00$83,694.04 GeneralEmergency Management$1,280.00$1,216.86$2,711.15 GeneralSignal Lights CSAH 75$0.00$87.96$87.96 GeneralAnimal Control$950.00$0.00$793.11 GeneralStreet Maintanence$239,205.00$13,133.54$249,583.91 GeneralIce & Snow Removal$97,570.00$7,506.47$113,915.52 GeneralEngineering Fee$30,000.00$11,335.62$64,813.87 GeneralStreet Cleaning$15,660.00$0.00$8,643.94 GeneralSkate Park and Ice Rink$3,345.00$44.00$2,124.31 GeneralBall Park$1,750.00$0.00$1,691.41 GeneralMaintenance Shop$18,085.00$2,292.27$20,969.39 GeneralPark Areas$213,270.00$10,742.45$190,421.91 GeneralCommunity Support$0.00$0.00$0.00 GeneralOther Financing Uses$0.00$0.00$128,390.00 GeneralFire Protection$96,900.00$0.00$100,655.44 FUND 101 General$2,332,540.00$178,180.00$2,409,928.79 FUND 102 Employee Retirement Reserve Employee Retirement ReservGeneral Adminstration$0.00$0.00$0.00 FUND 102 Employee Retirement Reserve$0.00$0.00$0.00 FUND 108 Cable Access Fee Cable Access FeeCable Access$8,500.00$0.00$150.31 FUND 108 Cable Access Fee$8,500.00$0.00$150.31 Council Month End Expenditure - General Fund Current Period: December 2014 2014December2014 DescriptionDEPART DescrYTD Budget2014 Amt YTD Amt FUND 150 Economic Development Economic DevelopmentEconomic Development Authority$130,595.00$104,941.80$387,932.15 Economic DevelopmentOther Financing Uses$0.00$0.00$0.00 FUND 150 Economic Development$130,595.00$104,941.80$387,932.15 FUND 450 2014 Imp Park Terrace 2014 Imp Park TerraceStreet Maintanence$0.00$6,796.80$1,418,388.87 2014 Imp Park TerraceOther Financing Uses$0.00$0.00$22,640.95 FUND 450 2014 Imp Park Terrace$0.00$6,796.80$1,441,029.82 FUND 490 Capital Outlay Capital OutlayGeneral Adminstration$4,750.00$0.00$7,857.04 Capital OutlayGeneral Government$0.00$0.00$0.00 Capital OutlayCity Offices$0.00$0.00$0.00 Capital OutlayCrime Control & Investigation$4,400.00$0.00$335.77 Capital OutlayCommunication Service$6,275.00$0.00$2,467.50 Capital OutlayAutomotive Services$17,150.00$0.00$12,038.83 Capital OutlayEmergency Management$2,000.00$0.00$0.00 Capital OutlayStreet Maintanence$15,500.00$0.00$7,127.48 Capital OutlayIce & Snow Removal$7,000.00$0.00$0.00 Capital OutlayStreet Lighting$0.00$0.00$0.00 Capital OutlayStreet Cleaning$0.00$0.00$0.00 Capital OutlaySkate Park and Ice Rink$0.00$0.00$0.00 Capital OutlayMaintenance Shop$6,690.00$0.00$0.00 Capital OutlayPark Areas$20,315.00$0.00$0.00 Capital OutlayOther Financing Uses$0.00$0.00$6,971.03 FUND 490 Capital Outlay$84,080.00$0.00$36,797.65 $2,555,715.00$289,918.60$4,275,838.72 Council Month End Expense - Enterprise Funds Current Period: December 2014 2014December2014 DescriptionDEPART DescrYTD Budget2014 Amt YTD Amt FUND 601 Water Fund Water FundBond Payment (P & I)$664,090.00$0.00$5,365,146.06 Water FundOther Financing Uses$45,000.00$0.00$131,178.00 Water FundPower and Pumping$21,790.00$96.57$12,966.03 Water FundPurification-Plant 1$35,100.00$1,387.51$16,050.47 Water FundPurification-Plant 2$82,465.00$5,387.92$83,863.56 Water FundDistribution$10,000.00$988.80$2,936.78 Water FundWellhead Protection$2,000.00$0.00$408.81 Water FundStorage-Tower 1$5,120.00$362.52$551,391.48 Water FundWater Maintenance$179,915.00$18,442.46$199,310.00 Water FundAdministration and General$37,290.00$1,335.67$31,246.67 Water FundDepreciation Expense$360,000.00$0.00$0.00 FUND 601 Water Fund$1,442,770.00$28,001.45$6,394,497.86 FUND 602 Sewer Fund Sewer FundBond Payment (P & I)$230,620.00$0.00$227,333.13 Sewer FundOther Financing Uses$45,000.00$0.00$47,350.00 Sewer FundSanitary Sewer Maintenanc$228,165.00$12,196.63$174,023.35 Sewer FundLift Station-Baker Street$85,780.00$194.08$2,593.03 Sewer FundLift Station-Ridgewood/DBL$2,915.00$161.79$3,901.87 Sewer FundLift Station-Northland$4,995.00$127.53$1,904.85 Sewer FundLift Station-CR 121$5,295.00$1,124.59$2,858.74 Sewer FundLift Station-Main$673,270.00$58,982.06$2,019,837.21 Sewer FundAdministration and General$38,015.00$2,386.71$36,663.25 Sewer FundDepreciation Expense$215,000.00$0.00$0.00 FUND 602 Sewer Fund$1,529,055.00$75,173.39$2,516,465.43 FUND 603 Refuse Collection Refuse CollectioWaste Collection$336,185.00$24,739.54$293,224.75 Refuse CollectioOther Financing Uses$0.00$0.00$675.00 Refuse CollectioDepreciation Expense$0.00$0.00$0.00 FUND 603 Refuse Collection$336,185.00$24,739.54$293,899.75 FUND 651 Storm Water Utility Storm Water UtiOther Financing Uses$18,250.00$0.00$18,720.00 Storm Water UtiAdministration and General$12,785.00$383.56$10,687.90 Storm Water UtiStorm Water Maintenance$126,830.00$2,228.81$57,666.57 Storm Water UtiDepreciation Expense$100,000.00$0.00$0.00 FUND 651 Storm Water Utility$257,865.00$2,612.37$87,074.47 FUND 652 Street Light Utility Street Light UtiliStreet Lighting$53,025.00$6,259.38$45,858.71 Street Light UtiliOther Financing Uses$0.00-$4,000.00$0.00 FUND 652 Street Light Utility$53,025.00$2,259.38$45,858.71 Council Month End Expense - Enterprise Funds Current Period: December 2014 2014December2014 DescriptionDEPART DescrYTD Budget2014 Amt YTD Amt $3,618,900.00$132,786.13$9,337,796.22 ADM-1 24,542.4616,853.464,858.338,899.6813,811.4368,965.366,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.00339,711.71341,411.71 655,097.51 ProjectBudgetReserveTransferred/SpentBudgetRemaining 201420142014Balance 21,250.0029,825.0035,000.0010,000.0013,165.0088,505.00500.0033,000.0033,500.00 3,000.001,750.002,000.001,000.005,000.008,500.004,400.006,275.004,000.006,350.006,800.002,000.001,750.003,750.007,000.006,690.009,400.001,750.00 173,080.00 (302,018.44) (302,018.44) 12/31(203,765.68) 268.43150.3119,065.5712,038.8314,506.3357,553.3864,680.86 5,722.457,924.385,000.002,467.507,127.48 12/31through Summary (500.00)(4,550.00)(6,971.03)(4,000.00) 2013 500.00 7,091.407,091.404,550.0014,516.033,545.00 10,636.40 5, Availablethrough CodeEquipmentBalanceGrant December Plan Expenditures 2014 (370.00) 27,264.9115,871.8910,782.7168,189.5320,929.3813,400.4244,267.1842,334.9616,598.5146,846.8636,235.23999.89 7,399.686,870.346,689.821,204.952,412.611,500.007,250.006,000.00157,765.451,200.00608,730.15609,930.15 880,152.31 Improvement 31, adopted December Capital Final Total Public Works CIP Total Police CIPTotal EDA CIP Total Administration CI P Maintenance490-45201-580Maintenance Shop Equipment Capital Administration101-41910-300Planning Document Updates Street Sweeping490-43220-580Street Sweeping Equipment of Police-Communications490-42151-580Communication Equipment Snow Removal490-43125-580Snow Removal Equipment 2014 Administration490-41430-570Administration Equipment Budget As 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 CIP Streets490-43120-580Street Equipment 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 2014 DepartmentAccount ΛАВЏ͵ЉЎΜ ЌВЍ͵ЏЎ 394.65 ЏͲЎЊЍ͵ЋВ 6,514.29 ЊЎͲЎЏЋ͵ЍЉЋВͲЋЎВ͵ЎБЍВͲЌЋЌ͵ААЌАͲЋЎЉ͵ЉЉЌБͲЉЉЉ͵ЉЉЌВͲЋЎЉ͵ЉЉЋͲЉЉЉ͵ЉЉЋЋͲАББ͵ЏЎЌЍͲЉЉБ͵ЋЎЋͲЊЏЎ͵ЊЎЊͲЌЋА͵ЎА 1,327.57 ЌЉͲЋАЏ͵ВЋЊБͲВВЊ͵ВЋАͲЍЎЉ͵ЉЉ 15,562.40217,075.9536,173.4056,718.84333,767.10 12/31Available BudgetAdjustmentsSpentReserve CodeDepartmentObjectYearDescriptionFunds201420142014Funds ЏЉЎ͵ЌЎ 605.35 ЌͲБАБ͵БЎ 3,878.85 ЌͲАЋВ͵ЊЋ 3,729.128,213.32 of AvailableGrants/as ЋͲЉЉЉ͵ЉЉ 2,000.002,000.00 12/31 of 12/31/2013as ЊͲЉЉЉ͵ЉЉ 1,000.002,000.00 ЌͲЉЉЉ͵ЉЉЎͲЉЉЉ͵ЉЉАͲЎЉЉ͵ЉЉБͲЉЉЉ͵ЉЉЎͲЉЉЉ͵ЉЉЋͲЉЉЉ͵ЉЉЎͲЉЉЉ͵ЉЉЊͲЎЉЉ͵ЉЉ 3,000.00 ЎЉЉ͵ЉЉ 500.00 ЋͲЉЉЉ͵ЉЉЎЉЉ͵ЉЉ 36,000.00 ЊЉͲЉЉЉ͵ЉЉЎЉЉ͵ЉЉ 10,500.00 ЋЉЉ͵ЉЉ 200.00 ЎЉЉ͵ЉЉЊͲЉЉЉ͵ЉЉ 53,200.00 ΛЊͲЋВЏ͵ЉЎΜ ВͲБВЌ͵ЊЍ 9,893.14 ЊЌͲЎЏЋ͵ЍЉЋЏͲЋЎВ͵ЎБЍЍͲЌЋЌ͵ААЋВͲАЎЉ͵ЉЉЌЉͲЉЉЉ͵ЉЉЌЍͲЋЎЉ͵ЉЉЊВͲЎЊА͵ААЋЍͲЉЉБ͵ЋЎЊͲЏЏЎ͵ЊЎЊͲЊЋА͵ЎА 1,127.57 ЋБͲААЏ͵ВЋЊБͲЍВЊ͵ВЋЏͲЍЎЉ͵ЉЉ 13,562.40182,805.0725,673.4053,718.84286,780.42 PurchasedReserve 105-42220-584Fire FightingEquipment Reserve1996/2005Extrication Equip105-42250-580Fire CommunicationOther Equipment2007800 MHz Radios Equipment Reserven/aBuilding Repairs 105-42220-585Fire FightingFirefighter Equipment2001Ladder Truck #2 105-42220-585Fire FightingFirefighter Equipmentn/aReplacement105-42250-580Fire CommunicationOther Equipmentn/aReplacement105-42270-580Medical ServicesOther Equipmentn/aReplacement 105-42220-580Fire FightingOther Equipmentn/aTurnout Gear105-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 Equipment Reserve2011Sealcoating 105-42220-585Fire FightingFirefighter Equipment20126 Wheeler 105-42220-585Fire FightingFirefighter Equipment1999Tanker #4 105-42220-585Fire FightingFirefighter Equipment2013Air Packs Improvements other than Buildin2008Painting Buildin g Hardware/Software than other Improvements 2014 Equipment Reserve Budget Equipment Computer Payable Equipment Department Adopted December 5, 2013 EquipmentEquipment Capital Building Communications for Administration Other Services 105-42280-530Fire Station & Buildin105-42280-530Fire Station & Buildin105-42280-530Fire Station & Buildin Plan ggg 2014 & Fire FightingFightingFighting ImprovementStation Final Medical CǒƓ Joseph ķ Board CźƩĻ FireFireFireFireFireFire St. TotalTotalTotalTotal TotalTotalTotal LƒƦƩƚǝĻƒĻƓƷ Fire Capital /ğƦźƷğƌ Account ƚƷğƌ FD-1401FD-1402FD-1403FD-1405FD-1406FD-1407FD-1408FD-1409FD-1417FD-1410FD-1411FD-1412FD-1413FD-1415FD-1416 FD-140FD-141 CIP # 44 Plat, Center basket, Co. 3study, Professional Parkway Flats grant District Business & flower Sisters Bayou hotel 2013 TIF, TIF (165.19) EDA 341,411.71 1,700.0025,259.0010,514.599,210.80287,304.007,588.51 339,711.71 CodeNumberEquipmentBalance201420142014Balance ProjectProjectReserveBudgetTransfersSpent2014 Plan 2013 Expenditures Improvement Budget 5, December (302,018.44) (63.00)(130.77)(286,636.00)(2,248.60) (12,940.07)(302,018.44) 12/31 CIP CapitalFinal Capital 12/31through Adopted 2014 2014 Fund General Availablethrough 33,500.00 500.0015,000.0018,000.00 33,000.00 (165.19) 12/31/2013 609,930.15 1,200.0010,322.005,454.669,341.57573,940.009,837.11 608,730.15 Business Demolition Program CSAH 2/3 Collection Street CDBG Grant Development Business Development/TIF BFA Grant/Loan Program Rental Conversions Let's Go Downtown Computer Softwar e EDA-1301EDA-1302EDA-1307EDA-1308EDA-1309EDA-1303 EDA-130EDA-130 45 EDA150-46500-582EDA150-46500-588 DepartmentAccount TOTAL EDA CIP (1,005.14) (1,005.14) 1,750.002,500.006,250.008,750.0020,000.006,973.44 45,218.30 25,475.001,750.0099,102.182,300.005,200.00 165,038.56 40,137.4111,550.0075,350.5012,000.0075,000.00 214,037.91 3,000.00 3,000.00 2,000.00 2,000.00 30,000.00 9,416.526,500.0014,000.002,300.00 ProjectProjectReserveBudgetTransfersSpentAvailable CodeNumberEquipmentBalance201420142014Balance 12/312014 Works Public Budget (2,255.14)(1,457.00)(3,712.14)(6,897.00)(25,190.98)(2,272.78)(1,649.50)(3,922.28) (2,255.14)(16,038.84) 2013 Expenditures Plan 5, CIP of Improvement December 2014 12/31/2013Grants/as CapitalFinal 258.75 258.75 Adopted Enterprise Capital 2014 1,750.001,250.002,500.003,750.007,500.003,750.00 20,500.00 1,750.0020,000.002,300.002,200.00 40,300.00 1,000.001,000.008,000.005,000.00 15,000.00 1,500.00 1,500.00 1,000.00 1,000.00 1,250.0010,000.00500.002,300.00 Enterprise 28,430.44149,670.79202,960.191,500.001,000.0030,000.00 6,250.00Repairs5,000.00Replacement12,500.00Repairs4,680.44(1/2)25,475.00Lining85,999.1815,196.61Sampler6,000.0014,000.00Plan42,410.1910,550.00Improvements76,000.00Sweeper4,000.00Easements/Acquire70,0 00.00(1/4)1,500.00 LS3,000.00Lighting1,000.00 Certificates LLS S Ridgewood LS Northland (1/2) Foamin St g Programme CR121 Replacemen Baker r Management t SystemSystem Equipment Televising/Root pumpspumpspumpspumps Media Land Loader CommunicationsCommunications Meter Roof Mapping Quality WaterSite Filter SubmersibleSubmersibleSubmersible Submersible (1/4)(1/4) TracerTracer 2015/2018 #4/5 HandheldEnd Compost Property Water SewerSewer SewerAerialStreetStreet 112 Front TruckTruck Storm Well WTPWTPWTP LineLine 140714051401140814021403140314031403 14031405140114021403140414031403140714251407 1401 14011404140514061410 WTWTWTWTWTWTWT RF SL WWWWWWWWWWWWWWWWWWSSSSSSSS PWPWPW PW 550580580220580580580580580550530300580580580580580300530530580510580510580580 4944049440494904941049420494204942149450494504945049450494504948049471494704947249473499004990049900499004990043230432304316043120 DepartmentAccount 601601601601601601601602602602602602651651651651651603449 602602602602602603Lighting652 Stormwater Streets Refuse Water Sewer St. City of St. Joseph Park Board Capital Improvement Budget Summary 2014 Final Capital Budget Adopted December 5, 2013 Balance General Funds Park Dedication Cash December 31, 201440,055$ (Unaudited) Adjustments Starting Balance40,055$ Legacy Grant-$ PotentialProposed Potential Projects: Millstream Cottages-phase 223,400$ Ending Balance for 201440,055$ Projects - Budget201320142015201620172018Total 14-18 PTR-01 (Millstream)-$ -$ 25,000$ -$ -$ -$ 25,000$ PTR-02 (Northland)-$ -$ -$ -$ -$ -$ -$ PTR-03 (Klinefelter)-$ 4,000$ 71,000$ -$ -$ -$ 75,000$ PTR-04 (Wobegon)-$ -$ -$ -$ -$ -$ -$ PTR-05 (Memorial)-$ -$ -$ -$ -$ -$ -$ $ --$ -$ -$ -$ -$ -$ PTR-06 (Centennial) $ 400400$ 400$ 400$ 400$ 400$ 2,000$ PTR-07 (Monument) PTR-08 (Hollow)-$ -$ -$ -$ -$ -$ -$ $ 10,00025,000$ -$ -$ -$ -$ 10,000$ PTR-09 (Cloverdale) PTR-10 (East Park)-$ -$ -$ -$ -$ -$ -$ PTR-11 (West Park)-$ -$ -$ -$ -$ -$ -$ $ 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) Total35,400$ 25,900$ 107,900$ 11,900$ 11,900$ 11,900$ 169,500$ Projects - ActualSpent 2013201414 Snow Town Expenses:vail. Re Av PTR-01 (Millstream)-$ -$ -$ 905$ PTR-02 (Northland)-$ -$ PTR-03 (Klinefelter)-$ -$Other 14 Expenses:2013 YTD PTR-04 (Wobegon)-$ -$ Dog Baggies269$ -$ PTR-05 (Memorial)-$ -$-1 Toilets2,211$ 2,155$ A PTR-06 (Centennial)-$ -$ PTR-07 (Monument)(122)$ -$2014 Revenue:2013 YTD PTR-08 (Hollow)-$ -$ Interest741$ 20$ PTR-09 (Cloverdale)(32,684)$ (20,628)$ Round Up133$ 134$ PTR-10 (East Park)-$ -$ GF Transfer4,000$ 3,000$ PTR-11 (West Park)-$ -$ Donation3,628$ 15,625$ PTR-12 (Trails)-$ -$ Park Dedic.-$ -$ PTR-13 (Trees)-$ -$ Total(32,806)$ (20,628)$ Millstream 5k Exp:vailable Rev A. $ 3,024-$