7-Attachment C Seawall Cost Proposal Workbook Final.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- 552409
- Issued by
- Wayne County, Detroit City, Michigan
About this file
This is a cost proposal workbook for seawall assessment, design, installation, repair, and replacement services for the City of Detroit, Michigan, Office of Contracting and Procurement on behalf of the Human, Homeless, and Family Services Division (Bridging Neighborhoods). The RFP solicits proposals for comprehensive seawall services at properties in the Jefferson-Chalmers neighborhood over a two-year contract period. Services are organized into five primary categories: Category A (Condition Assessment at a fixed fee per property), Category B (Engineering Design including site survey and geotechnical investigation), Category C (Permitting Support per application package), Category D (Construction by wall type and scope), and ancillary services including tieback/anchor assemblies, friction pile anchors, and dock demolition. The workbook includes estimated quantities for evaluation purposes only: nine properties for Categories A–C, 638 linear feet of seawall construction, 47 tieback/anchor assemblies, 260 linear feet of friction pile anchors, and 120 square feet of dock demolition area. Construction scopes are differentiated by steel sheet pile grade (Light-Duty Residential and Heavy-Duty Commercial-Grade) and type (New Installation, Repair/Raising, and Full Replacement), with separate unit pricing for each combination. The proposal requires completion of mandatory site walks for designated properties and submission of a single, unified cost total for evaluation.
Proposers must submit unit prices in dollars per linear foot for steel sheet pile construction, fixed fees for assessment and design services, and hourly rates for out-of-scope labor across eight categories (Principal/Professional Engineer, Project Manager, Field Technician/Inspector, Construction Superintendent, Equipment Operator, Laborer, Diver, and CAD/Drafting). Mobilization costs are quoted separately for three site-access tiers: Standard Land-Access, Marine/Barge-Access, and Restricted-Access. The workbook applies uniform estimated quantities across all proposals to enable comparable scoring; actual payment on task orders will be based on verified as-built quantities at the quoted unit prices. An optional Canal Property Owner Discount is available as an informational element only and does not affect the total proposed cost or scoring. Reimbursable agency permit fees are reimbursed at cost per task order and are not included in the scored total. The cost proposal summary automatically calculates the total proposed cost by multiplying unit prices and fees by the City's predetermined estimated quantities.
View the file
Other files
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
Cost Proposal Summary
| Cost Proposal — Summary | |||||
| Seawall Assessment, Design, Installation, Repair, and Replacement Services — RFP No. [INSERT] | |||||
| Proposer / Firm Name: | |||||
| Subconsultant/Subcontractor Firm Name (if applicable): | |||||
| No. | Pricing Element | Basis | Unit Price ($) | Est. Quantity | Amount ($) |
| 1 | Category A — Condition Assessment (fixed fee per property) | See 'Fixed Fees & Rates' tab | $0.00 | 9 properties | $0.00 |
| 2 | Category B — Engineering Design | See 'Fixed Fees & Rates' tab | $0.00 | 9 properties | $0.00 |
| 3 | Category C — Permitting Support (per application package) | See 'Fixed Fees & Rates' tab | $0.00 | 9 packages | $0.00 |
| 4 | Category D — Construction (unit prices by wall type) | See 'Unit Price Schedule' tab — Estimated Cost Worksheet total | varies by grade/scope | 638 LF | $0.00 |
| 5 | Tieback/Anchor Assembly (Category D) | See 'Unit Price Schedule' tab — Tieback/Anchor Estimated total | $0.00 | 47 EA | $0.00 |
| 6 | Friction Pile Anchor (Category D, alternate) | See 'Unit Price Schedule' tab — Friction Pile Anchor Estimated total | $0.00 | 260 LF | $0.00 |
| 7 | Mobilization — Standard Land-Access | See 'Fixed Fees & Rates' tab | $0.00 | 3 properties | $0.00 |
| 8 | Mobilization — Marine/Barge-Access | See 'Fixed Fees & Rates' tab | $0.00 | 3 properties | $0.00 |
| 9 | Mobilization — Restricted-Access | See 'Fixed Fees & Rates' tab | $0.00 | 3 properties | $0.00 |
| 10 | Dock Demolition (Category D, per SF of dock deck area, if applicable) | See 'Unit Price Schedule' tab — Dock Demolition Estimated total | $0.00 | 120 SF | $0.00 |
| 11 | Hourly Rates — Out-of-Scope Services | See 'Fixed Fees & Rates' tab — City-estimated hours | varies by labor category | 184 hrs | $0.00 |
| 12 | Reimbursable Expenses — Agency Permit Fees | Reimbursed at cost per Task Order; not included in scored total ($0) | $0.00 | ||
| TOTAL PROPOSED COST | $0.00 |
| Optional / Informational (Not Scored) | |||
| Canal Property Owner Discount (% off Contractor's standard retail pricing for other owners on the Fox Creek, Phillip Street, and Lakewood Canals — RFP Section 5.3) | Informational only; not included in Total Proposed Cost or scored under RFP Section 7 | 0.0% |
Note: Unit prices and fees pull automatically from the 'Fixed Fees & Rates' and 'Unit Price Schedule' tabs. Complete those tabs first; this summary updates automatically. Estimated quantities (gray) are entered by the City, are applied uniformly to all proposals, and are used only to calculate the Total Proposed Cost for evaluation under RFP Section 7; they do not guarantee any volume of work. The estimated number of properties used on this tab (nine (9) for Categories A–C and three (3) in each mobilization access tier) is a sample for scoring purposes only and does not represent the number of properties the City expects to serve under the RFP (see RFP Section 1). Category D, Tieback/Anchor, Friction Pile Anchor, and Dock Demolition quantities pull from the Estimated Cost Worksheets on the 'Unit Price Schedule' tab. Hourly Rates (Line 11) are weighted by the City's estimated hours for each labor category on the 'Fixed Fees & Rates' tab. Reimbursable expenses (Line 12) are agency permit fees reimbursed at cost on each Task Order; they are set at $0 by the City and are not included in the Total Proposed Cost. The Friction Pile Anchor line (Line 6) is an alternate to the Tieback/Anchor Assembly line (Line 5); the Engineer of Record determines which applies per property. Mobilization (Lines 7–9) is weighted by the City's estimated number of properties in each access tier; only the applicable tier's fee is paid per property. The Canal Property Owner Discount (above) is optional, priced off retail pricing, and does not affect Total Proposed Cost.
Unit Price Schedule
| Unit Price Schedule — Steel Sheet Pile | ||||||
| Category D — Construction. Proposer completes all unit prices ($/LF) below, plus Tieback/Anchor Assembly pricing (row 27), Friction Pile Anchor pricing (row 37), and Dock Demolition pricing (row 47). Mobilization pricing by access tier is entered on the Fixed Fees & Rates tab. | ||||||
| Wall Type | Unit | New Installation | ||||
| ($/LF) | Repair (Raise) | |||||
| ($/LF) | Full Replacement | |||||
| ($/LF) | Notes | |||||
| Steel Sheet Pile — Light-Duty (Residential) | LF | |||||
| Steel Sheet Pile — Heavy-Duty (Commercial-Grade) | LF | |||||
| Estimated Cost Worksheet (City planning estimate — fills automatically from rate card above) | ||||||
| Wall Type | Scope Type | Unit | Est. Quantity (LF) | Unit Price ($/LF) | Extended Price ($) | |
| Steel Sheet Pile — Light-Duty (Residential) | New Installation | LF | 105 | $0.00 | $0.00 | |
| Steel Sheet Pile — Light-Duty (Residential) | Repair | LF | 67 | $0.00 | $0.00 | |
| Steel Sheet Pile — Light-Duty (Residential) | Full Replacement | LF | 148 | $0.00 | $0.00 | |
| Steel Sheet Pile — Heavy-Duty (Commercial-Grade) | New Installation | LF | 105 | $0.00 | $0.00 | |
| Steel Sheet Pile — Heavy-Duty (Commercial-Grade) | Repair | LF | 66 | $0.00 | $0.00 | |
| Steel Sheet Pile — Heavy-Duty (Commercial-Grade) | Full Replacement | LF | 147 | $0.00 | $0.00 | |
| ESTIMATED TOTAL — CATEGORY D CONSTRUCTION | $0.00 | |||||
| Instructions: Enter unit prices ($/LF) for each steel sheet pile grade and scope in the rate card above (yellow cells). Scopes are defined in RFP Section 5.1 (Scope Definitions); "Repair" means raising an existing, structurally sound wall to the required top-of-wall elevation. In the Notes column (yellow), state for each grade the section designation, thickness or gauge, steel grade, and section modulus (in³/ft) priced, and for Light-Duty the maximum exposed wall height for which the section is typically suitable. Light-Duty (Residential) sections are typically lighter-gauge steel appropriate for lower retained soil heights and loads; Heavy-Duty (Commercial-Grade) sections are heavier-gauge for higher loads or extended design life. In the Estimated Cost Worksheet, the estimated linear footage for each grade/scope combination (including returns at wall ends, RFP Section 3.2, which are included in the New Installation quantities and paid at the New Installation unit price) is pre-filled by the City; proposers shall not change these quantities. Unit prices and extended prices calculate automatically. This worksheet total feeds the Cost Proposal Summary tab and is for budgetary planning; actual payment on each Task Order is based on verified as-built linear footage at the unit prices in the rate card above. |
| Tieback/Anchor Assembly Pricing | ||||
| Tieback and anchor requirements vary by property (spacing, deadman size, tie rod length) and are priced separately from the per-linear-foot wall price. Quote a single unit price per assembly (yellow cell). | ||||
| Item | Unit | Unit Price ($/EA) | Notes | |
| Tieback/Anchor Assembly (tie rod, deadman/anchor, and installation) | EA | $0.00 | ||
| Estimated Cost Worksheet — Tieback/Anchor Assembly (City planning estimate — fills automatically from rate card above) | ||||
| Item | Unit | Est. Quantity (EA) | Unit Price ($/EA) | Extended Price ($) |
| Tieback/Anchor Assembly | EA | 47 | $0.00 | $0.00 |
| TOTAL — TIEBACK/ANCHOR ASSEMBLIES | $0.00 | |||
| Friction Pile Anchor Pricing | ||||
| Friction pile anchors (e.g., helical or small-diameter driven piles) are an alternate to the tieback/anchor assembly above, quoted separately, for use where yard depth, access, or soil conditions make a conventional anchor assembly impractical. Quote a unit price per linear foot driven/installed (yellow cell). | ||||
| Item | Unit | Unit Price ($/LF) | Notes | |
| Friction Pile Anchor (helical or small-diameter driven pile, alternate to tieback/anchor assembly) | LF | $0.00 | ||
| Estimated Cost Worksheet — Friction Pile Anchor (City planning estimate — fills automatically from rate card above) | ||||
| Item | Unit | Est. Quantity (LF) | Unit Price ($/LF) | Extended Price ($) |
| Friction Pile Anchor | LF | 260 | $0.00 | $0.00 |
| TOTAL — FRICTION PILE ANCHOR | $0.00 | |||
| Dock Demolition Pricing | ||||
| Dock demolition applies only where the property owner has agreed that a dock may be demolished under the approved scope of work (RFP Sections 3.4 and 3.7). Quote a unit price per square foot of dock deck area (yellow cell), including demolition, removal of in-water piles or posts, hauling, and legal disposal. Demolition of other structures (e.g., sheds, fences) is billed at the hourly rates on the Fixed Fees & Rates tab. | ||||
| Item | Unit | Unit Price ($/SF) | Notes | |
| Dock Demolition (per SF of dock deck area, incl. in-water piles/posts, hauling, and disposal) | SF | $0.00 | ||
| Estimated Cost Worksheet — Dock Demolition (City planning estimate — fills automatically from rate card above) | ||||
| Item | Unit | Est. Quantity (SF) | Unit Price ($/SF) | Extended Price ($) |
| Dock Demolition | SF | 120 | $0.00 | $0.00 |
| TOTAL — DOCK DEMOLITION | $0.00 |
Fixed Fees & Rates
| Fixed Fees, Mobilization, and Hourly Rates | |||
| Categories A, B, C, mobilization, and hourly labor rates for out-of-scope work. | |||
| No. | Pricing Element | Basis | Price ($) |
| 1 | Category A — Condition Assessment | Fixed fee, per property assessed | $0.00 |
| 2 | Category B — Engineering Design | Fixed fee, per property (includes site survey and geotechnical investigation, RFP Section 3.2) | $0.00 |
| 3 | Category C — Permitting Support | Fixed fee, per permit application package | $0.00 |
| 4 | Mobilization — Standard Land-Access | Fixed fee, per property — Standard Land-Access (RFP Section 5.1) | $0.00 |
| 5 | Mobilization — Marine/Barge-Access | Fixed fee, per property — Marine/Barge-Access (RFP Section 5.1) | $0.00 |
| 6 | Mobilization — Restricted-Access | Fixed fee, per property — Restricted-Access (RFP Section 5.1) | $0.00 |
| Hourly Rate Schedule — Additional / Out-of-Scope Services | |||||
| Labor Category | Basis | Hourly Rate ($/hr) | Est. Hours (City) | Extended ($) | |
| Principal / Professional Engineer | Per hour, portal to portal | $0.00 | 10 | $0.00 | |
| Project Manager | Per hour, portal to portal | $0.00 | 10 | $0.00 | |
| Field Technician / Inspector | Per hour, portal to portal | $0.00 | 10 | $0.00 | |
| Construction Superintendent | Per hour, portal to portal | $0.00 | 20 | $0.00 | |
| Equipment Operator | Per hour, portal to portal | $0.00 | 40 | $0.00 | |
| Laborer | Per hour, portal to portal | $0.00 | 80 | $0.00 | |
| Diver (underwater inspection) | Per hour, portal to portal | $0.00 | 4 | $0.00 | |
| CAD / Drafting | Per hour, portal to portal | $0.00 | 10 | $0.00 | |
| TOTAL — HOURLY RATES (City-estimated hours) | 184 | $0.00 |
Walked Property Cost Worksheet
| Walked Property Cost Worksheet | ||
| RFP Section 5.2 — Mandatory Site Walk. One row per Walked Property. | ||
| Site Key / | ||
| Address | Scope Observed | Est. |
| Quantity (LF) | Light-Duty |
Cat. D Unit Price ($/LF) Light-Duty Cat. D Cost ($) Heavy-Duty Cat. D Unit Price ($/LF) Heavy-Duty Cat. D
| Cost ($) | Tieback/ |
| Anchor Qty (EA) | Tieback/ |
| Anchor Cost ($) | Friction Pile |
| Anchor Qty (LF) | Friction Pile |
| Anchor Cost ($) | Cat. A |
| Cost ($) | Cat. B |
| Cost ($) | Cat. C |
| Cost ($) | Access Tier |
| Observed | Mobilization |
| ($) | Dock Demo |
| Area (SF) | Dock Demo |
| Cost ($) | TOTAL WALKED |
PROPERTY COST —
LIGHT-DUTY ($) TOTAL WALKED
PROPERTY COST —
HEAVY-DUTY ($)
| 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | |
| 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | |
| 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | |
| 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | |
| 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | |
| 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | |
| TOTAL — ALL WALKED PROPERTIES | $0.00 | $0.00 | |||||||||||||||
| Instructions: Complete one row per property designated by the City as a Walked Property (RFP Section 5.2). Enter the Site Key/Address (yellow), select the observed Scope from the dropdown, and enter the estimated linear footage observed during the site walk. Category D unit prices and costs calculate automatically from the Unit Price Schedule tab for both the Light-Duty and Heavy-Duty steel sheet pile grades. Price each Walked Property using a single scope; a total Walked Property cost is calculated separately for each grade. If a tieback/anchor system is anticipated, enter the estimated number of assemblies (yellow); if friction pile anchors are anticipated instead, enter the estimated linear footage driven or installed (yellow) and leave the tieback quantity at 0. Costs calculate automatically from the Unit Price Schedule tab. If the property owner has agreed that a dock may be demolished, enter the estimated dock deck area in square feet (yellow); dock demolition cost calculates automatically from the Unit Price Schedule tab (enter 0 if not applicable). Category A, B, and C costs pull automatically from the Fixed Fees & Rates tab. Select the observed Access Tier from the dropdown (Standard Land-Access, Marine/Barge-Access, or Restricted-Access — see RFP Section 5.1); the corresponding mobilization fee pulls automatically from the Fixed Fees & Rates tab. Do not overwrite formula cells (white, black text). Walked Property totals are budgetary estimates only; final Category D payment on any Task Order is based on as-built quantities at the unit prices in the Unit Price Schedule tab, and Category B/C costs remain subject to completion of design and permitting. |
Instructions
| Cost Proposal Workbook — Instructions | |
| Companion pricing workbook for the Seawall RFP (Section 5.1) | |
| Tab order | |
| 1. Unit Price Schedule | Enter unit prices ($/LF) for Steel Sheet Pile, broken out by Light-Duty (Residential) and Heavy-Duty (Commercial-Grade) grade, and by New Installation, Repair (raising an existing wall), and Full Replacement, as defined in RFP Section 5.1. In the Notes column, state the section, gauge/thickness, steel grade, and section modulus priced for each grade. Also enter a unit price per Tieback/Anchor Assembly ($/EA) and a unit price per Friction Pile Anchor ($/LF) further down the same tab — friction pile anchors are an alternate to a tieback/anchor assembly, priced separately since the Engineer of Record selects one system or the other per property. Also enter a unit price per square foot of dock deck area for Dock Demolition ($/SF), which applies only where the property owner has agreed a dock may be demolished. This is the core Category D pricing required by RFP Section 5.1. |
| Estimated Cost Worksheets | Below each rate card on the same tab, the City has pre-filled its estimated linear footage (wall) or quantity (tieback/anchor assemblies, friction pile anchor footage, or dock deck area). Proposers shall not change these quantities; they are applied uniformly to all proposals so that totals can be compared. Unit prices and extended totals calculate automatically. |
| 2. Fixed Fees & Rates | Enter fixed fees for Category A (Assessment), Category B (Design), Category C (Permitting), Mobilization — quoted separately for each of three site-access tiers (Standard Land-Access, Marine/Barge-Access, and Restricted-Access, per RFP Section 5.1) — and the hourly rate schedule for out-of-scope work. Hourly rates are scored using the City's estimated hours (gray). |
| 3. Walked Property Cost Worksheet | Required by RFP Section 5.2. One row per City-designated Walked Property from the mandatory site walk. Enter the site key, observed scope, estimated footage, and (if applicable) estimated tieback/anchor quantity or friction pile anchor footage and dock deck area to be demolished. Select the observed Access Tier from the dropdown. Category D costs are calculated for both steel sheet pile grades (Light-Duty and Heavy-Duty), with a separate total for each grade (RFP Section 5.2). Category D, Tieback/Anchor, Dock Demolition, Category A/B/C, and Mobilization costs all pull automatically from the Unit Price Schedule and Fixed Fees & Rates tabs. |
| 4. Cost Proposal Summary | Multiplies your unit prices and fees by the City's estimated quantities (gray) and totals them. This Total Proposed Cost is the figure scored under RFP Section 7. Enter your firm name and, if teaming with a subconsultant or subcontractor (e.g., for licensed engineering services per Section 1.2), that firm's name; do not edit the formula cells (black text) or the City's estimated quantities (gray). Mobilization is weighted by the City's estimated number of properties in each access tier; only the applicable tier is paid per property. The optional Canal Property Owner Discount (RFP Section 5.3) is entered at the bottom of this tab and is informational only. Reimbursable allowance is set by the City, not the proposer. |
| Color key | |
| Yellow cells, blue text | Proposer-entered values — unit prices, fees, rates, and quantities. |
| White cells, black text | Formulas — do not overwrite. These calculate automatically from your entries. |
| Gray cells, black text | City-entered values — estimated quantities and the reimbursable allowance. Do not change. |
| Notes | |
| Estimated vs. actual quantities | The Estimated Cost Worksheet total is for budgetary comparison across proposals only. Actual payment on individual Task Orders is based on verified as-built linear footage at the unit prices quoted in the rate card. |
| Consistency | Unit prices quoted here should match the pricing used in any Task Order issued under the resulting Master Contract (see Standard Task Order Form, Section 4). |
| Input cell example: | 125.00 |
File details come from the government source that posted it. Updated .