Sect L Atch 3 - Cost Price Evaluation Workbook 22 Apr 10.xlsx

XLSX spreadsheet 77 KB Posted Apr 29, 2010

Attached to: KC-X Tanker Modernization Program Federal contract opportunity
Solicitation number: FA8625-10-R-6600
Issued by: Department of the Air Force Materiel Command

About this file

From the source

Sect L Atch 3 - Cost Price Evaluation Workbook 22 Apr 10.xlsx

View the file

Other files for this federal contract opportunity

Other files attached to KC-X Tanker Modernization Program, newest first.
File	Type	Posted
Sect J Atch 7 - VIQ Matrix 18 Jun 2010.pdf	PDF	Jun 24, 2010
Sect J Atch 9 - Option Matrix 18 Jun 2010.pdf	PDF	Jun 24, 2010
Reference Library Summary.pdf	PDF	Jun 24, 2010
Sect M Evaluation Factors for Award 18 Jun 2010.pdf	PDF	Jun 24, 2010
Reference Library 24 Feb 2010 Revision 2.xlsx	XLSX spreadsheet	Jun 24, 2010
Sect L Atch 17 - MILCON Evaluation Plan 18 Jun 2010.pdf	PDF	Jun 24, 2010
FA8625-10-R-6600 Amend 0004.pdf	PDF	Jun 24, 2010
KC-X RFP Questions and Answers 28 May 10.pdf	PDF	May 28, 2010
FA8625-10-R-6600 Amend 0003.pdf	PDF	May 18, 2010
Sect J Atch 2 - EMD SOO 4 May 10.pdf	PDF	May 18, 2010
Sect L Atch 1 - Correlation Matrix 4 May 10.pdf	PDF	May 18, 2010
Sect J Atch 3 - Prod SOO 4 May 10.pdf	PDF	May 18, 2010
Sect L Atch 17 - MILCON Evaluation Plan 22 Apr 10.pdf	PDF	Apr 29, 2010
Sect J Exhibit A - A086 22 Apr 10.pdf	PDF	Apr 29, 2010
Sect L Instruction to Offerors 22 Apr 10.pdf	PDF	Apr 29, 2010
Sect J Atch 3 - Prod SOO 22 Apr 10.pdf	PDF	Apr 29, 2010
Sect L Atch 18 - PPI Tool.mdb	MDB file	Apr 29, 2010
Sect J Exhibit C - C051 22 Apr 10.pdf	PDF	Apr 29, 2010
FA8625-10-R-6600 Amend 0002 22 Apr 10.pdf	PDF	Apr 29, 2010
Sect J Atch 2 - EMD SOO 22 Apr 10.pdf	PDF	Apr 29, 2010
Reference Library Revision 1_Change Summary Page.pdf	PDF	Apr 29, 2010
Sect L Atch 1 - Correlation Matrix 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect L Atch 4 - Requirements Prioritization 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 1 - SRD 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 8 - TMCR - TM-86-01N 24 Feb 10.doc	DOC document	Feb 24, 2010
Sect L Atch 14 - Past Performance Questionnaire Tracking Record 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect L Atch 11 - Past Performance Questionnaire Cover Letter 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Exhibit A - EMD NON-OMIT CDRLs 24 Feb 10.docx	DOCX document	Feb 24, 2010
Sect L Atch 9 - Past Performance Factsheets 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 9 - Option Matrix 24 Feb 10.xlsx	XLSX spreadsheet	Feb 24, 2010
Sect J Atch 7 - VIQ Option Matrix 24 Feb 10.docx	DOCX document	Feb 24, 2010
Sect L Atch 12 - Past Performance Client Authorization Letter 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect L Atch 3 - Cost Price Evaluation Workbook 24 Feb 10.xlsx	XLSX spreadsheet	Feb 24, 2010
Sect L Atch 2 - Weapon System Integrity Matrix 24 Feb 10.xlsx	XLSX spreadsheet	Feb 24, 2010
Sect J Exhibit C - Prod NON-OMIT CDRLs 24 Feb 10.docx	DOCX document	Feb 24, 2010
Sect L Atch 7 - IFARA Data Input Package 24 Feb 10.xlsx	XLSX spreadsheet	Feb 24, 2010
Sect M - Eval Factors for Award 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 3 - Prod SOO 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect L Atch 17 - MILCON Evaluation Plan 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 6 - IMP 24 Feb 10.docx	DOCX document	Feb 24, 2010
Sect J Atch 5 - AFMC Form 158 24 Feb 10.pdf	PDF	Feb 24, 2010
FA8625-10-R-6600 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 10 - Live Fire Asset List 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 11-22 - CSDR 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect L Atch 15 - Acronym List 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 24 - Definitions 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect L Atch 13 - Example Format for Past Performance Consent Letter 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Atch 2 - EMD SOO 24 Feb 10.pdf	PDF	Feb 24, 2010
Sect J Exhibit D - Prod OMIT CDRLs 24 Feb 10.docx	DOCX document	Feb 24, 2010
Sect J Exhibit B - EMD OMIT CDRLs 24 Feb 10.docx	DOCX document	Feb 24, 2010

