Atch 4 - DRAFT_EADE Pricing Template.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
Enterprise Architecture, Data, and Engineering (EADE) Recompete supporting USTRANSCOM, SDDC, and AMC Federal contract opportunity
Solicitation number
HTC71125RD002
Issued by
Department of Defense United States Transportation Command

About this file

This document is a draft pricing template attachment for the Enterprise Architecture, Data, and Engineering (EADE) federal contract opportunity. The template includes detailed labor categories and descriptions, as well as instructions for offerors to provide proposed fully burdened labor rates for both government and contractor site locations over a 5-year period with potential option years. The labor categories cover a range of technical and management roles required to support the EADE scope, including enterprise architects, data architects, systems engineers, program managers, and subject matter experts. Offerors are required to provide escalation rates for each year of the contract. The EADE contract opportunity is a single-award IDIQ with firm fixed price and labor hour task orders, with a 5-year ordering period anticipated to begin around October 2025. The procurement will be a 100% small business set-aside under NAICS 541512.

View the file

Other files for this federal contract opportunity

Other files attached to Enterprise Architecture, Data, and Engineering (EADE) Recompete supporting USTRANSCOM, SDDC, and AMC, newest first.
File Type Posted
2024.10.24 Government Responses_SAM.xlsx XLSX spreadsheet
Atch 6 - DRAFT_Table of Contents (Bidders Library).docx DOCX document
Atch 1 - DRAFT_ 2024.09.19 PWS.docx DOCX document
Atch 10 - DRAFT_Past Performance Information Sheet.docx DOCX document
DRAFT_FAR 52.212-1 Instructions to Offerors.docx DOCX document
Atch 3 - DRAFT_DD 254 SCI Addendum_Solicitation.pdf PDF
Atch 5 - DRAFT_NDA (Bidders Library).docx DOCX document
DRAFT_FAR 52.212-2 Evaluation.docx DOCX document
Industry Comment Matrix_Draft Solicitation.xlsx XLSX spreadsheet
Atch 12 - DRAFT_Past Performance Questionnaire.docx DOCX document
Atch 11 - DRAFT_Past Performance Reference Sheet.docx DOCX document
Show all 11

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

Text version

Instructions

Attachment 4
COMPLETE THE FOLLOWING:
Solicitation TitleEnterprise Architecture, Data, and Engineering (EADE)
Solicitation NumberHTC71125RD002
Offeror Name
Cage Code
Unique Entity Identifier (UEI)
Date
The Offeror is responsible to ensure compliance with federal regulations and provide the necessary data as required by the Request for Proposal.
Each tab has specific completion instructions for that tab. Offerors shall adhere to those instructions on each tab. Failure to adhere to the instructions may render an offeror's proposal ineligible for award.

Offeror shall complete the Government issued attachment as instructed:

1) Fill in the offeror's information in the table above.

2) Complete each tab as applicable.

3) The spreadsheet shall include all formulas. Note, that it is the offeror's responsibility to ensure the calculations are correct for the Cost Labor Rate Tabs.

LCAT Descriptions

Job Title/Labor CategorySkill LevelJob DescriptionPreferred Education/Experience
Administration/ClericalSeniorAdministration/Clerical (a) Responsible for developing, drafting, writing and editing reports, briefs, proposals, and other documents in support of a client's requirements. (b) Interfaces with personnel to coordinate meetings, maintain logs, records and files, provides end-user support, and performs general administrative duties. (c) Assists in budgetary, billing, and financial management. (d) Responsible for preparing and/or maintaining systems, programming and operations documentation, procedures and methods, including user reference manuals. Knowledge/Skill Description Possesses and applies a comprehensive knowledge across key tasks and high impact assignments. Plans and leads major technology assignments. Evaluates performance results and recommends major changes affecting short-term project growth and success. Functions as a technical expert across multiple project assignments. May supervise others.Bachelor's Degree and 3-5
Applications ProgrammerSeniorApplication Programmer (a) Formulates/defines system scope and objectives.
(b) Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. (c) Prepares detailed specifications from which programs will be written and designs, codes, tests, debugs, and documents those programs.Bachelor's Degree and 3-5
Applications ProgrammerSubject Matter ExpertApplication Programmer (a) Formulates/defines system scope and objectives.
(b) Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. (c) Prepares detailed specifications from which programs will be written and designs, codes, tests, debugs, and documents those programs.Master's Degree and 5-9
Applications Systems AnalystSeniorApplications Systems Analyst (a) Formulates/defines system scope and objectives. (b) Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. (c) Prepares detailed specifications for programs. Assists in the design, development, testing, implementation, and documentation of new software and enhancements of existing applications. (d) Works with project managers, developers, and end users to ensure application designs meet business requirements. (e) Formulates/defines specifications for complex operating software programming applications or modifies/maintains complex existing applications using engineering releases and utilities from the manufacturer. (f) Designs, codes, tests, debugs, and documents those programs. (g) Provides overall operating system, such as sophisticated file maintenance routines, large telecommunications networks, computer accounting, and advanced mathematical/scientific software packages. (h) Assists all phases of software systems programming applications. (i) Evaluates new and existing software products. Knowledge/Skill Description Possesses and applies a comprehensive knowledge across key tasks and high impact assignments. Plans and leads major technology assignments. Evaluates performance results and recommends major changes affecting short-term project growth and success. Functions as a technical expert across multiple project assignments. May supervise othersBachelor's Degree and 3-5
Configuration Management SpecialistJourneymanConfiguration Management Specialist (a) Provides configuration management planning. (b) Describes provisions for configuration identification, change control, configuration status accounting, and configuration audits. (c) Regulates the change process so that only approved and validated changes are incorporated into product documents and related software. Knowledge/Skill Description Possesses and applies expertise on multiple complex work assignments. Assignments may be broad in nature, requiring originality and innovation in determining how to accomplish tasks. Operates with appreciable latitude in developing methodology and presenting solutions to problems. Contributes to deliverables and performance metrics where applicable.Associate's Degree and 2-4
Configuration Management SpecialistSeniorConfiguration Management Specialist (a) Provides configuration management planning. (b) Describes provisions for configuration identification, change control, configuration status accounting, and configuration audits. (c) Regulates the change process so that only approved and validated changes are incorporated into product documents and related software. Knowledge/Skill Description Possesses and applies a comprehensive knowledge across key tasks and high impact assignments. Plans and leads major technology assignments. Evaluates performance results and recommends major changes affecting short-term project growth and success. Functions as a technical expert across multiple project assignments. May supervise others.Bachelor's Degree and 3-5
Data ArchitectSeniorData Architect (a) Designs and builds relational databases. Performs data access analysis design, and archive/recovery design and implementation. (b) Develops strategies for data acquisitions, archive recovery, and implementation of a database. (c) Works in a data warehouse environment, which includes data design, database architecture, and metadata repository creation. (d) Translates business needs into long-term architecture solutions. (e) Defines, designs, and builds dimensional databases. (f) Develops data warehousing blueprints, evaluating hardware and software platforms, and integrating systems. (g) Reviews and develops object and data models and the metadata repository to structure the data for better management and quicker access.Bachelor's Degree and 3-5
Data ArchitectSeniorData Architect (a) Designs and builds relational databases. Performs data access analysis design, and archive/recovery design and implementation. (b) Develops strategies for data acquisitions, archive recovery, and implementation of a database. (c) Works in a data warehouse environment, which includes data design, database architecture, and metadata repository creation. (d) Translates business needs into long-term architecture solutions. (e) Defines, designs, and builds dimensional databases. (f) Develops data warehousing blueprints, evaluating hardware and software platforms, and integrating systems. (g) Reviews and develops object and data models and the metadata repository to structure the data for better management and quicker access.Bachelor's Degree and 3-5
Data Architect
Subject Matter ExpertData Architect (a) Designs and builds relational databases. Performs data access analysis design, and archive/recovery design and implementation. (b) Develops strategies for data acquisitions, archive recovery, and implementation of a database. (c) Works in a data warehouse environment, which includes data design, database architecture, and metadata repository creation. (d) Translates business needs into long-term architecture solutions. (e) Defines, designs, and builds dimensional databases. (f) Develops data warehousing blueprints, evaluating hardware and software platforms, and integrating systems. (g) Reviews and develops object and data models and the metadata repository to structure the data for better management and quicker access.Master's Degree and 5-9,
Database Analyst/SpecialistSubject Matter ExpertDatabase Analyst/Specialist (Level4-Master) (a) Provides all activities related to the administration of computerized databases. (b) Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function. (c) Designs, creates, and maintains databases in a client/server environment. (d) Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data. (e) Advises users on access to various client/server databases. (f) Designs, implements, and maintains complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. (g) Applies knowledge and experience with database technologies, development methodologies, and front-end (e.g., COGNOS)/back-end programming languages (e.g., SQL). Performs database programming and supports systems design. (h) Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design. Knowledge/Skill Description Provides technical/management leadership on major tasks or technology assignments. Establishes goals and plans that meet project objectives. Has domain and expert technical knowledge. Directs and controls activities for a client, having overall responsibility for financial management, methods, and staffing to ensure that technical requirements are met. Interactions involve client negotiations and interfacing with senior management. Decision making and domain knowledge may have a critical impact on overall project implementation. May supervise others.Master's Degree and 3-5
Enterprise ArchitectSubject Matter ExpertEnterprise Architect (a) Provides high-level architectural expertise to managers and technical staff. (b) Develops architectural products and deliverables for the enterprise and operational business lines. (c) Develops strategy of system and the design infrastructure necessary to support that strategy. (d) Advises on selection of technological purchases with regards to processing, data storage, data access, and applications development. (e) Advises of feasibility of potential future projects to management.Bachelor's Degree and 3-5
Enterprise Architect
DirectorEnterprise Architect (a) Provides high-level architectural expertise to managers and technical staff. (b) Develops architectural products and deliverables for the enterprise and operational business lines. (c) Develops strategy of system and the design infrastructure necessary to support that strategy. (d) Advises on selection of technological purchases with regards to processing, data storage, data access, and applications development. (e) Advises of feasibility of potential future projects to management.Master's Degree and 5-9,
Enterprise Architect
DirectorEnterprise Architect (a) Provides high-level architectural expertise to managers and technical staff. (b) Develops architectural products and deliverables for the enterprise and operational business lines. (c) Develops strategy of system and the design infrastructure necessary to support that strategy. (d) Advises on selection of technological purchases with regards to processing, data storage, data access, and applications development. (e) Advises of feasibility of potential future projects to management.Master's Degree and 5-9,
Information Assurance/Security SpecialistSeniorInformation Assurance/Security Specialist (a) Determines enterprise information assurance and security standards. (b) Develops and implements information assurance/security standards and procedures. (c) Coordinates, develops, and evaluates security programs for an organization. Recommends information assurance/security solutions to support customers? requirements. (d) Identifies, reports, and resolves security violations. (e) Establishes and satisfies information assurance and security requirements based upon the analysis of user, policy, regulatory, and resource demands. (f) Supports customers at the highest levels in the development and implementation of doctrine and policies. (g) Applies know-how to government and commercial common user systems, as well as to dedicated special purpose systems requiring specialized security features and procedures. (h) Performs analysis, design, and development of security features for system architectures. (i) Analyzes and defines security requirements for computer systems which may include mainframes, workstations, and personal computers. (j) Designs, develops, engineers, and implements solutions that meet security requirements. (k) Provides integration and implementation of the computer system security solution. (l) Analyzes general information assurance-related technical problems and provides basic engineering and technical support in solving these problems. (m) Performs vulnerability/risk analyses of computer systems and applications during all phases of the system development life cycle. (n) Ensures that all information systems are functional and secure. Knowledge/Skill Description Possesses and applies a comprehensive knowledge across key tasks and high impact assignments. Plans and leads major technology assignments. Evaluates performance results and recommends major changes affecting short-term project growth and success. Functions as a technical expert across multiple project assignments. May supervise others.Bachelor's Degree and 3-5
Process EngineerSubject Matter ExpertProcess Engineer (a) Understands the required outcomes of a particular procedure. (b) Designs processes and supporting technologies related to the creation of products or services that are cost effective and in keeping with a given budget. (c) Implements process designs, creating prototypes, testing, making necessary modifications where required and commissioning the process. (d) Assesses security requirements and ensures that these are integrated into the process. (e) Works closely with other professionals such as functional stakeholders and information and systems engineers on development and research projects. (f) Integrates new technology and/or non-materiel solutions into existing processes.Master's Degree and 3-5
Program ManagerSeniorProgram Manager (a) Organizes, directs, and manages contract operation support functions, involving multiple, complex and inter‐related project tasks. (b) Manages teams of contract support personnel at multiple locations. (c) Maintains and manages the client interface at the senior levels of the client organization. (d) Meets with customer and contractor personnel to formulate and review task plans and deliverable items. Ensures conformance with program task schedules and costs.Bachelor's Degree and 3-5
Program ManagerSubject Matter ExpertProgram Manager (a) Organizes, directs, and manages contract operation support functions, involving multiple, complex and inter-related project tasks. (b) Manages teams of contract support personnel at multiple locations. (c) Maintains and manages the client interface at the senior levels of the client organization. (d) Meets with customer and contractor personnel to formulate and review task plans and deliverable items. Ensures conformance with program task schedules and costs.Master's Degree and 3-5
Security EngineerSubject Matter ExpertSecurity Engineer (a) Leads developing, implementing, and maintaining enterprise-wide information security capabilities. (b) Analyzes the enterprise business models and IT systems to determine security risks and risk management considerations (c) Defines enterprise and system level security requirements (d) Proposes technical solutions for systems and applications-level security architecture and design (e) Develops security plans, policies and procedures.Master's Degree and 3-5
Subject Matter ExpertSeniorSubject Matter Expert (a) Serves as subject matter expert, possessing in-depth knowledge of a particular area, such as business, computer science, engineering, mathematics, or the various sciences. (b) Provides technical knowledge and analysis of highly specialized applications and operational environments, high-level functional systems analysis, design, integration, documentation and implementation advice on exceptionally complex problems that need extensive knowledge of the subject matter for effective implementation. (c) Participates as needed in all phases of software development with emphasis on the planning, analysis, testing, integration, documentation, and presentation phases. (d) Applies principles, methods and knowledge of the functional area of capability to specific task order requirements, advanced mathematical principles and methods to exceptionally difficult and narrowly defined technical problems in engineering and other scientific applications to arrive at automated solutions. Knowledge/Skill Description Possesses and applies a comprehensive knowledge across key tasks and high impact assignments. Plans and leads major technology assignments. Evaluates performance results and recommends major changes affecting short-term project growth and success. Functions as a technical expert across multiple project assignments. May supervise others.Bachelor's Degree and 3-5
Subject Matter ExpertSubject Matter ExpertSubject Matter Expert (a) Serves as subject matter expert, possessing in-depth knowledge of a particular area, such as business, computer science, engineering, mathematics, or the various sciences. (b) Provides technical knowledge and analysis of highly specialized applications and operational environments, high-level functional systems analysis, design, integration, documentation and implementation advice on exceptionally complex problems that need extensive knowledge of the subject matter for effective implementation. (c) Participates as needed in all phases of software development with emphasis on the planning, analysis, testing, integration, documentation, and presentation phases. (d) Applies principles, methods and knowledge of the functional area of capability to specific task order requirements, advanced mathematical principles and methods to exceptionally difficult and narrowly defined technical problems in engineering and other scientific applications to arrive at automated solutions. Knowledge/Skill Description Provides technical/management leadership on major tasks or technology assignments. Establishes goals and plans that meet project objectives. Has domain and expert technical knowledge. Directs and controls activities for a client, having overall responsibility for financial management, methods, and staffing to ensure that technical requirements are met. Interactions involve client negotiations and interfacing with senior management. Decision making and domain knowledge may have a critical impact on overall project implementation. May supervise others.Master's Degree and 5-9
Subject Matter ExpertDirectorSubject Matter Expert (a) Serves as subject matter expert, possessing in-depth knowledge of a particular area, such as business, computer science, engineering, mathematics, or the various sciences. (b) Provides technical knowledge and analysis of highly specialized applications and operational environments, high-level functional systems analysis, design, integration, documentation and implementation advice on exceptionally complex problems that need extensive knowledge of the subject matter for effective implementation. (c) Participates as needed in all phases of software development with emphasis on the planning, analysis, testing, integration, documentation, and presentation phases. (d) Applies principles, methods and knowledge of the functional area of capability to specific task order requirements, advanced mathematical principles and methods to exceptionally difficult and narrowly defined technical problems in engineering and other scientific applications to arrive at automated solutions. Knowledge/Skill Description Provides technical/management leadership on major tasks or technology assignments. Establishes goals and plans that meet project objectives. Has domain and expert technical knowledge. Directs and controls activities for a client, having overall responsibility for financial management, methods, and staffing to ensure that technical requirements are met. Interactions involve client negotiations and interfacing with senior management. Decision making and domain knowledge may have a critical impact on overall project implementation. May supervise others.Master's Degree and 3-5
Systems AdministratorSeniorThe System Administrator Lead is responsible for several System Administrators in directing maintenance of the integrity and security of enterprise’s servers and systems which support the various operating units of the enterprise. The System Administrator - Lead also provides primary direction it developing programs and support systems for all of the enterprise’s operation units. The System Administrator – Lead is direct the conduct of system analysis and development, with limited support and direction from other professional staff, to keep our systems current with changing technologiesBachelor's Degree and 3-5
Systems ArchitectJourneymanSystems Architect (a) Provides system/solution-level architectural expertise to managers and technical staff. (b) Designs architectures to include the software, hardware, and communications to support the total requirements as well as provide for present and future cross-functional requirements and interfaces. (c) Architects, designs, and develops integrated information solutions/systems and controls project requirements, scope, risk, and change management issues (d) Advises of feasibility of potential future projects to management.Bachelor's Degree and 3-5
Systems ArchitectSeniorSystems Architect (a) Provides system/solution-level architectural expertise to managers and technical staff. (b) Designs architectures to include the software, hardware, and communications to support the total requirements as well as provide for present and future cross-functional requirements and interfaces. (c) Architects, designs, and develops integrated information solutions/systems and controls project requirements, scope, risk, and change management issues (d) Advises of feasibility of potential future projects to management.Master's Degree and 5-7
Systems Architect
Subject Matter ExpertSystems Architect (a) Provides system/solution-level architectural expertise to managers and technical staff. (b) Designs architectures to include the software, hardware, and communications to support the total requirements as well as provide for present and future cross-functional requirements and interfaces. (c) Architects, designs, and develops integrated information solutions/systems and controls project requirements, scope, risk, and change management issues (d) Advises of feasibility of potential future projects to management.Master's Degree and 5-9,
Systems EngineerSeniorSystems Engineer (a) Provides analysis related to the design, development, and integration of hardware, software, man‐machine interfaces and all system level requirements to provide an integrated IT solution. (b) Develops integrated system test requirement, strategies, devices and systems. (c) Directs overall system level testing.Bachelor's Degree and 3-5
Systems EngineerSubject Matter ExpertSystems Engineer (a) Provides analysis related to the design, development, and integration of hardware, software, man-machine interfaces and all system level requirements to provide an integrated IT solution. (b) Develops integrated system test requirement, strategies, devices and systems. (c) Directs overall system level testing.Master's Degree and 3-5
Technical WriterSeniorTechnical Writer (a) Writes a variety of technical articles, reports, brochures, and/or manuals for documentation for a wide range of uses. (b) Coordinates the display of graphics and the production of the document. (c) Ensures content is of high quality and conforms with standards.Bachelor's Degree and 3-5

Labor Rates (FP)

Attachment 1
Tab Instructions:

1. Offeror shall only complete GREEN filled cells.

2. Enter a fully burdened rate for Government and Contractor site locations for Year 1 (Columns D and E) for each labor category.

3. In Row 3, Column F through M, enter an "Escalation Rate" for each respective year of performance. Enter the increase in pricing as a percentage year over year. The escalation of proposed labor rates will automatically be calculated based on the offeror's proposed Year 1 labor rates. If an offeror does not input/enter an escalation for a given year in Row 3, no escalation will be calculated and the Government will enter an escalation of zero (0%) for that given year.

NOTE: Cells with equations are established to ensure precise calculations. Please refrain from modifying these equation cells. It is essential not to delete any rows or columns within this tab. The structure has been designed to maintain the accuracy of the data.

Escalation Rate0%
Year 1Year 2Year 3Year 4Year 5FAR 52.217-8
Base Period Year 1Base Period Year 2Base Period Year 3Base Period Year 4Base Period Year 5
LCAT#Labor CategoryLevelGovernmentContractorGovernmentContractorGovernmentContractorGovernmentContractorGovernmentContractorGovernmentContractor
1ADMINISTRATION/CLERICALSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2ADMINISTRATION/CLERICALJOURNEYMAN$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3APPLICATIONS SYSTEMS ANALYSTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4APPLICATIONS PROGRAMMERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5APPLICATIONS PROGRAMMERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6CONFIGURATION MGMT SPECIALISTJOURNEYMAN$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7CONFIGURATION MGMT SPECIALISTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8DATABASE ANALYST/SPECIALISTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9DATA ARCHITECTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10DATA ARCHITECTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11ENTERPRISE ARCHITECTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12ENTERPRISE ARCHITECTDIRECTOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
13INFORMATION ASSURANCE / SECURITY SPECIALISTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
14PROCESS ENGINEERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
15PROGRAM MANAGERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
16PROGRAM MANAGERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
17SECURITY ENGINEERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
18SUBJECT MATTER EXPERTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
19SUBJECT MATTER EXPERTDIRECTOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
20SUBJECT MATTER EXPERTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
21SYSTEMS ADMINISTRATORSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
22SYSTEMS ARCHITECTJOURNEYMAN$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
23SYSTEMS ARCHITECTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
24SYSTEMS ARCHITECTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
25SYSTEMS ENGINEERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
26SYSTEMS ENGINEERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
27TECHNICAL WRITERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Labor Rates (LH)

Attachment 1
Tab Instructions:

1. Offeror shall only complete GREEN filled cells.

2. Enter a fully burdened rate for Government and Contractor site locations for Year 1 (Columns D and E) for each labor category.

3. In Row 3, Column F through M, enter an "Escalation Rate" for each respective year of performance. Enter the increase in pricing as a percentage year over year. The escalation of proposed labor rates will automatically be calculated based on the offeror's proposed Year 1 labor rates. If an offeror does not input/enter an escalation for a given year in Row 3, no escalation will be calculated and the Government will enter an escalation of zero (0%) for that given year.

NOTE: Cells with equations are established to ensure precise calculations. Please refrain from modifying these equation cells. It is essential not to delete any rows or columns within this tab. The structure has been designed to maintain the accuracy of the data.

Escalation Rate0%
Year 1Year 2Year 3Year 4Year 5FAR 52.217-8
Base Period Year 1Base Period Year 2Base Period Year 3Base Period Year 4Base Period Year 5
LCAT#Labor CategoryLevelGovernmentContractorGovernmentContractorGovernmentContractorGovernmentContractorGovernmentContractorGovernmentContractor
1ADMINISTRATION/CLERICALSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2ADMINISTRATION/CLERICALJOURNEYMAN$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3APPLICATIONS SYSTEMS ANALYSTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4APPLICATIONS PROGRAMMERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5APPLICATIONS PROGRAMMERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6CONFIGURATION MGMT SPECIALISTJOURNEYMAN$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7CONFIGURATION MGMT SPECIALISTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8DATABASE ANALYST/SPECIALISTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9DATA ARCHITECTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10DATA ARCHITECTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11ENTERPRISE ARCHITECTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12ENTERPRISE ARCHITECTDIRECTOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
13INFORMATION ASSURANCE / SECURITY SPECIALISTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
14PROCESS ENGINEERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
15PROGRAM MANAGERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
16PROGRAM MANAGERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
17SECURITY ENGINEERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
18SUBJECT MATTER EXPERTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
19SUBJECT MATTER EXPERTDIRECTOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
20SUBJECT MATTER EXPERTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
21SYSTEMS ADMINISTRATORSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
22SYSTEMS ARCHITECTJOURNEYMAN$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
23SYSTEMS ARCHITECTSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
24SYSTEMS ARCHITECTSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
25SYSTEMS ENGINEERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
26SYSTEMS ENGINEERSME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
27TECHNICAL WRITERSENIOR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Sheet2

File details come from the government source that posted it. Updated .