Attachment_4_-_Pricing_Worksheet.xlsx

XLSX spreadsheet 30 KB Posted Mar 3, 2018

Attached to: Nellis AFB ADAIR II Federal contract opportunity
Solicitation number: FA4861-18-R-C003
Issued by: Department of the Air Force Air Combat Command

About this file

From the source

Pricing Worksheet

View the file

Other files for this federal contract opportunity

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
Attachment_4_-_ADAIR_II_Pricing_Worksheet.xlsx	XLSX spreadsheet	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_2_-_Oral_Presentation_Slide_Master.pptx	PPTX presentation	Mar 3, 2018
Attachment_6_-_DD_Form_254.pdf	PDF	Mar 3, 2018
Attachment_1a_-_PPI_Tool_Instructions.docx	DOCX document	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

Show all 21

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.

Example

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

Directions, Assumptions, Notes

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

2. Tail numbers 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 this 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 in order to be considered for an award.

4. Offerors must establish a unique Contract Line Item Number (CLIN) in Column A of this spreadsheet for each type of aircraft proposed that has a unique flight hour price. Numbering begins with 0001, 0002, 0003, etc.

5. Offerors must fill in the total number of aircraft proposed under this matrix in cell C3

6. Offerors must fill in the aircraft make in 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 price) flight hour cost for each aircraft in column D

9. Offerors must propose the average fuel consumption rate for each aircraft with the following assumptions: 30,000 ft altitude, 75% power, standard atmospheric temperature and pressure.

10. The fuel cost per hour, flight hours, aircraft tail cost, and estimated fuel cost per hour will auto-generate.

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

CLINs	Aircraft Make & Model	Aircraft Tail Number	Flight Hour Price (Dry)	Average Fuel Consumption in GPH	Estimated Fuel Cost Per Hour ($3 per gallon)	Flight Hours	Estimated Total/Aircraft Tail	Fuel Cost
CLIN 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
CLIN 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
CLIN 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
CLIN 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
CLIN 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
CLIN 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
CLIN 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 Evaluated Price		$ 68,175,520.00

Ordering Period 1 - Year 1

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