RFP_DJF-14-1200-R-0000034_Price_Template.xlsx

XLSX spreadsheet 63 KB Posted Jun 20, 2014

Attached to: FBI CODIS ACQUISITION SME AND ADMIN RFP
Solicitation number: DJF-14-1200-R-0000034
Issued by: Department of Justice Federal Bureau of Investigation Headquarters Division

About this file

From the source

Price Template

View the file

Other files

File	Type	Posted
CODIS_Acq_SME_Security_Requirements.pdf	PDF	Aug 5, 2014
CLIENT_AUTHORIZATION_LETTER_EXAMPLE.pdf	PDF	Aug 5, 2014
CODIS_SME_RFP_Amendment_2_7.9.14.pdf	PDF	Jul 9, 2014
Phase_1_Validation_Checklist_Amendment_1.doc	DOC document	Jul 1, 2014
CODIS_SME_RFP_Amendment_1_7.1.14.pdf	PDF	Jul 1, 2014
CODIS_Q A_Final.pdf	PDF	Jul 1, 2014
Schedule_Attachment.pdf	PDF	Jun 20, 2014
FBI_Security_Requirements_Attachment.docx	DOCX document	Jun 20, 2014
Attachment_J-3_OCI_Compliance.doc	DOC document	Jun 20, 2014
Phase_2_Validation_Checklist.docx	DOCX document	Jun 20, 2014
FBI_CODIS_Acquisition_SME_and_ADMIN_RFP_6.20.14.pdf	PDF	Jun 20, 2014
Phase_1_Validation_Checklist.doc	DOC document	Jun 20, 2014

Show all 12

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.

Instructions

Instructions:
1) Do not change any of the data within the green tabbed spreadsheets or the green fields within the gray tabbed spreadsheets.
2) Only complete the gray fields within the gray tabbed spreadsheets.
3) A description of the colums associated with the Labor (CLIN 1 and 5) tabs that will require completion by the vendors is provided in gray below. Those listed in green below are calculated automatically via formulas:
Company:	Name of the Prime or Sub-Contractor providing the labor
Labor Category:	Provide the Labor Cateogory being Proposed for this effort.
Alliant Hourly Rate:	List the Alliant approved Hourly Rate for the Labor Category proposed.
Proposed Hourly Rate:	List the Hourly Rate actually being proposed for this effort.
Discount Rate:	This field automatically calculates the discount rate provided to the Government by the offeror for each labor category and the average discount rate for all labor categories.
Hours:	Provide the number of hours per labor category proposed.
Base Labor:	This field automatically calculates the Discounted Hourly Rate multiplied by the Hours per labor category to provide an unburdened labor cost.
Overhead:	Provide the amount of overhead for each labor category (if necessary) within this field.
Facilities:	Provide the amount of facilities costs for each labor category (if necessary) within this field.
General and Administrative (G&A):	Provide the amount of G&A costs for each labor category (if necessary) within this field.
Sub-Total Cost:	This field automatically adds the Base Labor, Overhead, Facilities and G&A to provide a burdened labor cost.
Fee:	Provide the amount of Fee for each labor category (if necessary) within this field.
Total Cost:	This field automatically adds the Sub-Total Cost and Fee to provide a Total Cost of Labor.
Labor Discount:	This field automatically calculates the Labor Discount to the Government based on the Discount Rate provided by the offeror.
4) A description of the colums associated with the Hardware and Software (CLINS 2 and 3) tabs that will require completion by the vendors is provided in gray below. Those listed in green below are calculated automatically via formulas:
Item Price:	This is the price for a each (Qty = 1) item on the list.
Proposed Price:	This is the price being proposed for each (Qty = 1) item on the list.
Extended Item Price:	This field automatically calculates the Quantity multiplied by the Item Price.
Material Handling Charge (MHX):	Provide the amount of MHX costs for each item (if necessary) within this field.
General & Adminstrative (G&A) Expenses:	Provide the amount of G&A costs for each item (if necessary) within this field.
Sub-Total Item Cost:	This field automatically adds the Extended Cost + MHX + G&A.
Fee:	Provide the amount of Fee for each item (if necessary) within this field.
Total Item Cost:	This field automatically adds the Sub-Total Item Cost + Fee.
Quote Reference:	This field should provide the Basis of Estimate for the Item Price, such as a Website, Vendor Quote, etc. The offerors should also provide the Proposal page number in which the Quote is provided within this field.
Comment:	This field can be used to inform the government of any information needed, such as if an item is Not Separately Priced (NSP), if a price quote is good for three years, versus one, etc. If the item is NSP, the offeror should utilize this field to indicated which item # the price is included in.
5) All formulas should be included in the spreadsheets, such as the calculation of the MHX, G&A, and Fee.
6) If additional fields (columns or rows) are needed for other categories, such as additional overhead categories, additional labor categories, etc., feel fee to add them.
7) No changes should be made to the list of HW and SW within the CLIN 2 and CLIN 3 tabs, i.e., no rows should be added and no changes should be made to the order of the items.
8) For those proposing a Firm-Fixed Price Contract Type, please disregard fields related to a cost type contract, such as Overhead, G&A, Facilities, etc., within all the tabs.

