Attachment_3_Deluge_Cost_Model_3_Year_service_FFP_TM.xlsx
XLSX spreadsheet 99 KB Posted
- Solicitation number
- W91CRB-18-T-0009
About this file
Cost Model
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Deluge_Q&A-_AMD_01.pdf | ||
| Attachment_1_PWS_TM_FFP_ATC_DELUGE_SYSTEMS_CLEAN.docx | DOCX document | |
| Attachment_2_Deluge_Section_L_and_M.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
Section B Labor & ODC Proposed Labor & ODC
| DIRECT LABOR** | # of Personnel | Est. Productive Hours Per (Billed Hours) | Loaded Rated per Hour * | Estimated Cost |
| System Administration | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Database Management Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Web Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Applications Programming Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Information Assurance Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Comsec Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Logistics Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| VTC Support | 5 | |||
| Optional Categories | ||||
| Training Support | 1 | ERROR:#REF! | ||
| IT Customer Support | 3 | ERROR:#REF! | ||
| Configuration Management Support | 2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Systems Analyst Support | 10 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Telephone Support | 1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| ERROR:#REF! | ERROR:#REF! | |||
| Total Labor | ERROR:#REF! | ERROR:#REF! |
| Burden Rate | |||
| Total ODC's | $ - 0 | $ - 0 | |
| Total Travel | $ - 0 | $ - 0 |
Grand Total ERROR:#REF!
| Entering the appropriate percentages in the shaded areas will automatically compute the corresponding amounts in the spreadsheet. |
| * = From labor detail spreadsheet. |
| ** = NOTE: In this case, OCONUS means Iraq or Afghanistan. If performance is required in an OCONUS location other than Iraq or Afghanistan, proposed OCONUS rates will not be in effect. See CLIN 0001 for more detail. |
| Attachment 1 | Labor Categories and |
| Level of Effort | W91CRB-08-R-0092 |
| Attachment 1 | Labor Categories and |
| Level of Effort | W91CRB-08-R-0092 |
| Attachment 1 | Labor Categories and |
| Level of Effort | W91CRB-08-R-0092 |
INSTRUCTIONS
INSTRUCTIONS
SECTION B
| SECTION B - SUPPLIES OR SERVICES & PRICES | |
| Solicitation # | ***NORMALIZED** |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0001 | Labor Base Year (months 1 - 12) | 1 | Each | $ - 0 | |
| FFP | Fixed Price = | $ - 0 | |||
| Tasks 1-3: PWS 3.2,3.3 & 3.4 | Profit = | $ - 0 | |||
| Total FFP = | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0002 | ODCs Base Year (months 1 - 12) | 1 | Each | $ - 0 | |
| FP-PPR | Fixed price = | ||||
| Tasks 1-3: PWS 3.2,3.3 & 3.4 | G&A= | $ - 0 | |||
| Total FFP= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0003 | Labor Base Year (months 1 - 12) | 1 | Each | $ - 0 | |
| T&M | Price = | $ - 0 | |||
| Task 4: PWS 3.5 | Profit= | $ - 0 | |||
| Total T&M= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0004 | ODCs Base Year (months 1 - 12) | 1 | Each | $ - 0 | $ 6,721.00 |
| COST | Cost = | $ 6,721.00 | |||
| Task 4: PWS 3.5 | G&A= | $ - 0 | |||
| Total Cost= | $ 6,721.00 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0005 | Labor Option Year 1 (months 13-24) | 1 | Each | $ - 0 | $ - 0 |
| FFP | Fixed Price = | $ - 0 | |||
| Tasks 1-3: PWS 3.2,3.3 | Profit = | $ - 0 | |||
| Total FFP= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0006 | ODCs Option Year 1 (months 13-24) | 1 | Each | $ - 0 | |
| FP-PPR | Fixed price = | ||||
| Tasks 1-3: PWS 3.2,3.3 & 3.4 | G&A= | $ - 0 | |||
| Total FFP= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0007 | Labor Option Year 1 (months 13-24) | 1 | Each | $ - 0 | |
| T&M | Price= | $ - 0 | |||
| Task 4: PWS 3.5 | Profit= | $ - 0 | |||
| Total T&M= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0008 | ODCs Option Year 1 (months 13-24) | 1 | Each | $ - 0 | |
| COST | Cost = | $ 6,721.00 | |||
| Task 4: PWS 3.5 | G&A= | $ - 0 | |||
| Total Cost= | $ 6,721.00 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0009 | Labor - Option Year 2 (months 25-36) | 1 | Each | $ - 0 | |
| FFP | Fixed Price = | $ - 0 | |||
| Tasks 1-3: PWS 3.2,3.3 | Profit = | $ - 0 | |||
| Total FFP= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0010 | ODCs Option Year2 (months 25-36) | 1 | Each | $ - 0 | |
| FP-PPR | Fixed price = | ||||
| Tasks 1-3: PWS 3.2,3.3 | G&A= | $ - 0 | |||
| Total FFP= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0011 | Labor Option Year 2 (months 25-36) | 1 | Each | $ - 0 | |
| T&M | Price = | $ - 0 | |||
| Task 4: PWS 3.5 | Profit= | $ - 0 | |||
| Total T&M= | $ - 0 |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0012 | ODCs Option Year 2 (months 25-36) | 1 | Each | $ - 0 | |
| COST | Cost = | $ 6,721.00 | |||
| Task 4: PWS 3.5 | G&A= | $ - 0 | |||
| $ 6,721.00 | |||||
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0013 | Accounting for Contract Services | 1 | Each | $ - 0 | |
| NSP | Fixed price = | NSP | |||
| Price = | NSP |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT |
| 0014 | Contract Data Requirements List | 1 | Each | $ - 0 | |
| NSP | Fixed price = | NSP | |||
| Price = | NSP |
| TOTAL | |
| Estimated Price= | $ 20,163.00 |
| Profit = | $ - 0 |
| Price + Profit = | $ 20,163.00 |
&F, &A
&F, &A
&F, &A
PAGE &P OF &N
PAGE &P OF &N
PAGE &P OF &N
Labor FFP- Cost Detail
| Labor - Cost Detail Spreadsheet | |
| Solicitation No. | COST DETAIL CLIN 0001, CLIN 0005 & CLIN 0009 |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: |
| CLIN 0001-Base Period FFP, Tasks 1-3 | 1.00% | |||||||
| POSITON TITLES | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2) | If Col e=S, Enter Name of Subcontractor(s) | Total Burdened Rate less Profit (Note 3) | Total Burdened Price less Profit (Note 3) | Profit | Total | Total Burdened Rate Including Profit |
| a | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0005-Option Year 1 FFP, Tasks 1-3 | 1.00% | |||||||
| POSITON TITLES | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2) | If Col e=S, Enter Name of Subcontractor(s) | Total Hourly Burdened Rate less Profit (Note 3) | Total Burdened Price less Profit (Note 3) | Profit | Total | Total Burdened Rate Including Profit |
| a | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | ||||||||
| Enter P or S | ||||||||
| 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0009-Option Year 2 FFP, Tasks 1-3 | 1.00% | |||||||
| POSITON TITLES | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2) | If Col e=S, Enter Name of Subcontractor(s) | Total Burdened Rate less Profit (Note 3) | Total Burdened Price less Profit (Note 3) | Profit | Total | Total Burdened Rate Including Profit |
| a | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |||
| 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Burdened Price less Profit | Profit | Total | |
| TOTAL LABOR | $ - 0 | $ - 0 | $ - 0 |
&F, &A
&F, &A
&F, &A
PAGE &P OF &N
PAGE &P OF &N
PAGE &P OF &N
Labor T&M- Cost Detail
| Labor - Cost Detail Spreadsheet | |
| Solicitation No. | COST DETAIL CLIN 0003, CLIN 0007, AND CLIN 0011 |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: |
| CLIN 0003-Base Period- T&M Task 4 | 1.00% | |||||||
| POSITON TITLES | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2) | If Col e=S, Enter Name of Subcontractor(s) | Total Burdened Rate less Profit (Note 3) | Total Burdened Price less Profit (Note 3) | Profit | Total | Total Burdened Rate Including Profit |
| a | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Deluge Technician | 400 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Alarm Technican | 175 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Engineer | 175 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 750 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0007-Option Year 1 T&M- Task 4 | 1.00% | |||||||
| POSITON TITLES | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2) | If Col e=S, Enter Name of Subcontractor(s) | Total Hourly Burdened Rate less Profit (Note 3) | Total Burdened Price less Profit (Note 3) | Profit | Total | Total Burdened Rate Including Profit |
| a | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Deluge Technician | 400 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Alarm Technican | 175 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Engineer | 175 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 750 | $ - 0 | $ - 0 | $ - 0 | |||||
| 750 | ||||||||
| CLIN 0011-Option Year 2, T&M, Task 4 | 1.00% | |||||||
| POSITON TITLES | Total Hours | Effort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2) | If Col e=S, Enter Name of Subcontractor(s) | Total Burdened Rate less Profit (Note 3) | Total Burdened Price less Profit (Note 3) | Profit | Total | Total Burdened Rate Including Profit |
| a | d=b X c | e | f | g | h=d X g | i | j = h + 1 | k = j / d |
| Deluge Technician | 400 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Alarm Technican | 175 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Engineer | 175 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 750 | $ - 0 | $ - 0 | $ - 0 | |||||
| 750 |
| Total Burdened Price less Profit | Profit | Total | |
| TOTAL LABOR | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
ODC -FFP Cost Detail
| ODC Cost Detail Spreadsheet | |
| Solicitation No. | |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: | |
| ODC COST DETAIL (FFP) CLIN 0002, CLIN 0006 & CLIN 0010 | |
| *Offeror must provide complete detail by ODC type and quanitty, and basis of estimate |
| CLIN | ODCs (Note 6) | Burden/G&A Rate | G&A $ | Total ODC Cost | |
| a | b | c | d = b X c | e = b + d | |
| CLIN 0002 | 0.00% | $ - 0 | $ - 0 | FFP ODCs offeror will need to provide detail and basis of estimate | |
| CLIN 0006 | 0.00% | $ - 0 | $ - 0 | ||
| CLIN 0010 | 0.00% | $ - 0 | $ - 0 | ||
| Total | $ - 0 | $ - 0 | $ - 0 | ||
| (To Section B) |
ODC- Task 4 COST
| ODC Cost Detail Spreadsheet | |
| Solicitation No. | |
| Prime Contractor/Subcontractor Name/Division: | |
| Period of Performance: | |
| ODC COST DETAIL (NORMALIZED) CLIN 0004, CLIN 0008 & CLIN 0012 |
| CLIN | ODCs (Note 6) | Burden/G&A Rate | G&A $ | Total ODC Cost |
| a | b | c | d = b X c | e = b + d |
| CLIN 0004 | $ 6,721.00 | 0.00% | $ - 0 | $ 6,721.00 |
| CLIN 0008 | $ 6,721.00 | 0.00% | $ - 0 | $ 6,721.00 |
| CLIN 0012 | $ 6,721.00 | 0.00% | $ - 0 | $ 6,721.00 |
| Total | $ 20,163.00 | $ - 0 | $ 20,163.00 | |
| (To Section B) | ||||
| ***NORMALIZED*** |
Microsoft_Word_Document1.docx General: Each 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 pricintg 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 and cost realism analysis criteria in FAR 15.404-1. Please enter the requested data in the light blue shaded areas in the Labor-Cost Detail spreadsheets and in the Indirect Rate 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- Cost Detail Spreadsheet and is used as a basis for the proposed formal Section B.
Cost Summary Worksheet: This spreadsheet is for Govt analysis purposes. It is populated from the Labor-Cost Detail spreadsheet.
Labor-Detail Worksheet:
General: 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. Each offeror is to bid on the labor categories and number of productive hours they are proposing. Reference Technical Exhibit 1 in the Performance Work Statement for historical data
NOTE 2: Column a of the Labor- Detail Spreadsheets should list the position titles you are proposing. Reference Technical Exhibit 1 in the Performance Work Statement for historical data. 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 provided by the Govt for the respective labor category.
NOTE 3: Please enter the burdened labor rate before profit for the labor categories listed. The burdened labor rate consist of the base labor rate that is actually paid to the employee plus social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead and G&A exclusive of profit/fee. Additional information may be requested if so determined by the Contract Officer to determine reasonableness of prices proposed.
NOTE 4: N/A
NOTE 5: N/A
ODC - Cost Detail Spreadsheet:
NOTE 6: An estimated normalized amount for other direct cost (ODC) and travel has been specified for proposal purposes. Each offeror is to include this amount in their proposal. Any material handling and/or G&A is to be applied as appropriate. Since this is an estimated amount that may or may not occur, no fixed fee will be proposed.
Indirect Rate Summary Worksheet: Please provide the indirect rates by year, and proposed percentage of performance by labor hour for the prime offeror and each division or subcontractor proposed to perform effort on this solicitation. For proprietary reasons, subcontractors may submit the information in the requested format directly to the Contracting Officer. This information is necessary for evaluation purposes and MUST be supplied for the offeror, other divisions, and subcontractors for the offeror's proposal to be considered complete and adequate.
Sample Fringe/Overhead Worksheet: This spreadsheet shows a generally accepted format for fringe benefit and/or overhead pool/base/rate calculations. Fringe benefit and overhead pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The fringe and overhead rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide a similar schedule for fringe and overhead for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.
Sample G&A Worksheet: This spreadsheet shows a generally accepted format for G&A pool/base/rate calculations. G&A pool, base, and rate calculations are required as part of the offeror's cost/price proposal. Please provide a similar schedule for G&A for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the G&A rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.
image2.emf
File details come from the government source that posted it.