CLIN_Structure.xlsx

XLSX spreadsheet 58 KB Posted Mar 6, 2015

Attached to: North Warning System Rotary Wing Airlift Services
Solicitation number: FA4890-14-R-0002
Issued by: Department of the Air Force Air Combat Command

About this file

From the source

Solicitation CLIN Structure to be filled in and submitted with Proposal

View the file

Other files

File	Type	Posted
FA4890-14-R-0002_NWS_Rotary_Wing_Solicitation.pdf	PDF	Mar 6, 2015
Attachment_2_-_Aircraft_Unavailablility_Record.docx	DOCX document	Mar 6, 2015
Attachment_1_-_NWS_PWS_Rotary_Wing_as_of_06_Mar_15.docx	DOCX document	Mar 6, 2015
Attachment_3_-_List_of_Aircraft.docx	DOCX document	Mar 6, 2015
Attachment_6_-_Cost_Summary_Report.xlsx	XLSX spreadsheet	Mar 6, 2015
Attachment_1b_to_PWS_-_Aircraft_Business_Licence_Application_Form.pdf	PDF	Mar 6, 2015
Attachment_4_-_WAWF.docx	DOCX document	Mar 6, 2015
Attachment_1a_to_PWS_-_MOU_Between_DND_-_PCA.pdf	PDF	Mar 6, 2015
Attachment_5_-_Rotary_NWS_Flight_Log.docx	DOCX document	Mar 6, 2015
NWS_Rotary_Wing_Synopsis.doc	DOC document	Jan 15, 2015
Draft_Solicitation_Q_ _A's.docx	DOCX document	Nov 24, 2014
past_three_years_of_bulk_fuel_transfer.xls	XLS spreadsheet	Nov 24, 2014
Helipad_Types_NWS.pdf	PDF	Nov 24, 2014
Attachment_2_-_Aircraft_Unavailablility_Record.docx	DOCX document	Oct 31, 2014
Attachment_5_-_Rotary_NWS_Flight_Log.docx	DOCX document	Oct 31, 2014
Attachment_1_-_NWS_PWS_Rotary_Wing_as_of_14_Oct_14.docx	DOCX document	Oct 31, 2014
Attachment_4_-_WAWF.docx	DOCX document	Oct 31, 2014
Attachment_3_-_List_of_Aircraft.docx	DOCX document	Oct 31, 2014
CLIN_Structure.xlsx	XLSX spreadsheet	Oct 31, 2014
FA4890-14-R-0002_Draft_NWS_Rotary_Wing_RFP.doc	DOC document	Oct 31, 2014
Attachment_6_-_Cost_Summary_Report.xlsx	XLSX spreadsheet	Oct 31, 2014
NWS_Industry_Day_Sign_In_Sheet.pdf	PDF	Sep 8, 2014
NWS_Industry_Day_Briefing_ver.1.pptx	PPTX presentation	Sep 8, 2014
Draft_PWS_-_NWS_Main-Supp_Rotary_Wing_as_of_(5_Aug_14).docx	DOCX document	Aug 7, 2014
Industry_Day_Announcement_-_Amendment_1.docx	DOCX document	Aug 1, 2014
Industry_Day_Announcement.pdf	PDF	Jul 15, 2014
PWS_Draft_NWS_Main-Supp_Rotary_Wing_SS.pdf	PDF	Oct 16, 2013
ATTACHMENT_1_for_Main_Rotary.pdf	PDF	Oct 16, 2013

Show all 28

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.

Worksheet Instructions

1. Please do not modify any of the formulas within the Speadsheet.

2. Please only input the Unit/Hourly/Daily/Liter Rates on the left side of the Spreadsheet. The Right side should Auto fill once you input your Rates.

3. Please do not modify the quantities listed.

4. Please do not modify the amount listed in the Reimbusable Expense Line. This amount is a plug figure so all proposals have the same amount.

5. The Proposed rate inputted in the Supplemental Base Fee will be the cost that will be evaluated. Since the location of the helicopters are unknown each day, this CLIN will be invoiced IAW PWS Appendix 2, Para 4.1.. This CLIN will be funded for 244 days based off the rates proposed.

6. Please only input your rates on the Base Year, Option Year 1, Option Year 2 and Option Year 3 Tabs. The Summary Tab will Auto fill once you complete the other tabs.

7. This worksheet will be incorporated into the contract of the winning offeror.

Summary

NWS ROTARY WING AIRLIFT CONTRACT

