J.5 Cost Model FD Support Contract_Updated.xlsx

XLSX spreadsheet 332 KB Posted

Attached to
Force Development Support Services Combined Synopsis/Solicitation Updated Federal contract opportunity
Solicitation number
(W91CRB-21-R-0008)
Issued by
Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

This is a solicitation for non-personal technical, analytical, and financial support services. The services include contracted advisory and assistance to support the Office of the Deputy Chief of Staff (DCS), G-8 Force Development Directorates (FD) in their role in the prioritization, integration and programming of Army and Joint materiel capabilities. The support will include research, analytic, programmatic, materiel requirements development, communications, and financial services. The focus is to assist the G-8 FD mission to fully equip the Army forces. Questions are due by July 30, 2021, and proposals are due by August 10, 2021. Award will be based on a best value trade-off evaluation. The Government intends to award without communications but reserves the right to conduct communications if deemed necessary by the Contracting Officer.

View the file

Other files for this federal contract opportunity

Other files attached to Force Development Support Services Combined Synopsis/Solicitation Updated, newest first.
File Type Posted
B08 Solicitation W91CRB-21-R-0008 11 August 2021.pdf PDF
Q_As - W91CRB-21-R-0008 Force Development 11 August 2021.pdf PDF
J.6 Workload Data FD Support Contract_11 Aug 21.xlsx XLSX spreadsheet
J.5 Cost Model FD Support Contract_Updated.xlsx XLSX spreadsheet
J.3 DD 254 FD Support Contract.pdf PDF
J.4 DD 254 FD Support Contract Continuation Pages.pdf PDF
J.5 Cost Model FD Support Contract.xlsx XLSX spreadsheet
J.2 CDRL 2 FD Support Contract.pdf PDF
Question Spreadsheet - W91CRB-21-R-0008 Force Development.XLSX XLSX spreadsheet
Solicitation W91CRB-21-R-0008.pdf PDF
J.1 CDRL 1 FD Support Contract.pdf PDF
Show all 11

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

Instructions

Instructions
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Government Inputs
Solicitation Number:
Name of Action:Force Development Support
Period of Performance:
Annual Productive Hours:1,880
Offeror Inputs
Prime Contractor/Subcontractor Name/Division:
Street Address:
City, State and Zip Code:

Section B

Section B - Supplies or Services Costs and/or Prices
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
(The format below is a sample. Propose in the actual format of the Section B contained in the solicitation)
TRANSITION IN PERIOD
CLINSUPPLIES/ SERVICESQTYUNITUNIT PRICEAMOUNT
0008Transition In (30 Days)1Each$ - 0
Labor - FFP$ - 0From Cost Summary Worksheet
Firm Fixed Price$ - 0
BASE PERIOD
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0001Labor - FD Requirements Base1Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0002Labor - OCAR Requirements Base1Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0003Labor - CBDP Requirements Base1Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0004Travel/ODCs - Base1Each$ - 0
T&MEstimated cost=$ 100,000.00From Cost Summary Worksheet
Burden/G&A =0.00%$ - 0From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet
Subtotal$ 100,000.00
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0007Labor - Surge Requirements - Base1Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
OPTION PERIOD 1
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1001Labor - FD Requirements OY11Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1002Labor - OCAR Requirements OY11Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1003Labor - CBDP Requirements OY11Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1004Travel/ODCs - OY11Each$ - 0
T&MEstimated cost=$ 100,000.00From Cost Summary Worksheet
Burden/G&A =0.00%$ - 0From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet
Subtotal$ 100,000.00
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1007Labor - Surge Requirements - OY11Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
OPTION PERIOD 2
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2001Labor - FD Requirements OY21Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2002Labor - OCAR Requirements OY21Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2003Labor - CBDP Requirements OY21Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2004Travel/ODCs - OY21Each$ - 0
T&MEstimated cost=$ 100,000.00From Cost Summary Worksheet
Burden/G&A =0.00%$ - 0From Cost Summary WorkWorksheet and ODC Cost Detail WorkWorksheet
Subtotal$ 100,000.00
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2007Labor - Surge Requirements - OY21Each$ - 0
Labor - T&M$ - 0From Labor Worksheet
T&M Total Price$ - 0
TOTAL
TOTAL
Total Price$ 300,000.00
Double check figure$ 300,000.00Total of clin totals
Double check figure$ 300,000.00Cost Summary Total
Double check figure$ 300,000.00Total from individual Worksheets

