Appendix E(2) - Milestone Pricing Sheet - Table F-2 Continuation.xlsx

Cover

DISTRIBUTION STATEMENT A: Approved for Public Release; distribution unlimited.

1. Instructions

Tab 1. Instructions Nothing to input, informational only.

Tab 2. General Insert the required information in the blue highlighted cells.

Tab 3. Rate Backup See instructions at the top of Tab 3.

Tab 4. Milestone Schedule Insert the required information in the blue highlighted cells.

Tab 5. Total Cost-Price Summary Insert the required information in the blue highlighted cells.

Tab 6. Milestone Cost-Price Summary No action required. Tab is linked.

Tab 7. Labor Cost Form Instructions: Insert the required information in the blue highlighted cells. The Offeror shall input the period of performance in cells D6, AI6, BN6, CS6, and DX6. The period of performance shall reflect when the Offeror is projecting to perform the requirement. The Offeror shall allocate by milestone and year of performance the proposed hours and hourly rate for each labor category. If applicable insert any direct labor fringe rate(s), overhead rate(s), G&A rate(s), cost of money rate(s), and profit/fee rate(s) being proposed. Link the proposed base cost, contained in this tab, to its respective indirect rate base cost field, and apply the proposed indirect rate to this base cost. Documentation to support proposed labor category rates shall be provided in the cost proposal submission in the form of Government Agreement or Recommendation or payroll records. Order of preference for supporting documentation is as follows: Government Agreement or Recommendation (DCMA FPRA or FPRR or DCAA Audit); Payroll records for proposed personnel.

Tab 8. Material Cost Form Instructions: Insert the required information in the blue highlighted cells. The Offeror shall allocate its material costs to the associated milestone and year of performance.

Insert a material support tab(s): An itemized list of the material/equipment proposed (i.e. a bill of materials) must be provided as a tab in this file and in the cost proposal submission. This tab at a minimum should identify the source data, (i.e. quote, purchase order, long term agreement, actuals, etc.....), the procurement type (sole source, competitive, competition attempted, commercial, etc....), the date of the source data, the source data quantity and the source data unit price. Include any additional adjustments made to the source data (i.e. volume adjustment for quantity, escalation for changes in period of performance, etc...).

Link the unit cost from the material support tab(s) to the material unit cost on Material Cost tab (Tab 8). If applicable insert any material overhead rate(s), G&A rate(s), cost of money rate(s), and profit/fee rate(s) being proposed. Link the proposed base cost, contained in this tab, to its respective indirect rate base cost field, and apply the proposed indirect rate to this base cost.

Additionally, for each piece of proposed material/equipment that is included in the top 80% of the total proposed extended material cost provide a copy of the basis of cost documentation (i.e., vendor quote, catalog pricing data, past purchase orders, etc.) that indicates the item(s) being purchased, quantity and unit cost of each item). The top 80% of the proposed extended material cost is calculated at the net amount after escalation, volume adjustments, challenges, etc.. have been applied to the proposed base cost of each material item.

Tab 9. Subcontract Cost Form Instructions: Insert the required information in the blue highlighted cells. The Offeror shall allocate its subcontract costs to the associated milestone and year of performance. If applicable insert any prime overhead rate(s), G&A rate(s), cost of money rate(s), and profit/fee rate(s) being proposed. Link the proposed base cost, contained in this tab, to its respective indirect rate base cost field, and apply the proposed indirect rate to this base cost.

For Subcontracts less than $75,000: The Prime must confirm that they have reviewed the proposed costs and determined they are fair and reasonable. A description of the analysis performed and result on how the prime determined the subcontract cost fair and reasonable shall be included in the cost proposal submission.

Team Members/Subcontractors: For proposed team members/subcontractors of which the individual proposed price is greater than or equal to $75,000, the subcontractor shall provide its own Milestone Pricing Excel file and a detailed proposal broken out by month and by element of cost for each of the team members/subcontractors proposed must be provided in the Offeror’s cost proposal submission. Team member/subcontractor proposals must be as detailed as possible, but at a minimum must include the following: labor categories and hours specified, list of material/equipment and other direct costs, travel detail, lower tier subcontractors/consultants identified, indirect costs and fee. The Offeror must also state that a cost and price analysis has been performed on all team members/subcontractors and provide documentation supporting the determination of price reasonableness. Offerors shall also provide a list of all team members/subcontractors and a total cost for each team member. Please identify if each team member/subcontractor is a traditional or nontraditional defense contractor.

