Revised Fixed Rate Breakdown by Cost
133 KB Posted
- Attached to
- Administrative Support Service
- Solicitation number
- HSHQDC-12-R-00002
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 Category | Total 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 Category | Total 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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| 5.0000 | ||||||||||||||||
| Project Manager | 1,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 | ||||||||||
| Total | 59,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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| Executive Assistant DC | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Executive Assistant PA | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant TX | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant CO | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Total | 500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Travel at NTE Amount of $12, 500 | Travel 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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| 5.0000 | ||||||||||||||||
| Project Manager | 1,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 | ||||||||||
| Total | 59,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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| $12,500.00 | ||||||||||||||||
| Executive Assistant DC | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Executive Assistant PA | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant TX | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant CO | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Total | 500.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Travel at NTE Amount of $12, 500 | Travel 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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| 5.0000 | ||||||||||||||||
| Project Manager | 1,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 | ||||||||||
| Total | 59,520 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| $12,500.00 | ||||||||||||||||
| Surge - Labor Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| $ - 0 | ||||||||||||||||
| Executive Assistant DC | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Executive Assistant PA | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant TX | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant CO | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Total | 500.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Travel at NTE Amount of $12, 500 | Travel 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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| 5.0000 | ||||||||||||||||
| Project Manager | 1,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 | ||||||||||
| Total | 59,520 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| $12,500.00 | ||||||||||||||||
| Surge - Labor Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| $ - 0 | ||||||||||||||||
| Executive Assistant DC | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Executive Assistant PA | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant TX | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant CO | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Total | 500.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Travel at NTE Amount of $12, 500 | Travel 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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| 5.0000 | ||||||||||||||||
| Project Manager | 1,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 | ||||||||||
| Total | 59,520 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Surge - Labor Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| Executive Assistant DC | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Executive Assistant PA | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant TX | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant CO | 100 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Total | 500.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Travel at NTE Amount of $12, 500 | Travel 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 Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| 5.0000 | ||||||||||||||||
| Project Manager | 960 | $ - 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 | ||||||||||
| Total | 29,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Surge - Labor Category | Hours | Hourly Wage | Total Labor | Overtime Premium | Health & Welfare | Paid Time Off (PTO) to Include Holiday, Vacation, Sick, Bereavement, and Other | Taxes (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) | Overhead | Other Direct Costs (ODC) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Hourly Rate |
| Executive Assistant DC | 100 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Executive Assistant PA | 50 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant TX | 50 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Executive Assistant CO | 50 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| Total | 250.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Travel at NTE Amount of $12, 500 | Travel 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 | ||
| 2012 WD Colorado.pdf | ||
| Proposal Cover.doc | DOC document | |
| 2012 WD DC.pdf | ||
| Final Q A Amendment 0003.doc | DOC document | |
| Reps Certs.pdf | ||
| 2012 WD PA.pdf | ||
| Revised Fixed Rate Breakdown by Cost | — | |
| Schedule of Prices.xls | XLS spreadsheet | |
| 2012 WD Texas.pdf | ||
| Revised Deliverable Schedule.docx | DOCX document | |
| SF 30.pdf | ||
| Statement of Work.doc | DOC document | |
| Amendment 00002.pdf | ||
| Position Description.doc | DOC document | |
| Past Project.Ctr Performance.Quotation Cover.doc | DOC document | |
| Amendment 00001.pdf | ||
| Final PDF File.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 .