CLIN_Structure.xlsx

XLSX spreadsheet 41 KB Posted Oct 31, 2014

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

Please fill out all proposed pricing on this spreadsheet and the extended prices on the solicitation. This spreadsheet will be incorporated into the contract once award is made.

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
CLIN_Structure.xlsx	XLSX spreadsheet	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
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. If a Block is Blacked Out please only input the Rate. Blocks are Blacked out because that CLIN will not be used during the specified Period of Performance or the Rate will be inputted based of #4 below.

4. Please fill in the rates for the Contingency Flying Hours and Liters in CLINs 0004, 0009, 0014, 1003, and 2003 if your proposed rate is different than the proposed rates from CLINs 0003 and 0006, 0008 and 0011, 0013 and 0016, 1002 and 1005, and 2002 and 2005.

5. 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.

6. 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.

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

8. 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	Totals
Transition	$ - 0
Main Base Fee	$ - 0	$ - 0	$ - 0	$ - 0
Rotary Wing Flying Hours	$ - 0	$ - 0	$ - 0	$ - 0
Cost Riemburseable	$ 3,263,774.00	$ 1,722,417.00	$ 1,774,090.00	$ 6,760,281.00
Supplemental Base Fee	$ - 0	$ - 0	$ - 0	$ - 0
Rotary Wing Bulk Fuel Transfer	$ - 0	$ - 0	$ - 0	$ - 0
	$3,263,774.00	$1,722,417.00	$1,774,090.00	$6,760,281.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	$ 6,760,281.00	100.00%
Supplemental Base Fee	$ - 0	0.00%
Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
Total	$ 6,760,281.00	100%

Base Year Base Year (1 Oct 15 - 31 Dec 15) - 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	$ 344,074.00	100.00%
0005	Supplemental Base Fee	$ - 0	0.00%
0006	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 344,074.00	100%

Base Year (1 Jan 16 - 31 Dec 16) - Estimated Cost Summary

CLIN	Description	IGCE	% of Total
0007	Main Base Fee	$ - 0	0.00%
0008	Rotary Wing Flying Hours	$ - 0	0.00%
0009	Cost Riemburseable	$ 1,376,295.00	100.00%
0010	Supplemental Base Fee	$ - 0	0.00%
0011	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 1,376,295.00	100%

Base Year (1 Jan 17 - 31 Dec 17) - Estimated Cost Summary

CLIN	Description	IGCE	% of Total
0012	Main Base Fee	$ - 0	0.00%
0013	Rotary Wing Airlift Hours	$ - 0	0.00%
0014	Cost Riemburseable	$ 1,543,405.00	100.00%
0015	Supplemental Base Fee	$ - 0	0.00%
0016	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 1,543,405.00	100%

Base Year Total (Two Years and Three Months) $ 3,263,774.00

CLIN 0001 FFP (1 Aug 15 - 30 Sep 15)

Main Base Fee					FFP Amount
CLIN 0001	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	FFP Base Yr			$ - 0
CLIN 0002 FFP (1 Oct 15 - 31 Dec 15) (Three Months)

Main Base Fee						FFP Amount
CLIN 0002	QTY	Unit	Unit Price per Day	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Base fee Zone 1 - Inuvik	3	Months	$ - 0	$ - 0	$ - 0	3	Months	$ - 0	$ - 0
Base fee Zone 2 -Cambridge Bay	3	Months	$ - 0	$ - 0	$ - 0	FFP Base Yr			$ - 0
Base fee Zone 3 - Hall Beach	3	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 4 - Iqaluit	3	Months	$ - 0	$ - 0	$ - 0
Base fee Zone 5 - Goose Bay	3	Months	$ - 0	$ - 0	$ - 0
	Base Year Totals				$ - 0
CLIN 0003 FFP (1 Oct 15 - 31 Dec 15)

Rotary Wing Flying Hours						FFP Amount
CLIN 0003	QTY	Unit	Hourly Rate	Unit Price per Month	Extended Amount	QTY	Unit	Unit Price	Total
Rotary Wing Flying Hours	475	Hours	$ - 0	$ - 0	$ - 0	3	Months	$ - 0	$ - 0
	Base Year Totals				$ - 0	FFP Base Yr			$ - 0
