S-2 Price Data Breakdown DDB SERM-506-24.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- N4002724R0001
About this file
This document includes a price data breakdown spreadsheet and solicitation for repair and modernization services for the USS DELBERT D BLACK. The Navy seeks a firm-fixed price contract for repairs to hull, mechanical, electrical, electronic, equipment, and components, as well as preservation work. The solicitation is full and open competition under NAICS code 336611. Offerors must perform the work at Naval Station Mayport, Florida from October 2024 to February 2025. The spreadsheet is a template for offerors to provide labor hours, rates, materials, and pricing for base and option work, line of effort changes, and growth pricing. The Navy intends to award by January 2023 to the lowest priced technically acceptable offeror meeting the solicitation's requirements.
View the file
Other files
Show all 28
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: | USS DELBERT D BLACK (DDG 119) | Start: | 10/7/24 | ||||||||||||||||
| SSP: | SERM-506-24 ISRA | End: | 2/26/25 | ||||||||||||||||
| Company | |||||||||||||||||||
| Enter a value in all Prime and Subcontractor Columns | |||||||||||||||||||
| CLIN | Work Item | Type | Prime | Subcontractor | Total Base | Total Option | Prime Bid Rate* | Prime Mat Burden Rate* | Sub Bid Rate | Subcontractor Burden Rate* | |||||||||
| Labor Hours | Labor Dollars | Material | Material Burden ($) | Prime Subtotal | Labor Hours | Labor Dollars | Material | Subcontractor Burden ($) | Subcontractor Subtotal | ||||||||||
| 0001 | 000-00-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | Base | ||||
| 0001 | 042-00-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | Option | ||||
| 0001 | 123-00-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 123-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 165-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 241-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 245-00-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 251-32-002 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 251-32-003 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 259-10-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 259-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 441-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 512-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 513-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 513-11-002 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 513-11-003 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 514-00-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 514-20-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 571-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 588-21-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 593-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 622-12-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 624-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 625-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 631-11-002 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 721-31-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 721-31-002 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 980-10-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 980-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 982-31-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 992-11-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 992-31-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 993-00-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0001 | 998-41-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0002 | 456-90-001 | Base | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0003 | 130-11-001 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0004 | 167-80-001 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0005 | 167-80-002 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0006 | 167-80-003 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0007 | 583-11-001 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0008 | 593-11-002 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0009 | 980-90-001 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0010 | 980-90-002 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0011 | 980-90-003 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0012 | 980-90-004 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0013 | 980-90-005 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0014 | 980-90-006 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0015 | 980-90-007 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0016 | 980-90-008 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0017 | 980-90-009 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0018 | 980-90-010 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0019 | 980-90-011 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0020 | 980-90-012 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0021 | 980-90-013 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0022 | 980-90-014 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0023 | 980-90-015 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0024 | 980-90-016 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | |||||
| 0025 | 980-90-017 | Option | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
Subtotals - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
| Section B, Note B LOE2C | Work Item CLINs | Labor Hours | Labor Rate* | Total Labor | Material | Material Burden* | Total Material | Total LOE2C | ||
| 0026 | LOE2C | Option | 0001 | 1,359 | $ - 0 | $ - 0 | $ 76,795.88 | 0.00% | $0.00 | $0.00 |
| 0027 | LOE2C | Option | 0002 | 164 | $ - 0 | $ - 0 | $ 9,257.85 | 0.00% | $0.00 | $0.00 |
| 0028 | LOE2C | Option | 0003 0004 0005 0006 0007 0008 | 1,136 | $ - 0 | $ - 0 | $ 64,178.13 | 0.00% | $0.00 | $0.00 |
| 0029 | LOE2C | Option | 0009 | 97 | $ - 0 | $ - 0 | $ 5,466.62 | 0.00% | $0.00 | $0.00 |
| 0030 | LOE2C | Option | 0010 | 18 | $ - 0 | $ - 0 | $ 1,043.50 | 0.00% | $0.00 | $0.00 |
| 0031 | LOE2C | Option | 0011 | 15 | $ - 0 | $ - 0 | $ 859.03 | 0.00% | $0.00 | $0.00 |
| 0032 | LOE2C | Option | 0012 | 14 | $ - 0 | $ - 0 | $ 807.55 | 0.00% | $0.00 | $0.00 |
| 0033 | LOE2C | Option | 0013 | 18 | $ - 0 | $ - 0 | $ 1,016.89 | 0.00% | $0.00 | $0.00 |
| 0034 | LOE2C | Option | 0014 | 12 | $ - 0 | $ - 0 | $ 656.50 | 0.00% | $0.00 | $0.00 |
| 0035 | LOE2C | Option | 0015 | 11 | $ - 0 | $ - 0 | $ 621.00 | 0.00% | $0.00 | $0.00 |
| 0036 | LOE2C | Option | 0016 | 29 | $ - 0 | $ - 0 | $ 1,654.02 | 0.00% | $0.00 | $0.00 |
| 0037 | LOE2C | Option | 0017 | 233 | $ - 0 | $ - 0 | $ 13,176.61 | 0.00% | $0.00 | $0.00 |
| 0038 | LOE2C | Option | 0018 | 34 | $ - 0 | $ - 0 | $ 1,924.49 | 0.00% | $0.00 | $0.00 |
| 0039 | LOE2C | Option | 0019 | 24 | $ - 0 | $ - 0 | $ 1,332.72 | 0.00% | $0.00 | $0.00 |
| 0040 | LOE2C | Option | 0020 | 58 | $ - 0 | $ - 0 | $ 3,251.88 | 0.00% | $0.00 | $0.00 |
| 0041 | LOE2C | Option | 0021 | 46 | $ - 0 | $ - 0 | $ 2,576.16 | 0.00% | $0.00 | $0.00 |
| 0042 | LOE2C | Option | 0022 | 7 | $ - 0 | $ - 0 | $ 392.22 | 0.00% | $0.00 | $0.00 |
| 0043 | LOE2C | Option | 0023 | 18 | $ - 0 | $ - 0 | $ 1,009.06 | 0.00% | $0.00 | $0.00 |
| 0044 | LOE2C | Option | 0024 | 5 | $ - 0 | $ - 0 | $ 256.54 | 0.00% | $0.00 | $0.00 |
| 0045 | LOE2C | Option | 0025 | 21 | $ - 0 | $ - 0 | $ 1,207.91 | 0.00% | $0.00 | $0.00 |
| Subtotals | 3,319 | $0.00 | $ 187,484.56 | $0.00 | $0.00 |
| Evaluted Price for Growth/New Work Ship Repair Rates** | ||||||
| Labor Hours | Labor ($) | Material | Material Burden ($) | Total Growth/New Work Ship Repair Rates | Prime Labor Rate* | Prime Mat Burden Rate* |
| 1,461 | $0.00 | $79,146.92 | $0.00 | $79,146.92 | $0.00 | 0.00% |
| The excel file has imbedded formulas. Offerors shall insert proposed rates in the highlighted cells in the format provided, with the formulas maintained. | ||
| Total Base Price | $0.00 | |
| Total Option Price | $0.00 | |
| *Labor and Material/Subcontractor burden rates shall not exceed the ceiling rates in the basic contract. Burden dollars must be separated. | Total Evaluated Price*** | $79,146.92 |
**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. ***Total Evaluated Price is the sum of all Base, Options, LOE2C, and Growth Pricing.
&"Times New Roman,Regular"&10&P of &N &"Times New Roman,Regular"&10S-2
Sheet1
| 1,359 | $76,795.88 |
| 209 | $11,834.01 |
| 125 | $7,054.42 |
| 168 | $9,490.02 |
| 152 | $8,588.28 |
| 91 | $5,136.70 |
| 234 | $13,232.04 |
| 366 | $20,676.67 |
| 97 | $5,466.62 |
| 18 | $1,043.50 |
| 15 | $859.03 |
| 14 | $807.55 |
| 18 | $1,016.89 |
| 12 | $656.50 |
| 11 | $621.00 |
| 29 | $1,654.02 |
| 233 | $13,176.61 |
| 34 | $1,924.49 |
| 24 | $1,332.72 |
| 58 | $3,251.88 |
| 7 | $392.22 |
| 18 | $1,009.06 |
| 5 | $256.54 |
| 21 | $1,207.91 |
File details come from the government source that posted it. Updated .