Description	Base Yr	Option Yr 1	Option Yr 2	Option Yr 3	Option Yr 4	Totals
Transition	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Main Base Fee	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Rotary Wing Flying Hours	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Cost Riemburseable	$ 688,148.00	$ 1,376,295.00	$ 1,543,405.00	$ 1,722,417.00	$ 1,774,090.00	$ 7,104,355.00
Supplemental Base Fee	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Rotary Wing Bulk Fuel Transfer	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ 688,148.00	$ 1,376,295.00	$ 1,543,405.00	$ 1,722,417.00	$ 1,774,090.00	$ 7,104,355.00

Cost Summary

Description	IGCE	% of Total
Transition	$ - 0	0.00%
Main Base Fee	$ - 0	0.00%
Rotary Wing Flying Hours	$ - 0	0.00%
Cost Riemburseable	$ 7,104,355.00	100.00%
Supplemental Base Fee	$ - 0	0.00%
Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
Total	$ 7,104,355.00	100%

Base Year Base Period (1 Oct 15 - 31 Mar 16) - Estimated Cost Summary

CLIN	Description	IGCE	% of Total
0001	Transition	$ - 0	0.00%
0002	Main Base Fee	$ - 0	0.00%
0003	Rotary Wing Flying Hours	$ - 0	0.00%
0004	Cost Riemburseable	$ 688,148.00	100.00%
0005	Supplemental Base Fee	$ - 0	0.00%
0006	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 688,148.00	100%

CLIN 0001 FFP

Transition					FFP Amount
Description	QTY	Unit	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Transition	2	Months	$ - 0	$ - 0	2	Months	$ - 0	$ - 0
	Transition Total			$ - 0				$ - 0
CLIN 0002 FFP

Main Base Fee						FFP Amount
Description	QTY	Unit	Unit Price per Day	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Base fee Zone 1 - Inuvik	6	Months	$ - 0	$ - 0	$ - 0	6	Months	$ - 0	$ - 0
Base fee Zone 2 -Cambridge Bay	6	Months	$ - 0	$ - 0	$ - 0				$ - 0
Base fee Zone 3 - Hall Beach	6	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 4 - Iqaluit	6	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 5 - Goose Bay	6	Months	$ - 0	$ - 0	$ - 0
	Totals				$ - 0
CLIN 0003 FFP

Rotary Wing Flying Hours						FFP Amount
Description	QTY	Unit	Hourly Rate	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Wing Flying Hours	1100	Hours	$ - 0	$ - 0	$ - 0	6	Months	$ - 0	$ - 0
	Totals				$ - 0				$ - 0
CLIN 0004 CR

Cost Reimburseable					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	550	Hours	$ - 0	$ - 0	$ 688,148.00	Lot	$ 1.00	$ 688,148.00
Contingency Rotary Bulk Fuel Transfer Liters	0	Liters	$ - 0	$ - 0				$ 688,148.00
Reimburseable Expenses	$ 688,148.00	Lot	$ 1.00	$ 688,148.00
	Totals			$ 688,148.00
CLIN 0005 CR

Supplemental Base Fee					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price per Day	Extended Amount	QTY	Unit	Unit Price	Total
Supplemental Base Fee Zone 1 - Inuvik	48.8	Days	$ - 0	$ - 0	0	Lot	$ 1.00	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	48.8	Days	$ - 0	$ - 0				$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	48.8	Days	$ - 0	$ - 0
	Totals			$ - 0
CLIN 0006 FFP

Rotary Wing Bulk Fuel Transfer					FFP Amount
Description	AVERAGE QTY	Unit	Unit Price per Liter	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Bulk Fuel Transfer	1,500,000	Liters	$ - 0	$ - 0	0	Liters	$ - 0	$ - 0
	Totals			$ - 0				$ - 0

Option Year 1 Option Year 1 (1 Apr 16 - 31 Mar 17) - Estimated Cost Summary

CLIN	Description	IGCE	% of Total
1001	Main Base Fee	$ - 0	0.00%
1002	Rotary Wing Flying Hours	$ - 0	0.00%
1003	Cost Riemburseable	$ 1,376,295.00	100.00%
1004	Supplemental Base Fee	$ - 0	0.00%
1005	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 1,376,295.00	100%

CLIN 1001 FFP

Main Basing Fee						FFP Amount
Description	QTY	Unit	Unit Price per Day	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Base fee Zone 1 - Inuvik	12	Months	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
Base fee Zone 2 -Cambridge Bay	12	Months	$ - 0	$ - 0	$ - 0				$ - 0
Base fee Zone 3 - Hall Beach	12	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 4 - Iqaluit	12	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 5 - Goose Bay	12	Months	$ - 0	$ - 0	$ - 0
	Totals				$ - 0
