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