2024 07 24 L-1 Excel Pricing Model.xlsx
XLSX spreadsheet 57 KB Posted
- Attached to
- NEXT GENERATION SCALABLE DATA ENGINEERING, OPERATIONS, AND INFORMATICS SUPPORT FOR OPEN SCIENCE (NEXT GEN) Federal contract opportunity
- Solicitation number
- 80MSFC24R0005
About this file
This document is an Excel pricing model template related to a federal contract opportunity. The template is designed to summarize the total price, calculate fully burdened labor rates, develop composite IDIQ rates, and provide program management overhead for a contract effort titled "Next Generation Scalable Data Engineering, Operations, and Informatics Support for Open Science (NEXT GEN)". The federal contract opportunity is a pre-solicitation for a future NASA/Marshall Space Flight Center research and development services acquisition with anticipated release of a draft RFP on or about July 18, 2024 and a final RFP on or about September 5, 2024. The procurement is expected to be a total small business set-aside with a NAICS code of 541715 and a size standard of 1,000 employees.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 2024 07 24 Draft Request for Proposal Acquisition Overview Presentation - Next Gen.pptx | PPTX presentation | |
| 2024 07 24 Next Gen Draft RFP.docx | DOCX document |
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
INDEX
| Company Name: | Company XYZ, Inc. | INDEX |
| RFP# 80MSFC24R0005 | ||
| ATTACHMENT L-1 | ||
| Next Generation PRICE RELATED FORMS |
| Tab | Title | Specific Instruction | |
| A | Summary of Price Proposed | This tab is designed to summarize the total price (Phase-In, Labor cost for mission, IDIQ Model/scenario) for the entire contract effort. This tab is linked to other tabs within the workbook. Most of this tab will automatically populate once the other tabs have been completed. Offerors shall fill in the areas highlighted in yellow | Prime Offeror |
| B | Summary of Labor Build-Up | This tab is designed to calculate the Fully Burdened Labor Rate (FBLR) for every labor category that is proposed. Offerors shall map each of their labor categories to a NASA Identified Labor Category. Offerors are required to submit their labor rate burden calculation for each year proposed. Offerors shall provide the base direct labor rate, fringe benefits, G&A, and Profit to calculate the proposed FBLR. This is a supporting work sheet for Tab C - Composite IDIQ Rate Development and Price Calculation by Year. The Prime Offeror must account for minor subcontractors in their build-up of Tab B and Attachment L, TCP. | Prime Offeror and Major Subcontractor |
| C | Composite IDIQ Rate Development and Price Calculation by Year | This tab is designed to develop the composite IDIQ rates by contract years. The composite IDIQ rates will be used to complete Attachment J-4, Indefinite-Delivery, Indefinite-Quantity (IDIQ) Fully-Burdened Labor Rates and Travel Burden. The Prime Offeror shall input any handling/profit proposed on subcontractors in cell B13. The total composition of every category should be 100%. Column O includes WYE, Column P converts Column O to hours. Column Q generates dollars by labor category. This column is totaled and carried forward to Tab A Summary | Prime Offeror |
| D | Productive Hours Per WYE Conversion Table | This tab identifies the number of productive hours by labor type (i.e., Exempt) for each contract year. The offeror is to indicate in the notes area how the figure was calculated (e.g., 2080 hours per year minus 100 vacation hours minus 40 sick leave hours minus 80 holiday hours to total 1860 productive hours). | Prime Offeror and Major Subcontractor |
| E | Business Information and Cognizant Audit Agency Points of Contact | This tab identifies the Cognizant Audit Agency (name, address, and telephone number) who currently approves forward pricing rates. | Prime Offeror and Major Subcontractor |
| F | Program Management Overhead | This tab is designed to allocate Direct Overhead to include Project Managers and Senior Technical Project Managers. Include any additional overhead that would be necessary to support this effort. An allocation base would be required in order to determine how the cost will be allocated. This must be described in this form and applied to the proposal in accordance with the allocation base selected. (i.e. Fully Burdened Labor). | Prime Offeror |
EPM PAGE &P OF &N
Tab A - Summary Company XYZ, Inc. Summary of Price Proposed Tab A - Summary
| Base Yr 1 | Base Yr 2 | Option Yr. 1 | Option Yr. 2 | Option Yr. 3 | Option Yr. 4 | ||||
| (6 mos.) | Total With Extension | ||||||||
| Phase-In | $0 | ||||||||
| Labor | |||||||||
| Fully Burdened Labor (to include Subcontractors) | ERROR:#VALUE! | $0 | $0 | $0 | $0 | $0 | ERROR:#VALUE! | ||
| Other Direct Cost (ODC) | |||||||||
| Travel | $54,250 | $54,250 | $54,250 | $54,250 | $54,250 | $27,125 | $298,375 | ||
| Handling/Burden | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total ODC | $54,250 | $54,250 | $54,250 | $54,250 | $54,250 | $27,125 | $298,375 | ||
| Profit on ODC | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Calculated Price | ERROR:#VALUE! | $54,250 | $54,250 | $54,250 | $54,250 | $27,125 | ERROR:#VALUE! |
#NNM13440940R
EPM PAGE &P OF &N &A
Tab B Labor Build-up
| Prime or Subcontractor Name | Summary of Labor Build-Up | Tab B Labor Build-up | |||||||||||||||||||||||
| Base Year 2 | Option Year 1 | ||||||||||||||||||||||||
| LABOR CATEGORY | Base Yr | LABOR CATEGORY | Esc Rate: | LABOR CATEGORY | Esc Rate: | ||||||||||||||||||||
| NASA Identified Labor Category | Offerors Labor Category | Labor Type | Base Direct Labor (DL) Rate | Fringe Exempt | OH | Subtotal | G&A | Profit | Fully Burdened IDIQ Labor Rate | NASA Identified Labor Category | Base Direct Labor (DL) Rate | Fringe Exempt | OH | Subtotal | G&A | Profit | Fully Burdened IDIQ Labor Rate | NASA Identified Labor Category | Base Direct Labor (DL) Rate | Fringe Exempt | OH | Subtotal | G&A | Profit | Fully Burdened IDIQ Labor Rate |
| Software Developer/Software Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Software Developer/Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Software Developer/Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Software Developer/Software Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Software Developer/Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Software Developer/Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Principal software developer/software engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Principal software developer/software engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Principal software developer/software engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior User Interface / User Experience (UI/UX) Software Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior User Interface / User Experience (UI/UX) Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior User Interface / User Experience (UI/UX) Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior User Interface Designer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior User Interface Designer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior User Interface Designer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Machine Learning Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Machine Learning Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Machine Learning Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Principal Machine Learning Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Principal Machine Learning Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Principal Machine Learning Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Geospatial Data Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Geospatial Data Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Geospatial Data Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Geographic Information System Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Geographic Information System Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Geographic Information System Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Solutions Architect | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Solutions Architect | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Solutions Architect | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Technical Project Manager | Linked to Tab F | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Technical Project Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Technical Project Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Project Manager (PMO) | Linked to Tab F | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Project Manager (PMO) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Project Manager (PMO) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Option Year 4 | Option Year 5 | ||||||||||||||||
| LABOR CATEGORY | Esc Rate: | LABOR CATEGORY | Esc Rate: | ||||||||||||||
| NASA Identified Labor Category | Offerors Labor Category | Labor Type | Base Direct Labor (DL) Rate | Fringe Exempt | OH | Subtotal | G&A | Profit | Fully Burdened IDIQ Labor Rate | NASA Identified Labor Category | Base Direct Labor (DL) Rate | Fringe Exempt | OH | Subtotal | G&A | Profit | Fully Burdened IDIQ Labor Rate |
| Software Developer/Software Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Software Developer/Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Software Developer/Software Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Software Developer/Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Principal software developer/software engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Principal software developer/software engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior User Interface / User Experience (UI/UX) Software Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior User Interface / User Experience (UI/UX) Software Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior User Interface Designer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior User Interface Designer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Machine Learning Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Machine Learning Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Principal Machine Learning Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Principal Machine Learning Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Geospatial Data Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Geospatial Data Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Geographic Information System Engineer | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Geographic Information System Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Solutions Architect | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Solutions Architect | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Senior Technical Project Manager | Linked to Tab F | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Senior Technical Project Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Project Manager (PMO) | Linked to Tab F | Exempt | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Project Manager (PMO) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
RFP #NNM13440940R
&A
Tab C Composite Rate
| Proposing Entity: | Tab C Composite Rate |
| Offeror Name [ ] Prime _______________________________________________________________ |
Composite IDIQ Rate Development and Price Calculation by Year
| Identify Prime Offeror Loadings Applied to Subcontractor FBL Rates: e.g. G&A, handling, profit | |
| Prime Offeror Load (burdens) on Subcontractors | 1% |
| Base Year | |||||||||||||||||
| Prime Offeror | Subcontractor (Insert Name) | Subcontractor (Insert Name) | Subcontractor (Insert Name) | 1% | TOTAL COMPOSITE | ||||||||||||
| Prime FBL Rate* | Percent of Effort | Sub 1 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 2 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 3 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | PMO Rate Applied to Composite Rate | Composite IDIQ FBL Rate *** | Percent of Effort | WYE | Hours | Dollars | |
| Example using Prefilled Rates of 1% | $39.67 | 0% | $42.00 | $42.42 | 100% | $45.00 | $45.45 | $38.00 | $38.38 | $0.42 | $42.84 | 100% | 1.0 | ` | ERROR:#VALUE! |
| Software Developer/Software Engineer | $1.00 | 100% | $0.00 | $0.00 | $0.00 | $0.42 | $1.42 | 100% | 1.0 | ERROR:#VALUE! | ERROR:#VALUE! | ||
| Senior Software Developer/Software Engineer | $10.00 | 50% | $30.00 | $30.30 | 50% | $0.00 | $0.00 | $0.20 | $20.35 | 100% | 2.8 | ERROR:#VALUE! | ERROR:#VALUE! |
| Principal software developer/software engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 5.2 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| Senior User Interface / User Experience (UI/UX) Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 2.5 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| Senior User Interface Designer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.3 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| Senior Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| Principal Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| Senior Geospatial Data Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 3.8 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| Senior Geographic Information System Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.3 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| Senior Solutions Architect | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.6 | ERROR:#VALUE! | ERROR:#VALUE! | |||
| NOTE: Examples are highlighted in red font. Please remember to remove red highlighted examples from the templates in your official proposal submission. | 19.3 | ERROR:#VALUE! | ERROR:#VALUE! | ||||||||||
| Adjust columns and formatting as necessary | |||||||||||||
| ^^^ Apply all applicable loadings (Prime and Subcontractor) and Profit |
| 1 Prime Loaded FBL Rate must match the FBL Rate from Tab B |
| 2 The subcontractor's FBRs MUST MATCH the FBR data provided to the Government for the individual major subcontractor. |
| 3 This is the Team Composite FBR (Prime Offeror and all subcontractors) by NASA SLC that SHALL MATCH the FBRs as proposed in Attachment J-4. |
| 4 Total percentage of effort must equal 100% for each category |
| Escalation | 0% | Base Year 2 | ||||||||||||||
| Prime Offeror | Subcontractor (Insert Name) | Subcontractor (Insert Name) | Subcontractor (Insert Name) | 1% | TOTAL COMPOSITE | 2080 | ||||||||||
| Prime FBL Rate* | Percent of Effort | Sub 1 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 2 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 3 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | PMO Rate Applied to Composite Rate | Composite IDIQ FBL Rate *** | Percent of Effort | WYE | Hours | Dollars |
| Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2080 | $0 |
| Senior Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 4.3 | 8840 | $0 |
| Principal software developer/software engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 5.2 | 10712 | $0 |
| Senior User Interface / User Experience (UI/UX) Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 3.0 | 6240 | $0 |
| Senior User Interface Designer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.3 | 2600 | $0 |
| Senior Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2080 | $0 |
| Principal Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2080 | $0 |
| Senior Geospatial Data Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 4.8 | 9880 | $0 |
| Senior Geographic Information System Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.3 | 520 | $0 |
| Senior Solutions Architect | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.6 | 1248 | $0 |
| NOTE: Examples are highlighted in red font. Please remember to remove red highlighted examples from the templates in your official proposal submission. | 22.3 | 46280 | - 0 |
| Escalation | 0% | Option Period 1 | ||||||||||||||
| Prime Offeror | Subcontractor (Insert Name) | Subcontractor (Insert Name) | Subcontractor (Insert Name) | 1% | TOTAL COMPOSITE | 2088 | ||||||||||
| Prime FBL Rate* | Percent of Effort | Sub 1 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 2 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 3 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | PMO Rate Applied to Composite Rate | Composite IDIQ FBL Rate *** | Percent of Effort | WYE | Hours | Dollars |
| Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2088 | $0 |
| Senior Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 5.8 | 12006 | $0 |
| Principal software developer/software engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 5.2 | 10753 | $0 |
| Senior User Interface / User Experience (UI/UX) Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 3.5 | 7308 | $0 |
| Senior User Interface Designer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.3 | 2610 | $0 |
| Senior Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2088 | $0 |
| Principal Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2088 | $0 |
| Senior Geospatial Data Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 5.8 | 12006 | $0 |
| Senior Geographic Information System Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.3 | 522 | $0 |
| Senior Solutions Architect | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.6 | 1253 | $0 |
| 25.3 | 52722 | - 0 |
| Escalation | 0% | Option Period 2 | ||||||||||||||
| Prime Offeror | Subcontractor (Insert Name) | Subcontractor (Insert Name) | Subcontractor (Insert Name) | 1% | TOTAL COMPOSITE | 2088 | ||||||||||
| Prime FBL Rate* | Percent of Effort | Sub 1 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 2 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 3 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | PMO Rate Applied to Composite Rate | Composite IDIQ FBL Rate *** | Percent of Effort | WYE | Hours | Dollars |
| Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2088 | $0 |
| Senior Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 7.3 | 15138 | $0 |
| Principal software developer/software engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 5.2 | 10753 | $0 |
| Senior User Interface / User Experience (UI/UX) Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 4.0 | 8352 | $0 |
| Senior User Interface Designer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.3 | 2610 | $0 |
| Senior Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2088 | $0 |
| Principal Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2088 | $0 |
| Senior Geospatial Data Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 6.8 | 14094 | $0 |
| Senior Geographic Information System Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.3 | 522 | $0 |
| Senior Solutions Architect | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.6 | 1253 | $0 |
| 28.3 | 58986 | - 0 |
| Escalation | 0% | Option Period 3 | ||||||||||||||
| Prime Offeror | Subcontractor (Insert Name) | Subcontractor (Insert Name) | Subcontractor (Insert Name) | 1% | TOTAL COMPOSITE | 2080 | ||||||||||
| Prime FBL Rate* | Percent of Effort | Sub 1 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 2 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | Sub 3 FBL Rate** | Sub FBL Rate with Prime Load | Percent of Effort | PMO Rate Applied to Composite Rate | Composite IDIQ FBL Rate *** | Percent of Effort | WYE | Hours | Dollars |
| Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2080 | $0 |
| Senior Software Developer/Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 8.8 | 18200 | $0 |
| Principal software developer/software engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 5.2 | 10712 | $0 |
| Senior User Interface / User Experience (UI/UX) Software Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 4.5 | 9360 | $0 |
| Senior User Interface Designer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.3 | 2600 | $0 |
| Senior Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2080 | $0 |
| Principal Machine Learning Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 1.0 | 2080 | $0 |
| Senior Geospatial Data Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 7.8 | 16120 | $0 |
| Senior Geographic Information System Engineer | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.3 | 520 | $0 |
| Senior Solutions Architect | 100% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 100% | 0.6 | 1248 | $0 |
| 31.3 | 65000 | - 0 |
Tab D - Productive Factor Schedule of Productive Hours by Contract Year Tab D - Productive Factor
| Base Period 1 | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | |
| Start | 9/1/25 | 9/1/26 | 9/1/27 | 9/1/28 | 9/1/29 |
| Finish | 8/30/26 | 8/30/27 | 8/30/28 | 8/31/29 | 8/31/30 |
Available Hours 2,080 2,080 2,088 2,088 2,080
| Exempt Labor Categories | |||||
| Holiday | - 0 | - 0 | - 0 | - 0 | - 0 |
| Vacation | - 0 | - 0 | - 0 | - 0 | |
| Sick | - 0 | - 0 | - 0 | - 0 | - 0 |
| Training | - 0 | - 0 | - 0 | - 0 | - 0 |
| Other | - 0 | - 0 | - 0 | - 0 | - 0 |
Exempt Net productive factor 2,080 2,080 2,088 2,088 2,080
RFP #NNM13440940R
EPM PAGE &P OF &N &A
Tab E Cogz Off
| Business Information and Cognizant Audit Agency Points of Contact | INSTRUCTIONS TO OFFERORS |
| This template is required for Prime Offeror and Major Subcontractor(s). The Offeror and major subcontractors are instructed to identify the Cognizant Audit Agency (name, address, and telephone number) who currently approves forward pricing rates. | |
| Check Appropriate Box | |
| [ ] Prime Company Name: | |
| [ ] Interdivisional Company Name: | |
| [ ] Subcontractor Company Name: |
| Submitting Entity: | Cognizant Audit Agency Where Proposals are Sent: | Cognizant Audit Agency Where the Corporate Administrative Contracting Officer (CACO) or Administrative Contracting Officer (ACO) is located: |
| Company Name: | Cognizant Federal Agency Official: | Office |
CAGE Code:
DUNS:
POC: POC: POC:
Phone Number: Phone Number: Phone Number:
E-Mail Address: E-Mail Address: E-Mail Address:
Mailing Address: Mailing Address: Mailing Address:
Disclosures:
Note: The submitting entity audit point of contact (POC) and address provided above, must be at a location where auditable records supporting the proposed amounts physically reside. In the Disclosure area include any disclosures that may assist in the performance of an audit such as a recent proposal audit was performed on xx/xx/xx, a revision to the disclosure statement is underway, the financial records reside at ABC, however, the proposal team is located at XYZ and that is where the technical data resides.
Tab F PMO Program Management Overhead Calculation Tab F PMO
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||
| WYE | Rate | Dollars | WYE | Rate | Dollars | WYE | Rate | Dollars | WYE | Rate | Dollars | WYE | Rate | Dollars | |
| Senior Technical Project Manager | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 |
| Project Manager (PMO) | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 | - 0 | $0.00 | $1 |
| Other Category | - 0 | $1 | - 0 | $1 | - 0 | $1 | - 0 | $1 | - 0 | $1 | |||||
| Other Category | - 0 | $1 | - 0 | $1 | - 0 | $1 | - 0 | $1 | - 0 | $1 | |||||
| Other Category | - 0 | $1 | - 0 | $1 | - 0 | $1 | - 0 | $1 | - 0 | $1 |
Total Pool - 0 $5 - 0 $5 - 0 $5 - 0 $5 - 0 $5
| Allocation Base |
| i.e. (Total Burdened Labor) |
PMO Rate 0.0% 0.0% 0.0% 0.0% 0.0%
Areas in Yellow require manual input
File details come from the government source that posted it. Updated .