Attachment 0006 STMS Cost Price Spreadsheet.xlsx

XLSX spreadsheet 65 KB Posted

Attached to
Satellite Communications (SATCOM) Terminals Maintenance Support (STMS) - Cancelled
Solicitation number
W15P7T-25-R-0016
Issued by

About this file

This is a pricing spreadsheet template for the SATCOM Terminals Maintenance Support (STMS) contract. The template includes sections for Cost Plus Fixed Fee (CPFF) labor CLINs and Cost-No-Fee CLINs for travel, materials, and ODCs over a 5-year period (1 base year + 4 option years + 6-month extension option). The spreadsheet contains government plug numbers for non-labor costs: travel ($1.03M total), ODCs ($2.63M total), and materials ($7.65M total), totaling approximately $11.3M for these elements.

The labor portion requires pricing for 30 labor categories including program managers, network engineers, logisticians, and help desk personnel, with work locations at Aberdeen Proving Ground, Germany, and Kuwait. The template requires 66,400 annual labor hours (365,200 total hours over 5 years plus extension). Offerors must provide direct labor rates, fringe benefits, overhead, G&A, and fee percentages, along with supporting documentation like Forward Pricing Rate Agreements or payroll records. The contract is an 8(a) set-aside with projected award in April 2025.

View the file

Other files

File Type Posted
Cancellation Letter - STMS 27FEB2025.pdf PDF
STMS Solicitation Amendment 1 19 Feb 2025.pdf PDF
Attachment 0004 Labor Category Appendix AMD 01.xlsx XLSX spreadsheet
Attachment 0005-1 DD 254 Continuation Sheet.pdf PDF
STMS Industry Questions 19 Feb 2025.pdf PDF
W15P7T-25-R-0016 STMS.pdf PDF
Exhibit F CDRL B002 Contract Funds Status Report.pdf PDF
Exhibit K CDRL S001 FRACAS Report.pdf PDF
Attachment 0007 Past Performance Questionnaire STMS.pdf PDF
Exhibit H CDRL D001 Warranty Report.pdf PDF
Exhibit M CDRL B004 APG Vendor Report.pdf PDF
Attachment 0001 Performance Work Statement (PWS).pdf PDF
Attachment 0004 Labor Category Appendix.xlsx XLSX spreadsheet
Exhibit A CDRL A001 Site Survey Report.pdf PDF
Exhibit C CDRL A003 UID Report.pdf PDF
Attachment 0005 DD254.pdf PDF
Exhibit L CDRL A005 Property Management Report.pdf PDF
Exhibit G CDRL B003 IMS.pdf PDF
W15P7T-25-R-0016 STMS.pdf PDF
Exhibit B CDRL A002 Government Property Report.pdf PDF
Exhibit D CDRL A004 DMSMS Report.pdf PDF
Exhibit E CDRL B001 Monthly Report.pdf PDF
Exhibit J CDRL D002 COTS Manual.pdf PDF
Attachment 0002 Quality Assurance Surveillance Plan (QASP).pdf PDF
Attachment 0003 Manpower_Level of Effort (LOE).xlsx XLSX spreadsheet
Show all 25

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

Instructions

Offeror Name:0
Evaluation Stage:0
Government Instructions to Offerors
Firm Fixed Price (FFP) & Cost (No Fee) CLINs
Evaluation Stages
Proposal Submission Version and Date - First Submission
FINAL Proposal Submission and Date - Submission of the Final Proposal Revision (FPR), if questions or discussions are entered
TabInstructions
Offeror InformationOfferors shall complete all the green colored cells. For proposal date, please enter the date the proposal is submitted.
Total Proposed PriceCells will auto-populate from other tabs.
FFP CLINsCells will auto-populate from other tabs.
STMS Laor CLINsOfferors shall complete all the green colored cells.
Travel, Material, ODC CLIN tabsOfferors Shall include any additional uplifts on Government provided plug numbers for travel, material, and ODCs (ex. G&A). Fee is not permitted on these CLINs.

