Attachment 5 PECP Worksheet FA701422Q0033.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- Request for Quotation - Research and Development for Cost Estimating Modeling (CEM) Federal contract opportunity
- Solicitation number
- FA701422Q0033
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Solicitation Amendment FA701422Q00330001 SF 30.pdf | ||
| Attachment 7 DD254 Atch 2 - Item 10e2.pdf | ||
| Attachment 7 dd254 Atch 1 - Block 13 CONTINUATION.pdf | ||
| Attachment 7 DD 254 - O-S Cost Estimating BPA.pdf | ||
| Attachment 1 PWS AFCAA Legacy Cost Estimates 03Jun22.pdf | ||
| Attachment 6 Cost Estimates BPA Ordering Guide 16AUG2021.pdf | ||
| Attachment 4 Price Worksheet.xlsx | XLSX spreadsheet | |
| Attachment 3 Eval Criteria FA701422Q0033 6June22.docx | DOCX document | |
| PWS - Call Order 3 Independent Cost Estimates 2022_Final.docx | DOCX document | |
| Attachment 2 ITO FA701422Q0033 Cost BPA.docx | DOCX document | |
| PWS - Call Order 2 Legacy Cost Model 2022_Final.docx | DOCX document |
Show all 11
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
Instructions
FINAL
Instructions: This format shall be used for all Price Proposals for the O&S Legacy Cost Support and Independent Cost Estimates PECP IAW the Instructions to Offerors and Evaluation Criteria (FAR Addendum 52.212-1 and 52.212-2). As a minimum, offerors shall fill in the items in blue (blue text or text box filled in blue), as applicable to the requirement.
1. General:
a. It is the offeror's responsibility to ensure all columns and rows with formulas calculate correctly and provide a true representation of the proposed effort.
b. The Core FTE sheet will only include proposed pricing for all FTEs required by the effort (i.e., those other than optional).
2. 2nd Row: Complete areas in red font - Name of Offeror
3. Insert PoPs Row (2nd Row): Completed with POP
4. Labor Category: Insert the titles of applicable labor categories and, in parentheses, include the task(s) to which they apply and the number of FTEs in the labor category working on that task(s). For example: Program Manager (PWS 2.0) (2 FTEs), task 2.5 (1 FTE)) as an example. If more rows are needed for labor categories proposed, copy one of the previous gouping of rows (for example rows 31-39) and insert at the bottom. Repeat as many times as required.
5. Est. Hrs (separate columns for each PoP): The Government used1920 for each person proposed when planning this acquisition
6. Salary: Insert your cost elements, salary is preferred for price analysis purposes for each of the labor categories for the solicited effort (light blue). Complete the fringe cost (annually),,offerors may delete any additional rows not requiring rates for each labor category if necessary.
7. Total Labor (three separate columns): Column G should add up to the prior columns. Ensure your numbers are correct and all formulas work if any changes are made. If additional labor categories are added, ensure the totals for Total Labor are updated to include totals for all labor categories.
Note: The information provided on this spreadsheet to include the Unburdened Labor and fringe as updated in the tabs. This information will be used to review and evaluate the ProfessionalEmployee Compensation Plan (PECP).
PECP Worksheet
| PECP Proposal for Solicitation#: FA701422Q0033 | ||||
| O&S Legacy Cost Support and Independent Cost Estimates | ||||
| FTEs Total | ||||
| LABOR CATEGORY (Proposed Labor Category) | PWS Reference for Support | Unburdened Salary per LCAT Proposed | Fringe Cost | LCAT Cost |
| EXAMPLE: Subject Matter Expert, Engineer II | PWS Task Area 1, Task Area 3 | $ 125,000.00 | $ 40,000.00 | $ 165,000.00 |
| EXAMPLE: Subject Matter Expert, Engineer IV | PWS Task Area 3 | $ 133,000.00 | $ 42,560.00 | $ 175,560.00 |
| EXAMPLE: Subject Matter Expert, Engineer V | PWS Task Area 4, Task Area 6 | $ 145,000.00 | $ 46,400.00 | $ 191,400.00 |
| EXAMPLE: Subject Matter Expert, Analyst II | PWS Task Area 2, Task Area 6 | $ 110,000.00 | $ 35,200.00 | $ 145,200.00 |
| EXAMPLE: Subject Matter Expert, Data Architect II | PWS Task Area 2, Task Area 6 | $ 125,000.00 | $ 40,000.00 | $ 165,000.00 |
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 |
| Note: Please remove the examples section for the final submission. |
| Additional lines can be added for labor categories |
File details come from the government source that posted it. Updated .