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

About this file

Attachment 6 - Price Element Breakdown Spreadsheet

View the file

Other files

File Type Posted
Seniority_List.pdf PDF
Amendment_0011.pdf PDF
Amendment_0010.pdf PDF
SF-1449.pdf PDF
Exhibit_10_CPE_Limited_NWDTP.pdf PDF
Seniority_List.pdf PDF
Q A_Amendment_0009.pdf PDF
Amendment_00008.pdf PDF
Amendment_0007.pdf PDF
Amendment_0006.pdf PDF
Amenedment_0005.pdf PDF
Amendment_0004.pdf PDF
Attachment_6A_-_Price_Element_Breakdown_Instructions_April_2014.pdf PDF
Amendment_0003.pdf PDF
Amendment_0002.pdf 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 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 ELEMENTOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 56 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 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 56 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 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 56 Month Extension PeriodTotal Hours/Costs Priced
Full Time EquivalentsTotal Hours PricedTotal Costs without G&A or ProfitFull Time EquivalentsTotal Hours PricedTotal Costs without G&A or ProfitFull Time EquivalentsTotal Hours PricedTotal Costs without G&A or ProfitFull Time EquivalentsTotal Hours PricedTotal Costs without G&A or ProfitFull Time EquivalentsTotal Hours PricedTotal Costs without G&A or ProfitFull Time EquivalentsTotal Hours PricedTotal Costs without G&A or ProfitTotal Hours PricedTotal 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 .