Solicitation Attachment 1 Price Sheet 2023 3 03.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Vermont Fuel and Propane Delivery to Multiple Locations
Solicitation number
47PB0123Q0004
Issued by

View the file

Other files

File Type Posted
Amendment 0001 Vermont Fuel and Propane Delivery 47PB0123Q0004 RFQ 2023 3 03.pdf PDF
Contract Document 1 Performance Work Statement 2023 3 03.pdf PDF
Vermont Fuel and Propane Delivery 47PB0123Q0004 RFQ 2023 3 03.pdf PDF
Exhibit 1 - Building Information.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
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 YEAR, 4/1/2023-3/31/2024Option Year 1, 4/1/2024 through 3/31/2025Option Year 2, 4/1/2025 through 3/31/2026Option Year 3, 4/1/2026 through 3/31/2027Option Year 4, 4/1/2027 through 3/31/20286 Month Extension, 3/31/2028 through 9/30/2028
ServiceCLINIndex Rate 1 November 1, 2022Index Rate 2 December 1, 2022Index Rate 3 February 1, 2023Average 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 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 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!2001ERROR:#DIV/0!ERROR:#DIV/0!2500ERROR:#DIV/0!3001ERROR:#DIV/0!ERROR:#DIV/0!2500ERROR:#DIV/0!4001ERROR:#DIV/0!ERROR:#DIV/0!2500ERROR:#DIV/0!5001ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!
Derby Line Rt. 5- Propane0002ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!1002ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!2002ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!3002ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!4002ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!5002ERROR:#DIV/0!ERROR:#DIV/0!250ERROR:#DIV/0!
Derby Line Rt. 5 - Kerosene0003ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1003ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2003ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3003ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4003ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5003ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
Derby Line I 91- Fuel0004ERROR:#DIV/0!ERROR:#DIV/0!6,500ERROR:#DIV/0!1004ERROR:#DIV/0!ERROR:#DIV/0!6,500ERROR:#DIV/0!2004ERROR:#DIV/0!ERROR:#DIV/0!6,500ERROR:#DIV/0!3004ERROR:#DIV/0!ERROR:#DIV/0!6,500ERROR:#DIV/0!4004ERROR:#DIV/0!ERROR:#DIV/0!6,500ERROR:#DIV/0!5004ERROR:#DIV/0!ERROR:#DIV/0!3,250ERROR:#DIV/0!
Beebe Plain - Fuel0005ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1005ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2005ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3005ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4005ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5005ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
Beebe Plain - Propane0006ERROR:#DIV/0!ERROR:#DIV/0!100ERROR:#DIV/0!1006ERROR:#DIV/0!ERROR:#DIV/0!100ERROR:#DIV/0!2006ERROR:#DIV/0!ERROR:#DIV/0!100ERROR:#DIV/0!3006ERROR:#DIV/0!ERROR:#DIV/0!100ERROR:#DIV/0!4006ERROR:#DIV/0!ERROR:#DIV/0!100ERROR:#DIV/0!5006ERROR:#DIV/0!ERROR:#DIV/0!50ERROR:#DIV/0!
Norton - Fuel0007ERROR:#DIV/0!ERROR:#DIV/0!775ERROR:#DIV/0!1007ERROR:#DIV/0!ERROR:#DIV/0!775ERROR:#DIV/0!2007ERROR:#DIV/0!ERROR:#DIV/0!775ERROR:#DIV/0!3007ERROR:#DIV/0!ERROR:#DIV/0!775ERROR:#DIV/0!4007ERROR:#DIV/0!ERROR:#DIV/0!775ERROR:#DIV/0!5007ERROR:#DIV/0!ERROR:#DIV/0!388ERROR:#DIV/0!
Norton- Propane0008ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!1008ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!2008ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!3008ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!4008ERROR:#DIV/0!ERROR:#DIV/0!1250ERROR:#DIV/0!5008ERROR:#DIV/0!ERROR:#DIV/0!625ERROR:#DIV/0!
New North Troy- Propane0009ERROR:#DIV/0!ERROR:#DIV/0!2000ERROR:#DIV/0!1009ERROR:#DIV/0!ERROR:#DIV/0!2000ERROR:#DIV/0!2009ERROR:#DIV/0!ERROR:#DIV/0!2000ERROR:#DIV/0!3009ERROR:#DIV/0!ERROR:#DIV/0!2000ERROR:#DIV/0!4009ERROR:#DIV/0!ERROR:#DIV/0!2000ERROR:#DIV/0!5009ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!
Alburg Springs - Fuel0010ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1010ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2010ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3010ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4010ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5010ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
Alburg Springs - Propane0011ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!1011ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!2011ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!3011ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!4011ERROR:#DIV/0!ERROR:#DIV/0!1000ERROR:#DIV/0!5011ERROR:#DIV/0!ERROR:#DIV/0!500ERROR:#DIV/0!
West Berkshire-Fuel0012ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1012ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2012ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3012ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4012ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5012ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
East Richford Fuel0013ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1013ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2013ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3013ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4013ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5013ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
Richford-Fuel0014ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1014ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2014ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3014ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4014ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5014ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
Beecher Falls-Fuel0015ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1015ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2015ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3015ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4015ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5015ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
Canaan-Fuel0016ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!1016ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!2016ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!3016ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!4016ERROR:#DIV/0!ERROR:#DIV/0!275ERROR:#DIV/0!5016ERROR:#DIV/0!ERROR:#DIV/0!138ERROR:#DIV/0!
TOTALSERROR:#DIV/0!$ -$ -$ -$ -$ -

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