FLETC Firearms Questions Price Proposal Worksheet - Response to questions Amend 0004.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Firearms Support Services
- Solicitation number
- 70LGLY22RGLB00007
About this file
This document contains questions and answers regarding a contractor proposal template for providing firearms support services to the Department of Homeland Security Federal Law Enforcement Training Center. The key details are as follows:
The contractor is to provide dollar values for estimated taxes and benefits rather than blended percentage rates for each Contract Line Item Number. The full breakdown of applicable payroll taxes should be included, such as Social Security, Medicare, Federal Unemployment Tax, and State Unemployment Tax. The "Add Materials" column and associated formulas in the template were removed as that line item is not applicable to the requirement. A revised contractor proposal template was provided that excludes this column and replaces it with a monthly rate field.
View the file
Other files
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
Sheet1
| NO. | REFERENCE | PG. NO. | ISSUE / COMMENT | QUESTION | GOVERNMENT RESPONSE |
| 1 | Contractor Proposal Price Template | N/A | Each of the tabs in the price proposal spreadsheet contain fields for estimated tax and benefits rates expressed as a percentage in each CLIN for each period of performance. These rates will vary depending on the labor splits between SCA and non-SCA positions in Each CLIN. | Does the Government require that blended percentage rates be provided, or are the bidders to only insert the dollar values for the estimated taxes and benefits for each CLIN? | Contractors are to proivde the dollar values for their companies estimated taxes and benefits for each CLIN and not blended percentage rates. |
| 2 | Contractor Proposal Price Template | N/A | The Estimated taxes include FUTA and SUIT in each of the periods of performance. It is unclear what is required for the CLIN inputs in each year. | Please confirm that the requirement is to break out the full compliment of payroll taxes including the following: |
Social Security/Medicare (Collectively frequently called FICA) Federal Unemployment Tax (FUTA)
| State Unemployment Tax (SUTA) | Contractors are to privide the full break out of the full compliment of applicable payroll taxes to Social Security (FICA), Federal Unemployment Tax (FUTA), State Unemployment Tax (SUTA), etc. | |||
| 3 | Contractor Proposal Price Template | N/A | In each of the periods of performance in column N, there is a requirement to supply costs for Add Materials. Add Materials is not defined in either the RFP or instructions for the Price Proposal Worksheet. |
| What pricing is required and are bidders to use the percentage rates imbedded in the formulas? | Contractors are to utlize the percentage rates loaded in the MS spreadsheet which is set at 0.00%. Then contractors are to input their companies percentage rates into each formula. So that the dollar amounts reflect the contractors submitted pricing structure. | ||
| Contractor Proposal Price Template | N/A | In each of the periods of performance in column N, there is a requirement to supply costs for Add Materials. Add Materials is not defined in either the RFP or instructions for the Price Proposal Worksheet. |
| Are these costs assumed to include any indirect uplift such as G&A/material handling fee that company's charge in accordance with their estimating procedures. | Added material cost line in column "N" should be excluded or removed and is not applicable to the Firearms Support Services solicitaiton. | ||
| 4 | Contractor Proposal Price Template | N/A | In each of the periods of performance in column N, there is a requirement to supply costs for Add Materials. Formulas for this cost are included in the price proposal worksheet. However, each of these formulas appear to contain the following errors" |
Cell N5 - the source cell for the calculation has been deleted resulting in a #REF! error
Cell N16 refers to a blank cell with no data, so the result will always be zero.
| Will the Government be supplying a revised submission form? If not how should the formulas be adjusted? | A revised contractor proposal template has been provided excluding and removing the column N - add material and replaced with monthly rate (rounded). The revised contrator proposal template is attached and titled Firearms Support Services - Contractor Proposal Template Revision I. |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 |
File details come from the government source that posted it. Updated .