Third World Ant

The thoughts of a little ant on a big planet.

Thursday, June 14, 2007

Fuel for thought

If you’re at all like me (and yes, in this instance you are), you’ll moan about the fact that the petrol price keeps rising. Either the price of Brent crude’s increasing, or the Dollar’s gaining on the Rand, they always tell you. But even when the Dollar weakens against the Rand the price still rises.

Now, for an un-economist like me, this confusion is downright frustrating and smacks of excuses and refineries lining their oily pockets with even more absurd profits. So, I’ve done a little check on historical prices (using data from here and here) to see whether there’s been one mother of all consumer rights cock-ups, and, the answer is that I’m undecided. (The real truth is that I had to manually redraw the graphs below, so didn’t have the actual figures to convert the y-axes to equivalent scales, where a fair comparison could be made, so all my conclusions are based on visual estimation of the figures rather than on the actual figures themselves).

Warning: I really must warn you that I have as much Economics training as a pistachio, so feel free to ignore/correct me, peeps.

First, I present for your attention Graph A: the Dollar/Rand exchange rate plotted against Brent crude price per barrel. Because I don’t have data going further back, I can’t tell you whether there is any reasonable correlation between the two statistics – 9/11 was an anomaly which will have caused substantial disruptions to either or both figures (for example, demand for fuel fell as people lost their appetite for travel by aeroplane). At face value though, one might assume that there was no significant relationship between the two.




Next, I present Graph B: Brent crude price per barrel versus petrol price. Now this graph is more the stuff of statisticians’ wet dreams, because one can draw some conclusions off this: our petrol price is quite strongly correlated with the cost of Brent crude, which while being marginally inconvenient given the uncomfortable inching up of the barrel price on a daily basis, is also reassuring in that it sort of says that the stuff we fill our gorgeous Mini Coopers with is actually mostly fuel (without too many diluting cheaper substitutes like refinery fat-cat urine). I’ve even added pretty green circles to highlight the lag in changes in Brent crude price affecting the local petrol price.



But wait, there’s more… I’ll omit the third permutation of the above data (local petrol price vs Rand/Dollar exchange rate) because it’s much like the first graph (what with the close pattern between local petrol price and Brent crude price), and skip straight to the combined graph, where all three variables are plotted on one graph:




Now again, I warn you that the scales used on the y-axes are not comparable, so visual comparison is actually not going to be that accurate, but I’ve tried to estimate the actual values for more accurate comparison than just looking at the differences from the pictures. The first pretty green circle shows an increase in the Dollar’s value against the Rand of around 70%, with the arrow indicating a corresponding 40ish% decrease in the Brent crude price over the same time period. What happens to the petrol price over this time? It remains constant on average. i.e. the smaller change in the Brent crude price appears to buffer the larger change in the exchange rate. Now look at the second green circle: this depicts a 35% drop in the Dollar: Rand value over the period, while the arrow depicts the 150% increase in Brent crude price, and the corresponding 80% increase in the local petrol price.

If the impact of the percentage changes were like for like, then the first green circle scenario should result in a (70%-40%) = 30% increase in the petrol price (as opposed to it remaining roughly constant), while the second should result in a (150%-35%) = 115% increase in petrol price rather than the actual 80% experienced.

So what does this all mean? I can think of only four options:

1) Government is lying, they’re using the exchange rate as an excuse to hike up petrol prices to fund their (social) parties (I’m thinking Zoolander parties where they spray each other with “expensive” petrol for shits, giggles and cheap thrills)

2) The lag in the exchange rate’s effect on the petrol price is out of sync with the lag of Brent crude’s effect (i.e. the major impact on the petrol price is not seen until later than Brent’s price’s impact, so we’re comparing the wrong time periods for each graph against each other)

3) Government chooses to subsidise partly the effect of the exchange rate on the petrol price, but doesn’t feel the need to do so for the effect of Brent crude’s change in price

4) I’ve got something grossly incorrect here and am now spreading a groundless conspiracy theory, in which case I humbly apologise, Big Brothe…


10 Comments:

At 2:43 pm, Anonymous Anonymous said...

I see what you're trying to do, but your method of testing is a little bit off. No offense. I have to do stuff like this at work and for study, and this is far too simplistic a comparison. You would need statistical testing to get the true picture, and even then there are too many other variables to get a conclusive answer.

Points for thinking it through, though.

 
At 2:56 pm, Blogger Third World Ant said...

Thanks anon, no offense taken. This is indeed highly simplistic, and is lacking in insufficient years' data for any real comparison to be made.

