Attachment_5__Fixed_Rate_Breakdown_by_Cost.xls

Summary - Price

&C Fixed Rate Breakdown by Cost Element&R&D &CPage &P of &N Instructions

This worksheet automatically populates based on the entries made on tabs: Base, Order 1, Order 2, Order 3, Order 4, and the 6 Month Extension Option

Rate Breakdown - Base

&C Fixed Rate Breakdown by Cost Element&R&D &CPage &P of &N Instructions

1. Offeror and FTEs - The contractor must complete this worksheet for purposes of the Government's Price Evaluation and Price Realism analysis. At the top of the worksheet the offeror shall enter the name of their company and the FTEs required to staff the contract.

FTE is the abbreviation for Full Time Equivalents. For purposes of this worksheet, full-time equivalent employees equal the number of employees on full-time schedules plus the number of employees on part-time schedules converted to a full-time basis to staff the contract. For instance, if 5000 hours are quoted for a particular labor category and on average the annual productive hours of a full time employee for that labor category is 1920 (2080 less 80 holiday less 80 vacation leave), the equivalent FTE to staff the labor category is calculated as 5000/1920 = 2.6 FTE. Note that for staffing to an FTE level a contractor may use a combination of full time and part time employees. This information shall be entered in the highlighted cell at the top of the worksheet.

2. Fixed Price Breakdown - The worksheet will automatically calculate the total price and fixed montly price for each labor category when the applicable Hourly Wage rate, Overtime Premium amount, Health and Welfare amount, Paid Time Off amount, Taxes amount, WCI amount, Overhead amount, ODC amount, G&A amount, and Profit amount are entered into the highlighted cells. Note the hours to be priced under this contract have already been populated and shall not be altered. The following categories are self-calculating and do not require entries: Total Labor, Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.

3. Additional Labor - There will be a CLIN for additional not-to-exceed hours above and beyond the fixed price effort. In the highlighted cells, input fully burdened labor hour rates for the Secretary I and General Clerk III labor categories. A single labor hour rate will be used for Clerk III additional labor at all locations.

4. Not-to-Exceed Travel - In the highlighted cell enter your indirect rate applicable to the given Not-to-Exceed travel amount. The indirect costs applicable to travel will automatically calculate in the labeled cell as well as the total proposed travel costs including the applicable indirect costs. The indirect rate applicable to travel will remain fixed over the life of the contract and is not subject to audit adjustment, given this is a commercial contract.

5. Summary - Price Tab - This worksheet will automatically calculate the total price, based on the entries to the highlighted cells contained in the tabs: Base, Option 1, Option 2, Option 3, Option 4, and the 6 Month Extension Option

In the event that the fixed monthly prices provided in this worksheet differs from the Schedule of Prices (Schedule B), the contractor's proposed price for this solicitation shall be considered the extended amounts shown on Schedule of Prices. Note that the data to complete these worksheets is considered other than certified cost or pricing data, and, therefore is not subject to certification as provided under FAR 15.403-1(b)(1) and (3).

Although modification of the worksheet should not be necessary, it is not locked, therefore cells may be altered as long as a narrative explanation is provided regarding any revisions to the embedded formulas.

Rate Breakdown - Order 1

&C Fixed Rate Breakdown by Cost Element&R&D &CPage &P of &N Instructions

1. Offeror and FTEs - The contractor must complete this worksheet for purposes of the Government's Price Evaluation and Price Realism analysis. At the top of the worksheet the offeror shall enter the name of their company and the FTEs required to staff the contract.

FTE is the abbreviation for Full Time Equivalents. For purposes of this worksheet, full-time equivalent employees equal the number of employees on full-time schedules plus the number of employees on part-time schedules converted to a full-time basis to staff the contract. For instance, if 5000 hours are quoted for a particular labor category and on average the annual productive hours of a full time employee for that labor category is 1920 (2080 less 80 holiday less 80 vacation leave), the equivalent FTE to staff the labor category is calculated as 5000/1920 = 2.6 FTE. Note that for staffing to an FTE level a contractor may use a combination of full time and part time employees. This information shall be entered in the highlighted cell at the top of the worksheet.

