J24_Price Template - Amended Pricing 30Aug24.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Competitive 8(a) SATOC JOC 2025
- Solicitation number
- Not on record
View the file
Other files
Show all 44
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
IDIQ CLIN Price Summary Offeror: Insert Offeror Name Here
| Instructions: | The first line of the table is an example. Delete the contents and replace with proposed values. |
| 1) Enter the requested data in the yellow highlighted cells. The offeror may edit the worksheet to accomodate the offeror's price approach but the general format shall remain intact for evaluation and contract administration purposes. This TAB has been pre-populated with formulas to aid the offeror in calculating the proposed price. The offeror is responsible for ensuring that all calculations within the TAB are accurate and reflective of the offeror's proposed price. | |
| 2) Offerors shall insert a proposed coefficient for each CLIN. | |
| 3) The estimated annual ceiling values shall be reduced by the proposed coefficient for each CLIN resulting in the "Base of Coefficient". | |
| 4)The total proposed coefficient price is the delta in the "RFP Annual Ceiling CLIN" values and the "Base of the Coefficient" values. |
| CLIN | CLIN Description | RFP Annual Ceiling/CLIN | Proposed Coefficient | Base of Coefficient | Total Proposed Coefficient Price | Check |
| 0001 | Normal Working Hours in Non-Secure Areas | $80,000,000 | 1.20 | $66,666,667 | $13,333,333 | Yes |
| 0002 | Other than Normal Working Hours and/or in Secure Areas | $20,000,000 | 1.00 | $20,000,000 | $0 | Yes |
| 0003 | Normal Working Hours in Non-Secure Areas | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 0004 | Other than Normal Working Hours and/or in Secure Areas | $4,000,000 | 1.00 | $4,000,000 | $0 | Yes |
| 0005 | Streamlined Small Projects | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 1001 | Normal Working Hours in Non-Secure Areas | $80,000,000 | 1.00 | $80,000,000 | $0 | Yes |
| 1002 | Other than Normal Working Hours and/or in Secure Areas | $20,000,000 | 1.00 | $20,000,000 | $0 | Yes |
| 1003 | Normal Working Hours in Non-Secure Areas | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 1004 | Other than Normal Working Hours and/or in Secure Areas | $4,000,000 | 1.00 | $4,000,000 | $0 | Yes |
| 1005 | Streamlined Small Projects | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 2001 | Normal Working Hours in Non-Secure Areas | $80,000,000 | 1.00 | $80,000,000 | $0 | Yes |
| 2002 | Other than Normal Working Hours and/or in Secure Areas | $20,000,000 | 1.00 | $20,000,000 | $0 | Yes |
| 2003 | Normal Working Hours in Non-Secure Areas | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 2004 | Other than Normal Working Hours and/or in Secure Areas | $4,000,000 | 1.00 | $4,000,000 | $0 | Yes |
| 2005 | Streamlined Small Projects | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 3001 | Normal Working Hours in Non-Secure Areas | $80,000,000 | 1.00 | $80,000,000 | $0 | Yes |
| 3002 | Other than Normal Working Hours and/or in Secure Areas | $20,000,000 | 1.00 | $20,000,000 | $0 | Yes |
| 3003 | Normal Working Hours in Non-Secure Areas | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 3004 | Other than Normal Working Hours and/or in Secure Areas | $4,000,000 | 1.00 | $4,000,000 | $0 | Yes |
| 3005 | Streamlined Small Projects | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 4001 | Normal Working Hours in Non-Secure Areas | $80,000,000 | 1.00 | $80,000,000 | $0 | Yes |
| 4002 | Other than Normal Working Hours and/or in Secure Areas | $20,000,000 | 1.00 | $20,000,000 | $0 | Yes |
| 4003 | Normal Working Hours in Non-Secure Areas | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| 4004 | Other than Normal Working Hours and/or in Secure Areas | $4,000,000 | 1.00 | $4,000,000 | $0 | Yes |
| 4005 | Streamlined Small Projects | $8,000,000 | 1.00 | $8,000,000 | $0 | Yes |
| Total Price | $600,000,000 | $13,333,333 |
Task CLIN Price Summary Offeror: Insert Offeror Name Here
| Instructions: | The first line of the table is an example. Delete the contents and replace with proposed values. |
| 1) Enter the requested data in the yellow highlighted cells. The offeror may edit the worksheet to accomodate the offeror's price approach but the general format shall remain intact for evaluation and contract administration purposes. This TAB has been pre-populated with formulas to aid the offeror in calculating the proposed price. The offeror is responsible for ensuring that all calculations within the TAB are accurate and reflective of the offeror's proposed price. | |
| 2) Offerors shall insert the Proposed UPB Price by CLIN taken from the eGordian software for TO 0001. | |
| 3)The Offeror shall insert the proposed coefficients taken from the proposed IDIQ CLIN coefficients (Tab "IDIQ CLIN Price Summary") required to support TO 0001. | |
| 4) The total proposed TO Price is derived by mutiplying the proposed TO base price by the proposed CLIN coefficients required to supoprt TO 0001. |
| 2 | 3 | 4 | ||
| CLIN | CLIN Description | *Proposed UPB Price | Proposed Coefficient | Total Proposed TO Price (Proposed UPB Price*Proposed Coefficient) |
| 0001 | Normal Working Hours in Non-Secure Areas | $10,000 | 1.20 | $12,000 |
| 0002 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 0003 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 0004 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 0005 | Streamlined Small Projects | 1.00 | $0 | |
| 1001 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 1002 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 1003 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 1004 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 1005 | Streamlined Small Projects | 1.00 | $0 | |
| 2001 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 2002 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 2003 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 2004 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 2005 | Streamlined Small Projects | 1.00 | $0 | |
| 3001 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 3002 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 3003 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 3004 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 3005 | Streamlined Small Projects | 1.00 | $0 | |
| 4001 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 4002 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 4003 | Normal Working Hours in Non-Secure Areas | 1.00 | $0 | |
| 4004 | Other than Normal Working Hours and/or in Secure Areas | 1.00 | $0 | |
| 4005 | Streamlined Small Projects | 1.00 | $0 | |
| Total Price | $12,000 | |||
| * This price should reflect the price by CLIN using a coeffecient of 1.0 as taken from the eGordian® software. |
Coefficient Matrix Offeror: Insert Offeror Name Here
| Instructions: | |
| 1) Enter the requested data in the yellow highlighted cells. The offeror may edit the worksheet to accomodate the offeror's price approach but the general format shall remain intact for evaluation and contract administration purposes. This TAB has been pre-populated with formulas to aid the offeror in calculating the proposed price. The offeror is responsible for ensuring that all calculations within the TAB are accurate and reflective of the offeror's proposed price. | |
| 2) Offerors shall confirm the specific cost element included in each coefficient by CLIN by marking Yes or No in the applicable cells. | |
| 3) Cost elements not listed in the matrix but required to support a CLIN shall be identified by description and indicatate if the item applies to a specific coefficient/CLIN by marking "x" and "Yes" or "No" in the applicalble cells. | |
| 4) RFP directed minimum required cost elements are pre-populated with "x" for each coefficient/CLIN; however, the coefficients are not limited to the marked cost elements.. |
| Coefficient Traceability Matrix (Minimum requirements by CLIN) | Coefficient 1 | Included in Coefficient 1 | Coefficient 2 | Included in Coefficient 2 | Coefficient 3 | Included in Coefficient 3 | Coefficient 4 | Included in Coefficient 4 | Coefficient 5 | Included in Coefficient 5 |
| CLIN x001 | Yes/No | CLIN x002 | Yes/No | CLIN x003 | Yes/No | CLIN x004 | Yes/No | CLIN x005 | Yes/No | |
| Contractor’s overhead, profit, labor burden, contingencies | x | x | x | x | x | |||||
| Subcontractor’s overhead, profit, labor burden, contingencies | x | x | ||||||||
| Cost of money or borrowing fees to allow for payment of subcontractors ahead of payment from the Government | x | |||||||||
| Insurance | x | x | x | x | ||||||
| Mobilization and close out for the total contract and each task order | x | x | x | x | ||||||
| Access for contractor and commercial vehicles through gate 1 only | x | x | ||||||||
| Daily and final clean up to include dumpsters | x | x | x | x | x | |||||
| Portable restrooms | x | x | x | x | ||||||
| All costs associated with prime Contractor’s bonding | x | x | x | x | x | |||||
| Employee payroll taxes, insurance and fringe benefits | x | x | x | x | x | |||||
| Business taxes, contributions, memberships, corporate headquarters support (legal, financial, etc.) | x | x | x | x | ||||||
| Safety and compliance with environmental laws (i.e. safety rails, face and eye protection, protective clothing, obtaining necessary licenses, etc.) | x | x | x | x | ||||||
| Traffic and work site signs and barricades | x | x | x | x | ||||||
| Furniture moving (all except modular furniture and safes) | x | x | ||||||||
| Protection of and/or moving of Government property | x | x | ||||||||
| Disassembly, separation, and delivery of demolition items for turnin | x | x | ||||||||
| Removal, handling, transport and disposal of PCB ballasts (includes purchasing 55 gallon barrels) | x | x | ||||||||
| Removal, handling, transport and disposal of fluorescent lighting lamps, aerosol cans and paint cans | x | x | ||||||||
| Project management and supervision | x | x | x | x | x | |||||
| Quality Control | x | x | x | x | x | |||||
| Office management and equipment | x | x | x | x | ||||||
| Initial set-up of office trailer, including extension/metering of utilities | x | x | x | x | x | |||||
| Office rental, utilities, and custodial services | x | x | x | x | ||||||
| Costs to restore office trailer site to its original condition | x | x | x | x | x | |||||
| Vehicles, expenses, and insurance | x | x | x | x | x | |||||
| Employee phones and service plans | x | x | x | x | ||||||
| Depreciation of mobile office(s) | x | x | x | x | ||||||
| Submittal and report preparation | x | x | x | x | ||||||
| As built drawings | x | x | x | x | ||||||
| Copying project drawings and/or sketches | x | x | x | x | ||||||
| Interest associated with funding of equipment and payroll | x | x | x | x | ||||||
| Permits, licenses and fees | x | x | x | x | ||||||
| Purchasing and installing equipment warranty identification tags. | x | x | ||||||||
| Year 1’s proposed coefficients should include applicable phase in costs. | x | x | x | x | x | |||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) | ||||||||||
| Other (include description here) |
Total Evaluated Price Offeror: Insert Offeror Name Here
| Element | Total Price |
| IDIQ Coefficient Price | $13,333,333 |
| Task Order 0001 Price | $12,000 |
| Total Evaluated Price | $13,345,333 |
File details come from the government source that posted it. Updated .