Atch_6-Price_Element_Breakdown_(Corrected).xlsx

XLSX spreadsheet 45 KB Posted

Attached to
Protective Security Officer Services Federal contract opportunity
Solicitation number
70RFP219REC000002
Issued by
Department of Homeland Security Office of Procurement Operations

About this file

This document contains a price breakdown template and instructions for a solicitation seeking armed protective security officer services at multiple locations in Washington, D.C. The solicitation number is 70RFP219REC000002 and will be issued by the Department of Homeland Security's Federal Protective Service on or around February 22, 2019. Offerors must register in the System for Award Management and plan to attend an optional pre-proposal conference for additional details. The acquisition is set aside as a total HUBZone small business and will result in a single-award IDIQ contract for a base year and five one-year options. The template requires pricing details for regular and overtime wages, health and welfare benefits, paid breaks and lunches, relief staffing, non-productive time, overhead, G&A, and non-PSO positions. Narratives must explain the rate assumptions and cost methodologies.

Attachment 6-Price Element Breakdown for Solicitation 70RFP219REC000002 Non-Supervisory Positions

View the file

Other files for this federal contract opportunity

Other files attached to Protective Security Officer Services, newest first.
File Type Posted
70RFP219REC000002_Amd_0004.pdf PDF
Atch_6A-Price_Element_Breakdown_Supervisors.xlsx XLSX spreadsheet
70RFP219REC000002_AMD_0003.pdf PDF
Amendment_0002.pdf PDF
Amendment_0001.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Model for Price Realism

Model for Price Realism
December 2016 Version
Applicable: Prevailing WD(s)/CBA(s): CBA-2019-12241, Rev. 1; CBA-2019-12116; CBA-2019-12216; CBA-2019-12117
PRICING ELEMENTOrdering Period IOrdering Period IIOrdering Period IIIOrdering Period IVOrdering Period VOrdering Period VI - 6 Month Extension (FAR 52.217-8)Total
Regular Hourly Wage Rate Proposed (Ref Note 1)
Health and Welfare Hourly Rate Proposed (Ref Note 1)

Total Productive Hours Proposed - 0

Total Regular Wage Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Cost for Premium Portion of Estimated Overtime Hours (Ref Note 2)- 0
Shift Differential Pay- 0
Bonus/Performance Pay- 0

Subtotal - Productive Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

PSO Fringe Benefits and Non-Productive Time (Ref Note 4)
Health and Welfare (Ref Notes 1 & 3)$ - 0
Pension (Ref Note 1)- 0
401K Matching (Ref Note 1)- 0
Annual Benefit- 0
Holiday- 0
Vacation- 0
Sick- 0
Personal- 0
Jury Duty- 0
Bereavement- 0
Training- 0
Guard Mount- 0
Breaks & Lunches (See Breaks & Lunches Tab for Additional Pricing Info Required)0.000.000.000.000.000.00- 0
Other- 0

Sub-Total Fringe Benefits and Non-Productive Time $ - 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 4)
Workman's Comp Insurance$ - 0
General Liability Ins- 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:
XXXXX- 0
XXXXX- 0
XXXXX- 0

Sub-Total - Other Direct Elements $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Non-PSO Positions (See Non-PSO Positions Tab for additional Price Info Required) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 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 - Cost for Premium Portion of Estimated Overtime Hours

Note 3 - Health and Welfare

Note 4 - Fringe Benefits, Non-Productive Time, and Other Direct Element Pricing

Signature and Title of Preparer

(&"Arial,Italic"Name of Company&"Arial,Regular") Attachment 6 - Price Element Breakdown for Solicitation 70RFP219REC000002 Non-Supervisory Positions &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.

Provide written narratives describing the basis of the proposed Wage and Health & Welfare rates, including when weighted averages are used due to multiple applicable wage determinations.

Narrative on the Basis of the Proposed Wage and Health & Welfare Rates Provide a description of the basis of estimate for the H&W amount proposed in Row 18 as well as a description of any estimates, including the specific cost elements/spreadsheet rows containing those estimates, of any other health and welfare amounts priced into the proposal. For example, if all H&W cost proposed, inclusive of any H&W amounts paid for non-productive time (if applicable), is included in Row 18, then the narrative should describe that all H&W costs are included in Row 18 and how those costs were calculated. However, if for example H&W costs paid for Non-Productive time, if applicable, are included in Rows 22 through 30, then the narrative should clearly describe those Rows that contain costs for H&W and the basis of estimate for those costs.

Narrative on the Basis of Estimate for H&W Costs The "Cost for Premium Portion of Estimated Overtime Hours" line item (Row 11) is for contractors to input the lump sum premium cost for overtime hours estimated to be worked. These amounts should only represent the premium portion of overtime cost because the basic wages are already included in the Total Regular Wage Direct Labor (Row 10). The Government will not provide SCA price adjustments during contract performance for the premium portion of overtime hours worked. Accordingly, contractors should consider any applicable escalation for the overtime premium portion of the labor costs included in their price proposal. Note, contractors are required to input the percentage of overtime hours compared to productive hours on the "FTEs, Nonproductive Hrs, & OT" worksheet.

