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
Issued by
Department of Transportation Federal Aviation Administration Headquarters

View the file

Other files for this federal contract opportunity

Other files attached to Screening Information Request (SIR) for Ontario Engineering Services (OES), newest first.
File Type Posted
OES SIR Sect L_Amend 0002.pdf PDF
693KA8-23-R-00004 OES SIR QA Responses.pdf PDF
693KA8-23-R-00004_Amend 0002.pdf PDF
OES SIR L Att L4_Amend 0002.xlsx XLSX spreadsheet
OES SIR L Att L3_Amend 0002.docx DOCX document
OES SIR Sect C_Amend 0002.pdf PDF
OES SIR L Att L2_Amend 0002.docx DOCX document
693KA8-23-R-00004_Amend_0001.pdf PDF
OES SIR Sect I_Amend 1.pdf PDF
OES SIR Sect F.pdf PDF
OES SIR Sect G.pdf PDF
OES SIR Sect J.pdf PDF
OES SIR J2 Append A011.pdf PDF
OES SIR J Att J7.pdf PDF
OES SIR J Att J8.pdf PDF
OES SIR L Att L1.pdf PDF
OES SIR Sect B.pdf PDF
OES SIR Sect D.pdf PDF
OES SIR Sect H.pdf PDF
OES SIR J1 Append J1.3-1.zip ZIP file
OES SIR J Att J2.pdf PDF
OES SIR J2 Append A018.pdf PDF
OES SIR J Att J3.pdf PDF
OES SIR Sect K.pdf PDF
OES SIR L Att L2.docx DOCX document
OES SIR Sect M.pdf PDF
693KA8-23-R-00004.pdf PDF
OES SIR J Att J1.pdf PDF
OES SIR J1 Append J1.3-2.zip ZIP file
OES SIR J1 Append J1.3-3.zip ZIP file
OES SIR L Att L3.docx DOCX document
OES SIR Sect C.pdf PDF
OES SIR Sect E.pdf PDF
OES SIR Sect I.pdf PDF
OES SIR J Att J4.pdf PDF
OES SIR J Att J5.pdf PDF
OES SIR J Att J6.pdf PDF
OES SIR J Att J9 (Sample).pdf PDF
OES SIR Sect L.pdf PDF
OES SIR L Att L5.xlsx XLSX spreadsheet
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.

nYear 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)

CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 1Min Units - Year 1Max Units - Year 1MinimumExtended Ceiling
1000FFPFabricated Racks for FAEC.6.1.2, J1Each$0.0044$0.00$0.00
1001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
1001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
1001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
1001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 1001 Totals:$0.00$0.00
1002AT&MTechnical Support Services - LaborC.4 - C.7, J5N/AN/AN/ANTE$0.00$0.00
1002BT&MTechnical Support Services - Direct ChargesC.4 - C.7, H9N/AN/AN/ANTE$0.00
CLIN 1002 Totals:$0.00$0.00
1003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$0.00
Total:$0.00$0.00
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 2Min Units - Year 2Max Units - Year 2MinimumExtended Ceiling
2001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
2001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
2001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
2001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 2001 Totals:$0.00$0.00
2002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
2002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 2002 Totals:$0.00$0.00
2003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$0.00
Total:$0.00$0.00
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 3Min Units - Year 3Max Units - Year 3MinimumExtended Ceiling
3001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
3001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
3001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
3001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 3001 Totals:$0.00$0.00
3002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
3002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 3002 Totals:$0.00$0.00
3003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$0.00
Total:$0.00$0.00
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 4Min Units - Year 4Max Units - Year 4MinimumExtended Ceiling
4001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
4001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
4001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
4001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 4001 Totals:$0.00$0.00
4002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
4002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 4002 Totals:$0.00$0.00
4003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$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
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 5Min Units - Year 5Max Units - Year 5MinimumExtended Ceiling
5001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
5001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
5001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
5001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 5001 Totals:$0.00$0.00
5002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
5002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 5002 Totals:$0.00$0.00
5003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$0.00
Total:$0.00$0.00
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 6Min Units - Year 6Max Units - Year 6MinimumExtended Ceiling
6001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
6001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
6001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
6001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 6001 Totals:$0.00$0.00
6002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
6002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 6002 Totals:$0.00$0.00
6003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$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
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 7Min Units - Year 7Max Units - Year 7MinimumExtended Ceiling
7001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
7001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
7001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
7001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 7001 Totals:$0.00$0.00
7002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
7002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 7002 Totals:$0.00$0.00
7003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$0.00
Total:$0.00$0.00
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 8Min Units - Year 8Max Units - Year 8MinimumExtended Ceiling
8001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
8001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
8001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
8001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 8001 Totals:$0.00$0.00
8002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
8002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 8002 Totals:$0.00$0.00
8003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$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
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 9Min Units - Year 9Max Units - Year 9MinimumExtended Ceiling
9001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
9001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
9001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
9001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 9001 Totals:$0.00$0.00
9002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
9002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 9002 Totals:$0.00$0.00
9003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$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
CLINTypeDescriptionSOW ReferenceUnit of MeasureUnit Price - Year 10Min Units - Year 10Max Units - Year 10MinimumExtended Ceiling
10001AFFPFabricated RacksC.6.1.2, J1Each$0.0035300$0.00$0.00
10001BFFPMod KitsC.6.1.2, J1Each$0.000100$0.00$0.00
10001CFFPSite KitsC.6.1.2, J4Each$0.0030175$0.00$0.00
10001DFFPRack SubassembliesC.6.1.2, J1Each$0.000100$0.00$0.00
CLIN 9001 Totals:$0.00$0.00
10002AT&M or FFPTechnical Support Services - LaborC.6.4 - C.6.7, J5N/AN/AN/ANTE$0.00$0.00
10002BT&M or FFPTechnical Support Services - Direct ChargesC.6.4 - C.6.7, H9N/AN/AN/ANTE$0.00
CLIN 9002 Totals:$0.00$0.00
10003FFPTechnical Support Services - AGVC and Other FAA ProjectsC.4 - C.7N/AN/AN/ANTE$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 NTECLINS X002 A&B
Time and Material NTECLINs 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 MINCLINS X002 A&B
Time and Material MINCLINs X003

Fixed Price MIN Fabricated Racks, Mod Kits, Site Kits, and Rack Subassemblies CLINs X002A Technical Support Labor Total CLINs X002B Technical Support

Direct ChargesTechnical Support
Major ProjectsGrand 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
CLINTypeDescriptionYear 1 MaximumYear 2 MaximumYear 3 MaximumYear 4 MaximumYear 5 MaximumYear 6 MaximumYear 7 MaximumYear 8 MaximumYear 9 MaximumYear 10 Maximum
1000FFPFabricated Racks for FAE4
X001AFFPFabricated Racks300300300300300300300300300300
X001BFFPMod Kits100100100100100100100100100100
X001CFFPSite Kits175175175175175175175175175175
X001DFFPRack Subassemblies100100100100100100100100100100
CLINs 1000 and X001A-D Minimum Quantities
CLINTypeDescriptionYear 1 MinimumYear 2 MinimumYear 3 MinimumYear 4 MinimumYear 5 MinimumYear 6 MinimumYear 7 MinimumYear 8 MinimumYear 9 MinimumYear 10 Minimum
1000FFPFabricated Racks for FAE4
X001AFFPFabricated Racks35353535353535353535
X001BFFPMod Kits0000000000
X001CFFPSite Kits30303030303030303030
X001DFFPRack Subassemblies0000000000
CLINs 1000 and X001A-D Firm Fixed Prices
CLINTypeDescriptionYear 1 FFPYear 2 FFPYear 3 FFPYear 4 FFPYear 5 FFPYear 6 FFPYear 7 FFPYear 8 FFPYear 9 FFPYear 10 FFP
1000FFPFabricated Racks for FAE
X001AFFPFabricated Racks$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X001BFFPMod Kits$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X001CFFPSite Kits$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X001DFFPRack 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 CategoryAmountCostExtendedCost CategoryAmountCostExtended
$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 CategoryAmountCostExtendedCost CategoryAmountCostExtended
$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

CLINTypeDescriptionYear 1 Hourly RateYear 2 Hourly RateYear 3 Hourly RateYear 4 Hourly RateYear 5 Hourly RateYear 6 Hourly RateYear 7 Hourly RateYear 8 Hourly RateYear 9 Hourly RateYear 10 Hourly Rate
X002A.1T&MProgram Manager$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.2T&MSenior Program Analyst$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.3T&MProgram Analyst$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.4T&MJunior Program Analyst$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.5T&MInventory/Warehouse Manager$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.6T&MMaterial Management Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.7T&MJunior Material Management Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.8T&MRack Fabrication Production Manager$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.9T&MSenior CAD Operator$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.10T&MCAD Operator$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.11T&MInstallation Support Manager$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.12T&MLead Installation/Electronics Technician$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.13T&MInstallation/Electronics Technician$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.14T&MJunior Installation/Electronics Technician$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.15T&MLead Construction/Plants Technician$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.16T&MConstruction/Plants Technician$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.17T&MJunior Construction/Plants Technician$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.18T&MSenior Electronics Engineer$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002A.19T&MElectronics 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
1920For the purposes of calculating the Labor NTE amounts, 1920 hours is used as a person-year.
Base Period
Technical Support Services LaborYear 1Year 2Year 3Year 4
CLINTypeLabor CategoryRateHoursExtendedRateHoursExtendedRateHoursExtendedRateHoursExtended
X002A.1T&MProgram Manager$0.001920$0.00$0.001920$0.00$0.001920$0.00$0.001920$0.00
X002A.2T&MSenior Program Analyst$0.005760$0.00$0.005760$0.00$0.005760$0.00$0.005760$0.00
X002A.3T&MProgram Analyst$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.4T&MJunior Program Analyst$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.5T&MInventory/Warehouse Manager$0.001920$0.00$0.001920$0.00$0.001920$0.00$0.001920$0.00
X002A.6T&MMaterial Mgt Specialist$0.003840$0.00$0.003840$0.00$0.003840$0.00$0.003840$0.00
X002A.7T&MJunior Material Management Specialist$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.8T&MRack Fabrication Production Manager$0.001920$0.00$0.001920$0.00$0.001920$0.00$0.001920$0.00
X002A.9T&MSenior CAD Operator$0.007680$0.00$0.007680$0.00$0.007680$0.00$0.007680$0.00
X002A.10T&MCAD Operator$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.11T&MInstallation Support Manager$0.007680$0.00$0.007680$0.00$0.007680$0.00$0.007680$0.00
X002A.12T&MLead Installation/Electronics Technician$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00
X002A.13T&MInstallation/Electronics Technician$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00
X002A.14T&MJunior Installation/Electronics Technician$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.15T&MLead Construction/Plants Technician$0.005760$0.00$0.005760$0.00$0.005760$0.00$0.005760$0.00
X002A.16T&MConstruction/Plants Technician$0.005760$0.00$0.005760$0.00$0.005760$0.00$0.005760$0.00
X002A.17T&MJunior Construction/Plants Technician$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.18T&MSenior Electronics Engineer$0.0019200$0.00$0.0019200$0.00$0.0019200$0.00$0.0019200$0.00
X002A.19T&MElectronics Engineer$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
Totals145920$0.00145920$0.00145920$0.00145920$0.00
Minimum Totals:$0.00$0.00$0.00$0.00

Base Period NTE: $0.00

