General Fund Revenues - Malvern

Transcription

Malvern Borough, Chester County2018 BudgetGeneral FundRevenuesAccount 001.342.000TotalAccount TitleREAL ESTATE TAXESReal Estate Taxes (Current Year)Real Estate Taxes (Prior Years)Real Estate Taxes (Delinquent)Interim Real Estate TaxesLOCAL ENABLING TAX (ACT 511)Per Capita Tax (Current)Per Capita Tax (Prior Years)Real Estate Transfer TaxEarned Income Tax (Current)Earned Income Tax (Prior Years)Local Services Tax (Current)Local Services Tax (Prior)LICENSES AND PERMITSBuilding Permits & RegistrationPlumbing Permits & RegistrationStreet PermitsZoning & Subdivision PermitsFranchise Fees (Comcast & Verizon)Housing & Property MaintenanceInspection FeesParking PermitsFINES, FORFEITS & COSTSViolations of OrdinancesMotor Vehicle Code Violations/CriminalFalse Alarm PenaltiesEarnings on InvestmentsRents of Property2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/172018 Proposed 1,004,1578,57829,2741,042,010 1,007,00010,0004,0001,021,000 1,015,3986,7377,2651,029,401 1,018,3987,7528,1881,034,338 1,074,8167,0006,0001,087,816 ,657 ,300 5,868 5,611 5,300 7 0 8 4 0 1,18822,0121,9258,24339,79273,159 1,50023,0001,2004,00042,00071,700 3,68326,4421,05011,74841,95684,880 4,13727,4421,20011,74842,00086,527 2,00026,0001,2005,50046,00080,700Page 1General Fund

Malvern Borough, Chester County2018 BudgetAccount 55.041TotalAccount TitleGRANTS & GIFTSState Contributions - Pensions (State Aid)Grants from State, Federal & County Govt.Grant from County for Special ProjectsForeign Fire InsuranceBeverage Liquor License2016 Actual 30,47124,77027,8721,60084,7132017 Budget 30,471580,000510,50027,8728001,149,6432017 Year-to Date 2017 Projected FinalThru 11/30/17 33,39424,44925,27120083,314 33,39424,44925,27180083,9142018 Proposed talPUBLIC SAFETYPolice Special Duty Detail 17,128 17,128 14,000 14,000 18,275 18,275 18,651 18,651 16,50016,50001.364.030TotalSANITATION SERVICESSanitation Services Recycle Rebate 612 612 1,617 1,617 1,748 1,748 1,748 1,748 1,6171,61701.367.21TotalCULTURE - RECREATIONDiscount Tickets - Sale Commission - 250 250 19 2.00001.392.001TotalMISCELLANEOUSMiscellaneous IncomeZoning HearingPD Automatic Protection DevicePD Copies of Accident/Misc. ReportsMisc. Tax Certifications & DuplicatesLibrary RenovationsSale of Borough PropertySale of Dump TruckRefunds TRANSFER FROM OTHER FUNDSContingency Fund Highway Aid Fund 250 250 25,0001,5002,5004804,80012,18050,00060097,060 48,826 48,826 342,000 49,000 391,000 TOTAL GENERAL FUND REVENUES 3,669,810 5,037,320 Page 2- 17,6384,7503,3204604,15512,1801,16943,671 -25,0004,7503,3204804,50012,1801,16951,399 25,0002,2502,5005004,50012,18050,00060097,530 342,000 49,000 391,000 49,00049,0003,581,955 4,016,572 4,790,678General Fund