2. Fixed Price Breakdown - The worksheet will automatically calculate the total price and fixed montly price for each labor category when the applicable Hourly Wage rate, Overtime Premium amount, Health and Welfare amount, Paid Time Off amount, Taxes amount, WCI amount, Overhead amount, ODC amount, G&A amount, and Profit amount are entered into the highlighted cells. Note the hours to be priced under this contract have already been populated and shall not be altered. The following categories are self-calculating and do not require entries: Total Labor, Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.

3. Additional Labor - There will be a CLIN for additional not-to-exceed hours above and beyond the fixed price effort. In the highlighted cells, input fully burdened labor hour rates for the Secretary I and General Clerk III labor categories. A single labor hour rate will be used for Clerk III additional labor at all locations.

4. Not-to-Exceed Travel - In the highlighted cell enter your indirect rate applicable to the given Not-to-Exceed travel amount. The indirect costs applicable to travel will automatically calculate in the labeled cell as well as the total proposed travel costs including the applicable indirect costs. The indirect rate applicable to travel will remain fixed over the life of the contract and is not subject to audit adjustment, given this is a commercial contract.

5. Summary - Price Tab - This worksheet will automatically calculate the total price, based on the entries to the highlighted cells contained in the tabs: Base, Option 1, Option 2, Option 3, Option 4, and the 6 Month Extension Option

In the event that the fixed monthly prices provided in this worksheet differs from the Schedule of Prices (Schedule B), the contractor's proposed price for this solicitation shall be considered the extended amounts shown on Schedule of Prices. Note that the data to complete these worksheets is considered other than certified cost or pricing data, and, therefore is not subject to certification as provided under FAR 15.403-1(b)(1) and (3).

Although modification of the worksheet should not be necessary, it is not locked, therefore cells may be altered as long as a narrative explanation is provided regarding any revisions to the embedded formulas.

Rate Breakdown - Order 2

&C Fixed Rate Breakdown by Cost Element&R&D &CPage &P of &N Instructions

1. Offeror and FTEs - The contractor must complete this worksheet for purposes of the Government's Price Evaluation and Price Realism analysis. At the top of the worksheet the offeror shall enter the name of their company and the FTEs required to staff the contract.

FTE is the abbreviation for Full Time Equivalents. For purposes of this worksheet, full-time equivalent employees equal the number of employees on full-time schedules plus the number of employees on part-time schedules converted to a full-time basis to staff the contract. For instance, if 5000 hours are quoted for a particular labor category and on average the annual productive hours of a full time employee for that labor category is 1920 (2080 less 80 holiday less 80 vacation leave), the equivalent FTE to staff the labor category is calculated as 5000/1920 = 2.6 FTE. Note that for staffing to an FTE level a contractor may use a combination of full time and part time employees. This information shall be entered in the highlighted cell at the top of the worksheet.

2. Fixed Price Breakdown - The worksheet will automatically calculate the total price and fixed montly price for each labor category when the applicable Hourly Wage rate, Overtime Premium amount, Health and Welfare amount, Paid Time Off amount, Taxes amount, WCI amount, Overhead amount, ODC amount, G&A amount, and Profit amount are entered into the highlighted cells. Note the hours to be priced under this contract have already been populated and shall not be altered. The following categories are self-calculating and do not require entries: Total Labor, Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.

3. Additional Labor - There will be a CLIN for additional not-to-exceed hours above and beyond the fixed price effort. In the highlighted cells, input fully burdened labor hour rates for the Secretary I and General Clerk III labor categories. A single labor hour rate will be used for Clerk III additional labor at all locations.

4. Not-to-Exceed Travel - In the highlighted cell enter your indirect rate applicable to the given Not-to-Exceed travel amount. The indirect costs applicable to travel will automatically calculate in the labeled cell as well as the total proposed travel costs including the applicable indirect costs. The indirect rate applicable to travel will remain fixed over the life of the contract and is not subject to audit adjustment, given this is a commercial contract.

5. Summary - Price Tab - This worksheet will automatically calculate the total price, based on the entries to the highlighted cells contained in the tabs: Base, Option 1, Option 2, Option 3, Option 4, and the 6 Month Extension Option

In the event that the fixed monthly prices provided in this worksheet differs from the Schedule of Prices (Schedule B), the contractor's proposed price for this solicitation shall be considered the extended amounts shown on Schedule of Prices. Note that the data to complete these worksheets is considered other than certified cost or pricing data, and, therefore is not subject to certification as provided under FAR 15.403-1(b)(1) and (3).

