Attachment_6_-_70RFP218REC000004_Price_Element_Breakdown.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
Protective Security Officer (PSO) services at two IRS locations in MD and DC
Solicitation number
70RFP218REC000004
Issued by

About this file

Amendment 2 RFP 70RFP218REC000004

View the file

Other files

File Type Posted
Amendent_6_.docx DOCX document
Attachment_6_-_70RFP218REC000004_Price_Element_Breakdown.xlsx XLSX spreadsheet
Attachment_4_-_Past_Performance_Questionaire.doc DOC document
Amendment_5.pdf PDF
Amendment_5_Att_2_-_RFP_70RFP218REC00004.pdf PDF
Amendent_4_.docx DOCX document
Amendent_3_.docx DOCX document
Amendment_2.pdf PDF
Amendment_1.pdf PDF
RFP_70RFP218REC000004.pdf PDF
Attachment_4_-_Past_Performance_Questionaire.doc DOC document
Attachment_6_-_Price_Element_Breakdown.xlsx XLSX spreadsheet
Show all 12

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

December 2016 Version
Applicable: Prevailing WD(s)/CBA(s):
CBA 2018-11200
Ordering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5Ordering Period 6 (FAR 52.217-8)
CLIN 0001CLIN 0002CLIN 1001CLIN 1002CLIN 2001CLIN 2002CLIN 3001CLIN 3002CLIN 4001CLIN 4002CLIN 5001CLIN 5002
PRICING ELEMENTBasic PSO Svcs for MD0278, DC0022Supervisory PSO Svcs for MD0278, DC0022Basic PSO Svcs for MD0278, DC0022Supervisory PSO Svcs for MD0278, DC0022Basic PSO Svcs for MD0278, DC0022Supervisory PSO Svcs for MD0278, DC0022Basic PSO Svcs for MD0278, DC0022Supervisory PSO Svcs for MD0278, DC0022Basic PSO Svcs for MD0278, DC0022Supervisory PSO Svcs for MD0278, DC0022Basic PSO Svcs for MD0278, DC0022Supervisory PSO Svcs for MD0278, DC0022Total
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
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

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.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

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

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

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

Profit $ - 0

Grand Total $ - 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 4 - Proposed Hours and Costs for Providing Breaks and Lunches, and Associated Relief Costs
LOT 4 Base PeriodLOT 4 Option Period 1LOT 4 Option Period 2LOT 4 Option Period 3LOT 4 Option Period 4LOT 4 Six Mos Ext. (FAR 52.217-8)LOT 4
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

BaseOption 1Option 2Option 3Option 46 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 4 - Base PeriodLOT 4 - Option Period 1LOT 4 - Option Period 2LOT 4 - Option Period 3LOT 4 - Option Period 4LOT 4 - 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.