Attachment 6 Coefficient Non-PrePriced Items JOC 24R0002 DPG 010324.xlsx
XLSX spreadsheet 17 KB Posted
- Solicitation number
- W911S6-24-R-0002
About this file
This document is Attachment 6 - Development of Coefficient for Non-Pre-Priced Items for Solicitation W911S6-24-R-0002, a Job Order Contract (JOC) for minor construction work at Dugway Proving Ground.
The key details are: The contractor must provide a coefficient for non-pre-priced (NPP) line items, which cannot exceed 10% of the contract value. The contractor must explain their methodology for determining the value of the pre-priced Unit Price Book (UPB) and developing the coefficient, which should account for factors such as the accuracy of the UPB, expected task order awards volume, and total contractor markup. NPP items must be proposed at bare costs only, without any overhead or profit included, and supported by documentation such as competitive quotes. All pricing components must be included in the contractor's coefficients, as no allowances will be made for omitted costs later.
View the file
Other files
Show all 30
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
| 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 6&"Times New Roman,Regular" Development of Coefficient for Non-Pre-Priced Items Solicitation: W911S6-24-R-0002
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 Dugway Proving Ground 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 Dugway Proving Groundtask 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 6&"Times New Roman,Regular" Development of Coefficient for Non-Pre-Priced Items Solicitation: W911S6-24-R-0002
File details come from the government source that posted it. Updated .