03_Sep_2015_Replacement_Attachment_J-16a_DPF_Incentive_Calculator_-_Notional_Values.xls

XLS spreadsheet 218 KB Posted Sep 3, 2015

Attached to: TEAMS - Facilities, Logistics and Space Management
Solicitation number: HQ0147-15-R-0017
Issued by: DOD Missile Defense Agency

About this file

From the source

Replacement Attachment J-16a DPF Incentive Calculator - Notional Values

View the file

Other files

File	Type	Posted
HQ0147-R-15-0017__SF_30_Amendment_003.pdf	PDF	Sep 29, 2015
Section_L_-_Instructions_to_Offerors_-_FLSM__Amendment_0003.pdf	PDF	Sep 29, 2015
HQ0147-R-15-0017__SF_30_Amendment_0002.pdf	PDF	Sep 29, 2015
HQ0147-R-15-0017__SF_33.pdf	PDF	Sep 29, 2015
Attachment_J_ _L_Amendment_0001_FLSM.zip	ZIP file	Sep 28, 2015
FLSM_Q As_-_Final_RFP__28_Sep_15.pdf	PDF	Sep 28, 2015
Section_L_-_Instructions_to_Offerors_-_FLSM.pdf	PDF	Sep 28, 2015
HQ0147-R-15-0017_Amendment_0001_FLSM.pdf	PDF	Sep 28, 2015
Section_L_Attachments.zip	ZIP file	Sep 2, 2015
HQ0147-15-R-0017_FLSM_9.2.15.pdf	PDF	Sep 2, 2015
Section__M_-_Evaluation_Criteria_-_FLSM.pdf	PDF	Sep 2, 2015
Section_J_Attachments.zip	ZIP file	Sep 2, 2015
Section_L_-_Instructions_to_Offerors_-_FLSM.pdf	PDF	Sep 2, 2015

Show all 13

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.

TOTAL ROLLUP

Cost Plus Incentive Fee (CPIF) Calculator for DPF Portal - Notional Values
TARGET CPIF VALUES	Base Period	Option 1	Option 2	Total, All Periods
Target Cost =	$ 5,000,000	$ 1,750,000	$ 1,750,000	$ 8,500,000
Cost Incentive Fee Pool =	$ 135,000	$ 47,250	$ 47,250	$ 229,500
Performance Incentive Fee Pool =	$ 315,000	$ 110,250	$ 110,250	$ 535,500
Total Target Fee =	$ 450,000	$ 157,500	$ 157,500	$ 765,000
Total Target CPIF =	$ 5,450,000	$ 1,907,500	$ 1,907,500	$ 9,265,000
ACTUAL CPIF at end of Period	Base Period	Option 1	Option 2	Total, All Periods
Actual Cost =	$ 4,850,000	$ 1,784,000	$ 1,699,751	$ 8,333,751
Cost Incentive Fee Earned =	$ 180,000	$ 37,050	$ 62,325	$ 279,375
Performance Incentive Fee Earned =	$ 315,000	$ 110,250	$ 110,250	$ 535,500
Total CPIF at end of Period =	$ 5,345,000	$ 1,931,300	$ 1,872,326	$ 9,148,626
	Allocation of Incentive Fees		Share Ratios	Underrun	Overrun
Cost Incentive Share	30.0%		Contractor	30%	30%
Performance Incentive Share	70.0%		Govt	70%	70%	Cost Incentive Fee Available, Base + Option Years
						Optimistic Cost	Max Fee	Max Fee Percentage
						$ 7,990,000	$ 382,500	4.50%
			Proposed Fee	Actual Fee
Percent Delta from Target Cost for RIE	6.00%		$ 765,000	$ 814,875		Target Cost	Target Fee	Target Fee Percentage
		ENTER	9%	9.78%		$ 8,500,000	$ 229,500	2.70%
						Pessimistic Cost	Min Fee	Min Fee Percentage
						$ 9,010,000	$ 76,500	0.90%

&C03 Septmber 2015

TOTAL ROLLUP

7990000	7990000	9010000	0	8333751	7990000	9010000	8500000	7990000	9148625.7	0
8500000	4750000	12250000	8333751	8333751	7990000	9010000	9010000	9010000	9148625.7	9148625.7

