Formula & Average Pricing in the Oil & Gas Industry (2024)

Formula & Average Pricing in the Oil & Gas Industry (1)

April 30, 2015 6 minute read

In case you have noticed my other blogs then you must have already got an idea about the Upstream & Downstream Industry Process Overview & SAP Solutions in the Oil & Gas Industry.

If you did not get a chance, for Upstream refer: http://scn.sap.com/community/oil-and-gas/blog/2015/04/27/upstream-industry-process-overview-sap-solutions

For Downstream refer: http://scn.sap.com/community/oil-and-gas/blog/2015/04/28/downstream-industry-process-overview-sap-solutions

We have already discussed about the Downstream Industry Value Chain where you have noticed that Marketing Accounting & Pricing component plays quite a crucial role while we talk about Oil & Gas Industry. MAP) component is basically enhanced with many additional functions such as contract pricing, cumulative contract call off pricing, customer pricelist, default price lists etc. required for the downstream oil business.

Now let’s focus about Pricing portion in the Downstream Industry.

Different Pricing methods and strategies can be followed by the Downstream business to cater different needs :

  • Contract Pricing
  • Cumulative Contract call-off Pricing
  • Gross & Net Volume Pricing
  • Formula & Average Pricing etc.

Again from the transfer pricing methods point of view the frequently used pricing methods are:

  • Market based pricing
  • Cost based pricing
  • Negotiated pricing
  • Free market prices for both inputs and output
  • Cost plus margin for value of services rendered etc.

Bidding is done by the Commodity traders for oil futures contract and ultimately they are responsible for the Oil prices. These kind of contracts are basically agreements to buy or sell oil at a specific date in the future for an agreed-upon price. For example: External quotations of Oil prices are provided by Platts, Reuters etc

Let’s understand what is Formula & Average Pricing & why it is useful

  • In Oil and Gas industry, the price of certain petrochemical products like Benzene, Ethylene et al may vary every day. Since the shipping process for petrochemical products can take long, especially when the shipping method is sea/marine, it is common that the price is determined by the average of these prices over a time range (a week or month) plus a surcharge.
  • Third party providers like Argus, CMAI, Opis publish the market price of these products on a daily basis; these prices are commonly known as quotes.
  • In order to accommodate the business need to calculate the price of an order based on external quotes over a period of time, SAP introduced F&A pricing in IS Oil.

Next point comes What is the purpose of Formula & Average Pricing

  • F & A Pricing indicates Formula and Average (F&A) Pricing.
  • This method of Pricing uses external quotations such as Platts, Reuters, and others to determine the price of a material.
  • The purpose of F & A Pricing is to enable the calculation of product prices based on external quotations over a set time period.
  • The calculation is performed with company-defined calculation rules. Currency fluctuations within the time period are taken into account either by daily
    conversion or by averaging.
  • F & A Pricing can be used both on the purchasing (MM) & sales side (SD).

How Business works with the F & A Pricing

  • Most of the Businesses preferred to use the spreadsheet for price calculation. For example: It could be average of 1 week quote of Benzene, while complex ones can be like 0.91Benzend+0.3Ethylene+surcharge then average by one month.

However the spreadsheet method has its portion of drawback:

  • Time Consuming to find out right spreadsheet, Plugging Numbers, Referring the Spreadsheet multiple times etc.

Now its time to know about Formula & Average Pricing in SAP

F & A Pricing in SAP is quite recommended in order to address the issues with the spreadsheet load method:

  • In IS oil F&A pricing, these special formulas can be stored in the system and later used by sales order or purchase orders for automatic calculation.
  • Formula pricing is differentiated at condition type and condition record level.
  • Comparing to regular pricing, F&A pricing has a formula to be maintained for each formula pricing record, it enables variable dates for calculation, and further allows client to define multiple rules and compare two calculation results and pick the desired final rate.

