Attachment A 19-IFB-2362342761-BJL Madison Pricing Workbook.xlsx

XLSX spreadsheet 637 KB Posted

Attached to
19-IFB-2362342761-BJL Madison County ACQ Demo Group 2
Solicitation number
Doc2362342776
Issued by
Madison County, Maury CDP, North Carolina

About this file

This is a bid pricing workbook for the North Carolina Department of Public Safety Emergency Management in response to Request for Bid (RFB) 19-IFB-2362342761-BJL. The workbook covers acquisition and site demolition services for eight properties located in Marshall, North Carolina, all associated with Storm #4827 and Project #37. The properties include six commercial lots and two commercial properties with addresses on Main Street, Bridge Street, Island Road, and Baileys Branch Road. Vendors are required to complete individual Property Worksheets for each of the eight locations and provide a consolidated Bid Summary Sheet that auto-calculates totals across all work phases. The worksheet mandates that vendors specify unit prices and quantities for itemized work, including intake/DOB calculation, appraisal, title research, document preparation, closing attorney fees, asbestos/lead inspection, structure demolition, underground storage tank clearance, grading and seeding, and any miscellaneous costs. Vendors must also provide profit and overhead costs, construction management costs, and an anticipated overall project timeframe measured in days from Notice to Proceed through closeout for all contracted work.

The pricing workbook contains blank line items for vendors to input their cost estimates; all cells currently display $0.00, indicating this is a template for vendor completion. Vendors are explicitly prohibited from modifying the worksheet structure, adding or removing line items, or changing formulas, with noncompliance constituting grounds for bid rejection. The document emphasizes that vendors are responsible for ensuring accurate calculations of Work Phase Totals (Acquisition, Site Demolition, Profit & Overhead, and Construction Management Costs) and the Grand Total, and any errors must be immediately reported to the State using the contact method specified in the RFB. The workbook is designed to facilitate standardized pricing evaluation across multiple properties and work phases while maintaining the integrity of the bid comparison process.

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

BID SUMMARY SHEET

North Carolina Department of Public Safety
Emergency Management
ACQUISITION REQUEST FOR BID WORKSHEET
RFB NUMBER:
VENDOR:
BID DATE:
BID SUMMARY
WORK PHASETOTAL
ACQUISITION$0.00
SITE DEMOLITION$0.00
PROFIT & OVERHEAD$0.00
CONSTRUCTION MANAGEMENT COSTS$0.00
GRAND TOTAL:$0.00

TOTAL PROJECT TIME (DAYS):

NOTES:**Please read the following information carefully**
1) The Vendor shall fill out this Bid Worksheet in its entirety.
2) Modifications to this worksheet (i.e., adding/removing line items, modifying formulas, etc.) are not permitted. Noncompliance shall constitute grounds to reject Vendor's proposal.
3) Vendor is responsible for providing information in light blue cells.
4) This Bid Summary Sheet auto-calculates the Work Phase Totals (Acquisition, Site Demolition, Profit & Overhead, and Management Costs) from subsequent Property Worksheets. Vendor shall verify that all amounts for each individual phase and the Grand Total have been calculated correctly. Any errors or concerns with this worksheet shall be brought to the immediate attention of the State; Vendor shall follow the contact method as specified in the RFB.
5) Vendor must provide Construction Management Costs and Profit & Overhead Costs for each property, as applicable.
6) An individual Property Worksheet must be filled out in its entirety for EACH property. Property Worksheets are included within this Bid Worksheet.
7) Vendor shall note the unit of measure for each line item listed on the Property Worksheet (i.e., linear feet, square feet, hour, flat rate, or any reasonable unit of measure). Vendor shall input a Unit Price and Quantity for every line item (a '1' must be entered in the Quantity column for flat or individual costs).
8) Additional rows for miscellaneous costs have been provided for each property. Three additional rows per work phase have been provided if the Vendor determines other eligible costs should be provided in their bid. If Vendor elects to use this category, a description of the cost must be provided along with the unit of measure, unit price, and quantity.
9) Vendor shall provide the anticipated overall project timeframe (i.e., total time to complete work for all properties listed). This estimate, in days, shall begin with the Notice to Proceed and end at closeout for all contracted work. Vendor shall strive to meet this timeframe, as well as any timeframes put forth by NCEM, barring any unexpected acts of nature requiring a change in the Scope of Work and/or Change Order(s). It is the responsibility of the Vendor to create a time schedule, including any phasing or work overlap, in order to complete all projects in the specified timeframe. The timeframe submitted by each Vendor shall be used by the State when evaluating bids as to meet HMGP goals and deadlines.

REF-SHEET2-DONOTMOVE

*THIS SHEET HAS INTENTIONALLY BEEN LEFT BLANK. DO NOT DELETE.

PROPERTY (1)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:160 S Main St.
PROJECT #:37CITY:Marshall
* Commercial Lot
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

PROPERTY (2)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:216B S Main St.
PROJECT #:37CITY:Marshall
* Commercial Lot
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

PROPERTY (3)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:227 Island Rd
PROJECT #:37CITY:Marshall
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

PROPERTY (4)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:232 S Main St.
PROJECT #:37CITY:Marshall
* Commercial Lot
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

PROPERTY (5)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:242 S Main St.
PROJECT #:37CITY:Marshall
* Commercial Lot
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

PROPERTY (6)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:25 Bridge St.
PROJECT #:37CITY:Marshall
* Commercial Property
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.Basement Fill$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

PROPERTY (7)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:251 S Main St.
PROJECT #:37CITY:Marshall
* Commercial Property
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

PROPERTY (8)

ACQUISITION REQUEST FOR BID PROPERTY WORKSHEET
STORM #:4827STREET ADDRESS:38 Baileys Branch Rd
PROJECT #:37CITY:Marshall
* Commercial Property
WORK PHASEITEMIZED WORKUNIT OF MEASUREUNIT PRICEQUANTITYITEMIZED COST
AcquisitionIntake / DOB Calculation$0.00
Appraisal$0.00
Title Research$0.00
Document Prep$0.00
Closing Attorney Fees$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Acquisition Total:$0.00
Site DemolitionAsbestos / Lead Inspection$0.00
$0.00
Structure Demolition$0.00
UST / Other Clearance$0.00
Grade / Seed$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Misc.N/A or Provide Details$0.00
Site Demolition Total:$0.00
OtherProfit & Overhead
Construction Management Costs
Other Total:$0.00
Vendor Total:$0.00
Property Total:$0.00

REF-LASTSHEET-DONOTMOVE

*THIS SHEET HAS INTENTIONALLY BEEN LEFT BLANK. DO NOT DELETE.

image1.wmf

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