Attachment_10_Rev_01_-_Pricing_Tables.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
Professional, Administrative, and Facilities Support Services
Solicitation number
SWHARC15R0005
Issued by

About this file

Attachment 10 - Revision 01

View the file

Other files

File Type Posted
SWHARC15R0005-A002.pdf PDF
Attachment_1_Rev_01_-_Labor_Category_Descriptions.pdf PDF
SWHARC15R0005_-_Summary_of_Changes_A001_-_12_Jan_2016.pdf PDF
Attachment_8_Rev_01_-_Labor_Categories_FSN_Equivalents.pdf PDF
SWHARC15R0005-A001.pdf PDF
SWHARC15R0005_-_Q As_-_12_Jan_2016.pdf PDF
SWHARC15R0005_-_Questions_Template.docx DOCX document
SWHARC15R0005.pdf PDF
Attachment_1_-_Labor_Category_Descriptions.pdf PDF
Attachment_8_-_Labor_Categories_FSN_Equivalents.pdf PDF
Attachment_9_-_Embassy_Bogota_FSN_Pay_Scales.pdf PDF
Attachment_6_-_Sample_Subcontracting_Report.pdf PDF
Attachment_3A_-_Program_Manager_Required_Qualifications.pdf PDF
Attachment_5B_-_Sample_Client_Authorization_Letter.docx DOCX document
Attachment_3_-_Program_Management_Office_Requirements.pdf PDF
Attachment_10_-_Pricing_Tables.xlsx XLSX spreadsheet
Attachment_5A_-_Sample_Subcontractor_Consent_Letter.docx DOCX document
Attachment_7_-_Key_Personnel_Resume_Format.pdf PDF
Attachment_5_-_Past_Performance_Questionnaire.docx DOCX document
Draft_SWHARC15R0005_-_Q As_-_27_Nov_2015.pdf PDF
Draft_Attachment_4A_-_Sample_Subcontractor_Consent_Letter.pdf PDF
Draft_Attachment_4B_-_Sample_Client_Authorization_Letter.pdf PDF
Draft_Attachment_4_-_Past_Performance_Questionnaire.pdf PDF
Draft_Attachment_5_-_Sample_Subcontracting_Report.xlsx XLSX spreadsheet
Draft_SWHARC15R0005_-_Questions_ _Recommendations_Template.docx DOCX document
Draft_Attachment_1_-_Labor_Category_Descriptions.pdf PDF
Draft_SWHARC15R0005.pdf PDF
Draft_Attachment_6_-_Key_Personnel_Resume_Format.pdf PDF
Draft_Attachment_2_-_Pricing_Table.xlsx XLSX spreadsheet
Show all 29

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

1. Compliance Checklist- IDIQ

Pricing Table 1 Rev. 01Price Volume Compliance Checklist - Revision 01
RFP
ReferenceRequirementComply
(Yes/No)Proposal Reference
L.17.2.3(b)(1)The price proposal shall consist of the following, which are described further in this subsection:

a. Narrative (in Word or PDF)

b. Pricing Tables 1-6 (Excel file)

L.17.2.3(b)(2)Pricing Tables 1-6 are provided by the Government (Section J, Attachment 10) and shall be completed by the offerors. Detail Pricing Tables shall be provided and completed by the offerors.
L.17.2.3(b)(3)Offerors shall not add, delete, or otherwise alter the existing format or content in Pricing Tables 1-6. Offerors shall complete the required areas only.
L.17.2.3(b)(4)Offerors shall use for pricing purposes the following period of performance:

Base Period: May 1, 2016 through April 30, 2017 Option Period 1: May 1, 2017 through April 30, 2018 Option Period 2: May 1, 2018 through April 30, 2019 Option Period 3: May 1, 2019 through April 30, 2020 Option Period 4: May 1, 2020 through April 30, 2021 Six-Month Option to Extend: May 1, 2021 through October 31, 2021

