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 | |
| Basic IDIQ | $ 67,375,000.00 |
| TO 0001 | $ 9,625,000.00 |
| 6-month extension | $ 4,812,500.00 |
| Total Evaluated Price | $ 77,000,000.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 (NTE $9.3M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 6 | CBCSE Installation Services, Labor(NTE $9M) | 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 $21M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 9 | CBCSE Materials, Equipment, and ODCs (NTE $27.3M) | 1 | LOT | $0 |
| 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 $11.7M) | 1 | LOT | $11,175,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 12 | BCTC-ES Travel (NTE $6M) | 1 | LOT | $6,000,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 13 | CBCSE Travel (NTE $7.5M) | 1 | LOT | $7,500,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 14 | CMRA | 1 | LOT | |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 15 | CDRLs | 1 | LOT | |
| 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) | $28,875,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(NTE $6.2M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1006 | CBCSE Installation Services, Labor (NTE $6M) | 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 |
| 1007 | BCTC-ES Materials, Equipment, and ODCs (NTE $14M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1009 | CBCSE Materials, Equipment, and ODCs (NTE $18.2M) | 1 | LOT | $0 |
| 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 $7.45M) | 1 | LOT | $7,450,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1012 | BCTC-ES Travel (NTE $4M) | 1 | LOT | $4,000,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1013 | CBCSE Travel (NTE $5M) | 1 | LOT | $5,000,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1014 | CMRA | 1 | LOT | |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1015 | CDRLs | 1 | LOT | |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 1016 | Customer Support | 24 | Monthly | $0 |
| FFP |
Option 1 (24 Month PoP) $19,250,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(NTE $6.2M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2006 | CBCSE Installation Services, Labor(NTE $6M) | 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 $14M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2009 | CBCSE Materials, Equipment, and ODCs (NTE $18.2M) | 1 | LOT | $0 |
| 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 $7.45M) | 1 | LOT | $7,450,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2012 | BCTC-ES Travel (NTE $4M) | 1 | LOT | $4,000,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2013 | CBCSE Travel (NTE $5M) | 1 | LOT | $5,000,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2014 | CMRA | 1 | LOT | |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 2015 | CDRLs | 1 | LOT | |
| 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) | $19,250,000 | |||
| IDIQ TOTAL | $67,375,000 | |||
| 6-month Contract Extension (FAR 52.217-8 Option to Extend) | $4,812,500 | |||
| Total ID/IQ with 6-month Option to Extend | $72,187,500 |
TO 0001
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 (NTE $3.1M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 6 | CBCSE Installation Services, Labor (NTE $3M) | 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 $7M) | 1 | LOT | $0 |
| CPFF |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 9 | CBCSE Materials, Equipment, and ODCs (NTE $9.1M) | 1 | LOT | $0 |
| 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.7M) | 1 | LOT | $3,725,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 12 | BCTC-ES Travel (NTE $2M) | 1 | LOT | $2,000,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 13 | CBCSE Travel (NTE $2.5M) | 1 | LOT | $2,500,000 |
| COST |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 14 | CMRA | 1 | LOT | $0 |
| NSP |
| CLIN | DESCRIPTION | QUANTITY | U/I | AMOUNT |
| 15 | CDRLs | 1 | LOT | $0 |
| 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 $9,625,000
Example Parts Lists Offeror's Name: "Offeror"
| Instructions: |
| Information pruposes only. This is an example template that can be used during execution. |
| TSE Purchase Quantities by Type | JLCCTC v9.0 DIV LE (Static) | JLCCTC v9.0 VTCF (Mobile) | JLCCTC DIV LE v8.1 DELTA Upgrade to JLCCTC v9.0 | JLCCTC BDE LE or BDE LE (MOBILE) v8.1 DELTA Upgrade to JLCCTC v9.0 | ||||||
| Category | Configuration | Unit Cost | Count | Total | Count | Total | Count | Total | Count | Total |
| Infrastructure | Master Console | 0 | $0.00 | 1 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | Cisco Catalyst Switch Config 5 | 0 | $0.00 | 1 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| CHP | Dell Laptop | 0 | $0.00 | 1 | $0.00 | 0 | $0.00 | 1 | $0.00 | |
| CHP | Dell 7820 | 9 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | ||
| Server | HP DL360 GEN# Config 2 | 2 | $0.00 | 2 | $0.00 | $0.00 | 0 | $0.00 | ||
| CHP | Dell 7920 | 1 | $0.00 | 1 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure (Set of 58) | Cat6 Cables Config 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | |
| Infrastructure | HPE MSA 2.4TB 12G SAS 10K 2.5IN 512E HDD | 24 | $0.00 | 0 | $0.00 | 24 | $0.00 | 24 | $0.00 | |
| Infrastructure | Cisco Nexus Switch Config 4 | 2 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | DAC Config 1 | 2 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | Monitor Config 1b | 20 | $0.00 | 6 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | PDU Config 1 | 4 | $0.00 | 4 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | Rack Config 1c | 1 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | Rack Config 2 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | Rack Drawer Config 1 | 0 | $0.00 | 1 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | SAN Config 1 | 1 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | BUFFALO MediaStation Portable BDXL Blu-ray Writer - BDXL drive - USB 2.0 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | |
| Infrastructure | Tripp Lite USB 3.0 to SATA Hard Drive Flat Quick Dock 2.5in 3.5in HDD SSD | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | |
| Infrastructure | TP-Link Gigabit Adapter USB to RJ45 Gigabit Ethernet LAN Network Adapter | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 1 | $0.00 | |
| Infrastructure | UPS Config 1 | 2 | $0.00 | 2 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Server | HP DL360 GEN# Config 1 | 9 | $0.00 | 0 | $0.00 | 2 | $0.00 | 2 | $0.00 | |
| CDS | Dell R640 Server Config 10 (Rialto) | 1 | $0.00 | 0 | $0.00 | 1 | $0.00 | 1 | $0.00 | |
| Server | PowerEdge M640 Server VRTX Config 1 | 0 | $0.00 | 3 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | Cisco Switch USB to RJ-45 Rollover Cable Config 1 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| Infrastructure | Monitor Config 2 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| TC | Thin Client Config 1 | 9 | $0.00 | 6 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| TC | Thin Client Config 3 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| HW Cost by enclave | $0.00 | $0.00 | $0.00 | $0.00 |
| TE Purchase Quantities by Type | Small MTC | |||
| Category | Configuration | Unit Cost | Count | Total |
| Xerox VersaLink C405/YDN Color LED | C405/YDN | 1 | $0.00 | |
| MODEL 1201CC HIGH SECURITY SHREDDER | 6001201CC | 1 | $0.00 | |
| Smart Card Reader Kit For MFP B405/C405, For CAC | MFP B405/C405 | 15 | $0.00 | |
| 550-Sheet Feeder, Adjustable Up To A4/Legal | Any | 15 | $0.00 | |
| Stand for VersaLink B400 | Any | 15 | $0.00 | |
| 2 Additional Years Service; Extended On-Site Service | NA | 15 | $0.00 | |
| Axis PTZ Camera | 01752-004 | 1 | $0.00 | |
| Axis RJ45 Connector 5m | 5502-731 | 1 | $0.00 | |
| RJ45 F/F in line coupler | N234-001-WH | 1 | $0.00 | |
| 4WD Articulating Boom Lift 1 day | United | 1 | $0.00 | |
| POWER CONDITIONER, 2 OUTLET 8 AMP W/EMI/RMI FILTER,VOLT | SURSA82 | 20 | $0.00 | |
| CABLE, 3 FT HDMI INTERFACE CABLE | CRECBLHD3 | 20 | $0.00 | |
| CABLE, 6 FT HDMI INTERFACE CABLE | CRECBLHD6 | 1 | $0.00 | |
| CABLE, 12 FT HDMI INTERFACE CABLE | CRECBLHD12 | 19 | $0.00 | |
| PROJECTOR, WUXGA 5000 LUMEN 20LB LASER 5000:1 W/L (LXMU500Z) | CAN2632C002 | 20 | $0.00 | |
| MOUNT KIT, RPMAUW, CMS440, CMS006W | CHIKITES006W | 4 | $0.00 | |
| CEILING BOX, XL PLENUM | CHICMA473 | 4 | $0.00 | |
| CART, MOBILE, SINGLE MOUNT FOR 70Nah90" Nah BLK w/Rack | VIDMC1000XL | 2 | $0.00 | |
| BRACKET, CICSCO SPEAKERTRACK 60, MOUNTS TRIPOD OR FLAT | VIDBKTST60 | 2 | $0.00 | |
| SOUNDBAR BRACKET, BLACK | VIDSBB | 2 | $0.00 | |
| SURGE PROTECTOR, POWERBAR BRACKET FOR PM SERIES (BLCK) | VIDPMPB | 2 | $0.00 | |
| LCD, 75" 4K/UHD 350 NITS, 77 LBS, 1M:1, HDR10 | LGE75UR340C9UD | 1 | $0.00 | |
| Total | $0.00 |
Labor Descriptions Offeror's Name: "Offeror"
Instructions: For all Labor Categories proposed, the offeror shall populate each yellow cell with the pertinent information as they see fit to get the job done.
| Labor Category | Company | Description of Work Performed | Education Level | Minimum Years of Experience |
| SW ENGINEER (EXAMPLE) | John Doe Inc | 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.
| 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 | Total | Labor Category (Fully Burdened) | Base Period (3 Year Period of Performance) | Option 1 Period (2 Year Period of Performance) | Option 2 Period (2 Year Period of Performance) |
| Program Manager (11-1021) | Program Manager (11-1021) | |||||||||||||||
| Program Controller (Analyst) (13-1111) | Program Controller (Analyst) (13-1111) | |||||||||||||||
| Fielding Manager (11-3071) | Fielding Manager (11-3071) | |||||||||||||||
| Network Engineer, Senior (15-1241) | Network Engineer, Senior (15-1241) | |||||||||||||||
| Network Engineer, Intermediate (15-1241) | Network Engineer, Intermediate (15-1241) | |||||||||||||||
| Logistician (13-1081) | Logistician (13-1081) | |||||||||||||||
| Quality Assurance Specialist (15-1253) | Quality Assurance Specialist (15-1253) | |||||||||||||||
| Configuration Management Specialist (15-1211) | Configuration Management Specialist (15-1211) | |||||||||||||||
| Procurement Specialist (11-3061) | Procurement Specialist (11-3061) | |||||||||||||||
| Quality Assurance Manager (15-1253) | Quality Assurance Manager (15-1253) | |||||||||||||||
| Installation Technician 1 (Intermediate) (49-9099) | Installation Technician 1 (Intermediate) (49-9099) | |||||||||||||||
| Installation Technician 2 (Senior) (49-9099) | Installation Technician 2 (Senior) (49-9099) | |||||||||||||||
| RMF SME (17-2199) | RMF SME (17-2199) | |||||||||||||||
| Software Systems Engineer (17-2199) | 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 (3 Year Period of Performance) | Option 1 Period (2 Year Period of Performance) | Option 2 Period (2 Year Period of Performance) | Definition and Allocation Base | |
| Example | 5.00% | 5.10% | 5.20% | 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 | |||||
| Material Handing | |||||
| Subcontractor Handling | |||||
| G&A | |||||
| Proposed Fee (CPFF) | |||||
| Proposed Profit (FFP) |
File details come from the government source that posted it. Updated .