Rates Adjustment Example 8 Sep.xls

XLS spreadsheet 74 KB Posted Sep 8, 2008

Attached to: Professional, Administrative and Management Support Services Federal contract opportunity
Solicitation number: FA8202-08-R-1000
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Hill Air Force Base

About this file

From the source

Adjustment Examples - Illustration of Rates Adjustment Procedures

View the file

Other files for this federal contract opportunity

Other files attached to Professional, Administrative and Management Support Services, newest first.
File	Type	Posted
FA820209D000X_______0001.RTF	RTF text file	Feb 27, 2009
Integration_Support_Task_Order.pdf	PDF	Feb 27, 2009
FA820208R1000_______0003.RTF	RTF text file	Feb 27, 2009
Notice to Industry 23 Jan 09 - Response to Industry Question.doc	DOC document	Jan 23, 2009
Industry Comments - Air Force Responses 21 Jan 09.pdf	PDF	Jan 21, 2009
Industry Comments - Air Force Responses 12 Jan 09.pdf	PDF	Jan 21, 2009
Industry Comments - Air Force Responses 16 Jan 09.docx	DOCX document	Jan 16, 2009
Industry Comments - Air Force Responses 12 Jan 09.docx	DOCX document	Jan 12, 2009
FA820208R1000_______0001.RTF	RTF text file	Jan 12, 2009
FA820208R1000.RTF	RTF text file	Jan 5, 2009
Section_L_ATTACHMENT_4_Consent_Form.doc	DOC document	Jan 5, 2009
Section_L_ATTACHMENT_5_Commercial_Client_Authorization.doc	DOC document	Jan 5, 2009
Notice to Industry 5 Jan 09 - Official RFP release.doc	DOC document	Jan 5, 2009
Section_L_ATTACHMENT_3_Questionnaire.doc	DOC document	Jan 5, 2009
Section_L_ATTACHMENT_2_Quest_Cover_Letter.doc	DOC document	Jan 5, 2009
Section_L_ATTACHMENT_1_PPIS.docx	DOCX document	Jan 5, 2009
DD254_TLPS.pdf	PDF	Jan 5, 2009
Small_Business_Participation_CDRL_A100.pdf	PDF	Jan 5, 2009
Section_L_ATTACHMENT_7_Labor_Category_Rates_Matrix.xls	XLS spreadsheet	Jan 5, 2009
TLPS Section M 11 Dec 08	—	Dec 16, 2008
Notice to Industry 16 Dec - Discription of Changes Reflected in Draft RFP Posted 16 Dec 08.doc	DOC document	Dec 16, 2008
TLPS Section L 11 Dec 08	—	Dec 16, 2008
K Provision	—	Dec 16, 2008
FA820208R1000.RTF	RTF text file	Dec 16, 2008
Small_Business_Participation_CDRL_A100.pdf	PDF	Dec 16, 2008
Section_L_ATTACHMENT_7_Labor_Category_Rates_Matrix.xls	XLS spreadsheet	Dec 16, 2008
Section_L_ATTACHMENT_4_Consent_Form.doc	DOC document	Dec 16, 2008
Section_L_ATTACHMENT_1_PPIS.docx	DOCX document	Dec 16, 2008
Section_L_ATTACHMENT_5_Commercial_Client_Authorization.doc	DOC document	Dec 16, 2008
TLPS_PWS.doc	DOC document	Dec 16, 2008
Section_L_ATTACHMENT_2_Quest_Cover_Letter.doc	DOC document	Dec 16, 2008
Notice to Industry 20 Nov - Estimated RFP Release.doc	DOC document	Nov 20, 2008
Notice to Industry 14 Nov - Past Performance Volume.doc	DOC document	Nov 14, 2008
Notice to Industry 6 Oct - H Clauses.doc	DOC document	Oct 6, 2008
Draft Task Order Proposal Evaluation Method 23 Sep.doc	DOC document	Sep 23, 2008
RFI Rates Adjustment Clause 8 Sep.doc	DOC document	Sep 8, 2008
Alternate Approach Rates Adjustment Clause.doc	DOC document	Sep 8, 2008
Integration_Support_Task_Order.pdf	PDF	Aug 28, 2008
Section_L_ATTACHMENT_3_Questionnaire.doc	DOC document	Aug 28, 2008
Section_L_ATTACHMENT_2_Quest_Cover_Letter.doc	DOC document	Aug 28, 2008
Section_L_ATTACHMENT_1_PPIS.doc	DOC document	Aug 28, 2008
DD254_TLPS.pdf	PDF	Aug 28, 2008
Section_L_ATTACHMENT_7_Labor_Category_Rates_Matrix.xls	XLS spreadsheet	Aug 28, 2008
Response to Industry Questions 18 July.docx	DOCX document	Jul 18, 2008
DD254_TLPS.pdf	PDF	Jul 18, 2008
Section_L_ATTACHMENT_2_Quest_Cover_Letter.doc	DOC document	Jul 18, 2008
Section_L_ATTACHMENT_1_PPIS.doc	DOC document	Jul 18, 2008
Notice to Industry 18 July.doc	DOC document	Jul 18, 2008
Section_L_ATTACHMENT_4_Consent_Form.doc	DOC document	Jul 18, 2008
Small_Business_Report-CDRL-A100.xls	XLS spreadsheet	Jul 18, 2008

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Scenario details

