RFP Atch 17_C-5 FPIF Application.xlsx

XLSX spreadsheet 53 KB Posted

Attached to
C-5 Supplemental Depot Capability Federal contract opportunity
Solicitation number
FA8525-22-R-0003
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center

About this file

This document contains a template for calculating incentive fees for a fixed price incentive firm target contract to provide supplemental depot maintenance for C-5 aircraft. The template outlines how target costs, delivery schedules, and resulting incentive fees would be determined for each induction. It includes examples calculating incentive dollars and final prices under various hypothetical cost and schedule scenarios. The schedule factors and flow days per induction that would be used to determine schedule incentives are also provided.

View the file

Other files for this federal contract opportunity

Other files attached to C-5 Supplemental Depot Capability, newest first.
File Type Posted
SDC Industry QA_29 March 2022_ Attendance Listing_SAM.pdf PDF
Industry Day QA_29 Mar 2022.pdf PDF
DRAFT FA8525-22-R-0003.pdf PDF
Blank DD Form 2345.pdf PDF
Agenda.pdf PDF
PWS_C5 SDC_v17 Mar 22 _Draft.docx DOCX document
Draft_ C-5 SDC Section M.docx DOCX document
Draft_C-5 SDC Section L.docx DOCX document
Gov Response to Industry RFI Nov 2021 Ver 5.pdf PDF

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

Text version

CLIN X001 Incentive for PDM CLIN X001 (Incentive $ for PDM) Example: Base Period

COST/PRICE ELEMENTHOURS/BASERATEAMOUNTNOTES:
This worksheet is for demonstration of how the incentive profit will be calculated during execution of the contract.
TARGET COST (PDM, CLIN 0001)$ 1,000.00As stated in the draft RFP, the underrun and overrun shares are 50/50. The Ceiling Price is 130% of Target Cost.
TOTAL TARGET INCENTIVE DOLLARS$ 1,000.0010.00%$ 100.00Target Cost and Target Profit values are provided for example only and are not representative of the estimated pricing for this program.
CEILING PRICE130.00%$ 1,300.00Offerors must note that the 'schedule factors' (shown in Columns H and J) vary per induction. The entire factor listing is based on the flow days per induction, shown on "Schedule Flow Days by Induction".
The schedule factors have been established by the Government and will not be subject to change in proposals.
Total Target Incentive Dollars is broken down into:Scenarios #3 are hypothetical scenarios for demonstration and not representative of the estimated performance for this program.
1) TARGET COST INCENTIVE PROFIT (CLIN X001)$ 100.0030%$ 30.00
TOTAL$ 30.00

2) TARGET DELIVERY SCHEDULE INCENTIVE PROFIT (FOR CLIN 0001) $ 100.00 70% $ 70.00

Scenario 1: Induction 1, 5% Cost Underrun, Delivery Early by 60 daysTarget Flow Days560
Calculation of Incentive $:Actual Flow Days500
Under Days60
Actual Cost:$ 950.00
+/- from Target:$ 50.00
Ktr Underrun Share:$ 25.00
Target Profit, Cost share: 30%$ 30.00
Target Profit, Delivery share: 70%$ 77.56
Total Potential Profit:$ 132.56
Net Profit for Cost Incentive:$ 55.00
Net Profit for Schedule Incentive:$ 77.56
Total Potential Profit/Incentive:$ 132.56

Final Price: $ 1,082.56

Scenario 2: Induction 1, 5% Cost Overrun, Delivery Late by 31 daysTarget Flow Days476
Calculation of Incentive $:Actual Flow Days375
Over Days101
Actual Cost:$ 1,050.00
+/- from Target:$ (50.00)
Ktr Overrun Share:$ (25.00)
Target Profit, Cost share: 30%$ 30.00
Target Profit, Delivery share: 70%$ 60.10
Total Potential Profit:$ 65.10
Net Profit for Cost Incentive:$ 5.00
Net Profit for Schedule Incentive:$ 60.10
Total Potential Profit/Incentive:$ 65.10

Final Price: $ 1,115.10

