Cost-Price_Template.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Omnibus
Solicitation number
HC1047-14-R-4003
Issued by

About this file

Cost-Price Worksheet

View the file

Other files

File Type Posted
HC1047-14-R-4003-0004.pdf PDF
HC1047-14-R-4003-0004_Questions_and_Answers_02162014.xlsx XLSX spreadsheet
HC1047-14-R-4003-0003.pdf PDF
HC1047-14-R-4003-0003_Questions_and_Answers_02132014.xlsx XLSX spreadsheet
HC1047-14-R-4003-0002.pdf PDF
SF1408-14.pdf PDF
HC1047-14-R-4003_Questions_and_Answers_02112014.xlsx XLSX spreadsheet
HC1047-14-R-4003_P00001.pdf PDF
HC1047-14-R-4003_Questions_and_Answers.xlsx XLSX spreadsheet
HC1047-14-R-4003_Final_RFP_posted.pdf PDF
Final_Omnibus_DD254_DEG.pdf PDF
HC1047-14-R-4003_Omnibus__1-23-2014.docx DOCX document
Omnibus_PP_QUESTIONNAIRE.docx DOCX document
HC1047-14-R-4003_RFP.pdf PDF
Cost-Price_Template.xlsx XLSX spreadsheet
Show all 15

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:
Solicitation #:
Prime Offeror (if other than offeror):
The Summary Tab shall contain a roll up of total costs for each Contract Year proposed, summed to achieve total proposed contract value, including profit or fee, as applicable.
For each Task proposed, Offeror shall complete a set of these Cost Price Worksheets, with information supplied varying according to contract type. For example, if offeror is
proposing fully loaded labor rates, indirect rates specific to labor shall be provided only on the Rate Sheet tab, and eliminated from CY1 through Option to Extend tabs.
Include all formulas.
Offeror should add additional tabs, as appropriate, to reflect WBS for each Contract Year to level 3, if applicable. Costs on subordinate tabs should roll up to the summary costs
for line items shown on the CY1, etc. worksheet tabs.
OFFEROR SHALL PROVIDE COST DATA IN THIS FORMAT. SUBMISSIONS CONTAINING INCOMPLETE DATE, OR DATA INSUFFICIENT
TO ENABLE THE GOVERNMENT TO CONDUCT APPROPRIATE COST AND PRICING ANALYSIS MAY BE DEEMED NON RESPONSIVE OR DEFICIENT AND PRECLUDE OFFEROR'S PROPOSAL
FROM CONSIDERATION FOR AWARD.

SUMMARY

Offeror Name:
Solicitation #:
Prime Offeror (if other than offeror):
Summary
CY1$0.00
CY2$0.00
CY3$0.00
CY4$0.00
CY5$0.00
Option to Extend$0.00
TOTAL$0.00

CONSOLIDATED

Cost/Price Worksheet Template
Offeror Name:
Solicitation/Task Order:
Period of Performance:
CONSOLIDATED
Direct LaborHoursTotal
Labor Category 10$0.00
Labor Category 20$0.00
Labor Category 30$0.00
Labor Category 40$0.00
Labor Category N0$0.00
Subtotal Direct Labor$0.00
BaseRate
Fringe$0.00$0.00
Overhead$0.00$0.00
Subtotal Labor Cost$0.00
Material Cost$0.00
Subcontractor Costs
Subcontractor A$0.00
Subcontractor B$0.00
Subcontractor C$0.00
Subcontractor N$0.00
Subtotal Subcontractor Costs$0.00
BaseRate
Material and Subcontractor Handling$0.00$0.00
Travel$0.00
ODCs$0.00
G&A$0.00$0.00
Subtotal Cost before COM and FEE$0.00
COMBaseFactor
Overhead Pool A$0.00$0.00
Overhead Pool B$0.00$0.00
Overhead Pool C$0.00$0.00
Overhead Pool D$0.00$0.00
Subtotal COM$0.00
BaseRate
Fee$0.00$0.00
Total Cost Plus Fee$0.00

CY1

