This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Previous revision Last revision Both sides next revision | ||
leon:fuel-prices [2020/04/25 13:50] |
leon:fuel-prices [2024/01/17 06:59] rafal [COUNTRY TAX RATES FILE] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Fuel Prices ====== | ||
+ | |||
+ | <box tutorial> | ||
+ | |||
+ | [{{ : | ||
+ | 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. | ||
+ | |||
+ | You can also **mark fuel supplier as favourite**. This will **highlight the supplier in the FUEL tab** in the OPS section. | ||
+ | |||
+ | < | ||
+ | |||
+ | ===== Uploading fuel prices files ===== | ||
+ | |||
+ | [{{ : | ||
+ | |||
+ | Go to menu' OPS > Fuel prices' | ||
+ | |||
+ | To view uploaded prices, you need to enter airport code in the 'Fuel prices at selected airport' | ||
+ | |||
+ | 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 | ||
+ | |||
+ | It is possible to sort the prices at selected airport alphabetically by Card or by Price. | ||
+ | |||
+ | |||
+ | 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. | ||
+ | |||
+ | < | ||
+ | |||
+ | < | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ===== Reference fuel price ===== | ||
+ | [{{ : | ||
+ | |||
+ | 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 ===== | ||
+ | |||
+ | |||
+ | |||
+ | To add **custom fuel price** click **+** icon next to an airport code and select fuel card, select or fill in fuel supplier, add 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' | ||
+ | |||
+ | {{: | ||
+ | |||
+ | < | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ===== COUNTRY TAX RATES FILE ===== | ||
+ | |||
+ | |||
+ | |||
+ | When uploading fuel prices files to Leon, not all of them consist of both: ' | ||
+ | |||
+ | A file itself needs to be created as per the format below - only 2 columns are needed: **Country** and **Total Taxes**. | ||
+ | |||
+ | A column ' | ||
+ | |||
+ | 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' | ||
+ | [{{ : | ||
+ | {{: | ||
+ | |||
+ | Once the file is ready, go to **OPS > Fuel Prices** panel and use an uploader **Upload countries tax rates**. | ||
+ | |||
+ | {{: | ||
+ | |||
+ | Uploaded fuel taxes will show on the main 'Fuel Prices' | ||
+ | |||
+ | |||
+ | In a panel OPS, tab FUEL, if you switch between ' | ||
+ | |||
+ | {{: | ||
+ | |||
+ | < | ||
+ | |||
+ | ---------------------- | ||
+ | ===== Mineral Oil Tax ===== | ||
+ | |||
+ | Together with Country Tax rates, Leon now also allows uploading **Mineral Oil Tax** rates. | ||
+ | [{{ : | ||
+ | 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' | ||
+ | |||
+ | 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 format is presented below: | ||
+ | |||
+ | * **Old file format that includes the 'Total Tax' column** | ||
+ | |||
+ | {{: | ||
+ | |||
+ | * **New file format that includes tax rates based on the type of operations** | ||
+ | |||
+ | {{: | ||
+ | |||
+ | [{{ : | ||
+ | After uploading the file, the fuel prices in the tab ' | ||
+ | |||
+ | * Value from the **Total Tax** column is prioritized. If the 'Total Tax' column contains the rate, values from the ' | ||
+ | * If the 'Total Tax' column is 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. | ||
+ | |||
+ | |||
+ | --------------------- | ||