Cost Summary

Cost Summary Spreadsheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Force Development SupportTransition inBase PeriodOption 1Option 2Total
Labor & Subcontract Labor Hours2,663149,068162,620162,620476,972From Labor Cost Detail Worksheet
Direct & Indirect Labor & Subcontract Labor Costs (less G&A)$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Cost Detail Worksheet
G&A Costs$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Cost Detail Worksheet
Direct & Indirect Labor & Subcontract Labor Costs (Less Fee)$ - 0$ - 0$ - 0$ - 0$ - 0
Profit/Fee$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Cost Detail Worksheet
Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs (ODCs) (Less Burden)n/a$ 100,000.00$ 100,000.00$ 100,000.00$ 300,000.00From ODC Cost Detail Sheet
G&A Burden on ODCsn/a$ - 0$ - 0$ - 0$ - 0From ODC Cost Detail Sheet
ODCs$ - 0$ 100,000.00$ 100,000.00$ 100,000.00$ 300,000.00
Total Labor & ODC Costs$ - 0$ 100,000.00$ 100,000.00$ 100,000.00$ 300,000.00

Direct Labor Rate Schedule

Direct Labor Rate Schedule
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Transition PeriodBase Period - 11 MonthsOption Period 1Option Period 2
Directorate - DivisionLabor CategoriesLocationLabor TypeSCA IdentifierProposed Labor RateBasis for Rate ProposedProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor Rate
FD
OffsiteProgram ManagerContractor LocationProfessionaln/a$0.00$0.00$0.00
DOM - FDBSenior Analyst (Secret)GovernmentProfessionaln/a$0.00$0.00$0.00
DOM - FDCSenior Analyst (TS/SCI)GovernmentProfessional$0.00$0.00$0.00
DOM - FDCSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOM - FDDSenior Analyst (TS/SCI)GovernmentProfessional$0.00$0.00$0.00
DOM - FDDSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOM - FDGSenior Analyst (TS/SCI)GovernmentProfessional$0.00$0.00$0.00
DOM - FDGSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOM - FDISenior Analyst (TS/SCI)GovernmentProfessional$0.00$0.00$0.00
DOM - FDLSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOM - FDVSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOM OPSSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOI - FDAOperations Research Analyst (Secret)GovernmentProfessionaln/a$0.00$0.00$0.00
DOI - FDASenior Operations Research Analyst (Secret)GovernmentProfessionaln/a$0.00$0.00$0.00
DOI - FDPSenior Analyst (Secret)GovernmentProfessionaln/a$0.00$0.00$0.00
DOI - FDPAnalyst (Secret)GovernmentProfessionaln/a$0.00$0.00$0.00
DOI - FDRSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOI - FDRAnalyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOI - FDMSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOI - FDJSenior Analyst (Secret)GovernmentProfessional$0.00$0.00$0.00
DOI - FDJAnalyst (Secret)GovernmentProfessionaln/a$0.00$0.00$0.00
HQS - FDZForce Documentation Senior AnalystGovernmentProfessionaln/a$0.00$0.00$0.00
HQS - DIGCommunications Strategist Senior AnalystGovernmentProfessionaln/a$0.00$0.00$0.00
HQS - DIGWeb Master/DesignerGovernmentProfessionaln/a$0.00$0.00$0.00
OCAR
Senior AnalystGovernmentProfessionaln/a$0.00$0.00$0.00
CBDP
Senior AnalystGovernmentProfessionaln/a$0.00$0.00$0.00

Transition

Labor Cost Detail Spreadsheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours: 1880
Direct LaborIndirect Cost
CLIN 0008: Transition In Period - One Month0.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
FD
OffsiteProfessionalProgram ManagerEnter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDBProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDCProfessionalSenior Analyst (TS/SCI)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDCProfessionalSenior Analyst (Secret)Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDDProfessionalSenior Analyst (TS/SCI)Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDDProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDGProfessionalSenior Analyst (TS/SCI)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDGProfessionalSenior Analyst (Secret)Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDIProfessionalSenior Analyst (TS/SCI)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDLProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDVProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM OPSProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDAProfessionalOperations Research Analyst (Secret)Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDAProfessionalSenior Operations Research Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDPProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDPProfessionalAnalyst (Secret)Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDRProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDRProfessionalAnalyst (Secret)Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDMProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDJProfessionalSenior Analyst (Secret)Enter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDJProfessionalAnalyst (Secret)Enter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - FDZProfessionalForce Documentation Senior AnalystEnter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - DIGProfessionalCommunications Strategist Senior AnalystEnter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - DIGProfessionalWeb Master/DesignerEnter P or S$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OCAR
ProfessionalSenior AnalystEnter P or S1.00156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:17.002,663.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:156.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:2,663$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

Labor - FD

Labor Cost Detail Spreadsheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours: 1880
Direct CostIndirect Cost
CLIN 0001: Base Period - 11 Months0.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
FD
OffsiteProfessionalProgram ManagerEnter P or S0.50861.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDBProfessionalSenior Analyst (Secret)Enter P or S2.003,446.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDCProfessionalSenior Analyst (TS/SCI)Enter P or S2.003,446.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDCProfessionalSenior Analyst (Secret)Enter P or S6.0010,340.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDDProfessionalSenior Analyst (TS/SCI)Enter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDDProfessionalSenior Analyst (Secret)Enter P or S6.0010,340.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDGProfessionalSenior Analyst (TS/SCI)Enter P or S3.005,170.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDGProfessionalSenior Analyst (Secret)Enter P or S3.005,170.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDIProfessionalSenior Analyst (TS/SCI)Enter P or S4.006,893.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDLProfessionalSenior Analyst (Secret)Enter P or S4.006,893.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDVProfessionalSenior Analyst (Secret)Enter P or S2.003,446.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM OPSProfessionalSenior Analyst (Secret)Enter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDAProfessionalOperations Research Analyst (Secret)Enter P or S3.005,170.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDAProfessionalSenior Operations Research Analyst (Secret)Enter P or S3.005,170.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDPProfessionalSenior Analyst (Secret)Enter P or S3.005,170.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDPProfessionalAnalyst (Secret)Enter P or S4.006,893.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDRProfessionalSenior Analyst (Secret)Enter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDRProfessionalAnalyst (Secret)Enter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDMProfessionalSenior Analyst (Secret)Enter P or S9.0015,510.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDJProfessionalSenior Analyst (Secret)Enter P or S6.0010,340.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDJProfessionalAnalyst (Secret)Enter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - FDZProfessionalForce Documentation Senior AnalystEnter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - DIGProfessionalCommunications Strategist Senior AnalystEnter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - DIGProfessionalWeb Master/DesignerEnter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:68.50118,048.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:5,758.46$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 1001: Option Period 10.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
FD
OffsiteProfessionalProgram ManagerEnter P or S0.50940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDBProfessionalSenior Analyst (Secret)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDCProfessionalSenior Analyst (TS/SCI)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDCProfessionalSenior Analyst (Secret)Enter P or S6.0011,280.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDDProfessionalSenior Analyst (TS/SCI)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDDProfessionalSenior Analyst (Secret)Enter P or S6.0011,280.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDGProfessionalSenior Analyst (TS/SCI)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDGProfessionalSenior Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDIProfessionalSenior Analyst (TS/SCI)Enter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDLProfessionalSenior Analyst (Secret)Enter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM - FDVProfessionalSenior Analyst (Secret)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOM OPSProfessionalSenior Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDAProfessionalOperations Research Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDAProfessionalSenior Operations Research Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDPProfessionalSenior Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDPProfessionalAnalyst (Secret)Enter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDRProfessionalSenior Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDRProfessionalAnalyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDMProfessionalSenior Analyst (Secret)Enter P or S9.0016,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDJProfessionalSenior Analyst (Secret)Enter P or S6.0011,280.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
DOI - FDJProfessionalAnalyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - FDZProfessionalForce Documentation Senior AnalystEnter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - DIGProfessionalCommunications Strategist Senior AnalystEnter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
HQS - DIGProfessionalWeb Master/DesignerEnter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:68.50128,780.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 2001: Option Period 20.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
FD
OffsiteProfessionalProgram ManagerEnter P or S0.50940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDBProfessionalSenior Analyst (Secret)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDCProfessionalSenior Analyst (TS/SCI)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDCProfessionalSenior Analyst (Secret)Enter P or S6.0011,280.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDDProfessionalSenior Analyst (TS/SCI)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDDProfessionalSenior Analyst (Secret)Enter P or S6.0011,280.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDGProfessionalSenior Analyst (TS/SCI)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDGProfessionalSenior Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDIProfessionalSenior Analyst (TS/SCI)Enter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDLProfessionalSenior Analyst (Secret)Enter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM - FDVProfessionalSenior Analyst (Secret)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOM OPSProfessionalSenior Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDAProfessionalOperations Research Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDAProfessionalSenior Operations Research Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDPProfessionalSenior Analyst (Secret)Enter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDPProfessionalAnalyst (Secret)Enter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDRProfessionalSenior Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDRProfessionalAnalyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDMProfessionalSenior Analyst (Secret)Enter P or S9.0016,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDJProfessionalSenior Analyst (Secret)Enter P or S6.0011,280.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
DOI - FDJProfessionalAnalyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
HQS - FDZProfessionalForce Documentation Senior AnalystEnter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
HQS - DIGProfessionalCommunications Strategist Senior AnalystEnter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
HQS - DIGProfessionalWeb Master/DesignerEnter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
Total:68.50128,780.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:375,608$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

Labor - OCAR

Labor Cost Detail Spreadsheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours: 1880
Direct CostIndirect Cost
CLIN 0002: Base Period - 11 Months0.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
OCAR
GovernmentProfessionalSenior AnalystEnter P or S3.005,170.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:3.005,170.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 1002: Option Period 10.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
OCAR
GovernmentProfessionalSenior AnalystEnter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 2002: Option Period 20.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
OCAR
GovernmentProfessionalSenior AnalystEnter P or S3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:3.005,640.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:16,450$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

Labor - CBDP

Labor Cost Detail Spreadsheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours: 1880
Direct CostIndirect Cost
CLIN 0002: Base Period - 11 Months0.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
CBDP
GovernmentProfessionalSenior AnalystEnter P or S4.006,893.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4.006,893.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 1002: Option Period 10.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
FD
GovernmentProfessionalSenior AnalystEnter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 2002: Option Period 20.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
CBDP
GovernmentProfessionalSenior AnalystEnter P or S4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4.007,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:21,933$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

Labor - Surge

Labor Cost Detail Spreadsheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours: 1880
Direct CostIndirect Cost
CLIN 0007: Base Period - 11 Months0.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
GovernmentProfessionalOperations Research Analyst (Secret)Enter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalSenior Operations Research Analyst (Secret)Enter P or S1.001,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalSenior Analyst (Secret)Enter P or S7.0012,063.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalAnalyst (Secret)Enter P or S2.003,446.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:11.0018,956.67$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,723.33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 1007: Option Period 10.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
GovernmentProfessionalOperations Research Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalSenior Operations Research Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalSenior Analyst (Secret)Enter P or S7.0013,160.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalAnalyst (Secret)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:11.0020,680.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 2007: Option Period 20.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
GovernmentProfessionalOperations Research Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalSenior Operations Research Analyst (Secret)Enter P or S1.001,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalSenior Analyst (Secret)Enter P or S7.0013,160.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GovernmentProfessionalAnalyst (Secret)Enter P or S2.003,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:11.0020,680.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:60,317$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

ODC Cost Detail

ODC Cost Detail Spreadsheet (Note 13)
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
CLINDescriptionODCsBurden/G&A RateG&ATotal ODC Cost
abcde = c x df = c + e
0004ODCs Base Period$ 100,000.00$ - 0$ 100,000.00
1004ODCs Option Period 1$ 100,000.00$ - 0$ 100,000.00
2004ODCs Option Period 2$ 100,000.00$ - 0$ 100,000.00
Total$ 300,000.000.00%$ - 0$ 300,000.00
(To Section B)

Indirect Rate Summary

Indirect Rate Summary Spreadsheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
EntityContract TypeFringe RateOverhead RateG&A RateProposed Fee Rate% of Effort Performed by Prime and Subs Based on Labor Hours
Base Period (Including Transition In)
PRIME CONTRACTORT&M0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Option Year 1
PRIME CONTRACTORT&M0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Option Year 2 (Including Transition Out)
PRIME CONTRACTORT&M0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)

Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.

Subcontractors may provide data separately in the above format for proprietary reasons.

Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.

If rates proposed are based on other than actual rates, please state the reason(s).

Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

Fringe Benefit Worksheet