L.17.2.3(b)(5)In Pricing Table 1, offerors shall complete the “Comply (Yes/No)” and “Proposal Reference” columns.
L.17.2.3(b)(6)In Pricing Table 4, offers shall propose a monthly FFP amount for performance of all requirements identified in Attachment 3 under Section J.
L.17.2.3(b)(7)In Pricing Table 4, the proposed prices shall not exceed two decimal places.
L.17.2.3(b)(8)In Pricing Table 4, each proposed monthly FFP shall consist of all costs (direct, indirect, labor, non-labor, minimum costs required by local laws) and profit.
L.17.2.3(b)(9)In Pricing Table 5, offerors shall propose one fixed fully-loaded hourly labor rate per labor category/CLIN per period, regardless of which entity (offeror, subcontractor offeror, or other) is anticipated to perform the labor category.
L.17.2.3(b)(10)The labor categories included in Pricing Table 5 represent the known Government requirements. As such, a failure to propose rates for all labor categories and for all contract periods will be considered a material non-conformity by the Government.

Note: In the context of this RFP, a proposed fixed fully-loaded hourly labor rate is one that is not $0.00 or other nominal amount. It is one at which the contractor is expected to cover its costs and receive a reasonable profit. If an offeror normally allocates indirectly the costs associated with a labor category identified in Pricing Table 5, we remind such offeror that such allocation does not relieve the offeror from complying with each solicitation term, including this instruction, and any resulting contract term.

L.17.2.3(b)(11)In Pricing Table 5, the respective proposed fixed fully-loaded hourly labor rates shall be based on a normal workweek of 40 hours (8 hours per day x 5 days per week) for performance inside the continental United States (CONUS) or in Bogota, Colombia. The 48 hours (8 hours per day x 6 days per week) normal workweek applies to performance in Colombia (excluding Bogota).
L.17.2.3(b)(12)In Pricing Table 5, each proposed fixed fully-loaded hourly labor rate shall consist of a proposed unloaded hourly rate, any labor-related direct costs (e.g., any direct fringe benefits, any direct bonuses), applicable indirect costs, and profit. It also shall include at least the minimum labor rate and minimum costs required by applicable labor laws. It shall not include any other costs, including DBA Insurance and additional compensation costs like post hardship differential pay and danger pay. See Section B.4(f).
L.17.2.3(b)(13)In Pricing Table 5, the proposed fixed fully-loaded hourly labor rates shall be based on performance by Local National employees only. The Government anticipates that, like the existing contract, this successor contract will be performed by Local National employees only.
L.17.2.3(b)(14)In Pricing Table 5, the proposed fixed fully-loaded hourly labor rates shall not exceed two decimal places.
L.17.2.3(b)(15)In Pricing Table 6, the Government provided formulas to transfer automatically the proposed FFP for PMO and the fixed fully-loaded hourly labor rates from Pricing Tables 4 and 5, respectively, to the respective cells in the “FFUP” and “Fixed Rate” columns. However, offerors shall verify the transfer.
L.17.2.3(b)(16)In Pricing Table 6, the Government provided formulas to calculate automatically each proposed Subtotal under the two labor sections. Each formula is “FTE Per Year” multiplied by “Fixed Rate” multiplied by “Hours.” However, offerors shall verify the arithmetic accuracy.
L.17.2.3(b)(17)In Pricing Table 6, the Government provided formulas to calculate automatically the proposed Subtotal, Total, and Overall Proposed Price. However, offerors shall verify the arithmetic accuracy.
L.17.2.3(b)(18)In Pricing Table 6, the proposed Subtotal, Total, and Overall Proposed Price shall be in whole numbers (i.e., no decimals).
L.17.2.3(b)(19)In Pricing Tables 1-6, offerors shall complete all applicable data cells.
L.17.2.3(b)(20)In Pricing Tables 1-6, offerors shall not hide or lock any rows, columns, or cells that contain proposed data.
L.17.2.3(b)(21)In Pricing Tables 1-6, offerors shall propose all rates and prices in United States currency.
L.17.2.3(b)(22)In the Narrative, offerors shall identify, for each labor category, the basis of estimate of the proposed unloaded hourly labor rate comprising the proposed fixed fully-loaded hourly labor rate. Examples are actual salary, market survey(s), and letter of intent to hire.
L.17.2.3(b)(23)In the Narrative, offerors shall identify each internal labor category corresponding to RFP-specified labor category (if applicable). There might be instances in which the internal labor categories used by an offeror do not match with those required in Pricing Table 5. If this is the case, the Offeror shall include a reference matrix correlating each contract labor category to the internal labor category used by the offeror. The offeror shall not alter the labor categories included in the Pricing Tables.
L.17.2.3(b)(24)In the Narrative, pursuant to FAR 52.246-6(f) (Inspection – Time-and-Material and Labor-Hour), offerors shall identify the percentage of the proposed fixed fully-loaded hourly labor rates attributable to profit.

