Fuel Manager - Blending Stock

Quick Intro

Fuel Manager allows you to track and maintain a running average of the cost of purchase of the fuel currently in the tank(s). This is done by blending the stock each time you receive a delivery. This cost value is then used in the final price calculation function, to help you determine an appropriate retail price.

The only time a stock blend should be completed is after a delivery is entered, and it should be done immediately after that delivery is recorded.

Where To Find It

Open the Fuel Manager from your Nav Bar (this will be in the Marina Administration section). Then, navigate to the Stock Management tab at the top, and within that, the Blend Stock tab on the left-hand side.

Example:

      

Blending Stock

Blending Stock should be done immediately after a delivery is recorded, and it is best that all other stock records have been brought up-to-date before doing this - dip readings, marina usage, etc.

You cannot undo a blend, once it has been committed.

1. Navigate to the Blend Stock screen.
   
2. Check and set the selected fuel type as appropriate.
   
3. The left-hand panel will show the most recent delivery. You should check that this is correct and matches what you would expect to see.
   
4. The right-hand panel will display the stock level, total stock value, and effective cost per litre, calculated for both Before and After you received the most recent delivery.
   
1. You can manually set the cost per litre if you need, using the orange pen button, but generally this should not be required.
   
5. Once you're happy, click the yellow Save button to commit the blend.
   
6. You will then see the new blend entered into the History grid at the bottom.

Example Blend Calculation

Here is an example of how the blend calculation works.

Let's say, from your previous deliveries, you currently have 100 litres of diesel, with an effective cost per litre of £1.00. This gives you £100.00 of total diesel stock.

Now, if you receive a delivery of another 100 litres of diesel, and you paid £1.50 per litre for it, for a total of £150 cost.

Blending these, you will get:

1. 100l + 100l = 200 litres total stock
   
2. £100 + £150 = £250 total stock cost
   
3. £250 / 200l = £1.25 effective cost per litre

So, when you calculate your next update to your retail fuel prices, your starting at-cost price will be £1.25 per litre.

• Related Articles

• Fuel Manager - Feature Overview

  Quick Intro Fuel Manager is a comprehensive stock and price management module aimed at helping you track your stock, manage your pricing, and optimise your margins on fuel sales. Features Stock management – Log dip readings, deliveries, adjustments, ...

• Havenstar Reference Guide v3.1 - Fuel Manager

  Introduction Here, we have attached a copy of our Fuel Manager manual. To view the manual, select the tab 'Attachment', and you will then see the link to the file. The attachment takes you to the full version of the manual so you can print a copy as ...

• Fuel Manager - Correcting Mistakes

  Introduction If you have made a mistake in Fuel Manager, the corrections should be made as soon as possible. Below is a list of possible scenarios that you may encounter, and how to fix. Marina Usage These cannot be edited once posted, but there are ...

• Fuel Manager - Recording Deliveries

  Quick Intro The Fuel Manager Goods Received screen lets you log and track deliveries of fuel that you receive to the marina. You can capture fuel cost, litreage, delivery time, and record the specific tank(s) that received it. This data is then used ...

• Fuel Manager - Cost of Supply

  Quick Intro The cost of supply represents a set figure which is factored into the price calculation. It represents the ongoing cost of infrastructure and personnel costs to operate fuel storage and delivery systems. Fuel Manager lets you update and ...