Attachment A - Pricing Worksheet.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- STC ULSD FUEL DELIVERY
- Solicitation number
- 5400027902
- Issued by
- Greenville County, South Carolina
About this file
This document is an Attachment A - Pricing Worksheet for a ULSD (Ultra Low Sulfur Diesel) Fuel Delivery and Mobile Fueling Solicitation (Solicitation Number 5400027902) for the South Carolina Department of Education. The solicitation covers fuel delivery across multiple zones, including tankwagon and transport delivery methods, with estimated quantities ranging from 200,000 to 21,000,000 US gallons per zone. The pricing worksheet is designed for vendors to submit their markup pricing for fuel delivery in Zones 1-4, with specific line items for both traditional fuel delivery and mobile fueling services in counties including Greenville, Lexington, and Charleston.
The pricing structure includes various fees and taxes, such as SC Road Tax ($0.2800), State Environmental Impact Fee ($0.0050), State Inspection Fee ($0.0025), Federal LUST Tax ($0.0010), and a separate Oil Spill Trust Fund Fee. Vendors are required to enter their price markup, which should include profit and transportation costs, with the option to submit negative markups. The worksheet automatically calculates evaluated unit prices and estimated extended prices. Additionally, the solicitation includes a provision for Diesel Exhaust Fluid (DEF) service pricing, with estimated annual DEF quantities ranging from 22,892 to 41,613 US gallons across the specified zones.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Solicitation 5400027902 ULSD Fuel Delivery Amendment 1.pdf | ||
| Attachment C - Point of Contact Form.docx | DOCX document | |
| Attachment B - SC Fuel Zone Map.pdf | ||
| Solicitation 5400027902 STC ULSD Fuel Delivery.pdf |
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
Directions - Fuel Delivery
| SAMPLE Attachment A - Pricing Worksheet | ||
| ULSD Fuel Delivery | ||
| Solicitation 5400027902 | Vendor Name: |
| ITEM NUMBER | ITEM DESCRIPTION | ARE YOU ENTERING A BID FOR THIS LINE ITEM? | TAXES/FEES (see note above) | OIL SPILL TRUST FUND FEE | MMO ADMIN FEE | OPIS AVERAGE | ESTIMATED QUANTITY | UNIT OF MEASURE | OFFEROR'S PRICE MARKUP | EVALUATED UNIT PRICE | ESTIMATED EVALUATED EXTENDED PRICE |
| 1 | ULSD - Tankwagon Zone 1 | $0.2885 | $0.00214 | $0.0150 | $2.00 | 21,000,000 | US gallon | ||||
| 2 | ULSD - Tankwagon Zone 2 | $0.2885 | $0.00214 | $0.0150 | $2.00 | 14,000,000 | US gallon | ||||
| 3 | ULSD - Tankwagon Zone 3 | $0.2885 | $0.00214 | $0.0150 | $2.00 | 13,000,000 | US gallon | ||||
| 5 | ULSD - Transport Zone 1 | $0.2885 | $0.00214 | $0.0150 | $2.00 | 5,000,000 | US gallon | ||||
| 6 | ULSD - Transport Zone 2 | $0.2885 | $0.00214 | $0.0150 | $2.00 | 5,000,000 | US gallon | ||||
| 7 | ULSD - Transport Zone 3 | $0.2885 | $0.00214 | $0.0150 | $2.00 | 5,000,000 | US gallon | ||||
| 8 | ULSD - Transport Zone 4 | $0.2885 | $0.00214 | $0.0150 | $2.00 | 5,000,000 | US gallon |
In the next worksheet labeled "Attachment A - Bidding Schedule":
1) Enter your company name here
2) Use the dropdown to indicate if you are offering on each line item
3) Enter your price markup for each corresponding line item in the blue blocks
| All cells other than the green and blue cells are locked. Do not attempt to enter any |
| information in any cell other than the green and blue blocks or attempt to alter the spreadsheet. |
| The spreadsheet will automatically calculate the "Evaluated Unit Price" and the |
| Estimated Evaluated Extended Price. |
Pricing - Fuel Delivery
| Attachment A - Pricing Worksheet | |
| ULSD Fuel Delivery | |
| Solicitation 5400027902 | Vendor Name: |
| This worksheet replaces the Bidding Schedule typically found in Section VIII of the solicitation and is designed to calculate a total price per gallon. A response is required for all cells shaded GREEN. Enter your price markup rounded to the nearest ten thousandth ($0.XXXX) of a cent in the "Offeror's Price Markup" or BLUE cells below for any corresponding line item that you wish to offer a bid. The "Evaluated Unit Price" and the "Estimated Evaluated Extended Price" or the RED cells below will automatically calculate based on your input. A bid is required below for each "Evaluated Unit Price" you wish to bid on for your offer to be considered. This completed spreadsheet must be saved and attached as an Excel file online with your offer. |
| NOTE: The "Estimated Quantities" shown below are estimates only and based on prior historical usage. The "Taxes/Fees" column "E" below contains only the SC Road Tax ($0.2800), State Environmental Impact Fee ($0.0050), State Inspection Fee ($0.0025) and the Federal LUST Tax ($0.0010). The Federal Oil Spill Trust Fund Fee is listed separately since this amount varies by product. The amount entered for "Offeror's Price Markup" should be the offeror's margin for the corresponding line item and inlcude all profit and transportation. This price markup should not include any of the taxes or fees considered and listed below. A negative amount for "Offeror's Price Markup" is allowed. The calculation for the "Estimated Evaluated Extended Price" uses a rounded to the nearest ten thousandth ($0.XXXX) "Evaluated Unit Price". |
| ITEM NUMBER | ITEM DESCRIPTION | ARE YOU ENTERING A BID FOR THIS LINE ITEM? | TAXES/FEES (see note above) | OIL SPILL TRUST FUND FEE | MMO ADMIN FEE | OPIS AVERAGE | ESTIMATED QUANTITY | UNIT OF MEASURE | OFFEROR'S PRICE MARK-UP | EVALUATED UNIT PRICE | ESTIMATED EVALUATED EXTENDED PRICE |
| 1 | ULSD - Tankwagon Zone 1 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 200,000 | US gallon | ||||
| 2 | ULSD - Tankwagon Zone 2 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 200,000 | US gallon | ||||
| 3 | ULSD - Tankwagon Zone 3 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 200,000 | US gallon | ||||
| 4 | ULSD - Tankwagon Zone 4 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 200,000 | US gallon | ||||
| 5 | ULSD - Transport Zone 1 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 5,000,000 | US gallon | ||||
| 6 | ULSD - Transport Zone 2 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 5,000,000 | US gallon | ||||
| 7 | ULSD - Transport Zone 3 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 5,000,000 | US gallon | ||||
| 8 | ULSD - Transport Zone 4 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 5,000,000 | US gallon |
Directions - Mobile Fueling
| SAMPLE Attachment A - Pricing Worksheet | ||
| Mobile Fueling Program for South Carolina Department of Education | ||
| Solicitation 5400027902 | Vendor Name: |
| ITEM NUMBER | ITEM DESCRIPTION | ARE YOU ENTERING A BID FOR THIS LINE ITEM? | TAXES/FEES (see note above) | OIL SPILL TRUST FUND FEE | MMO ADMIN FEE | OPIS AVERAGE | ESTIMATED QUANTITY | UNIT OF MEASURE | OFFEROR'S PRICE MARKUP | EVALUATED UNIT PRICE | EXTENDED EVALUATED UNIT PRICE | ESTIMATED ANNUAL DIESEL EXHAUST FLUID QUANTITY | UNIT OF MEASURE | DIESEL EXHAUST FLUID SERVICE | EVALUATED DEF PRICE | TOTAL ESTIMATED EVALUATED EXTENDED PRICE |
| 1 | ULSD - Mobile Fueling Service - Zone 1 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 21,000,000 | US gallon | 30,070 | US gallon | $0.0000 | ||||||
| 2 | ULSD - Mobile Fueling Service - Zone 2 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 21,000,000 | US gallon | 22,892 | US gallon | $0.0000 | ||||||
| 3 | ULSD - Mobile Fueling Service - Zone 4 | $0.2885 | $0.00214 | $0.0200 | $2.00 | 14,000,000 | US gallon | 41,613 | US gallon | $0.0000 |
In the next worksheet labeled "Attachment A - Bidding Schedule":
1) Enter your company name here
2) Use the dropdown to indicate if you are offering on each line item
3) Enter your price markup for each corresponding line item in the blue blocks
| All cells other than the green and blue cells are locked. Do not attempt to enter any information in any cell other than the green and blue blocks or attempt to alter the spreadsheet. |
| Enter the per gallon charge for dispensing Diesel Exhaust Fluid on an as-needed basis. |
| The spreadsheet will automatically calculate the "Evaluated Unit Price", the "Evaluated DEF Price" and the "Total Estimated Evaluated Extended Price". |
Pricing - Mobile Fueling
| Attachment A - Pricing Worksheet | |
| Mobile Fueling Program for South Carolina Department of Education | |
| Solicitation 5400027902 | Vendor Name: |
| This worksheet replaces the Bidding Schedule typically found in Section VIII of the solicitation and is designed to calculate a total price per gallon. A response is required for all cells shaded GREEN. Enter your price markup rounded to the nearest ten thousandth ($0.XXXX) of a cent in the "Offeror's Price Markup" or BLUE cells below for any corresponding line item that you wish to offer a bid. The "Evaluated Unit Price" and the "Estimated Evaluated Extended Price" or the RED cells below will automatically calculate based on your input. A bid is required below for each "Evaluated Unit Price" you wish to bid on for your offer to be considered. This completed spreadsheet must be saved and attached as an Excel file online with your offer. |
| NOTE: The "Estimated Quantities" shown below are estimates only and based on prior historical usage. The "Taxes/Fees" column "E" below contains only the SC Road Tax ($0.2800), State Environmental Impact Fee ($0.0050), State Inspection Fee ($0.0025) and the Federal LUST Tax ($0.0010). The Federal Oil Spill Trust Fund Fee is listed separately since this amount varies by product. The amount entered for "Offeror's Price Markup" should be the offeror's margin for the corresponding line item and inlcude all profit and transportation. This price markup should not include any of the taxes or fees considered and listed below. A negative amount for "Offeror's Price Markup" is allowed. The calculation for the "Estimated Evaluated Extended Price" uses a rounded to the nearest ten thousandth ($0.XXXX) "Evaluated Unit Price". |
| ITEM NUMBER | ITEM DESCRIPTION | ARE YOU ENTERING A BID FOR THIS LINE ITEM? | TAXES/FEES (see note above) | OIL SPILL TRUST FUND FEE | MMO ADMIN FEE | OPIS AVERAGE | ESTIMATED QUANTITY | UNIT OF MEASURE | OFFEROR'S PRICE MARK-UP | EVALUATED UNIT PRICE | EXTENDED EVALUATED UNIT PRICE | ESTIMATED ANNUAL DIESEL EXHAUST FLUID QUANTITY | UNIT OF MEASURE | DIESEL EXHAUST FLUID SERVICE PRICE | EVALUATED DEF PRICE | TOTAL ESTIMATED EVALUATED EXTENDED PRICE |
| 1 | ULSD - Mobile Fueling Service - Zone 1, Greenville County | $0.2885 | $0.00214 | $0.0200 | $2.00 | 509,250 | US gallon | 30,070 | US gallon | $0.0000 | ||||||
| 2 | ULSD - Mobile Fueling Service - Zone 2, Lexington County | $0.2885 | $0.00214 | $0.0200 | $2.00 | 509,250 | US gallon | 22,892 | US gallon | $0.0000 | ||||||
| 3 | ULSD - Mobile Fueling Service - Zone 4, Charleston County | $0.2885 | $0.00214 | $0.0200 | $2.00 | 363,960 | US gallon | 41,613 | US gallon | $0.0000 |
File details come from the government source that posted it. Updated .