Format 1

FORMAT 1: Total Price Proposal Summary
Total			Base Period	Option Period 1	Option Period 2	Option Period 3	Option Period 4	TOTAL
CLIN	CLIN Description	Contract Type	Total	Total	Total	Total	Total	Total
0001	Services	FFP	*	*	*	*	*	*
0002	Travel	T&M	**	**	**	**	**	**
Total			- 0	- 0	- 0	- 0	- 0	- 0
* From Format 2
** From Format 3

Format 2 FORMAT 2: CLIN (0001) Summary

FBI Site Labor (Prime)

Base Period

Option Period 1

Option Period 2

Option Period 3

Option Period 4

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Labor Category

Acquisition Subject Matter Expert

1980

Administrative Assistant

1980

….(insert rows as needed)

1980

Total Direct Labor

FBI Site Labor (Prime) Total Costs

Summary Base Period Option Period 1 Option Period 2 Option Period 3 Option Period 4

Total: Price

Format 3

	FORMAT 3: CLIN (0002) Summary
	Destination	Period of Performance
(POP)	Trips per POP	Employees per trip	Days per trip	Mileage*	Rental Car*	Hotel	M&IE	Total**
					Miles	Rate

Clarksburg, WV	Base Year	4	1	4
Clarksburg, WV	Option Year 1	4	1	4
Clarksburg, WV	Option Year 2	4	1	4
Clarksburg, WV	Option Year 3	4	1	4
Clarksburg, WV	Option Year 4	4	1	4
*Offerors are expected to use either the Mileage columns or the Rental Car column, but not both.
**Not To Exceed (NTE) $10,000 per POP.

Format 5 WBS Item # Manufacturer Description HW Model Name HW Model Number Support Level Qty List Price Proposed Price Discount Rate Extended Price MHX G&A Sub-Total Item Cost Fee Total Item Cost Quote Reference Comments HW Discount

Format 6 Item # Manufacturer Description SW Version Number SW Serial/License Number SW Part Number Support Level Qty List Price Proposed Price Discount Rate Extended Price MHX G&A Sub-Total Item Cost Fee Total Item Cost Quote Reference Comments SW Discount

Format 7 Item # Manufacturer Description SW Version Number SW Serial/License Number SW Part Number Support Level Qty List Price Proposed Price Discount Rate Extended Price MHX G&A Sub-Total Item Cost Fee Total Item Cost Quote Reference Comments SW Discount

Template

FORMAT 2: CLIN (x0002, x0004, x0005) Summary

Contractor Site Labor (Prime)

Base Period

Option Period 1

Option Period 2

Option Period 3

Option Period 4

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Labor Category

….(insert rows as needed)

Total Direct Labor

Fringe Rate:

Fringe Cost

Total Labor and Fringe

Overhead Rate:

Overhead Cost

Total Labor, Fringe, Overhead

Indirect Charge* (enter indirect charge name here)

Indirect Rate:

Indirect Cost

….(insert other charges as needed)

