Attachment 0005_SEPM Cost Price Template.xlsx

XLSX spreadsheet 48 KB Posted

Attached to
PEO C3T - Systems Engineering and Program Management (SEPM) Support
Solicitation number
W15P7T-23-R-0004
Issued by

View the file

Other files

Show all 16

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

Government Instructions to Offerors
CPFF & Cost Task Order
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.
SummaryCells will auto-populate from other tabs.
Total (TO)Offerors shall complete all the green colored cells.
Travel CLINsOfferors shall complete all the green colored cells.
ODC CLINsOfferors shall complete all the green colored cells.
Direct LaborOfferors shall complete all the green colored cells.
Indirect LaborOfferors shall complete all the green colored cells.

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

Offerors Information

Offeror Company Information
Offeror Name:Offeror A
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)2/11/23
Proposal Valid until (mm/dd/yyyy)
Evaluation Stage:

Summary

Offeror A
Grand TotalBase PeriodOpt Yr 1Opt Yr 2
Hours Per Year2087Hours Per Year2087Hours Per Year2087Hours Per Year2087
PoP Length (months):36PoP Length (months):12PoP Length (months):12PoP Length (months):12
Total Hours589,440Total Hours186,240Total Hours197,760Total Hours205,440
CME282.4CME89.2CME94.8CME98.4
CME Annual Rate$ - 0CME Annual Rate$ - 0CME Annual Rate$ - 0CME Annual Rate$ - 0
Total Direct Labor$ - 0Total Direct Labor$ - 0Total Direct Labor$ - 0Total Direct Labor$ - 0
Total Burdened Labor Cost$ - 0Total Burdened Labor Cost$ - 0Total Burdened Labor Cost$ - 0Total Burdened Labor Cost$ - 0
Total Project Cost$ 7,100,000.00Total Project Cost$ 1,900,000.00Total Project Cost$ 2,500,000.00Total Project Cost$ 2,700,000.00
Burdened/UnburdenedERROR:#DIV/0!Burdened/UnburdenedERROR:#DIV/0!Burdened/UnburdenedERROR:#DIV/0!Burdened/UnburdenedERROR:#DIV/0!
Unburdened/BurdenedERROR:#DIV/0!Unburdened/BurdenedERROR:#DIV/0!Unburdened/BurdenedERROR:#DIV/0!Unburdened/BurdenedERROR:#DIV/0!

Total (TO)

Project Title:Systems and Engineering Program Management
Offeror:Offeror A
Date:2/11/23
Escalation4.80%Escalation4.80%
Base PeriodOption Period 1Option Period 2
Period Dates9/30/239/29/24Period Dates9/30/249/29/25Period Dates9/30/259/29/26
Direct Labor CategoryWork AreaHoursRateTotalHoursRateTotalHoursRateTotalTotal
Business and Operations Management
Acquisition Specialist, JourneymanAPG3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 0
Acquisition Specialist, SeniorAPG9,600$ - 0$ - 013,440$ - 0$ - 017,280$ - 0$ - 0$ - 0
Acquisition Specialist, Subject Matter ExpertAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Contracts Administrator, SeniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Communication Specialist, JuniorFt Eustice Va.1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Communication Specialist, JourneymanAPG3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 0
Communication Specialist, SeniorFt Eustice Va.1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Facilities Manager, SeniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Financial Analyst, JuniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Financial Analyst, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Financial Analyst, SeniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Graphic Designer, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Human Resources Administrative Assistant, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Manager, Program Subject Matter ExpertAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Program Analyst, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Program Analyst, SeniorArlington Va.5,760$ - 0$ - 05,760$ - 0$ - 05,760$ - 0$ - 0$ - 0
Program Specialist, JourneymanAPG7,680$ - 0$ - 07,680$ - 0$ - 07,680$ - 0$ - 0$ - 0
Security Specialist, SeniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Information Management
Computer Systems Analyst, JourneymanAPG3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 0
Cybersecurity Engineer, SeniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Database Architect, JourneymanAPG1,920$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 0
INFOSEC Engineer, SeniorAPG3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 0
Telecommunications Specialist, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Web Application Developer, Journeyman (Future)APG$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 0
Technical Engineering$ - 0
Computer Scientist, Subject Matter ExpertAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Configuration Management Specialist, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Data Analyst, JourneymanFt Hood Tx.1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Data Engineer, SeniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Network Engineer, SeniorFt Bliss Tx.5,760$ - 0$ - 05,760$ - 0$ - 05,760$ - 0$ - 0$ - 0
Network Engineer, Subject Matter ExpertAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Program Analyst, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Systems Engineer, SeniorFt Bliss Tx.11,520$ - 0$ - 011,520$ - 0$ - 013,440$ - 0$ - 0$ - 0
Systems Engineer, Subject Matter ExpertFt Bliss Tx.1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Test Engineer, SeniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Readiness Management
Logistician, SeniorAPG3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 0
Logistician, Subject Matter ExpertAPG3,840$ - 0$ - 03,840$ - 0$ - 03,840$ - 0$ - 0$ - 05,760$ - 0$ - 0
Logistics Specialist, JuniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Logistics Specialist, JourneymanAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Logistics Specialist, SeniorAPG5,760$ - 0$ - 05,760$ - 0$ - 05,760$ - 0$ - 0$ - 0
Maintenance SupervisorAPG63,360$ - 0$ - 065,280$ - 0$ - 067,200$ - 0$ - 0$ - 0
Program Analyst, Subject Matter ExpertAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0
Program Specialist, JuniorAPG1,920$ - 0$ - 01,920$ - 0$ - 01,920$ - 0$ - 0$ - 0