Malvern Borough, Chester County2018 BudgetGeneral FundExpendituresAccount 00.02101.400.033TotalAccount TitleADMINISTRATIONElected Officials CompensationSalary - Secretary/ManagerSalary - Treasurer/Admin. Asst.Salary - Assistant ManagerSalary/Wages - ClerksTelephone & Communications2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/172018 Proposed 6,00058,39638,20342,5328,8818,125162,137 9,60059,85039,44539,0008,8517,500164,246 3,95055,24636,41136,0007,4686,840145,915 5,15059,85039,44539,0008,8517,479159,775 9,60063,00040,72740,26820,3707,500181,465 4,8883,8903,3494,38921,80924,3547,09811,51081,287 7,0006,0003,5007,60023,00030,0008,00012,00097,100 8,2004,2113,4953,60411,97018,0456,32211,78167,629 8,2004,8153,4953,60413,05822,1658,00011,78175,118 1.403.01201.403.01301.403.014TotalTAX COLLECTIONEarned Income & Per Capita Commission EIT Tax Collection Study Group Expenses General Expense 17,70259618,298 16,500 5001,500 18,500 21,276 65 21,341 21,27670021,976 18,0005001,50020,00001.404.00001.404.002TotalLEGAL SERVICESLegal Services Legal Services - Planning Commission 93,223 93,223 100,000 4,000 104,000 84,255 84,255 91,914 91,914 EE BENEFITSWorkers Compensation Income Protection Insurance Group Life Insurance 11,646 4,939 1,676 13,000 4,280 1,491 12,235 2,282 1,229 12,235 2,493 1,355 lFINANCIAL ADMINISTRATIONReal Estate Tax RefundsMaterials & SuppliesConferences, Seminars, MeetingsDues & MembershipsOffice Equipment Maintenance & Exp.General ExpenseAdvertising & PrintingAuditing ServicesPage 3General Fund

Malvern Borough, Chester County2018 BudgetAccount 10.02701.410.029Account TitleHealthcare InsuranceDental Care InsuranceSocial Security Tax - BoroughNon-Uniformed Pension Fund (EE Contrib)2016 Actual 38,2072,38817,27676,131IT NETWORKING SERVICESOffice SuppliesComputer SuppliesRepairs and MaintenanceSmall Tools and Minor EquipmentENGINEERING SERVICESEngineering Services MUNICIPAL BUILDINGSMaterials & SuppliesUtilitiesGeneral ExpenseMaintenance & RepairsAlarm System ExpensePOLICE DEPARTMENTSalary - Chief of PoliceSalary & Wages - PatrolmenSalary & Wages - ClericalSalary & Wages - Part-Time PatrolmenSalary & Wages - OvertimeMaintenance - Office EquipmentMaterials & SuppliesUniformsAmmunitionTraining - EducationAdvertising & PrintingTelephone & Communications (police radios)Vehicle Maintenance & RepairsMaintenance - Traffic SignalsGas & Oil2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/172018 Proposed 34,6382,47524,2247,58687,694 27,6462,47416,04861,914 34,6382,47417,43670,630 55,7993,48326,4598,303113,340 11,0004,00010,5009,50035,000 5,5721,7069,4424,80821,528 7,186 4,000 10,301 5,245 26,732 7,5008,00010,0005,00030,50043,110 43,110 56,526 56,526 65,00065,00051,884 51,884 65,000 65,000 1,97440,1793,23454,27199,658 4,00045,0002,50052,0001,500105,000 2,43733,6851,46548,08285,670 4,00041,5992,16153,422101,182 4,00045,0002,50055,0001,500108,000 ,4003,36612,964 5006,5001,00013,40012,00011,60020,000 223,1627,2663,3308,490 111,665 359,497 70,334 66,959 33,550 13,000 2,477 8,093 4,500 5,000 500 7,926 3,330 15,000 5006,5001,00010,00010,0005,80020,000Page 4General Fund