The process flow for F & A Pricing is as follows:

  • Define Formulas to be used for F & A Pricing
  • Define Condition Type for F & A Pricing
  • Using Pricing Date to Determine the Rule
  • Using F & A Pricing During Invoicing

SAP Configuration for Formula & Average Pricing

F & A Pricing can be configured from the following IMG Node:

Industry Solution Oil & Gas (Downstream)> Industry Solution Oil & Gas (Downstream)> Formula & Average Pricing

The prerequisite for the F & A Pricing Configuration will be as follows:

  • The Group Conditions field should not be activated in customising:
  • The corresponding condition types (for example, FA00) and the access sequences must be defined and included in the pricing procedure in Customizing.
  • The price quotations used by F&A pricing are defined in the quotation table.
  • We can either use table OICQP provided in SAP Oil & Gas or we can use self-defined tables for storing the quotation data.
  • Quotation data can be entered manually in Maintaining Price Quotations, or electronically by remote connection to a data provider using the External Quotation Interface.
  • Automatic Pricing for Invoice Verification is important to set: MM Specific Settings net to be set:In the purchase order, select the item and choose Item Details. In the GR/IR area of the screen, select GR-based IV (goods receipt-based invoice verification).

  • In Customizing for the Industry Solution Oil & Gas (Downstream), we define the rules for copying data from the goods receipt document to the invoice receipt document

  • This is done by choosing MAP (Marketing, Accounting and Pricing) Formula & Average Pricing>Define copy rules for invoice receipt.
  • We can enter data as required by the PrTy(pricing type for invoices) field. The pricing type for invoices controls how the system carries out repricing during invoice verification.
  • The settings for controlling invoice verification and price date control based on the goods receipt can be made in the Info record and the Vendor master data record.
  • The settings made there are automatically copied to subsequent purchase documents.
  • To access the info record, choose Environment Info record. In the info record, choose Goto Purch. Org. data 1(Purchase Organization 1), then make the following settings:

  • For goods receipt-based invoice verification, select GR-based IV in the Control area of the screen

  • For price date control, enter data as required in the Pricing date cat. field in the Conditions area of the screen

Purchasing Data – Vendor:

  • On the initial screen of the vendor master record, choose Goto Purchasing org. data >Purchasing data, then make the following settings:
    • For goods receipt-based invoice verification, select GR-based inv. verif. in the Control data area of the screen.
    • For price date control, enter data as required in the Pricing date cat. field in the Conditions area of the screen

Differential Invoice:

  • In the oil industry arrangements are often made with customers to calculate invoices based on the average price of a product over a certain period of time.
  • If the product is delivered before the averaging period has elapsed, it is necessary to create a provisional invoice.
  • When the averaging period has ended and the final price is known, the pricedifference is invoiced by creating a differential invoice.

Formula Condition Type

  • Formula pricing is identified at the condition type configuration in Transaction Code V/06.

  • Formula pricing has the calculation type as Q, commodity Price, while regular condition types have the calculation type as percentage, quantity, fixed amount, weight, etc.
  • Regular Pricing Condition Type

Formula Pricing Condition

  • The difference in the calculation type would affect our screen in VK11. Note a new icon for maintaining formulas showed up, while scales is no longer an option, nor can we enter a number amount directly for this condition record.
  • After we make an entry for our condition record like what we do with regular conditions, select the line and click on maintain formula and it will take us to the screen where we can create a new formula.
  • Note this is the first method of creating a formula. We can also choose a pre created formula repository in the system.
  • Transaction Code – O317 & O318 can be used in order to create Formula Repository.
  • Once we give a name for the formula, system take us into the below screen for formula maintenance. Note we can copy and modify from an existing formula by clicking on the Repository Proposal icon

Formula & Average Pricing in the Oil & Gas Industry (2024)

FAQs

What are the five main factors that affect the price of oil? ›

These factors include:
  • Demand.
  • Supply.
  • Quality of Oil.
  • Speculation.
  • Demand for Oil.
  • Temporary Price Fluctuations.
  • Investing in Oil and Gas Drilling.
Jan 25, 2021

How is the price of a barrel of oil determined? ›

Crude oil prices are determined by global supply and demand. Economic growth is one of the biggest factors affecting petroleum product—and therefore crude oil—demand. Growing economies increase demand for energy in general and especially for transporting goods and materials from producers to consumers.

Who controls the price of oil? ›

Petroleum prices are determined by market forces of supply and demand, not individual companies, and the price of crude oil is the primary determinant of the price we pay at the pump.

What are the factors affecting the demand and supply of oil prices? ›

The factors that affect the demand and supply of oil include levels of oil consumption, oil reserves, global exchange rates, environmental issues, politics, and oil speculation on the financial markets.

What are the 3 main factors that impact gas prices? ›

The main components of the retail price of gasoline

The cost of crude oil. Refining costs and profits. Distribution and marketing costs and profits.

What three factors drive the price of oil? ›

What affects the price of oil? The price of oil fluctuates according to three main factors: current supply, future supply, and expected global demand.

How much profit do oil companies make in a gallon of gas? ›

According to Consumer Watchdog, “PBF reported making 78 cents per gallon refining crude oil into gasoline in California in the third quarter – the greatest raw profits anywhere in the nation or world.

How much does it cost to produce 1 gallon of gasoline? ›

How much does it cost to refine gasoline? The cost to refine gasoline varies between 40 cents and 70 cents per gallon, depending on various factors. What is the cost of distributing the oil? The cost to transport the refined oil to service stations runs about 27 cents per gallon.

What is the real reason gas prices are so high? ›

As international commodity, oil is priced on an international basis — according to global supply and demand. Global demand is the reason the price is going up now. The world's economies recover from the slump of the past few years and the developing economies, like China, are increasing their demand.

Who controls 90% of oil? ›

1 OPEC+ controls more than 50% of global oil supplies and about 90% of proven oil reserves.

Why is U.S. oil production down? ›

The production decline resulted from reduced drilling activity related to low oil prices in 2020.

Does the U.S. government control the price of oil? ›

There's no specific body or policy that regulates the oil and gas industry in the U.S. but federal, state and local governments each regulate various aspects of oil and gas operations. Who regulates what mostly depends on land ownership and whether the territory is covered by federal regulations or state laws.

What is causing oil prices to drop? ›

"Crude prices are falling after a mostly in-line inflation report sealed the deal for at least one more Fed rate hike," said Edward Moya, senior market analyst at data and analytics firm OANDA. Data showed the U.S. Consumer Price Index (CPI) rose 0.4% in February from 0.5% in January.

How do you stabilize oil prices? ›

The best way to stabilize oil prices is to boost supply, and alternatives to Russian oil are available to the world, said Mathias Corman, the secretary-general of the Organization for Economic Cooperation and Development.

What is the price of oil today? ›

Crude Oil & Natural Gas
IndexUnitsPrice
CL1:COM WTI Crude Oil (Nymex)USD/bbl.69.89
CO1:COM Brent Crude (ICE)USD/bbl.73.56
CP1:COM Crude Oil (Tokyo)JPY/kl62,410.00
NG1:COM Natural Gas (Nymex)USD/MMBtu2.21

Who controls gas prices in the world? ›

Yes, policies and legislation can certainly play a role, but gas prices are largely dictated by oil prices, and oil prices are dependent upon supply and demand.

How is gas price determined? ›

Gasoline prices are determined largely by the laws of supply and demand. Gasoline prices cover the cost of acquiring and refining crude oil as well as distributing and marketing the gasoline, in addition to state and federal taxes. Gas prices also respond to geopolitical events that impact the oil market.

Who is most affected by high gas prices? ›

Prices for goods such as food, clothing, and household goods are higher than they otherwise would be since gas and diesel play an important role in supply chains. High gas prices not only hurt Americans regardless of income level, but they also disproportionately hurt the lowest income households the most.

What are the names of the 3 factors that determine price? ›

