Attachment_D_EstimatedPersonnel_HourlyRate_v20220727.xlsx

XLSX spreadsheet 29 KB Posted Jul 27, 2022

Attached to: Data Entry, Imaging, Indexing, IT Support Services and Related Support Services Part for Enforcement Programs and Service and Strategic Intelligence and Information Directorates (EPS &OSII)
Solicitation number: DJA-21-ANTC-PR-0510
Issued by: Department of Justice Bureau of Alcohol Tobacco Firearms and Explosives

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains estimated personnel hours and hourly rates for various positions required to support five tasks for the Department of Justice Bureau of Alcohol Tobacco Firearms and Explosives. The five tasks include: National Tracing Center support; Firearms and Explosives Services Division support; Firearms and Ammunition Technology Division data entry, imaging and indexing support; Office of Strategic Intelligence and Information research assistance; and National Firearms Act Division support. The document outlines estimated hours and hourly rates by position for a base year and four option years. Key positions required include managers, supervisors, clerks, data entry operators, and research assistants. The total estimated hours and costs are provided for each task and year. The related federal contract opportunity is for data entry, imaging, indexing, IT support services and related services to support enforcement programs and services at the National Service Center in Martinsburg, WV for the Department of Justice Bureau of Alcohol Tobacco Firearms and Explosives.

View the file

Other files

File	Type	Posted
06062022_AllQuestions_15A00021R00000101_v20220824.docx	DOCX document	Aug 24, 2022
06062022_AllQuestions_15A00021R00000101_v20220822.docx	DOCX document	Aug 22, 2022
06062022_AllQuestions_15A00021R00000101_v20220808.docx	DOCX document	Aug 8, 2022
Attachment_F_Section_L_and_M_15A00021R00000101_v20220804.pdf	PDF	Aug 4, 2022
06062022_AllQuestions_15A00021R00000101_v20220804.docx	DOCX document	Aug 4, 2022
B.1.2_15A00021R00000101_0002_AmendmentTwo_v20220804.pdf	PDF	Aug 4, 2022
06062022_AllQuestions_15A00021R00000101_v20220725.docx	DOCX document	Jul 27, 2022
B.1.2_15A00021R00000101_0002_AmendmentTwo_v20220722.pdf	PDF	Jul 27, 2022
06062022_AllQuestions_15A00021R00000101_v20220725.docx	DOCX document	Jul 27, 2022
Attachment_F_Section_L_and_M_15A00021R00000101_v20220727.pdf	PDF	Jul 27, 2022
Attachment B_B.1.4_EPS_QASP_v20220727.docx	DOCX document	Jul 27, 2022
Attachment_A_EPS_OSII_PWS_v20220727.docx	DOCX document	Jul 27, 2022
B.1.2_15A00021R00000101_0001_AmendmentOne_v20220615.pdf	PDF	Jun 16, 2022
Attachment E Past and Present Performance Survey for EPS OSII.doc	DOC document	May 27, 2022
Attachment_A_EPS_OSII_PWS_v20220526.docx	DOCX document	May 27, 2022
B.1.2_15A00021R00000101_v20220527.pdf	PDF	May 27, 2022
Attachment_F_Section_L_and_M_15A00021R00000101_v20220526.pdf	PDF	May 27, 2022
Attachment C_WDOL_v20220527.pdf	PDF	May 27, 2022
Attachment B_B.1.4_EPS_QASP_v20220526.docx	DOCX document	May 27, 2022
Attachment_D_EstimatedPersonnel_HourlyRate_v20220419.xlsx	XLSX spreadsheet	May 27, 2022

Show all 20

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.

NTC cost break out Task One National Tracing Center (NTC)

			Base Period - 1/16/2023 to 1/15/2024			Option Period 1 - 1/16/24 to 1/15/2025			Option Period 2 - 1/16/2025 to 1/15/2026			Option Period 3 - 1/16/2026 to 1/15/2027			Option Period 4 - 1/16/2027 to 1/15/2028			All Periods
Personnel		Estimated Hours	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Esimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Esimated Quantity	Total Estimated Hours	Hourly Rate	Total Estimated Hours
Project Manager		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Deputy Project Manager		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Reports & Quality Supervisor		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Task Manager (Non-IT)		1,912		1,912			1,912			1,912			1,912			1,912		9,560
IT Manager		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Data Entry Operator II	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Document Preparation Clerk	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Doc Prep Clerk	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Duplicating Machine Operator	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Dupl Mach Operator	SCA	1,200		1,912			1,912			1,912			1,912			1,912		9,560
General Clerk I	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
General Clerk II	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
General Clerk III	SCA	1,200		1,912			1,912			1,912			1,912			1,912		9,560
Media Specialist I	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Personal Computer Support Tech	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Warehouse Specialist	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Photofinishing Worker	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Research Assistants I		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Research Assistants II		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Production Control Clerk	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Team Leads		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Supervisors		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Media Specialist II	SCA	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Senior IT Analyst		1,912		1,912			1,912			1,912			1,912			1,912		9,560
Base Year			- 0	42,064														42,064
Option Year One						- 0	42,064											42,064
Option Year Two									- 0	42,064								42,064
Option Year Three												- 0	42,064					42,064
Option Year Four															- 0	42,064		42,064
Total All Years																		210,320