Show all 50

KC-X Tanker Modernization Program has more files on GovTribe.

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.

EMD Acquisition Price

EMD Acquisition Price
Offeror's Name:
Offeror A
KC-X Program (TY$ - units in dollars & cents)
Contract Phase: EMD
CLIN Title	CLIN #	Contract	Target Price or FFP (FY)	Target Price or FFP (FY)	Target Price or FFP (FY)	Target Price or FFP (FY)	Target Price or FFP (FY)	Target Price or FFP (FY)	Target Price or FFP (FY)	Target Price or FFP (FY)	Target Price or FFP (FY)	Total Price	Facilities Capital Cost of Money (FCCOM)	Profit (Target Cost Less FCCOM multiplied by 12%)	Target Cost (Total Price less Profit)	Overrun to Ceiling Price (FY) (Ceiling Price less Total Price)	Ceiling Price
		Type	2011	2012	2013	2014	2015	2016	2017	2018	2019					XXXX	(Ceiling Price for FPIF CLINs is 125% of Target Cost; Ceiling for FFP CLINs is Total Price)
Engineering and Manufacturing Development (4 A/C)	0001	FPIF										0.00		0.00	0.00	0.00	0.00
Data (Non-Omit) for Engineering and Manufacturing Development	0002	FPIF/NSP	0.00
EMD Studies and Analyses	0003	FFP										0.00					0.00
EMD Live Fire Assets	0004	FPIF										0.00		0.00	0.00	0.00	0.00
Simulator Data Package	0005	FPIF										0.00		0.00	0.00	0.00	0.00
Operations, Maintenance, Installation and Training (OMIT) Data	0006	FPIF										0.00		0.00	0.00	0.00	0.00
Data License	0007	FFP										0.00					0.00
Type 1 Training in EMD	0008	FFP										0.00					0.00
Pre-Operational Support	0009	FPIF										0.00		0.00	0.00	0.00	0.00
TOTAL (TY$) PRICE			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00				0.00	0.00
Note: "Green" TOTAL (TY$) cell(s) highlight peak funding year(s)

Present Value (PV) Discount Factor	0.9783	0.9362	0.8958	0.8573	0.8203	0.7850	0.7512	0.7189	0.6879	0
											TOTAL EMD PV$
Engineering and Manufacturing Development PV$	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Prod Lots 1-13 Acq Price Production Lots 1-13 Acquisition Price

Offeror's Name: Offeror A

KC-X Program (TY$ - units in dollars & cents)

Contract Phase: Production Lots 1-13

Lot #

Aircraft

CLIN Title

CLIN #

Contract

Price (FY)

Price

Qty

Type

XXXX

Total

Lot #1

Total

0.00

Low-Rate Initial Production (Lot 1) w/Engines

