Revised Fixed Rate Breakdown by Cost

133 KB Posted

Attached to
Administrative Support Service
Solicitation number
HSHQDC-12-R-00002
Issued by

About this file

Fixed Rate Breakdown Worksheet

Text of this file

Summary - Price

Summary of Prices
Note this Worksheet calculates automatically based on the entries made to the Base and Ordering Period Tabs. NO ENTRIES SHALL BE MADE TO THIS WORKSHEET
Offeror:
Basic Services - Labor CategoryTotal Price
Project Manager- 0
Executive Assistant DC (6ea)- 0
Executive Assistant PA (2ea)- 0
Executive Assistant TX (2ea)- 0
Executive Assistant CO (2ea)- 0
Administrative Assistant II DC (11ea)- 0
Administrative Assistant II PA (1ea)- 0
Administrative Assistant II TX (1ea)- 0
Administrative Assistant II CO (1ea)- 0
Receptionist DC (4ea)- 0
Total$ - 0
Surge - Labor CategoryTotal Price
$0.00
Executive Assistant DC- 0
Executive Assistant PA- 0
Executive Assistant TX- 0
Executive Assistant CO- 0
Total$ - 0
Total
Travel at NTE Amount of $12, 500
Not-to-Exceed Travel$68,750.00
Indirect Rate Applicable to Travel
Total Indirect Costs Applicable to Travel$0.00
Total Travel with Burden$68,750.00
Grand Total (Base, Four Options, and 6 month Extension Option)
$68,750.00

&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

