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 price calculation worksheet (Attachment A) for a Natural Gas Management contract opportunity in Richland County, South Carolina. The document outlines monthly estimated natural gas quantities totaling 71,732 units annually, with monthly variations ranging from a low of 3,944 units in May to a high of 10,473 units in January, demonstrating seasonal fluctuation in usage patterns.
The pricing structure consists of three components: an estimated NYMEX price (set at $5.00 for evaluation purposes), Marketer's Margin, and Marketer's Transport Charges. The NYMEX component is variable and adjusts monthly, while the Marketer's Margin and Transport Charges are fixed components, though transport charges may be adjusted due to factors outside the marketer's control, such as tariffs. The total estimated annual value based on the worksheet calculations is $358,660. Offerors are required to complete only the Marketer's Margin and Marketer's Transport Charges fields, with other calculations updating automatically.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment B-.xls | XLS spreadsheet | |
| Attachment A-.xlsx | XLSX spreadsheet | |
| 5400027839 Amendment 1.rtf | RTF text file | |
| 5400027839 Full Bid.rtf | RTF text file | |
| 5400027839 Intent.doc | DOC document | |
| 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 .