Attachment_1_-_HSHQE6-16-R-00002_Fixed_Price_Breakdown_Spreadsheet_Rev1.xlsx
XLSX spreadsheet 65 KB Posted
- Solicitation number
- HSHQE6-16-R-00002
About this file
Revised Attachment 1 - Fixed Price Breakdown Spreadsheet
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment_0003_ro_RFP_HSHQE6-16-R-00002.pdf | ||
| Amendment_0002_to_RFP_HSHQE6-16-R-00002.pdf | ||
| Amendment_0001_to_RFP_HSHQE6-16-R-00002.pdf | ||
| HSHQE6-16-R-00002.pdf | ||
| Attachment_1_-_HSHQE6-16-R-00002_Price_Breakdown_Spreadsheet.xlsx | XLSX spreadsheet | |
| Attachment_2_-_Past_Project_Form.docx | DOCX document | |
| Attachment_3_-_Past_Performance_Questionnarie.docx | DOCX document |
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 |
| (Inclusive of all Option Periods and Option CLINS) |
| Offeror: | |
| Performance Period | Amount |
| Base Period (10/01/2016 - 09/30/2017) | $ 15,000.00 |
| Option 1 (10/01/2017 - 09/30/2018) | 15,000.00 |
| Option 2 (10/01/2018 - 09/30/2019) | 15,000.00 |
| Option 3 (10/01/2019 - 09/30/2020) | 15,000.00 |
| Option 1 (10/01/2020 - 09/30/2021) | 15,000.00 |
| 6 Month Extension (10/01/2021 - 03/31/2022) | 7,500.00 |
| Total Price | $ 82,500.00 |
Page &P of &N
Instructions
The offeror shall enter the name of their company in the yellow highlighted cell.
Summary - Price Tab - This worksheet automatically populates based on the entries made on the supporting tabs: Base Period, Option 1, Option 2, Option 3, Option 4, and 6 Month Ext.
ADDITIONAL NOTES:
1. In the event that the prices provided in this worksheet differ from the prices shown on the vendor's SF 1449, the offeror's proposed price for this solicitation shall be considered the extended amounts shown on SF 1449.
2. 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).
3. Offerors may make modifications to the Government provided pricing worksheets, however they must at a minimum provide the price build up information required by original spreadsheets inlcuded in the solicitation. If the Government provided worksheets are altered in any manner, it is the responsibility of the offeror to consider the impact the changes will have on the embedded calculations and formulas and on their price build-up. Accordingly, it is incumbent upon the offeror to ensure that all calculations and formulas result in accurate pricing. A narrative explanation must be provided to explain any additional cost elements added by the offeror and any revisions to the embedded formulas.
Base Period
Offeror:
BASE PERIOD - 10/01/2016 through 09/30/2017
| I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES | ||||||||||
| CLIN | Labor Category | Annual Hours | Location | Hourly Wage Rate | Annual Labor Cost (Product of Columns C and E) | Fringe Cost (if applicable) | Overhead & G&A Cost | Profit Amount | Labor Price (Sum of Columns F through I) | Fixed Monthly Amount (Column J Divided by 12) |
| 0001 | Program Analyst | 1,880 | Kansas City, MO | $ - 0 | $ - 0 | $ - 0 | ||||
| 0002 | Executive Administrative Assistant | 1,880 | Kansas City, MO | - 0 | - 0 | - 0 | ||||
| Total Price | $ - 0 |
| II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT | ||||||||||||||||||
| CLIN | Labor Category | Local Area Wage Determination | WD Occupation Code | Location | Hours | Hourly Wage | Total Basic Labor (Product of Columns F and G) | 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 Labor Costs (Sum of Columns H through L) | Overhead (if applicable) | General and Administrative (G&A) | Total Cost (Sum of Columns M through O) | Profit | Total Price (Sum of Columns P and Q) | Fixed Monthly Price (Column R Divided by 12) |
| 0003 | Administrative Assistant | 2005-2307 Rev 18 | 01020 | Kansas City, MO | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 0004 | Administrative Assistant | 2005-2205 Rev 20 | 01020 | Des Moines, IA | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 0005 | Administrative Assistant | 2015-2309 Rev 1 | 01020 | St. Louis, MO | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| Total Price | $ - 0 |
| III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT | ||||||
| CLIN | Labor Category | WD Occupation Code | Location | Annual Hours | Fully Burdened Hourly Rate | Price (Product of Columns E and F) |
| 0006 | Program Analyst | N/A | Kansas City, MO | 50 | $ - 0 | |
| 0007 | Executive Administrative Assistant | N/A | Kansas City, MO | 50 | - 0 | |
| 0008 | Administrative Assistant | 01020 | Kansas City, MO | 100 | - 0 | |
| 0009 | Administrative Assistant | 01020 | Des Moines, IA | 50 | - 0 | |
| 0010 | Administrative Assistant | 01020 | St. Louis, MO | 50 | - 0 | |
| Total Price | $ - 0 | |||||
| IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL | ||||||
| CLIN | Description | Fixed Indirect Rate | Travel CLIN Not to Exceed Amount | |||
| 0011 | Travel CLIN | 0.0% | $ 15,000.00 |
Page &P of &N
Instructions
The offeror must complete this spreadsheet for the purpose of the Government's Price Evaluation. At the top of the worksheet the offeror shall enter the name of their company.
I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES
Input the Basic Labor Rates, Fringe amounts, Overhead & G&A amounts, and Profit amounts for each category in the corresponding yellow cells. Take note, the inputs for the Fringe, Overhead &G&A, and Profit columns should be amounts, NOT rates or factors. The following columns automatically calculate and do not require entries: Annual Labor Cost, Labor Price, Fixed Monthly Amount.
II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT
Input the Hourly Wage rates, Health and Welfare amounts, Paid Time Off amounts, Tax amounts, WCI amounts, Overhead amounts, ODC amounts, G&A amounts, and Profit amounts into the yellow highlighted cells. The following columns automatically calculate and do not require entries: Total Basic Labor, Total of Labor Cost, Total Cost, Total Price, and the Fixed Monthly Price.
III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT
Input the fully burdened labor rates that the offeror intends to bill for each labor category when services are ordered under the Additional Services CLINS. The fully burdened labor rates should be inclusive of all applicable indirect costs (i.e. fringe, overhead and G&A), profit, and any other applicable loadings. It is highly recommended that when developing the fully burdened labor rates, offerors take into consideration the circumstances in which Additional Services can be ordered as described in the SOW.
IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL
In the yellow shaded cell, input the fixed indirect rate that will be applied to Travel costs associated with the Travel CLIN.
NOTE: - The annual not to exceed Travel amounts ($15,000 per ordering period except for $7,500 in the 6 month extension) are ceiling amounts inclusive of both the travel costs and indirect costs. However, for price evaluation purposes, the Government intends to apply the proposed fixed indirect rates to the annual not to exceed travel ceilings.
ADDITIONAL NOTES:
1. In the event that the fixed monthly prices provided in this worksheet differ from the prices shown on the vendor's SF 1449, the offeror's proposed price for this solicitation shall be considered the extended amounts shown on SF 1449.
2. 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).
3. Offerors may make modifications to the Government provided pricing worksheets, however they must at a minimum provide the price build up information required by original spreadsheets inlcuded in the solicitation. If the Government provided worksheets are altered in any manner, it is the responsibility of the offeror to consider the impact the changes will have on the embedded calculations and formulas and on their price build-up. Accordingly, it is incumbent upon the offeror to ensure that all calculations and formulas result in accurate pricing. A narrative explanation must be provided to explain any additional cost elements added by the offeror and any revisions to the embedded formulas.
Option 1 Offeror:
OPTION PERIOD 1 - 10/01/2017 through 09/30/2018
| I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES | ||||||||||
| CLIN | Labor Category | Annual Hours | Location | Hourly Wage Rate | Annual Labor Cost (Product of Columns C and E) | Fringe Cost (if applicable) | Overhead & G&A Cost | Profit Amount | Labor Price (Sum of Columns F through I) | Fixed Monthly Amount (Column J Divided by 12) |
| 1001 | Program Analyst | 1,880 | Kansas City, MO | $ - 0 | $ - 0 | $ - 0 | ||||
| 1002 | Executive Administrative Assistant | 1,880 | Kansas City, MO | - 0 | - 0 | - 0 | ||||
| Total Price | $ - 0 |
| II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT | ||||||||||||||||||
| CLIN | Labor Category | Local Area Wage Determination | WD Occupation Code | Location | Hours | Hourly Wage | Total Basic Labor (Product of Columns F and G) | 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 Labor Costs (Sum of Columns H through L) | Overhead (if applicable) | General and Administrative (G&A) | Total Cost (Sum of Columns M through O) | Profit | Total Price (Sum of Columns P and Q) | Fixed Monthly Price (Column R Divided by 12) |
| 1003 | Administrative Assistant | 2005-2307 Rev 18 | 01020 | Kansas City, MO | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 1004 | Administrative Assistant | 2005-2205 Rev 20 | 01020 | Des Moines, IA | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 1005 | Administrative Assistant | 2015-2309 Rev 1 | 01020 | St. Louis, MO | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| Total Price | $ - 0 |
| III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT | ||||||
| CLIN | Labor Category | WD Occupation Code | Location | Annual Hours | Fully Burdened Hourly Rate | Price (Product of Columns E and F) |
| 1006 | Program Analyst | N/A | Kansas City, MO | 50 | $ - 0 | |
| 1007 | Executive Administrative Assistant | N/A | Kansas City, MO | 50 | - 0 | |
| 1008 | Administrative Assistant | 01020 | Kansas City, MO | 100 | - 0 | |
| 1009 | Administrative Assistant | 01020 | Des Moines, IA | 50 | - 0 | |
| 1010 | Administrative Assistant | 01020 | St. Louis, MO | 50 | - 0 | |
| Total Price | $ - 0 | |||||
| IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL | ||||||
| CLIN | Description | Fixed Indirect Rate | Travel CLIN Not to Exceed Amount | |||
| 1011 | Travel CLIN | 0.0% | $ 15,000.00 |
Page &P of &N
Instructions
The offeror must complete this spreadsheet for the purpose of the Government's Price Evaluation. At the top of the worksheet the offeror shall enter the name of their company.
I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES
Input the Basic Labor Rates, Fringe amounts, Overhead & G&A amounts, and Profit amounts for each category in the corresponding yellow cells. Take note, the inputs for the Fringe, Overhead &G&A, and Profit columns should be amounts, NOT rates or factors. The following columns automatically calculate and do not require entries: Annual Labor Cost, Labor Price, Fixed Monthly Amount.
II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT
Input the Hourly Wage rates, Health and Welfare amounts, Paid Time Off amounts, Tax amounts, WCI amounts, Overhead amounts, ODC amounts, G&A amounts, and Profit amounts into the yellow highlighted cells. The following columns automatically calculate and do not require entries: Total Basic Labor, Total of Labor Cost, Total Cost, Total Price, and the Fixed Monthly Price.
III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT
Input the fully burdened labor rates that the offeror intends to bill for each labor category when services are ordered under the Additional Services CLINS. The fully burdened labor rates should be inclusive of all applicable indirect costs (i.e. fringe, overhead and G&A), profit, and any other applicable loadings. It is highly recommended that when developing the fully burdened labor rates, offerors take into consideration the circumstances in which Additional Services can be ordered as described in the SOW.
IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL
In the yellow shaded cell, input the fixed indirect rate that will be applied to Travel costs associated with the Travel CLIN.
NOTE: - The annual not to exceed Travel amounts ($15,000 per ordering period except for $7,500 in the 6 month extension) are ceiling amounts inclusive of both the travel costs and indirect costs. However, for price evaluation purposes, the Government intends to apply the proposed fixed indirect rates to the annual not to exceed travel ceilings.
ADDITIONAL NOTES:
1. In the event that the fixed monthly prices provided in this worksheet differ from the prices shown on the vendor's SF 1449, the offeror's proposed price for this solicitation shall be considered the extended amounts shown on SF 1449.
2. 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).
3. Offerors may make modifications to the Government provided pricing worksheets, however they must at a minimum provide the price build up information required by original spreadsheets inlcuded in the solicitation. If the Government provided worksheets are altered in any manner, it is the responsibility of the offeror to consider the impact the changes will have on the embedded calculations and formulas and on their price build-up. Accordingly, it is incumbent upon the offeror to ensure that all calculations and formulas result in accurate pricing. A narrative explanation must be provided to explain any additional cost elements added by the offeror and any revisions to the embedded formulas.
Option 2 Offeror:
OPTION PERIOD 2 - 10/01/2018 through 09/30/2019
| I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES | ||||||||||
| CLIN | Labor Category | Annual Hours | Location | Hourly Wage Rate | Annual Labor Cost (Product of Columns C and E) | Fringe Cost (if applicable) | Overhead & G&A Cost | Profit Amount | Labor Price (Sum of Columns F through I) | Fixed Monthly Amount (Column J Divided by 12) |
| 2001 | Program Analyst | 1,880 | Kansas City, MO | $ - 0 | $ - 0 | $ - 0 | ||||
| 2002 | Executive Administrative Assistant | 1,880 | Kansas City, MO | - 0 | - 0 | - 0 | ||||
| Total Price | $ - 0 |
| II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT | ||||||||||||||||||
| CLIN | Labor Category | Local Area Wage Determination | WD Occupation Code | Location | Hours | Hourly Wage | Total Basic Labor (Product of Columns F and G) | 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 Labor Costs (Sum of Columns H through L) | Overhead (if applicable) | General and Administrative (G&A) | Total Cost (Sum of Columns M through O) | Profit | Total Price (Sum of Columns P and Q) | Fixed Monthly Price (Column R Divided by 12) |
| 2003 | Administrative Assistant | 2005-2307 Rev 18 | 01020 | Kansas City, MO | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 2004 | Administrative Assistant | 2005-2205 Rev 20 | 01020 | Des Moines, IA | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 2005 | Administrative Assistant | 2015-2309 Rev 1 | 01020 | St. Louis, MO | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| Total Price | $ - 0 |
| III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT | ||||||
| CLIN | Labor Category | WD Occupation Code | Location | Annual Hours | Fully Burdened Hourly Rate | Price (Product of Columns E and F) |
| 2006 | Program Analyst | N/A | Kansas City, MO | 50 | $ - 0 | |
| 2007 | Executive Administrative Assistant | N/A | Kansas City, MO | 50 | - 0 | |
| 2008 | Administrative Assistant | 01020 | Kansas City, MO | 100 | - 0 | |
| 2009 | Administrative Assistant | 01020 | Des Moines, IA | 50 | - 0 | |
| 2010 | Administrative Assistant | 01020 | St. Louis, MO | 50 | - 0 | |
| Total Price | $ - 0 | |||||
| IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL | ||||||
| CLIN | Description | Fixed Indirect Rate | Travel CLIN Not to Exceed Amount | |||
| 2011 | Travel CLIN | 0.0% | $ 15,000.00 |
Page &P of &N
Instructions
The offeror must complete this spreadsheet for the purpose of the Government's Price Evaluation. At the top of the worksheet the offeror shall enter the name of their company.
I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES
Input the Basic Labor Rates, Fringe amounts, Overhead & G&A amounts, and Profit amounts for each category in the corresponding yellow cells. Take note, the inputs for the Fringe, Overhead &G&A, and Profit columns should be amounts, NOT rates or factors. The following columns automatically calculate and do not require entries: Annual Labor Cost, Labor Price, Fixed Monthly Amount.
II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT
Input the Hourly Wage rates, Health and Welfare amounts, Paid Time Off amounts, Tax amounts, WCI amounts, Overhead amounts, ODC amounts, G&A amounts, and Profit amounts into the yellow highlighted cells. The following columns automatically calculate and do not require entries: Total Basic Labor, Total of Labor Cost, Total Cost, Total Price, and the Fixed Monthly Price.
III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT
Input the fully burdened labor rates that the offeror intends to bill for each labor category when services are ordered under the Additional Services CLINS. The fully burdened labor rates should be inclusive of all applicable indirect costs (i.e. fringe, overhead and G&A), profit, and any other applicable loadings. It is highly recommended that when developing the fully burdened labor rates, offerors take into consideration the circumstances in which Additional Services can be ordered as described in the SOW.
IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL
In the yellow shaded cell, input the fixed indirect rate that will be applied to Travel costs associated with the Travel CLIN.
NOTE: - The annual not to exceed Travel amounts ($15,000 per ordering period except for $7,500 in the 6 month extension) are ceiling amounts inclusive of both the travel costs and indirect costs. However, for price evaluation purposes, the Government intends to apply the proposed fixed indirect rates to the annual not to exceed travel ceilings.
ADDITIONAL NOTES:
1. In the event that the fixed monthly prices provided in this worksheet differ from the prices shown on the vendor's SF 1449, the offeror's proposed price for this solicitation shall be considered the extended amounts shown on SF 1449.
2. 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).
3. Offerors may make modifications to the Government provided pricing worksheets, however they must at a minimum provide the price build up information required by original spreadsheets inlcuded in the solicitation. If the Government provided worksheets are altered in any manner, it is the responsibility of the offeror to consider the impact the changes will have on the embedded calculations and formulas and on their price build-up. Accordingly, it is incumbent upon the offeror to ensure that all calculations and formulas result in accurate pricing. A narrative explanation must be provided to explain any additional cost elements added by the offeror and any revisions to the embedded formulas.
Option 3 Offeror:
OPTION PERIOD 3 - 10/01/2019 through 09/30/2020
| I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES | ||||||||||
| CLIN | Labor Category | Annual Hours | Location | Hourly Wage Rate | Annual Labor Cost (Product of Columns C and E) | Fringe Cost (if applicable) | Overhead & G&A Cost | Profit Amount | Labor Price (Sum of Columns F through I) | Fixed Monthly Amount (Column J Divided by 12) |
| 3001 | Program Analyst | 1,880 | Kansas City, MO | $ - 0 | $ - 0 | $ - 0 | ||||
| 3002 | Executive Administrative Assistant | 1,880 | Kansas City, MO | - 0 | - 0 | - 0 | ||||
| Total Price | $ - 0 |
| II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT | ||||||||||||||||||
| CLIN | Labor Category | Local Area Wage Determination | WD Occupation Code | Location | Hours | Hourly Wage | Total Basic Labor (Product of Columns F and G) | 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 Labor Costs (Sum of Columns H through L) | Overhead (if applicable) | General and Administrative (G&A) | Total Cost (Sum of Columns M through O) | Profit | Total Price (Sum of Columns P and Q) | Fixed Monthly Price (Column R Divided by 12) |
| 3003 | Administrative Assistant | 2005-2307 Rev 18 | 01020 | Kansas City, MO | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 3004 | Administrative Assistant | 2005-2205 Rev 20 | 01020 | Des Moines, IA | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 3005 | Administrative Assistant | 2015-2309 Rev 1 | 01020 | St. Louis, MO | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| Total Price | $ - 0 |
| III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT | ||||||
| CLIN | Labor Category | WD Occupation Code | Location | Annual Hours | Fully Burdened Hourly Rate | Price (Product of Columns E and F) |
| 3006 | Program Analyst | N/A | Kansas City, MO | 50 | $ - 0 | |
| 3007 | Executive Administrative Assistant | N/A | Kansas City, MO | 50 | - 0 | |
| 3008 | Administrative Assistant | 01020 | Kansas City, MO | 100 | - 0 | |
| 3009 | Administrative Assistant | 01020 | Des Moines, IA | 50 | - 0 | |
| 3010 | Administrative Assistant | 01020 | St. Louis, MO | 50 | - 0 | |
| Total Price | $ - 0 | |||||
| IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL | ||||||
| CLIN | Description | Fixed Indirect Rate | Travel CLIN Not to Exceed Amount | |||
| 3011 | Travel CLIN | 0.0% | $ 15,000.00 |
Page &P of &N
Instructions
The offeror must complete this spreadsheet for the purpose of the Government's Price Evaluation. At the top of the worksheet the offeror shall enter the name of their company.
I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES
Input the Basic Labor Rates, Fringe amounts, Overhead & G&A amounts, and Profit amounts for each category in the corresponding yellow cells. Take note, the inputs for the Fringe, Overhead &G&A, and Profit columns should be amounts, NOT rates or factors. The following columns automatically calculate and do not require entries: Annual Labor Cost, Labor Price, Fixed Monthly Amount.
II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT
Input the Hourly Wage rates, Health and Welfare amounts, Paid Time Off amounts, Tax amounts, WCI amounts, Overhead amounts, ODC amounts, G&A amounts, and Profit amounts into the yellow highlighted cells. The following columns automatically calculate and do not require entries: Total Basic Labor, Total of Labor Cost, Total Cost, Total Price, and the Fixed Monthly Price.
III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT
Input the fully burdened labor rates that the offeror intends to bill for each labor category when services are ordered under the Additional Services CLINS. The fully burdened labor rates should be inclusive of all applicable indirect costs (i.e. fringe, overhead and G&A), profit, and any other applicable loadings. It is highly recommended that when developing the fully burdened labor rates, offerors take into consideration the circumstances in which Additional Services can be ordered as described in the SOW.
IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL
In the yellow shaded cell, input the fixed indirect rate that will be applied to Travel costs associated with the Travel CLIN.
NOTE: - The annual not to exceed Travel amounts ($15,000 per ordering period except for $7,500 in the 6 month extension) are ceiling amounts inclusive of both the travel costs and indirect costs. However, for price evaluation purposes, the Government intends to apply the proposed fixed indirect rates to the annual not to exceed travel ceilings.
ADDITIONAL NOTES:
1. In the event that the fixed monthly prices provided in this worksheet differ from the prices shown on the vendor's SF 1449, the offeror's proposed price for this solicitation shall be considered the extended amounts shown on SF 1449.
2. 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).
3. Offerors may make modifications to the Government provided pricing worksheets, however they must at a minimum provide the price build up information required by original spreadsheets inlcuded in the solicitation. If the Government provided worksheets are altered in any manner, it is the responsibility of the offeror to consider the impact the changes will have on the embedded calculations and formulas and on their price build-up. Accordingly, it is incumbent upon the offeror to ensure that all calculations and formulas result in accurate pricing. A narrative explanation must be provided to explain any additional cost elements added by the offeror and any revisions to the embedded formulas.
Option 4 Offeror:
OPTION PERIOD 4 - 10/01/2020 through 09/30/2021
| I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES | ||||||||||
| CLIN | Labor Category | Annual Hours | Location | Hourly Wage Rate | Annual Labor Cost (Product of Columns C and E) | Fringe Cost (if applicable) | Overhead & G&A Cost | Profit Amount | Labor Price (Sum of Columns F through I) | Fixed Monthly Amount (Column J Divided by 12) |
| 4001 | Program Analyst | 1,880 | Kansas City, MO | $ - 0 | $ - 0 | $ - 0 | ||||
| 4002 | Executive Administrative Assistant | 1,880 | Kansas City, MO | - 0 | - 0 | - 0 | ||||
| Total Price | $ - 0 |
| II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT | ||||||||||||||||||
| CLIN | Labor Category | Local Area Wage Determination | WD Occupation Code | Location | Hours | Hourly Wage | Total Basic Labor (Product of Columns F and G) | 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 Labor Costs (Sum of Columns H through L) | Overhead (if applicable) | General and Administrative (G&A) | Total Cost (Sum of Columns M through O) | Profit | Total Price (Sum of Columns P and Q) | Fixed Monthly Price (Column R Divided by 12) |
| 4003 | Administrative Assistant | 2005-2307 Rev 18 | 01020 | Kansas City, MO | 3,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 4004 | Administrative Assistant | 2005-2205 Rev 20 | 01020 | Des Moines, IA | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 4005 | Administrative Assistant | 2015-2309 Rev 1 | 01020 | St. Louis, MO | 1,880 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| Total Price | $ - 0 |
| III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT | ||||||
| CLIN | Labor Category | WD Occupation Code | Location | Annual Hours | Fully Burdened Hourly Rate | Price (Product of Columns E and F) |
| 4006 | Program Analyst | N/A | Kansas City, MO | 50 | $ - 0 | |
| 4007 | Executive Administrative Assistant | N/A | Kansas City, MO | 50 | - 0 | |
| 4008 | Administrative Assistant | 01020 | Kansas City, MO | 100 | - 0 | |
| 4009 | Administrative Assistant | 01020 | Des Moines, IA | 50 | - 0 | |
| 4010 | Administrative Assistant | 01020 | St. Louis, MO | 50 | - 0 | |
| Total Price | $ - 0 | |||||
| IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL | ||||||
| CLIN | Description | Fixed Indirect Rate | Travel CLIN Not to Exceed Amount | |||
| 4011 | Travel CLIN | 0.0% | $ 15,000.00 |
Page &P of &N
Instructions
The offeror must complete this spreadsheet for the purpose of the Government's Price Evaluation. At the top of the worksheet the offeror shall enter the name of their company.
I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES
Input the Basic Labor Rates, Fringe amounts, Overhead & G&A amounts, and Profit amounts for each category in the corresponding yellow cells. Take note, the inputs for the Fringe, Overhead &G&A, and Profit columns should be amounts, NOT rates or factors. The following columns automatically calculate and do not require entries: Annual Labor Cost, Labor Price, Fixed Monthly Amount.
II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT
Input the Hourly Wage rates, Health and Welfare amounts, Paid Time Off amounts, Tax amounts, WCI amounts, Overhead amounts, ODC amounts, G&A amounts, and Profit amounts into the yellow highlighted cells. The following columns automatically calculate and do not require entries: Total Basic Labor, Total of Labor Cost, Total Cost, Total Price, and the Fixed Monthly Price.
III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT
Input the fully burdened labor rates that the offeror intends to bill for each labor category when services are ordered under the Additional Services CLINS. The fully burdened labor rates should be inclusive of all applicable indirect costs (i.e. fringe, overhead and G&A), profit, and any other applicable loadings. It is highly recommended that when developing the fully burdened labor rates, offerors take into consideration the circumstances in which Additional Services can be ordered as described in the SOW.
IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL
In the yellow shaded cell, input the fixed indirect rate that will be applied to Travel costs associated with the Travel CLIN.
NOTE: - The annual not to exceed Travel amounts ($15,000 per ordering period except for $7,500 in the 6 month extension) are ceiling amounts inclusive of both the travel costs and indirect costs. However, for price evaluation purposes, the Government intends to apply the proposed fixed indirect rates to the annual not to exceed travel ceilings.
ADDITIONAL NOTES:
1. In the event that the fixed monthly prices provided in this worksheet differ from the prices shown on the vendor's SF 1449, the offeror's proposed price for this solicitation shall be considered the extended amounts shown on SF 1449.
2. 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).
3. Offerors may make modifications to the Government provided pricing worksheets, however they must at a minimum provide the price build up information required by original spreadsheets inlcuded in the solicitation. If the Government provided worksheets are altered in any manner, it is the responsibility of the offeror to consider the impact the changes will have on the embedded calculations and formulas and on their price build-up. Accordingly, it is incumbent upon the offeror to ensure that all calculations and formulas result in accurate pricing. A narrative explanation must be provided to explain any additional cost elements added by the offeror and any revisions to the embedded formulas.
6 Month Ext Offeror:
6 MONTH EXTENSION - 10/01/2021 through 03/31/2022
| I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES | ||||||||||
| CLIN | Labor Category | Annual Hours | Location | Hourly Wage Rate | Annual Labor Cost (Product of Columns C and E) | Fringe Cost (if applicable) | Overhead & G&A Cost | Profit Amount | Labor Price (Sum of Columns F through I) | Fixed Monthly Amount (Column J Divided by 6) |
| 5001 | Program Analyst | 940 | Kansas City, MO | $ - 0 | $ - 0 | $ - 0 | ||||
| 5002 | Executive Administrative Assistant | 940 | Kansas City, MO | - 0 | - 0 | - 0 | ||||
| Total Price | $ - 0 |
| II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT | ||||||||||||||||||
| CLIN | Labor Category | Local Area Wage Determination | WD Occupation Code | Location | Hours | Hourly Wage | Total Basic Labor (Product of Columns F and G) | 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 Labor Costs (Sum of Columns H through L) | Overhead (if applicable) | General and Administrative (G&A) | Total Cost (Sum of Columns M through O) | Profit | Total Price (Sum of Columns P and Q) | Fixed Monthly Price (Column R Divided by 6) |
| 5003 | Administrative Assistant | 2005-2307 Rev 18 | 01020 | Kansas City, MO | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 5004 | Administrative Assistant | 2005-2205 Rev 20 | 01020 | Des Moines, IA | 940 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 5005 | Administrative Assistant | 2015-2309 Rev 1 | 01020 | St. Louis, MO | 940 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| Total Price | $ - 0 |
| III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT | ||||||
| CLIN | Labor Category | WD Occupation Code | Location | Annual Hours | Fully Burdened Hourly Rate | Price (Product of Columns E and F) |
| 5006 | Program Analyst | N/A | Kansas City, MO | 25 | $ - 0 | |
| 5007 | Executive Administrative Assistant | N/A | Kansas City, MO | 25 | - 0 | |
| 5008 | Administrative Assistant | 01020 | Kansas City, MO | 50 | - 0 | |
| 5009 | Administrative Assistant | 01020 | Des Moines, IA | 25 | - 0 | |
| 5010 | Administrative Assistant | 01020 | St. Louis, MO | 25 | - 0 | |
| Total Price | $ - 0 | |||||
| IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL | ||||||
| CLIN | Description | Fixed Indirect Rate | Travel CLIN Not to Exceed Amount | |||
| 5011 | Travel CLIN | 0.0% | $ 7,500.00 |
Page &P of &N
Instructions
The offeror must complete this spreadsheet for the purpose of the Government's Price Evaluation. At the top of the worksheet the offeror shall enter the name of their company.
I. FIXED PRICE BREAKDOWN FOR PROFESSIONAL SERVICES
Input the Basic Labor Rates, Fringe amounts, Overhead & G&A amounts, and Profit amounts for each category in the corresponding yellow cells. Take note, the inputs for the Fringe, Overhead &G&A, and Profit columns should be amounts, NOT rates or factors. The following columns automatically calculate and do not require entries: Annual Labor Cost, Labor Price, Fixed Monthly Amount.
II. FIXED PRICE BREAKDOWN FOR ADMINISTRATIVE SUPPORT
Input the Hourly Wage rates, Health and Welfare amounts, Paid Time Off amounts, Tax amounts, WCI amounts, Overhead amounts, ODC amounts, G&A amounts, and Profit amounts into the yellow highlighted cells. The following columns automatically calculate and do not require entries: Total Basic Labor, Total of Labor Cost, Total Cost, Total Price, and the Fixed Monthly Price.
III. ADDITIONAL HOURS FOR PROFESSIONAL SERVICES AND ADMINISTRATIVE SUPPORT
Input the fully burdened labor rates that the offeror intends to bill for each labor category when services are ordered under the Additional Services CLINS. The fully burdened labor rates should be inclusive of all applicable indirect costs (i.e. fringe, overhead and G&A), profit, and any other applicable loadings. It is highly recommended that when developing the fully burdened labor rates, offerors take into consideration the circumstances in which Additional Services can be ordered as described in the SOW.
IV. FIXED INDIRECT RATE APPLICABLE TO TRAVEL
In the yellow shaded cell, input the fixed indirect rate that will be applied to Travel costs associated with the Travel CLIN.
NOTE: - The annual not to exceed Travel amounts ($15,000 per ordering period except for $7,500 in the 6 month extension) are ceiling amounts inclusive of both the travel costs and indirect costs. However, for price evaluation purposes, the Government intends to apply the proposed fixed indirect rates to the annual not to exceed travel ceilings.
ADDITIONAL NOTES:
1. In the event that the fixed monthly prices provided in this worksheet differ from the prices shown on the vendor's SF 1449, the offeror's proposed price for this solicitation shall be considered the extended amounts shown on SF 1449.
2. 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).
3. Offerors may make modifications to the Government provided pricing worksheets, however they must at a minimum provide the price build up information required by original spreadsheets inlcuded in the solicitation. If the Government provided worksheets are altered in any manner, it is the responsibility of the offeror to consider the impact the changes will have on the embedded calculations and formulas and on their price build-up. Accordingly, it is incumbent upon the offeror to ensure that all calculations and formulas result in accurate pricing. A narrative explanation must be provided to explain any additional cost elements added by the offeror and any revisions to the embedded formulas.
File details come from the government source that posted it. Updated .