Attachment 6_Cost_Proposal_Spreadsheet.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Naval Sea Logistics Center Readiness Based Sparing Services Federal contract opportunity
Solicitation number
N6572626R3000
Issued by
Department of the Navy Naval Sea Systems Command

About this file

This is a Cost Proposal Spreadsheet template for Solicitation No. N6572626R3000, a Naval Sea Logistics Center Readiness Based Sparing Services task order. The spreadsheet is designed for cost-plus-fixed-fee (CPFF) proposals covering a base period and four option years. Offerors must structure their pricing to include prime contractor direct labor costs organized by employee and labor category, indirect costs (overhead, fringe benefits, and G&A), subcontractor labor costs and fees, pass-through costs, other direct costs (ODCs), and fixed fee components. The template requires separate line items for prime contractor labor, subcontractor proposed costs and fees, prime contractor pass-through amounts, and any G&A adders to ODCs. Fee calculations are subject to SeaPort-e IDIQ contract limitations, with a maximum pass-through percentage of 8.0% and maximum fixed fee constraints based on prime contractor labor cost percentages. The spreadsheet includes a pass-through analysis section that differentiates between subcontractor proposed costs without fee and total pass-through amounts including prime offeror fee, with specific notation that prime offeror fees on subcontractor pricing are treated as fee elements rather than cost elements in Section B of the proposal. The template is formatted for electronic completion and requires offerors to input hours, rates, and amounts across all cost categories for the entire contract period and each individual option year.

View the file

Other files for this federal contract opportunity

Show all 18

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

Cost Proposal Spreadsheet

SOLICITATION NO. N6572626R3000 - ATTACHMENT 6
COST PROPOSAL SPREADSHEEET
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Total for All YearsBase PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Cost ElementsCompany Labor CategoryeCRAFT Labor CategoryHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Employee Name 1
Employee Name 2
Etc.
Total Direct Labor Cost
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost
COM
Total Prime Contractor Labor Cost
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1
Subcontractor 2
Etc.
Total proposed subcontractor labor cost and fee
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through

Total Labor Cost (Prime and Subcontractor Labor)

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor
Prime Contractor Fee for Subcontractor Labor *
Total Fee (for Prime and Subcontractor Labor)

Total Labor Cost Plus Fixed Fee (CPFF)

Other Direct Costs
Other Direct Costs (ODCs)
Any adders to ODCs such as G&A (cost only - no fee)
Total ODCs

Total CPFF all CLINs (Labor and ODCs)

Pass Through Analysis - Total for All YearsAmountPercent
Subcontractor proposed cost and fee
Pass Through Amount (not including fee)
Prime Contractor Fee for Subcontractor Labor *
Total Pass Through Amount (including fee)ERROR:#DIV/0!
Maximum Pass Through Allowed by SeaPort-e IDIQ Contract8.00%
Fee Analysis - Total for All YearsAmountPercent
Prime Contractor Labor Cost
Fixed Fee for Labor Performed by Prime ContractorERROR:#DIV/0!
Maximum Fixed Fee Allowed by SeaPort-e IDIQ Contract
* When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through as explained in the Section H Savings Clause of the MACs. In Section B, however, prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B.

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