Attachment B_Cost and Price Proposal Workbook Template Example.xlsx

XLSX spreadsheet 45 KB Posted

Attached to
Space-to-Space (S2S) Communication Broad Agency Announcement (BAA)
Solicitation number
FA8819-25-R-B006
Issued by

About this file

This document is a Cost and Price Proposal Workbook Template for a federal contract opportunity, specifically for the Space-to-Space (S2S) Communication Broad Agency Announcement (BAA). The template provides detailed instructions for contractors to complete comprehensive cost and pricing information across multiple worksheets, including historical and proposed indirect rates, element of cost summaries, subcontractor value breakdowns, and labor cost buildups for the base period and four option periods.

The template requires offerors to provide granular financial details such as direct labor rates, fully burdened labor rates, escalation factors, indirect rate calculations, and total estimated costs for each Contract Line Item Number (CLIN). The workbook is designed to capture a complete financial picture of proposed work, including labor hours, extended values, fixed fee percentages, and total estimated costs across different performance periods. It is specifically tailored for the Space Systems Command's Space Combat Power Program Executive Office, which is seeking technology advancements in proliferated low Earth orbit (pLEO) for Space-to-Space Communications.

View the file

Other files

Show all 11

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

COST PRICE SUMMARY

Instructions: The offeror shall indicate the cost/price to be charged for each CLIN rounded to the nearest whole dollar.
(INSERT CONTRACT TYPE) CLIN(s)(INSERT CONTRACT TYPE) CLIN(s)
CLINDescriptionCost/PriceFixed Fee (if applicable)Total PriceCLINGFY 2026GFY 2027GFY 2028GFY 2029GFY 2030
0100Base (Includes all elements of cost - Labor, Material, ODC, Indirects, Fee, etc.)000XTotal Funding RequiredTotal Funding RequiredTotal Funding RequiredTotal Funding RequiredTotal Funding Required
1001Option 1
1002Option 2

GRAND TOTAL CEILING ALL CLINs: $________________

SUMMARY INDIRECT RATES

Instructions: The below table shall be completed for contractors that do NOT have DCMA approved/recommended rates AND are proposing a CPFF/CR type contract.

For each indirect rate element used in development of the estimated cost/price, provide the actual historical rates realized from 2020 through 2024, including the actual historical amounts for the applicable Pool and Base. Additionally, provide the actual historical amounts realized for Revenue and Total Direct Labor for the applicable cost center.

HISTORICAL INDIRECT RATES
Historical Period20202021202220232024
Revenue[insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized]
Total Direct Labor[insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized]
[Insert Indirect Rate Element]Pool[insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized]
Base[insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized]
Rate[ Pool / Base in %][ Pool / Base in %][ Pool / Base in %][ Pool / Base in %][ Pool / Base in %]
[Insert Indirect Rate Element]Pool[insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized]
Base[insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized][insert applicable $ amount realized]
Rate[ Pool / Base in %][ Pool / Base in %][ Pool / Base in %][ Pool / Base in %][ Pool / Base in %]
[Insert additional rows for each Historical Indirect Rate Element ]

Instructions: For each indirect rate element used in development of the estimated cost/price, provide the Proposed Indirect Rate for each period.

All costs shall be fully supported by the narrative in the Cost/Price Supporting Documentation.

PROPOSED INDIRECT RATES
Period of PerformanceBase PeriodFirst Option PeriodSecond Option PeriodThird Option PeriodFourth Option Period
[Insert Proposed Rate Element][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period]
[Insert Proposed Rate Element][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period]
[Insert additional rows, as needed][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period][insert proposed rate % for period]

&G &G

&"Times New Roman,Italic"&10 FEDSIM is a Client Support Center housed within GSA, FAS, AAS

ELEMENT OF COST SUMMARY

Instructions: For contractors that are proposing a CPFF/CR type contract provide a summary total for each element of cost (e.g., direct labor, overhead, fringe, General and Administrative (G&A), Facilities Capital Cost of Money (FCCM), fee, etc.). For contractors proposing FFP type contract, complete the appropriate columns which must include the Total Price column.
SUPPLIES OR SERVICES AND PRICES/COSTS
CLINDirect Labor DollarsLabor OverheadSubcontract DollarsMaterialMaterial HandlingODCG&AFringeFCCMTotal CostFeeTotal Price
000X$ - 0$ - 0
000X$ - 0$ - 0
000X$ - 0$ - 0
000X$ - 0$ - 0
Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

&G &G

FEDSIM is a Client Support Center housed within GSA, FAS, AAS

SUBCONTRACTOR VALUE

This is an optional worksheet that may be included or deleted depending on the Request for Quotation (RFQ).

Tailor the tasks and period of performance (i.e., Base and Option Periods) to match the RFQ/RFP.