CLIN 0004 CR (1 Oct 15 - 31 Dec 15)

Cost Reimburseable					Cost Reimburseable Amount
CLIN 0004	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	300	Hours	$ - 0	$ - 0	$ 344,074.00	Lot	$ 1.00	$ 344,074.00
Contingency Rotary Bulk Fuel Transfer Liters	0	Liters	$ - 0	$ - 0	COST Base Yr			$ 344,074.00
Reimburseable Expenses	$ 344,074.00	Lot	$ 1.00	$ 344,074.00
	Base Year Totals			$ 344,074.00
CLIN 0005 CR (1 Oct 15 - 31 Dec 15)

Supplemental Base Fee
CLIN 0005	QTY	Unit	Unit Price per Day
Supplemental Base Fee Zone 1 - Inuvik	0	Days	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	0	Days	$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	0	Days	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	0	Days	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	0	Days	$ - 0
	Base Year Totals
CLIN 0006 CR (1 Oct 15 - 31 Dec 15)

Rotary Wing Bulk Fuel Transfer
CLIN 0006	AVERAGE QTY	Unit	Unit Price per Liter
Rotary Bulk Fuel Transfer	1,500,000	Liters	$ - 0
	Base Year Totals
CLIN 0007 FFP (1 Jan 16 - 31 Dec 16) (First Year)

Main Basing Fee						FFP Amount
CLIN 0007	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	FFP Base Yr			$ - 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
	Base Year Totals				$ - 0
CLIN 0008 FFP (1 Jan 16 - 31 Dec 16)

Rotary Wing Flying Hours						FFP Amount
CLIN 0008	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
	Base Year Totals				$ - 0	FFP Base Yr			$ - 0
CLIN 0009 CR (1 Jan 16 - 31 Dec 16)

Cost Reimburseable					Cost Reimburseable Amount
CLIN 0009	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	900	Hours	$ - 0	$ - 0	$ 1,376,295.00	Lot	$ 1.00	$ 1,376,295.00
Contingency Rotary Bulk Fuel Transfer Liters	500000	Liters	$ - 0	$ - 0	COST Base Yr			$ 1,376,295.00
Reimburseable Expenses	$ 1,376,295.00	Lot	$ 1.00	$ 1,376,295.00
	Base Year Totals			$ 1,376,295.00
CLIN 0010 (1 Jan 16 - 31 Dec 16)

Supplemental Base Fee
CLIN 0010	QTY	Unit	Unit Price per Day
Supplemental Base Fee Zone 1 - Inuvik	1	Days	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	1	Days	$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	1	Days	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	1	Days	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	1	Days	$ - 0
	Base Year Totals
CLIN 0011 CR (1 Jan 16 - 31 Dec 16)

Rotary Wing Bulk Fuel Transfer					FFP Amount
CLIN 0011	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
	Base Year Totals			$ - 0	FFP Base Yr			$ - 0
CLIN 0012 FFP (1 Jan 17 - 31 Dec 17) (Second Year)

Main Base Fee						Monthly FFP Amount
CLIN 0012	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	FFP Base Yr			$ - 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
	Base Year Totals				$ - 0
CLIN 0013 FFP (1 Jan 17 - 31 Dec 17)

Rotary Wing Flying Hours						FFP Amount
CLIN 0013	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
	Base Year Totals				$ - 0	FFP Base Yr			$ - 0
CLIN 0014 CR (1 Jan 17 - 31 Dec 17)

Cost Reimburseable					Cost Reimburseable Amount
CLIN 0014	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	900	Hours	$ - 0	$ - 0	$ 1,543,405.00	Lot	$ 1.00	$ 1,543,405.00
Contingency Rotary Bulk Fuel Transfer Liters	500000	Liters	$ - 0	$ - 0	COST Base Yr			$ 1,543,405.00
Reimburseable Expenses	$ 1,543,405.00	Lot	$ 1.00	$ 1,543,405.00
	Base Year Totals			$ 1,543,405.00
CLIN 0015 (1 Jan 17 - 31 Dec 17)

Supplemental Base Fee
CLIN 0015	QTY	Unit	Unit Price per Day
Supplemental Base Fee Zone 1 - Inuvik	1	Days	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	1	Days	$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	1	Days	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	1	Days	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	1	Days	$ - 0
	Base Year Totals
