Bunker Calculation, Formula With Example And Sample Excel Sheet



        Bunker calculation having very much significance in bunkering, at times wrong calculation can lead to shortage of bunker, oil spill etc. Here you can see  a few simple and convenient ways to calculate the bunker Quantity. You can also download the excel sheet for bunker calculation.
Bunker quantity is always said in Metric Ton (MT) because volume of oil changes according to the temperature , so it is always preferable to take bunker in weight which does not get changed with the change in temperature. But in actual scenario it's impossible to weigh the fuel oil physically . so we convert weight in to volume (m3).

To convert from MT to M3 we have to use the following basic formula

                   Volume(M3) = mass ( MT)/ density
   
     But here the density is , "corrected density" ie, density of oil at the temperature of barge or terminal is pumping

                  Corrected Density= D(1-0.000645(T-15))
 
D= density at 15°C, this you will get from bunker advice form
T= Temperature of the fuel oil at which the barge or terminal is pumping.

Find the corrected density put into the basic formula ie,

             Volume(M3) = mass ( MT)/ corrected density

From this you will get the total volume of bunker. 

Go to your sounding table go to the page of your particular tank which you are planing to take bunker, find out the volume by considering the trim.  There you will get the final ullage or sounding of your tank.


Must Read> Bunker Delivery Note Details

Bunker calculation example:

Consider 285MT of HFO is planning to take on No.1 HFO port tank having capacity of 400m3 at trim of 0.50m.

Information you will get from bunker advice form,
Density at 15°C =0.9909
Temperature of fuel oil at the time of pumping. =50 Deg. C

Corrected density =D(1-0.000645(t-15))
                          =0.9909 ( 1-000645(50-15))

                          = 0.9682
Volume (M3)  = Mass (MT)/ corrected density
                     = 285/0.9682

                      = 294.35M3

Go to your sounding table for No.1 HFO port tank find 294.35M3   there you will get the final ullage or sounding.  Below you can see the diagram





Bunker Calculation Excel Sheet Download Here 



If Itz Really Helpful Please Like or G+

2 comments:


>> Your Comments are always appreciated...
>> Discussion is an exchange of knowledge It Make the Mariner Perfect.... Please Discuss below...