Differences

This shows you the differences between two versions of the page.

--- leon:fuel-prices [2021/02/13 14:44]
rafal [Fuel Prices]
+++ leon:fuel-prices [2023/08/09 16:51]
marek [Adding custom fuel prices]
@@ Line 3: / Line 3: @@
 <box tutorial>[[videos:getting-started:fuel-prices|Video Tutorial]]</box>
+[{{ :leon:fuel-prices:Fuel prices - fav.png?200|Fuel prices list}}]
 If you are a holder of fuel cards, such as WFS, Shell, JetEx, etc..., you can **upload** current fuel prices into Leon. All uploaded prices show in a section OPS, **tab FUEL** of the right-hand filter.
@@ Line 30: / Line 30: @@
 ----
+===== Reference fuel price =====
+[{{ :leon:schedule-fuel:reference_fuel_price.png?nolink&500|Global reference fuel price setting in OPS -> Fuel Prices}}]
+It is possible to define global reference fuel price, to have a fuel price index calculated regardless of the supplier. You can set it up in OPS -> Fuel Prices.
+The price set up in OPS -> Fuel Prices will be used to calculate the fuel price index, which will be shown in the Fuel tab on flights in OPS, regardless of the supplier.
+The index will show the difference (in percentages) between the price offered by a supplier and the reference price.
+If the index is positive (the price offered is higher than the reference) the indication is red. If the difference is negative (the price offered is lower than the reference), the indication is green.
+----
 ===== Adding custom fuel prices =====
@@ Line 42: / Line 57: @@
 <box>**If required, we can add a new fuel card or a new fuel uploader to the list of the existing ones - please contact [[support@leonsoftware.com]] in this matter.**</box>
+----
+===== COUNTRY TAX RATES FILE =====
+When uploading fuel prices files to Leon, not all of them consist of both: 'Base' (excluding taxes) and 'Total' price (including taxes). To make it possible viewing both fuel prices in panels: Fuel Prices & OPS > tab FUEL, we have made it possible uploading a file with **Country tax rates**.
+A file itself needs to be created as per the format below - only 2 columns are needed: **Country** and **Total Taxes**.
+A column 'Country' can have inserted either country name (Argentina), country code (ARG) or iso code (AR).
+A value from 'Total Taxes' column will update fuel prices for airports of a country from this file:
+  * **Total price** = 'Base price' multiplied by 'Total Taxes' value.
+  * **Base price** = 'Total price' divided by 'Total Taxes' value.
+What's important is that inside the file, the sheet's name must be 'Fuel Taxes', otherwise it will not work.
+[{{ :leon:fuel-prices:fuel prices after tax uploaded.png?200|Country tax rates from uploaded file}}]
+{{:leon:fuel-prices:fuel taxes file.png|}}
+Once the file is ready, go to **OPS > Fuel Prices** panel and use an uploader **Upload countries tax rates**.
+{{:leon:fuel-prices:fuel taxes upload.png|}}
+Uploaded fuel taxes will show on the main 'Fuel Prices' page in a column **Country tax rate** (see screenshot on the right).
+In a panel OPS, tab FUEL, if you switch between 'BASE' & 'TOTAL', Leon will show prices accordingly, as per an example below: the tax rate for Germany has been defined to '3' and Leon shows 'Total' price as 'Base' price multiplied by '3'.
+{{:leon:fuel-prices:base total fuel price.png?nolink|}}
+<box>**If the fuel file uploaded to Leon already contained both prices: 'Base' & 'Total', Leon will not update them.**</box>

Leonsoftware Wiki

User Tools

Site Tools

Differences

Page Tools