CLIN 1002 FFP

Rotary Wing Flying Hours						FFP Amount
Description	QTY	Unit	Hourly Rate	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Wing Flying Hours	2200	Hours	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
	Totals				$ - 0				$ - 0
CLIN 1003 CR

Cost Reimburseable					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	1100	Hours	$ - 0	$ - 0	$ 1,376,295.00	Lot	$ 1.00	$ 1,376,295.00
Contingency Rotary Bulk Fuel Transfer Liters	500000	Liters	$ - 0	$ - 0				$ 1,376,295.00
Reimburseable Expenses	$ 1,376,295.00	Lot	$ 1.00	$ 1,376,295.00
	Totals			$ 1,376,295.00
CLIN 1004 CR

Supplemental Base Fee					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price per Day	Extended Amount	QTY	Unit	Unit Price	Total
Supplemental Base Fee Zone 1 - Inuvik	48.8	Days	$ - 0	$ - 0	$ - 0	Lot	$ 1.00	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	48.8	Days	$ - 0	$ - 0				$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	48.8	Days	$ - 0	$ - 0
	Totals			$ - 0
CLIN 1005 FFP

Rotary Wing Bulk Fuel Transfer					FFP Amount
Description	AVERAGE QTY	Unit	Unit Price per Liter	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Bulk Fuel Transfer	1,500,000	Liters	$ - 0	$ - 0	1,500,000	Liter	$0.00	$ - 0
	Totals			$ - 0				$ - 0

Option Year 2 Option Year 2 (1 Apr 17 - 31 Mar 18) - Estimated Cost Summary

CLIN	Description	IGCE	% of Total
2001	Main Base Fee	$ - 0	0.00%
2002	Rotary Wing Airlift Hours	$ - 0	0.00%
2003	Cost Riemburseable	$ 1,543,405.00	100.00%
2004	Supplemental Base Fee	$ - 0	0.00%
2005	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 1,543,405.00	100%

CLIN 2001 FFP

Main Base Fee						Monthly FFP Amount
Description	QTY	Unit	Unit Price per Day	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Base fee Zone 1 - Inuvik	12	Each	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
Base fee Zone 2 -Cambridge Bay	12	Each	$ - 0	$ - 0	$ - 0				$ - 0
Base fee Zone 3 - Hall Beach	12	Each	$ - 0	$ - 0	$ - 0
Base fee Zone 4 - Iqaluit	12	Each	$ - 0	$ - 0	$ - 0
Base fee Zone 5 - Goose Bay	12	Each	$ - 0	$ - 0	$ - 0
	Totals				$ - 0
CLIN 2002 FFP

Rotary Wing Flying Hours						FFP Amount
Description	QTY	Unit	Hourly Rate	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Wing Flying Hours	2200	Hours	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
	Totals				$ - 0				$ - 0
CLIN 2003 CR

Cost Reimburseable					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	1100	Hours	$ - 0	$ - 0	$ 1,543,405.00	Lot	$ 1.00	$ 1,543,405.00
Contingency Rotary Bulk Fuel Transfer Liters	500000	Liters	$ - 0	$ - 0				$ 1,543,405.00
Reimburseable Expenses	$ 1,543,405.00	Lot	$ 1.00	$ 1,543,405.00
	Totals			$ 1,543,405.00
CLIN 2004 CR

Supplemental Base Fee					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price per Day	Extended Amount	QTY	Unit	Unit Price	Total
Supplemental Base Fee Zone 1 - Inuvik	48.8	Days	$ - 0	$ - 0	$ - 0	Lot	$ 1.00	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	48.8	Days	$ - 0	$ - 0				$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	48.8	Days	$ - 0	$ - 0
	Totals			$ - 0
CLIN 2005 FFP

Rotary Wing Bulk Fuel Transfer					FFP Amount
Description	AVERAGE QTY	Unit	Unit Price per Liter	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Bulk Fuel Transfer	1,500,000	Liters	$ - 0	$ - 0	1,500,000	Liter	$ - 0	$ - 0
	Totals			$ - 0				$ - 0

Option Year 3 Option Year 3 (1 Apr 18 - 31 Mar 19) - Estimated Cost Summary

CLIN	Description	IGCE	% of Total
3001	Main Base Fee	$ - 0	0.00%
3002	Rotary Wing Flying Hours	$ - 0	0.00%
3003	Cost Riemburseable	$ 1,722,417.00	100.00%
3004	Supplemental Base Fee	$ - 0	0.00%
3005	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 1,722,417.00	100%

CLIN 3001 FFP

