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
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 Total | 31 Jan 2025 to 30 Jan 2026 | |||||
| LABOR CATEGORY (Proposed Labor Category) | PWS Task Area and summary of functions or tasks associated with this LCAT | Est. Hrs | Unburdened Salary per LCAT Proposed | Fringe Cost | FFP Discount Applied | LCAT Cost |
| EXAMPLE: Subject Matter Expert, Engineer | Para 4.1 Task 1 of the PWS: | 1,920.0 | $ - 0 | |||
| Senior Software Developer | 1,920.0 | |||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,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 Total | 30 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 LCAT | Est. Hrs | Unburdened Salary per LCAT Proposed | Fringe Cost | FFP Discount Applied | LCAT Cost |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 1,920.0 | ||||
| Senior Software Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,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 Total | 31 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 LCAT | Est. Hrs | Unburdened Salary per LCAT Proposed | Fringe Cost | FFP Discount Applied | LCAT Cost |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 1,920.0 | $ - 0 | |||
| Senior Software Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,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 Total | 30 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 LCAT | Est. Hrs | Unburdened Salary per LCAT Proposed | Fringe Cost | FFP Discount Applied | LCAT Cost |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 1,920.0 | ||||
| Senior Software Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,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 Total | 31 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 LCAT | Est. Hrs | Unburdened Salary per LCAT Proposed | Fringe Cost | FFP Discount Applied | LCAT Cost |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 1,920.0 | $ - 0 | |||
| Senior Software Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| SharePoint Developer | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,920.0 | $ - 0 | ||||
| IT SharePoint Consultant | 1,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 Total | 31 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 LCAT | Est. Hrs | Unburdened Salary per LCAT Proposed | Fringe Cost | FFP Discount Applied | LCAT Cost |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 960.0 | $ - 0 | |||
| Senior Software Developer | 960.0 | $ - 0 | ||||
| SharePoint Developer | 960.0 | $ - 0 | ||||
| SharePoint Developer | 960.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 960.0 | $ - 0 | ||||
| IT Senior SharePoint Consultant | 960.0 | $ - 0 | ||||
| IT SharePoint Consultant | 960.0 | $ - 0 | ||||
| IT SharePoint Consultant | 960.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 .