Malvern Borough, Chester County2018 BudgetAccount lAccount TitleTiresEnergy - Traffic LightsGeneral ExpenseCapital ExpendituresWorkers CompensationIncome Protection InsuranceGroup Life InsuranceHealthcare InsuranceDental Care InsuranceSocial Security Tax - BoroughPolice Professional Liability InsuranceUniformed Pension FundFIRE PROTECTIONContribution - Fire CompanyCost of Fire HydrantsWater ConsumptionState Workers Insurance Fund (SWIF)Foreign Fire InsuranceCODE ENFORCEMENTSalaries & WagesGeneral ExpenseContribution to Planning CommissionContribution to Zoning Hearing BoardContribution to Historical CommissionRefunds - Zoning Hearing2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/172018 Proposed 2812,053864,964 50,53715,0001,051,857 97911,768835,102 8,15111,768934,043 62,74715,0001,198,850 65,00017,5802,80220,69527,872133,949 73,30017,5004,00026,50027,872149,172 73,30016,2283,07223,38125,271141,252 73,30017,5473,48325,21925,271144,821 81,60017,8004,00027,50025,271156,171 75,5543,0191,2145,0762,86670588,434 78,3474,0002,0004,5003,0001,50093,347 71,7071,1902767,4261,99447183,064 78,3472,5005007,4263,0001,00092,773 86,5104,0001,0005,0003,0001,500101,010- - 1,0001,000839 839 1,000 1,000 01.427.02001.427.021TotalEMERGENCY MANAGEMENTEmergency Management Coordinator GARBAGE COLLECTION & DISPOSALContracted Services Landfill Fees & Expenses 153,908 68,198 222,106 175,000 74,000 249,000 134,674 67,839 202,513 164,381 80,601 244,982 181,00080,000261,00001.430.010PUBLIC WORKS - HIGHWAYS & STREETSSalaries & Wages 198,427 183,094 169,005 183,094 189,04401.415.000TotalPage 5General Fund

Malvern Borough, Chester County2018 BudgetAccount 30.22401.430.320TotalAccount Title2016 ActualSalaries & Wages - OvertimeMaterials & SuppliesUtilitiesGeneral ExpenseEquipment RentalTelephone & CommunicationsVehicle Maintenance & RepairsGas, Oil & TiresMinor Equipment PurchasesWorkers CompensationIncome Protection InsuranceGroup Life InsuranceHealthcare InsuranceDental Care InsuranceSocial Security Tax - BoroughNon-Uniformed Pension Fund (EE Contrib) 31,95663,3942,87117,231352,6802017 Budget 13,0004,1941,67172,1453,37521,2427,613428,3322017 Year-to Date 2017 Projected FinalThru 11/30/17 ,2451,24259,2133,37416,362318,402 ,2352,4491,35572,1453,37418,240374,6642018 Proposed 2.020TotalWINTER MAINTENANCE - SNOW REMOVALSnow & Ice Removal 9,189 9,189 30,000 30,000 5,636 5,636 30,000 30,000 30,00030,00001.433.020TotalTRAFFIC CONTROL DEVICESStreet Signs & Markings 8,525 8,525 13,000 13,000 5,953 5,953 8,221 8,221 10,00010,00001.434.020TotalSTREET LIGHTINGStreet Lighting 50,238 50,238 49,000 49,000 42,028 42,028 46,555 46,555 49,00049,00001.436.02001.436.053TotalSTORM SEWERS & DRAINSMaintenance & Repairs - Sewers & Drains Stormwater Fees 114 114 5,000 2,500 7,500 727 2,500 3,227 1,500 2,500 4,000 5,0005005,50001.437.020TotalREPAIRS TO TOOLS & MACHINERYRepairs to tools & machinery 1,044 1,044 1,600 1,600 1,214 1,214 1,600 1,600 1,6001,60001.438.020MAINTENANCE & REPAIRS TO ROADSMaintenance & Repairs - Streets 249,959 185,000 137,446 185,000 150,000Page 6General Fund

