OES SIR L Att L4.xlsx
XLSX spreadsheet 118 KB Posted
- Attached to
- Screening Information Request (SIR) for Ontario Engineering Services (OES) Federal contract opportunity
- Solicitation number
- 693KA8-23-R-00004
View the file
Other files for this federal contract opportunity
Show all 40
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cover Sheet
| PART IV – REPRESENTATIONS AND INSTRUCTIONS |
| SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS |
| ATTACHMENT L4 – PRICE EVALUATION MODEL |
FOR
SCREENING INFORMATION REQUEST
Solicitation Number: 693KA8-23-R-00004
Ontario Engineering Services (OES)
DEPARTMENT OF TRANSPORTATION
FEDERAL AVIATION ADMINISTRATION
&"Arial,Bold"&12
&"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
PEM Directions
OES PRICE EVALUATION MODEL DIRECTIONS
Ø The Price Evaluation Model (PEM) must be completed as described below. The PEM must be submitted in Excel format with no changes except for adding the required data in the unlocked cells.
Ø Data can only be entered into the cells which are colored salmon and unlocked in the “FFP Prices & Quantities” and “Labor Hourly Rate Schedule” tabs. All the other worksheets are totally locked.
Ø All of the calculations are automatic and cannot be changed.
Ø To calculate the Not to Exceed (NTE) labor amounts for the Base and Option Periods, the FAA utilizes 1920 hours for a person year. With the exception of the Installation/Electronics Technician, the labor categories which have more than one level (senior, mid, junior) the annual total estimated Level of Effort has been placed in the senior level for the NTE calculation. This is not intended to indicate all the work required on the OES contract will require senior level personnel. For Installation/Electronics Technicians, the labor of effort was split between Lead and Mid.
Ø On the Labor Person-Years by CLIN tab, the labor categories shown for "Estimated Ontario LOE" will work only at the Ontario, CA site. The labor categories shown for "Estimated Floating Crew LOE" and "Estimated Floating Crew Support" may work anywhere in the Continental United States (CONUS) and Alaska. Labor rates apply to all direct labor hours regardless of whether the Contractor or one of its subcontractors or partners performs the labor.
Ø The Not to Exceed (NTE) amounts for CLINs X002B Technical Support Services - Direct Charges and CLINs X003 Technical Support Services - Major Projects have been set by the FAA for the Base Period and the four (4) Option Periods. The minimums for the these CLINs are set at zero dollars ($0.00).
Ø CLINs X002B Technical Support Services - Direct Charges contain the following sub-CLINs: X002B.1 Travel, X002B.2 Material, X002B.3 Contractor Acquired Property (CAP), X002B.4 Other Direct Charges (ODC), X002B.5 Rack Shipping, X002B.6 Truck Leases, X002B.7 Trailers, and X002B.8 Subcontracts. See Section H.8 for more information regarding CLINs X002B. Technical Support Services - Direct Charges are acquired at actual cost as allocated by Task Order. These costs may include all appropriate indirect cost.
Ø The contractor must complete the following:
l FFP Prices & Quantities tab:
n Fill in an escalation rate for Years 2 through 10 in row 27.
| n | Year 1 FFP Build Up blocks are provided to show how the proposed Year 1 rates were derived for the FFP items. Identify each Cost Category, the Amount (e.g., labor hours) and Cost (e.g., labor rate) for cost category. The calculations are automatic. Please note, the FAA provides the majority of the materials for the CLINs X001A-D items to the contractor. Any material not provided by the FAA and shipping costs are considered reimbursable items and can be included in the monthly invoices to the FAA. | |
| ¡ | Complete the Fabricated Racks for Fabricated Racks for First Article Examination (FAE) block. The total amount in cell E36 will be automatically inserted into cell C21. | |
| ¡ | Complete the Fabricated Racks block. The total amount in cell E45 will be automatically inserted into cell C22. | |
| ¡ | Complete the Mod Kits block. The total amount in cell L45 will be automatically inserted into cell C23. | |
| ¡ | Complete the Site Kits block. The total amount in cell E54 will be automatically inserted into cell C24. | |
| ¡ | Complete the Rack Subassemblies block. The total amount in cell L54 will be automatically inserted into cell C25. |
l Labor Hourly Rate Schedule tab:
The Offeror must fill in a Time and Material (T&M) rate for all labor categories sub-CLINs (X002A.1 through X002A.19) for Year 1 in cells C4 through C22 and an escalation rate cells D26 through L26 for Years 2 through 10. The labor rates for Years 2 through 10 will be calculated automatically in the PEM. All PEM labor category rates will be used to set rates at contract award.
Labor category rates proposed must be fully burdened hourly rates that include wages, fringe benefits, overhead, general and administrative costs and profit.
l Indirect Rate for Direct Charges
In the cell to the right, enter the indirect rate which will be applied the Direct Charges. Any build up in this rate must be described in the Price Narrative.
PART IV – REPRESENTATIONS AND INSTRUCTIONS
SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS
ATTACHMENT L4 – PRICE EVALUATION MODEL &"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
OES TEP
OES TOTAL EVALUATED PRICE (TEP)
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 1 | Min Units - Year 1 | Max Units - Year 1 | Minimum | Extended Ceiling |
| 1000 | FFP | Fabricated Racks for FAE | C.6.1.2, J1 | Each | $0.00 | 4 | 4 | $0.00 | $0.00 |
| 1001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 1001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 1001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 1001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 1001 Totals: | $0.00 | $0.00 | |||||||
| 1002A | T&M | Technical Support Services - Labor | C.4 - C.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 1002B | T&M | Technical Support Services - Direct Charges | C.4 - C.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 1002 Totals: | $0.00 | $0.00 | |||||||
| 1003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 2 | Min Units - Year 2 | Max Units - Year 2 | Minimum | Extended Ceiling |
| 2001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 2001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 2001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 2001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 2001 Totals: | $0.00 | $0.00 | |||||||
| 2002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 2002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 2002 Totals: | $0.00 | $0.00 | |||||||
| 2003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 3 | Min Units - Year 3 | Max Units - Year 3 | Minimum | Extended Ceiling |
| 3001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 3001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 3001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 3001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 3001 Totals: | $0.00 | $0.00 | |||||||
| 3002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 3002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 3002 Totals: | $0.00 | $0.00 | |||||||
| 3003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 4 | Min Units - Year 4 | Max Units - Year 4 | Minimum | Extended Ceiling |
| 4001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 4001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 4001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 4001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 4001 Totals: | $0.00 | $0.00 | |||||||
| 4002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 4002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 4002 Totals: | $0.00 | $0.00 | |||||||
| 4003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 | |||||||
| FFP CLINs 1001-4001 Base Period Totals: | $0.00 | $0.00 | |||||||
| T&M CLINs 1002A-4002A Base Period Totals: | $0.00 | $0.00 | |||||||
| T&M CLINs 1002B-4002B Base Period Totals: | $0.00 | $23,541,000.00 | |||||||
| FFP CLINs 1003-4003 Base Period Totals: | $0.00 | $2,146,000.00 | |||||||
| Base Period Minimum and Ceiling Totals: | $0.00 | $25,687,000.00 | |||||||
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 5 | Min Units - Year 5 | Max Units - Year 5 | Minimum | Extended Ceiling |
| 5001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 5001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 5001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 5001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 5001 Totals: | $0.00 | $0.00 | |||||||
| 5002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 5002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 5002 Totals: | $0.00 | $0.00 | |||||||
| 5003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 6 | Min Units - Year 6 | Max Units - Year 6 | Minimum | Extended Ceiling |
| 6001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 6001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 6001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 6001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 6001 Totals: | $0.00 | $0.00 | |||||||
| 6002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 6002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 6002 Totals: | $0.00 | $0.00 | |||||||
| 6003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| FFP CLINs 5001-6001 Option Period 1 Totals: | $0.00 | $0.00 |
| T&M CLINs 5002A-6002A Option Period 1 Totals: | $0.00 | $0.00 |
| T&M CLINs 5002B-6002B Option Period 1 Totals: | $0.00 | $12,536,000.00 |
| FFP CLINs 5003-6003 Option Period 1 Totals: | $0.00 | $1,138,000.00 |
| Option Period 1 Minimum and Ceiling Totals: | $0.00 | $13,674,000.00 |
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 7 | Min Units - Year 7 | Max Units - Year 7 | Minimum | Extended Ceiling |
| 7001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 7001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 7001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 7001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 7001 Totals: | $0.00 | $0.00 | |||||||
| 7002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 7002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 7002 Totals: | $0.00 | $0.00 | |||||||
| 7003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 8 | Min Units - Year 8 | Max Units - Year 8 | Minimum | Extended Ceiling |
| 8001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 8001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 8001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 8001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 8001 Totals: | $0.00 | $0.00 | |||||||
| 8002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 8002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 8002 Totals: | $0.00 | $0.00 | |||||||
| 8003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| FFP CLINs 7001-8001 Option Period 2 Totals: | $0.00 | $0.00 | |||||||
| T&M CLINs 7002A-8002A Option Period 2 Totals: | $0.00 | $0.00 | |||||||
| T&M CLINs 7002A-8002A Option Period 2 Totals: | $0.00 | $12,946,000.00 | |||||||
| FFP CLINs 7003-8003 Option Period 2 Totals: | $0.00 | $1,184,000.00 | |||||||
| Option Period 2 Minimum and Ceiling Totals: | $0.00 | $14,130,000.00 | |||||||
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 9 | Min Units - Year 9 | Max Units - Year 9 | Minimum | Extended Ceiling |
| 9001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 9001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 9001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 9001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 9001 Totals: | $0.00 | $0.00 | |||||||
| 9002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 9002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 9002 Totals: | $0.00 | $0.00 | |||||||
| 9003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| Total: | $0.00 | $0.00 |
| FFP CLIN 9001 Option Period 3 Totals: | $0.00 | $0.00 |
| T&M CLIN 9002A Option Period 3 Totals: | $0.00 | $0.00 |
| T&M CLIN 9002B Option Period 3 Totals: | $0.00 | $6,668,000.00 |
| FFP CLIN 9003 Option Period 3 Totals: | $0.00 | $610,000.00 |
| Option Period 3 Minimum and Ceiling Totals: | $0.00 | $7,278,000.00 |
| CLIN | Type | Description | SOW Reference | Unit of Measure | Unit Price - Year 10 | Min Units - Year 10 | Max Units - Year 10 | Minimum | Extended Ceiling |
| 10001A | FFP | Fabricated Racks | C.6.1.2, J1 | Each | $0.00 | 35 | 300 | $0.00 | $0.00 |
| 10001B | FFP | Mod Kits | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| 10001C | FFP | Site Kits | C.6.1.2, J4 | Each | $0.00 | 30 | 175 | $0.00 | $0.00 |
| 10001D | FFP | Rack Subassemblies | C.6.1.2, J1 | Each | $0.00 | 0 | 100 | $0.00 | $0.00 |
| CLIN 9001 Totals: | $0.00 | $0.00 | |||||||
| 10002A | T&M or FFP | Technical Support Services - Labor | C.6.4 - C.6.7, J5 | N/A | N/A | N/A | NTE | $0.00 | $0.00 |
| 10002B | T&M or FFP | Technical Support Services - Direct Charges | C.6.4 - C.6.7, H9 | N/A | N/A | N/A | NTE | $0.00 | |
| CLIN 9002 Totals: | $0.00 | $0.00 | |||||||
| 10003 | FFP | Technical Support Services - AGVC and Other FAA Projects | C.4 - C.7 | N/A | N/A | N/A | NTE | $0.00 | |
| $675.00 | $0.00 | $0.00 |
| FFP CLIN 10001 Option Period 4 Totals: | $0.00 | $0.00 |
| T&M CLIN 10002A Option Period 4 Totals: | $0.00 | $0.00 |
| T&M CLIN 10002B Option Period 4 Totals: | $0.00 | $6,801,000.00 |
| CLIN 10003 Option Period 4 Totals: | $0.00 | $622,000.00 |
| Option Period 4 Minimum and Ceiling Totals: | $0.00 | $7,423,000.00 |
| Total Minimum and Maximum FFP CLIN 1000+X001 | $0.00 | $0.00 |
| Total Minimum and Maximum T&M CLIN X002A | $0.00 | $0.00 |
| Total Minimum and Maximum T&M CLIN X002B | $0.00 | $62,492,000.00 |
| Total Minimum and Maximum FFP CLIN X003 | $0.00 | $5,700,000.00 |
Minimum and Maximum Grand Totals: $0.00 $68,192,000.00
TOTAL EVALUATED PRICE: $68,192,000.00
SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS
ATTACHMENT L4 – PRICE EVALUATION MODEL &"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
OES Totals
OES NOT TO EXCEED (NTE) TOTALS
| CLINS X001 A-D | ||
| Fixed Price NTE | CLINS X002 A&B | |
| Time and Material NTE | CLINs X003 |
Fixed Price NTE Fabricated Racks, Mod Kits, Site Kits, and Rack Subassemblies CLINs X002A Technical Support Labor X002B Technical Support
| Direct Charges* | Technical Support | |||||
| Major Projects* | Grand Totals | |||||
| Year 1 (Base Period) | $0.00 | $0.00 | ||||
| Year 2 (Base Period) | $0.00 | $0.00 | ||||
| Year 3 (Base Period) | $0.00 | $0.00 | ||||
| Year 4 (Base Period) | $0.00 | $0.00 | ||||
| Base Period NTE: | $0.00 | $0.00 | $23,541,000.00 | $2,146,000.00 | $25,687,000.00 | |
| Year 5 (Option 1) | $0.00 | $0.00 | ||||
| Year 6 (Option 1) | $0.00 | $0.00 | ||||
| Option Period 1 NTE: | $0.00 | $0.00 | $12,536,000.00 | $1,138,000.00 | $13,674,000.00 | |
| Year 7 (Option 2) | $0.00 | $0.00 | ||||
| Year 8 (Option 2) | $0.00 | $0.00 | ||||
| Option Period 2 NTE: | $0.00 | $0.00 | $12,946,000.00 | $1,184,000.00 | $14,130,000.00 | |
| Year 9 (Option 3) | $0.00 | $0.00 | ||||
| Option Period 3 NTE: | $0.00 | $0.00 | $6,668,000.00 | $610,000.00 | $7,278,000.00 | |
| Year 10 (Option 4) | $0.00 | $0.00 | ||||
| Option Period 4 NTE: | $0.00 | $0.00 | $6,801,000.00 | $622,000.00 | $7,423,000.00 | |
| NTE Totals: | $0.00 | $0.00 | $62,492,000.00 | $5,700,000.00 | $68,192,000.00 |
* NTE totals for T&M CLINs X002B and FFP CLINs X003 have been set by the FAA for the Base and the four (4) Options Periods by period and NOT by year.
OES MINIMUM (MIN) TOTALS
| CLINS X001 A-D | ||
| Fixed Price MIN | CLINS X002 A&B | |
| Time and Material MIN | CLINs X003 |
Fixed Price MIN Fabricated Racks, Mod Kits, Site Kits, and Rack Subassemblies CLINs X002A Technical Support Labor Total CLINs X002B Technical Support
| Direct Charges | Technical Support | |||||
| Major Projects | Grand Totals | |||||
| Base Period MIN: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Period 1 MIN: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Period 2 MIN: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Period 3 MIN: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Period 4 MIN: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| MIN Totals: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS
ATTACHMENT L4 – PRICE EVALUATION MODEL &"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
FFP Prices & Quantities
CLINS 1000 AND X001A-D QUANTITIES AND FIRM FIXED PRICE (FFP) PRICES
| CLINs 1000 and X001A-D Maximum Quantities | ||||||||||||
| CLIN | Type | Description | Year 1 Maximum | Year 2 Maximum | Year 3 Maximum | Year 4 Maximum | Year 5 Maximum | Year 6 Maximum | Year 7 Maximum | Year 8 Maximum | Year 9 Maximum | Year 10 Maximum |
| 1000 | FFP | Fabricated Racks for FAE | 4 | |||||||||
| X001A | FFP | Fabricated Racks | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 |
| X001B | FFP | Mod Kits | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| X001C | FFP | Site Kits | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 |
| X001D | FFP | Rack Subassemblies | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| CLINs 1000 and X001A-D Minimum Quantities | ||||||||||||
| CLIN | Type | Description | Year 1 Minimum | Year 2 Minimum | Year 3 Minimum | Year 4 Minimum | Year 5 Minimum | Year 6 Minimum | Year 7 Minimum | Year 8 Minimum | Year 9 Minimum | Year 10 Minimum |
| 1000 | FFP | Fabricated Racks for FAE | 4 | |||||||||
| X001A | FFP | Fabricated Racks | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 |
| X001B | FFP | Mod Kits | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X001C | FFP | Site Kits | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 |
| X001D | FFP | Rack Subassemblies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CLINs 1000 and X001A-D Firm Fixed Prices | ||||||||||||
| CLIN | Type | Description | Year 1 FFP | Year 2 FFP | Year 3 FFP | Year 4 FFP | Year 5 FFP | Year 6 FFP | Year 7 FFP | Year 8 FFP | Year 9 FFP | Year 10 FFP |
| 1000 | FFP | Fabricated Racks for FAE | ||||||||||
| X001A | FFP | Fabricated Racks | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| X001B | FFP | Mod Kits | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| X001C | FFP | Site Kits | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| X001D | FFP | Rack Subassemblies | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Annual Escalation % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
| Year 1 FFP Build Up | |||||||||
| Fabricated Racks: | Mod Kits: | ||||||||
| Cost Category | Amount | Cost | Extended | Cost Category | Amount | Cost | Extended | ||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 |
| Site Kits: | Rack Subassemblies | ||||||||
| Cost Category | Amount | Cost | Extended | Cost Category | Amount | Cost | Extended | ||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 |
SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS
ATTACHMENT L4 – PRICE EVALUATION MODEL &"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
Labor Hourly Rate Schedule
LABOR HOURLY RATE SCHEDULE
| CLIN | Type | Description | Year 1 Hourly Rate | Year 2 Hourly Rate | Year 3 Hourly Rate | Year 4 Hourly Rate | Year 5 Hourly Rate | Year 6 Hourly Rate | Year 7 Hourly Rate | Year 8 Hourly Rate | Year 9 Hourly Rate | Year 10 Hourly Rate |
| X002A.1 | T&M | Program Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.2 | T&M | Senior Program Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.3 | T&M | Program Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.4 | T&M | Junior Program Analyst | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.5 | T&M | Inventory/Warehouse Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.6 | T&M | Material Management Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.7 | T&M | Junior Material Management Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.8 | T&M | Rack Fabrication Production Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.9 | T&M | Senior CAD Operator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.10 | T&M | CAD Operator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.11 | T&M | Installation Support Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.12 | T&M | Lead Installation/Electronics Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.13 | T&M | Installation/Electronics Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.14 | T&M | Junior Installation/Electronics Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.15 | T&M | Lead Construction/Plants Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.16 | T&M | Construction/Plants Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.17 | T&M | Junior Construction/Plants Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.18 | T&M | Senior Electronics Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| X002A.19 | T&M | Electronics Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Annual Escalation Rates: 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS
ATTACHMENT L4 – PRICE EVALUATION MODEL &"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
CLINs X002A Calculations
| CLINS X002A NOT TO EXCEED (NTE) CALCULATIONS | ||||||||||||||
| 1920 | For the purposes of calculating the Labor NTE amounts, 1920 hours is used as a person-year. | |||||||||||||
| Base Period | ||||||||||||||
| Technical Support Services Labor | Year 1 | Year 2 | Year 3 | Year 4 | ||||||||||
| CLIN | Type | Labor Category | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended |
| X002A.1 | T&M | Program Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 |
| X002A.2 | T&M | Senior Program Analyst | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 |
| X002A.3 | T&M | Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.4 | T&M | Junior Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.5 | T&M | Inventory/Warehouse Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 |
| X002A.6 | T&M | Material Mgt Specialist | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 |
| X002A.7 | T&M | Junior Material Management Specialist | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.8 | T&M | Rack Fabrication Production Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 |
| X002A.9 | T&M | Senior CAD Operator | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 |
| X002A.10 | T&M | CAD Operator | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.11 | T&M | Installation Support Manager | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 |
| X002A.12 | T&M | Lead Installation/Electronics Technician | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 |
| X002A.13 | T&M | Installation/Electronics Technician | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 |
| X002A.14 | T&M | Junior Installation/Electronics Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.15 | T&M | Lead Construction/Plants Technician | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 |
| X002A.16 | T&M | Construction/Plants Technician | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 |
| X002A.17 | T&M | Junior Construction/Plants Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.18 | T&M | Senior Electronics Engineer | $0.00 | 19200 | $0.00 | $0.00 | 19200 | $0.00 | $0.00 | 19200 | $0.00 | $0.00 | 19200 | $0.00 |
| X002A.19 | T&M | Electronics Engineer | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| Totals | 145920 | $0.00 | 145920 | $0.00 | 145920 | $0.00 | 145920 | $0.00 | ||||||
| Minimum Totals: | $0.00 | $0.00 | $0.00 | $0.00 |
Base Period NTE: $0.00
| Option Period 1 | Option Period 2 | |||||||||||||
| Technical Support Services Labor | Year 5 | Year 6 | Year 7 | Year 8 | ||||||||||
| CLIN | Type | Labor Category | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended |
| X002A.1 | T&M | Program Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 |
| X002A.2 | T&M | Senior Program Analyst | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 |
| X002A.3 | T&M | Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.4 | T&M | Junior Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.5 | T&M | Inventory/Warehouse Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 |
| X002A.6 | T&M | Material Mgt Specialist | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 |
| X002A.7 | T&M | Junior Material Management Specialist | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.8 | T&M | Rack Fabrication Production Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 |
| X002A.9 | T&M | Senior CAD Operator | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 |
| X002A.10 | T&M | CAD Operator | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.11 | T&M | Installation Support Manager | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 |
| X002A.12 | T&M | Lead Installation/Electronics Technician | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 |
| X002A.13 | T&M | Installation/Electronics Technician | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 |
| X002A.14 | T&M | Junior Installation/Electronics Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.15 | T&M | Lead Construction/Plants Technician | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 |
| X002A.16 | T&M | Construction/Plants Technician | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 |
| X002A.17 | T&M | Junior Construction/Plants Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.18 | T&M | Senior Electronics Engineer | $0.00 | 19200 | $0.00 | $0.00 | 19200 | $0.00 | $0.00 | 19200 | $0.00 | $0.00 | 19200 | $0.00 |
| X002A.19 | T&M | Electronics Engineer | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| Totals | 145920 | $0.00 | 145920 | $0.00 | 145920 | $0.00 | 145920 | $0.00 | ||||||
| Minimum Totals: | $0.00 | $0.00 | $0.00 | $0.00 |
Option Period 1 NTE: $0.00 Option Period 2 NTE: $0.00
| Option Period 3 | Option Period 4 | Grand Total | |||||||
| Technical Support Services Labor | Year 9 | Year 10 | |||||||
| CLIN | Type | Labor Category | Rate | Hours | Extended | Rate | Hours | Extended | |
| X002A.1 | T&M | Program Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 |
| X002A.2 | T&M | Senior Program Analyst | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 |
| X002A.3 | T&M | Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.4 | T&M | Junior Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.5 | T&M | Inventory/Warehouse Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 |
| X002A.6 | T&M | Material Mgt Specialist | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | $0.00 |
| X002A.7 | T&M | Junior Material Management Specialist | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.8 | T&M | Rack Fabrication Production Manager | $0.00 | 1920 | $0.00 | $0.00 | 1920 | $0.00 | $0.00 |
| X002A.9 | T&M | Senior CAD Operator | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 |
| X002A.10 | T&M | CAD Operator | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.11 | T&M | Installation Support Manager | $0.00 | 7680 | $0.00 | $0.00 | 7680 | $0.00 | $0.00 |
| X002A.12 | T&M | Lead Installation/Electronics Technician | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 |
| X002A.13 | T&M | Installation/Electronics Technician | $0.00 | 42240 | $0.00 | $0.00 | 42240 | $0.00 | $0.00 |
| X002A.14 | T&M | Junior Installation/Electronics Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.15 | T&M | Lead Construction/Plants Technician | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 |
| X002A.16 | T&M | Construction/Plants Technician | $0.00 | 5760 | $0.00 | $0.00 | 5760 | $0.00 | $0.00 |
| X002A.17 | T&M | Junior Construction/Plants Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.18 | T&M | Senior Electronics Engineer | $0.00 | 19200 | $0.00 | $0.00 | 19200 | $0.00 | $0.00 |
| X002A.19 | T&M | Electronics Engineer | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| Totals | 145920 | $0.00 | 145920 | $0.00 | $0.00 | ||||
| Minimum Totals: | $0.00 | $0.00 |
| Option Period 3 NTE: | $0.00 | ||||
| Option Period 4 NTE: | $0.00 | CLINs X002A NTE: | $0.00 |
CLINs X002A MINIMUMS
1760 For the purposes of calculating the Labor Minimum amounts, 1760 hours is used as a person-year.
| Base Period | |||||||||||||
| Technical Support Services Labor | Year 1 | Year 2 | Year 3 | Year 4 | |||||||||
| CLIN | Labor Category | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended |
| X002A.1 | Program Manager | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.2 | Senior Program Analyst | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.3 | Program Analyst | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.4 | Junior Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.5 | Inventory/Warehouse Manager | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.6 | Material Mgt Specialist | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.7 | Junior Material Management Specialist | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.8 | Rack Fabrication Production Manager | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.9 | Senior CAD Operator | $0.00 | 5280 | $0.00 | $0.00 | 5280 | $0.00 | $0.00 | 5280 | $0.00 | $0.00 | 5280 | $0.00 |
| X002A.10 | CAD Operator | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.11 | Installation Support Manager | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 |
| X002A.12 | Lead Installation/Electronics Technician | $0.00 | 10560 | $0.00 | $0.00 | 10560 | $0.00 | $0.00 | 10560 | $0.00 | $0.00 | 10560 | $0.00 |
| X002A.13 | Installation/Electronics Technician | $0.00 | 7040 | $0.00 | $0.00 | 7040 | $0.00 | $0.00 | 7040 | $0.00 | $0.00 | 7040 | $0.00 |
| X002A.14 | Junior Installation/Electronics Technician | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 |
| X002A.15 | Lead Construction/Plants Technician | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.16 | Construction/Plants Technician | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.17 | Junior Construction/Plants Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.18 | Senior Electronics Engineer | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 |
| X002A.19 | Electronics Engineer | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| Totals | 49280 | $0.00 | 49280 | $0.00 | 49280 | $0.00 | 49280 | $0.00 |
| Option Period 1 | Option Period 2 | ||||||||||||
| Technical Support Services Labor | Year 5 | Year 6 | Year 7 | Year 8 | |||||||||
| CLIN | Labor Category | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended | Rate | Hours | Extended |
| X002A.1 | Program Manager | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.2 | Sr Program Analyst | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.3 | Program Analyst | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.4 | Jr Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.5 | Inventory/Warehouse Mgr. | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.6 | Material Mgt Specialist | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.7 | Jr Material Mgt Specialist | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.8 | Rack Fabrication Mgr. | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.9 | Sr CAD Operator | $0.00 | 5280 | $0.00 | $0.00 | 5280 | $0.00 | $0.00 | 5280 | $0.00 | $0.00 | 5280 | $0.00 |
| X002A.10 | CAD Operator | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.11 | Installation Support Manager | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 |
| X002A.12 | Lead Installation/Electronics Tech | $0.00 | 10560 | $0.00 | $0.00 | 10560 | $0.00 | $0.00 | 10560 | $0.00 | $0.00 | 10560 | $0.00 |
| X002A.13 | Installation/Electronics Tech | $0.00 | 7040 | $0.00 | $0.00 | 7040 | $0.00 | $0.00 | 7040 | $0.00 | $0.00 | 7040 | $0.00 |
| X002A.14 | Jr Installation/Electronics Tech | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 |
| X002A.15 | Lead Construction/Plants Technician | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.16 | Construction/Plants Technician | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| X002A.17 | Jr Construction/Plants Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| X002A.18 | Sr Electronics Engineer | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 |
| X002A.19 | Electronics Engineer | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 |
| Totals | 49280 | $0.00 | 49280 | $0.00 | 49280 | $0.00 | 49280 | $0.00 |
| Option Period 3 | Option Period 4 | Grand Total | ||||||
| Technical Support Services Labor | Year 9 | Year 10 | ||||||
| CLIN | Labor Category | Rate | Hours | Extended | Rate | Hours | Extended | |
| X002A.1 | Program Manager | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.2 | Sr Program Analyst | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.3 | Program Analyst | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.4 | Jr Program Analyst | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.5 | Inventory/Warehouse Mgr. | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.6 | Material Mgt Specialist | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.7 | Jr Material Mgt Specialist | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.8 | Rack Fabrication Mgr. | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.9 | Sr CAD Operator | $0.00 | 5280 | $0.00 | $0.00 | 5280 | $0.00 | $0.00 |
| X002A.10 | CAD Operator | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.11 | Installation Support Manager | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 |
| X002A.12 | Lead Installation/Electronics Tech | $0.00 | 10560 | $0.00 | $0.00 | 10560 | $0.00 | $0.00 |
| X002A.13 | Installation/Electronics Tech | $0.00 | 7040 | $0.00 | $0.00 | 7040 | $0.00 | $0.00 |
| X002A.14 | Jr Installation/Electronics Tech | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 |
| X002A.15 | Lead Construction/Plants Technician | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.16 | Construction/Plants Technician | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| X002A.17 | Jr Construction/Plants Technician | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
| X002A.18 | Sr Electronics Engineer | $0.00 | 3520 | $0.00 | $0.00 | 3520 | $0.00 | $0.00 |
| X002A.19 | Electronics Engineer | $0.00 | 1760 | $0.00 | $0.00 | 1760 | $0.00 | $0.00 |
| Totals | 49280 | $0.00 | 49280 | $0.00 | $0.00 |
| Base Period MIN: | $0.00 | ||
| Option Period 1 MIN: | $0.00 | ||
| Option Period 2 MIN: | $0.00 | ||
| Option Period 3 MIN: | $0.00 | ||
| Option Period 4 MIN: | $0.00 | CLINs X002A MIN: | $0.00 |
SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS
ATTACHMENT L4 – PRICE EVALUATION MODEL &"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
Labor Person-Years by sub-CLIN
ESTIMATED LEVEL OF EFFORT (LOE) BY CLIN
| Sub-CLIN | Type | Labor Category | LOE for Minimum Calculations | LOE for Maximum Calculations | |
| Labor T&M Sub-CLINs - Estimated Ontario LOE | |||||
| Contract Management (SOW C.4) | |||||
| X002A.1 | T&M | Program Manager | 1 | 1 | |
| Program Analyst | |||||
| X002A.2 | T&M | Senior | 1 | 3 | |
| X002A.3 | T&M | Mid | 1 | 0 | |
| X002A.4 | T&M | Junior | 0 | 0 | |
| Property Management, Warehouse, and Acquisition Support (SOW C.5) | |||||
| X002A.5 | T&M | Inventory/Warehouse Manager | 1 | 1 | |
| Material Management Specialist | |||||
| X002A.6 | T&M | Mid | 1 | 2 | |
| X002A.7 | T&M | Junior | 0 | 0 | |
| Rack Fabrication Management and Support (SOW C.6.2) | |||||
| X002A.8 | T&M | Rack Fabrication Production Manager | 1 | 1 | |
| CAD Operator | |||||
| X002A.9 | T&M | Senior | 1 | 1 | |
| X002A.10 | T&M | Mid | 0 | 0 | |
| Installation Floating Crew Management (SOW C.7.2.1) | |||||
| NEXCOM Installation Support Manager | |||||
| X002A.11 | T&M | Installation Support Manager | 1 | 3 | |
| ACLS Installation Support Manager | |||||
| X002A.11 | T&M | Installation Support Manager | 1 | 1 | |
| Labor T&M Sub-CLINs - Estimated Floating Crews LOE | |||||
| Construction/Installation Floating Crew Support (SOW C.7.1) | |||||
| NEXCOM Installation Crews | |||||
| X002A.12 | T&M | Lead Installation/Electronics Technician | 4 | 20 | |
| Construction/Installation/Electronics Technician | |||||
| X002A.13 | T&M | Mid | 2 | 20 | |
| X002A.14 | T&M | Junior | 2 | ||
| X002A.15 | T&M | Lead Construction/Plants Technician | 1 | 3 | |
| Construction/Plants Technician | |||||
| X002A.16 | T&M | Mid | 1 | 3 | |
| X002A.17 | T&M | Junior | 0 | 0 | |
| ACLS Installation Crews | |||||
| X002A.12 | T&M | Lead Installation/Electronics Technician | 2 | 2 | |
| Construction/Installation/Electronics Technician | |||||
| X002A.13 | T&M | Mid | 2 | 2 | |
| X002A.14 | T&M | Junior | 0 | 0 | |
| Labor T&M Sub-CLINs - Estimated Floating Crew Support LOE | |||||
| Installation Floating Crew Engineering Support (SOW 7.2.2) | |||||
| NEXCOM Installation Engineering Support | |||||
| Electronics Engineer | |||||
| X002A.18 | T&M | Senior | 1 | 9 | |
| X002A.19 | T&M | Mid | 1 | 0 | |
| CAD Operator | |||||
| X002A.9 | T&M | Senior | 1 | 1 | |
| X002A.10 | T&M | Mid | 0 | 0 | |
| ACLS Installation Engineering Support | |||||
| Electronics Engineer | |||||
| X002A.18 | T&M | Senior | 1 | 1 | |
| X002A.19 | T&M | Mid | 0 | 0 | |
| CAD Operator | |||||
| X002A.9 | T&M | Senior | 1 | 2 | |
| X002A.10 | T&M | Mid | 0 | 0 |
Total Annual Estimated LOE: 28 76
SECTION L – INSTRUCTIONS, CONDITIONS, AND NOTICES TO OFFERORS
ATTACHMENT L4 – PRICE EVALUATION MODEL &"Arial,Bold"&12 693KA8-23-R-00004
L4-&P
BOE Data
| Table 1A1:S197. Global IHS 2020 Q1 Escalation Rate Forecast | Table 2. NEXCOM Phase 2 Program Construction/Installation Yearly Site Goals/Rack Quantities | |||||||||||||||||
| 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | Fiscal Year | FY22 | FY23 | FY24 | FY25 | FY26 | FY27 | ||
| Regional Wages | OES Contract Period | Base Period | Option 1 | |||||||||||||||
| Wages and Salaries, Northeast | 3.1% | 3.1% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 2.9% | 2.9% | OES Contract Year | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | ||
| Wages and Salaries, Midwest | 3.1% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 2.9% | 2.9% | 2.9% | Number of NEXCOM Sites | 94 | 86 | 64 | 56 | 32 | 0 | ||
| Wages and Salaries, South | 3.1% | 3.1% | 3.1% | 3.0% | 3.1% | 3.0% | 3.0% | 3.0% | 3.0% | Racks needed (#sites X 2) | 188 | 172 | 128 | 112 | 64 | 0 | ||
| Wages and Salaries, West | 3.4% | 3.2% | 3.2% | 3.1% | 3.1% | 3.0% | 3.0% | 3.0% | 3.0% | Minimum Quantities | 100 | 100 | 50 | 50 | 0 | 0 | ||
| Average: | 3.0% | Maximum Quantities | 300 | 300 | 200 | 200 | 125 | 125 | ||||||||||
| Table 3. Minimum and Maximum Quantities for Firm Fixed Price CLINs | ||||||||||||||||||
| Item | CLIN | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | ||||||||||||
| Years 1 & 2 | Years 3 & 4 | Years 5 & 6 | Years 7 & 8 | Year 9 | Year 10 | |||||||||||||
| Min | Max | Min | Max | Min | Max | Min | Max | Min | Max | Min | Max | |||||||
| Fabricated Racks | X001A | 100 | 300 | 50 | 200 | 0 | 125 | 0 | 125 | 0 | 125 | 0 | 125 | |||||
| Mod Kits | X001C | 20 | 100 | 20 | 100 | 0 | 125 | 0 | 125 | 0 | 125 | 0 | 125 | |||||
| Site Kits | X001B | 50 | 200 | 50 | 200 | 0 | 150 | 0 | 150 | 0 | 150 | 0 | 150 | |||||
| Other FFP CLINS | All Years | |||||||||||||||||
| Min | Max | Table 5. Estimated Prices for Firm Fixed Price CLINs 1000 and X001A-X001D | ||||||||||||||||
| All Rack Subassemblies | X001D | 0 | 100 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |||||
| FAE Rack | CLIN 1000 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | ||||||||
| Table 4. Estimated Prices for Year 1 Rack Subassemblies | ERROR:#REF! | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | ||||||||
| FFP ESTIMATED AMOUNTS FOR OES RACK SUBASSEMBLIES | Fabricated Rack | CLIN 1001A | CLIN 2001A | CLIN 3001A | CLIN 4001A | CLIN 5001A | CLIN 6001A | CLIN 7001A | CLIN 8001A | CLIN 9001A | CLIN 10001A | |||||||
| Subassembly Name | Estimated Hours | Total Hours | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| Assembly | Shipping Preparation | Mod Kit | CLIN 1001B | CLIN 2001B | CLIN 3001B | CLIN 4001B | CLIN 5001B | CLIN 6001B | CLIN 7001B | CLIN 8001B | CLIN 9001B | CLIN 10001B | ||||||
| 4 RF 25" V2 Roof Panel Assembly | 1 | 1 | 2.0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| V2 20 Block Din Rail Plate Assembly | 0.5 | 1 | 1.5 | Site Kit | CLIN 1001C | CLIN 2001C | CLIN 3001C | CLIN 4001C | CLIN 5001C | CLIN 6001C | CLIN 7001C | CLIN 8001C | CLIN 9001C | CLIN 10001C | ||||
| V2 4 RF Body Panel Assembly | 0.5 | 1 | 1.5 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| V2 2 RF Body | 0.5 | 1 | 1.5 | Rack Sub Assembly | CLIN 1001D | CLIN 2001D | CLIN 3001D | CLIN 4001D | CLIN 5001D | CLIN 6001D | CLIN 7001D | CLIN 8001D | CLIN 9001D | CLIN 10001D | ||||
| V2 1 RF Body | 0.5 | 1 | 1.5 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| Computer Pullout Tray Assembly | 0.5 | 1 | 1.5 | |||||||||||||||
| V2 16 Block Din Rail Panel Assembly | 0.5 | 1 | 1.5 | |||||||||||||||
| V2 36 Block Din Rail Panel Assembly | 0.5 | 1 | 1.5 | |||||||||||||||
| V2 Fan Kit | 0.3 | 1 | 1.3 | |||||||||||||||
| DataTray-137-2361-4RTR-V2-8D | 3 | 1.5 | 4.5 | |||||||||||||||
| Average Number of Hours: | 1.9 | |||||||||||||||||
| Year 1 Lead Installation/Electronics Hourly Rate: | $0.00 | |||||||||||||||||
| Year 1 Estimated Price: | $0.00 | |||||||||||||||||
| Table 6. Yearly Breakdown of CLINs X00A Estimated NTE Amount ($K) | ||||||||||||||||||
| CLIN | Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total | ||||||
| 1000 | FAE Racks | ERROR:#REF! | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | ERROR:#REF! | ||||||
| X001A.1 | Fabricated Racks | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| X001A.2 | Mod Kits | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| X001A.3 | Site Kits | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| X001A.4 | Rack Subassemblies | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| Totals: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| BOE tables 7 through 10 are information on the process of estimating labor rates and are not included in this file. |
| Table 11 is a separate tab in this file. |
| Table 12. Estimated Level of Effort by Labor Category and CLIN | |||||||
| CLIN | Labor Category | Level of Effort | |||||
| Base Period | Opt.1 | Opt. 2 | Opt. 3 | Opt. 4 | |||
| Years 1&2 | Years #&4 | Years 5&6 | Years 7&8 | Year 9 | Year 10 | ||
| T&M CLINs - Ontario Level of Effort (LOE) | |||||||
| Contract Management | |||||||
| X002A.1 | Program Manager | 1 | 1 | 1 | 1 | 1 | 1 |
| Program Analyst | 2 | 2 | 2 | 2 | 2 | 2 | |
| X002A.2 | Senior Level | ||||||
| X002A.3 | Mid Level | ||||||
| X002A.4 | Junior Level | ||||||
| Property Management, Warehouse, and Acquisition Support | |||||||
| X002A.5 | Inventory/Warehouse Manager | 1 | 1 | 1 | 1 | 1 | 1 |
| Material Management Specialist | 2 | 2 | 2 | 2 | 2 | 2 | |
| X002A.6 | Mid Level | ||||||
| X002A.7 | Junior Level | ||||||
| Rack Fabrication Management and Support | |||||||
| X002A.8 | Rack Fabrication Production Manager | 1 | 1 | 1 | 1 | 1 | 1 |
| CAD Operator | 1 | 1 | 1 | 1 | 1 | 1 | |
| X002A.9 | Senior Level | ||||||
| X002A.10 | Mid Level | ||||||
| Installation Management and Support | |||||||
| X00A.11 | Installation Support Manager | 2 | 2 | 2 | 2 | 2 | 2 |
| CAD Operator | 2 | 2 | 2 | 2 | 2 | 2 | |
| X002A.9 | Senior Level | ||||||
| X002A.10 | Mid Level | ||||||
| EVM Support for FAA Engineering Services | |||||||
| Program Analyst | 1 | 1 | 1 | 1 | 1 | 1 | |
| X002A.2 | Senior Level | ||||||
| X002A.3 | Mid Level | ||||||
| X002A.4 | Junior Level | ||||||
| T&M CLINs - Floating Crew Support | |||||||
| Installation Floating Crews | |||||||
| X002A.12 | Lead Installation/Electronics Technician | 12 | 10 | 8 | 8 | 8 | 8 |
| Installation/Electronics Technician | 12 | 10 | 8 | 8 | 8 | 8 | |
| X002A.13 | Mid Level | ||||||
| X002A.14 | Junior Level | ||||||
| X002A.15 | Lead Construction/Plants Technician | 2 | 2 | 1 | 1 | 1 | 1 |
| Construction/Plants Technician | 2 | 2 | 1 | 1 | 1 | 1 | |
| X002A.16 | Mid Level | ||||||
| X002A.17 | Junior Level | ||||||
| Installation Engineering Support | |||||||
| Electronics Engineer | 2 | 2 | 2 | 2 | 2 | 2 | |
| X002A.18 | Senior Level | ||||||
| X002A.19 | Mid Level |
| Table 13.Yearly Breakdown of CLINs X002A Estimated NTE Amount ($K) | ||||||||||||
| CLIN | Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total |
| X002A.1 | Program Manager | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.2 | Senior Program Analyst | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.3 | Program Analyst | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.4 | Junior Program Analyst | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.5 | Inventory/ Warehouse Manager | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.6 | Material Management Specialist | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.7 | Junior Material Management Specialist | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.8 | Rack Fabrication Production Manager | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.9 | Senior CAD Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.10 | CAD Operator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.11 | Installation Support Manager | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.12 | Lead Installation/ Electronics Technician | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.13 | Installation/ Electronics Technician | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.14 | Junior Installation/ Electronics Technician | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.15 | Lead Construction/ Plants Technician | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.16 | Construction/ Plants Technician | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.17 | Junior Construction/ Plants Technician | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.18 | Senior Electronics Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| X002A.19 | Electronics Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Totals: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Table 14. Other Costs Analysis and Results for Contract Management | Table 15 Other Costs Analysis and Results for EVM Support for FAA Engineering Services | ||||||||
| Analysis of DTFAWA-09-D-00062 for Contract Management | Analysis of DTFAWA-09-D-00062 for | ||||||||
| Description | Other Costs (DC) w/ Indirect Cost Added | EVM support for FAA Engineering Services | |||||||
| Travel | Material/CAP | ODC | Total DC | Description | Other Costs (DC) w/ Indirect Cost Added | ||||
| Year 8 Totals: | $25,868.36 | $2,071.19 | $1,463.37 | $29,402.92 | Travel | Material/CAP | ODC | Total DC | |
| Year 9 Totals: | $68,255.23 | $242.87 | $1,321.49 | $69,819.59 | Year 8 Totals: | $6,841.58 | $0.00 | $1,667.67 | $8,509.24 |
| Year 10 Totals: | $61,426.57 | $0.00 | $1,006.57 | $62,433.14 | Year 9 Totals: | $10,951.51 | $0.00 | $1,078.93 | $12,030.44 |
| *Year 11 Totals: | $71,801.22 | $0.00 | $1,766.25 | $73,567.47 | Year 10 Totals: | $8,143.62 | $0.00 | $4,443.32 | $12,586.94 |
| Max Amount (Years 8-11): | $71,801.22 | $2,071.19 | $1,766.25 | $73,567.47 | *Year 11 Totals: | $8,512.94 | $0.00 | $1,845.01 | $10,357.95 |
| Average Amount (Years 8-11): | $56,837.85 | $578.52 | $1,389.42 | $58,805.78 | Max Amount (Years 8-11): | $10,951.51 | $0.00 | $4,443.32 | $12,586.94 |
| Amounts Used in IGCE: | $30,000.00 | $2,000.00 | $2,000.00 | $34,000.00 | Average Amount (Years 8-11): | $8,612.41 | $0.00 | $2,258.73 | $10,871.14 |
| Amounts for IGCE: | $10,000.00 | $0.00 | $2,000.00 | $12,000.00 |
| Table 16. Other Costs Analysis and Results for Rack and Mod Kit Assembly | Table 18. Other Costs Analysis and Results for Construction/Installation Floating Crews | ||||||||||||
| Analysis of DTFAWA-09-D-00062 for Rack Fabrication | Analysis of DTFAWA-09-D-00062 for Floating Crew Tasks | ||||||||||||
| Description | Actual Other Costs (DC) w/ Indirect Cost Added | Racks per Year | Description | Actual Other Costs (DC) w/ Indirect Cost Added | Crews per Year | ||||||||
| Travel | Material/CAP | ODC | Total DC | Shipping | Travel | Material/CAP | ODC | Total DC | Freight | ||||
| Year 8 Totals: | $11,627.85 | $66,655.60 | $10,399.30 | $88,682.75 | $40,201.01 | 300 | Year 8 Totals: | $1,403,335.99 | $343,103.99 | $61,144.09 | $1,807,584.07 | $114,932.19 | 10 |
| Year 9 Totals: | $11,222.05 | $9,909.82 | $2,729.36 | $23,861.23 | $47,831.98 | 200 | Year 9 Totals: | $2,092,349.96 | $476,427.77 | $84,352.18 | $2,653,129.92 | $220,795.95 | 14 |
| Year 10 Totals: | $2,520.95 | $13,275.47 | $4,287.61 | $20,084.03 | $38,998.60 | 200 | Year 10 Totals: | $1,791,086.37 | $204,735.41 | $12,834.26 | $2,008,656.05 | $191,044.80 | 14 |
| *Year 11 Totals: | $17,958.69 | $0.00 | $7,052.01 | $25,010.70 | $35,333.98 | 120 | *Year 11 Totals: | $1,848,583.09 | $262,174.00 | $74,748.78 | $2,185,505.87 | $204,724.80 | 14 |
| Max Amount (Years 8-11): | $17,958.69 | $66,655.60 | $10,399.30 | $88,682.75 | $47,831.98 | Max Amount (Years 8-11): | $2,092,349.96 | $476,427.77 | $84,352.18 | $2,653,129.92 | $220,795.95 | ||
| Average Amount (Years 8-11): | $10,832.38 | $22,460.22 | $6,117.07 | $39,409.68 | $40,591.39 | Average Amount (Years 8-11): | $1,783,838.85 | $321,610.29 | $58,269.83 | $2,163,718.98 | $182,874.44 | ||
| Calculation of Direct Chargers per Rack | Calculation of Direct Chargers per Rack | ||||||||||||
| Year 8 Totals: | $222.19 | $34.66 | $256.85 | $134.00 | Year 8 Totals: | $140,333.60 | $34,310.40 | $6,114.41 | $180,758.41 | $383.11 | |||
| Year 9 Totals: | $49.55 | $13.65 | $63.20 | $239.16 | Year 9 Totals: | $149,453.57 | $34,030.56 | $6,025.16 | $189,509.28 | $1,103.98 | |||
| Year 10 Totals: | $66.38 | $21.44 | $87.82 | $194.99 | Year 10 Totals: | $127,934.74 | $14,623.96 | $916.73 | $143,475.43 | $955.22 | |||
| *Year 11 Totals: | $0.00 | $58.77 | $58.77 | $294.45 | *Year 11 Totals: | $132,041.65 | $18,726.71 | $5,339.20 | $156,107.56 | $1,706.04 | |||
| Max Amount (Years 8-11): | $222.19 | $58.77 | $256.85 | $294.45 | Max Amount (Years 8-11): | $149,453.57 | $34,310.40 | $6,114.41 | $189,509.28 | $1,706.04 | |||
| Average Amount (Years 8-11): | $84.53 | $32.13 | $116.66 | $215.65 | Average Amount (Years 8-11): | $137,440.89 | $25,422.91 | $4,598.87 | $167,462.67 | $1,037.09 | |||
| Amounts for IGCE: | $15,000.00 | $110.00 | $35.00 | $250.00 | Per Rack & Mod Kit | Amounts for IGCE: | $150,000.00 | $25,000.00 | $6,000.00 | $181,000.00 | $16,000.00 | Per Crew |
| Table 17. Rack Fabrication and Support Annual Estimated Other Costs Costs | |||||||||||||
| Category | Amt. per Rack | Years 1&2 | Years 3&4 | Years 5&6 | Years 7&8 | Year 9 | Year 10 | ||||||
| Number of FAE Racks: | 4 | N/A | N/A | N/A | N/A | N/A | |||||||
| Max Number of Racks: | 300 | 200 | 125 | 125 | 125 | 125 | |||||||
| Max Number of Mod Kits: | 100 | 100 | 125 | 125 | 125 | 125 | |||||||
| Material | $110.00 | $44,440 | $33,000 | $27,500 | $27,500 | $27,500 | $27,500 | ||||||
| ODC | $35.00 | $14,140 | $10,500 | $8,750 | $8,750 | $8,750 | $8,750 | ||||||
| Shipping | $250 | $100,000 | $75,000 | $62,500 | $62,500 | $62,500 | $62,500 | ||||||
| Total Other Costs: | $158,580 | $75,000 | $62,500 | $62,500 | $62,500 | $62,500 | |||||||
| Table 19. Construction/Installation Floating Crews Annual Estimated Other Costs | |||||||||||||
| Category | Amt. per Crew | Years 1&2 | Years 3&4 | Years 5&6 | Years 7&8 | Year 9 | Year 10 | ||||||
| Number of Crews: | 14 | 12 | 9 | 9 | 9 | 9 | |||||||
| Other Costs | Table 20. Major Projects Other Costs Percentages and Allocation | ||||||||||||
| Travel | $150,000 | $2,100,000 | $1,800,000 | $1,350,000 | $1,350,000 | $1,350,000 | $1,350,000 | Category | Lubbock | Orlando | Average | %age | Annual Allocation |
| Material | $15,000 | $210,000 | $180,000 | $135,000 | $135,000 | $135,000 | $135,000 | Travel | $98,474.00 | $120,527.00 | $109,500.50 | 11% | $55,000 |
| CAP | $10,000 | $140,000 | $120,000 | $90,000 | $90,000 | $90,000 | $90,000 | Material/CAP | $266,895.00 | $80,072.00 | $173,483.50 | 17% | $85,000 |
| ODC | $6,000 | $84,000 | $72,000 | $54,000 | $54,000 | $54,000 | $54,000 | ODC | $10,276.00 | $22,837.00 | $16,556.50 | 2% | $10,000 |
| Freight (Truck Leases) | $16,000 | $224,000 | $192,000 | $144,000 | $144,000 | $144,000 | $144,000 | Subcontract | $848,514.00 | $574,566.00 | $711,540.00 | 70% | $350,000 |
| Total Other Costs: | $2,758,000 | $2,364,000 | $1,773,000 | $1,773,000 | $1,773,000 | $1,773,000 | Totals: | $1,224,159.00 | $798,002.00 | $1,011,080.50 | 100% | $500,000.00 |
| Table 21. Yearly Breakdown of CLINs X002B Estimated NTE Amount ($K) | ||||||||||||
| CLIN | Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total |
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 .