User Tools

Site Tools


leon:fuel-prices

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
leon:fuel-prices [2020/02/06 11:55]
bartek
leon:fuel-prices [2024/01/19 14:33] (current)
rafal [Mineral Oil Tax]
Line 3: Line 3:
 <box tutorial>[[videos:getting-started:fuel-prices|Video Tutorial]]</box> <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.
  
-If you are a holder of fuel cards, such as: WFS, Shell, JetEx, etc..., you can **upload** current fuel prices into LeonAll uploaded prices show in a section OPS, **tab FUEL** of the right-hand filter.+You can also **mark fuel supplier as favourite**. This will **highlight the supplier in the FUEL tab** in the OPS section.
  
 <box>**Fuel files which have 2 prices included in the file: Base price & Total price -  will show now Total price. This applies to companies: AEG, AirBP Sterling, CS Fuel, EVO, Euro Jet, Flightworx, Fuel & More and Jetex.**</box> <box>**Fuel files which have 2 prices included in the file: Base price & Total price -  will show now Total price. This applies to companies: AEG, AirBP Sterling, CS Fuel, EVO, Euro Jet, Flightworx, Fuel & More and Jetex.**</box>
Line 10: Line 12:
 ===== Uploading fuel prices files ===== ===== Uploading fuel prices files =====
  
-[{{ :leon:fuel-prices:fuel prices - sorting.png?200|Fuel prices uploaded values from fuel files obtained from suppliers}}]+[{{ :leon:schedule-fuel:fuel prices page.png?200|Fuel prices from the uploaded fuel files obtained from fuel suppliers}}]
  
-Go to menu OPS > Fuel prices page and upload particular files in formats .xls, .xlsx or .csv. Once this is done you need to save it (bottom of the screen). Right below the card-name you will notice information: **Last updated**:DD-MM-YYYY with icon 'delete' next to it. The system updates the prices after 24 h from the last download.+Go to menuOPS > Fuel pricespage and upload particular files in formats .xls, .xlsx or .csv. Once this is done **you need to save it** (bottom of the screen). Right below the card-name you will notice information: **Last updated**:DD-MM-YYYY with icon 'delete' next to it. The system updates the prices after 24 h from the last download.
  
-To get the **UvAir** prices it is necessary to insert credentials you use to log into UVair, in a section Settings > Integrations.+To view uploaded pricesyou need to enter airport code in the 'Fuel prices at selected airport' part of the page. You will see list of available fuel suppliers together with the price, minimum quantity required, currency, last updated and expiry date. By clicking {{:leon:icons:delete-iks.png?|}} you can get rid of unwanted fuel cards
  
-In case of the **UvAir**, when hovering the mouse over the fuel prices 'Notes', Leon will display the following information in the tooltip:+It is possible to select different fuel units (GAL, L or T) in columns: Base Price & Total Price - __as long as an uploaded fuel file contains 2 types of the fuel price__. If a fuel file has only 1 fuel price, Leon will show **0** in Fuel Prices page in the column price that is missing in the file
  
-  * a note that the presented price is a base price +It is possible to sort the prices at selected airport alphabetically by Card or by Price.
-  * full price information including Base price, Tax and the Total price+
  
-This tooltip will be displayed when hovering the mouse over the notes in Handling > Fuel Prices section and in OPS > FUEL tab. 
  
-To view uploaded prices, you need to enter airport code in the 'Fuel prices at selected airport' part of the pageYou will see list of available fuel suppliers together with the price, minimum quantity required, currency, last updated and expiry date. By clicking {{:leon:icons:delete-iks.png?|}} you can get rid of unwanted fuel cards+If there is more than one price for the selected airport, Leon will mark the lowest one in greenIf you want to add custom fuel price, click on the icon **Add custom fuel price** and a new pop-up window will be displayedFill in mandatory fields and custom price will appear on the list for the selected airport. That added price can be edited at any time to add missing data or to change some details.
  
