Attachment B Seed Task Order Pricing (1-3) Attachments D F and H) (1).xlsx

XLSX spreadsheet 46 KB Posted Jun 11, 2020

Attached to: IMT Enterprise Support Solutions IDIQ Federal contract opportunity
Solicitation number: 140R8120R0005
Issued by: Department of the Interior Bureau of Reclamation

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains pricing templates and instructions for responding to solicitation number 140R8120R0005 for an IMT Enterprise Support Solutions IDIQ issued by the Department of the Interior Bureau of Reclamation. Offerors are instructed to provide fully-burdened labor rates for 68 base labor categories as well as any proposed supplemental categories for a 5-year IDIQ period of performance from October 2020 to September 2025. Pricing templates are also included for three sample task orders requiring help desk support, database administration, and application development services to be performed from October 2020 to September 2021. Offerors are to complete the templates by filling in labor hours, rates, and other direct and travel costs for the sample task orders, with the understanding that the labor hours must equal the total hours originally assigned across all categories.

View the file

Other files for this federal contract opportunity

Other files attached to IMT Enterprise Support Solutions IDIQ, newest first.
File	Type	Posted
Missed Questions with Answers_0007.pdf	PDF	Aug 5, 2020
Attachemnt G Seed Task Order Three PWS_0007.pdf	PDF	Aug 5, 2020
Attachment C Seed Task Order One PWS_0007.pdf	PDF	Aug 5, 2020
Attachment E Seed Task Order Two PWS_0007.pdf	PDF	Aug 5, 2020
Sol_140R8120R0005_Amd_0007.pdf	PDF	Aug 5, 2020
Attachment I Past Performance Questionnaire - Updated 08.04.2020_0007.docx	DOCX document	Aug 5, 2020
140R8120R0005 Solicitation_0007.pdf	PDF	Aug 5, 2020
Attachment A IDIQ PWS_0007.pdf	PDF	Aug 5, 2020
Sol_140R8120R0005_Amd_0006.pdf	PDF	Jul 31, 2020
Attachment J Labor Descriptions_0006.xlsx	XLSX spreadsheet	Jul 31, 2020
140R8120R0005 Solicitation_0006.pdf	PDF	Jul 31, 2020
Attachment I Past Performance Questionnaire_0006.docx	DOCX document	Jul 31, 2020
140R8120R0005 Solicitation_0001.pdf	PDF	Jun 12, 2020
Sol_140R8120R0005_Amd_0001.pdf	PDF	Jun 12, 2020
Attachment I Past Performance Questionnaire.docx	DOCX document	Jun 11, 2020
Sol_140R8120R0005.pdf	PDF	Jun 11, 2020
Attachment A IDIQ PWS.pdf	PDF	Jun 11, 2020
Attachment J Labor Descriptions.xlsx	XLSX spreadsheet	Jun 11, 2020
Attachment C Seed Task Order One PWS.pdf	PDF	Jun 11, 2020
Attachment E Seed Task Order Two PWS.pdf	PDF	Jun 11, 2020
Attachemnt G Seed Task Order Three PWS.pdf	PDF	Jun 11, 2020

Show all 21

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.

START HERE

Fill in Your Company Name in the Start Here Tab		140R8120R0005
		IMT Enterprise Support Solutions IDIQ
		Instructions for Pricing Attachments
	Instructions for Completing the Pricing Attachments
1. Enter your company name in the yellow-highlighted cell A1 of this spreadsheet. This cell will auto-populate similar cells in the
other tabs.

2. Fill in fully-burdened labor rates in Attachment B for all labor categories, for all years. See notes at the end of the schedule,

immediately below CLIN 0068, pertaining to the proposal of supplemental labor categories.

3. The fully-burdened labor rates you provide in Attachment B will automatically populate in the three seed task orders for the

designated labor categories to arrive at a total price for labor for each seed task order.

4. If you choose to propose supplemental labor categories for any of the requirements for any of the three seed task orders, the

total number of hours must equal the total hours originally assigned to the designated labor categories. For example,

proposed labor hours for Attachment D pricing are (13 FTEs x 2,080 hours) = 27,040 hours. Therefore, if you choose to

substitute some of the designated labor categories with your supplemental labor categories, the total of all labor hours should

equal 27,040. You will have to input your own hours and labor rates for the supplemental labor categories.

5. For Attachment D, Attachment F, and Attachment H, fill in amounts in the yellow-highlighted cells for Other Direct Costs and

Travel, as applicable.

6. As each tab is populated, the tab for the GRAND TOTAL will auto-populate.

7. When completed, save this file using this naming convention: 140R8120R0005_Pricing_YourCompamyName

8. If you encounter any problems with this spreadsheet, please contact the contracting officer immediately.

Attach B Binding Rates

Offeror Name:	Fill in Your Company Name in the Start Here Tab		140R8120R0005
Requirement Title:	IT Enterprise Contract Services	IMT Enterprise Support Solutions (IDIQ)
Period of Performance:	10/1/2020 - 9/30/2025		Attachment B Pricing

	Offerors must complete entire Price Schedule for all labor categories for all years to be considered for award		Year 1
October 01, 2020 - September 30, 2021		Year 2
October 01, 2021 - September 30, 2022		Year 3
October 01, 2022 - September 30, 2023		Year 4
October 01, 2023 - September 30, 2024		Year 5

October 01, 2024 - September 30, 2025

CLIN	Labor Category	Fully-Burdened Rate	Fully-Burdened Rate	Fully-Burdened Rate	Fully-Burdened Rate	Fully-Burdened Rate
0001	Application Developer 1		$ - 0	$ - 0	$ - 0	$ - 0
0002	Application Developer 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0003	Application Developer 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004	Application Developer 4	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0005	Audio/Video Specialist Jr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0006	Audio/Video Specialist Sr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0007	Business Analyst Jr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0008	Business Analyst Sr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0009	Business Subject Matter Specialist	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0010	Cloud Architect	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0011	Cloud Computing Specialist Jr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0012	Cloud Computing Specialist Sr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0013	Cloud Security Specialist Jr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0014	Cloud Security Specialist Sr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0015	Cloud System Engineer	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0016	Configuration Management Specialist 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0017	Configuration Management Specialist 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0018	Configuration Management Specialist 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0019	Data Analyst 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0020	Data Analyst 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0021	Data Analyst 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0022	Database Administrator 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0023	Database Administrator 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0024	Database Administrator 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0025	Data Center Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0026	Data Security Specialist 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0027	Data Security Specialist 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0028	Data Security Specialist 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0029	Functional Subject Matter Expert 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0030	Functional Subject Matter Expert 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0031	Helpdesk Technician 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0032	Helpdesk Specialist 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0033	Helpdesk Manager\Lead	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0034	Information Assurance Engineer	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0035	Information Services Consultant	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0036	Network Administrator 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0037	Network Administrator 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0038	Network Administrator 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0039	Network Engineer 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0040	Network Engineer 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0041	Network Engineer 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0042	Program Analyst Jr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0043	Program Analyst Sr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0044	Program Manager 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0045	Program Manager 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0046	Program Manager 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0047	Project Manager 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0048	Project Manager 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0049	SharePoint Administrator	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0050	Software Architect	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0051	Systems Administrator 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0052	Systems Administrator 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0053	Systems Administrator 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0054	Systems Administrator 4	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0055	Systems Engineer 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0056	Systems Engineer 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0057	Systems Engineer 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0058	Technical Writer 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0059	Technical Writer 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0060	Telecommunications Specialist 1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0061	Telecommunications Specialist 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0062	Telecommunications Specialist 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0063	Test Engineer	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0064	Testing Specialist Jr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0065	Testing Specialist Sr	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0066	Training Specialist	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0067	Web Developer 2	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0068	Web Developer 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

	Notes:
	1. Offerors may propose "supplemental labor categories" below in the event they have labor categories in addition to those identified in CLINs 0001 through 0068. Offerors are cautioned that use of any Supplementary Labor Categories when responding to a task order are subject to the same technical approval in terms of assessing the appropriate level of effort (kinds, quantity and skill mix of labor) to perform a task.
	2. Proposing additional labor categories is viewed as neither favorable nor unfavorable in terms of overall evaluation. Labor rates will be evaluated for price reasonableness and any instances of unbalancing.
	Supplemental Labor Categories Proposed by Offeror		Year 1
October 01, 2020 - September 30, 2021		Year 2
October 01, 2021 - September 30, 2022		Year 3
October 01, 2022 - September 30, 2023		Year 4
October 01, 2023 - September 30, 2024		Year 5

