DRAFT_Attachment_4_-_IDIQ_Pricing_Sheet_(Updated_7_Aug_17).xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- Financial Improvement & Audit Readiness (FIAR) Follow-on Support Federal contract opportunity
- Solicitation number
- FA7014-17-R-5002
About this file
DRAFT Attachment 4 - IDIQ Pricing Sheet
View the file
Other files for this federal contract opportunity
Show all 50
Financial Improvement & Audit Readiness (FIAR) Follow-on Support has more files on GovTribe.
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 V2.0
DRAFT
Instructions: This format shall be used for all Price Proposals for FIAR Task Orders (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).
c. The Optional FTE sheet will only include proposed pricing for all optional FTEs.
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 there are more than four labor categories proposed, copy one of the previous grouping of rows (for example rows 31-39) and insert at the bottom. Repeat as many times as required. If less that four labor categories are required, offers may delete additional rows not required.
5. Est. Hrs (separate columns for each PoP): Insert estimated hours for each labor category for each TO performance year (blue boxes). Each FTE should add up to 1920 hours for each labor category, unless otherwise specified in the TO RFP. In the example PoP of 26 Sep 17 to 25 Sep 18, for the first TO performance year for one FTE, take 1920 hours divided by 12, which is 160 hours per month. The same would then apply for the following years, with Est. Hrs in the option year tabs identified..
6. Rate: Insert your proposed cost elements for each of the labor categories for the solicited effort (light blue). The Total Cost and Loaded Rate columns will automatically calculate. The resulting values in the Loaded Rate column shall be equal or less than rates proposed as part of the OASIS ID/IQ solicitation and included in the basic OASIS ID/IQ award, and will cover the entire PoP. Offerors may delete any additional rows not requiring rates for each labor category if necessary.
7. Total Labor (three separate columns): These columns will auto calculate. 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 addiitonal costs to include Fringe, OH, G&A and Profit as updated in the tabs. This information will be used to review and evaluate the Employee Compensation Plan (ECP).
Core FTEs BASE
| FINAL | ||||||||
| Attachment 4 - Cost/Price Proposal for FIAR- Core FTEs | ||||||||
| FTEs Total | 26 September 17 - 25 Septemeber 18 BASE | |||||||
| LABOR CATEGORY (Proposed Labor Category) | PWS Task Area and summary of functions or tasks associated with this LCAT | Yr | Est. Hrs | Unburdened Labor Rate (Labor Price) | Additonal Costs (Fringe, OH, G&A and Profit) | FFP Discount Applied | Proposed Rate | Total Proposed |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 2018 | 1,880.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 236,880.00 |
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| Total Optional FTEs Value (Total FTEs and Hours) | 2018 | 1,880.0 | $ - 0 |
Core FTEs OY1
| FINAL | ||||||||
| Attachment 4 - Cost/Price Proposal for FIAR- Core FTEs | ||||||||
| FTEs Total | 26 September 18 - 25 Septemeber 19 OY1 | |||||||
| LABOR CATEGORY (Offeror's Proposed Labor Category) | PWS Task Area and summary of functions or tasks associated with this LCAT | Yr | Est. Hrs | Unburdened Labor Rate (Labor Price) | Additonal Costs (Fringe, OH, G&A and Profit) | FFP Discount Applied | Proposed Rate | Total Proposed |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 2019 | 1,880.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 236,880.00 |
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| Total Optional FTEs Value (Total FTEs and Hours) | 2019 | 1,880.0 | $ - 0 |
Core FTEs OY2
| FINAL | ||||||||
| Attachment 4 - Cost/Price Proposal for FIAR- Core FTEs | ||||||||
| FTEs Total | 26 September 19 - 25 Septemeber 20 OY2 | |||||||
| LABOR CATEGORY (Offeror's Proposed Labor Category) | PWS Task Area and summary of functions or tasks associated with this LCAT | Yr | Est. Hrs | Unburdened Labor Rate (Labor Price) | Additonal Costs (Fringe, OH, G&A and Profit) | FFP Discount Applied | Proposed Rate | Total Proposed |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 2020 | 1,880.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 236,880.00 |
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| Total Optional FTEs Value (Total FTEs and Hours) | 2020 | 1,880.0 | $ - 0 |
Core FTEs OY3
| FINAL | ||||||||
| Attachment 4 - Cost/Price Proposal for FIAR- Core FTEs | ||||||||
| FTEs Total | 26 September 20 - 25 Septemeber 21 OY3 | |||||||
| LABOR CATEGORY (Offeror's Proposed Labor Category) | PWS Task Area and summary of functions or tasks associated with this LCAT | Yr | Est. Hrs | Unburdened Labor Rate (Labor Price) | Additonal Costs (Fringe, OH, G&A and Profit) | FFP Discount Applied | Proposed Rate | Total Proposed |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 2021 | 1,880.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 236,880.00 |
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| Total Optional FTEs Value (Total FTEs and Hours) | 2021 | 1,880.0 | $ - 0 |
Core FTEs OY4
| FINAL | ||||||||
| Attachment 4 - Cost/Price Proposal for FIAR- Core FTEs | ||||||||
| FTEs Total | 26 September 21 - 25 Septemeber 22 OY4 | |||||||
| LABOR CATEGORY (Offeror's Proposed Labor Category) | PWS Task Area and summary of functions or tasks associated with this LCAT | Yr | Est. Hrs | Unburdened Labor Rate (Labor Price) | Additonal Costs (Fringe, OH, G&A and Profit) | FFP Discount Applied | Proposed Rate | Total Proposed |
| EXAMPLE: Subject Matter Expert II | Task Area 3 of the PWS: | 2022 | 1,880.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 236,880.00 |
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| $ - 0 | $ - 0 | |||||||
| Total Optional FTEs Value (Total FTEs and Hours) | 2022 | 1,880.0 | $ - 0 |
File details come from the government source that posted it. Updated .