Attachment_4_-_Pricing_Schedule.xlsx

XLSX spreadsheet 64 KB Posted Oct 11, 2022

Attached to: Litigation Support Services Federal contract opportunity
Solicitation number: 140D0423R0001
Issued by: Department of the Interior Departmental Offices Interior Business Center

About this file

Written by GovTribe AI · Dec 27, 2023

This pricing schedule attachment provides labor category details for a litigation support services solicitation issued by the Department of the Interior. The solicitation seeks pricing for nine labor categories - four related to litigation support and five for administrative support - across multiple U.S. locations and periods of performance. Offerors are instructed to complete the blue cells with applicable wage determinations, proposed standard and overtime wage rates by location, and Fair Labor Standards Act classifications. Weightings by location and period of performance are provided to calculate total evaluated pricing.

View the file

Other files for this federal contract opportunity

Other files attached to Litigation Support Services, newest first.
File	Type	Posted
Sol_140D0423R0001_Amd_0002.pdf	PDF	Oct 26, 2022
Attachment_9_-_FAR_52_212-5_Addendum_rev__1_0001.xlsx	XLSX spreadsheet	Oct 24, 2022
Sol_140D0423R0001_Amd_0001.pdf	PDF	Oct 24, 2022
Attachment_8_-_FAR_52_212-1_Addendum_-_Instructions_to_Offerors-Commercial_Products_and_Commercial_Services_rev__1_0001.pdf	PDF	Oct 24, 2022
Attachment_9_-_FAR_52_212-5_Addendum.xlsx	XLSX spreadsheet	Oct 11, 2022
Attachment_7_-_Wage_Determinations.pdf	PDF	Oct 11, 2022
Attachment_3_-_Past_Performance_Information_Sheet.docx	DOCX document	Oct 11, 2022
Attachment_1_-_Statement_of_Work.pdf	PDF	Oct 11, 2022
Attachment_6_-_Certificate_of_Non-Disclosure.docx	DOCX document	Oct 11, 2022
Sol_140D0423R0001.pdf	PDF	Oct 11, 2022
Attachment_5_-_Certificate_of_No_Conflict_Of_Interest.docx	DOCX document	Oct 11, 2022
Attachment_8_-_FAR_52_212-1_Addendum_-_Instructions_to_Offerors-Commercial_Products_and_Commercial_Services.pdf	PDF	Oct 11, 2022
Attachment_2_-_Compliance_Matrix.xlsx	XLSX spreadsheet	Oct 11, 2022

Show all 13

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

Try for free Login

Text version

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

Instructions

Worksheet	Instructions
General	1. Data entry required is located in the blue colored cells. All blue colored cells should be completed by the offeror.
Wage Determinations	1. Enter the applicable Wage Determination (WD) number in the WD column for the Contractor's Location.
	2. Enter the current WD revision number in the Rev column for the Contractor's Location.
Base, OY1, OY2, OY3, OY4, and FAR 52.217-8	1. All wage rates are to be in U.S. dollars and to two decimal places.
	2. Base - In the base row for each labor category, enter the proposed standard wage rate for all locations.
	3. OT- In the OT row for each labor category, enter an overtime wage rate for all locations.
	4. FLSA - Fair Labor Standards Act (FLSA) - Using the drop-down list, select if the labor category is exempt, non-exempt from FLSA.
	5. All wage rates (base and OT), locations, FLSA classifications must be completed for all periods of performance.
	6. Failure to complete all required data entry rate may eliminate the offer from consideration from award.
Printing	Print the Base, OY1, OY2, OY3, OY4, FAR 52.217-8, and Price Evaluation Factor worksheets in .PDF format and submit with the proposal.

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

Weightings

Base

Boston (Newton), MA

Pittsburgh, PA

Twin Cities, MN

Atlanta, GA

Knoxville, TN

Albuquerque, NM

Santa Fe, NM

Tulsa, OK

