24-84131514-ITB Government Crime Attachment B Price Sheet.xlsx
XLSX spreadsheet 41 KB Posted
- Solicitation number
- ITB-10823
- Issued by
- Leon County, Florida
About this file
This is a price sheet attachment (Attachment B) for a Government Crime Insurance solicitation (ITB No. 24-84131514-ITB) issued by the Florida Department of Management Services. The price sheet requires brokers to provide insurance coverage pricing for four possible policy periods spanning from January 1, 2025 to January 1, 2029, covering multiple state agencies and universities. The coverage requirements include Employee Theft, Excess Employee Theft, Faithful Performance of Duty, Forgery and Alteration, Inside Money and Securities, Inside Robbery, and Outside the Premises coverage for various Florida state entities including universities, departments, and agencies.
The pricing structure requires brokers to submit annual premiums for consecutive policy periods (either Period 1 alone; Periods 1 and 2; Periods 1, 2, and 3; or all four periods). The price sheet includes specific coverage limits such as $2 million for DEO excess employee theft, $4.8 million for DHSMV faithful performance duty, and varying limits for different agencies' forgery and alteration coverage (ranging from $100,000 to $500,000). Inside Money and Securities coverage totals $50.9 million, while Outside the Premises coverage amounts to $52.9 million across 369 locations. Pricing calculations include a 2.30% inflation rate adjustment factor, and terrorism risk insurance (TRIA) premium pricing is explicitly excluded.
View the file
Other files
Show all 16
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
| Solicitation No. 24-84131514-ITB |
| Government Crime Insurance |
| Attachment B |
tc={50813810-3ED7-4EE4-9D41-4F6DECD99142}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
@Soderberg, Jill - is it attachment G or 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. The input of Premiums and assessments and/or fees by a Bidder for Policy Periods 1, 2, 3 and 4 must be as described in these instructions
| 5. A Bidder may provide pricing for either Policy Period 1; Policy Periods 1 and 2; Policy Periods 1, 2, and 3 or Policy Periods 1, 2, 3 and 4. 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. |
| 6. For each Policy Period bid, Brokers will provide an annual premium for each of the insuring agreements listed below. | ||
| Insuring Agreement | Coverage Requirements | Pricing Requirement |
| 1 | Employee Theft - All Employees Blanket Coverage | Annual Premium |
| applies to 1 above | Excess Employee Theft | Annual Premium (rate per person if applicable) |
| applies to 1 above | Faithful Performance of Duty | Annual Premium (rate per person if applicable) |
| 3 | Forgery and Alteration | Annual Premium |
| 4, 5 and 6 | Inside the Premises M&S; Inside Robbery & Safe; Outside Premises | Annual Premium |
7. The Premium Subtotal is the auto-calculated total of all Premiums for the coverage requirements identified on the Price Sheet for a Policy Period.
| 8. 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. |
9. Brokers should not include Terrorism Risk Insurance (TRIA) premium pricing, as this coverage is not required on this policy.
10. 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.
| 11. 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. |
| 12. 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) | |
| DP for Policy Period 3 (PP3) = TP for PP3 ÷ (1 + R)2 | |
| DP for Policy Period 4 (PP4) = TP for PP4 ÷ (1 + R)3 | |
| 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 |
| 2024 Q3 2.30% |
| 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. |
13. 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.
| 14. 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. |
15. Upload this completed Microsoft Excel file within the Sourcing application. Do not convert the Price Sheet to a PDF or any other format.
16. 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
| Solicitation No. 24-84131514-ITB | ||||||||||||
| Government Crime Insurance | ||||||||||||
| Attachment B | ||||||||||||
| Price Sheet | ||||||||||||
| Broker Name: | ||||||||||||
| Policy Period → | 1 | 2 | 3 | |||||||||
| The most recent ten-year inflation rate from the Survey of Professional Forecasters (R) → | 2.30% | 2.30% | 2.30% | |||||||||
| Policy Period 1 1/1/25-1/1/26 | Policy Period 2 1/1/26-1/1/27 | Policy Period 3 1/1/27-1/1/28 | Policy Period 4 1/1/28-1/1/29 | |||||||||
| INSURING AGREEMENT 1 | EMPLOYEE THEFT - ALL EMPLOYEES BLANKET COVERAGE | Class 1 Employees | All Other Employees | Total Employees | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) |
| 35,685 | 60,608.00 | 96,292.50 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| Insuring Agreement #1 - Employee Theft - Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NAMED INSURED | No. of Employees | COVERAGE LIMIT REQUESTED | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | |||
| Applies to Employee | |||||||||||||
| Theft Insuring Agreement #1 | EXCESS EMPLOYEE THEFT | DEO | 20 | $ 2,000,000.00 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | |
| DOH | 6 | $ 300,000.00 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | |||
| Applies to Insuring Agreement #1 - Excess Employee Theft - Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NAMED INSURED | COVERAGE LIMIT REQUESTED | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | Rate per Person (additional info only if avail) | Annual Premium (required) | |||
| Applies to Employee Theft Insuring Agreement #1 | FAITHFUL PERFORMANCE OF DUTY (FPD) | DHSMV | 67 | $ 4,800,000.00 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 |
| JAC (Process Servers) | 26 | $5,000 per employee | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| JAC (Investigators) | 429.0 | $5,000 per employee | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| DOH (Nurses) | 6 | $5,000 per employee | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| Applies to Insuring Agreement #1 - FPD - Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| INSURING AGREEMENT 3 | FORGERY AND ALTERATION | NAMED INSURED | LIMIT | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) |
| DOE | $ 100,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| FAMU | $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| USF | $ 500,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Insuring Agreement #3 - Forgery and Alteration - Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CONVERT TO SCHEDULE see TDD - Inside Outside Premises worksheet contained in this price sheet workbook | NAMED INSURED | ADDITIONAL LIMITS | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | |
| INSURING AGREEMENT 4 | INSIDE - MONEY AND SECURITIES | Refer to TDD - Inside Outside Premises | $ 50,900,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| INSURING AGREEMENT 5 | INSIDE ROBBERY | DEM, NCF, UNF and UWF ONLY | $ 2,000,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| INSURING AGREEMENT 6 | OUTSIDE THE PREMISES | Refer to TDD - Inside Outside Premises | $ 52,939,991.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Insuring Agreements #4, #5, and #6 - Combined Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Premium Sub-Total → $ - 0 $ - 0 $ - 0 $ - 0
| ASSESSMENTS OR FEES | |||||||||||||
| (as applicable) | Assessment (insert name of Assessment & Statute) | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | ||||
| Assessment (insert name of Assessment & Statute) | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | |||||
| Assessment (insert name of Assessment & Statute) | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | |||||
| Policy Fee (if applicable) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Inspection Fee (if applicable) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Fees (insert name of Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Premium (TP) → $ - 0 $ - 0 $ - 0 $ - 0
Discounted Premium (DP) → $ - 0 NO BID NO BID NO BID
Calculated Premium (CP) → $ - 0
Convert Sch TDD Inside Outside
| CONVERT TO SCHEDULE COVERAGE | |||||
| ADDITONAL COVERAGE LIMIT REQUESTED | |||||
| NI | # of Locations | Inside M&S | Inside Robbery | Outside the Premises | |
| ANY | |||||
| APD | Agency for Persons with Disabilities | 4 | $ 500,000.00 | $ - 0 | $ 192,000.00 |
| DACS | Department of Agriculture and Consumer Services | 50 | $ 500,000.00 | $ - 0 | $ 9,000,000.00 |
| DBPR | Department of Business and Professional Regulation | 20 | $ 500,000.00 | $ - 0 | $ 465,000.00 |
| DHSMV | Department of Highway Safety and Motor Vehicles | 51 | $ 500,000.00 | $ - 0 | $ 1,690,000.00 |
| DMA | Department of Military Affairs | 55 | $ 500,000.00 | $ - 0 | $ - 0 |
| DEM | Department of Emergency Management | 5 | $ - 0 | $ 500,000.00 | $ - 0 |
| DOE | Department of Education | 95 | $ 10,000,000.00 | $ - 0 | $ - 0 |
| DOR | Department of Revenue | 9 | $ 10,000,000.00 | $ - 0 | $ 10,000,000.00 |
| DOS | Department of State | 4 | $ 2,000,000.00 | $ - 0 | $ 3,731,000.00 |
| DOT | Department of Transportation | 16 | $ 500,000.00 | $ - 0 | $ - 0 |
| DVA | Department of Veterans Affairs | 11 | $ 500,000.00 | $ - 0 | $ - 0 |
| FAMU | Florida Agricultural and Mechanical University | 4 | $ 900,000.00 | $ - 0 | $ 975,000.00 |
| FAU | Florida Atlantic University | 4 | $ 700,000.00 | $ - 0 | $ 810,000.00 |
| FDLE | Florida Department of Law Enforcement | 1 | $ 6,500,000.00 | $ - 0 | $ 6,500,000.00 |
| FGCU | Florida Gulf Coast University | 4 | $ 900,000.00 | $ - 0 | $ 1,115,000.00 |
| FSDB | Florida School for the Deaf and Blind | 1 | $ 500,000.00 | $ - 0 | $ 120,000.00 |
| FSU | Florida State University | 3 | $ 3,000,000.00 | $ - 0 | $ 2,525,000.00 |
| NCF | New College of Florida | 1 | $ 1,000,000.00 | $ 500,000.00 | $ 1,005,000.00 |
| PSC | Public Service Commission | 1 | $ 4,000,000.00 | $ - 0 | $ 4,000,200.00 |
| SBA | State Board of Administration of Florida | 1 | $ 1,000,000.00 | $ - 0 | $ 1,250,000.00 |
| UF | University of Florida | 1 | $ 2,500,000.00 | $ - 0 | $ 7,200,000.00 |
| UNF | University of North Florida | 12 | $ 900,000.00 | $ 500,000.00 | $ 975,000.00 |
| USF | University of South Florida | 13 | $ 2,500,000.00 | $ - 0 | $ 226,791.00 |
| UWF | University of West Florida | 3 | $ 1,000,000.00 | $ 500,000.00 | $ 1,160,000.00 |
Total 369 $ 50,900,000.00 $ 2,000,000.00 $ 52,939,991.00
File details come from the government source that posted it. Updated .