24-0094_Exhibit A_Pricing Specifications Guideline_03192025_Final.xlsx
XLSX spreadsheet 22 KB Posted
- Contract number
- 24-557THA-FINAN-P-88861
- Issued by
- Illinois
About this file
This document is a Pricing Specifications Guideline (Exhibit A) for a state and local insurance contract, specifically an Excel spreadsheet detailing pricing options for various insurance coverage programs. The document appears to be related to a comprehensive insurance procurement process, with multiple coverage types and pricing structures being evaluated.
The contract covers multiple insurance lines including medical, dental, vision, life insurance, commercial general liability, cyber liability, property insurance, equipment breakdown, public officials bond, and business travel insurance. Three distinct pricing options are presented: Option 1 involves a detailed breakdown of flat fees and commission percentages for different insurance categories, Option 2 proposes a flat fee for all programs, and Option 3 offers a commission percentage approach for all programs. The total estimated insurance coverage spans approximately $753,114,281 across various policy terms, with estimated annual insurance premiums of $4,974,528. The initial contract term is 5 years, with potential renewal periods, and coverage effective dates range from January 1st to June 1st across different insurance types.
View the file
Other files
Show all 17
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
SUMMARY
| SUMMARY | |||
| OPTION 1: TABLE A - FLAT FEE EMPLOYEE BENEFITS | Option 1: initial Term Table Total | $0.00 | |
| Initial 5 Year Term Grand Total | $0.00 | Option 1: Renewal Term Table Total | $0.00 |
| Renewal 5 Year Term Grand Total | $0.00 | Option 2: initial Term Total | $0.00 |
| Option 2: Renewal Term Total | $0.00 | ||
| OPTION 1: TABLE B - FLAT FEE LIABILITY | Option 3: initial Term Total | $0.00 | |
| Initial 5 Year Term Grand Total | $0.00 | Option 3: Renewal Term Total | $0.00 |
| Renewal 5 Year Term Grand Total | $0.00 | ||
| Option 1: Grand Total | $0.00 | ||
| OPTION 1: TABLE C - COMMISION PERCENTAGE PROGRAMS | Option 2: Grand Total | $0.00 | |
| Initial 5 Year Term Grand Total | $0.00 | Option 3: Grand Total | $0.00 |
| Renewal 5 Year Term Grand Total | $0.00 | $0.00 |
| OPTION 2: FLAT FEE FOR ALL PROGRAMS | |
| Initial 5 Year Term Grand Total | $0.00 |
| Renewal 5 Year Term Grand Total | $0.00 |
| OPTION 3: COMMISION PERCENTAGE FOR ALL PROGRAMS | |
| Initial 5 Year Term Grand Total | $0.00 |
| Renewal 5 Year Term Grand Total | $0.00 |
Pricing Tables Read Carefully - SECTION F: PROPOSAL FORMS Bookmark 9 - Pricing Section F.6 Pricing
Offeror shall upload Exhibit A under the “Required Documents” section of the Attachments tab and check the box "Does the attachment contain any pricing, cost or discount information?"
Failure to check this box allows your pricing to be viewed when the bids are opened and may result in disqualification of your offer.
Note: Do not enter cost, pricing, or any discount information in the Alternate Description field. Entering cost, pricing or discount information in the Alternate Description may result in disqualification. Instructions for Completing the Pricing Specifications Guideline (Exhibit A):
- Offeror must provide pricing for all Three (3) Options listed below, to include Commission Percentage, Flat Fee or combination of both. Complete each option for the Initial and Renewal Terms.
- Failure to provide pricing for all options will result in disqualification of your offer.
- Failure to provide pricing in any required fields, or marking "N/A", "Zero", "0.00" or "Blank", will result in disqualification of your offer.
Reference the RFP sections F.6.1.1., F.6.1.2., and F.6.1.4. for additional details.
| OPTION 1: (1 of 3 tables) | |||||
| TABLE A - FLAT FEE EMPLOYEE BENEFITS | |||||
| Benefits are generally reviewed as a group. Therefore, determine the monthly flat fee that would be required to discuss any of these items at any time. Calulate the monthly flat rate times 12 to enter the yearly rate. | Initial Term | Renewal Term | |||
| Estimated Type of Coverage | Policy Term | Estimated Premiums for One (1) Year | Annual Flat Fee | ||
| Initial Term - year One (1) | Annual Flat Fee | ||||
| Initial Term - year Two (2) | Annual Flat Fee | ||||
| Initial Term - year Three (3) | Annual Flat Fee | ||||
| Initial Term - year Four (4) | Annual Flat Fee Initial Term - year Five (5) | Annual Flat Fee | |||
| Renewal year - One (1) | Annual Flat Fee | ||||
| Renewal year - Two (2) | Annual Flat Fee | ||||
| Renewal - Three (3) | Annual Flat Fee | ||||
| Renewal year - Four (4) | Annual Flat Fee |
Renewal year - Five (5)
| Medical and Dental | March 1st-March 1st | $37,000,000 | ||||||||||
| Vision | March 1st-March 1st | $427,000 | ||||||||||
| Cobra | March 1st-March 1st | $30,000 | ||||||||||
| FSA and Commuter Benefits | March 1st-March 1st | $65,000 | ||||||||||
| Life Insurance | March 1st-March 1st | $540,000 | ||||||||||
| Yearly Sub Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Initial 5 Year Term Grand Total | $0.00 | |||||||||||
| Renewal 5 Year Term Grand Total | $0.00 |
| OPTION 1: (2 of 3 tables) | |||||
| TABLE B - FLAT FEE LIABILITY | |||||
| General Liability is usually reviewed as a group. Therefore, determine the monthly flat fee that would be required to discuss any of these items at any time. Calulate the monthly flat rate times 12 to enter the yearly rate. | Initial Term | Renewal Term | |||
| Estimated Type of Coverage | Policy Term | Estimated Amount of Coverage | Annual Flat Fee | ||
| Initial Term - year One (1) | Annual Flat Fee | ||||
| Initial Term - year Two (2) | Annual Flat Fee | ||||
| Initial Term - year Three (3) | Annual Flat Fee | ||||
| Initial Term - year Four (4) | Annual Flat Fee | ||||
| Initial Term - year Five (5) | Annual Flat Fee | ||||
| Renewal year - One (1) | Annual Flat Fee | ||||
| Renewal year - Two (2) | Annual Flat Fee | ||||
| Renewal - Three (3) | Annual Flat Fee | ||||
| Renewal year - Four (4) | Annual Flat Fee |
Renewal year - Five (5)
| Commercial General Liability/ Auto Liability including excess layers | June 1st-June 1st | $150,000,000 | ||||||||||
| Commercial Auto (First layer) | June 1st-June 1st | $5,000,000 | ||||||||||
| Cyber Liability | Jan 1st-Jan 1st | $10,000,000 | ||||||||||
| Yearly Sub Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Initial 5 Year Term Grand Total | $0.00 | |||||||||||
| Renewal 5 Year Term Grand Total | $0.00 |
| OPTION 1: (3 of 3 tables) | ||||
| TABLE C - COMMISSION PERCENTAGE PROGRAMS | Initial Term | Renewal Term | ||
| Estimated Type of Coverage | Policy Term | Estimated Amount of Coverage | Estimated Annual |
Insurance Premium Initial Five (5) Year Term Commission Percentage (percentage should be entered as a decimal)
| Initial Term Total | Estimated Annual Commission in Dollars |
| Initial Five (5) Year Term | Estimated Annual |
Insurance Premium Renewal Five (5) Year Term Commission Percentage (percentage should be entered as a decimal) Renewal Term Total Estimated Annual Commission in Dollars Renewal Five (5) Year Term
| Property Insurance | April 1st-April 1st | $100,000,000 | $2,272,635 | $0.00 | $2,272,635 | $0.00 |
| Property Insurance-Terrorism Buy Back | April 1st-April 1st | $100,000,000 | ||||
| Property Insurance-Excess Earthquake | April 1st-April 1st | $50,000,000 | ||||
| Property Insurance-Auto Physical Damage | April 1st-April 1st | $10,000,000 | ||||
| Property Insurance-CA Facility | April 1st-April 1st | $7,552,281 | ||||
| Equipment Breakdown | August 1st-August 1st | $125,000,000 | $24,418 | $0.00 | $24,418 | $0.00 |
| Public Officials Bond | Various Terms | $100,000 | $228 | $0.00 | $228 | $0.00 |
| Rolling Owner Controlled Insurance Program (Liability only) | Jan 1st-Jan 1st (various terms) | $25,000,000 | $534,084 | $0.00 | $534,084 | $0.00 |
| Business Travel Account | Nov 1st-Oct 31st - (various terms) | $2,500,000 | $12,653 | $0.00 | $12,653 | $0.00 |
| Contingency for any other insurance as needed for operations (ie.., Railroad Protective, OCIP, Contractor Pollution…) | Various Terms | $130,000,000 | $9,057,065 | $0.00 | $9,057,065 | $0.00 |
| 5 Year Term Grand Total | $59,505,415.88 | $0.00 | $59,505,415.88 | $0.00 | ||
| Initial 5 Year Term Grand Total | $0.00 | |||||
| Renewal 5 Year Term Grand Total | $0.00 |
| OPTION 2: FLAT FEE FOR ALL PROGRAMS | Initial Term | Renewal Term | ||
| Estimated Type of Coverage | Policy Term | Estimated Amount of Coverage | Estimated Annual |
Insurance Premium Initial Five (5) Year Term Estimated Annual Total Flat Fee Initial Five (5) Year Term Estimated Annual Insurance Premium Renewal Five (5) Year Term Estimated Annual Total Flat Fee Renewal Five (5) Year Term
| All Insurance Policies as listed in Option 1 + any additional insurance policies as needed through out the term of the contract. | Various Annual Terms | $753,114,281 | $4,974,528 | $4,974,528 | ||
| 5 Year Term Grand Total | $24,872,638.42 | $0.00 | $24,872,638.42 | $0.00 | ||
| Initial 5 Year Term Grand Total | $0.00 | |||||
| Renewal 5 Year Term Grand Total | $0.00 |
| OPTION 3: COMMISSION PERCENTAGE FOR ALL PROGRAMS | Initial Term | Renewal Term | ||
| Estimated Type of Coverage | Policy Term | Estimated Amount of Coverage | Estimated Annual |
Insurance Premium
| Initial Five (5) Year Term | Commission Percentage |
| (percentage should be entered as a decimal) | Estimated Annual Commission in Dollars |
| Initial Five (5) Year Term | Estimated Annual |
Insurance Premium
| Renewal Five (5) Year Term | Commission Percentage |
| (percentage should be entered as a decimal) | Estimated Annual Commission in Dollars |
Renewal Five (5) Year Term
| All Insurance Policies as listed in Option 1 + any additional insurance policies as needed through out the term of the contract. | Various Annual Terms | $753,114,281 | $4,974,528 | $0.00 | $4,974,528 | $0.00 |
| 5 Year Term Grand Total | $24,872,638.42 | $0.00 | $24,872,638.42 | $0.00 | ||
| Initial 5 Year Term Grand Total | $0.00 | |||||
| Renewal 5 Year Term Grand Total | $0.00 |
File details come from the government source that posted it. Updated .