Lot_5_-_Price_Element_Breakdown.xlsx

XLSX spreadsheet 58 KB Posted

Attached to
PSO services at various federal facilities in Maryland, Virginia and Washington, D. C.
Solicitation number
70RFP218REC000002
Issued by

About this file

This document contains a price element breakdown template for a federal contract solicitation for armed protective security officer services. The solicitation will be for up to five single-award, firm-fixed price, indefinite delivery/indefinite quantity contracts for lots covering various federal facilities in Maryland, Virginia, Washington D.C. The required services include providing armed protective security officers, with estimated periods of performance consisting of five base one-year ordering periods plus a six-month optional ordering period. Offerors must submit technical and price proposals in response to solicitation number 70RFP218REC000002, which is set to be released on May 31, 2018 for these small business set-aside requirements. The template provides instructions and tables for offerors to break out proposed price elements by labor category, fringe benefits, overhead rates, and other direct costs for the government to evaluate price realism.

Lot 5 - Price Element Spreadsheet

View the file

Other files

File Type Posted
70RFP218REC000002_-_Amendment_0011.pdf PDF
Award_Notice.pdf PDF
Conformed_Contract.pdf PDF
Amendment_0009.pdf PDF
Pricing_schedule.xlsx XLSX spreadsheet
Amendment_0008.pdf PDF
Lot_1_Exhibit_10_.pdf PDF
Revised_SOW.pdf PDF
CBA-2018-11483_(DC0011).pdf PDF
Amendment_0007.pdf PDF
Lot_3_EXHIBIT_10.pdf PDF
Lot_4_Exhibit_10.pdf PDF
Lot_2_Exhibit_10.pdf PDF
CBA-2014-6843_Rev._3_(MD0785_MD1248_MD0262_MD0774).pdf PDF
Amendment_0006.pdf PDF
Amendment_0005.pdf PDF
Amendment_0004.pdf PDF
Amendment_0003.pdf PDF
PreProposalConferenceSlides.ppt PPT presentation
Amendment_0002.pdf PDF
Amendment_0001.pdf PDF
Lot_5_-_Seniority_List.xlsx XLSX spreadsheet
Lot_1_-_Seniority_List.xlsx XLSX spreadsheet
Lot_4_-_Seniority_List.xlsx XLSX spreadsheet
Lot_3_-_Seniority_List.xlsx XLSX spreadsheet
Lot_2_-_Seniority_List.xlsx XLSX spreadsheet
Lot_2_-_Price_Element_Breakdown.xlsx XLSX spreadsheet
Lot_3_-_Price_Element_Breakdown.xlsx XLSX spreadsheet
Lot_4_-_Price_Element_Breakdown.xlsx XLSX spreadsheet
Pricing_schedule.xlsx XLSX spreadsheet
Lot_1_-_Price_Element_Breakdown.xlsx XLSX spreadsheet
Conformed_Solicitation.pdf PDF
Show all 32

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

LOT 5 Model for Price Realism
December 2016 Version
Applicable: Prevailing WD(s)/CBA(s):
LOT 5 - Ordering Period 1LOT 5 - Ordering Period 2LOT 5 - Ordering Period 3LOT 5 - Ordering Period 4LOT 5 - Ordering Period 5LOT 5 - 6 Month Extension (FAR 52.217-8)
CLIN 0001CLIN 0002CLIN 0003CLIN 0004CLIN 1001CLIN 1002CLIN 1003CLIN 1004CLIN 2001CLIN 2002CLIN 2003CLIN 2004CLIN 3001CLIN 3002CLIN 3003CLIN 3004CLIN 4001CLIN 4002CLIN 4003CLIN 4004CLIN 5001CLIN 5002CLIN 5003CLIN 5004
PRICING ELEMENTBasic PSO Svcs for VA0301, VA0316, VA0263, VA0822Basic PSO Svcs for VA0008Basic PSO Svcs for VA0382Lot 4 Supervisory Posts (Note 5)Basic PSO Svcs for VA0301, VA0316, VA0263, VA0822Basic PSO Svcs for VA0008Basic PSO Svcs for VA0382Lot 5 Supervisory Posts (Note 5)Basic PSO Svcs for VA0301, VA0316, VA0263, VA0822Basic PSO Svcs for VA0008Basic PSO Svcs for VA0382Lot 5 Supervisory Posts (Note 5)Basic PSO Svcs for VA0301, VA0316, VA0263, VA0822Basic PSO Svcs for VA0008Basic PSO Svcs for VA0382Lot 5 Supervisory Posts (Note 5)Basic PSO Svcs for VA0301, VA0316, VA0263, VA0822Basic PSO Svcs for VA0008Basic PSO Svcs for VA0382Lot 5 Supervisory Posts (Note 5)Basic PSO Svcs for VA0301, VA0316, VA0263, VA0822Basic PSO Svcs for VA0008Basic PSO Svcs for VA0382Lot 5 Supervisory Posts (Note 5)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$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 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.000.000.000.000.000.000.000.000.000.000.000.000.00- 0
Other- 0