Malvern Borough, Chester County2018 BudgetAccount NumberAccount Title2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/172018 ProposedTotal 249,959 185,000 137,446 185,000 150,00001.439.070TotalHIGHWAY CONSTRUCTION & REBUILDINGCapital Expenditures 53,583 53,583 80,000 80,000 79,028 79,028 79,028 79,028 863,77565,73815,00011,00039,9082,5866,00074,494 02101.454.01001.454.02001.454.021TotalPARKS & RECREATIONRecreational ProgramsMaintenance & RepairsSalaries & WagesMaterials & SuppliesGeneral Expense 01.455.020TotalSHADE TREESShade Tree Maintenance 15,875 15,875 16,000 16,000 9,250 9,250 11,000 11,000 15,00015,00001.456.020TotalLIBRARYContribution to Library 12,180 12,180 12,180 12,180 12,180 12,180 12,180 12,180 CELLANEOUSNon-Uniformed Pension FundCasualty - General LiabilityAutomobile Liability InsurancePublic Officials Liability InsuranceInland Marine InsuranceCatastrophe Liability Insurance (Umbrella)Commercial Property InsuranceMilitary & Civic Contributions 30,47113,5575,3907,8988,5031,62558,000125,443 TOTAL GENERAL FUND EXPENDITURES 2,838,794 BEFORE INTERFUND OPERATING TRANSFERSINTERFUND OPERATING TRANSFERS01.492.011 Forecasted Transfers of Historic GF Balance Surplus 01.492.011Transfer to Capital Reserve Fund from Grants 01.492.011Transfer to Capital Reserve Fund for Debt Service 284,052 Page 4 3,235,844 1,070,500 273,724 33,39413,0675,8318,5857,0062,25911,50081,642 2,555,036 - 33,39413,0675,8318,5857,0062,25930,000100,142 2,947,356 3,390,368 273,724 1,070,500274,060General Fund

Malvern Borough, Chester County2018 BudgetAccount NumberAccount Title01.492.011 Transfer to Capital Reserve Fund from General FundTransfer to Capital Reserve Fund from General Fund01.492.012Contingency Acct.01.489.000Transfer to Contingency AccountTotal2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/17 - 115,251 519,312 - 342,000 - 284,052 TOTAL GENERAL FUND EXPENDITURES 3,122,846 Page 81,000,456 2018 Proposed55,750 342,000 - 1,801,476 519,312 1,616,180 1,400,3095,037,320 3,074,348 4,563,536 4,790,678General Fund

Malvern Borough, Chester County2018 BudgetSewer FundRevenueAccount 64.013TotalAccount TitleEarnings from InvestmentsSewer RentsTapping & Sewer Connection FeesOther IncomeGrants from the County, State, Federal2016 Actual TOTAL SEWER FUND REVENUES 7,087859,4712,85836,276905,6932017 Budget 6,000810,00017,1512,000835,151905,693 2017 Year-to Date 2017 Projected FinalThru 11/30/17 835,151 8,314832,38514,29230,952885,943 885,943 8,314832,38517,15130,952888,8022018 Proposed 6,000825,00028,5852,000861,585888,802 861,585Sewer FundExpendituresAccount 108.484.010Account TitleOPERATIONS & MAINTENANCESalaries & WagesMaterials & SuppliesUtilitiesMaintenance & RepairsVehicle Maintenance & RepairsGas & OilSewage Disposal - VariousCapital ExpendituresADMINISTRATIONSalaries & WagesMaterials & SuppliesGeneral ExpenseEngineeringTelephone - CommunicationsAlarm System ExpenseAutomobile Insurance2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/172018 Proposed 109,51280912,56215,261482,401345,14816,835502,576 ,514 107,5482,19213,30213,4925622,078301,534440,709 116,5142,50016,26715,0005622,540367,637521,020 ,301 83,1841,40414,33821,6051,9031,3847,072 97,7288,50015,00022,0003,0002,0001,985 89,77318010,41120,9964,1881,4382,207 97,7281,50013,52622,0005,3401,4382,207 111,0688,50015,00012,0005,5002,0002,676Page 9Sewer Fund

