Attachment 6B - Subcontractor Pricing Model.xlsx

XLSX spreadsheet 103 KB Posted

Attached to
Maritime Position, Navigation and Timing (PNT) Systems In-Service Engineering and Technical Support Services Federal contract opportunity
Solicitation number
N65236-17-R-0008
Issued by
Department of the Navy Information Warfare Systems Command

About this file

This document package includes a subcontractor pricing model template and related federal contract opportunity notice. The pricing model template provides instructions and assumptions for subcontractors to use to submit pricing proposals for navigation systems in-service engineering services. It outlines labor categories, rates, overhead rates, and other cost elements for subcontractors to populate. The related federal contract opportunity seeks information on potential offerors interested in participating in an industry engagement in June 2018 regarding solicitation N65236-17-R-0008 for maritime position, navigation, and timing systems in-service engineering and technical support services for the Department of the Navy Information Warfare Systems Command. Responses will help determine the appropriate format for an industry engagement on this requirement.

View the file

Other files for this federal contract opportunity

Other files attached to Maritime Position, Navigation and Timing (PNT) Systems In-Service Engineering and Technical Support Services, newest first.
File Type Posted
Attachment 10 - DD FORM 254.pdf PDF
Attachment 3 - Resume Format.pdf PDF
Attachment 4 - Small Business Participation Data.pdf PDF
Attachment 7 - Small Business Subcontring Plan Matrix.xls XLS spreadsheet
Attachment 8 - Wage Determination.pdf PDF
Attachment 1B - Reference Info Sheet - Contract Specific Data.pdf PDF
Attachment 2B - Techincal Approach Labor Categories and Hours Estimate.xlsx XLSX spreadsheet
Attachment 6A - Prime Pricing Model.xlsx XLSX spreadsheet
Attachment 9 - QASP.pdf PDF
Attachment 2A - Technical Approach Factor SOO.pdf PDF
N6523617R0008_dated 01 May 2019.pdf PDF
Attachment 1A - Reference Info Sheet - Summary Data.pdf PDF
Pre-Solicitation QAs_PNT_posted 12 April 2019.pdf PDF
Attachment 5 - Past Performance.pdf PDF
Attendees List.pdf PDF
N65236-17-R-0008_(Revised Draft_PWS).pdf PDF
TAB 31 Industry Day Slides_31May18_v3 (002) WEB VERSION.pdf PDF
Industry _Engagement_Advertisement.docx DOCX document
Industry Day RFI.docx DOCX document
Show all 19

On GovTribe

Work with this file on GovTribe

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

Text version

Directions

GENERAL INSTRUCTIONS AND INFORMATION
RFP No. N6523617R0008
Title: Navigation Systems In-Service Engineering Services
Subcontractor Pricing Model Version 1.0 dated 24 Oct 2018
Contract Specialist: Lacey Flint, Telephone No. (843) 218-6142
Assumptions:
1.The Fringe Benefit allocation base is total labor dollars.
2.The Labor Overhead allocation base is total direct labor dollars PLUS associated fringe benefit.
3.The G&A allocation base is total cost input.
4.Facilities Capital Cost of Money is not incorporated.
5.Overtime for exempt personnel is based on a total time accounting concept. (Annual salary divided by total hours worked equals the hourly rate.)
6.Overtime for the Service Contract Standard labor categories is 1.5x the Straight Time Rate.
7.Fixed Fee is applied at the same percentage each year.
8.Performance will primarily be at Contractor and Government Sites in Norfolk, VA, and Contractor Sites in Groton, CT, and San Diego, CA.
9.Escalation for the SCLS labor categories is 2.0%
PRIME CONTRACTOR DIRECTIONS:
1.Fill in only those cells that are highlighted in blue:
a. Enter your company name at the top of the Summary sheet.
b. Populate the labor hour fields highlighted in blue for each subcontractor on the Labor Cost sheet.
2.Forward the appropriate Subcontractor Pricing Model to each subcontractor.
SUBCONTRACTOR DIRECTIONS:
1.If the assumptions above are valid, fill in only those cells that are highlighted in yellow:
a. Enter your company name at the top of the Summary sheet.
b. Enter escalation and indirect loading factors at the bottom of the Summary sheet, including allocation base data.
c. Provide the information requested on the Other Labor Data sheet if required.
d. Provide amounts for Additional ODCs on the Summary sheet, if required.
2.If above assumptions are not valid, modify appropriate formulas throughout the spreadsheets. Identify changes by highlighting all cells with changed formulas in YELLOW and explaining the reason for the changes in the space provided at the bottom of the Summary sheet.
8.Transmit entire Pricing Model file in EXCEL format (complete with active formulas) along with supporting narrative (pdf format) to the Government in accordance with RFP instructions.