Cost/Price Worksheet Template
Offeror Name:
Solicitation/Task Order:
Period of Performance:
CONTRACT YEAR 1
Direct LaborHoursRateTotal
Labor Category 1$0.00
Labor Category 2$0.00
Labor Category 3$0.00
Labor Category 4$0.00
Labor Category N$0.00
Subtotal Direct Labor$0.00
BaseRate
Fringe$0.00$0.00
Overhead$0.00$0.00
Subtotal Labor Cost$0.00
Material Cost$0.00
Subcontractor Costs
Subcontractor A$0.00
Subcontractor B$0.00
Subcontractor C$0.00
Subcontractor N$0.00
Subtotal Subcontractor Costs$0.00
BaseRate
Material and Subcontractor Handling$0.00$0.00
Travel$0.00
ODCs$0.00
G&A$0.00$0.00
Subtotal Cost before COM and FEE$0.00
COMBaseFactor
Overhead Pool A$0.00$0.00
Overhead Pool B$0.00$0.00
Overhead Pool C$0.00$0.00
Overhead Pool D$0.00$0.00
Subtotal COM$0.00
BaseRate
Fee/Profit$0.00$0.00
Total Cost Plus Fee/Profit$0.00

CY2

Cost/Price Worksheet Template
Offeror Name:
Solicitation/Task Order:
Period of Performance:
CONTRACT YEAR 2
Direct LaborHoursRateTotal
Labor Category 1$0.00
Labor Category 2$0.00
Labor Category 3$0.00
Labor Category 4$0.00
Labor Category N$0.00
Subtotal Direct Labor$0.00
BaseRate
Fringe$0.00$0.00
Overhead$0.00$0.00
Subtotal Labor Cost$0.00
Material Cost$0.00
Subcontractor Costs
Subcontractor A$0.00
Subcontractor B$0.00
Subcontractor C$0.00
Subcontractor N$0.00
Subtotal Subcontractor Costs$0.00
BaseRate
Material and Subcontractor Handling$0.00$0.00
Travel$0.00
ODCs$0.00
G&A$0.00$0.00
Subtotal Cost before COM and FEE$0.00
COMBaseFactor
Overhead Pool A$0.00$0.00
Overhead Pool B$0.00$0.00
Overhead Pool C$0.00$0.00
Overhead Pool D$0.00$0.00
Subtotal COM$0.00
BaseRate
Fee/Profit$0.00$0.00
Total Cost Plus Fee/Profit$0.00

CY3

Cost/Price Worksheet Template
Offeror Name:
Solicitation/Task Order:
Period of Performance:
CONTRACT YEAR 3
Direct LaborHoursRateTotal
Labor Category 1$0.00
Labor Category 2$0.00
Labor Category 3$0.00
Labor Category 4$0.00
Labor Category N$0.00
Subtotal Direct Labor$0.00
BaseRate
Fringe$0.00$0.00
Overhead$0.00$0.00
Subtotal Labor Cost$0.00
Material Cost$0.00
Subcontractor Costs
Subcontractor A$0.00
Subcontractor B$0.00
Subcontractor C$0.00
Subcontractor N$0.00
Subtotal Subcontractor Costs$0.00
BaseRate
Material and Subcontractor Handling$0.00$0.00
Travel$0.00
ODCs$0.00
G&A$0.00$0.00
Subtotal Cost before COM and FEE$0.00
COMBaseFactor
Overhead Pool A$0.00$0.00
Overhead Pool B$0.00$0.00
Overhead Pool C$0.00$0.00
Overhead Pool D$0.00$0.00
Subtotal COM$0.00
BaseRate
Fee/Profit$0.00$0.00
Total Cost Plus Fee/Profit$0.00

CY4

