4.02 J-1 Pricing Breakdown.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- MSC SHIP REPAIR VR
- Solicitation number
- N6817126QN020
About this file
This is a J-1 Pricing Breakdown template for a voyage repair availability (VRA) project for the USNS Arctic at Limassol, Cyprus under solicitation N6817126QN020. The pricing template is structured to capture Category A definitized work items with firm fixed pricing, including labor hours, labor rates, direct labor costs, equipment and material costs, travel expenses, and subcontractor pricing. The template requires contractors to input information only in designated highlighted cells (blue for prime contractor, yellow for subcontractor) and includes automatic formula calculations for work item totals and proposal total evaluated price.
The template accommodates multiple pricing components including direct labor with hourly rates, CFM/equipment and material costs, travel and other direct costs (ODCs), and subcontractor labor and equipment costs. A separate Travel Expenses Breakdown section captures per diem calculations based on personnel count, number of days, and specific categories including airfare, lodging, meals and incidentals, and rental car/transportation. The template also requires submission of indirect rates for General & Administrative (G&A), Overhead, and Profit, though these are noted as informational only and not evaluated separately from the total evaluated price. The current spreadsheet shows minimal pricing entries with a proposal total evaluated price of $19,425.00, indicating this is either a blank template or preliminary submission stage.
View the file
Other files
Show all 15
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
J-1 PRICE BREAKDOWN
| N6817126QN020 - USNS ARTIC Voyage Repair, Limassol, Cyprus. | ||||||||||||
| Work Item # | Title | Labor Hours | Labor Rate | Direct Labor Total Price | CFM/Equipment & Material Total Price | Travel | Other Direct Costs | Sub Contractor Direct Man Hours | Sub Contractor Labor Rate | Sub Contractor Direct Labor Total Price | SUB Contractor Equipment & Material Total Price | WORK ITEM TOTAL |
| 0135 | Deck guard Rail Renewal | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0001 | 0001_NSP_TAOE-SCOPE_GENERAL_REQUIREMENTS_AND_DEFINITIONS | NOT SEPARATELY PRICE | ||||||||||
| 0002 | 0002_NSP_TAOE-TECHNICAL_AND_MANUFACTURES_REPRESENTATIVE | |||||||||||
| 0004 | 0004_NSP_TESTING_AND_QUALITY_ASSURANCE | |||||||||||
| 0005 | 0005_NSP_TAOE_SWI_ELECTRICAL_SAFETY_PROCEDURE_REQUIREMENTS | |||||||||||
| 0020 | 0020_A_TAOE-SWI-GAS_FREE_CERTIFICATES | |||||||||||
| CLIN 0001 – Voyage Repair Category A Work Items | $ - 0 | |||||||||||
| Additional Government Requirements (AGR) | Government Requirement | Proposed Rate | ||||||||||
| LABOR HOURS | 300 | $ - 0 | $ - 0 | |||||||||
| SUBCONTRACTOR / MATERIAL | $ 19,425.00 | 0% | $ 19,425.00 | |||||||||
| CLIN 0002 – (Option) Additional Government Requirements (AGR) | $ 19,425.00 | |||||||||||
| PROPOSAL TOTAL EVALUATED PRICE | $ 19,425.00 |
| Indirect Rates |
| General & Administrative (G&A) |
| Overhead |
| Profit |
| 1. Only insert information in the highlighted cells: blue for prime, yellow for subcontractor |
| 2. For AGR rates, provide proposed labor rate for LABOR HOURS requirement and proposed burdened percentage for SUBCONTRACTOR / MATERIAL requirement. |
| 3. Provide indirect rates. Rates are for information purposes only and will not be evaluated separately from Total Evaluated Price. |
| 4. WORK ITEM TOTAL COLUMNS ARE FORMULAS. DO NOT ENTER INFORMATION OR ALTER THIS FORMULA. |
| 5. Proposal Total Price, gray shaded at bottom of sheet, is also a FORMULA - DO NOT ENTER INFORMATION or ALTER THIS FORMULA. |
| 6. ODC-Defined as anything not directly attributable to a final cost or production objective (i.e., labor, subcontracts, and/or material). Examples include rental charges, special tooling, testing equipment, etc. |
| 7. Travel costs should sum to total provided in 'TRAVEL EXPENSE BREAKDOWN' tab. |
J-1 TRAVEL EXPENSES BREAKDOWN
J-1 Travel Expenses Breakdown Prices in USD
| DESCRIPTION | NO. OF PERSONNEL | NO. OF DAYS | TRAVEL HRS | HOURLY RATE | TOTAL TRAVEL LABOR PRICE |
| TRAVEL EXPENSES | $ - 0 | $ - 0 |
| AIRFARE | LODGING | MEALS and INCIDENTALS | RENTAL CAR / TRANSPORTATION | TOTAL PER DIEM PRICE |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL TRAVEL PRICE $ - 0
File details come from the government source that posted it. Updated .