Total Indirect Costs

Contractor Site Labor (Prime) Total Costs

FBI Site Labor (Prime)

Base Period

Option Period 1

Option Period 2

Option Period 3

Option Period 4

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Labor Category

….(insert rows as needed)

Total Direct Labor

Fringe Rate:

Fringe Cost

Total Labor and Fringe

Overhead Rate:

Overhead Cost

Total Labor, Fringe, Overhead

Indirect Charge* (enter indirect charge name here)

Indirect Rate:

Indirect Cost

….(insert other charges as needed)

Total Indirect Costs

FBI Site Labor (Prime) Total Costs

Contractor Site Labor (Subcontractor)

Base Period

Option Period 1

Option Period 2

Option Period 3

Option Period 4

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Subcontractor A (enter company name here)

Labor Category

….(insert rows as needed)

Total Subcontractor A

Subcontractor B (enter company name here)

Labor Category

….(insert rows as needed)

Total Subcontractor B

….(insert other subcontractors as needed)

Total Direct Labor

Indirect Charge* (enter indirect charge name here)

Indirect Rate:

Indirect Cost

….(insert other charges as needed)

Total Indirect Costs

Contractor Site Labor (Subcontractor) Total Costs

FBI Site Labor (Subcontractor)

Base Period

Option Period 1

Option Period 2

Option Period 3

Option Period 4

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Hours

Rate

Total

Subcontractor A (enter company name here)

Labor Category

….(insert rows as needed)

Total Subcontractor A

Subcontractor B (enter company name here)

Labor Category

….(insert rows as needed)

Total Subcontractor B

….(insert other subcontractors as needed)

Total Direct Labor

Indirect Charge* (enter indirect charge name here)

Indirect Rate:

Indirect Cost

….(insert other charges as needed)

Total Indirect Costs

FBI Site Labor (Subcontractor) Total Costs

Non-Labor Direct Costs	Base Period	Option Period 1	Option Period 2	Option Period 3	Option Period 4
Direct Materials**
Indirect Charge* (enter indirect charge name here)
Indirect Rate:
Indirect Cost
….(insert other charges as needed)
Total Indirect Costs
Total Direct Materials
Other Direct Costs
Postal/Shipping Expenses
Facilities
Travel
Training
Consulting Services
….(insert rows as needed)
Total Other Direct Costs
Indirect Charge* (enter indirect charge name here)
Indirect Rate:
Indirect Cost
….(insert other charges as needed)
Total Indirect Costs
Non-Labor Direct Total Costs

Summary	Base Period	Option Period 1	Option Period 2	Option Period 3	Option Period 4
Contractor Site Labor (Prime) Total Costs
FBI Site Labor (Prime) Total Costs
Contractor Site Labor (Subcontractor) Total Costs
FBI Site Labor (Subcontractor) Total Costs
Non-Labor Direct Total Costs

SubTotal

G&A Rate:

G&A Cost

SubTotal

FCCOM Rate:

FCCOM Cost

Total Costs

Profit Rate:***

Profit

Total: Price

Base Fee Rate:	N/A	N/A	N/A	N/A	N/A
Base Fee
Award Fee Rate:
Award Fee
Total Fee

Total: Cost Plus Fee

* Includes charges such as material handling. Excludes G&A.

** Excludes the procurement of significant hardware, software, hardware maintenance, and software maintenance items (which are included in CLINs x0004, x0005, x0006, and x0007).

*** If the proposal does not apply the same profit rate across all cost elements, please detail what rates are applied to each cost element.

Item # Manufacturer Description HW Model Name HW Model Number Support Level Qty List Price Proposed Price Discount Rate Extended Price MHX G&A Sub-Total Item Cost Fee Total Item Cost Quote Reference Comments HW Discount

Item # Manufacturer Description SW Version Number SW Serial/License Number SW Part Number Support Level Qty List Price Proposed Price Discount Rate Extended Price MHX G&A Sub-Total Item Cost Fee Total Item Cost Quote Reference Comments SW Discount

File details come from the government source that posted it. Updated Nov 14, 2017.