Note: All prices proposed in this workbook, if awarded, will be deemed contractual amounts.

1. In support of the proposed Direct Labor Rates, Offeror and its subcontractor(s) shall provide documentation of the most recent Direct Labor Rates, to include at least one of the following (a, b, c, or d):

a. Forward Pricing Rate Agreements (FPRAs) or Forward Pricing Rate Recommendations (FPRRs) from Defense Contract Audit Agency (DCAA) or Defense Contract Management Agency (DCMA) or DCAA/DCMA approved Compensation Rate Tables mapped to the proposed Labor Categories

b. Letter(s) of Intent (LOIs), which include, at a minimum, the following:
i. Position;
ii. Direct hourly rate;
iii. Submitted on offeror’s or subcontractor’s letterhead;
iv. Signed by the employer and prospective employee; and
v. A statement that the LOI is for W9124J-23-R-0014
c. Payroll records and/or paystubs showing Rate of Pay, and referenced to the Labor Category in the Proposal.
d. Salary Survey data to include copies or screen shots of the actual salary survey data, which shall include, at a minimum, the following:
i. Source of data;
ii. Job title and description;
iii. Geographic location; and
iv. Range of salary amounts with reference to applicability of amounts
2. In support of the proposed Indirect Expense Rates, Offeror and its subcontractor(s) shall provide documentation of the most recent Indirect Expense Rates, to include at least one of the following (a, b, c, d or e):
a. Most recent Forward Pricing Rate Agreements (FPRAs) with DCAA or DCMA
b. Most recent Forward Pricing Rate Recommendations (FPRRs) from DCAA or DCMA
c. Most recent Forward Pricing Rate Proposal (FPRP)
d. Approved Provisional Rates Proposal
e. Other statement of current rates
Note for paragraphs c, d and e: If an Offeror supports proposed indirect rates utilizing documentation options (c) through (e) above, then the Offeror shall also include:
i. Three (3) years of either of the below two types of information to validate the calculations:
a. Incurred Cost Submissions to DCAA detailing pools and bases (by expense accounts) OR
b. historical actuals detailing pools and bases (by expense accounts);
AND
ii. Forecasted pools and bases for the current year (by expense account). Below is a sample (formats and dates may vary):
iii. If an entity cannot include a-c above because it restructured or is a new entity, that company shall provide proof to include the date it restructured or the date the new entity was formed and include the pools and bases as well as all historical data detailing pools and bases information (by expense account) which validates the calculation from the date of the restructuring.

NOTE 1: The rates reflected in the FPRA, FPRR, FPRP, Approved Provisional Rates Proposal or other statement of current rates should directly match the rates proposed by the offeror or subcontractor. If the rates do not match, the offeror or subcontractor shall provide sufficient detail explaining how the proposed rates are realistic.

NOTE 2: For all documents that are provided to support the proposed rates, such documents shall be clearly explained within the proposal. The explanation shall include a mapping of the supporting documentation to the proposed rate(s) and how the proposed rate(s) was developed.

Offeror Information

Offeror Company Information
Offeror Name:
Offeror Street Address:
Offeror City:
Offeror State:
Offeror Zip Code:
Offeror Primary Contact Name:
Offeror Primary Contact Email:
Offeror Primary Contact Phone Number:
Offeror DUNS:
Offeror NAICS:
Offeror CAGE Code:
Offeror Secondary Contact Name:
Offeror Secondary Contact Email:
Offeror Secondary Contact Phone Number:
Offeror DCMA Contact Name:
Offeror DCMA Contact Email:
Offeror DCMA Contact Phone Number:
Offeror DCMA Street Address:
Offeror DCMA City:
Offeror DCMA State:
Offeror DCMA Zip Code:
Offeror DCAA Contact Name:
Offeror DCAA Contact Email:
Offeror DCAA Contact Phone Number:
Offeror DCAA Street Address:
Offeror DCAA City:
Offeror DCAA State:
Offeror DCAA Zip Code:
Proposal Date: (mm/dd/yyyy)
Evaluation Stage:

Price Sheet, Section B

Offeror Name:0
Evaluation Stage:0
Offeror Proposed Prices
Proposal Valid until (mm/dd/yyyy):
DescriptionPWS ReferencePeriod of Performace (POP)CLINCLIN TypeProposal Total Quantity (NTE)UnitUnit PriceTotal
STMS Labor SupportBase0001CPFF3Month$ - 0$ - 0
STMS Labor Support Funding Period 1Base0002CPFF3Month$ - 0$ - 0
STMS Labor Support Funding Period 2Base0003CPFF3Month$ - 0$ - 0
STMS Labor Support Funding Period 3Base0004CPFF3Month$ - 0$ - 0
TravelBase0003COST$ 164,014.50
ODCsBase0004COST$ 427,015.89
MaterialBase0005COST$ 1,240,657.29
Total Base Year$ 1,831,687.68
STMS Labor SupportOY11001CPFF12Month$ - 0$ - 0
TravelOY11003COST$ 172,215.23
ODCsOY11004COST$ 448,366.68
MaterialOY11005COST$ 1,302,690.15
Total OY1$ 1,923,272.06
STMS Labor SupportOY22001CPFF12Month$ - 0$ - 0
TravelOY22003COST$ 180,825.99
ODCsOY22004COST$ 470,785.02
MaterialOY22005COST$ 1,367,824.66
TotaL OY2$ 2,019,435.67
STMS Labor SupportOY33001CPFF12Month$ - 0$ - 0
TravelOY33003COST$ 189,867.29
ODCsOY33004COST$ 494,324.27
MaterialOY33005COST$ 1,436,215.89
Total OY3$ 2,120,407.45
STMS Labor SupportOY44001CPFF12Month$ - 0$ - 0
TravelOY44003COST$ 199,360.65
ODCsOY44004COST$ 519,040.48
MaterialOY44005COST$ 1,508,026.69
Total OY4$ 2,226,427.82
STMS Labor Support52.217-85001CPFF6Month$ - 0$ - 0
Travel52.217-85003COST$ 121,913.97
ODCs52.217-85004COST$ - 0
Material52.217-85005COST$ 791,714.01
52.217-8$ 913,627.98
TOTAL PROPOSED PRICE$ 11,034,858.66

CPFF CLINs

BASE
UNITCLINQtyUnit PriceTotal
Month00013$ - 0$ - 0
Month00023$ - 0$ - 0
Month00033$ - 0$ - 0
Month00043$ - 0$ - 0
Total Base$ - 0
OY1
CLINQtyUnit PriceTotal
Month100112$ - 0$ - 0
Total OY1$ - 0
OY2
CLINQtyUnit PriceTotal
Month200112$ - 0$ - 0
Total OY2$ - 0
OY3
CLINQtyUnit PriceTotal
Month300112$ - 0$ - 0
Total OY3$ - 0
OY4
CLINQtyUnit PriceTotal
Month400112$ - 0$ - 0
Total OY4$ - 0
TOTAL
52.217-8
CLINQtyUnit PriceTotal
Month50016$ - 0$ - 0
52.217-8$ - 0
TOTAL
Total QtyTotal Cost
66$ - 0

Total Proposed Price

