City Of Delaware City Delaware November 12, 2020 VIA .

Transcription

City of Delaware CityDelawareNovember 12, 2020TO:VIA:FROM:SUBJECT:Mayor and City CouncilChief David L. Baylor, City ManagerMichelle Y. Graham, Finance ManagerFinancial Report as of October 31, 2020Below please find the internal (unaudited) income and expense statement and check registerfor the 4 months ended October 31, 2020.DepartmentNon-DepartmentalGeneral AdministrationCode EnforcementPublic SafetyCommunity CenterSanitationStreetsDrainageTotal General Fund RevenuesDepartmentGeneral AdministrationCode EnforcementPublic SafetyCommunity CenterPublic WorksSanitationYard WasteStormwaterStreetsDrainageParksTree ManagementRecycling CollectionsDebt ServiceTotal General Fund ExpendituresGeneral Fund .312,705,852.32%General Fund 8.921,740.009,530.9833,759.84573,736.97%General Fund Operating Surplus ,132,115.351

General Fund:The General Fund currently has an operating surplus of 2,132,115.35.General Fund Revenues are trending at 135.80% of the fiscal year budget and expenditures arecurrently trending at 28.80% of the budget.Non-Departmental revenues & Code Enforcement revenues are both at higher than expectedpercentages for this time period in the fiscal year. Community Center expenditures are higherthan the expected for this period in the fiscal year.AccountAccount DescriptionGENERAL FUND REVENUESGENERAL FUND EXPENDITURESCHANGE IN FUND al Revenues:Non-Departmental revenues are not attributable to the actions of one department’s activities.The accounts that would fall under this classification are below:Account 00-406501-000-481001-000-4811Account DescriptionREAL ESTATE TAXESREAL ESTATE PENALTIESINTEREST INCOMECABLE FRANCHISE FEEPILOTTRANSFER IN - WATER FUNDTRANSFER IN - REAL ESTATE TRANSFER TAXNONDEPARTMENTAL REVENUES2021 .0090,000.001,266,620.002021 831.70Non-Departmental Revenues are currently over 200% of the fiscal year budget. This is due tothe Transfer In – Water Fund revenue that represents the amount that was received from thesale of the Water Fund.2

General Administration:General Administration revenues are those revenues attributable to the activities performed bythe General Administration department. These include business and contractor’s licenses,permits, and property and lease agreements.AccountAccount 000-4905LICENSES AND PERMITSMISCELLANEOUS REVENUESALES - GARENTAL PROPERTYCELL TOWER LEASE / BALLFIELDAAT (CNS) LEASESDEMA HOMELAND SECURITY SUBAWARDGENERAL ADMINISTRATION 1-000-507001-000-5095SALARIES - GENERAL ADMINISTRATIONSALARIES - MAYOR & COUNCILSALARIES - CITY SECRETARYPAYROLL TAXES - GARETIREMENT PLAN - GAADVERTISING - GAASSESSOR - GAAUDIT - GAPAYROLL PROCESSING FEES - GACONTRACTUAL/PROFESSIONAL SERVICES - GAGIFTS AND -000-8000DUES/SUBSCRIPTIONS/MEETINGS - GAELECTION EXPENSE - GAELECTRICITY - GAENTERTAINMENT/ACTIVITIES - GAFEES/INTEREST/PENALTIES - GAHEATING FUEL - GAINSURANCE / GENERAL - GAINSURANCE / HEALTH - GAINSURANCE / PUB. OFF. LIAB. - GALEASE - PURCHASE/EQUIPMENT - GALEGAL - GAMAILINGS / POSTAGE - GAMAINTENANCE / BUILDING - GAMAINTENANCE / EQUIPMENT - GAMATERIALS & SUPPLIES - GAMISCELLANEOUS EXPENDITURES - GAOFFICE SUPPLIES - GAPLANNING & INSPECTIONS - GASEWER CHARGES NEW CASTLE COUNTY - GATELEPHONE - GATRAINING, TRAVEL, FOOD - GAWATER - ARTESIANBUILDING IMPROVEMENTSOPERATING TRANSFERS - GAGENERAL ADMINISTRATION 00(155.84)(30,000.00)433,350.00723,452.843

