In this lesson you will learn how to:
- Create a new season chart
- Attach a season chart to a price chart
- Create a purchase price chart
- Create a sales price chart
- Attach a Purchase price chart to a Booking Code
- Attach a Sales price chart to a Booking Code
Introduction
Discussion
A Price Chart is where all the prices, surcharges and discounts are created. The purchase prices are created in the Purchase price chart and the Sales prices are created in the Sales price chart.
Create a Purchase Price Chart
Discussion
To complete the setup of the Blue Horizons Garden Resort we need to create and attach the purchase and sales prices. Once the purchase and sales prices have been set up a booking for this hotel can be made through the booking system.
Step-by-Step: Creating a Purchase price chart
To Create a Purchase Price Chart:
- Select Travel>Purchasing Prices. Alternatively select the icon.
- Select Production&Procurement > The Americas > Caribbean.
- Right click on the Grenada folder.
- Select Create new price chart.
The Price Chart (Purchase) screen will open.
- Enter GNDHBLUHOR/ASE/Y11
The Purchase Price Chart naming convention is as follows:
G D H B L U H O R / A S E / Y 1 1
Booking CodePOS Season & Year
Alphanumeric |
Code |
Examples |
|
1-10 |
Booking Code |
SSHHMOVPIC - Movenpick Sharm el Sheikh |
|
11 |
/ |
|
|
12-14 |
POS |
Point of sale code |
|
15 |
/ |
|
|
16 |
Season |
*Y - |
*Year |
17-19 |
Year |
11 - 2011 |
- Select stay related in the Price Calculation field.
To ensure the price chart is available in all catalogues:
- Select Price chart enable in all catalogues.
- Select the button to the right of the Season Chart field.
The Season Dates screen will be displayed:
- Select the Production&Procurement catalogue in the Catalog field.
- Select Purchase under Season chart.
- Select New on the left side.
The Season Chart screen will be displayed.
- Enter GNDHBLUHOR/ASE/Y11 in the Description field.
- Ensure Purchase is selected in the Permitted field.
|
|
|
Purchase + Sales: the price chart is valid for Sales and Purchase price charts. |
|
|
- Select OK to save the Season Chart.
The GNDHBLUHOR/ASE/Y11 Season Chart is now visible.
- Select GNDHBLUHOR/ASE/Y11
- Select New on the right side.
The GNDHBLUHOR/ASE/Y11 is now visible.
The Season Period screen will open.
The Season Period screen is used to define a season's from date and to date.
- Enter A in the Description field.
- Enter A in the Season code field.
|
|
|
The same character in the Description and Season code fields is used to identify the seasons. The coding structure has not yet been defined. |
|
|
- Enter 01.11.2012 in the Date from field.
- Enter 31.10.2013 in the till field.
- Select OK to save the period.
The Season Date is now visible on the right side of the screen.
- Select OK to save the Season Chart.
- Select the drop down box to the right of the Season Chart field.
- Double click on the GNDHBLUHOR/ASE/Y11 Season Chart.
- Select OK to save the Purchase Price Chart.
The Purchase price chart is now visible on the left side of the screen.
New price codes will now be created.
This is necessary in order to view the seasons.
- Select the + to the left of the price chart.
- Right click on Main price chart.
- Select Create New Price code.
- The Price code (Purchase) screen will be displayed.
Ensure the following are selected:
- Basis: (Calculation): Night
Basis: (Calculation):
Night: if the calculation is per night.
Once: if there is one price for the entire stay, for example a tour. - Calculation type: Participants
|
|
|
Select Participants in the Calculation type field to calculate the sales price on a per person basis. |
|
|
Price Charts always relate to a certain room type. It is necessary to define which type of room at the Blue Horizons Garden Resort hotel this Price Chart applies to. In this example a standard double room (DS20) will be selected:
- Select the drop down box in the Code combination field.
- Select No catalog assignment > Hotel > Room Types folder.
- Select the DS20 room type.
- Enter Double Room Standard Garden View in the Price description.
- Select OK to save the price code.
|
|
|
The Code Combination for the Price code must be the same as the Code Combination for the Service types. |
|
|
The Standard Double room price code is now visible.
To specify the price calculation for this room type:
- Right click on Double Room Standard Garden View.
- Select Properties.
The Price code (Purchase) window will open.
- Select Unit in the Calculation type field.
|
|
|
The calculation type can vary dependant on the agreement. |
|
|
- Select OK to save.
The starting date of the season is displayed but the end date is not visible, (as discussed earlier in the Create a Sales Price section of this document).
Step-by-Step: Display Season Start and End Dates
The starting date of the season is displayed but the end date is not visible. This is confusing as the end user cannot tell when the season ends.
To display the seasons end date:
- Right click on GNDHBLUHOR/ASE/Y11
- Select Design.
- Select Seasons.
- Select All season terms.
Navigate to the price chart and the season start and end dates will now be visible
- Select the + left from GNDHBLUHOR/ASE/Y11.
- Select the + left from Main price chart.
- Select the + left from Standard Double room.
.
BEFOREAFTER
Enter Purchase Prices in the Season Chart
Discussion
Now that the Season Charts have been created, the Purchase prices must be entered indicating the purchase price for a standard double room in the Blue Horizons Garden resort for the selected season.
|
In the illustrated example only one season has been setup 1st November 2012 to 31st October 2013. It is however, still necessary to enter a season price otherwise it will not be possible to book this room in the booking system. |
|
|
- Right click on the season.
- Select Create New Price.
The Saison code / Prices (Sale) window will open.
- Select Basic price in the Basis field.
- Enter 78 (*the purchase price) in the *Amount field.
- Select Basic price in the Product type field.
|
|
|
The Product type field is used to define cancellation conditions, commission paid to a travel agency etc. For example a travel agency may receive 5% commission on flights and 10% commission on hotel rooms. |
|
|
- Select OK to save the new price.
The price is now visible on the right side of the screen. The purchase price chart is now created.
Create a Sales Price and Season Chart
Discussion
A Sales Price chart will now be created. In the One Instance approach Sales Price charts will reside within the POS Catalogue. As the POS folder structure already references the Tour Operator and Year, for example Apollo Sweden 2010/11 (ASE2010/11), there is no need to reference this information in the Sales Price Chart title.
|
|
|
|
Once a Purchase Price chart has been created it is possible to make a copy and paste it into the Sales Price chart where it can be edited. |
|
|
|
|
|
|
|
|
Please note, if the Booking Ability field in the Booking Code is set to Bookable the system will allow the service to be booked irrespective of whether sales and purchase prices have been set up. This is extremely dangerous as the service could effectively be sold free of charge. |
|
|
To create a Sales Price chart:
Step-by-Step: Creating a Sales Price Chart
- Select Travel>Selling Prices. Alternatively select the icon.
The Selling Prices menu is displayed.
- Select BEWO12/13> The Americas > Caribbean .
- Right click on the Grenada folder.
- Select Create new price chart.
The Price Chart (Sale) screen will open.
|
|
|
The relevant POS catalogue appears in the Catalog field. |
|
|
- Enter GNDHBLUHOR/ ASE/Y11 in the Name field.
The Sales Price Chart naming convention is as follows:
G D H B L U H O R / A S E / Y 1 1
Booking CodePOS Season & Year
Alphanumeric |
Code |
Examples |
|
1-10 |
Booking Code |
SSHHMOVPIC - Movenpick Sharm el Sheikh |
|
11 |
/ |
|
|
12-14 |
POS |
related point of sale |
|
15 |
/ |
|
|
16 |
Season |
*Y - |
*Year |
17-19 |
Year |
11 - 2011 |
- Select Stay related in the Price calculation field.
- Select Price chart enable in all catalogues.
|
The option selected in the Price Calculation field determines the price a customer is charged. |
|
|
As pricing is season dependent before any prices can be entered into DaVinci a Season Chart must be created and the dates for each season defined. To create the Season Chart:
- Select the button to the right of the Season Chart field.
The Season Dates screen will be displayed:
- Select the BEWO12/13catalogue in the Catalog field.
- Select Sales under Season chart.
- Select New on the left side.
The Season Chart screen will be displayed.
- Enter GNDHBLUHOR/ASE/Y11 in the Description field.
|
|
|
The Season Chart name entered in the Description field should have the same name as that used for the Booking Code. |
|
|
- Ensure Sales is selected in the Permitted field.
|
|
|
Purchase + Sales: the price chart is valid for Sales and Purchase price charts. |
|
|
- Select OK to save the Season Chart.
The GNDHBLUHOR/ASE/Y11 Season Chart is now visible.
- Select GNDHBLUHOR/ASE/Y11
- Select New on the right side.
The GNDHBLUHOR/ASE/Y11 is now visible.
The Season Period screen will open.
The Season Period screen is used to define a season's from date and to date.
- Enter A in the Description field.
- Enter A in the Season code field.
|
|
|
The same character in the Description and Season code fields is used to identify the seasons. The coding structure has not yet been defined. |
|
|
- Enter 01.11.2012 in the Date from field.
- Enter 31.10.2013 in the till field.
- Select OK to save the period.
The Season Date is now visible on the right side of the screen.
- Select OK to save the Season Chart.
- Select the drop down box to the right of the Season Chart field.
- Double click on the GNDHBLUHOR/ASE/Y11 Season Chart.
- Select OK to save the Sales price chart.
Price chartThe Sales price chart is now visible on the left side of the screen.
New price codes will now be created. This is necessary in order to view the seasons.
- Select the + to the left of the price chart.
- Right click on Main price chart.
- Select Create New Price code.
- The Price code (Sale) screen will be displayed.
Ensure the following are selected:
- Basis: (Calculation): Night
Basis: (Calculation):
Night: if the calculation is per night.
Once: if there is one price for the entire stay, for example a tour. - Calculation type: Participants
|
|
|
Select Participants in the Calculation type field to calculate the sales price on a per person basis. |
|
|
Price Charts always relate to a certain room type. It is necessary to define which type of room at the Blue Horizons Garden Resort hotel this Price Chart applies to. In this example a standard double room (DS20) will be selected:
- Select the drop down box in the Code combination field.
- Select No catalog assignment > Hotel > Room Types folder.
- Select the DS20 room type.
- Enter Double Room Standard Garden View in the Price description.
- Select OK to save the price code.
|
|
|
The Code Combination for the Price code must be the same as the Code Combination for the Service types. |
|
|
The Standard Double room price code is now visible.
To display the seasons end date:
- Right click on GNDHBLUHOR/ASE/Y11
- Select Design.
- Select Seasons.
- Select All season terms.
- Open GNDHBLUHOR/ASE/Y11
- Open the Main price chart.
- Open the Standard Double room.
The season end date is now visible on the right side of the screen. The Purchase price for this season now needs to be entered.
Enter Sales Prices in the Season Chart
Discussion
Now that the Season Charts have been created, the Sales price must be entered indicating the sales price for a standard double room in the Blue Horizons Garden resort for the selected season.
|
In the illustrated example only one season has been setup 1st November 2012 to 31st October 2013. It is however, still necessary to enter a season price otherwise it will not be possible to book this room in the booking system. |
|
|
- Right click on the season.
- Select Create New Price.
The Saison code / Prices (Sale) window will open.
- Select Basic price in the Basis field.
- Enter 178 (*the selling price) in the *Amount field.
- Select Basic price in the Product type field.
|
|
|
The Product type field is used to define cancellation conditions, commission paid to a travel agency etc. For example a travel agency may receive 5% commission on flights and 10% commission on hotel rooms. |
|
|
- Select OK to save the new price.
The price is now visible on the right side of the screen. The Sales price chart is now created.
|
|
|
A Season Chart and Price Chart must be stored in the same catalogue otherwise they cannot be linked. |
|
|
Attach a Sales/Purchase Price Chart to a Booking Code
Discussion
The Sales and Purchase Price charts have been created they now need to be attached to the Blue Horizons Resort hotel booking code. To attach the Sales/Purchase charts follow these steps:
Step-by-Step: Attaching a Sales price chart and a Purchase price chart to the Booking Code.
The Sales and Purchase price charts are attached to the booking code located in the master catalogue. To access the booking code:
- Select Travel>Services.
- Select Master > The Americas > Caribbean > Grenada
- Open the Blue Horizons Garden Resort Booking Code.
- Select the Booking Code tab.
To attach the Sales Price Chart to the Booking Code:
- Select BEWO12/13from the Catalog field.
- Click in the BEWO12/13row in the Sales column.
- Select BEWO12/13> The Americas > Caribbean > Grenada
- Select GNDHBLUHOR/ASE/Y11
To attach the Purchase Price Chart to the Booking Code;
- Click in the BEWO12/13row in the Purchase Price field.
- Select Production&Procurement > The Americas > Caribbean > Grenada > Blue Horizons Garden Resort > BEWO12/13>
- Select GNDHBLUHOR/ASE/Y11
|
|
|
Once sales prices and allotments have been assigned the booking ability field is updated to Bookable to ensure this service can be booked through the booking front end. |
|
|
Now the Purchase and Sales prices have been attached to the booking code this hotel is bookable.
- Select Bookable in the Booking Ability field.
Currency
Discussion
The local currency is normally the default currency of the DaVinci database. Hotel contracts are normally in the currency of the supplier or in US dollars. To change the currency of a price chart.
- Right Click on the Main Price Chart of a booking code.
- Select Properties.
The Price Subchart screen is displayed:
- Select the required currency from the SP Currency field.
- Select OK.
The Main Price Chart displays the selected currency.
Exercise 5
Each student will create a Season Chart, Sales Price and Purchase Price Charts.- Create four seasons as follows:
Season one:01 Jan 2012 to 31 Mar 2012
Season two: 01 April 2012 to 30 Jun 2012
Season three: 01 Jul 2012 to 30 Sep 2012
Season four:01 Oct 2012 to 31 Dec 2012
With reference to the table below:
- Create Sales and Purchase Price Charts for the relevant hotel.
|
Destination and IATA |
Hotel name and address |
Sales Price |
Purchase Price |
Student 1 |
Bahama's (NAS) |
Compass Point |
€170 per night |
€100 per night |
Student 2 |
Barbados (BGI) |
Tamarind Cove |
€250 per night |
€175 per night |
Student 3 |
St. Lucia (SLU) |
Coco Palm |
€175 per night |
€110 per night |
Student 4 |
St. Martin (SXM) |
Divi Little Bay |
€290 per night |
€220 per night |
Student 5 |
Jamaica |
Coyaba Beach Resort |
€250 per night |
€175 per night |
Student 6 |
Antigua |
Blue Waters |
€290 per night |
€220 per night |
Student 7 |
Suriname (PBM) |
Royal Torarica |
€175 per night |
€110 per night |
Student 8 |
Tobago |
Blue Waters Inn |
€170 per night |
€100 per night |
Exercise 6
In Exercise 1 booking codes for the following hotels were created:
Student |
Hotel Details |
Room type |
Student 1 |
Hotel Palmtree Hill |
BS |
Student 2 |
Hotel Coconut Grove |
BD |
Student 3 |
Coyaba Beach Resort |
BE |
Student 4 |
Calabash Hotel and Villas |
BT |
Student 5 |
Maca Bana Villa |
VE |
Student 6 |
Sandals Coyaba Beach |
VC |
Student 7 |
Grand Braco Resort and Spa |
VU |
Student 8 |
Coco Palm |
VO |
- Assign the Room Type shown in the table above to the booking code.
- Create an Allotment from 1 Jan 2012 to 31 Dec 2012.
- Create the following 3 Season Charts:
Season one:01 Jan 2012 to 30 Jun 2012
Season two: 01 Jul 2012 to 30 Sep 2012
Season three: 01 Oct 2012 to 31 Dec 2012
- Create Sales and Purchase Price Charts.
- Create a booking for the relevant hotel in Genesis.