Solicitation Attachment 1 Price Sheet 2022 05 13.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Propane Supply and Delivery Services for Vermont
Solicitation number
47PB0022Q0010
Issued by

About this file

This document includes a pricing sheet attachment and details of a related federal contract opportunity for propane supply and delivery services in Vermont. The General Services Administration is seeking proposals to provide propane at federally owned buildings and locations throughout Vermont as listed in solicitation documents. Offerors must supply index rates for various CLINs for the base year and proposed margin rates for basic and option years, with unit pricing and totals automatically calculating in the pricing sheet template. Proposals are due by email to the GSA Contracting Officer and Contract Specialist no later than May 31, 2022. The procurement will follow FAR Part 12 for commercial items and FAR Part 13.5 for certain commercial services. The resulting contract will be a total small business set-aside under NAICS code 454310 with a 100-employee size standard.

View the file

Other files

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

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, 7/1/2022-6/30/2023Option Year 1, 7/1/2023 through 6/30/2024Option Year 2, 7/1/2024 through 6/30/2025Option Year 3, 7/1/2025 through 6/30/2026Option Year 4, 7/1/2026 through 6/30/2027
ServiceCLINIndex Rate 1 October 1, 2021Index Rate 2 February 1, 2022Index Rate 3 April 30, 2022Average 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 Price
Alburg Springs - Propane0001ERROR:#DIV/0!ERROR:#DIV/0!27ERROR:#DIV/0!1001ERROR:#DIV/0!ERROR:#DIV/0!27ERROR:#DIV/0!2001ERROR:#DIV/0!ERROR:#DIV/0!27ERROR:#DIV/0!3001ERROR:#DIV/0!ERROR:#DIV/0!27ERROR:#DIV/0!4001ERROR:#DIV/0!ERROR:#DIV/0!27ERROR:#DIV/0!
Beecher Falls - Propane0002ERROR:#DIV/0!ERROR:#DIV/0!116ERROR:#DIV/0!1002ERROR:#DIV/0!ERROR:#DIV/0!116ERROR:#DIV/0!2002ERROR:#DIV/0!ERROR:#DIV/0!116ERROR:#DIV/0!3002ERROR:#DIV/0!ERROR:#DIV/0!116ERROR:#DIV/0!4002ERROR:#DIV/0!ERROR:#DIV/0!116ERROR:#DIV/0!
Canaan - Propane0003ERROR:#DIV/0!ERROR:#DIV/0!62ERROR:#DIV/0!1003ERROR:#DIV/0!ERROR:#DIV/0!62ERROR:#DIV/0!2003ERROR:#DIV/0!ERROR:#DIV/0!62ERROR:#DIV/0!3003ERROR:#DIV/0!ERROR:#DIV/0!62ERROR:#DIV/0!4003ERROR:#DIV/0!ERROR:#DIV/0!62ERROR:#DIV/0!
East Richford - Propane0004ERROR:#DIV/0!ERROR:#DIV/0!216ERROR:#DIV/0!1004ERROR:#DIV/0!ERROR:#DIV/0!216ERROR:#DIV/0!2004ERROR:#DIV/0!ERROR:#DIV/0!216ERROR:#DIV/0!3004ERROR:#DIV/0!ERROR:#DIV/0!216ERROR:#DIV/0!4004ERROR:#DIV/0!ERROR:#DIV/0!216ERROR:#DIV/0!
Highgate Springs - Propane0005ERROR:#DIV/0!ERROR:#DIV/0!44491ERROR:#DIV/0!1005ERROR:#DIV/0!ERROR:#DIV/0!44491ERROR:#DIV/0!2005ERROR:#DIV/0!ERROR:#DIV/0!44491ERROR:#DIV/0!3005ERROR:#DIV/0!ERROR:#DIV/0!44491ERROR:#DIV/0!4005ERROR:#DIV/0!ERROR:#DIV/0!44491ERROR:#DIV/0!
USDA / FDA Building at Highgate Springs - Propane/Diesel0006ERROR:#DIV/0!ERROR:#DIV/0!3,168ERROR:#DIV/0!1006ERROR:#DIV/0!ERROR:#DIV/0!3,168ERROR:#DIV/0!2006ERROR:#DIV/0!ERROR:#DIV/0!3,168ERROR:#DIV/0!3006ERROR:#DIV/0!ERROR:#DIV/0!3,168ERROR:#DIV/0!4006ERROR:#DIV/0!ERROR:#DIV/0!3,168ERROR:#DIV/0!
Montpelier Social Security - Propane0007ERROR:#DIV/0!ERROR:#DIV/0!5,584ERROR:#DIV/0!1007ERROR:#DIV/0!ERROR:#DIV/0!5,584ERROR:#DIV/0!2007ERROR:#DIV/0!ERROR:#DIV/0!5,584ERROR:#DIV/0!3007ERROR:#DIV/0!ERROR:#DIV/0!5,584ERROR:#DIV/0!4007ERROR:#DIV/0!ERROR:#DIV/0!5,584ERROR:#DIV/0!
Richford - Propane0008ERROR:#DIV/0!ERROR:#DIV/0!1107ERROR:#DIV/0!1008ERROR:#DIV/0!ERROR:#DIV/0!1107ERROR:#DIV/0!2008ERROR:#DIV/0!ERROR:#DIV/0!1107ERROR:#DIV/0!3008ERROR:#DIV/0!ERROR:#DIV/0!1107ERROR:#DIV/0!4008ERROR:#DIV/0!ERROR:#DIV/0!1107ERROR:#DIV/0!
West Berkshire- Propane0009ERROR:#DIV/0!ERROR:#DIV/0!495ERROR:#DIV/0!1009ERROR:#DIV/0!ERROR:#DIV/0!495ERROR:#DIV/0!2009ERROR:#DIV/0!ERROR:#DIV/0!495ERROR:#DIV/0!3009ERROR:#DIV/0!ERROR:#DIV/0!495ERROR:#DIV/0!4009ERROR:#DIV/0!ERROR:#DIV/0!495ERROR:#DIV/0!
SSA Littleton NH - Propane0010ERROR:#DIV/0!ERROR:#DIV/0!4920ERROR:#DIV/0!1010ERROR:#DIV/0!ERROR:#DIV/0!4920ERROR:#DIV/0!2010ERROR:#DIV/0!ERROR:#DIV/0!4920ERROR:#DIV/0!3010ERROR:#DIV/0!ERROR:#DIV/0!4920ERROR:#DIV/0!4010ERROR:#DIV/0!ERROR:#DIV/0!4920ERROR:#DIV/0!
TOTALSERROR:#DIV/0!$ -$ -$ -$ -

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