PriceModel.xlsx

XLSX spreadsheet 45 KB Posted Feb 22, 2019

Attached to: Next Generation All Aluminum Pallets Federal contract opportunity
Solicitation number: FA8534-19-R-0001
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains a price model and template examples related to a solicitation for next generation all-aluminum pallets. The solicitation seeks the manufacturing and production of item 463L Air Cargo Pallets over an 18-month basic period and seven one-year option periods, with quantities ranging from 5 first article units in the basic period to a maximum of 15,000 production units per option period. The price model provides unit pricing templates for the basic and option periods based on pallet quantity ranges and includes fields for aluminum content and prices subject and not subject to adjustment. It also includes examples demonstrating the evaluation and adjustment of proposed prices. The Department of the Air Force Materiel Command Lifecycle Management Center at Robins Air Force Base is the contracting agency. Award will be made using tradeoff procedures to the offeror providing the best value based on technical acceptability, past performance, cost/price, and small business utilization.

From the source

Price Model Excel Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to Next Generation All Aluminum Pallets, newest first.
File	Type	Posted
RFP_Release_-_Questions_from_Industry_6Nov19.docx	DOCX document	Nov 6, 2019
FA853419R0001_______0004.pdf	PDF	Oct 30, 2019
MIL-DTL-27443G.pdf	PDF	Oct 30, 2019
Additional_Questions_from_Industry_2Oct19.docx	DOCX document	Oct 3, 2019
CargoPalletAssembly201993426.STEP	STEP file	Oct 1, 2019
CenterPanelExtrusion201993428.STEP	STEP file	Oct 1, 2019
FA853419R0001_______0002.pdf	PDF	Oct 1, 2019
Price_Model_Revised.xlsx	XLSX spreadsheet	Oct 1, 2019
TieDownRingAssembly201993431.STEP	STEP file	Oct 1, 2019
IntermediatePanelExtrusion201993427.STEP	STEP file	Oct 1, 2019
RFP_release_-_Questions_from_Industry.docx	DOCX document	Sep 23, 2019
FA853419R0001_______0001.pdf	PDF	Sep 11, 2019
ppi_tool.accdb	MDB file	Sep 4, 2019
Eng_Data_List.pdf	PDF	Aug 23, 2019
Next_Gen_Cargo_Pallet_Replacement_MIL_DTL_27443G.pdf	PDF	Aug 23, 2019
Side_Panel_Extrusion_(X201993429).STEP	STEP file	Aug 23, 2019
Cargo_Pallet_Assembly_(X201993426).STEP	STEP file	Aug 23, 2019
Center_Panel_Extrusion_(X201993428).STEP	STEP file	Aug 23, 2019
Intermediate_Panel_Extrusion_(X201993427).STEP	STEP file	Aug 23, 2019
Edge_Rail_Extrusion_(X201993430).STEP	STEP file	Aug 23, 2019
CDRLS_A001_-_A010.pdf	PDF	Aug 19, 2019
SOW_Next_Gen.pdf	PDF	Aug 19, 2019
Drawing_Package.pdf	PDF	Aug 19, 2019
Section_L_Final.pdf	PDF	Aug 19, 2019
Price_Model,_final.xlsx	XLSX spreadsheet	Aug 19, 2019
FA853419R0001.pdf	PDF	Aug 19, 2019
ppi_tool.accdb	MDB file	Aug 19, 2019
Section_M_Final.pdf	PDF	Aug 19, 2019
Q&As_4.pdf	PDF	May 16, 2019
Tie-Down_Ring_Assembly_(X201993431).STEP	STEP file	May 16, 2019
Edge_Rail_Extrusion_(X201993430).STEP	STEP file	May 16, 2019
Cargo_Pallet_Assembly_(X201993426).STEP	STEP file	May 16, 2019
Intermediate_Panel_Extrusion_(X201993427).STEP	STEP file	May 16, 2019
Pre-Solicitation_Conference_Questions_Final.pdf	PDF	Apr 24, 2019
Revised_Drawings.pdf	PDF	Apr 24, 2019
Agenda.docx	DOCX document	Mar 26, 2019
Information_Sign_in_Sheet.pdf	PDF	Mar 22, 2019
REVISED_Price_Model.xlsx	XLSX spreadsheet	Mar 19, 2019
REVISED_SOW_NextGenPallet.pdf	PDF	Mar 19, 2019
Revised_Section_L_Aluminum_Pallet.doc	DOC document	Mar 19, 2019
QA_Mar_19_final.docx	DOCX document	Mar 8, 2019
Draft_-_Next_Gen_Cargo_Pallet_Replacement_MIL_DTL_27443.docx	DOCX document	Mar 8, 2019
SectionLAluminum.doc	DOC document	Feb 22, 2019
FA853419R0001.pdf	PDF	Feb 22, 2019
SOWNextGenPallet2018.pdf	PDF	Feb 22, 2019
CargoPalletsCDRLS.pdf	PDF	Feb 22, 2019
CWBSMatrix.docx	DOCX document	Feb 22, 2019
DraftForm1653.doc	DOC document	Feb 22, 2019
PackagingFORM158.pdf	PDF	Feb 22, 2019
Drawings.pdf	PDF	Feb 22, 2019