Although modification of the worksheet should not be necessary, it is not locked, therefore cells may be altered as long as a narrative explanation is provided regarding any revisions to the embedded formulas.

Rate Breakdown - Order 3

&C Fixed Rate Breakdown by Cost Element&R&D &CPage &P of &N Instructions

1. Offeror and FTEs - The contractor must complete this worksheet for purposes of the Government's Price Evaluation and Price Realism analysis. At the top of the worksheet the offeror shall enter the name of their company and the FTEs required to staff the contract.

FTE is the abbreviation for Full Time Equivalents. For purposes of this worksheet, full-time equivalent employees equal the number of employees on full-time schedules plus the number of employees on part-time schedules converted to a full-time basis to staff the contract. For instance, if 5000 hours are quoted for a particular labor category and on average the annual productive hours of a full time employee for that labor category is 1920 (2080 less 80 holiday less 80 vacation leave), the equivalent FTE to staff the labor category is calculated as 5000/1920 = 2.6 FTE. Note that for staffing to an FTE level a contractor may use a combination of full time and part time employees. This information shall be entered in the highlighted cell at the top of the worksheet.

2. Fixed Price Breakdown - The worksheet will automatically calculate the total price and fixed montly price for each labor category when the applicable Hourly Wage rate, Overtime Premium amount, Health and Welfare amount, Paid Time Off amount, Taxes amount, WCI amount, Overhead amount, ODC amount, G&A amount, and Profit amount are entered into the highlighted cells. Note the hours to be priced under this contract have already been populated and shall not be altered. The following categories are self-calculating and do not require entries: Total Labor, Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.

3. Additional Labor - There will be a CLIN for additional not-to-exceed hours above and beyond the fixed price effort. In the highlighted cells, input fully burdened labor hour rates for the Secretary I and General Clerk III labor categories. A single labor hour rate will be used for Clerk III additional labor at all locations.

4. Not-to-Exceed Travel - In the highlighted cell enter your indirect rate applicable to the given Not-to-Exceed travel amount. The indirect costs applicable to travel will automatically calculate in the labeled cell as well as the total proposed travel costs including the applicable indirect costs. The indirect rate applicable to travel will remain fixed over the life of the contract and is not subject to audit adjustment, given this is a commercial contract.

5. Summary - Price Tab - This worksheet will automatically calculate the total price, based on the entries to the highlighted cells contained in the tabs: Base, Option 1, Option 2, Option 3, Option 4, and the 6 Month Extension Option

In the event that the fixed monthly prices provided in this worksheet differs from the Schedule of Prices (Schedule B), the contractor's proposed price for this solicitation shall be considered the extended amounts shown on Schedule of Prices. Note that the data to complete these worksheets is considered other than certified cost or pricing data, and, therefore is not subject to certification as provided under FAR 15.403-1(b)(1) and (3).

Although modification of the worksheet should not be necessary, it is not locked, therefore cells may be altered as long as a narrative explanation is provided regarding any revisions to the embedded formulas.

Rate Breakdown - Order 4

&C Fixed Rate Breakdown by Cost Element&R&D &CPage &P of &N Instructions

1. Offeror and FTEs - The contractor must complete this worksheet for purposes of the Government's Price Evaluation and Price Realism analysis. At the top of the worksheet the offeror shall enter the name of their company and the FTEs required to staff the contract.

FTE is the abbreviation for Full Time Equivalents. For purposes of this worksheet, full-time equivalent employees equal the number of employees on full-time schedules plus the number of employees on part-time schedules converted to a full-time basis to staff the contract. For instance, if 5000 hours are quoted for a particular labor category and on average the annual productive hours of a full time employee for that labor category is 1920 (2080 less 80 holiday less 80 vacation leave), the equivalent FTE to staff the labor category is calculated as 5000/1920 = 2.6 FTE. Note that for staffing to an FTE level a contractor may use a combination of full time and part time employees. This information shall be entered in the highlighted cell at the top of the worksheet.

2. Fixed Price Breakdown - The worksheet will automatically calculate the total price and fixed montly price for each labor category when the applicable Hourly Wage rate, Overtime Premium amount, Health and Welfare amount, Paid Time Off amount, Taxes amount, WCI amount, Overhead amount, ODC amount, G&A amount, and Profit amount are entered into the highlighted cells. Note the hours to be priced under this contract have already been populated and shall not be altered. The following categories are self-calculating and do not require entries: Total Labor, Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.

