Attch 9 - FPIF Monthly Invoicing Worksheet 20220721.xlsx

XLSX spreadsheet 129 KB Posted Jul 21, 2022

Attached to: Joint Navigation Warfare Center (JNWC) IV - DRAFT Request for Proposal
Solicitation number: FA2518-22-R-0027
Issued by: Department of the Air Force Space Command

View the file

Other files

File	Type	Posted
DRAFT JNWC IV TO One PWS.pdf	PDF	Jul 25, 2022
DRAFT JNWC IV Basic IDIQ Work Statement.pdf	PDF	Jul 25, 2022
0 - DRAFT Request for Proposal FA251822R0027.pdf	PDF	Jul 22, 2022
Attch 6 - DRAFT Factor 2 Staffing Matrix 20220721.xlsx	XLSX spreadsheet	Jul 21, 2022
0 - DRAFT Request for Proposal FA251822R0027.pdf	PDF	Jul 21, 2022
Attch 3 - DRAFT J3 Warfighter Support Scenario 20220721.pdf	PDF	Jul 21, 2022
Attch 2 - DRAFT Section M Evaluation Factors for Award 20220721.pdf	PDF	Jul 21, 2022
Attch 4 - DRAFT J3 Warfighter Support Grading Key 20220721.xlsx	XLSX spreadsheet	Jul 21, 2022
Attch 5 - DRAFT J9 Engineering Support Scenario 20220721.pdf	PDF	Jul 21, 2022
Attch 1 - DRAFT Section L Instructions Conditions Notices to Offerors 20220721.pdf	PDF	Jul 21, 2022
Attch 8 - Professional Compensation Evaluation Plan Form 20220721.xlsx	XLSX spreadsheet	Jul 21, 2022
Attch 7 - DRAFT FPIF CLIN Structure Spreadsheet 20220721.xlsx	XLSX spreadsheet	Jul 21, 2022

Show all 12

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.

IDIQ OP

DRAFT

Joint Navigation Warfare Center (JNWC) IV

RFP: FA2518-22-R-0027

Section J Attachment 9: FPIF Monthly Invoicing Worksheet NOTE: This attachment is for informational purposose ONLY. It is used to identfy how the FPIF will be administered on a monthly basis and is NOT required for proposal submission.

	EXAMPLE: Illistration not meant to be a representation of all Task Oders
		1	2	3	4	5	6	7	8	9	10
IDIQ		BASIC ORDERING PERIOD					OPTIONAL ORDER PERIOD

TO #1
	base period	OY1	OY2	OY3	OY4

TO #2
	base period	OY1	OY2	OY3	OY4

0	Base +4
0	Monthly

Instructions

Will be completed prior to final RFP release

Cumulative Annual Summary

RWW FPIF with: Target Cost $700,000; Target Profit $70,000; Target Price $770,000; Ceiling Price $840,000. Share 50/50 Under & 50/50 Over.

Target Cost		$ 700,000
Target Profit %/$	10.00%	$ 70,000
Target Price		$ 770,000
Ceiling %/$	120.00%	$ 840,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 840,000

Final Actual Audited Allowable Cost: $ 696,500

Final Contract Price: $ 768,250

Final Contractor Profit (Loss): $ 71,750