Main Base Fee						FFP Amount
Description	QTY	Unit	Unit Price per Day	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Base fee Zone 1 - Inuvik	12	Months	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
Base fee Zone 2 -Cambridge Bay	12	Months	$ - 0	$ - 0	$ - 0				$ - 0
Base fee Zone 3 - Hall Beach	12	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 4 - Iqaluit	12	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 5 - Goose Bay	12	Months	$ - 0	$ - 0	$ - 0
	Totals				$ - 0
CLIN 3002 FFP

Rotary Wing Flying Hours						FFP Amount
Description	QTY	Unit	Hourly Rate	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Wing Flying Hours	2200	Hours	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
	Totals				$ - 0				$ - 0
CLIN 3003 CR

Cost Reimburseable					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	900	Hours	$ - 0	$ - 0	$ 1,722,417.00	Lot	$ 1.00	$ 1,722,417.00
Contingency Rotary Bulk Fuel Transfer Liters	500000	Liters	$ - 0	$ - 0				$ 1,722,417.00
Reimburseable Expenses	$ 1,722,417.00	Lot	$ 1.00	$ 1,722,417.00
	Totals			$ 1,722,417.00
CLIN 3004 CR

Supplemental Base Fee					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price per Day	Extended Amount	QTY	Unit	Unit Price	Total
Supplemental Base Fee Zone 1 - Inuvik	48.8	Days	$ - 0	$ - 0	$ - 0	Lot	$ 1.00	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	48.8	Days	$ - 0	$ - 0				$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	48.8	Days	$ - 0	$ - 0
	Totals			$ - 0
CLIN 3005 FFP

Rotary Wing Bulk Fuel Transfer					FFP Amount
Description	AVERAGE QTY	Unit	Unit Price per Liter	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Bulk Fuel Transfer	1,500,000	Liters	$ - 0	$ - 0	1,500,000	Liter	$ - 0	$ - 0
	Totals			$ - 0				$ - 0

Option Year 4 Option Year 4 (1 Apr 19 - 31 Mar 20) - Estimated Cost Summary

CLIN	Description	IGCE	% of Total
4001	Main Base Fee	$ - 0	0.00%
4002	Rotary Wing Flying Hours	$ - 0	0.00%
4003	Cost Riemburseable	$ 1,774,090.00	100.00%
4004	Supplemental Base Fee	$ - 0	0.00%
4005	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 1,774,090.00	100%

CLIN 4001 FFP

Main Base Fee						FFP Amount
Description	QTY	Unit	Unit Price per Day	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Base fee Zone 1 - Inuvik	12	Months	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
Base fee Zone 2 -Cambridge Bay	12	Months	$ - 0	$ - 0	$ - 0				$ - 0
Base fee Zone 3 - Hall Beach	12	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 4 - Iqaluit	12	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 5 - Goose Bay	12	Months	$ - 0	$ - 0	$ - 0
	Totals				$ - 0
CLIN 4002 FFP

Rotary Wing Flying Hours						FFP Amount
Description	QTY	Unit	Hourly Rate	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Wing Flying Hours	2200	Hours	$ - 0	$ - 0	$ - 0	12	Months	$ - 0	$ - 0
	Totals				$ - 0				$ - 0
CLIN 4003 CR

Cost Reimburseable					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	1100	Hours	$ - 0	$ - 0	$ 1,774,090.00	Lot	$ 1.00	$ 1,774,090.00
Contingency Rotary Bulk Fuel Transfer Liters	500000	Liters	$ - 0	$ - 0				$ 1,774,090.00
Reimburseable Expenses	$ 1,774,090.00	Lot	$ 1.00	$ 1,774,090.00
	Totals			$ 1,774,090.00
CLIN 4004 CR

Supplemental Base Fee					Cost Reimburseable Amount
Description	QTY	Unit	Unit Price per Day	Extended Amount	QTY	Unit	Unit Price	Total
Supplemental Base Fee Zone 1 - Inuvik	48.8	Days	$ - 0	$ - 0	$ - 0	Lot	$ 1.00	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	48.8	Days	$ - 0	$ - 0				$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	48.8	Days	$ - 0	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	48.8	Days	$ - 0	$ - 0
	Totals			$ - 0
CLIN 4005 FFP

Rotary Wing Bulk Fuel Transfer					FFP Amount
Description	AVERAGE QTY	Unit	Unit Price per Liter	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Bulk Fuel Transfer Base Yr	1,500,000	Liters	$0.00	$ - 0	1,500,000	Liters	$0.00	$ - 0
	Totals			$ - 0	FFP Option Yr 3			$ - 0

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