Option Period 1Option Period 2
Technical Support Services LaborYear 5Year 6Year 7Year 8
CLINTypeLabor CategoryRateHoursExtendedRateHoursExtendedRateHoursExtendedRateHoursExtended
X002A.1T&MProgram Manager$0.001920$0.00$0.001920$0.00$0.001920$0.00$0.001920$0.00
X002A.2T&MSenior Program Analyst$0.005760$0.00$0.005760$0.00$0.005760$0.00$0.005760$0.00
X002A.3T&MProgram Analyst$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.4T&MJunior Program Analyst$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.5T&MInventory/Warehouse Manager$0.001920$0.00$0.001920$0.00$0.001920$0.00$0.001920$0.00
X002A.6T&MMaterial Mgt Specialist$0.003840$0.00$0.003840$0.00$0.003840$0.00$0.003840$0.00
X002A.7T&MJunior Material Management Specialist$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.8T&MRack Fabrication Production Manager$0.001920$0.00$0.001920$0.00$0.001920$0.00$0.001920$0.00
X002A.9T&MSenior CAD Operator$0.007680$0.00$0.007680$0.00$0.007680$0.00$0.007680$0.00
X002A.10T&MCAD Operator$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.11T&MInstallation Support Manager$0.007680$0.00$0.007680$0.00$0.007680$0.00$0.007680$0.00
X002A.12T&MLead Installation/Electronics Technician$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00
X002A.13T&MInstallation/Electronics Technician$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00$0.0042240$0.00
X002A.14T&MJunior Installation/Electronics Technician$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.15T&MLead Construction/Plants Technician$0.005760$0.00$0.005760$0.00$0.005760$0.00$0.005760$0.00
X002A.16T&MConstruction/Plants Technician$0.005760$0.00$0.005760$0.00$0.005760$0.00$0.005760$0.00
X002A.17T&MJunior Construction/Plants Technician$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.18T&MSenior Electronics Engineer$0.0019200$0.00$0.0019200$0.00$0.0019200$0.00$0.0019200$0.00
X002A.19T&MElectronics Engineer$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
Totals145920$0.00145920$0.00145920$0.00145920$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 3Option Period 4Grand Total
Technical Support Services LaborYear 9Year 10
CLINTypeLabor CategoryRateHoursExtendedRateHoursExtended
X002A.1T&MProgram Manager$0.001920$0.00$0.001920$0.00$0.00
X002A.2T&MSenior Program Analyst$0.005760$0.00$0.005760$0.00$0.00
X002A.3T&MProgram Analyst$0.000$0.00$0.000$0.00$0.00
X002A.4T&MJunior Program Analyst$0.000$0.00$0.000$0.00$0.00
X002A.5T&MInventory/Warehouse Manager$0.001920$0.00$0.001920$0.00$0.00
X002A.6T&MMaterial Mgt Specialist$0.003840$0.00$0.003840$0.00$0.00
X002A.7T&MJunior Material Management Specialist$0.000$0.00$0.000$0.00$0.00
X002A.8T&MRack Fabrication Production Manager$0.001920$0.00$0.001920$0.00$0.00
X002A.9T&MSenior CAD Operator$0.007680$0.00$0.007680$0.00$0.00
X002A.10T&MCAD Operator$0.000$0.00$0.000$0.00$0.00
X002A.11T&MInstallation Support Manager$0.007680$0.00$0.007680$0.00$0.00
X002A.12T&MLead Installation/Electronics Technician$0.0042240$0.00$0.0042240$0.00$0.00
X002A.13T&MInstallation/Electronics Technician$0.0042240$0.00$0.0042240$0.00$0.00
X002A.14T&MJunior Installation/Electronics Technician$0.000$0.00$0.000$0.00$0.00
X002A.15T&MLead Construction/Plants Technician$0.005760$0.00$0.005760$0.00$0.00
X002A.16T&MConstruction/Plants Technician$0.005760$0.00$0.005760$0.00$0.00
X002A.17T&MJunior Construction/Plants Technician$0.000$0.00$0.000$0.00$0.00
X002A.18T&MSenior Electronics Engineer$0.0019200$0.00$0.0019200$0.00$0.00
X002A.19T&MElectronics Engineer$0.000$0.00$0.000$0.00$0.00
Totals145920$0.00145920$0.00$0.00
Minimum Totals:$0.00$0.00
Option Period 3 NTE:$0.00
Option Period 4 NTE:$0.00CLINs 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 LaborYear 1Year 2Year 3Year 4
CLINLabor CategoryRateHoursExtendedRateHoursExtendedRateHoursExtendedRateHoursExtended
X002A.1Program Manager$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.2Senior Program Analyst$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.3Program Analyst$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.4Junior Program Analyst$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.5Inventory/Warehouse Manager$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.6Material Mgt Specialist$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.7Junior Material Management Specialist$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.8Rack Fabrication Production Manager$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.9Senior CAD Operator$0.005280$0.00$0.005280$0.00$0.005280$0.00$0.005280$0.00
X002A.10CAD Operator$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.11Installation Support Manager$0.003520$0.00$0.003520$0.00$0.003520$0.00$0.003520$0.00
X002A.12Lead Installation/Electronics Technician$0.0010560$0.00$0.0010560$0.00$0.0010560$0.00$0.0010560$0.00
X002A.13Installation/Electronics Technician$0.007040$0.00$0.007040$0.00$0.007040$0.00$0.007040$0.00
X002A.14Junior Installation/Electronics Technician$0.003520$0.00$0.003520$0.00$0.003520$0.00$0.003520$0.00
X002A.15Lead Construction/Plants Technician$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.16Construction/Plants Technician$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.17Junior Construction/Plants Technician$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.18Senior Electronics Engineer$0.003520$0.00$0.003520$0.00$0.003520$0.00$0.003520$0.00
X002A.19Electronics Engineer$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
Totals49280$0.0049280$0.0049280$0.0049280$0.00
Option Period 1Option Period 2
Technical Support Services LaborYear 5Year 6Year 7Year 8
CLINLabor CategoryRateHoursExtendedRateHoursExtendedRateHoursExtendedRateHoursExtended
X002A.1Program Manager$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.2Sr Program Analyst$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.3Program Analyst$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.4Jr Program Analyst$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.5Inventory/Warehouse Mgr.$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.6Material Mgt Specialist$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.7Jr Material Mgt Specialist$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.8Rack Fabrication Mgr.$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.9Sr CAD Operator$0.005280$0.00$0.005280$0.00$0.005280$0.00$0.005280$0.00
X002A.10CAD Operator$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.11Installation Support Manager$0.003520$0.00$0.003520$0.00$0.003520$0.00$0.003520$0.00
X002A.12Lead Installation/Electronics Tech$0.0010560$0.00$0.0010560$0.00$0.0010560$0.00$0.0010560$0.00
X002A.13Installation/Electronics Tech$0.007040$0.00$0.007040$0.00$0.007040$0.00$0.007040$0.00
X002A.14Jr Installation/Electronics Tech$0.003520$0.00$0.003520$0.00$0.003520$0.00$0.003520$0.00
X002A.15Lead Construction/Plants Technician$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.16Construction/Plants Technician$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
X002A.17Jr Construction/Plants Technician$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00
X002A.18Sr Electronics Engineer$0.003520$0.00$0.003520$0.00$0.003520$0.00$0.003520$0.00
X002A.19Electronics Engineer$0.001760$0.00$0.001760$0.00$0.001760$0.00$0.001760$0.00
Totals49280$0.0049280$0.0049280$0.0049280$0.00
Option Period 3Option Period 4Grand Total
Technical Support Services LaborYear 9Year 10
CLINLabor CategoryRateHoursExtendedRateHoursExtended
X002A.1Program Manager$0.001760$0.00$0.001760$0.00$0.00
X002A.2Sr Program Analyst$0.001760$0.00$0.001760$0.00$0.00
X002A.3Program Analyst$0.001760$0.00$0.001760$0.00$0.00
X002A.4Jr Program Analyst$0.000$0.00$0.000$0.00$0.00
X002A.5Inventory/Warehouse Mgr.$0.001760$0.00$0.001760$0.00$0.00
X002A.6Material Mgt Specialist$0.001760$0.00$0.001760$0.00$0.00
X002A.7Jr Material Mgt Specialist$0.000$0.00$0.000$0.00$0.00
X002A.8Rack Fabrication Mgr.$0.001760$0.00$0.001760$0.00$0.00
X002A.9Sr CAD Operator$0.005280$0.00$0.005280$0.00$0.00
X002A.10CAD Operator$0.000$0.00$0.000$0.00$0.00
X002A.11Installation Support Manager$0.003520$0.00$0.003520$0.00$0.00
X002A.12Lead Installation/Electronics Tech$0.0010560$0.00$0.0010560$0.00$0.00
X002A.13Installation/Electronics Tech$0.007040$0.00$0.007040$0.00$0.00
X002A.14Jr Installation/Electronics Tech$0.003520$0.00$0.003520$0.00$0.00
X002A.15Lead Construction/Plants Technician$0.001760$0.00$0.001760$0.00$0.00
X002A.16Construction/Plants Technician$0.001760$0.00$0.001760$0.00$0.00
X002A.17Jr Construction/Plants Technician$0.000$0.00$0.000$0.00$0.00
X002A.18Sr Electronics Engineer$0.003520$0.00$0.003520$0.00$0.00
X002A.19Electronics Engineer$0.001760$0.00$0.001760$0.00$0.00
Totals49280$0.0049280$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.00CLINs 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-CLINTypeLabor CategoryLOE for Minimum CalculationsLOE for Maximum Calculations
Labor T&M Sub-CLINs - Estimated Ontario LOE
Contract Management (SOW C.4)
X002A.1T&MProgram Manager11
Program Analyst
X002A.2T&MSenior13
X002A.3T&MMid10
X002A.4T&MJunior00
Property Management, Warehouse, and Acquisition Support (SOW C.5)
X002A.5T&MInventory/Warehouse Manager11
Material Management Specialist
X002A.6T&MMid12
X002A.7T&MJunior00
Rack Fabrication Management and Support (SOW C.6.2)
X002A.8T&MRack Fabrication Production Manager11
CAD Operator
X002A.9T&MSenior11
X002A.10T&MMid00
Installation Floating Crew Management (SOW C.7.2.1)
NEXCOM Installation Support Manager
X002A.11T&MInstallation Support Manager13
ACLS Installation Support Manager
X002A.11T&MInstallation Support Manager11
Labor T&M Sub-CLINs - Estimated Floating Crews LOE
Construction/Installation Floating Crew Support (SOW C.7.1)
NEXCOM Installation Crews
X002A.12T&MLead Installation/Electronics Technician420
Construction/Installation/Electronics Technician
X002A.13T&MMid220
X002A.14T&MJunior2
X002A.15T&MLead Construction/Plants Technician13
Construction/Plants Technician
X002A.16T&MMid13
X002A.17T&MJunior00
ACLS Installation Crews
X002A.12T&MLead Installation/Electronics Technician22
Construction/Installation/Electronics Technician
X002A.13T&MMid22
X002A.14T&MJunior00
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.18T&MSenior19
X002A.19T&MMid10
CAD Operator
X002A.9T&MSenior11
X002A.10T&MMid00
ACLS Installation Engineering Support
Electronics Engineer
X002A.18T&MSenior11
X002A.19T&MMid00
CAD Operator
X002A.9T&MSenior12
X002A.10T&MMid00

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 ForecastTable 2. NEXCOM Phase 2 Program Construction/Installation Yearly Site Goals/Rack Quantities
2022202320242025202620272028202920302031Fiscal YearFY22FY23FY24FY25FY26FY27
Regional WagesOES Contract PeriodBase PeriodOption 1
Wages and Salaries, Northeast3.1%3.1%3.0%3.0%3.0%3.0%3.0%2.9%2.9%OES Contract YearYear 1Year 2Year 3Year 4Year 5Year 6
Wages and Salaries, Midwest3.1%3.0%3.0%3.0%3.0%3.0%2.9%2.9%2.9%Number of NEXCOM Sites94866456320
Wages and Salaries, South3.1%3.1%3.1%3.0%3.1%3.0%3.0%3.0%3.0%Racks needed (#sites X 2)188172128112640
Wages and Salaries, West3.4%3.2%3.2%3.1%3.1%3.0%3.0%3.0%3.0%Minimum Quantities100100505000
Average:3.0%Maximum Quantities300300200200125125
Table 3. Minimum and Maximum Quantities for Firm Fixed Price CLINs
ItemCLINBase PeriodOption Period 1Option Period 2Option Period 3Option Period 4
Years 1 & 2Years 3 & 4Years 5 & 6Years 7 & 8Year 9Year 10
MinMaxMinMaxMinMaxMinMaxMinMaxMinMax
Fabricated RacksX001A100300502000125012501250125
Mod KitsX001C20100201000125012501250125
Site KitsX001B50200502000150015001500150
Other FFP CLINSAll Years
MinMaxTable 5. Estimated Prices for Firm Fixed Price CLINs 1000 and X001A-X001D
All Rack SubassembliesX001D0100Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
FAE RackCLIN 1000N/AN/AN/AN/AN/AN/AN/AN/AN/A
Table 4. Estimated Prices for Year 1 Rack SubassembliesERROR:#REF!N/AN/AN/AN/AN/AN/AN/AN/AN/A
FFP ESTIMATED AMOUNTS FOR OES RACK SUBASSEMBLIESFabricated RackCLIN 1001ACLIN 2001ACLIN 3001ACLIN 4001ACLIN 5001ACLIN 6001ACLIN 7001ACLIN 8001ACLIN 9001ACLIN 10001A
Subassembly NameEstimated HoursTotal HoursERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
AssemblyShipping PreparationMod KitCLIN 1001BCLIN 2001BCLIN 3001BCLIN 4001BCLIN 5001BCLIN 6001BCLIN 7001BCLIN 8001BCLIN 9001BCLIN 10001B
4 RF 25" V2 Roof Panel Assembly112.0ERROR:#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 Assembly0.511.5Site KitCLIN 1001CCLIN 2001CCLIN 3001CCLIN 4001CCLIN 5001CCLIN 6001CCLIN 7001CCLIN 8001CCLIN 9001CCLIN 10001C
V2 4 RF Body Panel Assembly0.511.5ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
V2 2 RF Body0.511.5Rack Sub AssemblyCLIN 1001DCLIN 2001DCLIN 3001DCLIN 4001DCLIN 5001DCLIN 6001DCLIN 7001DCLIN 8001DCLIN 9001DCLIN 10001D
V2 1 RF Body0.511.5ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Computer Pullout Tray Assembly0.511.5
V2 16 Block Din Rail Panel Assembly0.511.5
V2 36 Block Din Rail Panel Assembly0.511.5
V2 Fan Kit0.311.3
DataTray-137-2361-4RTR-V2-8D31.54.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)
CLINCategoryYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Total
1000FAE RacksERROR:#REF!N/AN/AN/AN/AN/AN/AN/AN/AN/AERROR:#REF!
X001A.1Fabricated RacksERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
X001A.2Mod KitsERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
X001A.3Site KitsERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
X001A.4Rack SubassembliesERROR:#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
CLINLabor CategoryLevel of Effort
Base PeriodOpt.1Opt. 2Opt. 3Opt. 4
Years 1&2Years #&4Years 5&6Years 7&8Year 9Year 10
T&M CLINs - Ontario Level of Effort (LOE)
Contract Management
X002A.1Program Manager111111
Program Analyst222222
X002A.2Senior Level
X002A.3Mid Level
X002A.4Junior Level
Property Management, Warehouse, and Acquisition Support
X002A.5Inventory/Warehouse Manager111111
Material Management Specialist222222
X002A.6Mid Level
X002A.7Junior Level
Rack Fabrication Management and Support
X002A.8Rack Fabrication Production Manager111111
CAD Operator111111
X002A.9Senior Level
X002A.10Mid Level
Installation Management and Support
X00A.11Installation Support Manager222222
CAD Operator222222
X002A.9Senior Level
X002A.10Mid Level
EVM Support for FAA Engineering Services
Program Analyst111111
X002A.2Senior Level
X002A.3Mid Level
X002A.4Junior Level
T&M CLINs - Floating Crew Support
Installation Floating Crews
X002A.12Lead Installation/Electronics Technician12108888
Installation/Electronics Technician12108888
X002A.13Mid Level
X002A.14Junior Level
X002A.15Lead Construction/Plants Technician221111
Construction/Plants Technician221111
X002A.16Mid Level
X002A.17Junior Level
Installation Engineering Support
Electronics Engineer222222
X002A.18Senior Level
X002A.19Mid Level
Table 13.Yearly Breakdown of CLINs X002A Estimated NTE Amount ($K)
CLINCategoryYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Total
X002A.1Program Manager00000000000
X002A.2Senior Program Analyst00000000000
X002A.3Program Analyst00000000000
X002A.4Junior Program Analyst00000000000
X002A.5Inventory/ Warehouse Manager00000000000
X002A.6Material Management Specialist00000000000
X002A.7Junior Material Management Specialist00000000000
X002A.8Rack Fabrication Production Manager00000000000
X002A.9Senior CAD Operator00000000000
X002A.10CAD Operator00000000000
X002A.11Installation Support Manager00000000000
X002A.12Lead Installation/ Electronics Technician00000000000
X002A.13Installation/ Electronics Technician00000000000
X002A.14Junior Installation/ Electronics Technician00000000000
X002A.15Lead Construction/ Plants Technician00000000000
X002A.16Construction/ Plants Technician00000000000
X002A.17Junior Construction/ Plants Technician00000000000
X002A.18Senior Electronics Engineer00000000000
X002A.19Electronics Engineer00000000000
Totals:00000000000
Table 14. Other Costs Analysis and Results for Contract ManagementTable 15 Other Costs Analysis and Results for EVM Support for FAA Engineering Services
Analysis of DTFAWA-09-D-00062 for Contract ManagementAnalysis of DTFAWA-09-D-00062 for
DescriptionOther Costs (DC) w/ Indirect Cost AddedEVM support for FAA Engineering Services
TravelMaterial/CAPODCTotal DCDescriptionOther Costs (DC) w/ Indirect Cost Added
Year 8 Totals:$25,868.36$2,071.19$1,463.37$29,402.92TravelMaterial/CAPODCTotal DC
Year 9 Totals:$68,255.23$242.87$1,321.49$69,819.59Year 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.14Year 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.47Year 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.78Max 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.00Average 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 AssemblyTable 18. Other Costs Analysis and Results for Construction/Installation Floating Crews
Analysis of DTFAWA-09-D-00062 for Rack FabricationAnalysis of DTFAWA-09-D-00062 for Floating Crew Tasks
DescriptionActual Other Costs (DC) w/ Indirect Cost AddedRacks per YearDescriptionActual Other Costs (DC) w/ Indirect Cost AddedCrews per Year
TravelMaterial/CAPODCTotal DCShippingTravelMaterial/CAPODCTotal DCFreight
Year 8 Totals:$11,627.85$66,655.60$10,399.30$88,682.75$40,201.01300Year 8 Totals:$1,403,335.99$343,103.99$61,144.09$1,807,584.07$114,932.1910
Year 9 Totals:$11,222.05$9,909.82$2,729.36$23,861.23$47,831.98200Year 9 Totals:$2,092,349.96$476,427.77$84,352.18$2,653,129.92$220,795.9514
Year 10 Totals:$2,520.95$13,275.47$4,287.61$20,084.03$38,998.60200Year 10 Totals:$1,791,086.37$204,735.41$12,834.26$2,008,656.05$191,044.8014
*Year 11 Totals:$17,958.69$0.00$7,052.01$25,010.70$35,333.98120*Year 11 Totals:$1,848,583.09$262,174.00$74,748.78$2,185,505.87$204,724.8014
Max Amount (Years 8-11):$17,958.69$66,655.60$10,399.30$88,682.75$47,831.98Max 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.39Average 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 RackCalculation of Direct Chargers per Rack
Year 8 Totals:$222.19$34.66$256.85$134.00Year 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.16Year 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.99Year 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.45Max 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.65Average 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.00Per Rack & Mod KitAmounts for IGCE:$150,000.00$25,000.00$6,000.00$181,000.00$16,000.00Per Crew
Table 17. Rack Fabrication and Support Annual Estimated Other Costs Costs
CategoryAmt. per RackYears 1&2Years 3&4Years 5&6Years 7&8Year 9Year 10
Number of FAE Racks:4N/AN/AN/AN/AN/A
Max Number of Racks:300200125125125125
Max Number of Mod Kits:100100125125125125
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
CategoryAmt. per CrewYears 1&2Years 3&4Years 5&6Years 7&8Year 9Year 10
Number of Crews:14129999
Other CostsTable 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,000CategoryLubbockOrlandoAverage%ageAnnual Allocation
Material$15,000$210,000$180,000$135,000$135,000$135,000$135,000Travel$98,474.00$120,527.00$109,500.5011%$55,000
CAP$10,000$140,000$120,000$90,000$90,000$90,000$90,000Material/CAP$266,895.00$80,072.00$173,483.5017%$85,000
ODC$6,000$84,000$72,000$54,000$54,000$54,000$54,000ODC$10,276.00$22,837.00$16,556.502%$10,000
Freight (Truck Leases)$16,000$224,000$192,000$144,000$144,000$144,000$144,000Subcontract$848,514.00$574,566.00$711,540.0070%$350,000
Total Other Costs:$2,758,000$2,364,000$1,773,000$1,773,000$1,773,000$1,773,000Totals:$1,224,159.00$798,002.00$1,011,080.50100%$500,000.00
Table 21. Yearly Breakdown of CLINs X002B Estimated NTE Amount ($K)
CLINCategoryYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Total

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 .