Justify the specific technical need for a consultant. Provide a vitae of academic and experience qualifications. In the Consultant Support tab (Tab 10a) detail the labor category, number of hours required, and the rate per hour. Document where/when consultant has received proposed rate in performing similar services for others. Any necessary justification attachments should be provided within your Cost Proposal Narrative and Supporting Documents file.

For proposed team Consultants of which the proposed price is less than $75,000, the Offeror must confirm that they have reviewed the proposed costs and determined they are fair and reasonable. Offerors shall identify if each Consultant is a traditional or nontraditional defense contractor for all Consultants no matter their proposed cost. The Offeror must also state that a cost and price analysis has been performed on all Consultants and confirm the proposed costs are determined fair and reasonable.

For proposed Consultants of which the individual proposed price is greater than or equal to $75,000, a detailed proposal broken out by element of cost (i.e. labor categories, associated hours, travel, other direct costs, etc.) for each of the Consultants shall be provided in the prime Offeror’s cost proposal submission. The Offeror shall provide a list of all Consultants and a total cost for each consultant. The Offeror must also state that a cost and price analysis has been performed on all Consultants greater than or equal to $75,000 and provide documentation supporting the determination of price reasonableness.

Tab 11. ODC Cost Form Instructions: Insert the required information in the blue highlighted cells. The Offeror shall allocate its ODC costs to the associated milestone and year of performance. If applicable include any prime overhead rate(s), G&A rate(s), cost of money rate(s), and profit/fee rate(s) being proposed. Link the proposed base cost, contained in this tab, to its respective indirect rate base cost field, and apply the proposed indirect rate to this base cost.

The Offeror must identify and provide a detailed description of any Other Direct Costs that do not fit into the cost elements above, including the basis for determining those costs (i.e., vendor quotes, catalog pricing data, company estimating procedures, etc.), in the Offeror’s cost proposal submission. Additionally, for each proposed Other Direct Cost with a unit cost greater than or equal to $25,000, a copy of the basis of cost documentation (i.e., vendor quote, catalog pricing data, past purchase orders, etc.) must be included in the Offeror’s cost proposal.

The Offeror must provide an estimate of the travel required for the proposed effort. A basis of cost for all travel elements must be included in the proposal and the Travel Support tab (Tab 12a), to include the nature of any proposed travel, estimated number of trips required, destinations, mode and cost of transportation, and number of man-days per trip. Additionally the Offeror must include the cost for airfare, lodging, per diems, car rental, mileage, and miscellaneous travel costs. Mileage is applicable if one uses its private vehicle for transportation to the destination (Mileage is not applicable for car rentals as its included in the daily rate). Note: Offerors are expected to be cost-conscious regarding travel, for example, the contractor should propose in accordance with the Joint Travel Regulation. Travel costs that are deemed excessive (e.g., first class airfares, exorbitant hotel room charges, etc.) will be adjusted to a reasonable cost.

Indirect Rates Form Instructions: Insert the proposed indirect rate in the highlighted blue cells of the applicable direct cost tab and link the base cost the indirect rate is applied to within that tab.

The Offeror shall identify all proposed indirect costs (e.g., labor overhead, fringe benefits, material overhead, G&A, cost of money) and associated rates and provide supporting documentation. Documentation to support proposed indirect costs shall be provided in the cost proposal submission in the form of Government Agreement or detailed rate make up for the indirect costs. In terms of detailed rate make up for the indirect costs, the Offeror shall submit the expense pools and allocation bases that make up the indirect rate, the previous 3 years of forecasted and actual indirect rates, and a breakdown of the costs that make up 2-3 items in each expense pool. Order of preference for supporting documentation is as follows: Government Agreement or Recommendation (DCMA, FPRA or FPRR or DCAA Audit); detailed rate make up as identified above.

