Attachment 05 Coefficient Development - JOC 6 Aug 2021.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Job Order Contract - Minor Construction and Repair of Facilities
Solicitation number
W911S8-21-R-0003
Issued by

About this file

This document provides details for a Job Order Contract solicitation to provide minor construction and repair services at Joint Base Lewis-McChord in Washington state. The solicitation seeks a single-award indefinite delivery indefinite quantity job order contract with a one-year base period and four one-year option periods for an estimated total value of $50 million. Task orders issued against the contract will range in value from $2,000 to $1 million for work such as site work, demolition, building repairs, mechanical system replacements, and some vertical construction. Competition is limited to qualified 8(a) small businesses with a bona fide office in the Seattle SBA district and NAICS code 236220. The solicitation will be available on beta.SAM and any amendments posted there, with no paper copies distributed. The designated agency is the Department of the Army Materiel Command Mission and Installation Contracting Command at Joint Base Lewis-McChord.

View the file

Other files

File Type Posted
W911S8-21-R-0003 Amendment 0008.pdf PDF
Exhibit 39 - Coefficient Schedule rev 6 Aug 21.docx DOCX document
Exhibit 09 - 6 Aug 21.pdf PDF
Attachment 04 Notional Task Order Requirements - JOC W911S8-21-R-0003 JBLM rev. 6 Aug 2021.pdf PDF
W911S8-21-R-0003 Amendment 0007.pdf PDF
JOC QAs with Consolidated Responses 12 Aug 2021.pdf PDF
Exhibit 01 - General Requirements - rev 6 Aug 21.pdf PDF
W911S8-21-R-0003-0006.pdf PDF
W911S8-21-R-0003-0005.pdf PDF
W911S8-21-R-0003-0004.pdf PDF
W911S8-21-R-0003 0003.pdf PDF
W911S8-21-R-0003 0002.pdf PDF
Exhibit 36 - Pierce Co WD - 2 Apr 21.pdf PDF
Exhibit 38 - Jefferson Co WD - 2 Apr 21.pdf PDF
W911S8-21-R-0003 0001.pdf PDF
Exhibit 35 - King Co WD - 2 Apr 21.pdf PDF
Exhibit 14 - 1 Oct 20.pdf PDF
Attachment 05 Coefficient Development - JOC 20201026.xlsx XLSX spreadsheet
Exhibit 21 - 1 Oct 20.pdf PDF
Exhibit 03 - 1 Oct 20.pdf PDF
Exhibit 12 - 1 Oct 20.pdf PDF
Exhibit 19 - 1 Oct 20.pdf PDF
Exhibit 37 - Yakima Co WD - 22 Jan 21.pdf PDF
Exhibit 23 - 1 Oct 20.pdf PDF
Exhibit 04 - 1 Oct 20.pdf PDF
Exhibit 08 - 1 Oct 20.pdf PDF
Exhibit 27 - 1 Oct 20.pdf PDF
Exhibit 22 - 1 Oct 20.pdf PDF
Exhibit 39 - 9 Oct 20.pdf PDF
Exhibit 07 - 1 Oct 20.pdf PDF
Attachment 03 Past Performance Questionnaire - JOC W911S8-21-R-0003 JBLM 20210202.pdf PDF
Exhibit 17 - 1 Oct 20.pdf PDF
Exhibit 24 - 1 Oct 20.pdf PDF
Exhibit 25 - 1 Oct 20.pdf PDF
Exhibit 33 - Mar 2014.pdf PDF
Exhibit 05 - 1 Oct 20.pdf PDF
Exhibit 35 - King Co WD - 26 Feb 21.pdf PDF
Exhibit 15 - 1 Oct 20.pdf PDF
Exhibit 34 - ENG Form 4288-R.xlsx XLSX spreadsheet
Exhibit 13 - 1 Oct 20.pdf PDF
Exhibit 26 - 1 Oct 20.pdf PDF
Attachment 01 Consent Letter - JOC W911S8-21-R-0003 JBLM 20201026.docx DOCX document
Exhibit 10 - 1 Oct 20.pdf PDF
Exhibit 32 - 1 Oct 20.pdf PDF
Solicitation_W911S821R0003_Job Order Contract_JBLM_2 April 2021.pdf PDF
Exhibit 36 - Pierce Co WD - 29 Jan 21.pdf PDF
Exhibit 02 - 1 Oct 20.pdf PDF
Exhibit 16 - 1 Oct 20.pdf PDF
Attachment 04 Notional Task Order Requirements - JOC W911S8-21-R-0003 JBLM 20201026.pdf PDF
Exhibit 29 - 1 Oct 20.pdf PDF
Show 40 more

Latest 50 of 63 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 X001 U/M Qty Amount

Estimated Annual Task Order Awards (EATOA) $ 10,000,000.00

