Attachment 5B Sub Pricing Model_15R0005_rev_amd2.xlsx

XLSX spreadsheet 64 KB Posted

Attached to
Tagging, Tracking, and Locating (TTL) Equipment and Support Services
Solicitation number
N65236-15-R-0005
Issued by

View the file

Other files

File Type Posted
Attachment 4_15R0005.docx DOCX document
RFP N65236-15-R-0005_Final.pdf PDF
Attachment 3_15R0005.docx DOCX document
Attachment 1A_15R0005.docx DOCX document
Attachment 6_QASP_15R0005.pdf PDF
Attachment 1B_15R0005.docx DOCX document
SOL Questions_Answers_15R0005_26July.pdf PDF
Amendment 0002_15R0005.pdf PDF
Attachment 7_DD254_15-R-0005.pdf PDF
Amendment 0001_15R0005.pdf PDF
Attachment 5A Prime Pricing Model_15R0005_rev_amd1.xlsx XLSX spreadsheet
Attachment 8 - Wage Determination.pdf PDF
Attachment 2_15R0005.docx DOCX document
Exhibit A CDRLS_15R0005.pdf PDF
Amendment 0002_15R0005.pdf PDF
Attachment 2_15R0005.docx DOCX document
SOL Questions_Answers_15R0005_26July.pdf PDF
Attachment 7_DD254_15-R-0005.pdf PDF
Exhibit A CDRLS_15R0005.pdf PDF
Attachment 8 - Wage Determination.pdf PDF
Attachment 3_15R0005.docx DOCX document
Attachment 6_QASP_15R0005.pdf PDF
Attachment 1B_15R0005.docx DOCX document
Attachment 1A_15R0005.docx DOCX document
Attachment 5A Prime Pricing Model_15R0005_rev_amd1.xlsx XLSX spreadsheet
RFP N65236-15-R-0005_Final.pdf PDF
Amendment 0001_15R0005.pdf PDF
Attachment 5B Sub Pricing Model_15R0005_rev_amd2.xlsx XLSX spreadsheet
Attachment 4_15R0005.docx DOCX document
Show all 29

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

Directions

GENERAL INSTRUCTIONS AND INFORMATION
RFP N65236-15-R-0005
Title: Tagging, Tracking, and Locating Equipment and Services
Subcontractor Pricing Model Version 1.2 dtd 07-20-16
Contract Specialist: Adam Solivan (843) 218-3556
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.The Service Contract Labor Standards categories are subject to the applicable Wage Determinations for that area.
7.In accordance with 29 C.F.R 541, Computer IT labor category rates not identified on the Wage Determination shall be paid a minimum of $27.63.
8.Performance is anticipated to be at the Contractor Site in Tampa, FL.
9.Additional ODCs are subject to G&A.
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 (see #3 below).
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.

3 If direct labor rates are calculated by using other than 2,080 hours per year, list the number of hours per year used to calculate the hourly rate for each category of labor on the 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-15-R-0005
Title: Tagging, Tracking, and Locating Equipment and Services
Contractor's Name:
Subcontractor's Name
Year 1Year 2Year 3Year 4Year 5Total% of Hours
Labor Cost0.000.000.000.000.000.00
Labor Hours0000000.00%

Fringe Benefits 0.00 0.00 0.00 0.00 0.00 0.00

Overhead - Contractor Site - Tampa, FL 0.00 0.00 0.00 0.00 0.00 0.00

Total Combined Labor Costs (Less G&A) 0.00 0.00 0.00 0.00 0.00 0.00

Additional ODCs 0.00 0.00 0.00 0.00 0.00 0.00

G&A 0.00 0.00 0.00 0.00 0.00 0.00

Total Costs 0.00 0.00 0.00 0.00 0.00 0.00

Fixed Fee 0.00 0.00 0.00 0.00 0.00 0.00

Total Cost Plus Fixed Fee 0.00 0.00 0.00 0.00 0.00 0.00

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 - SCLS2.00%2.00%2.00%2.00%Direct Labor - SCLS
Fringe Benefit0.00%0.00%0.00%0.00%0.00%
Overhead - Contractor Site - Tampa, FL0.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-15-R-0005

Tampa, FLYear 1Year 2Year 3Year 4Year 5
Contractor SiteHours Per YearLabor RatesLabor RatesLabor RatesLabor RatesLabor Rates
Professional CategoriesSTSTTotal CostSTTotal CostSTTotal CostSTTotal CostSTTotal Cost
Program Manager (Resume)00.000.000.000.000.000.000.000.000.000.00
Program Manager00.000.000.000.000.000.000.000.000.000.00
Project Manager (Resume 1)00.000.000.000.000.000.000.000.000.000.00
Project Manager (Resume 2)00.000.000.000.000.000.000.000.000.000.00
Project Manager00.000.000.000.000.000.000.000.000.000.00
Engineer/Scientist 3 - General00.000.000.000.000.000.000.000.000.000.00
Engineer/Scientist 3 - Systems/Software Engineer00.000.000.000.000.000.000.000.000.000.00
Engineer/Scientist 2 - Network Engineer00.000.000.000.000.000.000.000.000.000.00
Management Analyst 3 (Resume 1)00.000.000.000.000.000.000.000.000.000.00
Management Analyst 3 (Resume 2)00.000.000.000.000.000.000.000.000.000.00
Management Analyst 300.000.000.000.000.000.000.000.000.000.00
Technical Analyst 300.000.000.000.000.000.000.000.000.000.00
Technical Writer/Editor 300.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 5 (Resume 1)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 5 (Resume 2)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 500.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 4 (Resume 1)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 4 (Resume 2)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 4 (Resume 3)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 400.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 3 (Resume 1)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 3 (Resume 2)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 3 (Resume 3)00.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 300.000.000.000.000.000.000.000.000.000.00
Management & Program Technician 300.000.000.000.000.000.000.000.000.000.00
SCA Categories
Administrative Assistant00.000.000.000.000.000.000.000.000.000.00
Supply Technician00.000.000.000.000.000.000.000.000.000.00
Computer Systems Analyst III00.000.000.000.000.000.000.000.000.000.00
Technical Instructor00.000.000.000.000.000.000.000.000.000.00
Technical Instructor/Course Developer (Resume 1)00.000.000.000.000.000.000.000.000.000.00
Technical Instructor/Course Developer (Resume 2)00.000.000.000.000.000.000.000.000.000.00
Technical Instructor/Course Developer00.000.000.000.000.000.000.000.000.000.00
Shipping & Receiving Clerk00.000.000.000.000.000.000.000.000.000.00
Warehouse Specialist00.000.000.000.000.000.000.000.000.000.00

Total Hours & Cost 0 0.00 0.00 0.00 0.00 0.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

Burdened Rates

RFP N65236-15-R-0005
Please do not delete any rows from this sheet
Tampa, FLYear 1Year 2Year 3Year 4Year 5
Contractor SiteLaborFringeOHG&ATotalLaborFringeOHG&ATotalLaborFringeOHG&ATotalLaborFringeOHG&ATotalLaborFringeOHG&ATotal
Professional CategoriesRateCostCostCostSTRateCostCostCostSTRateCostCostCostSTRateCostCostCostSTRateCostCostCostST
Program Manager (Resume)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Program Manager0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Project Manager (Resume 1)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Project Manager (Resume 2)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Project Manager0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Engineer/Scientist 3 - General0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Engineer/Scientist 3 - Systems/Software Engineer0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Engineer/Scientist 2 - Network Engineer0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Management Analyst 3 (Resume 1)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Management Analyst 3 (Resume 2)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Management Analyst 30.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Technical Analyst 30.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Technical Writer/Editor 30.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 5 (Resume 1)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 5 (Resume 2)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 50.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 4 (Resume 1)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 4 (Resume 2)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 4 (Resume 3)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 40.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 3 (Resume 1)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 3 (Resume 2)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 3 (Resume 3)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Subject Matter Expert (SME) 30.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Management & Program Technician 30.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
SCA Categories
Administrative Assistant0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Supply Technician0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Computer Systems Analyst III0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Technical Instructor0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Technical Instructor/Course Developer (Resume 1)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Technical Instructor/Course Developer (Resume 2)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Technical Instructor/Course Developer0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Shipping & Receiving Clerk0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Warehouse Specialist0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.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 N65236-15-R-0005
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 fromYear 1 Labor Rates
those specified in the RFP.LaborAdjusted HourlyEffective
Professional CategoriesOfferor's Labor CategoriesRate (1)Rate (2)Hours (3)
Program Manager (Resume)
Program Manager
Project Manager (Resume 1)
Project Manager (Resume 2)
Project Manager
Engineer/Scientist 3 - General
Engineer/Scientist 3 - Systems/Software Engineer
Engineer/Scientist 2 - Network Engineer
Management Analyst 3 (Resume 1)
Management Analyst 3 (Resume 2)
Management Analyst 3
Technical Analyst 3
Technical Writer/Editor 3
Subject Matter Expert (SME) 5 (Resume 1)
Subject Matter Expert (SME) 5 (Resume 2)
Subject Matter Expert (SME) 5
Subject Matter Expert (SME) 4 (Resume 1)
Subject Matter Expert (SME) 4 (Resume 2)
Subject Matter Expert (SME) 4 (Resume 3)
Subject Matter Expert (SME) 4
Subject Matter Expert (SME) 3 (Resume 1)
Subject Matter Expert (SME) 3 (Resume 2)
Subject Matter Expert (SME) 3 (Resume 3)
Subject Matter Expert (SME) 3
Management & Program Technician 3

(1) labor Rate is annual salary divided by 2,080 hours.

(2) Adjsuted Hourly Rate is annual salary divided by total hours
recorded.
(3) Effective Hours are the total hours recorded,
including leave.
Was Uncompensated Overtime used to calculate the
professional labor rates? (Yes/No)
Uncompensated Overtime Policy
SCA CategoriesSCA #Offeror's Labor Categories
Administrative Assistant01020
Supply Technician01410
Computer Systems Analyst III14103
Technical Instructor15090
Technical Instructor/Course Developer (Resume 1)15095
Technical Instructor/Course Developer (Resume 2)15095
Technical Instructor/Course Developer15095
Shipping & Receiving Clerk21130
Warehouse Specialist21410

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