N63394-21-R-0504_Attachment_JS-8_Cost_summary_format(2).xls

83 KB Posted

Attached to
Cooperative Engagement Capability (CEC) Alteration Installation Team (AIT)
Solicitation number
N6339421R0504
Issued by

About this file

Written by GovTribe AI ·

This document contains a cost summary format template and supporting documentation for a federal solicitation seeking engineering and technical support services. Naval Surface Warfare Center Port Hueneme Division is soliciting these services to provide Cooperative Engagement Capability Alteration Installation Team support. Services include installation, modification, logistics and upgrade support at various locations. Labor categories, hourly rates, overhead rates and past contract information are included for cost estimating purposes. The solicitation seeks these services for a one base and four option year period of performance and will result in a small business set-aside total contract award under NAICS code 336611.

View the file

Other files

File Type Posted
CEC AIT Amendment 5 conformed full.docx DOCX document
CEC AIT Mod Amendment 5.docx DOCX document
CEC AIT Amendment 4 conformed.docx DOCX document
CEC AIT Amendment 4 mod.docx DOCX document
CEC AIT mod Amendment 3.docx DOCX document
CEC AIT conformed Amendment 3.docx DOCX document
CEC AIT mod Amendment 3.docx DOCX document
Build Connect and Test Cables.xlsx XLSX spreadsheet
CEC AIT mod Amendment 2.docx DOCX document
CEC AIT conformed Amendment 2.docx DOCX document
N63394-21-R-0504_Attachment_JS-8_Cost_summary_format(2).xls XLS spreadsheet
Cable Repair and Test.xlsx XLSX spreadsheet
CEC AIT Amendment 1 mod.docx DOCX document
CEC AIT Amendment 1 conformed.pdf PDF
Exhibit_A_CDRLs Combined PDF.pdf PDF
CEC AIT RFP Final.pdf PDF
J-6_ GFI.pdf PDF
JS-9_SCA Wage Determinations.pdf PDF
N63394-21-R-0504_Attachment_JS-10_Past_Performance_Questionnaire(Clean).doc DOC document
J-4_QASP - CEC AIT.docx DOCX document
Exhibit_A_CDRLs Combined PDFs.pdf PDF
N63394-21-R-0504_Attachment_JS-7_DCAA_rate_check_form.xls XLS spreadsheet
N63394-21-R-0504_Attachment_J-3_Staffing_Plan_no_cost.xlsx XLSX spreadsheet
Show all 23

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Labor

SOLICITATION NO. N63394-21-R-0504 ATTACHMENT JS-8
COST SUMMARY FORMAT - LABOR COST ESTIMATE
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Direct CostsIndirect Cost Burden 1:Indirect Cost Burden 2:Indirect Cost Burden 3:Indirect Cost Burden 4:Fixed Fee:Facilities Capital Cost of Money Burden 1:Facilities Capital Cost of Money Burden 2:
Cost ElementsLabor CategoryRateHoursAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountEstimated Cost Plus Fixed Fee
Prime Contractor Labor Cost
Prime Contractor Labor
Item 1001
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1101
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1201
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1301
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1401
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Prime Contractor Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractor Labor Cost
Item 1001
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1101
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1201
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1301
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Item 1401
Employee Name 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Name 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Subcontractor Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Offerors may add additional columns to account for the application of additional burdens. Pricing shall be derived from left to right with the far left side including the direct costs and the far right including the direct cost following application of all fees and burdens. Please ensure working formulas. Please remember maximum pass-through rate that shall be charged against any non-ODC CLIN where labor is proposed under this contract shall not exceed 8%.

ODC

SOLICITATION NO. N63394-21-R-0504 ATTACHMENT JS-8
COST SUMMARY FORMAT - ODC ESTIMATE
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Indirect Cost Burden 1:Indirect Cost Burden 2:Indirect Cost Burden 3:Indirect Cost Burden 4:Facilities Capital Cost of Money Burden 1:Facilities Capital Cost of Money Burden 2:
Cost ElementsAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountRateAllocation BaseAmountTotal Price
Other Direct Cost
Other Direct Cost Material
Base Period$ 95,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 95,000
Option Period 1$ 95,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 95,000
Option Period 2$ 95,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 95,000
Option Period 3$ 95,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 95,000
Option Period 4$ 95,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 95,000
Total Other Direct Costs - Material$ 475,000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 475,000
Other Direct Cost Travel
Base Period$ 240,053$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 240,053
Option Period 1$ 240,053$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 240,053
Option Period 2$ 240,053$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 240,053
Option Period 3$ 240,053$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 240,053
Option Period 4$ 240,053$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 240,053
Total Other Direct Costs - Travel$ 1,200,265$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 1,200,265
Total Other Direct Cost$ 1,675,265$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 1,675,265

Offerors may add additional columns to account for the application of additional burdens. Pricing shall be derived from left to right with the far left side including the direct costs and the far right including the direct cost following application of all fees and burdens. Please ensure working formulas. Please remember maximum pass-through rate that shall be charged against any non-ODC CLIN where labor is proposed under this contract shall not exceed 8%.

Required Staff Plan_LOE

