Attachment_0020_CostWorkbook.xlsx
XLSX spreadsheet 58 KB Posted
- Attached to
- Fort Rucker Aviation Maintenance Services
- Solicitation number
- W9124G-17-R-0002
About this file
Attachment 0020 - Cost Workbook V2
View the file
Other files
Show 40 more
Latest 50 of 81 listed here. See the rest on GovTribe.
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
CostPrice Rollup
| Solicitation Number: | W9124G-17-R-0002 |
| Offeror Name: | |
| Offeror POC: | |
| Offeror POC Phone #: | |
| Offeror POC Email: |
| Total Contract | |||
| Element | Rates* | Proposed | |
| Labor | Please insert appropriate formulas to ensure these tables auto-populate from the information in your cost proposal. It is recommended you include these worksheets in the workbook for your proposal. Rates, as applicable, should be drawn from the rates worksheet. Other categories and/or lines may be added to maintain consistency with your accounting system and proposal. | ||
| Direct Labor | |||
| Labor Overhead | |||
| Labor, Management | |||
| Labor Overhead, Mgt | |||
| Subtotal, Labor |
| ODC |
| From FPIF CLINS |
| Gov't Auth Travel |
| CAP and Services |
| Local Purchase |
| Gov't Auth Training |
| Subtotal, ODC |
Subcontracts
G&A
Subtotal
Profit / Fee
| TOTAL |
| * as applicable |
| Phase In | Base Period | Option Period 1 | Option Period 2 | ||||||||
| Element | Rates* | Proposed | Element | Rates* | Proposed | Element | Rates* | Proposed | Element | Rates* | Proposed |
| Labor | Labor | Labor | Labor | ||||||||
| Direct Labor | Direct Labor | Direct Labor | Direct Labor | ||||||||
| Labor Overhead | Labor Overhead | Labor Overhead | Labor Overhead | ||||||||
| Labor, Management | Labor, Management | Labor, Management | Labor, Management | ||||||||
| Labor Overhead, Mgt | Labor Overhead, Mgt | Labor Overhead, Mgt | Labor Overhead, Mgt | ||||||||
| Subtotal, Labor | Subtotal, Labor | Subtotal, Labor | Subtotal, Labor |
| ODC | ODC | ODC | ODC |
| From FPIF CLINS | From FPIF CLINS | From FPIF CLINS | From FPIF CLINS |
| Gov't Auth Travel | Gov't Auth Travel | Gov't Auth Travel | Gov't Auth Travel |
| CAP and Services | CAP and Services | CAP and Services | CAP and Services |
| Local Purchase | Local Purchase | Local Purchase | Local Purchase |
| Gov't Auth Training | Gov't Auth Training | Gov't Auth Training | Gov't Auth Training |
| Subtotal, ODC | Subtotal, ODC | Subtotal, ODC | Subtotal, ODC |
Subcontracts Subcontracts Subcontracts Subcontracts
G&A G&A G&A G&A
Subtotal Subtotal Subtotal Subtotal
Profit / Fee Profit / Fee Profit / Fee Profit / Fee
| TOTAL | TOTAL | TOTAL | TOTAL |
| * as applicable | * as applicable | * as applicable | * as applicable |
| Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | ||||||||
| Element | Rates* | Proposed | Element | Rates* | Proposed | Element | Rates* | Proposed | Element | Rates* | Proposed |
| Labor | Labor | Labor | Labor | ||||||||
| Direct Labor | Direct Labor | Direct Labor | Direct Labor | ||||||||
| Labor Overhead | Labor Overhead | Labor Overhead | Labor Overhead | ||||||||
| Labor, Management | Labor, Management | Labor, Management | Labor, Management | ||||||||
| Labor Overhead, Mgt | Labor Overhead, Mgt | Labor Overhead, Mgt | Labor Overhead, Mgt | ||||||||
| Subtotal, Labor | Subtotal, Labor | Subtotal, Labor | Subtotal, Labor |
| ODC | ODC | ODC | ODC |
| From FPIF CLINS | From FPIF CLINS | From FPIF CLINS | From FPIF CLINS |
| Gov't Auth Travel | Gov't Auth Travel | Gov't Auth Travel | Gov't Auth Travel |
| CAP and Services | CAP and Services | CAP and Services | CAP and Services |
| Local Purchase | Local Purchase | Local Purchase | Local Purchase |
| Gov't Auth Training | Gov't Auth Training | Gov't Auth Training | Gov't Auth Training |
| Subtotal, ODC | Subtotal, ODC | Subtotal, ODC | Subtotal, ODC |
Subcontracts Subcontracts Subcontracts Subcontracts
G&A G&A G&A G&A
Subtotal Subtotal Subtotal Subtotal
Profit / Fee Profit / Fee Profit / Fee Profit / Fee
| TOTAL | TOTAL | TOTAL | TOTAL |
| * as applicable | * as applicable | * as applicable | * as applicable |
| Option Period 7 | Option Period 8 | Option Period 9 | ||||||
| Element | Rates* | Proposed | Element | Rates* | Proposed | Element | Rates* | Proposed |
| Labor | Labor | Labor | ||||||
| Direct Labor | Direct Labor | Direct Labor | ||||||
| Labor Overhead | Labor Overhead | Labor Overhead | ||||||
| Labor, Management | Labor, Management | Labor, Management | ||||||
| Labor Overhead, Mgt | Labor Overhead, Mgt | Labor Overhead, Mgt | ||||||
| Subtotal, Labor | Subtotal, Labor | Subtotal, Labor |
| ODC | ODC | ODC |
| From FPIF CLINS | From FPIF CLINS | From FPIF CLINS |
| Gov't Auth Travel | Gov't Auth Travel | Gov't Auth Travel |
| CAP and Services | CAP and Services | CAP and Services |
| Local Purchase | Local Purchase | Local Purchase |
| Gov't Auth Training | Gov't Auth Training | Gov't Auth Training |
| Subtotal, ODC | Subtotal, ODC | Subtotal, ODC |
Subcontracts Subcontracts Subcontracts
G&A G&A G&A
Subtotal Subtotal Subtotal
Profit / Fee Profit / Fee Profit / Fee
| TOTAL | TOTAL | TOTAL |
| * as applicable | * as applicable | * as applicable |
CLIN Pricing
| CONTRACT PRICING BY CLIN | |||||||||||||||
| These cells must be must be populated from your proposal. Please use formulas that reference back to your proposal. It is best if these worksheets are incorporatetd into your proposal workbook. | |||||||||||||||
| Cells for FPIF CLINS should be Ceiling Price. Cells for CR CLINS should be Government provided amount Plus any Handling Fees. Cells for CPFF should be Estimated Cost Plus Fixed Fee. | |||||||||||||||
| CLIN | Sub-CLIN | Description | CLIN Type | Unit of Issue | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option Period 5 | Option Period 6 | Option Period 7 | Option Period 8 | Option Period 9 | TOTALS |
| 1001 | Phase In | ||||||||||||||
| 1001AA | Phase-In Army | FFP | Month | ||||||||||||
| 1001AB | Phase-in Air Force | FFP | Month | ||||||||||||
| X002 | Army Aviation Maintenance | ||||||||||||||
| X002AA | Aircraft Maintenance - Army | FPI(F) | Month | ||||||||||||
| X003 | Government Specifically Authorized Other Direct Costs - Army | ||||||||||||||
| X003AA | Travel - Army | CR | Job | ||||||||||||
| X003AB | Contractor Acq Prop (CAP) and Services | CR | Job | ||||||||||||
| X003AC | Local Purchase -Green Flt (CH47, UH60, AH64, OH58) | CR | Job | ||||||||||||
| X003AD | Local Purchase - Commercial Fleet | CR | Job | ||||||||||||
| X003AE | Training - Army | CR | Job | ||||||||||||
| X004 | Phase Out | ||||||||||||||
| X004AA | Phase-out Army | FFP | Month | ||||||||||||
| X004AB | Phase-out Air Force | FFP | Month | ||||||||||||
| X005 | Contractor Acquired Property (CAP) Delivery | NSP | |||||||||||||
| X006 | Air Force Maintenance | ||||||||||||||
| X006AA | Air Force Aviation Maintenance | FPI(F) | Month | ||||||||||||
| X007 | Government Specifically Authorized Other Direct Costs - Air Force | ||||||||||||||
| X007AA | Travel - Air Force | CR | Job | ||||||||||||
| X007AB | CAP and Services - Air Force | CR | Job | ||||||||||||
| X007AC | Local Purchase - Air Force | CR | Job | ||||||||||||
| X008 | National Maintenance Program (NMP) Labor | ||||||||||||||
| X008AA | NMP AMCOM T Labor | CPFF | Month | ||||||||||||
| X008AB | NMP AMCOM Z Labor | CPFF | Month | ||||||||||||
| X008AC | NMP TACOM T Labor | CPFF | Month | ||||||||||||
| X009 | National Maintenance (NMP) Program Parts | ||||||||||||||
| X009AA | NMP Legacy Parts | CR | Job | ||||||||||||
| X010 | Contract Data Requirement List (CDRL) Data | ||||||||||||||
| X010AA | CDRL - Army | FFP | Month | ||||||||||||
| X010AB | CDRL - Air Force | FFP | Month | ||||||||||||
| X011 | Contractor Manpower Reporting (CMR) | ||||||||||||||
| X011AA | Army CMR | FFP | Each | ||||||||||||
| X011AB | Air Force CMR | FFP | Each | ||||||||||||
| X012 | Incentive Fee (Army) | ||||||||||||||
| X012AA | 1st Quarter | CR | Quarter | ||||||||||||
| X012AB | 2nd Quarter | CR | Quarter | ||||||||||||
| X012AC | 3rd Quarter | CR | Quarter | ||||||||||||
| X012AD | 4th Quarter | CR | Quarter | ||||||||||||
| X013 | Incentive Fee (Air Force) | ||||||||||||||
| X013AA | 1st Quarter | CR | Quarter | ||||||||||||
| X013AB | 2nd Quarter | CR | Quarter | ||||||||||||
| X013AC | 3rd Quarter | CR | Quarter | ||||||||||||
| X013AD | 4th Quarter | CR | Quarter | ||||||||||||
| X014 | MI 17 Support | ||||||||||||||
| X014AA | MI 17 Labor | CPFF | Month | ||||||||||||
| X015 | Mi-17 Other Direct Costs | ||||||||||||||
| X015AA | MI 17 Parts | CR | Job | ||||||||||||
| X015AB | MI 17 Travel | CR | Job | ||||||||||||
| X015AC | Mi-17 Contractor Acquired Property or Services | CR | Job | ||||||||||||
| TOTAL AMOUNT | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL CONTRACT AMOUNT: $ - 0
DRAFT W9124G-16-R-0007
Fort Rucker Rotary Maintenance
Target-Share-Price-Fee
| BASE PERIOD | OPTION PERIOD 1 | OPTION PERIOD 2 | OPTION PERIOD 3 | OPTION PERIOD 4 | |||||||||||||||||||||||||||||||||||||||||||||
| [These cells must be filled in as applicable to CLIN type.] | [These cells must be filled in as applicable to CLIN type.] | [These cells must be filled in as applicable to CLIN type.] | [These cells must be filled in as applicable to CLIN type.] | [These cells must be filled in as applicable to CLIN type.] | |||||||||||||||||||||||||||||||||||||||||||||
| CLIN | Sub-CLIN | Description | CLIN Type | Unit of Issue | Target Cost (FPIF) | Target Profit (FPIF) | Target Price (FPIF) | Underrun Share Ratio: Contractor | Underrun Share Ratio: Govern-ment | Overrun Share Ratio: Contractor | Overrun Share Ratio: Govern-ment | Ceiling Price (FPIF) | Cost (CR & CPFF) | Fixed Fee (CPFF) / Mat Hand Fee (CR) | Firm Fixed Price (FFP) | Target Cost (FPIF) | Target Profit (FPIF) | Target Price (FPIF) | Underrun Share Ratio: Contractor | Underrun Share Ratio: Govern-ment | Overrun Share Ratio: Contractor | Overrun Share Ratio: Govern-ment | Ceiling Price (FPIF) | Cost (CR & CPFF) | Fixed Fee (CPFF) / Mat Hand Fee (CR) | Firm Fixed Price (FFP) | Target Cost (FPIF) | Target Profit (FPIF) | Target Price (FPIF) | Underrun Share Ratio: Contractor | Underrun Share Ratio: Govern-ment | Overrun Share Ratio: Contractor | Overrun Share Ratio: Govern-ment | Ceiling Price (FPIF) | Cost (CR & CPFF) | Fixed Fee (CPFF) / Mat Hand Fee (CR) | Firm Fixed Price (FFP) | Target Cost (FPIF) | Target Profit (FPIF) | Target Price (FPIF) | Underrun Share Ratio: Contractor | Underrun Share Ratio: Govern-ment | Overrun Share Ratio: Contractor | Overrun Share Ratio: Govern-ment | Ceiling Price (FPIF) | Cost (CR & CPFF) | Fixed Fee (CPFF) / Mat Hand Fee (CR) | Firm Fixed Price (FFP) | Target Cost (FPIF) |
| 1001 | Phase In | ||||||||||||||||||||||||||||||||||||||||||||||||
| 1001AA | Army Phase-In | FFP | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| 1001AB | Air Force Phase-In | FFP | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X002 | Army Aviation Maintenance | ||||||||||||||||||||||||||||||||||||||||||||||||
| X002AA | Army Aviation Maintenance | FPI(F) | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X003 | Army Other Direct Cost | ||||||||||||||||||||||||||||||||||||||||||||||||
| X003AA | Army Travel | CR | Job | $ 125,856.00 | $ 128,058.48 | $ 130,299.50 | $ 132,579.74 | ||||||||||||||||||||||||||||||||||||||||||
| X003AB | Army Contractor Acq Prop (CAP) and Srv | CR | Job | $ 14,682,897.00 | $ 14,939,847.70 | $ 15,201,295.03 | $ 15,467,317.70 | ||||||||||||||||||||||||||||||||||||||||||
| X003AC | Local Purchase -Green Flt (CH47, UH60, AH64, OH58) | CR | Job | $ 1,315,297.64 | $ 1,338,315.35 | $ 1,361,735.87 | $ 1,385,566.24 | ||||||||||||||||||||||||||||||||||||||||||
| X003AD | Army Local Purchase- Commericial | CR | Job | $ 21,900,000.00 | $ 22,283,250.00 | $ 22,673,206.88 | $ 23,069,988.00 | ||||||||||||||||||||||||||||||||||||||||||
| X003AE | Army Training | CR | Job | $ 250,000.00 | $ 254,375.00 | $ 258,826.56 | $ 263,356.03 | ||||||||||||||||||||||||||||||||||||||||||
| X004 | Phase Out | ||||||||||||||||||||||||||||||||||||||||||||||||
| X004AA | Phase-out Army | FFP | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X004AB | Phase-out Air Force | FFP | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X005 | Contractor Acquired Property Delivery | NSP | |||||||||||||||||||||||||||||||||||||||||||||||
| X006 | Air Force Aviation Maintenance | ||||||||||||||||||||||||||||||||||||||||||||||||
| X006AA | Air Force Aviation Maintenance | FPI(F) | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X007 | Air Force Other Direct Cost | ||||||||||||||||||||||||||||||||||||||||||||||||
| X007AA | Air Force Travel | CR | Job | $ 30,000.00 | $ 30,525.00 | $ 31,059.19 | $ 31,602.72 | ||||||||||||||||||||||||||||||||||||||||||
| X007AB | Air Force CAP and Services | CR | Job | $ 150,000.00 | $ 152,625.00 | $ 155,295.94 | $ 158,013.62 | ||||||||||||||||||||||||||||||||||||||||||
| X007AC | Air Force Local Purchase | CR | Job | $ 1.00 | $ 1.02 | $ 1.04 | $ 1.05 | ||||||||||||||||||||||||||||||||||||||||||
| X008 | National Maintenance Program (NMP) Labor | ||||||||||||||||||||||||||||||||||||||||||||||||
| X008AA | NMP AMCOM T Labor | CPFF | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X008AB | NMP AMCOM Z Labor | CPFF | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X008AC | NMP TACOM T Labor | CPFF | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X009 | NMP Parts | ||||||||||||||||||||||||||||||||||||||||||||||||
| X009AA | NMP Legacy Parts | CR | Job | $ 75,000.00 | $ 76,312.50 | $ 77,647.97 | $ 79,006.81 | ||||||||||||||||||||||||||||||||||||||||||
| X010 | Contract Data Requirement List (CDRL) Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| X010AA | Data Item Descriptions – Army | FFP | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X010AB | Data Item Descriptions – Air Force | FFP | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X011 | Contractor Manpower Reporting (CMR) | ||||||||||||||||||||||||||||||||||||||||||||||||
| X011AA | Army CMR | FFP | Each | ||||||||||||||||||||||||||||||||||||||||||||||
| X011AB | Air Force CMR | FFP | Each | ||||||||||||||||||||||||||||||||||||||||||||||
| X012 | Incentive Fee (Army) | ||||||||||||||||||||||||||||||||||||||||||||||||
| X012AA | 1st Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X012AB | 2nd Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X012AC | 3rd Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X012AD | 4th Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X013 | Incentive Fee (Air Force) | ||||||||||||||||||||||||||||||||||||||||||||||||
| X013AA | 1st Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X013AB | 2nd Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X013AC | 3rd Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X013AD | 4th Quarter | CR | Quarter | ||||||||||||||||||||||||||||||||||||||||||||||
| X014 | MI 17 Support | ||||||||||||||||||||||||||||||||||||||||||||||||
| X014AA | MI 17 Labor | CPFF | Month | ||||||||||||||||||||||||||||||||||||||||||||||
| X015 | Mi-17 Other Direct Costs | ||||||||||||||||||||||||||||||||||||||||||||||||
| X015AA | MI 17 Parts | CR | Job | $ 1,321,512.00 | $ 1,344,638.46 | $ 1,368,169.63 | $ 1,392,112.60 | ||||||||||||||||||||||||||||||||||||||||||
| X015AB | MI 17 Travel | CR | Job | $ 1.00 | $ 1.02 | $ 1.04 | $ 1.05 | ||||||||||||||||||||||||||||||||||||||||||
| X015AC | Mi-17 Contractor Acquired Property or Services | CR | Job | $ 1.00 | $ 1.02 | $ 1.04 | $ 1.05 | ||||||||||||||||||||||||||||||||||||||||||
| TOTAL AMOUNT EachColumn |
Rates
| There is no specific format or content for this required worksheet. |
| The offeror should list all rates used in the contractor's proposal spreadsheet. These rates may include G&A, Material Handling, labor overheads, subcontractor overheads, profit / fee, and any other applicable rates. |
The cells in this worksheet where rates have been entered must be the 'controlling' cells. Changing or adjusting the rates in the cells in this worksheet should have a global effect on the proposal.
Fixed Price Incentive (Firm Target) (FPIF): this worksheet should also contain the offeror proposed underrun ratio, overrun ratio, target cost, target profit, target price, ceiling price, and the Point of Total Assumption (Please show formulas).
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .