Attachment 10 BCTE Cost-Pricing Workbook.xlsx
XLSX spreadsheet 2 MB Posted
- Solicitation number
- W900KK-23-R-0009RFP
View the file
Other files
Show 40 more
50 files listed here. See the rest on GovTribe.
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
| Cost and Pricing WORKBOOK: Offerors shall complete the yellow highlighted sections of this workbook. Instrcutions are in grey boxes on each tab. |
| PRICING: |
All direct labor and all indirect costs shall be priced in accordance with (IAW) the Rate Schedules set forth in this workbook. All direct and indirect not-to-exceed caps shall be binding for the length of the contract period and extend to include any TO or TO option period. These rates represent the burdened labor rates for each labor category and will apply to all related direct labor hours to be applied throughout the effective period of the contract. The fully burdened hourly rates represent not-to-exceed cap rates.
The burdened labor rates shall include all direct, indirect (fringe and overhead), general and administrative costs, other Offeror-specific applicable costs, and profit .
Total Evaluated Price Offeror's Name: "Offeror"
| Total Evaluated Price | |
| Amount | |
| IDIQ (Base and 2 Options) | $ 200,118,000.00 |
| TO 0001 | $ 30,562,000.00 |
| 6-month extension | $ 14,487,500.00 |
| Total Evaluated Price | $ 245,167,500.00 |
Note: This worksheet bring totals forward from the Basic IDIQ & TO 0001 Tabs.
Basic IDIQ Offeror's Name: "Offeror"
| BASIC IDIQ | ||||
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1 | Program Management | 36 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2 | Help Desk Support (includes: RWIS Help Desk, IA Support, and Video Telecon Help Desk Support) | 36 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 3 | BCTC-ES Site Surveys | 36 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 4 | CBCSE Site Surveys | 36 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 5 | BCTC-ES Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 6 | CBCSE Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 7 | Elecrtonic Security Systems (ESS) Support | 36 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 8 | BCTC-ES Materials, Equipment, and ODCs (NTE $37M) | 1 | LOT | $37,000,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 9 | CBCSE Materials, Equipment, and ODCs (NTE $33.6M) | 1 | LOT | $33,600,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 10 | BCTC-ES Software Licenses (NTE $4.2M) | 1 | LOT | $4,200,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 11 | CBCSE Software Licenses (NTE $10M) | 1 | LOT | $10,000,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 12 | BCTC-ES Travel (NTE $1.46M) | 1 | LOT | $1,460,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 13 | CBCSE Travel (NTE $228K) | 1 | LOT | $228,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 14 | Service Contract Reporting | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 15 | CDRLs | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 16 | Customer Support | 36 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 17 | Phase In | 1 | LOT | $0 |
| FFP |
| Base (36 Month PoP) | $86,488,000 | |||
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1001 | Program Management | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1002 | Help Desk Support (includes: RWIS Help Desk, IA Support, and Video Telecon Help Desk Support) | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1003 | BCTC-ES Site Surveys | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1004 | CBCSE Site Surveys | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1005 | BCTC-ES Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1006 | CBCSE Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1007 | Elecrtonic Security Systems (ESS) Support | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1008 | BCTC-ES Materials, Equipment, and ODCs (NTE $26.3M) | 1 | LOT | $26,300,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1009 | CBCSE Materials, Equipment, and ODCs (NTE $22M) | 1 | LOT | $22,000,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1010 | BCTC-ES Software Licenses (NTE $2.8M) | 1 | LOT | $2,800,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1011 | CBCSE Software Licenses (NTE $3.6M) | 1 | LOT | $3,600,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1012 | BCTC-ES Travel (NTE $950K) | 1 | LOT | $950,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1013 | CBCSE Travel (NTE $30K) | 1 | LOT | $30,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1014 | Service Contract Reporting | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1015 | CDRLs | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1016 | Customer Support | 24 | Monthly | $0 |
| FFP |
Option 1 (24 Month PoP) $55,680,000
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2001 | Program Management | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2002 | Help Desk Support (includes: RWIS Help Desk, IA Support, and Video Telecon Help Desk Support) | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2003 | BCTC-ES Site Surveys | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2004 | CBCSE Site Surveys | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2005 | BCTC-ES Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2006 | CBCSE Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2007 | Elecrtonic Security Systems (ESS) Support | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2008 | BCTC-ES Materials, Equipment, and ODCs (NTE $25.3M) | 1 | LOT | $25,300,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2009 | CBCSE Materials, Equipment, and ODCs (NTE $24.6M) | 1 | LOT | $24,600,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2010 | BCTC-ES Software Licenses (NTE $2.8M) | 1 | LOT | $2,800,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2011 | CBCSE Software Licenses (NTE $3.7M) | 1 | LOT | $3,700,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2012 | BCTC-ES Travel (NTE $1.25M) | 1 | LOT | $1,250,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2013 | CBCSE Travel (NTE $300K) | 1 | LOT | $300,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2014 | Service Contract Reporting | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2015 | CDRLs | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2016 | Customer Support | 24 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2017 | Phase Out | 1 | LOT | $0 |
| FFP | ||||
| OPTION | ||||
| Option 2 (24 Month PoP) | $57,950,000 | |||
| IDIQ TOTAL | $200,118,000 | |||
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 4001 | Six (6) Month Extension FAR 52.217-8 | 6 | Month | $14,487,500 |
| FFP | ||||
| OPTION | ||||
| Total ID/IQ with 6-month Option to Extend | $214,605,500 |
TO 01
Offeror's Name: "Offeror"
| TO 0001 | ||||
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1 | Program Management | 12 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2 | Help Desk Support (includes: RWIS Help Desk, IA Support, and Video Telecon Help Desk Support) | 12 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 3 | BCTC-ES Site Surveys | 12 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 4 | CBCSE Site Surveys | 12 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 5 | BCTC-ES Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 6 | CBCSE Installation Services, Labor | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 7 | Elecrtonic Security Systems (ESS) Support | 12 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 8 | BCTC-ES Materials, Equipment, and ODCs (NTE $11M) | 1 | LOT | $11,000,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 9 | CBCSE Materials, Equipment, and ODCs (NTE $14.3M) | 1 | LOT | $14,300,000 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 10 | BCTC-ES Software Licenses (NTE $1.4M) | 1 | LOT | $1,400,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 11 | CBCSE Software Licenses (NTE $3.3M) | 1 | LOT | $3,300,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 12 | BCTC-ES Travel (NTE $480K) | 1 | LOT | $480,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 13 | CBCSE Travel (NTE $82K) | 1 | LOT | $82,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 14 | CMRA | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 15 | CDRLs | 1 | LOT | NSP |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 16 | Customer Support | 12 | Monthly | $0 |
| FFP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 17 | Phase In | 1 | LOT | $0 |
| FFP |
TO 0001 Total $30,562,000
Labor Descriptions Offeror's Name: "Offeror"
Instructions: For all Labor Categories provided by the USG, the Offeror will use its naming convention for each labor category which matches the Description, Education Level and Years of Experience provided below. If additional labor categories other than the ones provided are need in order for the Offeror to accomplish its technical approach, additional labor categories can be added to the list by each Offeror providing the information required in each column.
| Labor Category (Provided by USG) | Offeror Category | Description of Work Performed | Education Level | Minimum Years of Experience |
| Installation Technician 1 (Intermediate) (EXAMPLE) | Installation Tech (Journeyman) | EXAMPLE: Designs and develops software applications. Performs coding, debugging, testing and troubleshooting throughout the application development process. Requires a bachelor's degree. Typically reports to a manager. Gaining exposure to some of the complex tasks within the job function. Occasionally directed in several aspects of the work. | Bachelors | Typically requires 2 to 4 years of related experience. |
| Program Manager | Plan, direct, or coordinate the operations of public or private sector organizations, overseeing multiple departments or locations. Duties and responsibilities include formulating policies, managing daily operations, and planning the use of materials and human resources, but are too diverse and general in nature to be classified in any one functional area of management or administration, such as personnel, purchasing, or administrative services. Usually manage through subordinate supervisors. Excludes First-Line Supervisors. | Master’s degree in Business Administration (Current Project Management Professional certification preferred) | related technical field with 10 years of experience in Program Management. | |
| Program Controller (Analyst) | Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants. | Bachelor's Degree | 5 | |
| Fielding Manager | Plan, direct, or coordinate transportation, storage, or distribution activities in accordance with organizational policies and applicable government laws or regulations. Includes logistics managers | Bachelor's/Master's Degree | 7 | |
| Network Engineer, Senior | This individual must have a degree of expertise with the following systems/protocols: Microsoft Server 2012 R2, Cisco Call Manager, access and core switches, routers, firewalls and at least one of the following current certifications: Microsoft Certified Systems Engineer, Cisco Certified Network Professional Routing and Switching. | Bachelor’s degree in Computer Science, Information Technology | At least seven (7) years of experience in Information Assurance technology or a related area. | |
| Network Engineer, Intermediate | Design and implement computer and information networks, such as local area networks (LAN), wide area networks (WAN), intranets, extranets, and other data communications networks. Perform network modeling, analysis, and planning, including analysis of capacity needs for network infrastructures. May also design network and computer security measures. May research and recommend network and data communications hardware and software. | Bachelors Degree | 5 | |
| Logistician | Analyze and coordinate the ongoing logistical functions of a firm or organization. Responsible for the entire life cycle of a product, including acquisition, distribution, internal allocation, delivery, and final disposal of resources. | Bachelors Degree | 3 | |
| Quality Assurance Specialist | Develop and execute software tests to identify software problems and their causes. Test system modifications to prepare for implementation. Document software and application defects using a bug tracking system and report defects to software or web developers. Create and maintain databases of known defects. May participate in software design reviews to provide input on functional requirements, operational characteristics, product designs, and schedules. | Bachelors Degree | 5 | |
| Configuration Management Specialist | Analyze science, engineering, business, and other data processing problems to develop and implement solutions to complex applications problems, system administration issues, or network concerns. Perform systems management and integration functions, improve existing computer systems, and review computer system capabilities, workflow, and schedule limitations. May analyze or recommend commercially available software. | Bachelors Degree | 5 | |
| Procurement Specialist | Plan, direct, or coordinate the activities of buyers, purchasing officers, and related workers involved in purchasing materials, products, and services. Includes wholesale or retail trade merchandising managers and procurement managers. | Bachelors Degree | 5 | |
| Quality Assurance Manager | Develop and execute software tests to identify software problems and their causes. Test system modifications to prepare for implementation. Document software and application defects using a bug tracking system and report defects to software or web developers. Create and maintain databases of known defects. May participate in software design reviews to provide input on functional requirements, operational characteristics, product designs, and schedules. | Bachelors Degree | 5 | |
| Installation Technician 1 (Intermediate) | All installation, maintenance, and repair workers | Associate Degree or Certification | 5 | |
| Installation Technician 2 (Senior) | All installation, maintenance, and repair workers | Associate Degree or Certification | 5 | |
| RMF SME | Risk Management Framework Subject Matter Expert | Bachelors Degree | 5 | |
| Electronic Security Systems SME | ESS Subject Matter Experts (SMEs) shall hold current certification with Lenel, DAQ, Software House, Pelco, and Axis certifications. SMEs are defined as technicians who perform maintenance and services on any of the above-mentioned ESS systems and/or equipment. | Associate Degree or Certification | The Contractor and/or any Subcontractors shall have, as a minimum, one (1) technician having a at least three (3) years of certified system experience and an additional technician having at least one-year certified system experience in maintenance and repair on systems equal in size, type and complexity of the systems indicated. | |
| Software Systems Engineer | Develop and execute software tests to identify software problems and their causes. Test system modifications to prepare for implementation. Document software and application defects using a bug tracking system and report defects to software or web developers. Create and maintain databases of known defects. May participate in software design reviews to provide input on functional requirements, operational characteristics, product designs, and schedules. | Bachelor’s degree in Computer Science, Information Technology | 5 |
Labor Rates Offeror's Name: "Offeror"
Instructions: In the first section (Columns B-N) the offeror will input their base rate for the Base Period each labor category proposed and then apply indirect rates to demonstrate the development of the fully burdened rate through profit for the Base Period. The offeror can adjust this worksheet as needed to complete the calculation. In the second section (Columns P-W) input the fully burdened rate for each category, for each base and option period. If additional labor categories other than the ones provided are need in order for the Offeror to accomplish its technical approach, additional labor categories can be added to the list by each Offeror.
| Base Period Fully Burdened Rate Build-up | Fully Burdened Rate Ceilings | |||||||||||||||||
| Labor Category | Base Labor Rate | Fringe Rate | Fringe Dollars | Sub-Total | Overhead Rate | Overhead Dollars | Sub-Total | G&A Rate | G&A Dollars | Sub-Total | Profit/Fee | Total | Base Period (Year 2) | Base Period (Year 3) | Option Period 1 (Year 1) | Option Period 1 (Year 2) | Option Period 2 (Year 1) | Option Period 2 (Year 2) |
| Program Manager (11-1021) | ||||||||||||||||||
| Program Controller (Analyst) (13-1111) | ||||||||||||||||||
| Fielding Manager (11-3071) | ||||||||||||||||||
| Network Engineer, Senior (15-1241) | ||||||||||||||||||
| Network Engineer, Intermediate (15-1241) | ||||||||||||||||||
| Logistician (13-1081) | ||||||||||||||||||
| Quality Assurance Specialist (15-1253) | ||||||||||||||||||
| Configuration Management Specialist (15-1211) | ||||||||||||||||||
| Procurement Specialist (11-3061) | ||||||||||||||||||
| Quality Assurance Manager (15-1253) | ||||||||||||||||||
| Installation Technician 1 (Intermediate) (49-9099) | ||||||||||||||||||
| Installation Technician 2 (Senior) (49-9099) | ||||||||||||||||||
| RMF SME (17-2199) | ||||||||||||||||||
| Electronic Security Systems SME | ||||||||||||||||||
| Software Systems Engineer (17-2199) |
Indirect Rates Offeror's Name: "Offeror"
| Instructions: |
| 1. If any of the rates/factors are not used in your indirect rate structures in your accounting system, leave the blocks empty and enter "Not Applicable" in the column titled "Definition and Allocation Base". |
| 2. Each Offeror shall supply their applicable rates for all years and a description and/or calculation of how their rates/factors were developed. That information can be included either below or elsewhere in your Cost/Price Volume. |
| 3. In the " Definition and Allocation Base" column, as a minimum, include a brief comment describing the base used for application of each indirect rate: For example, G&A would be, Total Cost Input, Single Element (Direct Labor Cost) or Value Added (excludes …. and … ). Overhead may be direct labor or direct labor plus fringe. |
| 4. If you have additional rates/factors as part of your indirect rate structure as defined in your accounting policies and procedures, you can add rows or columns as needed. |
| Rates | Base Period (Year 1) | Base Period (Year 2) | Base Period (Year 3) | Option Period 1 (Year 1) | Option Period 1 (Year 2) | Option Period 2 (Year 1) | Option Period 2 (Year 2) | Definition and Allocation Base | |
| Example | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | These rates are samples to show formula breakout.* | Identify Where in the Proposal the Basis of Estimate for Each Rate is Located. |
| Base Labor Rate Escalation | |||||||||
| Labor Fringe | |||||||||
| Overhead Onsite (Government) | |||||||||
| Overhead Offsite (Contractor Site) | |||||||||
| Material Handing | |||||||||
| Subcontractor Handling | |||||||||
| G&A | |||||||||
| Proposed Fee (CPFF) | |||||||||
| Proposed Profit (FFP) |
File details come from the government source that posted it. Updated .