0101

FFP

Warranty of LRIP Lot 1

0102

FFP

0.00

Data for LRIP Lot 1

0103

FFP/NSP

Interim Contractor Support (ICS) Year 1

0104

FFP

0.00

Spare Engines for LRIP Lot 1

0105

FFP

0.00

Wing Refueling Pod Kits for LRIP Lot 1

0106

FFP

0.00

Studies and Analyses for LRIP Lot 1

0107

FFP

Lot #2	12	Total			0.00	0.00
		Low-Rate Initial Production (Lot 2) w/Engines	0201	FFP
		Warranty of LRIP Lot 2	0202	FFP		0.00
		Data for LRIP Lot 2	0203	FFP/NSP
		Interim Contractor Support (ICS) Year 2	0204	FFP		0.00
		Spare Engines for LRIP Lot 2	0205	FFP		0.00
		Wing Refueling Pod Kits for LRIP Lot 2	0206	FFP		0.00
		Studies and Analyses for LRIP Lot 2	0207	FFP

Lot #3	15	Total			0.00	0.00
		Full-Rate Production (Lot 3) w/Engines	0301	NTE
		Warranty of FRP Lot 3	0302	NTE		0.00
		Data for FRP Lot 3	0303	NTE/NSP
		Interim Contractor Support (ICS) Year 3	0304	FFP		0.00
		Spare Engines for FRP Lot 3	0305	FFP		0.00
		Wing Refueling Pod Kits for FRP Lot 3	0306	FFP		0.00
		Studies and Analyses for FRP Lot 3	0307	FFP		0.00
		Over and Above Repairs for FRP Lot 3	0308	FFP LOE

Lot #4	15	Total			0.00	0.00
		Full-Rate Production (Lot 4) w/Engines	0401	NTE
		Warranty of FRP Lot 4	0402	NTE		0.00
		Data for FRP Lot 4	0403	NTE/NSP
		Interim Contractor Support (ICS) Year 4	0404	FFP		0.00
		Spare Engines for FRP Lot 4	0405	FFP		0.00
		Wing Refueling Pod Kits for FRP Lot 4	0406	FFP		0.00
		Studies and Analyses for FRP Lot 4	0407	FFP		0.00
		Over and Above Repairs for FRP Lot 4	0408	FFP LOE

Lot #5	15	Total			0.00	0.00
		Full-Rate Production (Lot 5) w/Engines	0501	NTE
		Warranty of FRP Lot 5	0502	NTE		0.00
		Data for FRP Lot 5	0503	NTE/NSP
		Interim Contractor Support (ICS) Year 5	0504	FFP		0.00
		Spare Engines for FRP Lot 5	0505	FFP		0.00
		Wing Refueling Pod Kits for FRP Lot 5	0506	FFP		0.00
		Studies and Analyses for FRP Lot 5	0507	FFP		0.00
		Over and Above Repairs for FRP Lot 5	0508	FFP LOE

Lot #6	15	Total			0.00	0.00
		Full-Rate Production (Lot 6) w/Engines	0601	NTE		0.00
		Warranty of FRP Lot 6	0602	NTE		0.00
		Data for FRP Lot 6	0603	NTE/NSP

Lot #7	15	Total			0.00	0.00
		Full-Rate Production (Lot 7) w/Engines	0701	NTE		0.00
		Warranty of FRP Lot 7	0702	NTE		0.00
		Data for FRP Lot 7	0703	NTE/NSP

Lot #8	15	Total			0.00	0.00
		Full-Rate Production (Lot 8) w/Engines	0801	NTE		0.00
		Warranty of FRP Lot 8	0802	NTE		0.00
		Data for FRP Lot 8	0803	NTE/NSP

Lot #9	15	Total			0.00	0.00
		Full-Rate Production (Lot 9) w/Engines	0901	NTE		0.00
		Warranty of FRP Lot 9	0902	NTE		0.00
		Data for FRP Lot 9	0903	NTE/NSP

