M67854-16-R-4806_Att_5_-_Pricing_Workbook_-_Protected.xlsx
XLSX spreadsheet 165 KB Posted
- Attached to
- Defense Readiness Reporting System-Marine Corps
- Solicitation number
- M67854-16-R-4806
- Issued by
-
United States Marine Corps
About this file
M67854-16-R-4806 Attachment 5
View the file
Other files
Show all 25
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
IDIQ Labor Categories
| STEP 1: ID/IQ Labor 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, may only be made by a negotiated contract modification. This information, minus the columns labeled with, "FAR 52.222-46" will be incorporated into the ID/IQ award. |
Please enter the requested information for each proposed labor category below. This data will be utilized in the task order worksheets, where you will select from these labor categories via a drop-down list, and the associated Year-1 Fully-Burdened Rate will be populated.
| # | Labor Category | Facility | Work Location Zip Code | Role and Responsibilities | Education (Degree Type) | Experience (Years) | 2016 Hourly Compensation ($) | ||||||||
| FAR 52.222-46 | 2016 Hourly Fringe ($) | ||||||||||||||
| FAR 52.222-46 | Year 1 Fully-Burdened Rate | ||||||||||||||
| (Jun 16 - Jun 17) | Year 2 Fully-Burdened Rate | ||||||||||||||
| (Jun 17 - Jun 18) | Year 3 Fully-Burdened Rate | ||||||||||||||
| (Jun 18 - Jun 19) | Year 4 Fully-Burdened Rate | ||||||||||||||
| (Jun 19 - Jun 20) | Company | ||||||||||||||
| 1 | Project Manager (Example LCAT) | Contractor | 22554 | Provides oversight for all activities | Bachelor | 6 | $53.26 | $18.38 | $93.78 | $93.78 | $93.78 | $93.78 | Company A (Prime) | ||
| 2 | IA Engineer (Example LCAT 2) | Government | 22134 | Responsible for all IA-related activities | Bachelor | 4 | $51.13 | $18.01 | $88.78 | $88.78 | $88.78 | $88.78 | Company B (Subcontractor) | ||
| 3 | |||||||||||||||
| 4 | |||||||||||||||
| 5 | |||||||||||||||
| 6 | |||||||||||||||
| 7 | |||||||||||||||
| 8 | |||||||||||||||
| 9 | |||||||||||||||
| 10 | |||||||||||||||
| 11 | |||||||||||||||
| 12 | |||||||||||||||
| 13 | |||||||||||||||
| 14 | |||||||||||||||
| 15 | |||||||||||||||
| 16 | |||||||||||||||
| 17 | |||||||||||||||
| 18 | |||||||||||||||
| 19 | |||||||||||||||
| 20 | |||||||||||||||
| 21 | |||||||||||||||
| 22 | |||||||||||||||
| 23 | |||||||||||||||
| 24 | |||||||||||||||
| 25 | |||||||||||||||
| 26 | |||||||||||||||
| 27 | |||||||||||||||
| 28 | |||||||||||||||
| 29 | |||||||||||||||
| 30 | |||||||||||||||
| 31 | |||||||||||||||
| 32 | |||||||||||||||
| 33 | |||||||||||||||
| 34 | |||||||||||||||
| 35 | |||||||||||||||
| 36 | |||||||||||||||
| 37 | |||||||||||||||
| 38 | |||||||||||||||
| 39 | |||||||||||||||
| 40 | |||||||||||||||
| 41 | |||||||||||||||
| 42 | |||||||||||||||
| 43 | |||||||||||||||
| 44 | |||||||||||||||
| 45 | |||||||||||||||
| 46 | |||||||||||||||
| 47 | |||||||||||||||
| 48 | |||||||||||||||
| 49 | |||||||||||||||
| 50 |
TO 0001 PDSS
| STEP 2: Task Order 0001 PDSS Pricing Basis of Estimate |
| Entries in this worksheet will constitute the final list of labor categories and associated data to be utilized for Task Order 0001 PDSS, pending any discussions and final proposal revisions. Changes to this list, subsequent to award of Task Order 0001 PDSS, may only be made by a negotiated contract modification. |
Please enter the requested information for each proposed labor category below. PWS § should be entered at the third level of indention (i.e. X.Y.Z). Labor Category may be entered by clicking into the cell and then clicking the drop-down arrow to select from the labor categories entered in the "IDIQ Labor Categories" worksheet. Level of Effort must be entered as a whole number greater than zero. All other fields are either pulled from the corresponding labor category entry on the "IDIQ Labor Categories" worksheet, or automatically calculated.
| PWS § | Labor Category | Company | Facility | Work Location Zip Code | Fully Burdened Rate (Year 1) | Level of Effort (Hours) | Price |
| 3.1.1 | Project Manager (Example LCAT) | Company A (Prime) | Contractor | 22554 | $93.78 | 40 | $3,751.20 |
| 3.1.2 | Project Manager (Example LCAT) | Company A (Prime) | Contractor | 22554 | $93.78 | 5 | $468.90 |
| 5.1.2 | IA Engineer (Example LCAT 2) | Company B (Subcontractor) | Government | 22134 | $88.78 | 110 | $9,765.80 |
| 3.1.1 | IA Engineer (Example LCAT 2) | Company B (Subcontractor) | Government | 22134 | $88.78 | 50 | $4,439.00 |
Summary of Level of Effort and Price by PWS § Summary of Level of Effort and Price by LCAT
| Row Labels | Sum of Level of Effort (Hours) | Sum of Price | Row Labels | Sum of Level of Effort (Hours) | Sum of Price |
| 3.1.1 | 90 | $8,190.20 | IA Engineer (Example LCAT 2) | 160 | $14,204.80 |
| 3.1.2 | 5 | $468.90 | Project Manager (Example LCAT) | 45 | $4,220.10 |
| 5.1.2 | 110 | $9,765.80 | (blank) | $0.00 | |
| (blank) | $0.00 | Grand Total | 205 | $18,424.90 | |
| Grand Total | 205 | $18,424.90 |
Total 4 $91.28 205 $18,424.90
Sum of Level of Effort (Hours)
| 3.1.1 | 3.1.2 | 5.1.2 | (blank) | 90 | 5 | 110 | Sum of Price |
| 3.1.1 | 3.1.2 | 5.1.2 | (blank) | 8190.2 | 468.9 | 9765.7999999999993 | 0 |
Sum of Level of Effort (Hours)
| IA Engineer (Example LCAT 2) | Project Manager (Example LCAT) | (blank) | 160 | 45 | Sum of Price |
| IA Engineer (Example LCAT 2) | Project Manager (Example LCAT) | (blank) | 14204.8 | 4220.0999999999995 | 0 |
TO 0002 ECPs
| STEP 3: Task Order 0002 Engineering Changes Pricing Basis of Estimate |
| Entries in this worksheet will constitute the final list of labor categories and associated data to be utilized for Task Order 0002 Engineering Changes, pending any discussions and final proposal revisions. Changes to this list, subsequent to award of Task Order 0002 Engineering Changes, may only be made by a negotiated contract modification. |
Please enter the requested information for each proposed labor category below. PWS § should be entered at the third level of indention (i.e. X.Y.Z). Labor Category may be entered by clicking into the cell and then clicking the drop-down arrow to select from the labor categories entered in the "IDIQ Labor Categories" worksheet. Level of Effort must be entered as a whole number greater than zero. All other fields are either pulled from the corresponding labor category entry on the "IDIQ Labor Categories" worksheet, or automatically calculated.
| PWS § | Labor Category | Company | Facility | Work Location Zip Code | Fully Burdened Rate (Year 1) | Level of Effort (Hours) | Price |
| 3.1.1 | Project Manager (Example LCAT) | Company A (Prime) | Contractor | 22554 | $93.78 | 60 | $5,626.80 |
| 3.1.2 | Project Manager (Example LCAT) | Company A (Prime) | Contractor | 22554 | $93.78 | 5 | $468.90 |
| 5.1.2 | IA Engineer (Example LCAT 2) | Company B (Subcontractor) | Government | 22134 | $88.78 | 110 | $9,765.80 |
| 3.1.1 | IA Engineer (Example LCAT 2) | Company B (Subcontractor) | Government | 22134 | $88.78 | 50 | $4,439.00 |
Summary of Level of Effort and Price by PWS § Summary of Level of Effort and Price by LCAT
| Row Labels | Sum of Level of Effort (Hours) | Sum of Price | Row Labels | Sum of Level of Effort (Hours) | Sum of Price |
| 3.1.1 | 110 | $10,065.80 | IA Engineer (Example LCAT 2) | 160 | $14,204.80 |
| 3.1.2 | 5 | $468.90 | Project Manager (Example LCAT) | 65 | $6,095.70 |
| 5.1.2 | 110 | $9,765.80 | (blank) | $0.00 | |
| (blank) | $0.00 | Grand Total | 225 | $20,300.50 | |
| Grand Total | 225 | $20,300.50 |
Total 4 $91.28 225 $20,300.50
Sum of Level of Effort (Hours)
| 3.1.1 | 3.1.2 | 5.1.2 | (blank) | 110 | 5 | 110 | Sum of Price |
| 3.1.1 | 3.1.2 | 5.1.2 | (blank) | 10065.799999999999 | 468.9 | 9765.7999999999993 | 0 |
Sum of Level of Effort (Hours)
| IA Engineer (Example LCAT 2) | Project Manager (Example LCAT) | (blank) | 160 | 65 | Sum of Price |
| IA Engineer (Example LCAT 2) | Project Manager (Example LCAT) | (blank) | 14204.8 | 6095.7 | 0 |
Lookup Values
| Education | Facility |
| High School | Contractor |
| Associate | Government |
| Bachelor | |
| Master | |
| Doctorate |
File details come from the government source that posted it. Updated .