Malvern Borough, Chester County2018 BudgetAccount 3TotalAccount TitleWorkers CompensationCasualty - General LiabilityCatastrophe Liability Insurance (Umbrella)Social Security Tax - BoroughCommercial Property InsurancePublic Officials Liability InsuranceDental Care InsuranceIncome Protection InsuranceHealthcare InsuranceGroup life InsuranceMisc. Ins.: Crime, Bonds, Computers2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 11/30/17 11,64663214,1573,0712,8613,92640,3211,412208,916 230239,521 TRANSFER TO OTHER FUNDSTransfer to Sewer Capital Reserve Transfer to Contingency Account Transfer to Sewer Capital Reserve for Debt Service 194,201194,201 29,31418,80148,115 TOTAL SEWER FUND EXPENDITURES 905,693 Page 10835,151 087- 8,565 139,217139,217645,796 2018 Proposed 300- 257,903 39,380- - 39,380888,802 861,585Sewer Fund

Malvern Borough, Chester County2018 BudgetSewer Capital Reserve FundRevenueAccount Number20.392.00220.392.00320.393.010TotalAccount Title2016 ActualBeginning BalanceReceived from Operational FundReceived from Operational Fund for Debt ServiceProceeds of Long-Term Debt (10-year loan) 1,062,834194,2011,257,0352017 Budget TOTAL SEWER CAPITAL RESERVE FUND REVENUES 1,257,035 1,214,83629,31418,8011,000,0002,262,9512017 Year-to Date 2017 Projected FinalThru 11/30/17 2,262,951 1,256,8181,256,818 1,256,818 1,256,818139,2171,396,0352018 Proposed 1,262,94139,3801,302,3211,396,035 1,302,321Sewer Capital Reserve FundExpendituresAccount NumberAccount Title20.429.072Repair of Sewer Mains20.429.073Repair Joints for I & I20.429.074 Upgrade wet well at Pump Station #2-Ruthland Ave.20.429.076Construction Fund - TT & VFSA20.429.077Replace Pump at Station #120.471.010Debt Service - Principal (10-year loan to 2026)20.472.020Debt Service - Interest (10-year loan to 2026)Total2016 Actual TOTAL SEWER CAPITAL RESERVE FUND EXPENDITURES 2182182017 Budget 218 SEWER CAPITAL RESERVE BALANCE 1,256,818Page 115,00050,000300,000125,00025,00014,814519,8142017 Year-to Date 2017 Projected FinalThru 10/31/17 32,73890,905123,643 42,18990,905133,0942018 Proposed 5,00050,000240,00075,00045,000415,000519,814 123,643 133,094 415,000 1,133,175 1,262,941 887,321Sewer Capital Reserve

Malvern Borough, Chester County2018 BudgetCapital Reserve FundRevenueAccount unt Title2016 ActualBeginning BalanceEarnings from InvestmentsTransfer from General FundProceeds of Long Term DebtProceeds of Short Term DebtTransfer - EEB HUB Separate AccountTransfer - Municipal Building Renovations Sep. Acct.Transfer of Historic General Fund Balance SurplusTotal 2017 Budget3,144,0905,174284,052- 3,433,316 TOTAL CAPITAL RESERVE FUND REVENUES 3,433,316 2,553,3386,2001,801,476150,0009,9954,521,0092017 Year-to Date 2017 Projected FinalThru 11/30/17 2,884,2974,636519,3123,408,244 4,521,009 3,408,244 2,884,2976,2001,616,1804,506,6762018 Proposed 3,998,6256,0001,400,309- 150,00033,000 - 5,587,9354,506,676 5,587,935Capital Reserve FundExpendituresAccount 37.00230.439.001Account TitleZoning Ordinance Amendments/UpdateGeneral Code Reformat of Code of OrdinancesDocument ImagingMunicipal Building Renovations (EEB HUB)Traffic Analysis Engineering StudiesMunicipal Best Practices Consultants StudyMultimodal Pedestrian ImpStormwater Pipe Replacement on No. Warren AveRandolph Woods Dev./Malvern-Willistown Greenway TrailReal EstateWoodland Avenue Streetscape ProjectSidewalk ImprovementsDecorative CrosswalksStreetscape ImprovementsBridge Street Bridge RepairsOld Lincoln Highway Improvements2016 Actual 0,000-Page 122017 Budget 40,00025,00020,000400,0002017 Year-to Date 2017 Projected FinalThru 11/30/17 3,65911,80034,14768,13527,73524,7995,600978 18 Proposed 40,00095,00032,500400,000Capital Reserve Fund

