4.02 J-1 Pricing Breakdown.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
MSC SHIP REPAIR VR
Solicitation number
N6817126QN020
Issued by

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 #TitleLabor HoursLabor RateDirect Labor Total PriceCFM/Equipment & Material Total PriceTravelOther Direct CostsSub Contractor Direct Man HoursSub Contractor Labor RateSub Contractor Direct Labor Total PriceSUB Contractor Equipment & Material Total PriceWORK ITEM TOTAL
0135Deck guard Rail Renewal0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0$ - 0$ - 0$ - 0
00010001_NSP_TAOE-SCOPE_GENERAL_REQUIREMENTS_AND_DEFINITIONSNOT SEPARATELY PRICE
00020002_NSP_TAOE-TECHNICAL_AND_MANUFACTURES_REPRESENTATIVE
00040004_NSP_TESTING_AND_QUALITY_ASSURANCE
00050005_NSP_TAOE_SWI_ELECTRICAL_SAFETY_PROCEDURE_REQUIREMENTS
00200020_A_TAOE-SWI-GAS_FREE_CERTIFICATES
CLIN 0001 – Voyage Repair Category A Work Items$ - 0
Additional Government Requirements (AGR)Government RequirementProposed Rate
LABOR HOURS300$ - 0$ - 0
SUBCONTRACTOR / MATERIAL$ 19,425.000%$ 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

DESCRIPTIONNO. OF PERSONNELNO. OF DAYSTRAVEL HRSHOURLY RATETOTAL TRAVEL LABOR PRICE
TRAVEL EXPENSES$ - 0$ - 0
AIRFARELODGINGMEALS and INCIDENTALSRENTAL CAR / TRANSPORTATIONTOTAL PER DIEM PRICE
$ - 0$ - 0$ - 0$ - 0$ - 0

TOTAL TRAVEL PRICE $ - 0

File details come from the government source that posted it. Updated .