Fuel Inventory Costing and History

The WAM (weighted average margin) is calculated for the day by taking opening inventory at yesterday’s WAM, adding all purchases at actual cost, recalculating the WAM for today and then deducting sales at today’s WAM.

 

Right clicking in the cost column on the light bulb for a specific fuel grade will bring up its inventory WAM and daily history:

 

 

 

This will show when this fuel type was bought and sold and will also give you the weighted cost calculation for that fuel type.

 

It is very important to understand to get accurate WAM for any fuel, that the over/short and ALL fuel invoices are entered into S2k. Then S2k will automatically do the rest for you. Here is a key to the above and how each day’s calculations are done:

 

Cost	The last or average cost (WAM) that is being used by S2k
Quantity	The fuel gallons that are used for the calculation, either sales or purchases or over/short numbers
# In Stock	The calculated running balance
Weighted Cost	The running WAM
Entity Ref.	type of transaction, Sales (for that day, if a blended tank is used this might have 2 entries per day), BP = Fuel vendor, Over/Short is the S2k calculated number to balance stick readings.
Other Ref	Is the date or invoice reference

**Any line that has a bold line is a fuel invoice and can be double clicked to get the details of the invoice and edit if necessary.