Attachment A-.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- NATURAL GAS MANAGEMENT
- Solicitation number
- 5400027839
- Issued by
- Richland County, South Carolina
About this file
This is a pricing calculation worksheet (Attachment A) for a Natural Gas Management contract opportunity for the State of South Carolina. The document outlines monthly estimated natural gas quantities totaling 71,732 units annually, with usage varying seasonally from a low of 3,944 units in May to a high of 10,473 units in January. No specific contract term dates are provided in this document.
The pricing structure consists of three components: an Estimated NYMEX rate (set at $5.00 for evaluation purposes), Marketer's Margin (a fixed component), and Marketer's Transport Charges (fixed but subject to tariff adjustments). The total estimated annual contract value based on these calculations is $358,660. The worksheet specifies that the NYMEX rate is variable and adjusts monthly, while the Marketer's Margin is generally fixed with decreases more likely to be approved than increases. Transport charges may be adjusted based on factors outside the marketer's control, such as tariffs.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment B-.xls | XLS spreadsheet | |
| 5400027839 Amendment 1.rtf | RTF text file | |
| 5400027839 Full Bid.rtf | RTF text file | |
| 5400027839 Intent.doc | DOC document | |
| Attachment A-.xlsx | XLSX spreadsheet | |
| 5400027839 Intent.doc | DOC document | |
| 5400027839 Amendment 1.rtf | RTF text file | |
| Attachment B-.xls | XLS spreadsheet | |
| 5400027839 Full Bid.rtf | RTF text file | |
| 5400027839 Amendment 1.rtf | RTF text file | |
| Attachment A-.xlsx | XLSX spreadsheet | |
| Attachment B-.xls | XLS spreadsheet | |
| 5400027839 Intent.doc | DOC document | |
| 5400027839 Full Bid.rtf | RTF text file | |
| Attachment A-.xlsx | XLSX spreadsheet | |
| 5400027839 Full Bid.rtf | RTF text file | |
| 5400027839 Amendment 1.rtf | RTF text file | |
| Attachment B-.xls | XLS spreadsheet | |
| Attachment A-.xlsx | XLSX spreadsheet | |
| Attachment B-.xls | XLS spreadsheet | |
| 5400027839 Full Bid.rtf | RTF text file |
Show all 21
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
Price Calculations 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 NYMEX is a variable component of price which adjusts monthly. The $5.00 "Estimated NYMEX" listed on the worksheet is intended to be used for evaluation purposes only. The actual NYMEX at the start of the contract term will be used for determining the actual starting prices. Pricing from that point forward will adjust with the NYMEX monthly. | |
| 3. "Marketer's Margin" is a fixed component of the price. It is difficult to conceive of a set of circumtances that would persuade the State to agree to an increase in the margin. A decrease request will likely receive immediate State approval. | |
| 4. "Marketer's Transport Charges" 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 Margin" and "Marketer's Transport Charges" for each month.
"Estimated Unit Prices" and "Estimated Extended Price" should update automatically.
Month Estimated Quantity Estimated NYMEX Marketer's Margin Marketer's Transport Charges Estimated Unit Price Estimated Extended Price
| July | 4,273 | $5.00 | $5.0000 | $21,365 |
| August | 3,975 | $5.00 | $5.0000 | $19,875 |
| September | 3,975 | $5.00 | $5.0000 | $19,875 |
| October | 4,977 | $5.00 | $5.0000 | $24,885 |
| November | 6,488 | $5.00 | $5.0000 | $32,440 |
| December | 9,675 | $5.00 | $5.0000 | $48,375 |
| January | 10,473 | $5.00 | $5.0000 | $52,365 |
| February | 8,656 | $5.00 | $5.0000 | $43,280 |
| March | 6,476 | $5.00 | $5.0000 | $32,380 |
| April | 4,840 | $5.00 | $5.0000 | $24,200 |
| May | 3,944 | $5.00 | $5.0000 | $19,720 |
| June | 3,980 | $5.00 | $5.0000 | $19,900 |
Annual Totals 71,732 $358,660
All fields beyond this point should automatically update. Offerors should confirm same prior to submittal.
Annual Total Estimated Extended Price $358,660
GRAND TOTAL ENTER THIS NUMBER ON THE BID SCHEDULE $358,660
File details come from the government source that posted it. Updated .