Attachment 7 Coefficient Non-PrePriced Items - Bliss JOC W911SG20R0042.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
FORT BLISS JOB ORDER CONTRACT
Solicitation number
W911SG20R0042
Issued by

About this file

This document contains details for a solicitation for a Job Order Contract to provide real property sustainment, restoration, and modernization minor construction services at Fort Bliss, Texas. The Mission and Installation Contracting Command at Fort Bliss is seeking proposals for a single-award indefinite delivery/indefinite quantity contract with a one-year base period and four one-year options periods valued between $75-100 million. Task orders will range from $2,000 to $1 million for small, multi-trade projects involving site work, demolition, mechanical systems, infrastructure preservation, renovation, and finish replacements. The contract is fully set aside for small businesses classified under NAICS code 236220 with a size standard of $39.5 million. Proposals are due through the Beta SAM website by the specified deadline.

View the file

Other files

File Type Posted
Attachment 7 Coefficient Non-PrePriced Items Texas - Bliss JOC 2 Aug 2021 W911SG20R0042.xlsx XLSX spreadsheet
Attachment 6 Coefficient Other Than Normal Texas - Bliss JOC 2 Aug 2021 W911SG20R0042.xlsx XLSX spreadsheet
Attachment 7a Coefficient Non-PrePriced Items New Mexico - Bliss JOC 2 Aug 2021 W911SG20R0042.xlsx XLSX spreadsheet
SOLICITATION Conform Copy 0003 FORT BLISS JOC W911SG20R0042.pdf PDF
Attachment 9 RFIs 2 Aug 2021 W911SG20R0042.pdf PDF
Technical Exhibit A Division 1 General Requirements 2 Aug 2021.pdf PDF
SOLICITATION Amendment 0003 FORT BLISS JOC W911SG20R0042-0003.pdf PDF
Attachment 8 Historical Workload 2 Aug 2021 W911SG20R0042.pdf PDF
Attachment 5a Coefficient Normal New Mexico - Bliss JOC 2 Aug 2021 W911SG20R0042.xlsx XLSX spreadsheet
Attachment 5 Coefficient Normal Texas - Bliss JOC 2 Aug 2021 W911SG20R0042.xlsx XLSX spreadsheet
Attachment 6a Coefficient Other Than Normal New Mexico - Bliss JOC 2 Aug 2021 W911SG20R0042.xlsx XLSX spreadsheet
SOLICITATION Conform Copy 0002 FORT BLISS JOC W911SG20R0042.pdf PDF
SOLICITATION Amendment 0002 FORT BLISS JOC W911SG20R0042-0002.pdf PDF
SOLICITATION Amendment 0001 FORT BLISS JOC W911SG20R0042-0001.pdf PDF
SOLICITATION Conform Copy 0001 FORT BLISS JOC W911SG20R0042.pdf PDF
Attachment 1 Consent Letter - Bliss JOC W911SG20R0042.docx DOCX document
Technical Exhibit AD Div 44 Pollution Control Equipment.pdf PDF
Attachment 6 Coefficient Other Than Normal - Bliss JOC W911SG20R0042.xlsx XLSX spreadsheet
Technical Exhibit Q Div 13 Special Construction.pdf PDF
Attachment 4a Notional Task Order Technical Drawings - Bliss JOC W911SG20R0042.pdf PDF
Technical Exhibit Z Div 32 Exterior Improvements.pdf PDF
Technical Exhibit AE Div 46 Water and Wastewater Equipment.pdf PDF
Technical Exhibit AB Div 34 Transportation.pdf PDF
Technical Exhibit C General Decision TX20210245.pdf PDF
Technical Exhibit T Div 22 Plumbing.pdf PDF
Technical Exhibit N Div 10 Specialties.pdf PDF
Technical Exhibit AA Div 33 Utilities.pdf PDF
Technical Exhibit J Div 06 Wood-Plastics-Composites.pdf PDF
Technical Exhibit F Div 02 Existing Conditions.pdf PDF
FORT BLISS JOC SOLICITATION W911SG20R0042.pdf PDF
Technical Exhibit O Div 11 Equipment.pdf PDF
Technical Exhibit B Areas of Fort Bliss with Historical Workload.pdf PDF
Technical Exhibit V Div 26 Electrical.pdf PDF
Technical Exhibit E General Decision NM20210045.pdf PDF
Technical Exhibit I Div 05 Metals.pdf PDF
Technical Exhibit K Div 07 Thermal and Moisture Protection.pdf PDF
Technical Exhibit S Div 21 Fire Suppression.pdf PDF
Technical Exhibit X Div 28 Electronic Safey and Security.pdf PDF
Attachment 4 Notional Task Order - Bliss JOC W911SG20R0042.pdf PDF
Technical Exhibit P Div 12 Furnishings.pdf PDF
Technical Exhibit U Div 23 HVAC.pdf PDF
Technical Exhibit Y Div 31 Earthwork.pdf PDF
Technical Exhibit H Div 04Masonry.pdf PDF
Technical Exhibit AC Div 35 Waterway.pdf PDF
Attachment 2 Specific Relevant Contracts - Bliss JOC W911SG20R0042.docx DOCX document
Attachment 3 Past Performance Questionnaire - Bliss JOC W911SG20R0042.docx DOCX document
Technical Exhibit L Div 08 Openings.pdf PDF
Technical Exhibit A Division 1 General Requirements.pdf PDF
Attachment 5 Coefficient Normal- Bliss JOC W911SG20R0042.xlsx XLSX spreadsheet
Technical Exhibit G Div 03 Concrete.pdf PDF
Show 40 more

Latest 50 of 54 listed here. See the rest on GovTribe.

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 7&"Times New Roman,Regular" Development of Coefficient for Non-Pre-Priced Items Solicitation: W911SG-20-R-0042

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 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 .