ITE M 4. 4
CITY MANAGER' S REPORT
MAY 16, 2022 CITY COUNCIL SPECIAL MEETING
ITEM: RATIFY SAN 70AQUIN COUNCIL OF GOVERNMENTS'
ANNUAL FINANCIAL PLAN
RECOMMENDATION: Adopt Resolution Ratifying the San Joaquin Council of Governments ( SJCOG) Annual Financial Plan for
FY 2022- 23
BACKGROUND:
Every year pursuant to Section 7( b) of the San Joaquin Council of Governments' S] COG) Joint Powers Agreement, in anticipation of the new fiscal budget year, SJCOG requests that each member city ratify SJCOG' s Annual Financial Plan ( AFP) for the upcoming fiscal year.
Attached and referenced herein as Attachment B, is the Approved SJCOG Fiscal Year FY) Budget for 2022- 2023. Similar requests from SJCOG have been submitted to participating cities and ratified annually since the Joint Powers Agreement went into effect December 7, 2000.
The SJCOG AFP for FY 2022- 2023, was adopted by their Board on March 24, 2022, by Board Resolution No. R- 22- 68. The AFP provides a detail of expenditures by cost category and line item comparing the proposed FY 2022- 2023 budgets with the current FY 2021- 2022 adopted budget.
REASON FOR RECOMMENDATION:
The SJCOG Joint Powers Agreement requires that the Annual Financial Plan be delivered to its jurisdictional member agencies for ratification. Therefore, it is recommended that the City Council ratify the SJCOG' s Annual Financial Plan for FY 2022- 2023.
FISCAL IMPACT:
No fiscal impact to Lathrop. However, the SJCOG letter dated April 4, 2022, highlights the following significant changes for FY 22- 23 when compared to FY 21- 22:
S1COG Annua/ Financia/ P/an Summar
Revenue Funds FY 2021- 2022 FY 2022- 2023
Federa/ Grants 7, 259, 320 6, 639, 687
State Grants 13, 851, 972 10, 797, 910
Local Funding 5, 522, 391 6, 478, 356
Interest & Other 71, 000 80, 000
Total Revenues 26, 704, 683 23, 995, 953
CITY MANAGER' S REPORT
MAY 16, 2022 CITY COUNCIL SPECIAL MEETING
RATIFY SJCOG ANNUAL FINANCIAL PLAN FOR FY 22- 23
S1COG Annua/ Financia/ P/an Summar
Expenditure Funds FY 2021- 2022 FY 2022- 2023
Salary & Benefits 5, 153, 228 5, 148, 342
Services & Supplies 1, 121, 300 1, 197, 800
Professional Services 20, 234, 655 17, 454, 311
Capital Outlay 195, 500 195, 500
Tota/ Expenditures i 26, 704, 683 23, 995, 953
Highlights:
o General Fund Operating Revenues decreased by $ 2, 708, 730 Federal Funding decreased by 8. 54%
State Funding Sources decreased by 22. 05%
Local Revenues increased by 17. 31%
o Budgeted Expenditures are $ 23, 995, 953
Salaries and Benefits decreased 0. 9%
Services and Supplies increase by 6. 82%
Training & Travel increased by $ 34, 000 from prior FY
o Professional Services increased $ 995, 631 over FY 20- 21 o Fixed Assets remained the same at $ 195, 000.
ATTACHMENTS:
A. Resolution Ratifying the San Joaquin Council of Governments Annual Financial Plan for FY 2022- 23
B. Letter from S) COG Dated April 4, 2022, including SJCOG Resolution R- 22- 68 Board Report Adopting the FY 2022- 23 Annual Financial Plan
CITY MANAGER' S REPORT
MAY 16, 2022 CITY COUNCIL SPECIAL MEETING
RATIFY SJCOG ANNUAL FINANCIAL PLAN FOR FY 22- 23
APPROVALS:
y ' c1 - 1 2
esa Vargas Date
Government Services Director
City lerk
r
3 Cari Jar s Date
Finan' irector
f
Z— Z Z,.
Salvador Navarrete Date
City Attorney
Z9-ZZ
Step en J. Salvatore Date
City Manager
RESOLUTION NO. 22-
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF LATHROP RATIFYING
THE SAN OAQUIN COUNCIL OF GOVERNMENTS' ANNUAL FINANCIAL PLAN FOR FY 2022- 2023
WHEREAS, every year pursuant to Section 7( b) of the San ] oaquin Council of Governments' ( SJCOG) Joint Powers Agreement, in anticipation of the new fiscal budget year, S) COG provides a letter, resolution, and report requesting that each City ratify SJCOG' s Annual Financial Plan for the upcoming fiscal year; and WHEREAS, the Annual Financial Plan provides a detail of expenditures by cost category and line item comparing the proposed 2022- 23 budgets with the current fiscal year's ( FY 2021- 22) adopted budget; and
WHEREAS, the SJCOG Board approved the Annual Financial Plan for FY 2022- 2023 on March 24, 2022, by Board Resolution No. R- 22- 68; and WHEREAS, the SJCOG Joint Powers Agreement requires that the Financial Plan be delivered to its member agencies for ratification; NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Lathrop hereby ratify the FY 2022- 2023 Annual Financial Plan for the San Joaquin Council of Governments.
The foregoing resolution was passed and adopted this 16th day of May 2022, by the following vote of the City Council, to wit:
AYES:
NOES:
ABSENT:
ABSTAIN:
Sonny Dhaliwal, Mayor
ATTEST: APPROVED AS O FORM:
S- Li
Teresa Vargas, City Clerk Salvador Navarrete, City Attorney Resolution No. 22-
DocuSign EnvelopelD: B963C759- 9306- 435C- A9CF- 5499753F0871 SSSE. WeberAvenue • Stockton, California 95202 • P209.235. 0600 • F209. 235. 0438 • www. sjcog. org Apri14, 2022
Stephen Salvatore
City of Lathrop
390 Towne Center Drive
HuR
Y
Lathrop, CA 95330 E' .......
Robe t Rickman
VICE CHAIR
Dear Mr. Salvatore:
Dinne Nguveia
EXE T E o REcroR
Enclosed is a summary of the San Joaquin Council of Governments' Annual Financial mt,. age„ re.s Plan( AFP) for Fiscal Year 2022/ 23.
CITIES OF
ESCALON.
nrHROP. The SJCOG Board staff report is included in this letter as well as a copy of the LOD1,
MANTECA, adopting resolution. Pursuant to SJCOG' s Joint Powers Agreement, following RiPON, adoption of the budget by the SJCOG Board, it is to be delivered to member agencies sTocKTON, for ratification by each governing body. Approval by a majority of the governing T
ApY' bodies representing 55% or more ofthe county' s population is considered ratification.
THE COUNTY OF SAN
JOAQUIN Therefore, SJCOG requests you place SJCOG' s Annual Financial Plan for Fiscal Year 2022/ 23 on a forthcoming agenda prior to June 30, 2022, for approval.
The Annual Financial Plan implements the FY 2022/ 23 Overall Work Program( OWP) that was also adopted by the SJCOG Board on March 24, 2022.
The attached proposed Annual Financial Plan( AFP) provides detail of revenues and expenditures by cost category and line item comparing the proposed FY 2022- 2023 budgets with the current year( FY 2021- 2022) adopted budget, as most recently amended, along with FY 2020- 2021 actual expenditures. The total revenues and expenditures total $ 23, 995, 953. 00. The proposed AFP represents the general fund budget for SJCOG. The revenues and expenditures in the AFP are the same as the Overall Work Program( OWP), however, presented in a traditional line-item format compared to the wark element format of the OWP.
The attached includes a summary of revenues and expenditures in the AFP and schedules detailing each ofthose categories( Revenues, Service and Supplies, Transportation, Training and Travel, Professional Services and Fixed/ Capital Assets).
The attached includes a suminary of revenues and expenditures in the AFP and detail for each of those categories.
Readers should note several differences between SJCOG and its member agencies' budgets:
SJCOG revenue sources are quite different from our member agencies.
SJCOG employs staff on an at- will basis, vis- a- vis civil service and has its own employee handbook and policies.
SJCOG has its own Financial and Accounting Policy guiding our financial matters including procurement procedures.
DocuSign Envelope ID: B9B3C759-9306 35C-A9CF-5499753F0871 SJCOG employees are exempted from Social Security except for Medicare.
As noted below, SJCOG offers a defined contribution retirement plan to its employees.
SJCOG has no Ca1PERS or post employments benefit obligations except limited sick leave conversion as noted.
The following assumptions are incorporated in the budget:
1. Work will not begin, and expenses will not be incurred unless anticipated revenue sources are secured.
2. The AFP anticipates SJCOG to be fully staffed. The budget includes a 5. 94% pool that can be drawn upon for merit- based increases and potential promotions. The full impact of that pool is incorporated into the salary- driven benefits ( retirement, Medicare, disability).
3. SJCOG has no significant liability exposure for post- employment benefits. a. The employee retirement program is a defined contribution program managed by the International City Managers Association Retirement Program ( Mission Square Retirement).
b. SJCOG employee vacation accruals are capped at two times the individual' s annual leave.
c. Upon separation with 50 years of age or 20 years of SJCOG employment, an employee can convert accrued sick leave hours to be deposited into a Retirement Health Savings Account to pay for health- related expenses. The conversion is based upon the employee' s salary at retirement.
REVENUES
Compared to the current year amended AFP, SJCOG general fund operating revenues are proposed to decrease from $ 26, 704, 682. 85 to $23, 995, 953. 00, a decrease of$2, 708, 729. 85.
Overall, federal funding for FY22/ 23 Revenue Bud et
To a dpetSZ3. yy5,953 general fund activities is
io, 9, 9io 619, 632. 58 or 8. 54%
120°°°°°
lower than FY 2021- 22 due
1a 6• 9• 6,4 8,356 primarily to consumption of
6 one year of Congestion
400000o Mitigation/ Air Quality
z
80•0°° funds( CMAQ) for dibs,
O
FaderaiGreMa SLteGraMs Local Inter
J OV' s Transportation
Demand Management
Funding Category
program.
Federal Grents SMu Gronu Local Interest& O[ her
State funding sources are
lower$ 3, 054, 062. 27 or 22. 05% due to:
1, 154, 000 drawdown on prior year' s Freeway Service Patrol funding. 1, 900, 000 is available for FY 22- 23 future years of Freeway Service Patrol funding. 472, 543 drawdown has occurred on four years of Senate Bill 1 ( SB1) Sustainable Transportation Planning Grants offset by a FY 22- 23 allocation of$341, 671.
There is $ 250, 000 from the State Transportation Improvement Program ( STIP) for planning.
DocuSign Envelope ID: 6963C759- 9306- 435C- A9CF- 5499753F0871 Expenditure of$2, 211, 597. 07 from the state grant for Sustainable Transportation Equity Project( STEP).
31, 777 is carried over from the prior year' s Affordable Housing& Sustainable Community grant.
Local revenues are higher by $ 955, 965. 00 or 17. 31% due to increased sales tax receipts bolstering the Local Transportation Fund by $ 512, 165 and Measure K by $443, 800.
EXPENDITURES
Salaries and Benefits are
FY22/ 23 Expenditures
TotalBudget$ 23,995,953 proposed to decrease by
za0000«
1, 4, 3u
4, 886 or . 9% from
5, 153, 228.26 to
o 5, 148, 342. 22 compared
a
W5'
1 to the FY 21- 22 amended
I,'. 2
budget. The budget
saooaoo i 197, 195• 0
includes a$ 200,000 or
5. 68% of total salaries
Sdufss& Sarvkes. nd Protwiaul CapitalOut` y
wrw•• w. pool for merit- based
Expendtture Class raises. The salary- driven
Salaries& Benefits ServkesandSupplles professionalServices CapitalOutlay benefits adjust accordingly.
Services and Supplies are proposed to increase slightly by $42, 500. Computer software and licensing has increased by $ 40, 000 to support both a return to the office, working remotely and heightened cybersecurity. Non- capital equipment and furniture is increasing $ 15, 000. Rents and leases- equipment is increased slightly by $ 6, 000. General office supplies, postage and subscriptions are reduced a combined $ 18, 500.
Transportation, Travel, and Training
Assuming work conditions are returning to normal, there will be more travel. In addition, with several new employees, more training expenses are expected. This budget is increased $ 34, 000 up to $ 100, 000. This will help to support such activities as the annual One Voice trip.
Professional Services— Decreases$ 2, 780, 343. 81 from FY 21- 22 from $20,234, 654. 59 to 17, 454, 310. 78
There is consumption of various grants and funding sources. For example, the SB- 1 Sustainable Communities Grants consumed$ 560, 000. The Regional Transportation Plan update is nearing the end of the cycle. This work consumed $322,000 in funding. The Sustainable Transportation Equity Project( STEP) has consumed $ 1, 800, 000.
Fixed Assets/ capital remains the same as the previous year at$ 195, 000.
Position Classification and Salary Schedule
Per board policy, the salary ranges at both the minimum and maximum levels are adjusted by the CPI change. The past year saw a 6. 52% increase in CPI. This is not a 6. 52% raise for all DocuSign Envelope ID: 69B3C759- 9306- 435C- A9CF- 5499753F0871 employees, only and adjustment to the salary ranges to keep them competitive in the marketplace.
SJCOG staff would be pleased to appear before your policymakers to answer any questions they might have regarding this matter. We request ratification prior to June 30, 2022. Please let me know when this will be on your agenda. If you have any questions regarding this matter, don' t hesitate to contact me at 235- 0600.
Thank you for your assistance.
Sincerely,
CDxuSipned
by:
77C9E4A491524D2...
STEVE DIAL
Deputy Executive Director/ Chief Financial Officer
Attachments:
R- 22- 68
FY 2022- 23 Annual Financial Plan Staff Report
FY 2022- 23 Annual Financial Plan Board Summary
DocuSign Envelope ID: 69B3C759- 930B- 435C- A9CF- 5499753F0871
RESOLUTION
SAN JOAQUIN COUNCIL OF GOVERNMENTS
R- 22- 68
RESOLUTION APPROVING THE ADOPTION OF THE 2022- 2023
ANNUAL FINANCIAL PLAN
FOR THE SAN JOAQUIN COUNCIL OF GOVERNMENTS
WHEREAS, the San Joaquin Council of Governments is required by the Joint Powers Agreement to adopt a budget( Annual Financial Plan) annually, and WHEREAS, the adopted budget is to be sent to the member agencies for ratification.
NOW THEREFORE BE IT RESOLVED, that the San Joaquin Council of Governments adopts the FY 2022- 2023 Annual Financial Plan and directs the Executive Director to transmit it to the member agencies for ratification.
PASSED AND ADOPTED this 24th day of March 2022 by the following vote of the San Joaquin Council of Governments, to wit:
AYES: Councilmember Canepa, Stockton; Councilmember Jobrack, Stockton; Councilmember Kuehne, Lodi; Supervisor Miller, SJC; Supervisor Rickman, SJC; Councilmember Singh, Manteca; Supervisor Winn, SJC; Councilmember Wright, Stockton; Mayor Young, Tracy; Councilmember Zuber
NOES:
ABSENT: Councilmember Bellinger, Escalon; Vice Mayor Lazard, Lathrop DocuSqn qy:
I(,'
C18474F2603B405...
LEU M. ZUBER,
Chair
DocuSign Envelope ID: 69B3C759- 9306- 435C- A9CF- 5499753F0871 March 2022
SJCOG Board
STAFF REPORT
SUBJECT: FY 2022- 2023 Proposed Annual Financial
Plan ( AFP)
RECOMMENDED ACTION: That the Board Adopt Resolution 22- 68 Approving the FY 2022- 2023 Annual Financial Plan
The attached proposed Annual Financial Plan( AFP) provides detail of revenues and expenditures by cost category and line item comparing the proposed FY 2022- 2023 budgets with the current year( FY 2021- 2022) adopted budget, as most recently amended, along with FY 2020- 2021 actual expenditures. The total revenues and expenditures total $ 23, 995, 953. 00. The proposed AFP represents the general fund budget for SJCOG. The revenues and expenditures in the AFP are the same as the Overall Work Program ( OWP), however, presented in a traditional line- item format compared to the work element format of the OWP.
Below is a summary of revenues and expenditures in the AFP. For the detail for each of those categories please refer to the attached.
Readers should note several differences between SJCOG and its member agencies' budgets:
SJCOG revenue sources are quite different from our member agencies.
SJCOG employs staff on an at- will basis, vis- a- vis civil service and has its own employee handbook and policies.
SJCOG has its own Financial and Accounting Policy guiding our financial matters including procurement procedures.
SJCOG employees are exempted from Social Security except for Medicare.
As noted below, SJCOG offers a defined contribution retirement plan to its employees.
SJCOG has no CaIPERS or post employments benefit obligations except limited sick leave conversion as noted.
Upon adoption by the board, pursuant to the SJCOG Joint Powers Agreement, the AFP will be sent to the member agencies for ratification. Ratification is achieved when a majority of the member agencies representing 55% of the county population approve the AFP.
The following assumptions are incorporated in the budget:
1. Work will not begin, and expenses will not be incurred unless anticipated revenue sources are secured.
2. The AFP anticipates SJCOG to be fully staffed. The budget includes a 5. 94% pool that can be drawn upon for merit- based increases and potential promotions. The full impact of that pool is incorporated into the salary- driven benefits ( retirement, Medicare, disability).
3. SJCOG has no significant liability exposure for post- employment benefits.
DocuSign Envelope ID: B963C759- 930B- 435C- A9CF- 5499753F0871 a. The employee retirement program is a defined contribution program managed by the International City Managers Association Retirement Program ( Mission Square Retirement).
b. SJCOG employee vacation accruals are capped at two times the individual' s annual leave.
c. Upon separation with 50 years of age or 20 years of SJCOG employment, an employee can convert accrued sick leave hours to be deposited into a Retirement Health Savings Account to pay for health-related expenses. The conversion is based upon the employee' s salary at retirement.
REVENUES
Compared to the current year amended AFP, SJCOG general fund operating revenues are proposed to decrease from $26, 704, 682. 85 to $ 23, 995, 953. 00, a decrease of$2, 708, 729. 85.
Overall, federal funding for FY22/ 23 Revenue Budget
Totol Budget$ 23,995, 953 general fund activities is
ia,797, 9, 619, 632. 58 or 8. 54%
1 lower than FY 2021- 22 due
o. ess, s 6,a, s, 3s6 primarily to consumption of
one year of Congestion
400 0o Mitigation/ Air Quality
z
80' 0°° funds ( CMAQ) for dibs,
SJCOG' s Trans1 ortation Paieral Gnnts SLts Gnnn tocal nrerest& t" Demand Management
Funding Category
program.
Federal Grants Sate Gnnts lotal Intcrast& Other
State funding sources are
lower$ 3, 054, 062. 27 or 22. 05% due to:
1, 154, 000 drawdown on prior year' s Freeway Service Patrol funding. 1, 900, 000 is available for FY 22- 23 future years of Freeway Service Patrol funding. 472, 543 drawdown has occurred on four years of Senate Bill 1 ( SB1) Sustainable Transportation Planning Grants offset by a FY 22- 23 allocation of$341, 671.
There is $ 250,000 from the State Transportation Improvement Program( STIP) for planning.
Expenditure of$2,211, 597. 07 from the state grant for Sustainable Transportation Equity Project( STEP).
31, 777 is carried over from the prior year' s Affordable Housing& Sustainable Community grant.
Local revenues are higher by $ 955, 965. 00 or 17. 31% due to increased sales tax receipts bolstering the Local Transportation Fund by $512, 165 and Measure K by $443, 800.
DocuSign Envelope ID: 69B3C759-930B 35C-A9CF-5499753F0871
EXPENDITURES
Salaries and Benefits are
FY22/ 23 Expenditures
Tota/ Budget 523, 995,953 proposed to decrease by
l,. saall
4, 886 or .9% from
N
200°°°°°
5, 153, 228. 26 to
i 5, 148, 342. 22 compared
to the FY 21- 22 amended
X
0 5' las` a2
W budget. The budget
5000000 1, 197, 0 195,500
includes a $ 200, 000 or
5. 68% of total salaries
SdrNsi Senkesand Prafwlaql CayYblOutl y
e s w s« w«= pool for merit-based
Expenditure Class raises. The salary- driven
Sslarles& Benefltx 5ervicesand5upplces ProfessionalServices • CapiWlOutlay benefits adjust accordingly.
Services and Supplies are proposed to increase slightly by $42, 500. Computer software and licensing has increased by $ 40, 000 to support both a return to the office, working remotely and heightened cybersecurity. Non- capital equipment and furniture is increasing $ 15, 000. Rents and leases- equipment is increased slightly by $ 6, 000. General office supplies, postage and subscriptions are reduced a combined $ 18, 500.
Transportation, Travel, and Training
Assuming work conditions are returning to normal, there will be more travel. In addition, with several new employees, more training expenses are expected. This budget is increased $ 34, 000 up to $ 100, 000. This will help to support such activities as the annual One Voice trip.
Professional Services— Decreases $ 2, 780,343. 81 from FY 21- 22 from $20,234,654. 59 to 17, 454,310.78
There is consumption of various grants and funding sources. For example, the SB- 1 Sustainable Communities Grants consumed $ 560, 000. The Regional Transportation Plan update is nearing the end of the cycle. This work consumed $ 322, 000 in funding. The Sustainable Transportation Equity Project( STEP) has consumed $ 1, 800, 000.
Fixed Assets/ capital remains the same as the previous year at$ 195, 000.
Position Classification and Salary Schedule
Per board policy, the salary ranges at both the minimum and maximum levels are adjusted by the CPI change. The past year saw a 6. 52% increase in CPI. This is not a 6. 52% raise for all employees, only and adjustment to the salary ranges to keep them competitive in the marketplace.
FISCAL IMPACT
All revenues in the AFP are secured and available. The Annual Financial Plan is required to be adopted by the Board of Directors prior to April 1 each year and disseminated to the member agencies for ratification. The Annual Financial Plan is the traditional line- item budget DocuSign Envelope ID: 6963C759- 9306- 435C- A9CF- 5499753F0871 identifying estimated revenues and expenditures for the fiscal year. The Annual Financial Plan is complementary to the Overall Work Program.
RECOMMENDATION
That the Board adopt Resolution 22- 68 approving the FY 2022- 23 Annual Financial Plan.
Prepared by: Steve Dial, Deputy Executive Director/ CFO, and Grace Orosco, Manager of Finance DocuSign Envelope ID: B963C759- 9306- 435C- A9CF- 5499753F0871 San Joaquin Council of Governments
ANNUAL FINANCIAL PLAN
Fiscal Year 2022/ 23
Proposed Final March 24, 2022
CHAIR
Councilmember Leo Zuber, City of Ripon
VICE- CHAIR
Supervisor Robert Rickman, San Joaquin County
BOARD OF DIRECTORS
Councilmember poug Kuehne City of Lodi
Vice Mayor Diane Lazard City of Lathrop
Councilmember Gary Singh City of Manteca
Councilmember Paul Canepa City of Stockton
Councilmember Sol Jobrack City of Stockton
Councilmember Dan Wright City of Stockton
Supervisor Kathy Miller County of San Joaquin
Supervisor Chuck Winn County of San Joaquin
Mayor Nancy Young City of Tracy
Councilmember David Bellinger City of Escalon
EX OFFICIO DIRECTORS
Dennis Agar, Director Caltrans District 10
Gary Giovanetti, Director San Joaquin Regional Transit District Anthony Barkett, Commissioner Port of Stockton
SUBMITTED BY:
Diane Nguyen
Executive Director
Steve Dial
Deputy Executive Director/
Chief Financial Officer
DocuSign Envelope ID: B9B3C759- 930B- 435C- A9CF- 5499753F0871 San Joaquin Council of Governments
ANNUAL FINANCIAL PLAN
Fiscal Year 2022/ 2023
Proposed Final March 24, 2022
Flr Zazi Flr xoZi- zz Fv t432-z3
REVENUES Actual Amd# 2 hrOp tldE Blt Change Change
irrrrui
Federal Grants 5, 367, 138. 67 7, 259, 319.58 6,G 6$ 7.0p ( 619,632.58) 8. 54% State Grants 1, 765, 556.88 13,851,972.27 1Q3, 1d:l10 ( 3, 054,062.27) 22. 05% Local 5, 207, 017. 69 5, 522, 391. 00 G,47'8,8 r6,pO' 955,965. 00 17. 319 Interest 9. 924.38 2Q000.00 1,OOOflO 0. 00%
Other 51, 662.44 51,000.00 4p,itOp. Qp 9,000.00 17. 65% 5' i' iP!E1l t 12, 401, 300.06 26,704, 682.85 353. ' ( 2, 708,729. 85) 10. 14%
EXPENDITURES
Salaries& Benefits 4, 068,938.40 5, 153,228. 26 5, 148, 34. 2Z 4,886.04) 0. 099'0 Services& Supplies 981, 384. 57 1, 121, 300.00 1, 197,$ OQ.QO 76,500.00 6.82% Office Expense 284,346J2 261, 500.00 296,pt10. 00 36, 500. 00 13. 96% Communications 58,827.07 60,000.00 60,Qp0.1W O. 00Y
Memberships 34,372. 11 45, 000.00 45,0110, 0( 0.00%
Maintenance- Equipment 4, 531. 64 10, 000. 00 iq,itOD. 00' 0. 00% Rents& Leases- Equipment 97, 230.00 125, 000.00 13i3Opp. 00 6, 000. 00 4.80% Transportation,Trevel& Training( In& Out of State) 8, 485. 68 66,000.00 lOEi,Q00. 00 34, 000. 00 51. 52% Publications& Legal Notices 8, 539.52 7, 500.00 5C1p, Op O. 00Y Insurance 137, 046. 83 146, 300. 00 14d, 3tl0. tiff 0. 00% Building Operations& Maintenance 194, 115. 00 200,000.00 2p, OQb. Op 0.00% S1COG Building Debt Service Principal and Interest 153,890.00 200, 000.00 20d,G00.W 0.00% Professional Services 5, 945,599.90 20, 234, 654. 59 17,A54;3iQ78 ( 2, 780,343. 81) 13.74% CapitalOutlay 71,482.52 195, 500.00 195, 500. OQ 0. 00% Unallocated/ Reserve
S1COG OPERATING EXPENDITURES 11, 067, 40539 26, 704, 682. 85 23, 595, 553. DtI' ( 2, 705, 729. 85) 10. 14% DocuSign Envelope ID: B963C759- 930B- 435C- A9CF- 5499753F0871 San Joaquin Council of Governments
ANNUAL FINANCIAL PLAN
Fiscal Year 2022/ 2023
Proposed Final March 24, 2022
REVENUE
FY 2020- 21 FY 2021- 22 FY 2022-23
Revenue Source Actual Amd 2 Proposed Fi al Change
FEDERALGRANTS
U.S. Department of TranspoKation:
Federal Highway Administretion( PL) 1, 407, 914 $ 1, 383, 630 $ 1, 707,304 $ 323, 674 Federal Highway Administration( PL FY 20/ 21 C/ O) 3, 885 3, 885) Federal 7ransit Administration MPO Planning( FTA 5303) 284, 130 S 378, 781 $ 378,781 S Federal 7ransit Administration MPO Planning( FTA 5303 FY 19/ 20 C/ O) $ 211, 901 $ 72, 392 72, 392) Federal Trensit Administretion MPO Planning( FTA 5303 FY 20/ 21 C/ O) 45, 769 45, 769) RSTPCML 6088( 068) I- 205 Managed Lanes Widening 1, 603, 321 $ 2, 421, 802 $ 2,421,802 $ TDM- Merced CAG CMAQ 101, 635 $ 201, 800 $ 40, 000 $ ( 161, 800) TDM- Merced CAG CMAQ 56, 507 $ 48, 365 S 75,000 $ 26, 635 TDM- StanCOG CMAQ S 368, 562 S 580, 958 $ 566,800 $ ( 14, 158) CMAQTDM 1, 333, 169 $ 2, 121, 937 $ 1, 450, 000 $ ( 671, 937) 5, 367, 139 $ 7, 259, 320 $ 6, 639, 687 $ ( 619,633)
STATE GRANTS
California DepaRment of Transportatian:
STIP Planning& Programming 207, 316 $ 290, 000 $ 250,000 $ ( 40, 000) S71P Planning& Programming FY 20/ 21 Carryover 41, 342 $ 41, 342 $ 41,342) FY 17/ 18 Caltrens Sustainable Transportation Planning Grant( 561) S FY 18/ 19 Caltrens Sustainable Trensportation Planning Grant( 561) 121, 583 $ FY 19/ 20 Caltrens Sustainable Transportation Planning Grent( SB3) 153, 588 $ 181, 488 181, 488) FY 19/ 20 Wltrens AdapWtion Planning Grant( 561) 89, 416 $ 99, 198 99, 198) FY 20/ 21 Caltrans Sustainable Transportation Planning Grent( SBI) 221, 487 $ 132, 325 $ 12,837 $ ( 119,488) FY 21/ 22 Caltrens Sustainable Transportation Planning Grant( 561) 347, 369 $ 275,000 S ( 72, 369) FY 22/ 23 Caltrans Sustainable 7ronsportation Planning Grent( 561) S 341, 671 $ 341,671 Sub- recipient of SBl Competitive Planning Gront( City of Lodi) 4, 837 $ 92, 513 $ 92, 513) State Planning& Research( Fmrly CT Rurel Planning Assistance) 50, 000 $ 50, 000 $ 50, 000) Caltrans- FSP( I- 205) FY 18- 19 Carryover FSP19- 6088( 064) 103, 579 Caltrans- FSP( I- 205) FY 19-20 allocation FSP20-6088(069) 207, 984 $ 362, 262 $ 362, 262) Caltrans-FSP( I- 205) FY 20-21 allocation FSP21- 6088 073) 546, 122 $ 186, 122 $ ( 360, 000) Caltrens- fSP( I- 205) FY 21- 22 allowtion FSP21- 6088 076) 547, 781 $ 54, 781 $ Freeway Service Patrol( FSP18 SB3 6088-063) Carryover 35, 831 $ 35, 831) Caltrans- FSP18581 FY 18- 19 allocation FSP19 561- 6088 066) 374,905 $ 11, 679 $ 11, 679) Caltrens- FSP39561( 6088- 070) FY 19- 20 allocation 490, 646 $ 106. 646 $ ( 384, 000) Caltrans- FSP215B3( 6088-074) FY 20- 21 allocation 454, 873 $ 454,873 S Caltrans- FSP215B1( 6088- 077) FY 21- 22 allocation 584, 555 $ 584,555 S Affordable Housing& Sustainable Communities FY 19/ 20 Enterprise Affordable Housing& Sustainable Communities FY 20/ 21 Enterprise $ 7, 785 $ 32,777 $ 31,777 $ 1, 000) State Tronsit Assistance 105, 939 $ 132, 850 $ 145,863 $ 13, 013 Clean Mobility Options Program( EV Car Share) 998,614 $ 699,030 $ ( 299,584) S1V Regional Early Action Planning Committee for Housing( REAP) 45, 061 $ 970, 097 $ 1,923, 702 $ 953, 605 Sustainable Trans rtation E ui Project( STEP) 30, 735 $ 7, 449, 650 $ 5,238, 053 ( 2, 211, 597. 07) SUB70TAL 1, 765, 556. 88 S 13 851972 $ 30 797 930 ( 3 054 062. 27) LOCAL
TDA( LTF Planning+ TDA Administration) 1, 723, 670 $ 1, 473, 900 $ 1,986, 065 $ 512, 165 Measure K Project Management 1, 483, 644 $ 1, 000, 000 $ 1,000,000 $ Measure K Administration 187, 356 $ 671, 000 $ 912, 000 $ 241, 000 Measure K dibs 146, 020 $ 864, 000 $ 1, 066,800 S 202, 800 RTIF 466, 200 $ 341, 491 $ 341,491 $
Valley MPOs Air Quality Planning 168,212 $ 2pp,000 $ Zpp,ppp $ 7ri-County Travel Demand( Merced, Stanislaus, San Joaquin) 5 SACOG 7DM( Trip Planning System, 511, dibs) 70, 266 $ 150, 000 $ 150,000 $ Merced- Modeling 28, 279 $ S S
SACOG FSP Match 190,503 $ 207, 000 $ 207,000 $
COG Pees 10, 000 $ 10,000 $
sxo i ax, ses $ eos, 000 g 5os, 000 S
SUBTOTAL $ 5, 207, 018 $ 5 522 391 $ 6 478 356 955 965. 00 OTHER
Interest 9, 924 $ 20, 000 $ 20,000 $
Other( ALUC Fees+doc fees) 51, 662 5 51, 000 S 60, 00p $ 9, Opp SUBTOTAL $ 61 587 $ 71 000 $ 80 00p $ 9 ppp
TOTAL 12, 401, 300. 06 $ 26, 704, 682. 85 $ 33' 5, 953.D0 ( 2, 708, 729. 85) DocuSign Envelope ID: 6963C759-9306-435C-A9CF-5499753F0871 San Joaquin Council of Governmenu
ANNUAL FINANCIAL PLAN
Fiscal Year 2022/ 2023
Proposed Final March 24, 2022
SERVICE AND SUPPLIES
FY 20- 21 FY 2021- 22 FY 2022- 23
Title Line Item Description Actual Amd# 2 qnel Change
Office Expense- Generel Generel 5upplies 11, 240 $ 35, 000 $ 2t1,G00: $ 15, 000) Recognitions S 500 $ S00 $
Printing 691 $ 4,000 $ 4,000 $
Noncapital Equip/ Furniture 37, 214 $ 20, 000 '$ 3S, d00 $ 15, 000 Computer Software& License 232,412 $ 195, 000 $ $ 3a, 000' $ 4Q000 Office Expense- Generel Subtotal 281, 556 $ 254, 500 $ 294,50D $ 40, 000 Office Expense- Postage Subtotal 1, 085 $ 3, 000 $ 1, 500 $ 1, 500) Office Expense- Subscriptions Subtotal 1, 705 $ 4,000 $ 2 OQ( 1- $ 2, 000) Office Expense- Subtotal 284, 347 $ 261, 500 $ 2 Q00 $ 36, 500 Communications- Subtotal 58,827 $ 60,000 $ 60000 $
Memberships- Subtotal 34, 372 $ 45, 000 .$ 45 $
Maintenance- Equipment- Subtotal 4,532 $ 10, 000 $ 10,0011 $ Rents& Leases- Equipment- Subtotal 97, 230 $ 125, 000 $ 131, A00 $ 6, 000 Publications& Legal Notices- Subtotal 8, 540 $ 7, 500 ;$, 7, 500 $ Insurences- Subtotal 137,047 $ 146, 300 $ 146 3f14 $
Building Maintenance- Subtotal 194, 115.00 $ 200, 000 $ 20p 000 $ BuildingDebt Service- Principle& Interest 353, 890. 00 $ 20q000 $ 200, pOp $ TOTAL SERVICES& SUPPLIES 972, 899 $ 1, 055, 300 '$ 1,097',$ 00 $ 42, 500 DocuSign EnvelopelD: B963C759- 9306-435C- A9CF- 5499753F0871
POSITION CLASSIFICATIONS& SALARV SCHEDULE
ANNUAL
Proposed March 24, 2022- Effective luly 1, 2022
Position Minimum Minimum Maximum Maxlmum
12 month
Change in CPI Previous New Previous New
Executive Director CON7RAR CONTRAR CONTRAR CONTRAR
GROUP A
Deputy Executfire D( rector/ CFO 6. 5220Y $ 173, 984.00 S 185, 331. 24 S 243, 578. W S 259, 464. 36
GROUP B
Dlpury Director Planning 6. 5220% $ 153, 946.00 $ 163, 96636 $ 215, 525. 00 $ 229, 581. 54 Deputy Director Programming& ProJect Delivery
GROUPC
6. 5220% $ 136, 235. 00 $ 145, 120. 25 $ 190, 730. 00 $ 203, 169. 41
GROUP D
Regional Planning or Programming Manager 6. 5220% S 121, 098. 00 S 128, 9%. Ol $ 169,537.00 5 180,594.20 GROUP E 6.5220% S 109, 097. 00 S 116, 212. 31 S 152,736.OD S 162, 697.94 Habitat Conservation Program Ma ager
Manager of Administrethe Services
Information 7echnology Manager
Communicattons Manager
Manager of Finance
GROUP F 6. 5220% S 98, 286. 00 $ 104, 696.21 S 137, 600.00 $ 146,574.27 Chief At[ ountant
Senior Regtonal Planner
Senior Program Specialist
GROUP G
6. 5220Y $ 88, 546.00 $ 94.320. 97 $ 123.964.00 $ 132. 048. 93 GROUP H 6. 5220% $ 80, 4%. 00 $ 85, 745. 95 5 112, 695. 00 $ 120,044.97 Associate Regional Planner
Associate Habitat Planner
Public Informatfon Officer
GROUPI
Human Resourcez Assistant 6.5220% S 73. 178.00 S 7, 950.67 S 102, 450.00 5 109,131. 79 Offite Administrator
GROUPI 6.5220% $ 66, 526. 00 S 70, 864. 83 S 93, 136.00 S 99,210. 33 Associate Program Specialist
Staff Accountant
Contract/ Grants Specialist
GROUP K 6. 5220% $ 60, 478.00 S 64, 422. 38 $ 84, 669.00 $ 90. 191. 11 Assistant Regional Planner
Assistant Program Specfalist
Assistant Habitat Planner
JuniorACCOuntant
GROUP L 6. 5220% $ 54, 960. 00 $ 58, 565. 80 $ 76,972. 00 $ 81, 992. 11 GROUP M 6. 5220% S 49,982. 00 $ 53, 241.83 $ 69, 975. 00 $ 74, 538. 77 Administrative Technician
Accounting Auistant II
GROUP N 6. 5220% $ 45, 320. 00 $ 48, 275.77 $ 63,448. 00 S 67,586.08 GROUP O 6. 5220% $ 41,% 3. 00 $ 44. 699. 83 $ 58, 748. 00 $ 62,579.54 Accounting Assistant I
DocuSign Envelope ID: 6963C759- 9306- 435C- A9CF- 5499753F0871 San Joaquin Council of Governments
ANNUAL FINANCIAL PLAN
Fiscal Year 2022/ 2023
Proposed Final March 24, 2022
Tranportation Travel& Training
FY 20- 21 FY 2021- 22 FY 2tt22- 23
Actual Amd# 2 f ti`appa ed,; iit rl ` Change
In and Out of State Travel 1, 458 $ 45, 000 7, $ 27, 000 Training 7, 028 $ 20, 000 $ OEM $ 5, 000
Rideshare Incentive 1, 000 $ pC $ 2, 000
frwr mrnrrerr
Transportation& Travel- Subtotal $ 8, 486 $ 66, 000 $ 1t1Ci, 000 $ 34, 000 DocuSign Envelope ID: 69B3C759- 930B- 435C- A9CF- 5499753F0871 San Joaquin Council of Governments
ANNUAL FINANCIAL PLAN
Fiscal Year 2022/ 2023
Proposed Final March 24, 2022
PROFESSIONAL SERVICES
FY 20- 21 FY 2021- 22 Y 2022-23
Work Element No./ Project Description actual nmd ai pr ttse t f tial Change 601. 01-- Regional Trensportation Plan 76, 279 $ 471, 883 $ YS, At10 $ ( 321, 883) 601. 011-- Regional Trensportation Plan( AHSC) S 32, 000 $ 31,' J' 7 $ ( 223) 601. 012-- SCS Implementation FY 17/ 18 561 grant
601.013--SCS Implementation FY 18/ 19 561 grent 47, 304 $ 601.014--SCS Implementation FY 19/ 20 5B1 grant 157, 520 5 200, 200, 000) 601.015-- 19/ 20 Caltrans Adaptation Planning grant 561 62, 271 5 300, 000 $ 100,000) 601. 016-- SCS Implementation PY 20/ 21561 grant 28Q525 S 141, 074 § 1+43,474 $ - 601.017-- SCS lmplementation FY 21/ 22 SBl grant 200, $ 12.537. $ ( 187, 163) 601.017--SCS Implementation FY 21/ 22 5B1 grant 5 347, 369 $ t75,C00 5 ( 72, 369) 601.018--SCS Implementation FY 22/ 23 SBi graot 34#, 671 $ 341,671 601. 02-- Regional Planning Studies 38, 301 $ 30,000 $ 30,Od4 $ - 602. 01-- RTIP
603. 01-- Road& Street Monitoring 430 $ 900,000 $ 9D0, 000 $ - 603. 015-- I- 205 Managed Lanes Widening Project 2, 008,407 $ 2, 000,000 $ Z,OW1, 000 $ - 603.02--Trensit Coordination
603.03--Transportation Air Quality 5 143,436 $ 200,000 $ 20Q, 000 $ - 603. 04-- Goods Movement
603. 041-- Goods Movement Partnership Planning Grant
701.01--Technical Assistance 24,854 $ 97, 350 j 9, 350 $ - 801. 01-- Intergovernmental Coordination S 120, 073 $ 130, 000 $ Y30,040` $ - 801. 012-- Intergovemmental Coordination( St. PM.& Reas) 5 50,000 $ 50,000 $ 50,000) 801. 02-- Projections& Forecasts 72,058 $ 140,000 $ 14t 000 S - 801. 03--Airport Land Use Commission 30,000 $ O, d00 $ - 801. 04-- Congestion Management 81, 872 $ 50, 000 $ 50r040 $ - 801. 05-- Regional Planning 9,506 $ 15,000 $ ` 13, tKib $ - 801.06--Valley MPO Coordination 18, 212 $ 45, 000 $ 45, OOC) $ - 801.09--SJCOG Inc 85,000 $ S, fl00' $ -
901.01-- Measure K 19, 194 5 50, 000 $ 50,p( b' $ -
901. 02-- RTIF 5, 586 $ 15,000 $ ' Y5, 000 $ -
901.03--Smart Growth
1001. 01-- COG OWP 13, 810 $ 5, 000 $ ' 5,d00 $ -
1001. 02--TDA Administration 158,614 $ 300,000 $ 254, 000- S ( 50,000) 1001. 03-- Community Involvement 46,429 $ 25, 000 $ 25,t1f1 $ - 1001. 04-- FAST ACT Management
1101. 01--Trensportation Demand Management 1, 480, 744 $ 2, 135, 713 S 1. 97, 9Y3 $ ( 161, 800) 3101. 03-- Transportation Demand Management
1201. 01-- Freeway Service Patrol 833,684 S 3, 034, 555 $ 2, t19, 903 S ( 814, 652) 1201. 03- S1COG Intems
1301. 01- PerformanCe Based Planning and Programming
1350.01- SJV Regional Early Action Planning Committee for Housing( REAP 5 6, 887 $ 849, 097 $ ,, 923,702 $ 1, 074, 605 1375. 01- Sustainable Transportation Equity Project( STEP) 17, 915 $ 7, 049, 650 $ 5, 238, 053 $( 1, 831, 597) 1380.01- CMO voucher progrem 5 S 998,000 $ 6y9, p30 $ ( 298, 970) Mdired 5 171, 689 $ 527, 963 S ( 127, 963)
TOTAL 5, 945,600 $ 20,234, 655 1?,45w4y i1: $( 2, 780, 344) DocuSign Envelope ID: 6963C759- 930B- 435C- A9CF- 5499753F0871 San Joaquin Council of Governments
ANNUAL FINANCIAL PLAN
Fiscal Year 2022/ 2023
Proposed Final March 24, 2022
FIXED ASSETS
FY 20- 21 FY 2021- 22 Y 2022-23"
Title Description Actual Amd# 2 1 po d itf l` Change
Office Furniture/ Equipment 10, 000 10,OOff $ -
Replacement Printers( 2)
Server Upgrade 10, 308 $ 20, 500 $ Zt}, 500' $ -
ERP Accounting System
Customer Relation Management 25, 000 $ 25.{1C10 $ -
Computer Upgrades 51, 205 $ 20, 000 $ 2i1, t100 $ -
Capitalized Building Maintenance/ Upgrades $ 9, 970 $ 120, 000 $ 32Q 0 $ - TOTAL 71, 483 $ 195, 500 $ 195, 50Q $ -
DocuSign Envelope ID: 6963C759- 9306- 435C- A9CF- 5499753F0871 San Joaquin Council of Governments
STAFf ALLOCATION
Approved March 25, 2021
Amendment# 1 October 28, 2021
3/ 25/ 2021 10/ 28/ 2021 3/ 24/ 2022
Proposed
Position 2021- 22 2021- 22 2022- 23
Executive Director 1 1 1
Deputy Executive Director/ Chief Financial Officer 1 1 1 Deputy Director 2 2 2
Project Manager Habitat 1 1 1
Manager of Finance 1 1
Public Communications Officer 1 1 1
Senior Regional Planner 4 4 4
Senior Program Specialist 1 1 1
Chief Accountant 1 1 0
Assistant/ Associate Regional Transportation Planner 6 3 4 Assistant/ Associate Program Specialist 2 2 1
Assistant/ Associate Habitat Planner 1 1 1
Planner Tech 1 0 1
Administrative Analyst 0 0 0
Administrative Technician 3 4 5
Manager of Administretive Services 1 1 0
Information Technology Manager 1 1 1
Office Administrator 1 1 1
Administrative Clerk I/ II 0 0 0
Senior Accountant 1 1 1
Junior Accountant 1 1 1
Contract/ Grant Specialist 1 0 0
Payroll Specialist- HR Assistant 1 0 0
Accounting Assistants I/ II 2 3 2
TOTAL 34 31 30
Regular Positions: 34 34 34
Interns/ Temporary/ Part- Time Positions: 3 0 2