The main determinants that affect the price are: Product Cost. The Utility and Demand. The extent of Competition in the market.

What is the real cause of oil prices? ›

As COVID-19 restrictions eased and economies rebounded rapidly, demand for oil spiked. Pandemic-related supply chain disruptions exacerbated the situation, causing gas prices to go up.

What is the main factor that drives the price? ›

Supply and Demand

Prices and rates change as supply or demand changes. If something is in demand and supply begins to shrink, prices will rise. If supply increases beyond current demand, prices will fall. If supply is relatively stable, prices can fluctuate higher and lower as demand increases or decreases.

How much money do gas stations make off a gallon of gas? ›

Retailers Make Very Little Selling Gas

Generally, the markup (or “margin”) on a gallon of gas is about 15 cents per gallon (gross profit before expenses). Factoring in expenses, which include rent, utilities, freight, labor and credit card fees, a retailer is left with about 2 cents per gallon in profit.

What is the most profitable oil company? ›

Saudi Arabian Oil Company (TADAWUL:2222.SR), Equinor ASA (NYSE:EQNR), Exxon Mobil Corporation (NYSE:XOM), and Shell plc (NYSE:SHEL) are some of the most profitable oil companies in the world. Click to continue reading and see 5 Most Profitable Oil Stocks in the World.

How much do gas companies make on a gallon of gas? ›

Gas retailers receive a fraction of the price listed on the sign–their net profit per gallon is around $0.03-$0.07–after factoring in costs like labor, utilities, insurance, and credit card transaction fees. This puts the net profit margin of a gas station at less than two percent.

How many gallons of gas does a barrel of crude oil make? ›

Petroleum refineries in the United States produce about 19 to 20 gallons of motor gasoline and 11 to 12 gallons of ultra-low sulfur distillate fuel oil (most of which is sold as diesel fuel and in several states as heating oil) from one 42-gallon barrel of crude oil.

What is the cheapest gas has ever been per gallon? ›

1998. Gas prices fell substantially from 1997 to 1998, dropping from an average of $1.23 per gallon to just $1.06 per gallon, the lowest since the government began tracking gasoline prices. In some states, average costs fell below a dollar.

Do oil companies set the price of oil? ›

The price of oil as we know it is actually set in the oil futures market. 5 An oil futures contract is a binding agreement that gives one the right to purchase oil by the barrel at a predefined price on a predefined date in the future.

Where does the US get its oil? ›

The top five source countries of U.S. gross petroleum imports in 2022 were Canada, Mexico, Saudi Arabia, Iraq, and Colombia. Note: Ranking in the table is based on gross imports by country of origin. Net import volumes in the table may not equal gross imports minus exports because of independent rounding of data.

Why are oil company profits so high? ›

In addition to high prices for crude oil, elevated natural-gas prices and high margins in the refining business also pushed up oil company profit, said Peter McNally, industrial and energy analyst at Third Bridge.

Why are oil prices so high 2023? ›

IEA: global oil demand will hit a record high in 2023.

The reason for that initial weekly loss came down to overall global economic growth pessimism and expectations that the U.S. Federal Reserve will continue raising interest rates, making the dollar more expensive and sapping demand for dollar-priced crude.

Which president broke up Standard Oil? ›

President Roosevelt publicly states an attack on Standard Oil and law-defying rich citizens. US Supreme Court dissolves Standard Oil trusts, company has six months to comply.

Who owns most of US oil? ›

In 2021, about 71% of total U.S. crude oil production came from five states.
  • The top five crude oil-producing states and their percentage shares of total U.S. crude oil production in 2021 were:
  • Texas42.4%
  • New Mexico11.1%
  • North Dakota9.9%
  • Alaska3.9%
  • Colorado3.7%
Sep 16, 2022

Who holds 80% of the world's oil? ›

Industry leader BP plc estimates that there are 1.73 trillion barrels of oil reserves globally. Approximately 80% of the world's oil reserves are in the Organization of the Petroleum Exporting Countries (OPEC).