Max-Target-Min Max Fee Min Fee CPIF With Cost Incentive Only Final Vertical RIE Left RIE Right Target-Min Range of Incentive Effectiveness Performance Vertical CPIF+ Peformance Incentive Earned Labor Cost Total Incentive Fee Total Contract Incentive Fee 382500 382500 76500 279374.7 382500 76500 229500 45000 814874.7 229500 382500 76500 279374.7 279374.7 76500 45000 814874.7 814874.7

Perf Incentives

			Performance Incentive Earned
PERFORMANCE INCENTIVE #1 - Customer Satisfaction			Share of 70%	Annual Pool - Base Period	Option 1 Pool	Option 2 Pool
		Percentage Very Satisfied greater than than or equal to 75% =	100%	$ 105,000	$ 110,250	$ 110,250
		Percentage Very Satisfied + Percentage Satisfied greater than or equal to 90% =	75%	$ 78,750	$ 82,688	$ 82,688
		Percentage Very Satisfied + Percentage Satisfied Between 75% and 90% =	50%	$ 52,500	$ 55,125	$ 55,125
		Percentage Very Satisfied + Percentage Satisfied less than 75% =	0%	$ - 0	$ - 0	$ - 0
	ENTER Yr 1 Very Satisfied Percentage =	80.00%
	ENTER Yr 2 Very Satisfied Percentage =	80.00%
	ENTER Yr 3 Very Satisfied Percentage =	80.00%
	ENTER Yr 4 Very Satisfied Percentage =	80.00%
	ENTER Yr 5 Very Satisfied Percentage =	80.00%
	ENTER Yr 1 Satisfied Percentage Achieved =	25.00%			Incentive Earned Yr 1 =	$ 105,000
	ENTER Yr 2 Satisfied Percentage Achieved =	35.00%			Incentive Earned Yr 2 =	$ 105,000
	ENTER Yr 3 Satisfied Percentage Achieved =	80.00%			Incentive Earned Yr 3 =	$ 105,000
	ENTER Yr 4 Satisfied Percentage Achieved =	45.00%			Incentive Earned Yr 4 =	$ 110,250
	ENTER Yr 5 Satisfied Percentage Achieved =	30.00%			Incentive Earned Yr 5 =	$ 110,250
					Total Incentive Earned =	$ 535,500
	ENTER Yr 1 Very Satisfied + Satisfied Percentage =	105.00%
	ENTER Yr 2 Very Satisfied + Satisfied Percentage =	115.00%
	ENTER Yr 3 Very Satisfied + Satisfied Percentage =	160.00%
	ENTER Yr 4 Very Satisfied + Satisfied Percentage =	125.00%
	ENTER Yr 5 Very Satisfied + Satisfied Percentage =	110.00%
						2 of 2
						1 of 2
						0 of 2
						0

&C03 Septmber 2015

Cost Incentive, Base

Cost Incentive Earned, Base Period
Cost Incentive Fee Available, Base Period
Optimistic Cost	Max Fee	Max Fee Percentage
$ 4,700,000	$ 225,000	4.50%
Target Cost	Target Fee	Target Fee Percentage
$ 5,000,000	$ 135,000	2.70%
Pessimistic Cost	Min Fee	Min Fee Percentage
$ 5,300,000	$ 45,000	0.90%
	Contractor Share of Under or Overrun =	Ktr Share % * (Target - Cost)
If Contractor Share > Max Fee, then Pay Max Fee
If Contractor Share < Than Min Fee, then Pay Min Fee
If Contractor Share < Max Fee and > Min Fee, then Pay Contractor Share
(EXAMPLE) Cost Incentive Earned, Base Period
	ENTER Actual Cost =	$ 4,850,000
	Share (based on Under or Overrun) =	30%
	Target Cost Incentive Fee =	$ 135,000
	+ Contractor Under/Overrun Share =	$ 45,000
	Calculated Total =	$ 180,000
	Cost Incentive Fee Earned, Base Period	$ 180,000
		CPI with: Target Cost $5,000,000; Target Fee $135,000; Min Fee $45,000; Max Fee $225,000. Contractor Share is 30%Underrun & 30%Overrun.

&C03 Septmber 2015

Cost Incentive, Base

4700000	4700000	5300000	0	4850000	4700000	5300000	5000000	4700000
5000000	2300000	7700000	4850000	4850000	4700000	5300000	5300000	5300000

Max-Target-Min Max Fee Min Fee CPIF With Cost Incentive Only Final Vertical RIE Left RIE Right Target-Min Range of Incentive Effectiveness Labor Cost Cost Incentive Fee DPF Portal Cost Incentive Fee, Base Period 225000 225000 45000 180000 225000 45000 135000 25000 135000 225000 45000 180000 180000 45000 25000