Cost/Price Worksheet Template
Offeror Name:
Solicitation/Task Order:
Period of Performance:
CONTRACT YEAR 4
Direct LaborHoursRateTotal
Labor Category 1$0.00
Labor Category 2$0.00
Labor Category 3$0.00
Labor Category 4$0.00
Labor Category N$0.00
Subtotal Direct Labor$0.00
BaseRate
Fringe$0.00$0.00
Overhead$0.00$0.00
Subtotal Labor Cost$0.00
Material Cost$0.00
Subcontractor Costs
Subcontractor A$0.00
Subcontractor B$0.00
Subcontractor C$0.00
Subcontractor N$0.00
Subtotal Subcontractor Costs$0.00
BaseRate
Material and Subcontractor Handling$0.00$0.00
Travel$0.00
ODCs$0.00
G&A$0.00$0.00
Subtotal Cost before COM and FEE$0.00
COMBaseFactor
Overhead Pool A$0.00$0.00
Overhead Pool B$0.00$0.00
Overhead Pool C$0.00$0.00
Overhead Pool D$0.00$0.00
Subtotal COM$0.00
BaseRate
Fee/Profit$0.00$0.00
Total Cost Plus Fee/Profit$0.00

CY 5

Cost/Price Worksheet Template
Offeror Name:
Solicitation/Task Order:
Period of Performance:
CONTRACT YEAR 5
Direct LaborHoursRateTotal
Labor Category 1$0.00
Labor Category 2$0.00
Labor Category 3$0.00
Labor Category 4$0.00
Labor Category N$0.00
Subtotal Direct Labor$0.00
BaseRate
Fringe$0.00$0.00
Overhead$0.00$0.00
Subtotal Labor Cost$0.00
Material Cost$0.00
Subcontractor Costs
Subcontractor A$0.00
Subcontractor B$0.00
Subcontractor C$0.00
Subcontractor N$0.00
Subtotal Subcontractor Costs$0.00
BaseRate
Material and Subcontractor Handling$0.00$0.00
Travel$0.00
ODCs$0.00
G&A$0.00$0.00
Subtotal Cost before COM and FEE$0.00
COMBaseFactor
Overhead Pool A$0.00$0.00
Overhead Pool B$0.00$0.00
Overhead Pool C$0.00$0.00
Overhead Pool D$0.00$0.00
Subtotal COM$0.00
BaseRate
Fee/Profit$0.00$0.00
Total Cost Plus Fee/Profit$0.00

Option to Extend

Cost/Price Worksheet Template
Offeror Name:
Solicitation/Task Order:
Period of Performance:
Option to Extend 6 mos
Direct LaborHoursRateTotal
Labor Category 1$0.00
Labor Category 2$0.00
Labor Category 3$0.00
Labor Category 4$0.00
Labor Category N$0.00
Subtotal Direct Labor$0.00
BaseRate
Fringe$0.00$0.00
Overhead$0.00$0.00
Subtotal Labor Cost$0.00
Material Cost$0.00
Subcontractor Costs
Subcontractor A$0.00
Subcontractor B$0.00
Subcontractor C$0.00
Subcontractor N$0.00
Subtotal Subcontractor Costs$0.00
BaseRate
Material and Subcontractor Handling$0.00$0.00
Travel$0.00
ODCs$0.00
G&A$0.00$0.00
Subtotal Cost before COM and FEE$0.00
COMBaseFactor
Overhead Pool A$0.00$0.00
Overhead Pool B$0.00$0.00
Overhead Pool C$0.00$0.00
Overhead Pool D$0.00$0.00
Subtotal COM$0.00
BaseRate
Fee/Profit$0.00$0.00
Total Cost Plus Fee/Profit$0.00

Rate Sheet

Rate Sheet
Esc0.0%1.5%2.0%2.5%3.0%3.5%
Direct RateYR 1YR 2YR 3YR 4Yr 5YR 6
Labor Category 1
Labor Category 2
Labor Category 3
Labor Category 4
Labor Category N
Fringe Rate
Overhead Rate
G&A
M/H
FCCoM A
FCCoM B
FCCoM C
FCCoM D

Travel

Create A Travel Worksheet for Each Contract Year
TravelLodgingTotalPer DiemTotalRound TripTotalCar RentalTotalTotal
Trip #OriginDestinationDaysNightsNo. PersonnelRateLodgingRatePer DiemAirfareAirfareRateCar RentalMileageParkingTravel
1000$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2000$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3000$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4000$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
n000$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL$0.00

Materials

Materials
Create a Materials Worksheet for each Contract year
ItemUnit Cost# UnitsSubtotal
10
20
30
40
N0
Total0

ODCs Provide a listing of ODCs by type, cost and applied burdens for each contract year.

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