General Administration revenues are currently trending at 52% of the fiscal year budget.Included in this revenue is a 30,000 DEMA grant that was used for improvements to the lobbyin Town Hall and 4,193.00 in Miscellaneous Revenue which are insurance proceeds fromdamages to the park due to a car accident.Expenditures are currently trending at 26% of the fiscal year budget. Contractual /Professionalservices have a substantial increase compared to last month’s report due to our annualpayment to Edmunds for our financial software maintenance agreement. Legal fees aretrending ahead of our adopted budget. Maintenance/Building is currently trending at 73% ofits adopted budget. Current maintenance expenses are mainly comprised oflandscaping/mowing ( 4560), heating & air conditioning maintenance agreement & repairs( 2099) & Town Hall cleaning ( 2100). Since last month’s report, invoices have been receivedfrom BIU for Planning & Inspection expenditures. They are currently only 1 month behind ininvoicing.Code Enforcement:Code Enforcement activities are related to violations of the City’s ordinances and act as aneffort to promote upkeep of properties located in the City’s ES/PENALTIES - CECODE ENFORCEMENT 4001-050-5340SALARIES - CEPAYROLL TAXES - CECONTRACTUAL/PROFESSIONAL SERVICES - CEGAS & OIL / VEHICLE - CEMISCELLANEOUS EXPENDITURESCODE ENFORCEMENT .977,890.00612.80500.00211.23150.009,364.03Code Enforcement revenues are currently trending at 72% of the fiscal year budget andexpenditures are trending at 23.25% of the fiscal year budget.4

Public Safety:Public Safety revenues are those revenues generated by the activities of the Delaware CityPolice Department. These include judgments rendered by courts, towing fees, extra dutyrequests, and grant revenues provided by State law enforcement 103-5001DESCRIPTIONFINES - PSCHARGE SERVICES - EXTRA DUTY PSPERMITS - SPECIAL EVENTSCONTRACT REIMBURSEMENT - PSINTRAFUND TRANSFER - GENERAL ADMINCOMBAT VIOLENT CRIMEOFFICE OF HIGHWAY SAFETYPUBLIC SAFETY REVENUESDESCRIPTIONSALARIES - FULL-TIME DUTYSALARIES - EXTRA DUTYSALARIES - OVERTIMEPAYROLL TAXES - PSRETIREMENT PLANS - PSCELL PHONES / MDT AIR-CARD SERVICE - PSCONTRACTUAL/PROFESSIONAL SERVICE - PSDUES/SUBSCRIPTIONS - PSELECTRICITY - PSGAS & OIL / VEHICLE - PSHEATING FUEL - PSINSURANCE / HEALTH - PSLEASE - PURCHASE/EQUIPMENT - PSLEASE - PURCHASE/VEHICLE - PSMAINTENANCE / BUILDING - PSMAINTENANCE / EQUIPMENT - PSMAINTENANCE / VEHICLE - PSMATERIALS & SUPPLIES - PSMISCELLANEOUS EXPENDITURES - PSOFFICE SUPPLIES - PSTRAINING, TRAVEL & FOOD - PSUNIFORM & PERSONAL EQUIPMENT - PSCOMBAT VIOLENT CRIMESALARIESMACHINERY AND EQUIPMENTOFFICE OF HIGHWAY SAFETYSALARIESMACHINERY & EQUIPMENTPUBLIC SAFETY 40.00)317,064.945

Public Safety expenditures are currently trending at 27% of the adopted budget.Contractual/Professional services is currently over the budgeted amount due to payment forevidence licenses and fitness for duty exams.Community Center:Community Center revenues are those that are received to support the operation andmaintenance of the community center. Primarily, these are rental payments from Reedy PointPlayers, reimbursement of utility expenditures for the Delaware City Library, and Grant-In-Aidrevenues received from the RIPTIONEVENT/ACTIVITY RENTAL REVENUE - CCRENTAL/MAINTENANCE SURCHARGE - CCGRANT-IN-AIDCOMMUNITY CENTER 0.00)(16,499.00)(18,971.93)(37,870.93) 23,129.07 of the 35,000.00 in Grant-In-Aid revenue has been utilized thus far to help coveroperating expenses at the Community Center.Expenditures are currently at 80% of the fiscal year budget. The main increase in expendituresfor the month of October were mowing expenses to Cutting Edge and repairs to the rooftopHVAC 01-200-536501-200-5370DESCRIPTIONSALARIES - CCPAYROLL TAXES - CCCONTRACTUAL/PROFESSIONAL SERVICES - CCELECTRICITY - CCHEATING FUEL - CCLEASE - PURCHASE/EQUIPMENT - CCMAINTENANCE / BUILDING - CCMATERIALS & SUPPLIES - CCSEWER CHARGES - NEW CASTLE COUNTYTELEPHONE - CCCOMMUNITY CENTER 235.71800.0411,262.856