3. Additional Labor - There will be a CLIN for additional not-to-exceed hours above and beyond the fixed price effort. In the highlighted cells, input fully burdened labor hour rates for the Secretary I and General Clerk III labor categories. A single labor hour rate will be used for Clerk III additional labor at all locations.

4. Not-to-Exceed Travel - In the highlighted cell enter your indirect rate applicable to the given Not-to-Exceed travel amount. The indirect costs applicable to travel will automatically calculate in the labeled cell as well as the total proposed travel costs including the applicable indirect costs. The indirect rate applicable to travel will remain fixed over the life of the contract and is not subject to audit adjustment, given this is a commercial contract.

5. Summary - Price Tab - This worksheet will automatically calculate the total price, based on the entries to the highlighted cells contained in the tabs: Base, Option 1, Option 2, Option 3, Option 4, and the 6 Month Extension Option

In the event that the fixed monthly prices provided in this worksheet differs from the Schedule of Prices (Schedule B), the contractor's proposed price for this solicitation shall be considered the extended amounts shown on Schedule of Prices. Note that the data to complete these worksheets is considered other than certified cost or pricing data, and, therefore is not subject to certification as provided under FAR 15.403-1(b)(1) and (3).

Although modification of the worksheet should not be necessary, it is not locked, therefore cells may be altered as long as a narrative explanation is provided regarding any revisions to the embedded formulas.

Rate Breakdown -6 Month Ext

&C Fixed Rate Breakdown by Cost Element&R&D &CPage &P of &N Instructions

1. Offeror and FTEs - The contractor must complete this worksheet for purposes of the Government's Price Evaluation and Price Realism analysis. At the top of the worksheet the offeror shall enter the name of their company and the FTEs required to staff the contract.

FTE is the abbreviation for Full Time Equivalents. For purposes of this worksheet, full-time equivalent employees equal the number of employees on full-time schedules plus the number of employees on part-time schedules converted to a full-time basis to staff the contract. For instance, if 5000 hours are quoted for a particular labor category and on average the annual productive hours of a full time employee for that labor category is 1920 (2080 less 80 holiday less 80 vacation leave), the equivalent FTE to staff the labor category is calculated as 5000/1920 = 2.6 FTE. Note that for staffing to an FTE level a contractor may use a combination of full time and part time employees. This information shall be entered in the highlighted cell at the top of the worksheet.

2. Fixed Price Breakdown - The worksheet will automatically calculate the total price and fixed montly price for each labor category when the applicable Hourly Wage rate, Overtime Premium amount, Health and Welfare amount, Paid Time Off amount, Taxes amount, WCI amount, Overhead amount, ODC amount, G&A amount, and Profit amount are entered into the highlighted cells. Note the hours to be priced under this contract have already been populated and shall not be altered. The following categories are self-calculating and do not require entries: Total Labor, Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.

3. Additional Labor - There will be a CLIN for additional not-to-exceed hours above and beyond the fixed price effort. In the highlighted cells, input fully burdened labor hour rates for the Secretary I and General Clerk III labor categories. A single labor hour rate will be used for Clerk III additional labor at all locations.

4. Not-to-Exceed Travel - In the highlighted cell enter your indirect rate applicable to the given Not-to-Exceed travel amount. The indirect costs applicable to travel will automatically calculate in the labeled cell as well as the total proposed travel costs including the applicable indirect costs. The indirect rate applicable to travel will remain fixed over the life of the contract and is not subject to audit adjustment, given this is a commercial contract.

5. Summary - Price Tab - This worksheet will automatically calculate the total price, based on the entries to the highlighted cells contained in the tabs: Base, Option 1, Option 2, Option 3, Option 4, and the 6 Month Extension Option

In the event that the fixed monthly prices provided in this worksheet differs from the Schedule of Prices (Schedule B), the contractor's proposed price for this solicitation shall be considered the extended amounts shown on Schedule of Prices. Note that the data to complete these worksheets is considered other than certified cost or pricing data, and, therefore is not subject to certification as provided under FAR 15.403-1(b)(1) and (3).

Although modification of the worksheet should not be necessary, it is not locked, therefore cells may be altered as long as a narrative explanation is provided regarding any revisions to the embedded formulas.