20155109_Attachment 08 - IDIQ Pricing Table (MEP_LEP).xlsx
XLSX spreadsheet 122 KB Posted
- Solicitation number
- 11042025
About this file
This document is a detailed IDIQ (Indefinite Delivery/Indefinite Quantity) pricing table for Multi Energy Portal (MEP) and Low Energy Portal (LEP) Systems for U.S. Customs and Border Protection (CBP). The pricing document covers a five-year contract period from September 30, 2026, to September 29, 2031, with multiple Contract Line Item Numbers (CLINs) across categories including equipment, site design, civil works, installation, training, maintenance, warranties, and on-demand services. The total contract value is approximately $551,996,573.14, with the LEP system accounting for the majority of the pricing ($551,996,573.14) and MEP system pricing primarily showing $0.00 across most line items.
Key pricing details include firm-fixed and time-and-materials pricing structures for various system types and quantities, with progressive pricing for different unit volumes and optional extended warranty periods. The document includes granular pricing for system components such as analyst stations, operator stations, situational walls, generators, power supplies, and installation services. Notable features are the increasing unit prices across option years, reflecting potential cost escalations, and the inclusion of preventative and corrective maintenance options, warranty periods, and on-demand services. The pricing table is marked "SENSITIVE BUT UNCLASSIFIED" and appears to be a draft document for a future CBP Non-Intrusive Inspection (NII) technology procurement.
View the file
Other files
Show all 17
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
Table 1 Summary (2)
| Contractor Name: | Summary Table | |
| Solicitation Number: | ||
| Task Order Number: | ||
| Task Order Title: | ||
| Base Period: | ||
| Option 1: | ||
| Option 2: | ||
| Option 3: | ||
| Option 4: | ||
| Option 5: |
| Contract Value | ||||||||
| Description | Total Price Base | Total Price Option 1 | Total Price Option 2 | Total Price Option 3 | Total Price Option 4 | 52.217-8 Extension | Total Price | |
| EQUIPMENT - Multi Energy Portal (MEP) | ||||||||
| CLIN 001 MEP | $ - 0 | $ - 0 | ||||||
| CLIN 101 Command Center | ERROR:#REF! | |||||||
| CLIN 201 Blanking Wall | ERROR:#REF! | |||||||
| CLIN 301 Power Conditioner | ERROR:#REF! | |||||||
| CLIN 401 | ERROR:#REF! | |||||||
| CLIN 501 | ERROR:#REF! | ERROR:#REF! | ||||||
| STANDARD LABOR | ||||||||
| CLIN 002 Engineering | ERROR:#REF! | |||||||
| CLIN 102 Technical Trade | ERROR:#REF! | |||||||
| CLIN 202 Laborers | ERROR:#REF! | |||||||
| CLIN 302 MEP | ERROR:#REF! | |||||||
| CLIN 402 Architecture | ERROR:#REF! | |||||||
| CLIN 502 Systems Designer | ERROR:#REF! | ERROR:#REF! | ||||||
| GENERAL REQUIREMENTS | ||||||||
| CLIN 003 Design | $ - 0 | |||||||
| CLIN 103 Civil | $ - 0 | |||||||
| CLIN 203 Site | $ - 0 | |||||||
| CLIN 303 Systems | $ - 0 | |||||||
| CLIN 403 Structure | $ - 0 | |||||||
| CLIN 503 Infrastructure | $ - 0 | $ - 0 | ||||||
| TRAINING | ||||||||
| CLIN 004 Analyst | $ 156,481.00 | |||||||
| CLIN 104 Training for Trainers | $ - 0 | |||||||
| CLIN 204 Operators | $ - 0 | |||||||
| CLIN 304 | $ - 0 | |||||||
| CLIN 404 | $ - 0 | |||||||
| CLIN 504 | $ - 0 | $ 156,481.00 | ||||||
| TESTING | ||||||||
| CLIN 005 Commissioning | $ 3,542,353.00 | |||||||
| CLIN 105 SAT | $ - 0 | |||||||
| CLIN 205 FAT | $ - 0 | |||||||
| CLIN 305 Systems | $ - 0 | |||||||
| CLIN 405 | $ - 0 | |||||||
| CLIN 505 | $ - 0 | $ 3,542,353.00 | ||||||
| DESIGN | ||||||||
| CLIN 006 Site Design | $ 263,164.00 | |||||||
| CLIN 106 Systems Design | $ - 0 | |||||||
| CLIN 206 Security | $ - 0 | |||||||
| CLIN 306 OIT | $ - 0 | |||||||
| CLIN 406 Blanking | $ - 0 | |||||||
| CLIN 506 Infrastructure | $ - 0 | $ 263,164.00 | ||||||
| CIVIL WORKS | ||||||||
| CLIN 007 Site Prep | $ 8,858,355.00 | |||||||
| CLIN 107 Concrete work | $ - 0 | |||||||
| CLIN 207 Steel Work | $ - 0 | |||||||
| CLIN 307 Geotech Studies | $ - 0 | |||||||
| CLIN 308 Infrastructure Install | $ - 0 | |||||||
| CLIN 407 Site Grading | $ - 0 | |||||||
| CLIN 507 Saw Cutting | $ - 0 | $ 8,858,355.00 | ||||||
| INSTALLATION | ||||||||
| CLIN 008 Mechanical | $ - 0 | |||||||
| CLIN 108 Electrical | $ - 0 | |||||||
| CLIN 208 Plumbing | $ - 0 | |||||||
| CLIN 308 Foundations | $ - 0 | |||||||
| CLIN 308 Command Center | $ - 0 | |||||||
| CLIN 408 Technology Trenches | $ - 0 | |||||||
| CLIN 508 Conduit/Junction Boxes | $ - 0 | $ - 0 | ||||||
| Grand Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Check | ||||||||
| ERROR:#REF! |
&1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED
Table 1 Summary
| Contractor Name: | Summary Table | |
| Solicitation Number: | ||
| Task Order Number: | ||
| Task Order Title: | ||
| Base Period: | ||
| Option 1: | ||
| Option 2: | ||
| Option 3: | ||
| Option 4: | ||
| Option 5: |
| Contract Value | ||||||||
| Description | Total Price Base | Total Price Option 1 | Total Price Option 2 | Total Price Option 3 | Total Price Option 4 | 52.217-8 Extension | Total Price | |
| EQUIPMENT - Low Energy Portal (LEP) | ||||||||
| CLIN 101 LEP | $ - 0 | $ - 0 | ||||||
| CLIN 101 Command Center | ERROR:#REF! | |||||||
| CLIN 201 Blanking Wall | ERROR:#REF! | |||||||
| CLIN 301 Power Conditioner | ERROR:#REF! | |||||||
| CLIN 401 | ERROR:#REF! | |||||||
| CLIN 501 | ERROR:#REF! | ERROR:#REF! | ||||||
| STANDARD LABOR | ||||||||
| CLIN 002 Engineering | ERROR:#REF! | |||||||
| CLIN 102 Technical Trade | ERROR:#REF! | |||||||
| CLIN 202 Laborers | ERROR:#REF! | |||||||
| CLIN 302 Systems Design | ERROR:#REF! | |||||||
| CLIN 402 Architecture | ERROR:#REF! | |||||||
| CLIN 502 MEP | ERROR:#REF! | ERROR:#REF! | ||||||
| GENERAL REQUIREMENTS | ||||||||
| CLIN 003 Design | $ - 0 | |||||||
| CLIN 103 Civil | $ - 0 | |||||||
| CLIN 203 Site | $ - 0 | |||||||
| CLIN 303 Systems | $ - 0 | |||||||
| CLIN 403 Structure | $ - 0 | |||||||
| CLIN 503 Infrastructure | $ - 0 | $ - 0 | ||||||
| TRAINING | ||||||||
| CLIN 004 Analyst | $ 156,481.00 | |||||||
| CLIN 104 Training for Trainers | $ - 0 | |||||||
| CLIN 204 Operators | $ - 0 | |||||||
| CLIN 304 | $ - 0 | |||||||
| CLIN 404 | $ - 0 | |||||||
| CLIN 504 | $ - 0 | $ 156,481.00 | ||||||
| TESTING | ||||||||
| CLIN 005 Commissioning | $ 3,542,353.00 | |||||||
| CLIN 105 SAT | $ - 0 | |||||||
| CLIN 205 FAT | $ - 0 | |||||||
| CLIN 305 Systems | $ - 0 | |||||||
| CLIN 405 | $ - 0 | |||||||
| CLIN 505 | $ - 0 | $ 3,542,353.00 | ||||||
| DESIGN | ||||||||
| CLIN 006 Site Design | $ 263,164.00 | |||||||
| CLIN 106 Systems Design | $ - 0 | |||||||
| CLIN 206 Security | $ - 0 | |||||||
| CLIN 306 OIT | $ - 0 | |||||||
| CLIN 406 Blanking | $ - 0 | |||||||
| CLIN 506 Infrastructure | $ - 0 | $ 263,164.00 | ||||||
| CIVIL WORKS | ||||||||
| CLIN 007 Site Prep | $ 8,858,355.00 | |||||||
| CLIN 107 Concrete work | $ - 0 | |||||||
| CLIN 207 Steel Work | $ - 0 | |||||||
| CLIN 307 Geotech Studies | $ - 0 | |||||||
| CLIN 308 Infrastructure Install | $ - 0 | |||||||
| CLIN 407 Site Grading | ||||||||
| CLIN 507 Saw Cutting | $ - 0 | $ 8,858,355.00 | ||||||
| INSTALLATION | ||||||||
| CLIN 008 Mechanical | $ - 0 | |||||||
| CLIN 108 Electrical | $ - 0 | |||||||
| CLIN 208 Plumbing | ||||||||
| CLIN 308 Foundations | $ - 0 | |||||||
| CLIN 308 Command Center | $ - 0 | |||||||
| CLIN 408 Technology Trenches | $ - 0 | |||||||
| CLIN 508 Conduit/Junction Boxes | $ - 0 | $ - 0 | ||||||
| Grand Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Check | ||||||||
| ERROR:#REF! |
&1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED
Instructions Attachment 8 serves as the standardized format for submitting pricing information and associated details for all required Contract Line Item Numbers (CLINs). This ensures uniformity across proposals and facilitates efficient evaluation of submissions.
1. Required Information Contractors must complete the following sections of Attachment 8:
a. Pricing Table: Provide detailed pricing for all required CLINs as specified in the solicitation. Ensure that all costs are clearly itemized and align with the scope of work and technical requirements outlined in the Statement of Work (SOW).
b. Justification Tab: Use this tab to provide a detailed explanation of the proposed pricing. Include any supporting rationale, such as cost breakdowns, market research, or other relevant data that substantiates the proposed costs.
c. Assumptions Tab: Clearly outline any assumptions made during the development of the proposal. These may include technical, operational, or logistical considerations that impact pricing or performance.
2. Formatting Requirements All entries in Attachment 8 must be completed electronically using the provided template. Do not alter the structure or format of the pricing table or tabs. If additional information is necessary, include it as supplemental documentation and reference it in the justification tab. Ensure all calculations are accurate and formulas within the pricing table are functional.
Pricing entries are ONLY required on tabs "MEP CLINs" and "LEP CLINs." Entries made to these tabs will automatically populate in the "Summary" tabs. If they do not, please update the "Summary" tabs to reflect the "MEP CLINs" and "LEP CLINs" tabs accordingly.
3. Submission Guidelines Proposals must be submitted in accordance with the timeline and instructions provided in the solicitation.
Ensure Attachment 8 is included as part of the proposal package. Proposals submitted without Attachment 8 completed in full may be deemed non-compliant and excluded from consideration.
5. Evaluation Considerations Proposals will be evaluated based on the accuracy, completeness, and reasonableness of the pricing provided in Attachment 8, as well as the clarity and validity of the justification and assumptions. Contractors are encouraged to provide detailed and transparent information to facilitate the evaluation process.
6. Questions and Clarifications If contractors have questions regarding the use of Attachment 8 or require clarification on any aspect of the pricing table template, they should submit inquiries in writing to the Contracting Officer prior to the proposal submission deadline.
MEP SUMMARY
| Summary Table | ||
| Contractor Name: | ||
| Solicitation Number: | ||
| Contract Number: | ||
| Contract Title: | FY26 Large-Scale Fixed Systems IDIQ |
| Base Period: September 30, 2026 to September 29, 2027 |
| Option 1: September 30, 2027 to September 29, 2028 |
| Option 2: September 30, 2028 to September 29, 2029 |
| Option 3: September 30, 2029 to September 29, 2030 |
| Option 4: September 30, 2030 to September 29, 2031 |
| Contract Value | |||||||
| Description | Total Price Base | Total Price Option 1 | Total Price Option 2 | Total Price Option 3 | Total Price Option 4 | Total Price | |
| EQUIPMENT - MULTI-ENERGY PORTAL SYSTEM (FFP) | |||||||
| CLIN 001 | $0.00 | ||||||
| CLIN 101 | $0.00 | ||||||
| CLIN 201 | $0.00 | ||||||
| CLIN 301 | $0.00 | ||||||
| CLIN 401 | $0.00 | ||||||
| CLIN 501 | $0.00 | ||||||
| SITE DESIGN (FFP) | |||||||
| CLIN 002 | $ - 0 | ||||||
| CLIN 102 | $ - 0 | ||||||
| CLIN 202 | $ - 0 | ||||||
| CLIN 302 | $ - 0 | ||||||
| CLIN 402 | $ - 0 | ||||||
| CLIN 502 | $ - 0 | ||||||
| CIVIL WORKS (T&M) | |||||||
| CLIN 003 | $ - 0 | ||||||
| CLIN 103 | $ - 0 | ||||||
| CLIN 203 | $ - 0 | ||||||
| CLIN 303 | $ - 0 | ||||||
| CLIN 403 | $ - 0 | ||||||
| CLIN 503 | $ - 0 | ||||||
| FURNITURE, FIXTURES, AND EQUIPMENT (FFP) | |||||||
| CLIN 004 | $ - 0 | ||||||
| CLIN 104 | $ - 0 | ||||||
| CLIN 204 | $ - 0 | ||||||
| CLIN 304 | $ - 0 | ||||||
| CLIN 404 | $ - 0 | ||||||
| CLIN 504 | $ - 0 | ||||||
| INSTALLATION (T&M) | |||||||
| CLIN 005 | $ - 0 | ||||||
| CLIN 105 | $ - 0 | ||||||
| CLIN 205 | $ - 0 | ||||||
| CLIN 305 | $ - 0 | ||||||
| CLIN 405 | $ - 0 | ||||||
| CLIN 505 | $ - 0 | ||||||
| TRAINING (FFP) | |||||||
| CLIN 006 | $ - 0 | ||||||
| CLIN 106 | $ - 0 | ||||||
| CLIN 206 | $ - 0 | ||||||
| CLIN 306 | $ - 0 | ||||||
| CLIN 406 | $ - 0 | ||||||
| CLIN 506 | $ - 0 | ||||||
| PREVENTATIVE MAINTENANCE OPTIONS (FFP) | |||||||
| CLIN 007 | $ - 0 | ||||||
| CLIN 107 | $ - 0 | ||||||
| CLIN 207 | $ - 0 | ||||||
| CLIN 307 | $ - 0 | ||||||
| CLIN 407 | $ - 0 | ||||||
| CLIN 507 | $ - 0 | ||||||
| CORRECTIVE MAINTENANCE OPTIONS (FFP) (parts, labor, diagnostics, and repair) | |||||||
| CLIN 009 | $ - 0 | ||||||
| CLIN 109 | $ - 0 | ||||||
| CLIN 209 | $ - 0 | ||||||
| CLIN 309 | $ - 0 | ||||||
| CLIN 409 | $ - 0 | ||||||
| CLIN 509 | $ - 0 | ||||||
| WARRANTY PERIODS (FFP) | |||||||
| CLIN 011 | $ - 0 | ||||||
| CLIN 111 | $ - 0 | ||||||
| CLIN 211 | $ - 0 | ||||||
| CLIN 311 | $ - 0 | ||||||
| CLIN 411 | $ - 0 | ||||||
| CLIN 511 | $ - 0 | ||||||
| ON-DEMAND SERVICES (FFP) | |||||||
| CLIN 012 | $ - 0 | ||||||
| CLIN 112 | $ - 0 | ||||||
| CLIN 212 | $ - 0 | ||||||
| CLIN 312 | $ - 0 | ||||||
| CLIN 412 | $ - 0 | ||||||
| CLIN 512 | $ - 0 | ||||||
| INDIRECT RATES | |||||||
| CLIN 012 | $ - 0 | ||||||
| CLIN 112 | $ - 0 | ||||||
| CLIN 212 | $ - 0 | ||||||
| CLIN 312 | $ - 0 | ||||||
| CLIN 412 | $ - 0 | ||||||
| CLIN 512 | $ - 0 | ||||||
| INCENTIVE POOL | |||||||
| CLIN 013 | $0.00 | ||||||
| CLIN 113 | $0.00 | ||||||
| CLIN 213 | $0.00 | ||||||
| CLIN 313 | $0.00 | ||||||
| CLIN 413 | $0.00 | ||||||
| CLIN 513 | $ - 0 |
Grand Total tc={E8206A93-6122-4C61-BE58-7B84FBD3D9C5}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
High-Level Comments:
*Labor-related costs are usually broken out by labor category and qty
*Also include sub-contracts, travel, shipping, equipment / materials, etc
*How are “on demand services” incorporated into the IGCE?
*Justifications need to be fleshed out – but specifically in a manner that enables the reader to understand how / why certain numbers / calculations were used. E.g.,
- How were the “economies of scale” determined for the different quantities?
- What did you use to determine which labor categories to use?
- How did you estimate the rates per labor category?
- What did you base the # of trips and cost of trips on? (e.g., which trips, to which locations, how many travelers, how many # days, etc.) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
High-Level Comments:
*Labor-related costs are usually broken out by labor category and qty
*Also include sub-contracts, travel, shipping, equipment / materials, etc
*How are “on demand services” incorporated into the IGCE?
*Justifications need to be fleshed out – but specifically in a manner that enables the reader to understand how / why certain numbers / calculations were used. E.g.,
- How were the “economies of scale” determined for the different quantities?
- What did you use to determine which labor categories to use?
- How did you estimate the rates per labor category?
- What did you base the # of trips and cost of trips on? (e.g., which trips, to which locations, how many travelers, how many # days, etc.)
&1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED
LEP SUMMARY
| Summary Table | ||
| Contractor Name: | ||
| Solicitation Number: | ||
| Contract Number: | ||
| Contract Title: | FY26 Large-Scale Fixed Systems IDIQ |
| Base Period: September 30, 2026 to September 29, 2027 |
| Option 1: September 30, 2027 to September 29, 2028 |
| Option 2: September 30, 2028 to September 29, 2029 |
| Option 3: September 30, 2029 to September 29, 2030 |
| Option 4: September 30, 2030 to September 29, 2031 |
| Contract Value | |||||||
| Description | Total Price Base | Total Price Option 1 | Total Price Option 2 | Total Price Option 3 | Total Price Option 4 | Total Price | |
| EQUIPMENT - LOW ENERGY PORTAL SYSTEM (FFP) | |||||||
| CLIN 001 | $34,710,424.00 | ||||||
| CLIN 101 | $36,297,508.80 | ||||||
| CLIN 201 | $11,186,604.45 | ||||||
| CLIN 301 | $11,745,934.67 | ||||||
| CLIN 401 | $12,333,231.41 | ||||||
| CLIN 501 | $106,273,703.33 | ||||||
| SITE DESIGN (FFP) | |||||||
| CLIN 002 | $1,400,000.00 | ||||||
| CLIN 102 | $1,680,000.00 | ||||||
| CLIN 202 | $551,250.00 | ||||||
| CLIN 302 | $578,812.50 | ||||||
| CLIN 402 | $607,753.13 | ||||||
| CLIN 502 | $ 4,817,815.63 | ||||||
| CIVIL WORKS (T&M) | |||||||
| CLIN 003 | $ 64,539,609.00 | ||||||
| CLIN 103 | $ 77,684,358.15 | ||||||
| CLIN 203 | $ 24,873,688.83 | ||||||
| CLIN 303 | $ 25,508,134.91 | ||||||
| CLIN 403 | $ 28,702,642.48 | ||||||
| CLIN 503 | $ 221,308,433.37 | ||||||
| FURNITURE, FIXTURES, AND EQUIPMENT (FFP) | |||||||
| CLIN 004 | $ 2,167,000.00 | ||||||
| CLIN 104 | $ 2,538,900.00 | ||||||
| CLIN 204 | $ 1,110,768.75 | ||||||
| CLIN 304 | $ 1,201,035.94 | ||||||
| CLIN 404 | $ 1,151,692.18 | ||||||
| CLIN 504 | $ 8,169,396.87 | ||||||
| INSTALLATION (T&M) | |||||||
| CLIN 005 | $ 53,937,100.00 | ||||||
| CLIN 105 | $ 64,724,520.00 | ||||||
| CLIN 205 | $ 21,237,733.13 | ||||||
| CLIN 305 | $ 22,299,619.78 | ||||||
| CLIN 405 | $ 23,414,600.78 | ||||||
| CLIN 505 | $ 185,613,573.69 | ||||||
| TRAINING (FFP) | |||||||
| CLIN 006 | $ 80,000.00 | ||||||
| CLIN 106 | $ - 0 | ||||||
| CLIN 206 | $ - 0 | ||||||
| CLIN 306 | $ - 0 | ||||||
| CLIN 406 | $ - 0 | ||||||
| CLIN 506 | $ 80,000.00 | ||||||
| PREVENTATIVE MAINTENANCE OPTIONS (FFP) | |||||||
| CLIN 007 | $ 406,322.00 | ||||||
| CLIN 107 | $ 487,586.40 | ||||||
| CLIN 207 | $ 159,989.29 | ||||||
| CLIN 307 | $ 167,988.75 | ||||||
| CLIN 407 | $ 176,388.19 | ||||||
| CLIN 507 | $ 1,398,274.63 | ||||||
| CORRECTIVE MAINTENANCE OPTIONS (FFP) | |||||||
| CLIN 009 | $ - 0 | ||||||
| CLIN 109 | $ 1,590,065.22 | ||||||
| CLIN 209 | $ 1,908,078.26 | ||||||
| CLIN 309 | $ 626,088.18 | ||||||
| CLIN 409 | $ 657,392.59 | ||||||
| CLIN 509 | $ 4,781,624.25 | ||||||
| WARRANTY PERIODS (FFP) | |||||||
| CLIN 011 | $ 1,890,000.00 | ||||||
| CLIN 111 | $ 4,620,000.00 | ||||||
| CLIN 211 | $ 3,566,587.50 | ||||||
| CLIN 311 | $ 2,633,596.88 | ||||||
| CLIN 411 | $ 2,765,276.72 | ||||||
| CLIN 511 | $ 15,475,461.09 | ||||||
| ON-DEMAND SERVICES (FFP) | |||||||
| CLIN 012 | $ 177,102.72 | ||||||
| CLIN 112 | $ 212,523.27 | ||||||
| CLIN 212 | $ 69,734.20 | ||||||
| CLIN 312 | $ 73,220.91 | ||||||
| CLIN 412 | $ 76,881.95 | ||||||
| CLIN 512 | $ 609,463.04 | ||||||
| INDIRECT RATES | |||||||
| CLIN 012 | $ - 0 | ||||||
| CLIN 112 | $ - 0 | ||||||
| CLIN 212 | $ - 0 | ||||||
| CLIN 312 | $ - 0 | ||||||
| CLIN 412 | $ - 0 | ||||||
| CLIN 512 | $ - 0 | ||||||
| INCENTIVE POOL | |||||||
| CLIN 013 | $1,008,000.00 | ||||||
| CLIN 113 | $1,209,600.00 | ||||||
| CLIN 213 | $396,900.00 | ||||||
| CLIN 313 | $416,745.00 | ||||||
| CLIN 413 | $437,582.25 | ||||||
| CLIN 513 | $ 3,468,827.25 |
Grand Total tc={89005434-2191-4F1F-8589-3B92B3AD2DA4}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
High-Level Comments:
*Labor-related costs are usually broken out by labor category and qty
*Also include sub-contracts, travel, shipping, equipment / materials, etc
*How are “on demand services” incorporated into the IGCE?
*Justifications need to be fleshed out – but specifically in a manner that enables the reader to understand how / why certain numbers / calculations were used. E.g.,
- How were the “economies of scale” determined for the different quantities?
- What did you use to determine which labor categories to use?
- What did you base the # of trips and cost of trips on? (e.g., which trips, to which locations, how many travelers, how many # days, etc.) $160,315,557.72 $191,045,061.83 $65,061,334.40 $65,251,177.51 $70,323,441.67 $551,996,573.14
High-Level Comments:
*Labor-related costs are usually broken out by labor category and qty
*Also include sub-contracts, travel, shipping, equipment / materials, etc
*How are “on demand services” incorporated into the IGCE?
*Justifications need to be fleshed out – but specifically in a manner that enables the reader to understand how / why certain numbers / calculations were used. E.g.,
- How were the “economies of scale” determined for the different quantities?
- What did you use to determine which labor categories to use?
- What did you base the # of trips and cost of trips on? (e.g., which trips, to which locations, how many travelers, how many # days, etc.)
&1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED
MEP CLINs
| Contractor Name: | ||||||||||||||||||||||
| Solicitation Number: | ||||||||||||||||||||||
| Task Order Number: | ||||||||||||||||||||||
| Task Order Title: | ||||||||||||||||||||||
| Base Period: September 30, 2026 to September 29, 2027 | ||||||||||||||||||||||
| Option 1: September 30, 2027 to September 29, 2028 | ||||||||||||||||||||||
| Option 2: September 30, 2028 to September 29, 2029 | ||||||||||||||||||||||
| Option 3: September 30, 2029 to September 29, 2030 | ||||||||||||||||||||||
| Option 4: September 30, 2030 to September 29, 2031 | ||||||||||||||||||||||
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| EQUIPMENT - MULTI-ENERGY PORTAL SYSTEM (FFP) | CLIN 001-XX | CLIN 101 | CLIN 201 | CLIN 301 | CLIN 401 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X100 | MEP (less than 5 units) | FFUP | 13 | $0.00 | FFUP | 20 | $0.00 | $0.00 | FFUP | 5 | $0.00 | $0.00 | FFUP | 5 | $0.00 | $0.00 | FFUP | 5 | $0.00 | $0.00 | $0.00 | |
| X101 | MEP (units 5-10) | FFUP | 0 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | $0.00 | |
| X102 | MEP (units 11-20) | FFUP | 0 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | $0.00 | |
| X103 | MEP (more than 20 units) | FFUP | 0 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | FFUP | 0 | $0.00 | $0.00 | $0.00 | |
| X116 | UVBx | FFUP | 13 | $0.00 | FFUP | 20 | $0.00 | $0.00 | FFUP | 5 | $0.00 | $0.00 | FFUP | 5 | $0.00 | $0.00 | FFUP | 5 | $0.00 | $0.00 | $0.00 |
Total Equipment Management $0.00 Total Equipment Management $0.00 Total Equipment Management $0.00 Total Equipment Management $0.00 Total Equipment Management $0.00 $0.00
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| SITE DESIGN (FFP) | CLIN 002 | CLIN 102 | CLIN 202 | CLIN 302 | CLIN 402 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X200 | Site Design | FFP | 13 | $0.00 | FFP | 20 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | $0.00 | |
| Concept Review | ||||||||||||||||||||||
| 50% Design | ||||||||||||||||||||||
| 95% Design | ||||||||||||||||||||||
| Issued for Construction Drawings | ||||||||||||||||||||||
| Total Site Design | $0.00 | Total Site Design | $0.00 | Total Site Design | $0.00 | Total Site Design | $0.00 | Total Site Design | $0.00 | $0.00 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| CIVIL WORKS (T&M) | CLIN 003 | CLIN 103 | CLIN 203 | CLIN 303 | CLIN 403 | |||||||||||||||||
| Sub - CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X300 | Mobilization and Site Preparations, Securing the site, Demobilization | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X301 | Command Center-New Construction | T&M | 10 | $ - 0 | T&M | 17 | $0.00 | $ - 0 | T&M | 3 | $0.00 | $ - 0 | T&M | 2 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X302 | Command Center-Retrofit | T&M | 3 | $ - 0 | T&M | 3 | $0.00 | $ - 0 | T&M | 2 | $0.00 | $ - 0 | T&M | 3 | $0.00 | $ - 0 | T&M | 0 | $0.00 | $ - 0 | $ - 0 | |
| X303 | Demolition/Excavation/Removal/Saw Cut | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X304 | Clearing/Grubbing, Dirt Work (balancing cut/fill), Compaction, Drainage | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X305 | Electrical/Plumbing/Mechanical | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X306 | Concrete/Asphalt/Footers/Foundations/Lanes of Traffic | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X307 | Steel Work | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X308 | Traffic Control Measures, Jersey Barriers, Speed bumps, striping, signage | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X309 | IT Trenches, Conduit, Conduit Banks, Junction Boxes, Pull Strings | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X310 | Site Survey | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X311 | SWPPP, Permitting | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 |
Total Civil Works $ - 0 Total Civil Works $ - 0 Total Civil Works $ - 0 Total Civil Works $ - 0 Total Civil Works $ - 0 $ - 0
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| FURNITURE, FIXTURES, AND EQUIPMENT (FFP) | CLIN 004 | CLIN 104 | CLIN 204 | CLIN 304 | CLIN 404 | |||||||||||||||||
| Sub - CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X400 | Analyst Station | FFUP | 26 | $ - 0 | FFUP | 40 | $0.00 | $ - 0 | FFUP | 10 | $0.00 | $ - 0 | FFUP | 10 | $0.00 | $ - 0 | FFUP | 10 | $0.00 | $ - 0 | $ - 0 | |
| X401 | Operator Station | FFUP | 13 | $ - 0 | FFUP | 20 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | $ - 0 | |
| X402 | Situational Wall | FFUP | 1 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | $ - 0 | |
| X403 | Furniture and fixtures | FFUP | 1 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | $ - 0 | |
| X404 | Generators | FFUP | 1 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | $ - 0 | |
| X405 | Uninterrupted Power Supplies | FFUP | 1 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | $ - 0 | |
| X406 | Power Conditioners | FFUP | 1 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | $ - 0 | |
| X407 | Operator Booth (8'x12') | FFUP | 10 | $ - 0 | FFUP | 17 | $0.00 | $ - 0 | FFUP | 4 | $0.00 | $ - 0 | FFUP | 4 | $0.00 | $ - 0 | FFUP | 4 | $0.00 | $ - 0 | $ - 0 | |
| X408 | Operator Booth (12'x16') | FFUP | 3 | $ - 0 | FFUP | 3 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | FFUP | 1 | $0.00 | $ - 0 | $ - 0 | |
| X409 | Laptops | FFUP | 15 | $ - 0 | FFUP | 15 | $0.00 | $ - 0 | FFUP | 15 | $0.00 | $ - 0 | FFUP | 15 | $0.00 | $ - 0 | FFUP | 15 | $0.00 | $ - 0 | $ - 0 |
Total Construction $ - 0 Total Construction $ - 0 Total Construction $ - 0 Total Construction $ - 0 Total Construction $ - 0 $ - 0
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| INSTALLATION (T&M) | CLIN 005 | CLIN 105 | CLIN 205 | CLIN 305 | CLIN 405 | |||||||||||||||||
| Sub - CLIN | Description | Type | Rate | Amount | Type | Rate | Amount | Type | Rate | Amount | Type | Rate | Amount | Type | Rate | Amount | Total | |||||
| X500 | Installation | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X501 | Integration | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X502 | Blanking Solution | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X503 | System Testing | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 | |
| X504 | Software installation/upgrade | T&M | 13 | $ - 0 | T&M | 20 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | T&M | 5 | $0.00 | $ - 0 | $ - 0 |
Total Installation $ - 0 Total Installation $ - 0 Total Installation $ - 0 Total Installation $ - 0 Total Installation $ - 0 $ - 0
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| TRAINING (FFP) | CLIN 006 | CLIN 106 | CLIN 206 | CLIN 306 | CLIN 406 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | |
| X600 | Training Development | FFUP | 1 | $ - 0 | FFP | 0 | $ - 0 | $ - 0 | FFP | 0 | $ - 0 | $ - 0 | FFP | 0 | $ - 0 | $ - 0 | FFP | 0 | $ - 0 | $ - 0 | $ - 0 |
Total Training $ - 0 Total Training $ - 0 Total Training $ - 0 Total Training $ - 0 Total Training $ - 0 $ - 0
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| PREVENTATIVE MAINTENANCE OPTIONS (FFP) | CLIN 007 | CLIN 107 | CLIN 207 | CLIN 307 | CLIN 407 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | |
| X700 | MEP Service | FFUP | 13 | $ - 0 | FFUP | 20 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | $ - 0 | |
| X701 | UVBx Service | FFUP | 13 | $ - 0 | FFUP | 20 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | $ - 0 | |
| Total Preventative Maintenance (UVBx) | $ - 0 | Total Preventative Maintenance (UVBx) | $ - 0 | Total Preventative Maintenance (UVBx) | $ - 0 | Total Preventative Maintenance (UVBx) | $ - 0 | Total Preventative Maintenance (UVBx) | $ - 0 | $ - 0 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| CORRECTIVE MAINTENANCE OPTIONS (FFP) (parts, labor, diagnostics, and repair) | CLIN 009 | CLIN 109 | CLIN 209 | CLIN 309 | CLIN 409 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | |
| X800 | MEP Service | FFUP | 0 | $ - 0 | FFUP | 15 | $0.00 | $ - 0 | FFUP | 10 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | $ - 0 | |
| X801 | UVBx Service | FFUP | 0 | $ - 0 | FFUP | 15 | $0.00 | $ - 0 | FFUP | 10 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | FFUP | 5 | $0.00 | $ - 0 | $ - 0 | |
| Total Corrective Maintenance (UVBx) | $ - 0 | Total Corrective Maintenance (UVBx) | $ - 0 | Total Corrective Maintenance (UVBx) | $ - 0 | Total Corrective Maintenance (UVBx) | $ - 0 | Total Corrective Maintenance (UVBx) | $ - 0 | $ - 0 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| WARRANTY PERIODS (FFP) | CLIN 011 | CLIN 111 | CLIN 211 | CLIN 311 | CLIN 411 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X110 | MEP-Required Comprehensive Base Warranty (1 Year) | FFP | 13 | $ - 0 | FFP | 20 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | $ - 0 | |
| X111 | MEP-Two Years of Warranty | FFP | 0 | $ - 0 | FFP | 15 | $0.00 | $ - 0 | FFP | 10 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | $ - 0 | |
| X112 | MEP-Three Years of Warranty | FFP | 0 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | $ - 0 | |
| X113 | MEP-Four Years of Warranty | FFP | 0 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | $ - 0 | |
| X114 | MEP-Five Years of Warranty | FFP | 0 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | $ - 0 | |
| X115 | UVBx-Required Comprehensive Base Warranty (1 Year) | FFP | 13 | $ - 0 | FFP | 20 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | $ - 0 | |
| X116 | UVBx-Two Years of Warranty | FFP | 0 | $ - 0 | FFP | 15 | $0.00 | $ - 0 | FFP | 10 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | $ - 0 | |
| X117 | UVBx-Three Years of Warranty | FFP | 0 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | $ - 0 | |
| X118 | UVBx-Four Years of Warranty | FFP | 0 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | $ - 0 | |
| X119 | UVBx-Five Years of Warranty | FFP | 0 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | FFP | 0 | $0.00 | $ - 0 | $ - 0 |
Total General Requirements $ - 0 Total General Requirements $ - 0 Total General Requirements $ - 0 Total General Requirements $ - 0 Total General Requirements $ - 0 $ - 0
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | |
| ON-DEMAND SERVICES (FFP) |
tc={A639788C-B52E-496B-87D2-973CD9831B4D}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
[Tasks]
There is a task anchored to this comment that cannot be viewed in your client.
Comment:
@SHEYYAB, ALLA S I added an on-demand services section here we will need to work on completing.
Reply:
| Please see my comment on the LEP CLINs worksheet | CLIN 012 | CLIN 112 | CLIN 212 | CLIN 312 | CLIN 412 | ||||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total | |
| X126 | On-Demand Services | FFP | 13 | $ - 0 | FFP | 20 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | FFP | 5 | $0.00 | $ - 0 | $ - 0 | ||
| Engineering Services | |||||||||||||||||||||||
| Ad Hoc Reports | |||||||||||||||||||||||
| Site Surveys |
tc={74F15DE4-5B50-42FB-B88B-24E9C1DC1FBD}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
@MERLI, KAITLIN H (CTR) this cost (and some other sub-CLINs) is included under Civil works
| Provisioning Support | |||||||||||
| Retrofit Support | |||||||||||
| Relocation Services | |||||||||||
| Site Work | |||||||||||
| Disposal | |||||||||||
| Emergency Services | |||||||||||
| Special Events | |||||||||||
| Training Activities | |||||||||||
| Total General Requirements | $ - 0 | Total General Requirements | $ - 0 | Total General Requirements | $ - 0 | Total General Requirements | $ - 0 | Total General Requirements | $ - 0 | $ - 0 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | |||||||||||||||||
| INDIRECT RATES | CLIN 013 | CLIN 113 | CLIN 213 | CLIN 313 | CLIN 413 | ||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount |
| X142 | G&A | ||||||||||||||||||||
| X143 | T&M | ||||||||||||||||||||
| X144 | Profit |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| INCENTIVE POOL | CLIN 014 | CLIN 114 | CLIN 214 | CLIN 314 | CLIN 414 | |||||||||||||||||
| Sub-CLIN | Description (would need a CLIN for each Option Year) | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | |
| Year 1 Incentives: Equipment CLIN | FFP | 13 | $0.00 | $0.00 | FFP | 20 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | $ - 0 | |
| Year 1 Incentives: Warranty CLIN | FFP | 13 | $0.00 | $0.00 | FFP | 20 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | FFP | 5 | $0.00 | $0.00 | $ - 0 | |
| Total General Requirements | $0.00 | Total General Requirements | $0.00 | Total General Requirements | $0.00 | Total General Requirements | $0.00 | Total General Requirements | $0.00 | $0.00 |
| Total Price Per Period | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| Check | ||||||
| ERROR:#REF! | ||||||
| FFP - Firm Fixed Price | ||||||
| FFUP - Firm Fixed Unit Price | ||||||
| T&M - Time and Materials | ||||||
| EVM is discouraged for Firm-Fixed-Price (FFP) contracts, except when a FFP contract valued at $20M or more is used for development work; this exception requires a Milestone Decision | ||||||
| 1. This is a hybrid contract with both FFP and T&M. | ||||||
| 2. This vehicle will be around the $300M to $500M value per MEP and LEP IDIQ Awards. |
@SHEYYAB, ALLA S I added an on-demand services section here we will need to work on completing.
Please see my comment on the LEP CLINs worksheet
@MERLI, KAITLIN H (CTR) this cost (and some other sub-CLINs) is included under Civil works
&1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED
LEP CLINs
| Contractor Name: | ||||||||||||||||||||||
| Solicitation Number: | ||||||||||||||||||||||
| Task Order Number: | ||||||||||||||||||||||
| Task Order Title: | ||||||||||||||||||||||
| Base Period: September 30, 2026 to September 29, 2027 | ||||||||||||||||||||||
| Option 1: September 30, 2027 to September 29, 2028 | ||||||||||||||||||||||
| Option 2: September 30, 2028 to September 29, 2029 | ||||||||||||||||||||||
| Option 3: September 30, 2029 to September 29, 2030 | ||||||||||||||||||||||
| Option 4: September 30, 2030 to September 29, 2031 | ||||||||||||||||||||||
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| EQUIPMENT - LOW ENERGY PORTAL SYSTEM (FFP) | CLIN 001 | CLIN 101 | CLIN 201 | CLIN 301 | CLIN 401 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X104 | LEP-Type 1 (less than 5 units) | FFUP | 11 | $1,400,000.00 | $15,400,000.00 | FFUP | 15 | $1,470,000.00 | $22,050,000.00 | FFUP | 5 | $1,543,500.00 | $7,717,500.00 | FFUP | 5 | $1,620,675.00 | $8,103,375.00 | FFUP | 5 | $1,701,708.75 | $8,508,543.75 | $61,779,418.75 |
| X105 | LEP-Type 1 (units 5-10) | FFUP | 0 | $1,300,000.00 | $0.00 | FFUP | 0 | $1,365,000.00 | $0.00 | FFUP | 0 | $1,433,250.00 | $0.00 | FFUP | 0 | $1,504,912.50 | $0.00 | FFUP | 0 | $1,580,158.13 | $0.00 | $0.00 |
| X106 | LEP-Type 1 (units 11-20) | FFUP | 0 | $1,250,000.00 | $0.00 | FFUP | 0 | $1,312,500.00 | $0.00 | FFUP | 0 | $1,378,125.00 | $0.00 | FFUP | 0 | $1,447,031.25 | $0.00 | FFUP | 0 | $1,519,382.81 | $0.00 | $0.00 |
| X107 | LEP-Type 1 (more than 20 units) | FFUP | 0 | $1,200,000.00 | $0.00 | FFUP | 0 | $1,260,000.00 | $0.00 | FFUP | 0 | $1,323,000.00 | $0.00 | FFUP | 0 | $1,389,150.00 | $0.00 | FFUP | 0 | $1,458,607.50 | $0.00 | $0.00 |
| X108 | LEP-Type 2 (less than 5 units) | FFUP | 0 | $3,200,000.00 | $0.00 | FFUP | 0 | $3,360,000.00 | $0.00 | FFUP | 0 | $3,528,000.00 | $0.00 | FFUP | 0 | $3,704,400.00 | $0.00 | FFUP | 0 | $3,889,620.00 | $0.00 | $0.00 |
| X109 | LEP-Type 2 (units 5-10) | FFUP | 0 | $3,000,000.00 | $0.00 | FFUP | 0 | $3,150,000.00 | $0.00 | FFUP | 0 | $3,307,500.00 | $0.00 | FFUP | 0 | $3,472,875.00 | $0.00 | FFUP | 0 | $3,646,518.75 | $0.00 | $0.00 |
| X110 | LEP-Type 2 (units 11-20) | FFUP | 0 | $2,900,000.00 | $0.00 | FFUP | 0 | $3,045,000.00 | $0.00 | FFUP | 0 | $3,197,250.00 | $0.00 | FFUP | 0 | $3,357,112.50 | $0.00 | FFUP | 0 | $3,524,968.13 | $0.00 | $0.00 |
| X111 | LEP-Type 2 (more than 20 units) | FFUP | 0 | $2,800,000.00 | $0.00 | FFUP | 0 | $2,940,000.00 | $0.00 | FFUP | 0 | $3,087,000.00 | $0.00 | FFUP | 0 | $3,241,350.00 | $0.00 | FFUP | 0 | $3,403,417.50 | $0.00 | $0.00 |
| X112 | LEP-Type 3 (less than 5 units) | FFUP | 3 | $3,500,000.00 | $10,500,000.00 | FFUP | 1 | $3,675,000.00 | $3,675,000.00 | FFUP | 0 | $3,858,750.00 | $0.00 | FFUP | 0 | $4,051,687.50 | $0.00 | FFUP | 0 | $4,254,271.88 | $0.00 | $14,175,000.00 |
| X113 | LEP-Type 3 (units 5-10) | FFUP | 0 | $3,200,000.00 | $0.00 | FFUP | 0 | $3,360,000.00 | $0.00 | FFUP | 0 | $3,528,000.00 | $0.00 | FFUP | 0 | $3,704,400.00 | $0.00 | FFUP | 0 | $3,889,620.00 | $0.00 | $0.00 |
| X114 | LEP-Type 3 (units 11-20) | FFUP | 0 | $3,100,000.00 | $0.00 | FFUP | 0 | $3,255,000.00 | $0.00 | FFUP | 0 | $3,417,750.00 | $0.00 | FFUP | 0 | $3,588,637.50 | $0.00 | FFUP | 0 | $3,768,069.38 | $0.00 | $0.00 |
| X115 | LEP-Type 3 (more than 20 units) | FFUP | 0 | $3,000,000.00 | $0.00 | FFUP | 0 | $3,150,000.00 | $0.00 | FFUP | 0 | $3,307,500.00 | $0.00 | FFUP | 0 | $3,472,875.00 | $0.00 | FFUP | 0 | $3,646,518.75 | $0.00 | $0.00 |
| X116 | UVBx | FFUP | 14 | $629,316.00 | $8,810,424.00 | FFUP | 16 | $660,781.80 | $10,572,508.80 | FFUP | 5 | $693,820.89 | $3,469,104.45 | FFUP | 5 | $728,511.93 | $3,642,559.67 | FFUP | 5 | $764,937.53 | $3,824,687.66 | $30,319,284.58 |
Total Equipment Management $34,710,424.00 Total Equipment Management $36,297,508.80 Total Equipment Management $11,186,604.45 Total Equipment Management $11,745,934.67 Total Equipment Management $12,333,231.41 $106,273,703.33
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| SITE DESIGN (FFP) | CLIN 002 | CLIN 102 | CLIN 202 | CLIN 302 | CLIN 402 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X200 | Site Design | FFP | 14 | $100,000.00 | $1,400,000.00 | FFP | 16 | $105,000.00 | $1,680,000.00 | FFP | 5 | $110,250.00 | $551,250.00 | FFP | 5 | $115,762.50 | $578,812.50 | FFP | 5 | $121,550.63 | $607,753.13 | $4,817,815.63 |
| X201 | Concept Review | |||||||||||||||||||||
| X202 | 50% Design | |||||||||||||||||||||
| X203 | 95% Design | |||||||||||||||||||||
| X204 | Issued for Construction Drawings | |||||||||||||||||||||
| Total Site Design | $1,400,000.00 | Total Site Design | $1,680,000.00 | Total Site Design | $551,250.00 | Total Site Design | $578,812.50 | Total Site Design | $607,753.13 | $4,817,815.63 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| CIVIL WORKS (T&M) | CLIN 003 | CLIN 103 | CLIN 203 | CLIN 303 | CLIN 403 | |||||||||||||||||
| Sub - CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X300 | Mobilization and Site Preparations, Securing the site, Demobilization | T&M | 14 | $200,000.00 | $ 2,800,000.00 | T&M | 16 | $210,000.00 | $ 3,360,000.00 | T&M | 5 | $220,500.00 | $ 1,102,500.00 | T&M | 5 | $231,525.00 | $ 1,157,625.00 | T&M | 5 | $243,101.25 | $ 1,215,506.25 | $ 9,635,631.25 |
| X301 | Command Center-New Construction | T&M | 11 | $600,000.00 | $ 6,600,000.00 | T&M | 13 | $630,000.00 | $ 8,190,000.00 | T&M | 3 | $661,500.00 | $ 1,984,500.00 | T&M | 2 | $694,575.00 | $ 1,389,150.00 | T&M | 5 | $729,303.75 | $ 3,646,518.75 | $ 21,810,168.75 |
| X302 | Command Center-Retrofit | T&M | 3 | $73,717.00 | $ 221,151.00 | T&M | 3 | $77,402.85 | $ 232,208.55 | T&M | 2 | $81,272.99 | $ 162,545.99 | T&M | 3 | $85,336.64 | $ 256,009.93 | T&M | 0 | $89,603.47 | $ - 0 | $ 871,915.47 |
| X303 | Demolition/Excavation/Removal/Saw Cut | T&M | 14 | $350,000.00 | $ 4,900,000.00 | T&M | 16 | $367,500.00 | $ 5,880,000.00 | T&M | 5 | $385,875.00 | $ 1,929,375.00 | T&M | 5 | $405,168.75 | $ 2,025,843.75 | T&M | 5 | $425,427.19 | $ 2,127,135.94 | $ 16,862,354.69 |
| X304 | Clearing/Grubing, Dirt Work (balancing cut/fill), Compaction, Drainage | T&M | 14 | $280,000.00 | $ 3,920,000.00 | T&M | 16 | $294,000.00 | $ 4,704,000.00 | T&M | 5 | $308,700.00 | $ 1,543,500.00 | T&M | 5 | $324,135.00 | $ 1,620,675.00 | T&M | 5 | $340,341.75 | $ 1,701,708.75 | $ 13,489,883.75 |
| X305 | Electrical/Plumbing/Mechanical | T&M | 14 | $800,000.00 | $ 11,200,000.00 | T&M | 16 | $840,000.00 | $ 13,440,000.00 | T&M | 5 | $882,000.00 | $ 4,410,000.00 | T&M | 5 | $926,100.00 | $ 4,630,500.00 | T&M | 5 | $972,405.00 | $ 4,862,025.00 | $ 38,542,525.00 |
| X306 | Concrete/Asphalt/Footers/Foundations/Lanes of Traffic | T&M | 14 | $630,000.00 | $ 8,820,000.00 | T&M | 16 | $661,500.00 | $ 10,584,000.00 | T&M | 5 | $694,575.00 | $ 3,472,875.00 | T&M | 5 | $729,303.75 | $ 3,646,518.75 | T&M | 5 | $765,768.94 | $ 3,828,844.69 | $ 30,352,238.44 |
| X307 | Steel Work | T&M | 14 | $350,000.00 | $ 4,900,000.00 | T&M | 16 | $367,500.00 | $ 5,880,000.00 | T&M | 5 | $385,875.00 | $ 1,929,375.00 | T&M | 5 | $405,168.75 | $ 2,025,843.75 | T&M | 5 | $425,427.19 | $ 2,127,135.94 | $ 16,862,354.69 |
| X308 | Traffic Control Measures, Jersey Barriers, Speed bumps, striping, signage | T&M | 14 | $350,000.00 | $ 4,900,000.00 | T&M | 16 | $367,500.00 | $ 5,880,000.00 | T&M | 5 | $385,875.00 | $ 1,929,375.00 | T&M | 5 | $405,168.75 | $ 2,025,843.75 | T&M | 5 | $425,427.19 | $ 2,127,135.94 | $ 16,862,354.69 |
| X309 | IT Trenches, Conduit, Conduit Banks, Junction Boxes, Pull Strings | T&M | 14 | $250,000.00 | $ 3,500,000.00 | T&M | 16 | $262,500.00 | $ 4,200,000.00 | T&M | 5 | $275,625.00 | $ 1,378,125.00 | T&M | 5 | $289,406.25 | $ 1,447,031.25 | T&M | 5 | $303,876.56 | $ 1,519,382.81 | $ 12,044,539.06 |
| X310 | Site Survey | T&M | 14 | $862,747.00 | $ 12,078,458.00 | T&M | 16 | $905,884.35 | $ 14,494,149.60 | T&M | 5 | $951,178.57 | $ 4,755,892.84 | T&M | 5 | $998,737.50 | $ 4,993,687.48 | T&M | 5 | $1,048,674.37 | $ 5,243,371.85 | $ 41,565,559.77 |
| X311 | SWPPP, Permiting | T&M | 14 | $50,000.00 | $ 700,000.00 | T&M | 16 | $52,500.00 | $ 840,000.00 | T&M | 5 | $55,125.00 | $ 275,625.00 | T&M | 5 | $57,881.25 | $ 289,406.25 | T&M | 5 | $60,775.31 | $ 303,876.56 | $ 2,408,907.81 |
Total Civil Works $ 64,539,609.00 Total Civil Works $ 77,684,358.15 Total Civil Works $ 24,873,688.83 Total Civil Works $ 25,508,134.91 Total Civil Works $ 28,702,642.48 $ 221,308,433.37
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| FURNITURE, FIXTURES, AND EQUIPMENT (FFP) | CLIN 004 | CLIN 104 | CLIN 204 | CLIN 304 | CLIN 404 | |||||||||||||||||
| Sub - CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X400 | Analyst Station | FFUP | 28 | $8,500.00 | $ 238,000.00 | FFUP | 32 | $8,925.00 | $ 285,600.00 | FFUP | 10 | $9,371.25 | $ 93,712.50 | FFUP | 10 | $9,839.81 | $ 98,398.13 | FFUP | 10 | $10,331.80 | $ 103,318.03 | $ 819,028.66 |
| X401 | Operator Station | FFUP | 14 | $8,500.00 | $ 119,000.00 | FFUP | 16 | $8,925.00 | $ 142,800.00 | FFUP | 5 | $9,371.25 | $ 46,856.25 | FFUP | 5 | $9,839.81 | $ 49,199.06 | FFUP | 5 | $10,331.80 | $ 51,659.02 | $ 409,514.33 |
| X402 | Situational Wall | FFUP | 1 | $50,000.00 | $ 50,000.00 | FFUP | 1 | $52,500.00 | $ 52,500.00 | FFUP | 1 | $55,125.00 | $ 55,125.00 | FFUP | 1 | $57,881.25 | $ 57,881.25 | FFUP | 1 | $60,775.31 | $ 60,775.31 | $ 276,281.56 |
| X403 | Furniture and fixtures | FFUP | 1 | $10,000.00 | $ 10,000.00 | FFUP | 1 | $10,500.00 | $ 10,500.00 | FFUP | 1 | $11,025.00 | $ 11,025.00 | FFUP | 1 | $11,576.25 | $ 11,576.25 | FFUP | 1 | $12,155.06 | $ 12,155.06 | $ 55,256.31 |
| X404 | Generators | FFUP | 1 | $50,000.00 | $ 50,000.00 | FFUP | 1 | $52,500.00 | $ 52,500.00 | FFUP | 1 | $55,125.00 | $ 55,125.00 | FFUP | 1 | $57,881.25 | $ 57,881.25 | FFUP | 1 | $60,775.31 | $ 60,775.31 | $ 276,281.56 |
| X405 | Uninterrupted Power Supplies | FFUP | 1 | $100,000.00 | $ 100,000.00 | FFUP | 1 | $105,000.00 | $ 105,000.00 | FFUP | 1 | $110,250.00 | $ 110,250.00 | FFUP | 1 | $115,762.50 | $ 115,762.50 | FFUP | 1 | $121,550.63 | $ 121,550.63 | $ 552,563.13 |
| X406 | Power Conditioners | FFUP | 1 | $50,000.00 | $ 50,000.00 | FFUP | 1 | $52,500.00 | $ 52,500.00 | FFUP | 1 | $55,125.00 | $ 55,125.00 | FFUP | 1 | $57,881.25 | $ 57,881.25 | FFUP | 1 | $60,775.31 | $ 60,775.31 | $ 276,281.56 |
| X407 | Operator Booth (8'x12') | FFUP | 11 | $100,000.00 | $ 1,100,000.00 | FFUP | 13 | $105,000.00 | $ 1,365,000.00 | FFUP | 3 | $110,250.00 | $ 330,750.00 | FFUP | 2 | $115,762.50 | $ 231,525.00 | FFUP | 5 | $121,550.63 | $ 607,753.13 | $ 3,635,028.13 |
| X408 | Operator Booth (12'x16') | FFUP | 3 | $130,000.00 | $ 390,000.00 | FFUP | 3 | $136,500.00 | $ 409,500.00 | FFUP | 2 | $143,325.00 | $ 286,650.00 | FFUP | 3 | $150,491.25 | $ 451,473.75 | FFUP | 0 | $158,015.81 | $ - 0 | $ 1,537,623.75 |
| X409 | Laptops | FFUP | 15 | $4,000.00 | $ 60,000.00 | FFUP | 15 | $4,200.00 | $ 63,000.00 | FFUP | 15 | $4,410.00 | $ 66,150.00 | FFUP | 15 | $4,630.50 | $ 69,457.50 | FFUP | 15 | $4,862.03 | $ 72,930.38 | $ 331,537.88 |
Total Construction $ 2,167,000.00 Total Construction $ 2,538,900.00 Total Construction $ 1,110,768.75 Total Construction $ 1,201,035.94 Total Construction $ 1,151,692.18 $ 8,169,396.87
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| INSTALLATION (T&M) | CLIN 005 | CLIN 105 | CLIN 205 | CLIN 305 | CLIN 405 | |||||||||||||||||
| Sub - CLIN | Description | Type | Rate | Amount | Type | Rate | Amount | Type | Rate | Amount | Type | Rate | Amount | Type | Rate | Amount | Total | |||||
| X500 | Installation | T&M | 14 | $1,602,650.00 | $ 22,437,100.00 | T&M | 16 | $1,682,782.50 | $ 26,924,520.00 | T&M | 5 | $1,766,921.63 | $ 8,834,608.13 | T&M | 5 | $1,855,267.71 | $ 9,276,338.53 | T&M | 5 | $1,948,031.09 | $ 9,740,155.46 | $ 77,212,722.12 |
| X501 | Integration | T&M | 14 | $750,000.00 | $ 10,500,000.00 | T&M | 16 | $787,500.00 | $ 12,600,000.00 | T&M | 5 | $826,875.00 | $ 4,134,375.00 | T&M | 5 | $868,218.75 | $ 4,341,093.75 | T&M | 5 | $911,629.69 | $ 4,558,148.44 | $ 36,133,617.19 |
| X502 | Blanking Solution | T&M | 14 | $400,000.00 | $ 5,600,000.00 | T&M | 16 | $420,000.00 | $ 6,720,000.00 | T&M | 5 | $441,000.00 | $ 2,205,000.00 | T&M | 5 | $463,050.00 | $ 2,315,250.00 | T&M | 5 | $486,202.50 | $ 2,431,012.50 | $ 19,271,262.50 |
| X503 | System Testing | T&M | 14 | $300,000.00 | $ 4,200,000.00 | T&M | 16 | $315,000.00 | $ 5,040,000.00 | T&M | 5 | $330,750.00 | $ 1,653,750.00 | T&M | 5 | $347,287.50 | $ 1,736,437.50 | T&M | 5 | $364,651.88 | $ 1,823,259.38 | $ 14,453,446.88 |
| X504 | Software installation/upgrade | T&M | 14 | $800,000.00 | $ 11,200,000.00 | T&M | 16 | $840,000.00 | $ 13,440,000.00 | T&M | 5 | $882,000.00 | $ 4,410,000.00 | T&M | 5 | $926,100.00 | $ 4,630,500.00 | T&M | 5 | $972,405.00 | $ 4,862,025.00 | $ 38,542,525.00 |
Total Installation $ 53,937,100.00 Total Installation $ 64,724,520.00 Total Installation $ 21,237,733.13 Total Installation $ 22,299,619.78 Total Installation $ 23,414,600.78 $ 185,613,573.69
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| TRAINING (FFP) | CLIN 006 | CLIN 106 | CLIN 206 | CLIN 306 | CLIN 406 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | |
| X600 | Training Development | FFP | 1 | $80,000.00 | $ 80,000.00 | FFP | 0 | $ 84,000.00 | $ - 0 | FFP | 0 | $ 88,200.00 | $ - 0 | FFP | 0 | $ 92,610.00 | $ - 0 | FFP | 0 | $ 97,240.50 | $ - 0 | $ 80,000.00 |
Total Training $ 80,000.00 Total Training $ - 0 Total Training $ - 0 Total Training $ - 0 Total Training $ - 0 $ 80,000.00
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| PREVENTATIVE MAINTENANCE OPTIONS (FFP) | CLIN 007 | CLIN 107 | CLIN 207 | CLIN 307 | CLIN 407 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | |
| X700 | LEP Service | FFUP | 14 | $25,000.00 | $ 350,000.00 | FFUP | 16 | $26,250.00 | $ 420,000.00 | FFUP | 5 | $27,562.50 | $ 137,812.50 | FFUP | 5 | $28,940.63 | $ 144,703.13 | FFUP | 5 | $30,387.66 | $ 151,938.28 | $ 1,204,453.91 |
| X701 | UVBx Service | FFUP | 14 | $4,023.00 | $ 56,322.00 | FFUP | 16 | $4,224.15 | $ 67,586.40 | FFUP | 5 | $4,435.36 | $ 22,176.79 | FFUP | 5 | $4,657.13 | $ 23,285.63 | FFUP | 5 | $4,889.98 | $ 24,449.91 | $ 193,820.72 |
| Total Preventative Maintenance (UVBx) | $ 406,322.00 | Total Preventative Maintenance (UVBx) | $ 487,586.40 | Total Preventative Maintenance (UVBx) | $ 159,989.29 | Total Preventative Maintenance (UVBx) | $ 167,988.75 | Total Preventative Maintenance (UVBx) | $ 176,388.19 | $ 1,398,274.63 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| CORRECTIVE MAINTENANCE OPTIONS (FFP) | CLIN 009 | CLIN 109 | CLIN 209 | CLIN 309 | CLIN 409 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | |
| X800 | LEP Service | FFUP | 1 | $0.00 | $ - 0 | FFUP | 14 | $99,576.09 | $ 1,394,065.22 | FFUP | 16 | $104,554.89 | $ 1,672,878.26 | FFUP | 5 | $109,782.64 | $ 548,913.18 | FFUP | 5 | $115,271.77 | $ 576,358.84 | $ 4,192,215.50 |
| X801 | UVBx Service | FFUP | 1 | $0.00 | $ - 0 | FFUP | 14 | $14,000.00 | $ 196,000.00 | FFUP | 16 | $14,700.00 | $ 235,200.00 | FFUP | 5 | $15,435.00 | $ 77,175.00 | FFUP | 5 | $16,206.75 | $ 81,033.75 | $ 589,408.75 |
| Total Corrective Maintenance (UVBx) | $ - 0 | Total Corrective Maintenance (UVBx) | $ 1,590,065.22 | Total Corrective Maintenance (UVBx) | $ 1,908,078.26 | Total Corrective Maintenance (UVBx) | $ 626,088.18 | Total Corrective Maintenance (UVBx) | $ 657,392.59 | $ 4,781,624.25 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||
| WARRANTY PERIODS (FFP) | CLIN 011 | CLIN 111 | CLIN 211 | CLIN 311 | CLIN 411 | |||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total |
| X110 | LEP-Required Comprehensive Base Warranty (1 Year) | FFP | 14 | $100,000.00 | $ 1,400,000.00 | FFP | 16 | $105,000.00 | $ 1,680,000.00 | FFP | 5 | $110,250.00 | $ 551,250.00 | FFP | 5 | $115,762.50 | $ 578,812.50 | FFP | 5 | $121,550.63 | $ 607,753.13 | $ 4,817,815.63 |
| X126 | LEP-Type 1 Two Years of Warranty | FFP | 0 | $250,000.00 | $ - 0 | FFP | 7 | $262,500.00 | $ 1,837,500.00 | FFP | 8 | $275,625.00 | $ 2,205,000.00 | FFP | 5 | $289,406.25 | $ 1,447,031.25 | FFP | 5 | $303,876.56 | $ 1,519,382.81 | $ 7,008,914.06 |
| X127 | LEP-Type 1 Three Years of Warranty | FFP | 0 | $350,000.00 | $ - 0 | FFP | 0 | $367,500.00 | $ - 0 | FFP | 0 | $385,875.00 | $ - 0 | FFP | 0 | $405,168.75 | $ - 0 | FFP | 0 | $425,427.19 | $ - 0 | $ - 0 |
| X128 | LEP Type 1 Four Years of Warranty | FFP | 0 | $450,000.00 | $ - 0 | FFP | 0 | $472,500.00 | $ - 0 | FFP | 0 | $496,125.00 | $ - 0 | FFP | 0 | $520,931.25 | $ - 0 | FFP | 0 | $546,977.81 | $ - 0 | $ - 0 |
| X129 | LEP Type 1 Five Years of Warranty | FFP | 0 | $550,000.00 | $ - 0 | FFP | 0 | $577,500.00 | $ - 0 | FFP | 0 | $606,375.00 | $ - 0 | FFP | 0 | $636,693.75 | $ - 0 | FFP | 0 | $668,528.44 | $ - 0 | $ - 0 |
| X130 | LEP-Type 2 Two Years of Warranty | FFP | 0 | $420,000.00 | $ - 0 | FFP | 0 | $441,000.00 | $ - 0 | FFP | 0 | $463,050.00 | $ - 0 | FFP | 0 | $486,202.50 | $ - 0 | FFP | 0 | $510,512.63 | $ - 0 | $ - 0 |
| X131 | LEP-Type 2 Three Years of Warranty | FFP | 0 | $650,000.00 | $ - 0 | FFP | 0 | $682,500.00 | $ - 0 | FFP | 0 | $716,625.00 | $ - 0 | FFP | 0 | $752,456.25 | $ - 0 | FFP | 0 | $790,079.06 | $ - 0 | $ - 0 |
| X132 | LEP Type 2 Four Years of Warranty | FFP | 0 | $850,000.00 | $ - 0 | FFP | 0 | $892,500.00 | $ - 0 | FFP | 0 | $937,125.00 | $ - 0 | FFP | 0 | $983,981.25 | $ - 0 | FFP | 0 | $1,033,180.31 | $ - 0 | $ - 0 |
| X133 | LEP Type 2 Five Years of Warranty | FFP | 0 | $1,100,000.00 | $ - 0 | FFP | 0 | $1,155,000.00 | $ - 0 | FFP | 0 | $1,212,750.00 | $ - 0 | FFP | 0 | $1,273,387.50 | $ - 0 | FFP | 0 | $1,337,056.88 | $ - 0 | $ - 0 |
| X134 | LEP-Type 3 Two Years of Warranty | FFP | 0 | $500,000.00 | $ - 0 | FFP | 0 | $525,000.00 | $ - 0 | FFP | 0 | $551,250.00 | $ - 0 | FFP | 0 | $578,812.50 | $ - 0 | FFP | 0 | $607,753.13 | $ - 0 | $ - 0 |
| X135 | LEP-Type 3 Three Years of Warranty | FFP | 0 | $750,000.00 | $ - 0 | FFP | 0 | $787,500.00 | $ - 0 | FFP | 0 | $826,875.00 | $ - 0 | FFP | 0 | $868,218.75 | $ - 0 | FFP | 0 | $911,629.69 | $ - 0 | $ - 0 |
| X136 | LEP Type 3 Four Years of Warranty | FFP | 0 | $1,000,000.00 | $ - 0 | FFP | 0 | $1,050,000.00 | $ - 0 | FFP | 0 | $1,102,500.00 | $ - 0 | FFP | 0 | $1,157,625.00 | $ - 0 | FFP | 0 | $1,215,506.25 | $ - 0 | $ - 0 |
| X137 | LEP Type 3 Five Years of Warranty | FFP | 0 | $1,250,000.00 | $ - 0 | FFP | 0 | $1,312,500.00 | $ - 0 | FFP | 0 | $1,378,125.00 | $ - 0 | FFP | 0 | $1,447,031.25 | $ - 0 | FFP | 0 | $1,519,382.81 | $ - 0 | $ - 0 |
| X115 | UVBx-Required Comprehensive Base Warranty (1 Year) | FFP | 14 | $35,000.00 | $ 490,000.00 | FFP | 16 | $36,750.00 | $ 588,000.00 | FFP | 5 | $38,587.50 | $ 192,937.50 | FFP | 5 | $40,516.88 | $ 202,584.38 | FFP | 5 | $42,542.72 | $ 212,713.59 | $ 1,686,235.47 |
| X138 | UVBx-Two Years of Warranty | FFP | 0 | $70,000.00 | $ - 0 | FFP | 7 | $73,500.00 | $ 514,500.00 | FFP | 8 | $77,175.00 | $ 617,400.00 | FFP | 5 | $81,033.75 | $ 405,168.75 | FFP | 5 | $85,085.44 | $ 425,427.19 | $ 1,962,495.94 |
| X139 | UVBx-Three Years of Warranty | FFP | 0 | $140,000.00 | $ - 0 | FFP | 0 | $147,000.00 | $ - 0 | FFP | 0 | $154,350.00 | $ - 0 | FFP | 0 | $162,067.50 | $ - 0 | FFP | 0 | $170,170.88 | $ - 0 | $ - 0 |
| X140 | UVBx-Four Years of Warranty | FFP | 0 | $210,000.00 | $ - 0 | FFP | 0 | $220,500.00 | $ - 0 | FFP | 0 | $231,525.00 | $ - 0 | FFP | 0 | $243,101.25 | $ - 0 | FFP | 0 | $255,256.31 | $ - 0 | $ - 0 |
| X141 | UVBx-Five Years of Warranty | FFP | 0 | $280,000.00 | $ - 0 | FFP | 0 | $294,000.00 | $ - 0 | FFP | 0 | $308,700.00 | $ - 0 | FFP | 0 | $324,135.00 | $ - 0 | FFP | 0 | $340,341.75 | $ - 0 | $ - 0 |
Total General Requirements $ 1,890,000.00 Total General Requirements $ 4,620,000.00 Total General Requirements $ 3,566,587.50 Total General Requirements $ 2,633,596.88 Total General Requirements $ 2,765,276.72 $ 15,475,461.09
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | |
| ON-DEMAND SERVICES (FFP) |
tc={E7390B8D-EE95-4665-A268-9E4FDA9CD2C5}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
[Tasks]
There is a task anchored to this comment that cannot be viewed in your client.
Comment:
@SHEYYAB, ALLA S I added an on-demand services section here we will need to work on completing.
Reply:
| My understanding is this line is for on-demand repair services (at least that’s my understanding from ILD spreadsheet). Some of the sub-CLINs here, such as “site work” are covered under civil works. It’s close to impossible to try and break the site work cost out of the civil works CLIN. I recommend renaming the “Civil works” CLIN if on-demand services is the preferred name | CLIN 012 | CLIN 112 | CLIN 212 | CLIN 312 | CLIN 412 | ||||||||||||||||||
| Sub-CLIN | Description | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Type | Qty | Rate | Amount | Total | |
| X126 | On-Demand Services (On-demand system repair) | FFP | 14 | $12,650.19 | $ 177,102.72 | FFP | 16 | $13,282.70 | $ 212,523.27 | FFP | 5 | $13,946.84 | $ 69,734.20 | FFP | 5 | $14,644.18 | $ 73,220.91 | FFP | 5 | $15,376.39 | $ 76,881.95 | $ 609,463.04 | |
| Engineering Services | |||||||||||||||||||||||
| Ad Hoc Reports | |||||||||||||||||||||||
| Site Surverys | |||||||||||||||||||||||
| Provisioning Support | |||||||||||||||||||||||
| Retrofit Support |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .