CONTRACT 6239 Professional Services AgreementAgreement No. 6239
Agreement No. [City Clerk assigns]_
PROFESSIONAL SERVICES AGREEMENT
BETWEEN
THE CITY OF EL SEGUNDO AND
BARTEL ASSOCIATES, LLC
This AGREEMENT is made and entered into this 6th day of December, 2021, by
and between the CITY OF EL SEGUNDO, a municipal corporation and general law city
("CITY") and BARTEL ASSOCIATES, a Limited Liability Corporation,
("CONSULTANT"). The parties agree as follows:
1. CONSIDERATION,
A. As partial consideration, CONSULTANT agrees to perform the work listed
in the SCOPE OF SERVICES, below,
B. As additional consideration, CONSULTANT and CITY agree to abide by
the terms and conditions contained in this Agreement;
C. As additional consideration, CITY agrees to pay CONSULTANT a sum not
to exceed Twenty -Six thousand, five hundred dollars ($26,500) for
CONSULTANT's services. CITY may modify this amount as set forth
below. Unless otherwise specified by written amendment to this
Agreement, CITY will pay this sum as specified in the attached Exhibit "A,"
which is incorporated by reference.
2. SCOPE OF SERVICES,
A. CONSULTANT will perform services listed in the attached Exhibit "A,"
which is incorporated by reference.
B. CONSULTANT will, in a professional manner, furnish all of the labor,
technical, administrative, professional and other personnel, all supplies
and materials, equipment, printing, vehicles, transportation, office space
and facilities, and all tests, testing and analyses, calculation, and all other
means whatsoever, except as herein otherwise expressly specified to be
furnished by CITY, necessary or proper to perform and complete the work
and provide the professional services required of CONSULTANT by this
Agreement.
3. PERFORMANCE STANDARDS. While performing this Agreement, CONSULTANT
will use the appropriate generally accepted professional standards of practice existing at
the time of performance utilized by persons engaged in providing similar services. CITY
will continuously monitor CONSULTANT's services. CITY will notify CONSULTANT of
any deficiencies and CONSULTANT will have fifteen (15) days after such notification to
City of El Segundo Professional Services (REV 2018.05)
Page 1 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
cure any shortcomings to CITY's satisfaction. Costs associated with curing the
deficiencies will be borne by CONSULTANT.
4. PAYMENTS. For CITY to pay CONSULTANT as specified by this Agreement,
CONSULTANT must submit a detailed invoice to CITY which lists the hours worked and
hourly rates for each personnel category and reimbursable costs (all as set forth in
Exhibit "A") the tasks performed, the percentage of the task completed during the billing
period, the cumulative percentage completed for each task, the total cost of that work
during the preceding billing month and a cumulative cash flow curve showing projected
and actual expenditures versus time to date.
5. NON -APPROPRIATION OF FUNDS. Payments due and payable to CONSULTANT
for current services are within the current budget and within an available, unexhausted
and unencumbered appropriation of the CITY. In the event the CITY has not
appropriated sufficient funds for payment of CONSULTANT services beyond the current
fiscal year, this Agreement will cover only those costs incurred up to the conclusion of
the current fiscal year.
6. FAMILIARITY WITH WORK.
A. By executing this Agreement, CONSULTANT agrees that it has:
Carefully investigated and considered the scope of services to be
performed,
Carefully considered how the services should be performed; and
ii. Understands the facilities, difficulties, and restrictions attending
performance of the services under this Agreement.
B. If services involve work upon any site, CONSULTANT agrees that
CONSULTANT has or will investigate the site and is or will be fully
acquainted with the conditions there existing, before commencing the
services hereunder. Should CONSULTANT discover any latent or
unknown conditions that may materially affect the performance of the
services, CONSULTANT will immediately inform CITY of such fact and will
not proceed except at CONSULTANT's own risk until written instructions
are received from CITY.
7. TERM. The term of this Agreement will be from January 1, 2022, to December 31,
2023. Unless otherwise determined by written amendment between the parties, this
Agreement will terminate in the following instances:
A. Completion of the work specified in Exhibit "A",
City of El Segundo Professional Services (REV 2018.05)
Page 2 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
B. Termination as stated in Section 15.
8. TIME FOR PERFORMANCE.
A. CONSULTANT will not perform any work under this Agreement until:.
CONSULTANT furnishes proof of insurance as required under
Section 22 of this Agreement; and
ii. CITY gives CONSULTANT a written notice to proceed.
B. Should CONSULTANT begin work on any phase in advance of receiving
written authorization to proceed, any such professional services are at
CONSULTANT's own risk.
9. TIME EXTENSIONS. Should CONSULTANT be delayed by causes beyond
CONSULTANT's control, CITY may grant a time extension for the completion of the
contracted services. If delay occurs, CONSULTANT must notify the Manager within
forty-eight (48) hours, in writing, of the cause and the extent of the delay and how such
delay interferes with the Agreement's schedule. The Manager will extend the
completion time, when appropriate, for the completion of the contracted services.
10. CONSISTENCY. In interpreting this Agreement and resolving any ambiguities, the
main body of this Agreement takes precedence over the attached Exhibits, this
Agreement supersedes any conflicting provisions. Any inconsistency between the
Exhibits will be resolved in the order in which the Exhibits appear below:
A. Exhibit: A: Scope of Work.
11. CHANGES. CITY may order changes in the services within the general scope of
this Agreement, consisting of additions, deletions, or other revisions, and the contract
sum and the contract time will be adjusted accordingly. All such changes must be
authorized in writing, executed by CONSULTANT and CITY. The cost or credit to CITY
resulting from changes in the services will be determined in accordance with written
agreement between the parties.
12. TAXPAYER IDENTIFICATION NUMBER. CONSULTANT will provide CITY with a
Taxpayer Identification Number.
13. PERMITS AND LICENSES. CONSULTANT, at its sole expense, will obtain and
maintain during the term of this Agreement, all necessary permits, licenses, and
certificates that may be required in connection with the performance of services under
this Agreement.
14. WAIVER. CITY's review or acceptance of, or payment for, work product prepared
by CONSULTANT under this Agreement will not be construed to operate as a waiver of
City of El Segundo Professional Services (REV 2018.05)
Page 3 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
any rights CITY may have under this Agreement or of any cause of action arising from
CONSULTANT's performance. A waiver by CITY of any breach of any term, covenant,
or condition contained in this Agreement will not be deemed to be a waiver of any
subsequent breach of the same or any other term, covenant, or condition contained in
this Agreement, whether of the same or different character.
15. TERMINATION,
A. Except as otherwise provided, CITY may terminate this Agreement at any
time with or without cause.
B. CONSULTANT may terminate this Agreement at any time with CITY's
mutual consent. Notice will be in writing at least thirty (30) days before the
effective termination date.
C. Upon receiving a termination notice, CONSULTANT will immediately
cease performance under this Agreement unless otherwise provided in the
termination notice. Except as otherwise provided in the termination notice,
any additional work performed by CONSULTANT after receiving a
termination notice will be performed at CONSULTANT's own cost; CITY
will not be obligated to compensate CONSULTANT for such work.
D. Should termination occur, all finished or unfinished documents, data,
studies, surveys, drawings, maps, reports and other materials prepared by
CONSULTANT will, at CITY's option, become CITY's property, and
CONSULTANT will receive just and equitable compensation for any work
satisfactorily completed up to the effective date of notice of termination,
not to exceed the total costs under Section 1(C).
E. Should the Agreement be terminated pursuant to this Section, CITY may
procure on its own terms services similar to those terminated.
F. By executing this document, CONSULTANT waives any and all claims for
damages that might otherwise arise from CITY's termination under this
Section.
16.OWNERSHIP OF DOCUMENTS. All documents, data, studies, drawings, maps,
models, photographs and reports prepared by CONSULTANT under this Agreement are
CITY's property. CONSULTANT may retain copies of said documents and materials as
desired but will deliver all original materials to CITY upon CITY's written notice. CITY
agrees that use of CONSULTANT's completed work product, for purposes other than
identified in this Agreement, or use of incomplete work product, is at CITY's own risk.
17. PUBLICATION OF DOCUMENTS. Except as necessary for performance of service
under this Agreement, no copies, sketches, or graphs of materials, including graphic art
City of El Segundo Professional Services (REV 2018.05)
Page 4 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
work, prepared pursuant to this Agreement, will be released by CONSULTANT to any
other person or public CITY without CITY's prior written approval. All press releases,
including graphic display information to be published in newspapers or magazines, will
be approved and distributed solely by CITY, unless otherwise provided by written
agreement between the parties.
18.INDEMNIFICATION.
A. CONSULTANT agrees to the following:
i. Indemnification for Professional Services. CONSULTANT will
save harmless and indemnify and at CITY's request reimburse
defense costs for CITY and all its officers, volunteers,
employees and representatives from and against any and all
suits, actions, or claims, of any character whatever, brought
for, or on account of, any injuries or damages sustained by
any person or property resulting or arising from any negligent
or wrongful act, error or omission by CONSULTANT or any of
CONSULTANT's officers, agents, employees, or
representatives, in the performance of this Agreement, except
for such loss or damage arising from CITY's sole negligence
or willful misconduct.
ii. Indemnification for other Damages. CONSULTANT indemnifies
and holds CITY harmless from and against any claim, action,
damages, costs (including, without limitation, attorney's fees),
injuries, or liability, arising out of this Agreement, or its
performance, except for such loss or damage arising from
CITY's sole negligence or willful misconduct. Should CITY be
named in any suit, or should any claim be brought against it
by suit or otherwise, whether the same be groundless or not,
arising out of this Agreement, or its performance,
CONSULTANT will defend CITY (at CITY's request and with
counsel satisfactory to CITY) and will indemnify CITY for any
judgment rendered against it or any sums paid out in
settlement or otherwise.
B. For purposes of this section "CITY" includes CITY's officers, officials,
employees, agents, representatives, and certified volunteers.
C. It is expressly understood and agreed that the foregoing provisions will
survive termination of this Agreement.
D. The requirements as to the types and limits of insurance coverage to be
maintained by CONSULTANT as required by Section 22, and any
City of El Segundo Professional Services (REV 2018.05)
Page 5 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
approval of said insurance by CITY, are not intended to and will not in any
manner limit or qualify the liabilities and obligations otherwise assumed by
CONSULTANT pursuant to this Agreement, including, without limitation, to
the provisions concerning indemnification.
19.ASSIGNABILITY. This Agreement is for CONSULTANT's professional services.
CONSULTANT's attempts to assign the benefits or burdens of this Agreement without
CITY's written approval are prohibited and will be null and void.
20.INDEPENDENT CONTRACTOR. CITY and CONSULTANT agree that
CONSULTANT will act as an independent contractor and will have control of all work
and the manner in which it is performed. CONSULTANT will be free to contract for
similar service to be performed for other employers while under contract with CITY.
CONSULTANT is not an agent or employee of CITY and is not entitled to participate in
any pension plan, insurance, bonus or similar benefits CITY provides for its employees.
Any provision in this Agreement that may appear to give CITY the right to direct
CONSULTANT as to the details of doing the work or to exercise a measure of control
over the work means that CONSULTANT will follow the direction of the CITY as to end
results of the work only.
21.AUDIT OF RECORDS. CONSULTANT will maintain full and accurate records with
respect to all services and matters covered under this Agreement. CITY will have free
access at all reasonable times to such records, and the right to examine and audit the
same and to make transcript therefrom, and to inspect all program data, documents,
proceedings and activities. CONSULTANT will retain such financial and program
service records for at least three (3) years after termination or final payment under this
Agreement.
22. INSURANCE.
A. Before commencing performance under this Agreement, and at all other
times this Agreement is effective, CONSULTANT will procure and
maintain the following types of insurance with coverage limits complying,
at a minimum, with the limits set forth below:
Type of Insurance
Commercial general liability
Professional Liability
Business automobile liability
Workers compensation
City of El Segundo Professional Services (REV 2018.05)
Page 6 of 11
Limits
$2, 000, 000
$1,000,000
$1,000,000
Statutory requirement
Agreement No. 6239
Agreement No. [City Clerk assigns]_
B, Commercial general liability insurance will meet or exceed the
requirements of the most recent ISO-CGL Form. The amount of
insurance set forth above will be a combined single limit per occurrence
for bodily injury, personal injury, and property damage for the policy
coverage. Liability policies will be endorsed to name CITY, its officials,
and employees as "additional insureds" under said insurance coverage
and to state that such insurance will be deemed "primary" such that any
other insurance that may be carried by CITY will be excess thereto. Such
endorsement must be reflected on ISO Form No. CG 20 10 11 85 or 88, or
equivalent. Such insurance will be on an "occurrence," not a "claims
made," basis and will not be cancelable or subject to reduction except
upon thirty (30) days prior written notice to CITY.
C. Professional liability coverage will be on an "occurrence basis" if such
coverage is available, or on a "claims made" basis if not available. When
coverage is provided on a "claims made basis," CONSULTANT will
continue to renew the insurance for a period of three (3) years after this
Agreement expires or is terminated. Such insurance will have the same
coverage and limits as the policy that was in effect during the term of this
Agreement and will cover CONSULTANT for all claims made by CITY
arising out of any errors or omissions of CONSULTANT, or its officers,
employees or agents during the time this Agreement was in effect.
D. Automobile coverage will be written on ISO Business Auto Coverage Form
CA 00 01 06 92, including symbol 1 (Any Auto).
E. CONSULTANT will furnish to CITY duly authenticated Certificates of
Insurance evidencing maintenance of the insurance required under this
Agreement and such other evidence of insurance or copies of policies as
may be reasonably required by CITY from time to time. Insurance must
be placed with insurers with a current A.M. Best Company Rating
equivalent to at least a Rating of "A:VII."
F. Should CONSULTANT, for any reason, fail to obtain and maintain the
insurance required by this Agreement, CITY may obtain such coverage at
CONSULTANT's expense and deduct the cost of such insurance from
payments due to CONSULTANT under this Agreement or terminate
pursuant to Section 15.
23. USE OF SUBCONTRACTORS. CONSULTANT must obtain CITY's prior written
approval to use any consultants while performing any portion of this Agreement. Such
approval must approve of the proposed consultant and the terms of compensation.
24.INCIDENTAL TASKS. CONSULTANT will meet with CITY monthly to provide the
status on the project, which will include a schedule update and a short narrative
City of El Segundo Professional Services (REV 2018.05)
Page 7 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
description of progress during the past month for each major task, a description of the
work remaining and a description of the work to be done before the next schedule
update.
25. NOTICES. All communications to either party by the other party will be deemed
made when received by such party at its respective name and address as follows:
If to CONSULTANT:
Bartel Associates, LLC
411 Borel Avenue, Suite 620
San Mateo, CA
Attention: Mary Beth Redding
Phone: (650) 377-1600
Email: mbredding@bartel-associates.com
If to CITY:
City of El Segundo
350 Main Street
El Segundo, CA
Attention: Vicky Cao
Phone: (310) 524-2377
Email: wcao@elsegundo.org
Any such written communications by mail will be conclusively deemed to have been
received by the addressee upon deposit thereof in the United States Mail, postage
prepaid and properly addressed as noted above. In all other instances, notices will be
deemed given at the time of actual delivery. Changes may be made in the names or
addresses of persons to whom notices are to be given by giving notice in the manner
prescribed in this paragraph.
26. CONFLICT OF INTEREST. CONSULTANT will comply with all conflict of interest
laws and regulations including, without limitation, CITY's conflict of interest regulations.
27.SOLICITATION. CONSULTANT maintains and warrants that it has not employed
nor retained any company or person, other than CONSULTANT's bona fide employee,
to solicit or secure this Agreement. Further, CONSULTANT warrants that it has not
paid nor has it agreed to pay any company or person, other than CONSULTANT's bona
fide employee, any fee, commission, percentage, brokerage fee, gift or other
consideration contingent upon or resulting from the award or making of this Agreement.
Should CONSULTANT breach or violate this warranty, CITY may rescind this
Agreement without liability.
28.THIRD PARTY BENEFICIARIES. This Agreement and every provision herein is
generally for the exclusive benefit of CONSULTANT and CITY and not for the benefit of
any other party. There will be no incidental or other beneficiaries of any of
CONSULTANT's or CITY's obligations under this Agreement.
29.INTERPRETATION. This Agreement was drafted in and will be construed in
accordance with the laws of the State of California, and exclusive venue for any action
involving this agreement will be in Los Angeles County.
City of El Segundo Professional Services (REV 2018.05)
Page 8 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
30. COMPLIANCE WITH LAW. CONSULTANT agrees to comply with all federal, state,
and local laws applicable to this Agreement.
31. ENTIRE AGREEMENT. This Agreement, and its Exhibit(s), sets forth the entire
understanding of the parties. There are no other understandings, terms or other
agreements expressed or implied, oral or written. This Agreement will bind and inure to
the benefit of the parties to this Agreement and any subsequent successors and
assigns.
32. RULES OF CONSTRUCTION. Each Party had the opportunity to independently
review this Agreement with legal counsel. Accordingly, this Agreement will be
construed simply, as a whole, and in accordance with its fair meaning; it will not be
interpreted strictly for or against either Party.
33. SEVERABILITY. If any portion of this Agreement is declared by a court of
competent jurisdiction to be invalid or unenforceable, then such portion will be deemed
modified to the extent necessary in the opinion of the court to render such portion
enforceable and, as so modified, such portion and the balance of this Agreement will
continue in full force and effect.
34. AUTHORITY/MODIFICATION. The Parties represent and warrant that all necessary
action has been taken by the Parties to authorize the undersigned to execute this
Agreement and to engage in the actions described herein. This Agreement may be
modified by written amendment.
35.ACCEPTANCE OF ELECTRONIC SIGNATURES. The Parties agree that this
Agreement, agreements ancillary to this Agreement, and related documents to be
entered into in connection with this Agreement will be considered signed when the
signature of a party is delivered by electronic (.pdf) or facsimile transmission. Such
electronic or facsimile signature will be treated in all respects as having the same effect
as an original signature.
36. CAPTIONS. The captions of the paragraphs of this Agreement are for convenience
of reference only and will not affect the interpretation of this Agreement.
37.TIME IS OF ESSENCE. Time is of the essence for each and every provision of this
Agreement.
38. FORCE MAJEURE. Should performance of this Agreement be prevented due to fire,
flood, explosion, acts of terrorism, war, embargo, government action, civil or military
authority, the natural elements, or other similar causes beyond the Parties' reasonable
control, then the Agreement will immediately terminate without obligation of either party
to the other.
City of El Segundo Professional Services (REV 2018.05)
Page 9 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
39.STATEMENT OF EXPERIENCE. By executing this Agreement, CONSULTANT
represents that it has demonstrated trustworthiness and possesses the quality, fitness
and capacity to perform the Agreement in a manner satisfactory to CITY.
CONSULTANT represents that its financial resources, surety and insurance experience,
service experience, completion ability, personnel, current workload, experience in
dealing with private consultants, and experience in dealing with public agencies all
suggest that CONSULTANT is capable of performing the proposed contract and has a
demonstrated capacity to deal fairly and effectively with and to satisfy a public CITY.
[Signatures on next page]
City of El Segundo Professional Services (REV 2018.05)
Page 10 of 11
Agreement No. 6239
Agreement No. [City Clerk assigns]_
IN WITNESS WHEREOF the parties hereto have executed this Agreement the
day and year first hereinabove written.
CU OF EL SEGU O BARTEL ASS - CIA I ES, LLC
cote Mitnick, Mary deth dding,
Cite Manager Vice President
APPROVED AS TO FORM:
f 'i 4
Joaq In Vazquez,
Dep I y City Attorney
City of El Segundo Professional Services (REV 2018.05)
Page 11 of 11
Agreement No. 6239
Exhibit A
December 3, 2021
Joseph Lillio
Director of Finance
City of El Segundo
350 Main Street
El Segundo, CA 90245
Re: OPEB Actuarial Valuation Fee Estimate & Data Request
Dear Mr. Lillio:
Bartel Associates would be pleased to provide the City of El Segundo actuarial consulting services. This
letter summarizes the project scope and our fee estimate for a June 30, 2021 actuarial valuation for the
City's retiree healthcare plan.
Background
Bartel Associates prepared a June 30, 2019 valuation for the 2020/21 and 2021/22 fiscal years. The
June 30, 2021 valuation will determine the 2022/23 and 2023/24 Actuarially Determined Contributions
(ADCs) and will provide the City's GASBS 75 information for the 2021/22 and 2022/23 fiscal years.
Estimated Fees
Information provided under the actuarial valuation, timing, and fees are as follows:
�__.... ... .___...___
Approximate Fees
Project Start/
Com letion Date Estimate Cap
Valuation report and meeting, including January 2022/ $ 18,500 $ 20,500
6/30/21 funded status March 2022
w 2022/23 and 2023/24 recommended contributions
GASBS 75 accounting report for 2021/22 July 2022 / 2,500 3,000
August 2022
GASBS 75 accounting report for 2022/23 July 2023 / 2,500 3,000
Au ust 2022
Please note that our fee estimate assumes:
■ We will bill the City for project progress at the following rates. Hourly rates increase each year for
inflation. but the Fee cat) above will not change.
Position � 2021 Hourlv Ratel
Partner & Vie Pr$300
.......... cPresident (Redding) ... ( gam._._ ......................... w
w The City has made no changes to its retiree healthcare plan or healthcare providers since the 2020/21
GASBS 75 accounting report.
Assistant Vice President .�...._.W.
µSenior
270
Associate Actuary �(Moore) _
220
Actuarial Analyst
200
Actuarial Analyst Shen
160
1 We are keeping 2021 hourly rates the same as 2020 in order to help our clients in these difficult tunes
411 Borel Avenue, Suite 620 •San Mateo, California 94402
main: 650/377-1600 •web: www.bartel-associates.com
Agreement No. 6239
Joseph Lillio
December 3, 2021 67
Page 2
• No substantial changes occur between the valuation date and the GASBS 75 measurement dates that
would require revised actuarial assumptions and/or plan provisions.
■ Participant census data requested will be provided completely and accurately in an Excel workbook
with one record per participant.
■ All plan, financial, and census information requested will be provided and is internally consistent.
■ Costs and liabilities will be provided using one funding method and one set of assumptions.
• The City has not changed its funding policy of paying the full ADC each year.
• Actuarial costs and liabilities will be presented for the plan as a whole and breakdowns for employee
groups.
• We will have one meeting with the City to review preliminary valuation results and will provide a
discussion outline for the meeting.
• We will provide the actuarial certification, and other information required by Ca1PERS from agencies
funding with CERBT along with a certified final valuation results discussion outline.
■ There will be no additional charges for expenses (e.g., travel, telephone, copying, etc.). The hourly
rates above include our costs for these items.
wi We will invoice the City monthly based on time incurred, subject to the above maximum fees.
Please note that our fee estimate will be higher if:
■ Results are needed for alternative plan designs.
■ The City requests additional meetings. We will base our fee for additional meetings on our billing
rates and the time needed for the meetings and preparation.
s Assistance with footnotes under GASBS 75 beyond our GASBS 75 reports (which will contain all
actuarial related information needed for footnotes).
• The City requests an executive summary. Our estimated fees are $2,500 for an executive summary.
Data Requirements
In order for us to begin the actuarial valuation, please provide:
General Information
• Summary of OPEB plan provisions and copies of the most recent MOUs for bargained employee
groups and agreements for unrepresented groups if they have changed from those provided for the
June 30, 2021 GASBS 75 report.
a All quarterly trust statements received from Ca1PERS CERBT including contributions and dates made
since June 30, 2021.
• June 30, 2021 OPEB financial statement footnote and required supplementary information (when
available).
• The City's most current Ca1PERS PEMHCA resolution(s) if different from that provided for the
June 30, 2019 valuation.
n The City's June 2021 Ca1PERS health premium invoice. Please remove any Social Security numbers.
Participant Census Data
ail The City should obtain its Ca1PERS PEMHCA database extract as follows:
Log in to myCa1PERS as a business partner. The permission sets you will need are Business Partner
AR Billing and Business Partner Health Contracts. If you need access to myCa1PERS, please
contact the City's myCa1PERS System Administrator.
411 Borel Avenue, Suite 620 • San Mateo, California 94402
main: 6501377-1600 • web: www.bartel-associates.com
Agreement No. 6239
Joseph Lillio
December 3, 2021
Page 3
Once granted the appropriate access, select the Health Contracts Tab and then you will see the
OPEB Data Extract Link on the left side toolbar. This extract may take up to 48 hours to process,
but typical turnaround times are closer to 24 hours. The myCa1PERS system will not send an
automated email once completed, so we recommend logging back to the same page to obtain the
extracted data files. You will receive 2 files: one for active participants and one for retired
participants.
• To use the data extract for the valuation:
➢ Add PERSable compensation to each active record
➢ Remove any retirees who aren't eligible to participate in your retiree healthcare plan, for
example, if they did not retire directly from the City
➢ Add portion of premium reimbursed by the City outside of PEMHCA to each retiree record
➢ Complete any additions, deletions, or changes necessary to make the file current as of the
valuation date.
■ The resulting active and retired participant data file as of June 30, 2021 will include at least:
• Active Data - name, employee number (not Social Security number), gender, birth date, hire date,
medical plan, single/2-party/family coverage, Ca1PERS pension tier (e.g. 2.7%@57, 2%@62, etc.),
Ca1PERS pension plan (Miscellaneous, Safety -Fire, Safety -Police), total Ca1PERS service including
service at other agencies (if available), City service, bargaining or employee group (including
indication of unrepresented/hourly), spouse's birth date (if available), and annual PERSable
compensation. Indicate the pay period for the compensation reported. Include any active
employees who have waived healthcare coverage. Note if hours for part-time employees are less
than 20 hours per week.
• Retiree Data - name, employee number (not Social Security number), gender, birth date, hire date,
retirement type (service retirement, disability retirement, surviving spouse), retirement date,
medical plan, single/2-party/family coverage, Ca1PERS pension plan (Miscellaneous, Safety -Fire,
Safety -Police), bargaining or employee group, spouse's birth date (if available), portion of premium
paid by the City, and portion of premium paid by the retiree. Include any retirees or surviving
spouses of retirees who have waived coverage if they can join the plan at a later date.
• In order to maintain confidentiality, do not provide Social Security numbers for the employee
number. We will not accept any files that contain Social Security Numbers.
• Our fee estimate assumes that the City will merge and reconcile all data files and provide one
census file with one complete record for each employee and eligible retiree. If the City needs our
help to merge and reconcile data, our fees will be higher.
• We may need additional data, depending on our review of the City's retiree medical plan design.
GASBS 75 Accounting Report Information
x Fiscal year end June 30, 2022 GASBS 75 Accounting Report Information
• Covered employee payroll for fiscal year 2021/22 — the total payroll (gross W-2 Medicare wages)
for all employees who could be eligible for OPEB benefits (including those terminated during the
fiscal year).
• OPEB retiree pay-as-you-go costs (retiree health insurance subsidy paid by City) and administrative
expenses (PEMHCA) paid by the City during fiscal year 2021/22. Indicate portion of payments, if
any, that were reimbursed by the trust.
• Employer contribution made to the trust during fiscal year 2021/22.
• Participant head counts (actives, retirees, and waived retirees) as of June 30, 2022 (measurement
date).
411 Borel Avenue, Suite 620 • San Mateo, California 94402
main: 650/377-1600 • web: www.bartel-associates.com
Agreement No. 6239
Joseph Lillio
December 3, 2021
Page 4
■ Fiscal year end June 30, 2023 GASBS 75 Accounting Report Information
• Covered employee payroll for fiscal year 2022/23 — the total payroll (gross W-2 Medicare wages)
for all employees who could be eligible for OPEB benefits (including those terminated during the
fiscal year).
• OPEB retiree pay-as-you-go costs (retiree health insurance subsidy paid by City) and administrative
expenses (PEMHCA) made outside the trust during fiscal year 2022/23. Indicate portion of
payments, if any, that were reimbursed by the trust.
• Employer contribution made to the trust during fiscal year 2022/23.
• Participant head counts (actives, retirees, and waived retirees) as of June 30, 2023 (measurement
date).
We look forward to continue working with you and the City. Please call me (650-377-1604) with any
questions.
Sincerely,
Bianca Lin, FSA
Assistant Vice President and Actuary
c: Mary Beth Redding, Bartel Associates, LLC
\\BARTCAFSOI\Bartel-Associates\Clients\City of El Segundo\Proposals\2021\BA ElSegundoCi 21-12-03 OPEB 06-30-21 Valuation fee
letter.docx
411 Borel Avenue, Suite 620 • San Mateo, California 94402
main: 6501377-1600 • web: www.bartel-associates.com