Calculate sales prices from purchase prices for single services in DaVinci
Content
1. Introduction
2. Purchase prices in DaVinci
3. Calculation of the sales prices
3.1. Sales price currency
3.2. Rounding
3.3. Commission
3.4. Margin
3.5. Additional calculation parameter
3.6. Manual adjustment
3.7. Generation of the sales price chart
| Anker |
|---|
| _Toc224622722 |
|---|
| _Toc224622722 |
|---|
|
Introduction
This documentation describes the functionality of sales price calculation out of purchase prices for single services.
| Anker |
|---|
| _Toc224622723 |
|---|
| _Toc224622723 |
|---|
|
Purchase prices
For the documentation of the functionality of sales price calculation from purchase prices the following booking code is used:
The purchase price table is "MLEANGAGA". On purchase side the hotel has six different room prices and one additional price for full board:
Example for purchase price of one room ("Superior Bungalow Doppel"):
In season "1" the "Superior Bungalow" costs 198, 00 USD per night. Additionally the tour operator purchases the night/child for 49,00 USD.
With a right mouse-click on the highest price chart the user gets a context menu.
Selecting menu item "Calculation" the calculation of the sales prices on base of the purchase price chart is started.
DaVinci opens a chart display (similar to Excel-spread-sheet) where all basic purchase prices (rows displayed in black colour) and all reductions and special offers (rows displayed in blue colour) are listed.
IMPORTANT: In current version of DaVinci the seasons stored on purchase side are automatically taken for the calculation of the sales prices. During the calculation process it is not possible to assign a different season structure for the sales chart.
Reductions/Special offersBasic price 
| Anker |
|---|
| _Toc224622724 |
|---|
| _Toc224622724 |
|---|
|
Calculation of the sales prices
| Anker |
|---|
| _Toc224622725 |
|---|
| _Toc224622725 |
|---|
|
Sales price currency
To calculate the sales prices it is required to set up the currency into which the sales price should be calculated.
In this example the currency "EUR" is selected for the sales prices. DaVinci automatically loads the exchange rate from purchase to sales currency into the calculation spread sheet. The sales price (column "amount to final") is updated accordingly:
The exchange rate for Euro is loaded according to the exchange rate settings given in the DaVinci currency chart.
| Anker |
|---|
| _Toc224622726 |
|---|
| _Toc224622726 |
|---|
|
Rounding
The user has the possibility to define the rounding rule that should be used for the calculation of the sales prices.
In this example the rounding rule defined is "Ending up", the rounding aim is defined to be"1,00". This means that all sales prices calculated according to the definitions are automatically rounded to a "full Euro" amount (see column "Amount to final")
DaVinci offers different types of rounding rules:
- Ending-up
- Ending-down
- Ending
- No rounding
| Anker |
|---|
| _Toc224622727 |
|---|
| _Toc224622727 |
|---|
|
Commission
The commission given to the retail agent can be defined as calculation parameter (Commission %).
In the example it is set as 10 %. The column "Comm. %" is filled accordingly and the sales price is automatically updated:
| Anker |
|---|
| _Toc224622728 |
|---|
| _Toc224622728 |
|---|
|
Margin
The margin can be defined as calculation parameter:
DaVinci offers different types of Margin paramter:
- Margin%
- Margin Absolute
In the example it is set as 23 %. The column "Margin%" is filled accordingly and the sales price is automatically updated:
| Anker |
|---|
| _Toc224622729 |
|---|
| _Toc224622729 |
|---|
|
Additional calculation parameter
Additional calculation amount can be defined as calculation parameter:
In the example it is set as "0". The column "Addition" is filled accordingly and the sales price is automatically updated:
| Anker |
|---|
| _Toc224622730 |
|---|
| _Toc224622730 |
|---|
|
Manual adjustment
Before storing the price calculation spread sheet the user is able to manually adjust any field in following rows in order to create a "nice price" or the reflect different conditions of seasons:
- Commission
- Margin
- Addition
- Amount to final
| Anker |
|---|
| _Toc224622731 |
|---|
| _Toc224622731 |
|---|
|
Generation of the sales price chart
After clicking on the "Save" Button, the sales price will be calculated and stored.
In the list DaVinci shows the result of the conversion process.
A new price table in the tab "sales" of the price administration console of DaVinci is displayed.
Example for sales price of one room ("Superior Bungalow Doppel") calculated out of purchase price:
In season "1" the "Superior Bungalow" costs 173,00 EUR per night. Additionally the tour operator charges the night/child with 43 EUR.
