Attachment 3 - Supporting Cost Data.xlsx
XLSX spreadsheet 38 KB Posted
- Solicitation number
- N6449820R4019
View the file
Other files
Show all 11
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
Summary Schedule
| Summary Schedule of Direct Costs and Indirec Rates Applied at Proposed Rates | |||
| Company Name: | xxxxx = not applicable for this cell | ||
| Contract Number/TO Number: | |||
| Technical Instruction Number: | |||
| CLIN/SLIN Number: | |||
| Date: | |||
| CONTRACT/Task No: | |||
| From | |||
| Rate | Amount | Tab | |
| Prime Contractors' Direct Labor | xxxxxx | $ - 0 | Amount in Column C derived from Totals on Prime DL Costs tab |
| Government Site DL | $ - 0 | Amount in Column C derived from Govt Prime DL Totals on Prime DL Costs tab | |
| Contractor Site DL | $ - 0 | Amount in Column C derived from Contractor Prime DL Totals on Prime DL Costs tab | |
| Fringes | % | (a) Rate in Column B derived from Indirect Rates, (b) Amount in Column C derived from indirect rate multiplied by proposed base costs | |
| Overhead - Govt-Site | % | (a) Rate in Column B derived from Indirect Rates, (b) Amount in Column C derived from indirect rate multiplied by proposed base costs | |
| Overhead - Contractor-Site | % | (a) Rate in Column B derived from Indirect Rates, (b) Amount in Column C derived from indirect rate multiplied by proposed base costs | |
| Subtotal Prime Contractor's DL and Applied Fringes/OH | $ - 0 |
| Subcontractors Direct Labor | xxxxxx | $ - 0 | Amount in Column C derived from Totals on Sub DL Costs tab |
| Subcontractors Other Direct Costs (ODCs) | xxxxxx | Amount in Column C derived from Total Subcontractor ODCs on ODCs tab | |
| Direct Materials | xxxxxx | Amount in Column C derived from Total Materials on ODCs tab | |
| Direct Specialized Services | xxxxxx | Amount in Column C derived from Total Specialized Services on ODCs tab | |
| Direct Travel | xxxxxx | Amount in Column C derived from Total Travel on ODCs tab |
| Subcontractor Handling Rate (on Subcontractor DL) | ||
| Subcontractor Handlng Rate (on Subcontractor ODCs) | % | (a) Rate in Column B derived from Indirect Rates, (b) Amount in Column C derived from indirect rate multiplied by proposed base costs |
| G&A - Applied | % | Rate in Column B derived from Indirect Rates |
| Incentive/Fixed Fee | ||
| Prime Contractor Fee for Prime Contractor Labor | % | |
| Prime Contractor Fee for Subcontractor Labor | % | |
| Total Incentive/Fixed Fee |
Total Cost Plus Incentive/Fixed Fee (CPFF/CPIF) $ - 0
| Prime contractor pass through Costs (not including fee) |
| Handling (if applicable) |
| G&A (if applicable) |
| Other (if any) |
| Total |
Prime DL Costs
If employee name not provided by contractor, put "TBD" in column "D" & identify contractor's basis for hourly rate in Column J; titled "Identify Basis for Hrly Rate….." (see * below for further requirements)
| (a) | (b) | (a) x (b) | ||||||
| Cost Elements | Key Personnel (yes/no) | Labor Category | Employee Name | Est Hours | Hrly Rate | Amount | Identify Basis for Hours (column e), i.e., provided in solicitation | Identify Basis for Hrly Rate (column F), i.e., contractor's current rates based on its payroll register |
| Prime Contractor Direct Labor | |
| Government Site DL | |
| Employee 1 (LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 2 LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 3 (LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 4 LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 5 (LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 6 (To be determined "TBD"), see * below for required details | |
| Total Govt Site DL | |
| Contractor Site DL | |
| Employee 6 (LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 7 (LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 8 (LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 9 (LASTNAME, FIRSTNAME if employee name provided) | |
| Employee 10 (LASTNAME, FIRSTNAME if employee name provided) | |
| Total Contractor Site DL |
TOTAL Prime Contractor Unburdened Direct Labor Cost
* = When a contractor identifies an employee name as "To be determined (TBD)", the contractor is required to provide the basis for its proposed hourly labor rate in Column J; along with supporting documentation for its proposed hourly labor rate. For example, a proposed hourly labor rate may be based on: (i) a contingent agreement with a prospective employee, (ii) contractor's average geographical hourly labor rates for the proposed labor category, (iii) hourly rate at which contractor hired last several electrical engineers in FY2015, (iv) Union Agreement, (vi) hourly labor rate survey data (a copy of the survey agreement if proprietary should be provided).
| As an example: | Labor Category | Employee Name | Est Hrs | Hrly Rate | Amount | Identify Basis for Hours (column e), i.e., provided in solicitation | Identify Basis for Hrly Rate (column F), i.e., contractor's current rates based on its payroll register | |
| Prime Contractor Direct Labor | xxxxxxxx | |||||||
| Government Site DL | xxxxxxxx | |||||||
| xxxxxxxx | Electrical Engineer | TBD | 40.0 | $ 25.00 | $ 1,000.00 | Requirements listed in Solicitation | Contractor's Avg Hrly Rate for Electrical Engineers in Philadelphia Region |
Indirect Rates
| Indirect Burden Pool Name | Rate or factor (FCCOM) | Basis for Rate/Factor (column d), i.e., Forward Pricing Rate Agreement with Government | Components of Allocation Base (cost elements against which indirect rate applied)* | Identify basis for Rate/Factor (column d), i.e., Forward Pricing Rate Agreement with Government |
| Fringe Benefits * | e.g., Prime Direct Labor (DL) $ | |||
| Overhead - On-Site * | e.g., Prime On-Site DL $ | |||
| Overhead - Off-Site * | e.g., Prime Off-Site DL $ | |||
| Subcontract Handling Rate * | e.g., Subcontract $ | |||
| General and Administrative (G&A) * | e.g, total costs excluding G&A pool costs | |||
| Facilities Capital Cost of Money (FCCOM) * | e.g., Prime DL $ | |||
| * = indirect burden pools vary from contractor to contractor. This will need to be tailored for each individual contractor. Additionally, the components | ||||
| of the allocation base against which indirect rates are applied (Column D) also vary from contractor to contractor & will also require modification for each contractor. | ||||
| Lastly, when a contractor is proposing different rates for the same pool becaue the proposed period of performance overlaps two contractor fiscal years (and the fiscal year rates vary), a contractor | ||||
| should identify each proposed fiscal year's indirect rates in separate rows (e.g., Fringe Benefits - FY2017 and Fringe Benefits - FY2018 would have separate rows) |
Sub DL Costs Cost Elements Labor Category Employee Name (if identified) Hours Hrly Rate Amount Basis for Hours (column d), i.e., based on hours directed by prime contractor Basis for Hrly Rate (column E); based on subcontractor's current rates supported by its payroll register
Authorized Subcontractor Labor Costs
| Subcontractor 1 (identify name) | ||||
| Employee 1 (if employee name provided) | ||||
| Employee 2 (if employee name provided) | ||||
| Subcontractor Fee | % | xxxxxx | xxxxxx | xxxxxx |
Total Proposed Subcontract 1 (id name) labor and fee
| Subcontractor 2 (identify name) | ||||
| Employee 1 (if employee name provided) | ||||
| Employee 2 (if employee name provided) | ||||
| Subcontractor Fee | % | xxxxxx | xxxxxx | xxxxxx |
Total Proposed Subcontract 2 (id name) labor and fee * xxxxxx xxxxxx
| Total Subcontractor Labor Costs | xxxxxx | xxxxxx | xxxxxx | xxxxxx |
| * additional rows will be needed for additional subcontractors. All authorized subcontractors should be identified on this tab |
ODCs Cost Elements Description of (a) each individual material item, (b) each individual service, (c) each employee traveling & each employee's travel destination ("from" and "to"), or (d) other description of other ODCs Units, Material Quantities, Labor Hours, or # of travel trips and duration of each TDY assignment Unit Cost Amount Basis for Units/Quantities/Hours, or # of travel trips (identified in column "D") Basis for Unit Cost (identified in column "E")
Other Direct Costs (ODCs):
1. Materials* (detailed list)
TOTAL INCIDENTAL/CONSUMABLE MATERIALS
2. Specialized services (detailed list)
TOTAL SPECIALIZED SERVICES
3. Travel Summary (detailed by employee/labor category and locations of travel)
TOTAL Direct Travel **
Total Prime Contractor ODCs (1 + 2 + 3)
| Subcontractors' ODCs: ** |
| 4. Consumable Materials (detailed list) |
5. Travel Summary (detailed by employee/labor category and locations of travel)
| Subcontractor ODCs (4 + 5) |
| * = listed should include all incidental, non-incidental, and consumable materials |
| ** = This tab should be customized for any other categories of ODCs which require separate visibility |
File details come from the government source that posted it. Updated .