Attachment_6a-Allocation_of_Supz_Costs_to_all_FDA_site.xlsx
XLSX spreadsheet 30 KB Posted
- Solicitation number
- HSHQEC-16-R-00004
About this file
Spreadsheet 6a
View the file
Other files
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 Number | Base | Option 1 | Option 2 | Option 3 | Option 4 | 6 Mos Ext | Total |
| 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 Year | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | 6 Month Extension (FAR 52.217-8) | ||||||||||||||
| PRICING ELEMENT | Shift Supervisor | Mobile and Lobby Supervisor | Total Base Year - All FDA Sites | Shift Supervisor | Mobile and Lobby Supervisor | Total Option 1 - All FDA Sites | Shift Supervisor | Mobile and Lobby Supervisor | Total Option 2 - All FDA Sites | Shift Supervisor | Mobile and Lobby Supervisor | Total Option 3 - All FDA Sites | Shift Supervisor | Mobile and Lobby Supervisor | Total Option 4 - All FDA Sites | Shift Supervisor | Mobile and Lobby Supervisor | Total 6 Mos - All FDA Sites | Total |
| 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 |
| Pension | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| 401K Matching | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Annual Benefit | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Holiday | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Vacation | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Sick | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Personal | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Jury Duty | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.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 |
| FUTA | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| SUTA | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | - 0 |
| Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.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 .