JODI Oil

Exercise JODI.1

  • Open the file “JODI_Oil_Exercises.xls”.
  • Please use the information below to fill in the Maxi-JODI table.

In October 2012 your country:

  • produced 2248 kilo tonnes (kt) of crude oil;
  • imported 450 kt of crude oil;
  • had closing national territory stocks of crude oil at 1260kt
  • had opening national territory stocks of crude oil at 1227kt

Please note that in the monthly statistics:

  • the crude oil refinery intake was equal to 2650
  • the inputs of biofuels that are produced from non-oil sources (renewables) was at 26kt;
  • Now look at the signs on the left hand side of the table.

+ / Production
+ / From Other sources
+ / Imports
- / Exports
+ / Products Transferred /Backflows
- / Direct Use
- / Stock Change
- / Statistical Difference
= / Refinery Intake
Closing stocks

Please note that contrary to what you might see from this formula, the Refinery Intake row is not calculated, it is an observed value.

The statistical difference represents the difference between the calculated refinery intake and the observed one. The calculated crude oil refinery intake formula:

Production + Imports – Exports – Direct Use – Stock Change

  • Look at the formula in the Statistical Difference row
  • Look at the Automatic Checks below the table:

“Total not equal to the sum of elements” – you have to fill in the column “Total (1)+(2)+(3)”

Your refinery intake observed of “Other” is 0, which prompts the check “Statistical Difference above 10% of Refinery Intake, please investigate”

Exercise JODI.2

  • Please put the following information to the Maxi-JODI table.

In October 2012:

  • The Refinery Gross Output by product was as follows
  • LPG: 199kt
  • Naphtha: 356kt
  • Gasoline: 576kt
  • Kerosene (Type Jet Fuel): 391kt
  • Gas / Diesel Oil: 524kt
  • Fuel oil: 633kt
  • Refinery Gas: 5kt
  • Ethane: 4kt

Keep in mind that Refinery Gas and Ethaneare a part of Other Products in Maxi-JODI: Check the definition of “Other Products” in the sheet “Definitions”.

  • Your countryimported 100kt of Other Kerosene.
  • You exported 91kt ofJet Kerosene.

Keep in mind: The Jet Kerosene is included in Total Kerosene, therefore it should not be greater than the Total Kerosene.

  • Fill in the observed Demand of the following products:
  • LPG: 200kt
  • Gasoline: 576kt
  • Naphtha: 350kt
  • Fuel oil: 633kt
  • Total Kerosene: 400kt
  • Kerosene (Type Jet Fuel): 300kt
  • Gas / Diesel Oil: 524kt
  • Other Products: 9kt
  • Fill in the columns “Total” on both sides.

Exercise JODI.3

  • Report the following information in the table:
  • 100kt of NGL was produced and used directly (i.e. not in the refinery, but in a gas plant) to produce LPG.

Keep in mind

This operation will have to be reported on both sides.

  • Start with NGL (production and direct use)
  • Then report the flow to the secondary products:
  • Hint: check the definition of “Other Products” and the flow “Receipts”
  • You need to show how the NGL was reclassified into LPG: use the “Interproduct Transfer” row.
  • Correct the columns “Total” on both sides.
  • Now look at the calculation of Refinery Losses below the table: (highlight the cell D31).

The automatic check shows:

"Reported figures imply a refinery gain. Losses should not be negative"

Try to explain why it is so.

1