00188_TUHSD_Life,_AD&D,_and_Disability_RFP_Financial_Workbook_2026(6007601.1).xlsx

XLSX spreadsheet 80 KB Posted Oct 14, 2026

Attached to: Employee Benefits- Life/STD/FSA/HSA/COBRA
Solicitation number: 27-011CH-32RFP
Issued by: Maricopa County, Tucson City, Arizona

About this file

Written by GovTribe AI · Oct 29, 2026

This is a financial workbook for the Tempe Union High School District's Request for Proposal (RFP) for Employee Benefits covering Life Insurance, Accidental Death & Dismemberment (AD&D), and Disability insurance for 2026. The district seeks proposals for comprehensive employee benefit coverage to support its workforce. Proposals must be submitted through the Procurement Portal at https://procurement.opengov.com/portal/tuhsd no later than 2:00 pm on Thursday, November 19, 2026. The workbook serves as the financial evaluation tool for interested vendors to understand the district's benefit needs and pricing structure, enabling vendors to develop competitive proposals based on the district's employee population and coverage requirements.

The financial workbook contains detailed pricing templates and benefit calculations necessary for vendors to submit accurate cost proposals. The document provides the framework for evaluating pricing terms, premium structures, and benefit calculations across the district's employee base. As a financial planning document, the workbook establishes the baseline data and methodologies that vendors must use to ensure consistent and comparable pricing submissions. The workbook does not identify any set-asides, incumbent providers, or specific funding amounts in its title or designation, focusing instead on providing the quantitative framework needed for vendors to develop and submit their financial proposals for the district's employee benefits package.

View the file

Other files