Lot #10	15	Total			0.00	0.00
		Full-Rate Production (Lot 10) w/Engines	1001	NTE		0.00
		Warranty of FRP Lot 10	1002	NTE		0.00
		Data for FRP Lot 10	1003	NTE/NSP

Lot #11	15	Total			0.00	0.00
		Full-Rate Production (Lot 11) w/Engines	1101	NTE		0.00
		Warranty of FRP Lot 11	1102	NTE		0.00
		Data for FRP Lot 11	1103	NTE/NSP

Lot #12	15	Total			0.00	0.00
		Full-Rate Production (Lot 12) w/Engines	1201	NTE		0.00
		Warranty of FRP Lot 12	1202	NTE		0.00
		Data for FRP Lot 12	1203	NTE/NSP

Lot #13	6	Total															0.00	0.00
		Full-Rate Production (Lot 13) w/Engines	1301	NTE														0.00
		Warranty of FRP Lot 13	1302	NTE														0.00
		Data for FRP Lot 13	1303	NTE/NSP
TOTAL	175	Production Lots 1-13 Total (TY$)			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Present Value (PV) Discount Factor 0 0 0 0 0 0 0 0 0 0 0 0 0

TOTAL 175 Production Lots 1-13 Total (PV$) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

IFARA Analysis AUP IFARA Analysis Average Unit Price (AUP)

Offeror's Name: Offeror A

KC-X Program, Then Year (TY) to Present Value (PV) Calculation - units in dollars & cents

Production Lots

Lot #

Aircraft

CLIN Title

CLIN #

Contract

FFP Price (FY)

NTE Price (FY)

Total Price

Qty

Type

XXXX

Lot #1

Low-Rate Initial Production (Lot 1) w/Engines (TY$)

0101

FFP

0.00

Present Value Discount Factor

Low-Rate Initial Production (Lot 1) w/Engines (PV$)

0.00

Lot #2	12	Low-Rate Initial Production (Lot 2) w/Engines (TY$)	0201	FFP	0.00
		Present Value Discount Factor			0
		Low-Rate Initial Production (Lot 2) w/Engines (PV$)			0.00

Lot #3	15	Full-Rate Production (Lot 3) w/Engines (TY$)	0301	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 3) w/Engines (PV$)			0.00

Lot #4	15	Full-Rate Production (Lot 4) w/Engines (TY$)	0401	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 4) w/Engines (PV$)			0.00

Lot #5	15	Full-Rate Production (Lot 5) w/Engines (TY$)	0501	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 5) w/Engines (PV$)			0.00

Lot #6	15	Full-Rate Production (Lot 6) w/Engines (TY$)	0601	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 6) w/Engines (PV$)			0.00

Lot #7	15	Full-Rate Production (Lot 7) w/Engines (TY$)	0701	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 7) w/Engines (PV$)			0.00

Lot #8	15	Full-Rate Production (Lot 8) w/Engines (TY$)	0801	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 8) w/Engines (PV$)			0.00

Lot #9	15	Full-Rate Production (Lot 9) w/Engines (TY$)	0901	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 9) w/Engines (PV$)			0.00

Lot #10	15	Full-Rate Production (Lot 10) w/Engines (TY$)	1001	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 10) w/Engines (PV$)			0.00

Lot #11	15	Full-Rate Production (Lot 11) w/Engines (TY$)	1101	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 11) w/Engines (PV$)			0.00

Lot #12	15	Full-Rate Production (Lot 12) w/Engines (TY$)	1201	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 12) w/Engines (PV$)			0.00

Lot #13	6	Full-Rate Production (Lot 13) w/Engines (TY$)	1301	NTE	0.00
		Present Value Discount Factor			0
		Full-Rate Production (Lot 13) w/Engines (PV$)			0.00

TOTAL	175	Total (TY$)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
		Total (PV$)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

TOTAL AVERAGE UNIT PRICE (PV$), Lots 1-13 0.00