Sacramento, CA

San Francisco, CA

Portland, OR

Boise, ID

Salt Lake City, UT

Phoenix, AZ

Denver, CO

Billings, MT

Anchorage, AK

Washington, D.C.

Lenexa, KS

Contractor's Location

Total Weighting

Base	0.01	0.01	0.01	0.01	0.04	0.01	0.01	0.05	0.01	0.03	0.01	0.01	0.03	0.01	0.03	0.01	0.01	0.35	0.25	0.1	1.0
OT	0.01	0.01	0.01	0.01	0.04	0.01	0.01	0.05	0.01	0.03	0.01	0.01	0.03	0.01	0.03	0.01	0.01	0.35	0.25	0.1	1.0

Overall
Base	0.95
OT	0.05

	Number of Estimated FTEs/Year	Hours/FTE	Total Number of Hours/Year
1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I	2.0	1920.0	3840.0
2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II	13.0	1920.0	24960.0
3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III	3.0	1920.0	5760.0
4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV	0.5	1920.0	960.0
5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I	1.0	1920.0	1920.0
6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II	4.0	1920.0	7680.0
7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III	1.0	1920.0	1920.0
8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV	0.5	1920.0	960.0
9) (F) Receiving Clerk/Facilities Ops Clerk I	1.0	1920.0	1920.0

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

Wage Determinations

Applicable Wage Determinations various Rev Dates (latest): Base Year
Occupation Code-Sub-Code
01000 - Administrative Support & Clerical Occupations
21000 - Materials Handling & Packing Occupations
30000 - Technical Occupations
01111-01113 - General Clerk I-III
30361-30364 - Paralegal/Legal Assistant I-IV
	State, City	WD	Rev	State, City	WD	Rev
	MA - Boston (Newton)	2015-4047	21	OR - Portland	2015-5563	18
	PA - Pittsburgh	2015-4235	21	ID - Boise	2015-5503	18
	MN - Twin Cities	2015-4945	20	UT - Salt Lake City	2015-5489	19
	GA - Atlanta	2015-4471	23	AZ - Phoenix	2015-5469	20
	TN - Knoxville	2015-4643	21	CO - Denver	2015-5419	22
	NM - Albuqueque	2015-5443	18	MT - Billings	2015-5389	18
	NM - Santa Fe	2015-5449	18	AK - Anchorage	2015-5681	16
	OK - Tulsa	2015-5317	19	Washington DC	2015-4281	24
	CA - Sacramento	2015-5631	17	KS - Lenexa	2015-5105	18
	CA - San Francisco	2015-5637	22	Contractor's Location

Estimated NTE 1,920 Hours: 2,080 (FT) - 160 hrs (4 weeks*) = 1,920-hours (billable) *this time is inclusive of Holidays

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

Base

Labor Rates by Category, Period of Performance, and Location

Applicable Wage Determinations (latest Rev Date(s))

Base Year (4/1/2023 - 3/31/2024)

ITEM # LABOR CATEGORY

Boston (Newton), MA

Pittsburgh, PA

Twin Cities, MN

Atlanta, GA

Knoxville, TN

Albuquerque, NM

Santa Fe, NM

Tulsa, OK

Sacramento, CA

San Francisco, CA

Portland, OR

Boise, ID

Salt Lake City, UT

Phoenix, AZ

Denver, CO

Billings, MT

Anchorage, AK

Washington, D.C.

Lenexa, KS

Contractor's Location

Weighted Average Labor Rate

Litigation Support (L)

1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I

Base

$0.00

FLSA

2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II

Base

$0.00

FLSA

3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III

Base

$0.00

FLSA

4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV

Base

$0.00

FLSA

Administrative Support (A)

5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I

Base

$0.00

FLSA

6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II

Base

$0.00

FLSA

7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III

Base

$0.00

FLSA

8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV

Base

$0.00

FLSA

