Attachment_1_-_Sample_Price_Adjustment_Calculation_7926_JG.pdf

PDF 114 KB Posted

Attached to
Media Monitoring Services
Solicitation number
ITB0000027
Issued by
Florida

About this file

This document is a sample price adjustment calculation attachment for a Media Monitoring Services contract with the Miami-Dade Aviation Department (MDAD) in Florida. The contract's effective date is May 1, 2022, with a solicitation end date of May 7, 2021. The attachment demonstrates the methodology for calculating Consumer Price Index (CPI)-based price adjustments throughout the contract term, using April 2021 as the base CPI index month (229.815) and the initial contract price as the baseline for all subsequent adjustments.

The price adjustment calculation methodology maintains a constant base price and base CPI index throughout the contract term, with adjustments applied by comparing the current CPI index to the April 2021 base index, calculating the percentage change, and multiplying that percentage by the initial contract price. The document provides two calculation examples: one showing a 1.37% adjustment based on April 2023 CPI data (resulting in a $1.37 increase on a $100.00 base price) and another demonstrating a 4.48% adjustment using June 2024 CPI data (resulting in a $4.48 increase). This mechanism allows for transparent and systematic price modifications based on actual inflation as measured by the Consumer Price Index, ensuring the contract price remains equitable throughout its duration.

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

Attachment 1 Sample Price Adjustment Calculation

Contract’s Effective Date: May 1, 2022 Solicitation’s End Date: May 7, 2021

Index Point Change Calculation:

Current CPI Index (April 2023) 232.945

Less: Base CPI Index (April 2021) 229.815

Equals: Index Point Change 3.130

Percentage Change Calculation:

Index Point Change 3.130

Divided by: Base CPI Index 229.815

Equals: 0.01362

Multiplied by 100: 1.3620

Equals: Percent Change 1.37%

Price Calculation:

Percent Change: 1.37%

Multiplied by Initial Contract Price (Base Price): $100.00

Equals: Applicable CPI Increase: $1.37

Adjusted Price According to CPI: $101.37

The Base Price and the Base CPI Index shall remain constant throughout the contract term and shall be the basis of all adjustments.

The following is an example of how to calculate a subsequent adjustment:

Index Point Change Calculation:

Current CPI Index (June 2024) 240.100

Less: Base CPI Index (April 2021) 229.815

Equals: Index Point Change 10.285

Percentage Change Calculation:

Index Point Change

10.285

Divided by: Base CPI Index 229.815

Equals: 0.04475

Multiplied by 100: 4.4753

Equals: Percent Change 4.48%

Price Calculation:

Percent Change:

4.48%

Multiplied by Initial Contract Price (Base Price): $100.00

Equals: Applicable CPI Increase: $4.48

Adjusted Price According to CPI: $104.48

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