Scenario 3: Induction 1, 20% Cost Overrun, Delivery Early by MAX 150 daysTarget Flow Days476
Calculation of Incentive $:Actual Flow Days326
Under Days150
Actual Cost:$ 1,200.00
+/- from Target:$ (200.00)
Ktr Overrun Share:$ (100.00)
Target Profit, Cost share: 30%$ 30.00
Target Profit, Delivery share: 70%$ 99.40
Total Potential Profit:$ 29.40
Net Profit for Cost Incentive:$ (70.00)
Net Profit for Schedule Incentive:$ 99.40
Total Potential Profit/Incentive:$ 29.40

Final Price: $ 1,229.40 Adjusted to Ceiling Price

Schedule Flow Days by Induction

Induction 1Induction 2Induction 3Aircraft InductionFlow Day% Improvement
PDM FPIF IncentivePDM FPIF IncentivePDM FPIF Incentive156015%
Target Days:560Target Days:476Target Days:428247610%
Day RangeTotal DaysPercentageDay RangeTotal DaysPercentageDay RangeTotal DaysPercentage34289%
92-98+4620.002892-98+3780.002892-98+3300.002843908%
85-914690.002685-913850.002685-913370.002653598%
78-844760.002478-843920.002478-843440.002463307%
71-774830.002271-773990.002271-773510.002273077%
64-704900.002064-704060.002064-703580.002082857%
57-634970.001857-634130.001857-633650.001892650%
50-565040.001650-564200.001650-563720.0016102650%
43-495110.001443-494270.001443-493790.0014112650%
36-425180.001236-424340.001236-423860.0012122650%
29-355250.001029-354410.001029-353930.0010132650%
22-285320.000822-284480.000822-284000.0008142650%
15-215390.000615-214550.000615-214070.0006152650%
8-145460.00048-144620.00048-144140.0004162650%
1-75530.00021-74690.00021-74210.0002
Goal Days5600.0000Goal Days4760.0000Goal Days4280.0000
1-7567-0.00011-7483-0.00011-7435-0.0001
8-14574-0.00028-14490-0.00028-14442-0.0002
15-21581-0.000315-21497-0.000315-21449-0.0003
22-28588-0.000422-28504-0.000422-28456-0.0004
29-35595-0.000529-35511-0.000529-35463-0.0005
36-42602-0.000636-42518-0.000636-42470-0.0006
43-49609-0.000743-49525-0.000743-49477-0.0007
50-56616-0.000850-56532-0.000850-56484-0.0008
57-63623-0.000957-63539-0.000957-63491-0.0009
64-70630-0.001064-70546-0.001064-70498-0.0010
71-77637-0.001171-77553-0.001171-77505-0.0011
78-84644-0.001278-84560-0.0012
85-91651-0.0013
92-98+658-0.0014
Induction 4Induction 5Induction 6
PDM FPIF IncentivePDM FPIF IncentivePDM FPIF Incentive
Target Days:390Target Days:359Target Days:330
Day RangeTotal DaysPercentageDay RangeTotal DaysPercentageDay RangeTotal DaysPercentage
92-982920.002843-493100.001415-213090.0006
85-912990.002636-423170.00128-143160.0004
78-843060.002429-353240.00101-73230.0002
71-773130.002222-283310.0008Goal Days3300.0000
64-703200.002015-213380.00061-7337-0.0001
57-633270.00188-143450.00048-14344-0.0002
50-563340.00161-73520.000215-21351-0.0003
43-493410.0014Goal Days3590.000022-28358-0.0004
36-423480.00121-7366-0.000129-35365-0.0005
29-353550.00108-14373-0.000236-42372-0.0006
22-283620.000815-21380-0.000343-49379-0.0007
15-213690.000622-28387-0.000450-56386-0.0008
8-143760.000429-35394-0.000557-63393-0.0009
1-73830.000236-42401-0.000664-70400-0.0010
Goal Days3900.000043-49408-0.0007
1-7397-0.000150-56415-0.0008
8-14404-0.000257-63422-0.0009
15-21411-0.000364-70429-0.0010
22-28418-0.0004
29-35425-0.0005
36-42432-0.0006
43-49439-0.0007
50-56446-0.0008
57-63453-0.0009
64-70460-0.0010
Induction 7Induction 8Induction 9 plus future inductions
PDM FPIF IncentivePDM FPIF IncentivePDM FPIF Incentive
Target Days:307Target Days:285Target Days:265
Day RangeTotal DaysPercentageDay RangeTotal DaysPercentageDay RangeTotal DaysPercentage
15-212860.000615-212640.000615-212440.0006
8-142930.00048-142710.00048-142510.0004
1-73000.00021-72780.00021-72580.0002
Goal Days3070.0000Goal Days2850.0000Goal Days2650.0000
1-7314-0.00011-7292-0.00011-7272-0.0001
8-14321-0.00028-14299-0.00028-14279-0.0002
15-21328-0.000315-21306-0.000315-21286-0.0003
22-28335-0.000422-28313-0.000422-28293-0.0004
29-35342-0.000529-35320-0.000529-35300-0.0005
36-42349-0.000636-42327-0.000636-42307-0.0006
43-49356-0.000743-49334-0.000743-49314-0.0007
50-56363-0.000850-56341-0.000850-56321-0.0008
57-63370-0.000957-63348-0.000957-63328-0.0009
64-70377-0.001064-70355-0.001064-70335-0.0010

