Atch 8 Order ICW Template.xlsx
XLSX spreadsheet 42 KB Posted
- Attached to
- OPEN MISSION SYSTEM ARCHITECTURE AND COMMAND AND CONTROL SYSTEMS Federal contract opportunity
- Solicitation number
- H9240823R0001
- Issued by
- United States Special Operations Command
About this file
This integrated cost workbook template is to be utilized by offerors responding to the Request for Proposal for the Open Mission System Architecture and Command and Control Systems contract opportunity. Key details include that the workbook consists of five worksheets for labor, materials, subcontractors, travel, and rates to detail all associated costs. Labor worksheets must include direct and indirect rates and supporting documentation. Materials worksheets must include a consolidated bill of materials and price support. Subcontractor worksheets must include price analyses of selected subcontractors. Indirect rates require a Forward Pricing Rate Agreement or actual expenses from the last three years. The solicitation number is H9240823R0001 and questions are due by February 24, 2023. The federal agency is the United States Special Operations Command.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Atch 4 Functional Req. Perf. Spec.pdf | ||
| Atch 1- OMSA C2 IDIQ PWS.pdf | ||
| Atch 7 QnA Template.docx | DOCX document | |
| Atch 6- Initial Order Pricing.xlsx | XLSX spreadsheet | |
| H9240823R0001 14Feb23.pdf | ||
| Atch 3- Initial Order PWS .pdf | ||
| Atch 2- DD Form 254.pdf | ||
| Atch 5- Ph 1 Go_No Go Cklst.pdf | ||
| Exhibit A- CDRLs.pdf | ||
| Atch 9- IDIQ A_B Kit Pricing.xlsx | XLSX spreadsheet |
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
Introduction
OMSA/C2 INTEGRATED COST WORKBOOK (ICW) TEMPLATE FOR USE WITH TO/DO RFPs
I. INTRODUCTION: The purpose of the requested information in the attached worksheets is to assist Government personnel in the review and evaluation of task/delivery order proposals submitted by Offerors. Offerors are reminded that the responsibility for providing adequate supporting data and attachments lies solely with them. Further, the offeror must also bear the burden of proof in establishing reasonableness of proposed costs; therefore, it is in the offeror’s best interest to submit a fully supportable and well-prepared cost proposal. The basis and rationale for all proposed costs should be provided as part of the proposal so that Government personnel can place reliance on the information as current, complete and accurate. Further, FAR 15.403-4 sets forth those circumstances in which offerors are required to submit certified cost or pricing data. This workbook shall be utilized in all Certified Cost/Pricing submissions and Other than Certified Cost/Pricing submissions. The workbook consists of five worksheets:
II. REQUIREMENTS:
1. Explanation of Each Worksheet: The summary is a rollup of all subsequent worksheets. There should be tracking (via formulae) to the workup for the summary total. In other words, the Government should be able to quickly discern how the Offeror is building its costs.
Summary: This is where the totals for each worksheet will feed. The data should feed from the other worksheets in the workbook. If a category (i.e. labor, materials, subcontractors, etc) applies to more than one CLIN the Offeror can add a column for the CLIN as long as there are no other changes to format.
Labor: This is where the labor costs will be detailed. If the company has different business segments with different rates, the company will break the details into those segments similar to the example. If the company has one Overhead and G&A rate for all employees then, of course, the “Segments” can be deleted. A narrative (separate cover is acceptable) should also be included that describes the basis for the proposed direct labor rates. It shall include documents that support the rates so that the government can determine the veracity of the rates.
If direct labor rates are based on the DCAA Forward Pricing Rate Agreement (FPRA) or DCMA (Forward Pricing Rate Recommendation (FPRR), a copy of this document shall be attached. The contractor’s Forward Pricing Rate Proposal (FPRP) submitted to DCMA is NOT a valid supporting document. If the FPRP is submitted, additional supporting as described below shall be included.
If direct labor rates are based on actual salary paid to existing employees, a copy of the payroll run shall be attached. Any Personal Identifiable Information (PII) shall be redacted from the payroll run.
If direct labor rates are based on salary web-sites, screen shots of the appropriate pages shall be included.
If direct labor rates for specific military labor categories are based on occupational series from the department of labor statistics, the cost narrative shall map the military category to the occupational series and provide the basis.
If direct labor is escalated in the out-years, the cost narrative shall state the escalation rate and provide the basis for the proposed escalation. Acceptable forms of support are, rates derived from IHS Global Insight, rates based on historical salary increases etc.
c. Materials: This is where the material costs will be detailed. If the company has different business segments with different rates, the company will break the details into those segments. If the company has one Overhead and G&A rate for all employees then, of course, the “Segments” can be deleted. The proposal shall include a Consolidated Bill of Materials (CBOM).The cost narrative shall describe the basis for the proposed Material costs. It shall include supporting documents such as copies of quotes or recent paid invoices. Acceptable forms of support are rates derived from IHS Global Insight, rates based on historical prices paid etc.
d. Subcontractors: This is where the subcontractor costs will be detailed. Please break out the subcontractor costs as shown. The cost volume shall list the subcontractors that will perform work under the contract. The cost volume shall include the price analysis conducted by the prime contractor which supports the decision to select each subcontractor. Each subcontractors’ price proposal shall be submitted.
e. Travel: Travel is a cost only reimbursable. G&A is allowable. Profit is not allowable. Travel will not reimbursed in excess of what a Government employee would be reimbursed. All labor associated with travel should be shown on the Labor worksheet. The cost volume shall describe how each of these estimates were determined.
f. Rates:
1) Indirect: If indirect rates are based on the DCAA FPRA or DCMA FPRR, a copy of this document shall be attached. The contractor’s FPRP submitted to DCMA is NOT a valid supporting document. If the FPRP is submitted, additional supporting as described below shall be included. A FPRA or FPRR is preferred and will be utilized if available. If a FPRA or FPRR is not available then indirect rates shall be based on actual indirect expenses experienced by the contractor, the following information shall be submitted:
Detailed pool and base costs for each indirect expense shall be provided.
The pool and base costs shall be provided for the last three years and budgeted expenses for the entire period of performance proposed. The budgeted expenses shall include the indirect costs being proposed.
2) Escalation Rates: The cost narrative shall state the escalation rate and provide the basis for the proposed escalation. Acceptable forms of support are rates derived from IHS Global Insight, rates based on historical experience.
3) Cost Estimating Relationships (CER): The cost narrative shall explain any CERs proposed and explain how they were calculated. The fact that their pricing software application produced the CER factor is not a valid explanation.
4) Facilities Capital Cost of Money (FCCM): If FCCM rates are based on the DCAA FPRA or DCMA FPRR, a copy of this document shall be attached. The contractor’s FPRP submitted to DCMA is NOT a valid supporting document. If the FPRA or FPRR is not available, detailed information which show how the FCCM rate was developed shall be included. In addition, Form DD1861 shall be submitted.
3. Please note the start and end date of the Offeror’s Fiscal Year.
4. If option pricing is requested they must be separately priced and separate spreadsheets, worksheets or tables should be provided for each option. Any proposed options that are not fully priced out, will not be included in any resulting award.
5. Except as stated, all modifications to this format require the approval of the Contracting Officer as any changes could affect the Government’s processes.
6. Acceptable supporting documentation include paid invoices and copies of subcontractors agreements. Documentation such as in-house purchase requests do not adequately support the cost.
7. Federal Acquisition Regulation provision 52.215-22 is incorporated into this solicitation by reference. The offeror is to exclude excessive pass-through charges from subcontractors. The offeror must identify in its proposal the percentage of effort it intends to perform and the percentage to be performed by each of its proposed subcontractors. If more than 70 percent of the total effort will be performed through subcontractors, the offeror must include the additional information required by the above-cited clause.
Summary
| SOLICITATION: _______________________ | NOTE (Format Exception): Some companies have G&A in each business segment, others utilize it just before profit. Please enter G&A where appropriate. | |
| Total | ||
| Total Labor | $ - 0 | |
| Overhead on Direct Labor | $ - 0 |
Direct Labor Total $ - 0
| Subcontract | $ - 0 |
| Subcontract Handling OH | $ - 0 |
Total Subcontracting $ - 0 $ - 0
| Materials/Equipment | $ - 0 |
| Material Handling OH | $ - 0 |
Total Materials $ - 0 $ - 0
| Other Direct Costs | $ - 0 |
| Travel Total | $ - 0 |
| Rental Equipment | $ - 0 |
Total Other Direct Costs $ - 0 $ - 0
| Subtotal of All Costs | $ - 0 |
| Minus Travel | $ - 0 |
| Subtotal for Profit & FCCOM | $ - 0 |
| Profit | $ - 0 |
| FCCOM | $ - 0 |
| Add Travel Back In | $ - 0 |
| Grand Total | $ - 0 |
&"Arial,Bold"OMSA/C2 CONTRACT Cost/Price Summary
&"Arial,Regular"Page &P of &N
Labor
| Labor Category | Units | Unit Price/Rate | Units | Unit Price/Rate | Extended Price | |
| Program Manager (example only) | $ - 0 | Note: There are 2 sets of columns in case the offeror needs to split labor between 2 fiscal years. | ||||
| Subtotal | $ - 0 | |||||
| Overhead | 0% | 0% | $ - 0 | |||
| G&A | 0% | 0% | $ - 0 | |||
| Total Admin | $ - 0 |
| Labor Category | Units | Unit Price/Rate | Units | Unit Price/Rate | Extended Price |
| Machinist (example only) | 400 | $ 25.00 | $ 10,000.00 | ||
| Subtotal | $ 10,000.00 | ||||
| Overhead | 10% | $ 1,000.00 | |||
| G&A | 10% | $ 1,000.00 | |||
| Total Manufacturing | $ 12,000.00 |
| Labor Category | Units | Unit Price/Rate | Units | Unit Price/Rate | Extended Price |
| Engineer Senior (example only) | 400 | $ 35.00 | $ 14,000.00 | ||
| Subtotal | $ 14,000.00 | ||||
| Overhead | 15% | $ 2,100.00 | |||
| G&A | 15% | $ 315.00 | |||
| Total Engineering | $ 16,415.00 | ||||
| Total Labor | $ 12,100.00 | ||||
| Total Overhead | $ 1,315.00 | ||||
| Total G&A | $ 18,730.00 | ||||
| Grand Total | $ 32,145.00 | ||||
| Note: Columns may need to be added to accommodate more than one fiscal year. |
&"Arial,Bold"MEUAS III MAC CONTRACT
LABOR
&"Arial,Regular"Page &P of &N
Materials
| Services Business Segment | |||
| Item | Units | Unit Price/Rate | Extended Price |
| $ - 0 | |||
| Subtotal | $ - 0 | ||
| Overhead | $ - 0 | ||
| G&A | $ - 0 | ||
| Total Admin | $ - 0 |
| Manufacturing Business Segment | |||
| Item | Units | Unit Price/Rate | Extended Price |
| Camera | $ - 0 | ||
| Subtotal | $ - 0 | ||
| Overhead | $ - 0 | ||
| G&A | $ - 0 | ||
| Total Manufacturing | $ - 0 |
| Total Materials | $ - 0 |
| Total Overhead | $ - 0 |
| Total G&A | $ - 0 |
Grand Total $ - 0
&"Arial,Bold"OMSA/C2 CONTRACT
MATERIALS
Page &P of &N
Subcontractors Item Units Unit Price/Rate Days Extended Price
| Total Materials | $ - 0 |
| Total G&A | $ - 0 |
Grand Total $ - 0
&"Arial,Bold"OMSA/C2 CONTRACT Subcontractors
Page &P of &N
Travel
| Reason for Travel: | ||||||
| Hotel Per Night | # of Days | |||||
| Meals Per Day | ||||||
| Job Title | Ticket | Hotel Nights | Meals | Rental Car | To/From Airport | Total |
| Rate | ||
| Subtotal | $ - 0 | |
| G&A | $ - 0 | |
| Total | $ - 0 |
&"Arial,Bold"OMSA/C2 CONTRACT
TRAVEL
&"Arial,Regular"Page &P of &N
Rates
&"Arial,Bold"OMSA/C2 CONTRACT
RATES
&"Arial,Regular"Page &P of &N
File details come from the government source that posted it. Updated .