County_LD_Schedule_(For_Purchasing_Only).xlsx

XLSX spreadsheet 29 KB Posted

Attached to
FY 2026 Pavement Preservation Package 2-STEP 2
Solicitation number
25-0071-ITB-C STEP 2
Issued by
Pinellas County, Clewiston City, Florida

About this file

The document is a Liquidated Damages Calculator spreadsheet prepared for Pinellas County, Florida, specifically for the FY 2026 Pavement Preservation Package 2 project (PID No. 25-0071-REQ). The project involves pavement preservation for five local neighborhood projects, totaling approximately 44.26 lane miles of roadway. The construction duration is set at 210 calendar days, with an Engineer's estimated probable construction cost of $5,984,357.93. The liquidated damages are calculated at $1,434.66 per day of project delay.

The document provides a detailed methodology for calculating liquidated damages, including considerations such as design consultant fees, construction administration costs, project overhead, and potential indirect expenses like lost revenues or grant funding. The calculation takes into account daily rates for project management, administrative costs, and other project-specific factors. The spreadsheet is designed to help the county establish a fair and reasonable per-day damage amount in case of project delays, with an emphasis on documenting the rationale and calculation method for future reference and potential audit purposes.

View the file

Other files

Show all 25

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

Table

LIQUIDATED DAMAGES CALCULATOR
Project Name: FY 2026 Pavement Preservation Package 2
PID No.: 25-0071-REQ
Enter Design Consultant's total post design fee$ - 0
Enter Construction Administrator's total FeeN/A
Duration of Construction (calendar days)210
Enter Total Project Enclosed Square Footage (if applicable)N/A
Enter Total Daily Department PM/APM Full time EquivalentsN/A
Engineer's Estimate of probable construction cost$ 5,984,357.93
Elements for Liquidated Damages Determination:
Design Consultant Fees$ - 0Total post design fee divided by construction duration *3%
Construction Administration/Inspection$ 1,356.00Daily combined burdened rate for CA staff + Consultant CEI
Project Manager/Assistant Project Manager$ 78.66(1 hour/day burdened rate)
Department Project OverheadLD Schedule
Agency Administrative Costs$ - 0
Temporary Heat/Cooling/Electric$ - 0
Temporary Storage of Owner Provided FFE$ - 0
Rental/Lease of Facilites for Staff, and/or Clients$ - 0
Lost revenues$ - 0
Lost grant revenues$ - 0
Interest$ - 0
Rental / moving expenses$ - 0
Cost for Insurance
Other
Total Liquidated Damages Amount per day$ 1,434.66
Prepared by:
Edit Highlighted Areas

Definitions

A. LIQUIDATED DAMAGES:
Liquidated damages are a specific sum (or a sum readily determinable) of money, stipulated by the contracting parties, as the amount to be recovered for each day of delay in delivery of the product.
Typically, the actual damage amount is unknown or difficult to estimate and is liquidated by the mutual agreement to the rate. Liquidated damages must be based on a reference to a definite standard, such as market value, established experience, or direct inference from known circumstances.
Liquidated damages can not be speculative or a penalty.
B. RATE DETERMINATION:
The amount of liquidated damages must be reasonable to ensure that the damages will not be held to be unenforceable. Therefore, the rate of liquidated damages, also, must be reasonable and is figured on a project-by-project basis.
On the other hand, you do not want to set the liquidated damages at too low an amount. Once liquidated damages are included in a contract, you will be unable to recover actual damages in excess of the specified amount.
C. HOW TO DETERMINE THE AMOUNT OF ANTICIPATED ACTUAL DAMAGES IN ORDER TO ESTABLISH AN APPROPRIATE AMOUNT FOR LIQUIDATED DAMAGES:
Examples of Elements of Rate Determination are listed below (All rates to be based on daily cost). The following list of criteria should be considered when determining anticipated damages that may be caused by a delay in the completion of a project.
Some of these are hard costs; others are based upon nonquantifiable factors.

*Design Consultant Fees – calculated as the construction administration portion of the consultant fee divided by the construction duration multiplied by 3% per year based on duration. If not known, use estimate.

*Construction Administration Fee - Generally calculated by the Construction Division; however, if Construction Division is not inspecting, cost can be based on the total cost for CA divided by the construction duration (multiplied by 3%/year).
FDOT grant funded projects will use the FDOT LD Schedule.
*Project Manager/Assistant Project Manager Time – Hourly burdened rate of PM or APM.
*DPW Project Overhead - based upon daily rate for DPW administrative overhead costs not recovered in PM billing rate.
*Agency Administrative Costs – based upon daily rate for agency personnel assigned to work on project or agency personnel required to spend a portion of their time should be included at that percentage of the daily rate.
*Temporary Heat/Cooling/Electric, Owner provided – Per S.F. of project area/day.
*Temporary Storage of Owner provided FFE – Costs for storage of Furniture, Fixtures, and Equipment, or other storage of products or materials caused by the delayed turn over of the facility.
*Rental/Lease of Facilities for Staff, and/or Clients – calculated in coordination with the agency representative based upon specific needs and available alternatives.
*Loss of revenue - Loss of potential revenue from a facility not opening as scheduled.
*Loss of grant - Loss of grant funding should the project not be completed on time.
*Interest (on borrowed funds) during unexcused delays in completion or periods of non-use.
*Rental/moving or other expenses for alternate space.
*Costs for insurance, utilities, or equipment.
D. HOW TO DOCUMENT THE MEANS BY WHICH LIQUIDATED DAMAGES ARE ESTABLISHED:
1. Determine your anticipated actual per diem damages using criteria such as those listed above.
2. Determine the appropriateness of the figure arrived at in Step 1. The anticipated figure may be used, or a percentage of that figure may be determined to be more appropriate for liquidated damages.
3. Create a typewritten document of the criteria, calculations, and judgments used above.
4. Place the documentation with the Contracts Unit project file for future reference. It is essential to keep all of the records used to determine the per diem liquidated damages amount.
This documentation is important to resolve possible future claims, for audit purposes, and for reference in developing future liquidated damages clauses.

Sheet3

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