If you read my comment here, I wonder if you could please list some of the other variables that will affect this relationship? (excluding unnatural occurrences such as acts of terrorism). Thanks dude/dudette...

 
At 6:03 pm, Anonymous Anonymous said...

Other variables could include taxes. Locally, you would need to look at local demand, which is difficult, but would include things like number of car sales (more cars on the road -> greater demand for petrol -> increase in local price). You can probably ignore things like production (more machines working equals more fuel) and airline sales (jet fuel) if your data is limited to petrol prices.

The world price of crude and exchange rate would be determinants of local prices, but you also need to consider local determinants like the one listed above.

You're not WRONG, it's just that graphs sometimes skew the picture. Look at the relationships between your variables (I suggest correlation and elasticity testing, which you can do quite easily in Excel). There should also be a ton of stuff on the 'net, if you want to do some research.

 
At 7:06 pm, Anonymous Anonymous said...

Ant,

I love your graphs - could you add more red though (I particularly like that colour on graphs).

As far as the petrol thing goes, I have to be honest...it doesn't really disturb me. Petrol will always become more and more expensive as time goes by. Imagine, one day you'll look back at what you're paying now and say *sigh* "those were the days". Hard to imagine I know - but whenever my gran told me how they used to drive to Pietersburg on a hand full on coins and still have change I had to remind her that it will NEVER be that cheap again.

They should alter that saying about death and taxes and add petrol price hikes to it.

 
At 10:05 am, Blogger Third World Ant said...

Anon - I've just learnt two things:

1 - local petrol price is regulated, so demand-supply analysis is meaningless

2 - petrol equalisation fund - because the price is regulated, sometimes excess money is made (for instance if the dollar weakens against the rand and new fuel is sold to consumers at the same price as before) which is used to compensate for exorbitant increases in price (e.g. when the rand's value halved over 6 months relative to the dollar). The point of this activity is to smoothe out price dips/hikes as best as possible.

So basically, chuck my entire analysis out the window :)

Louisa - yes ma'am, more red! Have you noticed how much of your monthly spend you actually spend on petrol? The answer (for me) is something like 8% (of total spend, not monthly salary). Check the post 'Graph It' in the following archive:

http://thirdworldant.blogspot.com/2007_02_01_archive.html

 
At 2:38 pm, Blogger It is the question said...

Howzit TWA

Sorry for the delay.

Point 2 is dead on the money. The equalisation fund seeks to smooth petrol price volatility, so any correlation analysis of the Brent oil price and our petrol price would be better if the 60 day moving average was used.

While your analysis is graphical, an equally simple regression analysis of the petrol price with the Rand Brent crude price (the combined figure is a better one to use) should show a fairly high coefficient for the Brent parameter - implying a high degree of correlation.

Further, the fit of the regression equation should improve if a lag between the petrol price and Brent crude price was built in - due to the delay in changing the regulated price.

Taxes and other items will affect the fit of the regrssion equation, but these change fairly seldom, so it is likely to be slight.

I'd expect about 90% of the moves in the local petrol price to be linked to the change in crude oil price. The remaining influence is likely to be from changes in refining and transportation costs.

That's the theory. Of course, analysis could prove me completely wrong...

 
At 2:53 pm, Blogger Third World Ant said...

IITQ - thanks dude. totally makes sense. I couldn't find a Rand Brent Crude price anywhere though, and not having the underlying numbers, I couldn't calculate it either :) Something else that might affect the price (though obviously less than the Brent crude price, obviously) are the taxes, as Anon mentioned above - contributions to Road Accident Fund, etc...

 
At 5:33 pm, Blogger It is the question said...

Hey TWA

It depends on what you're modeling.

If you are modeling the petrol price and oil price, taxes and oil price will likely show as a fixed percentage of petrol price (if petrol taxes are ad valorem -I can't remember).

A better way to model would be to model change in petrol price dependent on change in oil price (which is what I was narrating in my previous post). In this model taxes should not hold a lot of influence as they do not change much.

 
At 11:47 pm, Anonymous Anonymous said...

That's a good point about the taxes from IITQ, but the excise on fuel does go up over time. Also, the price regulation thing will limit the effect of demand on price, but there is still an effect. Seriously, someone local must have done a study on this. Surf the net young Ant, surf the net.

 
At 8:58 am, Blogger Third World Ant said...

Anon - 'young' Ant will surf away :)

 

Post a Comment

<< Home

South Africa's Top Sites