-It is possible to sort the prices at selected airport alphabetically by Card or by Price.+<box>**Converting GALLON to TON the density used is 0,798102878 KG/L, so the convertion is 1T = 331 US GAL.**</box>
  
 +<box>**If, after uploading a fuel file into Leon, fuel prices don't show up or don't match the file - please check the format of the newest file with the previous one. Check if columns in the last succesfully uploaded file match with the new file - they have to be EXACTLY the same.**</box>
 +
 +----
 +
 +===== 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. 
 +
 +----
  
-If there is more than one price for the selected airport, Leon will mark the lowest one in green. If you want to add a custom fuel price, click on the icon **Add custom fuel price** and a new pop-up window will be displayed. Fill in mandatory fields and custom price will appear on the list for the selected airport. That added price can be edited at any time to add missing data or to change some details.  
  
-<box>**If, after uploading a fuel file into Leon, fuel prices don't show up or don't match the file - please check the format of the newest file with the previous one. Check if columns in the last succesfully uploaded file match with the new file - they have to be EXACTLY the same.**</box> 
 ===== Adding custom fuel prices ===== ===== Adding custom fuel prices =====
-[{{ :leon:fuel-prices:fuel prices in legs info.png?200|Adding a custom fuel prices in Legs Info page}}] 
  
-The list of fuel prices is available in Flights > Legs Info screenunder tab 'Fuel'. Uploaded fuel prices along with the custom prices will appear when clicking on the particular airport-tab. You can input the price that has been negotiated with the fuel supplier. If you want the lowest price to be displayed on your 'Trip Sheet' document, tick the box on the right+ 
 + 
 +To add **custom fuel price** click **+** icon next to an airport code and select fuel card, select or fill in fuel supplieradd fuel price that has been **negotiated** with the fuel supplier, select currency and add notes, if necessary. 
 + 
 +If you want the lowest price to be displayed on your 'Trip Sheet' document, tick the box 'Show on Trip Sheet'
 + 
 +{{:leon:schedule:custom fuel price.png?nolink|}}
  
 <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>  <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>
 +
 +----------------------
 +===== Mineral Oil Tax =====
 +
 +Together with Country Tax rates, Leon now also allows uploading **Mineral Oil Tax** rates.
 +[{{ :leon:fuel-prices:mot_-_upload_tooltip.png?300|'Mineral Tax Oil' upload}}]
 +The rates are loaded in the standard way, just like tax rates, by uploading a file in the appropriate format ine the OPS > 'Fuel prices' section.
 +
 +It is **important** that the tab within the file containing the rates is named **MOT and VAT**.
 +
 +Once the file is uploaded, the Tax, MOT, and VAT rates will appear in the **Country tax rate** column when hovering the mouse over the **?** icon.
 +
 +The correct file formats that can be uploaded are presented below:
 +
 +  * **File format that contains the 'Total Tax' information only**
 +
 +{{:leon:fuel-prices:mot_-_old_format.png?nolink|}}
 +
 +  * **New file format that includes tax rates based on the type of operations**
 +
 +{{:leon:fuel-prices:mot_-_file_format.png?nolink|}}
 +
 +[{{ :leon:fuel-prices:mot_-_fuel_tab.png?250|Base Price calculation in OPS}}]
 +After uploading the file, the fuel prices in the tab 'FUEL' in OPS are being recalculated accordingly:
 +
 +  * If the Fuel File contains the **Total price** value, then this price is prioritized and the values from the 'MOT' and 'VAT' columns are omitted
 +  * If the 'Total price' column is not included or empty:
 +   
 +    * **Total Fuel Price** = (Base + MOT) x (1 + VAT)
 +    * **Base Fuel Price** = (Total Fuel Price / (1 + VAT)) - MOT   
 +
 +The **MOT rate is fixed at USD/GAL**, therefore it is converted to the units configured for an operator or an aircraft.
 +
 +Leon also differentiates the costs of both commercial and non-commercial flights are taken into account.
 +
 +
 +---------------------
 +
leon/fuel-prices.1580990124.txt.gz · Last modified: 2020/02/06 11:55 by bartek