The URL can be used to link to this page

Home My WebLink About[04f] Treasurer's Report 11 Council Agenda Item 4f MEETING DATE: August 22, 2016 AGENDA ITEM: Treasurer's Report- July 2016 SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: Cash/investment reconciled through July 31, 2016. Budget to actual reports attached for Council review. The cash and investment balance increased $3,637,604 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 five 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 $59,966 (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 the next couple months for the senior housing projects. Staff will review the water and sewer rates closer in September. The General fund spent 55% of the expenditure budget and received 60% of the revenue budget at the end of July. Building permit revenue is over budget totaling $127,780 including ten new homes, Kwik Trip and the government center. More activity is expected this year with the two senior facility projects and CSB athletic fields. The Enterprise funds spent 30% (without depreciation) and received 26% of the revenue budget. The utility bills represent Jan-June usage that was billed in July, due August 20"'. Expenses represent seven 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 July 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. Cash Balances Only Current Period: July 2016 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance Last Dim 10100 GeneralG 101-10100$1,441,304.52$772,899.41$228,847.40$1,500,068.72 Employee Retirement ReserveG 102-10100$92,558.84$0.00$0.00$126,923.84 Fire FundG 105-10100$533,097.17$39,166.70$40,937.70$580,452.06 Cable Access FeeG 108-10100$19,692.08$657.89$217.19$23,707.79 Economic DevelopmentG 150-10100$73,708.56$17,239.53$4,821.42$125,094.67 TIF 3-1 CMCUG 152-10100$403.49$0.65$80.66$154.37 TIF 4-1 Fortitude Senior AptsG 153-10100$0.00$0.00$7,147.50-$1,116.75 TIF 2-1 MillstreamG 157-10100$17,162.21$6,521.94$19,458.28$19,406.43 TIF 2-2 Meat MarketG 158-10100$242.94$1,245.67$4,031.45$317.40 TIF 2-3 Bayou Blues/Alley FlatG 159-10100$737.30$0.65$349.42$75.03 State Collected Sales TaxG 200-10100$1,212,523.90$74,809.60$0.00$1,279,002.37 Park DedicationG 205-10100$59,507.60$760.49$94.00$120,403.27 Charitable GamblingG 215-10100$2,391.38$408.44$1,207.98$3,280.60 Revolving Loan FundG 250-10100$11,993.70$1,234.89$0.00$20,540.00 2016 CIP Bonds \[govt center\]G 301-10100$0.00$110,769.49$108,906.25$91,998.47 2016 Street Impr \[Field St\]G 304-10100$0.00$0.00$0.00$0.00 2009A CrossoverRefunding BoG 318-10100$264,400.44$36,276.39$0.00$378,169.83 2011A Refunding Fire HallG 331-10100$49,619.06$6,610.42$0.00$81,325.48 2010B Refundin \[Hill/Clover\]G 333-10100$200,060.87$10,580.70$0.00$229,961.05 2011A CO Refund\[Interior St\]G 338-10100$116,548.60$28,326.02$0.00$180,731.11 2009B GO CIP BondsG 343-10100$1,481.44$10,392.48$0.00$32,994.02 2010B Street Impr \[16th Ave\]G 345-10100$215,398.03$4,215.63$0.00$229,509.71 2011A Pumper Truck CertificatG 346-10100$2,751.90$5,941.67$0.00$29,862.49 2011A GO CIP Bonds\[roof/gar\]G 347-10100$102.09$4,375.26$0.00$15,849.10 2013 Street Improve BondsG 348-10100$148,036.77$4,351.99$0.00$157,618.23 2013 Equipment CertificatesG 349-10100$3,338.72$9,109.56$0.00$32,356.54 2014 Street Impr \[ParkTerraceG 350-10100$199,690.61$20,708.51$0.00$246,952.91 2015 Street\[Clinton/Northland\]G 351-10100$23,410.53$22,366.72$40,449.18$62,931.11 2015 Equipment CertificatesG 352-10100$2,219.85$19,181.71$46,227.64$19,557.79 2015 Abatement Bonds\[KenneG 353-10100$3,391.12$243.35$0.00$129,632.95 Debt Service ReliefG 390-10100$184,349.41$3,544.24$184.50$176,805.09 2016 Government CenterG 401-10100$0.00$4,219,899.65$612,953.52$2,799,905.87 2016 Imp Field StG 404-10100$0.00$0.00$159,853.19-$223,259.86 2011CIP Bonds\[Roof/PD garagG 447-10100$174,042.45$0.00$0.00$0.00 2014 Imp Park TerraceG 450-10100$322,466.94$0.00$734.20$185,275.49 2015 Street\[Clinton/Northland\]G 451-10100$166,457.50$0.00$1,996.30$235,123.40 2015 Equipment CertificatesG 452-10100$93,173.99$0.00$0.00$70,533.21 Capital OutlayG 490-10100$258,027.64$8,646.85$2,695.65$258,036.45 WAC FundG 501-10100$99.04$5,189.77$0.00$117,487.85 SAC FundG 502-10100$123.41$2,431.23$0.00$54,191.47 Water FundG 601-10100$2,353.94$115,854.77$52,240.00$215,420.64 Sewer FundG 602-10100$750.35$96,113.66$92,414.22-$114,157.87 Refuse CollectionG 603-10100$231,905.94$19,991.39$25,165.56$239,463.32 Storm Water UtilityG 651-10100$229,795.98$8,705.56$3,655.61$261,648.76 Street Light UtilityG 652-10100$19,742.20$5,687.26$4,459.99$22,432.78 Last Dim 10100$6,379,062.51$5,694,460.14$1,459,128.81$10,016,667.19 Last Dim 10200 GeneralG 101-10200$275.00$0.00$0.00$275.00 Last Dim 10200$275.00$0.00$0.00$275.00 St. Joseph Page 2 Cash Balances Only Current Period: July 2016 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance $6,379,337.51$5,694,460.14$1,459,128.81$10,016,942.19 Council Month End Revenue Summary Current Period: July 2016 2016July2016 FUNDFUND DescrYTD Budget2016 AmtYTD Amt 101General$2,559,980.00$760,864.54$1,526,769.42 102Employee Retirement Reserve$34,365.00$0.00$34,365.00 105Fire Fund$285,510.00$39,166.70$182,302.56 108Cable Access Fee$8,155.00$657.89$4,013.39 150Economic Development$123,615.00$17,238.88$106,960.49 152TIF 3-1 CMCU$0.00$0.00$0.00 153TIF 4-1 Fortitude Senior Apts$0.00$0.00$15,000.00 157TIF 2-1 Millstream$37,275.00$6,521.29$21,814.61 158TIF 2-2 Meat Market$4,005.00$1,245.02$4,164.65 159TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00 200State Collected Sales Tax$235,520.00$74,809.60$176,735.73 205Park Dedication$355,600.00$760.49$63,582.11 215Charitable Gambling$4,525.00$658.28$4,688.14 250Revolving Loan Fund$12,855.00$1,234.89$8,489.62 3012016 CIP Bonds \[govt center\]$0.00$110,769.49$200,904.72 3042016 Street Impr \[Field St\]$0.00$0.00$0.00 3182009A CrossoverRefunding Bonds$262,380.00$36,276.39$122,455.03 3312011A Refunding Fire Hall$49,750.00$6,610.42$32,908.53 3332010B Refundin \[Hill/Clover\]$101,400.00$10,580.70$36,363.06 3382011A CO Refund\[Interior St\]$123,670.00$28,326.02$70,124.65 3432009B GO CIP Bonds$65,100.00$10,392.48$34,564.80 3452010B Street Impr \[16th Ave\]$44,570.00$4,215.63$20,817.18 3462011A Pumper Truck Certificate$45,360.00$5,941.67$29,581.48 3472011A GO CIP Bonds\[roof/gar\]$27,740.00$4,375.26$16,567.85 3482013 Street Improve Bonds$21,335.00$4,351.99$13,375.04 3492013 Equipment Certificates$57,300.00$9,109.56$30,318.16 3502014 Street Impr \[ParkTerrace\]$129,645.00$20,708.51$72,429.04 3512015 Street\[Clinton/Northland\]$61,940.00-$18,082.46$45,332.81 3522015 Equipment Certificates$32,030.00-$27,045.93$18,534.20 3532015 Abatement Bonds\[Kennedy\]$164,500.00$243.35$164,451.31 390Debt Service Relief$0.00$3,544.24$11,999.09 4012016 Government Center$0.00$4,219,899.65$4,303,942.10 4042016 Imp Field St$0.00$0.00$0.00 4502014 Imp Park Terrace$0.00$0.00$0.00 4512015 Street\[Clinton/Northland\]$0.00$0.00$75,000.00 4522015 Equipment Certificates$0.00$0.00$0.00 490Capital Outlay$60,000.00$8,296.85$36,889.15 501WAC Fund$433,400.00$5,189.77$117,293.09 502SAC Fund$122,500.00$2,431.23$53,552.09 601Water Fund$1,574,425.00$87,547.72$398,202.04 602Sewer Fund$1,579,770.00$71,663.49$358,538.27 603Refuse Collection$284,800.00$17,293.65$120,464.44 651Storm Water Utility$120,285.00$8,668.77$35,784.23 Council Month End Revenue Summary Current Period: July 2016 2016July2016 FUNDFUND DescrYTD Budget2016 AmtYTD Amt 652Street Light Utility$61,035.00$5,669.37$25,069.06 $9,084,340.00$5,540,135.40$8,594,347.14 Council Month End Revenue -General Fund Current Period: July 2016 2016July2016 FUNDFUND DescrSOURCE DescrYTD Budget2016 AmtYTD Amt FUND 101 General 101GeneralCurrent Ad Valorem Taxes$1,062,065.00$234,855.14$582,422.79 101GeneralSpecial Levy- City St. Joe$0.00$0.00$0.00 101GeneralState Sales Tax$0.00$221.66$265.55 101GeneralGas Franchise$31,070.00$0.00$8,010.55 101GeneralElectric Franchise$54,570.00$1,875.56$19,374.70 101GeneralBeer$1,525.00$5.00$1,192.50 101GeneralLiquor$19,760.00$0.00$22,669.17 101GeneralOutdoor Liquor Permit$2,500.00$0.00$1,750.00 101GeneralGambling Permits$200.00$40.00$275.00 101GeneralAmusement/Hunt/Peddler/Golf$1,395.00$50.00$452.13 101GeneralExcavation Permit$500.00$50.00$550.00 101GeneralCigarette License$600.00$0.00$31.25 101GeneralCable Franchise Fee$33,385.00$1,384.74$12,367.78 101GeneralBuilding Permits$90,000.00$10,512.74$127,779.67 101GeneralAnimal License$3,390.00$110.00$3,155.00 101GeneralRental Housing Registration$23,000.00$9,800.00$15,145.00 101GeneralFederal Grants - Other$5,000.00$1,910.66$1,910.66 101GeneralState Grants and Aids$950.00$0.00$0.00 101GeneralLocal Government Aid$913,700.00$456,850.50$456,850.50 101GeneralPERA Rate Increase Aid$1,540.00$770.50$770.50 101GeneralPolice Training Reim$3,500.00$0.00$0.00 101GeneralState Municipal Funds Aid$48,175.00$24,798.00$49,596.00 101GeneralState Police Aid$55,000.00$0.00$0.00 101GeneralOther Grants/Aids$250.00$0.00$0.00 101GeneralOther Governmental Unit$10,000.00$5,000.00$10,000.00 101GeneralCounty Grants - Road Maint.$7,745.00$0.00$95,000.00 101GeneralZoning and Subdivision Fee$1,000.00$1,750.00$6,749.00 101GeneralLand Use Deposit Fee$4,000.00$250.00$7,750.00 101GeneralSale of Maps and Publications$50.00$0.75$12.50 101GeneralAssessments Search$2,750.00$210.00$2,040.00 101GeneralSpecial Hearing$5,000.00$400.00$4,400.00 101GeneralAdministration Reimb$14,085.00$0.00$131.44 101GeneralWeed Cutting$500.00$400.00$400.00 101GeneralPark Fees$5,500.00$170.00$4,975.00 101GeneralBall Field Donation$250.00$0.00$0.00 101GeneralSchneider Field Rental$1,500.00$0.00$770.00 101GeneralRents and Royalties$40,000.00$3,466.98$24,268.86 101GeneralKennel Fees$700.00$210.00$530.00 101GeneralCounty Fines$26,000.00$1,339.22$14,873.44 101GeneralPolicy Fines$14,000.00$460.00$5,284.00 101GeneralAccident Report Fee$1,200.00$129.00$590.75 101GeneralSeized Property$1,000.00$0.00$544.00 Council Month End Revenue -General Fund Current Period: July 2016 2016July2016 FUNDFUND DescrSOURCE DescrYTD Budget2016 AmtYTD Amt 101GeneralSpecial Assessments$3,000.00$184.31$821.40 101GeneralInterest Earnings$22,500.00$2,199.47$21,024.02 101GeneralInterest Charges$200.00$0.20$0.20 101GeneralCo-op Dividend - LMCIT$12,000.00$0.00$0.00 101GeneralWater Tower Antenna Lease$3,770.00$314.69$2,198.40 101GeneralAdvertising$1,500.00$0.00$1,030.00 101GeneralContributions - General$500.00$0.00$15,100.00 101GeneralContributions - Parks$1,200.00$57.42$960.31 101GeneralSurplus Property$0.00$0.00$0.00 101GeneralReimbursement$27,955.00$1,088.00$2,747.35 101GeneralTransfers from Other Funds$0.00$0.00$0.00 FUND 101 General$2,559,980.00$760,864.54$1,526,769.42 FUND 102 Employee Retirement Reserve 102Employee Retirement ResTransfers from Other Funds$34,365.00$0.00$34,365.00 FUND 102 Employee Retirement Reserve$34,365.00$0.00$34,365.00 FUND 108 Cable Access Fee 108Cable Access FeeCable Franchise Fee$8,155.00$657.89$4,013.39 108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00 FUND 108 Cable Access Fee$8,155.00$657.89$4,013.39 FUND 150 Economic Development 150Economic DevelopmentCurrent Ad Valorem Taxes$122,365.00$16,963.98$56,549.31 150Economic DevelopmentLodging Tax$0.00$0.00$0.00 150Economic DevelopmentFederal Grants - Other$0.00$0.00$36,622.00 150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$12,500.00 150Economic DevelopmentDEED Housing Reimbursement$0.00$0.00$0.00 150Economic DevelopmentInterest Earnings$1,250.00$274.90$1,289.18 150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00 FUND 150 Economic Development$123,615.00$17,238.88$106,960.49 FUND 152 TIF 3-1 CMCU 152TIF 3-1 CMCUTax Increment$0.00$0.00$0.00 152TIF 3-1 CMCUInterest Earnings$0.00$0.00$0.00 152TIF 3-1 CMCUTransfers from Other Funds$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$0.00$0.00$0.00 FUND 153 TIF 4-1 Fortitude Senior Apts 153TIF 4-1 Fortitude Senior ATax Increment$0.00$0.00$0.00 153TIF 4-1 Fortitude Senior ATIF/MIF Deposit$0.00$0.00$15,000.00 153TIF 4-1 Fortitude Senior AInterest Earnings$0.00$0.00$0.00 153TIF 4-1 Fortitude Senior ATransfers from Other Funds$0.00$0.00$0.00 FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$0.00$15,000.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat 159TIF 2-3 Bayou Blues/Alley Tax Increment$0.00$0.00$0.00 159TIF 2-3 Bayou Blues/Alley Interest Earnings$0.00$0.00$0.00 Council Month End Revenue -General Fund Current Period: July 2016 2016July2016 FUNDFUND DescrSOURCE DescrYTD Budget2016 AmtYTD Amt 159TIF 2-3 Bayou Blues/Alley Transfers from Other Funds$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00 $2,726,115.00$778,761.31$1,687,108.30 Council Month End Revenue -Enterprise Funds Current Period: July 2016 FUND2016July2016 FUNDDescrSOURCE DescrYTD Budget2016 AmtYTD Amt FUND 601 Water Fund 601Water FundPenalties and Forfeited Disc$8,000.00$522.87$4,080.27 601Water FundCurrent Ad Valorem Taxes$73,500.00$11,658.41$38,705.92 601Water FundTransfers from Other Funds$416,500.00$0.00$0.00 601Water FundContributed Revenue$0.00$0.00$0.00 601Water FundMDS Test Fee$11,880.00$746.80$4,321.83 601Water FundWater Meter$5,000.00$315.00$13,605.00 601Water FundConnection/Reconnection fees$200.00$0.00$112.00 601Water FundUndesignated Funds$0.00-$1,858.04-$610.21 601Water FundBulk Water$1,500.00$3,197.38$6,018.76 601Water FundInterest Earnings$34,140.00$4,141.42$22,711.48 601Water FundState Sales Tax$0.00$573.02$150.12 601Water FundWater Line Charge$294,535.00$20,460.91$109,154.33 601Water FundSpecial Assessments$200.00$61.72-$762.23 601Water FundRate Class One$694,985.00$44,896.06$180,764.46 601Water FundAmortization of Bond Premium$0.00$0.00$0.00 601Water FundWater Tower Antenna Lease$33,985.00$2,832.17$19,785.31 601Water FundSurplus Property$0.00$0.00$0.00 601Water FundReimbursement$0.00$0.00$165.00 FUND 601 Water Fund$1,574,425.00$87,547.72$398,202.04 FUND 602 Sewer Fund 602Sewer FundReimbursement$200.00$0.00$0.00 602Sewer FundContributed Revenue$0.00$0.00$0.00 602Sewer FundOther Governmental Unit$1,500.00$0.00$0.00 602Sewer FundSpecial Assessments$200.00$21.97-$16.00 602Sewer FundInterest Earnings$3,925.00-$289.84-$1,061.71 602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00 602Sewer FundContributions - General$8,000.00$0.00$0.00 602Sewer FundOther Grants/Aids$0.00$0.00$0.00 602Sewer FundSanitary Sewer Service$1,063,345.00$40,037.94$192,696.06 602Sewer FundPenalties and Forfeited Disc$11,750.00$383.53$2,752.20 602Sewer FundSewer Line Charge$347,650.00$31,509.89$164,167.72 602Sewer FundTransfers from Other Funds$143,200.00$0.00$0.00 602Sewer FundSurplus Property$0.00$0.00$0.00 FUND 602 Sewer Fund$1,579,770.00$71,663.49$358,538.27 FUND 603 Refuse Collection 603Refuse CollecRefuse Collection Charges$258,260.00$16,333.13$99,019.14 603Refuse CollecContributions - General$0.00$0.00$0.00 603Refuse CollecInterest Earnings$2,500.00$675.15$3,795.23 603Refuse CollecPenalties and Forfeifted Disc$5,700.00$429.32$3,378.72 603Refuse CollecContributed Revenue$0.00$0.00$0.00 603Refuse CollecLicenses & Permits$18,140.00$775.00$17,525.00 603Refuse CollecState Sales Tax$0.00-$966.51-$3,233.60 603Refuse CollecSpecial Assessments$200.00$47.56-$20.05 FUND 603 Refuse Collection$284,800.00$17,293.65$120,464.44 FUND 651 Storm Water Utility 651Storm Water Development Fee$10,000.00$0.00$0.00 651Storm Water Transfers from Other Funds$0.00$0.00$0.00 651Storm Water Penalties and Forfeifted Disc$2,060.00$120.46$801.96 651Storm Water Rate Class One$101,180.00$7,277.00$37,722.07 651Storm Water Contributed Revenue$0.00$0.00$0.00 St. Joseph Page 2 Council Month End Revenue -Enterprise Funds Current Period: July 2016 FUND2016July2016 FUNDDescrSOURCE DescrYTD Budget2016 AmtYTD Amt 651Storm Water Reimbursement$0.00$0.00$0.00 651Storm Water Special Assessments$4,795.00$574.18-$6,541.63 651Storm Water Interest Earnings$2,250.00$697.13$3,801.83 FUND 651 Storm Water Utility$120,285.00$8,668.77$35,784.23 FUND 652 Street Light Utility 652Street Light UTransfers from Other Funds$0.00$0.00$0.00 652Street Light USpecial Assessments$50.00$4.36-$2.05 652Street Light UInterest Earnings$250.00$59.09$336.92 652Street Light URate Class One$60,535.00$5,553.06$24,339.30 652Street Light UPenalties and Forfeited Disc$200.00$52.86$394.89 FUND 652 Street Light Utility$61,035.00$5,669.37$25,069.06 $3,620,315.00$190,843.00$938,058.04 Council Month End Expenditure - Summary Current Period: July 2016 2016July2016 DescriptionYTD Budget2016 Amt YTD Amt General$2,569,980.00$217,065.75$1,407,322.67 Employee Retirement Reserve$34,365.00$0.00$0.00 Fire Fund$312,525.00$40,937.70$86,523.48 Cable Access Fee$2,010.00$217.19$671.94 Economic Development$123,615.00$4,820.77$56,029.67 TIF 3-1 CMCU$795.00$80.01$249.12 TIF 4-1 Fortitude Senior Apts$0.00$7,147.50$16,116.75 TIF 2-1 Millstream$34,545.00$19,457.63$19,738.86 TIF 2-2 Meat Market$4,545.00$4,030.80$4,090.81 TIF 2-3 Bayou Blues/Alley Flat$795.00$348.77$662.27 State Collected Sales Tax$2,874,000.00$0.00$164,509.20 Park Dedication$393,700.00$94.00$2,905.51 Charitable Gambling$0.00$1,457.82$3,807.76 Revolving Loan Fund$0.00$0.00$0.00 2016 CIP Bonds \[govt center\]$0.00$108,906.25$108,906.25 2016 Street Impr \[Field St\]$0.00$0.00$0.00 2009A CrossoverRefunding Bon$360,625.00$0.00$10,175.00 2011A Refunding Fire Hall$74,750.00$0.00$1,500.00 2010B Refundin \[Hill/Clover\]$144,750.00$0.00$7,223.75 2011A CO Refund\[Interior St\]$142,130.00$0.00$8,365.00 2009B GO CIP Bonds$61,450.00$0.00$3,420.00 2010B Street Impr \[16th Ave\]$64,855.00$0.00$7,327.50 2011A Pumper Truck Certificate$45,360.00$0.00$2,580.00 2011A GO CIP Bonds\[roof/gar\]$22,720.00$0.00$1,260.00 2013 Street Improve Bonds$39,270.00$0.00$4,535.00 2013 Equipment Certificates$53,500.00$0.00$1,650.00 2014 Street Impr \[ParkTerrace\]$164,035.00$0.00$26,917.50 2015 Street\[Clinton/Northland\]$67,470.00$0.00$6,120.00 2015 Equipment Certificates$32,670.00$0.00$1,235.00 2015 Abatement Bonds\[Kenned$141,435.00$0.00$38,529.15 Debt Service Relief$0.00$184.50$20,184.50 2016 Government Center$0.00$612,953.52$1,504,036.23 2016 Imp Field St$0.00$159,853.19$223,259.86 2011CIP Bonds\[Roof/PD garag$0.00$0.00$174,042.45 2014 Imp Park Terrace$0.00$734.20$10,745.07 2015 Street\[Clinton/Northland\]$0.00$1,996.30-$9,758.01 2015 Equipment Certificates$0.00$0.00$22,640.78 Capital Outlay$60,000.00$2,345.65$37,240.60 WAC Fund$416,500.00$0.00$0.00 SAC Fund$46,000.00$0.00$0.00 Water Fund$1,574,425.00$23,932.95$251,051.29 Sewer Fund$1,758,740.00$67,964.05$437,547.24 Refuse Collection$286,460.00$22,467.82$148,443.51 St. Joseph Page 2 Council Month End Expenditure - Summary Current Period: July 2016 2016July2016 DescriptionYTD Budget2016 Amt YTD Amt Storm Water Utility$214,375.00$3,618.82$26,898.18 Street Light Utility$69,590.00$4,442.10$29,460.19 $12,191,985.00$1,305,057.29$4,868,164.08 Council Month End Expenditure - General Fund Current Period: July 2016 2016July2016 DescriptionDEPART DescrYTD Budget2016 Amt YTD Amt FUND 101 General GeneralCouncil$60,725.00$7,702.37$32,048.98 GeneralLegislative Committees$5,565.00$0.00$1,914.70 GeneralOrdinance & Proceedings$1,600.00$1,261.65$2,522.58 GeneralMayor$10,985.00$818.60$4,864.37 GeneralElections$750.00$62.84$1,603.34 GeneralGeneral Adminstration$236,595.00$19,469.84$123,551.11 GeneralFinance$127,685.00$8,860.75$62,720.76 GeneralAudit Service$27,450.00$0.00$26,950.00 GeneralAssessing$23,500.00$0.00$0.00 GeneralCity Attorney$16,000.00$1,093.50$5,643.00 GeneralPlanning and Zoning$54,385.00$4,544.45$18,873.87 GeneralGeneral Government$20,675.00$783.08$11,226.39 GeneralCity Offices$33,575.00-$1,500.17$15,379.61 GeneralFacilites and Planning$0.00$3,300.00$0.00 GeneralCable Access$11,065.00$1,030.60$5,708.60 GeneralCrime Control & Investigation$952,830.00$80,331.69$515,747.52 GeneralPolice Training$9,545.00$72.52$4,922.88 GeneralCommunication Service$10,870.00$766.28$5,809.68 GeneralAutomotive Services$52,200.00$1,688.78$18,583.22 GeneralBuilding Inspec. Admistration$92,000.00$8,774.57$49,680.53 GeneralEmergency Management$960.00$8.06$1,469.90 GeneralAnimal Control$965.00$0.00$274.50 GeneralStreet Maintanence$274,350.00$18,543.22$106,380.30 GeneralIce & Snow Removal$112,710.00$0.00$39,094.08 GeneralEngineering Fee$30,000.00$5,539.47$19,389.75 GeneralStreet Cleaning$13,665.00$649.04$5,402.48 GeneralSkate Park and Ice Rink$5,240.00$45.16$2,759.31 GeneralBall Park$1,750.00$11.69$616.34 GeneralMaintenance Shop$27,365.00$1,309.00$13,644.60 GeneralPark Areas$218,995.00$21,090.99$159,077.05 GeneralCommunity Center$30,920.00$5,177.72$43,073.07 GeneralOther Financing Uses$0.00$0.00$31,500.00 GeneralFire Protection$105,060.00$25,630.05$76,890.15 FUND 101 General$2,569,980.00$217,065.75$1,407,322.67 FUND 102 Employee Retirement Reserve Employee Retirement ReservGeneral Adminstration$34,365.00$0.00$0.00 FUND 102 Employee Retirement Reserve$34,365.00$0.00$0.00 FUND 108 Cable Access Fee Cable Access FeeCable Access$2,010.00$217.19$671.94 FUND 108 Cable Access Fee$2,010.00$217.19$671.94 FUND 150 Economic Development Council Month End Expenditure - General Fund Current Period: July 2016 2016July2016 DescriptionDEPART DescrYTD Budget2016 Amt YTD Amt Economic DevelopmentEconomic Development Authority$123,615.00$4,820.77$56,029.67 Economic DevelopmentOther Financing Uses$0.00$0.00$0.00 FUND 150 Economic Development$123,615.00$4,820.77$56,029.67 FUND 152 TIF 3-1 CMCU TIF 3-1 CMCUEconomic Development Authority$795.00$80.01$249.12 TIF 3-1 CMCUOther Financing Uses$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$795.00$80.01$249.12 FUND 153 TIF 4-1 Fortitude Senior Apts TIF 4-1 Fortitude Senior AptsEconomic Development Authority$0.00$7,147.50$16,116.75 FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$7,147.50$16,116.75 FUND 159 TIF 2-3 Bayou Blues/Alley Flat TIF 2-3 Bayou Blues/Alley FlEconomic Development Authority$795.00$348.77$662.27 TIF 2-3 Bayou Blues/Alley FlOther Financing Uses$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$795.00$348.77$662.27 FUND 401 2016 Government Center 2016 Government CenterCity Offices$0.00$577,504.60$1,468,587.31 2016 Government CenterOther Financing Uses$0.00$35,448.92$35,448.92 FUND 401 2016 Government Center$0.00$612,953.52$1,504,036.23 FUND 404 2016 Imp Field St 2016 Imp Field StStreet Maintanence$0.00$159,853.19$223,259.86 FUND 404 2016 Imp Field St$0.00$159,853.19$223,259.86 FUND 490 Capital Outlay Capital OutlayGeneral Adminstration$8,145.00$2,345.65$15,571.27 Capital OutlayCrime Control & Investigation$1,185.00$0.00$720.00 Capital OutlayCommunication Service$5,170.00$0.00$2,509.40 Capital OutlayAutomotive Services$14,045.00$0.00$18,439.93 Capital OutlayEmergency Management$1,500.00$0.00$0.00 Capital OutlayStreet Maintanence$1,625.00$0.00$0.00 Capital OutlayIce & Snow Removal$5,375.00$0.00$0.00 Capital OutlayStreet Cleaning$3,750.00$0.00$0.00 Capital OutlayMaintenance Shop$4,125.00$0.00$0.00 Capital OutlayPark Areas$15,080.00$0.00$0.00 Capital OutlayOther Financing Uses$0.00$0.00$0.00 FUND 490 Capital Outlay$60,000.00$2,345.65$37,240.60 $2,791,560.00$1,004,832.35$3,245,589.11 Council Month End Expense - Enterprise Funds Current Period: July 2016 2016July2016 DescriptionDEPART DescrYTD Budget2016 Amt YTD Amt FUND 601 Water Fund Water FundBond Payment (P & I)$692,345.00$0.00$59,247.25 Water FundOther Financing Uses$38,215.00$0.00$715.00 Water FundPower and Pumping$21,105.00$537.35$13,351.16 Water FundPurification-Plant 1$43,935.00$1,437.58$11,333.19 Water FundPurification-Plant 2$80,275.00$6,143.58$38,779.24 Water FundDistribution$10,000.00$0.00$6,702.21 Water FundWellhead Protection$3,000.00$0.00$0.00 Water FundStorage-Tower 1$16,145.00$276.51$1,924.45 Water FundWater Maintenance$232,210.00$12,761.85$99,927.35 Water FundAdministration and General$37,195.00$2,776.08$19,071.44 Water FundDepreciation Expense$400,000.00$0.00$0.00 FUND 601 Water Fund$1,574,425.00$23,932.95$251,051.29 FUND 602 Sewer Fund Sewer FundBond Payment (P & I)$222,970.00$0.00$23,511.75 Sewer FundOther Financing Uses$45,935.00$0.00$1,435.00 Sewer FundSanitary Sewer Maintenanc$198,560.00$8,834.59$78,690.61 Sewer FundLift Station-Baker Street$5,885.00$225.93$1,635.46 Sewer FundLift Station-Ridgewood/DBL$2,980.00$139.89$1,426.17 Sewer FundLift Station-Northland$4,365.00$118.61$910.17 Sewer FundLift Station-CR 121$4,610.00$142.94$1,333.66 Sewer FundLift Station-Main$862,390.00$55,680.80$308,932.13 Sewer FundAdministration and General$36,045.00$2,821.29$19,672.29 Sewer FundDepreciation Expense$375,000.00$0.00$0.00 FUND 602 Sewer Fund$1,758,740.00$67,964.05$437,547.24 FUND 603 Refuse Collection Refuse CollectioWaste Collection$278,525.00$22,467.82$147,728.51 Refuse CollectioOther Financing Uses$1,435.00$0.00$715.00 Refuse CollectioDepreciation Expense$6,500.00$0.00$0.00 FUND 603 Refuse Collection$286,460.00$22,467.82$148,443.51 FUND 651 Storm Water Utility Storm Water UtiOther Financing Uses$18,965.00$0.00$0.00 Storm Water UtiAdministration and General$16,375.00$1,191.84$10,646.60 Storm Water UtiStorm Water Maintenance$79,035.00$2,426.98$16,251.58 Storm Water UtiDepreciation Expense$100,000.00$0.00$0.00 FUND 651 Storm Water Utility$214,375.00$3,618.82$26,898.18 FUND 652 Street Light Utility Street Light UtiliStreet Lighting$69,590.00$4,442.10$29,460.19 FUND 652 Street Light Utility$69,590.00$4,442.10$29,460.19 $3,903,590.00$122,425.74$893,400.41 St. Joseph Government Center Summary of Contract Changes (Price Revisions) JustificationIncrease (Decrease)Contractors Impacted Control # PR-Widen sidewalk and leave fire hydrant in $ C & L Excavating(852.00) 1 SEHplace PR1$(3,882.00) Changed the exterior lighting Kasella, C & L Excavating Change the head steel header plat to PR2$ HTH, J & H Erectors, Thurnbeck1,798.00 match jamb plates Adjust steel structure to support partition PR3$ Kasella, HTH, J & H Erectors, Thurnbeck103.00 wall Kasella, HTH, Yamry, Mid Central Door, Revision for ambulance area, not Central MN Ceilings, Floors by Beckers, PR4$8,218.13 planned when plans were drafted Fransen, Breth-Zenzen, Weidener, SCR, gn Electric, C & L Excavating Desi Removal of two smoke dampers that are PR5$ Yamry, Mid Central Door(570.00) not needed changed the type of verneer to match (no PR6$ HTH - cost) Plans did not include header over PR7$ J& H Erectors, Thurnbeck, Reinert Drywall,352.00 Window W3, Room 119 The structural stell as designed did not PR8work for the operable wall contractor $1,248.00 J& H Erectors, Thurnbeck, Reinert Drywall, (partition door). - No cost Reviewed door strikes adding where PR9$ Design Electric, Mid Central Door1,610.87 needed. PR10$289.00 roof parapet flashing accent Roof 1 Original flag lighting was pole style and PR11with the new location we are going $ Design Electric1,651.90 ground mount. Omit the 2.5 furring behind architectural PR12precast but maintain rigid insulation. (no $ HTH, Yamry- cost) PR13Dedication Plaque$457.00Benton Trophy, Yamry Add bullet proof glass protection for Yamry, ICG, Mid Central Door, American PR14$16,560.00 reception areasDoor, East Side Glass, Reinert Drywall change to corner stone material to match PR15$ HTH- (no cost) Change in radius of dias to allow for PR16$ Design Electric, ICG3,870.00 bullet proof material Modifications to hoesbib fixture at the PR17$ Weidner Mechanical- garage and sally port (no cost) Remove the casework in the meeting PR18$ Yamry, ICG (2,016.00) room 107, converting to office PR19Addition of 12 brick support angles$1,639.00THTH, Thurnbeck, Yamry Provide black out shades in the police PR20$ Kustom Blinds480.00 office windows Change in roof density insulation. The PR21original was a longer lead time and both $ Roof 1 (1,616.00) products are similar. Roof 1, Fransen, Weidner, SCR, Design PR22Add locker ventilation system6,938.92$ Electric PR23$ North Star Signs375.81 Add Building Sign Address Add Max Load and room occupancy PR24$ North Star Signs375.81 signs Eliminate guides for shades in Council PR25$ Kustom Blinds(332.00) Chambers Revise size and quantity of lockers. PR27Room dimensions do not support the $ Mid-America (Lockers), Design Electric(4,523.14) number of 24" lockers on the plan PR30Revision to Lighting in CATV Room$455.08Design Electric St. Joseph Government Center Summary of Contract Changes (Price Revisions) JustificationIncrease (Decrease)Contractors Impacted Control # HTH, Yamry, Mid Central Door, Reinert PR31Revision to storage room 1181,157.00$ Drywall $33,788.38 Contract Summary as of 8-11-16 AdditionalDesignFees30,000.00$2016BondProceeds4,275,000.00$ ContractsAcceptedBids3,370,302.85$2011BondFundHVAC84,042.45$ ConstructionManagement280,000.00$SaleofBuilidng500,000.00$ Contingency425,543.58$GeneralFundApproved$30,000.00 Architectural/Engineer312,849.05$TotalAvailRevenue υЍͲББВͲЉЍЋ͵ЍЎ \[ĻƭƭʹCĻĻƭƦğźķźƓЋЉЊЍ$(215,584.05) ArchitecturalReimb5,000.00$ CivilEngineering/Survey32,199.04$Spenttodate(1,559,138.36)$ Overheadjobcosts117,135.00$Balanceremaining υЌͲЌЋВͲВЉЍ͵ЉВ SoilBorings2,700.00$ FiberOptics7,500.00$ ExteriorSignageAllowance24,000.00$ TechnologyAllowance150,000.00$ PhoneSystem65,000.00$ Furniture/Appliances140,000.00$ RerouteGas3,904.00$ FinanceCosts55,100.35$ BuildingPermit83,350.18$ $4,889,000.00