Attachment_5_Cost_Price_Proposal_Template.xlsx

Instructions V2.0

DRAFT

Instructions: This format shall be used for all Price Proposals for ALLIANT 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 ID/IQ solicitation and included in the basic ALLIANT 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 OASIS 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.

14. CAF Fee: This column auto calculates. Ensure the totals are correct up to the subtotal for the CAF fee of .01% to be calculated based on the MOA for the Air Force and OASIS on this negotiated CAF.

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

Core FTEs Option 1

Core FTEs Option 2