J7 Cost Summary Format.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Iridium Satellite Communications Federal contract opportunity
Solicitation number
N0017821R4400
Issued by
Department of the Navy Naval Sea Systems Command

About this file

This document contains a cost summary template and details of a related federal contract opportunity. The cost summary template outlines the required format for proposing labor, other direct costs, fee, and pass-through costs. It includes sections for direct and indirect labor rates by individual, subcontractor costs, fee calculations, other direct costs, and supporting cost data documentation.

The related federal contract opportunity is a solicitation from the Department of the Navy Naval Sea Systems Command to provide ongoing operations and maintenance support for Iridium satellite communications services including the Geographic Broadcast Controller, Location Server, and virtual private network. It also requires assisting in the development of new end user devices, services like Global Data Broadcast, and integration of devices utilizing Short Burst Data and Global Data Broadcast enabled modems. The contractor will evaluate potential netted and broadcast communications architectures and recommend implementations to improve performance parameters like global range, capacity, resilience, and network management.

View the file

Other files for this federal contract opportunity

Other files attached to Iridium Satellite Communications, newest first.
File Type Posted
N0017821R4400 Amendment 10 Conformed Copy.pdf PDF
N0017821R4400 P9 conformed copy.pdf PDF
N0017821R4400 P8.pdf PDF
N0017821R4400 P7 RFP.pdf PDF
RFP N0017821R4400 P6.pdf PDF
N0017821R4400 P5 .pdf PDF
N0017821R4400 Amendment 4.pdf PDF
N0017821R4400 Amendment 3.pdf PDF
DD254 Attachment J.1 Rev 1.pdf PDF
N0017821R4400 Amendment 02.pdf PDF
N0017821R4400 Revision 1.pdf PDF
J5 GFP.xlsx XLSX spreadsheet
J2 QASP.pdf PDF
Exhibit A CDRLs.pdf PDF
J1 DD254.pdf PDF
J4 Key Labor Quals.pdf PDF
N0017821R4400 RFP.pdf PDF
J6 Ecraft Crosswalk.xlsx XLSX spreadsheet
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

CPFF Cost Summary

SOLICITATION NO. N00178-21-R-4400ATTACHMENT J.7
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
KEY?Total for All YearsBase PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Cost ElementsLabor CategoryY / NHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
LABOR CLINs
Prime Contractor Direct Labor Cost
Employee Name 1
Employee Name 2
Labor Category Average Rate per Year
Etc.
Total Direct Labor Cost
Prime Contractor Indirect Labor Cost
Fringe Benefits
Overhead
G&A
Total Indirect Labor Cost
Total Prime Direct and Indirect Labor Cost
FCCM
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)
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
OTHER DIRECT COSTS (ODC) CLINs
Prime Contractor ODC
Travel
ODC
Subtotal ODC
Prime Burdens on ODC
Material Handling
G&A
Other (Specify each separately)
Subtotal Burden on Prime ODCs
Subcontractor ODC
Travel
Subcontractor 1
Subcontractor 2
Etc.
Subtotal Subcontractor Travel
ODC
Subcontractor 1
Subcontractor 2
Etc.
Subtotal Subcontractor ODC
Total Subcontractor Travel and ODC
Prime Burdens on Subcontractor ODC
Material Handling
G&A
Other (Specify each separately)
Subtotal Prime Burden on Subcontractor ODC
TOTAL TRAVEL AND ODC CLINS
TOTAL ALL CLINS (LABOR AND ODC)
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 RateEffective Date of Current 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 (list)

Indirect Rate Support Sample Indirect Rate Supporting Documentation

BudgetPRIOR YEAR ACTUALS
Overhead ExpenseYear (BY)BY - 1BY - 2BY - 3
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. Updated .