Amend 3 - RFP Attach 4B (Rev 2) - Sub Pricing Model.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- ADVANCED ANALYTICS TECHNICAL SOLUTION (AATS)
- Solicitation number
- N65236-16-R-0001
View the file
Other files
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 | |
| Subcontractor Pricing Model, Rev. 3.1 dated 5-18-2017 | |
| Contract Specialist: Calvin Howard, Telephone (843) 218-5941 |
| Assumptions: | |
| 1. | Additional ODCs are subject to G&A. |
| 2. | CLIN 0004 has hours assigned for each year. |
| 3. | CLIN 0009 has hours assigned for Years 2 through 5 Only. |
| 4. | CLINs 0001, 0002, 0003, 0005, 0006, 0007, and 0008, 0011, and 0012 are Firm Fixed Price CLINs and shall be proposed by the Prime Contractor. |
| 5. | Performance is anticipated to be at the Government Sites in Charleston, SC and the Contractor Sites in Washington, DC. |
| 6. | Profit is applied at the same percentage for each year and is not applicable to ODCs (CLIN 0012). |
| 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-16-R-0001 |
| Title: Advanced Analytics Technical Solutions |
| Contractor's Name: |
| Subcontractor's Name |
| Labor | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | % of Hours |
| Labor Cost (CLINS 0004) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Labor Hours | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% |
| Labor Cost (CLINS 0009) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Labor Hours | 0 | 0 | 0 | 0 | 0 | 0 | 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 |
Additional ODCs 0.00 0.00 0.00 0.00 0.00 0.00
G&A - ODCs 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
Profit 0.00 0.00 0.00 0.00 0.00 0.00
Total FFP Cost 0.00 0.00 0.00 0.00 0.00 0.00
Loading Factors Year 1 Year 2 Year 3 Year 4 Year 5
| G&A | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
| Profit | 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 |
Burdened Labor Cost RFP N65236-16-R-0001 Send a copy of this page to the Prime
| Charleston, SC (CLIN 0004) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||
| Government Site | Hours Year 1 | Labor Rates | Hours Year 2 | Labor Rates | Hours Year 3 | Labor Rates | Hours Year 4 | Labor Rates | Hours Year 5 | Labor Rates | |||||
| Professional Categories | ST | ST | Total Cost | ST | ST | Total Cost | ST | ST | Total Cost | ST | ST | Total Cost | ST | ST | Total Cost |
| Program Manager | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Engineer/Scientist 5 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Engineer/Scientist 4 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Engineer/Scientist 3 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Technical Analyst 1 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Operations Specialist | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Training Specialist | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| SCA Categories | |||||||||||||||
| Computer Programmer II | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Computer Systems Analyst II | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Computer Systems Analyst III | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
BURDENED LABOR COST 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00
| Washington, DC (CLIN 0009) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||
| Contractor Site | Hours Year 1 | Labor Rates | Hours Year 2 | Labor Rates | Hours Year 3 | Labor Rates | Hours Year 4 | Labor Rates | Hours Year 5 | Labor Rates | |||||
| Professional Categories | ST | ST | Total Cost | ST | Total Cost | ST | Total Cost | ST | Total Cost | ST | Total Cost | ||||
| Engineer/Scientist 5 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Engineer/Scientist 4 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
| Engineer/Scientist 3 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 |
BURDENED LABOR COST 0 0.00 0 0.00 0 0.00 0 0.00 0 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 |
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 from | Year 1 Labor Rates | |||
| those specified in the RFP. | Labor | Adjusted Hourly | Effective | |
| Professional Categories | Offeror's Labor Categories | Rate (1) | Rate (2) | Hours (3) |
| 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) 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 Categories | SCA # | Offeror's Labor Categories |
| Computer Programmer II | 14072 | |
| Computer Systems Analyst III | 14102 | |
| Computer Systems Analyst III | 14103 |
&"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
File details come from the government source that posted it.