S-2 Cost Data Break Down YFNX-20 SERM-024-24.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- U. S. NAVY BARGE YFNX-20 NPTU SOLICITATION
- Solicitation number
- N40027-23-R-0010
About this file
This document contains a cost data breakdown template for the solicitation N40027-23-R-0010 from the Department of the Navy Naval Sea Systems Command for ship repair services for barge YFNX-20. The template requires offerors to provide labor rates, material rates, labor hours and costs, material costs, and overhead rates for line items for base and option years of work. The total evaluated price will be calculated from the proposed rates and estimates of growth work hours and materials. Offerors must maintain the embedded formulas when entering proposed rates in the highlighted cells.
View the file
Other files
Show all 29
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
Total Evaluated Price
| ATTACHMENT S-2 | |||||||||||||||||
| Ship: | YFNX-20 | Start: | 11/27/23 | ||||||||||||||
| SSP: | SERM-024-24 | End: | 4/26/24 | ||||||||||||||
| Company | |||||||||||||||||
| Enter a value in all Prime and Subcontractor Columns | |||||||||||||||||
| CLIN/ SLIN | Work Item | Type | Prime | Subcontractor | Subcontractor Burden* | Total Base | Total Option | Prime Bid Rate | Prime Mat Burden Rate | Sub Bid Rate | Subcontractor Burden Rate | ||||||
| Labor Hours | Labor Dollars | Material | Material Burden* | Labor Hours | Labor Dollars | Material | |||||||||||
| 0001 | 000-00-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | Base | ||||||||
| 0001 | 042-00-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | Option | ||||||||
| 0001 | 110-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 123-00-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 150-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0003 | 167-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0004 | 324-10-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 436-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 514-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0005 | 522-10-001 | Option | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 582-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0006 | 593-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 612-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0007 | 623-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 634-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0008 | 635-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0009 | 644-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0010 | 651-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0011 | 992-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 992-11-002 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0001 | 992-11-003 | Option | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0012 | 992-11-004 | Option | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0013 | 997-11-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| 0014 | 998-41-001 | Base | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||||||
| $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||||||||
| Subtotals | - 0 | $0.00 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Evaluted Price for Growth/New Work Ship Repair Rates** | ||||||
| Category | RFP Section B, Note A Growth/New Work Ship Repair Rates | Estimated Growth and New Work Hours and Material Costs | Total Calculation | *This is the burden in dollar amount. This amount will be automatically calculated once the contractor enters a material burden rate in Columns P and R. Material burden rate shall not exceed the ceiling rate in the basic contract. Burden dollars must be separated. | ||
| Proposed Labor Rate ($): | 400 | $0.00 | ||||
| Material ODC Rates (%): | $5,000.00 | $5,000.00 | ||||
| Total Growth Work Price | $ 5,000.00 | |||||
| NOTE: The excel file has imbedded formulas. Offeror shall insert proposed rates in the highlighted cells in the format provided, with the formulas maintained. | ||||||
| Total Base | $0.00 | |||||
| Total Option | $0.00 | |||||
| **The number of hours and material dollar values are for evaluation purposes only. The proposed labor and material burden rates will be the fixed rates for the entire availability regardless of how many hours and how much material are procured for growth or new work. | Eval Growth | $5,000.00 | ||||
| Total Evaluated Price | $5,000.00 |
&"Times New Roman,Regular"&10&P of &N &"Times New Roman,Regular"&10S-2
File details come from the government source that posted it. Updated .