Solicitation Attachment 1 Price Sheet 2024 08 16.xlsx

XLSX spreadsheet 18 KB Posted

Attached to
Vermont Fuel Oil and Propane at GSA Locations
Solicitation number
47PB0024Q0033
Issued by

About this file

Written by GovTribe AI ·

This document is a pricing sheet attachment to a Request for Quote (RFQ) for the supply and delivery of fuel oil and propane to various government locations throughout Vermont. The RFQ, solicitation number 47PB0024Q0033, is a total small business set-aside with a base period of 6 months from 11/1/2024 to 4/30/2025 and one 12-month option period.

The attachment provides instructions for offerors to submit pricing, including index rates, margin rates, and calculated unit prices and evaluated prices for each contract line item number (CLIN) covering fuel oil, propane, and kerosene deliveries to 16 different locations. The pricing is requested for the base period and two option periods. The North American Industry Classification System (NAICS) code for this procurement is 457120 - Fuel Dealers.

View the file

Other files

File Type Posted
Contract Document 1 Performance Work Statement 2024 08 16.pdf PDF
Exhibit 1 - Building Information.xlsx XLSX spreadsheet
RFQ Attachment 2 - Offerors Representations and Certifications.docx DOCX document
RFQ 47PB0024Q0033 Vermont Fuel and Propane Delivery 2024 08 16.pdf 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions to Offeror

Offerors shall provide requested information in the highlighted cells only

1. Offerors shall provide the requested Index Rates under Columns C,D,E (highlighted in Yellow) for each CLIN for the base year. Column F will auto calculate the average of the three (3) prices to provide an Index rate that will be used for calculating the unit cost. * This calculated Market Price will be used for calculating the unit cost for Option Periods.

2. Offerors shall provide their proposed Margin Rates under column G for the basic year (highlighted in Yellow) for each CLIN; and Columns,M,S,Y, AE for the Option Periods.

3.The Unit Price for the Basic Year and Option years will auto calucuate (Calculated Market Price + Margin rate)

4. The Evaluated price for each CLIN will auto calculate for for the Basic Year and Option Years (Calculated Unit Price * Estimated Quantities) and will be input onto the SF1449 at award.

5. The total year price will auto calcuate for the Basic Year and each option period. ROW 25

6. The Basic year price + option year price will be the total evaluated price

Pricing Sheet Attachment 1

BASE Period, 11/1/2024-4/30/2025Option Year 1, 5/1/2025 through 4/30/20266 Month Extension, 5/1/2026 through 10/31/2026
ServiceCLINIndex Rate 1 November 1, 2023Index Rate 2 December 1, 2023Index Rate 3 February 1, 2024Average Index RateMargin RateUnit PriceEstimated Quantities (1G=Gallons)Evaluated PriceCLINAverage Index Rate (From Base Year)Margin RateUnit PriceEstimated Quantities (1G=Gallons)Evaluated PriceCLINAverage Index Rate (From Base Year)Margin RateUnit PriceEstimated Quantities (1G=Gallons)Evaluated Price
Derby Line Rt. 5 - Fuel0001ERROR:#DIV/0!ERROR:#DIV/0!2500ERROR:#DIV/0!1001ERROR:#DIV/0!ERROR:#DIV/0!2500ERROR:#DIV/0!5001ERROR:#REF!ERROR:#REF!1250ERROR:#REF!
Derby Line Rt. 5- Propane0002ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!1002ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!5002ERROR:#REF!ERROR:#REF!250ERROR:#REF!
Derby Line Rt. 5 - Kerosene0003ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1003ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5003ERROR:#REF!ERROR:#REF!138ERROR:#REF!
Derby Line I 91- Fuel0004ERROR:#DIV/0!ERROR:#DIV/0!6,500ERROR:#DIV/0!1004ERROR:#DIV/0!ERROR:#DIV/0!6,500ERROR:#DIV/0!5004ERROR:#REF!ERROR:#REF!3,250ERROR:#REF!
Beebe Plain - Fuel0005ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1005ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5005ERROR:#REF!ERROR:#REF!138ERROR:#REF!
Beebe Plain - Propane0006ERROR:#DIV/0!ERROR:#DIV/0!100ERROR:#DIV/0!1006ERROR:#DIV/0!ERROR:#DIV/0!100ERROR:#DIV/0!5006ERROR:#REF!ERROR:#REF!50ERROR:#REF!
Norton - Fuel0007ERROR:#DIV/0!ERROR:#DIV/0!775ERROR:#DIV/0!1007ERROR:#DIV/0!ERROR:#DIV/0!775ERROR:#DIV/0!5007ERROR:#REF!ERROR:#REF!388ERROR:#REF!
Norton- Propane0008ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!1008ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!5008ERROR:#REF!ERROR:#REF!625ERROR:#REF!
New North Troy- Propane0009ERROR:#DIV/0!ERROR:#DIV/0!2000ERROR:#DIV/0!1009ERROR:#DIV/0!ERROR:#DIV/0!2000ERROR:#DIV/0!5009ERROR:#REF!ERROR:#REF!1000ERROR:#REF!
Alburg Springs - Fuel0010ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1010ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5010ERROR:#REF!ERROR:#REF!138ERROR:#REF!
Alburg Springs - Propane0011ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!1011ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!5011ERROR:#REF!ERROR:#REF!500ERROR:#REF!
West Berkshire-Fuel0012ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1012ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5012ERROR:#REF!ERROR:#REF!138ERROR:#REF!
East Richford Fuel0013ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1013ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5013ERROR:#REF!ERROR:#REF!138ERROR:#REF!
Richford-Fuel0014ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1014ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5014ERROR:#REF!ERROR:#REF!138ERROR:#REF!
Beecher Falls-Fuel0015ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1015ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5015ERROR:#REF!ERROR:#REF!138ERROR:#REF!
Canaan-Fuel0016ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1016ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5016ERROR:#REF!ERROR:#REF!138ERROR:#REF!

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