Exercise JODI Oil.1

Open the file “JODI_Oil_Exercises.xls”.

Please use the information below to fill in the Maxi-JODI table.

  • In February 2015 the following was observed in your country:
  • 2248 kilo tonnes (kt) of crude oil production;
  • 450kt of crude oil imports;
  • closing stocks of crude oil on national territory stood at 1260kt
  • opening stocks of crude on national territory oil stood at 1227kt

Please note that in the monthly statistics:

  • the crude oil refinery intake was equal to 2650kt
  • the inputs of biofuels from non-conventional oil sources (renewables) amounted to 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 the impression you might get from this formula, the Refinery Intake row is not calculated value, instead it is an observed value.

The statistical difference represents the difference between the calculated refinery intake and the observed refinery intake. The formula for the calculatedrefinery intake and the statistical difference look as follows:

Look at the Automatic Checks below the table:

  • “Total not equal to the sum of elements”:Please fill in the column “Total (1)+(2)+(3)”
  • Another check says: “Statistical Difference above 10% of Refinery Intake, please investigate”.
  • Can you identify the reason for the statistical difference?
  • How would you try to identify which flowsare missing? (Hint: Who would you try to contact?)

Exercise JODI Oil.2

Please fill in the following information in the Maxi-JODI table.

  • In February 2015 the following figures for Refinery Gross Output by product wereobserved in your country:
  • LPG: 199kt
  • Naphtha: 356kt
  • Gasoline: 576kt
  • Kerosene (Type Jet Fuel): 391kt
  • Gas/Diesel Oil: 524kt
  • Fuel oil: 633kt
  • Refinery Gas: 5kt
  • Ethane: 4kt

Please, keep in mind that refinery Gas and ethaneare part of “Other Products” in Maxi-JODI: Check the definition of “Other Products” in the sheet called “Definitions”.

  • In February 2015 the following trade figures wereobserved in your country:
  • Importof 100kt of other kerosene
  • Export of91kt ofjetkerosene.

Please, keep in mind thatjet kerosene is included in total kerosene.Therefore,the amounts reported under jet kerosene should not be larger than the amounts of total kerosene.

  • Please, fill in theamounts of observed demand for the following products:
  • LPG: 200kt
  • Naphtha: 350kt
  • Gasoline: 576kt
  • Total Kerosene: 400kt
  • Kerosene (Type Jet Fuel): 300kt
  • Gas/Diesel Oil: 524kt
  • Fuel oil: 633kt
  • Other Products: 9kt
  • Please fill in the correct amounts in the column “Total Products”.

Exercise JODI Oil.3

Please 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.

Please, keep in mind that this processhas to be reported on both sides of the table since it includes primary (NGL) as well as secondary products (LPG).

  • Start with filling in the amounts of NGL (production and direct use).
  • Continue with the reportingof the secondary products.

Hint: Check the definitions of the flows “Receipts”and “Interproduct Transfer” in the “Definitions” tab.

  • Please, correctthe columns “Total” on both sides of the table.
  • Now look at the calculation of Refinery Losses below the table: (click on the cell “D31” to see the formula).
  • The automatic check shows the following message:"Reported figures imply a refinery gain. Losses should not be negative".
  • In your opinion, what might be the reason for negative refinery losses?

1