The URL can be used to link to this page

Home My WebLink About[04e] Treasurer's Report 11 Council Agenda Item 4e MEETING DATE: September 19, 2016 AGENDA ITEM: Treasurer's Report- August 2016 SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: Cash/investment reconciled through August 31, 2016. Budget to actual reports attached for Council review. The cash and investment balance increased $3,147,835 since the beginning of the year. The first half tax/assessment proceeds and local government aid was received. In addition, bond proceeds for the government center project were received on July 7"'($4.2M). Cash will be spent down the next four months as bond payments,project expenditures and operational expenses continue. The second half tax/assessment and LGA payments will be received in December. The sewer fund shows a cash deficit of $3,713 (after combining with the SAC fund). Utility revenue collections lag expenses. It will take time for the cash balance to recover with the rate increases approved for 2016. Also, development fees will be received in November for the Fortitude senior housing project. Staff will review the water and sewer rates with the Council in October. The General fund spent 63% of the expenditure budget and received 63% of the revenue budget at the end of August. Building permit revenue is over budget totaling $141,633 including thirteen new homes, Kwik Trip, the government center and Country Manor senior housing. More activity is expected this year with the Fortitude senior facility project and CSB athletic fields. The Enterprise funds spent 36% (without depreciation) and received 32% of the revenue budget. The utility bills represent Jan-June usage. Expenses represent eight months. Finally, the last attachment is the monthly summary of the Government Center price revisions and funding summary as of August I Ith. BUDGET/FISCAL IMPACT: None—Information Only ATTACHMENTS: Request for Council Action—Treasurer's Report August 2016 Treasurer's Reports: Cash Balances Month End Revenue Summary Month End Revenue Summary—General Fund Month End Revenue Summary—Enterprise Funds Month End Expenditure summary Month End Expenditure Summary—General Fund Month End Expense Summary—Enterprise Funds Government Center Financial Summary REQUESTED COUNCIL ACTION: Accept the Treasurer's Report as presented. LastDim10100LastDim10200GeneralGeneralStreet LightUtilityStorm WaterUtilityRefuse CollectionSewer FundWaterFundSACFundWACFundCapitalOutlay2015 Equipment Certificates2015 Street\[Clinton/Norcenter\]RevolvingLoanFundCharitableGamblingPark DedicationStateCollectedSalesTaxTIF2-3BayouBlues/AlleyFlatTIF2-2MeatMarketTIF2-1MillstreamTIF4-1FortitudeSeniorAptsTIF3-1CMCUEconomicDevelopmentCableAccessFeeEmployeeRetirementReserveG101-10100G101-10200G652-10100G 651-10100G603-10100G602-10100G601-10100G502-10100G501-10100G490-10100G 452-10100G451-10100G450-10100G447-10100G404-10100G401-10100G390-10100G 353-10100G352-10100G351-10100G350-10100G349-10100G348-10100G347-10100G 346-10100G345-10100G343-10100G338-10100G333-10100G 331-10100G318-10100G304-10100G301-10100G250-10100G215-10100G205-10100G 200-10100G159-10100G158-10100G157-10100G153-10100G152-10100G150-10100G 108-10100G105-10100G102-51$1,212,523.87$264,400.708.56$19,751.90$1,737.30$242.9 00$0.503,486.06$35,213.43$4,560.30$88$586.93$41.68$0.101,341.44$30,592.33$4,560.99$50$150.00$215.0.00$2,360,858.38$98-$253,852.71$120,392.85$19,419.60$24,259.21-$1,331.275.00$275.00$75.03$0.00$0.0009/14/16 4:04PMSt. JosephLast Dim 10100Last Dim10200Page 1Cash Balances Only Current Period: August2016 09/14/164:04PMSt. Joseph 6,379,337.51$503,486.06$993,255.74$9,527,172.51 Page 2 CashBalances Only Current Period: August2016 MTDMTDCurrent FUNDDescrAccountBegin YrDebitCreditBalance 101651603602601502501490452451450404401390353352351350349348347346345343338333331318304301250215205200159158157153152150108105102GeneralStorm WaterUtilityRefuseCollectionSewerFundWaterFundSACFundWACFundCapitalOutlay2015EquipmentCertificates2015Street\[Clinton/Northland\]RevolvingLoanFundCharitableGamblingParkDedicationStateCollectedSalesTaxTIF2-3BayouBlues/AlleyFlatTIF2-2MeatMarketTIF2-1MillstreamTIF4-1FortitudeSeniorAptsTIF3-1CMCUEconomicDevelopmentCableAccessFeeEmployeeRetirement Reserve$1,574,425.00$123,615.00$37,275.00$4,005.00$0.00$101,713.87$21,070.56$9,426.75$586.53$83.60$0.00$4,303,942.10$119,828.15$78$15,000.00$4,165.00$0.0009/14/164:09PMSt. Joseph Page 1CouncilMonthEndRevenue SummaryCurrent Period: August 2016 2016August2016FUNDFUND DescrYTDBudget2016AmtYTD 652StreetLightUtility$61,035.00$4,545.91$29,614.97 09/14/164:09PMSt. Joseph 9,084,340.00$507,791.73$9,102,138.87 Page 2 CouncilMonthEndRevenueSummary Current Period: August2016 2016August2016 FUNDFUND DescrYTDBudget2016AmtYTDAmt 101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101101GeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGenera lGeneralGeneralGeneralCurrent AdValoremTaxesSeized PropertyAccident ReportFeePolicyFinesCountyFinesKennel FeesRentsandRoyaltiesSchneider FieldRentalBall FieldDonationShelter/RoomRentalFeesWeedCuttingAdministrationReimbSpecialHearingAssessmentsSearchSaleofMapsandPublicationsLandUseDeposit FeeCountyGrants - RoadMaint.OtherGovernmentalUnitOtherGrants/AidsStatePoliceAidStateMunicipal FundsAidPoliceTrainingReimPERARateIncreaseAidLocal GovernmentAidStateGrantsandAidsFederalGrants - OtherRentalHousingRegistrationAnimalLicenseBuilding PermitsCable FranchiseFeeCigaretteLicenseExcavation PermitAmusement/Hunt/Peddler/GolfGamblingPermitsOutdoorLiquorPermitLiquorBeerElectric FranchiseGasFranchiseState SalesTax$1,062,065.00$913,760.00$54,1,395.00$00$600.00$500.00$0.11,825.00$2,813.95$5,610.00$250.00$61.00$0.456,850.50$22,669.17$3,195.00$50$550.54$16.00$0.00$0 0009/14/164:10PMSt. Joseph FUND 101 GeneralPage1Council MonthEnd Revenue -General FundCurrent Period: August20162016August2016SFUNDFUNDDescrSOURCEDescrYTD FUND101GeneralFUND153TIF4-1FortitudeSeniorAptsFUND152TIF3-1CMCUFUND150EconomicDevelopmentFUND108CableAccessFeeFUND102EmployeeRetirementReserve1011591591531531531531521521521501 50150150150150150108108102101101101101101101101101101101GeneralTIF 2-3Bayou Blues/AlleyTIF4-1FortitudeSeniorATIF4-1FortitudeSeniorATIF4-1FortitudeSeniorATIF4-1FortitudeSeniorATIF3-1CMCUTIF3-1CMCUTIF3-1CMCUEconomicDevelopmentEconomic DevelopmentEconomic DevelopmentEconomic DevelopmentEconomic DevelopmentEconomic DevelopmentEconomic DevelopmentCableAccessFeeCableAccessFeeEmployeeRetirement ResGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralSpecial AssessmentsInterestEarningsTaxIncrementTransfers fromOtherFundsInterestEarningsTIF/MIFDepositTaxIncrementTransfers fromOtherFundsInterestEarningsTaxIncrementTransfers fromOtherFundsInterestEarningsDEED HousingReimbursementTIF/MIFDepositFederal Grants - OtherLodgingTaxCurrentAdValoremTaxesTransfersfromOtherFundsCableFranchiseFeeTransfers fromOtherFundsTransfersfromOtherFundsReimbursementSurplus PropertyContributions - GeneralAdvertisingWater TowerAntennaLeaseCo-op Dividend - LMCITInterest ChargesInterest Earnings$2,559,980.00$123,615.00$12,000.00$3,770.00$500.00$0.66$12,803.00$1,177.15$466.83$64.00$0.00$1,620,085.96$119,828.00$16,100.46$1,030.00$821.00$0.0009/14/164:10PMSt. JosephFUND102EmployeeRetirementReserveFUND 159TIF2-3BayouBlues/AlleyFlatFUND152TIF3-1CMCUFUND150EconomicDevelopmentFUND 108CableAccess Fee Page 2CouncilMonthEnd Revenue -General Fund Current Period: August 2016 2016August2016SFUNDFUNDDescrSOURCE DescrYTD Budget2016AmtYTD FUND159TIF2-3BayouBlues/AlleyFlat159TIF 2-3BayouBlues/Alley TransfersfromOtherFunds$0.00$0.00$0.00 09/14/164:10PMSt. Joseph 2,726,115.00$106,735.62$1,793,843.92 Page 3 CouncilMonthEndRevenue -GeneralFund Current Period: August2016 2016August2016 SFUNDFUNDDescrSOURCE DescrYTDBudget2016 AmtYTDAmt FUND601WaterFundFUND603RefuseCollectionFUND 602SewerFund601651651651651651603603603603603603603603602602602602602602602602602602602602602601601601601601601601601601601601601601601601601601Wat erFundRefuseCollectRefuseCollectRefuseCollectRefuseCollectRefuseCollectRefuse CollectRefuse CollectRefuseCollectSewerFundSewerFundSewerFundSewerFundSewer FundSewer FundSewer FundSewer FundSewerFundSewerFundSewerFundSewerFundSewerFundWater FundWater FundWaterFundWaterFundWaterFundWater FundWater FundWaterFundWaterFundWaterFundWater FundWater FundWaterFundWaterFundWaterFundWater FundWaterFundWaterTowerAntennaLeaseDevelopment FeeContributed RevenueReimbursementSpecialAssessmentsInterest EarningsRefuseCollectionChargesStateSalesTaxInterestEarningsPenaltiesandForfeiftedDiscSpecial AssessmentsContributions - GeneralLicenses & PermitsContributed RevenueOtherGrants/AidsSurplusPropertySpecialAssessmentsInterest EarningsAmortization ofBondPremiumContributions - GeneralOtherGovernmental UnitReimbursementTransfers fromOtherFundsContributed RevenueSanitary SewerServicePenaltiesandForfeited DiscSewerLineChargeInterest EarningsTransfersfromOtherFundsContributedRevenueMDS TestFeeWaterLineChargeWaterMeterPenaltiesandForfeitedDiscConnection/ReconnectionfeesUndesignated FundsBulkWaterRateClassOneReimbursementSurplus PropertyAmortization ofBondPremiumSpecialAssessmentsState SalesTaxCurrentAdValorem 00$1,063,345.00$294,535.00$73,500.000.00$8,200.00$0.00$0.00$101,076.35$26,842.90-$1,060.09$66$100.07-$81.00$0.499,915.91$13,705.00$2,173.51-$5,475.93$4,673.23$165.00-$16.00-$20.00$0.00$0.0009/14/164:08PMSt. JosephFUND601WaterFundFUND651Storm WaterUtilityFUND603RefuseCollectionFUND 602 Sewer FundPage1Council MonthEnd Revenue -Enterprise FundsCurrent Period: August2016FUND2016August2016 SFUNDDescrSOURCEDescrYTD FUND651StormWaterUtilityFUND652StreetLightUtility651652652652652652651651Storm WaterStormWater RateClassOneInterestEarningsTransfers fromOtherFundsRateClassOneSpecialAssessmentsPenalties andForfeitedDiscPenaltiesandForfeiftedDiscTransfers fromOtherFunds$120,285.00$61,035.00$2,060.00$250.00$50.00$0.00$9,426.75$42.59$0.00$45,210.98$437.48-$2.05$0.00 09/14/164:08PMSt. Joseph FUND652StreetLightUtility$3,620,315.00$212,227.15$1,150,285.19 Page 2 CouncilMonthEndRevenue -EnterpriseFunds Current Period: August2016 FUND2016August2016 SFUNDDescrSOURCEDescrYTDBudget2016AmtYTDAmt RevolvingLoanFundCharitableGamblingParkDedicationStateCollectedSalesTaxTIF2-3BayouBlues/AlleyFlatTIF2-2MeatMarketTIF2-1MillstreamTIF4-1FortitudeSeniorAptsTIF3-1CMCUEconomicDevelopmentCableAccessFeeEmployeeRetirement Reserve$2,874,000.00$123,615.00$00$34,545.00$4,545.00$795.00$0.904.10$439,087.50$27,134.41$1,200.00$215.00$0.00$440.87$1,943,906.25$164,331.75$73,117.17-$9,5,007.76$94$662.00$0.00$0.0009/14/164:06 PM St. JosephPage1Council Month EndExpenditure - Summary Current Period: August20162016August2016DDescriptionYTDBudget2016 StormWaterUtilityStreetLightUtility$214,375.00$69,590.00$11,229.93$4,546.60$34,006.79 09/14/164:06PMSt. Joseph12,191,985.00$995,528.36$5,863,692.44 Page 2 CouncilMonthEndExpenditure - Summary Current Period: August2016 2016August2016 DDescriptionYTDBudget2016AmtYTDAmt FUND101GeneralFUND 108CableAccessFeeFUND102EmployeeRetirementReserveGeneralCable AccessFeeEmployeeRetirementReservGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGen eralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralGeneralCouncilCable AccessGeneral AdminstrationFireProtectionOther FinancingUsesCommunityCenterParkAreasMaintenanceShopSkateParkandIceRinkStreetCleaningEngineering FeeIce & SnowRemovalStreet MaintanenceAnimal ControlEmergencyManagementBuilding Inspec. AdmistrationAutomotiveServicesCommunicationServicePoliceTrainingCrime Control & InvestigationCable AccessFacilitesandPlanningCity OfficesGeneral GovernmentPlanning andZoningCityAttorneyAuditServiceFinanceGeneral AdminstrationMayorOrdinance & ProceedingsLegislative Committees$2,569,980.00$127,685.00$10,985.545.00$1,965.00$0.00$0.00$218,399.53$11,908.31$2,634.50$11.98$0.00$0.00$1,625,381.78$614,950.00$74,645.71$2,671.94$0.00$0.00 09/14/164:05 PMSt. JosephFUND101GeneralFUND150EconomicDevelopmentFUND 108CableAccessFeeFUND 102Employee Retirement Reserve Page1CouncilMonth EndExpenditure - General Fund CurrentPeriod: August 20162016August2016 DDescriptionDEPARTDescrYTD Budget2016Amt FUND150EconomicDevelopmentFUND490CapitalOutlayFUND4042016ImpFieldStFUND159TIF2-3BayouBlues/AlleyFlatFUND153TIF4-1FortitudeSeniorAptsFUND152TIF3-1CMCUEconomic DevelopmentCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlayCapitalOutlay2016ImpFieldSt2016GovernmentCenter2016GovernmentCenterTIF2-3BayouBlues/AlleyFlTIF2-3BayouBlues/AlleyFlTIF4-1FortitudeSeniorAptsTIF3-1CMCUTIF3-1CMCUEconomic DevelopmentEconomicDevelopmentAuthorityOther FinancingUsesParkAreasMaintenance ShopStreetCleaningIce & SnowRemovalStreetMaintanenceEmergencyManagementAutomotiveServicesCommunicationServiceCrimeControl &InvestigationGeneralAdminstrationStreetMaintanenceOtherFinancingUsesCityOfficesOtherFinancingUsesEconomicDevelopmentAuthorityEconomicDevelopmentAuthorityOtherFinancingUsesEconomicDevelopmentAuthorityOtherFinancingUses$123,615.00$15,080.00$1,185.00$795.00$0.00$439,047.49$17,087.50$3,007.57$215.00$00$0.80$1,943,083.19$253,852.75$73,117.17$2,509.27$249.00$0.0009/14/164:05PMSt. JosephFUND152TIF3-1CMCUFUND4042016ImpFieldStFUND4012016GovernmentCenterFUND 159TIF 2-3BayouBlues/AlleyFlatFUND153TIF4-1FortitudeSenior Apts$2,791,560.00$746,154.54$3,991,743. 65 Page 2CouncilMonthEnd Expenditure - General Fund Current Period: August 2016 2016August2016DDescriptionDEPARTDescrYTDBudget2016 AmtYTD FUND601WaterFundFUND 652StreetLightUtilityFUND651StormWaterUtilityFUND603RefuseCollectionFUND 602SewerFundWaterFundStreetLightUtiliStormWaterUtiStormWaterUtiStormWaterUtiStormWaterUtiRefuseCollectioRefuse CollectioRefuse CollectioSewer FundSewer FundSewer FundSewer FundSewer FundSewer FundSewer FundSewer FundSewer FundSewer FundWaterFundWaterFundWaterFundWaterFundWaterFundWaterFundWaterFundWaterFundWaterFundWaterFundBondPayment (P & I)DepreciationExpenseAdministrationandGeneralWaterMaintenanceStorage-Tower1WellheadProtectionDistributionPuri fication-Plant2Purification-Plant1PowerandPumpingOtherFinancing 00$1,758,740.00$232,210.00$21,105.00$5,885.00$100,904.70$19,455.66$1,665.88$228.00$0.33$300,570.48$25,174.00$3,944.00$715.00$0.00 09/14/164:08 PMSt. JosephFUND601WaterFundFUND652StreetLightUtilityFUND651StormWaterUtilityFUND 603RefuseCollectionFUND602 SewerFund$3,903,590.00$188,353.41$1,081, 753.82 Page1CouncilMonth EndExpense - Enterprise Funds CurrentPeriod: August 20162016August2016DDescriptionDEPARTDescrYTD Budget2016Amt Justification Increase (Decrease) Contractors Impacted PR- SEH 1 Widen sidewalk and leave fire hydrant in place (852.00)$ C & L Excavating PR 1 Changed the exterior lighting (3,882.00)$ Kasella, C & L Excavating PR 2 Change the head steel header plat to match jamb plates 1,798.00$ HTH, J & H Erectors, Thurnbeck PR 3 Adjust steel structure to support partition wall 103.00$ Kasella, HTH, J & H Erectors, Thurnbeck PR 4 Revision for ambulance area, not planned when plans were drafted 8,218.13$ Kasella, HTH, Yamry, Mid Central Door, Central MN Ceilings, Floors by Beckers, Fransen, Breth-Zenzen, Weidener, SCR, Design Electric, C & L Excavating PR 5 Removal of two smoke dampers that are not needed (570.00)$ Yamry, Mid Central Door PR 6 changed the type of verneer to match (no cost)-$ HTH PR 7 Plans did not include header over Window W3, Room 119 352.00$ J& H Erectors, Thurnbeck, Reinert Drywall, PR 8 The structural stell as designed did not work for the operable wall contractor (partition door). - No cost 1,248.00$ J& H Erectors, Thurnbeck, Reinert Drywall, PR 9 Reviewed door strikes adding where needed.1,610.87$ Design Electric, Mid Central Door PR 10 roof parapet flashing accent 289.00$ Roof 1 PR 11 Original flag lighting was pole style and with the new location we are going ground mount. 1,651.90$ Design Electric PR 12 Omit the 2.5 furring behind architectural precast but maintain rigid insulation. (no cost) -$ HTH, Yamry PR 13 Dedication Plaque 457.00$ Benton Trophy, Yamry PR 14 Add bullet proof glass protection for reception areas 16,560.00$ Yamry, ICG, Mid Central Door, American Door, East Side Glass, Reinert Drywall PR 15 change to corner stone material to match (no cost)-$ HTH PR 16 Change in radius of dias to allow for bullet proof material 3,870.00$ Design Electric, ICG PR 17 Modifications to hoesbib fixture at the garage and sally port (no cost)-$ Weidner Mechanical PR 18 Remove the casework in the meeting room 107, converting to office (2,016.00)$ Yamry, ICG PR 19 Addition of 12 brick support angles 1,639.00$ THTH, Thurnbeck, Yamry PR 20 Provide black out shades in the police office windows 480.00$ Kustom Blinds PR 21 Change in roof density insulation. The original was a longer lead time and both products are similar. (1,616.00)$ Roof 1 PR 22 Add locker ventilation system 6,938.92$ Roof 1, Fransen, Weidner, SCR, Design Electric PR 23 Add Building Sign Address 375.81$ North Star Signs PR 24 Add Max Load and room occupancy signs 375.81$ North Star Signs PR 25 Eliminate guides for shades in Council Chambers (332.00)$ Kustom Blinds PR 27 Revise size and quantity of lockers. Room dimensions do not support the number of 24" lockers on the plan (4,523.14)$ Mid-America (Lockers), Design Electric PR 30 Revision to Lighting in CATV Room 455.08$ Design Electric Control # St. Joseph Government Center Summary of Contract Changes (Price Revisions) Justification Increase (Decrease) Contractors ImpactedControl # St. Joseph Government Center Summary of Contract Changes (Price Revisions) PR 31 Revision to storage room 118 1,157.00$ HTH, Yamry, Mid Central Door, Reinert Drywall PR 32 Sign on Building 7,125.78$ Design Electric, Scenic Sign PR 33 Monument Sign 56,224.89$ Design Electric, Scenic Sign PR 35 Addition of Projector, Screen Power, Data 806.51$ Design Electric PR 36 Concrete Slab for Generator 750.00$ Kasella Concrete, Design Electric 98,695.56$ Additional Design Fees 30,000.00$2016 Bond Proceeds 4,275,000.00$ Contracts Accepted Bids 3,370,302.85$2011 Bond Fund HVAC 84,042.45$ Construction Management 280,000.00$Sale of Builidng 500,000.00$ Contingency 425,543.58$MN OSHA Grant 7,000.00$ Architectural/Engineer 312,849.05$General Fund Approved 30,000.00$ Less:Fees paid in 2014 (215,584.05)$Total Avail Revenue 4,896,042.45$ Architectural Reimb 5,000.00$ Civil Engineering/Survey 32,199.04$ Overhead job costs 117,135.00$Spent to date (1,989,240.35)$ Soil Borings 2,700.00$Balance remaining 2,906,802.10$ Fiber Optics 7,500.00$ Exterior Signage Allowance 24,000.00$ Technology Allowance 150,000.00$ Phone System 65,000.00$ Furniture/Appliances 140,000.00$ Reroute Gas 3,904.00$ Finance Costs 55,100.35$ Building Permit 83,350.18$ 4,889,000.00$ Contract Summary as of 9-15-16