Attachment_12_Pricing_Template.xlsx

XLSX spreadsheet 49 KB Posted

Attached to
DTRA - AGENCY WIDE IT SERVICE DESIGN Federal contract opportunity
Solicitation number
HDTRA1-18-R-0045
Issued by
Defense Threat Reduction Agency

About this file

This document package includes a pricing template and details for a federal contract opportunity with the Defense Threat Reduction Agency. The pricing template provides labor categories and instructions for offerors to submit pricing for two initial task orders for IT solution engineering and systems test support as well as knowledge management solutions and support. Pricing should be submitted using the template for the base period and any option periods defined in the task order performance work statements. The federal contract opportunity is a solicitation for multiple-award ID/IQ contracts to provide agency-wide IT service design support. Two initial task orders will be awarded concurrently with the base contracts. Questions about the draft solicitation are due by July 23, 2018 to the specified email address and should follow the question format outlined. Award of the base contracts and initial task orders will occur on or around March 29, 2019.

Pricing Template

View the file

Other files for this federal contract opportunity

Other files attached to DTRA - AGENCY WIDE IT SERVICE DESIGN, newest first.
File Type Posted
Attachment_10_PPI_rev.doc DOC document
HDTRA1-18-R-0045_Mod1.pdf PDF
Attachment_5_HDTRA1-18-R-0045_DD254rev.pdf PDF
Attachment_14_RFP_Questions_and_Answers_2018_10.pdf PDF
Attachment_11_PPQ.doc DOC document
Attachment_6_DRAFT_QASP_-_IT_Service_Design_IDIQ.docx DOCX document
Exhibit_B_A002_Proj_Scheds.docx DOCX document
Attachment_4_Consolidated_Sample_Task_Order-_Final.docx DOCX document
Exhibit_C_A003_Tech_Anal_Rpts.docx DOCX document
Exhibit_F__A006_MGPL.docx DOCX document
Attachment_7_Preaward_Survey_of_Prospective_Contractor_Accounting_System_Checklist.pdf PDF
Attachment_2_PWS_TO_1_-_IT_Solution_Engineering_and_Test_Support_-_Final.docx DOCX document
Exhibit_D__A004_Plans.docx DOCX document
Attachment_1_SOO_IT_Service_Design.docx DOCX document
Attachment_10_PPI.doc DOC document
Exhibit_A__A001_MSR.docx DOCX document
Exhibit_E_A005_Info_Mtls.docx DOCX document
Attachment_13_IT_Service_Design_Supplemental_Information_Package.pdf PDF
Attachment_5_HDTRA1-18-R-0045_DD254.pdf PDF
Attachment_8_GPAT.doc DOC document
Attachment_9_NON-DISCLOSURE_AGREEMENT.doc DOC document
HDTRA1-18-R-0045_9.17.18.pdf PDF
Attachment_3_PWS_TO_2_-_Knowledge_Mgmt_Final.docx DOCX document
Exhibit_G_A007_Software_Design_Docs.docx DOCX document
HDTRA1-18-R-0045_-_Questions_and_Answers.pdf PDF
Attachment_5_HDTRA1-18-R-0045_DD254.pdf PDF
Exhibit_D__A004_Plans.docx DOCX document
Attachment_2_DRAFT_PWS_TO_1_-_IT_Solution_Engineering_and_Test_Support.docx DOCX document
Attachment_11_PPQ.doc DOC document
Exhibit_G_A007_Software_Design_Docs.docx DOCX document
Attachment_4_Sample_PWS_TO_3_-_GCC_Collaboration_Tool.docx DOCX document
Attachment_1_DRAFT_SOO_IT_Service_Design.docx DOCX document
Attachment_12_DRAFT_Pricing_Template.xlsx XLSX spreadsheet
Exhibit_F__A006_MGPL.docx DOCX document
Exhibit_A__A001_MSR.docx DOCX document
Attachment_7_Preaward_Survey_of_Prospective_Contractor_Accounting_System_Checklist.pdf PDF
Exhibit_C_A003_Tech_Anal_&_Rpts.docx DOCX document
Exhibit_E_A005_Info_Mtls.docx DOCX document
DRAFT_RFP_HDTRA1-18-R-0045.docx DOCX document
Attachment_9_NON-DISCLOSURE_AGREEMENT.doc DOC document
Exhibit_B_A002_Proj_Scheds.docx DOCX document
Attachment_6_DRAFT_QASP_-_IT_Service_Design_IDIQ.docx DOCX document
Attachment_10_PPI.doc DOC document
Attachment_8_GPAT.doc DOC document
Attachment_3_DRAFT_PWS_TO_2_-_Knowledge_Mgmt.docx DOCX document
Show all 45

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

General Cost Proposal

GENERAL INFORMATION

The Offeror shall provide a full cost proposal for Task Orders 1 and 2. The purpose of the requested information is to assist the Government's review and evaluation of cost proposals submitted by Offerors. Offerors are reminded that the responsibility for providing adequate supporting data and attachments lies solely with them. Further, the offeror must also bear the burden of proof in establishing reasonableness of proposed costs; therefore, it is in the offeror’s best interest to submit a fully supportable and well-prepared cost proposal. The basis and rationale for all proposed costs should be provided as part of the proposal so that Government personnel can place reliance on the information as current, complete and accurate. Further, FAR 15.403-4 sets forth those circumstances in which offerors are required to submit certified cost or pricing data.

Cost by Task: In addition to providing summary by period of performance (base and any options), the Contractor is also responsible for providing a breakdown of cost for each task indentified in the Performance Work Statement for Task Orders 1 and 2 (no costs are required for Sample Task Order 3). The sum of all cost by task worksheets MUST equal the total cost summary.

Options: For this proposal, Offerors are only to propose pricing for Task Orders 1 and 2 using the Period of Performance called out in the Performance Work Statements (PWS) Specific task order pricing will include task order pricing for the task order base period plus any task order option periods defined in the task order PWS.

Labor Categories: The Offeror shall use the Sample Pricing Template as a guide for the pricing structure/format and shall use the Labor Category tab to identify the labor categories that will be aligned with the Offeror's proposed staffing plan and overall proposed solution. If the Offeror can't align a labor category with thoses listed, creating a unique labor category is acceptable. The Offeror is, however, encouraged to attempt to align labor categories with the standard LCATs to the maximum extent practical.

Proposal Dates: For consistency among proposals Offeror's pricing should assume task order awards will be announced on 3/29/19. This date is for planning purposes only and is subject to change.

ERROR:#REF!

$0

Labor Categories Labor Categories for use in Proposal Pricing

The Offeror is encouraged to use the labor categories provided in the following table to the maximum extent practical. If these common labor categories do not exactly align with the Offeror's labor categories, please attempt to select the closest reasonable match within the listed labor categoreies. If the required labor category is not included in this list, and assigning a "closest match" is not reasonable, the government will accept additional unique labor categories. Please clearly identify all such unique labor categories and provide the relevant distinguishing qualifications.

PLEASE COMPLETE FOR ALL LABOR CATEGORIES USED
Labor CategoryContractor Labor Category EquivalentLevelEducationExperienceClearanceDirect Base Rate
Applications Systems AnalystIHS0-5yrsSecret
Applications Systems AnalystIIHS/Associate's5-10yrsSecret/TS
Applications Systems AnalystIIIBA/BS10-15yrsTS
Applications Systems AnalystIVMS15yrs +TS
Asset Management SpecialistIHS0-5yrsSecret
Asset Management SpecialistIIHS/Associate's5-10yrsSecret/TS
Asset Management SpecialistIIIBA/BS10-15yrsTS
Asset Management SpecialistIVMS15yrs +TS
Computer Forensic & Intrusion AnalystIHS0-5yrsSecret
Computer Forensic & Intrusion AnalystIIHS/Associate's5-10yrsSecret/TS
Computer Forensic & Intrusion AnalystIIIBA/BS10-15yrsTS
Computer Forensic & Intrusion AnalystIVMS15yrs +TS
Configuration Management SpecialistIHS0-5yrsSecret
Configuration Management SpecialistIIHS/Associate's5-10yrsSecret/TS
Configuration Management SpecialistIIIBA/BS10-15yrsTS
Configuration Management SpecialistIVMS15yrs +TS
Contract Officer/Contracts ManagerIHS0-5yrsSecret
Contract Officer/Contracts ManagerIIHS/Associate's5-10yrsSecret/TS
Contract Officer/Contracts ManagerIIIBA/BS10-15yrsTS
Contract Officer/Contracts ManagerIVMS15yrs +TS
Cyber Security SpecialistIHS0-5yrsSecret
Cyber Security SpecialistIIHS/Associate's5-10yrsSecret/TS
Cyber Security SpecialistIIIBA/BS10-15yrsTS
Cyber Security SpecialistIVMS15yrs +TS
Database SpecialistIHS0-5yrsSecret
Database SpecialistIIHS/Associate's5-10yrsSecret/TS
Database SpecialistIIIBA/BS10-15yrsTS
Database SpecialistIVMS15yrs +TS
Financial ManagerIHS0-5yrsSecret
Financial ManagerIIHS/Associate's5-10yrsSecret/TS
Financial ManagerIIIBA/BS10-15yrsTS
Financial ManagerIVMS15yrs +TS
Helpdesk SpecialistIHS0-5yrsSecret
Helpdesk SpecialistIIHS/Associate's5-10yrsSecret/TS
Helpdesk SpecialistIIIBA/BS10-15yrsTS
Helpdesk SpecialistIVMS15yrs +TS
Information Assurance/Security SpecialistIHS0-5yrsSecret
Information Assurance/Security SpecialistIIHS/Associate's5-10yrsSecret/TS
Information Assurance/Security SpecialistIIIBA/BS10-15yrsTS
Information Assurance/Security SpecialistIVMS15yrs +TS
Information Specialist/Knowledge EngineerIHS0-5yrsSecret
Information Specialist/Knowledge EngineerIIHS/Associate's5-10yrsSecret/TS
Information Specialist/Knowledge EngineerIIIBA/BS10-15yrsTS
Information Specialist/Knowledge EngineerIVMS15yrs +TS
Network SpecialistIHS0-5yrsSecret
Network SpecialistIIHS/Associate's5-10yrsSecret/TS
Network SpecialistIIIBA/BS10-15yrsTS
Network SpecialistIVMS15yrs +TS
Program ManagerIHS0-5yrsSecret
Program ManagerIIHS/Associate's5-10yrsSecret/TS
Program ManagerIIIBA/BS10-15yrsTS
Program ManagerIVMS15yrs +TS
Project ManagerIHS0-5yrsSecret
Project ManagerIIHS/Associate's5-10yrsSecret/TS
Project ManagerIIIBA/BS10-15yrsTS
Project ManagerIVMS15yrs +TS
Quality Assurance SpecialistIHS0-5yrsSecret
Quality Assurance SpecialistIIHS/Associate's5-10yrsSecret/TS
Quality Assurance SpecialistIIIBA/BS10-15yrsTS
Quality Assurance SpecialistIVMS15yrs +TS
Software DeveloperIHS0-5yrsSecret
Software DeveloperIIHS/Associate's5-10yrsSecret/TS
Software DeveloperIIIBA/BS10-15yrsTS
Software DeveloperIVMS15yrs +TS
Systems AdministratorIHS0-5yrsSecret
Systems AdministratorIIHS/Associate's5-10yrsSecret/TS
Systems AdministratorIIIBA/BS10-15yrsTS
Systems AdministratorIVMS15yrs +TS
Systems EngineerIHS0-5yrsSecret
Systems EngineerIIHS/Associate's5-10yrsSecret/TS
Systems EngineerIIIBA/BS10-15yrsTS
Systems EngineerIVMS15yrs +TS
Technical WriterIHS0-5yrsSecret
Technical WriterIIHS/Associate's5-10yrsSecret/TS
Technical WriterIIIBA/BS10-15yrsTS
Technical WriterIVMS15yrs +TS
Test Engineer LevelIHS0-5yrsSecret
Test Engineer LevelIIHS/Associate's5-10yrsSecret/TS
Test Engineer LevelIIIBA/BS10-15yrsTS
Test Engineer LevelIVMS15yrs +TS
Voice/Data Communications EngineerIHS0-5yrsSecret
Voice/Data Communications EngineerIIHS/Associate's5-10yrsSecret/TS
Voice/Data Communications EngineerIIIBA/BS10-15yrsTS
Voice/Data Communications EngineerIVMS15yrs +TS

Pricing Summary

HDTRA1-18-R-0045
Offeror:NOTE: totals in this Summary should reflect the sum of the totals from Task Orders 1 and 2
(insert Company Name)
$ - 0
Proposal Cost Summary
Base PeriodOption Period 1Option Period 2Option Period 3Option Period 4Task Total
Proposed HoursProposed Direct CostProposed HoursProposed Direct CostProposed HoursProposed Direct CostProposed HoursProposed Direct CostProposed HoursProposed Direct CostProposed HoursProposed Direct Cost
Direct Labor Subtotal

Fringe Benefits on Labor

Other Direct Costs (ODC)

Subctrontract Costs (if not included in labor)

Overhead

G & A

Facilities Cost of Money (COM)

Fixed Fee

Total Price

TO 1

Pricing Template - Sample
HDTRA1-18-R-0045Instructions for Task Order Pricing Worksheets: PWS performance objectives are provided as an example of one way to group the tasks for pricing the Task order, however, the Offeror is free to organize the tasks differently to more easily align with the proposed approach or solution. These worksheets do not include any formulas for calculations or autopopulating data from the detail sheets to the Summary tab since the Offeror is free to add, delete or combine rows or tasks which could impact any prepopulated formulas. Feel free to add formulas as needed.
Offeror:
(insert Company Name)
Task Order 1; IT Solution Engineering and Systems Test Support
Base PeriodOption Period 1Option Period 2Option Period 3Option Period 4Task Total
Proposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct Cost
Direct Labor
- 3.1 Task Order Mgmt
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.2 Requirements Analysis
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.3 Assessments and Reviews
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.4 IT Solution Development and Development Support
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.5 Incidental Procurement to Support Proof of Concept or Rapid Prototyping
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.6 IT Systems Testing Support Services
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.7 Task Order Transition Out
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.8 Task Order Transition - In
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- Other Direct Tasks
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category

TO 1 Direct Labor Subtotal

Fringe Benefits on Labor

Other Direct Costs (ODC)Use "plug" numbers provided
- Travel$30,000
- Incidental Procurement$200,000
- Other$1,200

TO 1 ODC Subtotal

Subctrontract Costs (if not included in labor)
- Subcontract #1
- Subcontract #2
Overhead
- Overhead on Labor
- Overhead on Materials/Handling
- Overhead onSubcontracts

G & A **

Facilities Cost of Money (COM)

Fixed Fee

Total Task Order 1
** NOTE: For G&A costs. This line is intended to reflect the total G&A. If your accounting system applies G&A at different rates for various cost elements feel free to insert rows as needed to show the various G&A cost factors and include appropriate G&A at that cost factor (ie, G&A associated with Travel), then total all teh contributing factors to arrive at a G&A Total figure for this G&A row, and to carry forward to the "Pricing Summary" Tab where all costs are summarized by category.

TO 2

Pricing Template - SampleInstructions for Task Order Pricing Worksheets: PWS performance objectives are provided as an example of one way to group the tasks for pricing the Task order, however, the Offeror is free to organize the tasks differently to more easily align with the proposed approach or solution. These worksheets do not include any formulas for calculations or autopopulating data from the detail sheets to the Summary tab since the Offeror is free to add, delete or combine rows or tasks which could impact any prepopulated formulas. Feel free to add formulas as needed.
HDTRA1-18-R-0045
Offeror:
(insert Company Name)
Task Order 2; Knowledge Management Solutions and Support
Base PeriodOption Period 1Option Period 2Option Period 3Option Period 4Task Total
Proposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct CostProposed HoursRateProposed Direct Cost
Direct Labor
- 3.1 Implement and Mature the DTRA KM Strategy
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.2 KM Technology Solutions and Support
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.3 Business Intelligence/Analytics/Process Improvement Requirement
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.4 Records Management Requirement
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.5 Task Order Transition In
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.6 Task Order Transition Out
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- 3.7 Task Order Management
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
- Other Direct Tasks
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category
-- DTRA defined Labor Category-- Offeror's equivalent Labor Category

TO 2 Direct Labor Subtotal

Fringe Benefits on Labor

Other Direct Costs (ODC)Use "plug" numbers provided
- Travel$15,000
- Incidental Procurement$50,000
- Other$1,200

TO 2 ODC Subtotal

Subctrontract Costs (if not included in labor)
- Subcontract #1
- Subcontract #2
Overhead
- Overhead on Labor
- Overhead on Materials/Handling
- Overhead onSubcontracts

G & A

Facilities Cost of Money (COM)

Fixed Fee

Total Task Order 2

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