Costs Covered By Coefficient (CCC)
Note:
No additional payments of any kind whatsoever will be made. All costs not included in the unit prices must be part of the coefficient.
Cost Items should be added, removed, or separated as the offeror deems necessary to demonstrate a detailed breakdown of costs covered by the coefficient.
Division 00 Adjustment Factors of the RSMeans Facilities Construction Cost Data
BUSINESS COSTS:
Overhead costs, including, unless specifically excluded in the Contract Documents, but not limited to;
Home office overhead
Insurance, bonds, and indemnification
Project meetings, training, management and supervision
Mobilization and close-out for the contract and each Job Order
Project office staff and equipment. Breakdown staff and equipment:
Profit.
Subcontractor's overhead and profit. Accounted for in value of UPB (VUPB).In VUPB
All taxes for which a waiver is not available including material sales tax and equipment rental
Employee or Subcontractor’s wage rates that exceed the prevailing wage rates.
Fringe benefits, payroll taxes, worker’s compensation, insurance costs and any other payment mandated by law in connection with labor that exceeds the labor rate allowances.
Cost of financing the work.
Business risks such as the risk of a lower than expected volume of work, smaller than anticipated Job Orders, poor Subcontractor performance, and inflation or material cost fluctuations.
CONSTRUCTION RELATED COSTS:
Services required to obtain filings and permits.
Preparation and modification of proposals, sketches, drawings, submittals, as-built drawings, CADD drawings, microfilm, and other project records.
Incidental engineering and architectural services.
Office trailer and portable toilets for Contractor’s use. Breakdown costs:
Construction vehicles such as pick-up trucks, utility trucks, vans, flat bed trucks, tractors, trailers, etc.
Storage devices or items such as gang boxes and containers for Contractor's tools, equipment and materials.
Basic safety and warning signage, minor barricades (e.g., construction tape, etc.) and personnel safety equipment (e.g., hard hats, safety harnesses with lifeline or cabling, protective clothing, safety glasses, face shields, etc.).
Meeting Owner security requirements.
Excess waste including roofing, drywall, VCT, carpet, wall covering, ceiling tile, pipe, conduit, siding, concrete, etc. This list is not intended to be all inclusive, but descriptive of the types of construction materials that are typically sold in standard lengths, sizes and weights.
Removing and returning Owner's furniture and furnishings (e.g. chairs, tables, pictures, etc. but excluding modular furniture, wall or ceiling attached or fastened devices or furnishings, safes or other furniture requiring disassembly).
Sealing, windows, and openings with plastic to contain construction dust and debris within the work area.
Daily clean-up.
Final professional project clean-up.
Costs resulting from inadequate supply of building materials, fuel, electricity, or skilled labor.
Costs resulting from productivity loss.
Working in extreme temperatures (below or above normal) or adverse conditions such as excessive rain, wind, sleet or snow.
Differences in project size; complexity and location.
All costs for other than discreet items of work specifically required to complete a particular Job Order.

Total Costs Covered By Coefficient (CCC) 0

Dollars left for Trades (EATOA - CCC) 10000000

Value of the UPB (VUPB) - includes subcontractor overhead and profit
(expressed as increase or decrease from 1)
UPB Estimate (Trades / VUPB)0

Coefficient (EATOA / UPB Estimate) ERROR:#DIV/0!

&"Times New Roman,Bold"&12ATTACHMENT 5&"Times New Roman,Regular" Development Coefficient(s)

Instructions Coefficient Instructions:

The offeror shall complete Attachment 5, 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 Joint Base Lewis-McChord (JBLM) 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 JBLM task orders actual costs to UPB estimated costs. No historical information is available to be provided. Provide narrative, detailed Excel worksheet(s), and graph(s) showing analysis. Please note, this is just one method that can be used in the development of a proposed coefficient.
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 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 coefficient shall contain all costs other than the pre-priced unit prices and shall include, but not be limited to:
1. All costs associated with bonding (specifically bond premiums)
2. All waste and excess material is defined as “Waste and Excess Quantities in the Completed In-place Construction Quantities”
a. All prices in the UPB are for the complete in-place construction unless explicitly described otherwise. The unit prices include delivery of materials to the job site. Waste or excess material quantities are incidental costs, which are included in
the contract coefficient unless explicitly stated otherwise in the UPB. Quantities used on individual job order proposals shall be taken from field measurements or design plans, as appropriate, without allowance for waste and/or incidental extra
materials used in performance of work. UPB prices include all waste and incidentals.
b. Incidental nails, screws, weldments, and connectors are included in UPB line items. Unless a connector or fastener is specifically stated as not being included, it is included in the price. For example: Installation of a suspended ceiling grid system
includes connectors, fasteners, and wire for the hanging system.
3. Mobilization and close out for the total contract and each task order
4. Cleanup for the total contract and for each task order, including final cleanup
5. Safety and compliance with environmental laws—costs associated with performing work in compliance with EPA/OSHA regulations, including but not limited to obtaining any necessary licenses and permits, reports requirements
6. Traffic and work site signs, barriers, and barricades
7. Contractor’s overhead, profit, labor burden, contingencies
8. Insurance
9. Subcontractor overhead and profit
10. Compliance with tax laws including business taxes, contributions, memberships, corporate headquarters support such as legal, financial
11. Permits, licenses, and fees
12. Project management and supervision
13. Protection of and/or moving of Government property
14. Contractor’s quality control
15. Office management and equipment
16. Interest associated with funding of equipment and payroll
17. Depreciation of mobile office(s)
18. CADD and as-built drawings, and submittals
19. Allowance for differences between location-specific Davis-Bacon wage rates and the rates used in the UPB line items
20. Work-site security
21. UPB costs confidence (to include issues regarding how the cost data are captured and the size/types of projects they reflect)
22. Number of copies of a commercial cost estimating and project management tool (e.g., WinEst, MS Project, e4Clicks) that they will need to support their contract requirements
23. Risk of lower than expected contract dollar amount
24. Risk of poor subcontractor performance and re-performance
25. Other risks of doing business
26. Operation and maintenance manuals
27. Protective clothing
28. Equipment rental
29. Electricity, water and restroom facilities not readily available at the project site
30. All costs associated with the Subdivisions/Major Classifications as identified in Exhibit 1-General Requirements paragraphs 1.7.1.2 and 1.7.1.3 as contained in any of the RSMeans bound or electronic databases shall NOT be used as line items in pricing task orders issued under this contract.
All costs associated within these paragraphs shall be covered in the Contractor’s coefficients:
31. Sales tax on material and equipment costs

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 5&"Times New Roman,Regular" Development of Coefficient(s)

File details come from the government source that posted it. Updated .