&"Times New Roman,Regular"&12

2. Reserved Pricing Table 2 RESERVED

3. Reserved Pricing Table 3 RESERVED

4. FFP PMO

Pricing Table 4 - Rev. 01 Proposed FFP per Month for PMO - Revision 01

CLINDescriptionBase Year (0001)Option Year 1 (1001)Option Year 2 (2001)Option Year 3 (3001)Option Year 4 (4001)Six-Month Option to Extend (see FAR 52.217-8) (5001)
X001Program Management Office0.000.000.000.000.000.00

5. Fixed Labor Rates Pricing Table 5 - Rev. 01 Proposed Fixed Fully-Loaded Hourly Labor Rates - Revision 01

40-Hour Normal Workweek
Base YearOption Year 1Option Year 2Option Year 3Option Year 4Six-Month Option to Extend
CLINNationalityLabor Category(see FAR 52.217-8)
RFP-specified
X100LNCHIEF NURSE INSTRUCTOR SUPERVISOR
X101LNARCHITECT
X102LNGENERAL SERVICES CLERK
X103LNSUPPORT SPECIALIST
X104LNPROCUREMENT CLERK
X105LNADMINISTRATIVE ASSISTANT
X106LNOPERATIONS MANAGER
X107LNSECURITY INVESTIGATOR
X108LNLOGISITCS ASSISTANT
X109LNLOGISTICS CLERK
X110LNLOGISTICS COORDINATOR
X111LNACCOUNTANT
X112LNADVISOR INTERDICTION
X113LNAVIATION ADVISOR
X114LNAVIATION ADVISOR AND PILOT
X115LNRESERVED
X116LNCHEMIST
X117LNCOLOMBIAN LIAISON ADVISOR
X118LNCONTRACTING/LEGAL ASSISTANT
X119LNCRIMINAL LAW/LEGAL ASSISTANT
X120LNDIGITALIZATION AND DATA BASE TECHNICIAN
X121LNSCIENTIFIC FIELD ADVISOR
X122LNFACILITIES MAINTENANCE AND DEPLOYMENT MANAGER
X123LNFACILITIES MAINTENANCE AND DEPLOYMENT POWER GENERATOR - CONSTRUCTION TECHNICIAN
X124LNINTELLIGENCE PLANNER/FIELD ADVISOR
X125LNDEMOBILIZATION INTELLIGENCE ADVISOR
X126LNJOINTS OPERATION ADVISOR
X127LNKNOWLEDGE MANAGEMENT ADVISOR
X128LNNIGHT VISION SYSTEMS INSTRUCTOR & WORKSHOP SUPERVISOR
X129LNPROGRAM ADVISOR FOR RIS
X130LNPROGRAM ASSISTANT BASE SECURITY
X131LNSEARCH AND RESCUE SPECIALIST
X132LNSECURITY CONSOLIDATION SPECIALIST
X133LNSTANDARDIZATION INSTRUCTOR PILOT UH-1 HUEY II
X134LNSTANDARDIZATION INSTRUCTOR PILOT MAINTENANCE EXAMINER SP-ME UH-1 HUEY I
X135LNSTANDARDIZATION INSTRUCTOR NON RATED - UH-1 HUEY II - UH-60
X136LNSUPERVISOR MARITIME
X137LNTECHNICAL ADVISOR – STRATEGIC INITIATIVE
X138LNTOXICOLOGIST – EPIDEMIOLOGIST
X139LNWEAPONS SYSTEM SUPERVISOR INSTRUCTOR
X140LNMANUAL ERADICATION SPECIALIST
48-Hour Normal Workweek
Base YearOption Year 1Option Year 2Option Year 3Option Year 4Six-Month Option to Extend
CLINNationalityLabor Category(see FAR 52.217-8)
RFP-specified
X300LNARCHITECT TECHNICIAN DRAFTSMAN
X301LNGROUND SUPPORT EQUIPMENT (GSE) LEAD MECHANIC
X302LNVEHICLE MAINTENANCE TECHNICIAN/OPERATOR
X303LNGROUND SUPPORT EQUIPMENT MANAGER
X304LNHANDYMAN - PART TIME
X305LNINVENTORY CONTROL SPECIALIST
X306LNAVIATION FUEL AND CHEMICAL EQUIPMENT MAINTENANCE EXPERT
X307LNBASE SUPPORT COORDINATOR
X308LNDEPUTY FACILITIES MAINTENANCE AND DEPLOYMENT MANAGER
X309LNFACILITIES MAINTENANCE & DEPLOYMENT ELECTRICIAN – AIR CONDITION TECHNICIAN
X310LNFACILITIES MAINTENANCE & DEPLOYMENT LEAD
Notes
An hourly rate must not be included for CLIN X115
Notes
40 = The number of hours in a normal workweek at which the fixed fully-loaded hourly labor rates in that column are being proposed.
48 = The number of hours in a normal workweek at which the fixed fully-loaded hourly labor rates in that column are being proposed.
Gray cell = Labor category is not expected to perform under this normal workweek schedule.
Nationality = LN, US, or TCN