Malvern Borough, Chester County2018 BudgetAccount 71.00030.472.00030.480.8932TotalAccount TitleTraffic Safety ImprovementsStreambank StabilizationSignage throughout the Borough (Wayfinding)Municipal Building RenovationsDebt Service - PrincipalDebt Service - InterestGeneral Expense2016 Actual TOTAL CAPITAL RESERVE FUND EXPENDITURES 41,258247,00025,932549,0192017 Budget 549,019 CAPITAL RESERVE BALANCE 2,884,297 Page ,7202017 Year-to Date 2017 Projected FinalThru 10/31/17 857 508,051 3,115,5601,445,289 2,923,387 3,998,625 2,472,3753,075,720 34,998251,00019,0552,953484,857 37,252251,00022,7253,000508,0512018 ProposedCapital Reserve Fund

Malvern Borough, Chester County2018 BudgetHighway Aid FundRevenueAccount Number35.341.00035.355.005TotalAccount Title2016 ActualBeginning Balance Earnings from Investments State Motor License Fund Grant TOTAL HIGHWAY AID FUND REVENUES 94,04954684,177178,7712017 Budget 129,77660086,752217,128178,771 2017 Year-to Date 2017 Projected FinalThru 10/26/17 217,128 129,94665188,609219,206 219,206 129,94665188,609219,2062018 Proposed 170,20660091,322262,128219,206 262,128Highway Aid FundExpendituresAccount Number35.492.000TotalAccount Title2016 Actual2017 Budget2017 Year-to Date 2017 Projected FinalThru 10/26/172018 ProposedTransfer to General Fund 48,826 48,826 49,000 49,000- 49,000 49,000 49,00049,000TOTAL HIGHWAY AID FUND EXPENDITURES 48,826 49,000 - 49,000 49,000HIGHWAY AID FUND BALANCE 129,946 168,128 219,206 170,206 213,128Page 14Highway Aid Fund

Updated: 10-31-17GeneralFundGENERAL FUND, UNRESTRICTED CASH12.31.2016NATIONAL BANK OF MALVERNCHECKINGGF Cap'lReserveSewer/Sewer Cap'lFundLiquidFuels l Cash Available casted RevenuesForecasted Transfers - Liquid FuelsForecasted ExpendituresForecasted Transfers-CRFGeneral Contingency Fund Transfer 4,016,572.03 49,000.00(2,947,356.14) (1,616,179.53) (508,050.61)1,616,179.53( 882,679.00) 1,338,995.14 2,302,018.94 1,662,168.16 6,200.00 888,802.00 89,209.00(49,000.00)East Side Flats Contingency Fund XferForecasted Cash Balance 12.31.2017INDIVIDUAL BANK ACCOUNTSAs of 12/31/2016Account NameAmountHistorical Commission 3,659.81Basketball Court (First Avenue)Sidewalk Fee-in-LieuTAGGreat Valley Holdings 9,162.896,680.16Ruthland Avenue Signage 884.31Stormwater Fund - TAG 16,101.33Shade Tree Fee-in-LieuAndrews Management - Church Street 2,774.31 5,336.421,343.74EEB HUB - Shown in Capital Reserve Fund152,633.07Municipal Building Construction Account32,983.93TOTALSContingency AccountsGeneral FundSewer Fund 224,879.81630,312.83404,176.28170,155.32

Malvern Borough, Chester County 2018 Budget . General Fund Revenues Page 1 General Fund. Malvern Borough, Chester County 2018 Budget Account Number Account Title 2016 Actual 2017 Budget 2017 Year-to Date 2017 Projected Final 2018 Proposed Thru 11/30/17 . SANITATION SERVICES .