Attachment 3 - Cost-Price_Worksheet_Template.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- HC1047-12-R-4031
- Issued by
-
Defense Information Systems Agency
About this file
Cost/Price Worksheet Template
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HC1047-12-R-4031-0004.pdf | ||
| HC1047-12-R-4031-0003.pdf | ||
| JSDR Development Questions and Answers Complete.xls | XLS spreadsheet | |
| HC1047-12-R-4031-0002 FINAL.pdf | ||
| JSDR Development Questions and Answers.xls | XLS spreadsheet | |
| HC1047-12-R-4031-0001.pdf | ||
| HC1047-12-R-4031.pdf | ||
| Attachment 2 - Past Performance References.docx | DOCX document | |
| Attachment 4 - Form DD254.pdf | ||
| Attachment 1 -Past Performance Cover Letter and Questionnaire.docx | DOCX document |
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. |
| THESE TEMPLATES ARE A MODEL ONLY. OFFEROR MAY PROVIDE COST DATA IN OWN FORMAT; HOWEVER, SUBMISSIONS CONTAINING INCOMPLETE DATA, 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 | ERROR:#REF! |
| Option to Extend | $0.00 |
| TOTAL | ERROR:#REF! |
CONSOLIDATED
| Cost/Price Worksheet Template | ||||
| Offeror Name: | ||||
| Solicitation/Task Order: | ||||
| Period of Performance: | ||||
| CONSOLIDATED | ||||
| Direct Labor | Hours | Total | ||
| Labor Category 1 | ERROR:#REF! | ERROR:#REF! | ||
| Labor Category 2 | ERROR:#REF! | ERROR:#REF! | ||
| Labor Category 3 | ERROR:#REF! | ERROR:#REF! | ||
| Labor Category 4 | ERROR:#REF! | ERROR:#REF! | ||
| Labor Category N | ERROR:#REF! | ERROR:#REF! | ||
| Subtotal Direct Labor | ERROR:#REF! | |||
| Base | Rate | |||
| Fringe | ERROR:#REF! | ERROR:#REF! | ||
| Overhead | ERROR:#REF! | ERROR:#REF! | ||
| Subtotal Labor Cost | ERROR:#REF! | |||
| Material Cost | ERROR:#REF! | |||
| Subcontractor Costs | ||||
| Subcontractor A | ERROR:#REF! | |||
| Subcontractor B | ERROR:#REF! | |||
| Subcontractor C | ERROR:#REF! | |||
| Subcontractor N | ERROR:#REF! | |||
| Subtotal Subcontractor Costs | ERROR:#REF! | |||
| Base | Rate | |||
| Material and Subcontractor Handling | ERROR:#REF! | ERROR:#REF! | ||
| Travel | ERROR:#REF! | |||
| ODCs | ERROR:#REF! | |||
| G&A | ERROR:#REF! | ERROR:#REF! | ||
| Subtotal Cost before COM and FEE | ERROR:#REF! | |||
| COM | Base | Factor | ||
| Overhead Pool A | ERROR:#REF! | ERROR:#REF! | ||
| Overhead Pool B | ERROR:#REF! | ERROR:#REF! | ||
| Overhead Pool C | ERROR:#REF! | ERROR:#REF! | ||
| Overhead Pool D | ERROR:#REF! | ERROR:#REF! | ||
| Subtotal COM | ERROR:#REF! | |||
| Base | Rate | |||
| Fee | ERROR:#REF! | ERROR:#REF! | ||
| Total Cost Plus Fee | ERROR:#REF! |
Base Year
| Cost/Price Worksheet Template | ||||
| Offeror Name: | ||||
| Solicitation/Task Order: | ||||
| Period of Performance: | ||||
| CONTRACT YEAR 1 | ||||
| Direct Labor | Hours | Rate | Total | |
| 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 | |||
| Base | Rate | |||
| 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 | |||
| Base | Rate | |||
| 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 | |||
| COM | Base | Factor | ||
| 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 | |||
| Base | Rate | |||
| Fee/Profit | $0.00 | $0.00 | ||
| Total Cost Plus Fee/Profit | $0.00 |
Option Period I
| Cost/Price Worksheet Template | ||||
| Offeror Name: | ||||
| Solicitation/Task Order: | ||||
| Period of Performance: | ||||
| CONTRACT YEAR 2 | ||||
| Direct Labor | Hours | Rate | Total | |
| 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 | |||
| Base | Rate | |||
| 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 | |||
| Base | Rate | |||
| 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 | |||
| COM | Base | Factor | ||
| 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 | |||
| Base | Rate | |||
| Fee/Profit | $0.00 | $0.00 | ||
| Total Cost Plus Fee/Profit | $0.00 |
Option Period II
| Cost/Price Worksheet Template | ||||
| Offeror Name: | ||||
| Solicitation/Task Order: | ||||
| Period of Performance: | ||||
| CONTRACT YEAR 3 | ||||
| Direct Labor | Hours | Rate | Total | |
| 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 | |||
| Base | Rate | |||
| 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 | |||
| Base | Rate | |||
| 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 | |||
| COM | Base | Factor | ||
| 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 | |||
| Base | Rate | |||
| Fee/Profit | $0.00 | $0.00 | ||
| Total Cost Plus Fee/Profit | $0.00 |
Option Period III
| Cost/Price Worksheet Template | ||||
| Offeror Name: | ||||
| Solicitation/Task Order: | ||||
| Period of Performance: | ||||
| CONTRACT YEAR 4 | ||||
| Direct Labor | Hours | Rate | Total | |
| 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 | |||
| Base | Rate | |||
| 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 | |||
| Base | Rate | |||
| 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 | |||
| COM | Base | Factor | ||
| 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 | |||
| Base | Rate | |||
| 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 Labor | Hours | Rate | Total | |
| 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 | |||
| Base | Rate | |||
| 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 | |||
| Base | Rate | |||
| 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 | |||
| COM | Base | Factor | ||
| 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 | |||
| Base | Rate | |||
| Fee/Profit | $0.00 | $0.00 | ||
| Total Cost Plus Fee/Profit | $0.00 |
Rate Sheet
| Rate Sheet | |||||||
| Esc | 0.0% | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% | |
| Direct Rate | YR 1 | YR 2 | YR 3 | YR 4 | Yr 5 | YR 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 | ||||||||||||||||
| Travel | Lodging | Total | Per Diem | Total | Round Trip | Total | Car Rental | Total | Total | |||||||
| Trip # | Origin | Destination | Days | Nights | No. Personnel | Rate | Lodging | Rate | Per Diem | Airfare | Airfare | Rate | Car Rental | Mileage | Parking | Travel |
| 1 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 2 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 3 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 4 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| n | 0 | 0 | 0 | $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 | |||
| Item | Unit Cost | # Units | Subtotal |
| 1 | 0 | ||
| 2 | 0 | ||
| 3 | 0 | ||
| 4 | 0 | ||
| N | 0 | ||
| Total | 0 |
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 .