018_W56JSR-17-R-0021_Sample_Worksheet.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Army Watercraft Systems (AWS) Services Federal contract opportunity
- Solicitation number
- W56JSR-17-R-0021
About this file
018 W56JSR-17-R-0021_Sample Worksheet
View the file
Other files for this federal contract opportunity
Show all 35
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
CLIN Structure
| CLIN Structure for the Anticipated Award | |||||
| CLIN Description | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 |
| Program Support-FFP | 1001 | 2001 | 3001 | 4001 | 5001 |
| C4ISR Technical Support-FFP | 1002 | 2002 | 3002 | 4002 | 5002 |
| C4ISR Technical Support-CPFF | 1003 | 2003 | 3003 | 4003 | 5003 |
| Travel-Cost | 1001 | 2004 | 3004 | 4004 | 5004 |
| Incidental Parts/Material-Cost | 1005 | 2005 | 3005 | 4005 | 5005 |
CLIN Cost Summary
| CONTRACTOR NAME | CLIN COST SUMMARY | |||||
| CLIN DESCRIPTION | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 | TOTAL |
| Program Support-FFP | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| C4ISR Technical Support-FFP | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| C4ISR Technical Support-CPFF | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Travel-Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Incidental Parts/Material-Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL CLIN COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Cost Element Summary
| SUMMARY OF COST ELEMENTS (ALL CLIN) | ||||||
| Cost Element | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 | Total |
| Direct Labor | ||||||
| Fringe | ||||||
| Overhead | ||||||
| Subcontractor | ||||||
| Subcontract Handling Cost (SHC) | ||||||
| Material | ||||||
| Material Handling Cost (MHC) | ||||||
| Travel | ||||||
| G&A | ||||||
| Fee | ||||||
| Sub Total (CPFF+Cost) |
| Program Support-FFP |
| Technical Support-FFP |
| Sub Total (FFP) |
Total (CPFF+Cost+FFP)
CPFF-FFP CLIN Worksheet
| Cost Element | Contractor Fiscal Year 20XX | |||
| CLIN 000X | ||||
| Direct Labor | Hours/Base | Rate | Dollars | |
| Labor Category 1 | Hours from LOE Worksheet | Rate from Labor Rate Worksheet | Formula | A |
| (Hours * Rate) | ||||
| Labor Category 2 | Hours from LOE Worksheet | Rate from Labor Rate Worksheet | Formula | B |
| (Hours * Rate) | ||||
| Labor Category 3 | Hours from LOE Worksheet | Rate from Labor Rate Worksheet | Formula | C |
| (Hours * Rate) | ||||
| Subtotal Direct Labor | Sum | Sum | D=A+B+C | |
| Fringe- if applicable | Formula Base (=D) | Rate from Indirect Rate Worksheet | Formula | E |
| (Base * Rate) | ||||
| Total Direct labor | Sum | F=D+E | ||
| Labor Overhead | Formula Base (=F) | Rate from Indirect Rate Worksheet | Formula | G |
| (Base *Rate) | ||||
| Subtotal Labor | Sum | H=F+G | ||
| S/IE | ||||
| S/IE 1 | From S/IE Cost proposal for applicable CLIN | K | ||
| S/IE 2 | From S/IE Cost proposal for applicable CLIN | L | ||
| S/IE 3 | From S/IE Cost proposal for applicable CLIN | M | ||
| Total S/IE | Sum | N=K+L+M | ||
| Subcontractor Handling | Formula Base (=N) | Rate from Indirect Rate Worksheet | Formula | O |
| (Base * Rate) | ||||
| G&A | Formula Base (=O+N+H) | Rate from Indirect Rate Worksheet | Formula | P |
| (Base * Rate) | ||||
| Total Cost Input (TCI) | Sum | Q=P+O+N+H | ||
| Fee | Formula Base (=Q) | Rate from Indirect Rate Worksheet | Formula | R |
| (Base * Rate) | ||||
| COM | ||||
| DL COM | Formula Base (D) | Rate from Indirect Rate Worksheet | Formula | S |
| (Base * Rate) | ||||
| G&A COM | Formula Base (=O+N+H) | Rate from Indirect Rate Worksheet | Formula | T |
| (Base * Rate) | ||||
| Total COM | Sum | U=S+T | ||
| Total Proposed | Sum | V=Q+R+U |
Cost CLIN Worksheet
| Cost Element | Base | Rate | Dollars | |
| Material | AA | |||
| Material Handling | Formula Base (=AA) | Rate from Indirect Rate Worksheet | Formula (Base*Rate) | BB |
| Travel | From Travel Worksheet | CC | ||
| ODCs (If Applicable) | From ODC worksheet | DD | ||
| S/IE | ||||
| S/IE 1 | From S/IE Cost proposal for applicable CLIN | EE | ||
| S/IE 2 | From S/IE Cost proposal for applicable CLIN | FF | ||
| S/IE 3 | From S/IE Cost proposal for applicable CLIN | GG | ||
| Subtotal SI&E | Sum | HH=EE+FF+GG | ||
| Subtotal | Sum | II=AA+BB+CC+DD+HH | ||
| G&A | Formula Base (=II) | Rate from Indirect Rate | Formula (Base*Rate) | JJ |
| Subtotal | Sum | KK=II+JJ | ||
| G&A COM | Formula Base (=II) | Rate from Indirect Rate | Formula (Base* Rate) | LL |
| Total | Sum | MM=KK+LL |
Material Cost Worksheet
| ITEM | ITEM NUMBER | ITEM DESCRIPTION | UNIT REQUIRED | UNIT COST | TOTAL EXTENDED COST (Unit Required*Unit Cost) |
| 1 | XXXX | ABC | XX | $XXX | $XXXX |
| 2 | XXXX | ABC | XX | $XXX | $XXXX |
| 3 | XXXX | ABC | XX | $XXX | $XXXX |
| 4 | XXXX | ABC | XX | $XXX | $XXXX |
| 5 | XXXX | ABC | XX | $XXX | $XXXX |
| 6 | XXXX | ABC | XX | $XXX | $XXXX |
| 7 | XXXX | ABC | XX | $XXX | $XXXX |
| 8 | XXXX | ABC | XX | $XXX | $XXXX |
| 9 | XXXX | ABC | XX | $XXX | $XXXX |
| 10 | XXXX | ABC | XX | $XXX | $XXXX |
| TOTAL | XXXX | $XXXXX |
File details come from the government source that posted it. Updated .