Tailor Orange text to match the RFQ/RFP.

Instructions: In accordance with the RFP, provide the proposed contract type of each subcontract, a breakdown of the total cost by task, and the total value of each proposed subcontract.

Insert additional columns, as needed, to include all proposed Subcontractors.

Total Price
$ - 0
SUBCONTRACTOR SUPPORTING DOCUMENTATION
(Subcontractor Name)(Subcontractor Name)(Subcontractor Name)(Subcontractor Name)(Subcontractor Name)(Subcontractor Name)(Subcontractor Name)(Subcontractor Name)(Subcontractor Name)
(Proposed Contract Type)(Proposed Contract Type)(Proposed Contract Type)(Proposed Contract Type)(Proposed Contract Type)(Proposed Contract Type)(Proposed Contract Type)(Proposed Contract Type)(Proposed Contract Type)
BASE PERIODTotal Price
TASK 1$ - 0
TASK 2$ - 0
TASK 3$ - 0
TASK 4$ - 0
Base Period Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
FIRST OPTION PERIOD
TASK 1$ - 0
TASK 2$ - 0
TASK 3$ - 0
TASK 4$ - 0
First Option Period Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SECOND OPTION PERIOD
TASK 1$ - 0
TASK 2$ - 0
TASK 3$ - 0
TASK 4$ - 0
Second Option Period Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
THIRD OPTION PERIOD
TASK 1$ - 0
TASK 2$ - 0
TASK 3$ - 0
TASK 4$ - 0
Third Option Period Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
FOURTH OPTION PERIOD
TASK 1$ - 0
TASK 2$ - 0
TASK 3$ - 0
TASK 4$ - 0
Fourth Option Period Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL PROPOSED SUBCONTRACT VALUE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
% OF TOTAL CONTRACT VALUEERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

&G &G

FEDSIM is a Client Support Center housed within GSA, FAS, AAS

LABOR CLIN SUMMARY

Instructions: Use this table to summarize the Total Hours, Total Estimated Cost, Fixed Fee Amount, and Total Estimated Cost-Plus-Fixed-Fee (CPFF) for each CPFF task.

This table includes the total amounts for Labor CLINs 000X.

LABOR CLIN SUMMARY

X001

Task Total hours Total Estimated Cost Fixed Fee Amount Total Estimated Cost-Plus-Fixed-Fee

(CFFF)

Base Period
1Insert total hours per task area for labor.Insert proposed total estimated cost per task area for labor.Insert proposed total Fixed Fee Amount.Insert proposed total estimated CPFF for labor.

(Sum of Columns C and D)

2$ - 0
3$ - 0
4$ - 0
Insert or delete rows, as appropriate, depending on the number of Task Areas identified in your Offeror developed Performance Work Statement.
Labor Total:0$ - 0$ - 0$ - 0
First Option Period
1Insert total hours per task area for labor.Insert proposed total estimated cost per task area for labor.Insert proposed total Fixed Fee Amount.Insert proposed total estimated

CPFF for labor.

(Sum of Columns C and D)

2$ - 0
3$ - 0
4$ - 0
Insert or delete rows, as appropriate, depending on the number of Task Areas identified in your Offeror developed Performance Work Statement.
Labor Total:0$ - 0$ - 0$ - 0
Second Option Period
1Insert total hours per task area for labor.Insert proposed total estimated cost per task area for labor.Insert proposed total Fixed Fee Amount.Insert proposed total estimated

CPFF for labor.

(Sum of Columns C and D)

2$ - 0
3$ - 0
4$ - 0
Insert or delete rows, as appropriate, depending on the number of Task Areas identified in your Offeror developed Performance Work Statement.
Labor Total:0$ - 0$ - 0$ - 0
Third Option Period
1Insert total hours per task area for labor.Insert proposed total estimated cost per task area for labor.Insert proposed total Fixed Fee Amount.Insert proposed total estimated

CPFF for labor.

(Sum of Columns C and D)

2$ - 0
3$ - 0
4$ - 0
Insert or delete rows, as appropriate, depending on the number of Task Areas identified in your Offeror developed Performance Work Statement.
Labor Total:0$ - 0$ - 0$ - 0
Fourth Option Period
1Insert total hours per task area for labor.Insert proposed total estimated cost per task area for labor.Insert proposed total Fixed Fee Amount.Insert proposed total estimated

CPFF for labor.

(Sum of Columns C and D)

2$ - 0
3$ - 0
4$ - 0
Insert or delete rows, as appropriate, depending on the number of Task Areas identified in your Offeror developed Performance Work Statement.
Labor Total:0$ - 0$ - 0$ - 0

Number of hours in an FTE:

&G &G

FEDSIM is a Client Support Center housed within GSA, FAS, AAS

CLIN0100 Labor Buildup

