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 | ||
| Attachment 3 Amend 1 - Product Pricing Worksheet.xlsx | XLSX spreadsheet | |
| Attachment 2 - SCDOT Policy for Pothole Patching Products.pdf | ||
| Solicitation.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 5400028758 | Attachment #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 Packaging | Buckets |
| 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. |
| Quantities | District 1 | District 2 | District 3 | District 4 | District 5 | District 6 | District 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:
| Quantities | District 1 | District 2 | District 3 | District 4 | District 5 | District 6 | District 7 |
| 1-10 Pallets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 11-20 Pallets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 21 Pallets | ERROR:#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 .