Attachment_JS-3_Cost_Spreadsheet_25R0001_Conformed Amend 0001.xlsx

XLSX spreadsheet 68 KB Posted

Attached to
Common Processing System (CPS) Sustainment, Installation, Procurement, and Engineering Services
Solicitation number
N6339425R0001
Issued by

About this file

This document is a cost spreadsheet attachment related to a federal contract opportunity. It contains detailed pricing information for the following contract line items:

FFP Materials: This section contains pricing information for various commercial off-the-shelf hardware items such as 64GB RAM parts and 2TB M.2 SSDs, with pre-priced unit costs and evaluated quantities for a 5-year IDIQ contract period.

CPFF Materials: This section includes pricing for cost-plus-fixed-fee (CPFF) materials to be provided under the first task order, with a total estimated value of $11,000,000.

CPFF Labor: This section contains labor categories, hourly rates, and estimated hours for the prime contractor and subcontractor labor to be provided under the first task order.

Cost-Only ODCs: This section covers estimated other direct costs, such as travel and material, for the IDIQ contract and first task order, with a total estimated value of $3,500,000.

The related federal contract opportunity is for Common Processing System (CPS) Sustainment, Installation, Procurement, and Engineering Services, solicited by the Naval Sea Systems Command. The anticipated performance period is 5 years, with the first ordering period starting in April 2025. The solicitation is open to unrestricted competition.

View the file

Other files

Show all 22

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

FFP Materials

SOLICITATION NO. N6339425R0001 ATTACHMENT JS-3Effective Date:
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Indirect Cost Burden 1:Indirect Cost Burden 2:Indirect Cost Burden 3:Facilities Capital Cost of Money Burden 1:Facilities Capital Cost of Money Burden 1:Profit
Cost ElementsAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountTotal PriceBurden Factor
FFP Materials
FFP Materials
CLIN 1000 (IDIQ Contract Year 1)$ 9,000,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 9,000,0001.0000
CLIN 1000 (IDIQ Contract Year 2)$ 9,000,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 9,000,0001.0000
CLIN 1000 (IDIQ Contract Year 3)$ 9,000,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 9,000,0001.0000
CLIN 1000 (IDIQ Contract Year 4)$ 9,000,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 9,000,0001.0000
CLIN 1000 (IDIQ Contract Year 5)$ 9,000,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 9,000,0001.0000

Total FFP Materials $ 45,000,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 45,000,000

Offerors may add additional columns to account for the application of additional burdens. Pricing shall be derived from left to right with the far left side including the direct costs and the far right including the direct cost following application of all profit and burdens. Please ensure working formulas. Amounts shall be in whole numbers. The burden factors in Column V will be incorporated into the resulting contract.

FFP Materials Pre-Priced Parts

SOLICITATION NO. N6339425R0001 ATTACHMENT JS-3
Effective Date:
Prime Offeror Name:
CLIN 1001 - 64GB RAM Part (amp inc. PN: AMP99M67)CLIN 1001 - Evaluated Quantities for 64GB RAM Part
(amp inc. PN: AMP99M67)CLIN 1001 - TEP for 64GB RAM Part

(amp inc. PN: AMP99M67)

PeriodStepladder QuantityPeriodStepladder QuantityPeriodEvaluated Price
1 – 910 – 4950 – 99100 – 249250+1 – 910 – 4950 – 99100 – 249250+
IDIQ Contract Year 1$1.00$1.00$1.00$1.00$1.00IDIQ Contract Year 1 (Total Quantity 499)94050150250IDIQ Contract Year 1$499.00
IDIQ Contract Year 2$1.00$1.00$1.00$1.00$1.00IDIQ Contract Year 2 (Total Quantity 499)94050150250IDIQ Contract Year 2$499.00
IDIQ Contract Year 3$1.00$1.00$1.00$1.00$1.00IDIQ Contract Year 3 (Total Quantity 499)94050150250IDIQ Contract Year 3$499.00
IDIQ Contract Year 4$1.00$1.00$1.00$1.00$1.00IDIQ Contract Year 4 (Total Quantity 499)94050150250IDIQ Contract Year 4$499.00
IDIQ Contract Year 5$1.00$1.00$1.00$1.00$1.00IDIQ Contract Year 5 (Total Quantity 499)94050150250IDIQ Contract Year 5$499.00
Total Over Five Years
(Total Quantity 2,495)452002507501250Total Evaluated Price (TEP)$2,495.00
CLIN 1002 - 2TB M.2 SSD Part
(Transcend Information Inc. PN: TS2TMTS952T2)CLIN 1002 - Evaluated Quantities for 2TB M.2 SSD Part
(Transcend Information Inc. PN: TS2TMTS952T2)CLIN 1002 - TEP for 2TB M.2 SSD Part