Can the US produce enough oil for itself? ›

You see, the U.S. does produce enough oil to meet its own needs, but it is the wrong type of oil. Crude is graded according to two main metrics, weight and sweetness. The weight of oil defines how easy it is to refine, or break down into its usable component parts, such as gasoline, jet fuel and diesel.

Why aren t oil companies pumping more oil in us? ›

According to Bloomberg, “U.S. oil companies generally have been reluctant to pump more, preferring to steer cash flows back to investors instead of spending it on new drilling that could flood the world with cheap crude.”

How many years of oil is left in the US? ›

That equates to somewhere in the region of 1.65 trillion barrels of proven oil reserves. Other sources up this estimate a bit, but most agree we have around 50 years left, give or take. For reference, a barrel of crude oil is about 42 gallons or about 159 liters.

Why aren t gas companies drilling? ›

As to why they weren't drilling more, oil executives blamed Wall Street. Nearly 60% cited "investor pressure to maintain capital discipline" as the primary reason oil companies weren't drilling more despite skyrocketing prices, according to the Dallas Fed survey.

What country has the most oil? ›

Venezuela has the largest amount of oil reserves in the world with more than 300 billion barrels in reserve. Saudi Arabia has the second-largest amount of oil reserves in the world with 297.5 billion barrels.

Who is the largest producer of oil in the world? ›

The United States is by far the world's biggest producer of oil, having produced around 16.6 million barrels of oil on average per day in 2021. Saudi Arabia and Russia follow head to head in second and third place, having produced around 11 and 10.9 million barrels of oil per day, respectively.

Will oil prices go down in 2023? ›

We expect the Brent price will average $83/b in 2023 and $78/b in 2024, down from $101/b in 2022. The West Texas Intermediate (WTI) price (the U.S. benchmark price) is forecast to generally follow a similar path, averaging $77/b in 2023 and $72/b 2024.

What will happen if oil prices keep going up? ›

High oil prices can drive job creation and investment as it becomes economically viable for oil companies to exploit higher-cost shale oil deposits. However, high oil prices also hit businesses and consumers with higher transportation and manufacturing costs.

What happens if oil prices keep rising? ›

Crude oil is a major economic input, so a rise in oil prices contributes to inflation, which measures the overall rate of price increases across the economy. Inflation as measured by the annual gain in the U.S. Consumer Price Index (CPI) set a 40-year high in March 2022 amid COVID-19 supply disruptions.

Who is controlling oil prices? ›

OPEC produces about 40% of the world's crude oil and its members' exports make up around 60% of global petroleum trade. The group aims to regulate global oil prices by coordinating on reductions or increases in production.

Who has control over the oil prices? ›

The Organization of the Petroleum Exporting Countries (OPEC) can have a significant influence on oil prices by setting production targets for its members. OPEC includes countries with some of the world's largest oil reserves.

What are the highest oil prices ever? ›

Historically, Crude oil reached an all time high of 147.27 in July of 2008. Crude oil - data, forecasts, historical chart - was last updated on May of 2023.

How many barrels of oil does the US use a day? ›

In 2022, the United States consumed an average of about 20.28 million barrels of petroleum per day, or a total of about 7.4 billion barrels of petroleum. Learn more: How much of the crude oil produced in the United States is consumed in the United States?

What is the average price per oil? ›

Average Crude Oil Spot Price is at a current level of 76.47, down from 80.25 last month and down from 112.40 one year ago. This is a change of -4.71% from last month and -31.96% from one year ago.

Why are the prices of oil going up? ›

Several of the world's biggest oil producers say they are cutting production, and that means oil prices are higher. It's probably not ideal for gas prices, inflation, and consumers, but it's also not the worst. That is the TL;DR of what is happening on oil right now.

What factors might have caused this change in oil prices? ›

  • OPEC Influences Prices.
  • Supply and Demand Impact.
  • Natural Disasters, Politics Weigh.
  • Political Instability.
  • Production Costs, Storage Impact.
  • Interest Rate Impact.