MILCON KC-X Beddown MILCON KC-X Beddown

Offeror's Name:
Offeror A
A/C DELIVERY SCHEDULE
	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	Total	Total	Delta
	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025	2026	2027	2028	2029	2030	Delivered	Required	Check
EMD A/C Deliveries				4															4	4	0
Lot 1 A/C Deliveries		6	1																7	7	0
Lot 2 A/C Deliveries			10	2															12	12	0
Lot 3 A/C Deliveries				13	2														15	15	0
Lot 4 A/C Deliveries					15														15	15	0
Lot 5 A/C Deliveries						15													15	15	0
Lot 6 A/C Deliveries							15												15	15	0
Lot 7 A/C Deliveries								15											15	15	0
Lot 8 A/C Deliveries									15										15	15	0
Lot 9 A/C Deliveries										15									15	15	0
Lot 10 A/C Deliveries											15								15	15	0
Lot 11 A/C Deliveries												15							15	15	0
Lot 12 A/C Deliveries													6						6	6	0
Lot 13 A/C Deliveries																			0	0	0
Total A/C Deliveries	0	6	11	19	17	15	15	15	15	15	15	15	6	0	0	0	0	0	164	164	0

A/C BEDDOWN SCHEDULE MILCON FY ALLOCATION

Aircraft Beddown Plan	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	FY	Total	Total	Delta	FY
	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025	2026	2027	2028	2029	2030	Based	Required	Check
Base 1 - Altus (2 A/C)		2																	2	2	0	2012
Base 2 - Grand Forks (12 A/C)		4	8																12	12	0	2012
Base 1 - Altus (1 A/C)			1																1	1	0
Base 3 - Fairchild (36 A/C)			2	19	15														36	36	0	2013
Base 1 - Altus (5 A/C)					2	3													5	5	0
Base 4 - MacDill (24 A/C)						12	12												24	24	0	2016
Base 5 - Seymour-Johnson (12 A/C)							3	9											12	12	0	2017
Base 6 - Scott (12 A/C)								6	6										12	12	0	2018
Base 7 - Kadena (12 A/C)									9	3									12	12	0	2019
Base 8 - Pease (12 A/C)										12									12	12	0	2020
Base 9 - March (12 A/C)											12								12	12	0	2021
Base 10 - Mildenhall (12 A/C)											3	9							12	12	0	2021
Base 11 - McConnell (12 A/C)												6	6						12	12	0	2022
Total	0	6	11	19	17	15	15	15	15	15	15	15	6	0	0	0	0	0	164	164	0
Delta Check	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Fuel Cost

Fuel Cost
Offerors Name:	Offeror A
Aircraft Fuel Consumption (Gal/Hr):

