Attachment C, Price Sheet.xlsx
XLSX spreadsheet 65 KB Posted
- Attached to
- Government Crime Insurance
- Solicitation number
- ITB-17050
- Issued by
- Florida
About this file
This is a Price Sheet attachment for a Government Crime Insurance Invitation to Bid (ITB No. 27-84131514) issued by the Florida Department of Management Services on behalf of multiple state agencies and universities. The solicitation seeks a single broker to provide comprehensive crime insurance coverage for state entities including the Department of Education, Department of Revenue, Department of State, Florida universities (UF, FSU, USF, FAMU, etc.), and various other state agencies. The coverage includes employee theft blanket protection for 95,753 total employees across participating agencies, excess employee theft coverage, faithful performance of duty bonds, forgery and alteration coverage, inside money and securities coverage up to $50.7 million, inside robbery coverage up to $1.5 million, and outside premises coverage up to $52.1 million. Brokers may submit pricing for one to five consecutive policy periods beginning January 1, 2027 through January 1, 2032, with each policy period covering a 12-month term.
Pricing must be submitted on the locked Excel Price Sheet with all premiums based on commission-based broker compensation rather than broker fees, with pricing evaluated on an equal basis across all bidders. Brokers must provide annual premiums for each insuring agreement, identify any statutorily required assessments as a percentage of premium subtotal, itemize additional fees such as policy or inspection fees, and ensure all coverage premiums assessed at policy inception remain fixed for the full policy period without changes. The Price Sheet automatically calculates a Discounted Premium using a 2.30% inflation rate from the Survey of Professional Forecasters and a Calculated Premium representing the average of discounted premiums across the bid period for scoring purposes. Surplus lines tax fees are prohibited under Florida Statutes, and terrorism risk insurance pricing should not be included. No alterations to the Price Sheet specifications are permitted, and the completed file must be uploaded in its original Microsoft Excel format, not converted to PDF or other formats.
View the file
Other files
Show all 15
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. 27-84131514-ITB |
| Government Crime Insurance |
| Attachment C |
| Price Sheet Instructions |
| 1. Brokers will download the Microsoft® Excel file Attachment C, Price Sheet. Bidders must provide pricing on Attachment C, Price Sheet, in accordance with these Price Sheet |
| instructions. |
2. The Price Sheet is locked and will move automatically to the areas highlighted in yellow where information is requested.
3. Brokers are required to supply accurate and complete information. Pricing must be based upon the coverage outlined in the ITB and current market rates.
| 4. Annual Premiums offered must be based on a commission-based Broker compensation, so that pricing can be evaluated on an equal basis. No Broker fee shall be accepted in |
| place of commission. Commission earned should be reported as part of the selected Insurer quotation documents. |
| 5. The Bidder shall adhere to the annual premium(s) listed in the Price Sheet as submitted, which shall be incorporated by reference into the Contract. All coverage premiums assessed |
| at Policy inception are fixed for the full Policy Period and shall not change. |
6. The input of Premiums and assessments and/or fees by a Bidder for Policy Periods 1, 2, 3, 4 and 5 must be as described in these instructions
| 7. A Bidder may provide pricing for either Policy Period 1; Policy Periods 1 and 2; Policy Periods 1, 2, and 3, Policy Periods 1, 2, 3 and 4, or Policy Periods 1, 2, 3 4 and 5. |
| 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. |
| 8. 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 | Computer and Funds Transfer Fraud | Annual Premium |
| 8 | Money Orders and Counterfeit Money | Annual Premium |
9. The Premium Subtotal is the auto-calculated total of all Premiums for the coverage requirements identified on the Price Sheet for a Policy Period.
| 10. 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. |
11. Brokers should not include Terrorism Risk Insurance (TRIA) premium pricing, as this coverage is not required on this policy.
12. 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.
| 13. 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. |
| 14. The DP for a Policy Period is calculated using the following formulas: | |
| DP for Policy Period 1 (PP1) = PP1 is not discounted. | |
| DP for Policy Period 2 (PP2) = PP2/(1+R)^P1 | |
| DP for Policy Period 3 (PP3) = PP3/(1+R)^P2 | |
| DP for Policy Period 4 (PP4) = PP4/(1+R)^P3 | |
| DP for Policy Period 5 (PP5) = PP5/(1+R)^P4 |
| 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 |
| 2026 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 , Policy Periods 1 and 2; Policy Periods 1, 2, and 3, Policy Periods 1, 2, 3 and 4, or Policy Periods 1, 2, 3 4 and 5. , as submitted by the Bidder. |
15. 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.
| 16. In accordance with section 626.916(1)(a) and (b), F.S., | |
| (a) The premium rate at which the coverage is exported shall not be lower than that rate applicable, if any, in actual and current use by a majority | |
| of the authorized insurers for the same coverage on a similar risk. | |
| (b) The policy or contract form under which the insurance is exported shall not be more favorable to the insured as to the coverage or rate than under similar contracts on file Sundays, and legal holidays if it finds that the use of such special form is not reasonably necessary for the principal purposes of the coverage or that its use would be contrary to the purposes of this Surplus Lines Law with respect to the reasonable protection of authorized insurers from unwarranted competition by unauthorized insurers. | |
| and in actual current use in this state by the majority of authorized insurers actually writing similar coverages on similar risks; except that a coverage may be exported | |
| under a unique form of policy designed for use with respect to a particular subject of insurance if a copy of such form is filed with the office by the surplus lines | |
| agent desiring to use the same and is subject to the disapproval of the office within 10 days of filing such form exclusive of Saturdays, Sundays, and legal holidays | |
| if it finds that the use of such special form is not reasonably necessary for the principal purposes of the coverage or that its use would be contrary to the purposes | |
| of this Surplus Lines Law with respect to the reasonable protection of authorized insurers from unwarranted competition by unauthorized insurers. |
| 17. 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' quotation not being considered. Brokers are reminded that |
| only one Price Sheet should be submitted with the quotation. |
18. Upload this completed Microsoft Excel file within the Sourcing application. Do not convert the Price Sheet to a PDF or any other format.
19. If there is a conflict between this Instructions Tab and the Price Sheet Tab, then the Price Sheet Instructions will control.
https://www.philadelphiafed.org/research-and-data/real-time-center/survey-of-professional-forecasters/historical-data/inflation-forecasts Price Sheet
| Solicitation No. 27-84131514-ITB | ||||||||||||||
| Government Crime Insurance | ||||||||||||||
| Attachment C | ||||||||||||||
| Price Sheet | ||||||||||||||
| Broker Name: | ||||||||||||||
| Policy Period → | 1 | 2 | 3 | 4 | ||||||||||
| The most recent ten-year inflation rate from the Survey of Professional Forecasters (R) → | 2.30% | 2.30% | 2.30% | 2.30% | ||||||||||
| Policy Period 1 1/1/27-1/1/28 | Policy Period 2 1/1/28-1/1/29 | Policy Period 3 1/1/29-1/1/30 | Policy Period 4 1/1/30-1/1/31 | Policy Period 5 1/1/31-1/1/32 | ||||||||||
| 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) | Rate per Person (additional info only if avail) | Annual Premium (required) |
| 38,456 | 57,297.25 | 95,753.25 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| Insuring Agreement #1 - Employee Theft - Total | $ - 0 | $ - 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) | Rate per Person (additional info only if avail) | Annual Premium (required) | ||
| Applies to Employee Theft Insuring Agreement #1 | EXCESS EMPLOYEE THEFT | COMMERCE | 20 | $ 2,000,000.00 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 |
| DOH | 2 | $ 300,000.00 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| Applies to Insuring Agreement #1 - Excess Employee Theft - Total | $ - 0 | $ - 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) | Rate per Person (additional info only if avail) | Annual Premium (required) | |||
| Applies to Employee Theft Insuring Agreement #1 | FAITHFUL PERFORMANCE OF DUTY (FPD) | DHSMV (Tax Collectors) | 67 | $ 4,800,000.00 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 |
| JAC (Process Servers) | 47 | $5,000 per employee | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| JAC (Investigators) | 405 | $5,000 per employee | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| DOH (Nurses) | 2 | $5,000 per employee | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | $ - | $ - 0 | ||
| Applies to Insuring Agreement #1 - FPD - Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| INSURING AGREEMENT 3 | FORGERY AND ALTERATION | NAMED INSURED | COVERAGE LIMIT REQUESTED | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) |
| DOE | $ 100,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| FAMU | $ 250,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| USF | $ 500,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Insuring Agreement #3 - Forgery and Alteration - Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CONVERT TO SCHEDULE COVERAGE | NAMED INSURED | ADDITIONAL COVERAGE LIMITS REQUESTED | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | Annual Premium (required) | |
| INSURING AGREEMENT 4 | INSIDE - MONEY AND SECURITIES | See Convert To Schedule Coverage worksheet | $ 50,700,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| INSURING AGREEMENT 5 | INSIDE ROBBERY | See Convert To Schedule Coverage worksheet | $ 1,500,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| INSURING AGREEMENT 6 | OUTSIDE THE PREMISES | See Convert To Schedule Coverage worksheet | $ 52,130,200.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Insuring Agreements #4 through #6 - Combined Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Premium Sub-Total → $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| ASSESSMENTS OR FEES | ||||||||||||||
| (as applicable) | Assessment (insert name of Assessment & Statute) | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | |||
| Assessment (insert name of Assessment & Statute) | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | ||||
| Assessment (insert name of Assessment & Statute) | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | 0% | $ - 0 | ||||
| Policy Fee (if applicable) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| Inspection Fee (if applicable) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Fees (insert name of Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Premium (TP) → $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Discounted Premium (DP) → $ - 0 NO BID NO BID NO BID NO BID
Calculated Premium (CP) → $ - 0
CONVERT TO SCHEDULE COVERAGE
| Solicitation No. 27-84131514-ITB |
| Government Crime Insurance |
| Attachment C |
| CONVERT TO SCHEDULE COVERAGE |
| Insuring Agreement 4 | Insuring Agreement 5 | Insuring Agreement 6 | Insuring Agreement 7 | Insuring Agreement 8 | |||||
| Inside M&S | Inside Robbery | Outside the Premises | Computer and Funds Transfer Fraud | Money Orders and Counterfeit Money | |||||
| Named Insured | # of Locations | Limit | Deductible | Limit | Deductible | Limit | Deductible | Limit / Deductible | Limit / Deductible |
| ALL LOCATIONS | $ 500,000 | $ 500,000 | $ 500,000.00 | $ 500,000 | $ 500,000 | $ 500,000 | $500,000/$50,000 | $500,000/$10,000 | |
| APD | 4 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | $ 192,000 | $ 500,000 | Not Covered | Not Covered |
| DBPR | 21 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | $ 465,000 | $ 500,000 | Not Covered | Not Covered |
| DEM | 4 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | No Additional Coverage | N/A | Not Covered | Not Covered |
| DMA | 55 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | No Additional Coverage | N/A | Not Covered | Not Covered |
| DOE | 95 | $ 10,000,000 | $ 500,000 | No Additional Coverage | N/A | No Additional Coverage | N/A | Not Covered | Not Covered |
| DOR | 9 | $ 10,000,000 | $ 500,000 | No Additional Coverage | N/A | $ 10,000,000 | $ 500,000 | Not Covered | Not Covered |
| DOS | 4 | $ 2,000,000 | $ 500,000 | No Additional Coverage | N/A | $ 3,731,000 | $ 500,000 | Not Covered | Not Covered |
| DOT | 8 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | No Additional Coverage | N/A | Not Covered | Not Covered |
| FAMU | 4 | $ 900,000 | $ 500,000 | No Additional Coverage | N/A | $ 975,000 | $ 500,000 | Not Covered | Not Covered |
| FDACS | 49 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | $ 9,000,000 | $ 500,000 | Not Covered | Not Covered |
| FDLE | 24 | $ 6,500,000 | $ 500,000 | No Additional Coverage | N/A | $ 6,500,000 | $ 500,000 | Not Covered | Not Covered |
| FDVA | 11 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | No Additional Coverage | N/A | Not Covered | Not Covered |
| FGCU | 4 | $ 900,000 | $ 500,000 | No Additional Coverage | N/A | $ 1,115,000 | $ 500,000 | Not Covered | Not Covered |
| FSDB | 1 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | $ 120,000 | $ 500,000 | Not Covered | Not Covered |
| FSU | 3 | $ 3,000,000 | $ 500,000 | No Additional Coverage | N/A | $ 2,525,000 | $ 500,000 | Not Covered | Not Covered |
| HSMV | 45 | $ 500,000 | $ 500,000 | No Additional Coverage | N/A | $ 1,690,000 | $ 500,000 | Not Covered | Not Covered |
| NCF | 1 | $ 1,000,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 1,005,000 | $ 500,000 | Not Covered | Not Covered |
| PSC | 1 | $ 4,000,000 | $ 500,000 | No Additional Coverage | N/A | $ 4,000,200 | $ 500,000 | Not Covered | Not Covered |
| SBA | 1 | $ 1,000,000 | $ 500,000 | No Additional Coverage | N/A | $ 1,250,000 | $ 500,000 | Not Covered | Not Covered |
| UF | 1 | $ 2,500,000 | $ 500,000 | No Additional Coverage | N/A | $ 7,200,000 | $ 500,000 | Not Covered | Not Covered |
| UNF | 12 | $ 900,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 975,000 | $ 500,000 | Not Covered | Not Covered |
| USF | 13 | $ 2,500,000 | $ 500,000 | No Additional Coverage | N/A | $ 226,791 | $ 500,000 | Not Covered | Not Covered |
| UWF | 3 | $ 1,000,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 1,160,000 | $ 500,000 | Not Covered | Not Covered |
| $ 50,700,000 | $ 1,500,000 | $ 52,129,991 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .