L-3 Cost Summary Workbook_ABM.xls
XLS spreadsheet 103 KB Posted
- Attached to
- Autonomy Baseline Manager (ABM) - A0002
- Solicitation number
- N0002423R6301
View the file
Other files
| File | Type | Posted |
|---|---|---|
| L_3_Cost_Summary_Workbook_Rev 1.xls | XLS spreadsheet | |
| J-3 Key Personnel Attributes-Requirements_Rev 1.xlsx | XLSX spreadsheet | |
| L-2 Staffing Matrix_ABM_Rev 1.xlsx | XLSX spreadsheet | |
| L-1 Bidder Question Submittal Form Rev1.xlsx | XLSX spreadsheet | |
| L-2 Staffing Matrix_ABM.xlsx | XLSX spreadsheet | |
| J-3 Key Personnel Attributes-Requirements_ABM.xlsx | XLSX spreadsheet | |
| L-1 Bidder Question Submittal Form.xlsx | XLSX spreadsheet |
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
Overall Cost Summary
| <Enter Prime Contractor Name Here> | ||||||
| Proposed Costs and Pricing for N00024-23-R-6301 | ||||||
| Q1. Are you proposing a price for CLIN 9000, Data Rights Procurement, in order for the Government to achieve its desired level of rights (GPR) for the data rights being asserted (i.e., less than GPR)? | <Yes/No> | |||||
| CLIN | Description | Type | Qty. | Unit Price | Amount | |
| 0001 | UxV Baseline Management and Software Deployment | Base | CPFF | 80,000 | $ - 0 | $ - 0 |
| 0003 | Travel, Material, and ODCs | Base | COST | $ 10,000,000 | ||
| 0101 | UxV Baseline Management and Software Deployment | Option Year 1 | CPFF | 80,000 | $ - 0 | $ - 0 |
| 0201 | UxV Baseline Management and Software Deployment | Option Year 2 | CPFF | 80,000 | $ - 0 | $ - 0 |
| 0301 | UxV Baseline Management and Software Deployment | Option Year 3 | CPFF | 80,000 | $ - 0 | $ - 0 |
| 0401 | UxV Baseline Management and Software Deployment | Option Year 4 | CPFF | 80,000 | $ - 0 | $ - 0 |
| 9000 | Data Rights Procurement | Option | FFP | $ - 0 | ||
| Total Proposed | $ 10,000,000 | |||||
| NOTES | ||||||
| Values in Columns G & H shall match the information as proposed in Section B for the Corresponding CLINs | ||||||
| For Q1, if the answer is yes, then enter the proposed price for Data Rights in the corresponding cell in the table above | ||||||
| For Q1, if the answer is no, then enter no price information; please note that the Government cannot execute an option CLIN at a price of $0, if the offeror | ||||||
| is proposing to elevate Data Rights offered at less-than-GPR to full GPR at a price of $0 |
Labor Cost Instructions
| TAB: | COLUMN/LOCATION: | INSTRUCTIONS: |
| ALL | ALL | All calculations must be shown using Excel formulas. No hard entered data is permitted where calculations are performed. |
| ALL: | Prime contractor shall verify with each subcontractor that the amount included in the Prime contractor proposal matches each subcontractor cost summary uploaded into the SeaPort portal. | |
| Cost Summary | A,B,C - Labor Categories | Labor Categories should be mapped using column A for contractor labor categories and column B for corresponding Government labor categories found in the provided Government estimated level of effort. If proposing actual employees, the employee name should be listed in column C. Insert the name of Key Personnel. Inserting the names of Non-Key Personnel are desired, but not required. |
| Cost Summary | Labor Rate Cells | Utilize the "John Smith" example for cells that should be hard keyed (green) and cells that should remaining formulas (grey) for cells pertaining to labor rates |
| Cost Summary | D - Labor Categories | Place of Performance |
| Cost Summary | E - Labor Categories | Identify the SOW task paragraph on which the employee will be performing. |
| Cost Summary | F - Labor Categories | Provide exemption status for each employee. |
| Cost Summary | I - Labor Categories | Complete column I with the payroll/Letter of Intent/substantiated rate. |
| Cost Summary | J - Labor Categories | Identify personnel with proposed UCOT by including the UCOT decrement factor as a %. |
| Cost Summary | L - Labor Categories | If proposing current rates and anticipated award date is the following year, escalation is allowed. Complete column with the escalation rate for base year labor. |
| Cost Summary | M - Labor Categories | Review Column (Base Year Labor Rate) to confirm the propose labor rate after base year escalation and UCOT, if applicable, is applied. |
| Cost Summary | Escalation Rate | Escalation rate should be hard keyed IAW Section L Assumed rates (L 1.10.5.6). |
| Labor Rates | Complete the Labor Rates worksheet. If proposing individual employees, the information should be provided based on the employee's direct labor rate(s). If proposing bid rate/composite rate, the information should be provided for each labor category. | |
| LOE Breakdown | Complete LOE Breakdown indicating the breakout of hours by prime/subcontractor by labor category | |
| Overtime Premium Breakdown | Complete Overtime Premium Breakdown indicating the proposed prime and subcontractors burdened OT Premium by year. OT Premium is defined as the cost over and above an individual's regular direct rate. To calculate, subtract the direct rate from the OT rate and multiply the difference by the number of OT hours. Sum the total year OT premium cost and provide the total year premium cost in the Overtime Premium tab. | |
| Labor Category Cells Key: | ||
| Hard Keyed | Change cells to this color when hard keyed in by the Offeror. | |
| Formula | Change cells this color when a formula is used by the Offeror. As noted above, no hard entered data is permitted where calculations are performed. |
&RN00164-19-R-35XX
Attachment XX
Labor Cost Summary
| Solicitation No. N00024-23-R-6301 | Escalation Rate | ||||||||||||||||||||||||
| Prime Offeror Name: | Year 2 | 3.30% | Year 3 | 3.30% | Year 4 | 3.00% | Year 5 | 3.10% | |||||||||||||||||
| Total for All Years | Direct Labor Adjustments | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||||||
| Cost Elements | Corresponding Government Labor Category | Direct Labor: Employee Name | Place of Performance | Exempt/Non-Exempt | Hours | Amount | Current Rate | Uncompensated Overtime (UCOT) | Adjusted for UCOT | Base Year Escalation Rate (%) | Base Year Labor Rate | Hours | Amount | Labor Rate | Hours | Amount | Labor Rate | Hours | Amount | Labor Rate | Hours | Amount | Labor Rate | Hours | Amount |
| Prime Contractor Labor Cost | |||||||||||||||||||||||||
| Prime Contractor Direct Labor | |||||||||||||||||||||||||
| Individual Employee/Labor Category 1 | Engineer I | Example: John Smith | Contrator Site Location | Exempt | 9600 | $892,497 | $ 83.66 | 100% | $ 83.66 | 4.20% | $87.17 | 1920 | $167,374 | $90.05 | 1920 | $172,897 | $93.02 | 1920 | $178,602 | $95.81 | 1920 | $183,961 | $98.78 | 1920 | $189,663 |
| Individual Employee/Labor Category 2 | |||||||||||||||||||||||||
| Etc. | |||||||||||||||||||||||||
| Total Direct Labor Cost | 0 | $0 | |||||||||||||||||||||||
| Prime Contractor Indirect Labor Cost | |||||||||||||||||||||||||
| Indirect Cost 1 ( %) | |||||||||||||||||||||||||
| Indirect Cost 2 ( %) | |||||||||||||||||||||||||
| Indirect Cost 3 ( %) | |||||||||||||||||||||||||
| Etc. | |||||||||||||||||||||||||
| Total Indirect Labor Cost | |||||||||||||||||||||||||
| Total Direct and Indirect Labor cost | |||||||||||||||||||||||||
| COM | |||||||||||||||||||||||||
| Total Prime Contractor Labor Cost | |||||||||||||||||||||||||
| Subcontractor Labor Cost (no ODC) | |||||||||||||||||||||||||
| Subcontractor proposed cost and fee | |||||||||||||||||||||||||
| Subcontractor 1 Cost | |||||||||||||||||||||||||
| Subcontractor 1 Fee | |||||||||||||||||||||||||
| Subcontractor 2 Cost | |||||||||||||||||||||||||
| Subcontractor 2 Fee | |||||||||||||||||||||||||
| Etc. | |||||||||||||||||||||||||
| Total Subcontractor Cost | |||||||||||||||||||||||||
| Total Labor Cost (Prime and Subcontractor Labor) | |||||||||||||||||||||||||
| Fee on Labor | |||||||||||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | |||||||||||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor * | |||||||||||||||||||||||||
| Total Fee (for Prime and Subcontractor Labor) | |||||||||||||||||||||||||
| Total Labor Cost (including Fee) | |||||||||||||||||||||||||
| Facilities Capital Cost of Money (FCCM) | |||||||||||||||||||||||||
| Total CPFF all CLINs (Labor) | |||||||||||||||||||||||||
| Fee Analysis - Total for All Years | Percent | ||||||||||||||||||||||||
| Prime Contractor Labor Cost | |||||||||||||||||||||||||
| Fixed Fee for Labor Performed by Prime Contractor | 0% | ||||||||||||||||||||||||
| Maximum Fixed Fee Allowed by Solicitation |
Labor Rates
| Insert rates specific to company | ||||||||||||
| Indirect Rates | Fee | |||||||||||
| Fringe % Rate | OH % Rate | G&A % Rate | Other % (specify) Rate | Fee % Rate | ||||||||
| 20.00% | 60.00% | 10.00% | 0.00% | 7.00% | ||||||||
| Employee Name (if applicable) | Contractor Labor Category | Government Labor Category | DL rate | Fringe $ | OH $ | G&A $ | Other $ | Sub-total $ | Fee $ | Total Burdened Rate | Total WY Hours (e.g., 1880, 1920, 2080) | FTE $ |
| John Doe - SAMPLE | Software Architecture Engineer | Software Systems Engineer | $45.00 | $9.00 | $27.00 | $8.10 | $89.10 | $6.24 | $95.34 | 1880 | $179,233.56 | |
| Add rows as needed |
LOE Breakdown
| Government Estimated LOE Labor Categories | Prime Hours | Sub 1 Hours | Sub 2 Hours | Etc. | Total Proposed Hours | Government Estimated LOE Hours | Delta |
| N/A | N/A | ||||||
| Add rows as needed. |
Overtime
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Prime Proposed Burdened OT | |||||
| Sub-contractor 1 Proposed Burdened OT | |||||
| Sub-contractor 2 Proposed Burdened OT | |||||
| Sub-contractor 3 Proposed Burdened OT | |||||
| Etc. | |||||
| Total Proposed Burdened OT |
Overtime Premium Breakdown
| Base Yr 1 | Option 1 | Option 2 | Option 3 | Option 4 | |
| Prime Proposed Burdened OT Premium | |||||
| Sub-contractor 1 Proposed Burdened OT Premium | |||||
| Sub-contractor 2 Proposed Burdened OT Premium | |||||
| Sub-contractor 3 Proposed Burdened OT Premium | |||||
| Etc. | |||||
| Total Proposed Burdened OT Premium |
File details come from the government source that posted it. Updated .