&"Times New Roman,Regular"&F &"Times New Roman,Regular"&A &"Times New Roman,Regular"&P of &N

Summary

RFP No. N6523617R0008
Title: Navigation Systems In-Service Engineering Services
Contractor's Name:
Subcontractor's Name
Base YearTotal% of Hours
Labor Cost0.000.00
Labor Hours000.00%

Fringe Cost 0.00 0.00

Overhead Government Site - Norfolk0.000.00
Overhead Contractor Site - Norfolk0.000.00
Overhead Contractor Site - Groton0.000.00
Overhead Contractor Site - San Diego0.000.00
Total Overhead0.000.00

G&A on Labor 0.00 0.00

Total Labor 0.00 0.00

Additional ODCs 0.00 0.00

G&A on ODCs 0.00 0.00

Total ODCs 0.00 0.00

Total Costs0.000.00
Fixed Fee0.000.00
Total CPFF Costs0.000.00
Loading FactorsBase YearAllocation Base
Please Fill In
Labor Escalation - ProfessionalDirect Labor - Professional
Labor Escalation - SCLSDirect Labor - SCLS
Fringe Benefit0.00%
Overhead Government Site - Norfolk0.00%
Overhead Contractor Site - Norfolk0.00%
Overhead Contractor Site - Groton0.00%
Overhead Contractor Site - San Diego0.00%
G&A0.00%
Fixed Fee0.00%

CONTRACTOR CHANGES TO THE PRICING MODEL

&"Times New Roman,Bold"&16&A&"Times New Roman,Regular"&10

&"Times New Roman,Regular"&F &A&"Times New Roman,Regular"Source Selection Information
See FAR 2.101 and 3.104&"Times New Roman,Regular"&P of &N

Labor Cost RFP No. N6523617R0008

Base Year
Hours Per BaseLaborRates
Labor CategoryLocationSiteSTOTSTOTTotal Cost
Engineer/Scientist 2 (Computer)Norfolk, VirginiaGovernment00.000.00
Management Analyst 3Norfolk, VirginiaGovernment00.000.00
Management Analyst 2Norfolk, VirginiaGovernment00.000.00
Subject Matter Expert (SME) 1Norfolk, VirginiaGovernment00.000.00
Word Processor III (01613)Norfolk, VirginiaGovernment000.000.000.00
Warehouse Specialist (21410)Norfolk, VirginiaGovernment000.000.000.00
Electronics Technician Maintenance II (23182)Norfolk, VirginiaGovernment000.000.000.00
Engineering Technician III (30083)Norfolk, VirginiaGovernment000.000.000.00
Program ManagerNorfolk, VirginiaContractor00.000.00
Engineer/Scientist 5Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 4 (Computer)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 4 (Electronics)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 4 (Mechanical)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 3 (Computer)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 3 (Electronics)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 3 (Mechanical)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 2 (Computer)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 2 (Electronics)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 2 (Mechanical)Norfolk, VirginiaContractor00.000.00
Engineer/Scientist 1Norfolk, VirginiaContractor00.000.00
Logistician 3Norfolk, VirginiaContractor00.000.00
Logistician 2Norfolk, VirginiaContractor00.000.00
Management Analyst 3Norfolk, VirginiaContractor00.000.00
Management Analyst 2Norfolk, VirginiaContractor00.000.00
Security Specialist 2Norfolk, VirginiaContractor00.000.00
Training Specialist 1Norfolk, VirginiaContractor00.000.00
Technical Writer/Editor 2Norfolk, VirginiaContractor00.000.00
Subject Matter Expert (SME) 3Norfolk, VirginiaContractor00.000.00
Subject Matter Expert (SME) 1Norfolk, VirginiaContractor00.000.00
Supply Technician (01410)Norfolk, VirginiaContractor000.000.000.00
Word Processor I (01611)Norfolk, VirginiaContractor000.000.000.00
Word Processor II (01612)Norfolk, VirginiaContractor000.000.000.00
Word Processor III (01613)Norfolk, VirginiaContractor000.000.000.00
Computer Programmer II (14072)Norfolk, VirginiaContractor000.000.000.00
Computer Programmer III (14073)Norfolk, VirginiaContractor000.000.000.00
Computer Programmer IV (14074)Norfolk, VirginiaContractor000.000.000.00
Computer Systems Analyst I (14101)Norfolk, VirginiaContractor000.000.000.00
Computer Systems Analyst III (14103)Norfolk, VirginiaContractor000.000.000.00
Computer Based Training Specialist / Instructor (15050)Norfolk, VirginiaContractor000.000.000.00
Warehouse Specialist (21410)Norfolk, VirginiaContractor000.000.000.00
Electronics Technician Maintenance I (23181)Norfolk, VirginiaContractor000.000.000.00
Electronics Technician Maintenance II (23182)Norfolk, VirginiaContractor000.000.000.00
Electronics Technician Maintenance III (23183)Norfolk, VirginiaContractor000.000.000.00
Machinist, Maintenance (23550)Norfolk, VirginiaContractor000.000.000.00
Drafter/CAD Operator IV (30064)Norfolk, VirginiaContractor000.000.000.00
Engineering Technician I (30081)Norfolk, VirginiaContractor000.000.000.00
Engineering Technician II (30082)Norfolk, VirginiaContractor000.000.000.00
Engineering Technician III (30083)Norfolk, VirginiaContractor000.000.000.00
Engineering Technician IV (30084)Norfolk, VirginiaContractor000.000.000.00
Engineering Technician V (30085)Norfolk, VirginiaContractor000.000.000.00
Engineering Technician VI (30086)Norfolk, VirginiaContractor000.000.000.00
Subject Matter Expert (SME) 3Groton, ConnecticutContractor00.000.00
Subject Matter Expert (SME) 3San Diego, CaliforniaContractor00.000.00

