A1 Appendix H-EPA Example.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- FSG 53 Performance-Based Acquisition Support Strategy Federal contract opportunity
- Solicitation number
- SPE4A5-20-R-0150
- Issued by
- Defense Logistics Agency Aviation
About this file
This document contains an example appendix and details of a federal contract solicitation. The appendix provides an example calculation of economic price adjustments using the Producer Price Index for construction machinery and equipment. The adjustments would apply to unit prices under an indefinite delivery indefinite quantity contract with a three and a half year base period and two three-year option periods for 215,838 National Stock Numbers in Federal Stock Group 53, which includes hardware and abrasives. Pricing would be fixed rates with economic adjustments calculated using the percentage change in the Producer Price Index from the base index at time of award to the adjusting index prior to contract modifications. The solicitation is seeking a single awardee to supply the stock numbers on an as-needed basis over the potential nine and a half year contract term.
View the file
Other files for this federal contract opportunity
Show all 50
FSG 53 Performance-Based Acquisition Support Strategy has more files on GovTribe.
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
Section H EPA Example
| NOTE: These calculations will be executed for each of the seven indices outlined in Section H, 1.1 EPA Indices, and applied to all items within each index in spreadsheet format. See Tab 2 |
| Contract Dates for example purposes: |
| Final Proposal Revision Date (Closing Date): September 1, 2018 |
| *to determine Base Index |
| Award Date: December 15, 2018 |
| Performance Period: December 15, 2018 - December 14, 2019 |
| Adjustment Period: December 15, 2019 - December 14, 2020 |
| Initiate Adjustment: Between 15-30 days before end of Period |
| Contract modification: NLT December 14, 2019 |
| *to determine Adjusting Index |
| Base Index Calculation: | Month/Year | Final Index |
| Aritmetic average of the final version of the indexes published | Sep 2017 | 161.6 |
| for the 12 month preceding the closing date for receipt of | Oct 2017 | 161.6 |
| proposals. Index PCU326130326130 used for this example. | Nov 2017 | 161.8 |
| Dec 2017 | 161.3 | |
| Jan 2018 | 161.4 | |
| Feb 2018 | 162.6 | |
| Mar 2018 | 162.6 | |
| Apr 2018 | 162.6 | |
| May 2018 | 162.6 | |
| Jun 2018 | 163.0 | |
| Jul 2018 | 163.9 | |
| Aug 2018 | 164.9 | |
| Total of the 12 months: | 1949.90 | |
| Base Index: | 162.49 |
(continued on next page)
| Adjusting Index Calculation: | Published Index | Month/Year | Index Status |
| Arithmetic average of the latest 12 months with published final | 164.9 | Sep 2018 | Final |
| versions of the index prior to the month in which the adjusting | 164.9 | Oct 2018 | Final |
| contract modification is effective. | 165.3 | Nov 2018 | Final |
| *For this example, Sep 2018 through Aug 2019 are the latest 12 | 165.3 | Dec 2018 | Final |
| months with published final versions of the index. | 165.0 | Jan 2019 | Final |
| 165.0 | Feb 2019 | Final | |
| 164.8 | Mar 2019 | Final | |
| 165.4 | Apr 2019 | Final | |
| 165.7 | May 2019 | Final | |
| 166.5 | Jun 2019 | Final | |
| 166.8 | Jul 2019 | Final | |
| 166.8 | Aug 2019 | Final | |
| 166.8 (P) | Sep 2019 | Preliminary | |
| 166.8 (P) | Oct 2019 | Preliminary | |
| 166.9 (P) | Nov 2019 | Preliminary | |
| 166.8 (P) | Dec 2019 | Preliminary | |
| Total of the 12 months with final versions of index: | 1986.40 | Sum of Sep 18 - Aug 19 | |
| Adjusting Index: | 165.53 | 1986.40 / 12 | |
| less the Base Index: | 162.49 | ||
| = Change to Index: | 3.04 | 165.53 - 162.49 | |
| Adjustment percentage: | 0.01873 | 3.04 / 162.49 (1.873%) | |
| Base Unit Price: | $50.00 | ||
| Calculated adjustment value: | 0.94 | $50 x .01873 | |
| Adjusted Unit Price: | $50.94 |
&"-,Bold"Appendix H SPE4A5-20-R-0150 Amendment 1 EPA Index Calculation Example
Source Selection Information - See FAR 2.101 & 3.104 For Official Use Only
PCU326130326130 Adjust by NIIN
| EPA Adjustment by NIIN (example only): | |||||
| NIIN | Index ID | Base Unit Price | Adjustment % | Unit Price Adjustment | Adjusted Unit Price |
| xx-xxx-xxxx | PCU326130326130 | $50.00 | 0.01873 | $0.94 | $50.94 |
| xx-xxx-xxxx | PCU326130326130 | $1.00 | 0.01873 | $0.02 | $1.02 |
| xx-xxx-xxxx | PCU326130326130 | $2.50 | 0.01873 | $0.05 | $2.55 |
| xx-xxx-xxxx | PCU326130326130 | $0.75 | 0.01873 | $0.01 | $0.76 |
| xx-xxx-xxxx | PCU326130326130 | $0.25 | 0.01873 | $0.00 | $0.25* |
| *UNIT PRICE ADJUSTMENTS LESS THAN $0.01 WILL BE A ZERO ADJUSTMENT |
File details come from the government source that posted it. Updated .