Sub-Total Fringe Benefits and Non-Productive Time $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Non-PSO Positions (See Non-PSO Positions Tab for additional Price Info Required) $ - 0

General and Administrative $ - 0

Total Price w/o Profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Profit $ - 0

Grand Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 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

Note 5 - Supervisors Are Not Subject to Contract Price Adjustments under FAR 52.222-43

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.

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 22 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 22, then the narrative should describe that all H&W costs are included in Row 22 and how those costs were calculated. However, if for example H&W costs paid for Non-Productive time, if applicable, are included in Rows 26 through 33, 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 15) 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 14). 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.

Supervisors are not considered service employees under 29 CFR 4.113(b), since they cannot stand post in a Supervisor capacity and their responsibilities include “management” as that term is defined under 29 CFR 541.102. Therefore, Supervisors are not covered under the Service Contract Act and increases to Supervisor wages and fringes are not subject to contract price adjustment under FAR 52.222-43. As a result, any escalation associated with these supervisory costs, including wages and benefits, should be included in the price proposal.

Breaks & Lunches

LOT 5 - Proposed Hours and Costs for Providing Breaks and Lunches, and Associated Relief Costs
LOT 5 Ordering Period 1LOT 5 Ordering Period 2LOT 5 Ordering Period 3LOT 5 Ordering Period 4LOT 5 Ordering Period 5LOT 5 Six Mos Ext. (FAR 52.217-8)LOT 5
CLIN 0001CLIN 0002CLIN 0003CLIN 1001CLIN 1002CLIN 1003CLIN 2001CLIN 2002CLIN 2003CLIN 3001CLIN 3002CLIN 3003CLIN 4001CLIN 4002CLIN 4003CLIN 5001CLIN 5002CLIN 5003Total
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- 0- 0- 0- 0- 0- 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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Instructions (also see Price Element Breakdown Instructions):

a. Complete the cells shown above in Rows 4 through 7 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 8 automatically will compute the total.

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

c. Input in Row 12 any other costs for providing relief (e.g. Relief Officer travel time between posts) that are not priced elsewhere in 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 14 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 34, 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 34 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 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 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 78 and 82).

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.

Describe the methodology for allocating the Non-PSO Position costs above to the individual CLINs presented on the Model for Realism worksheet (Row 76).

Narrative Description of Allocation Methodology for Non-PSO Position Costs:

FTEs, Nonproductive Hrs, & OT

PSO FTEs, Non-Productive Hours per FTE, and Percentage of Overtime Hours Proposed by Period
LOT 5 - Ordering Period 1LOT 5 - Ordering Period 2LOT 5 - Ordering Period 3LOT 5 - Ordering Period 4LOT 5 - Option Period 5LOT 5 - 6 Month Extension (FAR 52.217-8)
CLIN 0001CLIN 0002CLIN 0003CLIN 0004CLIN 1001CLIN 1002CLIN 1003CLIN 1004CLIN 2001CLIN 2002CLIN 2003CLIN 2004CLIN 3001CLIN 3002CLIN 3003CLIN 3004CLIN 4001CLIN 4002CLIN 4003CLIN 4004CLIN 5001CLIN 5002CLIN 5003CLIN 5004
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 .