Fiscal Year	Delivery Schedule (Includes EMD a/c)	Cumulative a/c deliveries	Retired a/c after 40 Yrs	Cumulative a/c retirements	Cumulative a/c Inventory	Cost/Gal of JP8 (BY2011$)	2011 Weighted Fuel Indicies	Cost of JP8 (TY$)	# of flying hrs per a/c, per yr	Aircraft Fuel Consumption (Gal/Hr)	Total operational fleet fuel cost (TY$)	Discount Factor	Present Value
2011	0	0		0	0	$3.03	1.000	$ 3.03	489		$ - 0	0.9783	$0.00
2012	0	0		0	0	$3.03	1.030	$ 3.12	489		$ - 0	0.9362	$0.00
2013	0	0		0	0	$3.03	1.050	$ 3.18	489		$ - 0	0.8958	$0.00
2014	0	0		0	0	$3.03	1.070	$ 3.24	489		$ - 0	0.8573	$0.00
2015	0	0		0	0	$3.03	1.093	$ 3.31	489		$ - 0	0.8203	$0.00
2016	0	0		0	0	$3.03	1.117	$ 3.38	489		$ - 0	0.7850	$0.00
2017	0	0		0	0	$3.03	1.142	$ 3.46	489		$ - 0	0.7512	$0.00
2018	0	0		0	0	$3.03	1.167	$ 3.54	489		$ - 0	0.7189	$0.00
2019	0	0		0	0	$3.03	1.192	$ 3.61	489		$ - 0	0.6879	$0.00
2020	0	0		0	0	$3.03	1.219	$ 3.69	489		$ - 0	0.6583	$0.00
2021	0	0		0	0	$3.03	1.245	$ 3.77	489		$ - 0	0.6299	$0.00
2022	0	0		0	0	$3.03	1.273	$ 3.86	489		$ - 0	0.6028	$0.00
2023	0	0		0	0	$3.03	1.301	$ 3.94	489		$ - 0	0.5769	$0.00
2024	0	0		0	0	$3.03	1.330	$ 4.03	489		$ - 0	0.5520	$0.00
2025	0	0		0	0	$3.03	1.359	$ 4.12	489		$ - 0	0.5282	$0.00
2026	0	0		0	0	$3.03	1.389	$ 4.21	489		$ - 0	0.5055	$0.00
2027	0	0		0	0	$3.03	1.419	$ 4.30	489		$ - 0	0.4837	$0.00
2028	0	0		0	0	$3.03	1.450	$ 4.39	489		$ - 0	0.4629	$0.00
2029	0	0		0	0	$3.03	1.482	$ 4.49	489		$ - 0	0.4430	$0.00
2030	0	0		0	0	$3.03	1.515	$ 4.59	489		$ - 0	0.4239	$0.00
2031	0	0		0	0	$3.03	1.548	$ 4.69	489		$ - 0	0.4056	$0.00
2032	0	0		0	0	$3.03	1.582	$ 4.79	489		$ - 0	0.3882	$0.00
2033	0	0		0	0	$3.03	1.617	$ 4.90	489		$ - 0	0.3715	$0.00
2034	0	0		0	0	$3.03	1.653	$ 5.01	489		$ - 0	0.3555	$0.00
2035	0	0		0	0	$3.03	1.689	$ 5.12	489		$ - 0	0.3402	$0.00
2036	0	0		0	0	$3.03	1.726	$ 5.23	489		$ - 0	0.3255	$0.00
2037	0	0		0	0	$3.03	1.764	$ 5.35	489		$ - 0	0.3115	$0.00
2038	0	0		0	0	$3.03	1.803	$ 5.46	489		$ - 0	0.2981	$0.00
2039	0	0		0	0	$3.03	1.843	$ 5.58	489		$ - 0	0.2852	$0.00
2040	0	0		0	0	$3.03	1.883	$ 5.71	489		$ - 0	0.2730	$0.00
2041	0	0		0	0	$3.03	1.925	$ 5.83	489		$ - 0	0.2612	$0.00
2042	0	0		0	0	$3.03	1.967	$ 5.96	489		$ - 0	0.2500	$0.00
2043	0	0		0	0	$3.03	2.010	$ 6.09	489		$ - 0	0.2392	$0.00
2044	0	0		0	0	$3.03	2.055	$ 6.23	489		$ - 0	0.2289	$0.00
2045	0	0		0	0	$3.03	2.100	$ 6.36	489		$ - 0	0.2190	$0.00
2046	0	0		0	0	$3.03	2.146	$ 6.50	489		$ - 0	0.2096	$0.00
2047	0	0		0	0	$3.03	2.193	$ 6.65	489		$ - 0	0.2006	$0.00
2048	0	0		0	0	$3.03	2.241	$ 6.79	489		$ - 0	0.1919	$0.00
2049	0	0		0	0	$3.03	2.291	$ 6.94	489		$ - 0	0.1837	$0.00
2050	0	0		0	0	$3.03	2.341	$ 7.09	489		$ - 0	0.1758	$0.00
2051	0	0	0	0	0	$3.03	2.393	$ 7.25	489		$ - 0	0.1682	$0.00
2052	0	0	0	0	0	$3.03	2.445	$ 7.41	489		$ - 0	0.1610	$0.00
2053	0	0	0	0	0	$3.03	2.499	$ 7.57	489		$ - 0	0.1540	$0.00
2054	0	0	0	0	0	$3.03	2.554	$ 7.74	489		$ - 0	0.1474	$0.00
2055	0	0	0	0	0	$3.03	2.610	$ 7.91	489		$ - 0	0.1410	$0.00
2056	0	0	0	0	0	$3.03	2.668	$ 8.08	489		$ - 0	0.1350	$0.00
2057	0	0	0	0	0	$3.03	2.726	$ 8.26	489		$ - 0	0.1292	$0.00
2058	0	0	0	0	0	$3.03	2.786	$ 8.44	489		$ - 0	0.1236	$0.00
2059	0	0	0	0	0	$3.03	2.848	$ 8.63	489		$ - 0	0.1183	$0.00
2060	0	0	0	0	0	$3.03	2.910	$ 8.82	489		$ - 0	0.1132	$0.00
2061	0	0	0	0	0	$3.03	2.974	$ 9.01	489		$ - 0	0.1083	$0.00
2062	0	0	0	0	0	$3.03	3.040	$ 9.21	489		$ - 0	0.1036	$0.00
2063	0	0	0	0	0	$3.03	3.107	$ 9.41	489		$ - 0	0.0992	$0.00
2064	0	0	0	0	0	$3.03	3.175	$ 9.62	489		$ - 0	0.0949	$0.00
2065	0	0	0	0	0	$3.03	3.245	$ 9.83	489		$ - 0	0.0908	$0.00
2066	0	0	0	0	0	$3.03	3.316	$ 10.05	489		$ - 0	0.0869	$0.00
2067	0	0	0	0	0	$3.03	3.389	$ 10.27	489		$ - 0	0.0832	$0.00
2068	0	0	0	0	0	$3.03	3.464	$ 10.49	489		$ - 0	0.0796	$0.00
2069	0	0	0	0	0	$3.03	3.540	$ 10.73	489		$ - 0	0.0762	$0.00
2070	0	0	0	0	0	$3.03	3.618	$ 10.96	489		$ - 0	0.0729	$0.00
2071	0	0	0	0	0	$3.03	3.697	$ 11.20	489		$ - 0	0.0697	$0.00
Totals											$ - 0		$0.00