Instructions: Use the table below to clearly provide the full buildup of estimated cost/price for labor CLIN 0001. Cleary identify all applicable rates and percent and dollar amount additions. Clearly demonstrate how the Base Rate progresses to the Fully Burdened Rate. Insert additional rows as needed to fully demonstrate the buildup of estimated cost/ price. Include applicable subtotal amounts as indicated.
CLIN 0100 - Direct Labor (Tasks 1-X (insert all labor tasks))
Base Period
NameEmployee IDLabor CategoryLabor CodeCorporate Labor CategoryCorporate Labor CodeSOC ID CodeKey PersonnelPrime Contractor or Subcontractor?Applicable Indirect
Rate Cost CenterProposed Direct
Labor RateExempt or
Non-ExemptBase Rate ($)Escalation Factor (%),
if applicablePeriod Direct
Labor Rate ($)Rate Element
Percent Buildup (%)Rate Element
Dollar Buildup ($)Rate Buildup (Direct Labor plus all applicable loads)Proposed Fully Burdened Labor RateTotal hours for Task 1Total hours for Task 2Total hours for Task X (insert Task number and add or delete columns as needed.)Total CLIN HoursExtended ValueFixed Fee Percentage (%)Fixed Fee
Amount ($)Total Estimated CostNotes
Insert name of proposed personInsert Corporate Employee ID if applicableInsert applicable labor categories below.

Author: To edit this cell simultaneously on all Task worksheets (e.g., CLIN 0001 - Task X, CLIN 0002 - Task X, CLIN 0003 - Task X, CLIN 0004 - Task X), see the Excel Tips on the Instructions tab.

Insert applicable Labor CodeInsert applicable Corporate Labor CategoryInsert applicable Corporate Labor CodeInsert applicable Standard Occupancy Classification (SOC) Labor ID CodeIndicate whether this is a Key Personnel.
(Yes/No)Insert the name of the company this individual works for.Insert the applicable indirect rate cost center.Insert the proposed direct labor rate.Insert whether the individual is determined as Exempt or Non-ExemptInsert, in dollars, the base, unescalated direct labor rate for this labor categoryInsert any proposed escalation rate for the period.Insert the Direct Labor rate with applicable escalation.Insert, in percent terms, the buildup of rate elementsInsert, in dollar terms, the buildup of rate elementsThe offeror shall insert new columns as appropriate to completely show all applicable loads and the cost buildup. The offeror shall ensure all loads are clearly labeled. It shall be clear how the offeror progressed from the Proposed Direct Labor Rate to the Proposed Fully Burdened Rate.Insert the proposed fully burdened labor rate.Insert total hours.Insert total hours.Insert total hours.Insert total CLIN hoursERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
Insert additional rows as needed0$ - 0$ - 0$ - 0
Total hours for Tasks 1-X, Total Extended Value for Tasks 1-X, Fixed Fee, and Total Estimated Cost:Insert Total Hours for Task 1Insert Total Hours for Task 2Insert Total Hours for Task X (insert Task number)Insert Total Hours for this CLINInsert Total Extended ValueInsert Fixed Fee PercentageInsert Fixed Fee Amount for this CLINInsert Total Extended Value plus Fixed Fee Amount for this CLIN

&G &G

FEDSIM is a Client Support Center housed within GSA, FAS, AAS

CLIN 1001 - Labor

