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
Issued by
Department of the Air Force Headquarters District Washington

View the file

Other files for this federal contract opportunity

Other files attached to Request for Quotation - Research and Development for Cost Estimating Modeling (CEM), newest first.
File Type Posted
Solicitation Amendment FA701422Q00330001 SF 30.pdf PDF
Attachment 7 DD254 Atch 2 - Item 10e2.pdf PDF
Attachment 7 dd254 Atch 1 - Block 13 CONTINUATION.pdf PDF
Attachment 7 DD 254 - O-S Cost Estimating BPA.pdf PDF
Attachment 1 PWS AFCAA Legacy Cost Estimates 03Jun22.pdf PDF
Attachment 6 Cost Estimates BPA Ordering Guide 16AUG2021.pdf 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 SupportUnburdened Salary per LCAT ProposedFringe CostLCAT Cost
EXAMPLE: Subject Matter Expert, Engineer IIPWS Task Area 1, Task Area 3$ 125,000.00$ 40,000.00$ 165,000.00
EXAMPLE: Subject Matter Expert, Engineer IVPWS Task Area 3$ 133,000.00$ 42,560.00$ 175,560.00
EXAMPLE: Subject Matter Expert, Engineer VPWS Task Area 4, Task Area 6$ 145,000.00$ 46,400.00$ 191,400.00
EXAMPLE: Subject Matter Expert, Analyst IIPWS Task Area 2, Task Area 6$ 110,000.00$ 35,200.00$ 145,200.00
EXAMPLE: Subject Matter Expert, Data Architect IIPWS 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 .