Amend 3 - RFP Attach 4A (Rev 2) - Prime Pricing Model.xlsx

XLSX spreadsheet 86 KB Posted

Attached to
ADVANCED ANALYTICS TECHNICAL SOLUTION (AATS)
Solicitation number
N65236-16-R-0001
Issued by

View the file

Other files

File Type Posted
(Pre-Solic) 20161205 - Industry Day - Pre-Solic Conference Slides.pptx PPTX presentation
Amendment 0002 (As Issued).pdf PDF
Amend 2 - RFP Attach 16 - AATS Ontology Sample (Zip).zip ZIP file
RFP Attach 7 - PWS Section 3.2 Compliance Cklist.xlsx XLSX spreadsheet
Amend 2 - RFP Attach 14 (Rev) - Cross Ref CLIN to PWS Section.docx DOCX document
(Pre-Solic) 20161128 - Draft Solicitation.pdf PDF
RFP Attach 8 - AATS Software Ftnality in DIL Environ.xlsx XLSX spreadsheet
RFP Attach 10 - DD254 - Contr Security Classific Spec.pdf PDF
(Pre-Solic) 20161208 - Pre-Solic Conf Attendees.docx DOCX document
(Pre-Solic) 20170403 - Revised Draft Solicitation.docx.mcgn5pg.partial —
(Pre-Solic) 20170217 - Draft Solic Q&A Update.docx DOCX document
RFP Attach 3 - Small Business Participation Data.pdf PDF
(Pre-Solic) 20170412 - Draft Solic Q&A Update.docx DOCX document
20170503 - Solicitation Q&As for Posting.docx DOCX document
RFP Attach 5 - Small Bus Subcontr Plan Matrix.xls XLS spreadsheet
(Pre-Solic) 20161011 - Revised Pre-Solic Notice Q&As.docx DOCX document
RFP Attach 12 - Wage Determination.pdf PDF
(Pre-Solic) 20161128 - Draft - Solic Attach 8.xlsx XLSX spreadsheet
RFP Attach 13 - Delivery Order 0001 Statement of Work.pdf PDF
(Pre-Solic) 20161116 - Pre-Solic Conference Agenda.docx DOCX document
RFP Attach 11 - Quality Assurance SurveillancePlan.pdf PDF
(Pre-Solic) 20161128 - Draft - Solic Attach 7.xlsx XLSX spreadsheet
Amend 2 - RFP Attach 2 (Rev) - Past Perform Quest (Word Format).docx DOCX document
(Pre-Solic) 20161116 - Special Notice - Pre-Solicitation Conference.pdf PDF
20170505 - Updated Solicitation Q&As (#10 - #18).docx DOCX document
RFP Attach 15 - Software Licensing Disclosure.pdf PDF
(Pre-Solic) Draft of RFP Attach 6 - IAS Hardware and Software Info.xlsx XLSX spreadsheet
20170511 - Updated Solicitation QAs (#19 - #55).docx DOCX document
Amendment 0001 (As Issued).pdf PDF
Amendment 0003 (As Issued).pdf PDF
Amend 3 - RFP Exhib A (Rev 2) - CDRLs.pdf PDF
(Pre-Solic) 20161128 - Draft Solic Attach 9.xlsx XLSX spreadsheet
RFP Attach 2 - Past Performance Questionnaire.pdf PDF
RFP Attach 6 - IAS Hardware and Software Info.xlsx XLSX spreadsheet
RFP Attach 1B - Ref Info Sheet - Contract Specific Data.pdf PDF
(Pre-Solic) Supplies and Svcs - Graphic.docx DOCX document
RFP N65236-16-R-0001 - As Issued.pdf PDF
(Pre-Solic) 20170404 - Draft Solic of 3 April 2017 - Q&A Update.docx DOCX document
RFP Attach 9 - AATS Software Capabil Matrix.xlsx XLSX spreadsheet
RFP Attach 1A - Ref Info Sheet - Summary Data.pdf PDF
Amend 3 - RFP Attach 4B (Rev 2) - Sub Pricing Model.xlsx XLSX spreadsheet
Show all 41

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-16-R-0001
Title: Advanced Analytics Technical Solutions
Prime Pricing Model Version 3.1 dated 05-18-2017
Contract Specialist: Calvin Howard, Telephone (843) 218-5941
Assumptions:
1.Profit is applied at the same percentage each year and is not applicable to ODCs (CLIN 0012).
2.Additional ODCs are subject to G&A.
3.CLIN 0004 has hours assigned for each year. Do not deviate from the hours in the pricing model.
4.CLIN 0009 has hours assigned in Years 2, 3, 4, and 5 only. Do not deviate from the hours in the pricing model.
5.CLINS 0001, 0002, 0003, 0005, 0006, 0007, and 0008, 0011, and 0012 are Firm Fixed Price CLINS. The Prime Contractor shall propose the total contract cost for these CLINS.
6.Performance is anticipated to be at the Government Sites in Charleston, SC and the Contractor Sites in Washington, DC.
7.Delivery Order 0001 will be awarded at time of the Contract Award for CLINS 0001, 0002, and 0003. Offerors are to bid their costs for that order on the Summary Tab.
Directions:
1.If the assumptions are valid, fill in only those cells highlighted in yellow, beginning with the company name at the top of the Summary sheet.
2.If the assumptions are not valid, modify appropriate formulas throughout the spreadsheet. Identify changes by highlighting all cells with changed formulas in YELLOW, describing the changes as well as the reasons for those 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 on the Other Labor Data sheet.
4.If company job titles are different from those in the RFP, provide this information on the Other Labor Data sheet.
5.Complete the YELLOW tabs entitled Benefit Summary and Salary Data for the prime only. Completion of this spreadsheet is mandatory, and when properly completed satisfies the requirement for the Professional Employee Compensation Plan. No additional information is required, but supplementary data may be provided, if desired.
this amount.
Helpful Hints and Reminders:
1.Notify the contract negotiator if you have any questions or problems relating to this pricing model.
2.Use the checklist provided below to ensure your proposal is complete.
Pricing Model Checklist
√Have the following been completed?
Your company name is entered on the Summary Sheet.
If your rates/categories differ from the model, the differences are explained on the Other Labor Data sheet.
Indirect rates are provided on the Summary sheet for each year.
Allocation base information is provided in the indirect rate section at the bottom of the Summary sheet.
If the pricing model formulas for applying the indirect rates are not consistent with your company accounting practices,
the appropriate formulas have been modified,
the changed cells are highlighted in yellow, and
the changes are explained at the bottom of the Summary sheet.
Subcontractor names are provided on the Team Hours sheet.
Hours assigned to each subcontractor are shown on the Team Hours sheet.
Subcontractor names are on the Summary sheet, in the same order they appear on the Team Hours sheet.
Subcontractor pricing models were prepared and sent to the proposed subcontractors for completion.
The subcontractors' proposed costs for each year (based on the subs' responses) are entered on the Summary sheet.
Proposed Additional ODCs for both the prime contractor and subcontractors are included on the Summary sheet.
Benefits Summary and Salary sheets are completed by the Prime Contractor.

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

Summary

RFP: N65236-16-R-0001
Title: Advanced Analytics Technical Solutions

Contractor's Name:

LaborYear 1Year 2Year 3Year 4Year 5Total% of Hours
Prime Labor Cost (CLIN 0004)$0.00$0.00$0.00$0.00$0.00$0.00
Labor Hours14,5001,7545,3541,5145,35428,47645.59%
Prime Labor Cost (CLIN 0009)$0.00$0.00$0.00$0.00$0.00$0.00
Labor Hours08,4968,4968,4968,49633,98454.41%
Subcontractor Labor Costs - (CLIN 0004)
Subcontractor # 1 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 1 Labor Hours0000000.00%
Subcontractor # 2 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 2 Labor Hours0000000.00%
Subcontractor # 3 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 3 Labor Hours0000000.00%
Subcontractor # 4 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 4 Labor Hours0000000.00%
Subcontractor Labor Costs - (CLIN 0009)
Subcontractor # 1 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 1 Labor Hours0000000.00%
Subcontractor # 2 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 2 Labor Hours0000000.00%
Subcontractor # 3 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 3 Labor Hours0000000.00%
Subcontractor # 4 Name$0.00$0.00$0.00$0.00$0.00$0.00
Sub # 4 Labor Hours0000000.00%
Total Subcontractor Labor (CLIN 0004)$0.00$0.00$0.00$0.00$0.00$0.00
Total Subcontractor Labor (CLIN 0009)$0.00$0.00$0.00$0.00$0.00$0.00
Total Combined Labor Costs - CLIN 0004$0.00$0.00$0.00$0.00$0.00$0.00
Total Combined Labor Costs - CLIN 0009$0.00$0.00$0.00$0.00$0.00$0.00
ODCs (CLIN 0012)
Travel$79,112.10$101,217.13$105,963.85$286,293.08
Additional ODCs (Prime)$0.00$0.00$0.00$0.00$0.00$0.00
Additional ODCs (Subs)$0.00$0.00$0.00$0.00$0.00$0.00
Total Travel and ODCs (less G&A)$79,112.10$0.00$101,217.13$0.00$105,963.85$286,293.08

G&A - ODCs (CLIN 0012) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Proposed Cost, FFP CLIN 0004$0.00$0.00$0.00$0.00$0.00$0.00
Profit$0.00$0.00$0.00$0.00$0.00$0.00
Total FFP CLIN 0004$0.00$0.00$0.00$0.00$0.00$0.00
Proposed Cost, FFP CLINS 0009$0.00$0.00$0.00$0.00$0.00$0.00
Profit$0.00$0.00$0.00$0.00$0.00$0.00
Total FFP CLIN 0009$0.00$0.00$0.00$0.00$0.00$0.00

Total FFP CLIN 0012 $79,112.10 $0.00 $101,217.13 $0.00 $105,963.85 $286,293.08

Total FFP Costs for (0004, 0009, and 0012) $79,112.10 $0.00 $101,217.13 $0.00 $105,963.85 $286,293.08

FFP CLINS (0001, 0002, 0003, 0005, 0006, 0007, 0008)
CLIN 0001 - Delivery of Advanced Analytics Technical Solutions (AATS) Capability$0.00
CLIN 0002 - Delivery of System Documentation/Technical Data Package$0.00
CLIN 0003 - Delivery of Systems Approach Training (SAT) Materials$0.00
CLIN 0005 - (Year 2) Annual Software Sustainment, Including Annual License Renewals, Software Updates and Security Updates$0.00
CLIN 0006 - (Year 3) Annual Software Sustainment, Including Annual License Renewals, Software Updates and Security Updates$0.00
CLIN 0007 - (Year 4) Annual Software Sustainment, Including Annual License Renewals, Software Updates and Security Updates$0.00
CLIN 0008 - (Year 5) Annual Software Sustainment, Including Annual License Renewals, Software Updates and Security Updates$0.00
CLIN 0011 - (Year 2, 3, 4, and 5) Additional AATS Software Licenses/User Capacity$0.00

Total FFP CLINs (0001, 0002, 0003, 0005, 0006, 0007, 0008) Cost $0.00

Total Cost $286,293.08

Proposed Price for Delivery Order 0001 - CLINs 0001, 0002 , and 0003 - To be awarded at time of Contract Award
CLIN 0001CLIN 0002CLIN 0003DO 0001 Total
$0.00$0.00$0.00$0.00

Loading Factors Year 1 Year 2 Year 3 Year 4 Year 5

G&A0.00%0.00%0.00%0.00%0.00%
Profit0.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

Burdened Labor Cost

RFP: N65236-16-R-0001

Charleston, SC (CLIN 0004)Year 1Year 2Year 3Year 4Year 5
Government SiteHours Year 1Labor RatesHours Year 2Labor RatesHours Year 3Labor RatesHours Year 4Labor RatesHours Year 5Labor Rates
Professional CategoriesSTSTTotal CostSTTotal CostSTTotal CostSTTotal CostSTTotal Cost
Program Manager480$0.00$0.00288$0.00$0.00288$0.00$0.00288$0.00$0.00288$0.00$0.00
Engineer/Scientist 5480$0.00$0.00816$0.00$0.00816$0.00$0.00816$0.00$0.00816$0.00$0.00
Engineer/Scientist 41,920$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.00
Engineer/Scientist 31,920$0.00$0.000$0.00$0.00960$0.00$0.000$0.00$0.00960$0.00$0.00
Technical Analyst 11,920$0.00$0.00160$0.00$0.00160$0.00$0.00160$0.00$0.00160$0.00$0.00
Operations Specialist240$0.00$0.00240$0.00$0.00480$0.00$0.000$0.00$0.00480$0.00$0.00
Training Specialist1,780$0.00$0.000$0.00$0.00480$0.00$0.000$0.00$0.00480$0.00$0.00
SCA Categories
Computer Programmer II1,920$0.00$0.000$0.00$0.00960$0.00$0.000$0.00$0.00960$0.00$0.00
Computer Systems Analyst II1,920$0.00$0.000$0.00$0.00960$0.00$0.000$0.00$0.00960$0.00$0.00
Computer Systems Analyst III1,920$0.00$0.00250$0.00$0.00250$0.00$0.00250$0.00$0.00250$0.00$0.00

BURDENED LABOR COST 0.00 0.00 0.00 0.00 0.00

Washington, DC (CLIN 0009)Year 1Year 2Year 3Year 4Year 5
Contractor SiteHours Year 1Labor RatesHours Year 2Labor RatesHours Year 3Labor RatesHours Year 4Labor RatesHours Year 5Labor Rates
Professional CategoriesSTSTTotal CostSTTotal CostSTTotal CostSTTotal CostSTTotal Cost
Engineer/Scientist 50$0.00$0.00816$0.00$0.00816$0.00$0.00816$0.00$0.00816$0.00$0.00
Engineer/Scientist 40$0.00$0.003,840$0.00$0.003,840$0.00$0.003,840$0.00$0.003,840$0.00$0.00
Engineer/Scientist 30$0.00$0.003,840$0.00$0.003,840$0.00$0.003,840$0.00$0.003,840$0.00$0.00

BURDENED LABOR COST 0.00 0.00 0.00 0.00 0.00

GRAND TOTAL BURDENED LABOR $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

Team Hours

RFP: N65236-16-R-0001

Charleston, SC (CLIN 0004)Government Site Labor Hours, Year 1Government Site Labor Hours, Year 2Government Site Labor Hours, Year 3Government Siteabor Hours, Year 4Government Site Labor Hours, Year 5
TotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime Contractor
Professional CategoriesST HoursSTSTSTSTSTST HoursSTSTSTSTSTST HoursSTSTSTSTSTST HoursSTSTSTSTSTST HoursSTSTSTSTST
Program Manager48000004802880000288288000028828800002882880000288
Engineer/Scientist 548000004808160000816816000081681600008168160000816
Engineer/Scientist 41,92000001,920000000000000000000000000
Engineer/Scientist 31,92000001,92000000096000009600000009600000960
Technical Analyst 11,92000001,9201600000160160000016016000001601600000160
Operations Specialist2400000240240000024048000004800000004800000480
Training Specialist1,78000001,78000000048000004800000004800000480
SCA Categories
Computer Programmer II1,92000001,92000000096000009600000009600000960
Computer Systems Analyst II1,92000001,92000000096000009600000009600000960
Computer Systems Analyst III1,92000001,9202500000250250000025025000002502500000250
Subtotal14,500000014,5001,75400001,7545,35400005,3541,51400001,5145,35400005,354
Washington, DC (CLIN 0009)Contractor Site Labor Hours, Year 1Contractor Site Labor Hours, Year 2Contractor Site Labor Hours, Year 3Contractor Site Labor Hours, Year 4Contractor Site Labor Hours, Year 5
TotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime ContractorTotalSubSubSubSubPrime Contractor
Professional CategoriesST HoursSTSTSTSTSTST HoursSTSTSTSTSTST HoursSTSTSTSTSTST HoursSTSTSTSTSTST HoursSTSTSTSTST
Engineer/Scientist 50000008160000816816000081681600008168160000816
Engineer/Scientist 40000003,84000003,8403,84000003,8403,84000003,8403,84000003,840
Engineer/Scientist 30000003,84000003,8403,84000003,8403,84000003,8403,84000003,840
Subtotal0000008,49600008,4968,49600008,4968,49600008,4968,49600008,496

Total Hours per Year 14,500 0 0 0 0 14,500 10,250 0 0 0 0 10,250 13,850 0 0 0 0 13,850 10,010 0 0 0 0 10,010 13,850 0 0 0 0 13,850

Percentage of Participation 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 100.00%

TOTAL HOURS: 62,460

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

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

Other Labor Data

RFP: N65236-16-R-0001
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
Offeror's Labor CategoriesRate (1)Rate (2)Hours (3)
Professional
Program Manager
Engineer/Scientist 5
Engineer/Scientist 4
Engineer/Scientist 3
Technical Analyst 1
Operations Specialist
Training Specialist

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

(2)Adjusted 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
Computer Programmer II14072
Computer Systems Analyst II14102
Computer Systems Analyst III14103

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

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

Benefit Summary

RFP: N65236-16-R-0001
Company Name:

PROFESSIONAL EMPLOYEE COMPENSATION PLAN

INSTRUCTIONS:

SalariesSee Attached Salary Data sheet
Salary Supporting DataSee Attached Salary Data sheet
Escalation
Eligibility for Benefits
Vacation
Sick Leave
Holidays
Military Leave
Jury Duty
Medical Insurance
Dental Care
Vision Care
Short Term Disability
Long-Term Disability
Life Insurance
AD&D
Retirement /Pension
Education Assistance
% of Salary/Fringe Rate
Additional Notes:

&"Times New Roman,Bold"&14

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

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

Salary Data

RFP: N65236-16-R-0001

INSTRUCTIONS:All Prime Offerors shall complete this tab. This page and the preceding Benefit Summary Chart constitute the Professional Employee Compensation Plan.
PROFESSIONAL SALARIESSUPPORTING SALARY DATA
Labor CategoryYear 1 Unloaded RateYear 1 SalaryCompensation Survey Name / Compensation Data SourceSurvey Date
Program Manager
Engineer/Scientist 5
Engineer/Scientist 4
Engineer/Scientist 3
Technical Analyst 1
Operations Specialist
Training Specialist

Labor rates are based on hours per year

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

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

Microsoft_Excel_Worksheet1.xlsx Benefits - Instructions

EMPLOYEE COMPENSATION PLAN

Salaries Provide a chart of salaries for the base year using the Salary Data spreadsheet in the pricing model. The salaries shall track back to the cost proposal submitted. Provide the number of hours per year (2,080 or other number). The compensation levels proposed should reflect a clear understanding of work to be performed and should indicate the capability to obtain and keep suitably qualified personnel to meet mission objectives. The salaries must take into account differences in skills, the complexity of various disciplines and professional job difficulty. CAUTION: Proposals envisioning compensation levels lower than those of predecessor contractors will be evaluated on the basis of maintaining program continuity, uninterrupted high quality work, and availability of required competent employees.

Salary Supporting Data Provide supporting data such as recognized national and regional compensation surveys and studies of professional, public and private organizations used in establishing the total compensation structure. It is not necessary to provide the actual survey.

Escalation Enter the proposed escalation for professional employees used for this proposal.

Eligibility for Benefits Provide either a general statement regarding eligibility for fringe benefits, or discuss with regard to each benefit. Does the benefit package apply to only the full-time employees, or are part-time employees eligible. What is the company's definition of a full-time and part-time employee?

Vacation Enter the number of vacation days per year at the various levels of years of employment. If your company uses Personal Time Off (PTO) instead, describe what that includes here.

Sick Leave Enter the number of paid sick days allowed per year.

Holidays Enter the number of paid holidays per year.

Military leave Describe the company policy, if any, regarding short term (annual training), and long term (active duty deployment) military leave. How much leave is allowed per year? Is the leave paid or unpaid?

Jury Duty Describe the company policy, if any, regarding Jury Duty. How much time is allowed per year? Is the leave paid or unpaid?

Medical Insurance Briefly describe the type of health care plans provided. Describe what portion of the premiums the company pays for employees and for dependents. If the company offers Healthcare Flexible Spending Accounts, provide that information as well.

Dental Care See guidelines for Medical Insurance above.

Vision Care See guidelines for Medical Insurance above.

Short Term Disability Describe the Short Term Disability coverage, if offered. Describe what portion of the premiums the company pays for employees and for dependents.

Long-Term Disability Describe the LongTerm Disability coverage, if offered. Describe what portion of the premiums the company pays for employees and for dependents.

Life Insurance Describe the Life Insurance coverage. Describe the portion of the premiums the company pays for employees, and any optional additional coverage available.

AD&D Describe the Accidental Death & Dismemberment coverage, if offered. Describe the portion of the premiums paid by the company.

Retirement /Pension Describe any 401(k) , pensions, or Profit Sharing . Who is eligible to participate? What is the company contribution and what is the vesting period?

Educational Assistance Describe the company policy on educational assistance. What expenses are reimbursed? What is the average amount per employee per year?

% of Salary What is the company fringe benefit rate? If there is no separate fringe rate, what portion of the overhead is fringe benefits?

Additional Notes: Describe any additional benefits you feel are significant.

Prepared by: Jean Duncan Revised 7-29-11 image2.emf

File details come from the government source that posted it.