Loading...
HomeMy WebLinkAbout04/18/2023 06.Q. Ordinance amending the 2023 Budget for the City of Yakima and making appropriations from Unappropriated Fund Balances within various Funds for expenditure during 2023 for various purposes (Second Reading) 1 sAir'i.jik ,„F` �'�11�1 l'cLiii * C-4\ ••6 BUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEMENT Item No. 6.Q. For Meeting of:April 18, 2023 ITEM TITLE: Ordinance amending the 2023 Budget for the City of Yakima and making appropriations from Unappropriated Fund Balances within various Funds for expenditure during 2023 for various purposes (Second Reading) SUBMITTED BY: Jennifer Ferrer-Santa Ines, Director of Finance and Budget* Kimberly Domine, Finance Division Manager Jen Paxton, Financial Services Officer SUMMARY EXPLANATION: This appropriation is an ordinance amending the 2023 Budget to provide appropriations for projects or programs that were unknown or uncertain and therefore not included at the time of the 2023 Budget adoption. ITEM BUDGETED: NA STRATEGIC PRIORITY: Public Trust and Accountability APPROVED FOR SUBMITTAL BY THE CITY MANAGER RECOMMENDATION: Pass the Ordinance. ATTACHMENTS: Description Upload Date Type D Ordinance 3/21/2023 Ordinance 0 Memo 4/14/2023 Cover Memo 0 Schedule 1 3/21/2023 Backup Material 0 2023 Revised budget by fund 3/21/2023 Backup Material 2 ORDINANCE NO. 2023- AN ORDINANCE amending the 2023 Budget for the City of Yakima; and making appropriations from Unappropriated Fund Balances within various funds for expenditure during 2023 for various purposes including 2022 encumbrances as 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 2023 in various amounts and for the purposes mentioned in the attached Schedule; and WHEREAS, at the time of the adoption of the 2023 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 2023, 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 I 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 18'h day of April, 2023. Janice Deccio, Mayor ATTEST: Sonya Clear Tee, City Clerk First Reading: April 4, 2023 Publication Date: Effective Date: 3 o¢Y'.. o -, FINANCE TO: Mayor and City Council FROM: Jennifer Ferrer-Santa Ines, Director of Finance and Budget Kimberly Domine, Finance Division Manager Jen Paxton, Financial Services Officer DATE: April 14, 2023 RE: 2023 Budget Ordinance- 2022 Carryforward This budget ordinance effects course corrections based on new information for the 2023 Budget year that was not known at the time of budget adoption. Budget amendments come before City Council; normally on a quarterly basis, to be transparent and accountable. The budget amendment is a recurring budget process step; staff accumulates information as it occurs and brings the adjustments to council. It 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 2023 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. Item numbers listed match red Ref#'s on attached spreadsheet: New Revenue: 1). General Fund 001 grant from Secretary of State Archives and Records Management Grant: This adjustment increases both revenue and expense in equal and offsetting amounts. $22,218.11 2). ONDS Fund 124 grant from Housing and Urban development for Home American Rescue Plan: this adjustment increases both revenue and expense in equal and offsetting amounts. $1,822,807 3). Streets Capital Fund 346 grant from Transportation Improvement Board Grant for Nob Hill Boulevard Overlay; this adjustment increases both revenue and expense in equal and offsetting amounts. $1,335,000 4). Capital Theatre Capital Fund 322 grant from Department of Commerce; this adjustment increases revenue. $245,000 5). Codes General Fund 001 grant from Department of Commerce CHIPS Grant; this adjustment increases both revenue and expenditures. $325,599.54 4 o¢Y'.. o -, FINANCE 6). Codes General Fund 001 grant from Department of Commerce CAD Grant; this adjustment increases revenue and expenditures. $47,153.06 7). Police General Fund 001 revenue from WAS PC(Washington Association of Sheriffs& Police Chiefs); this adjustment increases revenue and expenditures. $47,153.06 Prior-Year roll forward of 2022 encumbrances: 8). Prior-Year roll-forward of 2022 encumbrances. A large portion of this adjustment is for the Equipment Rental Fund, for prior-year-authorized purchases of vehicles and equipment that have a long purchase lead-time. $1,213,260.23 Offsetting revenue and expense for CDBG and HOME grants of $3,760,725.6 not yet obligated are also carried forward. Offsetting revenue and expense for ARPA grant of$2,530,954.95. All of these expenditures were included in the 2022 budget and as result are revenue- neutral to the 2023 Budget — these simply renew previously-approved expenditure authority. Similarly, General Fund roll-forward of 2022 approved expenditures is $361,961.47. From Fund Balance: The adjustments and corrections to the 2023 budget that are now known that were not known at the time of adoption, are: 9). Increase expenditures in General Fund 001 for City Hall emergency repair of heating and cooling system. $20,000 10). Increase expenditures in Water Operating Fund for Nelson Dam repairs. $43,991 11). Increase expenditures in PFD Fund 174 for transfer out to Capital Theatre Capital Budget 322 for HVAC and scope and scale evaluation. $133,006 12). Increase expenditures in Water Capital Fund 477 for Water WTP Flume repair project. $50,000 13). Increase expenditures in ARPA Fund 180 for Community Partnerships for 5 one-time payments. $500,000 14). Increase expenditures in ARPA Fund 180 for Mental Homeless/Mental Health. $1,500,000 15). Increase expenditures in ARPA Fund 180 for East Side Pool. $1,500,000 16). Increase expenditures in American Rescue Plan Fund 180 for Sewer Investment Mill Site. $500,000 5 FINANCE 17). Increase expenditures in American Rescue Plan Fund 180 for Water Investment Mill Site. $500,000 18). Increase expenditures in American Rescue Plan Fund 180 for YWCA Young Women's Christian Association Domestic Violence Shelter. $2,000,000 19). Increase expenditures in General Fund 001 for Code Book for Codes omitted from the 2023 budget. $7,000 20). Increase expenditures in the Capital Theatre Fund 322 for additional costs for construction project. $3,507 21). Increase expenditures in the Police Capital Fund 333 for additional costs for police vehicle uplifting. $134,850 22). Increase expenditures in Wastewater Construction Funds 476,472, and 478 for Sewer Collection System Projects $10,900,000 23). Increase expenditures in Equipment Rental Capital Fund 552 for police vehicles upfitting costs. $345,481.00 24). Increase expenditures in General Fund 001 $4,400, Water Operating $4,400, Sewer Operating 473 $4,400 and Refuse Operation 471 $4,400 for Civic Spark Fellow. 25). Increase expenditures Wastewater Operating Fund 473 for a transfer out to Wastewater Capital Fund 478. $4,300,000 26). Increase expenditures in 3% Criminal Justice Fund 303 for Police Tasers. $92,500 27). Increase expenditures in 3% Criminal Justice Fund 303 for Municipal Court remodel. $40,000 28). Increase expenditures in 370 Convention Center Capital Fund 370 for $77,000 for new flooring and $29,000 for partitions. $106,000 29). Increase expenditures and revenues in 464 Transit Capital Fund for 2 Transit buses. $1,157,380.44 30). Increase expenditures in 370 Fire Capital Fund for parking feasibility study. $5,490 31). Increase expenditures and revenues in 464 Transit Capital Fund for Transit grant. $209,366 32). Increase revenues in 464 Transit Capital Fund for Department of Transportation Grant omitted from the 2023 Budget. $361,858 6 o �, FINANCE 33). Increase revenues in 462 Transit Operating Fund for Fed Pass WADOT JARC Eburg Grant omitted from the 2023 budget. $3,764,086 Technical Adjustment: 34) House Keeping. Moving the Parking Enforcement department 653 to the Community Service Officer department 308 in General Fund. $97,822.24 This will have a zero impact on General Fund. 35) House Keeping. Moving the Animal Control Department in the Criminal Justice Fund 003 to General Fund 001 Community Service Officer department. Moving 2 Police officers to the Criminal Justice department Fund 003. 36) House Keeping. Increase Workers Compensation rates due to increased volume and cost of claims. This will increase expenditures in General Fund. $383,292.35 Staff expects further 2023 course-correction budget adjustments later in the year, as new information becomes available that is not fully known at this time. City of Yakima 2023 Budget Amendment&PO Encumbrances SCHEDULE! 1st Quarter F1,111-11,1 From Dr(CO _.. To Dr(Cr) # Description Fund I Account* I Name $ I Fund!Account I Name I $ Ref New Revenue-offsetting increases in espenditures and revenues I General Fund 001 8953441 Secretary of State Grant $ 22,218.11 001 1624100 Professional Service $ 22,218.11 1 Secretory of State Archives and Records Management Division Grant ONDS 124 8953313 HOME Grant ARPA $ 1,822,807.00 124 2424820 Neighborhood CI eanup/I mprvmnt $ 1,822,807.00 2 Housirg and Urban Development for Home American Rescue Plan ARP Grant Streets Capital 346 8953449 Transportation Improvement Bd $ 1,335,000.00 346 7156300 Improvements Other Than Bldgs $ 1,335,000.00 3 Transportation Improvement Board Grant for Project 2619 Nobhill Boulevard Overl Capital Theatre Capital 322 8953463 Depart of Commerce $ 245,000.00 322 Reserves $ 245,000.00 4 Depart of Commerce Grant Codes 001 8953457 Dept of Commerce $ 174,845.54 001 2264100 Professional Service $ 174,845.54 5 Departmental Commerce Code CHIPS(Connecting Housing to lnfrastru re Prograrr Codes 001 8953457 Dept of Commerce $ 148,754.00 001 2264100 Professional Service $ 148,754.00 Departmental Commerce Code CHIPS(Connecting Housing to lnfrastru re Prograrr Codes 001 8953457 Dept of Commerce $ 47,153.06 001 2293110 Office And Operatirg Supplies $ 47,153.06 6 Departmental Commerce Code CAD(Community Action days)Grant Police 001 8953772 YPD ILG County $ 51,109.70 001 3194100 Professional Service $ 51,109.70 7 WASPC revenue from legislative change to be used for training $ 3,846,887.41 $ 3,846,887.41 I Carryforward of encumbrance from 2022 prior year budget: I General Fund 001 Reserves $ 53,865.00 001 1624100 Professional Service $ 53,865.00 8 Salary Survey General Fund 001 Reserves $ 25,250.00 001 2164100 Professional Service $ 25,250.00 Permit Fee Study General Fund 001 Reserves $ 1,180.07 001 3053110 Office And Operatirg Supplies $ 1,180.07 Computer Equipment General Fund 001 Reserves $ 17,720.08 001 3053500 Small Tools&Minor Equipment $ 17,720.08 Systems Engineering General Fund 001 Reserves $ 22,847.21 001 3132800 Uniforms And Clothing $ 22,847.21 911 Supply-Uniforms General Fund 001 Reserves $ 12,658.03 001 3133500 Small Tools&Minor Equipment $ 12,658.03 Axon Enterprises General Fund 001 Reserves $ 21,730.86 001 3133506 Audio/Video Capabilities $ 21,730.86 Axon Enterprises General Fund 001 Reserves $ 15,499.65 001 3193110 Office And Operatirg Supplies $ 15,499.65 Ammunition General Fund 001 Reserves $ 25,088.78 001 3193112 Operating S1pplies/Ammunition $ 25,088.78 Ammunition General Fund 001 Reserves $ 14,581.36 001 3194100 Professional Service $ 14,581.36 Axon Enterprises General Fund 001 Reserves $ 294.84 001 3223191 Auto Supplies $ 294.84 Bud Clary Ford/Hyundai General Fund 001 Reserves $ 24,612.63 001 3513510 Non-Capital Computer Equipment $ 24,612.63 Copiers and Computer equipment General Fund 001 Reserves $ 60,148.73 001 3514100 Professional Service $ 60,148.73 Compunet,Critical Insight General Fund 001 Reserves $ 3,731.07 001 3514,400 R&M Contractors $ 3,731.07 Compunet General Fund 001 Reserves $ 5,593.70 001 3516300 Improvements Other Than Bldgs $ 5,593.70 Office NW Solutions General Fund 001 Reserves $ 54,785.14 001 3516460 Data Processing Equipment $ 54,785.14 Compunet,Copiers NW General Fund 001 Reserves $ 2,374.32 001 3523500 Small Tools&Minor Equipment $ 2,374.32 CDW 3%Criminal Justice 003 Reserves $ 116,732.56 003 3016420 Operating Equipment $ 116,732.56 Motorola Solutions-Radios Community Relations 125 Reserves $ 6,842.37 125 1256420 Operating Equipment $ 6,842.37 Sousley Sound-Council Chambers Audio System Upgrade Community Relations 125 Reserves $ 3,127.88 125 1263500 Small Tools&Minor Equipment $ 3,127.88 CD-Camera Council Chambers Streets Operatirg 141 Reserves $ 40,612.50 141 4133112 Operating S1pplies/General $ 40,612.50 Special Asphalt Products-Crack Seal Material Police Grants 152 Reserves $ 19,494.00 152 3094100 Professional Service $ 19,494.00 Insight Public Sector-Flock Camera ARPA 180 8953119 American Rescue Plan(ARPA) $ 65,575.65 180 3016420 Operating Equipment $ 65,575.65 Insight Public Sector-License Plate Reader ARPA 180 8953119 American Rescue Plan(ARPA) $ 2,530,954.95 180 3016430 Cars-Police $ 2,530,954.95 Bud Clary Ford/Hyundai Police Vehicles ARPA 180 8953119 American Rescue Plan(ARPA) $ 2,547,019.16 180 3226400 Machinery And Equipment-Fire $ 2,547,019.16 Cascade Fire Equipment,Bud Clary Fire Vehicles ARPA 180 8953119 American Rescue Plan(ARPA) $ 280,000.00 180 2244100 Professional Service $ 280,000.00 Bank of America Space Study ARPA 180 8953119 American Rescue Plan(ARPA) $ 4,496,448.96 180 Reserves $ 4,496,448.96 America Rescue Plan Revenue 3%Capital Fund 303 Reserves $ 1,854.72 303 3013500 Small Tools&Minor Equipment $ 1,854.72 CDW-Computer Equipment Capital Theatre Capital 322 Reserves $ 64,980.00 322 2706300 Improvements Other Than Bldgs $ 64,980.00 Bruce Mechanical-HVAC Capital Theatre Capital 322 Reserves $ 227,786.67 322 2706500 Construction Projects $ 227,786.67 Pacific NW Theatre Associates-Curtains Police Capital 333 Reserves $ 29,169.47 333 3014100 Professional Service $ 29,169.47 CDW-Compu ter Equipment Police Capital 333 Reserves $ 549,784.21 333 3016430 Cars $ 549,784.21 Bud Clary Ford/Hyundai-Police Vehicles REET 1 342 Reserves $ 279,306.44 342 7146300 Improvements Other Than Bldgs $ 279,306.44 CP Mechanical REET 1 342 Reserves $ 597,274.50 342 7146376 Other Imp Parks $ 597,274.50 Apex Mechanical 3/20/2023 1 of 5 Vyakima_city\ykfn\Shared\Budget 2023-2024\JM-2023 1st Qtr Budget Amendment and PO Encumbrance City of Yakima 2023 Budget Amendment&PO Encumbrances SCHEDULE! 1st Quarter From Dr(Cr) To Dr(Cr) fi Description Fund I Account* I Name $ Fund!Account I Name I $ Ref REET 2 343 Reserves $ 30,200.00 343 7164100 Professional Service $ 30,200.00 TENW REET 2 343 Reserves $ 187,655.26 343 7166300 Improvements Other Than Bldgs $ 187,655.26 HLA Engineering&Land 5arvey Convention Center Capital 370 Reserves $ 40,372.07 370 2794800 R&M/Contractors $ 40,372.07 Action Compaction Services AZ Convention Center Capital 370 Reserves $ 194,940.00 370 2796500 Construction Projects $ 194,940.00 Total Site Services,LLC Airport Operating 421 Reserves $ 1,840.39 421 2813113 Fire Truck Supplies $ 1,840.39 Day Wireless Systems Airport Operating 421 Reserves $ 7,367.97 421 2814800 R&M/Contractors $ 7,367.97 Mascott Equipment Stormwater Capital 441 Reserves $ 8,406.25 441 7464100 Professional Service $ 8,406.25 Advanced Lining Transit Operating 462 Reserves $ 11,970.00 462 4594910 Miscellaneous Expense $ 11,970.00 Salary Survey Transit Capital 464 8953938 Arra Direct Dot Grant $ 3,101,527.89 464 4516470 Buses $ 3,101,527.89 Gillig Transit Buses Transit Capital 464 8953938 Arra Direct Dot Grant $ 361,857.96 464 4676441 D/R Van $ 361,857.96 Schetky Northwest Sales,Transit Dial A Ride Vans Refuse 471 Reserves $ 52,459.90 471 4784100 Professional Service $ 52,459.90 Cascade Engineering Wastewater 472 Reserves $ 43,092.33 472 7394800 R&M/Contractors $ 43,092.33 Sentrimax Centrifuges USA Wastewater 473 Reserves $ 4,489.11 473 7313500 Small Tools&Minor Equipment $ 4,489.11 E3 Solutions Wastewater 473 Reserves $ 15,144.05 473 7314100 Professional Service $ 15,144.05 Salary Survey Water 474 Reserves $ 2,978.25 474 7644800 R&M/Contractors $ 2,978.25 Salary Survey Water 474 Reserves $ 2,538.00 474 7654800 R&M/Contractors $ 2,538.00 Awesome Grass Hydroseeding Water 474 Reserves $ 7,980.00 474 7724100 Professional Service $ 7,980.00 Salary Survey Irrigation 475 Reserves $ 2,992.50 475 7824100 Professional Service $ 2,992.50 Salary Survey Risk Management 515 Reserves $ 59,117.73 515 6694100 Professional Service $ 59,117.73 Knobels Electric Equipment Rental Capital 552 Reserves $ 670,695.74 552 5526430 Cars $ 670,695.74 Bud Clary Ford/Hyundai Equipment Rental Capital 552 Reserves $ 425,428.70 552 5526440 Trucks $ 425,428.70 Bud Clary Ford/Hyundai Equipment Rental Capital 552 Reserves $ 117,135.79 552 5526450 Other Equipment $ 117,135.79 AG Enterprise S1pply Environmental 555 Reserves $ 78,278.19 555 5614812 R&M/Contr-Tiger Oil $ 78,278.19 Haley&Aldrich ONDS 124 8953313 HOME Grant ARPA $ 1,774,104.19 124 2414820 Neighborhood Cleanup/Imprvmnt $ 1,774,104.19 Office of Neighborhood Development Carry Forward 2022 to 2023 ONDS 124 8953117 CARESGrantCDBG $ 180,597.61 124 2414110 Community Svc Program $ 180,597.61 Office of Neighborhood Development Carry Forward 2022 to 2024 ONDS 124 8953102 Cd Block Grant-Prior Year $ 1,191,295.33 124 2414820 Neighborhood Cleanup/I mprvmnt $ 1,191,295.33 Office of Neighborhood Development Carry Forward 2022 to 2025 ONDS 124 8953104 Home Program-Prior Year $ 473,009.47 124 2414820 Neighborhood Cleanup/I mprvmnt $ 473,009.47 Office of Neighborhood Development Carry Forward 2022 to 2026 ONDS 124 8953117 CARESGrantCDBG $ 141,719.00 124 2414130 HBCC Public Services $ 141,719.00 Office of Neighborhood Development Carry Forward 2022 to 2027 $ 21,408,119.19 $ 21,408,119.19 I Increase Budget Expenditures from Reserves I General Fund 001 Reserves $ 20,000.00 001 2243112 Office And Operating Supplies $ 20,000.00 9 City Hall emergency repair of the Heating and Cooling system. Water Operating Fund 474 Reserves $ 43,991.00 474 7654100 Professional Service $ 43,991.00 10 Dam Repairs PFD 174 2730055 Transfer Out $ 110,000.00 322 8950050 Transfer In $ 110,000.00 11 Transfer in from PFD for the HVRC and Scope&Scale Evaluations Capital Theatre Capital 322 Reserves $ 110,000.00 322 2706300 Improvements Other Than Bldgs $ 110,000.00 HVRC project and Scope of work evaluations. Capital Theatre Capital 322 Reserves $ 23,006.00 322 2706300 Improvements Other Than Bldgs $ 23,006.00 HVRC project and Scope of work evaluations. Water Capital Fund 477 Reserves $ 50,000.00 477 7736534 Water System Const 59434 $ 50,000.00 12 AC2601 Water WTP Flume Repair project ARPA 180 8953119 American Rescue Plan(ARPA) $ 500,000.00 180 1024960 Pass Thru Payments $ 500,000.00 13 Community Partnership for S One-Time Grants ARPA 180 8953119 American Rescue Plan(ARPA) $ 1,500,000.00 180 2394100 Professional Service $ 1,500,000.00 14 Mental Homeless/Mental Health ARPA 180 8953119 American Rescue Plan(ARPA) $ 1,500,000.00 180 5436300 Improvements Other Than Bldgs $ 1,500,000.00 15 East Side Pool ARPA 180 8953119 American Rescue Plan(ARPA) $ 500,000.00 180 7386535 Sewer System Const $ 500,000.00 16 For Sewer Investment Mill Site ARPA 180 8953119 American Rescue Plan(ARPA) $ 500,000.00 180 7736534 Water System Const $ 500,000.00 17 For Water Investment Mill Site ARPA 180 8953119 American Rescue Plan(ARPA) $ 2,000,000.00 180 1024100 Professional Service $ 2,000,000.00 18 YWCA Young Women's Christian Association Domestic Violence shelter General Fund 001 Reserves $ 7,000.00 001 2294910 Miscellaneous Expense $ 7,000.00 19 Code Book omitted from the 2022 Bucket Capital Theatre Capital 322 Reserves $ 89.00 322 2706300 Improvements Other Than Bldgs $ 89.00 20 Additional costs for construction project Capital Theatre Capital 322 Reserves $ 3,418.00 322 2706500 Construction Projects $ 3,418.00 Additional costs for construction project Capital Theatre Capital 333 Reserves $ 134,850.00 333 3016420 Cars $ 134,850.00 21 Police Vehicles Upfittirg Costs Wastewater Construction 476 Reserves $ 4,850,000.00 476 7384100 Professional Service $ 4,850,000.00 22 Sewer collections system condition assessment awarded in early 2023 Wastewater Construction 476 Reserves $ 775,000.00 476 7386300 WW Construction Improvements $ 775,000.00 Construction Projects Wastewater Construction 476 Reserves $ 475,000.00 476 7386535 Sewer System Const 59435 $ 475,000.00 Construction Projects Wastewater Facilities 472 Reserves $ 500,000.00 472 7396535 Sewer System Const 59435 $ 500,000.00 Construction Projects Wastewater Capital 478 Reserves $ 4,300,000.00 478 7396535 Sewer System Const 59435 $ 4,300,000.00 Construction Projects Equipment Rental Capital 552 Reserves $ 345,481.00 552 5526430 Cars $ 345,481.00 23 Police Vehicles Upfittirg Costs Water Operating Fund 474 Reserves $ 4,400.00 474 7714100 Professional Service $ 4,400.00 24 Civic Sparks Fellow Wastewater Operating 473 Reserves $ 4,400.00 473 7314100 Professional Service $ 4,400.00 Civic Sparks Fellow Stormwater 441 Reserves $ 4,400.00 441 7464100 Professional Service $ 4,400.00 Civic Sparks Fellow Refuse 471 Reserves $ 4,400.00 471 4784100 Professional Service $ 4,400.00 Civic Sparks Fellow General Fund 001 Reserves $ 4,400.00 001 1024100 Professional Service $ 4,400.00 Civic Sparks Fellow Wastewater Operatirg 473 7250055 Transfer Out $ 4,300,000.00 478 8950050 Transfer In $ 4,300,000.00 25 Transfer from Wastewater Operating to Construction Fund for projects 3%Criminal Justice Capital 303 Reserves $ 92,500.00 303 3013500 Small Tools&Equipment $ 92,500.00 26 Police Tasers 3%Criminal Justice Capital 303 Reserves $ 40,000.00 303 3013500 Small Tools&Equipment $ 40,000.00 27 Municipal Court remodel,desks,chairs,and partitions. Convention Center Capital 370 Reserves $ 106,000.00 370 2794800 R&M/Contractors $ 106,000.00 28 $77,000 new flooring,$29,000 for pardons for Convention Center Transit Operating 464 8953938 Arra Direct Dot Grant $ 1,157,380.44 464 4516470 Buses $ 1,157,380.44 29 Gillig Transit Buses 3/20/2023 2 of 5 Vyakima_city\ykfn\Shared\Budget 2023-2024\JM-20231st Qtr Budget Amendment and PO Encumbrance City of Yakima 2023 Budget Amendment&PO Encumbrances SCHEDULE! 1st Quarter IIMMEN. - m From Dr(Cr) 101 1 To Dr(Cr) # Description Fund I Account# I Name $ Fund!Account I Name I $ Ref Convention Center Capital 370 Reserves $ 5,490.00 370 2794100 R&M/Contractors $ 5,490.00 30 Parking Feasability Sbady Transit Capital 464 Reserves $ 209,366.00 464 4503500 Small Tools&Equipment $ 209,366.00 31 Transit Grant Transit Capital 464 8953448 Department of Transporb3tion Grant $ 361,858.00 464 Reserves $ 361,858.00 32 Depar7nent of Transportation Grant Transit Operating 462 8953323 Fed Pass WADOT JARC Eburg $ 3,764,086.00 462 Reserves $ 3,764,086.00 33 Fed Pass WADOT JARC Eburg Grant $ 28,306,515.44 $ 28,306,515.44 3/20/2023 3 of 5 Vyakima_city\ykfn\Shared\Budget 2023-2024\JM-2023 1st Qt Budget Amendment and PO Encumbrance City of Yakima 2023 BudgetAmendment&PO Encumbrances SCHEDULE! 1st Quarter inPl Fu From Dr(Cr) To Dr(Cr) * Description Fund I Account* I Name $ I Fund lAccclame I $ Ref House Keeping I Parkirg 001 6531110 Salaries-Permanent $ 47,762.28 001 3081110 Salaries-Permanent $ 47,762.28 34 Move Parking Enforcement department to Police Department 308 Parkirg 001 6531140 Deferred Comp $ 482.40 001 3081140 Deferred Comp $ 482.40 Move Parking Enforcement department to Police Department 308 Parking 001 6531200 Overtime $ 500.00 001 3081200 Overtime $ 500.00 Move Parking Enforcement department to Police Department 308 Parking 001 6532100 Social Security $ 3,701.22 001 3082100 Social Security $ 3,701.22 Move Parking Enforcement department to Police Department 308 Parking 001 6532210 Pers $ 5,012.64 001 3082210 Pers $ 5,012.64 Move Parking Enforcement department to Police Department 308 Parkirg 001 6532310 Industrial Insurance $ 2,289.60 001 3082310 Industrial Insurance $ 2,289.60 Move Parking Enforcement department to Police Department 308 Parkirg 001 6532410 Lifelnsurance $ 255.60 001 3082410 Lifelnsurance $ 255.60 Move Parking Enforcement department to Police Department 308 Parkirg 001 6532510 Medical Insurance $ 10,351.80 001 3082510 Medical Insurance $ 10,351.80 Move Parking Enforcement department to Police Department 308 Parking 001 6532610 Dental Insurance $ 754.92 001 3082610 Dental Insurance $ 754.92 Move Parking Enforcement department to Police Department 308 Parking 001 6532700 Unemployment Compensation $ 183.90 001 3082700 Unemployment Compensation $ 183.90 Move Parking Enforcement department to Police Department 308 Parking 001 6532712 Paid Family/Medical leave $ 77.88 001 3082712 Paid Family/Medical leave $ 77.88 Move Parking Enforcement department to Police Department 308 Parkirg 001 6532800 Uniforms And Clothing $ 600.00 001 3082800 Uniforms And Clothing $ 600.00 Move Parking Enforcement department to Police Department 308 Parkirg 001 6533110 Supplies $ 300.00 001 3083110 Supplies $ 300.00 Move Parking Enforcement department to Police Department 308 Parkirg 001 6533200 Fuel $ 4,000.00 001 3083200 Fuel $ 4,000.00 Move Parking Enforcement department to Police Department 308 Parking 001 6534100 Professional Svcs $ 1,600.00 001 3084100 Professional Svcs $ 1,600.00 Move Parking Enforcement department to Police Department 308 Parking 001 6534153 Prof.Svc./Collection CFg'S $ 8,500.00 001 3084153 Prof.Svc./Collection Chg'S $ 8,500.00 Move Parking Enforcement department to Police Department 308 Parkirg 001 6534212 Cellular Telephone $ 1,200.00 001 3084212 Cellular Telephone $ 1,200.00 Move Parking Enforcement department to Police Department 308 Parkirg 001 6534213 Data Communications $ 1,500.00 001 3084213 Data Communications $ 1,500.00 Move Parking Enforcement department to Police Department 308 Parkirg 001 6534220 Postage $ 100.00 001 3084220 Postage $ 100.00 Move Parking Enforcement department to Police Department 308 Parkirg 001 6534300 Transportation $ 1,000.00 001 3084300 Transportation $ 1,000.00 Move Parking Enforcement department to Police Department 308 Parking 001 6534800 R&M/Contactors $ 4,150.00 001 3084,400 R&M/Contractors $ 4,150.00 Move Parking Enforcement department to Police Department 308 Parking 001 6534910 Miscellaneous Expense $ 1,000.00 001 3084910 Miscellaneous Expense $ 1,000.00 Move Parking Enforcement department to Police Department 308 Parking 001 6534995 Equipment Replacement Costs $ 2,500.00 001 3084995 Equipment Replacement Costs $ 2,500.00 Move Parking Enforcement department to Police Department 308 Animal Control 003 2231110 Salaries-Permanent $ 102,690.33 001 3081110 Salaries-Permanent $ 102,690.33 Move Animal Control in Fund 033 to General Fund 308 Animal Control 003 2231140 Deferred Comp $ 1,037.25 001 3081140 Deferred Comp $ 1,037.25 Move Animal Control in Fund 033 to General Fund 309 Animal Control 003 2231200 Overtime $ 455.00 001 3081200 Overtime $ 455.00 Move Animal Control in Fund 033 to General Fund 310 Animal Control 003 2231300 Special Pay $ 50.00 001 3081300 Special Pay $ 50.00 Move Animal Control in Fund 033 to General Fund 311 Animal Control 003 2231410 Employee Year-End Cashout $ 500.00 001 3081410 Employee Year-End Cashout $ 500.00 Move Animal Control in Fund 033 to General Fund 312 Animal Control 003 2232100 Social Security $ 7,859.01 001 3082100 Social Security $ 7,859.01 Move Animal Control in Fund 033 to General Fund 313 3/20/2023 4 of 5 Vyakima_city\ykfn\Shared\Budget 2023-2024\JM-2023 1st Qt Budget Amendment and PO Encumbrance City of Yakima 2023 Budget Amendment&PO Encumbrances SCHEDULE! 1st Quarter 1 n5'l . From Dr(Cr) To Dr(Cr) R Description Fund I AccountU I Name $ I Fund lAccciame I $ Ref Animal Control 003 2232210 Pers $ 10,777.35 001 3082210 Pers $ 10,777.35 Move Animal Control in Fund 033 to General Fund 314 Animal Control 003 2232310 Industrial Insurance $ 4,579.20 001 3082310 Industrial Insurance $ 4,579.20 Move Animal Control in Fund 033 to General Fund 315 Animal Control 003 2232410 Life Insurance $ 511.20 001 3082410 Life Insurance $ 511.20 Move Animal Control in Fund 033 to General Fund 316 Animal Control 003 2232510 Medical Insurance $ 28,867.92 001 3082510 Medical Insurance $ 28,867.92 Move Animal Control in Fund 033 to General Fund 317 Animal Control 003 2232610 Dental Insurance $ 3,173.64 001 3082610 Dental Insurance $ 3,173.64 Move Animal Control in Fund 033 to General Fund 318 Animal Control 003 2232700 Unemployment Compensation $ 394.68 001 3082700 Unemployment Compensation $ 394.68 Move Animal Control in Fund 033 to General Fund 319 Animal Control 003 2232712 Paid Family/Medical leave $ 167.28 001 3082712 Paid Family/Medical leave $ 167.28 Move Animal Control in Fund 033 to General Fund 320 Animal Control 003 2232800 Uniforms And Clothing $ 300.00 001 3082800 Uniforms And Clothing $ 300.00 Move Animal Control in Fund 033 to General Fund 321 Animal Control 003 2233110 Supplies $ 500.00 001 3083110 Supplies $ 500.00 Move Animal Control in Fund 033 to General Fund 322 Animal Control 003 2233200 Fuel $ 4,000.00 001 3083200 Fuel $ 4,000.00 Move Animal Control in Fund 033 to General Fund 323 Animal Control 003 2234210 Telephone $ 150.00 001 3084210 Telephone $ 150.00 Move Animal Control in Fund 033 to General Fund 324 Animal Control 003 2234212 Cellular Telephone $ 700.00 001 3084212 Cellular Telephone $ 700.00 Move Animal Control in Fund 033 to General Fund 325 Animal Control 003 2234213 Data Communications $ 1,920.00 001 3084213 Data Communications $ 1,920.00 Move Animal Control in Fund 033 to General Fund 326 Animal Control 003 2234220 Postage $ 1,000.00 001 3084220 Postage $ 1,000.00 Move Animal Control in Fund 033 to General Fund 327 Animal Control 003 2234800 R&M/Contactors $ 3,661.00 001 3084800 R&M/Contractors $ 3,661.00 Move Animal Control in Fund 033 to General Fund 328 Animal Control 001 2234100 Professional Svcs $ 202,000.00 001 3084100 Professional Svcs $ 202,000.00 Move Animal Control in Fund 033 to General Fund 329 Animal Control 003 2234995 Equipment Replacement Costs $ 2,565.00 001 3084995 Equipment Replacement Costs $ 2,565.00 Move Animal Control in Fund 033 to General Fund 329 Police 001 3131110 Salaries-Permanent $ 171,770.16 003 3011110 Salaries-Permanent $ 171,770.16 35 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Police 001 3131140 Deferred Comp $ 9,764.67 003 3011140 Deferred Comp $ 9,764.67 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Police 001 3132100 Social Security $ 2,634.54 003 3012100 Social Security $ 2,634.54 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Police 001 3132210 Pers $ 9,621.33 003 3012210 Pers $ 9,621.33 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Police 001 3132310 Industrial Insurance $ 8,315.73 003 3012310 Industrial Insurance $ 8,315.73 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Police 001 3132410 Life Insurance $ 766.80 003 3012410 Life Insurance $ 766.80 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Police 001 3132510 Medical Insurance $ 22,723.92 003 3012510 Medical Insurance $ 22,723.92 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Police 001 3132610 Dental Insurance $ 2,361.60 003 3012610 Dental Insurance $ 2,361.60 Move 2 Police Officers from General Fund 001 to 3%Fund 003 Industrial Insurance 514 8956651 Operating Fund Contributions $ 357,406.00 001 3052310 Industrial Insurance $ 18,192.00 36 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3122310 Industrial Insurance $ 37,446.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3132310 Industrial Insurance $ 120,095.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3142310 Industrial Insurance $ 2,036.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3182310 Industrial Insurance $ 863.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3192310 Industrial Insurance $ 7,674.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3222310 Industrial Insurance $ 145,432.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3232310 Industrial Insurance $ 2,267.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3292310 Industrial Insurance $ 5,364.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3312310 Industrial Insurance $ 2,267.00 Increased costs in Workers Comp Industrial Insurance 001 Reserves 001 3222310 Industrial Insurance $ 15,770.00 Increased costs in Workers Comp Industrial Insurance 514 8956908 Workers'Comp.Withholding $ 25,989.00 514 Reserves $ 25,989.00 Increased costs in Workers Comp $ 1,087,034.85 $ 1,087,034.85 $ 54,648,556.89 $ 54,648,556.89 3/20/2023 5 of 5 Vyakima_city\ykfn\Shared\Budget 2023-2024JM-20231st Qtr Budget Amendment and PO Encumbrance 2023 Adopted Budget Revised Quarter 1 Budget Amendment _ A I B C D I E I F G I H I I J K 1 Fund Revenue Expenditures Ending Fund Balance Beginning Fund 2 Balance As of 3/16/23 Adopted Budget Adjustment Revised Adopted Budget Adjustment Revised Fund Blance Percentage 3 General Government Funds: $ 22,898,627.97 $ 104,838,481.20 $ 22,447,611.73 $ 127,286,092.93 $ 111,505,281.13 $ 18,998,739.55 $ 130,504,020.68 $ 19,680,700.22 4 001 General Fund $ 9,557,104.97 $ 67,596,060.00 $ 444,080.41 $ 68,040,140.41 $ 68,809,444.03 $ 1,142,747.99 $ 69,952,192.02 $ 7,645,053.36 10.93% 5 003 .3%Criminal Justice $ 1,457,734.68 $ 3,254,000.00 $ - $ 3,254,000.00 $ 3,573,344.61 $ 168,832.45 $ 3,742,177.06 $ 969,557.62 25.91% 6 612 Firemens Pension $ 1,587,703.98 $ 923,386.00 $ - $ 923,386.00 $ 966,839.53 $ - $ 966,839.53 $ 1,544,250.45 159.72% 7 131 Parks $ 555,067.73 $ 6,162,752.39 $ - $ 6,162,752.39 $ 6,233,727.00 $ - $ 6,233,727.00 $ 484,093.12 7.77% 8 141 Streets $ 1,392,105.17 $ 6,415,663.00 $ - $ 6,415,663.00 $ 6,517,426.00 $ 40,612.50 $ 6,558,038.50 $ 1,249,729.67 19.06% 9 124 Community Dev $ 1,204,804.00 $ 1,760,774.87 $ 5,583,532.60 $ 7,344,307.47 $ 1,775,249.37 $ 5,583,532.60 $ 7,358,781.97 $ 1,190,329.50 16.18% 10 125 Community Relations $ 778,111.09 $ 631,570.00 $ - $ 631,570.00 $ 758,989.70 $ 9,970.25 $ 768,959.95 $ 640,721.14 83.32% 11 136 Clean City Program $ 269,221.57 $ 834,705.00 $ - $ 834,705.00 $ 747,974.68 $ - $ 747,974.68 $ 355,951.89 47.59% 12 144 Cemetery $ 192,236.11 $ 362,500.00 $ - $ 362,500.00 $ 369,746.36 $ - $ 369,746.36 $ 184,989.75 50.03% 13 150 Emergency Services $ 204,612.58 $ 1,777,086.00 $ - $ 1,777,086.00 $ 1,741,141.70 $ - $ 1,741,141.70 $ 240,556.88 13.82% 14 151 Public Safety Comm $ 659,673.42 $ 2,500,307.00 $ - $ 2,500,307.00 $ 2,577,078.34 $ - $ 2,577,078.34 $ 582,902.08 22.62% 15 154 Dispatch $ 516,931.08 $ 1,714,958.92 $ - $ 1,714,958.92 $ 1,768,581.34 $ - $ 1,768,581.34 $ 463,308.66 26.20% 16 153 .3%PS Commun $ 446,474.88 $ 215,000.00 $ - $ 215,000.00 $ 336,433.79 $ - $ 336,433.79 $ 325,041.09 96.61% 17 152 Police Grants $ 826,733.88 $ 180,000.00 $ - $ 180,000.00 $ 226,052.11 $ 19,494.00 $ 245,546.11 $ 761,187.77 310.00% 18 161 DYBID $ 77,989.73 $ 185,750.00 $ - $ 185,750.00 $ 183,861.56 $ - $ 183,861.56 $ 79,878.17 43.44% 19 162 Trolley $ 42,534.66 $ 11,275.00 $ - $ 11,275.00 $ 10,042.00 $ - $ 10,042.00 $ 43,767.66 435.85% 20 163 Front St PBIA $ 8,013.35 $ 3,700.00 $ - $ 3,700.00 $ 3,700.00 $ - $ 3,700.00 $ 8,013.35 216.58% 21 170 Tourism Promo $ 716,785.14 $ 2,128,500.00 $ - $ 2,128,500.00 $ 1,986,398.40 $ - $ 1,986,398.40 $ 858,886.74 43.24% 22 171 Capitol Theatre $ 102,724.64 $ 455,244.36 $ - $ 455,244.36 $ 447,318.99 $ - $ 447,318.99 $ 110,650.01 24.74% 23 172 Pub Fac District $ 1,204,762.17 $ 1,115,600.00 $ - $ 1,115,600.00 $ 1,516,095.61 $ - $ 1,516,095.61 $ 804,266.56 53.05% 24 173 TPA $ 143,220.19 $ 1,350,400.00 $ - $ 1,350,400.00 $ 1,353,521.56 $ - $ 1,353,521.56 $ 140,098.63 10.35% 25 174 CapTh PFD $ 645,615.94 $ 836,258.00 $ - $ 836,258.00 $ 683,383.61 $ 110,000.00 $ 793,383.61 $ 688,490.33 86.78% 26 180 American Rescue Plan $ 67,700.00 $ - $ 16,419,998.72 $ 16,419,998.72 $ 4,496,448.96 $ 11,923,549.76 $ 16,419,998.72 $ 67,700.00 0.41% 27 272 Cony Ctr PFD $ 223,140.92 $ 1,404,577.00 $ - $ 1,404,577.00 $ 1,404,068.22 $ - $ 1,404,068.22 $ 223,649.70 15.93% 28 281 GO Bonds $ 17,626.09 $ 3,018,413.66 $ - $ 3,018,413.66 $ 3,018,413.66 $ - $ 3,018,413.66 $ 17,626.09 0.58% 29 Capital Project Funds: $ 17,531,060.15 I $ 18,435,284.25 $ 3,267,000.00 $ 21,702,284.25 $ 23,098,236.32 $ 5,630,676.34 $ 28,728,912.66 $ 10,504,431.74 30 321 CBD Cap Impr $ 55,023.93 $ - $ - $ - $ - $ - $ - $ 55,023.93 #DIV/0l 31 322 CapTh Constr $ 86,976.64 $ 60,000.00 $ 355,000.00 $ 415,000.00 $ 60,000.00 $ 429,279.67 $ 489,279.67 $ 12,696.97 2.60% 32 323 YRDA $ 330,541.54 $ 1,500,000.00 $ - $ 1,500,000.00 $ 1,362,027.19 $ - $ 1,362,027.19 $ 468,514.35 34.40% 33 331 Parks Capital $ 12,181.43 $ 151,212.00 $ 1,000,000.00 $ 1,151,212.00 $ 159,449.10 $ 1,000,000.00 $ 1,159,449.10 $ 3,944.33 0.34% 34 332 Fire Capital $ 510,237.47 $ 163,000.00 $ - $ 163,000.00 $ 82,161.71 $ - $ 82,161.71 $ 591,075.76 719.41% 35 333 Law&Justice Cap $ 854,989.54 $ 274,227.41 $ - $ 274,227.41 $ 3,051.27 $ 713,803.68 $ 716,854.95 $ 412,362.00 57.52% 36 303 .3%L&J Cap $ 575,776.36 $ 120,000.00 $ - $ 120,000.00 $ 120,000.00 $ 134,354.72 $ 254,354.72 $ 441,421.64 173.55% 37 342 Reet1 $ 4,323,052.45 $ 1,684,447.84 $ - $ 1,684,447.84 $ 3,776,635.78 $ 876,580.94 $ 4,653,216.72 $ 1,354,283.57 29.10% 38 343 Reet2 $ 1,680,549.47 $ 1,600,000.00 $ - $ 1,600,000.00 $ 1,879,395.50 $ 217,855.26 $ 2,097,250.76 $ 1,183,298.71 56.42% 39 344 TBD $ 4,281,860.20 $ 1,786,000.00 $ - $ 1,786,000.00 $ 4,745,036.72 $ - $ 4,745,036.72 $ 1,322,823.48 27.88% 40 346 Streets Capital $ 2,732,644.03 $ 10,303,897.00 $ 1,912,000.00 $ 12,215,897.00 $ 9,862,559.22 $ 1,912,000.00 $ 11,774,559.22 $ 3,173,981.81 26.96% 41 370 Cony Ctr Capital $ 1,758,805.22 $ 792,500.00 $ - $ 792,500.00 $ 942,919.83 $ 346,802.07 $ 1,289,721.90 $ 1,261,583.32 97.82% 42 392 Cap Impr Reserve $ 328,421.87 $ - $ - $ - $ 105,000.00 $ - $ 105,000.00 $ 223,421.87 212.78% 2023 Adopted Budget Revised Quarter 1 Budget Amendment _ A l B C D I E I F G I H I I J K 1 Fund Revenue Expenditures Ending Fund Balance Beginning Fund 2 Balance As of 3/16/23 Adopted Budget Adjustment Revised Adopted Budget Adjustment Revised Fund Blance Percentage 3 General Government Funds: $ 22,898,627.97 $ 104,838,481.20 $ 22,447,611.73 $ 127,286,092.93 $ 111,505,281.13 $ 18,998,739.55 $ 130,504,020.68 $ 19,680,700.22 43 Enterprise Funds: $ 78,567,959.26 $ 94,585,171.39 $13,046,710.29 $107,631,881.68 $ 99,004,718.94 $20,302,982.04 $119,307,700.98 $ 66,892,139.96 44 421 Airport Operations $ 1,362,960.26 $ 1,934,333.00 5 - 5 1,934,333.00 $ 1,963,443.16 5 9,208.36 5 1,972,651.52 $ 1,324,641.74 67.15% 45 422 Airport Capital $ 338,815.93 $ 4,105,060.00 $ - $ 4,105,060.00 $ 4,058,533.71 $ - $ 4,058,533.71 $ 385,342.22 9.49% 46 441 StormwaterOps $ 1,332,793.41 $ 4,126,410.00 $ - $ 4,126,410.00 $ 3,830,963.31 $ 12,806.25 $ 3,843,769.56 $ 1,615,433.85 42.03% 47 442 Stormwater Cap $ 5,433,593.72 $ 859,802.46 $ - $ 859,802.46 $ 4,020,553.68 $ - $ 4,020,553.68 $ 2,272,842.50 56.53% 48 462 Transit $ 11,616,412.98 $ 10,653,832.00 $ - $ 10,653,832.00 $ 10,700,373.15 $ 11,970.00 $ 10,712,343.15 $ 11,557,901.83 107.89% 49 464 Transit Capital $ 3,492,381.81 $ 1,766,976.32 $ 8,746,710.29 $ 10,513,686.61 $ 511,625.00 $ 4,830,132.29 $ 5,341,757.29 $ 8,664,311.13 162.20% 50 471 Refuse $ 4,996,715.79 $ 9,251,365.45 $ - $ 9,251,365.45 $ 9,310,586.71 5 56,859.90 $ 9,367,446.61 $ 4,880,634.63 52.10% 51 472 WW Cap Fac $ 5,596,995.24 $ 1,000,000.00 $ - $ 1,000,000.00 $ 4,583,617.51 $ 543,092.33 $ 5,126,709.84 $ 1,470,285.40 28.68% 52 473 WW Operating $ 13,886,605.60 $ 24,388,283.00 $ - $ 24,388,283.00 $ 25,180,729.15 5 4,324,033.16 $ 29,504,762.31 $ 8,770,126.29 29.72% 53 474 Water Operating $ 9,099,871.45 $ 13,495,704.25 $ - $ 13,495,704.25 $ 13,110,368.22 $ 61,887.25 $ 13,172,255.47 $ 9,423,320.23 71.54% 54 475 Irrigation Operating $ 1,548,091.51 $ 2,102,600.00 $ - $ 2,102,600.00 $ 2,407,467.33 $ 2,992.50 $ 2,410,459.83 $ 1,240,231.68 51.45% 55 476 WW Constr $ 10,438,016.93 $ 3,209,802.46 $ - $ 3,209,802.46 $ 4,020,815.12 $ 6,100,000.00 $ 10,120,815.12 $ 3,527,004.27 34.85% 56 477 Water Capital $ 1,887,610.64 $ 2,909,802.45 $ - 5 2,909,802.45 $ 2,701,259.69 $ 50,000.00 $ 2,751,259.69 $ 2,046,153.40 74.37% 57 478 WW Facilities $ 5,777,291.03 $ 1,000,000.00 $ 4,300,000.00 $ 5,300,000.00 $ 5,067,749.67 $ 4,300,000.00 $ 9,367,749.67 $ 1,709,541.36 18.25% 58 479 Irrigation Capital $ (1,522,464.36) $ 11,957,000.00 $ - $ 11,957,000.00 $ 5,712,433.53 $ - $ 5,712,433.53 $ 4,722,102.11 82.66% 59 488 WW Rev Bond $ 346,102.86 $ 382,800.00 $ - $ 382,800.00 $ 382,800.00 $ - $ 382,800.00 $ 346,102.86 90.41% 60 491 Irrig Rev Bond $ 213,053.63 $ 276,600.00 $ - $ 276,600.00 $ 276,600.00 $ - $ 276,600.00 $ 213,053.63 77.03% 61 493 WW Rev Bond $ 2,723,110.83 $ 1,164,800.00 $ - $ 1,164,800.00 $ 1,164,800.00 $ - $ 1,164,800.00 $ 2,723,110.83 233.78% 62 Internal Service Funds: $ 17,814,554.27 $ 33,654,885.01 $ 383,395.00 $ 34,038,280.01 $ 35,621,008.66 $ 1,696,137.15 $ 37,317,145.81 $ 14,535,688.47 63 512 Unemploy Reserve $ 439,197.26 $ 247,995.14 $ - $ 247,995.14 $ 234,542.37 $ - $ 234,542.37 $ 452,650.03 192.99% 64 513 Health Reserve $ 4,108,272.46 $ 15,562,634.88 $ - $ 15,562,634.88 $ 14,728,925.40 $ - $ 14,728,925.40 $ 4,941,981.94 33.55% 65 514 Workers Comp Res $ 68,539.27 $ 2,023,416.36 $ 383,395.00 $ 2,406,811.36 $ 2,241,785.23 $ - $ 2,241,785.23 $ 233,565.40 10.42% 66 515 Risk Mgmt Reserve $ 6,708,302.51 $ 5,438,457.51 $ - $ 5,438,457.51 $ 6,418,703.86 $ 59,117.73 $ 6,477,821.59 $ 5,668,938.43 87.51% 67 516 Wellness $ 187,450.62 $ 75,000.00 $ - $ 75,000.00 $ 66,900.00 $ - $ 66,900.00 $ 195,550.62 292.30% 68 551 Equipment Rental $ (232,326.06) $ 3,554,867.08 $ - $ 3,554,867.08 $ 3,556,797.28 $ - $ 3,556,797.28 $ (234,256.26) -6.59% 69 552 Replacement Reserve $ 5,082,346.14 $ 2,472,447.00 $ - $ 2,472,447.00 $ 3,579,500.00 $ 1,558,741.23 $ 5,138,241.23 $ 2,416,551.91 47.03% 70 555 Environmental $ 289,858.12 $ 422,100.00 $ - $ 422,100.00 $ 491,617.23 $ 78,278.19 $ 569,895.42 $ 142,062.70 24.93% 71 560 PW Admin $ 761,410.65 $ 1,433,450.00 $ - $ 1,433,450.00 $ 1,877,720.25 $ - $ 1,877,720.25 $ 317,140.40 16.89% 72 581 CustomerSVC $ 401,503.30 $ 2,424,517.04 $ - $ 2,424,517.04 $ 2,424,517.04 $ - $ 2,424,517.04 $ 401,503.30 16.56% 73 Fiduciary Funds: $ 2,136,404.02 $ 590,552.49 $ - $ 590,552.49 $ 590,552.49 $ - $ 590,552.49 $ 2,136,404.02 74 632 Vakcorps $ 1,099,534.53 $ 578,552.49 $ - $ 578,552.49 $ 578,552.49 $ - $ 578,552.49 $ 1,099,534.53 190.05% 75 633 Custodial Fund $ 307,760.90 $ - $ - $ - $ - $ - $ - $ 307,760.90 76 710 Cemetery Trust $ 729,108.59 $ 12,000.00 $ - $ 12,000.00 $ 12,000.00 $ - $ 12,000.00 $ 729,108.59 6075.90% 77 Grand Total $ 138,948,605.67 $ 252,104,374.34 $ 39,144,717.02 $ 291,249,091.36 $ 269,819,797.54 $ 46,628,535.08 $ 316,448,332.62 $ 113,749,364.41 35.95% 78 $ 113,749,364.41 79 $ -