OFFEROR0
CLINItemContract TypeBaseOY1OY2OY3OY452.217-8Total
0001, 0002,0003, 0004, 1001, 2001, 3001, 4001LaborCPFF$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
0005, 1002, 2002, 3002, 4002TravelCost (No Fee)$ 164,014.50$ 172,215.23$ 180,825.99$ 189,867.29$ 199,360.65$ 121,913.97$ 1,028,197.63
0006, 1003, 2003, 3003, 4003ODCsCost (No Fee)$ 427,015.89$ 448,366.68$ 470,785.02$ 494,324.27$ 519,040.48$ 272,496.25$ 2,632,028.59
0007, 1004, 2004, 3004, 4004MaterialsCost (No Fee)$ 1,240,657.29$ 1,302,690.15$ 1,367,824.66$ 1,436,215.89$ 1,508,026.69$ 791,714.01$ 7,647,128.69
TOTAL$ 1,831,687.68$ 1,923,272.06$ 2,019,435.67$ 2,120,407.45$ 2,226,427.82$ 1,186,124.23$ 11,307,354.91
Contract YearTravel CostsMaterial CostsODCs
Base$164,014.50$1,240,657.29$427,015.89$1,831,687.68
Option 1$172,215.23$1,302,690.15$448,366.68$1,923,272.06
Option 2$180,825.99$1,367,824.66$470,785.02$2,019,435.67
Option 3$189,867.29$1,436,215.89$494,324.27$2,120,407.45
Option 4$199,360.65$1,508,026.69$519,040.48$2,226,427.82
52.217-8$121,913.97$791,714.01$272,496.25$1,186,124.23
Total$1,028,197.63$7,647,128.69$2,632,028.59$11,307,354.91

STMS Labor CLINs

Labor CategoriesLabor CategoriesLocationSCA WD #/ Exempt StatusBASE - CLIN 0001OY1 - CLIN 1001OY2 - CLIN 2001OY3 - CLIN 3001OY4 - CLIN 400152.217-8 - CLIN 5001TOTAL
Total HoursDirect Labor RateExtended CostTotal HoursDirect Labor RateExtended CostTotal HoursDirect Labor RateExtended CostTotal HoursDirect Labor RateExtended CostTotal HoursDirect Labor RateExtended CostTotal HoursDirect Labor RateExtended CostTotal HoursTotal Cost
Global Logistics ManagerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
IT Asset Management Software EngineerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
IA Support ManagerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Jr-Level LogisticianAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Mid-Level LogisticianAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Office ManagerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Procurement CoordinatorAPG1,920$ - 01,920$ - 01,920$ - 01,920$ - 01,920$ - 0960$ - 010,560$ - 0
SATCOM Helpdesk SMEAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk SMEAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk SMEAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk SMEAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk SMEAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk TechnicianAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk TechnicianAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk TechnicianAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk TechnicianAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SATCOM Helpdesk TechnicianAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Senior Program ManagerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
SMC Program ManagerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Sr Warehouse ManagerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
STRMM Network EngineerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
STRMM Fielding Network AdminAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
STRMM Lead Network EngineerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
STRMM Network AdminAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
STRMM Network EngineerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
STRMM System AdminAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Warehouse ManagerAPG2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Mid-Level LogisticianGER2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Warehouse ManagerGER2,080$ - 02,080$ - 02,080$ - 02,080$ - 02,080$ - 01,040$ - 011,440$ - 0
Mid-Level LogisticianKWT3,120$ - 03,120$ - 03,120$ - 03,120$ - 03,120$ - 01,560$ - 017,160$ - 0
Warehouse ManagerKWT3,120$ - 03,120$ - 03,120$ - 03,120$ - 03,120$ - 01,560$ - 017,160$ - 0
Subtotal Direct Labor66,400066,400066,400066,400066,400033,2000365,200$ - 0
Fringe - Exempt0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
Fringe - SCA0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
Overhead0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
- 0
Subtotal Direct Labor, Fringe and Overhead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractor 1 Name$ - 0
Subcontractor 2 Name$ - 0

General & Administrative (G&A) 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 $ - 0

Subtotal Fully Burdened Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Total Cost Input (TCI) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Profit 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 0.00% $ - 0 $ - 0

TOTAL PROPOSED 66,400 $ - 0 66,400 $ - 0 66,400 $ - 0 66,400 $ - 0 66,400 $ - 0 33,200 $ - 0 365,200 $ - 0