Public RIPTIONCONTRACTUAL/PROFESSIONAL SERVICES - PWMAINTENANCE / EQUIPMENT - PWOPERATIONS/EXPENDITURES - STORMS PWPUBLIC WORKS 662.63615.00(2,295.42)21,982.21Outside of the storms expenditures, which were discussed last month, Public Works is trendingwithin expectation of the budget.Sanitation:Current sanitation revenues are those fees charged to property owners that are outside of theproperty limits, and extra cart fees for City residents.ACCOUNTDESCRIPTION01-350-4000SANITATION FEESSANITATION REVENUES01-350-5070CONTRACTUAL/PROFESSIONAL SERVICES - SNSANITATION on expenditures are currently trending slightly ahead of the adopted budget for thistime period in the fiscal year. We will continue to monitor the expenditures monthly.Yard FESSIONAL SERVICES - YWYARDWASTE FESSIONAL SERVICES - SWELECTRICITY - SWSTORMWATER 7,065.69Contractual services expenses are payments to KCI Technologies for the SWMPG project whichwas started in July. The estimated cost of the project is 22,844, of which ½ of the cost will bereimbursed with a matching grant.7

Streets:ACCOUNTDESCRIPTION01-400-4810TRANSFER IN - MUNICIPAL STREET AID FUNDSTREETS 30CONTRACTUAL/PROFESSIONAL SERVICES - STELECTRICITY - STMAINTENANCE / STREETS - STMATERIALS & SUPPLIES - STSTREETS 450-5310Account DescriptionMAINTENANCE / DRAINAGE - DRDRAINAGE ,500.001,500.00Park Maintenance IONMAINTENANCE / PARKS - PKMATERIALS & SUPPLIES - PKPARKS .08Park Maintenance expenditures for the month of October include mowing services andreplacement of a light pole head in the park. In addition, there were 4,193 in polereplacement expenses at the park due to a motor vehicle accident that were reimbursed by theinsurance proceeds mentioned as part of the General Administration revenues.Tree Maintenance NCE / TREES - TRTREE 1,740.00VARIANCE8,260.008,260.00No change in tree expenditures since September’s report.8

Recycling Collection UAL/PROFESSIONAL SERVICES - RCRECYCLING 9,530.98VARIANCE20,469.0220,469.02Recycling expenditures are currently on track within the current budget.Debt Service 00-5903DEBT SERVICE - WASHINGTON REVOLVING LOANDEBT SERVICE - COMMUNITY CENTER ROOFDEBT SERVICE - STREET BOND WSFS REFIDEBT SERVICE - VERIZON APPEALDEBT SERVICE 0032,980.000.1689,310.16Debt service expenditures will be lower than budgeted due to the payoff of the Street BondWSFS Refi. This debt was paid in full with the water sale.9

Water Fund:The Water Fund currently has a net income of 387,072.36.The only changes from last month’s reports are expenditures in Electricity & BuildingMaintenance. This is due to a final bill in the amount of 1.52 Delmarva Power and a final billfrom Cutting Edge for mowing services at Well -000-8000DESCRIPTIONBUDGETWATER UTILITY FEESREFINERY WATER UTILITY FEESGAIN ON SALEEASMENT REVENUEWATER FUND ECONTRACTUAL/PROFESSIONAL SERVICES - WFELECTRICITY - WFHEATING FUEL - WFLEGAL - WFMAINTENANCE / BUILDING - WFMATERIALS & SUPPLIES - WFSEWER CHARGES NEW CASTLE COUNTY - WFTELEPHONE - WFTRANSFER OUT - GENERAL FUNDWATER FUND 62.8323.76140.861,493,720.461,513,856.61NET INCOME (DEFICIT)-387,072.3610

