Exhibit F- Coefficient Non-PrePriced.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Carlisle Barracks Job Order Contract (JOC)
- Solicitation number
- W5168W26RA007
- Issued by
-
Department of the Army
About this file
This is an attachment providing instructions and a template for developing coefficients for Non-Pre-Priced (NPP) items under a Job Order Contract solicitation. The document outlines the framework for contractors to price work items not covered by the pre-priced Means Unit Price Book (UPB) used in the contract, with NPP work capped at 10 percent of contract value and prohibited from comprising an entire task order.
Contractors must complete the Coefficient Breakdown Form and provide detailed documentation supporting their NPP pricing methodology, which may include comparison of local subcontractor quotes to UPB equivalents, mathematical models using historical task order data, or weighted average analysis of past actual costs. For NPP items valued at $2,500 or more, offerors must provide at least three competitive quotes or catalog prices; items under $2,500 require a minimum of two competitive quotes. NPP proposals must include bare costs only for materials (excluding overhead), labor (including payroll taxes but excluding vacation and labor overhead), and equipment used solely for the NPP item, multiplied by the NPP indirect costs and profit rate. The coefficient formula C = VUPB × EATOA / (EATOA - CCC) incorporates the value of UPB, estimated annual task order awards, and total contractor markup to determine the final coefficient. All price components must be included in coefficients as no allowance for omitted costs will be permitted later.
View the file
Other files
Show all 29
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
Coefficient Breakdown CLIN X003 U/M Qty Amount
Estimated Annual Task Order Awards (EATOA) NPP $ 440,000.00
| Note: See Instructions |
| BARE COSTS ONLY: |
| Material Costs |
| Labor Costs |
| Equipment to be used solely as a result of inclusion of NPP item, whether by the prime or a subcontractor, or both. |
Total Costs Covered By Coefficient (CCC) 0
Value of the UPB (VUPB) - includes subcontractor overhead and profit
NPP Coefficient (UPB Estimate) ERROR:#DIV/0!
&"Times New Roman,Bold"&12ATTACHMENT 7&"Times New Roman,Regular" Development of Coefficient for Non-Pre-Priced Items Solicitation: Ft. Stewart JOC W5168W25RA024
Instructions
| Coefficient Instructions: NPP work shall not exceed 10% of the contract value/task order. No Task Order will consist solely of NPP work. |
| Non-pre-priced line items (NPP) shall only be allowed if the Government deems that an appropriate line item is not provided by the pre-priced RSMeans UPB |
| To permit recurrent use, a non-pre-priced line item shall be incorporated by supplemental agreement into the pre-priced UPB. This may be done at any time during the contract period |
The offeror shall complete Attachment 7, Coefficient Breakdown Form for each coefficient and explain the basis for the methodology and development of each coefficient. The explanation shall, at a minimum address the following:
| 1. The offeror’s perception of the accuracy or value of the (contract-required UPB) for Fort Irwin and which of the following methodologies and types of empirical quantitative evidence was used to determine its value: |
| a. Comparison of local subcontractor quotes to the equivalent estimates developed using the UPB for all trades. The individual trade ratios are weighted to reflect the amount of work expected by trade, and the resulting weighted |
| average is the value of the UPB. Provide narrative and detailed Excel worksheet(s) showing how the offeror applied this method. |
| b. A mathematical model developed using historical task order pricing data along with continued verification of model accuracy through cross-validations. Provide narrative and detailed Excel worksheet(s) to describe the model |
| and the cross-validations used to confirm model accuracy or value for this UPB. |
| c. A historical weighted average analysis of past Fort Irwin task orders actual costs to UPB estimated costs. Provide narrative, detailed Excel worksheet(s), and graph(s) showing analysis. |
| d. Other – explain in detail through narrative, Excel worksheet(s), and graph(s) methodology used. |
| e. Note – the value of the UPB shall be “net” (e.g., 1.00) or a percentage “decrease from” (e.g., 0.95) or “increase to” (e.g., 1.05) the unit prices listed in the UPB. The offeror’s accuracy of the UPB shall not extend beyond two decimal places. |
2. The basis for any assumptions regarding the expected “awards volume” (T.O. awards).
3. The on-site staff supporting the expected awards volume under the contract. List positions and full time equivalent (FTE) employee numbers.
| 4. The development of each coefficient using the following as a guide: |
| a. The coefficient associated with the UPB is based on the accuracy of the UPB, the expected awards volume, and the total contractor markup. |
| b. To determine the coefficient (C) the following information is needed: |
| 1. The ratio of the local market supporting the JOC/SABER work to the UPB, which is referred to as the “value of UPB” (VUPB). |
| 2. The estimated annual task order awards (EATOA). |
| 3. The total contractor markup, the costs including prime contractor profit being covered by the coefficient (CCC). |
| a. The Cost Covered by the Coefficients (CCC) shall be inclusive of all Division 00 Adjustment Factors including, but not limited to, overhead, profit, taxes, etc. Note subcontractor overhead and profit will be accounted for in the |
| value of the UPB not in the contractor markup. |
| 4. In formula form it can be stated as follows: C = VUPB * EATOA / (EATOA – CCC). |
| All components of price shall be included in the offeror’s coefficients as no allowance for an omitted cost will be made later. |
| The Government reserves the right to require the submission of Other Than Certified Cost or Pricing Data as is deemed necessary to arrive at a fair and reasonable price. |
| COEFFICIENT: The Offerors NPP coefficient shall contain all costs already associated with their Pre-Priced Coefficient for Normal Working Hours and is subject to the following additional information: |
| 1. Care shall be taken in pricing the NPP item(s)to ensure that costs and profit already present in the coefficient applied to prepriced items are not included in the cost of the item(s). |
| 2. Indirect costs and profit is defined as all costs associated with performing the tasks, other than direct labor, equipment and material costs. |
| 3. NPP proposals shall be supported with verifiable documentation supporting competitive quotes (minimum of two), catalog price, etc., for all NPP work. |
| 4. NPP items with a value of $2,500 or more shall be supported with verifiable documentation such as at least three (3) competitive quotes or catalog prices. |
| 5. NPP items shall be proposed in bare costs only (material, equipment and labor) multiplied by the quantity and the NPP indirect costs and profit rate (if applicable) to arrive at the total price for the NPP work. |
| 6. NPP items shall be proposed in bare costs only (material, equipment, and labor). |
| a. Material costs, which may include freight but may not include any overhead or associated costs whether by the prime or a subcontractor, or both |
| b. Labor costs, which may include associated payroll taxes such as FICA, FUTA, SUI, but excludes vacation, sick leave, or any labor overheads, whether by the prime or a subcontractor, or both |
| c. Equipment that is to be used solely as a result of the inclusion of the non-pre-priced item, whether by the prime or a subcontractor, or both. |
All components of price shall be included in the Offerors coefficients as no allowance for an omitted cost will be made later.
&"Times New Roman,Bold"&12ATTACHMENT 7&"Times New Roman,Regular" Development of Coefficient for Non-Pre-Priced Items Solicitation: W91151-17-R-0064
File details come from the government source that posted it. Updated .