Attachment A -UPDATED.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
NATURAL GAS BROKER
Solicitation number
5400027174
Issued by
Charleston County, Charleston City, South Carolina

About this file

This document is an attachment, titled "ATTACHMENT A - Price Calculations," related to a Natural Gas Broker contract opportunity involving the state of South Carolina and the jurisdictions of Charleston County and Charleston City. The attachment provides a pricing worksheet for offerors to enter their "Marketer's Basis/dt" for each month over a two-year contract term. The estimated quantities range from approximately 41,584 to 56,310 decatherms per month, with a total annual estimated quantity of 564,351 decatherms. The estimated NYMEX price is $1.60 per decatherm, and the "Marketer's Basis" is a fixed component of the price. The "Estimated Unit Price" and "Estimated Extended Price" will update automatically based on the offeror's input.

The pricing terms expressly state that the actual NYMEX futures pricing at the start of the contract term will be used for determining the actual starting prices, and that elements of the "Marketer's Basis" component may not be within the span of control of the offeror, such as tariffs. Offerors are instructed to enter the "Marketer's Basis/dt" for each month, and the "Estimated Unit Prices" and "Estimated Extended Price" will be calculated accordingly.

View the file

Other files

File Type Posted
Attachment A -UPDATED.xlsx XLSX spreadsheet
IFB.pdf PDF
Attachmenht B.xls XLS spreadsheet
Attachment C.xlsx XLSX spreadsheet
Amendment 1.pdf PDF
Attachment A.xlsx XLSX spreadsheet
Attachment C.xlsx XLSX spreadsheet
IFB.pdf PDF
Attachment A.xlsx XLSX spreadsheet
Attachmenht B.xls XLS spreadsheet
IFB.pdf PDF
Attachmenht B.xls XLS spreadsheet
Attachment A.xlsx XLSX spreadsheet
Attachment C.xlsx XLSX spreadsheet
Show all 14

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

Sheet1 ATTACHMENT A - Price Calculations

NOTE: When completing the calculations below, the offeror needs to be aware of the following:
1. "Estimated Quantity" is our best estimate based on previous usage. There is no expectation that the actual usage during the performance phase of the resulting contract will match the estimates exactly.
2. The $1.60 "Estimated NYMEX" listed on the worksheet is intended to be used for evaluation purposes only. The actual NYMEX futures pricing at the start of the contract term will be used for determining the actual starting prices.
4. "Marketer's Basis" is a fixed component of price. However there are elements of this component which are not within the span of control of the offeror (Example: Tarrifs). The pricing terms expressly state what and how price changes of this portion of price will be considered.
5. "Estimated Unit Price" is the sum total of the "Estimated NYMEX" + "Marketer's Margin" + Marketer's Transport Charges".
6. "Estimated Extended Price" is the product of "Estimated Quantity" x "Estimated Unit Price" expressed to the nearest dollar.

Dominion

Offerors need only enter their "Marketer's Basis/dt" for each month.

"Estimated Unit Prices" and "Estimated Extended Price" should update automatically.
Year 1Year 2
MonthEstimated Quantity in dtEstimated NYMEX/dtMarketer's Basis/dtEstimated Unit PriceEstimated Extended PriceMonthEstimated Quantity in dtEstimated NYMEX/dtMarketer's Basis/dtEstimated Unit PriceEstimated Extended Price
June42,768$1.60$1.6000$68,429June42,768$1.60$1.6000$68,429
July41,584$1.60$1.6000$66,535July41,584$1.60$1.6000$66,535
August42,009$1.60$1.6000$67,215August42,009$1.60$1.6000$67,215
September44,029$1.60$1.6000$70,447September44,029$1.60$1.6000$70,447
October48,194$1.60$1.6000$77,111October48,194$1.60$1.6000$77,111
November48,260$1.60$1.6000$77,217November48,260$1.60$1.6000$77,217
December45,239$1.60$1.6000$72,383December45,239$1.60$1.6000$72,383
January45,278$1.60$1.6000$72,445January45,278$1.60$1.6000$72,445
February56,310$1.60$1.6000$90,097February56,310$1.60$1.6000$90,097
March53,429$1.60$1.6000$85,487March53,429$1.60$1.6000$85,487
April49,559$1.60$1.6000$79,295April49,559$1.60$1.6000$79,295
May47,688$1.60$1.6000$76,301May47,688$1.60$1.6000$76,301

Annual Totals 564,351 enter this number on bid schedule for Year 1 $902,961 Year 1 Estimated Price Annual Totals 564,351 enter this number on bid schedule for Year 2 $902,961 Year 2 Estimated Price

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