The URL can be used to link to this page

Home My WebLink About[04c] Financial Report Council Agenda Item 4c MEETING DATE: July 15, 2019 AGENDA ITEM: Financial Report – 2nd Quarter & June 2019 Financial Reports SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: Council adopted the 2019 budget on December 17, 2018. BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to actual position are provided for Council review. The numbers presented are the cash balances as of June 30, 2019. CASH POSITION: - The market rate of return (ROR) is approximately 2.4% with an average maturity of 32 months. The City tiers the maturity dates within the boundaries of the Investment Policy. The tiered maturity dates have helped the City maintain a higher rate of return than the current market over time. In addition, one of the goals is to invest locally. The City’s more immediate cash flow needs are held at local financial institutions and the Stated money market fund (PMA 4M). - In June, the Federal Open Market Committee \[FOMC\] kept the federal fund rates at 2.25 to 2.5% citing inflation projections, and uncertainty and risks of economic outcomes of real GDP growth, unemployment, trade outcomes and inflation. - Interest earnings for 2019 amounts to a $140,386. 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 fluctuations. The interest earnings are well over the budgeted amounts. Staff budgets conservatively, but earnings are still higher than anticipated for the first half of the year. The strong US economy is reflected in the positive earnings. - Overall, the cash and investments balance increased $208,417 from the beginning of the year. 70% of the first half tax settlements and 25% of the LGA were received in June. The 30% and nd 75% of the first half receipts are received in July. The proceeds will help fund the 2 half of the year before the December settlements are received. FUNDS REPORT: - The General fund spent 47% of the 2019 expenditure budget and received 35% of the revenue budget. Expenditures and revenues are mainly operational in nature. The revenues are on target through June. There will be a one-time receipt of $50,000 for the conduit debt issue by Country Manor. Police fines are close to budget in the first half. The City is successfully collecting aged parking violations from the State’s Revenue Recapture system versus writing them off. The expenditures include first half of general operations. The finance department is a bit under expensed due to the delay in hiring the finance tech. The position was a full year in the budget. - The Enterprise Funds represent four months utility billing revenue collected while expenses represent six months. Overall, 25% of expenses have been incurred (less depreciation); 30% of st the revenue budget has been received. Revenues and expenses are general in nature plus 1 half bond interest expenses. 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 collected $161,250 WAC/Trunk fees in the first two quarters. New connections include five new homes, one sewer only th account connected to city water and Oaks on 20 apartments, phase 2. Water revenues represent 39%, expenses 25% of the budget at the end of June and all are operational in nature plus first have bond interest. Sewer fund analysis (fund 602/502) – The enclosed spreadsheet shows an analysis of the sewer fund, including the Sewer fund (602) and the Sewer Access fund (SAC-502). As with water, five new homes th and the second phase of the Oaks on 20 apartments was received. Sewer expenses are at 32% of the budget, while revenues are at 27% of the budget and all are operational in nature. ½ ¢ Sales Tax (fund 200): The sales tax fund has a cash balance of $519,170. The City anticipates collecting $440,000 in sales tax revenue in 2019, the start of the State legislation sales tax extension period. The City of St. Joseph collected $4,263,671 in sales tax revenue for the original legislative period. The budgeted amount was $3,372,754. The St. Cloud area collected $7.2M less than the original budget. St. Joseph has benefited from increased sales tax collections since the law was passed in 2005. The allocation formula is reviewed annually by the area Finance Directors to ensure sales credits are given to the correct community. The Sales Tax Summary report shows all revenues recorded and projects expensed from Fund 200. The projects are split to show the projects completed, the projects in progress, and the projects reviewed, but not moved forward at this time. After the anticipated revenue collections through 2038, $4.3M remains uncommitted. The available annual sales tax revenue after bonded commitments is $257,013. The East Park and CSAH 2 Trail projects will be paid for with cash out of the fund. The CSAH 2 Trail project will also receive $650,594 in federal funds to reimburse construction costs in 2019. The City has not collected any 2019 sales tax revenue in the first two quarters. The City of St. Cloud found a formula error from the State reports that needed to be corrected before remitting taxes. The area Finance Directors reviewed the reports and allocations. St. Cloud will begin remitting in July. CIP REPORTS: - General capital equipment purchases include costs to upgrade cable access equipment. The City also bought out squad 702 from the leasing company. - The EDA agreed to fund a portion of the access for the industrial park and covered part of the City’s engineering fees. The EDA also covered a portion of the administrative fees for the 209 housing rehabilitation grant. - Engineering expenses incurred relating to the 2019 street improvement, CR2 trail extension and Industrial Park expansion projects. - The East Park development has begun with the seeding and reforestation. This will take three years to complete the prep and planting. The trees will take ten years to provide good shade cover in the trails. BUDGET/FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action – Quarterly and June Financial Reports 2nd Quarter Reports: Cash Position as of 6/30/19 Cash and Investment Holdings Chart Cash Balances by Fund/Remaining Budget General & Fire Budget to Actual Expenditures & Revenues Enterprise Funds Activity Graph Quarterly Water Fund Analysis Half Cent Sales Tax Fund Summary June Treasurer’s Reports: Cash and Investment – Council Report Council Month End Revenue Summary Council Month End Revenue – General Fund Council Month End Revenue – Enterprise Funds Council Month End Expenditure Summary Council Month End Expenditure – General Fund Council Month End Expenses - Enterprise Funds Capital Improvement Summary Reports: General Fund Capital Improvement Plan - Summary General Fund Capital Improvement Plan - Fire Enterprise Capital Improvement Plan – Public Works Capital Improvement Budget Summary – Park Board REQUESTED COUNCIL ACTION: Consider accepting the 2nd quarter and June 2019 financial reports. City of St. Joseph, Minnesota Cash Position As of 6/30/19 Sentry BankMaturity DateInterestCurrent Balance# Securities% of Total Checking Account (Reconciled)N/A0.15%868,633$ N/A Money Market SavingsN/A1.00%92,116 N/A Jacob Wetterling Rec Center SavingsN/A0.15%3,161 N/A Bank Certificates of DepositN/AN/A- 0 averagesN/A0.58% Total SB$963,91012% Central MN Credit Union Share Savings AccountN/A0.00%5$ N/A Business Advantage CheckingN/A1.41%159,630 N/A Money Market SavingsN/A0.44%59 N/A Bank Certificates of Deposit15 months2.65%avg 2500,000 averages15 months2.24% Total CMCU$659,6948% PMA 4M - US Bank 4M Money Market SavingsN/A2.10%200,252$ N/A 4MP Money Market SavingsN/A2.16%744,824$ N/A Bank Certificates of DepositTiered 1-7 months2.44%avg 3596,300 averages3 months2.32% Total 4M$1,541,37719% Total Deposits3,164,981$ RBC Wealth Management Brokered Money Market SavingsN/A1.42%2,626$ N/A Government Securities/Notes66 months2.00%avg 1300,015 Brokered Certificates of DepositTiered 1-81 months2.40%avg 224,513,521 averages37 months2.39% Total RBC$4,816,16260% Total Investments4,816,162$ 2019 YTD Total Deposits and Investments$ Interest Earned7,981,142 Average Interest APY32 months2.41%$140,386 Petty Cash AdministrationN/AN/A200$ Community CenterN/AN/A25 Total Petty Cash$225 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 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. 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 Markets2,626$ 0.03%N/A Brokered Certificates of Deposit4,513,521$ 56.55%3.1 years Government Bonds/Notes300,015$ 3.76%5.5 years Foreign Currency Risk: The City only invests in USA and USA territories. ağƩƉĻƷ {ğǝźƓŭƭ {ĻĭǒƩźƷźĻƭ aƚƓĻǤ/5ƭ ağƩƉĻƷ /5ƭ ЊЍі Бі Ͳ Ͳ /ŷĻĭƉźƓŭaƚƓĻǤ.ğƓƉ.ƩƚƉĻƩĻķDƚǝĻƩƓƒĻƓƷ.ƩƚƉĻƩĻķ ЎВЏͲЌЉЉ ЊͲЉЍЉͲЍЊА Љі Ͳ ЋͲЏЋЏ ЊЍі Ͳ IƚƌķźƓŭƭ Ѝі Ͳ ЊͲЉЋБͲЋЏЍ ЌЉЉͲЉЊЎ LƓǝĻƭƷƒĻƓƷ ğƓķ /ğƭŷ ЏЉі Ͳ ЍͲЎЊЌͲЎЋЊ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5 19 RECEIVED19 LEFT $ 2,108,750 161,921 198,485 (51,738) 519,992 9,259 (30) 9,285 (638) (2,965) 448,157 138,861 (170,390) 87,295 959,777 1,080,920 187,456 56,424 54,566$ V $ 1,140,175 170,259 92,230 51,738 20,008 20,456 40 4,815 663 4,065 608,618 564 170,390 75,205 341,523 479,835 117,244 55,871 27,674 e $ 3,248,925$ 332,180$ 290,715$ -$ 540,000$ 29,715$ 10$ 14,100$ 25$ 1,100$ 1,056,775$ 139,425$ -$ 162,500$ 1,301,300$ 1,560,755$ 304,700$ 112,295$ 82,240 As of 6/30/19 $ 1,704,786 291,563 204,292 34,581 722,471 298,931 3,500 12,911 3,125 - 1,342,689 (175,806) 225,000 162,000 1,330,574 1,638,428 188,761 240,292 58,813$ 3,381,37 5 months of cash balanc City of St. Joseph, Minnesota Cash Balances by Fund/Remaining Budget 19 EXP BUD19 SPENT19 LEFT19 BUD RE $ 1,487,434 40,617 86,423 6,099 407,529 12,679 - 1,189 9,375 - 148,011 315,231 - - 240,726 352,327 141,504 47,588 23,427 E 2,144 55,89877,92034,67726,29747,080 664,742519,170119,534216,199585,819166,481798,928402,449241,474266,031 (249,975) 1,891,1762,112,0547,978,100 $ 3,192,220 332,180 290,715 40,680 311,610 3,500 1,490,700 139,425 1,571,300 1,990,755 330,265 82,240$ 3,320,157 1,130,000 14,100 12,500 - 225,000 162,000 287,880$ x d d d t r x FUNDCASH BALANC TOTALS 2019 cash increase208,417 12/31/18 Cash Balance7,769,683 General FundFire FundEDA FundTIF FundsState Collected Sales TaPark DedicationCharitable GamblingLodging TaDEED CDAP GranRevolving Loan FunDebt FundsCapital Project FundsWater Access FunSewer Access FunWater FundSewer FundRefuse/Compost FundStorm SeweStreet Light Utility BudgetActual BudgetActual ExpExpRevRev $170,259 $332,180 Fund $40,617 Revenues & $332,180 Expenditures Actual to $1,140,175 Budget FundFire $3,248,925 Fire & General $1,487,434 General $3,192,220 $ $500,000 $3,500,000$3,000,000$2,500,000$2,000,000$1,500,000$1,000,000 9ǣƦĻƓƭĻwĻǝĻƓǒĻ υЏЉЉͲЉЉЉ υЍАВͲБЌЎ υЎЉЉͲЉЉЉ υЍЉЉͲЉЉЉ υЌЎЋͲЌЋА Activity υЌЍЊͲЎЋЌ Funds υЌЉЉͲЉЉЉ υЋЍЉͲАЋЏ υЋЉЉͲЉЉЉ Enterprise υЊЍЊͲЎЉЍ υЊЊАͲЋЍЍ υЊЉЉͲЉЉЉ υЎЎͲБАЊ υЍАͲЎББ υЋЌͲЍЋА υЋАͲЏАЍ υ Light Sewer WaterWater Refuse Street Storm City of St. Joseph Quarterly Water Fund Analysis As of June 30, 2019 Fund 601+501, Water/WAC Fund Balance as of December 31, 2018(Audited) $ 1,113,559.35 WAC fees collected for: 5 new homes Year to Date Revenue: Interest Earnings20,945.26 1 sewer only connected to city water Ad Valorem Taxes7,994.28 Oaks on 20th, phase 2 Water Usage Charge171,918.40 Water Fixed Charge112,144.08 Penalties/Other Usage Fees12,287.04 WAC/Trunk Fees161,250.00 Antenna Lease Revenue16,295.44 Water Meters8,310.00 Bulk Water Sales769.15 Transfers from other Funds- Total Revenue511,913.6539.34%budget collected 2019 Revenue Budget1,301,300.00 (includes fund 501) Year to Date Expenses by Department: Debt Payments(46,107.75) Transfers to Other Funds(6,725.00) Power and Pumping(19,541.68) Water Treatment Plant 1(15,927.14) Water Treatment Plant 2(29,085.63) Distribution(3,434.49) Wellhead Protection- Water Tower(4,167.16) Water Maintenance(98,576.27) Water Administration(17,160.59) Total Expenses(240,725.71) 25.44%budget expensed 2019 Expense Budget(946,300.00) (excludes depreciation, includes 501) Fund Summary as of June 30, 2019: Water Fund Cash Balance - Fund 601+501 - unaudited $1,384,747.29 Fund 501$ 585,819.35 Fund 601$798,927.94 The balances represent the cash balance as of 6/30/19 City of St. Joseph Quarterly Sewer Fund Analysis As of June 30, 2019 Fund 602+502, Sewer/SAC Fund Balance as of December 31, 201(unaudited)$ 366,217.21 SAC fees collected for Year to Date Revenue:5 new homes Interest Earnings7,862.08 Oaks on 20th, phase 2 Sewer Usage Charge284,662.57 Sewer Fixed Charge186,675.47 Penalties/Other Usage Fees2,631.13 SAC/Trunk Fees73,075.00 RV Dump Donations133.00 Transfers from other Funds- Total Revenue555,039.2532.21%budget collected 2019 Revenue Budget1,723,255.00 (includes fund 502) Year to Date Expenses by Department: Debt Payments21,377.25 Transfers to Other Funds (6,570.00) Sewer Maintenance(51,288.36) Baker Street Lift Station(2,032.05) Ridgewood Lift Station(943.88) Northland Lift Station(1,563.57) CR121 Lift Station(788.43) Main Lift Station(296,530.03) Sewer Administration(13,987.52) Total Expenses(352,326.59) 26.52%budget expensed 2019 Expense Budget(1,328,755.00) (excludes depreciation,includes fund 502) Fund Summary as of June 30, 2019: Sewer Fund Cash Balance - Fund 602+502 - unaudited$ 568,929.87 Fund 502$ 166,480.66 Fund 602$ 402,449.21 The balances represent the cash balance as of 6/30/19. Sales Tax Summary Summary of Committed & Available Funds As of June 30, 2019 Revenues Recorded in Fund 200 Sales Tax Receipts through 6/30/194,263,956$ Interest Earnings 109,442 Community Center Bond Proceeds1,794,000 Transfer - Rec Funds (Facilities)19,274 Transfer - General Fund24,004 Transfer - Government Center Bonds35,449 Transferred to the Water Fund (int. earnings)(86,436) Donation, Misc. 40,110 s$6,199,799 Total Revenue gTotal State Bondin Projects CompletedProjectTotalFederal/APO/Fund 200Total Project Name/Type YearExpendedOther FundingExpendedProject Cost Sales Tax Committee2007/2008586 - 586 586 Park & Trail System Plan200751,631 - 51,631 51,631 Centennial Park Swing set201033,284 - 33,284 33,284 CR 2/3 Trail Extension Phase I2010-2013446,513 - 446,513 446,513 Wobegon Trailhead Improvements201313,886 - 13,886 13,886 CR 133/College Ave Sidewalk2010-2013192,730 - 192,730 192,730 Aquatics Design201471,624 110 71,514 71,624 $110 anonymous donation Wobegon Trail Extension to St. Cloud2017200,082 - 200,082 200,082 Millstream Park Shelter2015/2017529,599 40,000 489,599 529,599 $40,000 Lion's donation 2010-2013 78,727382,202 303,475 382,202 transfers from other funds Community Center - Planning Community Center - Colts purchase20142,986,618 1,794,000 2,340,109 2,986,618 $1.794M bond proceeds Pedestrian Bridge - Study2016-201713,382 - 13,382 13,382plus $32K APO funded Total Projects Completed 1,912,8374,922,138 4,156,791 4,922,138 TotalState Bonding Projects In ProgressFund 200Federal/APO/Fund 200Total Project Name/Type ExpendedOther FundingRemainingProject Cost Community Center Remodel, Phase II2023- - 500,000 500,000 East Park Development, Phase I2019-2021- 300,000 300,000 600,000 $300K State Bonding request Jacob Wetterling Recreation Center202011,350 7,500,000 13,500,0005,988,650 $6M donations est.; $1.5M state bonding request Field Street - sales tax portion only201740,000 - 360,000 400,000 cover bond payments due to deferred assessments Trail Extension Phase II/III2018-2019707,141 650,594 387,916 1,745,651$650,594 federal funding Total Projects in Progress 8,450,594758,491 7,536,566 16,745,651 Fund 200 Balance, December 31, 2018, audited$ 906,691 anticipated remaining 2019 sales tax revenues to collect 399,715 anticipated remaining 2020-2038 sales tax revenues to collect 10,560,000 Committed - to be funded(7,536,566) Anticipated remaining balance after commitments$4,329,840 Average Annual Revenue (3 yr)437,012.55$ Average Bond Payment Field St (5 yr)(20,000.00) Average Bond Payment Colts Academy (5 yr) (160,000.00) uncommitted annually (5 yr Average)$257,012.55 MSAS/SA Bonds ProjectDonations/YTDFund 200 Projects that have been discussed for YearProject CostState BondingExpendedTo Be Funded Sales Tax Funding, not approved Aquatics Center6,500,000 (2,000,000) - 4,500,000 $2M donations est. Pedestrian Crossing3,000,000 (1,500,000) - 1,500,000 $1.5M State Bonding request Amphitheater150,000 (50,000) - 100,000 $50K donations est. Total Projects Not Approved (3,550,000)9,650,000 - 6,100,000 e Estimated Maximum Funding Availabl 2006 - 2018 Legislation4,250,000$ 2019 - 2038 Legislation11,000,000 $15,250,000 Cash Balances Only Current Period: June 2019 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance Last Dim 10100 GeneralG 101-10100$1,776,179.52$679,057.84$224,973.75$1,281,058.03 Employee Retirement ReserveG 102-10100$122,343.34$0.00$4,802.18$174,246.16 Fire FundG 105-10100$581,626.46$23,460.43$1,720.12$664,742.29 Cable Access FeeG 108-10100$5,119.57$271.26$19,308.00-$12,188.85 Economic DevelopmentG 150-10100$58,897.49$52,832.52$19,415.60$55,898.30 TIF 3-1 CMCUG 152-10100$183.67$15,473.14$990.00$14,689.69 TIF 4-1 Fortitude Senior AptsG 153-10100$4,527.85$16,783.21$3,129.00$18,245.52 TIF 2-1 MillstreamG 157-10100$25,642.09$15,539.35$990.00$40,686.45 TIF 2-2 Meat MarketG 158-10100$495.50$3,389.92$0.00$3,893.95 TIF 2-3 Bayou Blues/Alley FlatG 159-10100$1,278.12$107.35$990.00$404.24 State Collected Sales TaxG 200-10100$827,524.42$50,848.61$282,177.21$519,170.26 Park DedicationG 205-10100$111,372.46$7,176.42$2,079.00$119,533.76 Charitable GamblingG 215-10100$2,096.31$9.32$0.00$2,144.27 Lodging TaxG 220-10100$30,334.72$1,373.42$0.00$34,677.41 DEED CDAP GrantG 225-10100$34,945.69$141.51$3,125.00$26,297.10 Revolving Loan FundG 250-10100$211,358.83$940.20$0.00$216,199.42 2016 CIP Bonds \[govt center\]G 301-10100$48,948.00$99,100.79$0.00$105,697.70 2017A CIP Bonds \[govt center\]G 303-10100$104,072.28$3,509.11$0.00$120,083.69 2016 Street Imp \[Field St\]G 304-10100$67,219.44$17,808.64$0.00$96,980.83 2017B Street Imp \[CBD Alleys\]G 305-10100$52,970.17$8,956.54$0.00$58,372.10 2018 Equipment CertificatesG 306-10100$50.07$21,063.39$0.00$19,022.56 2010B Refunding \[Hill/Clover\]G 333-10100$132,425.71$32,265.35$0.00$164,458.10 2011A CO Refund \[Interior St\]G 338-10100$81,909.29$36,525.82$0.00$115,528.17 2010B Street Imp \[16th Ave\]G 345-10100$150,570.60$9,295.03$0.00$156,750.38 2011A Pumper Truck CertificatG 346-10100$39.94$10,703.91$0.00$20,215.34 2013 Street Imp \[Overlays\]G 348-10100$86,921.38$8,474.41$0.00$93,829.87 2014 Street Imp \[ParkTerrace\]G 350-10100$205,032.07$38,195.58$0.00$237,073.42 2015 Street Imp\[Clinton/NorthG 351-10100$134,912.55$32,863.30$0.00$168,402.11 2015 Equipment CertificatesG 352-10100$1,044.81$54,624.39$0.00$57,004.63 2015 Abatement \[Comm CenteG 353-10100$28,351.01$565.30$0.00$169,836.00 Debt Service ReliefG 390-10100$539,508.46$4,104.01$13,975.00$528,799.33 Community Center phase IG 402-10100$2,468.78$15.22$0.00$3,042.00 2018 Equipment CertificatesG 406-10100$65,256.32$0.00$3,166.54$61,481.78 2019 Street OverlaysG 407-10100$0.00$0.00$28,120.35-$114,472.97 2019 Industrial Park ExpansionG 408-10100$0.00$40,238.98$87,980.18-$196,983.40 Capital OutlayG 490-10100$409,574.39$46,014.90$8,000.00$448,060.50 WAC FundG 501-10100$409,128.81$2,300.21$0.00$585,819.35 SAC FundG 502-10100$88,820.42$610.91$0.00$166,480.66 Water FundG 601-10100$602,018.79$115,885.62$36,706.06$798,927.94 Sewer FundG 602-10100$232,989.51$179,314.73$84,769.14$402,449.21 Refuse CollectionG 603-10100$244,488.14$36,695.92$23,716.56$241,474.14 Storm Water UtilityG 651-10100$251,993.02$11,032.11$3,042.60$266,030.82 Street Light UtilityG 652-10100$35,043.36$10,142.24$3,482.80$47,080.05 Last Dim 10100$7,769,683.36$1,687,710.91$856,659.09$7,981,142.31 Last Dim 10200 GeneralG 101-10200$225.00$0.00$0.00$225.00 Last Dim 10200$225.00$0.00$0.00$225.00 Cash Balances Only Current Period: June 2019 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance $7,769,908.36$1,687,710.91$856,659.09$7,981,367.31 Council Month End Revenue Summary Current Period: June 2019 2019June2019 FUNDFUND DescrYTD Budget2019 AmtYTD Amt 101General$3,184,310.00$677,301.33$1,034,927.11 102Employee Retirement Reserve$56,705.00$0.00$56,705.00 105Fire Fund$332,180.00$23,436.87$170,259.10 108Cable Access Fee$7,910.00$271.26$2,528.12 150Economic Development$290,715.00$52,832.52$92,230.44 152TIF 3-1 CMCU$0.00$15,473.14$15,481.04 153TIF 4-1 Fortitude Senior Apts$0.00$16,783.21$16,835.09 157TIF 2-1 Millstream$0.00$15,539.35$15,909.73 158TIF 2-2 Meat Market$0.00$3,389.92$3,396.66 159TIF 2-3 Bayou Blues/Alley Flat$0.00$107.35$115.87 200State Collected Sales Tax$540,000.00$3,549.63$20,008.04 205Park Dedication$29,715.00$7,176.42$20,456.41 215Charitable Gambling$10.00$9.32$40.19 220Lodging Tax$14,100.00$1,373.42$4,814.89 225DEED CDAP Grant$25.00$141.51$663.37 250Revolving Loan Fund$1,100.00$940.20$4,065.02 3012016 CIP Bonds \[govt center\]$270,300.00$99,100.79$99,632.42 3032017A CIP Bonds \[govt center\]$0.00$3,509.11$19,941.96 3042016 Street Imp \[Field St\]$49,155.00$17,808.64$38,658.12 3052017B Street Imp \[CBD Alleys\]$32,820.00$8,956.54$9,691.18 3062018 Equipment Certificates$57,005.00$21,063.39$21,941.42 3072019A Street Imp \[Overlays\]$0.00$0.00$0.00 3082019 GO Assessment Bonds$0.00$0.00$0.00 3332010B Refunding \[Hill/Clover\]$73,800.00$32,265.35$34,675.11 3382011A CO Refund \[Interior St\]$120,405.00$36,525.82$37,315.92 3452010B Street Imp \[16th Ave\]$36,975.00$9,295.03$11,442.24 3462011A Pumper Truck Certificate$42,870.00$10,703.91$21,517.09 3482013 Street Imp \[Overlays\]$23,310.00$8,474.41$10,100.91 3502014 Street Imp \[ParkTerrace\]$110,010.00$38,195.58$46,606.75 3512015 Street Imp\[Clinton/North\]$43,545.00$32,863.30$36,293.38 3522015 Equipment Certificates$36,010.00$54,624.39$55,513.61 3532015 Abatement \[Comm Center\]$160,570.00$565.30$161,261.05 390Debt Service Relief$0.00$4,104.01$4,027.02 402Community Center phase I$0.00$15.22$564.39 4062018 Equipment Certificates$0.00$0.00$0.00 4082019 Industrial Park Expansion$0.00$0.00$0.00 490Capital Outlay$139,425.00$46,014.90$46,014.90 501WAC Fund$0.00$2,300.21$170,390.40 502SAC Fund$162,500.00$610.91$75,204.60 601Water Fund$1,301,300.00$114,993.16$341,523.25 602Sewer Fund$1,560,755.00$179,289.62$479,834.65 Council Month End Revenue Summary Current Period: June 2019 2019June2019 FUNDFUND DescrYTD Budget2019 AmtYTD Amt 603Refuse Collection$304,700.00$35,880.71$117,244.05 651Storm Water Utility$112,295.00$11,032.11$55,871.46 652Street Light Utility$82,240.00$10,142.24$27,673.73 $9,176,760.00$1,596,660.10$3,381,375.69 Council Month End Revenue -General Fund Current Period: June 2019 2019June2019 FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt FUND 101 General 101GeneralCurrent Ad Valorem Taxes$1,424,710.00$476,696.86$476,696.86 101GeneralSpecial Levy- City St. Joe$0.00$0.00$143.22 101GeneralState Sales Tax$0.00-$49.96$48.44 101GeneralGravel Tax$13,670.00$0.00$2,421.50 101GeneralSolar Production Tax$500.00$0.00$0.00 101GeneralGas Franchise$32,760.00$0.00$8,566.44 101GeneralElectric Franchise$62,185.00$2,275.77$20,360.82 101GeneralLicenses & Permits$12,450.00$0.00$10,000.00 101GeneralBeer$0.00$0.00$0.00 101GeneralLiquor$28,185.00$400.00$26,795.00 101GeneralOutdoor Liquor Permit$2,000.00$0.00$1,900.00 101GeneralGambling Permits$350.00$0.00$240.00 101GeneralAmusement/Hunt/Peddler/Golf$1,400.00$75.00$360.00 101GeneralExcavation Permit$500.00$0.00$200.00 101GeneralCigarette License$675.00$0.00$0.00 101GeneralCable Franchise Fee$34,870.00$1,213.70$9,982.04 101GeneralBuilding Permits$145,000.00$21,389.45$72,415.64 101GeneralAnimal License$3,100.00$270.00$3,155.00 101GeneralRental Housing Registration$30,180.00$8,465.00$19,943.75 101GeneralFederal Grants - Other$8,000.00$0.00$0.00 101GeneralState Grants and Aids$1,100.00$0.00$0.00 101GeneralLocal Government Aid$994,435.00$145,187.51$145,187.51 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$55,800.00$0.00$29,994.50 101GeneralState Police Aid$65,000.00$0.00$0.00 101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00 101GeneralCounty Grants - Road Maint.$16,300.00$0.00$0.00 101GeneralZoning and Subdivision Fee$7,000.00$240.00$2,590.00 101GeneralLand Use Deposit Fee$4,000.00$0.00$6,500.00 101GeneralSale of Maps and Publications$25.00$0.00$4.75 101GeneralConduit Debt Fee$0.00$0.00$3,000.00 101GeneralAssessments Search$4,000.00$810.00$3,630.00 101GeneralSpecial Hearing$2,000.00$500.00$2,425.00 101GeneralAdministration Reimb$13,000.00$36.68$69.96 101GeneralWeed Cutting$500.00$0.00$0.00 101GeneralAdmission Fee$1,000.00$30.00$942.00 101GeneralShelter/Room Rental Fees$10,000.00$435.00$8,380.00 101GeneralBall Field Donation$100.00$0.00$0.00 101GeneralSchneider Field Rental$1,500.00$0.00$0.00 Council Month End Revenue -General Fund Current Period: June 2019 2019June2019 FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt 101GeneralRents and Royalties$59,055.00$6,468.41$38,810.46 101GeneralKennel Fees$300.00$0.00$25.00 101GeneralCounty Fines$38,000.00$3,252.93$10,069.74 101GeneralPolicy Fines$20,000.00$1,462.68$19,323.47 101GeneralAccident Report Fee$1,300.00$120.00$896.75 101GeneralSeized Property$2,000.00$0.00$0.00 101GeneralSpecial Assessments$4,000.00$1,226.57$2,090.50 101GeneralInterest Earnings$20,000.00$6,354.15$38,176.26 101GeneralInterest Charges$100.00$0.00$0.00 101GeneralCo-op Dividend - LMCIT$10,000.00$0.00$0.00 101GeneralWater Tower Antenna Lease$4,170.00$166.25$1,810.62 101GeneralAdvertising$1,200.00$200.00$1,220.00 101GeneralContributions - General$2,000.00$0.00$3,500.00 101GeneralContributions - Parks$250.00$75.33$80.33 101GeneralSurplus Property$0.00$0.00$0.00 101GeneralReimbursement$28,600.00$0.00$20,375.05 101GeneralInsurance Recovery$2,000.00$0.00$831.50 101GeneralTransfers from Other Funds$0.00$0.00$36,765.00 FUND 101 General$3,184,310.00$677,301.33$1,034,927.11 FUND 102 Employee Retirement Reserve 102Employee Retirement ResTransfers from Other Funds$56,705.00$0.00$56,705.00 FUND 102 Employee Retirement Reserve$56,705.00$0.00$56,705.00 FUND 108 Cable Access Fee 108Cable Access FeeCable Franchise Fee$7,910.00$271.26$2,528.12 108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00 FUND 108 Cable Access Fee$7,910.00$271.26$2,528.12 FUND 150 Economic Development 150Economic DevelopmentCurrent Ad Valorem Taxes$111,240.00$36,956.74$36,956.74 150Economic DevelopmentFederal Grants - Other$178,625.00$13,605.00$38,066.00 150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$500.00 150Economic DevelopmentTax Abatement Reimbursement$0.00$0.00$2,517.00 150Economic DevelopmentInterest Earnings$850.00$131.78$563.04 150Economic DevelopmentTransfers from Other Funds$0.00$2,139.00$13,627.66 FUND 150 Economic Development$290,715.00$52,832.52$92,230.44 FUND 490 Capital Outlay 490Capital OutlayCurrent Ad Valorem Taxes$138,925.00$46,014.90$46,014.90 490Capital OutlayFederal Grants - Other$0.00$0.00$0.00 490Capital OutlaySurplus Property$500.00$0.00$0.00 FUND 490 Capital Outlay$139,425.00$46,014.90$46,014.90 Council Month End Revenue -General Fund Current Period: June 2019 2019June2019 FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt $3,679,065.00$776,420.01$1,232,405.57 Council Month End Revenue -Enterprise Funds Current Period: June 2019 FUND2019June2019 FUNDDescrSOURCE DescrYTD Budget2019 AmtYTD Amt FUND 601 Water Fund 601Water FundWater Fixed Charge$326,220.00$37,011.58$112,144.08 601Water FundTransfers from Other Funds$207,000.00$0.00$0.00 601Water FundCurrent Ad Valorem Taxes$22,500.00$8,266.31$7,994.28 601Water FundMDS Test Fee$11,500.00$1,293.84$3,931.44 601Water FundWater Meter$5,510.00$100.00$8,310.00 601Water FundPenalties and Forfeited Disc$8,130.00$516.53$2,407.11 601Water FundUndesignated Funds$2,000.00$9,265.56$5,421.57 601Water FundBulk Water$3,500.00$365.20$769.15 601Water FundReimbursement$0.00$0.00$1,535.52 601Water FundWater Tower Antenna Lease$37,525.00$1,496.21$16,295.44 601Water FundAmortization of Bond Premium$0.00$0.00$0.00 601Water FundInterest Earnings$2,000.00$3,170.72$11,804.86 601Water FundSpecial Assessments$700.00$364.51-$495.08 601Water FundState Grants and Aids$0.00$0.00$0.00 601Water FundState Sales Tax$0.00-$86.57-$513.52 601Water FundUsage Rate$674,715.00$53,229.27$171,918.40 601Water FundContributed Revenue$0.00$0.00$0.00 FUND 601 Water Fund$1,301,300.00$114,993.16$341,523.25 FUND 602 Sewer Fund 602Sewer FundState Grants and Aids$0.00$0.00$0.00 602Sewer FundPenalties and Forfeited Disc$7,620.00$584.17$2,659.60 602Sewer FundSanitary Sewer Use Service$837,225.00$107,541.23$284,662.57 602Sewer FundContributed Revenue$0.00$0.00$0.00 602Sewer FundReimbursement$4,000.00$0.00$0.00 602Sewer FundSurplus Property$0.00$0.00$0.00 602Sewer FundContributions - General$750.00$67.00$133.00 602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00 602Sewer FundInterest Earnings$16,160.00$3,637.40$5,732.48 602Sewer FundOther Governmental Unit$0.00$0.00$0.00 602Sewer FundGain on Disposal of Assets$0.00$0.00$0.00 602Sewer FundSpecial Assessments$250.00$66.42-$28.47 602Sewer FundTransfers from Other Funds$162,000.00$0.00$0.00 602Sewer FundSewer Fixed Charge$532,750.00$67,393.40$186,675.47 FUND 602 Sewer Fund$1,560,755.00$179,289.62$479,834.65 FUND 603 Refuse Collection 603Refuse CollecSpecial Assessments$200.00$52.85-$22.65 603Refuse CollecContributed Revenue$0.00$0.00$0.00 603Refuse CollecReimbursement$0.00$0.00$1,116.03 603Refuse CollecInterest Earnings$2,000.00$1,024.31$4,489.72 603Refuse CollecPenalties and Forfeifted Disc$5,500.00$237.17$1,119.22 603Refuse CollecRefuse Collection Charges$271,760.00$30,471.49$90,466.52 603Refuse CollecState Grants and Aids$0.00$0.00$0.00 603Refuse CollecLicenses & Permits$25,240.00$3,190.00$22,425.60 603Refuse CollecState Sales Tax$0.00$904.89-$2,350.39 603Refuse CollecContributions - General$0.00$0.00$0.00 FUND 603 Refuse Collection$304,700.00$35,880.71$117,244.05 FUND 651 Storm Water Utility 651Storm Water Special Assessments$400.00$5.16-$2.21 Council Month End Revenue -Enterprise Funds Current Period: June 2019 FUND2019June2019 FUNDDescrSOURCE DescrYTD Budget2019 AmtYTD Amt 651Storm Water Storm Water Use Service$84,385.00$9,800.28$28,904.80 651Storm Water Storm Water Develop Fee$4,000.00$0.00$21,714.20 651Storm Water Penalties and Forfeifted Disc$1,500.00$104.78$309.72 651Storm Water Contributed Revenue$0.00$0.00$0.00 651Storm Water Interest Earnings$2,000.00$1,121.89$4,744.95 651Storm Water Other Grants/Aids$20,000.00$0.00$0.00 651Storm Water State Grants and Aids$10.00$0.00$0.00 651Storm Water Surplus Property$0.00$0.00$200.00 FUND 651 Storm Water Utility$112,295.00$11,032.11$55,871.46 FUND 652 Street Light Utility 652Street Light UPenalties and Forfeited Disc$1,000.00$67.66$241.48 652Street Light UState Grants and Aids$0.00$0.00$0.00 652Street Light UOther Grants/Aids$300.00$0.00$0.00 652Street Light USpecial Assessments$50.00$7.22-$3.10 652Street Light UInterest Earnings$335.00$175.99$709.90 652Street Light UContributions - General$0.00$0.00$0.00 652Street Light USurplus Property$0.00$0.00$36.00 652Street Light UReimbursement$0.00$0.00$0.00 652Street Light UUsage Rate$80,555.00$9,891.37$26,689.45 FUND 652 Street Light Utility$82,240.00$10,142.24$27,673.73 $3,361,290.00$351,337.84$1,022,147.14 Council Month End Expenditure - Summary Current Period: June 2019 2019June2019 DescriptionYTD Budget2019 Amt YTD Amt General$3,184,310.00$223,607.38$1,454,863.53 Employee Retirement Reserve$0.00$4,802.18$4,802.18 Fire Fund$332,180.00$1,696.56$40,617.00 Cable Access Fee$7,910.00$19,308.00$19,768.00 Economic Development$290,715.00$19,415.60$86,423.19 TIF 3-1 CMCU$795.00$990.00$990.00 TIF 4-1 Fortitude Senior Apts$0.00$3,129.00$3,129.00 TIF 2-1 Millstream$34,545.00$990.00$990.00 TIF 2-2 Meat Market$4,545.00$0.00$0.00 TIF 2-3 Bayou Blues/Alley Flat$795.00$990.00$990.00 State Collected Sales Tax$1,130,000.00$234,878.23$407,528.54 Park Dedication$311,610.00$2,079.00$12,679.38 Charitable Gambling$3,500.00$0.00$0.00 Lodging Tax$14,100.00$0.00$1,189.00 DEED CDAP Grant$12,500.00$3,125.00$9,375.00 Revolving Loan Fund$0.00$0.00$0.00 2016 CIP Bonds \[govt center\]$269,755.00$0.00$44,821.25 2017A CIP Bonds \[govt center\]$50,195.00$0.00$4,467.50 2016 Street Imp \[Field St\]$63,460.00$0.00$8,309.36 2017B Street Imp \[CBD Alleys\]$43,340.00$0.00$4,113.75 2018 Equipment Certificates$56,735.00$0.00$3,312.50 2010B Refunding \[Hill/Clover\]$141,525.00$0.00$3,206.25 2011A CO Refund \[Interior St\]$144,140.00$0.00$4,515.00 2010B Street Imp \[16th Ave\]$66,715.00$0.00$5,802.50 2011A Pumper Truck Certificate$42,870.00$0.00$1,380.00 2013 Street Imp \[Overlays\]$47,180.00$0.00$3,535.00 2014 Street Imp \[ParkTerrace\]$162,245.00$0.00$23,567.50 2015 Street Imp\[Clinton/North\]$70,160.00$0.00$5,025.00 2015 Equipment Certificates$36,335.00$0.00$612.50 2015 Abatement \[Comm Center$155,045.00$0.00$19,967.50 Debt Service Relief$141,000.00$13,975.00$15,375.00 Community Center phase I$0.00$0.00$0.00 2018 Equipment Certificates$0.00$3,166.54$3,774.54 2019 Street Overlays$0.00$28,120.35$114,472.97 2019 Industrial Park Expansion$0.00$47,741.20$196,983.40 Capital Outlay$139,425.00$8,000.00$8,000.00 WAC Fund$225,000.00$0.00$0.00 SAC Fund$162,000.00$0.00$0.00 Water Fund$1,571,300.00$35,813.60$240,725.71 Sewer Fund$1,990,755.00$84,744.03$352,326.59 Refuse Collection$330,265.00$22,901.35$141,503.67 Council Month End Expenditure - Summary Current Period: June 2019 2019June2019 DescriptionYTD Budget2019 Amt YTD Amt Storm Water Utility$287,880.00$3,042.60$47,588.04 Street Light Utility$82,240.00$3,482.80$23,426.91 $11,607,070.00$765,998.42$3,320,157.26 1 Council Month End Expenditure - General Fund Current Period: June 2019 2019June2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt FUND 101 General GeneralCouncil$65,745.00$6,433.29$30,049.62 GeneralLegislative Committees$5,800.00$0.00$420.00 GeneralOrdinance & Proceedings$2,200.00-$140.12$535.78 GeneralMayor$11,865.00$850.54$5,239.02 GeneralElections$4,200.00$0.00$0.00 GeneralGeneral Adminstration$304,265.00$19,464.62$121,674.10 GeneralFinance$217,245.00$12,360.43$64,257.94 GeneralAudit Service$28,450.00$0.00$28,075.00 GeneralAssessing$25,500.00$0.00$27,327.23 GeneralCity Attorney$22,000.00$3,750.50$12,922.96 GeneralPlanning and Zoning$85,390.00$5,053.18$33,507.32 GeneralGeneral Government$48,485.00$2,211.41$15,535.93 GeneralCity Offices$37,575.00$1,293.28$23,474.07 GeneralCable Access$5,705.00$322.95$1,293.73 GeneralCrime Control & Investigation$1,138,905.00$89,686.12$476,961.86 GeneralPolice Training$6,680.00$90.00$441.17 GeneralCommunication Service$15,265.00$941.02$5,335.24 GeneralAutomotive Services$48,430.00$1,714.98$15,868.15 GeneralBuilding Inspec. Admistration$95,200.00$7,500.00$39,676.94 GeneralEmergency Management$2,275.00$7.35$688.70 GeneralAnimal Control$815.00$0.00$282.50 GeneralStreet Maintanence$330,000.00$17,375.56$113,842.03 GeneralIce & Snow Removal$126,635.00$149.92$97,733.20 GeneralEngineering Fee$35,000.00$5,027.82$19,401.72 GeneralStreet Cleaning$14,610.00$2,573.82$10,086.11 GeneralSkate Park and Ice Rink$5,715.00$53.47$2,947.49 GeneralBall Park$3,600.00$16.99$16.99 GeneralMaintenance Shop$23,320.00$1,299.32$12,754.22 GeneralPark Areas$253,665.00$30,118.08$122,221.46 GeneralCommunity Center$91,770.00$15,452.85$69,474.09 GeneralOther Financing Uses$0.00$0.00$36,830.00 GeneralFire Protection$128,000.00$0.00$65,988.96 FUND 101 General$3,184,310.00$223,607.38$1,454,863.53 FUND 102 Employee Retirement Reserve Employee Retirement ReservGeneral Adminstration$0.00$0.00$0.00 Employee Retirement ReservCrime Control & Investigation$0.00$4,802.18$4,802.18 FUND 102 Employee Retirement Reserve$0.00$4,802.18$4,802.18 FUND 108 Cable Access Fee Cable Access FeeCable Access$7,910.00$19,308.00$19,768.00 Council Month End Expenditure - General Fund Current Period: June 2019 2019June2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt Cable Access FeeOther Financing Uses$0.00$0.00$0.00 FUND 108 Cable Access Fee$7,910.00$19,308.00$19,768.00 FUND 150 Economic Development Economic DevelopmentEconomic Development Authority$290,715.00$19,415.60$86,423.19 Economic DevelopmentOther Financing Uses$0.00$0.00$0.00 FUND 150 Economic Development$290,715.00$19,415.60$86,423.19 FUND 490 Capital Outlay Capital OutlayGeneral Adminstration$11,250.00$0.00$0.00 Capital OutlayCrime Control & Investigation$3,340.00$0.00$0.00 Capital OutlayCommunication Service$6,375.00$0.00$0.00 Capital OutlayAutomotive Services$16,445.00$8,000.00$8,000.00 Capital OutlayEmergency Management$1,500.00$0.00$0.00 Capital OutlayStreet Maintanence$2,750.00$0.00$0.00 Capital OutlayIce & Snow Removal$10,000.00$0.00$0.00 Capital OutlayStreet Cleaning$500.00$0.00$0.00 Capital OutlayMaintenance Shop$65,500.00$0.00$0.00 Capital OutlayPark Areas$21,765.00$0.00$0.00 Capital OutlayCommunity Center$0.00$0.00$0.00 Capital OutlayOther Financing Uses$0.00$0.00$0.00 FUND 490 Capital Outlay$139,425.00$8,000.00$8,000.00 $3,622,360.00$275,133.16$1,573,856.90 1 Council Month End Expense - Enterprise Funds Current Period: June 2019 2019June2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt FUND 601 Water Fund Water FundBond Payment (P & I)$697,695.00$0.00$46,107.75 Water FundOther Financing Uses$12,725.00$0.00$6,725.00 Water FundPower and Pumping$17,420.00$1,926.25$19,541.68 Water FundPurification-Plant 1$37,955.00$6,983.02$15,927.14 Water FundPurification-Plant 2$87,285.00$5,389.90$29,085.63 Water FundDistribution$10,000.00$3,251.00$3,434.49 Water FundWellhead Protection$5,500.00$0.00$0.00 Water FundStorage-Tower 1$18,295.00$488.78$4,167.16 Water FundWater Maintenance$252,640.00$12,767.83$98,576.27 Water FundAdministration and General$31,785.00$5,006.82$17,160.59 Water FundDepreciation Expense$400,000.00$0.00$0.00 FUND 601 Water Fund$1,571,300.00$35,813.60$240,725.71 FUND 602 Sewer Fund Sewer FundBond Payment (P & I)$236,170.00$0.00-$21,377.25 Sewer FundOther Financing Uses$19,570.00$0.00$6,570.00 Sewer FundSanitary Sewer Maintenanc$219,075.00$7,771.97$51,288.36 Sewer FundLift Station-Baker Street$6,080.00$186.32$2,032.05 Sewer FundLift Station-Ridgewood/DBL$2,700.00$198.67$943.88 Sewer FundLift Station-Northland$4,600.00$1,155.74$1,563.57 Sewer FundLift Station-CR 121$15,150.00$111.31$788.43 Sewer FundLift Station-Main$951,605.00$73,823.41$296,530.03 Sewer FundAdministration and General$35,805.00$1,496.61$13,987.52 Sewer FundDepreciation Expense$500,000.00$0.00$0.00 FUND 602 Sewer Fund$1,990,755.00$84,744.03$352,326.59 FUND 603 Refuse Collection Refuse CollectioWaste Collection$321,990.00$22,901.35$139,903.67 Refuse CollectioOther Financing Uses$1,600.00$0.00$1,600.00 Refuse CollectioDepreciation Expense$6,675.00$0.00$0.00 FUND 603 Refuse Collection$330,265.00$22,901.35$141,503.67 FUND 651 Storm Water Utility Storm Water UtiOther Financing Uses$24,230.00$0.00$4,980.00 Storm Water UtiAdministration and General$15,880.00$928.20$8,264.67 Storm Water UtiStorm Water Maintenance$132,770.00$2,114.40$34,343.37 Storm Water UtiDepreciation Expense$115,000.00$0.00$0.00 FUND 651 Storm Water Utility$287,880.00$3,042.60$47,588.04 FUND 652 Street Light Utility Street Light UtiliStreet Lighting$82,240.00$3,482.80$23,426.91 FUND 652 Street Light Utility$82,240.00$3,482.80$23,426.91 Council Month End Expense - Enterprise Funds Current Period: June 2019 2019June2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt $4,262,440.00$149,984.38$805,570.92 9,325.713,500.001,274.682,450.957,604.005,090.003,940.007,604.002,898.58 11,242.5428,802.8427,593.6669,550.5816,359.4337,993.2825,209.3638,572.8312,912.6114,500.0047,684.8260,000.0072,316.6231,270.00 (12,188.85) 133,498.46200,176.55101,756.52551,942.51231,180.76234,079.34 989,070.89 750.00250.00500.00500.00 4,200.003,000.001,500.005,500.005,000.003,340.006,375.008,000.007,195.001,250.001,500.001,500.002,465.005,500.003,900.001,500.00 19,950.0027,660.0026,500.0010,000.0060,000.0016,365.0044,100.0044,600.00 128,480.00 220,690.00 6/30 18.70 113.00113.00 8,000.008,000.00 19,768.0019,786.7019,267.1019,267.10 47,166.80 y 6/30through 201920192019Balance 2,528.122,528.12 39,994.5039,994.50 42,522.62 8 Summar 201 Plan 17, 2019 524.68 5,144.418,242.54 2,000.005,051.031,200.956,104.002,625.003,690.006,104.002,398.58 23,302.8422,593.6666,859.1613,019.4331,618.2825,209.3631,377.8311,412.6114,000.0037,684.8266,816.6227,370.0085,391.52 30, Availablethrough 113,838.46133,795.05383,581.01167,813.66170,212.24 734,490.87 Expenditures December Equipment June of Capital As Capital adopted 2019 Fund Final Total EDA CIP Total Police CEP General Total Public Works CEP Total Administration CEP CodeEquipmentBalanceGrant 150-46500-582Computer Software250/150-46500-588EDA ProgramsTotal General Capital Improvements ProjectBudgetReserveTransferred/SpentBudgetRemaining DepartmentAccount SoftwareProjects Election101-41410-xxxElection EquipmentPlanning101-41941-300Comp Plan UpdateFinance101-41530-300GASB UpdatesAdministration490-41430-570Administration EquipmentAdministration490-41430-581Computer ReplacementAdministration490-41430-582Computer SoftwareCable Access108-41950-580Cable EquipmentPolice - General490-42120-580Police EquipmentPolice-Communications490-42151-580Communication EquipmentPolice - Automotive490-42152-550Police SquadsPolice - Automotive490-42152-580Vehicle/EquipmentPolice - Automotive490-42152-581Squad LaptopsEmergency Services490-42500-580Emergency ServicesStreets101-43120-530Street ImprovementsStreets490-43120-550Street Motor VehiclesStreets490-43120-580Street EquipmentStreets490-43120-582Street SoftwareStreet Sweeping490-43220-580Street Sweeping EquipmentSnow Removal490-43125-580Snow Removal EquipmentMaintenance490-45201-520Maintenance Cold StorageMaintenance490-45201-580Maintenance Shop EquipmentParks490-45202-530Parks ImprovementsParks490-45202-580Parks EquipmentParks490-45202-550Parks Motor Vehicles EDAEDA 375 10 770 2,800.27 2,800.2 3,253.953,327.57 3,327.5 1,500.001,000.001,000.00 3,500.0 Funds 14,771.71 14,771.7 31,062.40 31,062.4 72,259.5899,323.7787,250.0074,000.0023,001.0014,000.0012,688.1390,908.2511,376.62 Available385,776.4102,284.8543,523.2 9 0 6/3 201 u / 9 201 000 0000 0 ment + trade in val 9 y 200.00 200.0 1,300.00 1,300.0 6,000.00 6,000.0 2,750.00 2,750.0 1,300.001,500.003,000.002,500.002,000.003,000.001,500.001,000.001,000.00 3,500.0 BudgetAdjustmentsSpentReserve 12,500.0012,500.0010,000.00 45,300.0 10,000.00 13,000.072,050.0 er with new tan g 35 07 717 h cas y 1,500.2 8,771.71 8,771.73,127.5 last lon 28,312.40 28,312.4 11,500.00 89,284.8 y AvailableGrants340,476.4471,473.2 12/31/20186/30 2 2021 - 10% down pa - - ma 203 8 - #277,250.00 2022 - pa - #372,500.00 #420,001.00 Lot 202 Van59,759.58- Radios80,908.25 Truck86,823.77 Repairs Rig Truck Wheeler1,953.95 MHz Painting Computers1,500.27 Tanker Air Packs 6 Parking RescueGrass 3 Replacement10,688.13Replacement8,376.62Replacement3,127.57 Turnout Gear Pumper Ladder800 Building Extrication Equip Rescue VanPumper TruckLadder Truck #2Tanker #4 201220242012202220122032200120211997202219992028201320192007201720112017-202220082017-202420122022201220322001202119992028 annualannual g on goingon goingon goingon goingon goingon goingon goingon going 2010-20112017-20181996-20052019-2026 PurchasedReplaceReserve Buildin e Building than than other other ObjectYearYearDescriptionFunds201 t e ReserveReserve Hardware/Softwar EquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipment 2019 Hardware/Software t t EquipmentEquipmentEquipmentEquipment Reserv tImprovements Equipmen Payable Computer Equipmen for Equipmen Department Building OtherEquipmentEquipmen & t Plan Fire Services BuildingEquipmentBuildingEquipmentBuildingImprovements ķ &&& AdministrationFightingFightingFightingCommunicationsStation CǒƓ ServicesOther Joseph Departmen Equipment FireFireFireFireFireMedicalFire Adopted December 17, 2018 CźƩĻ St. AdministrationComputerFightingOtherFightingFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterComm unicationOtherCommunicationOtherStationStationStationFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighter Proposed Debts TotalTotalTotalTotalTotalTotalTotal Capital e 580Fire584Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire580Fire580Fire580Medical530Fire530Fire530Fire585Fire585Fire585Fire585Fire 9ƨǒźƦƒĻƓƷ 581/582Fire Cod 4222042220422204222042220422204222042220422204222042250422504227042280422804228042220422204222042220 /ğƦźƷğƌ 42210 Account 105105105105105105105105105105105105105105105105105105105105 105 ƚƷğƌ Note: The fire department is funded by the City of St. Joseph, St. Joseph Township and St. Wendel Township. # CIP FD-1401FD-1402FD-1404FD-1403FD-1405FD-1406FD-1407FD-1408FD-1409FD-1417FD-1410FD-1411FD-1412FD-1413FD-1414FD-1415FD-1416FD-1405FD-1406FD-1407FD-1409 e 3,500.001,965.001,208.755,000.005,000.002,000.007,250.006,203.051,965.001,665.002,000.008,000.00 40,000.0012,250.0020,000.0017,274.1326,727.0055,794.5029,604.9461,900.0013,475.0013,800.0013,800.0016,200.00 142,174.88224,407.49 6/302019 (54.00) (456.25)(525.00) of(456.25)(579.00) as / 500.00500.00 3,500.001,465.001,665.005,000.005,000.002,000.001,000.005,000.005,000.003,500.001,465.001,665.002,000.006,900.002,300.002,300.002,200.00 20,000.0010,000.0015,000.0010,000.00 60,130.0047,830.00 # 500.00500.00 6,250.002,703.057,500.00 ######## 20,000.0011,750.0010,000.0012,274.1321,727.0040,848.5019,604.94 82,501.13 12/31/2018Grants 2020 goinggoinggoinggoing 20212021 // 2018/20202018/2020 goingongoingongoingongoingon new2020new2022new2022new2020new2022new2022 2017202720062021201020202008201720152020201420221995est.2015202120162021 20132013 onononon 2008/20092022 1984/20052006/20081984/20052006/2008 Study LS14,000.00 LS11,500.00 LS11,500.00 LS14,000.00 St s LS55,000.00 Model e FoamingPlan Work RidgewoodBakerNorthlandCR121 Main StudyStudy Plan System Programmer RateSewerRate Replacement Public Planr Maintenanc pumpspumpspumpspumps 2018 ExpansionExpansion BathroomsBathrooms Roof Meter Protection Plan 17, RepairsRepairs SupplyDistributionTower LiningTelevising/RootSample Replacement (1/4)(1/4) 12 #4/5 TankTank BuildingBuilding Expenditures TruckFuelKlinefelterPWWaterWaterWellheadHandheldComprehensiveWaterWellWTPWTPTruckFuelSewerPWKlinefelterSewerComprehensiveComprehensiveSewerPumpSubmersibleSubmersibleSubmersibleSubmersible December Equipment Capital 18041401140818051803140214031403140314031403 15031503 1804180518051805140118031712140214031403 1403141114031411 2019 WTWTWTWTWTWTWTWTWTWT Capital PWPWPWPW ENGWWWWENGWWWWWWWWWWWWWWWWWW Adopted 000000000000000000000000000 555852523030305830532258585558535252303030585853535353 CodeNumberEquipmentYearYearBalance201920192019Balance 494404944049440494404944049440494344949049490494354941049420494214945049450494504945049450494504945049490494804948049471494704947249473 Enterprise 601601601601601601601601601601601601602602602602602602602602602602602602602602 601 ProjectProjectPurchaseReplaceReserveBudgetTransfersSpentAvailabl DepartmentAccount WaterSewer e 2,000.001,000.008,692.626,600.00 8,692.62 14,550.0036,480.5564,000.0079,902.2432,000.00 38,600.00 197,932.79 6/302019 of as (22,073.30) (22,073.30) / 500.00 1,000.001,000.002,000.001,000.002,000.006,600.008,000.00 2,000.00 11,000.00 16,500.0014,600.00 # 6,692.62 6,692.62 ######## 14,050.0056,553.8553,000.0078,902.2424,000.00 24,000.00 12/31/2018Grants goinggoinggoing goingongoingongoingon n/a2021 19972020 ononon 2002/20142023/2029 s Compliance1,000.00 Work Lighting Schedule (1/4) Public Improvements r SWPPP/Permit 2018 Driveway Plan Loader Easements/Acquire 17, MS4 Quality SweepeLighting Mapping End Maintenance Expenditures UpdatePondAerialWaterStreetPropertyFrontMillstreamStreet December Improvement Capital 14071425 1712180514041405140618011410 SLSL 2019SSSSSSSSSS PWPW Adopted 330000000 Capital 303053535851585353 CodeNumberEquipmentYearYearBalance201920192019Balance 499004990049900499004990049900432304316043160 Enterprise 651651651651651603652652 651 LightingLighting ProjectProjectbegincompleteReserveBudgetTransfersSpentAvailabl DepartmentAccount StormwaterRefuseSt.St. City of St. Joseph Park Board 2019 Capital Improvement Budget Summary Council adopted December 17, 2018 General FundsBalance Park Dedication Cash June 30, 2019119,534$ (Unaudited) Adjustments Starting Balance119,534$ 2019 General Levy-remaining13,361$ Other Revenues-remaining(4,103)$ Potential Projects:PotentialProposed Millstream Cottages-phase 223,400$ Industrial Park \[2019+\]8,580$ Sunset Ridge-phase 2 - 4 lots2,000$ Ending Balance for 2019137,372$ Projects - Budget201820192020202120222023Total 19-23 PTR-01 (Millstream)40,000$ -$ -$ 100,000$ -$ -$ 100,000$ PTR-02 (Northland)-$ -$ -$ -$ 180,000$ -$ 180,000$ PTR-03 (Klinefelter)-$ -$ -$ -$ 250,000$ -$ 250,000$ PTR-04 (Wobegon)-$ -$ -$ -$ -$ -$ -$ PTR-05 (Memorial)5,200$ 600$ -$ -$ -$ -$ 600$ PTR-06 (Centennial)-$ -$ -$ -$ -$ -$ -$ PTR-07 (Monument)35,250$ 250$ 250$ 250$ 250$ 250$ 1,250$ PTR-08 (Hollow)1,000$ -$ -$ -$ -$ -$ -$ PTR-09 (Cloverdale)-$ -$ -$ -$ -$ -$ -$ PTR-10 (East Park)24,620$ 296,610$ 600,000$ -$ -$ 520,000$ 1,416,610$ PTR-12 (Trails)10,000$ 10,000$ 10,000$ 10,000$ 10,000$ 10,000$ 50,000$ PTR-13 (Trees)2,000$ 2,000$ 2,000$ 2,000$ 2,000$ 2,000$ 10,000$ PTR-14 (Dog Park)20,000$ -$ -$ 10,000$ -$ -$ 10,000$ PTR-15 (Skate Park)-$ -$ -$ 125,000$ -$ -$ 125,000$ Total138,070$ 309,460$ 612,250$ 247,250$ 442,250$ 532,250$ 2,008,460$ Projects - ActualSpent 20182019Other 19 Expenses Budget:2019 YTD PTR-01 (Millstream)31,550$ -$ Real Estate Taxes-$ 3,798$ PTR-02 (Northland)-$ -$ A-1 Toilets2,150$ 895$ PTR-03 (Klinefelter)-$ -$ 2019 YTD PTR-04 (Wobegon)-$ -$ 2019 Revenue Budget: PTR-05 (Memorial)-$ -$ Interest500$ 1,955$ PTR-06 (Centennial)-$ -$ Round Up135$ 60$ PTR-07 (Monument)-$ -$ GF Levy20,000$ 6,639$ PTR-08 (Hollow)-$ -$ Land Rent-$ -$ PTR-09 (Cloverdale)-$ -$ Transfer-$ -$ PTR-10 (East Park)21,994$ 7,986$ design, phase 1, plantingsDonations500$ 102$ PTR-11 (West Park)-$ -$ Park Dedic.8,580$ 11,700$ PTR-12 (Trails)-$ -$ PTR-13 (Trees)1,000$ -$ 19 Dog Park Donation Budget:2016-2019 PTR-14 (Dog Park)-$ -$ pavers/treats1,149$ Total54,544$ 7,986$ cash10,000$ 5,703$ thru 6/30/19