A01_Att_0003_Cost_Model_W91CRB-19-R-5025.xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- W91CRB19R5025
About this file
Attachment 003 Cost Model
View the file
Other files
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
INSTRUCTIONS
SECTION B
| SECTION B - SUPPLIES OR SERVICES & PRICES |
| Solicitation # W91CRB-19-R-5025 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0001 | Team Lead | 1 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT |
| 0002 | Field Serice Representative | EA | ||
| FFP | ||||
| $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0002AA | Ex-Patriot Raid Tower & TIF 25K | 7 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0002AB | Ex-Patriot Wolfhound | 3 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0002AC | Ex-Patriot RAID Tower and TIF-25K power generator | 2 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets | |||
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0003 | Logistician | 1 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0004 | Technical Writer | 1 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT |
| 0005 | Administrative Support | 1 | EA | |
| FFP | ||||
| Total = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0006 | Interpreters | 2 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0007 | Maintenance and Supply Services | 40 | EA | ||
| FFP | |||||
| Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| TOTAL | $ - 0 | Sum of all CLINS |
| DOUBLE CHECK NUMBER (Labor Detail worksheets + ODC worksheet) |
&F, &A
PAGE &P OF &N
Labor-Detail
| Labor - Cost Detail Spreadsheet | |
| Solicitation No. W91CRB-19-R-5025 | COST DETAIL |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: |
| 0.00% | 0.00% | 0.00% | ||||||||||||
| POSITON TITLES | FTEs (Note 1) | Annual Productive Hours | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2) | If Col e=S, Enter Name of Subcontractor(s) | Hourly Base Pay Rate (Note 3 ) | Fringe/Overhead (Note 4) | Rate Before Application Of Prime G&A & Fee (Note 5) | Total Prime & Sub Labor Before Prime G&A & Fee | G&A | Subtotal | Fee | Total | Total Burdened Rate Including Profit |
| a | b | c | d=b X c | e | f | g | h | i | j = d X i | k | l = j + k | m | n=l + m | o = n/d |
| Team Lead | 1 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Ex-Patriot certified RAID Tower and TIF-25K FSR | 7 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Ex-Patriot certified RAID Tower and TIF-25K power generator FSR | 2 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Ex-Patriot certified RAID Tower and TIF-25K logistician | 1 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Ex-Patriot certified RAID Tower and TIF-25K technical writer | 1 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Ex-Patriot certified RAID Tower and TIF-25K administrative support | 1 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Interpreter | 2 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Ex-Patriot certified RAID Tower and TIF-25K maintenance and supply sypport facility personnel | 40 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| Ex-Patriot Wolfhound FSRs | 3 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||
| 58 | 0 | $ - 0 | $ - 0 | $ - 0 |
* = Include OCONUS Allowances as applicable. Include DBA Insurance in the direct rate or indirect as applicable per the offeror's accounting system.
| Total Burdened Price less Profit | Fee | Total | |
| TOTAL LABOR | $ - 0 | $ - 0 | $ - 0 |
&F, &A
PAGE &P OF &N
ODC - Cost Summary
| ODC Cost Detail Spreadsheet | |
| Solicitation # W91CRB-19-R-5025 | |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: | |
| ODC COST DETAIL |
| CLIN | ODCs (Note 6) | Matl Handling/G&A Rate | Matl Handling/ G&A $ | Total ODC Price | |
| a | b | c | d = b X c | f = b + d | |
| CLIN 0001 | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0002 | $ - 0 | ||||
| CLIN 0002AA | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0002AB | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0002AC | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0003 | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0004 | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0005 | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0006 | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0007 | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| Total | $ - 0 | $ - 0 | $ - 0 | ||
| (To Section B) |
Microsoft_Word_Document1.docx General: 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 enclosed spreadsheets 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 acceptability, fairness, and reasonableness based on the cost/price analysis criteria in FAR 15.404-1. Please enter the requested data in the light blue shaded areas in the Labor-Detail spreadsheets and in the ODC Summary spreadsheet. The spreadsheets are designed to automatically compute and populate other cells in the Excel spreadsheets and workbooks.
Section B Worksheet: The Section B worksheet imports data from the Labor-Detail Spreadsheets and ODC – Cost Summary spreadsheet and is used as a basis for the proposed formal Section B.
Cost Summary Worksheet: N/A
Labor-Cost Detail Worksheet:
General: There is a separate Labor-Detail worksheet for each Country location. Enter the requested data in the blue shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.
NOTE 1: FTE = full time equivalent. Offeror is to input their proposed labor categories and number of productive hours in the spreadsheet.
NOTE 2: Column a of the Labor- Detail Spreadsheets contains labor categories. During contract performance these categories ostensibly may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in Col e if the effort is to be performed by the prime contractor, and a S if performed by another division or subcontractor. Enter the name of the division or contractor in Col f. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the Col d hours for the individual category among the Col d cells in the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours proposed for the respective labor category.
NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate consist of the base labor rate that is actually paid to the employee excluding social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead and exclusive of G&A and profit/fee.
NOTE 4: Apply fringe/overhead to prime offeror derived rates. "Sample Fringe-OHWorksheet" provides a sample to be used to compute fringe/overhead.
NOTE 5: Please enter the prime offeror or subcontractor billing rate (if performed by a subcontractor) BEFORE application of prime offeror general and administrative (G&A) expense and fixed fee. Therefore, the rate entered for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead. If the labor category is performed by a subcontractor, the rate entered in Col i is as follows: Rate = sub base rate +sub fringe + sub overhead + sub G&A + sub fee (i.e. subcontractor loaded rate EXCEPT for prime G&A and fee).
Defense Base Act (DBA) Insurance and other applicable allowances: Offerors must address these costs, based upon their normal business practice, and include them in ODCs and/or labor. If these costs are normally included in ODCs, offerors are to show this in their schedule of OCDs. As indicted above, if these costs are part of labor, an additional column may be inserted in the “Labor Detail” worksheet.
ODC - Cost Detail Spreadsheet:
NOTE 6: Offerors shall input their total proposed ODC cost for CLIN and supply a supporting schedule of these costs. Any material handling and/or G&A is to be applied as appropriate.
image2.emf
File details come from the government source that posted it.