Attachment_4_-_ADAIR_II_Pricing_Worksheet.xlsx

Other files attached to Nellis AFB ADAIR II, newest first.
File	Type	Posted
Attachment_4_-_Revised_ADAIR_II_Pricing_Worksheet.xlsx	XLSX spreadsheet	Apr 3, 2018
FA486118RC0030002_Nellis_ADAIR_II_Amendment_02.pdf	PDF	Apr 3, 2018
Nellis_ADAIR_II_RFP_Q&A_3.pdf	PDF	Mar 29, 2018
Nellis_ADAIR_II_RFP_Q&A_2.pdf	PDF	Mar 27, 2018
FA486118RC0030001_Nellis_ADAIR_II_Amendment.pdf	PDF	Mar 23, 2018
Nellis_ADAIR_II_RFP_Q&A.pdf	PDF	Mar 23, 2018
Attachment_7_-_PPQ_Cover_Letter_Questionnaire.pdf	PDF	Mar 23, 2018
ADAIR_II_Industry_Day_Attendance_Roster.pdf	PDF	Mar 8, 2018
Attachment_5_-_WD_15-5593_(Rev._-8).pdf	PDF	Mar 3, 2018
Attachment_1a_-_PPI_Tool_Instructions.docx	DOCX document	Mar 3, 2018
Attachment_2_-_Oral_Presentation_Slide_Master.pptx	PPTX presentation	Mar 3, 2018
Attachment_4_-_Pricing_Worksheet.xlsx	XLSX spreadsheet	Mar 3, 2018
Attachment_6_-_DD_Form_254.pdf	PDF	Mar 3, 2018
Attachment_3_-_Small_Business_Subcontracting_Plan_Checklist.pdf	PDF	Mar 3, 2018
Attachment_1_-_PPI_Tool.accdb	MDB file	Mar 3, 2018
FA486118RC003_Nellis_ADAIR_II_Solicitation.pdf	PDF	Mar 3, 2018
Industry_Briefing.pdf	PDF	Jan 16, 2018
Section_L_007.pdf	PDF	Jan 4, 2018
Section_M_009.pdf	PDF	Jan 4, 2018
ADAIR_PWS.pdf	PDF	Jan 4, 2018
Base_Access_Template.xlsx	XLSX spreadsheet	Jan 2, 2018

ADAIR II Pricing Worksheet - Example
	Pricing Estimated Flight Hours	5600
	Number of Proposed Aircraft	20
	Jet Fuel Cost per Gallon	$ 3.00

INSTRUCTIONS

1. Cells that are filled in with the peach color must be filled in by the offeror. Cells that are filled in with blue will auto-generate and are locked. Rows are able to be copied for additional aircraft. Offerors must ensure formula continuity.

2. Tail numbers for each proposed aircraft must correspond with the offeror’s technical proposal. All aircraft that are being proposed as part of the Nellis ADAIR II contract must be represented in the Matrix.

3. Offerors may propose as many aircraft (number and type) as they see appropriate for the contract. Proposed aircraft must meet the minimum requirements specified in the PWS in order to be considered for an award.

4. Offerors must establish a Line Item number in Column A of this spreadsheet for each type of aircraft proposed that has a different flight hour cost. Number sequencially beginning with Line Item 0001, Line Item 0002, Line Item 0003, etc. Offerors that undergo extensive modification to existing aircraft in the future to improve capability should create a new Line Item number in the pricing worksheet to reflect any change in price. Furthermore, these changes should be presented and articulated in the technical proposal section.

5. Offerors must fill in the total number of aircraft(s) proposed under this Matrix in Cell C3. Total number of aircraft in Cell C3 must equal the total number of aircraft proposed in Column B.

6. Offerors must fill in the Aircraft Make and Model in the respective cell in Column B.

7. Offerors must provide each Aircraft Tail Number in Column C.

8. Offerors must provide the dry (without fuel cost) Flight Hour Cost for each aircraft in Column D. Flight Hour Cost includes, maintenance, personnel, material, travel, as well as any other associated cost required to support the ADAIR mission.

