Attachment_5_-_Cost_Summary_Format_Workbook.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
NR-1 LAND HAUL SERVICES Federal contract opportunity
Solicitation number
N4523A19R1310
Issued by
Department of the Navy Naval Sea Systems Command

About this file

Attachment 5 - Cost_Summary_Format_Workbook

View the file

Other files for this federal contract opportunity

Other files attached to NR-1 LAND HAUL SERVICES, newest first.
File Type Posted
NR1_contract_Hanford_Site_visit_Qs_032619_Final.docx DOCX document
Attachment_3_CONTRACTOR_PERFORMANCE_DATA_SHEET_FOR_PAST_PERFORMANCE.docx DOCX document
N4523A19R1310_Solicitation.docx DOCX document
Attachment_4_Contractor_Performance_Questionnaire.docx DOCX document

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 Summary

SOLICITATION NO. N00024-XX-R-XXXX - ATTACHMENT X
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:Key
PersonnelTotal for All YearsBase PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Cost ElementsLabor CategoryY / NHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Task 1
Employee Name 1
Employee Name 2
Etc.
Task 2
Employee Name 1
Employee Name 2
Etc.
Task 3
Employee Name 1
Employee Name 2
Etc.
Task 4
Employee Name 1
Employee Name 2
Etc.
Task 5
Employee Name 1
Employee Name 2
Etc.
Task 6
Employee Name 1
Employee Name 2
Etc.
Task 7
Employee Name 1
Employee Name 2
Etc.
Task 8
Employee Name 1
Employee Name 2
Etc.

Surge Tasks 1 - 8

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
Task 1
Subcontractor 1
Subcontractor 2
Etc.
Task 2
Subcontractor 1
Subcontractor 2
Etc.
Task 3
Subcontractor 1
Subcontractor 2
Etc.
Task 4
Subcontractor 1
Subcontractor 2
Etc.
Task 5
Subcontractor 1
Subcontractor 2
Etc.
Task 6
Subcontractor 1
Subcontractor 2
Etc.
Task 7
Subcontractor 1
Subcontractor 2
Etc.
Task 8
Subcontractor 1
Subcontractor 2
Etc.

Subcontractor Surge Tasks 1 - 6

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)

Fee
Prime Contractor Fee for Prime Contractor Labor
Target Incentive Fee
Prime Contractor Fee for Subcontractor Labor *
Target Incentive Fee
Total Fee (for Prime and Subcontractor Labor)
Target Incentive Fee
Total Labor Cost Plus Target Fee
Any adders to ODCs such as G&A (cost only - no fee)
Total ODCs

Total 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%

* 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.

Supporting Cost Data Summary

SUPPORTING COST DATA

Direct Labor:Actual Current Labor RateProposed Base Period Labor RateReason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCAA recommended rates, if known.
Employee Name$$
Employee Name$$
Employee Name$$
Indirect Rates:Current RateProposed Base RateSubject to FPRA? (Yes/No) Reason for difference between current rates and proposed rates. Reason for difference between proposed rates and DCAA recommended rates, if known.
Fringe
Overhead
G&A
Other

Additional brief narrative in accordance with Section L, Section 4.4, Supporting Cost Data.

Indirect Rate Support Sample Indirect Rate Supporting Documentation

BudgetActual Expenses
Overhead Expense2011201020092008
Payroll Taxes$ 110,000$ 93,000$ 90,000$ 85,000
Vacation$ 50,000$ 46,000$ 43,000$ 42,000
Holiday$ 40,000$ 40,000$ 39,000$ 38,500
Sick Leave$ 10,000$ 9,000$ 8,000$ 7,000
Pensions$ 200,000$ 175,000$ 165,000$ 155,000
Office Equipment$ 5,000$ 6,000$ 65,000$ 3,000
Depreciation$ 4,000$ 1,000$ 4,000$ 2,000
Travel$ 40,000$ 35,000$ 33,000$ 33,000
Reproduction$ 10,000$ 9,800$ 9,700$ 9,600
Rent$ 130,000$ 82,000$ 75,000$ 68,000
Advertising$ 55,000$ 44,000$ 50,000$ 42,000
Insurance$ 48,000$ 46,000$ 44,000$ 42,000
Telephone$ 12,000$ 12,000$ 11,500$ 10,000
Total Pool$ 714,000$ 598,800$ 637,200$ 537,100
Less Unallowable Costs
Entertainment$ 6,000$ 4,000$ 1,000$ 3,000
Net Allowable Costs$ 708,000$ 594,800$ 636,200$ 534,100
Allocation Base
Direct Labor$ 1,895,500$ 1,756,200$ 1,650,000$ 1,530,000

Overhead Rate 37.35% 33.87% 38.56% 34.91%

*Contributing Government ContractsExpiration DateValue of Contracts
N000XX-XX-X-00XX6/1/11
N000XX-XX-X-00XX9/1/12
N000XX-XX-X-00XX8/1/10
* When developing your percentage, these are the contracts contributing
to development of the percentage.

File details come from the government source that posted it.