(Transcend Information Inc. PN: TS2TMTS952T2)

PeriodStepladder QuantityPeriodStepladder QuantityPeriodEvaluated Price
1 – 910 – 2425 – 4950+1 – 910 – 2425 – 4950+
IDIQ Contract Year 1$1.00$1.00$1.00$1.00IDIQ Contract Year 1 (Total Quantity 99)9152550IDIQ Contract Year 1$99.00
IDIQ Contract Year 2$1.00$1.00$1.00$1.00IDIQ Contract Year 2 (Total Quantity 99)9152550IDIQ Contract Year 2$99.00
IDIQ Contract Year 3$1.00$1.00$1.00$1.00IDIQ Contract Year 3 (Total Quantity 99)9152550IDIQ Contract Year 3$99.00
IDIQ Contract Year 4$1.00$1.00$1.00$1.00IDIQ Contract Year 4 (Total Quantity 99)9152550IDIQ Contract Year 4$99.00
IDIQ Contract Year 5$1.00$1.00$1.00$1.00IDIQ Contract Year 5 (Total Quantity 99)9152550IDIQ Contract Year 5$99.00
Total Over Five Years
(Total Quantity 495)4575125250TEP$495.00
CLIN 1003 - 2TB M.2 SSD Part
(Transcend Information Inc. PN: TS2TMTS970T)CLIN 1003 - Evaluated Quantities for 2TB M.2 SSD Part
(Transcend Information Inc. PN: TS2TMTS970T)CLIN 1003 - TEP for 2TB M.2 SSD Part

(Transcend Information Inc. PN: TS2TMTS970T)

PeriodStepladder QuantityPeriodStepladder QuantityPeriodEvaluated Price
1 – 910 – 2425 – 4950+1 – 910 – 2425 – 4950+
IDIQ Contract Year 1$1.00$1.00$1.00$1.00IDIQ Contract Year 1 (Total Quantity 99)9152550IDIQ Contract Year 1$99.00
IDIQ Contract Year 2$1.00$1.00$1.00$1.00IDIQ Contract Year 2 (Total Quantity 99)9152550IDIQ Contract Year 2$99.00
IDIQ Contract Year 3$1.00$1.00$1.00$1.00IDIQ Contract Year 3 (Total Quantity 99)9152550IDIQ Contract Year 3$99.00
IDIQ Contract Year 4$1.00$1.00$1.00$1.00IDIQ Contract Year 4 (Total Quantity 99)9152550IDIQ Contract Year 4$99.00
IDIQ Contract Year 5$1.00$1.00$1.00$1.00IDIQ Contract Year 5 (Total Quantity 99)9152550IDIQ Contract Year 5$99.00
Total Over Five Years
(Total Quantity 495)4575125250TEP$495.00

Pre-Priced Part TEP $3,485.00

The Offeror shall populate its proposed unit prices in the green cells. The proposed unit prices shall include any direct labor to procure and manage the procurement of the part, applicable indirect costs, and if proposed, FCCOM and profit. The evaluated quantities and TEP cells calculate automatically and should not be adjusted. The evaluated quantities are being provided for proposal and evaluation purposes only. Actual quantities ordered under the resulting contract will depend on the Government's need and availability of funding.

CPFF Materials

SOLICITATION NO. N6339425R0001 ATTACHMENT JS-3Effective Date:
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Indirect Cost Burden 1:Indirect Cost Burden 2:Indirect Cost Burden 3:Facilities Capital Cost of Money Burden 1:Facilities Capital Cost of Money Burden 1:Fixed Fee
Cost ElementsAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountTotal Price
CPFF Materials
CPFF Materials
CLIN 3000 (First TO Base Period)$ 2,200,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 2,200,000
CLIN 3100 (First TO Option Period 1)$ 2,200,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 2,200,000
CLIN 3200 (First TO Option Period 2)$ 2,200,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 2,200,000
CLIN 3300 (First TO Option Period 3)$ 2,200,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 2,200,000
CLIN 3400 (First TO Option Period 4)$ 2,200,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 2,200,000