Direct Labor Subtotal (Unburdened) 186,240 $0.00 197,760 $0.00 205,440 $0.00 $0.00

Fringe Benefits % 0.00% $0.00 0.00% $0.00 0.00% $0.00 $0.00

Overhead % 0.00% $0.00 0.00% $0.00 0.00% $0.00 $0.00

G&A% (on labor) 0.00% $0.00 0.00% $0.00 0.00% $0.00 $0.00

Fee% (on labor) 0.00% $0.00 0.00% $0.00 0.00% $0.00 $0.00

Direct Labor Total (Burdened) 186,240 $0.00 197,760 $0.00 205,440 $0.00 $0.00

Other Direct Costs
All Other Direct Costs (See ODC tab)$400,000.00$450,000.00$500,000.00$1,350,000.00

Travel (See Travel tab) $1,900,000.00 $2,050,000.00 $2,200,000.00 $3,950,000.00

Subtotal ODCs $1,900,000.00 $2,500,000.00 $2,700,000.00 $7,100,000.00

G&A % 0.00% $0.00 0.00% $0.00 0.00% $0.00 $0.00

Proposed GrandTotal186,240$1,900,000.00197,760$2,500,000.00205,440$2,700,000.00$7,100,000.00
$7,100,000.00
Labor Categories. Enter all proposed direct labor ratest and the escalation rates.
Escalation factor. For option years, include escalation factor for DIRECT LABOR based on a reputable source, such as Global Insights, for each option year, if applicable.

Travel CLINs

PEO C3T SEPM
TravelBase - CLIN XXXX
AmountRateTotal
RTEP Plug1,900,000.00
General & Administrative$ 1,900,000.000%$ - 0
TOTAL PROPOSED$ 1,900,000.00
TravelOY1 - CLIN XXXX
AmountRateTotal
RTEP Plug2,050,000.00
General & Administrative$ 2,050,000.000%$ - 0
TOTAL PROPOSED$ 2,050,000.00
TravelOY2 - CLIN XXXX
AmountRateTotal
RTEP Plug2,200,000.00
General & Administrative$ 2,200,000.000%$ - 0
TOTAL PROPOSED$ 2,200,000.00

ODC CLINs