Facilities Operations (F)

9) (F) Receiving Clerk/Facilities Ops Clerk I

Base

$0.00

FLSA

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

OY1

Labor Rates by Category, Period of Performance, and Location

Applicable Wage Determinations (latest Rev Date(s))

Option Year 1 (4/1/2024 - 3/31/2025)

ITEM # LABOR CATEGORY

Boston (Newton), MA

Pittsburgh, PA

Twin Cities, MN

Atlanta, GA

Knoxville, TN

Albuquerque, NM

Santa Fe, NM

Tulsa, OK

Sacramento, CA

San Francisco, CA

Portland, OR

Boise, ID

Salt Lake City, UT

Phoenix, AZ

Denver, CO

Billings, MT

Anchorage, AK

Washington, D.C.

Lenexa, KS

Contractor's Location

Weighted Average Labor Rate

Litigation Support (L)

1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I

Base

$0.00

FLSA

2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II

Base

$0.00

FLSA

3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III

Base

$0.00

FLSA

4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV

Base

$0.00

FLSA

Administrative Support (A)

5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I

Base

$0.00

FLSA

6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II

Base

$0.00

FLSA

7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III

Base

$0.00

FLSA

8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV

Base

$0.00

FLSA

Facilities Operations (F)

9) (F) Receiving Clerk/Facilities Ops Clerk I

Base

$0.00

FLSA

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

OY2

Labor Rates by Category, Period of Performance, and Location

Applicable Wage Determinations (latest Rev Date(s))

Option Year 2 (4/1/2025 - 3/31/2026)

ITEM # LABOR CATEGORY

Boston (Newton), MA

Pittsburgh, PA

Twin Cities, MN

Atlanta, GA

Knoxville, TN

Albuquerque, NM

Santa Fe, NM

Tulsa, OK

Sacramento, CA

San Francisco, CA

Portland, OR

Boise, ID

Salt Lake City, UT

Phoenix, AZ

Denver, CO

Billings, MT

Anchorage, AK

Washington, D.C.

Lenexa, KS

Contractor's Location

Weighted Average Labor Rate

Litigation Support (L)

1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I

Base

$0.00

FLSA

2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II

Base

$0.00

FLSA

3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III

Base

$0.00

FLSA

4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV

Base

$0.00

FLSA

Administrative Support (A)

5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I

Base

$0.00

FLSA

6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II

Base

$0.00

FLSA

7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III

Base

$0.00

FLSA

8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV

Base

$0.00

FLSA

Facilities Operations (F)

9) (F) Receiving Clerk/Facilities Ops Clerk I

Base

$0.00

FLSA

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

OY3

Labor Rates by Category, Period of Performance, and Location

Applicable Wage Determinations (latest Rev Date(s))

Option Year 3 (4/1/2026 - 3/31/2027)

ITEM # LABOR CATEGORY

Boston (Newton), MA

Pittsburgh, PA

Twin Cities, MN

Atlanta, GA

Knoxville, TN

Albuquerque, NM

Santa Fe, NM

Tulsa, OK

Sacramento, CA

San Francisco, CA

Portland, OR

Boise, ID

Salt Lake City, UT

Phoenix, AZ

Denver, CO

Billings, MT

Anchorage, AK

Washington, D.C.

Lenexa, KS

Contractor's Location

Weighted Average Labor Rate

Litigation Support (L)

1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I

Base

$0.00

FLSA

2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II

Base

$0.00

FLSA

3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III

Base

$0.00

FLSA

4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV

Base

$0.00

FLSA

Administrative Support (A)

5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I

Base

$0.00

FLSA

6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II

Base

$0.00

FLSA

7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III

Base

$0.00

FLSA

8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV

Base

$0.00

FLSA

Facilities Operations (F)

9) (F) Receiving Clerk/Facilities Ops Clerk I

Base

$0.00

FLSA

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

OY4

Labor Rates by Category, Period of Performance, and Location

