2023 Attachment B Price Sheet.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Accident and Sickness (CAMP) Insurance ITB
- Solicitation number
- ITB-03867
- Issued by
- Florida
About this file
This document is the Price Sheet Instructions and Price Sheet for the Invitation to Bid (ITB) 23-84131600-ITB Accident and Sickness (Camp) Insurance issued by the State of Florida. The ITB requests pricing for Accident and Sickness (Camp) Insurance coverage for three policy periods from March 15, 2023 to March 15, 2026. The Price Sheet requires brokers to provide pricing for various options including primary and excess coverage, with or without sickness, for non-sports, sports, and year-round participants. Brokers may bid on Policy Period 1, Periods 1 and 2, or Periods 1, 2, and 3, but cannot bid on other combinations. The estimated number of participants ranges from 50 to 15,809 across the 12 coverage options.
The Price Sheet requires brokers to provide the Annual Premium, any applicable assessments or fees, and the calculated Total Premium for each policy period. The Discounted Premium and Calculated Premium will be used for bid scoring purposes. Brokers must follow the provided instructions and cannot alter the Price Sheet. The selected broker will not be allowed to impose any fees not listed on the Price Sheet unless required by statute.
View the file
Other files
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
Price Sheet Instructions
| ITB: 23-84131600-ITB |
| Accident and Sickness (Camp) Insurance |
| Attachment B |
| Price Sheet Instructions |
| 1 | Brokers will download the Microsoft® Excel file Attachment B, Price Sheet. Review and follow these instructions and the general information as provided in the Price Sheet. |
| 2 | Brokers are required to supply accurate and complete information. Pricing must be based upon the coverage outlined in the ITB and current market rates. |
| 3 | The Price Sheet is locked and will move automatically to the areas highlighted in yellow where information is requested. |
| 4 | A Bidder may provide pricing for either Policy Period 1; Policy Periods 1 and 2; or Policy Periods 1, 2, and 3. No other combination of Policy Periods will be accepted or scored by the Department. Failure to provide consecutive pricing will result in the Bid being deemed non-responsive. Information regarding how the the pricing provided will be scored is specified in the ITB, with specifics in ITB Section 2.8, Basis of Award. |
| 5 | For each Policy Period bid, Brokers will provide an Annual Premium for Accident and Sickness (Camp) Insurance. |
| 6 | The Premium Subtotal is the auto-calculated total of all Premiums for the coverage requirements identified on the Price Sheet for a Policy Period. |
| 7 | If there are any assessments or fees associated with the proposed Insurance Policy, they must be identified as follows: |
| a. If any statutorily required and authorized assessments are to be included, identify the name of that assessment, and its applicable percentage of the premium subtotal associated with the applicable Policy Period. The Price Sheet will auto-calculate the associated cost for the assessment for that Policy Period. | |
| b. Any other fee shall be identified by name; and Broker will input the total annual cost of that fee for the Policy Period quoted. | |
| c. For an inspection fee, if applicable, a Broker must input the associated total annual cost for the Policy Period quoted. | |
| d. In accordance with subsection 626.932(4), Florida Statutes, surplus lines tax fees shall not be assessed. | |
| 8 | Brokers should not include Terrorism Risk Insurance (TRIA) premium pricing, as this coverage is not required on this policy. |
| 9 | The Total Premium (TP) is the auto-calculated total of the Premium Subtotal for a Policy Period, plus any amounts for assessments and/or fees bid for that Policy Period. |
| 10 | The price sheet automatically calculates the Discounted Premium (DP) and Calculated Premium (CP) are automatically calculated on the Price Sheet based on information input by a Bidder. The DP and CP are for scoring of the Bidder’s Price Sheet only and will not become part of any resulting awarded Contract. |
| 11 | The DP for a Policy Period is calculated using the following formulas: |
| DP for Policy Period 1 (PP1) = TP for PP1 | |
| DP for Policy Period 2 (PP2) = TP for PP2 ÷ (1 + R)1 | |
| DP for Policy Period 3 (PP3) = TP for PP3 ÷ (1 + R)2 |
| Where: | |
| R = The most recent ten-year inflation rate from the most recent Survey of Professional Forecasters. Percentages are expressed as decimals for calculation purposes | |
| https://www.philadelphiafed.org/research-and-data/real-time-center/survey-of-professional-forecasters/historical-data/inflation-forecasts | |
| 2022 Q3 2.80% | |
| To calculate the CP for a Bid for Policy Period 1 only, the CP is equal to the DP. | |
| To calculate the CP for a Bid for multiple Policy Periods, the CP is the AVERAGE of the DP’s for Policy Periods 1, 2, and 3 as submitted by the Bidder. | |
| 12 | The selected Broker will not be allowed to impose any fee not listed in the Price Sheet for a Policy Period, unless required by statute. |
| 13 | Other than providing the requested quotation information within the Price Sheet, the responding Broker may not alter the information, specifications, or contents of the Price Sheet, as created by the Department. Any such alteration of the Price Sheet specifications or contents may result in the Brokers's quotation not being considered. Brokers are reminded that only one Price Sheet should be submitted with the quotation. |
| 14 | Upload this completed Microsoft Excel file within the MFMP Sourcing application. Do not convert the Price Sheet to a PDF or any other format. |
| 15 | If there is a conflict between this Instructions Tab and the Price Sheet Tab, then the Instructions Tab will control. |
https://www.philadelphiafed.org/research-and-data/real-time-center/survey-of-professional-forecasters/historical-data/inflation-forecasts
PRICE SHEET
| ITB: 23-84131600-ITB |
| State of Florida Accident & Sickness (CAMP) Insurance Policy |
| Attachment B |
| Price Sheet |
Broker
| Policy Period (PP) | Period ® | 1 | 2 | ||||||
| The most recent 10 year Inflation rate from the survey of professional forcasters ( R ) | Rate ® | 2.80% | 2.80% | ||||||
| Coverage | Policy Period 1 3/15/23-3/15/24 | Policy Period 2 3/15/24-3/15/25 | Policy Period 3 3/15/25-3/15/26 | ||||||
| # | Plan / Options | Estimated # of Participants | Average # of Days | Price Per Person Per Day | Estimated Premium | Price Per Person Per Day | Estimated Premium | Price Per Person Per Day | Estimated Premium |
| 1 | Option 1: Primary (no sickness) - Non-Sports | 889 | 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2 | Option 1: Primary (no sickness) - Sports | 154 | 13 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 3 | Option 1: Primary (no sickness) - Year Round | 50 | 365 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 4 | Option 2: Excess (no sickness) - Non-Sports | 1640 | 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 5 | Option 2: Excess (no sickness) - Sports | 15809 | 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 6 | Option 2: Excess (no sickness) - Year Round | 70 | 365 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 7 | Option 3: Primary with sickness - Non-Sports | 1333 | 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 8 | Option 3: Primary with sickness - Sports | 621 | 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 9 | Option 3: Primary with sickness - Year Round | 74 | 365 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10 | Option 4 : Excess with sickness - Non-Sports | 773 | 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 11 | Option 4: Excess with sickness - Sports | 2579 | 23 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 12 | Option 4: Excess with sickness - Year Round | 166 | 365 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Premium Sub-Total $ - 0 $ - 0 $ - 0
| Assessments or Fees (as applicable) | ||||||
| Assessment (insert name of Assessment & Statute) | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| Assessment (insert name of Assessment & Statute) | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| Assessment (insert name of Assessment & Statute) | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 |
| Policy Fee (if applicable) | $ - 0 | $ - 0 | $ - 0 | |||
| Inspection Fee (if applicable) | $ - 0 | $ - 0 | $ - 0 | |||
| Fees (insert name of Fee) | $ - 0 | $ - 0 | $ - 0 |
Total Premium ® $ - 0 $ - 0 $ - 0
Discounted Premium ® $ - 0 NO BID NO BID
Calculated Premium® $ - 0
Sheet3
File details come from the government source that posted it. Updated .