Exhibit D- Coefficient Normal.xlsx
XLSX spreadsheet 21 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 Exhibit D Coefficient Breakdown Form for a Job Order Contract (JOC) for construction services at Carlisle Barracks. The file provides the template and instructions for offerors to develop and submit their pricing coefficients for the Carlisle Barracks JOC (W5168W26RA007), a single-award, Firm Fixed Price, Indefinite Delivery Indefinite Quantity contract with a 60-month ordering period and an estimated annual task order award value of $17,000,000. The solicitation is a 100% 8(a) competitive set-aside issued by the Department of the Army for broad construction services including small minor projects at Carlisle Barracks, Pennsylvania.
Offerors must complete the Coefficient Breakdown Form and demonstrate their methodology for calculating the coefficient using one of four specified approaches: comparison of local subcontractor quotes to Unit Price Book (UPB) estimates, a mathematical model using historical task order pricing data, a historical weighted average analysis of past task order costs, or an alternative methodology. The coefficient must account for all costs not covered by pre-priced unit prices, including Division 00 adjustment factors such as overhead, profit, bonding, mobilization, cleanup, safety and compliance, permits, insurance, project management, equipment rental, sales tax, subcontractor overhead and profit, and contingencies. Offerors must also explain their assumptions regarding expected task order award volume and provide on-site staffing requirements by position and FTE. The coefficient formula is C = VUPB × EATOA / (EATOA - CCC), where VUPB is the value of the UPB (expressed to two decimal places), EATOA is estimated annual task order awards, and CCC is the costs covered by the coefficient. All components of price must be included in the coefficient as no allowance for omitted costs will be provided.
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 X001 U/M Qty Amount
Estimated Amount of Task Order Awards (EATOA) - - $ 17,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) $ 17,000,000.00
| 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"&12EXHIBIT D&"Times New Roman,Regular" Development Coefficient for Normal Working Hours Solicitation: Carlisle Barracks JOC W5168W26RA007
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 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 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 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 with the following Subdivisions/Major Classifications shall be covered in the Contractor’s coefficients: |
| Subdivision 01-11 – Summary of Work, excluded in its entirety; Subdivision 01-21 – Allowances, excluded in its entirety; Subdivision 01-31 – Project Management and Coordination, excluded in its entirety; |
| Subdivision 01-32 – Construction Progress Documentation, excluded in its entirety; Subdivision 01-41 – Regulatory Requirements, excluded in its entirety; Subdivision 01-51 – Temporary Utilities, excluded in its entirety. |
| Subdivision 01-52 – Construction Facilities, excluded in its entirety; Subdivision 01-54-09 – Protection Equipment, excluded in its entirety; Subdivision 01-54-39 – Construction Equipment, excluded in its entirety. |
| 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 for Normal Working Hours Solicitation: W91151-17-R-0064
File details come from the government source that posted it. Updated .