Exhibit_B_-_Pricing_Tables.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
Overseas Installation Services (OSIS) for Department of State
Solicitation number
19AQMM19R0182
Issued by

About this file

From the source

Exhibit B

View the file

Other files

File Type Posted
19AQMM19R0182_Amd_01.pdf PDF
OSIS_Solicitation_Amd_01.docx DOCX document
RFP_Q&A.xlsx XLSX spreadsheet
OSIS_Solicitation_Amd_01.docx DOCX document
Exhibit_A_-_Past_Performance_Questionnaire.docx DOCX document
Appendix_J-12_-_CSP_Questionnaire.docx DOCX document
Attachment_A_-_Medical_Requirements_for_Contractors_Deploying_to_Afghanistan.docx DOCX document
Appendix_J-6_-_Applicable_Authorities_and_Publications.pdf PDF
Appendix_J-2_-_Facility_Security_Engineering_Division_and_Security_Systems_Integration_Division_Overview.pdf PDF
Exhibit_D_-_DD_254_-_OSIS_II.pdf PDF
OSIS_Solicitation.pdf PDF
Appendix_J-8_Security_Survey_Checklist_-_Design_Engineer.docx DOCX document
Exhibit_F_-_Award_Determination_Ratings_Table.pdf PDF
Appendix_J-1_-_Acronyms_and_Definitions.pdf PDF
Exhibit_E_-_OSIS_Award_Term_Determination_Plan.docx DOCX document
Attachment_B_-_Forms_and_Documents.pdf PDF
Appendix_J-5_-_CMMS_SOP_Listing.pdf PDF
SF33.pdf PDF
Appendix_J-3_-_Post_Profiles.pdf PDF
Appendix_J-11_CMMS_Item_Master_Catalog.xls XLS spreadsheet
Appendix_J-4_-_STO_Overseas_Organizational_Chart.pdf PDF
Appendix_J-7_-_Customer_Satisfaction_Surveys.pdf PDF
Appendix_J-10_-_Sample_Cost_Analysis_Report.docx DOCX document
Appendix_J-13_Readiness_Report.XLSX XLSX spreadsheet
Appendix_J-14_-_Scenario_-_TSU_Upgrade.pdf PDF
Appendix_J-9_Security_Survey_Checklist_-_Project_Manager.docx DOCX document
Exhibit_C_-_Explanation_of_Benefits.docx DOCX document
Show all 27

On GovTribe

Work with this file

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

Text version

The file's text, extracted by GovTribe without its formatting.

1. Prov. Bill. Ind. Cost Rates Pricing Table 1

Proposed Provisional Billing Indirect Cost Rates

Indirect Cost Rate Description
(e.g., Fringe Benefits, Overhead, G&A)Proposed Provisional Billing Indirect Cost RateBasis of Estimate of Proposed Provisional Billing Indirect Cost Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant Federal Agency Official, Internal Budget Estimate)Allocation Base
(e.g., Total Labor Dollars, Direct Labor Dollars, Total Cost Input)Offeror Fiscal Year Period

(e.g., January 1, 2019 - December 31, 2019) 1)

2)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate DescriptionProposed Provisional Billing Indirect Cost RateBasis of Estimate of Proposed Provisional Billing Indirect Cost RateAllocation BaseOfferor Fiscal Year Period
1) Fringe Benefits29.95%June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2019 -

December 31, 2019 Fringe Benefits 29.85% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2020 - December 31, 2020 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2021 - December 31, 2021 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2022 - December 31, 2022 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2023 - December 31, 2023 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2024 - December 31, 2024 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2025 - December 31, 2025 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2026 - December 31, 2026 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2027 - December 31, 2027 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2028 - December 31, 2028 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2029 - December 31, 2029 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2030 - December 31, 2030

2. Ceiling Indirect Cost Rates Pricing Table 2

Proposed Ceiling Indirect Cost Rates

Indirect Cost Rate Description
(e.g., Fringe Benefits, Overhead, G&A)Proposed Ceiling Indirect Cost RateBasis of Estimate of Proposed Ceiling Indirect Cost Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant Federal Agency Official, Internal Budget Estimate)Allocation Base
(e.g., Total Labor Dollars, Direct Labor Dollars, Total Cost Input)Offeror Fiscal Year Period

(e.g., January 1, 2019 - December 31, 2019) 1)

2)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate DescriptionProposed Ceiling Indirect Cost RateBasis of Estimate of Proposed Proposed Ceiling Indirect Cost RateAllocation BaseOfferor Fiscal Year Period
1) Fringe Benefits29.95%June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2019 -

December 31, 2019 Fringe Benefits 29.85% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2020 - December 31, 2020 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2021 - December 31, 2021 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2022 - December 31, 2022 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2023 - December 31, 2023 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2024 - December 31, 2024 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2025 - December 31, 2025 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2026 - December 31, 2026 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2027 - December 31, 2027 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2028 - December 31, 2028 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2029 - December 31, 2029 Fringe Benefits 29.80% June 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2030 - December 31, 2030

3. Fee Percentages

Pricing Table 3 Proposed Fee Percentages

Contract Period 1Contract Period 2Contract Period 3Contract Period 4Contract Period 5Contract Period 6Contract Period 7Contract Period 8Contract Period 9Contract Period 10Six-Month Option to Extend (FAR 52.217-8)
11
Notes
1) Offerors shall propose one fee percentage per contract period.
2) The proposed fee percentages shall not exceed two decimal places.
3) The proposed fee percentages shall not exceed the statutory limitation of 10.00%.