6. IDIQ Prices Pricing Table 6 - Rev. 01 IDIQ Proposed Prices - Revision 01

Program Management Office - FFP

Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4 Six-Month Option to Extend

CLINDescriptionFFUPMonthsSubtotalFFUPMonthsSubtotalFFUPMonthsSubtotalFFUPMonthsSubtotalFFUPMonthsSubtotalFFUPMonthsSubtotalTotal
X001PROGRAM MANAGEMENT OFFICE0.0012- 00.0012- 00.0012- 00.0012- 00.0012- 00.006- 00

40-Hour Normal Workweek

Base YearOption Year 1Option Year 2Option Year 3Option Year 4Six-Month Option to Extend
(see FAR 52.217-8)
CLINNationalityRFP-specified Labor CategoryFTE Per YearFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalTotal
X100LNCHIEF NURSE INSTRUCTOR SUPERVISOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X101LNARCHITECT1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X102LNGENERAL SERVICES CLERK1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X103LNSUPPORT SPECIALIST1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X104LNPROCUREMENT CLERK1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X105LNADMINISTRATIVE ASSISTANT6.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X106LNOPERATIONS MANAGER2.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X107LNSECURITY INVESTIGATOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X108LNLOGISITCS ASSISTANT1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X109LNLOGISTICS CLERK1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X110LNLOGISTICS COORDINATOR5.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X111LNACCOUNTANT1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X112LNADVISOR INTERDICTION1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X113LNAVIATION ADVISOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X114LNAVIATION ADVISOR AND PILOT1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X115LNRESERVED0.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X116LNCHEMIST1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X117LNCOLOMBIAN LIAISON ADVISOR3.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X118LNCONTRACTING/LEGAL ASSISTANT1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X119LNCRIMINAL LAW/LEGAL ASSISTANT1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X120LNDIGITALIZATION AND DATA BASE TECHNICIAN1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X121LNSCIENTIFIC FIELD ADVISOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X122LNFACILITIES MAINTENANCE AND DEPLOYMENT MANAGER1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X123LNFACILITIES MAINTENANCE AND DEPLOYMENT POWER GENERATOR - CONSTRUCTION TECHNICIAN18.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X124LNINTELLIGENCE PLANNER/FIELD ADVISOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X125LNDEMOBILIZATION INTELLIGENCE ADVISOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X126LNJOINTS OPERATION ADVISOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X127LNKNOWLEDGE MANAGEMENT ADVISOR2.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X128LNNIGHT VISION SYSTEMS INSTRUCTOR & WORKSHOP SUPERVISOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X129LNPROGRAM ADVISOR FOR RIS1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X130LNPROGRAM ASSISTANT BASE SECURITY1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X131LNSEARCH AND RESCUE SPECIALIST1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X132LNSECURITY CONSOLIDATION SPECIALIST1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X133LNSTANDARDIZATION INSTRUCTOR PILOT UH-1 HUEY II1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X134LNSTANDARDIZATION INSTRUCTOR PILOT MAINTENANCE EXAMINER SP-ME UH-1 HUEY I1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X135LNSTANDARDIZATION INSTRUCTOR NON RATED - UH-1 HUEY II - UH-601.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X136LNSUPERVISOR MARITIME1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X137LNTECHNICAL ADVISOR – STRATEGIC INITIATIVE2.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X138LNTOXICOLOGIST – EPIDEMIOLOGIST1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X139LNWEAPONS SYSTEM SUPERVISOR INSTRUCTOR1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
X140LNMANUAL ERADICATION SPECIALIST1.000.001,79200.001,79200.001,79200.001,79200.001,79200.0089600
Sub-total 40-Hour Normal Work Week71.000000000

