Exhibit F- Coefficient Non-PrePriced.xlsx
XLSX spreadsheet 17 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 offerors to develop and submit coefficients for non-pre-priced (NPP) items under the Carlisle Barracks Job Order Contract (JOC) solicitation W5168W26RA007. The document outlines the requirements, methodology, and calculation formulas for pricing NPP line items that fall outside the pre-priced RSMeans Unit Price Book (UPB).
Non-pre-priced work shall not exceed 10% of the contract value per task order, and no task order may consist solely of NPP work. NPP items are only permitted when the Government determines that an appropriate line item does not exist in the pre-priced UPB. Offerors must complete the Coefficient Breakdown Form and provide detailed explanations of their methodology, including: the offeror's assessment of UPB accuracy using one of four specified methodologies (local subcontractor quotes, mathematical models, historical weighted average analysis, or other justified approaches); basis for expected task order award volumes; and on-site staffing plans. NPP pricing must be submitted in bare costs only, segregated by material costs (including freight but excluding overhead), labor costs (including payroll taxes but excluding benefits or labor overhead), and equipment solely required for the NPP item. Items valued at $2,500 or more require at least three competitive quotes or catalog prices; items under $2,500 require minimum two quotes. All bare costs are multiplied by quantity and the NPP indirect cost and profit rate to reach the total price. The coefficient formula is: C = VUPB × EATOA / (EATOA - CCC), where VUPB is the value of UPB, EATOA is estimated annual task order awards, and CCC is total contractor markup costs. Offerors must ensure no duplication of costs already included in pre-priced coefficients and provide all supporting documentation; no allowance for omitted costs will be granted 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 Amount of Task Order Awards (EATOA) NPP 1 $ 2,000,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 W5168W26RA007
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 .