Attachment_6_-_Price_Element_Breakdown_-_April_2014.xlsx
XLSX spreadsheet 38 KB Posted
- Attached to
- Protective Security Officer (PSO) services
- Solicitation number
- HSHQEC-16-R-00006
- Issued by
-
Immigration and Customs Enforcement
About this file
Attachment 6 - Price Element Breakdown Spreadsheet
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Seniority_List.pdf | ||
| Amendment_0011.pdf | ||
| Amendment_0010.pdf | ||
| SF-1449.pdf | ||
| Exhibit_10_CPE_Limited_NWDTP.pdf | ||
| Seniority_List.pdf | ||
| Q A_Amendment_0009.pdf | ||
| Amendment_00008.pdf | ||
| Amendment_0007.pdf | ||
| Amendment_0006.pdf | ||
| Amenedment_0005.pdf | ||
| Amendment_0004.pdf | ||
| Attachment_6A_-_Price_Element_Breakdown_Instructions_April_2014.pdf | ||
| Amendment_0003.pdf | ||
| Amendment_0002.pdf | ||
| Attachment_4_-_Past_Performance_Questionaire.doc | DOC document | |
| Attachment_6_-_Price_Element_Breakdown_-_April_2014.xlsx | XLSX spreadsheet | |
| Attachment_8_-_Field_Level_Supervision_Exhibit.xls | XLS spreadsheet | |
| Amendment_0001.doc | DOC document | |
| RFP_HSHQEC-16-R-00006.pdf |
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
Text version
Model for Price Realism
| April 2014 Version | |||||||
| Applicable: Prevailing WD(s)/CBA(s): | |||||||
| PRICING ELEMENT | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | 6 Month Extension (FAR 52.217-8) | Total |
| Reg Hours Proposed | - 0 | ||||||
| OT Hours Proposed | - 0 | ||||||
| Shift Differential Hours Proposed | - 0 | ||||||
| Total Hours Proposed | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Hourly Wage Rate Proposed |
| OT Wage Rate Proposed |
| Total Regular Wage Direct Labor (Ref Note 1) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Overtime Premium Direct Labor | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Bonuses/Performance Pay | - 0 |
Subtotal - Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| Fringe Benefits |
| Proposed Health and Welfare Hourly Rate (Ref Note 1) |
| Health and Welfare | $ - 0 |
| Pension | - 0 |
| 401K Matching | - 0 |
| Annual Benefit | - 0 |
| Holiday | - 0 |
| Vacation | - 0 |
| Sick | - 0 |
| Personal | - 0 |
| Jury Duty | - 0 |
| Other | - 0 |
Sub-Total Fringe Benefits $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| Taxes | |
| FICA | - 0 |
| FUTA | - 0 |
| SUTA | - 0 |
| Other | - 0 |
Sub-Total Taxes $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Overhead $ - 0
| Other Direct Elements (Reference Note 2) | |
| Relief (See Relief Tab for Additional Pricing Info Required) | $ - 0 |
| Guard Mount | - 0 |
| Workman's Comp Insurance | - 0 |
| General Liability Ins | - 0 |
| Training - Basic, Range new hires | - 0 |
| Training - Baton | - 0 |
| Training - CPR/First Aid/AED Recertification Bi-Annually | - 0 |
| Training - Supervisory | - 0 |
| Training - Supervisory Re-Certification | - 0 |
| Training - Range Recertification | - 0 |
| Training - Triennial Refresher Training | - 0 |
| NWDTP Instructor Training (See SOW Section 6.7.3) | - 0 |
| NWDTP PSO Training (See SOW Section 6.7.4) | - 0 |
| Training - OC Spray Training | - 0 |
| Training - Other | - 0 |
| Uniforms | - 0 |
| Body Armor | - 0 |
| Weapons | - 0 |
| Ammunition | - 0 |
| Personal Protection Equipment | - 0 |
| Targets | - 0 |
| Travel | - 0 |
| Guard License Fees | - 0 |
| Medical/Physical Fitness/Drug Screen | - 0 |
| Other Start-Up/Transition | - 0 |
| Vehicle (Lease or Depreciation) | - 0 |
| Vehicle Maintenance | - 0 |
| Vehicle Fuel Charges | - 0 |
| Computer Usage Charges (Storage, Mainframe, Internet) | - 0 |
| Third Party Systems (e.g. Post Confirmation System) | - 0 |
| Consultants/Professional fees | - 0 |
| Other: | - 0 |
| XXXXX | - 0 |
| XXXXX | - 0 |
| XXXXX | - 0 |
Sub-Total - Other Direct Elements $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Non-PSO Positions (See Non-PSO Position Tab for additional Price Info Required) $ - 0
General and Administrative $ - 0
Total Price w/o Profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Profit $ - 0
Grand Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Basic Rate
Explanatory Notes
Note 1 - Rates
Note 2 - Other Direct Element Pricing
Signature and Title of Preparer
(&"Arial,Italic"Name of Company&"Arial,Regular") Price Element Breakdown for Solicitation (&"Arial,Italic"RFQ or RFP #&"Arial,Regular") &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 accounting 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.
When a weighted average of wage rates is used, the contractor shall explain the basis of their computations in this text box.
If Applicable - Basis of Weighted Average
Relief
| Hours and Costs for Providing Breaks and Lunches | |||||||
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | 6 Month Extension (FAR 52.217-8) | Total | |
| Paid Break Hours | - 0 | ||||||
| Paid Lunch Hours | - 0 | ||||||
| Non-Paid Break Hours | - 0 | ||||||
| Non-Paid Lunch Hours | - 0 | ||||||
| Total Break Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Total Paid Break Costs | $ - 0 |
| Total Paid Lunch Costs | $ - 0 |
| Total Cost for Paid Breaks and Lunches | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0 |
Narrative Description of Basis of Relief and Break Costs Included in the "Model for Price Realism" Tab
Instructions (also see Price Element Breakdown Instructions):
a. Complete the cells shown above in Rows 3 through 6 to detail the amount of (1) Paid Break and/or Lunch hours included in your pricing and (2) Non-Paid Break and/or Lunch hours. Row 7 automatically will compute the total.
b. For Rows 9 and 10 provide the total Paid break and/or Paid lunch break costs included in your "Model for Price Realism" worksheet.
c. Row 12 automatically computes the total cost for Paid Breaks and Lunches.
d. In the text box below provide a detailed narrative explaining (1) the basis of estimate for paid break/lunch costs included in your "Model for Price Realism" worksheet (e.g. XX amount of break /lunch time per an 8 hour shift) and (2) relief costs included in your "Model for Price Realism" worksheet. This narrative shall (1) explain which cost elements from the "Model for Price Realism" Worksheet contain the break costs detailed above including the amount of such costs included in each identified element, (2) the computations used to determine the paid breaks/lunch costs included in the pricing, (3) which cost elements from the "Model for Price Realism" Worksheet contain additional costs for providing relief (e.g. travel time). Additional worksheet tabs may be added if necessary to provide this requested Relief and Break pricing information.
e. Please note that the Total Cost for Paid Breaks and Lunches for each period will NOT automatically populate the Relief cells in row 47 of "Model for Price Realism" tab.
Non-PSO Positions
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | 6 Month Extension Period | Total Hours/Costs Priced | ||||||||||||||
| Full Time Equivalents | Total Hours Priced | Total Costs without G&A or Profit | Full Time Equivalents | Total Hours Priced | Total Costs without G&A or Profit | Full Time Equivalents | Total Hours Priced | Total Costs without G&A or Profit | Full Time Equivalents | Total Hours Priced | Total Costs without G&A or Profit | Full Time Equivalents | Total Hours Priced | Total Costs without G&A or Profit | Full Time Equivalents | Total Hours Priced | Total Costs without G&A or Profit | Total Hours Priced | Total Costs without G&A or Profit | |
| Contract Manager(s) | - 0 | $ - 0 | ||||||||||||||||||
| Regional Managers | - 0 | - 0 | ||||||||||||||||||
| Supervisors (Direct) | - 0 | - 0 | ||||||||||||||||||
| Quality Control Personnel | - 0 | - 0 | ||||||||||||||||||
| Training Instructor(s) | - 0 | - 0 | ||||||||||||||||||
| NWDTP Instructor(s) | - 0 | - 0 | ||||||||||||||||||
| Lead Officers | - 0 | - 0 | ||||||||||||||||||
| Admin | - 0 | - 0 | ||||||||||||||||||
| Other | - 0 | - 0 |
Total - 0 - 0 $ - 0 - 0 - 0 $ - 0 - 0 - 0 $ - 0 - 0 - 0 $ - 0 - 0 - 0 $ - 0 - 0 - 0 $ - 0 - 0 $ - 0
Instructions (also see Price Element Breakdown Instructions)
a. The purpose of this worksheet is to provide additional pricing information regarding the non-PSO positions that are included in your Labor Hour price build-up. Please note that the Total Costs without G&A and profit for each period will NOT automatically populate the Non-PSO position cells on the "Model for Price Realism" tab. Any applicable G&A and profit for the non-PSO positions should be accounted in the "Model for Price Realism" tab" .
b. 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 5,000 hours are quoted for a particular position and on average the annual productive hours of a full time employee for that position is 1800 hours (e.g. 2080 less 80 holiday less 160 vacation leave less 40 sick), the equivalent FTE to staff the labor category is calculated as 5000/1800 = 2.8 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 applicable cells for each Non-PSO Position category. This information may be used for Government Price Realism evaluation purposes.
c. In the text box below provide a detailed narrative explaining the basis of estimate for the Non-PSO Positions priced in this worksheet. The narrative should explain how the total Non-PSO position costs by labor category were estimated and how those costs were allocated among each building/CLIN.
Narrative Description of Basis of Non-PSO Position Costs
File details come from the government source that posted it. Updated .