4. Prices Pricing Table 4 Estimated Costs and Prices

Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Contract Year 6Contract Year 7Contract Year 8Contract Year 9Contract Year 10Six-Month Option to
Extend (FAR 52.217-8)TOTAL
CLIN/
Sub-CLINDescriptionDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $SubtotalDirect $Ind. $Subtotal
X001
X001ATSU - Survey Phase000000000000
X001BTSU - Design Phase000000000000
X001CTSU - Ordering and Logistics Phase000000000000
X001DTSU - Installation Phase000000000000
X001ETSU - Project Close-out Phase000000000000
X001FTSS Integration000000000000
X001GContingency TSS Operations Support000000000000
X001HTSS Installation Support000000000000
X001IOPC Maintenance and Repair Support000000000000
X001JDSIAS/Special Projects and Technology Insertion000000000000
X001KOPC Policy, Planning, and Performance Support000000000000
X001LProgram Management Support000000000000
X001MProject Management Support000000000000
X001NTransition000000000000
X001OTravel9,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0004,750,0004,750,00099,750,000
X001PPost Hardship Differential Pay000000000000
X001QDanger Pay000000000000
X001RDefense Base Act (DBA) Insurance000000000000
X001SFacilities000000000000
X001TTools000000000000
9,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0009,500,0004,750,00099,750,000
Fee %SubtotalFee %SubtotalFee %SubtotalFee %SubtotalFee %SubtotalFee %SubtotalFee %SubtotalFee %SubtotalFee %SubtotalFee %SubtotalFee %Subtotal
X002Fixed Fee0.00%00.00%00.00%00.00%00.00%00.00%00.00%00.00%00.00%00.00%00.00%00

TOTAL 9,500,000 9,500,000 9,500,000 9,500,000 9,500,000 9,500,000 9,500,000 9,500,000 9,500,000 9,500,000 4,750,000

OVERALL PROPOSED PRICE 99,750,000

Notes

CLIN = Contract line item number (bolded)
Sub-CLIN = Sub-contract line item number (unbolded)
Direct $ = Estimated direct cost
Ind. $ = Estimated indirect cost
Fee % = Proposed fee percentage from Pricing Table 3
Subtotal (sub-CLINs X001A-X001T) = Estimated direct cost + estimated indirect cost
Subtotal (CLIN X002) = Sum of Subtotals of sub-CLINs X001A-X001T x Fee %
Total = Sum of Subtotals
Overall Proposed Price = Sum of Totals

5. Sample Composite Ind Rates

Pricing Table 5FOR ILLUSTRATION PURPOSES ONLY
Sample Composite G&A Rate by Contract Period
Sample Offeror Fiscal YearSample Ceiling G&A Rate Proposed in Pricing Table 2Cont Yr 1Cont Yr 2Cont Yr 3Cont Yr 4Cont Yr 5Cont Yr 6Cont Yr 7Cont Yr 8Cont Yr 9Cont Yr 10Six Mo. Option
January 1, 2019 - December 31, 20197.18%7.12%
January 1, 2020 - December 31, 20207.10%7.06%
January 1, 2021 - December 31, 20217.05%7.04%
January 1, 2022 - December 31, 20227.03%6.93%
January 1, 2023 - December 31, 20236.90%6.90%
January 1, 2024 - December 31, 20246.90%6.90%
January 1, 2025 - December 31, 20256.90%6.90%
January 1, 2026 - December 31, 20266.90%6.90%
January 1, 2027 - December 31, 20276.90%6.90%
January 1, 2028 - December 31, 20286.90%6.90%
January 1, 2029 - December 31, 20296.90%6.90%
January 1, 2030 - December 31, 20306.90%

In this example, if G&A is applied in the proposal, then the offeror would apply 7.12% to the estimated Contract Year 1/Base Year costs, 7.06% to the estimated Contract Year 2 costs, etc.

This example blends the sample offeror fiscal year with the following period of performance, which is specified in Instruction No. 5 in the Price Proposal Instructions described in RFP Section L.19.1.
Contract Year 1/Base Year:October 1, 2019 through September 30, 2020
Contract Year 2 (Option or Award Term):October 1, 2020 through September 30, 2021
Contract Year 3 (Option or Award Term):October 1, 2021 through September 30, 2022
Contract Year 4 (Option or Award Term):October 1, 2022 through September 30, 2023
Contract Year 5 (Option or Award Term):October 1, 2023 through September 30, 2024
Contract Year 6 (Option or Award Term):October 1, 2024 through September 30, 2025
Contract Year 7 (Option or Award Term):October 1, 2025 through September 30, 2026
Contract Year 8 (Option or Award Term):October 1, 2026 through September 30, 2027
Contract Year 9 (Option or Award Term):October 1, 2027 through September 30, 2028
Contract Year 10 (Option or Award Term):October 1, 2028 through September 30, 2029
Six-Month Option to Extend:October 1, 2029 through March 31, 2030
Pursuant to the formulas in columns C through L:
1. There are 92 days from October 1 through December 31, and 273 days (or 274 days for Contract Years 1, 5, and 9) from January 1 through September 30.
2. Contract Years 1, 5, and 9, which run from October 1 through September 30 in their respective years, each have 366 days because February 29 occurs in 2020, 2024, and 2028.
3. Each other year, except the Six-Month Option to Extend Period, has 365 days.
Pursuant to the formula in cell M14, there are 182 days in the Six-Month Option to Extend Period.

File details come from the government source that posted it.