Price Contracts
Table of Contents
Setting Up A New Price Contract for Purchaser
Other basic information is needed before creating the actual Price Contract. Several factors may also be involved in determining the actual price paid for the product. These may include Gravity, BS&W, and Sulfur content, among others. For this example, we are going to assume the contract is for a new property with a new operator, and various factors impact the price.
Assumptions:
- Operator – Digger Operating, LLC - Texas Taxpayer # 1746518252
- Property – TX0004
- Product - Oil
- Price Index is TXCR, and the type is POSTED
- Adjustments for Gravity, BS&W and Sulfur content
To set up the operator, go to Master File Maintenance > #70 Purchaser/Operator [F12]. This will bring up the following screen. For our example, 60 is the Sub-Table for Operators.
To add the new operator, click the Add button at the bottom of the screen. Leave the table as 60. The Sub-Account Maintenance is a code for this specific operator. It can be up to 10 characters long and be alpha, numeric or any combination thereof. Our new operator is Digger Operating Company, and we are going to assign DIGOIL as his Sub-Account code. You would key in the name, address, and contact information you have.
The Operator tab is where you identify how this operator wants to receive their statements. Statements can be printed, sent via email, or both. If sending by email, enter the email in the E-Mail field. Multiple addresses can be entered by using a semi-colon between the addresses. Do not put a space between the semi-colon and the next address.
The State ID tab is where the operator's ID can be entered. Enter the Texas Taxpayer # 1746518252. Since our property is located in Texas, enter the Texas Taxpayer # as shown below. If the operator receives his statement via email, there is an option to include an XLXS copy of the file tickets.
Pricing information is set up under the menu heading Pricing/Other File Maintenance. There are 2 index types: Posted and Composition. The Posted is when the price is based on a single index. The Composition is used when the price is based on more than 1 index.
Our contract price is based on a single index TXCR, which we must set up. (TIP: If you have another contract based on this index, you need not set it up again. The same index can be used for multiple contracts.)
To add a new index, click the Add button at the bottom of the screen. In the Price Index Number field, enter TXCR. Type the name of this index in the Price Index Name field. Select Index Type “Posted”. See Price Index for more information on the different check boxes and options.
Enter the date; the Day will populate for you, and you will then enter the price. The example below has some dates entered. If holidays are to be ignored when calculating the monthly average, click that box beside that price. The Monthly Avg. is calculated for you. As you enter more dates, the Monthly Avg is recalculated for you. You will be adding more dates and prices to the index regularly. To add more, click on the plus (+) in the mini toolbar in the screen's bottom left corner.
Gravity is a standard industry measure of the density of liquid petroleum products. Very light crude oils and gasoline have a gravity(density) between 50 to 60. Light crude oil ranges from 35 to 45. Heavy crude oils range from about 6 to 25. The gravity is a factor in determining the quality of the petroleum product. Most purchasers either penalize the seller for gravity outside a specific range or reward them for gravity within a specific range. A gravity scale matrix is set up to address these adjustments to the price calculation in the contract.
Go to Pricing/Other File Maintenance menu > 51 Scales and Rates > Gravity Scale Maintenance. Our example allows us to deduct $0.10 from the price for each degree from 31.0 to 40 on the posted index price. If the gravity is between zero and 31, we will deduct $0.20 for each degree below 31. To set this up, click on the Add in the lower left corner of the Gravity Scale Maintenance screen. Our example is named TXCR1.
For example, if the gravity on a run ticket is 37.2, the adjustment is a deduction of $3.72 per barrel off of the posted index price. (37.2 * .10 = $3.72 per barrel). So if the index price is $43.85, the price paid is $40.13 ($43.85 – $3.72).
BS&W is the acronym for Basic Sediment and Water. When extracted from an Oil Reservoir, the crude oil will contain water and suspended solids from the reservoir formation. The particulate matter is known as sediment or mud. The bulk of the water and sediment is usually separated at the field to minimize the quantity that needs to be transported further. The residual content of these unwanted impurities is measured as BS&W. It is measured from a liquid sample of the production stream as a volume percentage of the production stream.
Go to Go to Pricing/Other File Maintenance menu > 51 Scales and Rates > BS & W Scale Maintenance. Our price contract provides for a deduction of $8 from the Indexed Price for each 0.1 percent of BS&W above 0.90%. To add this adjustment for BS&W, click Add in the maintenance screen's bottom left corner. Name this adjustment TXCR1 for this example.
Sulfur is another common contaminant that may adversely affect the price. To see it, Go to the Pricing/Other File Maintenance menu > 51 Scales and Rates > Sulfur Scale Maintenance. For our example, we will reduce the posted index price per barrel by $0.75 times the sulfur content of the oil as measured by percentage.
For example: if the sulfur content is 0.55%, we will deduct $0.42 per barrel from the posted index price (0.55 * -0.44 = -$0.42).
Now that the price adjustments have been set up and the index is set up, we are ready to set up the price contract. (NOTE: The information on the General tab is for informational purposes only; it is not required.) Our contract has a specific start date of 03/01/2023 and automatically renews. We must provide 60 days notice prior to canceling the contract. To add the contract, click Add in the bottom left-hand corner of the Price Contract Maintenance screen. Our contract number is TA321. Our operator is Digger Operating Company (previously added under the Operator maintenance). The General tab is shown below.
Our next critical tab is the Pricing tab. This is where we identify the purchaser, the price index, the price type, and the adjustment codes we have set up for Gravity, BS&W, and Sulfur. The first section of this screen addresses Price Contract Limits.
Both the Sulfur and Gravity limit options require a 2nd contract. When either the Sulfur, Gravity, BS&W, or Iron option is checked in the Price Contract Limit section, a field to specify the limit and the contract to use when this limit is exceeded is accessible to the right.
Property Maintenance
The last step is to assign the contract to the property. While still in the Price Contract, click on the Properties Using tab. Click the green "+" at the bottom of the screen to add a new line. Enter the start date of 03/01/2022 (remember the start date on the contract maintenance!) and use the lookup to find and select contract TA321. Be sure to save the screen. We will leave the defaults for the Gravity, BS&W, and Sulfur adjustments set to Yes.
Another way to attach a Price Contract to a Property is through the Master File Maintenance > Property > Price Contract tab. Since the property was already added through the Price Contract, the information has already been populated in Property Maintenance.