Att-5-Price element breakdown.xls
XLS spreadsheet 51 KB Posted
- Solicitation number
- HSHQWA-10-R-00001
- Issued by
-
Immigration and Customs Enforcement
About this file
ATTACHMENT 5 PRICE ELEMENT BREAKDOWN (MS Excel Format
View the file
Other files
Show all 28
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
Model for Price Realism
| Base Period | Base Period | Optional/Additional Ordering Period 1 | Additional Period 1 | Optional/Additional Ordering Period 2 | Additional Period 2 | Optional/Additional Ordering Period 3 | Additional Period 3 | Optional/Additional Ordering Period 4 | Additional Period 4 | Grand | |||||||||||
| PRICING ELEMENT | WD or CBA # | WD or CBA # | WD or CBA # | Total | WD or CBA # | WD or CBA # | WD or CBA # | Total | WD or CBA # | WD or CBA # | WD or CBA # | Total | WD or CBA # | WD or CBA # | WD or CBA # | Total | WD or CBA # | WD or CBA # | WD or CBA # | Total | Total |
| Reg Hours Bid | 0 | 0 | 0 | 0 | 0 | - 0 | |||||||||||||||
| OT Hours Bid | 0 | 0 | 0 | 0 | 0 | - 0 | |||||||||||||||
| Total Hours Bid | - 0 | - 0 | - 0 | 0 | 0 | 0 | 0 | 0 | - 0 | ||||||||||||
| WD or CBA Rate | |||||||||||||||||||||
| Reg. Labor Rate Used (Ref Note 1) | |||||||||||||||||||||
| OT Labor Rate Used | |||||||||||||||||||||
| Direct Labor | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 |
| Overtime Premium Labor | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 | - 0 | - 0 | 0.00 | - 0 |
| Subtotal - Labor | - 0 | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 |
| Fringe Benefits | |||||||||||||||||||||
| Health and Welfare Rate Used (Ref Note 1) | - 0 | ||||||||||||||||||||
| Health and Welfare | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Pension Rate Used (Ref Note 1) | - 0 | ||||||||||||||||||||
| Pension | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| 401K Matching | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Annual Benefit Rate Used (Ref Note 1) | - 0 | ||||||||||||||||||||
| Annual Benefit | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Holiday | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Vacation | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Sick | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Personal | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Jury Duty | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Other | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | ||||||||||||||||
| Sub-Total Fringe Benefits | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 |
| Taxes | |||||||||||||||||||||
| FICA | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| FUTA | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| SUTA | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Sub-Total Taxes | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 |
| Overhead | $0.00 | $0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Other Direct Elements (Reference Note 2) | |||||||||||||||||||||
| Relief | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Guard Mount | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Workman's Comp Insurance | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| General Liability Ins | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - Basic, Range new hires | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - Baton | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - CPR/First Aid Recertification Yearly | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - Supervisory | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - Supervisory Re-Certification | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - Range Recertification | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - Triennial Recertification training | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Training - Other | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Uniforms | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Body Armor | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Weapons | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Ammunition | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Targets | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Travel | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Guard License Fees | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Medical/Physical Fitness/Drug Screen | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Start up | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Vehicle (Lease or Depreciation) | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Other: | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| XXXXX | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| XXXXX | 0.00 | 0.00 | $ - 0 | 0.00 | 0.00 | - 0 | |||||||||||||||
| XXXXX | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Sub-Total - Other Direct Elements | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Management Approach (Ref: Note 3) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Material Handling | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| General and Administrative | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Total Price w/o Profit and IFF | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Profit | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||
| Industrial Funding Fee | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 | |||||||||||||||
| Grand Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Basic Rate | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Explanatory Notes | |||||||||||||||||||||
| Note 1 - Rates | |||||||||||||||||||||
| Note 2 - Other Direct Element Pricing | |||||||||||||||||||||
| Note 3 - Pricing for Management Approach Items | |||||||||||||||||||||
| Signature and Title of Preparer |
&C(&"Arial,Italic"Name of Company&"Arial,Regular") Price Element Breakdown for Solicitation: HSHQWA-10-R-00001&R &D For the purpose of this price breakdown model, these elements should be separately broken out as shown, even if it is the contractor's practice to include these items in their Overhead and/or G&A rate. However, the contractor should reduce their reported Overhead and G&A amounts for the impact of these separately identified price elements to the extent they are already included in their Overhead and G&A. This will ensure that price elements are not duplicated in the breakdown.
For the purpose of this price breakdown model, this amount represents the price associated with the advantageous aspects of the contractor's management approach, which are above the minimum requirements of the SOW. However, the contractor should reduce their reported Overhead, Other Direct Elements, and G&A to the extent these elements are included under the Management Approach pricing. This will ensure that price elements are not duplicated in the breakdown.
Additionally, the contractor should include a brief description of the items priced under the Management Approach and may include subsidiary calculations of the pricing on a separate worksheet. For example, if the contractor proposes to conduct weekly QC inspections on 25% of posts, then they should explain that the Management Approach pricing is specifically for weekly QC inspections.
The contractor should explain the basis of the rates used including providing the calculations when a weighted average of applicable rates is used.
Sheet3
File details come from the government source that posted it. Updated .