Attachment 1 Cost Summary Report.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
NSWCPD Navy Slewing Arm Davits (SLADs) Supply and Services Solicitation No. N6449820R4016
Solicitation number
19NE023
Issued by

View the file

Other files

File Type Posted
Attachment 3_Navy Standard SLAD Drawings.pdf PDF
N6449819R40160004 4.21.docx DOCX document
N6449820R40160003 4.10.20.pdf PDF
N6449820R40160002 4.8.20.pdf PDF
Exhibit A_CDRLS.pdf PDF
N6449820R40160001.pdf PDF
Exhibit A_CDRLS.pdf PDF
N6449820R4016 Finalized RFP 3.19.20.pdf PDF
Attachment 2_LaborRateSubstantiationTable.xls XLS spreadsheet
Attachment 3_Navy Standard SLAD Drawings.pdf PDF

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.

CPFF

SOLICITATION NO. N00024-0X-R-XXXX - ATTACHMENT 1
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Total for All YearsBase PeriodYear 2Year 3Year 4Year 5
Cost ElementsLabor 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.

eCRAFT Fully Burdened Rates The contractor shall provide the Fully Burdened Bid Rates for all proposed personnel. The sum of the total dollars must reconcile to the 'Total Labor Cost Plus Fixed Fee (CPFF)' for "All Years" as proposed in the Cost Summary Worksheet tab.

Column Descriptions are provided below: (All data provided below must be consistent with data contained in the Cost Summary Worksheet tab)
ECRAFT Labor Category Code: List eCRAFT labor category code, if known
Labor Category Description: List eCRAFT Labor Category Description
Employee Name: List employee name or "TBD" if unknown
Company: Prime Company Name or Subcontractor Company Name
Location and Pay Type: A location and pay type must be indicated for each labor category. For Straight time hours, location is indicated as either Contractor site (KR-SITE) or Government site (GOVT-SITE). For Overtime Hours, location is indicated as either Contrator Site (K-OT) or Government site (G-OT).
Hours: List the total hours for each labor category for the life of the contract
Average Fully Burdened Labor Rate: Defined as direct labor PLUS all applicable indirects PLUS fee encompassing the entire period of performance of the contract
Dollars: Hours TIMES Fully Burdened Labor Rate
Average Rate for All Years
eCRAFT Labor Category CodeeCRAFT Labor Category DescriptionEmployee NameCompanyLocation and Pay TypeHoursAverage Fully Burdened Labor RateDollars
$ - 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
$ - 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
Total Labor Cost Plus Fixed Fee (CPFF)0$ - 0

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