Applicable Wage Determinations (latest Rev Date(s))

Option Year 4 (4/1/2027 - 3/31/2028)

ITEM # LABOR CATEGORY

Boston (Newton), MA

Pittsburgh, PA

Twin Cities, MN

Atlanta, GA

Knoxville, TN

Albuquerque, NM

Santa Fe, NM

Tulsa, OK

Sacramento, CA

San Francisco, CA

Portland, OR

Boise, ID

Salt Lake City, UT

Phoenix, AZ

Denver, CO

Billings, MT

Anchorage, AK

Washington, D.C.

Lenexa, KS

Contractor's Location

Weighted Average Labor Rate

Litigation Support (L)

1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I

Base

$0.00

FLSA

2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II

Base

$0.00

FLSA

3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III

Base

$0.00

FLSA

4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV

Base

$0.00

FLSA

Administrative Support (A)

5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I

Base

$0.00

FLSA

6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II

Base

$0.00

FLSA

7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III

Base

$0.00

FLSA

8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV

Base

$0.00

FLSA

Facilities Operations (F)

9) (F) Receiving Clerk/Facilities Ops Clerk I

Base

$0.00

FLSA

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

FAR 52.217-8

Labor Rates by Category, Period of Performance, and Location

Applicable Wage Determinations (latest Rev Date(s))

FAR 52.217-8 Extenstion (4/1/2028 - 9/30/2028)

ITEM # LABOR CATEGORY

Boston (Newton), MA

Pittsburgh, PA

Twin Cities, MN

Atlanta, GA

Knoxville, TN

Albuquerque, NM

Santa Fe, NM

Tulsa, OK

Sacramento, CA

San Francisco, CA

Portland, OR

Boise, ID

Salt Lake City, UT

Phoenix, AZ

Denver, CO

Billings, MT

Anchorage, AK

Washington, D.C.

Lenexa, KS

Contractor's Location

Weighted Average Labor Rate

Litigation Support (L)

1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I

Base

$0.00

FLSA

2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II

Base

$0.00

FLSA

3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III

Base

$0.00

FLSA

4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV

Base

$0.00

FLSA

Administrative Support (A)

5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I

Base

$0.00

FLSA

6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II

Base

$0.00

FLSA

7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III

Base

$0.00

FLSA

8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV

Base

$0.00

FLSA

Facilities Operations (F)

9) (F) Receiving Clerk/Facilities Ops Clerk I

Base

$0.00

FLSA

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

Price Evaluation Factor

ITEM #) LABOR CATEGORY	Base Year	Option Year 1	Option Year 2	Option Year 3	Option Year 4	FAR 52.217-8
1) (Lit Sup I) Resource Analyst / Paralegal Legal Assist I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2) (Lit Sup II) Resource Analyst / Paralegal Legal Assist II	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3) (Lit Sup III) Resource Analyst / Paralegal Legal Assist III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4) (Lit Sup IV) Resource Analyst / Paralegal Legal Assist IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
5) (AA/GC/S-I) Administrative Assistant / General Clerk / Secretary I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
6) (AA/GC/S-II) Administrative Assistant / General Clerk / Secretary II	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
7) (AA/GC/S-III) Administrative Assistant / General Clerk / Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
8) (AA/GC/S-IV) Administrative Assistant / General Clerk / Secretary IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
9) (F) Receiving Clerk/Facilities Ops Clerk I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Yearly Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL (Price Evaluation Factor)	$0.00

&"Times New Roman,Regular"&8Attachment 4 - Pricing Schedule &"Times New Roman,Regular"&8 140D0423R0001

&"Times New Roman,Regular"&8&A	&"Times New Roman,Regular"&8For Official Use Only
Source Selection Information - See FAR 2.101 and 3.104	&"Times New Roman,Regular"&8Page &P of &N

File details come from the government source that posted it. Updated Oct 11, 2022.