Appendix H-EPA Index Calculation Example.xlsx
XLSX spreadsheet 17 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 provides details on federal contract opportunity SPE4A5-20-R-0150. The solicitation is for a long-term strategic contract to support the target population of 215,838 National Stock Numbers in Federal Stock Group 53, which includes hardware and abrasives. The proposed contract would be an indefinite delivery indefinite quantity commercial fixed price contract with economic price adjustments over a potential nine and a half year duration, including a three and a half year base period and two three-year option periods. The solicitation is seeking pricing for all items in the initial contract award. The Defense Logistics Agency Aviation is the contracting agency. Letters expressing subcontracting interest will be provided to the awardee. The contract will be competitively awarded using best value selection methods, resulting in a single contract award.
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
50-50 Index Performance EXAMPLE
| EXAMPLE ONLY - VALUES FOR DEMONSTRATIVE PURPOSES ONLY | ||||||
| Contract Award Date: | Monday, October 01, 2018 | |||||
| Terms: | Unit pricing will be calculated 14 days prior to the beginning of the next year of contract performance | |||||
| Contract period | Index date range | Average closing value | Percent of change (%) | Split 50/50 (%) | Index based price adjustment (%) | |
| Steel: | Base; Year 1 Start | 9/12/2017 - 9/11/2018: | 1,280.43 | |||
| Base; Year 2 Start | 9/12/2018 - 9/11/2019: | 1,108.06 | -13% | -7% | ||
| Base; Year 3 Start | 9/12/2019 - 9/11/2020: | 1,218.87 | 10% | 5% | ||
| … | … | … | … | … | ||
| Composite Metal: | Base; Year 1 Start | 9/12/2017 - 9/11/2018: | 1,372.09 | |||
| Base; Year 2 Start | 9/12/2018 - 9/11/2019: | 1,228.07 | -10% | -5% | ||
| Base; Year 3 Start | 9/12/2019 - 9/11/2020: | 1,289.47 | 5% | 3% | ||
| … | … | … | … | … |
| Combined: | Base; Year 2 Start | 9/12/2018 - 9/11/2019: | -12% |
| Base; Year 3 Start | 9/12/2019 - 9/11/2020: | 8% | |
| … | … | … |
&"-,Bold"&12SPE4A5-20-R-0150 Appendix H - EPA Index Calculation Examples 50-50 Index Performance Example
Source Selection Information -- See FAR 2.101 and 3.104 For Official Use Only
Single Index Performance EXAMPL
| EXAMPLE ONLY - VALUES FOR DEMONSTRATIVE PURPOSES ONLY | |||||
| Contract Award Date: | Monday, October 01, 2018 | ||||
| Terms: | Unit pricing will be calculated 14 days prior to the beginning of the next year of contract performance | ||||
| Contract period | Index date range | Average closing value | Percent of change (%) | Index based price adjustment (%) | |
| Rubber & Rubber Products PPI | Base; Year 1 Start | 9/12/2017 - 9/11/2018: | 177.44 | ||
| Base; Year 2 Start | 9/12/2018 - 9/11/2019: | 180.44 | 2% | 2% | |
| Base; Year 3 Start | 9/12/2019 - 9/11/2020: | 175.03 | -3% | -3% | |
| … | … | … | … | … |
&"-,Bold"&12SPE4A5-20-R-0150 Appendix H - EPA Index Calculation Examples Single Index Performance Example
For Official Use Only
Unit Price Adjustment EXAMPLE
| EXAMPLE ONLY - VALUES FOR DEMONSTRATIVE PURPOSES ONLY | ||||||||
| Source: Vendor TEP submission | ||||||||
| Source: Index performance | ||||||||
| NIIN Number: | XXX | |||||||
| Item Name: | XXXXXXX | |||||||
| Step 1: Adjust last year's unit price based on index performance | Step 2: Adjust revised unit price based on TEP contractual reductions on NIIN | Step 3: Adjust revised unit price based on TEP contractual rebate on total purchases | ||||||
| Last Year's Unit Price ($) | % Change in Average Closing Value | Adjusted Unit Price Based on Index ($) | Proposed NIIN-level Price Reduction in TEP (%) | Adjusted Unit Price Based on Proposed NIIN Price Reduction ($) | Proposed Volume Rebate in TEP (%) | Final Unit Price ($) | ||
| Base | Year 1 | -- | -- | -- | -- | 1.00 | ||
| Base | Year 2 | 1.00 | -12% | 0.88 | 5% | 0.84 | 1% | 0.83 |
| Base | Year 3 | 0.83 | 8% | 0.89 | 5% | 0.85 | 1% | 0.84 |
| Option | Year 4 | 0.84 | 3% | 0.87 | 3% | 0.84 | 1% | 0.83 |
| Option | Year 5 | 0.83 | 0% | 0.83 | 3% | 0.81 | 1% | 0.80 |
| Option | Year 6 | 0.80 | -2% | 0.78 | 2% | 0.77 | 1% | 0.76 |
| Option | Year 7 | 0.76 | 1% | 0.77 | 2% | 0.75 | 1% | 0.74 |
| Option | Year 8 | 0.74 | 5% | 0.78 | 1% | 0.77 | 1% | 0.77 |
| Option | Year 9 | 0.77 | 4% | 0.80 | 1% | 0.79 | 1% | 0.78 |
&"-,Bold"&12SPE4A5-20-R-0150 Appendix H - EPA Index Calculation Examples Unit Price Adjustment Example
For Official Use Only
File details come from the government source that posted it. Updated .