HomeMy WebLinkAbout2021-044 Ordinance 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 (Second Reading)AN ORDINANCE ORDINANCE NO. 2021-044 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 described in the attached Schedule. WHEREAS, the various funds indicated on the attached Schedule I 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 14th day of December, 2021. ATTEST: _J.r-10...00fe,1-7,) a? Sonya Claar Tee, City Clerk First Reading: December 7, 2021 Publication Date: December 17, 2021 Effective Date: December 14, 2021 City of Yakima 2021 Budget Amendment 4th Quarter SCHEDULE I From Fund From Dr (Cr) To Fund To Dr (Cr) Fund I Account 8 Name Fund I Account I Name 8 Description Ref New Revenue - offsetting increases in expenditures and revenues Parks Capital 331 8956711 Donation TPA 173 8951810 Operating Assessments $ (8,895.00) 331 5436300 Improvement Other than Buildings $ (180,000.00) 173 2554100 Professional Service $ (188,895.00) $ 8,895.00 1 Donation for Miller Park Improvements $ 180,000.00 2 Increase in Sales Tax for TPA $ 188,895.00 'Technical Adjustment - House Keeping ARPA ARPA ARPA ARPA ARPA Fire Capital Fire Capital Police Capital Police Capital EMS Levy Fire Capital Clean City Clean City Clean City Clean City 180 6090055 Transfer Out 170 180 180 180 332 332 333 333 150 332 1 1 1 1 2784110 6090055 6096400 6096430 3270092 8950050 1361120 1363110 1364100 Community Svc Program Reserves Fire Machinery & Equipment Police Vehicles Reserves Reserves Reserves Reserves Vehicle Replacement Reserve Transfer In Salaries/Temporary Office and Operating Supplies Professional Service Reserves Facilities 1 2240092 Vehicle Replacement Reserve 1 2290092 Vehicle Replacement Reserve Parking 1 6530092 Vehicle Replacement Reserve 7000092 Engineering 1 Vehicle Replacement Reserve 2230092 1 Vehicle Replacement Reserve 1260092 125 Vehicle Replacement Reserve 5410092 Parks 131 Vehicle Replacement Reserve 4130092 Streets 141 Vehicle Replacement Reserve 7460092 Storm Water 441 Vehicle Replacement Reserve 4760092 Refuse 471 Vehicle Replacement Reserve Waste Water 473 7260092 Vehicle Replacement Reserve Waste Water 473 7290092 Vehicle Replacement Reserve Waste Water 473 7310092 Vehicle Replacement Reserve (500,000.00) 170 (500,000.00) 180 (6,255,760.00) 180 (1,600,000.00) 180 (4,655,760.00) 180 (1,600,000.00) 332 (1,600,000.00) 332 (4,655,760.00) 333 (4,655,760.00) 333 (75,000.00) 150 (75,000.00) 332 (35,728.00) 1 (21,660.00) 1 (34,011.00) 1 (6,000.00) 1 $ (3,000.00) 1 $ (2,500.00) 1 $ (18,745.00) 1 $ (7,980.00) 1 $ (2,500.00) 1 $ (2,565.00) 125 $ (90,000.00) 131 $ (350,000.00) 141 $ (60,000.00) 441 (730,000.00) 471 $ (139,000.00) 473 $ (537.00) 473 $ (50,000.00) 473 8950550 Transfer In 2784110 Community Svc Program Reserves 3226400 Fire Machinery & Equipment 3016430 Police Vehicles 8950050 Transfer In 8953119 American Rescue Plan 8953119 American Rescue Plan 8950050 American Rescue Plan 3270055 Transfer Out 8956539 Replacement Monies Reserves Reserves Reserves 8956718 Clean City Donation 2249995 2294995 6534995 7004995 2234995 1264995 5414995 4134995 7464995 4764995 7264995 7294995 7314995 Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs Equipment Replacement Costs $ 500,000.00 $ 500,000.00 $ 6,255,760.00 $ 1,600,000.00 $ 4,655,760.00 $ 1,600,000.00 $ 1,600,000.00 $ 4,655,760.00 $ 4,655,760.00 $ 75,000.00 $ 75,000.00 $ 35,728.00 $ 21,660.00 $ 34,011.00 $ 6,000.00 3 Created ARPA Fund Technical changes for reporting out of fund 180 Correct ARPA transfer to Convention Center for negative tourism impact on revenues 4 Reverse Transfer Out Fire Machinery & Equipment Police Vehicles Moved Revenue to ARPA Fund 180 Moved Revenue to ARPA Fund 180 Moved Revenue to ARPA Fund 181 Moved Revenue to ARPA Fund 182 5 Moved from Vehicle Reserve to transfer In Moved from Revenue to Transfer in 6 Housekeeping -Clean City Fund moved to Special Revenue 136 Housekeeping -Clean City Fund moved to Special Revenue 136 Housekeeping -Clean City Fund moved to Special Revenue 136 Housekeeping -Clean City Fund moved to Special Revenue 136 Change in accounting move from Transfer out to expense account. $ 5,000.00 7 Increase amount transferred into vehicle reserves by $2,000 $ 2,500.00 Change in accounting move from Transfer out to expense account $ 18,745.00 Change in accounting move from Transfer out to expense account $ 7,980.00 Change in accounting move from Transfer out to expense account $ 2,500.00 Change in accounting move from Transfer out to expense account $ 2,565.00 Change in accounting move from Transfer out to expense account $ 90,000.00 Change in accounting move from Transfer out to expense account $ 350,000.00 Change in accounting move from Transfer out to expense account $ 60,000.00 Change in accounting move from Transfer out to expense account $ 730,000.00 Change in accounting move from Transfer out to expense account $ 139,000.00 Change in accounting move from Transfer out to expense account $ 537.00 Change in accounting move from Transfer out to expense account $ 50,000.00 Change in accounting move from Transfer out to expense account 11/23/2021 1 of 3 \\yakima_city\ykfn\Shared\Budget 2021\1M- 2021 QTR 4 Budget Amendment spreadsheet Work in Progressv2 City of Yakima 2021 Budget Amendment 4th Quarter SCHEDULE I From Fund Fund 1 Account 8 I Name Waste Water 473 7340092 Vehicle Replacement Reserve From Dr (Cr) To Fund Fund Account I Name $ (8,944.00) 473 7344995 Equipment Replacement Costs 1 To Dr (Cr) Description Ref $ 8,944.00 Change in accounting move from Transfer out to expense account Water 474 7640092 Vehicle Replacement Reserve $ (150,000.00) 474 7644995 Equipment Replacement Costs $ 150,000.00 Change in accounting move from Transfer out to expense account Water 474 7650092 Vehicle Replacement Reserve $ (30,000.00) 474 7650092 Equipment Replacement Costs $ 30,000.00 Change in accounting move from Transfer out to expense account Water 474 7710092 Vehicle Replacement Reserve $ (3,500.00) 474 7714995 Equipment Replacement Costs $ 3,500.00 Change in accounting move from Transfer out to expense account Irrigation 475 7820092 Vehicle Replacement Reserve $ (55,000.00) 475 7824995 Equipment Replacement Costs $ 55,000.00 Change in accounting move from Transfer out to expense account Equipment Rental 551 5510092 Vehicle Replacement Reserve $ (11,866.00) 551 5514995 Equipment Replacement Costs $ 11,866.00 Change in accounting move from Transfer out to expense account PW Admin 560 4910092 Vehicle Replacement Reserve $ (15,000.00) 560 4914995 Equipment Replacement Costs $ 15,000.00 Change in accounting move from Transfer out to expense account Customer Service Utilities 581 7670092 Vehicle Replacement Reserve $ (26,798.00) 581 7674995 Equipment Replacement Costs $ 26,798.00 Change in accounting move from Transfer out to expense account Equipment Rental Capital 552 8956545 ER Replacement -Ent Funds $ (1,280,645.00) 552 8956541 ER Replacement Funds -Ent Funds $ 1,226,981.00 Change in Accounting move from Transfer in to Revenue Equipment Rental Capital 552 8956546 ER Replacement -Govt Funds $ (479,785.00) 552 8956542 ER Replacement Funds-Govt Funds $ 492,411.00 Change in Accounting move from Transfer in to Revenue $ (29,788,804.00) $ 29,749,766.00 Increase Budget Expenditures from Reserves General Fund 1 Reserves $ (120,000.00) 1 3221200 Overtime $ 120,000.00 8 Increase Fire overtime Professional Service General Fund 1 Reserves $ (123,243.00) 1 2514100 $ 123,243.00 9 Increase in Main Street Tax Credit Community Contractors Relations 180 Reserves $ (4,800.00) 180 1264800 $ 4,800.00 10 Install glass safety partition at the YCTV-Y-PAC Facility using ARPA Funds Contractors Trolley 162 Reserves $ (2,000.00) 162 2064800 $ 2,000.00 11 Increase in Trolley repairs ARPA 180 Reserves $ (14,153.29) 180 1444100 Professional Service $ 14,153.29 12 Laserfiche Upgrade using APRA Funds ARPA 180 Reserves $ (113,803.44) 180 3221200 Overtime -Fire $ 113,803.44 13 Fire Overtime directly related to COVID ARPA 180 Reserves $ (20,000.00) 180 2244100 Professional Service $ 20,000.00 14 Bank of America space study ARPA 180 Reserves $ (50,000.00) 180 2246100 Land $ 50,000.00 15 Cost for purchase of Bank of America Building ARPA 180 Reserves $ (2,000,000.00) 180 2246200 Buildings $ 2,000,000.00 Cost for purchase of Bank of America Building Machinery and Equipment Fire ARPA 180 Reserves $ (16,500.00) 180 3326400 $ 16,500.00 16 Increase cost for purchase Fire vehcicle ARPA 180 Reserves $ (18,450.26) 180 1444100 Professional Service $ 18,450.26 17 Granicus Billing software Refuse EQR Repair Services -Labor Operating 471 Reserves $ (44,412.00) 471 4724891 $ 44,412.00 18 Increase EQR Repair Labor/Parts/Tires for increase in repair costs 11/23/2021 2 of 3 \\yakima_city\ykfn\Shared\Budget 2021\JM- 2021 QTR 4 Budget Amendment spreadsheet Work in Progressv2 City of Yakima 2021 Budget Amendment 4th Quarter SCHEDULE I From Fund Fund I Account 8 I Name Refuse Operating 471 Reserves Refuse Operating 471 Reserves Refuse Operating 471 Reserves Medical 513 Reserves From Dr (Cr) To Fund Fund I Account I Name $ (63,532.00) 471 4724892 $ (82,651.00) 471 4724893 EQR Repair Services -Parts EQR Repair Services -Tires To Dr (Cr) $ $ 63,532.00 $ 82,651.00 8 Description Ref Increase EQR Repair Labor/Parts/Tires for increase in repair costs Increase EQR Repair Labor/Parts/Tires for increase in repair costs Interfd Chgs-Customer Svc $ (64,850.00) 471 4774994 $ 64,850.00 Increase EQR Repair Labor/Parts/Tires for increase in repair costs $ (500,000.00) 513 1742560 Medical Claims Paid $ 500,000.00 19 Increase in medical claims paid. $ (3,238,394.99) $ 3,238,394.99 $ (33,216,093.99) $ 33,177,055.99 11/23/2021 3 of 3 \\yakima_city\ykfn\Shared\Budget 2021\JM- 2021 QTR 4 Budget Amendment spreadsheet Work in Progressv2 1 ITEM TITLE: SUBMITTED BY: BUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEM ENT Item No. 5.H. For Meeting of: December 14, 2021 Ordinance 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 (Second Reading) Jennifer Ferrer -Santa Ines, Director of Finance and Budget Kimberly Domine, Finance Division Manager Jennifer Morris, Financial Services Officer SUMMARY EXPLANATION: This appropriation for prior year encumbrances is part of the annual budgeting process. Attached is an Ordinance amending the 2021 Budget to provide appropriations for projects or programs that were uncertain and therefore not included at the time of the 2021 Budget adoption. ITEM BUDGETED: NA STRATEGIC PRIORITY: Public Trust and Accountability APPROVED FOR SUBMITTAL BY THE CITY MANAGER RECOMMENDATION: Pass Ordinance ATTACHMENTS: Description CI Ordinance 0 Ordinance Schedule I CI Memo Upload Date 11/23/2021 11/23/2021 11/23/2021 Type Ordinance Backup Material Corer Memo