Attachment_JS-3_Cost_Spreadsheet_25R0001.xlsx

XLSX spreadsheet 69 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 summary spreadsheet (Attachment JS-3) for a federal contract solicitation (N6339425R0001) for Common Processing System (CPS) Sustainment, Installation, Procurement, and Engineering Services.

The solicitation is for fixed-price materials, cost-plus-fixed-fee (CPFF) materials and labor, and cost-only other direct costs (ODCs) for the CPS program over a 5-year IDIQ contract period. The solicitation includes pricing for pre-priced parts such as 64GB RAM and 2TB M.2 SSDs. The total evaluated price (TEP) for the pre-priced parts is $3,485. The labor categories and rates are listed for both the prime contractor and subcontractor, with a maximum fixed fee rate of 4%. ODCs for travel and incidental material are also provided, totaling $3.5 million over the 5-year period. The solicitation is unrestricted and utilizes FAR Part 15 procedures. The first ordering period is anticipated to begin in April 2025.

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

Sheet1

DIRECT LABOR HOURS
eCRAFT position titleeCRAFT pos. code
DISPATCHER, MOTOR VEHICLE (MOTOR VEHICLE UTILIZATION ASSISTANT)1060
GENERAL CLERK II1112
MANAGER, ADMINISTRATIVE IIIMANA3
MANAGER, ADMINISTRATIVE IVMANA4
SECRETARY II1312
TECHNICAL WRITER II30462
ACCOUNTING CLERK III1013
ANALYST, FINANCIAL SYSTEMSANFS
ANALYST, MANAGEMENT IIANM2
ANALYST, MANAGEMENT IIIANM3
ANALYST, MANAGEMENT IANM1
DRAFTER/CAD OPERATOR IV30064
ENVIRONMENTAL TECHNICIAN30090
GENERAL MAINTENANCE WORKER23370
HEATING, VENTILATION AND AIR-CONDITIONING MECHANIC23410
LABORER, GROUNDS MAINTENANCE11210
MATERIAL EXPEDITER21040
MATERIAL HANDLING LABORER21050
SPECIALIST, QUALITY CONTROL IIISQC3
INTERPRETER (SIGN LANGUAGE)30130
AUDIO VISUAL ANIMATORAVA
AUDIO VISUAL SCRIPT WRITERAVSW
GRAPHIC ARTIST15080
PHOTOGRAPHER V13075
SPECIALIST, PUBLIC AFFAIRSSPA
MEDIA SPECIALIST III13063
MANAGER, ADMINISTRATIVE IMANA1
MANAGER, PROGRAM/PROJECT IMANP1

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