PEO C3T SEPM
ODCBase - CLIN XXXX
AmountRateTotal
RTEP Plug400,000.00
General & Administrative$ 400,000.000%$ - 0
TOTAL PROPOSED$ 400,000.00
ODCOY1 - CLIN XXXX
AmountRateTotal
RTEP Plug450,000.00
General & Administrative$ 450,000.000%$ - 0
TOTAL PROPOSED$ 450,000.00
ODCOY2 - CLIN XXXX
AmountRateTotal
RTEP Plug500,000.00
General & Administrative$ 500,000.000%$ - 0
TOTAL PROPOSED$ 500,000.00

Direct Labor

Detail should be provided in Cost Narrative
Labor Cat #Labor CategoryPlace of PerformanceClearance RequiredYears of Exp. requiredDirect labor rateSalary Survey, LOE, used to determine rate
B1AAcquisition Specialist, JourneymanAPG, MDSecret
B1CAcquisition Specialist, SeniorAPG, MDSecret
B1DAcquisition Specialist, Subject Matter ExpertAPG, MDSecret
B4CContracts Administrator, SeniorAPG, MDSecret
B3ACommunication Specialist, JuniorFort Eustis, VASecret
B3BCommunication Specialist, JourneymanAPG, MDSecret
B3CCommunication Specialist, SeniorFort Eustis, VASecret
B8CFacilities Manager, SeniorAPG, MDSecret
B9AFinancial Analyst, JuniorAPG, MDSecret
B9BFinancial Analyst, JourneymanAPG, MDSecret
B9CFinancial Analyst, SeniorAPG, MDSecret
B11BGraphic Designer, JourneymanAPG, MDSecret
B12BHuman Resources Administrative Assistant, JourneymanAPG, MDSecret
B18DManager, Program Subject Matter ExpertAPG, MDSecret
B17BProgram Analyst, JourneymanAPG, MDSecret
B17CProgram Analyst, SeniorArlington, VASecret
B19BProgram Specialist, JourneymanAPG, MDSecret
B24CSecurity Specialist, SeniorAPG, MDTop Secret/SCI
I3BComputer Systems Analyst, JourneymanAPG, MDSecret
I5CCybersecurity Engineer, SeniorAPG, MDSecret
I7BDatabase Architect, JourneymanAPG, MDSecret
T16CINFOSEC Engineer, SeniorAPG, MDTop Secret
I15CTelecommunications Specialist, JourneymanAPG, MDSecret
I16BWeb Application Developer, JourneymanAPG, MDSecret
I2DComputer Scientist, Subject Matter ExpertAPG, MDSecret
T3BConfiguration Management Specialist, JourneymanAPG, MDSecret
B6BData Analyst, JourneymanFort Hood, TXSecret
T4CData Engineer, SeniorAPG, MDSecret
I10CNetwork Engineer, SeniorFort Bliss, TXTop Secret
I10CNetwork Engineer, SeniorAPG, MDTop Secret
I10DNetwork Engineer, Subject Matter ExpertAPG, MDTop Secret
B17BProgram Analyst, JourneymanAPG, MDSecret
T26CSystems Engineer, SeniorFort Bliss, TXSecret
T26CSystems Engineer, SeniorAPG, MDSecret
T26DSystems Engineer, Subject Matter ExpertFort Bliss, TXSecret
T28CTest Engineer, SeniorAPG, MDSecret
R3CLogistician, SeniorAPG, MDSecret
R3DLogistician, Subject Matter ExpertAPG, MDSecret
R4ALogistics Specialist, JuniorAPG, MDSecret
R4BLogistics Specialist, JourneymanAPG, MDSecret
R4CLogistics Specialist, SeniorAPG, MDSecret
R5CMaintenance SupervisorAPG, MD (remote)Secret
B17DProgram Analyst, Subject Matter ExpertAPG, MDSecret
B20AProgram Specialist, JuniorAPG, MDSecret

Indirect Rate Required Information on Indirect Rates

FY2020FY2021FY2022Current Yeaer
Indirect Rate CategoriesPoolBaseRatePoolBaseRatePoolBaseRatePoolBaseRate

Fringe 0.00% 0.00% 0.00% 0.00%

Overhead

G&A

M&H

LOE