Offeror:BASE PERIOD - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORIES PROJECT MANAGER, EXECUTIVE ASSISTANT, ADMINISTRATIVE ASSISTANT II, and RECEPTIONIST
FTEs to Staff Contract:
Performance Period: 10/1/2012 -09/30/2013
Base Year
Basic Services - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Compensation Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
5.0000
Project Manager1,920$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant DC (6ea)11,520- 0- 0- 0- 0$ - 0
Executive Assistant PA (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant TX (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant CO (2ea)3,840- 0- 0- 0- 0$ - 0
Administrative Assistant II DC (11ea)21,120- 0- 0- 0- 0$ - 0
Administrative Assistant II PA (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II TX (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II CO (1ea)1,920- 0- 0- 0- 0$ - 0
Receptionist DC (4ea)7,680- 0- 0- 0- 0$ - 0
Total59,520$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$0.00$0.00$0.00$0.00$0.00
Surge - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Comp Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
$0.00$0.00$0.00$0.00$0.00$0.00
Executive Assistant DC200$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant PA100- 0- 0- 0- 0$ - 0
Executive Assistant TX100- 0- 0- 0- 0$ - 0
Executive Assistant CO100- 0- 0- 0- 0$ - 0
Total500$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel at NTE Amount of $12, 500Travel and Associated Indirect Burden
Not-to-Exceed Travel$12,500.00
Indirect Rate Applicable to Travel
Total Indirect Costs Applicable to Travel$ - 0
Total Travel with Burden$ 12,500.00

&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. Worksheet Entries - The worksheet will automatically calculate the total price and fixed hourly rate 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 Hourly rate.

3. 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.

4. 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 hourly rates 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

Offeror:ORDER PERIOD 1 - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORIES PROJECT MANAGER, EXECUTIVE ASSISTANT, ADMINISTRATIVE ASSISTANT II, and RECEPTIONIST
FTEs to Staff Contract:
Performance Period: 10/1/2013 - 9/30/2014
Option Period 1
Basic Services - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Compensation Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
5.0000
Project Manager1,920$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant DC (6ea)11,520- 0- 0- 0- 0$ - 0
Executive Assistant PA (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant TX (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant CO (2ea)3,840- 0- 0- 0- 0$ - 0
Administrative Assistant II DC (11ea)21,120- 0- 0- 0- 0$ - 0
Administrative Assistant II PA (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II TX (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II CO (1ea)1,920- 0- 0- 0- 0$ - 0
Receptionist DC (4ea)7,680- 0- 0- 0- 0$ - 0
Total59,520$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$0.00$0.00$0.00$0.00$0.00
Surge - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Comp Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
$12,500.00
Executive Assistant DC200$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant PA100- 0- 0- 0- 0$ - 0
Executive Assistant TX100- 0- 0- 0- 0$ - 0
Executive Assistant CO100- 0- 0- 0- 0$ - 0
Total500.0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel at NTE Amount of $12, 500Travel and Associated Indirect Burden
Not-to-Exceed Travel$12,500.00
Indirect Rate Applicable to Travel
Total Indirect Costs Applicable to Travel$ - 0
Total Travel with Burden$ 12,500.00

&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. Worksheet Entries - The worksheet will automatically calculate the total price and fixed hourly rate 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 Hourly rate.

3. 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.

4. 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 hourly rates 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

Offeror:ORDER PERIOD 2 - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORIES PROJECT MANAGER, EXECUTIVE ASSISTANT, ADMINISTRATIVE ASSISTANT II, and RECEPTIONIST
FTEs to Staff Contract:
Performance Period: 10/1/2014 - 09/30/2015
Option Period 1
Basic Services - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Compensation Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
5.0000
Project Manager1,920$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant DC (6ea)11,520- 0- 0- 0- 0$ - 0
Executive Assistant PA (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant TX (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant CO (2ea)3,840- 0- 0- 0- 0$ - 0
Administrative Assistant II DC (11ea)21,120- 0- 0- 0- 0$ - 0
Administrative Assistant II PA (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II TX (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II CO (1ea)1,920- 0- 0- 0- 0$ - 0
Receptionist DC (4ea)7,680- 0- 0- 0- 0$ - 0
Total59,520$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$12,500.00
Surge - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Comp Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
$ - 0
Executive Assistant DC200$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant PA100- 0- 0- 0- 0$ - 0
Executive Assistant TX100- 0- 0- 0- 0$ - 0
Executive Assistant CO100- 0- 0- 0- 0$ - 0
Total500.0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel at NTE Amount of $12, 500Travel and Associated Indirect Burden
Not-to-Exceed Travel$12,500.00
Indirect Rate Applicable to Travel
Total Indirect Costs Applicable to Travel$ - 0
Total Travel with Burden$ 12,500.00

&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. Worksheet Entries - The worksheet will automatically calculate the total price and fixed hourly rate 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 Hourly rate.

3. 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.

4. 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 hourly rates 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

Offeror:ORDER PERIOD 3 - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORIES PROJECT MANAGER, EXECUTIVE ASSISTANT, ADMINISTRATIVE ASSISTANT II, and RECEPTIONIST
FTEs to Staff Contract:
Performance Period: 10/1/2015 - 09/30/2016
Option Period 1
Basic Services - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Compensation Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
5.0000
Project Manager1,920$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant DC (6ea)11,520- 0- 0- 0- 0$ - 0
Executive Assistant PA (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant TX (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant CO (2ea)3,840- 0- 0- 0- 0$ - 0
Administrative Assistant II DC (11ea)21,120- 0- 0- 0- 0$ - 0
Administrative Assistant II PA (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II TX (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II CO (1ea)1,920- 0- 0- 0- 0$ - 0
Receptionist DC (4ea)7,680- 0- 0- 0- 0$ - 0
Total59,520$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$12,500.00
Surge - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Comp Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
$ - 0
Executive Assistant DC200$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant PA100- 0- 0- 0- 0$ - 0
Executive Assistant TX100- 0- 0- 0- 0$ - 0
Executive Assistant CO100- 0- 0- 0- 0$ - 0
Total500.0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel at NTE Amount of $12, 500Travel and Associated Indirect Burden
Not-to-Exceed Travel$12,500.00
Indirect Rate Applicable to Travel
Total Indirect Costs Applicable to Travel$ - 0
Total Travel with Burden$ 12,500.00

&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. Worksheet Entries - The worksheet will automatically calculate the total price and fixed hourly rate 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 Hourly rate.

3. 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.

4. 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 hourly rates 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

Offeror:ORDER PERIOD 4 - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORIES PROJECT MANAGER, EXECUTIVE ASSISTANT, ADMINISTRATIVE ASSISTANT II, and RECEPTIONIST
FTEs to Staff Contract:
Performance Period: 10/1/2016 - 09/30/2017
Option Period 4
Basic Services - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Compensation Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
5.0000
Project Manager1,920$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant DC (6ea)11,520- 0- 0- 0- 0$ - 0
Executive Assistant PA (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant TX (2ea)3,840- 0- 0- 0- 0$ - 0
Executive Assistant CO (2ea)3,840- 0- 0- 0- 0$ - 0
Administrative Assistant II DC (11ea)21,120- 0- 0- 0- 0$ - 0
Administrative Assistant II PA (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II TX (1ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II CO (1ea)1,920- 0- 0- 0- 0$ - 0
Receptionist DC (4ea)7,680- 0- 0- 0- 0$ - 0
Total59,520$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Surge - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Comp Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
Executive Assistant DC200$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant PA100- 0- 0- 0- 0$ - 0
Executive Assistant TX100- 0- 0- 0- 0$ - 0
Executive Assistant CO100- 0- 0- 0- 0$ - 0
Total500.0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel at NTE Amount of $12, 500Travel and Associated Indirect Burden
Not-to-Exceed Travel$12,500.00
Indirect Rate Applicable to Travel
Total Indirect Costs Applicable to Travel$ - 0
Total Travel with Burden$ 12,500.00

&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. Worksheet Entries - The worksheet will automatically calculate the total price and fixed hourly rate 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 Hourly rate.

3. 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.

4. 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 hourly rates 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

Offeror:6 MONTH EXTENSION PERIOD - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORIES PROJECT MANAGER, EXECUTIVE ASSISTANT, ADMINISTRATIVE ASSISTANT II, and RECEPTIONIST
FTEs to Staff Contract:
Performance Period: 10/1/2017 - 03/31/2018
6 Month Extension
Basic Services - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Compensation Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
5.0000
Project Manager960$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant DC (6ea)5,760- 0- 0- 0- 0$ - 0
Executive Assistant PA (2ea)1,920- 0- 0- 0- 0$ - 0
Executive Assistant TX (2ea)1,920- 0- 0- 0- 0$ - 0
Executive Assistant CO (2ea)1,920- 0- 0- 0- 0$ - 0
Administrative Assistant II DC (11ea)10,560- 0- 0- 0- 0$ - 0
Administrative Assistant II PA (1ea)960- 0- 0- 0- 0$ - 0
Administrative Assistant II TX (1ea)960- 0- 0- 0- 0$ - 0
Administrative Assistant II CO (1ea)960- 0- 0- 0- 0$ - 0
Receptionist DC (4ea)3,840- 0- 0- 0- 0$ - 0
Total29,760$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Surge - Labor CategoryHoursHourly WageTotal LaborOvertime PremiumHealth & WelfarePaid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and OtherTaxes (To include SUTA and FUTA)Workers Comp Insurance (WCI)Total of Labor Costs, Overtime Premium, H&W, PTO, Taxes and WCI (Columns D through I)OverheadOther Direct Costs (ODC)General and Administrative (G&A)Total CostProfitTotal PriceFixed Hourly Rate
Executive Assistant DC100$ - 0$ - 0$ - 0$ - 0$ - 0
Executive Assistant PA50- 0- 0- 0- 0$ - 0
Executive Assistant TX50- 0- 0- 0- 0$ - 0
Executive Assistant CO50- 0- 0- 0- 0$ - 0
Total250.0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel at NTE Amount of $12, 500Travel and Associated Indirect Burden
Not-to-Exceed Travel$6,250.00
Indirect Rate Applicable to Travel
Total Indirect Costs Applicable to Travel$ - 0
Total Travel with Burden$ 6,250.00

&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. Worksheet Entries - The worksheet will automatically calculate the total price and fixed hourly rate 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 Hourly rate.

3. 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.

4. 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 hourly rates 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.

Other files

File Type Posted
Schedule of Prices.xls XLS spreadsheet
Amendment.pdf PDF
2012 WD Colorado.pdf PDF
Proposal Cover.doc DOC document
2012 WD DC.pdf PDF
Final Q A Amendment 0003.doc DOC document
Reps Certs.pdf PDF
2012 WD PA.pdf PDF
Revised Fixed Rate Breakdown by Cost —
Schedule of Prices.xls XLS spreadsheet
2012 WD Texas.pdf PDF
Revised Deliverable Schedule.docx DOCX document
SF 30.pdf PDF
Statement of Work.doc DOC document
Amendment 00002.pdf PDF
Position Description.doc DOC document
Past Project.Ctr Performance.Quotation Cover.doc DOC document
Amendment 00001.pdf PDF
Final PDF File.pdf PDF
Fixed Rate Breakdown by Cost.xls XLS spreadsheet
Show all 20

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

File details come from the government source that posted it. Updated .