FESD cost break out Task Two Firearms and Explosives Services Division (FESD)

		Base Period - 1/16/2023 to 1/15/2024			Option Period 1 - 1/16/2024 to 1/15/2025			Option Period 2 - 1/16/2025 to 1/15/2026			Option Period 3 - 1/16/2026 to 1/15/2027			Option Period 4 - 1/16/2027 to 1/15/2028			All Years
Personnel	Estimated Hours	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	Total Estimated Hours
Supervisor ( FT)	1,912		1,912			1,912			1,912			1,912			1,912		9,560
IT Manager ( F/T)	1,912		1,912			1,912			1,912			1,912			1,912		9,560
General Clerk III (F/T)	1,912		1,912			1,912			1,912			1,912			1,912		9,560
General Clerk II ( F/T)	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Data Entry Operator II (FT)	1,912		1,912			1,912			1,912			1,912			1,912		9,560
Overall Total Employee Count
Total Employees Count, Hours and Price Per Year
Base Year: CLIN		0	9,560														9,560
Option Year One: CLIN					0	9,560											9,560
Option Year Two: CLIN								0	9,560								9,560
Option Year Three: CLIN											0	9,560					9,560
Option Year Four: CLIN														0	9,560		9,560
Total All Years																	47,800

FATD cost break out ATF - Data Entry, Imaging, Indexing, IT Support Services and Related Support Services - BAFO

Task Four for Firearms and Ammunition Technology Division (FATD)
			Base Year			Option Year 1			Option Year 2			Option Year 3			Option Year 4			All Years
Personnel	Estimated Hours		FTE Esimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	Total Estimated Hours
Warehouse Specialist ( F/T)	1,912	SCA		1,912			1,912			1,912			1,912			1,912		9,560
Research Assistant I ( F/T)	1,912			1,912			1,912			1,912			1,912			1,912		9,560
Overall Total Employee Count
Total Employees Count, Hours and Price Per Year
Base Year: CLIN			0	3,824														3,824
Option Year One: CLIN						0	3,824											3,824
Option Year Two: CLIN									0	3,824								3,824
Option Year Three: CLIN												0	3,824					3,824
Option Year Four: CLIN															0	3,824		3,824
Total All Years																		19,120

OSII Cost break out

Task Four OSII (OID/CID)

Base Period - 1/16/2023 to 1/15/2024

Option Period 1 - 1/16/2024 to 1/15/2025

Option Period 2 - 1/16/2025 to 1/15/2026

Option Period 3 - 1/16/2026 to 1/15/2027

Option Period 4 - 1/16/2027 to 1/15/2028

All Years

Personnel

Estimated Hours

FTE Estimated Quantity

Total Estimated Hours

Hourly Rate

FTE Estimated Quantity

Total Estimated Hours

Hourly Rate

FTE Estimated Quantity

Total Estimated Hours

Hourly Rate

FTE Estimated Quantity

Total Estimated Hours

Hourly Rate

FTE Estimated Quantity

Total Estimated Hours

Hourly Rate

Total Estimated Hours

Research Assistant I

1,912

9,560

Base Year

1,912

Option Year One

1,912

Option Year Two

1,912

Option Year Three

1,912

Option Year Four

1,912

Total All Years

9,560

NFA cost break out Task 5 - National Firearms Act Division

			Base Period - 1/16/2023 to 1/15/2024			Option Period 1 - 1/16/24 to 1/15/2025			Option Period 2 - 1/16/2025 to 1/15/2026			Option Period 3 - 1/16/2026 to 1/15/2027			Option Period 4 - 1/16/2027 to 1/15/2028		All Periods
Personnel		Estimated Hours	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Esimated Quantity	Total Estimated Hours	Hourly Rate	FTE Estimated Quantity	Total Estimated Hours	Hourly Rate	FTE Esimated Quantity	Total Estimated Hours	Hourly Rate
Task Manager (Non-IT)		1,912		1,912			1,912			1,912			1,912			1,912	9,560
Supervisor (FT)		1,912		1,912			1,912			1,912			1,912			1,912	9,560
Supervisor (FT) - Night Shift		1,912		1,912			1,912			1,912			1,912			1,912	9,560
Research Assistant		1,912		1,912			1,912			1,912			1,912			1,912	9,560
Production Control Clerk	SCA	1,912		1,912			1,912			1,912			1,912			1,912	9,560
Team Lead		1,912		1,912			1,912			1,912			1,912			1,912	9,560
General Clerk III	SCA	1,912		1,912			1,912			1,912			1,912			1,912	9,560
General Clerk II	SCA	1,912		1,912			1,912			1,912			1,912			1,912	9,560
Data Entry Operator II	SCA	1,912		1,912			1,912			1,912			1,912			1,912	9,560
DEO Night Shift	SCA	1,200		1,912			1,912			1,912			1,912			1,912	9,560
Technical Writer III	SCA	1,912		1,912			1,912			1,912			1,912			1,912	9,560
Base Year			- 0	21,032													21,032
Option Year One						- 0	21,032										21,032
Option Year Two									- 0	21,032							21,032
Option Year Three												- 0	21,032				21,032
Option Year Four															- 0	21,032	21,032
Total All Years																	105,160

File details come from the government source that posted it. Updated Jul 27, 2022.