Sect L Atch 3 - Cost Price Evaluation Workbook 25 Sep 09.xlsx

XLSX spreadsheet 78 KB Posted Sep 25, 2009

Attached to: KC-X Tanker Modernization Program
Solicitation number: FA8625-10-R-6600-SpecialNotice
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Wright Patterson Air Force Base

About this file

From the source

Section L Attachment 3 - Cost/Price Evaluation Workbook

View the file

Other files

File	Type	Posted
KC-X Draft RFP Questions and Answers 23 Feb 2010.pdf	PDF	Feb 23, 2010
KC-X Draft RFP Questions and Answers 11 February 2010.pdf	PDF	Feb 11, 2010
KC-X Draft RFP Questions and Answers 27 Jan 2010.pdf	PDF	Jan 27, 2010
KC-X Draft RFP Solicitation Number Revision.pdf	PDF	Jan 7, 2010
KC-X Draft RFP Document Reference Library Addendum3 3 Dec 09.pdf	PDF	Dec 3, 2009
KC-X Draft RFP Questions and Answers 25 Nov 2009.pdf	PDF	Nov 25, 2009
KC-X Draft RFP Questions and Answers 24 Nov 2009.pdf	PDF	Nov 24, 2009
KC-X Draft RFP Document Reference Library Addendum2 23-Nov-09.pdf	PDF	Nov 23, 2009
KC-X Draft RFP Document Reference Library Addendum1 18 Nov 09.pdf	PDF	Nov 18, 2009
KC-X Draft RFP Questions and Answers 18 Nov 2009.pdf	PDF	Nov 18, 2009
KC-X Draft RFP Questions Answers 13-Nov-09.pdf	PDF	Nov 13, 2009
KC-X Draft RFP Questions and Answers 10 Nov 2009.pdf	PDF	Nov 10, 2009
KC-X Draft Questions and Answers 30 Oct 2009.pdf	PDF	Oct 30, 2009
KC-X Draft Questions and Answers 23 Oct 2009.pdf	PDF	Oct 23, 2009
KC-X Draft Questions and Answers 19 Oct 2009.pdf	PDF	Oct 19, 2009
KC-X Draft RFP Document Reference Library 01 Oct 09.xlsx	XLSX spreadsheet	Oct 1, 2009
L047 836 AESG L-III Information to Offerors	—	Sep 25, 2009
Sect J Exhibit E FAA CDRLs 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Exhibit B EMD OMIT CDRLs 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 4 - DD254 25 Sep 09.pdf	PDF	Sep 25, 2009
Sect J Atch 6 - IMP 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 24 - Definitions 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 2 - EMD SOO 25 Sep 09.pdf	PDF	Sep 25, 2009
Sect L Atch 13 - Example Format for Past Performance Consent Letter 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Exhibit D Prod OMIT CDRLs 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 1 - SRD 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 11-22 CSDR 25 Sept.pdf	PDF	Sep 25, 2009
Sect J Atch 3 - Production SOO 25 Sep 09.pdf	PDF	Sep 25, 2009
Sect L Atch 10 - Past Performance Questionnaire 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 8 - EMD Prod TMCR 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 16 - CEO Certification Letter Template 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 9 - Option Matrix 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 12 - Past Performance Client Authorization Letter 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Exhibit C Prod NON- OMIT CDRLs 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 2 - Weapon System Integrity Matrix 25 Sep 09.xlsx	XLSX spreadsheet	Sep 25, 2009
Sect L Atch 9 - Past Performance Fact Sheets 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 1 - Correlation Matrix 25 Sep 09.pdf	PDF	Sep 25, 2009
M001 836 AESG Solicitation Provisions in Full Text	—	Sep 25, 2009
FA8625-10-R-6600 25 Sep 09.pdf	PDF	Sep 25, 2009
Sect L Atch 15 - Acronym List 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 5 - AFMC Form 158 25 Sep 09.pdf	PDF	Sep 25, 2009
Sect J Atch 10 - Live Fire Assets 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 11 - Past Performance Questionnaire Transmittal Letter 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 7 - IFARA Data Input Package 25 Sep 09.xlsx	XLSX spreadsheet	Sep 25, 2009
Sect J Exhibit A EMD NON-OMIT CDRLs 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect J Atch 7 - VIQ Option Matrix 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 4 - Requirements Prioritization 25 Sept 09.pdf	PDF	Sep 25, 2009
Sect L Atch 14 - Past Performance Questionnaire Tracking Record 25 Sept 09.pdf	PDF	Sep 25, 2009

