Pricing_Template_W91CRB-19-R-5023.xlsx
XLSX spreadsheet 70 KB Posted
- Attached to
- FIELD SERVICE REPRESENTATIVE Federal contract opportunity
- Solicitation number
- W91CRB-19-R-5023
About this file
Pricing Template
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| B08_W91CRB-19-R-5023-0003_Solicitation_Amendment.pdf | ||
| B08_W91CRB-19-R-5023_Solicitation_Questions_and_Responses.pdf | ||
| B08_W91CRB-19-R-5023-0002_Solicitation_Amendment.pdf | ||
| B08_W91CRB-19-R-5023-0001_Solicitation_Amendment.pdf | ||
| CDRL_A004.pdf | ||
| CDRL_A002.pdf | ||
| CDRL_A003.pdf | ||
| CDRL_A001.pdf | ||
| B08_W91CRB-19-R-5023_Solicitation.pdf | ||
| CDRL_B001.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
INSTRUCTIONS
INSTRUCTIONS
SECTION B
| SECTION B - SUPPLIES OR SERVICES & PRICES |
| Solicitation # W91CRB-19-R-5023 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0001 | In Country Logistics Support - KOREA (1 FTE) | 1 | Lot | ||
| PWS 3.1 | |||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0002 | In Country Logistics Support - CANADA (2 FTE's) | 1 | Lot | ||
| PWS 3.2 | |||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | |
| 0003 | In Country Logistics Support - IRAQ (4 FTE's) | 1 | Lot | ||
| PWS 3.3 | |||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | ||
| 0004 | In Country Logistics Support - - KOREA (1 FTE) | |||||
| 3 Month Option | 1 | Lot | ||||
| PWS 3.1 | ||||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | ||
| 0005 | In Country Logistics Support - KOREA (1 FTE) | |||||
| 3 Month Option | 1 | Lot | ||||
| PWS 3.1 | ||||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | ||
| 0006 | In Country Logistics Support - CANADA (2 FTE's) | |||||
| 3 Month Option | 1 | Lot | ||||
| PWS 3.2 | ||||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | ||
| 0007 | In Country Logistics Support - CANADA (2 FTE's) | |||||
| 3 Month Option | 1 | Lot | ||||
| PWS 3.2 | ||||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | ||
| 0008 | In Country Logistics Support - IRAQ (4 FTE's) | |||||
| 3 Month Option | 1 | Lot | ||||
| PWS 3.3 | ||||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | AMOUNT | ||
| 0009 | In Country Logistics Support - IRAQ (4 FTE's) | |||||
| 3 Month Option | 1 | Lot | ||||
| PWS 3.3 | ||||||
| FFP | Total = | $ - 0 | From Labor Detail and ODC Summary Worksheets |
| TOTAL | $ - 0 | Sum of all CLINS |
| $ - 0 | DOUBLE CHECK NUMBER (Labor Detail worksheets + ODC worksheet) |
&F, &A
PAGE &P OF &N
Labor - KOREA
| Labor - Cost Detail Spreadsheet | |
| Solicitation No. | COST DETAIL |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: |
| PWS Pargraph Reference 3.1.1 CLIN 0001 (6 Month Base) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 1 | 0 | P | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 1 | 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. |
| PWS Pargraph Reference 3.1.1 CLIN 0004 (3 Month Option) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 1 | 0 | P | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 1 | 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. |
| PWS Pargraph Reference 3.1.1 CLIN 0005 (3 Month Option) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 1 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 1 | 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 | Profit | Total | |
| TOTAL LABOR | $ - 0 | $ - 0 | $ - 0 |
&F, &A
PAGE &P OF &N
Labor - CANADA
| Labor - Cost Detail Spreadsheet | |
| Solicitation No. | COST DETAIL |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: |
| PWS Pargraph Reference 3.2.1 CLIN 0002 (6 Month Base) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 2 | 0 | P | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 2 | 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. |
| PWS Pargraph Reference 3.2.1 CLIN 0006 (3 Month Option) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 2 | 0 | P | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 2 | 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. |
| PWS Pargraph Reference 3.2.1 CLIN 0007 (3 Month Option) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 2 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 2 | 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 | Profit | Total | |
| TOTAL LABOR | $ - 0 | $ - 0 | $ - 0 |
&F, &A
PAGE &P OF &N
Labor - IRAQ
| Labor - Cost Detail Spreadsheet | |
| Solicitation No. | COST DETAIL |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: |
| PWS Pargraph Reference 3.3.1 CLIN 0003 (6 Month Base) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 4 | 0 | P | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 4 | 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. |
| PWS Pargraph Reference 3.3.1 CLIN 0008 (3 Month Option) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 4 | 0 | P | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 4 | 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. |
| PWS Pargraph Reference 3.3.1 CLIN 0009 (3 Month Option) | ||||||||||||||
| POSITON TITLES | FTEs (Note 1) | 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 | Profit | 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 |
| Field Service Representative | 4 | 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 0 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| 4 | 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 | Profit | Total | |
| TOTAL LABOR | $ - 0 | $ - 0 | $ - 0 |
&F, &A
PAGE &P OF &N
ODC - Cost Summary
| ODC Cost Detail Spreadsheet | |
| Solicitation # | |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: | |
| ODC COST DETAIL |
| CLIN | ODCs (Note 6) | Matl Handling/G&A Rate | Matl Handling/ G&A $ | Profit | Total ODC Price | |
| a | b | c | d = b X c | e | f = b + d + e | |
| CLIN 0001 | $ - 0 | 0.00% | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate | |
| CLIN 0002 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0003 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0004 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0005 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0006 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0007 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0008 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| CLIN 0009 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 | Provide a schedule and narrative for ODC/travel basis of estimate |
| Total | $ - 0 | $ - 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.