Attachment_6a-Allocation_of_Supz_Costs_to_all_FDA_site.xlsx

XLSX spreadsheet 30 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 6a-Allocation of Supv Costs to all FDA sites

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

Allocation by FDA Building Allocation of All FDA Sites Supervisory Costs to Each FDA Buidling by Period

FDA Building NumberBaseOption 1Option 2Option 3Option 46 Mos ExtTotal
MD0006$ - 0
MD0239- 0
MD0300- 0
MD0721- 0
MD0757- 0
MD0786- 0
MD1428- 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Instructions:

The post exhibit contains four supervisory posts that perform functions for all of the FDA locations. 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.

In the text box below, vendors must describe their methodology for allocating the "All FDA Sites" supervisory costs to each FDA building listed above.

Notes:

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

2. Effort for building MD0786 does not being until 08/01/2018 during Option 1.

Narrative Description of Allocation Methodology for "All FDA Sites" Supervisory Costs:

ALL FDA Sites - Supv April 2014 Version

Applicable: Prevailing WD(s)/CBA(s): CBA-2011-4572 Rev.4 (See RFP Attachment 5)

Base YearOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 46 Month Extension (FAR 52.217-8)
PRICING ELEMENTShift SupervisorMobile and Lobby SupervisorTotal Base Year - All FDA SitesShift SupervisorMobile and Lobby SupervisorTotal Option 1 - All FDA SitesShift SupervisorMobile and Lobby SupervisorTotal Option 2 - All FDA SitesShift SupervisorMobile and Lobby SupervisorTotal Option 3 - All FDA SitesShift SupervisorMobile and Lobby SupervisorTotal Option 4 - All FDA SitesShift SupervisorMobile and Lobby SupervisorTotal 6 Mos - All FDA SitesTotal
Reg Hours Proposed- 0- 0- 0- 0- 0- 0- 0
OT Hours Proposed- 0- 0- 0- 0- 0- 0- 0
Shift Differential Hours Proposed- 0- 0- 0- 0- 0- 0- 0
Total Hours Proposed- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Hourly Wage Rate Proposed
OT Wage Rate Proposed
Shift Differential Wage Rate Proposed
Total Regular Wage Direct Labor (Ref Note 1)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Overtime Premium Direct Labor- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Shift Differential Pay- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Bonuses/Performance Pay- 0- 0- 0- 0- 0- 0- 0

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

Fringe Benefits
Proposed Health and Welfare Hourly Rate (Ref Note 2)
Health and Welfare$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Pension0.000.000.000.000.000.00- 0
401K Matching0.000.000.000.000.000.00- 0
Annual Benefit0.000.000.000.000.000.00- 0
Holiday0.000.000.000.000.000.00- 0
Vacation0.000.000.000.000.000.00- 0
Sick0.000.000.000.000.000.00- 0
Personal0.000.000.000.000.000.00- 0
Jury Duty0.000.000.000.000.000.00- 0
Other0.000.000.000.000.000.00- 0

Sub-Total Fringe Benefits $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Taxes
FICA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
FUTA0.000.000.000.000.000.00- 0
SUTA0.000.000.000.000.000.00- 0
Other0.000.000.000.000.000.00- 0

Sub-Total Taxes $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Overhead $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Other Direct Elements (Reference Note 2)
Workman's Comp Insurance (WCI)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0
Insurance - Other (Excluding WCI)- 0- 0- 0- 0- 0- 0- 0
Training- 0- 0- 0- 0- 0- 0- 0
Uniforms- 0- 0- 0- 0- 0- 0- 0
Body Armor- 0- 0- 0- 0- 0- 0- 0
Weapons- 0- 0- 0- 0- 0- 0- 0
Ammunition- 0- 0- 0- 0- 0- 0- 0
Personal Protection Equipment- 0- 0- 0- 0- 0- 0- 0
Targets- 0- 0- 0- 0- 0- 0- 0
Travel- 0- 0- 0- 0- 0- 0- 0
Vehicle (Lease or Depreciation)- 0- 0- 0- 0- 0- 0- 0
Vehicle Maintenance- 0- 0- 0- 0- 0- 0- 0
Vehicle Fuel Charges- 0- 0- 0- 0- 0- 0- 0
Authority and Jursidiction, Permits, Licenses, and Adherence to Laws (SOW Section 4)- 0- 0- 0- 0- 0- 0- 0
Medical/Physical Fitness/Drug Screen- 0- 0- 0- 0- 0- 0- 0
Other Start-Up/Transition- 0- 0- 0- 0- 0- 0- 0
Computer Usage Charges (Storage, Mainframe, Internet)- 0- 0- 0- 0- 0- 0- 0
Third Party Systems (e.g. Post Confirmation System)- 0- 0- 0- 0- 0- 0- 0
Consultants/Professional fees- 0- 0- 0- 0- 0- 0- 0
Other:- 0- 0- 0- 0- 0- 0- 0
XXXXX- 0- 0- 0- 0- 0- 0- 0
XXXXX- 0- 0- 0- 0- 0- 0- 0
XXXXX- 0- 0- 0- 0- 0- 0- 0
XXXXX- 0- 0- 0- 0- 0- 0- 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

Total Cost (Exluding G&A and Profit) for All FDA Sites Supervision $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 - 0

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 Instructions: The post exhibit contains four supervisory posts that perform functions for all of the FDA locations. These supervisory posts are listed under the "All FDA Sites" desgination in the building number column of the post exhibit. One of the "All FDA Sites" supervisory posts is a Shift Supervisor, the three remaining posts are Mobile and Lobby Supervisors. The purpose of this spreadsheet is to capture the costs for the "All FDA Sites" supervisor posts. Columns D, H, L, P, T, and X will automatically calculate the total costs for shift supervisor and Mobile/Lobby supervisor by each period based on the costs input by the vendor for each position. Column Z automatically calculates the total "All FDA Site" supervision cost for all periods. The total costs by period (Cells D93, H93, L93, P93, T93, and X93) should be allocated to each FDA building on the "Allocation by FDA Building" spreadsheet of this workbook.

Notes:

1. This spreadsheet does not calculate G&A or profit on the "All FDA Sites" supervisory costs. The spreadsheet also does not calculate an hourly rate for these costs. The costs from this spreadsheet will be allocated among all of the FDA buildings on the "Allocation by FDA Building" worksheet of this workbook. The allocated costs will then be included on the pricing spreadsheets for each respective building. Accordingly, G&A and profit can be applied on each building's pricing spreadsheet and a bill rate and fixed monthly amount will be calculated for each building.

2. The cost for dedicated supervision at buildings MD0006 and MD0786 should not be included in the cost breakdown below. These superivsory costs should be inlcuded on each buildings individual pricing breakdown.

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