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) detailing natural gas procurement pricing methodology and monthly quantity estimates. The worksheet outlines estimated quantities for natural gas delivery across 12 months, 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, reflecting seasonal usage patterns.
The pricing structure consists of three components: an estimated NYMEX price (fixed at $5.00 for evaluation purposes), Marketer's Margin (a fixed component), and Marketer's Transport Charges (partially fixed with allowances for tariff changes). The total estimated annual value is $358,660. The worksheet specifies that actual usage may differ from estimates, and the NYMEX component will adjust monthly during contract performance. The Marketer's Margin is described as essentially fixed, with increases unlikely to be approved but decreases welcomed. Transport charges may be adjusted based on documented external factors such as tariff changes.
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 | |
| 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 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 .