Total Hours & Cost/YR 0 0.00

TOTAL ALL YEARS
Direct Labor Government Site - Norfolk0.00
Direct Labor Contractor Site - Norfolk0.00
Direct Labor Contractor Site - Groton0.00
Direct Labor Contractor Site - San Diego0.00
Fringe Government Site - Norfolk0.00
Fringe Contractor Site - Norfolk0.00
Fringe Contractor Site - Groton0.00
Fringe Contractor Site - San Diego0.00
Overhead Government Site - Norfolk0.00
Overhead Contractor Site - Norfolk0.00
Overhead Contractor Site - Groton0.00
Overhead Contractor Site - San Diego0.00
G&A0.00
Total Prime Labor Cost0.00

&"Times New Roman,Bold"&14&A

&"Times New Roman,Regular"&F

&A&"Times New Roman,Regular"Source Selection Information
See FAR 2.101 and 3.104&"Times New Roman,Regular"&P of &N

Rates RFP No. N6523617R0008 Please do not delete any rows from this sheet

Base Year
LaborFringeOHG&ATotalTotal
Labor CategoryLocationSiteRateCostCostCostSTOT
Engineer/Scientist 2 (Computer)Norfolk, VirginiaGovernment0.000.000.000.000.00
Management Analyst 3Norfolk, VirginiaGovernment0.000.000.000.000.00
Management Analyst 2Norfolk, VirginiaGovernment0.000.000.000.000.00
Subject Matter Expert (SME) 1Norfolk, VirginiaGovernment0.000.000.000.000.00
Word Processor III (01613)Norfolk, VirginiaGovernment0.000.000.000.000.000.00
Warehouse Specialist (21410)Norfolk, VirginiaGovernment0.000.000.000.000.000.00
Electronics Technician Maintenance II (23182)Norfolk, VirginiaGovernment0.000.000.000.000.000.00
Engineering Technician III (30083)Norfolk, VirginiaGovernment0.000.000.000.000.000.00
Program ManagerNorfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 5Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 4 (Computer)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 4 (Electronics)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 4 (Mechanical)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 3 (Computer)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 3 (Electronics)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 3 (Mechanical)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 2 (Computer)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 2 (Electronics)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 2 (Mechanical)Norfolk, VirginiaContractor0.000.000.000.000.00
Engineer/Scientist 1Norfolk, VirginiaContractor0.000.000.000.000.00
Logistician 3Norfolk, VirginiaContractor0.000.000.000.000.00
Logistician 2Norfolk, VirginiaContractor0.000.000.000.000.00
Management Analyst 3Norfolk, VirginiaContractor0.000.000.000.000.00
Management Analyst 2Norfolk, VirginiaContractor0.000.000.000.000.00
Security Specialist 2Norfolk, VirginiaContractor0.000.000.000.000.00
Training Specialist 1Norfolk, VirginiaContractor0.000.000.000.000.00
Technical Writer/Editor 2Norfolk, VirginiaContractor0.000.000.000.000.00
Subject Matter Expert (SME) 3Norfolk, VirginiaContractor0.000.000.000.000.000.00
Subject Matter Expert (SME) 1Norfolk, VirginiaContractor0.000.000.000.000.000.00
Supply Technician (01410)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Word Processor I (01611)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Word Processor II (01612)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Word Processor III (01613)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Computer Programmer II (14072)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Computer Programmer III (14073)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Computer Programmer IV (14074)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Computer Systems Analyst I (14101)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Computer Systems Analyst III (14103)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Computer Based Training Specialist / Instructor (15050)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Warehouse Specialist (21410)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Electronics Technician Maintenance I (23181)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Electronics Technician Maintenance II (23182)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Electronics Technician Maintenance III (23183)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Machinist, Maintenance (23550)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Drafter/CAD Operator IV (30064)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Engineering Technician I (30081)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Engineering Technician II (30082)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Engineering Technician III (30083)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Engineering Technician IV (30084)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Engineering Technician V (30085)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Engineering Technician VI (30086)Norfolk, VirginiaContractor0.000.000.000.000.000.00
Subject Matter Expert (SME) 3Groton, ConnecticutContractor0.000.000.000.000.00
Subject Matter Expert (SME) 3San Diego, CaliforniaContractor0.000.000.000.000.00