Rate Adjustment for NTE Labor Rates
Labor Escalation Scenarios
					Scenario #1	Scenario #2	Scenario #3
				CY 2011	Index up 2.1%	Index up 2.1%	Index up 2.1%
				CY 2012	no change	Index up .6%	Index up .6%
				CY 2013	no change	no change	Index down 0.4%
	Scenario #1: CY 2012 Rates Adjustment (see Excel Tab "Scenario #1" to follow the math tables)
		CY 2011 actual value is higher than CY 2011 forecasted value. NTE Labor Hour Rates CY 2012 and beyond are eligible for adjustments
		In February 2012, the actual for CY 2011 is posted on the U.S. Department of Labor, Bureau of Labor Statistics (BLS) website.
			Here is a link to the BLS website:			www.bls.gov
		CY 2011 actual value is 4.3%, versus forecasted value of 2.2%.
		The adjustment factor is the cumulative factor for CY 2011 actual divided by cumulative factor for CY 2011 forecast.
		1.061/ 1.039 = 1.021			Since the adjustment factor is greater than 1.02
		the proposed Labor Hours Rates for CY 2012 through CY 2020 can be adjusted by 1.021
	Scenario #2: CY 2013 Rates Adjustment (See Excel Tab "Scenario #2" to follow the math tables)
		In February 2013, the actual for CY 2012 is posted on the BLS website.
		CY 2012 actual value is 3.1%, versus forecasted value of 2.5%.
		The adjustment factor is the cumulative factor for CY 2012 actual divided by cumulative factor for CY 2012 forecast.
		1.094/1.087=1.006
		All rates in the Labor Category Rate Matrix (for CY 2013 through CY 2020) would NOT be adjusted upward
		because the factor 1.006 is less than 1.02
	Scenario #3: CY 2014 Rates Adjustment (See Excel Tab "Scenario #3 to follow the math tables)
		In February 2014, the actual for CY 2013 is posted on the BLS website.
		CY 2013 actual value is 2.0%, versus forecasted value of 2.4%.
		The adjustment factor is the cumulative factor for CY 2013 actual divided by cumulative factor for CY 2013 forecast.
			1.115 / 1.113 = 1.002
		All rates in the Labor Category Rate Matrix (for CY 2014 through CY 2020) would NOT be adjusted
		because the factor 1.002 is less than 1.02

www.bls.gov

Scenario #1

