Attachment_7.pdf

PDF 115 KB Posted

Attached to
Protective Service Officers (PSO) at various locations in Maryland
Solicitation number
HSHQEC-16-R-00004
Issued by

About this file

Attachment 7

View the file

Other files

File Type Posted
Attachment_6d-MD0239.xlsx XLSX spreadsheet
Attachment_6a-Allocation_of_Supz_Costs_to_all_FDA_site.xlsx XLSX spreadsheet
Attachment_6i-MD0759.xlsx XLSX spreadsheet
Attachment_6f-MD0721.xlsx XLSX spreadsheet
Attachment_6j-MD1871.xlsx XLSX spreadsheet
Attachment_6c-MD0006.xlsx XLSX spreadsheet
Amendment_3.pdf PDF
Attachment_6g-MD0757.xlsx XLSX spreadsheet
Attachment_6e-MD0300.xlsx XLSX spreadsheet
Attachment_6h-MD0786.xlsx XLSX spreadsheet
Attachment_6b-MD1428.xlsx XLSX spreadsheet
Amendment_2.pdf PDF
Amendment_1.pdf PDF
Attachment_6g-MD0757.xlsx XLSX spreadsheet
Attachment_9_-_Proposal_Submission_Checklist.pdf PDF
Att_5-Prevailing_WD-2005-2103_Rev._16.pdf PDF
Exhibit_5__Lautenberg.pdf PDF
Attachment_6d-MD0239.xlsx XLSX spreadsheet
Exhibit_5_A_Lautenberg_Fact_Sheet.pdf PDF
Exhibit_7_Contractor's_Certification.pdf PDF
Exhibit_11_GPE.pdf PDF
HSHQEC-16-R-00004-Table_of_Contents_ _Notice_to_Offerors.pdf PDF
Exhibit_12 _Physicians_Certification_2_5_16.pdf PDF
Exhibit_16_(FPS_FORM_139).pdf PDF
Exhibit_4_DHS_Form_11000-9.pdf PDF
RFP_Attachment_3_-_Past_Project_Form.pdf PDF
Attachment_6j-MD1871.xlsx XLSX spreadsheet
Exhibit_9A_Screening_Operations_Assessment.pdf PDF
Exhibit_7b_Preemployment_Requirement_Validation.pdf PDF
Exhibit_6_List_of_Req_Trng.pdf PDF
Attachment_2_PSO_Master_Certification_CMT_4_16_14.pdf PDF
CBA-2011-4572_Rev.4.pdf PDF
Exhibit_9_GPT.pdf PDF
Exhibit_8_CPT.pdf PDF
Exhibit_7a_Personal_Data_Validation.pdf PDF
Attachment_6i-MD0759.xlsx XLSX spreadsheet
Attachment_6c-MD0006.xlsx XLSX spreadsheet
Exhibit_11A_GPE_Supplementary_Equip.pdf PDF
HSHQEC-16-R-00004-Terms Conditions.pdf PDF
Attachment_6h-MD0786.xlsx XLSX spreadsheet
CBA-2009-2938_Rev.5.pdf PDF
Exhibit_14_DHS_11000-14_PACS_User_Agreement.pdf PDF
Attachment_6b-MD1428.xlsx XLSX spreadsheet
Attachment_3_PSO_Personnel_File_Outline.pdf PDF
Attachment_6e-MD0300.xlsx XLSX spreadsheet
Exhibit_11B_Lost_Stolen_PIV_Procedures.pdf PDF
Attachment_6f-MD0721.xlsx XLSX spreadsheet
CBA-2011-4571_Rev.5.pdf PDF
Exhibit_1_List_of_Req_Forms.pdf PDF
Attachment_6a-Allocation_of_Supz_Costs_to_all_FDA_site.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 60 listed here. See the rest on GovTribe.

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

Attachment 7 - Supplement

Instructions for Price Element Breakdown Templates 6

Introduction

Price Element Breakdown Template Attachment 6 is a Microsoft Excel based pricing tool that provides a standardized format for costing the PSO fixed monthly amounts and the allocation of Supervisory costs to those fixed monthly amounts. The templates were designed to assist contractors in pricing their proposal. Attachment 6 is a template the is made up of 10 individual spreadsheets for PSO/Supervisor services and are described as follows: Attachment 6a-Allocation of Supv Costs to all FDA sites, Attachment 6b-MD1428, Attachment 6c-MD0006, Attachment 6d-MD0239, Attachment 6e-MD0300, Attachment 6f-MD0721, Attachment 6g- MD0757, Attachment 6h-MD0786, Attachment 6i-MD0759, and Attachment 6j-MD1871. The cost data provided in these worksheets are considered other than certified cost pricing data as discussed under FAR 15.403-5(b)(2).

Instructions for Completion

1. Note that the Price Element Breakdown file (Attachment 6) contains 10 spreadsheets and are described in the above paragraph. The spreadsheets identified 6b through 6j are broken down per building and are identified with there corresponding wage determination number. Each of the spreadsheets are broken down into 5 tabs; “Model for Price Pealism”, “Breaks & Relief”, “Other Positions”, “NWDTP Instructor Training”, and “NWDTP PSO Training”.

2. Cost data for the Non-PSO Positions shall be entered under the “Other Postions” tab as instructed by the notes on the worksheet. This work sheet should exclude supervisors that will be billed direct from attachment 6a. Please note that the Total Costs without G&A and profit for each period will NOT automatically populate the Other Positions cells in row 93 of the "Model for Price Realism" tab. Any applicable G&A and profit for the Other Positions should be accounted in the "Model for Price Realism" tab".

3. The Breaks & Relief tabs do NOT self-populate to the applicable cells in row 52 of the “Model for Price Realism” worksheet tabs. The purpose of these worksheets is to provide specific cost data regarding relief and breaks that was included in the offeror’s proposal. For Rows 9 and 10 provide the total Paid break and/or Paid lunch break costs included in your "Model for Price Realism" worksheet. For Row 12 provide the total Relief costs for providing any Paid or Unpaid breaks included in your "Model for Price Realism" worksheet.

4. The NWDTP instructor Training tabs provide additional pricing information regarding the number of individuals that are included in your costs for the initial 40 hour NWDTP Instructor Training (See SOW Sections 6.7.3.1, 6.7.3.1.1, and 6.7.3.1.1.2). Please note that the additional 32 hours of co-teaching and observation training (See SOW Sections

6.7.3.1 and 6.7.3.1.2), as well as the annual 16 hour recertification (See SOW Section

6.7.3.2), should not be priced on this spreadsheet. These training activities will occur during normal NWDTP PSO training provided by the NWDTP Instructor. There is a line item on row 6 of the "Other Positions" tab to record the costs for the NWDTP Instructor(s) other than the initial training priced on this worksheet. Also note that the "Total Costs for NWDTP Instructor Training" for each period will NOT automatically populate the corresponding cells in Row 58 (Training -X Ray Screening training) of the "Model for Price Realism" tab. Note that the "Total Costs for NWDTP Instructor Training" for each period will NOT automatically populate the corresponding cells in Row 58 (Training -X Ray Screening training) of the "Model for Price Realism" tab.

Accordingly, the vendor should make sure that the appropriate costs from the “NWDTP Instructor Training” tab are presented in row 63 of the “Model for Realism” tab.

5. The NWDTP PSO training tabs provide additional pricing information regarding the number of PSOs that are included in your costs for: (1) Initial 16 hour NWDTP X Ray Screening Training, (2) Initial 8 hour NWDTP Non X Ray Screening Training, and (3) On-the-Job Training (See SOWs 6.7.4.1.1 and 6.7.4.11). Please note that the "Total Cost for NWDTP X Ray and Non X Ray Screening Training" for each period WILL automatically populate the corresponding cells in Row 64 (NWDTP PSO Training) of the "Model for Price Realism" tab.

6. Note that the Allocation of Supervision Costs to All FDA sites Price Breakdown Spreadsheet (Attachment 6a) contains two worksheet tabs entitled, “Allocation by FDA Buidling” and “All FDA Sites-Supv”. The price breakdown file requires offerors to provide cost amounts for (4) four supervisory posts that perform functions for all of the FDA locations (i.e.Shift Supervisor, and Mobile and Lobby Supervisor) by contract period. The Shift Supervision and Mobile and Lobby Supervisior positions are identified in Wage Determination No. CBA-2011-4572 Rev.4 (provided under attachment 5). The post schedule identifies supervisory positions, and are described a Shift Supervisor or Mobile and Lobby Supervisor. These supervisory posts are listed under the "All FDA Sites" desgination in the building number column of the post exhibit. Given that these Supervisory posts cannot be directly identified to any one specific builiding that they benefit, the purpose of this spreadsheet is for the user to allocate the total cost by ordering period for the All FDA Sites supervision ("All FDA Sites - Supv" Cells D93, H93, L93, P93, T93, and X93) to each FDA building. The allocated Supervision cost by building will be carried forward to each individual builiding's pricing spreadsheet and will be included in the bill rate for those buildings. The supervisory posts permanently located at building MD0006 and MD0786 should not be inlcuded the costs above. These posts will be priced on each respective buildings pricing sheets. The costs above are only for the supervisory posts identifed as "All FDA Sites". Effort for building MD0786 does not begin until 08/01/2018 during Option 1.

7. For spreahsheet 6c-MD0006 and 6h-MD0786 Columns B, C, G, G, J, K, N,O, R, S in the “Model for Price Realism” worksheet tab are separate colums to price out PSO costs and the dedicated Supervisor costs.

8. The worksheets are not locked and may be adjusted by the offeror as appropriate.

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