Labor Cat #Labor CategoryPlace of PerformanceClearance RequiredBase Year HoursOY1 HoursOY2 Hours
B1AAcquisition Specialist, JourneymanAPG, MDSecret38403,8403,840
B1CAcquisition Specialist, SeniorAPG, MDSecret960013,44017,280
B1DAcquisition Specialist, Subject Matter ExpertAPG, MDSecret19201,9201,920
B4CContracts Administrator, SeniorAPG, MDSecret19201,9201,920
B3ACommunication Specialist, JuniorFort Eustis, VASecret1,9201,9201,920
B3BCommunication Specialist, JourneymanAPG, MDSecret3,8403,8403,840
B3CCommunication Specialist, SeniorFort Eustis, VASecret1,9201,9201,920
B8CFacilities Manager, SeniorAPG, MDSecret19201,9201,920
B9AFinancial Analyst, JuniorAPG, MDSecret19201,9201,920
B9BFinancial Analyst, JourneymanAPG, MDSecret19201,9201,920
B9CFinancial Analyst, SeniorAPG, MDSecret19201,9201,920
B11BGraphic Designer, JourneymanAPG, MDSecret19201,9201,920
B12BHuman Resources Administrative Assistant, JourneymanAPG, MDSecret19201,9201,920
B18DManager, Program Subject Matter ExpertAPG, MDSecret19201,9201,920
B17BProgram Analyst, JourneymanAPG, MDSecret19201,9201,920
B17CProgram Analyst, SeniorArlington, VASecret57605,7605,760
B19BProgram Specialist, JourneymanAPG, MDSecret76807,6807,680
B24CSecurity Specialist, SeniorAPG, MDTop Secret/SCI19201,9201,920
I3BComputer Systems Analyst, JourneymanAPG, MDSecret38403,8403,840
I5CCybersecurity Engineer, SeniorAPG, MDSecret1,9201,9201,920
I7BDatabase Architect, JourneymanAPG, MDSecret1,9203,8403,840
T16CINFOSEC Engineer, SeniorAPG, MDTop Secret3,8403,8403,840
I15CTelecommunications Specialist, JourneymanAPG, MDSecret1,9201,9201,920
I16BWeb Application Developer, JourneymanAPG, MDSecret03,8403,840
I2DComputer Scientist, Subject Matter ExpertAPG, MDSecret1,9201,9201,920
T3BConfiguration Management Specialist, JourneymanAPG, MDSecret1,9201,9201,920
B6BData Analyst, JourneymanFort Hood, TXSecret1,9201,9201,920
T4CData Engineer, SeniorAPG, MDSecret1,9201,9201,920
I10CNetwork Engineer, SeniorFort Bliss, TXTop Secret3,8403,8403,840
I10CNetwork Engineer, SeniorAPG, MDTop Secret1,9201,9201,920
I10DNetwork Engineer, Subject Matter ExpertAPG, MDTop Secret1,9201,9201,920
B17BProgram Analyst, JourneymanAPG, MDSecret1,9201,9201,920
T26CSystems Engineer, SeniorFort Bliss, TXSecret3,8403,8403,840
T26CSystems Engineer, SeniorAPG, MDSecret7,6807,6809,600
T26DSystems Engineer, Subject Matter ExpertFort Bliss, TXSecret1,9201,9201,920
T28CTest Engineer, SeniorAPG, MDSecret1,92019201920
R3CLogistician, SeniorAPG, MDSecret3,8403,8403,840
R3DLogistician, Subject Matter ExpertAPG, MDSecret3,8403,8403,840
R4ALogistics Specialist, JuniorAPG, MDSecret1,9201,9201,920
R4BLogistics Specialist, JourneymanAPG, MDSecret1,9201,9201,920
R4CLogistics Specialist, SeniorAPG, MDSecret5,7605,7605,760
R5CMaintenance SupervisorAPG, MD (remote)Secret63,36065,28067,200
B17DProgram Analyst, Subject Matter ExpertAPG, MDSecret1,9201,9201,920
B20AProgram Specialist, JuniorAPG, MDSecret1,9201,9201,920
Total186240197760205440

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