Solicitation Attachment 1 Price Sheet 2022 03 11.xlsx
XLSX spreadsheet 21 KB Posted
- Solicitation number
- 47PB0022Q0008
About this file
This solicitation attachment provides pricing instructions and a pricing sheet for offerors to submit fuel supply and delivery services proposals to the General Services Administration. The solicitation seeks annual supply and delivery of #2 fuel oil, low sulfur off road diesel, winter blend, and propane for locations throughout Maine. Offerors must provide index rates for each fuel product for the base year and margin rates for the base year and each option period in the highlighted cells. The pricing sheet will automatically calculate unit prices, estimated quantities, and evaluated prices. Proposals are due by March 28, 2022. The primary NAICS code is 454310 with a 100-employee size standard. The procurement will be set aside as a total small business opportunity.
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, 4/1/2022-3/31/2023 | Option Year 1, 4/1/2023 through 3/31/2024 | Option Year 2, 4/1/2024 through 3/21/2025 | Option Year 3, 4/1/2025 through 3/31/2026 | Option Year 4, 4/1/2026 through 3/31/2027 | |||||||||||||||||||||||||||||
| Service | CLIN | Index Rate 1 April 30, 2021 | Index Rate 2 October 1, 2021 | Index Rate February 1, 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 |
| Calais New Bridge (ME0851BI) - Low Sulfur Off Road Diesel | 0001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 750 | ERROR:#DIV/0! | 1001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | 2001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | 3001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | 4001 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | ||||||||
| Calais New Bridge (ME0851BI) - Propane | 0002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 52,311 | ERROR:#DIV/0! | 1002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 103,500 | ERROR:#DIV/0! | 2002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 103,500 | ERROR:#DIV/0! | 3002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 103,500 | ERROR:#DIV/0! | 4002 | ERROR:#DIV/0! | ERROR:#DIV/0! | 103,500 | ERROR:#DIV/0! | ||||||||
| Calais Ferry Point (ME0501BC) - #2 Fuel Oil/Low Sulfur Off Road Diesel | 0003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,612 | ERROR:#DIV/0! | 1003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,031 | ERROR:#DIV/0! | 2003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,031 | ERROR:#DIV/0! | 3003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,031 | ERROR:#DIV/0! | 4003 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,031 | ERROR:#DIV/0! | ||||||||
| Calais Milltown (ME0091ZZ) - Propane | 0004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,293 | ERROR:#DIV/0! | 1004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,881 | ERROR:#DIV/0! | 2004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,881 | ERROR:#DIV/0! | 3004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,881 | ERROR:#DIV/0! | 4004 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,881 | ERROR:#DIV/0! | ||||||||
| Coburn Gore (ME0551BE) - Propane | 0005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 328 | ERROR:#DIV/0! | 1005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 288 | ERROR:#DIV/0! | 2005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 288 | ERROR:#DIV/0! | 3005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 288 | ERROR:#DIV/0! | 4005 | ERROR:#DIV/0! | ERROR:#DIV/0! | 288 | ERROR:#DIV/0! | ||||||||
| Coburn Gore (ME0551BE) - #2 Fuel Oil | 0006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,568 | ERROR:#DIV/0! | 1006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,450 | ERROR:#DIV/0! | 2006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,450 | ERROR:#DIV/0! | 3006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,450 | ERROR:#DIV/0! | 4006 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,450 | ERROR:#DIV/0! | ||||||||
| Coburn Gore Residence (ME0553BE) - #2 Fuel Oil | 0007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,436 | ERROR:#DIV/0! | 1007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 2007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 3007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 4007 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | ||||||||
| Coburn Gore Residence (ME0554BE) - #2 Fuel Oil | 0008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 804 | ERROR:#DIV/0! | 1008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 2008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 3008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 4008 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | ||||||||
| Coburn Gore Residence (ME0555BE) - #2 Fuel Oil | 0009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 791 | ERROR:#DIV/0! | 1009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 2009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 3009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | 4009 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,438 | ERROR:#DIV/0! | ||||||||
| Ft. Fairfeld (ME0601BF) - Propane | 0010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 76 | ERROR:#DIV/0! | 1010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | 2010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | 3010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | 4010 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | ||||||||
| Ft. Fairfeld (ME0601BF) - #2 Fuel Oil | 0011 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,470 | ERROR:#DIV/0! | 1011 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,981 | ERROR:#DIV/0! | 2011 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,981 | ERROR:#DIV/0! | 3011 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,981 | ERROR:#DIV/0! | 4011 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,981 | ERROR:#DIV/0! | ||||||||
| Ft. Kent (ME0088ZZ) - Low Sulfur Off Road Diesel | 0012 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,623 | ERROR:#DIV/0! | 1012 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,750 | ERROR:#DIV/0! | 2012 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,750 | ERROR:#DIV/0! | 3012 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,750 | ERROR:#DIV/0! | 4012 | ERROR:#DIV/0! | ERROR:#DIV/0! | 5,750 | ERROR:#DIV/0! | ||||||||
| Limestone (ME0701BL) - Propane | 0013 | ERROR:#DIV/0! | ERROR:#DIV/0! | 147 | ERROR:#DIV/0! | 1013 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | 2013 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | 3013 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | 4013 | ERROR:#DIV/0! | ERROR:#DIV/0! | 575 | ERROR:#DIV/0! | ||||||||
| Limestone (ME0701BL) - #2 Fuel Oil | 0014 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,132 | ERROR:#DIV/0! | 1014 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | 2014 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | 3014 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | 4014 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | ||||||||
| Madawaska (ME0051ZZ) - #2 Fuel Oil/Low Sulfur Off Road Diesel | 0015 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,162 | ERROR:#DIV/0! | 1015 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,246 | ERROR:#DIV/0! | 2015 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,246 | ERROR:#DIV/0! | 3015 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,246 | ERROR:#DIV/0! | 4015 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,246 | ERROR:#DIV/0! | ||||||||
| Orient (ME0751BT) - Propane | 0016 | ERROR:#DIV/0! | ERROR:#DIV/0! | 260 | ERROR:#DIV/0! | 1016 | ERROR:#DIV/0! | ERROR:#DIV/0! | 719 | ERROR:#DIV/0! | 2016 | ERROR:#DIV/0! | ERROR:#DIV/0! | 719 | ERROR:#DIV/0! | 3016 | ERROR:#DIV/0! | ERROR:#DIV/0! | 719 | ERROR:#DIV/0! | 4016 | ERROR:#DIV/0! | ERROR:#DIV/0! | 719 | ERROR:#DIV/0! | ||||||||
| Orient (ME0751BT) - #2 Fuel Oil | 0017 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,421 | ERROR:#DIV/0! | 1017 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | 2017 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | 3017 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | 4017 | ERROR:#DIV/0! | ERROR:#DIV/0! | 2,372 | ERROR:#DIV/0! | ||||||||
| Presque Isle (ME0078ZZ) - #2 Fuel Oil | 0018 | ERROR:#DIV/0! | ERROR:#DIV/0! | 1,607 | ERROR:#DIV/0! | 1018 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,888 | ERROR:#DIV/0! | 2018 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,888 | ERROR:#DIV/0! | 3018 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,888 | ERROR:#DIV/0! | 4018 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,888 | ERROR:#DIV/0! | ||||||||
| Van Buren (ME0843BX) - Low Sulfur Off Road Diesel | 0019 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,472 | ERROR:#DIV/0! | 1019 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | 2019 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | 3019 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | 4019 | ERROR:#DIV/0! | ERROR:#DIV/0! | 7,245 | ERROR:#DIV/0! | ||||||||
| Vanceboro (ME0832BV) - #2 Fuel Oil/Winter Blend/Low Sulfur Off Road Diesel | 0020 | ERROR:#DIV/0! | ERROR:#DIV/0! | 3,484 | ERROR:#DIV/0! | 1020 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,600 | ERROR:#DIV/0! | 2020 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,600 | ERROR:#DIV/0! | 3020 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,600 | ERROR:#DIV/0! | 4020 | ERROR:#DIV/0! | ERROR:#DIV/0! | 4,600 | ERROR:#DIV/0! | ||||||||
| Escourt (ME4033ZZ) - Propane | 0021 | ERROR:#DIV/0! | ERROR:#DIV/0! | 870 | ERROR:#DIV/0! | 1021 | ERROR:#DIV/0! | ERROR:#DIV/0! | 504 | ERROR:#DIV/0! | 2021 | ERROR:#DIV/0! | ERROR:#DIV/0! | 504 | ERROR:#DIV/0! | 3021 | ERROR:#DIV/0! | ERROR:#DIV/0! | 504 | ERROR:#DIV/0! | 4021 | ERROR:#DIV/0! | ERROR:#DIV/0! | 504 | ERROR:#DIV/0! | ||||||||
| TOTALS | ERROR:#DIV/0! | $ - | $ - | $ - | $ - |
File details come from the government source that posted it. Updated .