What is the biggest issue related to oil? ›

Industry Controversies
  • Drilling and pipelines near national parks.
  • Environmental impact, such as water, natural habitats, and air quality.
  • Financial power of integrated oil companies.
  • Impact on climate change.
  • Consolidated power of oil companies.
  • Oil spills and leaks.
  • Overuse and over-reliance on fossil fuels.
Feb 28, 2023

Why are oil prices dropping 2023? ›

Oil futures gave up early gains Friday to end lower, booking the biggest weekly drop of 2023 as worries over the U.S. and European banking sector stoke recession fears.

What will the price of oil be in 2023? ›

Forecast overview
Notable Forecast Changes20232024
Brent spot average (current forecast) (dollars per barrel)$85.01$81.21
Previous forecast$82.95$77.57
Percentage change2.5%4.7%
OPEC crude oil production (current forecast) (million barrels per day)33.734.6
6 more rows

In which country oil is most expensive? ›

Hong Kong is the most expensive place on Earth to fill up your car. Prices there are $4.32 a litre, substantially more than double the international average.

How many years of oil are left in the world? ›

That equates to somewhere in the region of 1.65 trillion barrels of proven oil reserves. Other sources up this estimate a bit, but most agree we have around 50 years left, give or take. For reference, a barrel of crude oil is about 42 gallons or about 159 liters.

Why are gas prices going up 2023? ›

Here's what it means. The weather is heating up, and so are gas prices. The national average for a gallon of regular gasoline rose eight cents since last week to $3.66 due to the rise in oil prices, nonprofit federation of motor clubs AAA said on Thursday.

Who sets the price of gas? ›

Gasoline prices are determined largely by the laws of supply and demand. Gasoline prices cover the cost of acquiring and refining crude oil as well as distributing and marketing the gasoline, in addition to state and federal taxes. Gas prices also respond to geopolitical events that impact the oil market.

What will happen if gas prices keep going up? ›

Rising gas prices may force some businesses to re-evaluate their hiring plans, holding off because they are uncertain about the economy's health. Less discretionary spending results in decreased sales, both of which can influence a company's ability to hire.

What is the current price of oil? ›

Crude Oil & Natural Gas
IndexUnitsPrice
CL1:COM WTI Crude Oil (Nymex)USD/bbl.70.24
CO1:COM Brent Crude (ICE)USD/bbl.73.94
CP1:COM Crude Oil (Tokyo)JPY/kl63,160.00
NG1:COM Natural Gas (Nymex)USD/MMBtu2.22

Why is the oil industry so corrupt? ›

Extracting and producing oil, natural gas, and minerals and metals requires large investments and specialised knowledge. Poor yet resource-rich countries often lack both. This increases the risk of corruption.

Why are we not drilling for oil? ›

As to why they weren't drilling more, oil executives blamed Wall Street. Nearly 60% cited "investor pressure to maintain capital discipline" as the primary reason oil companies weren't drilling more despite skyrocketing prices, according to the Dallas Fed survey.

Why not produce more us oil? ›

The reason that U.S. oil companies haven't increased production is simple: They decided to use their billions in profits to pay dividends to their CEOs and wealthy shareholders and simply haven't chosen to invest in new oil production.

Top Articles
Latest Posts
Article information

Author: Neely Ledner

Last Updated:

Views: 6714

Rating: 4.1 / 5 (42 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Neely Ledner

Birthday: 1998-06-09

Address: 443 Barrows Terrace, New Jodyberg, CO 57462-5329

Phone: +2433516856029

Job: Central Legal Facilitator

Hobby: Backpacking, Jogging, Magic, Driving, Macrame, Embroidery, Foraging

Introduction: My name is Neely Ledner, I am a bright, determined, beautiful, adventurous, adventurous, spotless, calm person who loves writing and wants to share my knowledge and understanding with you.