TOTAL for BASE$ - 0TOTAL for OPTION 1$ - 0TOTAL for OPTION 2$ - 0TOTAL for OPTION 3$ - 0TOTAL for OPTION 4$ - 0TOTAL for 52.217-8 OPTION$ - 0$ - 0
Monthly12$ - 0Monthly12$ - 0Monthly12$ - 0Monthly12$ - 0Monthly12$ - 0Monthly6$ - 0

Travel CLINs

TravelBase - CLIN 0003
AmountRateTotal
Solicitation Plug$ 164,014.50
TOTAL PROPOSED$ 164,014.50
TravelOY1 - CLIN 1003
AmountRateTotal
Solicitation Plug$ 172,215.23
TOTAL PROPOSED$ 172,215.23
TravelOY2 - CLIN 2003
AmountRateTotal
Solicitation Plug$ 180,825.99
TOTAL PROPOSED$ 180,825.99
TravelOY3 - CLIN 3003
AmountRateTotal
Solicitation Plug$ 189,867.29
TOTAL PROPOSED$ 189,867.29
TravelOY4 - CLIN 4003
AmountRateTotal
Solicitation Plug$ 199,360.65
TOTAL PROPOSED$ 199,360.65
Travel52.217-8 - CLIN 5003
AmountRateTotal
Solicitation Plug$ 121,913.97
TOTAL PROPOSED$ 121,913.97
TOTAL Travel$ 1,028,197.63
Offeror shall include the exact Government-provided estimates for Travel and ODCs in its proposal. The Government estimates are the total cost for Travel and ODCs INCLUSIVE of an offeror’s associated indirect charges. Offeror shall propose any applicable indirect charges on the Travel and/or ODC cost estimates in accordance with its disclosed accounting practices.

ODC CLINs

ODCsBase - CLIN 0004
AmountRateTotal
Solicitation Plug$ 427,015.89
Facility Charge
TOTAL PROPOSED$ 427,015.89
ODCsOY1 - CLIN 1004
AmountRateTotal
Solicitation Plug$ 448,366.68
Facility Charge
TOTAL PROPOSED$ 448,366.68
ODCsOY2 - CLIN 2004
AmountRateTotal
Solicitation Plug$ 470,785.02
Facility Charge
TOTAL PROPOSED$ 470,785.02
ODCsOY3 - CLIN 3004
AmountRateTotal
Solicitation Plug$ 494,324.27
Facility Charge
TOTAL PROPOSED$ 494,324.27
ODCsOY4 - CLIN 4004
AmountRateTotal
Solicitation Plug$ 519,040.48
Facility Charge
TOTAL PROPOSED$ 519,040.48
ODCs52.217-8 - CLIN 5004
AmountRateTotal
Solicitation Plug$ 272,496.25
Facility Charge
TOTAL PROPOSED$ 272,496.25
TOTAL ODCs$ 2,632,028.59

Material CLINs

MaterialsBase - CLIN 0005
AmountRateTotal
Solicitation Plug$ 1,240,657.29
TOTAL PROPOSED$ 1,240,657.29
MaterialsOY1 - CLIN 1005
AmountRateTotal
Solicitation Plug$ 1,302,690.15
TOTAL PROPOSED$ 1,302,690.15
MaterialsOY2 - CLIN 2005
AmountRateTotal
Solicitation Plug$ 1,367,824.66
TOTAL PROPOSED$ 1,367,824.66
MaterialsOY3 - CLIN 3005
AmountRateTotal
Solicitation Plug$ 1,436,215.89
TOTAL PROPOSED$ 1,436,215.89
MaterialsOY4 - CLIN 4005
AmountRateTotal
Solicitation Plug$ 1,508,026.69
TOTAL PROPOSED$ 1,508,026.69
Materials52.217-8 - CLIN 5005
AmountRateTotal
Solicitation Plug$ 791,714.01
TOTAL PROPOSED$ 791,714.01
Total Materials$ 7,647,128.69

image1.png

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