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
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/2023 | Option Year 1, 7/1/2023 through 6/30/2024 | Option Year 2, 7/1/2024 through 6/30/2025 | Option Year 3, 7/1/2025 through 6/30/2026 | Option Year 4, 7/1/2026 through 6/30/2027 | |||||||||||||||||||||||||||||
| Service | CLIN | Index Rate 1 October 1, 2021 | Index Rate 2 February 1, 2022 | Index Rate 3 April 30, 2022 | Average Index Rate | Margin Rate | Unit Price | Estimated Quantities (1G=Gallons) | Evaluated Price | CLIN | Average Index Rate (From Base Year) | Margin Rate | Unit Price | Estimated Quantities (1G=Gallons) | Evaluated Price | CLIN | Average Index Rate (From Base Year) | Margin Rate | Unit Price | Estimated Quantities (1G=Gallons) | Evaluated Price | CLIN | Average Index Rate (From Base Year) | Margin Rate | Unit Price | Estimated Quantities (1G=Gallons) | Evaluated Price | CLIN | Average Index Rate (From Base Year) | Margin Rate | Unit Price | Estimated Quantities (1G=Gallons) | Evaluated Price |
| Alburg Springs - Propane | 0001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 27 | ERROR:#DIV/0! | 1001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 27 | ERROR:#DIV/0! | 2001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 27 | ERROR:#DIV/0! | 3001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 27 | ERROR:#DIV/0! | 4001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 27 | ERROR:#DIV/0! | ||||||||
| Beecher Falls - Propane | 0002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 116 | ERROR:#DIV/0! | 1002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 116 | ERROR:#DIV/0! | 2002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 116 | ERROR:#DIV/0! | 3002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 116 | ERROR:#DIV/0! | 4002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 116 | ERROR:#DIV/0! | ||||||||
| Canaan - Propane | 0003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 62 | ERROR:#DIV/0! | 1003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 62 | ERROR:#DIV/0! | 2003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 62 | ERROR:#DIV/0! | 3003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 62 | ERROR:#DIV/0! | 4003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 62 | ERROR:#DIV/0! | ||||||||
| East Richford - Propane | 0004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 216 | ERROR:#DIV/0! | 1004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 216 | ERROR:#DIV/0! | 2004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 216 | ERROR:#DIV/0! | 3004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 216 | ERROR:#DIV/0! | 4004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 216 | ERROR:#DIV/0! | ||||||||
| Highgate Springs - Propane | 0005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 44491 | ERROR:#DIV/0! | 1005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 44491 | ERROR:#DIV/0! | 2005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 44491 | ERROR:#DIV/0! | 3005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 44491 | ERROR:#DIV/0! | 4005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 44491 | ERROR:#DIV/0! | ||||||||
| USDA / FDA Building at Highgate Springs - Propane/Diesel | 0006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,168 | ERROR:#DIV/0! | 1006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,168 | ERROR:#DIV/0! | 2006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,168 | ERROR:#DIV/0! | 3006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,168 | ERROR:#DIV/0! | 4006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,168 | ERROR:#DIV/0! | ||||||||
| Montpelier Social Security - Propane | 0007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,584 | ERROR:#DIV/0! | 1007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,584 | ERROR:#DIV/0! | 2007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,584 | ERROR:#DIV/0! | 3007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,584 | ERROR:#DIV/0! | 4007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,584 | ERROR:#DIV/0! | ||||||||
| Richford - Propane | 0008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1107 | ERROR:#DIV/0! | 1008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1107 | ERROR:#DIV/0! | 2008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1107 | ERROR:#DIV/0! | 3008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1107 | ERROR:#DIV/0! | 4008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1107 | ERROR:#DIV/0! | ||||||||
| West Berkshire- Propane | 0009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 495 | ERROR:#DIV/0! | 1009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 495 | ERROR:#DIV/0! | 2009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 495 | ERROR:#DIV/0! | 3009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 495 | ERROR:#DIV/0! | 4009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 495 | ERROR:#DIV/0! | ||||||||
| SSA Littleton NH - Propane | 0010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4920 | ERROR:#DIV/0! | 1010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4920 | ERROR:#DIV/0! | 2010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4920 | ERROR:#DIV/0! | 3010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4920 | ERROR:#DIV/0! | 4010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4920 | ERROR:#DIV/0! | ||||||||
| TOTALS | ERROR:#DIV/0! | $ - | $ - | $ - | $ - |
File details come from the government source that posted it. Updated .