Attachment 9-Pricing Sheet.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
Credentialing Services Federal contract opportunity
Solicitation number
70US0921R70090014
Issued by
Department of Homeland Security US Secret Service

View the file

Other files for this federal contract opportunity

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

Instructions Attachment X - Pricing Template

Please see RFQ Section X, Price Quotation, for complete instructions.

In accordance with RFQ Section X, the quoter shall complete Attachment 1: Pricing Template of this RFQ and return it with their price quote submission.

All pricing proposed prices will be used as the BPA prices.

The following instructions shall be used in completing the Pricing Template Worksheets. Each Quoter must complete as needed only the shaded "yellow" cells as needed.

1) "1. Labor Categories Description" tab - For each proposed labor category include the job title, minimum education, years of experience, Minimum Experience, and Functional Responsibility.
The yellow shaded areas to be completed as needed.
2) "2. T&M Labor Rates" tab: For each labor category proposed, For each of the labor categories proposed input the commercial base rate, and discounts proposed. The escalation rate field must also be completed, the model will then populate the option year labor rates.
The yellow shaded areas to be completed as needed.
3) "3. Scenario 1" Tab: This sheet calculates the scenario pricing 1. Offerors are to input the reference number for each proposed labor category from the "2. T&M Labor Rate" tab and the proposed scenario hours. Offerrors are to proposed Other Direct Costs for this scenario, and the total amount of other direct costs proposed will be used as the other direct cost ceiling on all task orders. Offerors may proposed an escalation for other direct costs as shown. Each category of expense must be listed and a description of each must be included.
The yellow shaded areas to be completed as needed.
4) "4. Scenario 2" Tab: This sheet calculates the scenario pricing. Offerors are to input the reference number for each proposed labor category from the "2. T&M Labor Rate" tab and the proposed scenario hours.
The yellow shaded areas to be completed as needed.
5) "5. Proposed Price" tab: All data on this sheet will self populate. The sheet contains the "Total evaluation price". Make no changes to this tab.

Attachment 1

&F &A

1. Labor Categories Descriptio

Cross reference # - agrees across tabs
Site - ContractorJob Title (Level)Min. EducationYears ExperienceFunctional Responsibility
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

&F &A

2. Labor Rates

Escalation Applied to Out Years 2.00%

Cross reference # - agrees across tabsLABOR CATEGORYLevelBase Period RateDiscount ProposedBase PeriodOption Year 1Option Year 2Option Year 3 -Option Year 4
INPUT REFERENCE # FROM LABOR RATE TAB00000
1NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
2NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
3NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
4NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
5NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
6NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
7NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
8NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
9NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
10NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
11NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
12NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
13NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
14NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0
15NA$ - 00.00%$ - 0$ - 0$ - 0$ - 0$ - 0

&F &A

3. Scenario 1

Scenario 1
Reference #Labor Category InformationBase Labor RateLabor HoursEvaluated Price
Cross reference # - agrees across tabs
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
Total Labor Costs$ - 0
Other Direct Costs
NameDescriptionUnit PriceQty RequiredEvaluated Price
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0
$ - 0- 0$ - 0

Total Other Direct Costs (Task Order Ceiling) $ - 0

Escalation for Ceiling on Other Direct Costs / Options 2.00%

&F &A

4. Scenario 2

Scenario 2
Reference #Labor Category InformationBase Labor RateLabor HoursEvaluated Price
Cross reference # - agrees across tabs
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
INPUT REFERENCE # FROM LABOR RATE TAB- 0$ - 0
Total Labor Costs$ - 0

5. Evaluated Price

Evaliated Price
Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4Total Evaluated
Scenario 1 (Labor)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Scenario 1 (Other Direct Costs - Ceiling for Task Orders)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Scenario 2 (Labor)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Scenario 1 (Other Direct Costs - Ceiling for Task Orders)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

&F &A

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