October 01, 2024 - September 30, 2025

Labor Category	Fully-Burdened Rate	Fully-Burdened Rate	Fully-Burdened Rate	Fully-Burdened Rate	Fully-Burdened Rate
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in if applicable; add/delete rows as necessary	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Attach D Pricing

Offeror Name	Fill in Your Company Name in the Start Here Tab				140R8120R0005
Period of Performance	10/1/2020 - 9/30/2021				IMT Enterprise Support Solutions IDIQ
					Attachment D Seed Task Order One
					Page 1 of 1
CLIN	Labor Category	Quantity	Hours	Fully-Burdened Rate	Total
0031	Helpdesk Technician 1	4	2,080	$0.00	$0.00
0032	Helpdesk Specialist 2	6	2,080	$0.00	$0.00
0033	Helpdesk Manager\Lead	1	2,080	$0.00	$0.00
0052	Systems Administrator 2	2	2,080	$0.00	$0.00

Supplemental Labor Categories (if none, leave rows blank)
	$0.00
	$0.00
	$0.00
	$0.00
	$0.00

Labor Total	$0.00
Other Direct Costs	$0.00
Travel	$0.00
Grand Total	$0.00

Attach F Pricing

Offeror Name	Fill in Your Company Name in the Start Here Tab				140R8120R0005
Period of Performance	10/1/2020 - 9/30/2021				IMT Enterprise Support Solutions IDIQ
					Attachment F Seed Task Order Two
					Page 1 of 1
CLIN	Labor Category	Quantity	Hours	Fully-Burdened Rate	Total
0023	Database Administrator 2	2	2,080	$0.00	$0.00
0024	Database Administrator 3	1	2,080	$0.00	$0.00
0028	Data Security Specialist 3	1	2,080	$0.00	$0.00
0047	Project Manager 2	1	2,080	$0.00	$0.00
0049	SharePoint Administrator	2	2,080	$0.00	$0.00
0053	Systems Administrator 3	2	2,080	$0.00	$0.00
0054	Systems Administrator 4	1	2,080	$0.00	$0.00
0056	Systems Engineer 2	3	2,080	$0.00	$0.00

Supplemental Labor Categories (if none, leave rows blank)
	$0.00
	$0.00
	$0.00
	$0.00
	$0.00

Labor Total	$0.00
Other Direct Costs	$0.00
Travel	$0.00
Grand Total	$0.00

Attach H Pricing

Offeror Name	Fill in Your Company Name in the Start Here Tab				140R8120R0005
Period of Performance	10/1/2020 - 9/30/2021				IMT Enterprise Support Solutions IDIQ
					Attachment H Seed Task Order Three
					Page 1 of 1
CLIN	Labor Category	Quantity	Hours	Fully-Burdened Rate	Total
0002	Application Developer 2	7	2,080	$0.00	$0.00
0003	Application Developer 3	5	2,080	$0.00	$0.00
0023	Database Adminstrator 2	2	2,080	$0.00	$0.00
0024	Database Adminstrator 3	1	2,080	$0.00	$0.00
0052	Systems Administrator 2	1	2,080	$0.00	$0.00
0065	Testing Specialist Sr	2	2,080	$0.00	$0.00

Supplemental Labor Categories (if none, leave rows blank)
	$0.00
	$0.00
	$0.00
	$0.00
	$0.00

Labor Total	$0.00
Other Direct Costs	$0.00
Travel	$0.00
Grand Total	$0.00

GRAND TOTAL

Offeror Name	Fill in Your Company Name in the Start Here Tab				140R8120R0005
Period of Performance	10/1/2020 - 9/30/2021				IMT Enterprise Support Solutions IDIQ
					GRAND TOTAL PRICING ALL SEED ORDERS
					Page 1 of 1
		Attachment D Pricing	Attachment F Pricing	Attachment H Pricing	Total All Orders
Labor		$0.00	$0.00	$0.00	$0.00
Other Direct Costs		$0.00	$0.00	$0.00	$0.00
Travel		$0.00	$0.00	$0.00	$0.00
Total		$0.00	$0.00	$0.00	$0.00

cksum	$0.00	$0.00	$0.00	$0.00
		This sheet completely self-calculates. There are no input cells.

ESRI_MAPINFO_SHEET

DO NOT EDIT

For Esri use only

File details come from the government source that posted it. Updated Jun 11, 2020.