Attachment_4_-_Pricing_Tables.11-2-2016.xlsx

XLSX spreadsheet 30 KB Posted Nov 16, 2016

Attached to: Department of State UH-1 Helicopter Programmed Depot Maintenance (PDM)
Solicitation number: SWHARC16R0009
Issued by: Department of State Office of Acquisition Management

About this file

From the source

Attachment 4

View the file

Other files

File	Type	Posted
SWHARC16R0009_-_Q&As_-_26_Jan_2017.pdf	PDF	Jan 26, 2017
SWHARC16R0009-A003.pdf	PDF	Jan 17, 2017
Attachment_4_-_Rev_01_-_11_January_2017.xlsx	XLSX spreadsheet	Jan 17, 2017
SWHARC16R0009_-_Q&As_-_11_Jan_2017.pdf	PDF	Jan 17, 2017
SWHARC16R0009-A002.pdf	PDF	Dec 8, 2016
SWHARC16R0009-A001.pdf	PDF	Dec 2, 2016
SWHARC16R0009_-_Q&As_-_2_Dec_2016.pdf	PDF	Dec 2, 2016
Attachment_6_-_Past_Performance_Questionnaire.docx	DOCX document	Nov 16, 2016
Attachment_1-_SOW_-_28_Mar_16.pdf	PDF	Nov 16, 2016
RFP_Q A_Template.docx	DOCX document	Nov 16, 2016
Attachment_5_-_Corp_Experience_Template.docx	DOCX document	Nov 16, 2016
Attachment_6B_-_Sample_Client_Authorization_Letter.docx	DOCX document	Nov 16, 2016
Attachment_2.pdf	PDF	Nov 16, 2016
Attachment_6A_-_Sample_Subcontractor_Consent_Letter.docx	DOCX document	Nov 16, 2016
Attachment_3_-_List_of_GFP.pdf	PDF	Nov 16, 2016
SWHARC16R0009.pdf	PDF	Nov 16, 2016
Draft_UH-1_RFP_-_Q As_-_21_Oct_2016.pdf	PDF	Oct 21, 2016
Draft_Attachment_5_-_Corp_Experience_Template.docx	DOCX document	Sep 15, 2016
Draft_Attachment_6A_-_Sample_Subcontractor_Consent_Letter.docx	DOCX document	Sep 15, 2016
Draft_Attachment_3_-_List_of_GFP.docx	DOCX document	Sep 15, 2016
Draft_RFP_Q A_Template.docx	DOCX document	Sep 15, 2016
Draft_Attachment_4_-_Pricing_Table.xlsx	XLSX spreadsheet	Sep 15, 2016
Draft_Attachment_6_-_Past_Performance_Questionnaire.docx	DOCX document	Sep 15, 2016
Draft_SWHARC16R0009.pdf	PDF	Sep 15, 2016
Draft_Attachment_6B_-_Sample_Client_Authorization_Letter.docx	DOCX document	Sep 15, 2016
Draft_Attachment_1_-_SOW.pdf	PDF	Sep 15, 2016
Draft_SOW_-_UH1_PDM.pdf	PDF	Apr 27, 2016

Show all 27

On GovTribe

Work with this file

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.

1. Provisional Billing Rates SWHARC16R0009 - SECTION J - ATTACHMENT 4 - PRICING TABLE 1 - PROPOSED PROVISIONAL BILLING INDIRECT COST RATES

	Offeror Name:
	Offeror DUNS Number:
	Date:
	Indirect Cost Rate Description (e.g., Fringe Benefits, Overhead, Fringe Benefits)	Proposed Provisional Billing Rate	Basis of Estimate of Proposed Provisional Billing Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant FAO)	Allocation Base
(e.g., Total Labor Dollars, Total Cost Input)	Offeror Fiscal Year Period

(e.g., January 1, 2017 - December 31, 2017) 1)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate Description	Proposed Provisional Billing Rate	Basis of Estimate of Proposed Provisional Billing Rate	Allocation Base
Offeror Fiscal Year Period

1) Fringe Benefits 30.25% October 1, 2016 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2017 - December 31, 2017 Fringe Benefits 30.00% October 1, 2016 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2018 - December 31, 2018 Fringe Benefits 29.95% October 1, 2016 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2019 - December 31, 2019 Fringe Benefits 29.80% October 1, 2016 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2020 - December 31, 2020 Fringe Benefits 29.80% October 1, 2016 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2021 - December 31, 2021 Fringe Benefits 29.80% October 1, 2016 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2022 - December 31, 2022

2. Ceiling Indirect Cost Rates SWHARC16R0009 - SECTION J - ATTACHMENT 4 - PRICING TABLE 2 - PROPOSED CEILING INDIRECT COST RATES

	Offeror Name:
	Offeror DUNS Number:
	Date:
	Indirect Cost Rate Description (e.g., Fringe Benefits, Overhead, G&A)	Proposed Ceiling Indirect Cost Rate	Basis of Estimate of Proposed Ceiling Indirect Cost Rate
(e.g., Internal Budget Estimate)	Allocation Base
(e.g., Total Labor Dollars, Total Cost Input)	Offeror Fiscal Year Period

(e.g., January 1, 2017 - December 31, 2017) 1)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate Description Proposed Ceiling Indirect Cost Rate Basis of Estimate of Proposed Ceiling Indirect Cost Rate Allocation Base Offeror Fiscal Year Period

3. IDIQ Prices

SWHARC16R0009 - SECTION J - ATTACHMENT 4 - PRICING TABLE 3 - IDIQ PRICES

Offeror Name:

Offeror DUNS Number:

Date:

PART I - CORE ITEMS AND OVER-AND-ABOVE REPAIRS

		BASE PERIOD (0XX)			OPTION PERIOD 1 (1XX)			OPTION PERIOD 2 (2XX)			OPTION PERIOD 3 (3XX)			OPTION PERIOD 4 (4XX)			6-MONTH EXTENSION (5XX)
CLIN	Description	Proposed Amount	Estimated Quantity	Subtotal	Proposed Amount	Estimated Quantity	Subtotal	Proposed Amount	Estimated Quantity	Subtotal	Proposed Amount	Estimated Quantity	Subtotal	Proposed Amount	Estimated Quantity	Subtotal	Proposed Amount	Estimated Quantity	Subtotal
X001	Aircraft Condition Inspection (ACI) – Firm Fixed Unit Price per Helicopter	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	10	$ - 0
X002	Surface Transportation to and from Contractor’s Facility (CONUS) – Firm Fixed Unit Price per Helicopter per Round-Trip	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	5	$ - 0
X003	Air Transportation to and from Contractor’s Facility (CONUS) – Firm Fixed Unit Price per Helicopter per Round-Trip	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	5	$ - 0
X004	Flyable Storage – Firm Fixed Unit Price per Helicopter per Month	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	10	$ - 0	$ - 0	5	$ - 0
X005	Non-Flyable Storage - Firm Fixed Unit Price per Helicopter per Month	$ - 0	5	$ - 0	$ - 0	5	$ - 0	$ - 0	5	$ - 0	$ - 0	5	$ - 0	$ - 0	5	$ - 0	$ - 0	2	$ - 0
X006	Fixed Fully-Loaded Blended Hourly Labor Rate for all Over-and-Above (O&A) Repairs	$ - 0	40,000	$ - 0	$ - 0	40,000	$ - 0	$ - 0	40,000	$ - 0	$ - 0	40,000	$ - 0	$ - 0	40,000	$ - 0	$ - 0	20,000	$ - 0
		Subtotal		$ - 0	Subtotal		$ - 0	Subtotal		$ - 0	Subtotal		$ - 0	Subtotal		$ - 0	Subtotal		$ - 0
		PART I SUBTOTAL																	$ - 0

PART II - MATERIALS AND INDIRECT COSTS

	BASE PERIOD (0XX)			OPTION PERIOD 1 (1XX)			OPTION PERIOD 2 (2XX)			OPTION PERIOD 3 (3XX)			OPTION PERIOD 4 (4XX)			6-MONTH EXTENSION (5XX)
Description	Estimated Direct Costs	Indirect Costs	Subtotal	Estimated Direct Costs	Indirect Costs	Subtotal	Estimated Direct Costs	Indirect Costs	Subtotal	Estimated Direct Costs	Indirect Costs	Subtotal	Estimated Direct Costs	Indirect Costs	Subtotal	Estimated Direct Costs	Indirect Costs	Subtotal
Aircraft Parts	$ 7,200,000	$ - 0	$ 7,200,000	$ 11,500,000	$ - 0	$ 11,500,000	$ 11,500,000	$ - 0	$ 11,500,000	$ 11,500,000	$ - 0	$ 11,500,000	$ 11,500,000	$ - 0	$ 11,500,000	$ 5,250,000	$ - 0	$ 5,250,000
	PART II SUBTOTAL																	$ 58,450,000

PART III - OVERALL PROPOSED PRICE $ 58,450,000

4. Sample Composite Ind Rates

		FOR ILLUSTRATION PURPOSES ONLY
Sample Composite G&A Rate by Contract Period
Sample Offeror Fiscal Year	Sample Ceiling G&A Rate Proposed in Pricing Table 2	Base	Opt Yr. 1	Opt Yr. 2	Opt Yr. 3	Opt Yr. 4	Six Mo. Option
January 1, 2017 - December 31, 2017	7.18%	7.16%
January 1, 2018 - December 31, 2018	7.10%		7.09%
January 1, 2019 - December 31, 2019	7.05%			7.04%
January 1, 2020 - December 31, 2020	7.03%				7.00%
January 1, 2021 - December 31, 2021	6.90%					6.88%
January 1, 2022 - December 31, 2022	6.84%						6.84%

In this example, if G&A is the only proposed indirect cost rate description applicable to aircraft parts, the offeror would multiply, for the base year for example, the RFP-specified
estimated direct cost of $7,200,000 by the 7.16% in cell C4 above, and the result ($515,520) would be entered into cell D25 ("Indirect Costs" column under Base Year) in Pricing Table 3.
This example blends the sample offeror fiscal year with the following period of performance, which is specified in RFP Section L.12(C)(b)(8):
Base Period:	April 3, 2017 through April 2, 2018
Option Year 1:	April 3, 2018 through April 2, 2019
Option Year 2:	April 3, 2019 through April 2, 2020
Option Year 3:	April 3, 2020 through April 2, 2021
Option Year 4:	April 3, 2021 through April 2, 2022
Six-Month Option to Extend: April 3, 2022 through October 2, 2022
Pursuant to the formulas in columns C through G:
1. There are 273 days from April 3 through December 31, and 92 days (or 93 days for Option Year 2) from January 1 through April 2.
2. Option Year 2, which runs from April 3, 2019 through April 2, 2020, has 366 days because February 29 occurs in 2020. Each other year, except the Six-Month Option to Extend Period, has 365 days.
Pursuant to the formula in cell H9, there are 183 days in the Six-Month Option to Extend Period, and no blending of periods is required.

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