Loading...
HomeMy WebLinkAbout2019 3rd Quarter Financial Report Council Agenda Item 5c MEETING DATE: October 21, 2019 AGENDA ITEM: Financial Report – 3rd Quarter & September 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 September 30, 2019. CASH POSITION: - The market rate of return (ROR) is approximately 2.38% with an average maturity of 31 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 State money market fund (PMA 4M). - In September, the Federal Open Market Committee \[FOMC\] reduced the federal fund rates nd 0.25% (2 consecutive decrease) to a rate of 1.75 to 2.5% citing the labor market remained strong and that economic activity had been rising at a moderate rate. Unemployment remains low and household spending had been rising at a strong pace. However, business fixed investment and exports had weakened. The uncertainty of international trade and the ongoing weakness in global economic growth continue to weigh on the domestic economy. Further, inflation remained low. - Interest earnings for 2019 amounts to a $263,994. 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 much higher than anticipated for the year. The strong US economy is reflected in the positive earnings. - Overall, the cash and investments balance increased $4,599,864, including $4,278,081 in 2019A bond proceeds, from the beginning of the year. The first half tax settlements and LGA were th received. Much of the bond proceeds will be spent in the 4 quarter 2019 and in 2020. FUNDS REPORT: - The General fund spent 71% of the 2019 expenditure budget and received 60% of the revenue budget. Expenditures and revenues are mainly operational in nature. The community center repairs and maintenance exceed budget. The City did not have much history to the operational expenditures as the City took over from the School District in 2018. The revenues are on target through September. There was a one-time receipt of $53,000 for the conduit debt issue by Country Manor. Building permit fees are over budget as well as interest earnings. - The Enterprise Funds represent seven months utility billing revenue collected while expenses represent nine months. Overall, 49% of expenses have been incurred (less depreciation); 50% of st the revenue budget has been received. Revenues and expenses are general in nature plus 1 half bond interest expenses. In addition, the sewer fund paid off a couple debts early. 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 $238,535 WAC/Trunk fees in the first three quarters. New connections include five new homes, one sewer only th account connected to city water, Oaks on 20 apartments, phase 2, Country Manor final payment and Dollar General. Water revenues represent 66%, expenses 37% of the budget at the end of September 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 the second phase of the Oaks on 20 apartments and Dollar General were received. Sewer expenses are at 71% of the budget, while revenues are at 49% of the budget. The City Council approved paying off a sewer bond and sewer note early. The expenses reflect these payoffs. The sewer fund also replaced pumps in the Northland lift station. Other revenues/expenses are operational in nature. ½ ¢ Sales Tax (fund 200): The sales tax fund has a cash balance of $141,049. 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, $3.5M 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. Staff requested the federal grant recently now that that trail project is substantially completed. The sales tax revenue represents sales taxes collected through July. There is a 2-3 months lag for the State to collect and remit to the communities. The total collected as of September 30, 2019 is $259,023. CIP REPORTS: - General capital equipment purchases include costs to upgrade cable access equipment. The City also bought out squad 702 from the leasing company. In addition, a computer system was purchased for the finance tech and scanner was replaced for the deputy clerk. Public Works replaced the Gator used for general maintenance and watering the hanging flowers. Cameras were added to the community center and park shelters. - 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 September Financial Reports 3rd Quarter Reports: Cash Position as of 9/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 September 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 3rd quarter and September 2019 financial reports. Thispageintentionally leftblank Total SB avg Total CMCU avg Total 4M Total Deposits7,452,985$ avg avg Total RBC Total Investments4,916,563$ ağƩƉĻƷ {ğǝźƓŭƭ {ĻĭǒƩźƷźĻƭ aƚƓĻǤ/5ƭ ağƩƉĻƷ /5ƭ ЌЌі /ŷĻĭƉźƓŭaƚƓĻǤ.ğƓƉ.ƩƚƉĻƩĻķDƚǝĻƩƓƒĻƓƷ.ƩƚƉĻƩĻķ Ͳ ЌͲВЌЌͲЏЎВ ЋЌі Ͳ ЋͲАЍЉͲЌЉЉ IƚƌķźƓŭƭ Ћі Ͳ LƓǝĻƭƷƒĻƓƷ ЋАЎͲАЋЋ ğƓķ /ğƭŷ Љі Ͳ ЌАͲЌЉЌ ЌВі Ͳ Ќі Ͳ ЍͲЎАВͲЊВА ЌЉЉͲЉЏЌ includes bond proceeds BudgetActual BudgetActual ExpExpRevRev $232,226 $332,180 Fund $119,325 Revenues & $332,180 Expenditures Actual to $1,965,093 Budget FundFire $3,248,925 Fire & General $2,271,768 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 2019 Revenue Budget1,301,300.00 (includes fund 501) 2019 Expense Budget(946,300.00) (excludes depreciation, includes 501) The balances represent the cash balance as of 9/30/19 2019 Revenue Budget1,723,255.00 (includes fund 502) 2019 Expense Budget(1,328,755.00) (excludes depreciation,includes fund 502) The balances represent the cash balance as of 9/30/19. As of September 30, 2019 $8,800 State SHIP Grant $110 anonymous donation $40,000 Lion's donation transfers from other funds $1.794M bond proceeds plus $32K APO funded Total Projects Completed 300,000$300K State Bonding request 7,500,000$6M donations est.; $1.5M state bonding request cover bond payments due to deferred assessments $650,594 federal funding Total Projects in Progress Fund 200 Balance, December 31, 2018, audited anticipated remaining 2019 sales tax revenues to collect anticipated remaining 2020-2038 sales tax revenues to collect Committed - to be funded Anticipated remaining balance after commitments uncommitted annually (5 yr Average) Projects that have been discussed for Sales Tax Funding, not approved $2M donations est. $1.5M State Bonding request $50K donations est. Total Projects Not Approved (original estimate $3,272,754) MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance Last Dim 10100 GeneralG 101-10100$1,776,179.52$27,132.31$214,381.87$1,388,141.54 Employee Retirement ReserveG 102-10100$122,343.34$0.00$0.00$136,144.58 Fire FundG 105-10100$581,626.46$4,735.85$5,049.30$648,001.38 Cable Access FeeG 108-10100$5,119.57$306.00$0.00-$10,417.91 Economic DevelopmentG 150-10100$58,897.49$235.50$2,247.86$55,710.90 TIF 3-1 CMCUG 152-10100$183.67$16.33$0.00$1,439.35 TIF 4-1 Fortitude Senior AptsG 153-10100$4,527.85$24.29$0.00$3,944.49 TIF 2-1 MillstreamG 157-10100$25,642.09$89.66$0.00$27,888.26 TIF 2-2 Meat MarketG 158-10100$495.50$4.93$0.00$706.28 TIF 2-3 Bayou Blues/Alley FlatG 159-10100$1,278.12$0.86$0.00$260.35 State Collected Sales TaxG 200-10100$827,524.42$61,315.82$123,966.12$143,733.20 Park DedicationG 205-10100$111,372.46$354.99$1,173.50$123,813.87 Charitable GamblingG 215-10100$2,096.31$6.04$0.00$2,177.84 Lodging TaxG 220-10100$30,334.72$2,655.72$4,675.00$33,612.73 DEED CDAP GrantG 225-10100$34,945.69$85.64$0.00$39,086.40 Revolving Loan FundG 250-10100$211,358.83$609.10$0.00$219,583.38 2016 CIP Bonds \[govt center\]G 301-10100$48,948.00$376.27$0.00$149,408.86 2017A CIP Bonds \[govt center\]G 303-10100$104,072.28$3,346.69$0.00$130,963.06 2016 Street Imp \[Field St\]G 304-10100$67,219.44$213,893.33$233.00$318,449.78 2017B Street Imp \[CBD Alleys\]G 305-10100$52,970.17$171.38$0.00$62,996.33 2018 Equipment CertificatesG 306-10100$50.07$233.77$0.00$29,114.52 2019A Street Imp \[Overlays\]G 307-10100$0.00$21,756.89$19,195.00$30,485.51 2019A Street Imp \[Ind Park\]G 308-10100$0.00$27,125.00$27,132.50-$957.50 2010B Refunding \[Hill/Clover\]G 333-10100$132,425.71$488.42$0.00$180,476.32 2011A CO Refund \[Interior St\]G 338-10100$81,909.29$352.29$139,515.00-$7,810.57 2010B Street Imp \[16th Ave\]G 345-10100$150,570.60$448.47$0.00$162,877.51 2011A Pumper Truck CertificatG 346-10100$39.94$67.11$41,380.00-$15,405.08 2013 Street Imp \[Overlays\]G 348-10100$86,921.38$270.76$0.00$98,737.37 2014 Street Imp \[ParkTerrace\]G 350-10100$205,032.07$697.48$0.00$256,634.11 2015 Street Imp\[Clinton/North\]G 351-10100$134,912.55$499.16$0.00$184,281.77 2015 Equipment CertificatesG 352-10100$1,044.81$203.83$0.00$81,065.13 2015 Abatement \[Comm CenteG 353-10100$28,351.01$478.55$0.00$172,534.16 Debt Service ReliefG 390-10100$539,508.46$11,180.00$11,680.00$530,058.23 Community Center phase IG 402-10100$2,468.78$8.57$0.00$3,087.59 2018 Equipment CertificatesG 406-10100$65,256.32$0.00$0.00$51,272.62 2019 Street OverlaysG 407-10100$0.00$1,803,289.75$24,686.59$1,932,171.04 2019 Industrial Park ExpansionG 408-10100$0.00$2,523,030.80$35,067.63$2,281,193.03 Capital OutlayG 490-10100$409,574.39$0.00$568.99$463,036.37 WAC FundG 501-10100$409,128.81$1,783.13$0.00$672,542.87 SAC FundG 502-10100$88,820.42$475.45$0.00$175,981.88 Water FundG 601-10100$602,018.79$60,526.93$32,891.39$953,486.85 Sewer FundG 602-10100$232,989.51$41,482.73$400,872.25$87,438.01 Refuse CollectionG 603-10100$244,488.14$11,818.85$23,315.83$226,927.45 Storm Water UtilityG 651-10100$251,993.02$8,764.48$4,860.68$295,363.02 Street Light UtilityG 652-10100$35,043.36$2,222.98$4,582.99$49,310.99 Last Dim 10100$7,769,683.36$4,832,566.11$1,117,475.50$12,369,547.87 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 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance $7,769,908.36$4,832,566.11$1,117,475.50$12,369,772.87 2019September2019 FUNDFUND DescrYTD Budget2019 AmtYTD Amt 101General$3,184,310.00$25,747.32$1,904,088.50 102Employee Retirement Reserve$56,705.00$0.00$56,705.00 105Fire Fund$332,180.00$4,649.49$232,226.35 108Cable Access Fee$7,910.00$306.00$4,299.06 150Economic Development$290,715.00$161.74$137,442.20 152TIF 3-1 CMCU$0.00$16.33$22,151.50 153TIF 4-1 Fortitude Senior Apts$0.00$24.29$24,111.24 157TIF 2-1 Millstream$0.00$89.66$23,011.81 158TIF 2-2 Meat Market$0.00$4.93$4,865.22 159TIF 2-3 Bayou Blues/Alley Flat$0.00$0.86$170.40 200State Collected Sales Tax$540,000.00$61,315.82$296,306.91 205Park Dedication$29,715.00$354.99$29,952.02 215Charitable Gambling$10.00$6.04$73.76 220Lodging Tax$14,100.00$2,655.72$13,617.71 225DEED CDAP Grant$25.00$85.64$16,577.67 250Revolving Loan Fund$1,100.00$609.10$7,448.98 3012016 CIP Bonds \[govt center\]$270,300.00$376.27$143,343.58 3032017A CIP Bonds \[govt center\]$0.00$3,346.69$30,821.33 3042016 Street Imp \[Field St\]$49,155.00$213,893.33$261,207.07 3052017B Street Imp \[CBD Alleys\]$32,820.00$171.38$14,315.41 3062018 Equipment Certificates$57,005.00$233.77$32,033.38 3072019A Street Imp \[Overlays\]$0.00$19,356.89$48,230.51 3082019A Street Imp \[Ind Park\]$0.00$27,125.00$27,125.00 3332010B Refunding \[Hill/Clover\]$73,800.00$488.42$50,693.33 3382011A CO Refund \[Interior St\]$120,405.00$352.29$53,492.18 3452010B Street Imp \[16th Ave\]$36,975.00$448.47$17,569.37 3462011A Pumper Truck Certificate$42,870.00$67.11$27,276.67 3482013 Street Imp \[Overlays\]$23,310.00$270.76$15,008.41 3502014 Street Imp \[ParkTerrace\]$110,010.00$697.48$66,167.44 3512015 Street Imp\[Clinton/North\]$43,545.00$499.16$52,173.04 3522015 Equipment Certificates$36,010.00$203.83$79,574.11 3532015 Abatement \[Comm Center\]$160,570.00$478.55$163,959.21 390Debt Service Relief$0.00$0.00$5,785.92 402Community Center phase I$0.00$8.57$609.98 4062018 Equipment Certificates$0.00$0.00$0.00 4072019 Street Overlays$0.00$1,803,289.75$2,082,775.00 4082019 Industrial Park Expansion$0.00$2,523,030.80$2,523,030.80 490Capital Outlay$139,425.00$0.00$69,735.57 501WAC Fund$0.00$1,783.13$257,113.92 502SAC Fund$162,500.00$475.45$84,705.82 601Water Fund$1,301,300.00$58,670.67$602,691.36 2019September2019 FUNDFUND DescrYTD Budget2019 AmtYTD Amt 602Sewer Fund$1,560,755.00$41,371.67$752,657.12 603Refuse Collection$304,700.00$11,781.98$180,288.12 651Storm Water Utility$112,295.00$8,764.48$107,831.76 652Street Light Utility$82,240.00$2,222.98$44,029.25 $9,176,760.00$4,815,436.81$10,567,292.99 2019September2019 FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt FUND 101 General 101GeneralCurrent Ad Valorem Taxes$1,424,710.00$0.00$680,995.52 101GeneralSpecial Levy- City St. Joe$0.00$0.00$143.22 101GeneralState Sales Tax$0.00$151.62$188.66 101GeneralGravel Tax$13,670.00$0.00$4,783.02 101GeneralSolar Production Tax$500.00$0.00$1,986.32 101GeneralGas Franchise$32,760.00$0.00$16,346.40 101GeneralElectric Franchise$62,185.00$2,412.52$36,870.58 101GeneralLicenses & Permits$12,450.00$0.00$10,000.00 101GeneralBeer$0.00$0.00$0.00 101GeneralLiquor$28,185.00$0.00$26,795.00 101GeneralOutdoor Liquor Permit$2,000.00$300.00$3,700.00 101GeneralGambling Permits$350.00$0.00$240.00 101GeneralAmusement/Hunt/Peddler/Golf$1,400.00$100.00$485.00 101GeneralExcavation Permit$500.00$0.00$250.00 101GeneralCigarette License$675.00$0.00$0.00 101GeneralCable Franchise Fee$34,870.00$1,480.72$18,111.45 101GeneralBuilding Permits$145,000.00$3,291.58$159,721.98 101GeneralAnimal License$3,100.00$30.00$3,490.00 101GeneralRental Housing Registration$30,180.00$0.00$31,188.75 101GeneralFederal Grants - Other$8,000.00$0.00$580.48 101GeneralState Grants and Aids$1,100.00$0.00$0.00 101GeneralLocal Government Aid$994,435.00$0.00$497,217.50 101GeneralPERA Rate Increase Aid$1,540.00$0.00$770.50 101GeneralPolice Training Reim$3,500.00$0.00$9,941.77 101GeneralState Municipal Funds Aid$55,800.00$0.00$59,989.00 101GeneralState Police Aid$65,000.00$0.00$1,041.54 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$400.00$5,305.00 101GeneralLand Use Deposit Fee$4,000.00$0.00$11,000.00 101GeneralSale of Maps and Publications$25.00$1.25$9.50 101GeneralConduit Debt Fee$0.00$0.00$53,000.00 101GeneralAssessments Search$4,000.00$450.00$5,400.00 101GeneralSpecial Hearing$2,000.00$0.00$3,625.00 101GeneralAdministration Reimb$13,000.00$0.00$99.96 101GeneralWeed Cutting$500.00$0.00$200.00 101GeneralAdmission Fee$1,000.00$78.00$1,096.00 101GeneralShelter/Room Rental Fees$10,000.00$100.00$9,250.00 101GeneralBall Field Donation$100.00$0.00$0.00 101GeneralSchneider Field Rental$1,500.00$0.00$1,090.00 2019September2019 FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt 101GeneralRents and Royalties$59,055.00$6,468.41$58,215.69 101GeneralKennel Fees$300.00$0.00$25.00 101GeneralCounty Fines$38,000.00$1,935.45$14,488.54 101GeneralPolicy Fines$20,000.00$200.00$24,042.72 101GeneralAccident Report Fee$1,300.00$195.00$1,233.50 101GeneralSeized Property$2,000.00$0.00$0.00 101GeneralSpecial Assessments$4,000.00$0.00$2,646.17 101GeneralInterest Earnings$20,000.00$5,313.36$63,313.68 101GeneralInterest Charges$100.00$200.00$200.63 101GeneralCo-op Dividend - LMCIT$10,000.00$0.00$0.00 101GeneralWater Tower Antenna Lease$4,170.00$513.43$3,003.73 101GeneralAdvertising$1,200.00$0.00$1,420.00 101GeneralContributions - General$2,000.00$0.00$3,500.00 101GeneralContributions - Parks$250.00$159.65$516.98 101GeneralSurplus Property$0.00$0.00$0.00 101GeneralReimbursement$28,600.00-$100.00$31,826.88 101GeneralInsurance Recovery$2,000.00$2,066.33$2,977.83 101GeneralTransfers from Other Funds$0.00$0.00$36,765.00 FUND 101 General$3,184,310.00$25,747.32$1,904,088.50 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$306.00$4,299.06 108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00 FUND 108 Cable Access Fee$7,910.00$306.00$4,299.06 FUND 150 Economic Development 150Economic DevelopmentCurrent Ad Valorem Taxes$111,240.00$0.00$52,795.34 150Economic DevelopmentFederal Grants - Other$178,625.00$0.00$62,056.00 150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$500.00 150Economic DevelopmentTax Abatement Reimbursement$0.00$0.00$7,208.00 150Economic DevelopmentInterest Earnings$850.00$161.74$1,255.20 150Economic DevelopmentTransfers from Other Funds$0.00$0.00$13,627.66 FUND 150 Economic Development$290,715.00$161.74$137,442.20 FUND 490 Capital Outlay 490Capital OutlayCurrent Ad Valorem Taxes$138,925.00$0.00$65,735.57 490Capital OutlayFederal Grants - Other$0.00$0.00$0.00 490Capital OutlaySurplus Property$500.00$0.00$4,000.00 FUND 490 Capital Outlay$139,425.00$0.00$69,735.57 2019September2019 FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt $3,679,065.00$26,215.06$2,172,270.33 FUND2019September2019 FUNDDescrSOURCE DescrYTD Budget2019 AmtYTD Amt FUND 601 Water Fund 601Water FundMDS Test Fee$11,500.00$448.90$6,376.17 601Water FundCurrent Ad Valorem Taxes$22,500.00$0.00$11,536.98 601Water FundContributed Revenue$0.00$0.00$0.00 601Water FundWater Fixed Charge$326,220.00$11,353.55$180,324.64 601Water FundWater Meter$5,510.00$0.00$8,980.00 601Water FundPenalties and Forfeited Disc$8,130.00$122.76$3,532.93 601Water FundUndesignated Funds$2,000.00-$9.99$3,389.40 601Water FundBulk Water$3,500.00$790.18$1,786.43 601Water FundReimbursement$0.00$0.00$1,535.52 601Water FundWater Tower Antenna Lease$37,525.00$4,620.81$27,033.27 601Water FundAmortization of Bond Premium$0.00$0.00$0.00 601Water FundInterest Earnings$2,000.00$2,399.69$24,157.78 601Water FundSpecial Assessments$700.00$0.00-$338.86 601Water FundState Sales Tax$0.00$978.54$801.62 601Water FundState Grants and Aids$0.00$0.00$0.00 601Water FundUsage Rate$674,715.00$37,966.23$333,575.48 601Water FundTransfers from Other Funds$207,000.00$0.00$0.00 FUND 601 Water Fund$1,301,300.00$58,670.67$602,691.36 FUND 602 Sewer Fund 602Sewer FundOther Governmental Unit$0.00$0.00$0.00 602Sewer FundPenalties and Forfeited Disc$7,620.00$100.00$3,711.60 602Sewer FundSanitary Sewer Use Service$837,225.00$22,817.60$436,576.67 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$89.00$605.00 602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00 602Sewer FundSpecial Assessments$250.00$0.00$0.00 602Sewer FundState Grants and Aids$0.00$0.00$0.00 602Sewer FundTransfers from Other Funds$162,000.00$0.00$0.00 602Sewer FundGain on Disposal of Assets$0.00$0.00$0.00 602Sewer FundInterest Earnings$16,160.00$2,668.61$19,843.81 602Sewer FundInsurance Recovery$0.00$0.00$0.00 602Sewer FundSewer Fixed Charge$532,750.00$15,696.46$291,920.04 FUND 602 Sewer Fund$1,560,755.00$41,371.67$752,657.12 FUND 603 Refuse Collection 603Refuse CollectSpecial Assessments$200.00$0.00$0.00 603Refuse CollectContributed Revenue$0.00$0.00$0.00 603Refuse CollectReimbursement$0.00$0.00$1,460.40 603Refuse CollectInterest Earnings$2,000.00$661.67$8,173.11 603Refuse CollectPenalties and Forfeifted Disc$5,500.00$38.66$1,505.78 603Refuse CollectRefuse Collection Charges$271,760.00$10,081.46$146,535.21 603Refuse CollectState Grants and Aids$0.00$0.00$0.00 603Refuse CollectLicenses & Permits$25,240.00$420.00$24,265.60 603Refuse CollectState Sales Tax$0.00$580.19-$1,651.98 603Refuse CollectContributions - General$0.00$0.00$0.00 FUND 603 Refuse Collection$304,700.00$11,781.98$180,288.12 FUND 651 Storm Water Utility FUND2019September2019 FUNDDescrSOURCE DescrYTD Budget2019 AmtYTD Amt 651Storm Water Special Assessments$400.00$0.00$0.00 651Storm Water Penalties and Forfeifted Disc$1,500.00$13.30$453.63 651Storm Water Storm Water Use Service$84,385.00$2,957.47$46,489.76 651Storm Water Storm Water Develop Fee$4,000.00$5,000.00$51,714.20 651Storm Water Contributed Revenue$0.00$0.00$0.00 651Storm Water Interest Earnings$2,000.00$793.71$8,974.17 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$8,764.48$107,831.76 FUND 652 Street Light Utility 652Street Light UPenalties and Forfeited Disc$1,000.00$9.97$342.40 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$0.00$0.00 652Street Light UInterest Earnings$335.00$137.92$1,420.42 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$2,075.09$42,230.43 FUND 652 Street Light Utility$82,240.00$2,222.98$44,029.25 $3,361,290.00$122,811.78$1,687,497.61 2019September2019 DescriptionYTD Budget2019 Amt YTD Amt General$3,184,310.00$207,380.38$2,209,096.59 Employee Retirement Reserve$0.00$0.00$42,903.76 Fire Fund$332,180.00$4,962.94$119,325.16 Cable Access Fee$7,910.00$0.00$19,768.00 Economic Development$290,715.00$2,174.10$131,822.35 TIF 3-1 CMCU$795.00$0.00$20,910.80 TIF 4-1 Fortitude Senior Apts$0.00$0.00$24,706.18 TIF 2-1 Millstream$34,545.00$0.00$20,890.27 TIF 2-2 Meat Market$4,545.00$0.00$4,656.23 TIF 2-3 Bayou Blues/Alley Flat$795.00$0.00$1,188.42 State Collected Sales Tax$1,130,000.00$123,966.12$1,059,264.47 Park Dedication$311,610.00$1,173.50$17,894.88 Charitable Gambling$3,500.00$0.00$0.00 Lodging Tax$14,100.00$4,675.00$11,056.50 DEED CDAP Grant$12,500.00$0.00$12,500.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$233.00$9,389.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 2019A Street Imp \[Overlays\]$0.00$16,795.00$17,745.00 2019A Street Imp \[Ind Park\]$0.00$27,132.50$28,082.50 2010B Refunding \[Hill/Clover\]$141,525.00$0.00$3,206.25 2011A CO Refund \[Interior St\]$144,140.00$139,515.00$144,030.00 2010B Street Imp \[16th Ave\]$66,715.00$0.00$5,802.50 2011A Pumper Truck Certificate$42,870.00$41,380.00$42,760.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$500.00$15,875.00 Community Center phase I$0.00$0.00$0.00 2018 Equipment Certificates$0.00$0.00$13,983.70 2019 Street Overlays$0.00$24,686.59$150,603.96 2019 Industrial Park Expansion$0.00$35,067.63$241,837.77 Capital Outlay$139,425.00$568.99$16,744.80 WAC Fund$225,000.00$0.00$0.00 SAC Fund$162,000.00$0.00$0.00 Water Fund$1,571,300.00$31,035.13$347,334.91 2019September2019 DescriptionYTD Budget2019 Amt YTD Amt Sewer Fund$1,990,755.00$400,761.19$940,160.26 Refuse Collection$330,265.00$23,278.96$219,094.43 Storm Water Utility$287,880.00$4,860.68$70,216.14 Street Light Utility$82,240.00$4,582.99$37,551.49 $11,607,070.00$1,094,729.70$6,109,824.18 2019September2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt FUND 101 General GeneralCouncil$65,745.00$9,248.80$45,345.88 GeneralLegislative Committees$5,800.00$16.43$481.19 GeneralOrdinance & Proceedings$2,200.00$125.00$660.78 GeneralMayor$11,865.00$669.57$7,856.79 GeneralElections$4,200.00$0.00$18.70 GeneralGeneral Adminstration$304,960.00$29,625.42$231,617.87 GeneralFinance$217,245.00$14,362.06$110,078.93 GeneralAudit Service$28,450.00$0.00$28,075.00 GeneralAssessing$25,500.00$0.00$27,327.23 GeneralCity Attorney$22,000.00-$26.25$23,305.23 GeneralInformation Technology$0.00$0.00$0.00 GeneralPlanning and Zoning$85,390.00$3,411.93$47,231.98 GeneralGeneral Government$48,485.00$3,130.30$24,441.43 GeneralCity Offices$36,880.00$2,886.87$30,672.84 GeneralCable Access$5,705.00$430.60$2,881.26 GeneralCrime Control & Investigation$1,138,905.00$68,053.51$746,288.38 GeneralPolice Training$6,680.00$0.00$1,380.17 GeneralCommunication Service$15,265.00$6,640.91$14,923.22 GeneralAutomotive Services$48,430.00$3,746.61$31,668.92 GeneralBuilding Inspec. Admistration$95,200.00$7,500.00$48,701.23 GeneralEmergency Management$2,275.00$0.00$2,071.43 GeneralAnimal Control$815.00$0.00$387.86 GeneralStreet Maintanence$330,000.00$15,471.26$188,537.25 GeneralIce & Snow Removal$126,635.00$2,234.37$99,936.17 GeneralEngineering Fee$35,000.00$12,098.93$32,847.79 GeneralStreet Cleaning$14,610.00$475.20$10,720.20 GeneralSkate Park and Ice Rink$5,715.00$40.33$3,219.75 GeneralBall Park$3,600.00$1,765.90$3,314.59 GeneralMaintenance Shop$23,320.00$904.76$17,989.04 GeneralPark Areas$253,665.00$19,244.04$199,059.26 GeneralCommunity Center$91,770.00$5,323.83$92,242.78 GeneralOther Financing Uses$0.00$0.00$36,830.00 GeneralFire Protection$128,000.00$0.00$98,983.44 FUND 101 General$3,184,310.00$207,380.38$2,209,096.59 FUND 102 Employee Retirement Reserve Employee Retirement ReservGeneral Adminstration$0.00$0.00$38,101.58 Employee Retirement ReservCrime Control & Investigation$0.00$0.00$4,802.18 FUND 102 Employee Retirement Reserve$0.00$0.00$42,903.76 FUND 108 Cable Access Fee 2019September2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt Cable Access FeeCable Access$7,910.00$0.00$19,768.00 Cable Access FeeOther Financing Uses$0.00$0.00$0.00 FUND 108 Cable Access Fee$7,910.00$0.00$19,768.00 FUND 150 Economic Development Economic DevelopmentEconomic Development Authority$290,715.00$2,174.10$131,822.35 Economic DevelopmentOther Financing Uses$0.00$0.00$0.00 FUND 150 Economic Development$290,715.00$2,174.10$131,822.35 FUND 490 Capital Outlay Capital OutlayGeneral Adminstration$11,250.00$194.99$1,865.96 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$0.00$8,000.00 Capital OutlayEmergency Management$1,500.00$0.00$0.00 Capital OutlayStreet Maintanence$2,750.00$0.00$3,252.42 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$374.00$3,626.42 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$568.99$16,744.80 $3,622,360.00$210,123.47$2,420,335.50 2019September2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt FUND 601 Water Fund Water FundBond Payment (P & I)$697,695.00$0.00$51,907.75 Water FundOther Financing Uses$12,725.00$0.00$6,725.00 Water FundPower and Pumping$17,420.00$739.09$21,611.45 Water FundPurification-Plant 1$37,955.00$2,935.18$22,797.00 Water FundPurification-Plant 2$87,285.00$8,478.98$52,159.04 Water FundDistribution$10,000.00$0.00$6,506.31 Water FundWellhead Protection$5,500.00$0.00$0.00 Water FundStorage-Tower 1$18,295.00$2,251.03$7,432.18 Water FundWater Maintenance$252,640.00$14,485.14$153,138.85 Water FundAdministration and General$31,785.00$2,145.71$25,057.33 Water FundDepreciation Expense$400,000.00$0.00$0.00 FUND 601 Water Fund$1,571,300.00$31,035.13$347,334.91 FUND 602 Sewer Fund Sewer FundBond Payment (P & I)$236,170.00$234,034.31$212,657.06 Sewer FundOther Financing Uses$19,570.00$0.00$6,570.00 Sewer FundSanitary Sewer Maintenanc$219,075.00$11,810.67$88,059.70 Sewer FundLift Station-Baker Street$6,080.00$685.85$3,191.00 Sewer FundLift Station-Ridgewood/DBL$2,700.00$105.00$1,264.27 Sewer FundLift Station-Northland$4,600.00$9,227.29$10,950.57 Sewer FundLift Station-CR 121$15,150.00$114.43$1,124.03 Sewer FundLift Station-Main$951,605.00$142,581.17$594,057.62 Sewer FundAdministration and General$35,805.00$2,202.47$22,286.01 Sewer FundDepreciation Expense$500,000.00$0.00$0.00 FUND 602 Sewer Fund$1,990,755.00$400,761.19$940,160.26 FUND 603 Refuse Collection Refuse CollectioWaste Collection$321,990.00$23,278.96$217,494.43 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$23,278.96$219,094.43 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$1,221.36$12,692.86 Storm Water UtiStorm Water Maintenance$132,770.00$3,639.32$52,543.28 Storm Water UtiDepreciation Expense$115,000.00$0.00$0.00 FUND 651 Storm Water Utility$287,880.00$4,860.68$70,216.14 FUND 652 Street Light Utility Street Light UtiliStreet Lighting$82,240.00$4,582.99$37,551.49 FUND 652 Street Light Utility$82,240.00$4,582.99$37,551.49 2019September2019 DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt $4,262,440.00$464,518.95$1,614,357.23 9,325.713,500.001,274.682,450.957,604.001,837.583,940.007,604.002,898.58 11,242.5427,371.8727,158.6769,455.5616,359.4337,993.2825,209.3638,572.8312,912.6114,500.0047,684.8260,000.0072,316.6231,270.0098,704.10 (10,417.91) 133,498.46230,171.05575,632.17231,180.76234,079.34 ########## 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 9/30 18.70 434.99113.00 1,430.978,000.008,000.003,252.423,252.426,617.84 19,768.0021,652.6619,267.1019,267.10 55,537.60 9/30through 201920192019Balance 200.00 4,299.064,299.06 69,989.0070,189.00 74,488.06 Summary 2018 Plan 17, 2019 524.68 30, 5,144.418,242.542,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 Availablethrough 113,838.46133,795.05383,581.01167,813.66170,212.24 734,490.87 Expenditures December Equipment September Capital of Capital adopted As 2019 Fund Final General CodeEquipmentBalanceGrant ProjectBudgetReserveTransferred/SpentBudgetRemaining DepartmentAccount SoftwareProjects EDAEDA 2,800.27 2,800.27 3,253.953,327.57 3,327.57 1,500.001,000.001,000.00 3,500.00 14,771.71 14,771.71 31,062.40 31,062.40 72,259.5899,323.7787,250.0073,400.1223,001.0014,000.0012,088.2590,908.2511,376.62 384,576.67102,284.87542,323.49 599.88599.88 1,199.761,199.76 200.00 200.00 1,300.00 1,300.00 6,000.00 6,000.00 2,750.00 2,750.00 1,300.001,500.003,000.002,500.002,000.003,000.001,500.001,000.001,000.00 3,500.00 BudgetAdjustmentsSpentReserve 12,500.0012,500.0010,000.00 45,300.00 10,000.00 13,000.0072,050.00 er with new tan g 1,500.27 8,771.71 8,771.713,127.57 last lon 28,312.40 28,312.40 11,500.00 89,284.87 y AvailableGrants/9/30Available340,476.43471,473.25 12/31/20189/30 - ma #277,250.00 #372,500.00 #420,001.00 Lot Van59,759.58 Radios80,908.25 Truck86,823.77 Repairs Rig Truck Wheeler1,953.95 MHz Painting Computers1,500.27 Tanker 6 Parking RescueGrass 3 Replacement10,688.13Replacement8,376.62Replacement3,127.57 Pumper Ladder800 Building PurchasedReplaceReserve Building Building than than other other ReserveReserve Hardware/Software EquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipment 2019 Hardware/Software EquipmentEquipmentEquipmentEquipment Reserve Improvements Equipment Payable Computer Equipment for Equipment Department Building OtherEquipmentEquipment & Plan Fire Services BuildingEquipmentBuildingEquipmentBuildingImprovements &&& AdministrationFightingFightingFightingCommunicationsStation CǒƓķ ServicesOther Joseph Equipment FireFireFireFireFireMedicalFire CźƩĻ AdministrationComputerFightingOtherFightingFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterComm unicationOtherCommunicationOtherStationStationStationFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighter St. TotalTotalTotalTotalTotalTotalTotal Capital 580Fire584Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire580Fire580Fire580Medical530Fire530Fire530Fire585Fire585Fire585Fire585Fire 9ƨǒźƦƒĻƓƷ 581/582Fire CodeDepartmentObjectYearYearDescriptionFunds201920192019Funds 4222042220422204222042220422204222042220422204222042250422504227042280422804228042220422204222042220 /ğƦźƷğƌ 42210 Account 105105105105105105105105105105105105105105105105105105105105 105 ƚƷğƌ 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.004,834.00 40,000.0012,250.0020,000.0011,314.1326,727.0055,794.5029,604.9461,900.0013,475.0013,800.0016,200.00 136,214.88215,441.49 9/302019 (54.00) (456.25)(525.00) of (5,960.00)(8,966.00) (6,416.25)(9,545.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/20051984/2005 2006/20082006/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.0031,949.5564,000.0079,902.2432,000.00 38,600.00 193,401.79 9/302019 of as (26,604.30) (26,604.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. Lion's donation design, phase 1, plantings thru 9/30/19