File	Type	Posted
Employee_Benefits-_Life_STD_FSA_HSA_COBRA_(Addendum_#1_Revision).pdf	PDF	Oct 29, 2026
Employee_Benefits-_Life_STD_FSA_HSA_COBRA.pdf	PDF	Oct 20, 2026
B6__Flex_Document(6009515.1).pdf	PDF	Oct 14, 2026
Attachment_B5__FSA_Utilization(6008907.1).docx	DOCX document	Oct 14, 2026
B4__STD_Experience(6009514.1).xlsx	XLSX spreadsheet	Oct 14, 2026
B3__STD_Booklet(6009513.1).pdf	PDF	Oct 14, 2026
B2__Life_Experience(6009512.1).xlsx	XLSX spreadsheet	Oct 14, 2026
B1__Life_Certificate(6009511.1).pdf	PDF	Oct 14, 2026
2026_Life-STD-FSA-COBRA_RFP.xlsx	XLSX spreadsheet	Oct 14, 2026
00188_TUHSD_FSA_HSA_COBRA_RFP_Financial_Workbook_2026(6007494.1).xlsx	XLSX spreadsheet	Oct 14, 2026
RFP,_TUHSD_00188,_Life,_STD,_COBRA,_FSA,_HSA_RFP_Background_and_SOW_2027(6007309.2).pdf	PDF	Oct 14, 2026

Show all 11

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Life, AD&D and Disability RFP — Financial Workbook

Instructions

Exhibit Instructions to Vendors

1. Do not delete or alter pre-labeled rows.

2. Electronic copies of these exhibits must be returned in Excel. Do not provide in a PDF format.

3. Do not extract individual worksheets (exhibits) and submit as separate Excel workbooks in the electronic copy.

4. Cells shaded light gold are expected inputs. Please review these carefully for a response.

You may additionally include your normal underwriting pricing worksheets and caveats. However, we will use your responses on the required exhibits and questionnaire as your proposal response when they differ from any supplemental underwriting materials you provide.

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

General Information

Life, AD&D and Disability RFP — Financial Workbook

General Information

Instructions to HBA

1. Complete the RFP Intake Form in Asana.

2. Prepare template and make sure it is peer reviewed before sending externally.

3. Check to make sure client information, policy year, and items in purple font are updated and correct before sending to carriers.

4. Do not extract individual worksheets (exhibits) and submit as separate Excel workbooks in the electronic copy.

5. When RFP and supporting documents are sent externally to carriers, please save the emails and financial template workbook to iManage. If data being sent to vendors contains PHI, be sure to send securely/encrypted (i.e. - SFT, Zixmail).

6. Do not share proprietary/confidential vendor specific information with other vendors (i.e. - provider network status, allowed charges, discounts, etc.).

Client and Project Name	Tempe Union High School District - RFP# 27-011CH-32
Policy Year	July 1, 2027–June 30, 2028
Policy Effective Date	July 1, 2027
Number of Eligibles	1000
Number of Employees/Participants	800
Peer Review Role	Name	Date
Doer
Checker
Reviewer

	Plan Year	Effective Date	Policy End Date
Year 1	07/1/2027 - 06/30/2028	7/1/27	6/30/28
Year 2	07/1/2028 - 06/30/2029	7/1/28	6/30/29
Year 3	07/1/2029 - 06/30/2030	7/1/29	6/30/30
Year 4	07/1/2030 - 06/30/2031	7/1/30	6/30/31
Year 5	07/1/2031 - 06/30/2032	7/1/31	6/30/32

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

1|Basic LifeAD&D Rates

Tempe Union High School District - RFP# 27-011CH-32

Basic Life and AD&D Composite Rates

Effective July 1, 2027

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

If bidding, this form must be completed in its entirety. Please do not alter, add or delete rows. Failure to complete this exhibit as requested may results in rejection of your offer.

Multi-year rate guarantees, including rate caps, will be given a higher weight in scoring.

Basic Life and AD&D Pricing	Current Volume	Rate
Monthly Fees (Basic Life and AD&D)
Basic Life Rate (per $1,000)	$ 56,250,000
Basic AD&D Rate (per $1,000)	$ 56,250,000
Estimated Annual Premium		$ - 0
Rate Guarantees
Rate Guarantee Period

Comments:

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

2|Voluntary LifeAD&D Rates

Tempe Union High School District - RFP# 27-011CH-32

Voluntary Life and AD&D Rates

Effective July 1, 2027

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

If bidding, this form must be completed in its entirety. Please do not alter, add or delete rows. Failure to complete this exhibit as requested may results in rejection of your offer.

Multi-year rate guarantees, including rate caps, will be given a higher weight in scoring.

Voluntary Life and AD&D Pricing	Current Volume (Employee)	Rate (Employee)	Current Volume (Spouse)	Rate (Spouse)
Monthly Fees (Voluntary Employee/Spouse Life)
20 to 24	$ - 0		$ - 0
25 to 29	$ 90,000		$ - 0
30 to 34	$ 440,000		$ 30,000
35 to 39	$ 1,420,000		$ 140,000
40 to 44	$ 2,350,000		$ 430,000
45 to 49	$ 5,160,000		$ 675,000
50 to 54	$ 4,740,000		$ 895,000
55 to 59	$ 3,710,000		$ 400,000
60 to 64	$ 2,160,000		$ 295,000
65 to 69	$ 280,000		$ 15,000
70 to 74	$ 500,000		$ 125,000
Estimated Annual Premium		$ - 0		$ - 0
Monthly Fees (Voluntary Child Life)
Voluntary Child Life (per $1,000)	$ 1,015,000
Estimated Annual Premium		$ - 0
Monthly Fees (Voluntary AD&D)
Voluntary AD&D (per $1,000)	$ 20,900,000
Estimated Annual Premium		$ - 0
Rate Guarantees
Rate Guarantee
Participation
Minimum Participation Requirements (if any)

Comments:

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

3|STD Rates

Tempe Union High School District - RFP# 27-011CH-32

Short Term Disability Administration Fee

Effective July 1, 2027

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

If bidding, this form must be completed in its entirety. Please do not alter, add or delete rows. Failure to complete this exhibit as requested may results in rejection of your offer.

Multi-year rate guarantees, including rate caps, will be given a higher weight in scoring.

Short Term Disability Pricing	Employees	Rate
Monthly Fees
STD Administration Fee (PEPM)	1125
Estimated Annual Premium		$ - 0
Rate Guarantees
Rate Guarantee

Comments:

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

8|Basic LifeAD&D Benefits

Tempe Union High School District - RFP# 27-011CH-32

Basic Life and AD&D Coverage Summary

Effective July 1, 2027

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

Complete the grid indicating any difference in benefit design offered. Please leave cells BLANK if proposed plan design offered is the same as requested.

Plan Design	Current/Requested	Proposed
Basic Life
Eligibility	Full Time Employees in Active Employment with the Employer in the United States

Excludes temporary and seasonal workers

Basic Employee Life	$50,000
Guarantee Issue	$50,000
Waiver of Premium	Included
Waiver of Premium Waiting Period	6 months
Portability	Yes - Basic, Supplemental & Dependent Life if under age 70
Portability Termination	At age 70
Age Reductions	Age 65: 65%, Age 70: 50%
Accelerated Death Benefit	80% or $250,000, whichever is less.
Conversion	Included
Basic AD&D
Basic Employee AD&D	$50,000
Loss of Sight in Both Eyes	100% of the Full Amount of AD&D Insurance
Paralysis of all four limbs	100% of the Full Amount of AD&D Insurance
Paralysis of three limbs	75% of the Full Amount of AD&D Insurance
Paralysis of two limbs	50% of the Full Amount of AD&D Insurance
Paraoysis of one limb	25% of the Full Amount of AD&D Insurance
Loss of an Arm	50% of the Full Amount of AD&D Insurance
Loss of a Leg	50% of the Full Amount of AD&D Insurance
Loss of a Hand	50% of the Full Amount of AD&D Insurance
Loss of a Foot	50% of the Full Amount of AD&D Insurance
Loss of Sight in One Eye	50% of the Full Amount of AD&D Insurance
Loss of Speech	50% of the Full Amount of AD&D Insurance
Loss of Hearing	50% of the Full Amount of AD&D Insurance
Brain Damage	25% of the Full Amount of AD&D Insurance to a maximum of $25,000
Coma	2% of the Full Amount of AD&D Insurance to a maximum of $24,000
Safety Belt	Equal to 10% of the full Benefit Amount for loss of life to a maximum of $10,000
Airbag use	Equal to 5% of the full Benefit Amount for loss of life to a maximum of $5,000
Transportation/Repatriation	Equal to 2% of the full Benefit Amount for loss of life to a maximum of $2,000
Child Care (per child)	Equal to 5% of the full Benefit Amount for loss of life to a maximum of $10,000
Child education (per student)	Equal to 5% of the full Benefit Amount for loss of life to a maximum of $3,000 for all students per academic year for up to 4 years
Spouse education (per student)	Equal to 5% of the full Benefit Amount for loss of life up to a total of $3,000 per academic year for up to 4 years
Common Carrier	Equal to 100% of the full Benefit Amount for loss of life to a maximum of $50,000
Occupational assualt	Equal to 100% of the full Benefit Amount for the loss to a maximum of $10,000

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

9|Vol. LifeAD&D Benefits

Tempe Union High School District - RFP# 27-011CH-32

Voluntary Life and AD&D Coverage Summary

Effective July 1, 2027

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

Complete the grid indicating any difference in benefit design offered. Please leave cells BLANK if proposed plan design offered is the same as requested.

Plan Design	Current/Requested	Proposed
Voluntary Life
Voluntary Life - Employee	6 times Basic Yearly Earnings Not to Exceed $500,000 max ($10,000 increments)

Employee Guaranteed Issue: $100,000 Voluntary Life - Spouse Not to Exceed 50% of Employee Voluntary Life Selection up to $250,000 max ($5,000 increments) Spouse Guaranteed Issue: $30,000

Voluntary Life - Child	Child birth - 26 years, choice of $1,000, $5,000 or $10,000
Guarantee Issue	$100,000
Waiver of Premium	Included
Waiver of Premium Waiting Period	6 months
Portability	Yes - Basic, Supplemental & Dependent Life if under age 70
Portability Termination	At age 70
Volunatry AD&D
Voluntary AD&D - Employee	6 times Basic Yearly Earnings Not to Exceed $500,000 max ($10,000 increments)

Employee Guaranteed Issue: $100,000

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

10|STD Benefits

Tempe Union High School District - RFP# 27-011CH-32

Short Term Disability Coverage Summary

Effective July 1, 2027

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

Complete the grid indicating any difference in benefit design offered. Please leave cells BLANK if proposed plan design offered is the same as requested.

Plan Design	Current/Requested	Proposed
Short Term Disability
Eligibility	Employees of TUHSD who work a minimum of 30 hours per week
Gross Disability Benefit	66.67% of Weekly Covered Earnings
Maximum Benefit	$800 per week
Minimum Benefit	$0 per week
Elimination Period	60 days accident / sickness
Maximum Benefit Period	18 weeks

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

12|Credits and Allowances Tempe Union High School District - RFP# 27-011CH-32

Credits and Allowances

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

Provide the amount of proposed credits and allowances in the indicated area.

Confirm that at the Client's discretion, the credits and allowances may be maintained as a single fund to encompass the initiatives which include but are not limited to the following:

Credits and Allowances	Vendor Response
Procurement Allowance
Initial and Ongoing Implementation Allowance
Implementation Audit Allowance
Compliance Review Allowance
Training/Client Summit Allowance
Communication Allowance

Comments:

This Request For Proposal form is the sole property of Segal and is not intended to be reproduced for any purpose other than review by the Plan Sponsor contracted with Segal to prepare a procurement analysis. This file cannot be copied or reproduced in any method without the written consent by Segal.

13|Performance Guarantees Tempe Union High School District - RFP# 27-011CH-32

Performance Guarantees

Authorized Signature

Authorized Name

Offeror Name

Date

Contact Email and Phone Number

For the following categories, provide the performance standard you are willing to offer, the financial penalty (maximum dollar amount or % of administrative fees) you will agree to pay if the standard is not met.

	Performance Guarantee	Frequency	Agree to comply with Performance Guarantee?
(Y \| N)	Dollars at Risk (% or $)
	1. Contractor attendance at Client meetings	Quarterly
	Attendance by Contractor representatives when requested at meetings scheduled by the Client during the contract period and implementation phase.
	2. Contractor call (or e-mail) return timeliness	Quarterly
	The Client or designated consultant’s calls (or e-mails) to Contractor are returned within 24 business hours.
	3. Processing monthly eligibility updates	Monthly
	All updates to eligibility or enrollment records will be made within three business days after the information is received by the Contractor.
	4. Telephone call availability & answering speed	Monthly
	90% of all calls are answered within 30 seconds (based on Client specific results).
	5. Telephone call on-hold (in-queue) time	Monthly
	An average of less than 2 minute(s) on hold before a human being answers.
	6. Telephone Abandonment Rate	Monthly
	An abandonment rate of less than 3% is maintained during standard business hours (based on Client specific results).
	7. Claims Processing Accuracy	Quarterly
	Process 98% of clean claims within an average of twelve (12) calendar days. This standard will be measured quarterly .
	8. Claims Processing Turnaround Time	Quarterly
	At least 99% of claims dollars submitted for payment will be accurately processed and paid. Financial accuracy will be based on Contractor’s self-reported numbers using Client specific claims and as verified through any claims audit conducted by the Client and/or their selected auditor.
	7. Account Management	Quarterly
	a. Arrange and conduct meetings with the Client regarding outstanding issues at pre-determined, mutually agreeable time intervals.
	b. Address and identify resolution of all Client administrative, plan management, and miscellaneous issues/problems within one week of notification of such issue.
	c. Contractor shall conduct an annual account management satisfaction survey/score card.
	d. Account Management Scorecard (to be determined jointly by the Client and Contractor).
	e. Account Team Scorecard (to be determined jointly by the Client and Contractor).
	8. Timeliness of Reports	Annually
	Provide accounting and statistical reports to the Client on a quarterly cadence and upon request by the Client within 10 days of the end of quarter or request for report.
	9. Implementation	Annually
	a. A contract draft will be provided within 60 business days following receipt of employer approval of contract language and all completed application materials and binder check.
	b. Enrollment materials for all eligible participants under the Plan will be delivered in accordance with the agreed upon Implementation Schedule/Calendar.
	c. Policy and certificate delivery to participants will occur prior to the effective date of coverage.
	c. Implementation is completed 60 days prior to open enrollment and the implementation manager shall continue to support the Client for 45 days after the implementation effective date of January 1.
	d. Successful implementation as defined by key milestones. Measurable milestones are included in your proposal.
	10. Communication Materials	Annually
	a. Mail a welcome packet to new participants within five (5) business days of receiving the Client's enrollment file.
	b. Submit copies of all Plan Participant communication materials and promotional materials to the Client for review and approval prior to distribution.

Comments:

14|Ratings

Tempe Union High School District - RFP# 27-011CH-32

Ratings

Independent Rating Agency
Ratings	AM Best	Standard & Poor's	Moody's	Other
Rating
Rating Date

Unauthorized replication or use of this financial workbook is prohibited.

This file cannot be copied or reproduced in any method without the written consent by Segal.

Master

CITY OF PHOENIX - RFP HR 23-003

image1.emf image2.emf image3.emf

File details come from the government source that posted it. Updated Oct 29, 2026.