Final Contractor Profit (Loss) %: 10.30%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 700,000	$ 70,000	$ 700,000	$ 70,000		$ 840,000	$ - 0
2	$ 420,000	$ 210,000	$ 840,000	$ - 0	right scaler	$ 840,000	0
					1	$ 980,000	$ (140,000)
						$ 980,000	$ (140,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$700,000
	$ 696,500	$ 71,750	0	$ 71,750		Target Profit	$70,000
	$ 696,500	0	$ 696,500	$ 71,750		Target Price	$770,000
						Ceiling Price	$840,000

Target-PTA

700000	840000	70000	0	Ceiling
840000	840000	980000	980000	0	0	-140000	-140000	Under Target	700000	420000	70000	210000	Final Cost - Profit (Loss)
696500	696500	71750	0	Final Price horizontal
0	696500	71750	71750	Analyst Notes

Annual Math

RWW FPIF with: Target Cost $700,000; Target Profit $70,000; Target Price $770,000; Ceiling Price $840,000. Share 50/50 Under & 50/50 Over.

Target Cost		$ 700,000
Target Profit %/$	10.00%	$ 70,000
Target Price		$ 770,000
Ceiling %/$	120.00%	$ 840,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 840,000

Final Actual Audited Allowable Cost: $ 696,500

Final Contract Price: $ 768,250

Final Contractor Profit (Loss): $ 71,750

Final Contractor Profit (Loss) %: 10.30%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 700,000	$ 70,000	$ 700,000	$ 70,000		$ 840,000	$ - 0
2	$ 420,000	$ 210,000	$ 840,000	$ - 0	right scaler	$ 840,000	0
					1	$ 980,000	$ (140,000)
						$ 980,000	$ (140,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$700,000
	$ 696,500	$ 71,750	0	$ 71,750		Target Profit	$70,000
	$ 696,500	0	$ 696,500	$ 71,750		Target Price	$770,000
						Ceiling Price	$840,000

Target-PTA

700000	840000	70000	0	Ceiling
840000	840000	980000	980000	0	0	-140000	-140000	Under Target	700000	420000	70000	210000	Final Cost - Profit (Loss)
696500	696500	71750	0	Final Price horizontal
0	696500	71750	71750	Analyst Notes

Base Aug 2023

RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.

Target Cost		100,000
Target Profit %/$	10.00%	$ 10,000
Target Price		$ 110,000
Ceiling %/$	120.00%	$ 120,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 120,000

Final Actual Audited Allowable Cost: $ 90,000

Final Contract Price: $ 105,000

Final Contractor Profit (Loss): $ 15,000

Final Contractor Profit (Loss) %: 16.67%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encourage to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 100,000	$ 10,000	$ 100,000	$ 10,000		$ 120,000	$ - 0
2	$ 60,000	$ 30,000	$ 120,000	$ - 0	right scaler	$ 120,000	0
					1	$ 140,000	$ (20,000)
						$ 140,000	$ (20,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$100,000
	$ 90,000	$ 15,000	0	$ 15,000		Target Profit	$10,000
	$ 90,000	0	$ 90,000	$ 15,000		Target Price	$110,000
						Ceiling Price	$120,000

Target-PTA

100000	120000	10000	0	Ceiling
120000	120000	140000	140000	0	0	-20000	-20000	Under Target	100000	60000	10000	30000	Final Cost - Profit (Loss)
90000	90000	15000	0	Final Price horizontal
0	90000	15000	15000	Analyst Notes

Sep 2023

RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.

Target Cost		100,000
Target Profit %/$	10.00%	$ 10,000
Target Price		$ 110,000
Ceiling %/$	120.00%	$ 120,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 120,000

Final Actual Audited Allowable Cost: $ 100,000

Final Contract Price: $ 110,000

Final Contractor Profit (Loss): $ 10,000

Final Contractor Profit (Loss) %: 10.00%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 100,000	$ 10,000	$ 100,000	$ 10,000		$ 120,000	$ - 0
2	$ 60,000	$ 30,000	$ 120,000	$ - 0	right scaler	$ 120,000	0
					1	$ 140,000	$ (20,000)
						$ 140,000	$ (20,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$100,000
	$ 100,000	$ 10,000	0	$ 10,000		Target Profit	$10,000
	$ 100,000	0	$ 100,000	$ 10,000		Target Price	$110,000
						Ceiling Price	$120,000

Target-PTA

100000	120000	10000	0	Ceiling
120000	120000	140000	140000	0	0	-20000	-20000	Under Target	100000	60000	10000	30000	Final Cost - Profit (Loss)
100000	100000	10000	0	Final Price horizontal
0	100000	10000	10000	Analyst Notes

Oct 2023

RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.

Target Cost		100,000
Target Profit %/$	10.00%	$ 10,000
Target Price		$ 110,000
Ceiling %/$	120.00%	$ 120,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 120,000

Final Actual Audited Allowable Cost: $ 104,000

Final Contract Price: $ 112,000

Final Contractor Profit (Loss): $ 8,000

Final Contractor Profit (Loss) %: 7.69%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 100,000	$ 10,000	$ 100,000	$ 10,000		$ 120,000	$ - 0
2	$ 60,000	$ 30,000	$ 120,000	$ - 0	right scaler	$ 120,000	0
					1	$ 140,000	$ (20,000)
						$ 140,000	$ (20,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$100,000
	$ 104,000	$ 8,000	0	$ 8,000		Target Profit	$10,000
	$ 104,000	0	$ 104,000	$ 8,000		Target Price	$110,000
						Ceiling Price	$120,000

Target-PTA

100000	120000	10000	0	Ceiling
120000	120000	140000	140000	0	0	-20000	-20000	Under Target	100000	60000	10000	30000	Final Cost - Profit (Loss)
104000	104000	8000	0	Final Price horizontal
0	104000	8000	8000	Analyst Notes

Nov 2023

RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.

Target Cost		100,000
Target Profit %/$	10.00%	$ 10,000
Target Price		$ 110,000
Ceiling %/$	120.00%	$ 120,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 120,000

Final Actual Audited Allowable Cost: $ 98,000

Final Contract Price: $ 109,000

Final Contractor Profit (Loss): $ 11,000

Final Contractor Profit (Loss) %: 11.22%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 100,000	$ 10,000	$ 100,000	$ 10,000		$ 120,000	$ - 0
2	$ 60,000	$ 30,000	$ 120,000	$ - 0	right scaler	$ 120,000	0
					1	$ 140,000	$ (20,000)
						$ 140,000	$ (20,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$100,000
	$ 98,000	$ 11,000	0	$ 11,000		Target Profit	$10,000
	$ 98,000	0	$ 98,000	$ 11,000		Target Price	$110,000
						Ceiling Price	$120,000

Target-PTA

100000	120000	10000	0	Ceiling
120000	120000	140000	140000	0	0	-20000	-20000	Under Target	100000	60000	10000	30000	Final Cost - Profit (Loss)
98000	98000	11000	0	Final Price horizontal
0	98000	11000	11000	Analyst Notes

Dec 2023

RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.

Target Cost		100,000
Target Profit %/$	10.00%	$ 10,000
Target Price		$ 110,000
Ceiling %/$	120.00%	$ 120,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 120,000

Final Actual Audited Allowable Cost: $ 99,000

Final Contract Price: $ 109,500

Final Contractor Profit (Loss): $ 10,500

Final Contractor Profit (Loss) %: 10.61%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 100,000	$ 10,000	$ 100,000	$ 10,000		$ 120,000	$ - 0
2	$ 60,000	$ 30,000	$ 120,000	$ - 0	right scaler	$ 120,000	0
					1	$ 140,000	$ (20,000)
						$ 140,000	$ (20,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$100,000
	$ 99,000	$ 10,500	0	$ 10,500		Target Profit	$10,000
	$ 99,000	0	$ 99,000	$ 10,500		Target Price	$110,000
						Ceiling Price	$120,000

Target-PTA

100000	120000	10000	0	Ceiling
120000	120000	140000	140000	0	0	-20000	-20000	Under Target	100000	60000	10000	30000	Final Cost - Profit (Loss)
99000	99000	10500	0	Final Price horizontal
0	99000	10500	10500	Analyst Notes

Jan 2024

RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.

Target Cost		100,000
Target Profit %/$	10.00%	$ 10,000
Target Price		$ 110,000
Ceiling %/$	120.00%	$ 120,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 120,000

Final Actual Audited Allowable Cost: $ 102,500

Final Contract Price: $ 111,250

Final Contractor Profit (Loss): $ 8,750

Final Contractor Profit (Loss) %: 8.54%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 100,000	$ 10,000	$ 100,000	$ 10,000		$ 120,000	$ - 0
2	$ 60,000	$ 30,000	$ 120,000	$ - 0	right scaler	$ 120,000	0
					1	$ 140,000	$ (20,000)
						$ 140,000	$ (20,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$100,000
	$ 102,500	$ 8,750	0	$ 8,750		Target Profit	$10,000
	$ 102,500	0	$ 102,500	$ 8,750		Target Price	$110,000
						Ceiling Price	$120,000

Target-PTA

100000	120000	10000	0	Ceiling
120000	120000	140000	140000	0	0	-20000	-20000	Under Target	100000	60000	10000	30000	Final Cost - Profit (Loss)
102500	102500	8750	0	Final Price horizontal
0	102500	8750	8750	Analyst Notes

Feb 2024

RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.

Target Cost		100,000
Target Profit %/$	10.00%	$ 10,000
Target Price		$ 110,000
Ceiling %/$	120.00%	$ 120,000

			Assigned Shares
Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	50.0%	/	50.0%
			Over Target	50.0%	/	50.0%

		Calculated Shares
Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared.	Cost	Profit
		Optimistic

DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.

Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.

Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values.	Govt	/	Ktr
			Under Target	/
			Over Target	/

Point of Total Assumption (PTA) $ 120,000

Final Actual Audited Allowable Cost: $ 103,000

Final Contract Price: $ 111,500

Final Contractor Profit (Loss): $ 8,500

Final Contractor Profit (Loss) %: 8.25%

Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.

			Govt	/Ktr
			50%	50%	Under	50	50	50/50 Under
			50%	50%	Over	50	50	50/50 Over
	Under Target		Target-PTA			Ceiling
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Cost	Profit
left Scaler	$ 100,000	$ 10,000	$ 100,000	$ 10,000		$ 120,000	$ - 0
2	$ 60,000	$ 30,000	$ 120,000	$ - 0	right scaler	$ 120,000	0
					1	$ 140,000	$ (20,000)
						$ 140,000	$ (20,000)
	Final Cost - Profit (Loss)		Final Price horizontal				Dollar Text
	Cost	Profit/(Loss)	Cost	Profit/(Loss)		Target Cost	$100,000
	$ 103,000	$ 8,500	0	$ 8,500		Target Profit	$10,000
	$ 103,000	0	$ 103,000	$ 8,500		Target Price	$110,000
						Ceiling Price	$120,000

Target-PTA

100000	120000	10000	0	Ceiling
120000	120000	140000	140000	0	0	-20000	-20000	Under Target	100000	60000	10000	30000	Final Cost - Profit (Loss)
103000	103000	8500	0	Final Price horizontal
0	103000	8500	8500	Analyst Notes

File details come from the government source that posted it. Updated Jul 21, 2022.