Attachment_5_Pricing_Workbook_-_Protected.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- M67854-17-R-2602
- Issued by
-
United States Marine Corps
About this file
Draft Pricing Workbook
View the file
Other files
Show all 42
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
Instructions
| M67854-17-R-2602 - ATTACHMENT 5 - PRICING WORKBOOK Tab 1 - Instructions Tab 2 - Contract FFP CLINS PRIME Tab 3 - Contract FFP CLINS SUBCONTRACTOR(S) Tab 4 - Contract Labor Rates and Categories |
| Tab 1 - Instructions: |
| Tab 2 - Contract FFP CLINS PRIME - This worksheet is where the Prime Offeror shall enter its total proposed pricing (includes subcontractor costs) for all FFP CLINs for all IDIQ Ordering Periods. The numbers within this spreadsheet shall match the numbers proposed in Schedule B of the Model Contract. |
| Tab 3 - Contract FFP CLINS SUB - This worksheet is where the Prime Offeror shall enter its Subcontractor's pricing only, for all FFP CLINs for all Ordering Periods. Note if Subcontractor pricing is not provided to the prime offeror then follow directions in Solicitation Section L, E, Vol VI, paragraph 7. The numbers within this spreadsheet shall match the numbers proposed in Schedule B of the Model Contract. |
| Tab 4 - Contract Labor Rates and Categories - This worksheet is where the Prime Offeror shall enter it's Labor Categories, Roles and Responsibilities, Education, Years of Experience, 2016 hourly Compensation Rate, Ordering Periods 1 through 5 year IDIQ Fully Burdened Labor Rates. These rates will remain fixed over the 5 Year ordering period of the IDIQ |
DRAFT
Contract FFP CLINs PRIME
| ATTACHMENT 5 - M67854-17-R-2602 | |||||||||
| Contract FFP CLINS PRIME - TOTAL COST (should include Subcontractor costs) | |||||||||
| CLIN NO. | ID/IQ Ordering Period 1 | CLIN NO. | ID/IQ Ordering Period 2 | CLIN NO. | ID/IQ Ordering Period 3 | CLIN NO. | ID/IQ Ordering Period 4 | CLIN NO. | ID/IQ Ordering Period 5 |
| 1001 | $0.00 | 2001 | $0.00 | 3001 | $0.00 | 4001 | $0.00 | 5001 | $0.00 |
| 1002 | $0.00 | 2002 | $0.00 | 3002 | $0.00 | 1002 | $0.00 | 5002 | $0.00 |
| 1003 | $0.00 | 2003 | $0.00 | 3003 | $0.00 | 4003 | $0.00 | 5003 | $0.00 |
| 1004 | $0.00 | 2004 | $0.00 | 3004 | $0.00 | 4004 | $0.00 | 5004 | $0.00 |
| 1005 | $0.00 | 2005 | $0.00 | 3005 | $0.00 | 4005 | $0.00 | 5005 | $0.00 |
| 1006 | $0.00 | 2006 | $0.00 | 3006 | $0.00 | 4006 | $0.00 | 5006 | $0.00 |
| 1007 | $0.00 | 2007 | $0.00 | 3007 | $0.00 | 4007 | $0.00 | 5007 | $0.00 |
| 1008 | $0.00 | 2008 | $0.00 | 3008 | $0.00 | 4008 | $0.00 | 5008 | $0.00 |
| 1009 | $0.00 | 2009 | $0.00 | 3009 | $0.00 | 4009 | $0.00 | 5009 | $0.00 |
| 1010 | $0.00 | 2010 | $0.00 | 3010 | $0.00 | 4010 | $0.00 | 5010 | $0.00 |
| 1011 | $0.00 | 2011 | $0.00 | 3011 | $0.00 | 4011 | $0.00 | 5011 | $0.00 |
| 1020 | $52,560.00 | 2020 | $53,680.00 | 3020 | $54,800.00 | 4020 | $55,920.00 | 5020 | $57,040.00 |
| TOTAL | $52,560.00 | $53,680.00 | $54,800.00 | $55,920.00 | $57,040.00 |
| Note 1: This worksheet provides the Total FFP for CLINs 1001 through 1011, 2001 through 2011, 3001 through 3011, 4001 through 4011 and 5001 through 5011. Pricing within this worksheet shall match pricing provided under Model Contract, Schedule B CLINs . | |||||
| Note 2: CLIN 1020, 2020, 3020, 4020 and 5020 represent the Governments estimated ODC/Travel estimate for the entire 5 year ordering period, for FFP CLINs |
DRAFT
Contract FFP CLINs SUB
| ATTACHMENT 5 - M67854-17-R-2602 | |||||||||
| Contract FFP CLINS SUBCONTRACTOR COST ONLY | |||||||||
| CLIN NO. | ID/IQ Ordering Period 1 | CLIN NO. | ID/IQ Ordering Period 2 | CLIN NO. | ID/IQ Ordering Period 3 | CLIN NO. | ID/IQ Ordering Period 4 | CLIN NO. | ID/IQ Ordering Period 5 |
| 1001 | $0.00 | 2001 | $0.00 | 3001 | $0.00 | 4001 | $0.00 | 5001 | $0.00 |
| 1002 | $0.00 | 2002 | $0.00 | 3002 | $0.00 | 1002 | $0.00 | 5002 | $0.00 |
| 1003 | $0.00 | 2003 | $0.00 | 3003 | $0.00 | 4003 | $0.00 | 5003 | $0.00 |
| 1004 | $0.00 | 2004 | $0.00 | 3004 | $0.00 | 4004 | $0.00 | 5004 | $0.00 |
| 1005 | $0.00 | 2005 | $0.00 | 3005 | $0.00 | 4005 | $0.00 | 5005 | $0.00 |
| 1006 | $0.00 | 2006 | $0.00 | 3006 | $0.00 | 4006 | $0.00 | 5006 | $0.00 |
| 1007 | $0.00 | 2007 | $0.00 | 3007 | $0.00 | 4007 | $0.00 | 5007 | $0.00 |
| 1008 | $0.00 | 2008 | $0.00 | 3008 | $0.00 | 4008 | $0.00 | 5008 | $0.00 |
| 1009 | $0.00 | 2009 | $0.00 | 3009 | $0.00 | 4009 | $0.00 | 5009 | $0.00 |
| 1010 | $0.00 | 2010 | $0.00 | 3010 | $0.00 | 4010 | $0.00 | 5010 | $0.00 |
| 1011 | $0.00 | 2011 | $0.00 | 3011 | $0.00 | 4011 | $0.00 | 5011 | $0.00 |
| 1020 | $52,560.00 | $53,680.00 | $54,800.00 | $55,920.00 | $57,040.00 |
| TOTAL | $52,560.00 | $53,680.00 | $54,800.00 | $55,920.00 | $57,040.00 |
| Note 1: This worksheet provides the Total FFP for CLINs 1001 through 1011, 2001 through 2011, 3001 through 3011, 4001 through 4011 and 5001 through 5011. Pricing within this worksheet shall match pricing provided under Model Contract, Schedule B CLINs . | |||||
| Note 2: CLIN 1020, 2020, 3020, 4020 and 5020 represent the Governments estimated ODC/Travel estimate for the entire 5 year ordering period, for FFP CLINs |
DRAFT
Lookup Values
| Education | Facility |
| High School | Contractor |
| Associate | Government |
| Bachelor | |
| Master | |
| Doctorate |
Labor Rates and Categories
| ATTACHMENT 5 - M67854-17-R-2602 | |
| STEP 1: Contract Labor Rates/Categories | |
| Entries in this worksheet will constitute the final list of labor categories and associated data to be utilized for the entirety of the ID/IQ and any awarded task orders, pending any discussions and final proposal revisions. Changes to this list, subsequent to award of an ID/IQ contract are not authorized. This information, minus the columns labeled with, "FAR 52.222-46" will be incorporated into the ID/IQ award. |
| # | Labor Category | Roles and Responsibilities | Education (Degree Type) | Experience (Years) | 2016 Hourly Compensation ($) 52.222-46 | 2016 Hourly Fringe ($) 52.222-46 | ID/IQ Ordering Period 1 Performance Fully-Burdened Labor Rate (date of award through 1 year) | ID/IQ Ordering Period 2 Performance Fully-Burdened Labor Rate (13-24 month) | ID/IQ Ordering Period 3 Performance Fully-Burdened Labor Rate (25-36 month) | ID/IQ Ordering Period 4 Performance Fully-Burdened Labor Rate (37 -48 month) | ID/IQ Ordering Period 5 Performance Fully-Burdened Labor Rate (49-60 month) | Company Name |
| 1 | Project Manager (Example LCAT) | Provides oversight for all activities | Bachelor | 6 | $53.26 | $18.38 | $71.64 | ABC - Prime | ||||
| 2 | IA Engineer (Example LCAT) | Responsible for all IA related activities | Bachelor | 4 | $51.13 | $18.01 | $69.14 | XYZ - Subcontractor | ||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 | ||||||||||||
| $0.00 |
DRAFT
Sheet1
File details come from the government source that posted it. Updated .