Attachment_0016_-_Cost_Reimbursable_Pricing_Proposal_Format_2017-11-20_Final.xlsx
XLSX spreadsheet 42 KB Posted
- Attached to
- Logistics Civil Augmentation Program (LOGCAP) V Federal contract opportunity
- Solicitation number
- W52P1J-16-R-0001
About this file
This document contains templates for a cost reimbursable pricing proposal format to be used for the Logistics Civil Augmentation Program (LOGCAP) V solicitation. The templates include tables for the grand total price summary, pricing by performance work statement and site, rates, labor details, other direct costs details, subcontract summary, and notes on how to populate each table. The related federal contract opportunity notice indicates the Army intends to issue a Request for Proposal for LOGCAP V logistical support services worldwide. Services will include setting the theater, supply operations, transportation, engineering, base camp services, and other logistics and sustainment support. The Army aims to award minimum four and up to six Indefinite Delivery, Indefinite Quantity contracts for an initial five-year ordering period with options for five additional one-year periods. Concurrent with the IDIQ awards, the Army will award a setting the theater requirement as a task order for each Geographic Combatant Command/Army Service Component Command, consisting of a one-year base and nine one-year options.
Attachment 0016_-_Cost_Reimbursable_Pricing_Proposal_Format_2017-11-20_Final.xlsx
View the file
Other files for this federal contract opportunity
Show all 50
Logistics Civil Augmentation Program (LOGCAP) V has more files on GovTribe.
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
Grand Total Price Summary
| GRAND TOTAL PRICE SUMMARY | |
| Enter name of task order here | |
| Enter name of offeror or subcontractor preparing this table here | |
| Name of Prime Contractor: | If the contractor is a subcontractor, enter prime contractor's name here |
| Cost Element | TRANSITION | FULL OPERATIONAL CAPABILITY (FOC) | GRAND TOTAL | ||||||
| Total Proposed Amount | Base Year Total Proposed Amount | Option Year 1 Total Proposed Amount | Option Year 2 Total Proposed Amount | Option Year 3 Total Proposed Amount | Option Year 4 Total Proposed Amount | FAR 52.217-8 Option to Extend Services Total Proposed Amount | FOC Total | (Transition + FOC) | |
| Direct Labor | |||||||||
| Materials | Plug Number | Plug Number | Plug Number | Plug Number | Plug Number | ||||
| Equipment | Plug Number | Plug Number | Plug Number | Plug Number | Plug Number | ||||
| Other Direct Costs | |||||||||
| Direct Labor Overhead | |||||||||
| Indirect Costs | |||||||||
| Subtotal | |||||||||
| General & Administrative Costs | |||||||||
| Subtotal | |||||||||
| Facilities Capital Cost of Money (FCCOM) | |||||||||
| Subtotal (All Costs) | Plug Number | ||||||||
| Fixed Fee | |||||||||
| Grand Total Price |
Cost Reimbursable Pricing Proposal Format Tab: &A
Page &P of &N
Minor formatting changes are permitted to accommodate automated development of the table (e.g., use of an Excel Pivot Table).
The yellow highlighted cells identify where the offeror should insert the Government provided plug numbers.
Enter "Same" in cell B4, or delete Excel Row 4, if the contractor filling out this worksheet is the prime contractor.
Pricing by PWS-Site
| SUMMARY OF (indicate whether sheet is "TOTAL COST", "TOTAL FEE", or "TOTAL COST PLUS FEE") BY PWS AND SITE | |
| Enter name of task order here. | |
| Enter name of offeror or subcontractor preparing this table here | |
| Name of Prime Contractor: | If the contractor is a subcontractor, enter prime contractor's name here |
| FULL OPERATIONAL CAPABILITY (FOC) | |||||||||
| PWS | |||||||||
| No. | PWS Description | Site Code | Base Year Total Proposed Amount | Option Year 1 Total Proposed Amount | Option Year 2 Total Proposed Amount | Option Year 3 Total Proposed Amount | Option Year 4 Total Proposed Amount | FAR 52.217-8 Option to Extend Services Total Proposed Amount | FOC Total |
| 04.01 | Shelter and Billeting | QAT001 | |||||||
| QAT002 |
Subtotal
| 04.02.01 | Environmental Control | QAT001 |
| QAT002 | ||
| ARE001 |
Subtotal
Total Prior to Plug Numbers (See note 2)
| Materials Plug Number (See note 3) |
| Equipment Plug Number (See note 3) |
| Materials/Equipment Plug Number Adder 1 (See note 4) |
| Materials/Equipment Plug Number Adder 2 (See note 4) |
GRAND TOTAL (See note 5)
FILE: Cost Reimbursable Pricing Proposal Format
TAB: &A
Page &P of &N
NOTES:
1. This sheet is provided as a sample format to guide the offeror in the preparation of the Total Cost, Total Fee, and Total Cost Plus Fee summaries. The offeror will populate the PWS numbers, PWS descriptions, and site codes using the data contained in the applicable Technical Exhibits (Attachments 2-10). Further information on this is provided in Attachment 15, Cost Price Proposal Requirements, paragraph 2.b.
2. This line should reflect the sum of all subtotals shown above this line. The numbers for the Base Year through Option Year 4 should reconcile to the corresponding totals in the Offeror's "Details" tabs.
3. These lines should reflect the Government provided plug numbers.
4. Use these lines to price out any adders (e.g., material handling rate, overhead, G&A), etc., applicable to the materials/equipment plug numbers. Change the title to reflect the name of the adder. If the offeror has more than two adders, add additional rows as needed.
5. This line should reflect the sum of the "Total Prior to Plug Numbers", materials and equipment plug numbers, and the material/equipment plug number adders.
6. Minor formatting changes are permitted to accommodate automated development of the table (e.g., use of an Excel Pivot Table).
7. Enter "Same" in cell C4, or delete Excel Row 4, if the contractor filling out this worksheet is the prime contractor.
Rates Table
| ENTER NAME OF TASK ORDER HERE | |
| RATES/FACTORS TABLE | |
| Enter name of offeror or subcontractor preparing this table here | |
| Name of Prime Contractor: | If the contractor is a subcontractor, enter prime contractor's name here |
| FEE PERCENTAGE | RATE | |||
| Fixed Fee Percentage | X.XX% | |||
| INDIRECT RATES/COST OF MONEY FACTORS | ||||
| 1. Identification of Offeror's Fiscal Year: | Calendar Year | |||
| 2. Rates/Factor Table: | ||||
| DESCRIPTION | YEAR | RATE/ FACTOR | ALLOCATION BASE | BASIS |
| Fringe Rate A | FY 17 | XX.XX% | Non-supervisory Direct Labor | FPRA Dtd XX |
| Fringe Rate B | FY 17 | XX.XX% | Supervisory/Mgt Direct Labor | FPRA Dtd XX |
| Labor Overhead | FY 17 | XX.XX% | Total Direct Labor | FPRA Dtd XX |
| OTHER RATES/FACTORS | ||||
| DESCRIPTION | YEAR | RATE/ FACTOR | ALLOCATION BASE | BASIS |
| Bonus A | FY 17 | XX.XX% | Non-supervisory Direct Labor | Based on rates used on XXX contract. The XXX contract is similar to this effort. |
| Bonus B | FY 17 | XX.XX% | Supervisory/Mgt Direct Labor | Based on rates used on XXX contract. The XXX contract is similar to this effort. |
| DBA Insurance | FY 17 | XX.XX% | Total Direct Labor | (Name of Insurance Co.) quote dated XX. |
| Airfare - (City, State of Home Office) to (Location) | FY 17 | $XXX.XX | All Personnel traveling to (location) | Quote from (name of travel agency, etc.) dated XX. |
NOTES ON THIS SHEET:
1. While a rates table is required for each task order, the offeror may use this table, or a table using the offeror's own format, as long as it provides the data requested in Attachment 0015 - Cost Price Proposal Requirements. If this sheet is used in lieu of the offeror's own format, the blue highlighted cells identify those cells that require fill-ins from the offeror.
2. The rates table should be used to identify rates and factors (both indirect and other rates) proposed for use within the offeror's proposal. The offeror shall add additional rows as needed. The offeror should also identify the offeror's proposed fixed fee percentage for each task order in the space provided. Examples are provided in italics. These examples may be removed when submitting the proposal.
3. The offeror should identify the period of its fiscal year (e.g., "Calendar Year", "1 April through 31 March", etc.) in the space provided.
4. Offerors are not precluded from providing additional columns if they consider them necessary or appropriate.
5. The reference to the year doesn't preclude offerors from providing composite rates if desired. If so, the "Basis" column or a notes column should indicate the rate is a composite rate. Further, the rate shown should be linked to the offeror's calculations showing how the composite rate was calculated. These calculations must contain working formulae. The calculations should contain notes as appropriate to explain them.
6. The table for "Other Rates/Factors" is intended as a place to identify rates/factors other than indirect and cost of money rates. The offeror should organize and group related rates in a logical manner.
7. Enter "Same" in cell D4, or delete Excel Row 4, if the contractor filling out this worksheet is the prime contractor.
Labor Details
| LABOR SCHEDULE | |
| Enter name of task order here | |
| Enter name of offeror or subcontractor preparing this table here | |
| Name of Prime Contractor: | If the contractor is a subcontractor, enter prime contractor's name here |
| PWS Para # | ||
| (See notes) | PWS Paragraph / Sub-Paragraph Description | |
| (See notes) | CLIN | Resource Type |
| (See notes) | Period |
(See notes)
| Site Code | ||||||||||||
| (See notes) | Subcontractor | |||||||||||
| (see notes) | Labor Category | |||||||||||
| (i.e., Job Title) | Unique Identifier (See notes) | Base (Hourly) Labor Rate | ||||||||||
| (See notes) | Type of Labor | |||||||||||
| (See notes) | FTE | Productive Hours | ||||||||||
| (See notes) | Direct Charged Non-Productive Hours | |||||||||||
| (See notes) | Direct Labor Cost Prior to Uplifts, Adders, etc. | Rate Identifier (See notes) | Overtime Cost | Uplift 1 | Uplift 2 | Direct Labor Overhead | Indirect Costs | G&A | FCCOM | Subtotal | Fixed Fee | Grand Total Price |
Grand Total
| BREAKOUT OF GRAND TOTALS BY PERIOD: |
| B |
| OY 1 |
| OY 2 |
| OY 3 |
| OY 4 |
| Grand Total |
Cost Reimbursable Pricing Proposal Format Tab: &A
Page &P of &N
NOTES:
1. The yellow highlighted column titles are mandatory unless the notes below provide otherwise. The offeror shall add columns as necessary to accommodate its estimating and accounting practices, or to provide additional information as appropriate. Such columns may be inserted in appropriate locations in the above table.
2. Offerors shall insert as many rows as are necessary to identify all direct charged resources for each CLIN/PWS/period/site. Each row will identify one discrete labor category for the CLIN/PWS/period/site listed for that row.
3. PWS Para # and Description: The offeror shall enter the appropriate PWS number and its corresponding description from the "Data Pkg for A.1 and H.2" tab of the applicable Technical Exhibit (see Attachments 2-10) for each row of data. Note that the column labeled "WBS Ref." in the "Data Pkg" tab is the PWS number. Only those PWS numbersand sites that have been activated require pricing.
4. CLIN: The offeror shall enter the CLIN number from Schedule B to identify what CLIN each row's cost information pertains to.
5. Resource Type: If a single schedule is used to list both labor and ODCs, use the codes listed below to identify the type of resource being proposed on each row. The schedule name in cell A1 should be changed accordingly. Otherwise this column may be deleted.
L - Labor O - Other Direct Costs
6. Period: Offerors should use the codes listed below to identify the period applicable to the cost being proposed. No code is provided for the FAR 52.217-8 Option to Extend Services period as the offeror does not need to separately estimate the resources, costs, and fees for this period. If the offeror chooses to do so, provide a code to identify these costs.
FOC: B - Base Year OY 1 - Option Year 1 OY 2 - Option Year 2 OY 3 - Option Year 3 OY 4 - Option Year 4
7. Site Code: The offeror shall enter the appropriate site code from the "Data Pkg for A.1 and H.2" tab of the applicable Technical Exhibit (see Attachments 2-10) for each row proposed, or its own code if the work is being performed at a location other than the Government site.
8. Subcontractor: Subcontracted labor resources shall be listed in the schedule. Identify the name of the subcontractor providing the resource. If no subcontracted labor is being proposed, this column may be deleted.
9. Labor Category (i.e., Job Title): The labor category descriptions used here should be consistent with the descriptions used in the offeror's labor staffing model.
10. Unique Identifier: List the unique identifier from the Labor Staffing Model that is applicable to the listed labor category. For any given identifier, there should be an exact match in the labor category description as used in both the Labor Staffing Model and this worksheet. The unique identifier should be the same for a given labor category description across all GCC/ASCCs, even though labor rates may differ due to the differing GCC/ASCCs.
11. Base (Hourly) Labor Rate:
a. For the prime contractor, and cost reimbursable subcontractors submitting subcontract proposals using this worksheet, this should identify the basic HOURLY rate of compensation, inclusive of any applicable escalation to the period of performance in question, prior to the addition of any additional compensation for overtime premiums, shift premiums, uplifts (whether company-provided or Department of State uplifts), fringes, etc.
b. Prime contractors and higher tier subcontractors should include subcontractor's fully burdened rates in this column, unless the prime contractor or higher tier subcontractor knows the subcontractor's basic labor rates. In this case, that rate should be used in this column. Additional columns should be provided to incorporate the subcontractor's adders.
12. Type of Labor: The offeror should use the codes EXPAT, FN, LN, or US to identify whether the Job Title is a US expat, foreign national, local national, or US based labor, respectively. This is required whether the labor is provided by the prime contractor or subcontractor.
13. Productive Hours and Direct Charged Non-Productive Hours: If it is an offeror's practice to propose non-productive time as a direct charge, such hours should be separately identified. If non-productive time is not direct charged, the non-productive time column may be removed.
14. Rate Identifier (column title may be changed): If the costs for a given column in any one period of performance are based on two or more rates, the offeror should provide an appropriately titled column that identifies the rate being used in the calculations for each row, or provides a code that can be used to identify the appropriate rate. For example, an offeror proposes fringe rate X for Division A employees, and fringe rate Y for Division B employees; this column should either provide the fringe rate, or the division name or unique code to identify the division in question. The Government needs some readily available means to filter data for a given rate. Depending on the offeror's circumstances and proposal preparation methodology, more than one rate identifier column may be needed.
15. Labor Adders: If proposed compensation includes more than just basic labor pay (i.e., proposed compensation includes additional items such uplifts (e.g., danger pay), overtime premiums, shift premiums, bonuses, etc.), each such adder should be separately identified and costed out.
16. Offerors should include a Grand Total row at the bottom of the table to show the grand total for each column of cost.
17. Offerors should provide a breakout of the Grand Total row's costs and fee by period in the spaces provided. A breakout by period is sufficient.
18. Enter "Same" in cell C4, or delete Excel Row 4, if the contractor filling out this worksheet is the prime contractor.
(See note "Labor Adders")
ODC Details
| ODC SCHEDULE | |
| Enter name of task order here | |
| Enter name of offeror or subcontractor preparing this table here | |
| Name of Prime Contractor: | If the contractor is a subcontractor, enter prime contractor's name here |
| PWS Para # | ||
| (See notes) | PWS Paragraph / Sub-Paragraph Description | |
| (See notes) | CLIN | Resource Type |
| (See notes) | Period |
(See notes)
| Site Code | ||||||||||
| (See notes) | Subcontractor | |||||||||
| (see notes) | Description | Quantity | Unit Cost | |||||||
| (See notes) | Unit of Measure | |||||||||
| (See notes) | Extended Cost Prior to Adders | Rate Identifier (See notes) | Indirect Costs | G&A | FCCOM | Subtotal | Fixed Fee | Grand Total Price | Source/ Vendor/ Supplier | Basis for Pricing |
Grand Total
| BREAKOUT OF GRAND TOTALS BY PERIOD: |
| B |
| OY 1 |
| OY 2 |
| OY 3 |
| OY 4 |
| Grand Total |
Cost Reimbursable Pricing Proposal Format Tab: &A
Page &P of &N
NOTES:
1. The yellow highlighted column titles are mandatory unless the notes below provide otherwise. The offeror shall add columns as necessary to accommodate its estimating and accounting practices, or to provide additional information as appropriate. Such columns may be inserted in appropriate locations in the above table.
2. Offerors shall insert as many rows as are necessary to identify all direct charged resources for each CLIN/PWS/period/site. Each row will identify one discrete resource for the CLIN/PWS/period/site listed for that row.
3. PWS Para # and Description: The offeror shall enter the appropriate PWS number and its corresponding description from the "Data Pkg for A.1 and H.2" tab of the applicable Technical Exhibit (see Attachments 2-10) for each row of data. Note that the column labeled "WBS Ref." in the "Data Pkg" tab is the PWS number. Only those PWS numbersand sites that have been activated require pricing.
4. CLIN: The offeror shall enter the CLIN number from Schedule B to identify what CLIN each row's cost information pertains to.
5. Resource Type: If a single schedule is used to list both labor and ODCs, use the codes listed below to identify the type of resource being proposed on each row. The schedule name in cell A1 should be changed accordingly. Otherwise this column may be deleted.
L - Labor O - Other Direct Costs
6. Period: Offerors should use the codes listed below to identify the period applicable to the cost being proposed. No code is provided for the FAR 52.217-8 Option to Extend Services period as the offeror does not need to separately estimate the resources, costs, and fees for this period. If the offeror chooses to do so, provide a code to identify these costs.
FOC: B - Base Year OY 1 - Option Year 1 OY 2 - Option Year 2 OY 3 - Option Year 3 OY 4 - Option Year 4
7. Site Code: The offeror shall enter the appropriate site code from the "Data Pkg for A.1 and H.2" tab of the applicable Technical Exhibit (see Attachments 2-10) for each row proposed, or its own code if the work is being performed at a location other than the Government site.
8. Subcontractor: Subcontracted ODC resources shall be listed in the schedule. Identify the name of the subcontractor providing the resource. If no subcontracted ODC resources is being proposed, this column may be deleted.
9. Not used.
10. Unit Cost: This should be the unit cost or price of the product or service itself. It should not include add-ons such as material handling, etc. If the unit cost or price shown is not consistent with the offeror's support, the offeror should explain why.
11. Unit of Measure: If codes or abbreviations are used, the offeror should provide an acronym list in the proposal to facilitate understanding the code or abbreviation.
12. Rate Identifier (column title may be changed): If the costs for a given column in any one period of performance are based on two or more rates, the offeror should provide an appropriately titled column that identifies the rate being used in the calculations for each row, or provides a code that can be used to identify the appropriate rate. For example, an offeror proposes material handling rate X for Division A materials, and material handling rate Y for Division B materials: this column should either provide the material handling rate, or the division name or unique code that can identify the division in question. The Government needs some readily available means to filter data for a given rate. Depending on the offeror's circumstances and proposal preparation methodology, more than one rate identifier column may be needed.
13. Source/Vendor/Supplier: This should identify the actual manufacturer, dealer, etc., of the material/equipment/other direct costs. If the line in question is identifying a subcontract, this information is not needed (the subcontractor proposal should contain this information).
14. Basis for Pricing: Identify whether pricing is based on vendor quotes, invoice prices, subcontract, etc.
15. In lieu of repetitively listing the source/vendor/supplier and basis for pricing for the same items, the offeror may provide, in addition to this schedule, a consolidated summary of this schedule for the purpose of providing the source/vendor/supplier and basis for pricing information.
16. Offerors should include a Grand Total row at the bottom of the table to show the grand total for each column of cost.
17. Offerors should provide a breakout of the Grand Total row's costs and fee by period in the spaces provided. A breakout by period is sufficient.
18. Enter "Same" in cell C4, or delete Excel Row 4, if the contractor filling out this worksheet is the prime contractor.
See notes
Subcontract Summary
| SUBCONTRACT SUMMARY | ||||||||
| Enter name of task order here | ||||||||
| Enter name of offeror or subcontractor preparing this table here | ||||||||
| Name of Prime Contractor: | If the contractor is a subcontractor, enter prime contractor's name here | |||||||
| SUBCONTRACTOR NAME | ELEMENT | FULL OPERATIONAL CAPABILITY (FOC) | ||||||
| Base Year Total Proposed Amount | Option Year 1 Total Proposed Amount | Option Year 2 Total Proposed Amount | Option Year 3 Total Proposed Amount | Option Year 4 Total Proposed Amount | FAR 52.217-8 Option to Extend Services Total Proposed Amount | FOC Total | ||
| Subcontractor 1 | Labor | |||||||
| ODC | ||||||||
| Subtotal | ||||||||
| Subcontractor 2 | Labor | |||||||
| ODC | ||||||||
| Subtotal | ||||||||
| Subcontractor 3 | Labor | |||||||
| ODC | ||||||||
| Subtotal | ||||||||
| Total |
File: Cost Reimbursable Pricing Proposal Format Tab: &A
PAGE &P OF &N
INSTRUCTIONS:
1. The offeror shall enter the names of the proposed subcontractor(s) in the spaces provided. If the offeror proposes more than three subcontractors, the offeror shall add additional space using the format shown.
2. For each subcontractor, insert the subcontractor's total proposed price (DO NOT include the prime contractor's add-ons and fees) in the spaces provided for the appropriate element of cost and period. If no subcontract cost is included in a particular element for a particular subcontractor, that element may be removed from the list for that subcontractor (e.g., subcontractor ABC is listed only in the Labor schedule; the ODC row may be deleted for ABC). The totals included in these tables should be consistent with the totals that are included in the corresponding detailed supporting schedule(s).
3. Populate the "Subtotal" line for each subcontractor.
4. Populate the "Total" line to show the total value for all subcontractors.
5. Enter "Same" in cell E4, or delete Excel Row 4, if the contractor filling out this worksheet is the prime contractor.
File details come from the government source that posted it. Updated .