SOLICITATION NO. N63394-21-R-0504 - ATTACHMENT JS-8 REQUIRED STAFFING PLAN
Labor CategoryBLS
Occupation CodeBLS PercentileeCraft
Occupation CodeSCA
Occupation CodePlace of PerformanceEstimated Labor Hours
10%25%50%75%90%BaseOY1OY2OY3OY4Total
Manager, Program/Project III11-9198$27.08$39.14$55.94$73.88$94.84MANP3N/AGovernment Site, TBD1,1352,7903,1152,6352,05511,730
Project Coordinator13-1081$26.96$35.41$47.54$62.95$81.70ANM1N/AGovernment Site, TBD4,4278,54910,5598,6427,78739,964
Platform Manager11-3000$27.08$39.14$55.94$73.88$94.84MANO2N/AGovernment Site, TBD3,3667,6818,7067,0565,79132,598
Quality47-4011$18.20$23.49$30.22$38.93$48.64SQC2N/AGovernment Site, TBD2,1013,7644,5263,6193,30117,311
Task Leader11-1021$22.04$32.43$49.83$77.49VariesOS2N/AGovernment Site, TBD11,49620,74627,97124,99622,811108,018
Electronics Technician Maintenance I49-2094$18.83$24.05$29.81$36.12$42.292318123181Government Site, TBD11,57519,87026,83025,27022,555106,100
Electronics Technician Maintenance II49-2094$18.83$24.05$29.81$36.12$42.292318223182Government Site, TBD10,67517,21023,61521,83520,02093,355
Electronics Technician Maintenance III49-2094$18.83$24.05$29.81$36.12$42.292318323183Government Site, TBD8,56515,42520,12518,67516,30079,090
Laborer/Helper47-2061$12.54$14.75$18.22$24.20$33.602347023470Government Site, TBD5,51610,93513,36611,6909,97651,483
Fire Watch33-2011$12.95$17.24$25.24$34.07$45.099910099100Government Site, TBD3,1355,9407,1205,3254,98526,505
Welder51-4121$14.73$17.37$21.25$25.88$31.852396023960Government Site, TBD5,07010,14011,4607,9507,35041,970
Marine Chemist19-2031$21.62$27.92$38.13$52.11$67.14CHEM130090Government Site, TBD1051210229212838246611,378
Foundation Machining51-4041$14.06$17.26$22.04$27.85$33.202355023550Government Site, TBD83613401973183017397,718
Optical Alignment Services17-3098$17.88$23.28$30.86$39.86$49.423039030390Government Site, TBD951911919595667
Piping Flush, Clean and Testing47-2152$16.09$20.35$27.08$36.24$47.592379023790Government Site, TBD936291930142363169710,929
Total69,978129,601165,491144,818128,927638,816

Indirect Rate Support

Sample Indirect Rate Supporting Documentation
SOLICITATION NO. N63394-21-R-0504 - ATTACHMENT JS-8
BudgetActual Expenses
Overhead Expense2021202020192018
Payroll Taxes$ 110,000$ 93,000$ 90,000$ 85,000
Vacation$ 50,000$ 46,000$ 43,000$ 42,000
Holiday$ 40,000$ 40,000$ 39,000$ 38,500
Sick Leave$ 10,000$ 9,000$ 8,000$ 7,000
Pensions$ 200,000$ 175,000$ 165,000$ 155,000
Office Equipment$ 5,000$ 6,000$ 65,000$ 3,000
Depreciation$ 4,000$ 1,000$ 4,000$ 2,000
Travel$ 40,000$ 35,000$ 33,000$ 33,000
Reproduction$ 10,000$ 9,800$ 9,700$ 9,600
Rent$ 130,000$ 82,000$ 75,000$ 68,000
Advertising$ 55,000$ 44,000$ 50,000$ 42,000
Insurance$ 48,000$ 46,000$ 44,000$ 42,000
Telephone$ 12,000$ 12,000$ 11,500$ 10,000
Total Pool$ 714,000$ 598,800$ 637,200$ 537,100
Less Unallowable Costs
Entertainment$ 6,000$ 4,000$ 1,000$ 3,000
Net Allowable Costs$ 708,000$ 594,800$ 636,200$ 534,100
Allocation Base
Direct Labor$ 1,895,500$ 1,756,200$ 1,650,000$ 1,530,000
Overhead Rate37.35%33.87%38.56%34.91%
*Contributing Government ContractsExpiration DateValue of Contracts
N000XX-XX-X-00XX6/1/18
N000XX-XX-X-00XX9/1/19
N000XX-XX-X-00XX8/1/17
* When developing your percentage, these are the contracts contributing
to development of the percentage.

Non-Key Proposed Staffing Plan

This table may be used for completing the proposed staffing plan. Key personnel have been removed from this table because their resumes will be provided as a separate part of the proposal. Bidders may propose alternate labor categories and work locations but should note any changes from the baseline. (Note: Number of rows may not total number of FTEs due to part time efforts. Bidders may add rows if desired.)
Labor CategoryGov't SiteKTR SiteCLINNameCompanyCompany Labor CategoryYears of ExperienceHighest level of educationDegreeClearance
Clerical
Admin & Security
* Task Paragraphs with an "X" imply that those labor categories perform multiple subtasks within the primary task paragraph.
FTE = Full Time Equivalent
KTR = Contractor

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