Loading...
HomeMy WebLinkAbout20223526.tiffORDINANCE NO. 258-B IN THE MATTER OF A SUPPLEMENTAL BUDGET APPROPRIATION FOR THE YEAR 2022 BE IT ORDAINED BY THE BOARD OF COUNTY COMMISSIONERS OF THE COUNTY OF WELD, STATE OF COLORADO: WHEREAS, the Board of County Commissioners of the County of Weld, State of Colorado, pursuant to Colorado statute and the Weld County Home Rule Charter, is vested with the authority of administering the affairs of Weld County, Colorado, and WHEREAS, Section 29-1-111, C.R.S., provides that if during the fiscal year the governing board deems it necessary, in view of the needs of the various offices or departments, it may transfer budgeted and appropriated monies from one or more spending agencies in one fund to one or more spending agencies in another fund and/or transfer budgeted appropriated monies between spending agencies within a fund, and WHEREAS, Section 29-1-111, C.R.S., provides that if during the fiscal year the governing body or any spending agency received unanticipated revenue or revenues not assured at the time of the adoption of the budget from any source other than the local government's property tax mill levy, the governing board of the local government may authorize the expenditure of these unanticipated or unassured funds by enacting a supplementary budget and appropriation, and WHEREAS, the Board of County Commissioners of Weld County has been advised that supplemental budget appropriations, in accordance with the above, need to be made in fiscal year 2022 in various County funds, as more fully set forth in the Exhibits attached hereto and incorporated herein by reference, and WHEREAS, this is an emergency caused by a contingency which would not have been reasonably foreseen at the time of the adoption of the 2022 Budget, and WHEREAS, by Section 29-3-112, C.R.S., the governing board of a county does, in an emergency situation, have authority for the expenditure of funds in excess of said budget, by Ordinance duly adopted by two-thirds of the vote of the governing body; however, Section 3-14(6) of the Weld County Home Rule Charter requires any ordinance which is declared therein to be an emergency ordinance to be enacted by four -fifths vote of the Board. NOW, THEREFORE, BE IT ORDAINED, by the Board of County Commissioners of the County of Weld, State of Colorado, that the supplemental budget appropriations for fiscal year 2022 in various County funds, as more fully set forth in the attached Exhibits, which were made necessary by an emergency caused by a contingency which could not have been reasonably foreseen at the time of the adoption of the 2022 Budget be, and hereby are, approved. 4876028 Pages: 1 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Koppes, Clerk and Recorder, Weld County , CO VIIIINF.rCIIthakil'tivIVIIVILfIMPilkl1iAEl Bill CC:CTS(E&/cH1CA(e8/ki4 FI(RR/Se), gc-r(cP/c0) O1/13/23 2022-3526 ORD258-B RE: ORDINANCE #258-B, SUPPLEMENTAL BUDGET APPROPRIATION FOR YEAR 2022 PAGE 2 BE IT FURTHER ORDAINED by the Board that an emergency exists which requires that Supplemental Budget Appropriation Ordinance No. 258-B be, and hereby is, declared to be an emergency ordinance under the provision of Section 3-14 of the Weld County Home Rule Charter. BE IT FURTHER ORDAINED by the Board, if any section, subsection, paragraph, sentence, clause, or phrase of this Ordinance is for any reason held or decided to be unconstitutional, such decision shall not affect the validity of the remaining portions hereof. The Board of County Commissioners hereby declares that it would have enacted this Ordinance in each and every section, subsection, paragraph, sentence, clause, and phrase thereof irrespective of the fact that any one or more sections, subsections, paragraphs, sentences, clauses, or phrases might be declared to be unconstitutional or invalid. The above and foregoing Ordinance Number 258-B was, on motion duly made and seconded, adopted by the following vote on the 19th day of December, A.D., 2022. BOARD OF COUNTY COMMISSIONERS WELD OUNTY, COLORADO ATTEST: ddt/14,0 G. vC11�►•� Weld County Clerk to the Board Coun y ttorney Date of signature: 01 /03/2 ScottK. James, Chair Published: December 9, 2022, in the Greeley Tribune Read and Approved: December 19, 2022 Published: December 23, 2022, in the Greeley Tribune Effective: December 19, 2022 4876028 Pages: 2 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Koppel, Clark and Recorder, Wald County , CO 2022-3526 ORD258-B VIII IN FJC: 114141 E 0571fir "III EXHIBIT A - GENERAL FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT DEBIT CREDIT 1000 10100 6340 $ 6,100 BOCC Memberships increase 1000 10100 6112 $ 13,000 Reallocation of salaries 1000 10150 6112 $ 3,100 Reallocation of salaries 1000 10200 6227 $ 25,500 C0RA Public Records Software 1000 10200 6372 $ 260,000 Increased legal services 1000 10200 6379 $ 100,000 County Attorney Professional Services 1000 10300 6112 $ 15,500 Reallocation of salaries 1000 10400 6112 $ 9,200 Reallocation of salaries 1000 11100 6112 $ 19,000 Reallocation of salaries 1000 12100 6227 $ 10,000 Increase for software maintenance expenses 1000 12100 6379 $ 200,000 Contract Service for Investment Management 1000 13100 4336 $ 150,000 Revenue increase from Oil and Gas audit 1000 13100 6379 $ 150,000 Martindale contract to audit Oil and Gas 1000 14100 6112 $ 350 Reallocation of salaries 1000 15100 6225 $ 10,000 Software maintenance agreement increase 1000 15200 6112 $ 4,800 Reallocation of salaries 1000 15300 6396 $ 4,000 Training and conference expenses 1000 16100 6112 $ 60,000 Reallocation of salaries 1000 16300 6220 $ 300 Supplies for new purchasing agent 1000 16400 6350 $ 15,000 Advertising expenses increased 1000 17100 6225 $ 5,000 Software maintenance agreement increase 1000 17200 6570 $ 8,000 Increase of miscellaneous supplies for grounds 1000 17300 6220 $ 800,000 Reallocation of computer hardware & software 1000 17300 6379 $ 160,000 Reallocation of computer hardware & software 1000 17300 6570 $ 400,000 Reallocation of computer hardware & software 1000 17300 6954 $ 385,000 Reallocation of computer hardware & software 1000 17300 6956 $ 175,000 Reallocation of computer hardware & software 1000 17600 6112 $ 7,400 Reallocation of salaries 1000 17600 6220 $ 12,000 Purchasing items due to supply chain issues 1000 17600 6250 $ 12,000 Increase cost of goods sold 1000 17600 6952 $ 19,000 Purchase of new envelope printer 1000 21110 6112 $ 10,300 Reallocation of salaries 1000 21120 4340 $ 241,000 Body Worn Camera Grant award 1000 21120 6952 $ 241,000 BWC expenses from grant 1000 21140 6112 $ 1,200 Reallocation of salaries 1000 21150 6112 $ 76,000 Reallocation of salaries 1000 21160 6112 $ 5,400 Reallocation of salaries 1000 21200 6112 $ 385,600 Reallocation of salaries 1000 21200 63841 $ 150,000 Vehicle repair increase far Patrol 1000 21200 63842 $ 100,000 Vehicle fuel increase for Patrol 1000 21205 6112 $ 24,000 Reallocation of salaries 1000 21205 4336 $ 3,300 Reimbursement revenue increase 1000 21205 4340 $ 62,000 Grant revenue for Investigations Equipment 1000 21205 6952 $ 60,000 Equipment purchased by grant 1000 21230 6112 $ 5,600 Reallocation of salaries 1000 21230 6373 $ 23,600 Humane Society contract increase 1000 21230 63842 $ 30,000 Fuel increase for Ordinance Enforcement 1000 21260 6112 $ 6,000 Reallocation of salaries 1000 21300 4340 $ 6,000 Grant income higher than anticipated 1000 24200 6112 $ 8,000 Reallocation of salaries 1000 24410 4320 $ 528,000 Grant increase for SCARP times 2 years 1000 24410 6379 $ 140,00.0 1BI grant assistance and inmate food costs 1000 24420 6112 $ 212,500 Reallocation of salaries /.09 4876028 Pages: 3 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Kopp., Clark and Recorder, Weld County , CO ILO FAMMOICIIIICII7PililliNifiAli %A Yoh "Ill aca.2. - 35a4 046252?- CONTINUED - GENERAL FUND PAGE 2 SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT DEBIT CREDIT 1000 25100 4730 $ 22,500 Increase revenue for building inspection fees 1000 26100 63842 $ 30,000 Increase fuel for actual use 1000 26100 6710 $ 16,000 Incentive payments for weed control 1000 56140 6710 $ 75,000 Reduction of unused awarded funds 1000 90100 4364 $ 405,000 Increase revenue from Dacono URA 1000 90100 4680 $ 17,000 Increase miscelaneous revenues 1000 90100 6112 $ 157,000 Non -departmental salaries and benefits 1000 90100 6956 $ 9,016,679 ERP contract approval 1000 96200 6112 $ 9,600 Reallocation of salaries 1000 3110 S 9,887,929 FROM Fund balance TOTAL GENERAL FUND $ 12,497,729 $ 12,497,729 4876028 Pages: 4 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Koppea, Clerk and Recorder, Weld County , CO ft EXHIBIT B - PUBLIC WORKS FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT PROJECT DEBIT CREDIT 2000 30100 6112 300 $ 77,700 Reallocation of salaries 2000 32100 6112 300 $ 35,800 Reallocation of salaries 2000 32100 63842 300 $ 700,000 Increase fuel for actual needs 2000 32200 63842 300 $ 1,000,000 Increase fuel for actual needs 2000 32400 6112 300 $ 12,000 Reallocation of salaries 2000 90100 4221 300 $ 300,000 Increase in Permit and ROW revenue 2000 90100 4680 300 $ 1,800,000 Increase inlGA revenue 2000 90100 4640 300 $ 3,350,000 Increase in Oil and Gas revenues 2000 3110 $ 3,624,500 To Fund Balance TOTAL PUBLIC WORKS FUND $ 5,450,000 $ 5,450,000 EXHIBIT C - HEALTH FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT PROGRAM DEBIT CREDIT 2526 41210 4340 400 $ 176,354 HDCGP Grant Revenue 2526 41210 6112 400 $76,232 Grant expense 2526 41210 6138 400 $11,677 Grant expense 2526 41210 6142 400 $11,042 Grant expense 2526 41210 6146 400 $1,077 Grant expense 2526 41210 6210 400 $48 Grant expense 2526 41210 6225 400 $20 Grant expense 2526 41210 6320 400 $71 Grant expense 2526 41210 6330 400 $9 Grant expense 2526 41210 6335 400 $73 Grant expense 2526 41210 6340 400 $1,489 Grant expense 2526 41210 6367 400 $335 Grant expense 2526 41210 6373 400 $62,623 Grant expense 2526 41210 6378 400 $2,760 Grant expense 2526 41210 6392 400 $100 Grant expense 2526 41210 6394 400 $115 Grant expense 2526 41210 6400 400 $212 Grant expense 2526 41210 6550 400 $8,471 Grant expense TOTAL HEALTH FUND 176,354 176,354 4876028 Pages: 5 of 10 01/09/2023 01:22 PM R F..:$0.00 Carly Koppel, Clark and Recorder, Wald County , CO VIII 1 �1��rI1'�I► I�W'�����I�iPF t►1� «�� 111 II 1 Exhibit D - Social Services Fund Dec 2022 Supplemental.xlsx EXHIBIT D SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B Department Human Services (Social Services Fund) BUDGET LEDGER INCREASE EXPENSE ACCOUNT CODE DECREASE REVENUE FUN,ryD DEPT. ACCOUNT PROG DEBIT r t4f �ui`t�61ie 2100 42110 2100 42110 6112 400 $ 660,000.00 4336 400 2100 42115 6112 400 $ 230,000.00 2100 42115 6359 400 $ 51,700.00 2100 42115 4336 400 2100 42365 6379 400 $ 560,800.00 2100 42365 4336 400 2100 42370 6112 400 $ 40,000.00 2100 42370 4336 400 2100 42380 6112 400 $ 79,300.00 2100 42380 4336 400 2100 42410 6112 400 $ 700,000.00 2100 42410 4336 400 2100 42415 6112 400 $ 125,000.00 2100 42415 6531 400 $ 100,000.00 2100 42415 4336 400 2100 42450 6110 400 $ 94,000.00 2100 42450 4336 400 2100 42610 6359 400 $ 73,000.00 2100 42610 4336 400 2100 88899 6112 ERAF2A $ 570,000.00 2100 88899 6745 ERAF2 $ 9,380,000.00 2100 88899 4320 ERAF2 DECREASE EXPENSE INCREASE REVENUE 660,000.00 281,700.00 560,800.00 40,000.00 79,300.00 700,000.00 225,000.00 94,000.00 73,000.00 9,950,000.00 12, 663, 800.00 12, 663, 800.00 4876028 Pages: 6 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Kopper, Clark and Recorder, Wald County , CO REASON Esfafirpde fer'�frVC �klttg`®ttpensss._ ' iti ar�t� P'. Various Increased Expenditures with accompanying reimbursement sources, including Medicaid Incentive Funding, SNAP ARPA Funding, and SNAP Incentive Furvding More active than anticipated Employment First program, addition of Behavioral Health Grant and Colorado Community Response programs IRe-implementation of the TANF Summer Youth program and Increased Expenditures resulting from passage of HB 22-1259, which increased monthly Basic Cash Assistance payments by 10% (Addition of the AND Navigator Program Unanticipated shift in Random Moment Sample distribution of pooled costs to the Old Age Pension program Lower than anticipated vacancy savings in the Child Welfare division and the addition of three positions added through approval of amid -year request Funding shift for several positions previously charged to other grants Creation and extension of Elder Justice Act funding to provide additional services through the Adult Protection Services program and associated oversight Funding made available for expansion of the outreach component of the Low -Income Energy Assistance Program (LEAP), services provided through a contract with United Way of Weld County Addition of Emergency Rental Assistance (I and II) program Page 1 of 1 VIII tI0.1411111 Exhibit E - Human Services Fund Dec 2022 Supplemental.xlsx EXHIBIT E SUPPLEMENTAL APPROPRIATION ORDINANCE 258- B Department Human Services (Human Services Fund) BUDGET LEDGER INCREASE EXPENSE ACCOUNT CODE DECREASE REVENUE 2625 61480 2625 61490 2625 61510 2625 61480 2625 61510 2625 61515 2625 61480 2625 61490 2625 61510 2625 61515 ACCOUNT !R°G2,, 6112 5401 $ 78,300.00 6112 5401 $ 101,100.00 6112 5401 $ 520,600.00 6340 5405 $ 70,000.00 6410 5608 $ 850,000.00 6373 540 $ 1,080,000.00 4336 520 4336 520 4336 520 4336 520 2625 61400 6112 5401 $ 40,000.00 2625 61400 6410 5608 $ 200,000.00 2625 61400 4320 520 2625 61450 6112 5401 $ 25,000.00 2625 61451 6112 5401 $ 35,000.00 2625 61450 4320 520 2625 61451 4320 520 2625 61420 6112 5401 $ 180,000.00 2625 61420 4320 540 2650 61700 6112 5501 $ 88,000.00 2650 61700 4320 520 2650 61720 6371 5606 $ 80,000.00 2650 61720 4320 520 2650 61750 6112 5401 $ 74,000.00 2650 61750 6373 540 $ 342,000.00 2650 61750 4320 520 DECREASE EXPENSE INCREASE REVENUE 148,300.00 101,100.00 1,370,600.00 1,080,000.00 240,000.00 25,000.00 35,000.00 180,000.00 88,000.00 80,000.00 416,000.00 4876028 Pages: 7 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Kopp.., Clerk and Recorder, Weld County , CO �urdl��I, PAPIC IIIAMPhifin III III RE aM le" Addition of Re-skilling, Up-skilling, New-skilling (RUN) Grant and WIOA Innovations Grant W IOA Funds shifted from Dislocated Worker program to Adult Program Timing shift of expenditure patterns for Youth programs Expansion of Recovery Colorado and Colorao Responds grants Timing shift of expenditure patterns between Federal Admin and State Admin Congregate Meal program ramping backup after COVID slow -down Page 1 of 2 Exhibit E - Human Services Fund Dec 2022 Supplemental.xlsx SUPPLEMENTAL APPROPRIATION ORDINANCE 258- B Department Human Services (Human Services Fund) BUDGET LEDGER INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT PRDEBIT CREDIT 2650 1fa.51 6373 5403 $ 32,000.00 2650 61755 6373 5403 $ 128,000.00 2650 61751 4314 520 32,000.0D 2650 61755 4320 520 128,000.00 2650 61785 6112 5401 $ 9,800.00 2650 61800 6245 5406 $ 14,000.00 2650 61785 4320 520 2650 61800 4320 520 2650 61840 6112 5401 $ 60,000.00 2650 61850 6112 5401 $ 60,000.00 2650 61840 4340 520 2650 61850 4340 520 2650 61940 6112 5401 $ 19,000.00 2650 61945 63596 5606 $ 103,800.00 2650 61940 4320 520 2650 61945 4320 520 9,800.00 14,000.00 60,000.00 60,000.00 19,000.00 103,800.00 4878028 Pages: 8 of 10 01/09/2023 01:22 PM R Fs.:$0.00 Carly Koppel, Clerk and r,County fa lkitilikh 11111 REASON Home -Delivered Meal program ramping back up after COVID slow -down Addition of ADRC CARES Act Funding to existing Funding source Additional funding provided under State Ombudsman and State Information 8; Referral programs Expansion of O. Part E - Caregiver and Respite programs Page 2 oft EXHIBIT D- SOCIAL SERVICES FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B See attached EXHIBIT E - HUMAN SERVICES FUND I SUPPLEMENTAL APPROPRIATION I ORDINANCE 258-B See attached EXHIBIT F - SOLID WASTE FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT DEBIT CREDIT 2700 90200 4410 $ 400,000 Increase revenue 2700 3110 $ 400,000 To Fund Balance TOTAL SOLID WASTE FUND 400,000 400,000 EXHIBIT G - FLEET SERVICES FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT DEBIT CREDIT 6000 96300 4410 $ 1,300,000 Increase revenue 6000 96300 6250 $ 1,300,000 Increase Cost of Goods Sold TOTAL FLEET SERVICES FUND 1,300,000 1,300,000 4876028 Pages: 9 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Koppel, Clerk and Recorder, Weld County , CO IIIII rdr3FhtginIbler010116,1I0IGINCIMiltitik III III EXHIBIT H - HEALTH INSURANCE FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT DEBIT CREDIT 6200 93100 4680 $ 2,500,000 Increase in employee contributions to health care 6200 93100 6340 $325,000 Reallocation of expenses 6200 93100 6373 $766,300 Reallocation of expenses 6200 93100 6510 $75,000 Increase of insurance 6200 93100 6733 $3,000,000 Increase in medical claims 6200 93400 6359 $ 325,000 Reallocation of expenses 6200 93400 6373 $ 766,300 Reallocation of expenses 6200 31100 $ 575,000 FROM Fund Balance TOTAL HEALTH INSURANCE FUND 4,166,300 4,166,300 EXHIBIT I - LIABILITY INSURANCE FUND SUPPLEMENTAL APPROPRIATION ORDINANCE 258-B INCREASE EXPENSE DECREASE EXPENSE ACCOUNT CODE DECREASE REVENUE INCREASE REVENUE FUND DEPT. ACCOUNT DEBIT CREDIT 6300 93200 6510 $ 671,000 Increase in Insurance 6300 93200 6712 $ 1,100,000 Decrease in losses for 2022 6300 3110 $429,000 TO Fund Balance TOTAL LIABILITY INSURANCE FUND 1,100,000 1,100,000 4876028 Pages: 10 of 10 01/09/2023 01:22 PM R Fee:$0.00 Carly Koppel, Clerk and Recorder, Weld County CO liii NFOrli tliNil c til��NIa C0u4%ii v i SUPPLEMENTAL APPROPRIATION REASONS GENERAL FUND: • Reallocate software and computer hardware budgets • Legal Fees • Martindale Oil and Gas Audit Investment Management Contract HR recruitment advertising costs Salary and Benefit Reallocations Revenue adjustments Grants Sheriff Account Adjustments Training costs Retirement transfer Reallocate vehicle costs ERP software costs PUBLIC WORKS FUND: • Project cost reallocation • Revenue Adjustments • Salary and Benefit Reallocations • Reallocate vehicle costs SOCIAL SERVICES FUND: • Grants • CARES Act HUMAN SERVICES FUND: • Grants • CARES Act PUBLIC HEALTH FUND: • Grants • CARES Act SOLID WASTE FUND: • Increased revenue adjustments FLEET SERVICES FUND: • Fuel costs and offsetting revenue HEALTH INSURANCE FUND: • Account adjustments • Claim Reserves • Revenue adjustments for final enrollment INSURANCE FUND: • Account adjustments • Claim Reserves supplemental appropriation reasons 2022 final Hello