Total Proposed Price

Offerors Name: Offeror A

	TPP (TY$)	TPP (PV$)
EMD	$ - 0	$ - 0
Prod Lots 1-13	$ - 0	$ - 0
Total	$ - 0	$ - 0

PV Discount Factors

PRESENT VALUE CALCULATOR

MID YEAR DISCOUNT FORMULA

DF = 1/(1+I)^t X 1.0223

DF = Discount Factor

I = Discount Rate

t = Number of Years

Data
Year Program Initiated	2011
Discount Rate	4.50%
Mid Year Conversion Factor	1.0223

Year Number	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49
Fiscal Year	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025	2026	2027	2028	2029	2030	2031	2032	2033	2034	2035	2036	2037	2038	2039	2040	2041	2042	2043	2044	2045	2046	2047	2048	2049	2050	2051	2052	2053	2054	2055	2056	2057	2058	2059
Discount Factor	0.9783	0.9362	0.8958	0.8573	0.8203	0.7850	0.7512	0.7189	0.6879	0.6583	0.6299	0.6028	0.5769	0.5520	0.5282	0.5055	0.4837	0.4629	0.4430	0.4239	0.4056	0.3882	0.3715	0.3555	0.3402	0.3255	0.3115	0.2981	0.2852	0.2730	0.2612	0.2500	0.2392	0.2289	0.2190	0.2096	0.2006	0.1919	0.1837	0.1758	0.1682	0.1610	0.1540	0.1474	0.1410	0.1350	0.1292	0.1236	0.1183

This is the start of the file's text. The full file is on GovTribe.

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