9. Offerors must propose the Average Fuel Consumption rate (Gallons per Hour (GPH) for each aircraft with the following assumptions: 30,000 feet altitude, 75% power, standard atmospheric temperature and pressure in Column E.

10. The Fuel Cost Per Hour, Flight Hours, Aircraft Tail Cost, and Fuel Cost cells will auto-generate. For estimating/evaluating purposes, the fuel rate is fixed at $3.00 per gallon.

11. Offerors must fill out pricing sheets for each ordering period located in each tab of the Matrix located below, (Ordering Period 1 - Year 1, Ordering Period 1 - Year 2, etc.), for each ordering period and year, which corresponds to one year (365 days) of estimated flying.

Line Item	Aircraft Make & Model	Aircraft Tail Number	Flight Hour Cost (Dry)	Average Fuel Consumption in GPH	Estimated Fuel Cost Per Hour ($3 per gallon)	Flight Hours	Estimated Total/Aircraft Tail	Fuel Cost
0001	C-172	N111	$ 6,000.00	600	$ 1,800.00	280	$ 1,680,000.00	$ 504,000.00
	C-172	N222	$ 6,000.00	600	$ 1,800.00	280	$ 1,680,000.00	$ 504,000.00
	C-172	N333	$ 6,000.00	600	$ 1,800.00	280	$ 1,680,000.00	$ 504,000.00
0002	PA-28	N444	$ 7,000.00	400	$ 1,200.00	280	$ 1,960,000.00	$ 336,000.00
	PA-28	N666	$ 7,000.00	400	$ 1,200.00	280	$ 1,960,000.00	$ 336,000.00
	PA-28	N777	$ 7,000.00	400	$ 1,200.00	280	$ 1,960,000.00	$ 336,000.00
0003	C-182	N888	$ 15,000.00	1500	$ 4,500.00	280	$ 4,200,000.00	$ 1,260,000.00
	C-182	N999	$ 15,000.00	1500	$ 4,500.00	280	$ 4,200,000.00	$ 1,260,000.00
	C-182	N123	$ 15,000.00	1500	$ 4,500.00	280	$ 4,200,000.00	$ 1,260,000.00
0004	BE-36	N234	$ 8,000.00	800	$ 2,400.00	280	$ 2,240,000.00	$ 672,000.00
	BE-36	N345	$ 8,000.00	800	$ 2,400.00	280	$ 2,240,000.00	$ 672,000.00
	BE-36	N456	$ 8,000.00	800	$ 2,400.00	280	$ 2,240,000.00	$ 672,000.00
0005	PA-36	N567	$ 14,000.00	1300	$ 3,900.00	280	$ 3,920,000.00	$ 1,092,000.00
	PA-36	N678	$ 14,000.00	1300	$ 3,900.00	280	$ 3,920,000.00	$ 1,092,000.00
	PA-36	N098	$ 14,000.00	1300	$ 3,900.00	280	$ 3,920,000.00	$ 1,092,000.00
0006	C-152	N983	$ 13,000.00	1400	$ 4,200.00	280	$ 3,640,000.00	$ 1,176,000.00
	C-152	NA3D	$ 13,000.00	1400	$ 4,200.00	280	$ 3,640,000.00	$ 1,176,000.00
	C-152	N432	$ 13,000.00	1400	$ 4,200.00	280	$ 3,640,000.00	$ 1,176,000.00
0007	BE-35	N11GG	$ 200.00	14	$ 42.00	280	$ 56,000.00	$ 11,760.00
	BE-35	N22GG	$ 200.00	14	$ 42.00	280	$ 56,000.00	$ 11,760.00
					Subtotal	5600	$ 53,032,000.00	$ 15,143,520.00
					Total Ordering Period X - Year X		$ 68,175,520.00

ADAIR II Pricing Worksheet - Example
	Pricing Estimated Flight Hours	5600
	Number of Proposed Aircraft
	Jet Fuel Cost per Gallon	$ 3.00