Instructions: Use the table below to clearly provide the full buildup of estimated cost/price for labor CLIN 1001. Cleary identify all applicable rates and percent and dollar amount additions. Clearly demonstrate how the Base Rate progresses to the Fully Burdened Rate. Insert additional rows as needed to fully demonstrate the buildup of estimated cost/ price. Include applicable subtotal amounts as indicated.
CLIN 1001 - Direct Labor (Tasks 1-X (insert all labor tasks))
First Option Period
NameEmployee IDLabor CategoryLabor CodeCorporate Labor CategoryCorporate Labor CodeSOC ID CodeKey PersonnelPrime Contractor or Subcontractor?Applicable Indirect Rate Cost CenterProposed Direct Labor RateExempt or
Non-ExemptBase Rate ($)Escalation Factor (%),
if applicablePeriod Direct
Labor Rate ($)Rate Element
Percent Buildup (%)Rate Element
Dollar Buildup ($)Rate Buildup (Direct Labor plus all applicable loads)Proposed Fully Burdened Labor RateTotal hours for Task 1Total hours for Task 2Total hours for Task X (insert Task number and add or delete columns as needed.)Total CLIN HoursExtended ValueFixed Fee Percentage (%)Fixed Fee
Amount ($)Total Estimated CostNotes
Insert name of proposed personInsert Corporate Employee ID if applicableInsert applicable labor categories below.Insert applicable Labor CodeInsert applicable Corporate Labor CategoryInsert applicable Corporate Labor CodeInsert applicable Standard Occupancy Classification (SOC) Labor ID CodeIndicate whether this is a Key Personnel.
(Yes/No)Insert the name of the company this individual works for.Insert the applicable indirect rate cost center.Insert the proposed direct labor rate.Insert whether the individual is determined as Exempt or Non-ExemptInsert, in dollars, the base, unescalated direct labor rate for this labor categoryInsert any proposed escalation rate for the period.Insert the Direct Labor rate with applicable escalation.Insert, in percent terms, the buildup of rate elementsInsert, in dollar terms, the buildup of rate elementsThe offeror shall insert new columns as appropriate to completely show all applicable loads and the cost buildup. The offeror shall ensure all loads are clearly labeled. It shall be clear how the offeror progressed from the Proposed Direct Labor Rate to the Proposed Fully Burdened Rate.Insert the proposed fully burdened labor rate.Insert total hours.Insert total hours.Insert total hours.Insert total CLIN hoursERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
Insert additional rows as needed0$ - 0$ - 0$ - 0
Total hours for Tasks 1-X, Total Extended Value for Tasks 1-X, Fixed Fee, and Total Estimated Cost:Insert Total Hours for Task 1Insert Total Hours for Task 2Insert Total Hours for Task X (insert Task number)Insert Total Hours for this CLINInsert Total Extended ValueInsert Fixed Fee PercentageInsert Fixed Fee Amount for this CLINInsert Total Extended Value plus Fixed Fee Amount for this CLIN

&G &G

FEDSIM is a Client Support Center housed within GSA, FAS, AAS

CLIN 1002 - Labor

Instructions: Use the table below to clearly provide the full buildup of estimated cost/price for labor CLIN 2001. Cleary identify all applicable rates and percent and dollar amount additions. Clearly demonstrate how the Base Rate progresses to the Fully Burdened Rate. Insert additional rows as needed to fully demonstrate the buildup of estimated cost/ price. Include applicable subtotal amounts as indicated.
CLIN 1002 - Direct Labor (Tasks 1-X (insert all labor tasks))
Second Option Period
NameEmployee IDLabor CategoryLabor CodeCorporate Labor CategoryCorporate Labor CodeSOC ID CodeKey PersonnelPrime Contractor or Subcontractor?Applicable Indirect Rate Cost CenterProposed Direct Labor RateExempt or
Non-ExemptBase Rate ($)Escalation Factor (%),
if applicablePeriod Direct
Labor Rate ($)Rate Element
Percent Buildup (%)Rate Element
Dollar Buildup ($)Rate Buildup (Direct Labor plus all applicable loads)Proposed Fully Burdened Labor RateTotal hours for Task 1Total hours for Task 2Total hours for Task X (insert Task number and add or delete columns as needed.)Total CLIN HoursExtended ValueFixed Fee Percentage (%)Fixed Fee
Amount ($)Total Estimated CostNotes
Insert name of proposed personInsert Corporate Employee ID if applicableInsert applicable labor categories below.Insert applicable Labor CodeInsert applicable Corporate Labor CategoryInsert applicable Corporate Labor CodeInsert applicable Standard Occupancy Classification (SOC) Labor ID CodeIndicate whether this is a Key Personnel.
(Yes/No)Insert the name of the company this individual works for.Insert the applicable indirect rate cost center.Insert the proposed direct labor rate.Insert whether the individual is determined as Exempt or Non-ExemptInsert, in dollars, the base, unescalated direct labor rate for this labor categoryInsert any proposed escalation rate for the period.Insert the Direct Labor rate with applicable escalation.Insert, in percent terms, the buildup of rate elementsInsert, in dollar terms, the buildup of rate elementsThe offeror shall insert new columns as appropriate to completely show all applicable loads and the cost buildup. The offeror shall ensure all loads are clearly labeled. It shall be clear how the offeror progressed from the Proposed Direct Labor Rate to the Proposed Fully Burdened Rate.Insert the proposed fully burdened labor rate.Insert total hours.Insert total hours.Insert total hours.Insert total CLIN hoursERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
0$ - 0$ - 0$ - 0
Insert additional rows as needed0$ - 0$ - 0$ - 0
Total hours for Tasks 1-X, Total Extended Value for Tasks 1-X, Fixed Fee, and Total Estimated Cost:Insert Total Hours for Task 1Insert Total Hours for Task 2Insert Total Hours for Task X (insert Task number)Insert Total Hours for this CLINInsert Total Extended ValueInsert Fixed Fee PercentageInsert Fixed Fee Amount for this CLINInsert Total Extended Value plus Fixed Fee Amount for this CLIN

&G &G

FEDSIM is a Client Support Center housed within GSA, FAS, AAS

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