&"Times New Roman,Bold"&16&A

&A

&"Times New Roman,Bold"Source Selection Information
See FAR 2.101 and 3.104&"Times New Roman,Regular"&P of &N

Other Labor Data

RFP No. N6523617R0008
UNCOMPENSATED OVERTIME CALCULATION
Note: Complete this section ONLY if proposed rates are calculated using other than 2,080 hours per year.
NOTE: All Offerors are to map their company labor categories to include labor category nomenclature, education, and experience as part of 52.215-20 Alt IV requirements.
Base Year Labor Rates
LaborAdjusted HourlyEffective
Professional CategoriesLabor Category NomenclatureDegree/EducationYears of ExperiencePosition DescriptionRate (1)Rate (2)Hours (3)
Program Manager
Engineer/Scientist 5
Engineer/Scientist 4 (Computer)
Engineer/Scientist 4 (Electronics)
Engineer/Scientist 4 (Mechanical)
Engineer/Scientist 3 (Computer)
Engineer/Scientist 3 (Electronics)
Engineer/Scientist 3 (Mechanical)
Engineer/Scienist 2 (Computer)
Engineer/Scienist 2 (Electronics)
Engineer/Scienist 2 (Mechanical)
Engineer/Scientist 1
Management Analyst 3
Management Analyst 2
Logistician 3
Logistician 2
Security Specialist 2
Training Specialist 1
Technical Editor/Writer 2
Subject Matter Expert 3
Subject Matter Expert 1
SCLS CategoriesSCLS #(1) Labor Rate is annual salary divided by 2,080 hours.
Word Processor I01611
Word Processor II01612(2) Adjusted Hourly Rate is annual salary divided by total hours
Word Processor III01613recorded.
Supply Technician01410
Warehouse Specialist21410(3) Effective Hours are the total hours recorded,
Electronics Technician Maintenance I23181including leave.
Electronics Technician Maintenance II23182
Electronics Technician Maintance III23183Was Uncompensated Overtime used to calculate the
Drafter/CAD Operator IV30064professional labor rates? (Yes/No)
Engineering Technician I30081
Engineering Technician III30082
Engineering Technician III30083
Engineering Technician IV30084
Engineering Technician V30085
Engineering Technician VI30086
Computer Programmer II14072
Computer Programmer III14073
Computer Programmer IV14074
Computer Systems Analyst I14101
Computer Systems Analyst III14103
Computer Based Training Speclialist/Instructor15050
Machinist Maintenance23550

&"Times New Roman,Bold"&14&A

&A &"Times New Roman,Regular"Source Selection Information See FAR 2.101 and 3.104

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