Show all 50

Next Generation All Aluminum Pallets 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.

Price Model, 01-08-19

Company Name:	Attachment ??	NOTES:
Address:		1. Price Subject to Adjustment (Aluminum $ contained within unit price)
POC:		2. Price Not Subject to Adjustment (All other $, excluding aluminum, contained within unit price)
Phone Number:
CAGE Code:
Request for Proposal No. FA8534-18-R-0004
Next Generation Pallet

BASIC PERIOD (18 months)

CLIN Description CLIN Type Quantity Unit/Issue Unit Price Evaluated Price

0001	First Article	FFP	5	EA	$ - 0
0002	F/A Non Recurring Costs	FFP	1	EA	$ - 0

Total for Basic Period $ - 0

Option I (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

1001	Next Generation Cargo Pallet	FPE	15,000
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	15,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
						15,000
									Total for Option I	$ - 0

Option II (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

2001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	20,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			20,001	30,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			30001	37,700	EA	7,700	284.50	$ - 0	$ - 0	$ - 0
						37,700
									Total for Option II	$ - 0

Option III (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

3001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	20,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			20,001	30,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			30001	37,700	EA	7,700	284.50	$ - 0	$ - 0	$ - 0
						37,700
									Total for Option III	$ - 0

Option IV (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

4001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	20,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			20,001	30,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			30001	37,700	EA	7,700	284.50	$ - 0	$ - 0	$ - 0
						37,700
									Total for Option IV	$ - 0
Option V (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

5001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	20,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			20,001	30,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			30001	37,700	EA	7,700	284.50	$ - 0	$ - 0	$ - 0
						37,700
									Total for Option V	$ - 0

Option VI (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

6001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	20,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			20,001	30,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			30001	37,700	EA	7,700	284.50	$ - 0	$ - 0	$ - 0
						37,700
									Total for Option VI	$ - 0

Option VII (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

7001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	20,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			20,001	30,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			30001	37,700	EA	7,700	284.50	$ - 0	$ - 0	$ - 0
						37,700
									Total for Option VII	$ - 0

Option VIII (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

8001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	20,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			20,001	30,000	EA	10,000	284.50	$ - 0	$ - 0	$ - 0
			30001	37,700	EA	7,700	284.50	$ - 0	$ - 0	$ - 0
						37,700
									Total for Option VIII	$ - 0

Option IX (06 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

9001	Next Generation Cargo Pallet	FPE	15,000
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ - 0	$ - 0	$ - 0
			2,001	5,000	EA	3,000	284.50	$ - 0	$ - 0	$ - 0
			5,001	10,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
			10,001	15,000	EA	5,000	284.50	$ - 0	$ - 0	$ - 0
						15,000
									Total for Option IX	$ - 0
									Total Evaluated Price	$ - 0

TEP example, 01-08-19 BASIC PERIOD (18 months)

CLIN Description CLIN Type Quantity Unit/Issue Unit Price Evaluated Price

0001	First Article	FFP	5	EA	$ 2,000.00	$ 10,000.00
0002	F/A Non Recurring Costs	FFP	1	EA	$ 1,000.00	$ 1,000.00

Total for Basic Period $ 11,000.00

Option I (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

1001	Next Generation Cargo Pallet	FPE	15,000
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ 20.00	$ 5,690.00	$ 1,800.00	$ 7,490.00	$ 14,980,000.00
			2,001	5,000	EA	3,000	284.50	$ 20.00	$ 5,690.00	$ 1,800.00	$ 7,490.00	$ 22,470,000.00
			5,001	10,000	EA	5,000	284.50	$ 20.00	$ 5,690.00	$ 1,800.00	$ 7,490.00	$ 37,450,000.00
			10,001	15,000	EA	5,000	284.50	$ 20.00	$ 5,690.00	$ 1,800.00	$ 7,490.00	$ 37,450,000.00
						15,000
											Total for Option I	$ 112,350,000.00

Option II (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

2001	Next Generation Cargo Pallet	FPE	37,700
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ 21.00	$ 5,974.50	$ 1,900.00	$ 7,875.00	$ 15,750,000.00
			2,001	5,000	EA	3,000	284.50	$ 21.00	$ 5,974.50	$ 1,900.00	$ 7,875.00	$ 23,625,000.00
			5,001	10,000	EA	5,000	284.50	$ 21.00	$ 5,974.50	$ 1,900.00	$ 7,875.00	$ 39,375,000.00
			10,001	20,000	EA	10,000	284.50	$ 21.00	$ 5,974.50	$ 1,900.00	$ 7,875.00	$ 78,750,000.00
			20,001	30,000	EA	10,000	284.50	$ 21.00	$ 5,974.50	$ 1,900.00	$ 7,875.00	$ 78,750,000.00
			30001	37,700	EA	7,700	284.50	$ 21.00	$ 5,974.50	$ 1,900.00	$ 7,875.00	$ 60,637,500.00
						37,700
											Total for Option II	$ 296,887,500.00

Option III (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

3001 Next Generation Cargo Pallet FPE Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc.

Total for Option III Etc.

Option IV (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

4001 Next Generation Cargo Pallet FPE Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc.

	Total for Option IV	Etc.
Option V (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

5001 Next Generation Cargo Pallet FPE Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc.

Total for Option V Etc.

Option VI (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

6001 Next Generation Cargo Pallet FPE Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc.

Total for Option VI Etc.

Option VII (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

7001 Next Generation Cargo Pallet FPE Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc.

Total for Option VII Etc.

Option VIII (12 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

8001 Next Generation Cargo Pallet FPE Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc. Etc.

Total for Option VIII Etc.

Option IX (06 months)

CLIN Description CLIN Type BEQ Unit/Issue Evaluated Qty Aluminum (Lbs) $/Lb. (Aluminum) PSA (See Note 1) PNSA (See Note 2) Unit Price Evaluated Price

9001	Next Generation Cargo Pallet	FPE	15,000
			Range
			From	To
			1	2,000	EA	2,000	284.50	$ 22.00	$ 6,259.00	$ 2,000.00	$ 8,259.00	$ 16,518,000.00
			2,001	5,000	EA	3,000	284.50	$ 22.00	$ 6,259.00	$ 2,000.00	$ 8,259.00	$ 24,777,000.00
			5,001	10,000	EA	5,000	284.50	$ 22.00	$ 6,259.00	$ 2,000.00	$ 8,259.00	$ 41,295,000.00
			10,001	15,000	EA	5,000	284.50	$ 22.00	$ 6,259.00	$ 2,000.00	$ 8,259.00	$ 41,295,000.00
						15,000
											Total for Option IX	$ 123,885,000.00
											Total Evaluated Price	$ 533,133,500.00

EPA example, 01-08-19

Example of EPA Increase
Step 1: PCO identifies baseline costs in the basic contract.
Contract Schedule
	U/I	Price Subject to Adjustment (PSA) (Note 1)			Price Not Subject to Adjustment (PNSA) (Note 2)	Total Unit Price
Structural Product Material (Identified Below)		QTY (Pounds)	Price	Total
Aluminum	Pounds	1000	$ 10.00	$ 10,000.00
Unit Price	EA			$ 10,000.00	$ 20,000.00	$ 30,000.00

Step 2: PCO reviews new costs in contractor's submitted proposal adjustment (PA).
PA submitted by Contractor
	U/I	Contractor's Proposed Adjustment to PSA (Note 1)			Price Not Subject to Adjustment (Note 2)	Adjusted Unit Price
Structural Product Material (Identified Below)		QTY (Pounds)	Price	Total
Aluminum	Pounds	1000	$ 11.00	$ 11,000.00
Unit Price	EA			$ 11,000.00	$ 20,000.00	$ 31,000.00

NOTE 1: Per FAR 16.203-4 (c)(4)(ii), when adjustments are made, they shall not include

indirect cost or profit.

NOTE 2: Includes all remaining unit costs and profit not proposed under the PSA.

Step 3: PCO determines if any adjustments are applicable.
Adjustment calculation 1
A =	$ 11,000.00
U =	$ 10,000.00
Δ =	($11,000 - $10,000)/$10,000 OR:
	10.00%

10.00% is ≥ 5.00%; therefore, PA is considered.

Adjustment calculation 2
Proposed Adjusted Total Unit Price		$ 31,000.00
	divided by
Initial Proposed Total Unit Price		$ 30,000.00
	=	103.33%

The proposed adjusted total unit price is no more than 10.00% higher than the initial proposed total

unit price. An EPA is applicable.

Step 4: Contractor's submitted PA meets the requirements for a price increase. A modification to the delivery order is issued for the adjusted unit price of $31,000 shown in Step 2.

Example of EPA Increase capped at 10%
Step 1: PCO identifies baseline costs in the basic contract.
Contract Schedule
	U/I	Price Subject to Adjustment (Note 1)			Price Not Subject to Adjustment (Note 2)	Total Unit Price
Structural Product Material (Identified Below)		QTY (Pounds)	Price	Total
Aluminum	Pounds	1000	$ 10.00	$ 10,000.00
Unit Price	EA			$ 10,000.00	$ 20,000.00	$ 30,000.00

Step 2: PCO reviews new costs in contractor's submitted proposal adjustment.
PA submitted by Contractor
	U/I	Contractor's Proposed Adjustment to PSA (Note 1)			Price Not Subject to Adjustment (Note 2)	Adjusted Unit Price
Structural Product Material (Identified Below)		QTY (Pounds)	Price	Total
Aluminum	Pounds	1000	$ 15.00	$ 15,000.00
Unit Price	EA			$ 15,000.00	$ 20,000.00	$ 35,000.00

NOTE 1: Per FAR 16.203-4 (c)(4)(ii), when adjustments are made, they shall not include

indirect cost or profit.

NOTE 2: Includes all remaining unit costs and profit not proposed under the PSA.

Step 3: PCO determines if any adjustments are applicable.
Adjustment calculation 1
A =	$ 15,000.00
U =	$ 10,000.00
Δ =	($15,000 - $10,000)/$10,000 OR:
	50.00%

50.00% is ≥ 5.00%; therefore, PA is considered.

Adjustment calculation 2
Proposed Adjusted Total Unit Price		$ 35,000.00
	divided by
Initial Proposed Total Unit Price		$ 30,000.00
	=	116.67%

The proposed adjusted total unit price is more than 10.00% higher than the initial proposed total unit

price. An EPA is applicable, but per FAR 52.216-4(c)(4), the increase will be capped at 10.00% higher than

the initial proposed total unit price.

Adjustment calculation 3 (capped at 10.00%)
Initial Proposed Total Unit Price		$ 30,000.00
	multiplied by	110.00%
	=
Adjusted Total Unit Price w/10.00% cap		$ 33,000.00

Step 4: Contractor's submitted PA meets the requirements for a price increase. The increase is capped at 10.00% higher than the initial proposed total unit price. A modification to the delivery order is issued for the adjusted unit price of $33,000 shown in Adjustment calculation 3.

Example of EPA Decrease
Step 1: PCO identifies baseline costs in the basic contract.
Contract Schedule
	U/I	Price Subject to Adjustment (Note 1)			Price Not Subject to Adjustment (Note 2)	Total Unit Price
Structural Product Material (Identified Below)		QTY (Pounds)	Price	Total
Aluminum	Pounds	1000	$ 10.00	$ 10,000.00
Unit Price	EA			$ 10,000.00	$ 20,000.00	$ 30,000.00

Step 2: PCO reviews new costs in contractor's submitted proposal adjustment.
PA submitted by Contractor
	U/I	Contractor's Proposed Adjustment to PSA (Note 1)			Price Not Subject to Adjustment (Note 2)	Adjusted Unit Price
Structural Product Material (Identified Below)		QTY (Pounds)	Price	Total
Aluminum	Pounds	1000	$ 9.50	$ 9,500.00
Unit Price	EA			$ 9,500.00	$ 20,000.00	$ 29,500.00

NOTE 1: Per FAR 16.203-4 (c)(4)(ii), when adjustments are made, they shall not include

indirect cost or profit.

NOTE 2: Includes all remaining unit costs and profit not proposed under the PSA.

Step 3: PCO determines if any adjustments are applicable.
Adjustment calculation 1
A =	$ 9,500.00
U =	$ 10,000.00
Δ =	($9,500 - $10,000)/$10,000 OR:
	-5.00%	(Absolute Value = 5.00%)

5.00% is ≥ 5.00%; therefore, PA is considered.

Adjustment calculation 2
Proposed Adjusted Total Unit Price		$ 29,500.00
	divided by
Initial Proposed Total Unit Price		$ 30,000.00
	=	98.33%

The proposed adjusted total unit price is less than the initial proposed total unit price; an EPA is

applicable. Per FAR 52.216-4(c)(4), there is no percentage limitation on the amount of decreases that may

be made.

Step 4: Contractor's submitted PA meets the requirements for a price decrease. A modification to the delivery order is issued for the adjusted unit price of $29,500 shown in Step 2.

File details come from the government source that posted it. Updated Dec 30, 2023.