Attachment_5_NEW__5-2-17.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- Installation Support Services for Yuma Proving Ground, AZ Federal contract opportunity
- Solicitation number
- W9124R-15-R-0001
About this file
Revised Attachment #5
View the file
Other files for this federal contract opportunity
Show all 50
Installation Support Services for Yuma Proving Ground, AZ has more files on GovTribe.
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
CostPrice Rollup
| Solicitation Number: |
| 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 |
| Material |
| Material Handling |
| Travel |
| 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 |
| Material | Material | Material | Material |
| Material Handling | Material Handling | Material Handling | Material Handling |
| Travel | Travel | Travel | Travel |
| 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 | ||||
| Element | Rates* | Proposed | Element | Rates* | Proposed |
| Labor | Labor | ||||
| Direct Labor | Direct Labor | ||||
| Labor Overhead | Labor Overhead | ||||
| Labor, Management | Labor, Management | ||||
| Labor Overhead, Mgt | Labor Overhead, Mgt | ||||
| Subtotal, Labor | Subtotal, Labor |
| ODC | ODC |
| Material | Material |
| Material Handling | Material Handling |
| Travel | Travel |
| Subtotal, ODC | Subtotal, ODC |
| Subcontracts | Subcontracts |
| G&A | G&A |
Subtotal Subtotal
Profit / Fee Profit / Fee
| TOTAL | TOTAL |
| * as applicable | * as applicable |
CLIN Pricing
| CONTRACT PRICING BY CLIN | ||||||||||
| These cells must be must be populated from your proposal with direct links to the data. Please use formulas that reference back to your proposal. It is best if these worksheets are incorporatetd into your proposal workbook. | ||||||||||
| Cells for FFP CLINs should be the total proposed price for the year. Cells for CR CLINS should be Government provided amount Plus any indirect Fees. | ||||||||||
| CLIN | Sub-CLIN | Description | CLIN Type | Unit of Issue | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | TOTALS |
| 1001 | ||||||||||
| 1001AA | Operations Staffing | FFP | Month | $ - 0 | ||||||
| X002 | ||||||||||
| X002AA | Preventive Maintenance | FFP | Month | $ - 0 | ||||||
| X003 | ||||||||||
| X003AA | Emergency Services Orders | FFP | Each | $ - 0 | ||||||
| X004 | ||||||||||
| X004AA | Emergency Repair | FFP | Each | $ - 0 | ||||||
| X005 | ||||||||||
| X005AA | Negotiated IJOs-Construction | FFP | Each | $ - 0 | ||||||
| X006 | ||||||||||
| X006AA | Negotiated IJOs-Services | FFP | Each | $ - 0 | ||||||
| X007 | ||||||||||
| X007AA | Pest Control | FFP | Month | $ - 0 | ||||||
| X008 | ||||||||||
| X008AA | Grounds Maintenance | FFP | Month | $ - 0 | ||||||
| X009 | ||||||||||
| X009AA | Reimbursables | COST | Each | $ - 0 | ||||||
| X010 | ||||||||||
| X010AA | Delivery of CAP - Material | FFP | Each | $ - 0 | ||||||
| X011 | ||||||||||
| X011AA | Delivery of CAP - Equipment | FFP | Each | $ - 0 | ||||||
| X012 | ||||||||||
| X012AA | Contractor Manpower Reporting | FFP | Each | $ - 0 | ||||||
| X013 | ||||||||||
| X013AA | Phase - IN | FFP | Each | |||||||
| TOTAL AMOUNT | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| $ - 0 |
DRAFT W9124G-16-R-0007
Fort Rucker Rotary Maintenance
Summary
BASE YEAR Option 1 Option 2 Option 3 Option 4 TOTAL ALL YEARS
| CLIN | Description | CLIN Type | Unit of Issue | Cost (CR) Plug Numbers | Cost Indirect fees/cost | Firm Fixed Price (FFP) | Cost (CR) Plug Numbers | Cost Indirect fees/cost | Firm Fixed Price (FFP) | Cost (CR) Plug Numbers | Cost Indirect fees/cost | Firm Fixed Price (FFP) | Cost (CR) Plug Numbers | Cost Indirect fees/cost | Firm Fixed Price (FFP) | Cost (CR) Plug Numbers | Cost Indirect fees/cost | Firm Fixed Price (FFP) | Cost (CR) Plug Numbers | Cost Indirect fees/cost | Firm Fixed Price (FFP) | |
| X001 | ||||||||||||||||||||||
| 1001AA | Operations Staffing | FFP | Month | $0 | ||||||||||||||||||
| X002 | ||||||||||||||||||||||
| X002AA | Preventive Maintenance | FFP | Month | $0 | ||||||||||||||||||
| X003 | ||||||||||||||||||||||
| X003AA | Emergency Services Orders | FFP | Each | $0 | ||||||||||||||||||
| X004 | ||||||||||||||||||||||
| X004AA | Emergency Repair | FFP | Each | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $5,000,000 | |||||||||||||
| X005 | ||||||||||||||||||||||
| X005AA | Negotiated IJOs-Construction | FFP | Each | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $500,000 | |||||||||||||
| X006 | ||||||||||||||||||||||
| X006AA | Negotiated IJOs-Services | FFP | Each | $750,000 | $750,000 | $750,000 | $750,000 | $750,000 | $3,750,000 | |||||||||||||
| X007 | ||||||||||||||||||||||
| X007AA | Pest Control | FFP | Month | |||||||||||||||||||
| X008 | ||||||||||||||||||||||
| X008AA | Grounds Maintenance | FFP | Month | |||||||||||||||||||
| X009 | ||||||||||||||||||||||
| X009AA | Reimbursables | COST | Each | $1,075,000 | $1,075,000 | $1,075,000 | $1,075,000 | $1,075,000 | $5,375,000 | |||||||||||||
| X010 | ||||||||||||||||||||||
| X010AA | Delivery of CAP - Material | FFP | Each | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $250,000 | |||||||||||||
| X011 | ||||||||||||||||||||||
| X011AA | Delivery of CAP - Equipment | FFP | Each | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $250,000 | |||||||||||||
| X012 | ||||||||||||||||||||||
| X012AA | Contractor Manpower Reporting | FFP | Each | |||||||||||||||||||
| X013 | ||||||||||||||||||||||
| X013AA | Phase - IN | FFP | Each | $0 | ||||||||||||||||||
| TOTAL AMOUNT EachColumn | $1,075,000 | $0 | $1,950,000 | $1,075,000 | $0 | $1,950,000 | $1,075,000 | $0 | $1,950,000 | $1,075,000 | $0 | $1,950,000 | $1,075,000 | $0 | $1,950,000 | $5,375,000 | $0 | $19,425,000 |
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.
IJO Burdened Rates There is no specific format or content for this required worksheet.
The offeror shall provide fully burdened rates for all proposed labor categories detailed in Section L 3.3.3. These rates will be used in the pricing/negotiation of Negotiated Individual Job Orders (IJO) - Services. The fully burdened rate shall include all direct and indirect rates, taxes and fringe associated with employee costs.
File details come from the government source that posted it. Updated .