Fringe Benefit Worksheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
TotalFringe Rate:ERROR:#DIV/0!
Total Fringe Expense:$ - 0
Statutory Fringe Benefits:*Enter %**
FICA0.00%
FUTA0.00%
SUTA0.00%
Workman's Compensation0.00%
Etc - Enter Additional Categories As Needed0.00%
Fringe Benefits:*Fringe benefit offered to all professional employees? (Yes/No) (Explain, if no)Employer ShareEmployee Share, if applicableEnter %**Describe fringe benefit and enter any additional comments
Paid Leave/Vacation0%
Holidays0%
Sick Leave0%
Jury Duty0%
Military Leave0%
Bereavement Leave0%
Health Insurance0%
Health/Flexible Spending Account0%
Dental Insurance0%
Vision Insurance0%
Health Reimbursement0%
Disability Insurance Short & Term0%
Disability Insurance Long Term0%
Life insurance0%
401K or retirement plan0%
Profit sharing0%
Tuition Reimbursement0%
Etc - Enter Additional Categories As Needed0%

Paid Leave/Vacation (PTO, Sick, Military, etc.) Years of Experience Hours Alloted Per Year

*Please enter all the fringe benefit categories to be offered to professional FLSA exempt employees under this contract. Please complete this sheet for each fringe benefit pool if multiple pools exist.
**What % of the fringe benefit category contributes to the overall fringe benefit rate?

Fringe Rate Worksheet

Fringe Rate Worksheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Fringe Expenses:FY2018 ActualFY2019 ActualFY2020 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Indirect payroll$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vacation (PTO)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Holiday$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sick Leave$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Health/Disability Ins$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Workmans Compensation/Defense Base Act$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Bonuses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Retention Pay$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
401k Match$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mil Leave$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Breavement$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Insurance$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Overhead Rate Worksheet

Overhead Rate Worksheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Overhead Expenses:FY2018 ActualFY2019 ActualFY2020 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

G&A Rate Worksheet

G&A Rate Worksheet
Solicitation Number:
Name of Action: Force Development Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
G&A Expenses:FY2018 ActualFY2019 ActualFY2020 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subscriptions$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Postage$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Printing$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Supplies$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Telephone$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Misc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Recruiting$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Maint$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Equip$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Consultants$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prof fees$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Filings$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Legal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Costs
Interest$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contributions$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Advertising, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A Pool After Deducting Unallowable Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Allocation Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead (including any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs (inclusing any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A Allocation Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Microsoft_Word_Document.docx General

Each offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed workbook shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for fairness, reasonableness, based on the cost/price analysis, and cost realism analysis (on cost CLINS) criteria in FAR 15.404-1.

Overall Instructions

· The worksheets are designed to automatically compute and populate other cells in the Excel workbook.

· The worksheet tabs shaded green have inputs required on that worksheet.

· Type the appropriate name of the Prime Contractor/Subcontractor/Division in Cell H14, the street address in Cell H15, and the city, state, and zip code in Cell H16 on the Instructions worksheet of the LOE Workbook. It will carry through the remaining worksheets.

· Please enter the requested data in the green shaded areas on the Direct Labor Rate Schedule, which includes the proposed labor rates, the cost realism basis for the rate proposed and the escalation rate used. The direct rate information feeds into the Labor Cost Detail worksheet.

· Please enter the requested data in the green shaded areas on the Labor Cost Detail worksheet, which includes which entity will be performing the work (columns D and E). Column L will only need inputs if the prime offeror is inputting a subcontractor’s fully burdened labor rate into that column.

· Please enter the requested data in the green shaded areas on the ODC Cost Detail worksheet. For the purposes of proposal, the Government has input normalized values for the ODCs. These numbers are to be used. The offerors may add any burden and/or G&A as appropriate. Since these are estimated amounts that may or may not occur, no fixed fee will be allowed on the ODCs.

· Please enter the requested data in the green shaded areas on the Indirect Rate Summary worksheet.

· Please enter the requested data in the green shaded areas on the Fringe, Overhead, and G&A Rate worksheets. These worksheets assist in calculating the indirect rates. This will enable the cost evaluation team to analyze the indirect costs. PLEASE NOTE: The rates at the bottom DO NOT carry over to the Indirect Rate Summary.

· To assist in the evaluation of the total compensation plan, please complete the requested data on the Fringe Benefit Worksheet. Any information not included will be assumed to not be offered. Offerors shall still supply a copy of its total compensation plan in accordance with the RFP.

Section B Worksheet

The Section B worksheet imports data from the Cost Summary, Labor Cost Detail, and ODC Cost Detail worksheets and is used as a basis for the proposed formal Section B.

This is the start of the file's text. The full file is on GovTribe.

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