Attachment 3 - Operational Foreseeable Cost.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- DRYDOCK: USCGC FREDERICK HATCH DD FY25 Federal contract opportunity
- Solicitation number
- 70Z08025QPBPL0002
About this file
This is an operational cost calculation spreadsheet detailing the transit costs for moving Coast Guard vessels between different locations, specifically focusing on the USCGC FREDERICK HATCH's movement to dry dock facilities. The spreadsheet breaks down costs for Fast Response Cutters (FRC) and National Security Cutters (WMSL) at $536 and $3,055 per hour respectively, with nautical mile rates of $51.04 and $311.76.
The calculations assume a 12-knot transit speed and include 72 rest hours per leg (3 days). Key routes and costs include Guam to Hawaii ($708,538.67), Hawaii to California ($5,062,531.97), and Washington ($5,213,866.42). The document specifically notes that FRCs traveling from Guam to CONUS must first stop in Hawaii and require a WMSL escort for the remainder of the journey, with total costs accumulating for each required stop along the route.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 70Z08025QPBPL00020004_US signed.pdf | ||
| Attachment1 Schedule of Services_Rev HATCH DD.xlsx | XLSX spreadsheet | |
| 70Z08025QPBPL00020003.pdf | ||
| QUESTIONS_ANSWERS.pdf | ||
| 70Z08025QPBPL00020002_US HATCH signed.pdf | ||
| Attachment 1 Schedule of Services_Rev.xlsx | XLSX spreadsheet | |
| 70Z08025QPBPL00020001_US HATCH Amendment signed.pdf | ||
| Schedule of Services - CGC FREDERICK HATCH DD.xlsx | XLSX spreadsheet | |
| 5. FREDERICK HATCH (WPC 154) DRYDOCK REV 0.pdf | ||
| 70Z08025QPBPL0002_0_US COMBINED SYNOPSIS SOLICITATION FREDERICK HATCH DD REPAIRS.pdf |
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
Sheet1
| FRC Move Cost | Foreseeable Costs | |||||||||
| $536 | per hour | Per DD | Combined DDs | |||||||
| $51.04 | per nm | Hawaii | $708,538.67 | $1,417,077.33 | ||||||
| California | $5,062,531.97 | $10,125,063.93 | ||||||||
| WMSL Move Cost | Washington | $5,213,866.42 | $10,427,732.84 | |||||||
| $3,055 | per hour | |||||||||
| $311.76 | per nm | |||||||||
| (Each way) | (Both Directions | (Each Way) | (Both directions) | Cost per Hour | Cost per nm | |||||
| Guam to HI | 3,500 | nm | 7000 | nm | 291.67 | hours | 583.33 | hours | $351,258.67 | $357,280.00 |
| HI to CA (FRC) | 3,093 | nm | 6186 | nm | 257.75 | hours | 515.5 | hours | $314,900 | $315,733.44 |
| HI to CA (WMSL) | 3,093 | nm | 6186 | nm | 257.75 | hours | 515.5 | hours | $1,794,812.50 | $1,928,547.36 |
| CA to WA | 589 | nm | 1178 | nm | 49.08 | hours | 98.17 | hours | $91,209.33 | $60,125.12 |
| **Assume 12 knots transit speed | 72 | rest hours/leg |
| (3 days) |
OP FORESEEABLE
| OPERATIONAL FORESEEABLE COST | |||
| FRC Move Cost | Foreseeable Costs | ||
| $536 | per hour | Per DD | |
| $51.04 | per nm | Hawaii | $708,538.67 |
| CONUS Shipyard | $747,130.67 |
| Each way | Both Directions | Each Way | Both Directions | Cost per Hour | Cost per nm | |||||
| Guam to HI | 3,500 | nm | 7000 | nm | 291.67 | hours | 583.33 | hours | $351,258.67 | $357,280.00 |
| HI to XY (FRC) | nm | 0 | nm | 0 | hours | 0 | hours | $38,592.00 | $0.00 | |
| XY Shipyard to AB |
| **Assume 12 knots transit speed | 72 | rest hours/leg |
| (3 days) | ||
| In order for an FRC to reach the Continental United States (CONUS) from Guam it must first travel to Hawaii. From Hawaii the FRC will require a WMSL escort to any CONUS shipyard. Use the information above to calculate the cost for an FRC to travel from Guam to the proposed shipyard. Some CONUS locations such as Washington will require an additional stop. IE Hawaii to California to Washington. Your total foreseeable costs will be the total for all stops required. |
File details come from the government source that posted it. Updated .