J4_Revised_Cost_Model_Full_Performance.xlsx
XLSX spreadsheet 68 KB Posted
- Attached to
- Army Cost Management Services Federal contract opportunity
- Solicitation number
- W91CRB-19-R-0023
About this file
This document contains templates and instructions for a cost proposal in response to a solicitation from the U.S. Army Contracting Command - Aberdeen Proving Ground. The solicitation seeks cost management services and has a number W91CRB-19-R-0023. Offerors must complete templates for labor rates, other direct costs, and a cost summary to propose fully burdened pricing for the base period and four option years. The templates include instructions for categorizing labor by prime or subcontractor performance and calculating direct rates, fringe benefits, and billing rates. They also provide normalized other direct cost values for the proposal. Proposed pricing will not include costs for the transition-in period. The deadline for submitting questions was January 15, 2019.
J4 Cost Model Template Full Performance
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| A01_Solicitation_W91CRB-19-R-0023_Amendment_01_Modification.pdf | ||
| A01_Solicitation_W91CRB-19-R-0023_Amendment_01_Conformed.pdf | ||
| A07_Feedback_Template_J6.pdf | ||
| J1_CDRLs_DD1423_PG1.pdf | ||
| J5_Performance_Risk_Questionnaire.docx | DOCX document | |
| J7_Initial_TO_PWS.docx | DOCX document | |
| J2__DD_254_ACM_Services.pdf | ||
| J6_Feedback_Template.xlsx | XLSX spreadsheet | |
| J8__Revised_Cost_Model_J4_TO_0001.xlsx | XLSX spreadsheet | |
| J1_CDRLs_DD1423_PG3.pdf | ||
| J3_QASP_ACM.docx | DOCX document | |
| Solicitation_W91CRB-19-R-0023.pdf | ||
| J1_CDRLs_DD1423_PG2.pdf |
Show all 13
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Inputs and Instructions
| Government Inputs |
| Offeror Inputs |
| Solicitation Number: | W91CRB-19-R-0023 |
| Name of Action: | Army Cost Management Services - DASA(CE) |
| Period of Performance: | 03/29/2019 - 03/28/2024 |
| Annual Productive Hours: | 1,740 |
| Prime Contractor/Subcontractor Name/Division: |
Section B
| Section B - Supplies or Services Costs and/or Prices |
| Solicitation Number: W91CRB-19-R-0023 |
| Name of Action: Army Cost Management Services - DASA(CE) |
| Period of Performance: 03/29/2019 - 03/28/2024 |
| Prime Contractor/Subcontractor Name/Division: |
| (The format below is a sample. Propose in the actual format of the Section B contained in the solicitation) |
| CLIN | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE | AMOUNT | |
| 0001 | Labor | Undefined | Job | Fixed Price = | $ - 0 | from Labor - Cost Detail Worksheet |
| FFP | Profit = | $ - 0 | from Labor - Cost Detail Worksheet | |||
| Total Price = | $ - 0 |
| 0002 | Other Direct Cost/Travel | Undefined | Job | Cost = | $ 762,373.82 | from ODC - Cost Detail Worksheet |
| COST | Burden = | $ - 0 | from ODC - Cost Detail Worksheet | |||
| $ 762,373.82 |
| 0003 | Contractor Manpower Reporting | Undefined | Job | Not Separately Priced |
| FFP |
| 0004 | Contract Data Requirements List | Undefined | Job | Not Separately Priced |
| FFP |
| 0005 | Transition-In | Undefined | Job | Fixed Price = | $ - 0 | from Labor - Cost Detail Worksheet |
| FFP | Profit = | $ - 0 | from Labor - Cost Detail Worksheet | |||
| Total Price = | $ - 0 |
| Total | Fixed Price = | $ - 0 |
| Profit = | $ - 0 | |
| Cost = | $ 762,373.82 | |
| Burden = | $ - 0 | |
| $ 762,373.82 |
| Check | $ 762,373.82 | from Individual Cells in Section B |
| Check | $ 762,373.82 | from Cost Summary Worksheet |
| Check | $ 762,373.82 | from Labor - Cost Detail Worksheet |
and ODC - Cost Detail Worksheet
&F, &A
PAGE &P OF &N
Cost Summary
| Cost Summary Worksheet | ||||||||
| Solicitation Number: W91CRB-19-R-0023 | ||||||||
| Name of Action: Army Cost Management Services - DASA(CE) | ||||||||
| Period of Performance: 03/29/2019 - 03/28/2024 | ||||||||
| Prime Contractor/Subcontractor Name/Division: | ||||||||
| Transition-In | Base Period, | |||||||
| Year 1 | Base Period, | |||||||
| Year 2 | Base Period, | |||||||
| Year 3 | Base Period, | |||||||
| Year 4 | Base Period, | |||||||
| Year 5 | Total | |||||||
| Labor Hours | 3,190 | 15,950 | 19,140 | 19,140 | 19,140 | 19,140 | 95,700 | |
| Unburdened Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Fringe | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other Direct Costs | $ 24,563.00 | $ 122,815.00 | $ 149,883.43 | $ 152,431.44 | $ 155,022.78 | $ 157,658.17 | $ 762,373.82 |
| Burden on ODCs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subtotal | $ 24,563.00 | $ 122,815.00 | $ 149,883.43 | $ 152,431.44 | $ 155,022.78 | $ 157,658.17 | $ 762,373.82 |
Total $ 24,563.00 $ 122,815.00 $ 149,883.43 $ 152,431.44 $ 155,022.78 $ 157,658.17 $ 762,373.82
Labor Detail
| Labor Detail Worksheet |
| Solicitation Number: W91CRB-19-R-0023 |
| Name of Action: Army Cost Management Services - DASA(CE) |
| Prime Contractor/Subcontractor Name/Division: |
| Period of Performance: 03/29/2019 - 03/28/2024 |
| Annual Productive Hours: 1740 |
| CLIN 0005: Transition-In Period Labor, Year One, Two Months | ||||
| Labor Categories | Hours | FTE | Total Productive Hours | Instruction 6.1: |
Enter a P if performed by the prime
| Enter a S if performed by a subcontractor | Instruction 6.1: |
| If column E = S, Enter Name of Subcontractor | Instruction 6.2: |
| Direct Labor Rate | Instruction 6.3: |
| Fringe | Instruction 6.4: |
Rate Less Profit
| Subcontractor Billing Rate Less Prime Profit | Profit | Fully Burdened Labor Rate | Total Price | |||||||||
| a | b | c | d=b x c | e | f | g | h | i | j | k = i + j | l = d x k | |
| Principal Consultant/SAP (Level 5) | 290 | 1.0 | 290.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Consultant/SAP (Level 4) | 290 | 2.0 | 580.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Consultant/SAP (Level 3) | 290 | 5.0 | 1,450.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Cost/Mngrl Acctant w/SAP (Level 2) | 290 | 2.0 | 580.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Project Admin Specialist/Technical Writer | 290 | 1.0 | 290.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 1,450 | 11.0 | 3,190.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Weighted Average: | 290.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0001: Base Period Labor, Year One, Ten Months | ||||
| Labor Categories | Hours | FTE | Total Productive Hours | Instruction 6.1: |
Enter a P if performed by the prime
| Enter a S if performed by a subcontractor | Instruction 6.1: |
| If column E = S, Enter Name of Subcontractor | Instruction 6.2: |
| Direct Labor Rate | Instruction 6.3: |
| Fringe | Instruction 6.4: |
Rate Less Profit
| Subcontractor Billing Rate Less Prime Profit | Profit | Fully Burdened Labor Rate | Total Price | |||||||||
| a | b | c | d=b x c | e | f | g | h | i | j | k = i + j | l = d x k | |
| Principal Consultant/SAP (Level 5) | 1,450 | 1.0 | 1,450.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Consultant/SAP (Level 4) | 1,450 | 2.0 | 2,900.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Consultant/SAP (Level 3) | 1,450 | 5.0 | 7,250.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Cost/Mngrl Acctant w/SAP (Level 2) | 1,450 | 2.0 | 2,900.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Project Admin Specialist/Technical Writer | 1,450 | 1.0 | 1,450.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 7,250 | 11.0 | 15,950.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Weighted Average: | 1,450.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0001: Base Period Labor, Year Two, Twelve Months | ||||
| Labor Categories | Hours | FTE | Total Productive Hours | Instruction 6.1: |
Enter a P if performed by the prime
| Enter a S if performed by a subcontractor | Instruction 6.1: |
| If column E = S, Enter Name of Subcontractor | Instruction 6.2: |
| Direct Labor Rate | Instruction 6.3: |
| Fringe | Instruction 6.4: |
Rate Less Profit
| Subcontractor Billing Rate Less Prime Profit | Profit | Fully Burdened Labor Rate | Total Price | |||||||||
| a | b | c | d=b x c | e | f | g | h | i | j | k = i + j | l = d x k | |
| Principal Consultant/SAP (Level 5) | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Consultant/SAP (Level 4) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Consultant/SAP (Level 3) | 1,740 | 5.0 | 8,700.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Cost/Mngrl Acctant w/SAP (Level 2) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Project Admin Specialist/Technical Writer | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 8,700 | 11.0 | 19,140.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Weighted Average: | 1,740.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0001: Base Period Labor, Year Three, Twelve Months | ||||
| Labor Categories | Hours | FTE | Total Productive Hours | Instruction 6.1: |
Enter a P if performed by the prime
| Enter a S if performed by a subcontractor | Instruction 6.1: |
| If column E = S, Enter Name of Subcontractor | Instruction 6.2: |
| Direct Labor Rate | Instruction 6.3: |
| Fringe | Instruction 6.4: |
Rate Less Profit
| Subcontractor Billing Rate Less Prime Profit | Profit | Fully Burdened Labor Rate | Total Price | |||||||||
| a | b | c | d=b x c | e | f | g | h | i | j | k = i + j | l = d x k | |
| Principal Consultant/SAP (Level 5) | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Consultant/SAP (Level 4) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Consultant/SAP (Level 3) | 1,740 | 5.0 | 8,700.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Cost/Mngrl Acctant w/SAP (Level 2) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Project Admin Specialist/Technical Writer | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 8,700 | 11.0 | 19,140.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Weighted Average: | 1,740.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0001: Base Period Labor, Year Four, Twelve Months | ||||
| Labor Categories | Hours | FTE | Total Productive Hours | Instruction 6.1: |
Enter a P if performed by the prime
| Enter a S if performed by a subcontractor | Instruction 6.1: |
| If column E = S, Enter Name of Subcontractor | Instruction 6.2: |
| Direct Labor Rate | Instruction 6.3: |
| Fringe | Instruction 6.4: |
Rate Less Profit
| Subcontractor Billing Rate Less Prime Profit | Profit | Fully Burdened Labor Rate | Total Price | |||||||||
| a | b | c | d=b x c | e | f | g | h | i | j | k = i + j | l = d x k | |
| Principal Consultant/SAP (Level 5) | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Consultant/SAP (Level 4) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Consultant/SAP (Level 3) | 1,740 | 5.0 | 8,700.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Cost/Mngrl Acctant w/SAP (Level 2) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Project Admin Specialist/Technical Writer | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 8,700 | 11.0 | 19,140.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Weighted Average: | 1,740.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| CLIN 0001: Base Period Labor, Year Five, Twelve Months | ||||
| Labor Categories | Hours | FTE | Total Productive Hours | Instruction 6.1: |
Enter a P if performed by the prime
| Enter a S if performed by a subcontractor | Instruction 6.1: |
| If column E = S, Enter Name of Subcontractor | Instruction 6.2: |
| Direct Labor Rate | Instruction 6.3: |
| Fringe | Instruction 6.4: |
Rate Less Profit
| Subcontractor Billing Rate Less Prime Profit | Profit | Fully Burdened Labor Rate | Total Price | |||||||||
| a | b | c | d=b x c | e | f | g | h | i | j | k = i + j | l = d x k | |
| Principal Consultant/SAP (Level 5) | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Consultant/SAP (Level 4) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Consultant/SAP (Level 3) | 1,740 | 5.0 | 8,700.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Senior Cost/Mngrl Acctant w/SAP (Level 2) | 1,740 | 2.0 | 3,480.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Project Admin Specialist/Technical Writer | 1,740 | 1.0 | 1,740.00 | Enter P or S | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total: | 8,700 | 11.0 | 19,140.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Weighted Average: | 1,740.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total: | 95,700.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Weighted Average: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
ODC Detail
| ODC Detail Worksheet | |||||
| Solicitation Number: W91CRB-19-R-0023 | |||||
| Name of Action: Army Cost Management Services - DASA(CE) | |||||
| Prime Contractor/Subcontractor Name/Division: | |||||
| Period of Performance: 03/29/2019 - 03/28/2024 | |||||
| CLIN | Instruction 7: | ||||
| ODCs/Travel | Burden/ | ||||
| G&A Rate | Burden/ | ||||
| G&A Dollars | Total ODC Cost | ||||
| a | b | c | d = b x c | e = b + d | |
| CLIN 0002 Transition-In | $ 24,563.00 | 0.00% | $ - 0 | $ 24,563.00 | |
| CLIN 0002 - Year 1 | $ 122,815.00 | 0.00% | $ - 0 | $ 122,815.00 | |
| CLIN 0002 - Year 2 | $ 149,883.43 | 0.00% | $ - 0 | $ 149,883.43 | |
| CLIN 0002 - Year 3 | $ 152,431.44 | 0.00% | $ - 0 | $ 152,431.44 | |
| CLIN 0002 - Year 4 | $ 155,022.78 | 0.00% | $ - 0 | $ 155,022.78 | |
| CLIN 0002 - Year 5 | $ 157,658.17 | 0.00% | $ - 0 | $ 157,658.17 | |
| Total | $ 762,373.82 | 0.00% | $ - 0 | $ 762,373.82 |
Microsoft_Word_Document1.docx General
Each offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed workbook shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for fairness, reasonableness, based on the cost/price analysis criteria in FAR 15.404-1. In accordance with the solicitation, the total evaluated price will NOT include the transition in period.
Overall Instructions
The Offeror is to complete any light green shaded cells. Please note that dark green cells may populate in the Section B worksheet.
The worksheets are designed to automatically compute and populate other cells in the Excel workbook.
Inputs and Instructions Worksheet
Type the appropriate name of the Prime Contractor/Subcontractor/Division in cell B7. It will carry through the remaining worksheets.
Section B Worksheet
The Section B worksheet imports data from the Cost Summary, Labor Detail, and ODC Detail worksheets and is used as a basis for the proposed formal Section B. Please note there are green shaded cells on this worksheet. It is a different shade of green. Data is NOT to be entered into these cells. They are conditionally formatted to provide a check that the total proposed price is calculated properly in all cells. If the math checks out, the cells will turn green. If not, the cells will be red. There are no inputs on this worksheet.
Cost Summary Worksheet
This worksheet is for Government analysis purposes. It is populated from the Labor Detail, ODC Detail. There are no inputs on this worksheet.
Labor Detail Worksheet
Prime Or Sub
The offeror is to enter a P in column E if the effort is to be performed by the prime contractor, and a S if performed by another division or subcontractor. Enter the name of the division or contractor in column F. If the particular individual category is to be performed jointly by more than one entity (i.e. the prime and a sub or subs), the offeror will be required to insert additional row(s) under the labor category and to allocate the column D hours for the individual category to be performed among the prime and subs. After this allocation, the total of the original and inserted rows under the individual category in column A shall total to the number of hours provided by or to the Government for the respective labor category.
Direct Labor Rate
Please enter the base labor rate for the labor categories listed. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer for proprietary reasons.
Fringe
Apply fringe to the direct labor rates inclusive of statutory (i.e. FICA, FUTA, SUTA, Workman's Comp) and non-statutory (i.e. health insurance, 401K, etc, vacations, holidays, etc). Subcontractors may submit this information directly to the Contracting Officer for proprietary reasons.
Billing Rate
This field will automatically calculate the prime hourly burdened rate before the application of G&A and fee. If the prime is proposing the use of a subcontractor, please enter the subcontractor billing rate (if performed by a subcontractor).
The rate calculated for prime contractor performed rate categories is: Rate Less Profit = Prime Direct Labor Rate + Prime Fringe.
If the labor category is performed by a subcontractor, the rate entered in column I is: Subcontractor Billing Rate Less Prime Profit = Sub Direct Labor Rate + Any Applicable Sub Indirect Rates.
Other Direct Costs
Please enter the requested data in the light green shaded areas on the ODC Detail worksheet. For the purposes of proposal, the Government has input normalized values for the ODCs. These numbers are to be used. The offerors may add any burden and/or G&A as appropriate. Since these are estimated amounts that may or may not occur, no fixed fee or profit will be allowed on the ODCs.
image1.emf
File details come from the government source that posted it. Updated .