Attachment 4 - Cost-Price Summary Spreadsheet.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
Highly Efficient Algorithms for Vacuum Electronic Device Modeling Federal contract opportunity
Solicitation number
N00173-24-R-GF04
Issued by
Department of the Navy Secretary of the Navy Office of Naval Research

About this file

This document includes a cost proposal template and summary template attachment for a solicitation seeking highly efficient algorithms for vacuum electronic device modeling. The templates provide guidance on how to build up direct labor rates, apply indirect costs and fees, and summarize total costs by base year and option periods. Offerors are instructed to populate the templates with labor categories, rates, hours, and indirect cost percentages for prime contractor and subcontractor labor. They also provide areas to calculate material and handling costs, general and administrative expenses, and fixed fees applied to both prime and subcontractor labor costs. The total proposed costs are rolled up by base year and each optional period.

The related solicitation seeks contractor support for theoretical and experimental vacuum electronic research to develop new simulation tools, maintain existing codes, create novel device designs, and test predictions against measured data. The work will be performed for the Electromagnetic Technology Branch of the Naval Research Laboratory to advance vacuum electronic device modeling capabilities. Offerors are directed to the attached request for proposals for more details on the opportunity.

View the file

Other files for this federal contract opportunity

Other files attached to Highly Efficient Algorithms for Vacuum Electronic Device Modeling, newest first.
File Type Posted
N00173-24-R-GF04 0001.pdf PDF
Attachment 2 - Past Performance Questionnaire.pdf PDF
Attachment 1 - Requirements for Onsite Contractors.pdf PDF
Attachment 3- DD 254 for RFP.pdf PDF
Exhibit A - DD-1423 CDRL.pdf PDF
N00173-24-R-GF04.pdf PDF

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

INDIRECT RATES TEMPLATE

INDIRECT RATES

OFFEROR:

FY-22FY-23FY-24FY-25FY-26FY-27
FRINGE KTR-SITE
FRINGE GOV-SITE
KTR-SITE OH
GOV-SITE OH
M&H
G&A
FEE
COM

Add Rows as Necessary

&"Times New Roman,Regular"&9RFP: N00173-24-R-GF04 Attachment 4 Cost Proposal Workbook - Cost-Price Summary Spreadsheet

LABOR RATE BUILD-UP TEMPLATE

PRIME LABOR BUILD-UP

CHARTS BELOW MAY BE EDITED IF NEEDED.

ADD ADDITIONAL CHARTS TO REFLECT CHANGES IN APPLIED INDIRECTS FOR OUT YEARS IF APPLICABLE.

1. DIRECT LABOR RATE BUILD-UP
INPUT "0" for the non-applicable OH
FringeOverhead (Gov-Site)Overhead (Ktr-Site)M&HG&ABurdened RateFeeBurdenedEscalation FY-22Escalation FY-23Escalation FY-24Escalation FY-25Escalation FY-26Escalation FY-27
Labor CategoryEmployeeBase Rate0.00%0.00%0.00%0.00%0.00%Rate w/ Fee0.00%0.00%0.00%0.00%0.00%0.00%
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2. SUBCONTRACTOR LABOR RATE BUILD-UP
Labor CategoryEmployeeBase RateM&HG&ABurdened RateFeeBurdenedEscalation FY-22Escalation FY-23Escalation FY-24Escalation FY-25Escalation FY-26Escalation FY-27
0.00%0.00%0.00%Rate w/ Fee0.00%0.00%0.00%0.00%0.00%0.00%
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

SUMMARY TEMPLATE

CHART BELOW MAY BE EDITED IF NEEDED.

TASK ORDER 1 -- COST SUMMARY FORMAT

TotalBase YearOption 1Option 2Option 3Option 4
Cost ElementsLabor Category (LCAT)HoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
Prime Contractor Direct Labor
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
NameLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00

Total Direct Labor Cost - 0 $0.00 - 0 $0.00 - 0 $0.00 - 0 $0.00 - 0 $0.00 - 0 $0.00

Prime Contractor Indirect Labor CostAmountRateAmountRateAmountRateAmountRateAmountRateAmount
Fringe Benefits$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
On-Site Overhead (Gov't Facility)$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
Off-Site Overhead (KTR Facility)$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
G&A$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
Total Indirect Labor Cost$0.00$0.00$0.00$0.00$0.00$0.00
Total Direct and Indirect Labor Cost$0.00$0.00$0.00$0.00$0.00$0.00
COM$0.00$0.00$0.00$0.00$0.00$0.00
Total Prime Contractor Labor Cost$0.00$0.00$0.00$0.00$0.00$0.00
Subcontractor Labor CostHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
Name/CompanyLCAT- 0$0.00$0.00$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
Name/CompanyLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
Name/CompanyLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
Name/CompanyLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
Name/CompanyLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00
Name/CompanyLCAT- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00$0.00- 0$0.00

Total Proposed Subcontractor Labor Cost - 0 $0.00 - 0 $0.00 $0.00 $0.00 $0.00 $0.00

Prime contractor pass through (not including fee)RateAmountRateAmountRateAmountRateAmountRateAmount
Material & Handling$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
G&A$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00

Total M&H and G&A on Subcontractor Labore $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Total Labor Cost (Prime and Subcontractor Labor) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

FeeRateAmountAmountAmountAmountAmount
Fixed Fee - Prime Labor Costs Only$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
Fixed Fee - Subcontract Labor Costs Only$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
Total Fee (for Prime and Subcontractor Labor Costs)$0.00$0.00$0.00$0.00$0.00$0.00

Total Labor Cost Plus Fixed Fee (CPFF) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Other Direct CostsRateAmountRateAmountRateAmountRateAmountRateAmount
ODC - Gov't Plug$0.00$0.00$0.00$0.00$0.00$0.00
M&H$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
G&A$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.000.00%$0.00
Total ODC$0.00$0.00$0.00$0.00$0.00$0.00

Total Task Order CPFF $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

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