Draft

Target Flow Days560Target Flow Days476Target Flow Days405Target Flow Days344Target Flow Days292Target Flow Days265
Induction 1Induction 2Induction 3Induction 4Induction 5Future Inductions
Actual Flow DaysDifference from TargetPercent ProfitActual Flow DaysDifference from TargetPercent ProfitActual Flow DaysDifference from TargetPercent ProfitActual Flow DaysDifference from TargetPercent ProfitActual Flow DaysDifference from TargetPercent ProfitActual Flow DaysDifference from TargetPercent Profit
510-500.980.98510-500.980.98510-500.980.98510-500.980.98510-500.980.98510-500.980.98
511-490.960.96511-490.960.96511-490.960.96511-490.960.96511-490.960.96511-490.960.96
512-480.940.94512-480.940.94512-480.940.94512-480.940.94512-480.940.94512-480.940.94
513-470.920.92513-470.920.92513-470.920.92513-470.920.92513-470.920.92513-470.920.92
514-460.90.9514-460.90.9514-460.90.9514-460.90.9514-460.90.9514-460.90.9
515-450.880.88515-450.880.88515-450.880.88515-450.880.88515-450.880.88515-450.880.88
516-440.860.86516-440.860.86516-440.860.86516-440.860.86516-440.860.86516-440.860.86
517-430.840.84517-430.840.84517-430.840.84517-430.840.84517-430.840.84517-430.840.84
518-420.820.82518-420.820.82518-420.820.82518-420.820.82518-420.820.82518-420.820.82
519-410.80.8519-410.80.8519-410.80.8519-410.80.8519-410.80.8519-410.80.8
520-400.780.78520-400.780.78520-400.780.78520-400.780.78520-400.780.78520-400.780.78
521-390.760.76521-390.760.76521-390.760.76521-390.760.76521-390.760.76521-390.760.76
522-380.740.74522-380.740.74522-380.740.74522-380.740.74522-380.740.74522-380.740.74
523-370.720.72523-370.720.72523-370.720.72523-370.720.72523-370.720.72523-370.720.72
524-360.70.7524-360.70.7524-360.70.7524-360.70.7524-360.70.7524-360.70.7
525-350.680.68525-350.680.68525-350.680.68525-350.680.68525-350.680.68525-350.680.68
526-340.660.66526-340.660.66526-340.660.66526-340.660.66526-340.660.66526-340.660.66
527-330.640.64527-330.640.64527-330.640.64527-330.640.64527-330.640.64527-330.640.64
528-320.620.62528-320.620.62528-320.620.62528-320.620.62528-320.620.62528-320.620.62
529-310.60.6529-310.60.6529-310.60.6529-310.60.6529-310.60.6529-310.60.6
530-300.580.58530-300.580.58530-300.580.58530-300.580.58530-300.580.58530-300.580.58
531-290.560.56531-290.560.56531-290.560.56531-290.560.56531-290.560.56531-290.560.56
532-280.540.54532-280.540.54532-280.540.54532-280.540.54532-280.540.54532-280.540.54
533-270.520.52533-270.520.52533-270.520.52533-270.520.52533-270.520.52533-270.520.52
534-260.50.5534-260.50.5534-260.50.5534-260.50.5534-260.50.5534-260.50.5
535-250.480.48535-250.480.48535-250.480.48535-250.480.48535-250.480.48535-250.480.48
536-240.460.46536-240.460.46536-240.460.46536-240.460.46536-240.460.46536-240.460.46
537-230.440.44537-230.440.44537-230.440.44537-230.440.44537-230.440.44537-230.440.44
538-220.420.42538-220.420.42538-220.420.42538-220.420.42538-220.420.42538-220.420.42
539-210.40.4539-210.40.4539-210.40.4539-210.40.4539-210.40.4539-210.40.4
540-200.380.38540-200.380.38540-200.380.38540-200.380.38540-200.380.38540-200.380.38
541-190.360.36541-190.360.36541-190.360.36541-190.360.36541-190.360.36541-190.360.36
542-180.340.34542-180.340.34542-180.340.34542-180.340.34542-180.340.34542-180.340.34
543-170.320.32543-170.320.32543-170.320.32543-170.320.32543-170.320.32543-170.320.32
544-160.30.3544-160.30.3544-160.30.3544-160.30.3544-160.30.3544-160.30.3
545-150.280.28545-150.280.28545-150.280.28545-150.280.28545-150.280.28545-150.280.28
546-140.260.26546-140.260.26546-140.260.26546-140.260.26546-140.260.26546-140.260.26
547-130.240.24547-130.240.24547-130.240.24547-130.240.24547-130.240.24547-130.240.24
548-120.220.22548-120.220.22548-120.220.22548-120.220.22548-120.220.22548-120.220.22
549-110.20.2549-110.20.2549-110.20.2549-110.20.2549-110.20.2549-110.20.2
550-100.180.18550-100.180.18550-100.180.18550-100.180.18550-100.180.18550-100.180.18
551-90.160.16551-90.160.16551-90.160.16551-90.160.16551-90.160.16551-90.160.16
552-80.140.14552-80.140.14552-80.140.14552-80.140.14552-80.140.14552-80.140.14
553-70.120.12553-70.120.12553-70.120.12553-70.120.12553-70.120.12553-70.120.12
554-60.10.1554-60.10.1554-60.10.1554-60.10.1554-60.10.1554-60.10.1
555-50.080.08555-50.080.08555-50.080.08555-50.080.08555-50.080.08555-50.080.08
556-40.060.06556-40.060.06556-40.060.06556-40.060.06556-40.060.06556-40.060.06
557-30.040.04557-30.040.04557-30.040.04557-30.040.04557-30.040.04557-30.040.04
558-20.020.02558-20.020.02558-20.020.02558-20.020.02558-20.020.02558-20.020.02
559-100559-100559-100559-100559-100559-100
5600-0.01-0.015600-0.01-0.015600-0.01-0.015600-0.01-0.015600-0.01-0.015600-0.01-0.01
5611-0.02-0.025611-0.02-0.025611-0.02-0.025611-0.02-0.025611-0.02-0.025611-0.02-0.02
5622-0.03-0.035622-0.03-0.035622-0.03-0.035622-0.03-0.035622-0.03-0.035622-0.03-0.03
5633-0.04-0.045633-0.04-0.045633-0.04-0.045633-0.04-0.045633-0.04-0.045633-0.04-0.04
5644-0.05-0.055644-0.05-0.055644-0.05-0.055644-0.05-0.055644-0.05-0.055644-0.05-0.05
5655-0.06-0.065655-0.06-0.065655-0.06-0.065655-0.06-0.065655-0.06-0.065655-0.06-0.06
5666-0.07-0.075666-0.07-0.075666-0.07-0.075666-0.07-0.075666-0.07-0.075666-0.07-0.07
5677-0.08-0.085677-0.08-0.085677-0.08-0.085677-0.08-0.085677-0.08-0.085677-0.08-0.08
5688-0.09-0.095688-0.09-0.095688-0.09-0.095688-0.09-0.095688-0.09-0.095688-0.09-0.09
5699-0.1-0.15699-0.1-0.15699-0.1-0.15699-0.1-0.15699-0.1-0.15699-0.1-0.1
57010-0.11-0.1157010-0.11-0.1157010-0.11-0.1157010-0.11-0.1157010-0.11-0.1157010-0.11-0.11
57111-0.12-0.1257111-0.12-0.1257111-0.12-0.1257111-0.12-0.1257111-0.12-0.1257111-0.12-0.12
57212-0.13-0.1357212-0.13-0.1357212-0.13-0.1357212-0.13-0.1357212-0.13-0.1357212-0.13-0.13
57313-0.14-0.1457313-0.14-0.1457313-0.14-0.1457313-0.14-0.1457313-0.14-0.1457313-0.14-0.14
57414-0.15-0.1557414-0.15-0.1557414-0.15-0.1557414-0.15-0.1557414-0.15-0.1557414-0.15-0.15
57515-0.16-0.1657515-0.16-0.1657515-0.16-0.1657515-0.16-0.1657515-0.16-0.1657515-0.16-0.16
57616-0.17-0.1757616-0.17-0.1757616-0.17-0.1757616-0.17-0.1757616-0.17-0.1757616-0.17-0.17
57717-0.18-0.1857717-0.18-0.1857717-0.18-0.1857717-0.18-0.1857717-0.18-0.1857717-0.18-0.18
57818-0.19-0.1957818-0.19-0.1957818-0.19-0.1957818-0.19-0.1957818-0.19-0.1957818-0.19-0.19
57919-0.2-0.257919-0.2-0.257919-0.2-0.257919-0.2-0.257919-0.2-0.257919-0.2-0.2
58020-0.21-0.2158020-0.21-0.2158020-0.21-0.2158020-0.21-0.2158020-0.21-0.2158020-0.21-0.21
58121-0.22-0.2258121-0.22-0.2258121-0.22-0.2258121-0.22-0.2258121-0.22-0.2258121-0.22-0.22
58222-0.23-0.2358222-0.23-0.2358222-0.23-0.2358222-0.23-0.2358222-0.23-0.2358222-0.23-0.23
58323-0.24-0.2458323-0.24-0.2458323-0.24-0.2458323-0.24-0.2458323-0.24-0.2458323-0.24-0.24
58424-0.25-0.2558424-0.25-0.2558424-0.25-0.2558424-0.25-0.2558424-0.25-0.2558424-0.25-0.25
58525-0.26-0.2658525-0.26-0.2658525-0.26-0.2658525-0.26-0.2658525-0.26-0.2658525-0.26-0.26
58626-0.27-0.2758626-0.27-0.2758626-0.27-0.2758626-0.27-0.2758626-0.27-0.2758626-0.27-0.27
58727-0.28-0.2858727-0.28-0.2858727-0.28-0.2858727-0.28-0.2858727-0.28-0.2858727-0.28-0.28
58828-0.29-0.2958828-0.29-0.2958828-0.29-0.2958828-0.29-0.2958828-0.29-0.2958828-0.29-0.29
58929-0.3-0.358929-0.3-0.358929-0.3-0.358929-0.3-0.358929-0.3-0.358929-0.3-0.3
59030-0.31-0.3159030-0.31-0.3159030-0.31-0.3159030-0.31-0.3159030-0.31-0.3159030-0.31-0.31
59131-0.32-0.3259131-0.32-0.3259131-0.32-0.3259131-0.32-0.3259131-0.32-0.3259131-0.32-0.32
59232-0.33-0.3359232-0.33-0.3359232-0.33-0.3359232-0.33-0.3359232-0.33-0.3359232-0.33-0.33
59333-0.34-0.3459333-0.34-0.3459333-0.34-0.3459333-0.34-0.3459333-0.34-0.3459333-0.34-0.34
59434-0.35-0.3559434-0.35-0.3559434-0.35-0.3559434-0.35-0.3559434-0.35-0.3559434-0.35-0.35
59535-0.36-0.3659535-0.36-0.3659535-0.36-0.3659535-0.36-0.3659535-0.36-0.3659535-0.36-0.36
59636-0.37-0.3759636-0.37-0.3759636-0.37-0.3759636-0.37-0.3759636-0.37-0.3759636-0.37-0.37
59737-0.38-0.3859737-0.38-0.3859737-0.38-0.3859737-0.38-0.3859737-0.38-0.3859737-0.38-0.38
59838-0.39-0.3959838-0.39-0.3959838-0.39-0.3959838-0.39-0.3959838-0.39-0.3959838-0.39-0.39
59939-0.4-0.459939-0.4-0.459939-0.4-0.459939-0.4-0.459939-0.4-0.459939-0.4-0.4
60040-0.41-0.4160040-0.41-0.4160040-0.41-0.4160040-0.41-0.4160040-0.41-0.4160040-0.41-0.41
60141-0.42-0.4260141-0.42-0.4260141-0.42-0.4260141-0.42-0.4260141-0.42-0.4260141-0.42-0.42
60242-0.43-0.4360242-0.43-0.4360242-0.43-0.4360242-0.43-0.4360242-0.43-0.4360242-0.43-0.43
60343-0.44-0.4460343-0.44-0.4460343-0.44-0.4460343-0.44-0.4460343-0.44-0.4460343-0.44-0.44
60444-0.45-0.4560444-0.45-0.4560444-0.45-0.4560444-0.45-0.4560444-0.45-0.4560444-0.45-0.45
60545-0.46-0.4660545-0.46-0.4660545-0.46-0.4660545-0.46-0.4660545-0.46-0.4660545-0.46-0.46
60646-0.47-0.4760646-0.47-0.4760646-0.47-0.4760646-0.47-0.4760646-0.47-0.4760646-0.47-0.47
60747-0.48-0.4860747-0.48-0.4860747-0.48-0.4860747-0.48-0.4860747-0.48-0.4860747-0.48-0.48
60848-0.49-0.4960848-0.49-0.4960848-0.49-0.4960848-0.49-0.4960848-0.49-0.4960848-0.49-0.49
60949-0.5-0.560949-0.5-0.560949-0.5-0.560949-0.5-0.560949-0.5-0.560949-0.5-0.5
61050-0.51-0.5161050-0.51-0.5161050-0.51-0.5161050-0.51-0.5161050-0.51-0.5161050-0.51-0.51
61151-0.52-0.5261151-0.52-0.5261151-0.52-0.5261151-0.52-0.5261151-0.52-0.5261151-0.52-0.52
61252-0.53-0.5361252-0.53-0.5361252-0.53-0.5361252-0.53-0.5361252-0.53-0.5361252-0.53-0.53
61353-0.54-0.5461353-0.54-0.5461353-0.54-0.5461353-0.54-0.5461353-0.54-0.5461353-0.54-0.54
61454-0.55-0.5561454-0.55-0.5561454-0.55-0.5561454-0.55-0.5561454-0.55-0.5561454-0.55-0.55
61555-0.56-0.5661555-0.56-0.5661555-0.56-0.5661555-0.56-0.5661555-0.56-0.5661555-0.56-0.56
61656-0.57-0.5761656-0.57-0.5761656-0.57-0.5761656-0.57-0.5761656-0.57-0.5761656-0.57-0.57
61757-0.58-0.5861757-0.58-0.5861757-0.58-0.5861757-0.58-0.5861757-0.58-0.5861757-0.58-0.58
61858-0.59-0.5961858-0.59-0.5961858-0.59-0.5961858-0.59-0.5961858-0.59-0.5961858-0.59-0.59
61959-0.6-0.661959-0.6-0.661959-0.6-0.661959-0.6-0.661959-0.6-0.661959-0.6-0.6
62060-0.615.662060-0.615.662060-0.615.662060-0.615.662060-0.615.662060-0.615.6

File details come from the government source that posted it. Updated .