Attachment_1_VT_Buildings_Amendment_1.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Supply Fuel and Propane Delivery to Various Locations in Vermont
Solicitation number
1PQB-VTFUELFY18
Issued by

About this file

From the source

Attachment 1, VT Buildings Price Sheet, Amendment 1

View the file

Other files

File Type Posted
Exhibit_1_VT_-_Revision_1.xlsx XLSX spreadsheet
VT_Solicitation.Statement_of_Work._Revision_1.pdf PDF
Attachment_1_VT_Buildings_Amendment_2.xlsx XLSX spreadsheet
VT_Solicitation.Statement_of_Work.pdf PDF
Attachment_1_VT_Buildings.xlsx XLSX spreadsheet
Exhibit_1_VT.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

Instructions to Offerors
Please enter ON THE SECOND TAB LABELED PRICE PROPOSAL
your Index and Margin rate on the Buildings you wish to submit a Bid for.
The cells for price entry are highlighted in yellow.
The contract unit price per gallon of oil and propane will consist of two components –
the current index rate and a margin inclusive of all contractor markup.
The unit price is expressed as follows: Unit Price= Current Index Rate + Contractor Margin.
The Total Lump Sum price is expressed as follows: Total Price = Estimated Quantity x Unit Price
Below is an Example: (these are notional rates, not a Government estimated rate)
Building NumberBuilding InformationEstimated Quantities (Gallons)CLINIndex RateMargin RateUnit PriceTotal Lump Sum Price
VT0014ZZRichford - Fuel Oil2014CLIN 0001$2.99$0.21$3.20$6,444.80
VT0851BWW. Berkshire- Fuel Oil2671CLIN 0002$2.77$0.21$2.98$7,959.58
VT0551BSAlburg Springs - Fuel Oil1209CLIN 0003$2.20$0.21$2.41$2,913.69
VT0002ZZBeecher Falls - Fuel Oil1782CLIN 0004$2.88$0.21$3.09$5,506.38
VT0007ZZCanaan - Fuel Oil1385CLIN 0005$2.20$0.21$2.41$3,337.85
VT0008ZZE. Richford - Fuel Oil2038CLIN 0006$3.22$0.21$3.43$6,990.34
VT0601BPBeebe Plain - Fuel Oil1205CLIN 0007$4.66$0.21$4.87$5,868.35
VT0601BPBeebe Plain -Propane250CLIN 0008$1.58$0.21$1.79$447.50
VT0651PDDerby Line Rt 5 - Fuel Oil5506CLIN 0009$2.11$0.21$2.32$12,773.92
VT0651PDDerby Line Rt 5 - Propane1188CLIN 0010$1.77$0.21$1.98$2,352.24
VT0651PDDerby Line Rt 5 - Kerosene350CLIN 0011$1.99$0.21$2.20$770.00
VT0651PDDerby Line I-91 - Fuel Oil9222CLIN 0012$2.20$0.21$2.41$22,225.02
VT0651PDDerby Line I-91 Propane2148CLIN 0013$1.79$0.21$2.00$4,296.00
VT0756BTNew North Troy - Propane9653CLIN 0014$1.77$0.21$1.98$19,112.94
VT0801BNNorton - Propane557CLIN 0015$1.78$0.21$1.99$1,108.43
VT0801BNNorton - Fuel Oil5280CLIN 0016$2.22$0.21$2.43$12,830.40
TOTAL$114,937.44
See Exhibit 1 for Building Specifications

Price Proposal

BASE YEAR, 10/01/17 through 09/30/18OPTION YEAR 1, 10/01/18 through 09/30/19OPTION YEAR 2, 10/01/19 through 09/30/20OPTION YEAR 3, 10/01/20 through 09/30/21OPTION YEAR 4, 10/01/21 through 09/30/22
Building NumberBuilding InformationEstimated Quantities (1G=Gallons)CLINIndex RateMargin RateUnit PriceTotal Lump Sum PriceCLINIndex RateMargin RateUnit PriceTotal Lump Sum PriceCLINIndex RateMargin RateUnit PriceTotal Lump Sum PriceCLINIndex RateMargin RateUnit PriceTotal Lump Sum PriceCLINIndex RateMargin RateUnit PriceTotal Lump Sum Price
VT0014ZZRichford - Fuel Oil2014CLIN 000100CLIN 100100CLIN 200100CLIN 300100CLIN 400100
VT0851BWW. Berkshire- Fuel Oil2671CLIN 000200CLIN 100200CLIN 200200CLIN 300200CLIN 400200
VT0551BSAlburg Springs - Fuel Oil1209CLIN 000300CLIN 100300CLIN 200300CLIN 300300CLIN 400300
VT0002ZZBeecher Falls - Fuel Oil1782CLIN 000400CLIN 100400CLIN 200400CLIN 300400CLIN 400400
VT0007ZZCanaan - Fuel Oil1,385CLIN 000500CLIN 100500CLIN 200500CLIN 300500CLIN 400500
VT0008ZZE. Richford - Fuel Oil2,038CLIN 000600CLIN 100600CLIN 200600CLIN 300600CLIN 400600
VT0601BPBeebe Plain - Fuel Oil1205CLIN 000700CLIN 100700CLIN 200700CLIN 300700CLIN 400700
VT0601BPBeebe Plain -Propane250CLIN 000800CLIN 100800CLIN 200800CLIN 300800CLIN 400800
VT0651PDDerby Line Rt 5 - Fuel Oil5,506CLIN 000900CLIN 100900CLIN 200900CLIN 300900CLIN 400900
VT0651PDDerby Line Rt 5 - Propane1188CLIN 001000CLIN 101000CLIN 201000CLIN 301000CLIN 401000
VT0651PDDerby Line Rt 5 - Kerosene350CLIN 001100CLIN 101100CLIN 201100CLIN 301100CLIN 401100
VT0651PDDerby Line I-91 - Fuel Oil9,222CLIN 001200CLIN 101200CLIN 201200CLIN 301200CLIN 401200
VT0651PDDerby Line I-91 Propane2,148CLIN 001300CLIN 101300CLIN 201300CLIN 301300CLIN 401300
VT0756BTNew North Troy - Propane9,653CLIN 001400CLIN 101400CLIN 201400CLIN 301400CLIN 401400
VT0801BNNorton - Propane557CLIN 001500CLIN 101500CLIN 201500CLIN 301500CLIN 401500
VT0801BNNorton - Fuel Oil5,280CLIN 001600CLIN 101600CLIN 201600CLIN 301600CLIN 401600
TOTAL BASE YEAR0TOTAL OPTION ONE$0.00TOTAL OPTION TWO$0.00TOTAL OPTION THREE$0.00TOTAL OPTION FOUR$0.00
Base and All Option Value$0.00
*Fill in yellow highlighted cells for all buildings being bid on

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