Total CPFF Materials $ 11,000,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 11,000,000

Offerors may add additional columns to account for the application of additional burdens. Pricing shall be derived from left to right with the far left side including the direct costs and the far right including the direct cost following application of all fees and burdens. The maximum fixed fee rate is 4.0%. Please ensure working formulas.

CLINs 3000, 3100, 3200, 3300, and 3400 will be included in the first task order (TO) which will be awarded concurrently with the base IDIQ contract.

CPFF Labor

SOLICITATION NO. N6339425R0001 ATTACHMENT JS-3Effective Date:
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Direct CostsIndirect Cost Burden 1:Indirect Cost Burden 2:Indirect Cost Burden 3:Indirect Cost Burden 4:Fixed Fee:Facilities Capital Cost of Money Burden 1:Facilities Capital Cost of Money Burden 2:
Cost ElementsLabor CategoryBase RateRateHoursAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountEstimated Cost Plus Fixed Fee
Prime Contractor Labor Cost
Prime Contractor Labor
Item 4000 (First TO Base Period)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4100 (First TO Option Period 1)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4200 (First TO Option Period 2)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4300 (First TO Option Period 3)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4400 (First TO Option Period 4)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Total Prime Contractor Labor Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Subcontractor Labor Cost
Item 4000 (First TO Base Period)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4100 (First TO Option Period 1)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4200 (First TO Option Period 2)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4300 (First TO Option Period 3)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 4400 (First TO Option Period 4)
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Total Subcontractor Labor Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Total Labor Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Offerors may add additional columns to account for the application of additional burdens. Pricing shall be derived from left to right with the far left side including the direct costs and the far right including the direct cost following application of all fees and burdens. Please ensure working formulas.

CLINs 4000, 4100, 4200, 4300, and 4400 will be included in the first TO issued concurrently with the IDIQ contract.

Cost Only ODC

SOLICITATION NO. N6339425R0001 ATTACHMENT JS-3Effective Date:
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Indirect Cost Burden 1:Indirect Cost Burden 2:Indirect Cost Burden 3:Indirect Cost Burden 4:Facilities Capital Cost of Money Burden 1:Facilities Capital Cost of Money Burden 2:
Cost ElementsAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountTotal Price
Other Direct Cost
Other Direct Costs - Travel and Incidental Material
CLIN 2000 (IDIQ Contract Year 1)$ 188,355$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 188,355
CLIN 2000 (IDIQ Contract Year 2)$ 194,005$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 194,005
CLIN 2000 (IDIQ Contract Year 3)$ 199,825$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 199,825
CLIN 2000 (IDIQ Contract Year 4)$ 205,820$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 205,820
CLIN 2000 (IDIQ Contract Year 5)$ 211,995$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 211,995
CLIN 5000 (First TO Base Period)$ 470,886$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 470,886
CLIN 5100 (First TO Option Period 1)$ 485,013$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 485,013
CLIN 5200 (First TO Option Period 2)$ 499,563$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 499,563
CLIN 5300 (First TO Option Period 3)$ 514,550$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 514,550
CLIN 5400 (First TO Option Period 4)$ 529,988$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 529,988

Total Other Direct Cost $ 3,500,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,500,000

Offerors may add additional columns to account for the application of additional burdens. Pricing shall be derived from left to right with the far left side including the direct costs and the far right including the direct cost following application of all burdens. Please ensure working formulas.

CLINs 5000, 5100, 5200, 5300, and 5400 will be included in the first TO issued concurrently with the IDIQ contract. ODCs under CLIN 2000 will be reserved on the IDIQ contract for issuance under future orders.

Indirect Rate Support Sample Indirect Rate Supporting Documentation

BudgetActual Expenses
Overhead Expense2024202320222021
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/18
N000XX-XX-X-00XX9/1/19
N000XX-XX-X-00XX8/1/17
* When developing your percentage, these are the contracts contributing
to development of the percentage.

Labor Categories

Analyst, Financial Systems I
Engineer, Computer II
Engineer, Electrical/Electronics III
Engineer, Mechanical II
Engineer, Systems II
Engineer, Systems IV
Engineering Technician I
Engineering Technician II
Engineering Technician IV
Engineering Technician V
Logistician III
Manager, Administrative III
Manager, Program/Project II
Manager, Program/Project III
Material Handling Laborer
Specialist, Quality Control III

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