CLIN 0016 CR (1 Jan 17 - 31 Dec 17)

Rotary Wing Bulk Fuel Transfer					FFP Amount
CLIN 0016	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
	Base Year Totals			$ - 0	FFP Base Yr			$ - 0

Option Year 1 Option Year 1 (1 Jan 18 - 31 Dec 18) - 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,722,417.00	100.00%
1004	Supplemental Base Fee	$ - 0	0.00%
1005	Rotary Wing Bulk Fuel Transfer	$ - 0	0.00%
	Total	$ 1,722,417.00	100%

CLIN 1001 FFP (1 Jan 18 - 31 Dec 18)

Main Base Fee						FFP Amount
CLIN 1001	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	FFP Option Yr 1			$ - 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
	Option Year 1 Totals				$ - 0
CLIN 1002 FFP (1 Jan 18 - 31 Dec 18)

Rotary Wing Flying Hours						FFP Amount
CLIN 1002	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
	Option Year 1 Totals				$ - 0	FFP Option Yr 1			$ - 0
CLIN 1003 CR (1 Jan 18 - 31 Dec 18)

Cost Reimburseable					Cost Reimburseable Amount
CLIN 1003	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	COST Option Yr 1			$ 1,722,417.00
Reimburseable Expenses	$ 1,722,417.00	Lot	$ 1.00	$ 1,722,417.00
	Option Year 1 Totals			$ 1,722,417.00
CLIN 1004 (1 Jan 18 - 31 Dec 18)

Supplemental Base Fee
CLIN 1004	QTY	Unit	Unit Price per Day
Supplemental Base Fee Zone 1 - Inuvik	1	Days	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	1	Days	$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	1	Days	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	1	Days	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	1	Days	$ - 0
	Option Year 1 Totals
CLIN 1005 CR (1 Jan 18 - 31 Dec 18)

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

Option Year 2 Option Year 2 (1 Jan 19 - 31 Dec 19) - Estimated Cost Summary

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

CLIN 2001 FFP (1 Jan 19 - 31 Dec 19)

Main Base Fee						FFP Amount
CLIN 2001	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	FFP Option Yr 2			$ - 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
	Option Year 2 Totals				$ - 0
CLIN 2002 FFP (1 Jan 19 - 31 Dec 19)

Rotary Wing Flying Hours						FFP Amount
CLIN 2002	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
	Option Year 2 Totals				$ - 0	FFP Option Yr 2			$ - 0
CLIN 2003 CR (1 Jan 19 - 31 Dec 19)

Cost Reimburseable					Cost Reimburseable Amount
CLIN 2003	QTY	Unit	Unit Price	Extended Amount	QTY	Unit	Unit Price	Total
Contingency Flying Hours	900	Hours	$ - 0	$ - 0	$ 1,774,090.00	Lot	$ 1.00	$ 1,774,090.00
Contingency Rotary Bulk Fuel Transfer Liters	500000	Liters	$ - 0	$ - 0	COST Option Yr 2			$ 1,774,090.00
Reimburseable Expenses	$ 1,774,090.00	Lot	$ 1.00	$ 1,774,090.00
	Option Year 2 Totals			$ 1,774,090.00
CLIN 2004 (1 Jan 19 - 31 Dec 19)

Supplemental Base Fee
CLIN 2004	QTY	Unit	Unit Price per Day
Supplemental Base Fee Zone 1 - Inuvik	1	Days	$ - 0
Supplemental Base fee Zone 2 - Cambridge Bay	1	Days	$ - 0
Supplemental Base Fee Zone 3 - Hall Beach	1	Days	$ - 0
Supplemental Base Fee Zone 4 - Iqaluit	1	Days	$ - 0
Supplemental Base Fee Zone 5 - Goose Bay	1	Days	$ - 0
	Option Year 2 Totals
CLIN 2005 CR (1 Jan 19 - 31 Dec 19)

Rotary Wing Bulk Fuel Transfer					FFP Amount
CLIN 2005	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
	Option Year 2 Totals			$ - 0	FFP Option Yr 2			$ - 0

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