Loading...
HomeMy WebLinkAbout2021-007 2021 Budget Amendment and Appropriations - Second ReadingAN ORDINANCE ORDINANCE NO. 2021-007 amending the 2021 Budget for the City of Yakima; and making appropriations from Unappropriated Fund Balances within various Funds for expenditure during 2021 for various purposes including 2020 encumbrances. WHEREAS, the various funds indicated on the attached Schedule contain Unappropriated Fund Balances available for appropriation and expenditures during 2021 in various amounts and for the purposes mentioned in the attached Schedule; and WHEREAS, at the time of the adoption of the 2021 budget it could not reasonably have been foreseen that the appropriation provided for by this ordinance would be required; and the City Council declares that an emergency exists of the type contemplated by RCW 35.33.091 and that it is in the best interests of the City to make the appropriation herein provided; now, therefore, BE IT ORDAINED BY THE CITY OF YAKIMA: Section 1. Appropriations are hereby made, for expenditure during 2021, from Unappropriated Fund Balances in the various Funds to the various accounts and in the various amounts, and for the various specific purposes, all as specified in the Schedule attached hereto and incorporated herein. Section 2. This ordinance is one making an appropriation and shall take effect immediately upon its passage, approval and publication as provided by law and by the City Charter. PASSED. BY THE CITY COUNCIL, signed and approved this 20th day of April, 2021. P tricia Byers, ATTEST: Sonia IaarTee, Ci First Reading: April 6, 2021 ler Publication Date: April 23, 2021 Effective Date: April 23, 2021 TO: Mayor and City Council FROM: Steve Groom, Director of Finance and Budget Kimberly Domine, Finance Division Manager Jen Morris, Financial Services Officer DATE: April 2, 2021 RE: 2021 Budget Ordinance - 2020 Carryforward This budget ordinance effects course corrections based on new information for the 2021 Budget year that was not known at the time of budget adoption. Staff routinely brings budget amendments, approximately quarterly to be transparent and accountable. Budget amendment is a recurring budget process step; staff accumulates new information anticipating to bring adjustments of this type to council on an approximately quarterly basis and is typically for one of four reasons: 1) New additional revenue makes it possible to approve additional related expenses, 2) Prior -year budgeted obligations need to be rolled forward to match disbursement in the current year, if not yet disbursed by Feb. 28th (60 days) 3) Accumulated fund balances can be appropriated, and 4) Corrections or changes between funds. Staff requests approval of adjustments and corrections to the 2021 budget that are now known that were not known at the time of adoption, per the attached detail spreadsheet, described in more detail as follows. tem numbers listed match red Ref#'s on attached spreadsheet: New Revenue: 1). Clean City donation $6,000 from Walmart for graffiti related expenses; this adjustment increases both revenue and expense in equal and offsetting amounts. 2), Parks donation $1,400 for Memorial Park Bench; this adjustment increases both revenue and expense in equal and offsetting amounts. 3). Airport CARES Act grant $22,500 was approved by council; this budget adjustment increases both equal and offsetting donation revenue and expenses, 4). Office of Neighborhood Development (ONDS) Cares Act Grant $618,993 was approved by council, this budget adjustment therefore increases both equal and offsetting donation revenue and expenses. Prior -Year roll -forward of 2020 encumbrances: 5). Prior -Year roll -forward of202U encumbrances. A large portion of this adjustment is for the Equipment Rental Fund, for prior -year -authorized puu:hesea-ofvohidea and equipment that have olong purchase |ead-Ume. $701.654.80 Offsetting revenue and expense for COBG and HOME grants nf$2.824.285.O5 not yet obligated are also carried forward. All of these expenditures were included in the 2020 budget and as result are revenue -neutral to the 2021 Budget —these simply renew previously -approved expenditure authority. 8imi|ody. General Fund roll -forward of2O2O- epprovadexpenditures ia$4O4.641.83. From Fund Balance: ' The adjustments and corrections to the 2021 budget that are now known that were not known at the time ofadoption, are: 6). Increase General Fund Expenditures in Clean City for budgeted Temporary Salary inadvertently omitted from the 2021 Budget ordinance schedule $35.72D 7l. Increase expenditures in Debt Fund 272 for budgeted Interest expense inadvertently omitted from the 2O21 Budget ordinance schedule. $58.98Ei80 8). |ncnaooe expenditures in Capital Improvement Reserve Fund 382 forCoyente Upgrade that was approved bycouncil requiring matching budget ordinance amendment $231.460 0>. Increase expenditures in Fund 474 Water Operations for increased ditch fees. $25.000 ' 1O).Increase expenditures inWater Capi I tal Fund 477for the Water System Construction for water main inthe N1st Street Project. $581]}00 ' 11). Increase 3%Criminal Justice Fund expenditures $1OO.O0Ofor council -approved portob|ms and mobiles upgrade and 25O.DOOfor radio console upgrades. $350.000 12). Increase Airport Operations Fund421 expenditures for the R & M Contractors for Airport Roof repairs. $20,000 13).|nnroase expenditures inAirport Operations Fund421hocalibrate navigation equipment. $10,000 14). Increase expenditures in General Fund Parking Enforcement 001 for Vehicle Replacement Reserve $ 16,245 per actual usage 15). Increase expenditures in Fund 581 Utilities Customer Service for Vehicle Replacement Reserve $22,298 per actual usage Staff expects further 2021 course -correction budget adjustments later in the year, as new City of Yakima 2021 Budget Amendment & PO Encumbrances 1st Quarter SCHEDULE I From Fund To Fund Fund 1 Accoun Name New Revenue - offsetting increases in expenditures and revenues Fund j'. Accoun Name From Dr (Cr) To Dr (Cr) Description 1 331 421 124 124 124 8956718 8956715 8953116 8953117 8953117 8953117 Donations Donations CARES Grant CARES Grant CARES Grant. CARES Grant. 1. 1364100 Professional Service 331 5453500 Small tools & Minor Equipment 421 2823110 Supplies 124 2423119 Operating Supplies- COVID 124 2414130 HBCC Public Services 124 2414820 Neighborhood Cleanup/Imprvmnt 6,000.00 1,400,00 22,500.00 123,625.00 235,368.00 260,000.00 648,893.00 6,000.00 1,400.00 22,500.00 618,993.00 648,893.00 Carr yfotward of encumbrance from 2020 prior year budget: 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 1 Gen Fund 124 Comm Des 8953104 131 Parks 131 Parks 303 .3%CJ Capital 303 .3%CJ Capital 342 REETI 342 REETI 342 REETI 370 Conv Ctr Capital 442 Stormw Cap 442 Stormw Cap 471 Refuse 471 Refuse 473 WW Op 474 Water Op 476 WW Constr 478 WW Facilities 552 Repl Reserve 555 Environmental 555 Environmental 555 Environmental Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward 1 Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward. Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward Fund Bal. prior yr carryforward 1024100 Professional Service $ 48,131.77 1363110 Supplies $ 21,660.00 1364100 Professional 5ervice $ 28,010.69 1624100 Professional Service $ 15,000.00 3133500 Small Tools & Minor Equipment $ 1,462.07 3133500 Small Tools & Minor Equipment $ 1,047.99 3133500 Small Tools & Minor Equipment $ 50,901.00 3133502 Ballistic Vests $ 9,983.45 3133503 Swat Minor Equip $ 8,079.64 3183112 Supplies $ 3,172.82 3184800 $ 6,196.53 3193112. Supplies'. $ 25,816.70 3193112 Operating Supplies/Ammunition $ 9,949.39 3193500 Small Tools & Minor Equipment $ 2,950.76 3193500 Small Tools & Minor Equipment $ 13,922.81 1 3513510 Non -Capital Computer Equipment $ 10,450.47 1 3516460 Data Processing Equipment $ 84,038.58 1 3516460 Data Processing Equipment $ 57,530.22 1 6123500 Small Tools & Minor Equipment $ 1,944.08 1 6536420. Operating Equipment $ 73,248.79 1 6536420 Operating Equipment $ 11,144.07 $ 484,641.83 124 2414820 Neighborhood Cleanup/Imprvmnt $ 2,924,265.65 $ 2,924,265.65 131 5214800 R &M/Contractors $ 11,535.03 $ 11,535.03 131 5434100 Professional Service $: 10,071.90 $ 10,071.90 303 3013500 Small Tools & Minor Equipment $ 5,236.88 $ 5,236.88 303 3013500 Small Tools & Minor Equipment $ 32,238.92 $ 32,238.92 342. 7146200 Buildings $ 10,288.50 $ 10,288.50 342 7146200 Buildings $ 10,828.92 $ 10,828.92 342 7146300 Improvement Other than Buildings $ 10,828.92 $ 10,828.92 370 2794800 R & M/Contractors $ 40,372.07 $ 40,372.07 442 7524100 Professional Service $ 235,676.58 $ 235,676.58 442 7524100 Professional Service $ 31,704.87 $ 31,704.87 471 4723500 Small Tools & Minor Equipment $ 2,513,64 $ 2,513.64 471 4723500 Small Tools & Minor Equipment $ 32,322.83 $ 32,322.83 473 7313125 Lab Supplies $ 1,657.62 $ 1,657.62 474 7654800 R & M/Contractors $ 6,516.00 $ 6,516.00 476 7384100 Professional Service $ 235,676.58 $ 235,676.58 478 7394100 Professional 5ervice $ 360,042.34 $ 360,042.34 552 5526440 Trucks $ 701,654.80 $ 701,654.80 555 5614817 R & M Tiger Oil. $ 123,052.10 $ 123,052.10 555 5614812 R & M Tiger Oil $ 55,373.00 $ 55,373.00 555 5616400 Machinery & Equipment $ 201,543,83 $ 201,543.83 Ref 1 Walmart Donation for Graffiti Expense 2 Memorial Bench Donations 3 CARES Grant 4 CARES Grant 4 CARES Grant 4 CARES Grant 5 Kiosk 5 YPD Graffiti Tracker 5 CLEAN CITY HOMELESS OUTREACH COR. 5 HR Professional Service 5 Computer 5 FIREARMS 5 YPD Survivor VR SIM Training 5 YPD- BALLISTIC VESTS 5 YPD-GASMASK FILTERS. 5 YPD- AIR FILTERS 5 YPD-OFFICE SPACE 5 AMMO 5 YPD-FIREARMS 5 Per Quote Q20-K20-901 5 YPD-LIVE SCAN - GSA Contract GS-35F-0199R 5 Quote LTVP456 Lenovo Comp Equip NASPO MNWNC-117 05815-007 5 Pro Services per quote 6MF148379 5 Computer Equipment 5 Small Tools & Minor Equipment 5 LICENSE PLATE READERTECH-PARKING ENFORCEMENT 5 TICKET WRITER TECH 5 Home Program/CBDG Program 5 Lions Pool Fiber Optic Cable Install 5 P&R Survey Wide Hollow Pedestrian Bridge 5 Armory Supplies 5 Computer Equipment 5 CITY HALL KIOSK CAMERA 5 CITY HALL LED LIGHT FIXTURES 5 HBJCC RELOCK AND KEY TO MASTER 5 Compactor 5 Professional Services from Akel Engineering for Wastewater 5 Stormwater Mock Audit Project#5W2521 C2020-139 5 REFUSE CARTS QUOTE WQ-101538730MNIA Contract 9171717 5 REFUSE CARTS QUOTE WQ-101538730MNIA Contract 6171717 5 GLS Composite Sampler parts for priority pollutant metals 5 WWTP Facility Master Plan 5 Stormwater Collections Master 5 WWTP Facility Master Plan 5 Trucks 5 Professional 5ervice 5 Professional Service 5 Fuel Management System Upgrades 4/2/2021 1 of 2 \\yakima_city\ykfn\Shared\Budget 2021\JM- 2021 QTR 1 Budget Amendment Amended City of Yakima 2021 Budget Amendment & PO Encumbrances 1st Quarter SCHEDULE I Fund From Fund Account 4 I Name Fund Account To Fund Name (Increase Budget Expenditures from Reserves From Dr (Cr) To Dr (Cr) $5,528,043 $5,528,043 Description Ref 1 Gen Fund Reserves 272 Cony Ctr PFD: Reserves 392 Capital Impr Res Reserves 475 Irrigation Op Reserves 477 Water Capital Reserves 003 .3%CJ Reserves 003 .3%CJ Reserves 421 Airport Op Reserves 421 Airport Op Reserves 551 Equip R 8956541 ER Replacement Fund 551 Equip R 8956542 ER Replacement Fund 1 1361120 Salaries/Temporary 272. 8328320 LTD External Interest 39Z 6526450 Other Equipment 475 7824708 Ditch Charges 477 7736534 Water System Const 59434 003 3013500 Small Tools & Minor Equipment 003 3013500 Small Tools & Minor Equipment 421 2864100 R & M Contractors 421 2814100 Professional Service 1 6510092 Vehicle Reserves 581 7670092 Vehicle Reserves 35,728.00 $ 35,728.00 6 Temporary Salaries budget in 2021 Budget missed on ordinance 58,999.80 $ 58,999.80 7 Interest omitted from 2021 Budget 231,460.00 $ 231,460.00 8 Cayenta Software Upgrade Approved by Council 25,000.00 $ 25,000.00 9 Additional Fees for water cost from naches Cowiche Canal 581,000.00 $ 581,000.00 10 Water Main for N 1st Street Project 250,000.00 $ 250,000.00 11 Radio Consoles Upgrade 100,000.00 $ 100,000.00 10 Portables and mobiles upgrade 20,000.00 $ 20,000.00 12 Roof Repairs 10,000.00 $ 10,000.00 13 calibrate navigation equipment 16,245,00 $ 16,245.00 14 Vehicle Reserves -Parking 22,298.00 $ 22,298.00 15 Vehicle Reserves- Utilities 1,350,730.80 $ 1,350,730.80 $ 7,527,666.61 $ 7,527,666.61 4/2/2021 2 of 2 \\yakima_city\ykfn\Shared\Budget 2021\JM- 2021 QTR 1 Budget Amendment Amended