Attachment_D_EstimatedPersonnel_HourlyRate_v20220419.xlsx
XLSX spreadsheet 59 KB Posted
- Solicitation number
- DJA-21-ANTC-PR-0510
About this file
This document contains an Excel spreadsheet with estimated personnel hours and rates to support various tasks for the Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF). The spreadsheet includes estimates for the National Tracing Center, Firearms and Explosives Services Division, Firearms and Ammunition Technology Division, and National Firearms Act Division across a base year and four option years.
For the National Tracing Center, estimated hours and FTEs are provided for positions including data entry operators, document preparation clerks, duplicating machine operators, general clerks, research assistants, production control clerks, team leads, supervisors, and IT managers. For the Firearms and Explosives Services Division, Firearms and Ammunition Technology Division, and National Firearms Act Division, estimated hours are also provided for positions like general clerks, data entry operators, warehouse specialists, and research assistants. The spreadsheet calculates total estimated hours and associated costs for each task and year.
View the file
Other files
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
Text version
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 | Shift | Estimated Hours | FTE Estimated Quantity | Total Estimated Hours* | Hourly Rate | FTE Estimated Quantity | Total Estimated Hours | FTE Esimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Esimated Quantity | Total Estimated Hours | Total Estimated Hours | |
| Project Manager | Day | 1,912 | 1,912 | 1,912 | 3,824 | ||||||||||
| Deputy Project Manager | Day | 1,912 | 1,912 | 1,912 | 3,824 | ||||||||||
| Reports & Quality Supervisor | Day | 1,912 | 1,912 | 1,912 | 3,824 | ||||||||||
| Task Manager (Non-IT) | Day | 1,912 | 3,840 | 3,840 | 7,680 | ||||||||||
| IT Manager | Day | 1,912 | - 0 | - 0 | - 0 | ||||||||||
| Data Entry Operator II | Day | SCA | 1,912 | 28,800 | 28,800 | 57,600 | |||||||||
| Data Entry Operator II | Night | SCA | 720 | 2,880 | 2,880 | 5,760 | |||||||||
| Data Entry Operator II - 5% Shift Premium Hrs | Night | SCA | 1,200 | 4,800 | 4,800 | 9,600 | |||||||||
| Document Preparation Clerk | Day | SCA | 1,912 | 19,200 | 19,200 | 38,400 | |||||||||
| Document Preparation Clerk | Night | SCA | 720 | 4,320 | 4,320 | 8,640 | |||||||||
| Doc Prep Clerk - 5% Shift Premium Hours | Night | SCA | 1,200 | 7,200 | 7,200 | 14,400 | |||||||||
| Duplicating Machine Operator | Day | SCA | 1,912 | 11,520 | 11,520 | 23,040 | |||||||||
| Duplicating Machine Operator | Night | SCA | 720 | 4,320 | 4,320 | 8,640 | |||||||||
| Dupl Mach Operator - 5% Shift Premium Hrs. | Night | SCA | 1,200 | 7,200 | 7,200 | 14,400 | |||||||||
| General Clerk I | Day | SCA | 1,912 | 1,912 | 1,912 | 3,824 | |||||||||
| General Clerk I | Night | SCA | 720 | 720 | 720 | 1,440 | |||||||||
| General Clerk 1 - 5% Shift Premium Hours | Night | SCA | 1,200 | 1,200 | 1,200 | 2,400 | |||||||||
| General Clerk II | Day | SCA | 1,912 | 11,520 | 11,520 | 23,040 | |||||||||
| General Clerk II | Night | SCA | 720 | 4,320 | 4,320 | 8,640 | |||||||||
| General Clerk II - 5% Shift Premium Hours | Night | SCA | 1,200 | 7,200 | 7,200 | 14,400 | |||||||||
| General Clerk III | Day | SCA | 1,912 | 186,922 | 186,585 | 373,507 | |||||||||
| General Clerk III | Night | SCA | 720 | 36,000 | 36,000 | 72,000 | |||||||||
| General Clerk III - 5% Shift Premium Hours | Night | SCA | 1,200 | 60,000 | 60,000 | 120,000 | |||||||||
| Media Specialist I | Day | SCA | 1,912 | - 0 | - 0 | - 0 | |||||||||
| Personal Computer Support Tech | Day | SCA | 1,912 | 1,912 | 1,912 | 3,824 | |||||||||
| Warehouse Specialist | Day | SCA | 1,912 | 7,680 | 7,680 | 15,360 | |||||||||
| Photofinishing Worker | Day | SCA | 1,912 | - 0 | - 0 | - 0 | |||||||||
| Research Assistants I | Day | 1,912 | 107,520 | 107,520 | 215,040 | ||||||||||
| Research Assistants II | Day | 1,912 | 107,520 | 107,520 | 215,040 | ||||||||||
| Research Assistants II | Night | 720 | 12,240 | 12,240 | 24,480 | ||||||||||
| Research Assistants II - 5 % Shift Premium Hrs. | Night | 1,200 | 20,400 | 20,400 | 40,800 | ||||||||||
| Production Control Clerk | Day | SCA | 1,912 | 1,912 | 1,912 | 3,824 | |||||||||
| Team Leads | Day | 1,912 | 7,680 | 7,680 | 15,360 | ||||||||||
| Team Leads | Night | 720 | 2,880 | 2,880 | 5,760 | ||||||||||
| Team Leads - 5% Shift Premium Hours | Night | 1,200 | 4,800 | 4,800 | 9,600 | ||||||||||
| Supervisors | Day | 1,912 | 9,600 | 9,600 | 19,200 | ||||||||||
| Supervisors | Night | 720 | 1,440 | 1,440 | 2,880 | ||||||||||
| Supervisors - 5% Shift Premium Hours | Night | 1,200 | 2,400 | 2,400 | 4,800 | ||||||||||
| Night Shift Supervisor | Night | 1,912 | 1,912 | 1,912 | 3,824 | ||||||||||
| Media Specialist II | Day | SCA | 1,912 | 3,840 | 3,840 | 7,680 | |||||||||
| Senior IT Analyst | Day | 1,912 | 5,760 | 5,760 | 11,520 | ||||||||||
| Overall Total Employee Count | |||||||||||||||
| Total Employees Count, Hours and Price Per Year | |||||||||||||||
| Base Year | - 0 | 0 | - 0 | ||||||||||||
| Option Year One | - 0 | 0 | - 0 | ||||||||||||
| Option Year Two | - 0 | 0 | - 0 | ||||||||||||
| Option Year Three | - 0 | 705,282 | 705,282 | ||||||||||||
| Option Year Four | - 0 | 704,945 | 704,945 | ||||||||||||
| Total All Years | 1,410,227 |
FESD cost break out ATF - Data Entry, Imaging, Indexing, IT Support Services and Related Support Services - BAFO tc={B22F676C-8CBC-475F-9F56-F5365FA3357E}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Remove this refers to a Best and Final Offer
| Task Two for Firearms and Explosives Services Division (FESD) | |||||||||||||||
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | All Years | ||||||||||
| Personnel | FTE Quantity | Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | Hourly Rate | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | Total Estimated Hours | |
| Supervisor (1 FT) | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| IT Manager (1 F/T) | 1,912 | - 0 | |||||||||||||
| General Clerk III (1 F/T) | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||
| General Clerk II (7 F/T) | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| Data Entry Operator II (20 FT) | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||
| Overall Total Employee Count | 0 | ||||||||||||||
| Total Employees Count, Hours and Price Per Year | |||||||||||||||
| Base Year: CLIN | 0 | 0 | - 0 | ||||||||||||
| Option Year One: CLIN | 0 | 0 | - 0 | ||||||||||||
| Option Year Two: CLIN | 0 | 0 | - 0 | ||||||||||||
| Option Year Three: CLIN | 0 | 0 | - 0 | ||||||||||||
| Option Year Four: CLIN | 0 | 0 | - 0 | ||||||||||||
| Total All Years | - 0 |
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) tc={090D1BBE-7BC0-4477-AA25-7CE4A5D9F588}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Should be Task Three?
| 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 | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | Total Estimated Hours | |
| Warehouse Specialist ( F/T) | 1,912 | SCA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| Research Assistant I ( F/T) | 1,912 | |||||||||||||
| Overall Total Employee Count | ||||||||||||||
| Total Employees Count, Hours and Price Per Year | ||||||||||||||
| Base Year: CLIN | 0 | 0 | - 0 | |||||||||||
| Option Year One: CLIN | 0 | 0 | - 0 | |||||||||||
| Option Year Two: CLIN | 0 | 0 | - 0 | |||||||||||
| Option Year Three: CLIN | 0 | 0 | - 0 | |||||||||||
| Option Year Four: CLIN | 0 | 0 | - 0 | |||||||||||
| Total All Years | - 0 |
OSII Cost break out tc={9AD48A23-3165-4E43-B94D-9808184F6537}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Suggest re-formatting to be consistent with prior tasks OID/CID Cost Analysis for Contract Support during Years 2022 - 2026 tc={BCE696D9-49BA-4B84-A3FE-9D66B07CA079}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
CID and OID?
| Labor Category | Estimated Hours | Base Year | Hourly Rate | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||
| Personnel | Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | ||
| Research Assistant | 1,912 | 1,912 | - 0 | - 0 | - 0 |
NFA cost break out National Firearms Act Division - ATF - Data Entry, Imaging, Indexing, IT Support Services and Related Support Services tc={6F52FD56-7A26-4B72-A71E-5A41B256ADDE}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Remove this and replace with Task 5 NFA like first few tasks Base Plus 4 Option Years
| NFA (Task 5) Estimate | Base Year | Hourly Rate | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | |||||||
| Personnel | Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | FTE Estimed Quantity | Total Estimated Hours | FTE Estimated Quantity | Total Estimated Hours | ||
| Task Manager (Non-IT) | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||
| Supervisor (FT) | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||
| Supervisor (FT) - Night Shift | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||
| Research Assistant | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||
| Production Control Clerk | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| Team Lead | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||
| General Clerk III | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| General Clerk II | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| Data Entry Operator II | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| DEO Night Shift | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| Technical Writer III | SCA | 1,912 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
| Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
| Estimated Cost of Living Increase |
File details come from the government source that posted it. Updated .