Admin_Cost_Breakdown_Spreadsheet_REV_3-3-15.xlsx
XLSX spreadsheet 63 KB Posted
- Solicitation number
- HSHQE3-15-R-00001
About this file
Attachment VI - Revised Spreadsheet for Price Calculation and Cost Breakdown
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment_000007.pdf | ||
| Amendment_000006.pdf | ||
| Revised_SOW_-3-17-15.docx | DOCX document | |
| Attachment_II_-_WD_2005-2247_REV._16_dated_12-22-2014.txt | TXT text file | |
| Attachment_8-_Revised_Schedule_of_Services_3-3-15.docx | DOCX document | |
| Attachment_III_-_WD_2005-2449_REV_15_dated_12-22-2014.txt | TXT text file | |
| Past_Project_Form_-_Attachment_IV.docx | DOCX document | |
| Past_Performance_Questionnaire_-_Attachment_V_(2-3).docx | DOCX document | |
| Amendment_000005.pdf | ||
| Amendment_00004_revised_3-9.pdf | ||
| Amendment_000003.pdf | ||
| Amendment_000002.pdf | ||
| Amendment_000001.pdf | ||
| Solicitation.zip | ZIP file |
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Summary - Price
| Summary of Prices |
| Note this Worksheet calculates automatically based on the entries made to the Base and Option Tabs. |
Offeror:
Basic Services - Labor Category Amount
| Secretary II (Philadelphia, PA) - 3 positions | $ - 0 |
| Secretary II (Baltimore, MD) - 1 Position | - 0 |
| Secretary II (Woodlawn, MD) - 1 Position | - 0 |
| Secretary II (Woodlawn, MD) - 1 Position | - 0 |
| Optional Additional Secretary II (All locations) -2 Positions | - 0 |
| Total Price | $ - 0 |
Travel at NTE Amount of $5,000.00 Total
| Not-to-Exceed Travel | $ 27,500.00 |
| Total Indirect Costs Applicable to Travel | - 0 |
| Total Travel with Burden | $ 27,500.00 |
| Grand Total | |
| 27,500.00 |
ATTACHMENT VI: Fixed Rate Breakdown by Cost Element &D
Instructions
This worksheet automatically populates based on the entries made on tabs: Base, Option I, Option II, Option III, Option IV, and the 6 Month Extension Option.
Rate Breakdown - Base
| Offeror: | BASE PERIOD - FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT - LABOR CATEGORY SECRETARY II | |
| ____________________________________________ | ATTACHMENT # VI |
| Base Year | |||||||||||||||
| Basic Services - Labor Category | Hours | Hourly Wage | Total Labor | 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, H&W, PTO, Taxes and WCI (Columns D through H) | Overhead (if applicable) | Other Direct Costs (ODC) (if applicable) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Monthly Price |
| 5.0000 | |||||||||||||||
| Secretary II (Philadelphia, PA) - 3 positions | 5,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Secretary II (Baltimore, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,250 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Optional Additional Secretary II (All locations) -2 Positions | |||||||||||||||
| Total | 10,850 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TRAVEL | |
| Travel at NTE Amount of $5,000.00 | Travel and Associated Indirect Burden |
| Not-to-Exceed Travel | $5,000.00 |
| Indirect Rate Applicable to Travel | |
| Total Indirect Costs Applicable to Travel | $ - 0 |
| Total Travel with Burden | $ 5,000.00 |
&D
Page &P of &N
Instructions
1. Offeror - The contractor must complete this or a similar 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.
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, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.
3. Additional Labor - Beginning with Option I, there will be a CLIN for additional not-to-exceed hours due to a projected need of up to three additional personnel. In the highlighted cells, input fully burdened labor hour rates for the General Clerk II labor category. A single labor hour rate will be used for Clerk II additional labor at all locations. Note that the additional labor costs shall not be included in the fixed monthly prices but will be billed separately based on actual number of additional hours utilized.
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 - Option 1
| Offeror: | OPTION I- FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORY SECRETARY II | |
| ATTACHMENT # VI |
| Option Period 1 | |||||||||||||||
| Basic Services - Labor Category | Hours | Hourly Wage | Total Labor | 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, H&W, PTO, Taxes and WCI (Columns D through H) | Overhead (if applicable) | Other Direct Costs (ODC) (if applicable) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Monthly Price |
| 5.0000 | |||||||||||||||
| Secretary II (Philadelphia, PA) - 3 positions | 5,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Secretary II (Baltimore, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| SecretaryII (Woodlawn, MD) - 1 Position | 1,250 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Optional Additional Secretary II (All locations) -2 Positions | 3,840 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Total | 14,690 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TRAVEL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Travel at NTE Amount of $5,000 | Travel and Associated Indirect Burden | |||||
| Not-to-Exceed Travel | $5,000.00 | |||||
| Indirect Rate Applicable to Travel | ||||||
| Total Indirect Costs Applicable to Travel | $ - 0 | |||||
| Total Travel with Burden | $ 5,000.00 |
Page &P of &N
Instructions
1. Offeror - The contractor must complete this or a similar 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.
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, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.
3. Additional Labor - Beginning with Option I, there will be a CLIN for additional not-to-exceed hours due to a projected need of up to three additional personnel. In the highlighted cells, input fully burdened labor hour rates for the General Clerk II labor category. A single labor hour rate will be used for Clerk II additional labor at all locations. Note that the additional labor costs shall not be included in the fixed monthly prices but will be billed separately based on actual number of additional hours utilized.
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 - Option II
| Offeror: | Option II - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORY SECRETARY II | |
| ATTACHMENT # VI |
| Option Period 1 | |||||||||||||||
| Basic Services - Labor Category | Hours | Hourly Wage | Total Labor | 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, H&W, PTO, Taxes and WCI (Columns D through H) | Overhead (if applicable) | Other Direct Costs (ODC) (if applicable) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Monthly Price |
| 5.0000 | |||||||||||||||
| Secretary II (Philadelphia, PA) - 3 positions | 5,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Secretary II (Baltimore, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,250 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Optional Additional Secretary II (All locations) -2 Positions | 3,840 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Total | 14,690 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TRAVEL | |
| Travel at NTE Amount of $5,000 | Travel and Associated Indirect Burden |
| Not-to-Exceed Travel | $5,000.00 |
| Indirect Rate Applicable to Travel | |
| Total Indirect Costs Applicable to Travel | $ - 0 |
| Total Travel with Burden | $ 5,000.00 |
Page &P of &N
Instructions
1. Offeror - The contractor must complete this or a similar 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.
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, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.
3. Additional Labor - Beginning with Option I, there will be a CLIN for additional not-to-exceed hours due to a projected need of up to three additional personnel. In the highlighted cells, input fully burdened labor hour rates for the General Clerk II labor category. A single labor hour rate will be used for Clerk II additional labor at all locations. Note that the additional labor costs shall not be included in the fixed monthly prices but will be billed separately based on actual number of additional hours utilized.
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 - Option III
| Offeror: | OPTION III - FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT - LABOR CATEGORY SECRETARY II | |
| ATTACHMENT # VI |
| Option Period 1 | |||||||||||||||
| Basic Services - Labor Category | Hours | Hourly Wage | Total Labor | 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, H&W, PTO, Taxes and WCI (Columns D through I) | Overhead (if applicable) | Other Direct Costs (ODC) (if applicable) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Monthly Price |
| 5.0000 | |||||||||||||||
| Secretary II (Philadelphia, PA) - 3 positions | 5,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Secretary II (Baltimore, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,250 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Optional Additional Secretary II (All locations) -2 Positions | 3,840 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Total | 14,690 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TRAVEL | |
| Travel at NTE Amount of $5,000.00 | Travel and Associated Indirect Burden |
| Not-to-Exceed Travel | $5,000.00 |
| Indirect Rate Applicable to Travel | |
| Total Indirect Costs Applicable to Travel | $ - 0 |
| Total Travel with Burden | $ 5,000.00 |
Page &P of &N
Instructions
1. Offeror - The contractor must complete this or a similar 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.
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, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.
3. Additional Labor - Beginning with Option I, there will be a CLIN for additional not-to-exceed hours due to a projected need of up to three additional personnel. In the highlighted cells, input fully burdened labor hour rates for the General Clerk II labor category. A single labor hour rate will be used for Clerk II additional labor at all locations. Note that the additional labor costs shall not be included in the fixed monthly prices but will be billed separately based on actual number of additional hours utilized.
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 I, Option II, Option III, Option IV, 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 - Option IV
| Offeror: | Option IV - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORY SECRETARY II | |
| ATTACHMENT # VI |
| Option Period 4 | |||||||||||||||
| Basic Services - Labor Category | Hours | Hourly Wage | Total Labor | 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, H&W, PTO, Taxes and WCI (Columns D through I) | Overhead (if applicable) | Other Direct Costs (ODC) (if applicable) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Monthly Price |
| 5.0000 | |||||||||||||||
| Secretary II (Philadelphia, PA) - 3 positions | 5,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Secretary II (Baltimore, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 1,250 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Optional Additional Secretary II (All locations) -2 Positions | 3,840 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Total | 14,690 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TRAVEL | |
| Travel at NTE Amount of $5,000.00 | Travel and Associated Indirect Burden |
| Not-to-Exceed Travel | $5,000.00 |
| Indirect Rate Applicable to Travel | |
| Total Indirect Costs Applicable to Travel | $ - 0 |
| Total Travel with Burden | $ 5,000.00 |
Page &P of &N
Instructions
1. Offeror - The contractor must complete this or a similar 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.
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, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.
3. Additional Labor - Beginning with Option I, there will be a CLIN for additional not-to-exceed hours due to a projected need of up to three additional personnel. In the highlighted cells, input fully burdened labor hour rates for the General Clerk II labor category. A single labor hour rate will be used for Clerk II additional labor at all locations. Note that the additional labor costs shall not be included in the fixed monthly prices but will be billed separately based on actual number of additional hours utilized.
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 I, Option II, Option III, Option IV, 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
| Offeror: | 6 MONTH EXTENSION PERIOD - FIXED RATE BREAKDOWN FOR ADMINISTRATE SUPPORT - LABOR CATEGORY SECRETARY II | |
| ATTACHMENT # VI |
| 6 Month Extension | |||||||||||||||
| Basic Services - Labor Category | Hours | Hourly Wage | Total Labor | 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, H&W, PTO, Taxes and WCI (Columns D through I) | Overhead (if applicable) | Other Direct Costs (ODC) (if applicable) | General and Administrative (G&A) | Total Cost | Profit | Total Price | Fixed Monthly Price |
| 5.0000 | |||||||||||||||
| Secretary II (Philadelphia, PA) - 3 positions | 2,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Secretary II (Baltimore, MD) - 1 Position | 960 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 960 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Secretary II (Woodlawn, MD) - 1 Position | 625 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Optional Additional Secretary II (All locations) -2 Positions | 1,920 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
| Total | 7,345 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TRAVEL | |
| Travel at NTE Amount of $2, 500 | Travel and Associated Indirect Burden |
| Not-to-Exceed Travel | $2,500.00 |
| Indirect Rate Applicable to Travel | |
| Total Indirect Costs Applicable to Travel | $ - 0 |
| Total Travel with Burden | $ 2,500.00 |
Page &P of &N
Instructions
1. Offeror - The contractor must complete this or a similar 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.
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, H&W, PTO, Taxes and WCI, Total Cost, Total Price, and the Fixed Monthly Price.
3. Additional Labor - Beginning with Option I, there will be a CLIN for additional not-to-exceed hours due to a projected need of up to three additional personnel. In the highlighted cells, input fully burdened labor hour rates for the General Clerk II labor category. A single labor hour rate will be used for Clerk II additional labor at all locations. Note that the additional labor costs shall not be included in the fixed monthly prices but will be billed separately based on actual number of additional hours utilized.
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 I, Option II, Option III, Option IV, 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.
deleted
Fixed Rate Breakdown by Cost Element &D
Page &P of &N
File details come from the government source that posted it. Updated .