Show all 48

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.

EMD Acquisition Price

EMD Acquisition Price
Offeror's Name:	Offeror Y

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 (Total Price less FCCOM multiplied by 12 %	Target Cost (Total Price less Profit)	Overrun to Ceiling Price (FY) (Ceiling Price less Total Price)	Ceiling Price
		Type	2010	2011	2012	2013	2014	2015	2016	2017	2018					XXXX	(Ceiling Price for FPIF CLINs is 125% of Target Cost; Ceiling for FFP CLINs is Total Price)
Engineering, Manufacturing and Development (4 A/C)	0001	FPIF										0.00		0.00	0.00	0.00	0.00
Data (Non-Omit) for Engineering, Manufacturing and Development	0002	FPIF/NSP
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, Manufacturing and 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-5 Acq Price Production Lots 1-5 Acquisition Price

Offeror's Name: Offeror Y

KC-X Program (TY$ - units in dollars & cents)
Contract Phase: Production Lots 1-5
Lot #	Aircraft	CLIN Title	CLIN #	Contract	FFP Price (FY)	FFP Price (FY)	FFP Price (FY)	FFP Price (FY)	FFP Price (FY)	FFP Price
	Qty			Type	xxxx					Total
Lot #1	7	Total			0.00					0.00
		Low-Rate Initial Production (Lot 1) w/Engines	0101	FFP						0.00
		Warranty of LRIP Lot 1 Aircraft	0102	FFP						0.00
		Data for LRIP Lot 1	0103	FFP/NSP
		Interim Contractor Support (ICS) for LRIP Lot 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						0.00

Lot #2	12	Total			0.00	0.00
		Low-Rate Initial Production (Lot 2) w/Engines	0201	FFP		0.00
		Warranty of LRIP Lot 2 Aircraft	0202	FFP
		Data for LRIP Lot 2	0203	FFP/NSP
		Interim Contractor Support (ICS) for LRIP Lot 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		0.00

Lot #3	15	Total			0.00	0.00
		Full-Rate Production (Lot 3) w/Engines	0301	FFP		0.00
		Warranty of FRP Lot 3 Aircraft	0302	FFP		0.00
		Data for FRP Lot 3	0303	FFP/NSP
		Interim Contractor Support (ICS) for FRP Lot 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		0.00

Lot #4	15	Total			0.00	0.00
		Full-Rate Production (Lot 4) w/Engines	0401	FFP		0.00
		Warranty of FRP Lot 4 Aircraft	0402	FFP		0.00
		Data for FRP Lot 4	0403	FFP/NSP
		Interim Contractor Support (ICS) for FRP Lot 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		0.00

Lot #5	15	Total							0.00	0.00
		Full-Rate Production (Lot 5) w/Engines	0501	FFP						0.00
		Warranty of FRP Lot 5 Aircraft	0502	FFP						0.00
		Data for FRP Lot 5	0503	FFP/NSP
		Interim Contractor Support for FRP Lot 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						0.00
		FAA Type Certification Data	0509	FFP						0.00
TOTAL	64	Production Lots 1-5 Total (TY$)			0.00	0.00	0.00	0.00	0.00	0.00

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

TOTAL 64 Production Lots 1-5 Total (PV$) 0.00 0.00 0.00 0.00 0.00 0.00

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

Offeror's Name: Offeror Y

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

Contract Phase: Production Lots 6-13

Lot #

Aircraft

CLIN Title

CLIN #

Contract

NTE Price (FY)

NTE Price

Qty

Type

Total

Lot #6

Total

0.00

Full-Rate Production (Lot 6) w/Engines

0601

NTE

Warranty of FRP Lot 6 Aircraft

0602

NTE

Data for FRP Lot 6

0603

NTE/NSP

0.00

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

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

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

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

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

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

Lot #13	6	Total										0.00	0.00
		Full-Rate Production (Lot 13) w/Engines	1301	NTE
		Warranty of FRP Lot 13 Aircraft	1302	NTE
		Data for FRP Lot 13	1303	NTE/NSP									0.00
TOTAL	111	Production Lots 6-13 Total (TY$)			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

TOTAL 111 Production Lots 6-13 Total (PV$) 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 Y

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 FFP/NTE Price

Qty

Type

xxxx

Lot #1

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

0101

FFP

0.00

Present Value Discount Factor

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

0.00

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

Lot #3	15	Full-Rate Production (Lot 3) w/Engines (TY$)	0301	FFP	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	FFP	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	FFP	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	Full-Rate Production w/Engines (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
		Full-Rate Production w/Engines (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 Y

A/C DELIVERY SCHEDULE
	FY	FY	FY	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	2031	2032	2033	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	0	0	0	164	164	0

A/C BEDDOWN SCHEDULE MILCON FY ALLOCATION

AMC Beddown Plan	FY	FY	FY	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	2031	2032	2033	Based	Required	Check
Base 1 (2 A/C)		2																				2	2	0	2012
Base 2 (12 A/C)		4	8																			12	12	0	2012
Base 1 (1 A/C)			1																			1	1	0
Base 3 (36 A/C)			2	19	15																	36	36	0	2013
Base 1 (5 A/C)					2	3																5	5	0
Base 4 (24 A/C)						12	12															24	24	0	2016
Base 5 (12 A/C)							3	9														12	12	0	2017
Base 6 (12 A/C)								6	6													12	12	0	2018
Base 7 (12 A/C)									9	3												12	12	0	2019
Base 8 (12 A/C)										12												12	12	0	2020
Base 9 (12 A/C)											12											12	12	0	2021
Base 10 (12 A/C)											3	9										12	12	0	2021
Base 11 (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	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	0	0	0

Fuel Cost

Fuel Cost
Offerors Name:	Offeror Y
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 (BY2010$)	2010 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
2010	0	0		0	0	$2.54	1.000	$ 2.54	489		$ - 0	0.9783	$0.00
2011	0	0		0	0	$2.54	1.113	$ 2.83	489		$ - 0	0.9362	$0.00
2012	0	0		0	0	$2.54	1.160	$ 2.95	489		$ - 0	0.8958	$0.00
2013	0	0		0	0	$2.54	1.192	$ 3.03	489		$ - 0	0.8573	$0.00
2014	0	0		0	0	$2.54	1.221	$ 3.10	489		$ - 0	0.8203	$0.00
2015	0	0		0	0	$2.54	1.249	$ 3.17	489		$ - 0	0.7850	$0.00
2016	0	0		0	0	$2.54	1.278	$ 3.25	489		$ - 0	0.7512	$0.00
2017	0	0		0	0	$2.54	1.307	$ 3.32	489		$ - 0	0.7189	$0.00
2018	0	0		0	0	$2.54	1.337	$ 3.40	489		$ - 0	0.6879	$0.00
2019	0	0		0	0	$2.54	1.368	$ 3.47	489		$ - 0	0.6583	$0.00
2020	0	0		0	0	$2.54	1.399	$ 3.55	489		$ - 0	0.6299	$0.00
2021	0	0		0	0	$2.54	1.431	$ 3.63	489		$ - 0	0.6028	$0.00
2022	0	0		0	0	$2.54	1.464	$ 3.72	489		$ - 0	0.5769	$0.00
2023	0	0		0	0	$2.54	1.498	$ 3.80	489		$ - 0	0.5520	$0.00
2024	0	0		0	0	$2.54	1.533	$ 3.89	489		$ - 0	0.5282	$0.00
2025	0	0		0	0	$2.54	1.568	$ 3.98	489		$ - 0	0.5055	$0.00
2026	0	0		0	0	$2.54	1.604	$ 4.07	489		$ - 0	0.4837	$0.00
2027	0	0		0	0	$2.54	1.641	$ 4.17	489		$ - 0	0.4629	$0.00
2028	0	0		0	0	$2.54	1.678	$ 4.26	489		$ - 0	0.4430	$0.00
2029	0	0		0	0	$2.54	1.717	$ 4.36	489		$ - 0	0.4239	$0.00
2030	0	0		0	0	$2.54	1.757	$ 4.46	489		$ - 0	0.4056	$0.00
2031	0	0		0	0	$2.54	1.797	$ 4.56	489		$ - 0	0.3882	$0.00
2032	0	0		0	0	$2.54	1.838	$ 4.67	489		$ - 0	0.3715	$0.00
2033	0	0		0	0	$2.54	1.881	$ 4.78	489		$ - 0	0.3555	$0.00
2034	0	0		0	0	$2.54	1.924	$ 4.89	489		$ - 0	0.3402	$0.00
2035	0	0		0	0	$2.54	1.968	$ 5.00	489		$ - 0	0.3255	$0.00
2036	0	0		0	0	$2.54	2.013	$ 5.11	489		$ - 0	0.3115	$0.00
2037	0	0		0	0	$2.54	2.060	$ 5.23	489		$ - 0	0.2981	$0.00
2038	0	0		0	0	$2.54	2.107	$ 5.35	489		$ - 0	0.2852	$0.00
2039	0	0		0	0	$2.54	2.155	$ 5.47	489		$ - 0	0.2730	$0.00
2040	0	0		0	0	$2.54	2.205	$ 5.60	489		$ - 0	0.2612	$0.00
2041	0	0		0	0	$2.54	2.256	$ 5.73	489		$ - 0	0.2500	$0.00
2042	0	0		0	0	$2.54	2.308	$ 5.86	489		$ - 0	0.2392	$0.00
2043	0	0		0	0	$2.54	2.361	$ 6.00	489		$ - 0	0.2289	$0.00
2044	0	0		0	0	$2.54	2.415	$ 6.13	489		$ - 0	0.2190	$0.00
2045	0	0		0	0	$2.54	2.471	$ 6.28	489		$ - 0	0.2096	$0.00
2046	0	0		0	0	$2.54	2.527	$ 6.42	489		$ - 0	0.2006	$0.00
2047	0	0		0	0	$2.54	2.586	$ 6.57	489		$ - 0	0.1919	$0.00
2048	0	0		0	0	$2.54	2.645	$ 6.72	489		$ - 0	0.1837	$0.00
2049	0	0		0	0	$2.54	2.706	$ 6.87	489		$ - 0	0.1758	$0.00
2050	0	0	0	0	0	$2.54	2.768	$ 7.03	489		$ - 0	0.1682	$0.00
2051	0	0	0	0	0	$2.54	2.832	$ 7.19	489		$ - 0	0.1610	$0.00
2052	0	0	0	0	0	$2.54	2.897	$ 7.36	489		$ - 0	0.1540	$0.00
2053	0	0	0	0	0	$2.54	2.964	$ 7.53	489		$ - 0	0.1474	$0.00
2054	0	0	0	0	0	$2.54	3.032	$ 7.70	489		$ - 0	0.1410	$0.00
2055	0	0	0	0	0	$2.54	3.101	$ 7.88	489		$ - 0	0.1350	$0.00
2056	0	0	0	0	0	$2.54	3.173	$ 8.06	489		$ - 0	0.1292	$0.00
2057	0	0	0	0	0	$2.54	3.246	$ 8.24	489		$ - 0	0.1236	$0.00
2058	0	0	0	0	0	$2.54	3.320	$ 8.43	489		$ - 0	0.1183	$0.00
2059	0	0	0	0	0	$2.54	3.397	$ 8.63	489		$ - 0	0.1132	$0.00
2060	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.1083	$0.00
2061	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.1036	$0.00
2062	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0992	$0.00
2063	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0949	$0.00
2064	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0908	$0.00
2065	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0869	$0.00
2066	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0832	$0.00
2067	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0796	$0.00
2068	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0762	$0.00
2069	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0729	$0.00
2070	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0697	$0.00
2071	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0667	$0.00
2072	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0639	$0.00
2073	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0611	$0.00
2074	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0585	$0.00
2075	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0560	$0.00
2076	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0536	$0.00
2077	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0512	$0.00
2078	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0490	$0.00
2079	0	0	0	0	0	$2.54	3.475	$ 8.83	489		$ - 0	0.0469	$0.00
Totals											$ - 0		$0.00

Total Proposed Price

Offerors Name: Offeror Y

	TPP (TY$)	TPP (PV$)
EMD	$ - 0	$ - 0
Prod Lots 1-5	$ - 0	$ - 0
Prod Lots 6-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	2010
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	2010	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
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.