I.B.08 ATTACHMENT B - Price Worksheet.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- Technical and Programmatic Support Services (TPSS) MATOC Generation 2 Federal contract opportunity
- Solicitation number
- W912DY20R0088
About this file
This document contains a price worksheet template and details of a federal contract opportunity for Technical and Programmatic Support Services. The price worksheet template outlines 27 labor categories with required fully burdened hourly rates for the base year and four option years. It specifies that proposed profit percentages and composite markups are binding for the life of the contract. The federal contract opportunity is a Multiple Award Task Order Contract solicitation from the U.S. Army Corps of Engineers Engineering Support Center Huntsville for Technical and Programmatic Support Services in areas including electronic security systems, utility monitoring and control systems, and cybersecurity. The scope of work involves quality oversight, criteria development, facility control system inventories, and support to Army and DoD agencies domestically and internationally. The solicitation type is best value tradeoff and contracts will have a 24-month base period and a 12-month option period for a total value of $49 million. The estimated award date is February 2021.
View the file
Other files for this federal contract opportunity
Show all 13
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
Sheet1
| Binding Labor rates and markup's COST SPREADSHEET - W912DY-20-R-0088 | |||||||||||||||
| Offeror Name goes here | |||||||||||||||
| Instructions/Clarification Concerning Pricing Model | |||||||||||||||
| 1 | Labor Rates for each year are being evaluated and are binding. If labor is going to be used outside of the offeror's labor force, the labor rates provided shall reflect the outside labor cost to include any subcontractor markup's. In other words the proposed labor rates shall be fully burdened to include any outside subcontractor cost. Also, the use of a subcontracted labor category shall be identified in Composite Markup and Labor Burden Notes column and reflect in the subcontracted labor rate buildup including any offeror markup's other than profit. | ||||||||||||||
| 2 | Proposed Profit or the base year and option years is the maximum ceiling is being evaluated and is binding for the life of the contract. | ||||||||||||||
| 3 | Composite Markups and Labor Burden Notes shall detail the actual markup and burden rates (i.e. material composite markup consisting of a 11% material handling fee and 11% Profit) All proposed markups are binding. | ||||||||||||||
| 4 | Green Fields are for Offeror Input | ||||||||||||||
| 5 | Yellow Cells for CLIN 1 are arbitrary Government furnished Labor Hours used for level of effort evaluation purposes only the labor effort sumtotal is required. The remaining yellow cells for are arbitrary Government supplied values only the composite markups are required. These NTE labor rates and markup ceilings are binding for the life of the contract for the base year and each option year. | ||||||||||||||
| 6 | It is the offeror's responsibility to ensure all formulas are correct this spreadsheet depicts the required results, the formulas contained may or may not be correct. | ||||||||||||||
| 7 | It is the offeror's responsibility to ensure any additional labor categories they feel are required for this work be identified and added to the labor categories presented. Use 80 hours for these added labor categories. The labor categories priced are binding and no additional labor categories s for a labor category will be added to the contract unless presented and priced here. | ||||||||||||||
| 8 | Offeror shall submit this worksheet in their proposal in Excel and PDF format. | ||||||||||||||
| Government furnished labor categories and labor hours | |||||||||||||||
| Base Years (24 Months) | |||||||||||||||
| CLIN 1 | Labor Categories | Base Years Labor Amount (No Loads/No Profit) | Base Years Labor Rate Fully Burdened Less Profit | Maximum Profit % | Fully Burdened Base Years Rate Plus Profit | Arbitrary Government Furnished Hours | Total Base Years | Composite Markup/Burden Notes | Labor Categories | Base Year Hours | Option 1 Year Hours | Option 2 Year Hours | Option 3 Year Hours | Option 4 Year Hours | Option 4 Year Six Month Extension Hours |
| 1 | Program Manager | $ - 0 | 50 | $ - 0 | For Example: Fully Burdened Rate includes: Direct Labor, Fringe (45%), Overhead (15%), and profit 10% | Senior level Program Manager (Key Personnel) | 50 | 50 | 50 | 50 | 50 | 25 | |||
| 2 | Contracts Manager | $ - 0 | 50 | $ - 0 | Mid Level Program Manager (Key Personnel) | 50 | 50 | 50 | 50 | 50 | 25 | ||||
| 3 | Senior Electrical/Mechanical Engineer | $ - 0 | 50 | $ - 0 | Senior level Project Manager | 50 | 50 | 50 | 50 | 50 | 25 | ||||
| 4 | Senior Electronics Security System (ESS) Engineer | $ - 0 | 50 | $ - 0 | Mid level Project Manager | 50 | 50 | 50 | 50 | 50 | 25 | ||||
| 5 | Lead IT/IA Manager (Information Assurance Technical Emphasis | $ - 0 | 50 | $ - 0 | Staff level Project Manager | 50 | 50 | 50 | 50 | 50 | 25 | ||||
| 6 | Quality Control Manager | $ - 0 | 80 | $ - 0 | Senior level Systems Administrator | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 7 | Fire Protection Engineer | $ - 0 | 80 | $ - 0 | Mid level Systems Administrator | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 8 | Site Superintendent | $ - 0 | 80 | $ - 0 | Staff level Systems Administrator | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 9 | HVAC Technician | $ - 0 | 50 | $ - 0 | Senior Energy Engineer (Key Personnel) | 50 | 50 | 50 | 50 | 50 | 25 | ||||
| 10 | Senior Security System Engineer | $ - 0 | 30 | $ - 0 | Senior level Electrical/Mechanical Engineer | 30 | 30 | 30 | 30 | 30 | 15 | ||||
| 11 | Security System Engineer | $ - 0 | 30 | $ - 0 | Mid level Electrical/Mechanical Engineer | 30 | 30 | 30 | 30 | 30 | 15 | ||||
| 12 | Senior Electronic Security Engineer | $ - 0 | 30 | $ - 0 | Staff level Electrical/Mechanical Engineer | 30 | 30 | 30 | 30 | 30 | 15 | ||||
| 13 | Electrical/Mechanical Engineer | $ - 0 | 80 | $ - 0 | Senior level Network Security Specialist | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 14 | Senior Project Manager | $ - 0 | 80 | $ - 0 | Mid level Network Security Specialist | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 15 | Project Manager | $ - 0 | 80 | $ - 0 | Staff level Network Security Specialist | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 16 | Senior ESS/UMCS Technician | $ - 0 | 50 | $ - 0 | Senior Information Security Engineer (Key Personnel) | 50 | 50 | 50 | 50 | 50 | 25 | ||||
| 17 | ESS/UMCS Technician | $ - 0 | 80 | $ - 0 | Senior level User Experience Designer | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 18 | Senior Network Engineer | $ - 0 | 80 | $ - 0 | Mid level User Experience Designer | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 19 | Network Engineer | $ - 0 | 80 | $ - 0 | Staff level User Experience Designer | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 20 | Technical Writer | $ - 0 | 80 | $ - 0 | Senior level System Security Engineer | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 21 | Programmer/Analyst | $ - 0 | 80 | $ - 0 | Mid level System Security Engineer | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 22 | CAD Operator | $ - 0 | 80 | $ - 0 | Staff level System Security Engineer | 80 | 80 | 80 | 80 | 80 | 40 | ||||
| 23 | Information Assurance Technician (IAT Level II) | $ - 0 | 30 | $ - 0 | Senior level Software Developer/Programmer | 30 | 30 | 30 | 30 | 30 | 15 | ||||
| 24 | Database Manager | $ - 0 | 30 | $ - 0 | Mid level Software Developer/Programmer | 30 | 30 | 30 | 30 | 30 | 15 | ||||
| 25 | System Administrator/Software Engineer | $ - 0 | 30 | $ - 0 | Staff level Software Developer/Programmer | 30 | 30 | 30 | 30 | 30 | 15 | ||||
| 26 | Network Specialist (DOD fielding experience emphasis) | $ - 0 | 40 | $ - 0 | Senior level Data Systems Analyst | 40 | 40 | 40 | 40 | 40 | 20 | ||||
| Total for the Base Year Level of effort | $ - 0 |
| Other Cost (No Labor) | Arbitrary Base Year Government Supplied Values | Maximum Composite Markup % | Composite Markup Notes |
| Materials & ODC | $ 2,000,000.00 | ||
| Subcontract | $ 250,000.00 | ||
| Travel | $ 250,000.00 | ||
| Contract Manpower Reporting (CMRA) is not separately priced (NSP) |
| Option Year (12 Months) | ||||||||
| CLIN 1001 | Labor Categories | Option Year Labor Amount (No Loads/No Profit) | Option Year Labor Rate Fully Burdened Less Profit to include escalation | Maximum Profit % | Fully Burdened Option Year Labor Rate Plus Profit | Arbitrary Government Furnished Hours | Total Option Year | Composite Markup/Burden Notes |
| Program Manager | $ - 0 | 50 | $ - 0 | |||||
| Contracts Manager | $ - 0 | 50 | $ - 0 | |||||
| Senior Electrical/Mechanical Engineer | $ - 0 | 50 | $ - 0 | |||||
| Senior Electronics Security System (ESS) Engineer | $ - 0 | 50 | $ - 0 | |||||
| Lead IT/IA Manager (Information Assurance Technical Emphasis | $ - 0 | 50 | $ - 0 | |||||
| Quality Control Manager | $ - 0 | 80 | $ - 0 | |||||
| Fire Protection Engineer | $ - 0 | 80 | $ - 0 | |||||
| Site Superintendent | $ - 0 | 80 | $ - 0 | |||||
| HVAC Technician | $ - 0 | 50 | $ - 0 | |||||
| Senior Security System Engineer | $ - 0 | 30 | $ - 0 | |||||
| Security System Engineer | $ - 0 | 30 | $ - 0 | |||||
| Senior Electronic Security Engineer | $ - 0 | 30 | $ - 0 | |||||
| Electrical/Mechanical Engineer | $ - 0 | 80 | $ - 0 | |||||
| Senior Project Manager | $ - 0 | 80 | $ - 0 | |||||
| Project Manager | $ - 0 | 80 | $ - 0 | |||||
| Senior ESS/UMCS Technician | $ - 0 | 50 | $ - 0 | |||||
| ESS/UMCS Technician | $ - 0 | 80 | $ - 0 | |||||
| Senior Network Engineer | $ - 0 | 80 | $ - 0 | |||||
| Network Engineer | $ - 0 | 80 | $ - 0 | |||||
| Technical Writer | $ - 0 | 80 | $ - 0 | |||||
| Programmer/Analyst | $ - 0 | 80 | $ - 0 | |||||
| CAD Operator | $ - 0 | 80 | $ - 0 | |||||
| Information Assurance Technician (IAT Level II) | $ - 0 | 30 | $ - 0 | |||||
| Database Manager | $ - 0 | 30 | $ - 0 | |||||
| System Administrator/Software Engineer | $ - 0 | 30 | $ - 0 | |||||
| Network Specialist (DOD fielding experience emphasis) | $ - 0 | 40 | $ - 0 | |||||
| Total for Option Year 1 Level of effort | $ - 0 |
| Other Cost (No Labor) | Arbitrary Option 1 Year Government Supplied Values | Maximum Composite Markup % | Composite Markup Notes |
| Materials & ODC | $ 2,000,000.00 | ||
| Subcontract | $ 250,000.00 | ||
| Travel | $ 250,000.00 | ||
| Contract Manpower Reporting (CMRA) is not separately priced (NSP) |
File details come from the government source that posted it. Updated .