Attachment 6a - Price Element Breakdown Instructions.doc

Attachment 6 - Supplement

Instructions for the Price Element Breakdown Template

Introduction This Price Element Breakdown Template is a Microsoft Excel based pricing tool that provides a standardized format developing the bill rates by CLIN and inputting the fixed indirect rates. The template was designed to assist offerors in pricing their proposal. Offerors should only complete those cost elements which apply to their proposal. The cost data provided in these worksheets are considered data other than certified cost pricing data as discussed under FAR 15.403-5(b)(2).

Instructions for Completion

1. The Price Element Breakdown file contains five worksheets entitled “Price Schedule”, “PSO and PST Price Model”, “Supervisor PSOs Price Model”, “VCS and SA Price Model”, and “Fixed Indirect Rates on ODCs”.

2. Provide the name of your company and the solicitation number for your submission in the header section of each worksheet.

3. The “Price Schedule” worksheet will automatically populate based on the bill rates calculated on the Price Model worksheets and the fixed indirect rates inputted on the “Fixed Indirect Rate(s) on ODCs” worksheet.

4. Each Price Model worksheet contains reference notes near the bottom of the worksheet. These notes either provide instructions for specific price elements/categories or require narratives on the bases of estimate certain price elements/categories listed on the Price Model worksheets.

5. The offeror shall input the rates, hours, and cost amounts for those line items listed on the Price Model worksheets that apply to the current proposal.

6. Row 12 on each of the “PSO and PST Price Model” and “Supervisor PSOs Price Model worksheets automatically calculates Total Regular Wage Direct Labor. Total Regular Wage Direct Labor is calculated in each worksheet by multiplying the Regular Hourly Wage Rates Proposed inputted by the offeror in Row 7 by the Total Productive Hours Proposed inputted by the offeror in Row 10.

7. Row 18 on each of the Visitor Control Specialist/Security Analyst Price Model worksheet automatically calculates Total Regular Wage Direct Labor. Total Regular Wage Direct Labor is calculated in each worksheet by multiplying the Regular Hourly Wage Rates Proposed inputted by the offeror in Row 7 by the Total Productive Hours Proposed inputted by the offeror in Row 16.

8. Each Price Model worksheet automatically calculates subtotals by price element category. Grand totals are also calculated toward the bottom of each Price Model. Data should not be inputted into rows calculating subtotals or grand totals. Similarly, each Price Model worksheet automatically calculates a bill rate by CLIN. Data should not be inputted into rows calculating bill rates. These bill rates will automatically populate the “Price Schedule” worksheet.

9. There are rows on each Price Model worksheet to insert additional price elements under the “Other Costs” price category which are not included in the standardized listed elements. Similarly, there are rows under the “Indirect Positions” price category to insert additional indirect positions not already listed on the worksheets. If including “Other” price elements or indirect positions, insert a description of each element in the applicable worksheet cell. If additional “other” price elements are needed for the breakdown, please insert new rows and list the additional elements.

10. Additional worksheets may be provided to explain any calculations, bases of estimate, or other factors/judgments used to determine the pricing amounts in the template.

11. The “Price Schedule” worksheet is locked however the additional worksheets are not locked and may be adjusted by the offeror as appropriate.