Attachment 3 - Product Pricing Worksheet.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
STC FOR WATER ACTIVATED POTHOLE PATCHING
Solicitation number
5400028758
Issued by
Lancaster County, South Carolina

About this file

This file is an Excel-based Product Pricing Worksheet for Solicitation 5400028758, specifically related to a water-activated pothole patching product procurement. The worksheet is designed to help vendors calculate and submit pricing per pound for product pallets across seven different districts, with pricing tiers for 1-10 pallets, 11-20 pallets, and 21+ pallets. Vendors are required to complete green-colored fields with product packaging details, including bucket/bag weights and number of bags/buckets per pallet, and provide bid prices that include delivery.

The pricing worksheet mandates precise calculations and requires vendors to ensure that their calculated price per pound matches entries on the Bidding Schedule (Section VIII), with failure to do so potentially resulting in a non-responsive offer. The document emphasizes comprehensive pricing transparency, requiring vendors to input specific product information and pricing across multiple district quantity brackets. The worksheet appears to be part of a structured procurement process for a water-activated pothole patching solution, with a focus on detailed, district-specific pricing submissions.

View the file

Other files

File Type Posted
Amendment #1.pdf PDF
Attachment 3 Amend 1 - Product Pricing Worksheet.xlsx XLSX spreadsheet
Attachment 2 - SCDOT Policy for Pothole Patching Products.pdf PDF
Solicitation.pdf PDF
Attacment 4 - Point of Contact Form.docx DOCX document
Attachment 1 - SCDOT Delivery Locations.xls XLS spreadsheet
Attachment 5 - Draft Reporting Template.xlsx XLSX spreadsheet

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

Pricing Worksheet Calculations

Solicitation 5400028758Attachment #3
Product Pricing Worksheet
STC Water Activated Pothole Patching
This worksheet is designed to assist you with calculating your offered price per pound. This worksheet must be completed
and submitted with your offer. All GREEN fields must be completed by the offeror. The RED fields are calculations
based on the information entered in the GREEN fields. The RED fields are your calculated price per pound and these
amounts must also be entered on the Bidding Schedule (see section VIII.) and submitted with your offer. The calculated
price per pound in the RED section must match the prices submitted on the Bidding Schedule (section VIII.) or your
offer may be deemed nonresponsive.

Select or enter the following information about your product:

Product PackagingBuckets
Weight per Bag or Bucket (lbs.)
Number of Bags/Buckets per Pallet
Enter your bid price per pallet for each district below in the space provided based on the price point (quantities) below.
Offered price must include delivery. See attachment #1 for delivery details.
QuantitiesDistrict 1District 2District 3District 4District 5District 6District 7
1-10 Pallets
11-20 Pallets
21 Pallets
The fields below will automatically calculate based on the information provided above. Be sure that all the RED fields
below are populated and that these prices match the Bidding Schedule (see section VIII.)

Price per Pound Calculations:

QuantitiesDistrict 1District 2District 3District 4District 5District 6District 7
1-10 PalletsERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
11-20 PalletsERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
21 PalletsERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

Sheet2

Buckets
Bags

Sheet3

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