Breaks & Lunches

Proposed Hours and Costs for Providing Breaks and Lunches, and Associated Relief Costs
Ordering Period IOrdering Period IIOrdering Period IIIOrdering Period IVOrdering Period VOrdering Period VI - 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/Lunch Hours- 0- 0- 0- 0- 0- 0- 0
Total Paid Break Costs$ - 0
Total Paid Lunch Costs- 0
Other Costs to Provide Relief- 0

Total Cost for Paid Breaks, Lunches, and Relief $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

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 that the vendor estimates will be provided. Row 7 automatically will compute the total.

b. For Rows 9 and 10 provide the total Paid break and/or Paid lunch costs included in your "Model for Price Realism" worksheet.

c. Input in Row 11 any other costs for providing relief (e.g. Relief Officer travel time between posts) that are not priced elsewhere in the "Model for Realism" (i.e. additional relief costs not included in Row 30 of the "Model for Realism"). See instruction e. below for a description of the narrative requirement identifying which costs elements on the "Model for Realism" include relief costs.

d. Row 13 automatically computes the total cost for Paid Breaks, Lunches, and other costs to provide relief.

e. In the text box below provide a detailed narrative explaining the basis of estimate for paid break/lunch costs (e.g. XX amount of break /lunch time per an 8 hour shift) and other relief costs included in your "Model for Price Realism" worksheet. This narrative shall explain (1) the computations used to determine the paid breaks/lunch costs included in the pricing, (2) the basis of estimate and composition of other costs for providing relief (e.g. wages and fringes paid to XX relief officer(s) for XX travel time between posts), and (3) if applicable, which cost elements from the "Model for Price Realism" Worksheet , other than Row 30, contain additional costs for paid breaks/lunches and/or relief . Additional worksheet tabs may be added if necessary to provide this requested Relief and Break pricing information.

f. The Total Cost for Paid Breaks, Lunches, and Relief for each period will automatically populate the Relief cells in row 30 of "Model for Price Realism" tab.

Note - The Government will not provide SCA price adjustments during contract performance for increases in wages and benefits provided for paid lunches and relief associated with paid lunches.

Narrative Description of the Basis of Relief and Break Costs Included in the "Model for Price Realism" Tab

Non-PSO Positions Proposed FTEs, Hours, and Costs for Non-PSO Positions

Ordering Period IOrdering Period IIOrdering Period IIIOrdering Period IVOrdering Period VOrdering Period VI - 6 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 Manager(s)- 0- 0
Quality Control Personnel- 0- 0
NWDTP Instructor(s)- 0- 0
Training Instructor(s)- 0- 0
Admin- 0- 0
Additional Positions:
XXX- 0- 0
XXX- 0- 0
XXX- 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 or Profit for each period will 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 priced on the "Model for Price Realism" tab" on the G&A and Profit lines (Rows 74 and 78).

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.

FTEs, Nonproductive Hrs, & OT

PSO FTEs, Non-Productive Hours per FTE, and Percentage of Overtime Hours Proposed by Period
Ordering Period IOrdering Period IIOrdering Period IIIOrdering Period IVOrdering Period VOrdering Period VI - 6 Month Extension (FAR 52.217-8)
PSO Full Time Equivalents Proposed
Vacation Hours per FTE
Sick/Personal Hours per FTE
Holiday Hours per FTE
Training Hours per FTE
Guard Mount Hours per FTE
Percentage of Productive Hours to be Fulfilled through the use of Overtime

Instructions:

In the cells above, input the number of proposed Full Time Equivalent (FTE) PSOs, Vacation Hours per FTE, Sick/Personal Hours Per FTE, Holiday Hours Per FTE, Training Hours per FTE, Guard Mount Hours per FTE, and Percentage of Productive Hours Hours to be Fulfilled through the use of Overtime . These amounts shall correspond to the costs presented on the Model for Price Realism tab. The percentage of Productive Hours to be fulfilled through the use of Overtime is calculated by dividing Productive Overtime Hours by Total Productive Hours. Note, not all of the non-productive hour categories listed above may pertain to your proposal. Accordingly, only input values for those categories that are included in the price build up prepared on the Model for Price Realism spreadsheet.

The input above is based on a pricing strategy that utilizes Full Time Equivalent calculations as a basis of estimate for non-productive hours. If a different pricing strategy was utilized, vendors should alter this spreadsheet to provide similar information based on their unique pricing strategy . The data inputted in this spreadsheet does not automatically populate any other spreadsheet and is not used in any formulas contained in this workbook.

In the text box below, provide a narrative describing the basis of the proposed PSO FTEs , each applicable non-productive hour category, and the percentage of overtime hours. Describe any unique factors that may impact the estimate(s). For example, if the estimates consider certain non-productive hour categories do not pertain to all PSOs (e.g. part time PSOs), then the narrative should clearly explain the impact.

This information may be used for Government Price Realism evaluation purposes.

Narrative Description of the Basis of the PSO Full Time Equivalents and Non-Productive Hours Proposed

File details come from the government source that posted it. Updated .