25-84131512-ITB EDP Attachment C Price Sheet.xlsx

XLSX spreadsheet 30 KB Posted

Attached to
Electronic Data Processing Equipment Insurance State and local contract opportunity
Solicitation number
ITB-12233
Issued by
Leon County, Florida

About this file

This is an Invitation to Bid (ITB) No. 25-84131512 issued by the Florida Department of Management Services for Electronic Data Processing Equipment Insurance, targeting non-Agency state entities with a Department of Financial Services State Risk Management Trust Fund Certificate. The multi-year contract seeks a broker to secure an insurance policy covering electronic data processing and scientific/medical equipment for various state agencies, universities, and legislative offices, with a total insured value of $378,793,546.61 and an anticipated contract start date of June 5, 2025. The procurement timeline includes vendor questions due by April 17, 2025, and bids due by May 7, 2025, at 2:00 PM Eastern Time, with a public bid opening at 2:15 PM. The contract will be for a one-year term with potential options for additional policy periods if pricing was originally provided.

The price sheet requires brokers to submit rates per $100 of total insured value across five equipment categories, including owned and leased electronic data processing, medical, and scientific equipment. Historical data shows an average annual premium of $203,132, with current policy rates of $0.04 per $100 for owned equipment and $0.360343 per $100 for leased equipment. Bidders must meet mandatory requirements, including possessing a valid insurance transaction certificate, having 10 years of insurance placement experience, and maintaining current licenses. The current policy is administered through Federal Insurance Company, with claims managed by ONE80 Intermediaries Inc., and historical loss reports indicate 98 claims over a 10-year period totaling $267,685. The Department reserves the right to make no award if determined to be in the state's best interest.

View the file

Other files for this state and local contract opportunity

Other files attached to Electronic Data Processing Equipment Insurance, newest first.
File Type Posted
25-84131512-ITB EDP Attachment A Scope of Work.pdf PDF
25-84131512-ITB EDP Attachment B Mandatory Responsive.pdf PDF
25-84131512-ITB EDP Attachment H Draft Contract.pdf PDF
25-84131512-ITB EDP Attachment I PUR 2023.pdf PDF
25-84131512-ITB EDP Attachment J Certfication DF Workplace.pdf PDF
25-84131512-ITB EDP Attachment I PUR 2023.pdf PDF
25-84131512-ITB EDP Attachment N DFS-D0-852 Property Coverage.pdf PDF
25-84131512-ITB EDPE Attachment O EDP and SCI-MED Values and Inventories.xlsx XLSX spreadsheet
25-84131512-ITB EDP Attachment A Scope of Work.pdf PDF
25-84131512-ITB EDP Attachment D ATCs.pdf PDF
25-84131512-ITB EDP Attachment F PUR 1000 GCC.pdf PDF
25-84131512-ITB EDP Attachment L Expiring Policy.pdf PDF
25-84131512-ITB EDP Attachment N DFS-D0-852 Property Coverage.pdf PDF
25-84131512-ITB EDPE Attachment O EDP and SCI-MED Values and Inventories.xlsx XLSX spreadsheet
_25-84131512-ITB EDP ITB Solicitation Document.pdf PDF
25-84131512-ITB EDP Attachment E ESTC 9.12.2024.pdf PDF
25-84131512-ITB EDP Attachment G PUR 7801.docx DOCX document
25-84131512-ITB EDP Attachment K Broker Information.pdf PDF
25-84131512-ITB EDP Attachment L Expiring Policy.pdf PDF
25-84131512-ITB EDP Attachment A Scope of Work.pdf PDF
25-84131512-ITB EDP Attachment D ATCs.pdf PDF
25-84131512-ITB EDP Attachment E ESTC 9.12.2024.pdf PDF
25-84131512-ITB EDP Attachment F PUR 1000 GCC.pdf PDF
25-84131512-ITB EDP Attachment J Certfication DF Workplace.pdf PDF
_25-84131512-ITB EDP ITB Solicitation Document.pdf PDF
25-84131512-ITB EDP Attachment B Mandatory Responsive.pdf PDF
25-84131512-ITB EDP Attachment J Certfication DF Workplace.pdf PDF
25-84131512-ITB EDP Attachment K Broker Information.pdf PDF
25-84131512-ITB EDP Attachment M Historical Loss Report.pdf PDF
25-84131512-ITB EDP Attachment C Price Sheet.xlsx XLSX spreadsheet
25-84131512-ITB EDP Attachment D ATCs.pdf PDF
25-84131512-ITB EDP Attachment F PUR 1000 GCC.pdf PDF
25-84131512-ITB EDP Attachment M Historical Loss Report.pdf PDF
25-84131512-ITB EDP Attachment N DFS-D0-852 Property Coverage.pdf PDF
25-84131512-ITB EDP Attachment G PUR 7801.docx DOCX document
25-84131512-ITB EDP Attachment G PUR 7801.docx DOCX document
25-84131512-ITB EDP Attachment H Draft Contract.pdf PDF
25-84131512-ITB EDPE Attachment O EDP and SCI-MED Values and Inventories.xlsx XLSX spreadsheet
_25-84131512-ITB EDP ITB Solicitation Document.pdf PDF
25-84131512-ITB EDP Attachment B Mandatory Responsive.pdf PDF
25-84131512-ITB EDP Attachment H Draft Contract.pdf PDF
25-84131512-ITB EDP Attachment K Broker Information.pdf PDF
25-84131512-ITB EDP Attachment L Expiring Policy.pdf PDF
25-84131512-ITB EDP Attachment M Historical Loss Report.pdf PDF
25-84131512-ITB EDP Attachment C Price Sheet.xlsx XLSX spreadsheet
25-84131512-ITB EDP Attachment E ESTC 9.12.2024.pdf PDF
25-84131512-ITB EDP Attachment I PUR 2023.pdf PDF
Show all 47

