Rate_Adjustment_Example.xls
XLS spreadsheet 33 KB Posted
- Attached to
- Professional, Administrative and Management Support Services Federal contract opportunity
- Solicitation number
- FA8202-08-R-1000
About this file
TLPS Rates Adjustment Example
View the file
Other files for this federal contract opportunity
Show all 50
Professional, Administrative and Management Support Services 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
Sheet1
| EXAMPLE OF CONTRACTUAL RATE ADJUSTMENT IN FEBRUARY 2012 | ||||||||
| APPLICABLE TO 9952.902-H902 RATE ADJUSTMENT CLAUSE | ||||||||
| RATE ADJUSTMENT ESCALATION MATRIX | ||||||||
| A | B | C | D | E | F | G | H | I |
| Originally | Originally | Originally | Index | Index | Index | Adjusted | ||
| Proposed | Proposed | Proposed | Forcasted | Forcasted | Forcasted | Contractual | ||
| NTE | Escalation | Cumulative | Escalation | Cumulative | NTE | NTE | ||
| Labor Category | CY | Rates | Factor | Escal. Factor | Factor | Escal.Factor | Rate | Rate |
| SENIOR AEROSPACE ENGINEER LEVEL 3 | 2009 | $ 85.00 | xxxx | xxxx | xxxx | xxxx | xxxx | $ 85.00 |
| 2010 | $ 87.98 | 3.48% | 1.03480 | 3.60% | 1.03600 | $ 88.06 | $ 87.98 | |
| 2011 | $ 91.03 | 3.49% | 1.07091 | 3.61% | 1.07340 | $ 91.24 | $ 91.03 | |
| 2012 | $ 94.21 | 3.50% | 1.10840 | 3.62% | 1.11226 | $ 94.54 | $ 94.54 | |
| 2013 | $ 97.52 | 3.51% | 1.14730 | 3.63% | 1.15263 | $ 97.97 | $ 97.97 | |
| 2014 | $ 100.95 | 3.52% | 1.18769 | 3.64% | 1.19459 | $ 101.54 | $ 101.54 | |
| 2015 | $ 104.52 | 3.53% | 1.22961 | 3.65% | 1.23819 | $ 105.25 | $ 105.25 | |
| 2016 | $ 108.22 | 3.54% | 1.27314 | 3.66% | 1.28351 | $ 109.10 | $ 109.10 | |
| 2017 | $ 112.06 | 3.55% | 1.31834 | 3.67% | 1.33061 | $ 113.10 | $ 113.10 | |
| 2018 | $ 116.05 | 3.56% | 1.36527 | 3.68% | 1.37958 | $ 117.26 | $ 117.26 | |
| 2019 | $ 120.19 | 3.57% | 1.41401 | 3.69% | 1.43049 | $ 121.59 | $ 121.59 | |
| 2020 | $ 124.49 | 3.58% | 1.46463 | 3.70% | 1.48341 | $ 126.09 | $ 126.09 | |
| NOTES ON COLUMNS | ||||||||
| A | Labor Category for Senior Aerspace Engineer Level 3 ( example) | |||||||
| B | Calendar Years NTE Rates for Senior Aerospace Engineer Level 3, this matches the current official Labor Category Rate Matrix | |||||||
| C | Originally proposed contractual NTE rates listed in the official Labor Category Rate Matrix (July 2008) | |||||||
| Note that these values (in column C) will coincide with the current Labor Category Rate Matrix for CY's 2012-2020 | ||||||||
| D | The forecasted escalations, by calendar year, established at the time of TLPS proposal submittal (July 2008) | |||||||
| Note that these forecasted escalation values may change as the Offical Labor Category Rate Matrix changes | ||||||||
| E | The forecasted index, cumulative values, for the current Labor Category Rate Matrix | |||||||
| F | The actual escalation rates, for CY 2009 - CY 2011, and the forecasted rates for CY 2012-2020, available in Feb. 2012 | |||||||
| G | The adjusted actual/forecasted index, cumulative values, for CY 2009 - CY 2020, based on Index available in Feb. 2012 | |||||||
| H | The rates computed for the most recent actual/forecast Index available Feb 2012 | |||||||
| I | The adjusted contractual NTE rates in Feb. 2012. Column G replaces Column C where applicable | |||||||
| Note: no adjustment to the contractual rates in the first three years, CY 2009 - CY 2011 | ||||||||
| ADDITIONAL NOTES/INSTRUCTIONS | ||||||||
| Request For Rate Rate Adjustments | APPLICABLE TO 9952.902-H902 RATE ADJUSTMENT CLAUSE | |||||||
| <> The successful contractor(s) for award shall submit a RATE ADJUSTMENT ESCALATION MATRIX when an adjustment is requested by the contractor | ||||||||
| along with the "revised" Labor Category Rate Matrix | ||||||||
| <> Submit the applicable GBL Economic Forecasting Index to support Rate Adjustment Escalation Matrix values (Aerospace Product and Parts Manufacturing Index) | ||||||||
| <> Submit other information/data as requested by the PCO | ||||||||
| <> Note the PCO must approve any rate changes and determine the procedures and terms in the Rate Adjustment Clause are followed. |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .