Attachment L2 - EMBM- J SA Cost and Pricing Worksheet.xlsx
XLSX spreadsheet 112 KB Posted
- Solicitation number
- HC104725R0003
- Issued by
-
Defense Information Systems Agency
About this file
The file is a cost and pricing worksheet for the Defense Information Systems Agency (DISA) Electromagnetic Battle Management Joint (EMBM-J) Situational Awareness (SA) contract (Solicitation Number HC104725R0003). The pricing document outlines a multi-period contract structure with a base period and four option periods, featuring multiple Contract Line Item Numbers (CLINs) across different contract types including Firm Fixed Price (FFP) and Cost Plus Fixed Fee (CPFF). The CLINs cover various technical services such as Agile Program Management, Engineering Support, Software Development, Environment Infrastructure, Helpdesk Support, and optional tasks including migration to DISA Services and Joint Warfighting Cloud Capability.
The total proposed pricing for the contract is $3,624,197.23, which includes Other Direct Costs (ODCs) and Travel expenses, with a 40% Surge CLIN provision. The contract periods show incrementally decreasing costs, starting at $978,114.42 in the base period and reducing to $561,541.05 in Option Period 4. The worksheet provides a detailed template for contractors to break down labor rates, indirect rates, and other cost components, emphasizing the need for transparent cost calculations and supporting documentation. The requirement focuses on developing and enhancing EMBM-J Situational Awareness capabilities, including software development, system administration, and enabling interoperability within joint electromagnetic spectrum operations.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HC104725R0003 AMD 0004.pdf | ||
| HC104725R0003 AMD 0003.pdf | ||
| HC104725R0003 AMD 0002.pdf | ||
| HC104725R0003 AMD 0001.pdf | ||
| Attachment L8 - Questions and Answers Revision 0001.xlsx | XLSX spreadsheet | |
| Attachment L5 - Small Business Participation Plan Revision 0001.docx | DOCX document | |
| Attachment L1 - Betterment.xlsx | XLSX spreadsheet | |
| Attachment J1 - DD Form 254.pdf | ||
| Attachment J2 - Government Furnished Property.xlsx | XLSX spreadsheet | |
| Attachment L5 - Small Business Participation Plan.docx | DOCX document | |
| Attachment L7 - SubK Plan Checklist.docx | DOCX document | |
| HC104725R0003.pdf | ||
| Attachment L6 - SubK or Teaming Partner Past Performance Consent.docx | DOCX document | |
| Attachment L3 - Past Performance References.docx | DOCX document | |
| Attachment J3 - Non-Disclosure Agreement for Contractor Personnel.docx | DOCX document | |
| Attachment L4 - Reading Library Index.xlsx | XLSX spreadsheet | |
| Attachment L8 - Questions and Answers.xlsx | XLSX spreadsheet |
Show all 17
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
Instructions
| Defense Information Systems Agency (DISA) |
| EMBM-J Situational Awareness |
GENERAL INFORMATION
| The Government template is for guidance purposes, and is not all inclusive. This template serves as an illustration of the format and details required to complete the Government cost/price evaluation. |
| The Offeror is responsible to ensure compliance with federal regulations and provide the necessary data as required by the request for proposal (RFP). |
The Offeror shall complete the Government issued template as instructed:
| 1) Complete the CLIN Summary and all corresponding sheets. |
| The Government must be able to verify and track all proposed pricing from the proposed details through to the CLIN Summary. |
| All links to the corresponding sheet/cells shall be made/linked prior to submitting a proposal |
| Note, that it is the Offeror's responsibility to ensure the calculations are correct. |
2) The spreadsheet shall include all formulas.
3) The Offeror shall provide the required detailed as instructed in the RFP.
4) The Contractor shall not include any "pricing notes" in the proposal template.
| 5) The Offeror can add additional rows/columns or tabs in the template as necessary. |
| If additional tabs are necessary to reflect further details, the costs on subordinate tabs shall roll up to the appriopriate sheets. |
| In addition, the Offeror can provide supporting documentation through an attachment if required. The information provided shall allow traceability between the proposed price included in the cost/price template and any provided source information. |
CLIN Summary
| Defense Information Systems Agency (DISA) |
| Pricing Worksheet |
| COMPLETE THE FOLLOWING: | ||||||||||
| Solicitation Title | EMBM-J SA | |||||||||
| Solicitation Number | HC104725R0003 | |||||||||
| Contractor Name | ||||||||||
| Cage Code | ||||||||||
| Date | ||||||||||
| CLIN STRUCTURE SUMMARY | ||||||||||
| CLIN Number | Contract Type | CLIN Description | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Subtotal | 6-Month Extension | Total Proposed Price |
| x001 | FFP | Agile Program Management (O&M) | $0.00 | $0.00 | $0.00 | |||||
| x002 | CPFF | Engineering Support and Outreach (RDT&E) | $0.00 | $0.00 | $0.00 | |||||
| x003 | CPFF | Software Development, Testing, and Delivery – New Capability (RDT&E) | $0.00 | $0.00 | $0.00 | |||||
| x004 | CPFF | Software Development, Testing, and Delivery – Sustainment (O&M) | $0.00 | $0.00 | $0.00 | |||||
| x005 | CPFF | Environment Infrastructure and Operations (O&M) | $0.00 | $0.00 | $0.00 | |||||
| x006 | CPFF | Extensions to Support Specialized User Requests (Optional Task) (RDT&E) | $0.00 | $0.00 | $0.00 | |||||
| x007 | CPFF | Helpdesk Tier II (Optional Task, O&M) | $0.00 | $0.00 | $0.00 | |||||
| x008 | CPFF | Support for Live, Virtual, and Constructive (LVC) Training, Exercises, Experiments, and Demonstrations (Optional Task, O&M) | $0.00 | $0.00 | $0.00 | |||||
| x009 | CPFF | Migration to DISA Services/Joint Warfighting Cloud Capability (JWCC) (Optional Task, RDT&E) | $0.00 | $0.00 | $0.00 | |||||
| x010 | CPFF | Deployment to the JWICS (Optional Task, RDT&E) | $0.00 | $0.00 | $0.00 | |||||
| x011 | CPFF | GOAT Stand-Alone application and EMBM-J SA Interoperability (Optional Task, RDT&E) | $0.00 | $0.00 | $0.00 | |||||
| x012 | COST | Other Direct Costs (ODCs)(O&M) | $630,253.16 | $507,762.00 | $305,510.36 | $314,675.68 | $324,115.95 | $2,082,317.15 | $162,057.97 | $2,244,375.12 |
| x013 | COST | Travel (O&M) | $68,400.00 | $70,452.00 | $72,565.56 | $74,742.53 | $76,984.80 | $363,144.89 | $38,492.40 | $401,637.29 |
| Subtotal: | $698,653.16 | $578,214.00 | $378,075.92 | $389,418.20 | $401,100.75 | $2,445,462.04 | $200,550.37 | $2,646,012.41 | ||
| Total RDT&E Tasks | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Total O&M Tasks | $698,653.16 | $578,214.00 | $378,075.92 | $389,418.20 | $401,100.75 | $2,445,462.04 | $200,550.37 | $2,646,012.41 | ||
| Total Non-Optional RDT&E Tasks | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Total Non-Optional O&M Tasks | $698,653.16 | $578,214.00 | $378,075.92 | $389,418.20 | $401,100.75 | $2,445,462.04 | $200,550.37 | $2,646,012.41 | ||
| 9999 | 40.00% | Surge (Cost Reimbursable NTE) (40% of Subtotal)* | $279,461.26 | $231,285.60 | $151,230.37 | $155,767.28 | $160,440.30 | $978,184.82 | $978,184.82 | |
| TOTAL PROPOSED PRICE: | $978,114.42 | $809,499.61 | $529,306.29 | $545,185.48 | $561,541.05 | $3,423,646.86 | $200,550.37 | $3,624,197.23 |
NOTE 1: *Surge CLIN OF ALL BASE PERIOD and OPTION PERIOD CLINs, excluding 6-mo extension authorized IAW FAR 52.217-8, see subtotal above). Surge CLINs are Cost Reimbursable (CR) Not to exceed (NTE).
NOTE 2: **6-Month Extension - For Evaluation Purposes only. Pricing for Optional 6-month extension authorized in accordance with FAR 52.217-8 shall be identical to the proposed pricing in the six months prior to expiration of the contract (base or option period). CLIN(s) will not appear on contract. Assume all previous option periods have been exercised. The 6-Month Extension column includes a formula to reflect identical pricing of the proposed pricing of the 6 months prior to expiration. DO NOT INCLUDE SURGE CLIN PRICING IN THIS NUMBER.
Base Period
| Defense Information Systems Agency (DISA) |
| Pricing Worksheet |
| Base Period | |||||||||||||||||||||||||||
| Labor | Rate Build | Totals | |||||||||||||||||||||||||
| CLIN # | Company Name (Prime/Sub) | PWS/SOW Task(s) | Labor Category/Item | Contractor/Government Site | Prime Direct Hrly Rate | Subcontract Hrly Rate | Indirect 1 | Indirect 2 | Indirect 3 | Indirect 4 | Indirect 5 | Indirect 6 | Proposed Labor Hr Cost | Fixed Fee | Proposed Fully Burdened Labor Hr Rate | Proposed Labor Hours | Total Direct Labor Cost | Total Subcontract Cost | Total Indirect 1 | Total Indirect 2 | Total Indirect 3 | Total Indirect 4 | Total Indirect 5 | Total Indirect 6 | Total Cost | Total Fixed Fee | Amount |
| 0% | 0% | 0% | 0% | 0% | 0% | 0% | (Column H * S) | (Column I * S) | (Column J * S) | (Column K * S) | (Column L * S) | (Column M * S) | (Column N * S) | (Column O * S) | (Column P * S) | (Column Q * S) | (Column R * S) | ||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| ADD ADDITIONAL ROWS IF NECESSARY | ||||||||||||
| Total Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other Direct Costs (ODCs)(O&M) | $630,253.16 | |||||||||||
| Travel (O&M) | $68,400.00 | |||||||||||
| Total Price | $698,653.16 |
Instructions: Provide detailed cost build-up by contract period—including all source information (i.e. direct and indirect rates), formulas and calculations—to support proposed labor rates for each of the labor categories. In Row 7, include the name of each indirect rate.
Option Period 1
| Defense Information Systems Agency (DISA) |
| Pricing Worksheet |
| Option Period 1 | |||||||||||||||||||||||||||
| Labor | Rate Build | Totals | |||||||||||||||||||||||||
| CLIN # | Company Name (Prime/Sub) | PWS/SOW Task(s) | Labor Category/Item | Contractor/Government Site | Prime Direct Hrly Rate | Subcontract Hrly Rate | Indirect 1 | Indirect 2 | Indirect 3 | Indirect 4 | Indirect 5 | Indirect 6 | Proposed Labor Hr Cost | Fixed Fee | Proposed Fully Burdened Labor Hr Rate | Proposed Labor Hours | Total Direct Labor Cost | Total Subcontract Cost | Total Indirect 1 | Total Indirect 2 | Total Indirect 3 | Total Indirect 4 | Total Indirect 5 | Total Indirect 6 | Total Cost | Total Fixed Fee | Amount |
| 0% | 0% | 0% | 0% | 0% | 0% | 0% | (Column H * S) | (Column I * S) | (Column J * S) | (Column K * S) | (Column L * S) | (Column M * S) | (Column N * S) | (Column O * S) | (Column P * S) | (Column Q * S) | (Column R * S) | ||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| ADD ADDITIONAL ROWS IF NECESSARY | ||||||||||||
| Total Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other Direct Costs (ODCs)(O&M) | $507,762.00 | |||||||||||
| Travel (O&M) | $70,452.00 | |||||||||||
| Total Price | $578,214.00 |
Instructions: Provide detailed cost build-up by contract period—including all source information (i.e. direct and indirect rates), formulas and calculations—to support proposed labor rates for each of the labor categories. In Row 7, include the name of each indirect rate.
Option Period 2
| Defense Information Systems Agency (DISA) |
| Pricing Worksheet |
| Option Period 2 | |||||||||||||||||||||||||||
| Labor | Rate Build | Totals | |||||||||||||||||||||||||
| CLIN # | Company Name (Prime/Sub) | PWS/SOW Task(s) | Labor Category/Item | Contractor/Government Site | Prime Direct Hrly Rate | Subcontract Hrly Rate | Indirect 1 | Indirect 2 | Indirect 3 | Indirect 4 | Indirect 5 | Indirect 6 | Proposed Labor Hr Cost | Fixed Fee | Proposed Fully Burdened Labor Hr Rate | Proposed Labor Hours | Total Direct Labor Cost | Total Subcontract Cost | Total Indirect 1 | Total Indirect 2 | Total Indirect 3 | Total Indirect 4 | Total Indirect 5 | Total Indirect 6 | Total Cost | Total Fixed Fee | Amount |
| 0% | 0% | 0% | 0% | 0% | 0% | 0% | (Column H * S) | (Column I * S) | (Column J * S) | (Column K * S) | (Column L * S) | (Column M * S) | (Column N * S) | (Column O * S) | (Column P * S) | (Column Q * S) | (Column R * S) | ||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| ADD ADDITIONAL ROWS IF NECESSARY | ||||||||||||
| Total Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other Direct Costs (ODCs)(O&M) | $305,510.36 | |||||||||||
| Travel (O&M) | $72,565.56 | |||||||||||
| Total Price | $378,075.92 |
Instructions: Provide detailed cost build-up by contract period—including all source information (i.e. direct and indirect rates), formulas and calculations—to support proposed labor rates for each of the labor categories. In Row 7, include the name of each indirect rate.
Option Period 3
| Defense Information Systems Agency (DISA) |
| Pricing Worksheet |
| Option Period 3 | |||||||||||||||||||||||||||
| Labor | Rate Build | Totals | |||||||||||||||||||||||||
| CLIN # | Company Name (Prime/Sub) | PWS/SOW Task(s) | Labor Category/Item | Contractor/Government Site | Prime Direct Hrly Rate | Subcontract Hrly Rate | Indirect 1 | Indirect 2 | Indirect 3 | Indirect 4 | Indirect 5 | Indirect 6 | Proposed Labor Hr Cost | Fixed Fee | Proposed Fully Burdened Labor Hr Rate | Proposed Labor Hours | Total Direct Labor Cost | Total Subcontract Cost | Total Indirect 1 | Total Indirect 2 | Total Indirect 3 | Total Indirect 4 | Total Indirect 5 | Total Indirect 6 | Total Cost | Total Fixed Fee | Amount |
| 0% | 0% | 0% | 0% | 0% | 0% | 0% | (Column H * S) | (Column I * S) | (Column J * S) | (Column K * S) | (Column L * S) | (Column M * S) | (Column N * S) | (Column O * S) | (Column P * S) | (Column Q * S) | (Column R * S) | ||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| ADD ADDITIONAL ROWS IF NECESSARY | ||||||||||||
| Total Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other Direct Costs (ODCs)(O&M) | $314,675.68 | |||||||||||
| Travel (O&M) | $74,742.53 | |||||||||||
| Total Price | $389,418.20 |
Instructions: Provide detailed cost build-up by contract period—including all source information (i.e. direct and indirect rates), formulas and calculations—to support proposed labor rates for each of the labor categories. In Row 7, include the name of each indirect rate.
Option Period 4
| Defense Information Systems Agency (DISA) |
| Pricing Worksheet |
| Option Period 4 | |||||||||||||||||||||||||||
| Labor | Rate Build | Totals | |||||||||||||||||||||||||
| CLIN # | Company Name (Prime/Sub) | PWS/SOW Task(s) | Labor Category/Item | Contractor/Government Site | Prime Direct Hrly Rate | Subcontract Hrly Rate | Indirect 1 | Indirect 2 | Indirect 3 | Indirect 4 | Indirect 5 | Indirect 6 | Proposed Labor Hr Cost | Fixed Fee | Proposed Fully Burdened Labor Hr Rate | Proposed Labor Hours | Total Direct Labor Cost | Total Subcontract Cost | Total Indirect 1 | Total Indirect 2 | Total Indirect 3 | Total Indirect 4 | Total Indirect 5 | Total Indirect 6 | Total Cost | Total Fixed Fee | Amount |
| 0% | 0% | 0% | 0% | 0% | 0% | 0% | (Column H * S) | (Column I * S) | (Column J * S) | (Column K * S) | (Column L * S) | (Column M * S) | (Column N * S) | (Column O * S) | (Column P * S) | (Column Q * S) | (Column R * S) | ||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| ADD ADDITIONAL ROWS IF NECESSARY | ||||||||||||
| Total Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other Direct Costs (ODCs)(O&M) | $324,115.95 | |||||||||||
| Travel (O&M) | $76,984.80 | |||||||||||
| Total Price | $401,100.75 |
Instructions: Provide detailed cost build-up by contract period—including all source information (i.e. direct and indirect rates), formulas and calculations—to support proposed labor rates for each of the labor categories. In Row 7, include the name of each indirect rate.
Rate Sheet
| Tab Instructions |
| Fill in blue-shaded cells for Prime labor category and fully burdened labor rate |
| LABOR RATES | ||||||||||||
| LCAT# | Proposed Labor Category | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | ||||||
| Employee Name/Bid Code | Government/Contractor Site | Actual Location of Performance (city, state) | No. of Years Experience | Fully Burdened Labor Hr Rate | Fully Burdened Labor Hr Rate | Fully Burdened Labor Hr Rate | Fully Burdened Labor Hr Rate | Fully Burdened Labor Hr Rate | Basis | Supporting Detail Ref | ||
| PRIME LABOR | ADD ADDITIONAL ROWS IF NECESSARY | |||||||||||
| 1 | ex. Commercial Price list | Attachment ABC | ||||||||||
| 2 | ||||||||||||
| 3 | ||||||||||||
| 4 | ||||||||||||
| 5 | ||||||||||||
| 6 | ||||||||||||
| 7 | ||||||||||||
| 8 | ||||||||||||
| 9 | ||||||||||||
| 10 | ||||||||||||
| SUBCONTRACTOR LABOR | ADD ADDITIONAL ROWS IF NECESSARY | |||||||||||
| 1 | ex. Commercial Price list | Attachment ABC | ||||||||||
| 2 | ||||||||||||
| 3 | ||||||||||||
| 4 | ||||||||||||
| 5 | ||||||||||||
| 6 | ||||||||||||
| 7 | ||||||||||||
| 8 | ||||||||||||
| 9 | ||||||||||||
| 10 |
| Indirect Rates | ||||||||||
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | ||||||
| # | Rate Category | Corporate Segment/ | ||||||||
| Bid Code | Rate | Rate | Rate | Rate | Rate | Basis of Rate | ||||
| (Ex: FPRA, FPRP, Provisional Billing, etc.) | Supporting Data Reference | |||||||||
| 1 | e.g. Fringe, Overhead, G&A, etc. | (e.g. Tab B) | ||||||||
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 |
File details come from the government source that posted it. Updated .