DRAFT_Attachment_4_Cost_Price_Proposal_FIAR.xlsx
XLSX spreadsheet 63 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 Cost/Price Proposal Worksheet
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 OASIS 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 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.
8. Material and Travel: Insert costs provided in the TO RFP for each TO performance year. If not provided in the RFP but included as part of the requirement, insert proposed costs for each TO performance year (light blue).
9. Material and Travel Handling Rates: Insert percentages in cells highlighted in blue for each TO performance year. These shall be equal to or less than the rates proposed as part of the ID/IQ RFP and subsequent award. The associated dollar value will automatically calculate and become part of the Total Other Direct Costs row in light purple/gray.
10. TOTAL LABOR & ODC: Ensure the totals for each TO performance year calculate to include labor and ODC, particularly if additional performance years were added.
11. Total for Core FTEs: Insert total number of core FTEs in the blue column to the right of the column with 'No.' for number, then ensure the dollar value cell equals the sum of the total labor for the base and all option years for the TO proposal.
12. Total for Optional FTEs: This column will pull from the total numbers (number of FTEs and $ value) on the Optional FTEs Spreadsheet. Ensure the data pulls from the total column in blue on the Optional spreadsheet (when there are optional FTEs for the solicited TO).
13. Total Award Value: Ensure the total includes the total funded and total optional for the TO. This will represent the total evaluated price for the solicitation for FFP contracts.
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).
DRAFT
Core FTEs BASE
| DRAFT | ||||||||
| FIAR | ||||||||
| FTEs Total | TBD | |||||||
| 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,920.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 241,920.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,920.0 | $ - 0 | |||||
| Travel Cost: | ||||||||
| Travel | Estimated amount provided by the Gov't. | $178,000.00 | ||||||
| Travel Handling Rate | 4% |
HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:
| To be provided by the Offeror if applicable. | $ 7,120.00 | ||||
| Total Travel Cost with Material and Travel rate (Fee percentage) | $185,120.00 | ||||
| TOTAL LABOR & TRAVEL | No. | $187,040.00 | |||
| Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017) | 0 | 0.0 | $ - 0 | ||
| Optional FTEs Total | 0 | 0.0 | $ - 0 | ||
| Subtotal before applying CAF | No. of Hours | 0.0 | $ 187,040.00 | ||
| OASIS CAF | $ 187.04 | ||||
| Total Award Value | No. of Hours | 0.0 | $ 187,227.04 |
Core FTEs OY1
| DRAFT | ||||||||
| FIAR | ||||||||
| FTEs Total | TBD | |||||||
| 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: | 2018 | 1,920.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 241,920.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,920.0 | $ - 0 | |||||
| Travel Cost: | ||||||||
| Travel | Estimated amount provided by the Gov't. | $178,000.00 | ||||||
| Travel Handling Rate | 4% |
HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:
| To be provided by the Offeror if applicable. | $ 7,120.00 | ||||
| Total Travel Cost with Material and Travel rate (Fee percentage) | $185,120.00 | ||||
| TOTAL LABOR & TRAVEL | No. | $187,040.00 | |||
| Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017) | 0 | 0.0 | $ - 0 | ||
| Optional FTEs Total | 0 | 0.0 | $ - 0 | ||
| Subtotal before applying CAF | No. of Hours | 0.0 | $ 187,040.00 | ||
| OASIS CAF | $ 187.04 | ||||
| Total Award Value | No. of Hours | 0.0 | $ 187,227.04 |
Core FTEs OY2
| DRAFT | ||||||||
| FIAR | ||||||||
| FTEs Total | TBD | |||||||
| 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: | 2018 | 1,920.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 241,920.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,920.0 | $ - 0 | |||||
| Travel Cost: | ||||||||
| Travel | Estimated amount provided by the Gov't. | $178,000.00 | ||||||
| Travel Handling Rate | 4% |
HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:
| To be provided by the Offeror if applicable. | $ 7,120.00 | ||||
| Total Travel Cost with Material and Travel rate (Fee percentage) | $185,120.00 | ||||
| TOTAL LABOR & TRAVEL | No. | $187,040.00 | |||
| Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017) | 0 | 0.0 | $ - 0 | ||
| Optional FTEs Total | 0 | 0.0 | $ - 0 | ||
| Subtotal before applying CAF | No. of Hours | 0.0 | $ 187,040.00 | ||
| OASIS CAF | $ 187.04 | ||||
| Total Award Value | No. of Hours | 0.0 | $ 187,227.04 |
Core FTEs OY3
| DRAFT | ||||||||
| FIAR | ||||||||
| FTEs Total | TBD | |||||||
| 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: | 2018 | 1,920.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 241,920.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,920.0 | $ - 0 | |||||
| Travel Cost: | ||||||||
| Travel | Estimated amount provided by the Gov't. | $178,000.00 | ||||||
| Travel Handling Rate | 4% |
HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:
| To be provided by the Offeror if applicable. | $ 7,120.00 | ||||
| Total Travel Cost with Material and Travel rate (Fee percentage) | $185,120.00 | ||||
| TOTAL LABOR & TRAVEL | No. | $187,040.00 | |||
| Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017) | 0 | 0.0 | $ - 0 | ||
| Optional FTEs Total | 0 | 0.0 | $ - 0 | ||
| Subtotal before applying CAF | No. of Hours | 0.0 | $ 187,040.00 | ||
| OASIS CAF | $ 187.04 | ||||
| Total Award Value | No. of Hours | 0.0 | $ 187,227.04 |
Core FTEs OY4
| DRAFT | ||||||||
| FIAR | ||||||||
| FTEs Total | TBD | |||||||
| 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: | 2018 | 1,920.0 | $ 50.00 | $ 78.00 | $ (2.00) | $ 126.00 | $ 241,920.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,920.0 | $ - 0 | |||||
| Travel Cost: | ||||||||
| Travel | Estimated amount provided by the Gov't. | $178,000.00 | ||||||
| Travel Handling Rate | 4% |
HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS: HARPER, CYNTHIA I CTR USAF HAF AFDW/PKS:
| To be provided by the Offeror if applicable. | $ 7,120.00 | ||||
| Total Travel Cost with Material and Travel rate (Fee percentage) | $185,120.00 | ||||
| TOTAL LABOR & TRAVEL | No. | $187,040.00 | |||
| Transition Phase-In Plan (11 Sep 2017 to 25 Sep 2017) | 0 | 0.0 | $ - 0 | ||
| Optional FTEs Total | 0 | 0.0 | $ - 0 | ||
| Subtotal before applying CAF | No. of Hours | 0.0 | $ 187,040.00 | ||
| OASIS CAF | $ 187.04 | ||||
| Total Award Value | No. of Hours | 0.0 | $ 187,227.04 |
Transition FTEs_Pricing
| Cost/Price Proposal for OASIS Task Order Security Cooperation Support Services (SCSS) (Firm Fixed Price/Unrestricted) - Core FTEs - Attachment 4 | |||||||
| Transition Phase-In Plan | OASIS | 11 September 17 - 25 Septemeber 17 Transition Phase-In Plan | |||||
| LABOR CATEGORY | Yr | Est. Hrs | Unburdened Labor | Fringe Cost | OH Cost | G&A Cost | Total Cost |
| Proposed Labor Category (Task number and number of FTEs in this labor category working on that task) | $ - 0 | ||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| Total Transition FTEs (Total FTEs and Hours) | 0 | 0.0 | $ - 0 | ||||
| DRAFT |
| FIAR | |||||||
| Transition Phase-In Plan | |||||||
| LABOR CATEGORY (Offeror's Proposed Labor Category) | Yr | Est. Hrs | Unburdened Labor Rate (Labor Price) | Additonal Costs (Fringe, OH, G&A and Profit) | FFP Discount Applied | Proposed Rate | Total Proposed |
| Proposed Labor Category (Task number and number of FTEs in this labor category working on that task) | $ - 0 | ||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| Total Transition FTEs (Total FTEs and Hours) | 0 | 0.0 | $ - 0 |
6 Months of Support
| DRAFT | |||||||
| FIAR | |||||||
| OPTIONAL FTEs Total | TBD | ||||||
| LABOR CATEGORY | Yr | Est. Hrs | Unburdened Labor Rate (Labor Price) | Additonal Costs (Fringe, OH, G&A and Profit) | FFP Discount Applied | Proposed Rate | Total Proposed Cost |
| Proposed Labor Category (Task number and number of FTEs in this labor category working on that task) | $ - 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) | 0.0 | $ - 0 |
File details come from the government source that posted it. Updated .