Attachment 5 PECP Worksheet FA701422Q0033.xlsx
XLSX spreadsheet 27 KB Posted
- Solicitation number
- FA701422Q0033
View the file
Other files
Show all 11
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
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 .