Cost Incentive, Option 1

Cost Incentive Earned, Option Period 1
Cost Incentive Fee Available, Option Period 1
Optimistic Cost	Max Fee	Max Fee Percentage
$ 1,645,000	$ 78,750	4.50%
Target Cost	Target Fee	Target Fee Percentage
$ 1,750,000	$ 47,250	2.70%
Pessimistic Cost	Min Fee	Min Fee Percentage
$ 1,855,000	$ 15,750	0.90%
	Contractor Share of Under or Overrun =	Ktr Share % * (Target - Cost)
If Contractor Share > Max Fee, then Pay Max Fee
If Contractor Share < Than Min Fee, then Pay Min Fee
If Contractor Share < Max Fee and > Min Fee, then Pay Contractor Share
Cost Incentive Earned, Option Period 1
	ENTER Actual Cost =	$ 1,784,000
	Share (based on Under or Overrun) =	30%
	Target Cost Incentive Fee =	$ 47,250
	+ Contractor Under/Overrun Share =	$ (10,200)
	Calculated Total =	$ 37,050
	Cost Incentive Earned, Option Period 1	$ 37,050
		CPI with: Target Cost $1,750,000; Target Fee $47,250; Min Fee $15,750; Max Fee $78,750. Contractor Share is 30%Underrun & 30%Overrun.

Manually Update Actual Cost at End of Performance Period &C03 Septmber 2015

Cost Incentive, Option 1

1645000	1645000	1855000	0	1784000	1645000	1855000	1645000	1750000
1750000	1225000	2275000	1784000	1784000	1645000	1855000	1855000	1855000

Max-Target-Min Max Fee Min Fee Final Final Vertical RIE Left RIE Right Range of Incentive Effectiveness Target-Min Labor Cost Cost Incentive Fee DPF Portal Cost Incentive Fee, Option Period 1 78750 78750 15750 37050 78750 15750 10000 47250 47250 78750 15750 37050 37050 10000 15750

Cost Incentive, Option 2

Cost Incentive Earned, Option Period 2
Cost Incentive Fee Available, Option Period 2
Optimistic Cost	Max Fee	Max Fee Percentage
$ 1,645,000	$ 78,750	4.50%
Target Cost	Target Fee	Target Fee Percentage
$ 1,750,000	$ 47,250	2.70%
Pessimistic Cost	Min Fee	Min Fee Percentage
$ 1,855,000	$ 15,750	0.90%
	Contractor Share of Under or Overrun =	Ktr Share % * (Target - Cost)
If Contractor Share > Max Fee, then Pay Max Fee
If Contractor Share < Than Min Fee, then Pay Min Fee
If Contractor Share < Max Fee and > Min Fee, then Pay Contractor Share
Cost Incentive Earned, Option Period 2
	ENTER Actual Cost =	$ 1,699,751
	Share (based on Under or Overrun) =	30%
	Target Cost Incentive Fee =	$ 47,250
	+ Contractor Under/Overrun Share =	$ 15,075
	Calculated Total =	$ 62,325
	Cost Incentive Earned, Option Period 2	$ 62,325
		CPI with: Target Cost $1,750,000; Target Fee $47,250; Min Fee $15,750; Max Fee $78,750. Contractor Share is 30%Underrun & 30%Overrun.

Manually Update Actual Cost at End of Performance Period &C03 Septmber 2015

Cost Incentive, Option 2

1645000	1645000	1855000	0	1699751	1645000	1855000	1645000	1750000
1750000	1225000	2275000	1699751	1699751	1645000	1855000	1855000	1855000

Max-Target-Min Max Fee Min Fee Final Final Vertical RIE Left RIE Right Range of Incentive Effectiveness Target-Min Labor Cost Cost Incentive Fee DPF Portal Cost Incentive Fee, Option Period 2 78750 78750 15750 62324.7 78750 15750 10000 47250 47250 78750 15750 62324.7 62324.7 10000 15750

Graph Data -DO NOT EDIT

					Contractor	Government
				Underrun	30	70	30%Underrun
				Overrun	30	70	30%Overrun
	Base	Option 1	Option 2	Total
	Dollar	Dollar	Dollar	Dollar