On GovTribe

Work with this file on GovTribe

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

Text version

Price Sheet Instructions

ITB No. 25-84131512-ITB
Electronic Data Processing Equipment Insurance
Attachment C
Price Sheet Instructions
1.Brokers will download the Microsoft® Excel file Attachment C, 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.Brokers will provide a rate per $100 of total insured value (TIV) for each of the lines below:
a.Owned Electronic Data Processing Equipment (including CAMLS)
b.Leased/Rented/Borrowed Electronic Data Processing Equipment (including CAMLS)
c.Owned Medical & Scientific Equipment (including NSTC, Byrd and CAMLS)
d.Leased/Rented/Borrowed Medical and Scientific Equipment
e.UF Scripps Owned Scientific Equipment
5.The Premium Subtotal is the auto-calculated total of all Premiums for the coverage requirements identified on the Price Sheet for a Policy Period.
6.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.
7.Brokers should not include Terrorism Risk Insurance (TRIA) premium pricing, as this coverage is not required on this policy.
8.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.
9.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.
10.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
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
2025 Q1 2.3
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, 3 and 4, as submitted by the Bidder.
11.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.
12.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.
13.Upload this completed Microsoft Excel file within the Sourcing application. Do not convert the Price Sheet to a PDF or any other format.
14.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 No. 25-84131512-ITB
Electronic Data Processing Equipment Insurance
Attachment C
Price Sheet

Broker Name:

Period (P) →123
The most recent ten-year inflation rate from the Survey of Professional Forecasters (R) →2.30%2.30%2.30%
#Equipment TypeValues requested for 6/5 policy onsetPolicy Period (PP) 1 6/5/25-6/5/26Policy Period (PP) 2 6/5/26-6/6/27Policy Period (PP) 3 6/5/27-6/5/28Policy Period (PP) 4 6/5/28-6/5/29
Rate per $100 of Insured ValueAnnual PremiumRate per $100 of Insured ValueAnnual PremiumRate per $100 of Insured ValueAnnual PremiumRate per $100 of Insured ValueAnnual Premium
1Owned Electronic Data Processing Equipment (including CAMLS)$ 257,341,632.90$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2Owned Medical & Scientific Equipment (including NSTC, Byrd and CAMLS)$ 38,331,273.60$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3Owned UF Scripps Scientific Equipment$ 82,876,180.32$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4Leased/Rented/Borrowed Electronic Data Processing Equipment$ 5,805,062.38$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5Leased/Rented/Borrowed Medical and Scientific Equipment$ 4,861,499.36$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Premium Sub-Total → $ - 0 $ - 0 $ - 0 $ - 0

ASSESSMENTS OR FEES
(as applicable)Assessment (insert name of Assessment & Statute)0%$ - 00%$ - 00%$ - 00%$ - 0
Assessment (insert name of Assessment & Statute)0%$ - 00%$ - 00%$ - 00%$ - 0
Assessment (insert name of Assessment & Statute)0%$ - 00%$ - 00%$ - 00%$ - 0
Policy Fee (if applicable)$ - 0$ - 0$ - 0$ - 0$ - 0
Inspection Fee (if applicable)$ - 0$ - 0$ - 0$ - 0
Fee (insert name of Fee)$ - 0$ - 0$ - 0$ - 0
Fee (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

File details come from the government source that posted it. Updated .