Alternately, in lieu of providing the supporting documentation for your indirect costs within the cost proposal submission, if the Offeror can obtain appropriate Government assistance on its own, the Offeror may provide a letter from the Cognizant Government audit agency stating that, based upon their review of the Offeror's proposal, the indirect rates used in the proposal are approved by a Government agency and were applied correctly in this specific proposal.

Profit / Fee Form Instructions: A final determination of fee will be reviewed and adjusted in accordance with the Government’s DFARS 215.404-71 Weighted guidelines method. Proposing Profit/Fee is allowable to include in a cost proposal when cost share is not being contributed by the Offeror.

Insert the proposed profit/fee rate in the highlighted blue cells of the applicable direct cost tab and link the base cost profit/fee is applied to within that tab.

Tab 13. Data Input Summary No input is required. This tab can be used to verify all inputted data across all tabs within this workbook is accurate.

2. General

COST PROPOSAL

GENERAL INFORMATION

Sign and date the form at the bottom where indicated.

Name of Company Contract Type (Include all contract types being proposed) Total Period of Performance

Annual Plan Requirement Identifier (Not needed for ad-hocs)

Business Contact and Address Project Submission Title

Typed Name and Title Signature Date

List your Team Members below and identify whether they are a Nontraditional or Traditional subcontractor/supplier. All Nontraditional organizations must complete and sign a Warranties & Representation Form.

3. Rate Backup

Form Instructions: For both direct and indirect rates, insert the information in the blue highlighted cells below.

Direct Labor Rates Documentation to support proposed labor category rates shall be provided in the cost proposal submission in the form of Government Agreement or Recommendation or payroll records. Order of preference for supporting documentation is as follows: Government Agreement or Recommendation (DCMA FPRA or FPRR or DCAA Audit); Payroll records for proposed personnel.

Indirect Rates:

Documentation to support proposed indirect costs shall be provided in the cost proposal submission in the form of Government Agreement or detailed rate make up for the indirect costs. In terms of detailed rate make up for the indirect costs, the Offeror shall submit the expense pools and allocation bases that make up the indirect rate, the previous 3 years of forecasted and actual indirect rates, and a breakdown of the costs that make up 2-3 items in each expense pool. Order of preference for supporting documentation is as follows: Government Agreement or Recommendation (DCMA, FPRA or FPRR or DCAA Audit); detailed rate make up as identified above.

Alternately, in lieu of providing the supporting documentation for your indirect costs within the cost proposal submission, if the Offeror can obtain appropriate Government assistance on its own, the Offeror may provide a letter from the Cognizant Government audit agency stating that, based upon their review of the Offeror's proposal, the indirect rates used in the proposal are approved by a Government agency and were applied correctly in this specific proposal.

4. Milestone Schedule

Milestone Schedule

Form Instructions: Insert the required information in the blue highlighted cells.

Milestone Number

Total Proposed

5. Total Cost-Price Summary

Total Cost-Price Summary

Form Instructions: Insert the required information in the blue highlighted cells.

Share

6. Milestone Cost-Price Summary

Milestone Cost-Price Summary

Form Instructions: Nothing to Input

Grand Total Price $ - 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 Grand Total Price $ - 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 Grand Total Price $ - 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 Grand Total Price $ - 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 Grand Total Price $ - 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 Grand Total Price $ - 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

7. Labor Cost

Labor Cost

Form Instructions: Insert the required information in the blue highlighted cells. The Offeror shall input the period of performance in cells D6, AI6, BN6, CS6, and DX6. The period of performance shall reflect when the Offeror is projecting to perform the requirement. The Offeror shall allocate by milestone and year of performance the proposed hours and hourly rate for each labor category. If applicable insert any direct labor fringe rate(s), overhead rate(s), G&A rate(s), cost of money rate(s), and profit/fee rate(s) being proposed. Link the proposed base cost, contained in this tab, to its respective indirect rate base cost field, and apply the proposed indirect rate to this base cost. Documentation to support proposed labor category rates shall be provided in the cost proposal submission in the form of Government Agreement or Recommendation or payroll records. Order of preference for supporting documentation is as follows: Government Agreement or Recommendation (DCMA FPRA or FPRR or DCAA Audit); Payroll records for proposed personnel.