Target Cost	$5,000,000	$1,750,000	$1,750,000	$ 8,500,000
Target Fee	$135,000	$47,250	$47,250	$ 229,500
Tentative Fee	$180,000	$37,050	$62,325	$ 279,375
Min-Fee	$45,000	$15,750	$15,750	$ 76,500
Max-Fee	$225,000	$78,750	$78,750	$ 382,500
	Max-Target-Min	Max-Target-Min	Max-Target-Min	Max-Target-Min
	$ 4,700,000	$ 1,645,000	$ 1,645,000	$ 7,990,000
	$ 5,000,000	$ 1,750,000	$ 1,750,000	$ 8,500,000
	$ 225,000	$ 78,750	$ 78,750	$ 382,500
	$ 135,000	$ 47,250	$ 47,250	$ 229,500
	Target-Min	Target-Min	Target-Min	Target-Min
	$ 5,000,000	$ 1,750,000	$ 1,750,000	$ 8,500,000
	$ 5,300,000	$ 1,855,000	$ 1,855,000	$ 9,010,000
	$ 135,000	$ 47,250	$ 47,250	$ 229,500
	$ 45,000	$ 15,750	$ 15,750	$ 76,500
Left Scaler	4	2	2
Max Fee	$ 4,700,000	$ 1,645,000	$ 1,645,000	$ 7,990,000
	$ 2,300,000	$ 1,225,000	$ 1,225,000	$ 4,750,000
	$ 225,000	$ 78,750	$ 78,750	$ 382,500
	$ 225,000	$ 78,750	$ 78,750	$ 382,500
	$ 225,000	$ 78,750	$ 78,750	$ 382,500
Right Scaler	4	2	2
Min Fee	$ 5,300,000	$ 1,855,000	$ 1,855,000	$ 9,010,000
	$ 7,700,000	$ 2,275,000	$ 2,275,000	$ 12,250,000
	$ 45,000	$ 15,750	$ 15,750	$ 76,500
	$ 45,000	$ 15,750	$ 15,750	$ 76,500
	$ 45,000	$ 15,750	$ 15,750	$ 76,500
				$ - 0
RIE Left	$ 4,700,000	$ 1,645,000	$ 1,645,000	$ 7,990,000
	$ 4,700,000	$ 1,645,000	$ 1,645,000	$ 7,990,000
	$ 225,000	$ 78,750	$ 78,750	$ 382,500
	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0
RIE Right	$ 5,300,000	$ 1,855,000	$ 1,855,000	$ 9,010,000
	$ 5,300,000	$ 1,855,000	$ 1,855,000	$ 9,010,000
	$ 45,000	$ 15,750	$ 15,750	$ 76,500
	$ - 0	$ - 0	$ - 0	$ - 0
RIE	$ 4,700,000	$ 1,645,000	$ 1,645,000	$ 7,990,000
	$ 5,300,000	$ 1,855,000	$ 1,855,000	$ 9,010,000
	$ 25,000	$ 10,000	$ 10,000	$ 45,000
	$ 25,000	$ 10,000	$ 10,000	$ 45,000
				$ - 0
Final Cost - Fee Vertical	$ 4,850,000	$ 1,784,000	$ 1,699,751	$ 8,333,751
	$ 4,850,000	$ 1,784,000	$ 1,699,751	$ 8,333,751
	0	0	0	$ - 0
	$ 180,000	$ 37,050	$ 62,325	$ 279,375
Final Cost - Fee Horizontal
	$ - 0	$ - 0	$ - 0	$ - 0
	$ 4,850,000	$ 1,784,000	$ 1,699,751	$ 8,333,751
	$ 180,000	$ 37,050	$ 62,325	$ 279,375
	$ 180,000	$ 37,050	$ 62,325	$ 279,375
Performance Incentive Bars
Performance Vertical Bar	$ 5,345,000	$ 1,931,300	$ 1,872,326	$ 9,148,626
	$ 5,345,000	$ 1,931,300	$ 1,872,326	$ 9,148,626
	0	0	0	$ - 0
	$ 495,000	$ 147,300	$ 172,575	$ 814,875
Performance Horizontal Bar	$ - 0	$ - 0	$ - 0	$ - 0
	$ 5,345,000	$ 1,931,300	$ 1,872,326	$ 9,148,626
	$ 495,000	$ 147,300	$ 172,575	$ 814,875
	$ 495,000	$ 147,300	$ 172,575	$ 814,875
		Customer Satisfaction Rates for Performance Incentive
		75%
		90%
		75%
		0%

Manually Update Actual Cost at End of Performance Period &C03 Septmber 2015

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