ATTACHMENT 4B Subcontract Rate Sheet COST V1.1.xlsx

XLSX spreadsheet 109 KB Posted

Attached to
Development, Technical, Management, and Engineering Services for Intelligence, Surveillance, and Reconnaissance Systems Federal contract opportunity
Solicitation number
N66001-17-R-0494
Issued by
Department of the Navy Information Warfare Systems Command

View the file

Other files for this federal contract opportunity

Other files attached to Development, Technical, Management, and Engineering Services for Intelligence, Surveillance, and Reconnaissance Systems, newest first.
File Type Posted
Questions and Answers3- N6600117R0494.pdf PDF
Attachment 5 - Desired Personnel QualificationsA0001.pdf PDF
Attachment 6 Organizational Experience Matrix.doc DOC document
Questions and Answers N6600117R0494.pdf PDF
Attachment 9 Small Business Participation.docx DOCX document
Attachment 3 WD 04-0047 Rev 14.pdf PDF
Attachment 8 Past Performance Questionaire.doc DOC document
N6600117R0494 Amendment 0001.pdf PDF
Attachment 4A Prime Rate Sheet V1.1.xlsx XLSX spreadsheet
N6600117R0494 Amendment 0002.pdf PDF
Attachment 7 - Reference Information Sheet.docx DOCX document
N66001-17-R-0494.pdf PDF
Attachment 2 WD-15-5365 Rev 6.pdf PDF
Question and Answer-2- N6600117R0494.pdf PDF
Show all 14

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 N65236-17-R-0494
Title:
SUBCONTRACTOR Pricing Model v1.1
Contract Specialist: Tiffany Boatwright
Assumptions:
1.The Fringe Benefit allocation base is total labor dollars.
2.The Labor Overhead allocation base = total direct labor dollars + 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 / total hours worked = hourly rate.)
6The Service Contract Labor Standards categories are subject to the applicable Wage Determinations for that area.
7Performance is anticipated to be at Contractor and Government Sites in San Diego, CA.
8Fixed Fee is applied to total labor costs only and at the same percentage each year.
9Contractor must identify if their site is in a location other than San Diego, CA
10Additional ODCs are subject to G&A.
PRIME CONTRACTOR DIRECTIONS:
1.Populate ONLY cells that are highlighted blue:
a. Enter Prime Contractor name on Summary sheet.
b. Populate the number of labor hours assigned to subcontractor on Labor Cost sheet.
2.Forward appropriate Subcontractor Pricing Model to subcontractor.
SUBCONTRACTOR DIRECTIONS:
1.If the assumptions above are valid, populate ONLY cells that are highlighted yellow:
a. Enter subcontractor name on Summary sheet.
b. Enter escalation and indirect loading factors on Summary sheet, including allocation base data.
c. Provide amounts for Additional ODCs on Summary sheet, if required.
d. Provide rates for labor categories on Burdened Rates sheet.
e. If applicable, provide information requested on the Other Labor Data sheet (see #3 below).
2.If above assumptions are not valid, modify appropriate formulas throughout the workbook. Identify changes by highlighting all cells with changed formulas in YELLOW and detail the reason for the change in the space provided on Summary sheet.
3.If direct labor rates are calculated by using other than 2,080 hours per year, document number of hours per year used to calculate hourly rate for each labor category on Other Labor Data sheet.
4.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 N65236-17-R-0494
Title:
Prime Contractor:
Subcontractor:
LaborYear 1Year 2Year 3Year 4Year 5Total% of Hours
Labor Cost:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Hours-0-0-0-0-00.00%
Fringe Benefits:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
- OH / Contractor Site / San Diego, CA:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
- OH / Gov't Site / San Diego, CA:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL LABOR COSTS (excluding G&A) SUBTOTAL:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Additional ODCs:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL COST (LABOR + ODCs + G&A):$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fixed Fee:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL CPFF:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Loading FactorsYear 1Year 2Year 3Year 4Year 5Allocation Base
Please Fill In
Labor Escalation - Professional0.00%0.00%0.00%0.00%Direct Labor - Professional
Labor Escalation - SCA2.00%2.00%2.00%2.00%Direct Labor - SCA
Fringe Benefit0.00%0.00%0.00%0.00%0.00%
- OH / Contractor Site / San Diego, CA:0.00%0.00%0.00%0.00%0.00%
- OH / Gov't Site / San Diego, CA:0.00%0.00%0.00%0.00%0.00%
G&A0.00%0.00%0.00%0.00%0.00%
Fixed Fee0.00%0.00%0.00%0.00%0.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 N65236-17-R-0494
Prime Contractor:
Subcontractor:
San Diego, CACONTRACT YEARS 1-5Year 1Year 2Year 3Year 4Year 5
GOVERNMENT SITEHrs / YearLabor RatesLabor RatesLabor RatesLabor RatesLabor Rates
PROFESSIONAL CATEGORIESSTOTSTOTTotal CostSTOTTotal CostSTOTTotal CostSTOTTotal CostSTOTTotal Cost
Program Manager-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Engineer/Scientist 1-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Engineer/Scientist 5-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Logistician 1-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Logistician 5-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Training Specialist 1-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Training Specialist 4-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Management and Program Technician 2-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Special Equipment Operator-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
Small Boat Operator-0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0$ - 0$ -0
PROFESSIONAL CATEGORIES SUBTOTAL:-0$ - 0$ - 0$ - 0$ - 0$ - 0
SCA CATEGORIES
Engineering Technician III (SCA 30083)-0-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Engineering Technician VI (SCA 30086)-0-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Diver (SCA 47040)-0-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Small Boat Operator-0-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
SCA CATEGORIES SUBTOTAL:-0$ - 0$ - 0$ - 0$ - 0$ - 0
LABOR / GOVERNMENT SITE / San Diego, CA:$ - 0$ - 0$ - 0$ - 0$ - 0
FRINGE / GOVERNMENT SITE / San Diego, CA:$ - 0$ - 0$ - 0$ - 0$ - 0
OH / CGOVERNMENT SITE / San Diego, CA:$ - 0$ - 0$ - 0$ - 0$ - 0
San Diego, CAYear 1Year 2Year 3Year 4Year 5
CONTRACTOR SITEHrs / YearLabor RatesLabor RatesLabor RatesLabor RatesLabor Rates
PROFESSIONAL CATEGORIESSTOTSTOTTotal CostSTOTTotal CostSTOTTotal CostSTOTTotal CostSTOTTotal Cost
Program Manager-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Engineer/Scientist 1-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Engineer/Scientist 5-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Logistician 1-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Logistician 5-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Training Specialist 1-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Training Specialist 4-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Management and Program Technician 2-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Special Equipment Operator-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Small Boat Operator-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
PROFESSIONAL CATEGORIES SUBTOTAL:-0$ - 0$ - 0$ - 0$ - 0$ - 0
SCA CATEGORIES
Engineering Technician III (SCA 30083)-0-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Engineering Technician VI (SCA 30086)-0-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
Diver (SCA 47040)-0-0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0$ -0
SCA CATEGORIES SUBTOTAL:-0$ -0$ -0$ -0$ -0$ -0
LABOR / CONTRACTOR SITE / San Diego, CA:$ -0$ -0$ -0$ -0$ -0
FRINGE / CONTRACTOR SITE / San Diego, CA:$ -0$ -0$ -0$ -0$ -0
OH / CONTRACTOR SITE / San Diego, CA:$ -0$ -0$ -0$ -0$ -0
GRAND TOTAL UNBURDENED LABOR:$ -0$ -0$ -0$ -0$ -0
GRAND TOTAL FRINGE:$ -0$ -0$ -0$ -0$ -0
GRAND TOTAL OH GOVERNMENT SITE:$ -0$ -0$ -0$ -0$ -0
GRAND TOTAL OH CONTRACTOR SITE:$ -0$ -0$ -0$ -0$ -0
GRAND TOTAL BURDENED LABOR COST:$ - 0$ - 0$ - 0$ - 0$ - 0

&"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

Burdened Rates

RFP N65236-17-R-0494Do not delete any rows or columns from this sheet
Prime Contractor:
Subcontractor:
San Diego, CAYear 1Year 2Year 3Year 4Year 5
GOVERNMENT SITELabor RateFringe CostOH CostG&A CostTotal STTotal OTLabor RateFringe CostOH CostG&A CostTotal STTotal OTLabor RateFringe CostOH CostG&A CostTotal STTotal OTLabor RateFringe CostOH CostG&A CostTotal STTotal OTLabor RateFringe CostOH CostG&A CostTotal STTotal OT
Professional Categories
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer/Scientist 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer/Scientist 5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistician 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistician 5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training Specialist 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training Specialist 4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Management and Program Technician 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Special Equipment Operator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Small Boat Operator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SCA Categories
Engineering Technician III (SCA 30083)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Technician VI (SCA 30086)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Diver (SCA 47040)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
San Diego, CAYear 1Year 2Year 3Year 4Year 5
CONTRACTOR SITELaborFringeOHG&ATotalTotalLaborFringeOHG&ATotalTotalLaborFringeOHG&ATotalTotalLaborFringeOHG&ATotalTotalLaborFringeOHG&ATotalTotal
Professional CategoriesRateCostCostCostSTOTRateCostCostCostSTOTRateCostCostCostSTOTRateCostCostCostSTOTRateCostCostCostSTOT
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer/Scientist 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer/Scientist 5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistician 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Logistician 5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training Specialist 1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training Specialist 4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Management and Program Technician 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Special Equipment Operator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Small Boat Operator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SCA Categories
Engineering Technician III (SCA 30083)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Technician VI (SCA 30086)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Diver (SCA 47040)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

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

&"Times New Roman,Regular"&F &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 N65236-17-R-0494
Prime Contractor:
Subcontractor:
UNCOMPENSATED OVERTIME CALCULATION
Note: Complete this section ONLY if proposed rates are calculated using other than 2,080 hours per year.
Note: Complete this section ONLY if company job titles are different from those specified in the RFP.Year 1 Labor Rates
Base Rate (1)Effective Rate (2)Effective Hrs (3)
PROFESSIONALOfferor's Labor Categories
Program Manager
Engineer/Scientist 1
Engineer/Scientist 5
Logistician 1
Logistician 5
Training Specialist 1
Training Specialist 4
Management and Program Technician 2
Special Equipment Operator
Small Boat Operator
(1) Base Rate = annual salary / 2,080 hours
(2) Effective Rate = annual salary / total hrs recorded.
(3) Effective Hrs are total hours recorded, including leave.
Was Uncompensated Overtime used to calculate the professional labor rates? (Yes/No)

Uncompensated Overtime Policy

SCA CategoriesOfferor's Labor Categories
Engineering Technician III (SCA 30083)
Engineering Technician VI (SCA 30086)
Diver (SCA 47040)

&"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 boolean

yes
no

File details come from the government source that posted it.