Attachment 5 PECP Worksheet SAF_AAIE.xlsx

XLSX spreadsheet 63 KB Posted

Attached to
SAF/AAIE Software Development Services (SDS) **GSA e-Buy Only Reference number RFQ1732817**
Solicitation number
FA701425R0004
Issued by

About this file

This document is an attachment to a federal contract solicitation for Software Development Services (SDS). The attachment is a pricing template for the General Services Administration (GSA) 8(a) STARS III contract under solicitation number FA701425R0004 for the SAF/AAIE organization. The template provides instructions for offerors to propose labor categories, estimated hours, unburdened salaries, fringe costs, and discounts for the base year and four option years, as well as a 6-month extension. The government is using 1920 hours per full-time equivalent (FTE) for planning purposes. The contract is a small business set-aside, and offerors must have a valid SECRET clearance. Responses to the solicitation are due by 4:00 PM Eastern on Friday, December 6, 2024, and must be submitted via email to hannah.dent.1@us.af.mil.

View the file

Other files

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 GSA 8(a) STARS III TaskOrders(TO), unless the Government provides a separate template with the TO solicitation. 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 (task 3.2 (2 FTEs), task 3.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 normally uses 1920 or 1880 hrs. for each person proposed when planning.

6. Salary: Insert your cost elements, salary is preferred for analysis purposes for each of the labor categories for the solicited effort (light blue). Complete the fringe cost (annually), deduct any discounts that is being offered from the GSA (8a) STARS III awarded rates. 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 Employee Compensation Plan (ECP).

FTEs BASE

FA701425R0004
PECP Proposal for - SAF/AAIE SDS - Attachment 5
FTEs Total31 Jan 2025 to 30 Jan 2026
LABOR CATEGORY (Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert, EngineerPara 4.1 Task 1 of the PWS:1,920.0$ - 0
Senior Software Developer1,920.0
SharePoint Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTEs OY1

FA701425R0004
PECP Proposal for - SAF/AAIE SDS - Attachment 5
FTEs Total30 Jan 2026 to 31 Jan 2027
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0
Senior Software Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTEs OY2

FA701425R0004
PECP Proposal for - SAF/AAIE SDS - Attachment 5
FTEs Total31 Jan 2027 to 30 Jan 2028
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0$ - 0
Senior Software Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTEs OY3

FA701425R0004
PECP Proposal for - SAF/AAIE SDS - Attachment 5
FTEs Total30 Jan 2028 to 31 Jan 2029
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0
Senior Software Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTEs OY4

FA701425R0004
PECP Proposal for - SAF/AAIE SDS - Attachment 5
FTEs Total31 Jan 2029 to 30 Jan 2030
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0$ - 0
Senior Software Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
SharePoint Developer1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT Senior SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
IT SharePoint Consultant1,920.0$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTE 6 Month Extension

FA701425R0004
PECP Proposal for - SAF/AAIE SDS - Attachment 5
FTEs Total31 Jan 2030 to 28 Aug 2030
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:960.0$ - 0
Senior Software Developer960.0$ - 0
SharePoint Developer960.0$ - 0
SharePoint Developer960.0$ - 0
IT Senior SharePoint Consultant960.0$ - 0
IT Senior SharePoint Consultant960.0$ - 0
IT SharePoint Consultant960.0$ - 0
IT SharePoint Consultant960.0$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

File details come from the government source that posted it. Updated .