Attachment 9 - Rate_Schedule_08242023 V1.4.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
Synthetic Theater Operations Research Model (STORM) Solicitation-Amendment 1
Solicitation number
FA7014-23-R-0031_STORM_Solicitation
Issued by

About this file

This document contains rate schedules and labor category descriptions for a solicitation seeking campaign analysis support services using the Synthetic Theater Operations Research Model (STORM) software. The solicitation is seeking fixed-price and time and material labor rates for various ordering periods through November 2028 for labor categories including campaign analysts, software engineers, and program managers to support the Department of the Air Force in evaluating concepts and programs through STORM modeling and simulation. The rate schedules include fully burdened hourly rates by labor category for contractor and government sites but are placeholder as all rates are currently set to $0. Labor category descriptions define qualifications and responsibilities for each position.

View the file

Other files

File Type Posted
Attach 14 - PWS and QASP Change Log_082223.docx DOCX document
Attachment 6 - Campaign Analytic Support PWS V1.0.DOC DOC document
Attach 11 - FAR 52.212-2 Addendum-Eval Factors_082423.docx DOCX document
Attachment 12 - Contract Data Requirements List (CDRLs)_07272023.pdf PDF
Attach 13 - Wage Determinations_082423.pdf PDF
Attachment 7 - Quality Assurance Surveillance Plan.docx DOCX document
Solicitation Amendment FA701423R00310001 SF 30.pdf PDF
Solicitation Amendment (CONFORMED) - FA701423R00310001.pdf PDF
Attachment 10 - Addendum to FAR 52.212-1 ITO_082423.docx DOCX document
FA701423R0031 Questions and Answers 08242023.xlsx XLSX spreadsheet
Attachment 12 - Contract Data Requirements List (CDRLs)_07272023.pdf PDF
Attachment 8 - Past_Performance_Questionnaire.pdf PDF
Attachment 11 - Addendum to FAR 52.212-2 Evaluation Factors__07272023.docx DOCX document
Attachment 9 - Rate_Schedule V1.3.xlsx XLSX spreadsheet
Attachment 6 - Campaign Analytic Support PWS V1.0.3_07272023.docx DOCX document
Attachment 3 - DRAFT Campaign Analytic Support - DD254 v2.pdf PDF
Attachment 10 - Addendum to FAR 52.212-1 Instructions to Offerors_07272023.docx DOCX document
Attachment 4 - DFARS Clause 252.227-7013 Rights in Technical Data.docx DOCX document
Attachment 5 - Small Business Participation Plan.docx DOCX document
Attachment 7 - Quality Assurance Surveillance Plan_updated_07282023_V3.3.0.pdf PDF
Attachment 1 - STORM_Software Users Agreement V2.12.pdf PDF
Solicitation - FA701423R0031 08032023v1.pdf PDF
Attachment 2 - STORM Software Distribution Statement (07052023) v0.pdf PDF
Show all 23

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

RATES-FIRM FIXED PRICE

CAMPAIGN ANALYSIS SUPPORT (STORM)RFP: FA701423R0031
Rate Schedule for Firm Fixed Price CLINsOfferor:
To be used for pricing CLINs 0002, 0003, 0005, and 0006 Task Orders.
The list below is not intended to be inclusive of all labor catagories. If needed, add include all labor catagories that will be used in the performance of this contract.
Ensure that the labor catagories used in your Cost and Pricing Schedule are listed here.
LABOR CATEGORYOrdering Period 1ORDERING PERIOD 2ORDERING PERIOD 3ORDERING PERIOD 4ORDERING PERIOD 5
29Nov23-28Nov2429Nov24-28Nov2529Nov25-28Nov2629Nov26-28Nov2729Nov27-28Nov28
RateRateRateRateRate
Senior Campaign Analyst/ Executive Campaign Analyst
Mid-Level Campaign Analyst
Junior Campaign Analyst
Senior Program Manager/ Program Manager II
GUSt User Group Administrator/ Programmer
Junior Campaign Software Engineer / Junior Programming Specialist
Mid-Level Campaign Software Engineer / Mid-Level Programmer
Senior Campaign Software Engineer/ Senior Programmer
Executive Campaign Software Engineer/ Executive Programmer
Principal Campaign Configuration Architect/ Principal Software Architect
Campaign Help Desk Software Engineer / Programming Specialist Representative
Chief Campaign Software Engineer/ Principal Engineer
Entry Level Campaign Software Engineer/ Junior Programming Specialist
Campaign Software Engineer / Programmer
Contractor SiteFringe Percentage
Overhead Percentage
G&A Percentage
Profit Percentage
TOTAL PERCENTAGE0.00%0.00%0.00%0.00%0.00%
Government SiteFringe Percentage
Overhead Percentage
G&A Percentage
Profit Percentage
TOTAL PERCENTAGE0.00%0.00%0.00%0.00%0.00%

RATES-T&M CONTRACTOR SITE

CAMPAIGN ANALYSIS SUPPORT (STORM)RFP: FA701423R0031Offeror:0
Rate Schedule for Contractor's Site Time and Material CLINS
To be used for pricing CLIN 0003 Task Orders.
The list below is not intended to be inclusive of all labor catagories. If needed, add labor catagories that will be used in the performance of this contract.
INSTRUCTIONS:
Cells D17 through L38 contain formulas. Rows and/or columns may be inserted as needed and it is the Offeror's responsibility to ensure formulas are adjusted accordingly.
Enter the hourly labor rate in the purple cells found in column C for the Labor Category idnetified in column B.
Enter Indirect Rate percentages in the blue cells found in row 16, columns D-G. The amount computed for each Labor Catagory will use that percentage and the Direct Labor Rate to compute the Indirect Rate amount in cells below row 15.
Columns H-L reflect the fully burneded rate for each Labor Category. Enter the annual escalation rate in the green cells found in row 16, columns I-L, to compute forward priced Fully Burdened Rates.
FULLY BURDENED RATES
LABOR CATEGORYDIRECTINDIRECT RATESORDERING PERIOD 1ORDERING PERIOD 2ORDERING PERIOD 3ORDERING PERIOD 4ORDERING PERIOD 5
LABORFRINGEOVERHEADG&APROFIT29Nov23-28Nov2429Nov24-28Nov2529Nov25-28Nov2629Nov26-28Nov2729Nov27-28Nov28
RATENo Escalation4.15%4.15%4.15%4.15%
Senior Campaign Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mid-Level Campaign Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Junior Campaign Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GUSt User Group Administrator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Junior Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mid-Level Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Principal Campaign Configuration Architect$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Campaign Help Desk Representative$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Chief Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Entry Level Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

RATES-T&M GOVERNMENT SITE

CAMPAIGN ANALYSIS SUPPORT (STORM)RFP: FA701423R0031Offeror:0
Rate Schedule for Government Site Time and Material CLINS
To be used for pricing CLIN 0003 Task Orders.
The list below is not intended to be inclusive of all labor catagories. If needed, add labor catagories that will be used in the performance of this contract.
INSTRUCTIONS:
Cells D17 through L38 contain formulas. Rows and/or columns may be inserted as needed and it is the Offeror's responsibility to ensure formulas are adjusted accordingly.
Enter the hourly labor rate in the purple cells found in column C for the Labor Category idnetified in column B.
Enter Indirect Rate percentages in the blue cells found in row 16, columns D-G. The amount computed for each Labor Catagory will use that percentage and the Direct Labor Rate to compute the Indirect Rate amount in cells below row 15.
Columns H-L reflect the fully burneded rate for each Labor Category. Enter the annual escalation rate in the green cells found in row 16, columns I-L, to compute forward priced Fully Burdened Rates.
FULLY BURDENED RATES
LABOR CATEGORYDIRECTINDIRECT RATESORDERING PERIOD 1ORDERING PERIOD 2ORDERING PERIOD 3ORDERING PERIOD 4ORDERING PERIOD 5
LABORFRINGEOVERHEADG&APROFIT29Nov23-28Nov2429Nov24-28Nov2529Nov25-28Nov2629Nov26-28Nov2729Nov27-28Nov28
RATENo Escalation4.15%4.15%4.15%4.15%
Senior Campaign Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mid-Level Campaign Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Junior Campaign Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GUSt User Group Administrator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Junior Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mid-Level Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Principal Campaign Configuration Architect$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Campaign Help Desk Representative$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Chief Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Entry Level Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Campaign Software Engineer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Labor Catagory Descriptions

Labor Category Descriptions
CAMPAIGN ANALYSIS SUPPORT (STORM)
Labor CategoryDescription
Senior Campaign AnalystPerforms independently to architect objectives, parameters and practical quantitative approaches to provide an enterprise-level perspective of concept and program requirements, component system specifications and alternative engineering solutions. Applies mastery-level analytical skills, mathematical models and computer science techniques in studies evaluating concept/program/platform performance against defined requirements and in context of organizational mission. Oversees one or more teams in the application of analytical skills, mathematical models and computer science techniques to evaluate concept/program/platform performance against defined requirements and in context of organizational mission. Applies mastery-level analytical skills and problem-solving techniques to refine insights and present them to senior-level audiences.
Skill Level: Requires a bachelor’s degree with at least 12 years of experience or have a master’s degree with at least 10 years of experience in the field related to campaign analysis and modeling. Out of all years of experience, a minimum of 8 years of experience shall be in using STORM.. Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. May lead and direct the work of others.
Mid-Level Campaign AnalystPerforms as a supporting member of a team requiring expertise in the application of specific technology solutions to meet requirements in context of organizational mission. Applies engineering principles to define specifications and shape the development of tools and methods for performing operations associated with a concept/program/project/activity.
Skill Level: Requires a bachelor’s degree with at least 8 years of experience or have a master’s degree with at least 6 years of experience in the field related to campaign analysis and modeling. Out of all years of experience, a minimum of 3 years of experience shall be in using STORM. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Junior Campaign AnalystPerforms as a supporting member of a team executing quantitative approaches to provide an enterprise-level

perspective of concept and program requirements, component system specifications and alternative engineering solutions. Applies basic-level analytical skills, mathematical models and computer science techniques in studies evaluating concept/program/project/activity performance against defined requirements and in context of organizational mission.

Skill Level: Require a bachelor’s degree with at least 2 years of experience or have a master’s degree with at least 1 year of experience in the field related to campaign analysis and modeling. Out of all years of experience, a minimum of 1 year of experience shall be in using STORM. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Senior Program ManagerManages multiple teams executing studies of concept/program/project/activity effectiveness against defined

requirements and in context of organizational mission. Interfaces with senior customer representatives to ensure contract technical execution and administration aligns with organization guidance and contract terms and conditions. Supervises all aspects of technical performance. Establishes standards, timelines and performance metrics and monitors compliance over the course of a complex team effort.

Skill Level: Require a bachelor’s degree with at least 15 years of experience in the field related to campaign analysis, software engineering, and program management. Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. May lead and direct the work of others.
GUSt User Group AdministratorPerforms as a participating member of a technical team translating preliminary specifications into a working

prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies refined programming skills and computer science techniques to develop representations at the sub-system level. Participates in code review, testing and configuration management processes and actions. Works to system design specifications. Works against defined task objectives and timelines.

Skill Level: Requires a bachelor’s degree with 1 year of experience in the field related to customer service or website administration. Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. May lead and direct the work of others.
Junior Campaign Software EngineerPerforms as a fully directed member of a technical team translating preliminary specifications into a working

prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies entry-level programming skills and computer science techniques to produce commodity-level representations. Observes code review, testing and configuration management processes and actions. Works to system design specifications. Works against defined task objectives and timelines

Skill Level: Requires a bachelor’s degree with at least 2 years of experience or have a master’s degree with at least 1 year of experience in the field related to software engineering. Out of all years of experience, a minimum of 1 year of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Mid-Level Campaign Software EngineerPerforms as a task leader on a technical team translating preliminary specifications into a working prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies professional-level programming skills and computer science techniques to develop representations at the sub-system level. Participates fully in code review, testing and configuration management processes and actions. Works to system design specifications. Informs task objectives and timelines.
Skill Level: Requires a bachelor’s degree with at least 8 years of experience or have a master’s degree with at least 6 years of experience in the field related to software engineering. Out of all years of experience, a minimum of 3 years of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Senior Campaign Software EngineerPerforms independently or as a task leader of a technical team translating preliminary specifications into a working prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies expert-level programming skills and computer science techniques to develop representations at the system level. Leads elements of code review, testing and configuration management processes and actions. Reviews and refines system design specifications. Proposes task objectives and timelines.
Skill Level: Requires a bachelor’s degree with at least 12 years of experience or have a master’s degree with at least 10 years of experience in the field related to software engineering. Out of all years of experience, a minimum of 8 years of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Executive Campaign Software EngineerPerforms independently or directs a technical team translating preliminary specifications into a working prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies mastery-level programming skills and computer science techniques to develop representations involving multiple systems. Leads code review, testing and configuration management processes and actions. Reviews and refines system design specifications. Establishes task objectives and timelines.
Skill Level: Requires a bachelor’s degree with at least 15 years of experience or have a master’s degree with at least 13 years of experience in the field related to software engineering. Out of all years of experience, a minimum of 10 years of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Principal Campaign Configuration ArchitectPerforms independently or directs one or more technical teams integrating developed representations of sub-systems and systems into a working prototype model or simulation of a complete, complex system to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies mastery-level programming skills and computer science techniques to integrate code at the enterprise level. Oversees code review, testing and configuration management processes and actions. Reviews and refines system design specifications. Establishes task objectives and timelines.
Skill Level: Requires a bachelor’s degree with at least 20 years of experience or have a master’s degree with at least 18 years of experience in the field related to software engineering. Out of all years of experience, a minimum of 15 years of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Campaign Help Desk Software Engineer RepresentativePerforms as a supporting member of a technical team translating preliminary specifications into a working prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies basic-level programming skills and computer science techniques to produce general-purpose code. Observes code review, testing and configuration management processes and actions. Works to system design specifications. Works against defined task objectives and timelines.
Skill Level: Requires a bachelor’s degree with at least 2 years of experience or have a master’s degree with at least 1 year of experience in the field related to software engineering. Out of all years of experience, a minimum of 1 year of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Chief Campaign Software EngineerPerforms independently to architect objectives, parameters and practical quantitative approaches to provide a

performance-based perspective of concept and program requirements, component system specifications and alternative engineering solutions. Applies engineering principles and mathematical models or simulations to design and execute studies of concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies mastery-level analytical skills and problem-solving techniques to generate and present insights to inform senior-level audiences.

Skill Level: Requires a bachelor’s degree with at least 20 years of experience or have a master’s degree with at least 18 years of experience in the field related to software engineering. Out of all years of experience, a minimum of 15 years of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Entry Level Campaign Software EngineerPerforms as a fully directed member of a technical team translating preliminary specifications into a working

prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies entry-level programming skills and computer science techniques to produce commodity-level representations. Observes code review, testing and configuration management processes and actions. Works to system design specifications. Works against defined task objectives and timelines.

Skill Level: Requires a bachelor's degree with 0 year of experience in the field related to software engineering. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.
Campaign Software EngineerPerforms as a participating member of a technical team translating preliminary specifications into a working

prototype model or simulation to support studies evaluating concept/program/project/activity effectiveness against defined requirements and in context of organizational mission. Applies refined programming skills and computer science techniques to develop representations at the sub-system level. Participates in code review, testing and configuration management processes and actions. Works to system design specifications. Works against defined task objectives and timelines.

Skill Level: Requires a bachelor’s degree with at least 8 years of experience or have a master’s degree with at least 6 years of experience in the field related to software engineering. Out of all years of experience, a minimum of 3 years of experience shall be in STORM software development. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager.

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