Labor Escalation
Global Insight, Inc. CEU3133640008
Aerospace Product and Parts Manufacturing
Bureau of Labor Statistics (BLS) Series ID is NAICS 3364
CY 2011 only
				(A)	(B)	(C)		(D)	(E)	(F)	(G)
				Base Values (Forecast)				Actual Values
	CY	Factor	%	CY	%	Factor		CY	%	Factor	Adjustment
	1999	19.649		2009	2.9%	1.000		2009	2.9%	1.000	N/A
	2000	20.522	4.4%	2010	1.7%	1.017		2010	1.7%	1.017	N/A
	2001	21.255	3.6%	2011	2.2%	1.039		2011	4.3%	1.061	N/A
	2002	22.086	3.9%	2012	2.5%	1.065		2012			1.021
	2003	22.931	3.8%	2013	2.4%	1.091		2013			1.021
	2004	23.926	4.3%	2014	2.3%	1.116		2014			1.021
	2005	24.803	3.7%	2015	2.3%	1.142		2015			1.021
	2006	26.265	5.9%	2016	2.2%	1.167		2016			1.021
	2007	28.379	8.0%	2017	2.2%	1.192		2017			1.021
	2008	29.764	4.9%	2018	2.1%	1.218		2018			1.021
	2009	30.635	2.9%	2019	2.1%	1.243		2019			1.021
	2010	31.157	1.7%	2020	2.1%	1.269		2020			1.021
	2011	31.833	2.2%
	2012	32.615	2.5%	CY 2011 Actual Cum Factor			1.061
	2013	33.395	2.4%	CY 2011 Forecast Cum Factor			1.039		CY 2012
	2014	34.173	2.3%	Computed Adjustment Factor			1.0205509106
	2015	34.954	2.3%	(1.051/1.039=1.021)
	2016	35.733	2.2%
	2017	36.521	2.2%
	2018	37.306	2.1%
	Notes:	In Columns (B) and (C), the labor index is normalized to CY 2009. The factors in Column (C) establish the forecast for CY 2009 - CY 2020.
		Columns (E) and (F) will be populated year-by-year, as the actual values become available.
		For example, in CY 2011, the actual value is 3.3% as opposed to the 2.2% forecast value. The adjustment would be the factor
		in Column (F) divided by the factor in Column (C), or 1.061/ 1.039 = 1.011.
		All rates in the Labor Category Rate Matrix (for CY 2012 through CY 2020) would be adjusted upward by a factor of 1.021.

Scenario #2

Labor Escalation
Global Insight, Inc. CEU3133640008
Aerospace Product and Parts Manufacturing
Bureau of Labor Statistics (BLS) Series ID is NAICS 3364
CY11, CY12, CY13: Up, Down, Up
		(A)	(B)	(C)		(D)	(E)	(F)	(G)
		Base Values (Forecast)				Actual Values
	CY 2012	CY	%	Factor		CY	%	Factor	Adjustment
		2009	2.9%	1.000		2009	2.9%	1.000	N/A
		2010	1.7%	1.017		2010	1.7%	1.017	N/A
		2011	2.2%	1.039		2011	4.3%	1.061	N/A
		2012	2.5%	1.065		2012			1.021
		2013	2.4%	1.091		2013			1.021
		2014	2.3%	1.116		2014			1.021
		2015	2.3%	1.142		2015			1.021
		2016	2.2%	1.167		2016			1.021
		2017	2.2%	1.192		2017			1.021
		2018	2.1%	1.218		2018			1.021
		2019	2.1%	1.243		2019			1.021
		2020	2.1%	1.269		2020			1.021
		(A)	(B)	(C)		(D)	(E)	(F)	(G)
		Base Values (Forecast)				Actual Values
	CY 2013	CY	%	Factor		CY	%	Factor	Adjustment
		2009	2.9%	1.000		2009	2.9%	1.000	N/A
		2010	1.7%	1.017		2010	1.7%	1.017	N/A
		2011	4.3%	1.061		2011	4.3%	1.061	N/A
		2012	2.5%	1.087		2012	3.1%	1.094	N/A
		2013	2.4%	1.113		2013			1.006
		2014	2.3%	1.139		2014			1.006
		2015	2.3%	1.165		2015			1.006
		2016	2.2%	1.191		2016			1.006
		2017	2.2%	1.217		2017			1.006
		2018	2.1%	1.243		2018			1.006
		2019	2.1%	1.269		2019			1.006
		2020	2.1%	1.295		2020			1.006
		Note: the Forecast for CY 2011 is re-baselined from 2.2% to 4.3% - one year later.
	Re-baseing	In the event that the Actual Value for CY2011 was less than the Forecasted value, it will take 2 years (or more) before
		the CY 2011 Actual Value is re-baselined into the Forecast
		CY 2011 Actual Cum Factor			1.094
		CY 2011 Forecast Cum Factor			1.087
		Computed Adjustment Factor			1.0058496206
		(1.094/1.087=1.006)