48-Hour Normal Workweek

Base YearOption Year 1Option Year 2Option Year 3Option Year 4Six-Month Option to Extend
(see FAR 52.217-8)
CLINNationalityRFP-specified Labor CategoryFTE Per YearFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalTotal
X300LNARCHITECT TECHNICIAN DRAFTSMAN1.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X301LNGROUND SUPPORT EQUIPMENT (GSE) LEAD MECHANIC1.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X302LNVEHICLE MAINTENANCE TECHNICIAN/OPERATOR5.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X303LNGROUND SUPPORT EQUIPMENT MANAGER1.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X304LNHANDYMAN - PART TIME0.50$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X305LNINVENTORY CONTROL SPECIALIST2.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X306LNAVIATION FUEL AND CHEMICAL EQUIPMENT MAINTENANCE EXPERT1.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X307LNBASE SUPPORT COORDINATOR4.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X308LNDEPUTY FACILITIES MAINTENANCE AND DEPLOYMENT MANAGER1.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X309LNFACILITIES MAINTENANCE & DEPLOYMENT ELECTRICIAN – AIR CONDITION TECHNICIAN13.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
X310LNFACILITIES MAINTENANCE & DEPLOYMENT LEAD8.00$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 02208$ - 0$ - 01104$ - 00
Sub-total 48-Hour Normal Work Week37.500000000

OVERALL PROPOSED PRICE 0

Notes
FTE Per Year = RFP-specified estimated full-time equivalent (FTE) employees per year
Fixed Rate = Proposed fixed fully-loaded hourly labor rate
Hours = RFP-specified estimated number of productive hours per year
Subtotal (Labor) = FTE Per Year x Fixed Rate x Hours
FFUP = Proposed firm-fixed-unit-price (per month)
Subtotal (Select Services) = FFUP x Months

File details come from the government source that posted it. Updated .