Real Estate Transfer Tax 4040REAL ESTATE TRANSFER TAXESREAL ESTATE TRANSFER TAX REVENUES-27,378.1027,378.1003-110-8000TRANSFER OUT - GENERAL FUNDREAL ESTATE TRANSFER TAX EXPENDITURES-27,378.1027,378.10NET CHANGE IN FUND BALANCE--Municipal Street Aid 4900MUNICIPAL STREET AIDSTREETS REVENUES-49,036.7649,036.7603-120-8000TRANSFER OUT - GENERAL FUNDSTREETS EXPENDITURES-1,956.311,956.31NET CHANGE IN FUND BALANCE-47,080.45The FY 21 Municipal Street Aid award was received in September in the amount of 49,053.97.In October, the State adjusted the award amount to 49,036.76. Thus far, we have 1,956.31 instreets expenditures.Façade Program Revolving Loan 4005INTEREST INCOMEFAÇADE PROGRAM REVOLVING LOAN FUND REVENUES-32.5432.5403-130-0000REVOLVING LOAN FACADE PROGRAMFAÇADE PROGRAM REVOLVING LOAN FUND EXPENDITURES--NET CHANGE IN FUND BALANCE-32.5411

State Aid to Local Law Enforcement 4900STATE AID TO LOCAL LAW ENFORCEMENTSALLE FUND REVENUES-939.48939.4803-140-5000SALARIESSALLE FUND EXPENDITURES-939.48939.48NET CHANGE IN FUND BALANCE--Emergency Illegal Drug Enforcement 4900EMERGENCY ILLEGAL DRUG ENFORCEMENTEIDE FUND REVENUES-334.20334.2003-150-5000SALARIESEIDE FUND EXPENDITURES-334.20334.20NET CHANGE IN FUND BALANCE--Mayor’s Ball Fund:10-000-4015DONATIONSMAYOR'S BALL REVENUES-(200.00)(200.00)10-000-5340MISCELLANEOUS EXPENDITURESMAYOR'S BALL EXPENDITURES-24,700.0024,700.00NET CHANGE IN FUND BALANCE-(24,900.00)The increase in the net change in the Mayor’s Ball fund balance from last month’s report is dueto expenditures for the park sign renovations.Delaware City Day Component ARE CITY DAY COMMITTEE FUND EXPENDITURESBUDGETACTUAL-VARIANCE151.25151.25The Delaware City Day Component expenditures are for our Delaware City Day banner thatwas order before the event was cancelled.12

Cash Balances:Please find below the reconciled balances of our bank accounts, as of October 31, 2020 andcompared to prior month balances, as well as a check register for the month of October 2020.DESCRIPTIONCASH - GENERAL FUND CHECKINGCASH - WSFS MONEY MARKETCASH - VIOLENT CRIMES CHECKING ACCOUNTCASH - GRANT IN AID CHECKINGCASH - MUNICIPAL STREET AID FUNDCASH - REVOLVING LOAN FACADE FUNDCASH - SALLE FUNDCASH - EIDE FUNDCASH - MAYOR'S BALL ACCOUNTCASH - DELAWARE CITY DAY COMMITTEETOTAL RECONCILED 57)(1,199,958.96) 92)** 1,200,000.00 was invested with a WSFS Wealth Investment portfolio.**13

Check #Check DateVendor1426010/1/2020 BGAUT0051426110/1/2020 CERTI0051426210/1/2020 DELAG0051426310/1/2020 DELAW0651426410/1/2020 MAICH0051426510/1/2020 STATE0501426610/7/2020 1STCH0051426710/7/2020 AECOM0051426810/7/2020 CAPIT0051426910/7/2020 CRYST0051427010/7/2020 DELMA0101427110/7/2020 DELMA0101427210/7/2020 DELMA0101427310/7/2020 DELMA0101427410/7/2020 DELMA0101427510/7/2020 DELMA0101427610/7/2020 DELMA0101427710/7/2020 DELMA0101427810/7/2020 DIAMO0101427910/7/2020 DIGIT0051428010/7/2020 FUELM0051428110/7/2020 GSDIR0051428210/7/2020 KCITE0051428310/7/2020 PSCCO0051428410/7/2020 DIAMO0051428

SUBJECT: Financial Report as of October 31, 2020 . Below please find the internal (unaudited) income and expense statement and check register for the 4 months ended October 31, 2020. Department Budget Actual % Non-Departmental 1,266,620.00 2,552,451.70 201.52% General Administration 210,000.00 109,735.85 52.26%