Scenario #3

Labor Escalation
Global Insight, Inc. CEU3133640008
Aerospace Product and Parts Manufacturing
Bureau of Labor Statistics (BLS) Series ID is NAICS 3364
CY11, CY12, CY13: Down, Up, Down
		(A)	(B)	(C)		(D)	(E)	(F)	(G)
		Base Values (Forecast)				Actual Values
	CY2012	CY	%	Factor		CY	%	Factor	Adjustment
	Rates Adjustment	2009	2.9%	1.000		2009	2.9%	1.000	N/A
		2010	1.7%	1.017		2010	1.7%	1.017	N/A
		2011	2.2%	1.039		2011	4.3%	1.061	N/A
		2012	2.5%	1.065		2012			1.021
		2013	2.4%	1.091		2013			1.021
	See Scenario #1	2014	2.3%	1.116		2014			1.021
		2015	2.3%	1.142		2015			1.021
		2016	2.2%	1.167		2016			1.021
		2017	2.2%	1.192		2017			1.021
		2018	2.1%	1.218		2018			1.021
		2019	2.1%	1.243		2019			1.021
		2020	2.1%	1.269		2020			1.021
		(A)	(B)	(C)		(D)	(E)	(F)	(G)
		Base Values (Forecast)				Actual Values
	CY2013
	Rates Adjustment	CY	%	Factor		CY	%	Factor	Adjustment
		2009	2.9%	1.000		2009	2.9%	1.000	N/A
		2010	1.7%	1.017		2010	1.7%	1.017	N/A
		2011	4.3%	1.061		2011	4.3%	1.061	N/A
		2012	2.5%	1.087		2012	3.1%	1.094	N/A
	See Scenario #2	2013	2.4%	1.113		2013			1.006
		2014	2.3%	1.139		2014			1.006
		2015	2.3%	1.165		2015			1.006
		2016	2.2%	1.191		2016			1.006
		2017	2.2%	1.217		2017			1.006
		2018	2.1%	1.243		2018			1.006
		2019	2.1%	1.269		2019			1.006
		2020	2.1%	1.295		2020			1.006
					Re-baselined
		(A)	(B)	(C)		(D)	(E)	(F)	(G)
		Base Values (Forecast)				Actual Values
	CY2014	CY	%	Factor		CY	%	Factor	Adjustment
	Rates Adjustment	2009	2.9%	1.000		2009	2.9%	1.000	N/A
		2010	1.7%	1.017		2010	1.7%	1.017	N/A
		2011	4.3%	1.061		2011	4.3%	1.061	N/A
		2012	2.5%	1.087		2012	3.1%	1.094	N/A
		2013	2.4%	1.113		2013	2.0%	1.115	N/A
		2014	2.3%	1.139		2014			1.002
		2015	2.3%	1.165		2015			1.002
		2016	2.2%	1.191		2016			1.002
		2017	2.2%	1.217		2017			1.002
		2018	2.1%	1.243		2018			1.002
		2019	2.1%	1.269		2019			1.002
		2020	2.1%	1.295		2020			1.002
		CY 2013 Actual Cum Factor			1.115
		CY 2013 Forecast Cum Factor			1.113
		Computed Adjustment Factor			1.002

File details come from the government source that posted it. Updated Nov 14, 2017.